mail po & note

1 files changed, 73 insertions, 5 deletions

diff --git a/indoteknik_custom/models/purchase_order.py b/indoteknik_custom/models/purchase_order.py
index c968ed53..0020753f 100755
--- a/indoteknik_custom/models/purchase_order.py
+++ b/indoteknik_custom/models/purchase_order.py
@@ -2,7 +2,14 @@ from odoo import fields, models, api, _
 from odoo.exceptions import AccessError, UserError, ValidationError
 from datetime import datetime, timedelta
 import logging
-from pytz import timezone
+from pytz import timezone, utc
+import io
+from openpyxl import Workbook
+import base64
+try:
+    from odoo.tools.misc import xlsxwriter
+except ImportError:
+    import xlsxwriter
 
 _logger = logging.getLogger(__name__)
 
@@ -43,7 +50,7 @@ class PurchaseOrder(models.Model):
 
     def add_product_to_pricelist(self):
         for line in self.order_line:
-            current_time = fields.Datetime.now(timezone('Asia/Jakarta')).strftime('%Y-%m-%d %H:%M:%S')
+            current_time = datetime.utcnow()
 
             purchase_pricelist = self.env['purchase.pricelist'].search([
                 ('product_id', '=', line.product_id.id),
@@ -224,7 +231,8 @@ class PurchaseOrder(models.Model):
                 raise UserError("Terdapat barang yang tidak bisa diproses")
             if line.product_id:
                 self.add_product_to_pricelist()
-            if line.price_unit != line.price_vendor:
+            if line.price_unit != line.price_vendor and line.price_vendor != 0:
+                self._send_po_not_sync()
                 send_email = True
                 break 
 
@@ -244,9 +252,69 @@ class PurchaseOrder(models.Model):
 
         return res
     
+    def _send_po_not_sync(self):
+        # Mengirim data ke model Po Sync Price jika harga po dan purchase pricelist tidak singkron
+        for line in self.order_line:
+            if line.price_unit != line.price_vendor and line.price_vendor != 0:
+                self.env['po.sync.price'].create([{
+                    'order_line_id': line.id,
+                }])
+            
+            
+
     def _send_mail(self):
-        template_id = self.env.ref('indoteknik_custom.mail_template_po_sync_price').id
-        template = self.env['mail.template'].browse(template_id)
+        output = io.BytesIO()
+        workbook = xlsxwriter.Workbook(output, {'in_memory': True})
+        worksheet = workbook.add_worksheet()
+        
+        format6 = workbook.add_format({'font_size': 12, 'align': 'center', 'bg_color': '#D3D3D3', 'bold': True})
+        format1 = workbook.add_format({'font_size': 11, 'align': 'center', 'valign': 'vcenter'})
+        format2 = workbook.add_format({'font_size': 10, 'bold': True})
+        format3 = workbook.add_format({'font_size': 10, 'bold': True})
+        
+        worksheet.set_column(0, 0, 10)  
+        worksheet.set_column(1, 1, 20)  
+        worksheet.set_column(2, 2, 20)  
+        worksheet.set_column(3, 3, 20)  
+        worksheet.set_column(4, 4, 15)  
+        worksheet.set_column(5, 5, 15)  
+        
+        worksheet.write('A1', 'PO', format6)
+        worksheet.write('B1', 'SKU', format6)
+        worksheet.write('C1', 'Product', format6)
+        worksheet.write('D1', 'Brand', format6)
+        worksheet.write('E1', 'Unit Price', format6)
+        worksheet.write('F1', 'Vendor Price', format6)
+        worksheet.write('G1', 'Created On', format6)
+        
+        row_number = 1
+        po_sync = self.env['po.sync.price'].search([], order='create_date desc')
+        for po in po_sync:
+            worksheet.write(row_number, 0, po.order_line_id.order_id.name, format1)
+            worksheet.write(row_number, 1, po.order_line_id.product_id.default_code, format1)
+            worksheet.write(row_number, 2, po.order_line_id.product_id.name, format1)
+            worksheet.write(row_number, 3, po.order_line_id.product_id.x_manufacture.x_name, format1)
+            worksheet.write(row_number, 4, po.order_line_id.price_unit, format1)
+            worksheet.write(row_number, 5, po.order_line_id.price_vendor, format1)
+            worksheet.write(row_number, 6, po.create_date.replace(tzinfo=utc).astimezone(timezone('Asia/Jakarta')).strftime('%Y-%m-%d %H:%M:%S'), format1)
+            row_number += 1
+
+        workbook.close()
+        
+        output.seek(0)
+
+        template = self.env.ref('indoteknik_custom.mail_template_po_sync_price')
+        template.attachment_ids.unlink()
+        attachment_vals = {
+            'name': 'Purchase Order.xlsx',
+            'datas': base64.b64encode(output.read()),
+            'mimetype': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
+            'res_model': 'mail.template',
+            'res_id': template.id,
+        }
+        attachment_id = self.env['ir.attachment'].create(attachment_vals)
+
+        template.attachment_ids = [(4, attachment_id.id)]
         template.send_mail(self.id, force_send=True)
 
     def po_approve(self):