---*/ $conn = db_connect($db_connect_str) ; if ( !$conn ) { exit ; } /*---< TOPページ設定 >---*/ if ( strlen ( $agent ) > 0 ) { $top_page = get_agent_url ( $conn, $agent ) ; $top_page = "http://210.232.177.211/askme/navi/src/tour/tour_sel_form.phtml".$top_page ; } /*---< ツアーテーブル検索 >---*/ $sql_cmd = "SELECT * FROM TOUR_TICKET WHERE " ; $sql_cmd = $sql_cmd."TOUR_CD = '$tour_cd'" ; $result = pg_Exec ( $conn, $sql_cmd ) ; if ( !$result ) { pg_FreeResult ( $result ) ; pg_Close ( $conn ) ; exit() ; } $res_num = pg_NumRows ( $result ) ; if ( $res_num > 0 ) { $tour_name = pg_Result ( $result, 0, "tour_name" ) ; $tour_sub = pg_Result ( $result, 0, "tour_sub" ) ; $recom_flg = pg_Result ( $result, 0, "recom_flg" ) ; $new_flg = pg_Result ( $result, 0, "new_flg" ) ; $start_date = pg_Result ( $result, 0, "start_date" ) ; $end_date = pg_Result ( $result, 0, "end_date" ) ; $dep_place_cd = pg_Result ( $result, 0, "dep_place_cd" ) ; $min_partnum = pg_Result ( $result, 0, "min_partnum" ) ; $air_company = pg_Result ( $result, 0, "air_company" ) ; $mileage = pg_Result ( $result, 0, "mileage" ) ; $class_cd = pg_Result ( $result, 0, "class_cd" ) ; $via = pg_Result ( $result, 0, "via" ) ; $local_tax = pg_Result ( $result, 0, "local_tax" ) ; $meal_cd = pg_Result ( $result, 0, "meal_cd" ) ; $tourcon_cd = pg_Result ( $result, 0, "tourcon_cd" ) ; $remark = pg_Result ( $result, 0, "remark" ) ; $point = pg_Result ( $result, 0, "point" ) ; $price_comment = pg_Result ( $result, 0, "price_comment" ) ; $term= pg_Result ( $result, 0, "term" ) ; $inv_comment = pg_Result ( $result, 0, "inv_comment" ); $picture = pg_Result ( $result, 0, "picture" ); $price_rank = get_tour_rank ( $conn, $tour_cd, $dep_date ) ; $tour_price = 0 ; $tour_price = get_tour_price ( $conn, $tour_cd, $price_rank ) ; $tourcon_nm = get_tourcon_nm ( $conn, $tourcon_cd ) ; $dep_place_num = str_target_num ( $dep_place_cd, "/" ) + 1 ; for ( $j=0 ; $j < $dep_place_num ; $j++ ) { $work = str_sep_target ( $dep_place_cd, "/", $j+1 ) ; $dep_place[$j] = $work ; } $air_company_num = str_target_num ( $air_company, "/" ) + 1 ; for ( $j=0 ; $j < $air_company_num ; $j++ ) { $work = str_sep_target ( $air_company, "/", $j+1 ) ; $company[$j] = $work ; } $class_nm = get_class_nm ( $conn, $class_cd ) ; for ( $i=0; $i < 15; $i++ ) { $target_date = cal_date ( $befor_dep_date, $i ) ; $arr_dep_date[$i] = $target_date ; $arr_tour_rank[$i] = get_tour_rank ( $conn, $tour_cd, $target_date ) ; $arr_tour_color[$i] = get_rank_color ( $conn, $arr_tour_rank[$i] ) ; $arr_tour_price[$i] = get_tour_price ( $conn, $tour_cd, $arr_tour_rank[$i] ) ; } $price_color[0] = get_rank_color ( $conn, "A" ) ; $price_color[1] = get_rank_color ( $conn, "B" ) ; $price_color[2] = get_rank_color ( $conn, "C" ) ; $price_color[3] = get_rank_color ( $conn, "D" ) ; $price_color[4] = get_rank_color ( $conn, "E" ) ; $price_color[5] = get_rank_color ( $conn, "F" ) ; $price_color[6] = get_rank_color ( $conn, "G" ) ; $price_color[7] = get_rank_color ( $conn, "H" ) ; $price_color[8] = get_rank_color ( $conn, "I" ) ; $price_color[9] = get_rank_color ( $conn, "J" ) ; $price_color[10] = get_rank_color ( $conn, "K" ) ; $price_color[11] = get_rank_color ( $conn, "L" ) ; $price_color[12] = get_rank_color ( $conn, "M" ) ; $price_color[13] = get_rank_color ( $conn, "N" ) ; $price_color[14] = get_rank_color ( $conn, "O" ) ; $price_color[15] = get_rank_color ( $conn, "P" ) ; $price_color[16] = get_rank_color ( $conn, "Q" ) ; $price_color[17] = get_rank_color ( $conn, "R" ) ; $price_color[18] = get_rank_color ( $conn, "S" ) ; $price_color[19] = get_rank_color ( $conn, "T" ) ; $price_color[20] = get_rank_color ( $conn, "U" ) ; $price_color[21] = get_rank_color ( $conn, "V" ) ; $price_color[22] = get_rank_color ( $conn, "W" ) ; $price_color[23] = get_rank_color ( $conn, "X" ) ; $price_color[24] = get_rank_color ( $conn, "Y" ) ; $price_color[25] = get_rank_color ( $conn, "Z" ) ; $price_type[0] = "A" ; $price_type[1] = "B" ; $price_type[2] = "C" ; $price_type[3] = "D" ; $price_type[4] = "E" ; $price_type[5] = "F" ; $price_type[6] = "G" ; $price_type[7] = "H" ; $price_type[8] = "I" ; $price_type[9] = "J" ; $price_type[10] = "K" ; $price_type[11] = "L" ; $price_type[12] = "M" ; $price_type[13] = "N" ; $price_type[14] = "O" ; $price_type[15] = "P" ; $price_type[16] = "Q" ; $price_type[17] = "R" ; $price_type[18] = "S" ; $price_type[19] = "T" ; $price_type[20] = "U" ; $price_type[21] = "V" ; $price_type[22] = "W" ; $price_type[23] = "X" ; $price_type[24] = "Y" ; $price_type[25] = "Z" ; for ( $i=0; $i < 26; $i++ ) { $work = get_tour_price ( $conn, $tour_cd, $price_type[$i] ) ; if ( strlen ( $work ) == 0 ) { $work = $space1 ; } $price[$i] = $work ; } $start_disp_year = substr ( $start_date, 0, 4 ) ; $start_disp_month = substr ( $start_date, 5, 2 ) ; $start_disp_day = substr ( $start_date, 6, 2 ) ; $end_disp_year = substr ( $end_date, 0, 4 ) ; $end_disp_month = substr ( $end_date, 5, 2 ) ; $end_disp_day = substr ( $end_date, 6, 2 ) ; } echo ""; ?> ツアー詳細結果画面
" ; $befor_dep_date = cal_date ( $dep_date, -7 ) ; $after_dep_date = cal_date ( $dep_date, 7 ) ; /*---< ツアースケジュール検索 >---*/ $sql_cmd = "SELECT * FROM TOUR_SCHEDULE WHERE TOUR_CD = '$tour_cd' ORDER BY SEQ_CD" ; $scd_res = pg_Exec ( $conn, $sql_cmd ) ; if ( !$scd_res ) { pg_FreeResult ( $result ) ; pg_FreeResult ( $scd_res ) ; pg_Close ( $conn ) ; exit () ; } $scd_num = pg_NumRows ( $scd_res ) ; /*---< ツアーホテル検索 >---*/ $sql_cmd = "SELECT * FROM TOUR_HOTEL WHERE TOUR_CD = '$tour_cd' ORDER BY SEQ_CD" ; $hotel_res = pg_Exec ( $conn, $sql_cmd ) ; if ( !$hotel_res ) { pg_FreeResult ( $result ) ; pg_FreeResult ( $hotel_res ) ; pg_Close ( $conn ) ; exit () ; } $hotel_num = pg_NumRows ( $hotel_res ) ; /*---< ツアー画像取得 >---*/ $sql_cmd = "SELECT * FROM TOUR_LINK WHERE TOUR_CD = '$tour_cd' ORDER BY SEQ_CD" ; $link_res = pg_Exec ( $conn, $sql_cmd ) ; if ( !$link_res ) { pg_FreeResult ( $link_res ) ; pg_Close ( $conn ) ; exit() ; } $link_num = pg_NumRows ( $link_res ) ; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
ツアー詳細データ"; echo ""; echo " "; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
ツアーコード:".$tour_cd."
"; if ($recom_flg == "1"){ echo ""; } echo "".$tour_name."
"; echo "
".$tour_sub."
 
