model = new Rekapbibitkebun(); $this->info = $this->model->makeInfo( $this->module); $this->access = array(); $this->data = array_merge(array( 'pageTitle' => $this->info['title'], 'pageNote' => $this->info['note'], 'pageModule'=> 'rekapbibitkebun', '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'); // Render into template return view( $this->module.'.index',$this->data); } public function showTable(Request $request) { $masa_tanam = $request->input('masa_tanam'); $jenjang_bibitan = $request->input('jenjang_bibitan'); // Panggil stored procedure $results = \DB::select("CALL sp_rekap_bibit_kebun_pc_rc(?, ?)", [$masa_tanam, $jenjang_bibitan]); // Ambil kolom dari hasil query $columns = array_keys((array)$results[0]); $html = ''; // Bangun HTML table // Table with Bootstrap styling and zebra stripes $html .= '
'; $html .= ''; $html .= ''; foreach ($columns as $col) { $html .= ''; } $html .= ''; foreach ($results as $row) { $html .= ''; foreach ($columns as $col) { $html .= ''; } $html .= ''; } $html .= '
' . htmlspecialchars(ucwords(str_replace('_', ' ', $col))) . '
' . htmlspecialchars($row->$col) . '
'; return $html; } public function formrekapbibit(Request $request) { // Make Sure users Logged if(!\Auth::check()) return redirect('user/login')->with('status', 'error')->with('message','You are not login'); $this->data = array_merge(array( 'pageTitle' => 'Rekap Bibit Kebun', 'pageNote' => 'Data Rekap Bibit Kebun', 'pageModule'=> 'rekapbibitkebun', 'return' => self::returnUrl() ),$this->data); return view($this->module.'.rekapbibit', $this->data); } public function rekapBibit(Request $request) { $jenjang = $request->input('jenjang'); $sistem = $request->input('sistem'); $tahun = $request->input('tahun'); $kemasakan = $request->input('kemasakan'); $kategori = $request->input('kategori'); $tingkat = $request->input('tingkat'); // Panggil stored procedure $results = \DB::select("CALL sp_rekap_bibit_new(?, ?, ?, ?, ?, ?)", [$jenjang, $sistem, $tahun, $kemasakan, $kategori, $tingkat]); // Ambil kolom dari hasil query if (empty($results)) { return '
No data found
'; } $columns = array_keys((array)$results[0]); $html = ''; // Bangun HTML table // Table with Bootstrap styling and zebra stripes $html .= ''; $html .= '
'; $html .= ''; $html .= ''; // Generate color map based on filter tahun $filterYear = intval(substr(str_replace('/', '', $tahun), 0, 2))+2000; $colorMap = array( ($filterYear - 2) => array('header' => '#F28B82', 'row' => '#FDE8E6'), ($filterYear - 1) => array('header' => '#7BB3F0', 'row' => '#E3EFFD'), $filterYear => array('header' => '#57BB8A', 'row' => '#E2F4EC'), ($filterYear + 1) => array('header' => '#F6C549', 'row' => '#FEF9E7'), ($filterYear + 2) => array('header' => '#B39DDB', 'row' => '#F3EFFE'), ); foreach ($columns as $col) { $colIndex = array_search($col, $columns); // Determine header background color based on year $headerBgColor = '#4a90d9'; $headerTextColor = '#fff'; if ($colIndex >= 5) { $yearStr = substr($col, 0, 4); if (isset($colorMap[$yearStr])) { $headerBgColor = $colorMap[$yearStr]['header']; $headerTextColor = '#fff'; } else { $headerBgColor = '#7f8c8d'; $headerTextColor = '#fff'; } } if ($colIndex < 5) { $leftOffset = array(0 => 0, 1 => 90, 2 => 170, 3 => 250, 4 => 330); $left = isset($leftOffset[$colIndex]) ? $leftOffset[$colIndex] : ($colIndex * 80); $stickyStyle = ' style="position: sticky; left: ' . $left . 'px; z-index: 10; background: linear-gradient(135deg, #2c3e50 0%, #4a6fa5 100%); color: #fff; border-right: 2px solid #1a2636;"'; } else { $stickyStyle = ' style="background-color: ' . $headerBgColor . '; color: ' . $headerTextColor . '; border-right: 1px solid rgba(255,255,255,0.25);"'; } $html .= '' . htmlspecialchars(ucwords(str_replace('_', ' ', $col))) . ''; } $html .= ''; $rowNum = 0; foreach ($results as $row) { $rowNum++; $html .= ''; foreach ($columns as $col) { $colIndex = array_search($col, $columns); if ($colIndex < 5) { $leftOffset = array(0 => 0, 1 => 90, 2 => 170, 3 => 250, 4 => 330); $left = isset($leftOffset[$colIndex]) ? $leftOffset[$colIndex] : ($colIndex * 80); $stickyBg = ($rowNum % 2 === 0) ? '#eaf2fb' : '#ffffff'; $stickyStyle = ' style="position: sticky; left: ' . $left . 'px; z-index: 9; background-color: ' . $stickyBg . '; border-right: 2px solid #d0e4f7; font-weight: ' . ($colIndex === 0 ? '600' : 'normal') . ';"'; $html .= '' . htmlspecialchars($row->$col) . ''; } else { $yearStr = substr($col, 0, 4); $bgColor = isset($colorMap[$yearStr]) ? $colorMap[$yearStr]['row'] : '#fff'; $val = $row->$col; $numericStyle = ''; $displayVal = ($val == '0' || $val === 0) ? '-' : htmlspecialchars($val); if (is_numeric(str_replace(',', '', $val)) && $val !== '' && $val != '0' && $val !== 0) { $numericStyle = ' font-weight: 500;'; } $html .= ''; } } $html .= ''; } $html .= '
' . $displayVal . '
'; return $html; } function show( Request $request , $id ) { /* Handle import , export and view */ $task =$id ; switch( $task) { case 'export': return $this->getExport( $request ); break; case 'showTable': return $this->showTable( $request ); break; case 'rekapBibit': return $this->rekapBibit( $request ); break; case 'formrekapbibit': return $this->formrekapbibit( $request ); break; } } }