initial commit

15 files changed, 1073 insertions, 0 deletions

diff --git a/vit_efaktur/wizard/__init__.py b/vit_efaktur/wizard/__init__.py
new file mode 100644
index 0000000..a3bac3c
--- /dev/null
+++ b/vit_efaktur/wizard/__init__.py
@@ -0,0 +1,7 @@
+from . import generate
+from . import product
+from . import partner
+from . import pk
+from . import auto
+from . import pm
+from . import assign
\ No newline at end of file
diff --git a/vit_efaktur/wizard/assign.py b/vit_efaktur/wizard/assign.py
new file mode 100644
index 0000000..1fbd802
--- /dev/null
+++ b/vit_efaktur/wizard/assign.py
@@ -0,0 +1,35 @@
+from odoo import api, fields, models, _
+import time
+from odoo.exceptions import UserError
+import logging
+_logger = logging.getLogger(__name__)
+
+class AssignConfirm(models.TransientModel):
+    _name = 'vit.assign_wizard'
+    _description = 'Assign Confirmation'
+
+
+    def _get_active_invoices(self):
+        if self._context.get('active_model') == 'account.invoice':
+            return self._context.get('active_ids', False)
+        return False
+    
+    invoice_ids = fields.Many2many(comodel_name="account.invoice", string="Invoices", required=True,
+                                 default=_get_active_invoices)
+
+    efaktur_id = fields.Many2one(comodel_name="vit.efaktur", string="Nomor E-Faktur", required=False, )
+
+    """
+    logika:
+    update invoice_ids.efaktur_id dengan yang dipilih
+    :return:
+    """
+
+    # @api.multi
+    def confirm_button(self):
+        self.ensure_one()
+
+        for inv in self.invoice_ids:
+            inv.efaktur_id = self.efaktur_id
+        
+        return {'type': 'ir.actions.act_window_close'}
diff --git a/vit_efaktur/wizard/assign.xml b/vit_efaktur/wizard/assign.xml
new file mode 100644
index 0000000..06ec473
--- /dev/null
+++ b/vit_efaktur/wizard/assign.xml
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+        
+        <record id="assign_wizard_view" model="ir.ui.view">
+            <field name="name">assign</field>
+            <field name="model">vit.assign_wizard</field>
+            <field name="arch" type="xml">
+                <form string="assign">
+                    <group>
+                        <field name="efaktur_id" domain="[('is_used','=',False)]"/>
+                        <field name="invoice_ids"/>
+                    </group>
+                    <footer>
+                        <button string="Confirm" icon="fa-check-circle" name="confirm_button" type="object" class="btn-primary"/>
+                        <button string="Cancel" icon="fa-times" class="btn-default" special="cancel" />
+                    </footer>
+                </form>
+            </field>
+        </record>
+        
+        <!-- <act_window id="assign_wizard_action"
+            name="Assign E-Faktur"
+            src_model="account.move"
+            res_model="vit.assign_wizard"
+            view_mode="form"
+            key2="client_action_multi" target="new"
+        /> -->
+    
+    </data>
+</odoo>
\ No newline at end of file
diff --git a/vit_efaktur/wizard/auto.py b/vit_efaktur/wizard/auto.py
new file mode 100644
index 0000000..7c7720b
--- /dev/null
+++ b/vit_efaktur/wizard/auto.py
@@ -0,0 +1,52 @@
+from odoo import api, fields, models, _
+from odoo.exceptions import UserError
+
+class efaktur_wizard(models.TransientModel):
+    _name = 'vit.efaktur_auto'
+    
+    start   = fields.Date("Invoice Date Start",required=True)
+    end     = fields.Date("Invoice Date End",required=True)
+    invoice_ids = fields.Many2many(comodel_name="account.move", string="Invoices", )
+
+    # @api.multi
+    def confirm_button(self):
+
+        invoice_ids = self.invoice_ids
+
+        efaktur_ids = self.env['vit.efaktur'].search([('is_used','=',False)],
+                                                     order="name asc")
+        efaktur_len = len(efaktur_ids)
+
+        i = 0
+        for inv in invoice_ids:
+            if i < efaktur_len:
+                inv.efaktur_id = efaktur_ids[i]
+            else:
+                break
+            i+=1
+
+        self.env.cr.commit()
+        raise UserError("Selesai penomoran E-Faktur %s invoices(s)!" % i)
+
+    # @api.multi
+    def find_invoices(self):
+        start = self.start
+        end = self.end
+
+        inv_obj = self.env['account.move']
+        invoices = inv_obj.search([('invoice_date','>=', start),
+                                   ('invoice_date','<=', end),
+                                   ('state','=','open'),
+                                   ('efaktur_id','=',False),
+                                   ('type','=','out_invoice')
+                                   ])
+        i = 0
+        invoice_ids = []
+        for inv in invoices:
+            invoice_ids.append((4,inv.id))
+            i+=1
+
+        self.invoice_ids=invoice_ids
+        self.env.cr.commit()
+        raise UserError("Found %s invoices(s)!" % i)
+
diff --git a/vit_efaktur/wizard/auto.xml b/vit_efaktur/wizard/auto.xml
new file mode 100644
index 0000000..6457326
--- /dev/null
+++ b/vit_efaktur/wizard/auto.xml
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+
+        <record id="act_open_vit_efaktur_auto_wizard" model="ir.actions.act_window">
+            <field name="name">Auto Number eFaktur</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">vit.efaktur_auto</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+        </record>
+
+        <record id="view_vit_efaktur_auto_form" model="ir.ui.view">
+            <field name="name">vit.efaktur_auto.form</field>
+            <field name="model">vit.efaktur_auto</field>
+            <field name="type">form</field>
+            <field name="priority" eval="8"/>
+            <field name="arch" type="xml">
+                <form string="eFaktur">
+                    <group colspan="4">
+                        <field name="start" />
+                        <field name="end" />
+                    </group>
+
+                    <notebook colspan="4">
+                        <page string="Invoices">
+                            <field name="invoice_ids"/>
+                        </page>
+                    </notebook>
+
+                    <footer>
+                        <button string="Find Invoices" name="find_invoices" type="object" class="btn-primary"/>
+                        <button string="Fill Nomor Seri Faktur Pajak" name="confirm_button" type="object" class="btn-primary"/>
+                        <button string="Cancel" class="btn-default" special="cancel" />
+                    </footer>
+
+                </form>
+            </field>
+        </record>
+
+    </data>
+</odoo>
\ No newline at end of file
diff --git a/vit_efaktur/wizard/generate.py b/vit_efaktur/wizard/generate.py
new file mode 100644
index 0000000..e152899
--- /dev/null
+++ b/vit_efaktur/wizard/generate.py
@@ -0,0 +1,28 @@
+from odoo import api, fields, models, _
+
+class efaktur_wizard(models.TransientModel):
+    _name = 'vit.generate_efaktur'
+    
+    start   = fields.Char("Start")
+    end     = fields.Char("End")
+    year     = fields.Integer("Year")
+
+    # @api.multi
+    def confirm_button(self):
+        start = self.start
+        end = self.end
+        
+        #017-17-34018714
+        a = start.split("-")
+        b = end.split("-")
+        
+        for i in range(int(a[2]), int(b[2])+1):
+            nomor = "%s-%s-%08d" % (a[0],a[1],i)
+            data = {
+                'year': self.year,
+                'name': nomor,
+            }
+            self.env['vit.efaktur'].create(data)
+        
+        return
+    
diff --git a/vit_efaktur/wizard/generate.xml b/vit_efaktur/wizard/generate.xml
new file mode 100644
index 0000000..f904208
--- /dev/null
+++ b/vit_efaktur/wizard/generate.xml
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+
+        <record id="act_open_vit_efaktur_wizard" model="ir.actions.act_window">
+            <field name="name">Generate eFaktur</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">vit.generate_efaktur</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+        </record>
+
+        <record id="view_vit_generate_efaktur_form" model="ir.ui.view">
+            <field name="name">vit.generate_efaktur.form</field>
+            <field name="model">vit.generate_efaktur</field>
+            <field name="type">form</field>
+            <field name="priority" eval="8"/>
+            <field name="arch" type="xml">
+                <form string="eFaktur">
+                    <group colspan="4">
+                        <field name="year" placeholder="xxxx"/>
+                        <field name="start" placeholder="xxx-xx-xxxxxxxx"/>
+                        <field name="end" placeholder="xxx-xx-xxxxxxxx"/>
+                    </group>
+
+                    <footer>
+                        <button string="Confirm" name="confirm_button" type="object" class="btn-primary"/>
+                        <button string="Cancel" class="btn-default" special="cancel" />
+                    </footer>
+
+                </form>
+            </field>
+        </record>
+
+    </data>
+</odoo>
\ No newline at end of file
diff --git a/vit_efaktur/wizard/partner.py b/vit_efaktur/wizard/partner.py
new file mode 100644
index 0000000..fe87361
--- /dev/null
+++ b/vit_efaktur/wizard/partner.py
@@ -0,0 +1,96 @@
+from odoo import api, fields, models, _
+import time
+import csv
+from odoo.modules import get_modules, get_module_path
+from odoo.exceptions import UserError
+import copy
+import logging
+from io import StringIO
+import base64
+
+_logger = logging.getLogger(__name__)
+
+
+class efaktur_partner_wizard(models.TransientModel):
+    _name = 'vit.efaktur_partner'
+    
+    export_file = fields.Binary(string="Export File",  )
+    export_filename = fields.Char(string="Export File",  )
+
+    # @api.multi
+    def confirm_button(self):
+        """
+        export partner yang is_efaktur_exported = False
+        update setelah export
+        :return: 
+        """
+        cr = self.env.cr
+
+        headers = [
+            'LT',
+            'NPWP',
+            'NAMA',
+            'JALAN',
+            'BLOK',
+            'NOMOR',
+            'RT',
+            'RW',
+            'KECAMATAN',
+            'KELURAHAN',
+            'KABUPATEN',
+            'PROPINSI',
+            'KODE_POS',
+            'NOMOR_TELEPON'
+        ]
+
+        mpath = get_module_path('vit_efaktur')
+        # csvfile = open(mpath + '/static/partner.csv', 'wb')
+        
+        csvfile = StringIO()
+        csvwriter = csv.writer(csvfile, delimiter=',')
+        csvwriter.writerow([h.upper() for h in headers])
+
+        partner = self.env['res.partner']
+        partners = partner.search([('is_efaktur_exported','=',False),
+                                   ('npwp','!=',False)])
+        i=0
+        for part in partners:
+            npwp = part.npwp.replace(".","").replace("-","")
+            data = {
+                'LT'        : 'LT',
+                'NPWP'      : npwp,
+                'NAMA'      : part.name,
+                'JALAN'     : part.street or '',
+                'BLOK'      : part.blok or '',
+                'NOMOR'     : part.nomor or '',
+                'RT'        : part.rt or '',
+                'RW'        : part.rw or '',
+                'KECAMATAN' : part.kecamatan_id.name or '',
+                'KELURAHAN' : part.kelurahan_id.name or '',
+                'KABUPATEN' : part.kecamatan_id.kota_id.name or '',
+                'PROPINSI'  : part.state_id.name or '',
+                'KODE_POS'  : part.zip or '',
+                'NOMOR_TELEPON': part.phone or ''
+            }
+            csvwriter.writerow([data[v] for v in headers])
+
+            part.is_efaktur_exported=True
+            part.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_partner',
+            'view_mode': 'form',
+            'res_id': self.id,
+            'views': [(False, 'form')],
+            'target': 'new',
+        }
diff --git a/vit_efaktur/wizard/partner.xml b/vit_efaktur/wizard/partner.xml
new file mode 100644
index 0000000..a39f926
--- /dev/null
+++ b/vit_efaktur/wizard/partner.xml
@@ -0,0 +1,54 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+
+        <record id="act_open_vit_efaktur_partner_wizard" model="ir.actions.act_window">
+            <field name="name">Export Lawan Transaksi</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">vit.efaktur_partner</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+        </record>
+
+        <record id="view_vit_efaktur_partner_form" model="ir.ui.view">
+            <field name="name">view_vit_efaktur_partner_form</field>
+            <field name="model">vit.efaktur_partner</field>
+            <field name="type">form</field>
+            <field name="priority" eval="8"/>
+            <field name="arch" type="xml">
+                <form string="Export Product">
+                    <p>
+                        Klik tombol Export di bawah untuk mulai export data Lawan Transaksi.
+                        Data yang diexport adalah Customer yang memiliki NPWP dan belum diexport ke E-Faktur.
+                    </p>
+
+                    <p>
+                        Setelah proses export Lawan Transaksi selesai dilakukan,
+                        download file:
+                    </p>
+                    <p>
+                        <group>
+                            <field name="export_file" readonly="1" filename="export_filename"/>
+                            <field name="export_filename" invisible="1" />
+                        </group>
+                        <!-- <a href="/vit_efaktur/static/partner.csv">
+                            <img src="/vit_efaktur/static/src/img/export.png"/>
+                            <b>partner.csv</b>
+                        </a> -->
+
+                    </p>
+                    <p>
+                        Lalu import ke program E-Faktur DJP melalui menu <b>Referensi - Lawan Transaksi - Import</b>
+                    </p>
+
+                    <footer>
+                        <button string="Export" name="confirm_button" type="object" class="btn-primary"/>
+                        <button string="Cancel" class="btn-default" special="cancel" />
+                    </footer>
+
+                </form>
+            </field>
+        </record>
+
+    </data>
+</odoo>
\ No newline at end of file
diff --git a/vit_efaktur/wizard/pk.py b/vit_efaktur/wizard/pk.py
new file mode 100644
index 0000000..3c94622
--- /dev/null
+++ b/vit_efaktur/wizard/pk.py
@@ -0,0 +1,340 @@
+from odoo import api, fields, models, _
+import time
+import csv
+from odoo.modules import get_modules, get_module_path
+from odoo.exceptions import UserError
+import copy
+import logging
+from io import StringIO
+import base64
+
+_logger = logging.getLogger(__name__)
+
+class efaktur_pk_wizard(models.TransientModel):
+    _name = 'vit.efaktur_pk'
+
+    export_file = fields.Binary(string="Export File",  )
+    export_filename = fields.Char(string="Export File",  )
+
+    # @api.multi
+    def confirm_button(self):
+        """
+        export pk yang is_efaktur_exported = False
+        update setelah export
+        :return: 
+        """
+        cr = self.env.cr
+
+        headers = [
+            'FK',
+            'KD_JENIS_TRANSAKSI',
+            'FG_PENGGANTI',
+            'NOMOR_FAKTUR',
+            'MASA_PAJAK',
+            'TAHUN_PAJAK',
+            'TANGGAL_FAKTUR',
+            'NPWP',
+            'NAMA',
+            'ALAMAT_LENGKAP',
+            'JUMLAH_DPP',
+            'JUMLAH_PPN',
+            'JUMLAH_PPNBM',
+            'ID_KETERANGAN_TAMBAHAN',
+            'FG_UANG_MUKA',
+            'UANG_MUKA_DPP',
+            'UANG_MUKA_PPN',
+            'UANG_MUKA_PPNBM',
+            'REFERENSI'
+        ]
+
+
+        mpath = get_module_path('vit_efaktur')
+
+        # csvfile = open(mpath + '/static/fpk.csv', 'wb')
+        csvfile = StringIO()
+        csvwriter = csv.writer(csvfile, delimiter=',')
+        csvwriter.writerow([h.upper() for h in headers])
+
+        inv_obj = self.env['account.move']
+        invoices = inv_obj.search([('is_efaktur_exported','=',False),
+                                   ('state','=','open'),
+                                   ('efaktur_id','!=', False),
+                                   ('move_type','=','out_invoice')])
+
+        company = self.env.user.company_id.partner_id
+
+        i=0
+        self.baris2(headers, csvwriter)
+        self.baris3(headers, csvwriter)
+
+        combined_invoices = self.gabung_by_efaktur(invoices)
+
+        for invoice in combined_invoices:
+            self.baris4(headers, csvwriter, invoice)
+            self.baris5(headers, csvwriter, company )
+
+            for line in invoice['invoice_line_ids']:
+                self.baris6(headers, csvwriter, line)
+
+            i+=1
+
+        for id in invoices.mapped('id'):
+            invoice = inv_obj.browse(id)
+            invoice.is_efaktur_exported=True
+            invoice.date_efaktur_exported=time.strftime("%Y-%m-%d %H:%M:%S")
+
+        cr.commit()
+        # csvfile.close()
+        # _logger.info(csvfile.getvalue().encode() )
+        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_pk',
+            'view_mode': 'form',
+            'res_id': self.id,
+            'views': [(False, 'form')],
+            'target': 'new',
+        }
+        # raise UserError("Export %s record(s) Done!" % i)
+
+    def gabung_by_efaktur(self, invoices):
+        old_efaktur = None
+        inv_obj = self.env['account.move']
+        i=0
+        combines=[]
+        # list of tuples of invoices to be combined by efaktur
+        # [(inv1,inv2,inv5),(inv3,inv4)]
+
+
+        final_invoices = []
+        # list of final combined invoices, totallized
+        # [inv125, inv34]
+
+        for inv in sorted(invoices, key=lambda inv: inv.efaktur_id):
+            if old_efaktur == inv.efaktur_id:
+                combines[i-1].append(inv_obj.search_read([('id','=',inv.id)])[0])
+            else:
+                combines.append([inv_obj.search_read([('id','=',inv.id)])[0]])
+                i += 1
+            old_efaktur = inv.efaktur_id
+
+        # comb = invoices per efaktur yg sama
+        for comb in combines:
+            i=0
+            for inv in comb:
+                if i == 0:
+                    i+=1
+                    continue
+
+                line_ids = inv['invoice_line_ids']
+                for id in line_ids:
+                    comb[0]['invoice_line_ids'].append(id)
+
+                comb[0]['amount_untaxed'] += inv['amount_untaxed']
+                comb[0]['amount_tax'] += inv['amount_tax']
+                comb[0]['amount_total'] += inv['amount_total']
+                comb[0]['number'] += "," + inv['number']
+                i+=1
+
+            comb[0]['invoice_line_ids'] = self.merge_lines(comb[0]['invoice_line_ids'])
+
+            final_invoices.append(comb[0])
+
+        return final_invoices
+
+    def merge_lines(self, lines):
+        old_line = None
+        final_lines = []
+
+        i=0
+        for line in self.env['account.move.line'].search_read([('id','in',lines)]):
+            if old_line and (old_line['product_id'] == line['product_id'] and old_line['price_unit'] == line['price_unit']):
+                old_line['price_unit'] += line['price_unit']
+                old_line['quantity'] += line['quantity']
+                final_lines.append(old_line)
+            else:
+                final_lines.append(line)
+
+            old_line = line
+            i+=1
+
+
+        return final_lines
+
+
+
+    def baris2(self, headers, csvwriter):
+        data = {
+            'FK': 'LT',
+            'KD_JENIS_TRANSAKSI': 'NPWP',
+            'FG_PENGGANTI': 'NAMA',
+            'NOMOR_FAKTUR': 'JALAN',
+            'MASA_PAJAK': 'BLOK',
+            'TAHUN_PAJAK': 'NOMOR',
+            'TANGGAL_FAKTUR': 'RT',
+            'NPWP': 'RW',
+            'NAMA': 'KECAMATAN',
+            'ALAMAT_LENGKAP': 'KELURAHAN',
+            'JUMLAH_DPP': 'KABUPATEN',
+            'JUMLAH_PPN': 'PROPINSI',
+            'JUMLAH_PPNBM': 'KODE_POS',
+            'ID_KETERANGAN_TAMBAHAN': 'NOMOR_TELEPON',
+            'FG_UANG_MUKA': '',
+            'UANG_MUKA_DPP': '',
+            'UANG_MUKA_PPN': '',
+            'UANG_MUKA_PPNBM': '',
+            'REFERENSI': ''
+        }
+        csvwriter.writerow([data[v] for v in headers])
+
+    def baris3(self, headers, csvwriter):
+        data = {
+            'FK': 'OF',
+            'KD_JENIS_TRANSAKSI': 'KODE_OBJEK',
+            'FG_PENGGANTI': 'NAMA',
+            'NOMOR_FAKTUR': 'HARGA_SATUAN',
+            'MASA_PAJAK': 'JUMLAH_BARANG',
+            'TAHUN_PAJAK': 'HARGA_TOTAL',
+            'TANGGAL_FAKTUR': 'DISKON',
+            'NPWP': 'DPP',
+            'NAMA': 'PPN',
+            'ALAMAT_LENGKAP': 'TARIF_PPNBM',
+            'JUMLAH_DPP': 'PPNBM',
+            'JUMLAH_PPN': '',
+            'JUMLAH_PPNBM': '',
+            'ID_KETERANGAN_TAMBAHAN': '',
+            'FG_UANG_MUKA': '',
+            'UANG_MUKA_DPP': '',
+            'UANG_MUKA_PPN': '',
+            'UANG_MUKA_PPNBM': '',
+            'REFERENSI': ''
+        }
+        csvwriter.writerow([data[v] for v in headers])
+
+
+    def baris4(self, headers, csvwriter, inv):
+        partner_id = self.env['res.partner'].browse(inv['partner_id'][0])
+        if not partner_id.npwp:
+            raise UserError("Harap masukkan NPWP Customer %s" % inv['partner_id'][1])
+
+        if not inv['efaktur_id'][0]:
+            raise UserError("Harap masukkan Nomor Seri Faktur Pajak Keluaran Invoice Nomor %s" % inv['number'])
+
+        # yyyy-mm-dd to dd/mm/yyyy
+
+        # d  = inv['invoice_date'].split("-")
+        # invoice_date = "%s/%s/%s" %(d[2],d[1],d[0])
+        invoice_date = inv['invoice_date'].strftime("%d/%m/%Y")
+        npwp = partner_id.npwp.replace(".","").replace("-","")
+        faktur = inv['efaktur_id'][1].replace(".","").replace("-","")
+
+        print ("Tax ", inv['amount_tax'])
+        print ("DPP ", inv['amount_untaxed'])
+        print ("Tax Round ", round(inv['amount_tax']))
+        print ("DPP Round ", round(inv['amount_untaxed']))
+
+        if inv['is_cancel']:
+            data = {
+                'FK': 'FK',
+                'KD_JENIS_TRANSAKSI': '01',
+                'FG_PENGGANTI': '1',
+                'NOMOR_FAKTUR': faktur,
+                'MASA_PAJAK': inv['masa_pajak'] or '',
+                'TAHUN_PAJAK': inv['tahun_pajak'] or '',
+                'TANGGAL_FAKTUR': invoice_date,
+                'NPWP': npwp,
+                'NAMA': partner_id.name.encode('utf8') or '',
+                'ALAMAT_LENGKAP': partner_id.alamat_lengkap.encode('utf8') or '',
+                'JUMLAH_DPP': round(inv['amount_untaxed']) or 0,
+                'JUMLAH_PPN': round(inv['amount_tax']) or 0,
+                'JUMLAH_PPNBM': 0,
+                'ID_KETERANGAN_TAMBAHAN': '',
+                'FG_UANG_MUKA': 0,
+                'UANG_MUKA_DPP': 0,
+                'UANG_MUKA_PPN': 0,
+                'UANG_MUKA_PPNBM': 0,
+                'REFERENSI': inv['number'] or ''
+            }
+
+        elif not inv['is_cancel']:
+            data = {
+                'FK': 'FK',
+                'KD_JENIS_TRANSAKSI': '01',
+                'FG_PENGGANTI': '0',
+                'NOMOR_FAKTUR': faktur,
+                'MASA_PAJAK': inv['masa_pajak'] or '',
+                'TAHUN_PAJAK': inv['tahun_pajak'] or '',
+                'TANGGAL_FAKTUR': invoice_date,
+                'NPWP': npwp,
+                'NAMA': partner_id.name.encode('utf8') or '',
+                'ALAMAT_LENGKAP': partner_id.alamat_lengkap.encode('utf8') or '',
+                'JUMLAH_DPP': round(inv['amount_untaxed']) or 0,
+                'JUMLAH_PPN': round(inv['amount_tax']) or 0,
+                'JUMLAH_PPNBM': 0,
+                'ID_KETERANGAN_TAMBAHAN': '',
+                'FG_UANG_MUKA': 0,
+                'UANG_MUKA_DPP': 0,
+                'UANG_MUKA_PPN': 0,
+                'UANG_MUKA_PPNBM': 0,
+                'REFERENSI': inv['number'] or ''
+            }
+
+        _logger.info(data)
+        csvwriter.writerow([data[v] for v in headers])
+
+    def baris5(self, headers, csvwriter, company):
+        data = {
+            'FK': 'FAPR',
+            'KD_JENIS_TRANSAKSI': company.name,
+            'FG_PENGGANTI': company.alamat_lengkap,
+            'NOMOR_FAKTUR': '',
+            'MASA_PAJAK': '',
+            'TAHUN_PAJAK': '',
+            'TANGGAL_FAKTUR': '',
+            'NPWP': '',
+            'NAMA': '',
+            'ALAMAT_LENGKAP': '',
+            'JUMLAH_DPP': '',
+            'JUMLAH_PPN': '',
+            'JUMLAH_PPNBM': '',
+            'ID_KETERANGAN_TAMBAHAN': '',
+            'FG_UANG_MUKA': '',
+            'UANG_MUKA_DPP': '',
+            'UANG_MUKA_PPN': '',
+            'UANG_MUKA_PPNBM': '',
+            'REFERENSI': ''
+        }
+        csvwriter.writerow([data[v] for v in headers])
+
+    def baris6(self, headers, csvwriter, line):
+        # harga_total = line['price_unit'] * line['quantity']
+        harga_total = round(line['price_subtotal'])
+        dpp = harga_total
+        ppn = round(dpp * 0.1) #TODO ambil dari Tax many2many
+        product_id = self.env['product.product'].browse(line['product_id'][0])
+
+        data = {
+            'FK': 'OF',
+            'KD_JENIS_TRANSAKSI': product_id.default_code or '',
+            'FG_PENGGANTI': product_id.name or '',
+            'NOMOR_FAKTUR': line['price_unit'],
+            'MASA_PAJAK': line['quantity'] ,
+            'TAHUN_PAJAK': harga_total,
+            'TANGGAL_FAKTUR': line['discount'] or 0,
+            'NPWP': dpp,
+            'NAMA': ppn,
+            'ALAMAT_LENGKAP': '0',
+            'JUMLAH_DPP': '0',
+            'JUMLAH_PPN': '',
+            'JUMLAH_PPNBM': '',
+            'ID_KETERANGAN_TAMBAHAN': '',
+            'FG_UANG_MUKA': '',
+            'UANG_MUKA_DPP': '',
+            'UANG_MUKA_PPN': '',
+            'UANG_MUKA_PPNBM': '',
+            'REFERENSI': ''
+        }
+        csvwriter.writerow([data[v] for v in headers])
+
diff --git a/vit_efaktur/wizard/pk.xml b/vit_efaktur/wizard/pk.xml
new file mode 100644
index 0000000..8e8e002
--- /dev/null
+++ b/vit_efaktur/wizard/pk.xml
@@ -0,0 +1,58 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+
+        <record id="act_open_vit_efaktur_pk_wizard" model="ir.actions.act_window">
+            <field name="name">Export Faktur Pajak Keluaran</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">vit.efaktur_pk</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+        </record>
+
+        <record id="view_vit_efaktur_pk_form" model="ir.ui.view">
+            <field name="name">view_vit_efaktur_pk_form</field>
+            <field name="model">vit.efaktur_pk</field>
+            <field name="type">form</field>
+            <field name="priority" eval="8"/>
+            <field name="arch" type="xml">
+                <form string="Export Pajak Keluaran">
+
+                    <p>
+                        Klik tombol Export di bawah untuk mulai export Faktur Pajak Keluaran.
+                        Data yang diexport adalah Customer Invoice yang berstatus Open dan belum diexport ke E-Faktur.
+                    </p>
+
+
+                    <p>
+                        Setelah proses export Faktur Pajak Keluaran selesai dilakukan,
+                        download file ini:
+                    </p>
+                    <p>
+                        <group>
+                            <field name="export_file" readonly="1" filename="export_filename"/>
+                            <field name="export_filename" invisible="1" />
+                        </group>
+
+                        <!--<a href="/vit_efaktur/static/fpk.csv">-->
+                            <!--<img src="/vit_efaktur/static/src/img/export.png"/>-->
+                            <!--<b>fpk.csv</b>-->
+                        <!--</a>-->
+                    </p>
+
+
+                    <p>
+                        Lalu import ke program E-Faktur DJP melalui menu <b>Referensi - Pajak Keluaran - Import</b>
+                    </p>
+
+                    <footer>
+                        <button string="Export" name="confirm_button" type="object" class="btn-primary"/>
+                        <button string="Cancel" class="btn-default" special="cancel" />
+                    </footer>
+
+                </form>
+            </field>
+        </record>
+
+    </data>
+</odoo>
\ No newline at end of file
diff --git a/vit_efaktur/wizard/pm.py b/vit_efaktur/wizard/pm.py
new file mode 100644
index 0000000..608069e
--- /dev/null
+++ b/vit_efaktur/wizard/pm.py
@@ -0,0 +1,115 @@
+from odoo import api, fields, models, _
+import time
+import csv
+from odoo.modules import get_modules, get_module_path
+from odoo.exceptions import UserError
+import copy
+import logging
+from io import StringIO
+import base64
+
+_logger = logging.getLogger(__name__)
+
+class efaktur_pm_wizard(models.TransientModel):
+    _name = 'vit.efaktur_pm'
+    
+    export_file = fields.Binary(string="Export File",  )
+    export_filename = fields.Char(string="Export File",  )
+
+    # @api.multi
+    def confirm_button(self):
+        """
+        export pm yang is_efaktur_exported = False
+        update setelah export
+        :return: 
+        """
+        cr = self.env.cr
+
+        headers = [
+            'FM',
+            'KD_JENIS_TRANSAKSI',
+            'FG_PENGGANTI',
+            'NOMOR_FAKTUR',
+            'MASA_PAJAK',
+            'TAHUN_PAJAK',
+            'TANGGAL_FAKTUR',
+            'NPWP',
+            'NAMA',
+            'ALAMAT_LENGKAP',
+            'JUMLAH_DPP',
+            'JUMLAH_PPN',
+            'JUMLAH_PPNBM',
+            'IS_CREDITABLE'
+        ]
+
+
+        mpath = get_module_path('vit_efaktur')
+
+        # csvfile = open(mpath + '/static/fpm.csv', 'wb')
+        csvfile = StringIO()
+        csvwriter = csv.writer(csvfile, delimiter=',')
+        csvwriter.writerow([h.upper() for h in headers])
+
+        onv_obj = self.env['account.move']
+        invoices = onv_obj.search([('is_efaktur_exported','=',False),
+                                   ('state','=','open'),
+                                   ('efaktur_masukan','!=', ''),
+                                   ('move_type','=','in_invoice')])
+
+
+        i=0
+        for invoice in invoices:
+            self.baris2(headers, csvwriter, invoice)
+            invoice.is_efaktur_exported=True
+            invoice.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_pm',
+            'view_mode': 'form',
+            'res_id': self.id,
+            'views': [(False, 'form')],
+            'target': 'new',
+        }
+
+    def baris2(self, headers, csvwriter, inv):
+        if not inv.partner_id.npwp:
+            raise UserError("Harap masukkan NPWP Supplier %s" % inv.partner_id.name)
+
+        if not inv.efaktur_masukan:
+            raise UserError("Harap masukkan Nomor Seri Faktur Pajak Masukan Invoice Nomor %s" % inv.number)
+
+        # yyyy-mm-dd to dd/mm/yyyy
+        # d  = inv.invoice_date.split("-")
+        # invoice_date = "%s/%s/%s" %(d[2],d[1],d[0])
+        invoice_date = inv['invoice_date'].strftime("%d/%m/%Y")
+        npwp = inv.partner_id.npwp.replace(".","").replace("-","")
+        faktur = inv.efaktur_masukan.replace(".","").replace("-","")
+
+        data = {
+            'FM':'FM',
+            'KD_JENIS_TRANSAKSI':'01',
+            'FG_PENGGANTI':'0',
+            'NOMOR_FAKTUR':faktur,
+            'MASA_PAJAK': inv.masa_pajak or '',
+            'TAHUN_PAJAK': inv.tahun_pajak or '',
+            'TANGGAL_FAKTUR': invoice_date,
+            'NPWP': npwp,
+            'NAMA': inv.partner_id.name or '',
+            'ALAMAT_LENGKAP': inv.partner_id.alamat_lengkap or '',
+            'JUMLAH_DPP': int(inv.amount_untaxed) or 0,
+            'JUMLAH_PPN': int(inv.amount_tax) or 0,
+            'JUMLAH_PPNBM': 0,
+            'IS_CREDITABLE':1
+        }
+        csvwriter.writerow([data[v] for v in headers])
+
diff --git a/vit_efaktur/wizard/pm.xml b/vit_efaktur/wizard/pm.xml
new file mode 100644
index 0000000..d4fafec
--- /dev/null
+++ b/vit_efaktur/wizard/pm.xml
@@ -0,0 +1,51 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+
+        <record id="act_open_vit_efaktur_pm_wizard" model="ir.actions.act_window">
+            <field name="name">Export Faktur Pajak Masukan</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">vit.efaktur_pm</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+        </record>
+
+        <record id="view_vit_efaktur_pm_form" model="ir.ui.view">
+            <field name="name">view_vit_efaktur_pm_form</field>
+            <field name="model">vit.efaktur_pm</field>
+            <field name="type">form</field>
+            <field name="priority" eval="8"/>
+            <field name="arch" type="xml">
+                <form string="Export Pajak Masukan">
+                    <p>
+                        Klik tombol Export di bawah untuk mulai export Faktur Pajak Masukan.
+                        Data yang diexport adalah Invoice Supplier yang berstatus Open dan belum diexport ke E-Faktur.
+                    </p>
+                    <p>
+                        Setelah proses export Faktur Pajak Masukan selesai dilakukan,
+                        download file:
+                    </p>
+                    <p>
+                        <group>
+                            <field name="export_file" readonly="1" filename="export_filename"/>
+                            <field name="export_filename" invisible="1" />
+                        </group>
+                        <!-- <a href="/vit_efaktur/static/fpm.csv">
+                            <img src="/vit_efaktur/static/src/img/export.png"/>
+                            <b>fpm.csv</b>
+                        </a> -->
+                    </p>
+                    <p>
+                        Lalu import ke program E-Faktur DJP melalui menu <b>Referensi - Pajak Masukan - Import</b>
+                    </p>
+                    <footer>
+                        <button string="Export" name="confirm_button" type="object" class="btn-primary"/>
+                        <button string="Cancel" class="btn-default" special="cancel" />
+                    </footer>
+
+                </form>
+            </field>
+        </record>
+
+    </data>
+</odoo>
\ No newline at end of file
diff --git a/vit_efaktur/wizard/product.py b/vit_efaktur/wizard/product.py
new file mode 100644
index 0000000..5f5b897
--- /dev/null
+++ b/vit_efaktur/wizard/product.py
@@ -0,0 +1,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',
+        }
\ No newline at end of file
diff --git a/vit_efaktur/wizard/product.xml b/vit_efaktur/wizard/product.xml
new file mode 100644
index 0000000..79f2751
--- /dev/null
+++ b/vit_efaktur/wizard/product.xml
@@ -0,0 +1,56 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+
+        <record id="act_open_vit_efaktur_product_wizard" model="ir.actions.act_window">
+            <field name="name">Export Product</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">vit.efaktur_product</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+        </record>
+
+        <record id="view_vit_efaktur_product_form" model="ir.ui.view">
+            <field name="name">view_vit_efaktur_product_form</field>
+            <field name="model">vit.efaktur_product</field>
+            <field name="type">form</field>
+            <field name="priority" eval="8"/>
+            <field name="arch" type="xml">
+                <form string="Export Product">
+                    <p>
+                        Klik tombol Export di bawah untuk mulai export data Barang/Jasa.
+                        Data yang diexport adalah Product yang belum diexport ke E-Faktur.
+                    </p>
+
+                    <p>
+                        Setelah proses export Barang/Jasa selesai dilakukan,
+                        download file:
+                    </p>
+                    <p>
+                        <group>
+                            <field name="export_file" readonly="1" filename="export_filename"/>
+                            <field name="export_filename" invisible="1" />
+                        </group>
+
+                        <!-- <a href="/vit_efaktur/static/product.csv">
+                            <img src="/vit_efaktur/static/src/img/export.png"/>
+                            <b>product.csv</b>
+                        </a> -->
+                    </p>
+
+
+                    <p>
+                        Lalu import ke program E-Faktur DJP melalui menu <b>Referensi - Barang/Jasa - Import</b>
+                    </p>
+
+                    <footer>
+                        <button string="Export" name="confirm_button" type="object" class="btn-primary"/>
+                        <button string="Cancel" class="btn-default" special="cancel" />
+                    </footer>
+
+                </form>
+            </field>
+        </record>
+
+    </data>
+</odoo>
\ No newline at end of file