public function get_view() { $dbc = $this->connection; $settings = $this->config->get('PLUGIN_SETTINGS'); $dbc->selectDB($settings['ScheduledEmailDB']); $templates = new ScheduledEmailTemplatesModel($dbc); $ret = '<table class="table table-bordered table-striped"> <thead> <tr> <th>ID</th> <th>Name</th> <th> </th> <th> </th> </tr> </thead> <tbody>'; foreach ($templates->find('scheduledEmailTemplateID') as $t) { $ret .= sprintf('<tr> <td>%d</td> <td>%s</td> <td><a class="btn btn-default btn-xs" href="?id=%d">%s</a></td> <td><a class="btn btn-danger btn-xs" href="?_method=delete&id=%d" onclick="return confirm(\'Delete template %s?\');">%s</a></td> </tr>', $t->scheduledEmailTemplateID(), $t->name(), $t->scheduledEmailTemplateID(), \COREPOS\Fannie\API\lib\FannieUI::editIcon(), $t->scheduledEmailTemplateID(), $t->name(), \COREPOS\Fannie\API\lib\FannieUI::deleteIcon()); } $ret .= '</tbody></table>'; $ret .= '<p> <a href="?_method=put" class="btn btn-default">Create New Template</a> </p>'; return $ret; }