HOME

Date

PO No.

Truck No.

Status

Customer

Supplier

Company

Mine

Weigth

f/Weigth

Rate

Expenses

Driver No.

Remarks.

"; 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($paidStatus>=0) $query.=" and rPrice='$paidStatus' "; if($status>=0) $query.=" and tPrice='$status' "; if($anyvalue!=""){ if(is_numeric($anyvalue)){ $query.= " and (poNo='$anyvalue' or batchNo='$anyvalue' ) "; }else{ $company="select ID from student where stdName like'%$anyvalue%' and labid='".$_SESSION['labid']."' "; $query.= " and (remarks like '%$anyvalue%' or batchNo='$anyvalue' or uprice in($company) )"; } } $query.=" order by date_ asc,invno asc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1;$in=$out=$direct=$inExp=$outExp=$directExp=$wt1=$wt2=$total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "

Summary"; echo "						IN"; echo " OUT"; echo " Direct"; echo "	".round($in,2); echo " ".round($out,2); echo " ".round($direct,2); echo "				"; echo "	".round($inExp,2); echo " ".round($outExp,2); echo " ".round($directExp,2); echo "
#	Date	PO No.	Customer	Supplier	Company	Mine	Status	Weight	F/Wt:	Rate	Expenes	Amount	Truck	Paid				"; $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=""; if(odbc_result($cur,'taxAct')) $accountName=getName($conn,"select stdName from student where ID='".odbc_result($cur,'taxAct')."' 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'); $link=""; if(odbc_result($cur,'tPrice')==0){ $status='IN'; $in+=odbc_result($cur,'qty'); $inExp+=(odbc_result($cur,'discount')+odbc_result($cur,'qty')odbc_result($cur,'pPrice' )); $amt=(odbc_result($cur,'discount')+odbc_result($cur,'qty')odbc_result($cur,'pPrice' )); $link="stockIn?siteInvoiceNo=$invno"; }elseif(odbc_result($cur,'tPrice')==1){ $status='OUT'; $out+=odbc_result($cur,'qty'); $outExp+=(odbc_result($cur,'discount')+odbc_result($cur,'sPrice')odbc_result($cur,'pPrice' )); $amt=(odbc_result($cur,'discount')+odbc_result($cur,'sPrice')odbc_result($cur,'pPrice' )); $link="stockOut?siteInvoiceNo=$invno"; }else{ $status='DIRECT'; $direct+=odbc_result($cur,'qty'); $directExp+=(odbc_result($cur,'discount')+odbc_result($cur,'sPrice')odbc_result($cur,'pPrice' )); $amt=(odbc_result($cur,'discount')+odbc_result($cur,'sPrice')odbc_result($cur,'pPrice' )); $link="stockInDirect?siteInvoiceNo=$invno"; } if($link!="") echo "	".$status.""; else echo "	".$status; echo "	".round(odbc_result($cur,'qty' ),2); echo "	".round(odbc_result($cur,'sPrice' ),2); $qtyDelevered=getName($conn,"select sum(qty) from itemInOut where poNo='".odbc_result($cur,'poNo' )."' and recordType in('PurchaseDirect','Sale') "); echo "	".round(odbc_result($cur,'pPrice' ),2);//factory weight echo "	".round(odbc_result($cur,'discount' ),2);//Exp weight //echo "	".round(odbc_result($cur,'discount')+odbc_result($cur,'qty')*odbc_result($cur,'pPrice' ),2); echo "	".round($amt,2); $total+=odbc_result($cur,'qty')*odbc_result($cur,'pPrice' ); $wt1+=odbc_result($cur,'qty'); //echo "	" ; echo "	".odbc_result($cur,'batchNo') ;//Exp weight $paidStatus=odbc_result($cur,'rPrice'); if($paidStatus==1) $show="Paid(".date('d.m.y',strtotime(odbc_result($cur,'paidDate'))).")"; else $show="Un-Paid"; echo "	$show" ; echo "	" ; echo "	" ; echo "	" ; echo "	" ; } echo "

"; ?>