phpstock/app/admin/controller/Filing.php

<?php

namespace app\admin\controller;

use think\Exception;
use think\facade\Db;
use think\facade\Validate;

//报备单
class Filing extends Base
{
    //列表
    public function getList()
    {
        $data = $this->request->only(['page' => 1, 'size' => 10, 'cat_id' => '', 'start_date' => '', 'end_date' => '', 'filingCode' => '', 'status' => '', 'good_name' => '', 'companyName' => '', 'companyCode' => '', 'orderCode' => '', 'supplierNo' => ''], 'post');

        $where = [['is_del', '=', '0']];
        if ($data['cat_id'] != '') $where[] = ['cat_id', '=', $data['cat_id']];
        if ($data['start_date'] != '' && $data['end_date'] != '') $where[] = ['addtime', 'between', [$data['start_date'] . ' 00:00:00', $data['end_date'] . ' 23:59:59']];
        if ($data['filingCode'] != '') $where[] = ['filingCode', 'like', '%' . $data['filingCode'] . '%'];
        if ($data['status'] != '') $where[] = ['status', '=', $data['status']];
        if ($data['good_name'] != '') $where[] = ['good_name', 'like', '%' . $data['good_name'] . '%'];
        if ($data['companyName'] != '') $where[] = ['companyName', 'like', '%' . $data['companyName'] . '%'];
        if ($data['companyCode'] != '') $where[] = ['companyCode', 'like', '%' . $data['companyCode'] . '%'];
        if ($data['orderCode'] != '') $where[] = ['orderCode', 'like', '%' . $data['orderCode'] . '%'];
        if ($data['supplierNo'] != '') $where[] = ['supplierNo', '=', $data['supplierNo']];

        $count = Db::name('filing')
            ->where($where)
            ->count('id');

        $list = Db::name('filing')
            ->field('id,filingCode,cat_id,good_name,num,good_img,price,expect_service,companyName,companyCode,status,addtime,"" catinfo,orderCode,cgd_charge')
            ->where($where)
            ->page($data['page'], $data['size'])
            ->order('id', 'desc')
            ->withAttr('good_img', function ($val) {
                return explode(',', $val);
            })
            ->select()
            ->toArray();

        $all_cat = [];
        foreach ($list as &$value) {
            if (!isset($all_cat[$value['cat_id']])) $all_cat[$value['cat_id']] = implode('/', array_column(made($value['cat_id']), 'name'));

            $value['catinfo'] = $all_cat[$value['cat_id']];
        }

        return json_show(0, '获取报备单列表成功', ['count' => $count, 'list' => $list]);


//        return FilingLogic::list($param);
    }

    //添加
    public function add()
    {
        $param = $this->request->only(['customerCode', 'supplierNo', 'companyName', 'num', 'is_determine_price', 'price' => 0, 'expect_service_proportion', 'expect_service', 'cgd_charge' => 0, 'brand_id', 'preservation_day', 'delivery_day', 'make_day', 'tax', 'unit_id', 'cat_id', 'spec_list' => [], 'good_name', 'origin_place', 'delivery_place', 'weight', 'supply_area', 'pay_way', 'gold_weight', 'noble_metal', 'config', 'other_config', 'remark', 'cost_desc', 'good_img'], 'post');

        $val = Validate::rule([
            'customerCode|业务公司' => 'require|max:255',
            'supplierNo|供应商' => 'require|max:255',
            'companyName|客户名称' => 'require|max:255',
            'num|销售数量' => 'require|number|gt:0|lt:999999999',
            'is_determine_price|是否确定售价' => 'require|number|in:1,0',
            'price|销售价' => 'requireIf:is_determine_price,1|float|max:99999999.99',
            'expect_service_proportion|期望服务费比例' => 'require|float|between:0,100',
            'expect_service|期望服务费' => 'require|float|max:99999999.99',
            'cgd_charge|采购价' => 'requireIf:is_determine_price,0|float|max:99999999.99',
            'brand_id|品牌' => 'require|number|gt:0',
            'preservation_day|有效期' => 'require|number|max:999999999',
            'delivery_day|物流时间' => 'require|number|max:999999999',
            'make_day|生产工期' => 'require|number|max:999999999',
            'tax|税点' => 'require|number|between:0,100',
            'unit_id|单位' => 'require|number|gt:0',
            'cat_id|分类' => 'require|number|gt:0',
            'spec_list|规格类型' => 'array|max:100',
            'good_name|商品名称' => 'require|max:255',
            'origin_place|产地' => 'require|array|length:3',
            'delivery_place|发货地' => 'require|array|length:3',
            'weight|总重量' => 'require|float|max:99999999.99',
            'supply_area|供货区域' => 'require|number|in:1,2',
            'pay_way|付款方式' => 'require|number|in:0,1,2',
            'remark|采购备注' => 'require|max:255',
            'cost_desc|工艺说明' => 'max:255',
            'good_img|商品图片' => 'require|array|max:10',
        ]);

        if (!$val->check($param)) return json_show(1004, $val->getError());

        //如果是贵金属的话，额外判断
        $cat = made($param['cat_id']);
        if (isset($cat[0]['id']) && $cat[0]['id'] == 6) {
            $val_gold = Validate::rule([
                'gold_weight|贵金属重量' => 'require|float|max:99999999.99',
                'noble_metal|贵金属类型' => 'require|number|in:1,2,3',
                'config|配置要求' => 'require|max:255',
                'other_config|其他配置要求' => 'require|max:255',
            ]);
            if (!$val_gold->check($param)) return json_show(1004, $val_gold->getError());
        }

        $val2 = Validate::rule([
            'spec_id|规格id' => 'require|number|gt:0',
            'spec_value_id|规格值id' => 'require|number|gt:0',
        ]);

        $all_spec = Db::name('specs')
            ->whereIn('id', array_column($param['spec_list'], 'spec_id'))
            ->column('spec_name', 'id');

        $all_spec_value = Db::name('spec_value')
            ->whereIn('id', array_column($param['spec_list'], 'spec_value_id'))
            ->column('spec_value', 'id');

        foreach ($param['spec_list'] as &$spec_list) {
            if (!$val2->check($spec_list)) return json_show(1004, $val2->getError());
            $spec_list['spec_name'] = $all_spec[$spec_list['spec_id']] ?? '';
            $spec_list['spec_value_name'] = $all_spec_value[$spec_list['spec_value_id']] ?? '';
        }

        if ($param['is_determine_price'] == 1) $param['cgd_charge'] = round(bcsub($param['price'], $param['expect_service'], 3), 2);//确定售价时，采购价=售价-服务费
        else $param['price'] = round(bcadd($param['cgd_charge'], $param['expect_service'], 3), 2);//不确定售价时，售价=采购价+服务费

//        $customerName = Db::name('business')
//            ->where(['companyNo' => $param['customerCode']])
//            ->value('company', '');
//        if ($customerName == '') return json_show(1004, '该业务公司不存在');
        $userCommon = new \app\admin\common\User();
        $names = $userCommon->handle('getCodeAndName', ['code' => [$param['customerCode'], $param['supplierNo']]]);
        if (!isset($names['data'][$param['customerCode']]) || $names['data'][$param['customerCode']] == '') return json_show(1004, '该业务公司不存在');
        if (!isset($names['data'][$param['supplierNo']]) || $names['data'][$param['supplierNo']] == '') return json_show(1004, '该供应商不存在');

        $rs = Db::name('filing')
            ->strict(false)
            ->insert(array_merge($param, [
                'customerName' => $names['data'][$param['customerCode']],
                'supplierName' => $names['data'][$param['supplierNo']],
                'filingCode' => makeNo('BM'),
                'service_proportion' => $param['expect_service_proportion'],//服务费比例与期望服务费比例一致
                'service_charge' => $param['expect_service'],//服务费与期望服务费一致
                'specinfo' => json_encode($param['spec_list']),
                'send_way' => 2,
                'cert_fee' => 0,
                'pakge_fee' => 0,
                'cost_fee' => 0,
                'mark_fee' => 0,
                'demo_fee' => 0,
                'open_fee' => 0,
                'delivery_fee' => 0,
                'is_gold_price' => 0,
                'is_diff' => 0,
                'apply_id' => $this->uid,
                'apply_name' => $this->uname,
                'status' => 0,
                'is_del' => 0,
                'addtime' => date('Y-m-d H:i:s'),
                'updatetime' => date('Y-m-d H:i:s'),
                'gold_weight' => $param['gold_weight'] ?? 0,
                'noble_metal' => $param['noble_metal'] ?? 0,
                'config' => $param['config'] ?? '',
                'other_config' => $param['other_config'] ?? '',
                'good_img' => implode(',', $param['good_img']),
                'origin_place' => implode(',', $param['origin_place']),
                'delivery_place' => implode(',', $param['delivery_place']),
            ]));

        return $rs ? json_show(0, '创建报备单成功') : json_show(1004, '创建报备单失败');


//        $param['supplierNo']= $this->request->user['supplierNo'];
//        $param['supplierName']= $this->request->user['supplierName'];

//        return FilingLogic::add($param);

    }

