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]); }