// +---------------------------------------------------------------------- namespace App\Services; use App\Models\GoodsModel; /** * 商品管理-服务类 * @author wesmiler * @since 2020/11/11 * Class GoodsService * @package App\Services */ class GoodsService extends BaseService { /** * 构造函数 * @author wesmiler * @since 2020/11/11 * GoodsService constructor. */ public function __construct() { $this->model = new GoodsModel(); } /** * 获取列表 * @return array * @since 2020/11/11 * @author wesmiler */ public function getList() { $params = request()->all(); $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE; $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE; $dataList = $this->model::from('goods as g') ->leftJoin('goods_cates as c', 'g.cate_id', '=', 'c.id') ->where(function ($query) use ($params) { $query->where('g.mark', 1); $title = isset($params['title']) ? trim($params['title']) : ''; if (!empty($title)) { $query->where('g.title', 'like', "%{$title}%"); } $cateId = isset($params['cate_id']) ? intval($params['cate_id']) : 0; if ($cateId > 0) { $query->where('g.cate_id', $cateId); } else if ($cateId == -1) { $query->where('g.is_recommand', 1); } $status = isset($params['status']) ? $params['status'] : 0; if ($status > 0) { $query->where('g.status', $status); } else { $query->whereIn('g.status', [1, 2]); } }) ->select(['g.id', 'g.cate_id', 'c.name as cate_name', 'g.title', 'g.stock', 'g.price', 'g.specs', 'g.thumb', 'g.status', 'g.create_time', 'g.update_time', 'g.description', 'g.sort', 'g.view_num','g.albums','g.content','g.is_recommand']) ->orderBy('g.update_time', 'desc') ->paginate($pageSize); $dataList = $dataList ? $dataList->toArray() : []; if ($dataList) { foreach ($dataList['data'] as &$item) { $item['thumb'] = $item['thumb'] ? get_image_url($item['thumb']) : ''; $item['albums'] = isset($item['albums']) && $item['albums'] ? json_decode($item['albums'], true) : []; $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : ''; if($item['albums']){ foreach ($item['albums'] as &$v){ $v['url'] = isset($v['url']) && $v['url']? get_image_url($v['url']) : ''; } } } unset($item); } return [ 'code' => 0, 'success'=> true, 'msg' => '操作成功', 'count' => isset($dataList['total']) ? $dataList['total'] : 0, 'data' => isset($dataList['data']) ? $dataList['data'] : 0, ]; } /** * 添加或编辑 * @return array * @since 2020/11/11 * @author wesmiler */ public function edit() { $data = request()->all(); // 图片处理 $image = trim($data['thumb']); $id = isset($data['id']) ? $data['id'] : 0; if (!$id && !$image) { return message('请上传商品图片', false); } if (strpos($image, "temp")) { $data['thumb'] = save_image($image, 'item'); } else { $data['thumb'] = str_replace(IMG_URL, "", $data['thumb']); } // 图册上传处理 if(isset($data['albums'])){ if($data['albums']){ foreach ($data['albums'] as &$v){ $v['url'] = isset($v['url']) && $v['url']? str_replace(IMG_URL, "", $v['url']) : ''; } } $data['albums'] = $data['albums']? json_encode($data['albums'], 256) : ''; } $data['update_time'] = time(); return parent::edit($data); // TODO: Change the autogenerated stub } }