    //详情
    public function detail()
    {
        $param = $this->request->only(['id' => 0], 'post', 'trim');

        $rs = Db::name('filing')
            ->alias('a')
            ->field('a.*,b.brand_name,d.unit unit_name,p.platform_name,"" cat_info')
            ->leftJoin('brand b', 'b.id=a.brand_id')
            ->leftJoin('unit d', 'd.id=a.unit_id')
            ->leftJoin('platform p', 'p.id=a.platform_id')
            ->where(['a.is_del' => 0, 'a.id' => $param['id']])
            ->withAttr('specinfo', function ($val) {
                return json_decode($val);
            })
            ->withAttr('good_img', function ($val) {
                return explode(',', $val);
            })->withAttr('origin_place', function ($val) {
                return explode(',', $val);
            })->withAttr('delivery_place', function ($val) {
                return explode(',', $val);
            })->withAttr('cat_info', function ($val, $da) {
                return made($da['cat_id']);
            })
            ->findOrEmpty();
        return json_show(0, '获取报备单详情成功', $rs);
//        return FilingLogic::detail($param);
    }

    //审核
    public function status()
    {
        if ($this->level != 2) return json_show(1004, '业务公司账号不能审核');

        $param = $this->request->only(['id', 'status', 'companyCode', 'plat_code' => '', 'service_charge', 'service_proportion', 'platform_id'], 'post');

        $val = Validate::rule([
            'id' => 'require|number|gt:0',
            'status|状态' => 'require|number|in:1,2',
            'companyCode|客户' => 'require|length:18',
            'service_charge|服务费' => 'require|float|egt:0|max:99999999.99',
            'service_proportion|服务费比例' => 'require|float|egt:0',
            'platform_id|平台id' => 'require|number|gt:0',
        ]);

        if (!$val->check($param)) return json_show(1004, $val->getError());

        $rs = Db::name('filing')
            ->field('id,status,is_determine_price,price,cgd_charge,platform_id,companyCode')
            ->where(['is_del' => 0, 'id' => $param['id']])
            ->whereIn('status', [0, 2])
            ->findOrEmpty();
        if (empty($rs)) return json_show(1005, '该报备单不存在或不允许审核');

        $userCommon = new \app\admin\common\User();
        $company = $userCommon->handle('cInfo', ['companyNo' => $param['companyCode']]);
        if (!isset($company['data'])) return json_show(1005, '该客户不存在');
//        $companyName = Db::name('customer_info')
//            ->where(['is_del' => 0, 'companyNo' => $param['companyCode']])
//            ->value('companyName', '');
//        if ($companyName == '') return json_show(1005, '该客户不存在');

        $tmp = Db::name('platform')
            ->where(['is_del' => 0, 'id' => $param['platform_id']])
            ->field('id,is_select_pay_rate')
            ->findOrEmpty();
        if (empty($tmp)) return json_show(1005, '该平台不存在');


        //校验支付渠道中的业务公司是否与报备单业务公司重复
        if ($tmp['is_select_pay_rate'] == 1) {
            $temp = Db::name('platform_pay_rate')
                ->where(['is_del' => 0, 'platform_id' => $rs['platform_id'], 'companyNo' => $rs['companyCode']])
                ->field('id')
                ->findOrEmpty();
            if (!empty($temp)) return json_show(1004, '业务公司重复，请选择其他平台');
        }

        $update = array_merge($param, [
            'companyName' => $company['data']['companyName'],
            'updatetime' => date('Y-m-d H:i:s'),
        ]);

        if ($rs['is_determine_price'] == 1) $update['cgd_charge'] = round(bcsub($rs['price'], $param['service_charge'], 3), 2);//确定售价时，采购价=售价-服务费
        else $update['price'] = round(bcadd($rs['cgd_charge'], $param['service_charge'], 3), 2);//不确定售价时，售价=采购价+服务费

        $res = Db::name('filing')
            ->where(['is_del' => 0, 'id' => $param['id']])
            ->whereIn('status', [0, 2])
            ->update($update);
        return $res ? json_show(0, '操作成功') : json_show(1004, '操作失败');


//        return FilingLogic::status($param);
    }

