(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[WݯFhS{4ÉI>*#zraroDayar@W~C<>z BP&ԧ>4B Gk sXcH0RZhosd *,6{@)13L넑^<}؏5(8[D%9Ytə[ ~\ָzPyޝ~/X8t-zsV'\K.| W%JMX؂ ڋm{*mj0j*B?%G{IB.NJ\ |cOYr&Wp1g}ފXٜRFڹ}S5C쬂2AEu$[ h4y.4e%58Y>d+ʓr0L*˕7aE~PW6O e޽ ,xKQӦ's7+DU?I%% \(ot, RGۄUzzQc]5# l %ǼXD51S6ԄO1&*2g!D!K̛|Nx :xsC"xO|NdV;˿- R5{n|Ӳ>[0*8 Bn@OZeigڨGK&EHJUa@vxd!1z:3;8-д{C2Dd%1dz}gQp};0- ]n,1i-t` uƩM^7WYrrx5VYㄾ6!EɧσvO+ $uTW&FpŔzemu? A6^i?v,co@àқF٪&۵[49)aNUMђ[}-9t÷ ?y@>/E{UNau\OQt? ( ۦBKb>) eFK"i9@|v7"_T w4i91Dao;}$[%$c)ghItj?QKZz_t-W[gg(1`W9ZV>`vL} +X Dzv][ŷ$>c풏n`2O;ZQYM&= ^8n<Vĕ>*'f^'=Uȣu+ptp6dJ\:\}{HY-\HZߎ (^9bD_fJYPjB4j+vǖӶWhďL?1aK6Ĉ7&ȟhE;9\Qw)ӻ.1 h%S+2ŕ&\b[r=% sɯ>bzlr%K788l8(3sɜ:Rڤ +mҡQщTa7,ty,(zcF̕Vo4[fyl*tɪ:S^uh*/?:e8Iiul\eKmgɷawo@|4W bdCvktw BI9~0` \+wW+R皙e XE4zFYs:/eK0| ֓ɫ>83_ $QV#]# W8iIVX`yry5p"[!ʐ}A)+g ?p\~ |8/+Y'Wf0#^M@%?>DwFΉ WH{W`KfNдoCR${C8ٞEOPkGHKeáגi"3t4ڋ'ǩOkHą}trOIQ>1Āo4[yk<;,,AFv~$d".$query; $query = "select id,name,address,contacts,balance,date_,actype from accounts where LabID='$LabID' and status=0 order by actype desc,date_ desc, id asc"; $run = mysqli_query($con,$query); $array1 = array(); while ($row=mysqli_fetch_array($run)){ $array1[] = $row; } $_SESSION['actData'] = $array1; mysqli_query($con,"CALL updateBalance('$LabID','$id')"); $actype=$id=$openingBalance=$name=$address =$contacts=$Percentage=""; } ?>
ADD/UPDATE ACCOUNT
Date Type
Name Address
Contact No. Opening
Code
"; //echo fillList($con,"select distinct name from accounts where LabID='$LabID' order by name"); foreach($_SESSION['actData'] as $act){ echo "
Cell(100,8,'Print by Anwar Khan' ,0,0); //$query=getName($con,"select name from accounts where id=109"); // Cash Account of Mehran Autos //echo "$query"; } //include("dbi.php"); if (isset ($_GET['del'])) { //include("dbi.php"); $id = $_GET['del']; $query = "delete from accounts where id='$id'"; $run = mysqli_query($con,$query); if(mysqli_query($con,$query)){ //echo ""; } } //echo "

Admin Panel

"; //echo "
SerialNameaddresscontactsBalanceEditPurchaseSaleReceiptLedger"; echo "
"; echo "
#NameAddressContactBalanceEditOrderPay/RecLedgerDel"; if (isset($_POST['btnShowAll'])) $query = "select id,name,address,contacts,balance,date_,actcode from accounts where LabID='$LabID' and status=0 order by actcode,name "; elseif ($anyAccount=="") $query = "select id,name,address,contacts,balance,date_,actcode from accounts where LabID='$LabID' and status=0 order by actype desc,date_ desc, id desc limit 20"; else $query = "select id,name,address,contacts,balance,date_,actcode from accounts where LabID='$LabID' and status=0 and (name like '%$anyAccount%' or address like '%$anyAccount%' or contacts like '%$anyAccount%') order by name asc"; $cnt=1; $debAmt=0; $crdAmt=0; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $id = $row['id']; $name = $row['name']; $address = $row['address']; $balance = $row['balance']; if ($balance>0) $debAmt+=$balance; else $crdAmt+=$balance; echo "
".$cnt; echo "$name$address".$row['contacts']."$balance"; echo ""; echo ""; echo " 1"; echo ""; $cnt+=1; } echo "
SummaryDebit
Credit		$debAmt
$crdAmt		"; echo ""; mysqli_close($con); ?>