PHP StudentFactory::getStudentByBannerID方法代码示例

 public function execute()
 {
     $db = PdoFactory::getPdoInstance();
     $query = "SELECT hms_assignment.banner_id, hms_hall_structure.room_number, hms_hall_structure.hall_name\n              FROM hms_assignment\n              JOIN hms_hall_structure\n                  ON hms_assignment.bed_id = hms_hall_structure.bedid\n              WHERE\n                hms_assignment.term = :term and\n                roomid IN (SELECT room_id\n                            FROM hms_learning_community_assignment\n                            JOIN hms_learning_community_applications\n                                ON hms_learning_community_assignment.application_id = hms_learning_community_applications.id\n                            JOIN hms_assignment\n                                ON (hms_learning_community_applications.username = hms_assignment.asu_username AND hms_learning_community_applications.term = hms_assignment.term)\n                            JOIN hms_bed\n                                ON hms_assignment.bed_id = hms_bed.id\n                            JOIN hms_room\n                                ON hms_bed.room_id = hms_room.id\n                            WHERE\n                                hms_learning_community_applications.term = :term)\n              ORDER BY roomid";
     $stmt = $db->prepare($query);
     $params = array('term' => $this->term);
     $stmt->execute($params);
     $queryResult = $stmt->fetchAll(PDO::FETCH_ASSOC);
     $results = array();
     $i = 0;
     $count = 0;
     foreach ($queryResult as $result) {
         $tplVals = array();
         $tplVals['BANNER'] = $result['banner_id'];
         $student = StudentFactory::getStudentByBannerID($result['banner_id'], $this->term);
         $tplVals['USERNAME'] = $student->getUsername();
         $tplVals['FIRST_NAME'] = $student->getFirstName();
         $tplVals['LAST_NAME'] = $student->getLastName();
         $membership = RlcMembershipFactory::getMembership($student, $this->term);
         if ($membership) {
             $tplVals['COMMUNITY'] = $membership->getRlcName();
             $count++;
         } else {
             $tplVals['COMMUNITY'] = '';
         }
         $tplVals['HALL'] = $result['hall_name'];
         $tplVals['ROOM'] = $result['room_number'];
         $results[$i] = $tplVals;
         $i++;
     }
     $this->memberCount = $count;
     $this->data = $results;
 }

 public function execute(CommandContext $context)
 {
     if (!UserStatus::isAdmin() || !Current_User::allow('hms', 'assign_by_floor')) {
         PHPWS_Core::initModClass('hms', 'exception/PermissionException.php');
         throw new PermissionException('You do not have permission to assign students by floor.');
     }
     $username = $context->get('username');
     $banner_id = (int) $context->get('banner_id');
     $reason = $context->get('reason');
     $meal_plan = $context->get('meal_plan');
     $bed_id = $context->get('bed_id');
     $term = Term::getSelectedTerm();
     try {
         if ($banner_id) {
             $student = StudentFactory::getStudentByBannerID($banner_id, Term::getSelectedTerm());
         } elseif (!empty($username)) {
             $student = StudentFactory::getStudentByUsername($username, Term::getSelectedTerm());
         } else {
             $context->setContent(json_encode(array('status' => 'failure', 'message' => 'Did not receive Banner ID or user name.')));
             return;
         }
         try {
             HMS_Assignment::assignStudent($student, $term, null, $bed_id, $meal_plan, null, null, $reason);
         } catch (AssignmentException $e) {
             $context->setContent(json_encode(array('status' => 'failure', 'message' => $e->getMessage())));
             return;
         }
         $message = $student->first_name . ' ' . $student->last_name;
         $context->setContent(json_encode(array('status' => 'success', 'message' => $message, 'student' => $student)));
     } catch (\StudentNotFoundException $e) {
         $context->setContent(json_encode(array('status' => 'failure', 'message' => $e->getMessage())));
     }
 }

 public function execute(CommandContext $context)
 {
     if (!UserStatus::isAdmin() || !Current_User::allow('hms', 'search')) {
         PHPWS_Core::initModClass('hms', 'exception/PermissionException.php');
         throw new PermissionException('You do not have permission to lookup student names!');
     }
     $student = null;
     $error = new JsonError(403);
     $username = $context->get('username');
     $banner_id = (int) $context->get('banner_id');
     try {
         if ($banner_id) {
             $student = StudentFactory::getStudentByBannerID($banner_id, Term::getSelectedTerm());
         } elseif (!empty($username)) {
             $student = StudentFactory::getStudentByUsername($username, Term::getSelectedTerm());
         } else {
             $error->setMessage('Did not receive Banner ID or user name.');
             $context->setContent(json_encode($error));
         }
         $student->gender_string = HMS_Util::formatGender($student->gender);
         $context->setContent(json_encode($student));
     } catch (\StudentNotFoundException $e) {
         $error->setMessage($e->getMessage());
         $context->setContent(json_encode($error));
     }
 }

    public function execute(CommandContext $context)
    {
        $newrows = array();
        $pdo = PdoFactory::getPdoInstance();
        $floor_id = (int) $context->get('floorId');
        $query = <<<EOF
select\troom.id as room_id,
\troom.room_number,
\troom.gender_type,
\tbed.id as bed_id,
\tbed.bedroom_label,
\tbed.bed_letter,
\tassign.banner_id,
\tassign.meal_option,
        assign.asu_username
from  \thms_room as room
\tfull join
\t\thms_bed as bed on room.id=bed.room_id
\tfull join
\t\thms_assignment as assign on bed.id=assign.bed_id
where\troom.floor_id = :floor_id
order by room_number asc, bedroom_label, bed_letter;
EOF;
        $prep = $pdo->prepare($query);
        $prep->execute(array(':floor_id' => $floor_id));
        $rows = $prep->fetchAll(PDO::FETCH_ASSOC);
        if (empty($rows)) {
            $context->setContent(json_encode(array()));
            return;
        }
        $count = -1;
        $room_number_track = 0;
        foreach ($rows as $k => $v) {
            $gender = HMS_Util::formatGender($v['gender_type']);
            if ($v['banner_id']) {
                $student = StudentFactory::getStudentByBannerID($v['banner_id'], Term::getSelectedTerm());
                if ($student) {
                    $v['student'] = $student->first_name . ' ' . $student->last_name;
                } else {
                    $v['student'] = null;
                }
            } else {
                $v['student'] = null;
            }
            if ($v['room_number'] != $room_number_track) {
                $count++;
                $newrows[$count]['room_number'] = $v['room_number'];
                $newrows[$count]['gender'] = $gender;
                $newrows[$count]['beds'][] = $v;
                $room_number_track = $v['room_number'];
            } else {
                $newrows[$count]['beds'][] = $v;
            }
        }
        $context->setContent(json_encode($newrows));
    }

 public function execute(CommandContext $context)
 {
     PHPWS_Core::initModClass('hms', 'StudentFactory.php');
     PHPWS_Core::initModClass('hms', 'RoommateProfile.php');
     PHPWS_Core::initModClass('hms', 'RoommateProfileView.php');
     $student = StudentFactory::getStudentByBannerID($context->get('banner_id'), $context->get('term'));
     $profile = RoommateProfileFactory::getProfile($context->get('banner_id'), $context->get('term'));
     $view = new RoommateProfileView($student, $profile);
     $context->setContent($view->show());
 }

 public function execute()
 {
     PHPWS_Core::initModClass('hms', 'PdoFactory.php');
     $db = PdoFactory::getInstance()->getPdo();
     $query = 'SELECT hms_assignment.banner_id, hms_assignment.reason,
               hms_hall_structure.hall_name, hms_hall_structure.room_number, hms_hall_structure.bed_letter
               FROM hms_assignment
               JOIN hms_hall_structure ON hms_assignment.bed_id = hms_hall_structure.bedid
               WHERE hms_assignment.banner_id
               NOT IN (SELECT hms_assignment.banner_id
                       FROM hms_assignment
                       JOIN hms_bed ON hms_assignment.bed_id = hms_bed.id
                       JOIN hms_checkin ON hms_bed.persistent_id = hms_checkin.bed_persistent_id
                       WHERE hms_assignment.bed_id = hms_checkin.bed_id
                       AND hms_assignment.banner_id = hms_checkin.banner_id
                       AND hms_assignment.term = :term)
               AND hms_assignment.term = :term';
     $stmt = $db->prepare($query);
     $stmt->execute(array('term' => $this->term));
     $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
     $rows = array();
     $i = 0;
     foreach ($results as $row) {
         $rowVals = array();
         $student = StudentFactory::getStudentByBannerID($row['banner_id'], $this->term);
         $rowVals['banner_id'] = $row['banner_id'];
         $rowVals['username'] = $student->getUsername();
         $rowVals['name'] = $student->getFullName();
         $rowVals['class'] = $student->getClass();
         $rowVals['reason'] = constant($row['reason']);
         $rowVals['hall_name'] = $row['hall_name'];
         $rowVals['room_number'] = $row['room_number'];
         $rowVals['bed_letter'] = $row['bed_letter'];
         $rows[$i] = $rowVals;
         $i++;
     }
     $this->total = $i;
     $this->data = $rows;
 }

 public function get_assignee()
 {
     PHPWS_Core::initModClass('hms', 'StudentFactory.php');
     if (!$this->loadAssignment()) {
         return false;
     }
     if (!isset($this->_curr_assignment->banner_id)) {
         return NULL;
     } else {
         return StudentFactory::getStudentByBannerID($this->_curr_assignment->getBannerId(), $this->term);
     }
 }

 /**
  * Pulls the assignment history for the current bed and plugs in the student profile link.
  * Returns null if no history is found.
  * @return array
  */
 private function getBedHistoryArray()
 {
     $db = \Database::newDB();
     $t1 = $db->addTable('hms_assignment_history');
     $t1->addFieldConditional('bed_id', $this->bed->id);
     /*
      if (isset($this->bed->_curr_assignment)) {
      $t1->addFieldConditional('banner_id', $this->bed->_curr_assignment->banner_id, '!=');
      }
     *
     */
     $t1->addOrderBy('assigned_on', 'DESC');
     $result = $db->select();
     if (empty($result)) {
         return null;
     }
     foreach ($result as $key => $assignment) {
         $student = StudentFactory::getStudentByBannerID($assignment['banner_id'], $this->bed->getTerm());
         $result[$key]['assigned_on_date'] = HMS_Util::get_short_date_time($assignment['assigned_on']);
         if (empty($assignment['removed_on'])) {
             $result[$key]['removed_on_date'] = 'Never';
         } else {
             $result[$key]['removed_on_date'] = HMS_Util::get_short_date_time($assignment['removed_on']);
         }
         $result[$key]['student'] = $student->getProfileLink();
     }
     return $result;
 }

 /**
  * Sends the appropriate emails for an officially denied room change request.
  *
  * @param $r RoomChangeRequest The Room Change Request that has been denied
  */
 public static function sendRoomChangeDeniedNotice(RoomChangeRequest $r)
 {
     $subject = 'Room Change Denied';
     $template = 'email/roomChangeDeniedNotice.tpl';
     $recipients = array();
     $tags = array('PARTICIPANTS' => array());
     $reason = $r->getDeniedReasonPublic();
     if (!is_null($reason) && !empty($reason)) {
         $tags['REASON'] = $reason;
     }
     // Add information about participants, also add each participant to recipients
     foreach ($r->getParticipants() as $p) {
         $student = StudentFactory::getStudentByBannerID($p->getBannerID(), $r->getTerm());
         $recipients[] = $student;
         $tags['PARTICIPANTS'][] = array('NAME' => $student->getName());
     }
     // Add any approvers that may have seen the previous email to recipients
     foreach ($r->getAllPotentialApprovers() as $a) {
         $recipients[] = array($a . TO_DOMAIN => '');
     }
     // Send a message per recipient
     $message = self::makeSwiftmailMessage(null, $subject, $tags, $template);
     foreach ($recipients as $r) {
         if ($r instanceof Student) {
             $message->setTo($r->getUsername() . TO_DOMAIN);
         } else {
             $message->setTo($r);
         }
         self::sendSwiftmailMessage($message);
     }
 }

 /**
  * Sets up the row tags for the pager
  *
  * @return Array Array of template tags.
  */
 public function getPagerTags()
 {
     $student = StudentFactory::getStudentByBannerID($this->banner_id, $this->term);
     $tags = array();
     $tags['STUDENT_ID'] = $student->getUsername() . "@appstate.edu";
     $tags['FIRST_NAME'] = $student->getFirstName();
     $tags['LAST_NAME'] = $student->getLastName();
     $viewProfileCmd = CommandFactory::getCommand('ShowRoommateProfile');
     $viewProfileCmd->setBannerid($student->getBannerId());
     $viewProfileCmd->setTerm($this->term);
     $tags['ACTIONS'] = $viewProfileCmd->getLink('[View Profile]');
     return $tags;
 }