screen/application/admin/controller/Goods.php

<?php

namespace app\admin\controller;

use app\common\controller\Backend;
use app\common\model\GoodsBind;
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());
        $this->assign('category',\app\common\model\Category::mall());

    }

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

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

    /**
     * 查看
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = true;
        //设置过滤方法
        $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
                    ->with(['category'])
                    ->where($where)
                    ->order($sort, $order)
                    ->paginate($limit);

            foreach ($list as $row) {

            }

            $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->with(['sku'=>function($q){}])->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']??''));
        if(empty($data['is_kill'])||$data['is_kill']==0){
            unset($data['amount_kill']);
        }
        $this->validate($data,[
            'name|商品名称'=>['require'],
            'describe|描述'=>['require','max:50'],
            'category_id|商品分类'=>['require'],
            'brand|品牌'=>['require'],
            //'amount|售价'=>['require','float','gt:0'],
            //'amount_cost|成本价'=>['require','float','egt:0'],
            'is_kill'=>['require'],
            //'amount_kill|秒杀价'=>['float','gt:0','requireIf:is_kill,1'],
            'logo|LOGO'=>['require','array','min:1','max:6'],
        ]);
        foreach ($data['sku'] as $item){
            $rule=[
                'name|规格名'=>['require'],
                'num_stock|规格库存'=>['require','gt:0'],
                'amount|售价'=>['require','float','gt:0'],
                'amount_cost|成本价'=>['require','float','egt:0'],
            ];
            if($data['is_kill']){
                $rule['amount_kill|秒杀价']=['float','gt:0','require'];
            }
            $this->validate($item,$rule);
        }
        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(!empty($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){
            $this->validate($sku,[
                'name|规格名称'=>['require'],
                'num_stock|库存'=>['require','gt:0'],
                'amount|价格'=>['require','gt:0'],
            ]);
            if(!empty($sku['id'])){
                $SKU=$goods->sku()->find($sku['id']);
                $SKU->save($sku);
            }else{
                $SKU=$goods->sku()->save($sku);
            }
            $ids[]=$SKU['id'];
        }
        $skuDel=$goods->sku()->whereNotIn('id',$ids)->select();
        foreach ($skuDel as $sku_del){
            $sku_del->delete();
        }
        //$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->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->save($temp);
            }else{
                $model=$goods->service()->save($temp);
            }
            $ids[]=$model['id'];
        }
        $goods->service()->whereNotIn('id',$ids)->delete();
        $goods->setAmount();
        Db::commit();
        $this->success();
    }

    public function bind_goods($ids){
        if($this->request->isGet()){
            $goods=$this->model->find($ids);
            $this->assign('row',$goods);
            return $this->fetch();
        }else{
            $data=input('row/a');
            foreach ($data as $goods_sku_id=>$info){
                $skuIds=array_filter(explode(',',$info['goods_id']));
                $sku=GoodsSku::find($goods_sku_id);
                $arr=[];
                foreach ($skuIds as $skuId){
                    $bind_sku=GoodsSku::find($skuId);
                    $arr[$skuId]=[
                        'goods_id'=>$ids,
                        'bind_goods_id'=>$bind_sku['goods_id'],
                    ];
                }
                $sku->bindSku()->sync($arr);
            }
            $this->success();
        }
    }
}