<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
include_once './TrainStationsNearDB.php';
$IDStationA = isset($_POST["StationA"]) ? $_POST["StationA"] : 0;
$IDStationB = isset($_POST["StationB"]) ? $_POST["StationB"] : 0;
$Action = isset($_POST["Action"]) ? $_POST["Action"] : 0;
if ($IDStationA != 0 && $IDStationB != 0 && $Action != 0) {
$result = TrainStationsNearDB::getAB($IDStationA, $IDStationB);
var_dump($result);
if ($result != false) {
if ($Action == "100") {
TrainStationsNearDB::update($IDStationA, $IDStationB);
}
if ($Action == "200") {
TrainStationsNearDB::delete($IDStationA, $IDStationB);
}
} else {
if ($Action == "100") {
TrainStationsNearDB::insert($IDStationA, $IDStationB);
}
}
}
echo "var StationsData = [";
for ($i = 0; $i < $TrainStationDataMaxRecords; $i++) {
echo "['";
echo $TrainStationData[$i]["IDStation"];
echo "','";
echo $TrainStationData[$i]["Name"];
echo "']";
if ($i < $TrainStationDataMaxRecords - 1) {
echo ",";
}
}
echo " ];";
?>
<?php
$TrainStationsNearData = TrainStationsNearDB::getAll();
//var_dump($TrainStationsNearData);
$TrainStationsNearDataMaxRecords = sizeof($TrainStationsNearData);
//var_dump($TrainStationsNearDataMaxRecords);
echo "var railPolyLines =[];";
for ($i = 0; $i < $TrainStationsNearDataMaxRecords; $i++) {
$TempRailAB = $TrainStationsNearData[$i];
$TempLocationA = TrainStationsDB::get($TempRailAB["IDStationA"]);
$TempLocationB = TrainStationsDB::get($TempRailAB["IDStationB"]);
echo "railPolyLines[" . $i . "]=";
echo "[[" . $TempLocationA["Lat"] . "," . $TempLocationA["Lng"] . "," . $TempRailAB["IDStationA"] . "," . $TempRailAB["IDStationB"] . "]";
echo ",";
echo "[" . $TempLocationB["Lat"] . "," . $TempLocationB["Lng"] . "]];";
/*if ( $i < $TrainStationDataMaxRecords - 1)
{
echo "),";
var_dump($StationData);
echo '</p></div>';
echo '<hr/>';
//var_dump(TrainStationsDB::get($StationA));
echo "<br/><b>StationB:" . $StationB . "</b><br/>";
$StationData = TrainStationsDB::get($StationB);
if (isset($StationData["Name"])) {
echo '<p><b>' . $StationData["Name"] . '</b></p>';
}
echo '<div><p>';
var_dump($StationData);
echo '</p></div>';
echo '<hr/>';
//var_dump(TrainStationsDB::get($StationB));
echo "<br><b>StationNear: Od :" . max($StationA, $StationB) . ", do:" . min($StationA, $StationB) . "-</b><br/>";
var_dump(TrainStationsNearDB::getAB($StationA, $StationB));
echo "<hr/>";
echo "Random number ( test if script is refreshing ): ";
var_dump(rand(0, 1000));
echo "<br/>";
?>
<script>
var SelectedStationA = "<?php
echo $StationA;
?>
";
var SelectedStationB = "<?php
echo $StationB;
?>
";
