class MultiQuotationLine(models.Model):
    _name = "x_multi.quotation.line"
    _description = "Multi Quotation Line"
    _rec_name = "order_reference"  # This field will be used for display names
    _order = "sale_order_id, sequence, id"  # Default ordering for records

    # Sequence field allows manual reordering of quotations
    sequence = fields.Integer(string='Sequence', default=10)
    
    # Parent sale order - required link, cascade delete when SO is deleted
    sale_order_id = fields.Many2one("sale.order", required=True, ondelete="cascade")
    
    # Auto-generated reference like "SO001-Op1", "SO001-Op2"
    order_reference = fields.Char("Order Reference", readonly=True, copy=False, default="/")
    
    # User-entered description for this quotation variation
    description = fields.Text("Description")
    
    # One2many relationship - links to sale.order.line records that belong to this quotation
    # copy=False prevents automatic duplication during record copying
    order_lines = fields.One2many(
        "sale.order.line", "multi_quotation_line_id", 
        string="Order Lines", copy=False
    )
    
    # Currency from parent sale order - stored for performance
    currency_id = fields.Many2one(
        "res.currency", related="sale_order_id.currency_id", 
        store=True, readonly=True
    )
    
    # Financial totals - computed from linked order lines
    untaxed_amount = fields.Monetary(
        "Untaxed Amount", currency_field="currency_id",
        compute="_compute_amounts", store=True
    )
    taxes = fields.Monetary(
        "Taxes", currency_field="currency_id",
        compute="_compute_amounts", store=True
    )
    total = fields.Monetary(
        "Total", currency_field="currency_id",
        compute="_compute_amounts", store=True
    )

    @api.depends("order_lines.price_total", "order_lines.price_tax", "order_lines.price_subtotal")
    def _compute_amounts(self):
        """
        Calculate financial totals by summing amounts from all linked order lines.
        This method runs whenever the dependent fields change.
        """
        for rec in self:
            # Sum subtotals (amounts before tax) from all active order lines
            untaxed = sum(line.price_subtotal for line in rec.order_lines)
            # Sum tax amounts from all active order lines
            taxes = sum(line.price_tax for line in rec.order_lines)
            
            # Update the computed fields
            rec.untaxed_amount = untaxed
            rec.taxes = taxes
            rec.total = untaxed + taxes

class MultiQuotationLine(models.Model):
    _name = "x_multi.quotation.line"
    _description = "Multi Quotation Line"
    _rec_name = "order_reference"  # This field will be used for display names
    _order = "sale_order_id, sequence, id"  # Default ordering for records

    # Sequence field allows manual reordering of quotations
    sequence = fields.Integer(string='Sequence', default=10)
    
    # Parent sale order - required link, cascade delete when SO is deleted
    sale_order_id = fields.Many2one("sale.order", required=True, ondelete="cascade")
    
    # Auto-generated reference like "SO001-Op1", "SO001-Op2"
    order_reference = fields.Char("Order Reference", readonly=True, copy=False, default="/")
    
    # User-entered description for this quotation variation
    description = fields.Text("Description")
    
    # One2many relationship - links to sale.order.line records that belong to this quotation
    # copy=False prevents automatic duplication during record copying
    order_lines = fields.One2many(
        "sale.order.line", "multi_quotation_line_id", 
        string="Order Lines", copy=False
    )
    
    # Currency from parent sale order - stored for performance
    currency_id = fields.Many2one(
        "res.currency", related="sale_order_id.currency_id", 
        store=True, readonly=True
    )
    
    # Financial totals - computed from linked order lines
    untaxed_amount = fields.Monetary(
        "Untaxed Amount", currency_field="currency_id",
        compute="_compute_amounts", store=True
    )
    taxes = fields.Monetary(
        "Taxes", currency_field="currency_id",
        compute="_compute_amounts", store=True
    )
    total = fields.Monetary(
        "Total", currency_field="currency_id",
        compute="_compute_amounts", store=True
    )

    @api.depends("order_lines.price_total", "order_lines.price_tax", "order_lines.price_subtotal")
    def _compute_amounts(self):
        """
        Calculate financial totals by summing amounts from all linked order lines.
        This method runs whenever the dependent fields change.
        """
        for rec in self:
            # Sum subtotals (amounts before tax) from all active order lines
            untaxed = sum(line.price_subtotal for line in rec.order_lines)
            # Sum tax amounts from all active order lines
            taxes = sum(line.price_tax for line in rec.order_lines)
            
            # Update the computed fields
            rec.untaxed_amount = untaxed
            rec.taxes = taxes
            rec.total = untaxed + taxes

