<% dim command command = Request("command") s_date_st = request("s_date_st") s_date_end = request("s_date_end") s_name = request("s_name") s_p_sn = request("s_p_sn") s_p_subject = request("s_p_subject") s_column = replace(request("s_column"), " ", "") Dim column_dic Set column_dic = Server.CreateObject("Scripting.Dictionary") With column_dic .Add "intranet_project", "인트라넷프로젝트" .Add "p_child_sn", "FCS프로젝트" .Add "p_subject", "프로젝트명" .Add "work_kind", "업무구분" .Add "m_name", "면접원 성명" .Add "s_area", "지역" .Add "s_type", "설문Type" .Add "inspection_user_name", "검증원 성명" .Add "r_date", "이관날짜" .Add "sum_esc", "이관부수" .Add "sum_tok", "TOK" .Add "sum_pass", "PASS" .Add "sum_err", "ERR" .Add "sum_notel", "NOTEL" End With if command <> "excel" then %>

FF 면접원 현황

<% End If if command = "excel" then Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition","attachment;filename=FF_Status.xls" end if %>
<% If command <> "excel" Then %> <% End if %> <% if command <> "" Then %> <% End if %>
기 간 ~ 면접원 성명
프로젝트 코드 프로젝트 명
집계 Column 선택
검색 시 1분에서 10분 가량 소요될 수 있습니다
<% query = " SELECT " if s_column <> "" Then query = query & " " & s_column & ", " else query = query & " intranet_project, p_subject, m_name, " End if query = query & " SUM(esc_cnt) as sum_esc, SUM(tok_cnt) as sum_tok, SUM(err_cnt) as sum_err, SUM(no_tel) as sum_notel, SUM(pass_cnt) as sum_pass " query = query & " FROM " query = query & " ( " query = query & " SELECT TPF.p_subject, CASE WHEN TPF.intranet_project = '' THEN TPF.p_child_sn ELSE TPF.intranet_project END as intranet_project, " query = query & " TPF.p_child_sn, R.r_date, R.s_area, R.s_type, " query = query & " R.m_name, R.m_no, " query = query & " 1 as esc_cnt, " query = query & " CASE WHEN TIR.r_result = '1' AND TIR.qc_stat = 'OK' THEN 1 ELSE 0 END as tok_cnt, " query = query & " CASE WHEN TIR.r_result <> '1' AND TIR.pass_stat = 'PASS' THEN 1 ELSE 0 END as pass_cnt, " query = query & " CASE WHEN TIR.pass_stat = 'ERROR' THEN 1 ELSE 0 END as err_cnt, " query = query & " CASE WHEN TIR.r_result IN ('5', '6', '7') AND TIR.pass_stat NOT IN ('ERROR', 'PASS') THEN 1 ELSE 0 END as no_tel, " query = query & " ISNULL(M.m_name, ISNULL(P.p_name, '')) as inspection_user_name, ISNULL(TIR.inspection_user, '') as inspection_user, CONVERT(VARCHAR(10), TIR.inspection_date, 120) as inspection_date " query = query & " FROM RES R WITH(NOLOCK) " query = query & " LEFT OUTER JOIN T_INSPECTION_RES TIR WITH(NOLOCK) ON R.r_sn = TIR.r_sn " query = query & " LEFT OUTER JOIN V_PROJECT_FCS TPF WITH(NOLOCK) ON R.p_sn = TPF.p_child_sn " query = query & " LEFT OUTER JOIN Man M WITH(NOLOCK) ON TIR.inspection_user = M.id " query = query & " LEFT OUTER JOIN Person P WITH(NOLOCK) ON TIR.inspection_user = P.p_no " query = query & " WHERE DelGubun = 'N' AND r_error IS NULL AND s_error IS NULL AND m_error IS NULL AND q_error IS NULL " query = query & " ) T " query = query & " WHERE r_date BETWEEN '" & s_date_st & "' AND '" & s_date_end & "' " If s_name <> "" Then query = query & " AND m_name LIKE '%" & s_name & "%' " End If If s_p_sn <> "" Then query = query & " AND intranet_project LIKE '" & s_p_sn & "%' " End If If s_p_subject <> "" Then query = query & " AND p_subject LIKE '%" & s_p_subject & "%' " End If if s_column <> "" Then query = query & " GROUP BY " & s_column & " " query = query & " ORDER BY " & s_column & " " Else query = query & " GROUP BY intranet_project, p_subject, m_name " query = query & " ORDER BY intranet_project, p_subject, m_name " End if 'response.Write query AdoRs.open query, adoconn, adopenstatic, adlockreadonly If AdoRs.RecordCount > 0 Then %> <% For i = 0 To AdoRs.fields.count - 1 %> <% Next %> <% Else %> <% End If Do While Not AdoRs.Eof %> <% For i = 0 To AdoRs.fields.count - 1 ' 원래 - 1 만 해야되는데, 마지막 컬럼 cnt 에 Detail 화면 링크를 걸기위해 조정 %> <% Next %> <% AdoRs.MoveNext Loop %>
<%= column_dic.Item(AdoRs.fields(i).Name)%> 
검색 결과가 없습니다
<%= AdoRs.fields(i) %>
<%if command <> "excel" then%>
<% end if %>