|
include "../com/l_menu02.html";?>
include "../com/lt_quick.html";?>
|
 |
Home > ¼÷¼Ò»óǰ > =$areaname;?> |
|
|
|
include "../pro_com/refund_ld.html";?>
|
|
|
if ($scodeno == 'all') { ?>
+ ¼÷¹ÚÁö Àüüº¸±â
} else { ?>
+ ¼÷¹ÚÁö Àüüº¸±â
} ?>
|
if ($scodeno == '002') { ?>
- Á¦ÁÖµµ È£ÅÚ/¸®Á¶Æ®
} else { ?>
- Á¦ÁÖµµ È£ÅÚ/¸®Á¶Æ®
} ?>
|
if ($scodeno == '001') { ?>
- Á¦ÁÖµµÆæ¼Ç
} else { ?>
- Á¦ÁÖµµÆæ¼Ç
} ?>
|
if ($tmp_temaname1 == 'TE001') { ?>
- ´ÜüÇü °´½Ç
} else { ?>
- ´ÜüÇü °´½Ç
} ?>
|
|
if ($tmp_temaname2 == 'TE002') { ?>
- ¹Ù´ÙÀü¸Á ¼÷¼Òº¸±â
} else { ?>
- ¹Ù´ÙÀü¸Á ¼÷¼Òº¸±â
} ?>
|
if ($tmp_temaname3 == 'TE003') { ?>
- Å볪¹«Çü Ææ¼Ç
} else { ?>
- Å볪¹«Çü Ææ¼Ç
} ?>
|
if ($tmp_temaname4 == 'TE004') { ?>
- ¼ö¿µÀå ÀÖ´Â Ææ¼Ç
} else { ?>
- ¼ö¿µÀå ÀÖ´Â Ææ¼Ç
} ?>
|
if ($tmp_temaname5 == 'TE005') { ?>
- ·°¼Å¸®¼÷¼Ò(°í±Þ¼÷¼Ò)
} else { ?>
- ·°¼Å¸®¼÷¼Ò(°í±Þ¼÷¼Ò)
} ?>
|
|
if ($tmp_temaname6 == 'TE006') { ?>
- µ¶Ã¤Çü(´Üµ¶Çü)Ææ¼Ç
} else { ?>
- µ¶Ã¤Çü(´Üµ¶Çü)Ææ¼Ç
} ?>
|
if ($tmp_temaname7 == 'TE007') { ?>
- ÀÚÄíÁö,¿ùÇ®Ææ¼Ç
} else { ?>
- ÀÚÄíÁö,¿ùÇ®Ææ¼Ç
} ?>
|
if ($tmp_temaname8 == 'TE008') { ?>
- Àú°¡Çü ÀÌ»ö¼÷¼Ò
} else { ?>
- Àú°¡Çü ÀÌ»ö¼÷¼Ò
} ?>
|
if ($tmp_temaname9 == 'TE009') { ?>
- Á¶½Ä¹«·áÁ¦°ø ¼÷¼Ò
} else { ?>
- Á¶½Ä¹«·áÁ¦°ø ¼÷¼Ò
} ?>
|
|
if ($tmp_temaname11 == 'TE011') { ?>
- ½ÅÃà¼÷¼Ò
} else { ?>
- ½ÅÃà¼÷¼Ò
} ?>
|
|
Áö¿ªÀ» º¯°æÇϽǰæ¿ì¿¡´Â "¼÷¹ÚÀÏÀÚ"¸¦ ¹Ýµå½Ã Àç°Ë»ö ÇÏ¼Å¾ß ÇÕ´Ï´Ù. |
|
if ($scodeno == 'all') { ?>
} else { ?>
 |
} ?>
if ($typeno == '002') { ?>
} else { ?>
} ?>
|
if ($typeno == '001') { ?>
} else { ?>
} ?>
|
if ($typeno == '004') { ?>
} else { ?>
} ?>
|
if ($typeno == '003') { ?>
} else { ?>
} ?>
|
 |
