<?php
if($br_id==0){
	$label = '';
	$price = '';
	$i=0;
	$s="select sum(ts_total) as total_ex,g_br.br_id,g_br.br_name from expense_list 
	inner join g_br on expense_list.br_id = g_br.br_id
	where (ts_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') and g_br.br_id <> 999 and g_br.br_id >0
	group by g_br.br_id
	order by g_br.br_id asc";
	$q=mysql_query($s);
	while($f=mysql_fetch_array($q)){
		$label .= "'".$f['br_name']."',";
		$p_sum .= number_format($f['total_ex'],2,'.','').",";
	}
	$s="select sum(total_cost) as total_cs from consume_rec 
	inner join g_br on consume_rec.br_id = g_br.br_id
	where (wd_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') and g_br.br_id <> 999 and g_br.br_id >0
	group by g_br.br_id
	order by g_br.br_id asc";
	
	$q=mysql_query($s);
	while($f=mysql_fetch_array($q)){
		$p_sum2 .= number_format($f['total_cs'],2,'.','').",";
		
	}
	$label = substr($label,0,strlen($label)-1);
	$p_sum = substr($p_sum,0,strlen($p_sum)-1);
	$p_sum2 = substr($p_sum2,0,strlen($p_sum2)-1);
	?>
<script>
	var barChartData = {
		labels: [ <?=$label?>],
		datasets: [ {
			label: 'Expense',
			backgroundColor: window.chartColors.red,
			stack: 'Stack 0',
			data: [
				<?=$p_sum?>
				
			]
		},{
			label: 'Consume',
			backgroundColor: window.chartColors.green,
			stack: 'Stack 0',
			data: [
				<?=$p_sum2?>
				
			]
		}]
	};
</script>
	<?php
}else{
	$s="select * from expense_list
	where  (ts_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') and br_id = ".$br_id;
	$q=mysql_query($s);
	if($f=mysql_fetch_array($q)){
		$data = explode(';',$f['detail']);
		foreach($data as $value){
			$value2 = explode("-",$value);
			if(strlen($value2[0])>0){
				$label .= "'".$value2[0]."',"; 
				$p_sum .= number_format($value2[1],2,'.','').",";
			}
		}
	}
	$s="SELECT * FROM consume_rec
	where  (wd_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') and br_id = ".$br_id."
	ORDER BY wd_date DESC";
	$q=mysql_query($s);
	while($f=mysql_fetch_array($q)){
		$detail = explode(";",$f['detail']);
		foreach($detail as $value){
			$list = explode("-",$value);
			if($list[0] != ''){
				$s1="select * from consume_list where consume_id = ".$list[0];
				$q1=mysql_query($s1);
				if($f1=mysql_fetch_array($q1)){
					$cs_name[$list[0]] =  "'".$f1['consume_name']."',";
					$cs_cost  = $f1['consume_price']*$list[1];
					$cs_total[$list[0]] +=  $cs_cost;
				}
			}
		}
	}
	$cs_cost ='';
	$i=1;
	for($i==1;$i<=58;$i++){
		if($cs_total[$i]){
			$cs_label .= $cs_name[$i];
			$cs_cost .= $cs_total[$i].",";
		}
	}
	$label .= $cs_label;$p_sum .= $cs_cost;
	$label = substr($label,0,strlen($label)-1);
	$p_sum = substr($p_sum,0,strlen($p_sum)-1);
?>
<script>
	var barChartData = {
		labels: [ <?=$label?>],
		datasets: [ {
			label: 'Expense',
			backgroundColor: window.chartColors.red,
			stack: 'Stack 0',
			data: [
				<?=$p_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 = '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>