$cleanspeed = explode(" ", $cleandesc[$speedkey]); $kvhdata[$index]['name'] = trim($cleanname[1]); $kvhdata[$index]['latitude'] = $cleancoords[1]; $kvhdata[$index]['longitude'] = $cleancoords[0]; $kvhdata[$index]['speed'] = $cleanspeed[3] * 1.852; $kvhdata[$index]['ipaddr'] = substr($cleanname[0], 0, -7); $kvhdata[$index]['id'] = substr($cleanid[2], 0, -3); $kvhdata[$index]['status'] = $cleanstatus; if ($statuscode[4] == 'In') { $kvhdata[$index]['statuscode'] = "40000"; } else { $kvhdata[$index]['statuscode'] = "40002"; } $kvhdata[$index]['notes'] = strip_tags($cleandesc[$hubkey]) . "<br />" . strip_tags($cleandesc[$speedkey]) . "<br />" . strip_tags($cleandesc[$notekey1]) . "<br />" . strip_tags($cleandesc[$notekey2]) . "<br />" . strip_tags($cleandesc[$notekey3]) . "<br />" . strip_tags($cleandesc[$notekey4]) . "<br />" . strip_tags($cleandesc[$notekey5]); $kvhdata[$index]['address'] = handleGeozone($link, substr($cleanid[2], 0, -3), $cleancoords[1], $cleancoords[0]); $kvhdata[$index]['heading'] = handleHeading($link, substr($cleanid[2], 0, -3), $cleancoords[1], $cleancoords[0]); $index++; } //Build Device and Location Insert Query $index = 0; $devices_in_feed = ""; foreach ($kvhdata as $data) { $insertquery[$index] = "INSERT INTO Device (accountID,deviceID,groupID,equipmentType,vehicleID,uniqueID,displayName,description,ipAddressCurrent,isActive,lastUpdateTime,lastInputState,notes) VALUES ('gtg','" . $data['id'] . "','kvh','netmodem','" . $data['name'] . "','" . $data['id'] . "','" . $data['name'] . "','" . $data['name'] . "','" . $data['ipaddr'] . "',1," . time() . "," . $data['statuscode'] . ",'" . $data['status'] . "<br />" . $data['notes'] . "') ON DUPLICATE KEY UPDATE groupID=VALUES(groupID),lastUpdateTime=VALUES(lastUpdateTime),ipAddressCurrent=VALUES(ipAddressCurrent),lastInputState=VALUES(lastInputState),notes=VALUES(notes);"; //$insertquery[$index] = "REPLACE INTO Device SET accountID='gtg',deviceID='".$data['id']."',groupID='kvh',equipmentType='netmodem',vehicleID='".$data['name']."',uniqueID='".$data['id']."',displayName='".$data['name']."',description='".$data['name']."',ipAddressCurrent='".$data['ipaddr']."',isActive=1,lastUpdateTime=".time().",lastInputState=".$data['statuscode'].",notes='".$data['status']."<br />".$data['notes']."';"; $index++; $insertquery[$index] = "REPLACE INTO EventData SET accountID='gtg',deviceID='" . $data['id'] . "',timestamp=" . time() . ",statusCode=61472,latitude=" . $data['latitude'] . ",longitude=" . $data['longitude'] . ",speedKPH=" . $data['speed'] . ",address='" . $data['address'] . "',heading=" . $data['heading'] . ";"; $index++; $insertquery[$index] = "REPLACE INTO EventData SET accountID='gtg',deviceID='" . $data['id'] . "',timestamp=" . time() . ",statusCode=" . $data['statuscode'] . ",rawData='" . $data['status'] . "';"; $index++; $devices_in_feed .= "'" . $data['id'] . "',"; }
$cleanspeed = explode(" ", $cleandesc[$speedkey]); $kvhdata[$index]['name'] = trim($cleanname[1]); $kvhdata[$index]['latitude'] = $cleancoords[1]; $kvhdata[$index]['longitude'] = $cleancoords[0]; $kvhdata[$index]['speed'] = $cleanspeed[3] * 1.852; $kvhdata[$index]['ipaddr'] = substr($cleanname[0], 0, -7); $kvhdata[$index]['id'] = substr($cleanid[2], 0, -3); $kvhdata[$index]['status'] = $cleanstatus; if ($statuscode[4] == 'In') { $kvhdata[$index]['statuscode'] = "40000"; } else { $kvhdata[$index]['statuscode'] = "40002"; } $kvhdata[$index]['notes'] = strip_tags($cleandesc[$hubkey]) . "<br />" . strip_tags($cleandesc[$speedkey]) . "<br />" . strip_tags($cleandesc[$notekey1]) . "<br />" . strip_tags($cleandesc[$notekey2]) . "<br />" . strip_tags($cleandesc[$notekey3]) . "<br />" . strip_tags($cleandesc[$notekey4]) . "<br />" . strip_tags($cleandesc[$notekey5]); $kvhdata[$index]['address'] = handleGeozone($link, strip_tags($cleanid[2]), $cleancoords[1], $cleancoords[0]); $kvhdata[$index]['heading'] = handleHeading($link, strip_tags($cleanid[2]), $cleancoords[1], $cleancoords[0]); $index++; } //Build Device and Location Insert Query $index = 0; print_r($kvhdata); foreach ($kvhdata as $data) { $insertquery[$index] = "INSERT INTO Device (accountID,deviceID,groupID,equipmentType,vehicleID,uniqueID,displayName,description,isActive,lastUpdateTime,lastInputState,notes) VALUES ('gtg','" . $data['id'] . "','kvh','netmodem','" . $data['name'] . "','" . $data['id'] . "','" . $data['name'] . "','" . $data['name'] . "',1," . time() . "," . $data['statuscode'] . ",'" . $data['status'] . "<br />" . $data['notes'] . "') ON DUPLICATE KEY UPDATE groupID=VALUES(groupID),lastUpdateTime=VALUES(lastUpdateTime),lastInputState=VALUES(lastInputState),notes=VALUES(notes);"; $index++; $insertquery[$index] = "REPLACE INTO EventData SET accountID='gtg',deviceID='" . $data['id'] . "',timestamp=" . time() . ",statusCode=61472,latitude=" . $data['latitude'] . ",longitude=" . $data['longitude'] . ",speedKPH=" . $data['speed'] . ",address='" . $data['address'] . "',heading=" . $data['heading'] . ";"; $index++; $insertquery[$index] = "REPLACE INTO EventData SET accountID='gtg',deviceID='" . $data['id'] . "',timestamp=" . time() . ",statusCode=" . $data['statuscode'] . ",rawData='" . $data['status'] . "';"; $index++; } //Perform Device and location Inserts //foreach($insertquery as $querytext)