class SaleOrder(models.Model):
    _inherit = "sale.order"

    # Boolean flag to enable/disable multi-quotation mode for this sale order
    is_multi_quotation = fields.Boolean(
        string="Multi Quotation",
        help="Enable multi quotation mode to use quotation lines",
    )
    
    # One2many relationship to all quotation variations for this sale order
    multi_quotation_line_ids = fields.One2many(
        "x_multi.quotation.line", "sale_order_id", 
        string="Quotation Lines"
    )
    
    # Reference to the quotation that was selected during finalization
    # This field being set indicates the sale order is no longer in multi-quotation mode
    finalized_quotation_line_id = fields.Many2one(
        "x_multi.quotation.line",
        string="Finalized Quotation",
        readonly=True,
        help="The quotation line that was finalized",
    )

    def action_confirm(self):
        """
        Override the standard confirmation method to add multi-quotation validation.
        Prevents users from confirming a multi-quotation order without finalizing first.
        """
        self.ensure_one()  # Ensure we're working with a single record
        
        # Check if this is a multi-quotation that hasn't been finalized yet
        if self.is_multi_quotation and not self.finalized_quotation_line_id:
            raise UserError(_("Please finalize a quotation first before confirming the Sale Order."))
        
        # If validation passes, proceed with standard Odoo confirmation process
        return super(SaleOrder, self).action_confirm()

class SaleOrder(models.Model):
    _inherit = "sale.order"

    # Boolean flag to enable/disable multi-quotation mode for this sale order
    is_multi_quotation = fields.Boolean(
        string="Multi Quotation",
        help="Enable multi quotation mode to use quotation lines",
    )
    
    # One2many relationship to all quotation variations for this sale order
    multi_quotation_line_ids = fields.One2many(
        "x_multi.quotation.line", "sale_order_id", 
        string="Quotation Lines"
    )
    
    # Reference to the quotation that was selected during finalization
    # This field being set indicates the sale order is no longer in multi-quotation mode
    finalized_quotation_line_id = fields.Many2one(
        "x_multi.quotation.line",
        string="Finalized Quotation",
        readonly=True,
        help="The quotation line that was finalized",
    )

    def action_confirm(self):
        """
        Override the standard confirmation method to add multi-quotation validation.
        Prevents users from confirming a multi-quotation order without finalizing first.
        """
        self.ensure_one()  # Ensure we're working with a single record
        
        # Check if this is a multi-quotation that hasn't been finalized yet
        if self.is_multi_quotation and not self.finalized_quotation_line_id:
            raise UserError(_("Please finalize a quotation first before confirming the Sale Order."))
        
        # If validation passes, proceed with standard Odoo confirmation process
        return super(SaleOrder, self).action_confirm()