if (Trim($sh)) {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_NAME LIKE '%$sh%'";
} else {
if (Trim($typeno)) {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." SUBSTRING(AIP_YTYPE,1,2) = 'SY' AND SUBSTRING(AIP_YTYPE,3,5) = '$typeno'";
}
if (Trim($scodeno)) {
if (Trim($scodeno) == '002') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_SCODE != '001'";
} else if (Trim($scodeno) == '001') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_SCODE = '001'";
}
}
if (Trim($keyword) == "È£ÅÚ") {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_SCODE = '002'";
}
if (Trim($keyword) == "¸®Á¶Æ®") {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_SCODE = '003'";
}
if (Trim($tmp_temaname1) == 'TE001') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA1 = '$tmp_temaname1'";
} else if (Trim($tmp_temaname2) == 'TE002') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA2 = '$tmp_temaname2'";
} else if (Trim($tmp_temaname3) == 'TE003') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA3 = '$tmp_temaname3'";
} else if (Trim($tmp_temaname4) == 'TE004') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA4 = '$tmp_temaname4'";
} else if (Trim($tmp_temaname5) == 'TE005') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA5 = '$tmp_temaname5'";
} else if (Trim($tmp_temaname6) == 'TE006') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA6 = '$tmp_temaname6'";
} else if (Trim($tmp_temaname7) == 'TE007') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA7 = '$tmp_temaname7'";
} else if (Trim($tmp_temaname8) == 'TE008') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA8 = '$tmp_temaname8'";
} else if (Trim($tmp_temaname9) == 'TE009') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA9 = '$tmp_temaname9'";
} else if (Trim($tmp_temaname11) == 'TE011') {
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_TEMA11 = '$tmp_temaname11'";
}
}
if($where == '') { $where = $where." WHERE "; }else{ $where = $where." AND "; }
$where = $where." AIP_YN = 'Y'";
//Àüü ·¹ÄÚµå¼ö
$query = "SELECT COUNT(*) AS CNT from AQU_lODGINGPRODUCT $where";
$result = mysql_query($query,$G_CONNECT);
$total_record = mysql_result($result,0,0);
//ÇÑ ÆäÀÌÁö´ç Ãâ·ÂÇÒ ¼ö
$num_per_page = 150;
//ÇÑ ºí·°´ç Ãâ·ÂÇÒ À̵¿ ÆäÀÌÁöÀÇ °¹¼ö
$page_per_block = 8;
//ÇöÀç ÆäÀÌÁö
if($page == '') $page = 1;
//Àüü ÆäÀÌÁö¼ö
$total_page = ceil($total_record/$num_per_page);
//ÀüüÆäÀÌÁö¼ö º¸´Ù ÇöÀçÆäÀÌÁö°¡ Å©´Ù¸é ÀüüÆäÀÌÁö¼ö·Î ¼³Á¤
if($total_page < $page) {
$page = $total_page;
}
if($total_page == 0) {
$page = 1;
}
//ÃÑ ºí·°¼ö
$total_block = ceil($total_page/$page_per_block);
$block = ceil($page/$page_per_block);
$first_page = ($block-1)*$page_per_block;
$last_page = $block*$page_per_block;
if($total_block <= $block) {
$last_page = $total_page;
}
//ÁöÁ¤ÇÑ ÆäÀÌÁö¿¡ ´ëÇÏ¿© Ãâ·ÂÇÒ ·¹ÄÚµå ¹øÈ£ÀÇ ¹üÀ§ °áÁ¤
if($total_record == 0) {
$first = 1;
$last = 0;
}else {
$first = $num_per_page*($page-1);
$last = $num_per_page*$page;
}
//¸ñ·ÏÀ» ²¨³»¿Â´Ù.
$query = "SELECT * FROM AQU_lODGINGPRODUCT $where ORDER BY AIP_RC DESC limit $first, $num_per_page";
$result = mysql_query($query,$G_CONNECT);
$curr_row_cnt = mysql_num_rows($result); //ÇöÀç ÆäÀÌÁö¿¡¼ º¸¿©ÁÙ ·¹ÄÚµå ¼ö(À§ Äõ¸® °á°ú ¼ö)
//ÆäÀÌÁö¸¸Å ¸ñ·Ï ¾²±â
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$fname = $G_VIEW_PD.$row[AIP_IMAGE]; $sprno = $row[AIP_NUM];
//Áö¿ª¸íĪ
$tmp_ytypename = '';
if ($row[AIP_YTYPE] == 'SY001') {
$tmp_ytypename = 'Á¦ÁֽñÇ';
} else if ($row[AIP_YTYPE] == 'SY002') {
$tmp_ytypename = '¼±ÍÆ÷.Áß¹®';
} else if ($row[AIP_YTYPE] == 'SY003') {
$tmp_ytypename = '¼ºÎÁö¿ª';
} else if ($row[AIP_YTYPE] == 'SY004') {
$tmp_ytypename = 'µ¿ºÎÁö¿ª';
}
//À¯Çü¸íĪ
$tmp_stypename = '';
if ($row[AIP_SCODE] == '001') {
$tmp_stypename = 'Ææ¼Ç';
} else if ($row[AIP_SCODE] == '002') {
$tmp_stypename = 'È£ÅÚ';
} else if ($row[AIP_SCODE] == '003') {
$tmp_stypename = '¸®Á¶Æ®';
} else if ($row[AIP_SCODE] == '004') {
$tmp_stypename = 'Äܵµ';
}
?>
=$tmp_ytypename;?> | =$tmp_stypename;?>
echo rfn_kstrcut($row[AIP_NAME], 25, '...');?>
|
|
* ¿¬ÈޱⰣ¿¡´Â 2¹ÚÀÌ»ó¸¸ ¿¹¾à °¡´É ÇÕ´Ï´Ù.
=$row[AIP_SPETXT];?> |
¿¹¾àÇϽм÷¼Ò°¡ ¸¶°¨µÉ¼ö ÀÖÀ¸´Ï ¿øÇϽô ¼÷¼Ò 2~3±ºµ¥ ´õ º¸½Ã°í ¿¹¾àÇϽǶ§ ¹®ÀÇ»çÇ× ¶õ¿¡
¼÷¼Ò¸íÀ» Àû¾î ÁÖ½Ã¸é ¿¹¾à °¡´É ¿©ºÎ È®ÀÎÇØ µå¸³´Ï´Ù. |
| °´½Ç¸í |
±âÁØ/ÃÖ´ë |
°´½Ç¼ö |
¼÷¹Ú |
ÃÑÆÇ¸Å°¡ |
¿¹¾à |
$query1 = "SELECT AID_AIPNUM, AID_NUM, AID_NAME, AID_STANDARDCNT, AID_MAXCNT, AID_ADULTPAY, AID_CHILDPAY FROM AQU_lODGINGPRDINDIVIDUAL
WHERE AID_YN = 'Y' AND AID_AIPNUM = '$sprno' ORDER BY AID_ORDER ASC";
$result1 = mysql_query($query1,$G_CONNECT);
//µ¥ÀÌŸ ²¨³»¿À±â
while($row1 = mysql_fetch_array($result1,MYSQL_ASSOC)) {
$sprno = $row1[AID_AIPNUM]; $spd = $row1[AID_NUM]; $dname = $row1[AID_NAME];
$standardcnt = $row1[AID_STANDARDCNT]; $maxcnt = $row1[AID_MAXCNT];
$tmp_price_add1 = $row1[AID_ADULTPAY]; //¼ºÀÎÃß°¡¿ä±Ý
$tmp_price_add2 = $row1[AID_CHILDPAY]; //¼ÒÀÎÃß°¡¿ä±Ý
//¼÷¹Ú¿©Çà»óǰ °¡°Ý°è»ê¼ÂÆÃ
lo_setRsvConfig('LO', $sprno, $spd, $tmp_sdate, $adultcnt, $childcnt, $usingday);
//¼÷¼ÒÃß°¡¿ä±Ý °è»ê ½ÃÀÛ
$add_total = $adultcnt + $childcnt; //ÃÑÀοø
$addnum = $add_total-$standardcnt*$cnt; //Ãß°¡Àοø
If ($addnum <= 0) {
$addmoney = 0; //Ãß°¡ÀοøÀÌ ¾øÀ»°æ¿ì
} else {
If ($adultcnt > $standardcnt*$cnt) {
$addmoney = ($adultcnt-$standardcnt*$cnt)*$tmp_price_add1 + $childcnt*$tmp_price_add2;
} else {
$addmoney = $addnum*$tmp_price_add2;
}
}
//¼÷¼ÒÃß°¡¿ä±Ý °è»ê ³¡
$tmp_addprice = $addmoney * $usingday; //Ãß°¡¿ä±Ý
$tmp_discountprice = (rfn_getRsvDiscountPriceLO() * $cnt) + $tmp_addprice; //ÇÒÀαݾ×
$tmp_priceynlo = rfn_getPRICEYNLO(); //¹Ì¿ä±ÝÀ¯¹«
?>
| =$dname;?> |
=$standardcnt;?>/=$maxcnt;?> |
=$cnt;?>½Ç |
=$usingday;?>¹Ú |
if ($tmp_priceynlo == "Y") { ?>
Àüȹ®ÀÇ |
 |
} else { ?>
¿ø |
 |
} ?>
} ?>
|
| |
} ?>
if($curr_row_cnt==0) { ?>
| °Ë»öµÈ ¼÷¹Ú»óǰÀÌ ¾ø½À´Ï´Ù. |
| |
} ?>
if($block > 1) { $my_page = $first_page; echo" "; }else{ echo" "; } ?>
if($page > 1) { $my_page = $page - 1; echo" "; }else{ echo" "; } ?>
|
for($i = $first_page+1; $i <= $last_page ; $i++) {
if($i == $page) {
?>
echo $i;?> .
} else { ?>
echo $i;?> if ($last_page != $i) { ?> . } ?>
} ?>
}
?>
|
//´ÙÀ½
if($page < $total_page)
{
$my_page = $page + 1;
echo" ";
}else{
echo" ";
}
?>
//ºí·°Ç¥Çö - ´ÙÀ½*°³
if($block < $total_block)
{
$my_page = $last_page+1;
echo" ";
}else{
echo" ";
}
?>
|
|
|