ezsystems / ezpublish-kernel

     *

     * @return array

     */

    public function loadObjectStateDataByIdentifier($identifier, $groupId)

    {

        $query = $this->createObjectStateFindQuery();

        $query->where(

            $query->expr->lAnd(

                $query->expr->eq(

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

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

                ),

                $query->expr->eq(

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

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

                )

            )

        );

        $statement = $query->prepare();

        $statement->execute();

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

    }

    /**

     * Loads data for all object states belonging to group with $groupId ID.

     *

     * @return array

     */

    public function loadVersionInfo($contentId, $versionNo)

    {

        $query = $this->queryBuilder->createVersionInfoFindQuery();

        $query->where(

            $query->expr->lAnd(

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('contentobject_id', 'ezcontentobject_version'),

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

                ),

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('version', 'ezcontentobject_version'),

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

                )

            )

        );

        $statement = $query->prepare();

        $statement->execute();

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

    }

    /**

     * Returns the number of all versions with given status created by the given $userId for content which is not in Trash.