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

<?php

namespace app\api\controller;


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

/**
 * 设备运行跟踪
 */

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


    /**
     * 左侧菜单栏
     * @ApiMethod (GET)
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function getTab()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $data = [];
        $department = Db::table('设备_基本资料')->distinct(true)->column('使用部门');
        if (empty($department)){
            $this->error('未获取到机台数据');
        }
        foreach ($department as $value){
            if (rtrim($value) !== '研发中心'){
                $machine = Db::table('设备_基本资料')->where('使用部门',$value)->field('rtrim(设备编号) as 设备编号,rtrim(设备名称) as 设备名称')->select();
                foreach ($machine as $kk=>$vv){
                    if ($vv['设备编号'] !== 'ZH01#'){
                        $date = Db::table('设备_产量计酬')->where('sczl_jtbh',$vv['设备编号'])->distinct(true)->order('UniqId desc')->limit(40)->column('sczl_rq');
                        $data[rtrim($value)][$vv['设备编号'].'【'.$vv['设备名称'].'】'] = $date;
                    }
                }
            }
        }
        $this->success('成功',$data);
    }


    /**
     * 机台每日产量
     * @ApiMethod (GET)
     * @param string $machine  机台编号
     * @param string $date 日期
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function chanLiang()
    {
        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)),
        ];
        $field = 'rtrim(sczl_gdbh) as 工单编号,rtrim(sczl_yjno) as yjno,rtrim(sczl_gxmc) as gxmc,rtrim(sczl_num) as num,rtrim(sczl_sj1) as sj1,
        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(sys_id) as 用户,rtrim(mod_rq) as 更新时间,rtrim(sczl_异常工时1) as 异常补时,rtrim(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';
        //机台信息
        $machineDetail = Db::table('设备_基本资料')->where('设备编号',$machine)->field('rtrim(千件工价) as 千件工价,rtrim(日定额) as 日定额')->find();
        //工单编号
        $Gd_gdbh = Db::table('设备_产量计酬')->where($where)->distinct(true)->column('sczl_gdbh');
        //产品名称
        $productName = Db::table('工单_基本资料')->whereIn('Gd_gdbh',$Gd_gdbh)->column('Gd_cpmc','Gd_gdbh');
        //组员信息
        $list = Db::table('设备_产量计酬')->where($where)->field($field)->select();
        $totalA = Db::table('设备_产量计酬')->where($where)->where('sczl_bzdh','A班')->field('SUM(sczl_cl) as 产量')->select();
        $totalB = Db::table('设备_产量计酬')->where($where)->where('sczl_bzdh','B班')->field('SUM(sczl_cl) as 产量')->select();
        if (empty($list)){
            $this->error('未找到机台数据');
        }
        foreach ($list as $key=>$value){
            $list[$key]['产品名称'] = $value['工单编号'].'---'.$productName[$value['工单编号']];
            if ($value['yjno']<10){
                $list[$key]['yjno'] = '0'.$value['yjno'];
            }
            $list[$key]['工序'] = $list[$key]['yjno'].'-'.$list[$key]['gxmc'];
            $list[$key]['备注'] = $value['bzdh'].'('.$value['num'].')'.date('H:i',strtotime($value['sj1'])).'<-->'.date('H:i',strtotime($value['sj2']));
            $list[$key]['千件工价'] = $machineDetail['千件工价'];
            $list[$key]['日定额'] = $machineDetail['日定额'];
            for ($i=1;$i<11;$i++){
                if (isset($value['sczl_bh'.$i])){
                    $name = Db::table('人事_基本资料')->where('员工编号',$value['sczl_bh'.$i])->field('rtrim(员工姓名) as name')->find();
                    if (isset($name['name'])){
                        $list[$key]['组员'.$i] = $value['sczl_bh'.$i].$name['name'].'('.((float)$value['sczl_rate'.$i]*100).'%'.')';
                    }
                }
                unset($list[$key]['sczl_bh'.$i],$list[$key]['sczl_rate'.$i]);
            }
            unset($list[$key]['工序编号'],$list[$key]['yjno'],$list[$key]['gxmc'],$list[$key]['num'],$list[$key]['sj1'],$list[$key]['sj2'],$list[$key]['bzdh']);
        }
        $list['totalA'] = $totalA[0]['产量'];
        $list['totalB'] = $totalB[0]['产量'];
        $this->success('成功',$list);
    }

    /**
     * 当日制程检验记录
     * @ApiMethod (GET)
     * @param string $machine  机台编号
     * @param string $date   日期
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function Inspect()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $machine = input('machine');
        $date = input('date');
        if (empty($machine) || empty($date)){
            $this->error('参数错误');
        }
        $last_id = Db::table('制程检验_记录')->order('UniqId desc')->field('UniqId')->find();
        $startId = $last_id['UniqId']-1000000;
        $where = [
            '设备编号' => $machine,
            '开工时间' => ['between',[date('Y-m-d 08:00:00',strtotime($date)),date('Y-m-d 08:00:00',strtotime($date)+86400)]],
            '类别' => ['in',['IPQC检验','机台检验']],
            'UniqId' => ['>',$startId],
        ];
        $begin = Db::table('制程检验_记录')->where($where)->field('UniqId')->find();
        $end = Db::table('制程检验_记录')->where($where)->order('UniqId desc')->field('UniqId')->find();
        $where['UniqId'] = ['between',[$begin['UniqId'],$end['UniqId']+1]];
        //检验项目筛选
        $itemA = Db::table('制程检验_记录')->where($where)->distinct(true)->where('班组编号','A班')->column('rtrim(检验项目)');
        $itemB = Db::table('制程检验_记录')->where($where)->distinct(true)->where('班组编号','B班')->column('rtrim(检验项目)');
        //检验时间
        $InspectionTime = Db::table('制程检验_记录')->where($where)->distinct(true)->column('提交时间');
        foreach ($InspectionTime as $k=>$v){
            $InspectionTime[$k] = date('H:i',strtotime($v));
        }
        //检测记录详情
        $field = 'rtrim(工单编号) as 工单编号,rtrim(印件号) as 印件号,rtrim(工序名称) as 工序名称';
        $nameDetailA = Db::table('制程检验_记录')->where($where)->field($field)->where('班组编号','A班')->find();
        $nameDetailB = Db::table('制程检验_记录')->where($where)->field($field)->where('班组编号','B班')->find();
        $list = $data1 = $data2 = [];
        //A班检测数据
        foreach ($itemA as $key=>$value){
            $SubmissionTime = Db::table('制程检验_记录')->where($where)
                ->where('班组编号','A班')
                ->where('检验项目',$value)
                ->where('检验结果','合格')
                ->field('rtrim(提交时间) as 提交时间')
                ->select();
            $time = [];
            foreach ($SubmissionTime as $k=>$v){
                $time[$k] = date('H:i',strtotime($v['提交时间']));
            }
            $data1[$key] = [
                '工单编号' => $nameDetailA['工单编号'],
                '印件号' => $nameDetailA['印件号'],
                '工序名称' => $nameDetailA['工序名称'],
                '检验项目' => $value,
                'inspectresult' => implode(',',$time),
            ];
        }
        //B班数据详情
        foreach ($itemB as $key=>$value){
            $SubmissionTime = Db::table('制程检验_记录')->where($where)
                ->where('班组编号','B班')
                ->where('检验项目',$value)
                ->where('检验结果','合格')
                ->field('rtrim(提交时间) as 提交时间')
                ->select();
            $time = [];
            foreach ($SubmissionTime as $k=>$v){
                $time[$k] = date('H:i',strtotime($v['提交时间']));
            }
            $data2[$key] = [
                '工单编号' => $nameDetailB['工单编号'],
                '印件号' => $nameDetailB['印件号'],
                '工序名称' => $nameDetailB['工序名称'],
                '检验项目' => $value,
                'inspectresult' => implode(',',$time),
            ];
        }
        $list = array_merge($data2,$data1);
        $list['inspectiontime'] = $InspectionTime;
        $this->success('成功',$list);
    }

    //生产中工单信息
    public function Production()
    {
        if ($this->request->isGet() === false){
            $this->error('请求错误');
        }
        $machine = input('machine');
        if (empty($machine)){
            $this->error('参数错误');
        }
        $nowTime = date('Y-m-d H:i:s',time());
        $where = [
            'Gy0_sbbh' => $machine,
            'Gy0_sj1' => ['<',$nowTime],
            'Gy0_sj2' => ['>',$nowTime],
        ];
//        $field = 'rtrim(Gy0_gdbh) as 工单编号,rtrim(Gy0_yjno) as 印件编号,rtrim(Gy0_gxh) as gxh,rtrim(Gy0_gxmc) as gxmc,rtrim(Ass_gxmc) as add,'
    }
}