    //取消转单
    public function cancel()
    {
        if ($this->level == 1) return json_show(1004, '超管不允许操作');

        $param = $this->request->only(['id'], 'post');
//        $param['supplierNo'] = $this->request->user['supplierNo'];
//        return FilingLogic::cancel($param);

        $where = [
            ['is_del', '=', 0],
            ['id', '=', $param['id']],
//            ['supplierNo', '=', $param['supplierNo']],
            ['status', 'in', [0, 1, 2, 4]]
        ];

        $rs = Db::name('filing')
            ->field('id,status,supplierNo')
            ->where($where)
            ->findOrEmpty();
        if (empty($rs)) return json_show(1005, '该报备单不存在或不允许取消');

        //level3账号都可以操作
        //level2账号的话，只有供应商负责人能操作
        if ($this->level == 2) {
            $userCommon = new \app\admin\common\User();
            $supp = $userCommon->handle('sInfo', ['code' => $rs['supplierNo']]);
            if ($this->uid != $supp['data']['personid']) return json_show(1004, '只有供应商负责人才能操作');
        }

        $res = Db::name('filing')
            ->where($where)
            ->update(['status' => 5, 'updatetime' => date('Y-m-d H:i:s')]);
        return $res ? json_show(0, '操作成功') : json_show(1004, '操作失败');
    }

