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