MultiGrid.js 14 KB

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