screen/application/admin/controller/Goods.php

<?php

namespace app\admin\controller;

use app\common\controller\Backend;
use app\common\model\GoodsSku;
use think\Db;

/**
 * 商品列管理
 *
 * @icon fa fa-circle-o
 */
class Goods extends Backend
{

    /**
     * Goods模型对象
     * @var \app\admin\model\Goods
     */
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\admin\model\Goods;
        $this->assign('status',\app\admin\model\Goods::getStatus());

    }

    public function import()
    {
        parent::import();
    }

    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */
    

    /**
     * 查看
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = false;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();

            $list = $this->model
                    
                    ->where($where)
                    ->order($sort, $order)
                    ->paginate($limit);

            foreach ($list as $row) {
                $row->visible(['id','name','brand','amount','amount_kill','is_hot','is_kill','is_down','num_sell','num_stock','create_time','update_time']);
                
            }

            $result = array("total" => $list->total(), "rows" => $list->items());

            return json($result);
        }
        return $this->view->fetch();
    }

    public function add()
    {
        if($this->request->isGet()){
            return $this->fetch();
        }else{
            $this->makeAdd();
        }
    }

    public function edit($ids = null)
    {
        if($this->request->isGet()){
            $row=$this->model->findOrFail($ids);
            $this->assign('row',$row);
            return $this->fetch('add');
        }else{
            $this->makeAdd();
        }
    }

    protected function makeVal(){
        $data=input('row/a');
        $data['logo']=array_filter(explode(',',$data['logo']??''));
        $this->validate($data,[
            'name|商品名称'=>['require'],
            'brand|品牌'=>['require'],
            'amount|售价'=>['require','float','gt:0'],
            'is_kill'=>['require'],
            'amount_kill|秒杀价'=>['float','gt:0','requireIf:is_kill,1'],
            'logo|LOGO'=>['require','array','min:1'],
        ]);
        foreach ($data['sku'] as $item){
            $this->validate($item,[
                'name|规格名'=>['require'],
                'num_stock|规格库存'=>['require','gt:0'],
            ]);
        }
        foreach ($data['detail'] as $item){
            $this->validate($item,[
                'name|规格参数名'=>['require'],
                'value|规格参数值'=>['require','gt:0'],
            ]);
        }
        foreach ($data['service'] as $item){
            $this->validate($item,[
                'name|售后服务参数名'=>['require'],
                'value|售后服务参数值'=>['require','gt:0'],
            ]);
        }
        return $data;
    }

    protected function makeAdd(){
        $data=$this->makeVal();
        if(isset($data['id'])){
            $goods=$this->model->findOrFail($data['id']);
        }else{
            $goods=new $this->model;
        }
        Db::startTrans();
        foreach ($data as $key=>$value){
            if(!in_array($key,$goods::$read)){
                $goods[$key]=$value;
            }
        }
        $goods->allowField(true)->save();
        $ids=[];
        foreach ($data['sku'] as $sku){
            if(!empty($sku['id'])){
                $SKU=$goods->sku()->find($sku['id']);
                $SKU->allowField(true)->save($sku);
            }else{
                $SKU=$goods->sku()->save($sku);
            }
            $ids[]=$SKU['id'];
        }
        $goods->sku()->whereNotIn('id',$ids)->update(['is_del'=>1]);
        $ids=[];
        foreach ($data['detail'] as $temp){
            if(!empty($temp['id'])){
                $model=$goods->detail()->find($temp['id']);
                $model->allowField(true)->save($temp);
            }else{
                $model=$goods->detail()->save($temp);
            }
            $ids[]=$model['id'];
        }
        $goods->detail()->whereNotIn('id',$ids)->delete();
        $ids=[];
        foreach ($data['service'] as $temp){
            if(!empty($temp['id'])){
                $model=$goods->service()->find($temp['id']);
                $model->allowField(true)->save($temp);
            }else{
                $model=$goods->service()->save($temp);
            }
            $ids[]=$model['id'];
        }
        $goods->service()->whereNotIn('id',$ids)->delete();
        Db::commit();
        $this->success();
    }
}