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

<?php

namespace app\api\controller;


use app\common\controller\Api;
use Monolog\Handler\IFTTTHandler;
use Overtrue\Socialite\Providers\WeWorkProvider;
use think\Db;
use think\Request;
use function fast\e;

/**
 *
 * 生产排单管理
 */
class Manufacture extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * 计划中工单
     * @ApiMethod （GET）
     * @return \think\response\Json
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function Project()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        if ($param['status'] === '计划中'){
            $status = '3-计划中';
        }else{
            $status = '1-已完工';
        }
        $page = 0;
        $limit = 15;
        if (isset($param['page'])){
            $page = $param['page'];
        }
        if (isset($param['limit'])){
            $limit = $param['limit'];
        }
        $where = [
            'gd_statu' => $status,
            '行号' => '1',
        ];
        if (isset($param['search'])){
            $where['Gd_lx|Gd_gdbh|Gd_客户代号|Gd_客户名称|Gd_khdh|Gd_khmc|Gd_cpdh|Gd_cpmc|成品代号|成品名称|产品版本号'] = ['like','%'.$param['search'].'%'];
        }
        $field = 'rtrim(Gd_生产分类) as 生产分类,rtrim(Gd_gdbh) as 工单编号,rtrim(Gd_cpdh) as 产品代号,rtrim(Gd_cpmc) as 产品名称,rtrim(成品名称) as 成品名称,
        rtrim(接单日期) as 接单日期,rtrim(交货日期) as 交货日期,rtrim(订单数量) as 订单数量,rtrim(计量单位) as 计量单位,rtrim(Gd_khmc) as 客户名称,
        rtrim(Gd_客户代号) as 客户编号,rtrim(Gd_desc) as 备注,rtrim(客户料号) as 客户料号,rtrim(Sys_id) as 创建用户,rtrim(Sys_rq) as 创建时间,
        rtrim(Mod_rq) as 修改时间,rtrim(Uniqid) as UNIQID,rtrim(投料率) as 投料率,rtrim(销售订单号) as 销售订单号';
        $list = \db('工单_基本资料')->where($where)->field($field)->limit(($page-1)*$limit,$limit)->order('Uniqid desc')->select();
        $total = \db('工单_基本资料')->where($where)->count();
        if (empty($list)){
            $this->success('',[]);
        }
        foreach ($list as $key=>$value){
            $list[$key]['订单数量'] = rtrim((float)$value['订单数量']);
            $list[$key]['产品名称'] = $value['产品名称'] != '' ? $value['产品名称']:$value['成品名称'];
            $number = \db('工单_工艺资料')->where('Gy0_gdbh',$value['工单编号'])->count();
            if ($number === 0){
                $list[$key]['status'] = 0;
            }else{
                $list[$key]['status'] = 1;
            }
            unset($list[$key]['成品名称']);
        }
        $this->success('成功',['data'=>$list,'total'=>$total]);
    }

    /**
     * 计划中工单->工艺资料
     * @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 projectCraft()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $Gd_gdbh = input('Gd_gdbh');
        if (empty($Gd_gdbh)){
            $this->error('参数错误');
        }
        $where = [
            'Gy0_gdbh' => $Gd_gdbh
        ];
        $filed = 'rtrim(Gy0_gdbh) as 工单编号,rtrim(重点工序) as 重点工序,Gy0_yjno,Gy0_gxh,Gy0_gxmc,Add_gxmc,rtrim(工序备注) as 工序备注,
        rtrim(Gy0_sbbh) as 机组,rtrim(Gy0_小时产能) as 小时产能,rtrim(Gy0_生产工时) as 生产工时,rtrim(Gy0_辅助工时) as 辅助工时,
        rtrim(印刷方式) as 印刷方式,rtrim(版距) as 版距,rtrim(Sys_id) as 创建用户,rtrim(Sys_rq) as 创建时间,rtrim(Mod_rq) as 修改时间,rtrim(UniqId) as UNIQID';
        $list = \db('工单_工艺资料')->where($where)->field($filed)->select();
        if (empty($list)){
            $this->success('',[]);
        }
        foreach ($list as $key=>$value){
            if ((int)$value['Gy0_yjno'] <10){
                $value['Gy0_yjno'] = '0'.rtrim($value['Gy0_yjno']);
            }
            if ((int)$value['Gy0_gxh'] <10){
                $value['Gy0_gxh'] = '0'.rtrim($value['Gy0_gxh']);
            }
            if (rtrim($value['Add_gxmc']) == ''){
                $list[$key]['印件工序及名称'] = $value['Gy0_yjno'].'-'.$value['Gy0_gxh'].'-->'.rtrim($value['Gy0_gxmc']);
            }else{
                $list[$key]['印件工序及名称'] = $value['Gy0_yjno'].'-'.$value['Gy0_gxh'].'-->'.rtrim($value['Gy0_gxmc']).'【'.rtrim($value['Add_gxmc']).'】';
            }
            unset($list[$key]['Gy0_gxmc'],$list[$key]['Add_gxmc']);
        }
        $this->success('成功',$list);
    }


    /**
     * 计划中工单->印件资料
     * @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 projectPrint()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $Gd_gdbh = input('Gd_gdbh');
        if (empty($Gd_gdbh)){
            $this->error('参数错误');
        }
        $where = [
            'Yj_Gdbh' => $Gd_gdbh,
        ];
        $field = 'rtrim(Yj_Gdbh) as 工单编号,rtrim(yj_Yjno) as 印件号,rtrim(yj_Yjdh) as 印件代号,rtrim(yj_yjmc) as 印件名称,
        rtrim(yj_zzmc) as 纸张名称,rtrim(yj_tlgg) as 投料规格,rtrim(yj_成品数量) as 成品数量,rtrim(yj_实际投料) as 实际投料,
        rtrim(yj_Dw) as  投料单位,rtrim(yj_平张投料) as 平张投料,rtrim(yj_ls) as 联数,rtrim(yj_ks) as 开数,rtrim(Sys_id) as 创建用户,
        rtrim(Sys_rq) as 创建时间,rtrim(Mod_rq) as 修改时间,rtrim(Uniqid) as UNIQID';
        $list = \db('工单_印件资料')->where($where)->field($field)->select();
        if (empty($list)){
            $this->success('');
        }
        foreach ($list as $key=>$value){
            $list[$key]['成品数量'] = rtrim((float)$value['成品数量']);
            $list[$key]['实际投料'] = rtrim((float)$value['实际投料']);
        }
        $this->success('成功',$list);
    }

    /**
     * 排程中/制程中工单
     */
    public function Schedule(){
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $where = '';
        if (!empty($param['search'])){
            $where = "
                        a.Gd_gdbh LIKE '%{$param['search']}%' 
                        OR a.`成品名称` LIKE '%{$param['search']}%' 
                    ";
        }
        if ($param['status'] === '排程中'){
            $list = db('工单_基本资料')->alias('a')
                ->field([
                    'rtrim(a.Gd_gdbh)' => '工单编号',
                    'rtrim(a.Gd_cpdh)' => '产品代号',
                    'rtrim(a.Gd_cpmc)' => '产品名称',
                    'rtrim(a.接单日期)' => '接单日期',
                    'rtrim(a.交货日期)' => '交货日期',
                    'rtrim(a.订单数量)' => '订单数量',
                    'rtrim(a.计量单位)' => '计量单位',
                    'rtrim(a.销售订单号)' => '销售订单号',
                    'rtrim(a.Gd_客户代号)' => '客户编号',
                    'rtrim(a.Gd_客户名称)' => '客户名称',
                    'rtrim(a.客户料号)' => '客户料号',
                    'rtrim(a.Uniqid)' => 'GDUID',
                ])
                ->join('工单_工艺资料 b', 'a.Gd_gdbh = b.Gy0_gdbh')
                ->where([
                    'a.gd_statu' => '2-生产中',
                    'a.行号' => '1',
                    'b.PD_WG' => '1900-01-01 00:00:00',
                ])
                ->where($where)
//                ->whereNotExists(function ($query) {
//                    $query->table('工单_工艺资料')->alias('b2')
//                        ->where('b2.Gy0_gdbh = a.Gd_gdbh')
//                        ->where('b2.Gy0_sj1 <> "1900-01-01 00:00:00"');
//                })
                ->group('a.Gd_gdbh')
                ->select();
        }else{
            $list = db('工单_基本资料')->alias('a')
                ->field([
                    'rtrim(a.Gd_gdbh)' => '工单编号',
                    'rtrim(a.Gd_cpdh)' => '产品代号',
                    'rtrim(a.Gd_cpmc)' => '产品名称',
                    'rtrim(a.接单日期)' => '接单日期',
                    'rtrim(a.交货日期)' => '交货日期',
                    'rtrim(a.订单数量)' => '订单数量',
                    'rtrim(a.计量单位)' => '计量单位',
                    'rtrim(a.销售订单号)' => '销售订单号',
                    'rtrim(a.Gd_客户代号)' => '客户编号',
                    'rtrim(a.Gd_客户名称)' => '客户名称',
                    'rtrim(a.客户料号)' => '客户料号',
                    'rtrim(a.Uniqid)' => 'GDUID',
                ])
                ->join('工单_工艺资料 b', 'a.Gd_gdbh = b.Gy0_gdbh')
                ->where([
                    'a.gd_statu' => '2-生产中',
                    'a.行号' => '1',
                    'b.PD_WG' => '1900-01-01 00:00:00',
                    'b.Gy0_sj1' => ['<>', '1900-01-01 00:00:00'],
                ])
                ->where($where)
                ->group('a.Gd_gdbh')
                ->select();
        }
        if (empty($list)){
            $this->success('未找到工单信息');
        }
        $this->success('成功',$list);
    }

    /**
     * 排程中/制程中工单->工序列表
     * @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 ScheduleProcess()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $Gd_gdbh = input('Gd_gdbh');
        if (empty($Gd_gdbh)){
            $this->error('参数错误');
        }
        $sql = "SELECT rtrim(a.Gy0_gdbh) as 工单编号,a.Gy0_yjno,a.Gy0_gxh,a.Gy0_gxmc,a.Add_gxmc,rtrim(a.Gy0_sbbh) as 设备编号,rtrim(a.Gy0_小时产能) as 小时产能,
                rtrim(a.工价系数) as 产能系数,rtrim(a.Gy0_生产工时) as 生产工时,rtrim(a.Gy0_辅助工时) as 辅助工时,rtrim(a.Gy0_最早开工时间) as 最早开工时间,
                rtrim(a.Gy0_sj1) as 计划开工时间,rtrim(a.Gy0_sj2) as 计划完工时间,rtrim(a.Gy0_班次安排) as 班次安排,rtrim(a.工序备注) as 排单备注,
                rtrim(a.PD_WG) as 工序完工,rtrim(a.UniqId) as UniqId,COALESCE(b.cl, 0) AS 产量, c.设备名称,rtrim(d.计划投料) as 工序产量
                FROM `工单_工艺资料` AS a
                JOIN `设备_基本资料` AS c ON a.Gy0_sbbh = c.设备编号
                JOIN `工单_基本资料` As d ON a.Gy0_gdbh = d.Gd_Gdbh
                LEFT JOIN (
                        SELECT sczl_gdbh, sczl_gxh, SUM(sczl_cl) AS cl
                        FROM `设备_产量计酬`
                        GROUP BY sczl_gdbh, sczl_gxh
                ) AS b ON a.Gy0_gdbh = b.sczl_gdbh AND (a.Gy0_gxh = b.sczl_gxh OR b.sczl_gxh IS NULL)
                WHERE a.Gy0_gdbh = '{$Gd_gdbh}' AND a.Gy0_sbbh != ''
                GROUP BY a.Gy0_yjno,a.Gy0_gxh";
        $list = Db::query($sql);
        if (empty($list)){
            $this->success('未找到工序');
        }
        foreach ($list as $key=>$value){
            if ((int)$value['Gy0_yjno'] <10){
                $value['Gy0_yjno'] = '0'.rtrim($value['Gy0_yjno']);
            }
            if ((int)$value['Gy0_gxh'] <10){
                $value['Gy0_gxh'] = '0'.rtrim($value['Gy0_gxh']);
            }
            if (rtrim($value['Add_gxmc']) == ''){
                $list[$key]['印件工序及名称'] = $value['Gy0_yjno'].'-'.$value['Gy0_gxh'].'-->'.rtrim($value['Gy0_gxmc']);
            }else{
                $list[$key]['印件工序及名称'] = $value['Gy0_yjno'].'-'.$value['Gy0_gxh'].'-->'.rtrim($value['Gy0_gxmc']).'【'.rtrim($value['Add_gxmc']).'】';
            }
            unset($list[$key]['Gy0_gxmc'],$list[$key]['Add_gxmc']);
            $list[$key]['机组'] = $value['设备编号'];
            $list[$key]['剩余产量'] = (int)$list[$key]['工序产量']-(int)$list[$key]['产量'];
        }
        $this->success('成功',$list);
    }
    /**
     * 排单页面左侧车间和机台菜单
     * @ApiMethod (GET)
     * @return \think\response\Json
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function workbench()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (isset($param['sort'])){
            $where['使用部门'] = '智能车间';
        }else{
            $where['使用部门'] = ['in',['印刷车间','印后车间']];
        }
        $data = [];
        $department = \db('设备_基本资料')
            ->distinct(true)
            ->where('使用部门','<>','研发中心')
            ->where('设备编组','<>','')
            ->where($where)
            ->order('设备编组')
            ->column('使用部门');
        if (empty($department)){
            $this->success('为获取到机台数据');
        }
        foreach ($department as $value){
            $benchClass = \db('设备_基本资料')->where('使用部门',$value)->distinct(true)->order('设备编组')->column('设备编组');
            foreach ($benchClass as $v){
                if (rtrim($v) !== ''){
                    $machine = \db('设备_基本资料')->where('使用部门',$value)->where('设备编组',$v)->field('rtrim(设备编号) as 设备编号,rtrim(设备名称) as 设备名称')->select();
                    foreach ($machine as $kk=>$vv){
                        $data[rtrim($value)][rtrim($v)][$kk] = $vv['设备编号'].'-->'.$vv['设备名称'];
                    }
                }
            }
        }

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


    /**
     * 工单状态设置
     * @ApiMethod (GET)
     * @param string $workOrder  工单编号
     * @param string $status   工单状态
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function StatusEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $workOrder = input('workOrder');
        $status = input('status');
        if (empty($workOrder) || empty($status)){
            $this->error('参数错误');
        }
        $sql = \db('工单_基本资料')->where('Gd_gdbh',$workOrder)->fetchSql(true)->update(['gd_statu'=>$status]);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 更改工序状态
     * @ApiMethod (GET)
     * @param void
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function complete()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $data = $this->request->param();
        if (empty($data)){
            $this->error('参数错误');
        }
        $where = [
            'Gy0_gdbh' => $data['workOrder'],
            'Gy0_gxh'  => $data['processCode']
        ];
        $sql = \db('工单_工艺资料')->where($where)->fetchSql(true)->update(['PD_WG'=>date('Y-m-d H:i:s',time())]);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 加入排产
     * @ApiMethod (POST)
     * @param void $data
     * @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 ProductionSchedulingAdd()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $data = Request::instance()->post();
        if (empty($data)){
            $this->error('参数错误');
        }
        $where = [
            'Gy0_gdbh' => $data['workOrder'],
            'Gy0_sbbh' => ['like','%'.$data['machine'].'%'],
            'Gy0_yjno' => $data['printCode'],
            'Gy0_gxh'  => $data['processCode']
        ];
        $result = \db('工单_工艺资料')->where($where)->field('rtrim(Gy0_sj1) as sj1')->find();
        if ($result['sj1'] != '1900-01-01 00:00:00'){
            $this->error('该工单已经是制程中');
        }
        $lastTime = \db('工单_工艺资料')
            ->where(['Gy0_sbbh'=>$where['Gy0_sbbh'],'Gy0_sj2'=>['<>','1900-01-01 00:00:00'],'Gy0_sj2'=>['<','2099-01-01 00:00:00']])
            ->field('rtrim(Gy0_sj2) as sj2')
            ->order('Gy0_sj2 desc')
            ->find();
        $date = date('Y-m-d H:i:s',time());
        if ($lastTime['sj2'] < $date){
            $newTime = $date;
        }else{
            $newTime = $lastTime['sj2'];
        }
        $row = \db('工单_工艺资料')
            ->where($where)
            ->field('rtrim(Gy0_计划接货数) as 计划接货数,rtrim(Gy0_小时产能) as 小时产能,rtrim(Gy0_辅助工时) as 辅助工时')
            ->find();
        if (empty($row)){
            $this->success('未找到该工单工艺资料');
        }
        $endTime = date('Y-m-d H:i:s',strtotime($newTime) + ((int)round($row['计划接货数']/$row['小时产能'])+(int)$row['辅助工时'])*3600);
        $sql = \db('工单_工艺资料')
            ->where($where)
            ->fetchSql(true)
            ->update(['Gy0_sj1'=>$newTime,'Gy0_sj2'=>$endTime,'Mod_rq'=>date('Y-m-d H:i:s',time())]);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 暂停排产
     * @ApiMethod (POST)
     * @param  void  $data
     * @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 ProductionSchedulingPause()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $data = Request::instance()->post();
        if (empty($data)){
            $this->error('参数错误');
        }
        $where = [
            'Gy0_gdbh' => $data['workOrder'],
            'Gy0_sbbh' => ['like','%'.$data['machine'].'%'],
            'Gy0_yjno' => $data['printCode'],
            'Gy0_gxh'  => $data['processCode']
        ];
        $machine = $data['machine'];
        $endTime = \db('工单_工艺资料')->where($where)->field('rtrim(Gy0_sj2) as sj2,rtrim(PD_WG) as wg')->find();
        if (empty($endTime)){
            $this->success('未找到该工序');
        }
        $time = $endTime['sj2'];
        if ($endTime['sj2'] == '1900-01-01 00:00:00' || $endTime['wg'] != '1900-01-01 00:00:00'){
            $this->error('该工单不是制程中工单');
        }
        $sql = \db('工单_工艺资料')
            ->where($where)
            ->fetchSql(true)
            ->update(['Gy0_sj1'=>'1900-01-01 00:00:00','Gy0_sj2'=>'1900-01-01 00:00:00','Mod_rq'=>date('Y-m-d H:i:s')]);
        $row = \db('工单_工艺资料')
            ->where($where)
            ->field('rtrim(Gy0_计划接货数) as 计划接货数,rtrim(Gy0_小时产能) as 小时产能,rtrim(Gy0_辅助工时) as 辅助工时')
            ->find();
        if (empty($row)){
            $this->success('未找到该工序');
        }
        $number = -(int)round($row['计划接货数']/$row['小时产能'])+(int)$row['辅助工时'];
        $rechSql = "UPDATE `工单_工艺资料` SET Gy0_sj1 = DATE_ADD(Gy0_sj1, INTERVAL {$number} HOUR),Gy0_sj2 = DATE_ADD(Gy0_sj2, INTERVAL {$number} HOUR) WHERE Gy0_sbbh LIKE '%{$machine}%' AND Gy0_sj1 >= '{$time}' AND Gy0_sj1 < '2099-01-01 00:00:00'";
        $rechres = Db::query($rechSql);
        $res = Db::query($sql);
        if ($res !== false && $rechres !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 工序状态更正
     * @ApiMethod (GET)
     * @param  void $param
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ProcessStatusCorrection()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $where = [
            'Gy0_gdbh' => $param['workOrder'],
        ];
        $workOrder = $where['Gy0_gdbh'];
        $field = 'rtrim(Gy0_yjno) as yjno,rtrim(Gy0_gxh) as gxh,rtrim(Gy0_gxmc) as gxmc,rtrim(Gy0_sbbh) as 设备代号,rtrim(Gy0_计划接货数) as 计划接货数,rtrim(Gy0_ls) as ls,rtrim(PD_WG) as 完工时间,rtrim(UniqId) as UniqId';
        $list = \db('工单_工艺资料')->where($where)->field($field)->order('Gy0_yjno,Gy0_gxh')->select();
        if (empty($list)){
            $this->success('未找到该工单工艺资料');
        }
        $yieldSql = "SELECT
            a.Gy0_yjno AS yjno,
            a.Gy0_gxh AS gxh,
            SUM( b.sczl_cl ) AS cl 
        FROM
            `工单_工艺资料` AS a
            JOIN `设备_产量计酬` AS b ON a.Gy0_gxh = b.sczl_gxh AND a.Gy0_yjno = b.sczl_yjno
        WHERE
            a.Gy0_gdbh = '{$workOrder}' 
        GROUP BY
            a.Gy0_yjno,a.Gy0_gxh";
        $yield = Db::query($yieldSql);
        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'];
            foreach ($yield as $k=>$v){
                if ($v['yjno'] === $list[$key]['yjno']) {
                    if ($v['gxh'] === $list[$key]['gxh']){
                        $list[$key]['计划产量/已完成'] = (int)$value['计划接货数'] . '/' . $v['cl'];
                        if ($value['计划接货数'] !== 0 && $value['计划接货数'] !== '' && !empty($value['计划接货数'])) {
                            $num = (float)number_format(intval($v['cl']) / intval($value['计划接货数']), 4);
                            $list[$key]['完成率'] = $num * 100 . '%';
                        } else {
                            $list[$key]['完成率'] = '';
                        }
                    }else{
                        $list[$key]['计划产量/已完成'] = $value['计划接货数'].'/0';
                        $list[$key]['完成率'] = '';
                    }
                }
            }
            if ($value['完工时间'] == '1900-01-01 00:00:00') {
                $list[$key]['完工时间'] = '';
            }
            unset($list[$key]['yjno'],$list[$key]['gxh'],$list[$key]['gxmc'],$list[$key]['计划接货数'],$list[$key]['ls']);
        }
        $this->success('成功',$list);
    }


    /**
     * 工序状态更正->工序状态编辑
     * @ApiMethod (POST)
     * @param  void
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function ProcessStatusCorrectionEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $i = 0;
        foreach ($param as $key=>$value){
            if ($value['PD_WG'] === null || $value['PD_WG'] === ''){
                $endTime = '1900-01-01 00:00:00';
            }else{
                $endTime = $value['PD_WG'];
            }
            $sql = \db('工单_工艺资料')
                ->where('UniqId',$value['UniqId'])
                ->fetchSql(true)
                ->update(['PD_WG'=>$endTime]);
            $res = Db::query($sql);
            if ($res !== false){
                $i++;
            }
        }
        if ($i !== 0){
            $this->success('成功');
        }else{
            $this->error('失败');
        }

    }

    /**
     * 班次选择
     * @ApiMethod （GET）
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ScheduleSelection()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $list = \db('工单_排程班次')->field('rtrim(bcdh) as 班次代号,rtrim(desc_) as desc_,rtrim(stdtime) as stdtime')->select();
        if (empty($list)){
            $this->success('未找到班次数据');
        }
        foreach ($list as $key=>$value){
            $list[$key]['detail'] = $value['班次代号'].'||'.$value['desc_'].'||'.$value['stdtime'];
            unset($list[$key]['desc_'],$list[$key]['stdtime']);
        }
        $this->success('成功',$list);
    }

    /**
     * 车间设备制程展示
     * @ApiMethod （GET）
     * @param  void $param
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */

    public function EquipmentScheduling()
    {
        if ($this->request->isGet() === false){
            $this->error('参数错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $machine = $param['machine'];
        $list = \db('工单_基本资料')
            ->alias('a')
            ->field([
                'rtrim(b.Gy0_gdbh)' => '工单编号',
                'rtrim(b.Gy0_计划接货数)' => '计划接货数',
                'rtrim(b.Gy0_小时产能)' => '小时产能',
                'rtrim(b.Gy0_生产工时)' => '生产工时',
                'rtrim(b.Gy0_辅助工时)' => '辅助工时',
                'rtrim(b.Gy0_班次安排)' => '班次安排',
                'rtrim(b.工序备注)' => '排单备注',
                'rtrim(b.Gy0_最早开工时间)' => '最早开工时间',
                'rtrim(b.Gy0_sj1)' => '计划开工时间',
                'rtrim(b.Gy0_sj2)' => '计划完工时间',
                'rtrim(b.Gy0_yjno)' => 'yjno',
                'rtrim(b.Gy0_gxh)' => 'gxh',
                'rtrim(b.Gy0_gxmc)' => 'gxmc',
                'rtrim(b.Gy0_ls)' => 'ls',
                'rtrim(b.UniqId)' => 'UniqId',
                'SUM(c.sczl_cl)' => '已完成'
            ])
            ->join('工单_工艺资料 b','a.Gd_gdbh = b.Gy0_gdbh')
            ->join('设备_产量计酬 c','a.Gd_gdbh = c.sczl_gdbh AND b.Gy0_yjno = c.sczl_yjno AND b.Gy0_gxh = c.sczl_gxh','LEFT')
            ->where([
                'b.Gy0_sbbh' => $machine,
                'b.Gy0_sj1' => ['>','1900-01-01 00:00:00'],
                'b.PD_WG' => '1900-01-01 00:00:00',
                'a.gd_statu' => '2-生产中'
            ])
            ->where('b.Gy0_sj1','<','2099-01-01 00:00:00')
            ->group('a.Gd_gdbh')
            ->select();
        foreach ($list as $key=>$value){
            $list[$key]['计划接货数'] = (int)round($value['计划接货数']/$value['ls']);
            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'];
            unset($list[$key]['yjno'],$list[$key]['gxh'],$list[$key]['gxmc'],$list[$key]['ls']);
        }
        $this->success('成功',$list);
    }

    /**
     * 车间设备排程编辑
     * @ApiMethod (POST)
     * @param  void $param
     * @return void
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function EquipmentSchedulingEdit()
    {
        if (Request::instance()->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $i = 0;
        foreach ($param as $key=>$value){
            $data = [
                'Gy0_小时产能' => $value['capacity'],
                'Gy0_生产工时' => $value['ProductionHours'],
                'Gy0_辅助工时' => $value['AuxiliaryHours'],
                'Gy0_班次安排' => $value['shift'],
                '工序备注' => $value['remark'],
                'Gy0_最早开工时间' => $value['start'] === ''?'1900-01-01 00:00:00':date('Y-m-d H:i:s',strtotime($value['start'])),
                'Gy0_sj1' => date('Y-m-d H:i:s',strtotime($value['projectTime'])),
//                'Gy0_sj2' => date('Y-m-d H:i:s',strtotime($value['projectTime'])+(ceil($value['ProductionHours'])+ceil($value['AuxiliaryHours']))*3600),
                'Gy0_sj2' => date('Y-m-d H:i:s',strtotime($value['endTime'])),
            ];
            $sql = \db('工单_工艺资料')
                ->where('UniqId',$value['UniqId'])
                ->fetchSql(true)
                ->update($data);
            $res = Db::query($sql);
            if ($res !== false){
                $i++;
            }
        }
        if ($i !== 0){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }


    /**
     * 机台工单展示
     * @ApiMethod ()
     * @return void
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function MachineWorkOrderList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求失败');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $where = '';
        if (isset($param['search'])){
            $where = "
                        b.Gd_gdbh LIKE '%{$param['search']}%' 
                        OR b.`成品名称` LIKE '%{$param['search']}%' 
                    ";
        }
        $list = \db('工单_工艺资料')
            ->alias('a')
            ->field([
                'RTRIM( a.Gy0_yjno )' =>'yjno',
                'RTRIM( a.Gy0_gxh )' => 'gxh',
                'RTRIM( a.Gy0_gxmc )' => 'gxmc',
                'RTRIM( a.Add_gxmc )' => 'Add_gxmc',
                'RTRIM( c.yj_yjmc )' => '印件名称',
                'RTRIM( a.`Gy0_计划接货数` )' => '计划接货数',
                'RTRIM( a.`Gy0_小时产能` )' => '小时产能',
                'RTRIM( a.`工价系数` )' => '产能系数',
                'RTRIM( a.`Gy0_生产工时` )' => '生产工时',
                'RTRIM( a.Gy0_ls )' => 'ls',
                'RTRIM( a.`Gy0_辅助工时` )' => '辅助工时',
                'RTRIM( a.`Gy0_最早开工时间` )' => '最早开工时间',
                'RTRIM( a.Gy0_sj1 )' => '计划开工时间',
                'RTRIM( a.Gy0_sj2 )' => '计划完工时间',
                'RTRIM( a.`Gy0_班次安排` )' => '班次安排',
                'RTRIM( a.`工序备注` )' => '排单备注',
                'RTRIM( b.Gd_cpmc )' => '产品名称',
                'RTRIM( b.`成品名称` )' => '成品名称',
                'RTRIM( b.`订单数量` )' => '订单数量',
                'RTRIM( b.`计量单位` )' => '计量单位',
                'RTRIM( b.`交货日期` )' => '交货日期',
                'RTRIM( b.Gd_cpdh )' => '产品代号',
                'RTRIM( b.`成品代号` )' => '成品代号',
                'RTRIM( a.Gy0_sbbh )' => '设备编号',
                'RTRIM( a.Gy0_SITE )' => '车间名称',
                'RTRIM( a.UniqId )' => 'GYUID',
                'RTRIM( b.Uniqid )' => 'UNIQID',
                'SUM( d.sczl_cl )' => '已完成产量',
                'RTRIM( b.Gd_gdbh )' => '工单编号',
                'RTRIM( b.`销售订单号` )' => '销售订单号',
            ])
            ->join('工单_印件资料 c','c.Yj_Gdbh = a.Gy0_gdbh AND c.yj_Yjno = a.Gy0_yjno')
            ->join('工单_基本资料 b','b.Gd_gdbh = a.Gy0_gdbh')
            ->join('设备_产量计酬 d','a.Gy0_gdbh = d.sczl_gdbh AND a.Gy0_yjno = d.sczl_yjno AND a.Gy0_gxh = d.sczl_gxh AND a.Gy0_sbbh = d.sczl_jtbh','LEFT')
            ->where([
                'b.gd_statu' => '2-生产中',
                'a.Gy0_sbbh' => ['LIKE','%'.$param['machine'].'%'],
                'a.PD_WG' => '1900-01-01 00:00:00',
            ])
            ->where($where)
            ->group('a.Gy0_gdbh,a.Gy0_yjno,a.Gy0_gxh')
            ->order('Gy0_sj1')
            ->select();
        if (empty($list)){
            $this->success('',[]);
        }
        $data['制程'] = $data['排程'] = [];
        foreach ($list as $key=>$value){
            $list[$key]['设备编号'] = $param['machine'];
            if ((int)$value['yjno'] <10){
                $value['yjno'] = '0'.rtrim($value['yjno']);
            }
            if ((int)$value['gxh'] <10){
                $value['gxh'] = '0'.rtrim($value['gxh']);
            }
            if (rtrim($value['Add_gxmc']) == ''){
                $list[$key]['印件工序及名称'] = $value['yjno'].'-'.$value['gxh'].'-->'.rtrim($value['gxmc']);
            }else{
                $list[$key]['印件工序及名称'] = $value['yjno'].'-'.$value['gxh'].'-->'.rtrim($value['gxmc']).'【'.rtrim($value['Add_gxmc']).'】';
            }
            unset($list[$key]['Add_gxmc']);
            if ($value['产品名称'] == ''){
                $list[$key]['产品名称'] = $value['成品名称'];
            }
            if ($value['产品代号'] == ''){
                $list[$key]['产品代号'] = $value['成品代号'];
            }
            unset($list[$key]['成品代号'],$list[$key]['成品名称']);
            if ($list[$key]['计划开工时间'] !== '1900-01-01 00:00:00'){
                array_push($data['制程'],$list[$key]);
            }else{
                array_push($data['排程'],$list[$key]);
            }
        }

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

    /**
     * 机组调整
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function MachineTeamEdit()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param) || isset($param['UniqId']) === false){
            $this->error('参数错误');
        }
        $sql = \db('工单_工艺资料')
            ->where('UniqId',$param['UniqId'])
            ->fetchSql(true)
            ->update(['Gy0_sbbh'=>$param['machine']]);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('修改成功');
        }else{
            $this->error('修改失败');
        }
    }

    /**
     * 子订单领料派单
     * @return void
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function processAdd()
    {
        if (Request::instance()->post() === false){
            $this->error('参数错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $data['班组编号'] = $param['班组'];
        $data['订单编号'] = $param['订单编号'];
        $data['子订单编号'] = $param['子订单编号'];
        $data['sys_id'] = $param['Sys_id'];
        $data['sys_rq'] = date('Y-m-d H:i:s',time());
        $sql = \db('工单_排程班次')->fetchSql(true)->insert($data);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('成功');
        }else{
            $this->error('失败');
        }
    }

    /**
     * 生产数据菜单显示
     * @return void
     */
    public function MachineList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $date = date('Y-m-d 00:00:00',time()-1888000);
        $arr = \db('设备_产量计酬')
            ->field([
                'DISTINCT(date_format(sczl_rq,"%Y-%m-%d"))' => '时间',
                'rtrim(sczl_jtbh)' => '机台编号'
            ])
            ->where('sczl_rq','>',$date)
            ->order('sczl_rq desc')
            ->select();
        $MachineList = \db('设备_基本资料')
            ->where('生产工序','in',['车缝','后道','总检','大烫','包装'])
            ->select();
        $list = ['车缝','后道','总检','大烫','包装'];
        $data =[];
        foreach ($list as $m=>$n){
            $data[$n] = [];
            foreach ($MachineList as $key=>$value){
                if ($n === $value['生产工序']){
                    $data[$n][$value['设备编号'].'--'.$value['设备编组']] = [];
                    foreach ($arr as $k=>$v){
                        if ($value['设备编号'] === $v['机台编号']){
                            array_push($data[$n][$value['设备编号'].'--'.$value['设备编组']],$v['时间']);
                        }
                    }
                }
            }
        }
        $this->success('成功',$data);
    }

    /**
     * 班组生产数据
     * @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('参数错误');
        }
        if (isset($param['date'])){
            $where['a.sczl_rq'] = $param['date'];
        }
        $where['a.sczl_jtbh'] = $param['machine'];
        $list = \db('设备_产量计酬')
            ->alias('a')
            ->join('工单_印件资料 b','b.订单编号 = a.订单编号 AND a.子订单编号 = a.子订单编号')
            ->field('b.订单编号,b.子订单编号,b.款号,b.颜色,b.船样,a.尺码,b.zdtotal as 制单数,a.数量 as 已完成,a.sys_rq as 上报时间')
            ->where($where)
            ->group('a.UniqId')
            ->select();
        $this->success('成功',$list);
    }

    /**
     * 工单审核
     * @return void
     * @throws \think\Exception
     * @throws \think\db\exception\BindParamException
     * @throws \think\exception\PDOException
     */
    public function Approval()
    {
        if ($this->request->isPost() === false){
            $this->error('请求错误');
        }
        $param = Request::instance()->post();
        if (empty($param)){
            $this->error('参数错误');
        }
        $data['审核'] = $param['sys_id'];
        $data['审核日期'] = date('Y-m-d H:i:s');
        $sql = \db('工单_基本资料')
            ->where('Uniqid',$param['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 UnapprovalList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (isset($param)){
            $where['订单编号'] = ['like','%'.$param['search'].'%'];
        }
//        $where['审核'] = null;
//        $where['审核日期'] = null;
        $where['Mod_rq'] = null;
        $list = \db('工单_基本资料')
            ->where($where)
            ->orderRaw("FIELD(gd_statu, '1-计划中', '2-生产中')")  // 自定义状态排序，'1-计划中'排在前
            ->order('订单编号 desc')  // 按订单编号降序排序
            ->select();
        $this->success('成功',$list);
    }

    /**
     * 月度工序产量列表
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function OrderYieldList()
    {
        // 判断是否是GET请求
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }

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

        // 处理搜索条件
        if (isset($param['search'])){
            $where['a.订单编号'] = ['like','%'.$param['search'].'%'];
        }
        if (isset($param['client'])){
            $where['b.客户编号'] = $param['client'];
        }

        // 只查询生产中的工单
        $where['b.gd_statu'] = '2-生产中';

        // 查询第一个表，获取产量信息，添加a.sys_rq字段
        $list = \db('设备_产量计酬')
            ->alias('a')
            ->join('工单_基本资料 b', 'a.订单编号 = b.订单编号')
            ->join('工单_印件资料 c', 'a.订单编号 = c.订单编号 AND a.子订单编号 = c.子订单编号')
            ->field('c.订单编号, c.子订单编号, c.款号, c.颜色, c.zdtotal as 制单总数, c.sctotal as 裁切总数, c.ck_rq as 出库日期, a.sys_rq, 
                 SUM(a.数量) as 产量, a.工序名称')
            ->where($where)
            ->whereNotNull('c.sc_rq')  // 过滤出生产日期不为空的数据
            ->group('a.订单编号, a.工序名称')
            ->order('c.Uniqid')
            ->select();

        // 查询第二个表，获取订单的基本信息
        $orderList = \db('工单_印件资料')
            ->alias('a')
            ->join('工单_基本资料 b', 'a.订单编号 = b.订单编号')
            ->field('a.订单编号, a.子订单编号, a.款号, a.颜色, a.zdtotal as 制单总数, a.sctotal as 裁切总数, a.ck_rq as 出库日期')
            ->where($where)
            ->whereNotNull('a.sc_rq')
            ->group('a.子订单编号')
            ->order('a.Uniqid')
            ->select();

        $data = [];

        // 合并两个查询结果
        foreach ($orderList as $key => $value){
            $data[$key] = $value; // 先将订单基本信息放入$data
            foreach ($list as $k => $v){
                if ($value['子订单编号'] === $v['子订单编号']) {
                    // 根据工序名称，将对应的产量数据加入到订单信息中
                    if (!isset($data[$key][$v['工序名称']])){
                        $data[$key][$v['工序名称']] = $v['产量'];
                    }
                    // 添加sys_rq到结果
                    $data[$key]['sys_rq'] = $v['sys_rq'];
                }
            }
        }

        // 返回成功的结果，包含合并后的数据
        $this->success('成功', $data);
    }

    /**
     * 月度工序产量左侧菜单
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
//    public function dateList()
//    {
//        if ($this->request->isGet() === false){
//            $this->error('请求错误');
//        }
//        // 查询并按月份统计
//        $result = Db::name('工单_基本资料')
//            ->field("DATE_FORMAT(Sys_rq, '%Y-%m') as month")
//            ->group("DATE_FORMAT(Sys_rq, '%Y-%m')")
//            ->select();
//        $list = $this->array_flatten($result);
//        $this->success('成功',$list);
//    }
//
//    function array_flatten($array) {
//        $result = [];
//        foreach ($array as $value) {
//            if (is_array($value)) {
//                $result = array_merge($result, $this->array_flatten($value));
//            } else {
//                $result[] = $value;
//            }
//        }
//        return $result;
//    }

    /**车缝派单菜单
     * @return void
     */
    public function CfmachineList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $list = \db('设备_基本资料')
            ->where('生产工序','车缝')
            ->column('设备编号');
        $this->success('成功',$list);
    }

    /**
     * 车缝派单列表
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function CfdataList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $list = \db('工单_排程班次')
            ->where('班组编号',$param['machine'])
            ->where('mod_rq',null)
            ->order('sys_rq desc')
            ->field('订单编号,子订单编号,班组编号,sys_rq as 创建时间,sys_id as 创建人员,UniqId')
            ->group('子订单编号')
            ->select();
        $this->success('成功',$list);
    }

    //车缝派单删除
    public function CfdataDel()
    {
        if ($this->request->isGet() === false)
        {
            $this->error('请求错误');
        }
        $param = $this->request->param();
        if (empty($param)){
            $this->error('参数错误');
        }
        $sql = \db('工单_排程班次')
            ->where('UniqId',$param['UniqId'])
            ->fetchSql(true)
            ->update(['mod_rq'=>date('Y-m-d H:i:s',time())]);
        $res = \db()->query($sql);
        if ($res !== false){
            $this->success('删除成功');
        }else{
            $this->error('删除失败');
        }
    }

    //车缝派单数据
    public function CfdataAllList()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $list = \db('工单_排程班次')
            ->where('mod_rq',null)
            ->order('sys_rq desc')
            ->field('订单编号,子订单编号,班组编号,sys_rq as 创建时间,sys_id as 创建人员,UniqId')
            ->group('子订单编号')
            ->select();
        $this->success('成功',$list);
    }
}