Example #1
0
 public static function get_closed_ccproject_thread($proj_id, $bdo_id)
 {
     $thread = DB::table('project_thread')->select('project_thread.*', 'users.image', 'users.first_name', 'users.last_name')->join('users', 'users.id', '=', 'project_thread.user_id')->where('project_thread.proj_id', $proj_id)->where('project_thread.returned', 2)->orderBy('id', 'desc')->get();
     $data = array();
     foreach ($thread as $key => $value) {
         $data[$key] = $value;
         $data[$key]->files = Project::getFiles($value->id);
     }
     foreach ($thread as $key => $value) {
         $data[$key] = $value;
         $data[$key]->file = Project::getFile($value->id);
     }
     return $data;
 }