include( "../../../lib/ticketlib.phtml" ) ?> include( "../../../lib/navilib.phtml" ) ?> include( "../../../lib/listlib.phtml" ) ?> include( "../../../lib/getlib.phtml" ) ?>
/*---< DBコネクト >---*/ $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 ""; ?>