Files
KIN/inspection/prj_list_modal.asp
2025-09-29 17:55:08 +09:00

90 lines
4.5 KiB
Plaintext
Raw Permalink Blame History

<!-- #include virtual = "lib/config.asp" -->
<%
Response.CharSet = "EUC-KR"
Dim n_gubun : n_gubun = Request("gubun")
Dim prj_sv
Dim p_url
select case n_gubun
case "p"
prj_sv = "and (p_punch_1 = '" & Session("USER_NUMBER") & "' or p_punch_2 = '" & Session("USER_NUMBER") & "' or p_punch_3 = '" & Session("USER_NUMBER") & "' or p_punch_4 = '" & Session("USER_NUMBER") & "') "
p_url = "punching_confirm.asp"
case "v1"
prj_sv = "and (p_verify_1 = '" & Session("USER_NUMBER") & "' or p_verify_2 = '" & Session("USER_NUMBER") & "' or p_verify_3 = '" & Session("USER_NUMBER") & "' or p_verify_4 = '" & Session("USER_NUMBER") & "') "
p_url = "ins_confirm.asp"
case "v2"
prj_sv = "and (p_verify_1 = '" & Session("USER_NUMBER") & "' or p_verify_2 = '" & Session("USER_NUMBER") & "' or p_verify_3 = '" & Session("USER_NUMBER") & "' or p_verify_4 = '" & Session("USER_NUMBER") & "') "
p_url = "cins_confirm.asp"
case "etc"
prj_sv = "and (p_verify_1 = '" & Session("USER_NUMBER") & "' or p_verify_2 = '" & Session("USER_NUMBER") & "' or p_verify_3 = '" & Session("USER_NUMBER") & "' or p_verify_4 = '" & Session("USER_NUMBER") & "' "
prj_sv = prj_sv&" or p_punch_1 = '" & Session("USER_NUMBER") & "' or p_punch_2 = '" & Session("USER_NUMBER") & "' or p_punch_3 = '" & Session("USER_NUMBER") & "' or p_punch_4 = '" & Session("USER_NUMBER") & "' "
prj_sv = prj_sv&" or p_code_1 = '" & Session("USER_NUMBER") & "' or p_code_2 = '" & Session("USER_NUMBER") & "' or p_code_3 = '" & Session("USER_NUMBER") & "' or p_code_4 = '" & Session("USER_NUMBER") & "' "
prj_sv = prj_sv&" or p_sv_1 = '" & Session("USER_NUMBER") & "' or p_sv_2 = '" & Session("USER_NUMBER") & "' or p_sv_3 = '" & Session("USER_NUMBER") & "' or p_sv_4 = '" & Session("USER_NUMBER") & "')"
p_url = "qetc_confirm.asp"
case "success"
prj_sv = "and (p_verify_1 = '" & Session("USER_NUMBER") & "' or p_verify_2 = '" & Session("USER_NUMBER") & "' or p_verify_3 = '" & Session("USER_NUMBER") & "' or p_verify_4 = '" & Session("USER_NUMBER") & "' "
prj_sv = prj_sv&" or p_punch_1 = '" & Session("USER_NUMBER") & "' or p_punch_2 = '" & Session("USER_NUMBER") & "' or p_punch_3 = '" & Session("USER_NUMBER") & "' or p_punch_4 = '" & Session("USER_NUMBER") & "' "
prj_sv = prj_sv&" or p_code_1 = '" & Session("USER_NUMBER") & "' or p_code_2 = '" & Session("USER_NUMBER") & "' or p_code_3 = '" & Session("USER_NUMBER") & "' or p_code_4 = '" & Session("USER_NUMBER") & "')"
p_url = "prj_success.asp"
end Select
%>
<script>
$(function () {
$(".prj_pick").css("cursor", "pointer");
$(".prj_pick").each(function () {
$(this).mouseover(function () {
$(this).children("td").css("color", "blue");
$(this).children("td").css("font-weight", "bold");
});
$(this).mouseout(function () {
$(this).children("td").css("color", "");
$(this).children("td").css("font-weight", "normal");
});
});
$(".prj_pick").click(function () {
$("#prj_code").val($(this).children('td:eq(0)').text());
$("#prj_name").val($(this).children('td:eq(1)').text());
$("#prj_search").attr("action", "<%=p_url %>");
$("#prj_search").submit();
});
});
</script>
<form id="prj_search" method="post">
<input type="hidden" name="prj_code" id="prj_code" value="" />
<input type="hidden" name="prj_name" id="prj_name" value="" />
<table width="100%" class="table table-sm table-sm2 table-bordered table-head tr-colors">
<tr>
<td align="center" ><3E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ʈ <20>ڵ<EFBFBD></td>
<td align="center" ><3E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ʈ <20><></td>
</tr>
<%
query = ""
query = query &" select * from project2.dbo.T_PROJECT_METHOD "
If n_gubun = "success" Then
query = query &" where p_field_complete = '1' "
Else
query = query &" where p_field_complete is null "
End If
query = query &" and p_child_sn is not null and p_child_sn > '20' "
if Session("Depart_code") <> "18" Then
query = query &prj_sv
End If
query = query &" order by p_child_sn "
Rs.open query, adoconn, adopenstatic, adlockreadonly
while not rs.eof
%>
<tr class="prj_pick">
<td ><%=Rs("p_child_sn") %></td>
<td ><%=Rs("p_subject") %></td>
</tr>
<%
rs.movenext
wend
Rs.close
%>
</table>
</form>