Jitamin / jitamin

     *

     * @return bool

     */

    public function remove($category_id)

    {

        $this->db->startTransaction();

        $this->db->table(TaskModel::TABLE)->eq('category_id', $category_id)->update(['category_id' => 0]);

        if (!$this->db->table(self::TABLE)->eq('id', $category_id)->remove()) {

            $this->db->cancelTransaction();

            return false;

        }

        $this->db->closeTransaction();

        return true;

    }

    /**

     * Duplicate categories from a project to another one, must be executed inside a transaction.

     *

     * @return bool

     */

    public function remove($project_id, $swimlane_id)

    {

        $this->db->startTransaction();

        // Tasks should not be assigned anymore to this swimlane

        $this->db->table(TaskModel::TABLE)->eq('swimlane_id', $swimlane_id)->update(['swimlane_id' => 0]);

        if (!$this->db->table(self::TABLE)->eq('id', $swimlane_id)->remove()) {

            $this->db->cancelTransaction();

            return false;

        }

        // Re-order positions

        $this->updatePositions($project_id);

        $this->db->closeTransaction();

        return true;

    }

    /**

     * Update swimlane positions after disabling or removing a swimlane.