[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

@@ -104,25 +104,32 @@ class SelfconsumptionImportWizard(models.TransientModel):
                 'The supply point partner {supply_partner} and the partner {vat} in the subscription are different.').format(
                 supply_partner=supply_point.partner_id.vat, vat=partner.vat)
 
-        return False
+        if not supply_point:
+            result = self.create_supply_point(line_dict, partner)
+            if not result[0]:
+                return result
+        return True
 
-    def create_supply_point(self, code, street, street2, city, state, zip, country, owner_vat):
+    def create_supply_point(self, line_dict, partner):
         owner = self.env['res.partner'].search([
-            '|', ('vat', '=', owner_vat), ('vat', '=ilike', owner_vat)
+            '|', ('vat', '=', line_dict['owner_vat']), ('vat', '=ilike', line_dict['owner_vat'])
         ], limit=1)
-        if not owner:
-            # TODO create new owner
-            raise UserError('Owner not found VAT:{}'.format(owner_vat))
-        country = self.env['res.country'].search([('code', '=', country)])
+        country = self.env['res.country'].search([('code', '=', line_dict['country'])])
+        if not country:
+            return False, _('Country code was not found: {code}').format(line_dict['country'])
+        state = self.env['res.country.state'].search(
+                [('code', '=', line_dict['state']), ('country_id', '=', country.id)])
+        if not state:
+            return False, _('State code was not found: {code}').format(line_dict['state'])
+
         return self.env['energy_selfconsumption.supply_point'].create({
-            'code': code,
-            'name': code,
-            'street': street,
-            'street2': street2,
-            'city': city,
-            'state_id': self.env['res.country.state'].search(
-                [('code', '=', state), ('country_id', '=', country.id)]).id,
-            'zip': zip,
+            'code': line_dict['code'],
+            'name': line_dict['code'],
+            'street': line_dict['street'],
+            'street2': line_dict['street2'],
+            'city': line_dict['city'],
+            'zip': line_dict['postal_code'],
+            'state_id': state.id,
             'country_id': country.id,
             'owner_id': owner.id,
             'partner_id': partner.id