/** * @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; }