screen/application/api/controller/Programme.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use app\common\model\Goods;
use app\common\model\GoodsInstall;
use app\common\model\GoodsInstallLink;
use app\common\model\GoodsSku;
use app\common\model\OrderInfo;
use app\common\model\ProgrammeGoods;
use app\common\model\Refund;
use app\common\service\InstallService;
use app\common\service\OrderService;
use think\Db;
use app\common\model\Orders as Order;

/**
 * 快速报价接口
 * @inheritdoc
 */
class Programme extends Api
{
    protected $noNeedRight="*";
    protected $noNeedLogin=['calculate'];
    /**
     * 预估报价
     * @ApiMethod (POST)
     * @ApiParams (name=sku,description="key为规格id,对象：num购买数量，num_install安装数量，{1:{num:1,num_install:2}})
     * ApiReturnParams (name=logo,description=logo)
     * @ApiReturnParams (name=name,description=商品名称)
     * @ApiReturnParams (name=sku,description=规格)
     * @ApiReturnParams (name=amount,description=单价)
     * @ApiReturnParams (name=amount_install,description=安装费)
     * @ApiReturnParams (name=amount_total,description=共计)
     *@ApiReturnParams (name=total,description=预估报价)
     * @ApiReturnParams (name=num,description=采购数量)
     * @ApiReturnParams (name=num_install,description=安装数量)
     * @ApiReturnParams (name=category_id,description=商品分类id)
     * @ApiReturnParams (name=amount_install_single,description=安装费单价)
    */
    public function calculate(){
        $sku = input('sku');
        if(!$sku){
           $this->error('请传商品信息');
        }
        $sku = htmlspecialchars_decode($sku);
        $sku = json_decode($sku,true);
        $goods = [];
        $goodsModel = new Goods();
        $goodsSkuModel = new GoodsSku();
        $total = 0;
        foreach ($sku as $k=>$v){
            $goodsSku = $goodsSkuModel->where('id',$k)->find();
            $nowGoods = $goodsModel->where('id',$goodsSku['goods_id'])->find();
            $goods[$k]['logo'] = $nowGoods['logo'];
            $goods[$k]['name'] = $nowGoods['name'];
            $goods[$k]['sku'] = $goodsSku['name'];
            $goods[$k]['sku_id'] = $k;
            $goods[$k]['num'] = $v['num'];
            $goods[$k]['category_id'] = $nowGoods['category_id'];
            $goods[$k]['num_install'] = $v['num_install'];
            $goods[$k]['amount'] = $goodsSku['amount'];//单价
            $goods[$k]['amount_install']=InstallService::getFee([$k=>$v]);//安装费
            $goods[$k]['amount_install_single']=$goods[$k]['num_install']>0?bcdiv($goods[$k]['amount_install'],$v['num_install']):0;//安装费
            //$goods[$k]['amount_total']=bcmul($goodsSku['amount'],$v['num']);
            list($goods[$k]['amount_total'],$_,$goods[$k]['amount'])=OrderService::getAmount($goodsSku,$goodsSku->goods,$v['num']);
            $goods[$k]['amount_total']=bcadd($goods[$k]['amount_total'],$goods[$k]['amount_install']);
            $total+=$goods[$k]['amount_total'];
        }
        $goods = array_values($goods);
        $result = ['goods'=>$goods,'total'=>$total];
        $this->success('',$result);
    }

