ezsystems / ezpublish-kernel

     *

     * @return string[][]

     */

    public function loadLanguageData($id)

    {

        $query = $this->createFindQuery();

        $query->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('id'),

                $query->bindValue($id, null, \PDO::PARAM_INT)

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Loads data for the Language with Language Code (eg: eng-GB).

     *

     * @return string[][]

     */

    public function loadLanguageDataByLanguageCode($languageCode)

    {

        $query = $this->createFindQuery();

        $query->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('locale'),

                $query->bindValue($languageCode, null, \PDO::PARAM_STR)

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Creates a Language find query.

     *

     * @return array

     */

    public function loadObjectStateData($stateId)

    {

        $query = $this->createObjectStateFindQuery();

        $query->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('id', 'ezcobj_state'),

                $query->bindValue($stateId, null, \PDO::PARAM_INT)

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Loads data for an object state by identifier.

     *

     * @return array

     */

    public function loadObjectStateGroupData($groupId)

    {

        $query = $this->createObjectStateGroupFindQuery();

        $query->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('id', 'ezcobj_state_group'),

                $query->bindValue($groupId, null, \PDO::PARAM_INT)

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Loads data for an object state group by identifier.

     *

     * @return array

     */

    public function loadObjectStateGroupDataByIdentifier($identifier)

    {

        $query = $this->createObjectStateGroupFindQuery();

        $query->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('identifier', 'ezcobj_state_group'),

                $query->bindValue($identifier, null, \PDO::PARAM_STR)

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Loads data for all object state groups, filtered by $offset and $limit.

     *

     * @return string[][]

     */

    public function loadGroupDataByIdentifier($identifier)

    {

        $q = $this->createGroupLoadQuery();

        $q->where(

            $q->expr->eq(

                $this->dbHandler->quoteColumn('name'),

                $q->bindValue($identifier, null, \PDO::PARAM_STR)

            )

        );

        $stmt = $q->prepare();

        $stmt->execute();

        return $stmt->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Returns an array with data about all Group objects.