Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1
<?
2
	$self=basename($PHP_SELF);
3
	$DB="Auftraggeber";
4
	require("connect.php");
5
 
6
		if ($action=="update")
7
		{
8
			if ($ID)
9
			{
10
				unset($HTTP_POST_VARS[action]);
11
				unset($HTTP_POST_VARS[ID]);
12
 
13
				if ($HTTP_POST_VARS[pwd] == '')
14
				{
15
					mysql_select_db ("Access");
16
					$query="update asset_trading_de set user='$HTTP_POST_VARS[user]' where ID=$ID";
17
					$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
18
					mysql_select_db ("asset_trading_de");
19
				}
20
				else
21
				{
22
					mysql_select_db ("Access");
23
					$HTTP_POST_VARS[pwd]=crypt($HTTP_POST_VARS[pwd]);
24
					$query="update asset_trading_de set user='$HTTP_POST_VARS[user]', passwd='$HTTP_POST_VARS[pwd]' where ID=$ID";
25
					$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
26
					mysql_select_db ("asset_trading_de");
27
				}
28
				unset($HTTP_POST_VARS[pwd]);
29
				$names=array();
30
				foreach(array_keys($HTTP_POST_VARS) as $elem)
31
				{
32
					array_push($names,"$elem='$HTTP_POST_VARS[$elem]'");
33
				}
34
 
35
				$query="update $DB set ".join($names,', ');
36
				$query=$query." where ID = ".$ID;
37
 
38
 
39
				$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
40
				header("Location: ".$self);
41
			}
42
			else // $action="insert"
43
			{
44
				unset($HTTP_POST_VARS[action]);
45
				unset($HTTP_POST_VARS[ID]);
46
				$pwd=crypt($HTTP_POST_VARS[pwd]);
47
				unset($HTTP_POST_VARS[pwd]);
48
				$Names=join(array_keys($HTTP_POST_VARS),',');
49
				$Values="'".join($HTTP_POST_VARS,"','")."'";
50
 
51
				$query="insert into $DB ($Names) VALUES ($Values)";
52
				$result = mysql_query ("$query");
53
				$error = mysql_errno();
54
				if ($error == 1062)
55
				{
56
					$action = "duplicate_error";
57
				}
58
				else
59
				{
60
					$ID=mysql_insert_id();
61
					mysql_select_db ("Access");
62
					$query="insert into asset_trading_de (user,passwd,ID) values ('$HTTP_POST_VARS[user]', '$pwd', '$ID')";
63
					$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
64
					mysql_select_db ("asset_trading_de");
65
					header("Location: ".$self);
66
				}
67
			}
68
		}
69
		if ($action=="delete")
70
		{
71
			if ($ID)
72
			{
73
				$condition=array();
74
				foreach ($ID as $elem) {array_push($condition," ID = ".$elem);}
75
				$cond=join(" or ",$condition);
76
				$query = "DELETE FROM $DB WHERE $cond";
77
				$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
78
 
79
				mysql_select_db ("Access");
80
				$query = "DELETE FROM asset_trading_de WHERE $cond";
81
				$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
82
				mysql_select_db ("asset_trading_de");
83
 
84
				header("Location: ".$self);
85
			}
86
		}
87
		if (!$action)
88
		{
89
			$action="select_edit";
90
		}
91
		if (!$sort) {$sort='Name1';}
92
?>
93
 
94
<html>
95
<head>
96
<title><? echo $webs[kunde_bezeichnung] ?>: Redaktionssystem</title>
97
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
98
<!--link rel=stylesheet type="text/css" href="../redaktion.css"-->
99
<script language="JavaScript">
100
<!--
101
function MM_swapImgRestore() { //v3.0
102
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
103
}
104
 
105
function MM_preloadImages() { //v3.0
106
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
107
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
108
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
109
}
110
 
111
function MM_swapImage() { //v3.0
112
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
113
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
114
}
115
 
116
function MM_openBrWindow(theURL,winName,features) { //v2.0
117
  window.open(theURL,winName,features);
118
}
119
 
120
function MM_findObj(n, d) { //v4.0
121
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
122
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
123
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
124
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
125
  if(!x && document.getElementById) x=document.getElementById(n); return x;
126
}
127
 
