PHP Util_Orm::add_query_where Examples

Example #1

File: albumimage.php Project: uzura8/flockbird

 public static function get_album_cover_filename($cover_album_image_id = 0, $album_id = 0, $access_from = 'others')
 {
     $public_flag_conds = \Site_Model::get_where_public_flag4access_from($access_from);
     $query = \Util_Orm::add_query_where(self::query(), $public_flag_conds);
     if ($cover_album_image_id) {
         $query->where('id', $cover_album_image_id);
         if ($album_image = $query->get_one()) {
             return $album_image->get_image();
         }
     }
     $query = \Util_Orm::add_query_where(self::query(), $public_flag_conds);
     $query->where('album_id', $album_id);
     $query->order_by('id', 'asc');
     $query->rows_limit(1);
     if (!($album_image = $query->get_one())) {
         return '';
     }
     return $album_image->get_image();
 }