/**
* 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.");
}
