SELECT id, payload_json, is_completed, is_started FROM module_forms WHERE company_id = AND module_key = AND report_year = LIMIT 1 INSERT INTO module_forms (company_id, module_key, report_year, payload_json, is_completed, is_started) VALUES ( , , , , 0, 0 ) INSERT INTO module_forms (company_id, module_key, report_year, payload_json, is_completed, is_started, updated_by) VALUES ( , , , , , 1, NULL ) ON DUPLICATE KEY UPDATE payload_json = VALUES(payload_json), is_completed = VALUES(is_completed), is_started = VALUES(is_started), updated_by = VALUES(updated_by), updated_at = CURRENT_TIMESTAMP INSERT INTO module_forms (company_id, module_key, report_year, payload_json, is_completed, is_started, updated_by) VALUES ( , , , , , , NULL ) ON DUPLICATE KEY UPDATE payload_json = VALUES(payload_json), is_completed = VALUES(is_completed), is_started = VALUES(is_started), updated_by = VALUES(updated_by), updated_at = CURRENT_TIMESTAMP /** * Modul als geöffnet markieren (nach Jahreswechsel / erstem Aufruf). */ /** * Status-Flags setzen (z. B. rote Warnungen ohne vollständigen Save). */ SELECT is_completed, total_sale_kwh, resellers_kwh, endconsumers_kwh, grosscustomers_count, grosscustomers_total_kwh, sector_private_households_kwh, sector_agriculture_kwh, sector_industry_kwh, sector_services_kwh, sector_district_heating_kwh, sector_other_kwh, sector_fuel_kwh, sector_wkk_kwh, biogas_import_total_kwh, deviation_comment FROM gas_reports WHERE company_id = AND module_key = 'gas_sectors' AND report_year = LIMIT 1 UPDATE gas_reports SET is_completed = 1, completed_at = NOW(), status = 'submitted', updated_by = NULL WHERE id =