    //转单
    public function transfer()
    {
        if ($this->level == 1) return json_show(1004, '超管不允许操作');

        $param = $this->request->only(['id', 'addr_list'], 'post');

        $val = Validate::rule([
            'id' => 'require|number|gt:0',
            'addr_list|收货地址' => 'require|array|max:100',
        ]);

        if (!$val->check($param)) return json_show(1004, $val->getError());

        $val2 = Validate::rule([
            'receipt_quantity|收货数量' => 'require|number|gt:0|max:999999999',
            'contactor|联系人' => 'require|max:255',
            'mobile|联系电话' => 'require|mobile',
            'addr_code|收货省市区编码' => 'require|array|length:3',
            'addr|详细地址' => 'require|max:255',
        ]);


        foreach ($param['addr_list'] as $addr_list) {
            if (!$val2->check($addr_list)) return json_show(1004, $val2->getError());
        }

        $filing = Db::name('filing')
            ->field(true)
            ->where(['is_del' => 0, 'id' => $param['id'], 'status' => 2])
            ->findOrEmpty();
        if (empty($filing)) return json_show(1005, '该报备单不存在或不允许转单');

        if (array_sum(array_column($param['addr_list'], 'receipt_quantity')) != $filing['num']) return json_show(1004, '收货地址的收货总数不符合');


//        $supplier = Db::name('supplier')
//            ->field('id,person,personid,name,code')
//            ->where(['code' => $filing['supplierNo']])
//            ->findOrEmpty();
        $userCommon = new \app\admin\common\User();
        $supplier = $userCommon->handle('sInfo', ['code' => $filing['supplierNo']]);

//        $names = $userCommon->handle('getCodeAndName', ['code' => [$filing['companyCode'], $filing['customerCode'],]]);

        //level3账号都可以操作
        //level2账号的话，只有供应商负责人能操作
        if (($this->level == 2) && ($this->uid != $supplier['data']['personid'])) return json_show(1004, '只有供应商负责人才能操作');

        $date = date('Y-m-d H:i:s');

        Db::startTrans();

        try {

            $order_type = 4;//报备商品
            $order_source = 7;//报备转单

            $spuCode = makeNo('SKU');

            //商品表
            Db::name('good_zixun')
                ->insert([
                    'spuCode' => $spuCode,
                    'good_name' => $filing['good_name'],
                    'brand_id' => $filing['brand_id'],
                    'cat_id' => $filing['cat_id'],
                    'good_unit' => $filing['unit_id'],
                    'good_type' => 0,
                    'moq' => 1,
                    'customized' => $filing['make_day'],
                    'tax' => $filing['tax'],
                    'platform_id' => $filing['platform_id'],
                    'supplierNo' => $filing['supplierNo'],
                    'supplierName' => $supplier['data']['name'],
                    'is_auth' => 0,
                    'craft_desc' => $filing['good_name'],
                    'good_remark' => '',
                    'good_img' => $filing['good_img'],
                    'good_thumb_img' => '',
                    'good_info_img' => '',
                    'status' => 1,
                    'createrid' => $filing['apply_id'],
                    'creater' => $filing['apply_name'],
                    'is_del' => 0,
                    'addtime' => $date,
                    'updatetime' => $date,
                    'specinfo' => $filing['specinfo'],
                    'work_day' => $filing['make_day'],
                    'noble_metal' => $filing['noble_metal'],
                    'is_gold_price' => $filing['is_gold_price'],
                    'good_weight' => $filing['gold_weight'],
                    'config' => $filing['config'],
                    'other_config' => $filing['other_config'],
                    'weight' => $filing['weight'],
                    'supply_area' => $filing['supply_area'],
                    'is_diff' => $filing['is_diff'],
                    'pay_way' => $filing['pay_way'],
                    'send_way' => $filing['send_way'],
                    'companyNo' => $filing['customerCode'],
                    'proof_type' => '',
                    'proof_url' => '',
                    'order_type' => $order_type
                ]);

            $orderCode = makeNo('QR');
            //订单表
            //sale
            $sale_id = Db::name('sale')->insertGetId([
                'orderCode' => $orderCode,
                'apply_id' => $filing['apply_id'],
                'apply_name' => $filing['apply_name'],
                'order_type' => $order_type,//报备商品
                'order_source' => $order_source,//报备转单
                'platform_id' => $filing['platform_id'],
                'good_code' => $spuCode,
                'skuCode' => '',
                'cat_id' => $filing['cat_id'],
                'good_name' => $filing['good_name'],
                'good_num' => $filing['num'],
                'good_type' => 1,
                'origin_price' => $filing['cgd_charge'],
                'sale_price' => $filing['price'],
                'total_price' => round(bcmul($filing['price'], $filing['num'], 3), 2),
                'post_fee' => 0,
                'is_diff' => $filing['is_diff'],
                'is_activity' => 0,
                'activity_code' => '',
                'is_stock' => 0,
                'customer_code' => $filing['companyCode'],
                'customerName' => $filing['companyName'],
                'supplierNo' => $filing['customerCode'],
                'supplierName' => $filing['customerName'],
                'supNo' => $filing['supplierNo'],
                'supName' => $filing['supplierName'],
                'zxNo' => '',
                'platform_order' => '',
                'send_num' => 0,
                'wsend_num' => $filing['num'],
                'th_num' => 0,
                'th_fee' => 0,
                'send_status' => 1,
                'send_type' => 1,//直接发货
                'remark' => '',
                'status' => 0,
                'is_del' => 0,
                'proof_id' => 0,
                'other_orderNo' => '',
                'workNo' => '',
                'poNo' => '',
                'use_order' => 0,
                'good_weight' => 0,
                'gold_price' => 0,
                'cost_price' => $filing['cost_fee'],
                'diff_weight' => 0,
                'diff_fee' => 0,
                'returnCode' => '',
                'addtime' => $date,
                'updatetime' => $date,
                'cgderid' => $supplier['data']['personid'],
                'cgder' => $supplier['data']['person'],
                'good_createrid' => $filing['apply_id'],
                'good_creater' => $filing['apply_name'],
            ]);


            //仓库
            $wsm = Db::name('warehouse_info')
                ->field('id,wsm_code')
                ->where(['supplierNo' => $filing['supplierNo'], 'companyNo' => $filing['customerCode'], 'is_del' => 0])
                ->findOrEmpty();
            if (empty($wsm)) {
                $wsm_code = makeNo('WSM');

                Db::name('warehouse_info')->insert([
                    'wsm_code' => $wsm_code,
                    'name' => $supplier['data']['name'],
                    'wsm_type' => 2,
                    'supplierNo' => $supplier['data']['code'],
                    'addr' => '',
                    'addrs_code' => '',
                    'contactor' => 0,
                    'contactor_name' => 0,
                    'mobile' => '',
                    'position' => '',
                    'companyNo' => $filing['supplierNo'],
                    'status' => 1,
                    'is_del' => 0,
                    'addtime' => $date,
                    'updatetime' => $date,
                ]);

            } else  $wsm_code = $wsm['wsm_code'];

            //采购单
            $cgdCode = makeNo('CG');

            Db::name('purchease_order')->insert([
                'cgdNo' => $cgdCode,
                'bkcode' => '',
                'wsm_code' => $wsm_code,
                'cgder' => $supplier['data']['person'],
                'cgder_id' => $supplier['data']['personid'],
                'spuCode' => $spuCode,
                'good_name' => $filing['good_name'],
                'good_num' => $filing['num'],
                'good_price' => $filing['cgd_charge'],
                'total_fee' => round(bcmul($filing['cgd_charge'], $filing['num']), 2),
                'pakge_fee' => $filing['pakge_fee'],
                'cert_fee' => $filing['cert_fee'],
                'open_fee' => $filing['open_fee'],
                'delivery_fee' => $filing['delivery_fee'],
                'mark_fee' => $filing['mark_fee'],
                'demo_fee' => $filing['demo_fee'],
                'diff_weight' => '0',
                'diff_fee' => '0',
                'gold_price' => '0',
                'supplierNo' => $filing['supplierNo'],
                'supplier_name' => $filing['supplierName'],
                'companyNo' => $filing['customerCode'],
                'companyName' => $filing['customerName'],
                'send_status' => 1,
                'send_num' => '0',
                'wsend_num' => $filing['num'],
                'remark' => '',
                'status' => 0,
                'lasttime' => $date,
                'is_del' => 0,
                'order_type' => $order_type,
                'order_source' => $order_source,
                'good_type' => 1,
                'addtime' => $date,
                'updatetime' => $date,
                'good_createrid' => $filing['apply_id'],
                'good_creater' => $filing['apply_name'],
            ]);

            //台账
            $standing_bood_data = [
                'standBookNo' => makeNo('IO'),
                'orderCode' => $orderCode,
                'sale_id' => $sale_id,
                'customer_code' => $filing['companyCode'],
                'supplierNo' => $filing['supplierNo'],
                'order_type' => $order_type,
                'order_source' => $order_source,
                'spuCode' => $spuCode,
                'addtime' => $date,
                'updatetime' => $date,
                'cgdNo' => $cgdCode,
            ];

            $i = 0;
            $order_send_insert = [];
            foreach ($param['addr_list'] as $addr) {
                //地址addr
                $addrid = Db::name('order_addr')->insertGetId([
                    'orderCode' => $orderCode,
                    'addr' => $addr['addr'],
                    'addr_code' => implode(',', $addr['addr_code']),
                    'contactor' => $addr['contactor'],
                    'mobile' => $addr['mobile'],
                    'customer_code' => $filing['companyCode'],
                    'post_fee' => 0,
                    'receipt_quantity' => $addr['receipt_quantity'],
                    'is_del' => 0,
                    'addtime' => $date,
                    'updatetime' => $date,
                ]);

                //发货单
                $outCode = makeNo('DF');
                //改变编码规则，将原来的编码后两位换成序列号
                //str_pad字符串填充
                $outCode = substr($outCode, 0, -2) . str_pad($i, 2, '0', STR_PAD_LEFT);
                Db::name('order_out')->insert([
                    'orderCode' => $orderCode,
                    'outCode' => $outCode,
                    'apply_id' => $this->uid,
                    'apply_name' => $this->uname,
                    'addrid' => $addrid,
                    'post_name' => '',
                    'post_code' => '',
                    'post_fee' => 0,
                    'sendtime' => $date,
                    'send_num' => $addr['receipt_quantity'],
                    'check_num' => 0,
                    'error_num' => 0,
                    'wsm_code' => '',
                    'order_type' => $order_type,
                    'status' => 0,
                    'addtime' => $date,
                    'updatetime' => $date,
                ]);
                $standing_bood_data['outCode'][] = $outCode;
                $order_send_insert[] = [
                    'cgdNo' => $cgdCode,
                    'outCode' => $outCode,
                    'send_num' => $addr['receipt_quantity'],
                    'bnCode' => '',
                    'status' => 1,
                    'addtime' => $date,
                    'updatetime' => $date,
                ];
                $i++;
            }

            //更新报备单
            Db::name('filing')
                ->where(['is_del' => 0, 'id' => $param['id'], 'status' => 2])
                ->update(['status' => 3, 'updatetime' => $date, 'orderCode' => $orderCode, 'reason' => '']);

            //待办已办先不处理

            //关联表
            Db::name('order_num')
                ->insert([
                    'orderCode' => $orderCode,
                    'cgdNo' => $cgdCode,
                    'spuCode' => $spuCode,
                    'companyNo' => $filing['customerCode'],
                    'good_num' => $filing['num'],
                    'wsend_num' => $filing['num'],
                    'send_num' => 0,
                    'wait_num' => $filing['num'],
                ]);

            if ($order_send_insert) Db::name('order_send')->insertAll($order_send_insert);


            //处理台账
            if (isset($standing_bood_data['outCode']) && is_array($standing_bood_data['outCode'])) $standing_bood_data['outCode'] = implode(',', $standing_bood_data['outCode']);

            Db::name('standing_book')->insert($standing_bood_data);

            Db::commit();
            return json_show(0, '转单成功');

        } catch (Exception $exception) {
            Db::rollback();
            Db::name('filing')
                ->where(['is_del' => 0, 'id' => $param['id'], 'status' => 2])
                ->update(['status' => 4, 'updatetime' => $date, 'reason' => $exception->getMessage()]);
            return json_show(1005, '转单失败,' . $exception->getMessage());
        }

//        $param['supplierNo'] = $this->request->user['supplierNo'];
//        return FilingLogic::transfer($param);
    }

