public function actionChart_year($year = null)
{
$config = new \app\models\Config_system();
$month = $config->MonthFull();
$title = "ยอดกำไร - ขาดทุน ปี พ.ศ. ";
$title .= $year + 543;
$labels = "รวมทั้งปี";
$report = new Report();
$result = $report->Report_year_table($year);
$sum_expenses_row = 0;
$sum_total_row = 0;
$sum_income = 0;
$sum_outcome = 0;
$income_month = 0;
$allowance_driver = 0;
//$value_income[] = 0;
//$value_outcome[] = 0;
foreach ($result as $rs) {
$sub = $report->Subreport_year($year, $rs['MONTH']);
$income_out_transport = $report->sum_income_out_transport_month($year, $rs['MONTH']);
$outgoing = $report->sum_get_outgoing_month($year, $rs['MONTH']);
//ค่าใช้จ่ายเกี่ยวกับการวิ่งทะเบียนนี
$expenses_truck = $report->sum_expenses_truck_month($year, $rs['MONTH']);
//ค่าใช้จ่ายเกี่ยวกับรถ
$salary = $report->sum_salary_month($year, $rs['MONTH']);
//เงินเดือนพนักงานและรายได้คนขับคันนี้
$engone_oil = $report->sum_engine_oil_month($year, $rs['MONTH']);
//ค่างเปลี่ยนน้ำมันเครื่อง
$annuities = $report->sum_annuities_month($year, $rs['MONTH']);
//ค่างวดรถ
$truck_act = $report->sum_truck_act_month($year, $rs['MONTH']);
//ค่าต่อทะเบียน พรบ.
$sum_expenses_row = (int) $outgoing + (int) $expenses_truck + (int) $salary + (int) $engone_oil + (int) $annuities + (int) $truck_act;
//รวมค่าใช้จ่าย
$allowance_driver = (int) $sub['allowance_driver1'] + (int) $sub['allowance_driver2'];
//รวมเบี้ยเลี้ยง 2 คน
$sum_total_row = $sub['income'] + $income_out_transport - $sum_expenses_row;
$income_month = $sub['income'] + $income_out_transport;
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 + ($sub['income'] + $income_out_transport);
//รายได้รวมทุกเดือน
$sum_outcome = $sum_outcome + $sum_expenses_row;
//รายจ่ายรวมทุกเดือน
}
//$val_income = implode('', $value_income);
//$val_outcome = implode('', $value_outcome);
return $this->renderAjax('chart', ['category' => $month, 'title' => $title, 'labels' => $labels, 'val_income' => $value_income, 'val_outcome' => $value_outcome, 'sumIncome' => (int) $sum_income, 'sumOutcome' => (int) $sum_outcome]);
}
<div class="row">
<div class="col-xs-12 col-sm-6 col-md-4 col-lg-4">
<div class="form-group">
<div class="input-group">
<div class="input-group-addon">ประจำเดือน</div>
<select id="month" name="month" class="form-control">
<?php
$monthnow = date("m");
if (strlen($monthnow) > 1) {
$month = $monthnow;
} else {
$month = "0" . $monthnow;
}
$month_val = $config->Monthval();
$month_full = $config->MonthFull();
for ($i = 0; $i <= 11; $i++) {
?>
<option value="<?php
echo $month_val[$i];
?>
" <?php
if ($month_val[$i] == $month) {
echo "selected = 'selected' ";
}
?>
>
<?php
echo $month_val[$i] . " - " . $month_full[$i];
?>
</option>
