コード例 #1
0
ファイル: User.php プロジェクト: Incubasys/sql_query_help
 public function get_all_users()
 {
     $sort_by = Input::get('sort_by');
     $user = User::where('id', '>', 0)->where('active', '=', 1)->get()->toArray();
     $user_data = array();
     foreach ($user as $u_user) {
         if ($u_user['rank'] == 0) {
             $ans_status = new Answers_status();
             $u_user['rank'] = $ans_status->get_user_rank($u_user['id']);
         }
         array_push($user_data, $u_user);
     }
     if (!empty($sort_by)) {
         if ($sort_by == 'rank') {
             usort($user_data, function ($a, $b) {
                 // usort — Sort an array by values using a user-defined comparison function
                 return $b['rank'] - $a['rank'];
             });
         } elseif ($sort_by == 'name') {
             //                usort($user_data, function($a, $b) {  //  usort — Sort an array by values using a user-defined comparison function
             //                    return strcmp($a['name'] , $b['name']);
             //                });
             ksort($user_data);
         }
     }
     return $user_data;
 }
コード例 #2
0
 public function get_user_rank_where_in($ids_array)
 {
     $status = Answers_status::whereIn('user_id', $ids_array)->where('status', '=', 1)->get();
     if (count($status) > 0) {
         return $status->toArray();
     } else {
         return "";
     }
 }
コード例 #3
0
 public function post_status($ans_id, $u_id, $status)
 {
     if ($ans_id != null && $u_id != null) {
         $post_like = new Answers_status();
         $check_user = $post_like->check_validity_to_post_status($ans_id, $u_id);
         if (!$check_user) {
             $is_posdt_like = $post_like->post_status($ans_id, $u_id, $status);
             if ($is_posdt_like) {
                 return redirect("user/listing");
             }
             return redirect("user/profile");
         } else {
             $message = "you cannot mark like/dislike/spam any answer AGAIN!";
             return view("welcome")->withStatusMessage($message);
         }
     } else {
         $message = "answer id or user id is null";
         return view("welcome")->withMessage($message);
     }
 }