quanwei
18 hours ago c441dea81bd86bdfb12dff35821fed51f4cc91c2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
<?php
 
namespace app\operations\service\statistics;
 
use app\operations\model\order\Order as OrderModel;
use app\operations\model\user\User as UserModel;
/**
 * 用户数据概况
 */
class UserService
{
    /**
     * 获取数据概况
     */
    public function getData()
    {
        $today = date('Y-m-d');
        $yesterday = date('Y-m-d', strtotime('-1 day'));
        $data = [
            // 累计会员数
            'user_total' => [
                'today' => number_format($this->getUserData(null, $today, 'user_total')),
                'yesterday' => number_format($this->getUserData(null, $yesterday, 'user_total'))
            ],
            // 新增会员数
            'user_add' => [
                'today' => number_format($this->getUserData($today, null, 'user_add')),
                'yesterday' => number_format($this->getUserData($yesterday, null, 'user_add'))
            ],
            // 成交会员数
            'user_pay' => [
                'today' => number_format($this->getOrderData($today, null, 'order_user_total')),
                'yesterday' => number_format($this->getOrderData($yesterday, null, 'order_user_total'))
            ],
        ];
        return $data;
    }
 
    /**
     * 查询成交占比
     */
    public function getPayScaleData($day){
        $today = date('Y-m-d');
        $startDate = null;
        if($day > 0){
            $startDate = date('Y-m-d', strtotime('-' .$day.' day'));
        }
        return [
            'pay' => $this->getUserData($startDate, $today, 'user_pay'),
            'no_pay' => $this->getUserData($startDate, $today, 'user_no_pay')
        ];
    }
    /**
     * 通过时间段查询用户数据
     */
    public function getNewUserByDate($days)
    {
        $data = [];
        foreach ($days as $day) {
            $data[] = [
                'day' => $day,
                'total_num' => $this->getUserData($day, null, 'user_add')
            ];
        }
        return $data;
    }
 
    /**
     * 通过时间段查询用户成交数据
     */
    public function getPayUserByDate($days)
    {
        $data = [];
        foreach ($days as $day) {
            $data[] = [
                'day' => $day,
                'total_num' => number_format($this->getOrderData($day, null, 'order_user_total'))
            ];
        }
        return $data;
    }
 
    /**
     * 获取用户数据
     */
    private function getUserData($startDate = null, $endDate = null, $type)
    {
        return (new UserModel)->getUserData($startDate, $endDate, $type);
    }
 
    /**
     * 获取订单数据
     */
    private function getOrderData($startDate = null, $endDate = null, $type)
    {
        return (new OrderModel)->getOrderData($startDate, $endDate, $type);
    }
}