MultiGrid.js 14 KB

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