MRPThrowGrid2.js 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445
  1. Ext.define('erp.view.pm.mps.MRPThrowGrid2',{
  2. extend: 'Ext.grid.Panel',
  3. requires: ['erp.view.core.plugin.CopyPasteMenu'],
  4. alias: 'widget.erpBatchDealGridPanel',
  5. id: 'batchDealGridPanel',
  6. emptyText : $I18N.common.grid.emptyText,
  7. columnLines : true,
  8. autoScroll : true,
  9. multiselected: [],
  10. /*layout:'Auto',*/
  11. verticalScrollerType: 'paginggridscroller',
  12. loadMask: true,
  13. disableSelection: true,
  14. invalidateScrollerOnRefresh: false,
  15. viewConfig: {
  16. trackOver: false
  17. },
  18. layout:'fit',
  19. store: [],
  20. columns: [],
  21. bodyStyle: 'background-color:#f1f1f1;',
  22. plugins: [Ext.create('Ext.ux.grid.GridHeaderFilters'),
  23. Ext.create('Ext.grid.plugin.CellEditing', {
  24. clicksToEdit: 1,
  25. listeners:{
  26. 'edit':function(editor,e,Opts){
  27. var record=e.record;
  28. if(e.originalValue!=e.value){
  29. Ext.MessageBox.show({
  30. title:'保存修改?',
  31. msg: '数据已修改需要保存吗?',
  32. buttons: Ext.Msg.YESNO,
  33. icon: Ext.Msg.WARNING,
  34. fn: function(btn){
  35. if(btn == 'yes'){
  36. //保存
  37. if(record.data.md_status!='未投放'){
  38. ('不能修改已投放的数据');
  39. return ;
  40. }
  41. Ext.Ajax.request({
  42. url:basePath+'pm/mrp/updateFieldData.action',
  43. params: {
  44. data:e.value,
  45. field:e.field,
  46. keyvalue:record.data.md_id
  47. },
  48. method : 'post',
  49. callback : function(options,success,response){
  50. var local=Ext.decode(response.responseText);
  51. if(local.success) {
  52. Ext.Msg.alert('提示','保存成功!');
  53. }else {
  54. showError(local.exceptionInfo);
  55. }
  56. }
  57. });
  58. } else if(btn == 'no'){
  59. //不保存
  60. e.record.reject();
  61. } else {
  62. return;
  63. }
  64. }
  65. });
  66. }
  67. /* if(record){
  68. data=record.data;
  69. for(var property in data){
  70. if(!/^[a-zA-Z]/.test(property)){
  71. qty+=data[property];
  72. }
  73. }
  74. if(qty>(data.ma_qty-data.ma_madeqty)){
  75. showError('排产数不能超过未交数!请重新输入');
  76. e.record.reject();
  77. }
  78. }*/
  79. }
  80. }
  81. }), Ext.create('erp.view.core.plugin.CopyPasteMenu')],
  82. features : [Ext.create('Ext.grid.feature.Grouping',{
  83. //startCollapsed: true,
  84. hideGroupedHeader: true,
  85. groupHeaderTpl: '{name} (Count:{rows.length})'
  86. }),{
  87. ftype : 'summary',
  88. showSummaryRow : false,//不显示默认合计行
  89. generateSummaryData: function(){
  90. var me = this,
  91. data = {},
  92. store = me.view.store,
  93. columns = me.view.headerCt.getColumnsForTpl(),
  94. i = 0,
  95. length = columns.length,
  96. //fieldData,
  97. //key,
  98. comp;
  99. //将feature的data打印在toolbar上面
  100. for (i = 0, length = columns.length; i < length; ++i) {
  101. comp = Ext.getCmp(columns[i].id);
  102. data[comp.id] = me.getSummary(store, comp.summaryType, comp.dataIndex, false);
  103. var tb = Ext.getCmp(columns[i].dataIndex + '_' + comp.summaryType);
  104. if(tb){
  105. tb.setText(tb.text.split(':')[0] + ':' + data[comp.id]);
  106. }
  107. }
  108. return data;
  109. }
  110. }],
  111. selModel: Ext.create('Ext.selection.CheckboxModel',{
  112. ignoreRightMouseSelection : false,
  113. listeners:{
  114. selectionchange:function(selectionModel, selected, options){
  115. }
  116. },
  117. getEditor: function(){
  118. return null;
  119. },
  120. onRowMouseDown: function(view, record, item, index, e) {//改写的onRowMouseDown方法
  121. var me = Ext.getCmp('batchDealGridPanel');
  122. var bool = true;
  123. var items = me.selModel.getSelection();
  124. Ext.each(items, function(item, index){
  125. if(this.index == record.index){
  126. bool = false;
  127. me.selModel.deselect(record);
  128. Ext.Array.remove(items, item);
  129. Ext.Array.remove(me.multiselected, record);
  130. }
  131. });
  132. Ext.each(me.multiselected, function(item, index){
  133. items.push(item);
  134. });
  135. me.selModel.select(items);
  136. if(bool){
  137. view.el.focus();
  138. var checkbox = item.childNodes[0].childNodes[0].childNodes[0];
  139. if(checkbox.getAttribute && checkbox.getAttribute('class') == 'x-grid-row-checker'){
  140. me.multiselected.push(record);
  141. items.push(record);
  142. me.selModel.select(items);
  143. } else {
  144. me.selModel.deselect(record);
  145. Ext.Array.remove(me.multiselected, record);
  146. }
  147. }
  148. me.summary();
  149. },
  150. onHeaderClick: function(headerCt, header, e) {
  151. if (header.isCheckerHd) {
  152. e.stopEvent();
  153. var isChecked = header.el.hasCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');
  154. if (isChecked) {
  155. this.deselectAll(true);
  156. var grid = Ext.getCmp('batchDealGridPanel');
  157. this.deselect(grid.multiselected);
  158. grid.multiselected = new Array();
  159. var els = Ext.select('div[@class=x-grid-row-checker-checked]').elements;
  160. Ext.each(els, function(el, index){
  161. el.setAttribute('class','x-grid-row-checker');
  162. });
  163. header.el.removeCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');//添加这个
  164. } else {
  165. var grid = Ext.getCmp('batchDealGridPanel');
  166. this.deselect(grid.multiselected);
  167. grid.multiselected = new Array();
  168. var els = Ext.select('div[@class=x-grid-row-checker-checked]').elements;
  169. Ext.each(els, function(el, index){
  170. el.setAttribute('class','x-grid-row-checker');
  171. });
  172. this.selectAll(true);
  173. header.el.addCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');//添加这个
  174. }
  175. }
  176. Ext.getCmp('batchDealGridPanel').summary();
  177. }
  178. }),
  179. initComponent : function(){
  180. this.GridUtil = Ext.create('erp.util.GridUtil');
  181. this.BaseUtil = Ext.create('erp.util.BaseUtil');
  182. this.RenderUtil = Ext.create('erp.util.RenderUtil');
  183. condition = this.BaseUtil.getUrlParam('urlcondition');
  184. condition = (condition == null) ? "" : condition;
  185. condition = condition.replace(/@/,"'%").replace(/@/,"%'");
  186. this.defaultCondition = condition;
  187. var gridParam = {caller: caller, condition: condition};
  188. this.getGridColumnsAndStore(this, 'common/singleGridPanel.action?', gridParam, "");
  189. this.callParent(arguments);
  190. //this.initRecords();
  191. },
  192. getGridColumnsAndStore: function(grid, url, param, no){
  193. var me = this;
  194. me.setLoading(true);//loading...
  195. Ext.Ajax.request({//拿到grid的columns
  196. url : basePath + 'pm/mrp/getMRPThrowConfig.action',
  197. params: param,
  198. method : 'post',
  199. async: false,
  200. callback : function(options,success,response){
  201. me.setLoading(false);
  202. var res = new Ext.decode(response.responseText);
  203. if(res.exceptionInfo){
  204. showError(res.exceptionInfo);return;
  205. }
  206. if(me.columns && me.columns.length > 2){
  207. var data = res.data != null ? Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')) : [];
  208. me.store.loadData(data);
  209. //解决固定列左右不对齐的情况
  210. var lockedView = me.view.lockedView;
  211. if(lockedView){
  212. var tableEl = lockedView.el.child('.x-grid-table');
  213. if(tableEl){
  214. tableEl.dom.style.marginBottom = '7px';
  215. }
  216. }
  217. me.initRecords();
  218. } else {
  219. if(res.columns){
  220. Ext.each(res.columns, function(column, y){
  221. me.setRenderer(column);
  222. var logic = column.logic;
  223. if(logic != null){
  224. me.setLogicType(column, logic, y);
  225. }
  226. });
  227. //store
  228. me.store = Ext.create('Ext.data.Store', {
  229. id: 'store',
  230. pageSize: 20,
  231. fields:res.fields,
  232. remoteSort: true,
  233. buffered: true,
  234. proxy: {
  235. type: 'ajax',
  236. url: basePath+'pm/mrp/getMrpData.action',
  237. extraParams:param,
  238. reader: {
  239. type:'json',
  240. root: 'data',
  241. totalProperty: 'totalCount'
  242. }
  243. },
  244. //autoLoad:true,
  245. leadingbufferzone:40,
  246. sorters: [{
  247. property: 'md_id',
  248. direction: 'DESC'
  249. }]
  250. });
  251. me.store.guaranteeRange(0,19);
  252. //view
  253. if(me.selModel.views == null){
  254. me.selModel.views = [];
  255. }
  256. me.columns=res.columns;
  257. }
  258. }
  259. }
  260. });
  261. },
  262. getMultiSelected: function(){
  263. var grid = this;
  264. var items = grid.selModel.getSelection();
  265. console.log(items);
  266. Ext.each(items, function(item, index){
  267. if(this.data[grid.keyField] != null && this.data[grid.keyField] != ''
  268. && this.data[grid.keyField] != '0' && this.data[grid.keyField] != 0){
  269. grid.multiselected.push(item);
  270. }
  271. });
  272. return Ext.Array.unique(grid.multiselected);
  273. },
  274. setRenderer: function(column){
  275. var grid = this;
  276. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  277. var renderName = column.renderer;
  278. if(contains(column.renderer, ':', true)){
  279. var args = new Array();
  280. Ext.each(column.renderer.split(':'), function(a, index){
  281. if(index == 0){
  282. renderName = a;
  283. } else {
  284. args.push(a);
  285. }
  286. });
  287. if(!grid.RenderUtil.args[renderName]){
  288. grid.RenderUtil.args[renderName] = new Object();
  289. }
  290. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  291. }
  292. column.renderer = grid.RenderUtil[renderName];
  293. column.haveRendered = true;
  294. }
  295. },
  296. setLogicType: function(column, logic, y){
  297. var grid = this;
  298. if(logic == 'detno'){
  299. grid.detno = column.dataIndex;
  300. } else if(logic == 'keyField'){
  301. grid.keyField = column.dataIndex;
  302. } else if(logic == 'mainField'){
  303. grid.mainField = column.dataIndex;
  304. } else if(logic == 'necessaryField'){
  305. grid.necessaryField = column.dataIndex;
  306. if(!grid.necessaryFields){
  307. grid.necessaryFields = new Array();
  308. }
  309. grid.necessaryFields.push(column.dataIndex);
  310. if(!column.haveRendered){
  311. column.renderer = function(val, meta, record, x, y, store, view){
  312. var c = this.columns[y];
  313. if(val != null && val.toString().trim() != ''){
  314. if(c.xtype == 'datecolumn'){
  315. val = Ext.Date.format(val, 'Y-m-d');
  316. }
  317. return val;
  318. } else {
  319. if(c.xtype == 'datecolumn'){
  320. val = '';
  321. }
  322. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  323. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  324. }
  325. };
  326. }
  327. } else if(logic == 'groupField'){
  328. grid.groupField = column.dataIndex;
  329. }
  330. },
  331. setToolbar: function(columns){
  332. var grid = this;
  333. var items = [];
  334. Ext.each(columns, function(column){
  335. if(column.summaryType == 'sum'){
  336. items.push('-',{
  337. id: column.dataIndex + '_sum',
  338. itemId: column.dataIndex,
  339. xtype: 'tbtext',
  340. text: column.header + '(sum):0'
  341. });
  342. } else if(column.summaryType == 'average') {
  343. items.push('-',{
  344. id: column.dataIndex + '_average',
  345. itemId: column.dataIndex,
  346. xtype: 'tbtext',
  347. text: column.header + '(average):0'
  348. });
  349. } else if(column.summaryType == 'count') {
  350. items.push('-',{
  351. id: column.dataIndex + '_count',
  352. itemId: column.dataIndex,
  353. xtype: 'tbtext',
  354. text: column.header + '(count):0'
  355. });
  356. }
  357. });
  358. grid.bbar = {
  359. xtype: 'toolbar',
  360. dock: 'bottom',
  361. items: items
  362. };
  363. },
  364. setDefaultStore: function(d, f){
  365. var me = this;
  366. var data = [];
  367. if(!d || d.length == 2){
  368. me.GridUtil.add10EmptyData(me.detno, data);
  369. me.GridUtil.add10EmptyData(me.detno, data);
  370. } else {
  371. data = Ext.decode(d.replace(/,}/g, '}').replace(/,]/g, ']'));
  372. }
  373. var store = Ext.create('Ext.data.Store', {
  374. fields: f,
  375. data: data,
  376. pageSize: 30,
  377. buffered: true,
  378. purgePageCount: 0,
  379. groupField: me.groupField,
  380. autoLoad:false,
  381. getSum: function(field) {
  382. var records = me.selModel.getSelection(),
  383. total = 0,
  384. i = 0,
  385. len = records.length;
  386. for (; i < len; ++i) {
  387. total += records[i].get(field);
  388. }
  389. return total;
  390. },
  391. getCount: function() {
  392. var records = me.selModel.getSelection(),
  393. count = 0;
  394. Ext.each(records, function(item){
  395. count++;
  396. });
  397. return count;
  398. },
  399. getAverage: function(field) {
  400. var records = me.selModel.getSelection(),
  401. count = 0,
  402. sum = 0;
  403. Ext.each(records, function(item){
  404. if(item.data[me.necessaryField] != null && item.data[me.necessaryField] != ''){
  405. count++;sum += item.data[field];
  406. }
  407. });
  408. return Ext.Number.format(sum/count, '0.00');
  409. }
  410. });
  411. return store;
  412. },
  413. /**
  414. * 修改为selection改变时,summary也动态改变
  415. */
  416. summary: function(){
  417. var me = this,
  418. store = this.store,
  419. value;
  420. Ext.each(me.columns, function(c){
  421. if(c.summaryType == 'sum'){
  422. value = store.getSum(c.dataIndex);
  423. me.down('tbtext[id=' + c.dataIndex + '_sum]').setText(c.header + '(sum):' + value);
  424. } else if(c.summaryType == 'count'){
  425. value = store.getCount();
  426. me.down('tbtext[id=' + c.dataIndex + '_count]').setText(c.header + '(count):' + value);
  427. } else if(c.summaryType == 'average'){
  428. value = store.getAverage(c.dataIndex);
  429. me.down('tbtext[id=' + c.dataIndex + '_average]').setText(c.header + '(average):' + value);
  430. }
  431. });
  432. },
  433. initRecords: function(){
  434. var records = this.store.data.items;
  435. var count = 0;
  436. Ext.each(records, function(record){
  437. if(!record.index){
  438. record.index = count++;
  439. }
  440. });
  441. }
  442. });