Advertisement
Guest User

Untitled

a guest
Oct 6th, 2021
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.78 KB | None | 0 0
  1. public function index(){
  2. // Proteksi
  3. if(session()->get('farmer_user') == "") {
  4. session()->setFlashdata('error', 'Anda belum login');
  5. return redirect()->to(base_url('farmer/login'));
  6. }
  7. // End proteksi
  8.  
  9. $modelFarmers = new Farmers_model();
  10. $modelCrops = new Crops_model();
  11. $modelTrx = new Transaction_model();
  12. $farmer = $modelFarmers->check_user(session()->get('farmer_user'));
  13.  
  14. $id_petani = $farmer['id'];
  15. $awal = strtotime('-1 year');
  16. $akhir = strtotime(date("Y-m-d"));
  17. $date_awal = date('Y-m-01', $awal); // Range Awal
  18. $date_akhir = date('Y-m-t', $akhir); // Range Akhir
  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();
  20. $month = [];
  21. $total = [];
  22. foreach($dataChart as $row){
  23. $year = $row['year'];
  24. if($row['month'] == 'January'){
  25. $month[] = "Januari $year";
  26. }elseif($row['month'] == 'February'){
  27. $month[] = 'Februari';
  28. }elseif($row['month'] == 'March'){
  29. $month[] = 'Maret';
  30. }elseif($row['month'] == 'April'){
  31. $month[] = 'April';
  32. }elseif($row['month'] == 'May'){
  33. $month[] = 'Mei';
  34. }elseif($row['month'] == 'June'){
  35. $month[] = 'Juni';
  36. }elseif($row['month'] == 'July'){
  37. $month[] = 'Juli';
  38. }elseif($row['month'] == 'August'){
  39. $month[] = 'Agustus';
  40. }elseif($row['month'] == 'September'){
  41. $month[] = 'September';
  42. }elseif($row['month'] == 'October'){
  43. $month[] = 'Oktober';
  44. }elseif($row['month'] == 'November'){
  45. $month[] = 'November';
  46. }elseif($row['month'] == 'December'){
  47. $month[] = "Desember $year";
  48. }
  49.  
  50. $total[] = $row['total'];
  51. }
  52.  
  53. $data = [
  54. 'title' => 'Dashboard',
  55. 'dashboard' => TRUE,
  56. 'crop' => $modelCrops->get_crop($farmer['id']),
  57. 'month' => $month,
  58. 'total' => $total,
  59. 'user_login' => $modelFarmers->check_user(session()->get('farmer_user'))
  60. ];
  61.  
  62. return view('farmer/dashboard.php', $data);
  63. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement