/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aNagiosTimeperiodRelatedByTimeperiodId !== null) { if ($this->aNagiosTimeperiodRelatedByTimeperiodId->isModified() || $this->aNagiosTimeperiodRelatedByTimeperiodId->isNew()) { $affectedRows += $this->aNagiosTimeperiodRelatedByTimeperiodId->save($con); } $this->setNagiosTimeperiodRelatedByTimeperiodId($this->aNagiosTimeperiodRelatedByTimeperiodId); } if ($this->aNagiosTimeperiodRelatedByExcludedTimeperiod !== null) { if ($this->aNagiosTimeperiodRelatedByExcludedTimeperiod->isModified() || $this->aNagiosTimeperiodRelatedByExcludedTimeperiod->isNew()) { $affectedRows += $this->aNagiosTimeperiodRelatedByExcludedTimeperiod->save($con); } $this->setNagiosTimeperiodRelatedByExcludedTimeperiod($this->aNagiosTimeperiodRelatedByExcludedTimeperiod); } if ($this->isNew()) { $this->modifiedColumns[] = NagiosTimeperiodExcludePeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = NagiosTimeperiodExcludePeer::doInsert($this, $con); $affectedRows += 1; // we are assuming that there is only 1 row per doInsert() which // should always be true here (even though technically // BasePeer::doInsert() can insert multiple rows). $this->setId($pk); //[IMV] update autoincrement primary key $this->setNew(false); } else { $affectedRows += NagiosTimeperiodExcludePeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } $this->alreadyInSave = false; } return $affectedRows; }
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aNagiosCommandRelatedByCheckCommand !== null) { if ($this->aNagiosCommandRelatedByCheckCommand->isModified() || $this->aNagiosCommandRelatedByCheckCommand->isNew()) { $affectedRows += $this->aNagiosCommandRelatedByCheckCommand->save($con); } $this->setNagiosCommandRelatedByCheckCommand($this->aNagiosCommandRelatedByCheckCommand); } if ($this->aNagiosCommandRelatedByEventHandler !== null) { if ($this->aNagiosCommandRelatedByEventHandler->isModified() || $this->aNagiosCommandRelatedByEventHandler->isNew()) { $affectedRows += $this->aNagiosCommandRelatedByEventHandler->save($con); } $this->setNagiosCommandRelatedByEventHandler($this->aNagiosCommandRelatedByEventHandler); } if ($this->aNagiosTimeperiodRelatedByCheckPeriod !== null) { if ($this->aNagiosTimeperiodRelatedByCheckPeriod->isModified() || $this->aNagiosTimeperiodRelatedByCheckPeriod->isNew()) { $affectedRows += $this->aNagiosTimeperiodRelatedByCheckPeriod->save($con); } $this->setNagiosTimeperiodRelatedByCheckPeriod($this->aNagiosTimeperiodRelatedByCheckPeriod); } if ($this->aNagiosTimeperiodRelatedByNotificationPeriod !== null) { if ($this->aNagiosTimeperiodRelatedByNotificationPeriod->isModified() || $this->aNagiosTimeperiodRelatedByNotificationPeriod->isNew()) { $affectedRows += $this->aNagiosTimeperiodRelatedByNotificationPeriod->save($con); } $this->setNagiosTimeperiodRelatedByNotificationPeriod($this->aNagiosTimeperiodRelatedByNotificationPeriod); } if ($this->isNew()) { $this->modifiedColumns[] = NagiosHostPeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = NagiosHostPeer::doInsert($this, $con); $affectedRows += 1; // we are assuming that there is only 1 row per doInsert() which // should always be true here (even though technically // BasePeer::doInsert() can insert multiple rows). $this->setId($pk); //[IMV] update autoincrement primary key $this->setNew(false); } else { $affectedRows += NagiosHostPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } if ($this->collNagiosServices !== null) { foreach ($this->collNagiosServices as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosHostContactMembers !== null) { foreach ($this->collNagiosHostContactMembers as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosDependencys !== null) { foreach ($this->collNagiosDependencys as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosDependencyTargets !== null) { foreach ($this->collNagiosDependencyTargets as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosEscalations !== null) { foreach ($this->collNagiosEscalations as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosHostContactgroups !== null) { foreach ($this->collNagiosHostContactgroups as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosHostgroupMemberships !== null) { foreach ($this->collNagiosHostgroupMemberships as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosHostCheckCommandParameters !== null) { foreach ($this->collNagiosHostCheckCommandParameters as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosHostParentsRelatedByChildHost !== null) { foreach ($this->collNagiosHostParentsRelatedByChildHost as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosHostParentsRelatedByParentHost !== null) { foreach ($this->collNagiosHostParentsRelatedByParentHost as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collNagiosHostTemplateInheritances !== null) { foreach ($this->collNagiosHostTemplateInheritances as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collAutodiscoveryDevices !== null) { foreach ($this->collAutodiscoveryDevices as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; }
if (isset($_POST['request'])) { // Load Up The Session Data if ($_POST['request'] == 'add_period') { // Check for valid field entry if (trim($_POST['timeperiod_manage']['timeperiod_name']) == '' || trim($_POST['timeperiod_manage']['alias']) == '') { $error = "Fields must be filled in."; } else { // Check for pre-existing command with same name if ($lilac->period_exists($_POST['timeperiod_manage']['timeperiod_name'])) { $error = "A time period with that name already exists!"; } else { // All is well for error checking, add the command into the db. $timeperiod = new NagiosTimeperiod(); $timeperiod->setName($_POST['timeperiod_manage']['timeperiod_name']); $timeperiod->setAlias($_POST['timeperiod_manage']['alias']); $timeperiod->save(); // Remove session data unset($_GET['timeperiod_add']); $success = "Time period added."; } } } } if (isset($_GET['timeperiod_id'])) { $timeperiod = NagiosTimeperiodPeer::retrieveByPK($_GET['timeperiod_id']); } // Get list of commands $lilac->return_period_list($period_list); $numOfPeriods = count($period_list); print_header("Time Period Editor"); if (isset($_GET['timeperiod_id']) || isset($_GET['timeperiod_add'])) {
public function import() { $engine = $this->getEngine(); $job = $engine->getJob(); $job->addNotice("FruityTimeperiodImporter beginning to import Timeperiod Configuration."); // Timeperiods foreach ($this->dbConn->query("SELECT * FROM nagios_timeperiods", PDO::FETCH_ASSOC) as $timeperiod) { // Check for existing timeperiod if (NagiosTimeperiodPeer::getByName($timeperiod['timeperiod_name'])) { $job->addNotice("Fruity Timeperiod Importer: The timeperiod " . $timeperiod['timeperiod_name'] . " already exists. Aborting it's import."); continue; } $newTimeperiod = new NagiosTimeperiod(); $newTimeperiod->setName($timeperiod['timeperiod_name']); $newTimeperiod->setAlias($timeperiod['alias']); $newTimeperiod->save(); if (!empty($timeperiod['sunday'])) { $entry = new NagiosTimeperiodEntry(); $entry->setEntry('sunday'); $entry->setValue($timeperiod['sunday']); $entry->setNagiosTimeperiod($newTimeperiod); $entry->save(); } if (!empty($timeperiod['monday'])) { $entry = new NagiosTimeperiodEntry(); $entry->setEntry('monday'); $entry->setValue($timeperiod['monday']); $entry->setNagiosTimeperiod($newTimeperiod); $entry->save(); } if (!empty($timeperiod['tuesday'])) { $entry = new NagiosTimeperiodEntry(); $entry->setEntry('tuesday'); $entry->setValue($timeperiod['tuesday']); $entry->setNagiosTimeperiod($newTimeperiod); $entry->save(); } if (!empty($timeperiod['wednesday'])) { $entry = new NagiosTimeperiodEntry(); $entry->setEntry('wednesday'); $entry->setValue($timeperiod['wednesday']); $entry->setNagiosTimeperiod($newTimeperiod); $entry->save(); } if (!empty($timeperiod['thursday'])) { $entry = new NagiosTimeperiodEntry(); $entry->setEntry('thursday'); $entry->setValue($timeperiod['thursday']); $entry->setNagiosTimeperiod($newTimeperiod); $entry->save(); } if (!empty($timeperiod['friday'])) { $entry = new NagiosTimeperiodEntry(); $entry->setEntry('friday'); $entry->setValue($timeperiod['friday']); $entry->setNagiosTimeperiod($newTimeperiod); $entry->save(); } if (!empty($timeperiod['saturday'])) { $entry = new NagiosTimeperiodEntry(); $entry->setEntry('saturday'); $entry->setValue($timeperiod['saturday']); $entry->setNagiosTimeperiod($newTimeperiod); $entry->save(); } } $job->addNotice("FruityTimeperiodImporter finished importing Timeperiod Configuration."); }