<?php 
if($br_id==0){
	$label = '';
	$price = '';
	$i=0;
	$s="select * from g_br where br_id <> 999 and br_id >0 order by br_id asc";
	$q=mysql_query($s);
	while($f=mysql_fetch_array($q)){
		$label .= "'".$f['br_name']."',";
		$total_bill = 0;
		$total_rev = 0;
		$dept = 0;
		$s1="select * from order_list where (order_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') and br_id = ".$f['br_id'];
		$q1=mysql_query($s1);
		while($f1=mysql_fetch_array($q1)){
			$total_bill += $f1['p3'];
			$s2="select sum(pay_total) as total_pay from order_pay where order_id ='".$f1['order_id']."'";
			$q2=mysql_query($s2);
			if($f2=mysql_fetch_array($q2)){
				$total_rev += $f2['total_pay'];
			}
		}
		$dept += $total_bill-$$total_rev;
		$dept_sum .= number_format($dept,2,'.','').",";
		$rev_sum .= number_format($total_rev,2,'.','').",";
	}
	$label = substr($label,0,strlen($label)-1);
	$dept_sum = substr($dept_sum,0,strlen($dept_sum)-1);
	$rev_sum = substr($rev_sum,0,strlen($rev_sum)-1);
	$date = strtotime(date('Y-m-d'));
	?>
<script>
	var barChartData  = {
		labels: [ <?=$label?>],
		datasets: [ {
			label: 'Revenue',
			backgroundColor: window.chartColors.green,
			stack: 'Stack 0',
			data: [
				<?=$rev_sum?>
				
			]
		},{
			label: 'Dept',
			backgroundColor: window.chartColors.red,
			stack: 'Stack 0',
			data: [
				<?=$dept_sum?>]
		}]
	};
</script>
	<?php
}else{
	$s="select * from job_main order by job_id asc";
	$q=mysql_query($s);
	while($f=mysql_fetch_array($q)){
		$label .= "'".$f['job_name']."',";
		$s1 = "select sum(price_total) as total_price from order_temp
		inner join order_list on order_temp.order_id = order_list.order_id
		where (order_list.order_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') and order_list.br_id = ".$br_id." and order_temp.job_id = ".$f['job_id'];
		//echo $s1;
		$q1=mysql_query($s1);
		if($f1=mysql_fetch_array($q1)){
			if($f1['total_price']>0){
				$rev_sum .= number_format($f1['total_price'],2,'.','').",";
			}else{
				$rev_sum .="0,";
			}
		}
	}
	$label = substr($label,0,strlen($label)-1);
	$rev_sum = substr($rev_sum,0,strlen($rev_sum)-1);
?>
<script>
	var barChartData = {
		labels: [ <?=$label?>],
		datasets: [ {
			label: 'Revenue',
			backgroundColor: window.chartColors.green,
			stack: 'Stack 0',
			data: [
				<?=$rev_sum?>
				
			]
		}]
	};
</script>
<?php
}
?>

<script>
	Chart.plugins.register( {
		afterDatasetsDraw: function ( chart ) {
			var ctx = chart.ctx;

			chart.data.datasets.forEach( function ( dataset, i ) {
				var meta = chart.getDatasetMeta( i );
				if ( !meta.hidden ) {
					meta.data.forEach( function ( element, index ) {
						// Draw the text in black, with the specified font
						ctx.fillStyle = 'rgb(255, 255, 255)';

						var fontSize = 12;
						var fontStyle = 'normal';
						var fontFamily = 'Helvetica Neue';
						ctx.font = Chart.helpers.fontString( fontSize, fontStyle, fontFamily );

						// Just naively convert to string for now
						var dataString = dataset.data[ index ].toString();

						// Make sure alignment settings are correct
						ctx.textAlign = 'right';
						ctx.textBaseline = 'top';

						var padding = 0;
						var position = element.tooltipPosition();
						ctx.fillText( dataString, position.x, position.y - ( fontSize / 2 ) - padding );
					} );
				}
			} );
		}
	} );
	window.onload = function () {
		var ctx = document.getElementById( 'canvas' ).getContext( '2d' );
		window.myBar = new Chart( ctx, {
			type: 'horizontalBar',
			data: barChartData,
			options: {
				title: {
					display: true,
					text: '<?=date('Y-m-d')?>'
				},
				tooltips: {
					mode: 'index',
					intersect: false
				},
				responsive: true,
				scales: {
					xAxes: [ {
						stacked: true,
					} ],
					yAxes: [ {
						stacked: true
					} ]
				}
			}
		} );
	};

	document.getElementById( 'randomizeData' ).addEventListener( 'click', function () {
		barChartData.datasets.forEach( function ( dataset ) {
			dataset.data = dataset.data.map( function () {
				return randomScalingFactor();
			} );
		} );
		window.myBar.update();
	} );
</script>