77.php 1.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192
  1. <?php
  2. /**
  3. * '菜单ID' => [
  4. * '字段英文名' =》 '字段中文名'
  5. * ]
  6. */
  7. return [
  8. [
  9. 'key' =>'order_number',
  10. 'value' => '关联单据号',
  11. ],
  12. [
  13. 'key' =>'voucher_type_title',
  14. 'value' => '单据类型',
  15. ],
  16. [
  17. 'key' =>'customer_code',
  18. 'value' => '结算客户编码',
  19. ],
  20. [
  21. 'key' =>'customer_title',
  22. 'value' => '结算客户',
  23. ],
  24. [
  25. 'key' =>'channel_finance',
  26. 'value' => '渠道财务',
  27. ],
  28. [
  29. 'key' =>'customer_profit_rate',
  30. 'value' => '客户毛利率',
  31. ],
  32. [
  33. 'key' =>'product_code',
  34. 'value' => '存货编码',
  35. ],
  36. [
  37. 'key' =>'product_title',
  38. 'value' => '存货名称',
  39. ],
  40. [
  41. 'key' =>'product_size',
  42. 'value' => '规格型号',
  43. ],
  44. [
  45. 'key' =>'unit',
  46. 'value' => '计量单位',
  47. ],
  48. [
  49. 'key' =>'quantity',
  50. 'value' => '开票数量',
  51. 'sum' => 1,
  52. ],
  53. [
  54. 'key' =>'price_1',
  55. 'value' => '单价',
  56. ],
  57. [
  58. 'key' =>'payment_amount',
  59. 'value' => '回款金额',
  60. 'sum' => 1,
  61. ],
  62. [
  63. 'key' =>'price_1_total',
  64. 'value' => '开票金额',
  65. 'sum' => 1,
  66. ],
  67. [
  68. 'key' =>'price_4',
  69. 'value' => '业务成本单价',
  70. 'sum' => 1,
  71. ],
  72. [
  73. 'key' =>'price_4_total',
  74. 'value' => '业务成本金额',
  75. 'sum' => 1,
  76. ],
  77. [
  78. 'key' =>'profit',
  79. 'value' => '毛利',
  80. 'value1' => '回款金额 - 业务成本金额',
  81. 'sum' => 2,
  82. 'formula' => 'payment_amount - price_4_total',
  83. ],
  84. [
  85. 'key' =>'profit_rate',
  86. 'value' => '毛利率%',
  87. 'value1' => '毛利 / 回款金额',
  88. 'sum' => 2,
  89. 'formula' => 'profit / payment_amount * 100',
  90. ],
  91. ];