mes-sdai-server-api/application/api/controller/WorkOrderSpotCheck.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use \think\Request;
use \think\Db;
use const http\Client\Curl\IPRESOLVE_V4;

class WorkOrderSpotCheck extends Api{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];
    /**
     * 首页
     */
    public function index() {
        $this->success('请求成功');
    }

    /**
     * 报工查询
     *
     */
    public function getList() {
        // 判断请求是否为 GET 请求
        if (!$this->request->isGet()) {
            $this->error('请求方式错误');
        }
        $params = $this->request->param();
        // 校验参数是否存在且不为空
        $requiredParams = ['order', 'code'];
        foreach ($requiredParams as $param) {
            if (!isset($params[$param]) || empty($params[$param])) {
                $this->error("$param 参数错误");
            }
        }
        // 如果订单编号没有 'DC' 前缀，自动添加 'DC'
        if (strpos($params['order'], 'DC') !== 0) {
            $params['order'] = 'DC' . $params['order'];
        }
        $order = $params['order'];

        // 根据不同的 code 值执行不同的逻辑
        switch ($params['code']) {
            case '裁剪':
                //订单编号
                $ddh = explode('-', $order)[0];

                //查询未出库的记录，若存在则进行批量出库和日志记录
                $data = \db('工单_印件资料')
                    ->where(['子订单编号' => $order, 'ck_rq' => null])
                    ->find();

                if ($data) {
                    // 检查并更新工单_基本资料表的出库日期
                    $sql = \db('工单_基本资料')
                        ->where('订单编号', $ddh)
                        ->whereNull('出库日期')
                        ->fetchSql(true)
                        ->update(['出库日期' => date("Y-m-d H:i:s")]);
                    \db()->query($sql);

                    // 更新工单_印件资料表的出库日期
                    $sql = \db('工单_印件资料')
                        ->where('子订单编号', $order)
                        ->whereNull('Mod_rq')
                        ->whereNull('ck_rq')
                        ->fetchSql(true)
                        ->update(['ck_rq' => date("Y-m-d H:i:s")]);
                    \db()->query($sql);

                }


                //查询子订单编号对应数据
                if (strpos($order, '-') !== false) {
                    //判断 $order -后面是否是两位
                    if (preg_match('/-(\d{2})$/', $order, $matches)) {
                        $number = (int)$matches[1];
                        //船样单子为：订单编号-90~99
                        if ($number > 70) {
                            $data = \db('工单_基本资料')->alias('j')
                                ->distinct('y.子订单编号')
                                ->field('
                                y.订单编号, y.子订单编号, y.款号, j.款式, y.颜色, 
                                y.zdtotal, y.sctotal, j.单位, y.Sys_id, y.Sys_rq, 
                                y.UniqId, y.sc_rq, y.颜色备注, y.color_id,y.船样,
                                y.cm1, y.cm2, y.cm3, y.cm4, y.cm5, y.cm6, y.cm7, y.cm8, y.cm9, y.cm10,
                                y.cmsl1, y.cmsl2, y.cmsl3, y.cmsl4, y.cmsl5, y.cmsl6, y.cmsl7, y.cmsl8, y.cmsl9, y.cmsl10,
                                y.scsl1, y.scsl2, y.scsl3, y.scsl4, y.scsl5, y.scsl6, y.scsl7, y.scsl8, y.scsl9, y.scsl10'
                                )
                                ->join('工单_印件资料 y', 'j.订单编号 = y.订单编号', 'left')
                                ->where('y.船样',1)
                                ->where(function($query) {
                                    $query->whereNull('y.Mod_rq')->whereOr('y.Mod_rq', '');
                                }) // 查询未删除数据
                                ->where('y.子订单编号', $order)
                                ->select();
                        } else {
                            //获取原始子订单编号【-01】后期不需要else中代码可以删除掉
                            //【查询尺码、制单数、填写报工新增实裁数】
                            $data = \db('工单_基本资料')->alias('j')
                                ->distinct('y.子订单编号')
                                ->field('
                                y.订单编号, y.子订单编号, y.款号, j.款式, y.颜色, 
                                y.zdtotal, y.sctotal, j.单位, y.Sys_id, y.Sys_rq, 
                                y.UniqId, y.sc_rq, y.颜色备注, y.color_id,y.船样,
                                y.cm1, y.cm2, y.cm3, y.cm4, y.cm5, y.cm6, y.cm7, y.cm8, y.cm9, y.cm10,
                                y.cmsl1, y.cmsl2, y.cmsl3, y.cmsl4, y.cmsl5, y.cmsl6, y.cmsl7, y.cmsl8, y.cmsl9, y.cmsl10,
                                y.scsl1, y.scsl2, y.scsl3, y.scsl4, y.scsl5, y.scsl6, y.scsl7, y.scsl8, y.scsl9, y.scsl10'
                                )
                                ->join('工单_印件资料 y', 'j.订单编号 = y.订单编号', 'left')
                                ->where('y.船样',0)
                                ->where(function($query) {
                                    $query->whereNull('y.Mod_rq')->whereOr('y.Mod_rq', '');
                                }) // 查询未删除数据
                                ->where('y.子订单编号', 'like', '%' . $ddh . '%')
                                ->select();
                        }
                    }else{
//                        $ddbh = explode('-', $order)[0];//获取订单编号
                        //【查询尺码、制单数、填写报工新增实裁数】
                        $data = \db('工单_基本资料')->alias('j')
                            ->distinct('y.子订单编号')
                            ->field('
                                y.订单编号, y.子订单编号, y.款号, j.款式, y.颜色, 
                                y.zdtotal, y.sctotal, j.单位, y.Sys_id, y.Sys_rq, 
                                y.UniqId, y.sc_rq, y.颜色备注, y.color_id,y.船样,
                                y.cm1, y.cm2, y.cm3, y.cm4, y.cm5, y.cm6, y.cm7, y.cm8, y.cm9, y.cm10,
                                y.cmsl1, y.cmsl2, y.cmsl3, y.cmsl4, y.cmsl5, y.cmsl6, y.cmsl7, y.cmsl8, y.cmsl9, y.cmsl10,
                                y.scsl1, y.scsl2, y.scsl3, y.scsl4, y.scsl5, y.scsl6, y.scsl7, y.scsl8, y.scsl9, y.scsl10'
                            )
                            ->join('工单_印件资料 y', 'j.订单编号 = y.订单编号', 'left')
                            ->where('y.船样',0)
                            ->where(function($query) {
                                $query->whereNull('y.Mod_rq')->whereOr('y.Mod_rq', '');
                            }) // 查询未删除数据
                            ->where('y.订单编号', 'like', '%' . $ddh . '%')
                            ->select();
                    }

                    $dataEntry = [];
                    $list = [];
                    $headers = [];//存放尺码表头
                    foreach ($data as $item) {
                        // 初始化尺码与数量映射数组
                        $cmScslMapping = [];
                        for ($i = 1; $i <= 10; $i++) {
                            $cmValue = $item['cm' . $i];
                            $scslValue = $item['scsl' . $i];
                            if (!is_null($cmValue) && $cmValue !== 0) {
                                $cmScslMapping[$cmValue] = ($scslValue === 0 || is_null($scslValue)) ? '' : $scslValue;
                                if (!in_array($cmValue, $headers)) {
                                    $headers[] = $cmValue;
                                }
                            }
                        }

                        // 将尺码数据平铺到主要数据中（表格数据）
                        $orderData = [
                            '订单编号' => $item['订单编号'],
                            '子订单编号' => $item['子订单编号'],
                            '款号' => $item['款号'],
                            '款式' => $item['款式'],
                            '颜色' => $item['颜色备注'],
                            'zdtotal' => $item['zdtotal'],
                            'sctotal' => $item['sctotal'],
                            '单位' => $item['单位'],
                            'Sys_id' => $item['Sys_id'],
                            'Sys_rq' => $item['Sys_rq'],
                        ];
                        // 平铺尺码映射数据
                        $orderData = array_merge($orderData, $cmScslMapping);
                        $dataEntry[] = $orderData;
                        // list 列表部分
                        $entry = [];
                        for ($i = 1; $i <= 10; $i++) {
                            $entry['cm' . $i] = ($item['cm' . $i] === 0 || is_null($item['cm' . $i])) ? '' : $item['cm' . $i];
                            $entry['cmsl' . $i] = ($item['cmsl' . $i] === 0 || is_null($item['cmsl' . $i])) ? '' : $item['cmsl' . $i];
                            $entry['scsl' . $i] = ($item['scsl' . $i] === 0 || is_null($item['scsl' . $i])) ? '' : $item['scsl' . $i];
                        }
                        $entry['订单编号'] = $item['订单编号'];
                        $entry['子订单编号'] = $item['子订单编号'];
                        $entry['UniqId'] = $item['UniqId'];
                        $entry['zdtotal'] = $item['zdtotal'];
                        $entry['颜色'] = $item['颜色'];
                        $entry['款式'] = $item['款式'];
                        $entry['款号'] = $item['款号'];
                        $entry['color_id'] = $item['color_id'];
                        $entry['颜色备注'] = $item['颜色备注'];
                        $list[] = $entry;
                    }
                    //打印当前订单所有尺码数据
//                    echo "<pre>";print_r($list);echo "<pre>";die;

//                    // 合并子订单
//                    $merged = [];
//                    foreach ($list as $item) {
//                        $key = $item['子订单编号'];
//                        // 生成合并的唯一键，以 color_id 和 颜色备注 为依据
//                        $mergeKey = $item['color_id'] . '-' . $item['颜色备注'];
//                        if (!isset($merged[$mergeKey])) {
//                            // 如果不存在，则初始化
//                            $merged[$mergeKey] = $item;
//                        } else {
//                            // 如果已经存在，则合并数量
//                            for ($i = 1; $i <= 10; $i++) {
//                                $sizeKey = 'cm' . $i;
//                                $qtyKey = 'cmsl' . $i;
//                                if (!empty($item[$sizeKey]) && $item[$sizeKey] === $merged[$mergeKey][$sizeKey]) {
//                                    $merged[$mergeKey][$qtyKey] = (int)$merged[$mergeKey][$qtyKey] + (int)$item[$qtyKey];
//                                }
//                            }
//                            // 累加总数量等字段
//                            $merged[$mergeKey]['zdtotal'] += $item['zdtotal'];
//                        }
//                    }
                    // 重置索引为连续数字索引
//                    $mergeds = array_values($merged);

                    // 创建新的合并子订单列表
                    $finalMerged = [];
                    foreach ($list as $mergedItem) {
                        $colorId = $mergedItem['color_id'];
                        // 查找原始列表中具有相同 color_id 的子订单编号
                        foreach ($list as $item) {
                            if ($item['color_id'] === $colorId) {
                                // 复制合并后的数据，并替换子订单编号
                                $newMergedItem = $mergedItem;
                                $newMergedItem['子订单编号'] = $item['子订单编号'];
                                $finalMerged[] = $newMergedItem;
                            }
                        }
                    }
//                    echo "<pre>";
//                    print_r($finalMerged);
//                    echo "</pre>";
//                    die;
                    // 在 $mergeds 中查找匹配的子订单编号 对应的一条数据
                    $matchedOrder = null;
                    foreach ($list as $mergedOrder) {
                        if ($mergedOrder['子订单编号'] === $order) {
                            $matchedOrder = $mergedOrder;
                            break; // 找到后可以退出循环
                        }
                    }

//                    $matchedOrder = null;
//                    foreach ($finalMerged as $mergedOrder) {
//                        if ($mergedOrder['子订单编号'] === $order) {
//                            $matchedOrder = $mergedOrder;
//                            break; // 找到后可以退出循环
//                        }
//                    }
//                    echo "<pre>";print_r($matchedOrder);echo "</pre>";die;



//                    // 合并子订单
//                    $merged = [];
//                    foreach ($list as $item) {
//                        $key = $item['子订单编号'];
//                        // 生成合并的唯一键，以 color_id 和 颜色备注 为依据
//                        $mergeKey = $item['color_id'] . '-' . $item['颜色备注'];
//                        if (!isset($merged[$mergeKey])) {
//                            // 如果不存在，则初始化
//                            $merged[$mergeKey] = $item;
//                        } else {
//                            // 如果已经存在，则合并数量
//                            for ($i = 1; $i <= 10; $i++) {
//                                $sizeKey = 'cm' . $i;
//                                $qtyKey = 'cmsl' . $i;
//                                if (!empty($item[$sizeKey]) && $item[$sizeKey] === $merged[$mergeKey][$sizeKey]) {
//                                    $merged[$mergeKey][$qtyKey] = (int)$merged[$mergeKey][$qtyKey] + (int)$item[$qtyKey];
//                                }
//                            }
//                            // 也可以累加其他字段，如总数量等
//                            $merged[$mergeKey]['zdtotal'] += $item['zdtotal'];
//                        }
//                    }
//                    $mergeds = array_values($merged); // 重置索引为连续数字索引
//                    //打印输出合并后订单数据
//                    echo "<pre>";print_r($mergeds);echo "</pre>";die;
//
//                    // 在 $mergeds 中查找匹配的子订单编号 对应的一条数据
//                    $matchedOrder = null;
//                    foreach ($mergeds as $mergedOrder) {
//                        if ($mergedOrder['子订单编号'] === $order) {
//                            $matchedOrder = $mergedOrder;
//                            break; // 找到后可以退出循环
//                        }
//                    }
//                    echo "<pre>";print_r($matchedOrder);echo "</pre>";die;

                    //产量进度汇总记录
                    $rows = db()->table('设备_产量计酬')->alias('c')
//                        ->join('工单_印件资料 y', 'c.订单编号 = y.订单编号', 'left')
                        ->field('c.款号, c.订单编号, c.子订单编号, c.sys_rq as 上报时间, c.尺码, c.数量')
                        ->where([
                            'c.子订单编号' => $params['order'],
                            'c.mod_rq' => null,
                            'c.工序名称' => $params['code']
                        ])
                        ->select();
                    $formattedRows = [];
                    foreach ($rows as $item) {
                        if (!empty($item['尺码'])) {
                            $key = $item['款号'];
                            if (!isset($formattedRows[$key])) {
                                $formattedRows[$key] = [
                                    '订单编号' => $item['订单编号'],
                                    '款号' => $item['款号'],
                                    '上报时间' => $item['上报时间'],
                                    '子订单编号' => $item['子订单编号'],
                                    '颜色' => $list[0]['颜色备注'],
                                    '裁剪数' => 0
                                ];
                            }
                            // 累加尺码数量
                            if (isset($formattedRows[$key][$item['尺码']])) {
                                $formattedRows[$key][$item['尺码']] += $item['数量'];
                            } else {
                                $formattedRows[$key][$item['尺码']] = $item['数量'];
                            }
                            // 累加当前尺码的数量【裁剪数】
                            $formattedRows[$key]['裁剪数'] += $item['数量'];
                        }
                    }
                    //重置索引为连续数字索引
                    $finalResult = array_values($formattedRows);

                    // 报工历史记录
                    $existingRecords = \db('设备_产量计酬')->alias('c')
                        ->field('
                             c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.数量, c.sczl_jtbh,
                             c.尾包,c.UniqId,c.ci_num,c.s_num,c.sys_rq, c.serial, 
                             j.款式,
                             y.zdtotal, y.sctotal, y.颜色,y.颜色备注
                             ')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where('c.子订单编号', $params['order'])
                        ->where('c.工序名称', $params['code'])
//                        ->where('c.sczl_jtbh', $params['sys_sbID'])
                        ->whereNull('c.mod_rq') // 查询未删除数据
                        ->where(function($query) {
                            $query->whereNotNull('y.ck_rq')->where('y.ck_rq', '<>', '');
                        }) // 查询出库数据
                        ->order('c.UniqId', 'desc')
                        ->distinct('c.子订单编号')
                        ->select();
                    $sizeSummary = [];
                    $sizes = [];
                    foreach ($existingRecords as $record) {
                        $size = $record['尺码'];
                        $quantity = $record['数量'];
                        $serial = $record['serial'];
                        // 如果尺码还没有出现过，加入尺码列表
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        if (!isset($sizeSummary[$record['UniqId']])) {
                            $sizeSummary[$record['UniqId']] = [
                                'UniqId' => $record['UniqId'],
                                '订单编号' => $record['订单编号'],
                                '子订单编号' => $record['子订单编号'],
                                '上报数量' => $record['s_num'],
                                '剩余数量' => $record['ci_num'],
                                '次品数量' => $record['数量'] - $record['ci_num'],
                                '生产款号' => $record['款号'],
                                '尺码' => $record['尺码'],
                                '工序编号' => $record['工序编号'],
                                '工序名称' => $record['工序名称'],
                                '数量' => $quantity,
                                '尾包' => $record['尾包'] == 1 ? '是' : '否',
                                '颜色' => $record['颜色备注'],
                                '组别' => $record['sczl_jtbh'],
                                '款式' => $record['款式'],
                                'serial' => '第('.$serial.')包',
                                'sys_rq' => $record['sys_rq']
                            ];
                        }
                    }
                    // 将 $sizeSummary 转换为索引数组
                    $sizeSummary = array_values($sizeSummary);
                    // 对 $sizeSummary 按 sys_rq 降序排序
                    usort($sizeSummary, function ($a, $b) {
                        return strtotime($b['UniqId']) - strtotime($a['UniqId']);
                    });
                    $result = [
                        'list' => $matchedOrder,
                        'headers' => $headers,
                        'table' => $finalResult,
                        'bgtable' => $existingRecords
                    ];
                }else {
                    //查询订单编号对应的数据
                    $data = \db('工单_基本资料')->alias('j')
                        ->distinct('y.子订单编号')
                        ->field('
                                y.订单编号, y.子订单编号, y.款号, j.款式, y.颜色, 
                                y.zdtotal, y.sctotal, j.单位, y.Sys_id, y.Sys_rq, 
                                y.UniqId, y.sc_rq, y.颜色备注, y.color_id,y.船样,
                                y.cm1, y.cm2, y.cm3, y.cm4, y.cm5, y.cm6, y.cm7, y.cm8, y.cm9, y.cm10,
                                y.cmsl1, y.cmsl2, y.cmsl3, y.cmsl4, y.cmsl5, y.cmsl6, y.cmsl7, y.cmsl8, y.cmsl9, y.cmsl10,
                                y.scsl1, y.scsl2, y.scsl3, y.scsl4, y.scsl5, y.scsl6, y.scsl7, y.scsl8, y.scsl9, y.scsl10'
                        )
                        ->join('工单_印件资料 y', 'j.订单编号 = y.订单编号', 'left')
//                        ->where('y.船样',1)
                        ->where(function($query) {
                            $query->whereNull('y.Mod_rq')->whereOr('y.Mod_rq', '');
                        }) // 查询未删除数据
//                            ->where($where)
                        ->where('y.订单编号', 'like', '%' . $order . '%')
                        ->select();

                    $headers = [];//存放尺码表头
                    foreach ($data as $item) {
                        // 初始化尺码与数量映射数组
                        $cmScslMapping = [];
                        for ($i = 1; $i <= 10; $i++) {
                            $cmValue = $item['cm' . $i];
                            $scslValue = $item['scsl' . $i];
                            if (!is_null($cmValue) && $cmValue !== 0) {
                                $cmScslMapping[$cmValue] = ($scslValue === 0 || is_null($scslValue)) ? '' : $scslValue;
                                if (!in_array($cmValue, $headers)) {
                                    $headers[] = $cmValue;
                                }
                            }
                        }
                    }

                    //【查询产量计酬历史记录】
                    $where['c.订单编号'] = ['like','%'.explode('C',$order)[1].'%'];
                    $where['c.工序名称'] = $params['code'];
                    $rows = db()->table('设备_产量计酬')->alias('c')
                        ->field('c.款号, c.订单编号, c.子订单编号, c.sys_rq as 上报时间, c.尺码, c.数量')
                        ->where([
                            'c.mod_rq' => null,
//                            'c.订单编号' => $order,
//                            'c.工序名称' => $params['code']
                        ])
                        ->where($where)
                        ->select();
                    $formattedRows = [];
                    foreach ($rows as $item) {
                        if (!empty($item['尺码'])) {
                            $key = $item['上报时间'];
                            if (!isset($formattedRows[$key])) {
                                $formattedRows[$key] = [
                                    '订单编号' => $item['订单编号'],
                                    '款号' => $item['款号'],
                                    '上报时间' => $item['上报时间'],
                                    '子订单编号' => $item['子订单编号'],
                                    '裁剪数' => 0
                                ];
                            }
                            // 累加尺码数量
                            if (isset($formattedRows[$key][$item['尺码']])) {
                                $formattedRows[$key][$item['尺码']] += $item['数量'];
                            } else {
                                $formattedRows[$key][$item['尺码']] = $item['数量'];
                            }
                            // 累加当前尺码的数量【裁剪数】
                            $formattedRows[$key]['裁剪数'] += $item['数量'];
                        }
                    }
                    // 重置索引为连续数字索引
                    $finalResult = array_values($formattedRows);

                    $result = [
                        'table' => $finalResult,
                        'headers' => $headers,
                        'list' => '',
                        'total' => '',
                    ];
                }
                $this->success('请求成功', $result);
                break;
            case '车缝':
                // 查询历史记录并生成尺寸汇总
                function getSizeSummary($order) {
                    $where = [];
                    if (strpos($order, '-') !== false) {
                        $where['c.子订单编号'] = $order;
                    } else {
                        $where['c.订单编号'] = ['like', '%' . $order . '%'];
                    }
                    $where['c.工序编号'] = '3';
                    $where['c.mod_rq'] = null;
                    $existingRecords = \db('设备_产量计酬')->alias('c')
                        ->field('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, 
                         CASE 
                            WHEN c.工序名称 IN ("裁剪", "车缝") THEN c.数量
                            ELSE c.s_num 
                            END as 数量,
                         c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num,c.UniqId,
                                y.zdtotal, y.sctotal, j.款式, y.颜色,y.颜色备注, CAST(c.serial_num AS SIGNED) as serial_num_numeric')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where($where)
                        ->order('c.sys_rq desc')
                        ->group('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.数量, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num, j.款式')
                        ->select();

                    $sizeSummary = [];
                    $sizes = [];
                    foreach ($existingRecords as $record) {
                        $size = $record['尺码'];
                        $quantity = $record['数量'];
                        $serial = $record['serial'];
                        $serialNum = $record['serial_num']; // serial_num 分组
                        $processNumber = $record['工序编号']; // 工序编号
                        // 初始化尺码
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 检查是否已有相同的 serial_num 组合
                        if (!isset($sizeSummary[$serialNum])) {
                            $sizeSummary[$serialNum] = [
                                '订单编号' => $record['订单编号'],
                                '子订单编号' => $record['子订单编号'],
                                '款号' => $record['款号'],
                                '款式' => $record['款式'],
                                '工序编号' => $record['工序编号'],
                                '工序名称' => $record['工序名称'],
                                '数量' => '0', // 记录总数量
                                '尾包' => $record['尾包'] == 1 ? '是' : '否',
                                '颜色' => $record['颜色'],
                                '颜色备注' => $record['颜色备注'],
                                '机台号' => $record['sczl_jtbh'],
                                '组别' => $record['sczl_bh'],
                                'serial' => [], // 流水号数组
                                'sys_rq' => $record['sys_rq'],
                                'UniqId' => $record['UniqId'],
                                '尺码数据' => [] // 用于存储每个尺码对应的流水号和数量
                            ];
                        }

                        // 将流水号添加到 serial 数组
                        $sizeSummary[$serialNum]['serial'][] = $serial;

                        // 累加数量到总数量
                        $sizeSummary[$serialNum]['数量'] += $quantity;

                        // 记录尺码数据
                        if (!isset($sizeSummary[$serialNum]['尺码数据'][$size])) {
                            $sizeSummary[$serialNum]['尺码数据'][$size] = [];
                        }

                        // 添加尺码对应的流水号和数量
                        $sizeSummary[$serialNum]['尺码数据'][$size][] =  $serial . ' (' . $quantity . ')';
                    }

                    // 对每个工序的 serial 进行处理，并转换为逗号分隔的字符串
                    $finalRecords = [];
                    foreach ($sizeSummary as &$summary) {
                        // 将 serial 数组按数值降序排序
                        sort($summary['serial'], SORT_NUMERIC);
                        $summary['serial'] = implode(',', $summary['serial']);

                        // 合并尺码数据到同一层级
                        foreach ($summary['尺码数据'] as $size => $serials) {
                            $summary[$size] = implode(', ', $serials); // 尺码对应的流水号和数量
                        }

                        unset($summary['尺码数据']); // 移除尺码数据数组，直接将数据合并到 summary
                        $finalRecords[] = $summary;
                    }

                    // 尺码排序（数字在前，字母在后）
                    usort($sizes, function ($a, $b) {
                        $sizeOrder = ['XXXS' => 1,'XXS' => 2,'XS' => 3,'S' => 4, 'M' => 5, 'L' => 6, 'XL' => 7, 'XXL' => 8, 'XXXL' => 9, 'XXXXL' => 10];
                        if (is_numeric($a) && is_numeric($b)) return $a - $b;
                        if (is_numeric($a)) return -1;
                        if (is_numeric($b)) return 1;
                        return ($sizeOrder[$a] ?? 100) - ($sizeOrder[$b] ?? 100);
                    });

                    return ['headers' => $sizes, 'records' => $finalRecords];
                }


                if (strpos($order, '-') !== false) {
                    if (!isset($params['sys_sbID']) || empty($params['sys_sbID'])) {
                        $this->error('sys_sbID 参数错误');
                    }

                    if (preg_match('/-(\d{2})$/', $order, $matches)) {
                        $number = (int)$matches[1];
                        if ($number > 70) {
                            //echo '船样';
                            //获取订单编号
//                            $ddbh = explode('-', $order)[0];
                            //1.查询尺码、制单数、填写报工新增实裁数
                            $data = \db('工单_基本资料')->alias('j')
                                ->distinct('y.子订单编号')
                                ->field('
                                y.订单编号, y.子订单编号, y.款号, j.款式, y.颜色, 
                                y.zdtotal, y.sctotal, j.单位, y.Sys_id, y.Sys_rq, 
                                y.UniqId, y.sc_rq, y.颜色备注, y.color_id,y.船样,
                                y.cm1, y.cm2, y.cm3, y.cm4, y.cm5, y.cm6, y.cm7, y.cm8, y.cm9, y.cm10,
                                y.cmsl1, y.cmsl2, y.cmsl3, y.cmsl4, y.cmsl5, y.cmsl6, y.cmsl7, y.cmsl8, y.cmsl9, y.cmsl10,
                                y.scsl1, y.scsl2, y.scsl3, y.scsl4, y.scsl5, y.scsl6, y.scsl7, y.scsl8, y.scsl9, y.scsl10'
                                )
                                ->join('工单_印件资料 y', 'j.订单编号 = y.订单编号', 'left')
                                ->where('y.船样',1)
                                ->where(function($query) {
                                    $query->whereNull('y.Mod_rq')->whereOr('y.Mod_rq', '');
                                }) // 查询未删除数据
                                ->where('y.子订单编号', $order)
                                ->select();
                        } else {
                            //echo '两位数子订单';
                            $ddbh = explode('-', $order)[0];//获取订单编号
                            //【查询尺码、制单数、填写报工新增实裁数】
                            $data = \db('工单_基本资料')->alias('j')
                                ->distinct('y.子订单编号')
                                ->field('
                                y.订单编号, y.子订单编号, y.款号, j.款式, y.颜色, 
                                y.zdtotal, y.sctotal, j.单位, y.Sys_id, y.Sys_rq, 
                                y.UniqId, y.sc_rq, y.颜色备注, y.color_id,y.船样,
                                y.cm1, y.cm2, y.cm3, y.cm4, y.cm5, y.cm6, y.cm7, y.cm8, y.cm9, y.cm10,
                                y.cmsl1, y.cmsl2, y.cmsl3, y.cmsl4, y.cmsl5, y.cmsl6, y.cmsl7, y.cmsl8, y.cmsl9, y.cmsl10,
                                y.scsl1, y.scsl2, y.scsl3, y.scsl4, y.scsl5, y.scsl6, y.scsl7, y.scsl8, y.scsl9, y.scsl10'
                                )
                                ->join('工单_印件资料 y', 'j.订单编号 = y.订单编号', 'left')
                                ->where('y.船样',0)
                                ->where(function($query) {
                                    $query->whereNull('y.Mod_rq')->whereOr('y.Mod_rq', '');
                                }) // 查询未删除数据
                                ->where('y.子订单编号', 'like', '%' . $ddbh . '%')
                                ->select();
                        }
                    }else{
                        $ddbh = explode('-', $order)[0];//获取订单编号
                        //【查询尺码、制单数、填写报工新增实裁数】
                        $data = \db('工单_基本资料')->alias('j')
                            ->distinct('y.子订单编号')
                            ->field('
                                y.订单编号, y.子订单编号, y.款号, j.款式, y.颜色, 
                                y.zdtotal, y.sctotal, j.单位, y.Sys_id, y.Sys_rq, 
                                y.UniqId, y.sc_rq, y.颜色备注, y.color_id,y.船样,
                                y.cm1, y.cm2, y.cm3, y.cm4, y.cm5, y.cm6, y.cm7, y.cm8, y.cm9, y.cm10,
                                y.cmsl1, y.cmsl2, y.cmsl3, y.cmsl4, y.cmsl5, y.cmsl6, y.cmsl7, y.cmsl8, y.cmsl9, y.cmsl10,
                                y.scsl1, y.scsl2, y.scsl3, y.scsl4, y.scsl5, y.scsl6, y.scsl7, y.scsl8, y.scsl9, y.scsl10'
                            )
                            ->join('工单_印件资料 y', 'j.订单编号 = y.订单编号', 'left')
                            ->where('y.船样',0)
                            ->where(function($query) {
                                $query->whereNull('y.Mod_rq')->whereOr('y.Mod_rq', '');
                            }) // 查询未删除数据
                            ->where('y.子订单编号', 'like', '%' . $ddbh . '%')
                            ->select();
                    }

                    $dataEntry = [];
                    $list = [];
                    $headers = [];//存放尺码表头
                    foreach ($data as $item) {
                        // 初始化尺码与数量映射数组
                        $cmScslMapping = [];
                        for ($i = 1; $i <= 10; $i++) {
                            $cmValue = $item['cm' . $i];
                            $scslValue = $item['scsl' . $i];
                            if (!is_null($cmValue) && $cmValue !== 0) {
                                $cmScslMapping[$cmValue] = ($scslValue === 0 || is_null($scslValue)) ? '' : $scslValue;
                                if (!in_array($cmValue, $headers)) {
                                    $headers[] = $cmValue;
                                }
                            }
                        }

                        // 将尺码数据平铺到主要数据中（表格数据）
                        $orderData = [
                            '订单编号' => $item['订单编号'],
                            '子订单编号' => $item['子订单编号'],
                            '款号' => $item['款号'],
                            '款式' => $item['款式'],
                            '颜色' => $item['颜色备注'],
                            'zdtotal' => $item['zdtotal'],
                            'sctotal' => $item['sctotal'],
                            '单位' => $item['单位'],
                            'Sys_id' => $item['Sys_id'],
                            'Sys_rq' => $item['Sys_rq'],
                        ];
                        // 平铺尺码映射数据
                        $orderData = array_merge($orderData, $cmScslMapping);
                        $dataEntry[] = $orderData;
                        // list 列表部分
                        $entry = [];
                        for ($i = 1; $i <= 10; $i++) {
                            $entry['cm' . $i] = ($item['cm' . $i] === 0 || is_null($item['cm' . $i])) ? '' : $item['cm' . $i];
                            $entry['cmsl' . $i] = ($item['cmsl' . $i] === 0 || is_null($item['cmsl' . $i])) ? '' : $item['cmsl' . $i];
                            $entry['scsl' . $i] = ($item['scsl' . $i] === 0 || is_null($item['scsl' . $i])) ? '' : $item['scsl' . $i];
                        }
                        $entry['订单编号'] = $item['订单编号'];
                        $entry['子订单编号'] = $item['子订单编号'];
                        $entry['UniqId'] = $item['UniqId'];
                        $entry['zdtotal'] = $item['zdtotal'];
                        $entry['颜色'] = $item['颜色'];
                        $entry['款式'] = $item['款式'];
                        $entry['款号'] = $item['款号'];
                        $entry['color_id'] = $item['color_id'];
                        $entry['颜色备注'] = $item['颜色备注'];
                        $list[] = $entry;
                    }

                    // 在 $mergeds 中查找匹配的子订单编号 对应的一条数据
                    $matchedOrder = null;
                    foreach ($list as $mergedOrder) {
                        if ($mergedOrder['子订单编号'] === $order) {
                            $matchedOrder = $mergedOrder;
                            break; // 找到后可以退出循环
                        }
                    }
                    $allScslEmpty = true;
                    for ($i = 1; $i <= 10; $i++) {
                        if (!empty($matchedOrder["scsl$i"])) {
                            $allScslEmpty = false;
                            break;
                        }
                    }

                    if ($allScslEmpty) {
                        $this->error('当前订单还未进行裁剪,请裁剪后再报工');
                    }
//                    echo "<pre>";print_r($matchedOrder);echo "</pre>";die;

                    $sizeData = getSizeSummary($order);
                    // 查询流水号(包数)和序号

                    $serial = \db('设备_产量计酬')
                        ->field('子订单编号, MAX(CAST(serial AS UNSIGNED)) as serial, MAX(CAST(serial_num AS UNSIGNED)) as serial_num')
                        ->where('子订单编号', $order)
//                        ->where(function($query) {
//                            $query->whereNull('mod_rq')->whereOr('mod_rq', '');
//                        }) // 查询未删除数据
//                        ->where('sczl_jtbh', $params['sys_sbID'])
                        ->group('子订单编号')
                        ->find();
                    $serial['serial'] = empty($serial['serial']) ? '000' : str_pad($serial['serial'], 3, '0', STR_PAD_LEFT);
                    $serial['serial_num'] = empty($serial['serial_num']) ? '0' : $serial['serial_num'];

                    $clwhere['sczl_jtbh'] = $params['sys_sbID'];
                    $clwhere['子订单编号'] = $order;
                    $clwhere['mod_rq'] = null;
                    $clwhere['工序名称'] = $params['code'];
                    $cljclist = \db('设备_产量计酬')
                        ->field('订单编号,子订单编号,尺码,数量,mod_rq')
                        ->where($clwhere)
                        ->select();
                    $result = [];
                    $totalQuantity = 0; // 总数量初始化
                    $orderNumber = ''; // 订单编号初始化
                    foreach ($cljclist as $item) {
                        $size = $item['尺码'];
                        $orderNumber = $item['订单编号'];
                        if (isset($result[$size])) {
                            $result[$size] += $item['数量'];
                        } else {
                            $result[$size] = $item['数量'];
                        }
                        // 累加总数量
                        $totalQuantity += $item['数量'];
                    }
                    $result['订单编号'] = $orderNumber;
                    foreach ($result as $size => $quantity) {
                        if ($size !== '订单编号' && $size !== '数量') {
                            $result[$size] = '合计(' . $quantity . ')';
                        }
                    }
                    $result['数量'] = '合计(' . $totalQuantity . ')';

                    // 初始化 $sizeData['records']，以防万一它不存在
                    if (!isset($sizeData['records'])) {
                        $sizeData['records'] = [];
                    }
                    // 将 $result 插入到 $sizeData['records'] 的最前面
                    array_unshift($sizeData['records'], $result);

                    $this->success('请求成功', [
                        'serial' => $serial['serial']+1, // 流水号
                        'serial_num' => $serial['serial_num']+1, // 序号
                        'list' => $matchedOrder, // 报工
                        'headers' => $sizeData['headers'], // 尺码表头
                        'records' => $sizeData['records'] // 查询历史记录
                    ]);
                }else{

                    $sizeData = getSizeSummary($order);
                    // 查询流水号(包数)和序号
                    $serial = \db('设备_产量计酬')
                        ->field('子订单编号, MAX(CAST(serial AS UNSIGNED)) as serial, MAX(CAST(serial_num AS UNSIGNED)) as serial_num')
                        ->where('订单编号', $order)
                        ->group('订单编号')
                        ->find();
                    $serial['serial'] = empty($serial['serial']) ? '000' : str_pad($serial['serial'], 3, '0', STR_PAD_LEFT);
                    $serial['serial_num'] = empty($serial['serial_num']) ? '0' : $serial['serial_num'];

                    $clwhere['sczl_jtbh'] = $params['sys_sbID'];
                    $clwhere['订单编号'] = $order;
                    $clwhere['工序名称'] = $params['code'];
                    $clwhere['mod_rq'] = null;
                    $cljclist = \db('设备_产量计酬')
                        ->field('订单编号,子订单编号,尺码,数量,mod_rq')
                        ->where($clwhere)
                        ->select();
                    $result = [];
                    $totalQuantity = 0; // 总数量初始化
                    $orderNumber = ''; // 订单编号初始化
                    foreach ($cljclist as $item) {
                        $size = $item['尺码'];
                        $orderNumber = $item['订单编号'];
                        if (isset($result[$size])) {
                            $result[$size] += $item['数量'];
                        } else {
                            $result[$size] = $item['数量'];
                        }
                        // 累加总数量
                        $totalQuantity += $item['数量'];
                    }
                    foreach ($result as $size => $quantity) {
                        if ($size !== '订单编号' && $size !== '数量') {
                            $result[$size] = '合计(' . $quantity . ')';
                        }
                    }
                    $result['订单编号'] = $orderNumber;
                    $result['数量'] = '合计(' . $totalQuantity . ')';
                    // 初始化 $sizeData['records']，以防万一它不存在
                    if (!isset($sizeData['records'])) {
                        $sizeData['records'] = [];
                    }
                    // 将 $result 插入到 $sizeData['records'] 的最前面
                    array_unshift($sizeData['records'], $result);

                    $this->success('请求成功', [
                        'serial' => $serial['serial'], // 流水号
                        'serial_num' => $serial['serial_num'], // 序号
//                        'list' => $matchedOrder, // 报工
                        'headers' => $sizeData['headers'], // 尺码表头
                        'records' => $sizeData['records'] // 查询历史记录
                    ]);
                }
                break;
            case '手工':
                $gongxuname = '手工';
                $gongxuncode = '4';
                // 查询历史记录并生成尺寸汇总
                function getSizeSummary($order) {
                    $where = [];
                    if (strpos($order, '-') !== false) {
                        $where['c.子订单编号'] = $order;
                    } else {
                        $where['c.订单编号'] = ['like', '%' . $order . '%'];
                    }
                    $where['c.工序编号'] = '4';
                    $where['c.mod_rq'] = null;
                    $existingRecords = \db('设备_产量计酬')->alias('c')
                        ->field('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num 数量, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num,c.UniqId,
                        ci_num,s_num,
                                y.zdtotal, y.sctotal, j.款式, y.颜色,y.颜色备注, CAST(c.serial_num AS SIGNED) as serial_num_numeric')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where($where)
                        ->order('c.sys_rq desc')
                        ->group('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num, j.款式')
                        ->select();
                    $sizeSummary = [];
                    $sizes = [];
                    foreach ($existingRecords as $record) {
                        $size = $record['尺码'];
                        $quantity = $record['数量'];
                        $serial = $record['serial'];
                        $serialNum = $record['serial_num']; // serial_num 分组
                        $processNumber = $record['工序编号']; // 工序编号
                        // 初始化尺码
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 检查是否已有相同的 serial_num 组合
                        if (!isset($sizeSummary[$serialNum])) {
                            $sizeSummary[$serialNum] = [
                                '订单编号' => $record['订单编号'],
                                '子订单编号' => $record['子订单编号'],
                                '款号' => $record['款号'],
                                '款式' => $record['款式'],
                                '工序编号' => $record['工序编号'],
                                '工序名称' => $record['工序名称'],
//                                '上报数量' => $record['s_num'],
                                '剩余数量' => $record['ci_num'],
                                '数量' => '0', // 记录总数量
                                '尾包' => $record['尾包'] == 1 ? '是' : '否',
                                '颜色' => $record['颜色'],
                                '颜色备注' => $record['颜色备注'],
                                '机台号' => $record['sczl_jtbh'],
                                '组别' => $record['sczl_bh'],
                                'serial' => [], // 流水号数组
                                'sys_rq' => $record['sys_rq'],
                                'UniqId' => $record['UniqId'],
                                '尺码数据' => [] // 用于存储每个尺码对应的流水号和数量
                            ];
                        }
                        // 将流水号添加到 serial 数组
                        $sizeSummary[$serialNum]['serial'][] = $serial;
                        // 累加数量到总数量
                        $sizeSummary[$serialNum]['数量'] += $quantity;

                        // 记录尺码数据
                        if (!isset($sizeSummary[$serialNum]['尺码数据'][$size])) {
                            $sizeSummary[$serialNum]['尺码数据'][$size] = [];
                        }
                        // 添加尺码对应的流水号和数量
                        $sizeSummary[$serialNum]['尺码数据'][$size][] =  $serial . ' (' . $quantity . ')';
                    }
                    // 对每个工序的 serial 进行处理，并转换为逗号分隔的字符串
                    $finalRecords = [];
                    foreach ($sizeSummary as &$summary) {
                        // 将 serial 数组按数值降序排序
                        sort($summary['serial'], SORT_NUMERIC);
                        $summary['serial'] = implode(',', $summary['serial']);

                        // 合并尺码数据到同一层级
                        foreach ($summary['尺码数据'] as $size => $serials) {
                            $summary[$size] = implode(', ', $serials); // 尺码对应的流水号和数量
                        }

                        unset($summary['尺码数据']); // 移除尺码数据数组，直接将数据合并到 summary
                        $finalRecords[] = $summary;
                    }

                    // 尺码排序（数字在前，字母在后）
                    usort($sizes, function ($a, $b) {
                        $sizeOrder = ['XXXS' => 1,'XXS' => 2,'XS' => 3,'S' => 4, 'M' => 5, 'L' => 6, 'XL' => 7, 'XXL' => 8, 'XXXL' => 9, 'XXXXL' => 10];
                        if (is_numeric($a) && is_numeric($b)) return $a - $b;
                        if (is_numeric($a)) return -1;
                        if (is_numeric($b)) return 1;
                        return ($sizeOrder[$a] ?? 100) - ($sizeOrder[$b] ?? 100);
                    });

                    return ['headers' => $sizes, 'records' => $finalRecords];
                }


                //判断是否为标签参数数据
                if (strpos($order, ',') !== false) {
                    if (!isset($params['sys_sbID']) || empty($params['sys_sbID'])) {
                        $this->error('未获取到机台号');
                    }
                    // 将子订单编号, 机台号, 工序, 尺码, 数量, 尾包, 流水号（包）分割为数组
                    $paramArray = explode(',', $order);

                    // 获取车缝报工生成小票的数据
                    $Uniqid = \db('设备_产量计酬')
                        ->where([
                            '子订单编号' => $paramArray[0],
                            '尺码' => $paramArray[3],
                            '数量' => $paramArray[4],
                            'serial' => $paramArray[6],
                        ])
                        ->find();

                    // 判断是否成功获取到数据
                    if ($Uniqid) {
                        $orderlist = \db('工单_基本资料')
                            ->where('订单编号', $Uniqid['订单编号'])
                            ->field('订单编号, 生产款号, 款式')
                            ->find();
                        $yinjianlist = \db('工单_印件资料')
                            ->where('订单编号', $orderlist['订单编号'])
                            ->field('zdtotal, sctotal,颜色,颜色备注')
                            ->find();
                    } else {
                        $this->error('当前扫码小票无效');
                    }

                    // 获取当前手工机台上报的数据
                    $res = \db('设备_产量计酬')
                        ->where([
                            '子订单编号' => $paramArray[0],
                            '尺码' => $paramArray[3],
                            '数量' => $paramArray[4],
                            'serial' => $paramArray[6],
                            'sczl_jtbh' => $params['sys_sbID'],
                            'mod_rq' => null,
                        ])
                        ->order('UniqId desc')
                        ->find();

                    if (empty($res)) {
                        $ci_num = $paramArray[4];
                    } else {
                        $ci_num = $res["ci_num"];
                    }
                    $results = [
                        'sys_sbID' => $params['sys_sbID'],//设备编号
                        'ci_num' => $ci_num,//剩余数量
                        'UniqId' => $Uniqid['UniqId'],
                        'order' => $paramArray[0],//子订单编号
                        'zb' => $params['sys_sbID'],//组别
                        'gx' => $gongxuncode,//默认固定工序
                        'cm' => $paramArray[3],//尺码
                        'sl' => $paramArray[4],//数量
                        'wb' => $paramArray[5],//尾包
                        '订单编号' => $orderlist['订单编号'],
                        '生产款号' => $orderlist['生产款号'],
                        '款式' => $orderlist['款式'],
                        'sctotal' => $yinjianlist['sctotal'],
                        'zdtotal' => $yinjianlist['zdtotal'],
                        '颜色' => $yinjianlist['颜色备注'],
                    ];

                    $ddorder = explode('-', $paramArray[0]);
                    $clwhere['sczl_jtbh'] = $params['sys_sbID'];
                    $clwhere['订单编号'] = $ddorder[0];
                    $clwhere['工序名称'] = $gongxuname;
                    $clwhere['mod_rq'] = null;
                    $cljclist = \db('设备_产量计酬')
                        ->field('订单编号,子订单编号,尺码,s_num as 数量,mod_rq')
                        ->where($clwhere)
                        ->select();
                    $result = [];
                    $totalQuantity = 0; // 总数量初始化
                    $orderNumber = ''; // 订单编号初始化
                    foreach ($cljclist as $item) {
                        $size = $item['尺码'];
                        $orderNumber = $item['订单编号'];
                        if (isset($result[$size])) {
                            $result[$size] += $item['数量'];
                        } else {
                            $result[$size] = $item['数量'];
                        }
                        // 累加总数量
                        $totalQuantity += $item['数量'];
                    }
                    foreach ($result as $size => $quantity) {
                        if ($size !== '订单编号' && $size !== '数量') {
                            $result[$size] = '合计(' . $quantity . ')';
                        }
                    }
                    $result['订单编号'] = $orderNumber;
                    $result['数量'] = '合计(' . $totalQuantity . ')';
                    $sizeData = getSizeSummary($ddorder[0]);
                    // 初始化 $sizeData['records']，以防万一它不存在
                    if (!isset($sizeData['records'])) {
                        $sizeData['records'] = [];
                    }
                    // 将 $result 插入到 $sizeData['records'] 的最前面
                    array_unshift($sizeData['records'], $result);

                    $this->success('请求成功', [
                        'result' => $results,//小票数据
                        'headers' => $sizeData['headers'], // 尺码表头
                        'records' => $sizeData['records'] // 查询历史记录
                    ]);
                }else{
                    // 查询历史记录
                    $res = \db('设备_产量计酬')->alias('c')
                        ->field('
                             c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num as 数量, c.sczl_jtbh,
                             c.尾包,c.UniqId,c.ci_num,c.s_num,c.sys_rq, c.serial, 
                             j.款式,
                             y.zdtotal, y.sctotal, y.颜色,y.颜色备注
                             ')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where('c.订单编号', 'like', '%' . explode('DC',$order)[1] . '%')
                        ->where('c.工序名称', $params['code'])
                        ->where('c.sczl_jtbh', $params['sys_sbID'])
                        ->whereNull('c.mod_rq') // 查询未删除数据
                        ->order('UniqId desc')
                        ->select();
                    // 初始化返回数据的结构
                    $reslist = [];
                    $sizes = [];
                    // 遍历查询结果，构造需要的结构化数据
                    foreach ($res as $record) {
                        $size = $record['尺码']; // 记录的尺码
                        $quantity = $record['数量']; // 每个记录的数量
                        $serial = $record['serial']; // 记录的serial
                        // 记录所有不同的尺码，避免重复
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 构造每条记录的详细信息
                        $reslist[] = [
                            'UniqId' => $record['UniqId'],
                            '订单编号' => $record['订单编号'],
                            '子订单编号' => $record['子订单编号'],
                            '上报数量' => $record['s_num'],
                            '剩余数量' => $record['ci_num'],
                            '次品数量' => $record['数量'] - $record['ci_num'],
                            '款号' => $record['款号'],
                            '尺码' => $record['尺码'],
                            '工序编号' => $record['工序编号'],
                            '工序名称' => $record['工序名称'],
                            '数量' => $quantity,
                            '尾包' => $record['尾包'] == 1 ? '是' : '否',
                            '颜色' => $record['颜色备注'],
                            '组别' => $record['sczl_jtbh'],
                            '款式' => $record['款式'],
                            'serial' => '第('.$serial.')包',
                            'sys_rq' => $record['sys_rq']
                        ];
                    }
                    // 按 sys_rq (时间) 或 UniqId 排序（按实际需求选）
                    usort($reslist, function ($a, $b) {
                        return strtotime($b['sys_rq']) - strtotime($a['sys_rq']);
                    });
                    // 返回结构化的查询结果
                    $this->success('请求成功', [
                        'result' => $res, // 原始查询结果
                        'headers' => $sizes, // 尺码表头
                        'records' => $reslist // 处理后的记录列表
                    ]);
                }
                break;
            case '大烫':
                $gongxuname = '大烫';
                $gongxuncode = '5';
                // 查询历史记录并生成尺寸汇总
                function getSizeSummary($order) {
                    $where = [];
                    if (strpos($order, '-') !== false) {
                        $where['c.子订单编号'] = $order;
                    } else {
                        $where['c.订单编号'] = ['like', '%' . $order . '%'];
                    }
                    $where['c.工序编号'] = '5';
                    $where['c.mod_rq'] = null;
                    $existingRecords = \db('设备_产量计酬')->alias('c')
                        ->field('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num 数量, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num,c.UniqId,
                        ci_num,s_num,
                                y.zdtotal, y.sctotal, j.款式, y.颜色,y.颜色备注, CAST(c.serial_num AS SIGNED) as serial_num_numeric')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where($where)
                        ->order('c.sys_rq desc')
                        ->group('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num, j.款式')
                        ->select();
                    $sizeSummary = [];
                    $sizes = [];
                    foreach ($existingRecords as $record) {
                        $size = $record['尺码'];
                        $quantity = $record['数量'];
                        $serial = $record['serial'];
                        $serialNum = $record['serial_num']; // serial_num 分组
                        $processNumber = $record['工序编号']; // 工序编号
                        // 初始化尺码
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 检查是否已有相同的 serial_num 组合
                        if (!isset($sizeSummary[$serialNum])) {
                            $sizeSummary[$serialNum] = [
                                '订单编号' => $record['订单编号'],
                                '子订单编号' => $record['子订单编号'],
                                '款号' => $record['款号'],
                                '款式' => $record['款式'],
                                '工序编号' => $record['工序编号'],
                                '工序名称' => $record['工序名称'],
//                                '上报数量' => $record['s_num'],
                                '剩余数量' => $record['ci_num'],
                                '数量' => '0', // 记录总数量
                                '尾包' => $record['尾包'] == 1 ? '是' : '否',
                                '颜色' => $record['颜色'],
                                '颜色备注' => $record['颜色备注'],
                                '机台号' => $record['sczl_jtbh'],
                                '组别' => $record['sczl_bh'],
                                'serial' => [], // 流水号数组
                                'sys_rq' => $record['sys_rq'],
                                'UniqId' => $record['UniqId'],
                                '尺码数据' => [] // 用于存储每个尺码对应的流水号和数量
                            ];
                        }
                        // 将流水号添加到 serial 数组
                        $sizeSummary[$serialNum]['serial'][] = $serial;
                        // 累加数量到总数量
                        $sizeSummary[$serialNum]['数量'] += $quantity;

                        // 记录尺码数据
                        if (!isset($sizeSummary[$serialNum]['尺码数据'][$size])) {
                            $sizeSummary[$serialNum]['尺码数据'][$size] = [];
                        }
                        // 添加尺码对应的流水号和数量
                        $sizeSummary[$serialNum]['尺码数据'][$size][] =  $serial . ' (' . $quantity . ')';
                    }
                    // 对每个工序的 serial 进行处理，并转换为逗号分隔的字符串
                    $finalRecords = [];
                    foreach ($sizeSummary as &$summary) {
                        // 将 serial 数组按数值降序排序
                        sort($summary['serial'], SORT_NUMERIC);
                        $summary['serial'] = implode(',', $summary['serial']);

                        // 合并尺码数据到同一层级
                        foreach ($summary['尺码数据'] as $size => $serials) {
                            $summary[$size] = implode(', ', $serials); // 尺码对应的流水号和数量
                        }

                        unset($summary['尺码数据']); // 移除尺码数据数组，直接将数据合并到 summary
                        $finalRecords[] = $summary;
                    }

                    // 尺码排序（数字在前，字母在后）
                    usort($sizes, function ($a, $b) {
                        $sizeOrder = ['XXXS' => 1,'XXS' => 2,'XS' => 3,'S' => 4, 'M' => 5, 'L' => 6, 'XL' => 7, 'XXL' => 8, 'XXXL' => 9, 'XXXXL' => 10];
                        if (is_numeric($a) && is_numeric($b)) return $a - $b;
                        if (is_numeric($a)) return -1;
                        if (is_numeric($b)) return 1;
                        return ($sizeOrder[$a] ?? 100) - ($sizeOrder[$b] ?? 100);
                    });

                    return ['headers' => $sizes, 'records' => $finalRecords];
                }


                //判断是否为标签参数数据
                if (strpos($order, ',') !== false) {
                    if (!isset($params['sys_sbID']) || empty($params['sys_sbID'])) {
                        $this->error('未获取到机台号');
                    }
                    // 将子订单编号, 机台号, 工序, 尺码, 数量, 尾包, 流水号（包）分割为数组
                    $paramArray = explode(',', $order);

                    // 获取车缝报工生成小票的数据
                    $Uniqid = \db('设备_产量计酬')
                        ->where([
                            '子订单编号' => $paramArray[0],
                            '尺码' => $paramArray[3],
                            '数量' => $paramArray[4],
                            'serial' => $paramArray[6],
                        ])
                        ->find();

                    // 判断是否成功获取到数据
                    if ($Uniqid) {
                        $orderlist = \db('工单_基本资料')
                            ->where('订单编号', $Uniqid['订单编号'])
                            ->field('订单编号, 生产款号, 款式')
                            ->find();
                        $yinjianlist = \db('工单_印件资料')
                            ->where('订单编号', $orderlist['订单编号'])
                            ->field('zdtotal, sctotal,颜色,颜色备注')
                            ->find();
                    } else {
                        $this->error('当前扫码小票无效');
                    }

                    // 获取当前手工机台上报的数据
                    $res = \db('设备_产量计酬')
                        ->where([
                            '子订单编号' => $paramArray[0],
                            '尺码' => $paramArray[3],
                            '数量' => $paramArray[4],
                            'serial' => $paramArray[6],
                            'sczl_jtbh' => $params['sys_sbID'],
                            'mod_rq' => null,
                        ])
                        ->order('UniqId desc')
                        ->find();

                    if (empty($res)) {
                        $ci_num = $paramArray[4];
                    } else {
                        $ci_num = $res["ci_num"];
                    }
                    $results = [
                        'sys_sbID' => $params['sys_sbID'],//设备编号
                        'ci_num' => $ci_num,//剩余数量
                        'UniqId' => $Uniqid['UniqId'],
                        'order' => $paramArray[0],//子订单编号
                        'zb' => $params['sys_sbID'],//组别
                        'gx' => $gongxuncode,//默认固定工序
                        'cm' => $paramArray[3],//尺码
                        'sl' => $paramArray[4],//数量
                        'wb' => $paramArray[5],//尾包
                        '订单编号' => $orderlist['订单编号'],
                        '生产款号' => $orderlist['生产款号'],
                        '款式' => $orderlist['款式'],
                        'sctotal' => $yinjianlist['sctotal'],
                        'zdtotal' => $yinjianlist['zdtotal'],
                        '颜色' => $yinjianlist['颜色备注'],
                    ];

                    $ddorder = explode('-', $paramArray[0]);
                    $clwhere['sczl_jtbh'] = $params['sys_sbID'];
                    $clwhere['订单编号'] = $ddorder[0];
                    $clwhere['工序名称'] = $gongxuname;
                    $clwhere['mod_rq'] = null;
                    $cljclist = \db('设备_产量计酬')
                        ->field('订单编号,子订单编号,尺码,s_num as 数量,mod_rq')
                        ->where($clwhere)
                        ->select();
                    $result = [];
                    $totalQuantity = 0; // 总数量初始化
                    $orderNumber = ''; // 订单编号初始化
                    foreach ($cljclist as $item) {
                        $size = $item['尺码'];
                        $orderNumber = $item['订单编号'];
                        if (isset($result[$size])) {
                            $result[$size] += $item['数量'];
                        } else {
                            $result[$size] = $item['数量'];
                        }
                        // 累加总数量
                        $totalQuantity += $item['数量'];
                    }
                    foreach ($result as $size => $quantity) {
                        if ($size !== '订单编号' && $size !== '数量') {
                            $result[$size] = '合计(' . $quantity . ')';
                        }
                    }
                    $result['订单编号'] = $orderNumber;
                    $result['数量'] = '合计(' . $totalQuantity . ')';
                    $sizeData = getSizeSummary($ddorder[0]);
                    // 初始化 $sizeData['records']，以防万一它不存在
                    if (!isset($sizeData['records'])) {
                        $sizeData['records'] = [];
                    }
                    // 将 $result 插入到 $sizeData['records'] 的最前面
                    array_unshift($sizeData['records'], $result);

                    $this->success('请求成功', [
                        'result' => $results,//小票数据
                        'headers' => $sizeData['headers'], // 尺码表头
                        'records' => $sizeData['records'] // 查询历史记录
                    ]);
                }else{
                    // 查询历史记录
                    $res = \db('设备_产量计酬')->alias('c')
                        ->field('
                             c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num as 数量, c.sczl_jtbh,
                             c.尾包,c.UniqId,c.ci_num,c.s_num,c.sys_rq, c.serial, 
                             j.款式,
                             y.zdtotal, y.sctotal, y.颜色,y.颜色备注
                             ')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where('c.订单编号', 'like', '%' . explode('DC',$order)[1] . '%')
                        ->where('c.工序名称', $params['code'])
                        ->where('c.sczl_jtbh', $params['sys_sbID'])
                        ->whereNull('c.mod_rq') // 查询未删除数据
                        ->order('UniqId desc')
                        ->select();
                    // 初始化返回数据的结构
                    $reslist = [];
                    $sizes = [];
                    // 遍历查询结果，构造需要的结构化数据
                    foreach ($res as $record) {
                        $size = $record['尺码']; // 记录的尺码
                        $quantity = $record['数量']; // 每个记录的数量
                        $serial = $record['serial']; // 记录的serial
                        // 记录所有不同的尺码，避免重复
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 构造每条记录的详细信息
                        $reslist[] = [
                            'UniqId' => $record['UniqId'],
                            '订单编号' => $record['订单编号'],
                            '子订单编号' => $record['子订单编号'],
                            '上报数量' => $record['s_num'],
                            '剩余数量' => $record['ci_num'],
                            '次品数量' => $record['数量'] - $record['ci_num'],
                            '款号' => $record['款号'],
                            '尺码' => $record['尺码'],
                            '工序编号' => $record['工序编号'],
                            '工序名称' => $record['工序名称'],
                            '数量' => $quantity,
                            '尾包' => $record['尾包'] == 1 ? '是' : '否',
                            '颜色' => $record['颜色备注'],
                            '组别' => $record['sczl_jtbh'],
                            '款式' => $record['款式'],
                            'serial' => '第('.$serial.')包',
                            'sys_rq' => $record['sys_rq']
                        ];
                    }
                    // 按 sys_rq (时间) 或 UniqId 排序（按实际需求选）
                    usort($reslist, function ($a, $b) {
                        return strtotime($b['sys_rq']) - strtotime($a['sys_rq']);
                    });
                    // 返回结构化的查询结果
                    $this->success('请求成功', [
                        'result' => $res, // 原始查询结果
                        'headers' => $sizes, // 尺码表头
                        'records' => $reslist // 处理后的记录列表
                    ]);
                }
                break;
            case '总检':
                $gongxuname = '总检';
                $gongxuncode = '6';
                // 查询历史记录并生成尺寸汇总
                function getSizeSummary($order) {
                    $where = [];
                    if (strpos($order, '-') !== false) {
                        $where['c.子订单编号'] = $order;
                    } else {
                        $where['c.订单编号'] = ['like', '%' . $order . '%'];
                    }
                    $where['c.工序编号'] = '6';
                    $where['c.mod_rq'] = null;
                    $existingRecords = \db('设备_产量计酬')->alias('c')
                        ->field('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num 数量, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num,c.UniqId,
                        ci_num,s_num,
                                y.zdtotal, y.sctotal, j.款式, y.颜色,y.颜色备注, CAST(c.serial_num AS SIGNED) as serial_num_numeric')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where($where)
                        ->order('c.sys_rq desc')
                        ->group('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num, j.款式')
                        ->select();
                    $sizeSummary = [];
                    $sizes = [];
                    foreach ($existingRecords as $record) {
                        $size = $record['尺码'];
                        $quantity = $record['数量'];
                        $serial = $record['serial'];
                        $serialNum = $record['serial_num']; // serial_num 分组
                        $processNumber = $record['工序编号']; // 工序编号
                        // 初始化尺码
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 检查是否已有相同的 serial_num 组合
                        if (!isset($sizeSummary[$serialNum])) {
                            $sizeSummary[$serialNum] = [
                                '订单编号' => $record['订单编号'],
                                '子订单编号' => $record['子订单编号'],
                                '款号' => $record['款号'],
                                '款式' => $record['款式'],
                                '工序编号' => $record['工序编号'],
                                '工序名称' => $record['工序名称'],
//                                '上报数量' => $record['s_num'],
                                '剩余数量' => $record['ci_num'],
                                '数量' => '0', // 记录总数量
                                '尾包' => $record['尾包'] == 1 ? '是' : '否',
                                '颜色' => $record['颜色'],
                                '颜色备注' => $record['颜色备注'],
                                '机台号' => $record['sczl_jtbh'],
                                '组别' => $record['sczl_bh'],
                                'serial' => [], // 流水号数组
                                'sys_rq' => $record['sys_rq'],
                                'UniqId' => $record['UniqId'],
                                '尺码数据' => [] // 用于存储每个尺码对应的流水号和数量
                            ];
                        }
                        // 将流水号添加到 serial 数组
                        $sizeSummary[$serialNum]['serial'][] = $serial;
                        // 累加数量到总数量
                        $sizeSummary[$serialNum]['数量'] += $quantity;

                        // 记录尺码数据
                        if (!isset($sizeSummary[$serialNum]['尺码数据'][$size])) {
                            $sizeSummary[$serialNum]['尺码数据'][$size] = [];
                        }
                        // 添加尺码对应的流水号和数量
                        $sizeSummary[$serialNum]['尺码数据'][$size][] =  $serial . ' (' . $quantity . ')';
                    }
                    // 对每个工序的 serial 进行处理，并转换为逗号分隔的字符串
                    $finalRecords = [];
                    foreach ($sizeSummary as &$summary) {
                        // 将 serial 数组按数值降序排序
                        sort($summary['serial'], SORT_NUMERIC);
                        $summary['serial'] = implode(',', $summary['serial']);

                        // 合并尺码数据到同一层级
                        foreach ($summary['尺码数据'] as $size => $serials) {
                            $summary[$size] = implode(', ', $serials); // 尺码对应的流水号和数量
                        }

                        unset($summary['尺码数据']); // 移除尺码数据数组，直接将数据合并到 summary
                        $finalRecords[] = $summary;
                    }

                    // 尺码排序（数字在前，字母在后）
                    usort($sizes, function ($a, $b) {
                        $sizeOrder = ['XXXS' => 1,'XXS' => 2,'XS' => 3,'S' => 4, 'M' => 5, 'L' => 6, 'XL' => 7, 'XXL' => 8, 'XXXL' => 9, 'XXXXL' => 10];
                        if (is_numeric($a) && is_numeric($b)) return $a - $b;
                        if (is_numeric($a)) return -1;
                        if (is_numeric($b)) return 1;
                        return ($sizeOrder[$a] ?? 100) - ($sizeOrder[$b] ?? 100);
                    });

                    return ['headers' => $sizes, 'records' => $finalRecords];
                }


                //判断是否为标签参数数据
                if (strpos($order, ',') !== false) {
                    if (!isset($params['sys_sbID']) || empty($params['sys_sbID'])) {
                        $this->error('未获取到机台号');
                    }
                    // 将子订单编号, 机台号, 工序, 尺码, 数量, 尾包, 流水号（包）分割为数组
                    $paramArray = explode(',', $order);

                    // 获取车缝报工生成小票的数据
                    $Uniqid = \db('设备_产量计酬')
                        ->where([
                            '子订单编号' => $paramArray[0],
                            '尺码' => $paramArray[3],
                            '数量' => $paramArray[4],
                            'serial' => $paramArray[6],
                        ])
                        ->find();

                    // 判断是否成功获取到数据
                    if ($Uniqid) {
                        $orderlist = \db('工单_基本资料')
                            ->where('订单编号', $Uniqid['订单编号'])
                            ->field('订单编号, 生产款号, 款式')
                            ->find();
                        $yinjianlist = \db('工单_印件资料')
                            ->where('订单编号', $orderlist['订单编号'])
                            ->field('zdtotal, sctotal,颜色,颜色备注')
                            ->find();
                    } else {
                        $this->error('当前扫码小票无效');
                    }

                    // 获取当前手工机台上报的数据
                    $res = \db('设备_产量计酬')
                        ->where([
                            '子订单编号' => $paramArray[0],
                            '尺码' => $paramArray[3],
                            '数量' => $paramArray[4],
                            'serial' => $paramArray[6],
                            'sczl_jtbh' => $params['sys_sbID'],
                            'mod_rq' => null,
                        ])
                        ->order('UniqId desc')
                        ->find();

                    if (empty($res)) {
                        $ci_num = $paramArray[4];
                    } else {
                        $ci_num = $res["ci_num"];
                    }
                    $results = [
                        'sys_sbID' => $params['sys_sbID'],//设备编号
                        'ci_num' => $ci_num,//剩余数量
                        'UniqId' => $Uniqid['UniqId'],
                        'order' => $paramArray[0],//子订单编号
                        'zb' => $params['sys_sbID'],//组别
                        'gx' => $gongxuncode,//默认固定工序
                        'cm' => $paramArray[3],//尺码
                        'sl' => $paramArray[4],//数量
                        'wb' => $paramArray[5],//尾包
                        '订单编号' => $orderlist['订单编号'],
                        '生产款号' => $orderlist['生产款号'],
                        '款式' => $orderlist['款式'],
                        'sctotal' => $yinjianlist['sctotal'],
                        'zdtotal' => $yinjianlist['zdtotal'],
                        '颜色' => $yinjianlist['颜色备注'],
                    ];
                    $ddorder = explode('-', $paramArray[0]);
                    $clwhere['sczl_jtbh'] = $params['sys_sbID'];
                    $clwhere['订单编号'] = $ddorder[0];
                    $clwhere['工序名称'] = $gongxuname;
                    $clwhere['mod_rq'] = null;
                    $cljclist = \db('设备_产量计酬')
                        ->field('订单编号,子订单编号,尺码,s_num as 数量,mod_rq')
                        ->where($clwhere)
                        ->select();
                    $result = [];
                    $totalQuantity = 0; // 总数量初始化
                    $orderNumber = ''; // 订单编号初始化
                    foreach ($cljclist as $item) {
                        $size = $item['尺码'];
                        $orderNumber = $item['订单编号'];
                        if (isset($result[$size])) {
                            $result[$size] += $item['数量'];
                        } else {
                            $result[$size] = $item['数量'];
                        }
                        // 累加总数量
                        $totalQuantity += $item['数量'];
                    }
                    foreach ($result as $size => $quantity) {
                        if ($size !== '订单编号' && $size !== '数量') {
                            $result[$size] = '合计(' . $quantity . ')';
                        }
                    }
                    $result['订单编号'] = $orderNumber;
                    $result['数量'] = '合计(' . $totalQuantity . ')';
                    $sizeData = getSizeSummary($ddorder[0]);
                    // 初始化 $sizeData['records']，以防万一它不存在
                    if (!isset($sizeData['records'])) {
                        $sizeData['records'] = [];
                    }
                    // 将 $result 插入到 $sizeData['records'] 的最前面
                    array_unshift($sizeData['records'], $result);

                    $this->success('请求成功', [
                        'result' => $results,//小票数据
                        'headers' => $sizeData['headers'], // 尺码表头
                        'records' => $sizeData['records'] // 查询历史记录
                    ]);
                }else{
                    // 查询历史记录
                    $res = \db('设备_产量计酬')->alias('c')
                        ->field('
                             c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num as 数量, c.sczl_jtbh,
                             c.尾包,c.UniqId,c.ci_num,c.s_num,c.sys_rq, c.serial, 
                             j.款式,
                             y.zdtotal, y.sctotal, y.颜色,y.颜色备注
                             ')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where('c.订单编号', 'like', '%' . explode('DC',$order)[1] . '%')
                        ->where('c.工序名称', $params['code'])
                        ->where('c.sczl_jtbh', $params['sys_sbID'])
                        ->whereNull('c.mod_rq') // 查询未删除数据
                        ->order('UniqId desc')
                        ->select();
                    // 初始化返回数据的结构
                    $reslist = [];
                    $sizes = [];
                    // 遍历查询结果，构造需要的结构化数据
                    foreach ($res as $record) {
                        $size = $record['尺码']; // 记录的尺码
                        $quantity = $record['数量']; // 每个记录的数量
                        $serial = $record['serial']; // 记录的serial
                        // 记录所有不同的尺码，避免重复
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 构造每条记录的详细信息
                        $reslist[] = [
                            'UniqId' => $record['UniqId'],
                            '订单编号' => $record['订单编号'],
                            '子订单编号' => $record['子订单编号'],
                            '上报数量' => $record['s_num'],
                            '剩余数量' => $record['ci_num'],
                            '次品数量' => $record['数量'] - $record['ci_num'],
                            '款号' => $record['款号'],
                            '尺码' => $record['尺码'],
                            '工序编号' => $record['工序编号'],
                            '工序名称' => $record['工序名称'],
                            '数量' => $quantity,
                            '尾包' => $record['尾包'] == 1 ? '是' : '否',
                            '颜色' => $record['颜色备注'],
                            '组别' => $record['sczl_jtbh'],
                            '款式' => $record['款式'],
                            'serial' => '第('.$serial.')包',
                            'sys_rq' => $record['sys_rq']
                        ];
                    }
                    // 按 sys_rq (时间) 或 UniqId 排序（按实际需求选）
                    usort($reslist, function ($a, $b) {
                        return strtotime($b['sys_rq']) - strtotime($a['sys_rq']);
                    });
                    // 返回结构化的查询结果
                    $this->success('请求成功', [
                        'result' => $res, // 原始查询结果
                        'headers' => $sizes, // 尺码表头
                        'records' => $reslist // 处理后的记录列表
                    ]);
                }
                break;
            case '包装':
                $gongxuname = '包装';
                $gongxuncode = '7';
                // 查询历史记录并生成尺寸汇总
                function getSizeSummary($order) {
                    $where = [];
                    if (strpos($order, '-') !== false) {
                        $where['c.子订单编号'] = $order;
                    } else {
                        $where['c.订单编号'] = ['like', '%' . $order . '%'];
                    }
                    $where['c.工序编号'] = '7';
                    $where['c.mod_rq'] = null;
                    $existingRecords = \db('设备_产量计酬')->alias('c')
                        ->field('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num 数量, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num,c.UniqId,
                        ci_num,s_num,
                                y.zdtotal, y.sctotal, j.款式, y.颜色,y.颜色备注, CAST(c.serial_num AS SIGNED) as serial_num_numeric')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where($where)
                        ->order('c.sys_rq desc')
                        ->group('c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num, c.sczl_jtbh, c.sczl_bh, c.尾包, c.sys_rq, c.serial, c.serial_num, j.款式')
                        ->select();
                    $sizeSummary = [];
                    $sizes = [];
                    foreach ($existingRecords as $record) {
                        $size = $record['尺码'];
                        $quantity = $record['数量'];
                        $serial = $record['serial'];
                        $serialNum = $record['serial_num']; // serial_num 分组
                        $processNumber = $record['工序编号']; // 工序编号
                        // 初始化尺码
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 检查是否已有相同的 serial_num 组合
                        if (!isset($sizeSummary[$serialNum])) {
                            $sizeSummary[$serialNum] = [
                                '订单编号' => $record['订单编号'],
                                '子订单编号' => $record['子订单编号'],
                                '款号' => $record['款号'],
                                '款式' => $record['款式'],
                                '工序编号' => $record['工序编号'],
                                '工序名称' => $record['工序名称'],
//                                '上报数量' => $record['s_num'],
                                '剩余数量' => $record['ci_num'],
                                '数量' => '0', // 记录总数量
                                '尾包' => $record['尾包'] == 1 ? '是' : '否',
                                '颜色' => $record['颜色'],
                                '颜色备注' => $record['颜色备注'],
                                '机台号' => $record['sczl_jtbh'],
                                '组别' => $record['sczl_bh'],
                                'serial' => [], // 流水号数组
                                'sys_rq' => $record['sys_rq'],
                                'UniqId' => $record['UniqId'],
                                '尺码数据' => [] // 用于存储每个尺码对应的流水号和数量
                            ];
                        }
                        // 将流水号添加到 serial 数组
                        $sizeSummary[$serialNum]['serial'][] = $serial;
                        // 累加数量到总数量
                        $sizeSummary[$serialNum]['数量'] += $quantity;

                        // 记录尺码数据
                        if (!isset($sizeSummary[$serialNum]['尺码数据'][$size])) {
                            $sizeSummary[$serialNum]['尺码数据'][$size] = [];
                        }
                        // 添加尺码对应的流水号和数量
                        $sizeSummary[$serialNum]['尺码数据'][$size][] =  $serial . ' (' . $quantity . ')';
                    }
                    // 对每个工序的 serial 进行处理，并转换为逗号分隔的字符串
                    $finalRecords = [];
                    foreach ($sizeSummary as &$summary) {
                        // 将 serial 数组按数值降序排序
                        sort($summary['serial'], SORT_NUMERIC);
                        $summary['serial'] = implode(',', $summary['serial']);

                        // 合并尺码数据到同一层级
                        foreach ($summary['尺码数据'] as $size => $serials) {
                            $summary[$size] = implode(', ', $serials); // 尺码对应的流水号和数量
                        }

                        unset($summary['尺码数据']); // 移除尺码数据数组，直接将数据合并到 summary
                        $finalRecords[] = $summary;
                    }

                    // 尺码排序（数字在前，字母在后）
                    usort($sizes, function ($a, $b) {
                        $sizeOrder = ['XXXS' => 1,'XXS' => 2,'XS' => 3,'S' => 4, 'M' => 5, 'L' => 6, 'XL' => 7, 'XXL' => 8, 'XXXL' => 9, 'XXXXL' => 10];
                        if (is_numeric($a) && is_numeric($b)) return $a - $b;
                        if (is_numeric($a)) return -1;
                        if (is_numeric($b)) return 1;
                        return ($sizeOrder[$a] ?? 100) - ($sizeOrder[$b] ?? 100);
                    });

                    return ['headers' => $sizes, 'records' => $finalRecords];
                }


                //判断是否为标签参数数据
                if (strpos($order, ',') !== false) {
                    if (!isset($params['sys_sbID']) || empty($params['sys_sbID'])) {
                        $this->error('未获取到机台号');
                    }
                    // 将子订单编号, 机台号, 工序, 尺码, 数量, 尾包, 流水号（包）分割为数组
                    $paramArray = explode(',', $order);

                    // 获取车缝报工生成小票的数据
                    $Uniqid = \db('设备_产量计酬')
                        ->where([
                            '子订单编号' => $paramArray[0],
                            '尺码' => $paramArray[3],
                            '数量' => $paramArray[4],
                            'serial' => $paramArray[6],
                        ])
                        ->find();

                    // 判断是否成功获取到数据
                    if ($Uniqid) {
                        $orderlist = \db('工单_基本资料')
                            ->where('订单编号', $Uniqid['订单编号'])
                            ->field('订单编号, 生产款号, 款式')
                            ->find();
                        $yinjianlist = \db('工单_印件资料')
                            ->where('订单编号', $orderlist['订单编号'])
                            ->field('zdtotal, sctotal,颜色,颜色备注')
                            ->find();
                    } else {
                        $this->error('当前扫码小票无效');
                    }

                    // 获取当前手工机台上报的数据
                    $res = \db('设备_产量计酬')
                        ->where([
                            '子订单编号' => $paramArray[0],
                            '尺码' => $paramArray[3],
                            '数量' => $paramArray[4],
                            'serial' => $paramArray[6],
                            'sczl_jtbh' => $params['sys_sbID'],
                            'mod_rq' => null,
                        ])
                        ->order('UniqId desc')
                        ->find();

                    if (empty($res)) {
                        $ci_num = $paramArray[4];
                    } else {
                        $ci_num = $res["ci_num"];
                    }
                    $results = [
                        'sys_sbID' => $params['sys_sbID'],//设备编号
                        'ci_num' => $ci_num,//剩余数量
                        'UniqId' => $Uniqid['UniqId'],
                        'order' => $paramArray[0],//子订单编号
                        'zb' => $params['sys_sbID'],//组别
                        'gx' => $gongxuncode,//默认固定工序
                        'cm' => $paramArray[3],//尺码
                        'sl' => $paramArray[4],//数量
                        'wb' => $paramArray[5],//尾包
                        '订单编号' => $orderlist['订单编号'],
                        '生产款号' => $orderlist['生产款号'],
                        '款式' => $orderlist['款式'],
                        'sctotal' => $yinjianlist['sctotal'],
                        'zdtotal' => $yinjianlist['zdtotal'],
                        '颜色' => $yinjianlist['颜色备注'],
                    ];

                    $ddorder = explode('-', $paramArray[0]);
                    $clwhere['sczl_jtbh'] = $params['sys_sbID'];
                    $clwhere['订单编号'] = $ddorder[0];
                    $clwhere['工序名称'] = $gongxuname;
                    $clwhere['mod_rq'] = null;
                    $cljclist = \db('设备_产量计酬')
                        ->field('订单编号,子订单编号,尺码,s_num as 数量,mod_rq')
                        ->where($clwhere)
                        ->select();
                    $result = [];
                    $totalQuantity = 0; // 总数量初始化
                    $orderNumber = ''; // 订单编号初始化
                    foreach ($cljclist as $item) {
                        $size = $item['尺码'];
                        $orderNumber = $item['订单编号'];
                        if (isset($result[$size])) {
                            $result[$size] += $item['数量'];
                        } else {
                            $result[$size] = $item['数量'];
                        }
                        // 累加总数量
                        $totalQuantity += $item['数量'];
                    }
                    foreach ($result as $size => $quantity) {
                        if ($size !== '订单编号' && $size !== '数量') {
                            $result[$size] = '合计(' . $quantity . ')';
                        }
                    }
                    $result['订单编号'] = $orderNumber;
                    $result['数量'] = '合计(' . $totalQuantity . ')';
                    $sizeData = getSizeSummary($ddorder[0]);
                    // 初始化 $sizeData['records']，以防万一它不存在
                    if (!isset($sizeData['records'])) {
                        $sizeData['records'] = [];
                    }
                    // 将 $result 插入到 $sizeData['records'] 的最前面
                    array_unshift($sizeData['records'], $result);

                    $this->success('请求成功', [
                        'result' => $results,//小票数据
                        'headers' => $sizeData['headers'], // 尺码表头
                        'records' => $sizeData['records'] // 查询历史记录
                    ]);
                }else{
                    // 查询历史记录
                    $res = \db('设备_产量计酬')->alias('c')
                        ->field('
                             c.订单编号, c.子订单编号, c.款号, c.工序编号, c.工序名称, c.尺码, c.s_num as 数量, c.sczl_jtbh,
                             c.尾包,c.UniqId,c.ci_num,c.s_num,c.sys_rq, c.serial, 
                             j.款式,
                             y.zdtotal, y.sctotal, y.颜色,y.颜色备注
                             ')
                        ->join('工单_印件资料 y', 'c.子订单编号 = y.子订单编号', 'left')
                        ->join('工单_基本资料 j', 'c.订单编号 = j.订单编号', 'left')
                        ->where('c.订单编号', 'like', '%' . explode('DC',$order)[1] . '%')
                        ->where('c.工序名称', $params['code'])
                        ->where('c.sczl_jtbh', $params['sys_sbID'])
                        ->whereNull('c.mod_rq') // 查询未删除数据
                        ->order('UniqId desc')
                        ->select();
                    // 初始化返回数据的结构
                    $reslist = [];
                    $sizes = [];
                    // 遍历查询结果，构造需要的结构化数据
                    foreach ($res as $record) {
                        $size = $record['尺码']; // 记录的尺码
                        $quantity = $record['数量']; // 每个记录的数量
                        $serial = $record['serial']; // 记录的serial
                        // 记录所有不同的尺码，避免重复
                        if (!in_array($size, $sizes)) {
                            $sizes[] = $size;
                        }
                        // 构造每条记录的详细信息
                        $reslist[] = [
                            'UniqId' => $record['UniqId'],
                            '订单编号' => $record['订单编号'],
                            '子订单编号' => $record['子订单编号'],
                            '上报数量' => $record['s_num'],
                            '剩余数量' => $record['ci_num'],
                            '次品数量' => $record['数量'] - $record['ci_num'],
                            '款号' => $record['款号'],
                            '尺码' => $record['尺码'],
                            '工序编号' => $record['工序编号'],
                            '工序名称' => $record['工序名称'],
                            '数量' => $quantity,
                            '尾包' => $record['尾包'] == 1 ? '是' : '否',
                            '颜色' => $record['颜色备注'],
                            '组别' => $record['sczl_jtbh'],
                            '款式' => $record['款式'],
                            'serial' => '第('.$serial.')包',
                            'sys_rq' => $record['sys_rq']
                        ];
                    }
                    // 按 sys_rq (时间) 或 UniqId 排序（按实际需求选）
                    usort($reslist, function ($a, $b) {
                        return strtotime($b['sys_rq']) - strtotime($a['sys_rq']);
                    });
                    // 返回结构化的查询结果
                    $this->success('请求成功', [
                        'result' => $res, // 原始查询结果
                        'headers' => $sizes, // 尺码表头
                        'records' => $reslist // 处理后的记录列表
                    ]);
                }
                break;
            default:
                $this->error('无效的 code 参数');
                break;
        }
    }


    /**
     * 出库报工日志
     * 确认出库 恢复出库状态
     */
    public function getTab() {
        if (!$this->request->isPost()) {
            $this->error('非法请求');
        }

        $params = $this->request->param();

        // 校验子订单编号和出库日期
        if (empty($params['order_id'])) {
            $this->error('子订单编号不能为空');
        }

        // 处理出库逻辑
        if ($params['code'] == '出库') {
            if (strpos($params['order_id'], '-') !== false) {
                // 查询传入的子订单编号的记录，获取其颜色备注
                $cklist = \db('工单_印件资料')
                    ->field('子订单编号, ck_rq, 颜色备注')
                    ->where('子订单编号', $params['order_id'])
                    ->find();

                if ($cklist) {
                    if (!empty($cklist['ck_rq'])) {
                        $this->error('该子订单已完成出库操作，请勿重复操作。');
                    } else {
                        // 获取相同颜色备注的所有子订单记录
                        $sameColorList = \db('工单_印件资料')
                            ->field('子订单编号, ck_rq')
                            ->where('颜色备注', $cklist['颜色备注'])
                            ->whereNull('ck_rq') // 只选择未出库的记录
                            ->select();

                        // 开始出库操作
                        $updateCount1 = 0;
                        foreach ($sameColorList as $item) {
                            // 更新 '工单_印件资料' 表中所有相同颜色备注的子订单的出库日期
                            $result1 = \db('工单_印件资料')
                                ->where('子订单编号', $item['子订单编号'])
                                ->update(['ck_rq' => date("Y-m-d H:i:s")]);

                            if ($result1 !== false) {
                                $updateCount1 += $result1;
                            }
                        }

                        // 检查 '工单_基本资料' 表的 '出库日期' 是否为空
                        $order = explode('-', $params['order_id'])[0];
                        $basicInfo = \db('工单_基本资料')
                            ->field('出库日期')
                            ->where('订单编号', $order)
                            ->find();

                        $updateCount2 = 0;
                        if (empty($basicInfo['出库日期'])) {
                            // 如果 '出库日期' 为空，则更新
                            $jbzl = \db('工单_基本资料')
                                ->where('订单编号', $order)
                                ->fetchSql(true)
                                ->update(['出库日期' => date("Y-m-d H:i:s")]);
                            $result2 = \db()->query($jbzl);
                            if ($result2 !== false) {
                                $updateCount2 = $result2;
                            }
                        }
//                        if ($updateCount1 > 0) {
//                            // 插入日志
//                            foreach ($sameColorList as $item) {
//                                $addlist = [
//                                    'order_id' => $item['子订单编号'],
//                                    'rq' => date("Y-m-d H:i:s"),
//                                    'name' => $params['code'],
//                                    'sys_id' => $params['sys_id']
//                                ];
//                                \db('设备_报工日志')->insertGetId($addlist);
//                            }
//                            $this->success("出库成功");
//                        } else {
//                            $this->error('出库失败');
//                        }
                    }
                } else {
                    $this->error('未找到对应的出库订单');
                }
            } else {
                $this->error('请扫描子订单编号进行出库');
            }
        }

        // 处理恢复逻辑
        else if ($params['code'] == '恢复') {
            $cklist = \db('工单_印件资料')
                ->field('子订单编号, ck_rq')
                ->where('子订单编号', $params['order_id'])
                ->find();

            if (!empty($cklist['ck_rq'])) {
                $result1 = \db('工单_印件资料')
                    ->where('子订单编号', $params['order_id'])
                    ->fetchSql(true)
                    ->update(['ck_rq' => null]);
                $updateCount1 = \db()->query($result1);

                // 更新 '工单_基本资料' 表
                $order = explode('-', $params['order_id'])[0];
                $result2 = \db('工单_基本资料')
                    ->where('订单编号', $order)
                    ->fetchSql(true)
                    ->update(['出库日期' => null,'gd_statu'=>'1-计划中']);
                $updateCount2 = \db()->query($result2);

//                if ($updateCount1 > 0 && $updateCount2 > 0) {
//                    // 插入日志
//                    $addlist = [
//                        'order_id' => $params['order_id'],
//                        'rq' => date("Y-m-d H:i:s"),
//                        'name' => $params['code'],
//                        'sys_id' => $params['sys_id']
//                    ];
//                    \db('设备_报工日志')->insertGetId($addlist);
//                    $this->success($params['order_id'] . "恢复未出库");
//                } else {
//                    $this->error($params['order_id'] . '该子订单是未出库状态，无需再次恢复');
//                }
            } else {
                $this->error('该子订单是未出库状态，无需再次恢复');
            }
        }
    }

    /**
     * 裁剪完工报工修改工单_印件资料表一条数据
     *
     */
    public function getInfo(){
        if (!$this->request->isPost()) {
            $this->error('非法请求');
        }
        $params = $this->request->param();
        // 检查子订单编号和日期是否都存在
        if (!isset($params['order_id']) || empty($params['order_id'])) {
            $this->error('参数错误，子订单编号不能为空');
        }
        if (!isset($params['rq']) || empty($params['rq'])) {
            $this->error('参数错误，日期不能为空');
        }
        function setIfNotEmpty($value) {
            return (!empty($value) && $value != 0) ? $value : '';
        }
        // 先查询当前记录的原始数据
        $existingData = \db('工单_印件资料')
            ->where('子订单编号', $params['order_id'])
//            ->where(function($query) {
//                $query->whereNull('Mod_rq')->whereOr('Mod_rq', '');
//            }) // 查询未删除数据
//            ->order('子订单编号 desc')
            ->find();

        if ($existingData) {
            // 计算新的累加值
            $updateData = [
                'sc_rq' => date('Y-m-d H:i:s'),//生产报工日期
                'scsl1' => isset($params['scsl1']) && is_numeric($params['scsl1']) ? $existingData['scsl1'] + $params['scsl1'] : $existingData['scsl1'] + 0,
                'scsl2' => isset($params['scsl2']) && is_numeric($params['scsl2']) ? $existingData['scsl2'] + $params['scsl2'] : $existingData['scsl2'] + 0,
                'scsl3' => isset($params['scsl3']) && is_numeric($params['scsl3']) ? $existingData['scsl3'] + $params['scsl3'] : $existingData['scsl3'] + 0,
                'scsl4' => isset($params['scsl4']) && is_numeric($params['scsl4']) ? $existingData['scsl4'] + $params['scsl4'] : $existingData['scsl4'] + 0,
                'scsl5' => isset($params['scsl5']) && is_numeric($params['scsl5']) ? $existingData['scsl5'] + $params['scsl5'] : $existingData['scsl5'] + 0,
                'scsl6' => isset($params['scsl6']) && is_numeric($params['scsl6']) ? $existingData['scsl6'] + $params['scsl6'] : $existingData['scsl6'] + 0,
                'scsl7' => isset($params['scsl7']) && is_numeric($params['scsl7']) ? $existingData['scsl7'] + $params['scsl7'] : $existingData['scsl7'] + 0,
                'scsl8' => isset($params['scsl8']) && is_numeric($params['scsl8']) ? $existingData['scsl8'] + $params['scsl8'] : $existingData['scsl8'] + 0,
                'scsl9' => isset($params['scsl9']) && is_numeric($params['scsl9']) ? $existingData['scsl9'] + $params['scsl9'] : $existingData['scsl9'] + 0,
                'scsl10' => isset($params['scsl10']) && is_numeric($params['scsl10']) ? $existingData['scsl10'] + $params['scsl10'] : $existingData['scsl10'] + 0,
                'sctotal' => isset($params['sctotal']) && is_numeric($params['sctotal']) ? $existingData['sctotal'] + $params['sctotal'] : $existingData['sctotal'] + 0,
                // 你可以在这里继续添加其他字段
            ];

            $updateCount = \db('工单_印件资料')
                ->where('子订单编号', $params['order_id'])
                ->fetchSql(true)
//                ->where(function($query) {
//                    $query->whereNull('Mod_rq')->whereOr('Mod_rq', '');
//                }) // 查询未删除数据
                ->update($updateData);
            $list_gd = \db()->query($updateCount);
        } else {
            echo "没有找到相关记录";
        }
        // 检查更新结果
        if ($list_gd > 0) {
            $this->success("更新成功");
        } else {
            // 查询数据库，是否能找到对应的子订单编号
            $existingRecord = \db('工单_印件资料')
                ->where('子订单编号', $params['order_id'])
//                ->where('UniqId', $params['UniqId'])
                ->find();
            if ($existingRecord) {
                $this->error('更新失败，可能是提供的更新数据与现有数据相同，未进行任何更改');
            } else {
                $this->error('更新失败，未找到对应的子订单编号');
            }
        }
    }

    /**
     * 手工、大烫、总检、包装完工报工【通用的报工操作函数】
     */
    function reportWork($params) {
        // 查询设备_产量计酬表的数据
        $bglist = \db('设备_产量计酬')->field('订单编号,子订单编号,数量,ci_num,款号,sys_rq,serial,serial_num')
            ->where('UniqId', $params['UniqId'])->fetchSql(true)->find();
        $list_gd = \db()->query($bglist);

        // 查询工单基本资料表的数据
        $orderlist = \db('工单_基本资料')->where('订单编号', $list_gd[0]['订单编号'])->find();

        // 检查code是否为 "包装"
        if ($params['code'] == '包装') {
            // 如果是 "包装"，则增加工单基本资料表中的入仓数量
            $addorder['工单入仓数量'] = $orderlist['工单入仓数量'] + $params['sl'];
            $result = \db('工单_基本资料')->where('订单编号', $list_gd[0]['订单编号'])->fetchSql(true)->update($addorder);
            $sql = \db()->query($result);
        }

        // 构建单条记录的函数，传递 $list_gd 作为参数
        function buildRecords($item, $list_gd) {
            return [
                '订单编号' => $item['order'],
                '子订单编号' => $item['order_id'],
                '款号' => $list_gd[0]['款号'],
                'serial' => $list_gd[0]['serial'],
                'serial_num' => $list_gd[0]['serial_num'],
                '工序编号' => $item['gx'],
                '工序名称' => $item['gxmc'],
                '尺码' => $item['cm'],
                '数量' => $item['sl'],
                'sczl_jtbh' => $item['sczl_jtbh'],
                'sczl_bh' => $item['sczl_bh'],
                '尾包' => $item['wb'],
                'sys_id' => $item['sys_id'],
                'sys_rq' => date('Y-m-d H:i:s'),
                'sczl_rq' => date('Y-m-d'),
                'ci_num' => $item['ci_num'] - $item['s_num'],
                's_num' => $item['s_num'],
            ];
        }

        // 检查是否是索引数组（多条记录）
        if (isset($params[0]) && is_array($params[0])) {
            foreach ($params as $item) {
                $list[] = buildRecords($item, $list_gd);
            }
        } else {
            // 处理单条记录
            $list[] = buildRecords($params, $list_gd);
        }

        // 插入数据到设备_产量计酬表
        $result = \db('设备_产量计酬')->insertAll($list);
        if ($result) {
            $this->success('数据插入成功 : ' . date('H:i:s'));
        } else {
            $this->error('数据插入失败');
        }
    }

    /**
     * 裁剪新增、车缝新增、手工新增、大烫新增、总检新增、包装新增
     * /work_order_spot_check/search
     */
    public function search(){
        if (!$this->request->isPost()) {
            $this->error('非法请求');
        }
        $params = $this->request->param();
        if($params['order_id'] == ''){
            $this->error('请扫描订单后再报工');
        }
        // 根据不同的 code 值执行不同的逻辑
        switch ($params['code']) {
            case '裁剪':
                $order_id = explode('-', $params['order_id']);
                $order = $order_id[0];
                //先查询这条订单是否存在
                $sql = \db('工单_基本资料')->where('订单编号', $order)->fetchSql(true)->find();
                $order_list = \db()->query($sql);
                if (empty($order_list)) {
                    $this->error('没有找到对应的订单信息');
                    return;
                }

                //将前端传过来的数据存到数据库
                $insertData = [];
                $dataList = isset($params[0]) && is_array($params[0]) ? $params : [$params];
                foreach ($dataList as $item) {
                    $list = [
                        '订单编号' => $order_list[0]['订单编号'],
                        '款号'    => $order_list[0]['生产款号'],
                        '子订单编号' => $item['order_id'],
                        '工序编号'  => '2',
                        '工序名称'  => '裁剪',
                        '尺码'    => $item['cm'],
                        '数量'    => $item['sl'],
                        'sczl_jtbh' => $item['sczl_jtbh'],
                        'sys_id'  => $item['sys_id'],
                        'sczl_bh' => $item['sczl_bh'],
                        'sczl_rq'  => date('Y-m-d 00:00:00'),
                        'sys_rq'  => date('Y-m-d H:i:s')
                    ];
                    $insertData[] = $list;
                }
                $result = \db('设备_产量计酬')->insertAll($insertData);
                $result ? $this->success('数据批量插入成功 : ' . date('H:i:s')) : $this->error('数据插入失败');
                break;
            case '车缝':
                $list = [];
                $order_id = explode('-', $params['order_id']);
                $order = $order_id[0];
                $sql = \db('工单_基本资料')->where('订单编号', $order)->fetchSql(true)->find();
                $list_gd = \db()->query($sql); // 查询的结果可能是多条记录，确保是数组

                // 查询子订单编号对应的最大 serial 值
                $list_order_id = \db('设备_产量计酬')
                    ->field('子订单编号, MAX(serial) as serial')
                    ->where('子订单编号',  $params['order_id'])
                    ->where(function($query) {
                        $query->whereNull('mod_rq')->whereOr('mod_rq', '');
                    }) // 查询未删除数据
                    ->group('子订单编号')
                    ->find();

                function buildRecord($item, $list_gd, $list_order_id) {
                    return [
                        '订单编号' => $list_gd[0]['订单编号'],
                        '款号' => $list_gd[0]['生产款号'],
                        '子订单编号' => $item['order_id'],
                        '工序编号' => 3,
                        '工序名称' => '车缝',
                        'serial' => $item['serial'],
                        'ci_num' => (int)$item['sl'],
                        'serial_num' => $item['serial_num'],
                        '尺码' => $item['cm'],
                        '数量' => (int)$item['sl'],
                        'sczl_jtbh' => $item['sczl_jtbh'],
                        'sys_rq' => date('Y-m-d H:i:s'),
                        'sczl_rq' => date('Y-m-d'),
                        '尾包' => $item['wb'],
                        'sys_id' => $item['sys_id'],
                        'sczl_bh' => $item['sczl_bh']
                    ];
                }
                if (isset($params[0]) && is_array($params[0])) {
                    foreach ($params as $item) {
                        $list[] = buildRecord($item, $list_gd, $list_order_id); // 所有记录使用相同的 serial
                    }
                } else {
                    // 处理单条记录
                    $list[] = buildRecord($params, $list_gd, $list_order_id); // 单条记录
                }
                $result = \db('设备_产量计酬')->insertAll($list);

                if ($result) {
                    $this->success('数据插入成功 : ' . date('H:i:s'));
                } else {
                    $this->error('数据插入失败');
                }
                break;
            case '手工':
            case '大烫':
            case '总检':
            case '包装':

                //调用reportWork方法名函数
                $this->reportWork($params);
                break;
            default:
                $this->error('无效的 code 参数');
                break;
        }
    }


    /**
     * 物理地址获取机台编号
     * /work_order_spot_check/getMachineMac
     */
    public function getMachineMac(){
        if ($this->request->isGet() == false){$this->error('非法请求');}
        $params = $this->request->get();
        if (empty($params['sys_sbID'])){$this->error('物理地址参数不能为空');}

        $data = \db('设备_基本资料')->where('sys_sbID', $params['sys_sbID'])
            ->field('设备编号 as 机台号,生产工序,工序,rtrim(设备编组) as 组别,组长,sys_sbID')
//            ->where('生产工序',$params['code'])
            ->find();
        $this->success('请求成功', $data);
    }

    /**
     * 删除报工记录
     * /work_order_spot_check/del
     */
//    public function del() {
//        if (!$this->request->isGet()) {
//            return $this->error('请求错误');
//        }
//
//        $param = $this->request->param();
//        if (empty($param['UniqId'])) {
//            return $this->error('UniqId参数错误');
//        }
//
//        // 将 $param['UniqId'] 的值按逗号分割成数组
//        $printIdArray = explode(',', $param['UniqId']);
//
//        // 如果是裁剪工序
//        if (isset($param['sys_id']) && strpos($param['sys_id'], '裁剪') !== false) {
//            // 初始化失败计数器
//            $failureCount = 0;
//
//            // 开启事务
//            \db()->startTrans();
//            try {
//                foreach ($printIdArray as $uniqId) {
//                    // 根据 UniqId 查询 设备_产量计酬 表中的订单编号、尺码和数量
//                    $result = \db('设备_产量计酬')->where('UniqId', $uniqId)
//                        ->field('子订单编号,订单编号,尺码,数量,sczl_bh')
//                        ->find();
//
//                    // 如果未查询到数据，跳过
//                    if (!$result) {
//                        $failureCount++;
//                        continue;
//                    }
//
//                    // 根据订单编号查询工单_印件资料表，并排除有修改日期的记录
//                    $yresult = \db('工单_印件资料')->where('子订单编号', $result['子订单编号'])
//                        ->whereNull('Mod_rq')
//                        ->find();
//
//                    // 处理 yresult 中的尺码
//                    $size = $result['尺码'];
//                    $quantity = $result['数量'];
//                    $updateData = [];
//                    for ($i = 1; $i <= 10; $i++) {
//                        $cmField = 'cm' . $i;
//                        $scslField = 'scsl' . $i;
//                        if (isset($yresult[$cmField]) && $yresult[$cmField] === $size) {
//                            if (isset($yresult[$scslField])) {
//                                $yresult[$scslField] -= $quantity;
//                                if ($yresult[$scslField] < 0) {
//                                    $yresult[$scslField] = 0;
//                                }
//                                $updateData[$scslField] = $yresult[$scslField];
//                            }
//                            break;
//                        }
//                    }
//
//                    // 更新工单_印件资料表
//                    $newTotal = 0;
//                    for ($i = 1; $i <= 10; $i++) {
//                        $scslField = 'scsl' . $i;
//                        if (isset($yresult[$scslField])) {
//                            $newTotal += $yresult[$scslField];
//                        }
//                    }
//
//                    \db('工单_印件资料')
//                        ->where('子订单编号', $result['子订单编号'])
//                        ->update(['sctotal' => $newTotal] + $updateData);
//
//                    // 更新设备_产量计酬表
//                    $updateData = [
//                        'mod_rq' => date('Y-m-d H:i:s'),
//                        'delsys_id' => $param['sys_id']
//                    ];
//                    $updateResult = \db('设备_产量计酬')->where('UniqId', $uniqId)->update($updateData);
//
//                    // 如果更新失败，记录失败
//                    if ($updateResult === false) {
//                        $failureCount++;
//                    }
//                }
//
//                // 提交事务
//                \db()->commit();
//
//            } catch (\Exception $e) {
//                // 发生异常时回滚
//                \db()->rollback();
//                return $this->error('操作失败：' . $e->getMessage());
//            }
//
//            // 返回操作结果
//            if ($failureCount === 0) {
//                return $this->success('删除成功');
//            } else {
//                return $this->error("操作完成，但有 {$failureCount} 条记录更新失败");
//            }
//        } else {
//
//            // 处理其他情况，跟上面的逻辑类似
//        }
//    }

    public function del() {
        // 判断请求方式是否为 GET
        if (!$this->request->isGet()) {
            return $this->error('请求错误');
        }

        // 获取请求参数
        $param = $this->request->param();

        // 检查 UniqId 参数是否存在
        if (empty($param['UniqId'])) {
            return $this->error('UniqId 参数错误');
        }

        // 将 UniqId 的值按逗号分割成数组
        $printIdArray = explode(',', $param['UniqId']);

        // 初始化失败计数器
        $failureCount = 0;

        // 开启事务
        \db()->startTrans();
        try {
            foreach ($printIdArray as $uniqId) {
                // 根据 UniqId 查询设备_产量计酬表中的数据
                $result = \db('设备_产量计酬')->where('UniqId', $uniqId)
                    ->field('子订单编号, 订单编号, 尺码, 数量, sczl_bh, 工序名称')
                    ->find();

                // 如果查询不到数据，跳过当前处理
                if (!$result) {
                    $failureCount++;
                    continue;
                }

                // 判断工序名称是否是“裁剪”
                if (isset($param['sys_id']) && strpos($param['sys_id'], '裁剪') !== false) {
                    // 如果工序名称包含“裁剪”，更新工单_印件资料表
                    $yresult = \db('工单_印件资料')->where('子订单编号', $result['子订单编号'])
                        ->whereNull('Mod_rq')  // 仅更新没有修改日期的记录
                        ->find();

                    // 如果没有查询到工单印件资料表的数据，跳过
                    if (!$yresult) {
                        $failureCount++;
                        continue;
                    }

                    // 处理尺码和数量更新
                    $size = $result['尺码'];
                    $quantity = $result['数量'];
                    $updateData = [];

                    // 遍历工单中的尺码字段（cm1 到 cm10），找到匹配的尺码
                    for ($i = 1; $i <= 10; $i++) {
                        $cmField = 'cm' . $i;
                        $scslField = 'scsl' . $i;
                        if (isset($yresult[$cmField]) && $yresult[$cmField] === $size) {
                            // 找到匹配的尺码后，更新对应的数量字段
                            if (isset($yresult[$scslField])) {
                                $yresult[$scslField] -= $quantity;
                                if ($yresult[$scslField] < 0) {
                                    $yresult[$scslField] = 0;  // 防止数量为负数
                                }
                                $updateData[$scslField] = $yresult[$scslField];
                            }
                            break;
                        }
                    }

                    // 计算更新后的总数量
                    $newTotal = 0;
                    for ($i = 1; $i <= 10; $i++) {
                        $scslField = 'scsl' . $i;
                        if (isset($yresult[$scslField])) {
                            $newTotal += $yresult[$scslField];
                        }
                    }

                    // 更新工单_印件资料表
                    \db('工单_印件资料')
                        ->where('子订单编号', $result['子订单编号'])
                        ->update(['sctotal' => $newTotal] + $updateData);
                }

                // 更新设备_产量计酬表
                $updateData = [
                    'mod_rq' => date('Y-m-d H:i:s'),
                    'delsys_id' => $param['sys_id']
                ];

                // 执行更新操作
                $updateResult = \db('设备_产量计酬')->where('UniqId', $uniqId)->update($updateData);

                // 如果更新失败，记录失败
                if ($updateResult === false) {
                    $failureCount++;
                }
            }

            // 提交事务
            \db()->commit();

        } catch (\Exception $e) {
            // 发生异常时回滚事务
            \db()->rollback();
            return $this->error('操作失败：' . $e->getMessage());
        }

        // 返回操作结果
        if ($failureCount === 0) {
            return $this->success('删除成功');
        } else {
            return $this->error("操作完成，但有 {$failureCount} 条记录更新失败");
        }
    }

    /**
     * 面料出库报工
     */
    public function outReport()
    {
        if ($this->request->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        foreach ($param as $item) {
            // 更新库存数据
            $Inventory = \db('物料_库存')
                ->where('批次号',$item['批次号'])
                ->field('库存数量,领用数量')
                ->find();
            $InventoryData = [
                '批次号'   =>  $item['批次号'],
                '关联号'   => $item['关联编号'],
                '物料编号' => $item['物料编码'],
                '物料名称' => $item['物料名称'],
                '领用数量' => $Inventory['领用数量'] + (float)$item['number'],
                '库存数量' => $Inventory['库存数量'] - (float)$item['number'],
                '实际门幅' => $item['实际门幅'],
                '单位'     => $item['单位'],
                '状态'     => 1,
                'departname'        => $item['departname'],
                'remark' => isset($item['remark']) ? $item['remark'] : '',
                'sys_id'   => $item['sys_id'],
                'sys_rq'   => date('Y-m-d H:i:s'),
            ];
            $sql = \db('物料_库存')->where('批次号',$item['批次号'])->fetchSql(true)->update($InventoryData);
            \db()->query($sql);

            // 记录入库报工日志
            $ReportData = [
                '批次号'       => $item['批次号'],
                'order_id'     => $item['order_id'],
                '款号'     => $item['款号'],
                '物料编码'     => $item['物料编码'],
                '物料名称'     => $item['物料名称'],
                '库存数量'     => $item['number'],
                'number'       => $item['number'],
                'rq'          => $item['rq'],
                'name'         => $item['name'],
                'sys_id'       => $item['sys_id'],
                'receipt_number' => $item['receipt_number'],
                '客户编号'     => $item['客户编号'],
                'departname'        => $item['departname'],
                'remark' => isset($item['remark']) ? $item['remark'] : '',
                '款式'        => $item['款式'],
                'sys_rq'      => date('Y-m-d H:i:s'),
            ];
            $sql = \db('设备_报工日志')->fetchSql(true)->insert($ReportData);
            \db()->query($sql);
        }
        $this->success('成功');
    }

    /**
     * 入库订单信息模糊查询
     */
    public function InputOrderSearch()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $list = \db('工单_基本资料')
            ->alias('a')
            ->join('工单_面料资料 b','a.订单编号 = b.BOM_工单编号')
            ->join('工单关联表 c','a.订单编号 = c.订单编号 AND b.BOM_物料编码 = c.物料编号')
            ->where('a.生产款号|a.订单编号|b.BOM_物料编码','like','%'.$param['search'].'%')
            ->where('a.Mod_rq',null)
            ->where('b.Mod_rq',null)
            ->field('a.订单编号,a.生产款号,a.客户编号,a.款式,a.订单数量,a.落货日期,a.接单日期,a.Sys_id as 创建人员,
            a.Sys_rq as 创建时间,b.BOM_颜色 as 颜色,b.BOM_物料编码 as 物料编码,b.BOM_物料名称 as 物料名称,GROUP_CONCAT(DISTINCT c.订单编号 SEPARATOR ",") AS 关联订单,c.关联编号')
            ->group('物料编码')
            ->order('a.订单编号 desc')
            ->select();
        if (empty($list)){
            $this->success('未找到相关订单信息');
        }else{
            $this->success('成功',$list);
        }
    }

    /**
     * 面料入库报工
     */
    public function inputStash()
    {
        if (!$this->request->isPost()) {
            $this->error('请求错误');
        }

        $param = Request::instance()->post();
        if (empty($param)) {
            $this->error('参数错误');
        }

        // 获取当前最大批次号
        $lastBatch = \db('物料_库存')
            ->field("批次号")
            ->orderRaw("CAST(SUBSTRING(批次号, 4) AS UNSIGNED) DESC")
            ->limit(1)
            ->value('批次号');

        $currentNumber = 0;
        if (!empty($lastBatch) && preg_match('/^PCH(\d+)$/i', $lastBatch, $match)) {
            $currentNumber = intval($match[1]);
        }

        foreach ($param as $item) {
            // 查找是否已有相同物料编号 + 关联号的库存记录
            $existingBatch = \db('物料_库存')
                ->where('物料编号', $item['物料编码'])
                ->whereNull('Mod_rq')
                ->where('关联号', $item['关联编号'])
                ->value('批次号');

            // 更新库存数据
            $Inventory = \db('物料_库存')
            ->where('批次号',$item['批次号'])
            ->field('库存数量,入仓总量')
            ->find();

            if ($existingBatch) {
                $BatchNumber = $existingBatch; // 已入库，使用原批次号
                $InventoryData = [
                '批次号'   =>  $item['批次号'],
                '关联号'   => $item['关联编号'],
                '物料编号' => $item['物料编码'],
                '物料名称' => $item['物料名称'],
                '入仓总量' => $Inventory['入仓总量'] + (float)$item['number'],
                '库存数量' => $Inventory['库存数量'] + (float)$item['number'],
                '实际门幅' => $item['实际门幅'],
                '单位'     => $item['单位'],
                '状态'     => 1,
                'departname'        => $item['departname'],
                'remark' => isset($item['remark']) ? $item['remark'] : '',
                'sys_id'   => $item['sys_id'],
                'sys_rq'   => date('Y-m-d H:i:s'),
            ];
            $sql = \db('物料_库存')->fetchSql(true)->where('批次号',$BatchNumber)->update($InventoryData);
            \db()->query($sql);
            } else {
                // 生成新批次号
                $currentNumber++;
                $BatchNumber = 'PCH' . $currentNumber;

                // 插入库存表
                $InventoryData = [
                    '批次号'       => $BatchNumber,
                    '关联号'       => $item['关联编号'],
                    '物料编号'     => $item['物料编码'],
                    '物料名称'     => $item['物料名称'],
                    '入仓总量'     => $item['number'],
                    '库存数量'     => $item['number'],
                    '单位'         => $item['单位'],
                    '实际门幅'     => $item['实际门幅'],
                    '状态'         => 1,
                    'departname'   => $item['departname'],
                    'remark'       => isset($item['remark']) ? $item['remark'] : '',
                    'sys_id'       => $item['sys_id'],
                    'sys_rq'       => date('Y-m-d H:i:s'),
                ];
                $sql = \db('物料_库存')->fetchSql(true)->insert($InventoryData);
                \db()->query($sql);
            }

            // 每条都写一条报工日志
            $ReportData = [
                '批次号'         => $BatchNumber,
                'order_id'       => $item['order_id'],
                '款号'           => $item['款号'],
                '物料编码'       => $item['物料编码'],
                '物料名称'       => $item['物料名称'],
                '库存数量'       => $item['number'],
                'number'         => $item['number'],
                'rq'             => $item['rq'],
                'name'           => $item['name'],
                'sys_id'         => $item['sys_id'],
                'receipt_number' => $item['receipt_number'],
                'departname'     => $item['departname'],
                'remark'         => isset($item['remark']) ? $item['remark'] : '',
                '客户编号'       => $item['客户编号'],
                '款式'           => $item['款式'],
                'sys_rq'         => date('Y-m-d H:i:s'),
            ];
            $sql = \db('设备_报工日志')->fetchSql(true)->insert($ReportData);
            \db()->query($sql);
        }

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

//    public function inputStash()
//    {
//        if (!$this->request->isPost()) {
//            $this->error('请求错误');
//        }
//        $param = Request::instance()->post();
//        if (empty($param)) {
//            $this->error('参数错误');
//        }
//            foreach ($param as $item) {
//                // 查询是否已存在批次号
//                $BatchNumber = \db('物料_库存')
//                    ->where('物料编号', $item['物料编码'])
//                    ->where('关联号', $item['关联编号'])
//                    ->value('批次号');
//
//                // 生成批次号
//                if (empty($BatchNumber)) {
//                    $LastNumber = \db('物料_库存')->order('批次号 DESC')->value('批次号');
//                    $BatchNumber = !empty($LastNumber) ? 'PCH' . ((int)substr($LastNumber, 3) + 1) : 'PCH1';
//
//                    // 物料_库存
//                    $InventoryData = [
//                        '批次号'   => $BatchNumber,
//                        '关联号'   => $item['关联编号'],
//                        '物料编号' => $item['物料编码'],
//                        '物料名称' => $item['物料名称'],
//                        '入仓总量' => $item['number'],
//                        '库存数量' => $item['number'],
//                        '单位'     => $item['单位'],
//                        '实际门幅' => $item['实际门幅'],
//                        '状态'     => 1,
//                        'departname'        => $item['departname'],
//                        'remark' => isset($item['remark']) ? $item['remark'] : '',
//                        'sys_id'   => $item['sys_id'],
//                        'sys_rq'   => date('Y-m-d H:i:s'),
//                    ];
//                    $sql = \db('物料_库存')->fetchSql(true)->insert($InventoryData);
//                    \db()->query($sql);
//                } else {
//                    // 更新库存数据
//                    $Inventory = \db('物料_库存')
//                        ->where('批次号', $BatchNumber)
//                        ->field('入仓总量,库存数量')
//                        ->find();
//                    $InventoryData = [
//                        '批次号'   =>  $item['批次号'],
//                        '关联号'   => $item['关联编号'],
//                        '物料编号' => $item['物料编码'],
//                        '物料名称' => $item['物料名称'],
//                        '入仓总量' => $Inventory['入仓总量'] + $item['number'],
//                        '库存数量' => $Inventory['库存数量'] + $item['number'],
//                        '实际门幅' => $item['实际门幅'],
//                        '单位'     => $item['单位'],
//                        '状态'     => 1,
//                        'departname'        => $item['departname'],
//                        'remark' => isset($item['remark']) ? $item['remark'] : '',
//                        'sys_id'   => $item['sys_id'],
//                        'sys_rq'   => date('Y-m-d H:i:s'),
//                    ];
//                    $sql = \db('物料_库存')->fetchSql(true)->where('批次号',$BatchNumber)->update($InventoryData);
//                    \db()->query($sql);
//                }
//
//                // 记录入库报工日志
//                $ReportData = [
//                    '批次号'       => $BatchNumber,
//                    'order_id'     => $item['order_id'],
//                    '款号'     => $item['款号'],
//                    '物料编码'     => $item['物料编码'],
//                    '物料名称'     => $item['物料名称'],
//                    '库存数量'     => $item['number'],
//                    'number'       => $item['number'],
//                    'rq'          => $item['rq'],
//                    'name'         => $item['name'],
//                    'sys_id'       => $item['sys_id'],
//                    'receipt_number' => $item['receipt_number'],
//                    'departname'        => $item['departname'],
//                    'remark' => isset($item['remark']) ? $item['remark'] : '',
//                    '客户编号'     => $item['客户编号'],
//                    '款式'        => $item['款式'],
//                    'sys_rq'      => date('Y-m-d H:i:s'),
//                ];
//                $sql = \db('设备_报工日志')->fetchSql(true)->insert($ReportData);
//                \db()->query($sql);
//            }
//            $this->success('成功');
//    }


    /**
     * 出库订单信息查询
     */
    public function OutOrderSearch()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $list = \db('工单_基本资料')
            ->alias('a')
            ->join('工单_面料资料 b','a.订单编号 = b.BOM_工单编号')
            ->join('物料_库存 c','b.BOM_物料编码 = c.物料编号','left')
            ->join('工单关联表 d','a.订单编号 = d.订单编号 AND d.物料编号 = b.BOM_物料编码')
            ->where('a.生产款号|a.订单编号|b.BOM_物料编码','like','%'.$param['search'].'%')
            ->where('a.Mod_rq',null)
            ->where('b.Mod_rq',null)
            ->where('c.状态',1)
            ->field('a.订单编号,a.生产款号,a.客户编号,a.款式,a.订单数量,a.落货日期,a.接单日期,a.Sys_id as 创建人员,
            a.Sys_rq as 创建时间,b.BOM_颜色 as 颜色,b.BOM_物料编码 as 物料编码,b.BOM_物料名称 as 物料名称,c.批次号,d.关联编号')
            ->order('a.订单编号 desc')
            ->select();
        if (empty($list)){
            $this->success('未找到相关订单信息');
        }else{
            $this->success('成功',$list);
        }
    }

    /**
     * 获取入库面料信息
     */
    public function getInputDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $list = \db('工单_面料资料')
            ->alias('b')
            ->join('物料_库存 a','a.物料编号 = b.BOM_物料编码 AND a.物料名称 = b.BOM_物料名称','left')
            ->join('工单关联表 c','b.BOM_物料编码 = c.物料编号 AND b.BOM_工单编号 = c.订单编号')
            ->field('a.批次号,c.关联编号,b.BOM_物料编码,b.BOM_物料名称,a.入仓总量,a.库存数量,a.领用数量,a.退还数量,a.单位,a.实际门幅,
            a.departname,
            b.BOM_工单编号,b.BOM_颜色,b.BOM_计划门幅 as 计划门幅,b.BOM_定额门幅,b.BOM_计划用量 as 计划用料,b.BOM_标准用量 as 定额用料')
            ->where('c.关联编号',$param['关联编号'])
            ->where('c.订单编号',$param['订单编号'])
            ->where('b.BOM_物料编码',$param['物料编码'])
            ->find();
        $orderList = \db('工单关联表')
            ->where('关联编号',$param['关联编号'])
            ->column('GROUP_CONCAT(DISTINCT 订单编号 SEPARATOR ",") AS 关联订单');
        $list['关联订单'] = $orderList[0];
        $this->success('成功',$list);
    }

    /**
     * 裁剪面料退货包工
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function TuihuoReport()
    {
        if ($this->request->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        foreach ($param as $item) {
            // 查询库存数据
            $number = \db('物料_库存')
                ->where('批次号', $item['批次号'])
                ->where('关联号', $item['关联编号'])
                ->where('物料编号', $item['物料编码'])
                ->whereNull('Mod_rq')
                ->field('库存数量, 退还数量')
                ->find();

            // 根据类型调整库存
            if ($item['type'] === '退仓') {
                $returnQuantity = $number['退还数量'] + (float)$item['number'];
                $stockQuantity  = $number['库存数量'] + (float)$item['number'];
            } elseif ($item['type'] === '退厂商') {
                $returnQuantity = $number['退还数量'];
                $stockQuantity = $number['库存数量'] - (float)$item['number'];
            } elseif ($item['type'] === '销售') {
                $returnQuantity = $number['退还数量'];
                $stockQuantity = $number['库存数量'] - (float)$item['number'];
            }elseif ($item['type'] === '退客户') {
                $returnQuantity = $number['退还数量'];
                $stockQuantity = $number['库存数量'] - (float)$item['number'];
            }else{
                $returnQuantity = $number['退还数量'];
                $stockQuantity = $number['库存数量'] ; 
            }

            // 构建库存数据
            $inventoryData = [
                '批次号'   => $item['批次号'],
                '关联号'   => $item['关联编号'],
                '物料编号' => $item['物料编码'],
                '物料名称' => $item['物料名称'],
                '实际门幅' => $item['实际门幅'],
                '单位'     => $item['单位'],
                '状态'     => 1,
                'sys_id'   => $item['sys_id'],
                'departname'  => $item['departname'],
                'remark' => isset($item['remark']) ? $item['remark'] : '',
                'sys_rq'   => date('Y-m-d H:i:s'),
                '退还数量' => $returnQuantity,
                '库存数量' => $stockQuantity,
            ];
            $InventorySql = \db('物料_库存')
                ->where('批次号',$item['批次号'])
                ->where('关联号',$item['关联编号'])
                ->where('物料编号',$item['物料编码'])
                ->whereNull('Mod_rq')
                ->fetchSql(true)
                ->update($inventoryData);
            \db()->query($InventorySql);

            // 记录入库报工日志
            $ReportData = [
                '批次号'       => $item['批次号'],
                'order_id'     => $item['order_id'],
                '款号'     => $item['款号'],
                '物料编码'     => $item['物料编码'],
                '物料名称'     => $item['物料名称'],
                '库存数量'     => $item['number'],
                'number'       => $item['number'],
                'rq'          => $item['rq'],
                'name'         => $item['name'],
                'sys_id'       => $item['sys_id'],
                'receipt_number' => $item['receipt_number'],
                'departname'  => $item['departname'],
                'remark' => isset($item['remark']) ? $item['remark'] : '',
                '客户编号'     => $item['客户编号'],
                '款式'        => $item['款式'],
                'type' =>  $item['type'],
                'sys_rq'      => date('Y-m-d H:i:s'),
            ];
            $sql = \db('设备_报工日志')->fetchSql(true)->insert($ReportData);
            \db()->query($sql);
        }
        $this->success('成功');
    }

}