[IMP] energy_selfconsumption: importation of selfconsumption inscriptions, supply points and distribution tables by CSV

Trello Card

Changelog

• [IMP] energy_selfconsumption: Added wizard to import self-consumption inscriptions and supply points
• [IMP] energy_selfconsumption: Added wizard to import distribution tables
• [IMP] energy_selfconsumption: Added two attachments to be downloaded from the wizard as templates. The attachments are public and can be downloaded by anyone without login.
• [IMP] energy_selfconsumption: Added attachments to be downloaded from the wizard of selfconsumption import with list of all Spanish state codes.
• [IMP] energy_selfconsumption: Added field partner_id in supply points to indicate partner that has to be subscribed to the project.
• [IMP] energy_selfconsumption: SQL constraint to assure that a supply point code is unique for every company (can be same code for different companies)
• [IMP] energy_selfconsumption: updated security rules for only admins to be able to import.
• [FIX] energy_project: removed required of inscriptions to be able to remove them.
• [FIX] energy_project: inscription set on delete to cascade to remove them when deleting project.
• [FIX] energy_selfconsumption_cooperator: removed field cooperator_id and inheritance in views as this field function is implemented in the main module for the new field partner_id

energy_selfconsumption/wizards/selfconsumption_import_wizard.py

@@ -67,7 +67,7 @@ class SelfconsumptionImportWizard(models.TransientModel):
 
     def import_single_statement(self, line, project):
         partner = self.env['res.partner'].search([
-            ('vat', '=ilike', line[0])
+            '|', ('vat', '=', line[0]), ('vat', '=ilike', line[0])
         ], limit=1)
 
         if not partner:
@@ -94,7 +94,9 @@ class SelfconsumptionImportWizard(models.TransientModel):
         return True
 
     def create_supply_point(self, code, street, street2, city, state, zip, country, owner_vat):
-        owner = self.env['res.partner'].search([('vat', '=', owner_vat)])
+        owner = self.env['res.partner'].search([
+            '|', ('vat', '=', owner_vat), ('vat', '=ilike', owner_vat)
+        ], limit=1)
         if not owner:
             # TODO create new owner
             raise UserError('Owner not found VAT:{}'.format(owner_vat))