<?php
if($br_id==0){
	$label = '';
	$price = '';
	$i=0;
	$s="select * from expense_list 
	inner join g_br on expense_list.br_id = g_br.br_id
	where ts_date = '".date('Y-m-d')."' and g_br.br_id <> 999 and g_br.br_id >0
	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['ts_total'],2,'.','').",";
	}
	$s="select * from consume_rec 
	inner join g_br on consume_rec.br_id = g_br.br_id
	where wd_date = '".date('Y-m-d')."' and g_br.br_id <> 999 and g_br.br_id >0
	order by g_br.br_id asc";
	$q=mysql_query($s);
	while($f=mysql_fetch_array($q)){
		$p_sum2 .= number_format($f['total_cost'],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);
	
	$date = strtotime(date('Y-m-d'));
	?>
<script>
	var barChartData = {
		labels: [ <?=$label?>],
		datasets: [ {
			label: 'Expense',
			backgroundColor: window.chartColors.green,
			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 = '".date('Y-m-d')."' and br_id = ".$br_id;
	echo $s;
	$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,'.','').",";
			}
		}
	}
	$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.green,
			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: '<?=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>