68.php 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. <?php
  2. /**
  3. * '菜单ID' => [
  4. * '字段英文名' =》 '字段中文名'
  5. * ]
  6. */
  7. return [
  8. [
  9. 'key' =>'order_type_title',
  10. 'value' => '单据类型',
  11. ],
  12. [
  13. 'key' =>'order_time',
  14. 'value' => '统计年月',
  15. ],
  16. [
  17. 'key' =>'employee_id_1_title',
  18. 'value' => '业务员',
  19. ],
  20. [
  21. 'key' =>'income',
  22. 'value' => '收入金额',
  23. 'value1' => '销货单:含税金额;
  24. 销售发票:开票金额;
  25. 回款单:回款金额;',
  26. 'sum' => 1,
  27. ],
  28. [
  29. 'key' =>'adjust',
  30. 'value' => '调整金额',
  31. 'value1' => '金额为负数的合计',
  32. 'sum' => 1,
  33. ],
  34. [
  35. 'key' =>'business',
  36. 'value' => '业务成本金额',
  37. 'value1' => '业务成本金额合计',
  38. 'sum' => 1,
  39. ],
  40. [
  41. 'key' =>'profit',
  42. 'value' => '毛利',
  43. 'value1' => '收入金额 - 业务成本金额',
  44. 'sum' => 2,
  45. 'formula' => 'income - business',
  46. ],
  47. [
  48. 'key' =>'profit_rate',
  49. 'value' => '毛利率%',
  50. 'value1' => '毛利 / 收入金额',
  51. 'sum' => 2,
  52. 'formula' => 'profit / income * 100',
  53. 'split_join' => '%',
  54. ],
  55. ];