Dashboard.php 2.6 KB
<?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("同步成功");
    }
}