/**
* 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!');
}