class SaleOrderLine(models.Model):
    _inherit = 'sale.order.line'

    # Controls visibility of this line - hidden lines don't contribute to totals
    # Default True ensures standard behavior for non-multi-quotation orders
    active = fields.Boolean("Active", default=True)
    
    # Foreign key linking this order line to its parent quotation
    # ondelete='cascade': Delete this line if parent quotation is deleted
    # copy=False: Don't duplicate this relationship when copying records
    multi_quotation_line_id = fields.Many2one(
        'x_multi.quotation.line', 
        string='Multi Quotation Line', 
        ondelete='cascade', 
        index=True,  # Database index for faster queries
        copy=False
    )

    @api.depends('product_uom_qty', 'price_unit', 'tax_id', 'discount', 'product_id')
    def _compute_amount(self):
        """
        Override Odoo's standard amount calculation to handle inactive lines.
        Inactive lines (from non-finalized quotations) should contribute $0 to totals.
        """
        # First, run Odoo's standard calculation logic
        super()._compute_amount()
        
        # Then, zero out amounts for inactive lines
        for line in self:
            # Check if this line is inactive (hidden)
            if not getattr(line, 'active', True):
                # Set all monetary fields to zero for inactive lines
                line.update({
                    'price_subtotal': 0.0,  # Subtotal before taxes
                    'price_tax': 0.0,       # Tax amount
                    'price_total': 0.0,     # Total including taxes
                })

class SaleOrderLine(models.Model):
    _inherit = 'sale.order.line'

    # Controls visibility of this line - hidden lines don't contribute to totals
    # Default True ensures standard behavior for non-multi-quotation orders
    active = fields.Boolean("Active", default=True)
    
    # Foreign key linking this order line to its parent quotation
    # ondelete='cascade': Delete this line if parent quotation is deleted
    # copy=False: Don't duplicate this relationship when copying records
    multi_quotation_line_id = fields.Many2one(
        'x_multi.quotation.line', 
        string='Multi Quotation Line', 
        ondelete='cascade', 
        index=True,  # Database index for faster queries
        copy=False
    )

    @api.depends('product_uom_qty', 'price_unit', 'tax_id', 'discount', 'product_id')
    def _compute_amount(self):
        """
        Override Odoo's standard amount calculation to handle inactive lines.
        Inactive lines (from non-finalized quotations) should contribute $0 to totals.
        """
        # First, run Odoo's standard calculation logic
        super()._compute_amount()
        
        # Then, zero out amounts for inactive lines
        for line in self:
            # Check if this line is inactive (hidden)
            if not getattr(line, 'active', True):
                # Set all monetary fields to zero for inactive lines
                line.update({
                    'price_subtotal': 0.0,  # Subtotal before taxes
                    'price_tax': 0.0,       # Tax amount
                    'price_total': 0.0,     # Total including taxes
                })

class AddQuotationLineWizard(models.TransientModel):
    _name = "x_add.quotation.line.wizard"
    _description = "Wizard to add or edit a multi quotation line"

    # Parent sale order - populated from context when wizard is opened
    sale_order_id = fields.Many2one('sale.order', readonly=True, required=True)
    
    # If editing existing quotation, this field holds the quotation being edited
    # If creating new quotation, this remains empty
    quotation_line_id = fields.Many2one('x_multi.quotation.line', readonly=True)
    
    # Transient lines - temporary records that exist only during wizard session
    # These get converted to permanent sale.order.line records when saved
    order_lines = fields.One2many(
        'x_add.quotation.line.wizard.line', 'wizard_id', 
        string='Order Lines'
    )
    
    # User-entered description for this quotation variation
    description = fields.Text(string='Description')
    
    # Computed summary fields - calculated from transient order_lines
    untaxed_amount = fields.Monetary(
        string='Untaxed Amount', currency_field='currency_id',
        compute='_compute_summary'
    )
    taxes = fields.Monetary(
        string='Taxes', currency_field='currency_id',
        compute='_compute_summary'
    )
    total = fields.Monetary(
        string="Total", compute="_compute_summary", readonly=True
    )

    @api.depends('order_lines.price_subtotal', 'order_lines.price_tax')
    def _compute_summary(self):
        """
        Calculate wizard totals by summing transient line amounts.
        This provides real-time feedback as users build their quotation.
        """
        for rec in self:
            # Sum amounts from all transient wizard lines
            untaxed = sum(line.price_subtotal for line in rec.order_lines)
            taxes = sum(line.price_tax for line in rec.order_lines)
            
            # Update computed summary fields
            rec.untaxed_amount = untaxed
            rec.taxes = taxes
            rec.total = untaxed + taxes

