ezsystems / ezpublish-kernel

     *

     * @return \eZ\Publish\Core\Persistence\Database\SelectQuery

     */

    protected function createObjectStateFindQuery()

    {

        $query = $this->dbHandler->createSelectQuery();

        $query->select(

            // Object state

            $this->dbHandler->aliasedColumn($query, 'default_language_id', 'ezcobj_state'),

            $this->dbHandler->aliasedColumn($query, 'group_id', 'ezcobj_state'),

            $this->dbHandler->aliasedColumn($query, 'id', 'ezcobj_state'),

            $this->dbHandler->aliasedColumn($query, 'identifier', 'ezcobj_state'),

            $this->dbHandler->aliasedColumn($query, 'language_mask', 'ezcobj_state'),

            $this->dbHandler->aliasedColumn($query, 'priority', 'ezcobj_state'),

            // Object state language

            $this->dbHandler->aliasedColumn($query, 'description', 'ezcobj_state_language'),

            $this->dbHandler->aliasedColumn($query, 'language_id', 'ezcobj_state_language'),

            $this->dbHandler->aliasedColumn($query, 'name', 'ezcobj_state_language')

        )->from(

            $this->dbHandler->quoteTable('ezcobj_state')

        )->innerJoin(

            $this->dbHandler->quoteTable('ezcobj_state_language'),

            $query->expr->eq(

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

                $this->dbHandler->quoteColumn('contentobject_state_id', 'ezcobj_state_language')

            )

        );

        return $query;

    }

    /**

     * Creates a generalized query for fetching object state group(s).

     *

     * @return \eZ\Publish\Core\Persistence\Database\SelectQuery

     */

    protected function createObjectStateGroupFindQuery()

    {

        $query = $this->dbHandler->createSelectQuery();

        $query->select(

            // Object state group

            $this->dbHandler->aliasedColumn($query, 'default_language_id', 'ezcobj_state_group'),

            $this->dbHandler->aliasedColumn($query, 'id', 'ezcobj_state_group'),

            $this->dbHandler->aliasedColumn($query, 'identifier', 'ezcobj_state_group'),

            $this->dbHandler->aliasedColumn($query, 'language_mask', 'ezcobj_state_group'),

            // Object state group language

            $this->dbHandler->aliasedColumn($query, 'description', 'ezcobj_state_group_language'),

            $this->dbHandler->aliasedColumn($query, 'language_id', 'ezcobj_state_group_language'),

            $this->dbHandler->aliasedColumn($query, 'real_language_id', 'ezcobj_state_group_language'),

            $this->dbHandler->aliasedColumn($query, 'name', 'ezcobj_state_group_language')

        )->from(

            $this->dbHandler->quoteTable('ezcobj_state_group')

        )->innerJoin(

            $this->dbHandler->quoteTable('ezcobj_state_group_language'),

            $query->expr->eq(

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

                $this->dbHandler->quoteColumn('contentobject_state_group_id', 'ezcobj_state_group_language')

            )

        );

        return $query;

    }

    /**

     * Inserts object state group translations into database.