RecDetail.js 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163
  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. hidden:true,
  73. text: '增加应收(本位币)(元)',
  74. dataIndex: 'rd_addrec_cr',
  75. exportFormat: 'Amount',
  76. xtype: 'numbercolumn',
  77. width: 160,
  78. renderer: function(v, m, r) {
  79. return saas.util.BaseUtil.numberFormat(v, 2, true);
  80. },
  81. summaryLabel: '增加应收(本位币)',
  82. summaryType: 'customize_sum',
  83. summaryRenderer: function(v, d, f, m) {
  84. return saas.util.BaseUtil.numberFormat(v, 2, true);
  85. },
  86. mySummaryRenderer: function(grid, column, datas) {
  87. return grid.store.sum(column.dataIndex)
  88. }
  89. }, {
  90. text: '增加预收(元)',
  91. xtype: 'numbercolumn',
  92. exportFormat: 'Amount',
  93. dataIndex: 'rd_addpre',
  94. width: 120,
  95. renderer: function(v, m, r) {
  96. return saas.util.BaseUtil.numberFormat(v, 2, true);
  97. },
  98. disableMySummary:true,
  99. summaryType: 'sum',
  100. summaryRenderer: function(v, d, f, m) {
  101. return saas.util.BaseUtil.numberFormat(v, 2, true);
  102. }
  103. },{
  104. hidden:true,
  105. text: '增加预收(本位币)(元)',
  106. dataIndex: 'rd_addpre_cr',
  107. exportFormat: 'Amount',
  108. xtype: 'numbercolumn',
  109. width: 160,
  110. renderer: function(v, m, r) {
  111. return saas.util.BaseUtil.numberFormat(v, 2, true);
  112. },
  113. summaryLabel: '增加预收(本位币)',
  114. summaryType: 'customize_sum',
  115. summaryRenderer: function(v, d, f, m) {
  116. return saas.util.BaseUtil.numberFormat(v, 2, true);
  117. },
  118. mySummaryRenderer: function(grid, column, datas) {
  119. return grid.store.sum(column.dataIndex)
  120. }
  121. }, {
  122. text: '应收余额(元)',
  123. xtype: 'numbercolumn',
  124. exportFormat: 'Amount',
  125. dataIndex: 'rd_remain',
  126. width: 120,
  127. renderer: function(v, m, r) {
  128. return saas.util.BaseUtil.numberFormat(v, 2, true);
  129. },
  130. disableMySummary:true,
  131. summaryType: 'sum',
  132. summaryRenderer: function(v, d, f, m) {
  133. return saas.util.BaseUtil.numberFormat(v, 2, true);
  134. }
  135. },{
  136. hidden:true,
  137. text: '应收余额(本位币)(元)',
  138. dataIndex: 'rd_remain_cr',
  139. exportFormat: 'Amount',
  140. xtype: 'numbercolumn',
  141. width: 160,
  142. renderer: function(v, m, r) {
  143. return saas.util.BaseUtil.numberFormat(v, 2, true);
  144. },
  145. summaryLabel: '应收余额(本位币)',
  146. summaryType: 'customize_sum',
  147. summaryRenderer: function(v, d, f, m) {
  148. return saas.util.BaseUtil.numberFormat(v, 2, true);
  149. },
  150. mySummaryRenderer: function(grid, column, datas) {
  151. return grid.store.sum(column.dataIndex)
  152. }
  153. }, {
  154. dataIndex: '',
  155. flex: 1
  156. }]
  157. });