Wduw{Aó*19ôKam*t}'tE}Zش٪|wv|~40;8} #^-ɼ 'Bl{˽1/nOf.~~+޸yjkߪRG{@BٓhV[<;͂  E^+'Fu]yehTHf/WX7bz~M0EPHB9y`%3,LE zr-ŬڱLʪC5հq2FوJM8-6&~颺L֖}8C3,O R.%9 1Ip#ǧd՗> 4 ~۪y5V/w|$rF^^j 3CECn`^ v'#d~8<2#,rhW+'dPVʘz|v,p4x"[:2#y7fmG(̯]xޡs{Q϶7UR+{: "UREP~Gh[-ՉyЕRQy}Lv'?jbctAڒu봁r-'Y=uAML<0?k[DK OA"M9@M>P*Ņy@+)HZ} X`o+38G~<xg=0B*NnU^r8N?".j\[#0mҌkrM"v8FL,qMDI#•ޱfE,6ƚ3zEao\}{HY-Lgm]vz&[iDmthM>P*Ņy@+)HZ} X`o+38G~<xg=0B*NnU^r8N?".j\[#0mҌkrM"v8FB $Gu 2y_}Mqv(@-"' }Q䣥%A3 3%C5Y@dlxe+L ;4k>{ 47m)~nϸGZsIm(ҫWfݕj~A߮8WGSJVQ*_ez:fpçxMl!g1i;F07'V8}jL dEq 8u8*WqѾcu}CL5zms}%{7 ^vXٕt/We,rX T9bx: 7 )"Ld ealҕT@^Fg u()][ L_ }+>MƽKtRKG1B;?#HcK\R7NL&P)C4a{ᰅĘk]P!8]Ό%'E E}^p70*P(Sp' uOoKH$A;d-b$-Dj^s-$!Aي &yxnt4ECXǘ1(߹˫pݐf=쉒Ͼ/ߴ-F7WTb t or:7m膖{dj>ܩल.9疬XlD$5".7PT G4U|։/07rjW..;e  tDwAH\N|\F׃[[X2^ 2[,$С4g}{ H`׻%i#@?T9h;} #- Eu)C^c:᧢pL-Ch[ԻW{<0D=62cB<}f}KUs3{?J'~_f=d24q?jJBM˸$R2 !SvNB^ y'}Be)G*5".7PT G4U|։/07rjW..;e  t C «)_3bQ\|w^hݵVއ"wsDlIbv1ZSL(u!fixJ5EwQ6a =YnY%w.`E< 㶈@!-oEXChB{B3OFHȶ&~³s4ݙҋÔgc5D"0erG7MEG N+WepXtq`$@VmƢ&L2>sUt ^p\yn%PIbi'V ~|^<59侏ҙlu(3h$TBNnzf|b _zU4w"^r;bjs3s#OSG0BnE5q.4So0?+dUbY4} ɟʹhWtV5#OM)zm挸+!w$BArvkgq>BՅ&$Ror4n'0U)C#vnˋl sLá66}6Ue5-TJ/ION['labid']."' and recordType='$recordType'"); if ($oldImg!="") unlink($_SESSION['photosFolder']."/$oldImg"); $query="update itemInOut set img='$picname' where invno='$invno' and labid='".$_SESSION['labid']."' and recordType='$recordType' "; $cur= odbc_exec( $conn, $query ); } */ echo ""; exit(); } if (isset($_GET['accountID'])) $accountID = $_GET['accountID']; if (isset($_GET['ID'])) $accountID = $_GET['ID']; if (isset($_GET['delinvno'])){ //$accountID = $_GET['accountID']; $query=getName($conn,"select accountID from ledger where invno='".$_GET['delinvno']."' and labid='".$_SESSION['labid']."' and recordType='$recordType' "); $cur=odbc_exec($conn,"delete from ledger where invno='".$_GET['delinvno']."' and labid='".$_SESSION['labid']."' and recordType='$recordType' "); if(is_array($query)){ for($i=0;$iwindow.open('purchaseOrder,'_self')"; } if (isset($_GET['editinvno'])){ //$accountID = $_GET['accountID']; $query="select * from itemInOut where invno='".$_GET['editinvno']."' and labid='".$_SESSION['labid']."' and recordType='$recordType' "; $cur=odbc_exec($conn,$query); while( odbc_fetch_row( $cur ) ) { $from=$date_= date("Y-m-d", strtotime(odbc_result( $cur, 'date_' ))); $accountID=odbc_result($cur,'accountID'); $invno=odbc_result($cur,'invno'); $batchNo=odbc_result($cur,'batchNo'); $qty=odbc_result($cur,'qty'); $pPrice=round(odbc_result($cur,'pPrice'),2); $tPrice=round(odbc_result($cur,'tPrice'),2); $discount=round(odbc_result($cur,'discount')); $remarks=odbc_result($cur,'remarks'); $fID=odbc_result($cur,'rPrice'); $poNo=odbc_result($cur,'poNo'); $companyID=odbc_result($cur,'uPrice'); } } ?> HOME
Date
PO No.
Customer
Company
Remarks
Weigth
Rate

"; echo "
"; ?> "; echo ""; echo ""; echo "
"; // $query= "select * from itemInOut where (date_ between '$from' and '$to') and invno>0 and labid='".$_SESSION['labid']."' and recordType='$recordType' "; if($accountID!="") $query.=" and accountID='$accountID' "; $query.=" order by date_ asc,invno asc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1;$wt1=$wt2=$total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
#DatePO No.CustomerCompanyRemarksWeightDeliveredFactoryRateAmount "; $date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' ))); $invno=odbc_result($cur,'invno'); echo "
".$cnt++."$date2"; echo "".odbc_result($cur,'poNo').""; $accountName=getName($conn,"select stdName from student where ID='".odbc_result($cur, 'accountID')."' and recordType='Account'"); echo "".$accountName; $accountName=getName($conn,"select stdName from student where ID='".odbc_result($cur, 'uPrice')."' and recordType='Account'"); echo "".$accountName; if(odbc_result($cur,"img")!="") echo "".odbc_result( $cur, 'remarks' ).""; else echo "".odbc_result($cur,'remarks'); echo "".round(odbc_result($cur,'qty' ),2); $qtyDelevered=getName($conn,"select sum(qty) from itemInOut where poNo='".odbc_result($cur,'poNo' )."' and recordType in('PurchaseDirect','Sale') "); echo "".round($qtyDelevered,2);//factory weight $wt1+=$qtyDelevered; $qtyDelevered=getName($conn,"select sum(sPrice) from itemInOut where poNo='".odbc_result($cur,'poNo' )."' and recordType in('PurchaseDirect','Sale') "); echo "".round($qtyDelevered,2);//factory weight $wt2+=$qtyDelevered; echo "".round(odbc_result($cur,'pPrice' ),2);//factory weight echo "".round(odbc_result($cur,'qty')*odbc_result($cur,'pPrice' ),2);//factory weight $total+=odbc_result($cur,'qty')*odbc_result($cur,'pPrice' ); echo "" ; echo "" ; echo "" ; echo "" ; } echo "
Summary".round($wt1,2)."".round($wt2,2)."".round($total,2); echo "
"; ?>