Blame | Letzte Änderung | Log anzeigen | RSS feed
<?$self=basename($PHP_SELF);$tab="speisekarte";define ("modul_name", "restaurant");define ("tool_name", "speisen");require_once "../Online-Shop/connect2.php";if ($action=="update"){$von=join("-",array_reverse(preg_split("/\./",$von)));$bis=join("-",array_reverse(preg_split("/\./",$bis)));if ($ID){$query="update $tab set Titel='$Titel', Text='$Text', Preis='$Preis', Rang='$Rang', von='$von', bis='$bis' where ID = $ID";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());header("Location: "."Speisekarte.php");}else{$query="insert into $tab (Titel,Text,Preis,Rang,von,bis) VALUES ('$Titel','$Text','$Preis','$Rang','$von','$bis')";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());header("Location: "."Speisekarte.php");}}if ($action=="delete"){if ($ID){$condition=array();foreach ($ID as $elem) {array_push($condition," ID = ".$elem);}$cond=join(" or ",$condition);$query = "DELETE FROM $tab WHERE $cond";$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());header("Location: "."Speisekarte.php");}else{//header("Location: "."KndStamm.php");}}if (!$action){$action="select_edit";}if ($action=="select_edit"){$headline='Übersicht';}if ($action=="edit"){$headline='Neueintrag';if ($ID){$headline='Bearbeiten';}}if ($action=="delete"){$headline='Entfernen';}if ($action=="view"){$headline='Übersicht';}?><html><head><title>Speisen - Redaktionssystem Webagentur Niewerth</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><meta name="description" content="Redaktionssystem"><meta name="author" content="Webagentur Niewerth"><meta name="robots" content="noindex"><link rel=stylesheet type="text/css" href="../buttons.css"><style type="text/css" link="redaktion.css"><MM:BeginLock translatorClass="MM_SSI" type="ssi" orig="%3C? require_once %22../buttons.css%22; ?%3E" fileRef="../buttons.css" depFiles="file:///L|/content-management/buttons.css">span {text-decoration:underline; color:#000000}p {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #000000}p.error {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-weight: bold}span {font-family: Arial, Helvetica, sans-serif; font-size: 10pt}span.blue {font-family: Arial, Helvetica, sans-serif; color: #FFFFFF; background-color:#0000A0; font-size: 10pt}span.small {font-family: Arial, Helvetica, sans-serif; font-size: 8pt; text-decoration: none}td {font-family: Arial, Helvetica, sans-serif; font-size: 10pt}td.timeout {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #FF0000;}td.small {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}td.headline {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #FFFFFF; font-weight: bold}td.haupt {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-weight: bold}input {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}select {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}textarea {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}a { text-decoration: none}</style><script language="JavaScript"><!--function MM_swapImgRestore() { //v3.0var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;}function MM_preloadImages() { //v3.0var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}}function MM_swapImage() { //v3.0var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}}function MM_findObj(n, d) { //v4.01var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);if(!x && d.getElementById) x=d.getElementById(n); return x;}function MM_validateForm() { //v4.0var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);if (val) { nm=val.name; if ((val=val.value)!="") {if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';} else if (test!='R') {if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';if (test.indexOf('inRange') != -1) { p=test.indexOf(':');min=test.substring(8,p); max=test.substring(p+1);if (val<min || max<val) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';} } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }} if (errors) alert('The following error(s) occurred:\n'+errors);document.MM_returnValue = (errors == '');}//--></script><script language="JavaScript" src="../checkDate.js"></script></head><body bgcolor="#<? echo $webs[bgcolor_seite]; ?>" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" onLoad="MM_preloadImages('../images/redaktion/bt_neu_f2.gif','../images/redaktion/bt_bearbeiten_f2.gif','../images/redaktion/bt_delete_f2.gif','../alt/images/redaktion/bt_ansicht_f2.gif','../images/navigation/bt_neu_f2.gif','../images/navigation/bt_bearbeiten_f2.gif','../images/navigation/bt_delete_f2.gif')" background="../neu/images/webelemente/bg_content.gif" text="#000000" ><form method="post" action="#"><table width="577" border="0" cellspacing="0" cellpadding="0"><tr valign="top"><td width="500"><table width="500" border="1" cellspacing="0" cellpadding="3"><tr><td colspan="3" bgcolor="#<? echo $webs[bgcolor_links] ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_seite] ?>"><b><? echo $headline ?></b></font></td></tr></table><?if ($action=="delete"){$result = mysql_query ("SELECT * FROM $tab order by von,Rang") or die (mysql_errno().": ".mysql_error());if (mysql_num_rows($result) == 0){?><font color="#<? echo $webs[font_color_seite] ?>"><b>Essind keine Daten eingetragen !</b></font><p> <font face="Arial, Helvetica, sans-serif" size="2"><?}while ($zeile=mysql_fetch_array($result)){$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));?></font></p><table width="500" border="1" cellspacing="0" cellpadding="3"><tr><td width="10%" bgcolor="#<? echo $webs[bgcolor_links] ?>"><font color="#<? echo $webs[font_color_links] ?>"><b>Titel:</b></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" colspan="4"><font face="Arial, Helvetica, sans-serif" size="2"><? if (!$zeile[Titel] == "") {echo $zeile[Titel];} else {echo " ";} ?></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" align="center" valign="middle" rowspan="2"><font face="Arial, Helvetica, sans-serif" size="2"><input type="checkbox" name="ID[]" value="<? echo $zeile[ID] ?>"></font></td></tr><tr><td width="10%" bgcolor="#<? echo $webs[bgcolor_links] ?>"><div align="left"><font color="#<? echo $webs[font_color_links] ?>"><b>Text:</b></font></div></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" colspan="4"><font face="Arial, Helvetica, sans-serif" size="2"><? if (!$zeile[Text] == "") {echo $zeile[Text];} else {echo " ";} ?></font><div align="center"> </div></td></tr><tr><td width="10%" bgcolor="#<? echo $webs[bgcolor_links] ?>"><div align="left"><font color="#<? echo $webs[font_color_links] ?>"><b>von:</b></font></div></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" width="32%"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $zeile[von] ?></font></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="10%" align="center" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>bis:</b></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" width="32%"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $zeile[bis] ?></font></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="15%"><font color="#<? echo $webs[font_color_links] ?>"><b>Position:</b></font></td><td align="center" valign="middle" width="11%" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $zeile[Rang] ?></font></td></tr></table><font face="Arial, Helvetica, sans-serif" size="2"><br><?}?> </font><table width="500" border="1" cellspacing="0" cellpadding="3"><tr><td colspan="3" bgcolor="#<? echo $webs[bgcolor_links] ?>"><div align="right"><input type="hidden" name="action" value='delete'><input type="submit" value="OK"><input type="reset" name="Button2" value="Zurücksetzen"></div></td></tr></table><font color="#<? echo $webs[font_color_seite] ?>"><?}?> <?if ($action=="select_edit"){$result = mysql_query ("SELECT * FROM $tab order by von,Rang asc") or die (mysql_errno().": ".mysql_error());if (mysql_num_rows($result) == 0){?> </font><div align="center"><p align="left"><font color="#<? echo $webs[font_color_seite] ?>"><b>Essind keine Daten eingetragen !</b></font></p></div><?}?><table width="500" border="1" cellspacing="0" cellpadding="3"><tr><td colspan=5 bgcolor="#<? echo $webs[bgcolor_links] ?>"><font color="#<? echo $webs[font_color_links] ?>"><b>Titel</b></font></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><div align="left"><font color="#<? echo $webs[font_color_links] ?>"><b>von</b></font></div></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="10%" align="left" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>bis</b></font></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="15%"><font color="#<? echo $webs[font_color_links] ?>"><b>Position</b></font></td></tr><?while ($zeile=mysql_fetch_array($result)){$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));?><tr><td colspan="5" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"> <a href="<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_rechts] ?>"><? echo $zeile[Titel]; ?></font></a> </td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_rechts] ?>"><? echo $zeile[von] ?></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_rechts] ?>"><? echo $zeile[bis] ?></font></td><td align="center" valign="middle" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_rechts] ?>"><? echo $zeile[Rang] ?></font></td></tr><font face="Arial, Helvetica, sans-serif" size="2"><?}?> </font></table><div align="right"><input type="hidden" name="action" value='edit'> </div><font face="Arial, Helvetica, sans-serif" size="2"><?}?> <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --><?if ($action=="view"){$result = mysql_query ("SELECT * FROM $tab") or die (mysql_errno().": ".mysql_error());if (mysql_num_rows($result) == 0){?> </font><div align="center"><p align="left"><font color="#<? echo $webs[font_color_seite] ?>"><b>Essind keine Daten eingetragen !</b></font></p><p></div><font face="Arial, Helvetica, sans-serif" size="2"><?}else{//$result = mysql_query ("SELECT * FROM $tab order by von asc") or die (mysql_errno().": ".mysql_error());//$zeile=mysql_fetch_array($result);$zeile[von]=date("Y-m-d");$von_array=preg_split("/-/",$zeile[von]);$result = mysql_query ("SELECT * FROM $tab order by von desc") or die (mysql_errno().": ".mysql_error());$zeile=mysql_fetch_array($result);$bis_array=preg_split("/-/",$zeile[bis]);}?> </font><table width="500" border="1" cellspacing="0" cellpadding="3"><?while (join("",$von_array) <= join("",$bis_array)){?><tr><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><a href="../tageskarte.php?Termin=<? echo join("-",$von_array) ?>"><font face="Arial, Helvetica, sans-serif" size="2"><? echo join(".",array_reverse($von_array)) ?></font></a></td></tr><?$von_array[2]=$von_array[2]+1;if ($von_array[2] < 10) {$von_array[2]="0".$von_array[2];}if (checkdate ($von_array[1],$von_array[2],$von_array[0])){}else{$von_array[2]="01";$von_array[1]=$von_array[1]+1;if ($von_array[1] < 10) {$von_array[1]="0".$von_array[1];}}if (checkdate ($von_array[1],$von_array[2],$von_array[0])){}else{$von_array[2]="01";$von_array[1]="01";$von_array[0]=$von_array[0]+1;}}?></table><font face="Arial, Helvetica, sans-serif" size="2"><?}?> <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --><?if ($action=="edit"){if ($ID){$result = mysql_query ("SELECT * FROM $tab where ID = $ID order by Rang desc") or die (mysql_errno().": ".mysql_error());$zeile=mysql_fetch_array($result);$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));}?> </font><table width="500" border="1" cellspacing="0" cellpadding="3"><tr><td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>Titel:</b></font></td><td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="middle"> <font face="Arial, Helvetica, sans-serif" size="2"><input type="text" name="Titel" size="45" value="<? echo $zeile[Titel]?>"></font></td></tr><tr><td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="top"><font color="#<? echo $webs[font_color_links] ?>"><b>Text:</b></font></td><td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"> <font face="Arial, Helvetica, sans-serif" size="2"><textarea name="Text" cols="39" rows="5"><? echo $zeile[Text]?></textarea></font></td></tr><tr><td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>Position:</b></font></td><td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="middle"> <font face="Arial, Helvetica, sans-serif" size="2"><select name="Rang"><option value="0" <? if ($zeile[Rang] == 0) {echo "selected";} ?>>Tagessuppe</option><option value="100" <? if ($zeile[Rang] == 100) {echo "selected";} ?>>Tagesempfehlung</option><option value="1" <? if ($zeile[Rang] == 1) {echo "selected";} ?>>1</option><option value="2" <? if ($zeile[Rang] == 2) {echo "selected";} ?>>2</option><option value="3" <? if ($zeile[Rang] == 3) {echo "selected";} ?>>3</option><option value="4" <? if ($zeile[Rang] == 4) {echo "selected";} ?>>4</option><option value="5" <? if ($zeile[Rang] == 5) {echo "selected";} ?>>5</option><option value="6" <? if ($zeile[Rang] == 6) {echo "selected";} ?>>6</option><option value="7" <? if ($zeile[Rang] == 7) {echo "selected";} ?>>7</option><option value="8" <? if ($zeile[Rang] == 8) {echo "selected";} ?>>8</option><option value="9" <? if ($zeile[Rang] == 9) {echo "selected";} ?>>9</option><option value="10" <? if ($zeile[Rang] == 10) {echo "selected";} ?>>10</option><option value="11" <? if ($zeile[Rang] == 11) {echo "selected";} ?>>11</option><option value="12" <? if ($zeile[Rang] == 12) {echo "selected";} ?>>12</option><option value="150" <? if ($zeile[Rang] == 150) {echo "selected";} ?>>Aktion1</option><option value="151" <? if ($zeile[Rang] == 151) {echo "selected";} ?>>Aktion2</option><option value="152" <? if ($zeile[Rang] == 152) {echo "selected";} ?>>Aktion3</option><option value="153" <? if ($zeile[Rang] == 153) {echo "selected";} ?>>Aktion4</option><option value="154" <? if ($zeile[Rang] == 154) {echo "selected";} ?>>Aktion5</option><option value="155" <? if ($zeile[Rang] == 155) {echo "selected";} ?>>Aktion6</option><option value="156" <? if ($zeile[Rang] == 156) {echo "selected";} ?>>Aktion7</option><option value="157" <? if ($zeile[Rang] == 157) {echo "selected";} ?>>Aktion8</option><option value="158" <? if ($zeile[Rang] == 158) {echo "selected";} ?>>Aktion9</option><option value="159" <? if ($zeile[Rang] == 159) {echo "selected";} ?>>Aktion10</option><option value="300" <? if ($zeile[Rang] == 300) {echo "selected";} ?>>Events</option></select></font></td></tr><tr><td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>Preis:</b></font></td><td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="middle"> <font color="#<? echo $webs[font_color_rechts] ?>"><input type="text" name="Preis" size="8" value="<? echo $zeile[Preis]?>"><b>€</b></font> </td></tr><tr><td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>Gültigkeit:</b></font></td><td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="middle"> <font color="#<? echo $webs[font_color_rechts] ?>"><b>von:<input type="text" name="von" size="10" maxlength="12" onFocus="current_value=this.value;if (this.value=='') {this.value=today()};this.select();" onChange="this.value=check_Date(this.value)" value="<? echo $zeile[von]?>"> bis: <input type="text" name="bis" size="10" maxlength="12" onFocus="current_value=this.value;if (this.value=='') {this.value=today()};this.select();" onChange="this.value=check_Date(this.value)" value="<? echo $zeile[bis]?>"></b></font></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td colspan="3"><div align="right"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif" size="2"><input type="hidden" name="ID" value="<? echo $ID ?>"><input type="hidden" name="action" value="update"></font> <font face="Arial, Helvetica, sans-serif" size="2"><input type="submit" value="OK" onClick="MM_validateForm('Titel','','R');return document.MM_returnValue"><input type="reset" name="Button" value="Zurücksetzen"></font></div></td></tr></table><font face="Arial, Helvetica, sans-serif" size="2"><?}?> </font><p></p><td width="77" align="right"><table width="67" border="1" cellspacing="0" cellpadding="0"><tr><td><a href="<? echo $self ?>?action=edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('new','','../images/navigation/bt_neu_f2.gif',1)"><img name="new" border="0" src="../images/navigation/bt_neu.gif" width="67" height="40" alt="Neueintrag"></a></td></tr><tr><td><a href="<? echo $self ?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('edit','','../images/navigation/bt_bearbeiten_f2.gif',1)"><img name="edit" border="0" src="../images/navigation/bt_bearbeiten.gif" width="67" height="40" alt="Eintrag bearbeiten"></a></td></tr><tr><td><a href="<? echo $self ?>?action=delete" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('delete','','../images/navigation/bt_delete_f2.gif',1)"><img name="delete" border="0" src="../images/navigation/bt_delete.gif" width="67" height="40" alt="Eintrag löschen"></a></td></tr><? // <tr>// <td><a href="Speisekarte.php?action=view" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('view','','../images/redaktion/bt_ansicht_f2.gif',1)"><img name="view" border="0" src="../images/redaktion/bt_ansicht.gif" width="67" height="40"></a></td>// </tr>?></table></td></tr></table></form></body></html>