Back to PhocacartStatistics class

Method getNumberOfUsers

public
getNumberOfUsers
(mixed $numberOfDate = -1, mixed $dateFrom = '', mixed $dateTo = '')

Method getNumberOfUsers - Source code

public function getNumberOfUsers($numberOfDate = -1, $dateFrom = '', $dateTo = '')
{
    if ($numberOfDate == -1) {
        $numberOfDate = 7;
    }
    if ($dateFrom == '') {
        $dateFrom = PhocacartDate::getCurrentDate($numberOfDate);
    }
    if ($dateTo == '') {
        $dateTo = PhocacartDate::getCurrentDate();
    }
    $db = Factory::getDbo();
    $q = 'SELECT COUNT(DISTINCT(a.user_id)) FROM #__phocacart_orders AS a WHERE a.published = 1';
    $q .= ' AND DATE(a.date) >= ' . $db->quote($dateFrom) . ' AND DATE(a.date) <= ' . $db->quote($dateTo);
    $whereOrderStatus = '';
    if (!PhocacartStatistics::setWhereByOrderStatus($whereOrderStatus)) {
        return 0;
    }
    if ($whereOrderStatus != '') {
        $q .= 'AND ' . $whereOrderStatus;
    }
    $db->setQuery($q);
    $count = $db->loadRow();
    if (isset($count[0]) && (int) $count[0] != 0) {
        return PhocacartStatistics::abreviateNumbers($count[0]);
    }
    return 0;
}