/** Main view */
public function _default()
{
$feedback_collection = new FeedbackRepository();
$feedback_collection->addOrderByField('date_created', true);
echo Columns::getInstance()->add('<a href="?p=' . P . '&do=_remove_unconfirmed" class="btn btn-danger">Remove unconfirmed</a>
<a href="?p=' . P . '&do=_remove_dupes" class="btn btn-warning">Remove duplicate emails</a>', ['align' => 'right']);
echo CmsTable::getInstance()->addData($feedback_collection)->addColumn(ColumnData::getInstance('date_created')->enableOrderableColumn()->disableNewlines()->enableRightAlign()->setHref('?p=' . P . '&do=view&id={%id%}')->dataType('ts2datetime')->setTitle('Date'))->addColumn(ColumnData::getInstance('name')->enableOrderableColumn())->addColumn(ColumnData::getInstance('phone')->enableOrderableColumn())->addColumn(ColumnData::getInstance('email')->enableOrderableColumn()->dataType('email'))->addColumn(ColumnAccept::getInstance('done')->setHref('?p=' . P . '&do=_done&id={%id%}')->enableOrderableColumn())->addColumn(ColumnDelete::getInstance()->setHref('?p=' . P . '&do=_delete&id={%id%}'))->attachFilterForm(FilterForm::getInstance()->setWidth('100%')->addFilter('Email', Text::getInstance('email')->actAs('like')));
}
public static function outputTable(array $params)
{
// Check columns
if (!isset($params['columns'])) {
$params['columns'] = [];
}
// Check order column
if (isset($params['order']) && !isset($params['columns']['order'])) {
$params['columns']['order'] = ['type' => 'order'];
}
// Check active column
if (isset($params['active']) && !isset($params['columns']['active'])) {
$params['columns']['active'] = ['type' => 'active'];
}
// Check edit column
if (isset($params['edit']) && !isset($params['columns']['edit'])) {
$params['columns']['edit'] = ['type' => 'edit'];
}
// Check delete column
if (isset($params['delete']) && !isset($params['columns']['delete'])) {
$params['columns']['delete'] = ['type' => 'delete'];
}
// Check params are supplied
if (!isset($params['data'])) {
$params['data'] = [];
}
$table = new CmsTable();
$table->addData($params['data']);
// Table title
if (isset($params['title'])) {
$table->setHeadingTitle($params['title']);
}
foreach ($params['columns'] as $column_key => $column_param) {
if (!is_array($column_param)) {
$column_key = $column_param;
$column_param = ['type' => 'data'];
}
if (!isset($column_param['type'])) {
$column_param['type'] = 'data';
}
$column = NULL;
switch ($column_param['type']) {
case 'data':
$column = new ColumnData($column_key);
break;
case 'date':
$column = new ColumnData($column_key);
$column->setDataTypeAsTsToDatetime();
break;
case 'email':
$column = new ColumnData($column_key);
$column->setDataTypeAsEmail();
break;
case 'accept':
$column = new ColumnAccept($column_key);
break;
case 'order':
$column = new ColumnOrder($column_key);
break;
case 'edit':
$column = ColumnEdit::getInstance($column_key);
break;
case 'active':
$column = ColumnActive::getInstance($column_key);
break;
case 'delete':
$column = ColumnDelete::getInstance($column_key);
break;
case 'gallery':
$column = new ColumnGallery($column_key);
break;
case 'image':
$column = new ColumnImg($column_key);
break;
case 'bool':
case 'done':
$column = new ColumnDone($column_key);
break;
default:
dump('Unknown column type "' . $column_param['type'] . '"');
break;
}
// Disable cutting long texts by column
if (isset($column_param['cut_long_strings'])) {
if (!$column_param['cut_long_strings']) {
$column->disableCutLongStrings();
}
}
// Disable cutting long texts by entire table
if (isset($params['cut_long_strings'])) {
if (!$params['cut_long_strings']) {
$column->disableCutLongStrings();
}
}
// Is multi-translatable data in column
if (isset($column_param['translation']) && $column_param['translation']) {
$column->enableTranslationColumn();
}
// Is orderable
if (isset($column_param['order']) && $column_param['order']) {
$column->enableOrderableColumn();
}
// Is dragable
if (isset($column_param['order_drag']) && $column_param['order_drag']) {
$column->enableDraggable();
}
// Title
if (isset($column_param['title'])) {
$column->setTitle($column_param['title']);
}
// Images for gallery
if (isset($column_param['images'])) {
$column->setImages($column_param['images']);
}
// Width of column
if (isset($column_param['narrow'])) {
$column->enableNarrowWidth();
}
if (isset($column_param['width'])) {
$column->setWidth($column_param['width']);
}
// Link
if (isset($column_param['href'])) {
$column->setHref($column_param['href']);
}
// Paired array
if (isset($column_param['pairs'])) {
$column->setPairedDataOptionsForKeys($column_param['pairs']);
}
// Value for column
if (isset($column_param['value'])) {
$column->setValue($column_param['value']);
}
// Add to filters
if (isset($column_param['filter']) && !isset($params['filters'][$column_key])) {
$params['filters'][$column_key] = [];
}
if ($column) {
$table->addColumn($column);
}
}
// Apply filter
if (isset($params['filters']) || isset($params['caption'])) {
$filter_form = new FilterForm();
// Top caption above table
if (isset($params['caption'])) {
$filter_form->setCaption($params['caption']);
}
// Render filters
if (isset($params['filters'])) {
foreach ($params['filters'] as $filter_key => $filter_data) {
// Title is obligate
if (!isset($filter_data['title'])) {
$filter_data['title'] = ucfirst(__($filter_key));
}
// Default type
if (!isset($filter_data['type'])) {
$filter_data['type'] = 'text';
$filter_data['like'] = true;
}
//Filter types
$filter = NULL;
switch ($filter_data['type']) {
case 'text':
$filter = Text::getInstance($filter_key);
break;
case 'select':
$filter = Select::getInstance($filter_key);
$filter->ignoreValue(-1);
// For "empty" value
break;
default:
dump('Unknown filter type "' . $filter_data['type'] . '"');
break;
}
// Options for selects
if (isset($filter_data['options'])) {
$filter->setOptions($filter_data['options']);
}
// Ignore values in selects
if (isset($filter_data['ignore'])) {
$filter->ignoreValue($filter_data['ignore']);
}
// Like search
if (isset($filter_data['like'])) {
$filter->enableActAsLike();
}
if ($filter) {
$filter_form->addFilter($filter_data['title'], $filter);
}
}
}
$table->attachFilterForm($filter_form);
}
return $table;
}
