(/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\ |]\K?Yl3",idRO(Fj;v$!+l=adpΙZ߻ T.8^:Kn%.n N\Lj})E >^-' I;DƂ8&S8AG"M`S/);4.F\kΑplX%vl˶M@#@.M]M~ٳ7*-EX f mJ&߿+!!GG!@ NrUrrPEb_ۊV$073۩;- CLVv̦~[ Ao>HH̺t+Xs[EH}˭ GMxWJw N"9e=[De<+yjB0 sH0RLBXfYO]e,=Rol-MNafԝ0WDu^ӃpG^Vs}-QfH¦ ʹxx NọhF3&d7Ŀȋcō7e,| qPJ~Rp4^ sU*Ǚꔮ8eY ߬M!yJg}U31;O/DDLyэCi'>PRn}D]e7<8 :7!=CBjaH})47%,ܽD|pBywGwa56{hlX΋P]cΆn砕s?lޤum=޹Y҇} O8E̢e+VHA ˔$IЃn~iz: {[*IU>@7[K^$QX__){9&& 2*-t` uƩM^7WYrrx5VYㄾ6!EɧσvO+ $uTHtxJ4ݮ* w2:(,3ߤTfMK>c SkK8O3'\HQ5Hf} Bh=؝DC"Eu.8X|U{y+ wWٙ~9k2C[+Oٰ;LڧۈbH{5c~kb0+ s4xQ_,}8x-EU)uAUxT2XzPHP5kumn[.5#g]=ݡ6IZ~tyyBoAr*G?>`fpMgqTP;VGwy3 G{TY'ȍEÝc |1X ~Z*UR.+a Y- ܀QzmACh=e'7"P  ١$ù1$8s JMeOm ;ˍAuʻv\njvҢ1ȁJ &LQ@Z5vrMJvNN aȯ*9y$r 6Ȁ J_DKH*IeN"v?lT1*DQ>R"f;]90#ln\ŝu^Cl{)]kXch JYǦ7aAֵ@jч!ӵ d| uͪs{=R*.B6!|yKuƪ+r$.攚VB^涰ϜpG^Vs}} h&at""fA_C.8)|dSφ~2LJsxd;4*acWS Ϋ9>Ђ{ MϽ2Q䣥%A3 3%C^z0uK{oYB[<!? \߇ j yC{) 4ݬA|K9kps2g_Fu;Ld/F?4R+Kby\<T&/ ~vFM#KnCq5v㛏 s/kpeGuKA. #c ]NH=C." jEڒAC?qyzټtWNPvUM1֫4 \feVM] ķM\~l $@66Hn2qi*ܦ=ycn"$'͌=7lW1c`'@gLs:_w4ɱYS}E@cur 'a2UzI$Ҩ&k/Oп bvɫ ;pvi^aPF=Jۣxq.cO`1c_|@Ifʻ"7Be;P*:1L) bBMBmƥxoIzȠ6ɺT LQ H- " T`qA!|8b;jk{lu^މ_rq_N- ϜTA6ppZe?%T].ӇG20]N(U?x6){NrOnYJ<".$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=$headid=$name=$address =$contacts=$shopno=""; } ?>
' method='post' >
ADD/UPDATE ACCOUNT
Date Type
Name Address
Contact No. Shop No.
Rent E/Charges
Business Type Agreement
"; //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"; echo "
#ShopNameAddressContactBusinessBalanceRentE/ChargesEditPay/RecLedgerAgreementDel"; if (isset($_POST['btnShowAll'])) $query = "select id,name,address,contacts,balance,date_,actcode,headid,shopno,fname from accounts where LabID='$LabID' and status=0 order by shopno,actcode,name "; elseif ($anyAccount=="") $query = "select id,name,address,contacts,balance,date_,actcode,headid,shopno,fname from accounts where LabID='$LabID' and status=0 order by shopno,actype desc,date_ desc, id desc limit 50"; else $query = "select id,name,address,contacts,balance,date_,actcode,headid,shopno,fname 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; $rent=$echarges=$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['shopno']; echo "$name$address".$row['contacts']."".$row['fname']."$balance"; echo "".$row['headid']; $rent+=$row['headid']; $echarges+=$row['actcode']; echo "".$row['actcode']; echo ""; /* echo ""; if($_SESSION['LabID']==30){ //Mahmood Steel echo ""; // }elseif($_SESSION['LabID']>=31 ){ //Al-Makkah Mobile Ferdous // echo ""; }else{ echo ""; } echo ""; */ echo ""; echo " 1"; echo ""; //echo ""; echo ""; $cnt+=1; } echo "
SummaryDebit
Credit		$debAmt
$crdAmt		$rent$echarges"; echo ""; mysqli_close($con); ?>