mes-server-api/application/api/controller/OrderSuperLoss.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Cache;
use think\Exception;
use think\Log;
use think\Queue;
use \think\Request;
use \think\Db;
/**
 * 工单超节损核算接口
 */
class OrderSuperLoss extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * 首页-已核查成品编号
     *
     */
    public function index()
    {
        $this->success('请求成功');
    }
    /**
     * 获取左侧菜单栏
     * @ApiMethod GET
     */
    public function getTab()
    {
        if (Request::instance()->isGet() == false) {
            $this->error('非法请求');
        }
        $sql = "SELECT   
                    DATE_FORMAT(a.jjcp_sj, '%Y-%m') AS date,  -- Format the date for grouping  
                    RTRIM(b.`编号`) AS 编号,  
                    RTRIM(b.`名称`) AS 客户名称,  
                    COUNT(DISTINCT a.jjcp_gdbh) AS count   
                FROM   
                    `成品入仓` a  
                LEFT JOIN   
                    `物料_存货结构` b   
                    ON (CASE   
                            WHEN LEFT(a.`jjcp_cpdh`, 1) REGEXP '^[A-Za-z]' THEN LEFT(a.`jjcp_cpdh`, 5)   
                            ELSE LEFT(a.`jjcp_cpdh`, 4)   
                        END) = RTRIM(b.`编号`)  -- Conditional join based on the first character  
                
                WHERE   
                    a.jjcp_sj >= DATE_SUB(CURDATE(), INTERVAL 12 MONTH)  -- Direct date comparison  
                    AND (a.jjcp_smb IN ('末 板', '末板'))  -- Cleaner syntax for conditions  
                    AND a.`成品编码` != ''
                    AND a.jjcp_sj >= '2025-01-01 00:00:00'
                GROUP BY   
                    DATE_FORMAT(a.jjcp_sj, '%Y-%m'),  -- Group by formatted date  
                    RTRIM(b.`编号`)   
                ORDER BY   
                    date DESC,  
                    编号 ASC;";
        $data = Db::query($sql);
//        $data = \db('工单_质量考核汇总')
//            ->field([
//                'sys_ny AS date',
//                'CASE
//            WHEN 产品代号 REGEXP \'[A-Za-z]\' THEN LEFT(产品代号, 5)
//            ELSE LEFT(产品代号, 4)
//        END AS 编号',
//                '客户名称',
//                'COUNT(DISTINCT Gy0_gdbh) AS count'
//            ])
//            ->group('编号, date')
//            ->order('date desc,编号')
//            ->select();
        // 创建一个新数组来存储整理后的数据
        $organizedData = [];
        // 遍历原始数据
        foreach ($data as $entry) {
            $date = date('Ym',strtotime($entry['date']));

            // 检查日期是否在已整理数据中存在
            if (isset($organizedData[$date])) {
                // 如果日期存在，将数据追加到该日期下
                $organizedData[$date][] = [
                    '客户名称' => $entry['客户名称'],
                    '客户编号' => $entry['编号'],
                    'total' => $entry['count'],
                ];
                // 统计该日期下所有数据的总和
                $organizedData[$date]['total_count'] += $entry['count'];
            } else {
                // 如果日期不存在，创建新的日期项并添加数据
                $organizedData[$date] = [
                    [
                        '客户名称' => $entry['客户名称'],
                        '客户编号' => $entry['编号'],
                        'total' => $entry['count'],
                    ]
                ];
                // 初始化该日期的总和
                $organizedData[$date]['total_count'] = $entry['count'];
            }
        }

        // 将整理后的数据调整为以日期和相加的总和为索引的格式
        $finalData = [];
        foreach ($organizedData as $date => $entries) {
            $totalCount = $entries['total_count'];
            $index = $date . '-' . $totalCount;
            unset($entries['total_count']);
            $finalData[$index] = $entries;
        }
        $this->success('请求成功',$finalData);
    }
    /**
     * 获取超节损工单列表
     * @ApiMethod GET
     * @params string date
     * @params string code
     * 报废定额=（基础损耗+损耗率*计划产量）*损耗系数*计损色数（特定工序会有，如果无就不乘）
     * 允损比例=报废定额/计划产量
     * 目标合格率 = 100%-超节损工单中显示工序的允损比例之和
     * 节损奖 小盒0.02 大盒0.09
     *
     */
