I am getting this following error
The operation cannot be completed: another model requires the record being deleted. If possible, archive it instead.
Model: product.enquiry (product.enquiry), Constraint: product_enquiry_product_id_fkey
# Product Enquiry Model
class ProductEnquiryModel(models.Model):
_name = "product.enquiry"
def name_get(self):
result = []
for enquiry in self:
result.append((enquiry.user_id.id, enquiry.user_id.farmer_name))
return result
product_id = fields.Many2one("retailer.products", string = "Product ID")
member_id = fields.Char(string = "Member ID", required=True)
enquired_at = fields.Datetime('Enquired At', readonly=True)
retailer_id = fields.Many2one("res.partner.retailer", string = "Retailer")
# Retailer Products Model
class RetailerProductsModel(models.Model):
_name = "retailer.products"
def name_get(self):
result = []
for product in self:
result.append((product.product_id.id, product.product_id.name))
return result
@api.onchange('product_id')
def getProductInfo(self):
if self.product_id:
self.category_id = self.product_id.categ_id
self.sub_category_id = self.product_id.sub_category_id
self.selling_price = self.product_id.list_price
self.name = self.product_id.name
@api.model
def create(self, vals):
if 'is_offer' in vals and vals['is_offer'] == True:
offers = self.env['product.offers'].create({
'name': vals['offer_type'],
'value': vals['value'],
'offer_type': vals['offer_type'],
})
vals['offer_id'] = offers.id
result = super(RetailerProductsModel, self).create(vals)
return result
name = fields.Char("Product Name")
retailer_id = fields.Many2one("res.partner.retailer", string = "Retailer")
product_id = fields.Many2one("product.template", string = "Product", ondelete='cascade', )
is_offer = fields.Boolean(string = "Offer")
offer_id = fields.Many2one("product.offers", string = "Offer")
selling_price = fields.Float("Price")
min_qty = fields.Integer("Minimum Quantity")
max_qty = fields.Integer("MaximumQuantity")
category_id = fields.Many2one("product.category", string = "Product Category", required=True)
sub_category_id = fields.Many2one("product.sub.category", string="Product Sub Category")
offer_type = fields.Selection([
('flat_discount', 'Flat Discount'),
('percentage', 'Percentage'),
],
'Offer Type')
value = fields.Float(string="Value")
retailer_product_multilingual_ids = fields.One2many('product.master.multilingual', 'retailer_product_multilingual_id', string='Data for Multilingual')
