예제 #1
0
 public static function getNotification($id)
 {
     $res = User::getNotificationSender($id);
     $res1 = DB::select("select distinct(rr.request_id), s.name as s_name, r.user_id as r_id, r.name as r_name\n                    , p.title as p_name,rr.request_id as id, rr.status, p.project_id as p_id\n                    from Request rr\n                     inner join User s on s.user_id = rr.sender_id\n                     inner join User r on r.user_id = rr.reciever_id\n                     inner join Project p on p.project_id = rr.project_id\n                     where  rr.reciever_id=? and status=0", array($id));
     return array_merge($res, $res1);
 }