screen/application/admin/controller/Goods.php

<?php

namespace app\admin\controller;

use app\admin\model\GoodsSize;
use app\admin\model\OrderInfo;
use app\admin\model\User;
use app\common\controller\Backend;
use app\common\model\GoodsBind;
use app\common\model\GoodsDetail;
use app\common\model\GoodsService;
use app\common\model\GoodsSku;
use app\common\model\Refund;
use think\Db;
use think\db\Query;
use Yansongda\Supports\Arr;

/**
 * 商品列管理
 *
 * @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','sku'=>function(Query $query){
                        $query->where('num_stock',0);
                    }])
                    ->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()
    {
        $this->layout=false;
        if($this->request->isGet()){
            $this->assign('row',null);
            return $this->fetch();
        }else{
            $this->makeAdd();
        }
    }

    public function edit($ids = null)
    {
        if($this->request->isGet()){
            $row=$this->model->with(['service','size','sku','detail'])->findOrFail($ids)->toArray();
            foreach ($row['sku'] as &$_sku){
                $_sku['detail']=[];
                $_sku['specValues']=$_sku['name'];
                foreach (explode(',',$_sku['name']) as $idx=>$name){
                    $_sku["sku-{$idx}"]=$name;
                }
                foreach ($row['detail']??[] as $d){
                    if($_sku['name']==$d['sku_name']){
                        $_sku['detail'][]=$d;
                    }
                }
            }

            //return json($row);
            $this->assign('row',$row);
            return $this->fetch('add');
        }else{
            $this->makeAdd();
        }
    }

    protected function makeVal(){
        $data=$this->request->post();
        $data['logo']=array_filter($data['logo']);
        $this->validate($data,[
            'name|商品名称'=>['require'],
            'describe|描述'=>['require','max:50'],
            'category_id|商品分类'=>['require'],
            'brand|品牌'=>['require'],
            'is_kill'=>['require'],
            'logo|LOGO'=>['require','array','min:1','max:6'],
        ]);
        if(empty($data['size'])){
            $this->error('请填写规格');
        }
        if(empty($data['sku'])){
            $this->error('请填写参数');
        }
        foreach ($data['size'] as $key=>$item){
            $this->validate($item,[
                'type|规格名称'=>['require']
            ]);
        }
        foreach ($data['sku'] as $key=>$item){
            $this->validate($item,[
                'amount_cost|成本价'=>['require','float','egt:0'],
                'num_stock|库存'=>['require','float','egt:0'],
                'num_stock_kill|秒杀库存'=>['require','float','egt:0'],
            ]);
            if(empty($item['amount_ladder'])){
                $this->error('请填写售价区间');
            }
            foreach ($item['amount_ladder'] as $ladder){
                $this->validate($ladder,[
                    'min|售价数量区间'=>['require','float','gt:0'],
                    'max|售价数量区间'=>['require','float','gt:0'],
                    'amount|售价区间价格'=>['require','float','gt:0'],
                ]);
            }
            foreach ($item['detail'] as $d){
                $this->validate($d,[
                    'name|规格介绍参数名'=>['require','max:20'],
                    'value|规格介绍参数值'=>['require','max:20'],
                ]);
            }
            if($data['is_kill']) {
                if(empty($item['amount_ladder'])){
                    $this->error('请填写秒杀价区间');
                }
                foreach ($item['amount_kill_ladder'] as $ladder) {
                    $this->validate($ladder, [
                        'min|秒杀价数量区间' => ['require', 'float', 'egt:0'],
                        'max|秒杀价数量区间' => ['require', 'float', 'egt:0'],
                        'amount|秒杀价区间价格' => ['require', 'float', 'egt:0'],
                    ]);
                }
            }
        }
        foreach ($data['service'] as $item){
            $this->validate($item,[
                'name|售后服务参数名'=>['require','max:20'],
                'value|售后服务参数值'=>['require','max:20'],
            ]);
        }
        return $data;
    }

    protected function makeAdd(){
        $data=$this->makeVal();
        if(!empty($data['id'])){
            $goods=$this->model->findOrFail($data['id']);
        }else{
            $goods=new $this->model;
        }
        //dd($data);
        Db::startTrans();
        foreach ($data as $key=>$value){
            if(!in_array($key,$goods::$read) && $goods->hasColumn($key)){
                $goods[$key]=$value;
            }
        }
        $goods->allowField(true)->save();
        $sizeId=[];
        foreach ($data['size'] as $size){
            $size['goods_id']=$goods['id'];
            if(!empty($size['id'])){
                $model=GoodsSize::get($size['id']);
                $model['names']=$size['names'];
                $model['type']=$size['type'];
                $model->save();
            }else{
                $model=GoodsSize::create($size);
            }
            $sizeId[]=$model['id'];
        }
        $goods->size()->whereNotIn('id',$sizeId)->delete();

        $skuId=[];
        $detailId=[];
        foreach ($data['sku'] as $key=>$_sku){
            $sku=Arr::only($_sku,['amount_cost','amount_kill_ladder','amount_ladder','num_stock','num_stock_kill','temp_ids']);
            $sku['name']=$_sku['specValues'];
            $sku['goods_id']=$goods['id'];
            if(!empty($sku['id'])){
                $model=GoodsSku::get($sku['id']);
                $model->allowField(true)->save($sku);
            }else{
                $model=GoodsSku::create($sku);
            }
            $skuId[]=$model['id'];

            foreach ($_sku['detail'] as $detail){
                $detail['sku_name']=$sku['name'];
                $detail['temp_ids']=$sku['temp_ids'];
                if(!empty($detail['id'])){
                    $model=GoodsDetail::get($detail['id']);
                    $model->allowField(true)->save($detail);
                }else{
                    $detail['goods_id']=$goods['id'];
                    $model=GoodsDetail::create($detail);
                }
                $detailId[]=$model['id'];
            }
        }
        $goods->sku()->whereNotIn('id',$skuId)->chunk(10000,function ($sku){
            foreach ($sku as $item){
                $item->delete();
            }
        });
        $goods->detail()->whereNotIn('id',$detailId)->delete();

        $serviceId=[];
        foreach ($data['service'] as $service){
            if(!empty($service['id'])){
                $model=GoodsService::get($service['id']);
                $model->allowField(true)->save($service);
            }else{
                $service['goods_id']=$goods['id'];
                $model=GoodsService::create($service);
            }
            $serviceId[]=$model['id'];
        }
        $goods->service()->whereNotIn('id',$serviceId)->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();
        }
    }
    #商品统计
    public function goods_statistics($ids){
        $row=$this->model->find($ids);
        $this->assign('row',$row);
        $time=input('time')?:sprintf('%s - %s',date('Y-m-d 00:00:00'),date('Y-m-d 23:59:59'));
        $this->assign('time',$time);
        $timeArr=explode(' - ',$time);
        $this->assign('viewCount',$row->viewFavCart()->typeView()->filterDate($timeArr,'date','date')->sum('num'));
        $this->assign('favCount',$row->viewFavCart()->typeFav()->filterDate($timeArr,'date','date')->sum('num'));
        $this->assign('cartCount',$row->viewFavCart()->typeCart()->filterDate($timeArr,'date','date')->sum('num'));
        #单价
        $goodsAmount=OrderInfo::payed()->filterDate($timeArr)
            ->where('goods_id',$row['id'])
            ->group('goods_id')
            ->field('SUM(amount_pay) as amount,SUM(num) as num')
            ->find();
        $this->assign('goodsAmount',$goodsAmount?bcdiv($goodsAmount['amount'],$goodsAmount['num']):0);
        #售后率统计
        $goodsNum=OrderInfo::filterDate($timeArr)
            ->where('goods_id',$row['id'])
            ->sum('num');
        $svcNum=Refund::filterDate($timeArr)
            ->where('goods_id',$row['id'])
            ->filterRefund()
            ->sum('num');
        $this->assign('svcPer',$goodsNum?bcdiv($svcNum,$goodsNum)*100:0);

        return $this->fetch();
    }
    #采购金额排序
    public function goods_buy_rank($ids){
        $row=$this->model->find($ids);
        //当前是否为关联查询
        $this->relationSearch = false;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $filter=json_decode(input('filter'),true);
            $map=[];
            if(!empty($filter['date'])){
                $timeArr=explode(' - ',$filter['date']);
                $timeArr[0]=strtotime($timeArr[0]);
                $timeArr[1]=strtotime($timeArr[1]);
                $map['create_time']=['between',$timeArr];
            }
            $list=OrderInfo::payed()
                ->where('goods_id',$row['id'])
                ->where($map)
                ->group('user_id')
                ->field('user_id,SUM(amount_pay) as amount')
                ->order('amount','desc')
                ->paginate($limit);

            if($list->items()) {
                $userNames = User::whereIn('id', array_column($list->items(), 'user_id'))->column('nickname', 'id');
            }
            $index=$list->listRows()*$list->currentPage()-$list->listRows();
            foreach ($list as $idx=>$item){
                $item['nickname']=$userNames[$item['user_id']]??'-';
                $item['rank']=$index+$idx+1;
            }

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

            return json($result);
        }
        return $this->view->fetch();
    }
    #订单金额排序
    public function order_amount_rank($ids){
        $row=$this->model->find($ids);
        //当前是否为关联查询
        $this->relationSearch = false;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $filter=json_decode(input('filter'),true);
            $map=[];
            if(!empty($filter['date'])){
                $timeArr=explode(' - ',$filter['date']);
                $timeArr[0]=strtotime($timeArr[0]);
                $timeArr[1]=strtotime($timeArr[1]);
                $map['create_time']=['between',$timeArr];
            }
            $list=\app\admin\model\Orders::payed()
                ->hasGoods($row['id'])
                ->where($map)
                ->field('user_id,amount_pay as amount,order_no')
                ->order('amount','desc')
                ->paginate($limit);

            $userNames=User::whereIn('id',array_column($list->items(),'user_id'))->column('nickname','id');
            $index=$list->listRows()*$list->currentPage()-$list->listRows();
            foreach ($list->items() as $idx=>&$item){
                $item['nickname']=$userNames[$item['user_id']]??'-';
                $item['rank']=$index+$idx+1;
            }

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

            return json($result);
        }
        return $this->view->fetch();
    }
    #订单笔数排名
    public function order_num_rank($ids){
        $row=$this->model->find($ids);
        //当前是否为关联查询
        $this->relationSearch = false;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $filter=json_decode(input('filter'),true);
            $map=[];
            if(!empty($filter['date'])){
                $timeArr=explode(' - ',$filter['date']);
                $timeArr[0]=strtotime($timeArr[0]);
                $timeArr[1]=strtotime($timeArr[1]);
                $map['create_time']=['between',$timeArr];
            }
            $list=\app\admin\model\Orders::payed()
                ->hasGoods($row['id'])
                ->where($map)
                ->group('user_id')
                ->field('user_id,count(user_id) as num')
                ->order('num','desc')
                ->paginate($limit);

            $userNames=User::whereIn('id',array_column($list->items(),'user_id'))->column('nickname','id');
            $index=$list->listRows()*$list->currentPage()-$list->listRows();
            foreach ($list as $idx=>$item){
                $item['nickname']=$userNames[$item['user_id']]??'-';
                $item['rank']=$index+$idx+1;
            }

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

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