RecDetail.js 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  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: null,
  8. listUrl: '/api/money/report/recDetail',
  9. defaultCondition: null,
  10. reportTitle: '应收账款明细',
  11. QueryWidth:0.1,
  12. //筛选:客户、日期(必填)
  13. searchItems: [ {
  14. xtype: 'dbfindtrigger',
  15. name: 'pi_custname',
  16. fieldLabel: '客户名称',
  17. columnWidth: 0.2
  18. }, {
  19. xtype: 'condatefield',
  20. name: 'pb_date',
  21. fieldLabel: '单据日期',
  22. columnWidth: 0.5
  23. }],
  24. reportColumns: [
  25. {
  26. text: 'id',
  27. dataIndex: 'pi_id',
  28. hidden: true
  29. }, {
  30. text: '单号',
  31. dataIndex: 'pi_inoutno',
  32. width: 200
  33. }, {
  34. text: '客户编号',
  35. dataIndex: 'pi_custcode',
  36. width: 200
  37. }, {
  38. text: '客户名称',
  39. dataIndex: 'pi_custname',
  40. width: 200
  41. }, {
  42. text: '单据类型',
  43. dataIndex: 'pi_class',
  44. width: 200
  45. },{
  46. text: '业务员',
  47. dataIndex: 'pu_buyername',
  48. width: 200
  49. }, {
  50. text: '单据日期',
  51. dataIndex: 'pb_date',
  52. width: 200,
  53. }, {
  54. text: '序号',
  55. dataIndex: 'pd_pdno',
  56. xtype: 'numbercolumn'
  57. },{
  58. text:'期初应收',
  59. dataIndex:'cu_beginaramount',
  60. xtype: 'numbercolumn',
  61. summaryType: 'sum',
  62. summaryRenderer: function(v) {
  63. var arr = (v + '.').split('.');
  64. var xr = (new Array(arr[1].length)).fill('0');
  65. var format = '0.' + xr.join();
  66. }
  67. },{
  68. text:'本期收款金额',
  69. xtype: 'numbercolumn',
  70. dataIndex:'pb_pdamount',
  71. xtype: 'numbercolumn',
  72. summaryType: 'sum',
  73. summaryRenderer: function(v) {
  74. var arr = (v + '.').split('.');
  75. var xr = (new Array(arr[1].length)).fill('0');
  76. var format = '0,000.' + xr.join();
  77. }
  78. },{
  79. text: '应收余额',
  80. xtype: 'numbercolumn',
  81. dataIndex: 'mustpay',
  82. xtype: 'numbercolumn',
  83. summaryType: 'sum',
  84. summaryRenderer: function(v) {
  85. var arr = (v + '.').split('.');
  86. var xr = (new Array(arr[1].length)).fill('0');
  87. var format = '0.' + xr.join();
  88. }
  89. }, {
  90. text: '应收日期',
  91. dataIndex: 'mustdate'
  92. }, {
  93. text: '单据总金额',
  94. dataIndex: 'pi_total',
  95. xtype: 'numbercolumn'
  96. }, {
  97. text: '备注',
  98. dataIndex: 'pd_unit'
  99. }]
  100. });