96 COUNT(CASE recht_ID WHEN 'pe' THEN 1 END) AS prod_edit, |
96 COUNT(CASE recht_ID WHEN 'pe' THEN 1 END) AS prod_edit, |
97 COUNT(CASE recht_ID WHEN 'pzr' THEN 1 END) AS proz_read, |
97 COUNT(CASE recht_ID WHEN 'pzr' THEN 1 END) AS proz_read, |
98 COUNT(CASE recht_ID WHEN 'pze' THEN 1 END) AS proz_edit, |
98 COUNT(CASE recht_ID WHEN 'pze' THEN 1 END) AS proz_edit, |
99 COUNT(CASE recht_ID WHEN 'rr' THEN 1 END) AS raum_read, |
99 COUNT(CASE recht_ID WHEN 'rr' THEN 1 END) AS raum_read, |
100 COUNT(CASE recht_ID WHEN 're' THEN 1 END) AS raum_edit, |
100 COUNT(CASE recht_ID WHEN 're' THEN 1 END) AS raum_edit, |
|
101 COUNT(CASE recht_ID WHEN 'ddr' THEN 1 END) AS dez_dat_read, |
|
102 COUNT(CASE recht_ID WHEN 'dde' THEN 1 END) AS dez_dat_edit, |
101 COUNT(CASE recht_ID WHEN 'rtr' THEN 1 END) AS recht_read, |
103 COUNT(CASE recht_ID WHEN 'rtr' THEN 1 END) AS recht_read, |
102 COUNT(CASE recht_ID WHEN 'rte' THEN 1 END) AS recht_edit, |
104 COUNT(CASE recht_ID WHEN 'rte' THEN 1 END) AS recht_edit, |
103 COUNT(CASE recht_ID WHEN 'vr' THEN 1 END) AS vertrag_read, |
105 COUNT(CASE recht_ID WHEN 'vr' THEN 1 END) AS vertrag_read, |
104 COUNT(CASE recht_ID WHEN 've' THEN 1 END) AS vertrag_edit, |
106 COUNT(CASE recht_ID WHEN 've' THEN 1 END) AS vertrag_edit, |
105 COUNT(CASE recht_ID WHEN 'vpr' THEN 1 END) AS vertr_part_read, |
107 COUNT(CASE recht_ID WHEN 'vpr' THEN 1 END) AS vertr_part_read, |
125 <th colspan='2'>Info</th> |
127 <th colspan='2'>Info</th> |
126 <th colspan='2'>Laser</th> |
128 <th colspan='2'>Laser</th> |
127 <th colspan='2'>Produkt</th> |
129 <th colspan='2'>Produkt</th> |
128 <th colspan='2'>Prozess</th> |
130 <th colspan='2'>Prozess</th> |
129 <th colspan='2'>Raum</th> |
131 <th colspan='2'>Raum</th> |
130 <th colspan='2'>Recht</th> |
|
131 <th colspan='2'>Vertrag</th> |
132 <th colspan='2'>Vertrag</th> |
132 <th colspan='2'>Vertr.Partner</th></tr>\n"; |
133 <th colspan='2'>Vertr.Partner</th> |
|
134 <th colspan='2'>dez. Daten</th> |
|
135 <th colspan='2'>Recht</th></tr>\n"; |
133 echo "<tr bgcolor='#68ACBF'>"; |
136 echo "<tr bgcolor='#68ACBF'>"; |
134 echo "<th>userid</th><th>read</th><th>edit</th> |
137 echo "<th>userid</th><th>read</th><th>edit</th> |
|
138 <th>read</th><th>edit</th> |
135 <th>read</th><th>edit</th> |
139 <th>read</th><th>edit</th> |
136 <th>read</th><th>edit</th> |
140 <th>read</th><th>edit</th> |
137 <th>read</th><th>edit</th> |
141 <th>read</th><th>edit</th> |
138 <th>read</th><th>edit</th> |
142 <th>read</th><th>edit</th> |
139 <th>read</th><th>edit</th> |
143 <th>read</th><th>edit</th> |
161 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->prod_edit)) ."</b></td>"; |
165 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->prod_edit)) ."</b></td>"; |
162 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->proz_read)) ."</b></td>"; |
166 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->proz_read)) ."</b></td>"; |
163 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->proz_edit)) ."</b></td>"; |
167 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->proz_edit)) ."</b></td>"; |
164 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->raum_read)) ."</b></td>"; |
168 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->raum_read)) ."</b></td>"; |
165 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->raum_edit)) ."</b></td>"; |
169 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->raum_edit)) ."</b></td>"; |
166 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->recht_read)) ."</b></td>"; |
|
167 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->recht_edit)) ."</b></td>"; |
|
168 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertrag_read)) ."</b></td>"; |
170 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertrag_read)) ."</b></td>"; |
169 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertrag_edit)) ."</b></td>"; |
171 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertrag_edit)) ."</b></td>"; |
170 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertr_part_read)) ."</b></td>"; |
172 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertr_part_read)) ."</b></td>"; |
171 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertr_part_edit)) ."</b></td>"; |
173 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertr_part_edit)) ."</b></td>"; |
|
174 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->dez_dat_read)) ."</b></td>"; |
|
175 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->dez_dat_edit)) ."</b></td>"; |
|
176 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->recht_read)) ."</b></td>"; |
|
177 echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->recht_edit)) ."</b></td>"; |
172 echo "</tr>\n"; |
178 echo "</tr>\n"; |
173 } |
179 } |
174 echo "</table></div>\n"; |
180 echo "</table></div>\n"; |
175 } |
181 } |
176 |
182 |