<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@include file="/field_manager/include/manager_head.jsp"%> <% int c_home = 0; String s_year = r_call(request.getParameter("s_year")); Calendar currentCalendar = Calendar.getInstance(); int now_year = currentCalendar.get(Calendar.YEAR); int now_month = currentCalendar.get(Calendar.MONTH) + 1; int c_year = now_year; if(!s_year.equals("")){ c_year = Integer.parseInt(s_year); } %> <% String c_project_no = r_call(request.getParameter("c_project_no")); if(c_project_no.equals("")){ %> <% }else{ String sql_up = " SELECT c.*, a.c_name as u_name, b.c_name as f_name from tbl_project c "; sql_up = sql_up + " inner join tbl_project a on a.c_no = c.c_up_no "; sql_up = sql_up + " inner join tbl_field b on b.c_no = a.c_field "; sql_up = sql_up + " where c.c_no = " + c_project_no; ResultSet rs_up = stmt.executeQuery(sql_up); if (rs_up.next()) { %>

Project BMC access statistics Field <%=rs_up.getString("f_name")%> Category <%=rs_up.getString("u_name")%> Project <%=rs_up.getString("c_name")%> <% } rs_up.close(); %> <%for(int y = 2018 ; y < now_year + 1 ; y++){%> selected<%}%>><%=y%> <%}%> <%for(int m = 1 ; m < 13 ; m++){%> <%}%> <% int m_co[] = new int[13]; String sql1=" SELECT * from tbl_menu where c_no > 1 and c_up_no = 0 and c_home="+ c_home +" order by c_no asc"; ResultSet rst = stmt.executeQuery(sql1); while (rst.next()) { %> <% for(int cho = 0; cho < 13; cho++){ m_co[cho] = 0; } String sql_co = "select c_visit, c_month from tbl_visit where c_home = "+ c_home +" and c_project_no = "+ c_project_no +" and c_show_no = "+ rst.getInt("c_no") +" and c_c_no = 0 and c_year = " + c_year + " order by c_month asc "; ResultSet rs_co = stmt.executeQuery(sql_co); while(rs_co.next()){ m_co[rs_co.getInt("c_month")] = rs_co.getInt("c_visit"); } rs_co.close(); %> <% if(rst.getInt("c_no") == 10){%> <%} %> <%for(int m = 1 ; m < 13 ; m++){%> <%}%> <% } rst.close(); %> <% String sql121=" SELECT * from tbl_menu where c_up_no = 1 order by c_order asc"; ResultSet rst2 = stmt2.executeQuery(sql121); while (rst2.next()) { %> <% for(int cho = 0; cho < 13; cho++){ m_co[cho] = 0; } String sql_co = "select c_visit , c_month from tbl_visit where c_home = "+ c_home +" and c_project_no = "+ c_project_no +" and c_show_no = "+ rst2.getInt("c_no") +" and c_c_no = 0 and c_year = " + c_year + " order by c_month asc "; ResultSet rs_co = stmt.executeQuery(sql_co); while(rs_co.next()){ m_co[rs_co.getInt("c_month")] = rs_co.getInt("c_visit"); } rs_co.close(); %> <%for(int m = 1 ; m < 13 ; m++){%> <%}%> <% } rst2.close(); %> Menu <%=m%>Month Data 9 && rst.getInt("c_no") <13){%>30px<%}else{%>10px<%}%>" ><%if(rst.getInt("c_no") > 9 && rst.getInt("c_no") <13){%>└<%}%> <%=rst.getString("c_name")%> <%if(m_co[m]>0){%> <%=m_co[m]%> <%}%> Membership └ <%=rst2.getString("c_name")%> <%if(m_co[m]>0){%> <%=m_co[m]%> <%}%>

<% } %> <%@include file="/field_manager/include/manager_bottom.jsp"%>