(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tTZ,qCV46 zU1?с?Iz=$m78\pmQ5?{aʓ@:S1TҫWJ!6gIGXI y>q3|qSK%SaAm*'~R^oe(ji4svj!+ܲm}vNg xipݖC膟 f9> u5^G$w1*/AN ;5փuO@\[ bp}QW-fgƴP$X @Zud|wn7[T # &A^bӇ1[>"his*_7p_[.'$ }lf%03 ^EM](Q $o|ע!-S/sx5 恕e_Dp{QK*d,N Ig@zkޤM1[JUK'Kj-&`+Y: { =' T\`=0o >T+ǂO_&UXw­]/exH+h=hTZ q}3^J>k>FLϺXYSSm` ?i| udVն6]#A95D9^N8eœo46:~ RعYO볿`qpw#]63h#@+~\52ӊ!+D*ȵ+; >^QUVK4 &t'eb5S+|]eQS)(ԅYp(Tm&I!?ey±".bkA$#"G{9yAᵎ[Yryf )@R"fy"N4N"q8ر/5m;tJ{!m[BM554;Gq!̏\ }H? f>d4II,QvW`/iyi/Gɐ(8w|y@sW%ݘZ؝|p:vME?{G9xI?g!+&[MTHזt QXM͆Ǿ$Fs_Wjpl||Y5[z:֞@ 97 y aN/`S'KVDï?'wm=޹Y҇} O8Έ*ts:_w4ɱYS}.v ֮=әܹno&tҚm`zP[-c@P\O_Sx100]6.I5I4X WaNn@\2. ^.P/OEB:!7:G _1yP@g0B錘 }l s0jSvÀ@b5IOwtm>-B{.lc9I ͡F4J"xsIGPg(݇[%{3Tz697,rr/52x$Q.no!}-)v;?cLsj~S 2QS)A.Ac3}GU=¤XU(SȹlM4 G0}eYtz2rD2P1r#Lc?<17@nь%T˂N_Nl5^/z9-"Y7%,ܽD~N8,[I֚G8a>\}ko // I$K2J\P5$;ݻ@Fz:(4'',UO 0"x7Gm$L*4ˤ *A6 sP˷倕1y6( ,5 5A;(B.ik7*3r-w`ꌪJo鿐&?|VW2MLHР0#f3|w8f?ϧv~ 41ˡ>Swg#\d@heYѽ bvv*|餇bP',p"/PϬI! Y jzƈܚ"Y mf3%9>ו?NL3&6j G/eʵrtfڋD*MarIMQZ) (McCDtpc٬2on<I>k#gؔ 0D?zvUB& Wkp! m FlpP"͜vHdX,XCm*;MN2kl>Vo*CIQN ۟ (܋7RWf)0 MW_SESSION['LabID']."'"); if ($uprice_stock=="") $uprice_stock =0; if ($qty_saleReturn-$qty_stock==0){ mysqli_query($con,"update item set qty=0,uprice=0 where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); }else{ $uprice=(($qty_stock*$uprice_stock)-($qty_saleReturn*$uprice_purchase))/($qty_stock-$qty_saleReturn); mysqli_query($con,"update item set uprice=$uprice where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); } updateQty($con,$itemid); return 0; } if(isset($_POST['btnSave'])){ $invno = $_POST['invno']; $amt = $_POST['amt']; $actype = $_POST['actype']; $extracharges =0;// $_POST['extracharges']; $paid = $_POST['paid']==""? 0: $_POST['paid']; $transport = $_POST['transport']==""? 0: $_POST['transport']; $Discount = $_POST['Discount']==""? 0: $_POST['Discount']; $date_ = date('Y-m-d',strtotime($_POST['date_'])); $actypeold=""; if (getName($con,"select 1 from saleReturn2 where invno='$invno' and LabID='".$_SESSION['LabID']."'")=="") { echo "Add Item First"; }else{ $qry="update saleReturn2 set actype='$actype',date_='$date_',paid=$paid,discount='$Discount',transport='$transport' where invno='$invno' and LabID='".$_SESSION['LabID']."'"; //echo $qry; mysqli_query($con,$qry); $actypeold=getName($con,"select actype from saleReturn2 where invno='$invno' and LabID='".$_SESSION['LabID']."'"); } $amt=$amt-$Discount; mysqli_query($con,"delete from ledger where saleReturnNo='$invno' and LabID='".$_SESSION['LabID']."'"); $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,$actid,$paid,$amt,$LabID)"; //echo $qry; mysqli_query($con,$qry); if($paid>0 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($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']; $discount= 0; $percentage = $_POST['percentage']; if($percentage>0){ $uprice=$sprice-($sprice*$percentage/100); }elseif($uprice>0){ $percentage=(100*(($sprice*$qty)-($qty*$uprice)))/($sprice*$qty); $uprice=$sprice-($sprice*$percentage/100); } $discount=($sprice*$qty)-($uprice*$qty); $amount=$qty*$uprice; $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 actid='$actid' and itemid='$itemid' and invno='$invno'")!=""){ $ret=deleteStock($con,$itemid,$invno); mysqli_query($con,"delete from saleReturn where itemid='$itemid' and actid='$actid' and invno='$invno'"); } $qry="insert into saleReturn (sprice,discount,percentage,uprice,date_,invno,actid,itemid,qty,pprice,LabID) values('$sprice','$discount','$percentage','$uprice','$date_',$invno,$actid,$itemid,$qty,$pprice,$LabID)"; mysqli_query($con,$qry); $ret=addStock($con,$itemid,$invno); $pur = getName($con,"select sum(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'")=="") $qry="insert into saleReturn2 (time_,date_,invno,actid,amount,LabID) values('$time_','$date_',$invno,$actid,$pur,$LabID)"; else $qry="update saleReturn2 set 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(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); //updateQty($con,$itemid); } function addStock($con,$itemid,$saleReturnNo){ $qty_saleReturn = getName($con,"select (qty) from saleReturn where itemid='$itemid' and invno='$saleReturnNo' and LabID='".$_SESSION['LabID']."'"); if ($qty_saleReturn=="") $qty_saleReturn =0; //$uprice_purchase = getName($con,"select (uprice) from saleReturn where itemid='$itemid' and invno='$saleReturnNo' and LabID='".$_SESSION['LabID']."'"); if ($uprice_purchase=="") $uprice_purchase =0; $uprice_purchase = getName($con,"select pprice from saleReturn where itemid='$itemid' and invno='$saleReturnNo' and LabID='".$_SESSION['LabID']."'"); if ($uprice_purchase=="") $uprice_purchase =0; $qty_stock = getName($con,"select (qty) from item where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); if ($qty_stock=="") $qty_stock =0; $uprice_stock = getName($con,"select (uprice) from item where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); if ($uprice_stock=="") $uprice_stock =0; if ($qty_saleReturn+$qty_stock==0){ mysqli_query($con,"update item set qty=0,uprice=0 where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); }else{ $uprice=(($qty_stock*$uprice_stock)+($qty_saleReturn*$uprice_purchase))/($qty_stock+$qty_saleReturn); mysqli_query($con,"update item set uprice='$uprice' where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); } updateQty($con,$itemid); return 0; } echo "
"; echo "
"; ?>

"; echo "
Inv#Item Name
Size/Model		qtyDatePriceQty%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 "
$cnt$name$size$model$stock"; echo "
".$row['invno']."$name
$size		$stock"; $recName=getName($con,"select receiverName from sale2 where invno='".$row['invno']."' and LabID='$LabID' "); echo "
".$recName; //echo ""; echo "		"; 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']; $amt=$uprice*$qty; echo ""; echo "$cnt$name$sprice"; echo "$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 = $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 "
"; ?>