/**
* 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->aNagiosEscalation !== null) {
if ($this->aNagiosEscalation->isModified() || $this->aNagiosEscalation->isNew()) {
$affectedRows += $this->aNagiosEscalation->save($con);
}
$this->setNagiosEscalation($this->aNagiosEscalation);
}
if ($this->aNagiosContact !== null) {
if ($this->aNagiosContact->isModified() || $this->aNagiosContact->isNew()) {
$affectedRows += $this->aNagiosContact->save($con);
}
$this->setNagiosContact($this->aNagiosContact);
}
if ($this->isNew()) {
$this->modifiedColumns[] = NagiosEscalationContactPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = NagiosEscalationContactPeer::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 += NagiosEscalationContactPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
$escalation->setHostgroup($tempSource->getId());
} else {
if ($type == "hosttemplate") {
$escalation->setHostTemplate($tempSource->getId());
} else {
if ($type == "service") {
$escalation->setService($tempSource->getId());
} else {
if ($type == "servicetemplate") {
$escalation->setServiceTemplate($tempSource->getId());
}
}
}
}
$escalation->setDescription(trim($_POST['escalation_description']));
$escalation->save();
header("Location: escalation.php?id=" . $escalation->getId());
die;
}
}
if ($type == "service") {
$textTitle = $tempSource->getNagiosHost()->getName() . " : " . $tempSource->getDescription();
} else {
$textTitle = $tempSource->getName();
}
print_header("Add Escalation To " . $title . " " . $textTitle);
print_window_header("Add A Escalation", "100%");
?>
<a href="<?php
echo $link;
?>
public function import()
{
$engine = $this->getEngine();
$job = $engine->getJob();
$job->addNotice("FruityEscalationImporter beginning to import Dependency Configuration.");
foreach ($this->dbConn->query("SELECT * FROM nagios_escalations", PDO::FETCH_ASSOC) as $escalation) {
$newEscalation = new NagiosEscalation();
if (!empty($escalation['service_id'])) {
// This is a service escalation
$lilacService = $this->getLilacServiceById($escalation['service_id']);
if (!$lilacService) {
$job->addNotice("Fruity Escalation Importer: Failed to get Lilac service with an id matching: " . $escalation['service_id']);
return true;
}
$newEscalation->setService($lilacService->getId());
} else {
if (!empty($escalation['host_id'])) {
// This is a host escalation
$hostName = $this->getHostNameById($escalation['host_id']);
$host = NagiosHostPeer::getByName($hostName);
if (!$host) {
$job->addNotice("Fruity Escalation Importer: Failed to get Lilac host with an name matching: " . $hostName);
return true;
}
$newEscalation->setHost($host->getId());
} else {
if (!empty($escalation['service_template_id'])) {
// This is a service template escalation
$templateName = $this->getServiceTemplateNameById($escalation['service_template_id']);
$template = NagiosServiceTemplatePeer::getByName($templateName);
if (!$template) {
$job->addNotice("Fruity Escalation Importer: Failed to get Lilac service template with name matching: " . $templateName);
return true;
}
$newEscalation->setServiceTemplate($template->getId());
} else {
if (!empty($escalation['host_template_id'])) {
// This is for a host template escalation
$templateName = $this->getHostTemplateNameById($escalation['host_template_id']);
$template = NagiosHostTemplatePeer::getByName($templateName);
if (!$template) {
$job->addNotice("Fruity Escalation Importer: Failed to get Lilac host template with name matching: " . $templateName);
return true;
}
$newEscalation->setHostTemplate($template->getId());
}
}
}
}
foreach ($escalation as $key => $val) {
unset($name);
if ($key == "escalation_id" || $key == "host_id" || $key == "host_template_id" || $key == "service_template_id" || $key == "service_id") {
continue;
}
if ($key == "escalation_description") {
$key = "description";
}
if ($key == "escalation_period") {
$escalationName = $this->getTimeperiodNameById($id);
if ($escalationName) {
$newEscalation->setEscalationPeriodByName($escalationName);
}
continue;
}
try {
$name = NagiosEscalationPeer::translateFieldName($key, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_PHPNAME);
} catch (Exception $e) {
$job->addNotice("Fruity Escalation Importer: Was unable to store unsupported value: " . $key);
}
if (!empty($name)) {
$method = "set" . $name;
$newEscalation->{$method}($val);
}
}
$newEscalation->save();
// Handle escalation contact groups.
foreach ($this->dbConn->query("SELECT * FROM nagios_escalation_contactgroups WHERE escalation_id = " . $escalation['escalation_id'], PDO::FETCH_ASSOC) as $contactgroup) {
$contactgroupName = $this->getContactGroupNameById($contactgroup['contactgroup_id']);
if ($contactgroupName) {
$lilacContactGroup = NagiosContactGroupPeer::getByName($contactgroupName);
if ($lilacContactGroup) {
$newContactGroup = new NagiosEscalationContactgroup();
$newContactGroup->setEscalation($newEscalation->getId());
$newContactGroup->setContactgroup($lilacContactGroup->getId());
$newContactGroup->save();
}
}
}
}
$job->addNotice("FruityEscalationImporter finished importing Escalation Configuration.");
}