class AddQuotationLineWizard(models.TransientModel):
    _name = "x_add.quotation.line.wizard"
    _description = "Wizard to add or edit a multi quotation line"

    # Parent sale order - populated from context when wizard is opened
    sale_order_id = fields.Many2one('sale.order', readonly=True, required=True)
    
    # If editing existing quotation, this field holds the quotation being edited
    # If creating new quotation, this remains empty
    quotation_line_id = fields.Many2one('x_multi.quotation.line', readonly=True)
    
    # Transient lines - temporary records that exist only during wizard session
    # These get converted to permanent sale.order.line records when saved
    order_lines = fields.One2many(
        'x_add.quotation.line.wizard.line', 'wizard_id', 
        string='Order Lines'
    )
    
    # User-entered description for this quotation variation
    description = fields.Text(string='Description')
    
    # Computed summary fields - calculated from transient order_lines
    untaxed_amount = fields.Monetary(
        string='Untaxed Amount', currency_field='currency_id',
        compute='_compute_summary'
    )
    taxes = fields.Monetary(
        string='Taxes', currency_field='currency_id',
        compute='_compute_summary'
    )
    total = fields.Monetary(
        string="Total", compute="_compute_summary", readonly=True
    )

    @api.depends('order_lines.price_subtotal', 'order_lines.price_tax')
    def _compute_summary(self):
        """
        Calculate wizard totals by summing transient line amounts.
        This provides real-time feedback as users build their quotation.
        """
        for rec in self:
            # Sum amounts from all transient wizard lines
            untaxed = sum(line.price_subtotal for line in rec.order_lines)
            taxes = sum(line.price_tax for line in rec.order_lines)
            
            # Update computed summary fields
            rec.untaxed_amount = untaxed
            rec.taxes = taxes
            rec.total = untaxed + taxes

class AddQuotationLineWizardLine(models.TransientModel):
    _name = "x_add.quotation.line.wizard.line"
    _description = "Wizard Order Line for Multi Quotation"

    wizard_id = fields.Many2one(
        'x_add.quotation.line.wizard', 
        string='Quotation Wizard', 
        required=True, 
        ondelete='cascade'
    )
    
    # Product fields
    product_id = fields.Many2one('product.product', string='Product')
    name = fields.Text(string='Description')
    product_uom_qty = fields.Float(string='Quantity', default=1.0)
    product_uom = fields.Many2one('uom.uom', string='UoM')
    price_unit = fields.Float(string='Unit Price', required=True)
    
    # Computed totals
    price_subtotal = fields.Monetary(
        string='Subtotal', compute='_compute_line_totals', 
        store=True, currency_field='currency_id'
    )
    tax_id = fields.Many2many('account.tax', string='Taxes')

    @api.depends('product_uom_qty', 'price_unit', 'tax_id', 'product_id')
    def _compute_line_totals(self):
        for line in self:
            if not line.product_id:
                line.price_tax = 0.0
                line.price_subtotal = 0.0
                line.price_total = 0.0
                continue

            taxes = line.tax_id.compute_all(
                line.price_unit, line.currency_id, line.product_uom_qty,
                product=line.product_id,
                partner=line.wizard_id.sale_order_id.partner_id
            )
            line.price_tax = sum(t.get('amount', 0.0) for t in taxes.get('taxes', []))
            line.price_subtotal = taxes.get('total_excluded', 0.0)
            line.price_total = taxes.get('total_included', 0.0)

