FormPanel.js 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582
  1. Ext.define('saas.view.money.verification.FormPanel', {
  2. extend: 'saas.view.core.form.FormPanel',
  3. // extend: 'Ext.panel.Panel',
  4. xtype: 'money-verification-formpanel',
  5. controller: 'money-verification-formpanel',
  6. viewModel: 'money-verification-formpanel',
  7. viewName: 'money-verification-formpanel',
  8. caller: 'Verification',
  9. //字段属性
  10. _title: '核销单',
  11. _idField: 'id',
  12. _codeField: 'vc_code',
  13. _statusField: 'vc_status',
  14. _statusCodeField: 'vc_statuscode',
  15. _readUrl: '/api/money/verification/read/',
  16. _saveUrl: '/api/money/verification/save/',
  17. _auditUrl: '/api/money/verification/audit/',
  18. _unAuditUrl: '/api/money/verification/unAudit/',
  19. _deleteUrl: '/api/money/verification/delete/',
  20. defatulType: 'receipts_offset_receivable',
  21. etc: {
  22. /**
  23. * 预收:receipts
  24. * 预付:prepaid
  25. * 应收:receivable
  26. * 应付:payable
  27. */
  28. // base
  29. base: [{
  30. xtype: 'combo',
  31. name: 'vc_kind',
  32. fieldLabel: '业务类型',
  33. editable: false,
  34. store: [
  35. ['receipts_offset_receivable', '预收冲应收'],
  36. ['prepaid_offset_payable', '预付冲应付'],
  37. ['receivable_offset_payable', '应收冲应付'],
  38. ['receivable_to_receivable', '应收转应收'],
  39. ['payable_to_payable', '应付转应付']
  40. ]
  41. }],
  42. detail1: {
  43. xtype: "detailGridField",
  44. storeModel: 'saas.model.money.Verification1',
  45. detnoColumn: 'vd_detno',
  46. deleteDetailUrl: '/api/money/verification/deleteDetail1/',
  47. columnWidth: 1,
  48. columns: [{
  49. text: 'ID',
  50. dataIndex: 'id',
  51. hidden: true
  52. }, {
  53. text: '来源ID',
  54. dataIndex: 'vd_slid',
  55. hidden: true
  56. }, {
  57. text: '来源单号',
  58. dataIndex: 'vd_slcode',
  59. width: 150,
  60. editor:{
  61. displayField : "display",
  62. editable : true,
  63. format : "",
  64. hideTrigger : false,
  65. maxLength : 100.0,
  66. minValue : null,
  67. positiveNum : false,
  68. queryMode : "local",
  69. store : null,
  70. valueField : "value",
  71. xtype : "oriOrderMutiDbfindTrigger"
  72. }
  73. }, {
  74. text: '业务类型',
  75. dataIndex: "vd_slkind",
  76. width: 110
  77. }, {
  78. text: "单据日期",
  79. dataIndex: "vd_sldate",
  80. xtype: 'datecolumn',
  81. width: 110
  82. }, {
  83. text: "单据金额",
  84. xtype: 'numbercolumn',
  85. dataIndex: "vd_amount",
  86. width: 110,
  87. renderer : function(v) {
  88. var arr = (v + '.').split('.');
  89. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  90. var format = '0,000.' + xr.join();
  91. return Ext.util.Format.number(v, format);
  92. },
  93. summaryType: 'sum',
  94. summaryRenderer: function(v) {
  95. var arr = (v + '.').split('.');
  96. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  97. var format = '0,000.' + xr.join();
  98. return Ext.util.Format.number(v, format);
  99. }
  100. }, {
  101. text: "已核销金额",
  102. xtype: 'numbercolumn',
  103. dataIndex: "sl_yamount",
  104. width: 110,
  105. ignore:true,
  106. renderer : function(v) {
  107. var arr = (v + '.').split('.');
  108. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  109. var format = '0,000.' + xr.join();
  110. return Ext.util.Format.number(v, format);
  111. },
  112. summaryType: 'sum',
  113. summaryRenderer: function(v) {
  114. var arr = (v + '.').split('.');
  115. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  116. var format = '0,000.' + xr.join();
  117. return Ext.util.Format.number(v, format);
  118. }
  119. }, {
  120. text: "未核销金额",
  121. xtype: 'numbercolumn',
  122. dataIndex: "sl_namount",
  123. width: 110,
  124. ignore:true,
  125. renderer : function(v) {
  126. var arr = (v + '.').split('.');
  127. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  128. var format = '0,000.' + xr.join();
  129. return Ext.util.Format.number(v, format);
  130. },
  131. summaryType: 'sum',
  132. summaryRenderer: function(v) {
  133. var arr = (v + '.').split('.');
  134. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  135. var format = '0,000.' + xr.join();
  136. return Ext.util.Format.number(v, format);
  137. }
  138. }, {
  139. text: "本次核销金额",
  140. xtype: 'numbercolumn',
  141. dataIndex: "vd_nowbalance",
  142. width: 150,
  143. editor : {
  144. xtype : "numberfield",
  145. decimalPrecision: 2
  146. },
  147. allowBlank : false,
  148. renderer : function(v) {
  149. var arr = (v + '.').split('.');
  150. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  151. var format = '0,000.' + xr.join();
  152. return Ext.util.Format.number(v, format);
  153. },
  154. summaryType: 'sum',
  155. summaryRenderer: function(v) {
  156. var arr = (v + '.').split('.');
  157. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  158. var format = '0,000.' + xr.join();
  159. return Ext.util.Format.number(v, format);
  160. }
  161. }]
  162. },
  163. detail2: {
  164. xtype: "detailGridField",
  165. storeModel: 'saas.model.money.Verification1',
  166. detnoColumn: 'vcd_detno',
  167. deleteDetailUrl: '/api/money/verification/deleteDetail2/',
  168. columnWidth: 1,
  169. columns: [{
  170. text: 'ID',
  171. dataIndex: 'id',
  172. hidden: true
  173. }, {
  174. text: '来源ID',
  175. dataIndex: 'vcd_slid',
  176. hidden: true
  177. }, {
  178. text: '来源单号',
  179. dataIndex: 'vcd_slcode',
  180. width: 150,
  181. editor:{
  182. displayField : "display",
  183. editable : true,
  184. format : "",
  185. hideTrigger : false,
  186. maxLength : 100.0,
  187. minValue : null,
  188. positiveNum : false,
  189. queryMode : "local",
  190. store : null,
  191. valueField : "value",
  192. xtype : "oriOrderMutiDbfindTrigger"
  193. }
  194. }, {
  195. text: '业务类型',
  196. dataIndex: "vcd_slkind",
  197. width: 110
  198. }, {
  199. text: "单据日期",
  200. dataIndex: "vcd_sldate",
  201. xtype: 'datecolumn',
  202. width: 110
  203. }, {
  204. text: "单据金额",
  205. xtype: 'numbercolumn',
  206. dataIndex: "vcd_amount",
  207. width: 110,
  208. renderer : function(v) {
  209. var arr = (v + '.').split('.');
  210. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  211. var format = '0,000.' + xr.join();
  212. return Ext.util.Format.number(v, format);
  213. },
  214. summaryType: 'sum',
  215. summaryRenderer: function(v) {
  216. var arr = (v + '.').split('.');
  217. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  218. var format = '0,000.' + xr.join();
  219. return Ext.util.Format.number(v, format);
  220. }
  221. }, {
  222. text: "已核销金额",
  223. xtype: 'numbercolumn',
  224. dataIndex: "sl_yamount",
  225. width: 110,
  226. ignore:true,
  227. renderer : function(v) {
  228. var arr = (v + '.').split('.');
  229. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  230. var format = '0,000.' + xr.join();
  231. return Ext.util.Format.number(v, format);
  232. },
  233. summaryType: 'sum',
  234. summaryRenderer: function(v) {
  235. var arr = (v + '.').split('.');
  236. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  237. var format = '0,000.' + xr.join();
  238. return Ext.util.Format.number(v, format);
  239. }
  240. }, {
  241. text: "未核销金额",
  242. xtype: 'numbercolumn',
  243. dataIndex: "sl_namount",
  244. width: 110,
  245. ignore:true,
  246. renderer : function(v) {
  247. var arr = (v + '.').split('.');
  248. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  249. var format = '0,000.' + xr.join();
  250. return Ext.util.Format.number(v, format);
  251. },
  252. summaryType: 'sum',
  253. summaryRenderer: function(v) {
  254. var arr = (v + '.').split('.');
  255. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  256. var format = '0,000.' + xr.join();
  257. return Ext.util.Format.number(v, format);
  258. }
  259. }, {
  260. text: "本次核销金额",
  261. xtype: 'numbercolumn',
  262. dataIndex: "vcd_nowbalance",
  263. width:150,
  264. editor : {
  265. xtype : "numberfield",
  266. decimalPrecision: 2
  267. },
  268. allowBlank : false,
  269. renderer : function(v) {
  270. var arr = (v + '.').split('.');
  271. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  272. var format = '0,000.' + xr.join();
  273. return Ext.util.Format.number(v, format);
  274. },
  275. summaryType: 'sum',
  276. summaryRenderer: function(v) {
  277. var arr = (v + '.').split('.');
  278. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  279. var format = '0,000.' + xr.join();
  280. return Ext.util.Format.number(v, format);
  281. }
  282. }]
  283. },
  284. other: [{
  285. fieldLabel: '备注',
  286. xtype: 'textfield',
  287. columnWidth: 1,
  288. name: 'vc_remark'
  289. }],
  290. // 预收冲应收
  291. receipts_offset_receivable : {
  292. main: [{
  293. xtype: 'hidden',
  294. fieldLabel: '客户名称',
  295. name: 'vc_custid',
  296. listeners: {
  297. change: 'clearDetails'
  298. }
  299. }, {
  300. fieldLabel: '客户编号',
  301. xtype: 'hidden',
  302. name: 'vc_custcode',
  303. }, {
  304. fieldLabel: '客户名称',
  305. xtype: 'customerDbfindTrigger',
  306. name: 'vc_custname',
  307. }, {
  308. fieldLabel: '日期',
  309. xtype: 'datefield',
  310. defaultValue: new Date(),
  311. allowBlank : false,
  312. name: 'vc_date'
  313. }, {
  314. xtype: 'hidden',
  315. name: 'vc_amount1',
  316. fieldLabel: '核销金额'
  317. }, {
  318. xtype: "hidden",
  319. name: "vc_amount2",
  320. fieldLabel: "未核销金额"
  321. },],
  322. details: ['detail1', 'detail2']
  323. },
  324. // 预付冲应付
  325. prepaid_offset_payable: {
  326. main: [{
  327. xtype: 'hidden',
  328. name: 'vc_vendid',
  329. fieldLabel: '供应商名称',
  330. listeners: {
  331. change: 'clearDetails'
  332. }
  333. }, {
  334. xtype: "hidden",
  335. name: "vc_vendcode",
  336. fieldLabel: "供应商编号"
  337. }, {
  338. xtype: "vendorDbfindTrigger",
  339. name: "vc_vendname",
  340. fieldLabel: "供应商名称",
  341. allowBlank : false
  342. }, {
  343. fieldLabel: '日期',
  344. xtype: 'datefield',
  345. defaultValue: new Date(),
  346. allowBlank : false,
  347. name: 'vc_date'
  348. }],
  349. details: ['detail1', 'detail2']
  350. },
  351. // 应收冲应付
  352. receivable_offset_payable: {
  353. main: [{
  354. fieldLabel: '客户名称',
  355. xtype: 'textfield',
  356. name: 'vc_custid',
  357. hidden: true,
  358. listeners: {
  359. change: 'clearDetail0'
  360. }
  361. }, {
  362. fieldLabel: '客户编号',
  363. xtype: 'textfield',
  364. name: 'vc_custcode',
  365. hidden: true
  366. }, {
  367. fieldLabel: '客户名称',
  368. xtype: 'customerDbfindTrigger',
  369. name: 'vc_custname'
  370. }, {
  371. xtype: 'hidden',
  372. name: 'vc_vendid',
  373. fieldLabel: '供应商ID',
  374. listeners: {
  375. change: 'clearDetail1'
  376. }
  377. }, {
  378. xtype: "hidden",
  379. name: "vc_vendcode",
  380. fieldLabel: "供应商编号"
  381. }, {
  382. xtype: "vendorDbfindTrigger",
  383. name: "vc_vendname",
  384. fieldLabel: "供应商名称",
  385. allowBlank : false
  386. }, {
  387. fieldLabel: '日期',
  388. xtype: 'datefield',
  389. defaultValue: new Date(),
  390. allowBlank : false,
  391. name: 'vc_date'
  392. }],
  393. details: ['detail1', 'detail2']
  394. },
  395. // 应收转应收
  396. receivable_to_receivable: {
  397. main: [{
  398. fieldLabel: '转出客户',
  399. xtype: 'textfield',
  400. name: 'vc_outcustid',
  401. hidden: true,
  402. listeners: {
  403. change: 'clearDetail0'
  404. }
  405. }, {
  406. fieldLabel: '转出客户编号',
  407. xtype: 'textfield',
  408. name: 'vc_outcustcode',
  409. hidden: true
  410. }, {
  411. fieldLabel: '转出客户',
  412. xtype: 'customerDbfindTrigger',
  413. name: 'vc_outcustname'
  414. }, {
  415. fieldLabel: '转入客户id',
  416. xtype: 'textfield',
  417. name: 'vc_turncustid',
  418. hidden: true
  419. }, {
  420. fieldLabel: '转入客户编号',
  421. xtype: 'textfield',
  422. name: 'vc_turncustcode',
  423. hidden: true
  424. }, {
  425. fieldLabel: '转入客户',
  426. xtype: 'customerDbfindTrigger',
  427. name: 'vc_turncustname',
  428. }, {
  429. fieldLabel: '日期',
  430. xtype: 'datefield',
  431. defaultValue: new Date(),
  432. allowBlank : false,
  433. name: 'vc_date'
  434. }],
  435. details: ['detail1']
  436. },
  437. // 应付转应付
  438. payable_to_payable: {
  439. main: [{
  440. fieldLabel: '转出供应商',
  441. xtype: 'textfield',
  442. name: 'vc_outvendid',
  443. hidden: true,
  444. listeners: {
  445. change: 'clearDetail0'
  446. }
  447. }, {
  448. fieldLabel: '转出供应商编号',
  449. xtype: 'textfield',
  450. name: 'vc_outvendcode',
  451. hidden: true
  452. }, {
  453. fieldLabel: '转出供应商',
  454. xtype: 'vendorDbfindTrigger',
  455. name: 'vc_outvendname'
  456. }, {
  457. fieldLabel: '转入供应商id',
  458. xtype: 'textfield',
  459. name: 'vc_turnvendid',
  460. hidden: true
  461. }, {
  462. fieldLabel: '转入供应商编号',
  463. xtype: 'textfield',
  464. name: 'vc_turnvendcode',
  465. hidden: true
  466. }, {
  467. fieldLabel: '转入供应商',
  468. xtype: 'vendorDbfindTrigger',
  469. name: 'vc_turnvendname',
  470. }, {
  471. fieldLabel: '日期',
  472. xtype: 'datefield',
  473. defaultValue: new Date(),
  474. allowBlank : false,
  475. name: 'vc_date'
  476. }],
  477. details: ['detail1']
  478. },
  479. defaultConditions: {
  480. receipts_offset_receivable: ['ifnull(sl_custid,0)={vc_custid} and ifnull(sl_preamount,0)<>0 and ifnull(sl_namount,0)<>0',
  481. 'ifnull(sl_custid,0)={vc_custid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0 and sl_kind in (\'期初余额\',\'出货单\',\'销售退货单\')'],
  482. prepaid_offset_payable: ['ifnull(sl_vendid,0)={vc_vendid} and ifnull(sl_preamount,0)<>0 and ifnull(sl_namount,0)<>0',
  483. 'ifnull(sl_vendid,0)={vc_vendid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0'],
  484. receivable_offset_payable: ['ifnull(sl_custid,0)={vc_custid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0',
  485. 'ifnull(sl_vendid,0)={vc_vendid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0'],
  486. receivable_to_receivable: ['ifnull(sl_custid,0)={vc_outcustid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0'],
  487. payable_to_payable: ['ifnull(sl_vendtid,0)={vc_outvendid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0']
  488. }
  489. },
  490. // initComponent: function() {
  491. // this.callParent(arguments);
  492. // },
  493. initFormItems: function() {
  494. var me = this,
  495. cusItems = me.cusItems,
  496. defaultItems = me.getAcitveItems(),
  497. FormUtil = saas.util.FormUtil;
  498. me.detailCount = 0;
  499. if(cusItems) {
  500. var items = defaultItems || [];
  501. Ext.Array.each(cusItems, function(cusItem) {
  502. var item = items.find(function(item) {
  503. return item.name == cusItem.name;
  504. });
  505. Ext.apply(item, cusItem);
  506. });
  507. items = FormUtil.applyDefaultItems(me, items);
  508. me.removeAll();
  509. me.addItems(items);
  510. FormUtil.loadData(me);
  511. }else {
  512. FormUtil.applyCusItemConfig(me)
  513. .then(function(res) {
  514. if(res.success) {
  515. var config = res.data || true, items = defaultItems || [];
  516. if(config) {
  517. cusItems = config.items || [];
  518. me.cusItems = cusItems;
  519. Ext.Array.each(cusItems, function(cusItem) {
  520. var item = items.find(function(item) {
  521. return item.name == cusItem.name;
  522. });
  523. Ext.apply(item, cusItem);
  524. });
  525. items = FormUtil.applyDefaultItems(me, items);
  526. }
  527. me.removeAll();
  528. return me.addItems(items);
  529. }
  530. })
  531. .then(function(items) {
  532. me.fireEvent('afterSetItems', me, items);
  533. })
  534. .then(function() {
  535. FormUtil.loadData(me);
  536. })
  537. .catch(function(response) {
  538. saas.util.BaseUtil.showToast('错误:' + response.message);
  539. console.error(response);
  540. });
  541. }
  542. },
  543. getAcitveItems: function() {
  544. var me = this,
  545. acitveType = me.acitveType || me.defatulType,
  546. etc = me.etc,
  547. acitveEtc = etc[acitveType],
  548. mainItems = acitveEtc.main,
  549. details = acitveEtc.details,
  550. base = etc.base,
  551. detail1 = etc.detail1,
  552. detail2 = etc.detail2,
  553. other = etc.other,
  554. items = [];
  555. base[0].defaultValue = acitveType;
  556. items = Ext.Array.merge(base, mainItems, (details[0] ? [detail1] : []), (details[1] ? [detail2] : []), other );
  557. return items;
  558. },
  559. });