Refence Usages¶

Liste von besonderen Implementierungen:

PDF UZH CD¶

• GRC - wird dynamisch gerendert und an Mail angehaengt.

Excel¶

• IK

MultiForm¶

• ?

LDAP Search & Import User¶

• ?

FE Login: Auto update FE-Group¶

• IK, LK, GRC, LSZGS

Drag'n'Drop¶

• Report: IK - Prio Antraege, LSZGS - Lab Visit
• Form: FormEditor

Temporary Table¶

• IK: Stored Procedure, kopieren von Antraegen fuer 'Archiv'-Funktion

BEGIN

  CREATE TEMPORARY TABLE `tmp` SELECT * FROM Application WHERE 0;

  INSERT INTO `tmp` SELECT * FROM `Application` WHERE id=@srcId;

  UPDATE `tmp` SET id=0, srcId=@srcId, created=NOW(), modified=NOW();

  INSERT INTO `Application` SELECT * FROM `tmp`;

  SET @newId=LAST_INSERT_ID();

  DROP TABLE `tmp`;

  CREATE TEMPORARY TABLE `tmp` SELECT * FROM `Posting` WHERE 0;

  INSERT INTO `tmp` SELECT `po`.* FROM `Posting` AS po, `Ggroup` AS gr WHERE po.apId=@srcId AND po.grId=gr.id AND gr.reference='mi_posting_nicht_budgetierte_mittel';

  UPDATE `tmp` SET id=0, apId=@newId, created=NOW(), modified=NOW();

  INSERT INTO `Posting` SELECT * FROM `tmp`;

  DROP TABLE `tmp`;

  CREATE TEMPORARY TABLE `tmp` SELECT * FROM `Note` WHERE 0;

  INSERT INTO `tmp` SELECT `no`.* FROM `Note` AS no, `Ggroup` AS gr, Ggroup AS grFilter WHERE no.apId=@srcId AND no.grId=gr.id AND gr.grId=grFilter.id AND grFilter.reference='mi_upload';

  UPDATE `tmp` SET id=0, apId=@newId, created=NOW(), modified=NOW();

  INSERT INTO `Note` SELECT * FROM `tmp`;

  DROP TABLE `tmp`;

END