|
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 : |
<?
/**
* 회원 정보 찾기
*
* 작성일 : 20130521.허종
*/
include "../include/top_iframe.html"; //공통파일 인클루드
$href = "&tmp_layer_id={$tmp_layer_id}&search_key={$search_key}&search_word={$search_word}";
$_href = $href."&page={$page}";
//테이블명
$table = " TB_MEMBER ";
// 검색 설정
$sql_where = " and mb_id != 'click' and mb_level = 21 /*일반회원*/ and del_flag='N' ";
if($search_key and $search_word) $sql_where .= " and {$search_key} like '%{$search_word}%' ";
// 리스트 수 가져옴
$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="";
//배열에 저장
$data = array();
$data = member_fetch($sql_where,$sql_order,$olds,$line);
// 회원포인트
$class_CommonTour = new CommonTour();
?>
<div class="iframe">
<!-- 본문 -->
<!-- 폼 -->
<form name="frm_member_search" id="frm_member_search" onsubmit="return check_search();">
<input type="hidden" name="tmp_layer_id" value="<?=$tmp_layer_id?>"><!-- 레이어ID -->
<div class="pop_search_border">
<select name="search_key" id="search_key">
<option value="mb_nm" <?=($search_key=="mb_nm")?"selected":""?>>이름</option>
<option value="mb_id" <?=($search_key=="mb_id")?"selected":""?>>아이디</option>
<option value="mb_phone" <?=($search_key=="mb_phone")?"selected":""?>>핸드폰</option>
<option value="mb_tel" <?=($search_key=="mb_tel")?"selected":""?>>전화번호</option>
<option value="mb_email" <?=($search_key=="mb_email")?"selected":""?>>이메일</option>
<option value="mb_address" <?=($search_key=="mb_address")?"selected":""?>>주소</option>
</select>
<input name="search_word" id="search_word" type="text" value="<?=$search_word?>" class="input_text" hname="검색어" required /> <input type="button" value="검 색" class="Table_btn gray" onClick="check_search();" />
</div>
<div class=" mt20" style="width:100%;height:240px;overflow-y:auto;overflow-x:hidden;">
<table width="100%" border="0" cellpadding="0" cellspacing="0" summary="회원조회 결과" id="tbl_member_list" class="setting_write2">
<caption>회원조회</caption>
<colgroup>
<col />
<col style=" width:100px">
<col style=" width:50px">
<col style=" width:100px">
<col style=" width:100px">
<col style=" width:120px">
</colgroup>
<thead>
<tr>
<th>아이디</td>
<th>이름</td>
<th>성별</td>
<th>핸드폰</td>
<th>전화</td>
<th>-</td>
</tr>
</thead>
<?
If(count($data)>0){
for($i=0 ; $i<count($data) ; $i++) {
$row = $data[$i];
$data_mbpoint = $class_CommonTour->pointTotal(array("sql_where"=>" and mb_id='{$row[mb_id]}' "));
$mb_point_tot = $data_mbpoint['cur_point'];
?>
<!-- 반복 -->
<tbody>
<tr>
<td><?=$row['mb_id']?></td>
<td><?=$row['mb_nm']?></td>
<td><?=$row['mb_gend2']?></td>
<td><?=$row['mb_phone']?></td>
<td><?=$row['mb_tel']?></td>
<td align="center">
<input type="button" value="회원상세" class="Table_btn red" onClick="parent.to_dialog.ajax('../reservation/person_reserve_member_ajax.view.html?mb_id=<?=$row['mb_id']?>','회원상세보기','650','380',false,true)" />
<!-- <input type="button" value="예약내역" class="Table_btn" onClick="parent.to_dialog.ajax('../reservation/person_reserve_member_ajax.viewres.html?mb_id=<?=$row['mb_id']?>','예약내역조회','750','350',false,true)" /> -->
<input type="button" value="확인" class="Table_btn" onClick="insert_member('<?=$row['mb_id']?>','<?=$row['mb_nm']?>','<?=$row['mb_phone']?>','<?=$row['mb_tel']?>','<?=$row['mb_email']?>','<?=$row['mb_nat_cd']?>','<?=$row['resv_cnt']?>','<?=$row['mb_zipno']?>','<?=$row['mb_address1']?>','<?=$row['mb_address2']?>','<?=$mb_point_tot?>');" />
</td>
</tr>
<?}
}else{?>
<tr>
<td colspan="6" class="pop_border">:: 검색된 자료가 없습니다. ::</td>
</tr>
</tbody>
<?}?>
<!-- /반복 -->
</table>
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</form>
<!-- /폼 -->
</div>
<!-- /본문 -->
<style type="text/css">
#tbl_member_list {border:1px solid #CFCFD1;}
#tbl_member_list th{border:1px solid #CFCFD1; background-color:#F9F9F9}
#tbl_member_list td{border:1px solid #CFCFD1; padding:3px 3px 3px 3px;}
</style>
<script type="text/javascript">
function check_search()
{
if ( $("#search_word").val().length < 2 ) {
alert('검색어2자이상 입력해 주세요.');
$("#search_word").select();
return false;
}
document.frm_member_search.submit();
}
function insert_member(mb_id,mb_nm,mb_phone,mb_tel,mb_email,cust_nat_cd,resv_cnt,zipcode,address,address_d,mb_point)
{
var f = parent.document;
$("#mb_id",f).val(mb_id);
$("#cu_name",f).val(mb_nm);//예약자명
//$("#res_cust_nm").attr("readOnly",true);
$("#cu_phone",f).val(mb_phone);
$("#cu_tel",f).val(mb_tel);
$("#cu_email",f).val(mb_email);
/*
$("#cust_nat_cd").val(cust_nat_cd);
$("#lodg_history").html(resv_cnt);//숙박횟수
$("#cust_nm").val(mb_nm);
$("#cust_nat_cd").val(cust_nat_cd);
$("#zipcode").val(zipcode);
$("#address").val(address);
$("#address_d").val(address_d);
*/
// 숙박 예약폼
$("#res_cust_id",f).val(mb_id);
$("#res_cust_nm",f).val(mb_nm);//예약자명
//$("#res_cust_nm").attr("readOnly",true);
$("#hp",f).val(mb_phone);
$("#tel",f).val(mb_tel);
$("#cust_email",f).val(mb_id);
$("#cust_nat_cd",f).val(cust_nat_cd);
$("#lodg_history",f).html(resv_cnt);//숙박횟수
$("#cust_nm",f).val(mb_nm);
$("#cust_nat_cd",f).val(cust_nat_cd);
$("#zipcode",f).val(zipcode);
//$("#address").val(address);
$("#member_point",f).html(number_format(mb_point.toString()));
//창닫기
parent.to_dialog.close('<?=$tmp_layer_id?>');
}
$("#search_word").select();
</script>
<?
include "../include/footer_iframe.html";
?>