<?php
$wdUses = array();
$ssUses = array();
$monthArray = array();
$subTime = date('Y-m-d', strtotime('-1 years'));
$currentTime = date('Y-m-d');
echo $subTime;
$wdLog = AuditLog::findAllInDateRangeWithProductIdsAndActionId(date('y-m-d h', $subTime) ,$currentTime, 1, 1);
$ssLog = AuditLog::findAllInDateRangeWithProductIdsAndActionId(date('y-m-d h', $subTime) ,$currentTime, 3, 1);
for($i = 0; $i < 12; $i++)
{
$startTime = date('Y-m-d', strtotime('-$i months'));
$endTime = date('Y-m-d', strtotime('-($i +1) months'));
foreach ($wdLog as $log)
{
if( $log->getDateTime() >= $subtime && $log->getDateTime() < $endTime )
{
++$wdUses[$i];
}
}
foreach ($ssLog as $log)
{
if( $log->getDateTime() >= $subtime && $log->getDateTime() < $endTime )
{
++$ssUses[$i];
}
}
$monthArray[$i] = $startTime();
}
$wdUses = json_encode($wdUses);
$ssUses = json_encode($ssUses);
$monthArray = json_encode($monthArray);
echo $wdUses;
?>
preferences:
76.74 ms | 402 KiB | 5 Q