public function getFields()
{
$this->loadLanguageFile('backend/SiteNews');
foreach (ActiveGridController::getSchemaColumns('NewsPost', $this->application) as $key => $data) {
$fields[$key] = $this->translate($data['name']);
}
return $this->getGroupedFields($fields);
}
public function getFields()
{
$this->loadLanguageFile('backend/NewsletterSubscriber');
foreach (ActiveGridController::getSchemaColumns('NewsletterSubscriber', $this->application) as $key => $data) {
$fields[$key] = $this->translate($data['name']);
}
unset($fields['NewsletterSubscriber.confirmationCode']);
return $this->getGroupedFields($fields);
}
public function getFields()
{
$this->loadLanguageFile('backend/Currency');
foreach (ActiveGridController::getSchemaColumns('Currency', $this->application) as $key => $data) {
$fields[$key] = $this->translate($data['name']);
}
unset($fields['Currency.position']);
unset($fields['Currency.lastUpdated']);
unset($fields['Currency.rounding']);
return $this->getGroupedFields($fields);
}
public function getFields()
{
$this->loadLanguageFile('backend/User');
$this->loadLanguageFile('backend/UserGroup');
foreach (ActiveGridController::getSchemaColumns('UserAddress', $this->application) as $key => $data) {
$fields[$key] = $this->translate($data['name']);
}
$groupedFields = $this->getGroupedFields($fields);
$identify = array();
foreach (array('ID', 'email', 'isDefault', 'isShipping') as $field) {
$field = 'AddressUser.' . $field;
$identify[$field] = $this->application->translate($field);
}
$groupedFields['AddressUser'] = $identify;
return $groupedFields;
}
public function getFields()
{
$this->loadLanguageFile('backend/DeliveryZone');
$this->loadLanguageFile('backend/ShippingService');
foreach (ActiveGridController::getSchemaColumns('DeliveryZone', $this->application) as $key => $data) {
$fields[$key] = $this->translate($data['name']);
}
$fields = array_intersect_key($fields, array_flip(array('DeliveryZone.ID', 'DeliveryZone.name')));
foreach (ActiveGridController::getSchemaColumns('ShippingService', $this->application) as $key => $data) {
$fields[$key] = $this->translate($data['name']);
}
foreach (ActiveGridController::getSchemaColumns('ShippingRate', $this->application) as $key => $data) {
$fields[$key] = $this->translate($data['name']);
}
foreach (array('ShippingService.ID', 'ShippingService.position', 'ShippingRate.ID', 'ShippingRate.perItemChargeClass') as $unnecessary) {
unset($fields[$unnecessary]);
}
return $this->getGroupedFields($fields);
}
protected function getSelectFilter()
{
$filter = parent::getSelectFilter();
$id = $this->request->get('id');
if (!is_numeric($id)) {
$id = (int) substr($id, 6);
}
if ($id > 0) {
$filter->mergeCondition(new EqualsCond(new ARFieldHandle('User', 'userGroupID'), $id));
} else {
if ($id == -1) {
// without group
$filter->mergeCondition(new IsNullCond(new ARFieldHandle('User', 'userGroupID')));
} else {
if ($id == -3) {
// online
$filter->mergeHavingCondition(new EqualsOrMoreCond(f('isOnline'), 1));
}
}
}
$filter->addField('(SELECT COUNT(*) > 0 From SessionData WHERE userID=User.ID)', '', 'isOnline');
return $filter;
}
public function getAvailableColumns()
{
$availableColumns = parent::getAvailableColumns();
$validColumns = array('DiscountCondition.name', 'DiscountCondition.isEnabled', 'DiscountCondition.couponCode', 'DiscountCondition.validFrom', 'DiscountCondition.validTo', 'DiscountCondition.position');
return array_intersect_key($availableColumns, array_flip($validColumns));
}
public function changeColumns()
{
parent::changeColumns();
return $this->getGridResponse();
}
protected function getDisplayedColumns(Category $category)
{
// product ID is always passed as the first column
return parent::getDisplayedColumns($category, array('hiddenType' => 'numeric'));
}
protected function setGridResponse()
{
$res = parent::setGridResponse();
$displayedColumns = $res['displayedColumns'];
$availableColumns = $res['availableColumns'];
foreach ($displayedColumns as $column => $type) {
$parts = explode('.', $column);
if ('specField' == array_shift($parts)) {
$field = SpecField::getInstanceByID(array_shift($parts));
if ($field->isSelector()) {
$displayedColumns[$column] = $field->isMultiValue->get() ? 'multi-select' : 'select';
$values = array();
foreach ($field->getValuesList() as $value) {
$values[$value['ID']] = $value['value_lang'];
}
$availableColumns[$column]['values'] = $values;
}
}
}
$res['displayedColumns'] = $displayedColumns;
$res['availableColumns'] = $availableColumns;
return $res;
}
protected function getDisplayedColumns($params = null, $customColumns = array())
{
return parent::getDisplayedColumns($params, array_merge($customColumns, $this->getAlwaysDisplayedColumns()));
}
public function getAvailableColumns()
{
// get available columns
$availableColumns = parent::getAvailableColumns();
unset($availableColumns['CustomerOrder.shipping']);
unset($availableColumns['CustomerOrder.isFinalized']);
unset($availableColumns['CustomerOrder.checkoutStep']);
$availableColumns['HasUsedCoupon'] = array('type' => 'bool', 'name' => $this->translate('HasUsedCoupon'));
$availableColumns['UsedCouponCount'] = array('type' => 'numeric', 'name' => $this->translate('UsedCouponCount'));
$availableColumns['ProductCount'] = array('type' => 'numeric', 'name' => $this->translate('ProductCount'));
$availableColumns['UniqueProductCount'] = array('type' => 'numeric', 'name' => $this->translate('UniqueProductCount'));
$availableColumns['HasUnreadCustomerMessage'] = array('type' => 'bool', 'name' => $this->translate('HasUnreadCustomerMessage'));
$availableColumns['HasUnrespondedCustomerMessage'] = array('type' => 'bool', 'name' => $this->translate('HasUnrespondedCustomerMessage'));
return $availableColumns;
}
public function getAvailableColumns()
{
$availableColumns = parent::getAvailableColumns();
unset($availableColumns['ProductReview.ratingSum']);
unset($availableColumns['ProductReview.ratingCount']);
unset($availableColumns['ProductReview.ip']);
unset($availableColumns['Product.ID']);
return $availableColumns;
}
