--- /dev/null
+<?php
+
+class PdoChannelVersionManager extends AbstractPdoManager {
+
+ public function edit(ChannelVersion $channel){
+ if ($channel->id){
+ $this->update($channel);
+ return $channel->id;
+ } else {
+ return $this->create($channel);
+ }
+ }
+
+ public function create(ChannelVersion $channel){
+ $sql = "INSERT INTO channel_version(channel_id, status, version_id) VALUES (?,?,?)";
+ $this->query($sql,$channel->channel_id,$channel->status,$channel->version_id);
+ return $this->lastInsertId();
+ }
+
+ public function update(ChannelVersion $channel){
+ $sql = "UPDATE channel_version SET channel_id=?,status=?,version_id=? WHERE id=?";
+ $this->query($sql,$channel->channel_id,$channel->status,$channel->version_id,$channel->id);
+ }
+
+ public function listByVersion($version_id){
+ $sql = "SELECT channel_version.*, channel.channel_key, channel.libelle FROM channel_version" .
+ " LEFT JOIN channel ON channel_version.channel_id=channel.id" .
+ " WHERE version_id = ?";
+ return $this->query($sql,$version_id);
+ }
+
+ public function delete($id){
+ $sql = "DELETE FROM channel_version WHERE id=?";
+ $this->query($sql,$id);
+ }
+
+ /**
+ * @param $channel_id
+ * @return ChannelVersion|null
+ */
+ public function getChannel($channel_id){
+ $sql = "SELECT * FROM channel_version WHERE id=?";
+ $result = $this->queryOne($sql,$channel_id);
+ return $this->createObjectModel($result);
+ }
+
+}
\ No newline at end of file