rep_customer_group.php

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

$oBudget = new Budget($budget_scenario);
$pc = $_GET['pc']?(integer)$_GET['pc']:$arrUsrData['usrProfitID'];

$sql = "SELECT customer_group_code, cntTitle, SUM(".$oBudget->getThisYTDSQL('ytd').") as YTD 
		FROM reg_master 
		LEFT JOIN common_db.tbl_counterparty ON cntID=customer_group_code
		WHERE 
			scenario IN ('{$arrSetup['stpFYEID']}','{$arrSetup['stpScenarioID']}') 
			AND company={$company}
			AND (pc={$pc} OR bdv={$pc})
			".Reports::GOP_FILTER."
		GROUP BY customer_group_code		
		ORDER BY YTD DESC
		LIMIT 50
		";
$rs = $oSQL->q($sql);
while ($rw = $oSQL->f($rs)){
	$arrJQCloud[] = Array('text'=>$rw['cntTitle'],'weight'=>(integer)$rw['YTD'],'link'=>"rep_sales_kpi_new.php?cntID={$rw['customer_group_code']}");
}

$arrJS[] = "../common/jquery/jQCloud/jqcloud/jqcloud-1.0.4.min.js";
$arrCSS[] = "../common/jquery/jQCloud/jqcloud/jqcloud.css";
include ('includes/inc-frame_top.php');
?>
<div id='cloud' style='width:1900px; height: 900px;'></div>
<script>
$(document).ready(function(){
	
	var width = $('body').css('width');
	var height = $('body').css('height')/2;
	$('#cloud').css({'width':width,'height':height});

	var words = <?php echo json_encode($arrJQCloud); ?>;
	
	$('#cloud').jQCloud(words,{
	  autoResize: true,
	  fontSize: {
		from: 6,
		to: 72
	  }	  
	});
});
</script>
<?php
include ('includes/inc-frame_bottom.php');