<% x = "2" Dim title() Max_Title = 26 Dim sel_type ReDim title(Max_Title, 3) Dim sel_year Dim doc_year_list() sel_year = CStr(Year(Now)) If Request("sel_year") <> "" Then sel_year = Request("sel_year") End If query = "select distinct 문서제목 from 문서내용 order by 문서제목" Rs.Open query, adoConn, 1 ReDim title(Rs.RecordCount, 3) title(0, 1) = "전체" i = 0 Do While Not Rs.EOF i = i + 1 title(i, 1) = Rs("문서제목") Rs.MoveNext Loop Rs.Close query = "select distinct left(발급일,4) as 발급일 from 문서내용 order by left(발급일,4) desc" Rs.Open query, adoConn, 1 ReDim doc_year_list(Rs.RecordCount) i = 0 Do While Not Rs.EOF i = i + 1 doc_year_list(i) = Rs("발급일") Rs.MoveNext Loop Rs.Close sel_type = Request("sel_type") If Trim(sel_type) = "" Then sel_type = "0" End If p_hotvalue = Request("p_hotvalue") if request("gotopage") <> "" then tmp_currentpage = request("gotopage") else tmp_currentpage = 1 end if %> <% Function ExtractTargetValue(val) Dim arr, s, p arr = Split(val, "^//^") s = arr(0) p = InStr(s, "^^") if p > 0 then ExtractTargetValue = Mid(s, p + 2) else ExtractTargetValue = s end if End Function %>

승인 문서

<% query = "SELECT a.*, b.* " query = query & "FROM Document a WITH(NOLOCK) " query = query & " INNER JOIN 문서내용 b WITH(NOLOCK) on a.d_no = b.문서번호 " query = query & " LEFT OUTER JOIN direct_costcode D1 WITH(NOLOCK) ON CONVERT(VARCHAR(5), b.target11) = CONVERT(VARCHAR(5), D1.id) " query = query & " LEFT OUTER JOIN direct_costcode D2 WITH(NOLOCK) ON CONVERT(VARCHAR(5), b.target12) = CONVERT(VARCHAR(5), D2.id) " query = query & "WHERE b.login_p_no <> '" & Session("User_Number") & "' " query = query & " AND a.d_delok = 'N' " If sel_type <> "0" Then query = query & " AND a.d_name = '" & title(sel_type, 1) & "' " Else query = query & " AND a.d_name <> '업무일지' " End If If sel_year <> "all" Then query = query & " AND a.d_no LIKE 'KRC-" & sel_year & "%' " End If If p_hotvalue <> "" Then query = query & " AND ( " query = query & " b.p_sn LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " a.d_write_name LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " D1.d_cost_name LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " D2.d_cost_name LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " a.d_no LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target8 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target9 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target20 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target21 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target22 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target23 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target24 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target25 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target26 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target27 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target28 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target29 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target30 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target31 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target32 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target33 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target34 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target35 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target36 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target37 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target38 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target39 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target40 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target41 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target42 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target43 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target44 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target45 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target46 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target47 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target48 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target49 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' OR " query = query & " b.target50 LIKE '%" & replace(p_hotvalue, "_", "[_]") & "%' " query = query & " ) " End If query = query & " AND a.d_order_cnt in ('77') " query = query & " AND (a.d_order1 = '" & Session("User_Number") & "' " for tmp_i = 2 to 4 query = query & " OR a.d_order" & tmp_i & " = '" & Session("User_Number") & "' " next query = query & " OR a.d_order5 = '" & Session("User_Number") & "') " query = query & "ORDER BY a.d_sn DESC " Rs.Open query, adoConn, 1 tmp_count = Rs.RecordCount %>
발급일 : 목록결과 : 총 <%=formatnumber(tmp_count,0)%>개의 항목이 있습니다.         <%if tmp_project_chk = "1" OR tmp_admin_chk = "1" then%> 문서종류 <%end if%>        작성자, 프로젝트 코드, 거래처, 항목, 세부, 문서번호, 품의문서로 검색 가능
<% if Rs.RecordCount > 0 then Rs.PageSize = 20 tmp_ok = 1 PageCount = Rs.PageCount Rs.absolutepage = tmp_Currentpage tmp_total_record = Rs.RecordCount tmp_for = Cint(tmp_total_record) - ((Cint(tmp_Currentpage) - 1) * Rs.PageSize) if Rs.PageSize <= tmp_for then if Rs.RecordCount <= Rs.PageSize then tmp_for = Rs.recordcount else tmp_for = Rs.PageSize end if else tmp_for = tmp_for end if for i = 1 to tmp_for tmp_txt = "완료" if Cint(tmp_Currentpage)=1 then Num=Cint(tmp_total_record)- i+1 else Num=Cint(tmp_total_record) - ((Cint(tmp_Currentpage) - 1) * Rs.PageSize) - i +1 end if tmp_flag = mid(Rs("d_no"), 10, 1) if Rs("d_name") = "직접비" then tmpstr = Rs("p_sn") else tmpstr = Rs("d_no") end if if Rs("d_name") = "문화체육비신청서" then tmp_flag = "o2" end If if Rs("d_name") = "면접원수당지출결의서" then tmp_flag = "t2" end If tmp_display_name = Rs("d_name") if tmp_display_name = "부서비신청서" then tmp_display_name = "그룹(장)활동비" end if if Rs("d_name") = "면접원수당지출결의서" or Rs("d_name") = "내근직수당지출결의서" then tmp_doc_code = ExtractTargetValue(Rs("target20")) tmp_doc_desc = ExtractTargetValue(Rs("target21")) else tmp_doc_code = Rs("target10") tmp_doc_desc = Rs("target1") end if %> <% Rs.MoveNext next end if Rs.Close %>
No. 문서분류 작성일 작성자 요청
<%=Num%> ','1','<%=x%>','<%=Rs("p_sn") %>')" class="blue"><%=tmp_display_name%>[<%=Rs("d_no")%>] ◆([<%=tmp_doc_code%>] <%=tmp_doc_desc%>) <%=Rs("d_write_date")%> <%=Rs("login_이름")%> 처리완료
<%=Pagelist("allow_listall.asp",tmp_currentpage ,tmp_bcolor , "", pagecount, "&b_type=" & b_type & "&sel_type=" & sel_type & "&p_hotvalue=" & p_hotvalue & "&sel_year=" & sel_year)%>