Anzahl Registrierungen der laufenden Woche nach Tagen anzeigen
<?php
defined('_JEXEC') or die;
$dateTime = \JFactory::getDate('now', 'GMT');
$lastMonday = clone $dateTime->modify(
$dateTime->format('l') == 'Sunday' ? 'Monday last week' : 'Monday this week'
);
$lastMonday = $lastMonday->toSql();
$db = \JFactory::getDbo();
$query = $db->getQuery(true)
->select($db->qn('registerDate'))
->from($db->qn('#__users'))
->where($db->qn('block') . '= 0')
->where($db->qn('registerDate') . '>=' . $db->q($lastMonday))
;
$db->setQuery($query);
$registerDates = $db->loadObjectList();
$days = array(
'Monday' => 0,
'Tuesday' => 0,
'Wednesday' => 0,
'Thursday' => 0,
'Friday' => 0,
'Saturday' => 0,
'Sunday' => 0,
);
foreach ($registerDates as $Date)
{
$day = date('l', strtotime($Date->registerDate));
$days[$day]++;
}
$html = array();
$html[] = '<ul>';
foreach ($days as $day => $count)
{
$html[] = '<li>' . JText::_(strtoupper($day)) . ': ' . $count . '</li>';
}
$html[] = '</ul>';
echo implode("\n", $html);