class AddQuotationLineWizardLine(models.TransientModel):
    _name = "x_add.quotation.line.wizard.line"
    _description = "Wizard Order Line for Multi Quotation"

    wizard_id = fields.Many2one(
        'x_add.quotation.line.wizard', 
        string='Quotation Wizard', 
        required=True, 
        ondelete='cascade'
    )
    
    # Product fields
    product_id = fields.Many2one('product.product', string='Product')
    name = fields.Text(string='Description')
    product_uom_qty = fields.Float(string='Quantity', default=1.0)
    product_uom = fields.Many2one('uom.uom', string='UoM')
    price_unit = fields.Float(string='Unit Price', required=True)
    
    # Computed totals
    price_subtotal = fields.Monetary(
        string='Subtotal', compute='_compute_line_totals', 
        store=True, currency_field='currency_id'
    )
    tax_id = fields.Many2many('account.tax', string='Taxes')

    @api.depends('product_uom_qty', 'price_unit', 'tax_id', 'product_id')
    def _compute_line_totals(self):
        for line in self:
            if not line.product_id:
                line.price_tax = 0.0
                line.price_subtotal = 0.0
                line.price_total = 0.0
                continue

            taxes = line.tax_id.compute_all(
                line.price_unit, line.currency_id, line.product_uom_qty,
                product=line.product_id,
                partner=line.wizard_id.sale_order_id.partner_id
            )
            line.price_tax = sum(t.get('amount', 0.0) for t in taxes.get('taxes', []))
            line.price_subtotal = taxes.get('total_excluded', 0.0)
            line.price_total = taxes.get('total_included', 0.0)

def action_add_line(self):
    """
    Main action method that converts transient wizard data into permanent records.
    This method handles both creating new quotations and editing existing ones.
    """
    # Validation: Ensure user has added at least one product
    if not self.order_lines:
        raise UserError(_("Please add at least one product line."))

    # Prepare data for the multi-quotation line record
    vals = {
        "sale_order_id": self.sale_order_id.id,  # Link to parent sale order
        "description": self.description,          # User-entered description
        # Note: order_reference will be auto-generated in create() method
        # Note: financial totals will be computed automatically from linked lines
    }

    ql = False  # Variable to hold the quotation line record

    # EDIT vs CREATE logic
    if self.quotation_line_id:
        # EDITING EXISTING QUOTATION
        ql = self.quotation_line_id
        ql.write(vals)  # Update existing record with new description
        
        # Remove all existing sale.order.line records for this quotation
        # This ensures a clean slate - we'll recreate all lines from wizard data
        lines_to_unlink = self.env['sale.order.line'].search([
            ('multi_quotation_line_id', '=', ql.id)
        ])
        lines_to_unlink.unlink()  # Permanently delete old lines
        
    else:
        # CREATING NEW QUOTATION
        ql = self.env["x_multi.quotation.line"].create(vals)
        # Link the new quotation to the parent sale order
        self.sale_order_id.write({"multi_quotation_line_ids": [(4, ql.id)]})

    # Convert transient wizard lines to permanent sale.order.line records
    for line in self.order_lines:
        # Prepare data for permanent sale order line
        new_so_line_vals = {
            # Links - connect this line to both sale order and quotation
            "order_id": self.sale_order_id.id,
            "multi_quotation_line_id": ql.id,
            
            # Product information
            "product_id": line.product_id.id,
            "name": line.name,                      # Product description
            "product_uom_qty": line.product_uom_qty, # Quantity ordered
            "product_uom": line.product_uom.id,     # Unit of measure
            "price_unit": line.price_unit,          # Unit price
            
            # Taxes - convert many2many relationship format
            "tax_id": [(6, 0, line.tax_id.ids)] if line.tax_id else False,
            
            # Additional fields that might be set by user
            "discount": line.discount if hasattr(line, 'discount') else 0.0,
            "sequence": line.sequence if hasattr(line, 'sequence') else 10,
        }
        
        # Create the permanent sale order line record
        self.env["sale.order.line"].create(new_so_line_vals)

    # Close the wizard window - user returns to main sale order form
    return {"type": "ir.actions.act_window_close"}

