MultiGrid.js 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427
  1. Ext.QuickTips.init();
  2. Ext.define('erp.controller.ma.MultiGrid', {
  3. extend: 'Ext.app.Controller',
  4. requires: ['erp.util.FormUtil', 'erp.util.GridUtil'],
  5. views:[
  6. 'ma.MultiGrid','ma.MyForm','ma.MyGrid','ma.MyDetail','core.button.DeleteDetail','core.toolbar.Toolbar',
  7. 'core.trigger.DbfindTrigger','core.trigger.MultiDbfindTrigger','core.grid.TfColumn','core.grid.YnColumn',
  8. 'core.button.UUListener', 'core.button.DbfindButton','core.button.ComboButton', 'core.form.YnField'
  9. ],
  10. init:function(){
  11. var me = this;
  12. me.FormUtil = Ext.create('erp.util.FormUtil');
  13. me.GridUtil = Ext.create('erp.util.GridUtil');
  14. this.control({
  15. 'multidbfindtrigger': {
  16. render: function(field){
  17. if(field.name == 'fo_button4add' || field.name == 'fo_button4rw'){
  18. var fields = Ext.Object.getKeys($I18N.common.button);
  19. var values = Ext.Object.getValues($I18N.common.button);
  20. var data = [];
  21. Ext.each(fields, function(f, index){
  22. var o = {};
  23. o.value = fields[index];
  24. o.display = values[index];
  25. data.push(o);
  26. });
  27. field.multistore = {fields:['display', 'value'],data:data};
  28. }
  29. }
  30. },
  31. 'mygrid': {
  32. select: function(selModel, record){
  33. this.GridUtil.onGridItemClick(selModel, record);
  34. var grid = selModel.view.findParentByType('mygrid');
  35. if(record&&record.data.fd_dbfind)
  36. grid.down('erpDbfindButton').setDisabled(false);
  37. else if(record && record.data.fd_type == 'C')
  38. grid.down('erpComboButton').setDisabled(false);
  39. else {
  40. grid.down('erpComboButton').setDisabled(true);
  41. grid.down('erpDbfindButton').setDisabled(true);
  42. }
  43. }
  44. },
  45. 'mydetail': {
  46. select: function(selModel, record){
  47. this.GridUtil.onGridItemClick(selModel, record, 'detail');
  48. var grid = selModel.view.findParentByType('mydetail');
  49. if(record&&record.data.dg_dbbutton)
  50. grid.down('erpDbfindButton').setDisabled(false);
  51. else if(record && record.data.dg_type == 'combo')
  52. grid.down('erpComboButton').setDisabled(false);
  53. else {
  54. grid.down('erpComboButton').setDisabled(true);
  55. grid.down('erpDbfindButton').setDisabled(true);
  56. }
  57. }
  58. },
  59. 'button[name=save]': {
  60. click: function(btn){
  61. //序列号
  62. if(Ext.getCmp('fo_seq')) {
  63. Ext.getCmp('fo_seq').setValue(Ext.getCmp('fo_table').value.toUpperCase().split(' ')[0] + '_SEQ');
  64. }
  65. var dt = Ext.getCmp('fo_detailtable');
  66. if(dt != null && dt.value != null && dt.value != ''){
  67. Ext.getCmp('fo_detailseq').setValue(dt.value.toUpperCase().split(' ')[0] + '_SEQ');
  68. }
  69. var grid = btn.ownerCt.ownerCt;
  70. if(Ext.getCmp('fo_table')) {
  71. var val = Ext.getCmp('fo_table').value.toUpperCase().split(' ')[0];
  72. Ext.Array.each(grid.store.data.items, function(item){
  73. if(item.data['fd_field'] != null && item.data['fd_field'] != ''){
  74. if(item.data['fd_table'].toUpperCase() != val) {
  75. item.set('fd_table', val);
  76. }
  77. }
  78. });
  79. }
  80. //判断detailtable的主键字段是否加到了detailgrid里面
  81. //me.insertKeyField();
  82. //判断detailtable与主表关联的字段是否加到了detailgrid里面
  83. //me.insertMainField();
  84. me.save();
  85. }
  86. },
  87. 'erpDeleteDetailButton': {
  88. afterrender: function(btn){
  89. btn.ownerCt.add({
  90. xtype:'erpDbfindButton',
  91. });
  92. btn.ownerCt.add({
  93. xtype:'erpComboButton',
  94. });
  95. }
  96. },
  97. /**
  98. * 下拉框设置
  99. */
  100. 'erpComboButton': {
  101. click: function(btn){
  102. var activeTab = btn.up('tabpanel').getActiveTab();
  103. var record = activeTab.down('gridpanel').selModel.lastSelected;
  104. if(record) {
  105. if(activeTab.id == 'maintab'){
  106. if(record.data.fd_type == 'C') {
  107. btn.comboSet(Ext.getCmp('fo_caller').value, record.data.fd_field);
  108. }
  109. } else {
  110. if(record.data.dg_type == 'combo')
  111. btn.comboSet(Ext.getCmp('fo_caller').value, record.data.dg_field);
  112. }
  113. }
  114. }
  115. },
  116. /**
  117. * DBFind设置
  118. */
  119. 'erpDbfindButton': {
  120. click: function(btn){
  121. var activeTab = btn.up('tabpanel').getActiveTab();
  122. var record = activeTab.down('gridpanel').selModel.lastSelected;
  123. if(record) {
  124. if(activeTab.id == 'maintab'){
  125. if(record.data.fd_dbfind)
  126. btn.dbfindSetUI(Ext.getCmp('fo_caller').value, record.data.fd_field);
  127. }else {
  128. if(record.data.dg_dbbutton)
  129. btn.dbfindSetGrid(Ext.getCmp('fo_caller').value, activeTab.down('gridpanel'), record.data.dg_field);
  130. }
  131. }
  132. }
  133. },
  134. 'button[name=delete]': {
  135. click: function(btn){
  136. me.FormUtil.onDelete(Ext.getCmp('fo_id').value);
  137. }
  138. },
  139. 'button[name=close]': {
  140. click: function(btn){
  141. me.FormUtil.beforeClose(me);
  142. }
  143. },
  144. 'textfield[name=fo_detailtable]': {
  145. change: function(field){
  146. var grid = Ext.getCmp('detail');
  147. if(grid) {
  148. var val = field.value.toUpperCase().split(' ')[0];
  149. Ext.each(grid.store.items, function(){
  150. var t = this.data['dg_table'];
  151. if(t != null && t != ''){
  152. if(val != t.toUpperCase()){
  153. this.set('dg_table', val);
  154. }
  155. }
  156. });
  157. }
  158. }
  159. },
  160. 'panel[id=detailtab]': {
  161. activate: function(){
  162. // var dt = Ext.getCmp('fo_detailtable').value;
  163. // if(dt == null || dt == ''){
  164. // showError("[主表]->[从表资料]->[明细表名]还未填写!");
  165. // Ext.getCmp('mytab').setActiveTab(0);
  166. // } else {
  167. // //判断detailtable的主键字段是否加到了detailgrid里面
  168. // me.insertKeyField();
  169. // //判断detailtable与主表关联的字段是否加到了detailgrid里面
  170. // me.insertMainField();
  171. // }
  172. }
  173. },
  174. 'dbfindtrigger[name=fo_keyfield]': {
  175. afterrender: function(t){
  176. t.autoDbfind = false;
  177. t.dbKey = "fo_table";
  178. t.mappingKey = "ddd_tablename";
  179. t.dbMessage = "请先选择表名!";
  180. }
  181. },
  182. 'dbfindtrigger[name=fo_codefield]': {
  183. afterrender: function(t){
  184. t.autoDbfind = false;
  185. t.dbKey = "fo_table";
  186. t.mappingKey = "ddd_tablename";
  187. t.dbMessage = "请先选择表名!";
  188. }
  189. },
  190. 'dbfindtrigger[name=fo_statusfield]': {
  191. afterrender: function(t){
  192. t.autoDbfind = false;
  193. t.dbKey = "fo_table";
  194. t.mappingKey = "ddd_tablename";
  195. t.dbMessage = "请先选择表名!";
  196. }
  197. },
  198. 'dbfindtrigger[name=fo_statuscodefield]': {
  199. afterrender: function(t){
  200. t.autoDbfind = false;
  201. t.dbKey = "fo_table";
  202. t.mappingKey = "ddd_tablename";
  203. t.dbMessage = "请先选择表名!";
  204. }
  205. },
  206. 'dbfindtrigger[name=fo_detailkeyfield]': {
  207. afterrender: function(t){
  208. t.autoDbfind = false;
  209. t.dbKey = "fo_detailtable";
  210. t.mappingKey = "ddd_tablename";
  211. t.dbMessage = "请先选择从表名!";
  212. }
  213. },
  214. 'dbfindtrigger[name=fo_detailmainkeyfield]': {
  215. afterrender: function(t){
  216. t.autoDbfind = false;
  217. t.dbKey = "fo_detailtable";
  218. t.mappingKey = "ddd_tablename";
  219. t.dbMessage = "请先选择从表名!";
  220. }
  221. },
  222. 'dbfindtrigger[name=fo_detailstatuscode]': {
  223. afterrender: function(t){
  224. t.autoDbfind = false;
  225. t.dbKey = "fo_detailtable";
  226. t.mappingKey = "ddd_tablename";
  227. t.dbMessage = "请先选择从表名!";
  228. }
  229. },
  230. 'dbfindtrigger[name=fo_detailstatus]': {
  231. afterrender: function(t){
  232. t.autoDbfind = false;
  233. t.dbKey = "fo_detailtable";
  234. t.mappingKey = "ddd_tablename";
  235. t.dbMessage = "请先选择从表名!";
  236. }
  237. },
  238. 'dbfindtrigger[name=fo_detaildetnofield]': {
  239. afterrender: function(t){
  240. t.autoDbfind = false;
  241. t.dbKey = "fo_detailtable";
  242. t.mappingKey = "ddd_tablename";
  243. t.dbMessage = "请先选择从表名!";
  244. }
  245. },
  246. 'button[name=preview]': {
  247. click: function(){
  248. }
  249. }
  250. });
  251. },
  252. insertKeyField: function(){
  253. var grid = Ext.getCmp('detail');
  254. var field = Ext.getCmp('fo_detailkeyfield');
  255. var count = 0;
  256. Ext.each(grid.store.data.items, function(){
  257. var logic = this.data['dg_logictype'];
  258. var t = this.data['dg_field'];
  259. if(field.value.toUpperCase() == t.toUpperCase()){
  260. this.set('dg_logictype', 'keyField');
  261. logic = 'keyField';
  262. if(count >= 2){
  263. if(this.data['dg_id'] == null || this.data['dg_id'] == ''){
  264. grid.store.remove(this);
  265. }
  266. }
  267. }
  268. if(logic == 'keyField'){
  269. count++;
  270. if(count < 2 && field.value.toUpperCase() != t.toUpperCase()){
  271. this.set('dg_field', field.value);
  272. }
  273. if(count >= 2){
  274. if(this.data['dg_id'] == null || this.data['dg_id'] == ''){
  275. grid.store.remove(this);
  276. }
  277. }
  278. }
  279. });
  280. if(count == 0){
  281. grid.store.add({
  282. dg_sequence: grid.store.data.items[grid.store.data.length-1].data['dg_sequence'] + 1,
  283. dg_logictype: 'keyField',
  284. dg_field: field.value,
  285. dg_caption: 'ID',
  286. dg_table: Ext.getCmp('fo_detailtable').value,
  287. dg_caller: Ext.getCmp('fo_caller').value,
  288. dg_width: 0,
  289. dg_check: 0,
  290. dg_visible: '0',
  291. dg_type: 'numbercolumn',
  292. dg_editable: '0',
  293. dg_dbbutton: '0'
  294. });
  295. } else if(count > 1){
  296. showError("您的从表中有" + count + "个逻辑类型为[主键字段]的字段,请仔细核查!");
  297. }
  298. },
  299. insertMainField: function(){
  300. var grid = Ext.getCmp('detail');
  301. var field = Ext.getCmp('fo_detailmainkeyfield');
  302. var count = 0;
  303. Ext.each(grid.store.data.items, function(){
  304. var logic = this.data['dg_logictype'];
  305. var t = this.data['dg_field'];
  306. if(field.value.toUpperCase() == t.toUpperCase()){
  307. this.set('dg_logictype', 'mainField');
  308. logic = 'mainField';
  309. if(count >= 2){
  310. if(this.data['dg_id'] == null || this.data['dg_id'] == ''){
  311. grid.store.remove(this);
  312. }
  313. }
  314. }
  315. if(logic == 'mainField'){
  316. count++;
  317. if(count < 2 && field.value.toUpperCase() != t.toUpperCase()){
  318. this.set('dg_field', field.value);
  319. }
  320. if(count >= 2){
  321. if(this.data['dg_id'] == null || this.data['dg_id'] == ''){
  322. grid.store.remove(this);
  323. }
  324. }
  325. }
  326. });
  327. if(count == 0){
  328. grid.store.add({
  329. dg_sequence: grid.store.data.items[grid.store.data.length-1].data['dg_sequence'] + 1,
  330. dg_logictype: 'mainField',
  331. dg_field: field.value,
  332. dg_caption: 'MainID',
  333. dg_table: Ext.getCmp('fo_detailtable').value,
  334. dg_caller: Ext.getCmp('fo_caller').value,
  335. dg_width: 0,
  336. dg_check: 0,
  337. dg_visible: '0',
  338. dg_type: 'text',
  339. dg_editable: '0',
  340. dg_dbbutton: '0'
  341. });
  342. } else if(count > 1){
  343. showError("您的从表中有" + count + "个逻辑类型为[关联主表字段]的字段,请仔细核查!");
  344. }
  345. },
  346. createPreForm: function(){
  347. var form = Ext.create('Ext.form.Panel', {
  348. });
  349. },
  350. createPreGrid: function(){
  351. },
  352. createFormItem: function(record){
  353. },
  354. save: function(){
  355. var form = Ext.getCmp('form');
  356. var me = this;
  357. if(form && ! me.FormUtil.checkForm()){
  358. return;
  359. }
  360. var grids = Ext.ComponentQuery.query('mygrid'), grid;
  361. if(grids.length > 0) {
  362. var grid = grids[0];
  363. if(form) {
  364. var field = Ext.getCmp('fo_table'), val = field.value.split(' ')[0];
  365. grid.store.each(function(item){
  366. if(item.data['fd_field'] != null && item.data['fd_field'] != '' && Ext.isEmpty('fd_table')){
  367. item.set('fd_table', val);
  368. }
  369. });
  370. }
  371. }
  372. var details = Ext.ComponentQuery.query('mydetail'), detail;
  373. if(details.length > 0) {
  374. var detail = details[0];
  375. if(form) {
  376. var field = Ext.getCmp('fo_detailtable'), val = field.value.split(' ')[0];
  377. detail.store.each(function(item){
  378. if(item.data['dg_field'] != null && item.data['dg_field'] != '' && Ext.isEmpty('dg_table')){
  379. item.set('dg_table', val);
  380. }
  381. });
  382. }
  383. }
  384. var dd = grid ? grid.getChange() : {},de = detail ? detail.getChange() : {};
  385. me.onSave(form ? Ext.encode(form.getValues()) : null, Ext.encode(dd.added || []),
  386. Ext.encode(dd.updated || []), Ext.encode(dd.deleted || []), Ext.encode(de.added || []),
  387. Ext.encode(de.updated || []), Ext.encode(de.deleted || []));
  388. },
  389. onSave: function(formData, formAdded, formUpdated, formDeleted, gridAdded, gridUpdated, gridDeleted){
  390. var me = this;
  391. me.FormUtil.setLoading(true);
  392. Ext.Ajax.request({
  393. url : basePath + 'ma/updateMultiForm.action',
  394. params: {
  395. formData: formData,
  396. formAdded: formAdded,
  397. formUpdated: formUpdated,
  398. formDeleted: formDeleted,
  399. gridAdded: gridAdded,
  400. gridUpdated: gridUpdated,
  401. gridDeleted: gridDeleted
  402. },
  403. method : 'post',
  404. callback : function(opt, s, res){
  405. me.FormUtil.setLoading(false);
  406. var rs = new Ext.decode(res.responseText);
  407. if(rs.success){
  408. showMessage('提示', '保存成功!', 1000);
  409. window.location.reload();
  410. } else if(rs.exceptionInfo){
  411. var str = rs.exceptionInfo;
  412. if(str.trim().substr(0, 12) == 'AFTERSUCCESS'){
  413. str = str.replace('AFTERSUCCESS', '');
  414. window.location.reload();
  415. }
  416. showError(str);return;
  417. } else {
  418. showMessage('提示', '保存失败!');
  419. }
  420. }
  421. });
  422. }
  423. });