Esempio n. 1
0
function index()
{
    session_start();
    global $db, $prefix;
    include "header.php";
    $tpl = new Template();
    smartyValidate::connect($tpl, empty($_POST));
    SmartyValidate::register_form('fare_search');
    //set
    $origin = intval($_REQUEST["origin"]);
    $destination = intval($_REQUEST["destination"]);
    if ($_POST["departure"]) {
        $departure = tounixdate($_POST["departure"]);
    } else {
        $departure = $_GET["departure"];
    }
    $faretype = intval($_REQUEST["faretype"]);
    $class = intval($_REQUEST["class"]);
    $airline = intval($_REQUEST["airline"]);
    $tpl->assign("origin", $origin);
    $tpl->assign("destination", $destination);
    $tpl->assign("class", $class);
    $tpl->assign("faretype", $faretype);
    //fare type
    $qtype = $db->query("SELECT * FROM travel_faretype");
    while (list($type_id, $type_name) = $db->fetch_row($qtype)) {
        $type_opt[$type_id] = $type_name;
    }
    //Origin
    $qorigin = $db->query("SELECT origin_id,origin_name FROM travel_origin ORDER BY origin_name ASC ");
    $origin_opt = array();
    while (list($origin_id, $origin_name) = $db->fetch_row($qorigin)) {
        $origin_opt[$origin_id] = $origin_name;
    }
    //Destination
    $qdestination = $db->query("SELECT destination_id,destination_name FROM travel_destination JOIN\r\n\t{$prefix}_fares ON destination_id=fare_destination\r\n\tORDER BY destination_name ASC");
    $destination_opt = array();
    while (list($destination_id, $destination_name) = $db->fetch_array($qdestination)) {
        $destination_opt[$destination_id] = $destination_name;
    }
    // Airlines
    $qairline = $db->query("SELECT airline_id,airline_name FROM travel_airline");
    $airline_opt = array();
    while (list($airline_id, $airline_name) = $db->fetch_array($qairline)) {
        $airline_opt[$airline_id] = $airline_name;
    }
    // Class
    $qclass = $db->query("SELECT class_id,class_name FROM travel_class");
    $class_opt = array();
    while (list($class_id, $class_name) = $db->fetch_array($qclass)) {
        $class_opt[$class_id] = $class_name;
    }
    if (!isset($_GET[page]) && empty($_POST)) {
        $tpl->assign("origin_opt", $origin_opt);
        $tpl->assign("destination_opt", $destination_opt);
        $tpl->assign("airline_opt", $airline_opt);
        $tpl->assign("class_opt", $class_opt);
        $tpl->assign("type_opt", $type_opt);
        $tpl->assign("lang", $lang);
        $tpl->display("search/search.tpl");
    } else {
        if (SmartyValidate::is_valid($_POST)) {
            // no errors, done with SmartyValidate
            $tpl->assign($_POST);
            $tpl->assign("origin_opt", $origin_opt);
            $tpl->assign("destination_opt", $destination_opt);
            $tpl->assign("airline_opt", $airline_opt);
            $tpl->assign("class_opt", $class_opt);
            $tpl->assign("type_opt", $type_opt);
            $tpl->assign("lang", $lang);
            $tpl->display("search/search.tpl");
            SmartyValidate::disconnect();
            $origin = intval($_REQUEST["origin"]);
            $destination = intval($_REQUEST["destination"]);
            if ($_POST["departure"]) {
                $departure = tounixdate($_POST["departure"]);
            } else {
                $departure = $_GET["departure"];
            }
            $faretype = intval($_REQUEST["faretype"]);
            $class = intval($_REQUEST["class"]);
            $airline = intval($_REQUEST["airline"]);
            //goto("index.php?m=search&op=search&origin=$origin&destination=$destination&departure=$departure&faretype=$faretype&class=$class&airline=$airline","Processing");
            $faretype = intval($_REQUEST["faretype"]);
            $class = intval($_REQUEST["class"]);
            $airline = intval($_REQUEST["airline"]);
            $query = "SELECT * FROM " . $prefix . "_fares," . $prefix . "_fares_origin\r\n\t\t\tWHERE fare_id= fares_fare AND fares_origin ={$origin} \tAND fare_destination='{$destination}'";
            if (!empty($faretype)) {
                $query .= " AND fare_type={$faretype}";
            }
            if (!empty($class)) {
                $query .= " AND fare_class={$class}";
            }
            if (!empty($airline)) {
                $query .= " AND fare_airline={$airline}";
            }
            if (!empty($departure)) {
                $query .= " AND {$departure} BETWEEN  fare_dept_start AND  fare_dept_end";
            }
            $qsearch = $db->query($query);
            $num_record = $db->row_count($qsearch);
            if ($num_record < 1) {
                $tpl->assign("norecord", "norecord");
                $tpl->assign("lang", $lang);
                $tpl->display("search/search_result.tpl");
                include "footer.php";
                exit;
            }
            if (isset($_GET['page'])) {
                $page = intval($_GET['page']);
            } else {
                $page = 1;
            }
            $currentpage = $page;
            $perpage = 10;
            $start = ($page - 1) * $perpage;
            $pages = ceil($num_record / $perpage);
            $starting_no = $start + 1;
            if ($num_record - $start < $perpage) {
                $end_count = $num_record;
            } elseif ($num_record - $start >= $perpage) {
                $end_count = $start + $perpage;
            }
            if ($pages > 1) {
                $page_link = makepagelink("index.php?m=search&origin={$origin}&destination={$destination}&departure={$departure}&class={$class}&faretype={$faretype}&airline={$airline}", $page, $pages);
            } else {
                $page_link = "";
            }
            $result = $db->query("{$query}  AND fare_active=1 ORDER BY   fare_adultfare ASC limit {$start},{$perpage}");
            while ($row = $db->fetch_array($result)) {
                $indexx = $row[fare_id];
                $info[$indexx] = $row;
                $info[$indexx]["airline"] = getrow("airline_name", "travel_airline", "airline_id", "{$row['fare_airline']}");
            }
            $originName = getrow("origin_name", "" . $prefix . "_origin", "origin_id", "{$origin}");
            $destinationName = getrow("destination_name", "" . $prefix . "_destination", "destination_id", "{$destination}");
            $tpl->assign("lang", $lang);
            $tpl->assign("fareinfo", $info);
            $tpl->assign("found", $num_record);
            $tpl->assign("destinationName", $destinationName);
            $tpl->assign("originName", $originName);
            $tpl->assign("page_link", $page_link);
            $tpl->assign("end_count", $end_count);
            $tpl->assign("starting_no", $starting_no);
            $tpl->assign("currentpage", "{$currentpage}/{$pages}");
            $tpl->display("search/search_result.tpl");
        } else {
            $tpl->assign("origin_opt", $origin_opt);
            $tpl->assign("destination_opt", $destination_opt);
            $tpl->assign("airline_opt", $airline_opt);
            $tpl->assign("class_opt", $class_opt);
            $tpl->assign("type_opt", $type_opt);
            $tpl->assign("lang", $lang);
            $tpl->assign($_POST);
            $tpl->display("search/search.tpl");
        }
    }
    include "footer.php";
}
Esempio n. 2
0
header("location:index.php");
die();
}

$index=2;

$page_title="Contact us";


require_once("mainfile.php");
global $config;

include("header.php");
$tpl= new Template();
$tpl->modTemplate("contact");
smartyValidate::connect($tpl, empty($_POST));
SmartyValidate::register_form('contact_us');
	 $tpl->assign("lang",$lang);
$tpl->assign("phone",$config[site_phone]);
if(empty($_POST)) {
	 $tpl->assign("lang",$lang);
	$tpl->display('contact.tpl');
}
else{
		   // validate after a POST
		   if(SmartyValidate::is_valid($_POST)) {
			   // no errors, done with SmartyValidate
			   	$uname=$_POST['uname'];
			   	$message=$_POST['message'];
			   	$subject=$_POST['subject'];
			   	$uemail=$_POST['uemail'];