|
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 = 21 /*일반회원*/ and del_flag='N' ";
if($ins_dt_s and $ins_dt_e) $sql_where .= " and ins_dt between '{$ins_dt_s}' and '{$ins_dt_e}' ";// 가입일
if($search_key=="mb_address" and $search_word) {
$sql_where .= " AND ( mb_address1 like '%{$search_word}%' OR mb_address2 like '%{$search_word}%' ) ";
}else 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 = 30; // 보여줄 갯수
$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="";
#echo "$sql_where";
//배열에 저장
$data = array();
$data = member_fetch($sql_where,$sql_order,$olds,$line);
$today = date("Y-m-d");
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title"><i class="xi-user-address" style="font-size:23px; vertical-align:text-top;color:#000"></i><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);" 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);" value="<?=$ins_dt_e?>" readonly />
</li>
<li class="pl10">
<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_email" <?=($search_key=="mb_email")?"selected":""?>>이메일</option>
<option value="mb_address" <?=($search_key=="mb_address")?"selected":""?>>주소</option>
</select>
</li>
<li>
<label for="mb_nm" class="v_none2">검색어 입력</label>
<input class="search_box" id="search_word" name="search_word" type="text" value="<?=$search_word?>" 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">
<span>Total : <?=number_format($total)?>명</span>
<input class="Table_btn gray" id="btn_agent_search" onclick="location.href='person_member_out.html';" type="button" value="탈퇴고객" style="height:21px; margin-left:5px;">
</p>
<!-- 상품정렬 -->
<ul class="search_rt_btn">
<li><a href="javascript:;" class="Tbtn" onclick="to_excel('<?=urlencode($sql_where)?>','','');"><img src="../image/btn/ico_excel.gif" alt="엑셀" /> 엑셀저장</a></li>
<li><a href="javascript:;" class="Tbtn gray" onclick="send_mail();">
<i class="xi-mail-o" style="font-size:15px; vertical-align:text-top;"></i> 단체메일</a></li>
<li><a href="javascript:;" class="Tbtn gray" onclick="send_sms_pop()">
<i class="xi-comment-o" style="font-size:15px; vertical-align:text-top;"></i> 단체문자</a></li>
</ul><!-- 상품등록 -->
</div>
</div>
<!-- 폼 -->
<form name="frm_main_list" id="frm_main_list" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list" summary="개인회원 관리하실 수 있습니다.">
<caption>개인회원 관리</caption>
<colgroup>
<col style="width:50px" />
<col style="width:80px" />
<col style="width:80px" />
<col style="width:170px" />
<col style="width:170px" />
<col style="width:190px" />
<col style="" />
<col style="width:130px" />
<col style="width:60px" />
<col style="width:60px" />
<col style="width:130px" />
<col style="width:60px" />
<col style="width:130px" />
</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>
<th scope="col">SMS수신</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;
$culv = base_codec("MEM","CULV",$row['mb_cu_level']);
$culv_str = $culv[0]['cd_nm'];
$newdate = date("Y-m-d", strtotime("+3 day", strtotime($row['ins_dt_new'])));
// 회원의 언어 구분값
$mem_lang = TO_member_get_lang($row['mb_nat_cd']);
// 유입채널 아이콘
$channel_icon = TO_member_get_channel_icon($row['ins_channel'], $mem_lang);
?>
<tr>
<td><?=$num?></td>
<td><?=$culv_str?></td>
<td>
<?php
if(strpos($row['mb_id'], "bnpa_") !== false){
echo '<img src="/admin/image/partner/benepia_member.jpg">';
}else{
echo $channel_icon;
}
?>
</td>
<td class="a_name">
<a href="person_modify.html?<?=$_href?>&seq=<?=$row['seq']?>">
<?=$row['mb_nm']?>
<!--new icon -->
<?if($today >= $row['ins_dt_new'] && $today <= $newdate) : ?>
<img src="../image/new.gif">
<a>
<? endif; ?>
</td>
<td><?=$row['mb_phone']?></td>
<td class="mem_id"><a href="person_modify.html?<?=$_href?>&seq=<?=$row['seq']?>"><b><?=$row['mb_id']?></b></a></td>
<td class="txt_l pl10"><?=$row['mb_email']?></td>
<td><?=$row['ins_dt2']?></td>
<td><span id="mail_yn_<?=$row['seq']?>" style="cursor:pointer;"><img src="../image/btn/<?=$row['mb_email_yn2']?>" onClick="ajax_obj_loader('member_proc.php?SqlType=mailyn_edit&seq=<?=$row['seq']?>&mb_email_yn=<?=$row['mb_email_yn_opp']?>','mail_yn_<?=$row['seq']?>');" alt="메일보내기 여부" /></span>
</td>
<td>
<span id="sms_yn_<?=$row['seq']?>" style='cursor:pointer;'><img src="../image/btn/<?=$row['mb_sms_yn2']?>" onClick="ajax_obj_loader('member_proc.php?SqlType=smsyn_edit&seq=<?=$row['seq']?>&mb_sms_yn=<?=$row['mb_sms_yn_opp']?>','sms_yn_<?=$row['seq']?>');" alt="sms보내기 여부" /></span>
</td>
<td><?=$row['last_login_dt2']?></td>
<td><?=$row['login_cnt']?></td>
<td>
<input type="button" name="mb_out" id="mb_out" value="탈퇴" class="Table_btn" onClick="mb_del('<?=$row['seq']?>','<?=$row['mb_id']?>');" />
<input type="button" name="mb_edit" id="mb_edit" value="수정" class="Table_btn" onClick="location.href='person_modify.html?<?=$_href?>&seq=<?=$row['seq']?>'" />
<input type="button" name="mb_edit" id="mb_edit" value="문자" class="Table_btn" onClick="location.href='person_modify.html?<?=$_href?>&seq=<?=$row['seq']?>'" />
<?if($TK_MEMBER['mb_id']=='click'){?>
<input type="button" name="mb_out" id="mb_out" value="삭제" class="Table_btn" onClick="mb_out_del('<?=$row['seq']?>','<?=$row['mb_id']?>');" />
<?}?>
</td>
</tr>
<?}?>
</tbody>
</table>
</form>
<!-- /폼 -->
</div>
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
</div>
<script type="text/javascript">
function mb_del(seq,mb_id)
{
if(!confirm('탈퇴회원 목록으로 이동됩니다.'))return;
ajax_loader("member_proc.php?SqlType=mb_out&seq="+seq+"&mb_id="+mb_id);
}
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);
}
function send_mail()
{
var obj = $("input[name='mail_send[]']:checked");
var str = "";
var i=0;
to_dialog.iframe('mail_send.html?members_id='+str,'메일 보내기','1000','840',true,true,'no');
}
function send_sms_pop()
{
var obj = $("input[name='sms_send[]']:checked");
var str = "";
var i=0;
to_dialog.iframe('sms_send.html?members_seq='+str,'문자 보내기','1000','840',true,true,'no');
}
// 엑셀출력
function to_excel(sql_where)
{
if(!sql_where) return;
if(!confirm('1,000건이하로 엑셀다운로드됩니다.\n시간이 소요될수 있습니다.엑셀파일을 다운로드 하시겠습니까?')) return;
document.location.href='person_member_excel.html?sql_where='+sql_where;
}
</script>
<? include "../include/footer.html" ?>