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;
}