//    public function getList(){
//        if (Request::instance()->isGet() == false) {
//            $this->error('非法请求');
//        }
//        $params = Request::instance()->param();
//        $where = [];
//        if (!empty($params['code'])) {
//            if (!empty($params['search'])) {
//                $this->error('参数错误');
//            }
//        }
//        if (!empty($params['date'])) {
//            if (!empty($params['search'])) {
//                $this->error('参数错误');
//            }
//            $date_year = substr($params['date'],0,4);
//            $date_mon = substr($params['date'],4);
//            $date = $date_year.'-'.$date_mon;
//            $where['a.jjcp_sj' ] = array('like',$date.'%');
//        }
//        if (!empty($params['search'])) {
//            if (!empty($params['date']) || !empty($params['code'])) {
//                $this->error('参数错误');
//            }
//            $where['a.jjcp_gdbh|a.成品名称|a.jjcp_cpmc'] = array('like','%'.$params['search'].'%');
//        }
//        $where['a.jjcp_smb' ] = array('IN', array('末 板', '末板'));
//        $limit = $params['limit'];
//        if (empty($limit)){
//            $limit = 15;
//        }
//        $pages = $params['page'];
//        if (empty($pages)){
//            $pages = 1;
//        }
//        $is_have_cache = false;
//        $num = config('product_code_digit');
//        if ($is_have_cache === false){
//            if (!empty($params['code'])){
//                $sql= db('物料_收发记录')
//                    ->alias('d')
//                    ->where('d.仓库编号', 'Y101')
//                    ->whereOr('d.仓库编号', '101')
//                    ->group('d.st_gdbh, d.cpdh')
//                    ->field('d.st_gdbh, d.cpdh,d.st_rq, SUM(d.st_sl) as 实际投料,d.仓库编号')
//                    ->buildSql();
//                $data = db('成品入仓')->alias('a')
//                    ->join('工单_基本资料 b', 'a.jjcp_gdbh = b.Gd_gdbh', 'left')
//                    ->join('工单_印件资料 c', 'a.jjcp_gdbh = c.Yj_Gdbh AND a.jjcp_cpdh = c.yj_Yjdh', 'left')
//                    ->join([$sql => 'd'], 'a.jjcp_gdbh = d.st_gdbh AND a.jjcp_cpdh = d.cpdh', 'left')
//                    ->where($where)
//                    ->where(function($query) {
//                        $query->where('d.仓库编号', '101')
//                            ->whereOr('d.仓库编号', 'Y101');})
//                    ->whereRaw('LEFT(a.成品编码, CASE WHEN a.成品编码 REGEXP "[a-zA-Z]" THEN 5 ELSE 4 END) = ?', [$params['code']])
//                    ->field('a.jjcp_gdbh as Gd_gdbh, a.jjcp_yjno, rtrim(a.jjcp_cpdh) as 成品编码, rtrim(a.jjcp_cpmc) as 成品名称,
//             a.jjcp_sj, a.jjcp_smb, b.计量单位, b.Gd_khdh, d.实际投料, c.yj_Yjno, c.yj_ls, c.yj_ks, c.质量考核')
//                    ->group('a.jjcp_gdbh, a.jjcp_yjno')
//                    ->order('b.Gd_khdh, a.成品编码 asc, a.jjcp_yjno,d.st_rq desc')
//                    ->page($pages)
//                    ->limit($limit)
//                    ->select();
//                $total = db('成品入仓')->alias('a')
//                    ->join('工单_基本资料 b', 'a.jjcp_gdbh = b.Gd_gdbh','left')
//                    ->join('工单_印件资料 c', 'a.jjcp_gdbh = c.Yj_Gdbh','left')
//                    ->where($where)
//                    ->whereRaw('LEFT(a.成品编码, CASE WHEN a.成品编码 REGEXP "[a-zA-Z]" THEN 5 ELSE 4 END) = ?', [$params['code']])
//                    ->count();
//            }else{
//                $sql= db('物料_收发记录')
//                    ->alias('d')
//                    ->where('d.仓库编号', 'Y101')
//                    ->whereOr('d.仓库编号', '101')
//                    ->group('d.st_gdbh, d.cpdh')
//                    ->field('d.st_gdbh, d.cpdh,d.st_rq, SUM(d.st_sl) as 实际投料,d.仓库编号')
//                    ->buildSql();
//                $data = db('成品入仓')->alias('a')
//                    ->join('工单_基本资料 b', 'a.jjcp_gdbh = b.Gd_gdbh', 'left')
//                    ->join('工单_印件资料 c', 'a.jjcp_gdbh = c.Yj_Gdbh AND a.jjcp_cpdh = c.yj_Yjdh', 'left')
//                    ->join([$sql => 'd'], 'a.jjcp_gdbh = d.st_gdbh AND a.jjcp_cpdh = d.cpdh', 'left')
//                    ->where($where)
//                    ->field('a.jjcp_gdbh as Gd_gdbh, a.jjcp_yjno, rtrim(a.jjcp_cpdh) as 成品编码, rtrim(a.jjcp_cpmc) as 成品名称,
//             a.jjcp_sj, a.jjcp_smb, b.计量单位, b.Gd_khdh, d.实际投料, c.yj_Yjno, c.yj_ls, c.yj_ks, c.质量考核')
//                    ->group('a.jjcp_gdbh, a.jjcp_yjno')
//                    ->order('b.Gd_khdh, a.成品编码 asc, a.jjcp_yjno, d.st_rq desc')
//                    ->page($pages)
//                    ->limit($limit)
//                    ->select();
//                $total = db('成品入仓')->alias('a')
//                    ->join('工单_基本资料 b', 'a.jjcp_gdbh = b.Gd_gdbh','left')
//                    ->join('工单_印件资料 c', 'a.jjcp_gdbh = c.Yj_Gdbh','left')
//                    ->where($where)
//                    ->count();
//            }
//            foreach ($data as $key => $value){
//                //查出成品数量及日期
//                $cp_sql = "SELECT SUM(jjcp_sl) as cp_sl,MAX(jjcp_sj) as jjcp_sj FROM `成品入仓` WHERE jjcp_gdbh = '{$value['Gd_gdbh']}' AND jjcp_yjno = '{$value['jjcp_yjno']}' GROUP BY jjcp_gdbh,jjcp_yjno";
//                $cp_data = Db::query($cp_sql);
//                //入仓总数
//                $data[$key]['warehousing_num'] = $cp_data[0]['cp_sl'];
//                $data[$key]['warehousing_date'] = substr($cp_data[0]['jjcp_sj'],0,10);
//                //查出进入超节损的工序，有上报产量的工序就进入超节损
//                $gxh_sql = "SELECT sczl_gxh FROM
//                        (SELECT sczl_gxh FROM 设备_产量计酬 WHERE sczl_gdbh = '{$value['Gd_gdbh']}' AND sczl_yjno = '{$value['jjcp_yjno']}'
//                        UNION SELECT sczl_gxh FROM db_sczl WHERE sczl_gdbh = '{$value['Gd_gdbh']}' AND sczl_yjno = '{$value['jjcp_yjno']}') AS combined_result";
//                $gxh_arr = Db::query($gxh_sql);
//                $gxh_values = array_column($gxh_arr, 'sczl_gxh');
//                $gy_data =db('工单_工艺资料')
//                    ->alias('a')
//                    ->field([
//                        'a.Gy0_yjno', 'a.Gy0_gxh', 'RTRIM(a.Gy0_gxmc) as Gy0_gxmc','RTRIM(a.Add_gxmc) as Add_gxmc','a.Gy0_ks', 'a.Gy0_ls', 'a.Gy0_计划接货数',
//                        'a.Gy0_计划损耗', 'a.超节损承担比例','SUM(b.sczl_zcfp) as total_fp','SUM(b.sczl_cl) as total_cl','SUM(c.sczl_cl) as cl','SUM(c.sczl_fp) as fp',
//                    ])
//                    ->join('设备_产量计酬 b', 'a.Gy0_gdbh = b.sczl_gdbh AND a.Gy0_yjno = b.sczl_yjno AND a.Gy0_gxh = b.sczl_gxh','left')
//                    ->join('db_sczl c', 'a.Gy0_gdbh = c.sczl_gdbh AND a.Gy0_yjno = c.sczl_yjno AND a.Gy0_gxh = c.sczl_gxh','left')
//                    ->where([
//                        'a.Gy0_gdbh' => $value['Gd_gdbh'],
//                        'a.Gy0_yjno' =>$value['jjcp_yjno'],
//                        'a.Gy0_gxh' => ['in', $gxh_values]
//                    ])
//                    ->group('a.Gy0_yjno,a.Gy0_gxh')
//                    ->select();
//                $arr = [];
//                $plan_loss = [];//工单计划损耗
//                $machine_plan_loss = 0;//机检计划损耗
//                foreach ($gy_data as $k=>$v){
//                    if (strpos($v['Gy0_gxmc'],'检') === false){
//                        if ($v['Gy0_计划接货数'] > 0){
//                            $rate =  round($v['Gy0_计划损耗'] / $v['Gy0_计划接货数'],5);
//                        }else{
//                            $rate = 0;
//                        }
//                        $arr[$k] = floor($rate * 10000) /10000;
//                        $plan_loss[$k] = $v['Gy0_计划损耗']*$v['Gy0_ls']*$value['yj_ks'];
//                    }
//                }
//                if ((int)$value['yj_ls'] > 0){
//                    $value['实际投料'] = number_format(((int)$value['实际投料']/10000)*$value['yj_ls']*$value['yj_ks'],4);
//                }else{
//                    $value['实际投料'] = number_format($value['实际投料']/10000,4);
//                }
//                $data[$key]['实际投料'] = $value['实际投料'];
//                if ($value['实际投料'] >0 ){
//                    $target_rate =  (1-array_sum($arr))*100;
//                    $data[$key]['target_rate'] =$target_rate.'%'; //目标合格率
//                    $real_rate = $cp_data[0]['cp_sl'] / ((float)str_replace(',', '', $value['实际投料']) * 10000) *100;
//                    $data[$key]['real_rate'] = number_format($real_rate,2) . '%';//实际合格率
//                }else{
//                    $data[$key]['target_rate'] = ''; //目标合格率
//                    $data[$key]['real_rate'] = '';//实际合格率
//                }
//
//                //制程废品
//                $zzfp_data =db('设备_产量计酬')->where('sczl_gdbh',$value['Gd_gdbh'])->where('sczl_yjno',$value['jjcp_yjno'])->value('SUM(sczl_zcfp) as sczl_zcfp');
//                $data[$key]['zcfp'] = $zzfp_data * $value['yj_ls'];//制程废品
//                //废品合计
//                $wasteTotal = db('db_qczl')->where('qczl_gdbh',$value['Gd_gdbh'])->where('qczl_yjno',$value['jjcp_yjno'])->sum('qczl_fp');
//                if (empty($wasteTotal)){
//                    $wasteTotal = 0;
//                }
//                $data[$key]['废品合计'] = $wasteTotal + $data[$key]['zcfp'];//废品合计
//                $data[$key]['工单无形损'] = (int)((float)str_replace(',', '', $value['实际投料']) *10000) - $cp_data[0]['cp_sl'] - $data[$key]['废品合计'];//工单无形损
//                $out_sql = "SELECT fp_sl1,fp_sl2,fp_sl3,fp_sl4,fp_sl5,fp_sl6,fp_sl7,fp_sl8,fp_sl9,fp_sl10,fp_sl11,fp_sl12,fp_sl13,
//                        fp_lb1,fp_lb2,fp_lb3,fp_lb4,fp_lb5,fp_lb6,fp_lb7,fp_lb8,fp_lb9,fp_lb10,fp_lb11,fp_lb12,fp_lb13,
//                        fp_bh1,fp_bh2,fp_bh3,fp_bh4,fp_bh5,fp_bh6,fp_bh7,fp_bh8,fp_bh9,fp_bh10,fp_bh11,fp_bh12,fp_bh13,
//                        fp_gxmc1,fp_gxmc2,fp_gxmc3,fp_gxmc4,fp_gxmc5,fp_gxmc6,fp_gxmc7,fp_gxmc8,fp_gxmc9,fp_gxmc10,fp_gxmc11,fp_gxmc12,fp_gxmc13
//                        FROM db_qczl WHERE qczl_gdbh = '{$value['Gd_gdbh']}' AND  qczl_yjno = '{$value['jjcp_yjno']}'";
//                $waste_out = Db::query($out_sql);
//                $list = []; //外发废数组
//                $quality = [];//质检废数组
//                $material = [];//材料废数组
//                $change = [];//零头处理数组
//                $machine = [];//机检废品数组
//                $j = 0;
//                $m = 0;
//                $n = 0;
//                $l = 0;
//                $o = 0;
//                foreach ($waste_out as $entry) {
//                    for ($i = 1; $i <= 13; $i++) {
//                        $labelKey = "fp_lb" . $i;
//                        $bhKey = "fp_bh" . $i;
//                        $gxmcKey = "fp_gxmc" . $i;
//                        $slKey = "fp_sl" . $i;
//                        if (!empty($entry[$labelKey])) {
//                            //外发加工废
//                            if (substr($entry[$labelKey],0,3) == 'M04'){
//                                $list[$j]= $entry[$slKey];
//                                $j++;
//                            }
//                            //材料废
//                            if (substr($entry[$labelKey],0,1) == 'L' ){
//                                $material[$n]= $entry[$slKey];
//                                $n++;
//                            }
//                            //零头处理
//                            if (substr($entry[$labelKey],0,3) == 'M01' ){
//                                $change[$l]= $entry[$slKey];
//                                $l++;
//                            }
//
//                            //机检废品
//                            if (substr($entry[$labelKey],0,1) == 'K' ){
//                                $machine[$o]= $entry[$slKey];
//                                $o++;
//                            }
//                        }
//                        $quality[$m]= $entry[$slKey];
//                        $m++;
//                    }
//                }
//                $machine_waste = array_sum($machine);//机检废品
//                if ($data[$key]['Gd_gdbh'] == '2401746'){
//                    halt($machine_waste);
//                }
//                $data[$key]['工单计划损耗'] = array_sum($plan_loss);//工单计划损耗
//                /**
//                 * 奖惩系数及金额
//                 * 奖惩金额 = 工单节损数 * 0.02(0.09)
//                 * 工单节损数 = 工单计划损耗 - 废品总数 - 机检节损数
//                 * 机检节损数 = 机检计划损耗 - 机检质检废品
//                 */
//                $machine_loss = $machine_plan_loss - $machine_waste;
//                $order_loss = $data[$key]['工单计划损耗'] - ($data[$key]['废品合计'] - array_sum($list) - array_sum($material)+$data[$key]['工单无形损'] - $machine_waste);
//                $guige = \db('物料_存货编码')
//                    ->where('物料代码',$data[$key]['成品编码'])
//                    ->value('rtrim(规格)');
//                //工序超节损金额
//                if ($guige === '小盒'){
//                    $moneyRate = 0.02;
//                }else{
//                    $moneyRate = 0.09;
//                }
//                $reward = $order_loss * $moneyRate;
//                $data[$key]['reward_rate'] = '1';
//                if ($data[$key]['质量考核'] === 0){
//                    $data[$key]['reward_money'] = number_format($reward,2);
//                    $data[$key]['考核'] = '是';
//                }else{
//                    $data[$key]['reward_money'] = '';
//                    $data[$key]['考核'] = '否';
//                }
//                $data[$key]['材料废'] = array_sum($material); //材料废
//                $data[$key]['零头处理'] = array_sum($change); //零头处理
//                $data[$key]['外发废'] = array_sum($list);//外发废
//                $data[$key]['分摊废'] = '';//分摊废
//                $data[$key]['工单质检废'] =  array_sum($quality);  //质检废
//                $data[$key]['机检废'] = $machine_waste;
//            }
//            $res = [
//                'data'=>$data,
//                'total' => $total
//            ];
//
//        }
//        $this->success('请求成功',$res);
//    }
    /**
     * 获取工单超节损工艺
     * @ApiMethod GET
     * @params string order
     */
    public function getOrderSuperLossGy(){
        if (Request::instance()->isGet() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->param();
        if (!isset($params['order']) || empty($params['order'])) {
            $this->error('参数错误');
        }
        if (!isset($params['yjno']) || empty($params['yjno'])) {
            $this->error('参数错误');
        }
        $sql = "SELECT a.Gy0_gdbh,a.Gy0_yjno,a.Gy0_gxh,rtrim(a.Gy0_gxmc) as Gy0_gxmc,rtrim(a.Add_gxmc) as Add_gxmc,
                a.Gy0_ls,a.Gy0_Rate0,a.Gy0_Rate1,a.损耗系数,a.Gy0_ms,a.Gy0_计划接货数*a.Gy0_ls as Gy0_计划接货数,
                a.Gy0_计划损耗*a.Gy0_ls as Gy0_计划损耗,sum(b.sczl_cl) as total_cl,sum(b.sczl_zcfp) as total_fp,
                sum(c.sczl_cl) as cl,SUM(c.sczl_fp) as fp,rtrim(a.印刷方式) as 印刷方式,rtrim(a.版距) as 版距
                FROM `工单_工艺资料` a
                LEFT JOIN `设备_产量计酬` b ON a.Gy0_gdbh = b.sczl_gdbh AND a.Gy0_gxh = b.sczl_gxh
                LEFT JOIN `db_sczl` c ON a.Gy0_gdbh = c.sczl_gdbh AND a.Gy0_gxh = c.sczl_gxh
                WHERE a.Gy0_gdbh = '{$params['order']}' AND a.Gy0_yjno = '{$params['yjno']}' GROUP BY a.Gy0_gxh";
        $data = Db::query($sql);
        foreach ($data as $key=>$value){
            if (!empty($value['total_cl'])){
                $data[$key]['total_cl'] = $value['total_cl'] *$value['Gy0_ls'];
            }else{
                $data[$key]['total_cl'] =$value['cl'] *$value['Gy0_ls'];
            }
            if (!empty($value['total_fp'])){
                $data[$key]['total_fp'] = $value['total_fp'] *$value['Gy0_ls'];
            }else{
                $data[$key]['total_fp'] = $value['fp'] *$value['Gy0_ls'];
            }
            if ($value['印刷方式'] === '卷对卷'){
                $data[$key]['total_cl'] = ceil($data[$key]['total_cl'] / $value['版距']*1000);
                $data[$key]['total_fp'] = ceil($data[$key]['total_fp'] / $value['版距']*1000);
            }
            unset($data[$key]['cl']);
            unset($data[$key]['fp']);
        }
        $this->success('请求成功',$data);
    }
    /**
     * 工单超节损统计
     * @ApiMethod GET
     * @params string order
     * 节损奖 小盒0.02 大盒0.09
     */
    public function getOrderSuperLossCount(){
        if (Request::instance()->isGet() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->param();
        if (!isset($params['order']) || empty($params['order'])) {
            $this->error('参数错误');
        }
        $order = $params['order'];
        $field = 'a.Gd_gdbh,rtrim(a.成品代号) as 成品代号,rtrim(a.成品名称) as 成品名称,rtrim(a.销售订单号) as 销售订单号,a.订单数量,c.yj_ls as ls,c.yj_ks as ks,SUM(b.st_sl) as 投料';
        $data =db('工单_基本资料')
            ->alias('a')
            ->join('物料_收发记录 b','a.Gd_gdbh = b.st_gdbh AND a.Gd_cpdh = b.cpdh')
            ->join('工单_印件资料 c','c.Yj_Gdbh = a.Gd_gdbh AND c.yj_Yjdh = a.Gd_cpdh')
            ->where('a.Gd_Gdbh',$order)
            ->where('a.行号',$params['yjno'])
            ->where('c.yj_Yjno',$params['yjno'])
            ->where(function($query) {
                $query->where('b.仓库编号', '101')
                    ->whereOr('b.仓库编号', 'Y101');})
            ->field($field)
            ->find();
        if ($data['ls'] == 0){
            $data['ls'] === 1;
        }
        if ($data['ks'] == 0){
            $data['ks'] === 1;
        }
        $data['实际投料'] = number_format($data['投料'] * $data['ls'] * $data['ks'] / 10000, 4, '.', '');
        if($data['实际投料'] == 0){
            $this->error('投料数据为 0,请点击超节损页面“修正工单投料”按钮进行修正');
            return;
        }
        //查出成品数量及日期
        $cp_sql = "SELECT SUM(jjcp_sl) as cp_sl,MAX(jjcp_sj) as jjcp_sj FROM `成品入仓` WHERE jjcp_gdbh = '{$order}' AND jjcp_yjno = '{$params['yjno']}' GROUP BY jjcp_gdbh,jjcp_yjno";
        $cp_data = Db::query($cp_sql);
        if (empty($cp_data)){
            $this->success('此工单未查询到成品入库信息,请核查该工单是否已进入超节损');
        }
        $data['warehousing_num'] = $cp_data[0]['cp_sl'];
        $data['warehousing_date'] = substr($cp_data[0]['jjcp_sj'],0,10);
        //查出进入超节损的工序，有上报产量的工序就进入超节损
        $gxh_sql = "SELECT sczl_gxh FROM
                        (SELECT sczl_gxh FROM 设备_产量计酬 WHERE sczl_gdbh = '{$order}' AND sczl_yjno = '{$params['yjno']}'
                        UNION SELECT sczl_gxh FROM db_sczl WHERE sczl_gdbh = '{$order}' AND sczl_yjno = '{$params['yjno']}' AND sczl_gxmc like '%拆片%') AS combined_result";
        $gxh_arr = Db::query($gxh_sql);
        $gxh_values = array_column($gxh_arr, 'sczl_gxh');
        foreach ($gxh_values as $k=>$v){
            if ((int)$v < 10){
                $gxh_values[$k] = '0'.$v;
            }
        }
        $gy_data =db('工单_工艺资料')
            ->alias('a')
            ->field([
                'a.Gy0_yjno', 'a.Gy0_gxh', 'RTRIM(a.Gy0_gxmc) as Gy0_gxmc','RTRIM(a.Add_gxmc) as Add_gxmc','a.Gy0_ks', 'a.Gy0_ls', 'a.Gy0_计划接货数*a.Gy0_ls as Gy0_计划接货数',
                'a.Gy0_计划损耗', 'a.无形损承担比例','a.超节损承担比例','SUM(b.sczl_zcfp) as total_fp','SUM(b.sczl_cl) as total_cl','SUM(c.sczl_cl) as cl','SUM(c.sczl_fp) as fp',
            ])
            ->join('设备_产量计酬 b', 'a.Gy0_gdbh = b.sczl_gdbh AND a.Gy0_yjno = b.sczl_yjno AND a.Gy0_gxh = b.sczl_gxh','left')
            ->join('db_sczl c', 'a.Gy0_gdbh = c.sczl_gdbh AND a.Gy0_yjno = c.sczl_yjno AND a.Gy0_gxh = c.sczl_gxh','left')
            ->where([
                'a.Gy0_gdbh' => $order,
                'a.Gy0_yjno' => $params['yjno'],
                'a.Gy0_gxh' => ['in', $gxh_values]
            ])
            ->group('a.Gy0_yjno,a.Gy0_gxh')
            ->select();
        $arr = [];
        $plan_loss = [];//工单计划损耗
        foreach ($gy_data as $k=>$v){
            $rate =  round($v['Gy0_计划损耗'] / $v['Gy0_计划接货数'],5);
            $arr[$k] = floor($rate * 10000) /10000;
            $plan_loss[$k] = $v['Gy0_计划损耗'];
        }
        $target_rate =  (1-array_sum($arr))*100;
        $data['target_rate'] =$target_rate.'%'; //目标合格率
        $real_rate = $cp_data[0]['cp_sl'] / ((float)$data['实际投料'] * 10000) *100;
        $data['real_rate'] = number_format($real_rate,2) . '%';//实际合格率
        //制程废品
        $zzfp_data =db('设备_产量计酬')->where('sczl_gdbh',$order)->where('sczl_yjno',$params['yjno'])->value('SUM(sczl_zcfp) as sczl_zcfp');
        //联数
        $ls =db('工单_工艺资料')->where('Gy0_gdbh',$order)->field('Gy0_ls,Gy0_ks')->find();
        //制程废品*ls
        $data['zcfp'] = $zzfp_data * $ls['Gy0_ls'] * $ls['Gy0_ks'];
        //废品数量
        $wasteTotal = db('db_qczl')->where('qczl_gdbh',$order)->where('qczl_yjno',$params['yjno'])->sum('qczl_fp');
        if (empty($wasteTotal)){
            $wasteTotal = 0;
        }
        //废品合计
        $waste_total = $data['zcfp'] + $wasteTotal;
        //工单无形损
        $data['intangible_loss'] = (int)((float)$data['实际投料'] *10000 - $cp_data[0]['cp_sl'] - $waste_total);
        $out_sql = "SELECT fp_sl1,fp_sl2,fp_sl3,fp_sl4,fp_sl5,fp_sl6,fp_sl7,fp_sl8,fp_sl9,fp_sl10,fp_sl11,fp_sl12,fp_sl13,
                        fp_lb1,fp_lb2,fp_lb3,fp_lb4,fp_lb5,fp_lb6,fp_lb7,fp_lb8,fp_lb9,fp_lb10,fp_lb11,fp_lb12,fp_lb13, 
                        fp_bh1,fp_bh2,fp_bh3,fp_bh4,fp_bh5,fp_bh6,fp_bh7,fp_bh8,fp_bh9,fp_bh10,fp_bh11,fp_bh12,fp_bh13,
                        fp_gxmc1,fp_gxmc2,fp_gxmc3,fp_gxmc4,fp_gxmc5,fp_gxmc6,fp_gxmc7,fp_gxmc8,fp_gxmc9,fp_gxmc10,fp_gxmc11,fp_gxmc12,fp_gxmc13,UniqId
                        FROM db_qczl WHERE qczl_gdbh = '{$order}' AND qczl_yjno = '{$params['yjno']}'";
        $waste_out = Db::query($out_sql);
        $list = []; //外发废数组
        $quality = [];//质检废数组
        $material = [];//材料废数组
        $change = [];//零头处理数组
        $jijian = [];//机检数据
        $j = 0;
        $m = 0;
        $n = 0;
        $l = 0;
        $s = 0;
        foreach ($waste_out as $entry) {
            for ($i = 1; $i <= 13; $i++) {
                $labelKey = "fp_lb" . $i;
                $bhKey = "fp_bh" . $i;
                $gxmcKey = "fp_gxmc" . $i;
                $slKey = "fp_sl" . $i;
                if (!empty($entry[$labelKey])) {
                    //外发废
                    if (substr($entry[$labelKey],0,3) == 'M04'){
                        $list[$j]= $entry[$slKey];
                        $j++;
                    }
                    //材料废
                    if (substr($entry[$labelKey],0,1) == 'L' ){
                        $material[$n]= $entry[$slKey];
                        $n++;
                    }
                    //零头处理
                    if (substr($entry[$labelKey],0,3) == 'M01' ){
                        $change[$l]= $entry[$slKey];
                        $l++;
                    }

                    //机检数据
                    if (substr($entry[$labelKey],0,1) == 'K' ){
                        $jijian[$s]= $entry[$slKey];
                        $s++;
                    }
                }
                $quality[$m]= $entry[$slKey];
                $m++;
            }
        }
        $data['材料废'] = array_sum($material); //材料废
        $data['零头处理'] = array_sum($change); //零头处理
        $data['外发废'] = array_sum($list);//外发废
        $data['工单质检废'] =  array_sum($quality);//质检废
        $data['机检废品'] = array_sum($jijian);
        $plan_total =db('工单_工艺资料')
            ->where(['Gy0_gdbh' => $order,'Gy0_yjno' => $params['yjno'], 'Gy0_gxh' => ['in', $gxh_values]])
            ->where('Gy0_gxmc','NOT LIKE','%检%')
            ->value('SUM(Gy0_计划损耗 * Gy0_ls * Gy0_ks)');
        if($plan_total == 0){
            $this->error('计划损耗数据为 0,请到工单资料管理页面修改工艺资料中选择正确的工序损耗');
            return;
        }
        //单据列表最后统计
        $total = [];
        $total['plan_loss'] = 0;
        $total['total_fp'] = 0;
        $total['waste_quality'] = 0;
        $total['waste_intangible'] = 0;
        $total['reward'] = 0; //超节损奖励数组
        //按工序打印
        if ($params['type'] == 1){
            $total['total_waste'] = 0;
            $total['loss'] = 0;
            foreach ($gy_data as $k=>$item){
                $gy_data[$k]['Gy0_计划损耗'] = $item['Gy0_计划损耗']*$item['Gy0_ls']*$item['Gy0_ks'];
                $gy_data[$k]['waste_quality'] = 0;
                $gy_data[$k]['total_fp'] = $item['total_fp'] * $item['Gy0_ls'];
                $gy_data[$k]['total_cl'] = $item['total_cl'] * $item['Gy0_ls'];
                //无形损
                if (floatval($item['无形损承担比例']) > 0){
                    if (strpos($item['Gy0_gxmc'],'机检') === false){
                        $gy_data[$k]['intangible_loss'] = round(number_format($gy_data[$k]['Gy0_计划损耗']/$plan_total,4) * $data['intangible_loss'] * floatval($item['无形损承担比例']));
                    }else{
                        $gy_data[$k]['intangible_loss'] = 0;
                    }
                }else{
                    if (strpos($item['Gy0_gxmc'],'机检') === false){
                        $gy_data[$k]['intangible_loss'] = round(number_format($gy_data[$k]['Gy0_计划损耗']/$plan_total,4) * $data['intangible_loss']);
                    }else{
                        $gy_data[$k]['intangible_loss'] = 0;
                    }
                }
                foreach ($waste_out as $entry) {
                    for ($i = 1; $i <= 13; $i++) {
                        $gxmcKey = "fp_gxmc" . $i;
                        $slKey = "fp_sl" . $i;
                        if (substr($entry[$gxmcKey],0,2) == $item['Gy0_gxh']){
                            $gy_data[$k]['waste_quality'] += $entry[$slKey];
                        }elseif (strpos($item['Gy0_gxmc'],'机检') !== false){
                            $gy_data[$k]['waste_quality'] =  $data['机检废品'];
                        }
                    }
                }
                //报废合计
//                if ($gy_data[$k]['intangible_loss'] < 0){
//                    $gy_data[$k]['total_waste'] = $gy_data[$k]['waste_quality']  +  $gy_data[$k]['total_fp'];
//                }else{
                $gy_data[$k]['total_waste'] = $gy_data[$k]['waste_quality'] + $gy_data[$k]['intangible_loss'] +  $gy_data[$k]['total_fp'];
//                }
                //工序节损数
                $gy_data[$k]['loss'] = $item['Gy0_计划损耗']*$item['Gy0_ls']*$item['Gy0_ks'] - $gy_data[$k]['total_waste'];
                //占投料报废率
                $gy_data[$k]['loss_rate'] = number_format($gy_data[$k]['loss'] / $item['Gy0_计划接货数'],4) * 100 .'%';
                //工序目标报废率
                $target_loss_rate = floor($item['Gy0_计划损耗'] / $item['Gy0_计划接货数'] * 10000) / 10000;
                if ($target_loss_rate == 0){
                    $target_loss_rate = round($item['Gy0_计划损耗'] / $item['Gy0_计划接货数'] * 10000) / 10000;
                }
                $gy_data[$k]['target_loss_rate'] = $target_loss_rate * 100 . '%';
                //工序实际报废率
                $gy_data[$k]['actual_loss_rate'] = number_format($gy_data[$k]['total_waste'] / ($data['实际投料']*10000),4) * 100 .'%';
                $gy_data[$k]['超节损承担比例'] = number_format($item['超节损承担比例'],4) * 100 .'%';
                $guige = \db('物料_存货编码')
                    ->where('物料代码',$data['成品代号'])
                    ->value('rtrim(规格)');
                //工序超节损金额
                if ($guige === '小盒'){
                    $moneyRate = 0.02;
                }else{
                    $moneyRate = 0.09;
                }
                if (strpos($item['Gy0_gxmc'],'机检') !== false){
                    $gy_data[$k]['工序超节损金额'] = '0.000000';
                    $gy_data[$k]['waste_quality'] = $data['机检废品'];
                }else{
                    $gy_data[$k]['工序超节损金额'] = number_format($gy_data[$k]['loss'] * $item['超节损承担比例'] * $moneyRate,4);
                }
                $total['plan_loss'] += $gy_data[$k]['Gy0_计划损耗'];
                $total['total_fp'] += $gy_data[$k]['total_fp'];
                $total['waste_quality'] += $gy_data[$k]['waste_quality'];
                $total['waste_intangible'] += $gy_data[$k]['intangible_loss'];
                $total['total_waste'] += $gy_data[$k]['total_waste'];
                $total['loss'] += $gy_data[$k]['loss'];
                $total['reward'] += floatval(str_replace(',', '', $gy_data[$k]['工序超节损金额']));
            }
            $total['reward'] = number_format($total['reward'],2);
            $data['gy_data'] = $gy_data;
            $data['total'] = $total;
            $this->success('请求成功',$data);
        }else{ //按班组打印
            //总产量数据
            $total_cl_data = \db('工单_工艺资料')->alias('a')
                ->field(['a.Gy0_yjno', 'a.Gy0_gxh','a.Gy0_ls', 'SUM(b.sczl_cl) as total_cl', 'SUM(c.sczl_cl) as cl'])
                ->join('设备_产量计酬 b', 'a.Gy0_gdbh = b.sczl_gdbh AND a.Gy0_yjno = b.sczl_yjno AND a.Gy0_gxh = b.sczl_gxh','left')
                ->join('db_sczl c', 'a.Gy0_gdbh = c.sczl_gdbh AND a.Gy0_yjno = c.sczl_yjno AND a.Gy0_gxh = c.sczl_gxh','left')
                ->where([
                    'a.Gy0_gdbh' => $order,
                    'a.Gy0_yjno' => $params['yjno'],
                    'a.Gy0_gxh' => ['IN', $gxh_values],
                    'b.sczl_cl|c.sczl_cl' => ['>', 0]
                ])
                ->group('b.sczl_gxh')
                ->order('a.Gy0_gxh')
                ->select();
            //按班组分的产量数据
            $gy_data =db('工单_工艺资料')
                ->alias('a')
                ->field([
                    'a.Gy0_yjno', 'a.Gy0_gxh', 'a.Gy0_ls', 'a.Gy0_ks' ,'a.Gy0_计划损耗', 'a.超节损承担比例', 'b.sczl_gxmc',
                    'SUM(b.sczl_zcfp) as sczl_zcfp', 'SUM(b.sczl_cl) as total_cl',
                    'b.sczl_bh1', 'b.sczl_bh2', 'b.sczl_bh3', 'b.sczl_bh4', 'b.sczl_bh5', 'b.sczl_bh6',
                    'b.sczl_bh7', 'b.sczl_bh8', 'b.sczl_bh9', 'b.sczl_bh10',
                    'rtrim(c.sczl_gxmc) as gxmc', 'SUM(c.sczl_cl) as cl', 'SUM(c.sczl_fp) as fp', 'c.sczl_bh1 as sczl_bh'
                ])
                ->join('设备_产量计酬 b', 'a.Gy0_gdbh = b.sczl_gdbh AND a.Gy0_yjno = b.sczl_yjno AND a.Gy0_gxh = b.sczl_gxh','left')
                ->join('db_sczl c', 'a.Gy0_gdbh = c.sczl_gdbh AND a.Gy0_yjno = c.sczl_yjno AND a.Gy0_gxh = c.sczl_gxh','left')
                ->where([
                    'a.Gy0_gdbh' => $order,
                    'a.Gy0_yjno' => $params['yjno'],
                    'a.Gy0_gxh' => ['in', $gxh_values],
                    'b.sczl_cl|c.sczl_cl' => ['>', 0]
                ])
                ->group('b.sczl_gxh, b.sczl_bh1, CASE WHEN b.sczl_bh2 = "000000" THEN "" ELSE b.sczl_bh2 END, b.sczl_bh3, 
                         b.sczl_bh4, b.sczl_bh5, b.sczl_bh6, b.sczl_bh7, b.sczl_bh8, b.sczl_bh9, c.sczl_bh1')
                ->order('a.Gy0_gxh asc, b.开工时间 asc, c.sczl_rq desc')
                ->select();
            foreach ($gy_data as $key=>$value){
                $gy_data[$key]['Gy0_yjno'] = $value['Gy0_yjno'] > 10 ? $value['Gy0_yjno'] : '0'.$value['Gy0_yjno'];
                //每道工序的产量（按班组分）
                $gy_data[$key]['total_cl'] = $value['total_cl'] * $value['Gy0_ls'];
                if (empty($value['total_cl'])){
                    $gy_data[$key]['total_cl'] = $value['cl'] * $value['Gy0_ls'];
                }
                $value['Gy0_计划损耗'] = $value['Gy0_计划损耗']*$value['Gy0_ls']*$value['Gy0_ks'];
                //计算每道工序的计划损耗
                foreach ($total_cl_data as $k=>$v){
                    //每道工序的总产量
                    $cl = $v['total_cl'] * $v['Gy0_ls'];
                    if (empty($cl)){
                        $cl = $v['cl'] * $v['Gy0_ls'];
                    }
                    if ($value['Gy0_yjno'] == $v['Gy0_yjno'] && $value['Gy0_gxh'] == $v['Gy0_gxh']){
                        $gy_data[$key]['计划损耗'] = round($gy_data[$key]['total_cl'] / $cl  * $value['Gy0_计划损耗']);
                    }
                }
                //每道工序的制程废品（按班组分）
                $gy_data[$key]['sczl_zcfp'] = $value['sczl_zcfp'] * $value['Gy0_ls'];
                if (empty($value['sczl_zcfp'])){
                    $gy_data[$key]['sczl_zcfp'] = $value['fp'] * $value['Gy0_ls'];
                }
                //计算每道工序的质检废(按班组)
                $gy_data[$key]['sczl_gxmc'] = $value['sczl_gxmc'];
                if (empty($value['sczl_gxmc'])){
                    $gy_data[$key]['sczl_gxmc'] = $value['gxmc'];
                }
                if (empty($value['sczl_bh1']) || is_null($value['sczl_bh1'])){
                    $value['sczl_bh1'] = $value['sczl_bh'];
                }
                $gy_data[$key]['sczl_bh1'] = $value['sczl_bh1'];
                $gy_data[$key]['质检废'] = 0;
                foreach ($waste_out as $entry) {
                    for ($i = 1; $i <= 13; $i++) {
                        $gxmcKey = "fp_gxmc" . $i;
                        $slKey = "fp_sl" . $i;
                        $bhKey = "fp_bh" . $i;
                        if ((int)substr($entry[$gxmcKey],0,2) == $value['Gy0_gxh'] && $entry[$bhKey] == $value['sczl_bh1']){
                            $gy_data[$key]['质检废'] += $entry[$slKey];
                        }
                    }
                }
                //无形损分摊
                if ($plan_total >0){
                    $gy_data[$key]['无形损分摊'] = round($gy_data[$key]['计划损耗'] / $plan_total * $data['intangible_loss']);
                }else{
                    $gy_data[$key]['无形损分摊'] = 0;
                }

                //班组成员
                $nameArr = [];
                for ($j = 1; $j <= 10; $j++) {
                    $bhKey = "sczl_bh" . $j;
                    if (!empty($value[$bhKey])){
                        $name = \db('人事_基本资料')->where('员工编号',$value[$bhKey])->value('rtrim(员工姓名)');
                        array_push($nameArr,$name);
                    }
                }
                $gy_data[$key]['member'] = implode(' ',$nameArr);
                unset($gy_data[$key]['Gy0_计划损耗']);
                unset($gy_data[$key]['gxmc']);
                unset($gy_data[$key]['cl']);
                unset($gy_data[$key]['fp']);
                unset($gy_data[$key]['sczl_bh']);

            }
            $i = 0;
            foreach ($gy_data as &$item) {
                $sczl_bh1 = $item['sczl_bh1'];
                $total_cl = $item['total_cl'];
//                $item['total'] = $totals[$sczl_bh1]['total'];
//                if ($totals[$sczl_bh1]['count'] > 1) {
//                    $item['质检废'] = round($total_cl / $totals[$sczl_bh1]['total'] * $item['质检废']);
//                }
                //节损数量
                if ($item['无形损分摊'] > 0){
                    $total_waste = $item['质检废']  +  $item['sczl_zcfp'] + $item['无形损分摊'];
                }else{
                    $total_waste = $item['质检废']  +  $item['sczl_zcfp'];
                }
                $gy_data[$i]['节损数量'] = $item['计划损耗'] - $total_waste;
                //节损奖
                $guige = \db('物料_存货编码')
                    ->where('物料代码',$data['成品代号'])
                    ->value('rtrim(规格)');
                //工序超节损金额
                if ($guige === '小盒'){
                    $moneyRate = 0.02;
                }else{
                    $moneyRate = 0.09;
                }
                if (strpos($item['sczl_gxmc'],'机检') !== false){
                    $gy_data[$i]['节损奖'] = 0;
                }else{
                    $gy_data[$i]['节损奖'] = number_format($gy_data[$i]['节损数量'] *  $item['超节损承担比例'] * $moneyRate,4);
                }
                $gy_data[$i]['超节损承担比例'] = number_format($item['超节损承担比例'],4) * 100 .'%';

                $total['plan_loss'] += $item['计划损耗'];
                $total['total_fp'] += $item['sczl_zcfp'];
                $total['waste_quality'] += $item['质检废'];
                $total['waste_intangible'] += $item['无形损分摊'];
                $total['reward'] += floatval(str_replace(',', '', $gy_data[$i]['节损奖']));
                $i++;
            }
            $total['reward'] = number_format($total['reward'],2);
            $data['gy_data'] = $gy_data;
            $data['total'] = $total;
            $this->success('请求成功',$data);
        }
    }
    /**
     * 获取工单工艺
     * @ApiMethod GET
     * @params string order
     */
    public function getOrderGy(){
        if (Request::instance()->isGet() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->param();
        if (!isset($params['order']) || empty($params['order'])) {
            $this->error('参数错误');
        }
        $order = $params['order'];
        $field = 'Gy0_yjno,Gy0_gxh,rtrim(Gy0_gxmc) as Gy0_gxmc,rtrim(Add_gxmc) as Add_gxmc,Gy0_rate0,Gy0_rate1,损耗系数,无形损承担比例 as loss_one,超节损承担比例 as loss_two,超节损核算单价 as loss_thr,UniqId';
        $data =db('工单_工艺资料')->where('Gy0_gdbh',$order)->where('Gy0_yjno',$params['yjno'])->field($field)->select();
        $this->success('请求成功',$data);
    }
    /**
     * 更新工单工艺
     * @ApiMethod POST
     * @params array data
     */
    public function updateOrderGy(){
        if (Request::instance()->isPost() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->post();
        if (!isset($params) || !isset($params[0]['UniqId'])){
            $this->error('参数不能为空');
        }
        $i = 0;
        foreach ($params as $key=>$value){
            $data = [];
            $data['无形损承担比例'] = $value['loss_one'];
            $data['超节损承担比例'] = $value['loss_two'];
            $data['超节损核算单价'] = $value['loss_thr'];
            $sql =db('工单_工艺资料')->where('UniqId',$value['UniqId'])->fetchSql(true)->update($data);
            $res = Db::query($sql);
            if ($res !== false){
                $i++;
            }
        }
        if ($i !== 0){
            $this->success('更新成功');
        }else{
            $this->error('更新失败');
        }
    }
    /**
     * 获取工单印件考核资料
     * @ApiMethod GET
     * @params string order
     */
    public function getOrderYj(){
        if (Request::instance()->isGet() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->request();
        if (!isset($params['order']) || empty($params['order'])) {
            $this->error('参数错误');
        }
        if (!isset($params['yjno']) || empty($params['yjno'])) {
            $this->error('参数错误');
        }
        $data =db('工单_印件资料')
            ->where('Yj_gdbh',$params['order'])
            ->where('Yj_Yjno', $params['yjno'])
            ->field('Yj_gdbh,rtrim(yj_Yjdh) as yj_Yjdh,yj_Yjno,rtrim(yj_yjmc) as yj_yjmc,质量考核')->find();
        $this->success('请求成功',$data);
    }
    /**
     * 更新工单印件考核资料
     * @ApiMethod POST
     * @params array data
     */
    public function updateOrderYj(){
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $params = $this->request->get();
        if (!isset($params['order'])){
            $this->error('参数不能为空');
        }
        if (!isset($params['yj_yjno'])){
            $this->error('参数不能为空');
        }
        if (!isset($params['examine'])){
            $this->error('参数不能为空');
        }
        if ($params['examine'] === '参与'){
            $examine = 0;
        }else{
            $examine = 1;
        }
        $where['Yj_Gdbh'] = $params['order'];
        $where['yj_Yjno'] = $params['yj_yjno'];
        $sql =db('工单_印件资料')->where($where)->fetchSql(true)->update(['质量考核'=>$examine]);
        $res = \db()->query($sql);
        $returnData = $this->OneOrderSuperLoss($where['Yj_Gdbh'],$where['yj_Yjno']);
        db('工单_质量考核汇总')
            ->where('Gy0_gdbh',$where['Yj_Gdbh'])
            ->where('印件及工序',$where['yj_Yjno'])
            ->delete();
        $sql = db('工单_质量考核汇总')->fetchSql(true)->insertAll($returnData);
        $result = db()->query($sql);
        if($result===false) $this->error('失败');
        if ($res !== false){
            $this->success('更新成功');
        }else{
            $this->error('更新失败');
        }
    }
    /**
     * 获取修正工单实际投料列表
     * @ApiMethod GET
     * @params string year
     * @params string month
     */
    public function getOrderFeedList(){
        if (Request::instance()->isGet() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->request();
        if (empty($params['workorder']) || empty($params['yjno'])) {
            $this->error('参数错误');
        }
        $field = "a.Gd_gdbh,rtrim(c.yj_Yjdh) as yj_yjdh,c.yj_Yjno, c.yj_ks,c.yj_ls,rtrim(c.yj_zzdh) as yj_zzdh,
                  rtrim(b.BOM_物料名称) as BOM_物料名称,rtrim(c.yj_tlgg) as yj_tlgg,rtrim(d.st_dw) as BOM_投料单位,
                  a.订单数量,c.yj_平张投料, b.BOM_实际用量,d.st_sl as 实际投料,d.st_oldSl as 原投料,a.投料确认,
                  d.Uniqid as UniqId,d.mod_number";
        $data =db('工单_基本资料')->alias('a')
            ->join('工单_印件资料 c','a.Gd_gdbh = c.Yj_Gdbh ','left')
            ->join('工单_bom资料 b','c.Yj_Gdbh = b.BOM_工单编号 AND c.yj_zzdh = b.BOM_物料编码','left')
            ->join('物料_收发记录 d','a.Gd_gdbh = d.st_gdbh AND d.cpdh = c.yj_Yjdh')
            ->where('a.Gd_gdbh',$params['workorder'])
            ->where('c.yj_Yjno',$params['yjno'])
            ->where(function($query) {
                $query->where('d.仓库编号', '101')
                    ->whereOr('d.仓库编号', 'Y101');})
            ->field($field)
            ->group('a.Gd_gdbh,d.Uniqid')
            ->order('b.BOM_投料单位,a.UniqId asc')
            ->select();
        if (empty($data)){
            $this->success('请求成功');
        }
        foreach ($data as $key=>$value){
            $len = stripos($value['yj_tlgg'],'/');
            if ($len){
                $name = substr($value['yj_tlgg'],0,$len);
                $len_two = stripos($value['yj_tlgg'],'（');
                if ($len_two){
                    $name = substr($name,0,$len_two);
                }
                $data[$key]['yj_tlgg'] = $name;
            }
            $data[$key]['rate'] = '';
            if (empty($value['原投料'])){
                $data[$key]['原投料'] = $value['实际投料'];
            }
            if ($value['mod_number'] === 0){
                $data[$key]['实际投料'] = '';
            }
        }
        $this->success('请求成功',$data);
    }
    /**
     * 更新工单实际投料
     * @ApiMethod POST
     * @params int UniqId
     * @params string number
     */
    public function updateOrderFeed(){
        if (Request::instance()->isPost() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->post();
        if (!isset($params[0]['UniqId']) || empty($params[0]['UniqId'])){
            $this->error('参数错误');
        }
        $i = 0;
        $list = \db('物料_收发记录')->where('Uniqid',$params['0']['UniqId'])->find();
        foreach ($params as $key=>$value){
            $mod_num = \db('物料_收发记录')
                ->where('Uniqid',$value['UniqId'])
                ->value('mod_number');
            $tl_sql = \db('物料_收发记录')
                ->where('Uniqid',$value['UniqId'])
                ->fetchSql(true)
                ->update(['st_sl'=>$value['number'],'st_oldSl'=>$value['old_number'],'mod_number'=>$mod_num+1,'st_dw' => $value['dw']]);
            $tlRes = Db::query($tl_sql);
            if (!$tlRes){
                $i++;
            }
//            $logData = [
//                'Gd_gdbh'      => $list['st_gdbh'], // 使用原始工单编号
//                'ModifyUser'   => $value['sys_id'],
//                'ModifyTime'   => date('Y-m-d H:i:s'),
//                'FieldName'    => 'st_sl',
//                'OldValue'     => $value['old_number'],
//                'NewValue'     => $value['number'],
//                'ModifySource' => '物料投料数修改'
//            ];
//            $logSql = \db('系统操作日志表')->fetchSql(true)->insert($logData);
//            $result = \db()->query($logSql);

        }
        $total_num = \db('物料_收发记录')
            ->alias('a')
            ->field('SUM(a.st_sl) as 投料数量,b.yj_ls,b.yj_ks')
            ->join('工单_印件资料 b','a.st_gdbh = b.Yj_Gdbh AND a.cpdh = b.yj_yjdh')
            ->where('a.st_gdbh',$list['st_gdbh'])
            ->where('a.cpdh',$list['cpdh'])
            ->where(function($query) {
                $query->where('a.仓库编号', '101')
                    ->whereOr('a.仓库编号', 'Y101');})
            ->find();
        $number = $total_num['投料数量']/10000*$total_num['yj_ls']*$total_num['yj_ks'];
        $res_sql = db('工单_基本资料')->where('Gd_gdbh',$list['st_gdbh'])->where('Gd_cpdh',$list['cpdh'])->fetchSql(true)->setField('实际投料',$number);
        $res = Db::query($res_sql);
        $data['yj_实际投料'] = $number;
        $yj_sql =db('工单_印件资料')->where('Yj_Gdbh',$list['st_gdbh'])->where('yj_Yjdh',$list['cpdh'])->fetchSql(true)->update($data);
        $yjRes = Db::query($yj_sql);
        $yjno = db('工单_印件资料')->where('Yj_Gdbh',$list['st_gdbh'])->where('yj_Yjdh',$list['cpdh'])->column('yj_Yjno')[0];

        /**
         * 重新计算工单超节损数据
         **/

        $result = $this->OneOrderSuperLoss($list['st_gdbh'],$yjno);

        //先删除数据
        \db('工单_质量考核汇总')
            ->where('Gy0_gdbh',$list['st_gdbh'])
            ->where('印件及工序',$yjno)
            ->delete();
        //插入新数据
        $lossSql = \db('工单_质量考核汇总')->fetchSql(true)->insertAll($result);
        $lossRes = \db()->query($lossSql);
        if ($i != 0 && $lossRes !== false){
            $this->success('更新成功');
        }else{
            $this->error('更新失败');
        }
    }
    /**
     * 工单工序产量统计
     * @ApiMethod GET
     * @params string order
     */
    public function getOrderProcessCount(){
        if (Request::instance()->isGet() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->request();
        if (empty($params['order']) || empty($params['order'])) {
            $this->error('参数错误');
        }
        if (empty($params['yjno']) || empty($params['yjno'])) {
            $this->error('参数错误');
        }
        $order = $params['order'];
        $yjno = $params['yjno'];
        $sql = "SELECT a.Gy0_yjno,a.Gy0_gxh,rtrim(a.Gy0_gxmc) as Gy0_gxmc,rtrim(a.Add_gxmc) as Add_gxmc,a.Gy0_计划接货数,
                a.Gy0_ls,a.Gy0_sbbh,a.PD_WG,SUM(b.sczl_cl) as sczl_cl,SUM(b.sczl_zcfp) as sczl_zcfp,
                SUM(b.sczl_来料少数) as 来料异常,COUNT(DISTINCT b.sczl_num) as process_num,b.sczl_Pgcl,
                SUM(c.sczl_cl) as cl,b.sczl_rq,rtrim(a.印刷方式) as 印刷方式,rtrim(a.版距) as 版距
                FROM `工单_工艺资料` a
                LEFT JOIN `设备_产量计酬` b ON a.Gy0_gdbh = b.sczl_gdbh AND a.Gy0_yjno = b.sczl_yjno AND a.Gy0_gxh = b.sczl_gxh
                LEFT JOIN db_sczl c ON a.Gy0_gdbh = c.sczl_gdbh AND a.Gy0_yjno = c.sczl_yjno AND a.Gy0_gxh = c.sczl_gxh
                WHERE a.Gy0_gdbh = '{$order}' and a.GY0_Yjno = '{$yjno}' GROUP BY a.Gy0_yjno, a.Gy0_gxh ORDER BY a.Gy0_yjno, a.Gy0_gxh";
        $data = Db::query($sql);
        //手检数据
        $handData =db('db_手工检验')->where('sczl_gdbh',$order)->field('sum(sczl_cl) as cl,rtrim(sczl_yjgx) as sczl_gxh')->select();
        //包装及成品防护数据
        $sql = "SELECT sczl_gdbh1,sczl_gdbh2,sczl_gdbh3,sczl_gdbh4,sczl_gdbh5,sczl_gdbh6,rtrim(sczl_gxmc1) as sczl_gxmc1,rtrim(sczl_gxmc2) as sczl_gxmc2,
                rtrim(sczl_gxmc3) as sczl_gxmc3,rtrim(sczl_gxmc4) as sczl_gxmc4,rtrim(sczl_gxmc5) as sczl_gxmc5,rtrim(sczl_gxmc6) as sczl_gxmc6,
                sczl_cl1,sczl_cl2,sczl_cl3,sczl_cl4,sczl_cl5,sczl_cl6,sczl_PgCl1,sczl_PgCl2,sczl_PgCl3,sczl_PgCl4,sczl_PgCl5,sczl_PgCl6
                FROM `db_包装计件` WHERE `sczl_gdbh1` LIKE '%{$order}%' OR `sczl_gdbh2` LIKE '%{$order}%' 
                OR `sczl_gdbh3` LIKE '%{$order}%' OR `sczl_gdbh4` LIKE '%{$order}%' OR `sczl_gdbh5` LIKE '%{$order}%' OR `sczl_gdbh6` LIKE '%{$order}%'";
        $package = Db::query($sql);
        $list = [];
        $j = 0;
        foreach ($package as $value){
            for ($i = 1; $i <= 6; $i++) {
                $gdbhlKey = "sczl_gdbh" . $i;
                $gxmcKey = "sczl_gxmc" . $i;
                $clKey = "sczl_cl" . $i;
                $pgclKey = "sczl_PgCl" . $i;
                if ($value[$gdbhlKey] == '2311743' && $value[$clKey] > 0) {
                    $list[$j]['sczl_gdbh'] = $value[$gdbhlKey];
                    $list[$j]['sczl_gxmc'] =  $value[$gxmcKey];
                    $list[$j]['sczl_cl'] =  $value[$clKey];
                    $list[$j]['sczl_PgCl'] =  $value[$pgclKey];
                    $j++;
                }
            }
        }
        // 创建一个关联数组，用于存储相同 sczl_gxmc 的值和对应的乘积之和
        $sumArray = [];
        foreach ($list as $item) {
            $key = $item['sczl_gxmc'];
            $cl = floatval($item['sczl_cl']);
            $pgCl = intval($item['sczl_PgCl']);
            $product = $cl * $pgCl;
            if (!isset($sumArray[$key])) {
                $sumArray[$key] = 0;
            }
            $sumArray[$key] += $product;
        }
        $handGxh = substr($handData[0]['sczl_gxh'],-2);
        foreach ($data as $key=>$item){
            $data[$key]['折算车头产量'] = $item['Gy0_计划接货数'];
            $data[$key]['Gy0_计划接货数'] = $item['Gy0_计划接货数']*$item['Gy0_ls'];
            $data[$key]['制程废品率'] = '';
            if ($item['sczl_zcfp'] > 0 && $item['sczl_cl']){
                $data[$key]['制程废品率'] = number_format($item['sczl_zcfp']/$item['sczl_cl']*100,4).'%';
            }
            if ($item['cl'] > 0){
                $data[$key]['sczl_cl'] = $item['cl'];
            }
            if ($item['sczl_Pgcl'] > 0){
                $data[$key]['sczl_cl'] = $item['sczl_cl'] * $item['sczl_Pgcl'];
            }
            if ($item['Gy0_gxh'] == (int)$handGxh){
                $data[$key]['sczl_cl'] = $handData[0]['cl'];
            }
            foreach ($sumArray as $k=>$v){
                if ($item['Gy0_gxmc'] == $k){
                    $data[$key]['sczl_cl'] = $v;
                }
            }
            if (substr($item['PD_WG'],0,4) == '1900'){
                $data[$key]['PD_WG'] = '计划';
            }else{
                $data[$key]['PD_WG'] = '完工';
            }
            //印刷方式为卷对卷时候：上报产量/版距*1000
            if ($item['印刷方式'] === '卷对卷'){
                $data[$key]['sczl_cl'] = ceil($data[$key]['sczl_cl']/$item['版距']*1000);
                $data[$key]['sczl_zcfp'] = ceil($data[$key]['sczl_zcfp']/$item['版距']*1000);
                $data[$key]['来料异常'] = ceil($data[$key]['来料异常']/$item['版距']*1000);
            }
        }
        $this->success('请求成功',$data);
    }


    /**
     * 月份员工超节损数据汇总
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function EmployeeDataCollect()
    {
        if ($this->request->isPost() === false) {
            $this->error('请求错误');
        }
        $params = $this->request->post();
        if (empty($params)) {
            $this->error('参数错误');
        }
        $date = date('Ym', strtotime($params['date']));
        $list = \db('工单_质量考核汇总')
            ->alias('a')
            ->join('工单_印件资料 b', 'a.Gy0_gdbh = b.Yj_Gdbh AND a.印件及工序 = b.yj_Yjno')
            ->join('成品入仓 c', 'a.Gy0_gdbh = c.jjcp_gdbh AND a.印件及工序 = c.jjcp_yjno')
            ->where('a.sys_ny', $date)
            ->where(function ($query) {
                $query->where('b.质量考核', 0)
                    ->whereOr('b.质量考核', null);
            })
            ->where('c.jjcp_smb', 'like', '末%')
            ->select();
        $data = [];

        foreach ($list as $item) {
            $workshop = $item["车间名称"] ?? '';

            for ($i = 1; $i <= 8; $i++) {
                if (!empty($item["sczl_bh{$i}"]) && $item["sczl_bh{$i}"]!== ''){
                    $bh = $item["sczl_bh{$i}"] ?? '';
                    $xm = $item["Xm{$i}"] ?? '';
                    $rateValue = floatval($item["sczl_rate{$i}"]) ?? '';

                    // 关键优化：如果分配比例为 0 或空，默认为 1
                    $rate = (empty($rateValue) || (float)$rateValue == 0) ? 1 : (float)$rateValue;
                    if (!empty($bh) && $bh !== '') {
                        $je = round((float)$item["CjsJe"] * $rate, 4);
                        $data[] = [
                            "bh" => $bh,
                            "xm" => $xm,
                            "je" => (float)number_format($je, 4, '.', ''),
                            "cj" => $workshop
                        ];
                    }
                }

            }
        }
        $result = [];

        foreach ($data as $item) {
            $cj = $item['cj'];
            $bh = $item['bh'];
            $je = round($item['je'], 2); // 保留两位小数

            if (!isset($result[$cj])) {
                $result[$cj] = [];
            }

            if (isset($result[$cj][$bh])) {
                $result[$cj][$bh]['je'] += (float)$je;
            } else {
                $result[$cj][$bh] = [
                    'bh' => $bh,
                    'xm' => $item['xm'],
                    'je' => (float)$je,
                    'cj' => $cj
                ];
            }
        }
        // 将每个车间的子数组转换为索引数组
        foreach ($result as $cjName => &$items) {
            $items = array_values($items);
        }

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


    /**
     * 单条工单超节损计算
     * @param $gdbh
     * @param $yjno
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    /**
 * 计算单个工单的超节损数据
 * 
 * @param string $gdbh 工单编号
 * @param string $yjno 印件号
 * @return array|false 返回超节损计算结果数组，失败返回false
 */
public function OneOrderSuperLoss($gdbh, $yjno)
{
    // ========== 阶段1: 基础数据查询 ==========
    // 获取工单末板入仓数据
    $workOrderData = $this->getWorkOrderWarehouse($gdbh, $yjno);
    if (empty($workOrderData)) {
        $this->error("工单{$gdbh}-{$yjno}未查询到末板入仓记录");
    }
    
    // 获取工单入仓总数量
    $totalNumber = $this->getTotalWarehouseCount($gdbh, $yjno);
    // 获取工单资料和投料数据
    $workOrderInfo = $this->getWorkOrderInfo($gdbh, $yjno);
    
    // 投料为空则返回失败
    if (empty($workOrderInfo['投料'])) {
        return false;
    }
    
    // ========== 阶段2: 投料数据处理 ==========
    // 处理投料单位转换和开数联数默认值
    $data = $this->processMaterialData($workOrderInfo);
    
    // 调用外部方法计算计划工序产出
    (new WorkOrder())->PlannedProcessYield($gdbh, $yjno, 0, $data['实际投料'] * 10000 / $data['ls']);
    
    // 添加工单入仓数据到结果集
    $data['warehousing_num'] = $totalNumber;
    $data['warehousing_date'] = substr($workOrderData['jjcp_sj'], 0, 10);
    
    // ========== 阶段3: 报工工序获取 ==========
    // 获取有报工记录的工序列表
    $gxhValues = $this->getReportedProcesses($workOrderData['jjcp_gdbh'], $workOrderData['jjcp_yjno']);
    if (empty($gxhValues)) {
        $this->error("工单{$workOrderData['jjcp_gdbh']}-{$workOrderData['jjcp_yjno']}未查询到报工信息");
    }
    
    // ========== 阶段4: 合格率与废品计算 ==========
    // 计算目标合格率和实际合格率
    $data = $this->calculateRates($data, $totalNumber);
    // 计算制程废品和无形损耗
    $data = $this->calculateWaste($data, $workOrderData, $totalNumber);
    
    // ========== 阶段5: 废品数据处理 ==========
    // 处理核检单废品上报数据，分类统计各类废品
    $wasteResult = $this->processWasteData($workOrderData['jjcp_gdbh'], $workOrderData['jjcp_yjno']);
    $data = array_merge($data, $wasteResult['summary']);
    $wasteDetails = $wasteResult['details'];
    
    // ========== 阶段6: 工序产量数据获取 ==========
    // 获取按班组分的产量数据和工序汇总数据
    $productionData = $this->getProductionData($workOrderData, $gxhValues);
    
    // ========== 阶段7: 超节损计算 ==========
    // 计算每道工序的超节损金额和节损奖
    $gyData = $this->calculateSuperLoss(
        $productionData['gy_data'], 
        $productionData['total_cl_data'], 
        $wasteDetails, 
        $data, 
        $workOrderData
    );
    
    // ========== 阶段8: 结果整合 ==========
    // 构建最终的超节损结果数据结构
    return $this->buildResult($gyData, $data, $totalNumber, $workOrderData);
}

// ========== 私有方法实现 ==========

/**
 * 获取工单末板入仓数据
 * 
 * @param string $gdbh 工单编号
 * @param string $yjno 印件号
 * @return array 入仓数据
 */
private function getWorkOrderWarehouse($gdbh, $yjno)
{
    return \db('成品入仓')
        ->where('jjcp_gdbh', $gdbh)
        ->where('jjcp_yjno', $yjno)
        ->where('jjcp_smb', '末 板')  // 只查询末板记录
        ->find();
}

/**
 * 获取工单入仓总数量
 * 
 * @param string $gdbh 工单编号
 * @param string $yjno 印件号
 * @return int 入仓总数量
 */
private function getTotalWarehouseCount($gdbh, $yjno)
{
    $result = \db('成品入仓')
        ->where('jjcp_gdbh', $gdbh)
        ->where('jjcp_yjno', $yjno)
        ->column('SUM(jjcp_sl)');  // 汇总入仓数量
    return $result ? $result[0] : 0;
}

/**
 * 获取工单资料和投料数据
 * 
 * @param string $gdbh 工单编号
 * @param string $yjno 印件号
 * @return array 工单资料和投料数据
 */
private function getWorkOrderInfo($gdbh, $yjno)
{
    // 查询字段：工单编号、成品信息、销售订单、订单数量、开数、联数、投料量、单位等
    $field = 'a.Gd_gdbh,rtrim(a.成品代号) as 成品代号,rtrim(a.成品名称) as 成品名称,
              rtrim(a.销售订单号) as 销售订单号,a.订单数量,c.yj_ls as ls,c.yj_ks as ks,SUM(b.st_sl) as 投料,
              b.st_dw,c.yj_zzmc,c.yj_tlgg,SUM(b.mod_number) as mod_num';
    
    return db('工单_基本资料')
        ->alias('a')
        ->join('物料_收发记录 b', 'a.Gd_gdbh = b.st_gdbh AND a.Gd_cpdh = b.cpdh')
        ->join('工单_印件资料 c', 'c.Yj_Gdbh = a.Gd_gdbh AND c.yj_Yjdh = a.Gd_cpdh')
        ->where('a.Gd_Gdbh', $gdbh)
        ->where('c.yj_Yjno', $yjno)
        ->where(function ($query) {
            // 仓库编号限定为101或Y101
            $query->where('b.仓库编号', '101')->whereOr('b.仓库编号', 'Y101');
        })
        ->field($field)
        ->find();
}

/**
 * 获取有报工记录的工序列表
 * 
 * @param string $gdbh 工单编号
 * @param string $yjno 印件号
 * @return array 工序编号数组
 */
private function getReportedProcesses($gdbh, $yjno)
{
    // 使用UNION合并设备产量计酬和db_sczl表的报工工序
    $sql = "SELECT sczl_gxh FROM (
                SELECT sczl_gxh FROM 设备_产量计酬 WHERE sczl_gdbh = ? AND sczl_yjno = ?
                UNION 
                SELECT sczl_gxh FROM db_sczl WHERE sczl_gdbh = ? AND sczl_yjno = ?
            ) AS combined_result";
    
    // 使用参数绑定防止SQL注入
    $gxh_arr = Db::query($sql, [$gdbh, $yjno, $gdbh, $yjno]);
    if (empty($gxh_arr)) return [];
    
    // 工序号小于10的前面补0，保证格式统一
    return array_map(function ($v) {
        return (int)$v < 10 ? '0' . $v : $v;
    }, array_column($gxh_arr, 'sczl_gxh'));
}

/**
 * 处理投料数据
 * - 处理特殊单位转换（吨转张）
 * - 设置开数、联数默认值
 * - 计算实际投料量
 * 
 * @param array $workOrderInfo 工单资料
 * @return array 处理后的投料数据
 */
private function processMaterialData($workOrderInfo)
{
    $data = $workOrderInfo;
    
    // 特殊投料单位转换：吨转张
    if (!empty($data['yj_tlgg'])) {
        // 提取图令规格中的长宽尺寸
        $number1 = (int)substr($data['yj_tlgg'], 0, 3);
        $number2 = (int)substr($data['yj_tlgg'], 4, 3);
        
        // 提取纸张克重
        if ($number1 !== 0 && $number2 !== 0 && preg_match('/(\d+)g/', $data['yj_zzmc'], $matches)) {
            if ($data['st_dw'] === '吨') {
                // 计算转换：吨 -> 克 -> 张
                $data['投料'] = round(($data['投料'] * 1000 * 1000) / $matches[1] / ($number1 * $number2) * 1000000);
                $data['st_dw'] = '张';
            }
        }
    }
    
    // 开数、联数为0时默认设为1（避免除零错误）
    $data['ls'] = $data['ls'] == 0 ? 1 : $data['ls'];
    $data['ks'] = $data['ks'] == 0 ? 1 : $data['ks'];
    
    // 计算工单实际投料量（除以10000转换单位）
    $data['实际投料'] = str_replace(',', '', number_format($data['投料'] * $data['ls'] * $data['ks'] / 10000, 4));
    
    return $data;
}

/**
 * 计算合格率
 * 
 * @param array $data 工单数据
 * @param int $totalNumber 入仓数量
 * @return array 包含合格率的数据
 */
private function calculateRates($data, $totalNumber)
{
    // 目标合格率默认100%
    $data['target_rate'] = '100%';
    // 实际合格率 = 入仓数量 / 实际投料 * 100%
    $data['real_rate'] = number_format($totalNumber / ($data['实际投料'] * 10000) * 100, 2) . '%';
    
    return $data;
}

/**
 * 计算废品数量和无形损耗
 * 
 * @param array $data 工单数据
 * @param array $workOrderData 入仓数据
 * @param int $totalNumber 入仓数量
 * @return array 包含废品数据的结果
 */
private function calculateWaste($data, $workOrderData, $totalNumber)
{
    // 查询制程废品数量
    $zzfpData = db('设备_产量计酬')
        ->where('sczl_gdbh', $workOrderData['jjcp_gdbh'])
        ->where('sczl_yjno', $workOrderData['jjcp_yjno'])
        ->field('SUM(sczl_zcfp) as sczl_zcfp')
        ->select();
    
    // 制程废品 = 原始制程废品 * 开数 * 联数
    $data['zcfp'] = ($zzfpData[0]['sczl_zcfp'] ?? 0) * $data['ls'] * $data['ks'];
    
    // 查询核检单废品数量
    $wasteTotal = db('db_qczl')
        ->where('qczl_gdbh', $workOrderData['jjcp_gdbh'])
        ->where('qczl_yjno', $workOrderData['jjcp_yjno'])
        ->sum('qczl_fp') ?: 0;
    
    // 无形损耗 = 实际投料 - 入仓数量 - 制程废品 - 核检废品
    $data['intangible_loss'] = (int)($data['实际投料'] * 10000 - $totalNumber - $data['zcfp'] - $wasteTotal);
    
    return $data;
}

/**
 * 处理核检单废品数据
 * 分类统计：外发废、材料废、零头处理、质检废、机检废
 * 
 * @param string $gdbh 工单编号
 * @param string $yjno 印件号
 * @return array 包含废品汇总和详情的数据
 */
private function processWasteData($gdbh, $yjno)
{
    // 查询核检单废品上报数据（包含13个废品字段）
    $sql = "SELECT qczl_num,fp_sl1,fp_sl2,fp_sl3,fp_sl4,fp_sl5,fp_sl6,fp_sl7,fp_sl8,fp_sl9,fp_sl10,fp_sl11,fp_sl12,fp_sl13,
                   fp_lb1,fp_lb2,fp_lb3,fp_lb4,fp_lb5,fp_lb6,fp_lb7,fp_lb8,fp_lb9,fp_lb10,fp_lb11,fp_lb12,fp_lb13,
                   fp_bh1,fp_bh2,fp_bh3,fp_bh4,fp_bh5,fp_bh6,fp_bh7,fp_bh8,fp_bh9,fp_bh10,fp_bh11,fp_bh12,fp_bh13,
                   fp_gxmc1,fp_gxmc2,fp_gxmc3,fp_gxmc4,fp_gxmc5,fp_gxmc6,fp_gxmc7,fp_gxmc8,fp_gxmc9,fp_gxmc10,fp_gxmc11,fp_gxmc12,fp_gxmc13,UniqId
            FROM db_qczl WHERE qczl_gdbh = ? AND qczl_yjno = ?";
    
    $waste_out = Db::query($sql, [$gdbh, $yjno]);
    
    // 初始化废品分类汇总数组
    $summary = ['外发废' => 0, '材料废' => 0, '零头处理' => 0, '工单质检废' => 0, '机检废' => 0];
    
    // 遍历每条核检单记录
    foreach ($waste_out as $entry) {
        // 遍历13个废品字段
        for ($i = 1; $i <= 13; $i++) {
            $slValue = $entry["fp_sl{$i}"] ?? 0;
            // 累计质检废总量
            $summary['工单质检废'] += $slValue;
            
            // 根据废品类别进行分类
            if (!empty($entry["fp_lb{$i}"])) {
                $label = $entry["fp_lb{$i}"];
                $gxmc = $entry["fp_gxmc{$i}"] ?? '';
                
                // M04开头为外发加工废
                if (substr($label, 0, 3) === 'M04') $summary['外发废'] += $slValue;
                // L开头为材料废
                elseif (substr($label, 0, 1) === 'L') $summary['材料废'] += $slValue;
                // M01开头为零头处理
                elseif (substr($label, 0, 3) === 'M01') $summary['零头处理'] += $slValue;
                // 工序名称以01开头为机检废品
                elseif (substr($gxmc, 0, 2) === '01') $summary['机检废'] += $slValue;
            }
        }
    }
    
    return ['summary' => $summary, 'details' => $waste_out];
}

/**
 * 获取工序产量数据
 * 
 * @param array $workOrderData 入仓数据
 * @param array $gxhValues 工序编号数组
 * @return array 包含汇总数据和班组数据的数组
 */
private function getProductionData($workOrderData, $gxhValues)
{
    // 查询工序产量汇总数据
    $totalClData = \db('工单_工艺资料')->alias('a')
        ->field(['a.Gy0_yjno', 'a.Gy0_gxh', 'rtrim(a.Gy0_gxmc) as gxmc', 'a.Gy0_ls', 
                 'SUM(b.sczl_cl) as total_cl', 'SUM(c.sczl_cl) as cl',
                 'rtrim(a.印刷方式) as 印刷方式', 'rtrim(a.版距) as 版距'])
        ->join('设备_产量计酬 b', 'a.Gy0_gdbh = b.sczl_gdbh AND a.Gy0_yjno = b.sczl_yjno AND a.Gy0_gxh = b.sczl_gxh', 'left')
        ->join('db_sczl c', 'a.Gy0_gdbh = c.sczl_gdbh AND a.Gy0_yjno = c.sczl_yjno AND a.Gy0_gxh = c.sczl_gxh', 'left')
        ->where([
            'a.Gy0_gdbh' => $workOrderData['jjcp_gdbh'],
            'a.Gy0_yjno' => $workOrderData['jjcp_yjno'],
            'a.Gy0_gxh' => ['IN', $gxhValues],
            'b.sczl_cl|c.sczl_cl' => ['>', 0],  // 产量大于0
        ])
        ->group('a.Gy0_gxh')
        ->order('a.Gy0_gxh')
        ->select();
    
    // 查询按班组分的产量数据
    $gyData = db('工单_工艺资料')->alias('a')
        ->field([
            'a.Gy0_gdbh', 'a.Gy0_yjno', 'a.Gy0_gxh', 'a.Gy0_ls', 'a.Gy0_ks', 
            'a.Gy0_计划损耗', 'a.超节损承担比例', 'CONCAT(`a`.`Gy0_gxmc`, "【", a.Add_gxmc,"】") AS sczl_gxmc',
            'SUM(b.sczl_zcfp) as sczl_zcfp', 'SUM(b.sczl_cl) as total_cl',
            'b.sczl_bh1', 'b.sczl_bh2', 'b.sczl_bh3', 'b.sczl_bh4', 'b.sczl_bh5', 'b.sczl_bh6',
            'b.sczl_bh7', 'b.sczl_bh8', 'b.sczl_bh9', 'b.sczl_bh10', 
            'GROUP_CONCAT(DISTINCT b.sczl_num SEPARATOR ",") AS 流程单',
            'b.sczl_bzdh', 'b.sczl_rate1', 'b.sczl_rate2', 'b.sczl_rate3', 'b.sczl_rate4', 'b.sczl_rate5',
            'b.sczl_rate6', 'b.sczl_rate7', 'b.sczl_rate8', 'b.sczl_rate9', 'b.sczl_rate10',
            'rtrim(c.sczl_gxmc) as gxmc', 'SUM(c.sczl_cl) as cl', 'SUM(c.sczl_fp) as fp', 'c.sczl_bh1 as sczl_bh',
            'd.使用部门 as 使用部门', 'c.sczl_bzdh as bzdh', 'b.sczl_jtbh', 'a.损耗系数', 'a.Gy0_ms', 'a.Gy0_Rate0',
            'a.Gy0_Rate1', 'a.无形损承担比例', 'a.Gy0_计划接货数*a.Gy0_ls*a.Gy0_ks as 计划产量', 
            'e.Gd_客户代号', 'e.Gd_客户名称', 'e.Gd_cpdh', 'e.Gd_cpmc', 'e.销售订单号', 
            'e.投料大箱', 'e.订单数量', 'e.计量单位', 'rtrim(a.Gy0_SITE) as Gy0_SITE',
            'rtrim(a.印刷方式) as 印刷方式', 'rtrim(a.版距) as 版距'
        ])
        ->join('设备_产量计酬 b', 'a.Gy0_gdbh = b.sczl_gdbh AND a.Gy0_yjno = b.sczl_yjno AND a.Gy0_gxh = b.sczl_gxh', 'left')
        ->join('db_sczl c', 'a.Gy0_gdbh = c.sczl_gdbh AND a.Gy0_yjno = c.sczl_yjno AND a.Gy0_gxh = c.sczl_gxh', 'left')
        ->join('设备_基本资料 d', 'd.设备编号 = b.sczl_jtbh', 'left')
        ->join('工单_基本资料 e', 'a.Gy0_gdbh = e.Gd_gdbh AND a.Gy0_yjno = e.行号')
        ->where([
            'a.Gy0_gdbh' => $workOrderData['jjcp_gdbh'],
            'a.Gy0_yjno' => $workOrderData['jjcp_yjno'],
            'a.Gy0_gxh' => ['in', $gxhValues],
            'b.sczl_cl|c.sczl_cl' => ['>', 0],
        ])
        ->group('a.Gy0_gxh,b.sczl_jtbh,b.sczl_bh1, CASE WHEN b.sczl_bh2 = "000000" THEN "" ELSE b.sczl_bh2 END, b.sczl_bh3,
                 b.sczl_bh4, b.sczl_bh5, b.sczl_bh6, b.sczl_bh7, b.sczl_bh8, b.sczl_bh9, c.sczl_bh1')
        ->order('a.Gy0_gxh asc, b.开工时间 asc, c.sczl_rq desc')
        ->select();
    
    return ['total_cl_data' => $totalClData, 'gy_data' => $gyData];
}

/**
 * 获取工单计划损耗总量
 * 
 * @param array $workOrderData 入仓数据
 * @param array $gyData 工序数据
 * @return float 计划损耗总量
 */
private function getPlanLossTotal($workOrderData, $gyData)
{
    $gxhValues = array_unique(array_column($gyData, 'Gy0_gxh'));
    
    return db('工单_工艺资料')
        ->where(['Gy0_gdbh' => $workOrderData['jjcp_gdbh'], 
                 'Gy0_yjno' => $workOrderData['jjcp_yjno'], 
                 'Gy0_gxh' => ['in', $gxhValues]])
        ->value('SUM(Gy0_计划损耗 * Gy0_ls * Gy0_ks)') ?: 0;
}

/**
 * 计算班组产量
 * 
 * @param array $item 工序数据项
 */
private function calculateProduction(&$item)
{
    // 班组产量 = 原始产量 * 开数 * 联数
    $item['total_cl'] = $item['total_cl'] * $item['Gy0_ls'] * $item['Gy0_ks'];
    
    // 如果设备产量计酬表没有数据，使用报工表数据
    if (empty($item['total_cl'])) {
        $item['total_cl'] = $item['cl'] * $item['Gy0_ls'] * $item['Gy0_ks'];
    }
    
    // 班组编号为空时使用报工表的班组编号
    if (empty($item['sczl_bh1'])) {
        $item['sczl_bh1'] = $item['sczl_bh'];
    }
}

/**
 * 根据印刷方式调整产量（卷对卷需除以版距）
 * 
 * @param array $item 工序数据项
 * @param array $totalClData 产量汇总数据
 * @return int 调整后的产量
 */
private function adjustProduction($item, $totalClData)
{
    $banju = $item['版距'] / 1000;  // 版距转换为米
    $cl = $item['total_cl'];  // 注意：这里已经在 calculateProduction() 中乘以了 ls 和 ks
    
    // 卷对卷印刷方式需要除以版距
    if ($item['印刷方式'] === '卷对卷') {
        $cl = $cl / $banju;
    }
    
    // 不需要再乘以 ls 和 ks，避免重复计算
    return (int)$cl;
}

/**
 * 计算班组质检废品
 * 
 * @param array $item 工序数据项
 * @param array $wasteDetails 废品详情数据
 * @return int 质检废品数量
 */
private function calculateQualityWaste($item, $wasteDetails)
{
    $zjfp = 0;
    
    // 遍历废品详情，匹配工序和班组
    foreach ($wasteDetails as $entry) {
        for ($i = 1; $i <= 13; $i++) {
            $gxmc = $entry["fp_gxmc{$i}"] ?? '';
            $bh = $entry["fp_bh{$i}"] ?? '';
            
            // 匹配工序编号和班组编号
            if ((int)substr($gxmc, 0, 2) == $item['Gy0_gxh'] && $bh == $item['sczl_bh1']) {
                $zjfp += $entry["fp_sl{$i}"] ?? 0;
            }
        }
    }
    
    return $zjfp;
}

/**
 * 计算工序产量
 * 
 * @param array $item 工序数据项
 * @param array $totalClData 产量汇总数据
 * @return int 工序产量
 */
private function calculateProcessProduction($item, $totalClData)
{
    foreach ($totalClData as $v) {
        $banju = $v['版距'] / 1000;
        $totalCl = $v['total_cl'];
        
        // 卷对卷需调整
        if ($v['印刷方式'] === '卷对卷') {
            $totalCl = $totalCl / $banju;
        }
        
        // 匹配工序
        if ($v['Gy0_yjno'] === $item['Gy0_yjno'] && $v['Gy0_gxh'] === $item['Gy0_gxh']) {
            // 拆片工序使用报工产量，其他工序使用设备产量
            // 注意：这里需要乘以 ls 和 ks，因为 total_cl 来自数据库原始值
            return strpos($v['gxmc'], '拆片') !== false 
                ? $v['cl'] * $item['Gy0_ls'] * $item['Gy0_ks']
                : $totalCl * $item['Gy0_ls'] * $item['Gy0_ks'];
        }
    }
    
    return 0;
}

/**
 * 清理工序数据中的临时字段
 * 
 * @param array $item 工序数据项
 */
private function cleanupProcessData(&$item)
{
    unset($item['gxmc'], $item['cl'], $item['fp'], $item['sczl_bh'], $item['bzdh']);
}

/**
 * 计算超节损数据
 * 
 * @param array $gyData 工序数据
 * @param array $totalClData 产量汇总数据
 * @param array $wasteDetails 废品详情
 * @param array $data 工单数据
 * @param array $workOrderData 入仓数据
 * @return array 计算后的工序数据
 */
private function calculateSuperLoss($gyData, $totalClData, $wasteDetails, $data, $workOrderData)
{
    $sumBz = [];  // 班组产量汇总
    $planTotal = $this->getPlanLossTotal($workOrderData, $gyData);

    // 第一步：预计算班组产量总和
    foreach ($gyData as &$item) {
        $this->calculateProduction($item);
        $key = "{$item['sczl_bh1']}-{$item['Gy0_gxh']}";
        $sumBz[$key] = isset($sumBz[$key]) ? $sumBz[$key] + $item['total_cl'] : $item['total_cl'];
    }
    
    // 第二步：收集所有员工编号用于批量查询
    $employeeIds = [];
    foreach ($gyData as $item) {
        for ($j = 1; $j <= 10; $j++) {
            if (!empty($item["sczl_bh{$j}"])) {
                $employeeIds[] = $item["sczl_bh{$j}"];
            }
        }
    }
    // 批量查询员工姓名
    $employeeNames = $this->getEmployeeNames(array_unique($employeeIds));
    
    // 第三步：计算每道工序的超节损数据
    foreach ($gyData as $kk => &$vv) {
        // 注意：calculateProduction() 已在之前调用，total_cl 已乘以 ls 和 ks
        // 现在只需要调整卷对卷的情况
        $vv['total_cl'] = $this->adjustProduction($vv, $totalClData);

        // 计算计划损耗
        $vv['Gy0_计划损耗'] = $vv['Gy0_计划损耗'] * $vv['Gy0_ls'] * $vv['Gy0_ks'];
        
        // 根据工序总产量计算班组分摊计划损耗
        foreach ($totalClData as $v) {
            if ($vv['Gy0_yjno'] == $v['Gy0_yjno'] && $vv['Gy0_gxh'] == $v['Gy0_gxh']) {
                $cl = $v['total_cl'] ?: $v['cl'];
                $vv['计划损耗'] = round($vv['total_cl'] / ($cl * $v['Gy0_ls']) * $vv['Gy0_计划损耗']);
                break;
            }
        }
        
        // 计算制程废品
        $vv['sczl_zcfp'] = $vv['sczl_zcfp'] ? $vv['sczl_zcfp'] * $vv['Gy0_ls'] : ($vv['fp'] * $vv['Gy0_ls']);
        
        // 设置工序名称和班组编号
        $vv['sczl_gxmc'] = $vv['sczl_gxmc'] ?: $vv['gxmc'];
        $vv['sczl_bh1'] = $vv['sczl_bh1'] ?: $vv['sczl_bh'];
        
        // 计算质检废品
        $vv['zjfp'] = $this->calculateQualityWaste($vv, $wasteDetails);
        $vv['质检废'] = round($vv['zjfp'] * ($vv['total_cl'] / $sumBz["{$vv['sczl_bh1']}-{$vv['Gy0_gxh']}"]));
        
        // 无形损分摊
        // 计算工序无形损（基于计划损耗分摊）
        $rawIntangibleLoss = $planTotal > 0 ? $vv['计划损耗'] / $planTotal * $data['intangible_loss'] : 0;
        // 计算工序计划产量的千分之三作为阈值
        $intangibleThreshold = $vv['计划产量'] * 0.003;
        // 判断：如果工序无形损不超过千分之三，则计为0；超过千分之三的部分取正整数计入超节损
        if ($rawIntangibleLoss <= $intangibleThreshold) {
            $vv['无形损分摊'] = 0;
        } else {
            // 超过千分之三的部分，取正整数
            $vv['无形损分摊'] = max(0, (int)($rawIntangibleLoss - $intangibleThreshold));
        }
                
        // 填充员工姓名
        for ($j = 1; $j <= 10; $j++) {
            $vv["sczl_name{$j}"] = !empty($vv["sczl_bh{$j}"]) ? ($employeeNames[$vv["sczl_bh{$j}"]] ?? '') : '';
        }
        
        // 计算工序产量
        $vv['工序产量'] = $this->calculateProcessProduction($vv, $totalClData);
        
        // 清理临时字段
        $this->cleanupProcessData($vv);
    }
    
    // 第四步：计算节损奖
    // 查询产品规格，确定核算单价
    $guige = \db('物料_存货编码')->where('物料代码', $data['成品代号'])->value('rtrim(规格)');
    $moneyRate = strpos($guige, '小盒') !== false ? 0.02 : 0.09;  // 小盒0.02元，其他0.09元
    
    foreach ($gyData as &$item) {
        // 节损数量 = 计划损耗 - 实际损耗（质检废+制程废+无形损）
        $totalWaste = $item['质检废'] + $item['sczl_zcfp'] + ($item['无形损分摊'] > 0 ? $item['无形损分摊'] : 0);
        $item['节损数量'] = $item['计划损耗'] - $totalWaste;
        
        // 节损奖 = 节损数量 * 超节损承担比例 * 核算单价（机检工序无奖励）
        $item['节损奖'] = strpos($item['sczl_gxmc'], '机检') !== false ? 0 : number_format($item['节损数量'] * $item['超节损承担比例'] * $moneyRate, 4);
        
        // 系统年月和核算单价
        $item['sys_ny'] = date('Ym', strtotime($workOrderData['jjcp_sj']));
        $item['超节损核算单价'] = $moneyRate;
    }
    
    return $gyData;
}

/**
 * 构建最终的超节损结果数据结构
 * 
 * @param array $gyData 工序数据
 * @param array $data 工单数据
 * @param int $totalNumber 入仓数量
 * @param array $workOrderData 入仓数据
 * @return array 超节损结果数组
 */
private function buildResult($gyData, $data, $totalNumber, $workOrderData)
{
    $result = [];
    
    foreach ($gyData as $key => $value) {
        $result[$key] = [
            'sys_ny' => $value['sys_ny'],                    // 系统年月
            'Gy0_gdbh' => $value['Gy0_gdbh'],                // 工单编号
            '印件及工序' => $value['Gy0_yjno'],               // 印件号
            '工序' => $value['Gy0_gxh'],                      // 工序编号
            '工序名称' => $value['sczl_gxmc'],                 // 工序名称
            '联数' => $value['Gy0_ls'],                       // 联数
            '基础损耗' => $value['Gy0_Rate0'],                // 基础损耗率
            '损耗率' => $value['Gy0_Rate1'],                  // 损耗率
            '损耗系数' => $value['损耗系数'],                   // 损耗系数
            '计损色数' => $value['Gy0_ms'],                    // 计损色数
            '计划产量' => $value['计划产量'],                   // 计划产量
            '计划损耗' => $value['Gy0_计划损耗'],              // 计划损耗
            '班组分摊计划损耗' => $value['计划损耗'],            // 班组分摊计划损耗
            '印件工序产量' => $value['工序产量'],                // 工序产量
            '班组产量' => $value['total_cl'],                  // 班组产量
            '班组制程废品' => $value['sczl_zcfp'],             // 班组制程废品
            '工单质检废' => $data['工单质检废'],                // 工单质检废
            '班组质检废品' => $value['zjfp'],                  // 班组质检废品
            '班组分摊质检废品' => $value['质检废'],              // 班组分摊质检废品
            '无班组废品' => 0,                                // 无班组废品
            '外发废' => $data['外发废'],                        // 外发废
            '材料废' => $data['材料废'],                        // 材料废
            '零头处理' => $data['零头处理'],                     // 零头处理
            '分摊废' => 0,                                    // 分摊废
            '分摊废明细' => 0,                                // 分摊废明细
            '印件无形损' => $data['intangible_loss'],          // 无形损耗
            '班组分摊无形损' => $value['无形损分摊'],           // 班组分摊无形损
            'CjsSl' => $value['节损数量'],                     // 节损数量
            'CjsJe' => str_replace(",", "", $value['节损奖']), // 节损奖金额
            '无形损承担比例' => $value['无形损承担比例'],        // 无形损承担比例
            '超节损承担比例' => $value['超节损承担比例'],        // 超节损承担比例
            '超节损核算单价' => $value['超节损核算单价'],        // 超节损核算单价
            'sczl_jtbh' => $value['sczl_jtbh'],               // 机台编号
            'sczl_bzdh' => $value['sczl_bzdh'],               // 班组单号
            'sczl_bh1' => $value['sczl_bh1'],                 // 班组成员1
            'sczl_bh2' => $value['sczl_bh2'],                 // 班组成员2
            'sczl_bh3' => $value['sczl_bh3'],                 // 班组成员3
            'sczl_bh4' => $value['sczl_bh4'],                 // 班组成员4
            'sczl_bh5' => $value['sczl_bh5'],                 // 班组成员5
            'sczl_bh6' => $value['sczl_bh6'],                 // 班组成员6
            'sczl_bh7' => $value['sczl_bh7'],                 // 班组成员7
            'sczl_bh8' => $value['sczl_bh8'],                 // 班组成员8
            'Xm1' => $value['sczl_name1'],                    // 成员姓名1
            'Xm2' => $value['sczl_name2'],                    // 成员姓名2
            'Xm3' => $value['sczl_name3'],                    // 成员姓名3
            'Xm4' => $value['sczl_name4'],                    // 成员姓名4
            'Xm5' => $value['sczl_name5'],                    // 成员姓名5
            'Xm6' => $value['sczl_name6'],                    // 成员姓名6
            'Xm7' => $value['sczl_name7'],                    // 成员姓名7
            'Xm8' => $value['sczl_name8'],                    // 成员姓名8
            'sczl_rate1' => $value['sczl_rate1'],             // 成员效率1
            'sczl_rate2' => $value['sczl_rate2'],             // 成员效率2
            'sczl_rate3' => $value['sczl_rate3'],             // 成员效率3
            'sczl_rate4' => $value['sczl_rate4'],             // 成员效率4
            'sczl_rate5' => $value['sczl_rate5'],             // 成员效率5
            'sczl_rate6' => $value['sczl_rate6'],             // 成员效率6
            'sczl_rate7' => $value['sczl_rate7'],             // 成员效率7
            'sczl_rate8' => $value['sczl_rate8'],             // 成员效率8
            '类型' => '',                                     // 类型
            '客户代号' => $value['Gd_客户代号'],                // 客户代号
            '客户名称' => $value['Gd_客户名称'],                // 客户名称
            '产品代号' => $value['Gd_cpdh'],                   // 产品代号
            '产品名称' => $value['Gd_cpmc'],                   // 产品名称
            '销售订单号' => $value['销售订单号'],                // 销售订单号
            '订单数量' => $value['订单数量'],                   // 订单数量
            '计量单位' => $value['计量单位'],                   // 计量单位
            '实际投料' => $data['实际投料'],                    // 实际投料
            '入仓数量' => $totalNumber,                       // 入仓数量
            '入仓日期' => $workOrderData['jjcp_sj'],          // 入仓日期
            '大箱数' => $value['投料大箱'],                    // 投料大箱数
            '废品合计' => $data['工单质检废'] + $data['zcfp'], // 废品合计
            'sys_id' => '',                                   // 系统ID
            'sys_rq' => date('Y-m-d H:i:s', time()),          // 系统日期
            '车间名称' => $value['Gy0_SITE']                  // 车间名称
        ];
    }
    
    return $result;
}

/**
 * 批量获取员工姓名
 * 
 * @param array $employeeIds 员工编号数组
 * @return array 员工姓名映射表（编号=>姓名）
 */
private function getEmployeeNames($employeeIds)
{
    if (empty($employeeIds)) return [];
    
    return db('人事_基本资料')
        ->where('员工编号', 'in', $employeeIds)
        ->column('rtrim(员工姓名)', '员工编号');
}


    /**
     * 超节损列表
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function getList()
    {
        if (!Request::instance()->isGet()) {
            $this->error('非法请求');
        }

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

        // 设置默认分页和限制
        $limit = empty($params['limit']) ? 15 : intval($params['limit']);
        $pages = empty($params['page']) ? 1 : intval($params['page']);

        // 构建查询条件
        if (!empty($params['code'])) {
            // 根据产品代号是否含有字母确定匹配长度
            $prefixLength = preg_match('/[A-Za-z]/', $params['code']) ? 5 : 4;
            $where['a.jjcp_cpdh'] = ['LIKE', substr($params['code'], 0, $prefixLength) . '%'];
        }

        if (!empty($params['date'])) {
            $year = substr($params['date'], 0, 4); // 取前4位作为年份
            $month = substr($params['date'], 4, 2); // 取后2位作为月份

            // 格式化为需要的值
            $formattedDate = $year . '-' . $month;
            $where['a.jjcp_sj'] = ['like',$formattedDate.'%'];
        }

        if (!empty($params['search'])) {
            if (!empty($params['date']) || !empty($params['code'])) {
                $this->error('参数错误');
            }
            $where['a.jjcp_gdbh|a.jjcp_cpdh|a.jjcp_cpmc'] = ['like', '%' . $params['search'] . '%'];
        }

        // 定义字段
        $field = '  
        b.sys_ny,  
        a.jjcp_gdbh AS Gd_gdbh,  
        a.jjcp_yjno AS jjcp_yjno,  
        a.jjcp_yjno AS yj_Yjno, 
        c.yj_Yjdh as yjdh,
        c.yj_ls AS yj_ls,  
        c.yj_cpdh AS 成品编码,  
        c.yj_yjmc AS 成品名称,  
        b.`实际投料`,  
        b.`计量单位`,  
        DATE(a.jjcp_sj) AS warehousing_date,  
        total_sl.warehousing_num,
        SUM(DISTINCT b.`计划损耗`) AS `工单计划损耗`,  
        b.`废品合计`,  
        SUM(b.`CjsJe`) AS reward_money,  
        b.`印件无形损` AS 工单无形损,  
        b.`材料废`,  
        b.`零头处理`,  
        b.`外发废`,  
        SUM(b.`班组制程废品`) AS zcfp,  
        `工单质检废` AS 工单质检废,
        c.质量考核,
        c.工单类型
    ';

        // 子查询：计算所有记录的 jjcp_sl 总和（入仓数量）
        $subQuery = \db('成品入仓')
            ->alias('a_sub')
            ->field('
        a_sub.jjcp_gdbh AS Gd_gdbh_sub,
        a_sub.jjcp_yjno AS jjcp_yjno_sub,
        SUM(a_sub.jjcp_sl) AS warehousing_num
        ')
            ->group('a_sub.jjcp_gdbh, a_sub.jjcp_yjno')
            ->buildSql();

        $list = \db('成品入仓')
            ->alias('a')
            ->join('工单_质量考核汇总 b','a.jjcp_gdbh = b.Gy0_gdbh AND a.jjcp_yjno = b.印件及工序','left')
            ->join('工单_印件资料 c','a.jjcp_gdbh = c.Yj_Gdbh AND a.jjcp_yjno = c.yj_Yjno')
            ->join([$subQuery => 'total_sl'], 'a.jjcp_gdbh = total_sl.Gd_gdbh_sub AND a.jjcp_yjno = total_sl.jjcp_yjno_sub', 'left')
            ->field($field)
            ->where($where)
            ->where('a.jjcp_smb','like','末%')
            ->group('Gd_gdbh,jjcp_yjno')
            ->order('warehousing_date DESC')
            ->page($pages)
            ->limit($limit)
            ->select();
        // 处理查询结果
        foreach ($list as $key => $value) {
            $status = \db('工单_印件资料')
                ->where('Yj_Gdbh', $value['Gd_gdbh'])
                ->where('yj_Yjno', $value['jjcp_yjno'])
                ->value('质量考核');
            $processDetail = \db('工单_工艺资料')
                ->where('Gy0_gdbh', $value['Gd_gdbh'])
                ->where('Gy0_yjno', $value['jjcp_yjno'])
                ->field('CONCAT(rtrim(Gy0_gxmc),"[",rtrim(Add_gxmc),"]") as 工序名称,Gy0_ls as 联数')
                ->select();
            $number1 = $number2 = 1;
            foreach ($processDetail as $k => $v) {
                if (strpos($v['工序名称'],'分切') !== false) {
                    $number1 = $v['联数'];
                }
                if (strpos($v['工序名称'],'分切') === false && $v['联数'] > 1) {
                    $number2 = $v['联数'];
                }
            }
            $Multiple = $number1/$number2;
            if (is_int($Multiple) === false) {
                $Multiple = 1;
            }
            $list[$key]['工单质检废'] = $value['废品合计'] - $value['zcfp'];
            $list[$key]['质量考核'] = $status;
            $list[$key]['考核'] = ($status == 1) ? '否' : '是';
            if ($value['实际投料'] !== null){
                $actualMaterial = $value['实际投料'] * 10000;
                $list[$key]['target_rate'] = $this->calculateRate($actualMaterial, $value['工单计划损耗']);
                $list[$key]['real_rate'] = $value['warehousing_num']/($value['实际投料']*10000)*100;
                $list[$key]['real_rate'] = number_format($list[$key]['real_rate'], 2).'%';
            }else{
                $list[$key]['target_rate'] = null;
                $list[$key]['real_rate'] = null;
            }
            $list[$key]['reward_rate'] = '1'; // or some logic if needed
        }
        if (!empty($list)) {
            $this->success('成功', $list);
        } else {
            $this->error('未找到数据');
        }
    }

// 计算合格率
    private function calculateRate($actual, $loss)
    {
        if ($actual == 0) {
            return '0.00%'; // 防止除以零
        }
        $rate = ($actual - $loss) / $actual * 100;
        return number_format($rate, 2) . '%';
    }

    /**
     * 工序超节损
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ProcessLoss()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param) || empty($param['order']) || empty($param['yjno'])){
            $this->error('参数错误');
        }
        $where = ['Gy0_gdbh'=>$param['order'],'印件及工序'=>$param['yjno']];
        //查询订单印件数据
        $field = '  
            Gy0_gdbh AS Gd_gdbh,   
            `印件及工序` AS yjno,   
            `联数` AS ls,  
            `产品代号` AS `成品代号`,  
            `产品名称` AS `成品名称`,  
            `实际投料`,  
            `计量单位`,  
            DATE(`入仓日期`) AS warehousing_date,  
            `入仓数量` AS warehousing_num,  
            SUM(DISTINCT `计划损耗`) AS `计划损耗`,  
            `废品合计`,  
            `印件无形损` as intangible_loss,  
            `材料废`,  
            `零头处理`,  
            `外发废`,  
            SUM(`班组制程废品`) AS `zcfp`,  
            `工单质检废` AS `班组分摊质检废品`,  
            `订单数量`,  
            `销售订单号`
            
        ';
        $list = \db('工单_质量考核汇总')
            ->field($field)
            ->where($where)
            ->group('Gy0_gdbh, `印件及工序`')
            ->order('sys_rq DESC')
            ->find();
        $processDetail = \db('工单_工艺资料')
            ->where('Gy0_gdbh', $param['order'])
            ->where('Gy0_yjno', $param['yjno'])
            ->field('CONCAT(rtrim(Gy0_gxmc),"[",rtrim(Add_gxmc),"]") as 工序名称,Gy0_ls as 联数')
            ->select();

            $status = \db('工单_印件资料')
    ->where('Yj_Gdbh', $param['order'])
    ->where('yj_Yjno', $param['yjno'])
    ->value('质量考核');

    // 添加到 $list 数组中
    $list['质量考核'] = $status;
    $list['考核'] = ($status == 1) ? '不参与考核' : '参与考核';
//        $number1 = $number2 = 1;
//        foreach ($processDetail as $k => $v) {
//            if (strpos($v['工序名称'],'分切') !== false) {
//                $number1 = $v['联数'];
//            }
//            if (strpos($v['工序名称'],'分切') === false && $v['联数'] > 1) {
//                $number2 = $v['联数'];
//            }
//        }
//        $Multiple = $number1/$number2;
//        if (is_int($Multiple) === false) {
//            $Multiple = 1;
//        }
        $list['实际投料'] = $list['实际投料']*10000;
        //目标合格率
        $list['target_rate'] = ($list['实际投料']-$list['计划损耗'])/$list['实际投料']*100;
        $list['target_rate'] = number_format($list['target_rate'],2);
        $list['target_rate'] = $list['target_rate'].'%';
        //实际合格率
//        $list['real_rate'] = $list['warehousing_num']/($list['实际投料']*$Multiple)*100;
        $list['real_rate'] = $list['warehousing_num']/($list['实际投料'])*100;
        $list['real_rate'] = number_format($list['real_rate'],2);
        $list['real_rate'] = $list['real_rate'].'%';

        //查询工序数据
        $gy_field = '  
            `工序` AS Gy0_gxh,  
            `工序名称` AS Gy0_gxmc,  
            `印件及工序` AS Gy0_yjno,  
            `联数` AS Gy0_ls,  
            计划损耗 AS Gy0_计划损耗,  
            `计划产量` AS Gy0_计划接货数,  
            SUM(`班组分摊无形损`) AS Gy0_无形损,  
            SUM(`CjsSl`) AS loss,  
            `印件工序产量` AS total_cl,  
            SUM(`班组制程废品`) AS total_fp,  
            SUM(`班组分摊质检废品`) AS waste_quality,
            SUM(`CjsJe`) AS 工序超节损金额,
            `无形损承担比例`,
            `超节损承担比例`
        ';
        $gy_data = \db('工单_质量考核汇总')
            ->field($gy_field)
            ->where($where)
            ->group('Gy0_gxh')
            ->select();
        foreach ($gy_data as $key=>$value){
            if (strpos($value['Gy0_gxmc'],'分切') === false) {
                $Multiple = 1;
            }
            //报废合计
            $gy_data[$key]['total_waste'] = $value['Gy0_无形损'] + $value['total_fp'] + $value['waste_quality'];
            //工序实际报废率
            $gy_data[$key]['actual_loss_rate'] = ((number_format($gy_data[$key]['total_waste']/$list['实际投料'],4))*100).'%';
            //工序目标报废率
            $gy_data[$key]['target_loss_rate'] = ((number_format($value['Gy0_计划损耗']/$list['实际投料'],4))*100).'%';
            //占投料报废率
            $gy_data[$key]['loss_rate'] = ((number_format(($value['Gy0_计划损耗']-$gy_data[$key]['total_waste'])/$list['实际投料'],4))*100).'%';
        }
        $list['gy_data'] = $gy_data;
        $total = [
            'total_waste' => 0,
            'total_zjfp' => 0,
            'total_fp' => 0,
            'plan_loss' => 0,
            'waste_intangible' => 0,
            'loss' => 0,
            'reward' => 0,
        ];
        foreach ($gy_data as $item){
            $total['total_waste'] += $item['total_waste'];
            $total['total_zjfp'] += $item['waste_quality'];
            $total['total_fp'] += $item['total_fp'];
            $total['plan_loss'] += $item['Gy0_计划损耗'];
            $total['waste_intangible'] += $item['Gy0_无形损'];
            $total['loss'] += $item['loss'];
            $total['reward'] += $item['工序超节损金额'];
        }
        $total['reward'] = round($total['reward'],2);
        //查询废品数量
        $out_sql = "SELECT qczl_num,fp_sl1,fp_sl2,fp_sl3,fp_sl4,fp_sl5,fp_sl6,fp_sl7,fp_sl8,fp_sl9,fp_sl10,fp_sl11,fp_sl12,fp_sl13,
                        fp_lb1,fp_lb2,fp_lb3,fp_lb4,fp_lb5,fp_lb6,fp_lb7,fp_lb8,fp_lb9,fp_lb10,fp_lb11,fp_lb12,fp_lb13, 
                        fp_bh1,fp_bh2,fp_bh3,fp_bh4,fp_bh5,fp_bh6,fp_bh7,fp_bh8,fp_bh9,fp_bh10,fp_bh11,fp_bh12,fp_bh13,
                        fp_gxmc1,fp_gxmc2,fp_gxmc3,fp_gxmc4,fp_gxmc5,fp_gxmc6,fp_gxmc7,fp_gxmc8,fp_gxmc9,fp_gxmc10,fp_gxmc11,fp_gxmc12,fp_gxmc13,UniqId
                        FROM db_qczl WHERE qczl_gdbh = '{$param['order']}' AND qczl_yjno = '{$param['yjno']}'";
        $waste_out = Db::query($out_sql);
        $machine = [];//机检废品数组
        $o = 0;
        foreach ($waste_out as $entry) {
            for ($i = 1; $i <= 13; $i++) {
                $labelKey = "fp_lb" . $i;
                $slKey = "fp_sl" . $i;
                if (!empty($entry[$labelKey])) {
                    //机检废品
                    if (substr($entry[$labelKey],0,1) == 'K' ){
                        $machine[$o]= $entry[$slKey];
                        $o++;
                    }
                }
            }
        }
        $list['机检废'] = array_sum($machine);//机检废
        $list['total'] = $total;
        $this->success('成功',$list);
    }


    //班组超节损数据
    public function ClassLossData()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param) || empty($param['order']) || empty($param['yjno'])){
            $this->error('参数错误');
        }
        $where = ['Gy0_gdbh'=>$param['order'],'印件及工序'=>$param['yjno']];
        //查询订单印件数据
        $field = '  
            Gy0_gdbh AS Gd_gdbh,   
            `印件及工序` AS yjno,   
            `联数` AS ls,  
            `产品代号` AS `成品代号`,  
            `产品名称` AS `成品名称`,  
            `实际投料`,  
            `计量单位`,  
            DATE(`入仓日期`) AS warehousing_date, 
            `入仓数量` AS warehousing_num,  
            SUM(DISTINCT `计划损耗`) AS `计划损耗`,  
            `废品合计`,  
            `印件无形损` as intangible_loss,  
            `材料废`,  
            `零头处理`,  
            `外发废`,  
            SUM(`班组制程废品`) AS `zcfp`,  
            `工单质检废` AS `班组分摊质检废品`,  
            `订单数量`,  
            `销售订单号`
            
        ';
        $list = \db('工单_质量考核汇总')
            ->field($field)
            ->where($where)
            ->group('Gy0_gdbh, `印件及工序`')
            ->order('sys_rq DESC')
            ->find();

        $processDetail = \db('工单_工艺资料')
            ->where('Gy0_gdbh', $param['order'])
            ->where('Gy0_yjno', $param['yjno'])
            ->field('CONCAT(rtrim(Gy0_gxmc),"[",rtrim(Add_gxmc),"]") as 工序名称,Gy0_ls as 联数')
            ->select();

            $status = \db('工单_印件资料')
    ->where('Yj_Gdbh', $param['order'])
    ->where('yj_Yjno', $param['yjno'])
    ->value('质量考核');

        // 添加到 $list 数组中
        $list['质量考核'] = $status;
        $list['考核'] = ($status == 1) ? '不参与考核' : '参与考核';
//        $number1 = $number2 = 1;
//        foreach ($processDetail as $k => $v) {
//            if (strpos($v['工序名称'],'分切') !== false) {
//                $number1 = $v['联数'];
//            }
//            if (strpos($v['工序名称'],'分切') === false && $v['联数'] > 1) {
//                $number2 = $v['联数'];
//            }
//        }
//        $Multiple = $number1/$number2;
//        if (is_int($Multiple) === false) {
//            $Multiple = 1;
//        }

        $list['实际投料'] = $list['实际投料']*10000;
        //目标合格率
        $list['target_rate'] = ($list['实际投料']-$list['计划损耗'])/$list['实际投料']*100;
        $list['target_rate'] = number_format($list['target_rate'],2);
        $list['target_rate'] = $list['target_rate'].'%';
        //实际合格率
//        $list['real_rate'] = $list['warehousing_num']/($list['实际投料']*$Multiple)*100;
        $list['real_rate'] = $list['warehousing_num']/($list['实际投料'])*100;
        $list['real_rate'] = number_format($list['real_rate'],2);
        $list['real_rate'] = $list['real_rate'].'%';
        //班组数据
        $gy_data = \db('工单_质量考核汇总')
            ->where($where)
            ->select();
        $class_data = [];
        foreach ($gy_data as $item){
            $name = '';
            for ($i=1;$i<9;$i++){
                if ($item['Xm'.$i] !== ''){
                    $name = $name.' '.$item['Xm'.$i];
                }
            }
            $data = [
                'member' => $name,
                'sczl_gxmc' => $item['工序名称'],
                'total_cl' => $item['班组产量'],
                '计划损耗' => $item['班组分摊计划损耗'],
                '无形损分摊' => $item['班组分摊无形损'],
                '节损奖' => $item['CjsJe'],
                '节损数量' => $item['CjsSl'],
                'sczl_zcfp' => $item['班组制程废品'],
                '质检废' => $item['班组分摊质检废品'],
                '超节损承担比例' => ($item['超节损承担比例']*100).'%',
            ];
            array_push($class_data,$data);
        }
        $list['gy_data'] = $class_data;
        //工单节损数据
        $total_field = '
            SUM(`班组分摊质检废品`) as total_waste,
            SUM(`班组质检废品`) as total_zjfp,
            SUM(`班组制程废品`) as total_fp,
            SUM(DISTINCT `计划损耗`) AS plan_loss,
            `材料废`,
            `印件无形损` as waste_intangible,
            SUM(CjsSl) as loss,
            SUM(CjsJe) as reward
        ';
        $total = \db('工单_质量考核汇总')
            ->where($where)
            ->field($total_field)
            ->find();
        //查询废品数量
        $out_sql = "SELECT qczl_num,fp_sl1,fp_sl2,fp_sl3,fp_sl4,fp_sl5,fp_sl6,fp_sl7,fp_sl8,fp_sl9,fp_sl10,fp_sl11,fp_sl12,fp_sl13,
                        fp_lb1,fp_lb2,fp_lb3,fp_lb4,fp_lb5,fp_lb6,fp_lb7,fp_lb8,fp_lb9,fp_lb10,fp_lb11,fp_lb12,fp_lb13, 
                        fp_bh1,fp_bh2,fp_bh3,fp_bh4,fp_bh5,fp_bh6,fp_bh7,fp_bh8,fp_bh9,fp_bh10,fp_bh11,fp_bh12,fp_bh13,
                        fp_gxmc1,fp_gxmc2,fp_gxmc3,fp_gxmc4,fp_gxmc5,fp_gxmc6,fp_gxmc7,fp_gxmc8,fp_gxmc9,fp_gxmc10,fp_gxmc11,fp_gxmc12,fp_gxmc13,UniqId
                        FROM db_qczl WHERE qczl_gdbh = '{$param['order']}' AND qczl_yjno = '{$param['yjno']}'";
        $waste_out = Db::query($out_sql);
        $machine = [];//机检废品数组
        $o = 0;
        foreach ($waste_out as $entry) {
            for ($i = 1; $i <= 13; $i++) {
                $labelKey = "fp_lb" . $i;
                $slKey = "fp_sl" . $i;
                if (!empty($entry[$labelKey])) {
                    //机检废品
                    if (substr($entry[$labelKey],0,1) == 'K' ){
                        $machine[$o]= $entry[$slKey];
                        $o++;
                    }
                }
            }
        }
        $list['机检废'] = array_sum($machine);//机检废
        $list['total'] = $total;
        $this->success('成功',$list);

    }


    /**
     * 循环插入超节损数据
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function orderLossData()
    {
        $param = $this->request->param();
        $where = [];
        if (isset($param['gdbh']) && isset($param['yjno']) && !empty($param['gdbh']) && !empty($param['yjno'])){
            $where['a.jjcp_gdbh'] = $param['gdbh'];
            $where['a.jjcp_yjno'] = $param['yjno'];
        }
        if (isset($param['mouth'])){
            $where['a.jjcp_sj'] = ['like',$param['mouth'].'%'];
        }
        $where['a.jjcp_smb'] = ['like','末%'];
        $list = \db('成品入仓')
            ->alias('a')
            ->join('设备_产量计酬 b','a.jjcp_gdbh = b.sczl_gdbh AND a.jjcp_yjno = b.sczl_yjno')
            ->join('物料_收发记录 c','a.jjcp_gdbh = c.st_gdbh AND a.jjcp_cpdh = c.cpdh')
            ->where($where)
            ->where(function ($query) {
                $query->where('c.仓库编号', '101')
                    ->whereOr('c.仓库编号', 'Y101');
            })
            ->field('a.jjcp_gdbh,a.jjcp_yjno')
            ->group('a.jjcp_gdbh,a.jjcp_yjno')
            ->select();

        $i = 0;
        if (empty($list)) {
            $this->error('未搜索到工单入仓数据');
        }
        foreach ($list as $item){
            $jobData = [
                'gdbh' => $item['jjcp_gdbh'],
                'yjno' => $item['jjcp_yjno'],
                'created_at' => date('Y-m-d H:i:s'),
            ];
            $res = Queue::push('app\\job\\OrderSuperLossJob', $jobData, 'order_loss_calculation');
            if (!$res) {
                $i++;
            }
        }
        if ($i === 0){
            $this->success('任务已提交，共' . count($list) . '条');
        }else{
            $this->error('提交完成，失败' . $i . '条');
        }
    }


    /**
     * 创建投料数
     * @return void
     */
    public function feedAdd()
    {
        // 1. 请求验证
        if (!$this->request->isPost()) {
            $this->error('请求错误');
        }

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

        // 2. 数据验证
        $requiredFields = ['st_gdbh', 'st_sl', 'st_dw', 'sys_id', 'cpdh'];
        foreach ($requiredFields as $field) {
            if (!isset($param[$field]) || $param[$field] === '') {
                $this->error("参数{$field}不能为空");
            }
        }

        try {
            // 3. 数据准备
            $currentTime = date('Y-m-d H:i:s');
            $currentDate = date('Y-m-d');

            // 仓库编号逻辑
            $cangku = preg_match('/[a-zA-Z]/', $param['st_gdbh']) ? 'Y101' : '101';

            // 4. 主数据
            $data = [
                'st_rq' => $currentDate,
                'st_jylb' => '生产领料',
                'st_gdbh' => $param['st_gdbh'],
                'st_wlbh' => $param['st_wlbh'],
                'st_sl' => $param['st_sl'],
                'st_dw' => $param['st_dw'],
                'sys_id' => $param['sys_id'],
                'sys_rq' => $currentTime,
                'cpdh' => $param['cpdh'],
            ];

            // 添加仓库编号（特殊处理）
            $data['`仓库编号`'] = $cangku;

            // 5. 日志数据
            $logData = [
                'Gd_gdbh' => $param['st_gdbh'],
                'ModifyUser' => $param['sys_id'],
                'ModifyTime' => $currentTime,
                'FieldName' => 'st_sl',
                'NewValue' => $param['st_sl'],
                'ModifySource' => '新增物料投料数'
            ];

            // 6. 开启事务
            Db::startTrans();

            // 7. 插入日志
            Db::name('系统操作日志表')->insert($logData);

            // 8. 插入主记录 - 手动构建安全的SQL语句
            $fields = array_keys($data);
            $values = array_values($data);

            // 构建字段名部分
            $fieldList = implode(', ', array_map(function($field) {
                return strpos($field, '`') === 0 ? $field : "`{$field}`";
            }, $fields));

            // 构建占位符
            $placeholders = implode(', ', array_fill(0, count($values), '?'));

            // 执行安全的参数化查询
            $sql = "INSERT INTO `物料_收发记录` ({$fieldList}) VALUES ({$placeholders})";
            $feedResult = Db::execute($sql, $values);

            if ($feedResult === false) {
                throw new Exception('新增物料记录失败');
            }

            // 9. 获取工单信息
            $totalNum = Db::name('工单_印件资料')
                ->field('yj_ls, yj_ks, yj_tlgg, yj_zzmc, yj_Yjno')
                ->where('Yj_Gdbh', $param['st_gdbh'])
                ->where('yj_Yjdh', $param['cpdh'])
                ->find();

            if (!$totalNum) {
                throw new Exception('未找到对应的工单印件资料');
            }

            // 10. 计算投料数量
            $num = $param['st_sl'];
            if (!empty($totalNum['yj_tlgg'])) {
                $dimensions = explode('*', $totalNum['yj_tlgg']);
                $number1 = (int)($dimensions[0] ?? 0);
                $number2 = (int)($dimensions[1] ?? 0);

                preg_match('/(\d+)g/', $totalNum['yj_zzmc'], $matches);
                $paperWeight = $matches[1] ?? 0;

                if ($param['st_dw'] === '吨' && $paperWeight > 0 && $number1 > 0 && $number2 > 0) {
                    $num = round(($param['st_sl'] * 1000000) / $paperWeight / ($number1 * $number2) * 1000000);
                }
            }

            // 11. 计算实际投料
            $actualFeed = $num / 10000 * $totalNum['yj_ls'] * $totalNum['yj_ks'];

            // 12. 更新工单基本资料 - 使用原生SQL处理中文字段
            $updateBasicSql = "UPDATE `工单_基本资料` SET `实际投料` = ? WHERE `Gd_gdbh` = ? AND `Gd_cpdh` = ?";
            $basicResult = Db::execute($updateBasicSql, [$actualFeed, $param['st_gdbh'], $param['cpdh']]);

            if ($basicResult === false) {
                throw new Exception('更新工单基本资料失败');
            }

            // 13. 更新工单印件资料 - 使用原生SQL
            $updateYjSql = "UPDATE `工单_印件资料` SET `yj_实际投料` = ? WHERE `Yj_Gdbh` = ? AND `yj_cpdh` = ?";
            $yjResult = Db::execute($updateYjSql, [$actualFeed, $param['st_gdbh'], $param['cpdh']]);

            if ($yjResult === false) {
                throw new Exception('更新工单印件资料失败');
            }

            $yjNo = $totalNum['yj_Yjno'];

            // 14. 重新计算工单超节损数据
            $resultAdd = $this->OneOrderSuperLoss($param['st_gdbh'], $yjNo);

            // 15. 更新质量考核汇总 - 先删除
            $deleteSql = "DELETE FROM `工单_质量考核汇总` WHERE `Gy0_gdbh` = ? AND `印件及工序` = ?";
            Db::execute($deleteSql, [$param['st_gdbh'], $yjNo]);

            // 16. 插入新的质量考核数据
            if (!empty($resultAdd)) {
                foreach ($resultAdd as $item) {
                    $fields = array_keys($item);
                    $values = array_values($item);

                    $fieldList = implode(', ', array_map(function($field) {
                        return strpos($field, '`') === 0 ? $field : "`{$field}`";
                    }, $fields));

                    $placeholders = implode(', ', array_fill(0, count($values), '?'));

                    $insertSql = "INSERT INTO `工单_质量考核汇总` ({$fieldList}) VALUES ({$placeholders})";
                    Db::execute($insertSql, $values);
                }
            }

            // 17. 提交事务
            Db::commit();

            $this->success('新增成功');

        } catch (Exception $e) {
            // 18. 回滚事务
            Db::rollback();
            $this->error('操作失败: ' . $e->getMessage());
        }
    }
    /**
     * 获取物料信息
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function getFeedList()
    {
        if (Request::instance()->isGet() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->request();
        if (empty($params['workorder']) || empty($params['yjno'])) {
            $this->error('参数错误');
        }
        $field = "a.Gd_gdbh,rtrim(c.yj_Yjdh) as yj_yjdh,c.yj_Yjno, c.yj_ks,c.yj_ls,rtrim(c.yj_zzdh) as yj_zzdh,
                  rtrim(b.BOM_物料名称) as BOM_物料名称,rtrim(c.yj_tlgg) as yj_tlgg,
                  a.订单数量,c.yj_平张投料, b.BOM_实际用量,a.投料确认";
        $data =db('工单_基本资料')->alias('a')
            ->join('工单_印件资料 c','a.Gd_gdbh = c.Yj_Gdbh ','left')
            ->join('工单_bom资料 b','c.Yj_Gdbh = b.BOM_工单编号 AND c.yj_zzdh = b.BOM_物料编码','left')
            ->where('a.Gd_gdbh',$params['workorder'])
            ->where('c.yj_Yjno',$params['yjno'])
            ->field($field)
            ->group('a.Gd_gdbh')
            ->order('b.BOM_投料单位,a.UniqId asc')
            ->select();
        if (empty($data)){
            $this->success('请求成功');
        }
        foreach ($data as $key=>$value){
            $len = stripos($value['yj_tlgg'],'/');
            if ($len){
                $name = substr($value['yj_tlgg'],0,$len);
                $len_two = stripos($value['yj_tlgg'],'（');
                if ($len_two){
                    $name = substr($name,0,$len_two);
                }
                $data[$key]['yj_tlgg'] = $name;
            }
            $data[$key]['rate'] = '';
        }
        $this->success('请求成功',$data);
    }


    /**
     * 获取工单类型
     * @return void
     */
    public function getWorkorderStatus()
    {
        if ($this->request->isGet() == false) {
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param['workorder']) || empty($param['yjno'])) {
            $this->error('参数错误');
        }
        $data = \db('工单_印件资料')
            ->where('Yj_Gdbh',$param['workorder'])
            ->where('yj_Yjno',$param['yjno'])
            ->field('Yj_gdbh,rtrim(yj_Yjdh) as yj_Yjdh,yj_Yjno,rtrim(yj_yjmc) as yj_yjmc,工单类型')
            ->find();
        $this->success('成功',$data);
    }

    /**
     * 修改工单类型
     * @return void
     * @throws Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function updateWorkorderStatus()
    {
        if ($this->request->isGet() == false) {
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param['workorder']) || empty($param['yjno']) || empty($param['status'])) {
            $this->error('参数错误');
        }
        $sql = \db('工单_印件资料')
            ->where('Yj_Gdbh',$param['workorder'])
            ->where('yj_Yjno',$param['yjno'])
            ->fetchSql(true)
            ->update(['工单类型'=>$param['status']]);
        $result = db()->query($sql);
        if ($result !== false) {
            $this->success('修改成功');
        }else{
            $this->error('修改失败');
        }

    }
}