<?php
if($br_id==0){
	$label = '';
	$price = '';
	$i=0;
	$s="SELECT SUM(rev_pay) AS sum_rev, SUM(p3) AS total_bill,g_br.br_name,order_list.br_id FROM order_list
	INNER JOIN g_br ON order_list.br_id = g_br.br_id
	where (pay_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59')
	GROUP BY order_list.br_id 
	order by g_br.br_id asc";
	$q=mysql_query($s);
	while($f=mysql_fetch_array($q)){
		$s1="select sum(ts_total) as total_cost from expense_list where br_id= ".$f['br_id']." and (ts_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59')";
		$q1=mysql_query($s1);
		$a1=mysql_affected_rows();
		if($f1=mysql_fetch_array($q1)){
			if($a1==1){
				$expense = $f1['total_cost'];
			}else{
				$expense = 0;
			}
		}
		$s1="select sum(total_cost) as total_cost from consume_rec
		where br_id = ".$f['br_id']." and (wd_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59')";
		$q1=mysql_query($s1);
		$a1=mysql_affected_rows();
		if($f1=mysql_fetch_array($q1)){
			if($a1==1){
				$consume = $f1['total_cost'];
			}else{
				$consume = 0;
			}
		}
		$all_cost = $expense + $consume;
		$label .= "'".$f['br_name']."',";
		$rev_pay .= number_format($f['sum_rev'],2,".",'').",";
		$total_cost .= number_format($all_cost,2,".",'').",";
	}
	$label = substr($label,0,strlen($label)-1);
	$rev_pay = substr($rev_pay,0,strlen($rev_pay)-1);
	$total_cost = substr($total_cost,0,strlen($total_cost)-1);
	
	$date = strtotime(date('Y-m-d'));
	?>
<script>
	var barChartData = {
		labels: [ <?=$label?>],
		datasets: [ {
			label: 'Revenue',
			backgroundColor: window.chartColors.blue,
			stack: 'Stack 0',
			data: [
				<?=$rev_pay?>
				
			]
		}, {
			label: 'Cost',
			backgroundColor: window.chartColors.red,
			stack: 'Stack 1',
			data: [
				<?=$total_cost?>
				
			]
		}]
	};
</script>
	<?php
}else{
	$label = '';
	$price = '';
	$i=0;
	$s="SELECT SUM(rev_pay) AS sum_rev, SUM(p3) AS total_bill,g_br.br_name,order_list.br_id FROM order_list
	INNER JOIN g_br ON order_list.br_id = g_br.br_id
	where (pay_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') and order_list.br_id=".$br_id."
	GROUP BY order_list.br_id 
	order by g_br.br_id asc";
	$q=mysql_query($s);
	while($f=mysql_fetch_array($q)){
		$s1="select sum(ts_total) as total_cost from expense_list where br_id= ".$f['br_id']." and (ts_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59')";
		$q1=mysql_query($s1);
		$a1=mysql_affected_rows();
		if($f1=mysql_fetch_array($q1)){
			if($a1==1){
				$expense = number_format($f1['total_cost'],2,".",'').",";
			}else{
				$expense = "0,";
			}
		}
		$s1="select sum(total_cost) as total_cost from consume_rec
		where br_id = ".$f['br_id']." and (wd_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59')";
		$q1=mysql_query($s1);
		$a1=mysql_affected_rows();
		if($f1=mysql_fetch_array($q1)){
			if($a1==1){
				$consume = number_format($f1['total_cost'],2,".",'').",";
			}else{
				$consume = "0,";
			}
		}
		$label .= "'".$f['br_name']."',";
		$rev_pay .= number_format($f['sum_rev'],2,".",'').",";
	}
	$label = substr($label,0,strlen($label)-1);
	$rev_pay = substr($rev_pay,0,strlen($rev_pay)-1);
	$expense = substr($expense,0,strlen($expense)-1);
	$consume = substr($consume,0,strlen($consume)-1);
	
	$date = strtotime(date('Y-m-d'));
?>
<script>
	var barChartData = {
		labels: [ <?=$label?>],
		datasets: [ {
			label: 'Revenue',
			backgroundColor: window.chartColors.green,
			stack: 'Stack 0',
			data: [
				<?=$rev_pay?>
				
			]
		},{
			label: 'Expense',
			backgroundColor: window.chartColors.orange,
			stack: 'Stack 1',
			data: [
				<?=$expense?>
				
			]
		},{
			label: 'Consume',
			backgroundColor: window.chartColors.red,
			stack: 'Stack 2',
			data: [
				<?=$consume?>
				
			]
		}]
	};
</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 = 'center';
						ctx.textBaseline = 'top';

						var padding = -10;
						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: 'bar',
			data: barChartData,
			options: {
				title: {
					display: true,
					text: '<?=$_REQUEST['st_date']." - ".$_REQUEST['fn_date']?>'
				},
				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>