public function getdataByorder()
{
$currentTab = Input::get('currentTab');
$setting = Input::get('setting');
$groupId = Input::get('groupId');
$group_question = "";
$All_groups[] = array($groupId);
$CurrentUserId = 0;
$CurrentUser = "";
if (Auth::check()) {
$CurrentUser = Auth::User();
$CurrentUserId = $CurrentUser->id;
if ($CurrentUserId != "") {
$CurrentUserId = $CurrentUserId;
}
}
if ($currentTab == "topquery") {
$group_question = DB::table('users_groups')->join('questions', 'users_groups.user_id', '=', 'questions.user_id')->select(array('questions.*', 'users_groups.group_id'))->where('questions.user_id', '!=', $CurrentUserId)->where('users_groups.group_id', '=', $groupId)->where('questions.queryStatus', '=', 'open')->orderBy('questions.created_at', 'DESC')->get();
if ($setting == 'Recent') {
if (!empty($group_question)) {
foreach ($group_question as $key => $value) {
if (isset($value->user_id)) {
$value->user_id = User::find($value->user_id);
}
if (isset($value->id)) {
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->giver_Count = Question::find($value->id)->GiversHelp()->count();
}
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if (isset($giver_Info->user_id)) {
$toppers[] = $giver_Info->user_id;
if ($giver_Info->user_id == $CurrentUserId) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
} elseif ($setting == 'Unanswered') {
if (!empty($group_question)) {
foreach ($group_question as $key => $value) {
if (isset($value->user_id)) {
$value->user_id = User::find($value->user_id);
}
if (isset($value->id)) {
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->giver_Count = Question::find($value->id)->GiversHelp()->count();
}
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if (isset($giver_Info->user_id)) {
$toppers[] = $giver_Info->user_id;
if ($giver_Info->user_id == $CurrentUserId) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
$group_question = array_values(array_sort($group_question, function ($value) {
return $value->giver_Count;
}));
}
} elseif ($setting == 'Populer') {
if (!empty($group_question)) {
foreach ($group_question as $key => $value) {
if (isset($value->user_id)) {
$value->user_id = User::find($value->user_id);
}
if (isset($value->id)) {
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->giver_Count = Question::find($value->id)->GiversHelp()->count();
}
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if (isset($giver_Info->user_id)) {
$toppers[] = $giver_Info->user_id;
if ($giver_Info->user_id == $CurrentUserId) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
$group_question = array_values(array_sort($group_question, function ($value) {
return $value->giver_Count;
}));
$group_question = array_reverse($group_question);
}
}
}
return View::make('group.ajax_group_queryOrder', array('group_question' => $group_question, 'coutTopQuery' => 0, 'CurrentUserId' => $CurrentUserId));
}
public static function SendEmailToNonKarma($type, $connection_giverId, $receiverId, $meetingId, $giver_email)
{
$type = 14;
$receiverDetail = User::find($receiverId);
$giverDetail = Connection::find($connection_giverId);
$ReceiverName = $receiverDetail->fname . ' ' . $receiverDetail->lname;
$subject = "KarmaNote received from " . $receiverDetail->fname . " " . $receiverDetail->lname;
$fullname = $giverDetail->fname . ' ' . $giverDetail->lname;
$to = $giver_email;
// fetch
$karmaNoteDetail = Karmanote::where('req_id', '=', $meetingId)->first();
$url = KarmaHelper::generateURL($meetingId, $receiverDetail, $giverDetail, '0');
$message_email = array();
$message_email['karmanote'] = $karmaNoteDetail->details;
$message_email['skills'] = KarmaHelper::getSkillsname($karmaNoteDetail->skills);
Mail::send('emails.nonkcusernoterecieved', array('Content' => $message_email, 'giverDetail' => $giverDetail, 'receiverDetail' => $receiverDetail, 'subject' => $subject, 'url' => $url), function ($message) use($to, $subject, $fullname, $giverDetail, $receiverDetail) {
$from = $receiverDetail->fname . ' ' . $receiverDetail->lname;
$fromname = $from . " via karmacircles";
$message->to($to, $fullname)->replyTo($receiverDetail->email, $from)->subject($subject)->from('*****@*****.**', $fromname);
});
}
public function loadmoreProfile()
{
//Karma notes block
$karmaTrailUser = $karmaReceivedUser = $karmaSentUser = '';
$profileSelf = 0;
$CurrentUserDetail = "";
$CurrentUserId = 0;
if (!empty($_REQUEST)) {
$start = $_REQUEST['hitcount'] + 1;
$action = $_REQUEST['action'];
$id = $_REQUEST['userProfile'];
$perpage = 10;
$profileUserDetail = User::find($id);
if (Auth::check()) {
$CurrentUserDetail = Auth::User();
$CurrentUserId = $CurrentUserDetail->id;
if ($CurrentUserId == $profileUserDetail['id']) {
$profileSelf = "1";
} else {
$profileSelf = "0";
}
}
if ($action == 'KarmaTrail') {
$karmaTrail = KarmaHelper::getKarmaTrail($id, $start, $perpage);
if (count($karmaTrail) > 0) {
foreach ($karmaTrail as $trail) {
$userSkills = "";
$karma['user_id_receiver'] = User::find($trail->user_id_receiver)->toArray();
if (!empty($trail->user_id_giver)) {
$karma['user_id_giver'] = User::find($trail->user_id_giver)->toArray();
} else {
$karma['user_id_giver'] = Connection::find($trail->connection_id_giver)->toArray();
}
if ($id == $trail->user_id_receiver) {
$karma['status'] = $trail->statusreceiver;
} else {
$karma['status'] = $trail->statusgiver;
}
$karma['piclink'] = $trail->piclink;
$karma['karmaNotes'] = $trail->details;
if (!empty($trail->skills)) {
$userSkills = KarmaHelper::getSkillsname($trail->skills);
}
$karma['skills'] = $userSkills;
$karma['req_id'] = $trail->req_id;
$karma['meetingdatetime'] = date('F d, Y', strtotime($trail->meetingdatetime));
$karma['created_at'] = date('F d, Y', strtotime($trail->created_at));
$karmaTrailUser[] = $karma;
}
}
}
//echo "<pre>";print_r($karmaTrailUser);echo "</pre>";die;
if ($action == 'KarmaNotesReceived') {
$karmaReceived = $profileUserDetail->KarmanoteReceiver()->orderBy('karmanotes.created_at', 'desc')->skip($start)->take($perpage)->get();
if (!empty($karmaReceived)) {
foreach ($karmaReceived->toArray() as $received) {
$userReceivedSkills = "";
$karmareceived['user_id_receiver'] = User::find($received['user_idreceiver'])->toArray();
if (!empty($received['user_id_giver'])) {
$karmareceived['user_id_giver'] = User::find($received['user_idgiver'])->toArray();
} else {
$karmareceived['user_id_giver'] = Connection::find($received['connection_idgiver'])->toArray();
}
$karmareceived['karmaNotes'] = $received['details'];
if (!empty($received['skills'])) {
$userReceivedSkills = KarmaHelper::getSkillsname($received['skills']);
}
$karmareceived['skills'] = $userReceivedSkills;
$karmareceived['status'] = $received['statusgiver'];
$karmareceived['req_id'] = $received['req_id'];
$karmareceived['req_detail'] = Meetingrequest::find($received['req_id']);
$karmareceived['created_at'] = date('F d, Y', strtotime($received['created_at']));
$karmaReceivedUser[] = $karmareceived;
}
}
}
//echo "<pre>";print_r($karmaReceived->toArray());echo "</pre>";die;
if ($action == 'KarmaNotesSent') {
$karmaSent = $profileUserDetail->KarmanoteGiver()->orderBy('karmanotes.created_at', 'desc')->skip($start)->take($perpage)->get();
//echo "<pre>";print_r($karmaSent->toArray());echo "</pre>";die;
if (!empty($karmaSent)) {
foreach ($karmaSent->toArray() as $sent) {
$userSentSkills = "";
$karmasent['user_id_receiver'] = User::find($sent['user_idreceiver'])->toArray();
if (!empty($sent['user_idgiver'])) {
$karmasent['user_id_giver'] = User::find($sent['user_idgiver'])->toArray();
} else {
$karmasent['user_id_giver'] = Connection::find($sent['connection_idgiver'])->toArray();
}
$karmasent['karmaNotes'] = $sent['details'];
if (!empty($sent['skills'])) {
$userSentSkills = KarmaHelper::getSkillsname($sent['skills']);
}
$karmasent['skills'] = $userSentSkills;
$karmasent['req_id'] = $sent['req_id'];
$karmasent['req_detail'] = Meetingrequest::find($sent['req_id'])->toArray();
$karmasent['status'] = $sent['statusreceiver'];
$karmasent['created_at'] = date('F d, Y', strtotime($sent['created_at']));
$karmaSentUser[] = $karmasent;
}
}
}
return View::make('ajax_loadmoreProfile', array('id' => $id, 'CurrentUserDetail' => $CurrentUserDetail, 'profileSelf' => $profileSelf, 'karmaTrail' => $karmaTrailUser, 'profileUserDetail' => $profileUserDetail, 'countTrail' => 0, 'countReceived' => 0, 'countSent' => 0, 'profielURL' => '', 'karmascore' => '', 'karmaReceived' => $karmaReceivedUser, 'karmaSent' => $karmaSentUser));
}
}
public static function getAdminReportNote($request_id, $user_id, $begin, $end)
{
$karmaTrailUser = $karmaTrailDet = $karmaTrail = '';
$getUser = "";
$getUser = KarmaHelper::getTestUsers();
if ($user_id != 0) {
$testchk = in_array($user_id, $getUser);
}
$query = Karmanote::query();
if ($request_id == 0) {
if ($user_id != 0 && $testchk != 1 && $begin != 0 && $end != 0) {
$karmaTrail = DB::select(DB::raw("select `karmanotes`.* from `karmanotes` where (`karmanotes`.`user_idreceiver` = " . $user_id . " or `karmanotes`.`user_idgiver` = " . $user_id . " or `karmanotes`.`connection_idgiver` = " . $user_id . " ) and `karmanotes`.`created_at` between '" . $begin . "' and '" . $end . "' order by `karmanotes`.`created_at` desc"));
}
if ($user_id == 0 && $begin != 0 && $end != 0) {
$karmaTrail = DB::select(DB::raw("select `karmanotes`.* from `karmanotes` where `karmanotes`.`created_at` between '" . $begin . "' and '" . $end . "' order by `karmanotes`.`created_at` desc"));
}
if ($user_id == 0 && $begin == 0 && $end == 0) {
$karmaTrail = DB::select(DB::raw("select `karmanotes`.* from `karmanotes` order by `karmanotes`.`created_at` desc"));
}
} else {
$karmaTrailDet = DB::table('karmanotes')->where('karmanotes.req_id', '=', $request_id)->orderBy('karmanotes.created_at', 'desc')->select('karmanotes.*')->distinct()->first();
}
//echo"<pre>==".$user_id."====";print_r($karmaTrail);echo"</pre>====="; die;
if (!empty($karmaTrail)) {
foreach ($karmaTrail as $trail) {
$userSkills = "";
$rcvr = in_array($trail->user_idreceiver, $getUser);
if (isset($trail->user_idreceiver) && $rcvr != 1) {
$karma['user_idreceiver'] = User::find($trail->user_idreceiver)->toArray();
} else {
$karma['user_idreceiver'] = "";
}
$giver = in_array($trail->user_idgiver, $getUser);
if (!empty($trail->user_idgiver) && $giver != 1) {
$karma['user_idgiver'] = User::find($trail->user_idgiver)->toArray();
} else {
$connection = in_array($trail->connection_idgiver, $getUser);
if (!empty($trail->connection_idgiver) && $connection != 1) {
$karma['user_idgiver'] = Connection::find($trail->connection_idgiver)->toArray();
} else {
$karma['user_idgiver'] = "";
}
}
if ($user_id == $trail->user_idreceiver) {
$karma['status'] = $trail->statusreceiver;
} else {
$karma['status'] = $trail->statusgiver;
}
//$karma['piclink'] = $trail->piclink;
$karma['karmaNotes'] = $trail->details;
if (!empty($trail->skills)) {
$userSkills = KarmaHelper::getSkillsname($trail->skills);
}
$karma['skills'] = $userSkills;
$karma['req_id'] = $trail->req_id;
//$karma['meetingdatetime'] = date('F d, Y', strtotime($trail->meetingdatetime));
$karma['created_at'] = date('F d, Y', strtotime($trail->created_at));
$karmaTrailUser[] = $karma;
}
}
if (!empty($karmaTrailDet)) {
$userSkills = "";
$karma['karmaNotes'] = $karmaTrailDet->details;
if (!empty($karmaTrailDet->skills)) {
$userSkills = KarmaHelper::getSkillsname($karmaTrailDet->skills);
}
$karma['skills'] = $userSkills;
$karma['req_id'] = $karmaTrailDet->req_id;
$karma['statusgiver'] = $karmaTrailDet->statusgiver;
$karma['statusreceiver'] = $karmaTrailDet->statusreceiver;
$karma['created_at'] = date('F d, Y', strtotime($karmaTrailDet->created_at));
$karmaTrailUser[] = $karma;
}
return $karmaTrailUser;
}
public function getdataByorder()
{
$currentTab = Input::get('currentTab');
$setting = Input::get('setting');
$CurrentUser = Auth::User();
$access = 'public';
//$Usergroup = Auth::User()->Groups;
//$groupCount = count($Usergroup);
$All_groups_id = $All_groups = $All_groupset = $group_question = '';
$groupQue_id = array();
if (!empty($CurrentUser)) {
$Userquery = DB::table('karmacircles_users')->where('user_id', $CurrentUser->id)->get();
foreach ($Userquery as $key => $value) {
if (!empty($value->givers)) {
$user_id_giver = explode(',', $value->givers);
} else {
$user_id_giver = array();
}
if (!empty($value->takers)) {
$user_id_taker = explode(',', $value->takers);
} else {
$user_id_taker = array();
}
if (!empty($value->givers_takers)) {
$user_id_giver_taker = explode(',', $value->givers_takers);
} else {
$user_id_giver_taker = array();
}
$user_data = array_merge($user_id_giver, $user_id_taker, $user_id_giver_taker);
$result_unique_data = array_unique($user_data);
$result_unique_data = array_filter($result_unique_data);
$result_unique_data_id = implode(',', $result_unique_data);
}
}
if ($currentTab == "myquestion") {
$myquestion = "";
if ($setting == 'Recent') {
$myquestion = Auth::User()->Questions()->orderBy('created_at', 'DESC')->get();
if (!empty($myquestion)) {
foreach ($myquestion as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
$giver_Info->user_id = User::find($giver_Info->user_id);
}
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
} elseif ($setting == 'Unanswered') {
$question_willingtohelp = DB::select(DB::raw("select count(question_id) as countQuestion,question_id from users_question_willingtohelp group by question_id"));
if (!empty($question_willingtohelp)) {
$question_willingtohelp_after_sort = array_values(array_sort($question_willingtohelp, function ($value) {
return $value->countQuestion;
}));
$question_value = array_reverse($question_willingtohelp_after_sort);
foreach ($question_value as $key => $value) {
$question_id = $value->question_id;
$question_id_value[] = $question_id;
}
} else {
$question_id_value[] = 0;
}
$myquestion = Auth::User()->Questions()->where('questions.queryStatus', 'open')->whereNotIn('questions.id', $question_id_value)->orderBy('created_at', 'DESC')->get();
if (!empty($myquestion)) {
foreach ($myquestion as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
$giver_Info->user_id = User::find($giver_Info->user_id);
}
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
$myquestion = array_values(array_sort($myquestion, function ($value) {
return $value->giver_Count;
}));
} elseif ($setting == 'Populer') {
$myquestion = DB::select(DB::raw("SELECT count(users_question_willingtohelp.question_id) as countId,users_question_willingtohelp.question_id,questions.id,questions.queryStatus,questions.question_url,questions.created_at,questions.skills,questions.subject,questions.user_id FROM questions RIGHT JOIN users_question_willingtohelp ON questions.id=users_question_willingtohelp.question_id where questions.user_id=" . $CurrentUser->id . " group by users_question_willingtohelp.question_id"));
if (!empty($myquestion)) {
foreach ($myquestion as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
$giver_Info->user_id = User::find($giver_Info->user_id);
}
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
//echo "<pre>";print_r($myquestion);echo "</pre>";die();
$myquestion = array_values(array_sort($myquestion, function ($value) {
return $value->countId;
}));
$myquestion = array_reverse($myquestion);
//$myquestion[]=new question($myquestion,true);
}
return View::make('ajax_queryOrderMyquestion', array('CurrentUser' => $CurrentUser, 'myquestion' => $myquestion));
} elseif ($currentTab == "groupquestion") {
//$group_question = DB::select(DB::raw('select users.id,questions.question_url,questions.subject,questions.skills,questions.queryStatus,questions.created_at,questions.user_id from questions right join users on questions.user_id = users.id where users.id IN ('.$result_unique_data_id.') And questions.querystatus="open" AND questions.user_id != "'.$CurrentUser->id.'" order by users.karmascore desc, questions.created_at desc'));
$group_question = '';
if ($setting == 'Recent') {
//echo '<pre>';print_r($result_unique_data);die;
$group_question = DB::table('questions')->leftJoin('users', 'questions.user_id', '=', 'users.id')->select(array('questions.*'))->whereIn('questions.user_id', $result_unique_data)->where('questions.querystatus', '=', 'open')->where('questions.user_id', '!=', $CurrentUser->id)->orderBy('questions.created_at', 'DESC')->get();
if (!empty($group_question)) {
foreach ($group_question as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if ($giver_Info->user_id == $CurrentUser->id) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
} elseif ($setting == 'Unanswered') {
$question_willingtohelp = DB::select(DB::raw("select count(question_id) as countQuestion,question_id from users_question_willingtohelp group by question_id"));
if (!empty($question_willingtohelp)) {
$question_willingtohelp_after_sort = array_values(array_sort($question_willingtohelp, function ($value) {
return $value->countQuestion;
}));
$question_value = array_reverse($question_willingtohelp_after_sort);
foreach ($question_value as $key => $value) {
$question_id = $value->question_id;
$question_id_value[] = $question_id;
}
} else {
$question_id_value[] = 0;
}
$group_question = DB::table('questions')->where('questions.querystatus', '=', 'open')->where('questions.user_id', '!=', $CurrentUser->id)->whereIn('questions.user_id', $result_unique_data)->whereNotIn('questions.id', $question_id_value)->orderBy('questions.created_at', 'DESC')->get();
//echo '<pre>';print_r($allquestion);die;
if (!empty($group_question)) {
foreach ($group_question as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->giver_Count = Question::find($value->id)->GiversHelp()->count();
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if ($giver_Info->user_id == $CurrentUser->id) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
$group_question = array_values(array_sort($group_question, function ($value) {
return $value->giver_Count;
}));
} elseif ($setting == 'Populer') {
$question_willingtohelp = DB::select(DB::raw("select count(question_id) as countQuestion,question_id from users_question_willingtohelp group by question_id"));
if (!empty($question_willingtohelp)) {
$question_willingtohelp_after_sort = array_values(array_sort($question_willingtohelp, function ($value) {
return $value->countQuestion;
}));
$question_value = array_reverse($question_willingtohelp_after_sort);
foreach ($question_value as $key => $value) {
$question_id = $value->question_id;
$question_id_value[] = $question_id;
}
} else {
$question_id_value[] = 0;
}
$group_question = DB::table('questions')->where('questions.querystatus', '=', 'open')->where('questions.user_id', '!=', $CurrentUser->id)->whereIn('questions.user_id', $result_unique_data)->whereIn('questions.id', $question_id_value)->orderBy('questions.created_at', 'DESC')->get();
if (!empty($group_question)) {
foreach ($group_question as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->giver_Count = Question::find($value->id)->GiversHelp()->count();
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if ($giver_Info->user_id == $CurrentUser->id) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
$group_question = array_values(array_sort($group_question, function ($value) {
return $value->giver_Count;
}));
$group_question = array_reverse($group_question);
}
//echo "<pre>";print_r($group_question);echo "</pre>";die();
return View::make('ajax_queryOrder', array('CurrentUser' => $CurrentUser, 'questionType' => $group_question));
} elseif ($currentTab == "allQuestion") {
$allquestion = '';
if ($setting == 'Recent') {
$allquestion = DB::table('questions')->leftJoin('users', 'questions.user_id', '=', 'users.id')->select(array('questions.*'))->where('questions.querystatus', '=', 'open')->where('questions.user_id', '!=', $CurrentUser->id)->orderBy('questions.created_at', 'DESC')->get();
if (!empty($allquestion)) {
foreach ($allquestion as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if ($giver_Info->user_id == $CurrentUser->id) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
} elseif ($setting == 'Unanswered') {
$question_willingtohelp = DB::select(DB::raw("select count(question_id) as countQuestion,question_id from users_question_willingtohelp group by question_id"));
if (!empty($question_willingtohelp)) {
$question_willingtohelp_after_sort = array_values(array_sort($question_willingtohelp, function ($value) {
return $value->countQuestion;
}));
$question_value = array_reverse($question_willingtohelp_after_sort);
foreach ($question_value as $key => $value) {
$question_id = $value->question_id;
$question_id_value[] = $question_id;
}
} else {
$question_id_value[] = 0;
}
$allquestion = DB::table('questions')->where('questions.querystatus', '=', 'open')->where('questions.user_id', '!=', $CurrentUser->id)->whereNotIn('questions.id', $question_id_value)->orderBy('questions.created_at', 'DESC')->get();
//echo '<pre>';print_r($allquestion);die;
if (!empty($allquestion)) {
foreach ($allquestion as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->giver_Count = Question::find($value->id)->GiversHelp()->count();
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if ($giver_Info->user_id == $CurrentUser->id) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
}
} elseif ($setting == 'Populer') {
$allquestion = DB::select(DB::raw("SELECT count(users_question_willingtohelp.question_id) as countId,users_question_willingtohelp.question_id,questions.id,questions.queryStatus,questions.question_url,questions.created_at,questions.skills,questions.subject,questions.user_id FROM questions RIGHT JOIN users_question_willingtohelp ON questions.id=users_question_willingtohelp.question_id where questions.queryStatus='open' And questions.user_id !=" . $CurrentUser->id . " group by users_question_willingtohelp.question_id"));
if (!empty($allquestion)) {
foreach ($allquestion as $key => $value) {
$value->user_id = User::find($value->user_id);
$value->giver_Info = Question::find($value->id)->GiversHelp;
$value->giver_Count = Question::find($value->id)->GiversHelp()->count();
$value->answered = 0;
if (!$value->giver_Info->isEmpty()) {
foreach ($value->giver_Info as $key => $giver_Info) {
if ($giver_Info->user_id == $CurrentUser->id) {
$value->answered = 1;
} else {
if ($value->answered != '1') {
$value->answered = 0;
}
}
$giver_Info->user_id = User::find($giver_Info->user_id);
}
} else {
$value->answered = 0;
}
$value->skills = KarmaHelper::getSkillsname($value->skills);
}
$allquestion = array_values(array_sort($allquestion, function ($value) {
return $value->giver_Count;
}));
$allquestion = array_reverse($allquestion);
}
}
//echo "<pre>";print_r($allquestion);echo "</pre>";die();
return View::make('ajax_queryOrder', array('CurrentUser' => $CurrentUser, 'questionType' => $allquestion));
}
}
