69.php 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  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' =>'customer_code',
  26. 'value' => '结算客户编码',
  27. ],
  28. [
  29. 'key' =>'customer_title',
  30. 'value' => '结算客户',
  31. ],
  32. [
  33. 'key' =>'channel_finance',
  34. 'value' => '渠道财务',
  35. ],
  36. [
  37. 'key' =>'channel_details',
  38. 'value' => '渠道明细',
  39. ],
  40. [
  41. 'key' =>'product_code',
  42. 'value' => '存货编码',
  43. ],
  44. [
  45. 'key' =>'product_title',
  46. 'value' => '存货名称',
  47. ],
  48. [
  49. 'key' =>'product_size',
  50. 'value' => '规格型号',
  51. ],
  52. [
  53. 'key' =>'unit',
  54. 'value' => '单位',
  55. ],
  56. [
  57. 'key' =>'price_1',
  58. 'value' => '核销单价',
  59. 'value1' => '存货档案中的核销单价',
  60. ],
  61. [
  62. 'key' =>'price_1_total',
  63. 'value' => '核销总价',
  64. 'value1' => '核销单价 * 销货数量',
  65. 'sum' => 1,
  66. ],
  67. [
  68. 'key' =>'price_2',
  69. 'value' => '运费单价',
  70. 'value1' => '存货档案中的运费单价',
  71. ],
  72. [
  73. 'key' =>'price_2_total',
  74. 'value' => '运费总价',
  75. 'value1' => '运费单价 * 销货数量',
  76. 'sum' => 1,
  77. ],
  78. [
  79. 'key' =>'quantity',
  80. 'value' => '销货数量',
  81. 'sum' => 1,
  82. ],
  83. [
  84. 'key' =>'price_3',
  85. 'value' => '含税单价',
  86. ],
  87. [
  88. 'key' =>'price_3_total',
  89. 'value' => '含税金额',
  90. 'sum' => 1,
  91. ],
  92. [
  93. 'key' =>'price_4',
  94. 'value' => '业务成本单价',
  95. 'value1' => '存货档案中的业务成本单价',
  96. ],
  97. [
  98. 'key' =>'price_4_total',
  99. 'value' => '业务成本金额',
  100. 'value1' => '销货数量 * 业务成本单价',
  101. 'sum' => 1,
  102. ],
  103. [
  104. 'key' =>'profit',
  105. 'value' => '毛利',
  106. 'value1' => '销货金额(含税金额) - 业务成本金额',
  107. 'sum' => 2,
  108. 'formula' => 'price_3_total - business',
  109. ],
  110. [
  111. 'key' =>'profit_rate',
  112. 'value' => '毛利率%',
  113. 'value1' => '毛利 / 销货金额(含税金额)',
  114. 'sum' => 2,
  115. 'formula' => 'profit / price_3_total * 100',
  116. 'split_join' => '%',
  117. ],
  118. ];