I:ܫc+]YF3KD $ײ >WTqNp"#z>]伽mo&c^S`@0k5*s9 )&UHroGJqGFll*i$Lq~-AZ+j ^,ݏ!4 sD䊔a#=_5&Ӂ\h@YjĶ,4UaM*/fy=)sлXabN v,lKSWmgk;mCZ!(L9zV JxvNK*k6i̷&kX;m*;ULjBՑw8s!~ŰyOAVEP*1ǔ(t˶ֈ)D?4" k KgVkR ej=j'v,p4x"9FABDZ)IDF"| .Hm'sz˒ >FxZC5a3S-nyG  -6&~颺L֖};*D@M'\j8OVQ_CPOiƀv4"-eVU]DvZ$%+_E44˜:̜8]SpH伶Xli>'2# ՀybI´>;ӓG@ՆydA/䂡Zcbw<xg=0B*NnU^r8N?".j\[#0mҌkrM"v8FL,qMDI#•ޱfE,6ƚ3zEao\}{HY-Lgm]vbHw &<ϯ **ymcƱU R2˚T(.6#8Rr ,,zU%tdtm>-B{CpRS{}Q׬:fpçxMl!g1i;F070~Nk O==XX\yMX‰rVrP6|WX-HJWaO\-vD\>P(" -e,D5)r'9Y\SGܸ WCTg|g7I{3sH O`[*'Xˠv%u?cLKK% 68"R$2NXo=;gÒvul\eKm(H+]4WCF?5ܣ /Ma&pP;IZ=ufMɳ\VݹO^c,oV~L<i_=+cڼ|2-؋!'I\hӢ8- 2L+ëh kBy}:pdUWrΒW$LEX>`ܝ-3@ކP82Iz[4X R+F/<4v( ^Ԅd\{$lFBb5JN} dlMſ=xFY'cB/ֽOOSdU$;iQwuXmP7aXD5sFSs2;jFB{q:aKC8@ca`߮8WGSJV,zn W ,VEmjcLdp:%~H oI(ϝ;nK;qy})ejXڟX‰rVrP6|čtg]vm{W3}trOIQ>1 Sk~ ٧^Ρ 4pdUWrrq?+w.]0>2CffPRS1^uf1iS]sZ#d'&_zm,m+D5wJ*a@͠f)L(x,aȎŠ^f5ge0yn.N+pF`fd(otO Z55\nsl%ic|r&aNTKF) R1UnzƹFLjxpj(iUlL@j~ath 4`! 7!bR;CS'^i1e+ 4L!ZaK%}u+dq|oFǯgEe)c=%{ S&} 3V$a>cFIVKHaQ@NJ(}R%'V}A3sL"R= ]NQf:fq~!R8݆/o j=F%&^ ~"iw?eSKolFơ`j:uz,fCK ?++읛Xm1-[6yqw|*rt7j.>Sk*#jЊͱvgjatܨB\wY[9x)"Q#ͬUZ$':޶( @Ŭl)Ń0˃GwZƅlKSWmgk;mCZ!(L9zV JxvNK*k lvr౅ !V؃UZm4k3.1@[lN1 (}EfzRS@U;߉6#E)W>\w4qF6@!PX1A~NE4o.K-LXYȎ^Aߤ%y5z:MʓL5Y>?w4qF6@!PX1A~NyQ =Y>"B)B>3bǹn8ayRa~JZ./;M ($9ɡ&3zg`荟BVźuriBRzR,YЅL<Aݒ*3i,HD/ޣe^ö3%5QЍHk#I;@vy;<ᐯݪ!bL);0{/%?K oo%gՏb jTl@j齽}#N&+HʆfңmRR(Tba4՝yp ^SiCFaϞ(0Q v|'v y8MK(X 4mng])t&Un,-f;0jD!C&Ta"sZMc`5v㛏 s_j7m׊fYk's+Y5<"; exit2($conn,$conn3); } } 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_' ))); $expiry= date("Y-m-d", strtotime(odbc_result( $cur, 'expiry' ))); $accountID=odbc_result($cur,'accountID'); $invno=odbc_result($cur,'invno'); $closeStatus=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
From Date
to Date
PO No.
Remarks
Weigth
Rate

"; echo "
"; 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' "; if(isset($_REQUEST['anyvalue']) and $_REQUEST['anyvalue']!="") $query.=" and poNo='".$_REQUEST['anyvalue']."' "; $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 "
#From Dateto DateRemarks"; $date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' ))); $invno=odbc_result($cur,'invno'); echo "
".$cnt++."$date2"; echo "".date("d.m.y", strtotime(odbc_result($cur,'expiry'))); echo "".odbc_result($cur,'remarks'); //echo "".round(odbc_result($cur,'qty' ),2); $total+=odbc_result($cur,'qty')*odbc_result($cur,'pPrice' ); //echo "" ; echo "" ; echo "" ; } echo "
"; ?>