sp1000je
484 lines
14 KiB
Plaintext
484 lines
14 KiB
Plaintext
<!--#include virtual="/common/file/inc_head.asp"-->
|
||
<%
|
||
|
||
dim v_search, v_keyword, table, Query_Fields, Query_Where, Query_OrderBy
|
||
Dim recordcount
|
||
dim pagesize, v_totalpage, v_page, TotalCnt, v_block
|
||
|
||
Dim nameSort1, nameSort2
|
||
|
||
nameSort1 = inputValue( Request.QueryString("nameSort1") )
|
||
nameSort2 = inputValue( Request.QueryString("nameSort2") )
|
||
|
||
v_search = inputValue( Request.QueryString("p_search") ) '검색조건
|
||
v_keyword = inputValue( Request.QueryString("p_keyword") ) '검색어
|
||
prepage = Request.ServerVariables("path_info") & "?" & Request.ServerVariables("query_string") '현재페이지경로
|
||
|
||
table = "view_address_member" '테이블
|
||
idx_field = "adr_idx" '기본키
|
||
oreder_filed = "adr_name asc, adr_idx asc" '정렬기준 필드
|
||
Query_Fields = "adr_idx, bdm_idx, adr_m_id, adr_name, adr_mobile1, adr_mobile2, adr_mobile3, adr_c_memo, bdm_menuname" '불러올 필드
|
||
pagesize = 10 '목록개수
|
||
v_block = 10 '페이지개수
|
||
|
||
'==================조합 쿼리문=======================
|
||
If v_keyword <> "" then
|
||
Query_Where = " where adr_m_id = '" & session("ss_m_id") & "' and " & v_search & " like '%" & v_keyword & "%'"
|
||
andOrWhere = " and "
|
||
Else
|
||
Query_Where = " where adr_m_id = '" & session("ss_m_id") & "'"
|
||
andOrWhere = " and "
|
||
End If
|
||
|
||
If nameSort1 <> "" And nameSort2 <> "" Then
|
||
Query_Where = Query_Where & andOrWhere & " adr_name between '" & nameSort1 & "' and '" & nameSort2 & "'"
|
||
End if
|
||
|
||
|
||
Query_OrderBy = " ORDER BY "&oreder_filed
|
||
'==================조합 쿼리문=======================
|
||
|
||
'==================전체 레코드 수 뽑기===============
|
||
sql="select count("&idx_field&") from " & table & Query_Where
|
||
'Response.write sql
|
||
'Response.end
|
||
set rs = DbCon.execute(sql)
|
||
recordcount=CInt( rs(0) ) '이 전체레코드갯수를 이용해서 페이지갯수를 뽑아 낼것이다.
|
||
Set rs = nothing
|
||
'==================전체 레코드 수 뽑기===============
|
||
|
||
v_totalpage=fix((recordcount-1)/pagesize)+1 '전체덩어리갯수
|
||
v_page = Request.QueryString("p_page")
|
||
|
||
if v_page="" then
|
||
v_page = 1
|
||
elseif cint(v_page) < 1 then
|
||
v_page = 1
|
||
elseif cint(v_page)>cint(v_totalpage) then
|
||
v_page=cint(v_totalpage)
|
||
end if
|
||
|
||
'========================리스트 출력 쿼리문 생성======================
|
||
'MS-SQL
|
||
sql = "select Top " & pagesize& " " & Query_Fields & " from " & table
|
||
sql = sql & Query_Where & andOrWhere & " "&idx_field&" not in"
|
||
sql = sql & "(select top " & pagesize * (v_page - 1) & " "&idx_field&" from " & table
|
||
sql = sql & Query_Where & Query_OrderBy & ")"
|
||
sql = sql & Query_OrderBy
|
||
'========================리스트 출력 쿼리문 생성 끝======================
|
||
'response.write sql
|
||
|
||
|
||
Set rs = Dbcon.Execute( sql )
|
||
If rs.bof Or rs.eof Then
|
||
List_data = Null
|
||
TotalCnt = 0
|
||
else
|
||
List_data = rs.getrows
|
||
TotalCnt = recordcount
|
||
End if
|
||
|
||
|
||
'=======================주소그룹============================
|
||
sql = "select a.bdm_idx, bdm_menuname, b.Cnt from bd_address as a left outer join view_bd_memTotal as b on a.bdm_idx = b.bdm_idx where bdm_id = '"&session("ss_m_id")&"' order by bdm_code"
|
||
Set rs = DbCon.Execute( sql )
|
||
If rs.bof Or rs.eof Then
|
||
addr_list = Null
|
||
Else
|
||
addr_list = rs.getrows
|
||
End If
|
||
'=======================주소그룹============================
|
||
|
||
|
||
Set rs = Nothing
|
||
DbCon.close
|
||
Set DbCon = Nothing
|
||
|
||
|
||
|
||
sortkeyword = "가;나;다;라;마;바;사;아;자;차;카;타;파;하;히"
|
||
sortkeyword_arr = Split(sortkeyword, ";")
|
||
%>
|
||
<script type="text/javascript">
|
||
//<![CDATA[
|
||
//정렬
|
||
function doSort(nameSort1, nameSort2){
|
||
location.href="?nameSort1="+nameSort1+"&nameSort2="+nameSort2;
|
||
}
|
||
|
||
|
||
|
||
function checkAll(){
|
||
var eForm = document.getElementById('mem_List');
|
||
if(eForm.chk_all.value == "") {
|
||
eForm.chk_all.value="Y";
|
||
checkboxChk(eForm.adr_idx, true);
|
||
}else {
|
||
eForm.chk_all.value="";
|
||
checkboxChk(eForm.adr_idx, false);
|
||
}
|
||
}
|
||
|
||
function checkboxChk(chkObj, type){
|
||
var field = chkObj;//buseo_mem.document.mem_list.check;
|
||
if(field.length == null){
|
||
field.checked = type;
|
||
}else{
|
||
for (i = 0; i < field.length; i++){
|
||
field[i].checked = type;
|
||
}
|
||
}
|
||
}
|
||
|
||
//삭제
|
||
function DelOk(){
|
||
if (confirm("삭제하시겠습니까?")){
|
||
document.getElementById("mem_List").submit();
|
||
}return;
|
||
}
|
||
|
||
//그룹이동
|
||
function grpChange(){
|
||
var obj = document.getElementById("bdm_idx_select");
|
||
var eForm = document.getElementById("mem_List");
|
||
|
||
eForm.bdm_idx.value = obj.value;
|
||
|
||
if (confirm("선택된 주소록을 그룹이동 하시겠습니까?")){
|
||
eForm.action = "addr_grp_change_ok.asp";
|
||
eForm.submit();
|
||
}return;
|
||
}
|
||
|
||
//]]>
|
||
</script>
|
||
|
||
<!-- 타이틀 -->
|
||
<div id="cont_head">
|
||
<h2>주소록</h2>
|
||
<p class="imp">기본적으로 가나다 순으로 나오며, 정렬설정은 아래의 선택으로 지정하실 수 있습니다.</p>
|
||
</div>
|
||
<!-- //타이틀 -->
|
||
<!-- 내용 -->
|
||
<div id="cont_wrap">
|
||
<!-- 주소록 -->
|
||
<div class="s0201">
|
||
<div class="h_board">
|
||
<div class="float_l">
|
||
<select class="select_basic" style="width:140px;">
|
||
<option>정렬기준</option>
|
||
<option>가나다순</option>
|
||
<option>등록순</option>
|
||
</select>
|
||
<ul class="k_alpa">
|
||
<li><a href="#" class="active">ㄱ</a></li>
|
||
<li><a href="#">ㄴ</a></li>
|
||
<li><a href="#">ㄷ</a></li>
|
||
<li><a href="#">ㄹ</a></li>
|
||
<li><a href="#">ㅁ</a></li>
|
||
<li><a href="#">ㅂ</a></li>
|
||
<li><a href="#">ㅅ</a></li>
|
||
<li><a href="#">ㅇ</a></li>
|
||
<li><a href="#">ㅈ</a></li>
|
||
<li><a href="#">ㅊ</a></li>
|
||
<li><a href="#">ㅋ</a></li>
|
||
<li><a href="#">ㅌ</a></li>
|
||
<li><a href="#">ㅍ</a></li>
|
||
<li><a href="#">ㅎ</a></li>
|
||
<li><a href="#">A-Z</a></li>
|
||
</ul>
|
||
</div>
|
||
<div class="float_r">
|
||
<a href="#" class="c_gray">엑셀저장</a>
|
||
<a href="#" class="c_gray">엑셀등록</a>
|
||
<a href="javascript:;" onclick="clickArea(detaillayer9,0);" class="c_mint">주소록 등록</a>
|
||
</div>
|
||
</div>
|
||
<table class="table1" summary="주소록">
|
||
<colgroup>
|
||
<col width="5%" />
|
||
<col width="15%" />
|
||
<col width="20%" />
|
||
<col width="12%" />
|
||
<col width="20%" />
|
||
<col width="*" />
|
||
</colgroup>
|
||
<thead>
|
||
<tr>
|
||
<th scope="col"><input type="checkbox" /></th>
|
||
<th scope="col">이름</th>
|
||
<th scope="col">연락처</th>
|
||
<th scope="col">문자보내기</th>
|
||
<th scope="col">소속그룹</th>
|
||
<th scope="col">메모</th>
|
||
</tr>
|
||
</thead>
|
||
<tbody>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
<tr>
|
||
<td><input type="checkbox" /></td>
|
||
<td>홍길동</td>
|
||
<td><a href="javascript:;" onclick="clickArea(detaillayer10,0);">010-1234-5463</a></td>
|
||
<td>
|
||
<div class="btngroup">
|
||
<ul class="btn_sm">
|
||
<li><a href="#" class="sm1">발송</a></li>
|
||
</ul>
|
||
</div>
|
||
</td>
|
||
<td>나눔아이앤씨</td>
|
||
<td>메모메모</td>
|
||
</tr>
|
||
</tbody>
|
||
</table>
|
||
<div class="paginate">
|
||
<a href="#" class="prev">이전</a>
|
||
<ul>
|
||
<li><a href="#" class="active">1</a></li>
|
||
<li><a href="#">2</a></li>
|
||
<li><a href="#">3</a></li>
|
||
<li><a href="#">4</a></li>
|
||
<li><a href="#">5</a></li>
|
||
</ul>
|
||
<a href="#" class="next">다음</a>
|
||
</div>
|
||
<div class="f_board">
|
||
<div class="btngroup">
|
||
<ul class="btn_nrm_bor column3">
|
||
<li><a href="#">전체선택/해제</a></li>
|
||
<li><a href="#">선택삭제</a></li>
|
||
<li><a href="javascript:;" onclick="clickArea(detaillayer8,0);">선택 주소록 그룹설정</a></li>
|
||
</ul>
|
||
</div>
|
||
<div class="search_frm">
|
||
<ul>
|
||
<li class="s_month">
|
||
<select style="width:150px;">
|
||
<option>그룹전체</option>
|
||
</select>
|
||
</li>
|
||
<li class="s_word">
|
||
<select style="width:100px;">
|
||
<option>검색</option>
|
||
</select>
|
||
<input type="text" class="w_text" placeholder="검색어를 입력하세요." />
|
||
<input type="image" src="/img/sub/btn_search.png" title="검색" class="btn_search" />
|
||
</li>
|
||
</ul>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
<!-- //주소록 -->
|
||
</div>
|
||
<!-- //내용 -->
|
||
|
||
<!-- 그룹설정 -->
|
||
<div id="detaillayer8" class="maskpopbox" style="display:none;">
|
||
<div class="popbox">
|
||
<div class="poptit">
|
||
<h4>그룹설정</h4>
|
||
<span class="popcls"><img src="/img/sub/btn_popcls.gif" alt="닫기" /></span>
|
||
</div>
|
||
<div class="popct">
|
||
<p>선택한 <strong>‘5건’</strong> 주소록을<br/>아래의 그룹으로 이동합니다.</p>
|
||
<div class="sl_box">
|
||
<select>
|
||
<option>영업팀</option>
|
||
</select>
|
||
</div>
|
||
<div class="btngroup">
|
||
<ul class="btn_nrm column2">
|
||
<li><a href="#" class="nrm1">그룹이동</a></li>
|
||
<li><a href="#" class="nrm2">취소</a></li>
|
||
</ul>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
<!-- //그룹설정 -->
|
||
|
||
<!-- 주소록등록 -->
|
||
<div id="detaillayer9" class="maskpopbox" style="display:none;">
|
||
<div class="popbox">
|
||
<div class="poptit">
|
||
<h4>주소록등록</h4>
|
||
<span class="popcls"><img src="/img/sub/btn_popcls.gif" alt="닫기" /></span>
|
||
</div>
|
||
<div class="popct">
|
||
<p class="essential"><strong>필수항목</strong></p>
|
||
<ul class="frm">
|
||
<li><input type="text" class="inp_basic ess" placeholder="이름"/></li>
|
||
<li><input type="text" class="inp_basic ess" placeholder="연락처"/></li>
|
||
<li><input type="text" class="inp_basic" placeholder="메모"/></li>
|
||
<li>
|
||
<select class="select_basic ess">
|
||
<option>영업팀</option>
|
||
</select>
|
||
</li>
|
||
</ul>
|
||
<div class="btngroup">
|
||
<ul class="btn_nrm column2">
|
||
<li><a href="#" class="nrm1">저장</a></li>
|
||
<li><a href="#" class="nrm2">취소</a></li>
|
||
</ul>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
<!-- //주소록등록 -->
|
||
|
||
<!-- 주소록수정 -->
|
||
<div id="detaillayer10" class="maskpopbox" style="display:none;">
|
||
<div class="popbox">
|
||
<div class="poptit">
|
||
<h4>주소록수정</h4>
|
||
<span class="popcls"><img src="/img/sub/btn_popcls.gif" alt="닫기" /></span>
|
||
</div>
|
||
<div class="popct">
|
||
<ul class="frm">
|
||
<li><input type="text" class="inp_basic" value="홍길동"/></li>
|
||
<li><input type="text" class="inp_basic" value="010-1234-5678" /></li>
|
||
<li><input type="text" class="inp_basic" value="나눔아이앤씨" /></li>
|
||
<li>
|
||
<select class="select_basic">
|
||
<option>영업팀</option>
|
||
</select>
|
||
</li>
|
||
</ul>
|
||
<div class="btngroup">
|
||
<ul class="btn_nrm column2">
|
||
<li><a href="#" class="nrm1">수정</a></li>
|
||
<li><a href="#" class="nrm2">취소</a></li>
|
||
</ul>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
<!-- //주소록수정 -->
|
||
|
||
<!--#include virtual="/common/file/bottom.asp"--> |