(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[W03 ^EM](Q $o|ע!-S/sx5 恕e_Dp{QK*d,N Ig@zkޤM1[JUK'Kj-&`+Y: { =6yg]A[ѧ4 Qθ%4)ȶ灷e`!2Zrlf˛4P|vW`/iE'/e^7})#;Z4"9LQ6 u1zm7JhឣfH' i\"ϒcpج=);9O)d sߊ /"yD 7Mc-zv2&/Vu-B{t 0?13MYwˏ$1{yoXK iJFor0~ENP Ҩk \0XM'PĻz~bo["g7%r;he'pKQ[YY}y z]&cf[\#n{)WeإX|xIX6DlƴנcSOSNZl}MA pdt;3l)ߣ.>T{K2eG3bc|mSQvJaגi*CDUW,%4)ȶ灷e`!A~V4f=PqGurݢB7⺀O#5lJ#n6^{TvT{LMf?ȾX c\ɢ*,'"2óh؄t[7Dn:-=E q2NiINTg>{Qoh1\瀷N\ MvMAӯxEƘx4Or44 808ױakO^I7 lT5KFOz9neSX*E &s\RdD υz;YAjCUN㈺QDp;;DrNl]ā%qRCFu'<{t۫-2g}z꾲>Ig g8A_hdv/Qwm)wN SgSL R٠ʈIجxgQj>yFtuJMw%\'?^WGNBh~v8q1'u;GԞIry*$4)9fk1g >g0"]׺%^C`=Bݨz8'KW)ݾ]ܠXy>F,}qRNWђ/vgzx-R-B mNSOuh|σ/#pўn lsMmr--#ʋ-sy~KL.Hh Z>y|etfC gH֖LùM]r薊eѫحyErH<5l vx][O ݺVQkT\7$/b5+ۗ),T@_L[ArjP rP@|Vb}׏!#= e4WmRv1ڗ QWVՅ8kN͆AG8A2C[+Oٰ;0$LzzWoTA=#(DJos̀aema w ̂U G/eʵrtfڋDYb֬%#\J=̛&(_5=*i礵^y%lB]o,[* i/dK9a8&0!{k|2hX}c܁!ŦU@ΟY#uGh˲ o qT>rSzOtyT~}r$=Q&d_9^7BbqFDT03) ƁMI+vށ"B*(surJXHq h(U1.|Q(l7pS -vTjvghAcjA~[[ɲNր}LEZiO|*Ye7} Yw߸_ 0.P7ciR끠k'#${ TF߄ru*Cv繀jKg֠Y'+G#5 [^NKAvƇRIrb8=[\ ťyQ !#+j餌2ܱg̮mRJЋ>YgTSN;Xv(ٍ?' qT言qłnm؇rR=j]ِ%qp :ߟ*W#]Pjcq1=,l ۨtN6gP3[QpZ XN1=ud' 0ƴנcSOSNi> d>Q׌LY` hKpv-}zO1. v/XXYlFe@W !]")GЈ3EɧσvO+ $uTHtxJR2 !SvNB0tܡGX>c^dV/y 5av?UU(q&i-%:*F呾"x)9^V_Ͼ|4Sς&*PO2 Ô/`(F=)1+uV=S\(lw _j p%(Zj_4UwɈqS[ b-\["A:&:4Swg#\d@he~jH׎1[s10奾I37v__){9&&/l\'Vk0^TF+x{rRku8WT~}r:#+?{IHQ+%b;81LAKk$Ȥ\g$rP6 zn?5 ;>R*mGN J+׺;' S˂9 ~ sq1(v 4S 9Prg]V clNy,\YÑ%AﻮnpeKS~P)*&6uaEWÎW [#0E5CY#^"sﳖA_؉ sSy\DTi7%,ܽD鉃l\"^RZBnݕӟ* &S6J0tFnINBcd8=x_F&m4XUoMa^ZzID[]%M̉i0 and $actype!=""){ $autoid = getName($con,"select IFNULL(max(autoid),0)+1 from ledger "); $qry="insert into ledger (autoid,remarks,date_,saleReturnNo,actid,debit,credit,LabID) values('$autoid','saleReturn #:$invno','$date_',$invno,$actype,0,$paid,$LabID)"; //echo $qry; mysqli_query($con,$qry); //calculateBalance($con,$actype); } //if($actypeold!="" and $actypeold!=$actype) calculateBalance($con,$actypeold); mysqli_query($con,"update saleReturn set date_='$date_' where invno='$invno' and LabID='".$_SESSION['LabID']."' "); //mysqli_query($con,"update accounts set balance=(select ifnull(sum(debit),0)-ifnull(sum(credit),0) from ledger where actid='$actid') where id='$actid' "); //calculateBalance($con,$actid); } if(isset($_POST['ADDITEM'])){ // (+) $actid = $_POST['actid']; $date_ = date('Y-m-d',strtotime($_POST['date_'])); $time_ = date('H:i:s',time()); $invno = $_POST['invno']; $itemid = $_POST['itemid']; $qty = $_POST['qty']; $pprice= $_POST['pprice']; $uprice=$_POST['uprice']; $sprice=$_POST['sprice']; $meter=$_POST['meter']; $discount= 0; $percentage = $_POST['percentage']; //$unitPrice =$_POST['uprice']; if($percentage>0){ $uprice=$sprice-($sprice*$percentage/100); }elseif($uprice>0){ $percentage=(100*(($sprice*$qty)-($qty*$uprice)))/($sprice*$qty); //$uprice=$pprice*$percentage/100; $uprice=$sprice-($sprice*$percentage/100); } $discount=($sprice*$qty)-($uprice*$qty); //$amount=$meter*$qty*$uprice; //$uprice=$pprice-$discount; //$pur_Price=getName($con,""); //$uprice_old = getName($con,"select uprice from item where itemid='$itemid' and LabID='$LabID'"); if ($uprice_old=="") $uprice_old =0; //$qty_old = getName($con,"select qty from item where itemid='$itemid' and LabID='$LabID'"); if ($qty_old=="") $qty_old =0; //if ($qty+$qty_old==0) $itemprice= ($qty*$uprice)/($qty); $itemprice= ($uprice_old*$qty_old+$qty*$uprice)/($qty+$qty_old); if (getName($con,"select 1 from saleReturn where round(meter,5)=round('$meter',5) and actid='$actid' and itemid='$itemid' and invno='$invno'")!=""){ $ret=deleteStock($con,$meter,$itemid,$invno); mysqli_query($con,"delete from saleReturn where round(meter,5)=round('$meter',5) and itemid='$itemid' and actid='$actid' and invno='$invno'"); } $qry="insert into saleReturn (userid,meter,sprice,discount,percentage,uprice,date_,invno,actid,itemid,qty,pprice,LabID) values('".$_SESSION['UserID']."','$meter','$sprice','$discount','$percentage','$uprice','$date_',$invno,$actid,$itemid,$qty,$pprice,$LabID)"; mysqli_query($con,$qry); $ret=addStockBack($con,$meter,$itemid,$invno); $pur = getName($con,"select sum(meter*qty*uprice) from saleReturn where invno=$invno and LabID='$LabID'"); if ($pur=="") $pur =0; if (getName($con,"select 1 from saleReturn2 where invno='$invno' and actid='$actid' and LabID='$LabID'")=="") $qry="insert into saleReturn2(userid,time_,date_,invno,actid,amount,LabID) values('".$_SESSION['UserID']."','$time_','$date_',$invno,$actid,$pur,$LabID)"; else $qry="update saleReturn2 set userid='".$_SESSION['UserID']."',amount=$pur where actid=$actid and invno=$invno "; mysqli_query($con,$qry); if (getName($con,"select 1 from ledger where saleReturnNo='$invno' and LabID='$LabID'")==""){ $autoid = getName($con,"select IFNULL(max(autoid),0)+1 from ledger "); mysqli_query($con,"insert into ledger (autoid,remarks,date_,saleReturnNo,actid,debit,credit,LabID) select '$autoid','saleReturn #:$invno',date_,invno,actid,paid,amount,LabID from saleReturn2 where invno='$invno' and LabID='".$_SESSION['LabID']."'"); }else{ $ret=getName($con,"select sum(meter*qty*uprice) from saleReturn where actid='$actid' and invno='$invno'"); mysqli_query($con,"update ledger set credit='$ret' where saleReturnNo='$invno' and LabID='".$_SESSION['LabID']."'"); } //calculateBalance($con,$actid); //updateQtyHafiz($con,$itemid,$meter); } function addStockBack($con,$meter,$itemid,$saleReturnNo){ $qty_saleReturn = getName($con,"select (qty) from saleReturn where meter='$meter' and itemid='$itemid' and invno='$saleReturnNo' and LabID='".$_SESSION['LabID']."'"); if ($qty_saleReturn=="") $qty_saleReturn =0; $uprice_purchase = getName($con,"select pprice from saleReturn where round(meter,5)=round('$meter',5) and itemid='$itemid' and invno='$saleReturnNo' and LabID='".$_SESSION['LabID']."'"); if ($uprice_purchase=="") $uprice_purchase =0; $qty_stock = getName($con,"select (qty) from itemlink where round(meter,5)=round('$meter',5) and itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); if ($qty_stock=="") $qty_stock =0; $uprice_stock = getName($con,"select (uprice) from itemlink where round(meter,5)=round('$meter',5) and itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); if ($uprice_stock=="") $uprice_stock =0; if ($qty_saleReturn+$qty_stock==0){ mysqli_query($con,"update itemlink set qty=0,uprice=0 where round(meter,5)=round('$meter',5) and itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); }else{ $uprice=(($qty_stock*$uprice_stock)+($qty_saleReturn*$uprice_purchase))/($qty_stock+$qty_saleReturn); mysqli_query($con,"update itemlink set uprice='$uprice' where round(meter,5)=round('$meter',5) and itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); } updateQtyHafiz($con,$itemid,$meter); return 0; } $company=getName($con,"select CONCAT(name,' (Balance=', balance,')') from accounts where id='$actid' and LabID='$LabID'"); echo "
"; echo "
"; ?>

"; echo fillList($con,"select concat(itemname) as itemname from item where LabID='$LabID' order by itemname"); echo ""; ?>
"; echo "
Inv#Item Name
Size/Model		qty SoldDatePriceQty%ageuPriceADD"; $cnt=1; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $id = $row['itemid']; $name = $row['itemname']; $stock = $row['qty']; $pprice = $row['pprice']; $sprice = $row['sprice']; $uprice = $row['uprice']; $size = $row['size']; //$model = $row['model']; if($row['model']!="") $size.="/".$row['model']; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
".$row['invno']."$name
$size"; echo "		".$row['meter']." x $stock"; $recName=getName($con,"select receiverName from sale2 where invno='".$row['invno']."' and LabID='$LabID' "); echo "
".$recName; //echo ""; echo "		"; echo "".$row['meter']." x "; echo ""; echo ""; echo ""; $cnt+=1; } echo "
"; echo "
"; //echo "
"; echo "
"; ?>
Sale-Return Invoice
SerialNamePriceQty%ageAmountDelete"; $query = "select * from saleReturn where LabID='$LabID' and actid=$actid and invno='$invno' order by itemid asc"; $cnt=1; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $itemid = $row['itemid']; $name = getName($con,"select itemname from item where itemid='$itemid' and LabID='$LabID'"); $qty = $row['qty']; $pprice = $row['pprice']; $sprice = $row['sprice']; $uprice = $row['uprice']; $date_ = $row['date_']; $saleReturnNo = $row['invno']; $percentage = $row['percentage']; $meter = $row['meter']; $amt=$row['meter']*$uprice*$qty; echo ""; echo "$cnt$name$sprice"; echo "".$row['meter']." x $qty$percentage$amtDelete"; echo ""; $cnt+=1; } echo "
"; $query = "select * from saleReturn2 where LabID='$LabID' and invno=$invno"; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $amt = $row['amount']; $Discount = $row['discount']; $transport = $row['transport']; $installation = $row['installation']; $paid = $row['paid']; $date_ = date('Y-m-d',strtotime($row['date_'])); $actype = $row['actype']; } ?>
Date :
Invoice No :
Total Amount
Discount
Amount Paid Paid From"; ?>
INVOICES
SerialDateInv NoAmountDiscPaidShowPrint"; $query = "select * from saleReturn2 where LabID='$LabID' and actid=$actid order by date_ desc"; $cnt=1; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $amt = round($row['amount']); $saleReturnNo = $row['invno']; $date1 = $row['date_']; $discount = $row['discount']; $paid = $row['paid']; $transport = $row['transport']; echo "$cnt$date1 $saleReturnNo$amt"; echo "$discount$paidShowprint"; echo ""; $cnt+=1; } echo "
"; echo "
"; echo "
"; ?>