대관신청
신청자 정보
신청자
연락처
신청 현황
list_rec_cnt > 0)
{
$num = $cls_board->list_rec_cnt;
$_l = $cls_board->get_list("seq_rt DESC");
for ($i = 0; $i < count($_l); $i++)
{
foreach($_l[$i] as $k => $v) $_l[$i][$k] = stripslashes($v);
if ($_l[$i]['status']=="w") {
$status = "예약";
$stat_color = "doing";
} else if ($_l[$i]['status']=="r") {
$status = "완료";
$stat_color = "complete";
} else if ($_l[$i]['status']=="c") {
$status = "취소";
$stat_color = "";
}
//예약 상황
$sql = "SELECT
COUNT(seq_rt) AS tn,
(SELECT COUNT(seq_rt) FROM RT_RENTAL_DATA WHERE seq_rt=".$_l[$i]['seq_rt']." AND STATUS='O') AS so,
(SELECT COUNT(seq_rt) FROM RT_RENTAL_DATA WHERE seq_rt=".$_l[$i]['seq_rt']." AND STATUS='X') AS sx,
(SELECT COUNT(seq_rt) FROM RT_RENTAL_DATA WHERE seq_rt=".$_l[$i]['seq_rt']." AND STATUS='R') AS sr
FROM RT_RENTAL_DATA
WHERE seq_rt=".$_l[$i]['seq_rt'];
$_t = $dbo->fetch($sql);
$so_str = ($_t['so'] > 0) ? " / 입실처리 ".$_t['so']."일" : "";
$sx_str = ($_t['sx'] > 0) ? " / 미입실 ".$_t['sx']."일" : "";
$gubun = ($_l[$i]['gubun_en']=="N") ? "일반예약":"정기예약";
?>
예약신청 |
||
|---|---|---|
예약시간 |
fetch_list("SELECT * FROM RT_RENTAL_DATA WHERE seq_rt='".$_l[$i]['seq_rt']."' ORDER BY rvdt_d ASC");
if (count($_s) > 0) {
for ($m = 0; $m < count($_s); $m++){
$tmarr[$_s[$m]['seq_rp']][] = ($_s[$m]['rvdt_h'] < 10)?"0".$_s[$m]['rvdt_h']:$_s[$m]['rvdt_h'];
}
}
echo " ";
foreach ($tmarr as $k => $v) {
if ($tmarr[$k]) {
$place_nm = $place_arr[$k];
$newarr = null;
sort($v);
for ($aa = 0; $aa < count($v); $aa++) {
$newarr[] = ($v[$aa] < 10)?$v[$aa].":00":$v[$aa].":00";
}
}
$time_str = implode(" , ", $newarr);
echo $place_nm." ".$time_str." |
|
이용상황 |
총 일 예약 / 잔여 일 |
데이터가 없습니다