fhiiqm/info_ed3.php
changeset 26 3c1e3ac7089f
child 28 8d8bce56918f
equal deleted inserted replaced
25:482252ff12fd 26:3c1e3ac7089f
       
     1 <?php
       
     2 
       
     3 /**
       
     4  * @author Bettina Schwarzer, Fritz-Haber-Institut
       
     5  * @copyright 02/2012
       
     6  *
       
     7  * INSERT,UPDATE Informationen Geschaeftverteilungsplan   
       
     8  */
       
     9 
       
    10     error_reporting(E_ALL ^ E_NOTICE);
       
    11     
       
    12     session_start();
       
    13     if (! isset($_SESSION["userid"]))
       
    14     { 
       
    15         include_once ("inc/func_lib.inc.php");	
       
    16         login($_SERVER["PHP_SELF"]);
       
    17         exit;
       
    18     }
       
    19     
       
    20     if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("ir",$_SESSION["recht"]) && !in_array("ie",$_SESSION["recht"])))
       
    21     {
       
    22         header("Location: start.php");
       
    23         exit;
       
    24     }    
       
    25 
       
    26     $ityp   = $_GET["t"];
       
    27     
       
    28     $infid  = $_GET["i"];
       
    29     $del    = $_POST["del"];
       
    30     $sub    = $_POST["eintragen"];
       
    31     $dup    = $_POST["dup"];
       
    32     if (!$dup) $dup = $_GET["d"];
       
    33     $copy   = $_GET["c"];
       
    34 	$inf    = $_POST["inf"];
       
    35     $ok		= $_POST["ok"];
       
    36     if (!$inf["okn"]) $ok = false;
       
    37     $duptext="";
       
    38     
       
    39 //    print_r($inf); echo "<br /><br />";
       
    40 
       
    41 	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
       
    42     include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
       
    43 	$dbc = new dbconnection();
       
    44     
       
    45     if ($dup)
       
    46     {   // Info duplizieren
       
    47         $tab = "Info";
       
    48         $key = "info_ID";
       
    49         $val =  $infid;
       
    50 //        $ret=1;
       
    51         $ret = duplicate_record ($tab, $key, $val);
       
    52         if ($ret)
       
    53         { 
       
    54             $infid_new=$ret;
       
    55             // Infofilename loeschen
       
    56             $sql = "UPDATE fhiiqm.Info SET info_file = NULL WHERE info_ID = $infid_new";
       
    57             $retf = $dbc -> execute($sql);
       
    58             if ($dbc->error) echo "<p  class='red'>error loeschen Info-File: " . $dbc->error . "</p>";
       
    59             
       
    60             // duplizieren Produkte
       
    61             $sql = "INSERT INTO Info_Produkt SELECT $infid_new,produkt_ID FROM Info_Produkt WHERE info_ID = $infid";
       
    62             $retp = $dbc -> execute($sql);
       
    63             if ($dbc->error) echo "<p  class='red'>error copy Info_Produkt: " . $dbc->error . "</p>";
       
    64             
       
    65             // duplizieren Adressat
       
    66             $sql = "INSERT INTO Info_Adressat SELECT $infid_new,info_adr_ID FROM Info_Adressat WHERE info_ID = $infid";
       
    67             $reta = $dbc -> execute($sql);
       
    68             if ($dbc->error) echo "<p  class='red'>error copy Info_Adressat: " . $dbc->error . "</p>";
       
    69             
       
    70             // duplizieren Verantwortliche
       
    71             $sql = "INSERT INTO Info_Verantwortlich SELECT $infid_new,persknr,prioritaet FROM Info_Verantwortlich WHERE info_ID = $infid";
       
    72             $retv = $dbc -> execute($sql);
       
    73             if ($dbc->error) echo "<p  class='red'>error copy Info_Verantwortlich: " . $dbc->error . "</p>";
       
    74             
       
    75             if ($ret && $retf && $retp && $reta && $retv)
       
    76             {
       
    77                 $addr = $_SERVER["PHP_SELF"] . "?i=$infid_new&c=1";
       
    78                 header("Location: $addr");
       
    79                 exit;
       
    80             }
       
    81             else $duptext = " - Fehler beim Duplizieren von ". $inf["iname"];    
       
    82         }
       
    83         else $duptext = " - Fehler beim Duplizieren von ". $inf["iname"];    
       
    84     }
       
    85     
       
    86 ?>
       
    87 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
       
    88 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
       
    89 
       
    90 <head>
       
    91 	<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
       
    92    	<link href="css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/> 
       
    93    	<link href="css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/> 
       
    94     <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness/jquery-ui-1.8.16.custom.css" rel="Stylesheet" />	
       
    95     <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.6.2.min.js"></script>
       
    96     <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.16.custom.min.js"></script>
       
    97 
       
    98 	<title>Edit Informationen</title>
       
    99 </head>
       
   100 
       
   101 <body>
       
   102 
       
   103     <script>
       
   104         function split( val ) {
       
   105         	return val.split( /;\s*/ );
       
   106         }
       
   107         function extractLast( term ) {
       
   108         	return split( term ).pop();
       
   109         }
       
   110 //        $(document).ready(function() {
       
   111         $(function() {
       
   112         $("#titel").focus();
       
   113         $("#persknr").autocomplete({
       
   114                 source: "/fhiiqm/inc/ma_list_ac.inc.php",
       
   115     			minLength: 2,
       
   116                 select: function(event,ui){$("#pid").val(ui.item.id);}
       
   117     		});
       
   118         $("#vpers")
       
   119                 .bind( "keydown", function( event ) {
       
   120 				if ( event.keyCode === $.ui.keyCode.TAB &&
       
   121 						$( this ).data( "autocomplete" ).menu.active ) {
       
   122 					event.preventDefault();
       
   123 //                    alert ("bind: "+event.keyCode);
       
   124 				    }
       
   125                 })
       
   126                 .autocomplete({
       
   127 //              source: "/fhiiqm/inc/ma_list_ac.inc.php",
       
   128 //              minLength: 2,
       
   129 //              select: function(event,ui){$("#pid").val(ui.item.id);}
       
   130 				source: function( request, response ) {
       
   131 					$.getJSON( "/fhiiqm/inc/ma_list_ac.inc.php", {
       
   132 						term: extractLast( request.term )
       
   133 					}, response );
       
   134 				},				
       
   135                 focus: function() {
       
   136 					// prevent value inserted on focus
       
   137 					return false;
       
   138 				},
       
   139 				select: function( event, ui ) {
       
   140 					var terms = split( this.value );
       
   141 //                    alert ("eingabe: "+terms+ ", ids="+idstr.valueOf());
       
   142 					// remove the current input
       
   143 					terms.pop();
       
   144 					// add the selected item
       
   145 					terms.push( ui.item.value );
       
   146 					// add placeholder to get the comma-and-space at the end
       
   147 					terms.push( "" );
       
   148 //                    alert ("select: "+terms+ "ids = "+$("#vpid").val());
       
   149 					this.value = terms.join( "; " );
       
   150                     
       
   151                     var ids = $("#vpid").val().split(",");
       
   152                     ids.push(ui.item.id);
       
   153                     ids.join(",");
       
   154 //                    alert (ids);
       
   155                     $("#vpid").val(ids);
       
   156 					return false;
       
   157 				},
       
   158                 change: function(event, ui){
       
   159 //                    alert ("change: "+ui.item.value+","+ ui.item.id);
       
   160                 },
       
   161 				search: function() {
       
   162 					// custom minLength
       
   163 					var term = extractLast( this.value );
       
   164 					if ( term.length < 2 ) {
       
   165 						return false;
       
   166 					}
       
   167                 }    		
       
   168                 });
       
   169         $("#cdat").datepicker({
       
   170             dateFormat: 'yy-mm-dd', //nur Datum
       
   171             yearRange: '2000:2025',
       
   172             changeMonth: true,
       
   173 			changeYear: true,
       
   174             firstDay: 1,
       
   175             dayNamesMin: ['So','Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa' ],
       
   176             monthNamesShort: ['Jan','Feb','Mar','Apr','Mai','Jun','Jul','Aug','Sep','Okt','Nov','Dez'] 
       
   177         });
       
   178         $("#vdat").datepicker({
       
   179             dateFormat: 'yy-mm-dd', //nur Datum
       
   180             yearRange: '2000:2025',
       
   181             changeMonth: true,
       
   182 			changeYear: true,
       
   183             firstDay: 1,
       
   184             dayNamesMin: ['So','Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa' ],
       
   185             monthNamesShort: ['Jan','Feb','Mar','Apr','Mai','Jun','Jul','Aug','Sep','Okt','Nov','Dez'] 
       
   186         });
       
   187         $("#bdat").datepicker({
       
   188             dateFormat: 'yy-mm-dd', //nur Datum
       
   189             yearRange: '2000:2025',
       
   190             changeMonth: true,
       
   191 			changeYear: true,
       
   192             firstDay: 1,
       
   193             dayNamesMin: ['So','Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa' ],
       
   194             monthNamesShort: ['Jan','Feb','Mar','Apr','Mai','Jun','Jul','Aug','Sep','Okt','Nov','Dez'] 
       
   195         });
       
   196         $("input[id='persknr']").addClass("long20");
       
   197         $("input[id='cdat']").addClass("long10");
       
   198         $("input[id='vdat']").addClass("long10");
       
   199         $("input[id='bdat']").addClass("long10");
       
   200         });
       
   201     </script>
       
   202 
       
   203 <?php
       
   204     echo "&nbsp;";  
       
   205     echo "<div class=\"float-br smaller\" valign='top'>";
       
   206     echo "&nbsp;&nbsp;&nbsp;user: " . $_SESSION["userid"];
       
   207     echo "&nbsp;&nbsp;&nbsp;<a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
       
   208     echo "<div class=\"float-r\"><img src=\"img/document_image_ver.png\" border=\"0\" alt=\"Infodaten &auml;ndern\" title=\"Infodaten &auml;ndern\"/></div>\n";
       
   209 
       
   210 
       
   211     echo "<div align='center'>";
       
   212     if ($infid) $text = "editieren"; else $text = "erfassen";
       
   213     if ($copy) $duptext = " (Kopie)";
       
   214     echo "<h3>Information $text$duptext<h3>";
       
   215     
       
   216     echo "</div>\n";
       
   217     
       
   218     if (!$ok || (!$sub && !$del && !$dup))
       
   219     {
       
   220         if ($infid && (!$sub || !$del) && !isset($inf))
       
   221         { // update
       
   222             $sql = "SELECT info_ID,info_name_s,info_name_l,info_date,info_valid_from,info_valid_to,infotyp_ID,
       
   223                                 i.persknr,lang,info_file,info_rel_ID,info_freigabe,info_sort, 
       
   224                                 CONCAT(nachname,', ',vorname) AS aname 
       
   225                                 FROM fhiiqm.Info i LEFT OUTER JOIN fhiiqm.Mitarbeiter m 
       
   226                                 ON i.persknr=m.persknr 
       
   227                                 WHERE info_ID = $infid";
       
   228             if ($result = $dbc -> queryObjectArray($sql))
       
   229             {
       
   230                 foreach ($result as $row)
       
   231                 {
       
   232                     $inf["infid"]   = $infid;
       
   233                     $inf["iname"]   = $row->info_name_s;
       
   234                     $inf["ilong"]   = $row->info_name_l;
       
   235                     $inf["cdat"]    = $row->info_date;
       
   236                     $inf["vdat"]    = $row->info_valid_from;
       
   237                     $inf["bdat"]    = $row->info_valid_to;
       
   238                     $inf["ityp"]    = $row->infotyp_ID;
       
   239                     $inf["persknr"] = $row->aname;
       
   240                     $inf["pers"]    = $row->persknr;
       
   241                     $inf["infrel"]  = $row->info_rel_ID;
       
   242                     $inf["ifname"]  = $row->info_file;
       
   243                     $inf["lang"]    = $row->lang;     
       
   244                     $inf["sort"]    = $row->info_sort;     
       
   245                 }            
       
   246             }
       
   247             // Produkt
       
   248             $sql = "SELECT produkt_ID FROM Info_Produkt WHERE info_ID = $infid";
       
   249             if ($result = $dbc -> queryObjectArray($sql))
       
   250             {
       
   251                 foreach ($result as $row)
       
   252                 {
       
   253                     $inf['prid'][] = $row->produkt_ID;
       
   254                 }
       
   255             }
       
   256             // Adressat
       
   257             $sql = "SELECT info_adr_ID FROM Info_Adressat WHERE info_id = $infid";
       
   258             if ($result = $dbc->queryObjectArray($sql))
       
   259             {
       
   260                 foreach ($result as $row)
       
   261                 $inf["adr"][] = $row->info_adr_ID;
       
   262             }
       
   263             // Verantwortlicher
       
   264             $sql = "SELECT iv.persknr,prioritaet, CONCAT (nachname, ', ',vorname) as ma 
       
   265                     FROM Info_Verantwortlich iv INNER JOIN Mitarbeiter m ON iv.persknr=m.persknr
       
   266                     WHERE info_id = $infid
       
   267                     ORDER BY 3";
       
   268             if ($result = $dbc->queryObjectArray($sql))
       
   269             {
       
   270                 foreach ($result as $row)
       
   271                 {
       
   272                     $inf["vpers"] .= $row->ma . "; ";
       
   273                     $inf["vpn"]  .= $row->persknr .",";   
       
   274 //                    $inf["prio"][]  = $row->prioritaet;
       
   275                     $inf["prio"][$row->persknr]  = $row->prioritaet;
       
   276                 }
       
   277                 $inf["vpn"] = substr($inf["vpn"],0,strlen($inf["vpn"])-1);
       
   278             }
       
   279 //    print_r($inf); echo "<br /><br />";
       
   280             
       
   281         }
       
   282         include($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/form/info_form3.inc.php");     
       
   283         if ($sub)
       
   284 		{
       
   285             echo            
       
   286             "<tr>
       
   287         		<td>Upload Infodokument </td>
       
   288         		<td><input type=\"file\" name=\"ifile\" size=\"50\" maxlength=\"50\" value=\"" .
       
   289             $_FILES["ifile"]["name"] . "\"/></td>
       
   290             </tr>";
       
   291     
       
   292 		}
       
   293         if ($sub || $del)
       
   294 		{
       
   295 		  	if ($sub)
       
   296                 $frage = "Alle Angaben ok?";
       
   297             elseif ($del)
       
   298                 $frage = "Information wirklich l&ouml;schen?";
       
   299 			echo "<tr>
       
   300 			  <td class=\"red\" valign=\"top\" align=\"left\">$frage</td>
       
   301 			        <td><input type=\"checkbox\" name=\"ok\" value=\"1\"";
       
   302 			        if ($ok)  echo "checked=\"checked\""; 
       
   303 			echo " /></td>\n</tr>\n"; 
       
   304 		}
       
   305         if (!is_null($_SESSION["recht"]) && in_array("ie",$_SESSION["recht"]))
       
   306         {
       
   307             echo "
       
   308            	<tr><td>&nbsp;</td>\n
       
   309             	<td><input  class=\"button\" type=\"submit\" name=\"eintragen\" value=\"  eintragen  \" />";
       
   310             if ($infid)
       
   311             {
       
   312                 echo "&nbsp;&nbsp;&nbsp;<input class=\"buttonr\" type=\"submit\" value=\"l&ouml;schen\" name=\"del\" title=\"delete\" />";
       
   313                 echo "&nbsp;&nbsp;&nbsp;<input class=\"button\" type=\"submit\" value=\"duplizieren\" name=\"dup\" title=\"delete\" />";
       
   314             }    
       
   315            	echo "</td></tr>\n";
       
   316         }
       
   317         echo "</table>\n";
       
   318         echo "</div>\n";
       
   319 //            if (!is_null($_SESSION["recht"]) && !in_array("le", $_SESSION["recht"]))
       
   320             echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"info_flist.php\" target=\"_self\" title=\"Infoliste\">&laquo; zur Infoliste</a></p>\n"; 
       
   321         echo "</form>\n";   
       
   322     }
       
   323     else
       
   324     {
       
   325         echo "<div align='center'>\n";
       
   326         
       
   327         if ($del)
       
   328         {   // loescht auch m:n - Tabellen wegen Loeschweitergabe
       
   329             $sql = "DELETE FROM Info WHERE info_ID = '$infid'";
       
   330             $retdi = $dbc -> execute($sql);
       
   331             if ($retdi)
       
   332             {
       
   333                 include ("inc/file_upload.inc.php");
       
   334                 $retdf  = mod_file("/var/www/fhiiqm/infos",$infid,"","del");  // Loeschen Dokument
       
   335                 if ($retdf) echo "<p class='green'><b>Infodokument zu ID '$infid' wurde gel&ouml;scht.</b></p>\n";
       
   336                 echo "<p class='green'><b>Infodaten zu ID '$infid' wurden gel&ouml;scht.</b></p>\n";
       
   337                 echo "<br /><br />\n";
       
   338     
       
   339                 // Anzeigen geloeschter Infodaten
       
   340                 if ($fname)
       
   341                     $ifile = $infid . "_" . $fname;
       
   342                 else
       
   343                     $ifile = $inf['ifname'];
       
   344                 echo "<p class='green'><b>DELETE: Daten  zu '".$inf["iname"]."' wurden erfolgreich gel&ouml;scht.</b></p>\n";
       
   345                 include ("inc/info_dat_show.inc.php");
       
   346             }                
       
   347             else
       
   348             {
       
   349                 echo "<p class='red'><b>DELETE: Daten  zu '".$inf["iname"]."' konnten nicht gel&ouml;scht werden!</b></p>\n";
       
   350                 echo "sql = $sql<br />";
       
   351                 echo "error DELETE: " . $dbc->error . "<br />";
       
   352             }
       
   353         }
       
   354         else //INSERT oder UPDATE
       
   355         {
       
   356             //daten speichern
       
   357             $inf["iname"] = substr($inf["iname"],0,300);
       
   358             $inf["ilong"] = substr($inf["ilong"],0,8000);
       
   359             $inf["sort"] = substr($inf["sort"],0,10);   // 28.03.2012 5 -> 10 Zeichen
       
   360             if ($inf["ityp"] == -1) $inf["ityp"] = null;
       
   361             
       
   362             if ($inf["persknr"] < "!") $inf["pers"] = null;
       
   363             if ($inf["infrel"] == -1) $inf["infrel"] = null;
       
   364             if ($inf["lang"] == -1) $inf["lang"] = null;
       
   365             if ($inf["ifname"] < "!") $inf["ifname"] = null;
       
   366             
       
   367             if ($inf["cdat"] == "") $inf["cdat"] = null; 
       
   368             if ($inf["vdat"] == "") $inf["vdat"] = null; 
       
   369             if ($inf["bdat"] == "") $inf["bdat"] = null; 
       
   370     
       
   371             if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
       
   372             
       
   373             $stmt = $dbc -> stmtinit();
       
   374             if (is_object($stmt))
       
   375             {
       
   376                 if ($infid)
       
   377                 {   //UPDATE
       
   378                     // alter Name Infofile
       
   379                     $sql = "SELECT info_file FROM Info WHERE info_ID = $infid";
       
   380                     $ifile_old = $dbc -> querySingleItem($sql);
       
   381                     
       
   382                     $stmt -> prepare("UPDATE fhiiqm.Info SET
       
   383                                 info_name_s = ?, 
       
   384                                 info_name_l = ?, 
       
   385                                 info_date = ?, 
       
   386                                 info_valid_from = ?, 
       
   387                                 info_valid_to = ?, 
       
   388                                 infotyp_ID = ?, 
       
   389                                 persknr = ?, 
       
   390                                 lang = ?,
       
   391                                 info_sort = ?, 
       
   392                                 info_rel_ID = ? WHERE info_ID = $infid");
       
   393                     $stmt -> bind_param('sssssiissi',$inf["iname"],$inf["ilong"],$inf["cdat"],$inf["vdat"],$inf["bdat"],$inf["ityp"],$inf["pers"],$inf["lang"],$inf["sort"],$inf["infrel"]);
       
   394                     $result = $stmt -> execute();
       
   395                     if ($stmt->error) echo "error UPDATE Info: " . $stmt->error . "<br><br>\n";
       
   396                 }
       
   397                 else
       
   398                 {   //INSERT
       
   399                     $stmt -> prepare ("INSERT INTO Info (info_name_s,info_name_l,info_date,info_valid_from,info_valid_to,
       
   400                                 infotyp_ID,persknr,lang,info_sort,info_rel_ID) VALUES (?,?,?,?,?,?,?,?,?,?)");
       
   401                     $stmt -> bind_param('sssssiissi', $inf["iname"],$inf["ilong"],$inf["cdat"],$inf["vdat"],$inf["bdat"],$inf["ityp"],$inf["pers"],$inf["lang"],$inf["sort"],$inf["infrel"]);
       
   402                     $result = $stmt -> execute();      
       
   403                 
       
   404                     if ($stmt->error) echo "error INSERT Info: " . $stmt->error . "<br><br>\n";
       
   405                     if ($result)
       
   406                     { // INSERT o.k.
       
   407                       // info_ID ermitteln
       
   408                         $infid = $dbc -> insertId();
       
   409                     }    
       
   410                 } 
       
   411             }   // stmt-Objekt
       
   412             if ($result)
       
   413             {
       
   414                  // n:m Tabellen INSERT
       
   415                 include ("inc/info_tab_ins.inc.php");
       
   416 
       
   417                 // upload File
       
   418                 if (is_uploaded_file($_FILES["ifile"]["tmp_name"]) && isset($_FILES["ifile"]["name"]) && $_FILES["ifile"]["name"] )
       
   419                 {
       
   420                     include ("inc/file_upload.inc.php");
       
   421                     $fname  = gen_filename($inf['ifname'],"ifile",$infid);
       
   422                     $retdf  = mod_file("/var/www/fhiiqm/infos",$infid,"","del");     // Loeschen alte Datei
       
   423                     $retf   = upload("ifile", $fname, $infid, "infos");              // Datei prüfen und in Dokumentenverzeichnis verschieben
       
   424                     
       
   425                     if ($retf)
       
   426                     {   // upload o.k.
       
   427                         //UPDATE des Filenamens
       
   428                         $sql = "UPDATE Info SET info_file = '" . $infid . "_" . $fname ."' WHERE info_ID=$infid";
       
   429                         $reti=$dbc->execute($sql);
       
   430                         if (!$reti) 
       
   431                             echo $dbc -> error . "<br>\n";
       
   432                     }
       
   433                    
       
   434                 }
       
   435                 else
       
   436                 {// nur Aenderung Dateiname
       
   437                     if ($inf["ifname"]) // Dateiname vergeben
       
   438                     {
       
   439                         include ("inc/file_upload.inc.php");
       
   440                         $fname = gen_filename($inf["ifname"],$ifile_old,$infid,0);
       
   441                         $len = strlen($infid)+1;
       
   442                         if (substr($fname,0,$len) != "$infid" . "_") $fname = $infid . "_" . $fname;
       
   443                         if ($inf["ifname"] != $ifile_old)
       
   444                         {
       
   445                             $retf  = mod_file("/var/www/fhiiqm/infos",$infid,$fname,"upd");  // Umbenennen alte Datei
       
   446                             if ($retf) 
       
   447                             {
       
   448                                 $sql = "UPDATE Info SET info_file = '" . $fname . "' WHERE info_ID=$infid";
       
   449                                 $reti=$dbc->execute($sql);
       
   450                                 if (!$reti) 
       
   451                                     echo $dbc -> error . "<br>\n";
       
   452                                 if (substr($fname,0,$len) == "$infid" . "_") $fname = substr($fname,$len,50);
       
   453                             }
       
   454                             
       
   455                         }
       
   456                         else
       
   457                         {
       
   458                             //kein Upload, keine Dateinamenaenderung
       
   459                             if (substr($fname,0,$len) == "$infid" . "_") $fname = substr($fname,$len,50);
       
   460                             $retf=1; $reti=1;
       
   461                         }
       
   462                     }
       
   463                     else // kein Dateiname angegeben
       
   464                     {$retf=1; $reti=1;}
       
   465                 }
       
   466             }            
       
   467             if ($result && $retf && $reti && $reta && $retp && $retv) // INSERT/UPDATE Info
       
   468             {
       
   469                 //Eingabe Daten, Upload File erfolgreich 
       
   470                     echo "<p class='green'><b>Infodaten zu ID '$infid' wurden erfolgreich gespeichert.</b></p>\n";
       
   471                     echo "<br /><br />\n";
       
   472 
       
   473                 // Anzeigen gespeicherte Infodaten
       
   474                 if ($fname)
       
   475                     $ifile = $infid . "_" . $fname;
       
   476                 else
       
   477                     $ifile = $inf['ifname'];
       
   478                 include ("inc/info_dat_show.inc.php");
       
   479             }            
       
   480         }   // INSERT / UPDATE
       
   481         echo "</div>";
       
   482         echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"info_flist.php\" target=\"_self\" title=\"Infoliste\">Infoliste</a></p>\n"; 
       
   483         echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Info erfassen\">Weitere Info erfassen</a></p>\n";    
       
   484         
       
   485     }   // Form o.k. und submit
       
   486 ?>
       
   487     
       
   488 </body>
       
   489 </html>