GridPanel.js 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487
  1. Ext.define('erp.view.scm.purchase.VerifyApplyDetail.GridPanel',{
  2. extend: 'Ext.grid.Panel',
  3. alias: 'widget.erpVerifyApplyDetailGridPanel',
  4. requires: ['erp.view.core.grid.HeaderFilter', 'erp.view.core.toolbar.Toolbar', 'erp.view.core.plugin.CopyPasteMenu'],
  5. id: 'verifyApplyDetailGridPanel',
  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: true, enableCopy: true, enablePaste: true, 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. //startCollapsed: true,
  26. hideGroupedHeader: true,
  27. groupHeaderTpl: '{name} (Count:{rows.length})'
  28. }),{
  29. ftype : 'summary',
  30. showSummaryRow : true,//不显示默认合计行
  31. generateSummaryData: function(){
  32. var me = this,
  33. data = {},
  34. store = me.view.store,
  35. columns = me.view.headerCt.getColumnsForTpl(),
  36. i = 0,
  37. length = columns.length,
  38. //fieldData,
  39. //key,
  40. comp;
  41. //将feature的data打印在toolbar上面
  42. for (i = 0, length = columns.length; i < length; ++i) {
  43. comp = Ext.getCmp(columns[i].id);
  44. data[comp.id] = me.getSummary(store, comp.summaryType, comp.dataIndex, false);
  45. var tb = Ext.getCmp(columns[i].dataIndex + '_' + comp.summaryType);
  46. if(tb){
  47. tb.setText(tb.text.split(':')[0] + ':' + data[comp.id]);
  48. }
  49. }
  50. return data;
  51. }
  52. }],
  53. selModel: Ext.create('Ext.selection.CheckboxModel',{
  54. ignoreRightMouseSelection : false,
  55. listeners:{
  56. selectionchange:function(selModel, selected, options){
  57. selModel.view.ownerCt.selectall = false;
  58. }
  59. },
  60. getEditor: function(){
  61. return null;
  62. },
  63. onRowMouseDown: function(view, record, item, index, e) {//改写的onRowMouseDown方法
  64. var me = view.ownerCt;
  65. var bool = true;
  66. var items = me.selModel.getSelection();
  67. Ext.each(items, function(item, index){
  68. if(item && item.internalId == record.internalId){
  69. bool = false;
  70. me.selModel.deselect(record);
  71. Ext.Array.remove(items, item);
  72. }
  73. });
  74. if(bool){
  75. view.el.focus();
  76. var checkbox = item.childNodes[0].childNodes[0].childNodes[0];
  77. if(checkbox.getAttribute && checkbox.getAttribute('class') == 'x-grid-row-checker'){
  78. items.push(record);
  79. me.selModel.select(items);
  80. } else {
  81. me.selModel.deselect(record);
  82. }
  83. }
  84. me.multiselected = me.selModel.getSelection();
  85. me.summary();
  86. },
  87. onHeaderClick: function(headerCt, header, e) {
  88. if (header.isCheckerHd) {
  89. e.stopEvent();
  90. var isChecked = header.el.hasCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');
  91. if (isChecked) {
  92. this.deselectAll(true);
  93. var grid = Ext.getCmp('verifyApplyDetailGridPanel');
  94. this.deselect(grid.multiselected);
  95. grid.multiselected = new Array();
  96. var els = Ext.select('div[@class=x-grid-row-checker-checked]').elements;
  97. Ext.each(els, function(el, index){
  98. el.setAttribute('class','x-grid-row-checker');
  99. });
  100. header.el.removeCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');//添加这个
  101. } else {
  102. var grid = Ext.getCmp('verifyApplyDetailGridPanel');
  103. this.deselect(grid.multiselected);
  104. grid.multiselected = new Array();
  105. var els = Ext.select('div[@class=x-grid-row-checker-checked]').elements;
  106. Ext.each(els, function(el, index){
  107. el.setAttribute('class','x-grid-row-checker');
  108. });
  109. this.selectAll(true);
  110. this.view.ownerCt.selectall = true;
  111. header.el.addCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');//添加这个
  112. }
  113. }
  114. Ext.getCmp('verifyApplyDetailGridPanel')
  115. }
  116. }),
  117. initComponent : function(){
  118. this.GridUtil = Ext.create('erp.util.GridUtil');
  119. this.BaseUtil = Ext.create('erp.util.BaseUtil');
  120. this.RenderUtil = Ext.create('erp.util.RenderUtil');
  121. condition = this.BaseUtil.getUrlParam('gridCondition');
  122. condition = (condition == null) ? "" : condition;
  123. condition = condition.replace(/@/,"'%").replace(/@/,"%'");
  124. this.defaultCondition = condition;
  125. var gridParam = {caller: caller, condition: condition};
  126. this.GridUtil.getGridColumnsAndStore(this, 'common/singleGridPanel.action?', gridParam, "");
  127. this.addEvents({
  128. storeloaded: true
  129. });
  130. this.callParent(arguments);
  131. this.initRecords();
  132. },
  133. sync: true,
  134. getMultiSelected: function(){
  135. var grid = this;
  136. grid.multiselected = [];
  137. var items = grid.selModel.getSelection();
  138. if(grid.selectall && items.length == grid.store.pageSize) {
  139. items = grid.store.prefetchData.items;
  140. }
  141. Ext.each(items, function(item, index){
  142. if(this.data[grid.keyField] != null && this.data[grid.keyField] != ''
  143. && this.data[grid.keyField] != '0' && this.data[grid.keyField] != 0){
  144. grid.multiselected.push(item);
  145. }
  146. });
  147. return grid.multiselected;
  148. },
  149. unique: function(items) {
  150. var d = new Object();
  151. Ext.Array.each(items, function(item){
  152. d[item.id] = item;
  153. });
  154. return Ext.Object.getValues(d);
  155. },
  156. getGridColumnsAndStore: function(grid, url, param, no,sync){
  157. var me = this;
  158. me.setLoading(true);//loading...
  159. Ext.Ajax.request({//拿到grid的columns
  160. url : basePath + url,
  161. params: param,
  162. method : 'post',
  163. async: sync?false:true,
  164. callback : function(options,success,response){
  165. me.setLoading(false);
  166. var res = new Ext.decode(response.responseText);
  167. if(res.exceptionInfo){
  168. showError(res.exceptionInfo);return;
  169. }
  170. if(me.columns && me.columns.length > 2){
  171. var data = res.data != null ? Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')) : [];
  172. me.store.loadData(data);
  173. me.setMore(data.length);
  174. //解决固定列左右不对齐的情况
  175. var lockedView = me.view.lockedView;
  176. if(lockedView){
  177. var tableEl = lockedView.el.child('.x-grid-table');
  178. if(tableEl){
  179. tableEl.dom.style.marginBottom = '7px';
  180. }
  181. }
  182. me.view.refresh();
  183. me.initRecords();
  184. grid.fireEvent('storeloaded', grid);
  185. grid.summary();
  186. } else {
  187. if(res.columns){
  188. Ext.each(res.columns, function(column, y){
  189. me.setRenderer(column);
  190. var logic = column.logic;
  191. if(logic != null){
  192. me.setLogicType(column, logic, y);
  193. }
  194. });
  195. //store
  196. me.store = me.setDefaultStore(res.data, res.fields);
  197. //view
  198. if(me.selModel.views == null){
  199. me.selModel.views = [];
  200. }
  201. if(res.dbfinds.length > 0){
  202. me.dbfinds = res.dbfinds;
  203. }
  204. //toolbar
  205. me.setToolbar(res.columns);
  206. //reconfigure store&columns
  207. me.columns = res.columns;
  208. me.view.doLayout();
  209. }
  210. }
  211. }
  212. });
  213. },
  214. setRenderer: function(column){
  215. var grid = this;
  216. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  217. var renderName = column.renderer;
  218. if(contains(column.renderer, ':', true)){
  219. var args = new Array();
  220. Ext.each(column.renderer.split(':'), function(a, index){
  221. if(index == 0){
  222. renderName = a;
  223. } else {
  224. args.push(a);
  225. }
  226. });
  227. if(!grid.RenderUtil.args[renderName]){
  228. grid.RenderUtil.args[renderName] = new Object();
  229. }
  230. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  231. }
  232. column.renderer = grid.RenderUtil[renderName];
  233. column.haveRendered = true;
  234. }
  235. },
  236. setLogicType: function(column, logic, y){
  237. var grid = this;
  238. if(logic == 'detno'){
  239. grid.detno = column.dataIndex;
  240. } else if(logic == 'keyField'){
  241. grid.keyField = column.dataIndex;
  242. } else if(logic == 'mainField'){
  243. grid.mainField = column.dataIndex;
  244. } else if(logic == 'necessaryField'){
  245. grid.necessaryField = column.dataIndex;
  246. if(!grid.necessaryFields){
  247. grid.necessaryFields = new Array();
  248. }
  249. grid.necessaryFields.push(column.dataIndex);
  250. if(!column.haveRendered){
  251. column.renderer = function(val, meta, record, x, y, store, view){
  252. var c = this.columns[y];
  253. if(val != null && val.toString().trim() != ''){
  254. if(c.xtype == 'datecolumn'){
  255. val = Ext.Date.format(val, 'Y-m-d');
  256. }
  257. return val;
  258. } else {
  259. if(c.xtype == 'datecolumn'){
  260. val = '';
  261. }
  262. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  263. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  264. }
  265. };
  266. }
  267. } else if(logic == 'groupField'){
  268. grid.groupField = column.dataIndex;
  269. }
  270. },
  271. setToolbar: function(columns){
  272. var grid = this;
  273. var items = [];
  274. Ext.each(columns, function(column){
  275. if(column.summaryType == 'sum'){
  276. items.push('-',{
  277. id: column.dataIndex + '_sum',
  278. itemId: column.dataIndex,
  279. xtype: 'tbtext',
  280. text: column.text + '(sum):0'
  281. });
  282. } else if(column.summaryType == 'average') {
  283. items.push('-',{
  284. id: column.dataIndex + '_average',
  285. itemId: column.dataIndex,
  286. xtype: 'tbtext',
  287. text: column.text + '(average):0'
  288. });
  289. } else if(column.summaryType == 'count') {
  290. items.push('-',{
  291. id: column.dataIndex + '_count',
  292. itemId: column.dataIndex,
  293. xtype: 'tbtext',
  294. text: column.text + '(count):0'
  295. });
  296. }
  297. });
  298. grid.bbar = {
  299. xtype: 'toolbar',
  300. dock: 'bottom',
  301. items: items
  302. };
  303. },
  304. setDefaultStore: function(d, f){
  305. var me = this;
  306. var data = [];
  307. if(!d || d.length == 2){
  308. me.GridUtil.add10EmptyData(me.detno, data);
  309. me.GridUtil.add10EmptyData(me.detno, data);
  310. } else {
  311. data = Ext.decode(d.replace(/,}/g, '}').replace(/,]/g, ']'));
  312. }
  313. var store = Ext.create('Ext.data.Store', {
  314. fields: f,
  315. data: data,
  316. groupField: me.groupField,
  317. getSum: function(field) {
  318. var records = me.selModel.getSelection(),
  319. total = 0,
  320. i = 0,
  321. len = records.length;
  322. for (; i < len; ++i) {
  323. total += records[i].get(field);
  324. }
  325. return total;
  326. },
  327. getCount: function() {
  328. var records = me.selModel.getSelection(),
  329. count = 0;
  330. Ext.each(records, function(item){
  331. count++;
  332. });
  333. return count;
  334. },
  335. getAverage: function(field) {
  336. var records = me.selModel.getSelection(),
  337. count = 0,
  338. sum = 0;
  339. Ext.each(records, function(item){
  340. if(item.data[me.necessaryField] != null && item.data[me.necessaryField] != ''){
  341. count++;sum += item.data[field];
  342. }
  343. });
  344. return Ext.Number.format(sum/count, '0.00');
  345. }
  346. });
  347. return store;
  348. },
  349. /**
  350. * 修改为selection改变时,summary也动态改变
  351. */
  352. summary: function(){
  353. var me = this,
  354. store = this.store, items = store.data.items, selected = me.selModel.getSelection(),
  355. value, m = me.down('erpToolbar');
  356. b = me.down('tbtext[id=selected-count]');
  357. if (!b) {
  358. m.add('-');
  359. b = m.add({xtype: 'tbtext', id: 'selected-count'});
  360. }
  361. b.setText('共: ' + items.length + ' 条, 已选: ' + selected.length + ' 条');
  362. },
  363. initRecords: function(){
  364. var records = this.store.data.items;
  365. var count = 0;
  366. Ext.each(records, function(record){
  367. if(!record.index){
  368. record.index = count++;
  369. }
  370. });
  371. },
  372. getSum: function(records, field) {
  373. var total = 0,
  374. i = 0,
  375. len = records.length;
  376. (len == 0) && (records = this.store.data.items);
  377. for (; i < len; ++i) {
  378. total += records[i].get(field);
  379. }
  380. return total;
  381. },
  382. listeners: {
  383. scrollershow: function(scroller) {
  384. if (scroller && scroller.scrollEl) {
  385. scroller.clearManagedListeners();
  386. scroller.mon(scroller.scrollEl, 'scroll', scroller.onElScroll, scroller);
  387. }
  388. }
  389. },
  390. setMore : function(c) {
  391. if(c >= 1000) {
  392. var g = this, e = g.down('erpToolbar');
  393. if(!g.bigVolume) {
  394. var m = e.down('tool[name=more]');
  395. if(!m) {
  396. m = Ext.create('Ext.panel.Tool', {
  397. name: 'more',
  398. type: 'right',
  399. margin: '0 5 0 5',
  400. handler: function() {
  401. g.bigVolume = true;
  402. g.ownerCt.down('form').onQuery();
  403. m.disable();
  404. }
  405. });
  406. e.add('->');
  407. e.add(m);
  408. } else {
  409. m.show();
  410. }
  411. }
  412. }
  413. },
  414. viewConfig: {// 显示分仓库库存
  415. listeners: {
  416. render: function(view) {
  417. var prodfield = view.ownerCt.getProdField();
  418. if(prodfield && !view.tip) {
  419. view.tip = Ext.create('Ext.tip.ToolTip', {
  420. target: view.el,
  421. delegate: view.itemSelector,
  422. trackMouse: true,
  423. renderTo: Ext.getBody(),
  424. listeners: {
  425. beforeshow: function updateTipBody(tip) {
  426. var record = view.getRecord(tip.triggerElement),
  427. grid = view.ownerCt;
  428. if(record && grid.productwh) {
  429. var c = record.get(prodfield), pws = new Array();
  430. Ext.each(grid.productwh, function(d){
  431. if(d.PW_PRODCODE == c) {
  432. pws.push(d);
  433. }
  434. });
  435. tip.down('grid').setTitle(c);
  436. tip.down('grid').store.loadData(pws);
  437. }
  438. }
  439. },
  440. items: [{
  441. xtype: 'grid',
  442. width: 300,
  443. columns: [{
  444. text: '仓库编号',
  445. cls: 'x-grid-header-1',
  446. dataIndex: 'PW_WHCODE',
  447. width: 80
  448. },{
  449. text: '仓库名称',
  450. cls: 'x-grid-header-1',
  451. dataIndex: 'WH_DESCRIPTION',
  452. width: 120
  453. },{
  454. text: '库存',
  455. cls: 'x-grid-header-1',
  456. xtype: 'numbercolumn',
  457. align: 'right',
  458. dataIndex: 'PW_ONHAND',
  459. width: 90
  460. }],
  461. columnLines: true,
  462. title: '物料分仓库存',
  463. store: new Ext.data.Store({
  464. fields: ['PW_WHCODE', 'WH_DESCRIPTION', 'PW_ONHAND'],
  465. data: [{}]
  466. })
  467. }]
  468. });
  469. }
  470. }
  471. }
  472. },
  473. getProdField : function() {
  474. var f = null;
  475. switch (caller){
  476. case 'SendNotify!ToProdIN!Deal' ://通知单转出货
  477. f = 'snd_prodcode';
  478. break;
  479. case 'Sale!ToAccept!Deal' ://订单转出货
  480. f = 'sd_prodcode';
  481. break;
  482. }
  483. return f;
  484. }
  485. });