// +---------------------------------------------------------------------- namespace App\Services\Common; use App\Models\FreightPackageModel; use App\Services\BaseService; use App\Services\RedisService; /** * 货物包装管理-服务类 * @author laravel开发员 * @since 2020/11/11 * Class FreightPackageService * @package App\Services\Common */ class FreightPackageService extends BaseService { // 静态对象 protected static $instance = null; /** * 构造函数 * @author laravel开发员 * @since 2020/11/11 */ public function __construct() { $this->model = new FreightPackageModel(); } /** * 静态入口 */ public static function make() { if (!self::$instance) { self::$instance = new static(); } return self::$instance; } /** * 列表 * @param $params * @param int $pageSize * @return array */ public function getDataList($params, $pageSize = 15) { $where = ['a.mark' => 1]; $list = $this->model->from('freight_package as a') ->where($where) ->where(function ($query) use($params){ $keyword = isset($params['keyword'])? $params['keyword'] : ''; if($keyword){ $query->where('a.name','like',"%{$keyword}%"); } }) ->where(function ($query) use($params){ $status = isset($params['status'])? $params['status'] : 0; if($status>0 && is_array($status)){ $query->whereIn('a.status', $status); }else if($status){ $query->where('a.status', $status); } $type = isset($params['type'])? $params['type'] : 0; if($type>0){ $query->where('a.type', $type); } }) ->select(['a.*']) ->orderBy('a.create_time','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'] : [] ]; } /** * 编辑 * @return array */ public function edit() { $data = request()->post(); return parent::edit($data); } /** * 车型选项 * @param int $num * @return array|mixed */ public function getOptions($type=0, $num = 20) { $cacheKey = "caches:index:freight_package_{$type}"; $datas = RedisService::get($cacheKey); if($datas){ return $datas; } $where = ['status'=>1,'mark'=>1]; $datas = $this->model->where($where) ->where(function($query) use($type){ if($type){ $query->whereIn('type',[0, $type]); } }) ->select(['id','name','type','status']) ->limit($num) ->orderBy('sort','desc') ->orderBy('id','asc') ->get(); $datas = $datas? $datas->toArray() : []; if($datas){ RedisService::set($cacheKey, $datas, rand(5, 10)); } return $datas; } }