*/ if (!defined('sugarEntry') || !sugarEntry) { die('Not A Valid Entry Point'); } global $db, $app_list_strings; $response = ""; $action = ""; if (isset($_POST['action'])) { $action = $_POST['action']; } if (isset($_POST['department']) && isset($_POST['frame_type'])) { $department = $_POST['department']; $frame_type = $_POST['frame_type']; $sql = "SELECT * FROM tours WHERE deparment = '{$department}' AND frame_type = '{$frame_type}' AND is_template = 1 AND deleted = 0"; $result = $db->query($sql); Tour::destinationToList(); $tours = array(); while ($row = $db->fetchByAssoc($result)) { $transport = explode('^,^', $row['transport']); $transport_dom = get_select_options($app_list_strings['transport_dom'], $transport); $destination = explode('^,^', $row['noiden']); $allCountries = Country::get_list_countries($row['deparment']); $destiantion_dom = get_select_options_with_id($allCountries, $row['deparment']); $currency = get_select_options($app_list_strings['currency_dom'], $row['currency']); $status = get_select_options_with_id($app_list_strings['tour_status_dom'], $row['status']); /*$tour = array( "id" => $row['id'], "name" => $row['name'], "description" => $row['description'], "from_place" => $row['from_place'], "to_place" => $row['to_place'],