1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 | <?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 getCurrentAlerts() { global $conn; $query = 'SELECT * from servicealerts_alerts where NOW() > start and NOW() < "end"'; //debug($query, "database"); $query = $conn->prepare($query); //if ($stop_sequence != "") $query->bindParam(":stop_sequence", $stop_sequence); $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 "; } if ($filter_id != "") { $query .= " AND informed_id = :informed_id "; } //debug($query, "database"); $query = $conn->prepare($query); if ($filter_class != "" ) { $query->bindParam(":informed_class", $filter_class); } if ($filter_id != "") { $query->bindParam(":informed_id", $filter_id); } $query->bindParam(":servicealert_id", $id); $query->execute(); if (!$query) { databaseError($conn->errorInfo()); return Array(); } return $query->fetchAll(); } ?> |