} $response = json_encode($synced); } else { return false; } } } else { if ($action == "get_tour_num") { $response = Tour::get_tour_num(); } else { if ($action == "get_destination_by_area") { if (isset($_POST['area'])) { $area_id = $_POST['area']; $department = $_POST['department']; $country_id = $_POST['country_id']; $destinations = Destination::getDestinationsByArea($country_id, $area_id, $department); $response = get_select_options_with_id($destinations, ''); } } else { if ($action == "get_cities_by_areas") { if (isset($_POST['areas'])) { $areas = $_POST['areas']; $areas = explode("|", $areas); $countries = explode(",", $_POST['country']); $countries = implode("','", $countries); $cities = array(); $query = "SELECT \r\n D.* \r\n FROM\r\n destinations D \r\n JOIN c_areas_destinations_c AD \r\n ON D.ID = AD.c_areas_de577anations_idb \r\n JOIN c_areas A \r\n ON A.ID = AD.c_areas_de9d4fc_areas_ida \r\n JOIN countries_destinations_c cd \r\n ON cd.countries_bc13nations_idb = D.id\r\n JOIN countries c \r\n ON c.id = cd.countries_5a12untries_ida\r\n WHERE (1!=1 "; foreach ($areas as $id) { $query .= " or A.id = '{$id}'"; } $query .= ') and cd.deleted =0 and c.deleted =0 and D.deleted = 0 and AD.deleted=0 and A.deleted = 0 ';
} */ $country_id = ''; if (count($areas) > 0) { $area_options .= '<option value ="">none</option>'; foreach ($areas as $row) { if ($row['id'] == $focus->area && $row['country_id'] == $focus->country_id) { $area_options .= "<option selected='selected' data-code='" . $row['code'] . "' data-country='" . $row['country_id'] . "' value='" . $row['id'] . "' >" . $row['name'] . '-' . $row['country'] . "</option>"; } else { $area_options .= "<option data-code='" . $row['code'] . "' data-country='" . $row['country_id'] . "' value='" . $row['id'] . "' >" . $row['name'] . '-' . $row['country'] . "</option>"; } $area_pattern .= $area_pattern == "" ? "" : "|"; $area_pattern .= $row['code']; } } $destination = Destination::getDestinationsByArea($focus->country_id, $focus->area, $focus->deparment); if (!empty($focus->noiden)) { $noiden = explode('^,^', $focus->noiden); $ss->assign('DESTINATIONS', get_select_options_with_id($destination, $noiden)); } else { $ss->assign('DESTINATIONS', '<option data-code="" value="">--None--</option>'); } $ss->assign("TOUR_AREA", $area_options); //$ss->assign("TOUR_AREA", get_select_options_with_id($app_list_strings['destination_region_dom'],$focus->area)); // custom if ($focus->tour_code) { // $tour_code_area = substr($focus->tour_code, 0, 5); if (preg_match('/^(' . $frame_types_pattern . ')(' . $area_pattern . ')(\\d+)(\\/)(\\w+)-(\\d+)$/', $focus->tour_code, $matches)) { $tour_frame_type = $matches[1]; $tour_code_area = $matches[2]; $tour_code_num = $matches[3];