Overall Sales Screen"; print ""; print ""; $month=substr($monthyearonly,0,2); $year=substr($monthyearonly,2,4); //print "

$stock_ref - $monthyearonly $hostcompanyid $currency $month $year

"; $sql=" SELECT viamedquote_orders_invoices.invoiceref, viamedquote_orders_invoices.invoicecommitedon FROM viamedquote_orders_invoices group by viamedquote_orders_invoices.invoiceref"; $stmt = pdoquery($sql); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $invoiceref=$row['invoiceref']; $invoicecommittedon[$invoiceref]=$row['invoicecommitedon']; } $sql="SELECT * FROM viamedquote_orders_details where viamedquote_orders_details.stockref=? group by orderid"; $stmt = pdoquery($sql, array($stock_ref)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $orderid=$row['orderid']; $orderpricelist[$orderid]=$row['pricelist']; //print "$orderid $row[pricelist]
"; } $sql="SELECT count(stockref) as totalcount , viamedquote_orders_invoices_details.invoiceref , viamedquote_orders_invoices_details.deliveryid , viamedquote_orders_invoices_details.goodstotal , viamedquote_orders_invoices_details.orderid, viamedquote_orders.company_id FROM viamedquote_orders,viamedquote_orders_invoices_details WHERE viamedquote_orders_invoices_details.stockref=? and viamedquote_orders.hostcompany=? and viamedquote_orders_invoices_details.orderid=viamedquote_orders.id group by viamedquote_orders_invoices_details.invoiceref, viamedquote_orders_invoices_details.stockref, viamedquote_orders_invoices_details.deliveryid order by invoiceref "; //print "$sql
"; $lowestdate=$nowis; $highestdate=0; $stmt = pdoquery($sql, array($stock_ref, $hostcompanyid)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); $currenctcodelist['ALL']='ALL'; $headerdisplay .= ""; foreach ($rows as $row) { $invoiceref=$row['invoiceref']; $invcommitdate=$invoicecommittedon[$invoiceref]; $orderid=$row['orderid']; $pricelist=$orderpricelist[$orderid]; $deliveryid=$row['deliveryid']; $currenctcode=isset($currencypricelist[$pricelist]) ? $currencypricelist[$pricelist] : ''; $companyid=$row['company_id']; //print "$invoiceref $invoicecommittedon[$invoiceref]
"; // is POS FLow or Negative Flow if ($deliveryid >0) { // Invoice So Positive $mod=1; } else { $mod=-1; // Credit so Negative Flow } $qtyinvoiced=$row['totalcount']*$mod; $goodstotal=$row['goodstotal']*$mod; $datemonthlink=date("mY",$invcommitdate); $datemonthpricelistlink=date("mY",$invcommitdate).$pricelist; $prndate=date("d M Y",$invcommitdate); $float = 0; // Assuming float is 0 $id = ''; // Assuming id is empty string if ($monthyearonly==$datemonthlink) { $displayline[$prndate] .= ""; $total=$total+$qtyinvoiced; } $companyidlist[$companyid]=$companyid; $datemonthcustomerlink=date("mY",$invcommitdate).$companyid; $customerdisplaylineqty[$datemonthcustomerlink] = (isset($customerdisplaylineqty[$datemonthcustomerlink]) ? $customerdisplaylineqty[$datemonthcustomerlink] : 0) + $qtyinvoiced; $customerdisplaylinevalue[$datemonthcustomerlink] = (isset($customerdisplaylinevalue[$datemonthcustomerlink]) ? $customerdisplaylinevalue[$datemonthcustomerlink] : 0) + $goodstotal; } ksort($displayline); foreach ($displayline as $line) { $headerdisplay .=$line; } $headerdisplay .= ""; $headerdisplay .= "

Invoice Reference	Date	Account	Company	Qty	Raw Value	Currency	Pricelist
".operadoclinks($x,$invoiceref,$float)."$invoiceref	$prndate	CID$companyid	"; $displayline[$prndate] .= ""; $displayline[$prndate] .= linkcrm($x,$companyid,$id).getcompanyname($companyid)."	$qtyinvoiced	$goodstotal	$currenctcode
			TOTAL	$total

"; $lowestdateyear=date("Y",$lowestdate); $highestdateyear=date("Y",$highestdate); print "$headerdisplay"; ?>