Files
KIN/project/punching_input_user.asp
2025-09-29 17:55:08 +09:00

169 lines
6.9 KiB
Plaintext
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<!-- #include virtual = "lib/config.asp" -->
<%
SET rsa = server.CreateObject("ADODB.RECORDSET")
SET rsp = server.CreateObject("ADODB.RECORDSET")
dim pn_cd : pn_cd=request.item("pn_cd") '-- 펀칭코드
dim pu_type : pu_type=request.item("pu_prjcode_type") '-- 펀칭타입
%>
<meta http-equiv="Content-Type" content="application/vnd.ms-excel;charset=euc-kr">
<meta http-equiv="Expires" content="Mon, 06 Jan 1990 00:00:01 GMT">
<meta http-equiv="Expires" content="-1">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<title><%=GNB_TITLE%></title>
<link rel="stylesheet" type="text/css" href="../css/basic.css">
<script src="/js/jquery.min.js"></script>
<script src="/js/jquery-ajax-call.js"></script>
<script src="/js/jquery.form.min.js"></script>
<script language="javascript" src="../js/common.js"></script>
<script language=javascript>
function js_user_set_ok(x){
x.target = "";
x.action = "punching_input_user_save.asp";
x.submit();
}
</script>
</head>
<body onclick="javascript:try{if(winObj.window.focus()){}}catch(exception){}" ondblclick="javascript:try{if(winObj.window.focus()){}}catch(exception){}" >
<form name='xform' method='post' >
<input type="hidden" name="pn_cd" value="<%=pn_cd%>" ><!-- 펀칭코드 -->
<input type="hidden" name="pu_type" value="<%=pu_type%>" ><!-- 펀칭타입 -->
<!------------------><!------------------><!------------------>
<!-- <br><br><center><font color=blue><u>※ FCS로 이관할 데이터의 면접원을 확인하여 주세요 </u></font><br><br></center> -->
<table border="0" style="width:700px;" align=center >
<tr>
<td align=center valign=top >
<input type="button" value=" <<<<<<<<<<< 면접원 변경내용 저장 >>>>>>>>>>>> " name="btn01" class="button black medium" onclick='javascript:js_user_set_ok(document.forms[0]);' style="font-size:11pt;background-color:#999999;color:#ffffff;width:500px;height:50px;cursor:hand;" >&nbsp;
<input type="button" value="창닫기" name="btn01" class="button black medium" onclick='javascript:window.close();' style="font-size:11pt;background-color:#999999;color:#ffffff;height:50px;cursor:hand;" >
</td>
</tr>
</table><br>
<table border="0" style="width:700px;" align=center >
<tr>
<td align=center valign=top >
<br><br>
<font color=blue>
FCS데이터 이관시 적용되는 면접원코드 확인 및 변경<br><br>※ FCS 데이터 이관시에만 적용되며, 원본(펀칭)데이터 면접원 정보가 변경되지는 않습니다)
</font>
<br><br>
<table border="0" style="width:700px;" align=center >
<tr>
<td align=center valign=top >
<table style="width:690px;" cellpadding="5" cellspacing="0" border="0" style="border-collapse:collapse;">
<tr height="25px">
<td width="4%" align="center" >No</td>
<td width="22%" align="center" >펀칭된 면접원코드</td>
<td width="16%" align="center" >면접원이름</td>
<td width="16%" align="center" >생년월일</td>
<td width="16%" align="center" >면접원코드 </td>
<td width="19%" align="center" >FCS이관시 면접원코드</td>
</tr>
<%
dim a : a=1
sql=" select "&vbCrLf
sql=sql&" A.*, "&vbCrLf
sql=sql&" isnull(B.new_id,'정보없음') as new_id, "&vbCrLf
sql=sql&" isnull(B.tyymmdd,'정보없음') as tyymmdd, "&vbCrLf
sql=sql&" isnull(B.m_name,'정보없음') as m_name, "&vbCrLf
sql=sql&" isnull(C.ffusercode_change,'') as ffusercode_change "&vbCrLf
sql=sql&" from "&vbCrLf
sql=sql&" ( "&vbCrLf
sql=sql&" select "&vbCrLf
sql=sql&" ffusercode, "&vbCrLf
sql=sql&" case when left(ffusercode,2)='1-' "&vbCrLf
sql=sql&" then ffusercode "&vbCrLf
sql=sql&" else "&vbCrLf
sql=sql&" isnull('1-'+REPLICATE('0',4 - LEN(ffusercode))+cast(ffusercode as varchar(10)),'') "&vbCrLf
sql=sql&" end man_cd "&vbCrLf
sql=sql&" from [project2].[dbo].[punching_data] "&vbCrLf
sql=sql&" where ff_ing='1' "&vbCrLf
sql=sql&" and pc_prjcode='"&pn_cd&"' "&vbCrLf
sql=sql&" and pc_prjcode_sub1='"&pu_type&"' "&vbCrLf
sql=sql&" and ffid in ( "&vbCrLf
sql=sql&" select ttelnum from [punching].[dbo].[tb_response] "&vbCrLf
sql=sql&" where tprocode='"&pn_cd&"' "&vbCrLf
sql=sql&" and char(ttype+65)='"&pu_type&"' "&vbCrLf
sql=sql&" and ting='19' "&vbCrLf '-- 검증이관(19)
sql=sql&" ) "&vbCrLf
sql=sql&" group by ffusercode "&vbCrLf
sql=sql&" ) A "&vbCrLf
sql=sql&" left join "&vbCrLf
sql=sql&" ( "&vbCrLf
sql=sql&" select new_id, left(m_jumin,6) as tyymmdd, m_name from [project2].[dbo].[man] "&vbCrLf
sql=sql&" where m_activity='활동' "&vbCrLf
sql=sql&" and left(new_id,2)='1-' "&vbCrLf
sql=sql&" ) B "&vbCrLf
sql=sql&" on A.man_cd=B.new_id "&vbCrLf
sql=sql&" left join "&vbCrLf
sql=sql&" ( "&vbCrLf
sql=sql&" select ffusercode, ffusercode_change from [dbo].[T_RES_FIELD_USER_CHANGE] "&vbCrLf
sql=sql&" where ting='1' "&vbCrLf
sql=sql&" and pu_child_sn='"&pn_cd&"' "&vbCrLf
sql=sql&" and pu_type='"&pu_type&"' "&vbCrLf
sql=sql&" ) C "&vbCrLf
sql=sql&" on A.man_cd=C.ffusercode "&vbCrLf
sql=sql&" order by B.m_name asc "&vbCrLf
'response.write sql
rsp.Open sql, adoConn, 1
while not rsp.Eof
%>
<tr>
<td align="center"><%=a%></td>
<td align="center"><%=rsp("ffusercode")%></td>
<td align="center"><%=rsp("m_name")%></td>
<td align="center" ><%=rsp("tyymmdd")%></td>
<td align="center"><%=rsp("new_id")%></td>
<%if rsp("ffusercode_change")="" then%>
<td align="center"><input type="text" name="field_set_<%=rsp("man_cd")%>" id="field_set_<%=rsp("man_cd")%>" value="<%=rsp("man_cd")%>" size="20" maxlength="50" style="font-size:11pt;border:1px solid #FF0000;" ></td>
<%else %>
<td align="center"><input type="text" name="field_set_<%=rsp("man_cd")%>" id="field_set_<%=rsp("man_cd")%>" value="<%=rsp("ffusercode_change")%>" size="20" maxlength="50" style="font-size:11pt;border:1px solid #FF0000;" ></td>
<%end if %>
</tr>
<%
a=a+1
rsp.movenext
Wend
rsp.Close
%>
</table>
</td>
</tr>
<tr>
<td align=center valign=top >&nbsp;</td>
</tr>
<tr>
<td align=center valign=top >
<input type="button" value=" <<<<<<<<<<< 면접원 변경내용 저장 >>>>>>>>>>>> " name="btn01" class="button black medium" onclick='javascript:js_user_set_ok(document.forms[0]);' style="font-size:11pt;background-color:#999999;color:#ffffff;width:500px;height:50px;cursor:hand;" >&nbsp;
<input type="button" value="창닫기" name="btn01" class="button black medium" onclick='javascript:window.close();' style="font-size:11pt;background-color:#999999;color:#ffffff;height:50px;cursor:hand;" >
</td>
</tr>
<tr>
<td align=right valign=top> </td>
</tr>
</table>
<!------------------><!------------------><!------------------>
</form>
</body>
</html>