| changeset 41 | 9c668cd391fa |
| parent 27 | d92bbe898f32 |
| child 44 | d652bbba2d43 |
| 40:6f4b105daa24 | 41:9c668cd391fa |
|---|---|
12 */ |
12 */ |
13 |
13 |
14 include_once("/var/www/fhiiqm/inc/dbconnect.inc.php"); |
14 include_once("/var/www/fhiiqm/inc/dbconnect.inc.php"); |
15 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
15 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
16 |
16 |
17 $sql = "CALL vertrag_ablauf()"; |
17 $sql = "CALL vertrag_ablauf_mf()"; |
18 // liefert: cid, cname, vtypid, vtypk, cbegin, cend, cauto, cmon, email, cfile, bem, ckdate |
18 // liefert: cid, cname, vtypid, vtypk, cbegin, cend, cauto, cmon, email, cfile, bem, ckdate |
19 |
19 |
20 $result = $dbc -> queryObjectArray($sql); |
20 $result = $dbc -> queryObjectArray($sql); |
21 if ($result) |
21 if ($result) |
22 { |
22 { |
109 $emess .= "<p>Beste Grüße, Ihre IQM-Datenbank</p>\n</body></html>\n"; |
109 $emess .= "<p>Beste Grüße, Ihre IQM-Datenbank</p>\n</body></html>\n"; |
110 |
110 |
111 // Anhang anfügen |
111 // Anhang anfügen |
112 if ($noatt == 0) |
112 if ($noatt == 0) |
113 { |
113 { |
114 // nur 1. File |
|
115 if (strpos($row->cfile,"|")) $fname = substr($row->cfile,0,strpos($row->cfile,"|")); else $fname=$row->cfile; |
|
114 $fname = $row->cfile; |
116 $fname = $row->cfile; |
115 $ftyp = substr($fname,strrpos($fname,".")+1); |
117 $ftyp = substr($fname,strrpos($fname,".")+1); |
116 switch (strtolower($ftyp)) |
118 switch (strtolower($ftyp)) |
117 { |
119 { |
118 case "pdf": |
120 case "pdf": |