public function get_view()
{
$dbc = FannieDB::getReadOnly($this->config->get('OP_DB'));
$code = new ReasoncodesModel($dbc);
$ret = '<form method="post">
<p><button type="submit" class="btn btn-default">Save Reasons</button></p>
<table class="table table-bordered">
<tr>
<th>#</th>
<th>Reason</th>
<th>Current Accounts</th>
</tr>';
$countP = $dbc->prepare('
SELECT COUNT(*)
FROM suspensions
WHERE (reasoncode & ?) <> 0
');
for ($i = 0; $i < 30; $i++) {
$code->mask(1 << $i);
$count = $dbc->getValue($countP, array(1 << $i));
$reason = $code->load() ? $code->textStr() : '';
$ret .= sprintf('<tr>
<td>%d<input type="hidden" name="mask[]" value="%d" /></td>
<td><input type="text" class="form-control" name="reason[]" value="%s" />
<td>%d</td>
</tr>', $i + 1, 1 << $i, $reason, $count);
}
$ret .= '</table>';
$ret .= '<p><button type="submit" class="btn btn-default">Save Reasons</button></p>';
$ret .= '</form>';
return $ret;
}
function report_description_content()
{
$dbc = $this->connection;
$dbc->selectDB($this->config->get('OP_DB'));
$reason = 'Any Reason';
$mask = FormLib::get('reason', 0);
if ($mask != 0) {
$code = new ReasoncodesModel($dbc);
$code->mask($mask);
if ($code->load()) {
$reason = $code->textStr();
} else {
$reason = 'Unknown?';
}
}
return array('Accounts suspended for: ' . $reason);
}
