Пример #1
0
 public function run()
 {
     $user_id = intval(Input::get('user_id', 0));
     $user = UserORM::find($user_id);
     if (empty($user)) {
         return '用户未找到';
     }
     $sql = "SELECT a.*, al.source FROM album as a LEFT JOIN album_source as al ON al.album_id = a.id WHERE a.user_id = " . $user_id . " AND al.is_front = " . BaseORM::ENABLE . "  ORDER BY a.id DESC";
     $results = DB::select(DB::raw($sql));
     return AlbumModel::listData($results);
 }