function genAnwendungTabelle($id) {
$fr_result = fnQueryNumberAndColumn('name', 'nummer', FR_TABLE, 'nummer', 'ASC');
$a_result = fnQueryNumberAndColumn('name', 'nummer', A_TABLE, 'nummer', 'ASC');
if ($fr_count > 0 && $a_count > 0) {
$data = $table = $bemerkungen = array(); $table[0][] = 'Fachrichtung:';
foreach($data['fr'] as $fr) {
}
$table[1][] = 'Anwendung:';
for($i = 0; $i <= $fr_count - 1; $i++) {
}
for($i = 2; $i <= $a_count+1; $i++) {
$a_nr = $i-1; // Start bei 1
$table[$i][] = $data['a'][$i-2]['name'];
for ($j = 1; $j <= $fr_count; $j++) {
$fr_nr = $j; // Start bei 1
$result = fnQueryNumberAndColumnWhere('nummer', 'fachrichtungnummer, anwendungnummer, bemerkung', OHKSHFRHA_TABLE, 'fachrichtungnummer = '.$fr_nr.' AND anwendungnummer = '.$a_nr.' AND kunststoffnummer = '.$id, 'nummer', 'ASC');
while($bemerkungen_res = mysql_fetch_assoc($result)) {$bemerkungen[] = $bemerkungen_res;} }
}
$bemerkungen_count = array(); $bemerkungen_count2 = array(); foreach ($bemerkungen as $bemerkung) {
$a = $bemerkung['anwendungnummer'];
$fr = $bemerkung['fachrichtungnummer'];
if (!isset($bemerkungen_count2[$a])) { $bemerkungen_count2[$a] = 0;
}
if (!isset($bemerkungen_count[$fr.'_'.$a])) { $bemerkungen_count[$fr.'_'.$a] = 0;
}
if (!empty($bemerkung['bemerkung'])) { $bemerkungen_count2[$a]++;
$bemerkungen_count[$fr.'_'.$a]++;
}
}
echo ' <table id="framatrix">'."n";
$trcount = $litref_count = 1;
$thead = $tfoot = $tbody = FALSE;
foreach ($table as $rows => $row) {
if (is_odd($trcount)) {
$trclass = 'odd';
} else {
$trclass = 'even';
}
if ($trcount === 1) {
echo ' <thead>'."n";
echo ' <tr class="'.$trclass.'">'."n";
} elseif ($trcount === 2) {
echo ' <tr class="'.$trclass.'">'."n";
$thead = TRUE;
} elseif ($trcount === 3) {
echo ' <tbody>'."n";
echo ' <tr class="'.$trclass.'">'."n";
$tbody = TRUE;
} elseif ($trcount === count($table)) { echo ' </tbody>'."n";
echo ' <tfoot>'."n";
echo ' <tr>'."n";
$tfoot = TRUE;
} else {
echo ' <tr class="'.$trclass.'">'."n";
}
$tdcount = 1;
foreach ($row as $col => $cell) {
if (is_odd($tdcount)) {
$tdclass = 'odd';
} else {
$tdclass = 'even';
}
$footnote = $spanclass = '';
if ($cell === 0) {
$celltext = '';
} else {
$celltext = $cell;
}
if ($trcount > 2 && $tdcount > 1) {
if ($tdcount != 1) {
$spanclass = 'empty_counter';
} else {
$spanclass = 'fra_counter';
$fra = ($tdcount - 1).'_'.($trcount - 2);
$footnote = '<cite class="footnote"><a href="#litref_'.$litref_count.'">'.$litref_count.'</a></cite>';
$litref_count++;
}
}
}
} else {
$spanclass = 'anwendung';
}
} else {
$footnote = '';
if ($trcount === 1) {
$spanclass = 'fachrichtung';
} else {
$spanclass = 'anwendung';
}
}
if ($thead || ($trcount === 1 && !$thead)) {
$out = ' <th ';
} else {
$out = ' <td ';
}
$out .= 'class="'.$tdclass.'"><span class="'.$spanclass.'">'.$celltext.'</span>';
$out .= $footnote;
}
if ($thead || ($trcount === 1 && !$thead)) {
$out .= '</th>';
} else {
$out .= '</td>';
}
echo $out."n";
$tdcount++;
}
echo ' </tr>'."n";
if ($thead) {
echo ' </thead>'."n";
$thead = FALSE;
} elseif ($trcount === count($table)-1) { $tbody = FALSE;
} elseif ($tfoot) {
echo ' </tfoot>'."n";
$tfoot = FALSE;
}
$trcount++;
}
echo ' </table>'."n";
if ($litref_count > 1) {
echo ' <div ="litref">'."n";
$litref_count = 1;
foreach ($bemerkungen_count as $key => $count) {
$out = ' <p id="litref_'.$litref_count.'"><sup>'.$litref_count.'</sup> ';
$sourceline = '';
$fr = $fra[0];
$a = $fra[1];
foreach ($bemerkungen as $bemerkung) {
if ($bemerkung['fachrichtungnummer'] === $fr && $bemerkung['anwendungnummer'] === $a) $sourceline .= $bemerkung['bemerkung'].'; ';
}
$sourceline = rtrim($sourceline, '; '); $out .= $sourceline.'</p>'."n";
echo $out;
$litref_count++;
}
echo ' </div>'."n";
}
}
}