from odoo import fields, models, api, _
from odoo.exceptions import AccessError, UserError, ValidationError
from odoo.tools import DEFAULT_SERVER_DATETIME_FORMAT
import logging

_logger = logging.getLogger(__name__)


class SalesOrderPurchaseMatch(models.Model):
    _name = 'sales.order.purchase.match'

    sales_order_id = fields.Many2one('sale.order', string='Sale Order', index=True, required=True, ondelete='cascade')
    purchase_order_id = fields.Many2one('purchase.order', string='PO')
    purchase_line_id = fields.Many2one('purchase.order.line', string='PO Line')
    product_id = fields.Many2one('product.product', string='Product')
    qty_so = fields.Float(string='Qty SO')  
    qty_po = fields.Float(string='Qty PO')
    # picking_id = fields.Many2one('stock.picking', string='Picking')
    # move_id = fields.Many2one('stock.move', string='Move')
    # partner_id = fields.Many2one('res.partner', string='Partner')
    # partner_invoice_id = fields.Many2one('res.partner', string='Invoice Partner')
    # salesperson_id = fields.Many2one('res.users', string='Sales')