cxinv/app/admin/controller/InterOrder.php

<?php


namespace app\admin\controller;

use think\facade\Db;
use think\facade\Validate;
use think\App;
class InterOrder extends \app\admin\BaseController{
	 public function __construct(App $app) {
	 	parent::__construct($app);
	 }
	/**
	* @return \think\response\Json|void
	* @throws \think\db\exception\DataNotFoundException
	* @throws \think\db\exception\DbException
	* @throws \think\db\exception\ModelNotFoundException
	 */
	 public function list(){
		$param = $this->request->only(["page"=>1,"size"=>10,'cgdNo'=>"","qrdNo"=>"","khNo"=>"",
		"supplierNo"=>"","companyNo"=>"","starttime"=>"","endtime"=>"","sale_name"=>"","cgd_saler"=>""],"post","trim");
		$where=[];
		 $check = checkRole($this->roleid,143);
        if($check){
            $where[]=["a.apply_id","=",$this->uid];
        }
		if($param['cgdNo']!="") $where[]=["a.cgdNo","like","%{$param['cgdNo']}%"];
		if($param['qrdNo']!="") $where[]=["a.orderCode","like","%{$param['qrdNo']}%"];
		if($param['khNo']!="") $where[]=["b.customerNo","like","%{$param['khNo']}%"];
		if($param['companyNo']!="") $where[]=["b.companyNo","like","%{$param['companyNo']}%"];
		if($param['supplierNo']!="") $where[]=["c.supplierNo","like","%{$param['supplierNo']}%"];
		if($param['starttime']!="") $where[]=["a.addtime",">=",date("Y-m-d 00:00:00",strtotime($param['starttime']))];
		if($param['endtime']!="") $where[]=["a.addtime","<=",date("Y-m-d 23:59:59",strtotime($param['endtime']))];
		if($param['sale_name']!="") $where[]=["b.ownerName","like","%{$param['sale_name']}%"];
		if($param['cgd_saler']!="") $where[]=["c.ownerName","like","%{$param['cgd_saler']}%"];

		$count= Db::name("inter_order")
            ->alias("a")
            ->leftJoin("qrd_info b","a.orderCode=b.sequenceNo and b.is_del=0 and b.qrdSource=10")
            ->leftJoin("cgd_info c","b.cgdNo=c.sequenceNo and c.is_del=0 and c.cgdSource=10")
            ->where($where)
            ->count('a.id');
		$total =ceil($count/$param['size']);
		$page =$total>=$param['page'] ? intval($param['page']): intval($total);
		$list= Db::name("inter_order")
            ->alias("a")
            ->leftJoin("qrd_info b","a.orderCode=b.sequenceNo and b.is_del=0 and b.qrdSource=10")
            ->leftJoin("cgd_info c","b.cgdNo=c.sequenceNo and c.is_del=0 and c.cgdSource=10")
		->field("a.id,
		a.orderCode,
		b.customerName as khName,
		b.customerNo as khNo,
		b.companyName,
		b.companyNo,
		a.rate*100 as cgd_tax,
		c.supplierName,
		c.supplierNo,
        b.poCode,
        a.addtime as ordertime,
        b.ownerName as sale_name,
        c.ownerName as cgd_saler,
        c.department as cgd_depart,
        b.department as sale_depart,
        b.goodName,
        b.tax,
        b.goodPrice,
        b.goodNum,
        b.totalPrice,
         b.apay_fee,
         b.wpay_fee,
         b.ainv_fee,
            b.winv_fee,
            b.qrdType,
            b.catInfo,
            a.cgdNo,
            b.workCode")
           ->json(["catInfo"])
		->where($where)->page($page,intval($param['size']))->order("id desc")
		->select()->toArray();
//		echo  Db::name("inter_order")->getLastSql();
		return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
	 }

	 public function create(){
	 	$param =$this->request->only([
	 		"sale_name"=>"","sale_id"=>"","companyNo"=>'',"poCode"=>"","workCode"=>"","khNo"=>"","qrdType"=>"","goodName"=>"",
	 		"tax"=>"","goodNum"=>"","goodPrice"=>"","mobile"=>"","addr"=>"","contactor"=>"",
	 		"buyer"=>"","buyerid"=>"","sendtime"=>"","cat"=>'',"supplierNo"=>"","cgd_tax"=>"","sale_depart"=>"","cgd_depart"=>""
	 		],"post");
	 	$valid =Validate::rule([
	 		"sale_name|业务员名称"=>"require|max:255|min:1",
	 		"sale_id|业务员名称"=>"require|number|gt:0",
	 		"companyNo|业务公司编号"=>"require|max:255|min:1",
	 		"supplierNo|业务公司编号"=>"require|max:255|min:1",
	 		"poCode|PO编号"=>"require|max:255|min:1",
	 		"workCode|单据编号"=>"require|max:255|min:1",
	 		"khNo|客户公司编号"=>"require|max:255|min:1",
	 		"qrdType|订单类型"=>"require|number|in:[1,2,3]",
	 		"goodName|商品名称"=>"require|max:255|min:1",
	 		"tax|税率"=>"require|number|gt:0",
	 		"goodNum|商品数量"=>"require|number|gt:0",
	 		"goodPrice|商品单价"=>"require|float|gt:0",
	 		"mobile|联系人电话"=>"require|number|mobile",
	 		"contactor|联系人"=>"require|max:255|min:1",
	 		"addr|收货地址"=>"require|max:255|min:1",
	 		"buyer|销售员"=>"require|max:255|min:1",
	 		"buyerid|销售员"=>"require|number|gt:0",
	 		"sendtime|发货时间"=>"require|date",
	 		"cat|商品分类id"=>"require|number|gt:0",
	 		"cgd_tax|采购毛利率"=>"require|float|gt:0",
	 		"sale_depart|销售员部门"=>"require|max:255|min:1",
	 		"cgd_depart|采购员部门"=>"require|max:255|min:1",
	 	]);
	 	if($valid->check($param)==false)return error_show(1004,$valid->getError());
		$qrdcode =makeNo("QRD");
		$cgddcode =makeNo("CGD");
		$goodCode =makeNo("SPU");
		$customer =Db::name("customer_info")->where('companyNo', "=", $param['khNo'])->find();
		$supplierName =Db::name("supplier_info")->where('code', "=", $param['supplierNo'])->value("name","");
		$companyName =Db::name("supplier_info")->where('code', "=", $param['companyNo'])->value("name","");
		$taxinfo = Db::name("order_rate")->where(["id"=>$param["tax"],"status"=>1])->value("rate",0);
		$param["cgd_tax"]=$param["cgd_tax"]/100;
		$cat = [];
		$this->cat($param['cat'],$cat);
		if(empty($cat)) return error_show(1004,'分类信息为找到');
		$inter=[
			"cgdNo"=>$cgddcode,
			"orderCode"=>$qrdcode,
			"rate"=>$param["cgd_tax"],
			"apply_id"=>$this->uid,
			"apply_name"=>$this->uname,
			"mobile"=>$param['mobile'],
			"contactor"=>$param['contactor'],
			"sendtime"=>$param['sendtime'],
			"addr"=>$param['addr'],
		];

		$qrd =[
                                'name' => $param['sale_depart']."销售单",//确认单名称,
                                'sequenceNo' => $qrdcode,//确认单编号,
                                'ownerName' => $param['sale_name'],//销售员,
                                'ownerid' => $param['sale_id'],//销售员id,
                                'department' => $param['sale_depart'],//部门,
                                'createdTime' => date("Y-m-d H:i:s"),//销售单创建时间,
                                'qrdType' => $param['qrdType'],//销售单类型,
                                'qrdSource' => 1,//销售单来源,
                                'companyNo' => $param['companyNo'],//业务企业编号,
                                'companyName' => $companyName,//业务企业名称,
                                'customerNo' => $param['khNo'],//客户编号,
                                'customerName' =>$customer['companyName']??"",//客户名称,
                                'poCode' => $param['poCode'],//po编号,
                                'platName' => '',//平台名称,
                                'workCode' =>$param['workCode'],//业务编号,
                                'zxCode' => '',//咨询单编号,
                                'goodNo' => $goodCode,//商品编号,
                                'goodName' => $param['goodName'],//商品名称,
                                'goodBrand' =>'',//商品品牌,
                                'firstCat' => $cat[0]['cat_name']??"",//一级分类,
                                'secCat' => $cat[1]['cat_name']??"",//二级分类,
                                'thirdCat' => $cat[2]['cat_name']??"",//三级分类,
                                'catInfo' => json_encode($cat,JSON_UNESCAPED_UNICODE),//分类详情,
                                'fundCode' => $cat[2]['fund_code']??"",//核算编码,
                                'goodMaterial' => '',//商品材质,
                                'goodUnit' => '',//商品单位,
                                'goodDesc' => '',//工艺说明,
                                'goodType' =>1,//商品类型,
                                'goodModel' => '',//商品型号,
                                'isStock' => 0,//是否库存品,
                                'metalsType' =>'',//贵金属种类,
                                'weight' => 0,//商品重量,
                                'goldPrice' => 0,//贵金属单价,
                                'deliveryDay' =>'',//物流天数,
                                'workDay' => '',//工期,
                                'tax' => $taxinfo,//税率,
                                'goodNum' => $param['goodNum'],//销售数量,
                                'goodPrice' => $param['goodPrice'],//产品单价,
                                'totalPrice' =>round( $param['goodPrice']*$param['goodNum'],2),//货款总额,
                                'sendNum' => $param['goodNum'],//已发货数量,
                                'wsendNum' => 0,//未发货数量,
                                'apay_fee' => 0,//已付款,
                                'pay_fee' => 0,//付款中
                                'wpay_fee' => round( $param['goodPrice']*$param['goodNum'],2),
                                'inv_fee' => 0,//回票中
                                'ainv_fee' => 0,//已开票,
                                'winv_fee' =>round( $param['goodPrice']*$param['goodNum'],2),
                                'is_diff' =>0,//是否有工差,
                                'sendType' => 1,//发货方式,
                                'sendStatus' =>3,//发货状态,
                                'pay_status' =>1,//收款状态,1未付，2部分，3完结
                                'inv_status' => 1,//开票状态,,1未付，2部分，3完结
                                'remark' => '',//备注,
                                'invtime' => null,
                                'paytime' => null,
                                'diff_weight' =>0,//工差重量,
                                'diff_fee' =>0,//工差金额,
                                'area' =>$customer['companyName']??"",//公司,
                                'customerAttr' => $customer['parent']??"",//客户属性,
                                'branch' => $customer['branch']??"",//分公司,从客户表中查
                                'cgdNo' => $cgddcode,//采购单号,
                                'thNum' => 0,//退货数量,
                                'th_fee' => 0,//退货金额,
                                'is_del' => 0,//是否删除,
                                'addtime' => date("Y-m-d H:i:s"),
                                'updatetime' =>date("Y-m-d H:i:s"),
                                'inv_tag' => 0,//开票标签,
                                'pay_tag' => 0,//回款标签,
                                'inv_tag_fee' => 0,//开票票标签金额,
                                'pay_tag_fee' => 0,//回款标签金额,

                            ];
		$cgd=[
                                'name' => $param['cgd_depart']."采购单",//采购单名称',
                                'sequenceNo' => $cgddcode,//采购单编号',
                                'ownerName' => $param['buyer'],//采购员名称',
                                'ownerid' => $param['buyerid'],//采购员id',
                                'department' => $param['cgd_depart'],//部门名称',
                                'createdTime' => date("Y-m-d H:i:s"),//订单创建时间',
                                'cgdType' =>$param['qrdType'],//采购单类型',
                                'cgdSource' => 0,//采购单来源',
                                'companyNo' => $param['companyNo'],//业务公司编号',
                                'companyName' => $companyName,//业务公司',
                                'cgdTime' => date("Y-m-d H:i:s"),//采购下单时间',
                                'bkCode' => '',//备库单编号',
                                'qrdCode' => $qrdcode,//确认单编号',
                                'goodNo' => $goodCode,//商品编号',
                                'goodName' => $param['goodName'],//商品名称',
                                'goodType' => 1,//商品类型',
                                'goodBrand' =>'',//商品品牌',
                                'goodModel' => '',//商品型号',
                                'firstCat' => $cat[0]['cat_name']??"",//商品一级分类',
                                'secCat' => $cat[1]['cat_name']??"",//二级分类',
                                'thirdCat' => $cat[2]['cat_name']??"",//三级分类',
                                'catInfo' => json_encode($cat,JSON_UNESCAPED_UNICODE),//分类明细',
                                'fundCode' => $cat[2]['fund_code']??"",//NOT NULL,
                                'goodMaterial' => '',//商品材质',
                                'goodUnit' => '',//商品单位',
                                'goodDesc' => '',//工艺说明',
                                'metalsType' => '',//贵金属种类',
                                'weight' => 0,//商品重量',
                                'goldPrice' => 0,//贵金属实时金价',
                                'is_diff' =>0,//是否有工差',
                                'deliveryDay' =>'',//物流天数',
                                'workDay' =>'',//产品工期',
                                'tax' => $taxinfo,//税点',
                                'barePrice' => 0,//裸价',
                                'markPrice' => 0,//加标费',
                                'packPrice' => 0,//包装费',
                                'certPrice' => 0,//证书费',
                                'openPrice' => 0,//开模费',
                                'costPrice' => 0,//工艺费',
                                'deliveryPrice' =>0,//物流费',
                                'goodPrice' => round( $param['goodPrice']*(1-$param['cgd_tax']),2),//成本合计/单价',
                                'isStock' =>0,//是否库存品',
                                'goodNum' => $param['goodNum'],//下单数量',
                                'totalPrice' => round(  $param['goodNum']*$param['goodPrice']*(1-$param['cgd_tax']),2),//采购总货款',
                                'supplierNo' => $param['supplierNo'],//供应商编号',
                                'supplierName' => $supplierName,//供应商名称',
                                'apay_fee' => 0,//已付款金额',
                                'wpay_fee' =>round(  $param['goodNum']*$param['goodPrice']*(1-$param['cgd_tax']),2),//采购总货款',
                                'ainv_fee' => 0,//已开票金额',
                                'winv_fee' =>round(  $param['goodNum']*$param['goodPrice']*(1-$param['cgd_tax']),2),//采购总货款',
                                'sendType' => 1,//发货方式',
                                'bkCreater' => '',//备库申请人',
                                'sendStatus' => 3,//发货状态',
                                'wsendNum' =>0,//未发货数量',
                                'sendNum' => $param['goodNum'],//已发货数量',
                                'wareHouse' => '',//仓库名称',
                                'wsmCode' =>'',//仓库编号',
                                'remark' => '',//备注',
                                'pay_status' =>1,//付款情况',
                                'inv_status' => 1,//开票情况',
                                'diff_weight' => 0,//工差重量',
                                'diff_fee' => 0,//工差金额',
                                'thNum' => 0,//退货数量',
                                'th_fee' => 0,//退货金额',
                                'check_rate' => '',//修正后的税率',
                                'is_del' => 0,
                                'addtime' => date("Y-m-d H:i:s"),
                                'updatetime' => date("Y-m-d H:i:s"),
                            ];

		$good=[
					"spuCode"=>$goodCode,
					"good_name"=>$param['goodName'],
					"companyNo"=>$param['companyNo'],
					"supplierNo"=>$param['supplierNo'],
					"is_stock"=>0,
					"craft_desc"=>'',
					"after_sales"=>'',
					"good_img"=>'',
					"good_thumb_img"=>'',
					"good_info_img"=>'',
					"creater"=>$this->uname,
					"createrid"=>$this->uid,
					"cat_name"=>$cat[2]['cat_name'],
					"unit_name"=>'',
					"isZx"=>0,
					"status"=>0,
					"addtime"=>date("Y-m-d H:i:s"),
					"updatetime"=>date("Y-m-d H:i:s")
				];
				 Db::startTrans();
        try {
            $a = Db::name("qrd_info")->insert($qrd);
            $d = Db::name("inter_order")->insert($inter);
            $b = Db::name('cgd_info')->insert($cgd);
            $c = Db::name('good')->insert($good);
            if ($a && $b && $c&&$d) {
                Db::commit();
                return app_show(0,'新建成功');
            } else {
                Db::rollback();
                return error_show(1004,'新建失败');
            }
        } catch (\Exception $e) {
            Db::rollback();
            return error_show(1004, $e->getMessage());
        }

	 }

	public function save(){
			$param =$this->request->only([
	 		"sale_name"=>"","sale_id"=>"","companyNo"=>'',"poCode"=>"","workCode"=>"","khNo"=>"","qrdType"=>"","goodName"=>"",
	 		"tax"=>"","goodNum"=>"","goodPrice"=>"","good_total"=>"","mobile"=>"","addr"=>"","contactor"=>"","id"=>"",
	 		"buyer"=>"","buyerid"=>"","sendtime"=>"","cat"=>'',"supplierNo"=>"","cgd_tax"=>"","sale_depart"=>"","cgd_depart"=>""
	 		],"post");
	 	$valid =Validate::rule([
	 		"id|主键ID"=>"require|number|gt:0",
	 		"sale_name|业务员名称"=>"require|max:255|min:1",
	 		"sale_id|业务员名称"=>"require|number|gt:0",
	 		"companyNo|业务公司编号"=>"require|max:255|min:1",
	 		"supplierNo|业务公司编号"=>"require|max:255|min:1",
	 		"poCode|PO编号"=>"require|max:255|min:1",
	 		"workCode|单据编号"=>"require|max:255|min:1",
	 		"khNo|客户公司编号"=>"require|max:255|min:1",
	 		"qrdType|订单类型"=>"require|number|in:[1,2,3]",
	 		"goodName|商品名称"=>"require|max:255|min:1",
	 		"tax|税率"=>"require|number|gt:0",
	 		"goodNum|商品数量"=>"require|number|gt:0",
	 		"goodPrice|商品单价"=>"require|float|gt:0",
	 		"mobile|联系人电话"=>"require|number|mobile",
	 		"contactor|联系人"=>"require|max:255|min:1",
	 		"addr|收货地址"=>"require|max:255|min:1",
	 		"buyer|销售员"=>"require|max:255|min:1",
	 		"buyerid|销售员"=>"require|number|gt:0",
	 		"sendtime|发货时间"=>"require|date",
	 		"cat|商品分类"=>"require|number|gt:0",
	 		"cgd_tax|采购毛利率"=>"require|float|gt:0",
	 		"sale_depart|销售员部门"=>"require|max:255|min:1",
	 		"cgd_depart|采购员部门"=>"require|max:255|min:1",
	 	]);
	 	if($valid->check($param)==false)return error_show(1004,$valid->getError());
	 	$inter_order=Db::name("inter_order")->where(["id"=>$param['id']])->findOrEmpty();
	 	if(empty($inter_order)) return error_show(1004,"未找到订单数据");
		$qrd_order=Db::name("qrd_info")->where(["sequenceNo"=>$inter_order['orderCode']])->findOrEmpty();
	 	if(empty($qrd_order)) return error_show(1004,"未找到销售单数据");
	 	$cgd_order=Db::name("cgd_info")->where(["sequenceNo"=>$inter_order['cgdNo']])->findOrEmpty();
	 	if(empty($cgd_order)) return error_show(1004,"未找到采购单数据");
		$param["cgd_tax"]=$param["cgd_tax"]/100;
		$customer =Db::name("customer_info")->where('companyNo', "=", $param['khNo'])->find();
		$supplierName =Db::name("supplier_info")->where('code', "=", $param['supplierNo'])->value("name","");
		$companyName =Db::name("supplier_info")->where('code', "=", $param['companyNo'])->value("name","");
		$taxinfo = Db::name("order_rate")->where(["id"=>$param["tax"],"status"=>1])->value("rate",0);
		$cat = [];
		$this->cat($param['cat'],$cat);
		if(empty($cat)) return error_show(1004,'分类信息为找到');
		$inter=[
			"id"=>$inter_order['id'],
			"rate"=>$param["cgd_tax"],
			"mobile"=>$param['mobile'],
			"contactor"=>$param['contactor'],
			"addr"=>$param['addr'],
			"sendtime"=>$param['sendtime'],
			"updatetime"=>date("Y-m-d H:i:s")
		];

		$qrd =["id"=>$qrd_order['id'],
                                'name' => $param['sale_depart']."销售单",//确认单名称,
                                'ownerName' => $param['sale_name'],//销售员,
                                'ownerid' => $param['sale_id'],//销售员id,
                                'department' => $param['sale_depart'],//部门,
                                'qrdType' => $param['qrdType'],//销售单类型,
                                'companyNo' => $param['companyNo'],//业务企业编号,
                                'companyName' => $companyName,//业务企业名称,
                                'customerNo' => $param['khNo'],//客户编号,
                                'customerName' =>$customer['companyName']??"",//客户名称,
                                'poCode' => $param['poCode'],//po编号,
                                'workCode' =>$param['workCode'],//业务编号,
                                'goodName' => $param['goodName'],//商品名称,
                                'firstCat' => $cat[0]['cat_name']??"",//一级分类,
                                'secCat' => $cat[1]['cat_name']??"",//二级分类,
                                'thirdCat' => $cat[2]['cat_name']??"",//三级分类,
                                'catInfo' => json_encode($cat,JSON_UNESCAPED_UNICODE),//分类详情,
                                'fundCode' => $cat[2]['fund_code']??"",//核算编码,
                                'tax' => $taxinfo,//税率,
                                'goodNum' => $param['goodNum'],//销售数量,
                                'goodPrice' => $param['goodPrice'],//产品单价,
                                'totalPrice' =>round( $param['goodPrice']*$param['goodNum'],2),//货款总额,
                                'sendNum' => $param['goodNum'],//已发货数量,
                                'wpay_fee' => round( $param['goodPrice']*$param['goodNum'],2),
                                'winv_fee' =>round( $param['goodPrice']*$param['goodNum'],2),
                                'area' =>$customer['companyName']??"",//公司,
                                'customerAttr' => $customer['parent']??"",//客户属性,
                                'branch' => $customer['branch']??"",//分公司,从客户表中查
                                'updatetime' =>date("Y-m-d H:i:s"),
                            ];
		$cgd=["id"=>$cgd_order['id'],
                                'name' => $param['cgd_depart']."采购单",//采购单名称',
                                'ownerName' => $param['buyer'],//采购员名称',
                                'ownerid' => $param['buyerid'],//采购员id',
                                'department' => $param['cgd_depart'],//部门名称',
                                'cgdType' =>$param['qrdType'],//采购单类型',
                                'companyNo' => $param['companyNo'],//业务公司编号',
                                'companyName' => $companyName,//业务公司',
                                'goodName' => $param['goodName'],//商品名称',
                                'firstCat' => $cat[0]['cat_name']??"",//商品一级分类',
                                'secCat' => $cat[1]['cat_name']??"",//二级分类',
                                'thirdCat' => $cat[2]['cat_name']??"",//三级分类',
                                'catInfo' => json_encode($cat,JSON_UNESCAPED_UNICODE),//分类明细',
                                'fundCode' => $cat[2]['fund_code']??"",//NOT NULL,
                                'tax' => $taxinfo,//税点',
                                'goodPrice' => round( $param['goodPrice']*(1-$param['cgd_tax']),2),//成本合计/单价',
                                'goodNum' => $param['goodNum'],//下单数量',
                                'totalPrice' => round(  $param['goodNum']*$param['goodPrice']*(1-$param['cgd_tax']),2),//采购总货款',
                                'supplierNo' => $param['supplierNo'],//供应商编号',
                                'supplierName' => $supplierName,//供应商名称',
                                'wpay_fee' =>round(  $param['goodNum']*$param['goodPrice']*(1-$param['cgd_tax']),2),//采购总货款',
                                'winv_fee' =>round(  $param['goodNum']*$param['goodPrice']*(1-$param['cgd_tax']),2),//采购总货款',
                                'sendNum' => $param['goodNum'],//已发货数量',
                                'updatetime' => date("Y-m-d H:i:s"),
                            ];
				 Db::startTrans();
        try {
            $a = Db::name("qrd_info")->save($qrd);
            $d = Db::name("inter_order")->save($inter);
            $b = Db::name('cgd_info')->save($cgd);
            if ($a && $b && $d) {
                Db::commit();
                return app_show(0,'更新成功');
            } else {
                Db::rollback();
                return error_show(1004,'更新失败');
            }
        } catch (\Exception $e) {
            Db::rollback();
            return error_show(1004, $e->getMessage());
        }
	}
//			"id|主键ID"=>"require|number|gt:0",
//	 		"sale_name|业务员名称"=>"require|max:255|min:1",
//	 		"sale_id|业务员名称"=>"require|number|gt:0",
//	 		"companyNo|业务公司编号"=>"require|max:255|min:1",
//	 		"supplierNo|业务公司编号"=>"require|max:255|min:1",
//	 		"poNo|PO编号"=>"require|max:255|min:1",
//	 		"sequenceNo|单据编号"=>"require|max:255|min:1",
//	 		"khNo|客户公司编号"=>"require|max:255|min:1",
//	 		"qrdType|订单类型"=>"require|number|in:[1,2,3]",
//	 		"goodName|商品名称"=>"require|max:255|min:1",
//	 		"tax|税率"=>"require|number|gt:0",
//	 		"goodNum|商品数量"=>"require|number|gt:0",
//	 		"goodPrice|商品单价"=>"require|number|gt:0",
//	 		"mobile|联系人电话"=>"require|number|mobile",
//	 		"contactor|联系人"=>"require|max:255|min:1",
//	 		"addr|收货地址"=>"require|max:255|min:1",
//	 		"buyer|销售员"=>"require|max:255|min:1",
//	 		"buyerid|销售员"=>"require|number|gt:0",
//	 		"sendtime|发货时间"=>"require|date",
//	 		"cat|商品分类"=>"require|array",
//	 		"cgd_tax|采购毛利率"=>"require|number|gt:0",
//	 		"sale_depart|销售员部门"=>"require|max:255|min:1",
//	 		"cgd_depart|采购员部门"=>"require|max:255|min:1",
	  public function  info(){
        $post=$this->request->post();
        $id = isset($post['id'])&&$post['id']!='' ? $post['id'] :"";
        $condition = [['a.id',"=",$id]];
        $list=Db::name('inter_order')->alias('a')->join('qrd_info b','a.orderCode=b.sequenceNo','left')
            ->join('cgd_info c','a.cgdNo=c.sequenceNo','left')->json(["cat"])->where($condition)
            ->order("a.addtime desc")->field('a.id,
            b.goodNo ,
            a.orderCode,
            b.customerNo as khNo,
            b.customerName as khName,
            b.companyName,
            b.companyNo,
            b.poCode,
            b.workCode,
            a.addtime as ordertime,
            b.ownerName as sale_name,
            b.ownerid as sale_id,
            b.department as sale_depart,
            b.goodName,
            b.goodNo,
            b.tax,
            b.catInfo as cat,
            b.goodPrice,
            b.goodNum,
            b.totalPrice,
            b.qrdType,
            c.supplierName,
            c.supplierNo,
            a.cgdNo,
            c.ownerName as buyer,
            c.ownerid as buyerid,
            c.department as cgd_depart,
            a.sendtime ,
            a.rate*100 as cgd_tax,
            a.contactor,
            a.mobile,
            a.addr
            ')->findOrEmpty();
        if(empty($list)){
            return error_show(1004,'未找到数据');
        }

        $list['rateid'] =  Db::name("order_rate")->where('rate',"=",$list['tax'])->value("id",'');
        return app_show(0,"获取成功",$list);
        }

     public function getCat(){
        $post=$this->request->post();
        $condition = [['status',"=",1],["is_del","=",0],['level',"=",3]];
        $cat_name=isset($post['cat_name']) && $post['cat_name'] !==""? trim($post['cat_name']) :"";
        if($cat_name!==""){
            $condition[]=['cat_name',"like","%$cat_name%"];
        }
         $search=isset($post['search']) && $post['search'] !==""? trim($post['search']) :"";
        if($search!==""){
            $condition[]=['search',"like","%$search%"];
        }
        $cat = Db::connect("mysql_wsm")->name("cat")->where($condition)->field("id,cat_name,fund_code,search")->order
        ("weight desc ,addtime desc")->select()->toArray();
        return app_show(0,"获取成功",$cat);
    }

    private function cat($id,&$cat=[]){
	 	$condition[]=["id","=",$id];
	 	$data= Db::connect("mysql_wsm")->name("cat")->where($condition)->field("id,cat_name,fund_code,pid")->findOrEmpty();
	 	array_unshift($cat,$data);
		if($data['pid']==0||empty($data)) return $cat;
		else $this->cat($data['pid'],$cat);

    }
}