
<center><h2><strong>Ubuntu</strong></h2>
­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­
<!DOCTYPE html>
<html>
<?php

/**
 * Matomo - free/libre analytics platform
 *
 * @link https://matomo.org
 * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
 */
namespace Piwik\Plugins\TagManager\Dao;

use Piwik\Common;
use Piwik\Db;
use Piwik\DbHelper;
use Piwik\Plugins\TagManager\Model\Environment;
class ContainerReleaseDao extends \Piwik\Plugins\TagManager\Dao\BaseDao implements \Piwik\Plugins\TagManager\Dao\TagManagerDao
{
    protected $table = 'tagmanager_container_release';
    public function install()
    {
        DbHelper::createTable($this->table, "\n                  `idcontainerrelease` BIGINT NOT NULL AUTO_INCREMENT,\n                  `idcontainer` VARCHAR(8) NOT NULL,\n                  `idcontainerversion` BIGINT UNSIGNED NOT NULL,\n                  `idsite` int(11) UNSIGNED NOT NULL,\n                  `status` VARCHAR(10) NOT NULL,\n                  `environment` VARCHAR(" . Environment::MAX_LENGTH . ") NOT NULL,\n                  `release_login` VARCHAR(100) NOT NULL,\n                  `release_date` DATETIME NOT NULL,\n                  `deleted_date` DATETIME NULL,\n                  PRIMARY KEY(`idcontainerrelease`), KEY(`idsite`, `idcontainer`)");
    }
    public function releaseVersion($idSite, $idContainer, $idContainerVersion, $environment, $releaseLogin, $releaseDate)
    {
        $this->deleteAllVersionsForRelease($idSite, $idContainer, $environment, $releaseDate);
        $status = self::STATUS_ACTIVE;
        $values = array('idcontainer' => $idContainer, 'idcontainerversion' => $idContainerVersion, 'idsite' => $idSite, 'status' => $status, 'environment' => $environment, 'release_date' => $releaseDate, 'release_login' => $releaseLogin);
        return $this->insertRecord($values);
    }
    /**
     * @return array
     */
    public function getAllReleases()
    {
        $table = $this->tablePrefixed;
        $releases = Db::fetchAll("SELECT * FROM {$table}" . ' ORDER BY idcontainerrelease ASC');
        return $this->enrichReleases($releases);
    }
    /**
     * @return array
     */
    public function getAllReleasedContainers()
    {
        $table = $this->tablePrefixed;
        $containerTable = Common::prefixTable('tagmanager_container');
        $sql = "SELECT crd.idcontainer, crd.idsite \n                FROM {$table} crd \n                LEFT JOIN {$containerTable} conr ON crd.idcontainer = conr.idcontainer \n                WHERE conr.`status` = ? and crd.`status` = ? group by crd.idsite, crd.idcontainer\n                                                             order by crd.idsite, crd.idcontainer";
        $containers = Db::fetchAll($sql, array(self::STATUS_ACTIVE, self::STATUS_ACTIVE));
        return $containers;
    }
    /**
     * @param int $idSite
     * @param int $idContainer
     * @return array
     */
    public function getReleasesOfContainer($idSite, $idContainer)
    {
        $table = $this->tablePrefixed;
        $releases = Db::fetchAll("SELECT * FROM {$table} WHERE `status` = ? and idsite = ? and idcontainer = ? ORDER BY release_date ASC", array(self::STATUS_ACTIVE, $idSite, $idContainer));
        return $this->enrichReleases($releases);
    }
    /**
     * @param int $idSite
     * @param int $idContainer
     * @param int $idContainerVersion
     * @return array
     */
    public function getReleasesForContainerVersion($idSite, $idContainer, $idContainerVersion)
    {
        $table = $this->tablePrefixed;
        $bind = array(self::STATUS_ACTIVE, $idSite, $idContainer, $idContainerVersion);
        $releases = Db::fetchAll("SELECT * FROM {$table} WHERE `status` = ? and idsite = ? and idcontainer = ? and idcontainerversion = ? ORDER BY release_date ASC", $bind);
        return $this->enrichReleases($releases);
    }
    /**
     * @param int $idSite
     * @param int $idContainer
     * @param string $environment
     * @return array
     */
    public function getReleaseForContainerVersion($idSite, $idContainer, $environment)
    {
        $table = $this->tablePrefixed;
        $bind = array(self::STATUS_ACTIVE, $idSite, $idContainer, $environment);
        $release = Db::fetchRow("SELECT * FROM {$table} WHERE `status` = ? and idsite = ? and idcontainer = ? and environment = ?", $bind);
        return $this->enrichRelease($release);
    }
    /**
     * @param int $idSite
     * @param string $deletedDate
     */
    public function deleteAllVersionsForSite($idSite, $deletedDate)
    {
        $table = $this->tablePrefixed;
        $query = "UPDATE {$table} SET status = ?, deleted_date = ? WHERE idsite = ? and status != ?";
        $bind = array(self::STATUS_DELETED, $deletedDate, $idSite, self::STATUS_DELETED);
        Db::query($query, $bind);
    }
    /**
     * @param int $idSite
     * @param string $deletedDate
     */
    public function deleteAllVersionsForRelease($idSite, $idContainer, $environment, $deletedDate)
    {
        $query = sprintf("UPDATE %s SET status = ?, deleted_date = ? WHERE idsite = ? and idcontainer = ? and environment = ? and status != ?", $this->tablePrefixed);
        $bind = array(self::STATUS_DELETED, $deletedDate, $idSite, $idContainer, $environment, self::STATUS_DELETED);
        Db::query($query, $bind);
    }
    public function deleteNoLongerExistingEnvironmentReleases($availableEnvironments, $deletedDate)
    {
        $availableEnvironments[] = Environment::ENVIRONMENT_LIVE;
        // we make sure they are set as we never want to remove them
        $availableEnvironments[] = Environment::ENVIRONMENT_PREVIEW;
        $availableEnvironments = array_values(array_unique($availableEnvironments));
        $values = Common::getSqlStringFieldsArray($availableEnvironments);
        $query = sprintf("UPDATE %s SET status = ?, deleted_date = ? WHERE status != ? and environment not in (%s)", $this->tablePrefixed, $values);
        $bind = array(self::STATUS_DELETED, $deletedDate, self::STATUS_DELETED);
        foreach ($availableEnvironments as $availableEnvironment) {
            $bind[] = $availableEnvironment;
        }
        $query = Db::query($query, $bind);
        return $query->rowCount();
    }
    protected function isNameAlreadyUsed(int $idSite, string $name, ?int $idContainerVersion = null) : bool
    {
        // This is hard coded since releases don't have a name and therefore don't use this method
        return \true;
    }
    private function enrichReleases($releases)
    {
        if (empty($releases)) {
            return array();
        }
        foreach ($releases as $index => $release) {
            $releases[$index] = $this->enrichRelease($release);
        }
        return $releases;
    }
    private function enrichRelease($release)
    {
        if (empty($release)) {
            return $release;
        }
        $release['idcontainerrelease'] = (int) $release['idcontainerrelease'];
        $release['idcontainerversion'] = (int) $release['idcontainerversion'];
        $release['idsite'] = (int) $release['idsite'];
        return $release;
    }
}
