/**
* @return \Zend\Http\Response\Stream|\Zend\Stdlib\ResponseInterface|\Zend\View\Model\ViewModel
*/
public function indexAction()
{
$this->layout('layout/admin');
$grid = $this->dataGridService;
$grid->setTitle('character-panel grid');
$grid->setDataSource($this->adminCharacterService->getCharacterQueryBuilder());
$grid->setToolbarTemplate(null);
$col = new Column\Select('id', 'p');
$col->setLabel('#');
$grid->addColumn($col);
$col = new Column\Select('jid', 'user');
$col->setLabel('BackendId');
$col->addFormatter(new Column\Formatter\GenerateLink($this->viewRenderer, 'PServerAdmin/user_detail', 'usrId', ['action' => 'backend']));
$grid->addColumn($col);
$col = new Column\Select('charName', 'p');
$col->setLabel('CharName');
$grid->addColumn($col);
$col = new Column\Select('deleted', 'p');
$col->setReplaceValues([0 => 'no', 1 => 'yes']);
$col->setLabel('Deleted');
$grid->addColumn($col);
$col = new Column\Select('nickName', 'p');
$col->setLabel('NickName');
$grid->addColumn($col);
$col = new Column\Select('name', 'guild');
$col->setLabel('GuildName');
$grid->addColumn($col);
$col = new Column\Select('jobType', 'job');
$col->setReplaceValues([0 => 'none', 1 => 'Trader', 2 => 'Thief', 3 => 'Hunter']);
$col->setLabel('JobType');
$grid->addColumn($col);
$col = new Column\Select('level', 'job');
$col->setLabel('JobLevel');
$grid->addColumn($col);
$col = new Column\Select('level', 'p');
$col->setLabel('Level');
$grid->addColumn($col);
$col = new Column\Select('lastLogout', 'p');
$col->setLabel('LastLogout');
$col->setType(new AdminDateTime());
$grid->addColumn($col);
$grid->render();
return $grid->getResponse();
}
/**
* Consumers list
*
* @return \ZfcDatagrid\Datagrid
*/
public function getDatagrid()
{
$grid = $this->getGrid();
$grid->setTitle('Customers');
$grid->setId('customerGrid');
$grid->setToolbarTemplateVariables(array('globalActions' => array(_('New Customer') => '/admin/customer/add'), array(_('New Customer') => '/admin/customer/add')));
$dbAdapter = $this->adapter;
$select = new Select();
$select->from(array('c' => 'customer'));
$select->join('user', 'c.user_id = user.user_id', array('email'), 'left');
$select->join('base_status', 'status_id = base_status.id', array('id'), 'left');
// Status array
$arrStatus = array();
$status = $this->statusservice->findAll('customers');
foreach ($status as $s) {
$arrStatus[$s->getId()] = $s->getStatus();
}
$grid->setDefaultItemsPerPage($this->settings->getValueByParameter('Customer', 'recordsperpage'));
$grid->setDataSource($select, $dbAdapter);
$col = new Column\Select('id', 'c');
$col->setLabel('Id');
$col->setIdentity();
$grid->addColumn($col);
$col = new Column\Select('company', 'c');
$col->setLabel(_('Company'));
$col->setWidth(40);
$grid->addColumn($col);
$col = new Column\Select('firstname', 'c');
$col->setLabel(_('Last name'));
$col->setWidth(15);
$grid->addColumn($col);
$col = new Column\Select('lastname', 'c');
$col->setLabel(_('First name'));
$col->setWidth(15);
$grid->addColumn($col);
$colType = new Type\DateTime('Y-m-d H:i:s', \IntlDateFormatter::SHORT, \IntlDateFormatter::SHORT);
$colType->setSourceTimezone('Europe/Rome');
$colType->setOutputTimezone('UTC');
$colType->setLocale('it_IT');
$col = new Column\Select('id', 'base_status');
$col->setLabel('Status');
$col->setWidth(10);
$col->setReplaceValues($arrStatus);
$col->setFilterSelectOptions($arrStatus);
$col->setTranslationEnabled(true);
$grid->addColumn($col);
$col = new Column\Select('email', 'user');
$col->setLabel(_('Email'));
$col->addFormatter(new Formatter\Email());
$col->addStyle(new Style\Bold());
$col->setWidth(15);
$grid->addColumn($col);
$col = new Column\Select('createdat', 'c');
$col->setType($colType);
$col->setLabel(_('Created At'));
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Icon();
$showaction->setAttribute('href', "/admin/customer/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id', 'c')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setIconClass('glyphicon glyphicon-pencil');
$delaction = new Column\Action\Icon();
$delaction->setAttribute('href', '/admin/customer/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('Are you sure?')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setIconClass('glyphicon glyphicon-remove');
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->addMassAction(new Action\Mass(_('Enable'), '/admin/customer/massaction/enable', true));
$grid->addMassAction(new Action\Mass(_('Disable'), '/admin/customer/massaction/disable', true));
$grid->addMassAction(new Action\Mass(_('Delete'), '/admin/customer/massaction/delete', true));
#$grid->setToolbarTemplateVariables(['myVariable' => 123]);
#$grid->setToolbarTemplate('zfc-datagrid/toolbar/customer');
return $grid;
}