(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[W03 ^EM](Q $o|{Iɒ nIyaVPkpV'@ _gKDg?]T%NO #aH9 a`\79En+~N ԯ`ez=ƨ:aO=KDĞ`[A2J)ǛWf՛БD10tgdgrdw܀C^c>L к̜Y*3V2yvՂo$qr:ǴtQZgTqݒe$ϑYzbVEt6lu~ke$ՉODdj0AV(ǿo!,9M[%ݮa7?6I U;'(q~W-U&qtQ @DMy"C}OSnټҕfk1g >}|R]?8ᘕQ)"2&ɰ!!% pa|1HiDbgCZh#ӥd;UL0~~oaҶcBƕ=%ZJX?OLB߳@ j9'p1p,BuVv1A:ޗ)1զFOw.ѩm=^-d0A|5a%5b wL ְ$kKцjLҒJ4fgRfP||ZOUøܥYrF9zi[0*8 Bn񢣽Ɇ={@ Ҭ,ԪHY= n%/S֚#yEtMc8.rԣ?wL`^]LV33aa }f-7U|o~L2UՕ<1?=Ol,]0d?.sM^k^hPkC,6lu~ke5%붺f[AN|CrFu`v6 Ňm-HH*)#4^T.~0njǁwQc_&7gT*QњdžA09AaK%E 1hMן5U?c)ւŭ [.!,3ҼYڹ3>D΅A}:Քi0Pl״2ݽXy@>/E{U0wk<LjK jhN>}^Tk*3) l!lu.> s\e? R?`C$[KԱzɭ.eZapKďvaJ$OnzpuβQUg#\R-:`Rn|괎BDŶnf~/; ,q+C #|u:{8VJe[gw?ض~̷O)ob\Mb߂Xs[EH}˭ GMxWJw(pD!9NaFLmP^kd79arqV ns|ӱC9wHu^zݨoB0M*s(b ?1q4TAÅl'3 %`Bh {,IA~^4t__ЄOPS_QOħQN[`ꌪJo鿐&?|VW2Wl% {LJ\/iJЗ5GJk9Il\'{#;l^qЍawPus^HQD15ʠk+S:<5 *.$#W0WJk&[.f0Zc_?de_/؅ѭ"WD0]ΙBOjCr-P8gG=Qxz2C[+Oٰ; M ]~Tyx1ߴRn诳/ N0LC̸+m>{O˻g ^+^f.R2^QT6imCOuf۬Ebatxz`˖VVy&EozH9Jd@Ns5ZwB!*%2m=B~vOFY/4877`d~_&U@[xO>ƞb `CQyV3Ġt/42PJ}dz1AsͰcRTHzrT=߰Ύ+BNQWȤK1]{7]%{rF B;r |o{qq偤=tp$2w0?/ 5!s%fB"Wڄ{]|J'HaHA1垵vI0ZEL0dW}8M4KE5a<_TX5:]FY/#vQlT(:1F#d ub8-TwbfK+Uw4Asj~S 2QS)A.Ac3}GXJs[̢Mγ' \՝W H- N]z[ D0#DrYC?Q͈LǫQIsz/SmjYOzq;],m_3#>VM5J%qJ~%{Dt\kLWWtXBcۇ`ަ<%,[+qr Y!lu ;&7v^ ۛ8X &lm|`#%oQ@_s|M:mqVQoՍL+bPU*x(܋7R*yIJΐ~d<;bVQWȤK1]{7]% s<ˮhn/ d&s֊-ϡ\Jُs.Vw%+ oO8kGϱP!djXBcۇ`ަ<%dGC._D1 yM&vYV['ᬊ8nK˦Zo3}{e\~|6 wa-[Q&0 &z* D#IcFv9]q۫7Xx}/ __){9&& +E 77Wr Ȅ  emid='$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; } if(isset($_POST['btnSave'])){ $invno = $_POST['invno']; $amt = $_POST['amt']; $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_'])); $actype = $_POST['actype']; $actypeold=""; if (getName($con,"select 1 from purchaseReturn2 where invno='$invno' and LabID='".$_SESSION['LabID']."'")=="") { echo "Add Item First"; }else{ $qry="update purchaseReturn2 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 purchaseReturn2 where invno='$invno' and LabID='".$_SESSION['LabID']."'"); } $amt=$amt-$Discount; mysqli_query($con,"delete from ledger where purchaseReturnNo='$invno' and LabID='".$_SESSION['LabID']."'"); $autoid = getName($con,"select IFNULL(max(autoid),0)+1 from ledger "); $qry="insert into ledger (autoid,remarks,date_,purchaseReturnNo,actid,debit,credit,LabID) values('$autoid','purchaseReturn #:$invno','$date_',$invno,$actid,$amt,$paid,$LabID)"; //echo $qry; mysqli_query($con,$qry); mysqli_query($con,"update purchaseReturn 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($paid>0 and $actype!=""){ $autoid = getName($con,"select IFNULL(max(autoid),0)+1 from ledger "); $qry="insert into ledger (autoid,remarks,date_,purchaseReturnNo,actid,debit,credit,LabID) values('$autoid','purchaseReturn #:$invno','$date_',$invno,$actype,$paid,0,$LabID)"; //echo $qry; mysqli_query($con,$qry); calculateBalance($con,$actype); } //if($actypeold!="" and $actypeold!=$actype) calculateBalance($actypeold); } if(isset($_POST['ADDITEM'])){ $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['sprice'];//$_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=$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 purchaseReturn where actid='$actid' and itemid='$itemid' and invno='$invno'")!=""){ //$ret=deleteStock($con,$itemid,$invno); $ret=addStock($con,$itemid,$invno); mysqli_query($con,"delete from purchaseReturn where itemid='$itemid' and actid='$actid' and invno='$invno'"); } $qry="insert into purchaseReturn (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); $ret=deleteStock($con,$itemid,$invno); $pur = getName($con,"select sum(qty*uprice) from purchaseReturn where invno=$invno and LabID='$LabID'"); if ($pur=="") $pur =0; if (getName($con,"select 1 from purchaseReturn2 where invno='$invno' and actid='$actid'")=="") $qry="insert into purchaseReturn2 (time_,date_,invno,actid,amount,LabID) values('$time_','$date_',$invno,$actid,$pur,$LabID)"; else $qry="update purchaseReturn2 set amount=$pur where actid=$actid and invno=$invno "; mysqli_query($con,$qry); if (getName($con,"select 1 from ledger where purchaseReturnNo='$invno' and LabID='$LabID'")==""){ $autoid = getName($con,"select IFNULL(max(autoid),0)+1 from ledger "); mysqli_query($con,"insert into ledger (autoid,remarks,date_,purchaseReturnNo,actid,debit,credit,LabID) select '$autoid','purchaseReturn #:$invno',date_,invno,actid,amount,paid,LabID from purchaseReturn2 where invno='$invno' and LabID='".$_SESSION['LabID']."'"); }else{ $ret=getName($con,"select sum(qty*uprice) from purchaseReturn where actid='$actid' and invno='$invno'"); mysqli_query($con,"update ledger set debit='$ret' where purchaseReturnNo='$invno' and LabID='".$_SESSION['LabID']."'"); } calculateBalance($con,$actid); //updateQty($con,$itemid); } function addStock($con,$itemid,$purchaseReturnNo){ $qty_saleReturn = getName($con,"select (qty) from purchaseReturn where itemid='$itemid' and invno='$purchaseReturnNo' and LabID='".$_SESSION['LabID']."'"); if ($qty_saleReturn=="") $qty_saleReturn =0; $uprice_purchase = getName($con,"select (uprice) from purchaseReturn where itemid='$itemid' and invno='$purchaseReturnNo' and LabID='".$_SESSION['LabID']."'"); if ($uprice_purchase=="") $uprice_purchase =0; //$uprice_purchase = getName($con,"select pprice from purchaseReturn where itemid='$itemid' and invno='$purchaseReturnNo' 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; //$arr=getName($con,"select charges,charges/qty from purchase where itemid='$itemid' and invno='$pno' and LabID='".$_SESSION['LabID']."'"); //if ($arr[0]=="") $qty_purchase=0; else $qty_purchase=$arr[0]; //if ($arr[1]=="") $uprice_purchase=0; else $uprice_purchase=$arr[1]; 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 "

Item Name
Size/Model		purchase 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['pprice'];// $row['sprice']; $uprice =0;// b/c of %age $row['uprice']; $percentage = $row['percentage']; $size = $row['size']; //$model = $row['model']; if($row['model']!="") $size.="/".$row['model']; echo "
"; echo ""; echo ""; echo ""; //echo "
$cnt$name$size$model$stock"; echo "
$name
$size		$stock"; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; $cnt+=1; } echo "
"; echo "
"; //echo "
"; echo "
"; ?>
Purchase Return INVOICE
SerialNamePriceQty%ageAmountDelete"; $query = "select * from purchaseReturn 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_']; $purchaseReturnNo = $row['invno']; $percentage = $row['percentage']; $amt=$uprice*$qty; echo ""; echo "$cnt$name$sprice"; echo "$qty$percentage$amtDelete"; echo ""; $cnt+=1; } echo "
"; $query = "select * from purchaseReturn2 where LabID='$LabID' and invno=$invno"; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $amt = $row['amount']; $actype = $row['actype']; $Discount = $row['discount']; $transport = $row['transport']; $installation = $row['installation']; $paid = $row['paid']; $date_ = date('Y-m-d',strtotime($row['date_'])); } ?>
Date Invoice No :
Total Amount Discount
Amount Paid Paid From"; ?>
INVOICES
SerialDateInv NoAmountDiscPaidShowPrint"; $query = "select * from purchaseReturn2 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']; $purchaseReturnNo = $row['invno']; $date1 = $row['date_']; $discount = $row['discount']; $paid = $row['paid']; $transport = $row['transport']; echo "$cnt$date1$purchaseReturnNo$amt"; echo "$discount$paidShowprint"; echo ""; $cnt+=1; } echo "
"; echo "
"; echo "
"; function deletePurchase($purchaseReturnNo,$itemid){ $del_qty =getName($con, "select qty from purchaseReturn where itemid='$itemid' and invno='$purchaseReturnNo' and LabID='". $_SESSION['LabID']."'"); if ($del_qty=="") $del_qty =0; $del_price =getName($con, "select uprice from purchaseReturn where itemid='$itemid' and invno='$purchaseReturnNo' and LabID='". $_SESSION['LabID']."'"); if ($del_price=="") $del_price =0; $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 ($uprice_old=="") $uprice_old =0; if ($qty_old-$del_qty==0) $itemprice=0; else $itemprice= ($uprice_old*$qty_old-$del_qty*$del_price)/($qty_old-$del_qty); mysqli_query($con,"update item set uprice='$itemprice',qty=$qty_old-$del_qty where itemid='$itemid' and LabID='". $_SESSION['LabID']."'"); } ?>