/** * 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); }