fetch_assoc()) { $list[] = $row; } mysqli_free_result($res1); mysqli_close($link); return $list; } function insert_187_jdxf($sql) { $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'jdxf', 3306); mysqli_query($link, "set character set 'utf8'"); $res1 = mysqli_query($link, $sql); mysqli_close($link); return $res1; } function query_187_ytapi($sql) { $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytapi', 3306); mysqli_query($link, "set character set 'utf8'"); $res1 = mysqli_query($link, $sql); if ($res1 == FALSE) { return $list = null; } $list = array(); while ($row = $res1->fetch_assoc()) { $list[] = $row; } mysqli_free_result($res1); mysqli_close($link); return $list; } function insert_187_ytapi($sql) { $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytapi', 3306); mysqli_query($link, "set character set 'utf8'"); $res1 = mysqli_query($link, $sql); mysqli_close($link); return $res1; } function query_187_ytIoT($sql) { $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytIoT', 3306); mysqli_query($link, "set character set 'utf8'"); $res1 = mysqli_query($link, $sql); if ($res1 == FALSE) { return $list = null; } $list = array(); while ($row = $res1->fetch_assoc()) { $list[] = $row; } mysqli_free_result($res1); mysqli_close($link); return $list; } function insert_187_ytIoT($sql) { $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytIoT', 3306); mysqli_query($link, "set character set 'utf8'"); $res1 = mysqli_query($link, $sql); mysqli_close($link); return $res1; } function http_post_advertise($url, $data) { //封装curl方法 $ch = curl_init(); //初始化 curl_setopt($ch, CURLOPT_URL, $url); //请求地址 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, true); //https协议需要以下两行,否则请求不成功 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); //post方法所需要的参数 curl_setopt($ch, CURLOPT_POSTFIELDS, $data); // curl_setopt($ch, CURLOPT_HTTPHEADER,array()); $result = curl_exec($ch); curl_close($ch); return $result; //返回所获取的方法 } function ytapi187_query($sql) { $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytapi', 3306); mysqli_query($link, "set character set 'utf8'"); $res1 = mysqli_query($link, $sql); if ($res1 == FALSE) { return $list = null; } $list = array(); while ($row = $res1->fetch_assoc()) { $list[] = $row; } mysqli_free_result($res1); mysqli_close($link); return $list; } function ytapi187_inset($sql) { $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytapi', 3306); mysqli_query($link, "set character set 'utf8'"); $res1 = mysqli_query($link, $sql); mysqli_close($link); return $res1; } function addtable($device_id, $deviceType) { if ($deviceType == 'Smoke') { $device_table = "sp_" . "y" . $device_id; $create_sql = " CREATE TABLE `" . $device_table . "` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `device_id` varchar(200) DEFAULT NULL, `RSRQ` varchar(255) DEFAULT NULL, `CSQ` varchar(255) DEFAULT NULL, `DeviceType` varchar(50) DEFAULT NULL, `DeviceStatus` varchar(50) DEFAULT NULL, `BatteryLevel` varchar(50) DEFAULT NULL, `SensorLevel` varchar(50) DEFAULT NULL, `eventTime` varchar(50) DEFAULT NULL, `storeTime` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; "; } else { $device_table = "sp_d" . $device_id; $create_sql = " CREATE TABLE `" . $device_table . "` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `device_code` varchar(30) DEFAULT NULL, `port` varchar(55) DEFAULT NULL, `time` datetime DEFAULT '2012-01-01', `status` varchar(50) DEFAULT NULL, `address` varchar(50) DEFAULT NULL, `ncmd` varchar(50) DEFAULT NULL, `data1` varchar(50) DEFAULT NULL, `data2` varchar(255) DEFAULT NULL, `data3` varchar(255) DEFAULT NULL, `data4` varchar(255) DEFAULT NULL, `data5` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; "; } return $create_sql; } //function sql_exec($sql){ // $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'jdxf', 3306); // mysqli_query($link,"set character set 'utf8'"); // mysqli_query($link,$sql); // mysqli_close($link); //} function owner($device_id) { $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'jdxf', 3306); mysqli_query($link, "set character set 'utf8'"); $sql = "SELECT company,louyu,unitinfo FROM sp_owner WHERE owner_code = '$device_id'"; $res1 = mysqli_query($link, $sql); $row = $res1->fetch_assoc(); mysqli_free_result($res1); mysqli_close($link); return $row; } function gettoken() { if (file_exists("./token.json")) { $token = json_decode(file_get_contents('./token.json'), true); if ($token['token_time_out'] >= time()) { return json_encode($token); } else { return refreshtoken(); } } else { return Auth(); } } function gettoken1() { if (file_exists("./token1.json")) { $token = json_decode(file_get_contents('./token1.json'), true); if ($token['token_time_out'] >= time()) { return json_encode($token); } else { return refreshtoken1(); } } else { return Auth1(); } } function Auth() { $data = "appId=wvdOfp7JVe0ULwnFKwBF0edfbcAa&secret=Bihoe_rY9vebXMw6sFfpQy0jiRca"; $header = [ "Content-Type:application/x-www-form-urlencoded", ]; $rescurl = curl("https://device.api.ct10649.com:8743/iocm/app/sec/v1.1.0/login", $data, $header); // echo $rescurl; // exit(); // echo '第一'.$rescurl; if ($rescurl[0] == 200) { $res = json_decode($rescurl[1], true); $res["token_time_out"] = $res['expiresIn'] + time(); $res["refresh_token_time_out"] = time() + 86400 * 7; $result = json_encode($res); file_put_contents("./token.json", $result); return $result; } else { return $rescurl[1]; } } function Auth1() { $data = "appId=bIS92ndpAf_fhmPdLaNuTidbFfka&secret=NZMe1G42OdSmzlEuDpR_3ywKPhIa"; $header = [ "Content-Type:application/x-www-form-urlencoded", ]; $rescurl = curl("https://device.api.ct10649.com:8743/iocm/app/sec/v1.1.0/login", $data, $header); // echo $rescurl; // exit(); // echo '第一'.$rescurl; if ($rescurl[0] == 200) { $res = json_decode($rescurl[1], true); $res["token_time_out"] = $res['expiresIn'] + time(); $res["refresh_token_time_out"] = time() + 86400 * 7; $result = json_encode($res); file_put_contents("./token1.json", $result); return $result; } else { return $rescurl[1]; } } function refreshtoken() { $token = session("token"); if ($token["refresh_token_time_out"] >= time()) { $data = [ "appId" => "wvdOfp7JVe0ULwnFKwBF0edfbcAa", "secret" => "Bihoe_rY9vebXMw6sFfpQy0jiRca", "refreshToken" => $token["refreshToken"], ]; $header = [ "Content-Type:application/json", ]; $rescurl = curl("https://device.api.ct10649.com:8743/iocm/app/sec/v1.1.0/refreshToken", json_encode($data), $header); if ($rescurl[0] == 200) { $res = json_decode($rescurl[1], true); $res["token_time_out"] = time() + $res['expiresIn']; $res["refresh_token_time_out"] = time() + 86400 * 7; //session('token',$res);// $result = json_encode($res); file_put_contents("./token.json", $result); return $result; } else { return $rescurl[1]; } } else { return Auth(); } } function refreshtoken1() { $token = session("token"); if ($token["refresh_token_time_out"] >= time()) { $data = [ "appId" => "bIS92ndpAf_fhmPdLaNuTidbFfka", "secret" => "NZMe1G42OdSmzlEuDpR_3ywKPhIa", "refreshToken" => $token["refreshToken"], ]; $header = [ "Content-Type:application/json", ]; $rescurl = curl("https://device.api.ct10649.com:8743/iocm/app/sec/v1.1.0/refreshToken", json_encode($data), $header); if ($rescurl[0] == 200) { $res = json_decode($rescurl[1], true); $res["token_time_out"] = time() + $res['expiresIn']; $res["refresh_token_time_out"] = time() + 86400 * 7; //session('token',$res);// $result = json_encode($res); file_put_contents("./token1.json", $result); return $result; } else { return $rescurl[1]; } } else { return Auth1(); } } function curl($url, $data = '', $header = "", $method = "POST") { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); // curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 4); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); /* curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (compatible; MSIE 5.01; Windows NT 5.0)');*/ // curl_setopt($ch, CURLOPT_VERBOSE, 1); //debugģʽ curl_setopt($ch, CURLOPT_SSLCERT, "./server.crt"); curl_setopt($ch, CURLOPT_SSLCERTPASSWD, "IoM@1234"); curl_setopt($ch, CURLOPT_SSLKEY, "./server.key"); if ($method == "POST" || $method == "PUT" || $method == "DELETE") { curl_setopt($ch, CURLOPT_CUSTOMREQUEST, $method); curl_setopt($ch, CURLOPT_POSTFIELDS, $data); } curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $info = curl_exec($ch); $status = curl_getinfo($ch, CURLINFO_HTTP_CODE); if (curl_errno($ch)) { $infores = 'Errno' . curl_error($ch); } else { $infores = array($status, $info); } curl_close($ch); return $infores; } function http_post($url, $post, $timeout) { $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_POST, 1); curl_setopt($curl, CURLOPT_POSTFIELDS, $post); // curl_setopt($curl, CURLOPT_TIMEOUT, $timeout); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $output = curl_exec($curl); $code = curl_getinfo($curl, CURLINFO_HTTP_CODE); $errMsg = curl_multi_getcontent($curl); if (curl_errno($curl)) { $infores = 'Errno' . curl_error($curl); } else { $infores = array($code, $output); } curl_close($curl); return $infores; } function json_post($url, $data) { $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false); if (!$data) { return 'data is null'; } if (is_array($data)) { $data = json_encode($data); } curl_setopt($curl, CURLOPT_POST, 1); curl_setopt($curl, CURLOPT_POSTFIELDS, $data); curl_setopt($curl, CURLOPT_HEADER, 0); curl_setopt($curl, CURLOPT_HTTPHEADER, array( 'Content-Type: application/json; charset=utf-8', 'Content-Length:' . strlen($data), 'Cache-Control: no-cache', 'Pragma: no-cache' )); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $res = curl_exec($curl); $errorno = curl_errno($curl); if ($errorno) { return $errorno; } curl_close($curl); return $res; } function curl_get($url) { $header = array( 'Accept: application/json', ); $curl = curl_init(); //设置抓取的url curl_setopt($curl, CURLOPT_URL, $url); //设置头文件的信息作为数据流输出 curl_setopt($curl, CURLOPT_HEADER, 0); // 超时设置,以秒为单位 curl_setopt($curl, CURLOPT_TIMEOUT, 1); // 超时设置,以毫秒为单位 // curl_setopt($curl, CURLOPT_TIMEOUT_MS, 500); // 设置请求头 curl_setopt($curl, CURLOPT_HTTPHEADER, $header); //设置获取的信息以文件流的形式返回,而不是直接输出。 curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false); //执行命令 $data = curl_exec($curl); $errorno=curl_error($curl); // 显示错误信息 if ($errorno) { return $errorno; } curl_close($curl); return $data; } function array_column($arr2, $column_key) { $data = []; foreach ($arr2 as $key => $value) { $data[] = $value[$column_key]; } return $data; } function ytapi_query($sql){ $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytapi', 3306); mysqli_query($link,"set character set 'utf8'"); $res1 = mysqli_query($link,$sql); if($res1==FALSE){ return $list=null; } $list=array(); while ($row = $res1->fetch_assoc()) { $list[]=$row; } mysqli_free_result($res1); mysqli_close($link); return $list; }