| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118 | <?php/** * '菜单ID' => [ *     '字段英文名' =》 '字段中文名' * ] */return [    [        'key' =>'order_number',        'value' => '销货单号',    ],    [        'key' =>'order_time',        'value' => '单据日期',    ],    [        'key' =>'employee_id_1_title',        'value' => '业务员',    ],    [        'key' =>'employee_id_2_title',        'value' => '上级管理人员',    ],    [        'key' =>'customer_code',        'value' => '结算客户编码',    ],    [        'key' =>'customer_title',        'value' => '结算客户',    ],    [        'key' =>'channel_finance',        'value' => '渠道财务',    ],    [        'key' =>'channel_details',        'value' => '渠道明细',    ],    [        'key' =>'product_code',        'value' => '存货编码',    ],    [        'key' =>'product_title',        'value' => '存货名称',    ],    [        'key' =>'product_size',        'value' => '规格型号',    ],    [        'key' =>'unit',        'value' => '单位',    ],    [        'key' =>'price_1',        'value' => '核销单价',        'value1' => '存货档案中的核销单价',    ],    [        'key' =>'price_1_total',        'value' => '核销总价',        'value1' => '核销单价 * 销货数量',        'sum' => 1,    ],    [        'key' =>'price_2',        'value' => '运费单价',        'value1' => '存货档案中的运费单价',    ],    [        'key' =>'price_2_total',        'value' => '运费总价',        'value1' => '运费单价 * 销货数量',        'sum' => 1,    ],    [        'key' =>'quantity',        'value' => '销货数量',        'sum' => 1,    ],    [        'key' =>'price_3',        'value' => '含税单价',    ],    [        'key' =>'price_3_total',        'value' => '含税金额',        'sum' => 1,    ],    [        'key' =>'price_4',        'value' => '业务成本单价',        'value1' => '存货档案中的业务成本单价',    ],    [        'key' =>'price_4_total',        'value' => '业务成本金额',        'value1' => '销货数量 * 业务成本单价',        'sum' => 1,    ],    [        'key' =>'profit',        'value' => '毛利',        'value1' => '销货金额(含税金额) - 业务成本金额',        'sum' => 2,        'formula' => 'price_3_total - business',    ],    [        'key' =>'profit_rate',        'value' => '毛利率%',        'value1' => '毛利 / 销货金额(含税金额)',        'sum' => 2,        'formula' => 'profit / price_3_total * 100',    ],];
 |