GridUtil.js 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918
  1. Ext.define('erp.util.GridUtil',{
  2. /**
  3. * 取grid配置及数据
  4. * 包括dbfind的配置
  5. * @param no 需要自动编号的字段
  6. */
  7. getGridColumnsAndStore: function(grid, url, param, no){
  8. var me = this;
  9. grid.setLoading(true);
  10. Ext.Ajax.request({//拿到grid的columns
  11. url : basePath + url,
  12. params: param,
  13. async: (grid.sync ? false : true),
  14. method : 'post',
  15. callback : function(options,success,response){
  16. grid.setLoading(false);
  17. if (!response) return;
  18. var res = new Ext.decode(response.responseText);
  19. if(res.exceptionInfo){
  20. showError(res.exceptionInfo);return;
  21. }
  22. if(res.columns){
  23. var limits = res.limits, limitArr = new Array();
  24. if(limits != null && limits.length > 0) {//权限外字段
  25. limitArr = Ext.Array.pluck(limits, 'lf_field');
  26. }
  27. Ext.each(res.columns, function(column, y){
  28. // column有取别名
  29. if(column.dataIndex.indexOf(' ') > -1) {
  30. column.dataIndex = column.dataIndex.split(' ')[1];
  31. }
  32. //power
  33. if(limitArr.length > 0 && Ext.Array.contains(limitArr, column.dataIndex)) {
  34. column.hidden = true;
  35. }
  36. //renderer
  37. me.setRenderer(grid, column);
  38. //logictype
  39. me.setLogicType(grid, column);
  40. });
  41. //data
  42. var data = [];
  43. if(!res.data || res.data.length == 2){
  44. if (grid.buffered) {
  45. me.add10EmptyData(grid.detno, data);
  46. me.add10EmptyData(grid.detno, data);//添加20条空白数据
  47. } else {
  48. grid.on('reconfigure', function(){// 改为Grid加载后再添加空行,节约200~700ms
  49. me.add10EmptyItems(grid, 40, false);
  50. });
  51. }
  52. } else {
  53. data = Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']'));
  54. }
  55. //store
  56. var store = me.setStore(grid, res.fields, data, grid.groupField, grid.necessaryField);
  57. //view
  58. if(grid.selModel && grid.selModel.views == null){
  59. grid.selModel.views = [];
  60. }
  61. //dbfind
  62. if(res.dbfinds && res.dbfinds.length > 0){
  63. grid.dbfinds = res.dbfinds;
  64. }
  65. //reconfigure
  66. if(grid.sync) {//同步加载的Grid
  67. grid.reconfigure(store, res.columns);
  68. grid.on('afterrender', function(){
  69. me.setToolbar(grid, grid.columns, grid.necessaryField, limitArr);
  70. });
  71. } else {
  72. //toolbar
  73. if (grid.generateSummaryData === undefined) {// 改为Grid加载后再添加合计,节约60ms
  74. me.setToolbar(grid, res.columns, grid.necessaryField, limitArr);
  75. }
  76. grid.reconfigure(store, res.columns);
  77. }
  78. if(grid.buffered) {//缓冲数据的Grid
  79. grid.verticalScroller = Ext.create('Ext.grid.PagingScroller', {
  80. activePrefetch: false,
  81. store: store
  82. });
  83. store.guaranteeRange(0, Math.min(store.pageSize, store.prefetchData.length) - 1);
  84. }
  85. var form = Ext.ComponentQuery.query('form');
  86. if(form && form.length > 0){
  87. grid.readOnly = form[0].readOnly;//grid不可编辑
  88. }
  89. } else {
  90. grid.hide();
  91. var form = Ext.ComponentQuery.query('form')[0];
  92. if(form) {
  93. if(form.items.items.length == 0) {
  94. form.on('afterload', function(){
  95. me.updateFormPosition(form);//字段较少时,修改form布局
  96. });
  97. } else {
  98. me.updateFormPosition(form);//字段较少时,修改form布局
  99. }
  100. }
  101. }
  102. }
  103. });
  104. },
  105. setRenderer: function(grid, column){
  106. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  107. if(!grid.RenderUtil){
  108. grid.RenderUtil = Ext.create('erp.util.RenderUtil');
  109. }
  110. var renderName = column.renderer;
  111. if(contains(column.renderer, ':', true)){
  112. var args = new Array();
  113. Ext.each(column.renderer.split(':'), function(a, index){
  114. if(index == 0){
  115. renderName = a;
  116. } else {
  117. args.push(a);
  118. }
  119. });
  120. if(!grid.RenderUtil.args[renderName]){
  121. grid.RenderUtil.args[renderName] = new Object();
  122. }
  123. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  124. }
  125. column.renderer = grid.RenderUtil[renderName];
  126. column.haveRendered = true;
  127. }
  128. },
  129. setLogicType: function(grid, column){
  130. var logic = column.logic;
  131. if(logic != null){
  132. if(logic == 'detno'){
  133. grid.detno = column.dataIndex;
  134. column.width = 40;
  135. column.align = 'center';
  136. column.renderer = function(val, meta) {
  137. meta.tdCls = Ext.baseCSSPrefix + 'grid-cell-special';
  138. return val;
  139. };
  140. } else if(logic == 'keyField'){
  141. grid.keyField = column.dataIndex;
  142. } else if(logic == 'mainField'){
  143. grid.mainField = column.dataIndex;
  144. }else if(logic == 'orNecessField'){
  145. if(!grid.orNecessField){
  146. grid.orNecessField = new Array();
  147. }
  148. grid.orNecessField.push(column.dataIndex);
  149. }else if(logic == 'necessaryField'){
  150. grid.necessaryField = column.dataIndex;
  151. if(!grid.necessaryFields){
  152. grid.necessaryFields = new Array();
  153. }
  154. grid.necessaryFields.push(column.dataIndex);
  155. if(!column.haveRendered){
  156. column.renderer = function(val, meta, record, x, y, store, view){
  157. var c = this.columns[y];
  158. if(val != null && val.toString().trim() != ''){
  159. if(c.xtype == 'datecolumn' && typeof val === 'object'){
  160. val = Ext.Date.format(val, 'Y-m-d');
  161. } else if(c.xtype == 'numbercolumn') {
  162. val = Ext.util.Format.number(val, c.format || '0,000.00');
  163. }
  164. return val;
  165. } else {
  166. if(c.xtype == 'datecolumn'){
  167. val = '';
  168. }
  169. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  170. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  171. }
  172. };
  173. }
  174. } else if(logic == 'groupField'){
  175. grid.groupField = column.dataIndex;
  176. }
  177. }
  178. },
  179. setStore: function(grid, fields, data, groupField, necessaryField){
  180. Ext.each(fields, function(f){
  181. if(f.name.indexOf(' ') > -1) {// column有取别名
  182. f.name = f.name.split(' ')[1];
  183. }
  184. if(!Ext.isChrome){
  185. if(f.type == 'date'){
  186. f.dateFormat = 'Y-m-d H:m:s';
  187. }
  188. }
  189. });
  190. var modelName = 'ext-model-' + grid.id;
  191. Ext.define(modelName, {
  192. extend: 'Ext.data.Model',
  193. fields: fields
  194. });
  195. var config = {
  196. model: modelName,
  197. groupField: groupField,
  198. getSum: function(records, field) {
  199. if (arguments.length < 2) {
  200. return 0;
  201. }
  202. var total = 0,
  203. i = 0,
  204. len = records.length;
  205. if(necessaryField) {
  206. for (; i < len; ++i) {//重写getSum,grid在合计时,只合计填写了必要信息的行
  207. var necessary = records[i].get(necessaryField);
  208. if(necessary != null && necessary != ''){
  209. total += records[i].get(field);
  210. }
  211. }
  212. } else {
  213. for (; i < len; ++i) {
  214. total += records[i].get(field);
  215. }
  216. }
  217. return total;
  218. },
  219. getCount: function() {
  220. if(necessaryField) {
  221. var count = 0;
  222. Ext.each(this.data.items, function(item){//重写getCount,grid在合计时,只合计填写了必要信息的行
  223. if(item.data[necessaryField] != null && item.data[necessaryField] != ''){
  224. count++;
  225. }
  226. });
  227. return count;
  228. }
  229. return this.data.items.length;
  230. }
  231. };
  232. if(grid.buffered) {//grid数据缓存
  233. config.buffered = true;
  234. config.pageSize = 200;
  235. config.purgePageCount = 0;
  236. config.proxy = {
  237. type: 'memory'
  238. };
  239. } else {
  240. config.data = data;
  241. }
  242. var store = Ext.create('Ext.data.Store', config);
  243. store.each(function(item, x){
  244. item.index = x;
  245. });
  246. if(grid.buffered) {
  247. var ln = data.length, records = [], i = 0;
  248. for (; i < ln; i++) {
  249. records.push(Ext.create(modelName, data[i]));
  250. }
  251. store.cacheRecords(records);
  252. }
  253. return store;
  254. },
  255. setToolbar: function(grid, columns, necessaryField, limitArr){
  256. var items = [];
  257. var bool = true;
  258. if(!grid.dockedItems)
  259. return;
  260. Ext.each(grid.dockedItems.items, function(item){
  261. if(item.dock == 'bottom' && item.items){//bbar已存在
  262. bool = false;
  263. }
  264. });
  265. if(bool){
  266. Ext.each(columns, function(column){
  267. if(limitArr.length == 0 || !Ext.Array.contains(limitArr, column.dataIndex)) {
  268. if(column.summaryType == 'sum'){
  269. items.push('-',{
  270. id: column.dataIndex + '_sum',
  271. itemId: column.dataIndex,
  272. xtype: 'tbtext',
  273. text: column.text + '(sum):0'
  274. });
  275. } else if(column.summaryType == 'average') {
  276. items.push('-',{
  277. id: column.dataIndex + '_average',
  278. itemId: column.dataIndex,
  279. xtype: 'tbtext',
  280. text: column.text + '(average):0'
  281. });
  282. } else if(column.summaryType == 'count') {
  283. items.push('-',{
  284. id: column.dataIndex + '_count',
  285. itemId: column.dataIndex,
  286. xtype: 'tbtext',
  287. text: column.text + '(count):0'
  288. });
  289. }
  290. }
  291. if(column.dataIndex == necessaryField){
  292. column.renderer = function(val){
  293. if(val != null && val.toString().trim() != ''){
  294. return val;
  295. } else {
  296. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  297. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  298. }
  299. };
  300. }
  301. });
  302. grid.addDocked({
  303. xtype: 'toolbar',
  304. dock: 'bottom',
  305. items: items
  306. });
  307. } else {
  308. var bars = Ext.ComponentQuery.query('erpToolbar');
  309. if(bars.length > 0){
  310. Ext.each(columns, function(column){
  311. if(column.summaryType == 'sum'){
  312. bars[0].add('-');
  313. bars[0].add({
  314. id: column.dataIndex + '_sum',
  315. itemId: column.dataIndex,
  316. xtype: 'tbtext',
  317. text: column.text + '(sum):0'
  318. });
  319. } else if(column.summaryType == 'average') {
  320. bars[0].add('-');
  321. bars[0].add({
  322. id: column.dataIndex + '_average',
  323. itemId: column.dataIndex,
  324. xtype: 'tbtext',
  325. text: column.text + '(average):0'
  326. });
  327. } else if(column.summaryType == 'count') {
  328. bars[0].add('-');
  329. bars[0].add({
  330. id: column.dataIndex + '_count',
  331. itemId: column.dataIndex,
  332. xtype: 'tbtext',
  333. text: column.text + '(count):0'
  334. });
  335. }
  336. });
  337. }
  338. }
  339. },
  340. updateFormPosition: function(form){
  341. var height = window.innerHeight;
  342. var width = window.innerWidth;
  343. if(Ext.isIE){
  344. height = screen.height*0.75;
  345. width = screen.width*0.75;
  346. }
  347. if(form){
  348. if(form.items.items.length > 12){
  349. form.setHeight(height);
  350. } else {//少于12个字段的单form页面,强制居中显示
  351. if(form.items.items == 0){
  352. form.on('afterlayout', function(){
  353. if(0 < form.items.items.length <= 12){
  354. Ext.each(form.items.items, function(item){
  355. if(item.columnWidth >= 0.25 && item.columnWidth < 0.6){
  356. item.setWidth(width*0.65*0.45);
  357. item.columnWidth = 0.4;
  358. } else if(item.columnWidth >= 0.6) {
  359. item.setWidth(width*0.65*0.9);
  360. item.columnWidth = 1;
  361. }
  362. });
  363. }
  364. });
  365. } else {
  366. Ext.each(form.items.items, function(item){
  367. if(item.columnWidth >= 0.25 && item.columnWidth < 0.6){
  368. item.setWidth(width*0.65*0.45);
  369. item.columnWidth = 0.4;
  370. } else if(item.columnWidth >= 0.6) {
  371. item.setWidth(width*0.65*0.9);
  372. item.columnWidth = 1;
  373. }
  374. });
  375. }
  376. form.setHeight('60%');
  377. form.setWidth('80%');
  378. form.el.dom.style.top = height*0.175;
  379. form.el.dom.style.marginTop = height*0.125 + 'px';
  380. form.el.dom.style.marginRight = width*0.125 + 'px';
  381. form.el.dom.style.marginLeft = width*0.125 + 'px';
  382. form.el.dom.style.paddingLeft = '30px';
  383. form.el.dom.style.paddingTop = '15px';
  384. //form.el.dom.align = 'center';
  385. //form.setPosition(width*0.175, height*0.175);
  386. }
  387. }
  388. },
  389. loadNewStore: function(grid, param){
  390. var me = this;
  391. grid.setLoading(true);//loading...
  392. Ext.Ajax.request({//拿到grid的columns
  393. url : basePath + "common/loadNewGridStore.action",
  394. params: param,
  395. method : 'post',
  396. callback : function(options,success,response){
  397. grid.setLoading(false);
  398. var res = new Ext.decode(response.responseText);
  399. if(res.exceptionInfo){
  400. showError(res.exceptionInfo);return;
  401. }
  402. var data = res.data;
  403. if(!data || data.length == 0){
  404. grid.store.removeAll();
  405. me.add10EmptyItems(grid);
  406. } else {
  407. if(grid.buffered) {
  408. var ln = data.length, records = [], i = 0;
  409. for (; i < ln; i++) {
  410. records.push(Ext.create(grid.store.model.getName(), data[i]));
  411. }
  412. grid.store.purgeRecords();
  413. grid.store.cacheRecords(records);
  414. grid.store.totalCount = ln;
  415. grid.store.guaranteedStart = -1;
  416. grid.store.guaranteedEnd = -1;
  417. var a = grid.store.pageSize - 1;
  418. a = a > ln - 1 ? ln - 1 : a;
  419. grid.store.guaranteeRange(0, a);
  420. } else {
  421. grid.store.loadData(data);
  422. }
  423. }
  424. //自定义event
  425. grid.addEvents({
  426. storeloaded: true
  427. });
  428. grid.fireEvent('storeloaded', grid, data);
  429. }
  430. });
  431. },
  432. /**
  433. * 从index行开始,往grid里面加十空行
  434. * @param detno 编号字段
  435. * @param data 需要添加空白数据的data
  436. */
  437. add10EmptyData: function(detno, data){
  438. if(detno){
  439. var index = data.length == 0 ? 0 : Number(data[data.length-1][detno]);
  440. for(var i=0;i<20;i++){
  441. var o = new Object();
  442. o[detno] = index + i + 1;
  443. data.push(o);
  444. }
  445. } else {
  446. for(var i=0;i<20;i++){
  447. var o = new Object();
  448. data.push(o);
  449. }
  450. }
  451. },
  452. /**
  453. * 从index行开始,往grid里面加十空行
  454. * @param grid
  455. */
  456. add10EmptyItems: function(grid, count, append){
  457. var store = grid.store,
  458. items = store.data.items, arr = new Array();
  459. var detno = grid.detno;
  460. count = count || 10;
  461. append = append === undefined ? true : false;
  462. if(detno){
  463. var index = items.length == 0 ? 0 : Number(store.last().get(detno));
  464. for(var i=0;i < count;i++ ){
  465. var o = new Object();
  466. o[detno] = index + i + 1;
  467. arr.push(o);
  468. }
  469. } else {
  470. for(var i=0;i < count;i++ ){
  471. var o = new Object();
  472. arr.push(o);
  473. }
  474. }
  475. store.loadData(arr, append);
  476. var i = 0;
  477. store.each(function(item, x){
  478. if(item.index) {
  479. i = item.index;
  480. } else {
  481. if (i) {
  482. item.index = i++;
  483. } else {
  484. item.index = x;
  485. }
  486. }
  487. });
  488. },
  489. isBlank: function(grid, data) {
  490. if(typeof grid.isEmptyRecord === 'function') {
  491. return grid.isEmptyRecord.call(grid, data);
  492. } else {
  493. console.log(grid.necessaryFields);
  494. var ff = grid.necessaryFields,bool = true;
  495. var of = grid.orNecessField, c;
  496. if(ff) {
  497. bool = false;
  498. Ext.each(ff, function(f) {
  499. c = grid.down('gridcolumn[dataIndex=' + f + ']');
  500. if(Ext.isEmpty(data[f]) || (data[f] == 0 && c
  501. && c.xtype != 'ynnvcolumn' && c.xtype != 'yncolumn')) {
  502. bool = true;return;
  503. }
  504. });
  505. } else if(of){
  506. Ext.each(of,function(f){
  507. if(!Ext.isEmpty(data[f]) && data[f] != 0){
  508. bool = false;
  509. return;
  510. }
  511. });
  512. } else {
  513. if(!grid.necessaryField || !Ext.isEmpty(data[grid.necessaryField])) {
  514. bool = false;
  515. }
  516. }
  517. return bool;
  518. }
  519. },
  520. /**
  521. * 获取grid已保存但部分必填字段没填写的行,并提示
  522. */
  523. getInvalid: function(grid) {
  524. if(grid.keyField) {
  525. var me = this, cols = {};
  526. Ext.Array.each(grid.columns, function(c){
  527. if(c.dataIndex)
  528. cols[c.dataIndex] = c.text || c.header;
  529. });
  530. var errs = [];
  531. grid.store.each(function(record){
  532. var key = record.get(grid.keyField);
  533. if(key && key > 0 && me.isBlank(grid, record.data)) {
  534. var ff = grid.necessaryFields, s = '';
  535. if(ff) {
  536. Ext.each(ff, function(f) {
  537. c = grid.down('gridcolumn[dataIndex=' + f + ']');
  538. if(c.logic != 'ignore' && (Ext.isEmpty(record.get(f)) || (record.get(f) == 0 && c
  539. && c.xtype != 'ynnvcolumn' && c.xtype != 'yncolumn'))) {
  540. s += '<u> ' + (c.text || c.header) + ' </u> ';
  541. }
  542. });
  543. } else if(grid.necessaryField) {
  544. var f = grid.necessaryField, c = grid.down('gridcolumn[dataIndex=' + f + ']');
  545. if(c.logic != 'ignore' && (Ext.isEmpty(record.get(f)) || (record.get(f) == 0 && c
  546. && c.xtype != 'ynnvcolumn' && c.xtype != 'yncolumn'))) {
  547. s += '<u> ' + (c.text || c.header) + ' </u> ';
  548. }
  549. }
  550. if(s.length > 0)
  551. errs.push((grid.detno ? ('行: ' + record.get(grid.detno) + ', ') : '') + s);
  552. }
  553. });
  554. return errs.join('<br>');
  555. }
  556. return null;
  557. },
  558. /**
  559. * 拿到grid里面要提交的数据
  560. */
  561. getGridStore: function(grid){
  562. if(grid == null){
  563. grid = Ext.getCmp('grid');
  564. }
  565. var me = this,
  566. jsonGridData = new Array();
  567. var form = Ext.getCmp('form');
  568. if(grid!=null){
  569. var s = grid.getStore().data.items;//获取store里面的数据
  570. var dd;
  571. for(var i=0;i<s.length;i++){//将grid里面各行的数据获取并拼成jsonGridData
  572. var data = s[i].data;
  573. dd = new Object();
  574. if(s[i].dirty && !me.isBlank(grid, data)){
  575. Ext.each(grid.columns, function(c){
  576. if((!c.isCheckerHd)&&(c.logic != 'ignore')){//只需显示,无需后台操作的字段,自动略去
  577. if(c.xtype == 'datecolumn'){
  578. c.format = c.format || 'Y-m-d';
  579. if(Ext.isDate(data[c.dataIndex])){
  580. dd[c.dataIndex] = Ext.Date.format(data[c.dataIndex], c.format);
  581. } else {
  582. if(c.editor&&c.logic!='unauto'){
  583. dd[c.dataIndex] = Ext.Date.format(new Date(), c.format);//如果用户没输入日期,或输入有误,就给个默认日期,
  584. }
  585. }
  586. } else if(c.xtype == 'datetimecolumn'){
  587. if(Ext.isDate(data[c.dataIndex])){
  588. dd[c.dataIndex] = Ext.Date.format(data[c.dataIndex], 'Y-m-d H:i:s');//在这里把GMT日期转化成Y-m-d H:i:s格式日期
  589. } else {
  590. if(c.editor&&c.logic!='unauto'){
  591. dd[c.dataIndex] = Ext.Date.format(new Date(), 'Y-m-d H:i:s');//默认日期,
  592. }
  593. }
  594. } else if(c.xtype == 'numbercolumn'){//赋个默认值0吧,不然不好保存
  595. if(data[c.dataIndex] == null || data[c.dataIndex] == '' || String(data[c.dataIndex]) == 'NaN'){
  596. dd[c.dataIndex] = '0';//也可以从data里面去掉这些字段
  597. } else {
  598. dd[c.dataIndex] = "" + s[i].data[c.dataIndex];
  599. }
  600. } else {
  601. dd[c.dataIndex] = s[i].data[c.dataIndex];
  602. }
  603. if (c.defaultValue && (dd[c.dataIndex] == null || dd[c.dataIndex] == '0')) {
  604. dd[c.dataIndex] = c.defaultValue;
  605. }
  606. }
  607. });
  608. if(grid.mainField && form && form.keyField){//例如,将pu_id的值赋给pd_puid
  609. dd[grid.mainField] = Ext.getCmp(form.keyField).value;
  610. }
  611. jsonGridData.push(Ext.JSON.encode(dd));
  612. }
  613. }
  614. }
  615. return jsonGridData;
  616. },
  617. getAllGridStore: function(grid){
  618. if(grid == null){
  619. grid = Ext.getCmp('grid');
  620. }
  621. var jsonGridData = new Array();
  622. var form = Ext.getCmp('form');
  623. grid.getStore().each(function(item){//将grid里面各行的数据获取并拼成jsonGridData
  624. var data = Ext.clone(item.data);
  625. if(data[grid.necessaryField] != null && data[grid.necessaryField] != ""){
  626. if(grid.mainField && form && form.keyField){//例如,将pu_id的值赋给pd_puid
  627. data[grid.mainField] = Ext.getCmp(form.keyField).value;
  628. }
  629. Ext.each(grid.columns, function(c){
  630. if(c.xtype == 'datecolumn'){
  631. if(Ext.isDate(data[c.dataIndex])){
  632. data[c.dataIndex] = Ext.Date.toString(data[c.dataIndex]);//在这里把GMT日期转化成Y-m-d格式日期
  633. } else {
  634. data[c.dataIndex] = Ext.Date.format(new Date(), 'Y-m-d');//如果用户没输入日期,或输入有误,就给个默认日期,
  635. //或干脆return;并且提示一下用户
  636. }
  637. } else if(c.xtype == 'numbercolumn'){//赋个默认值0吧,不然不好保存
  638. if(data[c.dataIndex] == null || data[c.dataIndex] == ''){
  639. data[c.dataIndex] = '0';//也可以从data里面去掉这些字段
  640. } else {
  641. data[c.dataIndex] = "" + data[c.dataIndex];
  642. }
  643. }
  644. });
  645. jsonGridData.push(Ext.JSON.encode(data));
  646. }
  647. });
  648. return jsonGridData;
  649. },
  650. /**
  651. * 检查grid是否已修改
  652. */
  653. checkGridDirty: function(grid){
  654. var store = grid.getStore().data.items;//获取store里面的数据
  655. var msg = '';
  656. for(var i=0;i<store.length;i++){
  657. if(store[i].dirty){//明细行被修改过哦
  658. var changed = Ext.Object.getKeys(store[i].modified);//拿到被修改了的字段
  659. var s = '';
  660. for(var j = 0;j < changed.length;j++){
  661. Ext.each(grid.columns, function(c, index){
  662. if((!c.isCheckerHd) && (c.logic != 'ignore') && (c.logic != 'detno')){
  663. if(c.dataIndex == changed[j]){//由字段dataindex匹配其text
  664. if(s == '') {
  665. s = '第' + (i+1) + '行:';
  666. }
  667. s += '<font color=blue>' + c.text + '</font>&nbsp;';
  668. }
  669. }
  670. });
  671. }
  672. if(s != '')
  673. msg += s;
  674. }
  675. }
  676. if(msg != '' && msg != ';'){//明细行被修改过哦
  677. msg = "明细行<font color=green>" + msg.substring(0, msg.length-1) + "</font>已编辑过";
  678. } else {
  679. msg = '';
  680. }
  681. return msg;
  682. },
  683. getRecordByCode: function(param){
  684. Ext.Ajax.request({
  685. url : basePath + 'common/getRecordByCode.action',
  686. params: param,
  687. method : 'post',
  688. callback : function(options,success,response){
  689. //var res = new Ext.decode(response.responseText);
  690. }
  691. });
  692. },
  693. onGridItemClick: function(selModel, record, id){
  694. var me = this.GridUtil || this;
  695. var grid = selModel.ownerCt;
  696. if(grid && !grid.readOnly){
  697. var index = grid.store.indexOf(record);
  698. if(index == grid.store.indexOf(grid.store.last())){
  699. me.add10EmptyItems(grid);//就再加10行
  700. }
  701. var btn = grid.down('erpDeleteDetailButton');
  702. if(btn)
  703. btn.setDisabled(false);
  704. btn = grid.down('erpAddDetailButton');
  705. if(btn)
  706. btn.setDisabled(false);
  707. btn = grid.down('copydetail');
  708. if(btn)
  709. btn.setDisabled(false);
  710. btn = grid.down('pastedetail');
  711. if(btn)
  712. btn.setDisabled(false);
  713. btn = grid.down('updetail');
  714. if(btn)
  715. btn.setDisabled(false);
  716. btn = grid.down('downdetail');
  717. if(btn)
  718. btn.setDisabled(false);
  719. if(grid.down('tbtext[name=row]')){
  720. grid.down('tbtext[name=row]').setText(index);
  721. }
  722. }
  723. },
  724. onGridItemClickForEditGrid: function(selModel, record, id){
  725. var grid = id == null ? Ext.getCmp('grid') : Ext.getCmp(id);
  726. var index = null;
  727. if(grid.detno){
  728. index = record.data[grid.detno];
  729. index = index == null ? (record.index + 1) : index;
  730. if(index.toString() == 'NaN'){
  731. index = '';
  732. }
  733. if(index == grid.store.data.items[grid.store.data.items.length-1].data[grid.detno]){//如果选择了最后一行
  734. this.add10EmptyItems(grid);//就再加10行
  735. }
  736. } else {
  737. index = record.index + 1;
  738. if(index.toString() == 'NaN'){
  739. index = '';
  740. }
  741. if(index == grid.store.data.items[grid.store.data.items.length-1].index + 1){//如果选择了最后一行
  742. this.add10EmptyItems(grid);//就再加10行
  743. }
  744. }
  745. // var btn = grid.down('erpDeleteButton');
  746. // btn.setDisabled(false);
  747. },
  748. deleteDetailForEditGrid:function(btn){
  749. var grid = btn.ownerCt.ownerCt;
  750. var records = grid.selModel.getSelection();
  751. if(records.length > 0){
  752. if(grid.keyField){
  753. if(records[0].data[grid.keyField] != null && records[0].data[grid.keyField] > 0){
  754. warnMsg($I18N.common.msg.ask_del, function(btn){
  755. if(btn == 'yes'){
  756. grid.BaseUtil.getActiveTab().setLoading(true);//loading...
  757. Ext.Ajax.request({
  758. url : basePath + "common/deleteDetail.action",
  759. params: {
  760. caller: caller,
  761. condition: grid.keyField + "=" + records[0].data[grid.keyField]
  762. },
  763. method : 'post',
  764. callback : function(options,success,response){
  765. grid.BaseUtil.getActiveTab().setLoading(false);
  766. var localJson = new Ext.decode(response.responseText);
  767. if(localJson.exceptionInfo){
  768. showError(localJson.exceptionInfo);return;
  769. }
  770. if(localJson.success){
  771. grid.store.remove(records[0]);
  772. delSuccess(function(){
  773. });//@i18n/i18n.js
  774. } else {
  775. delFailure();
  776. }
  777. }
  778. });
  779. }
  780. });
  781. } else {
  782. grid.store.remove(records[0]);
  783. }
  784. } else {
  785. if(records[0].data[grid.keyField] != null && records[0].data[grid.keyField] > 0){
  786. showError("grid未配置keyField,无法删除该行数据!");
  787. } else {
  788. grid.store.remove(records[0]);
  789. }
  790. }
  791. }
  792. },
  793. onSave: function(grid, saveUrl){
  794. var me = this;
  795. if(grid){
  796. var param = me.getGridStore();
  797. if(grid.necessaryField.length > 0 && (param == null || param == '')){
  798. showError('明细表还未添加数据');return;
  799. } else {
  800. var url = saveUrl || grid.saveUrl || Ext.getCmp('form').saveUrl;
  801. me.getActiveTab().setLoading(true);//loading...
  802. Ext.Ajax.request({
  803. url : basePath + url,
  804. params : {
  805. param: unescape(param.toString().replace(/\\/g,"%"))
  806. },
  807. method : 'post',
  808. callback : function(options,success,response){
  809. me.getActiveTab().setLoading(false);
  810. var localJson = new Ext.decode(response.responseText);
  811. if(localJson.success){
  812. saveSuccess(function(){
  813. //add成功后刷新grid
  814. me.loadNewStore(grid, {
  815. caller: caller,
  816. condition: grid.mainField + '=' + Ext.getCmp(Ext.getCmp('form').keyField).value
  817. });
  818. });
  819. } else if(localJson.exceptionInfo){
  820. var str = localJson.exceptionInfo;
  821. if(str.trim().substr(0, 12) == 'AFTERSUCCESS'){
  822. str = str.replace('AFTERSUCCESS', '');
  823. saveSuccess(function(){
  824. //add成功后刷新grid
  825. me.loadNewStore(grid, {
  826. caller: caller,
  827. condition: grid.mainField + '=' + Ext.getCmp(Ext.getCmp('form').keyField).value
  828. });
  829. });
  830. showError(str);
  831. } else {
  832. showError(str);
  833. return;
  834. }
  835. } else{
  836. saveFailure();//@i18n/i18n.js
  837. }
  838. }
  839. });
  840. }
  841. }
  842. },
  843. onUpdate: function(grid, updateUrl){
  844. var me = this;
  845. if(grid){
  846. var param = me.getGridStore();
  847. if(grid.necessaryField.length > 0 && (param == null || param == '')){
  848. showError('明细表还未添加数据');return;
  849. } else {
  850. var url = updateUrl || grid.updateUrl || Ext.getCmp('form').updateUrl;
  851. me.getActiveTab().setLoading(true);//loading...
  852. Ext.Ajax.request({
  853. url : basePath + url,
  854. params : {
  855. param: unescape(param.toString().replace(/\\/g,"%"))
  856. },
  857. method : 'post',
  858. callback : function(options,success,response){
  859. me.getActiveTab().setLoading(false);
  860. var localJson = new Ext.decode(response.responseText);
  861. if(localJson.success){
  862. updateSuccess(function(){
  863. //add成功后刷新grid
  864. me.loadNewStore(grid, {
  865. caller: caller,
  866. condition: grid.mainField + '=' + Ext.getCmp(Ext.getCmp('form').keyField).value
  867. });
  868. });
  869. } else if(localJson.exceptionInfo){
  870. var str = localJson.exceptionInfo;
  871. if(str.trim().substr(0, 12) == 'AFTERSUCCESS'){
  872. str = str.replace('AFTERSUCCESS', '');
  873. updateSuccess(function(){
  874. //add成功后刷新grid
  875. me.loadNewStore(grid, {
  876. caller: caller,
  877. condition: grid.mainField + '=' + Ext.getCmp(Ext.getCmp('form').keyField).value
  878. });
  879. });
  880. showError(str);
  881. } else {
  882. showError(str);
  883. return;
  884. }
  885. } else{
  886. saveFailure();//@i18n/i18n.js
  887. }
  888. }
  889. });
  890. }
  891. }
  892. },
  893. getActiveTab: function(){
  894. var tab = null;
  895. if(Ext.getCmp("content-panel")){
  896. tab = Ext.getCmp("content-panel").getActiveTab();
  897. }
  898. if(!tab && parent.Ext.getCmp("content-panel"))
  899. tab = parent.Ext.getCmp("content-panel").getActiveTab();
  900. if(!tab && parent.parent.Ext.getCmp("content-panel"))
  901. tab = parent.parent.Ext.getCmp("content-panel").getActiveTab();
  902. if(!tab){
  903. var win = parent.Ext.ComponentQuery.query('window');
  904. if(win.length > 0){
  905. tab = win[win.length-1];
  906. }
  907. }
  908. return tab;
  909. }
  910. });