diff options
| author | FIN-IT_AndriFP <andrifebriyadiputra@gmail.com> | 2025-11-26 09:23:23 +0700 |
|---|---|---|
| committer | FIN-IT_AndriFP <andrifebriyadiputra@gmail.com> | 2025-11-26 09:23:23 +0700 |
| commit | 479fd12d41346f4d15f3eaff28b22b345c46f0c0 (patch) | |
| tree | 1d9253359a758cce2596a8bc50e6bf0c57774824 | |
| parent | 6613509e8a11ed0669b7a835be555a8f5c6869b1 (diff) | |
(andri) off mail_template_po
| -rwxr-xr-x | indoteknik_custom/models/purchase_order.py | 96 |
1 files changed, 48 insertions, 48 deletions
diff --git a/indoteknik_custom/models/purchase_order.py b/indoteknik_custom/models/purchase_order.py index 8a615df9..3d22b0f0 100755 --- a/indoteknik_custom/models/purchase_order.py +++ b/indoteknik_custom/models/purchase_order.py @@ -1152,7 +1152,7 @@ class PurchaseOrder(models.Model): if self.is_local_env(): _logger.warning("📪 Local environment detected — skip sending email reminders.") return - self._send_mail() + # self._send_mail() if self.revisi_po: delta_time = current_time - timedelta(days=1) @@ -1229,58 +1229,58 @@ class PurchaseOrder(models.Model): 'order_line_id': line.id, }]) - def _send_mail(self): - output = io.BytesIO() - workbook = xlsxwriter.Workbook(output, {'in_memory': True}) - worksheet = workbook.add_worksheet() + # def _send_mail(self): + # 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'}) + # 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'}) - 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.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', 'PO Price', format6) - worksheet.write('F1', 'Purchase Pricelist', format6) - worksheet.write('G1', 'Created On', format6) + # worksheet.write('A1', 'PO', format6) + # worksheet.write('B1', 'SKU', format6) + # worksheet.write('C1', 'Product', format6) + # worksheet.write('D1', 'Brand', format6) + # worksheet.write('E1', 'PO Price', format6) + # worksheet.write('F1', 'Purchase Pricelist', 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() + # 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) + # 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): greater_than_plafon, message = self._get_msg_plafon_qty() |
