Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function index(){
- // Proteksi
- if(session()->get('farmer_user') == "") {
- session()->setFlashdata('error', 'Anda belum login');
- return redirect()->to(base_url('farmer/login'));
- }
- // End proteksi
- $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
- $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();
- $month = [];
- $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);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement