";
//print_r($params);
//echo "
";die;
        if (empty($params['id']) || empty($params['gy_name'])) {
            $this->error('ID/工序名称不能为空');
        }

        $data = [
            'gy_name' => $params['gy_name'],
            'big_process' => $params['big_process'],
//            'part_sort' => $params['part_sort'],
            'gy_sort' => $params['gy_sort'],
            'standard_hour' => $params['standard_hour'] ?? 0,
            'standard_score' => $params['standard_score'] ?? 0,
            'difficulty_coef' => $params['difficulty_coef'] ?? 1,
            'sys_id' => $params['sys_id'],
            'updatetime' => date('Y-m-d H:i:s')
        ];

        $res = db('产品_工艺资料')
            ->where('id', $params['id'])
            ->whereNull('mod_rq')
            ->update($data);

        return $res !== false ? $this->success('修改成功') : $this->error('修改失败');
    }

    /**
     * 删除工艺资料
     */
    public function ProcessDelete()
    {
        if (!Request::instance()->isPost()) {
            $this->error('非法请求');
        }

        $id = input('id');
        if (empty($id)) {
            $this->error('请选择需要删除的数据');
        }

        $ids = explode(',', $id);

        $result = \db('产品_工艺资料')
            ->where('id', 'in', $ids)
            ->update(['mod_rq' => date('Y-m-d H:i:s')]);

        if ($result !== false) {
            $this->success('删除成功');
        } else {
            $this->error('删除失败');
        }
    }

    /**
     * 调整部件与工艺序号牌组
     */
    public function UpdataSort(){
        if (!Request::instance()->isPost()) {
            $this->error('非法请求');
        }

        $params = Request::instance()->param();

        $product_code = $params['product_code'];
        $sys_id       = $params['sys_id'];

        if (empty($product_code)) {
            $this->error('产品编号不能为空');
        }

        // ======================
        // 更新 产品_部件资料
        // ======================
        if (!empty($params['part_list']) && is_array($params['part_list'])) {
            foreach ($params['part_list'] as $item) {
                $id = $item['id'] ?? 0;
                if ($id <= 0) continue;

                // 🔥 把要更新的内容放变量里
                $updateData = [
                    'part_sort' => $item['part_sort'],
                    'part_name' => $item['part_name'],
                    'sys_id'  => $sys_id
                ];

                Db::name('产品_部件资料')
                    ->where('id', $id)
                    ->update($updateData);
            }
        }

        // ======================
        // 更新 产品_工艺资料
        // ======================
        if (!empty($params['process_list']) && is_array($params['process_list'])) {
            foreach ($params['process_list'] as $item) {
                $id = $item['id'] ?? 0;
                if ($id <= 0) continue;

                // 🔥 把要更新的内容放变量里
                $updateData = [
                    'gy_sort'        => $item['gy_sort'],
                    'gy_name'        => $item['gy_name'] ,
                    'big_process'    => $item['big_process'],
                    'standard_hour'  => $item['standard_hour'],
                    'standard_score' => $item['standard_score'],
                    'part_sort'      => $item['part_sort'],
                    'part_name'      => $item['part_name'],
                    'sys_id'       => $sys_id
                ];

                Db::name('产品_工艺资料')
                    ->where('id', $id)
                    ->update($updateData);
            }
        }

        $this->success('排序更新成功');
    }

    /**
     * Excel 导入 部件 + 工艺
     */
    public function ProcessExcel(){
        if (!Request::instance()->isPost()) {
            $this->error('非法请求');
        }

        $params = Request::instance()->param();
        $file = request()->file('file');

        // 1. 先判断文件是否存在
        if (empty($file)) {
            $this->error('请上传Excel文件');
        }

        // 2. 必传参数校验
        $product_code = $params['product_code'];
        $sys_id = $params['sys_id'];

        if (empty($product_code)) {
            $this->error('请选择产品后，再进行提交');
        }

        // 3. 正确获取文件扩展名（解决 getExtension 为空的问题）
        $fileInfo = $file->getInfo();
        $fileName = $fileInfo['name'];
        $ext = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));

        if (!in_array($ext, ['xlsx', 'xls'])) {
            $this->error('只支持 xls / xlsx 格式');
        }

        $file_path = $file->getRealPath();
        $data = [];

        if ($ext == 'xlsx') {
            $data = $this->readXlsx($file_path);
        } elseif ($ext == 'xls') {
            $data = $this->readXls($file_path);
        }

        // 4. 解析数据
        $rows = array_slice($data, 1);
        $insert_data = [];
        foreach ($rows as $row) {
            $part_name = trim($row[0] ?? '');
            $gy_name = trim($row[1] ?? '');
            if (empty($part_name) || empty($gy_name)) continue;

            $insert_data[] = [
                'part_name'        => $part_name,
                'gy_name'          => $gy_name,
                'big_process'      => trim($row[2] ?? ''),
                'standard_hour'    => floatval($row[3] ?? 0),
                'standard_score'   => floatval($row[4] ?? 0),
                'difficulty_coef'  => floatval($row[5] ?? 1),
            ];
        }

        if (empty($insert_data)) {
            $this->error('Excel 无有效数据');
        }

        // 5. 处理部件
        $part_map = [];
        $part_sort = 1;
        foreach ($insert_data as $item) {
            $name = $item['part_name'];
            if (!isset($part_map[$name])) {
                $part_map[$name] = $part_sort++;
            }
        }

        $part_all = [];
        foreach ($part_map as $name => $sort) {
            $part_all[] = [
                'product_code' => $product_code,
                'part_sort'    => $sort,
                'part_name'    => $name,
                'sys_id'       => $sys_id,
                'sys_rq'   => date('Y-m-d H:i:s'),
                'mod_rq'       => null
            ];
        }

        // 6. 处理工艺
        $gy_sort_map = [];
        $process_all = [];
        foreach ($insert_data as $item) {
            $part_sort = $part_map[$item['part_name']];
            $gy_sort_map[$part_sort] = isset($gy_sort_map[$part_sort]) ? $gy_sort_map[$part_sort] + 1 : 1;

            $process_all[] = [
                'product_code'    => $product_code,
                'part_sort'       => $part_sort,
                'part_name'       => $item['part_name'],
                'gy_sort'         => $gy_sort_map[$part_sort],
                'gy_name'         => $item['gy_name'],
                'big_process'     => $item['big_process'],
                'standard_hour'   => $item['standard_hour'],
                'standard_score'  => $item['standard_score'],
                'difficulty_coef' => $item['difficulty_coef'],
                'sys_id'          => $sys_id,
                'sys_rq'      => date('Y-m-d H:i:s'),
                'mod_rq'       => null
            ];
        }

