statisSend.jsp 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228
  1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
  2. <%@include file="/context/mytags.jsp"%>
  3. <head>
  4. <t:base type="jquery,easyui,tools,DatePicker"></t:base>
  5. <link rel="stylesheet" type="text/css" media="screen" href="plug-in/jqgrid/css/css/cupertino/jquery-ui-1.8.16.custom.css" />
  6. <link rel="stylesheet" type="text/css" media="screen" href="plug-in/ace/css/ui.jqgrid.css" />
  7. <script type="text/javascript" src="${ctx}/plug-in/jquery/jquery-1.11.3.min.js"></script>
  8. <script type="text/javascript" src="plug-in/jquery/jquery.jqprint.js"></script>
  9. <script type="text/javascript" src="plug-in/jqgrid/js/jquery.jqGrid.src.js"></script>
  10. <script type="text/javascript" src="plug-in/jqgrid/js/i18n/grid.locale-cn.js"></script>
  11. <script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
  12. <script type="text/javascript" src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
  13. <script type="text/javascript" src="${ctx}/plug-in/tableExport/libs/FileSaver/FileSaver.min.js"></script>
  14. <script type="text/javascript" src="${ctx}/plug-in/tableExport/libs/js-xlsx/xlsx.core.min.js"></script>
  15. <script type="text/javascript" src="${ctx}/plug-in/tableExport/tableExport.min.js"></script>
  16. <style>
  17. .ui-jqgrid {
  18. font-size: 14px;
  19. }
  20. .ui-jqgrid-view {
  21. font-size: 14px;
  22. }
  23. .ui-jqgrid .ui-jqgrid-htable th {
  24. height: 28px;
  25. font-size: 14px; /* 14 */
  26. }
  27. .ui-jqgrid .ui-jqgrid-btable {
  28. height: 28px;
  29. font-size: 12px;
  30. }
  31. .ui-jqgrid .ui-jqgrid-ftable {
  32. font-size: 13px;
  33. }
  34. .ui-jqgrid .ui-jqgrid-pager {
  35. height: 28px;
  36. font-size: 14px; /* 14 */
  37. }
  38. .ui-jqgrid .ui-pg-input {
  39. font-size: 1em;
  40. height: 20px;
  41. }
  42. .ui-jqgrid .i-pg-selbox {
  43. font-size: 0.9em;
  44. height: 20px;
  45. }
  46. .ui-jqgrid tr.ui-row-ltr td {
  47. text-align: center;
  48. }
  49. .ui-jqgrid tr.footrow-ltr td {
  50. text-align: center;
  51. }
  52. .ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default
  53. {
  54. background: #5187c9 ;
  55. color: #fffbf8;
  56. }
  57. .ui-widget-content
  58. {
  59. background:#fff;
  60. }
  61. /*.ui-priority-secondary, .ui-widget-content .ui-priority-secondary, .ui-widget-header .ui-priority-secondary { opacity: 1; filter:Alpha(Opacity=100); font-weight: normal; background-color: #F5F5F5;}*/
  62. .ui-jqgrid tr.jqgrow td { white-space: normal !important; height:auto; } /**内容自动换行 */
  63. th.ui-th-column div{
  64. white-space: normal !important;
  65. height: auto !important;
  66. }
  67. </style>
  68. </head>
  69. <div>
  70. <div id="searchDiv">
  71. <%--查询框begin --%>
  72. <table cellpadding="0" cellspacing="1" class="formtable" style="position:fixed;top:5px;"> <!-- bottom -->
  73. <tr >
  74. <td class="value">
  75. <label><input type="radio" name="groupBy" value="noticeType" checked="checked"/>按类型</label>&nbsp;&nbsp;
  76. <label><input type="radio" name="groupBy" value="dep"/>按部门</label>&nbsp;&nbsp;&nbsp;
  77. <label><input type="radio" name="groupBy" value="user"/>按用户</label>
  78. </td>
  79. <td width="20">&nbsp;</td>
  80. <td class="value">
  81. <div id="c_noticeType" class="sc">
  82. 类型:
  83. <t:dictSelect field="noticeType" type="select" datatype="*" typeGroupCode="message_notice_type" hasLabel="false" title="通知类型" ></t:dictSelect>
  84. </div>
  85. <div id="c_dep" style="display:none" class="sc">
  86. 部门:
  87. <input type="text" id="depName" name="depName"/>
  88. </div>
  89. <div id="c_user" style="display:none" class="sc">
  90. 用户名:
  91. <input type="text" id="realname" name="realname"/>
  92. </div>
  93. <%-- <t:dictSelect id="period" field="period" type="list" extendJson="{class:'form-control',style:'width:136px'}"
  94. typeGroupCode="busperiod" hasLabel="false" title="采购期间" ></t:dictSelect> --%>
  95. </td>
  96. <td>&nbsp;&nbsp;&nbsp;&nbsp;</td>
  97. <td align="right">
  98. <label class="Validform_label"> 发送时间: </label>
  99. </td>
  100. <td class="value">
  101. <input id="startTime" name="startTime" type="text" style="width: 150px" class="Wdate" readonly="readonly"
  102. onClick='WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,dateFmt: "yyyy-MM"})' datatype="*" ignore="ignore" />
  103. -
  104. <input id="endTime" name="endTime" type="text" style="width: 150px" class="Wdate" readonly="readonly"
  105. onClick='WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,dateFmt: "yyyy-MM"})' datatype="*" ignore="ignore" />
  106. <label class="Validform_label" style="display: none;"> 发送时间: </label>
  107. </td>
  108. <td width="20px"></td>
  109. <td height="50px" align="right">
  110. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-search" onclick="btn_query()">查询</a>
  111. <%--<a href="#" class="easyui-linkbutton l-btn" iconcls="icon-putout" onclick="btn_output()">导出excel</a>--%>
  112. <%--<a href="#" class="easyui-linkbutton l-btn" iconcls="icon-print" onclick="btn_print()">打印</a>--%>
  113. </td>
  114. </tr>
  115. </table>
  116. <%--查询框end --%>
  117. </div>
  118. <%--div2 end--%>
  119. <br/><br/><br/>
  120. <div id="divgrid">
  121. <div id="div1">
  122. <table id="jqGrid"></table>
  123. </div>
  124. </div>
  125. <%--<div class="easyui-layout" fit="true">
  126. <div region="center" style="padding:0px;border:0px">
  127. </div>
  128. </div>--%>
  129. <script type="text/javascript">
  130. $('input[name="groupBy"]').on('click',function(){
  131. var t=$(this);
  132. var groupBy = t.val();
  133. $('.sc').hide();
  134. $('#c_'+groupBy).show();
  135. showGridTable(groupBy);
  136. });
  137. showGridTable();
  138. function showGridTable(group) {
  139. var requrl = 'mMessageDataController.do?statisSendDatagrid';
  140. var searchDiv = $('#searchDiv');
  141. var postData={};
  142. searchDiv.find('input,select,textarea').each(function(){
  143. var t=$(this);
  144. if(t.attr('type')=='radio' &&!t.is(':checked')) {
  145. return;
  146. }
  147. var name =t.attr('name');
  148. var value=t.val();
  149. if(name&&value){
  150. postData[name]=value;
  151. }
  152. });
  153. var colNames=['类型','月份','次数'];
  154. if(group=='dep'){
  155. colNames[0] = '部门';
  156. }
  157. if(group=='user'){
  158. colNames[0] = '用户';
  159. }
  160. $("#div1").empty();
  161. $("#div1").html("<table class='jqgrid' id='jqGrid'></table>");
  162. $("#jqGrid").jqGrid({
  163. url: requrl,
  164. datatype: "json",
  165. mtype: "POST",
  166. postData:postData,
  167. caption: '<div style="text-align:center;font-size: 14px;"><span>消息发送统计表</span></div>',
  168. colNames:colNames,
  169. colModel: [
  170. {label: '类型', name: 'title', width: 130, sortable: false, align: 'left'},
  171. {label: '月份', name: 'sendMonth', width: 80, sortable: false, align: 'center'},
  172. {label: '次数', name: 'count', width: 80, sortable: false, align: 'center'}
  173. ],
  174. viewrecords: true,
  175. height: 500,
  176. rowNum: -1,
  177. rownumbers: true,
  178. rownumWidth: 25,
  179. autowidth: false,
  180. multiselect: false,
  181. frozen: true,
  182. footerrow: false, //开启统计
  183. userDataOnFooter: false, //在页脚显示统计
  184. altRows: true,
  185. pager: "#jqGridPager",
  186. jsonReader: {
  187. root: "page.list",
  188. page: "page.currPage",
  189. total: "page.totalPage",
  190. records: "page.totalCount"
  191. },
  192. prmNames: {
  193. page: "page",
  194. rows: "limit",
  195. order: "order"
  196. }
  197. ,loadComplete:function(){
  198. var records = $("#jqGrid").getGridParam('records');
  199. if(records==0){
  200. $("#jqGrid").remove();
  201. }
  202. }
  203. ,gridComplete: function () {
  204. }
  205. });
  206. }
  207. function btn_query(){
  208. showGridTable();
  209. }
  210. </script>