*/
$actions_result = db_query("SELECT DISTINCT * FROM target_email_actions WHERE (digest_date IS NULL OR digest_date = '') AND project_id = '$project_id' ORDER BY redcap_data_access_group ASC, abs(record) ASC");
if ($actions_result) {
while ($actions_row = db_fetch_assoc($actions_result)) {
$item_count++;
foreach ($actions_row AS $key => $value) {
$$key = $value;
}
$event_keys = Event::getUniqueKeys($project_id);
$event_id = array_search($redcap_event_name, $event_keys);
$url = APP_PATH_WEBROOT_FULL . "redcap_v" . $redcap_version . "/DataEntry/index.php?pid=$project_id&id=$record&event_id=$event_id&page=$form_name";
$rows .= RCView::tr(array('style' => 'border:1px solid #d0d0d0;'),
RCView::td(array('class' => 'data_1', 'style' => "font-family:Verdana;font-size:8pt;background-color:" . row_style($item_count) . ";border:1px solid #CCCCCC;text-align:left;padding:5px 8px;"),
"<a href='{$url}'>$record</a>"
) .
RCView::td(array('class' => 'data_1', 'style' => "font-family:Verdana;font-size:8pt;background-color:" . row_style($item_count) . ";border:1px solid #CCCCCC;text-align:left;padding:5px 8px;"),
$redcap_data_access_group
)
);
if (!$debug) {
if (!db_query("UPDATE target_email_actions SET digest_date = '$today' WHERE action_id = '$action_id'")) {
error_log("ERROR: failed to update target_email_actions.digest_date");
}
}
d($actions_row);
}
if ($item_count > 0) {
/**
* construct html for email
*/
$html = "<div>";
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $result_row['aedecod']);
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $result_row['aehlt']);
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $result_row['aehlgt']);
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $result_row['aesoc']);
$rows .= RCView::tr('', $columns);
$item_count++;
}
if ($loose_result) {
if (db_num_rows($loose_result) > 0) {
while ($loose_result_row = db_fetch_assoc($loose_result)) {
$columns = '';
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $loose_result_row['aellt']);
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $loose_result_row['aedecod']);
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $loose_result_row['aehlt']);
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $loose_result_row['aehlgt']);
$columns .= RCView::td(array('class' => row_style($item_count), 'style' => 'white-space: nowrap;'), $loose_result_row['aesoc']);
$rows .= RCView::tr('', $columns);
$item_count++;
}
}
}
$tbody = "<tbody>" . $rows . "</tbody>";
echo RCView::table(array('id' => 'ae_report_results', 'class' => 'dt', 'cellspacing' => '0'), $thead . $tbody);
echo RCView::br() . RCView::br();
} else {
echo RCView::h3('', "Sorry, there were no results for that search. Try again?");
}
}
/**
* after submit and results are returned, highlight the search term
* @TODO: figure out why we can't set focus back to the search input field
}
}
if (sizeof($entries) > 0) {
$topSize = $entries[0]->getTotalSize();
echo "<table class='data'>";
echo "<tr>\n";
echo " <th>rank</th>\n";
echo " <th>self+desc</th>\n";
echo " <th>self</th>\n";
echo " <th>desc</th>\n";
echo " <th>count</th>\n";
echo " <th>class</th>\n";
echo "</tr>\n";
for ($i = 0; $i < sizeof($entries); $i++) {
$entry = $entries[$i];
echo "<tr class='" . row_style($i) . "'>";
echo "<td>";
printf("%.4f", $entry->getTotalSize() / $topSize);
echo "</td>";
echo "<td align='right'>";
printf("%.3fM", $entry->getTotalSize() / (1024 * 1024));
echo "</td>";
echo "<td align='right'>";
printf("%.3fM", $entry->getSelfSize() / (1024 * 1024));
echo "</td>";
echo "<td align='right'>";
printf("%.3fM", $entry->getChildSize() / (1024 * 1024));
echo "</td>";
echo "<td align='right'>";
printf("%d", $entry->getCount());
echo "</td>";
function print_db_pools($db_pools)
{
ob_start();
?>
<table class="data">
<tr>
<th> </th>
<th colspan='5' id='connections'><?php
echo info("Connections", "Database_Connections");
?>
</th>
<th colspan='2' id='config'><?php
echo info("Config", "Database_Connections");
?>
</th>
</tr>
<tr>
<th id='name'><?php
echo gettext('Name');
?>
</th>
<th id='active'><?php
echo gettext('Active');
?>
</th>
<th id='idle'><?php
echo gettext('Idle');
?>
</th>
<th id='created'><?php
echo gettext('Created');
?>
</th>
<th id='failed' colspan='2'><?php
echo gettext('Failed');
?>
</th>
<th id='max-connections'>max-connections</th>
<th id='idle-time'>idle-time</th>
</tr>
<?php
$row = 0;
foreach ($db_pools as $pool) {
?>
<tr class='<?php
echo row_style($row++);
?>
'>
<td headers="name"><?php
echo $pool->Name;
?>
</td>
<td headers="connections active"><?php
echo $pool->ConnectionActiveCount;
?>
</td>
<td headers="connections idle"><?php
echo $pool->ConnectionIdleCount;
?>
</td>
<td headers="connections created"><?php
echo format_miss_ratio($pool->ConnectionCountTotal, $pool->ConnectionCreateCountTotal);
?>
</td>
<td headers="connections failed"><?php
echo $pool->ConnectionFailCountTotal;
?>
</td>
<td headers="connections failed" class='<?php
echo format_ago_class($pool->LastFailTime);
?>
'>
<?php
echo format_ago($pool->LastFailTime);
?>
</td>
<td headers="config max-connections"><?php
echo $pool->MaxConnections;
?>
</td>
<td headers="config idle-time"><?php
echo sprintf("%.2fs", $pool->MaxIdleTime * 0.001);
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
return ob_get_clean();
}
<tr>
<th>Name</th>
<th>Active count</th>
<th>Idle count</th>
<th>Total count</th>
<th>max-connections</th>
<th>idle-time</th>
</tr>
<?php
$row = 0;
foreach ($db_pools as $pool) {
?>
<tr class='<?php
echo row_style($row++);
?>
'>
<td><?php
echo $pool->Name;
?>
</td>
<td><?php
echo $pool->ConnectionActiveCount;
?>
</td>
<td><?php
echo $pool->ConnectionIdleCount;
?>
</td>
<td><?php
