IQ96YH_u ,G6k9dd: 5U\P|2=q[(9 Pװ}(<γx )&UHroG[Xb.fz&p1 |P)Qڡdm jެ>D$&_ITiㇾ xnҒ ?ni̍rkʳ^}Åt{RN jh#CC#PyE K_ìD:"&{CdLq"ֳHmbrXI`YV)Me-.⣎OkǥfCA젏ZD/PA09O\CIWҁ?~F(bS%Rώ+1]{~[|BZyDQYrK_Ba0ͱ9ZI?MF-"$Qzr15v45%e V;C/a/.fp.JG W NGŊF2Y!xQI5Lu 59𹬢B؉Ȩo¢ |^ 5'愯jcLdp:%~fA6,44˜:̜8]SpH伶Xli>'2# ՀybI´>;ӓG@ՆydA/䂡Zcbw<xg=0B*NnU^r8N?".j\[#0mҌkrM"v8FL,qMDI#•ޱfE,6ƚ3zEao\}{HY-Lgm]vǝ5u@CVC~YG^An8H56l޽eWpGw_@dgI ?:Xyf8p1Rr[3!3 ,7,'+ (]{2dH}0s0XPǰhyY fo탊gڈ$ R]s]tLNlc妪B!SV--Ҕ"s^rJ~Z&u :IVذ}|^ 5'愯jcLdp:%~zHdKez_ӰUI6%>5IH߃b#Y{`ү6`RȉyzކP82Iz"ډ[9ɛ1_lnߎ؉leon*Ow*tufQ;WV4xglVt[8g R,+J+xt2覊Z7QL$Q-e<qy %ZHjg;L:[^һOtza?zbM6e|_X>rHSfӱBVbwEvSY}o]H{Kf d Ꭺ U.yUg"k9'=E`M j_:4aR9XG_6.؝D) CJ s;N&ejkq hݥIyf]>Xq?ɢtE@ѕC#!E$f8+X- -Iߧ>eä"Z^\C*S櫫 m*$zHƧ觪&̷c/.04h- 8ɭ'Re:*U|̖AmԞYe.a v,/ɪiQQW^4d״}}3E>BĩJr'K]p]P;Ɓep۳O3>#la/l"W ]!  _w==_#`o )9,4yR9Pah04`Nq'(Z A[ZLJvh.tA"⤛M{ I1y 0?Y>\j!,vەH$x1xu*OOL,˜(]UKܧO LGCs_qu&H[eC̥HKqHdpG aoB1WMI/7%i܋tg-8>(AFb8^Kr .6\>[4n]`U/+#I.cޟ.;E$89!6ω8}k@_9'nU .\dcPg~3a8Ĩf̲](,hAMµ;^-vSiƢ[ȕs'[ɉ/d)Ze$@^D*1Zh!QGݙҋ1?ZOgCz~>&n07~ET]-a_Mz[vaMpp\CAYwL62MS.u}3ғ\|o<-pPUAt]샜&u>t0Ar|oGI%؍C7LuxoV!VeS#fP8o:%5Tl'Z1{in 8U}HKcӿ]ZB >q>z!ϴXJj _ǃc x|J`psKEt)%)6hpeG*GoB{s sl![D@zL^tjջjo1Hl+t` *?7=E' ~*[Ͽ!OkOjog.rM{nԛ5".7PT G4U{9E1! yW%mT v(Q] 0?YqJ8"fA[׉=h.KμsCYxrqMJ3*wH)]^ĠXW;,S&Op:;{=i~ 'iE^TG^. F_m?2t"sg4ʖ[ 7'W9/4gKSR'K(eV,yY?O g.8[I/e;vZNֱGc!dư(纑j3*ݹ^*\Y0R`џO$y%~Ee"]); $target_file = $_SESSION['photosFolder']."/".$picname; if(move_uploaded_file($temp_name, $target_file)){ //$oldImg=getName($conn,"select img from itemInOut where invno='$invno' and labid='".$_SESSION['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 ); } //exit(); //echo ""; //exit(); } } $invno= "";$qty= ""; $incomeTax=$remarks= "";$percentage= ""; $pPrice= "";$date_= "";$accountID= "";$poNo= "";$anyvalue= ""; $accountName= ""; $medicineCompany=""; $Status=0;$tPrice="";$Salary=0; //$date_ = $from = $to = date('Y-m-d',time()); if(isset($_REQUEST['from'])) $from = date('Y-m-01',strtotime($_REQUEST['from'])); if(isset($_REQUEST['to'])) $to = date('Y-m-d',strtotime($_REQUEST['to'])); if (isset($_GET['accountID'])) $accountID = $_GET['accountID']; if (isset($_GET['ID'])) $accountID = $_GET['ID']; if (isset($_GET['delinvno'])){ //$accountID = $_GET['accountID']; if(canDelete($conn,"temporaryInvoice")=="0"){ $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 ) ) { $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'); $incomeTax=odbc_result($cur,'incomeTax'); } } ?> HOME
Date
Customer
PO No.
Weigth
Rate
Percentage
Remarks
incomeTax
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; $netAmt1=$totalTaxValue=$netTotal=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
#DatePO_NoCustomerRemarksWeightRateAmount%ageAmountTaxValueNet_Amt"; $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); $net=$amount*odbc_result($cur,'percentage')/100; echo "".round($net,2); $netAmt1+=$net; $tax=$net*odbc_result($cur,'incomeTax')/100; echo "".round($tax,2); $totalTaxValue+=$tax; $net=$net-($net*odbc_result($cur,'incomeTax')/100); echo "".round($net,2); $netTotal+=$net; //echo "".round($amount-$net,2); echo "" ; echo "" ; } echo "
Summary".round($totalqty,2)."".round($total,2)."".round($netAmt1,2)."".round($totalTaxValue,2)."".round($netTotal,2).""; echo "
"; ?>