model = new Consolelhpmkso(); $this->info = $this->model->makeInfo( $this->module); $this->access = array(); $this->data = array_merge(array( 'pageTitle' => $this->info['title'], 'pageNote' => $this->info['note'], 'pageModule'=> 'consolelhpmkso', '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); } function show( Request $request , $id ) { /* Handle import , export and view */ $task =$id ; switch( $task) { case 'export': return $this->getExport( $request ); break; case 'getConsoleProdis': return $this->getConsoleProdis( $request ); break; case 'formConsoleProdis': return $this->formConsoleProdis( $request ); break; case 'getConsoleProdispg': return $this->getConsoleProdispg( $request ); break; case 'formConsoleProdispg': return $this->formConsoleProdispg( $request ); break; } } public function formConsoleProdis( Request $request ) { $html = '
'; $html .= ' '; return $html; } public function getConsoleProdis(Request $request) { $startDate = $request->input('start_date', '2026-02-15'); $endDate = $request->input('end_date', '2026-02-22'); $kode_kebun = $request->input('kode_kebun', 'sk01'); $results = \DB::select('CALL sp_console_prodis_kebun(?, ?, ?)', [ $startDate, $endDate, $kode_kebun ]); $html = ''; $html .= '
'; $html .= ''; $html .= ''; $html .= ''; if (!empty($results)) { foreach (array_keys((array)$results[0]) as $header) { $displayHeader = strtoupper(str_replace('_', ' ', $header)); $html .= ''; } } $html .= ''; foreach ($results as $index => $row) { $html .= ''; $colIndex = 0; foreach ((array)$row as $cell) { $stickyClass = ($colIndex < 3) ? 'sticky-col' : ''; if ($colIndex >= 3) { // Numeric columns - right aligned with number formatting $formattedValue = is_numeric($cell) ? number_format($cell, 2, ',', '.') : htmlspecialchars($cell); $html .= ''; }else if($colIndex == 2){ $icons = [ 'luas digiling' => '', 'tebu digiling' => '', 'protas' => '', 'hablur' => '', 'rendemen' => '', 'gula' => '', 'tetes' => '' ]; $icon = $icons[$cell] ?? ''; $html .= ''; } else { // Text columns - left aligned $html .= ''; } $colIndex++; } $html .= ''; } $html .= '
' . htmlspecialchars($displayHeader) . '
' . $formattedValue . '' . $icon . ' ' . htmlspecialchars($cell) . '' . htmlspecialchars($cell) . '
'; $html .= '
'; return $html; } public function formConsoleProdispg( Request $request ) { $html = '
'; $html .= ' '; return $html; } public function getConsoleProdispg(Request $request) { $startDate = $request->input('start_date'); $endDate = $request->input('end_date'); $kode_kebun = $request->input('kode_kebun'); $results = \DB::select('CALL sp_console_prodis_pg(?, ?, ?)', [ $startDate, $endDate, $kode_kebun ]); $html = ''; $html .= '
'; $html .= ''; $html .= ''; $html .= ''; if (!empty($results)) { foreach (array_keys((array)$results[0]) as $header) { $displayHeader = strtoupper(str_replace('_', ' ', $header)); $html .= ''; } } $html .= ''; foreach ($results as $index => $row) { $html .= ''; $colIndex = 0; foreach ((array)$row as $cell) { $stickyClass = ($colIndex < 5) ? 'sticky-col' : ''; if ($colIndex >= 5) { $formattedValue = is_numeric($cell) ? number_format($cell, 2, ',', '.') : htmlspecialchars($cell); $html .= ''; } else if ($colIndex == 3) { $icons = [ 'luas digiling' => '', 'tebu digiling' => '', 'protas' => '', 'hablur' => '', 'rendemen' => '', 'gula' => '', 'tetes' => '' ]; $icon = $icons[$cell] ?? ''; $html .= ''; } else { $html .= ''; } $colIndex++; } $html .= ''; } $html .= '
' . htmlspecialchars($displayHeader) . '
' . $formattedValue . '' . $icon . ' ' . htmlspecialchars($cell) . '' . htmlspecialchars($cell) . '
'; $html .= '
'; return $html; } }