from odoo import models, api, fields
from odoo.exceptions import AccessError, UserError, ValidationError
from datetime import timedelta, date
import logging

_logger = logging.getLogger(__name__)

class ManageStock(models.Model):
    _name = "manage.stock"
    _description = "Manage Stock"
    _inherit = ['mail.thread']
    _rec_name = 'product_id'

    product_id = fields.Many2one('product.product', string="Product", required=True)
    min_stock = fields.Float(string='Min Stock', required=True)
    buffer_stock = fields.Float(string='Buffer Stock', required=True)
    vendor_id = fields.Many2one('res.partner', string="Vendor", required=True)
    qty_available = fields.Float(string='Qty Available', compute='_compute_qty_available')
    qty_onhand = fields.Float(string='Qty Onhand', compute='_compute_qty_available')
    qty_incoming = fields.Float(string='Qty Incoming', related='product_id.incoming_qty')

    _sql_constraints = [
        ('product_unique', 'unique (product_id)', 'This product already has a stock management rule!'),
    ]

    def _compute_qty_available(self):
        for record in self:
            quant_records = self.env['stock.quant'].search([
                ('product_id', '=', record.product_id.id),
                # ('id','in', [80,81]),
                ('location_id', '=', 55)
            ])

            total_available = quant_records.available_quantity or 0.0
            total_onhand = quant_records.quantity or 0.0
            record.qty_available = total_available
            record.qty_onhand = total_onhand

    def create_automatic_purchase(self):
        if not self:
            raise UserError("No stock records selected.")

        automatic_purchase = self.env['automatic.purchase'].create({
            'apo_type': 'reordering',
        })

        lines_to_create = []

        for stock in self:
            location_id = 55

            quant_records = self.env['stock.quant'].search([
                ('product_id', '=', stock.product_id.id),
                ('location_id', '=', location_id)
            ])

            total_available = quant_records.quantity or 0.0

            qty_incoming = stock.product_id.incoming_qty or 0.0

            qty_purchase = stock.buffer_stock - (total_available + qty_incoming)

            qty_purchase = max(qty_purchase, 0.0)

            pricelist = self.env['purchase.pricelist'].search([
                ('product_id', '=', stock.product_id.id),
                ('vendor_id', '=', stock.vendor_id.id)
            ], limit=1)

            price = pricelist.price if pricelist else 0.0
            subtotal = qty_purchase * price

            lines_to_create.append({
                'automatic_purchase_id': automatic_purchase.id,
                'product_id': stock.product_id.id,
                'qty_purchase': qty_purchase,
                'qty_min': stock.min_stock,
                'qty_buffer': stock.buffer_stock,
                'partner_id': stock.vendor_id.id,
                'taxes_id': stock.vendor_id.tax_id.id if stock.vendor_id.tax_id else False,
                'price': price,
                'product_public_category_id': stock.product_id.product_public_category_id.id,
                'brand_id': stock.product_id.brand_id.id,
            })

        self.env['automatic.purchase.line'].create(lines_to_create)

        return {
            'type': 'ir.actions.act_window',
            'res_model': 'automatic.purchase',
            'view_mode': 'form',
            'res_id': automatic_purchase.id,
            'target': 'current',
        }