QFQ

h1. Refence Usages

Liste von besonderen Implementierungen:

h1. PDF UZH CD 

* GRC - wird dynamisch gerendert und an Mail angehaengt.

h1. Excel

* IK

h1. MultiForm

* ?

h1. LDAP Search & Import User

* ? 

h1. FE Login: Auto update FE-Group

* IK, LK, GRC, LSZGS

h1. Drag'n'Drop 

* Report: IK - Prio Antraege, LSZGS - Lab Visit

* Form: FormEditor

h1. Temporary Table

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

<pre>

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