|
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/reservation/ |
Upload File : |
<?
/**
* 회원 정보 찾기
*
* 작성일 : 20130521.허종
*/
include "../include/top_proc.html"; //공통파일 인클루드
$data = array();
//$search_word = "이순";//테스트
$sql_where = " and mb_level='21' ";
if($search_key and $search_word) {
$sql_where .= " and {$search_key} like '%{$search_word}%' ";
$data = member_fetch($sql_where);
}
?>
<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 -->
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="10" align="center"> </td>
</tr>
<tr>
<td height="40" align="center" class="pop_search_border">
<select name="search_key" id="search_key" style="height:18px;">
<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?>" size="20" class="input_text" hname="검색어" required /> <input type="button" value="검 색" class="btn_green_left" onClick="check_search();" /><span class="btn_green_right"></span>
</td>
</tr>
<tr>
<td height="10" align="center"></td>
</tr>
<tr>
<td>
<!-- 검색결과 -->
<?if($search_key){?>
<div style="width:100%;height:240px;overflow-y:auto;overflow-x:hidden;">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" summary="회원조회 결과" id="tbl_member_list">
<caption>회원조회</caption>
<tr height="30">
<th width="80" >아이디</td>
<th width="70" >이름</td>
<th width="90" >핸드폰</td>
<th width="90" >전화</td>
<th width="170" >-</td>
</tr>
<?
If(count($data)>0){
for($i=0 ; $i<count($data) ; $i++) {
$row = $data[$i];
?>
<!-- 반복 -->
<tbody>
<tr height="25" >
<td><?=$row['mb_id']?></td>
<td><?=$row['mb_nm']?></td>
<td><?=$row['mb_phone']?></td>
<td><?=$row['mb_tel']?></td>
<td align="center">
<input type="button" value="회원상세" class="btn_gray_left" onClick="to_dialog.ajax('person_reserve_member_ajax.view.html?mb_id=<?=$row['mb_id']?>','회원상세보기','650','380',false,true)" /><span class="btn_gray_right"></span>
<!-- <input type="button" value="예약내역" class="btn_orange_left" onClick="to_dialog.ajax('person_reserve_member_ajax.viewres.html?mb_id=<?=$row['mb_id']?>','예약내역조회','750','350',false,true)" /><span class="btn_orange_right"></span> -->
<input type="button" value="확인" class="btn_green_left" 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']?>');" /><span class="btn_green_right"></span>
</td>
</tr>
<? }
}else{?>
<tr>
<td colspan="5" height="50" class="pop_border">:: 검색된 자료가 없습니다. ::</td>
</tr>
</tbody>
<?}?>
<!-- /반복 -->
</table>
</div>
<?}?>
<!-- /검색결과 -->
</td>
</tr>
<tr>
</table>
</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;
}
ajax_post("<?=$tmp_layer_id?>","../reservation/person_reserve_member_ajax.html","frm_member_search");
return false;
}
function insert_member(mb_id,mb_nm,mb_phone,mb_tel,mb_email,cust_nat_cd,resv_cnt,zipcode,address,address_d)
{
$("#res_cust_id").val(mb_id);
$("#res_cust_nm").val(mb_nm);//예약자명
//$("#res_cust_nm").attr("readOnly",true);
$("#hp").val(mb_phone);
$("#tel").val(mb_tel);
$("#cust_email").val(mb_id);
$("#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);
//창닫기
to_dialog.close('<?=$tmp_layer_id?>');
}
$("#search_word").select();
</script>