// +---------------------------------------------------------------------- namespace App\Services\Common; use App\Models\GoodsModel; use App\Models\StoreModel; use App\Services\BaseService; use App\Services\RedisService; /** * 商家店铺管理-服务类 * @author laravel开发员 * @since 2020/11/11 * @package App\Services\Common */ class StoreService extends BaseService { /** * 构造函数 * @author laravel开发员 * @since 2020/11/11 * AdService constructor. */ public function __construct() { $this->model = new StoreModel(); } /** * 列表 * @param $params * @param int $pageSize * @return array */ public function getDataList($params, $pageSize = 15) { $query = $this->getQuery($params); $list = $query->select(['a.*']) ->orderBy('a.create_time','desc') ->orderBy('a.id','desc') ->paginate($pageSize > 0 ? $pageSize : 9999999); $list = $list? $list->toArray() :[]; if($list){ foreach($list['data'] as &$item){ $item['create_time'] = $item['create_time']? datetime($item['create_time'],'Y-m-d H.i.s') : ''; } } return [ 'pageSize'=> $pageSize, 'total'=>isset($list['total'])? $list['total'] : 0, 'list'=> isset($list['data'])? $list['data'] : [] ]; } /** * 查询 * @param $params * @return \Illuminate\Database\Eloquent\Builder */ public function getQuery($params) { $where = ['a.mark' => 1]; $status = isset($params['status'])? $params['status'] : 1; if($status>0){ $where['a.status'] = $status; }else{ unset($where['a.status']); } $model = $this->model->with(['member']) ->from('stores as a') ->where($where) ->where(function ($query) use($params){ $name = isset($params['name'])? $params['name'] : ''; if($name){ $query->where(function ($query) use ($name){ $query->where('a.name','like',"%{$name}%"); }); } $phone = isset($params['phone'])? $params['phone'] : ''; if($phone){ $query->where(function ($query) use ($phone){ $query->where('a.phone',$phone); }); } }); return $model; } /** * 添加或编辑 * @return array * @since 2020/11/11 * @author laravel开发员 */ public function edit() { $data = request()->all(); // 图片处理 if(isset($data['logo'])){ $data['logo'] = get_image_path($data['logo']); } if(empty($data['name'])){ return message('请填写店铺名称',false); } return parent::edit($data); } }