model = new Prognosasisatebu(); $this->info = $this->model->makeInfo( $this->module); $this->access = array(); $this->data = array_merge(array( 'pageTitle' => $this->info['title'], 'pageNote' => $this->info['note'], 'pageModule'=> 'prognosasisatebu', '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'); return view( $this->module.'.index',$this->data); } public function getDataFromSP(Request $request) { $params = [ $request->input('jawa_luarjawa'), $request->input('cluster'), $request->input('kode_kebun'), $request->input('nama_rayon'), $request->input('periode'), $request->input('tgl') ]; $results = \DB::select('CALL sp_prognosa_sisatebu(?, ?, ?, ?, ?, ?)', $params); // Return JSON response $jsonResponse = response()->json($results); // Generate HTML table // Add Bootstrap styling for a more attractive table $html = ''; $html .= '

'; $html .= ''; if (!empty($results)) { foreach ($results[0] as $key => $value) { $colName = ucwords(str_replace('_', ' ', $key)); $html .= ''; } $html .= ''; foreach ($results as $row) { $html .= ''; foreach ($row as $cell) { $html .= ''; } $html .= ''; } $html .= '

' . htmlspecialchars($colName) . '
' . htmlspecialchars($cell) . '

'; } else { $html .= 'No Data'; } return $html; } function show( Request $request , $id ) { /* Handle import , export and view */ $task =$id ; switch( $task) { case 'export': return $this->getExport( $request ); break; case 'getDataFromSP': return $this->getDataFromSP( $request ); } } }