RecDetail.js 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160
  1. Ext.define('saas.view.money.report.RecDetail', {
  2. extend: 'saas.view.core.report.ReportPanel',
  3. xtype: 'monry-report-recdetail',
  4. controller: 'money-report-recdetail',
  5. viewModel: 'money-report-recdetail',
  6. viewName: 'money-report-recdetail',
  7. groupField: 'groupfield',
  8. groupHeaderTpl: '{[values.rows[0].data.rd_custname]} ({[values.rows[0].data.rd_currency]})',
  9. listUrl: '/api/money/report/recDetail',
  10. defaultCondition: null,
  11. reportTitle: '应收账款明细',
  12. QueryWidth: 0.25,
  13. allowPaging: false,
  14. //筛选:客户、日期(必填)
  15. searchItems: [{
  16. xtype: 'customerDbfindTrigger',
  17. name: 'rd_custname',
  18. emptyText: '请输入客户名称',
  19. columnWidth: 0.25
  20. }, {
  21. xtype: 'conmonthfield',
  22. name: 'rd_ym',
  23. fieldLabel: '期间',
  24. columnWidth: 0.5
  25. }],
  26. reportModel: 'saas.model.report.RecDetail',
  27. reportColumns: [{
  28. text: '单据日期',
  29. xtype: 'datecolumn',
  30. dataIndex: 'rd_date',
  31. width: 110
  32. }, {
  33. text: '单号',
  34. dataIndex: 'rd_code',
  35. width: 150
  36. }, {
  37. text: '业务类型',
  38. dataIndex: 'rd_kind',
  39. width: 100
  40. }, {
  41. text: '业务员',
  42. dataIndex: 'rd_sellername',
  43. width: 80
  44. }, {
  45. text: '币别',
  46. dataIndex: 'rd_currency',
  47. align:'center',
  48. width: 65
  49. },{
  50. text: '汇率',
  51. dataIndex: 'rd_rate',
  52. align:'center',
  53. width: 65,
  54. renderer: function (v, m, r) {
  55. return saas.util.BaseUtil.numberFormat(v, 6, false);
  56. }
  57. }, {
  58. text: '增加应收(元)',
  59. dataIndex: 'rd_addrec',
  60. exportFormat: 'Amount',
  61. xtype: 'numbercolumn',
  62. width: 120,
  63. renderer: function(v, m, r) {
  64. return saas.util.BaseUtil.numberFormat(v, 2, true);
  65. },
  66. summaryType: 'sum',
  67. disableMySummary:true,
  68. summaryRenderer: function(v, d, f, m) {
  69. return saas.util.BaseUtil.numberFormat(v, 2, true);
  70. }
  71. },{
  72. text: '增加应收(本位币)(元)',
  73. dataIndex: 'rd_addrec_cr',
  74. exportFormat: 'Amount',
  75. xtype: 'numbercolumn',
  76. width: 160,
  77. renderer: function(v, m, r) {
  78. return saas.util.BaseUtil.numberFormat(v, 2, true);
  79. },
  80. summaryLabel: '增加应收(本位币)',
  81. summaryType: 'customize_sum',
  82. summaryRenderer: function(v, d, f, m) {
  83. return saas.util.BaseUtil.numberFormat(v, 2, true);
  84. },
  85. mySummaryRenderer: function(grid, column, datas) {
  86. return grid.store.sum(column.dataIndex)
  87. }
  88. }, {
  89. text: '增加预收(元)',
  90. xtype: 'numbercolumn',
  91. exportFormat: 'Amount',
  92. dataIndex: 'rd_addpre',
  93. width: 120,
  94. renderer: function(v, m, r) {
  95. return saas.util.BaseUtil.numberFormat(v, 2, true);
  96. },
  97. disableMySummary:true,
  98. summaryType: 'sum',
  99. summaryRenderer: function(v, d, f, m) {
  100. return saas.util.BaseUtil.numberFormat(v, 2, true);
  101. }
  102. },{
  103. text: '增加预收(本位币)(元)',
  104. dataIndex: 'rd_addpre_cr',
  105. exportFormat: 'Amount',
  106. xtype: 'numbercolumn',
  107. width: 160,
  108. renderer: function(v, m, r) {
  109. return saas.util.BaseUtil.numberFormat(v, 2, true);
  110. },
  111. summaryLabel: '增加预收(本位币)',
  112. summaryType: 'customize_sum',
  113. summaryRenderer: function(v, d, f, m) {
  114. return saas.util.BaseUtil.numberFormat(v, 2, true);
  115. },
  116. mySummaryRenderer: function(grid, column, datas) {
  117. return grid.store.sum(column.dataIndex)
  118. }
  119. }, {
  120. text: '应收余额(元)',
  121. xtype: 'numbercolumn',
  122. exportFormat: 'Amount',
  123. dataIndex: 'rd_remain',
  124. width: 120,
  125. renderer: function(v, m, r) {
  126. return saas.util.BaseUtil.numberFormat(v, 2, true);
  127. },
  128. disableMySummary:true,
  129. summaryType: 'sum',
  130. summaryRenderer: function(v, d, f, m) {
  131. return saas.util.BaseUtil.numberFormat(v, 2, true);
  132. }
  133. },{
  134. text: '应收余额(本位币)(元)',
  135. dataIndex: 'rd_remain_cr',
  136. exportFormat: 'Amount',
  137. xtype: 'numbercolumn',
  138. width: 160,
  139. renderer: function(v, m, r) {
  140. return saas.util.BaseUtil.numberFormat(v, 2, true);
  141. },
  142. summaryLabel: '应收余额(本位币)',
  143. summaryType: 'customize_sum',
  144. summaryRenderer: function(v, d, f, m) {
  145. return saas.util.BaseUtil.numberFormat(v, 2, true);
  146. },
  147. mySummaryRenderer: function(grid, column, datas) {
  148. return grid.store.sum(column.dataIndex)
  149. }
  150. }, {
  151. dataIndex: '',
  152. flex: 1
  153. }]
  154. });