    /**
     * 保存方案
     * @ApiMethod (POST)
     * @ApiParams (name=sku,description="key为规格id,对象：num购买数量，num_install安装数量，{1:{num:1,num_install:2}})
     * @ApiParams (name=name,description=方案名称)
     */
    public function submit(){
        $data=input();
        $this->validate($data,[
            'sku|商品'=>['require','min:1'],
            'name|方案名称'=>['require','max:100'],
        ]);
        Db::startTrans();
        $user=$this->auth->getUser();
        $data['createtime'] = time();
        $data['user_id'] = $user['id'];
        $reault = Db::name('Programme')->strict(false)->insert($data);
        $id =  Db::name('Programme')->getLastInsID();
        $sku = htmlspecialchars_decode($data['sku']);
        $sku = json_decode($sku,true);
        $goods = [];
        $goodsModel = new Goods();
        $goodsSkuModel = new GoodsSku();
        $total = 0;
        foreach ($sku as $k=>$v){
            $goodsSku = $goodsSkuModel->where('id',$k)->find();
            $nowGoods = $goodsModel->where('id',$goodsSku['goods_id'])->find();
            $goods[$k]['programme_id'] = $id;
            $goods[$k]['goods_id'] = $goodsSku['goods_id'];
            $goods[$k]['sku_id'] = $k;
            $goods[$k]['logo'] = implode(',',$nowGoods['logo']);
            $goods[$k]['name'] = $nowGoods['name'];
            $goods[$k]['sku'] = $goodsSku['name'];
            $goods[$k]['num'] = $v['num'];
            $goods[$k]['num_install'] = $v['num_install'];
            $goods[$k]['amount'] = $goodsSku['amount'];//单价
            $goods[$k]['amount_install']=InstallService::getFee([$k=>$v]);//安装费
            $goods[$k]['amount_total']=bcmul($goodsSku['amount'],$v['num']);
            $goods[$k]['amount_total']=bcadd($goods[$k]['amount_total'],$goods[$k]['amount_install']);
            $total+=$goods[$k]['amount_total'];
        }
        $goods = array_values($goods);
        $goodsResult = Db::name('ProgrammeGoods')->strict(false)->insertAll($goods);
        $totalResult = Db::name('Programme')->where('id',$id)->setField('amount_total',$total);
        if(!$reault || !$goodsResult || !$totalResult){
            Db::rollback();
            $this->error('保存失败');
        }
        Db::commit();
        $this->success('保存成功');
    }

    /**
     * 用户方案列表
     * @ApiParams (name=page,description=分页)
     * @ApiParams (name=limit,description=分页)
     *ApiReturnParams (name=id,description=方案id)
     * ApiReturnParams (name=name,description=方案名称)
     * ApiReturnParams (name=createtime,description=创建时间)
     * ApiReturnParams (name=sku_id,description=规格低)
     * ApiReturnParams (name=sku,description=规格名称)
     * ApiReturnParams (name=num,description=数量)
     */
    public function lists(){
        $user=$this->auth->getUser();
        $lists=$user->programmes()
            ->order('id','desc')
            ->paginate(input('limit',15));
        $data = $lists->toArray();
        $list = $data['data'];
        foreach ($list as  &$v){
            $v['goods'] = Db('ProgrammeGoods')->where('programme_id',$v['id'])->select();
        }
        $data['data'] = $list;

        $this->success('',$data);
    }
    /**
     * 查看方案
     * @ApiParams (name=id,description=方案id)
     * @ApiParams (name=page,description=分页)
     * @ApiParams(name=limit,description=分页)
     * ApiReturnParams (name=goods_id,description=商品id)
     * ApiReturnParams (name=logo,description=logo)
     * ApiReturnParams (name=name,description=商品名称)
     * @ApiReturnParams (name=sku,description=规格)
     * @ApiReturnParams (name=amount,description=单价)
     * @ApiReturnParams (name=amount_install,description=安装费)
     * ApiReturnParams (name=createtime,description=创建时间)
     */
    public function detail(){
        $id = input('id');
        $user=$this->auth->getUser();
        $lists= ProgrammeGoods::where('programme_id',$id)
            ->order('id','desc')
            ->paginate(input('limit',15));
        $data = $lists->toArray();
        $list = $data['data'];
        foreach ($list as  &$v){
            $v['logo'] = explode(',', $v['logo']);
        }
        $data['data'] = $list;
        $this->success('',$data);
    }
    /**
     * 查看方案无分页
     * @ApiParams (name=id,description=方案id)
     * @ApiParams (name=page,description=分页)
     * @ApiParams(name=limit,description=分页)
     * ApiReturnParams (name=goods_id,description=商品id)
     * ApiReturnParams (name=logo,description=logo)
     * ApiReturnParams (name=name,description=商品名称)
     * @ApiReturnParams (name=sku,description=规格)
     * @ApiReturnParams (name=amount,description=单价)
     * @ApiReturnParams (name=amount_install,description=安装费)
     * ApiReturnParams (name=createtime,description=创建时间)
     */
    public function detail1(){
        $id = input('id');
        $user=$this->auth->getUser();
        $list= ProgrammeGoods::where('programme_id',$id)
            ->order('id','desc')
            ->select();
        foreach ($list as  &$v){
            $v['logo'] = explode(',', $v['logo']);
            $v['num_stock']=$v['skuObj']['num_stock'];
        }
        $data['data'] = $list;
        $this->success('',$data);
    }
    /**
     * 删除方案
     *@ApiParams (name=id,description=方案id)
     */
    public function delete(){
        $id = input('id');
        Db('Programme')->where('id',$id)->delete();
        Db('ProgrammeGoods')->where('programme_id',$id)->delete();
        $this->success('删除成功');
    }
    /**
     * 删除方案商品
     * @ApiParams (name=ids,description=方案详情id)
     */
    public function deleteGoods(){
        $id = input('ids');
        $user=$this->auth->getUser();
        ProgrammeGoods::whereIn('id',$id)
            ->whereExists(
                \app\common\model\Programme::where('user_id',$user->id)->where('id',Db::raw((new ProgrammeGoods)->getTable().'.programme_id'))->buildSql()
            )
            ->delete();
        $this->success('删除成功');
    }

