ezsystems / ezpublish-kernel

     * @param int $newParent

     * @param int $opcode

     */

    public function updateNodeAssignment($contentObjectId, $oldParent, $newParent, $opcode)

    {

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

        $query

            ->update($this->handler->quoteTable('eznode_assignment'))

            ->set(

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

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

            )

            ->set(

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

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

            )

            ->where(

                $query->expr->lAnd(

                    $query->expr->eq(

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

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

                    ),

                    $query->expr->eq(

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

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

                    )

                )

            );

        $query->prepare()->execute();

    }

    /**

     * Create locations from node assignments.

     *

     * @return bool

     */

    public function remove($action, $id = null)

    {

        /** @var $query \eZ\Publish\Core\Persistence\Database\DeleteQuery */

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

        $query->deleteFrom(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

        if ($id !== null) {

            $query->where(

                $query->expr->lAnd(

                    $query->expr->eq(

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

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

                    ),

                    $query->expr->eq(

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

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

                    )

                )

            );

        }

        $query->prepare()->execute();

    }

    /**

     * Loads all autogenerated entries with given $parentId with optionally included history entries.