echo "
";
print_r($part_all);
echo "
";die;
        // 7. 写入数据库（你可以按需注释）
        db('产品_部件资料')->where('product_code', $product_code)->update(['mod_rq' => date('Y-m-d H:i:s')]);
        db('产品_部件资料')->insertAll($part_all);

        db('产品_工艺资料')->where('product_code', $product_code)->update(['mod_rq' => date('Y-m-d H:i:s')]);
        db('产品_工艺资料')->insertAll($process_all);

        $this->success('导入成功', [
            '部件数量' => count($part_all),
            '工艺数量' => count($process_all)
        ]);
    }

    private function readXlsx($file)
    {
        if (!class_exists('ZipArchive')) {
            return [];
        }

        $zip = new \ZipArchive();
        if ($zip->open($file) !== true) {
            return [];
        }

        // 读取工作表内容和共享字符串
        $content = $zip->getFromName('xl/worksheets/sheet1.xml');
        $strings = $zip->getFromName('xl/sharedStrings.xml');
        $zip->close();

        // 解析共享字符串
        $str_map = [];
        if ($strings) {
            preg_match_all('/]*>([^<]+)<\/t><\/si>/s', $strings, $matches);
            $str_map = $matches[1] ?? [];
        }

        $rows = [];
        // 解析每一行
        preg_match_all('/]*>(.*?)<\/row>/s', $content, $row_matches);
        foreach ($row_matches[1] as $row_xml) {
            $cols = array_fill(0, 6, ''); // 固定6列，防止错位
            $cellIndex = 0;

            // 解析单元格
            preg_match_all('/]*>(.*?)<\/c>/s', $row_xml, $cell_matches);
            foreach ($cell_matches[0] as $i => $cell_xml) {
                if ($cellIndex >= 6) break; // 只取前6列

                $cell_type = $cell_matches[1][$i] ?? '';
                $cell_inner = $cell_matches[2][$i] ?? '';
                $value = '';

                // 读取单元格值
                if (preg_match('/([^<]+)<\/v>/', $cell_inner, $v_match)) {
                    $value = $v_match[1];
                } elseif (preg_match('/([^<]+)<\/t>/', $cell_inner, $t_match)) {
                    $value = $t_match[1];
                }

                // 处理共享字符串
                if ($cell_type === 's' && isset($str_map[$value])) {
                    $value = $str_map[$value];
                }

                $cols[$cellIndex] = $value;
                $cellIndex++;
            }

            $rows[] = $cols;
        }

        return $rows;
    }

    private function readXls($file)
    {
        $data = file_get_contents($file);
        $rows = [];
        $len = strlen($data);
        $p = 0;

        while ($p < $len) {
            $id = ord($data[$p]);
            $size = unpack('v', substr($data, $p + 1, 2))[1];
            if ($id == 0x20) {
                $row = [];
                $sp = $p + 4;
                while ($sp < $p + $size) {
                    $type = ord($data[$sp]);
                    if ($type == 0x02) {
                        $val = substr($data, $sp + 3, 1);
                        $row[] = trim($val);
                        $sp += 8;
                    } else {
                        $sp++;
                    }
                }
                if (!empty($row)) $rows[] = $row;
            }
            $p += $size;
        }
        return $rows;
    }
}