"; echo ""; echo ""; echo ""; $inv_comment = str_replace ( "\n", "
", $inv_comment ) ; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
".$inv_comment."
 
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
ツアースケジュール 機内食 朝食 昼食 夕食
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ( $i = 0; $i < $scd_num; $i++ ) { $seq_cd = pg_Result ( $scd_res, $i, "seq_cd" ); $schedule = pg_Result ( $scd_res, $i, "schedule" ); $inflight = pg_Result ( $scd_res, $i, "inflight" ) ; $breakfast = pg_Result ( $scd_res, $i, "breakfast" ) ; $lunch = pg_Result ( $scd_res, $i, "lunch" ) ; $dinner = pg_Result ( $scd_res, $i, "dinner" ) ; $city_nm = pg_Result ( $scd_res, $i, "city_nm" ) ; $schedule = str_replace ( "\n", "
", $schedule ) ; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
日程スケジュール食事宿泊地
".$seq_cd."".$schedule.""; if ( strcmp ( $inflight, "1" ) == 0 ) { echo ""; } else { echo ""; } if ( strcmp ( $breakfast, "1" ) == 0 ) { echo ""; } else { echo ""; } if ( strcmp ( $lunch, "1" ) == 0 ) { echo ""; } else { echo ""; } if ( strcmp ( $dinner, "1" ) == 0 ) { echo ""; } else { echo ""; } echo "".$city_nm."
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
ご利用予定宿泊施設
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
宿泊地宿泊条件ホテル名
"; echo ""; for ( $i = 0; $i < $hotel_num; $i++ ) { $seq_cd = pg_Result ( $hotel_res, $i, "seq_cd" ); $place = pg_Result ( $hotel_res, $i, "place" ); $accom_cd = pg_Result ( $hotel_res, $i, "accom_cd" ); $grade_cd = pg_Result ( $hotel_res, $i, "grade_cd" ); $category_cd = pg_Result ( $hotel_res, $i, "category_cd" ); $roomtype_cd = pg_Result ( $hotel_res, $i, "roomtype_cd" ); $usetype_cd = pg_Result ( $hotel_res, $i, "usetype_cd" ); $hotel_nm = pg_Result ( $hotel_res, $i, "hotel_nm" ); echo ""; echo ""; echo ""; echo ""; $hotel_nm = str_replace("\n", "
", $hotel_nm); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
".$place."施設タイプ".get_accom_nm($conn, $accom_cd)."".$hotel_nm."
施設グレード".get_grade_nm($conn, $grade_cd)."
部屋カテゴリ".get_hotel_category($conn, $category_cd)."
部屋タイプ".get_roomtype($conn, $roomtype_cd)."
利用形態".get_hotel_usetype($conn, $usetype_cd)."
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
ツアー条件
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ( $local_tax == 0 ) { $tax_nm = "含まない"; } else { $tax_nm = "含む"; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $remark = str_replace ( "\n", "
", $remark ) ; echo ""; echo ""; echo "
出発地"; for ( $j=0; $j < $dep_place_num ; $j++ ) { echo get_dep_place ( $conn, $dep_place[$j] ) ; echo $space1; } echo "
最少催行人数".$min_partnum."人
添乗員".$tourcon_nm."
ご利用予定エアライン"; for ( $j=0; $j < $air_company_num ; $j++ ) { echo get_air_comp_nm ( $conn, $company[$j] ) ; echo $space1; } echo "
マイレージ"; if ( $mileage == 0 ) { echo "無し"; } else { echo "有り"; } echo "
座席クラス".$class_nm."
経由".get_via_nm($conn, $via)."
食事条件".get_meal_nm($conn, $meal_cd)."
現地税".$tax_nm."
備考".$remark."
"; echo "
" ; /*----< 料金表出力 >---*/ echo "" ; echo "" ; echo ""; echo ""; echo "" ; echo "
ツアー料金表
" ; echo "" ; echo "" ; for ( $i=0; $i < 11; $i++ ) { echo "" ; } echo "" ; for ( $i=0; $i < 11; $i++ ) { echo "" ; } echo "" ; for ( $i=11; $i < 22; $i++ ) { echo "" ; } echo "" ; for ( $i=11; $i < 22; $i++ ) { echo "" ; } echo "" ; for ( $i=22; $i < 26; $i++ ) { echo "" ; } echo "" ; for ( $i=22; $i < 26; $i++ ) { echo "" ; } echo "" ; echo "
" ; echo $font2.$price_type[$i].$f_close ; echo "
" ; echo $font2.$price[$i].$f_close ; echo "
" ; echo $font2.$price_type[$i].$f_close ; echo "
" ; echo $font2.$price[$i].$f_close ; echo "
" ; echo $font2.$price_type[$i].$f_close ; echo "
" ; echo $font2.$price[$i].$f_close ; echo "
" ; echo "
" ; echo "
" ; echo "" ; echo "" ; echo ""; echo ""; echo "" ; echo "
問合せ・申込みは、カレンダーの日付をクリックして下さい。クリックできない場合はお見積もり依頼又はお電話にてお問合せください。
" ; echo "" ; $end_flg = 0 ; $now_year = $start_disp_year ; $j = 0 ; while (1) { echo "" ; for ( $i=0; $i < 4 ; $i++ ) { $now_month = $start_disp_month + $j ; if ( $now_month > 12 ) { $now_month = 1 ; $start_disp_month = 1 ; $j = 0 ; $now_year++ ; } if ( ($now_year == $end_disp_year && $now_month > $end_disp_month) || ($now_year > $end_disp_year) ) { $end_flg = 1 ; break ; } $j++ ; echo "" ; } echo "" ; echo "" ; echo "" ; if ( $end_flg == 1 ) { if ( $line_num < 5 ) { echo "" ; for ( $k=0; $k < 7; $k++ ) { echo ""; } echo "" ; } break ; } } echo "
" ; $tmp = getdate(mktime(0,0,0,(int)$now_month,1,(int)$now_year)); /* 当月の初めの日時を取得*/ $first_mday = $tmp[wday]; /*今月一日の曜日*/ $now_day = 1; /*現在作画している日*/ echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; /* 日にちの作画スタート */ $line_num = 0 ; for($k = 0; $k < $first_mday; $k++){ /* 一日の曜日まで作画位置をずらす */ echo ""; } while(checkdate((int)$now_month,$now_day,(int)$now_year)){ $n_day = sprintf ( "%02d", $now_day ) ; $n_month = sprintf ( "%02d", $now_month ) ; $n_date = $now_year."/".$n_month."/".$n_day ; $p_rank = get_tour_rank ( $conn, $tour_cd, $n_date ) ; $p_color = get_rank_color ( $conn, $p_rank ) ; echo ""; $now_day++; $first_mday++; if(($first_mday % 7)==0){ /* 現在、土曜日なので改行 */ $first_mday = 0; echo ""; if ( checkdate((int)$now_month,$now_day,(int)$now_year) ) { $line_num++ ; } echo ""; } } /* 日にちの作画の終了 */ while($first_mday == 6){ /* カレンダーが埋まるまで位置をずらす */ echo ""; $first_mday++; } echo "" ; if ( $line_num < 5 ) { echo "" ; for ( $k=0; $k < 7; $k++ ) { echo ""; } echo "" ; } echo "
" ; echo "".$now_month.$f_close ; echo "
".$font2."".$f_close.$f_close."".$font2."".$f_close."".$font2."".$f_close."".$font2."".$f_close."".$font2."".$f_close."".$font2."".$f_close."".$font2."".$f_close.$f_close."
"; if ( strlen ( $p_rank ) > 0 ) { echo "" ; echo $font2.$now_day.$f_close ; echo "" ; } else { echo $font2.$now_day.$f_close ; } echo "
".$font2.$p_rank.$f_close ; echo "
" ; echo "
".$space1."
" ; /*---< 備考出力 >---*/ echo ""; echo ""; echo ""; echo ""; echo ""; echo "
料金備考
"; echo ""; echo ""; $price_comment = str_replace ( "\n", "
", $price_comment ) ; echo ""; echo ""; echo "
".$price_comment."
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
ツアー写真
"; echo ""; for($i=0; $i < $link_num; $i++){ $link_comment = pg_Result ( $link_res, $i, "comment" ) ; $link_url = pg_Result ( $link_res, $i, "url" ) ; echo ""; echo ""; echo ""; echo ""; } echo "
".$link_comment."
"; echo "
"; /*---< 見出し出力 >---*/ echo "" ; echo "" ; echo "" ; echo "" ; echo "
" ; echo ""; echo " "; echo "
" ; if ( strlen ( $agent ) == 0 ) { company_pr_disp ( "../../" ) ; } pg_FreeResult ( $result ) ; pg_FreeResult ( $scd_res ) ; pg_FreeResult ( $hotel_res ) ; pg_FreeResult ( $link_res ) ; pg_Close ( $conn ) ; ?>