    //订单录入
    public function orderAdd()
    {
        $param = $this->request->param([
            "companyNo" => '',
            "poCode" => "",
            "workCode" => "",
            "khNo" => "",
            "qrdType" => 3,
            "goodName" => "",
            "tax" => "",
            "goodNum" => "",
            "goodPrice" => "",
            "goodUnit" => "",
            "mobile" => "",
            "addr" => "",
            "addr_code" => "",
            "contactor" => "",
            "buyerid" => "",
            "buyer_name" => "",
            "sendtime" => "",
            "cat_id" => '',
            "supplierNo" => "",
            "cgd_tax" => "",
            "platform_id" => "0",
        ], "post", "trim");

        $valid = Validate::rule([
            "companyNo|业务公司编号" => "require|max:255|min:1",
            "supplierNo|业务公司编号" => "require|max:255|min:1",
            "poCode|PO编号" => "require|max:255|min:1",
            "khNo|客户公司编号" => "require|max:255|min:1",
            "qrdType|订单类型" => "require|number|in:1,2,3",
            "goodName|商品名称" => "require|max:255|min:1",
            "goodUnit|商品单位" => "require|number|gt:0",
            "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",
            "buyerid|采购员ID" => "require|number|gt:0",
            "buyer_name|采购员" => "require|max:255|min:1",
            "sendtime|发货时间" => "require|date",
            "cat_id|商品分类id" => "require|number|gt:0",
            "cgd_tax|采购毛利率" => "require|float|gt:0",
            "platform_id|平台" => "require|number"
        ]);
        if ($valid->check($param) == false) return error_show(1004, $valid->getError());
        $qrdcode = makeNo("QR");
        $cgddcode = makeNo("CG");
        $goodCode = makeNo("SKU");
        $userCommon = new \app\admin\common\User();
        $tmp = $userCommon->handle('getCodeAndName',['code'=>[$param['khNo'],$param['supplierNo'],$param['companyNo']]]);
        if(!isset($tmp['code']) || $tmp['code']!=0) return json_show($tmp['code'],$tmp['message'],$tmp['data']);
        if(!isset($tmp['data'][$param['khNo']])) return json_show(1004, "未找到客户数据");
        if(!isset($tmp['data'][$param['supplierNo']])) return json_show(1004, "未找到平台供应商数据");
        if(!isset($tmp['data'][$param['companyNo']])) return json_show(1004, "未找到平台业务公司数据");
        if($tmp['data'][$param['supplierNo']] == $tmp['data'][$param['companyNo']]) return json_show(1004,'供应商和业务公司不能为同一家公司');

//        $customer = Db::name("customer_info")->where('companyNo', "=", $param['khNo'])->find();
//        if ($customer == false) return error_show(1004, "客户信息未找到");
//        $supplierName = Db::name("supplier")->where('code', "=", $param['supplierNo'])->value("name", "");
//        if ($supplierName == '') return error_show(1004, "供应商信息未找到");
//        $companyName = Db::name("supplier")->where('code', "=", $param['companyNo'])->value("name", "");
//        if ($companyName == '') return error_show(1004, "业务公司信息未找到");
//        if ($param['platform_id'] != 0) {
            $payinfo = Db::name("platform")->where(["id"=> $param['platform_id'],"is_del"=>0])->findOrEmpty();
            if (empty($payinfo)) return error_show(1004, "平台信息未找到");
            if ($payinfo['status'] != 1) return error_show(1004, "平台信息已禁用");
            if($payinfo['is_select_pay_rate']==1){
	            $supplierArr = Db::name("platform_pay_rate")->where(["platform_id" => $param['platform_id'], "status" => 1, "is_del" => 0])->column("companyNo");
	            if (in_array($param['companyNo'], $supplierArr)) return error_show(1004, "平台支付渠道含有该业务公司，平台无法使用！");
            }

//        }
        $param["cgd_tax"] = $param["cgd_tax"] / 100;
        $cgdPrice = round($param['goodPrice'] * (1 - $param['cgd_tax']), 2);
        $qrddata = [
            "orderCode" => $qrdcode,
            "apply_id" => $this->uid,
            "apply_name" => $this->uname,
            "order_type" => $param['qrdType'],
            "order_source" => 9,
            "platform_id" => $param['platform_id'],
            "good_code" => $goodCode,
            "skuCode" => '',
            "cat_id" => $param['cat_id'],
            "good_name" => $param['goodName'],
            "good_num" => $param['goodNum'],
            "good_type" => 1,
            "origin_price" => $cgdPrice,
            "sale_price" => $param['goodPrice'],
            "total_price" => round($param['goodPrice'] * $param['goodNum'], 2),
            "post_fee" => 0,
            "is_diff" => 0,
            "is_activity" => 0,
            "activity_code" => '',
            "is_stock" => 0,
            "arrive_time" => $param['sendtime'],
            "customer_code" => $param['khNo'],
            "customerName" => $tmp['data'][$param['khNo']],
            "supplierNo" => $param['companyNo'],
            "supplierName" =>$tmp['data'][$param['companyNo']],
            "supName" => $tmp['data'][$param['supplierNo']],
            "supNo" => $param['supplierNo'],
            "platform_order" => $param['poCode'],
            "send_num" => $param['goodNum'],
            "wsend_num" => 0,
            "send_status" => 3,
            "send_type" => 1,
            "status" => 2,
            "is_del" => 0,
            "pay_id" => 0,
            "workNo" => $param['workCode'],
            "addtime" => date("Y-m-d H:i:s"),
            "updatetime" => date("Y-m-d H:i:s"),
            "cgderid" => $param['buyerid'],
            "cgder" => $param['buyer_name'],
            "good_createrid" => $this->uid,
            "good_creater" => $this->uname
        ];
        $orderCgd = [
            "orderCode" => $qrdcode,
            "cgdNo" => $cgddcode,
            "spuCode" => $goodCode,
            "good_num" => $param['goodNum'],
            "wsend_num" => 0,
            "send_num" => $param['goodNum'],
            "wait_num" => 0
        ];
        $cgddata = [
            "cgdNo" => $cgddcode,
            "bkcode" => '',
            "wsm_code" => "",
            "cgder_id" => $param['buyerid'],
            'cgder' => $param['buyer_name'],
            "spuCode" => $goodCode,
            "good_name" => $param['goodName'],
            "good_num" => $param['goodNum'],
            "good_price" => $cgdPrice,
            "total_fee" => round($cgdPrice * $param['goodNum'], 2),
            "supplierNo" => $param['supplierNo'],
            "supplier_name" =>$tmp['data'][$param['supplierNo']],
            "companyNo" => $param['companyNo'],
            "companyName" => $tmp['data'][$param['companyNo']],
            "send_status" => 3,
            "send_num" => $param['goodNum'],
            "wsend_num" => 0,
            "status" => 3,
            "lasttime" => date("Y-m-d H:i:s"),
            "order_type" => $param['qrdType'],
            "order_source" => 9,
            "addtime" => date("Y-m-d H:i:s"),
            "updatetime" => date("Y-m-d H:i:s"),
            "good_createrid" => $this->uid,
            "good_creater" => $this->uname,
        ];
        $goodinfo = [
            "spuCode" => $goodCode,
            "good_name" => $param['goodName'],
            "brand_id" => 0,
            "cat_id" => $param['cat_id'],
            "good_unit" => $param['goodUnit'],
            "good_type" => 1,
            "moq" => 1,
            "customized" => 0,
            "platform_id" => $param['platform_id'],
            "tax" => $param['tax'],
            "supplierNo" => $param['supplierNo'],
            "supplierName" =>$tmp['data'][$param['supplierNo']],
            "is_auth" => 1,
            "craft_desc" => '',
            "good_remark" => '',
            "good_img" => '',
            "good_thumb_img" => '',
            "good_info_img" => '',
            "createrid" => $this->uid,
            "creater" => $this->uname,
            "specinfo" => '',
            "work_day" => 0,
            "noble_metal" => 0,
            "good_weight" => 0,
            "config" => "",
            "weight" => 0,
            "supply_area" => 0,
            "is_diff" => 0,
            "pay_way" => 0,
            "send_way" => 0,
            "companyNo" => $param['companyNo'],
            "companyName" => $tmp['data'][$param['companyNo']],
            "addtime" => date("Y-m-d H:i:s"),
            "updatetime" => date("Y-m-d H:i:s"),
        ];
        $orderAddr = [
            "orderCode" => $qrdcode,
            "addr" => $param['addr'],
            "addr_code" => $param['addr_code'],
            "contactor" => $param['contactor'],
            "mobile" => $param['mobile'],
            "arrive_time" => $param['sendtime'],
            "customer_code" => $param['khNo'],
            "receipt_quantity" => $param['goodNum'],
            "addtime" => date("Y-m-d H:i:s"),
            "updatetime" => date("Y-m-d H:i:s"),
        ];
        Db::startTrans();
        try {
            $qrd = Db::name("sale")->insert($qrddata);
            if ($qrd == false) throw new Exception("销售单生成失败");
            $qrd = Db::name("order_num")->insert($orderCgd);
            if ($qrd == false) throw new Exception("销售单采购管联生成失败");
            $qrd = Db::name("purchease_order")->insert($cgddata);
            if ($qrd == false) throw new Exception("采购单生成失败");
            $qrd = Db::name("good_zixun")->insert($goodinfo);
            if ($qrd == false) throw new Exception("商品信息录入生成失败");
            $qrd = Db::name("order_addr")->insert($orderAddr);
            if ($qrd == false) throw new Exception("销售单地址生成失败");
//            if ($param['pay_id'] != 0) {
//                pay_log($param['pay_id'], $param['companyNo'], $qrdcode);
//            }

            Db::commit();
            return app_show(0, '订单生成成功');
        } catch (\Exception $exception) {
            Db::rollback();
            return error_show(1004, $exception->getMessage());
        }
    }

