/**
* Creates a dataset that contains information about area request status in the given project over
* time.
*
* @param Project $project
* @return StatDateDataset
*/
public function fetchAreaRequestTimeData(Project $project)
{
$data = $this->conn->fetchAll('SELECT * FROM `' . CoreTables::STAT_ARQ_TIME_TBL . '` WHERE `projectId` = :projectId ORDER BY `datePoint`', [':projectId' => $project->getId()]);
$engine = new StatDateDataset(StatDateDataset::TYPE_PACKED);
return $engine->dataset('requestsNew')->dataset('requestsVerification')->dataset('requestsApproved')->dataset('requestsRejected')->process($data);
}
/**
* Creates a dataset that contains information about participant numbers over time within a
* single area.
*
* @param Area $area
* @return StatDateDataset
*/
public function fetchAreaParticipantsOverTime(Area $area)
{
$data = $this->conn->fetchAll('SELECT * FROM `' . EdkTables::STAT_AREA_PARTICIPANT_TIME_TBL . '` ' . 'WHERE `projectId` = :projectId AND `areaId` = :areaId ' . 'ORDER BY `datePoint`', [':projectId' => $area->getProject()->getId(), ':areaId' => $area->getId()]);
$engine = new StatDateDataset(StatDateDataset::TYPE_PACKED);
return $engine->dataset('participantNum')->process($data);
}
