samwilson / taggedfiles

        return $this->getHashedPath() . '/v' . $version;

    }

    public function getTags()

    {

        $tagsSql = 'SELECT t.id, t.title '

            . ' FROM item_tags it JOIN tags t ON (it.tag=t.id) '

            . ' WHERE it.item=:id '

            . ' ORDER BY t.title ASC ';

        $params = ['id' => $this->getId()];

        return $this->db->query($tagsSql, $params)->fetchAll();

    }

    public function getTagsString()

    {

        return isset($this->data->date_granularity) ? $this->data->date_granularity : self::DATE_GRANULARITY_DEFAULT;

    }

    public function getChangeSets()

    {

        $sql = 'SELECT * FROM changes c'

            .' JOIN changesets cs ON c.changeset = cs.id'

            .' JOIN users u ON u.id = cs.user'

            .' WHERE item = :id'

            .' ORDER BY datetime DESC, cs.id DESC';

        return $this->db->query($sql, ['id'=>$this->getId()])->fetchAll();

    }

}