|
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 : |
<?php
include "../include/top.html";
include "_common.php";
//테이블명
$table = " TB_MEMBER ";
// 검색 설정
$sql_where = " and mb_id != 'click' and mb_level = {$level_cd} /*거래처회원*/ 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($bz_cd_s) $sql_where .= " and bz_cd = '{$bz_cd_s}' ";//업체분류
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 = 100; // 보여줄 갯수
$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="mb_favorite desc, seq desc";
//배열에 저장
$data = array();
$data = member_fetch($sql_where,$sql_order,$olds,$line);
$today = date("Y-m-d");
/*if(devCookie()){
p($data);
}*/
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<?if($level_cd == $cf['agent_level']){?>
<div class="title"><i class="xi-network-home" style="font-size:23px; vertical-align:text-top;color:#000"></i><strong>거래처 리스트</strong></div>
<?}else if($level_cd==$cf['trade_level']){?>
<div class="title"><i class="xi-network-company" style="font-size:23px; vertical-align:text-top;color:#000"></i><strong>공급처 리스트</strong></div>
<?}else if($level_cd==$cf['hotel_level']){?>
<div class="title"><i class="xi-hotel" 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">
<INPUT TYPE="hidden" NAME="level_cd" value="<?=$level_cd?>">
<INPUT TYPE="hidden" NAME="left_menu" value="<?=$left_menu?>">
<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="bz_cd_s" id="bz_cd_s">
<option value="">업체분류</option>
<?for($i=0 ; $i < count($data_bzcd) ; $i++ ){?>
<option value="<?=$data_bzcd[$i]['code']?>" <?=($data_bzcd[$i]['code']==$bz_cd_s)?"selected":""?>><?=$data_bzcd[$i]['cd_nm']?></option>
<?}?>
</select>
</li>
<li class="pl10">
<select name="search_key" id="search_key">
<option value="bz_corp_nm" <?=($search_key=="bz_corp_nm")?"selected":""?>>상호명</option>
<option value="mb_nm" <?=($search_key=="mb_nm")?"selected":""?>>담당자명</option>
<option value="mb_id" <?=($search_key=="mb_id")?"selected":""?>>아이디</option>
<option value="mb_address" <?=($search_key=="mb_address")?"selected":""?>>업체주소</option>
</select>
</li>
<li>
<label for="bz_corp_nm_s" class="v_none2">검색어 입력</label>
<input class="search_box" id="search_word" name="search_word" value="<?=$search_word?>" type="text" onfocus="this.style.background='#ffffff url(none)'" onblur="if(this.value.length == 0) {this.style.background='#ffffff url(../image/common/search_txtbg04.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">
<?if($level_cd == $cf['agent_level']){?>
<p class="search_result_txt member"><span>판매채널 검색 : <?=$total?></span><span class="txt">개 파트너사가 검색되었습니다.</span></p>
<?}else if($level_cd==$cf['trade_level']){?>
<p class="search_result_txt member"><span>공급처 검색 : <?=$total?></span><span class="txt">개 시설사가 검색되었습니다.</span></p>
<?}?>
<ul class="search_rt_btn">
<?if($level_cd == $cf['agent_level']){?>
<input class="Table_btn gray" id="btn_agent_search" onclick="location.href='biz_member_out.html?level_cd=12&left_menu=202';" type="button" value="탈퇴거래처" style="height:21px;">
<?}else if($level_cd==$cf['trade_level']){?>
<input class="Table_btn gray" id="btn_agent_search" onclick="location.href='biz_member_out.html?level_cd=13&left_menu=302';" type="button" value="탈퇴공급처" style="height:21px;">
<? } ?>
</ul>
</div>
</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list" summary="업체회원 관리하실 수 있습니다.">
<caption>업체회원 관리</caption>
<colgroup>
<col style=" width:50px" />
<col style=" width:110px;" /><!-- 업체구분 -->
<col style=" width:200px" /><!-- 상호명 -->
<col style=" width:50px" /><!-- 언어 -->
<col style=" width:100px" /><!-- 아이디 -->
<col style=" width:100px" />
<col style=" width:130px" />
<col style=" width:130px" />
<col style=" width:70px" />
<col style=" width:70px;" />
<col style=" width:70px;" />
<col style=" width:90px" />
<col style=" width:110px" />
<col style=" width:60px" />
<? if($level_cd==$cf['trade_level']){ ?>
<col style=" width:90px" />
<? } ?>
<col style=" width:70px" />
<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">전체바코드</th>
<th scope="col">잔여바코드</th>
<th scope="col">가입일</th>
<th scope="col">최근로그인일</th>
<th scope="col">로그인수</th>
<? if($level_cd==$cf['trade_level']){ ?>
<th scope="col">API연동</th>
<? } ?>
<th scope="col">자동로그인</th>
<th scope="col"><span style="color:red;font-weight: 700;">공지사항 / 탈퇴</th>
</tr>
</thead>
<tbody>
<?
for($i=0 ; $i < count($data) ; $i++){
$row = $data[$i];
$num = $total - ($page - 1) * $line - $i;
$newdate = date("Y-m-d", strtotime("+3 day", strtotime($row['ins_dt_new'])));
if($level_cd == $cf['agent_level']){
$resv_data = db_fetch("select count(res_seq) as resv_cnt from TB_RES_GOOD where agent_id='{$row['mb_id']}' AND res_stat_cd != 'E'");
} else {
$resv_data = db_fetch("select count(res_seq) as resv_cnt from TB_RES_GOOD where producer_id='{$row['mb_id']}' AND res_stat_cd != 'E'");
}
$row['resv_cnt'] = $resv_data['resv_cnt'];
$autologin_key= base64_encode(md5_encrypt($row['mb_id']));
// API 연동 아이콘 표시
$rs = db_query("SELECT distinct(g_api) FROM good WHERE g_api != '' and producer_id = '{$row['mb_id']}'");
$apiimg = '';
$g_api_arr = array();
for ($ig=0; $row_g_api = db_fetch_array($rs); $ig++) {
$g_api_arr = array_merge($g_api_arr, explode(",",$row_g_api['g_api']));
}
$g_api_arr = array_unique($g_api_arr);
foreach($g_api_arr as $k => $v){
$row['api_icon'] .= "<img src='/admin/image/partner/".strtolower($v).".png' border='0' align='adsmiddle' title='API연동 : ".$v."'> ";
}
// 바코드 수량
$sql = "SELECT (SELECT COUNT(seq) FROM TB_TICKET WHERE producer_id = '{$row['mb_id']}' AND del_flag='N' ) AS all_count, (SELECT COUNT(seq) FROM TB_TICKET WHERE producer_id = '{$row['mb_id']}' AND ticket_status = 'W' AND del_flag='N') AS wait_count;";
$ticket_count = db_fetch($sql);
?>
<tr>
<td>
<? if($row['mb_favorite'] == 1){ ?>
<img src="/admin/image/common/icon_star.png">
<? } else { ?>
<?=$num?>
<? } ?>
</td>
<td><?=$row['bz_cd2']?></td>
<td class="pl10 tll">
<b><a href="biz_member_modify.html?<?=$_href?>&seq=<?=$row['seq']?>"><?=$row['bz_corp_nm']?></a></b>
<!--new icon -->
<?if($today >= $row['ins_dt_new'] && $today <= $newdate) : ?>
<img src="../image/new.gif">
<? endif; ?>
<?php
if(file_exists($_SERVER['DOCUMENT_ROOT'].'/admin/image/partner/'.$row['mb_id'].'.png')){
?>
<img src="/admin/image/partner/<?=$row['mb_id']?>.png" />
<?php
}
?>
</td>
<td><?=langStr($row['bz_nat'])?></td>
<td><?=$row['mb_id']?></td>
<td><?=$row['biz_pass_memo']?></td>
<td><?=$row['mb_nm']?></td>
<td><?=$row['mb_phone']?></td>
<td>
<a href="/admin/res_good/good_res_list.html?producer_id=<?=$row['mb_id']?>"><?=number_format($row['resv_cnt'])?></a>
</td>
<td>
<a href="/admin/ticket/ticket_group_list.html?search_key=producer_id&search_word=<?=$row['mb_id']?>"><?=number_format($ticket_count['all_count'])?></a>
</td>
<td>
<a href="/admin/ticket/ticket_group_list.html?search_key=producer_id&search_word=<?=$row['mb_id']?>" class="<?if($ticket_count['all_count']>0) echo "c_red fw_b"; ?>"><?=number_format($ticket_count['wait_count'])?></a>
</td>
<td><?=$row['ins_dt2']?></td>
<td><?=$row['last_login_dt2']?></td>
<td><?=$row['login_cnt']?></td>
<? if($level_cd==$cf['trade_level']){ ?>
<td><?=$row['api_icon']?></td>
<? } ?>
<td><a href="https://tkplace.co.kr/admin/login_auto_proc.php?key=<?=$autologin_key?>" target="_blank"><i class="xi-log-in" style="font-size:20px;"></i></a></td>
<td>
<?
echo '<input type="button" value="공지" class="Table_btn" onClick="notice_agent(\''.$row['mb_id'].'\')" />';
?>
<input type="button" name="mb_out" id="mb_out" value="탈퇴" class="Table_btn" onClick="mb_del('<?=$row['seq']?>','<?=$row['mb_id']?>');" />
<?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>
</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);
}
//[son]대리점 공지
function notice_agent(agent_id) {
var url = '../res_good/b2b_notice_memo.html?agent_id='+agent_id;
to_dialog.iframe(url,'거래처 공지','600','650',true,false,'no');
}
</script>
<? include "../include/footer.html" ?>