Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<!--  Auswahl SELECT_EDIT START  -->
2 
<?
3 
    $cond = array( "where 1" );
4 
    if ( $_GET["firma"] )
5 
    {
6 
        $cond[] = " firma=" . ( int )$_GET["firma"];
7 
    }
8 
    if ( isset($user_rechte[modul_name][tool_name]["language"]) )
9 
    {
10 
        $cond[] = "language='DE'";
11 
    }
12 
 
13 
    if ( is_array($_SESSION[$self]["filter"]) )
14 
    {
15 
        foreach ( $_SESSION[$self]["filter"] as $key => $value )
16 
        {
17 
            if ( $value )
18 
            {
19 
                if ( is_numeric($key) )
20 
                {
21 
                    $cond[] = $value;
22 
                }
23 
                else
24 
                {
25 
                    $cond[] = "$key = '$value'";
26 
                }
27 
            }
28 
        }
29 
    }
30 
    else
31 
    {
32 
        $cond = array();
33 
    }
34 
 
35 
    $query = "
36 
			SELECT
37 
				$tab.*,
38 
				DATE_FORMAT(gueltig_von,'%d.%m.%Y') as von,
39 
				DATE_FORMAT(gueltig_bis,'%d.%m.%Y') as bis
40 
			FROM
41 
				$tab
42 
			" . implode( " and ", $cond ) . "
43 
			ORDER BY
44 
				$sort
45 
			";
46 
    if ( !$result = mysql_query($query) )
47 
    {
48 
        unset( $_SESSION[$self]["filter"] );
49 
        die( mysql_errno() . ": " . mysql_error() . pre($query, true) );
50 
    }
51 
    $count = mysql_num_rows( $result );
52 
 
53 
    if ( !$start )
54 
    {
55 
        $start = 0;
56 
    }
57 
    $query = $query . " limit $start, $range";
58 
?>
59 
<table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
60 
  <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
61 
    <td class="headline" colspan="2" bgcolor="#<? echo $webs[bgcolor_links] ?>">
62 
		<span style="float:right"><?= $count; ?></span>
63 
		<font color="#<? echo $webs[font_color_links] ?>">News: Bearbeiten</font>
64 
	</td>
65 
  </tr>
66 
  <tr>
67 
  	<td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
68 
		<? require_once  "includes/filter.php"; ?>
69 
	</td>
70 
  </tr>
71 
<?
72 
    if ( $count == 0 )
73 
    {
74 
?><tr><td colspan="2">Es sind keine Daten eingetragen !</td></tr><?
75 
    }
76 
 
77 
    if ( $count >= $range )
78 
    {
79 
?><tr><td colspan="2" bgcolor="#<? echo $webs[bgcolor_links] ?>"><? require_once  "includes/blaettern.php"; ?></td></tr><?
80 
    }
81 
 
82 
 
83 
    $result = mysql_query( $query ) or die( mysql_errno() . ": " .
84 
        mysql_error() . "<hr>$query" );
85 
    while ( $zeile = mysql_fetch_array($result) )
86 
    {
87 
        // Versuchen den Artikel in language nachzuladen
88 
        $query_lang = "select * from $tab where language='$_SESSION[language]' and ID = $zeile[ID]";
89 
        if ( $result_lang = mysql_query($query_lang) )
90 
        {
91 
            if ( $zeile_lang = mysql_fetch_array($result_lang) )
92 
            {
93 
                $zeile = $zeile_lang;
94 
            }
95 
        }
96 
 
97 
?>
98 
	<tr>
99 
		<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" width="100%">
100 
<?
101 
        if ( ($_SESSION[language] != $zeile[language]) && (isset($user_rechte[modul_name][tool_name]["language"])) )
102 
        { ?><img src="../images/Online-Shop/directory/file!.gif"><? }
103 
 
104 
 
105 
?><a href="<? echo $self ?>?action=edit&ID=<? echo $zeile[ID]; ?>"><?
106 
 
107 
        $format_string = "ueberschrift;";
108 
        if ( $web_rechte[modul_name][tool_name][edit_string] )
109 
        {
110 
            $format_string = $web_rechte[modul_name][tool_name][edit_string];
111 
        }
112 
 
113 
        $elements = explode( ";", $format_string );
114 
 
115 
        foreach ( $elements as $elem )
116 
        {
117 
            if ( array_key_exists($elem, $zeile) )
118 
            {
119 
                if ( $zeile[$elem] )
120 
                {
121 
                    echo $zeile[$elem];
122 
                }
123 
                else
124 
                {
125 
                    echo "[no Name]";
126 
                }
127 
            }
128 
            else
129 
            {
130 
                echo $elem;
131 
            }
132 
 
133 
            if ( $elem != end($elements) )
134 
            {
135 
                echo "&nbsp;|&nbsp;";
136 
            }
137 
        }
138 
?></a><?
139 
 
140 
?>
141 
  </td>
142 
		<? if ( isset($user_rechte[modul_name][tool_name][kategorie]) )
143 
        { ?>
144 
			<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" nowrap>
145 
				<font color="<? echo $webs[font_color_rechts] ?>"><? echo $zeile[kategorie] ?></font>
146 
			</td>
147 
		<? } ?>
148 
  </tr>
149 
  <?
150 
    } // while
151 
 
152 
?>
153 
<tr>
154 
	<td align="right" colspan="2" bgcolor="#<? echo $webs[bgcolor_links] ?>">
155 
		<? if ( $count >= $range )
156 
    {
157 
        require_once  "includes/blaettern.php";
158 
    } ?>
159 
		<input type="submit" value="   OK   ">
160 
		<input type="reset" name="Button" value="Abbrechen">
161 
	</td>
162 
</tr>
163 
</table>
164 
<!--  Auswahl SELECT_EDIT ENDE  -->