(/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ۄUz8<{hNQn2Ҙֈ$zTO3=o%u#"{YHff|ڌc~LwcB@+0~P5%G_xj0}l6l7SxMTG?F5PN.5Na a43lP#3?dW>KfMKPC <>Ԥ 953v`*} S)ŧXnx pM@cky1w:8[xuy ޲/4L,{Z^^I`{6jV٘\/ 8B-hmdYy.-^k8vVASkK8O3'\HQ5Hf}  z1pH<ʐW6ْn԰W9Rm~K;Km/pzh&{R5 s$0f2/RO\,piЃn~iz: {[*IU>@7[K^$QX__){9&&A u~ub8-TwbfK;kvaq˱3d'/$I" &&f|7%,ܽDK_\;#[/ mރt"p>`[T`'̹+6EI3'Ixȟ{^ g ?,ƴנcSOSN 2*-t` uƩM^7WYrrx5VYㄾ6!EɧσvO+ $uTW&FpŔzeʁĉ&d4pI%ƹ|о4@0 1G$A MS ]+s_.<"ț~b@{iG ~k;IjB*%B Q~873d7ɪP_/~^ɜz3> uls:_w4ɱYS}%]WKps$m-̎.rC-"b 8Dd^;ZB&;KĀ 70!}[7*`+]ƕ|`CRr"%|\7HK~t/S4`K-MbbőZgǚ/|IAfS={X!ċƏcwϻOqRO׋o*ϡ]HQLA6-J*T^Q$CddD!F~ه_t ,0.M:_R~ՈІw{Hw*[o¯SXpRE5=6~ $~1ul\eKm7mOQlt?} h&at"$goĖ3,ϾĜ"d+W*j? ͩu@v]|$߅B8@L+kc8dn!o%ҸDNPXvt`uut쫾אΌ[ ti¢gun A;^{OtlTr?7Y_du'=bU3".w/y9=~7 } /0{O,*f 5f%gmGvXH{GU|녖LkFevR& JJJ[f BrV 56l60`@X[Qbk@5@~KDCmP@N2#n]BCǧE(/TڧnҁWբ_):ē|'&riJpxEIa1:xUb pmy@>/E{sߊǡ)f'di 2ݎ/n\LnG^"/%[jE=񊖏2 k' YV |\!;(w".$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 "
#NameAddressContactBalanceEditPurchaseSalesReturnPay/RecLedgerLedger2pReturnDel"; 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']; //$contacts = $row['contacts']; $balance = $row['balance']; if ($balance>0) $debAmt+=$balance; else $crdAmt+=$balance; //$date_ = date('Y-m-d',strtotime($row['date_'])); //echo "
$cnt"; echo "
".$cnt; // echo "".$row['actcode']; echo "$name$address".$row['contacts']."$balance"; echo ""; if($_SESSION['LabID']==30){ //Mahmood Steel echo ""; // }elseif($_SESSION['LabID']>=31 ){ //Al-Makkah Mobile Ferdous // echo ""; }else{ echo ""; } echo ""; echo ""; echo " 1"; echo " 2"; echo ""; echo ""; $cnt+=1; } echo "
SummaryDebit
Credit		$debAmt
$crdAmt		"; echo ""; mysqli_close($con); ?>