/** * Looks for an entry with the 'magic_winner' flag set and returns it, otherwise it returns null */ public static function check_magic_winner($term) { $now = time(); $query = "SELECT * 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 term={$term}) as foo ON hms_new_application.username = foo.asu_username\n WHERE foo.asu_username IS NULL AND (hms_lottery_application.invite_expires_on < {$now} OR hms_lottery_application.invite_expires_on IS NULL)\n AND hms_new_application.term = {$term}\n AND hms_lottery_application.magic_winner = 1"; $result = PHPWS_DB::getRow($query); if (PEAR::isError($result)) { PHPWS_Error::log($result); return null; } if (!isset($result) || empty($result)) { return null; } else { return $result; } }
/** * Returns a Department object based on the given department ID. * @param unknown $id * @return Department */ public static function getDepartmentById($id) { // Sanity checking if (!isset($id) || $id === '') { throw new \InvalidArgumentException('Missing department ID.'); } // Query $query = "SELECT * FROM intern_department WHERE id = {$id}"; $result = \PHPWS_DB::getRow($query); if (\PHPWS_Error::isError($result)) { throw new DatabaseException($result->toString()); } if (sizeof($result) == 0) { return null; } // Create the object and set member variables $department = new DepartmentDB(); $department->setId($result['id']); $department->setName($result['name']); $department->setHidden($result['hidden']); $department->setCorequisite($result['corequisite']); return $department; }
public static function getFacultyObjectById($id) { if (!isset($id)) { throw new \InvalidArgumentException('Missing faculty id.'); } $sql = "SELECT intern_faculty.* FROM intern_faculty WHERE intern_faculty.id = {$id}"; $row = \PHPWS_DB::getRow($sql); if (\PHPWS_Error::logIfError($row)) { throw new Exception($row); } $faculty = new FacultyDB(); $faculty->setId($row['id']); $faculty->setUsername($row['username']); $faculty->setFirstName($row['first_name']); $faculty->setLastName($row['last_name']); $faculty->setPhone($row['phone']); $faculty->setFax($row['fax']); $faculty->setStreetAddress1($row['street_address1']); $faculty->setStreetAddress2($row['street_address2']); $faculty->setCity($row['city']); $faculty->setState($row['state']); $faculty->setZip($row['zip']); return $faculty; }
/** * * * * */ function view($showLinks = TRUE) { /* Find the key into the entries array for the selected entry */ foreach ($this->_entries as $entryKey => $entryValue) { if ($entryValue['id'] == $_REQUEST['PHAT_ENTRY_ID']) { break; } } /* Get the data for the selected entry from the database */ $sql = 'SELECT * FROM ' . $this->getFormTable() . " WHERE id='" . $_REQUEST['PHAT_ENTRY_ID'] . "'"; $entry = PHPWS_DB::getRow($sql); $rowClass = NULL; $entryTags = array(); $entryTags['ENTRY_DATA'] = NULL; /* Step through the entries values and feed them through the entryRow template */ $toggle = 1; foreach ($entry as $key => $value) { $rowTags = array(); if ($key == 'position') { continue; } elseif ($key == 'updated') { $value = date(PHPWS_DATE_FORMAT . ' ' . PHPWS_TIME_FORMAT, $value); } $attribute = ' class="bgcolor1" '; /* Toggle the row colors for better visability */ if ($toggle % 2) { $rowClass = $attribute; } else { $rowClass = null; } $toggle++; if (isset($rowClass)) { $rowTags['ROW_CLASS'] = $rowClass; } $rowTags['ENTRY_LABEL'] = $key; if (preg_match('/a:\\d+:{/', $value)) { $rowTags['ENTRY_VALUE'] = implode(', ', unserialize($value)); } else { $rowTags['ENTRY_VALUE'] = PHPWS_Text::parseOutput($value, ENCODE_PARSED_TEXT, false, true); } $entryTags['ENTRY_DATA'] .= PHPWS_Template::processTemplate($rowTags, 'phatform', 'report/entryRow.tpl'); } if (isset($this->archive)) { $entryTags['BACK_LINK'] = $_SESSION['PHAT_advViews']->getArchiveViewLink(); } if ($showLinks && !isset($_REQUEST['lay_quiet'])) { $entryTags['PRINT'] = '<a href="index.php?module=phatform&PHAT_REPORT_OP=view&PHAT_ENTRY_ID=' . $_REQUEST['PHAT_ENTRY_ID'] . '&lay_quiet=1" target="_blank">' . dgettext('phatform', 'Print View') . '</a>'; /* Show the next and/or previous links to step through entries */ if ($entryKey < sizeof($this->_entries) - 1) { $entryTags['NEXT'] = '<a href="index.php?module=phatform&PHAT_REPORT_OP=view&PHAT_ENTRY_ID=' . $this->_entries[$entryKey + 1]['id'] . '">' . dgettext('phatform', 'Next Entry') . '</a>'; } if ($entryKey > 0) { $entryTags['PREVIOUS'] = '<a href="index.php?module=phatform&PHAT_REPORT_OP=view&PHAT_ENTRY_ID=' . $this->_entries[$entryKey - 1]['id'] . '">' . dgettext('phatform', 'Previous Entry') . '</a>'; } } $GLOBALS['CNT_phatform']['title'] = $_SESSION['PHAT_FormManager']->form->getLabel(); /* Return the entire processed entry */ if (isset($_REQUEST['lay_quiet'])) { echo PHPWS_Template::processTemplate($entryTags, 'phatform', 'report/entry.tpl'); } else { return PHPWS_Template::processTemplate($entryTags, 'phatform', 'report/entry.tpl'); } }
private function getMagicWinner() { $query = "SELECT * 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 term = {$this->term}) as foo ON hms_new_application.username = foo.asu_username\n WHERE foo.asu_username IS NULL AND (hms_lottery_application.invited_on IS NULL)\n AND hms_new_application.term = {$this->term}\n AND hms_lottery_application.magic_winner = 1"; $result = PHPWS_DB::getRow($query); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } return $result; }
function _editOptions() { if (Current_User::allow('phatform', 'edit_options')) { if (isset($_REQUEST['PHAT_OptionSetId']) && !is_numeric($_REQUEST['PHAT_OptionSetId']) || isset($_REQUEST['PHAT_OptionBack'])) { $_REQUEST['PHAT_MAN_OP'] = 'Options'; $this->action(); return; } else { $optionSetId = $_REQUEST['PHAT_OptionSetId']; } if (isset($_REQUEST['PHAT_SaveOptionSet'])) { if (is_array($_REQUEST['PHAT_ElementOptions']) && is_array($_REQUEST['PHAT_ElementValues'])) { for ($i = 0; $i < sizeof($_REQUEST['PHAT_ElementOptions']); $i++) { $_REQUEST['PHAT_ElementOptions'][$i] = PHPWS_Text::parseInput($_REQUEST['PHAT_ElementOptions'][$i]); $_REQUEST['PHAT_ElementValues'][$i] = PHPWS_Text::parseInput($_REQUEST['PHAT_ElementValues'][$i]); } $options = addslashes(serialize($_REQUEST['PHAT_ElementOptions'])); $values = addslashes(serialize($_REQUEST['PHAT_ElementValues'])); $saveArray = array('optionSet' => $options, 'valueSet' => $values); $db = new PHPWS_DB('mod_phatform_options'); $db->addWhere('id', $optionSetId); $db->addValue($saveArray); $db->update(); } } else { if (isset($_REQUEST['PHAT_delete'])) { $db = new PHPWS_DB('mod_phatform_options'); $db->addWhere('id', $optionSetId); $db->delete(); $_REQUEST['PHAT_MAN_OP'] = 'Options'; $this->action(); return; } } $GLOBALS['CNT_phatform']['title'] = PHAT_TITLE; $sql = "SELECT * FROM mod_phatform_options WHERE id='{$optionSetId}'"; $result = PHPWS_DB::getRow($sql); if ($result) { $elements = array(); $elements[] = PHPWS_Form::formHidden('module', $this->_module); $elements[] = PHPWS_Form::formHidden('PHAT_MAN_OP', 'editOptions'); $elements[] = PHPWS_Form::formHidden('PHAT_OptionSetId', $optionSetId); $options = unserialize(stripslashes($result['optionSet'])); $values = unserialize(stripslashes($result['valueSet'])); $editTags = array(); $editTags['TITLE'] = dgettext('phatform', 'Edit option set') . " {$result['label']}"; $editTags['NUMBER_LABEL'] = dgettext('phatform', 'Option'); $editTags['INPUT_LABEL'] = dgettext('phatform', 'Text'); $editTags['VALUE_LABEL'] = dgettext('phatform', 'Value'); $editTags['OPTIONS'] = ''; $rowClass = NULL; for ($i = 0; $i < sizeof($options); $i++) { $optionRow['OPTION_NUMBER'] = $i + 1; $optionRow['OPTION_INPUT'] = PHPWS_Form::formTextField("PHAT_ElementOptions[{$i}]", $options[$i], PHAT_DEFAULT_SIZE, PHAT_DEFAULT_MAXSIZE); $optionRow['VALUE_INPUT'] = PHPWS_Form::formTextField("PHAT_ElementValues[{$i}]", $values[$i], PHAT_DEFAULT_SIZE, PHAT_DEFAULT_MAXSIZE); $optionRow['ROW_CLASS'] = $rowClass; if ($i % 2) { $rowClass = ' class="bgcolor1"'; } else { $rowClass = null; } $editTags['OPTIONS'] .= PHPWS_Template::processTemplate($optionRow, 'phatform', 'options/option.tpl'); } } $editTags['BACK_BUTTON'] = PHPWS_Form::formSubmit(dgettext('phatform', 'Back'), 'PHAT_OptionBack'); $editTags['SAVE_BUTTON'] = PHPWS_Form::formSubmit(dgettext('phatform', 'Save'), 'PHAT_SaveOptionSet'); $elements[] = PHPWS_Template::processTemplate($editTags, 'phatform', 'options/optionList.tpl'); return PHPWS_Form::makeForm('PHAT_Options_edit', 'index.php', $elements); } else { $this->_list(); } }