update stock vendor

2 files changed, 13 insertions, 1 deletions

diff --git a/indoteknik_api/controllers/api_v1/product.py b/indoteknik_api/controllers/api_v1/product.py
index 87747988..53ba7671 100644
--- a/indoteknik_api/controllers/api_v1/product.py
+++ b/indoteknik_api/controllers/api_v1/product.py
@@ -18,7 +18,7 @@ class Product(controller.Controller):
         id = int(kw.get('id'))
         product = request.env['product.product'].search([('id', '=', id)], limit=1)
         product_sla = request.env['product.sla'].search([('product_variant_id', '=', id)], limit=1)
-        stock_vendor = request.env['stock.vendor'].search([('product_variant_id', '=', id)], limit=1)
+        stock_vendor = self.env['stock.vendor'].get_stock_updated_last_7_days(id)
 
         qty_available = product.qty_onhand_bandengan
             
diff --git a/indoteknik_custom/models/stock_vendor.py b/indoteknik_custom/models/stock_vendor.py
index 1e5bce16..e72748c3 100755
--- a/indoteknik_custom/models/stock_vendor.py
+++ b/indoteknik_custom/models/stock_vendor.py
@@ -1,5 +1,6 @@
 from odoo import fields, models, api
 import logging
+from datetime import datetime, timedelta
 
 _logger = logging.getLogger(__name__)
 
@@ -16,6 +17,17 @@ class StockVendor(models.Model):
         ('done', 'Done')
     ], string="Cache Reset")
 
+    @api.model
+    def get_stock_updated_last_7_days(self, id):
+        date_7_days_ago = datetime.now() - timedelta(days=7)
+
+        stocks = self.search([
+            ('product_variant_id', '=', id),
+            ('write_date', '>=', date_7_days_ago.strftime("%Y-%m-%d %H:%M:%S"))
+        ], limit=1)
+
+        return stocks
+
     def cache_reset(self):
         stocks = self.env['stock.vendor'].search([
             ('cache_reset_status', '=', 'reset'),