public function submitQueryForm() { $shareOnLinkedin = ''; if (!empty(Input::get('shareOnLinkedin'))) { $shareOnLinkedin = Input::get('shareOnLinkedin'); } if (!empty(Input::get('subject'))) { $subject = Input::get('subject'); } if (!empty(Input::get('description'))) { $description = Input::get('description'); } if (!empty(Input::get('skillTags'))) { $skills = Input::get('skillTags'); } if (!empty(Input::get('privacysetting'))) { $privacysetting = Input::get('privacysetting'); } if (!empty(Input::get('receiver_id'))) { $receiver_id = Input::get('receiver_id'); } if (!empty(Input::get('user_groups'))) { $user_groups = Input::get('user_groups'); } $url_subject = $subject; $url_subject = strtolower($url_subject); //Make alphanumeric (removes all other characters) $url_subject = preg_replace("/[^a-z0-9_\\s-]/", "", $url_subject); $url_subject = trim($url_subject); //Clean up multiple dashes or whitespaces $url_subject = preg_replace("/[\\s-]+/", " ", $url_subject); //Convert whitespaces and underscore to dash $url_subject = preg_replace("/[\\s_]/", "-", $url_subject); if (!empty($receiver_id)) { $Question = new Question(); $Question->user_id = $receiver_id; $Question->subject = strip_tags($subject); $Question->description = strip_tags($description); if (!empty($skills)) { $Question->skills = implode(',', $skills); } else { $Question->skills = ''; } $Question->access = $privacysetting; $Question->question_url = strtolower($url_subject); $Question->save(); $questionId = $Question->id; $getUser = User::where('id', '=', $receiver_id)->first(); //Add data on users_mykarma table for query $myKarmaDataQuery = new Mykarma(); $myKarmaDataQuery->entry_id = $questionId; $myKarmaDataQuery->user_id = $receiver_id; $myKarmaDataQuery->fname = $getUser->fname; $myKarmaDataQuery->lname = $getUser->lname; $myKarmaDataQuery->piclink = $getUser->piclink; $myKarmaDataQuery->entry_type = 'Query'; $myKarmaDataQuery->users_role = 'PostedQuery'; $myKarmaDataQuery->status = 'Open'; $myKarmaDataQuery->unread_flag = 'false'; $myKarmaDataQuery->no_of_unread_items = '0'; $myKarmaDataQuery->entry_updated_on = Carbon::now(); $myKarmaDataQuery->save(); $user_id_giver = 'null'; $feedType = 'KarmaQuery'; KarmaHelper::storeKarmacirclesfeed($user_id_giver, $receiver_id, $feedType, $questionId); if (!empty($user_groups)) { $user_groups = explode(',', $user_groups); foreach ($user_groups as $key => $value) { $Groupquestion = new Groupquestion(); $Groupquestion->question_id = $Question->id; $Groupquestion->group_id = $value; $Groupquestion->user_id = $Question->user_id; $Groupquestion->save(); } } //echo "<pre>";print_r($_POST);echo "</pre>";die(); if ($shareOnLinkedin == '1' && $privacysetting == 'public') { Queue::push('MessageSender@shareQuestionOnLinkedin', array('type' => '9', 'question_id' => $Question->id)); } return Redirect::to('/karma-queries'); } }
public function deletequery() { $id = Input::get('queryId'); $deleteQuestionwillingtohelp = Questionwillingtohelp::where('question_id', '=', $id)->delete(); $deleteGroupQuestion = Groupquestion::where('question_id', '=', $id)->delete(); $deleteQuestion = Question::where('id', '=', $id)->delete(); $deleteKarmafeed = Karmafeed::where('id_type', '=', $id)->whereIn('message_type', array('KarmaQuery', 'OfferHelpTo'))->delete(); $deleteMykarma = Mykarma::where('entry_id', '=', $id)->whereIn('users_role', array('PostedQuery', 'OfferedHelp'))->delete(); echo "Question " . $id . " deleted"; }