PurchasePay.js 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  1. Ext.define('saas.view.purchase.report.PurchasePay', {
  2. extend: 'saas.view.core.report.ReportPanel',
  3. xtype: 'purchase-report-purchasepay',
  4. controller: 'purchase-report-purchasepay',
  5. viewModel: 'purchase-report-purchasepay',
  6. viewName: 'purchase-report-purchasepay',
  7. groupField: 'pu_vendname',
  8. groupHeaderTpl: '供应商名称: {[values.rows[0].data.pu_vendname]}',
  9. listUrl: '/api/purchase/report/purchasePay',
  10. defaultCondition: null,
  11. reportTitle: '采购付款一览表',
  12. QueryWidth:0.25,
  13. searchItems: [
  14. {
  15. xtype: 'vendorDbfindTrigger',
  16. name: 'pu_vendname',
  17. columnWidth: 0.25,
  18. emptyText:'请输入供应商名称'
  19. }, {
  20. xtype: 'condatefield',
  21. name: 'createTime',
  22. fieldLabel: '日期',
  23. columnWidth: 0.5
  24. }],
  25. reportModel: 'saas.model.report.PurchasePay',
  26. reportColumns: [ {
  27. text: '付款单号',
  28. dataIndex: 'pb_code',
  29. width: 150
  30. }, {
  31. text: '供应商名称',
  32. dataIndex: 'pu_vendname',
  33. width: 200
  34. }, {
  35. text : "日期",
  36. dataIndex : "createTime",
  37. xtype:'datecolumn',
  38. width: 110
  39. }, {
  40. text: '来源单号',
  41. dataIndex: 'pbd_slcode',
  42. width: 150
  43. }, {
  44. text: '业务类型',
  45. dataIndex: 'pbd_slkind',
  46. width: 100
  47. }, {
  48. text: '金额(元)',
  49. xtype: 'numbercolumn',
  50. exportFormat: 'Amount',
  51. dataIndex: 'pi_nettotal',
  52. width: 120,
  53. renderer: function(v) {
  54. return saas.util.BaseUtil.numberFormat(v, 2, true);
  55. },
  56. }, {
  57. text: '税额(元)',
  58. xtype: 'numbercolumn',
  59. exportFormat: 'Amount',
  60. dataIndex: 'pd_total-pi_nettotal',
  61. width: 120,
  62. renderer: function(v) {
  63. return saas.util.BaseUtil.numberFormat(v, 2, true);
  64. },
  65. }, {
  66. text: '价税合计(元)',
  67. xtype: 'numbercolumn',
  68. exportFormat: 'Amount',
  69. dataIndex: 'pi_total',
  70. width: 120,
  71. renderer: function(v) {
  72. return saas.util.BaseUtil.numberFormat(v, 2, true);
  73. },
  74. }, {
  75. text: '付款金额(元)',
  76. dataIndex: 'pbd_nowbalance',
  77. exportFormat: 'Amount',
  78. xtype: 'numbercolumn',
  79. width: 120,
  80. summaryType: 'sum',
  81. summaryLabel: '付款金额',
  82. renderer: function(v) {
  83. return saas.util.BaseUtil.numberFormat(v, 2, true);
  84. },
  85. summaryRenderer: function(v) {
  86. return saas.util.BaseUtil.numberFormat(v, 2, true);
  87. }
  88. }, {
  89. text: '付款比例(%)',
  90. //本次付款/采购金额*100%
  91. dataIndex: 'pb_payrate',
  92. xtype: 'numbercolumn',
  93. width: 100,
  94. renderer : function(v) {
  95. return saas.util.BaseUtil.numberFormat(v, 2, false);
  96. }
  97. }, {
  98. text: '付款人',
  99. dataIndex: 'pb_manname',
  100. width: 80
  101. }, {
  102. text: '备注',
  103. dataIndex: 'pb_remark',
  104. width: 250
  105. }]
  106. });