You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
85 lines
3.9 KiB
85 lines
3.9 KiB
# -*- 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
|
|
|