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