';
$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
?>