public function createAccess() { $query = new Am_Query($this->getDi()->accessLogTable); $query->leftJoin('?_user', 'm', 't.user_id=m.user_id')->addField("m.login", 'member_login')->addField("CONCAT(m.name_f, ' ', m.name_l)", 'member_name'); $query->setOrder('time', 'desc'); $g = new Am_Grid_ReadOnly('_access', ___('Access Log'), $query, $this->getRequest(), $this->view); $g->setPermissionId(Am_Auth_Admin::PERM_LOGS); $g->addGridField(new Am_Grid_Field_Date('time', ___('Time'), true, '', null, '10%')); $g->addGridField(new Am_Grid_Field('member_login', ___('User'), true, '', array($this, 'renderAccessMember'), '10%')); $g->addGridField(new Am_Grid_Field_Expandable('url', ___('URL'), true, '', null, '20%')); $g->addGridField(new Am_Grid_Field('remote_addr', ___('IP'), true, '', null, '10%')); $g->addGridField(new Am_Grid_Field_Expandable('referrer', ___('Referrer'), true, '', null, '15%')); $g->setFilter(new Am_Grid_Filter_Text(___('Filter by IP or Referrer or URL'), array('remote_addr' => 'LIKE', 'referrer' => 'LIKE', 'url' => 'LIKE'))); return $g; }
public function createAdminLog() { $ds = new Am_Query($this->getDi()->adminLogTable); $ds->setOrder('dattm', 'desc'); $g = new Am_Grid_ReadOnly('_admin', ___('Admin Log'), $ds, $this->getRequest(), $this->view); $g->setPermissionId(Am_Auth_Admin::PERM_LOGS_ADMIN); $g->addField(new Am_Grid_Field_Date('dattm', ___('Date/Time'), true)); $g->addField(new Am_Grid_Field('admin_login', ___('Admin'), true))->addDecorator(new Am_Grid_Field_Decorator_Link(REL_ROOT_URL . "/admin-admins?_admin_a=edit&_admin_id={admin_id}", '_top')); $g->addField(new Am_Grid_Field('ip', ___('IP'), true, '', null, '10%')); $g->addField(new Am_Grid_Field('message', ___('Message'))); $g->addField(new Am_Grid_Field('record', ___('Record')))->setRenderFunction(array($this, 'renderRec')); $g->setFilter(new Am_Grid_Filter_AdminLog()); return $g; }
public function displayeditcategoryAction() { if (!$this->strategy->canEditCategory(null)) { throw new Am_Exception_AccessDenied(); } $ds = new Am_Query($this->getDi()->helpdeskCategoryTable); $grid = new Am_Grid_ReadOnly('_helpdesk_category', ___('Categories'), $ds, $this->getRequest(), $this->view, $this->getDi()); $grid->addField('login', ___('Title'))->setRenderFunction(array($this, 'renderEditCategoryTitle')); $grid->setPermissionId(Bootstrap_Helpdesk::ADMIN_PERM_ID); $grid->isAjax($this->isAjax() && $this->isGridRequest('_helpdesk_category')); echo $grid->run(); }
function payoutDetailAction() { $ds = new Am_Query($this->getDi()->affCommissionTable); $ds->leftJoin('?_invoice', 'i', 'i.invoice_id=t.invoice_id'); $ds->leftJoin('?_user', 'u', 'u.user_id=i.user_id'); $ds->leftJoin('?_product', 'p', 't.product_id=p.product_id'); $ds->addField('u.user_id', 'user_id')->addField('CONCAT(u.login, \' (\',u.name_f, \' \',u.name_l,\') [#\', u.user_id, \'] \')', 'user_name')->addField('u.email', 'user_email')->addField('p.title', 'product_title'); $ds->addWhere('t.aff_id=?', $this->user_id); $ds->addWhere('payout_detail_id=?', $this->getParam('payout_detail_id')); $ds->setOrder('commission_id', 'desc'); $grid = new Am_Grid_ReadOnly('_affcomm', ___('Affiliate Commission'), $ds, $this->_request, $this->view); $grid->setPermissionId(Bootstrap_Aff::ADMIN_PERM_ID); $grid->setCountPerPage(10); $userUrl = new Am_View_Helper_UserUrl(); $grid->addField(new Am_Grid_Field_Date('date', ___('Date')))->setFormatDate(); $grid->addField('user_name', ___('User'))->addDecorator(new Am_Grid_Field_Decorator_Link($userUrl->userUrl('{user_id}'), '_top')); $grid->addField('product_title', ___('Product')); $grid->addField('record_type', ___('Type'))->setRenderFunction(array($this, 'renderType')); $fieldAmount = $grid->addField('amount', ___('Commission'))->setRenderFunction(array($this, 'renderCommAmount')); $grid->addField('tier', ___('Tier'))->setRenderFunction(array($this, 'renderTier')); $grid->addCallback(Am_Grid_ReadOnly::CB_TR_ATTRIBS, array($this, 'commCbGetTrAttribs')); $grid->runWithLayout('admin/user-layout.phtml'); }
protected function createDetailGrid($date) { // public $textNoRecordsFound = "No rebills today - most possible cron job was not running."; $q = new Am_Query($this->getDi()->ccRebillTable); $q->addWhere('t.rebill_date=?', $date); $q->leftJoin('?_invoice', 'i', 'i.invoice_id=t.invoice_id'); $q->addField('i.public_id', 'public_id'); $q->addField('i.user_id', 'user_id'); $grid = new Am_Grid_ReadOnly('_r_d', ___('Detailed Rebill Report for %s', amDate($date)), $q, $this->_request, $this->view); $grid->setPermissionId('cc'); $grid->addField(new Am_Grid_Field_Date('tm_added', 'Started', true)); $grid->addField(new Am_Grid_Field('invoice_id', 'Invoice#', true, '', array($this, 'renderInvoiceLink'))); $grid->addField(new Am_Grid_Field_Date('rebill_date', 'Date', true))->setFormatDate(); $grid->addField('status', 'Status', true)->setFormatFunction(array('CcRebill', 'getStatusText')); $grid->addField('status_msg', 'Message'); $grid->setCountPerPage(10); return $grid; }
public function createLeadsGrid() { $ds = new Am_Query($this->getDi()->affLeadTable); $ds->leftJoin('?_user', 'a', 't.aff_id=a.user_id'); $ds->addField('CONCAT(a.login, \' (\', a.name_f, \' \', a.name_l,\') [#\', a.user_id, \']\')', 'aff_name'); $ds->leftJoin('?_aff_banner', 'b', 't.banner_id=b.banner_id'); $ds->addField('b.title', 'banner'); $ds->leftJoin('?_user', 'u', 'u.user_id=t.user_id'); $ds->addField('CONCAT(u.login, \' (\',u.name_f, \' \',u.name_l,\') [#\', u.user_id, \']\')', 'user_name')->addField('u.email', 'user_email'); $grid = new Am_Grid_ReadOnly('_affclicks', ___('Leads'), $ds, $this->_request, $this->view); $grid->setPermissionId(Bootstrap_Aff::ADMIN_PERM_ID); $userUrl = new Am_View_Helper_UserUrl(); $grid->addField('aff_name', ___('Affiliate'))->addDecorator(new Am_Grid_Field_Decorator_Link($userUrl->userUrl('{aff_id}'), '_top')); $grid->addField('user_name', ___('User'))->addDecorator(new Am_Grid_Field_Decorator_Link($userUrl->userUrl('{user_id}'), '_top')); $grid->addField('banner', ___('Banner'))->setRenderFunction(array($this, 'renderBanner')); $grid->addField('time', ___('Date/Time'))->setFormatFunction('amDateTime'); $grid->addField('first_visited', ___('First visited'))->setFormatFunction('amDateTime'); $grid->setFilter(new Am_Grid_Filter_Leads()); return $grid; }
protected function createDetailGrid($date) { // public $textNoRecordsFound = "No rebills today - most possible cron job was not running."; $q = new Am_Query($this->getDi()->ccRebillTable); $q->addWhere('rebill_date=?', $date); $grid = new Am_Grid_ReadOnly('_dd', "Detailed Rebill Report For [{$date}]", $q, $this->_request, $this->view); $grid->setPermissionId('cc'); $grid->addField(new Am_Grid_Field_Date('tm_added', 'Started', true)); $grid->addField('invoice_id', 'Invoice#', true); $grid->addField(new Am_Grid_Field_Date('rebill_date', 'Date', true))->setFormatDate(); $grid->addField('status', 'Status', true)->setFormatFunction(array('CcRebill', 'getStatusText')); $grid->addField('status_msg', 'Message'); return $grid; }
public function createLeadsGrid() { $ds = new Am_Query($this->getDi()->affLeadTable); $ds->leftJoin('?_user', 'a', 't.aff_id=a.user_id'); $ds->addField('CONCAT(a.name_f, \' \', a.name_l)', 'aff_name'); $ds->leftJoin('?_aff_banner', 'b', 't.banner_id=b.banner_id'); $ds->addField('b.title', 'banner'); $ds->leftJoin('?_user', 'u', 'u.user_id=t.user_id'); $ds->addField('CONCAT(u.name_f, \' \',u.name_l)', 'user_name')->addField('u.email', 'user_email'); $grid = new Am_Grid_ReadOnly('_affclicks', ___("Leads"), $ds, $this->_request, $this->view); $grid->setPermissionId('affiliates'); $userUrl = new Am_View_Helper_UserUrl(); $grid->addField('aff_name', ___('Affiliate'))->addDecorator(new Am_Grid_Field_Decorator_Link($userUrl->userUrl('{aff_id}'), '_blank')); $grid->addField('user_name', ___('User'))->addDecorator(new Am_Grid_Field_Decorator_Link($userUrl->userUrl('{user_id}'), '_blank')); $grid->addField('banner', ___('Banner')); $grid->addField('time', ___('Time'))->setFormatFunction('amDateTime'); $grid->addField('first_visited', ___('First visited'))->setFormatFunction('amDateTime'); return $grid; }