model = new Prognosaproduksitebukabag(); $this->info = $this->model->makeInfo( $this->module); $this->access = array(); $this->data = array_merge(array( 'pageTitle' => $this->info['title'], 'pageNote' => $this->info['note'], 'pageModule'=> 'prognosaproduksitebukabag', 'return' => self::returnUrl() ),$this->data); } public function index( Request $request ) { // Make Sure users Logged if(!\Auth::check()) return redirect('user/login')->with('status', 'error')->with('message','You are not login'); $this->grab( $request) ; if($this->access['is_view'] ==0) return redirect('dashboard')->with('message', __('core.note_restric'))->with('status','error'); // Render into template return view( $this->module.'.index',$this->data); } function show( Request $request , $id ) { /* Handle import , export and view */ $task =$id ; switch( $task) { case 'export': return $this->getExport( $request ); break; case 'htmlTable': return $this->htmlTable( $request ); break; case 'htmlTablepPg': return $this->htmlTablepPg( $request ); break; } } public function htmlTable(Request $request) { // require login and view access if(!\Auth::check()) { return redirect('user/login')->with('status', 'error')->with('message','You are not login'); } $this->grab($request); if(isset($this->access['is_view']) && $this->access['is_view'] == 0) { return redirect('dashboard')->with('message', __('core.note_restric'))->with('status','error'); } // fetch rows from the database view $rows = \DB::table('q_prod_prognosa_produksi_tebu_kabag')->get(); // build html table $headers = [ 'nama_cluster','kode_kebun','nama_kebun','tanggal','luas_takmar','ton_takmar','protas_takmar', 'hi_ha_tebang','hi_netto_ton','hi_protas','ha_tebang','netto_ton','protas', 'sisa_ha','sisa_tebu','sisa_protas','prognosa_luas','prognosa_tebu','prognosa_protas', 'persen_luas','persen_tebu','persen_protas' ]; // styled, colorful and responsive table $html = ''; $html .= '
'; if (!$rows->isEmpty() && isset($rows[0]->periode)) { $periode = htmlspecialchars($rows[0]->periode, ENT_QUOTES, 'UTF-8'); $html .= '
🏆 Data Prognosa Produksi Tebu Periode ' . $periode . '
'; $html .= ' '; } // add extra CSS to make first 3 columns sticky when scrolling horizontally $html .= ''; $html .= ''; // header row $html .= ''; $html .= ''; foreach ($headers as $index => $h) { $label = strtoupper(str_replace('_', ' ', $h)); $thClass = ''; $thStyle = ''; // first three columns fixed if ($index === 0) { $thClass = 'sticky-col'; $thStyle = 'width:160px;'; } elseif ($index === 1) { $thClass = 'sticky-col-2'; $thStyle = 'width:120px;'; } elseif ($index === 2) { $thClass = 'sticky-col-3'; $thStyle = 'width:140px;'; } $html .= ''; } $html .= ''; if ($rows->isEmpty()) { $html .= ''; } else { $rowIndex = 0; $numericCols = [ 'luas_takmar','ton_takmar','protas_takmar','hi_ha_tebang','hi_netto_ton','hi_protas', 'ha_tebang','netto_ton','protas','sisa_ha','sisa_tebu','sisa_protas', 'prognosa_luas','prognosa_tebu','prognosa_protas','persen_luas','persen_tebu','persen_protas' ]; foreach ($rows as $r) { $rowClass = ''; $isTotalKso = (isset($r->nama_cluster) && strtoupper(trim($r->nama_cluster)) === 'TOTAL KSO'); $html .= ''; $colIndex = 0; foreach ($headers as $h) { $val = isset($r->{$h}) ? $r->{$h} : null; // apply sticky class for first 3 columns on body cells too $tdClass = ''; $tdStyle = ''; if ($colIndex === 0) { $tdClass = 'sticky-col'; $tdStyle = 'width:160px;'; } elseif ($colIndex === 1) { $tdClass = 'sticky-col-2'; $tdStyle = 'width:120px;'; } elseif ($colIndex === 2) { $tdClass = 'sticky-col-3'; $tdStyle = 'width:140px;'; } // format date if ($h === 'tanggal' && !empty($val)) { $ts = strtotime($val); $val = $ts ? date('d/m/Y', $ts) : $val; } // Kolom persen_luas, persen_tebu, persen_protas (index 19,20,21) if (in_array($colIndex, [19, 20, 21])) { $percent = is_numeric($val) ? (float)$val : null; if ($percent === null || $val === '') { $cellContent = ''; } elseif ($percent == 100.00) { $cellContent = '-'; } elseif ($percent > 100.00) { // panah naik hijau $cellContent = '▲ '.htmlspecialchars(number_format($percent,2)).' %'; } elseif ($percent < 100.00) { // panah turun merah $cellContent = '▼ '.htmlspecialchars(number_format($percent,2)).' %'; } if ($isTotalKso) $cellContent = '' . $cellContent . ''; $cell = ''; } // numeric formatting untuk kolom 5..18 elseif ($colIndex >= 4 && $colIndex <= 17 && $val !== null && $val !== '') { $val = number_format((float)$val, 2); // e.g. 1.234,56 $cellContent = htmlspecialchars((string)$val, ENT_QUOTES, 'UTF-8'); if ($isTotalKso) $cellContent = '' . $cellContent . ''; $cell = ''; } elseif (in_array($h, $numericCols) && $val !== null && $val !== '') { // fallback numeric formatting for other numeric columns (no thousands separator, dot decimal) $val = number_format((float)$val, 2, '.', ''); // add percent sign for persen_* columns if (strpos($h, 'persen') !== false) { $val = $val . ' %'; } $cellContent = htmlspecialchars((string)$val, ENT_QUOTES, 'UTF-8'); if ($isTotalKso) $cellContent = '' . $cellContent . ''; $cell = ''; } else { // boolean/int flag formatting if ($h === 'is_total') { $val = (int)$val; } $cellContent = htmlspecialchars((string)$val, ENT_QUOTES, 'UTF-8'); // Bold only for nama_cluster column if TOTAL KSO if ($isTotalKso && $h === 'nama_cluster') { $cellContent = '' . $cellContent . ''; } elseif ($isTotalKso && $h !== 'nama_cluster') { $cellContent = '' . $cellContent . ''; } $cell = ''; } $html .= $cell; $colIndex++; } $html .= ''; $rowIndex++; } } $html .= '
' . htmlspecialchars($label, ENT_QUOTES, 'UTF-8') . '
No data found
' . $cellContent . '' . $cellContent . '' . $cellContent . '' . $cellContent . '
'; $html .= ' '; return response($html, 200)->header('Content-Type', 'text/html; charset=utf-8'); } public function htmlTablepPg(Request $request) { // Ambil parameter tanggal dari request, default ke hari ini jika tidak ada $tanggal = $request->input('tanggal', date('Y-m-d')); // Eksekusi stored procedure $rows = \DB::select("CALL sp_rekap_mejatebu_sd_kebun_pg_prognosa(?, ?)", [$tanggal, null]); // Definisikan header kolom $headers = [ 'nama_cluster','kode_kebun','nama_kebun','pg_penggiling','nama_pg','periode', 'prognosa_luas','prognosa_tebu','prognosa_protas', 'ha_tebang','netto_ton','protas', 'sisa_ha','sisa_tebu','sisa_protas', 'jumlah_spta','jumlah_spta_uniq','tanggal_giling_sd' ]; // Kolom numerik untuk subtotal/total $numericCols = [ 'prognosa_luas','prognosa_tebu','prognosa_protas', 'ha_tebang','netto_ton','protas', 'sisa_ha','sisa_tebu','sisa_protas', 'jumlah_spta','jumlah_spta_uniq' ]; // Siapkan subtotal dan total $subtotals = []; $totals = []; foreach ($numericCols as $col) $totals[$col] = 0; $html = '
'; // Tambahkan CSS untuk tampilan menarik dan berwarna $html .= ''; // Caption judul tabel $html .= '
🏆 Data Rekap Prognosa Tebu PG
'; $html .= '
'; $html .= ''; $html .= ''; foreach ($headers as $i => $h) { $label = strtoupper(str_replace('_',' ',$h)); $thClass = ''; $thStyle = ' position: sticky;top: 0;'; // Freeze kolom 1-6 if ($i === 0) { $thClass = 'sticky-col'; $thStyle = 'width:120px;'; } elseif ($i === 1) { $thClass = 'sticky-col-2'; $thStyle = 'width:120px;'; } elseif ($i === 2) { $thClass = 'sticky-col-3'; $thStyle = 'width:120px;'; } elseif ($i === 3) { $thClass = 'sticky-col-4'; $thStyle = 'width:120px;'; } elseif ($i === 4) { $thClass = 'sticky-col-5'; $thStyle = 'width:120px;'; } elseif ($i === 5) { $thClass = 'sticky-col-6'; $thStyle = 'width:120px;'; } $html .= ''; } $html .= ''; $lastKodeKebun = null; $namakebun = null; foreach ($rows as $i => $r) { // Hitung subtotal per kode_kebun if ($lastKodeKebun !== null && $lastKodeKebun !== $r->kode_kebun) { // Hitung subtotal khusus untuk prognosa_protas, protas dan sisa_protas $sub_prognosa_protas = ($subtotals['prognosa_luas'] ?? 0) != 0 ? ($subtotals['prognosa_tebu'] ?? 0) / ($subtotals['prognosa_luas'] ?? 1) : 0; $sub_protas = ($subtotals['ha_tebang'] ?? 0) != 0 ? ($subtotals['netto_ton'] ?? 0) / ($subtotals['ha_tebang'] ?? 1) : 0; $sub_sisa_protas = ($subtotals['sisa_ha'] ?? 0) != 0 ? ($subtotals['sisa_tebu'] ?? 0) / ($subtotals['sisa_ha'] ?? 1) : 0; $html .= ''; foreach ($headers as $j => $h) { $tdClass = ''; $tdStyle = ''; if ($j === 0) { $tdClass = 'sticky-col'; $tdStyle = 'width:120px;'; } elseif ($j === 1) { $tdClass = 'sticky-col-2'; $tdStyle = 'width:120px;'; } elseif ($j === 2) { $tdClass = 'sticky-col-3'; $tdStyle = 'width:120px;'; } elseif ($j === 3) { $tdClass = 'sticky-col-4'; $tdStyle = 'width:120px;'; } elseif ($j === 4) { $tdClass = 'sticky-col-5'; $tdStyle = 'width:120px;'; } elseif ($j === 5) { $tdClass = 'sticky-col-6'; $tdStyle = 'width:120px;'; } if ($h == 'nama_cluster') { $html .= ''; } elseif ($h == 'prognosa_protas') { $html .= ''; } elseif ($h == 'protas') { $html .= ''; } elseif ($h == 'sisa_protas') { $html .= ''; } elseif (in_array($h, $numericCols)) { $val = isset($subtotals[$h]) ? number_format($subtotals[$h], 2) : ''; $html .= ''; } else { $html .= ''; } } $html .= ''; $subtotals = []; } $lastKodeKebun = $r->kode_kebun; $namakebun = $r->nama_kebun; // Akumulasi subtotal dan total foreach ($numericCols as $col) { $val = isset($r->$col) ? (float)$r->$col : 0; $subtotals[$col] = isset($subtotals[$col]) ? $subtotals[$col] + $val : $val; $totals[$col] += $val; } $html .= ''; foreach ($headers as $j => $h) { $tdClass = ''; $tdStyle = ''; if ($j === 0) { $tdClass = 'sticky-col'; $tdStyle = 'width:120px;'; } elseif ($j === 1) { $tdClass = 'sticky-col-2'; $tdStyle = 'width:120px;'; } elseif ($j === 2) { $tdClass = 'sticky-col-3'; $tdStyle = 'width:120px;'; } elseif ($j === 3) { $tdClass = 'sticky-col-4'; $tdStyle = 'width:120px;'; } elseif ($j === 4) { $tdClass = 'sticky-col-5'; $tdStyle = 'width:120px;'; } elseif ($j === 5) { $tdClass = 'sticky-col-6'; $tdStyle = 'width:120px;'; } $val = isset($r->$h) ? $r->$h : ''; if (in_array($h, $numericCols) && $val !== '') { $html .= ''; } elseif ($h == 'tanggal_giling_sd' && $val) { $html .= ''; } else { $html .= ''; } } $html .= ''; // Jika baris terakhir, tampilkan subtotal if ($i === count($rows) - 1) { $sub_prognosa_protas = ($subtotals['prognosa_luas'] ?? 0) != 0 ? ($subtotals['prognosa_tebu'] ?? 0) / ($subtotals['prognosa_luas'] ?? 1) : 0; $sub_protas = ($subtotals['ha_tebang'] ?? 0) != 0 ? ($subtotals['netto_ton'] ?? 0) / ($subtotals['ha_tebang'] ?? 1) : 0; $sub_sisa_protas = ($subtotals['sisa_ha'] ?? 0) != 0 ? ($subtotals['sisa_tebu'] ?? 0) / ($subtotals['sisa_ha'] ?? 1) : 0; $html .= ''; foreach ($headers as $j => $h) { $tdClass = ''; $tdStyle = ''; if ($j === 0) { $tdClass = 'sticky-col'; $tdStyle = 'width:120px;'; } elseif ($j === 1) { $tdClass = 'sticky-col-2'; $tdStyle = 'width:120px;'; } elseif ($j === 2) { $tdClass = 'sticky-col-3'; $tdStyle = 'width:120px;'; } elseif ($j === 3) { $tdClass = 'sticky-col-4'; $tdStyle = 'width:120px;'; } elseif ($j === 4) { $tdClass = 'sticky-col-5'; $tdStyle = 'width:120px;'; } elseif ($j === 5) { $tdClass = 'sticky-col-6'; $tdStyle = 'width:120px;'; } if ($h == 'nama_cluster') { $html .= ''; } elseif ($h == 'prognosa_protas') { $html .= ''; } elseif ($h == 'protas') { $html .= ''; } elseif ($h == 'sisa_protas') { $html .= ''; } elseif (in_array($h, $numericCols)) { $val = isset($subtotals[$h]) ? number_format($subtotals[$h], 2) : ''; $html .= ''; } else { $html .= ''; } } $html .= ''; } } // Tampilkan total keseluruhan $html .= ''; // Hitung total khusus untuk prognosa_protas, protas dan sisa_protas $total_prognosa_protas = ($totals['prognosa_luas'] ?? 0) != 0 ? ($totals['prognosa_tebu'] ?? 0) / ($totals['prognosa_luas'] ?? 1) : 0; $total_protas = ($totals['ha_tebang'] ?? 0) != 0 ? ($totals['netto_ton'] ?? 0) / ($totals['ha_tebang'] ?? 1) : 0; $total_sisa_protas = ($totals['sisa_ha'] ?? 0) != 0 ? ($totals['sisa_tebu'] ?? 0) / ($totals['sisa_ha'] ?? 1) : 0; foreach ($headers as $j => $h) { $tdClass = ''; $tdStyle = ''; if ($j === 0) { $tdClass = 'sticky-col'; $tdStyle = 'width:120px;'; } elseif ($j === 1) { $tdClass = 'sticky-col-2'; $tdStyle = 'width:120px;'; } elseif ($j === 2) { $tdClass = 'sticky-col-3'; $tdStyle = 'width:120px;'; } elseif ($j === 3) { $tdClass = 'sticky-col-4'; $tdStyle = 'width:120px;'; } elseif ($j === 4) { $tdClass = 'sticky-col-5'; $tdStyle = 'width:120px;'; } elseif ($j === 5) { $tdClass = 'sticky-col-6'; $tdStyle = 'width:120px;'; } if ($h == 'nama_cluster') { $html .= ''; } elseif ($h == 'prognosa_protas') { $html .= ''; } elseif ($h == 'protas') { $html .= ''; } elseif ($h == 'sisa_protas') { $html .= ''; } elseif (in_array($h, $numericCols)) { $val = isset($totals[$h]) ? number_format($totals[$h], 2) : ''; $html .= ''; } else { $html .= ''; } } $html .= ''; $html .= '
' . htmlspecialchars($label, ENT_QUOTES, 'UTF-8') . '
Subtotal ' . htmlspecialchars($namakebun) . '' . number_format($sub_prognosa_protas, 2) . '' . number_format($sub_protas, 2) . '' . number_format($sub_sisa_protas, 2) . '' . $val . '
' . number_format((float)$val, 2) . '' . date('d/m/Y', strtotime($val)) . '' . htmlspecialchars((string)$val, ENT_QUOTES, 'UTF-8') . '
Subtotal ' . htmlspecialchars($namakebun) . '' . number_format($sub_prognosa_protas, 2) . '' . number_format($sub_protas, 2) . '' . number_format($sub_sisa_protas, 2) . '' . $val . '
TOTAL' . number_format($total_prognosa_protas, 2) . '' . number_format($total_protas, 2) . '' . number_format($total_sisa_protas, 2) . '' . $val . '
'; // Tombol download Excel $html .= ' '; return response($html, 200)->header('Content-Type', 'text/html; charset=utf-8'); } }