|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/res_good/ |
Upload File : |
<?php
include "../include/top.html";
//테이블명
$table = "TB_RES_BANK";
// 검색 설정
$sql_where = " ";
if($select_key and $input_key) $sql_where .= " and {$select_key} like '%{$input_key}%' ";// 검색
// 리스트 수 가져옴
$sql = "select count(*) as total from {$table} where 0=0 {$sql_where} ";
$row = db_fetch($sql);
$total = $row[total];
// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = 20; // 보여줄 갯수
$list = 10; // 블럭 갯수
$total_page = ceil($total / $line); // 총페이지
if ($total == 0) $total_page = 1; // 데이터가 하나도 없으면 총페이지 1
if ($page > $total_page) $page = $total_page; // 페이지가 전체 페이지보다 크면 페이지 번호를 바꿈
$total_list = intval($total_page / $list);
if ($total_page % $list == 0) $total_list--;
$curr_list = intval($page / $list);
if ($page % $list == 0) $curr_list--;
$start_page = $curr_list * $list + 1;
$prev_list = $start_page - $list;
$next_list = $start_page + $list;
$olds = $line * ($page - 1);
// 정렬 설정
$sql_order="";
//배열에 저장
$sql = "select * from {$table} where 1 {$sql_where} order by ins_dt desc "; // ins_dt 추가(2014-10-07)
$sql .= " limit $olds , $line";
$rs = db_query($sql);
$data = db_fetch_all($rs);
// 파라메터
$href = "select_key={$select_key}&input_key={$input_key}";
$_href = $href."page={$page}";
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title"><strong>입금예약목록</strong></div>
<div class="contents_detail">
<form name="Search_List" method="get" action="<?=$PHP_SELF?>">
<div class="c_top_bar">
<ul class="c_top_search">
<li>
<select name="select_key" id="select_key">
<option value="mb_nm" <?if($select_key=='mb_nm') echo "selected";?>>이름</option>
<option value="mb_id" <?if($select_key=='mb_id') echo "selected";?>>아이디</option>
</select>
</li>
<li>
<label for="input_key" class="v_none2">검색어 입력</label>
<input class="search_box" id="input_key" name="input_key" type="text" value="<?=$input_key?>" /><input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_btn_search" />
</li>
</ul>
</div>
</form>
<div id="Content_box">
<div class="top_txt_s">
<div class="bar_wrap">
<p class="search_result_txt member"><span><?=number_format($total)?></span><span>개의 입금목록이 있습니다.</span></p>
</div>
</div>
<form name="board_List" id="board_List" method="POST">
<input type="hidden" name="SqlType" id="SqlType" value="" />
<input type="hidden" name="BD_CD" id="BD_CD" value="<?=$BD_CD?>" />
<input type="hidden" name="mb_level" value="<?=$TK_MEMBER['mb_level']?>" />
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="board_list_tbl" class="t_list" summary="게시물을 확인하실 수 있습니다.">
<caption>게시물 확인</caption>
<colgroup>
<col style=" width:40px" />
<col style=" width:75px" />
<col style="width:95px" />
<col style=" width:110px" />
<col style=" width:120px" />
<col />
<col style=" width:110px" />
<col style=" width:140px" />
<col style=" width:100px" />
<col style=" width:110px" />
<col style=" width:60px" />
<col style=" width:140px" />
<col style=" width:115px" />
</colgroup>
<thead>
<tr>
<th scope="col">No.</th>
<th scope="col">상태</th>
<th scope="col">고객ID</th>
<th scope="col">고객명</th>
<th scope="col">바우처</th>
<th scope="col">구매상품명</th>
<th scope="col">입금은행</th>
<th scope="col">입금계좌번호</th>
<th scope="col" style="color:#0984e3;font-weight:bold">입금자명</th>
<th scope="col" style="color:#0984e3;font-weight:bold">입금액</th>
<th scope="col">예약건수</th>
<th scope="col">등록일자</th>
<th scope="col">-</th>
</tr>
</thead>
<tbody>
<?
for($i=0 ; $i < count($data) ; $i++){
$row = $data[$i];
$num = $total - $i;
$tot_pre_money = 0;
$tot_price_money = 0;
$res_good_nm = '';
$arr_t = explode(",",$row['res_info']);
for($j=0 ; $j<count($arr_t) ; $j++)
{
$arr_t2 = explode("||",$arr_t[$j]);
$tab = $arr_t2[0];
$res_no = $arr_t2[1];
$arr = reserv_tab($tab,$res_no);
$tot_pre_money += $arr['pre_money'];
$tot_price_money += $arr['price_sell_total'];
$res_good_nm[] = $arr['res_good_nm'];
}
// 상태
if($row['proc_stat']=="A") {
$stat_str = "접수";
$stat_str = "입금대기";
$stat_color = "#e0fafb";
$font_color = "#000";
} else {
$stat_str = "입금완료";
$stat_color = "#3ebde8";
$font_color = "#FFF";
}
?>
<tr <?if ( $arr['rsv_no'] =="" || $row['del_flag'] =="Y" )echo "class='cancel_line2'";?>>
<td><?=$num?></td>
<td style="background-color:<?=$stat_color?>; color:<?=$font_color?>;"><?=$stat_str?></td>
<td><?=$row['mb_id']?></td>
<td><?=$row['mb_nm']?></td>
<td><?=$arr['rsv_no']?></td>
<td onclick="to_dialog.iframe('bank_edit.html?seq=<?=$row['seq']?>','입금예약상세 - <?=$row['mb_nm']?>','600','700',true,true,'yes');" style="cursor:pointer;text-align:left; padding-left:20px;"><strong><?=implode("<br>", $res_good_nm)?></strong>
<td><?=$row['inbk_nm']?></td>
<td class="ls-1"><?=$row['inbk_num']?></td>
<td><?=$row['inbk_innm']?></td>
<td class="txt_r ls-1" style="color:#0984e3;"><strong><?=number_format($tot_price_money)?></strong></td>
<td><?=$j?></td>
<td class="ls-1"><?=$row['ins_dt']?></td>
<td>
<input type="button" class="Table_btn" value="상세" onclick="to_dialog.iframe('bank_edit.html?seq=<?=$row['seq']?>','입금예약상세 - <?=$row['mb_nm']?>','600','700',true,true,'yes');" />
<? if($row['del_flag'] == 'N') { ?>
<? } else if($row['del_flag'] == 'Y') { ?>
<? } ?>
<input type="button" class="Table_btn gray" value="취소" onclick="bank_cancel(<?=$row['seq']?>)" />
<input type="button" class="Table_btn gray" value="삭제" onclick="bank_delete(<?=$row['seq']?>)" />
</td>
</tr>
<?}?>
</tbody>
</table>
</form>
</div>
<div class="c_paging">
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
</div>
</div>
<script Language="Javascript">
function bank_cancel(seq){
var form = document.forms['board_List'];
if(!confirm('정말취소하시겠습니까?')) return;
document.location.href='bank_proc.html?SqlType=bank_cancel&seq='+seq;
}
function bank_delete(seq){
var form = document.forms['board_List'];
var mb_level = form.elements['mb_level'].value;
if(mb_level != 1) {
alert('입금내역 삭제는 최고 관리자에게 삭제 사유 제출하여 요청해주세요.');
return;
}
if(!confirm('정말삭제하시겠습니까?')) return;
document.location.href='bank_proc.html?SqlType=bank_del&seq='+seq;
}
</script>
<? include "../include/footer.html" ?>