" ; /*---< DBコネクト >---*/ $conn = db_connect($db_connect_str) ; if ( !$conn ) { exit ; } /*---< ＴＯＰページ設定 >---*/ if ( strlen ( $agent ) > 0 ) { $top_page = get_agent_url ( $conn, $agent ) ; $top_page = "http://".$top_page ; } if ($year_f == ""){ $year_f = date("Y"); } if ($month_f == ""){ $month_f = date("m"); } if ($day_f == ""){ $day_f = date("d"); } $year_f = sprintf ( "%04d", $year_f ) ; $month_f = sprintf ( "%02d", $month_f ) ; $day_f = sprintf ( "%02d", $day_f ) ; $dep_date = $year_f."/".$month_f."/".$day_f ; $befor_dep_date = cal_date ( $dep_date, -7 ) ; $after_dep_date = cal_date ( $dep_date, 7 ) ; if ( strlen ( $price_f ) > 0 ) { if ( strlen ( $price_hani_f ) > 0 ) { $work_price1 = (int)$price_f + (int)$price_hani_f ; $work_price2 = (int)$price_f - (int)$price_hani_f ; } else { $work_price1 = (int)$price_f * 1.2 ; $work_price2 = (int)$price_f * 0.8 ; } } /*---< 目的地ＳＱＬ作成 >---*/ $sql_place_1 = "" ; $sql_place_2 = "" ; $sql_place_3 = "" ; $place_flg = 0 ; if ( strlen ( $area_cd_l_1f ) > 0 || strlen ( $area_cd_m_1f ) > 0 || strlen ( $area_cd_s_1f ) > 0 ) { if ( strlen ( $area_cd_l_1f ) > 0 ) { $sql_place_1 = $sql_place_1."AREA_CD_L = '$area_cd_l_1f' " ; $place_flg = 1 ; } if ( strlen ( $area_cd_m_1f) > 0 ) { if ( $place_flg == 1 ) { $sql_place_1 = $sql_place_1."AND AREA_CD_M = '$area_cd_m_1f' " ; } else { $sql_place_1 = $sql_place_1."AREA_CD_M = '$area_cd_m_1f' " ; $place_flg = 1 ; } } if ( strlen ( $area_cd_s_1f ) > 0 ) { if ( $place_flg == 1 ) { $sql_place_1 = $sql_place_1."AND AREA_CD_S = '$area_cd_s_1f' " ; } else { $sql_place_1 = $sql_place_1."AREA_CD_S = '$area_cd_s_1f' " ; } } } $place_flg = 0 ; if ( strlen ( $area_cd_l_2f ) > 0 || strlen ( $area_cd_m_2f ) > 0 || strlen ( $area_cd_s_2f ) > 0 ) { if ( strlen ( $area_cd_l_2f ) > 0 ) { $sql_place_2 = $sql_place_2."AREA_CD_L = '$area_cd_l_2f' " ; $place_flg = 1 ; } if ( strlen ( $area_cd_m_2f) > 0 ) { if ( $place_flg == 1 ) { $sql_place_2 = $sql_place_2."AND AREA_CD_M = '$area_cd_m_2f' " ; } else { $sql_place_2 = $sql_place_2."AREA_CD_M = '$area_cd_m_2f' " ; $place_flg = 1 ; } } if ( strlen ( $area_cd_s_2f ) > 0 ) { if ( $place_flg == 1 ) { $sql_place_2 = $sql_place_2."AND AREA_CD_S = '$area_cd_s_2f' " ; } else { $sql_place_2 = $sql_place_2."AREA_CD_S = '$area_cd_s_2f' " ; } } } $place_flg = 0 ; if ( strlen ( $area_cd_l_3f ) > 0 || strlen ( $area_cd_m_3f ) > 0 || strlen ( $area_cd_s_3f ) > 0 ) { if ( strlen ( $area_cd_l_3f ) > 0 ) { $sql_place_3 = $sql_place_3."AREA_CD_L = '$area_cd_l_3f' " ; $place_flg = 1 ; } if ( strlen ( $area_cd_m_3f) > 0 ) { if ( $place_flg == 1 ) { $sql_place_3 = $sql_place_3."AND AREA_CD_M = '$area_cd_m_3f' " ; } else { $sql_place_3 = $sql_place_3."AREA_CD_M = '$area_cd_m_3f' " ; $place_flg = 1 ; } } if ( strlen ( $area_cd_s_3f ) > 0 ) { if ( $place_flg == 1 ) { $sql_place_3 = $sql_place_3."AND AREA_CD_S = '$area_cd_s_3f' " ; } else { $sql_place_3 = $sql_place_3."AREA_CD_S = '$area_cd_s_3f' " ; } } } /*---< ツアー目的地テーブルの検索 >---*/ $place_flg = 0 ; $sql_cmd_wk = "SELECT DISTINCT TOUR_CD FROM TOUR_ARR_PLACE " ; if ($and_f == "1"){ $and_or = "AND "; if ( strlen ( $sql_place_1 ) > 0 ) { $sql_cmd = $sql_cmd_wk."WHERE ".$sql_place_1." " ; } if ( strlen ( $sql_place_2 ) > 0 && strlen ( $sql_place_3 ) == 0) { $sql_cmd .= "AND TOUR_CD IN (".$sql_cmd_wk." WHERE ".$sql_place_2.") " ; } else if ( strlen ( $sql_place_2 ) > 0 && strlen ( $sql_place_3 ) > 0) { $sql_cmd .= "AND TOUR_CD IN (".$sql_cmd_wk." WHERE ".$sql_place_2." " ; $sql_cmd .= "AND TOUR_CD IN (".$sql_cmd_wk." WHERE ".$sql_place_3.")) " ; } if ( strlen ( $sql_cmd ) == 0 && strlen ( $tour_cd_f ) > 0 ) { $sql_cmd =$sql_cmd_wk." WHERE TOUR_CD = '$tour_cd_f' "; } else if ( strlen ( $sql_cmd ) > 0 && strlen ( $tour_cd_f ) > 0 ) { $sql_cmd =$sql_cmd." AND TOUR_CD = '$tour_cd_f' "; } } else { $and_or = "OR "; if ( strlen ( $sql_place_1 ) > 0 ) { $sql_cmd = $sql_cmd_wk."WHERE ( ".$sql_place_1." ) " ; $place_flg = 1 ; } if ( strlen ( $sql_place_2 ) > 0 ) { if ( $place_flg == 0 ) { $sql_cmd = $sql_cmd."WHERE ( ".$sql_place_2." ) " ; } else { $sql_cmd = $sql_cmd.$and_or." ( ".$sql_place_2." ) " ; } } if ( strlen ( $sql_place_3 ) > 0 ) { if ( $place_flg == 0 ) { $sql_cmd = $sql_cmd."WHERE ( ".$sql_place_3." ) " ; } else { $sql_cmd = $sql_cmd.$and_or." ( ".$sql_place_3." ) " ; } } if ( strlen ( $sql_cmd ) == 0 && strlen ( $tour_cd_f ) > 0 ) { $sql_cmd =$sql_cmd." WHERE TOUR_CD = '$tour_cd_f' "; } else if ( strlen ( $sql_cmd ) > 0 && strlen ( $tour_cd_f ) > 0 ) { $sql_cmd =$sql_cmd." AND TOUR_CD = '$tour_cd_f' "; } $sql_cmd = $sql_cmd."GROUP BY TOUR_CD" ; } if (strlen ( $sql_cmd ) == 0){ $sql_cmd = $sql_cmd_wk; if ( strlen ( $tour_cd_f ) > 0 ) { $sql_cmd =$sql_cmd." WHERE TOUR_CD = '$tour_cd_f' "; } } $arr_res = pg_Exec ( $conn, $sql_cmd ) ; if ( !$arr_res ) { pg_FreeResult ( $arr_res ) ; pg_Close ( $conn ) ; exit() ; } $arr_num = pg_NumRows ( $arr_res ) ; for ( $i = 0 ; $i < $arr_num ; $i++ ) { $tour_cd = pg_Result ( $arr_res, $i, "tour_cd" ) ; $arr_tour_cd[$i] = $tour_cd ; } pg_FreeResult ( $arr_res ); /*---< 指定された出発日＋−７日間のデータを抽出 >---*/ for ( $j=0 ; $j < $arr_num ; $j++ ) { $dep_tour_price[$j] = 0 ; } for ( $dep_tour_num=0,$i=0 ; $i < $arr_num ; $i++ ) { $sql_cmd = "SELECT * FROM TOUR_PRICE WHERE TOUR_CD = '$arr_tour_cd[$i]' AND " ; $sql_cmd = $sql_cmd."( DEP_DATE >= '$befor_dep_date' AND DEP_DATE <= '$after_dep_date' ) "; $sql_cmd = $sql_cmd."ORDER BY DEP_DATE" ; $date_res = pg_Exec ( $conn, $sql_cmd ) ; if ( !$date_res ) { pg_FreeResult ( $date_res ) ; pg_Close ( $conn ); exit() ; } $date_num = pg_NumRows ( $date_res ) ; /* if ( $date_num == 0 ) { continue ; } */ /* 2002/08/17 dep_tour_cd ->dep_tour_cd1 */ $dep_tour_cd1[$dep_tour_num] = $arr_tour_cd[$i] ; $dep_tour_num++ ; pg_FreeResult ( $date_res ) ; } /*---< 件数チェック >---*/ for ( $line_no=0,$i=0 ; $i < $dep_tour_num ; $i++ ) { $sql_cmd = "SELECT * FROM TOUR_TICKET WHERE TOUR_CD = '$dep_tour_cd1[$i]' " ; if ( strlen ( $term1_f ) > 0 ) { $sql_cmd = $sql_cmd."AND TERM >= '$term1_f' " ; } if ( strlen ( $term2_f ) > 0 ) { $sql_cmd = $sql_cmd."AND TERM <= '$term2_f' " ; } /* 2002/08/17 add dep_place_cd for search */ $place_flg = 0 ; for ( $j=0; $j < $dep_place_num_f; $j++ ) { $dep_nm = "dep_place".$j ; if ( strlen ( ${$dep_nm} ) > 0 ) { if ( $place_flg == 0 ) { $sql_cmd = $sql_cmd."AND ( DEP_PLACE_CD LIKE '%${$dep_nm}%' " ; $place_flg = 1 ; } else { $sql_cmd = $sql_cmd."OR DEP_PLACE_CD LIKE '%${$dep_nm}%' " ; } } } if ( $place_flg == 1 ) { $sql_cmd = $sql_cmd." ) " ; } $result = pg_Exec ( $conn, $sql_cmd ) ; if ( !$result ) { pg_FreeResult ( $result ) ; pg_Close ( $conn ) ; exit ( ) ; } $res_num = pg_NumRows ( $result ) ; if ( $res_num == 0 ) { continue ; } /* 2002/08/17 add dep_place_cd for search */ $dep_tour_cd[$line_no] = $dep_tour_cd1[$i] ; $line_no++ ; } echo "
"; echo "
"; echo "
★
"; echo "
ツアー検索結果一覧
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; if ($line_no == 0){ echo "
あなたの条件と一致したツアーはありませんでした。
"; echo "
さらに詳しい内容をご覧になりたい方は、「詳細」ボタンをクリックして下さい。
"; } else { echo "
あなたの条件と一致したツアーは".$line_no."件ありました。
"; echo "
さらに詳しい内容をご覧になりたい方は、「詳細」ボタンをクリックして下さい。
"; } echo "
" ; echo "
" ; /*---< 検索結果出力 >--*/ /* ページ変え処理 */ if ($sear_pt == ""){ $sear_pt = 1; } /* 2002/08/17 change $dep_tour_num -> $line_no */ search_disp($sear_pt, $line_no, "tour_sel.phtml?agent=$agent&area_cd_l_1f=$area_cd_l_1f&area_cd_m_1f=$area_cd_m_1f&area_cd_s_1f=$area_cd_s_1f&area_cd_l_2f=$area_cd_l_2f&area_cd_m_2f=$area_cd_m_2f&area_cd_s_2f=$area_cd_s_2f&area_cd_l_3f=$area_cd_l_3f&area_cd_m_3f=$area_cd_m_3f&area_cd_s_3f=$area_cd_s_3f&term1_f=$term1_f&term2_f=$term2_f&dep_place_1f=$dep_place_1f&dep_place_2f=$dep_place_2f&dep_place_3f=$dep_place_3f&dep_place_4f=$dep_place_4f&dep_place_5f=$dep_place_5f&year_f=$year_work&month_f=$month_work&day_f=$day_work&price1_f=$price1_f&price2_f=$price2_f&tour_cd_f=$tour_cd_f&and_f=$and_f&$sear_pt=$sear_pt"); $i = $sear_pt - 1 ; $end_pt = $sear_pt + $disp_search_num -1; /* 2002/08/17 change $dep_tour_num -> $line_no */ if ($end_pt >= $line_no){ $end_pt = $line_no; } for ( ; $i < $end_pt ; $i++ ) { $sql_cmd = "SELECT * FROM TOUR_TICKET WHERE TOUR_CD = '$dep_tour_cd[$i]' " ; if ( strlen ( $term1_f ) > 0 ) { $sql_cmd = $sql_cmd."AND TERM >= '$term1_f' " ; } if ( strlen ( $term2_f ) > 0 ) { $sql_cmd = $sql_cmd."AND TERM <= '$term2_f' " ; } $place_flg = 0 ; for ( $j=0; $j < $dep_place_num_f; $j++ ) { $dep_nm = "dep_place".$j ; if ( strlen ( ${$dep_nm} ) > 0 ) { if ( $place_flg == 0 ) { $sql_cmd = $sql_cmd."AND ( DEP_PLACE_CD LIKE '%${$dep_nm}%' " ; $place_flg = 1 ; } else { $sql_cmd = $sql_cmd."OR DEP_PLACE_CD LIKE '%${$dep_nm}%' " ; } } } if ( $place_flg == 1 ) { $sql_cmd = $sql_cmd." ) " ; } $result = pg_Exec ( $conn, $sql_cmd ) ; if ( !$result ) { pg_FreeResult ( $result ) ; pg_Close ( $conn ) ; exit ( ) ; } $res_num = pg_NumRows ( $result ) ; if ( $res_num == 0 ) { continue ; } $tour_cd = pg_Result ( $result, 0, "tour_cd" ) ; $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" ) ; $air_company = pg_Result ( $result, 0, "air_company" ) ; $class_cd = pg_Result ( $result, 0, "class_cd" ) ; $term = pg_Result ( $result, 0, "term" ) ; for ( $j=0; $j < 15; $j++ ) { $target_date = cal_date ( $befor_dep_date, $j ) ; $work_mon = substr ( $target_date, 5, 2 ) ; $work_day = substr ( $target_date, 8, 2 ) ; $arr_dep_date[$j] = $work_mon."月".$work_day."日" ; $arr_tour_rank[$j] = get_tour_rank ( $conn, $tour_cd, $target_date ) ; $arr_tour_color[$j] = get_rank_color ( $conn, $arr_tour_rank[$j] ) ; $arr_tour_price[$j] = get_tour_price ( $conn, $tour_cd, $arr_tour_rank[$j] ) ; $dayofweek = get_dayofweek( $target_date ) ; $dayofweek_ja = change_yobi_fetj( $dayofweek ) ; if ( strcmp ( $dayofweek_ja, "土" ) == 0 ) { $arr_tour_yobi[$j] = "(
".$dayofweek_ja.$f_close."
)"; } elseif ( strcmp ( $dayofweek_ja, "日" ) == 0 ) { $arr_tour_yobi[$j] = "(
".$dayofweek_ja.$f_close."
)"; } else { $arr_tour_yobi[$j] = "(".$dayofweek_ja.")" ; } $arr_tour_yobi_sho[$j] = "(".$dayofweek_ja.")" ; } $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 ) ; $accom_nm = get_accom_nm( $conn, $accom_cd ) ; $grade_nm = get_grade_nm ( $conn, $grade_cd ) ; echo "
"; echo "
"; $j = $i + 1 ; echo "
".$j."
"; echo "
".$tour_name.$space2."
(".$tour_cd.")
"; echo "
".$tour_sub."
"; echo "
"; echo "
"; echo "
"; if ($recom_flg == "1"){ echo "
"; } echo "
"; echo "
料金
"; echo "
".$arr_dep_date[7].$arr_tour_yobi_sho[7]."
"; echo "
"; if ( strlen ( $arr_tour_price[7] ) > 0 ) { if ( strlen ( $price1_f ) > 0 && strlen ( $price2_f) > 0 ) { if ( $price1_f > $arr_tour_price[7] || $price2_f < $arr_tour_price[7] ) { echo "
\\".$arr_tour_price[$j]."
"; } else { echo "
\\".$arr_tour_price[7]."
"; } } elseif ( strlen ( $price1_f ) == 0 && strlen ( $price2_f) > 0 ) { if ( $price2_f < $arr_tour_price[7] ) { echo "
\\".$arr_tour_price[$j]."
"; } else { echo "
\\".$arr_tour_price[7]."
"; } } elseif ( strlen ( $price1_f ) > 0 && strlen ( $price2_f) == 0 ) { if ( $price1_f > $arr_tour_price[7] ) { echo "
\\".$arr_tour_price[$j]."
"; } else { echo "
\\".$arr_tour_price[7]."
"; } } else { echo "
\\".$arr_tour_price[7]."
"; } } else { echo "
該当無し
"; } echo "
"; echo "
"; echo "
"; if ($new_flg == "1"){ echo "
"; } else { echo "
"; } echo "
ツアー期間
"; echo "
".$term."日
"; echo "
設定期間
"; echo "
".$start_date."〜".$end_date."
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
出発地
"; echo "
"; for ( $j=0; $j < $dep_place_num ; $j++ ) { echo $font2.get_dep_place ( $conn, $dep_place[$j] ) ; echo $space1.$f_close ; } echo "
"; echo "
"; echo "
"; echo "
航空会社
"; echo "
"; for ( $j=0; $j < $air_company_num ; $j++ ) { echo $font2.get_air_comp_nm ( $conn, $company[$j] ) ; echo $space1.$f_close ; } echo "
"; echo "
"; echo "
"; echo "
"; } echo "
"; /* 2002/08/17 change $dep_tour_num -> $line_no */ search_disp($sear_pt, $line_no, "tour_sel.phtml?agent=$agent&area_cd_l_1f=$area_cd_l_1f&area_cd_m_1f=$area_cd_m_1f&area_cd_s_1f=$area_cd_s_1f&area_cd_l_2f=$area_cd_l_2f&area_cd_m_2f=$area_cd_m_2f&area_cd_s_2f=$area_cd_s_2f&area_cd_l_3f=$area_cd_l_3f&area_cd_m_3f=$area_cd_m_3f&area_cd_s_3f=$area_cd_s_3f&term1_f=$term1_f&term2_f=$term2_f&dep_place_1f=$dep_place_1f&dep_place_2f=$dep_place_2f&dep_place_3f=$dep_place_3f&dep_place_4f=$dep_place_4f&dep_place_5f=$dep_place_5f&year_f=$year_work&month_f=$month_work&day_f=$day_work&price1_f=$price1_f&price2_f=$price2_f&tour_cd_f=$tour_cd_f&and_f=$and_f&$sear_pt=$sear_pt"); echo "
"; echo "
"; if ( strlen ( $agent ) == 0 ) { company_pr_disp ( "../../" ) ; } pg_FreeResult ( $result ) ; pg_Close ( $conn ) ; ?>