[IMP] Changes of translations and user usability in the selfconsumption module

• OP#190
• OP#654
• OP#706
• OP#703
• OP#504
• OP#524
• OP#556
• OP#606
• OP#705
• OP#704
• OP#717
• OP#718
• OP#608
• OP#574

Realizar estás querys antes de hacer el -u all al cargar la nueva implementación.

ALTER TABLE energy_project_participation RENAME TO energy_selfconsumptions_participation;
ALTER TABLE energy_selfconsumption_inscription_selfconsumption RENAME COLUMN participation TO participation_id;


update energy_selfconsumption_inscription_selfconsumption set participation_real_quantity = (
    select quantity from energy_selfconsumptions_participation where id = participation_id
);

--update energy_selfconsumption_inscription_selfconsumption set state = 'inactive' where supply_point_id in (
--    select supply_point_id from energy_selfconsumption_supply_point_assignation where distribution_table_id in (
--        select id from energy_selfconsumption_distribution_table where state != 'active' and selfconsumption_project_id = energy_selfconsumption_inscription_selfconsumption.selfconsumption_project_id
--    )
--);

update energy_selfconsumption_inscription_selfconsumption set state = 'active' where supply_point_id in (
    select supply_point_id from energy_selfconsumption_supply_point_assignation where distribution_table_id in (
        select id from energy_selfconsumption_distribution_table where state = 'active' and active = true and selfconsumption_project_id = energy_selfconsumption_inscription_selfconsumption.selfconsumption_project_id
    )
);

added ToBeMerged label

requested review from @daniquilez

assigned to @alvarog

merged

mentioned in commit e796b76a

removed ToBeMerged label

mentioned in merge request !490 (merged)