<?php
namespace app\adminVue\controller;

use app\BaseController;
use think\facade\Db;
use think\facade\Cache;
use think\facade\Session;
use think\Request;
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

class MeGet extends TokenCheck
{   
    // 获取ATBU工作计划列表
    public function getPlanningList(){
        $obj = Db::name('me_work_order')->where('status','>',0);
        if(input('?get.type')){
            $obj = $obj->where('type',input('get.type'));
        }
        $data = $obj->where('status',input('get.status'))->pages(input('get.limit'));
        $info = Db::name('me_base')->where('mid',16)->column('content','title');
        $aid_info = Db::name('admin_user')->where('status',1)->column('truename','id');
        $project_info = Db::name('team_base')->where('mid','<',4)->column('title','id');
        foreach ($data['lists'] as $k => $v) {
            $data['lists'][$k]['type'] = $info[$v['type']];
            $data['lists'][$k]['owner_name'] = $aid_info[$v['creator']];
            $data['lists'][$k]['create_time'] = date('Y-m-d',$v['create_time']);
            $data['lists'][$k]['need_date'] = date('Y-m-d',$v['need_date']);
            $data['lists'][$k]['set_date'] = date('Y-m-d',$v['create_time']);
            $data['lists'][$k]['project'] = $v['project']>0?$project_info[$v['project']]:'';
            $data['lists'][$k]['line'] = $v['line']>0?$project_info[$v['line']]:'';
            $data['lists'][$k]['family'] = $v['family']>0?$project_info[$v['family']]:'';
        }
        exit($this->lay_table($data));
    }
    //获取保养清单
    public function getMeCareList(){
        $obj = Db::name('me_care_list')->where('status',1);
        if(input('?get.type')){
            $obj = $obj->where('type_name',input('get.type'));
        }
        $data = $obj->pages(input('get.limit'));
        exit($this->lay_table($data));
    }
    //获取保养设备类型清单
    public function getCareTypeList(){
        $list = Db::name('me_care_list')->where('status',1)->column('type_name');
        $data = array_unique($list);
        exit(json_encode(array('code'=>0,'data'=>array_values($data))));
    }
    //获取保养设备类型清单
    public function getMachineList(){
        $item = input('get.');
        $obj = Db::name('me_machine_list')->where('status',1);
		if(isset($item['line'])&&$item['line']>0){
			$obj = $obj->where('line',$item['line']);
		}
        if($item['view']==2){
			$obj = $obj->where('change_type','>',0);
		}
		if(isset($item['type'])&&$item['type']>0){
			$type = Db::name('me_base')->where(array('mid'=>2,'mark'=>$item['type']))->column('id');
			$obj = $obj->whereIn('type',$type);
		}
		if(isset($item['kw'])&&$item['kw']!==''){
			$obj = $obj->where('fixed_number|m_name','like','%'.$item['kw'].'%');
		}
		$data = $obj->order('id desc')->pages($item['limit']);
		$info = Db::name('team_base')->where('mid','<',3)->column('title','id');
		$type_info = Db::name('me_base')->where('mid',2)->column('title','id');
		$aid_info = Db::name('admin_user')->cache('adminName',600)->column('truename','id');
		$tie_info = Db::name('me_tie_detail')->where('status',1)->cates('m_id');
		foreach ($data['lists'] as $k => $v) {
			$data['lists'][$k]['project_name'] = $v['project']>0?$info[$v['project']]:'';
			$data['lists'][$k]['line_name'] = $v['line']>0?$info[$v['line']]:'';
			$data['lists'][$k]['type_name'] = $type_info[$v['type']];
			$data['lists'][$k]['owner'] = $aid_info[$v['owner']];
		}
        exit($this->lay_table($data));
    }
    //获取保养设备类型清单
    public function machineListExport(){
		$data = Db::name('me_machine_list')->where('status',1)->order('id desc')->lists();
		$info = Db::name('team_base')->where('mid','<',3)->column('title','id');
		$type_info = Db::name('me_base')->where('mid',2)->column('title','id');
		$aid_info = Db::name('admin_user')->cache('adminName',600)->column('truename','id');
		$tie_info = Db::name('me_tie_detail')->where('status',1)->cates('m_id');
		foreach ($data as $k => $v) {
            $list[$k]['序号'] = $v['id'];
            $list[$k]['设备名称'] = $v['m_name'];
            $list[$k]['设备类型'] = $type_info[$v['type']];
            $list[$k]['固定资产号'] = $v['fixed_number'];
            $list[$k]['区域'] = $v['project']>0?$info[$v['project']]:'';
            $list[$k]['产线'] = $v['project']>0?$info[$v['line']]:'';
            $list[$k]['变更类型'] = $v['change_type']==0?'NA':($v['change_type']==1?'新设备':($v['change_type']==2?'替代设备':'偏差放行'));
            $list[$k]['可否报修'] = $v['is_alarm']==1?'是':'否';
            $list[$k]['是否保养'] = $v['is_care']==1?'是':'否';
            $list[$k]['更新人'] = $aid_info[$v['owner']];
            $list[$k]['更新日期'] = date('Y-m-d',$v['update']);

		}
        exit(json_encode(array('code'=>0,'data'=>$list)));
    }  
    //获取保养设备类型清单
    public function getMachineTypeList(){
        $item = input('get.');
        $obj = Db::name('me_base')->where(['mid'=>2,'status'=>1]);
		if(isset($item['mark'])&&$item['mark']>0){
			$obj = $obj->where('mark',$item['mark']);
		}
		$data = $obj->pages($item['limit']);
        $type_info = Db::name('me_base')->where('mid',1)->column('title','id');
        foreach ($data['lists'] as $k => $v) {
			$data['lists'][$k]['type_name'] = $type_info[$v['mark']];
		}
        exit($this->lay_table($data));
    }

    
}