<?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'); }