From milekz@gmail.com Mon Apr 27 18:35:58 2015 From: milek To: lms@lists.lms.org.pl Subject: Re: [lms] dokumenty - smarty Date: Mon, 27 Apr 2015 13:34:38 +0200 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6798622620225472545==" --===============6798622620225472545== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Jak user b=C4=99dzie mia=C5=82 jak=C4=85=C5=9B taryf=C4=99 przeterminowan=C4= =85 to zapytanie zwr=C3=B3ci =C5=BA=C5=82e warto=C5=9Bci=C2=A0 -------- Original message -------- From: Marcin =20 Date: 27.04.2015 13:11 (GMT+01:00)=20 To: lista u=C5=BCytkownik=C3=B3w LMS =20 Subject: Re: [lms] dokumenty - smarty=20 -------- Original message -------- From: Marcin =20 Date: 27.04.2015 13:11 (GMT+01:00)=20 To: lista u=C5=BCytkownik=C3=B3w LMS =20 Subject: Re: [lms] dokumenty - smarty=20 i znowu odpowiadam sobie sam. ale by by=C5=82o dla potomnych. zrobi=C5=82em to w php zamiast w smarty. w engine.php doda=C5=82em #v+ if($customernodes) foreach($customernodes as $idx =3D> $row) { $customernodes[$idx]['net'] =3D $DB->GetRow('SELECT *, inet_ntoa(addr= ess) AS ip FROM networks WHERE address =3D (inet_aton(mask) & ?)', array($row= ['ipaddr'])); foreach ($assignments as $valass){ foreach ($valass['nodes'] as $lit =3D> $valnod) { if ($valnod['id'] =3D=3D $row['id']){ $customernodes[$idx]['down'] =3D floor($valass['downceil'= ]/1024); $customernodes[$idx]['uplo'] =3D floor($valass['upceil']/= 1024); } =20 } } } #v- zapewne istnieje =C5=82atwiejszy spos=C3=B3b ale moja wiedza z php jest zniko= ma, wi=C4=99c zrobi=C5=82em jak umia=C5=82em :) wa=C5=BCne =C5=BCe dzia=C5=82= a i jest =C5=82atwo dost=C4=99pne w smarty. W dniu 24 kwietnia 2015 19:55 u=C5=BCytkownik Marcin na= pisa=C5=82: Witam Podpowiedzcie jak w szablonie dokumentu, smarty, wyci=C4=85gn=C4=85=C4=87 pr= =C4=99dko=C5=9B=C4=87 komputera. Na umowi=C4=99 wypisuj=C4=99 hosty i chcia=C5=82bym obok niego wypisa=C4=87 p= r=C4=99dko=C5=9Bci. problem w tym, =C5=BCe hosty s=C4=85 przekazywane w tablicy customernodes a p= r=C4=99dko=C5=9B=C4=87 jest w tablicy assignments. $assignments Smarty_Variable Object (3) ->value =3D Array (2) 0 =3D> Array (29) id =3D> "8310" tariffid =3D> "516" customerid =3D> "2856" upceil =3D> "2196" downceil =3D> "24196" nodes =3D> Array (1) 0 =3D> Array (2) name =3D> "nazwaklienta" id =3D> "5817" .... $customernodes Smarty_Variable Object (3) ->value =3D Array (1) 0 =3D> Array (19) id =3D> "5817" name =3D> "nazwaklienta" ip =3D> "192.192.192.192" ownerid =3D> "2856" ... w templatce mam taki kod: #v+
6. Urz=C4=85dzenia Abonenckie przeznaczone do instalacji u= Abonenta {section name=3Dcustomernodes loop=3D$customernodes} {/section}
{trans("IP Address:")} {trans("Login:")} {trans("Password:")}
{$customernodes[customernodes].ip} {$customernodes[customernodes].name} {$customernodes[customernodes].passwd}
#v- i do tego, do ka=C5=BCdego komputera chc=C4=99 doda=C4=87 pr=C4=99dko=C5=9B= =C4=87 z assignments. poprosz=C4=99 o wskaz=C3=B3wk=C4=99 jak to osi=C4=85gn=C4=85=C4=87 w smarty? --=20 Pozdrawiam Marcin / nicraM --=20 Pozdrawiam Marcin / nicraM --===============6798622620225472545== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9VVRGLTgiPjwvaGVhZD48Ym9keSA+PGRpdj5KYWsgdXNlciBixJlkemll IG1pYcWCIGpha8SFxZsgdGFyeWbEmSBwcnpldGVybWlub3dhbsSFIHRvIHphcHl0YW5pZSB6d3LD s2NpIMW6xYJlIHdhcnRvxZtjaSZuYnNwOzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGRpdiBz dHlsZT0iZm9udC1zaXplOjlweDtjb2xvcjojNTc1NzU3Ij48YnI+PC9kaXY+PC9kaXY+PGRpdj48 L2Rpdj48YnI+PGJyPi0tLS0tLS0tIE9yaWdpbmFsIG1lc3NhZ2UgLS0tLS0tLS08YnI+RnJvbTog TWFyY2luICZsdDttYXJjaW5AbmljcmFtLm5ldCZndDsgPGJyPkRhdGU6IDI3LjA0LjIwMTUgIDEz OjExICAoR01UKzAxOjAwKSA8YnI+VG86IGxpc3RhIHXFvHl0a293bmlrw7N3IExNUyAmbHQ7bG1z QGxpc3RzLmxtcy5vcmcucGwmZ3Q7IDxicj5TdWJqZWN0OiBSZTogW2xtc10gZG9rdW1lbnR5IC0g c21hcnR5IDxicj48YnI+PGRpdiBzdHlsZT0iZm9udC1zaXplOjEwMCU7dGV4dC1hbGlnbjpsZWZ0 O2NvbG9yOiMwMDAwMDAiPi0tLS0tLS0tIE9yaWdpbmFsIG1lc3NhZ2UgLS0tLS0tLS08YnI+RnJv bTogTWFyY2luICZsdDttYXJjaW5AbmljcmFtLm5ldCZndDsgPGJyPkRhdGU6IDI3LjA0LjIwMTUg IDEzOjExICAoR01UKzAxOjAwKSA8YnI+VG86IGxpc3RhIHXFvHl0a293bmlrw7N3IExNUyAmbHQ7 bG1zQGxpc3RzLmxtcy5vcmcucGwmZ3Q7IDxicj5TdWJqZWN0OiBSZTogW2xtc10gZG9rdW1lbnR5 IC0gc21hcnR5IDxicj48YnI+PC9kaXY+PGRpdiBkaXI9Imx0ciI+PGRpdj48ZGl2PjxkaXY+PGRp dj5pIHpub3d1IG9kcG93aWFkYW0gc29iaWUgc2FtLiBhbGUgYnkgYnnFgm8gZGxhIHBvdG9tbnlj aC48YnI+PC9kaXY+enJvYmnFgmVtIHRvIHcgcGhwIHphbWlhc3QgdyBzbWFydHkuIHcgZW5naW5l LnBocCBkb2RhxYJlbTxicj48YnI+PC9kaXY+I3YrPGJyPmlmKCRjdXN0b21lcm5vZGVzKTxicj4m bmJzcDsmbmJzcDsmbmJzcDsgZm9yZWFjaCgkY3VzdG9tZXJub2RlcyBhcyAkaWR4ID0mZ3Q7ICRy b3cpPGJyPiZuYnNwOyZuYnNwOyZuYnNwOyB7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsm bmJzcDsmbmJzcDsgJGN1c3RvbWVybm9kZXNbJGlkeF1bJ25ldCddID0gJERCLSZndDtHZXRSb3co J1NFTEVDVCAqLCBpbmV0X250b2EoYWRkcmVzcykgQVMgaXAgRlJPTSBuZXR3b3JrcyBXSEVSRSBh ZGRyZXNzID0gKGluZXRfYXRvbihtYXNrKSAmYW1wOyA/KScsIGFycmF5KCRyb3dbJ2lwYWRkcidd KSk7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgZm9yZWFjaCAoJGFz c2lnbm1lbnRzIGFzICR2YWxhc3Mpezxicj4mbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7 Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyBmb3JlYWNoICgkdmFsYXNzWydub2RlcyddIGFzICRs aXQgPSZndDsgJHZhbG5vZCkgezxicj4mbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5i c3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgaWYgKCR2YWxub2RbJ2lk J10gPT0gJHJvd1snaWQnXSl7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJz cDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJz cDsgJGN1c3RvbWVybm9kZXNbJGlkeF1bJ2Rvd24nXSA9IGZsb29yKCR2YWxhc3NbJ2Rvd25jZWls J10vMTAyNCk7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7 Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJGN1c3Rv bWVybm9kZXNbJGlkeF1bJ3VwbG8nXSA9IGZsb29yKCR2YWxhc3NbJ3VwY2VpbCddLzEwMjQpOzxi cj4mbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNw OyAmbmJzcDsmbmJzcDsmbmJzcDsgfSZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJz cDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyA8YnI+Jm5ic3A7Jm5ic3A7 Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgfTxicj4mbmJzcDsm bmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7IH08YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7IH08 YnI+PC9kaXY+I3YtPGJyPjxicj48L2Rpdj56YXBld25lIGlzdG5pZWplIMWCYXR3aWVqc3p5IHNw b3PDs2IgYWxlIG1vamEgd2llZHphIHogcGhwIGplc3Qgem5pa29tYSwgd2nEmWMgenJvYmnFgmVt IGphayB1bWlhxYJlbSA6KSB3YcW8bmUgxbxlIGR6aWHFgmEgaSBqZXN0IMWCYXR3byBkb3N0xJlw bmUgdyBzbWFydHkuPGJyPjwvZGl2PjxkaXYgY2xhc3M9ImdtYWlsX2V4dHJhIj48YnI+PGRpdiBj bGFzcz0iZ21haWxfcXVvdGUiPlcgZG5pdSAyNCBrd2lldG5pYSAyMDE1IDE5OjU1IHXFvHl0a293 bmlrIE1hcmNpbiA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzptYXJjaW5Abmlj cmFtLm5ldCIgdGFyZ2V0PSJfYmxhbmsiPm1hcmNpbkBuaWNyYW0ubmV0PC9hPiZndDs8L3NwYW4+ IG5hcGlzYcWCOjxicj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJn aW46MCAwIDAgLjhleDtib3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4 Ij48ZGl2IGRpcj0ibHRyIj48ZGl2PjxkaXY+PGRpdj5XaXRhbTxicj48L2Rpdj5Qb2Rwb3dpZWR6 Y2llIGphayB3IHN6YWJsb25pZSBkb2t1bWVudHUsIHNtYXJ0eSwgd3ljacSFZ27EhcSHIHByxJlk a2/Fm8SHIGtvbXB1dGVyYS48YnI+PC9kaXY+TmEgdW1vd2nEmSB3eXBpc3VqxJkgaG9zdHkgaSBj aGNpYcWCYnltIG9ib2sgbmllZ28gd3lwaXNhxIcgcHLEmWRrb8WbY2kuPGJyPjwvZGl2PnByb2Js ZW0gdyB0eW0sIMW8ZSBob3N0eSBzxIUgcHJ6ZWthenl3YW5lIHcgdGFibGljeSBjdXN0b21lcm5v ZGVzIGEgcHLEmWRrb8WbxIcgamVzdCB3IHRhYmxpY3kgYXNzaWdubWVudHMuPGJyIGNsZWFyPSJh bGwiPjxkaXY+PGRpdj48ZGl2PjxkaXY+PGJyPiRhc3NpZ25tZW50cyAmbmJzcDsmbmJzcDsmbmJz cDsgU21hcnR5X1ZhcmlhYmxlIE9iamVjdCAoMyk8YnI+LSZndDt2YWx1ZSA9IEFycmF5ICgyKTxi cj4mbmJzcDsgMCA9Jmd0OyBBcnJheSAoMjkpPGJyPiZuYnNwOyZuYnNwOyZuYnNwOyBpZCA9Jmd0 OyAiODMxMCI8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7IHRhcmlmZmlkID0mZ3Q7ICI1MTYiPGJyPiZu YnNwOyZuYnNwOyZuYnNwOyBjdXN0b21lcmlkID0mZ3Q7ICIyODU2Ijxicj4mbmJzcDsmbmJzcDsm bmJzcDsgdXBjZWlsID0mZ3Q7ICIyMTk2Ijxicj4mbmJzcDsmbmJzcDsmbmJzcDsgZG93bmNlaWwg PSZndDsgIjI0MTk2Ijxicj4mbmJzcDsmbmJzcDsmbmJzcDsgbm9kZXMgPSZndDsgQXJyYXkgKDEp PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyAwID0mZ3Q7IEFycmF5ICgyKTxicj4m bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgbmFtZSA9Jmd0OyAibmF6 d2FrbGllbnRhIjxicj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsg aWQgPSZndDsgIjU4MTciPGJyPiZuYnNwOy4uLi48YnI+PGJyPiRjdXN0b21lcm5vZGVzICZuYnNw OyZuYnNwOyZuYnNwOyBTbWFydHlfVmFyaWFibGUgT2JqZWN0ICgzKTxicj4tJmd0O3ZhbHVlID0g QXJyYXkgKDEpPGJyPiZuYnNwOyAwID0mZ3Q7IEFycmF5ICgxOSk8YnI+Jm5ic3A7Jm5ic3A7Jm5i c3A7IGlkID0mZ3Q7ICI1ODE3Ijxicj4mbmJzcDsmbmJzcDsmbmJzcDsgbmFtZSA9Jmd0OyAibmF6 d2FrbGllbnRhIjxicj4mbmJzcDsmbmJzcDsmbmJzcDsgaXAgPSZndDsgIjE5Mi4xOTIuMTkyLjE5 MiI8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7IG93bmVyaWQgPSZndDsgIjI4NTYiPGJyPi4uLjxicj48 YnI+PGJyPjwvZGl2PjxkaXY+dyB0ZW1wbGF0Y2UgbWFtIHRha2kga29kOjxicj48L2Rpdj48ZGl2 PiN2Kzxicj4mbHQ7ZGl2IGlkPSJ1cnphZHplbmlhIiZndDs8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7 ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJmx0O3RoZWFkJmd0OzYuIFVy esSFZHplbmlhIEFib25lbmNraWUgcHJ6ZXpuYWN6b25lIGRvIGluc3RhbGFjamkgdSBBYm9uZW50 YSZsdDsvdGhlYWQmZ3Q7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsg Jm5ic3A7Jm5ic3A7Jm5ic3A7ICZsdDt0YWJsZSBjZWxscGFkZGluZz0iMyIgY2VsbHNwYWNpbmc9 IjAiIGJvcmRlcj0iMSImZ3Q7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJz cDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbHQ7dHImZ3Q7PGJyPiZu YnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZu YnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJmx0O3RkJmd0O3t0cmFucygiSVAg QWRkcmVzczoiKX0mbHQ7L3RkJmd0Ozxicj4mbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7 Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7 Jm5ic3A7ICZsdDt0ZCZndDt7dHJhbnMoIkxvZ2luOiIpfSZsdDsvdGQmZ3Q7PGJyPiZuYnNwOyZu YnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZu YnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJmx0O3RkJmd0O3t0cmFucygiUGFzc3dvcmQ6 Iil9Jmx0Oy90ZCZndDs8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAm bmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZsdDsvdHImZ3Q7PGJyPiZuYnNw OyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNw OyZuYnNwOyZuYnNwOyB7c2VjdGlvbiBuYW1lPWN1c3RvbWVybm9kZXMgbG9vcD0kY3VzdG9tZXJu b2Rlc308YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJz cDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZsdDt0ciZndDs8YnI+Jm5ic3A7Jm5ic3A7Jm5i c3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5i c3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbHQ7dGQmZ3Q7eyRjdXN0b21lcm5vZGVzW2N1c3RvbWVy bm9kZXNdLmlwfSZsdDsvdGQmZ3Q7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsm bmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsm bmJzcDsgJmx0O3RkJmd0O3skY3VzdG9tZXJub2Rlc1tjdXN0b21lcm5vZGVzXS5uYW1lfSZsdDsv dGQmZ3Q7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5i c3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJmx0O3RkJmd0 O3skY3VzdG9tZXJub2Rlc1tjdXN0b21lcm5vZGVzXS5wYXNzd2R9Jmx0Oy90ZCZndDs8YnI+Jm5i c3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5i c3A7Jm5ic3A7Jm5ic3A7ICZsdDsvdHImZ3Q7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsm bmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7Jm5ic3A7ICZuYnNwOyZuYnNwOyZuYnNwOyB7L3NlY3Rp b259PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsmbmJzcDsgJm5ic3A7Jm5ic3A7 Jm5ic3A7ICZsdDsvdGFibGUmZ3Q7PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJzcDsm bmJzcDsgJmx0Oy9kaXYmZ3Q7PGJyPjwvZGl2PjxkaXY+I3YtPGJyPjxicj48L2Rpdj48ZGl2Pmkg ZG8gdGVnbywgZG8ga2HFvGRlZ28ga29tcHV0ZXJhIGNoY8SZIGRvZGHEhyBwcsSZZGtvxZvEhyB6 IGFzc2lnbm1lbnRzLjxicj48L2Rpdj48ZGl2PnBvcHJvc3rEmSBvIHdza2F6w7N3a8SZIGphayB0 byBvc2nEhWduxIXEhyB3IHNtYXJ0eT88c3BhbiBjbGFzcz0iSE9FblpiIj48Zm9udCBjb2xvcj0i Izg4ODg4OCI+PGJyPjwvZm9udD48L3NwYW4+PC9kaXY+PHNwYW4gY2xhc3M9IkhPRW5aYiI+PGZv bnQgY29sb3I9IiM4ODg4ODgiPjxkaXY+PGJyPjxicj48YnI+PGJyPi0tIDxicj48ZGl2PlBvemRy YXdpYW08YnI+TWFyY2luIC8gbmljcmFNPGJyPjwvZGl2Pgo8L2Rpdj48L2ZvbnQ+PC9zcGFuPjwv ZGl2PjwvZGl2PjwvZGl2PjwvZGl2Pgo8L2Jsb2NrcXVvdGU+PC9kaXY+PGJyPjxiciBjbGVhcj0i YWxsIj48YnI+LS0gPGJyPjxkaXYgY2xhc3M9ImdtYWlsX3NpZ25hdHVyZSI+UG96ZHJhd2lhbTxi cj5NYXJjaW4gLyBuaWNyYU08YnI+PC9kaXY+CjwvZGl2Pgo8L2JvZHk+ --===============6798622620225472545==-- From marcin@nicram.net Mon Apr 27 18:48:14 2015 From: Marcin To: lms@lists.lms.org.pl Subject: Re: [lms] dokumenty - smarty Date: Mon, 27 Apr 2015 18:48:11 +0200 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0120100457751410998==" --===============0120100457751410998== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable W dniu 27 kwietnia 2015 13:34 u=C5=BCytkownik milek napi= sa=C5=82: > Jak user b=C4=99dzie mia=C5=82 jak=C4=85=C5=9B taryf=C4=99 przeterminowan= =C4=85 to zapytanie zwr=C3=B3ci =C5=BA=C5=82e > warto=C5=9Bci > > niby czemu zwr=C3=B3ci z=C5=82e warto=C5=9Bci jak wyci=C4=85ga tylko pr=C4=99= dko=C5=9Bci a nie patrzy w daty zobowi=C4=85zywania? i znowu odpowiadam sobie sam. ale by by=C5=82o dla potomnych. > zrobi=C5=82em to w php zamiast w smarty. w engine.php doda=C5=82em > > #v+ > if($customernodes) > foreach($customernodes as $idx =3D> $row) > { > $customernodes[$idx]['net'] =3D $DB->GetRow('SELECT *, > inet_ntoa(address) AS ip FROM networks WHERE address =3D (inet_aton(mask) & > ?)', array($row['ipaddr'])); > foreach ($assignments as $valass){ > foreach ($valass['nodes'] as $lit =3D> $valnod) { > if ($valnod['id'] =3D=3D $row['id']){ > $customernodes[$idx]['down'] =3D > floor($valass['downceil']/1024); > $customernodes[$idx]['uplo'] =3D > floor($valass['upceil']/1024); > } > } > } > } > #v- > > zapewne istnieje =C5=82atwiejszy spos=C3=B3b ale moja wiedza z php jest zni= koma, > wi=C4=99c zrobi=C5=82em jak umia=C5=82em :) wa=C5=BCne =C5=BCe dzia=C5=82a = i jest =C5=82atwo dost=C4=99pne w smarty. > > W dniu 24 kwietnia 2015 19:55 u=C5=BCytkownik Marcin > napisa=C5=82: > >> Witam >> Podpowiedzcie jak w szablonie dokumentu, smarty, wyci=C4=85gn=C4=85=C4=87 = pr=C4=99dko=C5=9B=C4=87 >> komputera. >> Na umowi=C4=99 wypisuj=C4=99 hosty i chcia=C5=82bym obok niego wypisa=C4= =87 pr=C4=99dko=C5=9Bci. >> problem w tym, =C5=BCe hosty s=C4=85 przekazywane w tablicy customernodes a >> pr=C4=99dko=C5=9B=C4=87 jest w tablicy assignments. >> >> $assignments Smarty_Variable Object (3) >> ->value =3D Array (2) >> 0 =3D> Array (29) >> id =3D> "8310" >> tariffid =3D> "516" >> customerid =3D> "2856" >> upceil =3D> "2196" >> downceil =3D> "24196" >> nodes =3D> Array (1) >> 0 =3D> Array (2) >> name =3D> "nazwaklienta" >> id =3D> "5817" >> .... >> >> $customernodes Smarty_Variable Object (3) >> ->value =3D Array (1) >> 0 =3D> Array (19) >> id =3D> "5817" >> name =3D> "nazwaklienta" >> ip =3D> "192.192.192.192" >> ownerid =3D> "2856" >> ... >> >> >> w templatce mam taki kod: >> #v+ >>
>> 6. Urz=C4=85dzenia Abonenckie przeznaczone do instalacj= i u >> Abonenta >> >> >> >> >> >> >> {section name=3Dcustomernodes loop=3D$customernodes} >> >> >> >> >> >> {/section} >>
{trans("IP Address:")}{trans("Login:")}{trans("Password:")}
{$customernodes[customernodes].ip}{$customernodes[customernodes].name}{$customernodes[customernodes].passwd}
>>
>> #v- >> >> i do tego, do ka=C5=BCdego komputera chc=C4=99 doda=C4=87 pr=C4=99dko=C5= =9B=C4=87 z assignments. >> poprosz=C4=99 o wskaz=C3=B3wk=C4=99 jak to osi=C4=85gn=C4=85=C4=87 w smart= y? >> >> >> >> >> -- >> Pozdrawiam >> Marcin / nicraM >> > > > > -- > Pozdrawiam > Marcin / nicraM > > _______________________________________________ > lms mailing list > lms(a)lists.lms.org.pl > http://lists.lms.org.pl/mailman/listinfo/lms > > --=20 Pozdrawiam Marcin / nicraM --===============0120100457751410998== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGRpdiBkaXI9Imx0ciI+PGJyPjxkaXYgY2xhc3M9ImdtYWlsX2V4dHJhIj48YnI+PGRpdiBjbGFz cz0iZ21haWxfcXVvdGUiPlcgZG5pdSAyNyBrd2lldG5pYSAyMDE1IDEzOjM0IHXFvHl0a293bmlr IG1pbGVrIDxzcGFuIGRpcj0ibHRyIj4mbHQ7PGEgaHJlZj0ibWFpbHRvOm1pbGVrekBnbWFpbC5j b20iIHRhcmdldD0iX2JsYW5rIj5taWxla3pAZ21haWwuY29tPC9hPiZndDs8L3NwYW4+IG5hcGlz YcWCOjxicj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MCAw IDAgLjhleDtib3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4Ij48ZGl2 PjxkaXY+SmFrIHVzZXIgYsSZZHppZSBtaWHFgiBqYWvEhcWbIHRhcnlmxJkgcHJ6ZXRlcm1pbm93 YW7EhSB0byB6YXB5dGFuaWUgendyw7NjaSDFusWCZSB3YXJ0b8WbY2nCoDwvZGl2PjxkaXY+PGJy PjwvZGl2PjwvZGl2PjwvYmxvY2txdW90ZT48ZGl2Pjxicj48L2Rpdj48ZGl2Pm5pYnkgY3plbXUg endyw7NjaSB6xYJlIHdhcnRvxZtjaSBqYWsgd3ljacSFZ2EgdHlsa28gcHLEmWRrb8WbY2kgYSBu aWUgcGF0cnp5IHcgZGF0eSB6b2Jvd2nEhXp5d2FuaWE/IDxicj48L2Rpdj48ZGl2IHN0eWxlPSJm b250LXNpemU6MTAwJTt0ZXh0LWFsaWduOmxlZnQ7Y29sb3I6IzAwMDAwMCI+PGJyPjwvZGl2Pjxi bG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAgMCAuOGV4O2Jv cmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPjxkaXY+PGRpdj48ZGl2 IGNsYXNzPSJoNSI+PGRpdiBkaXI9Imx0ciI+PGRpdj48ZGl2PjxkaXY+PGRpdj5pIHpub3d1IG9k cG93aWFkYW0gc29iaWUgc2FtLiBhbGUgYnkgYnnFgm8gZGxhIHBvdG9tbnljaC48YnI+PC9kaXY+ enJvYmnFgmVtIHRvIHcgcGhwIHphbWlhc3QgdyBzbWFydHkuIHcgZW5naW5lLnBocCBkb2RhxYJl bTxicj48YnI+PC9kaXY+I3YrPGJyPmlmKCRjdXN0b21lcm5vZGVzKTxicj7CoMKgwqAgZm9yZWFj aCgkY3VzdG9tZXJub2RlcyBhcyAkaWR4ID0mZ3Q7ICRyb3cpPGJyPsKgwqDCoCB7PGJyPsKgwqDC oCDCoMKgwqAgJGN1c3RvbWVybm9kZXNbJGlkeF1bJiMzOTtuZXQmIzM5O10gPSAkREItJmd0O0dl dFJvdygmIzM5O1NFTEVDVCAqLCBpbmV0X250b2EoYWRkcmVzcykgQVMgaXAgRlJPTSBuZXR3b3Jr cyBXSEVSRSBhZGRyZXNzID0gKGluZXRfYXRvbihtYXNrKSAmYW1wOyA/KSYjMzk7LCBhcnJheSgk cm93WyYjMzk7aXBhZGRyJiMzOTtdKSk7PGJyPsKgwqDCoCDCoMKgwqAgZm9yZWFjaCAoJGFzc2ln bm1lbnRzIGFzICR2YWxhc3Mpezxicj7CoMKgwqAgwqDCoMKgIMKgwqDCoCBmb3JlYWNoICgkdmFs YXNzWyYjMzk7bm9kZXMmIzM5O10gYXMgJGxpdCA9Jmd0OyAkdmFsbm9kKSB7PGJyPsKgwqDCoCDC oMKgwqAgwqDCoMKgIMKgwqDCoCBpZiAoJHZhbG5vZFsmIzM5O2lkJiMzOTtdID09ICRyb3dbJiMz OTtpZCYjMzk7XSl7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgJGN1c3Rv bWVybm9kZXNbJGlkeF1bJiMzOTtkb3duJiMzOTtdID0gZmxvb3IoJHZhbGFzc1smIzM5O2Rvd25j ZWlsJiMzOTtdLzEwMjQpOzxicj7CoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgICRj dXN0b21lcm5vZGVzWyRpZHhdWyYjMzk7dXBsbyYjMzk7XSA9IGZsb29yKCR2YWxhc3NbJiMzOTt1 cGNlaWwmIzM5O10vMTAyNCk7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCB9wqDCoMKg IMKgwqDCoCDCoMKgwqAgwqDCoMKgIDxicj7CoMKgwqAgwqDCoMKgIMKgwqDCoCB9PGJyPsKgwqDC oCDCoMKgwqAgfTxicj7CoMKgwqAgfTxicj48L2Rpdj4jdi08YnI+PGJyPjwvZGl2PnphcGV3bmUg aXN0bmllamUgxYJhdHdpZWpzenkgc3Bvc8OzYiBhbGUgbW9qYSB3aWVkemEgeiBwaHAgamVzdCB6 bmlrb21hLCB3acSZYyB6cm9iacWCZW0gamFrIHVtaWHFgmVtIDopIHdhxbxuZSDFvGUgZHppYcWC YSBpIGplc3QgxYJhdHdvIGRvc3TEmXBuZSB3IHNtYXJ0eS48YnI+PC9kaXY+PGRpdiBjbGFzcz0i Z21haWxfZXh0cmEiPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+VyBkbml1IDI0IGt3aWV0 bmlhIDIwMTUgMTk6NTUgdcW8eXRrb3duaWsgTWFyY2luIDxzcGFuIGRpcj0ibHRyIj4mbHQ7PGEg aHJlZj0ibWFpbHRvOm1hcmNpbkBuaWNyYW0ubmV0IiB0YXJnZXQ9Il9ibGFuayI+bWFyY2luQG5p Y3JhbS5uZXQ8L2E+Jmd0Ozwvc3Bhbj4gbmFwaXNhxYI6PGJyPjxibG9ja3F1b3RlIGNsYXNzPSJn bWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2Nj IHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPjxkaXYgZGlyPSJsdHIiPjxkaXY+PGRpdj48ZGl2Pldp dGFtPGJyPjwvZGl2PlBvZHBvd2llZHpjaWUgamFrIHcgc3phYmxvbmllIGRva3VtZW50dSwgc21h cnR5LCB3eWNpxIVnbsSFxIcgcHLEmWRrb8WbxIcga29tcHV0ZXJhLjxicj48L2Rpdj5OYSB1bW93 acSZIHd5cGlzdWrEmSBob3N0eSBpIGNoY2lhxYJieW0gb2JvayBuaWVnbyB3eXBpc2HEhyBwcsSZ ZGtvxZtjaS48YnI+PC9kaXY+cHJvYmxlbSB3IHR5bSwgxbxlIGhvc3R5IHPEhSBwcnpla2F6eXdh bmUgdyB0YWJsaWN5IGN1c3RvbWVybm9kZXMgYSBwcsSZZGtvxZvEhyBqZXN0IHcgdGFibGljeSBh c3NpZ25tZW50cy48YnIgY2xlYXI9ImFsbCI+PGRpdj48ZGl2PjxkaXY+PGRpdj48YnI+JGFzc2ln bm1lbnRzIMKgwqDCoCBTbWFydHlfVmFyaWFibGUgT2JqZWN0ICgzKTxicj4tJmd0O3ZhbHVlID0g QXJyYXkgKDIpPGJyPsKgIDAgPSZndDsgQXJyYXkgKDI5KTxicj7CoMKgwqAgaWQgPSZndDsgJnF1 b3Q7ODMxMCZxdW90Ozxicj7CoMKgwqAgdGFyaWZmaWQgPSZndDsgJnF1b3Q7NTE2JnF1b3Q7PGJy PsKgwqDCoCBjdXN0b21lcmlkID0mZ3Q7ICZxdW90OzI4NTYmcXVvdDs8YnI+wqDCoMKgIHVwY2Vp bCA9Jmd0OyAmcXVvdDsyMTk2JnF1b3Q7PGJyPsKgwqDCoCBkb3duY2VpbCA9Jmd0OyAmcXVvdDsy NDE5NiZxdW90Ozxicj7CoMKgwqAgbm9kZXMgPSZndDsgQXJyYXkgKDEpPGJyPsKgwqDCoMKgwqAg MCA9Jmd0OyBBcnJheSAoMik8YnI+wqDCoMKgwqDCoMKgwqAgbmFtZSA9Jmd0OyAmcXVvdDtuYXp3 YWtsaWVudGEmcXVvdDs8YnI+wqDCoMKgwqDCoMKgwqAgaWQgPSZndDsgJnF1b3Q7NTgxNyZxdW90 Ozxicj7CoC4uLi48YnI+PGJyPiRjdXN0b21lcm5vZGVzIMKgwqDCoCBTbWFydHlfVmFyaWFibGUg T2JqZWN0ICgzKTxicj4tJmd0O3ZhbHVlID0gQXJyYXkgKDEpPGJyPsKgIDAgPSZndDsgQXJyYXkg KDE5KTxicj7CoMKgwqAgaWQgPSZndDsgJnF1b3Q7NTgxNyZxdW90Ozxicj7CoMKgwqAgbmFtZSA9 Jmd0OyAmcXVvdDtuYXp3YWtsaWVudGEmcXVvdDs8YnI+wqDCoMKgIGlwID0mZ3Q7ICZxdW90OzE5 Mi4xOTIuMTkyLjE5MiZxdW90Ozxicj7CoMKgwqAgb3duZXJpZCA9Jmd0OyAmcXVvdDsyODU2JnF1 b3Q7PGJyPi4uLjxicj48YnI+PGJyPjwvZGl2PjxkaXY+dyB0ZW1wbGF0Y2UgbWFtIHRha2kga29k Ojxicj48L2Rpdj48ZGl2PiN2Kzxicj4mbHQ7ZGl2IGlkPSZxdW90O3VyemFkemVuaWEmcXVvdDsm Z3Q7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgICZsdDt0aGVhZCZndDs2LiBVcnrEhWR6ZW5pYSBB Ym9uZW5ja2llIHByemV6bmFjem9uZSBkbyBpbnN0YWxhY2ppIHUgQWJvbmVudGEmbHQ7L3RoZWFk Jmd0Ozxicj7CoMKgwqAgwqDCoMKgIMKgwqDCoCAmbHQ7dGFibGUgY2VsbHBhZGRpbmc9JnF1b3Q7 MyZxdW90OyBjZWxsc3BhY2luZz0mcXVvdDswJnF1b3Q7IGJvcmRlcj0mcXVvdDsxJnF1b3Q7Jmd0 Ozxicj7CoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgJmx0O3RyJmd0Ozxicj7CoMKgwqAgwqDC oMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgICZsdDt0ZCZndDt7dHJhbnMoJnF1b3Q7SVAgQWRkcmVz czomcXVvdDspfSZsdDsvdGQmZ3Q7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKg wqAgJmx0O3RkJmd0O3t0cmFucygmcXVvdDtMb2dpbjomcXVvdDspfSZsdDsvdGQmZ3Q7PGJyPsKg wqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgJmx0O3RkJmd0O3t0cmFucygmcXVvdDtQ YXNzd29yZDomcXVvdDspfSZsdDsvdGQmZ3Q7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDC oCAmbHQ7L3RyJmd0Ozxicj7CoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAge3NlY3Rpb24gbmFt ZT1jdXN0b21lcm5vZGVzIGxvb3A9JGN1c3RvbWVybm9kZXN9PGJyPsKgwqDCoCDCoMKgwqAgwqDC oMKgIMKgwqDCoCAmbHQ7dHImZ3Q7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKg wqAgJmx0O3RkJmd0O3skY3VzdG9tZXJub2Rlc1tjdXN0b21lcm5vZGVzXS5pcH0mbHQ7L3RkJmd0 Ozxicj7CoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgICZsdDt0ZCZndDt7JGN1c3Rv bWVybm9kZXNbY3VzdG9tZXJub2Rlc10ubmFtZX0mbHQ7L3RkJmd0Ozxicj7CoMKgwqAgwqDCoMKg IMKgwqDCoCDCoMKgwqAgwqDCoMKgICZsdDt0ZCZndDt7JGN1c3RvbWVybm9kZXNbY3VzdG9tZXJu b2Rlc10ucGFzc3dkfSZsdDsvdGQmZ3Q7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCAm bHQ7L3RyJmd0Ozxicj7CoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgey9zZWN0aW9ufTxicj7C oMKgwqAgwqDCoMKgIMKgwqDCoCAmbHQ7L3RhYmxlJmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDsv ZGl2Jmd0Ozxicj48L2Rpdj48ZGl2PiN2LTxicj48YnI+PC9kaXY+PGRpdj5pIGRvIHRlZ28sIGRv IGthxbxkZWdvIGtvbXB1dGVyYSBjaGPEmSBkb2RhxIcgcHLEmWRrb8WbxIcgeiBhc3NpZ25tZW50 cy48YnI+PC9kaXY+PGRpdj5wb3Byb3N6xJkgbyB3c2thesOzd2vEmSBqYWsgdG8gb3NpxIVnbsSF xIcgdyBzbWFydHk/PHNwYW4+PGZvbnQgY29sb3I9IiM4ODg4ODgiPjxicj48L2ZvbnQ+PC9zcGFu PjwvZGl2PjxzcGFuPjxmb250IGNvbG9yPSIjODg4ODg4Ij48ZGl2Pjxicj48YnI+PGJyPjxicj4t LSA8YnI+PGRpdj5Qb3pkcmF3aWFtPGJyPk1hcmNpbiAvIG5pY3JhTTxicj48L2Rpdj4KPC9kaXY+ PC9mb250Pjwvc3Bhbj48L2Rpdj48L2Rpdj48L2Rpdj48L2Rpdj4KPC9ibG9ja3F1b3RlPjwvZGl2 Pjxicj48YnIgY2xlYXI9ImFsbCI+PGJyPi0tIDxicj48ZGl2PlBvemRyYXdpYW08YnI+TWFyY2lu IC8gbmljcmFNPGJyPjwvZGl2Pgo8L2Rpdj4KPC9kaXY+PC9kaXY+PC9kaXY+PGJyPl9fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fPGJyPgpsbXMgbWFpbGluZyBs aXN0PGJyPgo8YSBocmVmPSJtYWlsdG86bG1zQGxpc3RzLmxtcy5vcmcucGwiPmxtc0BsaXN0cy5s bXMub3JnLnBsPC9hPjxicj4KPGEgaHJlZj0iaHR0cDovL2xpc3RzLmxtcy5vcmcucGwvbWFpbG1h bi9saXN0aW5mby9sbXMiIHRhcmdldD0iX2JsYW5rIj5odHRwOi8vbGlzdHMubG1zLm9yZy5wbC9t YWlsbWFuL2xpc3RpbmZvL2xtczwvYT48YnI+Cjxicj48L2Jsb2NrcXVvdGU+PC9kaXY+PGJyPjxi ciBjbGVhcj0iYWxsIj48YnI+LS0gPGJyPjxkaXYgY2xhc3M9ImdtYWlsX3NpZ25hdHVyZSI+UG96 ZHJhd2lhbTxicj5NYXJjaW4gLyBuaWNyYU08YnI+PC9kaXY+CjwvZGl2PjwvZGl2Pgo= --===============0120100457751410998==-- From milekz@gmail.com Mon Apr 27 19:06:48 2015 From: milek To: lms@lists.lms.org.pl Subject: Re: [lms] dokumenty - smarty Date: Mon, 27 Apr 2015 19:06:45 +0200 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3883762601473227692==" --===============3883762601473227692== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit Przykładowo masz klienta z abonamentem 10/5Mbit/s, wcześniej miał 5/2Mbit/s ( przeterminowane ) oraz 3/1Mbit/s twoje zapytanie zwróci 18/8Mbit/s dodaj coś w stylu where (assignments.dateto >EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0)) or assignments.dateto=0) and assignments.datefrom < EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0)) Miłosz --===============3883762601473227692== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGRpdiBkaXI9Imx0ciI+PGRpdj5Qcnp5a8WCYWRvd28gbWFzeiBrbGllbnRhIHogYWJvbmFtZW50 ZW0gMTAvNU1iaXQvcywgd2N6ZcWbbmllaiBtaWHFgiA1LzJNYml0L3MgKCBwcnpldGVybWlub3dh bmUgKSBvcmF6IDMvMU1iaXQvc8KgIHR3b2plIHphcHl0YW5pZSB6d3LDs2NpIDE4LzhNYml0L3M8 YnI+PGJyPjwvZGl2PjxkaXY+ZG9kYWogY2/FmyB3IHN0eWx1PGJyPjxicj7CoHdoZXJlIChhc3Np Z25tZW50cy5kYXRldG8gJmd0O0VYVFJBQ1QoRVBPQ0ggRlJPTSBDVVJSRU5UX1RJTUVTVEFNUCgw KSnCoCBvciBhc3NpZ25tZW50cy5kYXRldG89MCkgYW5kIGFzc2lnbm1lbnRzLmRhdGVmcm9tICZs dDsgRVhUUkFDVChFUE9DSCBGUk9NIENVUlJFTlRfVElNRVNUQU1QKDApKTxicj48L2Rpdj48ZGl2 Pjxicj48YnI+PC9kaXY+TWnFgm9zejxicj48L2Rpdj4K --===============3883762601473227692==-- From marcin@nicram.net Mon Apr 27 19:19:09 2015 From: Marcin To: lms@lists.lms.org.pl Subject: Re: [lms] dokumenty - smarty Date: Mon, 27 Apr 2015 19:19:06 +0200 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7589867923159055698==" --===============7589867923159055698== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit w sumie racja. aczkolwiek przeterminowane zobowiązania usuwam, przy tworzeniu umowy, aneksu musi być porządek, nie może być czegoś przeterminowanego. W dniu 27 kwietnia 2015 19:06 użytkownik milek napisał: > Przykładowo masz klienta z abonamentem 10/5Mbit/s, wcześniej miał > 5/2Mbit/s ( przeterminowane ) oraz 3/1Mbit/s twoje zapytanie zwróci > 18/8Mbit/s > > dodaj coś w stylu > > where (assignments.dateto >EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0)) or > assignments.dateto=0) and assignments.datefrom < EXTRACT(EPOCH FROM > CURRENT_TIMESTAMP(0)) > > > Miłosz > > _______________________________________________ > lms mailing list > lms(a)lists.lms.org.pl > http://lists.lms.org.pl/mailman/listinfo/lms > > -- Pozdrawiam Marcin / nicraM --===============7589867923159055698== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGRpdiBkaXI9Imx0ciI+PGRpdj53IHN1bWllIHJhY2phLiA8YnI+PC9kaXY+YWN6a29sd2llayBw cnpldGVybWlub3dhbmUgem9ib3dpxIV6YW5pYSB1c3V3YW0sIHByenkgdHdvcnplbml1IHVtb3d5 LCBhbmVrc3UgbXVzaSBiecSHIHBvcnrEhWRlaywgbmllIG1vxbxlIGJ5xIcgY3plZ2/FmyBwcnpl dGVybWlub3dhbmVnby48YnI+PC9kaXY+PGRpdiBjbGFzcz0iZ21haWxfZXh0cmEiPjxicj48ZGl2 IGNsYXNzPSJnbWFpbF9xdW90ZSI+VyBkbml1IDI3IGt3aWV0bmlhIDIwMTUgMTk6MDYgdcW8eXRr b3duaWsgbWlsZWsgPHNwYW4gZGlyPSJsdHIiPiZsdDs8YSBocmVmPSJtYWlsdG86bWlsZWt6QGdt YWlsLmNvbSIgdGFyZ2V0PSJfYmxhbmsiPm1pbGVrekBnbWFpbC5jb208L2E+Jmd0Ozwvc3Bhbj4g bmFwaXNhxYI6PGJyPjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdp bjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgi PjxkaXYgZGlyPSJsdHIiPjxkaXY+UHJ6eWvFgmFkb3dvIG1hc3oga2xpZW50YSB6IGFib25hbWVu dGVtIDEwLzVNYml0L3MsIHdjemXFm25pZWogbWlhxYIgNS8yTWJpdC9zICggcHJ6ZXRlcm1pbm93 YW5lICkgb3JheiAzLzFNYml0L3PCoCB0d29qZSB6YXB5dGFuaWUgendyw7NjaSAxOC84TWJpdC9z PGJyPjxicj48L2Rpdj48ZGl2PmRvZGFqIGNvxZsgdyBzdHlsdTxicj48YnI+wqB3aGVyZSAoYXNz aWdubWVudHMuZGF0ZXRvICZndDtFWFRSQUNUKEVQT0NIIEZST00gQ1VSUkVOVF9USU1FU1RBTVAo MCkpwqAgb3IgYXNzaWdubWVudHMuZGF0ZXRvPTApIGFuZCBhc3NpZ25tZW50cy5kYXRlZnJvbSAm bHQ7IEVYVFJBQ1QoRVBPQ0ggRlJPTSBDVVJSRU5UX1RJTUVTVEFNUCgwKSk8YnI+PC9kaXY+PGRp dj48YnI+PGJyPjwvZGl2Pk1pxYJvc3o8YnI+PC9kaXY+Cjxicj5fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fXzxicj4KbG1zIG1haWxpbmcgbGlzdDxicj4KPGEg aHJlZj0ibWFpbHRvOmxtc0BsaXN0cy5sbXMub3JnLnBsIj5sbXNAbGlzdHMubG1zLm9yZy5wbDwv YT48YnI+CjxhIGhyZWY9Imh0dHA6Ly9saXN0cy5sbXMub3JnLnBsL21haWxtYW4vbGlzdGluZm8v bG1zIiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL2xpc3RzLmxtcy5vcmcucGwvbWFpbG1hbi9saXN0 aW5mby9sbXM8L2E+PGJyPgo8YnI+PC9ibG9ja3F1b3RlPjwvZGl2Pjxicj48YnIgY2xlYXI9ImFs bCI+PGJyPi0tIDxicj48ZGl2IGNsYXNzPSJnbWFpbF9zaWduYXR1cmUiPlBvemRyYXdpYW08YnI+ TWFyY2luIC8gbmljcmFNPGJyPjwvZGl2Pgo8L2Rpdj4K --===============7589867923159055698==-- From marcin@nicram.net Mon Apr 27 20:52:20 2015 From: Marcin To: lms@lists.lms.org.pl Subject: Re: [lms] dokumenty - smarty Date: Mon, 27 Apr 2015 20:52:17 +0200 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3932223167039238985==" --===============3932223167039238985== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable by nie wyciaga=C4=87 z bazy ju=C5=BC wyci=C4=85gni=C4=99te dane zrobi=C5=82em= to w php w ten spos=C3=B3b: #v+ if($customernodes) foreach($customernodes as $idx =3D> $row) { $customernodes[$idx]['net'] =3D $DB->GetRow('SELECT *, inet_ntoa(address) AS ip FROM networks WHERE address =3D (inet_aton(mask) & ?)', array($row['ipaddr'])); $customernodes[$idx]['linktype'] =3D $DB->GetOne('SELECT linktype FROM nodes WHERE id=3D? AND ', array($row['id'])); foreach ($assignments as $valass){ if (($valass['dateto'] > time() || $valass['dateto'] =3D=3D 0) && ($valass['datefrom'] < time() || $valass['datefrom'] =3D=3D 0)){ foreach ($valass['nodes'] as $lit =3D> $valnod) { if ($valnod['id'] =3D=3D $row['id']){ $customernodes[$idx]['down'] +=3D floor($valass['downceil']/1024); $customernodes[$idx]['uplo'] +=3D floor($valass['upceil']/1024); } } } } } #v- teraz zsumuje pr=C4=99dko=C5=9Bci tylko z aktywnych taryf W dniu 27 kwietnia 2015 19:19 u=C5=BCytkownik Marcin na= pisa=C5=82: > w sumie racja. > aczkolwiek przeterminowane zobowi=C4=85zania usuwam, przy tworzeniu umowy, > aneksu musi by=C4=87 porz=C4=85dek, nie mo=C5=BCe by=C4=87 czego=C5=9B prze= terminowanego. > > W dniu 27 kwietnia 2015 19:06 u=C5=BCytkownik milek na= pisa=C5=82: > >> Przyk=C5=82adowo masz klienta z abonamentem 10/5Mbit/s, wcze=C5=9Bniej mia= =C5=82 >> 5/2Mbit/s ( przeterminowane ) oraz 3/1Mbit/s twoje zapytanie zwr=C3=B3ci >> 18/8Mbit/s >> >> dodaj co=C5=9B w stylu >> >> where (assignments.dateto >EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0)) or >> assignments.dateto=3D0) and assignments.datefrom < EXTRACT(EPOCH FROM >> CURRENT_TIMESTAMP(0)) >> >> >> Mi=C5=82osz >> >> _______________________________________________ >> lms mailing list >> lms(a)lists.lms.org.pl >> http://lists.lms.org.pl/mailman/listinfo/lms >> >> > > > -- > Pozdrawiam > Marcin / nicraM > --=20 Pozdrawiam Marcin / nicraM --===============3932223167039238985== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGRpdiBkaXI9Imx0ciI+PGRpdj48ZGl2PjxkaXY+YnkgbmllIHd5Y2lhZ2HEhyB6IGJhenkganXF vCB3eWNpxIVnbmnEmXRlIGRhbmUgenJvYmnFgmVtIHRvIHcgcGhwIHcgdGVuIHNwb3PDs2I6PGJy Pjxicj48L2Rpdj4jdis8YnI+aWYoJGN1c3RvbWVybm9kZXMpPGJyPsKgwqDCoCBmb3JlYWNoKCRj dXN0b21lcm5vZGVzIGFzICRpZHggPSZndDsgJHJvdyk8YnI+wqDCoMKgIHs8YnI+wqDCoMKgIMKg wqDCoCAkY3VzdG9tZXJub2Rlc1skaWR4XVsmIzM5O25ldCYjMzk7XSA9ICREQi0mZ3Q7R2V0Um93 KCYjMzk7U0VMRUNUICosIGluZXRfbnRvYShhZGRyZXNzKSBBUyBpcCBGUk9NIG5ldHdvcmtzIFdI RVJFIGFkZHJlc3MgPSAoaW5ldF9hdG9uKG1hc2spICZhbXA7ID8pJiMzOTssIGFycmF5KCRyb3db JiMzOTtpcGFkZHImIzM5O10pKTs8YnI+wqDCoMKgIMKgwqDCoCAkY3VzdG9tZXJub2Rlc1skaWR4 XVsmIzM5O2xpbmt0eXBlJiMzOTtdID0gJERCLSZndDtHZXRPbmUoJiMzOTtTRUxFQ1QgbGlua3R5 cGUgRlJPTSBub2RlcyBXSEVSRSBpZD0/IEFORCAmIzM5OywgYXJyYXkoJHJvd1smIzM5O2lkJiMz OTtdKSk7wqDCoMKgIMKgwqDCoCA8YnI+wqDCoMKgIMKgwqDCoCBmb3JlYWNoICgkYXNzaWdubWVu dHMgYXMgJHZhbGFzcyl7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIGlmICgoJHZhbGFzc1smIzM5 O2RhdGV0byYjMzk7XSAmZ3Q7IHRpbWUoKSB8fCAkdmFsYXNzWyYjMzk7ZGF0ZXRvJiMzOTtdID09 IDApICZhbXA7JmFtcDsgKCR2YWxhc3NbJiMzOTtkYXRlZnJvbSYjMzk7XSAmbHQ7IHRpbWUoKSB8 fCAkdmFsYXNzWyYjMzk7ZGF0ZWZyb20mIzM5O10gPT0gMCkpezxicj7CoMKgwqAgwqDCoMKgIMKg wqDCoCA8YnI+wqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKg IMKgwqDCoCBmb3JlYWNoICgkdmFsYXNzWyYjMzk7bm9kZXMmIzM5O10gYXMgJGxpdCA9Jmd0OyAk dmFsbm9kKSB7PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgIMKg wqDCoCDCoMKgwqAgwqDCoMKgIGlmICgkdmFsbm9kWyYjMzk7aWQmIzM5O10gPT0gJHJvd1smIzM5 O2lkJiMzOTtdKXs8YnI+wqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAg wqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgICRjdXN0b21lcm5vZGVzWyRpZHhdWyYjMzk7ZG93 biYjMzk7XSArPSBmbG9vcigkdmFsYXNzWyYjMzk7ZG93bmNlaWwmIzM5O10vMTAyNCk7PGJyPsKg wqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDC oMKgIMKgwqDCoCAkY3VzdG9tZXJub2Rlc1skaWR4XVsmIzM5O3VwbG8mIzM5O10gKz0gZmxvb3Io JHZhbGFzc1smIzM5O3VwY2VpbCYjMzk7XS8xMDI0KTs8YnI+wqDCoMKgIMKgwqDCoCDCoMKgwqAg wqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKgwqAgfcKgwqDCoCDCoMKgwqAg wqDCoMKgIMKgwqDCoCA8YnI+wqDCoMKgIMKgwqDCoCDCoMKgwqAgwqDCoMKgIMKgwqDCoCDCoMKg wqAgwqDCoMKgIMKgwqDCoCB9PGJyPsKgwqDCoCDCoMKgwqAgwqDCoMKgIH08YnI+wqDCoMKgIMKg wqDCoCDCoMKgwqAgPGJyPsKgwqDCoCDCoMKgwqAgfTxicj7CoMKgwqAgfTxicj48L2Rpdj4jdi08 YnI+PGJyPjwvZGl2PnRlcmF6IHpzdW11amUgcHLEmWRrb8WbY2kgdHlsa28geiBha3R5d255Y2gg dGFyeWY8YnI+PGRpdj48YnI+PC9kaXY+PC9kaXY+PGRpdiBjbGFzcz0iZ21haWxfZXh0cmEiPjxi cj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+VyBkbml1IDI3IGt3aWV0bmlhIDIwMTUgMTk6MTkg dcW8eXRrb3duaWsgTWFyY2luIDxzcGFuIGRpcj0ibHRyIj4mbHQ7PGEgaHJlZj0ibWFpbHRvOm1h cmNpbkBuaWNyYW0ubmV0IiB0YXJnZXQ9Il9ibGFuayI+bWFyY2luQG5pY3JhbS5uZXQ8L2E+Jmd0 Ozwvc3Bhbj4gbmFwaXNhxYI6PGJyPjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5 bGU9Im1hcmdpbjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmct bGVmdDoxZXgiPjxkaXYgZGlyPSJsdHIiPjxkaXY+dyBzdW1pZSByYWNqYS4gPGJyPjwvZGl2PmFj emtvbHdpZWsgcHJ6ZXRlcm1pbm93YW5lIHpvYm93acSFemFuaWEgdXN1d2FtLCBwcnp5IHR3b3J6 ZW5pdSB1bW93eSwgYW5la3N1IG11c2kgYnnEhyBwb3J6xIVkZWssIG5pZSBtb8W8ZSBiecSHIGN6 ZWdvxZsgcHJ6ZXRlcm1pbm93YW5lZ28uPGJyPjwvZGl2PjxkaXYgY2xhc3M9ImdtYWlsX2V4dHJh Ij48YnI+PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPjxkaXY+PGRpdiBjbGFzcz0iaDUiPlcgZG5p dSAyNyBrd2lldG5pYSAyMDE1IDE5OjA2IHXFvHl0a293bmlrIG1pbGVrIDxzcGFuIGRpcj0ibHRy Ij4mbHQ7PGEgaHJlZj0ibWFpbHRvOm1pbGVrekBnbWFpbC5jb20iIHRhcmdldD0iX2JsYW5rIj5t aWxla3pAZ21haWwuY29tPC9hPiZndDs8L3NwYW4+IG5hcGlzYcWCOjxicj48L2Rpdj48L2Rpdj48 YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MCAwIDAgLjhleDti b3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4Ij48ZGl2PjxkaXYgY2xh c3M9Img1Ij48ZGl2IGRpcj0ibHRyIj48ZGl2PlByenlrxYJhZG93byBtYXN6IGtsaWVudGEgeiBh Ym9uYW1lbnRlbSAxMC81TWJpdC9zLCB3Y3plxZtuaWVqIG1pYcWCIDUvMk1iaXQvcyAoIHByemV0 ZXJtaW5vd2FuZSApIG9yYXogMy8xTWJpdC9zwqAgdHdvamUgemFweXRhbmllIHp3csOzY2kgMTgv OE1iaXQvczxicj48YnI+PC9kaXY+PGRpdj5kb2RhaiBjb8WbIHcgc3R5bHU8YnI+PGJyPsKgd2hl cmUgKGFzc2lnbm1lbnRzLmRhdGV0byAmZ3Q7RVhUUkFDVChFUE9DSCBGUk9NIENVUlJFTlRfVElN RVNUQU1QKDApKcKgIG9yIGFzc2lnbm1lbnRzLmRhdGV0bz0wKSBhbmQgYXNzaWdubWVudHMuZGF0 ZWZyb20gJmx0OyBFWFRSQUNUKEVQT0NIIEZST00gQ1VSUkVOVF9USU1FU1RBTVAoMCkpPGJyPjwv ZGl2PjxkaXY+PGJyPjxicj48L2Rpdj5NacWCb3N6PGJyPjwvZGl2Pgo8YnI+PC9kaXY+PC9kaXY+ PHNwYW4gY2xhc3M9IiI+X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX188YnI+CmxtcyBtYWlsaW5nIGxpc3Q8YnI+CjxhIGhyZWY9Im1haWx0bzpsbXNAbGlzdHMu bG1zLm9yZy5wbCIgdGFyZ2V0PSJfYmxhbmsiPmxtc0BsaXN0cy5sbXMub3JnLnBsPC9hPjxicj4K PGEgaHJlZj0iaHR0cDovL2xpc3RzLmxtcy5vcmcucGwvbWFpbG1hbi9saXN0aW5mby9sbXMiIHRh cmdldD0iX2JsYW5rIj5odHRwOi8vbGlzdHMubG1zLm9yZy5wbC9tYWlsbWFuL2xpc3RpbmZvL2xt czwvYT48YnI+Cjxicj48L3NwYW4+PC9ibG9ja3F1b3RlPjwvZGl2PjxzcGFuIGNsYXNzPSIiPjxi cj48YnIgY2xlYXI9ImFsbCI+PGJyPi0tIDxicj48ZGl2PlBvemRyYXdpYW08YnI+TWFyY2luIC8g bmljcmFNPGJyPjwvZGl2Pgo8L3NwYW4+PC9kaXY+CjwvYmxvY2txdW90ZT48L2Rpdj48YnI+PGJy IGNsZWFyPSJhbGwiPjxicj4tLSA8YnI+PGRpdiBjbGFzcz0iZ21haWxfc2lnbmF0dXJlIj5Qb3pk cmF3aWFtPGJyPk1hcmNpbiAvIG5pY3JhTTxicj48L2Rpdj4KPC9kaXY+Cg== --===============3932223167039238985==--