73 lines
3.9 KiB
Plaintext
73 lines
3.9 KiB
Plaintext
|
|
<!-- #include virtual = "lib/config.asp" -->
|
|
<OBJECT RUNAT=Server PROGID=ADODB.Recordset id=rsp></OBJECT>
|
|
<%'
|
|
|
|
|
|
p_child_sn = request("p_child_sn")
|
|
depart_type = request("depart_type")
|
|
|
|
' Session.CodePage = 65001 '한글
|
|
Response.CharSet = "EUC-KR" '한글
|
|
Response.AddHeader "Pragma","no-cache"
|
|
Response.AddHeader "cache-control", "no-staff"
|
|
Response.Expires = -1
|
|
|
|
if depart_type = "2" then ' 실사는 그냥 패스
|
|
response.Write "1"
|
|
response.end
|
|
end if
|
|
|
|
query = "" ' export_range <- 용역범위, a_cnt <- 견적서 또는 제안서, b_cnt <- 보고서, c_cnt <- 설문지, d_cnt <- 전산팀(DP)
|
|
query = query & " SELECT isnull(isnull(isnull(a.p_export_range, b.p_export_range), c.p_export_range), d.p_export_range) as export_range , isnull(a.a_CNT, 0) as a_cnt, isnull(b.b_CNT, 0) as b_cnt, isnull(c.c_CNT, 0) as c_cnt, isnull(d.d_CNT, 0) as d_cnt, "
|
|
query = query & " (SELECT COUNT(*) FROM T_SYSTEM_ATTACH WHERE f_p_sn = '" & LEFT(p_child_sn, 7) & "' AND f_use_yn = 'Y' AND f_kind = '010') as contract_cnt FROM "
|
|
query = query & " ( "
|
|
query = query & " SELECT p_export_range, count(*) as a_CNT FROM "
|
|
query = query & " (SELECT p_export_range FROM V_PROJECT_METHOD WHERE p_child_sn = '" & p_child_sn & "') A, "
|
|
query = query & " (SELECT f_kind FROM T_SYSTEM_ATTACH WHERE f_p_sn = '" & LEFT(p_child_sn, 7) & "' AND f_use_yn = 'Y' AND f_kind IN ('002', '003') GROUP BY f_kind) B "
|
|
query = query & " GROUP BY p_export_range "
|
|
query = query & " ) A full outer join "
|
|
query = query & " ( "
|
|
query = query & " SELECT p_export_range, count(*) as b_CNT FROM "
|
|
query = query & " (SELECT p_export_range FROM V_PROJECT_METHOD WHERE p_child_sn = '" & p_child_sn & "') A, "
|
|
query = query & " (SELECT f_kind FROM T_SYSTEM_ATTACH WHERE f_p_sn = '" & LEFT(p_child_sn, 7) & "' AND f_use_yn = 'Y' AND f_kind IN ('004') GROUP BY f_kind) B "
|
|
query = query & " GROUP BY p_export_range "
|
|
query = query & " ) B on 1=1 full outer join "
|
|
query = query & " ( "
|
|
query = query & " SELECT p_export_range, count(*) as c_CNT FROM "
|
|
query = query & " (SELECT p_export_range FROM V_PROJECT_METHOD WHERE p_child_sn = '" & p_child_sn & "') A, "
|
|
query = query & " (SELECT f_kind FROM T_SYSTEM_ATTACH WHERE f_p_sn = '" & LEFT(p_child_sn, 7) & "' AND f_use_yn = 'Y' AND f_kind IN ('005', '006') GROUP BY f_kind) B "
|
|
query = query & " GROUP BY p_export_range "
|
|
query = query & " ) C on 1=1 full outer join "
|
|
query = query & " ( "
|
|
query = query & " SELECT p_export_range, count(*) as d_CNT FROM "
|
|
query = query & " (SELECT p_export_range FROM V_PROJECT_METHOD WHERE p_child_sn = '" & p_child_sn & "') A, "
|
|
query = query & " (SELECT f_kind FROM T_SYSTEM_ATTACH WHERE f_p_sn = '" & LEFT(p_child_sn, 7) & "' AND f_use_yn = 'Y' AND f_kind IN ('009') GROUP BY f_kind) B "
|
|
query = query & " GROUP BY p_export_range "
|
|
query = query & " ) D on 1=1 "
|
|
|
|
rsp.Open query, adoConn, 1
|
|
'response.write query & "<br>"
|
|
|
|
ret_val = "0"
|
|
if rsp.recordCount > 0 then
|
|
if depart_type = "1" then
|
|
if rsp("export_range") = "001" then '용역범위 - 테이블 및 데이터 인 경우
|
|
if cint(rsp("contract_cnt")) >= 1 and cint(rsp("a_cnt")) >= 1 and cint(rsp("c_cnt")) >= 1 then ' 제안서 또는 견적서가 있고, 설문지가 있으면,
|
|
ret_val = "1"
|
|
end if
|
|
else '용역범위 - 보고서, Top-line/Brief 경우
|
|
if cint(rsp("contract_cnt")) >= 1 and cint(rsp("a_cnt")) >= 1 and cint(rsp("b_cnt")) >= 1 and cint(rsp("c_cnt")) >= 1 then ' 제안서 또는 견적서가 있고, 보고서가 있으며, 설문지도 있을 때,
|
|
ret_val = "1"
|
|
end if
|
|
end if
|
|
elseif depart_type = "3" then
|
|
if cint(rsp("d_cnt")) >= 1 then ' 전산(DP)가 있으면
|
|
ret_val = "1"
|
|
end if
|
|
end if
|
|
end if
|
|
response.Write ret_val
|
|
|
|
rsp.close
|
|
%> |