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";
}
