199 lines
7.2 KiB
Plaintext
199 lines
7.2 KiB
Plaintext
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@include file="/field_manager/include/manager_head.jsp"%>
|
|
<%
|
|
int c_home = Integer.parseInt(r_call(request.getParameter("c_home")));
|
|
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);
|
|
}
|
|
|
|
%>
|
|
<center>
|
|
<table width="1000" cellSpacing="0" cellPadding="0" border="0">
|
|
<tr >
|
|
<td >
|
|
<table width="100%" cellSpacing="0" cellPadding="0" border="0" bgcolor=ffffff>
|
|
<tr >
|
|
<td height="60" style="font-weight:bold;">
|
|
Apply Access statistics
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<!---------------------------------------------------------------------------------------->
|
|
<script>
|
|
function s_search(){
|
|
document.s_bcb.action="list.jsp";
|
|
document.s_bcb.method="post";
|
|
document.s_bcb.submit();
|
|
}
|
|
</script>
|
|
<table width="100%" cellSpacing="0" cellPadding="0" border="0" bgcolor=ffffff>
|
|
<form name="s_bcb" action="list.jsp" method="post" target="_self">
|
|
<tr >
|
|
<td align=left valign=bottom style="line-height:120%;padding-bottom:5px">
|
|
<select name="s_year" style="height:24px" onchange="s_search()">
|
|
<%for(int y = 2019 ; y < now_year + 1 ; y++){%>
|
|
<option value="<%=y%>" <%if(c_year == y){%>selected<%}%>><%=y%></option>
|
|
<%}%>
|
|
</select>
|
|
|
|
<select name="c_home" style="height:24px" onchange="s_search()">
|
|
<% String sql1_r=" SELECT * from tbl_field where c_relation = 0 and c_no = "+ c_home +" order by c_use asc, c_no desc";
|
|
ResultSet rst_r = stmt.executeQuery(sql1_r);
|
|
while (rst_r.next()) {
|
|
%>
|
|
<option value="<%=rst_r.getInt("c_no")%>" <%if(c_home == rst_r.getInt("c_no")){%>selected<%}%>><%=rst_r.getString("c_name")%></option>
|
|
<%}
|
|
rst_r.close();
|
|
%>
|
|
</select>
|
|
</td>
|
|
|
|
</tr>
|
|
</form>
|
|
</table>
|
|
<table width="100%" cellSpacing="1" cellPadding="0" border="0" bgcolor=cdcdcd>
|
|
<tr bgcolor=ededed style="font-weight:bold;">
|
|
<td height="26px" align=center>Menu</td>
|
|
<%for(int m = 1 ; m < 13 ; m++){%>
|
|
<td align=center width=60><%=m%>Month</td>
|
|
<%}%>
|
|
</tr>
|
|
<%
|
|
int m_co[] = new int[13];
|
|
String sql_co = "select c_visit, c_month from tbl_visit where c_home = "+ c_home +" and c_project_no = 0 and c_show_no = -1 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(c_home == 33){
|
|
%>
|
|
<tr bgcolor=ffffff onMouseover="this.bgColor='#B9C1FF'" onMouseout="this.bgColor='#ffffff'">
|
|
<td height="26px" align=left style="padding-left:10px" ><b>Intro Page</td>
|
|
<%for(int m = 1 ; m < 13 ; m++){%>
|
|
<td align=center >
|
|
<%if(m_co[m]>0){%>
|
|
<%=m_co[m]%>
|
|
<%}%>
|
|
</td>
|
|
<%}%>
|
|
</tr>
|
|
<%
|
|
}
|
|
%>
|
|
<%
|
|
for(int cho = 0; cho < 13; cho++){
|
|
m_co[cho] = 0;
|
|
}
|
|
sql_co = "select c_visit, c_month from tbl_visit where c_home = "+ c_home +" and c_project_no = 0 and c_show_no = 0 and c_c_no = 0 and c_year = " + c_year + " order by c_month asc ";
|
|
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();
|
|
|
|
%>
|
|
<tr bgcolor=ffffff onMouseover="this.bgColor='#B9C1FF'" onMouseout="this.bgColor='#ffffff'">
|
|
<td height="26px" align=left style="padding-left:10px" ><b>Main Page</td>
|
|
<%for(int m = 1 ; m < 13 ; m++){%>
|
|
<td align=center >
|
|
<%if(m_co[m]>0){%>
|
|
<%=m_co[m]%>
|
|
<%}%>
|
|
</td>
|
|
<%}%>
|
|
</tr>
|
|
<%
|
|
String sql1=" SELECT * from tbl_menu where c_up_no = 0 and c_home="+ c_home +" order by c_order asc";
|
|
ResultSet rst = stmt.executeQuery(sql1);
|
|
while (rst.next()) {
|
|
%>
|
|
<tr bgcolor=ffffff >
|
|
<td height="26px" align=left style="padding-left:10px" colspan=13><%=rst.getString("c_name")%> </td>
|
|
|
|
</tr>
|
|
<%
|
|
String sql12=" SELECT * from tbl_menu where c_up_no = "+ rst.getInt("c_no") +" order by c_order asc";
|
|
ResultSet rst2 = stmt2.executeQuery(sql12);
|
|
while (rst2.next()) {
|
|
%>
|
|
<%
|
|
for(int cho = 0; cho < 13; cho++){
|
|
m_co[cho] = 0;
|
|
}
|
|
sql_co = "select c_visit, c_month from tbl_visit where c_home = "+ c_home +" and c_project_no = 0 and c_show_no = "+ rst2.getInt("c_no") +" and c_c_no = 0 and c_year = " + c_year + " order by c_month asc ";
|
|
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();
|
|
|
|
%>
|
|
<tr bgcolor=ffffff onMouseover="this.bgColor='#B9C1FF'" onMouseout="this.bgColor='#ffffff'" >
|
|
<td height="26px" align=left style="padding-left:30px" >└ <%=rst2.getString("c_name")%> </td>
|
|
<%for(int m = 1 ; m < 13 ; m++){%>
|
|
<td align=center >
|
|
<%if(m_co[m]>0){%>
|
|
<%=m_co[m]%>
|
|
<%}%>
|
|
</td>
|
|
<%}%>
|
|
</tr>
|
|
<% }
|
|
rst2.close();
|
|
%>
|
|
<% }
|
|
rst.close();
|
|
%>
|
|
|
|
<tr bgcolor=ffffff >
|
|
<td height="26px" align=left style="padding-left:10px" colspan=13>Membership </td>
|
|
</tr>
|
|
<%
|
|
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;
|
|
}
|
|
sql_co = "select c_visit, c_month from tbl_visit where c_home = "+ c_home +" and c_project_no = 0 and c_show_no = "+ rst2.getInt("c_no") +" and c_c_no = 0 and c_year = " + c_year + " order by c_month asc ";
|
|
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();
|
|
|
|
%>
|
|
<tr bgcolor=ffffff onMouseover="this.bgColor='#B9C1FF'" onMouseout="this.bgColor='#ffffff'">
|
|
<td height="26px" align=left style="padding-left:30px" >└ <%=rst2.getString("c_name")%> </td>
|
|
<%for(int m = 1 ; m < 13 ; m++){%>
|
|
<td align=center >
|
|
<%if(m_co[m]>0){%>
|
|
<%=m_co[m]%>
|
|
<%}%>
|
|
</td>
|
|
<%}%>
|
|
</tr>
|
|
<% }
|
|
rst2.close();
|
|
%>
|
|
</table>
|
|
<!---------------------------------------------------------------------------------------->
|
|
|
|
</tr>
|
|
</table>
|
|
<br />
|
|
<br />
|
|
<br />
|
|
<br />
|
|
<%@include file="/field_manager/include/manager_bottom.jsp"%>
|