144 } |
151 } |
145 else |
152 else |
146 { |
153 { |
147 // Daten speichern |
154 // Daten speichern |
148 echo "<div align='center'>\n"; |
155 echo "<div align='center'>\n"; |
149 // alte Bezeichnung Protokoll holen |
|
150 $sql = "SELECT pruef_file |
|
151 FROM fhiiqm.A_Pruefung |
|
152 WHERE alp_ID = $alpid"; |
|
153 if ($result = $dbc -> queryObjectArray($sql)) |
|
154 foreach ($result as $row) $al["pfname_old"] = $row->pruef_file; |
|
155 |
156 |
156 if ($alpid) |
157 if ($alpid) |
157 { |
158 { |
158 //update |
159 //update |
|
160 // alte Bezeichnung Protokoll holen |
|
161 $sql = "SELECT pruef_file |
|
162 FROM fhiiqm.A_Pruefung |
|
163 WHERE alp_ID = $alpid"; |
|
164 $al["pfname_old"] = $dbc -> querySingleItem($sql); |
159 // upload File |
165 // upload File |
160 if (is_uploaded_file($_FILES["pfile"]["tmp_name"]) && isset($_FILES["pfile"]["name"]) && $_FILES["pfile"]["name"] ) |
166 if (is_uploaded_file($_FILES["pfile"]["tmp_name"]) && isset($_FILES["pfile"]["name"]) && $_FILES["pfile"]["name"] ) |
161 { |
167 { |
162 include ("inc/file_upload.inc.php"); |
168 include ("inc/file_upload.inc.php"); |
163 if ($al['pfname']<"!") $al['pfname']="al_pruefung"; |
169 if ($al['pfname']<"!") $al['pfname']="al_pruefung"; |
178 $fname = gen_filename($al["pfname"],$al["pfname_old"],$alpid,0); |
184 $fname = gen_filename($al["pfname"],$al["pfname_old"],$alpid,0); |
179 $len = strlen($alpid)+1; |
185 $len = strlen($alpid)+1; |
180 if (substr($fname,0,$len) != "$alpid" . "_") $fname = $alpid . "_" . $fname; |
186 if (substr($fname,0,$len) != "$alpid" . "_") $fname = $alpid . "_" . $fname; |
181 if ($al["pfname"] != $al["pfname_old"]) |
187 if ($al["pfname"] != $al["pfname_old"]) |
182 { |
188 { |
183 $retf = mod_file("/var/www/fhiiqm/alprot",$alpid,$fname,"upd"); // Umbenennen alte Datei |
189 if ($al["pfname"]>"!") |
184 if ($retf) |
|
185 { |
190 { |
186 $sql = "UPDATE A_Pruefung SET pruef_file = '" . $fname . "' WHERE alp_ID=$alpid"; |
191 $retf = mod_file("/var/www/fhiiqm/alprot",$alpid,$fname,"upd"); // Umbenennen alte Datei |
187 $retp=$dbc->execute($sql); |
192 if ($retf) |
188 if (!$retp) |
193 { |
189 echo $dbc -> error . "<br>\n"; |
194 $sql = "UPDATE A_Pruefung SET pruef_file = '" . $fname . "' WHERE alp_ID=$alpid"; |
190 if (substr($fname,0,$len) == "$alpid" . "_") $fname = substr($fname,$len,50); |
195 $retp=$dbc->execute($sql); |
|
196 if (!$retp) |
|
197 echo $dbc -> error . "<br>\n"; |
|
198 if (substr($fname,0,$len) == "$alpid" . "_") $fname = substr($fname,$len,50); |
|
199 } |
|
200 } |
|
201 else |
|
202 { |
|
203 $retf=1; $retp=1; |
|
204 if ($al["pfname_old"]) |
|
205 { // Loeschen alte Datei |
|
206 $retf = mod_file("/var/www/fhiiqm/alprot",$alpid,"","del"); |
|
207 if ($retf) |
|
208 { |
|
209 $sql = "UPDATE A_Pruefung SET pruef_file = null WHERE alp_ID=$alpid"; |
|
210 $retp=$dbc->execute($sql); |
|
211 if (!$retp) |
|
212 echo $dbc -> error . "<br>\n"; |
|
213 } |
|
214 } |
|
215 |
191 } |
216 } |
192 |
217 |
193 } |
218 } |
194 else |
219 else |
195 { |
220 { |