huahuibao/common/services/xhPictureService.php

<?php

namespace common\services;

use common\models\xhPicture;
use Yii;
use common\models\xhOrder;
use common\components\stringUtil;
use common\components\dict;

class xhPictureService
{

    public static function getPictureList($data,$all=false)
    {
        $query      = xhPicture::find();
        $categoryId = isset($data['categoryId']) ? $data['categoryId'] : 0;
        $query->where(['sjId' => 1]);
        $query->andWhere(['categoryId' => $categoryId]);
        $query->orderBy('picSort desc');
        $count = 0;
        $page = 1;
        if($all){
            $models     = $query->asArray()->all();
        }else{
            $countQuery = clone $query;
            $count      = $countQuery->count();
            $page       = isset($data['page']) ? $data['page'] : 1;
            $pageSize   = isset($data['pageSize']) ? $data['pageSize'] : 6;
            $offset     = ($page - 1) * $pageSize;
            $models     = $query->offset($offset)->limit($pageSize)->asArray()->all();
        }
        return ['model' => $models, 'count' => $count, 'page' => $page];
    }

}