QFQ

uzhmob push to preview

https://www.forkred.uzh.ch/preview/

---------

Notes:

Oct 28th 2020

w/ megger

adapt typo3 qfq config -> dynamic/debug/?custom

ggroup 'mob' export / import (care for typo3 role id's?) (export sql, custom, data only)

	rows with no references -> (id 103-115~~)

ggroup_member -> do full diff for null reference things

	-> help ask carsten

w/ carsten

sync scripts clean up (names etc.)

ggroup_member should not contain business logic

drop Gglue

full sync -> for typo3 FE groups

117 - states of mob project

75  - email templates

93  - dummy mob period

other ggroup_member's -> faculty groups

Current SQL list:

                        ALTER TABLE `financialrequest` ADD `adress_extra_privat_secondary` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `address_extra_privat`;

        ALTER TABLE `financialrequest` CHANGE `adress_extra_privat_secondary` `address_extra_privat_secondary` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

        ALTER TABLE `financialrequest` ADD `supervisor_promotion_secondary` VARCHAR(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `supervisor_promotion`;

        ALTER TABLE `financialrequest` ADD `institut_seminar_klinik` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `supervisor`, ADD `abteilung_lehrstuhl_arbeitsgruppe` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `institut_seminar_klinik`;

        ALTER TABLE `financialrequest` ADD `1_ginst_name` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `05_amount`, ADD `1_ginst_location` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `1_ginst_name`, ADD `1_ginst_country` INT NOT NULL AFTER `1_ginst_location`, ADD `1_ginst_duration` INT NOT NULL AFTER `1_ginst_country`, ADD `1_ginst_betr_nachname` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `1_ginst_duration`, ADD `1_ginst_betr_vorname` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `1_ginst_betr_nachname`, ADD `1_ginst_betr_isk` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `1_ginst_betr_vorname`, ADD `1_ginst_betr_lal` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `1_ginst_betr_isk`, ADD `1_ginst_betr_email` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `1_ginst_betr_lal`;

                ALTER TABLE `financialrequest` ADD `2_ginst_name` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `05_amount`, ADD `2_ginst_location` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `2_ginst_name`, ADD `2_ginst_country` INT NOT NULL AFTER `2_ginst_location`, ADD `2_ginst_duration` INT NOT NULL AFTER `2_ginst_country`, ADD `2_ginst_betr_nachname` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `2_ginst_duration`, ADD `2_ginst_betr_vorname` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `2_ginst_betr_nachname`, ADD `2_ginst_betr_isk` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `2_ginst_betr_vorname`, ADD `2_ginst_betr_lal` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `2_ginst_betr_isk`, ADD `2_ginst_betr_email` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `2_ginst_betr_lal`;

                ALTER TABLE `financialrequest` CHANGE `new_request` `new_request` ENUM('','neues Gesuch','Verlaengerungsgesuch','Wiedereinreichung') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

        ALTER TABLE `financialrequest` CHANGE `project_status_ethics` `project_status_ethics` ENUM('','Keine Bewilligung erforderlich','Antrag ist in Vorbereitung','Antrag wurde eingereicht','Antrag wurde bewilligt','Bestaetigung liegt bei') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

        ALTER TABLE `financialrequest` ADD `project_status_regulations` BOOLEAN NOT NULL DEFAULT FALSE AFTER `project_status_veterinary`;

        ALTER TABLE `financialrequest` ADD `pers_begleitung_partner` ENUM('','Ja','Nein') NOT NULL DEFAULT '' AFTER `stwf_final_comment`;

        ALTER TABLE `financialrequest` ADD `pers_begleitung_name` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `pers_begleitung_partner`, ADD `pers_children_zulagen` ENUM('0','1','2','3','4','5','6') NOT NULL DEFAULT '0' AFTER `pers_begleitung_name`;

        ALTER TABLE `financialrequest` ADD `pers_reqregist_fee` INT NOT NULL DEFAULT '0' AFTER `pers_children_zulagen`;

        ALTER TABLE `financialrequest` ADD `funding_application_elsewhere` ENUM('','Keine weiteren Mittel beantragt','Mittel bei folgenden Stellen beantragt') NOT NULL AFTER `pers_reqregist_fee`;

        ALTER TABLE `financialrequest` ADD `funding_application_ensured` ENUM('','Keine weiteren Mittel zugesichert','Weitere Mittel von folgenden Stellen zugesichert') NOT NULL AFTER `funding_application_elsewhere`, ADD `01_secondary_institution` VARCHAR(80) NOT NULL AFTER `funding_application_ensured`, ADD `02_secondary_institution` VARCHAR(80) NOT NULL AFTER `01_secondary_institution`, ADD `03_secondary_institution` VARCHAR(80) NOT NULL AFTER `02_secondary_institution`, ADD `01_secondary_amount` VARCHAR(30) NOT NULL AFTER `03_secondary_institution`, ADD `02_secondary_amount` VARCHAR(30) NOT NULL AFTER `01_secondary_amount`, ADD `03_secondary_amount` VARCHAR(30) NOT NULL AFTER `02_secondary_amount`;

        ALTER TABLE `financialrequest` CHANGE `project_status_regulations` `project_status_regulations` ENUM('','Zur Kenntnis genommen und akzeptiert') NOT NULL;

        INSERT INTO `ggroup` (`id`, `name`, `owner`, `value`, `value2`, `t1`, `typ`, `date`, `ord`, `aenderung`, `gr_id`, `x_id`, `reference`, `modified`, `created`) VALUES ('100', 'Upload Setup UZHMob', '0', '', '', '', 'Organisatoren', '', '0', CURRENT_TIMESTAMP, '', '', 'fks_upload_setup_mob', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

        UPDATE `ggroup` SET `reference` = 'fks_upload_setup_uzhmob' WHERE `ggroup`.`id` = 100;

ALTER TABLE `financialrequest` CHANGE `pers_reqregist_fee` `pers_reqregist_fee` VARCHAR(30) NOT NULL;

ALTER TABLE `financialrequest` CHANGE `pers_children_zulagen` `pers_children_zulagen` ENUM('0','1','2','3','4','5','6','') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `financialrequest` CHANGE `pers_children_zulagen` `pers_children_zulagen` ENUM('','0','1','2','3','4','5','6') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

sigh...

ALTER TABLE `financialrequest` CHANGE `1_ginst_duration` `1_ginst_duration` VARCHAR(11) NOT NULL;

ALTER TABLE `financialrequest` CHANGE `2_ginst_duration` `2_ginst_duration` VARCHAR(11) NOT NULL;

ALTER TABLE `review` ADD `umfeld_var` VARCHAR(30) NOT NULL AFTER `quality_var`;

ALTER TABLE `review` ADD `comments_2` TEXT NOT NULL AFTER `comments`, ADD `comments_3` TEXT NOT NULL AFTER `comments_2`;

ALTER TABLE `review` ADD `comments_4` TEXT NOT NULL AFTER `comments_3`;

-----------

Notes Dec 15th 2020

w/ megger

- ensure debug email is correct

- ensure sub-headings are correct

- ensure pdf and excel export works (check page uid's correct)

- URL_EXPORT irrelevant? (qfq custom config)

- NO_ENGINE_SUBSTITUTION removed (qfq database config)

- ensure routing (login/languages) works

- transfer e-mail templates via MD5 hash