/**
* Create service
*
* @param ServiceLocatorInterface $sm
* @return mixed
*/
public function createService(ServiceLocatorInterface $sm)
{
$dataGrid = new \ZfcDatagrid\Service\DatagridFactory();
$dataGrid = $dataGrid->createService($sm);
$dataGrid->setTitle('Seo');
$dataGrid->setDefaultItemsPerPage(20);
$em = $sm->get('doctrine.entitymanager.orm_default');
$qb = $em->createQueryBuilder();
$qb->select('s');
$qb->from('Seo\\Entity\\Seo', 's');
$dataGrid->setDataSource($qb);
$col = new Column\Select('id', 's');
$col->setWidth(1);
$col->setSortDefault(1, 'DESC');
$col->setIdentity();
$col->setHidden(false);
$col->setLabel('Id');
$dataGrid->addColumn($col);
$col = new Column\Select('pageId', 's');
$col->setLabel('PageId');
$dataGrid->addColumn($col);
$col = new Column\Select('type', 's');
$col->setLabel('Type');
// $col->setReplaceValues(array(
// 'BUILDER' => 'Builder',
// 'JOB' => 'Job',
// 'HOMEOWNER' => 'Homeowner'
// ));
$dataGrid->addColumn($col);
$col = new Column\Select('title', 's');
$col->setLabel('Title');
$dataGrid->addColumn($col);
$col = new Column\Select('description', 's');
$col->setLabel('Description');
$dataGrid->addColumn($col);
$col = new Column\Select('keywords', 's');
$col->setLabel('Keywords');
$dataGrid->addColumn($col);
$action2 = new Column\Action\Icon();
$action2->setIconClass('icon-edit');
$action2->setAttribute('href', "/seo/update/" . $action2->getRowIdPlaceholder());
$action2->setAttribute('data-toggle', 'modal');
$action2->setAttribute('data-target', '#updateModal');
$action3 = new Column\Action\Icon();
$action3->setIconClass('icon-remove');
$action3->setAttribute('href', '/seo/remove/' . $action3->getRowIdPlaceholder());
$action3->setAttribute('data-toggle', 'modal');
$action3->setAttribute('data-target', '#removeModal');
$col = new Column\Action();
$col->setLabel('Actions');
$col->setWidth(1);
$col->addAction($action2);
$col->addAction($action3);
$dataGrid->addColumn($col);
return $dataGrid;
}
public function listAction()
{
$request = $this->getRequest();
if ($request->isPost()) {
$postData = $request->getPost();
if ($postData->btnAdd === 'add') {
$this->redirect()->toRoute('backend_user');
}
}
$sl = $this->getServiceLocator();
$dbAdapter = $sl->get('Zend\\Db\\Adapter\\Adapter');
$grid = $sl->get('ZfcDatagrid\\Datagrid');
$grid->setDefaultItemsPerPage(5);
$grid->setToolbarTemplate('layout/list-toolbar');
$grid->setDataSource($sl->get('Backend\\Model\\UserTable')->getUsersList(), $dbAdapter);
$col = new Column\Select('id', 'u');
$col->setLabel('id');
$col->setWidth(25);
$col->setIdentity(true);
$col->setSortDefault(1, 'ASC');
$grid->addColumn($col);
$col = new Column\Select('username', 'u');
$col->setLabel('Username');
$col->setWidth(25);
$grid->addColumn($col);
$col = new Column\Select('full_name', 'u');
$col->setLabel('Name');
$col->setWidth(25);
$grid->addColumn($col);
$col = new Column\Select('email', 'u');
$col->setLabel('Email');
$col->setWidth(25);
$grid->addColumn($col);
$col = new Column\Select('name', 'r');
$col->setLabel('Rol');
$col->setWidth(25);
$grid->addColumn($col);
$editBtn = new Column\Action\Button();
$editBtn->setLabel('Edit');
$editBtn->setAttribute('class', 'btn btn-primary');
$editBtn->setAttribute('href', '/backend/user/edit/id/' . $editBtn->getRowIdPlaceholder());
$delBtn = new Column\Action\Button();
$delBtn->setLabel('Delete');
$delBtn->setAttribute('class', 'btn btn-danger');
$delBtn->setAttribute('href', '/backend/user/delete/id/' . $delBtn->getRowIdPlaceholder());
$col = new Column\Action();
$col->addAction($editBtn);
$col->addAction($delBtn);
$grid->addColumn($col);
return $grid->getResponse();
}
/**
* Consumers list
*
* @return \ZfcDatagrid\Datagrid
*/
public function getDatagrid()
{
$grid = $this->getGrid();
$grid->setId('dummyGrid');
$dbAdapter = $this->adapter;
$select = new Select();
$select->from(array('c' => 'dummy'));
$RecordsPerPage = $this->settings->getValueByParameter('Dummy', 'recordsperpage');
$grid->setDefaultItemsPerPage($RecordsPerPage);
$grid->setDataSource($select, $dbAdapter);
$colId = new Column\Select('id', 'c');
$colId->setLabel('Id');
$colId->setIdentity();
$grid->addColumn($colId);
$col = new Column\Select('name', 'c');
$col->setLabel(_('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('createdat', 'c');
$col->setType($colType);
$col->setLabel(_('Created At'));
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Button();
$showaction->setAttribute('href', "/admin/dummy/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id', 'c')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setLabel(_('edit'));
$delaction = new Column\Action\Button();
$delaction->setAttribute('href', '/admin/dummy/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('Are you sure?')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setLabel(_('delete'));
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->setToolbarTemplate('');
return $grid;
}
/**
* Consumers list
*
* @return \ZfcDatagrid\Datagrid
*/
public function getDatagrid()
{
$grid = $this->getGrid();
$grid->setId('profileDatagrid');
$dbAdapter = $this->adapter;
$select = new Select();
$select->from(array('p' => 'profile'));
$RecordsPerEvent = $this->settings->getValueByParameter('profile', 'recordsperevent');
$grid->setDefaultItemsPerPage($RecordsPerEvent);
$grid->setDataSource($select, $dbAdapter);
$colId = new Column\Select('id', 'p');
$colId->setLabel('Id');
$colId->setIdentity();
$grid->addColumn($colId);
$col = new Column\Select('name', 'p');
$col->setLabel(_('Name'));
$col->setWidth(15);
$grid->addColumn($col);
$col = new Column\Select('address', 'p');
$col->setLabel(_('Address'));
$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('createdat', 'p');
$col->setType($colType);
$col->setLabel(_('Created At'));
$grid->addColumn($col);
$col = new Column\Select('updatedat', 'p');
$col->setType($colType);
$col->setLabel(_('Updated At'));
$grid->addColumn($col);
$col = new Column\Select('public', 'p');
$col->setType(new \ZfcDatagrid\Column\Type\PhpString());
$col->setLabel(_('Public'));
$col->setTranslationEnabled(true);
$col->setFilterSelectOptions(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$col->setReplaceValues(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Button();
$showaction->setAttribute('href', "/admin/profile/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id', 'p')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setLabel(_('Edit'));
$delaction = new Column\Action\Button();
$delaction->setAttribute('href', '/admin/profile/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('" . _('Are you sure?') . "')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setLabel(_('Delete'));
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->setToolbarTemplate('');
return $grid;
}
/**
* Consumers list
*
* @return \ZfcDatagrid\Datagrid
*/
public function getDatagrid()
{
$grid = $this->getGrid();
$grid->setId('cmspagecategoryGrid');
$dbAdapter = $this->adapter;
$select = new Select();
$select->from(array('c' => 'cms_page_category'));
$grid->setDefaultItemsPerPage(100);
$grid->setDataSource($select, $dbAdapter);
$colId = new Column\Select('id', 'c');
$colId->setLabel('Id');
$colId->setIdentity();
$grid->addColumn($colId);
$col = new Column\Select('category', 'c');
$col->setLabel(_('Category'));
$col->setWidth(15);
$grid->addColumn($col);
$col = new Column\Select('visible', 'c');
$col->setType(new \ZfcDatagrid\Column\Type\String());
$col->setLabel(_('Visible'));
$col->setTranslationEnabled(true);
$col->setFilterSelectOptions(array('' => '-', '0' => 'No', '1' => 'Yes'));
$col->setReplaceValues(array('' => '-', '0' => 'No', '1' => 'Yes'));
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Button();
$showaction->setAttribute('href', "/admin/cmscategory/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id', 'c')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setLabel(_('edit'));
$delaction = new Column\Action\Button();
$delaction->setAttribute('href', '/admin/cmscategory/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('Are you sure?')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setLabel(_('delete'));
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->setToolbarTemplate('');
return $grid;
}
private function createGrid()
{
$dbAdapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$select = new Select();
$select->from(array('l' => 'base_languages'));
$grid = $this->getServiceLocator()->get('ZfcDatagrid\\Datagrid');
$grid->setDefaultItemsPerPage(100);
$grid->setDataSource($select, $dbAdapter);
$colId = new Column\Select('id', 'l');
$colId->setLabel('Id');
$colId->setIdentity();
$grid->addColumn($colId);
$col = new Column\Select('language', 'l');
$col->setLabel(_('Title'));
$col->setWidth(15);
$grid->addColumn($col);
$col = new Column\Select('locale', 'l');
$col->setLabel(_('Locale'));
$grid->addColumn($col);
$col = new Column\Select('base', 'l');
$col->setType(new \ZfcDatagrid\Column\Type\String());
$col->setLabel(_('Base'));
$col->setTranslationEnabled(true);
$col->setFilterSelectOptions(array('' => '-', '0' => 'No', '1' => 'Yes'));
$col->setReplaceValues(array('' => '-', '0' => 'No', '1' => 'Yes'));
$grid->addColumn($col);
$col = new Column\Select('active', 'l');
$col->setType(new \ZfcDatagrid\Column\Type\String());
$col->setLabel(_('Active'));
$col->setTranslationEnabled(true);
$col->setFilterSelectOptions(array('' => '-', '0' => 'No', '1' => 'Yes'));
$col->setReplaceValues(array('' => '-', '0' => 'No', '1' => 'Yes'));
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Button();
$showaction->setAttribute('href', "/admin/languages/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id', 'l')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setLabel($this->translator->translate('edit'));
$delaction = new Column\Action\Button();
$delaction->setAttribute('href', '/admin/languages/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('Are you sure?')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setLabel($this->translator->translate('delete'));
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->setToolbarTemplate('');
return $grid;
}
/**
* Product list
*
* @return \ZfcDatagrid\Datagrid
*/
public function getDatagrid()
{
$grid = $this->getGrid();
$grid->setId('productGrid');
$dbAdapter = $this->adapter;
$select = new Select();
$select->from(array('p' => 'product_attributes'));
$RecordsPerPage = $this->settings->getValueByParameter('product_attributes', 'recordsperpage');
$grid->setDefaultItemsPerPage($RecordsPerPage);
$grid->setDataSource($select, $dbAdapter);
$colId = new Column\Select('id', 'p');
$colId->setLabel('Id');
$colId->setIdentity();
$grid->addColumn($colId);
$col = new Column\Select('name', 'p');
$col->setLabel(_('Name'));
$col->setWidth(15);
$grid->addColumn($col);
$col = new Column\Select('type', 'p');
$col->setLabel(_('Type'));
$col->setWidth(5);
$grid->addColumn($col);
$col = new Column\Select('quick_search', 'p');
$col->setLabel(_('Search'));
$col->setWidth(5);
$col->setFilterSelectOptions(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$col->setReplaceValues(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$grid->addColumn($col);
$col = new Column\Select('label', 'p');
$col->setLabel(_('Label'));
$col->setWidth(15);
$grid->addColumn($col);
$col = new Column\Select('is_user_defined', 'p');
$col->setLabel(_('Is User Defined'));
$col->setWidth(5);
$col->setFilterSelectOptions(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$col->setReplaceValues(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$grid->addColumn($col);
$col = new Column\Select('is_required', 'p');
$col->setLabel(_('Is Required'));
$col->setWidth(5);
$col->setFilterSelectOptions(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$col->setReplaceValues(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Button();
$showaction->setAttribute('href', "/admin/product/attributes/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id', 'p')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setLabel(_('edit'));
$delaction = new Column\Action\Button();
$delaction->setAttribute('href', '/admin/product/attributes/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('Are you sure?')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setLabel(_('delete'));
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->setToolbarTemplate('');
return $grid;
}
/**
* 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;
}
/**
* Consumers list
*
* @return \ZfcDatagrid\Datagrid
*/
public function getDatagrid()
{
$grid = $this->getGrid();
$grid->setId('contactGrid');
$dbAdapter = $this->adapter;
$select = new Select();
$select->from(array('c' => 'customer_group'));
$grid = $this->getGrid();
$grid->setDefaultItemsPerPage(10);
$grid->setDataSource($select, $dbAdapter);
$colId = new Column\Select('id', 'c');
$colId->setLabel('Id');
$colId->setIdentity();
$grid->addColumn($colId);
$col = new Column\Select('name', 'c');
$col->setLabel(_('Name'));
$grid->addColumn($col);
$col = new Column\Select('enabled', 'c');
$col->setLabel(_('Enabled'));
$col->setWidth(15);
$col->setFilterSelectOptions(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$col->setReplaceValues(array('' => '-', '0' => _('No'), '1' => _('Yes')));
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Button();
$showaction->setAttribute('href', "/admin/customer/group/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id', 'c')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setLabel(_('edit'));
$delaction = new Column\Action\Button();
$delaction->setAttribute('href', '/admin/customer/group/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('Are you sure?')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setLabel(_('delete'));
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->setToolbarTemplate('');
return $grid;
}
/**
* Consumers list
*
* @return \ZfcDatagrid\Datagrid
*/
public function getDatagrid()
{
$grid = $this->getGrid();
$grid->setId('cmsblockGrid');
$dbAdapter = $this->adapter;
$select = new Select();
$select->from(array('b' => 'cms_block'))->join(array('l' => 'base_languages'), 'b.language_id = l.id', array('language'), 'left');
$grid->setDefaultItemsPerPage(100);
$grid->setDataSource($select, $dbAdapter);
$colId = new Column\Select('id', 'b');
$colId->setLabel('Id');
$colId->setIdentity();
$grid->addColumn($colId);
$col = new Column\Select('title', 'b');
$col->setLabel(_('Title'));
$col->setWidth(15);
$grid->addColumn($col);
$col = new Column\Select('placeholder', 'b');
$col->setLabel(_('Placeholder'));
$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('createdat', 'b');
$col->setType($colType);
$col->setLabel(_('Created At'));
$grid->addColumn($col);
$col = new Column\Select('updatedat', 'b');
$col->setType($colType);
$col->setLabel(_('Updated At'));
$grid->addColumn($col);
$col = new Column\Select('language', 'l');
$col->setLabel(_('Language'));
$col->addStyle(new Style\Bold());
$grid->addColumn($col);
$col = new Column\Select('visible', 'b');
$col->setType(new \ZfcDatagrid\Column\Type\String());
$col->setLabel(_('Visible'));
$col->setTranslationEnabled(true);
$col->setFilterSelectOptions(array('' => '-', '0' => 'No', '1' => 'Yes'));
$col->setReplaceValues(array('' => '-', '0' => 'No', '1' => 'Yes'));
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Button();
$showaction->setAttribute('href', "/admin/cmsblocks/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id', 'b')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setLabel(_('edit'));
$delaction = new Column\Action\Button();
$delaction->setAttribute('href', '/admin/cmsblocks/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('Are you sure?')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setLabel(_('delete'));
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->setToolbarTemplate('');
return $grid;
}
/**
* Product list
*
* @return \ZfcDatagrid\Datagrid
*/
public function getDatagrid()
{
$eavProduct = new \Product\Model\EavProduct($this->tableGateway);
$records = array();
$result = array();
$customAttributes = array();
$grid = $this->getGrid();
$grid->setId('productGrid');
$dbAdapter = $this->adapter;
$select = new Select();
$select->from(array('p' => 'product'));
// execute the query
$sql = new \Zend\Db\Sql\Sql($this->adapter);
$stmt = $sql->prepareStatementForSqlObject($select);
$results = $stmt->execute();
// execute the main query
$records = $this->tableGateway->select($select);
// load the attributes from the preferences
$columnsAttributesIdx = $this->settings->getValueByParameter('product', 'attributes');
if (!empty($columnsAttributesIdx)) {
// get from the database the custom attributes set as product preferences ($columnsAttributesIdx)
$selectedAttributes = $this->attributes->findbyIdx(json_decode($columnsAttributesIdx, true));
$selectedAttributes->buffer();
// Get the selected product attribute values ONLY
$attributes = $eavProduct->loadAttributes($results, $selectedAttributes);
$attributesValues = $attributes->toArray();
// loop the selected product attribute records
foreach ($attributesValues as $recordId => $attributeValue) {
// loop the record selected values
foreach ($attributeValue as $id => $value) {
// get the attribute information
$theAttribute = $eavProduct->getAttribute($id);
// create a temporary array of data to merge with the main datagrid array
$customAttributes[$recordId][$theAttribute->getName()] = $value;
// Create a custom column on the grid
$col = new Column\Select($theAttribute->getName());
$col->setLabel(_($theAttribute->getLabel()));
$grid->addColumn($col);
}
}
// Merge the temporary array with the main datagrid array
foreach ($records as $record) {
$result[] = array_merge($record->getArrayCopy(), $customAttributes[$record->getId()]);
}
}
$RecordsPerPage = $this->settings->getValueByParameter('product', 'recordsperpage');
$grid->setDefaultItemsPerPage($RecordsPerPage);
$grid->setDataSource($result);
$colId = new Column\Select('id');
$colId->setLabel('Id');
$colId->setIdentity();
$grid->addColumn($colId);
$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('createdat');
$col->setType($colType);
$col->setLabel(_('Created At'));
$col->setWidth(15);
$grid->addColumn($col);
// Add actions to the grid
$showaction = new Column\Action\Button();
$showaction->setAttribute('href', "/admin/product/edit/" . $showaction->getColumnValuePlaceholder(new Column\Select('id')));
$showaction->setAttribute('class', 'btn btn-xs btn-success');
$showaction->setLabel(_('edit'));
$delaction = new Column\Action\Button();
$delaction->setAttribute('href', '/admin/product/delete/' . $delaction->getRowIdPlaceholder());
$delaction->setAttribute('onclick', "return confirm('Are you sure?')");
$delaction->setAttribute('class', 'btn btn-xs btn-danger');
$delaction->setLabel(_('delete'));
$col = new Column\Action();
$col->addAction($showaction);
$col->addAction($delaction);
$grid->addColumn($col);
$grid->setToolbarTemplate('');
return $grid;
}