FormPanel.js 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786
  1. Ext.define('saas.view.money.verification.FormPanel', {
  2. extend: 'saas.view.core.form.FormPanel',
  3. xtype: 'money-verification-formpanel',
  4. controller: 'money-verification-formpanel',
  5. viewModel: 'money-verification-formpanel',
  6. viewName: 'money-verification-formpanel',
  7. caller: 'Verification',
  8. //字段属性
  9. _title: '核销单',
  10. _idField: 'id',
  11. _codeField: 'vc_code',
  12. _statusField: 'vc_status',
  13. _statusCodeField: 'vc_statuscode',
  14. _auditmanField: 'vc_auditman',
  15. _auditdateField: 'vc_auditdate',
  16. _readUrl: '/api/money/verification/read',
  17. _saveUrl: '/api/money/verification/save',
  18. _auditUrl: '/api/money/verification/audit',
  19. _unAuditUrl: '/api/money/verification/unAudit',
  20. _deleteUrl: '/api/money/verification/delete',
  21. defatulType: 'receipts_offset_receivable',
  22. initComponent: function () {
  23. this.initEtcConfig();
  24. this.callParent(arguments);
  25. },
  26. initFormItems: function () {
  27. this.initEtcConfig();
  28. var me = this,
  29. defaultItems = me.getAcitveItems(),
  30. FormUtil = saas.util.FormUtil;
  31. me.defaultItems = Ext.Array.clone(defaultItems);
  32. me.detailCount = 0;
  33. saas.util.ViewUtil.getViewConfig(me.viewName)
  34. .then(function (cfg) {
  35. let items = defaultItems || [];
  36. me.cusCfg = cfg;
  37. items = FormUtil.initItems(items);
  38. items = FormUtil.applyCusMainItemConfig(items, cfg);
  39. items = FormUtil.applyCusDetailItemConfig(items, cfg);
  40. me.configItems = items;
  41. items = FormUtil.applyDefaultItems(me, items);
  42. me.removeAll();
  43. return me.addItems(items);
  44. })
  45. .then(function (items) {
  46. me.fireEvent('afterSetItems', me, items);
  47. })
  48. .then(function () {
  49. FormUtil.loadData(me);
  50. })
  51. },
  52. getAcitveItems: function () {
  53. var me = this,
  54. acitveType = me.acitveType || me.defatulType,
  55. etc = me.etc,
  56. acitveEtc = etc[acitveType],
  57. mainItems = acitveEtc.main,
  58. details = acitveEtc.details,
  59. base = etc.base,
  60. detail1 = etc.detail1,
  61. detail2 = etc.detail2,
  62. other = etc.other,
  63. items = [];
  64. base[0].defaultValue = acitveType;
  65. items = Ext.Array.merge(base, mainItems, (details[0] ? [detail1] : []), (details[1] ? [detail2] : []), other);
  66. me.viewName = 'money-verification-formpanel-' + acitveType;
  67. return items;
  68. },
  69. listeners: {
  70. afterSetItems: function (form) {
  71. var viewModel = form.getViewModel();
  72. var init_vc_kind = form.init_vc_kind;
  73. if (init_vc_kind) {
  74. viewModel.set('vc_kind', init_vc_kind);
  75. form.init_vc_kind = null;
  76. }
  77. }
  78. },
  79. initEtcConfig: function () {
  80. Ext.apply(this, {
  81. etc: {
  82. /**
  83. * 预收:receipts
  84. * 预付:prepaid
  85. * 应收:receivable
  86. * 应付:payable
  87. */
  88. // base
  89. base: [{
  90. xtype: 'combo',
  91. name: 'vc_kind',
  92. fieldLabel: '业务类型',
  93. allowBlank: false,
  94. editable: false,
  95. store: [
  96. ['receipts_offset_receivable', '预收冲应收'],
  97. ['prepaid_offset_payable', '预付冲应付'],
  98. ['receivable_offset_payable', '应收冲应付'],
  99. ['receivable_to_receivable', '应收转应收'],
  100. ['payable_to_payable', '应付转应付']
  101. ],
  102. listeners: {
  103. beforerender: function (f) {
  104. f.firstLoad = true;
  105. if (f.ownerCt.initId != 0) {
  106. f.setReadOnly(true);
  107. f.setDisabled(true);
  108. }
  109. }
  110. }
  111. }],
  112. detail1: {
  113. xtype: "detailGridField",
  114. name: 'detail1',
  115. storeModel: 'saas.model.money.Verification1',
  116. detnoColumn: 'vd_detno',
  117. deleteDetailUrl: '/api/money/verification/deleteDetail1',
  118. columnWidth: 1,
  119. columns: [{
  120. text: 'ID',
  121. dataIndex: 'id',
  122. hidden: true
  123. }, {
  124. text: '来源ID',
  125. dataIndex: 'vd_slid',
  126. hidden: true
  127. }, {
  128. text: '来源单号',
  129. dataIndex: 'vd_slcode',
  130. width: 150,
  131. allowBlank: false,
  132. editor: {
  133. displayField: "display",
  134. editable: true,
  135. format: "",
  136. hideTrigger: false,
  137. maxLength: 100.0,
  138. minValue: null,
  139. positiveNum: false,
  140. queryMode: "local",
  141. store: null,
  142. valueField: "value",
  143. xtype: "oriOrderMutiDbfindTrigger"
  144. }
  145. }, {
  146. text: '业务类型',
  147. dataIndex: "vd_slkind",
  148. width: 110
  149. }, {
  150. text: "单据日期",
  151. dataIndex: "vd_sldate",
  152. xtype: 'datecolumn',
  153. width: 110
  154. }, {
  155. text: "单据金额(元)",
  156. xtype: 'numbercolumn',
  157. dataIndex: "vd_amount",
  158. width: 110,
  159. renderer: function (v) {
  160. return saas.util.BaseUtil.numberFormat(v, 2, true);
  161. },
  162. summaryType: 'sum',
  163. summaryRenderer: function(v, d, f, m) {
  164. return saas.util.BaseUtil.numberFormat(v, 2, true);
  165. }
  166. }, {
  167. text: "已核销金额(元)",
  168. xtype: 'numbercolumn',
  169. dataIndex: "sl_yamount",
  170. width: 120,
  171. ignore: true,
  172. renderer: function (v) {
  173. return saas.util.BaseUtil.numberFormat(v, 2, true);
  174. },
  175. summaryType: 'sum',
  176. summaryRenderer: function(v, d, f, m) {
  177. return saas.util.BaseUtil.numberFormat(v, 2, true);
  178. }
  179. }, {
  180. text: "未核销金额(元)",
  181. xtype: 'numbercolumn',
  182. dataIndex: "sl_namount",
  183. width: 120,
  184. ignore: true,
  185. renderer: function (v) {
  186. return saas.util.BaseUtil.numberFormat(v, 2, true);
  187. },
  188. summaryType: 'sum',
  189. summaryRenderer: function(v, d, f, m) {
  190. return saas.util.BaseUtil.numberFormat(v, 2, true);
  191. }
  192. }, {
  193. text: "本次核销金额(元)",
  194. xtype: 'numbercolumn',
  195. dataIndex: "vd_nowbalance",
  196. width: 150,
  197. editor: {
  198. xtype: "numberfield",
  199. decimalPrecision: 2
  200. },
  201. allowBlank: false,
  202. renderer: function (v) {
  203. return saas.util.BaseUtil.numberFormat(v, 2, true);
  204. },
  205. summaryType: 'sum',
  206. summaryRenderer: function(v, d, f, m) {
  207. return saas.util.BaseUtil.numberFormat(v, 2, true);
  208. }
  209. }, {
  210. dataIndex: "vd_text1",
  211. text: "自定义字段1",
  212. width: 100,
  213. hidden: true,
  214. initHidden: false,
  215. editor: {
  216. xtype: "textfield"
  217. },
  218. }, {
  219. dataIndex: "vd_text2",
  220. text: "自定义字段2",
  221. width: 100,
  222. hidden: true,
  223. initHidden: false,
  224. editor: {
  225. xtype: "textfield"
  226. },
  227. }, {
  228. dataIndex: "vd_text3",
  229. text: "自定义字段3",
  230. width: 100,
  231. hidden: true,
  232. initHidden: false,
  233. editor: {
  234. xtype: "textfield"
  235. },
  236. }, {
  237. dataIndex: "vd_text4",
  238. text: "自定义字段4",
  239. width: 100,
  240. hidden: true,
  241. initHidden: false,
  242. editor: {
  243. xtype: "textfield"
  244. },
  245. }, {
  246. dataIndex: "vd_text5",
  247. text: "自定义字段5",
  248. width: 100,
  249. hidden: true,
  250. initHidden: false,
  251. editor: {
  252. xtype: "textfield"
  253. },
  254. }]
  255. },
  256. detail2: {
  257. xtype: "detailGridField",
  258. name: 'detail2',
  259. storeModel: 'saas.model.money.Verification2',
  260. detnoColumn: 'vcd_detno',
  261. deleteDetailUrl: '/api/money/verification/deleteDetail2',
  262. columnWidth: 1,
  263. columns: [{
  264. text: 'ID',
  265. dataIndex: 'id',
  266. hidden: true
  267. }, {
  268. text: '来源ID',
  269. dataIndex: 'vcd_slid',
  270. hidden: true
  271. }, {
  272. text: '来源单号',
  273. dataIndex: 'vcd_slcode',
  274. width: 150,
  275. allowBlank: false,
  276. editor: {
  277. displayField: "display",
  278. editable: true,
  279. format: "",
  280. hideTrigger: false,
  281. maxLength: 100.0,
  282. minValue: null,
  283. positiveNum: false,
  284. queryMode: "local",
  285. store: null,
  286. valueField: "value",
  287. xtype: "oriOrderMutiDbfindTrigger"
  288. }
  289. }, {
  290. text: '业务类型',
  291. dataIndex: "vcd_slkind",
  292. width: 110
  293. }, {
  294. text: "单据日期",
  295. dataIndex: "vcd_sldate",
  296. xtype: 'datecolumn',
  297. width: 110
  298. }, {
  299. text: "单据金额(元)",
  300. xtype: 'numbercolumn',
  301. dataIndex: "vcd_amount",
  302. width: 110,
  303. renderer: function (v) {
  304. return saas.util.BaseUtil.numberFormat(v, 2, true);
  305. },
  306. summaryType: 'sum',
  307. summaryRenderer: function(v, d, f, m) {
  308. return saas.util.BaseUtil.numberFormat(v, 2, true);
  309. }
  310. }, {
  311. text: "已核销金额(元)",
  312. xtype: 'numbercolumn',
  313. dataIndex: "sl_yamount",
  314. width: 120,
  315. ignore: true,
  316. renderer: function (v) {
  317. return saas.util.BaseUtil.numberFormat(v, 2, true);
  318. },
  319. summaryType: 'sum',
  320. summaryRenderer: function(v, d, f, m) {
  321. return saas.util.BaseUtil.numberFormat(v, 2, true);
  322. }
  323. }, {
  324. text: "未核销金额(元)",
  325. xtype: 'numbercolumn',
  326. dataIndex: "sl_namount",
  327. width: 120,
  328. ignore: true,
  329. renderer: function (v) {
  330. return saas.util.BaseUtil.numberFormat(v, 2, true);
  331. },
  332. summaryType: 'sum',
  333. summaryRenderer: function(v, d, f, m) {
  334. return saas.util.BaseUtil.numberFormat(v, 2, true);
  335. }
  336. }, {
  337. text: "本次核销金额(元)",
  338. dataIndex: "vcd_nowbalance",
  339. xtype: 'numbercolumn',
  340. width: 150,
  341. allowBlank: false,
  342. editor: {
  343. xtype: "numberfield",
  344. decimalPrecision: 2
  345. },
  346. renderer: function (v) {
  347. return saas.util.BaseUtil.numberFormat(v, 2, true);
  348. },
  349. summaryType: 'sum',
  350. summaryRenderer: function(v, d, f, m) {
  351. return saas.util.BaseUtil.numberFormat(v, 2, true);
  352. }
  353. }, {
  354. dataIndex: "vcdtext1",
  355. text: "自定义字段1",
  356. width: 100,
  357. hidden: true,
  358. initHidden: false,
  359. editor: {
  360. xtype: "textfield"
  361. },
  362. }, {
  363. dataIndex: "vcdtext2",
  364. text: "自定义字段2",
  365. width: 100,
  366. hidden: true,
  367. initHidden: false,
  368. editor: {
  369. xtype: "textfield"
  370. },
  371. }, {
  372. dataIndex: "vcdtext3",
  373. text: "自定义字段3",
  374. width: 100,
  375. hidden: true,
  376. initHidden: false,
  377. editor: {
  378. xtype: "textfield"
  379. },
  380. }, {
  381. dataIndex: "vcdtext4",
  382. text: "自定义字段4",
  383. width: 100,
  384. hidden: true,
  385. initHidden: false,
  386. editor: {
  387. xtype: "textfield"
  388. },
  389. }, {
  390. dataIndex: "vcdtext5",
  391. text: "自定义字段5",
  392. width: 100,
  393. hidden: true,
  394. initHidden: false,
  395. editor: {
  396. xtype: "textfield"
  397. },
  398. }]
  399. },
  400. other: [{
  401. xtype: 'textfield',
  402. name: 'vc_remark',
  403. columnWidth: 1,
  404. fieldLabel: '备注'
  405. }, {
  406. xtype: "hidden",
  407. name: "creatorId",
  408. fieldLabel: "录入人ID",
  409. readOnly: true
  410. }, {
  411. xtype: "textfield",
  412. name: "creatorName",
  413. fieldLabel: "录入人",
  414. readOnly: true
  415. }, {
  416. xtype: "datefield",
  417. name: "createTime",
  418. fieldLabel: "录入日期",
  419. readOnly: true,
  420. defaultValue: new Date()
  421. }, {
  422. xtype: "hidden",
  423. name: "updaterId",
  424. fieldLabel: "更新人ID",
  425. readOnly: true
  426. }, {
  427. xtype: "hidden",
  428. name: "updaterName",
  429. fieldLabel: "更新人",
  430. readOnly: true
  431. }, {
  432. xtype: "hidden",
  433. name: "updateTime",
  434. fieldLabel: "更新日期",
  435. readOnly: true,
  436. defaultValue: new Date()
  437. }, {
  438. xtype: 'textfield',
  439. name: 'vc_auditman',
  440. fieldLabel: '审核人',
  441. readOnly: true
  442. }, {
  443. xtype: "datefield",
  444. name: "vc_auditdate",
  445. fieldLabel: "审核日期",
  446. readOnly: true
  447. }, {
  448. xtype: "textfield",
  449. name: "vc_text1",
  450. fieldLabel: "自定义字段1",
  451. hidden: true,
  452. initHidden: false
  453. }, {
  454. xtype: "textfield",
  455. name: "vc_text2",
  456. fieldLabel: "自定义字段2",
  457. hidden: true,
  458. initHidden: false
  459. }, {
  460. xtype: "textfield",
  461. name: "vc_text3",
  462. fieldLabel: "自定义字段3",
  463. hidden: true,
  464. initHidden: false
  465. }, {
  466. xtype: "textfield",
  467. name: "vc_text4",
  468. fieldLabel: "自定义字段4",
  469. hidden: true,
  470. initHidden: false
  471. }, {
  472. xtype: "textfield",
  473. name: "vc_text5",
  474. fieldLabel: "自定义字段5",
  475. hidden: true,
  476. initHidden: false
  477. }],
  478. // 预收冲应收
  479. receipts_offset_receivable: {
  480. main: [{
  481. xtype: 'hidden',
  482. fieldLabel: '客户名称',
  483. name: 'vc_custid',
  484. allowBlank: false,
  485. listeners: {
  486. change: 'clearDetails'
  487. }
  488. }, {
  489. fieldLabel: '客户编号',
  490. xtype: 'hidden',
  491. name: 'vc_custcode',
  492. }, {
  493. fieldLabel: '客户名称',
  494. xtype: 'customerDbfindTrigger',
  495. name: 'vc_custname',
  496. allowBlank: false
  497. }, {
  498. fieldLabel: '日期',
  499. xtype: 'datefield',
  500. defaultValue: new Date(),
  501. allowBlank: false,
  502. name: 'vc_date'
  503. }, {
  504. xtype: 'hidden',
  505. name: 'vc_amount1',
  506. thousandSeparator: ',',
  507. fieldLabel: '核销金额(元)'
  508. }, {
  509. xtype: "hidden",
  510. name: "vc_amount2",
  511. thousandSeparator: ',',
  512. fieldLabel: "未核销金额(元)"
  513. }],
  514. details: ['detail1', 'detail2'],
  515. other: ['other']
  516. },
  517. // 预付冲应付
  518. prepaid_offset_payable: {
  519. main: [{
  520. xtype: 'hidden',
  521. name: 'vc_vendid',
  522. fieldLabel: '供应商名称',
  523. allowBlank: false,
  524. listeners: {
  525. change: 'clearDetails'
  526. }
  527. }, {
  528. xtype: "hidden",
  529. name: "vc_vendcode",
  530. fieldLabel: "供应商编号"
  531. }, {
  532. xtype: "vendorDbfindTrigger",
  533. name: "vc_vendname",
  534. fieldLabel: "供应商名称",
  535. allowBlank: false
  536. }, {
  537. fieldLabel: '日期',
  538. xtype: 'datefield',
  539. defaultValue: new Date(),
  540. allowBlank: false,
  541. name: 'vc_date'
  542. }, {
  543. xtype: 'hidden',
  544. name: 'vc_amount1',
  545. thousandSeparator: ',',
  546. fieldLabel: '核销金额(元)'
  547. }, {
  548. xtype: "hidden",
  549. name: "vc_amount2",
  550. thousandSeparator: ',',
  551. fieldLabel: "未核销金额(元)"
  552. }],
  553. details: ['detail1', 'detail2'],
  554. other: ['other']
  555. },
  556. // 应收冲应付
  557. receivable_offset_payable: {
  558. main: [{
  559. fieldLabel: '客户名称',
  560. xtype: 'textfield',
  561. name: 'vc_custid',
  562. hidden: true,
  563. listeners: {
  564. change: 'clearDetail0'
  565. }
  566. }, {
  567. fieldLabel: '客户编号',
  568. xtype: 'textfield',
  569. name: 'vc_custcode',
  570. hidden: true
  571. }, {
  572. fieldLabel: '客户名称',
  573. xtype: 'customerDbfindTrigger',
  574. name: 'vc_custname',
  575. allowBlank: false,
  576. }, {
  577. xtype: 'hidden',
  578. name: 'vc_vendid',
  579. fieldLabel: '供应商',
  580. listeners: {
  581. change: 'clearDetail1'
  582. }
  583. }, {
  584. xtype: "hidden",
  585. name: "vc_vendcode",
  586. fieldLabel: "供应商编号"
  587. }, {
  588. xtype: "vendorDbfindTrigger",
  589. name: "vc_vendname",
  590. fieldLabel: "供应商名称",
  591. allowBlank: false
  592. }, {
  593. fieldLabel: '日期',
  594. xtype: 'datefield',
  595. defaultValue: new Date(),
  596. allowBlank: false,
  597. name: 'vc_date'
  598. }, {
  599. xtype: 'hidden',
  600. name: 'vc_amount1',
  601. thousandSeparator: ',',
  602. fieldLabel: '核销金额(元)'
  603. }, {
  604. xtype: "hidden",
  605. name: "vc_amount2",
  606. thousandSeparator: ',',
  607. fieldLabel: "未核销金额(元)"
  608. }],
  609. details: ['detail1', 'detail2'],
  610. other: ['other']
  611. },
  612. // 应收转应收
  613. receivable_to_receivable: {
  614. main: [{
  615. fieldLabel: '转出客户',
  616. xtype: 'textfield',
  617. name: 'vc_custid',
  618. hidden: true,
  619. listeners: {
  620. change: 'clearDetail0'
  621. }
  622. }, {
  623. fieldLabel: '转出客户编号',
  624. xtype: 'textfield',
  625. name: 'vc_custcode',
  626. hidden: true
  627. }, {
  628. fieldLabel: '转出客户',
  629. xtype: 'customerDbfindTrigger',
  630. name: 'vc_custname',
  631. allowBlank: false,
  632. }, {
  633. fieldLabel: '转入客户id',
  634. xtype: 'textfield',
  635. name: 'vc_turncustid',
  636. hidden: true
  637. }, {
  638. fieldLabel: '转入客户编号',
  639. xtype: 'textfield',
  640. name: 'vc_turncustcode',
  641. hidden: true
  642. }, {
  643. fieldLabel: '转入客户',
  644. xtype: 'customerDbfindTrigger',
  645. name: 'vc_turncustname',
  646. allowBlank: false,
  647. }, {
  648. fieldLabel: '日期',
  649. xtype: 'datefield',
  650. defaultValue: new Date(),
  651. allowBlank: false,
  652. name: 'vc_date'
  653. }, {
  654. xtype: 'hidden',
  655. name: 'vc_amount1',
  656. thousandSeparator: ',',
  657. fieldLabel: '核销金额(元)'
  658. }, {
  659. xtype: "hidden",
  660. name: "vc_amount2",
  661. thousandSeparator: ',',
  662. fieldLabel: "未核销金额(元)"
  663. }],
  664. details: ['detail1'],
  665. other: ['other']
  666. },
  667. // 应付转应付
  668. payable_to_payable: {
  669. main: [{
  670. fieldLabel: '转出供应商',
  671. xtype: 'textfield',
  672. name: 'vc_vendid',
  673. hidden: true,
  674. listeners: {
  675. change: 'clearDetail0'
  676. }
  677. }, {
  678. fieldLabel: '转出供应商编号',
  679. xtype: 'textfield',
  680. name: 'vc_vendcode',
  681. hidden: true
  682. }, {
  683. fieldLabel: '转出供应商',
  684. xtype: 'vendorDbfindTrigger',
  685. name: 'vc_vendname',
  686. allowBlank: false,
  687. }, {
  688. fieldLabel: '转入供应商id',
  689. xtype: 'textfield',
  690. name: 'vc_turnvendid',
  691. hidden: true
  692. }, {
  693. fieldLabel: '转入供应商编号',
  694. xtype: 'textfield',
  695. name: 'vc_turnvendcode',
  696. hidden: true
  697. }, {
  698. fieldLabel: '转入供应商',
  699. xtype: 'vendorDbfindTrigger',
  700. name: 'vc_turnvendname',
  701. allowBlank: false,
  702. }, {
  703. fieldLabel: '日期',
  704. xtype: 'datefield',
  705. defaultValue: new Date(),
  706. allowBlank: false,
  707. name: 'vc_date'
  708. }, {
  709. xtype: 'hidden',
  710. name: 'vc_amount1',
  711. thousandSeparator: ',',
  712. fieldLabel: '核销金额(元)'
  713. }, {
  714. xtype: "hidden",
  715. name: "vc_amount2",
  716. thousandSeparator: ',',
  717. fieldLabel: "未核销金额(元)"
  718. }],
  719. details: ['detail1'],
  720. other: ['other']
  721. },
  722. defaultConditions: {
  723. receipts_offset_receivable: ['ifnull(sl_custid,0)={vc_custid} and ifnull(sl_preamount,0)<>0 and ifnull(sl_namount,0)<>0 ' +
  724. ' and ((sl_kind=\'收款单\') or (sl_kind=\'期初余额\' and sl_ym=' +
  725. '(select min(pd_detno) from periodsdetail where pd_status=0 and periodsdetail.companyid=subledger.companyid)))',
  726. 'ifnull(sl_custid,0)={vc_custid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0 ' +
  727. ' and (sl_kind in (\'出货单\',\'销售退货单\') or (sl_kind in (\'期初余额\') and sl_ym=' +
  728. '(select min(pd_detno) from periodsdetail where pd_status=0 and periodsdetail.companyid=subledger.companyid)))'
  729. ],
  730. prepaid_offset_payable: ['ifnull(sl_vendid,0)={vc_vendid} and ifnull(sl_preamount,0)<>0 and ifnull(sl_namount,0)<>0 ' +
  731. ' and ((sl_kind=\'付款单\') or (sl_kind=\'期初余额\' and sl_ym=' +
  732. '(select min(pd_detno) from periodsdetail where pd_status=0 and periodsdetail.companyid=subledger.companyid)))',
  733. 'ifnull(sl_vendid,0)={vc_vendid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0' +
  734. ' and (sl_kind in (\'采购验收单\',\'采购验退单\') or (sl_kind in (\'期初余额\') and sl_ym=' +
  735. '(select min(pd_detno) from periodsdetail where pd_status=0 and periodsdetail.companyid=subledger.companyid)))'
  736. ],
  737. receivable_offset_payable: ['ifnull(sl_custid,0)={vc_custid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0 ' +
  738. ' and ((sl_kind in (\'出货单\',\'销售退货单\')) or (sl_kind=\'期初余额\' and sl_ym=' +
  739. '(select min(pd_detno) from periodsdetail where pd_status=0 and periodsdetail.companyid=subledger.companyid)))',
  740. 'ifnull(sl_vendid,0)={vc_vendid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0' +
  741. ' and (sl_kind in (\'采购验收单\',\'采购验退单\') or (sl_kind in (\'期初余额\') and sl_ym=' +
  742. '(select min(pd_detno) from periodsdetail where pd_status=0 and periodsdetail.companyid=subledger.companyid)))'
  743. ],
  744. receivable_to_receivable: ['ifnull(sl_custid,0)={vc_custid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0 ' +
  745. ' and ((sl_kind in (\'出货单\',\'销售退货单\')) or (sl_kind=\'期初余额\' and sl_ym=' +
  746. '(select min(pd_detno) from periodsdetail where pd_status=0 and periodsdetail.companyid=subledger.companyid)))'
  747. ],
  748. payable_to_payable: ['ifnull(sl_vendid,0)={vc_vendid} and ifnull(sl_preamount,0)=0 and ifnull(sl_namount,0)<>0' +
  749. ' and (sl_kind in (\'采购验收单\',\'采购验退单\') or (sl_kind in (\'期初余额\') and sl_ym=' +
  750. '(select min(pd_detno) from periodsdetail where pd_status=0 and periodsdetail.companyid=subledger.companyid)))'
  751. ]
  752. }
  753. },
  754. });
  755. }
  756. });