<?php

/**
 * 概览
 */

namespace Module\Admin;

use Pyramid\Component\HttpFoundation\Response;
use Pyramid\Component\HttpFoundation\RedirectResponse;
use Pyramid\Component\WeChat\WeChat;

trait Dashboard {
    
    /**
     * 概览
     * @route /admin/dashboard
     */
    public static function dashboard($request) {
        //微信用户统计
        $wxuser = db_query("select subscribe, count(*) as total from {wxuser} group by subscribe")->fetchAllKeyed();
        $wxuserSubscribe = !empty($wxuser[1]) ? $wxuser[1] : 0;
        $wxuserTotal = array_sum($wxuser);
        $wxuserTotal = $wxuserTotal ? $wxuserTotal : 1;
        $wxuserPercent = ceil($wxuserSubscribe/$wxuserTotal*100);
        $wxuserAccessed = db_query("select * from {wxuser} where subscribe=1 order by accessed desc limit 10")->fetchAll();
        //店鋪統計
        $storeTotal = db_query("select count(*) as total from {store}")->fetchField();
        
        return new Response(render('/admin/dashboard.html', array(
            'sexes' => config()->get('sexes'),
            'wxuserChart' => array(
                'wxuserSubscribe' => $wxuserSubscribe,
                'wxuserTotal'     => $wxuserTotal,
                'wxuserPercent'   => $wxuserPercent,
                'wxuserAccessed'  => $wxuserAccessed,
            ),        
            'storeTotal' => $storeTotal,
        )));
    }

}