|
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/member/ |
Upload File : |
<?
include "../include/top.html";
include "_common.php";
//테이블명
$table = " TB_MEMBER ";
// 검색 설정
$sql_where = " and mb_id != 'click' and mb_level='{$level_cd}' and del_flag='Y' ";
if($ins_dt_s and $ins_dt_e) $sql_where .= " and ins_dt between '{$ins_dt_s}' and '{$ins_dt_e}' ";//가입일
if($mb_nat_cd_s) $sql_where .= " and mb_nat_cd = '{$mb_nat_cd_s}' ";//국적
if($mb_gend_s) $sql_where .= " and mb_gend = '{$mb_gend_s}' ";//성별
if($mb_nm_s) $sql_where .= " and mb_nm like '%{$mb_nm_s}%' ";//이름
// 리스트 수 가져옴
$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=" seq desc ";
$data = array();
$data = member_fetch($sql_where,$sql_order,$olds,$line);
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<?if($level_cd == $cf['agent_level']){?>
<div class="title"><strong>탈퇴 거래처</strong></div>
<?}else if($level_cd==$cf['trade_level']){?>
<div class="title"><strong>탈퇴 공급처</strong></div>
<?}?>
<div class="contents_detail">
<!-- 폼 -->
<form name="frm_list" id="frm_list" method="get">
<div class="c_top_bar">
<ul class="c_top_search">
<li>
<label for="ins_dt_s" class="txt">가입일</label>
<label for="ins_dt_s" class="v_none2">가입일 날짜 이날부터</label>
<input name="ins_dt_s" id="ins_dt_s" type="text" class="cal_input" onclick="AjaxCal(this,event);" onkeyup="OnDateStyle(this)" value="<?=$ins_dt_s?>" readonly/> ~
<label for="ins_dt_e" class="v_none2">가입일 날짜 이날까지</label>
<input name="ins_dt_e" id="ins_dt_e" type="text" class="cal_input" onclick="AjaxCal(this,event);" onkeyup="OnDateStyle(this)" value="<?=$ins_dt_e?>" readonly/>
</li>
<li class="pl10">
<select name="mb_nat_cd_s" id="mb_nat_cd_s">
<option value="">국적</option>
<?for($i=0 ; $i < count($data_natcd) ; $i++ ){?>
<option value="<?=$data_natcd[$i]['code']?>" <?=($data_natcd[$i]['code']==$mb_nat_cd_s)?"selected":""?>><?=$data_natcd[$i]['cd_nm']?></option>
<?}?>
</select>
</li>
<li>
<select name="mb_gend_s" id="mb_gend">
<option value="">성별</option>
<option value="M" <?=($mb_gend_s=="M")?"selected":""?>>남</option>
<option value="F" <?=($mb_gend_s=="F")?"selected":""?>>여</option>
</select>
</li>
<li>
<label for="mb_nm" class="v_none2">검색어 입력</label>
<input class="search_box <?=($mb_nm_s)?"":"search_box_bg3"?>" id="mb_nm" name="mb_nm_s" type="text" value="<?=$mb_nm_s?>" onfocus="this.style.background='#ffffff url(none)'" onblur="if(this.value.length == 0) {this.style.background='#ffffff url(../image/common/search_txtbg03.gif)';this.style.backgroundRepeat='no-repeat';this.style.backgroundPosition='5px 1px';}" /><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><?=$total?></span><span class="txt">명의 회원이 검색되었습니다.</span></p>
</div>
</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list" summary="탈퇴요청한 개인회원을 확인하실 수 있습니다.">
<caption>개인회원 탈퇴요청</caption>
<colgroup>
<col style=" width:40px" />
<col style=" width:80px" />
<col />
<col style=" width:160px" />
<col style=" width:100px" />
<col style=" width:60px" />
<col style=" width:100px" />
<col style=" width:135px" />
<col style=" width:40px" />
</colgroup>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">업체구분</th>
<th scope="col">아이디</th>
<th scope="col">업체명</th>
<th scope="col">이름</th>
<th scope="col">예약수</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 - ($page - 1) * $line - $i;
?>
<tr>
<td><?=$num?></td>
<td><?=$row['bz_cd2']?></td>
<td class="mem_id"><?=$row['mb_id']?></td>
<td style="text-align:left;"><?=$row['bz_corp_nm']?></td>
<td><?=$row['mb_nm']?></td>
<td><?=$row['resv_cnt']?></td>
<td><?=$row['ins_dt2']?></td>
<td><?=$row['last_login_dt2']?></td>
<td><input type="image" src="../image/btn/btn_delete.gif" align="top" alt="삭제처리" style="cursor:pointer;" onClick="<?if($TK_MEMBER['mb_level']>'1'){?>alert('권한이없습니다.');return false;<?}?>mb_out_del('<?=$row['seq']?>','<?=$row['mb_id']?>');" /></td>
</tr>
<?}?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<script type="text/javascript">
function mb_out_del(seq,mb_id)
{
if(!confirm('완전히 삭제됩니다.'))return;
ajax_loader("member_proc.php?SqlType=mb_out_del&seq="+seq+"&mb_id="+mb_id);
}
</script>
<? include "../include/footer.html" ?>