(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[WݿbZI>ub}r]oP0̰Mc{86rjW@)ަ8煷*3V2yvՂo$qr:ǴtQZgTqݒe$ϑ65d]>HYv*^?*eu @*.WV?)8DpsMz,sv UT#X*u@cCidWé2gO=G q `U\?f20^<j)fۺW # _Jf.=Rъ>P'*vBƭrMD#''I|X*4sҬs_7p_[.$H؉Z9; Xn޸Er3s@&\AGf̫vT{LMfg25PTބ9Ω T,kLv$*`:wxšo }Zd38J~m \^~8ޠiP4D.vXP/\L }=#&=J>d4II,Q0Ȣ3je(ʈT?P5#@LM Vz([_=(2V)GdyeGT4qXJr5jhQ{ +RCb獹ofNo'4Î^(MQNq`%Y# + Hʞ:c. ;qq_MAOg-؎oUݧdп\i5wQ+4IJkTk(0j{|-H%Zjd3?>g)_dTo~D<E}-zΨϋzY0{+7653Jr4dĀ aB׵b5}z)քXy`eah}`.N!4nOa͘,*CkI h|vv'NaRT(WHŧ}K_9MiNi)-K.7"9.0m;tJ{9wv Mo  q^ꊷP&1I!Klڂh-8'>4J"xsIGPgcv.c^Y2gيgCͼ66}6Ue5}\nt/,zDz. inrƳ[4vQ;>>A \_V7wUPOB ݋G[1a8-ei↑pS-i:q-ў H %!ͧ }{e\~|6'uM'> $ݫrKɾ- BPUY*sw +Uw4Asj~S 2QS)A.Ac3}G{畜EaiJ5=,T83-"JMV0HrhR2 !SvNB\d@hed/ (iha?/)7lBGܛQeuӠ.w$ - T:y\d@hea{eSN fdъZG5L#;UVRpWvFG/B@FC:<*Ol>Lӊ!+D*pL# Fvv$W/ ̲UO 0"x7G?a'D٫%6߽ D0^@f99A y`b{)eo&(^ !sWllxM{,9giS\$HכR:;t\ _d@FWS)fYM淏4$=j>psJ+1GDRʠ.hns QWȤK1]{7]%]sG֩ӱ{<0r4=~0vBW&9)b}8?K(($q @>zXv6#ne J\@Pk^~f+ɄR&skלf@ز)Qj[J5L&O!gSqy\nB)/W")(a7 wRpWvF+00BBHCCBHC I֛/.mT ko' rxww\ϯ2؂qڙAk_ڙ,D9 Loɇe(U'\yv.c^Y2gqC8W*$ܪ IJy;8]X4EL)nek&K\uP iI@$/6u6TU=e\د pŹv?`ZB^=[ͻ f3Hon<I>k#gؔ 0D=y滛$=Fbz@r$G[Kj9'[ֿK Z$u FPW5nu0_W%9*X_e"l]&R%aG{#;l^qЍawPus^m:ʝ6n#e ȅ4m5jbtf̜G3T4ηG|O8kGϱP!dj*;MN2kl>Vo*CIQN ۟ (܋7RWf)0 MWUH mY/8k1CO^}VȰ [ZԽW±Nkx/5Ћ`O1Ui=+e"M87Q1Eo5d퇸 9L }'rIyC9БwPML۔:@)"r:辑o&(^ !sWllxM{,9g_r9z*Ă?ShEv*śe,yI;^r\֜Ikj2:c`jp\g5T٠~\4)S+o A&߄T:Tt Ut$).vMWR ZAhH o eNQ{=V蓀 !0Xt<snxpeN D?Q^.aٯ<rvtԂ*IVݍP,}~A  Alv0˪k'7Q1Eo5d퇸 9L }'rIyC9БwPML۔:@)"r:辑o&(^ !sWllxM{,9g4^f+lGH\sBpzX@C>T/(r\9qbV~IN2{>;7\uHW5?~3vAICEŻ;!XáRTiԱ?V$3T Cq;ܱYU&skלf@؎yfQ!rˉ T'[.vMWR ZAMRoApD 7w j{qty_sale =0; $uprice_sale = getName("select (uprice) from sale where itemid=$itemid and invno='$saleno' and LabID='".$_SESSION['LabID']."'"); if ($uprice_sale=="") $uprice_sale =0; $qty_stock = getName("select (qty) from item where itemid=$itemid and LabID='".$_SESSION['LabID']."'"); if ($qty_stock=="") $qty_stock =0; $uprice_stock = getName("select (uprice) from item where itemid=$itemid and LabID='".$_SESSION['LabID']."'"); if ($uprice_stock=="") $uprice_stock =0; if ($qty_sale==$qty_stock){ mysql_query("update item set qty=0,uprice=0 where itemid=$itemid and LabID='".$_SESSION['LabID']."'"); }else{ $uprice=(($qty_stock*$uprice_stock)-($qty_sale*$uprice_sale))/($qty_stock-$qty_sale); mysql_query("update item set qty=$qty_stock-$qty_sale,uprice=$uprice where itemid=$itemid and LabID='".$_SESSION['LabID']."'"); } updateQty($itemid); } if(isset($_POST['btnSave'])){ $invno = $_POST['invno']; $amt = $_POST['amt']; $paid = $_POST['paid']; $transport = 0; // $_POST['transport']; //$discount = $_POST['discount']; $receiverName = $_POST['receiverName']; $receiverCell = $_POST['receiverCell']; $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_'])); if (getName("select 1 from sale2 where invno='$invno' and LabID='".$_SESSION['LabID']."'")=="") { echo "Add Item First"; }else{ $qry="update sale2 set receiverName='$receiverName',receiverCell='$receiverCell',date_='$date_',paid=$paid,discount='$discount',transport='$transport' where invno='$invno' and LabID='".$_SESSION['LabID']."'"; //echo $qry; mysql_query($qry); mysql_query("update sale set date_='$date_' where invno='$invno' and LabID='".$_SESSION['LabID']."' "); } $amt=$amt-$discount; mysql_query("delete from ledger where saleno='$invno' and LabID='".$_SESSION['LabID']."'"); $autoid = getName("select IFNULL(max(autoid),0)+1 from ledger "); $qry="insert into ledger (autoid,remarks,date_,saleno,actid,debit,credit,LabID) values('$autoid','sale #:$invno','$date_',$invno,$actid,$amt,$paid,$LabID)"; //echo $qry; mysql_query($qry); //mysql_query("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'])){ $invno = $_POST['invno']; $itemid = $_POST['itemid']; $stock = $_POST['stock']; $qty = $_POST['qty']; if ($qty<=$stock){ $percentage = $_POST['percentage']; $uprice=$sprice= $_POST['sprice']; //$pprice=$_POST['uprice']; $pprice=getName("select pprice from item where itemid='$itemid'"); $unitPrice = $_POST['unitPrice']; $discount=0; $date_ = date('Y-m-d',strtotime($_POST['date_'])); //if($percentage != 0) $discount=$sprice*$percentage/100; //$uprice=$sprice-$discount; if($percentage>0){ $uprice=$sprice-($sprice*$percentage/100); }elseif($unitPrice>0){ $percentage=(100*(($sprice*$qty)-($qty*$unitPrice)))/($sprice*$qty); //$uprice=$pprice*$percentage/100; $uprice=$sprice-($sprice*$percentage/100); } $discount=($sprice*$qty)-($uprice*$qty); if (getName("select 1 from sale where actid='$actid' and itemid='$itemid' and invno='$invno'")=="") $qry="insert into sale (uprice,percentage,discount,date_,invno,actid,itemid,qty,pprice,sprice,LabID) values('$uprice',$percentage,$discount,'$date_',$invno,$actid,$itemid,$qty,$pprice,$sprice,$LabID)"; else $qry="update sale set uprice='$uprice',percentage='$percentage',discount='$discount',qty=$qty,pprice=$pprice,sprice=$sprice where actid=$actid and itemid=$itemid and invno='$invno'"; //echo $qry; if(mysql_query($qry)){ //echo "Data Saved "; } else echo "Error"; $pur = getName("select sum(qty*uprice) from sale where invno=$invno and LabID='$LabID'"); if ($pur=="") $pur =0; if (getName("select 1 from sale2 where invno='$invno' and actid='$actid'")=="") $qry="insert into sale2 (date_,invno,actid,amount,LabID) values('$date_',$invno,$actid,$pur,$LabID)"; else $qry="update sale2 set amount=$pur where actid=$actid and invno=$invno "; mysql_query($qry); $pur = getName("select sum(qty) from purchase where itemid=$itemid and LabID='$LabID'"); if ($pur=="") $pur =0; $sale = getName("select sum(qty) from sale where itemid=$itemid and LabID='$LabID'"); if ($sale=="") $sale =0; mysql_query("update item set qty=$pur-$sale,sprice=$sprice where itemid=$itemid and LabID='".$_SESSION['LabID']."' "); if (getName("select 1 from ledger where LabID='$LabID' and saleno='$invno'")==""){ $autoid = getName("select IFNULL(max(autoid),0)+1 from ledger "); mysql_query("insert into ledger (autoid,remarks,date_,saleno,actid,debit,credit,LabID) select '$autoid','Sale #:$invno',date_,invno,actid,amount,paid,LabID from sale2 where invno='$invno' and LabID='".$_SESSION['LabID']."'"); }else{ mysql_query("update ledger set debit=(select sum(qty*uprice) from sale where invno='$invno' and LabID='".$_SESSION['LabID']."') where saleno='$invno' and LabID='".$_SESSION['LabID']."'"); } calculateBalance($con,$actid); updateQty($itemid); }else { echo "

