71.php 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. <?php
  2. /**
  3. * '菜单ID' => [
  4. * '字段英文名' =》 '字段中文名'
  5. * ]
  6. */
  7. return [
  8. [
  9. 'key' =>'order_number',
  10. 'value' => '回款单号',
  11. ],
  12. [
  13. 'key' =>'order_time',
  14. 'value' => '单据日期',
  15. ],
  16. [
  17. 'key' =>'employee_id_1_title',
  18. 'value' => '业务员',
  19. ],
  20. [
  21. 'key' =>'employee_id_2_title',
  22. 'value' => '上级管理人员',
  23. ],
  24. [
  25. 'key' =>'channel_finance',
  26. 'value' => '渠道财务',
  27. ],
  28. [
  29. 'key' =>'payment_amount',
  30. 'value' => '回款金额',
  31. 'sum' => 1,
  32. ],
  33. [
  34. 'key' =>'price_4_total',
  35. 'value' => '业务成本金额',
  36. 'value1' => '开票数量 * 存货业务成本单价',
  37. 'sum' => 1,
  38. ],
  39. [
  40. 'key' =>'profit',
  41. 'value' => '毛利',
  42. 'value1' => '回款金额 - 业务成本金额',
  43. 'sum' => 2,
  44. 'formula' => 'payment_amount - price_4_total',
  45. ],
  46. [
  47. 'key' =>'profit_rate',
  48. 'value' => '毛利率%',
  49. 'value1' => '毛利 / 回款金额',
  50. 'sum' => 2,
  51. 'formula' => 'profit / payment_amount * 100',
  52. ],
  53. ];