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); } }