(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[WݿbZI>ub}r]oP0̰Mc{8QoFp1kH# )wYDly5 .L:ɞ!o:v6aoSLʇJ0~燉jYR6Wy/r9R&,1^|^DמĔ".^Zf_m~ځ&TkXhWdtns{&@:h/r*xݎ .Imܤa-r mŮ k-BD<%kY^ J+&*~ OJ$恆ΜRG!qaHhR% "Uc&pQ/*tvX %G F~ 5]eF.Y{ö̤xgh/Y24hD 66+#(NK2tG|6b٥5 )W`}tD@Mn4v{EF[קł&8ŬϚ]qN3S[Vg#kO[7tN61T=L[uXߏrDK;P@(fB;0h`Rfmg}:<ybsIVvC^jYK 7Mc-zv2&$Ҥnԏ\5iWU3t`_xγt h)O='LYfn$!jWU'PL1,$ l5$u5Dž(B%`SdoO9CULq"* }f>ϱ;Rp;.[V 6*cG@c|d{MkXf 'Yy&-ĭ'п5hNL}=BR;]I`;Ϊ@? Yu?OH@tʜ{C?VШCxxu# ?$ J!F`j&Z,dז}u\3[¢)wAp>:IڏepN>6.!$lI[_挖ƮBL$nӃqa ݶCkWJᬅӥk攚VB^涰Ϝԣc>(Ӹ=xGH = C~ìzD|ֺc_sp" XT*&cֻ1WDunѰGl 7`bFPx(he}K_.B[1+W # F1C ?@t#ﰿHHh]=~i FU \h"MOsO}:D$@@"9u\l{ɑ :ǿ]l;nDh9j(d8[7 gc]@=L_]?k'kXO Zbӥ?-" ǵL/rc?C[(j%t>k cj< Fw2a;GHl}҅HUTK/K?~Ytt<=@t7"#)?s-6{dtM. u'OHO.Ƃ2O'q>y+b3r΃oKGfI>|tQIFvDvP|t>dxxϩ(KI3$g9ւRg A֡Qίp_ή/]*!L{!>Ki6D$gMzh-O%tǍ=ˑsBi'峼QoŸAkϧfiL\ 숃0FJIH^6PjTGs{`Uq}\mÖC b+"wzEwgR?Dj30>TǮ sM9D8,fA>GSW#l n.P#3?d{;0qa}4[`uS8]Uۻr!6[m2#5xdwsRB V)Hf^z(?|r,aW1;|^QكۿvbN'\tMT[^}OERaTࣻ?(P(img @ z (ɘިנ 90jOSπTK/Ͼef4uVP#3?dϞ9l^qUb]ZWA*A.&vFEGzw$ofbߕI ѱf4uVP#3?d46Yʼn]ZWA*A.&vFxPƺ` S $"/b꿺A߯oĔ 'C9|нb$09shk&lF[6^o jLzlC5@vP=rhG?z865) ؜#& (I)Z1 Ǘ6< 9MrD5#r. }p /* Item Type Color */ //include("db.php"); //update accounts set date_=CURRENT_DATE() where date_ is null if(isset($_POST['submit'])){ //include("db.php"); $itemid = protect($_POST['itemid']); $itemname = protect($_POST['itemname']); $size = protect($_POST['size']); $model = protect($_POST['model']); $pprice = protect($_POST['pprice']); $sprice = protect($_POST['sprice']); $Percentage = protect($_POST['Percentage']); if($Percentage=="") $Percentage=0; $d_id = protect($_POST['d_id']); $itemtype ="";// protect($_POST['itemtype']); $itemcolor ="";// protect($_POST['itemcolor']); if ($itemid =="") { $itemid = maxno("item","itemid"); $query = "insert into item (itemtype,itemcolor,status,pprice,sprice,itemid,itemname,size,model,Percentage,LabID) values ('$itemtype','$itemcolor',0,'$pprice','$sprice','$itemid','$itemname','$size','$model','$Percentage','$LabID')"; } else { $query = "update item set itemtype='$itemtype',itemcolor='$itemcolor',itemname='$itemname',size='$size',model='$model',sprice='$sprice',pprice='$pprice' where itemid='$itemid'"; } if(mysql_query($query)){ //echo ""; //echo ""; //echo ""; } } if (isset ($_GET['edit'])) { //include("db.php"); $itemid = $_GET['edit']; $query = "delete from item where itemid='$itemid'"; //$run = mysql_query($query); } if (isset ($_GET['delItem'])) { $itemid = $_GET['delItem']; $isStock=getName("select 1 from purchase where itemid='$itemid' "); if($isStock=="") $isStock=getName("select 1 from sale where itemid='$itemid' "); if($isStock==""){ //$query = "delete from item where itemid='$itemid'"; mysql_query("delete from item where itemid='$itemid'"); }else{ echo "Sorry! Stock Cant be deleted"; } } //echo "

Admin Panel

"; echo "
SerialNameSizeModelTypeP_PriceS_PriceQtyEditDelete"; echo "
"; $query = "select * from item where LabID='$LabID' and(itemname like'%$anyItem%' or size like'%$anyItem%' or model like'%$anyItem%') order by itemid desc"; $cnt=1; $pAmt=0; $sAmt=0; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $itemid = $row['itemid']; $itemname = $row['itemname']; $size = $row['size']; $model = $row['model']; $pprice = $row['pprice']; $sprice = $row['sprice']; $itemtype = $row['itemtype']; $itemcolor = $row['itemcolor']; $qty= $row['qty']; //$pAmt+=$qty*$row['uprice']; $pAmt+=$qty*$row['pprice']; $sAmt+=$qty*$sprice; echo "
$cnt$itemname$size$model$itemtype$pprice$sprice$qtyEdit"; echo "del"; $cnt+=1; } $qty=$sAmt-$pAmt; echo "
Summary$pAmt$sAmt$qty"; //echo "
Generate Salary"; //echo ""; //echo ""; //echo ""; ?>