phpstock/app/admin/controller/Data.php

<?php

namespace app\admin\controller;

use think\App;
use think\facade\Db;

//数据统计类
class Data extends Base

{
    //数据看板，获取相关统计数据
    public function index()
    {
        $data = [];

        //1.今日销量(单数、金额)
        $data['today_sales_volume'] = [
            'orders_number' => '0',
            'money' => '00.00'
        ];

        //2.今日销冠(部门、姓名、单数、金额)
        $data['today_sales_champion'] = [
            'company_id' => '0',
            'company' => 'xxx部',
            'nickname' => '张三',
            'orders' => '0',
            'money' => '00.00'
        ];

        //3.今日采购(采购订单数量、商品数量、竞价单数、反馈商品数)
        $data['today_purchase'] = [
            'orders' => '0',
            'goods' => '0',
            'bidding_orders' => '0',
            'feedback_goods' => '0'
        ];

        //4.今日订单列表(按照完成率排序，前三名的部门、单数、金额)
        $data['today_order'] = [
            ['company' => 'xxx部', 'orders' => '30', 'money' => '300'],
            ['company' => 'xx部', 'orders' => '20', 'money' => '200'],
            ['company' => 'x部', 'orders' => '10', 'money' => '100'],
        ];

        //5.本月完成率列表(按照完成率排序，前三名的部门、完成单数和完成率，区分今日、本周、本月和毛利率状态：2达标、1最低、0不达标等情况)
        $data['month_completion_rate'] = [
            'today' => [
                ['company' => 'xxx部', 'completion' => 10, 'completion_rate' => '30%', 'type' => '2'],
                ['company' => 'xx部', 'completion' => 10, 'completion_rate' => '20%', 'type' => '1'],
                ['company' => 'x部', 'completion' => 10, 'completion_rate' => '10%', 'type' => '0'],
            ],
            'week' => [
                ['company' => 'xxx部', 'completion' => 10, 'completion_rate' => '30%', 'type' => '2'],
                ['company' => 'xx部', 'completion' => 10, 'completion_rate' => '20%', 'type' => '1'],
                ['company' => 'x部', 'completion' => 10, 'completion_rate' => '10%', 'type' => '0'],
            ],
            'month' => [
                ['company' => 'xxx部', 'completion' => 10, 'completion_rate' => '30%', 'type' => '2'],
                ['company' => 'xx部', 'completion' => 10, 'completion_rate' => '20%', 'type' => '1'],
                ['company' => 'x部', 'completion' => 10, 'completion_rate' => '10%', 'type' => '0'],
            ],
        ];

        //6.待开票(单数、金额)
        $data['wait_invoice'] = [
            'orders' => '10',
            'money' => '34.45'
        ];

        //7.待回款(单数、金额)
        $data['wait_return'] = [
            'orders' => '100',
            'money' => '3.45'
        ];

        //8.待回票(单数、金额)
        $data['wait_ticket'] = [
            'orders' => '8',
            'money' => '38.5'
        ];

        //9.待付款(单数、金额)
        $data['wait_payment'] = [
            'orders' => '34',
            'money' => '5338.58'
        ];



        //10.竞价(招标单数、未竞标单数)
        $data['bidding'] = [
            'bidding_orders' => '10',
            'no_bidding_orders' => '2'
        ];

        //11.采购单(采购单数、未下单数)
        $data['purchase'] = [
            'purchase_orders' => '10',
            'no_purchase_orders' => '2'
        ];

        //12.采购单(采购下单数、未生产单数)
        $data['purchase_2'] = [
            'orders' => '10',
            'no_orders' => '2'
        ];

        //13.未发货(单数、商品数)
        $data['no_deliver'] = [
            'orders' => '10',
            'goods' => '2'
        ];

        //14.转单率(部门名称、今日转单率、本月转单率，今年转单率，按照年度转单率排序)
        $data['transfer_order_rate'] = [
            ['company' => 'xxx部', 'today_tor' => '34%', 'month_tor' => '68%', 'year_tor' => '45%'],
            ['company' => 'xx部', 'today_tor' => '34%', 'month_tor' => '68%', 'year_tor' => '40%'],
            ['company' => 'x部', 'today_tor' => '34%', 'month_tor' => '68%', 'year_tor' => '6%'],
        ];

        return app_show(0, '请求成功', $data);

    }

}