| author | Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> |
| Thu, 23 Aug 2012 10:17:50 +0200 | |
| changeset 29 | 72f79dab938e |
| parent 26 | 3c1e3ac7089f |
| child 31 | 0a1eb975fbd9 |
| permissions | -rw-r--r-- |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
1 |
<?php |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
2 |
|
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
3 |
/** |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
4 |
* @author Bettina Schwarzer |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
5 |
* @copyright 08/2011 |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
6 |
* |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
7 |
* INSERT Infodaten in n:m-Tabellen fuer INSERT und UPDATE Infodaten |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
8 |
*/ |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
9 |
|
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
10 |
// Produkt |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
11 |
$retp = true; |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
12 |
if (is_array($inf["prid"]) && array_sum($inf["prid"])>0) |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
13 |
{ // nur Produkte, keine Gruppen, Bereiche
|
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
14 |
|
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
15 |
// Loeschen altes Produkt, INSERT neues |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
16 |
$sql = "DELETE FROM Info_Produkt WHERE info_ID = $infid"; |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
17 |
$retpd = $dbc -> execute($sql); |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
18 |
if ($retpd) |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
19 |
{
|
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
20 |
foreach ($inf["prid"] as $pid) |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
21 |
{
|
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
22 |
//INSERT in Produkt_Vertrag |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
23 |
$sql = "INSERT INTO Info_Produkt VALUES($infid,$pid)"; |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
24 |
$retpi = $dbc -> execute($sql); |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
25 |
if (!$retpi) $retp=false; |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
26 |
} |
|
24
15f33315f045
+ Info GVP, Raum-Reinigung, Vertrag: Email vor Ende, Test Hierarchie
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
1
diff
changeset
|
27 |
if (!$retp) echo "error INSERT Info_Produkt: $dbc->error<br />\n"; |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
28 |
} |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
29 |
else |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
30 |
{
|
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
31 |
echo "error INSERT Info_Produkt: " . $dbc -> error . " <br />\n"; |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
32 |
$retp = false; |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
33 |
} |
|
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
34 |
} |
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
35 |
if ($inf['ityp'] != 7 && substr($inf['ityp'],0,1) != 8) |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
36 |
{
|
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
37 |
// Adressat |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
38 |
$reta = true; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
39 |
$sql = "DELETE FROM Info_Adressat WHERE info_ID = $infid"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
40 |
$retd = $dbc -> execute($sql); |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
41 |
if ($retd) |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
42 |
{
|
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
43 |
if (is_array($inf['adr'])) |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
44 |
{
|
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
45 |
foreach ($inf['adr'] as $adr) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
46 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
47 |
if ($adr != -1) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
48 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
49 |
$sql = "INSERT INTO Info_Adressat VALUES($infid, $adr)"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
50 |
$retai = $dbc -> execute($sql); |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
51 |
if (!$retai) $reta = false; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
52 |
} |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
53 |
} |
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
54 |
if (!$reta) echo "error INSERT Info_Adressat: $dbc->error<br />\n"; |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
55 |
} |
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
56 |
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
57 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
58 |
else |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
59 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
60 |
echo "error INSERT Info_Adressat: " . $dbc -> error . " <br />\n"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
61 |
$reta = false; |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
62 |
} |
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
63 |
// Verantwortliche + Bemerkung (ehemals Prioritaet) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
64 |
$retv = true; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
65 |
$sql = "DELETE FROM Info_Verantwortlich WHERE info_ID = $infid"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
66 |
$retv = $dbc -> execute($sql); |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
67 |
if ($retv) |
|
26
3c1e3ac7089f
+ csv-Dateien Laser, Vertrag, Raum
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
25
diff
changeset
|
68 |
{
|
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
69 |
if (!is_object($stmt)) $stmt = $dbc -> stmtinit(); |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
70 |
if (isset($inf["vpn"]) && $inf["vpn"]) |
|
26
3c1e3ac7089f
+ csv-Dateien Laser, Vertrag, Raum
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
25
diff
changeset
|
71 |
{
|
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
72 |
$parr = explode(",",$inf["vpn"]);
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
73 |
$stmt -> prepare("INSERT INTO Info_Verantwortlich (info_ID,persknr,prioritaet) VALUES(?,?,?)");
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
74 |
foreach ($parr as $pnr) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
75 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
76 |
$stmt -> bind_param('iis',$infid, $pnr, $inf["prio"][$pnr]);
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
77 |
$retvi = $stmt -> execute(); |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
78 |
if (!$retvi) $retv = false; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
79 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
80 |
if (!$retv) echo "error INSERT Info_Verantwortlich: $stmt->error<br />\n"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
81 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
82 |
elseif (is_array($inf['vpers'])) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
83 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
84 |
$stmt -> prepare("INSERT INTO Info_Verantwortlich (info_ID,persknr,prioritaet) VALUES(?,?,?)");
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
85 |
for ($k=0; $k<count($inf['vpers']); $k++) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
86 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
87 |
if ($inf['vpers'] != -1) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
88 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
89 |
$stmt -> bind_param('iis',$infid, $inf["vpers"][$k], $inf["prio"][$inf["vpers"][$k]]);
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
90 |
$retvi = $stmt -> execute(); |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
91 |
if (!$retvi) $retv = false; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
92 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
93 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
94 |
if (!$retv) echo "error INSERT Info_Verantwortlich: $stmt->error<br />\n"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
95 |
} |
|
26
3c1e3ac7089f
+ csv-Dateien Laser, Vertrag, Raum
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
25
diff
changeset
|
96 |
} |
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
97 |
else |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
98 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
99 |
echo "error INSERT Info_Verantwortlich: " . $dbc -> error . " <br />\n"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
100 |
$retv = false; |
|
24
15f33315f045
+ Info GVP, Raum-Reinigung, Vertrag: Email vor Ende, Test Hierarchie
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
1
diff
changeset
|
101 |
} |
|
15f33315f045
+ Info GVP, Raum-Reinigung, Vertrag: Email vor Ende, Test Hierarchie
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
1
diff
changeset
|
102 |
} |
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
103 |
elseif ($inf['ityp'] == 7) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
104 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
105 |
// Adressat |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
106 |
$reta = true; $retv = true; // Verantwortliche werden nicht benannt |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
107 |
$sql = "DELETE FROM Info_Funktion WHERE info_ID = $infid"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
108 |
$retd = $dbc -> execute($sql); |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
109 |
if ($retd) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
110 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
111 |
if (is_array($inf['adr'])) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
112 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
113 |
foreach ($inf['adr'] as $adr) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
114 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
115 |
if ($adr != -1) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
116 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
117 |
$sql = "INSERT INTO Info_Funktion VALUES($infid, '$adr')"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
118 |
$retai = $dbc -> execute($sql); |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
119 |
if (!$retai) $reta = false; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
120 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
121 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
122 |
if (!$reta) echo "error INSERT Info_Funktion: $dbc->error<br />\n"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
123 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
124 |
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
125 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
126 |
else |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
127 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
128 |
echo "error INSERT Info_Adressat: " . $dbc -> error . " <br />\n"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
129 |
$reta = false; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
130 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
131 |
|
|
24
15f33315f045
+ Info GVP, Raum-Reinigung, Vertrag: Email vor Ende, Test Hierarchie
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
1
diff
changeset
|
132 |
} |
|
29
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
133 |
elseif (substr($inf['ityp'],0,1) == 8) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
134 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
135 |
$reta = true; $retv = true; // keine Adressaten, Verantwortliche |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
136 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
137 |
$retl = true; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
138 |
if ($inf['ityp'] == 81 && $inf['anl'] > -1) //Anlagen |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
139 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
140 |
$retd = $dbc -> execute("DELETE FROM Info_Anlage WHERE info_ID = $infid");
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
141 |
if ($retd) |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
142 |
{
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
143 |
$retl = $dbc -> execute("INSERT INTO Info_Anlage (info_ID,al_ID) VALUES($infid," . $inf['anl'] .")" );
|
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
144 |
if (!$retl) echo "error INSERT Info_Anlage: $dbc->error<br />\n"; |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
145 |
} |
|
72f79dab938e
+ Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
26
diff
changeset
|
146 |
} |
|
1
6288d5685bff
Stand v. 31.08.2011
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
147 |
?> |