quanwei
2025-12-10 898043fc97d2ab8b793fd317a049b874ed207c6d
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
<?php
 
namespace app\agent\controller\statistics;
 
use app\agent\controller\Controller;
use app\common\service\statistics\OrderService;
use app\common\service\statistics\ProductRankingService;
 
/**
 * 销售数据控制器
 */
class Sales extends Controller
{
    /**
     * 销售数据统计
     */
    public function index()
    {
        return $this->renderSuccess('', [
            // 成交订单统计
            'order' => (new OrderService(0))->getData(),
            // 成交商品统计
            'product' => (new OrderService(0))->getProductData(),
            // 销量top10
            'productSaleRanking' => (new ProductRankingService())->getSaleRanking(),
            // 浏览top10
            'productViewRanking' => (new ProductRankingService())->getViewRanking(),
            // 退款top10
            'productRefundRanking' => (new ProductRankingService())->getRefundRanking(),
        ]);
    }
 
    /**
     * 通过时间段查询本期上期金额
     * $type类型:order refund
     */
    public function order($search_time, $type = 'order')
    {
        $days = $this->getDays($search_time);
        $data = [];
        if($type == 'order'){
            $data = (new OrderService(0))->getDataByDate($days);
        }else if($type == 'refund'){
            $data = (new OrderService(0))->getRefundByDate($days);
        }
        return $this->renderSuccess('', [
            // 日期
            'days' => $days,
            // 数据
            'data' => $data,
        ]);
    }
 
    /**
     * 通过时间段查询本期上期金额
     */
    public function product($search_time)
    {
        $days = $this->getDays($search_time);
        return $this->renderSuccess('', [
            // 日期
            'days' => $days,
            // 数据
            'data' => (new OrderService(0))->getProductDataByDate($days),
        ]);
    }
 
    /**
     * 获取具体日期数组
     */
    private function getDays($search_time)
    {
        //搜索时间段
        if(!isset($search_time) || empty($search_time)){
            //没有传,则默认为最近7天
            $end_time = date('Y-m-d', time());
            $start_time = date('Y-m-d', strtotime('-7 day',time()));
        }else{
            $start_time = array_shift($search_time);
            $end_time = array_pop($search_time);
        }
 
        $dt_start = strtotime($start_time);
        $dt_end = strtotime($end_time);
        $date = [];
        $date[] = date('Y-m-d', strtotime($start_time));
        while($dt_start < $dt_end) {
            $date[] = date('Y-m-d', strtotime('+1 day',$dt_start));
            $dt_start = strtotime('+1 day',$dt_start);
        }
        return $date;
    }
}