def action_add_line(self):
    """
    Main action method that converts transient wizard data into permanent records.
    This method handles both creating new quotations and editing existing ones.
    """
    # Validation: Ensure user has added at least one product
    if not self.order_lines:
        raise UserError(_("Please add at least one product line."))

    # Prepare data for the multi-quotation line record
    vals = {
        "sale_order_id": self.sale_order_id.id,  # Link to parent sale order
        "description": self.description,          # User-entered description
        # Note: order_reference will be auto-generated in create() method
        # Note: financial totals will be computed automatically from linked lines
    }

    ql = False  # Variable to hold the quotation line record

    # EDIT vs CREATE logic
    if self.quotation_line_id:
        # EDITING EXISTING QUOTATION
        ql = self.quotation_line_id
        ql.write(vals)  # Update existing record with new description
        
        # Remove all existing sale.order.line records for this quotation
        # This ensures a clean slate - we'll recreate all lines from wizard data
        lines_to_unlink = self.env['sale.order.line'].search([
            ('multi_quotation_line_id', '=', ql.id)
        ])
        lines_to_unlink.unlink()  # Permanently delete old lines
        
    else:
        # CREATING NEW QUOTATION
        ql = self.env["x_multi.quotation.line"].create(vals)
        # Link the new quotation to the parent sale order
        self.sale_order_id.write({"multi_quotation_line_ids": [(4, ql.id)]})

    # Convert transient wizard lines to permanent sale.order.line records
    for line in self.order_lines:
        # Prepare data for permanent sale order line
        new_so_line_vals = {
            # Links - connect this line to both sale order and quotation
            "order_id": self.sale_order_id.id,
            "multi_quotation_line_id": ql.id,
            
            # Product information
            "product_id": line.product_id.id,
            "name": line.name,                      # Product description
            "product_uom_qty": line.product_uom_qty, # Quantity ordered
            "product_uom": line.product_uom.id,     # Unit of measure
            "price_unit": line.price_unit,          # Unit price
            
            # Taxes - convert many2many relationship format
            "tax_id": [(6, 0, line.tax_id.ids)] if line.tax_id else False,
            
            # Additional fields that might be set by user
            "discount": line.discount if hasattr(line, 'discount') else 0.0,
            "sequence": line.sequence if hasattr(line, 'sequence') else 10,
        }
        
        # Create the permanent sale order line record
        self.env["sale.order.line"].create(new_so_line_vals)

    # Close the wizard window - user returns to main sale order form
    return {"type": "ir.actions.act_window_close"}

class FinalizeQuotationWizard(models.TransientModel):
    _name = "x_finalize.quotation.wizard"
    _description = "Wizard to finalize a Multi Quotation"

    sale_order_id = fields.Many2one("sale.order", string="Sale Order", required=True, readonly=True)
    finalized_line_id = fields.Many2one(
        "x_multi.quotation.line",
        string="Finalized Quotation",
        required=True,
        domain="[('id', 'in', multi_quotation_line_ids)]"
    )

    def action_finalize(self):
        self.ensure_one()
        sale_order = self.sale_order_id
        finalized_line = self.finalized_line_id

        # Get all sale order lines
        all_so_lines = sale_order.order_line
        multi_quotation_lines = all_so_lines.filtered(
            lambda line: line.multi_quotation_line_id
        )
        
        # Identify finalized vs non-finalized lines
        lines_from_finalized = multi_quotation_lines.filtered(
            lambda line: line.multi_quotation_line_id == finalized_line
        )
        non_finalized_lines = multi_quotation_lines - lines_from_finalized

        # Hide non-finalized lines
        if non_finalized_lines:
            non_finalized_lines.write({'active': False})

        # Ensure finalized lines are active
        if lines_from_finalized.filtered(lambda l: not l.active):
            lines_from_finalized.write({'active': True})

        # Update sale order
        sale_order.write({
            'finalized_quotation_line_id': finalized_line.id,
            'is_multi_quotation': False,
        })

        return {
            'type': 'ir.actions.act_window',
            'name': 'Sale Order',
            'res_model': 'sale.order',
            'res_id': sale_order.id,
            'view_mode': 'form',
            'target': 'current',
        }

