projects / busui.git / blobdiff
search:
summary | shortlog | log | commit | commitdiff | tree
side by side | plain
Code standards, fix base path at least for php includes and use single quotes more often
[busui.git] / include / db / servicealert-dao.inc.php
blob:a/include/db/servicealert-dao.inc.php -> blob:b/include/db/servicealert-dao.inc.php 
--- a/include/db/servicealert-dao.inc.php
+++ b/include/db/servicealert-dao.inc.php
@@ -3,26 +3,26 @@
 /*
  *    Copyright 2010,2011 Alexander Sadleir 
 
-  Licensed under the Apache License, Version 2.0 (the "License");
+  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
 
   http://www.apache.org/licenses/LICENSE-2.0
 
   Unless required by applicable law or agreed to in writing, software
-  distributed under the License is distributed on an "AS IS" BASIS,
+  distributed under the License is distributed on an 'AS IS' BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
  */
 
-function getServiceOverride($date = "") {
+function getServiceOverride($date = '') {
     global $conn;
-    $query = "Select * from calendar_dates where date = :date and exception_type = '1' LIMIT 1";
-    // debug($query,"database");
+    $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
-    $date = date("Ymd", ($date != "" ? $date : time()));
-    $query->bindParam(":date", $date);
+    $date = date('Ymd', ($date != '' ? $date : time()));
+    $query->bindParam(':date', $date);
     $query->execute();
     if (!$query) {
         databaseError($conn->errorInfo());
@@ -33,10 +33,10 @@
 
 function getServiceAlert($alertID) {
     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 id = :servicealert_id";
-    debug($query, "database");
+    $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';
+    debug($query, 'database');
     $query = $conn->prepare($query);
-    $query->bindParam(":servicealert_id", $alertID);
+    $query->bindParam(':servicealert_id', $alertID);
     $query->execute();
     if (!$query) {
         databaseError($conn->errorInfo());
@@ -48,16 +48,16 @@
 function updateServiceAlert($alertID, $alert) {
     global $conn;
     $query = 'update servicealerts_alerts set start=:start, "end"=:end, header=:header, description=:description, url=:url, cause=:cause, effect=:effect where id = :servicealert_id';
-    debug($query, "database");
+    debug($query, 'database');
     $query = $conn->prepare($query);
-    $query->bindValue(":servicealert_id", $alertID);
-    $query->bindValue(":start", $alert['startdate']);
-    $query->bindValue(":end", $alert['enddate']);
-    $query->bindValue(":header", $alert['header']);
-    $query->bindValue(":description", $alert['description']);
-    $query->bindValue(":url", $alert['url']);
-    $query->bindValue(":cause", $alert['cause']);
-    $query->bindValue(":effect", $alert['effect']);
+    $query->bindValue(':servicealert_id', $alertID);
+    $query->bindValue(':start', $alert['startdate']);
+    $query->bindValue(':end', $alert['enddate']);
+    $query->bindValue(':header', $alert['header']);
+    $query->bindValue(':description', $alert['description']);
+    $query->bindValue(':url', $alert['url']);
+    $query->bindValue(':cause', $alert['cause']);
+    $query->bindValue(':effect', $alert['effect']);
     $query->execute();
 
     print_r($conn->errorInfo());
@@ -71,16 +71,16 @@
 function addServiceAlert($alert) {
     global $conn;
     $query = 'INSERT INTO servicealerts_alerts (start, "end", header, description, url,cause,effect) VALUES (:start, :end, :header, :description, :url,:cause,:effect) ';
-    debug($query, "database");
+    debug($query, 'database');
     $query = $conn->prepare($query);
     //print_r($alert);
-    $query->bindValue(":start", $alert['startdate']);
-    $query->bindValue(":end", $alert['enddate']);
-    $query->bindValue(":header", $alert['header']);
-    $query->bindValue(":description", $alert['description']);
-    $query->bindValue(":url", $alert['url']);
-    $query->bindValue(":cause", $alert['cause']);
-    $query->bindValue(":effect", $alert['effect']);
+    $query->bindValue(':start', $alert['startdate']);
+    $query->bindValue(':end', $alert['enddate']);
+    $query->bindValue(':header', $alert['header']);
+    $query->bindValue(':description', $alert['description']);
+    $query->bindValue(':url', $alert['url']);
+    $query->bindValue(':cause', $alert['cause']);
+    $query->bindValue(':effect', $alert['effect']);
     $query->execute();
 
     print_r($conn->errorInfo());
@@ -93,8 +93,8 @@
 
 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 = '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) {
@@ -106,8 +106,8 @@
 
 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() < \"end\"";
-    // debug($query, "database");
+    $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() < "end"';
+    // debug($query, 'database');
     $query = $conn->prepare($query);
     $query->execute();
     if (!$query) {
@@ -116,10 +116,11 @@
     }
     return $query->fetchAll();
 }
+
 function getAllAlerts() {
     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";
-    // debug($query, "database");
+    $query = 'SELECT id,extract(\'epoch\' from start) as start, extract(\'epoch\' from "end") as "end",cause,effect,header,description,url from servicealerts_alerts';
+    // debug($query, 'database');
     $query = $conn->prepare($query);
     $query->execute();
     if (!$query) {
@@ -132,24 +133,24 @@
 function getInformedAlerts($id, $filter_class, $filter_id) {
 
     global $conn;
-    //echo "$id, $filter_class, $filter_id\n";
-    $query = "SELECT * from servicealerts_informed where servicealert_id = :servicealert_id";
+    //echo '$id, $filter_class, $filter_id\n';
+    $query = 'SELECT * from servicealerts_informed where servicealert_id = :servicealert_id';
 
-    if ($filter_class != "") {
-        $query .= " AND informed_class = :informed_class  ";
+    if ($filter_class != '') {
+        $query .= ' AND informed_class = :informed_class  ';
     }
-    if ($filter_id != "") {
-        $query .= " AND informed_id = :informed_id ";
+    if ($filter_id != '') {
+        $query .= ' AND informed_id = :informed_id ';
     }
-    // debug($query, "database");
+    // debug($query, 'database');
     $query = $conn->prepare($query);
-    if ($filter_class != "") {
-        $query->bindParam(":informed_class", $filter_class);
+    if ($filter_class != '') {
+        $query->bindParam(':informed_class', $filter_class);
     }
-    if ($filter_id != "") {
-        $query->bindParam(":informed_id", $filter_id);
+    if ($filter_id != '') {
+        $query->bindParam(':informed_id', $filter_id);
     }
-    $query->bindParam(":servicealert_id", $id);
+    $query->bindParam(':servicealert_id', $id);
     $query->execute();
     if (!$query) {
         databaseError($conn->errorInfo());
@@ -161,11 +162,11 @@
 function deleteInformedAlert($serviceAlertID, $class, $id) {
     global $conn;
     $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->bindParam(":servicealert_id", $serviceAlertID);
-    $query->bindParam(":informed_class", $class);
-    $query->bindParam(":informed_id", $id);
+    $query->bindParam(':servicealert_id', $serviceAlertID);
+    $query->bindParam(':informed_class', $class);
+    $query->bindParam(':informed_id', $id);
     $query->execute();
     print_r($conn->errorInfo());
     if (!$query) {
@@ -179,12 +180,12 @@
     global $conn;
     $query = 'INSERT INTO servicealerts_informed (servicealert_id , informed_class , informed_id, informed_action) 
         VALUES(:servicealert_id ,:informed_class, :informed_id, :informed_action)';
-    debug($query, "database");
+    debug($query, 'database');
     $query = $conn->prepare($query);
-    $query->bindParam(":servicealert_id", $serviceAlertID);
-    $query->bindParam(":informed_class", $class);
-    $query->bindParam(":informed_id", $id);
-    $query->bindParam(":informed_action", $action);
+    $query->bindParam(':servicealert_id', $serviceAlertID);
+    $query->bindParam(':informed_class', $class);
+    $query->bindParam(':informed_id', $id);
+    $query->bindParam(':informed_action', $action);
     $query->execute();
 
     print_r($conn->errorInfo());
Unnamed repository; edit this file to name it for gitweb.
GitPHP by Chris Han