|
|
<%@page import="java.net.URLDecoder"%> |
|
|
<%@ page contentType="text/html; charset=UTF-8" |
|
|
import="java.net.URLEncoder" import="java.util.Date" |
|
|
import="java.text.*" import="kr.co.kihyun.util.MDate" |
|
|
import="kr.co.kihyun.lang.MLong" import="kr.co.kihyun.lang.MString" |
|
|
import="kr.co.kihyun.moumi.Moumi" import="kr.co.kihyun.moumi.MoumiUtil" |
|
|
import="kr.co.kihyun.beans.user.HttpSSOLogin" |
|
|
import="kr.co.kihyun.beans.user.UserGroup" |
|
|
import="kr.co.kihyun.beans.user.User" |
|
|
import="kr.co.kihyun.beans.user.UserGroupList" |
|
|
import="kr.co.kihyun.beans.user.Dept" |
|
|
import="kr.co.kihyun.lang.Encoder" |
|
|
import="kr.co.kihyun.beans.entity.MUser" import="java.util.*" |
|
|
import="javax.jdo.PersistenceManager" import="javax.jdo.Transaction" |
|
|
import="kr.co.kihyun.beans.entity.*" |
|
|
import="kr.co.kihyun.beans.entity.util.*" |
|
|
import="kr.co.kihyun.beans.entity.UserPart" |
|
|
import="kr.co.kihyun.service.*" import="kr.co.kihyun.service.vo.*" |
|
|
import="java.util.HashMap" |
|
|
import="java.util.Map" import="javax.jdo.Query" import="kr.co.kihyun.moumi.MoumiConfig" |
|
|
import="org.slf4j.Logger" import="org.slf4j.LoggerFactory" |
|
|
%> |
|
|
|
|
|
<%@ include file="/totsys/common/inc/sec/secure.inc.jsp"%> |
|
|
<% |
|
|
//final Logger LOG = LoggerFactory.getLogger(this.getClass()); |
|
|
PersistenceManager pm = new MPersistenceManager(PMF.get().getPersistenceManager()); |
|
|
Transaction tx = pm.currentTransaction(); |
|
|
try{ |
|
|
/********** session³»ÀÇ userId **********/ |
|
|
String usID = HttpSSOLogin.getLoginID(request); |
|
|
String deptID = HttpSSOLogin.getDeptID(request); |
|
|
int sysAuth = HttpSSOLogin.getSysAuth(request); |
|
|
|
|
|
/****** Parameter *******/ |
|
|
//String strPage = clearXSS(request.getParameter("strPage"),""); |
|
|
String searchType = clearXSS(request.getParameter("searchType"),""); |
|
|
String dateType = clearXSS(request.getParameter("dateType"),""); |
|
|
String stDate = clearXSS(request.getParameter("stDate"),""); |
|
|
String edDate = clearXSS(request.getParameter("edDate"),""); |
|
|
String searchOrgan = clearXSS(request.getParameter("search_organ"),""); |
|
|
String searchDept = clearXSS(request.getParameter("search_dept"),""); |
|
|
String chkboxDept = clearXSS(request.getParameter("chkbox_dept"),""); |
|
|
String chkboxSchool = clearXSS(request.getParameter("chkbox_school"),""); |
|
|
String searchOrganName = ""; |
|
|
|
|
|
tx.begin(); |
|
|
|
|
|
List list = null; |
|
|
DecimalFormat numberFormat = new DecimalFormat("#,###,###"); |
|
|
Long now_today = new Date().getTime(); |
|
|
SimpleDateFormat dForomat = new SimpleDateFormat("yyyy-MM-dd"); |
|
|
|
|
|
MDept mDept = pm.getObjectById(MDept.class, deptID); |
|
|
|
|
|
|
|
|
// if( LOG.isDebugEnabled() ) { |
|
|
// LOG.debug("sysAuth={}", sysAuth); |
|
|
// } |
|
|
|
|
|
boolean disableOrgan = false; |
|
|
boolean disableDept = false; |
|
|
|
|
|
DeptService deptService = new DeptService(pm); |
|
|
String sOrgan = "ALL"; |
|
|
String sDept = "ALL"; |
|
|
List organDeptList = null; |
|
|
List deptList = null; |
|
|
String rootDept = ""; |
|
|
//=========================================================== |
|
|
// ±³À°Ã», ºÎ¼, Çб³¿¡ ´ëÇÑ ÄÞº¸¹Ú½º °ª Á¶È¸ |
|
|
//=========================================================== |
|
|
if( sysAuth == SysAuth.SYSADM.ordinal() ) { |
|
|
//9.½Ã½ºÅÛ°ü¸®ÀÚ |
|
|
rootDept = mDept.getRootDept(pm).getId(); |
|
|
organDeptList = deptService.getLOVFromDept(DeptService.TYPE.SAME_ROOT_DEPT, rootDept); |
|
|
}else if( sysAuth == SysAuth.SUB_SYSADM.ordinal() ) { |
|
|
//7.±â°ü½Ã½ºÅÛ°ü¸®ÀÚ |
|
|
sOrgan = mDept.getOrgan(); |
|
|
if( deptID.equals(sOrgan) ) { |
|
|
//±â°ü |
|
|
disableOrgan = true; |
|
|
organDeptList = new ArrayList(); |
|
|
CodeVO codeVO = new CodeVO(); |
|
|
codeVO.setCode(mDept.getName()); |
|
|
codeVO.setValue(mDept.getId()); |
|
|
organDeptList.add(codeVO); |
|
|
}else{ |
|
|
//ºÎ¼, Çб³ |
|
|
sDept = deptID; |
|
|
disableOrgan = true; |
|
|
disableDept = true; |
|
|
organDeptList = new ArrayList(); |
|
|
CodeVO organCode = new CodeVO(); |
|
|
MDept mOrgan = pm.getObjectById(MDept.class, sOrgan); |
|
|
organCode.setCode(mOrgan.getName()); |
|
|
organCode.setValue(mOrgan.getId()); |
|
|
organDeptList.add(organCode); |
|
|
deptList = new ArrayList(); |
|
|
CodeVO codeVO = new CodeVO(); |
|
|
codeVO.setCode(mDept.getName()); |
|
|
codeVO.setValue(mDept.getId()); |
|
|
deptList.add(codeVO); |
|
|
|
|
|
Grade grade = mDept.getGrade(); |
|
|
if( grade == Grade.NULL ) { |
|
|
//ºÎ¼ |
|
|
chkboxDept = "D"; |
|
|
}else{ |
|
|
//Çб³ |
|
|
chkboxSchool = "S"; |
|
|
} |
|
|
} |
|
|
} |
|
|
//=========================================================== |
|
|
if( !searchType.equals("") ) { |
|
|
sOrgan = searchOrgan; |
|
|
sDept = searchDept; |
|
|
String sDeptSchoolType = MString.checkNull(chkboxDept, chkboxSchool); |
|
|
|
|
|
StatisticsService service = new StatisticsService(pm); |
|
|
|
|
|
Map params = new HashMap(); |
|
|
params.put("organId", sOrgan); |
|
|
params.put("deptId", sDept); |
|
|
params.put("deptSchoolType", sDeptSchoolType); |
|
|
if( searchType.equals("all") ) { |
|
|
params.put("startDate", stDate); |
|
|
params.put("endDate", edDate); |
|
|
|
|
|
list = service.getStatisticsForAll(params); |
|
|
}else if( searchType.equals("period") ) { |
|
|
params.put("dateType", dateType); |
|
|
params.put("stDate", stDate); |
|
|
params.put("edDate", edDate); |
|
|
list = service.getStatisticsByDate(params); |
|
|
} |
|
|
} |
|
|
%> |
|
|
|
|
|
<html> |
|
|
<head> |
|
|
<title><%=Moumi.getTitle()%></title> |
|
|
<link rel="stylesheet" href="images/text.css" type="text/css"> |
|
|
<link rel="stylesheet" href="/totsys/common/css/kecttep.css" type="text/css"> |
|
|
<link rel="stylesheet" href="/totsys/common/css/SquareButtons.css" type="text/css"> |
|
|
<style> |
|
|
span.box_shape { |
|
|
height: 22px; |
|
|
width: 100px; |
|
|
background-color: #d1be91; |
|
|
font-family: Dotum; |
|
|
font-size: 12px; |
|
|
font-weight: bold; |
|
|
padding-top: 3px; |
|
|
border: 1px solid #333333; |
|
|
text-align: center; |
|
|
color: #FFFFFF; |
|
|
} |
|
|
|
|
|
</style> |
|
|
<script src="images/rollover.js"></script> |
|
|
<script src="/totsys/common/js/find.js"></script> |
|
|
<script src="/totsys/common/js/util.js"></script> |
|
|
<script src="/totsys/common/js/calendar.js"></script> |
|
|
<script type="text/javascript" src="/totsys/common/js/jquery-1.12.4.min.js"></script> |
|
|
<script type="text/javascript" src="/totsys/common/js/jquery.custom.indicator.js"></script> |
|
|
<script language="javascript"> |
|
|
/** |
|
|
* DOM°´Ã¼°¡ ¸ðµÎ ·ÎµùµÈ ÈÄ È£ÃâµÇ´Â ÇÔ¼ö |
|
|
* @param {type} param |
|
|
*/ |
|
|
$(document).ready(function() { |
|
|
//±â°£º°, Àüü¿¡ µû¸¥ °Ë»öÁ¶°Ç¿¡ ´ëÇÑ Ç¥½Ã ¿©ºÎ °áÁ¤ |
|
|
var searchType = "<%=searchType%>"; |
|
|
$rdSearchType = $('input[type="radio"][name="searchType"]'); |
|
|
if( searchType == "period") { |
|
|
$rdSearchType[0].click(); |
|
|
$rdDateType = $('input[type="radio"][name="dateType"][value="<%= dateType %>"]')[0].checked = true; |
|
|
}else if( searchType == "all") { |
|
|
$rdSearchType[1].click(); |
|
|
} |
|
|
//±³À°Ã» ÄÞº¸¹Ú½º ¼±Åà |
|
|
$("#id_organ").val("<%= sOrgan %>"); |
|
|
|
|
|
<% if( !MString.isNull(chkboxDept) ) { %> |
|
|
//ºÎ¼ üũ¹Ú½º ¼±Åà ó¸® |
|
|
$("#id_chk_dept").attr("checked", true); |
|
|
<% }else if( !MString.isNull(chkboxSchool) ) {%> |
|
|
//Çб³ üũ¹Ú½º ¼±Åà ó¸® |
|
|
$("#id_chk_school").attr("checked", true); |
|
|
<% } %> |
|
|
fn_onChangeOrgan(); |
|
|
|
|
|
<% if( disableOrgan ) { %> |
|
|
//±³À°Ã» ÄÞº¸¹Ú½º ºñÈ°¼º ó¸® |
|
|
$("#id_organ").attr("disabled", true); |
|
|
<% } |
|
|
if( disableDept ) { |
|
|
%> |
|
|
//ºÎ¼, Çб³ üũ¹Ú½º ¹× ÄÞº¸¹Ú½º ºñÈ°¼º ó¸® |
|
|
$("#id_dept").attr("disabled", true); |
|
|
$("#id_chk_dept").attr("disabled", true); |
|
|
$("#id_chk_school").attr("disabled", true); |
|
|
<% } %> |
|
|
}); |
|
|
|
|
|
/** |
|
|
* ±â°£º°, Àüü radio button¿¡ ´ëÇÑ À̺¥Æ® ó¸® ÇÔ¼ö |
|
|
* @param {type} obj |
|
|
* @returns {undefined} |
|
|
*/ |
|
|
function fn_rdChange(obj) { |
|
|
var val = obj.value; |
|
|
var display = "inline"; |
|
|
$span_date = $("#span_date"); |
|
|
|
|
|
if( val == "all" ) { |
|
|
display = "none"; |
|
|
} |
|
|
$span_date.css("display", display); |
|
|
} |
|
|
|
|
|
/** |
|
|
* ½ÃÀÛÀÏ°ú Á¾·áÀÏÀÇ Á¤ÇÕ¼º üũ ÇÔ¼ö |
|
|
* @param {type} stDate |
|
|
* @param {type} edDate |
|
|
* @returns {Boolean} |
|
|
*/ |
|
|
function isDateTrue(stDate, edDate) { |
|
|
if(stDate <= edDate) { |
|
|
return true; |
|
|
} |
|
|
return false; |
|
|
} |
|
|
|
|
|
/** |
|
|
* Á¶È¸¹öÆ° Ŭ¸¯ ½Ã È£ÃâµÇ´Â ÇÔ¼ö |
|
|
* @returns {Boolean} |
|
|
*/ |
|
|
function fn_SearchStatistics(p_type) { |
|
|
if( !isDateTrue(document.searchForm.stDate.value, document.searchForm.edDate.value) ) { |
|
|
alert("<%= MoumiConfig.getMessageBundle().getString("moumi.message.popup.startEndDateCheck") %>"); |
|
|
document.searchForm.edDate.focus(); |
|
|
document.searchForm.edDate.select(); |
|
|
return false; |
|
|
} |
|
|
|
|
|
if( p_type == "search" ) { |
|
|
document.searchForm.action = ""; |
|
|
}else if( p_type == "excel" ) { |
|
|
document.searchForm.action = "statistics_excel.jsp"; |
|
|
} |
|
|
|
|
|
document.searchForm.search_organ.value = document.searchForm.organ.value; |
|
|
document.searchForm.search_dept.value = document.searchForm.dept.value; |
|
|
return true; |
|
|
} |
|
|
|
|
|
/** |
|
|
* Excel ´Ù¿î·Îµå ÇÔ¼ö |
|
|
* @returns {undefined} */ |
|
|
function fn_excelLink() { |
|
|
if( fn_SearchStatistics("excel") ) document.searchForm.submit(); |
|
|
} |
|
|
//ºÎ¼, Çб³¿¡ ´ëÇÑ ±¸ºÐÀÚ º¯¼ö Á¤ÀÇ |
|
|
var lov_dept_same_organ = "<%= DeptService.TYPE.DEPT_OF_SAME_ORGAN.ordinal() %>"; |
|
|
var lov_school_same_organ = "<%= DeptService.TYPE.SCHOOL_OF_SAME_ORGAN.ordinal() %>"; |
|
|
|
|
|
/** |
|
|
* ±³À°Ã»À» º¯°æ ½Ã È£ÃâµÇ´Â ÇÔ¼ö |
|
|
* @returns {undefined} |
|
|
*/ |
|
|
function fn_onChangeOrgan() { |
|
|
var organId = $("#id_organ option:selected").val(); |
|
|
$("#id_dept option[value!='ALL']").remove(); |
|
|
var $id_chk_dept = $("#id_chk_dept"); |
|
|
var $id_chk_school = $("#id_chk_school"); |
|
|
if( organId == "ALL" ) { |
|
|
$id_chk_dept.attr("checked", false); |
|
|
$id_chk_dept.attr("disabled", true); |
|
|
$id_chk_school.attr("checked", false); |
|
|
$id_chk_school.attr("disabled", true); |
|
|
|
|
|
}else{ |
|
|
$id_chk_dept.attr("disabled", false); |
|
|
$id_chk_school.attr("disabled", false); |
|
|
if( $id_chk_dept.is(":checked") ) { |
|
|
fn_getDeptLOV(organId, lov_dept_same_organ); |
|
|
}else if( $id_chk_school.is(":checked") ) { |
|
|
fn_getDeptLOV(organId, lov_school_same_organ); |
|
|
} |
|
|
} |
|
|
} |
|
|
|
|
|
/** |
|
|
* Ajax±â´ÉÀ» »ç¿ëÇÏ¿© ¼¹ö¿¡ LOV°ªÀ» ¿äûÇÏ´Â ÇÔ¼ö |
|
|
* @param {type} p_deptId |
|
|
* @param {type} p_lov_type |
|
|
* @returns {undefined} |
|
|
*/ |
|
|
function fn_getDeptLOV(p_deptId, p_lov_type) { |
|
|
$.ajax({ |
|
|
url:"/servlet/kr.co.kihyun.service.servlet.AjaxProcessServlet", |
|
|
type:"POST", |
|
|
dataType:"json", |
|
|
async: true, |
|
|
data:{ |
|
|
proc_type:"dept_lov", |
|
|
lov_type:p_lov_type, |
|
|
deptId:p_deptId |
|
|
}, |
|
|
success:function(data) { |
|
|
fn_callBackForSuccess(data); |
|
|
}, |
|
|
error:function(e) { |
|
|
alert("error=" + e); |
|
|
}, |
|
|
beforeSend:function() { |
|
|
$.customIndicator.show(window.self); |
|
|
}, |
|
|
complete:function() { |
|
|
$.customIndicator.hide(window.self); |
|
|
} |
|
|
}); |
|
|
} |
|
|
|
|
|
/** |
|
|
* fn_getDeptLOVÇÔ¼öÀÇ ¼º°ø ½Ã È£ÃâµÇ´Â ÇÔ¼ö |
|
|
* @param {type} data |
|
|
* @returns {undefined} |
|
|
*/ |
|
|
function fn_callBackForSuccess(data) { |
|
|
|
|
|
// jquery ÃÖÀûÈ 2014.11.17 Update by YOUNGJUN,CHO |
|
|
var id_deptObj = $("#id_dept"); // selector object ¸¦ º¯¼ö·Î ÀúÀåÇÏ¿©, dom Ž»ö ¼Óµµ¸¦ °³¼±ÇÔ. |
|
|
|
|
|
if( data != null ) { |
|
|
|
|
|
var optionHtml = ""; |
|
|
for(var i = 0; i < data.length; i++ ) { |
|
|
//$("#id_dept").append("<option value='" + data[i].value + "'>" + data[i].code + "</option>"); |
|
|
// option À» µ¿ÀûÀ¸·Î Ãß°¡½Ã html À» º¯¼ö¿¡ ÀúÀå ÈÄ, ÇѲ¨¹ø¿¡ append ó¸®Çϵµ·Ï º¯°æ. |
|
|
optionHtml = optionHtml + "<option value='" + data[i].value + "'>" + data[i].code + "</option>"; |
|
|
} |
|
|
|
|
|
//$("#id_dept").append( optionHtml ); |
|
|
id_deptObj.append( optionHtml ); |
|
|
|
|
|
//$("#id_dept").val("<%//= sDept %>"); |
|
|
id_deptObj.val("<%= sDept %>"); |
|
|
} |
|
|
|
|
|
// select box ÀÇ width°¡ ¹Ù·Î ¹Ù²îÁö ¾Ê´Â Çö»óÀÌ ÀÖ¾î¼ select box ¿¡ focus ¸¦ ÁöÁ¤ÇÏ´Â ¹æ¹ýÀ¸·Î ÇØ°á. |
|
|
id_deptObj.focus(); |
|
|
} |
|
|
|
|
|
/** |
|
|
* ºÎ¼, Çб³ üũ¹Ú½º Ŭ¸¯ ½Ã È£ÃâµÇ´Â ÇÔ¼ö |
|
|
* @param {type} p_checkbox |
|
|
* @returns {undefined} */ |
|
|
function fn_onChangeCheck(p_checkbox) { |
|
|
if( p_checkbox.name == $("#id_chk_dept").attr("name") ) { |
|
|
$("#id_chk_school").attr("checked", false); |
|
|
}else if( p_checkbox.name == $("#id_chk_school").attr("name") ) { |
|
|
$("#id_chk_dept").attr("checked", false); |
|
|
} |
|
|
|
|
|
if( $("#id_chk_dept").is(":checked") ) { |
|
|
// fn_onChangeOrgan(); |
|
|
}else if( $("#id_chk_school").is(":checked") ) { |
|
|
// fn_onChangeOrgan(); |
|
|
}else{ |
|
|
$("#id_dept option[value!='ALL']").remove(); |
|
|
} |
|
|
} |
|
|
</script> |
|
|
</head> |
|
|
<body style='' BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0> |
|
|
<table width="100%" border="0" cellpadding="0" cellspacing="0"> |
|
|
<%--<jsp:include page="/totsys/common/inc/totper/top/top.jsp" flush="true"/>--%> |
|
|
<tr> |
|
|
<td nowrap width="10"></td> |
|
|
<td valign="top"> |
|
|
<!---------------------------------------------------------------------------------------------------------------------------> |
|
|
<table width="100%" border="0" cellspacing="0" cellpadding="0"> |
|
|
<jsp:include page="/totsys/common/inc/title/title.jsp" flush="true" /> |
|
|
<tr class="toolbar"> |
|
|
<td> |
|
|
<!-------------------------------------°Ë»öÁ¶°Ç½ÃÀÛ-------------------------------------------------> |
|
|
<form name="searchForm" method="post" style="margin: 0px" onsubmit="return fn_SearchStatistics('search');"> |
|
|
<input type="hidden" name="search_organ" value=""> |
|
|
<input type="hidden" name="search_dept" value=""> |
|
|
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="margin: 0px;border-color: #3366ff;"> |
|
|
<tr class="toolbar" valign="middle" style="height:30px;"> |
|
|
<td align="left" width="100%" nowrap style="padding-top: 4px;padding-bottom: 0px;margin: 0px; vertical-align: middle;"> |
|
|
|
|
|
<label for="" style="vertical-align: middle;"> |
|
|
<strong><%=Moumi.getMessageBundle().getString("moumi.message.tot_doc.date")%></strong> |
|
|
</label> |
|
|
|
|
|
|
|
|
<!--// °Ë»ö ½ÃÀÛÀÏ --> |
|
|
<input name="stDate" type="text" size="10" value="<%=stDate.equals("") ? dForomat.format(now_today) : stDate%>" readonly onclick="showSetWin('searchForm.stDate');" style="cursor: pointer; vertical-align: middle;" class="inputtxt"> |
|
|
<a href="#" onclick="showSetWin('searchForm.stDate');"> |
|
|
<img src="/totsys/common/images/date.gif" align="middle"> |
|
|
</a><!-- °Ë»ö ½ÃÀÛÀÏ //--> |
|
|
~ |
|
|
<!--// °Ë»ö Á¾·áÀÏ --> |
|
|
<input name="edDate" type="text" size="10" value="<%=edDate.equals("") ? dForomat.format(now_today) : edDate%>" readonly onclick="showSetWin('searchForm.edDate');" style="cursor: pointer; vertical-align: middle;" class="inputtxt"> |
|
|
<a href="#" onclick="showSetWin('searchForm.edDate');"> |
|
|
<img src="/totsys/common/images/date.gif" align="middle"> |
|
|
</a><!-- °Ë»ö Á¾·áÀÏ //--> |
|
|
|
|
|
|
|
|
<!--// ±â°£º° --> |
|
|
<label for="" style="vertical-align: middle;"> |
|
|
<input type="radio" name="searchType" value="period" checked onclick="fn_rdChange(this);" style="vertical-align: middle;"> |
|
|
<%=Moumi.getMessageBundle().getString("moumi.message.statistics.period")%> |
|
|
</label><!-- ±â°£º° //--> |
|
|
|
|
|
|
|
|
<span id="span_date" style="margin: 0 0 0 5px; padding: 1px 6px 1px 3px; border:1px solid #BABABA; vertical-align: middle;"> |
|
|
<!--// ±â°£º°(ÀÏ°£) --> |
|
|
<label for=""> |
|
|
<input type="radio" name="dateType" value="day" checked> <%=Moumi.getMessageBundle().getString("moumi.message.statistics.period.day")%> |
|
|
</label><!-- ±â°£º°(ÀÏ°£) //--> |
|
|
<!--// ±â°£º°(¿ù°£) --> |
|
|
<label for=""> |
|
|
<input type="radio" name="dateType" value="month"> <%=Moumi.getMessageBundle().getString("moumi.message.statistics.period.month")%> |
|
|
</label><!-- ±â°£º°(¿ù°£) //--> |
|
|
<!--// ±â°£º°(³â°£) --> |
|
|
<label for=""> |
|
|
<input type="radio" name="dateType" value="year"> <%=Moumi.getMessageBundle().getString("moumi.message.statistics.period.year")%> |
|
|
</label><!-- ±â°£º°(³â°£) //--> |
|
|
</span> |
|
|
|
|
|
<label for="" style="vertical-align: middle;"> |
|
|
<input type="radio" name="searchType" value="all" onclick="fn_rdChange(this);" style="vertical-align: middle;"> <%=Moumi.getMessageBundle().getString("moumi.message.tot_doc.all")%> |
|
|
</label> |
|
|
|
|
|
</td> |
|
|
</tr> |
|
|
<tr class="toolbar" valign="middle" > |
|
|
<td align="left" width="100%" nowrap style="padding-bottom: 0px;margin: 0px; vertical-align: middle;"> |
|
|
|
|
|
<label for="" style="vertical-align: middle;"> |
|
|
<strong><%=Moumi.getMessageBundle().getString("moumi.message.doc.Coporation")%></strong> |
|
|
</label> |
|
|
|
|
|
|
|
|
<!--// ±â°ü select box --> |
|
|
<select id="id_organ" name="organ" class="inputtxt" onchange="fn_onChangeOrgan();" style="vertical-align: middle;"> |
|
|
<option value="ALL"><%=Moumi.getMessageBundle().getString("moumi.message.tot_doc.all")%></option> |
|
|
<% |
|
|
if( organDeptList != null && organDeptList.size() > 0 ) { |
|
|
for(Object obj : organDeptList) { |
|
|
CodeVO codeVO = (CodeVO)obj; |
|
|
%> |
|
|
<option value="<%= codeVO.getValue()%>"><%= codeVO.getCode() %></option> |
|
|
<% |
|
|
} |
|
|
} |
|
|
%> |
|
|
</select><!-- ±â°ü select box //--> |
|
|
|
|
|
|
|
|
<!--// ºÎ¼ checkbox --> |
|
|
<label for="" style="vertical-align: middle;"> |
|
|
<%=Moumi.getMessageBundle().getString("moumi.message.tot_doc.devision")%><input type="checkbox" id="id_chk_dept" name="chkbox_dept" value="D" onclick="fn_onChangeCheck(this);"> |
|
|
</label><!-- ºÎ¼ checkbox //--> |
|
|
|
|
|
|
|
|
<!--// ºÎ¼ or Çб³ select box --> |
|
|
<select id="id_dept" name="dept" class="inputtxt" onchange="fn_onChangeDept(this);"> |
|
|
<option value="ALL"><%=Moumi.getMessageBundle().getString("moumi.message.tot_doc.all")%></option> |
|
|
<% |
|
|
if( deptList != null && deptList.size() > 0 ) { |
|
|
for(Object obj : deptList) { |
|
|
CodeVO codeVO = (CodeVO)obj; |
|
|
%> |
|
|
<option value="<%= codeVO.getValue()%>"><%= codeVO.getCode() %></option> |
|
|
<% |
|
|
} |
|
|
} |
|
|
%> |
|
|
</select><!-- ºÎ¼ or Çб³ select box //--> |
|
|
|
|
|
<input type="image" src="/totsys/common/images/bt_search_inquiry2.gif" border="0" align="middle" style="vertical-align: middle;"> |
|
|
<!--// ¿¢¼¿ÀúÀå button --> |
|
|
<a href="javascript:void(0);" onclick="javascript:fn_excelLink();" style="vertical-align: middle;"> |
|
|
<img src="/totsys/common/images/bt_excel.gif" alt="¿¢¼¿ÀúÀå" /> |
|
|
</a><!-- ¿¢¼¿ÀúÀå button //--> |
|
|
</td> |
|
|
</tr> |
|
|
</table> |
|
|
</form> |
|
|
<!-------------------------------------°Ë»öÁ¶°Ç³¡-------------------------------------------------> |
|
|
</td> |
|
|
</tr> |
|
|
<% if( !searchType.equals("") ) { %> |
|
|
<tr> |
|
|
<td valign="top"> |
|
|
<!-------------------------------------¸ñ·Ï½ÃÀÛ-------------------------------------------------> |
|
|
<% if( searchType.equals("") || searchType.equals("period") ) { %> |
|
|
<!------------------------------±â°£º° Á¶È¸ ½ÃÀÛ-----------------------------------> |
|
|
<table width="100%" border="0" cellspacing="0" cellpadding="0"> |
|
|
<tr width="100%"> |
|
|
<td> |
|
|
<table border="1px" class="kecttep_list_table" bordercolor="#e3e3e3" width="100%" cellpadding="0" cellspacing="0"> |
|
|
<tr valign="middle" style="padding-top: 3px"> |
|
|
<td style="text-align: center;" class="kecttep_tdmenu"><%=MoumiConfig.getMessageBundle().getString("moumi.message.tot_doc.day")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.tot_doc.person")%></td> |
|
|
<td width="17%" align="center" class="kecttep_tdmenu"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_doc")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.temp")%></td> |
|
|
<td width="17%" align="center" class="kecttep_tdmenu"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_doc")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.complete")%></td> |
|
|
<td width="17%" align="center" class="kecttep_tdmenu"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.accept")%></td> |
|
|
<td width="17%" align="center" class="kecttep_tdmenu"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_report")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.temp")%></td> |
|
|
<td width="17%" align="center" class="kecttep_last_tdmenu"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_report")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.complete")%></td> |
|
|
</tr> |
|
|
<% |
|
|
int prssTot = 0; //Áý°èÁøÇàÇÕ°è |
|
|
int endTot = 0; //Áý°è¿Ï·áÇÕ°è |
|
|
int acceptTot = 0; //Á¢¼öÇÕ°è |
|
|
int tempTot = 0; //Á¦ÃâÁøÇàÇÕ°è |
|
|
int compTot = 0; //Á¦Ãâ¿Ï·áÇÕ°è |
|
|
for(int i = 0; i < list.size(); i++ ) { |
|
|
Object[] row = (Object[])list.get(i); |
|
|
prssTot += Integer.parseInt(row[1].toString()); |
|
|
endTot += Integer.parseInt(row[2].toString()); |
|
|
acceptTot += Integer.parseInt(row[3].toString()); |
|
|
tempTot += Integer.parseInt(row[4].toString()); |
|
|
compTot += Integer.parseInt(row[5].toString()); |
|
|
%> |
|
|
<tr style="padding-top: 3px" valign="middle" onmouseover="this.style.backgroundColor='F9F9F9'" onmouseout="this.style.backgroundColor='white'"> |
|
|
<td nowrap class="kecttep_graytd" style="text-align: center;"><%= row[0] %></td> |
|
|
<td nowrap class="kecttep_graytd statistics_number"><%= numberFormat.format(row[1]).trim() %></td> |
|
|
<td nowrap class="kecttep_graytd statistics_number"><%= numberFormat.format(row[2]).trim() %></td> |
|
|
<td nowrap class="kecttep_graytd statistics_number"><%= numberFormat.format(row[3]).trim() %></td> |
|
|
<td nowrap class="kecttep_graytd statistics_number"><%= numberFormat.format(row[4]).trim() %></td> |
|
|
<td nowrap class="kecttep_last_graytd statistics_number"><%= numberFormat.format(row[5]).trim() %></td> |
|
|
</tr> |
|
|
<% |
|
|
} |
|
|
%> |
|
|
<tr style="padding-top: 3px" valign="middle" onmouseover="this.style.backgroundColor='F9F9F9'" onmouseout="this.style.backgroundColor='white'"> |
|
|
<td nowrap class="kecttep_tdmenu" style="text-align: center;"><%=MoumiConfig.getMessageBundle().getString("moumi.message.total")%></td> |
|
|
<td nowrap class="kecttep_tdmenu statistics_number"><%= numberFormat.format(prssTot).trim() %></td> |
|
|
<td nowrap class="kecttep_tdmenu statistics_number"><%= numberFormat.format(endTot).trim() %></td> |
|
|
<td nowrap class="kecttep_tdmenu statistics_number"><%= numberFormat.format(acceptTot).trim() %></td> |
|
|
<td nowrap class="kecttep_tdmenu statistics_number"><%= numberFormat.format(tempTot).trim() %></td> |
|
|
<td nowrap class="kecttep_last_tdmenu statistics_number"><%= numberFormat.format(compTot).trim() %></td> |
|
|
</tr> |
|
|
</table> |
|
|
</td> |
|
|
</tr> |
|
|
</table> |
|
|
<!------------------------------±â°£º° Á¶È¸ ³¡-----------------------------------> |
|
|
<% |
|
|
}else if( searchType.equals("all") ) { |
|
|
Object[] row = (Object[])list.get(0); |
|
|
%> |
|
|
<!------------------------------Àüü Á¶È¸ ½ÃÀÛ-----------------------------------> |
|
|
|
|
|
<!--// Àüü Åë°è - Áý°è --> |
|
|
<br /> |
|
|
<img src="/totsys/common/images/ico_3.gif" border="0" align="absmiddle"> <strong><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_doc")%></strong> |
|
|
|
|
|
<table class="kecttep_list_table" width="300" border="1" cellspacing="0" cellpadding="0"> |
|
|
<tr> |
|
|
<td width="100" class="kecttep_tdmenu" align="center"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_doc")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.temp")%></td> |
|
|
<td class="kecttep_last_graytd" align="right" nowrap style="padding-right: 10px;"><strong><%= numberFormat.format(row[0]).trim() %></strong> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.job")%></td> |
|
|
</tr> |
|
|
<tr onmouseover="this.style.backgroundColor='F9F9F9'" onmouseout="this.style.backgroundColor='white'"> |
|
|
<td width="100" class="kecttep_tdmenu" align="center"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_doc")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.complete")%></td> |
|
|
<td class="kecttep_last_graytd" align="right" nowrap style="padding-right: 10px;"><strong><%= numberFormat.format(row[1]).trim() %></strong> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.job")%></td> |
|
|
</tr> |
|
|
</table><!-- Àüü Åë°è - Áý°è //--> |
|
|
|
|
|
<!--// Àüü Åë°è - Á¦Ãâ --> |
|
|
<br /> |
|
|
<img src="/totsys/common/images/ico_3.gif" border="0" align="absmiddle"> <strong><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_report")%></strong> |
|
|
|
|
|
<table class="kecttep_list_table" width="300" border="0" cellspacing="0" cellpadding="0"> |
|
|
<tr> |
|
|
<td width="100" class="kecttep_tdmenu" align="center"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.accept")%> </td> |
|
|
<td class="kecttep_last_graytd" align="right" nowrap style="padding-right: 10px;"><strong><%= numberFormat.format(row[2]).trim() %></strong> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.job")%></td> |
|
|
</tr> |
|
|
<tr> |
|
|
<td width="100" class="kecttep_tdmenu" align="center"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_report")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.temp")%></td> |
|
|
<td class="kecttep_last_graytd" align="right" nowrap style="padding-right: 10px;"><strong><%= numberFormat.format(row[3]).trim() %></strong> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.job")%></td> |
|
|
</tr> |
|
|
<tr> |
|
|
<td width="100" class="kecttep_tdmenu" align="center"><%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.tot_report")%> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.complete")%></td> |
|
|
<td class="kecttep_last_graytd" align="right" nowrap style="padding-right: 10px;"><strong><%= numberFormat.format(row[4]).trim() %></strong> <%=MoumiConfig.getMessageBundle().getString("moumi.message.statistics.job")%></td> |
|
|
</tr> |
|
|
</table><!-- Àüü Åë°è - Á¦Ãâ //--> |
|
|
|
|
|
|
|
|
|
|
|
<!------------------------------Àüü Á¶È¸ ³¡-----------------------------------> |
|
|
<% } %> |
|
|
<!-------------------------------------¸ñ·Ï³¡-------------------------------------------------> |
|
|
</td> |
|
|
</tr> |
|
|
<% } %> |
|
|
<!------------------------------- top menu start -------------------------------> |
|
|
<%@ include file="/totsys/common/inc/buttom/buttom.jsp"%> |
|
|
<!------------------------------- top menu end -------------------------------> |
|
|
</table> |
|
|
<!---------------------------------------------------------------------------------------------------------------------------> |
|
|
</td> |
|
|
<td nowrap width="10"></td> |
|
|
</tr> |
|
|
</table> |
|
|
<div id="SetWin" style="position: absolute; z-index: 10; visibility: hidden; width: 100px; background: silver; border: 1px #333333 solid; line-height: 1.4em; padding: 3px 3px; v"></div> |
|
|
</body> |
|
|
</html> |
|
|
<% |
|
|
tx.commit(); |
|
|
}catch(Exception ex){ |
|
|
//ex.printStackTrace(); |
|
|
out.println(kr.co.kihyun.text.html.ServletUtil.getJavaScript("location='/servlet/kr.co.kihyun.beans.user.HttpSSOLogin?mode=logout';")); |
|
|
}finally{ |
|
|
if(tx.isActive()) |
|
|
tx.rollback(); |
|
|
pm.close(); |
|
|
} |
|
|
%>
|
|
|
|
