IQM: comparison fhiiqm/test/tab_info

equal deleted inserted replaced

-:d02d02efc55a
+:0a1eb975fbd9
 $copy   = $_GET["c"];
 	$inf    = $_POST["inf"];
 $ok		= $_POST["ok"];
 if (!$inf["okn"]) $ok = false;
 $duptext="";
+if (!$infid) $infid = $inf['infid'];
 //    print_r($inf); echo "<br /><br />";
 	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
-	$dbc = new dbconnection();
+	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
 if ($dup)
 {   // Info duplizieren
 $tab = "Info";
 $key = "info_ID";
 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,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["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))
 	echo "</td></tr>\n";
 }
 echo "</table>\n";
 echo "</div>\n";
 //            if (!is_null($_SESSION["recht"]) && !in_array("le", $_SESSION["recht"]))
-echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/info_flist.php?$getp\" target=\"_self\" title=\"Infoliste\">&laquo; zur Infoliste</a></p>\n";
+echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Info erfassen\">Weitere Info erfassen</a></p>\n";
 echo "</form>\n";
 echo "</div>\n";
 }
 else
 {
 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.
 // upload File
 if (is_uploaded_file($_FILES["ifile"]["tmp_name"]) && isset($_FILES["ifile"]["name"]) && $_FILES["ifile"]["name"] )
 {
 include ($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/inc/file_upload.inc.php");
 $fname  = gen_filename($inf['ifname'],"ifile",$infid);
-$retdf  = mod_file("/var/www/fhiiqm/infos",$infid,"","del");     // Loeschen alte Datei
+$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
+$retf   = upload("ifile", $fname, $infid, "/var/www/fhiiqm/infos"); // Datei prüfen und in Dokumentenverzeichnis (vollstaendiger Pfad)) verschieben
 if ($retf)
 {   // upload o.k.
 //UPDATE des Filenamens
 $sql = "UPDATE Info SET info_file = '" . $infid . "_" . $fname ."' WHERE info_ID=$infid";
 $ifile = $inf['ifname'];
 include ($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/inc/info_dat_show.inc.php");
 }
 }   // INSERT / UPDATE
 echo "</div>";
-echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/info_flist.php?$getp\" target=\"_self\" title=\"Infoliste\">Infoliste</a></p>\n";
+//        echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/info_flist.php?$getp\" target=\"_self\" title=\"Infoliste\">Infoliste</a></p>\n";
 echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Info erfassen\">Weitere Info erfassen</a></p>\n";
 }   // Form o.k. und submit
 ?>

changeset 31	0a1eb975fbd9
parent 30	d02d02efc55a