--- /dev/null
+<?php
+
+class PdoChannelManager extends AbstractPdoManager {
+
+ public function edit($channel_key,$libelle){
+ $sql = "SELECT id FROM channel WHERE channel_key=?";
+ $channel_id = $this->queryOne($sql,$channel_key);
+ if ($channel_id){
+ $sql = "UPDATE channel SET libelle=? WHERE channel_key=?";
+ $this->query($sql,$libelle,$channel_key);
+ } else {
+ $sql = "INSERT INTO channel (channel_key, libelle) VALUE (?,?)";
+ $this->query($sql,$channel_key,$libelle);
+ $channel_id = $this->lastInsertId();
+ }
+ return $channel_id;
+ }
+
+ public function getList(){
+ $sql = "SELECT * FROM channel ORDER BY libelle";
+ return $this->query($sql);
+ }
+
+ /**
+ * @param $channel_id
+ * @return Channel |null
+ */
+ public function getChannel($channel_id){
+ $sql = "SELECT * FROM channel WHERE id=?";
+ $info = $this->queryOne($sql,$channel_id);
+ return $this->createObjectModel($info);
+ }
+
+ /**
+ * @param $channel_key
+ * @return Channel|null
+ */
+ public function getChannelByChannelKey($channel_key){
+ $sql = "SELECT * FROM channel WHERE channel_key=?";
+ $info = $this->queryOne($sql,$channel_key);
+ return $this->createObjectModel($info);
+ }
+
+}
\ No newline at end of file