Dashboard.php
2.6 KB
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
<?php
namespace app\admin\controller\qywx;
use addons\qyexternal\model\UserBehavior;
use app\common\controller\Backend;
use addons\qyexternal\model\Corp;
class Dashboard extends Backend
{
public function index()
{
$corp = Corp::withCount(["follow", "contacts", "chats"])->select();
$data_corp = [];
foreach ($corp as $item) {
$data_corp["name"][] = $item["name"];
$data_corp["follow"][] = ["value"=>$item["follow_count"], "name"=>$item["name"]];
$data_corp["contacts"][] = ["value"=>$item["contacts_count"], "name"=>$item["name"]];
$data_corp["chats"][] = ["value"=>$item["chats_count"], "name"=>$item["name"]];
}
if (!empty($data_corp)) {
$this->assignconfig('corp', $data_corp);
}
$week = $this->getUserBehavior(7);
$month = $this->getUserBehavior(30);
$this->assignconfig('behavior', compact("week", "month"));
return $this->view->fetch();
}
protected function getUserBehavior($days)
{
$count = [
"new_apply_cnt" => 0,
"new_contact_cnt" => 0,
"negative_feedback_cnt" => 0,
"chat_cnt" => 0,
"message_cnt" => 0,
"reply_percentage" => 0,
"avg_reply_time" => 0,
];
$end_time = strtotime(date("Y-m-d", strtotime("-1 day")));
$start_time = $end_time - 86400 * intval($days - 1);
$behavior = UserBehavior::whereBetween("date", [$start_time, $end_time])->select();
$data = [];
foreach ($behavior as $item) {
$data["x"][$item["date"]] = date("m-d", $item["date"]);
foreach ($item->toArray() as $key=>$val) {
if (in_array($key, array_keys($count))) {
if (isset($data[$key][$item["date"]])) {
$data[$key][$item["date"]] += $val;
} else {
$data[$key][$item["date"]] = $val;
}
if (isset($count[$key])) {
$count[$key] += $val;
}
}
}
}
foreach ($data as &$val) {
$val = array_values($val);
}
if(isset($data["x"])) {
$data["x"] = array_values($data["x"]);
}
$data["count"] = $count;
return $data;
}
public function sync()
{
foreach (Corp::all() as $val) {
$payload = new \Weasy\Core\Corp($val["id"]);
$payload->sync();
}
$this->success("同步成功");
}
}