ezsystems / ezpublish-kernel

     *

     * @return int

     */

    public function getContentCount($stateId)

    {

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

        $query->select(

            $query->alias($query->expr->count('*'), 'count')

        )->from(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        $count = $statement->fetchColumn();

        return $count !== null ? (int)$count : 0;

    }

    /**

     * Updates the object state priority to provided value.

     *

     * @return array

     */

    public function loadTrashByLocation($locationId)

    {

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

        $query

            ->select('*')

            ->from($this->handler->quoteTable('ezcontentobject_trash'))

            ->where(

                $query->expr->eq(

                    $this->handler->quoteColumn('node_id'),

                    $query->bindValue($locationId)

                )

            );

        $statement = $query->prepare();

        $statement->execute();

        if ($row = $statement->fetch(\PDO::FETCH_ASSOC)) {

            return $row;

        }

        throw new NotFound('trash', $locationId);

    }

    /**

     * List trashed items.