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