Wduw{Aó*19ôKam*t}_Ci.R+~8&H&h|DЁ[ޮ/^PyI2IAD}dM4!Ŭl)`rIRy=!ףr)|/}Z>YM!5߿;~t.y돱@l$iPuPZx֥ 4 ~۪y5V&HwFjf.d c+ Vt yhu=,puPEx =x.QPYN aJRm,-1Ԟ{i^:Ł-w sm$d &UjPն(4 ^Ԅd\{uu>>$q^B:F2$˾hF*膯$ &:P(" d8uGƔ_7q&r_3>o'Gʻ(~C*j\[#0mҌ1<@|/L!TQ!niRikȸw4qF6ilk, '܊khr+GCXc•ޱfEpDՕbe n.ZyR4_!]h)>vQ䣥%A3 3%C Jԯ>gw0~Nk O==/M4&Bb/a/.fp 6acO#!Ow}trOIQ>1 Sk~ #Y(7CُٞW|?Rx2kN2 c4$>xt{EuVq1*>USeʳsUX `MV-q2z g\}{HY-OlZFp$@v- |QɊYc\OoŕMܯz Q)HySrak'RXNRDλ& 4PC޽eWpGw_@dga iL(4 2-zxS|.oM'Gʻ(~C*j\[#0mҌ1<@|/L!TQ!niRikȸw4qF6ilk, '܊khr+GCXc•ޱfEpDՕbe n.ZyRκ_奅& JJJ800z^[56)M.L֋GRoŕMܯz Q)HySrqzN迧w,,+CF M?> zfOUϸ3Vd=) &/Y70M}(y}e=PDq,3 8hEWFSs2;jFB{q:a+J+xt2覊l0cMw Pl{SdӄT4>j\[#0mҌ1_$*'R^M+C+]avͲ;j8W`SC[>Ԡ^dW;BP@+6Ҙ|!~>9Zʓrٻf_bM GF/FHrT1CuyxbwEvSY7xU=5!5ăsZPxu4)յrzFtY庴՘k$iX2>5W i@M=2,P_QuۆT=g})pP9Vxp/K!ȡmU#>!֙` 1ߗ9]g'-`(ݠZxQ*,R"H(PY 59f%pb`xph ?ӕ\9Q |jIO!H[3\$*27֟h@rDE2$4s j2CPP-oGY:|MvbGݓP!4r&"AT#=nN Yۂ#4M\]D,cSf=JtJX|oj^d2MuE=jɳ>r'K]p]P;ƁD*T_1FYv(Oj>BOKvmm~F{=B"y3{D`kkk [,Չ7.~fVf`Q؄@*&|$ JdYKȂ͝Cj* d'kM.x<3~w`!J< +3lZ&YʋaZHi5{jnUB62~$!6MW*1E]vF'z>Tg;D?>O^xQ7y`;탏dT2\p6B2OlaGD{'"lW^Z\Ű$yTlFXhZNֱGc!dư(纑j3*ݹ^*\Y0R`џO$y%~EI:'/=pEq= #2g2E T?n']WF$K䝱r5DZlJ[u^I*sJF%=dZ/hСĕ)R<߷+^r, lz Ԡ[z$l z~h^M-Ev-*ԥ0^S5ǬӤO#ylkr)=DA26*4WM\ HCw|bZ^;8,~ylabid']."' 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 ""; } if (isset($_GET['sTax'])) $sTax = $_GET['sTax']; if (isset($_GET['ID'])) $sTax = $_GET['ID']; if (isset($_GET['delinvno'])){ //$sTax = $_GET['sTax']; $cur=odbc_exec($conn,"delete from itemInOut where invno='".$_GET['delinvno']."' and labid='".$_SESSION['labid']."' and recordType='$recordType' "); echo ""; } if (isset($_GET['editinvno'])){ //$sTax = $_GET['sTax']; $query="select top 1 * 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_' ))); $sTax=round(odbc_result($cur,'sTax'),2); $invno=odbc_result($cur,'invno'); $batchNo2=$batchNo=odbc_result($cur,'batchNo'); $qty=odbc_result($cur,'qty'); $pPrice=round(odbc_result($cur,'pPrice')); $tPrice=round(odbc_result($cur,'tPrice')); $discount=round(odbc_result($cur,'discount')); $remarks=odbc_result($cur,'remarks'); $paymentType=odbc_result($cur,'rPrice'); $sPrice=odbc_result($cur,'sPrice'); $serialno=odbc_result($cur,'serialno'); $location=odbc_result($cur,'location'); $address=odbc_result($cur,'address'); } } ?> HOME
Date
Incharge
Cell No
Tehsil
Address
Total Roti
Payments
Gharany
Volunteers
Donations
Remarks
Slip No.
Image
.
"; echo "
"; echo ""; ?> "; echo ""; ?> "; ?> "; $arr=array(0,0,0,0,0,0,0,0,0,0); //$query= "select * from itemInOut where (date_ between '$from' and '$to') and invno>0 and labid='".$_SESSION['labid']."' and recordType='$recordType' order by date_ asc,invno asc"; $query= "select * from itemInOut where (date_ between '$from' and '$to') and invno>0 and labid='".$_SESSION['labid']."' and recordType='$recordType' "; if($location!="") $query.=" and location='$location' "; $query.=" order by date_ desc,invno desc "; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1;$total=$tqty=$amt=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
#DateInchargeRemarksAddressRotiPaymentsGraanyVolunteersDonation"; $date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' ))); $invno=odbc_result($cur,'invno'); echo "
".$cnt++."$date2"; echo "".odbc_result( $cur, 'batchNo' ); //$accountName=getName($conn,"select stdName from student where ID='".odbc_result($cur, 'sTax')."' and recordType='Account'"); //echo "".$accountName; echo "".odbc_result( $cur, 'remarks' ); echo "".odbc_result( $cur, 'address' ); $tqty+=odbc_result( $cur, 'qty' ); $amt=odbc_result( $cur, 'qty' )*odbc_result($cur,'pPrice'); $amt+=odbc_result( $cur, 'qty' )*odbc_result($cur,'tPrice'); //freight echo "".round(odbc_result( $cur, 'qty' ),2); echo "".round(odbc_result($cur,'sPrice')); echo "".round(odbc_result($cur,'pPrice')); //grany echo "".round(odbc_result($cur,'tPrice')); //vol echo "".round(odbc_result($cur,'discount')); //vol echo ""; $total+=$amt; echo "" ; echo "" ; $i=0; $arr[$i++]+=odbc_result( $cur, 'qty' ); $arr[$i++]+=odbc_result( $cur, 'sPrice' ); $arr[$i++]+=odbc_result( $cur, 'pPrice' ); $arr[$i++]+=odbc_result( $cur, 'tPrice' ); $arr[$i++]+=odbc_result( $cur, 'discount' ); } echo "
Summary"; for ($i=0;$i<5;$i++){ echo "".$arr[$i]; } echo "
"; ?>