1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556 |
- <?php
- /**
- * '菜单ID' => [
- * '字段英文名' =》 '字段中文名'
- * ]
- */
- return [
- [
- 'key' =>'order_type_title',
- 'value' => '单据类型',
- ],
- [
- 'key' =>'order_time',
- 'value' => '统计年月',
- ],
- [
- 'key' =>'employee_id_1_title',
- 'value' => '业务员',
- ],
- [
- 'key' =>'income',
- 'value' => '收入金额',
- 'value1' => '销货单:含税金额;
- 销售发票:开票金额;
- 回款单:回款金额;',
- 'sum' => 1,
- ],
- [
- 'key' =>'adjust',
- 'value' => '调整金额',
- 'value1' => '金额为负数的合计',
- 'sum' => 1,
- ],
- [
- 'key' =>'business',
- 'value' => '业务成本金额',
- 'value1' => '业务成本金额合计',
- 'sum' => 1,
- ],
- [
- 'key' =>'profit',
- 'value' => '毛利',
- 'value1' => '收入金额 - 业务成本金额',
- 'sum' => 2,
- 'formula' => 'income - business',
- ],
- [
- 'key' =>'profit_rate',
- 'value' => '毛利率%',
- 'value1' => '毛利 / 收入金额',
- 'sum' => 2,
- 'formula' => 'profit / income * 100',
- 'split_join' => '%',
- ],
- ];
|