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();
}
<?php
require "logclass.php";
// Logging class initialization
$log = new Logging();
// set path and name of log file (optional)
$log->lfile('mylog.txt');
// write message to the log file
$log->lwrite('cron executed');
// close log file
$log->lclose();
mail("*****@*****.**", "testing cron", date("y-m-d h:i:s"));
require_once "GpsFix.php";
require_once "Staypoint.php";
require_once "request_tools.php";
require_once "Logging.php";
if (isset($_POST['createTrajectory'])) {
$min_time = $_POST["minTime"];
// In milliseconds
$max_time = $_POST["maxTime"];
// In milliseconds
$min_distance = $_POST["minDistance"];
// In meters
$time_zone = new DateTimeZone("America/Mexico_City");
$date_now = new DateTime("now", $time_zone);
$converted_date = $date_now->format('Y-m-d H:i:s');
$log = new Logging();
$log->lfile('logs/mylogTrajectory.txt');
$log->lwrite("fecha es: " . $converted_date);
insert_new_trajectory($converted_date, $converted_date, $min_distance, $min_time, $max_time);
echo "trajOk";
} else {
$last_trajectory = get_last_trajectory();
$min_time = $last_trajectory["minTime"];
$max_time = $last_trajectory["maxTime"];
$min_distance = $last_trajectory["minDistance"];
$ml = new MontoliouLive($min_time, $max_time, $min_distance);
if (!isset($_POST['lastPart'])) {
if (validate_fix_input()) {
$fix = GpsFix::create_fix_from_parameters();
$stay_point = $ml->process_fix($fix);
if ($stay_point != null) {
echo $stay_point;
1. Read a configuration from file
2. Store a configuration to file
3. List the skin files in config
NOTE:
Start initiating the database by executing: http://localhost/kaku/backend_sql.php?init=1
this will initialize the MySQL database as defined below in init_dbase()
====================================================================================== */
$debug = 1;
$time_now = time();
// Time NOW at this moment of calling
$time_start = $time_now - 24 * 60 * 60;
// Time a day ago
$log = new Logging();
$log->lfile($log_dir . '/zway_daemon.log');
$log->lwrite("\n\n---------------------------------- STARTING ZWAVE DAEMON -----------------------------------");
$apperr = "";
$appmsg = "";
// ----------------------------------------------------------------------------------------
// ZWAY_DUMP
//
// Default is to dump all devices. $dev is for later optional use
function zway_dump($ch, $dev)
{
global $time_start;
global $debug;
curl_setopt_array($ch, array(CURLOPT_URL => 'http://192.168.2.52:8083/ZWaveAPI/Data/' . $time_start, CURLOPT_RETURNTRANSFER => true));
$output = curl_exec($ch);
if ($output === false) {
if ($debug >= 2) {
$setTo = "leancode+" . time() . "@gmail.com";
echo $setSubject . "<br>";
// $setReturnPath = "*****@*****.**";
// $setFrom = $setReplyTo = $setSender = array('*****@*****.**' => 'OKTicK Search Ltd');
// foreach ( $setFrom as $fromAddress => $fromName);
}
// initialise the dkim
$privateKey = get_private_key();
// Generated one as the paired public key is set in DNS
$selector = 'default';
//$signer = Swift_Signers_DKIMSigner::newInstance($privateKey, $domain, $selector)
$signer = new Swift_Signers_DKIMSigner($privateKey, MAILHOST, $selector);
$signer->setBodyCanon('relaxed')->ignoreHeader('Return-Path')->setHeaderCanon('relaxed')->setHashAlgorithm('rsa-sha1');
// make sure we are on the right domain for the links in the message
$log = new Logging();
$log->lfile('/home/oktick-beta/email.log');
// set path and name of log file (optional)
/*
$log->lwrite("setReturnPath($setReturnPath)");
$log->lwrite("setSubject($setSubject)");
$log->lwrite("setFrom($fromAddress, $fromName)");
$log->lwrite("setTo($setTo)");
//$log->lwrite("setBody($html)");
//$log->lwrite("addPart($text)");
$log->lwrite("setId($setId)");
$log->lwrite("setReplyTo($setReplyTo)");
$log->lwrite("setSender($setSender)");
*/
// Create the message
$message = Swift_Message::newInstance()->setDate(time())->setReturnPath($setReturnPath)->setSubject($setSubject)->setFrom($setFrom)->setTo($setTo)->setBody($html, 'text/html')->addPart($text, 'text/plain')->setId($setId)->setReplyTo($setReplyTo)->setSender($setSender)->setPriority(3)->attachSigner($signer);
$mxs = get_mx_records_sorted($setTo);
$content .= '"Day ' . $arr['day'] . ': ' . ucfirst($arr['read']) . '",';
$content .= date_format($date, "m/d/Y") . ',';
$content .= 'true,';
$content .= '"READ: ' . ucfirst($arr['read']) . ' PRAY: ' . ucfirst($arr['meditation']);
if (array_key_exists('video', $arr)) {
$content .= ' WATCH: ' . ucfirst($arr['video']);
}
$content .= ' http://bible.sograce.org/#/' . $arr['day'] . '/1"';
return $content;
}
$jsonLocation = "../js/plan_tbp.json";
$milliseconds = round(microtime(true) * 1000);
$fileName = 'calendar_' . $milliseconds . '.csv';
//we'll just use the logging class, since i have it handy
$log = new Logging();
$log->lfile($fileName);
//read in the json
$string = file_get_contents($jsonLocation);
$json_a = json_decode($string, true);
//lets create th initial start date
$seedDate = date_create("2016-01-01");
//create the initial header file
$log->lwrite('Subject,Start Date,All Day Event,Description');
foreach ($json_a as $v) {
if (!empty($v)) {
$cLine = createCalendarLine($v, $seedDate);
$log->lwrite($cLine, false);
//increase date
date_add($seedDate, date_interval_create_from_date_string("1 day"));
}
}
if (!$con) {
die('Could not connect: ' . mysql_error());
}
$db = mysql_select_db("magento", $con);
if (!$db) {
echo "cant select database";
}
//************************ SET STATUS for API ***********************************//
// $apiMode = "live" or "test"
$apiMode = "test";
//******************************************************************************//
$config_info = parse_ini_file('/var/www/html/magento/paGateway/paGateway.ini', true);
include "/var/etl/bin/includes/logging.php";
// Logging class initialization
$log = new Logging();
$log->lfile('/var/log/paGateway/paGateway_test.log');
$log->lwrite("Script STARTED.\r\n");
//External script - Load magento framework
require_once "/var/www/html/magento/app/Mage.php";
Mage::app();
//construct paAPI class
require_once '/var/www/html/magento/paGateway/paAPI.php';
$paOrder = new paAPI();
$myOrder = Mage::getModel('sales/order');
// print_r($myOrder);
$orders = Mage::getModel('sales/mysql4_order_collection');
// print_r($orders);
$now = date('Y.m.d \\: h:m:s');
$to = $config_info['email']['to'];
$uid = $config_info['login']['uid'];
$pass = $config_info['login']['pass'];
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
// THE SOFTWARE.
//
// You should have received a copy of the GNU General Public License
// along with LamPI. If not, see <http://www.gnu.org/licenses/>.
//
//
$log = new Logging();
$logfile = '/home/pi/log/EnerPI.log';
$log->lfile($logfile);
$log->lwrite("Starting energy.php script. __ROOT__ is " . __ROOT__);
$apperr = "";
// Global Error. Just append something and it will be sent back
$appmsg = "";
// Application Message (returned from backend to Client)
$graphAction = "";
// Must be "graph" only initially
$graphType = "";
// T emperature, H umidity, P airPressure
$graphPeriod = "";
// 1d 1w 1m 1y
$graphSensors = array();
// List of sensor values we like to graph
// ----------------------------------------------------------------------------
// MAKE GRAPH
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);
}
$ret = 0;
set_time_limit(0);
// NO execution time limit imposed
ob_implicit_flush();
$log = new Logging();
// Logging class initialization, maybe init at declaration
$sensor = new Sensor();
// Weather Log
$queue = new Queue();
$sock = new Sock();
$dlist = new Device();
// Class for handling of device specific commands
$wthr = new Weather();
// Class for Weather handling in database
// set path and name of log file (optional)
$log->lfile($log_dir . '/LamPI-daemon.log');
$log->lwrite("-------------- STARTING DAEMON ----------------------");
sleep(2);
// Open the SQL handler to the mysql daemon
$pisql = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if ($pisql->connect_errno) {
$log->lwrite("LamPI-daemon:: Failed to connect to MySQL: (" . $pisql->connect_errno . ") " . $pisql->connect_error, 1);
exit(1);
}
// Some variables that are probably (re)set by get_parse();
$doinit = false;
$doreset = false;
$dofile = "";
// Parse the comamndline (starting) for commandparameters
// 1. Parse the URL sent by client (not working, but could restart itself later version)
// XXX Need to adapt get_parse to also read URL-like (should that be necessary)
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
include "/var/etl/bin/includes/logging.php";
include "/var/etl/bin/includes/functions.php";
// Logging class initialization
$log = new Logging();
$log->lfile('test.txt');
$log->lwrite("Script STARTED.\r\n");
$unwanted_array = array('Š' => 'S', 'š' => 's', 'Ş' => 'S', 'ş' => 's', 'Ž' => 'Z', 'ž' => 'z', 'À' => 'A', 'Á' => 'A', 'Â' => 'A', 'Ã' => 'A', 'Ä' => 'A', 'Å' => 'A', 'Å' => 'A', 'Æ' => 'A', 'Ç' => 'C', 'È' => 'E', 'É' => 'E', 'Ê' => 'E', 'Ë' => 'E', 'Ì' => 'I', 'Í' => 'I', 'Î' => 'I', 'Ï' => 'I', 'Ñ' => 'N', 'Ò' => 'O', 'Ó' => 'O', 'Ô' => 'O', 'Õ' => 'O', 'Ö' => 'O', 'Ø' => 'O', 'Ù' => 'U', 'Ú' => 'U', 'Û' => 'U', 'Ü' => 'U', 'Ű' => 'U', 'Ý' => 'Y', 'Þ' => 'B', 'ß' => 'Ss', 'à' => 'a', 'á' => 'a', 'â' => 'a', 'ã' => 'a', 'ä' => 'a', 'å' => 'a', 'æ' => 'a', 'ç' => 'c', 'è' => 'e', 'é' => 'e', 'ê' => 'e', 'ë' => 'e', 'ì' => 'i', 'í' => 'i', 'î' => 'i', 'ï' => 'i', 'ı' => 'i', 'ð' => 'o', 'ñ' => 'n', 'ò' => 'o', 'ó' => 'o', 'ô' => 'o', 'õ' => 'o', 'ö' => 'o', 'ø' => 'o', 'ù' => 'u', 'ú' => 'u', 'û' => 'u', 'ű' => 'u', 'ü' => 'u', 'ý' => 'y', 'ý' => 'y', 'þ' => 'b', 'ÿ' => 'y', 'º' => '*', 'ż' => 'z');
$log->lwrite(print_r($unwanted_array));
// comment
$daemonIP = "192.168.2.53";
// XXX We should make this dynamic. IP of our LamPI-daemon
$noError = true;
$curl_errs = 0;
// Count the number of curl errors
$curl_msgs = 0;
$time_now = time();
// Time NOW at this moment of calling
// ----------------------------------------------------------------------------------------
// ZWAY CONFIGURATIONS
//
$zway_dev = array();
$zway_rules = array('id' => 1, 'dev' => 9, 'gui_inValid' => 3, 'rules' => "");
$zway_val = "";
$log = new Logging();
$log->lfile($log_dir . '/LamPI-gate.log');
$log->lwrite("\n\n---------------------------------- STARTING ZWAVE DAEMON -----------------------------------");
$apperr = "";
// Global Error. Just append something and it will be sent back
$appmsg = "";
// Application Message (from backend to Client)
// ----------------------------------------------------------------------------------------
// ZWAY_DUMP
//
// Default is to dump all devices. $tim is for later optional use
//
function zway_dump($ch, $tim)
{
// global $time_start;
global $razberry;
global $debug;
<?php
//Error reporting
ini_set('display_errors', 1);
error_reporting(E_ALL);
include "/var/www/html/magento/paGateway/includes/conn.php";
include "/var/etl/bin/includes/logging.php";
include "/var/etl/bin/includes/database_functions.php";
include "/var/etl/bin/includes/functions.php";
// Logging class initialization
$log = new Logging();
$log->lfile('/var/log/paGateway/pag_update_shipping.log');
$log->lwrite("starting file. \r\n");
// **************************************** SCRIPT MODE ***************************************************************/
// set to test so that magento status is not set to complete. no way to move from complete back to processing */
$scriptMode = "live";
$config_info = parse_ini_file('/var/www/html/magento/paGateway/paGateway.ini', true);
$now = date('Y.m.d \\: h:m:s');
$to = $config_info['email']['to'];
$db = mysql_select_db($config_info['db_info']['db_selected'], $con);
if (!$db) {
echo "cant select database";
}
//load paAPI
require_once "/var/www/html/magento/paGateway/paOrder.php";
function getStatus($orderId)
{
$config_info = parse_ini_file('/var/www/html/magento/paGateway/paGateway.ini', true);
$uid = $config_info['login']['uid'];
$pass = $config_info['login']['pass'];
// PO Number entered via API. Use Magento Invoice ID.
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;
}
if (!$con) {
die('Could not connect: ' . mysql_error());
}
$db = mysql_select_db("magento", $con);
if (!$db) {
echo "cant select database";
}
//************************ SET STATUS for API ***********************************//
// $apiMode = "live" or "test"
$apiMode = "test";
//******************************************************************************//
$config_info = parse_ini_file('/var/www/html/magento/paGateway/paGateway.ini', true);
include "/var/etl/bin/includes/logging.php";
// Logging class initialization
$log = new Logging();
$log->lfile('/var/log/paGateway/paGateway.log');
$log->lwrite("Script STARTED.\r\n");
//External script - Load magento framework
require_once "/var/www/html/magento/app/Mage.php";
Mage::app();
$myOrder = Mage::getModel('sales/order');
// print_r($myOrder);
$orders = Mage::getModel('sales/mysql4_order_collection');
// print_r($orders);
//FILTER to only orders in processing status
$orders->addFieldToFilter('status', array('eq' => "processing"));
//Status is "processing"
$allIds = $orders->getAllIds();
// print_r($allIds);
foreach ($allIds as $thisId) {
$myOrder->reset()->load($thisId);
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;
}
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();
}
}
