/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $data = array('content' => table_content::where('content_id', '=', $id)->get(), 'media_manager' => DB::select('select media_manager_id as id, media_manager_title as name from table_media_manager'), 'users_detail' => DB::select('select users_id as id, users_name as value, users_name as label from table_users_detail'), 'content_category' => DB::select('select content_category_id as id, content_category_title as value, content_category_title as label from table_content_category'), 'hashtag' => json_encode(DB::select('select hashtag_id as id, hashtag_title as name from table_hashtag')), 'content_from' => DB::select('select content_id as id, content_title as value, content_title as label from table_content')); //Ambil data nama media manager foreach ($data['content'] as $key => $value) { $exp = $value->content_media_id; $usrUp = $value->content_users_uploader; $usrEdit = $value->content_last_editor; $contCat = $value->content_category_id; $contFrom = $value->content_repost_from; $contHash = $value->hashtag_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; //END Ambil data nama media manager $tempHash = explode(",", $contHash); $i = 0; for ($i; $i < count($tempHash); $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_hashtag')->select('hashtag_id as id', 'hashtag_title as name')->where('hashtag_id', '=', $tempHash[$i])->first(); if ($newArray != null) { $dataHashtag[$newArray->id] = $newArray->name; } } if (isset($dataHashtag)) { $data['dataHashtag'] = $dataHashtag; } $data['dataIdHashtag'] = $contHash; //Ambil data users_name $users_name = DB::table('table_users_detail')->select('users_id as id', 'users_name as value')->where('users_id', '=', $usrUp)->first(); $users_name2 = DB::table('table_users_detail')->select('users_id as id', 'users_name as value')->where('users_id', '=', $usrEdit)->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 //Ambil data Content Category $content_category = DB::table('table_content_category')->select('content_category_id as id', 'content_category_title as value')->where('content_category_id', '=', $contCat)->first(); if ($content_category != null) { $data['dataContentCategory'] = $content_category; } else { $data['dataContentCategory'] = ''; } //END Ambil data Content Category $content_from = DB::table('table_content')->select('content_id as id', 'content_title as value')->where('content_id', '=', $contFrom)->first(); if ($content_from != null) { $data['dataContentFrom'] = $content_from; } else { $data['dataContentFrom'] = ''; } return view('admin.database.content.content-edit', compact('data')); }
public function repost() { $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]; if (Request::input('cid') == null) { return (new Response(array('status' => true, 'msg' => 'Please select a content that you want to repost '), 200))->header('content-Type', "json"); } else { //get content resource $target = table_content::where('content_id', '=', Request::input('cid'))->first(); //input content $field_content = array('content_title' => $target->content_title, 'content_headline' => $target->headline, 'content_detail' => $target->content_detail, 'content_media_id' => $target->content_media_id, 'content_users_uploader' => $uid, 'content_last_editor' => $target->content_last_editor, 'content_date_insert' => date('Y-m-d H:i:s'), 'content_date_expired' => $target->content_date_expired, 'content_publish' => $target->content_publish, 'content_category_id' => $target->content_category_id, 'content_hashtag_id' => $target->content_hashtag_id, 'content_repost_from' => $target->content_id); $content = table_content::create($field_content); //notification repost //input content $field_notiication = array('users_id' => $target->content_users_uploader, 'datetime' => date('Y-m-d H:i:s'), 'status' => 'send'); $content = table_notification::create($field_notiication); /* //it always return 1 iterate. i made it but i don't know where a message of notiication store? $dataConverted = array(); $app = app(); $i=0; $whorepost = table_users_detail::where('users_id', '=',$uid)->first(); foreach($whorepost as $row){ $dataConverted[$i]->uid = $row->users_id; //send user ID who repost his/her content $dataConverted[$i]->unm = $row->users_name; //send user Name who repost his/her content $dataConverted[$i]->ttl = $target->content_title; //send the Title that reposted $dataConverted[$i]->nci = $whorepost; //send the new content ID to him/her $dataConverted[$i]->cdi = date('Y-m-d H:i:s'); //send the date repost (insert) } */ return (new Response(array('status' => true, 'msg' => 'success'), 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"); } }