<?php
/**
 * Created by PhpStorm.
 * User: Li Jianxuan
 * Date: 14-9-19
 * Time: 下午3:21
 */

namespace Westdc\User;

use Zend\ServiceManager\ServiceManager;
use Zend\ServiceManager\ServiceManagerAwareInterface;

class Status implements ServiceManagerAwareInterface{

    protected $serviceManager;

    private $db;

    public function setServiceManager(ServiceManager $serviceManager)
    {
        $this->serviceManager = $serviceManager;

        $this->init();

        return $this;
    }

    private function init()
    {
        $dbService = $this->serviceManager->get('Db');
        $this->db = $dbService->getPdo();
    }


    public function getUserCount(){

        $sql="select count(id) as total from users";
        $uq=$this->db->query($sql);

        return $uq->fetchColumn(0);

    }

    public function getAdminCount(){

        $sql="select count(id) as total from users where usertype='administrator'";
        $uq=$this->db->query($sql);

        return $uq->fetchColumn(0);

    }

}