TempStoreGridPanel.js 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396
  1. Ext.define('erp.view.common.tempStore.TempStoreGridPanel',{
  2. extend: 'Ext.grid.Panel',
  3. alias: 'widget.erpTempStoreGridPanel',
  4. requires: ['erp.view.core.grid.HeaderFilter', 'erp.view.core.toolbar.Toolbar', 'erp.view.core.plugin.CopyPasteMenu'],
  5. id: 'tempStoreGridPanel',
  6. emptyText : $I18N.common.grid.emptyText,
  7. columnLines : true,
  8. autoScroll : true,
  9. multiselected: [],
  10. store: [],
  11. columns: [],
  12. bodyStyle: 'background-color:#f1f1f1;',
  13. dockedItems: [{xtype: 'erpToolbar', dock: 'bottom', enableAdd: false, enableDelete: false, enableCopy: false, enablePaste: false, enableUp: false, enableDown: false}],
  14. plugins: [Ext.create('Ext.grid.plugin.CellEditing', {
  15. clicksToEdit: 1
  16. }), Ext.create('erp.view.core.grid.HeaderFilter'), Ext.create('erp.view.core.plugin.CopyPasteMenu')],
  17. headerCt: Ext.create("Ext.grid.header.Container",{
  18. forceFit: false,
  19. sortable: true,
  20. enableColumnMove:true,
  21. enableColumnResize:true,
  22. enableColumnHide: true
  23. }),
  24. features : [Ext.create('Ext.grid.feature.Grouping',{
  25. hideGroupedHeader: true,
  26. groupHeaderTpl: '{name} (Count:{rows.length})'
  27. }),{
  28. ftype : 'summary',
  29. showSummaryRow : false,//不显示默认合计行
  30. generateSummaryData: function(){
  31. var me = this,
  32. data = {},
  33. store = me.view.store,
  34. columns = me.view.headerCt.getColumnsForTpl(),
  35. i = 0,
  36. length = columns.length,
  37. comp, value;
  38. //将feature的data打印在toolbar上面
  39. for (i = 0, length = columns.length; i < length; ++i) {
  40. comp = Ext.getCmp(columns[i].id);
  41. data[comp.id] = me.getSummary(store, comp.summaryType, comp.dataIndex, false);
  42. var tb = Ext.getCmp(columns[i].dataIndex + '_' + comp.summaryType);
  43. if(tb){
  44. value = data[comp.id];
  45. if(comp.xtype == 'numbercolumn') {
  46. value = Ext.util.Format.number(value, (comp.format || '0,000.000'));
  47. }
  48. tb.setText(tb.text.split(':')[0] + ':' + value);
  49. }
  50. }
  51. return data;
  52. }
  53. }],
  54. selModel: Ext.create('Ext.selection.CheckboxModel',{
  55. checkOnly : true,
  56. ignoreRightMouseSelection : false,
  57. listeners:{
  58. selectionchange:function(selModel, selected, options){
  59. selModel.view.ownerCt.summary();
  60. selModel.view.ownerCt.selectall = false;
  61. }
  62. },
  63. getEditor: function(){
  64. return null;
  65. },
  66. onHeaderClick: function(headerCt, header, e) {
  67. if (header.isCheckerHd) {
  68. e.stopEvent();
  69. var isChecked = header.el.hasCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');
  70. if (isChecked && this.getSelection().length > 0) {//先全选,再筛选后再全选时,无法响应的bug
  71. this.deselectAll(true);
  72. } else {
  73. this.selectAll(true);
  74. this.view.ownerCt.selectall = true;
  75. }
  76. }
  77. }
  78. }),
  79. initComponent : function(){
  80. this.GridUtil = Ext.create('erp.util.GridUtil');
  81. this.BaseUtil = Ext.create('erp.util.BaseUtil');
  82. this.RenderUtil = Ext.create('erp.util.RenderUtil');
  83. var gridParam = {caller: caller, condition: ""};
  84. this.getGridColumnsAndStore(this, 'common/singleGridPanel.action?', gridParam, "",true);
  85. this.addEvents({
  86. storeloaded: true
  87. });
  88. this.callParent(arguments);
  89. this.initRecords();
  90. },
  91. sync: true,
  92. getMultiSelected: function(){
  93. var grid = this;
  94. grid.multiselected = [];
  95. var items = grid.selModel.getSelection();
  96. if(grid.selectall && items.length == grid.store.pageSize && grid.store.prefetchData) {
  97. items = grid.store.prefetchData.items;
  98. }
  99. Ext.each(items, function(item, index){
  100. if(this.data[grid.keyField] != null && this.data[grid.keyField] != ''
  101. && this.data[grid.keyField] != '0' && this.data[grid.keyField] != 0){
  102. grid.multiselected.push(item);
  103. }
  104. });
  105. return grid.multiselected;
  106. },
  107. unique: function(items) {
  108. var d = new Object();
  109. Ext.Array.each(items, function(item){
  110. d[item.id] = item;
  111. });
  112. return Ext.Object.getValues(d);
  113. },
  114. getGridColumnsAndStore: function(grid, url, param, no,sync){
  115. var me = this;
  116. me.setLoading(true);//loading...
  117. Ext.Ajax.request({//拿到grid的columns
  118. url : basePath + url,
  119. params: param,
  120. method : 'post',
  121. async: sync?false:true,
  122. callback : function(options,success,response){
  123. me.setLoading(false);
  124. var res = new Ext.decode(response.responseText);
  125. if(res.exceptionInfo){
  126. showError(res.exceptionInfo);return;
  127. }
  128. if(res.columns){
  129. var limits = res.limits, limitArr = new Array();
  130. if(limits != null && limits.length > 0) {//权限外字段
  131. limitArr = Ext.Array.pluck(limits, 'lf_field');
  132. }
  133. Ext.each(res.columns, function(column, y){
  134. if(column.xtype=='textareatrigger'){
  135. column.xtype='';
  136. column.renderer='texttrigger';
  137. }
  138. // column有取别名
  139. if(column.dataIndex.indexOf(' ') > -1) {
  140. column.dataIndex = column.dataIndex.split(' ')[1];
  141. }
  142. //power
  143. if(limitArr.length > 0 && Ext.Array.contains(limitArr, column.dataIndex)) {
  144. column.hidden = true;
  145. }
  146. //renderer
  147. me.setRenderer(column);
  148. //logictype
  149. me.setLogicType(column, column.logic, {headerColor: res.necessaryFieldColor},y);
  150. });
  151. var checkdata=[];
  152. var d1=parent.Ext.getCmp('batchDealGridPanel').tempStore;//暂存区数据
  153. Ext.each(d1,function(d){
  154. var keys=Ext.Object.getKeys(d);
  155. Ext.each(keys, function(k){
  156. checkdata.push(d[k].data);
  157. });
  158. });
  159. //data
  160. var data = checkdata;
  161. //store
  162. var store = me.GridUtil.setStore(grid, res.fields, data, grid.groupField, grid.necessaryField);
  163. //view
  164. if(grid.selModel && grid.selModel.views == null){
  165. grid.selModel.views = [];
  166. }
  167. //dbfind
  168. if(res.dbfinds && res.dbfinds.length > 0){
  169. grid.dbfinds = res.dbfinds;
  170. }
  171. //reconfigure
  172. if(grid.sync) {//同步加载的Grid
  173. grid.reconfigure(store, res.columns);
  174. grid.on('afterrender', function(){
  175. me.GridUtil.setToolbar(grid, grid.columns, grid.necessaryField, limitArr);
  176. grid.summary();
  177. });
  178. }
  179. grid.readOnly =true;
  180. }
  181. }
  182. });
  183. },
  184. setRenderer: function(column){
  185. var grid = this;
  186. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  187. var renderName = column.renderer;
  188. if(contains(column.renderer, ':', true)){
  189. var args = new Array();
  190. Ext.each(column.renderer.split(':'), function(a, index){
  191. if(index == 0){
  192. renderName = a;
  193. } else {
  194. args.push(a);
  195. }
  196. });
  197. if(!grid.RenderUtil.args[renderName]){
  198. grid.RenderUtil.args[renderName] = new Object();
  199. }
  200. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  201. }
  202. column.renderer = grid.RenderUtil[renderName];
  203. column.renderName=renderName;
  204. column.haveRendered = true;
  205. }
  206. },
  207. setLogicType: function(column, logic, headerCss,y){
  208. var grid = this;
  209. if(logic == 'detno'){
  210. grid.detno = column.dataIndex;
  211. } else if(logic == 'keyField'){
  212. grid.keyField = column.dataIndex;
  213. } else if(logic == 'mainField'){
  214. grid.mainField = column.dataIndex;
  215. } else if(logic == 'necessaryField'){
  216. grid.necessaryField = column.dataIndex;
  217. if(!grid.necessaryFields){
  218. grid.necessaryFields = new Array();
  219. }
  220. grid.necessaryFields.push(column.dataIndex);
  221. if(!column.haveRendered){
  222. column.renderer = function(val, meta, record, x, y, store, view){
  223. var c = this.columns[y];
  224. if(val != null && val.toString().trim() != ''){
  225. if(c.xtype == 'datecolumn'){
  226. val = Ext.Date.format(val, 'Y-m-d');
  227. }
  228. return val;
  229. } else {
  230. if(c.xtype == 'datecolumn'){
  231. val = '';
  232. }
  233. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  234. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  235. }
  236. };
  237. }
  238. if(headerCss.headerColor)
  239. column.style = 'color:#' + headerCss.headerColor;
  240. } else if(logic == 'groupField'){
  241. grid.groupField = column.dataIndex;
  242. }
  243. },
  244. setToolbar: function(columns){
  245. var grid = this;
  246. var items = [];
  247. var bool = true;
  248. Ext.each(grid.dockedItems.items, function(item){
  249. if(item.dock == 'bottom' && item.items){//bbar已存在
  250. bool = false;
  251. }
  252. });
  253. if(bool){
  254. Ext.each(columns, function(column){
  255. if(column.summaryType == 'sum'){
  256. items.push('-',{
  257. id: column.dataIndex + '_sum',
  258. itemId: column.dataIndex,
  259. xtype: 'tbtext',
  260. text: column.text + '(sum):0'
  261. });
  262. } else if(column.summaryType == 'average') {
  263. items.push('-',{
  264. id: column.dataIndex + '_average',
  265. itemId: column.dataIndex,
  266. xtype: 'tbtext',
  267. text: column.text + '(average):0'
  268. });
  269. } else if(column.summaryType == 'count') {
  270. items.push('-',{
  271. id: column.dataIndex + '_count',
  272. itemId: column.dataIndex,
  273. xtype: 'tbtext',
  274. text: column.text + '(count):0'
  275. });
  276. }
  277. });
  278. grid.addDocked({
  279. xtype: 'toolbar',
  280. dock: 'bottom',
  281. items: items
  282. });
  283. }else{
  284. var bars = Ext.ComponentQuery.query('erpToolbar');
  285. if(bars.length > 0){
  286. Ext.each(columns, function(column){
  287. if(column.summaryType == 'sum'){
  288. bars[0].add('-');
  289. bars[0].add({
  290. id: column.dataIndex + '_sum',
  291. itemId: column.dataIndex,
  292. xtype: 'tbtext',
  293. text: column.text + '(sum):0'
  294. });
  295. } else if(column.summaryType == 'average') {
  296. bars[0].add('-');
  297. bars[0].add({
  298. id: column.dataIndex + '_average',
  299. itemId: column.dataIndex,
  300. xtype: 'tbtext',
  301. text: column.text + '(average):0'
  302. });
  303. } else if(column.summaryType == 'count') {
  304. bars[0].add('-');
  305. bars[0].add({
  306. id: column.dataIndex + '_count',
  307. itemId: column.dataIndex,
  308. xtype: 'tbtext',
  309. text: column.text + '(count):0'
  310. });
  311. }
  312. });
  313. }
  314. }
  315. },
  316. /**
  317. * 修改为selection改变时,summary也动态改变
  318. */
  319. summary: function(){
  320. var me = this,
  321. store = this.store, items = store.data.items, selected = me.selModel.getSelection(),
  322. value, m = me.down('erpToolbar'), n = me.down('toolbar[to=select]');
  323. Ext.each(me.columns, function(c){
  324. if(c.summaryType && !n)
  325. n = me.addDocked({
  326. xtype: 'toolbar',
  327. dock: 'bottom',
  328. to: 'select',
  329. items: [{
  330. xtype: 'tbtext',
  331. text: '已勾选',
  332. style: {
  333. marginLeft: '6px'
  334. }
  335. }]
  336. })[0];
  337. if(c.summaryType == 'sum'){
  338. me.updateSummary(c, me.getSum(items, c.dataIndex), 'sum', m);
  339. me.updateSummary(c, me.getSum(selected, c.dataIndex), 'sum', n);
  340. } else if(c.summaryType == 'count'){
  341. me.updateSummary(c, items.length, 'count', m);
  342. me.updateSummary(c, selected.length, 'count', n);
  343. }
  344. });
  345. if(n) {
  346. var count = n.down('tbtext[id=selected-count]');
  347. if(!count) {
  348. n.add('->');
  349. count = n.add({
  350. xtype: 'tbtext',
  351. id: 'selected-count'
  352. });
  353. }
  354. count.setText('共: ' + items.length + ' 条, 已选: ' + selected.length + ' 条');
  355. }
  356. },
  357. updateSummary: function(column, value, type, scope) {
  358. var id = column.dataIndex + '_' + type + (scope.to == 'select' ? '_select' : ''),
  359. b = scope.down('tbtext[id=' + id + ']');
  360. if (!b) {
  361. scope.add('-');
  362. b = scope.add({xtype: 'tbtext', id: id});
  363. }
  364. if(column.xtype == 'numbercolumn') {
  365. value = Ext.util.Format.number(value, (column.format || '0,000.000'));
  366. }
  367. b.setText(column.text + '(' + type + '):' + value);
  368. },
  369. initRecords: function(){
  370. var records = this.store.data.items;
  371. var count = 0;
  372. Ext.each(records, function(record){
  373. if(!record.index){
  374. record.index = count++;
  375. }
  376. });
  377. },
  378. getSum: function(records, field) {
  379. var total = 0,
  380. i = 0,
  381. len = records.length;
  382. (len == 0) && (records = this.store.data.items);
  383. for (; i < len; ++i) {
  384. total += records[i].get(field);
  385. }
  386. return total;
  387. },
  388. listeners: {
  389. scrollershow: function(scroller) {
  390. if (scroller && scroller.scrollEl) {
  391. scroller.clearManagedListeners();
  392. scroller.mon(scroller.scrollEl, 'scroll', scroller.onElScroll, scroller);
  393. }
  394. }
  395. }
  396. });