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

<?php

namespace app\api\controller;


use app\common\controller\Api;
use think\Db;
use think\Request;

/**
 * 质量继绩效管理
 */

class Facility extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];


    /**
     * 查询月份数据
     */
    public function ApiMouthlist() {
        // 检查请求类型是否为GET
        if ($this->request->isGet() === false) {
            $this->error('请求错误');
        }
        $param = $this->request->param();
        // 查询符合条件的数据
        $list = \db('设备_质量汇总')
            ->where('状态', $param['code'])
            ->where('mod_rq', null)
            ->group('Sys_rq')
            ->select();
        if (empty($list)) {
            $this->error('没有找到数据');
        }
        // 用于存储按年和月分类的数据
        $data = [];
        // 遍历查询结果，将日期按年、月分组
        foreach ($list as $item) {
            // 获取 Sys_rq 字段的值（日期）
            $sys_rq = $item['Sys_rq'];

            // 提取年、月、日
            $year = date('Y', strtotime($sys_rq));
            $month = date('Y-m', strtotime($sys_rq));
            $day = date('Y-m-d', strtotime($sys_rq));

            // 将数据按年、月、日分类
            if (!isset($data[$year])) {
                $data[$year] = [];
            }

            if (!isset($data[$year][$month])) {
                $data[$year][$month] = [];
            }

            // 将日期加入到对应的年、月下
            $data[$year][$month][] = $day;
        }
        $this->success('成功', $data);
    }


    /**
     * 新增次品和新增返工
     */
    public function ApiAddDefective(){
        if (!$this->request->isPost()) {
            $this->error('非法请求');
        }
        $params = $this->request->param();
        if (empty($params)){
            $this->error('参数错误');
        }

        $res = \db('设备_质量汇总')->where('mod_rq', null)->order('status_num desc')->find();
        //记录每次新增次数排序
        $status_num = $res['status_num'];

        // 构建单条记录的函数，传递 $list_gd 作为参数
        function buildRecords($item,$status_num) {
            // 拆分物料名称（假设格式为 面料分类-面料名称）
            $materialParts = explode('-', $item['物料名称']);
            $materialCategory = isset($materialParts[0]) ? $materialParts[0] : '';  // 面料分类
            $materialName = isset($materialParts[1]) ? $materialParts[1] : '';  // 面料名称


            return [
                '订单编号' => $item['订单编号'],
                '生产款号' => $item['生产款号'],
                '款式' => $item['款式'],
                '颜色' => $item['颜色'],
                '尺码' => $item['尺码'],
                '数量' => $item['数量'],
                '组别' => $item['组别'],
                '实际用料' => $item['实际用料'],
                '计划用料' => $item['计划用料'],
                '备注' => $item['备注'],
                '问题分类' => $item['问题分类'],
                'sczl_rq' => date('Y-m-d H:i:s'),
                'Sys_rq' =>  $item['Sys_rq'],
                'Sys_id' => $item['Sys_id'],
                '状态' => $item['状态'],
                'status_num' => $status_num + 1,
                '面料分类' => $materialCategory,
                '面料名称' => $materialName,

            ];
        }

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

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


    /**
     * 查询订单对应尺码
     */
    public function queryOrderSize() {
        // 检查请求类型是否为GET
        if ($this->request->isGet() === false) {
            $this->error('请求错误');
        }
        $param = $this->request->param();

        // 获取问题分类
        $fetchCategory = \db('db_问题分类')->field('问题类型')->select();
        $category = array_column($fetchCategory, '问题类型'); // 获取问题类型列表

        // 查询订单基本信息
        $gdlist = \db('工单_基本资料')
            ->field('订单编号,生产款号,款式,订单数量')
//            ->where('订单编号|生产款号','like','%'.$param['订单编号'].'%')
            ->where(['订单编号|生产款号' => $param['订单编号']])
            ->where('Mod_rq', null)
            ->find();
        if (empty($gdlist)) {
            $this->error('未找到相关数据');
        }


        // 查询订单尺码信息
        $sizeData = \db('工单_印件资料')->where(['订单编号' => $gdlist['订单编号']])->where('Mod_rq', null)->select();
        if (empty($sizeData)) {
            $this->error('未找到相关数据');
        }

        // 计算所有尺码数据
        $sizes = [];
        foreach ($sizeData as $order) {
            foreach ($order as $key => $value) {
                if (strpos($key, 'cm') === 0 && strpos($key, 'cmsl') === false && $value !== null && $value !== '') {
                    $sizes[] = $value;
                }
            }
        }
        $sizes = array_values(array_unique($sizes)); // 去重后的尺码数据

        // 获取颜色备注并统计每个颜色的sctotal和zdtotal
        $colorData = []; // 用于存储每个颜色备注对应的sctotal和zdtotal
        foreach ($sizeData as $item) {
            if (!empty($item['颜色备注'])) {
                $color = $item['颜色备注'];

                $sctotal = (int)$item['sctotal'];
                $zdtotal = (int)$item['zdtotal'];
                if (isset($colorData[$color])) {
                    $colorData[$color]['sctotal'] += $sctotal;
                    $colorData[$color]['zdtotal'] += $zdtotal;
                } else {
                    $colorData[$color] = [
                        'sctotal' => $sctotal,
                        'zdtotal' => $zdtotal
                    ];
                }
            }
        }
        // 获取颜色备注（去重）
        $colorremark = array_values(array_unique(array_keys($colorData)));

        // 获取面料数据
        $getAllFabricData = \db('工单_面料资料')
            ->field('BOM_desc,BOM_物料名称,BOM_定额门幅,BOM_计划门幅,BOM_颜色')
            ->where('BOM_工单编号', $param['订单编号'])
            ->where('Mod_rq', null)
            ->select();
        $fabricData = [];
        $materialSeen = [];
        $descNullData = [];

        // 处理面料数据
        foreach ($getAllFabricData as $value) {
            $materialName = $value['BOM_物料名称'];
            $bomDesc = $value['BOM_desc'];
            $combinedData = ($bomDesc ? $bomDesc : '') . ' - ' . $materialName;

            // 如果 BOM_desc 为空，记录该物料名称
            if (empty($bomDesc)) {
                $descNullData[] = $combinedData;
                continue;
            }

            // 如果 BOM_desc 不为空，检查该物料名称是否已经出现过
            if (!in_array($materialName, $materialSeen)) {
                $fabricData[] = $combinedData;
                $materialSeen[] = $materialName;
            }
        }

        // 处理 BOM_desc 为空的物料名称，确保不重复添加
        foreach ($descNullData as $combinedData) {
            if (!in_array($combinedData, $fabricData)) {
                $fabricData[] = $combinedData;
            }
        }

        // 去重处理面料数据
        $finalFabricData = [];
        $seenDescriptions = [];

        foreach ($fabricData as $item) {
            $parts = explode(' - ', $item);
            if (count($parts) == 2) {
                $desc = $parts[0];
                $material = $parts[1];

                // 如果物料没有被记录过，或者描述不为空，保留数据
                if (!in_array($material, $seenDescriptions)) {
                    $finalFabricData[] = $item;
                    $seenDescriptions[] = $material;
                }
            } else {
                // 描述为空的直接保留
                $finalFabricData[] = $item;
            }
        }

        // 用于统计每个物料的用料情况
        $uniqueFabricData = []; // 去重后的面料数据
        foreach ($getAllFabricData as $fabric) {
            $key = $fabric['BOM_颜色'] . '-' . $fabric['BOM_物料名称']; // 以颜色和物料名称为唯一标识
            $uniqueFabricData[$key] = $fabric; // 使用唯一标识作为数组的键，自动去重
        }
        // 重建数组索引，移除键名
        $uniqueFabricData = array_values($uniqueFabricData);
        $materialUsage = [];
        // 遍历每种颜色的统计数据
        foreach ($colorData as $color => $data) {
            // 遍历去重后的面料数据
            foreach ($uniqueFabricData as $fabric) {
                // 判断颜色是否匹配
                if ($fabric['BOM_颜色'] === $color) {
                    // 直接统计每个物料的数量，而不进行用料的计算
                    $materialUsage[$color][$fabric['BOM_物料名称']][] = $fabric; // 使用物料名称作为键，存储所有相关的面料数据
                }
            }
        }

        // 生成实际用料数据
        $actualUsage = [];
        foreach ($materialUsage as $color => $materials) {
            foreach ($materials as $materialName => $fabricData) {
                // 获取该颜色下的 sctotal 和 zdtotal
                $sctotal = isset($colorData[$color]['sctotal']) ? $colorData[$color]['sctotal'] : 0;
                $zdtotal = isset($colorData[$color]['zdtotal']) ? $colorData[$color]['zdtotal'] : 0;
                // 获取定额门幅和计划门幅
                $standardWidth = isset($fabricData[0]['BOM_定额门幅']) ? $fabricData[0]['BOM_定额门幅'] : 0;
                $plannedWidth = isset($fabricData[0]['BOM_计划门幅']) ? $fabricData[0]['BOM_计划门幅'] : 0;
                // 直接根据去重后的面料数据进行统计
                $actualUsage[] = [
                    '颜色' => $color,
                    '物料名称' => $materialName,
                    '定额门幅' => $standardWidth,
                    '计划门幅' => $plannedWidth,
                    'sctotal' => $sctotal,
                    'zdtotal' => $zdtotal
                ];
            }
        }

        foreach ($actualUsage as &$item) {
            $item['实际用料'] = $item['sctotal'] * $item['定额门幅'];
            $item['计划用料'] = $item['zdtotal'] * $item['计划门幅'];
        }

        // 选择显示的字段
        $fieldsToShow = ['颜色', '物料名称', '实际用料', '计划用料'];
        $finalResult = array();
        foreach ($actualUsage as $item) {
            $filteredItem = array();
            foreach ($fieldsToShow as $field) {
                if (isset($item[$field])) {
                    $filteredItem[$field] = $item[$field];
                }
            }
            $finalResult[] = $filteredItem;
        }


        $this->success('成功', [
            'list' => $gdlist,
            'colorremark' => $colorremark,
            'fetchCategory' => $category,
            'FabricData' => $finalFabricData,
            'size' => $sizes,
            '面料统计' => $finalResult
        ]);
    }


    /**
     * 查询次片、返工列表数据
     */
    /**
     * 查询次片、返工列表数据
     */
    public function ApiSubPieceAndReworkList() {
        if ($this->request->isGet() === false) {
            $this->error('请求错误');
        }
        $params = $this->request->param();
        $where = ['mod_rq' => null];
        if (!empty($params['code'])) {
            $where['状态'] = $params['code'];
        }
        if (!empty($params['search'])) {
            $where['订单编号|生产款号|面料名称'] = ['like', '%' . $params['search'] . '%'];
        }
        if (!empty($params['Sys_rq'])) {
            $where['Sys_rq'] = $params['Sys_rq'];
        }
        $query = \db('设备_质量汇总')
            ->where($where)
            ->limit(($params['page'] - 1) * $params['limit'], $params['limit']);
        $res = $query->select();
        $total = $query->count();
        $this->success('成功', ['data' => $res, 'total' => $total]);
    }

//    /**
//     * 更新问题分类接口
//     */
//    public function Production()
//    {
//
//    }

    /**
     * 统计面料次品汇总
     * 统计面料返工汇总
     */
//        if ($this->request->isGet() === false){
//            $this->error('请求错误');
//        }
//        $params = $this->request->param();

    public function ApiDefectsAndRework()
    {
        // 查询设备质量汇总数据，mod_rq为空
        $list = \db('设备_质量汇总')
            ->where('mod_rq', null)
            ->where('状态', '次片')
            ->select();

        // 创建一个空数组来存储面料名称及其对应的总数量
        $fabricSummary = [];

        // 遍历查询结果，累加相同面料名称的数量
        foreach ($list as $item) {
            $fabricName = $item['面料名称'];
            $quantity = $item['数量'];
            // 如果该面料名称已存在于数组中，则累加数量
            if (isset($fabricSummary[$fabricName])) {
                $fabricSummary[$fabricName] += $quantity;
            } else {
                // 如果该面料名称不存在，则初始化数量
                $fabricSummary[$fabricName] = $quantity;
            }
        }

        // 打印结果
        echo "<pre>";
        print_r($fabricSummary);
        echo "</pre>";
    }



    /**
     * 工序、印件、完成数量
     * @ApiMethod (GET)
     * @param string $workOrder  工单编号
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function Procedure()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $workOrder = input('Gd_gdbh');
        $data = [];
        if (!empty($workOrder)){
            //右边工艺及完成数量
            $Process = \db('设备_产量计酬')->where('sczl_gdbh',$workOrder)
                ->distinct(true)->order('sczl_gxh')
                ->column('sczl_gxh');
            foreach ($Process as $k=>$v){
                $res= \db('设备_产量计酬')->where('sczl_gdbh',$workOrder)
                    ->where('sczl_gxh',$v)
                    ->field('rtrim(sczl_yjno) as sczl_yjno,rtrim(sczl_gxmc) as sczl_gxmc')
                    ->find();
                if ($res['sczl_yjno']<10){
                    $res['sczl_yjno'] = '0'.$res['sczl_yjno'];
                }
                $processList['process'] = $res['sczl_yjno'].'-'.$res['sczl_gxmc'];
                $processList['completed'] = \db('设备_产量计酬')
                    ->where('sczl_gdbh',$workOrder)
                    ->where('sczl_gxh',$v)
                    ->count();
                array_push($data,$processList);
            }
        }
        $this->success('成功',$data);
    }


    /**
     * 班组人员及分配比例
     * @ApiMethod （GET）
     * @param string $machine 机台编号
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */

    public function Team()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $machine = input('machine');
        if (empty($machine)){
            $this->error('参数错误');
        }
        $where = [
            'sczl_jtbh' => $machine,
        ];
        $field = 'rtrim(sczl_bzdh) as 班组号,rtrim(sczl_bh1) as bh1,rtrim(sczl_bh2) as bh2,rtrim(sczl_bh3) as bh3,rtrim(sczl_bh4) as bh4,
        rtrim(sczl_bh5) as bh5,rtrim(sczl_bh6) as bh6,rtrim(sczl_bh7) as bh7,rtrim(sczl_bh8) as bh8,rtrim(sczl_bh9) as bh9,
        rtrim(sczl_bh10) as bh10,rtrim(sczl_rate1) as rate1,rtrim(sczl_rate2) as rate2,rtrim(sczl_rate3) as rate3,rtrim(sczl_rate4) as rate4,
        rtrim(sczl_rate5) as rate5,rtrim(sczl_rate6) as rate6,rtrim(sczl_rate7) as rate7,rtrim(sczl_rate8) as rate8,
        rtrim(sczl_rate9) as rate9,rtrim(sczl_rate10) as rate10,rtrim(UniqId) as ID';
        $team = \db('设备_产量计酬')
            ->where('sczl_jtbh',$machine)
            ->field($field)
            ->order('UniqId desc')
            ->find();
        $list = \db('设备_班组资料')->where($where)->field($field)->select();
        $data = [];
        foreach ($list as $k=>$v){
            if ($team == $v){
                $data[$k]['status'] = 1;
            }else{
                $data[$k]['status'] = 0;
            }
            $data[$k]['ID'] = $v['ID'];
            $data[$k]['班组号'] = $v['班组号'];
            for ($i=1;$i<11;$i++){
                if ($v['bh'.$i] != '' && $v['bh'.$i] != '000000'){
                    $name = \db('人事_基本资料')->where('员工编号',$v['bh'.$i])->field('rtrim(员工姓名) as 姓名')->find();
                    if ($v['rate'.$i] > 0){
                        $data[$k][$i-1] = $v['bh'.$i].' '.$name['姓名'].' ('.number_format($v['rate'.$i]*100,2).'%'.')';
                    }else{
                        $data[$k][$i-1] = $v['bh'.$i].' '.$name['姓名'].' (0.00%'.')';
                    }

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


    /**
     * 当班产量明细
     * @ApiMethod (GET)
     * @param string $machine  机台编号
     * @param string $workOrder  工单编号
     * @param string $team   班次
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function OutputDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $machine = input('machine');
        $workOrder = input('Gd_gdbh');
        $team = substr(input('team'),0,1);
        if (empty($machine) || empty($team)){
            $this->success('');
        }
        $sczlTime = date('Y-m-d H:i:s',time());
        if ($sczlTime>date('Y-m-d 00:00:00') && $sczlTime<date('Y-m-d 08:30:00')){
            $time = date('Y-m-d 00:00:00',time()-86400);
        }else{
            $time = date('Y-m-d 00:00:00');
        }
        $where = [
            'sczl_jtbh' => $machine,
            'sczl_bzdh' => ['like',$team.'%'],
            'sczl_rq' => $time,
        ];
        $field = 'rtrim(sczl_gdbh) as 工单编号,rtrim(sczl_yjno) as yjno,rtrim(sczl_num) as 流程单号,rtrim(sczl_dedh) as dedh,rtrim(sczl_gxmc) as gxmc,rtrim(sczl_num) as 标牌号,rtrim(sczl_cl) as 产量,
        rtrim(sczl_zcfp) as 制程废品,rtrim(sczl_zccp) as 制程次品,rtrim(sczl_前工序废) as 前工序废,rtrim(sczl_来料少数) as 来料异常,rtrim(sczl_装版工时) as 装版工时,
        rtrim(sczl_保养工时) as 保养工时,rtrim(sczl_打样工时) as 打样工时,rtrim(sczl_异常停机工时) as 异常停机工时,rtrim(sczl_设备运行工时) as 通电工时,
        rtrim(码开始行) as 码开始行,rtrim(码结束行) as 码结束行,rtrim(码包) as 码包,rtrim(主电表) as 主电表,rtrim(辅电表) as 辅电表,rtrim(sczl_ms) as 色度,
        rtrim(sczl_sj1) as sj1,rtrim(sczl_sj2) as sj2,rtrim(UniqId) as UniqId,rtrim(sczl_bh98) as 拉料,rtrim(sczl_ls) as ls';
        $list = \db('设备_产量计酬')->where($where)->field($field)->order('UniqId desc')->select();
        if (!empty($list)){
            foreach ($list as $k=>$v){
                $name = \db('工单_基本资料')->where('Gd_gdbh',$v['工单编号'])->where('行号',$v['yjno'])->field('rtrim(Gd_cpmc) as productName,rtrim(成品名称) as 成品名称')->find();
                if ($v['yjno']<10){
                    $list[$k]['yjno'] = '0'.$v['yjno'];
                }
                if (!empty($v['拉料'])){
                    $list[$k]['拉料姓名'] = \db('人事_基本资料')->where('员工编号',$v['拉料'])->value('rtrim(员工姓名) as 员工姓名');
                }
                if (isset($list[$k]['拉料姓名']) === false){
                    $list[$k]['拉料姓名'] = '';
                }
                $list[$k]['印件及工序'] = $list[$k]['yjno'].'-'.$v['gxmc'];
                $list[$k]['生产时间段'] = substr($v['sj1'],5,5).' '.substr($v['sj1'],11,5).'<-->'.substr($v['sj2'],5,5).' '.substr($v['sj2'],11,5);
                $list[$k]['产品名称'] = $name['productName'];
                if (empty($name['productName'])){
                    $list[$k]['产品名称'] = $name['成品名称'];
                }
            }
            $field1 = 'SUM(sczl_cl) as 产量,SUM(sczl_zcfp) as 制程废品,SUM(sczl_zccp) as 制程次品,SUM(sczl_前工序废) as 前工序废,
        SUM(sczl_来料少数) as 来料异常,SUM(sczl_装版工时) as 装版工时,SUM(sczl_保养工时) as 保养工时,SUM(sczl_打样工时) as 打样工时,
        SUM(sczl_异常停机工时) as 异常停机工时,SUM(sczl_设备运行工时) as 通电工时,SUM(码开始行) as 码开始行,SUM(码结束行) as 码结束行,
        SUM(码包) as 码包,SUM(主电表) as 主电表,SUM(辅电表) as 辅电表';
            $total = \db('设备_产量计酬')->where($where)->field($field1)->order('UniqId desc')->select();
            $total[0]['版数'] = count($list);
            $list['total'] = $total[0];
        }


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

    /**
     * 检验记录
     * @ApiMethod （GET）
     * @param string $machine  机台编号
     * @param string $workOrder  工单编号
     * @param string $team   班次
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function InspectionRecord()
    {
        if ($this->request->isGet() === false){
            $this->error('请求失败');
        }
        $machine = input('machine');
        $workOrder = input('Gd_gdbh');
        $team = input('team');
        if (empty($machine) || empty($workOrder) || empty($team)){
            $this->success('');
        }
        $where = [
            '设备编号' => $machine,
            '工单编号' => $workOrder,
            '班组编号' => $team,
            '类别' => ['in',['IPQC检验','机台检验']],
        ];
        //检验项目筛选
        $item = \db('制程检验_记录')->where($where)->distinct(true)->column('rtrim(检验项目)');
        //检验时间
        $InspectionTime = \db('制程检验_记录')->where($where)->distinct(true)->column('提交时间');
        foreach ($InspectionTime as $k=>$v){
            $InspectionTime[$k] = date('H:i',strtotime($v));
        }
        //检测记录详情
        $field = 'rtrim(工单编号) as 工单编号,rtrim(印件号) as 印件号,rtrim(工序名称) as 工序名称';
        $nameDetail = \db('制程检验_记录')->where($where)->field($field)->find();
        $data = [];
        //检测数据
        foreach ($item as $key=>$value){
            $SubmissionTime = \db('制程检验_记录')->where($where)
                ->where('检验项目',$value)
                ->where('检验结果','合格')
                ->field('rtrim(提交时间) as 提交时间')
                ->select();
            $time = [];
            foreach ($SubmissionTime as $k=>$v){
                $time[$k] = date('H:i',strtotime($v['提交时间']));
            }
            $data[$key] = [
                '工单编号' => $nameDetail['工单编号'],
                '印件号' => $nameDetail['印件号'],
                '工序名称' => $nameDetail['工序名称'],
                '检验项目' => $value,
                'inspectresult' => implode(',',$time),
            ];
        }
        $data['inspectiontime'] = $InspectionTime;
        $this->success('成功',$data);
    }


    /**
     * 班组维护->班组添加
     * @ApiMethod （GET）
     * @param void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function MachineTeamAdd()
    {
        if (Request::instance()->isPost() === false ){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $lastId = \db('设备_班组资料')
            ->order('UniqId desc')
            ->value('UniqId');
        if (empty($lastId)){
            $lastId = 0;
        }
        for($i=1;$i<11;$i++){
            if (!empty($param['sczl_bh'.$i])){
                $name = \db('人事_基本资料')->where('员工编号',$param['sczl_bh'.$i])->value('员工编号');
                if (empty($name)){
                    $this->error('未找到编号'.$param['sczl_bh'.$i].'员工信息，无法添加，请输入正确的员工编号');
                }
            }
        }
        $param['sys_rq'] = date('Y-m-d H:i:s',time());
        $param['UniqId'] = $lastId + 1;
        $param['mod_rq'] = date('Y-m-d H:i:s',time());
        $sql = \db('设备_班组资料')->fetchSql(true)->insert($param);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }


    /**
     * 机台编号列表
     * @ApiMethod  (GET)
     * @return void
     */
    public function MachineList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $list = \db('设备_基本资料')->field('rtrim(设备编号) as 设备编号,rtrim(设备名称) as 设备名称')->select();
        if (empty($list)){
            $this->success('未找到机台编号');
        }
        $data = [];
        foreach ($list as $key=>$value){
            $data[$key] = $value['设备编号'] . '||' . $value['设备名称'];
        }
        $this->success('成功',$data);
    }

    /**
     * 删除班组信息
     * @ApiMethod (GET)
     * @param  void
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function teamDel()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $machine = \db('设备_班组资料')
            ->where('UniqId',$param['UniqId'])
            ->value('sczl_jtbh');
        $teamId = \db('设备_产量采集')
            ->where('设备编号',$machine)
            ->order('UniqId desc')
            ->value('班组ID');
        if ($teamId === (int)$param['UniqId']){
            $this->success('无法删除正在生产的班组资料，请先切换班组');
        }
         $res = \db('设备_班组资料')
            ->where('UniqId',$param['UniqId'])
            ->delete();
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }

    }

    /**
     * 管理人员现场巡检记录->展示
     * @ApiMethod (GET)
     * @param  void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function FieldInspectionRecord()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $date = date('Y-m-d H:i:s',time());
        if (empty($param['start'])){
            $startTime = date('Y-m-d 08:30:00',time());
        }else{
            $startTime = $param['start'];
        }

        if ($date<$startTime){
            $startTime = date('Y-m-d H:i:s',strtotime($startTime)-86400);
        }
        $where = [
            '工单编号' => $param['workOrder'],
            '开工时间' => $startTime,
            '类别' => '现场巡查记录',
            '班组编号' => $param['team']
        ];
        $filed = 'rtrim(工单编号) as 工单编号,rtrim(印件号) as 印件号,rtrim(工序名称) as 工序名称,rtrim(流程单号) as 流程单号,
        rtrim(设备编号) as 设备编号,rtrim(班组编号) as 班组编号,rtrim(检验项目) as 现场管理人员,rtrim(检验备注) as 检验备注,
        rtrim(提交时间) as 提交时间,rtrim(开工时间) as 开工时间';
        $list = \db('制程检验_记录')->where($where)
            ->field($filed)
            ->select();
        if (empty($list)){
            $this->success('',[]);
        }
        foreach ($list as $key=>$value){
            $number = floor((strtotime($value['提交时间'])-strtotime($value['开工时间']))/(15*60));
            $list[$key]['归属时段'] = $value['开工时间'];
            $list[$key]['分钟差数'] = $number;
            if ($number != 0){
                $list[$key]['归属时段'] = date('Y-m-d H:i:s',strtotime($value['开工时间'])+$number*15*60);
            }
        }
        $this->success('成功',$list);
    }

    /**
     * 管理人员现场巡检记录->添加
     * @ApiMethod (POST)
     * @param  void
     * @return void
     */

    public function FieldInspectionRecordAdd()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        if ($param['processCode']<10){
            $param['processCode'] = '0'.$param['processCode'];
        }
        $date = date('Y-m-d H:i:s',time());
        $startTime = date('Y-m-d 08:30:00',time());
        if ($date<$startTime){
            $startTime = date('Y-m-d H:i:s',strtotime($startTime)-86400);
        }
        $data = [
            '类别' => $param['category'],
            '工单编号' => $param['workOrder'],
            '印件号' => $param['printCode'],
            '工序名称' => $param['processCode'].'-'.$param['process'],
            '流程单号' => $param['flowCode'],
            '设备编号' => $param['machine'],
            '班组编号' => $param['team'],
            '检验项目' => '['.$param['employeeCode'].'/'.$param['employeeName'].']',
            '相关标准' => '',
            '量测仪器' => '',
            '检验结果' => '',
            '检验备注' => $param['remark'],
            '提交时间' => date('Y-m-d H:i:s',time()),
            '开工时间' => $startTime,
            'sys_id' => '',
            'sys_rq' => date('Y-m-d H:i:s',time()),
            'mod_rq' => '0000-00-00 00:00:00',
            'UniqId' => \db('制程检验_记录')->order('UniqId desc')->field('UniqId')->find()['UniqId']+1
        ];
        $sql = \db('制程检验_记录')->fetchSql(true)->insert($data);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 设备点检->左侧菜单栏
     * @ApiMethod (GET)
     * @param  void
     * @return void
     */
    public function SpotCheckItem()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $list = \db('设备_点检项目')
            ->where('适用机型','LIKE','%;'.$param['machine'].';%')
            ->distinct(true)
            ->column('部件名称','部件编号');
        if (empty($list)){
            $this->success('');
        }
        $this->success('成功',$list);
    }

    /**
     * 设备点检->检测项目
     * @ApiMethod (GET)
     * @param  void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function  InspectionItem()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $list = \db('设备_点检项目')
            ->where('部件名称',$param['unitName'])
            ->where('适用机型','like','%'.$param['machine'].'#%')
            ->field('rtrim(检验项目) as 检验项目,rtrim(判定标准) as 判定标准,rtrim(点检方法) as 点检方法')
            ->select();
        if (empty($list)){
            $this->success('未找到检测项目');
        }
        $this->success('成功',$list);
    }


    /**
     * 设备点检->检测记录添加
     * @ApiMethod (POST)
     * @param  void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public  function InspectionItemAdd()
    {
        if (Request::instance()->isPost()  === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $lastNumber =  \db("设备_点检记录")->field('Uniqid as ID')->order('Uniqid desc')->find()['ID'];
        if (empty($lastNumber)){
            $lastId = 0;
        }else{
            $lastId = $lastNumber;
        }
        $row = [];
        foreach ($param as $key=>$value){
            $unitCode = \db('设备_点检项目')->where('部件名称',$value['unitName'])->field('rtrim(部件编号) as 部件编号')->find();
            $row[$key] = [
                '日期' => date('Y-m-d 00:00:00',time()),
                '班组编号' => $value['team'],
                '点检设备' => $value['machine'],
                '部件编号' => $unitCode['部件编号'],
                '部件名称' => $value['unitName'],
                '检验项目' => $value['itemName'],
                '判定标准' => $value['standard'],
                '点检方法' => $value['method'],
                '点检结果' => $value['status'],
                '备注说明' => $value['remark'],
                'Sys_id'  =>'',
                'Sys_rq'  => date('Y-m-d H:i:s',time()),
                'Mod_rq'  => date('Y-m-d H:i:s',time()),
                'Uniqid'  => $lastId+$key+1
            ];

        }
        $sql = \db('设备_点检记录')->fetchSql(true)->insertAll($row);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 机台印版领用->左侧菜单
     * @ApiMethod (GET)
     * @param  void
     * @return void
     */
    public function PrintGetTab()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $productCode = $param['productCode'];
        $sql = "SELECT DISTINCT(RTRIM(b.`名称`)) as `印版分类`,RTRIM(b.`编号`) as `编号` FROM `产品_印版资料` as a
                JOIN `物料_存货结构` as b ON b.`编号` = SUBSTRING(a.`存货编码`,1,4)
                WHERE a.YB_Cpdh = '{$productCode}'";
        $res = Db::query($sql);
        if (empty($res)){
            $this->success('');
        }
        $this->success('成功',$res);
    }

    /**
     * 机台印版领用记录->数据详情
     * @ApiMethod (GET)
     * @param  void
     * @return void
     */
    public function PrintDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求失败');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $productCode = $param['productCode'];
        $code = $param['code'].'%';
        $workOrder = $param['workOrder'];
        $sql = "SELECT 
                RTRIM(a.`存货编码`) as `存货编码`,
                RTRIM(c.`物料名称`) as `存货名称`,
                RTRIM(b.`印版名称`) as `印版名称`,
                RTRIM(b.`供方批号`) as `供方批号`,
                RTRIM(b.`制造日期`) as `制造日期`,
                SUM(d.`Yb_印数`) as `印数`,
                RTRIM(e.`名称`) as `印版类别`,
                SUBSTRING(a.YB_Cpdh,1,4) as `客户编号`,
                RTRIM(f.`Gd_客户名称`) as `客户名称`,
                RTRIM(a.YB_Cpdh) as `产品编号`,
                RTRIM(f.Gd_cpmc) as `产品名称`,
                RTRIM(d.UniqID) as UniqId
                FROM `产品_印版资料` as a 
                LEFT JOIN `产品_印版库` as b ON b.`存货编码` = a.`存货编码`
                JOIN `物料_存货编码` as c ON c.`物料代码` = a.`存货编码`
                LEFT JOIN `工单_印版领用记录` as d ON d.`Yb_供方批号` = b.`供方批号`
                JOIN `物料_存货结构` as e ON e.`编号` = SUBSTRING(a.`存货编码`,1,4)
                JOIN `工单_基本资料` as f ON a.YB_Cpdh = f.Gd_cpdh
                WHERE a.YB_Cpdh = '{$productCode}' 
                AND a.`存货编码` LIKE '{$code}'
                AND f.Gd_gdbh = '{$workOrder}'
                AND b.`报废日期` = '1900-01-01 00:00:00'
                GROUP BY b.`供方批号`
                ORDER BY a.`存货编码`";
        $list = Db::query($sql);
        if (empty($list)){
            $this->success('');
        }
        $this->success('成功',$list);
    }

    /**
     * 换型清场->左侧菜单栏
     * @ApiMethod  (GET)
     * @param  void
     * @return void
     */
    public function remodelGetTab()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $date = date('Y-m-d 00:00:00',time()-3456000);
        $nowTime = date('Y-m-d H:i:s',time());
        $list = \db('设备_基本资料')->where('使用状态',1)->order('设备编号')->column('设备编号');
        if (empty($list)){
            $this->error('失败');
        }
        $sql = "SELECT RTRIM(a.`设备编号`) as `设备编号`,RTRIM(b.`日期`) as `日期`,RTRIM(b.UniqId) as UniqId 
                FROM `设备_基本资料` as a 
                LEFT JOIN `制程_换型清场` as b ON b.`机台编号` = a.`设备编号`
                WHERE b.`日期` > '{$date}' AND b.日期 < '{$nowTime}' AND b.`工单编号A` <> '' AND b.`工单编号B` <> '' ORDER BY b.`UniqId`";
        $res = Db::query($sql);
        $data = $result = [];
        foreach ($list as $key=>$value){
            $data[$value] = $result[$value]= $time = [];
            foreach ($res as $k=>$v){
                if ($value === $v['设备编号']){
                    $row = [
                        '日期' => $v['日期'],
                        'id' => $v['UniqId']
                    ];
                    array_push($data[$value],$row);

                }
            }
            foreach ($data[$value] as $m=>$n){
                $time[$m] = $n['日期'];
            }
            $time = array_values(array_unique($time));
            foreach ($time as $kk=>$vv){
                $i=1;
                foreach ($data[$value] as $kkk=>$vvv){
                    if ($kkk>=$kk  && $vv === $vvv['日期']){
                        array_push($result[$value],date('Y-m-d',strtotime($vv)).'第'.$i.'次换型/'.$vvv['id']);
                        $i++;
                    }
                }
            }
        }
        $this->success('成功',$result);
    }

    /**
     * 换型清场->详情
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function RemodelDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $field = 'rtrim(日期) as 日期,rtrim(班组) as 班组,rtrim(机台编号) as 机台编号,rtrim(工单编号A) as 工单编号A,rtrim(印件工序A) as 印件工序A,
        rtrim(码包号A) as 码包号A,rtrim(工单编号B) as 工单编号B,rtrim(印件工序B) as 印件工序B,rtrim(码包号B) as 码包B,
        rtrim(清场项目A) as 项目1,rtrim(清场项目B) as 项目2,rtrim(清场项目C) as 项目3,rtrim(清场项目D) as 项目4,rtrim(清场项目E) as 项目5,
        rtrim(机长) as 机长,rtrim(班长) as 班长,rtrim(质量巡查员) as 质量巡查员';
        $list = \db('制程_换型清场')->where('UniqId',$param['UniqId'])->field($field)->find();
        if (empty($list)){
            $this->success('未找到该条清场记录');
        }
        $list['日期'] = date('Y-m-d',strtotime($list['日期']));
        $printNameA = \db('工单_印件资料')->where('Yj_Gdbh',$list['工单编号A'])->field('rtrim(yj_yjmc) as yjmc')->find();
        if (empty($printNameA)){
            $list['印件名称A'] = '';
        }else{
            $list['印件名称A'] = $printNameA['yjmc'];
        }
        $printNameB = \db('工单_印件资料')->where('Yj_Gdbh',$list['工单编号B'])->field('rtrim(yj_yjmc) as yjmc')->find();
        if (empty($printNameB)){
            $list['印件名称B'] = '';
        }else{
            $list['印件名称B'] = $printNameB['yjmc'];
        }
        $this->success('成功',$list);
    }

    /**
     * 换型清场->当前设备清场记录
     * @ApiMethod (GET)
     * @param  void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ModelChangeRecord()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $date = date('Y-m-d 00:00:00',time()-3888000);
        $nowTime = date('Y-m-d H:i:s',time());
        $where = [
            '日期' =>['between',[$date,$nowTime]],
            '机台编号' => $param['machine'],
            '工单编号A' => ['<>',''],
            '工单编号B' => ['<>',''],
        ];
        $field = "rtrim(日期) as 日期,rtrim(机台编号) as 机台编号,rtrim(班组) as 班组,rtrim(工单编号A) as 工单编号A,rtrim(印件工序A) as 印件工序A,
        rtrim(码包号A) as 码包号A,rtrim(工单编号B) as 工单编号B,rtrim(印件工序B) as 印件工序B,rtrim(码包号B) as 码包号B,rtrim(清场项目A) as 清场项目A,
        rtrim(清场项目B) as 清场项目B,rtrim(清场项目C) as 清场项目C,rtrim(清场项目D) as 清场项目D,rtrim(清场项目E) as 清场项目E,rtrim(机长) as 机长,
        rtrim(班长) as 班长,rtrim(质量巡查员) as 质量巡查员,rtrim(sys_rq) as 创建时间,rtrim(UniqId) as UNIQID";
        $list = \db('制程_换型清场')
            ->where($where)
            ->field($field)
            ->select();
        if (empty($list)){
            $this->success('未找到换型记录');
        }
        foreach ($list as $key=>$value){
            $printNameA = \db('工单_印件资料')->where('Yj_Gdbh',$value['工单编号A'])->value('rtrim(yj_yjmc) as yjmc');
            if (empty($printNameA)){
                $list[$key]['印件名称A'] = '';
            }else{
                $list[$key]['印件名称A'] = $printNameA;
            }
            $printNameB = \db('工单_印件资料')->where('Yj_Gdbh',$value['工单编号B'])->value('rtrim(yj_yjmc) as yjmc');
            if (empty($printNameB)){
                $list[$key]['印件名称B'] = '';
            }else{
                $list[$key]['印件名称B'] = $printNameB;
            }
        }
        $this->success('成功',$list);
    }

    /**
     * 车间机台状态列表展示
     * @ApiMethod (GET)
     * @param  void
     * @return void
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function MachineDetailList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $workshop = $param['workshop'];
        $sql = "SELECT
                    RTRIM( a.`设备编号` ) AS 设备编号,
                    RTRIM( a.`设备名称` ) AS 设备名称,
                    RTRIM( d.`当前状态` ) AS 状态
                FROM
                    `设备_基本资料` AS a
                    JOIN (
                    SELECT
                        b.`设备编号`,
                        b.`当前状态`,
                        b.`开工时间` 
                    FROM
                        `设备_产量采集` AS b
                        JOIN ( SELECT `设备编号`, MAX( `UniqId` ) AS `UniqId` FROM `设备_产量采集` GROUP BY `设备编号` ) AS c ON b.`设备编号` = c.`设备编号` 
                        AND b.`UniqId` = c.`UniqId`  
                    ) AS d ON a.`设备编号` = d.`设备编号`
                WHERE
                    a.`使用部门` = '{$workshop}' 
                GROUP BY
                    a.`设备编号`
                ORDER BY 
                    a.UniqId";
        $list = \db()->query($sql);
        foreach ($list as $key=>$value){
            if ($value['状态'] == ''){
                $list[$key]['状态'] = '待单';
            }
        }
        $this->success('成功',$list);
    }

    /**
     * 机台当前参数展示
     * @ApiMethod (GET)
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function MachineDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $data = [];
        if ($param['start'] === ''){
            if (date('Y-m-d H:i:s')>date('Y-m-d 08:30:00',time()) && date('Y-m-d H:i:s')<date('Y-m-d 20:30:00',time())){
                $param['start'] = date('Y-m-d 08:30:00',time());
            }elseif (date('Y-m-d H:i:s')>date('Y-m-d 20:30:00',time()) && date('Y-m-d H:i:s')<date('Y-m-d 23:59:59',time())){
                $param['start'] = date('Y-m-d 20:30:00',time());
            }else{
                $param['start'] = date('Y-m-d 20:30:00',time()-86400);
            }
        }
        $machineDetail = \db('设备_产量采集')
            ->alias('a')
            ->join('设备_基本资料 b','a.设备编号 = b.设备编号')
            ->join('工单_工艺资料 c','a.工单编号 = c.Gy0_gdbh AND a.设备编号 = c.Gy0_sbbh')
            ->join('工单_基本资料 d','a.工单编号 = d.Gd_gdbh')
            ->field([
                'rtrim(a.开工时间)' => '开工时间',
                'rtrim(a.设备编号)' => '设备编号',
                'rtrim(a.工单编号)' => '工单编号',
                'rtrim(b.设备名称)' => '设备名称',
                'rtrim(c.Gy0_gxh)' => '工序号',
                'rtrim(c.Gy0_gxmc)' => '工序名称',
                'rtrim(d.Gd_cpmc)' => '产品名称'
            ])
            ->where('a.设备编号', $param['machine'])
            ->order('a.UniqId desc')
            ->find();
        $data['machine'] = [
            '日期' => $machineDetail['开工时间'],
            '设备' => $machineDetail['设备编号'].'-->'.$machineDetail['设备名称'],
            '工单' => $machineDetail['工单编号'].'-->'.$machineDetail['产品名称'],
            '工艺' => ($machineDetail['工序号']<10?'0'.$machineDetail['工序号']:$machineDetail['工序号']).'--'.$machineDetail['工序名称']
        ];
        //机台状态时间
        $startTime = \db('设备_产量采集')
            ->where('设备编号',$param['machine'])
            ->where('开工时间',$param['start'])
            ->field('rtrim(时间) as 时间,当班产量,rtrim(当前状态) as 状态,MAX(时间) as 最大时间,MAX(当班产量) as 最大产量')
            ->group('当前状态')
            ->select();
        if (!empty($startTime)){
            foreach ($startTime as $key=>$value){
                $data['timeDifference'][$key] = [
                    '时间' => round((strtotime($value['最大时间'])-strtotime($value['时间']))/3600,2),
                    '状态' => $value['状态'] = null?'待单':$value['状态'],
                ];
                if ($value['状态'] === '生产'){
                    $data['当班产量'] = $value['最大产量']-$value['当班产量'];
                }
            }
        }else{
            $data['timeDifference'][0] = [
                '时间' => 0,
                '状态' => '待单'
            ];
            $data['当班产量'] = 0;
        }
        //机台产能/时间明细
        $row = \db('设备_产量采集')
            ->where('设备编号',$param['machine'])
            ->where('开工时间',$param['start'])
            ->where('当班产量','<>',-1)
            ->field('rtrim(时间) as 时间,rtrim(当班产量) as 产量,rtrim(当前状态) as 状态')
            ->select();
        if (empty($row)){
            $data['row'] = [];
        }
        foreach ($row  as $key=>$value){
            $data['row'][$key]['时间'] = date('Y-m-d H:i',strtotime($value['时间']));
            $data['row'][$key]['状态'] = $value['状态'];
            if ($key<2){
                $data['row'][$key]['产能'] = 0;
            }else{
                $data['row'][$key]['产能'] = ($row[$key-1]['产量']-$row[$key-2]['产量'])*60;
            }
        }
        //机台状态
        $status = end($row);
        if (empty($status['状态'])){
            $data['status'] = '待单';
        }else{
            $data['status'] = $status['状态'];
        }
        //检验数据
        $list = \db('制程检验_记录')
            ->where('开工时间',$param['start'])
            ->where('设备编号',$param['machine'])
            ->where('sys_rq','>',$param['start'])
            ->where('工单编号',$machineDetail['工单编号'])
            ->field('rtrim(类别) as 类别,提交时间')
            ->select();
        $data['首件'] = $data['自检'] = $data['IPQC'] = [];
        if (!empty($list)){
            foreach ($list as $key=>$value){
                if ($value['类别'] == '首件与过程确认'){
                    array_push($data['首件'],$value['提交时间']);
                }
                if ($value['类别'] == '机台检验'){
                    array_push($data['自检'],$value['提交时间']);
                }
                if ($value['类别'] == 'IPQC检验'){
                    array_push($data['IPQC'],$value['提交时间']);
                }
            }
            $data['首件'] = array_values(array_unique($data['首件']));
            $data['自检'] = array_values(array_unique($data['自检']));
            $data['IPQC'] = array_values(array_unique($data['IPQC']));
        }else{
            $data['首件'] = [];
            $data['自检'] = [];
            $data['IPQC'] = [];
        }
        $this->success('成功',$data);
    }

    /**
     * 制程检验记录->检验项目
     * @ApiMethod (GET)
     * @param void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ProcessInspectionRecordsItem()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $list = \db('制程检验_项目')
            ->where('工序','like','%'.$param['process'].'%')
            ->select();
        if (empty($list)){
            $this->success('未找到检测项目');
        }
        $data = [];
        foreach ($list as $key=>$value){
            $data['首件']['指标检验'][$key] = [
                '检验项目' => rtrim($value['检测项目']),
                '检测方法' => rtrim($value['检测方法']),
                '检验频率' => rtrim($value['首件签样要求']),
                '相关标准' => rtrim($value['技术要求'])
            ];
            $data['机台检验']['指标检验'][$key] = [
                '检验项目' => rtrim($value['检测项目']),
                '检测方法' => rtrim($value['检测方法']),
                '检验频率' => rtrim($value['机台自检频率']),
                '相关标准' => rtrim($value['技术要求'])
            ];
            $data['IPQC']['指标检验'][$key] = [
                '检验项目' => rtrim($value['检测项目']),
                '检测方法' => rtrim($value['检测方法']),
                '检验频率' => rtrim($value['IPQC检验频率']),
                '相关标准' => rtrim($value['技术要求'])
            ];
        }
        $row = \db('制程检验_项目附加')
            ->where('工序','like','%'.$param['process'].'%')
            ->select();
        foreach ($row as $key=>$value){
            $data['首件']['附加'][$key] = [
                '缺陷备注' => rtrim($value['缺陷备注']),
                '编号' => rtrim($value['编号'])
            ];
            $data['机台检验']['附加'][$key] = [
                '缺陷备注' => rtrim($value['缺陷备注']),
                '编号' => rtrim($value['编号'])
            ];
            $data['IPQC']['附加'][$key] = [
                '缺陷备注' => rtrim($value['缺陷备注']),
                '编号' => rtrim($value['编号'])
            ];
        }
        $this->success('成功',$data);
    }

    /**
     * 制程检验记录->检测记录添加
     * @ApiMethod （POST）
     * @param void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ProcessInspectionRecordsItemAdd()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $startID = \db('制程检验_记录')->order('UniqId desc')->value('UniqId');
        if (empty($startID)){
            $startID = 0;
        }
        $process = \db('工单_工艺资料')
            ->where('Gy0_gdbh',$param[0]['workOrder'])
            ->where('Gy0_sbbh','like','%'.$param[0]['machine'].'#'.'%')
            ->field('rtrim(Gy0_gxh) as gxh,rtrim(Gy0_gxmc) as gxmc,rtrim(Add_gxmc) as add_gxmc')
            ->find();
        $startTime = \db('设备_产量采集')
            ->where('设备编号','like','%'.$param[0]['machine'].'#%')
            ->where('工单编号',$param[0]['workOrder'])
            ->order('UniqId desc')
            ->find();
        if ((int)$process['gxh']<10){
            $process['gxh'] = '0'.$process['gxh'];
        }
        if ($process['add_gxmc'] !== ''){
            $printName = $process['gxh'].'-'.$process['gxmc'].'【'.$process['add_gxmc'].'】';
        }else{
            $printName = $process['gxh'].'-'.$process['gxmc'];
        }
        if (empty($process)){
            $this->success('数据错误');
        }
        $data = [];
        foreach ($param as $key=>$value){
            $data[$key] = [
                '类别' => $value['category'],
                '工单编号' => $value['workOrder'],
                '印件号' => $value['yjno'],
                '工序名称' => $printName,
                '流程单号' => $value['flow'],
                '设备编号' => $value['machine'].'#',
                '班组编号' => $startTime['班组编号'],
                '检验项目' => $value['item'],
                '相关标准' => $value['standard'],
                '量测仪器' => $value['instrument'],
                '检验结果' => $value['result'],
                '检验备注' => $value['remark'],
                '提交时间' => date('Y-m-d H:i:s',time()),
                '开工时间' => rtrim($startTime['开工时间']),
                'sys_id' => '',
                'sys_rq' => date('Y-m-d H:i:s',time()),
                'mod_rq' => '0000-00-00 00:00:00',
                'UniqId' => $startID + $key +1
            ];
        }
        $res = \db('制程检验_记录')->insertAll($data);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 制程检验记录->附加检验记录添加
     * @ApiMethod （POST）
     * @param  void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function AdditionalInspectionRecordAdd()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $startID = \db('制程检验_记录附加')->order('UniqId desc')->value('UniqId');
        if (empty($startID)){
            $startID = 0;
        }
        $process = \db('工单_工艺资料')
            ->where('Gy0_gdbh',$param[0]['workOrder'])
            ->where('Gy0_sbbh','like','%'.$param[0]['machine'].'#'.'%')
            ->field('rtrim(Gy0_gxh) as gxh,rtrim(Gy0_gxmc) as gxmc,rtrim(Add_gxmc) as add_gxmc')
            ->find();
        $startTime = \db('设备_产量采集')
            ->where('设备编号','like','%'.$param[0]['machine'].'#%')
            ->where('工单编号',$param[0]['workOrder'])
            ->order('UniqId desc')
            ->find();
        if ((int)$process['gxh']<10){
            $process['gxh'] = '0'.$process['gxh'];
        }
        if ($process['add_gxmc'] !== ''){
            $printName = $process['gxh'].'-'.$process['gxmc'].'【'.$process['add_gxmc'].'】';
        }else{
            $printName = $process['gxh'].'-'.$process['gxmc'];
        }
        if (empty($process)){
            $this->success('数据错误');
        }
        $data = [];
        foreach ($param as $key=>$value){
            $data[$key] = [
                '工单编号' => $value['workOrder'],
                '印件号' => $value['yjno'],
                '工序名称' => $printName,
                '流程单号' => $value['flow'],
                '设备编号' => $value['machine'],
                '班组编号' => $startTime['班组编号'],
                '缺陷备注' => $value['remark'],
                '提交时间' => date('Y-m-d H:i:s',time()),
                '开工时间' => rtrim($startTime['开工时间']),
                'sys_id' => '',
                'sys_rq' => date('Y-m-d H:i:s',time()),
                'mod_rq' => '0000-00-00 00:00:00',
                'UniqId' => $startID + $key +1
            ];
        }
        $res = \db('制程检验_记录附加')->insertAll($data);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 客诉记录
     * @ApiMethod (GET)
     * @param  void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
     public function ComplaintRecord()
     {
         if ($this->request->isGet() === false){
             $this->error('请求错误');
         }
         $param = $this->request->param();
         if (isset($param['productCode'])){
             $where['产品编号'] = $param['productCode'];
         }
         $filed = "rtrim(产品编号) as 产品编号,rtrim(产品名称) as 产品名称,rtrim(客诉日期) as 客诉日期,rtrim(客诉单号) as 客诉单号,
         rtrim(客诉方式) as 客诉方式,rtrim(订单编号) as 订单编号,rtrim(客户编号) as 客户编号,rtrim(客户名称) as 客户名称,
         rtrim(客诉描述) as 客诉描述,rtrim(缺陷关键字) as 缺陷关键字,rtrim(客诉性质) as 客诉性质,rtrim(扣分) as 扣分,
         rtrim(主要责任部门) as 主要责任部门,rtrim(次要责任部门) as 次要责任部门";
         $list = \db('db_客诉记录')
             ->where($where)
             ->field($filed)
             ->select();
         if (empty($list)){
             $this->success('未找到该产品客诉记录');
         }
         $this->success('成功',$list);
     }

    /**
     * 设置机台班组信息
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */

    public function setMachineTeam()
    {
        if (Request::instance()->isPost() == false) {
            $this->error('非法请求');
        }
        $params = Request::instance()->post();
        if (!isset($params['machine']) || empty($params['machine'] )) {
            $this->error('参数不能为空');
        }
        if (!isset($params['order']) || empty($params['order'])){
            $this->error('工单编号不能为空');
        }
        if (empty($params['team_id']) || empty($params['sczl_bzdh'])){
            $this->error('请先选择班组成员');
        }
        $machine = $params['machine'] . '#';
        $data = [];
        $lastData = \db('设备_产量采集')
            ->order('UniqId desc')
            ->find();
        $id = $lastData['UniqId']+1;
        $data['当前状态'] = $params['status'];
        $data['时间'] = date('Y-m-d H:i:s');
        $data['设备编号'] = $machine;
        $data['工单编号'] = empty($params['order']) ? '':$params['order'];
        $data['印件号'] = empty($params['yjno']) ? '':$params['yjno'];
        $data['工序号'] = empty($params['gy_name']) ? '' : (int)substr($params['gy_name'], 0, 2);
        $data['工序名称'] = empty($params['gy_name']) ? '' : $params['gy_name'];
        $data['当班产量'] = $params['production_now'];
        $data['累计产量'] = $params['production_all'];
        $data['班组编号'] = $params['sczl_bzdh'];
        $data['班组ID'] = $params['team_id'];
        // 获取当前时间
        $current_time = time();
        // 设置时间范围
        $start_time1 = strtotime(date('Y-m-d') . ' 08:30:00');
        $end_time1 = strtotime(date('Y-m-d') . ' 20:30:00');
        $end_time2 = strtotime(date('Y-m-d') . ' 24:00:00');
        $start_time3 = strtotime(date('Y-m-d', strtotime('+1 day')) . ' 08:30:00');
        // 判断当前时间属于哪个时间范围
        if ($current_time >= $start_time1 && $current_time <= $end_time1) {
            $data['开工时间'] = date('Y-m-d') . ' 08:30:00';
        } elseif ($current_time > $end_time1 && $current_time <= $end_time2) {
            $data['开工时间'] = date('Y-m-d') . ' 20:30:00';

        } elseif ($current_time > $end_time1 && $current_time <= $start_time3) {
            $data['开工时间'] = date('Y-m-d', strtotime('+1 day')) . ' 08:30:00';
        }
        if (!empty($params['order']) && !empty($params['yjno'])){
            $option['Gy0_gdbh'] = $params['order'];
            $option['Gy0_yjno'] = $params['yjno'];
            $option['Gy0_gxh'] = $data['工序号'];
            $data['任务ID'] = \db('工单_工艺资料')->where($option)->value('UniqId');
        }else{
            $data['任务ID'] = '';
        }
        $data['UniqId'] = $id;
        $sql = \db('设备_产量采集')->fetchSql(true)->insert($data);
        $res = Db::query($sql);
        if ($res === false) {
            $this->error('设置失败');
        } else {
            $this->success('设置成功');
        }
    }

    /**
     * 首页数据
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function index()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $nowTime = date('Y-m-d H:i:s',time());
        $oldTime = (date('Y')-1).'-'.date('m-d H:i:s');
        $where =[
            'Mod_rq' => ['between',[$oldTime,$nowTime]],
            '行号' => '1'
        ];
        $data = [];
        //按状态查询工单信息
        $orderList = \db('工单_基本资料')
            ->where($where)
            ->field('count(Gd_gdbh) as 数量,rtrim(gd_statu) as 状态')
            ->group('gd_statu')
            ->select();
        foreach ($orderList as $value){
            if ($value['状态'] === '1-已完工'){
                $data['workOrderData']['已完工'] = $value['数量'];
            }
            if ($value['状态'] === '3-计划中'){
                $data['workOrderData']['计划中'] = $value['数量'];
            }
        }
        $data['workOrderData']['排程中'] = db('工单_基本资料')->alias('a')
            ->join('工单_工艺资料 b', 'a.Gd_gdbh = b.Gy0_gdbh')
            ->join('产品_基本资料 c', 'a.Gd_cpdh = c.产品编号')
            ->where([
                'a.gd_statu' => '2-生产中',
                'a.行号' => '1',
                'a.Mod_rq' => ['between',[$oldTime,$nowTime]],
                'b.PD_WG' => '1900-01-01 00:00:00',
                'b.Gy0_sj1' => '1900-01-01 00:00:00',
                'c.状态' => '',
            ])
            ->group('a.Gd_gdbh')
            ->count();
        $data['workOrderData']['制程中'] = db('工单_基本资料')->alias('a')
            ->join('工单_工艺资料 b', 'a.Gd_gdbh = b.Gy0_gdbh')
            ->join('产品_基本资料 c', 'a.Gd_cpdh = c.产品编号')
            ->where([
                'a.gd_statu' => '2-生产中',
                'a.行号' => '1',
                'a.Mod_rq' => ['between',[$oldTime,$nowTime]],
                'b.PD_WG' => '1900-01-01 00:00:00',
                'b.Gy0_sj1' => ['<>', '1900-01-01 00:00:00'],
                'c.状态' => '',
            ])
            ->group('a.Gd_gdbh')
            ->count();
        //按月份查询工单信息
        $data['monthData'] = \db('工单_基本资料')
            ->where('Mod_rq', 'between', [$oldTime, $nowTime])
            ->field('DATE_FORMAT(Mod_rq, "%Y-%m") as month, COUNT(*) as count')
            ->group('month')
            ->order('month')
            ->select();
        //查询最近十条客诉信息
        $data['customer'] = \db('db_客诉记录')
            ->field('rtrim(客诉描述) as 客诉描述,DATE_FORMAT(客诉日期, "%Y-%m-%d") as 日期,rtrim(UniqID) as UniqId')
            ->limit(10)
            ->order('Sys_rq desc')
            ->select();
        $this->success('成功',$data);
    }

    /**
     * 员工信息获取
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function EmployeeData()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (isset($param['code']) === false){
            $this->error('参数错误');
        }
        $res = \db('人事_基本资料')
            ->where('员工编号','like',$param['code'].'%')
            ->field('rtrim(员工编号) as 员工编号,rtrim(员工姓名) as 员工姓名')
            ->select();
        if (empty($res)){
            $this->success('未找到该员工');
        }
        $this->success('成功',$res);
    }

    /**
     * 换型清场添加
     * @return void
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function remodelDataAdd()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $lastId = \db('制程_换型清场')->order('UniqId desc')->value('UniqId');
        $param['sys_id'] = '['.$param['机台编号'].']';
        $param['sys_rq'] = date('Y-m-d H:i:s',time());
        $param['mod_rq'] = date('Y-m-d H:i:s',time());
        $param['UniqId'] = $lastId + 1;
        $sql = \db('制程_换型清场')->fetchSql(true)->insert($param);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 换型清场记录修改
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function remodelDataEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $param['mod_rq'] = date('Y-m-d H:i:s',time());
        $sql = \db('制程_换型清场')->fetchSql(true)->update($param);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 换型清场记录删除
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function remodelDataDel()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $res = \db('制程_换型清场')->where('UniqId',$param['UniqId'])->delete();
        if ($res !== false){
            $this->success('删除成功');
        }else{
            $this->error('删除失败');
        }
    }

    /**
     * 印版领用记录添加
     * @return void
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function PrintDetailAdd()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $lastId = \db('工单_印版领用记录')->order('UniqID desc')->value('UniqID');
        foreach ($param as $key=>$value){
            $param[$key]['Yb_领用日期'] = date('Y-m-d H:i:s',time());
            $param[$key]['Sys_rq'] = date('Y-m-d H:i:s',time());
            $param[$key]['Mod_rq'] = date('Y-m-d H:i:s',time());
            $param[$key]['UniqID'] = $lastId + $key +1;
        }
        $sql = \db('工单_印版领用记录')->fetchSql(true)->insertAll($param);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('添加成功');
        }else{
            $this->error('添加失败');
        }
    }

    /**
     * 印版领用记录退还
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function PrintDetailEdit()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $idList = explode(',',$param['id']);
        $i = 0;
        foreach ($idList as $key=>$value){
            $data['Yb_退还日期'] = date('Y-m-d H:i:s',time());
            $data['Mod_rq'] = date('Y-m-d H:i:s',time());
            $sql = \db('工单_印版领用记录')->where('UniqID',$value)->fetchSql(true)->update($data);
            $res = \db()->query($sql);
            if ($res === false){
                $i++;
            }
        }
        if ($i !== 0){
            $this->error('退还失败');
        }else{
            $this->success('退还成功');
        }
    }

    /**
     * 当班产量明细修改
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function chanliangEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param['UniqId'])){
            $this->error('参数错误');
        }
        $param['sczl_打样工时'] = $param['sczl_打样总工时'];
        $param['sczl_装版工时'] = $param['sczl_装版总工时'];
        $param['mod_rq'] = date('Y-m-d H:i:s',time());
        $data = $param;
        unset($data['UniqId']);
        $sql = \db('设备_产量计酬')
            ->where('UniqId',$param['UniqId'])
            ->fetchSql(true)
            ->update($data);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('修改成功');
        }else {
            $this->error('修改失败');
        }
    }

    /**
     * 获取当日上报产量详细数据
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function MachineChanliangDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param['UniqId'])){
            $this->error('参数错误');
        }
        $field = 'rtrim(sczl_gdbh) as 工单编号,rtrim(sczl_dedh) as dedh,rtrim(sczl_yjno) as yjno,rtrim(sczl_gxh) as gxh,rtrim(sczl_gxmc) as gxmc,rtrim(sczl_num) as num,rtrim(sczl_sj1) as sj1,rtrim(sczl_ls) as 联数,
        rtrim(sczl_sj2) as sj2,rtrim(sczl_cl) as 产量,rtrim(sczl_bzdh) as bzdh,rtrim(sczl_zcfp) as 制程废品,rtrim(sczl_zccp) as 制程次品,rtrim(sczl_前工序废) as 前工序废,rtrim(sczl_来料少数) as 来料异常,
        rtrim(sczl_装版工时) as 装版工时,rtrim(sczl_保养工时) as 保养工时,rtrim(sczl_打样工时) as 打样工时,rtrim(sczl_异常停机工时) as 异常总工时,rtrim(sczl_设备运行工时) as 通电工时,
        rtrim(码开始行) as 码开始行,rtrim(码结束行) as 码结束行,rtrim(码包) as 码包,rtrim(主电表) as 主电表,rtrim(辅电表) as 辅电表,rtrim(sczl_ms) as 色度数,
        rtrim(sczl_异常工时1) as 异常补时,rtrim(sczl_异常类型1) as 异常类型,sczl_bh1,sczl_bh2,rtrim(sczl_装版工时) as 装版补产工时,rtrim(sczl_打样工时) as 打样补产工时,
        sczl_bh3,sczl_bh4,sczl_bh5,sczl_bh6,sczl_bh7,sczl_bh8,sczl_bh9,sczl_bh10,sczl_rate1,sczl_rate2,sczl_rate3,sczl_rate4,sczl_rate5,sczl_rate6,sczl_rate7,
        sczl_rate8,sczl_rate9,sczl_rate10,sczl_bh98,rtrim(UniqId) as UniqId';
        $list = \db('设备_产量计酬')->where('UniqId',$param['UniqId'])->field($field)->find();
        if (empty($list)){
            $this->success('未找到产量详情信息');
        }
        $productName = \db('工单_基本资料')->whereIn('Gd_gdbh',$list['工单编号'])->field('rtrim(成品名称) as 成品名称,rtrim(Gd_cpmc) as cpmc')->find();
        $list['印件名称'] = $productName['cpmc'];
        if (!empty($productName['成品名称'])){
            $list['cpmc'] = $productName['成品名称'];
        }elseif (empty($productName['成品名称']) && !empty($productName['cpmc'])){
            $list['cpmc'] = $productName['cpmc'];
        }else{
            $list['cpmc'] = '';
        }
        for ($i=1;$i<11;$i++){
            if (isset($list['sczl_bh'.$i])){
                $name = \db('人事_基本资料')->where('员工编号',$list['sczl_bh'.$i])->field('rtrim(员工姓名) as name')->find();
                if (isset($name['name'])){
                    $list['组员'.$i] = [
                        '编号' => $list['sczl_bh'.$i],
                        '姓名' => $name['name'],
                        '比例' => ((float)$list['sczl_rate'.$i]*100).'%'
                    ];
                }
            }
            if (empty($list['sczl_bh'.$i])){
                $list['组员'.$i] = [
                    '编号' => '',
                    '姓名' => '',
                    '比例' => ''
                ];
            }

            unset($list['sczl_bh'.$i],$list['sczl_rate'.$i]);
        }
        $list['拉料'] = [
            '编号' => $list['sczl_bh98'],
            '姓名' => \db('人事_基本资料')->where('员工编号',$list['sczl_bh98'])->value('rtrim(员工姓名)')
        ];
        unset($list['sczl_bh98']);
        $this->success('成功',$list);
    }

    /**
     * 当日上报产量详细数据修改
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function MachineChanliangDetailEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param['UniqId'])){
            $this->error('参数错误');
        }
        $param['sczl_type'] = $param['sczl_gxmc'];
        $param['mod_rq'] = date('Y-m-d H:i:s',time());
        $UnidId = $param['UniqId'];
        unset($param['UniqId']);
        $sql = \db('设备_产量计酬')->where('UniqId',$UnidId)->fetchSql(true)->update($param);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('修改成功');
        }else{
            $this->error('修改失败');
        }
    }

    /**
     * 产量上报数据删除
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function ChanliangDel()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param['UniqId'])){
            $this->error('参数错误');
        }
        $idList = explode(',',$param['UniqId']);
        foreach ($idList as $key=>$value){
            $res = \db('设备_产量计酬')
                ->where('UniqId',$value)
                ->delete();
        }
        if ($res !== false){
            $this->success('删除成功');
        }else{
            $this->error('删除失败');
        }
    }

    /**
     * 日产量上报添加
     * @return void
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function ChanliangAdd()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $params = Request::instance()->post();
        if (empty($params['sczl_gdbh'])){
            $this->error('参数错误');
        }
        $lastId = \db('设备_产量计酬')->order('UniqId desc')->value('rtrim(UniqId)');
        $params['sczl_type'] = $params['sczl_gxmc'];
        $params['sczl_wgsj'] = '1900-01-01 00:00:00';
        $params['sczl_废品率系数'] = 0;
        $params['sys_rq'] = date('Y-m-d H:i:s',time());
        $params['mod_rq'] = date('Y-m-d H:i:s',time());
        $params['UniqId'] = $lastId + 1;
        $sql = \db('设备_产量计酬')->fetchSql(true)->insert($params);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 日产量上报添加获取工单信息
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ChanliangWorkorder()
    {
        if ($this->request->isGet() === false)
        {
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
//        $where = [
//            'b.Gy0_sbbh' => ['like','%'.$param['machine'].'%'],
//        ];
//        if (!empty($param['machine'])){
//            $where = [
//                'b.Gy0_sbbh' => ['like','%'.$param['machine'].'%'],
//            ];
//        }
        if (!empty($param['search'])){
            $where['b.Gy0_gdbh'] = ['like','%'.$param['search'].'%'];
        }
        $list = \db('工单_基本资料')
            ->alias('a')
            ->field('rtrim(Gd_gdbh) as gdbh,rtrim(成品名称) as cpmc')
            ->join('工单_工艺资料 b','a.Gd_gdbh = b.Gy0_gdbh')
            ->where($where)
            ->select();
        if (empty($list)){
            $this->success('未找到相关工单');
        }else{
            $this->success('成功',$list);
        }
    }

    /**
     * 日产量上报工单印件资料
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ChanliangPrintDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param['gdbh'])){
            $this->error('参数错误');
        }
        $where = [
            'Yj_Gdbh' => $param['gdbh']
        ];
        $list = \db('工单_印件资料')
            ->where($where)
            ->field('rtrim(yj_Yjno) as yjno,rtrim(yj_yjmc) as yjmc,rtrim(yj_ls) as ls')
            ->select();
        if (empty($list)){
            $this->success('未找到印件资料');
        }else{
            $this->success('成功',$list);
        }
    }

    /**
     * 日产量上报工艺资料获取
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ChanliangProcessDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param['gdbh'])){
            $this->error('参数错误');
        }
//        $sys_bh = \db('dic_lzde')->where('适用机型',$param['machine'])->value('sys_bh');
        $list = \db('工单_工艺资料')
            ->where('Gy0_gdbh',$param['gdbh'])
            ->where('Gy0_yjno',$param['yjno'])
//            ->where('Gy0_sbbh','like','%'.$param['machine'].'%')
            ->field('rtrim(Gy0_gxh) as gxh,rtrim(Gy0_gxmc) as gxmc,rtrim(Add_gxmc) as add_gxmc')
            ->select();
        if (empty($list)){
            $this->success('未获取工序');
        }
//        $time = \db('设备_产量计酬')
//            ->where('sczl_gdbh',$param['gdbh'])
//            ->where('sczl_yjno',$param['yjno'])
//            ->where('sczl_jtbh','like','%'.$param['machine'].'%')
//            ->order('UniqId desc')
//            ->value('sczl_sj2');
//        $newTime = date('Y-m-d H:i:s');
//        if ($newTime > date('Y-m-d 08:30:00') && $newTime < date('Y-m-d 20:30:00') && $time < date('Y-m-d 08:30:00')){
//            $time = date('Y-m-d 08:30:00');
//        }elseif ($newTime > date('Y-m-d 20:30:00') && $time < date('Y-m-d 20:30:00')){
//            $time = date('Y-m-d 20:30:00');
//        }
        foreach ($list as $key=>$value){
            if ((int)$value['gxh'] < 10){
                $value['gxh'] = '0'.$value['gxh'];
            }
            if (empty($value['add_gxmc'])){
                $list[$key]['name'] = $value['gxh'].'-'.$value['gxmc'];
            }else{
                $list[$key]['name'] = $value['gxh'].'-'.$value['gxmc'].'【'.$value['add_gxmc'].'】';
            }
            unset( $list[$key]['add_gxmc']);
//            $list[$key]['time'] = $time;
        }
//        $list['sys_bh'] = $sys_bh;
        $this->success('成功',$list);
    }

    /**
     * 工价系数修改
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function CoefficientEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $params = Request::instance()->post();
        if (empty($params['id'])){
            $this->error('参数错误');
        }
        $idList = explode(',',$params['id']);
        $i=0;
        foreach ($idList as $key=>$value){
            $sql = \db('设备_产量计酬')
                ->where('UniqId',$value)
                ->fetchSql(true)
                ->update(['sczl_工价系数'=>$params['工价系数']]);
            $res = \db()->query($sql);
            if ($res === false){
                $i++;
            }
        }
        if ($i!==0){
            $this->error('修改失败');
        }else{
            $this->success('修改成功');
        }
    }

    /**
     * 色度系数修改
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function ChromaDataEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $params = Request::instance()->post();
        if (empty($params['id'])){
            $this->error('参数错误');
        }
        $idList = explode(',',$params['id']);
        $i=0;
        foreach ($idList as $key=>$value){
            $sql = \db('设备_产量计酬')
                ->where('UniqId',$value)
                ->fetchSql(true)
                ->update(['sczl_ms'=>$params['ms']]);
            $res = \db()->query($sql);
            if ($res === false){
                $i++;
            }
        }
        if ($i!==0){
            $this->error('修改失败');
        }else{
            $this->success('修改成功');
        }
    }

    /**
     * 凹印版距修改
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function PrintingModeDataEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $params = Request::instance()->post();
        if (empty($params['id'])){
            $this->error('参数错误');
        }
        $idList = explode(',',$params['id']);
        //获取工单印件工序
        $orderList = \db('设备_产量计酬')
            ->where('UniqId',$idList[0])
            ->field('rtrim(sczl_gdbh) as 工单编号,rtrim(sczl_yjno) as 印件号,rtrim(sczl_gxh) as 工序号')
            ->find();
        //修改工艺资料
        $sql = \db('工单_工艺资料')
            ->where([
                'Gy0_gdbh'=>$orderList['工单编号'],
                'Gy0_yjno'=>$orderList['印件号'],
                'Gy0_gxh'=>$orderList['工序号']
            ])
            ->fetchSql(true)
            ->update(['版距'=>$params['plate'],'印刷方式'=>$params['mode']]);
        $res = \db()->query($sql);
        if ($res === false){
            $this->error('修改失败');
        }else{
            $this->success('修改成功');
        }
    }

    /**
     * 废品率系数批量修改
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function RejectionEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $params = Request::instance()->post();
        if (empty($params['id'])){
            $this->error('参数错误');
        }
        $idList = explode(',',$params['id']);
        $i=0;
        foreach ($idList as $key=>$value){
            $sql = \db('设备_产量计酬')
                ->where('UniqId',$value)
                ->fetchSql(true)
                ->update(['sczl_废品率系数'=>$params['rejection']]);
            $res = \db()->query($sql);
            if ($res === false){
                $i++;
            }
        }
        if ($i!==0){
            $this->error('修改失败');
        }else{
            $this->success('修改成功');
        }
    }

    /**
     * 日产量上报班组信息批量修改
     * @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 YieldTeamEdit()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param['Uniqid']) || empty($param['teamID'])){
            $this->error('参数错误');
        }
        $idList = explode(',',$param['Uniqid']);
        $teamList = \db('设备_班组资料')->where('UniqId',$param['teamID'])->find();
        $data = [];
        for ($i=1;$i<11;$i++){
            $data['sczl_bh'.$i] = $teamList['sczl_bh'.$i];
            $data['sczl_rate'.$i] = $teamList['sczl_rate'.$i];
            $data['sczl_bzdh'] = $teamList['sczl_bzdh'];
        }
        $j = 0;
        foreach ($idList as $key => $value){
            $sql = \db('设备_产量计酬')
                ->where('UniqId',$value)
                ->fetchSql(true)
                ->update($data);
            $res = \db()->query($sql);
            if ($res === false){
                $j++;
            }
        }
        if ($j === 0){
            $this->success('修改成功');
        }else{
            $this->error('修改失败');
        }
    }

    /**
     * 检品机日产量上报数据修改
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function JpChanliangEdit()
    {
        if (Request::instance()->isPost() == false){
            $this->error('非法请求');
        }
        $params = Request::instance()->post();
        if (empty($params['UniqId'])){
            $this->error('参数错误');
        }
        $params['mod_rq'] = date('Y-m-d H:i:s');
        $data = $params;
        $data['sczl_装版总工时'] = $params['sczl_装版工时'];
        unset($data['UniqId']);
        $sql = \db('设备_产量计酬')->where('UniqId',$params['UniqId'])->fetchSql(true)->update($data);
        $res = \db()->query($sql);
        if ($res === false){
            $this->error('修改失败');
        }else{
            $this->success('成功');
        }
    }

    /**
     * 检品机日产量上报数据列表
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function JPmachineDetail()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $machine = input('machine');
        $date = input('date');
        $where = [
            'sczl_jtbh' => $machine,
            'sczl_rq' => date('Y-m-d H:i:s',strtotime($date.' 00:00:00')),
        ];
        $field = 'rtrim(sczl_gdbh) as 工单编号,rtrim(sczl_dedh) as dedh,rtrim(sczl_yjno) as yjno,rtrim(sczl_gxh) as gxh,rtrim(sczl_gxmc) as gxmc,rtrim(sczl_type) as 检验类型,rtrim(sczl_num) as num,rtrim(sczl_cl) as 计件箱数,
        rtrim(sczl_Pgcl) as 每箱数量,rtrim(sczl_bzdh) as bzdh,IF(sczl_废品率系数 = 0, "",sczl_废品率系数) as 废品率系数,IF(sczl_装版工时 = 0, "",sczl_装版工时) as 换膜补时, IF(sczl_保养工时 = 0, "",sczl_保养工时) as 保养工时,IF(sczl_异常停机工时 = 0, "",sczl_异常停机工时) as 异常总工时,IF(sczl_设备运行工时 = 0, "",sczl_设备运行工时) as 通电工时,
        rtrim(sys_id) as 用户,rtrim(mod_rq) as 更新时间,IF(sczl_异常工时1 = 0, "",sczl_异常工时1) as 异常补时,IF(sczl_异常类型1 = 0, "",sczl_异常类型1) as 异常类型,sczl_bh1,sczl_bh2,
        sczl_bh3,sczl_bh4,sczl_bh5,sczl_bh6,sczl_bh7,sczl_bh8,sczl_bh9,sczl_bh10,sczl_rate1,sczl_rate2,sczl_rate3,sczl_rate4,sczl_rate5,sczl_rate6,sczl_rate7,
        sczl_rate8,sczl_rate9,sczl_rate10,sczl_bh98,rtrim(UniqId) as UniqId,rtrim(sczl_工价系数) as 难度系数,rtrim(sczl_dedh) as 定额代号,sczl_rq,sczl_装版总工时 as 换膜总工时';
        //机台信息
        $machineDetail = \db('设备_基本资料')->where('设备编号',$machine)->field('rtrim(千件工价) as 千件工价,rtrim(日定额) as 日定额')->find();
        //组员信息
        $list = \db('设备_产量计酬')->where($where)->field($field)->select();
        $totalA = \db('设备_产量计酬')
            ->where($where)
            ->where('sczl_bzdh','like','A%')
            ->field('sczl_type as 检验类型,SUM(sczl_cl) as 箱数')
            ->group('检验类型')
            ->select();
        $totalB = \db('设备_产量计酬')
            ->where($where)
            ->where('sczl_bzdh','like','B%')
            ->field('sczl_type as 检验类型,SUM(sczl_cl) as 箱数')
            ->group('检验类型')
            ->select();
        if (empty($list)){
            $this->success('',[]);
        }
        foreach ($list as $key=>$value){
            //产品名称
            $productName = \db('工单_基本资料')->whereIn('Gd_gdbh',$value['工单编号'])->field('rtrim(成品名称) as 成品名称,rtrim(Gd_cpmc) as cpmc')->find();
            if (!empty($productName)){
                if (!empty($productName['成品名称'])){
                    $list[$key]['产品名称'] = $value['工单编号'].'---'.$productName['成品名称'];
                    $list[$key]['cpmc'] = $productName['成品名称'];
                }else{
                    $list[$key]['产品名称'] = $value['工单编号'];
                    $list[$key]['cpmc'] = '';
                }
            }else{
                $list[$key]['产品名称'] = $value['工单编号'];
                $list[$key]['cpmc'] = '';
            }
            if (empty($value['定额代号'])){
                $list[$key]['千件工价'] = '';
                $list[$key]['日定额'] = '';
                $list[$key]['补产标准'] = '';
            }else{
                $row = \db('dic_lzde')->where('sys_bh',$value['定额代号'])->field('rtrim(千件工价) as 千件工价,rtrim(日定额) as 日定额,rtrim(补产标准) as 补产标准')->find();
                $list[$key]['千件工价'] = $row['千件工价'];
                $list[$key]['日定额'] = $row['日定额'];
                $list[$key]['补产标准'] = $row['补产标准'];
            }
            $list[$key]['工序'] = $list[$key]['yjno'].'-'.$list[$key]['gxmc'];
            for ($i=1;$i<11;$i++){
                if (isset($value['sczl_bh'.$i])){
                    $name = \db('人事_基本资料')->where('员工编号',$value['sczl_bh'.$i])->field('员工姓名 as name')->find();
                    if (isset($name['name'])){
                        $list[$key]['组员'.$i] = $value['sczl_bh'.$i].$name['name'].'('.((float)$value['sczl_rate'.$i]*100).'%'.')';
                        $list[$key]['sczl_name'.$i] = $name['name'];
                    }else{
                        $list[$key]['sczl_name'.$i] = '';
                    }
                }
            }
        }
        $list['totalA'] = $totalA;
        $list['totalB'] = $totalB;
        $this->success('成功',$list);
    }
}