public function actionChart_month($year = null, $month = null)
{
$config = new \app\models\Config_system();
$months = $config->MonthFullKey();
$title = "ยอดกำไร - ขาดทุน ปี พ.ศ. ";
$title .= $year + 543;
$title .= " เดือน " . $months[$month];
$labels = "รวมทั้งเดือน";
$report = new Report();
$result = $report->Report_month($year, $month);
$sum_expenses_row = 0;
$sum_total_row = 0;
$sum_income = 0;
$sum_outcome = 0;
$income_month = 0;
foreach ($result as $rs) {
$day[] = $rs['DAY'];
$sum_expenses_row = $rs['oil_price'] + $rs['gas_price'] + $rs['expenses_around'] + $rs['fix_truck'] + $rs['income_driver'] + $rs['truck_period'] + $rs['truck_act'];
$sum_total_row = $rs['income'] - $sum_expenses_row;
$income_month = $rs['income'];
if (empty($income_month)) {
$income = 0;
} else {
$income = $income_month;
}
if (empty($sum_expenses_row)) {
$outcome = 0;
} else {
$outcome = $sum_expenses_row;
}
$value_income[] = (int) $income;
$value_outcome[] = (int) $outcome;
$sum_income = $sum_income + $rs['income'];
//รายได้รวมทุกเดือน
$sum_outcome = $sum_outcome + $sum_expenses_row;
//รายจ่ายรวมทุกเดือน
}
//$val_income = implode('', $value_income);
//$val_outcome = implode('', $value_outcome);
return $this->renderAjax('chart', ['category' => $day, 'title' => $title, 'labels' => $labels, 'val_income' => $value_income, 'val_outcome' => $value_outcome, 'sumIncome' => (int) $sum_income, 'sumOutcome' => (int) $sum_outcome]);
}