| <?php | <?php |
| function getServiceOverride($date="") { | function getServiceOverride($date="") { |
| global $conn; | global $conn; |
| $query = "Select * from calendar_dates where date = :date and exception_type = '1' LIMIT 1"; | $query = "Select * from calendar_dates where date = :date and exception_type = '1' LIMIT 1"; |
| // debug($query,"database"); | // debug($query,"database"); |
| $query = $conn->prepare($query); // Create a prepared statement | $query = $conn->prepare($query); // Create a prepared statement |
| $query->bindParam(":date", date("Ymd",($date != "" ? $date : time()))); | $query->bindParam(":date", date("Ymd",($date != "" ? $date : time()))); |
| $query->execute(); | $query->execute(); |
| if (!$query) { | if (!$query) { |
| databaseError($conn->errorInfo()); | databaseError($conn->errorInfo()); |
| return Array(); | return Array(); |
| } | } |
| return $query->fetch(PDO::FETCH_ASSOC); | return $query->fetch(PDO::FETCH_ASSOC); |
| } | } |
| function getCurrentAlerts() { | function getCurrentAlerts() { |
| global $conn; | global $conn; |
| $query = "SELECT * from servicealerts_alerts"; | $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); |
| //if ($stop_sequence != "") $query->bindParam(":stop_sequence", $stop_sequence); | //if ($stop_sequence != "") $query->bindParam(":stop_sequence", $stop_sequence); |
| $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 getInformedAlerts($id,$filter_class,$filter_id) { | function getInformedAlerts($id,$filter_class,$filter_id) { |
| global $conn; | global $conn; |
| $query = "SELECT * from servicealerts_informed where servicealert_id = :servicealert_id"; | $query = "SELECT * from servicealerts_informed where servicealert_id = :servicealert_id"; |
| if ($filter_class != "" && $filter_id != "") { | if ($filter_class != "" ) { |
| $query .= " AND (informed_class = :informed_class OR informed_class = 'network') AND informed_id = :informed_id"; | $query .= " AND informed_class = :informed_class "; |
| } | |
| if ($filter_id != "") { | |
| $query .= " AND informed_id = :informed_id "; | |
| } | } |
| //debug($query, "database"); | //debug($query, "database"); |
| $query = $conn->prepare($query); | $query = $conn->prepare($query); |
| if ($filter_class != "" && $filter_id != "") { | if ($filter_class != "" ) { |
| $query->bindParam(":informed_class", $filter_class); | $query->bindParam(":informed_class", $filter_class); |
| } | |
| 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(); |
| } | } |
| ?> | ?> |