IQM: comparison fhiiqm/info

equal deleted inserted replaced

-:d02d02efc55a
+:0a1eb975fbd9
 /**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 02/2012
 *
-* INSERT,UPDATE Informationen Geschaeftverteilungsplan
+* INSERT(,UPDATE) Informationen Geschaeftverteilungsplan
 */
 error_reporting(E_ALL ^ E_NOTICE);
 session_start();
 echo "<div align='center'>";
 if ($infid) $text = "editieren"; else $text = "erfassen";
 if ($copy) $duptext = " (Kopie)";
 echo "<h3>Gesch&auml;ftsverteilungsplan $text$duptext<h3>";
+if ($_FILES["ifile"]["error"] == 1 || $_FILES["ifile"]["error"] == 2)
+{
+if ($_FILES["ifile"]["error"] == 2)
+echo "<p class='red'><b>Uploadfile > 10 MByte!</b></p>\n";
+$ok = 0;
+}
 echo "</div>\n";
 if (!$ok || (!$sub && !$del && !$dup))
 {
 if ($infid && (!$sub || !$del) && !isset($inf))
 { // update
 $sql = "SELECT info_ID,info_name_s,info_name_l,info_date,info_valid_from,info_valid_to,infotyp_ID,
-i.persknr,lang,info_file,info_rel_ID,info_freigabe_ID,info_sort,
+i.persknr,lang,info_file,info_rel_ID,info_freigabe_ID,info_sort,betrag,
 CONCAT(nachname,', ',vorname) AS aname
 FROM fhiiqm.Info i LEFT OUTER JOIN fhiiqm.Mitarbeiter m
 ON i.persknr=m.persknr
 WHERE info_ID = $infid";
 if ($result = $dbc -> queryObjectArray($sql))
 $inf["pers"]    = $row->persknr;
 $inf["infrel"]  = $row->info_rel_ID;
 $inf["ifname"]  = $row->info_file;
 $inf["lang"]    = $row->lang;
 $inf["fg"]      = $row->info_freigabe_ID;
 $inf["sort"]    = $row->info_sort;
+$inf["betr"]    = str_replace('.',',',$row->betrag);
 }
 }
 // Produkt
 $sql = "SELECT produkt_ID FROM Info_Produkt WHERE info_ID = $infid";
 if ($result = $dbc -> queryObjectArray($sql))
 if ($inf["cdat"] == "") $inf["cdat"] = null;
 if ($inf["vdat"] == "") $inf["vdat"] = null;
 if ($inf["bdat"] == "") $inf["bdat"] = null;
 if ($inf["fg"] == -1) $inf["fg"] = null;
+if (isset($inf['betr']) && $inf['betr']) $betrag = dbformat_wert($inf['betr']); else $betrag = null;
 if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
 $stmt = $dbc -> stmtinit();
 if (is_object($stmt))
 {
 infotyp_ID = ?,
 persknr = ?,
 lang = ?,
 info_freigabe_ID = ?,
 info_sort = ?,
-info_rel_ID = ? WHERE info_ID = $infid");
+info_rel_ID = ?,
-$stmt -> bind_param('sssssiisisi',$inf["iname"],$inf["ilong"],$inf["cdat"],$inf["vdat"],$inf["bdat"],$inf["ityp"],$inf["pers"],$inf["lang"],$inf["fg"],$inf["sort"],$inf["infrel"]);
+betrag = ? WHERE info_ID = $infid");
+$stmt -> bind_param('sssssiisisid',$inf["iname"],$inf["ilong"],$inf["cdat"],$inf["vdat"],$inf["bdat"],$inf["ityp"],$inf["pers"],$inf["lang"],$inf["fg"],$inf["sort"],$inf["infrel"],$betrag);
 $result = $stmt -> execute();
 if ($stmt->error) echo "error UPDATE Info: " . $stmt->error . "<br><br>\n";
 }
 else
 {   //INSERT
 $stmt -> prepare ("INSERT INTO Info (info_name_s,info_name_l,info_date,info_valid_from,info_valid_to,
-infotyp_ID,persknr,lang,info_freigabe_ID,info_sort,info_rel_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?)");
+infotyp_ID,persknr,lang,info_freigabe_ID,info_sort,info_rel_ID,betrag) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)");
-$stmt -> bind_param('sssssiisisi', $inf["iname"],$inf["ilong"],$inf["cdat"],$inf["vdat"],$inf["bdat"],$inf["ityp"],$inf["pers"],$inf["lang"],$inf["fg"],$inf["sort"],$inf["infrel"]);
+$stmt -> bind_param('sssssiisisid', $inf["iname"],$inf["ilong"],$inf["cdat"],$inf["vdat"],$inf["bdat"],$inf["ityp"],$inf["pers"],$inf["lang"],$inf["fg"],$inf["sort"],$inf["infrel"],$betrag);
 $result = $stmt -> execute();
 if ($stmt->error) echo "error INSERT Info: " . $stmt->error . "<br><br>\n";
 if ($result)
 { // INSERT o.k.
 include ("inc/info_tab_ins.inc.php");
 // upload File
 if (is_uploaded_file($_FILES["ifile"]["tmp_name"]) && isset($_FILES["ifile"]["name"]) && $_FILES["ifile"]["name"] )
 {
-include ("inc/file_upload.inc.php");
+include_once ("inc/file_upload.inc.php");
 $fname  = gen_filename($inf['ifname'],"ifile",$infid);
 $retdf  = mod_file("/var/www/fhiiqm/infos",$infid,"","del");     // Loeschen alte Datei
 $retf   = upload("ifile", $fname, $infid, "infos");              // Datei prüfen und in Dokumentenverzeichnis verschieben
 if ($retf)
 }
 else
 {// nur Aenderung Dateiname
 if ($inf["ifname"]) // Dateiname vergeben
 {
-include ("inc/file_upload.inc.php");
+include_once ("inc/file_upload.inc.php");
 $fname = gen_filename($inf["ifname"],$ifile_old,$infid,0);
 $len = strlen($infid)+1;
 if (substr($fname,0,$len) != "$infid" . "_") $fname = $infid . "_" . $fname;
 if ($inf["ifname"] != $ifile_old)
 {
 if (substr($fname,0,$len) == "$infid" . "_") $fname = substr($fname,$len,50);
 $retf=1; $reti=1;
 }
 }
 else // kein Dateiname angegeben
-{$retf=1; $reti=1;}
+{
+$retf=1; $reti=1;
+if ($ifile_old)
+{    // Loeschen alte Datei
+include_once ("inc/file_upload.inc.php");
+$retf  = mod_file("/var/www/fhiiqm/infos",$infid,"","del");
+if ($retf)
+{
+$sql = "UPDATE Info SET info_file = null WHERE info_ID=$infid";
+$reti=$dbc->execute($sql);
+if (!$reti)
+echo $dbc -> error . "<br>\n";
+}
+}
+}
 }
 }
 if ($result && $retf && $reti && $reta && $retp && $retv) // INSERT/UPDATE Info
 {
 //Eingabe Daten, Upload File erfolgreich

changeset 31	0a1eb975fbd9
parent 30	d02d02efc55a
child 36	4411d3239444