1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
from odoo import api, fields, models, _
import time
import csv
from odoo.modules import get_module_path
from odoo.exceptions import UserError
import copy
import logging
from io import StringIO
import base64
class efaktur_product_wizard(models.TransientModel):
_name = 'vit.efaktur_product'
export_file = fields.Binary(string="Export File", )
export_filename = fields.Char(string="Export File", )
# @api.multi
def confirm_button(self):
"""
export product yang is_efaktur_exported = False
update setelah export
:return:
"""
cr = self.env.cr
headers = [
'OB',
'KODE_OBJEK',
'NAMA',
'HARGA_SATUAN'
]
mpath = get_module_path('vit_efaktur')
# csvfile = open(mpath + '/static/product.csv', 'wb')
csvfile = StringIO()
csvwriter = csv.writer(csvfile, delimiter=',')
csvwriter.writerow([h.upper() for h in headers])
product = self.env['product.template']
products = product.search([('is_efaktur_exported','=',False)])
i=0
for prod in products:
data = {
'OB' : 'OB',
'KODE_OBJEK': prod.default_code or '',
'NAMA' : prod.name,
'HARGA_SATUAN':prod.list_price
}
csvwriter.writerow([data[v] for v in headers])
prod.is_efaktur_exported=True
prod.date_efaktur_exported=time.strftime("%Y-%m-%d %H:%M:%S")
i+=1
cr.commit()
# csvfile.close()
# raise UserError("Export %s record(s) Done!" % i)
self.export_file = base64.b64encode(csvfile.getvalue().encode())
self.export_filename = 'Export-%s.csv' % time.strftime("%Y%m%d_%H%M%S")
return {
'name': "Export E-Faktur Complete, total %s records" % i,
'type': 'ir.actions.act_window',
'res_model': 'vit.efaktur_product',
'view_mode': 'form',
'res_id': self.id,
'views': [(False, 'form')],
'target': 'new',
}
|
