Wduw{Aó*19ôKam*t}reP!BjiK >8۠ 4]O7)o[^&e6?J3/N*Dz56p#h0vNSbH8 :jWx19s1TΊ|yлXabN v,lKSWmgk;mCZ!(L9zV JxvNK*kKIX/hx2,d,a&߿+!!GGFX2*jSe3FUaeig!UT!6r#`Uwtkr~@8n Г.+{: ".^(}\Yox ɑrC' (me `L0~Nk O==/M4&Bb/a/.fp;jt;wO B>7ܑlmgtAڒu봁r-'&u :I,Ǚ?+ qN5:F2$˾hF*Ok.߿^ eKpo͐*ݏQ|YW?XEvOҞMfA5î+CD})ejXڟX‰rVrP6|WX-HJWaO\-vD\>P("a <MBΗq?qx꬙$qiJwg|g7I{3Iyv~UoM:;4y1~Úۗ-CKjǢ]X5W{oPa- )EV$B4W44˜:̜8]ψ(2}CF>3y~'[i.` +BnTcXcQx4*߮8WGSSY6()R@sf>EU =G妺ĶwBz8ɤ,Z .餒E_:pݬYVׄ=ÁwѨ#Z6@i:rԝa높k-A8R=SYYdꬶ@靮XL 7Sj :U R2˚T(.6#8Rr U_B;.=Q䣥%A3 3%Cz27Kψpo͐*ݏQ|YW?XEvOҞMfA5î+CD})ejXڟX‰rVrP6|WX-HJWaO\-vD\>P(" -e,D5)r'9Y\SGڜU3t`_xγt mJvL?Qlg*AI;QWѸ/6DR7k{j^/aIwzm#3e9{D]̂u-"}*C}trOIQ>1Ī̻[w .Y8 lq,"+]8yaqN UyL3*;_]0I[C!]Z#ɖz/.H%xB.;rAeNO2ѻ=s̾cҩ}E';+7o1lzbj >a1E Grn@! Zd22)hSر|#Ϋ$Y [EEK*3ےhym+.w n> K^S;M_tvvpr8rBM4acI*,4֣hs4[ _eyiddXي &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^heQ!mFT 9Hvo@'11h/p>ᩛ]SĽCdjӛmfT "@Z;7xF:tEW}YkJJqwL [IAK0^JU?u*y w17~j'Lݟr__6erEFqFN^iۢ&V\*P"Ǩg}Ua“^+<_6M_&r,5V;p ՋcdR%HOR2Ȁ?qiVLY!-oEXChB{B3O(:8RtS4Ӫ1z4\Vk3Iӊ27;O\LwS`B*w^KW@6'/]Pe@~A&77nl:`6 ѴXyX$Wc;E(mJ ,|?N 947m*V@[q YD`PCRP]Y HHS_aײg:HpPùy+8M! ݏuǏ)0tE QT$y94~Kj/9 f;΁:{A (4S;D?>v&O3lhp fPA@gU/hV(n}r@1P'5b/nNВC3Baj2l\a{iǓ,WoGkŠuvjlia]o߀t=yĀOWJ H5\Ȗcs@3j|f c17(zĢ×gQ2O6؄@*&|$ JdYKȂ͝:5`tL5kLwindow.open('temporaryInvoice?from=$from','_self')"; 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('temporaryInvoice,'_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'); $poNo=odbc_result($cur,'poNo'); $qty=odbc_result($cur,'qty'); $pPrice=round(odbc_result($cur,'pPrice'),2); $tPrice=round(odbc_result($cur,'tPrice'),2); $percentage=round(odbc_result($cur,'percentage')); $remarks=odbc_result($cur,'remarks'); $fID=odbc_result($cur,'rPrice'); } } ?> HOME
Date
Customer
PO No.
Weigth
Rate
Percentage
Remarks
Image

"; 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;$total=$totalqty=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
#DatePO_NoCustomerRemarksWeightRateAmount%ageAmount"; $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; if(odbc_result($cur,"img")!="") echo "".odbc_result( $cur, 'remarks' ).""; else echo "".odbc_result($cur,'remarks'); echo "".round(odbc_result( $cur, 'qty' ),2); $totalqty+=odbc_result( $cur, 'qty' ); echo "".round(odbc_result( $cur, 'pPrice' ),2); $amount=odbc_result($cur, 'qty')*odbc_result( $cur, 'pPrice' ); $total+=$amount; echo "".round($amount); echo "".round(odbc_result( $cur, 'percentage'),2); echo "".round($amount*odbc_result($cur,'percentage')/100,2); echo "" ; echo "" ; } echo "
Summary".round($totalqty,2)."".round($total,2).""; echo "
"; ?>