public function processAPI()
{
if ($this->sqlInjection($_SERVER['REQUEST_URI'])) {
$log = new Logging();
$log->lfile('/var/www/web1162/html/tankUp/log_error.txt');
$log->lwrite("SQL_Injection?: " . $_SERVER['REQUEST_URI']);
$log->lclose();
return $this->_response("Unexpected Parameters", 400);
}
if ((int) method_exists($this, $this->endpoint) > 0) {
return $this->_response($this->{$this->endpoint}($this->args));
}
return $this->_response("No Endpoint: {$this->endpoint}", 404);
}
public function GetDataByCoords($article, $distance, $sortBy, location $coords)
{
try {
$log = new Logging();
$log->lfile('/var/www/web1162/html/tankUp/log_debug.txt');
$log->lwrite($article . $distance . $sortBy . $coords->latitude . $coords->longitude);
$log->lclose();
$param = new GetDataByCoordsRequest($article, $distance, $coords, $sortBy);
$response = $this->__construct()->__soapCall("getDataByCoords", array($param));
return $response->petrolStation;
} catch (Exception $e) {
// Umwandlung Soap-Exception zu HTTP
return $e;
}
}
public function run()
{
$log = new Logging();
// $parenClass = new ParentClass();
// set path and name of log file (optional)
$log->lfile('log.txt');
$json = file_get_contents('php://input');
$log->lwrite("post: " . $json);
$update = new Update($json);
$message = $update->getMessage();
$chat = $message->getChat();
$chat_id = $chat->getId();
$text = $message->getText();
$client = new Client();
$client->sendMessage($chat_id, $text, null, null, null);
$client->sendLocation($chat_id, 53.480759, -2.242631, null, null);
$client->sendPhoto($chat_id, 'pic.jpg', 'sweety', null, null);
$log->lclose();
}
private function GetTownByCoords(location $loc)
{
$town = null;
// TODO Fehler
$db_id = mysql_connect("localhost", "web1162", "bX2KARTc");
if (!$db_id) {
die("Verbindungsaufbau ist gescheitert");
}
try {
$arg2 = $loc->latitude;
$arg1 = $loc->longitude;
$log = new Logging();
$log->lfile('/var/www/web1162/html/tankUp/log_debug.txt');
$log->lwrite("FuelApi_v2: " . $arg2);
$log->lclose();
} catch (Exception $ex) {
return new Exception("Server", "Error converting location : " . $ex);
}
// mysql_query("use usr_web_1162_4");
$db_sel = mysql_select_db("usr_web1162_4", $db_id);
if (!$db_sel) {
die('Kann Datenbank nicht benutzen : ' . mysql_error());
}
mysql_query("SET names 'utf8'");
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $db_id);
$locRecords = mysql_query("SELECT data.loc_id as id, data.text_val as ort, ACOS( SIN( RADIANS( src.lat ) ) * SIN( RADIANS( '{$arg2}' ) ) + COS( RADIANS( src.lat ) ) * COS( RADIANS( '{$arg2}' ) ) * COS( RADIANS( src.lon ) - RADIANS( '{$arg1}' ) ) ) *6380 AS distance\n\t\t\t\t\t\t\t\t\t\t\t FROM geodb_coordinates src, geodb_textdata data\n\t\t\t\t\t\t\t\t\t\t\t WHERE src.lat > '{$arg2}' - 0.4\n\t\t\t\t\t\t\t\t\t\t\t AND src.lat < '{$arg2}' + 0.4\n\t\t\t\t\t\t\t\t\t\t\t AND src.lon > '{$arg1}' - 0.4\n\t\t\t\t\t\t\t\t\t\t\t AND src.lon < '{$arg1}' + 0.4\n\t\t\t\t\t\t\t\t\t\t\t AND data.loc_id = src.loc_id\n\t\t\t\t\t\t\t\t\t\t\t AND data.text_type = 500100000\n\t\t\t\t\t\t\t\t\t\t\t HAVING distance <5\n\t\t\t\t\t\t\t\t\t\t\t ORDER BY distance asc\n\t\t\t\t\t\t\t\t\t\t\t LIMIT 1");
if (mysql_num_rows($locRecords) >= 1) {
while ($aktZeile = mysql_fetch_assoc($locRecords)) {
$town = $aktZeile['ort'];
break;
}
}
return $town;
}
function getDataByCoord($params)
{
$lat;
$lon;
$art;
$umkreis;
$sortieren;
try {
$lat = $params->getParam(0)->scalarval();
$lon = $params->getParam(1)->scalarval();
$art = $params->getParam(2)->scalarval();
$umkreis = $params->getParam(3)->scalarval();
$sortieren = $params->getParam(4)->scalarval();
} catch (Exception $fault) {
return new Exception("Server", "Error converting params getDataByCoords : " . $fault);
}
if ($log == null) {
$log = new Logging();
}
$log->lfile('log_info.txt');
$log->lwrite("Aufruf getDataByCoord mit Artikel " . $art . " , Umkreis: " . $umkreis . " , Sortieren nach: " . $sortieren . " , Long: " . $lon . " , Lat: " . $lat . ".");
$log->lclose();
$db_id = mysql_connect("localhost", "web1162", "bX2KARTc");
if (!$db_id) {
die("Verbindungsaufbau ist gescheitert");
}
$db_sel = mysql_select_db("usr_web1162_3", $db_id);
if (!$db_sel) {
die('Kann Datenbank nicht benutzen : ' . mysql_error());
}
mysql_query("SET names 'utf8'");
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $db_id);
try {
$priceRecords = null;
$basequery = "select distinct TIME_FORMAT(ot.startTimeOfPeriod,'%H:%i') as ab, TIME_FORMAT(ot.endTimeOfPeriod,'%H:%i') as bis,\n \t\t\t\t\t\t\t\t\t\t\t\t\t(select CASE WHEN CURRENT_TIME BETWEEN ot.startTimeOfPeriod\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND ot.endTimeOfPeriod\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tthen 1\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\telse 0\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tend\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) as open,\n \t\t\t\t\t\t\t\t\t\t\t\t\t" . $art . " , a.id, a.petrolStationBrand, a.petrolStationStreet, a.petrolStationHouseNumber, a.petrolStationPostcode, a.petrolStationPlace, a.petrolStationVersionTime, a.longitude as AnbietGPSLaenge, a.latitude as AnbietGPSBreite, ACOS( SIN( RADIANS( a.latitude ) ) * SIN( RADIANS( '{$lat}' ) ) + COS( RADIANS( a.latitude ) ) * COS( RADIANS( '{$lat}' ) ) * COS( RADIANS( a.longitude ) - RADIANS( '{$lon}' ) ) ) *6380 AS 'distance'\n\t\t\t\t\t\t\t\t\t\t \n\t \t\t\t\t\t\t\t\t\t\t\t\t\tfrom ( select Max(`version`) as newest \n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfrom `fuelPrice` \n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tgroup by `id` ) plNewest, \n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t`fuelPrice` pl, `petrolStation` a, `openingTimes` ot\n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\twhere a.latitude > '{$lat}' - 0.4\n\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\tAND a.latitude < '{$lat}' + 0.4\n\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\tAND a.longitude > '{$lon}' - 0.4\n\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\tAND a.longitude < '{$lon}' + 0.4\n\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\tand pl.`version` = plNewest.newest\n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand a.`id` = pl.`id` \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand ot.applicableDay = (SELECT DAYNAME( CURDATE( ) ) )\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand ot.fid = a.id\n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand " . $art . " > 0 \t\n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\thaving distance < '{$umkreis}' ";
if (strpos($sortieren, 'preis') !== false) {
$priceRecords = mysql_query($basequery . " order by {$art}, distance limit 7");
} else {
if (strpos($sortieren, 'distanz') !== false) {
$priceRecords = mysql_query($basequery . " order by distance limit 7");
}
}
if (mysql_num_rows($priceRecords) >= 1) {
$petrolStationList = array();
/* Tankstelle ermitteln */
while ($aktZeile = mysql_fetch_assoc($priceRecords)) {
$location = new location($aktZeile['AnbietGPSBreite'], $aktZeile['AnbietGPSLaenge']);
$address = new address($aktZeile['petrolStationStreet'], $aktZeile['petrolStationHouseNumber'], $aktZeile['petrolStationPostcode'], $aktZeile['petrolStationPlace']);
$petrolStation = new petrolStation($aktZeile['id'], $aktZeile['petrolStationBrand'], $aktZeile['open'], $aktZeile['ab'], $aktZeile['bis'], $location, $aktZeile[$art], $address, $aktZeile['petrolStationVersionTime'], $aktZeile['distance']);
array_push($petrolStationList, $petrolStation);
}
} else {
echo "Keine Ergebnisse";
}
} catch (SoapFault $fault) {
return new SoapFault("Server", "Error reading town by coord. " . $fault);
}
$petrolStationArray = array();
// $petrolStationList.count
$count = 0;
$resp = new jsonrpcresp(new jsonrpcval("no data", 'string'));
if ($petrolStationList != null) {
foreach ($petrolStationList as $station) {
$petrolStation = array('owner' => new jsonrpcval(umlaute_ersetzen($station->owner), 'string'), 'isOpen' => new jsonrpcval($station->isOpen, 'boolean'), 'openFrom' => new jsonrpcval($station->openFrom . "", 'string'), 'openTo' => new jsonrpcval($station->openTo . "", 'string'), 'longitude' => new jsonrpcval($station->location->longitude, 'double'), 'latitude' => new jsonrpcval($station->location->latitude, 'double'), 'price' => new jsonrpcval($station->price, 'string'), 'street' => new jsonrpcval(umlaute_ersetzen($station->address->street), 'string'), 'housenumber' => new jsonrpcval($station->address->housenumber, 'string'), 'postal' => new jsonrpcval($station->address->postal, 'string'), 'place' => new jsonrpcval(umlaute_ersetzen($station->address->place), 'string'), 'reporttime' => new jsonrpcval($station->reporttime . "", 'string'), 'distance' => new jsonrpcval($station->distance, 'double'), 'id' => new jsonrpcval($station->id, 'double'));
array_push($petrolStationArray, new jsonrpcval($petrolStation, 'struct'));
$count += 1;
}
$resp = new jsonrpcresp(new jsonrpcval($petrolStationArray, 'struct'));
$resp->content_type = "text/json; charset=iso-8859-1";
//$resp->serialize('UTF-8');
}
return $resp;
}
zway_switch_set($ch, $unit, $zway_dev[$i]['gui_old']);
// Set back to the old value
$zway_dev[$i]['gui_inValid'] = 0;
$log->lwrite("ERROR: Switch corrected:: " . $zway_dev[$i]['name'] . " gui_old: " . $zway_dev[$i]['gui_old'] . ", gui_val: " . $gui_val . ", zway_val: " . $zway_val, 0);
}
}
}
}
break;
case "sensor":
$log->lwrite("\tSensor for device id: " . $i . " not yet implemented, zway id: " . $unit, 2);
break;
case "thermostat":
$log->lwrite("\tThermostat for device id: " . $i . " not yet implemented, sway id: " . $unit, 2);
break;
default:
$log->lwrite("\tZway unknown type: " . $dev_config[$i]['type'], 1);
}
// switch
// Print the status
$log->lwrite("device: " . $dev_config[$i]['name'] . ", unit: " . $unit . ": gui old: " . $zway_dev[$i]['gui_old'] . ", gui val: " . $gui_val . ", zway val: " . $zway_val . ", inValid: " . $zway_dev[$i]['gui_inValid'], 2);
} else {
}
// brand==ZWAVE
}
// for
}
// while
$log->lwrite("Closing LamPI-gate");
$log->lclose();
flush();
function getDataByCoordsRPC(GetDataByCoordsRequest $reqt)
{
$response = null;
$lat;
$lon;
$art;
$umkreis;
$sortieren;
try {
$loc = $reqt->location;
$lat = $loc->latitude;
$lon = $loc->longitude;
$art = $reqt->article;
$umkreis = $reqt->distance;
$sortieren = $reqt->sortBy;
} catch (SoapFault $fault) {
return new SoapFault("Server", "Error converting GetDataByCoordsRequest : " . $fault);
}
if ($log == null) {
$log = new Logging();
}
$log->lfile('/var/www/web1162/html/tankUp/log_debug.txt');
$log->lwrite("Aufruf getDataByCoord mit Artikel " . $reqt->article . " , Umkreis: " . $reqt->distance . " , Sortieren nach: " . $reqt->sortBy . " , Long: " . $lon . " , Lat: " . $lat . ".");
$log->lclose();
$db_id = mysql_connect("localhost", "web1162", "bX2KARTc");
if (!$db_id) {
die("Verbindungsaufbau ist gescheitert");
}
// mysql_query("use usr_web_1162_3");
$db_sel = mysql_select_db("usr_web1162_3", $db_id);
if (!$db_sel) {
// close log file
$log->lclose();
die('Kann Datenbank nicht benutzen : ' . mysql_error());
}
mysql_query("SET names 'utf8'");
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $db_id);
try {
$priceRecords = null;
$basequery = "select distinct TIME_FORMAT(ot.startTimeOfPeriod,'%H:%i') as ab, TIME_FORMAT(ot.endTimeOfPeriod,'%H:%i') as bis,\n \t\t\t\t\t\t\t\t\t\t\t\t\t(select CASE WHEN CURRENT_TIME BETWEEN ot.startTimeOfPeriod\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND ot.endTimeOfPeriod\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tthen 1\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\telse 0\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tend\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) as open,\n \t\t\t\t\t\t\t\t\t\t\t\t\t" . $art . " , a.id, a.petrolStationBrand, a.petrolStationStreet, a.petrolStationHouseNumber, a.petrolStationPostcode, a.petrolStationPlace, a.petrolStationVersionTime, a.longitude as AnbietGPSLaenge, a.latitude as AnbietGPSBreite, ACOS( SIN( RADIANS( a.latitude ) ) * SIN( RADIANS( '{$lat}' ) ) + COS( RADIANS( a.latitude ) ) * COS( RADIANS( '{$lat}' ) ) * COS( RADIANS( a.longitude ) - RADIANS( '{$lon}' ) ) ) *6380 AS 'distance'\n\t\t\t\t\t\t\t\t\t\t \n\t \t\t\t\t\t\t\t\t\t\t\t\t\tfrom ( select Max(`version`) as newest \n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfrom `fuelPrice` \n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tgroup by `id` ) plNewest, \n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t`fuelPrice` pl, `petrolStation` a, `openingTimes` ot\n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\twhere a.latitude > '{$lat}' - 0.4\n\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\tAND a.latitude < '{$lat}' + 0.4\n\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\tAND a.longitude > '{$lon}' - 0.4\n\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\tAND a.longitude < '{$lon}' + 0.4\n\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\tand pl.`version` = plNewest.newest\n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand a.`id` = pl.`id` \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand ot.applicableDay = (SELECT DAYNAME( CURDATE( ) ) )\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand ot.fid = a.id\n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand " . $art . " > 0 \t\n\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\thaving distance < '{$umkreis}' ";
if (strpos($sortieren, 'preis') !== false) {
$priceRecords = mysql_query($basequery . " order by {$art}, distance limit 7");
} else {
if (strpos($sortieren, 'distanz') !== false) {
$priceRecords = mysql_query($basequery . " order by distance limit 7");
} else {
$priceRecords = mysql_query($basequery . " order by distance limit 7");
}
}
$petrolStationList = array();
if (mysql_num_rows($priceRecords) >= 1) {
/* Tankstelle ermitteln */
while ($aktZeile = mysql_fetch_assoc($priceRecords)) {
$location = new location($aktZeile['AnbietGPSBreite'], $aktZeile['AnbietGPSLaenge']);
$address = new address($aktZeile['petrolStationStreet'], $aktZeile['petrolStationHouseNumber'], $aktZeile['petrolStationPostcode'], $aktZeile['petrolStationPlace']);
$petrolStation = new petrolStation($aktZeile['id'], $aktZeile['petrolStationBrand'], $aktZeile['open'], $aktZeile['ab'], $aktZeile['bis'], $location, $aktZeile[$art], $address, $aktZeile['petrolStationVersionTime'], $aktZeile['distance']);
array_push($petrolStationList, $petrolStation);
}
}
} catch (SoapFault $fault) {
return new SoapFault("Server", "Error reading town by coord. " . $fault);
}
return new GetDataByCoordsResponse($petrolStationList);
}
<?php
/* Includes */
include 'engine/genericFTPEngine.php';
include 'adapters/genericProductsAdapter.php';
include 'core/logging.php';
/* turn off the maximum execution time */
ini_set('MAX_EXECUTION_TIME', -1);
/* file name construction preamble */
$priceFile = 'pricefile.xml';
$remotePriceFile = $priceFile . '.zip';
$localPriceFile = 'downloads/' . $priceFile;
/* instantiate logger */
$logger = new Logging();
$logger->lwrite('Integration Job at ' . date("Ymd") . ' BEGIN');
/* connect and fetch file logic */
$engine = new GenericFTPEngine($logger);
$engine->connect();
$engine->fetch($remotePriceFile, null);
$xml = $engine->load($localPriceFile);
$integration = new GenericProductsAdapter($logger);
$integration->process($xml);
/* clean up */
$logger->lwrite('Integration Job END');
$logger->lclose();
public function getAllTowns()
{
require_once 'Logging.php';
include 'db_connect.php';
date_default_timezone_set('GMT');
$query = "SELECT town_name, country from town ORDER BY town_name";
$date = date('Y-m-d H:i:s');
/* Create Log file */
fopen("c:\nmpp\\htdocs\\weather\\automated\\log\\yahoo-api-download.txt", "w");
// Logging class initialization
$log = new Logging();
// set path and name of log file (optional)
$log->lfile('c:\\xampp\\htdocs\\weather\\automated\\log\\yahoo-api-download.txt');
$log->lwrite('Script Started at: ' . $date);
if ($result = $dbcon->query($query)) {
/* fetch associative array */
while ($row = $result->fetch_assoc()) {
$town = $row['town_name'];
$country = 'UK';
echo $town . "\n";
$query = "https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20weather.forecast%20where%20woeid%20in%20(select%20woeid%20from%20geo.places(1)%20where%20text%3D%22" . rawurlencode($town) . "%2C%20" . $country . "%22)%20and%20u%20%3D%27c%27&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys";
$weatherfeed = file_get_contents($query);
$weatherfeed = json_decode($weatherfeed);
if ($weatherfeed->query->results == null || $weatherfeed->query->results->channel->location->city == "United Kingdom") {
$weatherfeed = null;
// write message to the log file
$log->lwrite('API Fail for Town: ' . $row['town_name']);
} else {
$request_date = new Datetime($weatherfeed->query->created);
$request_date = $request_date->format('Y-m-d H:i:s');
$fdate = new Datetime($weatherfeed->query->results->channel->item->forecast[0]->date);
$forecast_date = $fdate->format('Y-m-d');
$feed_url = $weatherfeed->query->results->channel->link;
$town = $weatherfeed->query->results->channel->location->city;
$postcode = null;
$min_temp = $weatherfeed->query->results->channel->item->forecast[0]->low;
$max_temp = $weatherfeed->query->results->channel->item->forecast[0]->high;
$avg_temp = $weatherfeed->query->results->channel->item->condition->temp;
$wind_dir = $weatherfeed->query->results->channel->wind->direction;
$conditions = $weatherfeed->query->results->channel->item->condition->text;
$source_id = 1;
$second_date = new Datetime($weatherfeed->query->results->channel->item->forecast[1]->date);
$second_date = $second_date->format('Y-m-d');
$second_mintemp = $weatherfeed->query->results->channel->item->forecast[1]->low;
$second_maxtemp = $weatherfeed->query->results->channel->item->forecast[1]->high;
$second_conditions = $weatherfeed->query->results->channel->item->forecast[1]->text;
$second_avg = $second_maxtemp / 2 + $second_mintemp / 2;
}
$presentforecast = "INSERT INTO weather_forecast (request_date, forecast_date, feed_url, town, postcode_prefix, min_temp, max_temp, avg_temp, wind_dir, conditions, source_id)\n\t\t\tVALUES ('{$request_date}', '{$forecast_date}', '{$feed_url}', '{$town}', '{$postcode}', '{$min_temp}', '{$max_temp}', '{$avg_temp}', '{$wind_dir}', '{$conditions}', '{$source_id}')";
$secondforecast = "INSERT INTO weather_forecast (request_date, forecast_date, feed_url, town, postcode_prefix, min_temp, max_temp, avg_temp, wind_dir, conditions, source_id)\n\t\t\tVALUES ('{$request_date}', '{$second_date}', '{$feed_url}', '{$town}', '{$postcode}', '{$second_mintemp}', '{$second_maxtemp}', '{$second_avg}', null, 'second_conditions', '{$source_id}')";
if ($dbcon->query($presentforecast) === TRUE) {
echo "New first created successfully \n";
if ($dbcon->query($secondforecast) === TRUE) {
echo "New second forecast created successfully \n\n";
} else {
echo "Error: \n" . $dbcon->error;
}
} else {
echo "Error: \n" . $dbcon->error;
}
}
$log->lwrite('Script Run on: ' . $date);
// close log file
$log->lclose();
$dbcon->close();
}
}