class FinalizeQuotationWizard(models.TransientModel):
    _name = "x_finalize.quotation.wizard"
    _description = "Wizard to finalize a Multi Quotation"

    sale_order_id = fields.Many2one("sale.order", string="Sale Order", required=True, readonly=True)
    finalized_line_id = fields.Many2one(
        "x_multi.quotation.line",
        string="Finalized Quotation",
        required=True,
        domain="[('id', 'in', multi_quotation_line_ids)]"
    )

    def action_finalize(self):
        self.ensure_one()
        sale_order = self.sale_order_id
        finalized_line = self.finalized_line_id

        # Get all sale order lines
        all_so_lines = sale_order.order_line
        multi_quotation_lines = all_so_lines.filtered(
            lambda line: line.multi_quotation_line_id
        )
        
        # Identify finalized vs non-finalized lines
        lines_from_finalized = multi_quotation_lines.filtered(
            lambda line: line.multi_quotation_line_id == finalized_line
        )
        non_finalized_lines = multi_quotation_lines - lines_from_finalized

        # Hide non-finalized lines
        if non_finalized_lines:
            non_finalized_lines.write({'active': False})

        # Ensure finalized lines are active
        if lines_from_finalized.filtered(lambda l: not l.active):
            lines_from_finalized.write({'active': True})

        # Update sale order
        sale_order.write({
            'finalized_quotation_line_id': finalized_line.id,
            'is_multi_quotation': False,
        })

        return {
            'type': 'ir.actions.act_window',
            'name': 'Sale Order',
            'res_model': 'sale.order',
            'res_id': sale_order.id,
            'view_mode': 'form',
            'target': 'current',
        }

<xpath expr="//page[@name='order_lines']" position="attributes">
    <attribute name="attrs">{'invisible': [('is_multi_quotation', '=', True)]}</attribute>
</xpath>

<page string="Quotation Lines" name="quotation_lines"
      attrs="{'invisible': [('is_multi_quotation', '=', False)]}">
    <button name="%(action_add_quotation_line_wizard)d"
            type="action"
            string="Add Quotation"
            class="btn-primary"/>
    
    <field name="multi_quotation_line_ids" nolabel="1">
        <tree string="Quotation Lines">
            <field name="order_reference"/>
            <field name="description"/>
            <field name="untaxed_amount" string="Subtotal"/>
            <field name="taxes"/>
            <field name="total"/>
            <button name="action_open_wizard" type="object" 
                    string="" icon="fa-pencil"/>
        </tree>
    </field>
</page>

<xpath expr="//page[@name='order_lines']" position="attributes">
    <attribute name="attrs">{'invisible': [('is_multi_quotation', '=', True)]}</attribute>
</xpath>

<page string="Quotation Lines" name="quotation_lines"
      attrs="{'invisible': [('is_multi_quotation', '=', False)]}">
    <button name="%(action_add_quotation_line_wizard)d"
            type="action"
            string="Add Quotation"
            class="btn-primary"/>
    
    <field name="multi_quotation_line_ids" nolabel="1">
        <tree string="Quotation Lines">
            <field name="order_reference"/>
            <field name="description"/>
            <field name="untaxed_amount" string="Subtotal"/>
            <field name="taxes"/>
            <field name="total"/>
            <button name="action_open_wizard" type="object" 
                    string="" icon="fa-pencil"/>
        </tree>
    </field>
</page>

