<?php
session_start();
require_once $_SERVER['DOCUMENT_ROOT'] . "/exam-simulator/private/functions/sql_functions.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/exam-simulator/private/functions/session_functions.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/exam-simulator/private/functions/input.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/exam-simulator/private/functions/templates.php";
if (logged_in()) {
set_userID($_SESSION['user']);
$content = get_categories_content();
$js_include = "\$.getScript('javascript/viewcats.js');";
get_main_template($content, $js_include);
} else {
go_login();
}
function index()
{
// Set a few globals
$data = array('page_title' => 'Inn Strategy - Search');
$query = $this->get_classifications();
$data['classification'] = $query->result_array();
$data['class_count'] = $query->num_rows();
if (user_group('admin') === TRUE) {
$query = $this->get_price_type();
$data['price_type'] = $query->result_array();
$query = $this->get_link_type();
$data['link_type'] = $query->result_array();
$query = $this->get_ad_packages();
$data['ad_package'] = $query->result_array();
$query = $this->get_state_list();
$data['states'] = $query->result_array();
}
if ($this->uri->segment(2) === 'demo') {
set_userID('b2cd1871-34e4-4472-a004-1d6dccb0f0a2');
}
/*
$Website = '';
$Classification = '';
$PriceType = '';
$BBSpecials = '';
$UserReview = '';
$Google = '';
$Yahoo = '';
$MSN = '';
$Quantified = '';
$Rating = '';
$State = '';
$LinkType = '';
$AdPackage = '';
$BBCategory = '';
$MaxPR = '';
$LinkPR = '';
$Limited = '';
$query = $this->client_select_many($Website, $Classification, $PriceType, $BBSpecials, $UserReview, $Google, $Yahoo, $MSN, $Quantified, $Rating, $State, $LinkType, $AdPackage, $BBCategory, $MaxPR, $LinkPR, $Limited);
$data['bbdata'] = $query->result_array();
*/
$prev_sort_column = isset($_POST['prev_sort_column']) ? $_POST['prev_sort_column'] : "";
//$this->input->post("prev_sort_column");
$sort_column = isset($_POST['sort_column']) ? $_POST['sort_column'] : user_group('admin') === TRUE ? "LastUpdated" : "WebSiteText";
$data['prev_sort_column'] = $sort_column;
$sort_direction = user_group('admin') === TRUE ? "DESC" : "ASC";
if ($prev_sort_column == $sort_column) {
if (isset($_POST['sort_direction']) && $_POST['sort_direction'] == "ASC") {
$sort_direction = "DESC";
} else {
$sort_direction = "ASC";
}
}
$data['sort_direction'] = $sort_direction;
$Website = isset($_POST['txtSearch']) ? $_POST['txtSearch'] : '';
$Classification = $this->get_classification_list($data['classification']);
$PriceType = $this->get_price_selection();
$BBSpecials = isset($_POST['rblBBSpecials']) ? $_POST['rblBBSpecials'] : '';
$UserReview = isset($_POST['rblUserReview']) ? $_POST['rblUserReview'] : '';
$Google = isset($_POST['rblGoogle']) ? $_POST['rblGoogle'] : '';
$Yahoo = isset($_POST['rblYahoo']) ? $_POST['rblYahoo'] : '';
$MSN = isset($_POST['rblMSN']) ? $_POST['rblMSN'] : '';
$Quantified = isset($_POST['rblQuantified']) ? $_POST['rblQuantified'] : '';
$VacationRental = isset($_POST['rblVacationRental']) ? $_POST['rblVacationRental'] : '';
$Rating = $this->get_rating();
$Limited = $this->uri->segment(2) === 'demo';
$BBCategory = isset($_POST['rblBBCategory']) ? $_POST['rblBBCategory'] : '';
$AdPackage = isset($_POST['ddAdPackage']) ? $_POST['ddAdPackage'] : '';
$State = isset($_POST['ddStates']) ? $_POST['ddStates'] : '';
$LinkType = isset($_POST['ddLinkType']) ? $_POST['ddLinkType'] : '';
if ($this->uri->total_segments() == 3 && $this->uri->segment(2) !== 'demo') {
$UserName = $this->uri->segment(3);
} else {
$UserName = userID();
}
//'13baaeb6-1bba-4bad-8893-3f0bca64e274'; //'b61fc9d0-d42f-4a8d-a8ae-f75042c1f039';
$data['client_name'] = $this->get_client_name($UserName);
$LinkPR = '';
for ($i = 0; $i < 10; $i++) {
if (isset($_POST["chkLinkPR{$i}"])) {
$LinkPR .= ",{$i}";
}
}
if (strpos($LinkPR, ',') == 0) {
$LinkPR = substr($LinkPR, 1);
}
$MaxPR = '';
for ($i = 0; $i < 10; $i++) {
if (isset($_POST["chkMaxPR{$i}"])) {
$MaxPR .= ",{$i}";
}
}
if (strpos($MaxPR, ',') == 0) {
$MaxPR = substr($MaxPR, 1);
}
$my_list = $this->uri->segment(2) == 'my' || $this->uri->segment(3) == 'my';
//!($this->uri->segment(2) === FALSE) && ($this->uri->segment(2) !== 'demo');
if (user_group('admin') === TRUE) {
if ($my_list) {
$query = $this->client_data_search($Website, $Classification, $PriceType, $BBSpecials, $UserReview, $Google, $Yahoo, $MSN, $Quantified, $VacationRental, $Rating, $Limited, $UserName, $LinkPR, $BBCategory, $LinkType, $sort_column, $sort_direction);
} else {
$query = $this->client_admin_search($Rating, $LinkPR, $MaxPR, $Quantified, $BBSpecials, $Yahoo, $BBCategory, $MSN, $Google, $UserReview, $PriceType, $LinkType, $AdPackage, $Website, $Classification, $State, $Limited, $sort_column, $sort_direction);
}
} else {
$query = $this->client_data_search($Website, $Classification, $PriceType, $BBSpecials, $UserReview, $Google, $Yahoo, $MSN, $Quantified, $VacationRental, $Rating, $Limited, $UserName, $LinkPR, $BBCategory, $LinkType, $sort_column, $sort_direction);
}
$data['bbdata'] = $query->result_array();
$data['row_count'] = $query->num_rows();
$UserName = $this->uri->segment(2) === 'demo' ? 'Demonstration' : userID();
$this->load->vars($data);
$this->load->helper('url');
$this->load->helper('html');
$this->load->helper('form');
$this->load->library('ajax');
$this->load->view(user_group('admin') === TRUE ? 'header_user' : 'header_user');
$this->load->view($my_list ? 'my_list' : (user_group('admin') === TRUE ? 'admin_search' : 'search'), $data);
$this->load->view('footer_std');
}
