Select Git revision
ReportsController.php
ReportsController.php 2.85 KiB
<?php
class ReportsController extends Nmc_Controller_Action
{
public function indexAction()
{
header('Location: /Reports/ApprovedCourses/');
}
public function approvedCoursesAction()
{
$in = $this->getRequest();
$year = $in->getParam(0);
$month = $in->getParam(1);
$view = new Application_View();
$view->page = 'approvedCourses';
if ($year > 2000) {
$date = new Zend_Date();
$date->setYear($year);
$date->setMonth($month);
$date->setDay(1);
$date->setHour(0);
$date->setMinute(0);
$date->setSecond(0);
$startDate = $date;
$endDate = clone $date;
$endDate->addMonth(1);
$endDate->subSecond(1);
$requests = Requests::getInstance()->fetchRequestsInDateRange($startDate, $endDate);
//$requests = Requests::getInstance()->fetchAllSorted('state = "approve"', Requests::COMPLETED_REQUESTS_ONLY);
$uccVote = ApprovalActionsAbstract::getInstance()->fetchRow('name = "UCC Voting"');
$requestData = array();
$requestData['subject'] = array();
$requestData['courseNumber'] = array();
$requestData['courseLetter'] = array();
$requestData['counter'] = array();
$requestData['request'] = array();
$i = 0;
foreach ($requests as $index => $request) {
$course = $request->getCourseGeneration();
$originalCourse = $course->getParentGeneration(true);
if (!$originalCourse) {
$originalCourse = $course;
}
$votes = ApproverVotes::getInstance()->fetchByRequestAndAction(
$request,
$uccVote
);
$requestData['subject'][] = $originalCourse->subject;
$requestData['courseNumber'][] = $originalCourse->courseNumber;
$requestData['courseLetter'][] = $originalCourse->courseLetter;
$requestData['counter'][] = $i++;
$requestData['requestData'][] = array('request' => $request,
'voteTally' => $votes->getTally());
}