128
function MM_validateForm() { //v4.0
129
  var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
130
  for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
131
    if (val) { nm=val.name;if (nm=="user") {nm="Kennung";} if ((val=val.value)!="") {
132
      if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
133
        if (p<1 || p==(val.length-1)) errors+='- '+nm+' muss eine E-Mail Adresse sein.\n';
134
      } else if (test!='R') {
135
        if (isNaN(val)) errors+='- '+nm+' muss eine Zahl sein.\n';
136
        if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
137
          min=test.substring(8,p); max=test.substring(p+1);
138
          if (val<min || max<val) errors+='- '+nm+' muss eine Zahl zwischen '+min+' und '+max+' sein.\n';
139
    } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' wird benötigt.\n'; }
140
  } if (errors) alert('Folgende Fehler sind aufgetreten:\n'+errors);
141
  document.MM_returnValue = (errors == '');
142
}
143
//-->
144
</script>
145
<script language="javascript" src="file:///L|/asset-trading.de/redaktion/checkDate.js"></script>
146
<meta name="description" content="Redaktionssystem">
147
<meta name="author" content="Webagentur Niewerth">
148
<meta name="robots" content="noindex">
149
<style type="text/css">
150
A:link {text-decoration: none; color: #<? echo $webs[bgcolor_links] ?>}
151
A:visited {text-decoration: none; color: #<? echo $webs[bgcolor_links] ?>}
152
A:hover {text-decoration: none; color: #999900}
153
span {text-decoration:underline; color:#000000}
154
p {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[bgcolor_links] ?>}
155
p.error {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[bgcolor_links] ?>; font-weight: bold}
156
span.small {font-family: Arial, Helvetica, sans-serif; font-size: 8pt; text-decoration: none}
157
td {font-family: Arial, Helvetica, sans-serif; font-size: 10pt}
158
td.timeout {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #FF0000;}
159
td.small {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
160
td.headline {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #FFFFFF; font-weight: bold}
161
td.haupt {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-weight: bold}
162
input {  font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
163
select {  font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
164
textarea {  font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
165
</style>
166
</head>
167
 
168
<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_delete_f2.gif','../images/redaktion/bt_bearbeiten_f2.gif')" text="#000000">
169
<form method="post" action="#" name="formname" enctype="multipart/form-data">
170
  <table width="662" border="0" cellspacing="0" cellpadding="0">
171
    <tr valign="top">
172
 
173
      <td width="585">
174
        <?
175
		if ($action=="duplicate_error")
176
		{?>
177
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
178
          <tr>
179
            <td colspan="3" class="headline" bgcolor="#<? echo $webs[bgcolor_links] ?>">Auftraggeber:
180
              Neueintrag</td>
181
          </tr>
182
          <tr>
183
            <td width="100%">
184
              <p class="error">Fehler!</p>
185
                Dieses Login ist bereits vergeben! </td>
186
          </tr>
187
          <tr>
188
            <td colspan="3" bgcolor="#<? echo $webs[bgcolor_links] ?>">&nbsp;</td>
189
          </tr>
190
        </table>
191
		<?}
192
	?>
193
        <?  if ($action=="delete")
194
	{
195
	$result = mysql_query ("SELECT * FROM $DB order by $sort") or die (mysql_errno().": ".mysql_error());
196
	if (mysql_num_rows($result) == 0)
197
	{
198
	?>
199
        <p class="error">Es sind keine
200
            Daten eingetragen !</p>
201
          <p></p>
202
 
203
	<?
204
	}
205
	else
206
	{
207
	?>
208
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
209
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
210
            <td colspan="3" class="headline">Auftraggeber: L&ouml;schen</td>
211
</tr>
212
<tr>
213
	        <td width="15%" class="haupt"><a href="<? echo $self?>?action=delete&sort=user">Login</a></td>
214
	        <td class="haupt"><a href="<? echo $self?>?action=delete&sort=Name1">Name1</a></td>
215
	<td width=4%>&nbsp;</td>
216
</tr>
217
<?
218
	while ($zeile=mysql_fetch_array($result))
219
	{
220
?>
221
<tr><td><a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>"><? echo $zeile[user]; ?></a></td><td><a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>"><? echo $zeile[Name1]; ?></a></td><td><input type="checkbox" name="ID[]" value="<?  echo $zeile[ID] ?>"></td></tr>
222
<?
223
	}
224
?>
225
<tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
226
	<td colspan="3" align="right">
227
		<input type="hidden" name="action" value='delete'>
228
		<input type="submit" value="LÖSCHEN">
229
		<input type="reset" name="Button22" value="Zur&uuml;cksetzen">
230
	</td>
231
</tr>
232
</table>
233
        <?
234
	}
235
?>
236
        <?
237
 	}
238
?>
239
        <?
240
 
241
  if ($action=="select_edit")
242
	{
243
	$result = mysql_query ("SELECT * FROM $DB order by $sort") or die (mysql_errno().": ".mysql_error());
244
	if (mysql_num_rows($result) == 0)
245
	{
246
	?>
247
 
248
          <p class="error">Es sind keine
249
            Daten eingetragen !</p>
250
          <p></p>
251
 
252
	<?
253
	}
254
	else
255
	{
256
	?>
257
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
258
          <tr>
259
	        <td colspan="2" class="headline" bgcolor="#<? echo $webs[bgcolor_links] ?>">Auftraggeber: Bearbeiten</td>
260
</tr>
261
<tr>
262
	        <td width="15%" class="haupt"><a href="<? echo $self?>?action=select_edit&sort=user">
263
              Login</a></td>
264
	        <td class="haupt"><a href="<? echo $self?>?action=select_edit&sort=Name1">
265
              Name1 </a></td>
266
</tr>
267
<?
268
	while ($zeile=mysql_fetch_array($result))
269
	{
270
?>
271
<tr><td><a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>"><? echo $zeile[user]; ?></a></td><td><a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>"><? echo $zeile[Name1]; ?></a></td></tr>
272
<?
273
	}
274
?>
275
          <tr>
276
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_links] ?>">&nbsp;
277
                <input type="hidden" name="action" value='edit'>
278
             </td>
279
          </tr>
280
        </table>
281
 <?
282
	}
283
?>
284
        <?
285
 	}
286
?> <?
287
	if ($action=="edit")
288
	{
289
		if ($ID)
290
		{
291
			$result = mysql_query ("SELECT * FROM $DB where ID = $ID") or die (mysql_errno().": ".mysql_error());
292
			$zeile=mysql_fetch_array($result);
293
		}
294
  	$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
295
   	$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
296
   	$zeile[Eingangsdatum]=join(".",array_reverse(preg_split("/-/",$zeile[Eingangsdatum])));
297
	?>
298
	    <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
299
          <tr>
300
            <td colspan="4" class="headline" bgcolor="#<? echo $webs[bgcolor_links] ?>">Auftraggeber:
301
              <?
302
					if ($ID)
303
					{
304
					 ?>
305
              Bearbeiten
306
              <?
307
					}
308
					else
309
					{
310
					 ?>
311
              Neueintrag
312
              <?
313
					}
314
				?>
315
            </td>
316
          </tr>
317
          <tr>
318
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline">Name1:</td>
319
            <td colspan=3>
320
              <input type="text" name="Name1" size="30" value="<? echo $zeile[Name1]?>">
321
            </td>
322
          </tr>
323
          <tr>
324
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline"><font color="#FFFFFF">Name2:</font></td>
325
            <td colspan=3>
326
              <input type="text" name="Name2" size="30" value="<? echo $zeile[Name2]?>">
327
            </td>
328
          </tr>
329
          <tr>
330
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline">Strasse:</td>
331
            <td width="148">
332
              <input type="text" name="Strasse" size="30" value="<? echo $zeile[Strasse]?>">
333
            </td>
334
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="95" class="headline">Hausnummer:</td>
335
            <td width="159">
336
              <input type="text" name="Nr" size="6" value="<? echo $zeile[Nr]?>">
337
            </td>
338
          </tr>
339
          <tr>
340
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline">PLZ/Ort:</td>
341
            <td colspan=3>
342
              <input type="text" name="PLZ" size="5" value="<? echo $zeile[PLZ]?>">
343
              <input type="text" name="Ort" size="30" value="<? echo $zeile[Ort]?>">
344
            </td>
345
          </tr>
346
          <tr>
347
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline">Telefon:</td>
348
            <td colspan=3>
349
              <input type="text" name="Tel" size="30" value="<? echo $zeile[Tel]?>">
350
            </td>
351
          </tr>
352
          <tr>
353
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline">Fax:</td>
354
            <td colspan=3>
355
              <input type="text" name="Fax" size="30" value="<? echo $zeile[Fax]?>">
356
            </td>
357
          </tr>
358
          <tr>
359
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline">E-Mail:</td>
360
            <td colspan=3>
361
              <input type="text" name="E_Mail" size="30" value="<? echo $zeile[E_Mail]?>">
362
            </td>
363
          </tr>
364
          <tr>
365
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline" valign="top">Rechte:</td>
366
            <td colspan=3>
367
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
368
                <tr>
369
                  <td width="23%">Loginname:</td>
370
                  <td>
371
                    <input type="text" name="user" size="30" value="<? echo $zeile[user]?>">
372
                  </td>
373
                </tr>
374
                <tr>
375
                  <td width="23%">Passwort:</td>
376
                  <td>
377
                    <input type="password" name="pwd" size="30">
378
                  </td>
379
                </tr>
380
                <tr>
381
                  <td width="23%">Status:</td>
382
                  <td>
383
                    <select name="select">
384
                      <option value="1" selected>H&auml;nderl 1</option>
385
                      <option value="2">H&auml;nderl 2</option>
386
                      <option value="3">H&auml;nderl 3</option>
387
                      <option value="4">H&auml;nderl 4</option>
388
                      <option value="5">H&auml;nderl 5</option>
389
                      <option value="6">H&auml;nderl 6</option>
390
                    </select>
391
                  </td>
392
                </tr>
393
              </table>
394
 
395
            </td>
396
          </tr>
397
          <tr>
398
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" colspan="4" class="headline">Ansprechpartner:</td>
399
          </tr>
400
          <tr>
401
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>">&nbsp;</td>
402
            <td colspan=3>
403
              <table border=0 cellpadding="0" cellspacing="0" width="100%" height="100%">
404
                <tr>
405
                  <td width="23%">Name:</td>
406
                  <td width="77%">
407
                    <input type="text" name="Ansprechpartner_Name" size="30" value="<? echo $zeile[Ansprechpartner_Name]?>">
408
                  </td>
409
                </tr>
410
                <tr>
411
                  <td width="23%">Handy:</td>
412
                  <td width="77%">
413
                    <input type="text" name="Handy" size="30" value="<? echo $zeile[Handy]?>">
414
                  </td>
415
                </tr>
416
              </table>
417
            </td>
418
          </tr>
419
          <tr>
420
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="64" class="headline">&nbsp;</td>
421
            <td colspan=3>
422
              <table border=0 cellpadding="0" cellspacing="0" width="100%" height="100%">
423
                <tr>
424
                  <td width="23%" valign="top">Bemerkung:</td>
425
                  <td width="77%" class="small">
426
                    <textarea name="Bemerkung" cols="35" rows="5" wrap="OFF"><? echo $zeile[Bemerkung]?></textarea>
427
                  </td>
428
                </tr>
429
              </table>
430
            </td>
431
          </tr>
432
          <tr>
433
            <td colspan=4 align="right" bgcolor="#<? echo $webs[bgcolor_links] ?>">
434
              <input type="hidden" name="ID" value="<? echo $ID ?>">
435
              <input type="hidden" name="action" value="update">
436
              <input type="submit" value="OK" onClick="MM_validateForm('Name1','','R','user','','R');return document.MM_returnValue">
437
              <input type="reset" name="Button" value="Zur&uuml;cksetzen">
438
            </td>
439
          </tr>
440
        </table>
441
        <?
442
	}
443
?> </td>
444
      <td width="77" align="right">
445
        <table width="67" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#FFFFFF" bordercolordark="#999999">
446
  		<tr>
447
            <td><a href="<? echo $self ?>?action=edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('new','','file:///L|/asset-trading.de/images/redaktion/bt_neu_f2.gif',1)"><img name="new" border="0" src="file:///L|/asset-trading.de/images/redaktion/bt_neu.gif" width="67" height="40" alt="Neueintrag"></a></td>
448
  		</tr>
449
 	 	<tr>
450
            <td><a href="<? echo $self ?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('edit','','file:///L|/asset-trading.de/images/redaktion/bt_bearbeiten_f2.gif',1)"><img name="edit" border="0" src="file:///L|/asset-trading.de/images/redaktion/bt_bearbeiten.gif" width="67" height="40" alt="Eintrag bearbeiten"></a></td>
451
  		</tr>
452
  		<tr>
453
            <td><a href="<? echo $self ?>?action=delete" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('delete','','file:///L|/asset-trading.de/images/redaktion/bt_delete_f2.gif',1)"><img name="delete" border="0" src="file:///L|/asset-trading.de/images/redaktion/bt_delete.gif" width="67" height="40" alt="Eintrag l&ouml;schen"></a></td>
454
  		</tr>
455
		</table>
456
      </td>
457
</tr>
458
</table>
459
</form>
460
</body>