public function execute(CommandContext $context) { // Check for report ID $reportId = $context->get('reportId'); if (!isset($reportId) || is_null($reportId)) { throw new InvalidArgumentException('Missing report id.'); } PHPWS_Core::initModClass('hms', 'ReportFactory.php'); // Load the report to get its class try { $report = ReportFactory::getReportById($reportId); } catch (InvalidArgumentException $e) { NQ::simple('hms', hms\NotificationView::SUCCESS, 'Report canceled.'); $context->goBack(); } $db = new PHPWS_DB('hms_report'); $db->addWhere('id', $reportId); $result = $db->delete(); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } NQ::simple('hms', hms\NotificationView::SUCCESS, 'Report canceled.'); $cmd = CommandFactory::getCommand('ShowReportDetail'); $cmd->setReportClass($report->getClass()); $cmd->redirect(); }
/** * unregisters deleted keys from menu * * @author Matthew McNaney <mcnaney at gmail dot com> * @version $Id$ */ function menu_unregister_key(Key $key) { PHPWS_Core::initModClass('menu', 'Menu_Link.php'); if (empty($key) || empty($key->id)) { return FALSE; } $db = new PHPWS_DB('menu_links'); $db->addWhere('key_id', $key->id); $result = $db->delete(); if (PHPWS_Error::isError($result)) { PHPWS_Error::log($result); } $db2 = new PHPWS_DB('menu_assoc'); $db2->addWhere('key_id', $key->id); $result = $db2->delete(); if (PHPWS_Error::isError($result)) { PHPWS_Error::log($result); } $db3 = new PHPWS_DB('menus'); $db3->addWhere('assoc_key', $key->id); $db3->addValue('assoc_key', 0); $db3->addValue('assoc_url', null); $db3->update(); return true; }
public function delete() { $db = new PHPWS_DB('analytics_tracker'); $db->addWhere('id', $this->id); $result = $db->delete(); if (PHPWS_Error::logIfError($result)) { return $result; } }
/** * unregisters deleted keys from search * * @author Matthew McNaney <mcnaney at gmail dot com> * @version $Id$ */ function search_unregister_key(Key $key) { if (empty($key->id)) { return FALSE; } $db = new PHPWS_DB('search'); $db->addWhere('key_id', (int) $key->id); return $db->delete(); }
/** * @author Matthew McNaney <mcnaney at gmail dot com> * @version $Id$ */ function calendar_uninstall(&$content) { PHPWS_Core::initModClass('calendar', 'Schedule.php'); // Need functions to remove old event tables $db = new PHPWS_DB('calendar_schedule'); $schedules = $db->getObjects('Calendar_Schedule'); if (PHPWS_Error::isError($schedules)) { return $schedules; } elseif (empty($schedules)) { $result = PHPWS_DB::dropTable('calendar_schedule'); if (PHPWS_Error::isError($result)) { return $result; } $result = PHPWS_DB::dropTable('calendar_notice'); if (PHPWS_Error::isError($result)) { return $result; } $result = PHPWS_DB::dropTable('calendar_suggestions'); if (PHPWS_Error::isError($result)) { return $result; } return true; } $error = false; foreach ($schedules as $sch) { $result = $sch->delete(); if (PHPWS_Error::isError($result)) { PHPWS_Error::log($result); $error = true; } } $result = PHPWS_DB::dropTable('calendar_schedule'); if (PHPWS_Error::isError($result)) { return $result; } $result = PHPWS_DB::dropTable('calendar_notice'); if (PHPWS_Error::isError($result)) { return $result; } $result = PHPWS_DB::dropTable('calendar_suggestions'); if (PHPWS_Error::isError($result)) { return $result; } if (PHPWS_DB::isTable('converted')) { $db2 = new PHPWS_DB('converted'); $db2->addWhere('convert_name', array('schedule', 'calendar')); $db2->delete(); $content[] = dgettext('calendar', 'Removed convert flag.'); } if (!$error) { $content[] = dgettext('calendar', 'Calendar tables removed.'); } else { $content[] = dgettext('calendar', 'Some errors occurred when uninstalling Calendar.'); } return true; }
/** * Deletes this item from the queue */ public function delete() { $db = new PHPWS_DB('hms_banner_queue'); $db->addWhere('id', $this->id); $result = $db->delete(); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } return TRUE; }
public function delete() { $db = new PHPWS_DB('hms_movein_time'); $db->addWhere('id', $this->id); $result = $db->delete(); if (!$result || PHPWS_Error::logIfError($result)) { return false; } return true; }
public function delete() { $db = new PHPWS_DB('hms_roommate'); $db->addWhere('id', $this->id); $result = $db->delete(); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } $this->id = 0; return true; }
public function delete() { $db = new PHPWS_DB('checkin_reasons'); $db->addWhere('id', $this->id); $result = !PHPWS_Error::logIfError($db->delete()); if ($result) { $db = new PHPWS_DB('checkin_rtos'); $db->addWhere('reason_id', $this->id); return !PHPWS_Error::logIfError($db->delete()); } return false; }
public function delete() { $db = new PHPWS_DB('hms_summer_application'); $db->addWhere('id', $this->id); $result = $db->delete(); if (!$result || PHPWS_Error::logIfError($result)) { return $result; } if (!parent::delete()) { return false; } return TRUE; }
/** * Deletes the passed in EmergencyContact from the database. * @param EmergencyContact $contact * @throws InvalidArgumentException * @throws Exception */ public static function delete(EmergencyContact $contact) { $contactId = $contact->getId(); if (is_null($contactId) || !isset($contactId)) { throw new \InvalidArgumentException('Missing contact id.'); } $db = new \PHPWS_DB('intern_emergency_contact'); $db->addWhere('id', $contactId); $result = $db->delete(); if (\PHPWS_Error::logIfError($result)) { throw new \Exception($result->toString()); } return true; }
/** * @author Matthew McNaney <mcnaney at gmail dot com> * @version $Id$ */ function rss_unregister($module, &$content) { $db = new PHPWS_DB('rssfeeds'); $db->addWhere('module', $module); $result = $db->delete(); if (PHPWS_Error::isError($result)) { PHPWS_Error::log($result); $content[] = dgettext('rss', 'An error occurred trying to unregister this module from RSSFeeds.'); return FALSE; } else { $content[] = dgettext('rss', 'Module unregistered from RSSFeeds.'); return TRUE; } }
function purgeProperties() { $last_purge = \PHPWS_Settings::get('properties', 'last_purge') + 86400; $current_time = time(); if ($last_purge < $current_time) { \PHPWS_Settings::set('properties', 'last_purge', $current_time); \PHPWS_Settings::save('properties'); $db = new PHPWS_DB('properties'); $db->addWhere('timeout', time(), '<'); $db->addValue('active', 0); $db->update(); $db = new PHPWS_DB('prop_roommate'); $db->addWhere('timeout', time(), '<'); $db->delete(); } }
public function delete() { if (!Current_User::allow('hms', 'remove_rlc_members')) { PHPWS_Core::initModClass('hms', 'exception/PermissionException.php'); throw new PermissionException('You do not have permission to remove RLC members.'); } if (!isset($this->id)) { return FALSE; } $db = new PHPWS_DB('hms_learning_community_assignment'); $db->addWhere('id', $this->id); $result = $db->delete(); if (PHPWS_Error::logIfError($result)) { return FALSE; } $this->id = 0; return TRUE; }
/** * Queues a Remove Assignment * * NOTE: If the queue contains a Create Assignment for the same * user to the same room, this will NOT queue a room assignment, * but rather will delete the original assignment, UNLESS the * $force_queue flag is set. The $force_queue flag being true will * queue a removal no matter what. * * MORE NOTE: If this requires immediate processing because banner * commits are enabled, the it will be sent straight to Banner, * and so the force_queue flag will be ignored. */ public static function queueRemoveAssignment(Student $student, $term, HMS_Residence_Hall $hall, HMS_Bed $bed, $refund) { $entry = new BannerQueueItem(0, BANNER_QUEUE_REMOVAL, $student, $term, $hall, $bed, null, null, $refund); if (BannerQueue::processImmediately($term)) { return $entry->process(); } // Otherwise, look for an corresponding assignment $db = new PHPWS_DB('hms_banner_queue'); $db->addWhere('type', BANNER_QUEUE_ASSIGNMENT); $db->addWhere('asu_username', $student->getUsername()); $db->addWhere('building_code', $hall->getBannerBuildingCode()); $db->addWhere('bed_code', $bed->getBannerId()); $db->addWhere('term', $term); $result = $db->count(); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } if ($result == 0) { return $entry->save(); } else { return $db->delete(); } }
public function removeUser($username, $classname = null, $instanceId = null) { $db = new PHPWS_DB('users'); $db->addWhere('username', $username); $result = $db->select('row'); if (PHPWS_Error::logIfError($result) || is_null($result['id'])) { return false; } $user_id = $result['id']; $db = new PHPWS_DB('hms_user_role'); $db->addWhere('user_id', $user_id); $db->addWhere('role', $this->id); if (!is_null($classname)) { $db->addWhere('class', strtolower($classname)); } if (!is_null($instanceId)) { $db->addWhere('instance', $instanceId); } $result = $db->delete(); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } return true; }
public static function postMeta() { $values['page_title'] = strip_tags($_POST['page_title']); $values['meta_keywords'] = strip_tags($_POST['meta_keywords']); $values['meta_description'] = strip_tags($_POST['meta_description']); if (isset($_POST['index'])) { $index = 1; } else { $index = 0; } if (isset($_POST['follow'])) { $follow = 1; } else { $follow = 0; } PHPWS_Settings::set('layout', 'use_key_summaries', (int) isset($_POST['use_key_summaries'])); PHPWS_Settings::save('layout'); $values['meta_robots'] = $index . $follow; if (isset($_POST['key_id'])) { $key_id = (int) $_POST['key_id']; } if (isset($key_id)) { $values['key_id'] = $key_id; $db = new PHPWS_DB('layout_metatags'); $db->addWhere('key_id', $key_id); $db->delete(); if (isset($_POST['reset'])) { return true; } $db->reset(); $db->addValue($values); return $db->insert(); } else { $db = new PHPWS_DB('layout_config'); $db->addValue($values); return $db->update(); } }
public function saveDependencies() { if (!$this->_dependency) { return true; } $db = new PHPWS_DB('dependencies'); $db->addWhere('source_mod', $this->title); $db->delete(); $db->reset(); $dep_list = $this->getDependencies(); if (empty($dep_list)) { return null; } foreach ($dep_list['MODULE'] as $stats) { $db->addValue('source_mod', $this->title); $db->addValue('depended_on', $stats['TITLE']); $db->addValue('version', $stats['VERSION']); $result = $db->insert(); if (PHPWS_Error::isError($result)) { return $result; } } }
public static function resetDefaultBoxes() { $db = new PHPWS_DB('layout_box'); $db->addWhere('theme', Layout::getDefaultTheme()); $result = $db->delete(); if (PHPWS_Error::isError($result)) { PHPWS_Error::log($result); } }
/** * Unregisters a module by pulling current keys and * deleting them individually. Although this takes longer * than simply wiping the table, it cleans up old associations. Function * also removes the module from the phpws_key_register table. * Returns true is all is well, false if there was a problem cleaning * up the associations, and an error object if a major problem occurred. */ public static function unregisterModule($module) { $error_free = true; $db1 = new PHPWS_DB('phpws_key'); $db1->addWhere('module', $module); $result = $db1->getObjects('Key'); if (PHPWS_Error::isError($result)) { return $result; } if (!empty($result)) { foreach ($result as $key) { $result = $key->delete(); if (!$result) { $error_free = false; } } } $db2 = new PHPWS_DB('phpws_key_register'); $db2->addWhere('module', $module); $result = $db2->delete(); if (PHPWS_Error::isError($result)) { return $result; } return $error_free; }
public function save() { if (empty($this->key_id) || empty($this->keywords)) { return FALSE; } $db = new PHPWS_DB('search'); $db->addWhere('key_id', $this->key_id); $db->delete(); $db->reset(); $key = new Key($this->key_id); $db->addValue('key_id', $key->id); $db->addValue('module', $key->module); $db->addValue('created', $key->create_date); if (is_array($this->keywords)) { $keywords = implode(' ', $this->keywords); } else { $keywords = $this->keywords; } $db->addValue('keywords', $keywords); return $db->insert(); }
/** * Unregisters a module's settings */ public static function unregister($module) { $db = new PHPWS_DB('mod_settings'); $db->addWhere('module', $module); return $db->delete(); }
public function deleteAssoc() { $db = new PHPWS_DB('fc_file_assoc'); $db->addWhere('file_type', FC_MEDIA); $db->addWhere('file_id', $this->id); return $db->delete(); }
public static function lockBlock($block_id, $key_id) { $block_id = (int) $block_id; $key_id = (int) $key_id; unset($_SESSION['Pinned_Blocks'][$block_id]); $values['block_id'] = $block_id; $values['key_id'] = $key_id; $db = new PHPWS_DB('block_pinned'); $db->addWhere($values); $result = $db->delete(); $db->addValue($values); return $db->insert(); }
public function delete() { if (!$this->id) { throw new \Exception('Missing contact id'); } $c_db = new \PHPWS_DB('prop_contacts'); $c_db->addWhere('id', $this->id); $result = $c_db->delete(); if (\PEAR::isError($result)) { \PHPWS_Error::log($result); throw new \Exception('Could not delete contact from database.'); } $p_db = new \PHPWS_DB('properties'); $p_db->addWhere('contact_id', $this->id); $result = $p_db->delete(); if (\PEAR::isError($result)) { \PHPWS_Error::log($result); throw new \Exception('Could not delete contact properties from database.'); } $i_db = new \PHPWS_DB('prop_photo'); $i_db->addWhere('cid', $this->id); $result = $i_db->delete(); if (\PEAR::isError($result)) { \PHPWS_Error::log($result); throw new \Exception('Could not delete contact photos from database.'); } $dir = 'images/properties/c' . $this->id; \PHPWS_File::rmdir($dir); return true; }
/** * Deletes a branch from the hub's database */ public function delete() { $db = new PHPWS_DB('branch_sites'); $db->addWhere('id', $this->id); $result = $db->delete(); if (PHPWS_Error::isError($result)) { PHPWS_Error::log($result); return false; } return true; }
public function delete() { if ($this->id) { $db = new \PHPWS_DB('properties'); $db->addWhere('id', $this->id); if (\PEAR::isError($db->delete())) { throw new \Exception('Error occurred during deletion.'); } } }
public function delete() { if (is_null($this->id) || !isset($this->id)) { throw new InvalidArgumentException('Invalid bed id.'); } $db = new PHPWS_DB('hms_bed'); $db->addWhere('id', $this->id); $result = $db->delete(); if (!$result || PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } return true; }
public function kill() { $theme_var = $this->getThemeVar(); $theme = $this->getTheme(); $db = new PHPWS_DB('layout_box'); $db->addWhere('id', $this->getId()); $result = $db->delete(); if (PHPWS_Error::isError($result)) { return $result; } Layout_Box::reorderBoxes($theme, $theme_var); }
public function unpinFolder() { if (!isset($_REQUEST['folder_id']) || !isset($_REQUEST['key_id'])) { return; } $folder_id = (int) $_REQUEST['folder_id']; $key_id = (int) $_REQUEST['key_id']; $db = new PHPWS_DB('filecabinet_pins'); $db->addWhere('folder_id', $folder_id); $db->addWhere('key_id', $key_id); $db->delete(); }