ProfitDetail.js 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. /**
  2. * 毛利润分析表
  3. */
  4. Ext.define('saas.view.money.report.ProfitDetail', {
  5. extend: 'saas.view.core.report.ReportPanel',
  6. xtype: 'monry-report-profitdetail',
  7. controller: 'money-report-profitdetail',
  8. viewModel: 'money-report-profitdetail',
  9. viewName: 'money-report-profitdetail',
  10. groupField: null,
  11. listUrl: '/api/money/report/profitdetails',
  12. defaultCondition: null,
  13. reportTitle: '毛利润分析表',
  14. QueryWidth: 0.2,
  15. searchItems: [{
  16. xtype: 'customerDbfindTrigger',
  17. name: 'pi_custname',
  18. columnWidth: 0.15,
  19. dbfinds:[{
  20. from:'cu_name',to:'pi_custname'
  21. }],
  22. emptyText: '请输入客户名称',
  23. columnWidth: 0.15
  24. }, {
  25. xtype : "remotecombo",
  26. storeUrl:'/api/document/customerkind/getCombo',
  27. name : "cu_type",
  28. emptyText : "请选择客户类型",
  29. columnWidth: 0.15,
  30. hiddenBtn:true
  31. }, {
  32. xtype: 'condatefield',
  33. name: 'pi_date',
  34. fieldLabel: '日期',
  35. columnWidth: 0.5
  36. }],
  37. reportModel: 'saas.model.report.ProfitDetail',
  38. reportColumns: [{
  39. text: '客户类型',
  40. dataIndex: 'cu_type',
  41. width: 100,
  42. }, {
  43. text: '客户名称',
  44. dataIndex: 'pi_custname',
  45. width: 200,
  46. }, {
  47. text: '金额(元)',
  48. dataIndex: 'netamount',
  49. exportFormat: 'Amount',
  50. xtype: 'numbercolumn',
  51. width: 0,
  52. renderer : function(v, m, r) {
  53. return saas.util.BaseUtil.numberFormat(v, 2, true);
  54. },
  55. }, {
  56. text: '税额(元)',
  57. dataIndex: 'saamount-netamount',
  58. exportFormat: 'Amount',
  59. xtype: 'numbercolumn',
  60. width: 0,
  61. renderer : function(v, m, r) {
  62. return saas.util.BaseUtil.numberFormat(v, 2, true);
  63. },
  64. }, {
  65. text: '销售金额(元)',
  66. dataIndex: 'saamount',
  67. exportFormat: 'Amount',
  68. xtype: 'numbercolumn',
  69. width: 120,
  70. renderer : function(v, m, r) {
  71. return saas.util.BaseUtil.numberFormat(v, 2, true);
  72. },
  73. summaryType: 'sum',
  74. summaryLabel: '销售金额',
  75. summaryRenderer: function(v) {
  76. return saas.util.BaseUtil.numberFormat(v, 2, true);
  77. }
  78. }, {
  79. text: '成本金额(元)',
  80. dataIndex: 'costamount',
  81. exportFormat: 'Amount',
  82. xtype: 'numbercolumn',
  83. width: 120,
  84. renderer : function(v, m, r) {
  85. return saas.util.BaseUtil.numberFormat(v, 2, true);
  86. },
  87. summaryType: 'sum',
  88. summaryLabel: '成本金额',
  89. summaryRenderer: function(v) {
  90. return saas.util.BaseUtil.numberFormat(v, 2, true);
  91. }
  92. }, {
  93. text: '毛利润(元)',
  94. dataIndex: 'profit',
  95. exportFormat: 'Amount',
  96. xtype: 'numbercolumn',
  97. width: 120,
  98. renderer : function(v, m, r) {
  99. return saas.util.BaseUtil.numberFormat(v, 2, true);
  100. },
  101. summaryType: 'sum',
  102. summaryLabel: '毛利润',
  103. summaryRenderer: function(v) {
  104. return saas.util.BaseUtil.numberFormat(v, 2, true);
  105. }
  106. }, {
  107. text: '毛利率(%)',
  108. dataIndex: 'profitpresent',
  109. width: 100,
  110. xtype: 'numbercolumn',
  111. renderer : function(v, m, r) {
  112. return saas.util.BaseUtil.numberFormat(v, 2, true);
  113. },
  114. },{
  115. dataIndex: '',
  116. flex: 1
  117. }]
  118. });