SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | public function index(){
| |
| 3 | // Proteksi | |
| 4 | if(session()->get('farmer_user') == "") {
| |
| 5 | session()->setFlashdata('error', 'Anda belum login');
| |
| 6 | return redirect()->to(base_url('farmer/login'));
| |
| 7 | } | |
| 8 | // End proteksi | |
| 9 | //-------------------BIKIN defaultnya dahulu | |
| 10 | $month = []; | |
| 11 | $total = []; | |
| 12 | for($i=1;$i<=12;$i++) | |
| 13 | {
| |
| 14 | $month[$i]=date("F", strtotime('2000-'.$i.'-01');
| |
| 15 | $total[$i]=0; | |
| 16 | } | |
| 17 | //------------------- | |
| 18 | $modelFarmers = new Farmers_model(); | |
| 19 | - | $dataChart = $modelTrx->query("SELECT harga, MONTHNAME(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")->getResultArray();
|
| 19 | + | |
| 20 | - | $month = []; |
| 20 | + | |
| 21 | - | $total = []; |
| 21 | + | |
| 22 | ||
| 23 | $id_petani = $farmer['id']; | |
| 24 | $awal = strtotime('-1 year');
| |
| 25 | $akhir = strtotime(date("Y-m-d"));
| |
| 26 | $date_awal = date('Y-m-01', $awal); // Range Awal
| |
| 27 | $date_akhir = date('Y-m-t', $akhir); // Range Akhir
| |
| 28 | //MONTHNAME(tanggal_transaksi) as month | |
| 29 | $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"; | |
| 30 | $dataChart = $modelTrx->query($sql)->getResultArray(); | |
| 31 | ||
| 32 | foreach($dataChart as $row) | |
| 33 | {
| |
| 34 | $total[ $row['month'] ] = $row['total']; | |
| 35 | } | |
| 36 | /* | |
| 37 | foreach($dataChart as $row){
| |
| 38 | $year = $row['year']; | |
| 39 | if($row['month'] == 'January'){
| |
| 40 | $month[] = "Januari $year"; | |
| 41 | }elseif($row['month'] == 'February'){
| |
| 42 | $month[] = 'Februari'; | |
| 43 | }elseif($row['month'] == 'March'){
| |
| 44 | $month[] = 'Maret'; | |
| 45 | }elseif($row['month'] == 'April'){
| |
| 46 | $month[] = 'April'; | |
| 47 | }elseif($row['month'] == 'May'){
| |
| 48 | $month[] = 'Mei'; | |
| 49 | }elseif($row['month'] == 'June'){
| |
| 50 | $month[] = 'Juni'; | |
| 51 | }elseif($row['month'] == 'July'){
| |
| 52 | $month[] = 'Juli'; | |
| 53 | }elseif($row['month'] == 'August'){
| |
| 54 | $month[] = 'Agustus'; | |
| 55 | }elseif($row['month'] == 'September'){
| |
| 56 | $month[] = 'September'; | |
| 57 | }elseif($row['month'] == 'October'){
| |
| 58 | $month[] = 'Oktober'; | |
| 59 | }elseif($row['month'] == 'November'){
| |
| 60 | $month[] = 'November'; | |
| 61 | }elseif($row['month'] == 'December'){
| |
| 62 | $month[] = "Desember $year"; | |
| 63 | } | |
| 64 | ||
| 65 | $total[] = $row['total']; | |
| 66 | } | |
| 67 | */ | |
| 68 | $data = [ | |
| 69 | 'title' => 'Dashboard', | |
| 70 | 'dashboard' => TRUE, | |
| 71 | 'crop' => $modelCrops->get_crop($farmer['id']), | |
| 72 | 'month' => $month, | |
| 73 | 'total' => $total, | |
| 74 | 'user_login' => $modelFarmers->check_user(session()->get('farmer_user'))
| |
| 75 | ]; | |
| 76 | ||
| 77 | return view('farmer/dashboard.php', $data);
| |
| 78 | } |
