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.
59 lines
2.7 KiB
59 lines
2.7 KiB
# -*- coding: utf-8 -*-
|
|
###############################################################################
|
|
#
|
|
# Cybrosys Technologies Pvt. Ltd.
|
|
#
|
|
# Copyright (C) 2023-TODAY Cybrosys Technologies(<https://www.cybrosys.com>)
|
|
# Author: Aysha Shalin (odoo@cybrosys.com)
|
|
#
|
|
# You can modify it under the terms of the GNU LESSER
|
|
# GENERAL PUBLIC LICENSE (LGPL 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 LESSER GENERAL PUBLIC LICENSE (LGPL v3) for more details.
|
|
#
|
|
# You should have received a copy of the GNU LESSER GENERAL PUBLIC LICENSE
|
|
# (LGPL v3) along with this program.
|
|
# If not, see <http://www.gnu.org/licenses/>.
|
|
#
|
|
###############################################################################
|
|
from odoo import api, models
|
|
|
|
|
|
class StockQuant(models.Model):
|
|
""" Extends 'stock.quant' for retrieving data of products that are out of
|
|
stock."""
|
|
_inherit = "stock.quant"
|
|
|
|
@api.model
|
|
def get_out_of_stock(self):
|
|
""" Returns products and quantities that are out of stock."""
|
|
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_product.id,sum(stock_quant.quantity) from product_product
|
|
inner join stock_quant on product_product.id = stock_quant.product_id
|
|
where stock_quant.quantity < %s and stock_quant.company_id = %s group by product_product.id''' \
|
|
% (out_stock_value, company_id)
|
|
self._cr.execute(query)
|
|
result = self._cr.fetchall()
|
|
total_quantity = []
|
|
product_name = []
|
|
for record in result:
|
|
total_quantity.append(record[1])
|
|
for record in result:
|
|
complete_name = self.env['product.product'].browse(
|
|
record[0]).display_name
|
|
product_name.append(complete_name)
|
|
value = {
|
|
'product_name': product_name,
|
|
'total_quantity': total_quantity
|
|
}
|
|
return value
|
|
|