Project

General

Profile

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