public static function editPost($input)
{
$validation = Validator::make($input, Posts::$editPostRules);
if ($validation->fails()) {
return Response::json(array('status' => '0', 'msg' => $validation->getMessageBag()->first()), 200);
} else {
$access_token = $input['token'];
$title = $input['title'];
$post_id = $input['post_id'];
$skillset = $input['skillset'];
$post_desc = isset($input['post_desc']) ? $input['post_desc'] : "";
$post_image = Input::file('post_image');
$post_video = Input::file('post_video');
$current_time = new DateTime();
$user_id = Users::getUserIdByToken($access_token);
if ($user_id) {
$post_data = DB::table('posts')->select('*')->where('title', $title)->where('user_id', $user_id)->first();
if ($post_data) {
if ($post_image == "") {
$image = "";
} else {
$image = Users::uploadPostFiles('post_image');
}
if ($post_video == "") {
$video = "";
} else {
$video = Users::uploadPostFiles('post_video');
}
if ($video) {
DB::table('posts')->where('user_id', $user_id)->where('id', $post_id)->update(['title' => $title, 'post_desc' => $post_desc, 'post_image' => $image, 'post_video' => $video]);
} else {
DB::table('posts')->where('id', $post_id)->where('user_id', $user_id)->update(['title' => $title, 'post_desc' => $post_desc, 'post_image' => $image]);
}
if ($skillset) {
$set = "";
foreach ($skillset as $key => $val) {
$m = str_replace(' ', '', $val);
$set .= '"' . $m . '",';
}
$num = rtrim($set, ', ');
DB::table('post_skillset')->select('*')->where('user_id', $user_id)->where('post_id', $post_id)->whereRaw('skillset_id NOT IN' . '(' . $num . ')')->delete();
foreach ($skillset as $key => $value) {
$skill[$key] = DB::table('post_skillset')->select('*')->where('post_id', $post_id)->where('user_id', $user_id)->where('skillset_id', $value)->get();
if (!$skill[$key]) {
$post_skill = DB::table('post_skillset')->insertGetId(array('user_id' => $user_id, 'post_id' => $post_id, 'skillset_id' => $value, 'created_at' => $current_time));
}
}
}
return Response::json(array('status' => '1', 'msg' => 'Post Updated'), 200);
} else {
return Response::json(array('status' => '2', 'msg' => 'Post doesnot exists'), 200);
}
} else {
return Response::json(array('status' => '0', 'msg' => "Token Expired"), 200);
}
}
}
public static function editVideo($input)
{
$validation = Validator::make($input, Users::$editVideoRules);
if ($validation->fails()) {
return Response::json(array('status' => '0', 'msg' => $validation->getMessageBag()->first()), 200);
} else {
$access_token = $input['token'];
$profile_thumb = Input::file('profile_thumb');
$profile_video = Input::file('profile_video');
$current_time = new DateTime();
$user_id = Users::getUserIdByToken($access_token);
if ($user_id) {
if ($profile_video == "") {
$video = "";
$thumb = "";
} else {
$video = Users::uploadPostFiles('profile_video');
$thumb = Users::uploadPostFiles('profile_thumb');
}
if ($video) {
DB::table('users')->where('id', $user_id)->update(['profile_thumb' => $thumb, 'profile_video' => $video]);
}
$profile_setup_status = Users::ProfileSetupStatus($user_id);
return Response::json(array('status' => '1', 'msg' => 'User Profile Updated', 'profile_complete_status' => $profile_setup_status), 200);
} else {
return Response::json(array('status' => '0', 'msg' => "Token Expired"), 200);
}
}
}
