Ysurac /
FlightAirMap
| @@ 46-59 (lines=14) @@ | ||
| 43 | } |
|
| 44 | ||
| 45 | ||
| 46 | public function getOperator($ident) { |
|
| 47 | $query = "SELECT * FROM translation WHERE Operator = :ident LIMIT 1"; |
|
| 48 | $query_values = array(':ident' => $ident); |
|
| 49 | try { |
|
| 50 | $sth = $this->db->prepare($query); |
|
| 51 | $sth->execute($query_values); |
|
| 52 | } catch(PDOException $e) { |
|
| 53 | return "error : ".$e->getMessage(); |
|
| 54 | } |
|
| 55 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
|
| 56 | if (count($row) > 0) { |
|
| 57 | return $row['operator_correct']; |
|
| 58 | } else return $ident; |
|
| 59 | } |
|
| 60 | ||
| 61 | public function addOperator($ident,$correct_ident,$source) { |
|
| 62 | $query = "INSERT INTO translation (Operator,Operator_correct,Source) VALUES (:ident,:correct_ident,:source)"; |
|
| @@ 128-147 (lines=20) @@ | ||
| 125 | } else return array(); |
|
| 126 | } |
|
| 127 | ||
| 128 | public function checkSchedule($ident) { |
|
| 129 | global $globalDBdriver; |
|
| 130 | //$query = "SELECT COUNT(*) as nb FROM schedule WHERE ident = :ident AND date_added > DATE_SUB(CURDATE(), INTERVAL 8 DAY) - 8 LIMIT 1"; |
|
| 131 | if ($globalDBdriver == 'mysql') { |
|
| 132 | $query = "SELECT COUNT(*) as nb FROM routes WHERE CallSign = :ident AND ((date_added BETWEEN DATE(DATE_SUB(CURDATE(), INTERVAL 15 DAY)) AND DATE(NOW()) and date_modified IS NULL) OR (date_modified BETWEEN DATE(DATE_SUB(CURDATE(), INTERVAL 15 DAY)) AND DATE(NOW()))) LIMIT 1"; |
|
| 133 | } else { |
|
| 134 | $query = "SELECT COUNT(*) as nb FROM routes WHERE CallSign = :ident |
|
| 135 | AND ((date_added::timestamp BETWEEN CURRENT_TIMESTAMP - INTERVAL '15 DAYS' AND CURRENT_TIMESTAMP) and date_modified::timestamp IS NULL) |
|
| 136 | OR (date_modified::timestamp BETWEEN CURRENT_TIMESTAMP - INTERVAL '15 DAYS' AND CURRENT_TIMESTAMP) LIMIT 1"; |
|
| 137 | } |
|
| 138 | $query_values = array(':ident' => $ident); |
|
| 139 | try { |
|
| 140 | $sth = $this->db->prepare($query); |
|
| 141 | $sth->execute($query_values); |
|
| 142 | } catch(PDOException $e) { |
|
| 143 | return "error : ".$e->getMessage(); |
|
| 144 | } |
|
| 145 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
|
| 146 | return $row['nb']; |
|
| 147 | } |
|
| 148 | ||
| 149 | /** |
|
| 150 | * Get flight info from Air France |
|
