Index: ssts-web/src/main/webapp/disinfectsystem/reportforms/foreignTousseSupplierStatisticsReport.js =================================================================== diff -u --- ssts-web/src/main/webapp/disinfectsystem/reportforms/foreignTousseSupplierStatisticsReport.js (revision 0) +++ ssts-web/src/main/webapp/disinfectsystem/reportforms/foreignTousseSupplierStatisticsReport.js (revision 33272) @@ -0,0 +1,526 @@ +var entityName = "外来器械包供应商统计报表"; +var myMask; +var searchCustomTimePeriodStore; +var is2Column = false; +var widthArr = []; + +//获取表头列 +function getTableHeaderColumnArray(reportType) { + var columnNameArray = []; + if (reportType) { + columnNameArray = [{ + name: '日期', + width: 100 + }, { + name: '供应商', + width: 300 + }, { + name: '材料汇总', + width: 210 + }, { + name: '大小', + width: 140 + }, { + name: '灭菌包数量', + width: 80 + }]; + } else { + columnNameArray = [{ + name: '序号', + width: 100 + }, { + name: '供应商', + width: 300 + }, { + name: '材料汇总', + width: 210 + }, { + name: '大小', + width: 140 + }, { + name: '灭菌包数量', + width: 80 + }]; + } + return columnNameArray; +} + +//获取表头的td +function getHeadTd(name, width, rowspan, colspan) { + var html = '
" + title + "
"; + tableHtml += getTableHtml(result, reportType) + document.getElementById('thisIframe').contentWindow.document.getElementById('table').innerHTML = tableHtml; + myMask.hide(); + }, + failure: function (response, options) { + showResult(response.responseText); + } + }); + } + + var dt = new Date(); + var startDayofMonth = dt.getFullYear() + "/" + (dt.getMonth() + 1) + "/01"; + var endDayofMonth = dt.getFullYear() + "/" + (dt.getMonth() + 1) + "/" + dt.getDate() + " 23:59"; + + //供应商 + var supplierStore = new Ext.data.Store({ + proxy: new Ext.data.HttpProxy({ + url: WWWROOT + '/disinfectSystem/baseData/supplierAction!getSupplierInfoByType.do?supplierType=' + encodeURI(supplierType), + method: 'POST' + }), + reader: new Ext.data.JsonReader({ + root: 'data' + }, [ + { name: 'id', mapping: 'id' }, + { name: 'companyName', mapping: 'companyName' } + ] + ) + }); + + //时间段 + searchCustomTimePeriodStore = new Ext.data.Store({ + proxy: new Ext.data.HttpProxy({ + url: WWWROOT + '/report/customTimePeriodReportAction!queryAllCustomTimePeriod.do', + method: 'POST' + }), + reader: new Ext.data.JsonReader({ + fields: [{ + name: 'id' + }, { + name: 'timePeriodName' + }] + }) + }); + + var form = new Ext.form.FormPanel({ + title: entityName, + region: 'north', + labelAlign: 'right', + buttonAlign: 'center', + collapsible: true, + collapseMode: 'mini', + split: true, + border: 0, + frame: true, + bodyStyle: 'padding:0px auto;margin:0px',// padding:1px;padding-top:5px; + height: 130, + items: [{ + layout: 'column', + height: 150, + labelWidth: 120, + items: [{ + columnWidth: .3, + layout: 'form', + items: [{ + xtype: 'combo', + fieldLabel: '查询时间类型', + id: 'timeType', + name: 'timeType', + valueField: 'value', + displayField: 'value', + store: new Ext.data.SimpleStore({ + fields: ['value'], + data: [['接收时间'], ['发货时间'], ['申请时间']] + }), + forceSelection: true, + value: '接收时间', + editable: false, + mode: 'local', + triggerAction: 'all', + anchor: '95%' + }] + }, { + columnWidth: .3, + layout: 'form', + items: [{ + xtype: 'datefield', + fieldLabel: '开始时间', + id: 'startDate', + name: 'startDate', + editable: false, + format: 'Y-m-d H:i', + altFormats: 'Y-m-d|Y-n-j|y-n-j|y-m-j|y-m-d|y-n-d|Y-n-d|Y-m-j|Ymd|Ynj|ynj|ymj|ymd|ynd|Ynd|Ymj|Y/m/d|Y/n/j|y/n/j|y/m/j|y/m/d|y/n/d|Y/n/d|Y/m/j', + allowBlank: false, + anchor: '95%', + value: new Date(startDayofMonth), + listeners: { + specialkey: function (field, e) { + if (e.getKey() == Ext.EventObject.ENTER) { + var isOK = field.validate(); + if (isOK) { + var value = field.getValue(); + field.setValue(value); + var endDate = Ext.getCmp('endDate'); + endDate.selectText(); + endDate.focus(); + } + + } + } + } + }] + }, { + columnWidth: .3, + layout: 'form', + items: [{ + xtype: 'datefield', + fieldLabel: '结束时间', + id: 'endDate', + name: 'endDate', + editable: false, + format: 'Y-m-d H:i', + altFormats: 'Y-m-d|Y-n-j|y-n-j|y-m-j|y-m-d|y-n-d|Y-n-d|Y-m-j|Ymd|Ynj|ynj|ymj|ymd|ynd|Ynd|Ymj|Y/m/d|Y/n/j|y/n/j|y/m/j|y/m/d|y/n/d|Y/n/d|Y/m/j', + allowBlank: false, + anchor: '95%', + value: new Date(endDayofMonth), + listeners: { + specialkey: function (field, e) { + if (e.getKey() == Ext.EventObject.ENTER) { + var isOK = field.validate(); + if (isOK) { + var value = field.getValue(); + field.setValue(value); + reloadReport(); + } + } + } + } + }] + }, { + columnWidth: .3, + layout: 'form', + items: [{ + xtype: 'combo', + id: 'supplierName', + name: 'supplierName', + queryParam: 'spell', + fieldLabel: '供应商', + minChars: 0, + valueField: 'companyName', + displayField: 'companyName', + store: supplierStore, + forceSelection: true, + lazyInit: true, + triggerAction: 'all', + hideTrigger: false, + typeAhead: false, + allowBlank: true, + anchor: '95%' + }] + }, { + columnWidth: .3, + layout: 'form', + items: [{ + xtype: 'combo', + id: 'customTimePeriodId', + name: 'customTimePeriodId', + queryParam: 'spell', + fieldLabel: '时间段', + minChars: 0, + valueField: 'id', + displayField: 'timePeriodName', + anchor: '95%', + store: searchCustomTimePeriodStore, + lazyInit: false, + listWidth: 380, + triggerAction: 'all', + forceSelection: true, + hideTrigger: false, + typeAhead: false, + allowBlank: true + }] + }, { + columnWidth: .3, + layout: 'form', + items: [{ + id: 'reportType', + name: 'reportType', + fieldLabel: '按日期汇总', + xtype: 'checkbox', + inputValue: '按日期汇总', + cls: 'sterilizerCheckbox', + labelSeparator: '' + }] + }] + }], + buttons: [{ + xtype: 'button', + text: '查询', + minWidth: 70, + iconCls: 'icon_search', + handler: function () { + reloadReport(); + } + }, { + xtype: 'button', + text: '重置', + minWidth: 70, + iconCls: 'icon_set', + handler: function () { + Ext.getCmp('timeType').setValue('接收时间'); + Ext.getCmp('startDate').setValue(new Date(startDayofMonth)); + Ext.getCmp('endDate').setValue(new Date(endDayofMonth)); + Ext.getCmp('supplierName').setValue(''); + Ext.getCmp('customTimePeriodId').setValue(''); + Ext.getCmp('reportType').setValue(false); + } + }, { + xtype: 'button', + text: '自定义时间段', + iconCls: 'icon_set', + minWidth: 100, + handler: function () { + showCustomTimePeriodWin(); + } + }] + }); + + + var reportForm = new Ext.Panel({ + frame: false,//渲染面板 + autoScroll: true,//自动显示滚动条 + collapsible: true,//允许展开和收缩 + bodyPadding: 5, + tbar: [{ + text: '导出', + handler: function () { + var html = document.getElementById('thisIframe').contentWindow.document.getElementById('table').innerHTML; + if (html !== '') { + var startDate = $Id('startDate').value; + var endDate = $Id('endDate').value; + var title = '外来器械包供应商统计报表(' + startDate + '至' + endDate + ')'; + var data = { + fileName: title, + fileType: ".xls", + html: html + } + exportMask = new Ext.LoadMask(Ext.getBody(), { + msg: '正在导出文件,请稍候!', + removeMask: true + }); + exportMask.show(); + setTimeout(function () { + exportReportExcel(data, document.getElementById('thisIframe').contentWindow.document.getElementById('table'), true, [100, 300]); + }, 1000); + } + } + }], + html: '' + }); + + new Ext.Viewport({ + layout: 'border', + items: [form, { + region: 'center', + margins: '0 0 0 0', + layout: 'fit', + items: reportForm + }] + }); +}); \ No newline at end of file Index: ssts-web/src/main/webapp/homepage/menuconfigure.js =================================================================== diff -u -r33176 -r33272 --- ssts-web/src/main/webapp/homepage/menuconfigure.js (.../menuconfigure.js) (revision 33176) +++ ssts-web/src/main/webapp/homepage/menuconfigure.js (.../menuconfigure.js) (revision 33272) @@ -716,6 +716,7 @@ {hidden :SSTS_GoodsDistributeReportChart,text:"物品发放分布饼图",href:WWWROOT+'/disinfectsystem/reportforms/goodsDistributeReportChartView.jsp',hrefTarget:linkTarget,leaf:true}, {hidden :SSTS_TousseDeliverReport,text:"器械包发货统计报表",href:WWWROOT+'/disinfectsystem/reportforms/tousseDeliverStatisticsView.jsp',hrefTarget:linkTarget,leaf:true}, {hidden :SSTS_ForeignTousseReport,text:"外来器械申请单统计报表",href:WWWROOT+'/disinfectsystem/reportforms/foreignTousseApplicationReport.jsp',hrefTarget:linkTarget,leaf:true}, + {hidden :!sstsConfig.enableForeignTousseSupplierStatisticsReport,text:"外来器械包供应商统计报表",href:WWWROOT+'/disinfectsystem/reportforms/foreignTousseSupplierStatisticsReport.jsp',hrefTarget:linkTarget,leaf:true}, {hidden :SSTS_ForeignTousseSupplierChargeReport,text:"外来器械包供应商收费报表",href:WWWROOT+'/disinfectsystem/reportforms/foreignTousseSupplierChargeReport.jsp',hrefTarget:linkTarget,leaf:true}, {hidden :!hasForeignTousseSizeSetting,text:"外来器械包大小统计报表",href:WWWROOT+'/disinfectsystem/reportforms/foreignTousseSizeReport.jsp',hrefTarget:linkTarget,leaf:true}, {hidden :SSTS_ApparatusInfusionisType,text:"各类型输液器报表",href:WWWROOT+'/disinfectsystem/reportforms/apparatusInfusionisTypeView.jsp',hrefTarget:linkTarget,leaf:true}, Index: ssts-web/src/main/webapp/disinfectsystem/reportforms/foreignTousseSupplierStatisticsReport.jsp =================================================================== diff -u --- ssts-web/src/main/webapp/disinfectsystem/reportforms/foreignTousseSupplierStatisticsReport.jsp (revision 0) +++ ssts-web/src/main/webapp/disinfectsystem/reportforms/foreignTousseSupplierStatisticsReport.jsp (revision 33272) @@ -0,0 +1,35 @@ +<%@page import="com.forgon.disinfectsystem.entity.basedatamanager.supplier.Supplier"%> +<%@ page contentType="text/html; charset=UTF-8"%> +<%@ include file="/common/taglibs.jsp"%> + + + +<%@ include file="/common/includeExtJsAndCss.jsp"%> + + + + + + + + + + + + + + + + + + + + + +