-1
-2
function fixed ($incident, $vendors)
{
global $dbh;
global $vendor;
$query = "SELECT vendor,date,url FROM vendorreport WHERE incident = $incident";
if (count ($vendors)) {
$query .= " AND ( vendor = '" . implode ($vendors, "' OR vendor = '") . "' )";
}
$sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
$date = explode (" ", $row['date']);
$report[$row['vendor']] = sprintf ("%s %s", $date[0], $row['url']);
}
return $report;
}
function format_incident ($vendor, $report, $row, $color)
{
global $tcell;
global $trow;
$date = explode (" ", $row['date']);
$date = $date[0];
#$date = explode ("-", $date[0]);
#$date = sprintf ("%d/%02d/%02d", $date[0], $date[1], $date[2]);
if (strlen ($row['url'])) {
$incident = sprintf ("%s", $row['url'], $row['subject']);
} else {
$incident = $row['subject'];
}
$fixes = '';
for ($i=0; $i < count ($vendor); $i++) {
if ($report[$vendor[$i]]) {
$rep = explode (" ", $report[$vendor[$i]]);
if ($rep[1] == "n/v") {
$foo = $rep[1];
} elseif ($rep[1] == "n/a") {
$foo = $rep[0];
} else {
$foo = sprintf ("%s", $rep[1], $rep[0]);
}
} else {
#$foo = "n/a";
$foo = " ";
}
$fixes .= sprintf ($tcell, $foo);
}
return sprintf ($trow, $color, $date, $incident, $fixes);
}
$trow = '
| %s |
%s |
%s
';
$tcell = '%s | ';
?>
# Local variables:
# mode: indented-text
# mode: auto-fill
# end: