PHP tb_ablum_picture::select示例

示例#1

文件： MainFrameController.php 项目： 252114997/ourshow

 public static function getPicturesOfAblum($ablum_id, $page, $rows)
 {
     $query_builder = tb_ablum_picture::select()->where('ablum_id', $ablum_id);
     $total = $query_builder->count();
     $offset = ($page - 1) * $rows;
     $items = $query_builder->orderBy('tb_ablum_picture.updated_at', 'desc')->leftJoin('tb_pictures', 'tb_pictures.id', '=', 'tb_ablum_picture.picture_id')->skip($offset)->take($rows)->get()->toArray();
     // ->lists('picture_id');
     Util::log_debug("sql=" . $query_builder->toSql());
     Util::log_debug("pictures_of_ablum=" . json_encode($items));
     return array('rows' => $items, 'count' => $total);
 }