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

451 lines
13 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_type") '-- 펀칭타입
dim pu_area : pu_area=request.item("pu_area") '-- 펀칭지역
%>
<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_tclick(x,ck,cmval,xcnt){
var sp_name="";
// sp_name="sp_"+cmval;
sp_name=cmval;
if(x.tno.length!=undefined){
if(ck==true){
x.elements["field_set_"+sp_name].value="";
x.elements["field_set_"+sp_name].readOnly=false;
document.getElementById("sp_"+sp_name+"").style.display="block";
x.uno[xcnt].checked=false;
x.uno[xcnt].disabled=false;
x.uno[xcnt].style.display="block";
x.bno[xcnt].checked=false;
x.bno[xcnt].disabled=false;
x.bno[xcnt].style.display="block";
x.bno2[xcnt].checked=false;
x.bno2[xcnt].disabled=false;
x.bno2[xcnt].style.display="block";
}else{
x.elements["field_set_"+sp_name].value="";
x.elements["field_set_"+sp_name].readOnly=false;
document.getElementById("sp_"+sp_name+"").style.display="none";
x.uno[xcnt].checked=false;
x.uno[xcnt].disabled=false;
x.uno[xcnt].style.display="none";
x.bno[xcnt].checked=false;
x.bno[xcnt].disabled=false;
x.bno[xcnt].style.display="none";
x.bno2[xcnt].checked=false;
x.bno2[xcnt].disabled=false;
x.bno2[xcnt].style.display="none";
}
}else{
if(ck==true){
x.elements["field_set_"+sp_name].value="";
document.getElementById("sp_"+sp_name+"").style.display="block";
x.uno[xcnt].checked=false;
x.uno[xcnt].disabled=false;
x.uno[xcnt].style.display="block";
x.bno[xcnt].checked=false;
x.bno[xcnt].disabled=false;
x.bno[xcnt].style.display="block";
x.bno2[xcnt].checked=false;
x.bno2[xcnt].disabled=false;
x.bno2[xcnt].style.display="block";
}else{
x.elements["field_set_"+sp_name].value="";
document.getElementById("sp_"+sp_name+"").style.display="none";
x.uno[xcnt].checked=false;
x.uno[xcnt].disabled=false;
x.uno[xcnt].style.display="none";
x.bno[xcnt].checked=false;
x.bno[xcnt].disabled=false;
x.bno[xcnt].style.display="none";
x.bno2[xcnt].checked=false;
x.bno2[xcnt].disabled=false;
x.bno2[xcnt].style.display="none";
}
}
}
function js_field_set_ok(x){
if(x.tno==undefined){
alert("펀칭 프로그램에서 [데이터 검증이관]을 해주시기 바랍니다 ");
return false;
}
var no_val;
var no_cnt;
var no_cnt2;
var tt;
//------------------------------------------
// 검증문항 선택 체크
no_cnt=0;
for(i=0;i<x.tno.length; i++){
if((x.tno[i].disabled==false)&&(x.tno[i].checked==true)){no_cnt++}
}
if(Number(no_cnt)==0){
alert("선택된 검증문항이 없습니다 ");
return;
}
//------------------------------------------
// Column 매칭 선택여부 체크
no_val="";
for(i=0;i<x.tno.length; i++){
if((x.tno[i].checked==true)&&(x.uno[i].checked==false)&&(x.bno[i].checked==false)&&(x.bno2[i].checked==false)){
no_val=x.tno[i].value;
if(x.elements["field_set_"+no_val].value==""){
alert("검증 라벨을 입력하여 주세요 ");
x.elements["field_set_"+no_val].focus();
return;
}
}
}
//------------------------------------------
// 이름체크
no_cnt=0;
for(i=0;i<x.uno.length; i++){
if(x.uno[i].disabled==false){
if(x.uno[i].checked==true){
no_cnt++;
}
}
}
if(Number(no_cnt)==0){
alert("[이름을 필수적으로 선택해 주세요 ");
return;
}
//------------------------------------------
// 검증전화번호 체크
no_cnt=0;
for(i=0;i<x.bno.length; i++){
if(x.bno[i].disabled==false){
if(x.bno[i].checked==true){
tt=x.bno[i].value;
no_cnt++;
}
}
}
if(Number(no_cnt)==0){
for(i=0;i<x.bno2.length; i++){
if(x.bno2[i].disabled==false){
if(x.bno2[i].checked==true){
tt=x.bno2[i].value;
no_cnt++;
}
}
}
}
if(Number(no_cnt)==0){
alert("[검증 번호 하나는 필수적으로 선택해 주셔야 합니다 ");
return;
}
/*
// 검증전화번호 중복체크
for(i=0;i<x.bno2.length; i++){
if(x.bno2[i].checked==true){
if(x.bno2[i].value==tt){
alert("[검증 전화번호(1)] [검증 전화번호(2)] 가 중복 됩니다. 검증 전화번호 는 서로 다른 문번을 선택하여 주시기 바랍니다 ");
return;
}
}
}
*/
no_cnt2=0;
for(i=0;i<x.tno.length; i++){
if(x.tno[i].checked==true){no_cnt2++;}
}
if(Number(no_cnt2)>30){
alert("[검증업로드] 문항이 ["+no_cnt2+"]개 선택 되었습니다. [검증업로드] 문항은30개 이상 선택하실수 없습니다 ");
return;
}
if(Number(no_cnt2)==1){
alert("검증 전화번호외 [검증업로드] 문항을 선택하여 주세요 ");
return;
}
x.target="";
x.action="punching_field_setting_reg.asp";
x.submit();
// window.open('about:blank','_self').self.close();
}
function js_r_click(x,jname,j,jvalue,a,a1,a2){
//_r_click(xform,this.value,'<%=cdbl(a)-1%>','phone_number','bno2','uno','bno');"
var x_name="field_set_"+jname;
var x_name2="";
for(var i=0;i<x.elements[a].length; i++){
if(i==j){
x.elements[a][i].disabled=false;
x.elements[a][i].checked=true;
x.elements[a1][i].disabled=true;
x.elements[a1][i].checked=false;
x.elements[a2][i].disabled=true;
x.elements[a2][i].checked=false
x.elements[x_name].value=jvalue;
x.elements[x_name].readOnly=true;
}else{
x_name2="field_set_"+x.elements[a][i].value;
if(x.elements[x_name2].value==jvalue){
if(x.elements[x_name2].readOnly==true){
x.elements[x_name2].value="";
x.elements[x_name2].readOnly=false;
x.elements[a1][i].disabled=false;
x.elements[a1][i].checked=false;
x.elements[a2][i].disabled=false
x.elements[a2][i].checked=false
}
}
}
}
}
</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%>" ><!-- 펀칭타입 -->
<input type="hidden" name="pu_area" value="<%=pu_area%>" ><!-- 펀칭지역 -->
<!------------------><!------------------><!------------------>
<center><font color=blue><u>※ FCS로 이관할 데이터를 선택하여 주세요(이관 데이터 선택은 최초 1번만 세팅 하실수 있습니다)</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_field_set_ok(document.forms[0]);' style="font-size:11pt;width:500px;" >
</td>
</tr>
</table><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="8%" align="center" >검증<br>업로드</td>
<td width="21%" align="center" >펀칭문번</td>
<td width="25%" align="center" >검증 라벨 </td>
<td width="12%" align="center" >이름</td>
<td width="14%" align="center" >검증<br>휴대폰번호(1)</td>
<td width="13%" align="center" >검증<br>일반번호(2)</td>
</tr>
<tr>
<td align="center">-</td>
<td align="center">고정</td>
<td align="center"><font color=blue><b>fftype (설문Type)</b></font></td>
<td align="right" ><%=set_sbox("설문Type","설문Type")%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;</td>
<td align="center">-</td>
<td align="center">-</td>
<td align="center">-</td>
</tr>
<tr>
<td align="center">-</td>
<td align="center">고정</td>
<td align="center"><font color=blue><b>ffid (설문ID)</b></font></td>
<td align="right"><%=set_sbox("설문ID","설문ID")%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;</td>
<td align="center">-</td>
<td align="center">-</td>
<td align="center">-</td>
</tr>
<tr>
<td align="center">-</td>
<td align="center">고정</td>
<td align="center"><font color=blue><b>ffusercode (면접원ID)</b></font></font></td>
<td align="right" ><%=set_sbox("면접원ID","면접원ID")%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align="center">-</td>
<td align="center">-</td>
<td align="center">-</td>
</tr>
<%
dim a : a=1
sql=" select ffque from [project2].[dbo].[punching_data] "
sql=sql&" where pc_prjcode='"&pn_cd&"' "
sql=sql&" and pc_prjcode_sub1='"&pu_type&"' "
sql=sql&" group by ffque "
sql=sql&" order by max(id) asc "
'response.write sql
rsp.Open sql, adoConn, 1
if rsp.eof then
%>
<tr>
<td colspan="7" align="center" style="font-size:11pt;"><br><br><br><br><b>
- 펀칭 프로그램에서 검증이관 처리된 데이터가 없습니다 -
</b><br><br><br><br></td>
</tr>
<%
rsp.close
else
while not rsp.Eof
%>
<tr>
<td align="center"><%=a%></td>
<td align="center"><input type="checkbox" name="tno" value="<%=rsp("ffque")%>" onclick="javascript:js_tclick(xform,this.checked, this.value,'<%=cdbl(a)-1%>');" style="border:1px solid #FF0000;" ></td>
<td align="center"><font size="3"><font color=blue><b><%=rsp("ffque")%></b></font></font></td>
<td align="right"><span id="sp_<%=rsp("ffque")%>" style="display:none;" ><%=set_sbox("",rsp("ffque"))%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></td>
<td align="center"><input type="radio" name="uno" value="<%=rsp("ffque")%>" style="display:none;" style="border:1px solid #FF0000;" onclick="javascript:js_r_click(xform,this.value,'<%=cdbl(a)-1%>','user_name','uno','bno','bno2');" ></td>
<td align="center"><input type="radio" name="bno" value="<%=rsp("ffque")%>" style="display:none;" style="border:1px solid #FF0000;" onclick="javascript:js_r_click(xform,this.value,'<%=cdbl(a)-1%>','phone_number1','bno','uno','bno2');" ></td>
<td align="center"><input type="radio" name="bno2" value="<%=rsp("ffque")%>" style="display:none;" style="border:1px solid #FF0000;" onclick="javascript:js_r_click(xform,this.value,'<%=cdbl(a)-1%>','phone_number2','bno2','uno','bno');" ></td>
</tr>
<%
a=a+1
rsp.movenext
Wend
rsp.Close
%>
<%end if%>
</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_field_set_ok(document.forms[0]);' style="font-size:11pt;width:500px;" >
</td>
</tr>
<tr>
<td align=right valign=top> </td>
</tr>
</table>
<!------------------><!------------------><!------------------>
</form>
</body>
</html>
<%
function set_sbox(motxt, moname)
dim tval : tval=""
select case motxt
case "설문Type"
tval=tval&"<input type=""text"" name=""field_set_x_type"" id=""field_set_x_type"" value="""&moname&""" size=""12"" maxlength=""50"" style=""border:1px solid #FF0000;font-size:11pt;"" readonly >"
case "설문ID"
tval=tval&"<input type=""text"" name=""field_set_x_id"" id=""field_set_x_id"" value="""&moname&""" size=""12"" maxlength=""50"" style=""border:1px solid #FF0000;font-size:11pt;"" readonly >"
case "면접원ID"
tval=tval&"<input type=""text"" name=""field_set_x_name"" id=""field_set_x_name"" value="""&moname&""" size=""12"" maxlength=""50"" style=""border:1px solid #FF0000;font-size:11pt;"" readonly >"
case else
tval=tval&"<input type=""text"" name=""field_set_"&moname&""" id=""field_set_"&moname&""" value="""" size=""12"" maxlength=""50"" style=""border:1px solid #FF0000;font-size:11pt;"" >"
end select
set_sbox=tval
end function
%>