public static function storeKarmacirclesfeed($giver, $receiver, $feedtype, $feedtypeId) { if ($feedtype == 'KarmaNote') { $karmaNoteData = Karmanote::where('id', '=', $feedtypeId)->select('id', 'user_idgiver', 'connection_idgiver')->first(); $karmaCircleFeed = new Karmafeed(); if (!empty($karmaNoteData->user_idgiver)) { $karmaCircleFeed->giver_id = $karmaNoteData->user_idgiver; } else { $karmaCircleFeed->giver_id = '0'; } if (!empty($karmaNoteData->connection_idgiver)) { $karmaCircleFeed->karmafeed_connection_id = $karmaNoteData->connection_idgiver; } else { $karmaCircleFeed->karmafeed_connection_id = '0'; } $karmaCircleFeed->receiver_id = $receiver; $karmaCircleFeed->message_type = $feedtype; $karmaCircleFeed->id_type = $feedtypeId; $karmaCircleFeed->save(); } else { $karmaCircleFeed = new Karmafeed(); $karmaCircleFeed->giver_id = $giver; $karmaCircleFeed->receiver_id = $receiver; $karmaCircleFeed->message_type = $feedtype; $karmaCircleFeed->id_type = $feedtypeId; $karmaCircleFeed->save(); } return true; }
public function closeQuestion() { if (!empty(Input::get('question_id'))) { $question_id = Input::get('question_id'); } if (!empty($question_id)) { $Question = Question::find($question_id); $Question->queryStatus = 'closed'; $Question->save(); $usersFeedDelete = Karmafeed::where('id_type', '=', $question_id)->delete(); return Redirect::to('/karma-queries'); } }
public static function otherProfileTrail() { $karmacircleFeed = Karmafeed::select('message_type As type', 'id_type', 'receiver_id', 'giver_id', 'updated_at')->get(); foreach ($karmacircleFeed as $karmaFeed) { $receiverId = $karmaFeed->receiver_id; $giverId = $karmaFeed->giver_id; $karmaFeedMessage = $karmaFeed->type; $karmaFeedId = $karmaFeed->id_type; $karmaFeedDate = $karmaFeed->updated_at; if (!empty($receiverId)) { $receiverData = User::where('id', '=', $receiverId)->select('fname As receiverFirstName', 'lname As receiverLastName', 'piclink As receiverPic')->first(); } if (!empty($giverId)) { $giverData = User::where('id', '=', $giverId)->select('fname As giverFirstName', 'lname As giverLastName', 'piclink As giverPic')->first(); } if ($karmaFeedMessage == 'KarmaNote') { $getKarmaNoteDetails = Karmanote::where('id', '=', $karmaFeedId)->select(array('karmanotes.details As description'))->first(); $karmaNoteFeed[] = array_merge($karmaFeed->toArray(), $getKarmaNoteDetails->toArray(), $giverData->toArray(), $receiverData->toArray()); } else { $karmacircleFeedCount = DB::table('users_karmafeeds')->where('message_type', '=', 'KarmaNote')->count(); if ($karmacircleFeedCount < 1) { $karmaNoteFeed = array(); } } if ($karmaFeedMessage == 'Group') { $getGroupDetails = Group::where('id', '=', $karmaFeedId)->select(array('groups.name As name', 'groups.description As description'))->first(); $groupFeed[] = array_merge($karmaFeed->toArray(), $getGroupDetails->toArray(), $receiverData->toArray()); } else { $karmacircleGroupCount = DB::table('users_karmafeeds')->where('message_type', '=', 'Group')->count(); if ($karmacircleGroupCount < 1) { $groupFeed = array(); } } if ($karmaFeedMessage == 'KarmaQuery') { $getQueryDetails = Question::where('id', '=', $karmaFeedId)->select(array('questions.queryStatus As queryStatus', 'questions.description As description'))->first(); $queryFeed[] = array_merge($karmaFeed->toArray(), $getQueryDetails->toArray(), $receiverData->toArray()); } else { $karmacircleQueryCount = DB::table('users_karmafeeds')->where('message_type', '=', 'Question')->count(); if ($karmacircleQueryCount < 1) { $queryFeed = array(); } } if ($karmaFeedMessage == 'OfferHelpTo') { $getOfferHelpDetails = Question::where('id', '=', $karmaFeedId)->select(array('questions.queryStatus As queryStatus', 'questions.description As description'))->first(); $getOfferHelpCount = Questionwillingtohelp::has('id')->where('user_id', '=', $receiverId)->where('question_id', '=', $karmaFeedId)->count(); $offerHelpToFeed[] = array_merge($karmaFeed->toArray(), $getOfferHelpDetails->toArray(), $receiverData->toArray(), $giverData->toArray()); } else { $offerHelpToFeedCount = DB::table('users_karmafeeds')->where('message_type', '=', 'OfferHelpTo')->count(); if ($offerHelpToFeedCount < 1) { $offerHelpToFeed = array(); } } } $feed = array_merge($karmaNoteFeed, $groupFeed, $queryFeed); $sort = array(); foreach ($feed as $k => $v) { $sort['updated_at'][$k] = $v['updated_at']; } array_multisort($sort['updated_at'], SORT_DESC, $feed); echo "<pre>"; print_r($arr); die; echo '<pre>'; print_r($feed); die; }
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"; }