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); }