rep_pnl_activity.php

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

include ('includes/inc_rep_activity.php');


if(!isset($_GET['tab'])){
	$oBudget = new Budget($budget_scenario);
	$arrJS[]='js/rep_pnl.js';
	// $arrJS[]='js/input_form.js';	
	include ('includes/inc-frame_top.php');
	echo '<h1>',$arrUsrData["pagTitle$strLocal"],': ',$oBudget->title,'</h1>';
	echo '<h2>',$subtitle,'</h2>';
	echo '<p>',$oBudget->timestamp,'</p>';
	?>
	<div class='f-row'><label for='budget_scenario'>Select scenario</label><?php echo Budget::getScenarioSelect();?></div>
	<?php
		if(!isset($_GET['ghq'])){
	?>
		<div id='ghq_filter'>
			<ul class='link-footer'>
			<?php
				$sql = "SELECT DISTINCT prtGHQ FROM vw_product_type ORDER BY prtGHQ";
				$rs = $oSQL->q($sql);
				while ($rw = $oSQL->f($rs)){
					?>
					<li><a href="<?php echo $_SERVER['PHP_SELF'],"?budget_scenario={$budget_scenario}&ghq=",urlencode($rw['prtGHQ']);?>"><?php echo $rw['prtGHQ']?$rw['prtGHQ']:"[None]";?></a></li>
					<?
				}
			?>
			</ul>
		</div>
	<?php
	}
	// Budget::getGHQTabs('reg_master', true);
	Budget::getActivityTabs('reg_master', true, "WHERE company='{$company}' ".$sqlActivityFilter);
	include ('includes/inc-frame_bottom.php');
} else {
	require ('classes/reports.class.php');
	include ('includes/inc_report_buttons.php');
	if ($_GET['tab']=='all'){
		$sqlWhere = "WHERE 1=1 {$sqlActivityFilter}";
	} else {
		// $sqlWhere = "WHERE activity in (SELECT prtID FROM vw_product_type WHERE prtGHQ=".$oSQL->e($_GET['tab']).")";
		$sqlWhere = "WHERE activity = ".$oSQL->e($_GET['tab'])."  {$sqlActivityFilter}";
	}
	// echo '<pre>',$sqlWhere,'</pre>';
	Reports::masterByCustomerEst($sqlWhere." AND scenario='$budget_scenario'");
	?>
		<ul class='link-footer'>
			<li><a href='javascript:SelectContent("report_<?php echo $_GET['tab'];?>");'>Copy table</a></li>
		</ul>
	<?php
}


?>