/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $data = array('dataschedule' => table_schedule::where('schedule_id', '=', $id)->get(), 'schedule_type' => table_schedule_type::select('schedule_type_id', 'schedule_type_name')->get(), 'schedule_typeAuto' => json_encode(DB::select('select schedule_type_id as id, schedule_type_name as label from table_schedule_type')), 'users_detail' => json_encode(DB::select('select users_id as id, users_name as value, users_name as label from table_users_detail')), 'media_manager' => json_encode(DB::select('select media_manager_id as id, media_manager_title as name from table_media_manager'))); //Ambil data schedule foreach ($data['dataschedule'] as $key => $value) { $scheduleType = $value->schedule_type_id; $usrCreator = $value->schedule_users_creator; $usrSource = $value->schedule_users_source; $exp = $value->schedule_media_id; } $tempExp = explode(",", $exp); $i = 0; for ($i; $i < count($tempExp); $i++) { //$newArray = DB::select('select media_manager_id as id, media_manager_title as name from table_media_manager where media_manager_id='.$tempExp[$i]); $newArray = DB::table('table_media_manager')->select('media_manager_id as id', 'media_manager_title as name')->where('media_manager_id', '=', $tempExp[$i])->first(); if ($newArray != null) { $dataMediaManager[$newArray->id] = $newArray->name; } } if (isset($dataMediaManager)) { $data['dataMediaManager'] = $dataMediaManager; $data['dataIdMediaManager'] = $exp; } else { $data['dataMediaManager'] = ''; $data['dataIdMediaManager'] = ''; } //Ambil data Schedule Type $row = DB::table('table_schedule_type')->select('schedule_type_id as id', 'schedule_type_name as value')->where('schedule_type_id', '=', $scheduleType)->first(); if ($row != null) { $data['dataScheduleType'] = $row; } else { $data['dataScheduleType'] = ''; } //END Ambil data Schedule Type //Ambil data users_name $users_name = DB::table('table_users_detail')->select('users_id as id', 'users_name as value')->where('users_id', '=', $usrCreator)->first(); $users_name2 = DB::table('table_users_detail')->select('users_id as id', 'users_name as value')->where('users_id', '=', $usrSource)->first(); if ($users_name != null) { $data['dataUsers'] = $users_name; } else { $data['dataUsers'] = ''; } if ($users_name2 != null) { $data['dataUsers2'] = $users_name2; } else { $data['dataUsers2'] = ''; } //END Ambil data users_name return view('admin.database.schedule.schedule-edit', compact('data')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { table_schedule_type::find($id)->delete(); return redirect('admin/schedule-type')->with('warning', 'Data have been removed!'); }