# -*- coding: utf-8 -*-
################################################################################
#
#    Cybrosys Technologies Pvt. Ltd.
#
#    Copyright (C) 2024-TODAY Cybrosys Technologies(<https://www.cybrosys.com>)
#    Author: Saneen K (odoo@cybrosys.com)
#
#    You can modify it under the terms of the GNU AFFERO
#    GENERAL PUBLIC LICENSE (AGPL v3), Version 3.
#
#    This program is distributed in the hope that it will be useful,
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#    GNU AFFERO GENERAL PUBLIC LICENSE (AGPL v3) for more details.
#
#    You should have received a copy of the GNU AFFERO GENERAL PUBLIC LICENSE
#    (AGPL v3) along with this program.
#    If not, see <http://www.gnu.org/licenses/>.
#
################################################################################
from odoo import api, fields, models


class ProductStockLocation(models.Model):
    """ Inherits stock.quant """
    _inherit = "stock.quant"

    virtual_available = fields.Float(string='Forecasted Quantity',
                                     compute="_compute_location_qty",
                                     help="Forecasted Quantity")
    incoming_qty = fields.Float(string='Incoming',
                                compute="_compute_location_qty",
                                help="Incoming Quantity")
    outgoing_qty = fields.Float(string='Outgoing',
                                compute="_compute_location_qty",
                                help="Outgoing Quantity")
    brand_id = fields.Many2one(related='product_id.brand_id',
                               string='Brand', store=True, readonly=True,
                               help="Product brand")

    def _compute_location_qty(self):
        """Method to compute the quantity of incoming and outgoing stock."""
        for rec in self:
            product = rec.product_id
            rec.virtual_available = product.with_context(
                {'location': rec.location_id.id}).virtual_available
            rec.incoming_qty = product.with_context(
                {'location': rec.location_id.id}).incoming_qty
            rec.outgoing_qty = product.with_context(
                {'location': rec.location_id.id}).outgoing_qty

    @api.model
    def get_out_of_stock(self):
        """rpc method of out of stock graph
        Returns products and quantity"""
        company_id = self.env.company.id
        sett_out_stock_bool = self.env['ir.config_parameter'].sudo(). \
            get_param("inventory_stock_dashboard_odoo.out_of_stock", default="")
        sett_out_stock_quantity = self.env['ir.config_parameter'].sudo(). \
            get_param("inventory_stock_dashboard_odoo.out_of_stock_quantity",
                      default="")
        if sett_out_stock_bool == "True":
            if sett_out_stock_quantity:
                out_stock_value = int(sett_out_stock_quantity)
                query = '''select product_template.name,sum(stock_quant.quantity)
                 from stock_quant inner join product_product on stock_quant.
                 product_id = product_product.id inner join product_template on 
                 product_product.product_tmpl_id = product_template.id  where 
                 stock_quant.quantity < %s and stock_quant.company_id = %s group
                 by product_template.name''' \
                 % (out_stock_value, company_id)
                self._cr.execute(query)
                result = self._cr.fetchall()
                total_quantity = []
                for record in result:
                    total_quantity.append(record[1])
                product_name = []
                for record in result:
                    product_name.append(record[0])
                value = {
                    'product_name': product_name,
                    'total_quantity': total_quantity
                }
                return value