<?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' =>'product_code',
        'value' => '存货编码',
    ],
    [
        'key' =>'product_title',
        'value' => '存货名称',
    ],
    [
        'key' =>'product_size',
        'value' => '规格型号',
    ],
    [
        'key' =>'unit',
        'value' => '单位',
    ],
    [
        'key' =>'quantity',
        'value' => '开票数量',
        'sum' => 1,
    ],
    [
        'key' =>'price_1',
        'value' => '单价',
    ],
    [
        'key' =>'price_1_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_1_total - price_4_total',
    ],
    [
        'key' =>'profit_rate',
        'value' => '毛利率%',
        'value1' => '毛利 / 开票金额',
        'sum' => 2,
        'formula' => 'profit / price_1_total * 100',
        'split_join' => '%',
    ],
];