mbirth / cops

     * @param integer $customId

     * @return string|null

     */

    private static function getDatatypeByCustomID($customId)

    {

        $result = Base::getDb()->prepare('SELECT datatype FROM custom_columns WHERE id = ?');

        $result->execute(array($customId));

        if ($post = $result->fetchObject()) {

            return $post->datatype;

        }

        return NULL;

    }

    /**

     * Create a CustomColumnType by CustomID

     * @param integer $customId

     * @return string

     */

    protected static function getTitleByCustomID($customId)

    {

        $result = Base::getDb()->prepare('SELECT name FROM custom_columns WHERE id = ?');

        $result->execute(array($customId));

        if ($post = $result->fetchObject()) {

            return $post->name;

        }

        return "";

    }

    /**

     * Get the query to find all books with a specific value of this column

        return Base::getCountGeneric ("languages", self::ALL_LANGUAGES_ID, Base::PAGE_ALL_LANGUAGES);

    }

    public static function getLanguageById ($languageId) {

        $result = Base::getDb ()->prepare('select id, lang_code  from languages where id = ?');

        $result->execute (array ($languageId));

        if ($post = $result->fetchObject ()) {

            return new Language ($post->id, Language::getLanguageString ($post->lang_code));

        }

        return NULL;

    }

        return Base::getCountGeneric ("publishers", self::ALL_PUBLISHERS_ID, Base::PAGE_ALL_PUBLISHERS);

    }

    public static function getPublisherByBookId ($bookId) {

        $result = Base::getDb ()->prepare('select publishers.id as id, name

from books_publishers_link, publishers

where publishers.id = publisher and book = ?');

        $result->execute (array ($bookId));

        if ($post = $result->fetchObject ()) {

            return new Publisher ($post);

        }

        return NULL;

    }

    public static function getPublisherById ($publisherId) {

        $result = Base::getDb ()->prepare('select id, name

        return NULL;

    }

    public static function getPublisherById ($publisherId) {

        $result = Base::getDb ()->prepare('select id, name

from publishers where id = ?');

        $result->execute (array ($publisherId));

        if ($post = $result->fetchObject ()) {

            return new Publisher ($post);

        }

        return NULL;

    }

    public static function getAllPublishers() {

        return Base::getEntryArrayWithBookNumber (self::SQL_ALL_PUBLISHERS, self::PUBLISHERS_COLUMNS, array (), "Publisher");

        return Base::getCountGeneric ("series", self::ALL_SERIES_ID, Base::PAGE_ALL_SERIES);

    }

    public static function getSerieByBookId ($bookId) {

        $result = Base::getDb ()->prepare('select  series.id as id, name

from books_series_link, series

where series.id = series and book = ?');

        $result->execute (array ($bookId));

        if ($post = $result->fetchObject ()) {

            return new Serie ($post);

        }

        return NULL;

    }

    public static function getSerieById ($serieId) {

        $result = Base::getDb ()->prepare('select id, name  from series where id = ?');

        return NULL;

    }

    public static function getSerieById ($serieId) {

        $result = Base::getDb ()->prepare('select id, name  from series where id = ?');

        $result->execute (array ($serieId));

        if ($post = $result->fetchObject ()) {

            return new Serie ($post);

        }

        return NULL;

    }

    public static function getAllSeries() {

        return Base::getEntryArrayWithBookNumber (self::SQL_ALL_SERIES, self::SERIES_COLUMNS, array (), "Serie");

        return Base::getCountGeneric ("tags", self::ALL_TAGS_ID, Base::PAGE_ALL_TAGS);

    }

    public static function getTagById ($tagId) {

        $result = Base::getDb ()->prepare('select id, name  from tags where id = ?');

        $result->execute (array ($tagId));

        if ($post = $result->fetchObject ()) {

            return new Tag ($post);

        }

        return NULL;

    }

    public static function getAllTags() {

        return Base::getEntryArrayWithBookNumber (self::SQL_ALL_TAGS, self::TAG_COLUMNS, array (), "Tag");