";
//print_r($bach['bach_ids']);
//echo "
";die;
//        $summaryUpdate = $mongo->name($qcode_bachsummary)
//            ->where('_id', new \MongoDB\BSON\ObjectId($bach['bach_ids']))  // 这里也要根据实际字段类型处理
//            ->find();
//        echo "
";
//        print_r($summaryUpdate);
//        echo "
";

        if ($result) {


            $this->success('更新成功');
        } else {
            $this->error('更新失败');
        }
    }


    /**
     * 批次发货删除
     * @param $ids
     * @return void
     */
    public function apply_del($ids)
    {
        $export = new QcodeExport();
        $userinfo = Session::get('admin');
        $large = new QcodeLarge();
        if (empty($ids)){
            $this->error('请求错误');
        }
        $res = $export->where('_id',$ids)->update(['delete_time'=>date('Y-m-d H:i:s',time())]);
        if ($res === false){
            $this->error('删除失败');
        }
        $large_list = $export->where('_id',$ids)->find();
        $large_id = explode(',',$large_list['large_str']);
        foreach ($large_id as $v){
            $result = $large->name($userinfo['company'].'_'.'qcode_large')->where('_id',$v)->update(['l_status'=>0]);
            if ($result === 0){
                $this->error('删除失败');
            }
        }
        $this->success('成功');
    }

    /**
     * 司机弹窗
     * @param $ids
     * @return string
     * @throws \think\Exception
     */
    public function goods($ids)
    {
        $this->view->assign('ids',$ids);
        return $this->view->fetch();
    }

    /**
     * 批次发货提交
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function apply_add()
    {
        $goods = new QcodeGoods();
        $export = new QcodeExport();
        $userinfo = Session::get('admin');
        if ($this->request->isAjax() === false){
            $this->error('请求错误');
        }
        $ids = input('ids');
        $order_number = input('order_number');
        $deliveryman = input('deliveryman');
        $shr_phone = input('shr_phone');
        $plate_number = input('plate_number');
        $note = input('note');
//        $id_list = [];
//        if (strpos($ids,',') === false){
//            $id_list[0] = $ids;
//        }else{
//            $id_list = explode(',',$ids);
//        }
//        $update_status = $export->where('company_id',$userinfo['company'])->whereIn('_id',$id_list)->update(['status'=>2]);
        $mongo = \think\Db::connect('mongodb');
        $collection = $userinfo['company'] . '_qcode_bach';
        $bachsummary = $userinfo['company'] . '_qcode_bachsummary';
        $update_status = $mongo->name($bachsummary)->where('_id',$ids)->update(
            [
                'bach_status'=>2,
                'delete_time' => date('Y-m-d H:i:s')
            ]);
        if ($update_status){
            $bachsummary_list = $mongo->name($bachsummary)->where('_id',$ids)->select();
            $daterq = date('ymd',time());
            $data = [
                'shdh' => substr($daterq,2,2).' '.substr($daterq,2,6).mt_rand(1000,9999),//收货单号
                'order_number' => $order_number,//订单号
                'deliveryman' => $deliveryman,//订单号
                'shr_phone' => $shr_phone,//电话
                'plate_number' => $plate_number,//车牌号
                'shrq_date' => '',
                'supplier_name' => $bachsummary_list[0]['supplier_name'],//供应商名称
                'supplier_id' => $userinfo['id'],//供应商名称id
                'user_id' => $userinfo['id'],//用户id
                'status' => 0,
                'qcode_bachsummary_id' => $ids,
                'export_id' => '',
                'create_time' => time(),
                'note' => $note,
                'company_id' => $userinfo['company'],
            ];
            $data['qrcode_add'] = $this->Qrcode($data['shdh']);
            $res = $goods->save($data);
            if ($res === false){
                $this->error('失败');
            }
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 生成二维码
     * @param $url
     * @return string
     */
    public function Qrcode($url)
    {
        $level=2;
        $size=5;
        Vendor('phpqrcode.phpqrcode');//加载生成二维码的核心类
        $errorCorrectionLevel =intval($level) ;//容错级别
        $matrixPointSize = intval($size);//生成图片大小
        //生成二维码图片
        $object = new \QRcode();
        //打开缓冲区
        ob_start();
        $object->png($url, false, $errorCorrectionLevel, $matrixPointSize, 2);
        //这里就是把生成的图片流从缓冲区保存到内存对象上，使用base64_encode变成编码字符串，通过json返回给页面。
        $imageString = base64_encode(ob_get_contents());
        //关闭缓冲区
        ob_end_clean();
        //把生成的base64字符串返回给前端
        return 'data:image/png;base64,'.$imageString;
    }

    /**
     * 发货单
     * @return string|\think\response\Json
     * @throws \think\Exception
     */
    public function dispatch()
    {
        $export = new QcodeGoods();
        $this->request->filter(['strip_tags', 'trim']);
        if (false === $this->request->isAjax()) {
            return $this->view->fetch();
        }
        if ($this->request->request('keyField')) {
            return $this->selectpage();
        }
        // 接收参数
        $userInfo = Session::get('admin');
        $where = [
            'company_id' => $userInfo['company'],
            'delete_time'=> ''
        ];
        $search = input('search');
        if (isset($search)){
            $where['order_number|supplier_name|status|plate_number|shdh|deliveryman'] = new \MongoDB\BSON\Regex($search);
        }
        $filter = input('filter');
        $filter = json_decode($filter,true);
        //订单编号查询
        if (isset($filter['order_number'])){
            $where['order_number'] =$filter['order_number'];
        }
        //所属公司查询
        if (isset($filter['supplier_name'])){
            $where['supplier_name'] = $filter['supplier_name'];
        }
        if (isset($filter['status'])){
            $where['status'] = (int)$filter['status'];
        }
        if (isset($filter['create_time'])){
            $begin = substr($filter['create_time'],0,19);
            $end = substr($filter['create_time'],22);
            $begin = strtotime($begin);
            $end = strtotime($end);
            $where['create_time'] = ['between',[$begin,$end]];
        }
        $order = input('order');
        $offset = input('offset');
        $limit = input('limit');
        $total = $export->where($where)->count();
        $export_list = $export
            ->order('_id',$order)
            ->where($where)
            ->whereIn('status',[0,1])
            ->skip($offset)
            ->limit($limit)
            ->select();
        $list=[];
        foreach ($export_list as $k=>$v) {
            $list[$k]['id'] = substr(json_encode($v['_id']),9,-2);
            $list[$k]['shdh'] = $v['shdh'];
            $list[$k]['order_number'] = $v['order_number'];
            $list[$k]['supplier_name'] = $v['supplier_name'];
            $list[$k]['deliveryman'] = $v['deliveryman'];
            $list[$k]['plate_number'] = $v['plate_number'];
            $list[$k]['create_time'] = $v['create_time'];
            $list[$k]['status'] = $v['status'];
        }
        $result = ['total'=>$total,'rows'=>$list];
        return json($result);
    }

    /**
     * 发货单打印
     * @return \think\response\Json|void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function printqrcode()
    {
        // 1. 验证请求类型
        if (!$this->request->isAjax()) {
            return json(['code' => 0, 'msg' => '请求错误']);
        }

        try {
            // 2. 初始化数据库连接
            $mongo = \think\Db::connect('mongodb');
            $userinfo = Session::get('admin');

            if (empty($userinfo) || empty($userinfo['company'])) {
                return json(['code' => 0, 'msg' => '用户信息获取失败']);
            }

            // 3. 设置集合名称
            $goodsCollection = '_qcode_goods';
            $bachCollection = $userinfo['company'] . '_qcode_bach';
            $bachsummaryCollection = $userinfo['company'] . '_qcode_bachsummary';

            // 4. 获取请求参数
            $id = input('id');
            if (empty($id)) {
                return json(['code' => 0, 'msg' => 'ID不能为空']);
            }

            // 5. 查询发货单信息
            $goodList = $mongo->name($goodsCollection)
                ->where('_id', $id)
                ->find();

            if (empty($goodList)) {
                return json(['code' => 0, 'msg' => '未找到发货单数据']);
            }

            // 6. 获取批次数据
            if (isset($goodList['data']) && is_array($goodList['data'])) {
                $detailData = $goodList['data'];
            } else {
                if (empty($goodList['qcode_bachsummary_id'])) {
                    return json(['code' => 0, 'msg' => '发货单缺少批次汇总ID']);
                }

                $bachsummaryData = $mongo->name($bachsummaryCollection)
                    ->where('_id', $goodList['qcode_bachsummary_id'])
                    ->find();

                if (empty($bachsummaryData)) {
                    return json(['code' => 0, 'msg' => '未找到对应的批次汇总数据']);
                }

                $detailData = $mongo->name($bachCollection)
                    ->where('bach_ids', $bachsummaryData['bach_ids'])
                    ->select();
            }

            // 7. 按产品名称分组处理
            $productGroups = [];
            foreach ($detailData as $item) {
                $productName = $item['matter_name'];
                if (!isset($productGroups[$productName])) {
                    $productGroups[$productName] = [];
                }
                $productGroups[$productName][] = $item;
            }

            // 8. 处理分组数据
            $groupedData = [];
            $totalTray = 0;
            $totalBox = 0;
            $productSummary = [];

            // 存储完整托盘和部分托盘
            $allFullPallets = [];
            $allPartialPallets = [];

            foreach ($productGroups as $productName => $items) {
                foreach ($items as $item) {
                    if ($item['pallet_type'] === 'full') {
                        $allFullPallets[] = [
                            'productName' => $productName,
                            'data' => $item
                        ];
                    } else {
                        $allPartialPallets[] = [
                            'productName' => $productName,
                            'data' => $item
                        ];
                    }
                }
            }

            // 对完整托盘按产品名称和托盘序号排序
            usort($allFullPallets, function($a, $b) {
                $nameCompare = strcmp($a['productName'], $b['productName']);
                if ($nameCompare !== 0) {
                    return $nameCompare;
                }
                return $a['data']['pallet_sequence'] <=> $b['data']['pallet_sequence'];
            });

            // 处理完整托盘
            $currentPalletNumber = 1;
            $currentProduct = null;
            $rangeStart = null;
            $rangeCount = 0;

            foreach ($allFullPallets as $index => $pallet) {
                if ($pallet['productName'] !== $currentProduct) {
                    // 完成上一个产品范围
                    if ($rangeStart !== null) {
                        $first = $allFullPallets[$rangeStart]['data'];

                        $groupedData[] = [
                            'pallet' => $currentPalletNumber . '-' . ($currentPalletNumber + $rangeCount - 1),
                            'matter_name' => $currentProduct,
                            'small_num' => $first['small_num'],
                            'total_boxes' => $first['boxes_in_pallet'],
                            'tray_num' => $first['tray_num'],
                            'box_num' => $first['box_num'],
                            'pallet_height' => $first['pallet_height'],
                            'pallet_length' => $first['pallet_length'],
                            'pallet_width' => $first['pallet_width'],
                            'large_num' => $rangeCount,
                            'larger_num' => $first['boxes_in_pallet'] * $rangeCount,
                            'num' => $first['num'] * $rangeCount,
                            'danwei' => $first['danwei']
                        ];

                        $totalTray += $rangeCount;
                        $totalBox += $first['boxes_in_pallet'] * $rangeCount;

                        if (!isset($productSummary[$currentProduct])) {
                            $productSummary[$currentProduct] = [
                                'qty' => 0,
                                'unit' => $first['danwei']
                            ];
                        }
                        $productSummary[$currentProduct]['qty'] += $first['num'] * $rangeCount;

                        $currentPalletNumber += $rangeCount;
                    }

                    // 开始新的产品范围
                    $currentProduct = $pallet['productName'];
                    $rangeStart = $index;
                    $rangeCount = 1;
                } else {
                    $rangeCount++;
                }
            }

            // 处理最后一个产品范围
            if ($rangeStart !== null) {
                $first = $allFullPallets[$rangeStart]['data'];

                $groupedData[] = [
                    'pallet' => $currentPalletNumber . '-' . ($currentPalletNumber + $rangeCount - 1),
                    'matter_name' => $currentProduct,
                    'small_num' => $first['small_num'],
                    'total_boxes' => $first['boxes_in_pallet'],
                    'tray_num' => $first['tray_num'],
                    'box_num' => $first['box_num'],
                    'pallet_height' => $first['pallet_height'],
                    'pallet_length' => $first['pallet_length'],
                    'pallet_width' => $first['pallet_width'],
                    'large_num' => $rangeCount,
                    'larger_num' => $first['boxes_in_pallet'] * $rangeCount,
                    'num' => $first['num'] * $rangeCount,
                    'danwei' => $first['danwei']
                ];

                $totalTray += $rangeCount;
                $totalBox += $first['boxes_in_pallet'] * $rangeCount;

                if (!isset($productSummary[$currentProduct])) {
                    $productSummary[$currentProduct] = [
                        'qty' => 0,
                        'unit' => $first['danwei']
                    ];
                }
                $productSummary[$currentProduct]['qty'] += $first['num'] * $rangeCount;

                $currentPalletNumber += $rangeCount;
            }

            // 处理部分托盘 - 合并显示但分开产品信息
            $warning4Partial = null;
            $warning10Partial = null;

            // 查找可以合并的部分托盘
            foreach ($allPartialPallets as $partial) {
                if (strpos($partial['productName'], '警语4') !== false) {
                    $warning4Partial = $partial;
                } elseif (strpos($partial['productName'], '警语10') !== false) {
                    $warning10Partial = $partial;
                }
            }

            // 检查是否可以合并（7+13=20箱）
            if ($warning4Partial && $warning10Partial &&
                ($warning4Partial['data']['boxes_in_pallet'] + $warning10Partial['data']['boxes_in_pallet']) == 20) {

                // 警语4版本（7箱）
                $groupedData[] = [
                    'pallet' => $currentPalletNumber,
                    'matter_name' => $warning4Partial['productName'],
                    'small_num' => $warning4Partial['data']['small_num'],
                    'total_boxes' => $warning4Partial['data']['boxes_in_pallet'],
                    'tray_num' => $warning4Partial['data']['tray_num'],
                    'box_num' => $warning4Partial['data']['box_num'],
                    'pallet_height' => $warning4Partial['data']['pallet_height'],
                    'pallet_length' => $warning4Partial['data']['pallet_length'],
                    'pallet_width' => $warning4Partial['data']['pallet_width'],
                    'large_num' => 1,
                    'larger_num' => $warning4Partial['data']['boxes_in_pallet'],
                    'num' => $warning4Partial['data']['num'],
                    'danwei' => $warning4Partial['data']['danwei'],
                    'is_combined' => true
                ];

                // 警语10版本（13箱）
                $groupedData[] = [
                    'pallet' => $currentPalletNumber,
                    'matter_name' => $warning10Partial['productName'],
                    'small_num' => $warning10Partial['data']['small_num'],
                    'total_boxes' => $warning10Partial['data']['boxes_in_pallet'],
                    'tray_num' => $warning10Partial['data']['tray_num'],
                    'box_num' => $warning10Partial['data']['box_num'],
                    'pallet_height' => $warning10Partial['data']['pallet_height'],
                    'pallet_length' => $warning10Partial['data']['pallet_length'],
                    'pallet_width' => $warning10Partial['data']['pallet_width'],
                    'large_num' => 1,
                    'larger_num' => $warning10Partial['data']['boxes_in_pallet'],
                    'num' => $warning10Partial['data']['num'],
                    'danwei' => $warning10Partial['data']['danwei'],
                    'is_combined' => true
                ];

                $totalTray += 1; // 只算一个托盘
                $totalBox += 20; // 总箱数7+13=20

                // 产品统计
                foreach ([$warning4Partial, $warning10Partial] as $partial) {
                    if (!isset($productSummary[$partial['productName']])) {
                        $productSummary[$partial['productName']] = [
                            'qty' => 0,
                            'unit' => $partial['data']['danwei']
                        ];
                    }
                    $productSummary[$partial['productName']]['qty'] += $partial['data']['num'];
                }

                $currentPalletNumber++;
            } else {
                // 不能合并，单独显示每个部分托盘
                foreach ($allPartialPallets as $partial) {
                    $groupedData[] = [
                        'pallet' => $currentPalletNumber,
                        'matter_name' => $partial['productName'],
                        'small_num' => $partial['data']['small_num'],
                        'total_boxes' => $partial['data']['boxes_in_pallet'],
                        'tray_num' => $partial['data']['tray_num'],
                        'box_num' => $partial['data']['box_num'],
                        'pallet_height' => $partial['data']['pallet_height'],
                        'pallet_length' => $partial['data']['pallet_length'],
                        'pallet_width' => $partial['data']['pallet_width'],
                        'large_num' => 1,
                        'larger_num' => $partial['data']['boxes_in_pallet'],
                        'num' => $partial['data']['num'],
                        'danwei' => $partial['data']['danwei']
                    ];

                    $totalTray += 1;
                    $totalBox += $partial['data']['boxes_in_pallet'];

                    if (!isset($productSummary[$partial['productName']])) {
                        $productSummary[$partial['productName']] = [
                            'qty' => 0,
                            'unit' => $partial['data']['danwei']
                        ];
                    }
                    $productSummary[$partial['productName']]['qty'] += $partial['data']['num'];

                    $currentPalletNumber++;
                }
            }

            // 9. 单位分类统计
            $totalTao = 0;
            $totalZhang = 0;
            $totalGe = 0;

            foreach ($productSummary as $product) {
                switch ($product['unit']) {
                    case '套':
                        $totalTao += $product['qty'];
                        break;
                    case '张':
                        $totalZhang += $product['qty'];
                        break;
                    case '个':
                        $totalGe += $product['qty'];
                        break;
                }
            }

            // 10. 构造返回数据
            $responseData = [
                '_id' => $goodList['_id'],
                'shrq_date' => date('Y-m-d'),
                'shdh' => $goodList['shdh'] ?? '',
                'order_number' => $goodList['order_number'] ?? '',
                'address' => $goodList['address'] ?? '',
                'company_id' => $goodList['company_id'] ?? 0,
                'count' => $goodList['count'] ?? 0,
                'create_time' => $goodList['create_time'] ?? '',
                'data' => $groupedData,
                'summary' => [
                    'totalTray' => $totalTray,
                    'totalBox' => $totalBox,
                    'totalTao' => $totalTao,
                    'totalZhang' => $totalZhang,
                    'totalGe' => $totalGe,
                    'products' => $productSummary
                ],
                'delete_time' => $goodList['delete_time'] ?? '',
                'deliveryman' => $goodList['deliveryman'] ?? '',
                'export_id' => $goodList['export_id'] ?? '',
                'note' => $goodList['note'] ?? '',
                'order_ddbh' => $goodList['order_ddbh'] ?? '',
                'plate_number' => $goodList['plate_number'] ?? '',
                'qrcode_add' => $goodList['qrcode_add'] ?? '',
                'shr_phone' => $goodList['shr_phone'] ?? '',
                'status' => $goodList['status'] ?? 0,
                'supplier_id' => $goodList['supplier_id'] ?? 0,
                'supplier_name' => $goodList['supplier_name'] ?? '',
                'sync_flag' => $goodList['sync_flag'] ?? 0,
                'user_id' => $goodList['user_id'] ?? 0
            ];

            return json([
                'code' => 1,
                'data' => $responseData
            ]);

        } catch (\Exception $e) {
            return json([
                'code' => 0,
                'msg' => '系统错误: ' . $e->getMessage()
            ]);
        }
    }
//    public function printqrcode()
//    {
//        // 1. 验证请求类型
//        if (!$this->request->isAjax()) {
//            return json(['code' => 0, 'msg' => '请求错误']);
//        }
//
//        try {
//            // 2. 初始化数据库连接
//            $mongo = \think\Db::connect('mongodb');
//            $userinfo = Session::get('admin');
//
//            if (empty($userinfo) || empty($userinfo['company'])) {
//                return json(['code' => 0, 'msg' => '用户信息获取失败']);
//            }
//
//            // 3. 设置集合名称
//            $goodsCollection = '_qcode_goods';
//            $bachCollection = $userinfo['company'] . '_qcode_bach';
//            $bachsummaryCollection = $userinfo['company'] . '_qcode_bachsummary';
//
//            // 4. 获取请求参数
//            $id = input('id');
//            if (empty($id)) {
//                return json(['code' => 0, 'msg' => 'ID不能为空']);
//            }
//
//            // 5. 查询发货单信息
//            $goodList = $mongo->name($goodsCollection)
//                ->where('_id', $id)
//                ->find();
//
//            if (empty($goodList)) {
//                return json(['code' => 0, 'msg' => '未找到发货单数据']);
//            }
//
//            // 6. 获取批次数据
//            if (isset($goodList['data']) && is_array($goodList['data'])) {
//                $detailData = $goodList['data'];
//            } else {
//                if (empty($goodList['qcode_bachsummary_id'])) {
//                    return json(['code' => 0, 'msg' => '发货单缺少批次汇总ID']);
//                }
//
//                $bachsummaryData = $mongo->name($bachsummaryCollection)
//                    ->where('_id', $goodList['qcode_bachsummary_id'])
//                    ->find();
//
//                if (empty($bachsummaryData)) {
//                    return json(['code' => 0, 'msg' => '未找到对应的批次汇总数据']);
//                }
//
//                $detailData = $mongo->name($bachCollection)
//                    ->where('bach_ids', $bachsummaryData['bach_ids'])
//                    ->select();
//            }
//
//            // 7. 按产品名称和规格分组处理
//            $productGroups = [];
//            foreach ($detailData as $item) {
//                // 创建分组键，包含产品名称和规格
//                $groupKey = $item['matter_name'] . '|' .
//                    $item['pallet_height'] . '|' .
//                    $item['pallet_length'] . '|' .
//                    $item['pallet_width'];
//
//                if (!isset($productGroups[$groupKey])) {
//                    $productGroups[$groupKey] = [
//                        'product_name' => $item['matter_name'],
//                        'height' => $item['pallet_height'],
//                        'length' => $item['pallet_length'],
//                        'width' => $item['pallet_width'],
//                        'full' => [],
//                        'partial' => []
//                    ];
//                }
//
//                if ($item['pallet_type'] === 'full') {
//                    $productGroups[$groupKey]['full'][] = $item;
//                } else {
//                    $productGroups[$groupKey]['partial'][] = $item;
//                }
//            }
//
//            // 8. 处理分组数据，实现拼托逻辑
//            $groupedData = [];
//            $totalTray = 0;
//            $totalBox = 0;
//            $productSummary = [];
//
//            foreach ($productGroups as $group) {
//                $productName = $group['product_name'];
//                $palletSpec = $group['length'] . ' * ' . $group['width'];
//
//                // 处理完整托盘
//                if (!empty($group['full'])) {
//                    usort($group['full'], function($a, $b) {
//                        return $a['pallet_sequence'] <=> $b['pallet_sequence'];
//                    });
//
//                    $firstFull = $group['full'][0];
//                    $lastFull = end($group['full']);
//                    $palletCount = count($group['full']);
//                    $totalBoxes = $firstFull['boxes_in_pallet'] * $palletCount;
//
//                    $groupedData[] = [
//                        'pallet' => $firstFull['pallet_sequence'].'-'.$lastFull['pallet_sequence'],
//                        'matter_name' => $productName,
//                        'small_num' => $firstFull['small_num'],
//                        'total_boxes' => $firstFull['boxes_in_pallet'],
//                        'tray_num' => $firstFull['tray_num'],
//                        'box_num' => $firstFull['box_num'],
//                        'pallet_height' => $group['height'],
//                        'pallet_length' => $group['length'],
//                        'pallet_width' => $group['width'],
//                        'large_num' => $palletCount,
//                        'larger_num' => $totalBoxes,
//                        'num' => $firstFull['num'] * $palletCount,
//                        'danwei' => $firstFull['danwei']
//                    ];
//
//                    $totalTray += $palletCount;
//                    $totalBox += $totalBoxes;
//
//                    if (!isset($productSummary[$productName])) {
//                        $productSummary[$productName] = [
//                            'qty' => 0,
//                            'unit' => $firstFull['danwei']
//                        ];
//                    }
//                    $productSummary[$productName]['qty'] += $firstFull['num'] * $palletCount;
//                }
//
//                // 处理部分托盘 - 实现拼托逻辑
//                $partialPallets = $group['partial'];
//                if (!empty($partialPallets)) {
//                    // 按托盘序号排序
//                    usort($partialPallets, function($a, $b) {
//                        return $a['pallet_sequence'] <=> $b['pallet_sequence'];
//                    });
//
//                    // 尝试将部分托盘合并
//                    $mergedPartials = [];
//                    $currentMerge = null;
//
//                    foreach ($partialPallets as $partial) {
//                        if ($currentMerge === null) {
//                            $currentMerge = $partial;
//                            $currentMerge['merged_count'] = 1;
//                        } else {
//                            // 检查是否可以合并（相同产品且箱子数相加不超过18）
//                            $canMerge = ($currentMerge['matter_name'] === $partial['matter_name']) &&
//                                (($currentMerge['boxes_in_pallet'] + $partial['boxes_in_pallet']) <= 18);
//
//                            if ($canMerge) {
//                                $currentMerge['boxes_in_pallet'] += $partial['boxes_in_pallet'];
//                                $currentMerge['num'] += $partial['num'];
//                                $currentMerge['merged_count']++;
//                            } else {
//                                $mergedPartials[] = $currentMerge;
//                                $currentMerge = $partial;
//                                $currentMerge['merged_count'] = 1;
//                            }
//                        }
//                    }
//
//                    if ($currentMerge !== null) {
//                        $mergedPartials[] = $currentMerge;
//                    }
//
//                    // 处理合并后的部分托盘
//                    foreach ($mergedPartials as $merged) {
//                        $sequenceText = $merged['merged_count'] > 1 ?
//                            $merged['pallet_sequence'].'-'.($merged['pallet_sequence'] + $merged['merged_count'] - 1):
//                            $merged['pallet_sequence'];
//
//                        $groupedData[] = [
//                            'pallet' => $sequenceText,
//                            'matter_name' => $productName,
//                            'small_num' => $merged['small_num'],
//                            'total_boxes' => $merged['boxes_in_pallet'],
//                            'tray_num' => $merged['tray_num'],
//                            'box_num' => $merged['box_num'],
//                            'pallet_height' => $group['height'],
//                            'pallet_length' => $group['length'],
//                            'pallet_width' => $group['width'],
//                            'large_num' => $merged['merged_count'],
//                            'larger_num' => $merged['boxes_in_pallet'],
//                            'num' => $merged['num'],
//                            'danwei' => $merged['danwei']
//                        ];
//
//                        $totalTray += $merged['merged_count'];
//                        $totalBox += $merged['boxes_in_pallet'];
//
//                        if (!isset($productSummary[$productName])) {
//                            $productSummary[$productName] = [
//                                'qty' => 0,
//                                'unit' => $merged['danwei']
//                            ];
//                        }
//                        $productSummary[$productName]['qty'] += $merged['num'];
//                    }
//                }
//            }
//
//            // 9. 单位分类统计
//            $totalTao = 0;
//            $totalZhang = 0;
//            $totalGe = 0;
//
//            foreach ($productSummary as $product) {
//                switch ($product['unit']) {
//                    case '套':
//                        $totalTao += $product['qty'];
//                        break;
//                    case '张':
//                        $totalZhang += $product['qty'];
//                        break;
//                    case '个':
//                        $totalGe += $product['qty'];
//                        break;
//                }
//            }
//
//            // 10. 构造返回数据
//            $responseData = [
//                '_id' => $goodList['_id'],
//                'shrq_date' => date('Y-m-d'),
//                'shdh' => $goodList['shdh'] ?? '',
//                'order_number' => $goodList['order_number'] ?? '',
//                'address' => $goodList['address'] ?? '',
//                'company_id' => $goodList['company_id'] ?? 0,
//                'count' => $goodList['count'] ?? 0,
//                'create_time' => $goodList['create_time'] ?? '',
//                'data' => $groupedData,
//                'summary' => [
//                    'totalTray' => $totalTray,
//                    'totalBox' => $totalBox,
//                    'totalTao' => $totalTao,
//                    'totalZhang' => $totalZhang,
//                    'totalGe' => $totalGe,
//                    'products' => $productSummary
//                ],
//                // 其他字段保持不变
//                'delete_time' => $goodList['delete_time'] ?? '',
//                'deliveryman' => $goodList['deliveryman'] ?? '',
//                'export_id' => $goodList['export_id'] ?? '',
//                'note' => $goodList['note'] ?? '',
//                'order_ddbh' => $goodList['order_ddbh'] ?? '',
//                'plate_number' => $goodList['plate_number'] ?? '',
//                'qrcode_add' => $goodList['qrcode_add'] ?? '',
//                'shr_phone' => $goodList['shr_phone'] ?? '',
//                'status' => $goodList['status'] ?? 0,
//                'supplier_id' => $goodList['supplier_id'] ?? 0,
//                'supplier_name' => $goodList['supplier_name'] ?? '',
//                'sync_flag' => $goodList['sync_flag'] ?? 0,
//                'user_id' => $goodList['user_id'] ?? 0
//            ];
//
//            return json([
//                'code' => 1,
//                'data' => $responseData
//            ]);
//
//        } catch (\Exception $e) {
//            return json([
//                'code' => 0,
//                'msg' => '系统错误: ' . $e->getMessage()
//            ]);
//        }
//    }
//    public function printqrcode()
//    {
//        // 1. 验证请求类型
//        if (!$this->request->isAjax()) {
//            return json(['code' => 0, 'msg' => '请求错误']);
//        }
//
//        try {
//            // 2. 初始化数据库连接
//            $mongo = \think\Db::connect('mongodb');
//            $userinfo = Session::get('admin');
//
//            if (empty($userinfo) || empty($userinfo['company'])) {
//                return json(['code' => 0, 'msg' => '用户信息获取失败']);
//            }
//
//            // 3. 设置集合名称
//            $goodsCollection = '_qcode_goods';
//            $bachCollection = $userinfo['company'] . '_qcode_bach';
//            $bachsummaryCollection = $userinfo['company'] . '_qcode_bachsummary';
//
//            // 4. 获取请求参数
//            $id = input('id');
//            if (empty($id)) {
//                return json(['code' => 0, 'msg' => 'ID不能为空']);
//            }
//
//            // 5. 查询发货单信息
//            $goodList = $mongo->name($goodsCollection)
//                ->where('_id', $id)
//                ->find();
//
//            if (empty($goodList)) {
//                return json(['code' => 0, 'msg' => '未找到发货单数据']);
//            }
//
//            // 6. 获取批次数据
//            if (isset($goodList['data']) && is_array($goodList['data'])) {
//                $detailData = $goodList['data'];
//            } else {
//                if (empty($goodList['qcode_bachsummary_id'])) {
//                    return json(['code' => 0, 'msg' => '发货单缺少批次汇总ID']);
//                }
//
//                $bachsummaryData = $mongo->name($bachsummaryCollection)
//                    ->where('_id', $goodList['qcode_bachsummary_id'])
//                    ->find();
//
//                if (empty($bachsummaryData)) {
//                    return json(['code' => 0, 'msg' => '未找到对应的批次汇总数据']);
//                }
//
//                $detailData = $mongo->name($bachCollection)
//                    ->where('bach_ids', $bachsummaryData['bach_ids'])
//                    ->select();
//            }
//
//            // 7. 按产品名称分组处理
//            $productGroups = [];
//            foreach ($detailData as $item) {
//                $productName = $item['matter_name'];
//                if (!isset($productGroups[$productName])) {
//                    $productGroups[$productName] = [
//                        'full' => [],
//                        'partial' => []
//                    ];
//                }
//
//                if ($item['pallet_type'] === 'full') {
//                    $productGroups[$productName]['full'][] = $item;
//                } else {
//                    $productGroups[$productName]['partial'][] = $item;
//                }
//            }
//
//            // 8. 处理分组数据
//            $groupedData = [];
//            $totalTray = 0;
//            $totalBox = 0;
//            $productSummary = [];
//
//            foreach ($productGroups as $productName => $group) {
//                // 处理完整托盘
//                if (!empty($group['full'])) {
//                    // 按托盘序号排序
//                    usort($group['full'], function($a, $b) {
//                        return $a['pallet_sequence'] <=> $b['pallet_sequence'];
//                    });
//
//                    $firstFull = $group['full'][0];
//                    $lastFull = end($group['full']);
//                    $palletCount = count($group['full']);
//                    $totalBoxes = $firstFull['boxes_in_pallet'] * $palletCount;
//
//                    $groupedData[] = [
//                        'pallet' => $firstFull['pallet_sequence'].'-'.$lastFull['pallet_sequence'],
//                        'matter_name' => $productName,
//                        'small_num' => $firstFull['small_num'],
//                        'total_boxes' => $firstFull['boxes_in_pallet'],
//                        'tray_num' => $firstFull['tray_num'],
//                        'box_num' => $firstFull['box_num'],
//                        'pallet_height' => $firstFull['pallet_height'],
//                        'pallet_length' => $firstFull['pallet_length'],
//                        'pallet_width' => $firstFull['pallet_width'],
//                        'large_num' => $palletCount,
//                        'larger_num' => $totalBoxes,
//                        'num' => $firstFull['num'] * $palletCount,
//                        'danwei' => $firstFull['danwei']
//                    ];
//
//                    $totalTray += $palletCount;
//                    $totalBox += $totalBoxes;
//
//                    // 产品汇总
//                    if (!isset($productSummary[$productName])) {
//                        $productSummary[$productName] = [
//                            'qty' => 0,
//                            'unit' => $firstFull['danwei']
//                        ];
//                    }
//                    $productSummary[$productName]['qty'] += $firstFull['num'] * $palletCount;
//                }
//
//                // 处理部分托盘
//                foreach ($group['partial'] as $partial) {
//                    $groupedData[] = [
//                        'pallet' => $partial['pallet_sequence'],
//                        'matter_name' => $productName,
//                        'small_num' => $partial['small_num'],
//                        'total_boxes' => $partial['boxes_in_pallet'],
//                        'tray_num' => $partial['tray_num'],
//                        'box_num' => $partial['box_num'],
//                        'pallet_height' => $partial['pallet_height'],
//                        'pallet_length' => $partial['pallet_length'],
//                        'pallet_width' => $partial['pallet_width'],
//                        'large_num' => 1,
//                        'larger_num' => $partial['boxes_in_pallet'],
//                        'num' => $partial['num'],
//                        'danwei' => $partial['danwei']
//                    ];
//
//                    $totalTray += 1;
//                    $totalBox += $partial['boxes_in_pallet'];
//
//                    // 产品汇总
//                    if (!isset($productSummary[$productName])) {
//                        $productSummary[$productName] = [
//                            'qty' => 0,
//                            'unit' => $partial['danwei']
//                        ];
//                    }
//                    $productSummary[$productName]['qty'] += $partial['num'];
//                }
//            }
//
//            // 9. 单位分类统计
//            $totalTao = 0;
//            $totalZhang = 0;
//            $totalGe = 0;
//
//            foreach ($productSummary as $product) {
//                switch ($product['unit']) {
//                    case '套':
//                        $totalTao += $product['qty'];
//                        break;
//                    case '张':
//                        $totalZhang += $product['qty'];
//                        break;
//                    case '个':
//                        $totalGe += $product['qty'];
//                        break;
//                }
//            }
//
//            // 10. 构造返回数据
//            $responseData = [
//                '_id' => $goodList['_id'],
//                'shrq_date' => date('Y-m-d'),
//                'shdh' => $goodList['shdh'] ?? '',
//                'order_number' => $goodList['order_number'] ?? '',
//                'address' => $goodList['address'] ?? '',
//                'company_id' => $goodList['company_id'] ?? 0,
//                'count' => $goodList['count'] ?? 0,
//                'create_time' => $goodList['create_time'] ?? '',
//                'data' => $groupedData,
//                'summary' => [
//                    'totalTray' => $totalTray,
//                    'totalBox' => $totalBox,
//                    'totalTao' => $totalTao,
//                    'totalZhang' => $totalZhang,
//                    'totalGe' => $totalGe,
//                    'products' => $productSummary
//                ],
//                // 其他字段保持不变
//                'delete_time' => $goodList['delete_time'] ?? '',
//                'deliveryman' => $goodList['deliveryman'] ?? '',
//                'export_id' => $goodList['export_id'] ?? '',
//                'note' => $goodList['note'] ?? '',
//                'order_ddbh' => $goodList['order_ddbh'] ?? '',
//                'plate_number' => $goodList['plate_number'] ?? '',
//                'qrcode_add' => $goodList['qrcode_add'] ?? '',
//                'shr_phone' => $goodList['shr_phone'] ?? '',
//                'status' => $goodList['status'] ?? 0,
//                'supplier_id' => $goodList['supplier_id'] ?? 0,
//                'supplier_name' => $goodList['supplier_name'] ?? '',
//                'sync_flag' => $goodList['sync_flag'] ?? 0,
//                'user_id' => $goodList['user_id'] ?? 0
//            ];
//
//            return json([
//                'code' => 1,
//                'data' => $responseData
//            ]);
//
//        } catch (\Exception $e) {
//            return json([
//                'code' => 0,
//                'msg' => '系统错误: ' . $e->getMessage()
//            ]);
//        }
//    }
//    public function printqrcode()
//    {
//        // 1. 验证请求类型
//        if (!$this->request->isAjax()) {
//            return json(['code' => 0, 'msg' => '请求错误']);
//        }
//
//        try {
//            // 2. 初始化数据库连接
//            $mongo = \think\Db::connect('mongodb');
//            $userinfo = Session::get('admin');
//
//            if (empty($userinfo) || empty($userinfo['company'])) {
//                return json(['code' => 0, 'msg' => '用户信息获取失败']);
//            }
//
//            // 3. 设置集合名称
//            $goodsCollection = '_qcode_goods';
//            $bachCollection = $userinfo['company'] . '_qcode_bach';
//            $bachsummaryCollection = $userinfo['company'] . '_qcode_bachsummary';
//
//            // 4. 获取请求参数
//            $id = input('id');
//            if (empty($id)) {
//                return json(['code' => 0, 'msg' => 'ID不能为空']);
//            }
//
//            // 5. 查询发货单信息
//            $goodList = $mongo->name($goodsCollection)
//                ->where('_id', $id)
//                ->find();
//
//            if (empty($goodList)) {
//                return json(['code' => 0, 'msg' => '未找到发货单数据']);
//            }
//
//            // 6. 检查是否需要查询批次数据（根据您的数据结构，可能已包含在data字段）
//            if (isset($goodList['data']) && is_array($goodList['data'])) {
//                // 如果goods数据中已包含批次数据，直接使用
//                $detailData = $goodList['data'];
//            } else {
//                // 否则执行原有查询逻辑
//                if (empty($goodList['qcode_bachsummary_id'])) {
//                    return json(['code' => 0, 'msg' => '发货单缺少批次汇总ID']);
//                }
//
//                // 查询批次汇总数据
//                $bachsummaryData = $mongo->name($bachsummaryCollection)
//                    ->where('_id', $goodList['qcode_bachsummary_id'])
//                    ->find();
//
//                if (empty($bachsummaryData)) {
//                    return json(['code' => 0, 'msg' => '未找到对应的批次汇总数据']);
//                }
//
//                // 查询批次明细数据
//                $detailData = $mongo->name($bachCollection)
//                    ->where('bach_ids', $bachsummaryData['bach_ids'])
//                    ->select();
//            }
//
//            // 7. 构造返回数据（完全匹配您提供的格式）
//            $responseData = [
//                '_id' => $goodList['_id'],
//                'shrq_date' => date('Y-m-d'),
//                'shdh' => $goodList['shdh'] ?? '',
//                'order_number' => $goodList['order_number'] ?? '',
//                'address' => $goodList['address'] ?? '',
//                'company_id' => $goodList['company_id'] ?? 0,
//                'count' => $goodList['count'] ?? 0,
//                'create_time' => $goodList['create_time'] ?? '',
//                'data' => $detailData,  // 批次明细数据
//                'delete_time' => $goodList['delete_time'] ?? '',
//                'deliveryman' => $goodList['deliveryman'] ?? '',
//                'export_id' => $goodList['export_id'] ?? '',
//                'note' => $goodList['note'] ?? '',
//                'order_ddbh' => $goodList['order_ddbh'] ?? '',
//                'plate_number' => $goodList['plate_number'] ?? '',
//                'qrcode_add' => $goodList['qrcode_add'] ?? '',
//                'shr_phone' => $goodList['shr_phone'] ?? '',
//                'status' => $goodList['status'] ?? 0,
//                'supplier_id' => $goodList['supplier_id'] ?? 0,
//                'supplier_name' => $goodList['supplier_name'] ?? '',
//                'sync_flag' => $goodList['sync_flag'] ?? 0,
//                'user_id' => $goodList['user_id'] ?? 0
//            ];
//echo "
";
//print_r($responseData);
//echo "
";die;
//            return json([
//                'code' => 1,
//                'data' => $responseData
//            ]);
//
//        } catch (\Exception $e) {
//            // 异常处理
//            return json([
//                'code' => 0,
//                'msg' => '系统错误: ' . $e->getMessage()
//            ]);
//        }
//    }

//    public function printqrcode()
//    {
//        $goods = new QcodeGoods();
//        $export = new QcodeExport();
//        $large = new QcodeLarge();
//        $bach  = new QcodeBach();
//        $userinfo = Session::get('admin');
//
//        if ($this->request->isAjax() === false) {
//            $this->error('请求错误');
//        }
//
//        $id = input('id');
//        $good_list = $goods->where('_id', $id)->find();
//
//        if ($good_list) {
//            if (strpos($good_list['export_id'], ',') === false) {
//                $export_id[0] = $good_list['export_id'];
//            } else {
//                $export_id = explode(',', $good_list['export_id']);
//            }
//
//            $data = [];
//            $motter_nos = []; // 用于存储 motter_no 字段
//
//            foreach ($export_id as $k => $v) {
//                $data[$k] = $export->where('_id', $v)->find();
//                // 确保 $data[$k] 是一个有效的对象
//                if ($data[$k] instanceof QcodeExport) {
//                    if (!empty($data[$k]['order_ddbh'])) {
//                        $motter_nos[] = $data[$k]['order_ddbh'];
//                    }
//                }
//
//                $large_str = explode(',', $data[$k]['large_str']);
//                $large_list = $large->name($userinfo['company'] . '_' . 'qcode_large')->whereIn('_id', $large_str)->select();
//                $large_num = $large_weight = 0;
//
//                foreach ($large_list as $value) {
//                    $bach_detail = $bach->name($userinfo['company'].'_qcode_bach')->where('_id', $value['bach_id'])->find();
//
//                    $num = (int)$bach_detail['num'];                      // 总张数
//                    $small_num = (int)$bach_detail['small_num'];          // 每箱张数
//                    $boxes_per_pallet = (int)$bach_detail['total_boxes']; // 每托箱数
//
//                    // 重新计算总箱数
//                    $larger_num = (int)ceil($num / $small_num);
//
//                    // 当前批次对应的总托数
//                    $full_pallets = floor($larger_num / $boxes_per_pallet);
//                    $last_pallet_boxes = $larger_num % $boxes_per_pallet;
//                    $total_pallets = $full_pallets + ($last_pallet_boxes > 0 ? 1 : 0);
//
//                    // 当前是第几托（code中解析）
//                    $current_flow_str = substr($value['code'], 53, 6);
//                    $current_flow = (int) ltrim($current_flow_str, '0');
//                    $total_pallets = (int) $total_pallets;
//
//                    // 是否是最后一托
//                    $is_last = ($current_flow === $total_pallets) ? 1 : 0;
//
//                    // 修正箱数
//                    $data[$k]['larger_num'] = $boxes_per_pallet;
//                    if ($is_last && $last_pallet_boxes > 0) {
//                        $data[$k]['larger_num'] = $last_pallet_boxes;
//                    }
//
//                    $data[$k]['l_num'] += $value['l_num']; // 累加数量
//                    $data[$k]['l_weight'] += $value['l_weight']; // 累加重量
//                }
//
//                // 更新数据
////                $data[$k]['l_num'] = $large_num / 10000; // 转换数量
////                $data[$k]['l_weight'] = $large_weight; // 更新重量
//
//                // 添加 motter_no 到数组
//                if (!empty($data[$k]['order_ddbh'])) {
//                    $order_ddbh[] = $data[$k]['order_ddbh'];
//                }
//
//                $bach_record = $bach->name($userinfo['company'] . '_' . 'qcode_bach')->where([
//                    'order_ddbh'   => $data[$k]['order_ddbh'],
//                    'matter_no'    => $data[$k]['matter_no'],
//                    'matter_name'  => $data[$k]['matter_name'],
//                ])->find();
//
//
//                //计算当前总箱数
//                $bach_id = (string)$bach_record['_id'];
//                $qcode_large = $bach->name($userinfo['company'] . '_' . 'qcode_large')->where([
//                    'bach_id'   => $bach_id,
//                    'l_status'  => 1,
//                ])->count();
//
//                $tuo_count = $bach_record['total_boxes'] * $qcode_large;
//
//                if ($bach_record) {
//                    $data[$k]['QcodeBach_num'] =  $tuo_count * $bach_record['small_num'];
//                    $data[$k]['QcodeBach_danwei'] = $bach_record['danwei'];
//                    $data[$k]['QcodeBach_small_num'] = $bach_record['small_num'];
//                    $data[$k]['larger_num'] = $tuo_count;
//                } else {
//                    $data[$k]['QcodeBach_num'] = 0;
//                }
//            }
//
//            // 拼接 motter_no 字段
//            $good_list['order_ddbh'] = implode(',', $order_ddbh);
//
//            // 继续处理其他数据
//            $good_list['address'] = $userinfo['company_address'];
//            $good_list['data'] = $data;
//            $good_list['count'] = count($data);
//            $good_list['shrq_date'] = substr($good_list['create_time'], 0, 10);
//
//            if (empty($good_list['qrcode_add'])) {
//                $good_list['qrcode_add'] = $this->Qrcode($good_list['shdh']);
//                $goods->where('_id', $id)->update(['qrcode_add' => $good_list['qrcode_add']]);
//            }
//
//            if ($good_list['note'] === 'NULL') {
//                $good_list['note'] = '';
//            }
//
//            // 新增代码
//            $good_array = $good_list ? $good_list->toArray() : [];
//            $dataList = $good_array['data'] ?? [];
//
//            // 步骤1：按照 create_time 升序排序
//            usort($dataList, function ($a, $b) {
//                return strtotime($a['create_time']) - strtotime($b['create_time']);
//            });
//
//            // 步骤2：添加 large_ber 字段
//            $start = 1;
//            foreach ($dataList as &$item) {
//                $count = intval($item['large_num']);
//                $end = $start + $count - 1;
//                $item['large_ber'] = ($start === $end) ? (string)$start : "$start-$end";
//                $start = $end + 1;
//            }
//            unset($item);
//echo "
";
//print_r($dataList);
//echo "
";
//            $good_list['data'] = $dataList;
//            return json(['code' => 1, 'data' => $good_list]);
//        }
//    }

//    public function printqrcode()
//    {
//        $goods = new QcodeGoods();
//        $export = new QcodeExport();
//        $large = new QcodeLarge();
//        $userinfo = Session::get('admin');
//        if ($this->request->isAjax() === false) {
//            $this->error('请求错误');
//        }
//        $id = input('id');
//        $good_list = $goods->where('_id',$id)->find();
//
//        if ($good_list){
//            if (strpos($good_list['export_id'],',') === false){
//                $export_id[0] = $good_list['export_id'];
//            }else{
//                $export_id = explode(',',$good_list['export_id']);
//            }
//            $data = [];
//            foreach ($export_id as $k=>$v){
//                $data[$k] = $export->where('_id',$v)->find();
//                $large_str = explode(',',$data[$k]['large_str']);
//                $large_list = $large->name($userinfo['company'].'_'.'qcode_large')->whereIn('_id',$large_str)->select();
//                $large_num = $large_weight = 0;
//                foreach ($large_list as $value){
//                    $large_num = $large_num + $value['l_num'];
//                    $large_weight = $large_weight + $value['l_weight'];
//                }
//                $data[$k]['l_num'] = $large_num/10000;
//                $data[$k]['l_weight'] = $large_weight;
//            }
//            $good_list['address'] = $userinfo['company_address'];
//            $good_list['data'] = $data;
//            $good_list['count'] = count($data);
//            $good_list['shrq_date'] = substr($good_list['create_time'],0,10) ;
//            if (empty($good_list['qrcode_add'])){
//                $good_list['qrcode_add'] = $this->Qrcode($good_list['shdh']);
//                $goods->where('_id',$id)->update(['qrcode_add'=>$good_list['qrcode_add']]);
//            }
//            if ($good_list['note'] == 'NULL'){
//                $good_list['note'] = '';
//            }
//
//            //新增代码
//            $good_array = $good_list ? $good_list->toArray() : [];
//            // 假设 $goodArray 是已经转为普通数组的结构
//            $dataList = $good_array['data'] ?? [];
//            // 步骤1：按照 create_time 升序排序
//            usort($dataList, function ($a, $b) {
//                return strtotime($a['create_time']) - strtotime($b['create_time']);
//            });
//            // 步骤2：添加 large_ber 字段
//            $start = 1;
//            foreach ($dataList as &$item) {
//                $count = intval($item['large_num']);
//                $end = $start + $count - 1;
//                $item['large_ber'] = ($start === $end) ? (string)$start : "$start-$end";
//                $start = $end + 1;
//            }
//            unset($item);
//            $good_list['data'] = $dataList;
//
//            return json(['code'=>1,'data'=>$good_list]);
//        }
//    }

    /**
     * 获取辅料名称
     * @return \think\response\Json
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function matterName()
    {
//        $userinfo = Session::get('admin');
//        $lager = new QcodeLarge();
//        $bach = new QcodeBach();
//        $bach_id = $lager->name($userinfo['company'].'_'.'qcode_large')->where('delete_time','')->column('bach_id');
//        $matter_name = [];
//        if (!empty($bach_id)){
//            foreach ($bach_id as $v){
//                $bach_list = $bach->name($userinfo['company'].'_'.'qcode_bach')->where('_id',$v)->find();
//                $matter_name[$bach_list['matter_no']] = $bach_list['matter_name'];
//            }
//        }
//        $matter_name = array_unique($matter_name);
//        return json($matter_name);
    }

    /**
     * 发货单删除
     * @param $ids
     * @return void
     */
    public function dispatch_del($ids)
    {
        $goods = new QcodeGoods();
        $export = new QcodeExport();
        if (empty($ids)){
            $this->error('参数错误');
        }
        $res = $goods->where('_id',$ids)->update(['delete_time'=>date('Y-m-d H:i:s',time())]);
        if ($res === false){
            $this->error('删除失败');
        }
        $userinfo = Session::get('admin');
        $mongo = \think\Db::connect('mongodb');
        $collection = $userinfo['company'] . '_qcode_bach';
        $bachsummary = $userinfo['company'] . '_qcode_bachsummary';
        $res_find = $goods->where('_id',$ids)->find();
        $update_status = $mongo->name($bachsummary)->where('_id',$res_find['qcode_bachsummary_id'])->update(
            [
                'bach_status'=>0,
                'delete_time' => ''
            ]);
        if ($update_status === false){
            $this->error('删除失败');
        }
//        $export_list = $goods->where('_id',$ids)->find();
//        $export_id = explode(',',$export_list['export_id']);
//        foreach ($export_id as $v){
//            $result = $export->where('_id',$v)->update(['status'=>0]);
//            if ($result === false){
//                $this->error('删除失败');
//            }
//        }

        $this->success('成功');
    }

    /**
     * 收货列表
     */
    public function receive()
    {
        //当前是否为关联查询
        $this->relationSearch = false;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            $where = [
                'delete_time'=> ''
            ];

            $req = input();
            $req['sort'] == 'id' ? $sort = '_id' : $sort = $req['sort'];
            $order = $req['order'];
            $offset = $req['offset'];
            $limit = $req['limit'];

            // 构造模糊查询条件
//            $regex = new MongoDB\BSON\Regex('.*abc.*', 'i');
//            $filter = ['field' => $regex];

            $filter = json_decode($req['filter'], true);
            if (isset($filter['status'])){
                $where['status'] = intval($filter['status']);
                unset($filter['status']);
            }
            if (isset($filter['create_time'])){
                $begin = substr($filter['create_time'],0,19);
                $end = substr($filter['create_time'],22);
                $begin = strtotime($begin);
                $end = strtotime($end);
                $where['create_time'] = ['between',[$begin,$end]];
                unset($filter['create_time']);
            }
            foreach ($filter as $k => $v){
                $where[$k] = new \MongoDB\BSON\Regex($v);
            }

            $goods = new QcodeGoods();
            $total = $goods->where($where)->count();
            $list = $goods->where($where)
                ->order($sort,$order)
                ->limit($limit)
                ->skip($offset)
                ->select();
            foreach ($list as $k=>$v) {
                $oid = $v['_id']->jsonSerialize();
                $list[$k]['id'] = $oid['$oid'];
            }

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

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

    /**
     * 扫码/输入收货
     */
    public function receive_add()
    {
        $req = $this->request->param();
        if(!isset($req['shdh']) || empty($req['shdh'])){
            $this->error('请输入送货单号');
        }
        $data = [
            'shdh'=>$req['shdh'],
            'delete_time'=>'',
        ];
        $goods = new QcodeGoods();
        $row = $goods->where($data)->find();
        if (!$row) $this->error('未查询到该单号');

        if ($row['status']==2) $this->error('该单号已收货');

        //收货---修改status为2
        $bool = $goods->where($data)->update(['status'=>2,'sync_flag'=>0]);
        if ($bool){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 取消收货
     */
    public function receive_del()
    {
        $req = $this->request->param();

        if(!isset($req['ids']) || empty($req['ids'])){
            $this->error('id不能为空');
        }
        $data = [
            '_id'=>$req['ids'],
            'delete_time'=>'',
        ];
        $goods = new QcodeGoods();

        //收货---修改status为2
        $bool = $goods->where($data)->update(['status'=>0,'sync_flag'=>0]);
        if ($bool){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }
}