USKYZHAF/Home/Controller/StatusDetailsController.class.php

<?php

namespace Home\Controller;

use Think\Controller;

class StatusDetailsController extends ComController
{

    public function getStatusDetailsList(){
        $Date=I();
//        print_r($Date);
        $phone=$Date['phone'];
        $company_code = $Date['company_code'];
        $status_type=$Date['status_type'];
        $transfer_type=$Date['transfer_type'];
        $dwtype=$Date['dwtype'];
        if (!empty($_SESSION['phone'])) {
            $phone = $_SESSION['phone'];
        }

        if (!isset($status_type)) {
            $res['msg'] = '操作失败，缺少重要参数';
            $res['flag'] = false;
            echo json_encode($res);
            exit();
        }


        if (!empty($company_code)){
            $device_list = $this->getDeviceCode($company_code);
        }else{
            $company_code1=M()->query("select owner_code from sp_owner_phone WHERE phone='".$phone."' GROUP BY owner_code limit 1");
            $company_code=$company_code1[0]['owner_code'];
            $device_list = $this->getDeviceCode($company_code);
        }

//        print_r($device_list);

        $where='';
        if (!empty($transfer_type)){
            $where.=" and b.transfer_type='".$transfer_type."' ";
        }

        if (!empty($dwtype)){
            $where.=" and b.dwtype='".$dwtype."' ";
        }

        switch ($status_type) {
            case '1':
                $data1=M()->query("select b.* from sp_v_device_status as a join sp_owner as b on a.device_id=b.owner_code  where a.device_status='离线' and a.device_id in(".$device_list.")".$where);
                $data2=M()->query("SELECT b.* FROM sp_devices_status AS a JOIN sp_owner AS b ON a.deviceid=b.owner_code WHERE b.dwtype=1 AND a.true_status in(75,300) AND b.company='".$company_code."' ".$where);
                break;
            case '2':
                $data1=M()->query("select b.* from sp_v_device_status as a join sp_owner as b on a.device_id=b.owner_code  where a.device_status='在线' and a.device_id in(".$device_list.")".$where);
                $data2=M()->query("SELECT b.* FROM sp_devices_status AS a JOIN sp_owner AS b ON a.deviceid=b.owner_code WHERE b.dwtype=1 AND a.true_status='0' AND b.company='".$company_code."' ".$where);
                break;
            default:
                $res['msg'] = '操作失败，系统中尚未定义该类型';
                $res['flag'] = false;
                echo json_encode($res);
                exit();
                break;
        }
        $data = array_merge($data1,$data2);
        $res['company_code'] = $company_code;
        $res['msg'] = '操作成功';
        $res['flag'] = true;
        $res['data'] = $data;
        echo json_encode($res);
    }

}