GridPanel.js 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328
  1. Ext.define('erp.view.common.batchPrint.GridPanel',{
  2. extend: 'Ext.grid.Panel',
  3. alias: 'widget.erpBatchPrintGridPanel',
  4. requires: ['erp.view.core.plugin.CopyPasteMenu'],
  5. id: 'batchPrintGridPanel',
  6. emptyText : $I18N.common.grid.emptyText,
  7. columnLines : true,
  8. autoScroll : true,
  9. multiselected: [],
  10. store: [],
  11. columns: [],
  12. GridUtil: Ext.create('erp.util.GridUtil'),
  13. BaseUtil: Ext.create('erp.util.BaseUtil'),
  14. plugins: [Ext.create('erp.view.core.plugin.CopyPasteMenu'),Ext.create('erp.view.core.grid.HeaderFilter')],
  15. selModel: Ext.create('Ext.selection.CheckboxModel',{
  16. checkOnly : true,
  17. ignoreRightMouseSelection : false,
  18. listeners:{
  19. selectionchange:function(selModel, selected, options){
  20. selModel.view.ownerCt.summary();
  21. selModel.view.ownerCt.selectall = false;
  22. }
  23. },
  24. getEditor: function(){
  25. return null;
  26. },
  27. onHeaderClick: function(headerCt, header, e) {
  28. if (header.isCheckerHd) {
  29. e.stopEvent();
  30. var isChecked = header.el.hasCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');
  31. if (isChecked && this.getSelection().length > 0) {//先全选,再筛选后再全选时,无法响应的bug
  32. this.deselectAll(true);
  33. } else {
  34. this.selectAll(true);
  35. this.view.ownerCt.selectall = true;
  36. }
  37. }
  38. }
  39. }),
  40. listeners: {
  41. scrollershow: function(scroller) {
  42. if (scroller && scroller.scrollEl) {
  43. scroller.clearManagedListeners();
  44. scroller.mon(scroller.scrollEl, 'scroll', scroller.onElScroll, scroller);
  45. }
  46. }
  47. },
  48. initComponent : function(){
  49. condition = this.BaseUtil.getUrlParam('urlcondition');
  50. condition = (condition == null) ? "" : condition;
  51. condition = condition.replace(/@/,"'%").replace(/@/,"%'");
  52. this.defaultCondition = condition;
  53. var gridParam = {caller: caller, condition: condition};
  54. this.GridUtil.getGridColumnsAndStore(this, 'common/singleGridPanel.action', gridParam, "");
  55. this.callParent(arguments);
  56. this.initRecords();
  57. },
  58. headerCt: Ext.create("Ext.grid.header.Container",{
  59. forceFit: false,
  60. sortable: true,
  61. enableColumnMove:true,
  62. enableColumnResize:true,
  63. enableColumnHide: true
  64. }),
  65. invalidateScrollerOnRefresh: false,
  66. viewConfig: {
  67. trackOver: false
  68. },
  69. buffered: true,
  70. sync: true,
  71. getMultiSelected: function(){
  72. var grid = this;
  73. grid.multiselected = [];
  74. var items = grid.selModel.getSelection();
  75. if(grid.selectall && items.length == grid.store.pageSize) {
  76. items = grid.store.prefetchData.items;
  77. }
  78. Ext.each(items, function(item, index){
  79. if(this.data[grid.keyField] != null && this.data[grid.keyField] != ''
  80. && this.data[grid.keyField] != '0' && this.data[grid.keyField] != 0){
  81. grid.multiselected.push(item);
  82. }
  83. });
  84. return grid.multiselected;
  85. },
  86. unique: function(items) {
  87. var d = new Object();
  88. Ext.Array.each(items, function(item){
  89. d[item.id] = item;
  90. });
  91. return Ext.Object.getValues(d);
  92. },
  93. getGridColumnsAndStore: function(grid, url, param, no){
  94. var me = this;
  95. me.setLoading(true);//loading...
  96. Ext.Ajax.request({//拿到grid的columns
  97. url : basePath + url,
  98. params: param,
  99. method : 'post',
  100. async: false,
  101. callback : function(options,success,response){
  102. me.setLoading(false);
  103. var res = new Ext.decode(response.responseText);
  104. if(res.exceptionInfo){
  105. showError(res.exceptionInfo);return;
  106. }
  107. if(me.columns && me.columns.length > 2){
  108. var data = res.data != null ? Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')) : [];
  109. me.store.loadData(data);
  110. //解决固定列左右不对齐的情况
  111. var lockedView = me.view.lockedView;
  112. if(lockedView){
  113. var tableEl = lockedView.el.child('.x-grid-table');
  114. if(tableEl){
  115. tableEl.dom.style.marginBottom = '7px';
  116. }
  117. }
  118. me.initRecords();
  119. } else {
  120. if(res.columns){
  121. Ext.each(res.columns, function(column, y){
  122. me.setRenderer(column);
  123. var logic = column.logic;
  124. if(logic != null){
  125. me.setLogicType(column, logic, y);
  126. }
  127. });
  128. //store
  129. me.store = me.setDefaultStore(res.data, res.fields);
  130. //view
  131. if(me.selModel.views == null){
  132. me.selModel.views = [];
  133. }
  134. if(res.dbfinds.length > 0){
  135. me.dbfinds = res.dbfinds;
  136. }
  137. //toolbar
  138. me.setToolbar(res.columns);
  139. //reconfigure store&columns
  140. me.columns = res.columns;
  141. }
  142. }
  143. }
  144. });
  145. },
  146. setRenderer: function(column){
  147. var grid = this;
  148. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  149. var renderName = column.renderer;
  150. if(contains(column.renderer, ':', true)){
  151. var args = new Array();
  152. Ext.each(column.renderer.split(':'), function(a, index){
  153. if(index == 0){
  154. renderName = a;
  155. } else {
  156. args.push(a);
  157. }
  158. });
  159. if(!grid.RenderUtil.args[renderName]){
  160. grid.RenderUtil.args[renderName] = new Object();
  161. }
  162. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  163. }
  164. column.renderer = grid.RenderUtil[renderName];
  165. column.haveRendered = true;
  166. }
  167. },
  168. setLogicType: function(column, logic, y){
  169. var grid = this;
  170. if(logic == 'detno'){
  171. grid.detno = column.dataIndex;
  172. } else if(logic == 'keyField'){
  173. grid.keyField = column.dataIndex;
  174. } else if(logic == 'mainField'){
  175. grid.mainField = column.dataIndex;
  176. } else if(logic == 'necessaryField'){
  177. grid.necessaryField = column.dataIndex;
  178. if(!grid.necessaryFields){
  179. grid.necessaryFields = new Array();
  180. }
  181. grid.necessaryFields.push(column.dataIndex);
  182. if(!column.haveRendered){
  183. column.renderer = function(val, meta, record, x, y, store, view){
  184. var c = this.columns[y];
  185. if(val != null && val.toString().trim() != ''){
  186. if(c.xtype == 'datecolumn'){
  187. val = Ext.Date.format(val, 'Y-m-d');
  188. }
  189. return val;
  190. } else {
  191. if(c.xtype == 'datecolumn'){
  192. val = '';
  193. }
  194. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  195. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  196. }
  197. };
  198. }
  199. } else if(logic == 'groupField'){
  200. grid.groupField = column.dataIndex;
  201. }
  202. },
  203. setToolbar: function(columns){
  204. var grid = this;
  205. var items = [];
  206. Ext.each(columns, function(column){
  207. if(column.summaryType == 'sum'){
  208. items.push('-',{
  209. id: column.dataIndex + '_sum',
  210. itemId: column.dataIndex,
  211. xtype: 'tbtext',
  212. text: column.header + '(sum):0'
  213. });
  214. } else if(column.summaryType == 'average') {
  215. items.push('-',{
  216. id: column.dataIndex + '_average',
  217. itemId: column.dataIndex,
  218. xtype: 'tbtext',
  219. text: column.header + '(average):0'
  220. });
  221. } else if(column.summaryType == 'count') {
  222. items.push('-',{
  223. id: column.dataIndex + '_count',
  224. itemId: column.dataIndex,
  225. xtype: 'tbtext',
  226. text: column.header + '(count):0'
  227. });
  228. }
  229. });
  230. grid.bbar = {
  231. xtype: 'toolbar',
  232. dock: 'bottom',
  233. items: items
  234. };
  235. },
  236. setDefaultStore: function(d, f){
  237. var me = this;
  238. var data = [];
  239. if(!d || d.length == 2){
  240. me.GridUtil.add10EmptyData(me.detno, data);
  241. me.GridUtil.add10EmptyData(me.detno, data);
  242. } else {
  243. data = Ext.decode(d.replace(/,}/g, '}').replace(/,]/g, ']'));
  244. }
  245. var store = Ext.create('Ext.data.Store', {
  246. fields: f,
  247. data: data,
  248. groupField: me.groupField,
  249. getSum: function(field) {
  250. var records = me.selModel.getSelection(),
  251. total = 0,
  252. i = 0,
  253. len = records.length;
  254. for (; i < len; ++i) {
  255. total += records[i].get(field);
  256. }
  257. return total;
  258. },
  259. getCount: function() {
  260. var records = me.selModel.getSelection(),
  261. count = 0;
  262. Ext.each(records, function(item){
  263. count++;
  264. });
  265. return count;
  266. },
  267. getAverage: function(field) {
  268. var records = me.selModel.getSelection(),
  269. count = 0,
  270. sum = 0;
  271. Ext.each(records, function(item){
  272. if(item.data[me.necessaryField] != null && item.data[me.necessaryField] != ''){
  273. count++;sum += item.data[field];
  274. }
  275. });
  276. return Ext.Number.format(sum/count, '0.00');
  277. }
  278. });
  279. return store;
  280. },
  281. initRecords: function(){
  282. var records = this.store.data.items;
  283. var count = 0;
  284. Ext.each(records, function(record){
  285. if(!record.index){
  286. record.index = count++;
  287. }
  288. });
  289. },
  290. viewConfig: {
  291. getRowClass: function(record) {
  292. return record.get('ifrep') == -1 ? 'rep' : '';
  293. }
  294. },
  295. getSum: function(items, column) {
  296. var sum = 0;
  297. Ext.Array.each(items, function(item){
  298. sum += Number(item.get(column.dataIndex));
  299. });
  300. return sum;
  301. },
  302. /**
  303. * 修改为selection改变时,summary也动态改变
  304. */
  305. summary: function(){
  306. var me = this,
  307. items = me.selModel.getSelection(),
  308. value;
  309. Ext.each(me.columns, function(c){
  310. if(c.summaryType == 'sum'){
  311. value = me.getSum(items, c);
  312. if(c.xtype == 'numbercolumn') {
  313. value = Ext.util.Format.number(value, (c.format || '0,000.000'));
  314. }
  315. me.down('tbtext[id=' + c.dataIndex + '_sum]').setText(c.text + '(sum):' + value);
  316. } else if(c.summaryType == 'count'){
  317. value = items.length;
  318. me.down('tbtext[id=' + c.dataIndex + '_count]').setText(c.text + '(count):' + value);
  319. } else if(c.summaryType == 'average'){
  320. value = me.getSum(items, c) / items.length;
  321. if(c.xtype == 'numbercolumn') {
  322. value = Ext.util.Format.number(value, (c.format || '0,000.000'));
  323. }
  324. me.down('tbtext[id=' + c.dataIndex + '_average]').setText(c.text + '(average):' + value);
  325. }
  326. });
  327. }
  328. });