Sorry! Quantity Exceeded

"; } $i=1000; } //echo "
i=".$i; $query = "select * from sale2 where LabID='$LabID' and invno=$invno"; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $amt = $row['amount']; $discount = $row['discount']; $net=$amt-$discount; $transport = $row['transport']; $installation = $row['installation']; $paid = $row['paid']; $receiverName = $row['receiverName']; $receiverCell = $row['receiverCell']; $date_ = date('Y-m-d',strtotime($row['date_'])); } ?>
Inv No:
Date:
 Total Amount
 discount
 NetAmount
 Paid
 Name
 Cell No.
SerialDateNamePriceQty%ageupriceAmountDelete"; $query = "select * from sale where LabID='$LabID' and actid=$actid and invno='$invno' order by itemid asc"; $cnt=1; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $itemid = $row['itemid']; $name = getName("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_']; $saleno = $row['invno']; $amt=$uprice*$qty; echo ""; echo "$cnt$date_$name$sprice$qty".$row['percentage']."".$row['uprice'].""; echo "$amtDelete"; //echo "x"; //onClick=\"javascript:return confirm('are you sure you want to delete this?');\" echo ""; $cnt+=1; } echo "
"; echo "
SerialDateInvoiceNoAmountdiscountNetAmountPaidShowPrint"; $query = "select * from sale2 where LabID='$LabID' and actid=$actid order by date_ desc"; $cnt=1; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $amt = $row['amount']; $saleno = $row['invno']; $date1 = $row['date_']; $discount = $row['discount']; $paid = $row['paid']; $transport = $row['transport']; $net=$amt-$discount; echo "
$cnt$date1$saleno$amt"; echo "$discount$net$paidShowprint"; echo ""; $cnt+=1; } echo "

"; echo "
"; echo "
Search Item:"; //echo ""; echo ""; echo "
"; //echo "

Admin Panel

"; echo "
"; echo "
SerialNameSizeModelStockDatePriceQty%ageuPriceAdd"; if ($anyvalue=="") $query = "select * from item where LabID='$LabID' and status=0 order by itemname asc"; else $query = "select * from item where LabID='$LabID' and status=0 and (itemname like '%$anyvalue%' or model like '%$anyvalue%' or size like '%$anyvalue%') order by itemname asc"; $cnt=1; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $id = $row['itemid']; $name = $row['itemname']; $stock = $row['qty']; $pprice = $row['pprice']; $uprice = $row['uprice']; $sprice = $row['sprice']; $size = $row['size']; $model = $row['model']; echo "
"; echo ""; echo ""; echo ""; echo ""; echo "
$cnt$name$size$model$stock"; echo ""; //echo ""; echo ""; //echo "
Generate Salary"; echo ""; echo ""; echo ""; $cnt+=1; } echo "
"; echo "
"; ?>