    /**
     * 方案详情
     * @ApiParams (name=id,description=方案id)
     * ApiReturnParams (name=goods_id,description=商品id)
     * ApiReturnParams (name=logo,description=logo)
     * ApiReturnParams (name=name,description=商品名称)
     * @ApiReturnParams (name=sku,description=规格)
     * @ApiReturnParams (name=amount,description=单价)
     * @ApiReturnParams (name=amount_install,description=安装费)
     * ApiReturnParams (name=createtime,description=创建时间)
     */
    public function info(){
        $id = input('id');
        $goods =  Db('ProgrammeGoods')->where('programme_id',$id)->select();
        $goodsIds =   Db('ProgrammeGoods')->where('programme_id',$id)->column('goods_id');
        $left = [];
        foreach ($goodsIds as $k=>$v){
            $nowGoods = Db('ProgrammeGoods')->where('goods_id',$v)->where('programme_id',$id)->find();
            $categoryId = Db('Goods')->where('id',$v)->value('category_id');
            $cate = DB('category')->field('id,name')->where('id',$categoryId)->find();
            if(empty($left[$cate['id']])){
                $left[$cate['id']] = $cate;
            }
            array_push($left[$cate['id']],$nowGoods);
        }
        $left = array_values($left);
        dump($left);
    }

    /**
     * 更新方案
     * @ApiParams (name=skuid,description=skuid)
     * @ApiParams (name=pid,description=方案ID)
     * @ApiParams (name=num,description=数量)
     * @ApiParams (name=num_install,description=安装数量)
     */
    public function update(){
        $data=$this->_validate([
            'pid'=>['require'],
            'skuid'=>['require'],
            'num'=>['require'],
            'num_install'=>['require'],
        ]);
        $user=$this->auth->getUser();
        \app\common\model\Programme::where('user_id',$user['id'])->findOrFail($data['pid']);
        $goods=ProgrammeGoods::where('programme_id',$data['pid'])
            ->where('sku_id',$data['skuid'])
            ->find();
        if($goods){
            $goods['num']=$data['num'];
            $goods['num_install']=$data['num_install'];
            $goods->save();
        }
        $this->success();
    }
}