/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $datacontentcategory = table_content_category::where('content_category_id', '=', $id)->first(); $mediaid = $datacontentcategory->media_manager_id; $media = table_media_manager::where('media_manager_id', $mediaid)->first(); if ($media != null) { $medianame = $media->media_manager_title; } else { $medianame = ''; } $data = array('dataContentCategory' => table_content_category::where('content_category_id', '=', $id)->get(), 'media_manager_name' => $medianame, 'media_manager' => json_encode(DB::select('select media_manager_id as id, media_manager_title as label, media_manager_title as value from table_media_manager'))); return view('admin.database.content-category.content-category-edit', compact('data')); }
public function index() { $result = DB::table('table_content as ct')->select('ct.*', DB::raw('(select content_category_title from table_content_category where content_category_id = ct.content_category_id) as content_category_title'), DB::raw('(select content_title from table_content where content_id = ct.content_repost_from) as content_repost'))->orderBy('content_id', 'desc')->paginate(10); foreach ($result as $res => $value) { $idsplit = explode(',', $value->content_media_id); $length = count($idsplit); $name = ''; for ($i = 0; $i < $length; $i++) { $cek = table_media_manager::where('media_manager_id', '=', $idsplit[$i])->first(); if ($cek != null) { $name = $name . $cek->media_manager_title . ', '; } } $value->content_media_id = $name; } $data = array('content' => $result); return view('admin.database.content.content-index', compact('data')); }
public function index() { $result = table_schedule_type::latest('schedule_type_id')->paginate(10); foreach ($result as $res => $value) { $idsplit = explode(',', $value->media_manager_id); $length = count($idsplit); $name = ''; for ($i = 0; $i < $length; $i++) { $cek = table_media_manager::where('media_manager_id', '=', $idsplit[$i])->first(); if ($cek != null) { $name = $name . $cek->media_manager_title . ', '; } } $value->media_manager_id = $name; } $data = array('schedule-type' => $result); return view('admin.database.schedule-type.schedule-type-index', compact('data')); }
public function index() { $result = DB::table('table_schedule as sch')->select('sch.*', DB::raw('(select users_name from table_users_detail where users_id = sch.schedule_users_creator) as users_name_creator'), DB::raw('(select users_name from table_users_detail where users_id = sch.schedule_users_source) as users_name_source'), DB::raw('(select schedule_type_name from table_schedule_type where schedule_type_id = sch.schedule_type_id) as schedule_type_name'))->orderBy('schedule_id', 'desc')->paginate(10); foreach ($result as $res => $value) { $idsplit = explode(',', $value->schedule_media_id); $length = count($idsplit); $name = ''; for ($i = 0; $i < $length; $i++) { $cek = table_media_manager::where('media_manager_id', '=', $idsplit[$i])->first(); if ($cek != null) { $name = $name . $cek->media_manager_title . ', '; } } $value->schedule_media_id = $name; } $data = array('schedule' => $result); return view('admin.database.schedule.schedule-index', compact('data')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { table_media_manager::find($id)->delete(); return redirect('admin/media-manager')->with('warning', 'Data successfully removed!'); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $app = app(); if (Request::has('token')) { $token = Request::input('token', ''); $compare = GlobalLibrary::tokenExtractor($token); $users_checker = GlobalLibrary::CheckUsersToken($compare); //echo '<pre>'.print_r($compare).'</pre>'; if ($users_checker[0]) { $uname = $users_checker[1]; $uid = $users_checker[2]; $email = $users_checker[3]; //get query $result = DB::select('Select ts.*, tud.users_name as users_name_creator, st.schedule_type_name, tud.users_name as users_name_source from table_schedule ts, table_schedule_type st, table_users_detail tud WHERE ts.schedule_type_id = st.content_category_id AND tud.users_id = ts.schedule_users_creator AND ts.schedule_users_creator = ' . $uid . ' ORDER BY schedule_id DESC '); //this foreach for get media manager name and source foreach ($result as $res => $value) { $idsplit = explode(',', $value->schedule_media_id); //get user source $cekuser = table_users_detail::where('users_id', '=', $value->schedule_users_source)->first(); if ($cekuser != null) { $value->users_name_source = $cekuser->users_name; } $length = count($idsplit); $name = ''; for ($i = 0; $i < $length; $i++) { $cek = table_media_manager::where('media_manager_id', '=', $idsplit[$i])->first(); if ($cek != null) { $name = $name . $cek->media_manager_title . ', '; } } $value->schedule_media_id = $name; } //this code for convert $dataConverted = array(); $app = app(); $i = 0; foreach ($result as $row) { $dataConverted[$i] = $app->make('stdClass'); $dataConverted[$i]->id = $row->schedule_id; $dataConverted[$i]->ttl = $row->cschedule_title; $dataConverted[$i]->typ = $row->schedule_type_id; $dataConverted[$i]->suc = $row->schedule_users_creator; $dataConverted[$i]->usc = $row->schedule_users_source; $dataConverted[$i]->dst = $row->schedule_date_start; $dataConverted[$i]->dnd = $row->schedule_date_end; $dataConverted[$i]->des = $row->schedule_description; $dataConverted[$i]->hed = $row->schedule_headline; $dataConverted[$i]->med = $row->schedule_media_id; $dataConverted[$i]->pub = $row->schedule_publish; $dataConverted[$i]->rpt = $row->schedule_repeat; $dataConverted[$i]->uns = $row->users_name_source; $dataConverted[$i]->utn = $row->schedule_type_name; $dataConverted[$i]->unc = $row->users_name_creator; $i++; } return (new Response(array('status' => true, 'msg' => 'success', 'data' => $dataConverted), 200))->header('Content-Type', "json"); } else { return (new Response(array('status' => false, 'msg' => 'Authentication Failed2'), 200))->header('Content-Type', "json"); } } else { return (new Response(array('status' => false, 'msg' => 'Authentication Failed1'), 200))->header('Content-Type', "json"); } }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $currentfile = table_media_manager::find($id); $currentfile = $currentfile->media_manager_filename; if (file_exists('./UPLOADED/' . $currentfile)) { unlink('./UPLOADED/' . $currentfile); } table_media_manager::find($id)->delete(); return redirect('admin/media-manager')->with('warning', 'Data have been removed!'); }
public function search_content() { $app = app(); if (Request::has('token')) { $token = Request::input('token', ''); $compare = GlobalLibrary::tokenExtractor($token); $users_checker = GlobalLibrary::CheckUsersToken($compare); //echo '<pre>'.print_r($compare).'</pre>'; if ($users_checker[0]) { $uname = $users_checker[1]; $uid = $users_checker[2]; $email = $users_checker[3]; $users = table_users_detail::where('users_email', '=', $email)->where('users_name', '=', $uname)->where('users_detail_id', '=', $uid)->first(); $follow = $users->users_json_following; //get query $keyword = Request::input('qwr'); $result = DB::select('Select tc.*, tud.users_name, tcc.content_category_title from table_content_category tcc, table_content tc, table_users_detail tud WHERE tc.content_category_id = tcc.content_category_id AND tud.users_id = tc.content_users_uploader AND tc.content_title like ' . $keyword . ' '); foreach ($result as $res => $value) { //get media manager $idsplit = explode(',', $value->content_media_id); $length = count($idsplit); $name = ''; for ($i = 0; $i < $length; $i++) { $cek = table_media_manager::where('media_manager_id', '=', $idsplit[$i])->first(); if ($cek != null) { $name = $name . $cek->media_manager_title . ', '; } } //get content repost $cekrepost = table_content::where('content_id', '=', $value->content_repost_from)->first(); if ($cekrepost != null) { $value->content_repost_from = $cekrepost->content_title; } //get hashtag $idsplittag = explode(',', $value->hashtag_id); $lengthtag = count($idsplittag); $hashtag = ''; for ($j = 0; $j < $lengthtag; $j++) { $cektag = table_hashtag::where('hashtag_id', '=', $idsplittag[$j])->first(); if ($cektag != null) { $hashtag = $hashtag . $cektag->media_manager_title . ', '; } } $value->hashtag_id = $hashtag; } //this code for convert $dataConverted = array(); $app = app(); $i = 0; foreach ($result as $row) { $dataConverted[$i] = $app->make('stdClass'); $dataConverted[$i]->id = $row->content_id; $dataConverted[$i]->ttl = $row->ccontent_title; $dataConverted[$i]->hed = $row->content_headline; $dataConverted[$i]->det = $row->content_detail; $dataConverted[$i]->med = $row->content_media_id; $dataConverted[$i]->upl = $row->content_users_uploader; $dataConverted[$i]->uun = $row->content_users_uploader_name; $dataConverted[$i]->cle = $row->content_last_editor; $dataConverted[$i]->cdi = $row->content_date_insert; $dataConverted[$i]->cdu = $row->content_date_update; $dataConverted[$i]->cde = $row->content_date_expired; $dataConverted[$i]->pub = $row->content_publish; $dataConverted[$i]->cat = $row->content_category_id; $dataConverted[$i]->ccn = $row->content_category_name; $dataConverted[$i]->chi = $row->content_hashtag_id; $dataConverted[$i]->crf = $row->content_repost_from; $dataConverted[$i]->crn = $row->content_repost; $i++; } return (new Response(array('status' => true, 'msg' => 'success', 'data' => $dataConverted), 200))->header('Content-Type', "json"); } else { return (new Response(array('status' => false, 'msg' => 'Authentication Failed2'), 200))->header('Content-Type', "json"); } } else { return (new Response(array('status' => false, 'msg' => 'Authentication Failed1'), 200))->header('Content-Type', "json"); } }