printing_log($Data, $filename_log); //需要用到的参数 if (!empty($Data['IMEI'])) { $device_code = $Data['IMEI']; } else if (!empty($Data['IEMI'])) { $device_code = $Data['IEMI']; } $insert_id = $Data['insert_id']; $remarks = $Data['bz']; $time = $Data['time']; $evt_name = $Data['evt_name']; $evt = $Data['evt']; if (empty($insert_id) || empty($device_code)) { echo '缺少重要参数,请检查推送代码!'; exit(); } switch ($evt) { case 'LF01': $status = '声音报警'; $where = " AND data2 like '%9%'"; break; case 'LF03': $status = '电梯检修'; $where = " AND data2 like '%9%'"; break; case 'LF04': $status = '电梯检修恢复'; $where = " AND data2 like '%9%'"; break; case 'LF05': $status = '电梯故障'; $where = " AND data2 like '%9%'"; break; case 'LF0501': $status = '电梯异常停留'; $where = " AND data2 like '%9%'"; break; case 'LF0502': $status = '电梯异常开门'; $where = " AND data2 like '%9%'"; break; case 'LF0503': $status = '电梯异常关门'; $where = " AND data2 like '%9%'"; break; case 'LF0504': $status = '电梯异常走梯'; $where = " AND data2 like '%9%'"; break; case 'LF06': $status = '电梯故障恢复'; $where = " AND data2 like '%9%'"; break; default: $status = '其他' . $Data['Status']; $where = " AND data2 like '%9%'"; break; } if (!empty($evt_name)) { $status = $evt_name; $where = " AND data2 like '%9%'"; } $data = M()->query("select s.owner_name,s.unitinfo,s.company,c.owner_address from sp_owner s ,sp_owner_company c where s.company=c.owner_id and s.owner_code ='" . $device_code . "'"); $union_sql = M()->query("select phone from sp_owner_phone WHERE owner_code='" . $data[0]['company'] . "' " . $where . " union select phone from sp_owner_phone WHERE owner_code in (select other_code from sp_owner_fujin where owner_code='" . $data[0]['company'] . "') " . $where . " "); if (count($union_sql) == 0) { echo "phone is null"; exit; } $openids = $this->array_column1($union_sql, "phone"); if (empty($openids)) { echo 'open is null'; exit; } $status11 = M()->query("SELECT statustime FROM sp_devices_status where deviceid='" . $device_code . "'"); $op = M()->query("SELECT openid FROM sp_wx_customuser WHERE type='wx' and idphone in($openids)"); $access_token = GetAccess_Token1(); $address = '警报地址:' . $data[0]['owner_address'] . $data[0]['unitinfo']; $type = $status; //keyword3.DATA if (empty($time)) { $time = $status11[0]['statustime']; } //remark.DATA if (empty($remarks)) { $remarks = '设备名称:' . $data[0]['owner_name']; } $url = "https://iot.usky.cn/jdxf/wxapp2.php/Home/Fireinfo/index/type/17/id/" . $insert_id; foreach ($op as $o) { if (!empty($o['openid'])) { $R = $this->SendDeviceAlarm($access_token, $o['openid'], $address, $device_code, $type, $time, $remarks, $url); $filename_log = "/var/www/html/jdxf/log/elevator_t_log" . date("Y-m-d") . ".log"; $this->printing_log($R, $filename_log); print_r($R); } } } }