return $lastVersionDeclaration;
}
+ public function findFirstVersionForId($id) {
+
+ $query = $this -> pdo -> prepare('SELECT versions FROM changelogs WHERE id = :id');
+ $query -> bindValue('id', $id);
+ $query -> execute();
+
+ // GETTING LAST DECLARED VERSION ID
+ $lastVersionId = null;
+ $result = $query -> fetch(PDO::FETCH_ASSOC);
+ $versions = explode("|", $result['versions']);
+ foreach ($versions as $version) {
+ $versionArray = explode(';', $version);
+ $versionId = $versionArray[0];
+ $versionDeclaration = $versionArray[1];
+ if(!isset($lastVersionDeclaration) || $versionDeclaration < $lastVersionDeclaration) {
+ $lastVersionDeclaration = $versionDeclaration;
+ $lastVersionId = $versionId;
+ }
+ }
+ $query->closeCursor();
+
+ // GETTING VERSION
+ $versionManager = new PdoVersionManager();
+ if(isset($lastVersionId)) {
+ $version = $versionManager->getVersion($lastVersionId);
+ } else {
+ $version = new Version();
+ }
+ return $version;
+ }
+
+ public function findFirstVersionDeclarationForId($id) {
+
+ $query = $this -> pdo -> prepare('SELECT versions FROM changelogs WHERE id = :id');
+ $query -> bindValue('id', $id);
+ $query -> execute();
+
+ // GETTING LAST VERSION DECLARATION
+ $lastVersionDeclaration = null;
+ $result = $query -> fetch(PDO::FETCH_ASSOC);
+ $versions = explode("|", $result['versions']);
+ foreach ($versions as $version) {
+ $versionArray = explode(';',$version);
+ $versionDeclaration = $versionArray[1];
+ if(!isset($lastVersionDeclaration) || $versionDeclaration < $lastVersionDeclaration) {
+ $lastVersionDeclaration = $versionDeclaration;
+ }
+ }
+ $query->closeCursor();
+
+ return $lastVersionDeclaration;
+ }
+
}