<?php |
<?php |
function getServiceOverride($date = "") |
|
{ |
|
global $conn; |
|
$query = "Select * from calendar_dates where date = :date and exception_type = '1' LIMIT 1"; |
|
// debug($query,"database"); |
|
$query = $conn -> prepare($query); // Create a prepared statement |
|
$query -> bindParam(":date", date("Ymd", ($date != "" ? $date : time()))); |
|
$query -> execute(); |
|
if (!$query) { |
|
databaseError($conn -> errorInfo()); |
|
return Array(); |
|
} |
|
return $query -> fetch(PDO :: FETCH_ASSOC); |
|
} |
|
|
|
function getServiceAlert($alertID) |
/* |
{ |
* Copyright 2010,2011 Alexander Sadleir |
global $conn; |
|
$query = 'SELECT * from servicealerts_alerts where id = :servicealert_id'; |
|
debug($query, "database"); |
|
$query = $conn -> prepare($query); |
|
$query -> bindParam(":servicealert_id", $alertID); |
|
$query -> execute(); |
|
if (!$query) { |
|
databaseError($conn -> errorInfo()); |
|
return Array(); |
|
} |
|
return $query -> fetch(PDO :: FETCH_ASSOC); |
|
} |
|
|
|
|
Licensed under the Apache License, Version 2.0 (the "License"); |
|
you may not use this file except in compliance with the License. |
|
You may obtain a copy of the License at |
|
|
function updateServiceAlert($alertID, $start, $end, $description, $url) |
http://www.apache.org/licenses/LICENSE-2.0 |
{ |
|
global $conn; |
|
$query = 'update servicealerts_alerts set start=:start, "end"=:end, description=:description, url=:url where id = :servicealert_id'; |
|
debug($query, "database"); |
|
$query = $conn -> prepare($query); |
|
$query -> bindParam(":servicealert_id", $alertID); |
|
$query -> bindParam(":start", $start); |
|
$query -> bindParam(":end", $end); |
|
$query -> bindParam(":description", $description); |
|
$query -> bindParam(":url", $url); |
|
$query -> execute(); |
|
|
|
print_r($conn -> errorInfo()); |
Unless required by applicable law or agreed to in writing, software |
if (!$query) { |
distributed under the License is distributed on an "AS IS" BASIS, |
databaseError($conn -> errorInfo()); |
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
return Array(); |
See the License for the specific language governing permissions and |
} |
limitations under the License. |
return $query -> fetch(PDO :: FETCH_ASSOC); |
*/ |
} |
|
|
|
function addServiceAlert($start, $end, $description, $url) |
function getServiceOverride($date = "") { |
{ |
global $conn; |
global $conn; |
$query = "Select * from calendar_dates where date = :date and exception_type = '1' LIMIT 1"; |
$query = 'INSERT INTO servicealerts_alerts (start, "end", description, url) VALUES (:start, :end, :description, :url) '; |
// debug($query,"database"); |
debug($query, "database"); |
$query = $conn->prepare($query); // Create a prepared statement |
$query = $conn -> prepare($query); |
$query->bindParam(":date", date("Ymd", ($date != "" ? $date : time()))); |
$query -> bindParam(":start", $start); |
$query->execute(); |
$query -> bindParam(":end", $end); |
if (!$query) { |
$query -> bindParam(":description", $description); |
databaseError($conn->errorInfo()); |
$query -> bindParam(":url", $url); |
return Array(); |
$query -> execute(); |
} |
|
return $query->fetch(PDO :: FETCH_ASSOC); |
|
} |
|
|
print_r($conn -> errorInfo()); |
function getServiceAlert($alertID) { |
if (!$query) { |
global $conn; |
databaseError($conn -> errorInfo()); |
$query = "SELECT id,extract('epoch' from start) as start, extract('epoch' from \"end\") as \"end\",cause,effect,header,description,url from servicealerts_alerts where id = :servicealert_id"; |
return Array(); |
debug($query, "database"); |
} |
$query = $conn->prepare($query); |
return $query -> fetch(PDO :: FETCH_ASSOC); |
$query->bindParam(":servicealert_id", $alertID); |
} |
$query->execute(); |
|
if (!$query) { |
|
databaseError($conn->errorInfo()); |
|
return Array(); |
|
} |
|
return $query->fetch(PDO :: FETCH_ASSOC); |
|
} |
|
|
function getCurrentAlerts() |
function updateServiceAlert($alertID, $start, $end, $header, $description, $url) { |
{ |
global $conn; |
global $conn; |
$query = 'update servicealerts_alerts set start=:start, "end"=:end, header=:header, description=:description, url=:url where id = :servicealert_id'; |
$query = 'SELECT * from servicealerts_alerts where NOW() > start and NOW() < "end"'; |
debug($query, "database"); |
// debug($query, "database"); |
$query = $conn->prepare($query); |
$query = $conn -> prepare($query); |
$query->bindParam(":servicealert_id", $alertID); |
$query -> execute(); |
$query->bindParam(":start", $start); |
if (!$query) { |
$query->bindParam(":end", $end); |
databaseError($conn -> errorInfo()); |
$query->bindParam(":header", $header); |
return Array(); |
$query->bindParam(":description", $description); |
} |
$query->bindParam(":url", $url); |
return $query -> fetchAll(); |
$query->execute(); |
} |
|
|
|
function getFutureAlerts() |
print_r($conn->errorInfo()); |
{ |
if (!$query) { |
global $conn; |
databaseError($conn->errorInfo()); |
$query = 'SELECT * from servicealerts_alerts where NOW() > start or NOW() < "end"'; |
return Array(); |
// debug($query, "database"); |
} |
$query = $conn -> prepare($query); |
return $query->fetch(PDO :: FETCH_ASSOC); |
$query -> execute(); |
} |
if (!$query) { |
|
databaseError($conn -> errorInfo()); |
function addServiceAlert($start, $end, $header, $description, $url) { |
return Array(); |
global $conn; |
} |
$query = 'INSERT INTO servicealerts_alerts (start, "end", header, description, url) VALUES (:start, :end, :header, :description, :url) '; |
return $query -> fetchAll(); |
debug($query, "database"); |
} |
$query = $conn->prepare($query); |
function getInformedAlerts($id, $filter_class, $filter_id) |
$query->bindParam(":start", $start); |
{ |
$query->bindParam(":end", $end); |
|
$query->bindParam(":header", $header); |
global $conn; |
$query->bindParam(":description", $description); |
$query = "SELECT * from servicealerts_informed where servicealert_id = :servicealert_id"; |
$query->bindParam(":url", $url); |
|
$query->execute(); |
if ($filter_class != "") { |
|
|
print_r($conn->errorInfo()); |
|
if (!$query) { |
|
databaseError($conn->errorInfo()); |
|
return Array(); |
|
} |
|
return $query->fetch(PDO :: FETCH_ASSOC); |
|
} |
|
|
|
function getCurrentAlerts() { |
|
global $conn; |
|
$query = "SELECT id,extract('epoch' from start) as start, extract('epoch' from \"end\") as \"end\",cause,effect,header,description,url from servicealerts_alerts where NOW() > start and NOW() < \"end\""; |
|
// debug($query, "database"); |
|
$query = $conn->prepare($query); |
|
$query->execute(); |
|
if (!$query) { |
|
databaseError($conn->errorInfo()); |
|
return Array(); |
|
} |
|
return $query->fetchAll(); |
|
} |
|
|
|
function getFutureAlerts() { |
|
global $conn; |
|
$query = "SELECT id,extract('epoch' from start) as start, extract('epoch' from \"end\") as \"end\",cause,effect,header,description,url from servicealerts_alerts where NOW() > start or NOW() < \"end\""; |
|
// debug($query, "database"); |
|
$query = $conn->prepare($query); |
|
$query->execute(); |
|
if (!$query) { |
|
databaseError($conn->errorInfo()); |
|
return Array(); |
|
} |
|
return $query->fetchAll(); |
|
} |
|
|
|
function getInformedAlerts($id, $filter_class, $filter_id) { |
|
|
|
global $conn; |
|
$query = "SELECT * from servicealerts_informed where servicealert_id = :servicealert_id"; |
|
|
|
if ($filter_class != "") { |
$query .= " AND informed_class = :informed_class "; |
$query .= " AND informed_class = :informed_class "; |
|
} |
} |
|
if ($filter_id != "") { |
if ($filter_id != "") { |
$query .= " AND informed_id = :informed_id "; |
$query .= " AND informed_id = :informed_id "; |
|
} |
} |
|
// debug($query, "database"); |
// debug($query, "database"); |
$query = $conn -> prepare($query); |
$query = $conn->prepare($query); |
if ($filter_class != "") { |
if ($filter_class != "") { |
$query -> bindParam(":informed_class", $filter_class); |
$query->bindParam(":informed_class", $filter_class); |
} |
} |
if ($filter_id != "") { |
if ($filter_id != "") { |
$query -> bindParam(":informed_id", $filter_id); |
$query->bindParam(":informed_id", $filter_id); |
} |
} |
$query -> bindParam(":servicealert_id", $id); |
$query->bindParam(":servicealert_id", $id); |
$query -> execute(); |
$query->execute(); |
if (!$query) { |
if (!$query) { |
databaseError($conn -> errorInfo()); |
databaseError($conn->errorInfo()); |
return Array(); |
return Array(); |
} |
} |
return $query -> fetchAll(); |
return $query->fetchAll(); |
} |
} |
function deleteInformedAlert($serviceAlertID, $class, $id) |
|
{ |
function deleteInformedAlert($serviceAlertID, $class, $id) { |
global $conn; |
global $conn; |
$query = 'DELETE from servicealerts_informed where servicealert_id = :servicealert_id and informed_class = :informed_class AND informed_id = :informed_id'; |
$query = 'DELETE from servicealerts_informed where servicealert_id = :servicealert_id and informed_class = :informed_class AND informed_id = :informed_id'; |
debug($query, "database"); |
debug($query, "database"); |
$query = $conn -> prepare($query); |
$query = $conn->prepare($query); |
$query -> bindParam(":servicealert_id", $serviceAlertID); |
$query->bindParam(":servicealert_id", $serviceAlertID); |
$query -> bindParam(":informed_class", $class); |
$query->bindParam(":informed_class", $class); |
$query -> bindParam(":informed_id", $id); |
$query->bindParam(":informed_id", $id); |
$query -> execute(); |
$query->execute(); |
print_r($conn -> errorInfo()); |
print_r($conn->errorInfo()); |
if (!$query) { |
if (!$query) { |
databaseError($conn -> errorInfo()); |
databaseError($conn->errorInfo()); |
return Array(); |
return Array(); |
} |
} |
return null; |
return null; |
} |
} |
function addInformedAlert($serviceAlertID, $class, $id, $action) |
|
{ |
|
global $conn; |
|
$query = 'INSERT INTO servicealerts_informed (servicealert_id , informed_class , informed_id) VALUES(:servicealert_id ,:informed_class, :informed_id)'; |
|
debug($query, "database"); |
|
$query = $conn -> prepare($query); |
|
$query -> bindParam(":servicealert_id", $serviceAlertID); |
|
$query -> bindParam(":informed_class", $class); |
|
$query -> bindParam(":informed_id", $id); |
|
$query -> execute(); |
|
|
|
print_r($conn -> errorInfo()); |
function addInformedAlert($serviceAlertID, $class, $id, $action) { |
if (!$query) { |
global $conn; |
databaseError($conn -> errorInfo()); |
$query = 'INSERT INTO servicealerts_informed (servicealert_id , informed_class , informed_id) VALUES(:servicealert_id ,:informed_class, :informed_id)'; |
return Array(); |
debug($query, "database"); |
} |
$query = $conn->prepare($query); |
|
$query->bindParam(":servicealert_id", $serviceAlertID); |
|
$query->bindParam(":informed_class", $class); |
|
$query->bindParam(":informed_id", $id); |
|
$query->execute(); |
|
|
|
print_r($conn->errorInfo()); |
|
if (!$query) { |
|
databaseError($conn->errorInfo()); |
|
return Array(); |
|
} |
return null; |
return null; |
|
} |
} |
|
?> |
?> |