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

141 lines
5.8 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_ans_view(x,xpn_cd,xpu_type,xpu_area,xpu_que,xpu_que_label){
if(xpu_que_label==""){
alert("등록된 보기정보가 없습니다 ");
return false;
}
var url = "punching_field_setting_ok_view_ans.asp?";
url=url+"pn_cd="+xpn_cd;
url=url+"&pu_que="+xpu_que;
url=url+"&pu_area="+xpu_area;
url=url+"&pu_type="+xpu_type;
var pwidth=800;
var pheight=700;
var tleft=(screen.width-pwidth)/2;
var ttop=(screen.height-pheight)/2;
winObj=window.open(url, "wins2_1", "left="+tleft+", top="+ttop+", menubar=no, location=no, status=no, toolbar=no, width="+pwidth+", height="+pheight+", scrollbars=yes ,resizable=no");
}
</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%>" ><!-- 펀칭지역 -->
<!------------------><!------------------><!------------------>
<br><br>
<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:opener.parent_function();window.open('about:blank','_parent').parent.close();" 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;" border='1' bordercolordark='#FFFFFF' cellspacing='0' cellpadding='5' align=center >
<tr height="25px">
<td width="5%" align="center" bgcolor='#E2E2E2' style='word-break:break-all' >No</td>
<td width="13%" align="center" bgcolor='#E2E2E2' style='word-break:break-all' >펀칭문번</td>
<td width="19%" align="center" bgcolor='#E2E2E2' style='word-break:break-all' >검증 라벨 </td>
<td width="17%" align="center" bgcolor='#E2E2E2' style='word-break:break-all' >이름</td>
<td width="19%" align="center" bgcolor='#E2E2E2' style='word-break:break-all' >검증<br>휴대폰번호(1)</td>
<td width="19%" align="center"bgcolor='#E2E2E2' style='word-break:break-all' >검증<br>일반번호(2)</td>
</tr>
<%
dim a : a=1
sql=" select A.*, isnull(B.pu_que_ans,'') as pu_que_ans from "
sql=sql&" ( "
sql=sql&" select * from [project2].[dbo].[T_RES_SQ_QUE_LAB] "
sql=sql&" where ting='1' "
sql=sql&" and pu_que_type in ('0','2','3') " '-- 검증문항(0) / 검증전화번호(2) / 이름(3)
sql=sql&" and pu_child_sn='"&pn_cd&"' "
sql=sql&" and pu_type='"&pu_type&"' "
'-- fcs 지역 sql=sql&" and fcs_area='"&pu_area&"' "
sql=sql&" ) A "
sql=sql&" left join "
sql=sql&" ( "
sql=sql&" select pu_que as pu_que_ans from [project2].[dbo].[T_RES_SQ_ANS_LAB] "
sql=sql&" where ting='1' "
sql=sql&" and pu_child_sn='"&pn_cd&"' "
sql=sql&" and pu_type='"&pu_type&"' "
'-- fcs 지역 sql=sql&" and fcs_area='"&pu_area&"' "
sql=sql&" group by pu_que "
sql=sql&" ) B "
sql=sql&" on A.pu_que=B.pu_que_ans "
sql=sql&" order by A.pu_que_type desc, A.tphone_1 desc, A.tphone_2 desc, A.id asc "
rsp.Open sql, adoConn, 1
while not rsp.Eof
%>
<tr onMouseOver=bgColor="#F3F3F3" onMouseOut=bgColor="#FFFFFF" bgcolor="#FFFFFF" style="cursor: pointer;" onclick="javascript:js_ans_view(xform,'<%=pn_cd%>','<%=pu_type%>','<%=pu_area%>','<%=rsp("pu_que")%>','<%=rsp("pu_que_ans")%>');" >
<td align="center" style='word-break:break-all' >&nbsp;<%=a%></td>
<td align="center" style='word-break:break-all' >&nbsp;<%=rsp("pu_que")%></td>
<td align="left" style='word-break:break-all' >&nbsp;<%=replace(replace(rsp("pu_que_label"),"phone_number",""),"user_name","")%></td>
<td align="center" style='word-break:break-all' >&nbsp;<%=replace(rsp("tuser_name"),"user_name","응답자 이름")%></td>
<td align="center" style='word-break:break-all' >&nbsp;<%=replace(rsp("tphone_1"),"phone_number","검증 전화번호(1)")%></td>
<td align="center" style='word-break:break-all' >&nbsp;<%=replace(rsp("tphone_2"),"phone_number","검증 전화번호(2)")%></td>
</tr>
<%
a=a+1
rsp.movenext
Wend
rsp.Close
%>
</table>
</td>
</tr>
<tr>
<td align=center valign=top > </td>
</tr>
<tr>
<td align=center valign=top >
<input type="button" value=" <<<<<<<<<<< 창 닫 기 >>>>>>>>>>>> " name="btn01" class="button black medium" onclick="javascript:opener.parent_function();window.open('about:blank','_parent').parent.close();" style="font-size:11pt;width:500px;" >
</td>
</tr>
</table>
<br><br>
<!------------------><!------------------><!------------------>
</form>
</body>
</html>