133 lines
5.1 KiB
Plaintext
133 lines
5.1 KiB
Plaintext
<!-- #include virtual = "include/header.asp" -->
|
|
<!-- #include virtual = "include/left.asp" -->
|
|
<!-- Content Wrapper. Contains page content -->
|
|
<div class="content-wrapper">
|
|
<!-- Content Header (Page header) -->
|
|
<div class="content-header">
|
|
<h1>직원정보</h1>
|
|
</div>
|
|
<!-- /.content-header -->
|
|
<!-- Main content -->
|
|
<div class="content-body">
|
|
<div class="content">
|
|
<div class="container-fluid">
|
|
<div class="row">
|
|
<div class="col-12">
|
|
<table width="100%" cellpadding="0" cellspacing="0" border="0">
|
|
<%
|
|
Query = ""
|
|
Query = Query & " SELECT p_name, p_team_name, p_rank_name, p_tel2, p_tel3, birthday, jumin "
|
|
Query = Query & " FROM V_PERSON "
|
|
Query = Query & " WHERE p_resign = '0' AND ISNULL(krc_in_date, '') != '' "
|
|
query = query & " ORDER BY p_name "
|
|
|
|
Adors.open Query, adoconn, 1
|
|
%>
|
|
<tr>
|
|
<td colspan="2">
|
|
<font class="brown">직원정보 리스트입니다. 현직원(<%=Adors.recordcount%>)명 - 가나다순</font>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="2">
|
|
<div class="card-deck">
|
|
<% Do until Adors.EOF %>
|
|
<% If Adors.AbsolutePosition Mod 8 = 1 And Adors.AbsolutePosition <> 1 Then %>
|
|
</div>
|
|
<div class="card-deck">
|
|
<% End If %>
|
|
<div class="card m-2 p-1">
|
|
<img class="card-img-top p-2" src="/images/management/img/<%=replace(left(decode(Adors("jumin"),0),8),"-" ,"_")%>_<%=Adors("p_name")%>.jpg?ver=3" onerror="this.src='/images/management/no_img.gif'" alt="직원 사진">
|
|
<div class="card-body p-1">
|
|
<h5 class="card-title m-0"><%=Adors("p_name")%></h5>
|
|
</div>
|
|
<ul class="list-group list-group-flush">
|
|
<li class="list-group-item p-0"><%=Adors("p_team_name")%></li>
|
|
<li class="list-group-item p-0"><%=Adors("p_rank_name")%></li>
|
|
<li class="list-group-item p-0"><%=Adors("p_tel2")%></li>
|
|
<li class="list-group-item p-0"><%=Right(Adors("p_tel3"), 4)%></li>
|
|
<li class="list-group-item p-0"><%=Mid(Adors("birthday"), 6)%></li>
|
|
</ul>
|
|
</div>
|
|
<% Adors.MoveNext %>
|
|
<% Loop %>
|
|
<% If Adors.recordCount Mod 8 <> 0 Then %>
|
|
<% For i=1 To 8 - Adors.recordCount Mod 8 %>
|
|
<div class="card m-2 p-1 invisible"></div>
|
|
<% Next %>
|
|
<% End If %>
|
|
<% Adors.Close %>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
<% '퇴사자
|
|
if session("Depart_Code") = 0 or session("job_code") = "10" or tmp_admin_chk = "1" then
|
|
Query = ""
|
|
Query = Query & " SELECT P.p_name, p_tel2, p_tel3, birthday, jumin, ISNULL(D.d_name, '알수없음') AS d_name, O.p_name AS position_nm "
|
|
Query = Query & " FROM PERSON P LEFT JOIN Depart D ON P.p_depart = D.d_code "
|
|
Query = Query & " LEFT JOIN [Position] O ON P.p_pos = O.p_code "
|
|
Query = Query & " WHERE p_resign = '1' AND len(p_no) = 8 AND krc_in_date IS NOT NULL "
|
|
Query = Query & " ORDER BY P.p_name "
|
|
Adors.open Query, adoconn, 1
|
|
%>
|
|
<tr>
|
|
<td colspan ="2"><div class='py-5'></div></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan ="2">
|
|
<font class="brown">직원정보 리스트입니다. 퇴직자(<%=Adors.recordcount%>)명 - 가나다순</font>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="2">
|
|
<div class="card-deck">
|
|
<% Do until Adors.EOF %>
|
|
<% If Adors.AbsolutePosition Mod 8 = 1 And Adors.AbsolutePosition <> 1 Then %>
|
|
</div>
|
|
<div class="card-deck">
|
|
<% End If %>
|
|
<div class="card m-2 p-1">
|
|
<img class="card-img-top p-2" src="/images/management/img/<%=replace(left(decode(Adors("jumin"),0),8),"-" ,"_")%>_<%=Adors("p_name")%>.jpg" onerror="this.src='/images/management/no_img.gif'" alt="직원 사진">
|
|
<div class="card-body p-1">
|
|
<h5 class="card-title m-0"><%=Adors("p_name")%></h5>
|
|
</div>
|
|
<ul class="list-group list-group-flush">
|
|
<li class="list-group-item p-0"><%=Adors("d_name")%></li>
|
|
<li class="list-group-item p-0"><%=Adors("position_nm")%></li>
|
|
<li class="list-group-item p-0"><%=Adors("p_tel2")%></li>
|
|
<li class="list-group-item p-0"><%=Mid(Adors("p_tel3"), 9, 4)%></li>
|
|
<li class="list-group-item p-0"><%=Mid(Adors("birthday"), 6)%></li>
|
|
</ul>
|
|
</div>
|
|
<% Adors.MoveNext %>
|
|
<% Loop %>
|
|
<% If Adors.recordCount Mod 8 <> 0 Then %>
|
|
<% For i=1 To 8 - Adors.recordCount Mod 8 %>
|
|
<div class="card m-2 p-1 invisible"></div>
|
|
<% Next %>
|
|
<% End If %>
|
|
<% Adors.Close %>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
<%end if%>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<!-- /.content -->
|
|
<!-- REQUIRED SCRIPTS -->
|
|
<script>
|
|
function downEmail() {
|
|
location.href= "./downcsv.asp";
|
|
}
|
|
|
|
function person_info() {
|
|
location.href= "./down_person_info.asp";
|
|
}
|
|
</script>
|
|
</div>
|
|
<!-- /.content-wrapper -->
|
|
<!-- #include virtual = "include/footer.asp" --> |