$lang['apartman_small'], 2 => $lang['penzion_small'], 3 => $lang['vila_small'], 4 => $lang['pokoj_small'], 5 => $lang['hotel_small'], 6 => $lang['resort_small'] ); $room_type = array( 1 => $lang['loznice'], 2 => $lang['kuchyne'], 3 => $lang['koupelna'], 4 => $lang['obyvaci_pokoj'], 5 => $lang['obyvak_s_kuchyni'], 6 => $lang['studio'], 7 => $lang['wc'], 8 => $lang['balkon'], 9 => $lang['terasa'], ); session_update(); $id = (int) $_GET['id']; switch ( $_GET['obj'] ) { case 'res': # letovisko a objekty v nem $result = MSQ_utf(' SELECT r.resort_id, rl.resort_name, rl.resort_desc FROM c_resort `r` LEFT JOIN c_resort_lng `rl` ON rl.resort_id = r.resort_id AND rl.lng_id = ' . $_SESSION['lng'] . ' WHERE r.resort_id = ' . (int) $id . ' '); $id = @mysql_fetch_assoc($result); $out = "

{$lang['vyhledavani_letovisko']}:   {$id['resort_name']}

\n"; $out .= show_resort(false, $id['resort_desc']); $out .= show_object($id['resort_id']); $out .= gallery_thumbnails($id['resort_id'], 2); break; case 'obj': # objekty a apartmany v nem $result = MSQ_utf(' SELECT r.resort_id, rl.resort_name , o.obj_id, ol.obj_name FROM c_resort `r` LEFT JOIN c_resort_lng `rl` ON rl.resort_id = r.resort_id AND rl.lng_id = ' . $_SESSION['lng'] . ' , c_object `o` LEFT JOIN c_object_lng `ol` ON ol.obj_id = o.obj_id AND ol.lng_id = ' . $_SESSION['lng'] . ' WHERE o.obj_id = ' . (int) $id . ' AND o.resort_id = r.resort_id '); $id = @mysql_fetch_assoc($result); $out = '

' . $id['obj_name'] . "

\n"; $out .= ''; $out .= '\n"; $out .= show_object($id['obj_id']); $title = $id['obj_name'] . ' | ' . $lang['cestovni_agentura']; break; case 'apa': # konkretni apartman s pokoji $result = MSQ_utf(' SELECT r.resort_id, rl.resort_name , o.obj_id, ol.obj_name , a.apa_id, a.apa_code, al.apa_name FROM c_resort `r` LEFT JOIN c_resort_lng `rl` ON rl.resort_id = r.resort_id AND rl.lng_id = ' . $_SESSION['lng'] . ' , c_object `o` LEFT JOIN c_object_lng `ol` ON ol.obj_id = o.obj_id AND ol.lng_id = ' . $_SESSION['lng'] . ' , c_apartment `a` LEFT JOIN c_apartment_lng `al` ON al.apa_id = a.apa_id AND al.lng_id = ' . $_SESSION['lng'] . ' WHERE a.apa_id = ' . $id . ' AND a.apa_deleted IS NULL AND a.obj_id = o.obj_id AND o.resort_id = r.resort_id '); $id = @mysql_fetch_assoc($result); $out = '

' . $id['apa_name'] . "

\n"; $out .= '\n"; $out .= show_apartment($id['resort_id'], $id['obj_id'], $id['apa_id'], $id['resort_name']); $title = $id['obj_name'] . ' - ' . $id['apa_name'] . ' | ' . $lang['cestovni_agentura']; break; } $out_body .= $out; /* zobrazeni informaci letoviska */ function show_resort($name, $desc=false) { global $lang; $out = table_start(0, 1, 0, '100%'); if ( $name ) $out .= table_tr(false, array('d', 'd'), array($lang['vyhledavani_letovisko'].':', $name), array('c#text-main^w#100', 'c#text-main')); if ( $desc ) { $out .= table_tr(false, array('d'), array($desc), array('c#text-main-justify^l#2')); $out .= table_tr(false, array('d'), array(''), array('c#tr-separator^l#4')); } $out .= table_end(); return $out; } /* zobrazeni informaci objektu */ function show_object( $obj_id=false ) { global $lang, $object_type, $zero, $col1; $pets = array(1=>$lang['nedovolen'], $lang['dovolen'], $lang['dovolen_poplatek']); $catering = array(1=>$lang['ne'], $lang['v_dome'], $lang['v_restauraci']); $bed_clothes = array(1=>$lang['ne'], $lang['tydne']); $ingoing = array(1=>$lang['kdykoli'], $lang['so_so']); # data objektu $sql = "SELECT o.*, ol.* FROM c_object `o` LEFT JOIN c_object_lng `ol` ON ol.obj_id=o.obj_id AND ol.lng_id={$_SESSION['lng']} WHERE "; $sql .= $obj_id ? 'o.obj_id = ' . $obj_id : 'resort_id = ' . $resort_id; $sql .= ' ORDER BY o.obj_order'; $result = MSQ_utf($sql); list ( $apa_total, $apa_beds, $rooms ) = sumarize_apartments( $obj_id ); # detaily objektu $row = mysql_fetch_assoc($result); $descr = $row['obj_desc'] ? '

' . $row['obj_desc'] . '

' : ''; $descr .= table_start(0, 1, 0, '100%'); if ( $row['obj_avail_from'] ) { $tmp = explode('-', $row['obj_avail_from']); $from_to = ((int) $tmp[1]).'.'.((int)$tmp[0]).' - '; $tmp = explode('-', $row['obj_avail_to']); $from_to .= ((int) $tmp[1]).'.'.((int)$tmp[0]); } else { $from_to = $lang['celorocne_small']; } $descr .= table_tr(false, array('d', 'd'), array($lang['Kod_objektu'].':', $row['obj_code']), array('c#title^w#' . $col1, 'c#value') ); $descr .= table_tr(false, array('d', 'd'), array($lang['Apartmany'] . ':', $rooms), array('c#title^v#top', 'c#value') ); $descr .= table_tr(false, array('d', 'd'), array($lang['typ'].':', $object_type[$row['obj_type']]), array("c#title^w#$col1", 'c#value') ); if ( $row['obj_fishery'] ) $potential[] = $lang['rybareni']; if ( $row['obj_windsurfing'] ) $potential[] = $lang['windsurfing']; if ( $row['obj_rafting'] ) $potential[] = $lang['rafting']; if ( $row['obj_diving'] ) $potential[] = $lang['potapeni']; if ( count($potential) > 0 ) { $descr .= table_tr(false, array('d', 'd'), array($lang['moznosti_vyziti'].':', implode(', ', $potential)), array("c#text-td", 'c#text-td') ); } $descr .= table_tr(false, array('d', 'd'), array( $lang['nastup'].':', $ingoing[$row['obj_ingoing']], ), array('c#text-td^v#top', 'c#text-td') ); $descr .= table_tr(false, array('d', 'd'), array( $lang['k_dispozici'].':', $from_to ), array('c#text-td^v#top', 'c#text-td') ); $descr .= table_tr(false, array('d', 'd'), array( $lang['jazyky'].':', show_languages($obj_id) ), array('c#text-td^v#top', 'c#text-td') ); $descr .= table_tr(false, array('d', 'd'), array( $lang['sluzby'].':', '' . $lang['podrobne_informace'] . '' # show_services($row['obj_services']), ), array('c#text-td^v#top', 'c#text-td') ); list ( $final_price, $price, $price_type, $discount_price, $discount_type ) = find_lowest_price( $obj_id ); $descr .= table_tr(false, array('d', 'd'), array( $lang['cena'] . ':' , $lang['od'] . ' ' . ( $discount_price && $discount_type ? '' . $price . ' ' . $final_price : $final_price ) . ' / ' . strtolower($price_type) ), array('c#text-td^v#top', 'c#text-td') ); $descr .= table_tr(false, array('d'), array('
'), array('c#tr-separator^l#2')); $zaloha = str_replace(array('#', '*'), array($lang['objekt_small'], $row['obj_price_backup']), $lang['zaloha_1']); $charges = $row['obj_with_charges'] ? '
' . $lang['poplatky_predem'] : ''; $descr .= table_tr(false, array('d'), array('
'), array('c#text-td^l#2')); $descr .= table_tr(false, array('d'), array($zaloha . ' ' . ($row['obj_price_prepay'] ? $lang['pred_odjezdem'] : $lang['na_miste']) . '.' . $charges), array('c#text-td^l#2') ); $descr .= table_end(); $gallery .= new_gallery($obj_id, 3); $icons = '
' . get_icons($obj_id) . '

'; $last = table_start(0, 1, 0, '100%'); $last .= table_tr(false, array('d', 'd'), array( $lang['Posledni_aktualizace'].':', last_occupation_update($obj_id, 'obj') ), array('c#text-td^v#top', 'c#text-td red bold') ); $last .= table_end(); $back .= '
' . get_back_link('obj', $obj_id) . '

'; $bottom .= '
' . $last . $back . '
'; $out .= content_box( 'big' , false , $descr . $icons . apartment_selector($obj_id) . $bottom , false , $gallery ); $out .= '
\n"; $hidden = $_COOKIE['the_tab_cookie'] == 0 ? '' : ' none'; $out .= '
'; $out .= show_apartment($id['resort_id'], $obj_id); $out .= '
'; $hidden = $_COOKIE['the_tab_cookie'] == 1 ? '' : ' none'; $out .= '
'; $out .= ''; $out .= table_tr('alt', array('d', 'd'), array( $lang['pobyt_se_psy'].':', $pets[$row['obj_pets']] ), array('c#title', 'c#value') ); $out .= table_tr(false, array('d', 'd'), array( $lang['internet'].':', ($row['obj_internet'] == 1 ? $zero[1] : $zero[0]) ), array('c#title', 'c#value') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['parkovani'].':', ($row['obj_parking'] == 1 ? $zero[1] : $zero[0]) ), array('c#title', 'c#value') ); $out .= table_tr(false, array('d', 'd'), array( $lang['stravovani'].':', $catering[$row['obj_catering']] ), array('c#title', 'c#value') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['povleceni'].':', $bed_clothes[$row['obj_bed_clothes']] ), array('c#title', 'c#value') ); $out .= table_tr(false, array('d', 'd'), array( $lang['gril'].':', $zero[$row['obj_grill']] ), array('c#title', 'c#value') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['kotveni'].':', $zero[$row['obj_anchorage']] ), array('c#title', 'c#value') ); $result_beaches = MSQ_utf(" SELECT beach_name FROM c_obj_beach `b` LEFT JOIN c_beaches_lng as `l` ON `l`.beach_id=`b`.beach_id AND lng_id={$_SESSION['lng']} WHERE obj_id = $obj_id "); while ( $tmp = mysql_fetch_assoc($result_beaches)) { $beaches .= $tmp['beach_name'].'
'; } $out .= table_tr(false, array('d', 'd'), array( $lang['plaze'].':', $beaches ), array('c#title', 'c#value') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['nejblizsi_mesto'].':', $row['obj_city'] ), array('c#title', 'c#value') ); $out .= table_tr(false, array('d', 'd'), array( $lang['vzdal_magistrala'].':', $row['obj_highway_dist'] ), array('c#title', 'c#value') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['benzinka'].':', $row['obj_gas'] ), array('c#title', 'c#value') ); $out .= table_tr(false, array('d', 'd'), array( $lang['vzdal_smenarna'].':', $row['obj_exchange_dist'] ), array('c#title', 'c#value') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['vzdal_more'].':', $row['obj_sea_dist'] ), array('c#title', 'c#value') ); $out .= table_tr(false, array('d', 'd'), array( $lang['vzdal_posta'].':', $row['obj_post_dist'] ), array('c#title', 'c#value') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['vzdal_plaz'].':', $row['obj_beach_dist'] ), array('c#title', 'c#value') ); $out .= table_tr(false, array('d', 'd'), array( $lang['neprehlednete'].':', $row['obj_important'] ), array('c#title', 'c#value') ); $odd_row = false; if ( $row['obj_fishing_permit'] || $row['obj_fly_season'] || $row['obj_fish_kind'] || $row['obj_fish_size'] ) { $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['rybarska_povolenka'].':', ($row['obj_fishing_permit'] ? $row['obj_fishing_permit'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['druhy_ryb'].':', ($row['obj_fish_kind'] ? $row['obj_fish_kind'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['muskarska_sezona'].':', ($row['obj_fly_season'] ? $row['obj_fly_season'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['miry_ryb'].':', ($row['obj_fish_size'] ? $row['obj_fish_size'] : '-') ), array('c#title', 'c#value') ); } if ( $row['obj_raft_size'] || $row['obj_raft_price'] ) { $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['delka_raftu'].':', ($row['obj_raft_size'] ? $row['obj_raft_size'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['ceny_raftu'].':', ($row['obj_raft_price'] ? $row['obj_raft_price'] : '-') ), array('c#title', 'c#value') ); } if ( $row['obj_diving_lesson'] || $row['obj_diving_equip'] ) { $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['kurz_potapeni'].':', ($row['obj_diving_lesson'] ? $row['obj_diving_lesson'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['cena_bomby'].':', ($row['obj_diving_equip'] ? $row['obj_diving_equip'] : '-') ), array('c#title', 'c#value') ); } if ( $row['obj_windsurf_lesson'] ) { $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['cena_windsurfingu'].':', $row['obj_windsurf_lesson'] ), array('c#title', 'c#value') ); $odd_row = !$odd_row; } /* nadmorska vyska, vzdalenost od vleku, delky sjezdovek, ... */ if ( $row['obj_altitude'] || $row['obj_tow_distance'] || $row['obj_ski_slope'] || $row['obj_ski_slope_length'] || $row['obj_ski_running'] || $row['obj_sleigh']) { $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['nadmorska_vyska'].':', ($row['obj_altitude'] ? $row['obj_altitude'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['pocet_sjezdovek'].':', ($row['obj_ski_slope'] ? $row['obj_ski_slope'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['vzdalenost_vlek'].':', ($row['obj_tow_distance'] ? $row['obj_tow_distance'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['delka_sjezdovek'].':', ($row['obj_ski_slope_length'] ? $row['obj_ski_slope_length'] : '-') ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['bezkarske_trasy'].':', $zero[$row['obj_ski_running']] ), array('c#title', 'c#value') ); $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['sankarske_trasy'].':', $zero[$row['obj_sleigh']] ), array('c#title', 'c#value') ); } if ( $row['obj_mountain_touring'] ) { $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['horske_tury'].':', $zero[$row['obj_mountain_touring']] ), array('c#title', 'c#value') ); } if ( $row['obj_bicycle_trail'] ) { $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['cyklostezky'].':', $zero[$row['obj_bicycle_trail']] ), array('c#title', 'c#value') ); } if ( $row['obj_lakes'] ) { $out .= table_tr( ($odd_row ? 'alt' : false ), array('d', 'd'), array( $lang['jezera'].':', $zero[$row['obj_lakes']] ), array('c#title', 'c#value') ); $odd_row = !$odd_row; } if ( $row['obj_extra_services'] ) { $out .= table_tr( ($odd_row ? false : 'alt' ), array('d', 'd'), array( $lang['sluzby_navic'].':', $row['obj_extra_services'] ), array('c#title', 'c#value') ); } $out .= table_end(); $out .= ''; $hidden = $_COOKIE['the_tab_cookie'] == 2 ? '' : ' none'; $out .= '
'; $out .= form_start('get', $conf_basedir . '/klient/scripts/main/data_show.php', false, false, false, 'tracerouteform'); $out .= ''; $out .= form_input('text', false, 'starting_destination', $_GET['starting_destination'], 'id="starting-destination"'); $out .= form_input('submit', false, 'submit', $lang['Najit_trasu'], 'onclick="traceRoute(); return false;" id="search-trace"'); $out .= form_end(); $out .= '' . $lang['Detaily_cesty'] . ': '; $out .= '
'; $result = MSQ_utf(build_sql( 'obj', $row['obj_id'], 'obj', 1 )); $map = mysql_fetch_assoc( $result ); $out .= ''; $out .= '
'; $hidden = $_COOKIE['the_tab_cookie'] == 3 ? '' : ' none'; $out .= '
'; $out .= stripslashes(@mysql_result(MSQ_utf("SELECT reviews FROM c_obj_reviews WHERE obj_id = $obj_id AND lng_id={$_SESSION['lng']}"), 0, 0)); $out .= '
'; return $out; } /* zobrazeni informaci apartmanu */ function show_apartment($resort_id, $obj_id, $apa_id=false, $resort_name=false) { global $lang, $zero, $conf_basedir, $col1, $room_type, $object_type; if ( $apa_id ) { # apartment list $sql = build_sql( 'apa', $apa_id, 'apa', false, 'apa' ); $result = MSQ_utf($sql); # detaily apartmanu $row = mysql_fetch_assoc($result); $equipment = array( 'apa_air_condition' => $lang['klimatizace'], 'apa_jacuzzi' => $lang['Jacuzzi'], 'apa_sauna' => $lang['Sauna'], ); foreach ( $equipment as $input_id => $descr ) { if ( $row[$input_id] ) { $apa_equipment[] = $descr; } } $descr = $row['apa_desc'] ? '

' . $row['apa_desc'] . '

' : ''; $descr .= table_start(0, 1, 0, '100%'); $descr .= table_tr(false, array('d', 'd'), array($lang['kod_apartmanu'].':', $row['apa_code']), array('c#title^w#' . $col1, 'c#value') ); $descr .= table_tr(false, array('d', 'd'), array($lang['pocet_pokoju'].':', $row['apa_rooms']), array('c#title', 'c#value') ); $descr .= table_tr(false, array('d', 'd'), array($lang['pocet_luzek'].':', $row['apa_beds']), array('c#title', 'c#value') ); if ( $apa_equipment ) { $descr .= table_tr(false, array('d', 'd'), array($lang['vybaveni'].':', implode('
', $apa_equipment)), array('c#title^v#top', 'c#value') ); } $descr .= table_end(); $gallery .= new_gallery($apa_id, 4); $back .= '
' . get_back_link('apa', $apa_id) . '

'; $out .= content_box( 'big' , false , $descr . $back , false , $gallery ); $price_backup = array($row['obj_price_backup'], $row['obj_price_prepay']); $out .= '
\n"; $out .= '
'; $out .= show_rooms( $apa_id ); $out .= '
'; $out .= '
'; $out .= show_order_form( $apa_id, $obj_id ); $out .= '
'; $out .= '
'; $out .= include('../order/obsazenost.php'); $out .= '
'; $out .= '
'; $out .= show_apa_price( $apa_id ); $out .= '
'; $out .= '
'; } else { # apartment list $sql = build_sql( 'apa', $obj_id, 'obj', false, 'apa' ); $result = MSQ_utf($sql); # seznam apartmanu $out .= '
' . sprintf($lang['celkem_ubytovacich_jednotek'], mysql_num_rows($result)) . '
'; while( $row = @mysql_fetch_assoc($result) ) { if ( !$row['apa_id'] ) { continue; } $room_result = MSQ_utf('SELECT * FROM c_rooms WHERE apa_id = ' . $row['apa_id'] . ' ORDER BY room_order'); $rooms = $kitchen = 0; $room_data = array(); while ( $room = mysql_fetch_assoc($room_result) ) { $rooms += in_array($room['room_type'], array(1, 4, 5, 6)) ? 1 : 0; if ( !$kitchen ) { $kitchen = $room['room_type'] == 2 ? '+1' : $room['room_type'] == 5 ? '+kk' : 0; } $equipment = array(); if ($room['room_beds_big']) { $equipment[] = $room['room_beds_big'] . ' x ' . $lang['postel_manzelska']; } if ($room['room_beds_small']) { $equipment[] = $room['room_beds_small'] . ' x ' . $lang['postel_oddelena']; } if ($room['room_sofa']) { $equipment[] = $room['room_sofa'] . ' x ' . $lang['pohovka_rozkladaci']; } if ($room['room_spare_beds']) { $equipment[] = $room['room_spare_beds'] . ' x ' . $lang['pristylka']; } if ($room['room_spare_beds_small']) { $equipment[] = $room['room_spare_beds_small'] . ' x ' . $lang['pristylka_dite']; } if ($room['room_case']) { $equipment[] = $lang['s_skrin']; } if ($room['room_nightlight']) { $equipment[] = $lang['s_nocni_lampa']; } if ($room['room_bedside']) { $equipment[] = $lang['s_nocni_stolek']; } if ($room['room_tv']) { $equipment[] = $lang['s_tv']; } if ($room['room_sat']) { $equipment[] = $lang['s_sat']; } if ($room['room_radio']) { $equipment[] = $lang['s_radio']; } if ($room['room_stove_el']) { $equipment[] = $lang['s_sporak_ele']; } if ($room['room_stove_gas']) { $equipment[] = $lang['s_sporak_plyn']; } if ($room['room_dinette']) { $equipment[] = $lang['s_jidelni_kout']; } if ($room['room_washer']) { $equipment[] = $lang['s_mycka']; } if ($room['room_fridge']) { $equipment[] = $lang['s_lednicka']; } if ($room['room_freezer']) { $equipment[] = $lang['s_mrazak']; } if ($room['room_bath']) { $equipment[] = $lang['s_vana']; } if ($room['room_washing_machine']) { $equipment[] = $lang['s_pracka']; } if ($room['room_shower_bath']) { $equipment[] = $lang['s_sprcha']; } if ($room['room_wc']) { $equipment[] = $lang['wc']; } if ($room['room_boiler']) { $equipment[] = $lang['s_bojler']; } if ($room['room_sitting']) { $equipment[] = $lang['s_posezeni']; } if ($room['room_sunshade']) { $equipment[] = $lang['s_slunecnik']; } if ($room['room_clothesline']) { $equipment[] = $lang['s_snura']; } if ($room['room_clotheshore']) { $equipment[] = $lang['s_susak']; } if ($room['room_microwave']) { $equipment[] = $lang['s_mikrovlnka']; } if ($room['room_coffee']) { $equipment[] = $lang['s_coffee']; } if ($room['room_desk']) { $equipment[] = $lang['s_stul']; } if ($room['room_chair']) { $equipment[] = $lang['s_kreslo']; } if ($room['room_combined_stove']) { $equipment[] = $lang['Kombinovany_sporak']; } if ($room['room_oven']) { $equipment[] = $lang['Trouba_na_peceni']; } if ($room['room_dishes']) { $equipment[] = $lang['Nadobi']; } if ($room['room_gas_cooker']) { $equipment[] = $lang['Varna_deska_plynova']; } if ($room['room_electric_cooker']) { $equipment[] = $lang['Varna_deska_elektricka']; } if ($room['room_combined_cooker']) { $equipment[] = $lang['Varna_deska_kombinovana']; } if ($room['room_sea_outlook']) { $equipment[] = $lang['Vyhled_na_more']; } if ($room['room_covered_terrace']) { $equipment[] = $lang['Kryta_terasa']; } if ($room['room_winter_terrace']) { $equipment[] = $lang['Zimni_terasa']; } if ($room['room_mirror']) { $equipment[] = $lang['Zrcadlo']; } if ($room['room_vault']) { $equipment[] = $lang['Trezor']; } if ($room['room_fan']) { $equipment[] = $lang['Ventilator']; } if ($room['room_phone']) { $equipment[] = $lang['telefon_big']; } if ($room['room_vacum_cleaner']) { $equipment[] = $lang['Vysavac']; } if ($room['room_hairdrier']) { $equipment[] = $lang['Fen']; } if ($room['room_bidet']) { $equipment[] = $lang['Bidet']; } $equipment = strtolower( @implode(', ', (array) $equipment) ); $room_data[] = array( 'room_type' => $room_type[$room['room_type']], 'equipment' => $equipment ); } if ( !$kitchen ) { $kitchen = '+0'; } switch ( $row['apa_beds'] ) { case 1: $lang_az_pro = $lang['az_pro_osobu']; break; case 2: case 3: case 4: $lang_az_pro = $lang['az_pro_osoby']; break; default: $lang_az_pro = $lang['az_pro_osob']; break; } $out .= '
'; $out .= '
'; $out .= '

' . a_link($row['apa_name'], $conf_basedir . '/klient/scripts/main/data_show.php?obj=apa&id=' . $row['apa_id']) . '

'; # $out .= '' . $rooms . $kitchen . '
'; $out .= sprintf($lang_az_pro, $row['apa_beds']); $out .= $row['apa_floor'] ? '' . $row['apa_floor'] . '. ' . $lang['patro'] . '' : ''; $out .= "
\n"; $out .= table_start(false, false, false, false, false, 'info'); $i = false; foreach ( $room_data as $room ) { $out .= table_tr( $i ? 'alt' : '', array('d', 'd'), array( $room['room_type'], $room['equipment'] ), array('c#title^v#top', 'c#value') ); $i = !$i; } $out .= table_end(); $discount = (int) @mysql_result(mysql_query('SELECT obj_price_discount FROM c_object WHERE obj_id = ' . $obj_id), 0, 0); $discount = $discount > 0 ? $discount = ' ' . (-1 * $discount) . '%' : ''; $discount_type = apartman_discount_type( $row['apa_id'] ); $out .= '
'; $out .= a_link($lang['Rezervovat_nyni'], $conf_basedir . '/klient/scripts/main/data_show.php?obj=apa&id=' . $row['apa_id'] . '#tabs-3', false, 'btn blue', 'setTabCookies(3);'); $out .= a_link($lang['Zjistit_terminy'], $conf_basedir . '/klient/scripts/main/data_show.php?obj=apa&id=' . $row['apa_id'] . '#tabs-2', false, 'btn blue', 'setTabCookies(2);'); $out .= a_link($lang['Galerie'], $conf_basedir . '/klient/scripts/main/data_show.php?obj=apa&id=' . $row['apa_id'] . '&showgallery=1', false, 'btn blue'); $out .= a_link($lang['objednat'], $conf_basedir . '/klient/scripts/main/data_show.php?obj=apa&id=' . $row['apa_id'] . '#tabs-1', false, 'btn book', 'setTabCookies(1);'); $out .= $discount_type ? '
' . a_link($lang[$discount_type] . $discount, $conf_basedir . '/klient/scripts/main/data_show.php?obj=apa&id=' . $row['apa_id'] . '#tabs-3', false, 'btn yellow') : ''; $out .= '
'; $out .= '
'; $out .= ''; $out .= "
\n"; } } return($out); } /* zobrazeni informaci pokoju */ function show_rooms( $apa_id ) { global $lang, $conf_basedir, $room_type; if ( !$apa_id ) { return; } $room_data = array(); $result = MSQ_utf("SELECT * FROM c_rooms WHERE apa_id = $apa_id ORDER BY room_order"); while ( $room = mysql_fetch_assoc($result) ) { $equipment = array(); if ($room['room_beds_big']) { $equipment[] = $room['room_beds_big'] . ' x ' . $lang['postel_manzelska']; } if ($room['room_beds_small']) { $equipment[] = $room['room_beds_small'] . ' x ' . $lang['postel_oddelena']; } if ($room['room_sofa']) { $equipment[] = $room['room_sofa'] . ' x ' . $lang['pohovka_rozkladaci']; } if ($room['room_spare_beds']) { $equipment[] = $room['room_spare_beds'] . ' x ' . $lang['pristylka']; } if ($room['room_spare_beds_small']) { $equipment[] = $room['room_spare_beds_small'] . ' x ' . $lang['pristylka_dite']; } if ($room['room_case']) { $equipment[] = $lang['s_skrin']; } if ($room['room_nightlight']) { $equipment[] = $lang['s_nocni_lampa']; } if ($room['room_bedside']) { $equipment[] = $lang['s_nocni_stolek']; } if ($room['room_tv']) { $equipment[] = $lang['s_tv']; } if ($room['room_sat']) { $equipment[] = $lang['s_sat']; } if ($room['room_radio']) { $equipment[] = $lang['s_radio']; } if ($room['room_stove_el']) { $equipment[] = $lang['s_sporak_ele']; } if ($room['room_stove_gas']) { $equipment[] = $lang['s_sporak_plyn']; } if ($room['room_dinette']) { $equipment[] = $lang['s_jidelni_kout']; } if ($room['room_washer']) { $equipment[] = $lang['s_mycka']; } if ($room['room_fridge']) { $equipment[] = $lang['s_lednicka']; } if ($room['room_freezer']) { $equipment[] = $lang['s_mrazak']; } if ($room['room_bath']) { $equipment[] = $lang['s_vana']; } if ($room['room_washing_machine']) { $equipment[] = $lang['s_pracka']; } if ($room['room_shower_bath']) { $equipment[] = $lang['s_sprcha']; } if ($room['room_wc']) { $equipment[] = $lang['wc']; } if ($room['room_boiler']) { $equipment[] = $lang['s_bojler']; } if ($room['room_sitting']) { $equipment[] = $lang['s_posezeni']; } if ($room['room_sunshade']) { $equipment[] = $lang['s_slunecnik']; } if ($room['room_clothesline']) { $equipment[] = $lang['s_snura']; } if ($room['room_clotheshore']) { $equipment[] = $lang['s_susak']; } if ($room['room_microwave']) { $equipment[] = $lang['s_mikrovlnka']; } if ($room['room_coffee']) { $equipment[] = $lang['s_coffee']; } if ($room['room_desk']) { $equipment[] = $lang['s_stul']; } if ($room['room_chair']) { $equipment[] = $lang['s_kreslo']; } if ($room['room_combined_stove']) { $equipment[] = $lang['Kombinovany_sporak']; } if ($room['room_oven']) { $equipment[] = $lang['Trouba_na_peceni']; } if ($room['room_dishes']) { $equipment[] = $lang['Nadobi']; } if ($room['room_gas_cooker']) { $equipment[] = $lang['Varna_deska_plynova']; } if ($room['room_electric_cooker']) { $equipment[] = $lang['Varna_deska_elektricka']; } if ($room['room_combined_cooker']) { $equipment[] = $lang['Varna_deska_kombinovana']; } if ($room['room_sea_outlook']) { $equipment[] = $lang['Vyhled_na_more']; } if ($room['room_covered_terrace']) { $equipment[] = $lang['Kryta_terasa']; } if ($room['room_winter_terrace']) { $equipment[] = $lang['Zimni_terasa']; } if ($room['room_mirror']) { $equipment[] = $lang['Zrcadlo']; } if ($room['room_vault']) { $equipment[] = $lang['Trezor']; } if ($room['room_fan']) { $equipment[] = $lang['Ventilator']; } if ($room['room_phone']) { $equipment[] = $lang['telefon_big']; } if ($room['room_vacum_cleaner']) { $equipment[] = $lang['Vysavac']; } if ($room['room_hairdrier']) { $equipment[] = $lang['Fen']; } if ($room['room_bidet']) { $equipment[] = $lang['Bidet']; } $room_data[] = array( 'room_type' => $room_type[$room['room_type']], 'equipment' => strtolower( @implode(', ', (array) $equipment) ) ); } $out = table_start(false, false, false, false, false, 'accomdetails'); $i = true; foreach ( $room_data as $room ) { $out .= table_tr( $i ? 'alt' : '', array('d', 'd'), array( $room['room_type'], $room['equipment'] ), array('c#title', 'c#value') ); $i = !$i; } $out .= table_end(); return $out; } /* zobrazeni ceniku apartmanu daneho terminu */ function show_apa_price($apa_id) { global $lang, $zero, $object_type; $pri_types = array( 1 => $lang['cena_noc'], 2 => $lang['cena_osoba'], 3 => $lang['cena_2_osoby'], 4 => $lang['cena_3_osoby'], 5 => $lang['cena_4_osoby'], 6 => $lang['cena_5_osob'], 7 => $lang['cena_6_osob'], 8 => $lang['cena_7_osob'], 9 => $lang['cena_8_osob'], 10 => $lang['cena_9_osob'], 11 => $lang['cena_10_osob'], 12 => $lang['cena_11_osob'], 13 => $lang['cena_12_osob'], 14 => $lang['cena_13_osob'], 15 => $lang['cena_14_osob'], 16 => $lang['cena_15_osob'] ); $country = $_SESSION['lng']; //substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2); $result = MSQ_utf(" SELECT p.pri_id, p.pri_type, p.pri_pets, p.pri_air_condition, p.pri_internet, p.pri_discount_type, p.pri_discount_price, p.pri_tax, ( IF( p.pri_discount_type != '' AND p.pri_discount_price > 0 , p.pri_discount_price , p.pri_price ) * (1 + a.apa_bonus / 100) ) AS `final_price`, ( p.pri_price * (1 + a.apa_bonus / 100) ) AS `pri_price`, p.pri_breakfast, p.pri_lunch, p.pri_dinner, p.pri_half, p.pri_full, p.pri_entry_fee, p.pri_parking_fee, p.pri_washing_fee, p.pri_final_cleaning_fee, p.pri_guarantee, p.pri_backup, l.pri_note, a.apa_bonus, o.obj_price_backup, o.obj_price_prepay FROM c_prices `p` LEFT JOIN c_prices_lng `l` ON l.pri_id=p.pri_id AND lng_id={$_SESSION['lng']}, c_apartment `a`, c_object `o` WHERE a.apa_id = $apa_id AND a.apa_deleted IS NULL AND a.apa_id = p.apa_id AND a.obj_id = o.obj_id ORDER BY pri_order "); $prices = array( 'pri_backup' => $lang['Vratna_zaloha'], 'pri_air_condition' => $lang['klimatizace'], 'pri_internet' => $lang['internet'], 'pri_pets' => $lang['zvirata'], 'pri_breakfast' => $lang['snidane_big'], 'pri_lunch' => $lang['obedy_big'], 'pri_dinner' => $lang['vecere_big'], 'pri_half' => $lang['polopenze_big'], 'pri_full' => $lang['plna_penze_big'], 'pri_entry_fee' => $lang['Poplatek_za_prihlaseni'], 'pri_parking_fee' => $lang['Poplatek_za_parkovani'], 'pri_washing_fee' => $lang['Poplatek_za_prani'], 'pri_final_cleaning_fee' => $lang['Poplatek_za_uklid'], 'pri_guarantee' => $lang['Kauce_v_pripade_skody'] ); $out = table_start(false, false, false, false, false, 'pricedetails'); while ( $row = mysql_fetch_assoc($result) ) { $price_backup = array($row['obj_price_backup'], $row['obj_price_prepay']); $terms = array(); $res = MSQ_utf("SELECT CONCAT(term_from, '-', term_to) as termin FROM c_terms WHERE pri_id={$row['pri_id']}"); while ( $row_2 = mysql_fetch_assoc($res) ) { $terms[] = $row_2['termin']; } $last_minute = strtoupper($lang[$row['pri_discount_type']]); $out .= table_tr('alt', array('d', 'd', 'd', 'd'), array( $lang['ceny_terminu'] . ':', implode(',  ', $terms), $last_minute ), array('c#title', 'c#value', 'c#title red^l#2') ); $out .= table_tr(false, array('d', 'd', 'd', 'd'), array( $pri_types[$row['pri_type']] . ':', ( $row['pri_discount_price'] && $row['pri_discount_type'] ? '' . show_price($row['pri_price'], $country, true) . '   ' . '' . show_price($row['final_price'], $country, true) . '' : show_price($row['final_price'], $country, true) ), ( $row['pri_tax'] >= 0 ? $lang['pobytova_taxa'].':' : ''), ( $row['pri_tax'] >= 0 ? ( $row['pri_tax'] > 0 ? show_price($row['pri_tax']) : '√' ) : '' ) ), array('c#title', 'c#value', 'c#title', 'c#value') ); $pairs = array(); $alt = 'alt'; foreach ( $prices as $price_id => $desc ) { if ( $row[$price_id] < 0 ) { continue; } $pairs[] = $desc . ':'; $pairs[] = $row[$price_id] > 0 ? show_price($row[$price_id]) # ? ( preg_match('/^(pri_air|pri_internet)/', $price_id) # ? show_price($row[$price_id]) # : show_price($row[$price_id], $country, true) # ) : '√'; if ( count( $pairs ) > 2 ) { $out .= table_tr( $alt, array('d', 'd', 'd', 'd'), $pairs, array('c#title', 'c#value', 'c#title', 'c#value') ); $pairs = array(); $alt = $alt ? '' : 'alt'; } } if ( count( $pairs ) > 0 ) { $pairs[] = $pairs[] = ''; $out .= table_tr( $alt, array('d', 'd', 'd', 'd'), $pairs, array('c#title', 'c#value', 'c#title', 'c#value') ); $alt = $alt ? '' : 'alt'; } if ( $row['pri_note'] ) { $out .= table_tr($alt, array('d', 'd'), array($lang['poznamka'].':', $row['pri_note']), array('c#title', 'l#3') ); } $out .= table_tr('alt', array('d'), array('
'), array('l#4')); } $zaloha = str_replace(array('#', '*'), array($lang['apartman_small'], $price_backup[0]), $lang['zaloha_1']); if ( $zaloha ) { $obj_charge = (int) mysql_result( mysql_query(' SELECT obj_with_charges FROM c_object `o` INNER JOIN c_apartment `a` USING (obj_id) WHERE a.apa_deleted IS NULL AND a.apa_id = ' . $apa_id ) , 0 , 0 ); $out .= table_tr(false, array('d'), array( '

' . $zaloha . ' ' . ($price_backup[1] ? $lang['pred_odjezdem'] : $lang['na_miste']) . '.

' . ( $obj_charge ? '

' . $lang['poplatky_predem'] . '

' : '' ) . '

' . $lang['Ceny_v_eurech_plati_za_osobu_a_noc'] . '

' ), array('c#text-td^l#5') ); } $out .= table_end(); return $out; } /* formular pro objednavku apartmanu */ function show_order_form($apa_id, $obj_id) { global $conf_basedir, $lang; $ext_1 = " onclick='clear_right();'"; $ext_2 = " onclick='clear_left();'"; $out .= '
'; $out .= form_start('get', $conf_basedir . '/klient/scripts/order/objednavky.php', false, false, false, 'orderForm'); $out .= form_input('hidden', '', 'apa_id', $apa_id, ' id="order-apa-id"'); $out .= form_input('hidden', '', 'yy', $_GET['yy']); $out .= table_start(false, false, false, false, false, 'accomdetails'); $out .= table_tr('alt', array('d', 'd'), array( $lang['termin'] . ':', form_input('text', 'calendar', 'od', ($_SESSION['ap'][$apa_id]['od'] ? $_SESSION['ap'][$apa_id]['od'] : $_GET['od'])) . ' - ' . form_input('text', 'calendar', 'do', ($_SESSION['ap'][$apa_id]['do'] ? $_SESSION['ap'][$apa_id]['do'] : $_GET['do'])) ), array('c#title', 'c#value^l#3') ); $out .= table_tr(false, array('d', 'd'), array( $lang['dospeli_big'] . ':', form_input('text', 'w20', 'dospeli', ($_SESSION['ap'][$apa_id]['dospeli'] ? $_SESSION['ap'][$apa_id]['dospeli'] : $_GET['dospeli'])) ), array('c#title', 'c#value^l#3') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['deti_3'] . ':', form_input('text', 'w20', 'deti_3', ($_SESSION['ap'][$apa_id]['deti_3'] ? $_SESSION['ap'][$apa_id]['deti_3'] : $_GET['deti_3'])) ), array('c#title', 'c#value^l#3') ); $out .= table_tr(false, array('d', 'd'), array( $lang['deti_12'] . ':', form_input('text', 'w20', 'deti_12', ($_SESSION['ap'][$apa_id]['deti_12'] ? $_SESSION['ap'][$apa_id]['deti_12'] : $_GET['deti_12'])) ), array('c#title', 'c#value^l#3') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['deti_18'] . ':', form_input('text', 'w20', 'deti_18', ($_SESSION['ap'][$apa_id]['deti_18'] ? $_SESSION['ap'][$apa_id]['deti_18'] : $_GET['deti_18'])) ), array('c#title', 'c#value^l#3') ); $out .= table_tr(false, array('d', 'd'), array( $lang['zvirata'] . ':', form_input('text', 'w20', 'zvirata', ($_SESSION['ap'][$apa_id]['zvirata'] ? $_SESSION['ap'][$apa_id]['zvirata'] : $_GET['zvirata'])) ), array('c#title', 'c#value^l#3') ); $out .= table_tr('alt', array('d', 'd', 'd', 'd'), array( $lang['snidane_big'] . ':', form_input('checkbox', '', 'snidane', 1, ($_SESSION['ap'][$apa_id]['snidane'] ? ' checked="checked"' : '').$ext_1, ' id="l1"'), $lang['polopenze_big'] . ':', form_input('radio', '', 'penze', 1, ($_SESSION['ap'][$apa_id]['penze'] == 1 ? ' checked="checked"' : '').$ext_2, ' id="r1"') ), array('c#title', 'c#value', 'c#title', 'c#value') ); $out .= table_tr('false', array('d', 'd', 'd', 'd'), array( $lang['obedy_big'] . ':', form_input('checkbox', '', 'obedy', 1, ($_SESSION['ap'][$apa_id]['obedy'] ? ' checked="checked"' : '').$ext_1, ' id="l2"'), $lang['plna_penze_big'].':', form_input('radio', '', 'penze', 2, ($_SESSION['ap'][$apa_id]['penze'] == 2 ? ' checked="checked"' : '').$ext_2, ' id="r2"') ), array('c#title', 'c#value', 'c#title', 'c#value') ); $out .= table_tr('alt', array('d', 'd'), array( $lang['vecere_big'] . ':', form_input('checkbox', '', 'vecere', 1, ($_SESSION['ap'][$apa_id]['vecere'] ? ' checked="checked"' : '').$ext_1, ' id="l3"'), ), array('c#title', 'c#value^l#3') ); $out .= table_tr(false, array('d', 'd'), array( $lang['poznamka'] . ':', form_textarea(false, 'poznamka', 4, ($_SESSION['ap'][$apa_id]['poznamka'] ? $_SESSION['ap'][$apa_id]['poznamka'] : $_GET['poznamka'])) ), array('c#title', 'c#value^l#3') ); if ( isset($_SESSION['ap'][$apa_id]) ) { $buttons = form_input('submit', 'btnsimple red left', 'finish', $lang['Dokoncit_objednavku'], " onclick=\"window.location.href='$conf_basedir/klient/scripts/order/kosik.php'; return false;\"") . form_input('submit', 'btnsimple blue left', 'continue', $lang['Pokracovat_ve_vyberu'], " onclick=\"window.location.href='$conf_basedir/klient/scripts/main/data_show.php?obj=obj&id=$obj_id'; return false;\"") . '
'; } else { $buttons = form_input('submit', 'btnsimple red', 'add', $lang['pridat_apartman']); } $out .= table_tr(false, array('d'), array('
' . $buttons . '
'), array('l#4^a#center^i#orderButtons')); $out .= table_end(); $out .= form_end(); return $out; } # listbox apartmanu v objektu function apartment_selector( $objId ) { global $lang, $conf_basedir; $sql = build_sql( 'apa', $objId, 'obj'); $result = MSQ_utf($sql); $out .= '
' . $lang['objednat_apartman'] . ''; $out .= '
'; while ( $row = mysql_fetch_assoc( $result ) ) { $out .= a_link( $row['apa_name'] , $conf_basedir . '/klient/scripts/main/data_show.php?obj=apa&id=' . $row['apa_id'] . '#tabs-1' , false , 'filteropen' , 'setTabCookies(1);' ); } $out .= '

'; return $out; } /* ZOBRAZOVACI CAST SKRIPTU */ require '../../../system/page_start.php'; // hlavicka stranky require '../../../system/page_body.php'; // telo stranky require '../../../system/page_end.php'; // paticka stranky vcetne uzavreni spojeni s databazi ?>