<field name="order_lines" widget="section_and_note_one2many">
    <tree editable="bottom" create="true" delete="true">
        <control>
            <create name="add_product_control" string="Add a line"/>
            <create name="add_section_control" string="Add a section" 
                    context="{'default_display_type': 'line_section'}"/>
        </control>
        
        <field name="product_id" string="Product"/>
        <field name="name" string="Description"/>
        <field name="product_uom_qty" string="Quantity"/>
        <field name="price_unit" string="Unit Price"/>
        <field name="price_subtotal" string="Subtotal" readonly="1"/>
    </tree>
</field>

<field name="order_lines" widget="section_and_note_one2many">
    <tree editable="bottom" create="true" delete="true">
        <control>
            <create name="add_product_control" string="Add a line"/>
            <create name="add_section_control" string="Add a section" 
                    context="{'default_display_type': 'line_section'}"/>
        </control>
        
        <field name="product_id" string="Product"/>
        <field name="name" string="Description"/>
        <field name="product_uom_qty" string="Quantity"/>
        <field name="price_unit" string="Unit Price"/>
        <field name="price_subtotal" string="Subtotal" readonly="1"/>
    </tree>
</field>

@api.model
def create(self, vals):
    if not vals.get("order_reference") or vals.get("order_reference") == "/":
        so_id = vals.get("sale_order_id")
        if so_id:
            sale_order = self.env["sale.order"].browse(so_id)
            prefix = f"{sale_order.name}-Op"
            existing_refs = sale_order.multi_quotation_line_ids.filtered(
                lambda m: m.order_reference and m.order_reference.startswith(prefix)
            ).mapped("order_reference")
            
            indices = []
            for ref in existing_refs:
                try:
                    idx = int(ref.replace(prefix, ""))
                    indices.append(idx)
                except ValueError:
                    continue
            
            next_idx = (max(indices) + 1) if indices else 1
            vals["order_reference"] = f"{prefix}{next_idx}"
    
    return super(MultiQuotationLine, self).create(vals)

@api.model
def create(self, vals):
    if not vals.get("order_reference") or vals.get("order_reference") == "/":
        so_id = vals.get("sale_order_id")
        if so_id:
            sale_order = self.env["sale.order"].browse(so_id)
            prefix = f"{sale_order.name}-Op"
            existing_refs = sale_order.multi_quotation_line_ids.filtered(
                lambda m: m.order_reference and m.order_reference.startswith(prefix)
            ).mapped("order_reference")
            
            indices = []
            for ref in existing_refs:
                try:
                    idx = int(ref.replace(prefix, ""))
                    indices.append(idx)
                except ValueError:
                    continue
            
            next_idx = (max(indices) + 1) if indices else 1
            vals["order_reference"] = f"{prefix}{next_idx}"
    
    return super(MultiQuotationLine, self).create(vals)

def copy(self, default=None):
    if default is None:
        default = {}
    
    original_id = self.id
    duplicated_mql = super(MultiQuotationLine, self).copy(default)

    # Copy all child lines including inactive ones
    all_children = self.env['sale.order.line'].with_context(active_test=False).search([
        ('multi_quotation_line_id', '=', original_id)
    ])
    
    for old_line in all_children:
        line_vals = old_line.copy_data()[0]
        line_vals.update({
            'order_id': duplicated_mql.sale_order_id.id,
            'multi_quotation_line_id': duplicated_mql.id,
            'active': True,
        })
        self.env['sale.order.line'].create(line_vals)

    return duplicated_mql

def copy(self, default=None):
    if default is None:
        default = {}
    
    original_id = self.id
    duplicated_mql = super(MultiQuotationLine, self).copy(default)

    # Copy all child lines including inactive ones
    all_children = self.env['sale.order.line'].with_context(active_test=False).search([
        ('multi_quotation_line_id', '=', original_id)
    ])
    
    for old_line in all_children:
        line_vals = old_line.copy_data()[0]
        line_vals.update({
            'order_id': duplicated_mql.sale_order_id.id,
            'multi_quotation_line_id': duplicated_mql.id,
            'active': True,
        })
        self.env['sale.order.line'].create(line_vals)

    return duplicated_mql