Akce
Úkol #44348
uzavřený
Úkol #42382: Aktualizace systému OVK
Úkol #43424: Vývoj nového OVK
export z předchozích registrací
Začátek:
11.04.2024
Uzavřít do:
% Hotovo:
100%
Odhadovaná doba:
Smlouva:
Popis
Vzhledem ke zjištěné chybě při převodu databází komisařů potřebujeme ASAP tyto exporty:
- lidí, kteří byli delegováni do komise a dali souhlas s kontaktováním pro další volby
- u každého člověka údaje Jméno, Příjmení, Datum narození, E-mail, Telefon
- minimálně pro volby 2023 (prezident), 2022 (komunál a senát), 2021 (sněmovna), případně i 2020 (kraje, senát)
Exporty poté sloučit, očistit o duplicity a nahrát do TESTOVACÍ aplikace do tabulky Osoby.
Akce
#1
Aktualizováno uživatelem Andrej Ramašeuski před 22 dny(ů)
- % Hotovo změněn z 0 na 10
Struktura databazi registraci. Cim se mam ridit pri filtraci. Je tam spousta polozek navazanych na forkflow o kterem nevim nic.
Column | Type | Collation | Nullable | Default
--------------------------+--------------------------------+-----------+----------+-------------------------------------------
id | integer | | not null | nextval('registrations_id_seq'::regclass)
okrsek_id | integer | | |
confirmed_by_id | integer | | |
canceled_by_id | integer | | |
declined_by_id | integer | | |
name | character varying(255) | | not null |
surname | character varying(255) | | not null |
birth_date | date | | |
data_box | character varying(255) | | | NULL::character varying
phone | character varying(255) | | not null |
email | character varying(255) | | not null |
street | character varying(255) | | not null |
town | character varying(255) | | not null |
zip | character varying(255) | | not null |
contact_street | character varying(255) | | not null |
contact_town | character varying(255) | | not null |
contact_zip | character varying(255) | | not null |
agree_privacy | boolean | | not null |
agree_contact | boolean | | not null |
agree_newsletter | boolean | | not null |
agree_help | boolean | | not null |
ip | character varying(255) | | not null |
created_at | timestamp(0) without time zone | | not null |
confirmed_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
canceled_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
moved_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
delivered_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
declined_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
registered_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
canceled_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
confirmed_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
declined_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
moved_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
delivered_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
position | integer | | |
decline_reason | character varying(255) | | | NULL::character varying
person_id | integer | | |
repair_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
repair_code | character varying(255) | | | NULL::character varying
delegation_generated_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
obec_id | integer | | not null |
obvod_id | integer | | |
email_validated_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
phone_validated_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
email_validation_code | character varying(255) | | | NULL::character varying
validated_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
guess_person_id | integer | | |
election_id | integer | | |
internal_note | text | | |
validation_attempts | integer | | not null | 0
vals | text | | |
reminder_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
cancel_code | character varying(255) | | | NULL::character varying
cancel_attempts | integer | | not null | 0
repair_attempts | integer | | not null | 0
repaired_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
repair_vals | text | | |
repaired_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
manual_email_sent_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
unsubscribed_at | timestamp(0) without time zone | | | NULL::timestamp without time zone
cislo | integer | | |
Akce
#2
Aktualizováno uživatelem Andrej Ramašeuski před 22 dny(ů)
- Stav změněn z Nový na V řešení (diskutuje se)
Akce
#3
Aktualizováno uživatelem Andrej Ramašeuski před 22 dny(ů)
asi tak:
select distinct name,surname,birth_date,email,phone from registrations where confirmed_at is not null and canceled_at is null and declined_at is null and agree_contact order by name,surname;
Akce
#4
Aktualizováno uživatelem Martin Kučera před 22 dny(ů)
Možná spíš
select distinct name,surname,birth_date,email,phone from registrations where delegation_generated_at is not null and unsubscribed_at is null and agree_contact order by name,surname;
Akce
#5
Aktualizováno uživatelem Andrej Ramašeuski před 22 dny(ů)
stara database:
create table project_people as
select distinct name,surname,birth_date,email,phone,true as agree_contact,'neutral' as status, 'IMPORT20240411' as note
from registrations
where confirmed_at is not null
and canceled_at is null
and declined_at is null
and agree_contact
and delegation_generated_at is not null
and unsubscribed_at is null
order by name,surname;
pg_dump -a --column-inserts -t project_people DELETED_ovk | psql ovk-test
Akce
#7
Aktualizováno uživatelem Andrej Ramašeuski před 22 dny(ů)
- % Hotovo změněn z 90 na 100
- Stav změněn z V řešení (diskutuje se) na Dokončen
Akce