Skip to content
Snippets Groups Projects

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

Closed Álvaro García requested to merge feacture/selfconsumption into dev

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 ) );

OP#190

Edited by Álvaro García

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
Please register or sign in to reply
Loading