PHP PHPWS_DB::getCol方法代码示例

 /**
  * Main searching function. Does the database lookup and then checks each student though the various functions.
  */
 public function doSearch()
 {
     // Clear all the caches
     StudentDataProvider::clearAllCache();
     $term = $this->term;
     $query = "select DISTINCT * FROM (select hms_new_application.username from hms_new_application WHERE term={$term} AND cancelled != 1 UNION select hms_assignment.asu_username from hms_assignment WHERE term={$term}) as foo";
     $result = PHPWS_DB::getCol($query);
     if (PHPWS_Error::logIfError($result)) {
         throw new Exception($result->toString());
     }
     foreach ($result as $username) {
         $student = null;
         try {
             $student = StudentFactory::getStudentByUsername($username, $term);
         } catch (Exception $e) {
             $this->actions[$username][] = 'WARNING!! Unknown student!';
             // Commenting out the NQ line, since this doesn't work when the search is run from cron/Pulse
             //NQ::simple('hms', hms\NotificationView::WARNING, 'Unknown student: ' . $username);
             continue;
         }
         if ($student->getType() != TYPE_WITHDRAWN && $student->getAdmissionDecisionCode() != ADMISSION_WITHDRAWN_PAID && $student->getAdmissionDecisionCode() != ADMISSION_RESCIND) {
             continue;
         }
         $this->actions[$username][] = $student->getBannerId() . ' (' . $student->getUsername() . ')';
         $this->withdrawnCount++;
         $this->handleApplication($student);
         $this->handleAssignment($student);
         $this->handleRoommate($student);
         $this->handleRlcAssignment($student);
         $this->handleRlcApplication($student);
     }
 }

 /**
  * Returns a list of usernames which are currently on the waiting list
  * (has a valid housing application, not assigned)
  *
  * @param unknown $term
  * @throws DatabaseException
  * @return unknown
  */
 public static function getRemainingWaitListApplications($term)
 {
     // Get the list of user names still on the waiting list, sorted by ID (first come, first served)
     $sql = "SELECT username FROM hms_new_application JOIN hms_lottery_application ON hms_new_application.id = hms_lottery_application.id\n                    LEFT OUTER JOIN (SELECT asu_username FROM hms_assignment WHERE hms_assignment.term={$term}) as foo ON hms_new_application.username = foo.asu_username\n                    WHERE foo.asu_username IS NULL\n                    AND hms_new_application.term = {$term}\n                    AND special_interest IS NULL\n                    AND waiting_list_date IS NOT NULL\n                    ORDER BY application_term DESC, hms_new_application.id ASC";
     $applications = PHPWS_DB::getCol($sql);
     if (PHPWS_Error::logIfError($applications)) {
         throw new DatabaseException($applications->toString());
     }
     return $applications;
 }

 function _getIds()
 {
     if (isset($this->_table)) {
         $table = $this->_table;
     } else {
         $table = $this->_tables[$this->listName];
     }
     $sql = 'SELECT id FROM ' . $table;
     $sort = $this->getSort();
     if (isset($sort)) {
         $sql .= $sort;
     }
     $order = $this->getOrder();
     if (isset($order)) {
         $sql .= $order;
     }
     return PHPWS_DB::getCol($sql);
 }