<?php
session_start();
include_once "../dao/dbcon.php";
include_once "../dao/service.php";
$statement = $_POST['serv_stat'];
$provider_id = $_SESSION['provider']['serviceprovider_id'];
$service_name = "Company Service Statement for " . $_SESSION['provider']['primaryname'];
$errors = "";
if (!empty($statement) || $statement != null) {
$no_of_rows = get_servicedesc_rows($service_name);
if ($no_of_rows > 0 || $no_of_rows == 1) {
// if record exists ... update
updateServices($statement, $service_name);
echo "UPDATE";
} else {
// insert new record
$service_sq = pg_query_params("select nextval('techmatcher.serviceid_seq')", array());
$result_service = pg_fetch_row($service_sq);
$service_id = $result_service[0];
$result = setServices($service_id, $service_name, $statement);
$result1 = setSPOfferServices($provider_id, $service_id);
echo "INSERT";
}
} else {
$errors = $errors . "<li> Statement couldn't be empty. </li>";
echo $errors;
}
} elseif (isset($_POST['addNewFeature'])) {
$desc = $_POST['addNewFeature'];
addFeature($desc);
$id = getFeatureID($desc);
echo $id;
} elseif (isset($_POST['featureID'])) {
$id = $_POST['featureID'];
deleteFeature($id);
} elseif (isset($_POST['addNewAdvantage'])) {
$advantage = $_POST['addNewAdvantage'];
addAdvantages($advantage);
$resp['advKey'] = getAdvantageID($advantage);
echo json_encode($resp);
} elseif (isset($_POST['advID'])) {
$Aid = $_POST['advID'];
deleteAdvantage($Aid);
} elseif (isset($_POST['updService'])) {
$service = $_POST['updService'];
$price = $_POST['updPrice'];
$id = $_POST['serviceID'];
updateServices($service, $price, $id);
} elseif (isset($_POST['addNewService'])) {
$service = $_POST['addNewService'];
$price = $_POST['addNewPrice'];
addCharges($service, $price);
$id = getServiceID($service, $price);
echo $id;
} elseif (isset($_POST['ServId'])) {
$id = $_POST['ServId'];
deleteService($id);
}
/**
* @param $triggers
*/
protected function updateReal(array $triggers)
{
$triggers = zbx_toArray($triggers);
$infos = array();
$dbTriggers = $this->get(array('triggerids' => zbx_objectValues($triggers, 'triggerid'), 'output' => API_OUTPUT_EXTEND, 'selectHosts' => array('name'), 'selectDependencies' => API_OUTPUT_REFER, 'preservekeys' => true, 'nopermissions' => true));
$descriptionChanged = $expressionChanged = false;
foreach ($triggers as &$trigger) {
$dbTrigger = $dbTriggers[$trigger['triggerid']];
$hosts = zbx_objectValues($dbTrigger['hosts'], 'name');
if (isset($trigger['description']) && strcmp($dbTrigger['description'], $trigger['description']) != 0) {
$descriptionChanged = true;
} else {
$trigger['description'] = $dbTrigger['description'];
}
$expressionFull = explode_exp($dbTrigger['expression']);
if (isset($trigger['expression']) && strcmp($expressionFull, $trigger['expression']) != 0) {
$this->validateItems($trigger);
$expressionChanged = true;
$expressionFull = $trigger['expression'];
$trigger['error'] = 'Trigger expression updated. No status update so far.';
}
if ($expressionChanged) {
// check the expression
$expressionData = new CTriggerExpression();
if (!$expressionData->parse($expressionFull)) {
self::exception(ZBX_API_ERROR_PARAMETERS, $expressionData->error);
}
// if the trigger contains templates, delete any events that may exist
if ($this->expressionHasTemplates($expressionData)) {
DB::delete('events', array('object' => EVENT_OBJECT_TRIGGER, 'objectid' => $trigger['triggerid']));
}
DB::delete('functions', array('triggerid' => $trigger['triggerid']));
try {
$trigger['expression'] = implode_exp($expressionFull, $trigger['triggerid'], $hosts);
} catch (Exception $e) {
self::exception(ZBX_API_ERROR_PARAMETERS, _s('Cannot implode expression "%s".', $expressionFull) . ' ' . $e->getMessage());
}
if (isset($trigger['status']) && $trigger['status'] != TRIGGER_STATUS_ENABLED) {
if ($trigger['value_flags'] == TRIGGER_VALUE_FLAG_NORMAL) {
addUnknownEvent($trigger['triggerid']);
$trigger['value_flags'] = TRIGGER_VALUE_FLAG_UNKNOWN;
}
}
// if the expression has changed, we must revalidate the existing dependencies
if (!isset($trigger['dependencies'])) {
$trigger['dependencies'] = zbx_objectValues($dbTrigger['dependencies'], 'triggerid');
}
}
$triggerUpdate = $trigger;
if (!$descriptionChanged) {
unset($triggerUpdate['description']);
}
if (!$expressionChanged) {
unset($triggerUpdate['expression']);
}
DB::update('triggers', array('values' => $triggerUpdate, 'where' => array('triggerid' => $trigger['triggerid'])));
// update service status
if (isset($trigger['priority']) && $trigger['priority'] != $dbTrigger['priority']) {
$serviceStatus = $dbTrigger['value'] == TRIGGER_VALUE_TRUE ? $trigger['priority'] : 0;
updateServices($trigger['triggerid'], $serviceStatus);
}
// restore the full expression to properly validate dependencies
$trigger['expression'] = $expressionChanged ? explode_exp($trigger['expression']) : $expressionFull;
$infos[] = _s('Updated: Trigger "%1$s" on "%2$s".', $trigger['description'], implode(', ', $hosts));
add_audit_ext(AUDIT_ACTION_UPDATE, AUDIT_RESOURCE_TRIGGER, $dbTrigger['triggerid'], $dbTrigger['description'], null, $dbTrigger, $triggerUpdate);
}
unset($trigger);
foreach ($infos as $info) {
info($info);
}
}