    public function orderInfo()
    {
        $param = $this->request->param(["orderCode"], "post", "trim");
        if ($param['orderCode'] == '') return error_show(1004, "订单编号不能为空");
        $saleinfo = Db::name("sale")->where(["orderCode" => $param['orderCode']])->findOrEmpty();
        if (empty($saleinfo)) return error_show(1004, "销售单不存在");
        if ($saleinfo['order_source'] != 9) return error_show(1004, "销售单来源不是网络录入");
        $cgd = Db::name("purchease_order")->alias("a")
            ->leftJoin("order_num b", "a.cgdNo=b.cgdNo")
            ->where(["b.orderCode" => $param['orderCode']])
            ->field("a.*")
            ->findOrEmpty();
        if (empty($cgd)) return error_show(1004, "采购单不存在");
        $goodinfo = Db::name("good_zixun")->where(["spuCode" => $saleinfo['good_code']])->findOrEmpty();
        if (empty($goodinfo)) return error_show(1004, "商品信息不存在");
        $addr = Db::name("order_addr")->where(["orderCode" => $param['orderCode']])->findOrEmpty();
        if (empty($addr)) return error_show(1004, "地址信息不存在");
        $addinfo = $addr['addr_code'] != '' ? json_decode($addr['addr_code'], true) ?? $addr['addr_code'] : '';
        if (is_string($addinfo) && $addinfo != '') {
            $addinfo = ["provice_code" => '', "city_code" => '', "area_code" => ''];
            list($addinfo['provice_code'], $addinfo['city_code'], $addinfo['area_code']) = explode(",", $addr['addr_code']);
        }
		$platform = Db::name("platform")->where(["id" => $saleinfo['platform_id']])->field("platform_name,pay_title")
		->findOrEmpty();

        $userCommon = new \app\admin\common\User();
        $names = $userCommon->handle('getCodeAndName', ['code' => [$saleinfo['supplierNo'], $saleinfo['customer_code']]]);

        $data = [
            "orderCode" => $saleinfo['orderCode'],
            "companyNo" => $saleinfo['supplierNo'],
            "companyName" => $names['data'][$saleinfo['supplierNo']] ?? '',//Db::name("supplier")->where(["code" => $saleinfo['supplierNo']])->value("name", ''),
            "poCode" => $saleinfo['platform_order'],
            "workCode" => $saleinfo['workNo'],
            "platform_id" => $saleinfo['platform_id'],
            "platform_name" =>$platform['platform_name']??"",
            "khNo" => $saleinfo['customer_code'],
            "khName" => $names['data'][$saleinfo['customer_code']] ?? '',//Db::name("customer_info")->where(["companyNo" => $saleinfo['customer_code']])->value("companyName", ''),
            "qrdType" => $saleinfo['order_type'],
            "goodName" => $saleinfo['good_name'],
            "tax" => $goodinfo['tax'],
            "goodUnit" => $goodinfo['good_unit'],
            "unitName" => Db::name("unit")->where(["id" => $goodinfo['good_unit']])->value("unit", ""),
            "goodNum" => $saleinfo['good_num'],
            "goodPrice" => $saleinfo['sale_price'],
            "mobile" => $addr['mobile'],
            "addr" => $addr['addr'],
            "addr_cn" => GetAddr(json_encode($addinfo)),
            "addr_code" => $addr['addr_code'],
            "contactor" => $addr['contactor'],
            "buyerid" => $saleinfo['cgderid'],
            "buyer_name" => $saleinfo['cgder'],
            "sendtime" => $saleinfo['arrive_time'],
            "cat_id" => made($saleinfo['cat_id']),
            "cat_name" => Db::name("cat")->where(["id" => $saleinfo['cat_id']])->value("cat_name", ''),
            "supplierNo" => $cgd['supplierNo'],
            "supplierNanme" => $cgd['supplier_name'],
            "cgd_tax" => round(($saleinfo['sale_price'] - $saleinfo['origin_price']) / $saleinfo['sale_price'], 4) * 100,
            "pay_id" => $saleinfo['pay_id'],
            "pay_name" =>$platform['pay_title']??"",
        ];
        return app_show(0, "获取成功", $data);
    }

