rep_capacity.php

<?php
// $flagNoAuth = true;
require ('common/auth.php');
require ('classes/budget.class.php');
require ('classes/reports.class.php');

include ('includes/inc_report_settings.php');

$oBudget = new Budget($budget_scenario);
$oReport = new Reports(Array('budget_scenario'=>$budget_scenario));

// if ($reference!=$oBudget->reference_scenario->id){
	// $oReference = new Budget($reference);
	// $strVsTitle = ' vs '.$oReference->title;
// } else {
	// $reference = $oBudget->reference_scenario->id;
// }

include ('includes/inc-frame_top.php');
echo '<h1>',$arrUsrData["pagTitle$strLocal"],': ',$oBudget->title,$strVsTitle,'</h1>';

include ('includes/inc_report_selectors.php');
echo '<p>',$oBudget->timestamp,'; ',$oBudget->rates,'</p>';

$sql = "SELECT pol, pod, cntTitle, cntYUNAS, rteTitle, gbr, POL.prtTitle as polTitle, POD.prtTitle as podTitle,
		".$oBudget->getMonthlySumSQL($oBudget->offset+1, $oBudget->offset+12)." 
		FROM reg_sales
		LEFT JOIN vw_counterparty ON cntID=customer
		LEFT JOIN tbl_route ON rteID=route
		LEFT JOIN tbl_port POL ON POL.prtID=pol
		LEFT JOIN tbl_port POD ON POD.prtID=pod
		WHERE posted=1 AND kpi=1 AND activity IN (48,63) AND scenario='{$oBudget->id}' AND company='{$company}'
		GROUP BY pol, pod, customer, route, gbr
		ORDER BY route, pol, pod, customer";
$rs = $oSQL->q($sql);
?>
<table class='budget' id='capacity_report'>
	<thead>
		<tr>
			<th>Trade</th>
			<th>SAP/GBR</th>
			<th>Customer</th>
			<th>CustomerID</th>
			<th>POL</th>
			<th>POD</th>
			<?php echo $oBudget->getTableHeader('monthly',$oBudget->offset+1,$oBudget->offset+12);?>
			<th>Total</th>
		</tr>
	</thead>
<?php
while ($rw = $oSQL->f($rs)){
	?>
	<tr>
		<td><?php echo $rw['rteTitle'];?></td>
		<td><?php echo $rw['gbr']?"Y":"";?></td>
		<td><?php echo $rw['cntTitle'];?></td>
		<td><?php echo $rw['cntYUNAS'];?></td>
		<td title="<?php echo $rw['pol'];?>"><?php echo $rw['polTitle'];?></td>
		<td title="<?php echo $rw['pod'];?>"><?php echo $rw['podTitle'];?></td>		
		<?php 
			$rowTotal = 0;
			for ($m=$oBudget->offset+1;$m<=$oBudget->offset+12;$m++){
				$month = $oBudget->arrPeriod[$m];
				$rowTotal +=$rw[$month];
				echo '<td class="budget-decimal">',$oReport->render($rw[$month]),'</td>';
			};
		?>
		<td class="budget-ytd budget-decimal"><?php $oReport->render($rowTotal);?></td>
	</tr>
	<?php
}
?>
</table>
<?php
include ('includes/inc-frame_bottom.php');



?>