perbaikan 006

<?php
public function index(){
        // Proteksi
        if(session()->get('farmer_user') == "") {
            session()->setFlashdata('error', 'Anda belum login');
            return redirect()->to(base_url('farmer/login'));
        }
        // End proteksi
//-------------------BIKIN defaultnya dahulu
        $month = [];
        $total = [];
        for($i=1;$i<=12;$i++)
        {
            $month[$i]=date("F", strtotime('2000-'.$i.'-01');
            $total[$i]=0;
        }
    //-------------------
        $modelFarmers = new Farmers_model();
        $modelCrops = new Crops_model();
        $modelTrx = new Transaction_model();
        $farmer = $modelFarmers->check_user(session()->get('farmer_user'));

        $id_petani = $farmer['id'];
        $awal = strtotime('-1 year');
        $akhir = strtotime(date("Y-m-d"));
        $date_awal = date('Y-m-01', $awal); // Range Awal
        $date_akhir = date('Y-m-t', $akhir); // Range Akhir
//MONTHNAME(tanggal_transaksi) as month
        $sql ="SELECT harga, MONTH(tanggal_transaksi) as month, Year(tanggal_transaksi) as year, COUNT(tanggal_transaksi) as total, SUM(harga) as total_penghasilan FROM transaksi WHERE id_petani = $id_petani AND status = 'sukses' AND (tanggal_transaksi BETWEEN '$date_awal' AND '$date_akhir') GROUP BY MONTH(tanggal_transaksi) ORDER BY YEAR(tanggal_transaksi) ASC, MONTH(tanggal_transaksi) ASC";
        $dataChart = $modelTrx->query($sql)->getResultArray();

        foreach($dataChart as $row)
        {
            $total[ $row['month'] ] =  $row['total'];
        }
/*
        foreach($dataChart as $row){
            $year = $row['year'];
            if($row['month'] == 'January'){
                $month[] = "Januari $year";
            }elseif($row['month'] == 'February'){
                $month[] = 'Februari';
            }elseif($row['month'] == 'March'){
                $month[] = 'Maret';
            }elseif($row['month'] == 'April'){
                $month[] = 'April';
            }elseif($row['month'] == 'May'){
                $month[] = 'Mei';
            }elseif($row['month'] == 'June'){
                $month[] = 'Juni';
            }elseif($row['month'] == 'July'){
                $month[] = 'Juli';
            }elseif($row['month'] == 'August'){
                $month[] = 'Agustus';
            }elseif($row['month'] == 'September'){
                $month[] = 'September';
            }elseif($row['month'] == 'October'){
                $month[] = 'Oktober';
            }elseif($row['month'] == 'November'){
                $month[] = 'November';
            }elseif($row['month'] == 'December'){
                $month[] = "Desember $year";
            }

            $total[] = $row['total'];
        }
*/
        $data = [
            'title'             => 'Dashboard',
            'dashboard'         => TRUE,
            'crop'              => $modelCrops->get_crop($farmer['id']),
            'month'             => $month,
            'total'             => $total,
            'user_login'        => $modelFarmers->check_user(session()->get('farmer_user'))
        ];

        return view('farmer/dashboard.php', $data);
    }