$inputs = Input::all();
$term = $inputs['term'];
$franchiseeId = Session::get('franchiseId');
$result = DB::select('call sp_searchStudentCustomers(?, ?, ?)', array($term, $franchiseeId, '@result'));
if (isset($result)) {
return Response::json($result);
}
return Response::json(array("status" => "clear"));
});
Route::any('getWeekendsForBday', function () {
$inputs = Input::all();
$startDate = "01 " . $inputs['dateSelected'];
$lastDateofMonth = date('t', strtotime($inputs['dateSelected']));
$endDate = $lastDateofMonth . " " . $inputs['dateSelected'];
$saturdays = getWeekends($startDate, $endDate, "Sat");
$sundays = getWeekends($startDate, $endDate, "Sun");
$result['saturdays'] = $saturdays;
$result['sundays'] = $sundays;
if (isset($result)) {
return Response::json($result);
}
return Response::json(array("status" => "clear"));
});
Route::any('getCities', function () {
$inputs = Input::all();
$id = $inputs['id'];
$countryCode = $inputs['countryCode'];
$cities = Cities::getCities($id, $countryCode);
return Response::json($cities);
});
Route::get('logout', "VaultController@logout");
<?php
error_reporting(-1);
ini_set('display_errors', 'On');
include_once 'aviasales.php';
$result = getWeekends();
echo print_r($result);
echo '</br></br>';
echo $result[0]['Friday'] . '</br>';
$date = new DateTime($result[0]['Friday']);
echo date('Y-m', $date->getTimestamp());
* Date: 01.09.2015
* Time: 15:20
*/
error_reporting(-1);
ini_set('display_errors', 'On');
set_time_limit(3600);
echo 'start</br>';
$timeStart = microtime(true);
require_once 'aviasales.php';
$origins = array('Москва', 'Санкт-Петербург');
//Destinations list from database
$destinations = getDestinations(5);
//Only include tariffs 80%+ cheaper then month average
$ratio = 0.7;
//Dates for next 6 months
$weekends = getWeekends(30);
//Table header
echo '<table>';
echo '<tr><th>Origin</th><th>Destination</th><th>Date</th><th>Days</th><th>Return at</th><th>Price</th><th>Average</th><th>Link</th></tr>';
$month = '';
foreach ($origins as $origin) {
foreach ($destinations as $destination) {
foreach ($weekends as $weekend) {
foreach (array('Friday', 'Saturday') as $day) {
//Get IATA codes
$originIata = getCityCode($origin);
$destIata = getCityCode($destination['destination_name']);
if ($originIata && $destIata) {
//Define average rate for dest/month
$curMonth = date('Y-m', strtotime($weekend['Friday']));
if ($month != $curMonth) {
