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

<?php

namespace app\api\controller;


use app\common\controller\Api;
use Monolog\Handler\IFTTTHandler;
use think\Db;
use think\Request;

/**
 * 工单资料管理
 */
class WorkOrder extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * 工单资料菜单列表
     *
     * @ApiMethod (GET)
     * @return false|string
     * @throws \think\Exception
     */
    public function DataList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $where = [
            '行号' => '1',
        ];
        $ClientList = Db::table('erp_客户供应商')->where('类型','客户')->cache(true)->column('简称','编号');
        //获取总计划中数量和总生产中数量
        $productingAll = Db::table('工单_基本资料')->where('gd_statu','2-生产中')->cache(true)->count();
        $progressAll = Db::table('工单_基本资料')->where('gd_statu','3-计划中')->cache(true)->count();
        $data = [
            'productingAll' => $productingAll,
            'progressAll' => $progressAll
        ];
        //按客户编号查询生产中，计划中数量
        foreach ($ClientList as $key=>$value){
            $order = Db::table('工单_基本资料')->where('Gd_客户代号',$key)->cache(true)->count();
            if ($order !== 0){
                $productIng = Db::table('工单_基本资料')->where('Gd_客户代号',$key)->where($where)->where('gd_statu','2-生产中')->cache(true)->count();
                $proGress = Db::table('工单_基本资料')->where('Gd_客户代号',$key)->where($where)->where('gd_statu','3-计划中')->cache(true)->count();
                $code = Db::table('工单_基本资料')->where('Gd_客户代号',$key)->field('rtrim(成品代号) as 成品代号')->cache(true)->find();
                $Detail = [
                    'Gd_khdh' => substr($code['成品代号'],0,4),
                    'Gd_khmc' => rtrim($value),
                    'producting' => $productIng = 0?'':"生产中：".$productIng,
                    'progress' => $proGress=0?'':'计划中：'.$proGress,
                ];
                $menu = $Detail['Gd_khdh'].'【'.$Detail['producting'].$Detail['progress'].'】'.'【'.$Detail['Gd_khmc'].'】';
                array_push($data,$menu);
            }
        }
        $this->success('成功',$data);
    }

    /**
     * 工单基本资料列表
     * @ApiMethod (GET)
     * @param string $limit 查询长度
     * @param string $Gd_khdh 客户代号
     * @param string $startTime 接单日期开始时间
     * @param string $endTime  接单日期结束时间
     * @return \think\response\Json
     * @throws \think\exception\DbException
     */
    public function WorkList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $search = input('search');
        $limit = input('limit');
        $clientNumber = input('Gd_khdh');
        $startTime = input('start');
        $endTime = input('end');
        $workOrder = input('workOrder');
        $productCode = input('productCode');
        if (!empty($clientNumber)){
            $where['成品代号'] = ['like',$clientNumber.'%'];
        }
        if (!empty($workOrder)){
            $where['Gd_gdbh'] = $workOrder;
        }
        if (!empty($productCode)){
            $where['Gd_cpdh'] = $productCode;
        }
        if (!empty($search)){
            $where['Gd_lx|Gd_gdbh|Gd_客户代号|Gd_客户名称|Gd_khdh|Gd_khmc|Gd_cpdh|Gd_cpmc|成品代号|成品名称|产品版本号'] = ['like','%'.$search.'%'];
        }
        if (!empty($startTime) && !empty($endTime)){
            $where['接单日期'] = ['between',[$startTime,$endTime]];
        }
        $list = Db::table('工单_基本资料')
            ->where($where)
            ->order('接单日期 desc')
            ->paginate($limit);
        //工单基本资料数据整理
        $data = [];
        foreach ($list->items() as $key=>$value){
            $data[$key] = [
                '工单编号' => rtrim($value['Gd_gdbh']),
                '生产分类' => rtrim($value['Gd_生产分类']),
                '销售订单号' => rtrim($value['销售订单号']),
                '产品代号' => rtrim($value['Gd_cpdh']),
                '产品名称' => rtrim($value['Gd_cpmc']),
                '订单数量' => rtrim($value['订单数量']),
                '单位' => rtrim($value['计量单位']),
                '折合大箱' => rtrim((int)$value['投料大箱']),
                '投料率' => rtrim($value['投料率']),
                '平均合格率' => '',
                '开单日期' => date('Y-m-d',strtotime(rtrim($value['接单日期']))),
                '交货日期' => date('Y-m-d',strtotime(rtrim($value['交货日期']))),
                '工单类型' => rtrim($value['Gd_lx']),
                '工单状态' => rtrim($value['gd_statu']),
                '当前生产工序' => '',
                '产量提交时间' =>  '',
                '建档用户' => rtrim($value['Sys_id']),
                '建档时间' => rtrim($value['Sys_rq']),
                '更新时间' => rtrim($value['Mod_rq']),
                'Uniqid' => rtrim($value['Uniqid'])
            ];
        }
        $this->success('成功',$data);
    }

    /**
     * 印件资料
     * @ApiMethod (GET)
     * @param string $Gd_gdbh  工单编号
     * @return \think\response\Json
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function Printed()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $Gd_gdbh = input('Gd_gdbh');
        if (empty($Gd_gdbh)){
            $this->error('参数错误');
        }
        $list = Db::table('工单_印件资料')->where('Yj_Gdbh',$Gd_gdbh)->select();
        $data = [];
        if ($list){
            foreach ($list as $key=>$value){
                $data[$key] = [
                    '印件号' => rtrim($value['yj_Yjno']),
                    '印件代号' => rtrim($value['yj_Yjdh']),
                    '印件名称' => rtrim($value['yj_yjmc']),
                    '纸张代号' => rtrim($value['yj_zzdh']),
                    '纸张名称' => rtrim($value['yj_zzmc']),
                    '投料规格' => rtrim($value['yj_tlgg']),
                    '平张投料' => rtrim($value['yj_平张投料']),
                    '开料规格' => rtrim($value['yj_klgg']),
                    '开数*联数' => rtrim($value['yj_ks']).'*'.rtrim($value['yj_ls']),
                    '建档用户' => rtrim($value['Sys_id']),
                    '建档时间' => rtrim($value['Sys_rq']),
                    '更新时间' => rtrim($value['Mod_rq']),
                    'zzdh1'  => rtrim($value['yj_zzdh1']),
                    'zzdh2'  => rtrim($value['yj_zzdh2']),
                    'zzdh3'  => rtrim($value['yj_zzdh3']),
                    'zzdh4'  => rtrim($value['yj_zzdh4']),
                    'zzmc1'  => rtrim($value['yj_zzmc1']),
                    'zzmc2'  => rtrim($value['yj_zzmc2']),
                    'zzmc3'  => rtrim($value['yj_zzmc3']),
                    'zzmc4'  => rtrim($value['yj_zzmc4']),
                    '订单数量' => rtrim($value['yj_成品数量']),
                    '万小张' => rtrim($value['yj_实际投料']),
                    '开数' => rtrim($value['yj_ks']),
                    '联数' => rtrim($value['yj_ls']),
                    '核算规格' => rtrim($value['Yj_核算规格']),
                    '备注' => rtrim($value['yj_desc']),
                    'Uniqid' => rtrim($value['Uniqid'])
                ];
            }
        }
        $this->success('成功',$data);
    }

    /**
     * 工艺资料
     * @ApiMethod (GET)
     * @param string $Gd_gdbh  工单编号
     * @return \think\response\Json
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function Craft()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }

        $Gd_gdbh = input('Gd_gdbh');
        if (empty($Gd_gdbh)){
            $this->error('参数错误');
        }
        $list = Db::table('工单_工艺资料')
            ->where('Gy0_gdbh',$Gd_gdbh)
            ->select();
        $Gd_cpdh = Db::table('工单_基本资料')->where('Gd_gdbh',$Gd_gdbh)->field('Gd_cpdh')->find();
        $data = [];
        if ($list){
            foreach ($list as $key=>$value){
                if ($value['Gy0_yjno']<10){
                    $value['Gy0_yjno'] = '0'.$value['Gy0_yjno'];
                }
                if ($value['Gy0_gxh']<10){
                    $value['Gy0_gxh'] = '0'.$value['Gy0_gxh'];
                }
                $where = [
                    'Gy0_cpdh' => $Gd_cpdh['Gd_cpdh'],
                    'Gy0_yjno' => $value['Gy0_yjno'],
                    'Gy0_gxh' => $value['Gy0_gxh'],
                ];
                $product = Db::table('产品_工艺资料')->where($where)->field('工价系数,损耗系数')->find();
                $data[$key] = [
                    '重点工序' => rtrim($value['重点工序']),
                    '印件-工序' => rtrim($value['Gy0_yjno']).'-'.rtrim($value['Gy0_gxh']),
                    '备选工序' => '',
                    '工序名称' => rtrim($value['Gy0_gxmc']).'【'.rtrim($value['Add_gxmc']).'】',
                    '计划产量' => rtrim($value['Gy0_计划接货数']),
                    '基础损耗' => rtrim($value['Gy0_Rate0']),
                    '损耗率' => rtrim($value['Gy0_Rate1']),
                    '报废定额' => '',
                    '允损比例' => '',
                    '难度系数' => isset($product['工价系数'])?rtrim($product['工价系数']):'',
                    '损耗系数' => isset($product['损耗系数'])?rtrim($product['损耗系数']):'',
                    '人工检_次品板' => (int)$value['人工检_次品板']=0?'':$value['人工检_次品板'],
                    '人工检_废检' => (int)$value['人工检_废检']=0?'':$value['人工检_废检'],
                    '机检_正品板' => (int)$value['机检_正品板']=0?'':$value['机检_正品板'],
                    '机检_次品板' => (int)$value['机检_次品板']=0?'':$value['机检_次品板'],
                    '机检_废检' => (int)$value['机检_废检']=0?'':$value['机检_废检'],
                    '开数*联数' => rtrim($value['Gy0_ks']).'*'.rtrim($value['Gy0_ls']),
                    '备注' => isset($value['工序备注'])?rtrim($value['工序备注']):'',
                    '印刷方式' => isset($value['印刷方式'])?rtrim($value['印刷方式']):'',
                    '版距' => isset($value['版距'])?rtrim($value['版距']):'',
                    '建档用户' => rtrim($value['Sys_id']),
                    '建档日期' => isset($value['Sys_rq'])?rtrim($value['Sys_rq']):'',
                    '更新时间' => isset($value['Mod_rq'])?rtrim($value['Mod_rq']):'',
                    '车间名称' => rtrim($value['Gy0_SITE']),
                    '质量要求' => rtrim($value['质量要求']),
                    '质量隐患' => rtrim($value['质量隐患']),
                    '开数' => rtrim($value['Gy0_ks']),
                    '联数' => rtrim($value['Gy0_ls']),
                    'UniqId' => rtrim($value['UniqId'])
                ];
            }
        }
        $this->success('成功',$data);
    }

    /**
     * BOM资料
     * @ApiMethod (GET)
     * @param string $Gd_gdbh   工单编号
     * @return \think\response\Json
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function Bom()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $Gd_gdbh = input('Gd_gdbh');
        if (empty($Gd_gdbh)){
            $this->error('参数错误');
        }
        $field = 'rtrim(BOM_方案) as 方案,rtrim(BOM_物料编码) as 物料编号,rtrim(BOM_物料名称) as 物料名称,BOM_投料单位,
        BOM_投入数,BOM_产出数,BOM_产出单位,rtrim(BOM_计划用量) as 计划用量,rtrim(Sys_ID) as 建档用户,rtrim(Sys_rq) as 建档时间,rtrim(Mod_rq) as 更新时间';
        $list = Db::table('工单_bom资料')
            ->where('BOM_工单编号',$Gd_gdbh)
            ->field($field)
            ->select();
        foreach ($list as $key=>$value){
            $list[$key]['消耗定量'] = rtrim($value['BOM_投入数']).rtrim($value['BOM_投料单位']).'/'.rtrim($value['BOM_产出数']).rtrim($value['BOM_产出单位']);
            unset($list[$key]['BOM_投料单位'],$list[$key]['BOM_投入数'],$list[$key]['BOM_产出数'],$list[$key]['BOM_产出单位']);
            $list[$key]['计划用量'] = rtrim((float)$value['计划用量']);
        }
        $this->success('成功',$list);
    }


    /**
     * 编辑页面展示
     * @ApiMethod (GET)
     * @param string $workOrder   工单编号
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function DataCorrection()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $workOrder = input('Gd_gdbh');
        if (empty($workOrder)){
            $this->error('参数错误');
        }
        $field = 'rtrim(Gd_lx) as 重点工单,rtrim(Gd_gdbh) as 工单编号,rtrim(Gd_生产分类) as 生产类型,rtrim(Gd_khdh) as 客户代号,rtrim(Gd_客户名称) as 客户名称,
        rtrim(Gd_cpdh) as 产品代号,rtrim(Gd_cpmc) as 产品名称,rtrim(开单日期) as 开单日期,rtrim(订单数量) as 订单数量,rtrim(交货日期) as 交货日期,
        rtrim(投料率) as 投料率,rtrim(实际投料) as 万小张,rtrim(计量单位) as 单位,rtrim(投料大箱) as 投料大箱,rtrim(排产时库存) as 库存大箱,rtrim(警语版面) as 警语版面,
        rtrim(销售订单号) as 销售订单号,rtrim(产品版本号) as 版本号,rtrim(客户ERP编码) as 客户ERP编码,rtrim(码源数量) as 码源数量,rtrim(进程备注) as 进程备注,rtrim(Gd_desc) as 备注,rtrim(Uniqid) as Uniqid';
        $list = Db::table('工单_基本资料')->where('Gd_gdbh',$workOrder)->field($field)->find();
        if (empty($list)){
            $this->error('未找到该工单信息');
        }
        $printData = Db::table('工单_印件资料')
            ->where('Yj_Gdbh',$workOrder)
            ->field('rtrim(yj_yjmc) as 印件名称,rtrim(yj_Yjdh) as 印件代号,rtrim(yj_平张投料) as 平张投料')
            ->find();
        if (empty($printData)){
            $this->error('未找到该工单印件资料');
        }
        $list['印件名称'] = $printData['印件名称'];
        $list['印件代号'] = $printData['印件代号'];
        $list['平张投料'] = $printData['平张投料'];
        $this->success('成功',$list);
    }

    /**
     * 工单资料修改
     * @ApiMethod (POST)
     * @param  void
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */

    public function WorkOrderEdit()
    {
        if ($this->request->isPost() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param) || isset($param['Uniqid']) === false){
            $this->error('参数错误');
        }
        $row = [
            'Gd_lx' => isset($param['lx'])?$param['lx']:'',
            '开单日期' => isset($param['kdrq'])?$param['kdrq']:'',
            'Gd_gdbh' => isset($param['gdbh'])?$param['gdbh']:'',
            'Gd_生产分类' => isset($param['scfl'])?$param['scfl']:'',
            'Gd_客户代号' => isset($param['khdh'])?$param['khdh']:'',
            'Gd_客户名称' => isset($param['khmc'])?$param['khmc']:'',
            '成品代号' => isset($param['cpdh'])?$param['cpdh']:'',
            '成品名称' => isset($param['cpmc'])?$param['cpmc']:'',
            '订单数量' => isset($param['ddsl'])?$param['ddsl']:'',
            '交货日期' => isset($param['jhrq'])?$param['jhrq']:'',
            '投料率' => isset($param['tll'])?$param['tll']:'',
            '计划投料' => isset($param['jhtl'])?$param['jhtl']:'',
            '实际投料' => isset($param['sjtl'])?$param['sjtl']:'',
            '计量单位' => isset($param['jldw'])?$param['jldw']:'',
            '投料大箱' => isset($param['tldx'])?$param['tldx']:'',
            '销售订单号' => isset($param['xsddh'])?$param['xsddh']:'',
            '警语版面' => isset($param['jymb'])?$param['jymb']:'',
            '产品版本号' => isset($param['bbh'])?$param['bbh']:'',
            '客户ERP编码' => isset($param['erp'])?$param['erp']:'',
            '码源数量' => isset($param['ymsl'])?$param['ymsl']:'',
            '进程备注' => isset($param['jcbz'])?$param['jcbz']:'',
            'Gd_desc' => isset($param['desc'])?$param['desc']:'',
        ];
        $sql = Db::table('工单_基本资料')->where('Uniqid',$param['Uniqid'])->fetchSql(true)->update($row);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }


    /**
     * U8投料试算
     * @ApiMethod (GET)
     * @param string  $processCode   产品编号
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */

    public function U8Trial()
    {
        if ($this->request->isGet() === false)
        {
            $this->error('请求错误');
        }
        $productCode = input('productCode');
        if (empty($productCode)){
            $this->error('参数错误');
        }
        $field = 'rtrim(Gy0_cpdh) as 产品代号,rtrim(Gy0_yjno) as 印件号,rtrim(Gy0_gxh) as 工序号,rtrim(gy0_gxmc) as gxmc,rtrim(Add_gxmc) as add_gxmc,
        rtrim(Gy0_Ms) as 墨色数,rtrim(Gy0_shdh) as 损耗代号,rtrim(损耗系数) as 损耗系数,rtrim(Gy0_ls) as 加工联数';
        $list = Db::table('产品_工艺资料')->where('Gy0_cpdh',$productCode)->field($field)->select();
        if (empty($list)){
            $this->error('未找到该产品工序');
        }
        foreach ($list as $key=>$value){
            $data = Db::table('dic_lzsh')->where('sys_bh',$value['损耗代号'])->field('rtrim(sys_rate0) as rate0,rtrim(sys_rate1) as rate1')->cache(true)->find();
            $list[$key]['调机损耗'] = isset($data['rate0'])?$data['rate0']:'';
            $list[$key]['运行损耗率'] = isset($data['rate1'])?$data['rate1']:'';
            if ($value['add_gxmc'] !== ''){
                $list[$key]['工序名称'] = $value['gxmc'].'【'.$value['add_gxmc'].'】';
            }else{
                $list[$key]['工序名称'] = $value['gxmc'];
            }
            unset($list[$key]['gxmc'],$list[$key]['add_gxmc']);
        }
        $this->success('成功',$list);
    }


    /**
     * 引用产品资料->获取产品资料
     * @ApiMethod  (GET)
     * @param  string $workOrder   工单编号
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */

    public function ProductInformation()
    {
        if ($this->request->isGet() === false)
        {
            $this->error('请求错误');
        }
        $workOrder = input('workOrder');
        if (empty($workOrder)){
            $this->error('参数错误');
        }
        $field = 'rtrim(Gd_gdbh) as 工单编号,rtrim(Gd_客户名称) as 客户名称,rtrim(成品代号) as 产品代号,rtrim(成品名称) as 产品名称';
        $Detail = Db::table('工单_基本资料')->where('Gd_gdbh',$workOrder)->field($field)->find();
        if (empty($Detail)){
            $this->error('未找到工单信息');
        }
        $Detail['客户代号'] = substr($Detail['产品代号'],0,4);
        $this->success('成功',$Detail);
    }

    /**
     * 引用产品资料->复制产品工艺资料
     * @ApiMethod  (POST)
     * @param string $oldWorkOrder   被复制工单编号
     * @param string $newWorkOrder   复制工单编号
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */

    public function ProductInformationEdit()
    {
        if ($this->request->isPost() === false)
        {
            $this->error('请求错误');
        }
        $oldWorkOrder = input('oldWorkOrder');
        $newWorkOrder = input('newWorkOrder');
        if (empty($oldWorkOrder) || empty($newWorkOrder))
        {
            $this->error('参数错误');
        }
        //获取原工单工艺资料
        $oldProcessData = Db::table('工单_工艺资料')->where('Gy0_gdbh',$oldWorkOrder)->select();
        $ProsessUniqId = Db::table('工单_工艺资料')->field('UniqId')->order('UniqId desc')->find();
        foreach ($oldProcessData as $k=>$v){
            $oldProcessData[$k]['Gy0_gdbh']  = $newWorkOrder;
            $oldProcessData[$k]['Sys_id'] = '';
            $oldProcessData[$k]['UniqId'] = $ProsessUniqId['UniqId'] + $k + 1;
        }
        if (Db::table('工单_工艺资料')->where('Gy0_gdbh',$newWorkOrder)->find()){
            Db::table('工单_工艺资料')->where('Gy0_gdbh',$newWorkOrder)->delete();
        }
        //获取原工单印件资料
        $oldPrintData = Db::table('工单_印件资料')->where('Yj_Gdbh',$oldWorkOrder)->select();
        $PrintUniqId = Db::table('工单_印件资料')->field('Uniqid')->order('Uniqid desc')->find();
        foreach ($oldPrintData as $k=>$v){
            $oldPrintData[$k]['Yj_Gdbh']  = $newWorkOrder;
            $oldPrintData[$k]['Sys_id'] = '';
            $oldPrintData[$k]['Uniqid'] = $PrintUniqId['Uniqid'] +$k +1;
        }
        if (Db::table('工单_印件资料')->where('Yj_Gdbh',$newWorkOrder)->find()){
            Db::table('工单_印件资料')->where('Yj_Gdbh',$newWorkOrder)->delete();
        }
        //复制印件、工艺资料
        $ProcessSQL = Db::table('工单_工艺资料')->fetchSql(true)->insertAll($oldProcessData);
        $ProcessRes = Db::query($ProcessSQL);
        $PrintSQL = Db::table('工单_印件资料')->fetchSql(true)->insertAll($oldPrintData);
        $PrintRes = Db::query($PrintSQL);
        if ($ProcessRes !== false && $PrintRes !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }


    /**
     * 工艺流程调成->获取当前工单工艺资料
     * @ApiMethod (GET)
     * @param string $workorder  当前工单编号
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ProcessFlow()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $workOrder = input('workOrder');
        if (empty($workOrder)){
            $this->error('参数错误');
        }
        $list = Db::table('工单_基本资料')->where('Gd_gdbh',$workOrder)->field('rtrim(成品代号) as 成品编号,rtrim(成品名称) as 成品名称')->find();
        if (empty($list)){
            $this->error('未找到工单信息');
        }
        $filed = 'rtrim(Gy0_方案) as 方案,rtrim(Gy0_yjno) as 印件号,rtrim(Gy0_gxh) as 工序号,rtrim(Gy0_gxmc) as gxmc,rtrim(Add_gxmc) as add_gxmc,
        rtrim(工价系数) as 工价系数,rtrim(损耗系数) as 损耗系数,rtrim(Gy0_ks) as ks,rtrim(Gy0_ls) as ls,rtrim(工序备注) as 备注,rtrim(Gy0_SITE) as 车间,
        rtrim(Gy0_sbbh) as 设备编号,rtrim(Gy0_sbmc) as 设备名称,rtrim(Sys_id) as 建档用户,rtrim(Sys_rq) as 建档时间,rtrim(Mod_rq) as 更新时间';
        $process = Db::table('工单_工艺资料')->where('Gy0_gdbh',$workOrder)->field($filed)->select();
        if (empty($process)){
            $this->error('未找到该工单工艺资料');
        }
        foreach ($process as $key=>$value){
            if (isset($value['add_gxmc'])){
                $process[$key]['工序名称'] = $value['gxmc'] . '【'.$value['add_gxmc'].'】';
            }else{
                $process[$key]['工序名称'] = $value['gxmc'];
            }
            $process[$key]['工价系数'] = (float)$value['工价系数'];
            $process[$key]['损耗系数'] = (float)$value['损耗系数'];
            $process[$key]['开数*联数'] = $value['ks'].'*'.$value['ls'];
        }
        $list['process'] = $process;
        $this->success('成功',$list);
    }

    /**
     * 参照工单列表获取
     * @ApiMethod (GET)
     * @param string $workOrder  工单编号
     * @param string $productCode   产品代号
     * @return void
     */
    public function ReferenceWorkOrder()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $productCode = input('productCode');
        $workOrder = input('workOrder');
        if (empty($productCode) || empty($workOrder)){
            $this->error('参数错误');
        }
        $list = Db::table('工单_基本资料')->where('成品代号',$productCode)->where('Gd_gdbh','<>',$workOrder)->column('Gd_gdbh');
        if (empty($list)){
            $this->error('未获取该产品其他工单信息');
        }
        $this->success('成功',$list);
    }

    /**
     * 工艺资料复制
     * @ApiMethod (POST)
     * @param  string $oldWorkOrder    被复制工单编号
     * @param  string $newWorkOrder    复制工单编号
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     *
     */
    public function ProcessCopy()
    {
        if ($this->request->isPost() === false){
            $this->error('请求错误');
        }
        $oldWorkOrder = input('oldWorkOrder');
        $newWorkOrder = input('newWorkOrder');
        if (empty($oldWorkOrder) || empty($newWorkOrder))
        {
            $this->error('参数错误');
        }
        //获取原工单工艺资料
        $oldProcessData = Db::table('工单_工艺资料')->where('Gy0_gdbh',$oldWorkOrder)->select();
        $ProsessUniqId = Db::table('工单_工艺资料')->field('UniqId')->order('UniqId desc')->find();
        foreach ($oldProcessData as $k=>$v){
            $oldProcessData[$k]['Gy0_gdbh']  = $newWorkOrder;
            $oldProcessData[$k]['Sys_id'] = '';
            $oldProcessData[$k]['Mod_rq'] = date('Y-m-d H:i:s',time());
            $oldProcessData[$k]['UniqId'] = $ProsessUniqId['UniqId'] + $k + 1;
        }
        if (Db::table('工单_工艺资料')->where('Gy0_gdbh',$newWorkOrder)->find()){
            Db::table('工单_工艺资料')->where('Gy0_gdbh',$newWorkOrder)->delete();
        }
        //插入工艺资料
        $ProcessSQL = Db::table('工单_工艺资料')->fetchSql(true)->insertAll($oldProcessData);
        $ProcessRes = Db::query($ProcessSQL);
        if ($ProcessRes !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * U8工单列表
     * @ApiMethod (GET)
     * @param  void
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function U8workOrder()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $filed = 'rtrim(Gd_gdbh) as 工单编号,rtrim(行号) as 行号,rtrim(Gd_客户代号) as 客户代号,rtrim(Gd_客户名称) as 客户名称,
        rtrim(成品代号) as 成品代号,rtrim(成品名称) as 成品名称,rtrim(Mod_rq) as 获取日期,rtrim(Uniqid) as 序号';
        $list = Db::table('工单_基本资料')->where('Gd_gdbh',$param['workOrder'])->field($filed)->select();
        if (empty($list)){
            $this->error('未找到工单');
        }
        $this->success('成功',$list);
    }

    /**
     * U8工单资料删除
     * @param string $workOrder  工单编号
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function U8DataCorrection()
    {
        if($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $workOrder = input('Uniqid');
        if (empty($workOrder)){
            $this->error('参数错误');
        }
        $data = [];
        if (strpos($workOrder,',')){
            $data = explode(',',$workOrder);
        }else{
            $data[0] = $workOrder;
        }
        $res = Db::table('工单_基本资料')->where('Uniqid','in',$data)->delete();
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }


    /**
     * 产品废检系数调整->质检工艺数据获取
     * @ApiMethod (GET)
     * @param  string  $workOrder   工单编号
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function TestCoefficient()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $workOrder = input('workOrder');
        if (empty($workOrder)){
            $this->error('参数错误');
        }
        $where = [
            'Gy0_gdbh' => $workOrder,
            'Gy0_gxmc' => ['like','%检%']
        ];
        $filed = 'rtrim(Gy0_gdbh) as gdbh,rtrim(Gy0_yjno) as yjno,rtrim(Gy0_gxh) as gxh,rtrim(Gy0_gxmc) as gxmc,rtrim(人工检_正品板) as 人工正品板,
        rtrim(人工检_次品板) as 人工次品板,rtrim(人工检_废检) as 人工废检,rtrim(机检_正品板) as 机检正品板,rtrim(机检_次品板) as 机检次品板,
        rtrim(机检_废检) as 机检废检,rtrim(Gy0_sbbh) as 设备编号,rtrim(Uniqid) as Uniqid';
        $list = Db::table('工单_工艺资料')->where($where)->field($filed)->select();
        if (empty($list)){
            $this->error('未找到该工单工艺');
        }
        $name = Db::table('工单_基本资料')
            ->where('Gd_gdbh',$workOrder)
            ->field('rtrim(Gd_cpdh) as 产品代号,rtrim(Gd_khmc) as 客户名称,rtrim(Gd_cpmc) as 产品名称')
            ->find();
        if (empty($name)){
            $this->error('未找到该工单');
        }
        foreach ($list as $key=>$value){
            if ($value['yjno']<10){
                $value['yjno'] = '0'.$value['yjno'];
            }
            if ($value['gxh']<10){
                $value['gxh'] = '0'.$value['gxh'];
            }
            $list[$key]['印件工序及工艺'] = $value['gdbh'].'-'.$value['yjno'].'-'.$value['gxh'].'-'.$value['gxmc'];
            unset($list[$key]['gdbh'],$list[$key]['yjno'],$list[$key]['gxmc']);
            $list[$key]['产品编号'] = $name['产品代号'];
            $list[$key]['产品名称'] = $name['产品名称'];
            $list[$key]['客户名称'] = $name['客户名称'];
        }
        $this->success('成功',$list);
    }

    /**
     * 产品质检系数调整->系数修改
     * @ApiMethod (GET)
     * @param string $workorder   工单编号
     * @param string $processCode  工序号
     * @param float $code1  人工正品板
     * @param float $code2  人工次品板
     * @param float $code3  人工废检
     * @param float $code4  机检正品板
     * @param float $code5  机检次品板
     * @param float $code6  机检废检
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function TestCoefficientEdit()
    {
        if ($this->request->isPost() === false){
            $this->error('请求错误');
        }
        $workOrder = input('workOrder');
        $processCode = input('processCode');
        $row = [
            '人工检_正品板' => input('code1'),
            '人工检_次品板' => input('code2'),
            '人工检_废检'   => input('code3'),
            '机检_正品板' => input('code4'),
            '机检_次品板' => input('code5'),
            '机检_废检' => input('code6'),
        ];
        if (empty($workOrder) || empty($processCode)){
            $this->error('参数错误');
        }
        $where = [
            'Gy0_gdbh' => $workOrder,
            'Gy0_gxh' => $processCode
        ];
        $sql = Db::table('工单_工艺资料')->where($where)->fetchSql(true)->update($row);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }


    /**
     * 修正工单核算参数->数据获取
     * @ApiMethod (GET)
     * @param string $workOrder  工单编号
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function AccountingParameter()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $workOrder = input('workOrder');
        if (empty($workOrder)){
            $this->error('参数错误');
        }
        $field = 'rtrim(Gy0_方案) as 方案,rtrim(Gy0_yjno) as yjno,rtrim(Gy0_gxh) as gxh,rtrim(Gy0_gxmc) as gxmc,rtrim(Add_gxmc) as add_gxmc,
        rtrim(Gy0_sbbh) as 参照设备,rtrim(工价系数) as 难度系数,rtrim(Gy0_shdh) as 损耗代号,rtrim(Gy0_Rate0) as 基础损耗,rtrim(Gy0_Rate1) as 损耗率,
        rtrim(印刷方式) as 印刷方式,rtrim(版距) as 版距,rtrim(Gy0_ms) as 计损色数,rtrim(损耗系数) as 损耗系数,rtrim(UniqId) as UniqId';
        $list = Db::table('工单_工艺资料')->where('Gy0_gdbh',$workOrder)->field($field)->select();
        if (empty($list)){
            $this->error('未找到该工单工艺资料');
        }
        foreach ($list as $key=>$value){
            if ($value['yjno']<10){
                $value['yjno'] = '0'.$value['yjno'];
            }
            if ($value['gxh']<10){
                $value['gxh'] = '0'.$value['gxh'];
            }
            $list[$key]['印件号及工序名称'] = $value['yjno'].'-'.$value['gxh'].$value['gxmc'].'('.$value['add_gxmc'].')';
            unset($list[$key]['yjno'],$list[$key]['gxmc'],$list[$key]['add_gxmc']);
        }
        $this->success('成功',$list);
    }


    /**
     * 修正工单核算参数->参数修改
     * @ApiMethod （POST）
     * @param  void
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function AccountingParameterEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param) || isset($param[0]['Uniqid']) === false){
            $this->error('参数错误');
        }
        $i = 0;
        foreach ($param as $key=>$value){
            $data = Db::table('dic_lzsh')->where('sys_bh',$value['loss'])->field('rtrim(sys_rate0) as rate0,rtrim(sys_rate1) as rate1')->find();
            $row = [
                '工价系数' => $value['difficulty']?:'',
                'Gy0_shdh' => $value['loss']?:'',
                '印刷方式' => $value['printMode']?:'',
                '版距' => $value['plate']?:'',
                'Gy0_ms' => $value['chromatic']?:'',
                '损耗系数' => $value['wastage']?:'',
                'Gy0_Rate0' => $data['rate0'],
                'Gy0_Rate1' => $data['rate1']
            ];
            $sql = Db::table('工单_工艺资料')->where('Uniqid',$value['Uniqid'])->fetchSql(true)->update($row);
            $res = Db::query($sql);
            if ($res !== false){
                $i++;
            }
        }
        if ($i !== 0){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 印件资料修改
     * @ApiMethod （POST）
     * @param  void
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */

    public function PrintedEdit()
    {
        if ($this->request->isPost() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param) || isset($param['Uniqid']) === false){
            $this->error('参数错误');
        }
        $data = [
            'yj_Yjno' => isset($param['yjno'])?$param['yjno']:'',
            'yj_Yjdh' => isset($param['yjdh'])?$param['yjdh']:'',
            'yj_yjmc' => isset($param['yjmc'])?$param['yjmc']:'',
            'yj_zzdh' => isset($param['zzdh'])?$param['zzdh']:'',
            'yj_zzdh1' => isset($param['zzdh1'])?$param['zzdh1']:'',
            'yj_zzdh2' => isset($param['zzdh2'])?$param['zzdh2']:'',
            'yj_zzdh3' => isset($param['zzdh3'])?$param['zzdh3']:'',
            'yj_zzdh4' => isset($param['zzdh4'])?$param['zzdh4']:'',
            'yj_zzmc' => isset($param['zzmc'])?$param['zzmc']:'',
            'yj_zzmc1' => isset($param['zzmc1'])?$param['zzmc1']:'',
            'yj_zzmc2' => isset($param['zzmc2'])?$param['zzmc2']:'',
            'yj_zzmc3' => isset($param['zzmc3'])?$param['zzmc3']:'',
            'yj_zzmc4' => isset($param['zzmc4'])?$param['zzmc4']:'',
            'yj_成品数量' => isset($param['cpsl'])?$param['cpsl']:'',
            'yj_实际投料' => isset($param['sjtl'])?$param['sjtl']:'',
            'yj_平张投料' => isset($param['pztl'])?$param['pztl']:'',
            'yj_tlgg' => isset($param['tlgg'])?$param['tlgg']:'',
            'yj_klgg' => isset($param['klgg'])?$param['klgg']:'',
            'Yj_核算规格' => isset($param['hsgg'])?$param['hsgg']:'',
            'yj_ks' => isset($param['ks'])?$param['ks']:'',
            'yj_ls' => isset($param['ls'])?$param['ls']:'',
            'yj_desc' => isset($param['desc'])?$param['desc']:'',
        ];
        $sql = Db::table('工单_印件资料')->where('Uniqid',$param['Uniqid'])->fetchSql(true)->update($data);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }

    }

    /**
     * 工艺资料修改
     * @ApiMethod (POST)
     * @param void
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function ProcessDetailEdit()
    {
        if ($this->request->isPost() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param) || isset($param['UniqId']) === false){
            $this->error('参数错误');
        }
        $rate = Db::table('dic_lzsh')->where('sys_bh',$param['shdh'])->field('rtrim(sys_rate0) as rate0,rtrim(sys_rate1) as rate1')->find();
        $data = [
            'Gy0_yjno' => isset($param['yjno'])?$param['yjno']:'',
            'Gy0_gxh' => isset($param['gxh'])?$param['gxh']:'',
            '重点工序' => isset($param['zdgx'])?$param['zdgx']:'',
            'Gy0_ks' => isset($param['ks'])?$param['ks']:'',
            'Gy0_ls' => isset($param['ls'])?$param['ls']:'',
            'Gy0_SITE' => isset($param['site'])?$param['site']:'',
            'Gy0_gxmc' => isset($param['gxmc'])?$param['gxmc']:'',
            'Add_gxmc' => isset($param['add_gxmc'])?$param['add_gxmc']:'',
            'Gy0_ms' => isset($param['ms'])?$param['ms']:'',
            'Gy0_sbbh' => isset($param['sbbh'])?$param['sbbh']:'',
            'Gy0_Rate0' => $rate['rate0'],
            'Gy0_Rate1' => $rate['rate1'],
            'Gy0_辅助工时' => isset($param['fzgs'])?$param['fzgs']:'',
            'Gy0_小时产能' => isset($param['xscn'])?$param['xscn']:'',
            'Gy0_shdh' => isset($param['shdh'])?$param['shdh']:'',
            '损耗系数' => isset($param['shxs'])?$param['shxs']:'',
            '工价系数' => isset($param['ndxs'])?$param['ndxs']:'',
            '印刷方式' => isset($param['ysfs'])?$param['ysfs']:'',
            '版距' => isset($param['bj'])?$param['bj']:'',
            '工序备注' => isset($param['gxbz'])?$param['gxbz']:'',
            '质量要求' => isset($param['zlyq'])?$param['zlyq']:'',
            '质量隐患' => isset($param['sbyh'])?$param['sbyh']:'',
            'Mod_rq' => date('Y-m-d H:i:s',time()),
        ];
        $sql = Db::table('工单_工艺资料')->where('UniqId',$param['UniqId'])->fetchSql(true)->update($data);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    //
}