sync price unit po & price purchase pricelist

4 files changed, 97 insertions, 3 deletions

diff --git a/indoteknik_custom/__manifest__.py b/indoteknik_custom/__manifest__.py
index b7aadbdf..252d92b4 100755
--- a/indoteknik_custom/__manifest__.py
+++ b/indoteknik_custom/__manifest__.py
@@ -87,6 +87,7 @@
         'views/account_move_multi_update.xml',
         'views/airway_bill.xml',
         'views/product_attribute_value.xml',
+        'views/mail_template_po.xml',
         'report/report.xml',
         'report/report_banner_banner.xml',
         'report/report_banner_banner2.xml',
diff --git a/indoteknik_custom/models/purchase_order.py b/indoteknik_custom/models/purchase_order.py
index 7091bb72..38e617e7 100755
--- a/indoteknik_custom/models/purchase_order.py
+++ b/indoteknik_custom/models/purchase_order.py
@@ -206,8 +206,17 @@ class PurchaseOrder(models.Model):
         self.date_planned = delta_time
 
         return res
+    
+    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)
+        template.send_mail(self.id, force_send=True)
 
     def po_approve(self):
+        for line in self.order_line:
+            if line.price_unit != line.price_vendor:
+                self._send_mail()
+            
         if self.env.user.is_leader or self.env.user.is_purchasing_manager:
             raise UserError("Bisa langsung Confirm")
         elif self.total_percent_margin == self.total_so_percent_margin and self.sale_order_id:
diff --git a/indoteknik_custom/models/purchase_order_line.py b/indoteknik_custom/models/purchase_order_line.py
index 1b5bba3a..450d3430 100755
--- a/indoteknik_custom/models/purchase_order_line.py
+++ b/indoteknik_custom/models/purchase_order_line.py
@@ -30,15 +30,15 @@ class PurchaseOrderLine(models.Model):
     suggest = fields.Char(string='Suggest')
     price_vendor = fields.Float(string='Price Vendor', compute='compute_price_vendor')
     
-
     def compute_price_vendor(self):
         for line in self:
             purchase_pricelist = self.env['purchase.pricelist'].search([
                 ('product_id', '=', line.product_id.id),
-                ('vendor_id', '=', line.partner_id.id)
+                ('vendor_id', '=', line.order_id.partner_id.id)
             ], limit=1)
 
-            price_vendor = purchase_pricelist.product_price
+            price_vendor = format(purchase_pricelist.product_price, ".2f")
+            price_vendor = float(price_vendor)
             line.price_vendor = price_vendor
 
     def compute_qty_stock(self):
diff --git a/indoteknik_custom/views/mail_template_po.xml b/indoteknik_custom/views/mail_template_po.xml
new file mode 100644
index 00000000..8eb72e12
--- /dev/null
+++ b/indoteknik_custom/views/mail_template_po.xml
@@ -0,0 +1,84 @@
+<?xml version="1.0" ?>
+<odoo>
+    <data noupdate="0">
+        <record id="mail_template_po_sync_price" model="mail.template">
+            <field name="name">PO: Sync Unit Price Purchase Pricelist</field>
+            <field name="model_id" ref="model_purchase_order" />
+            <field name="subject">Your PO ${object.name}</field>
+            <field name="email_from"></field>
+            <field name="email_to">azkan4elll@gmail.com</field>
+            <field name="body_html" type="html">
+                <table border="0" cellpadding="0" cellspacing="0"
+                    style="padding-top: 16px; background-color: #F1F1F1; font-family:Verdana, Arial,sans-serif; color: #454748; width: 100%; border-collapse:separate;">
+                    <tr>
+                        <td align="center">
+                            <table border="0" cellpadding="0" cellspacing="0" width="590"
+                                style="padding: 16px; background-color: white; color: #454748; border-collapse:separate;">
+                                <tbody>
+                                    <!-- HEADER -->
+                                    <tr>
+                                        <td align="center" style="min-width: 590px;">
+                                            <table border="0" cellpadding="0" cellspacing="0" width="590"
+                                                style="min-width: 590px; background-color: white; padding: 0px 8px 0px 8px; border-collapse:separate;">
+                                                <tr>
+                                                    <td valign="middle">
+                                                        <span style="font-size: 10px;">PO</span><br />
+                                                        <span style="font-size: 20px; font-weight: bold;">
+                                                            ${object.name}
+                                                        </span>
+                                                    </td>
+                                                </tr>
+                                                <tr>
+                                                    <td colspan="2" style="text-align:center;">
+                                                        <hr width="100%"
+                                                            style="background-color:rgb(204,204,204);border:medium none;clear:both;display:block;font-size:0px;min-height:1px;line-height:0; margin: 16px 0px 16px 0px;" />
+                                                    </td>
+                                                </tr>
+                                            </table>
+                                        </td>
+                                    </tr>
+                                    <!-- CONTENT -->
+                                    <tr>
+                                        <td align="center" style="min-width: 590px;">
+                                            <table border="0" cellpadding="0" cellspacing="0" width="590"
+                                                style="min-width: 590px; background-color: white; padding: 0px 8px 0px 8px; border-collapse:separate;">
+                                                <tr>
+                                                    <td valign="top" style="font-size: 13px;">
+                                                        <div>
+                                                            Dear Stefanus Darren,
+                                                            <br/><br/>
+                                                            Terdapat PO yang harga Unit Price nya tidak sama dengan yang ada di purchase pricelist nya.
+                                                            <br/><br/>
+                                                            Berikut adalah rincian PO:
+                                                            % for line in object.order_line:
+                                                                <ul>
+                                                                    <li>Nama Produk: ${line.product_id.name}</li>
+                                                                    <li>Harga Unit dalam PO: ${line.price_unit}</li>
+                                                                    <li>Harga Unit dalam Purchase Pricelist: ${line.price_vendor}</li>
+                                                                </ul>
+                                                            % endfor
+                                                            Silahkan periksa dan lakukan koreksi jika diperlukan.
+                                                            <br/><br/>
+                                                            Terima kasih.
+                                                        </div>
+                                                    </td>
+                                                </tr>
+                                                <tr>
+                                                    <td style="text-align:center;">
+                                                        <hr width="100%"
+                                                            style="background-color:rgb(204,204,204);border:medium none;clear:both;display:block;font-size:0px;min-height:1px;line-height:0; margin: 16px 0px 16px 0px;" />
+                                                    </td>
+                                                </tr>
+                                            </table>
+                                        </td>
+                                    </tr>
+                                </tbody>
+                            </table>
+                        </td>
+                    </tr>
+                </table>
+            </field>
+            <field name="auto_delete" eval="True" />
+        </record>
+    </data>
+</odoo>
\ No newline at end of file