    public function orderEdit()
    {
        $param = $this->request->param([
            "orderCode" => "",
//            "companyNo" => '',
            "poCode" => "",
            "workCode" => "",
//            "khNo" => "",
            "tax" => "",
            "goodUnit" => "",
            "mobile" => "",
            "addr" => "",
            "addr_code" => "",
            "contactor" => "",
            "buyerid" => "",
            "buyer_name" => "",
            "sendtime" => "",
            "supplierNo" => "",
            "cgd_tax" => ""
        ], "post", "trim");

        $valid = Validate::rule([
            "orderCode|销售单号" => "require|max:255",
//	 		"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",
            "mobile|联系人电话" => "require|number|mobile",
            "goodUnit|商品单位" => "require|number|gt:0",
            "contactor|联系人" => "require|max:255|min:1",
            "addr|收货地址" => "require|max:255|min:1",
            "addr_code|收货省市区" => "require|max:255|min:1",
            "buyerid|采购员ID" => "require|number|gt:0",
            "buyer_name|采购员" => "require|max:255|min:1",
            "sendtime|发货时间" => "require|date",
            "tax|商品利率" => "require|number",
            "cgd_tax|采购毛利率" => "require|float|gt:0",
        ]);
        if ($valid->check($param) == false) return error_show(1004, $valid->getError());

        $param["cgd_tax"] = $param["cgd_tax"] / 100;
        $saleinfo = Db::name("sale")->where(["orderCode" => $param['orderCode']])->findOrEmpty();
        if (empty($saleinfo)) return error_show(1004, "销售单不存在");
        if ($saleinfo['order_source'] != 9) return error_show(1004, "销售单来源不是网络录入");
        $cgd = Db::name("purchease_order")->alias("a")
            ->leftJoin("order_num b", "a.cgdNo=b.cgdNo")
            ->where(["b.orderCode" => $param['orderCode']])
            ->field("a.*")
            ->findOrEmpty();
        if (empty($cgd)) return error_show(1004, "采购单不存在");

        $userCommon = new \app\admin\common\User();
        $tmp = $userCommon->handle('getCodeAndName',['code'=>[$param['supplierNo'],$cgd['companyNo']]]);
        if(!isset($tmp['code']) || $tmp['code']!=0) return json_show($tmp['code'],$tmp['message'],$tmp['data']);
//        if(!isset($tmp['data'][$param['khNo']])) return json_show(1004, "未找到客户数据");
        if(!isset($tmp['data'][$param['supplierNo']])) return json_show(1004, "未找到平台供应商数据");
//        if(!isset($tmp['data'][$param['companyNo']])) return json_show(1004, "未找到平台业务公司数据");
        if ($tmp['data'][$param['supplierNo']] == $tmp['data'][$param['companyNo']]) return json_show(1004, '供应商和业务公司不能为同一家公司');



        $good = Db::name("good_zixun")->where(["spuCode" => $saleinfo['good_code']])->findOrEmpty();
        if (empty($good)) return error_show(1004, "商品信息不存在");
        $addr = Db::name("order_addr")->where(["orderCode" => $param['orderCode']])->findOrEmpty();
        if (empty($addr)) return error_show(1004, "地址信息不存在");
        $cgdPrice = round($saleinfo['sale_price'] * (1 - $param['cgd_tax']), 2);
//        if ($saleinfo['platform_id'] != 0) {
//				$supplierArr = Db::name("platform_pay_rate")->where(["platform_id" => $param['platform_id'], "status" => 1, "is_del" => 0])->column("companyNo");
//	            if (in_array($param['companyNo'], $supplierArr)) return error_show(1004, "平台支付渠道含有该业务公司，平台无法使用！");
//        }
        $qrddata = [
            "origin_price" => $cgdPrice,
            "arrive_time" => $param['sendtime'],
//			"customer_code"=>$param['khNo'],
//			"supplierNo"=>$param['companyNo'],
            "platform_order" => $param['poCode'],
            "workNo" => $param['workCode'],
            "updatetime" => date("Y-m-d H:i:s"),
            "cgderid" => $param['buyerid'],
            "cgder" => $param['buyer_name']
        ];
        $cgddata = [
            "cgder_id" => $param['buyerid'],
            'cgder' => $param['buyerid'],
            "good_price" => $cgdPrice,
            "total_fee" => round($cgdPrice * $saleinfo['good_num'], 2),
            "supplierNo" => $param['supplierNo'],
            "supplier_name" => $tmp['data'][$param['supplierNo']],
//			"companyNo"=>$param['companyNo'],
            "updatetime" => date("Y-m-d H:i:s"),
        ];
        $goodinfo = [
            "good_unit" => $param['goodUnit'],
            "tax" => $param['tax'],
            "supplierNo" => $param['supplierNo'],
//            "companyNo" => $param['companyNo'],
            "updatetime" => date("Y-m-d H:i:s"),
        ];
        $orderAddr = [
            "addr" => $param['addr'],
            "addr_code" => $param['addr_code'],
            "contactor" => $param['contactor'],
            "mobile" => $param['mobile'],
            "arrive_time" => $param['sendtime'],
//            "customer_code" => $param['khNo'],
            "updatetime" => date("Y-m-d H:i:s"),
        ];
        Db::startTrans();
        try {
            $qrd = Db::name("sale")->where($saleinfo)->update($qrddata);
            if ($qrd == false) throw new Exception("销售单更新失败");
            $qrd = Db::name("purchease_order")->where($cgd)->update($cgddata);
            if ($qrd == false) throw new Exception("采购单更新失败");
            $qrd = Db::name("good_zixun")->where($good)->update($goodinfo);
            if ($qrd == false) throw new Exception("商品信息更新失败");
            $qrd = Db::name("order_addr")->where($addr)->update($orderAddr);
            if ($qrd == false) throw new Exception("销售单地址更新失败");
            Db::commit();
            return app_show(0, '订单更新成功');
        } catch (\Exception $exception) {
            Db::rollback();
            return error_show(1004, $exception->getMessage());
        }
    }
}