Skip to content
Snippets Groups Projects
Select Git revision
  • ac4404677af6e6dbba8d81fd35a3784efc837acb
  • master default
  • disable-new-requests
  • fix-bulletin-view-missing-notes-error
  • add-missing-queue-managers
  • projects-task-53
  • projects-task-51
  • projects-task-43
  • projects-task-24
  • projects-task-31
  • projects-task-32
  • projects-task-8
  • project-setup-docs
  • projects-task-28
  • projects-task-27
  • projects-task-9
  • projects-task-7
  • mass-update-course-codes-in-sections
  • wdn-four
  • learning-outcomes
  • additional-bulletin-pages
  • svn-redesign
  • svn-popups
  • svn-trunk
  • svn-performance
  • svn-tim
26 results

ReportsController.php

Blame
  • 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());
                }