function process_do($harvest_event_id, $taxa_count, $published, $agent_name, $agent_id, $ctr, $resource_title)
{
if ($agent_id == 27) {
$datatype = array(1 => array("label" => "IUCN", "id" => "6"));
} else {
$datatype = array(1 => array("label" => "Image", "id" => "1"), 2 => array("label" => "Sound", "id" => "2"), 3 => array("label" => "Text", "id" => "3"), 4 => array("label" => "Video", "id" => "4"), 5 => array("label" => "Flash", "id" => "7"), 6 => array("label" => "YouTube", "id" => "8"));
}
//start initialize
$vetted_type = array(1 => array("id" => Vetted::find("unknown"), "label" => "Unknown"), 2 => array("id" => Vetted::find("untrusted"), "label" => "Untrusted"), 3 => array("id" => Vetted::find("trusted"), "label" => "Trusted"));
for ($i = 1; $i <= count($datatype); $i++) {
for ($j = 1; $j <= count($vetted_type); $j++) {
$str1 = $vetted_type[$j]['id'];
$str2 = $datatype[$i]["id"];
$do[$str1][$str2] = array();
}
}
//end initialize
$qry = "Select data_objects.id, data_objects.data_type_id, data_objects.vetted_id From data_objects_harvest_events Inner Join data_objects ON data_objects_harvest_events.data_object_id = data_objects.id Where data_objects_harvest_events.harvest_event_id = {$harvest_event_id}";
$result = $this->mysqli->query($qry);
while ($result && ($row = $result->fetch_assoc())) {
$id = $row["id"];
$data_type_id = $row["data_type_id"];
$vetted_id = $row["vetted_id"];
$do[$vetted_id][$data_type_id][$id] = true;
}
$param = array();
for ($i = 1; $i <= count($datatype); $i++) {
for ($j = 1; $j <= count($vetted_type); $j++) {
$str1 = $vetted_type[$j]['id'];
$str2 = $datatype[$i]["id"];
$param[] = count($do[$str1][$str2]);
}
}
$arr = $param;
for ($j = 1; $j <= count($datatype); $j++) {
$sum[$j] = 0;
}
if ($ctr % 2 == 0) {
$color = '';
} else {
$color = 'aqua';
}
print "\n <table bgcolor='{$color}' cellpadding='3' cellspacing='0' border='1' style='font-size : x-small; font-family : Arial Narrow;'> \n <tr><td colspan='24'>\n <table>\n <tr><td>\n Agent: <a target='eol' href='http://www.eol.org/administrator/content_partner_report/show/{$agent_id}'>{$agent_name}</a>\n [{$resource_title}] \n <font size='2'>" . self::iif($published, "Published: {$published}", "-not yet published-") . " Harvest event id: {$harvest_event_id}</font>\n </td></tr>\n </table>\n </td></tr> \n <tr align='center'>";
for ($i = 1; $i <= count($datatype); $i++) {
print "<td colspan='3'>" . $datatype[$i]["label"] . "</td>";
}
print "</tr>";
print "\n <tr align='center'>";
$k = 0;
for ($j = 1; $j <= count($datatype); $j++) {
for ($i = 1; $i <= count($vetted_type); $i++) {
print "<td>" . $vetted_type[$i]['label'] . "</td>";
$index = $datatype[$j]["id"];
@($sum[$index] = @$sum[$index] + $arr[$k]);
$k++;
}
}
print "</tr>";
print "\n <tr align='center'>";
for ($i = 0; $i < count($arr); $i++) {
print "<Td align='right'>" . $arr[$i] . "</td>";
}
print "</tr>";
print "\n <tr align='center'>";
$k = 0;
for ($j = 1; $j <= count($datatype); $j++) {
print "<td colspan='3' align='right'>" . number_format($sum[$datatype[$j]["id"]]) . "</td>";
}
print "</tr>";
print " \n <tr><td colspan='24'>\n <table> \n <tr><td>Taxa count: </td><td align='right'>" . number_format($taxa_count, 0) . "</td></tr> \n <tr><td>Data objects: </td><td align='right'>" . number_format(array_sum($sum)) . "</td></tr>\n </table>\n </td></tr> \n </table>";
return "";
}
