setJsOptions($jsOptions);
$upload_id->addRule('required');
$size = $form->addElement('group', 'size')
->setLabel(___("Size\nWidth × Height"));
$size->setSeparator(' × ');
$width = $size->addElement('text', 'width', array('size' => 4));
$height = $size->addElement('text', 'height', array('size' => 4));
}
function valuesFromForm()
{
$values = parent::valuesFromForm();
$values['height'] = $values['size']['height'];
$values['width'] = $values['size']['width'];
unset($values['size']);
return $values;
}
function valuesToForm()
{
$values = parent::valuesToForm();
$values['size']['height'] = @$values['height'];
$values['size']['width'] = @$values['width'];
return $values;
}
}
class Am_Grid_Editable_TextLinks extends Am_Grid_Editable_AffBannersAbstract
{
protected $affBannerType = AffBanner::TYPE_TEXTLINK;
protected function getGridTitle()
{
return ___('Text Links');
}
protected function _initForm($form) {}
}
class Am_Grid_Editable_Custom extends Am_Grid_Editable_AffBannersAbstract
{
protected $affBannerType = AffBanner::TYPE_CUSTOM;
protected function getGridTitle()
{
return ___('Custom HTML');
}
protected function _initForm($form)
{
$form->addTextarea('html', array('rows' => 10, 'class' => 'el-wide'))
->setLabel(___("HTML Code\n%url% will be replaced with actual url of affilate link"))
->addRule('required');
}
}
class Am_Grid_Editable_LightBoxes extends Am_Grid_Editable_AffBannersAbstract
{
protected $affBannerType = AffBanner::TYPE_LIGHTBOX;
protected function getGridTitle()
{
return ___('Light Boxes');
}
protected function _initForm($form)
{
$upload_id = $form->addElement(new Am_Form_Element_Upload('upload_id', array(), array('prefix' => 'banners')))
->setLabel(___('Lightbox Thumbnail Image'))
->setId('lightboxes-upload_id')
->setAllowedMimeTypes(array(
'image/png', 'image/jpeg', 'image/tiff', 'image/gif',
));
$upload_id->addRule('required');
$upload_big_id = $form->addElement(new Am_Form_Element_Upload('upload_big_id', array(), array('prefix' => 'banners')))
->setLabel(___('Lightbox Main Image'))
->setId('lightboxes-upload_big_id')
->setAllowedMimeTypes(array(
'image/png', 'image/jpeg', 'image/tiff', 'image/gif',
));
$upload_big_id->addRule('required');
}
function valuesFromForm()
{
$values = parent::valuesFromForm();
$values['height'] = $values['size']['height'];
$values['width'] = $values['size']['width'];
unset($values['size']);
return $values;
}
function valuesToForm()
{
$values = parent::valuesToForm();
$values['size']['height'] = @$values['height'];
$values['size']['width'] = @$values['width'];
return $values;
}
}
class Am_Grid_Editable_AffBannersAll extends Am_Grid_Editable
{
protected $permissionId = Bootstrap_Aff::ADMIN_PERM_ID;
public function __construct(Am_Mvc_Request $request, Am_View $view)
{
$id = explode('_', get_class($this));
$id = strtolower(array_pop($id));
parent::__construct('_' . $id, $this->getGridTitle(), $this->createDs(), $request, $view);
}
public function initActions()
{
$this->actionAdd(new Am_Grid_Action_AffBannersAllEdit('edit', ___('Edit')));
$this->actionAdd(new Am_Grid_Action_Delete);
$this->actionAdd(new Am_Grid_Action_Sort_AffBanners());
}
function renderUGroup($b)
{
$res = array();
$options = $this->getDi()->userGroupTable->getSelectOptions();
foreach (explode(',', $b->user_group_id) as $ug_id) {
if (isset($options[$ug_id]))
$res[] = $options[$ug_id];
}
return $this->renderTd($res ? implode(", ", $res) : ___('All'));
}
protected function getGridTitle()
{
return ___('All Banners');
}
protected function initGridFields()
{
$this->addField(new Am_Grid_Field_Enum('type', ___('Type'), true))
->setTranslations(array(
AffBanner::TYPE_TEXTLINK => ___('Text Link'),
AffBanner::TYPE_BANNER => ___('Banner'),
AffBanner::TYPE_PAGEPEEL => ___('Page Peel'),
AffBanner::TYPE_LIGHTBOX => ___('Light Box'),
AffBanner::TYPE_CUSTOM => ___('Custom HTML')
));
$this->addField(new Am_Grid_Field('title', ___('Title'), true, '', null, '25%'));
$this->addField(new Am_Grid_Field('url', ___('URL'), true, '', null, '35%'));
$this->addField(new Am_Grid_Field('category', ___('Category'), true));
$this->addField(new Am_Grid_Field('available', ___('Available'), false))->setRenderFunction(array($this, 'renderUGroup'));
$this->addField(new Am_Grid_Field_IsDisabled());
parent::initGridFields();
}
protected function createDs()
{
$query = new Am_Query(Am_Di::getInstance()->affBannerTable);
$query->setOrder('sort_order');
return $query;
}
}
class Am_Grid_Editable_AffBannersCategory extends Am_Grid_Editable
{
protected $permissionId = Bootstrap_Aff::ADMIN_PERM_ID;
public function __construct(Am_Mvc_Request $request, Am_View $view)
{
$id = explode('_', get_class($this));
$id = strtolower(array_pop($id));
parent::__construct('_' . $id, $this->getGridTitle(), $this->createDs(), $request, $view);
}
public function initActions()
{
$this->actionAdd(new Am_Grid_Action_LiveEdit('name'));
}
protected function getGridTitle()
{
return ___('Banner Categories');
}
protected function initGridFields()
{
$this->addField(new Am_Grid_Field('name', ___('Title')));
parent::initGridFields();
}
protected function createDs()
{
$ret = array();
foreach (Am_Di::getInstance()->affBannerTable->getCategories() as $category) {
$cat = new stdClass();
$cat->name = $category;
$ret[] = $cat;
}
return new Am_Grid_DataSource_AffBannerCategory($ret);
}
}
class Am_Grid_DataSource_AffBannerCategory extends Am_Grid_DataSource_Array
{
public function updateRecord($record, $valuesFromForm)
{
Am_Di::getInstance()->db->query('UPDATE ?_aff_banner SET category=? WHERE category=?',
$valuesFromForm['name'],
$record->name);
}
}
class Am_Grid_Action_Upload extends Am_Grid_Action_Abstract
{
protected $type = self::NORECORD;
public function __construct($id = null, $title = null)
{
$this->title = ___('Upload');
parent::__construct($id, $title);
}
public function run()
{
$form = $this->grid->getForm();
$form->setAttribute('target', '_top');
$upload = new Am_Upload(Am_Di::getInstance());
$upload->setPrefix($this->grid->getCompleteRequest()->getParam('prefix'));
$upload->loadFromStored();
$ids_before = $this->getUploadIds($upload);
if ($form->isSubmitted() && $upload->processSubmit('upload')) {
//find currently uploaded file
$upload_id = array_pop(array_diff($this->getUploadIds($upload), $ids_before));
$upload = Am_Di::getInstance()->uploadTable->load($upload_id);
$upload->desc = $this->grid->getCompleteRequest()->getParam('desc');
$upload->save();
return $this->grid->redirectBack();
}
echo $this->renderTitle();
echo $form;
}
protected function getUploadIds(Am_Upload $upload)
{
$upload_ids = array();
foreach ($upload->getUploads() as $upload) {
$upload_ids[] = $upload->pk();
}
return $upload_ids;
}
}
class Am_Grid_Action_AffBannersAllEdit extends Am_Grid_Action_Abstract
{
protected $privilege = 'edit';
public function __construct($id, $title)
{
$this->id = $id;
$this->title = $title;
parent::__construct();
$this->setTarget('_top');
}
public function getUrl($record = null, $id = null)
{
$id = $record->pk();
switch ($record->type) {
case AffBanner::TYPE_TEXTLINK:
$prefix = 'textlinks';
break;
case AffBanner::TYPE_BANNER:
$prefix = 'banners';
break;
case AffBanner::TYPE_PAGEPEEL:
$prefix = 'pagepeel';
break;
case AffBanner::TYPE_LIGHTBOX:
$prefix = 'lightboxs';
break;
case AffBanner::TYPE_CUSTOM:
$prefix = 'custom';
break;
default:
throw new Am_Exception_InternalError(sprintf('Unknown banner type [%s] in %s::%s',
$record->type, __CLASS__, __METHOD__));
}
$back_url = Am_Html::escape($this->grid->getBackUrl());
return $this->grid->getDi()->url("aff/admin-banners/p/$prefix/index?_{$prefix}_a=edit&_{$prefix}_b=$back_url&_{$prefix}_id=$id", false);
}
public function run()
{
}
}
class Am_Grid_Action_Sort_AffBanners extends Am_Grid_Action_Sort_Abstract
{
protected function setSortBetween($item, $after, $before)
{
$this->_simpleSort(Am_Di::getInstance()->affBannerTable, $item, $after, $before);
}
}
class Aff_AdminGeneralLinkController extends Am_Mvc_Controller
{
public function checkAdminPermissions(Admin $admin)
{
return $admin->hasPermission(Bootstrap_Aff::ADMIN_PERM_ID);
}
function indexAction()
{
$form = $this->createForm();
$form->setDataSources(array($this->getRequest()));
if ($this->getRequest()->isPost() && $form->validate()) {
$v = $form->getValue();
$this->getDi()->config->saveValue('aff.general_link_url', $v['general_link_url']);
}
echo $form;
}
function createForm()
{
$form = new Am_Form_Admin('aff-general-link');
$form->addElement('text', 'general_link_url', array('class' => 'el-wide'))
->setLabel(___("General Affiliate Link Redirect URL\n" .
'It is url of landing page for default affiliate link (which does not related to any banner), ' .
'home page will be used if you keep it empty'))
->setValue($this->getDi()->config->get('aff.general_link_url', ''));
$form->addSaveButton();
return $form;
}
}
class Aff_AdminBannersController extends Am_Mvc_Controller_Pages
{
public function checkAdminPermissions(Admin $admin)
{
return $admin->hasPermission(Bootstrap_Aff::ADMIN_PERM_ID);
}
public function preDispatch()
{
parent::preDispatch();
$this->setActiveMenu('affiliates-banners');
}
public function initPages()
{
$this->addPage(array($this, 'createController'), 'general', ___('General Link'))
->addPage('Am_Grid_Editable_Banners', 'banners', ___('Banners'))
->addPage('Am_Grid_Editable_TextLinks', 'textlinks', ___('Text Links'))
//->addPage('Am_Grid_Editable_PagePeels', 'pagePeels', ___('Page Peels'))
->addPage('Am_Grid_Editable_LightBoxes', 'lightboxes', ___('Light Boxes'))
->addPage('Am_Grid_Editable_Custom', 'custom', ___('Custom HTML'))
->addPage('Am_Grid_Editable_AffBannersAll', 'all', ___('All Banners'))
->addPage('Am_Grid_Editable_AffBannersCategory', 'category', ___('Banner Categories'))
->addPage('Am_Grid_Editable_Downloads', 'downloads', ___('Marketing Materials'));
}
public function createController($id, $title, $grid)
{
return new Aff_AdminGeneralLinkController($grid->getRequest(), $grid->getResponse(), $this->_invokeArgs);
}
}PK \4 4 MemberController.phpnu [ getDi()->auth->requireLogin($this->getDi()->url('aff/member', null, false));
$this->user = $this->getDi()->user;
if (!$this->user->is_affiliate) {
//throw new Am_Exception_InputError("Sorry, this page is opened for affiliates only");
$this->_redirect('member');
}
}
function indexAction()
{
$this->_redirect('aff/aff');
}
function statsAction()
{
class_exists('Am_Report_Standard', true);
include_once AM_APPLICATION_PATH . '/aff/library/Reports.php';
if ($this->getDi()->config->get('aff.affiliate_can_view_details') && $detailDate = $this->getFiltered('detailDate')) {
if (!preg_match('/^\d{4}-\d{2}-\d{2}$/', $detailDate))
throw new Am_Exception_InputError("Wrong date passed");
$c = 0;
foreach ($this->getDi()->affCommissionTable->fetchByDate($detailDate, $this->user->user_id) as $c) {
$c++;
$p = $c->getPayment();
if (!$p)
continue;
$u = $p->getUser();
$i = $p->getInvoice();
$product = $c->getProduct();
$s = sprintf('%s (%s) – %s %s', $this->escape($u->name_f . ' ' . $u->name_l),
___($product->title), Am_Currency::render($c->amount),
($c->tier ? sprintf(' (%d-tier)', $c->tier+1) : ''));
if ($c->record_type == AffCommission::VOID)
$s = "$s (void)
";
echo $s . "". Am_Currency::render($record->sales_amount)." ";
}
);
$grid->runWithLayout('aff/keywords.phtml');
}
}PK \TMLְ AffPayoutsController.phpnu [ array('class' => 'Aff_AffPayoutDetailsController', 'file' => 'aff/controllers/AffPayoutDetailsController.php'),
);
protected $_defaultNested = array(
'aff-payout-details'
);
public function createTable()
{
return $this->getDi()->affPayoutTable;
}
}
PK \i}u u ! AdminCommissionRuleController.phpnu [ getDi()->affCommissionRuleTable->getMaxTier();
$next_tier = ++$max_tier;
$comm = $this->getDi()->affCommissionRuleRecord;
$comm->tier = $next_tier;
$comm->type = AffCommissionRule::TYPE_GLOBAL;
$comm->sort_order = ($next_tier + 1) * 10000;
$comm->comment = ($next_tier + 1) . '-Tier Affiliates Commission';
$comm->save();
$this->grid->redirectBack();
}
/**
* @return Am_Di
*/
protected function getDi()
{
return $this->grid->getDi();
}
}
class Am_Grid_Action_RemoveLastTier extends Am_Grid_Action_Abstract
{
protected $type = Am_Grid_Action_Abstract::NORECORD;
protected $title = 'Remove Last Tier';
public function run()
{
$max_tier = $this->getDi()->affCommissionRuleTable->getMaxTier();
if ($max_tier) {
$this->getDi()->affCommissionRuleTable->findFirstByTier($max_tier)->delete();
}
$this->grid->redirectBack();
}
/**
*
* @return Am_Di
*/
protected function getDi()
{
return $this->grid->getDi();
}
}
class Am_Grid_Action_TestAffCommissionRule extends Am_Grid_Action_Abstract
{
protected $type = Am_Grid_Action_Abstract::NORECORD;
protected $title = 'Test Commission Rules';
protected $cssClass = 'link';
public function run()
{
$f = $this->createForm();
$f->setDataSources(array($this->grid->getCompleteRequest()));
echo $this->renderTitle();
if ($f->isSubmitted() && $f->validate() && $this->process($f))
return;
echo $f;
}
function process(Am_Form $f)
{
$vars = $f->getValue();
$user = Am_Di::getInstance()->userTable->findFirstByLogin($vars['user']);
if (!$user) {
list($el) = $f->getElementsByName('user');
$el->setError(___('User %s not found', $vars['user']));
return false;
}
$aff = Am_Di::getInstance()->userTable->findFirstByLogin($vars['aff']);
if (!$aff) {
list($el) = $f->getElementsByName('aff');
$el->setError(___('Affiliate %s not found', $vars['user']));
return false;
}
$couponAff = null;
if ($vars['coupon']) {
$coupon = Am_DI::getInstance()->couponTable->findFirstByCode($vars['coupon']);
if ($coupon && ($coupon->aff_id || $coupon->getBatch()->aff_id)) {
$couponAff = Am_Di::getInstance()->userTable->load($coupon->aff_id ? $coupon->aff_id : $coupon->getBatch()->aff_id, false);
}
}
/* @var $invoice Invoice */
$invoice = Am_Di::getInstance()->invoiceTable->createRecord();
$invoice->setUser($user);
if ($vars['coupon']) {
$invoice->setCouponCode($vars['coupon']);
$error = $invoice->validateCoupon();
if ($error) throw new Am_Exception_InputError($error);
}
$user->aff_id = $aff->pk();
foreach ($vars['product_id'] as $plan_id => $qty)
{
$p = Am_Di::getInstance()->billingPlanTable->load($plan_id);
$pr = $p->getProduct();
$invoice->add($pr, $qty);
}
$invoice->calculate();
$invoice->setPaysystem($vars['paysys_id'], false);
$invoice->invoice_id = '00000';
$invoice->public_id = 'TEST';
$invoice->tm_added = sqlTime('now');
echo "";
echo $invoice->render();
echo
"\nBilling Terms: " . $invoice->getTerms() .
"\n".str_repeat("-", 70)."\n";
$helper = new Am_View_Helper_UserUrl();
$helper->setView(new Am_View);
printf("User Ordering the subscription: %d/%s "%s" <%s> \n",
$helper->userUrl($user->pk()),
$user->pk(), Am_Html::escape($user->login),
Am_Html::escape($user->name_f . ' ' . $user->name_l),
Am_Html::escape($user->email));
printf("Reffered Affiliate: %d/%s "%s" <%s> \n",
$helper->userUrl($aff->pk()),
$aff->pk(),
Am_Html::escape($aff->login),
Am_Html::escape($aff->name_f . ' ' . $aff->name_l),
Am_Html::escape($aff->email));
if ($couponAff) {
printf("Affiliate Detected by Coupon (will get commision): %d/%s "%s" <%s> \n",
$helper->userUrl($couponAff->pk()),
$couponAff->pk(),
Am_Html::escape($couponAff->login),
Am_Html::escape($couponAff->name_f . ' ' . $couponAff->name_l),
Am_Html::escape($couponAff->email));
}
$max_tier = Am_Di::getInstance()->affCommissionRuleTable->getMaxTier();
//COMMISSION FOR FREE SIGNUP
if (!(float)$invoice->first_total
&& !(float)$invoice->second_total
&& $vars['is_first']) {
echo "\nFREE SIGNUP :\n";
list($item,) = $invoice->getItems();
echo sprintf("* ITEM: %s\n", Am_Html::escape($item->item_title));
foreach (Am_Di::getInstance()->affCommissionRuleTable->findRules($invoice, $item, $aff, 0, 0) as $rule)
{
echo $rule->render('* ');
}
$to_pay = Am_Di::getInstance()->affCommissionRuleTable->calculate($invoice, $item, $aff, 0, 0);
echo "* AFFILIATE WILL GET FOR THIS ITEM: " . Am_Currency::render($to_pay) . "\n";
for ($i=1; $i<=$max_tier; $i++) {
$to_pay = Am_Di::getInstance()->affCommissionRuleTable->calculate($invoice, $item, $aff, 0, $i, $to_pay);
$tier = $i+1;
echo "* $tier-TIER AFFILIATE WILL GET FOR THIS ITEM: " . Am_Currency::render($to_pay) . "\n";
}
echo str_repeat("-", 70) . "\n";
}
//COMMISSION FOR FIRST PAYMENT
$price_field = (float)$invoice->first_total ? 'first_total' : 'second_total';
if ((float)($invoice->$price_field)) {
echo "\nFIRST PAYMENT ($invoice->currency {$invoice->$price_field}) :\n";
$payment = Am_Di::getInstance()->invoicePaymentTable->createRecord();
$payment->invoice_id = @$invoice->invoice_id;
$payment->dattm = sqlTime('now');
$payment->amount = $invoice->$price_field;
echo str_repeat("-", 70) . "\n";
foreach ($invoice->getItems() as $item)
{
if (!(float)($item->$price_field)) continue; //do not calculate commission for free items within invoice
echo sprintf("* ITEM: %s ($invoice->currency {$item->$price_field})\n", Am_Html::escape($item->item_title));
foreach (Am_Di::getInstance()->affCommissionRuleTable->findRules($invoice, $item, $aff, 1, 0, $payment->dattm) as $rule)
{
echo $rule->render('* ');
}
$to_pay = Am_Di::getInstance()->affCommissionRuleTable->calculate($invoice, $item, $aff, 1, 0, $payment->amount, $payment->dattm);
echo "* AFFILIATE WILL GET FOR THIS ITEM: " . Am_Currency::render($to_pay) . " \n";
for ($i=1; $i<=$max_tier; $i++) {
$to_pay = Am_Di::getInstance()->affCommissionRuleTable->calculate($invoice, $item, $aff, 1, $i, $to_pay, $payment->dattm);
$tier = $i+1;
echo "* $tier-TIER AFFILIATE WILL GET FOR THIS ITEM: " . Am_Currency::render($to_pay) . " \n";
}
echo str_repeat("-", 70) . "\n";
}
}
//COMMISSION FOR SECOND AND SUBSEQUENT PAYMENTS
if ((float)$invoice->second_total)
{
echo "\nSECOND AND SUBSEQUENT PAYMENTS ($invoice->second_total $invoice->currency) :\n";
$payment = Am_Di::getInstance()->invoicePaymentTable->createRecord();
$payment->invoice_id = @$invoice->invoice_id;
$payment->dattm = sqlTime('now');
$payment->amount = $invoice->second_total;
echo str_repeat("-", 70) . "\n";
foreach ($invoice->getItems() as $item)
{
if (!(float)$item->second_total) continue; //do not calculate commission for free items within invoice
echo sprintf("* ITEM: %s ($item->second_total $invoice->currency)\n", Am_Html::escape($item->item_title));
foreach (Am_Di::getInstance()->affCommissionRuleTable->findRules($invoice, $item, $aff, 2, 0, $payment->dattm) as $rule)
{
echo $rule->render('* ');
}
$to_pay = Am_Di::getInstance()->affCommissionRuleTable->calculate($invoice, $item, $aff, 2, 0, $payment->amount, $payment->dattm);
echo "* AFFILIATE WILL GET FOR THIS ITEM: " . Am_Currency::render($to_pay) . " \n";
for ($i=1; $i<=$max_tier; $i++) {
$to_pay = Am_Di::getInstance()->affCommissionRuleTable->calculate($invoice, $item, $aff, 2, $i, $to_pay, $payment->dattm);
$tier = $i+1;
echo "* $tier-TIER AFFILIATE WILL GET FOR THIS ITEM: " . Am_Currency::render($to_pay) . " \n";
}
echo str_repeat("-", 70) . "\n";
}
}
echo " ";
return true;
}
protected function createForm()
{
$f = new Am_Form_Admin;
$f->addText('user')->setLabel('Enter username of existing user')
->addRule('required', 'This field is required');
$f->addText('aff')->setLabel('Enter username of existing affiliate')
->addRule('required', 'This field is required');
$f->addText('coupon')->setLabel('Enter coupon code or leave field empty');
$f->addCheckbox('is_first')->setLabel('Is first user invoice?');
$f->addElement(new Am_Form_Element_ProductsWithQty('product_id'))
->setLabel(___('Choose products to include into test invoice'))
->loadOptions(Am_Di::getInstance()->billingPlanTable->selectAllSorted())
->addRule('required');
$f->addSelect('paysys_id')
->setLabel(___('Payment System'))
->loadOptions(Am_Di::getInstance()->paysystemList->getOptions());
$f->addSubmit('', array('value' => 'Test'));
$f->addScript()->setScript(<<grid->getVariablesList() as $k)
{
$kk = $this->grid->getId() . '_' . $k;
if ($v = @$_REQUEST[$kk])
$f->addHidden($kk)->setValue($v);
}
return $f;
}
}
class Am_Grid_Editable_AffCommissionRule extends Am_Grid_Editable
{
protected $permissionId = Bootstrap_Aff::ADMIN_PERM_ID;
public function renderTable()
{
$url = $this->getDi()->url('admin-setup/aff');
return parent::renderTable() .
___('For each item in purchase, aMember will look through all rules, from top to bottom. ' .
'If it finds a matching multiplier, it will be remembered. ' .
'If it finds a matching custom rule, it takes commission rates from it. ' .
'If no matching custom rule was found, it uses "Default" commission settings.
' .
'For n-tier affiliates, no rules are used, you can just define percentage of commission earned by previous level.
') .
'' . ___('Check other Affiliate Program Settings') . '
';
}
public function __construct(Am_Mvc_Request $request, Am_View $view)
{
parent::__construct('_affcommconf',
___('Affiliate Commission Rules'), Am_Di::getInstance()->affCommissionRuleTable->createQuery(),
$request, $view);
$this->setEventId('gridAffCommissionRule');
$this->setRecordTitle('Commission Rule');
$this->addField('comment', 'Comment')->setRenderFunction(array($this, 'renderComment'));
$this->addField('sort_order', 'Sort')->setRenderFunction(array($this, 'renderSort'));
$this->addField('_commission', 'Commission', false)->setRenderFunction(array($this, 'renderCommission'));
$this->addField('_conditions', 'Conditions', false)->setRenderFunction(array($this, 'renderConditions'));
$this->actionGet('edit')->setTarget('_top');
$this->actionGet('insert')->setTitle('New Custom %s')->setTarget('_top');
$this->actionAdd(new Am_Grid_Action_AddTier());
if ($this->getDi()->affCommissionRuleTable->getMaxTier()) {
$this->actionAdd(new Am_Grid_Action_RemoveLastTier());
}
$this->actionAdd(new Am_Grid_Action_TestAffCommissionRule());
$this->setForm(array($this,'createConfigForm'));
$this->addCallback(Am_Grid_Editable::CB_VALUES_TO_FORM, array($this, '_valuesToForm'));
$this->addCallback(Am_Grid_Editable::CB_VALUES_FROM_FORM, array($this, '_valuesFromForm'));
}
public function renderSort(AffCommissionRule $rule)
{
$v = $rule->isGlobal() ? '-' : $rule->sort_order;
return $this->renderTd($v);
}
public function renderCommission(AffCommissionRule $rule, $fieldName)
{
return $this->renderTd($rule->renderCommission(), false);
}
public function renderConditions(AffCommissionRule $rule, $fieldName)
{
return $this->renderTd($rule->renderConditions(), true);
}
public function renderComment(AffCommissionRule $rule)
{
if ($rule->isGlobal())
$text = ''.$rule->comment.' ';
else
$text = $this->escape($rule->comment);
return "$text \n";
}
public function _valuesToForm(& $values, AffCommissionRule $record)
{
$values['_conditions'] = json_decode(@$values['conditions'], true);
foreach ((array)$values['_conditions'] as $k => $v) {
$values['_conditions_status'][$k] = 1; //enabled
}
}
public function _valuesFromForm(& $values, AffCommissionRule $record)
{
$values['free_signup_t'] = '$';
$conditions = array();
foreach ($values['_conditions_status'] as $k => $v) {
if ($v) {
$conditions[$k] = $values['_conditions'][$k];
}
}
$this->cleanUpConditions($conditions);
if (!empty($conditions)) {
$values['conditions'] = json_encode($conditions);
}
}
/**
* Remove incomplete conditions
*
* @param array $conditions
*/
protected function cleanUpConditions(& $conditions)
{
foreach ($conditions as $type => $vars) {
switch ($type) {
case AffCommissionRule::COND_PRODUCT_ID :
case AffCommissionRule::COND_PRODUCT_CATEGORY_ID :
case AffCommissionRule::COND_AFF_PRODUCT_ID :
case AffCommissionRule::COND_AFF_PRODUCT_CATEGORY_ID :
if (empty($vars)) unset($conditions[$type]);
break;
case AffCommissionRule::COND_AFF_SALES_AMOUNT:
case AffCommissionRule::COND_AFF_ITEMS_COUNT:
case AffCommissionRule::COND_AFF_SALES_COUNT:
if (empty($vars['count']) || empty($vars['days']))
unset($conditions[$type]);
break;
case AffCommissionRule::COND_COUPON :
if (($vars['type'] == 'batch' && !$vars['batch_id'])
|| ($vars['type'] == 'coupon' && !$vars['code']))
unset($conditions[$type]);
break;
}
}
}
public function createConfigForm(Am_Grid_Editable $grid)
{
$form = new Am_Form_Admin;
$record = $grid->getRecord($grid->getCurrentAction());
if (empty($record->type)) $record->type = null;
if (empty($record->tier)) $record->tier = 0;
$globalOptions = AffCommissionRule::getTypes();
($record->type && !isset($globalOptions[$record->type])) && $globalOptions[$record->type] = $record->getTypeTitle();
$cb = $form->addSelect('type')->setLabel('Type')->loadOptions($globalOptions);
if ($record->isGlobal())
$cb->toggleFrozen(true);
$form->addScript()->setScript(<<X ");
});
jQuery(document).on('click',"a.hide-row",function(){
var row = jQuery(this).closest(".row");
var id = row.hide().attr("id");
var val = /row-(.*)/i.exec(id).pop();
jQuery('input[name="_conditions_status[' + val + ']"]').val(0);
jQuery("#condition-select option[value='"+val+"']").prop("disabled", false);
});
jQuery('#used-type').change(function(){
jQuery('#used-batch_id, #used-code').hide();
switch (jQuery(this).val()) {
case 'batch' :
jQuery('#used-batch_id').show();
break;
case 'coupon' :
jQuery('#used-code').show();
break;
}
}).change()
});
CUT
);
$comment = $form->addText('comment', array('size' => 40))
->setLabel('Rule title - for your own reference');
if ($record->isGlobal()) {
$comment->toggleFrozen(true);
} else {
$comment->addRule('required', 'This field is required');
}
if (!$record->isGlobal())
$form->addInteger('sort_order')
->setLabel('Sort order - rules with lesser values executed first');
if (!$record->isGlobal()) // add conditions
{
$set = $form->addFieldset('', array('id'=>'conditions'))->setLabel('Conditions');
$set->addSelect('', array('id' => 'condition-select'))->setLabel('Add Condition')->loadOptions(array(
'' => ___('Select Condition...'),
___('User') => array(
'first_time' => ___('First Time Purchase of Product'),
'first_time_payment' => ___('First Time Purchase'),
),
___('Invoice') => array(
'coupon' => ___('By Used Coupon'),
'paysys_id' => ___('By Used Payment System'),
'product_id' => ___('By Product'),
'product_category_id' => ___('By Product Category'),
'not_product_id' => ___('Not Product'),
'not_product_category_id' => ___('Not Product Category'),
'upgrade' => ___('Upgrade Invoice'),
),
___('Affiliate') => array(
'aff_group_id' => ___('By Affiliate Group Id'),
'aff_sales_count' => ___('By Affiliate Sales Count'),
'aff_items_count' => ___('By Affiliate Item Sales Count'),
'aff_sales_amount' => ___('By Affiliate Sales Amount'),
'aff_product_id' => ___('By Affiliate Active Product'),
'aff_product_category_id' => ___('By Affiliate Active Product Category'),
)
));
$set->addHidden('_conditions_status[product_id]');
$set->addMagicSelect('_conditions[product_id]', array('id' => 'product_id'))
->setLabel(___("This rule is for particular products\n" .
'if none specified, rule works for all products'))
->loadOptions(Am_Di::getInstance()->productTable->getOptions());
$set->addHidden('_conditions_status[product_category_id]');
$el = $set->addMagicSelect('_conditions[product_category_id]', array('id' => 'product_category_id'))
->setLabel(___("This rule is for particular product categories\n" .
"if none specified, rule works for all product categories"));
$el->loadOptions(Am_Di::getInstance()->productCategoryTable->getAdminSelectOptions());
$set->addHidden('_conditions_status[not_product_id]');
$set->addMagicSelect('_conditions[not_product_id]', array('id' => 'not_product_id'))
->setLabel(___("Product is not\n" .
'if none specified, rule works for all products'))
->loadOptions(Am_Di::getInstance()->productTable->getOptions());
$set->addHidden('_conditions_status[not_product_category_id]');
$el = $set->addMagicSelect('_conditions[not_product_category_id]', array('id' => 'not_product_category_id'))
->setLabel(___("Product is not included to Category\n" .
"if none specified, rule works for all product categories"));
$el->loadOptions(Am_Di::getInstance()->productCategoryTable->getAdminSelectOptions());
$set->addHidden('_conditions_status[aff_group_id]');
$el = $set->addMagicSelect('_conditions[aff_group_id]', array('id' => 'aff_group_id'))
->setLabel(___("This rule is for particular affiliate groups\n" .
"you can add user groups and assign it to customers in User editing form"));
$el->loadOptions(Am_Di::getInstance()->userGroupTable->getSelectOptions());
$set->addHidden('_conditions_status[aff_sales_count]');
$gr = $set->addGroup('_conditions[aff_sales_count]', array('id' => 'aff_sales_count'))
->setLabel(___("Affiliate sales count\n" .
"trigger this commission if affiliate made more than ... sales within ... days before the current date\n" .
"(only count of new invoices is calculated)"
));
$gr->addStatic()->setContent('use only if affiliate referred ');
$gr->addInteger('count', array('size'=>4));
$gr->addStatic()->setContent(' invoices within last ');
$gr->addInteger('days', array('size'=>4));
$gr->addStatic()->setContent(' days');
$set->addHidden('_conditions_status[aff_items_count]');
$gr = $set->addGroup('_conditions[aff_items_count]', array('id' => 'aff_items_count'))
->setLabel(___("Affiliate items count\n" .
"trigger this commission if affiliate made more than ... item sales within ... days before the current date\n" .
"(only count of items in new invoices is calculated"
));
$gr->addStatic()->setContent('use only if affiliate made ');
$gr->addInteger('count', array('size'=>4));
$gr->addStatic()->setContent(' item sales within last ');
$gr->addInteger('days', array('size'=>4));
$gr->addStatic()->setContent(' days');
$set->addHidden('_conditions_status[aff_sales_amount]');
$gr = $set->addGroup('_conditions[aff_sales_amount]', array('id' => 'aff_sales_amount'))
->setLabel(___("Affiliate sales amount\n" .
"trigger this commission if affiliate made more than ... sales within ... days before the current date\n" .
"(only new invoices calculated)"
));
$gr->addStatic()->setContent('use only if affiliate made ');
$gr->addInteger('count', array('size'=>4));
$gr->addStatic()->setContent(' ' .Am_Currency::getDefault(). ' in total sales amount within last ');
$gr->addInteger('days', array('size'=>4));
$gr->addStatic()->setContent(' days');
$set->addHidden('_conditions_status[coupon]');
$gr = $set->addGroup('_conditions[coupon]', array('id' => 'coupon'))
->setLabel(___('Used coupon'));
$gr->setSeparator(' ');
$gr->addSelect('used')
->loadOptions(array(
'1' => 'Used',
'0' => "Didn't Use"
));
$gr->addSelect('type')
->setId('used-type')
->loadOptions(array(
'any' => ___('Any Coupon'),
'batch' => ___("Coupon From Batch"),
'coupon' => ___("Specific Coupon")
));
$gr->addSelect('batch_id')
->setId('used-batch_id')
->loadOptions(
$this->getDi()->couponBatchTable->getOptions()
);
$gr->addText('code', array('size'=>10))
->setId('used-code');
$set->addHidden('_conditions_status[paysys_id]');
$set->addMagicSelect('_conditions[paysys_id]', array('id' => 'paysys_id'))
->setLabel(___('This rule is for particular payment system'))
->loadOptions(Am_Di::getInstance()->paysystemList->getOptions());
$set->addHidden('_conditions_status[first_time]');
$set->addStatic('_conditions[first_time]', array('id' => 'first_time'))
->setLabel(___("First Time Purchase of Product"))
->setContent("✓
");
$set->addHidden('_conditions_status[first_time_payment]');
$set->addSelect('_conditions[first_time_payment]', array('id' => 'first_time_payment'))
->setLabel(___("First Time Purchase"))
->loadOptions(array(
0 => ___('No'),
1 => ___('Yes')
));
$set->addHidden('_conditions_status[upgrade]');
$set->addStatic('_conditions[upgrade]', array('id' => 'upgrade'))
->setLabel(___("Upgrade Invoice"))
->setContent("✓
");
$set->addHidden('_conditions_status[aff_product_id]');
$set->addMagicSelect('_conditions[aff_product_id]', array('id' => 'aff_product_id'))
->setLabel(___("Apply this rule if affiliate has active access to"))
->loadOptions(Am_Di::getInstance()->productTable->getOptions());
$set->addHidden('_conditions_status[aff_product_category_id]');
$el = $set->addMagicSelect('_conditions[aff_product_category_id]', array('id' => 'aff_product_category_id'))
->setLabel(___("Apply this rule if affiliate has active access to"));
$el->loadOptions(Am_Di::getInstance()->productCategoryTable->getAdminSelectOptions());
}
$set = $form->addFieldset('', array('id' => 'commission'))->setLabel('Commission');
if ($record->tier == 0)
{
$set->addElement(new Am_Form_Element_AffCommissionSize(null, null, 'first_payment'))
->setLabel(___("Commission for First Payment\ncalculated for first payment in each invoice"));
$set->addElement(new Am_Form_Element_AffCommissionSize(null, null, 'recurring'))
->setLabel(___("Commission for Rebills"));
$group = $set->addGroup('')
->setLabel(___("Commission for Free Signup\ncalculated for first customer invoice only"));
$group->addText('free_signup_c', array('size'=>5));
$group->addStatic()->setContent(' ' . Am_Currency::getDefault());
;//->addRule('gte', 'Value must be a valid number > 0, or empty (no text)', 0);
} else {
$set->addText('first_payment_c')
->setLabel(___("Commission\n% of commission received by referred affiliate"));
}
if (!$record->isGlobal())
{
$set = $form->addFieldset('', array('id' => 'multiplier'))->setLabel('Multipier');
$set->addText('multi', array('size' => 5, 'placeholder' => '1.0'))
->setLabel(___("Multiply commission calculated by the following rules\n" .
"to number specified in this field. To keep commission untouched, enter 1 or delete this rule"))
;//->addRule('gt', 'Values must be greater than 0.0', 0.0);
}
return $form;
}
}
class Aff_AdminCommissionRuleController extends Am_Mvc_Controller_Grid
{
public function checkAdminPermissions(Admin $admin)
{
return $admin->hasPermission(Bootstrap_Aff::ADMIN_PERM_ID);
}
public function createGrid()
{
return new Am_Grid_Editable_AffCommissionRule($this->getRequest(), $this->getView());
}
}PK \Gv9 9 AdminController.phpnu [ hasPermission(Bootstrap_Webhooks::ADMIN_PERM_ID);
}
function createGrid()
{
$ds = new Am_Query($this->getDi()->webhookTable);
$grid = new Am_Grid_Editable('_w', ___('Browse Webhooks'), $ds, $this->getRequest(), $this->getView(), $this->getDi());
$grid->setPermissionId(Bootstrap_Webhooks::ADMIN_PERM_ID);
$grid->addCallback(Am_Grid_ReadOnly::CB_TR_ATTRIBS, array($this, 'getTrAttribs'));
$grid->addField(new Am_Grid_Field('webhook_id', '#', true, '', null, '1%'));
$grid->addField('event_id', ___('Event'));
$grid->addField('url', ___('Url'));
$grid->setForm(array($this, 'createForm'));
$grid->setRecordTitle('WebHook');
$grid->addCallback(Am_Grid_Editable::CB_RENDER_CONTENT, function(& $out, Am_Grid_Editable $grid) {
$cron_url = $this->getDi()->url('webhooks/cron',null,true,2);
$out = '' . "It is required to setup a cron job to run each minute to trigger sending of webhooks
* * * * * /usr/bin/curl $cron_url " . '
');
$js_ = '';
foreach ($this->getModule()->getTypes() as $k => $v)
{
$desc = array($v['title']);
if(isset($v['description']))
$desc[] = $v['description'];
$params = array();
if(!is_array($v['params']))
$params = array($v['params']);
else
$params = $v['params'];
if(isset($v['nested']))
{
if(!is_array($v['nested']))
$params = array_merge($params,array($v['nested']));
else
$params = array_merge($params,$v['nested']);
}
$desc[] = 'List of parameters:['.implode(',', $params).']';
$js_.="webhooksCache.{$k} = '". implode('
var webhooksCache = {"" : {} };
$js_
jQuery(document).ready(function($) {
function onWebhookChange() {
$("#webhook_info").html(webhooksCache[$(this).val()]);
}
$("#$id_").change(onWebhookChange);
});
EOF
);
$form->addText('url',array('class'=>'el-wide'))->setLabel(___("Url\n" .
'url of the page POST data will be sent to'))->addRule('required');
$form->addAdvcheckbox('is_disabled')->setLabel(___('Is Disabled?'));
return $form;
}
}
PK \ ClickJsController.phpnu [ getParam('r'));
if (is_numeric($id)) {
$aff = $this->getDi()->userTable->load($id, false);
if ($aff) return $aff;
}
if (strlen($id)) {
$aff = $this->getDi()->userTable->findFirstByLogin($id);
if ($aff) return $aff;
}
return null;
}
function findKeyword()
{
if($keyword = $this->getParam('keyword'))
{
return substr($keyword, 0, Bootstrap_Aff::KEYWORD_MAX_LEN);
}
return null;
}
function indexAction(){
if(!Am_Di::getInstance()->config->get('aff.tracking_code'))
{
$this->log('Click logging disabled in config');
}
elseif ($this->aff = $this->findAff())
{
$keyword = $this->findKeyword();
$aff_click_id = $this->getDi()->affClickTable->log($this->aff, null, $this->getParam('s'), $this->getModule()->findKeywordId($this->aff->pk(), $keyword));
$this->getModule()->setCookie($this->aff, null, $aff_click_id);
$this->log('Click Logged');
}
}
function log($text){
if (constant('AM_APPLICATION_ENV') != 'debug') return;
echo 'console.log("'.$text.'")';
}
}
PK \s Q$ Q$ AdminConvertController.phpnu [ isSuper();
}
/**
*
* @return Am_Crypt
*/
function getCurrentCryptObject()
{
$cname = $this->getDi()->getCryptClass();
return (new $cname);
}
/**
*
* @return Am_Crypt
*/
function getOldCryptObject()
{
$crypt = $this->getCurrentCryptObject();
$oldCrypt = $crypt;
$oldSig = $oldCrypt->loadKeySignature();
$cname = Am_Crypt::getClassByMethod($oldSig);
if (get_class($oldCrypt) != $cname)
{
$oldCrypt = new $cname;
}
if ($oldCrypt->getKeySignature() != $oldSig)
{
// Now try to load old key file;
$path = APPLICATION_PATH . '/configs/key-old.php';
if (!file_exists($path))
throw new Am_Exception_Crypt_Key(___('Unable to find old keyfile. '
. 'Please upload it to %s '
. 'Then refresh page', $path)); // @todo comment
$key = include $path;
if (!strlen($key))
throw new Am_Exception_Crypt_Key('Key file has incorrect format or the key is empty'); // @todo comment
if ($key == 'REPLACE THIS STRING TO YOUR KEYSTRING')
throw new Am_Exception_Crypt_Key("You must define a valid key in the file [$path] instead of default");
$oldCrypt = new $cname($key);
}
return $oldCrypt;
}
function createBackup()
{
try
{
$this->getDi()->db->query("CREATE TABLE ?_cc_backup LIKE ?_cc");
$this->getDi()->db->query("INSERT INTO ?_cc_backup SELECT * FROM ?_cc");
$this->getDi()->db->query("CREATE TABLE ?_config_backup LIKE ?_config");
$this->getDi()->db->query("INSERT INTO ?_config_backup SELECT * FROM ?_config");
}
catch (Exception $ex)
{
$this->getDi()->errorLogTable->logException($ex);
throw new Am_Exception_InputError(
___('Unable to backup cc and config tables. '
. 'Check "aMember CP -> Error Log " for more info', $this->getDi()->url('admin-logs'))
);
}
}
function dropBackup()
{
try
{
$this->getDi()->db->query('DROP TABLE ?_config_backup');
$this->getDi()->db->query('DROP TABLE ?_cc_backup');
}
catch (Exception $ex)
{
$this->getDi()->errorLogTable->logException($ex);
throw new Am_Exception_InputError(
___('Unable to delete backup tables. '
. 'Please delete cc_backup and config_backup tables manually '
. 'Check "aMember CP -> Error Log " for more info ', $this->getDi()->url('admin-logs'))
);
}
}
function restoreBackup()
{
try
{
$this->getDi()->db->query('TRUNCATE TABLE ?_config');
$this->getDi()->db->query("INSERT INTO ?_config SELECT * FROM ?_config_backup");
$this->getDi()->db->query('TRUNCATE TABLE ?_cc');
$this->getDi()->db->query("INSERT INTO ?_cc SELECT * FROM ?_cc_backup");
}
catch (Exception $ex)
{
$this->getDi()->errorLogTable->logException($ex);
throw new Am_Exception_InputError(
___('Unable to restore back in cc_backup and config_backup tables'
. 'Please restore it manually. '
. 'Check "aMember CP -> Error Log " for more info ', $this->getDi()->url('admin-logs'))
);
}
}
function indexAction()
{
$crypt = $this->getCurrentCryptObject();
$oldCrypt = $this->getOldCryptObject();
$this->view->title = "Convert CC Database";
$startUrl = $this->getDi()->url('cc/admin-convert/do');
if (get_class($oldCrypt) != get_class($crypt))
{
$this->view->content = <<
Encryption method was changed. You have to encrypt database using new encryption method.
You must backup your database before you'll run this tool. GGI-Central is not responsible for any damage
this script may result to. If you have no backup saved, you may loose your data.
Encryption key file was changed. Please upload old key file to {$path} and re-encrypt CC table.
You must backup your database before you'll run this tool. GGI-Central is not responsible for any damage
this script may result to. If you have no backup saved, you may loose your data.
Key signature stored in database and key signature that was generated are equal. No further actions are required.
CUT;
}
$this->view->display('admin/layout.phtml');
}
function doAction()
{
$this->crypt = $this->getCurrentCryptObject();
$this->oldCrypt = $this->getOldCryptObject();
$this->context = $this->getParam('context');
if (!$this->context)
$this->createBackup();
$batch = new Am_BatchProcessor(array($this, 'doWork'));
$breaked = !$batch->run($this->context);
$breaked ? $this->convertRedirect() : $this->convertComplete();
}
function doWork(& $context, Am_BatchProcessor $batch)
{
$db = $this->getDi()->db;
try
{
$this->done = $db->selectCell("select count(*) from ?_cc where cc_idtotal = $db->selectCell("select count(*) from ?_cc");
$q = $db->queryResultOnly("SELECT * FROM ?_cc WHERE cc_id > ?d", (int) $context);
while ($r = $db->fetchRow($q))
{
$context = $r['cc_id'];
$ccRecord = $this->getDi()->CcRecordRecord;
$ccRecord->getTable()->setCrypt($this->oldCrypt);
$ccRecord->fromRow($r);
if (preg_match('/[^\s\d-]/', $ccRecord->cc_number)) {
throw new Am_Exception_InternalError(
"Problem with converting to new encryption key. "
. "cc record# {$ccRecord->cc_id} could not be converted, "
. "it seems the old key has been specified incorrectly. Conversion cancelled.");
return;
}
$ccRecord->getTable()->setCrypt($this->crypt);
$ccRecord->update();
$this->done++;
if (!$batch->checkLimits())
return;
}
}
catch (Exception $ex)
{
$this->getDi()->errorLogTable->logException($ex);
$this->restoreBackup();
$this->dropBackup();
throw new Am_Exception_InputError(
___('Got an error when attempting to re-encode CC record. '
. 'CC and config tables were restored from backup. '
. 'Check "aMember CP -> Error Log " for more info ', $this->getDi()->url('admin-logs'))
);
}
return true;
}
function convertRedirect()
{
$done = $this->done;
$total = $this->total;
$url = $this->getUrl('admin-convert', 'do', 'cc', array('context' => $this->context));
$text = $total > 0 ? (___('Converting CC info (%d from %d)', $done, $total) . '. ' . ___('Please wait')) :
___('Converting started');
$text .= '...';
$this->redirectHtml($url, $text, ___('Converting') . '...', false, $done, $total);
}
function convertComplete()
{
$this->crypt->saveKeySigunature();
$this->view->assign('title', ___('Done'));
ob_start();
print '';
print 'Records were re-encoded using new key/encryption method';
print '. ';
$url = $this->getUrl('admin-convert', 'index', 'cc');
print '
' . ___('Back') . '
");
}
public function renderStatus($obj, $fieldname, $grid, $field)
{
return $obj->{$fieldname} ?
$this->renderTd(sprintf('%d - %s ', $obj->{$fieldname}, Am_Currency::render($obj->{$fieldname . '_amt'})), false) :
$this->renderTd('');
}
protected function createAdapter()
{
$q = new Am_Query($this->getDi()->ccRebillTable);
$q->leftJoin('?_invoice', 'i', 't.invoice_id=i.invoice_id');
$q->clearFields();
$q->groupBy('rebill_date');
$q->addField('t.rebill_date');
$q->addField('(1)', 'is_log');
$q->addField('COUNT(t.rebill_date)', 'total');
$q->addField('SUM(i.second_total/i.base_currency_multi)', 'total_amt');
$q->addField('SUM(IF(t.status=0, 1, 0))', 'status_0');
$q->addField('SUM(IF(t.status=1, 1, 0))', 'status_1');
$q->addField('SUM(IF(t.status=2, 1, 0))', 'status_2');
$q->addField('SUM(IF(t.status=3, 1, 0))', 'status_3');
$q->addField('SUM(IF(t.status=4, 1, 0))', 'status_4');
$q->addField('SUM(IF(t.status=0, i.second_total/i.base_currency_multi, 0))', 'status_0_amt');
$q->addField('SUM(IF(t.status=1, i.second_total/i.base_currency_multi, 0))', 'status_1_amt');
$q->addField('SUM(IF(t.status=2, i.second_total/i.base_currency_multi, 0))', 'status_2_amt');
$q->addField('SUM(IF(t.status=3, i.second_total/i.base_currency_multi, 0))', 'status_3_amt');
$q->addField('SUM(IF(t.status=4, i.second_total/i.base_currency_multi, 0))', 'status_4_amt');
$u = new Am_Query($this->getDi()->invoiceTable, 'i');
$u->addWhere('i.paysys_id IN (?a)', array_merge(array('avoid-sql-error'), $this->getPlugins()));
$u->groupBy('rebill_date');
$u->clearFields()->addField('i.rebill_date');
$u->addField('(0)', 'is_log');
$u->addField('COUNT(i.invoice_id)', 'total');
$u->addField('SUM(i.second_total/i.base_currency_multi)', 'total_amt');
for ($i = 1; $i < 11; $i++)
$u->addField('(NULL)');
$u->leftJoin('?_cc_rebill', 't', 't.rebill_date=i.rebill_date');
$u->addWhere('i.rebill_date IS NOT NULL');
$u->addWhere('t.rebill_date IS NULL');
$q->addUnion($u);
$q->addOrder('rebill_date', true);
return $q;
}
public function createGrid()
{
$grid = new Am_Grid_ReadOnly('_r', 'Rebills by Date', $this->createAdapter(), $this->_request, $this->view);
$grid->setPermissionId('cc');
$grid->addField('rebill_date', 'Date')->setRenderFunction(array($this, 'renderDate'));
$grid->addField('status_0', 'Processing Not Finished')->setRenderFunction(array($this, 'renderStatus'));
$grid->addField('status_1', 'No CC Saved')->setRenderFunction(array($this, 'renderStatus'));
$grid->addField('status_2', 'Error')->setRenderFunction(array($this, 'renderStatus'));
$grid->addField('status_3', 'Success')->setRenderFunction(array($this, 'renderStatus'));
$grid->addField('status_4', 'Exception!')->setRenderFunction(array($this, 'renderStatus'));
$grid->addField('total', 'Total')->setRenderFunction(array($this, 'renderTotal'));
$grid->addField('_action', '')->setRenderFunction(array($this, 'renderLink'));
$grid->addCallback(Am_Grid_ReadOnly::CB_TR_ATTRIBS, array($this, 'getTrAttribs'));
return $grid;
}
public function getPlugins()
{
$this->getDi()->plugins_payment->loadEnabled();
$ret = array();
foreach ($this->getDi()->plugins_payment->getAllEnabled() as $ps)
if ($ps instanceof Am_Paysystem_CreditCard || $ps instanceof Am_Paysystem_Echeck)
$ret[] = $ps->getId();
return $ret;
}
public function renderDate(CcRebill $obj)
{
$raw = $obj->rebill_date;
$d = amDate($raw);
return $this->renderTd("$d%d - %s', $obj->total, Am_Currency::render($obj->total_amt)), false);
} else {
$url = $this->getDi()->url('default/admin-payments/p/invoices/index' , array(
'_invoice_filter' => array(
'datf' => 'rebill_date',
'dat1' => amDate($obj->rebill_date),
'dat2' => amDate($obj->rebill_date)
),
'_invoice_sort' => 'rebill_date'
));
return $this->renderTd(sprintf('%d - %s$iconRun ";
}
if ($obj->is_log) {
$iconDetail = $this->getDi()->view->icon('view', ___('Details'));
$linkDetail = "$iconDetail ";
}
}
return "$linkRun $linkDetail ";
}
public function renderInvoiceLink($record)
{
return 'user_id . "#invoice-" . $record->invoice_id) . '" target=_top >' . $record->invoice_id . '/' . $record->public_id . ' ');
div.load(amUrl("/cc/admin-rebills/detail?_r_d_date=") + date , function(){
div.dialog({
autoOpen: true
,width: 800
,buttons: {}
,closeOnEscape: true
,title: "$title_details"
,modal: true
,open: function(){
div.ngrid();
}
});
});
});
});
jQuery(function(){
jQuery(document).on('submit',"#run-form form", function(){
jQuery(this).ajaxSubmit({target: '#run-form'});
return false;
});
});
CUT;
}
public function createRunForm()
{
$form = new Am_Form;
$form->setAction($this->getUrl(null, 'run'));
$s = $form->addSelect('paysys_id')->setLabel(___('Choose a plugin'));
$s->addRule('required');
foreach ($this->getModule()->getPlugins() as $p)
$s->addOption($p->getTitle(), $p->getId());
$form->addDate('date')->setLabel(___('Run Rebill Manually'))->addRule('required');
$form->addHidden('back_url');
$form->addSubmit('run', array('value' => ___('Run')));
return $form;
}
public function detailAction()
{
$date = $this->getFiltered('_r_d_date');
if (!$date)
throw new Am_Exception_InputError('Wrong date');
$grid = $this->createDetailGrid($date);
$grid->isAjax(false);
$grid->runWithLayout('admin/layout.phtml');
}
protected function createDetailGrid($date)
{
$q = new Am_Query($this->getDi()->ccRebillTable);
$q->addWhere('t.rebill_date=?', $date);
$q->leftJoin('?_invoice', 'i', 'i.invoice_id=t.invoice_id');
$q->leftJoin('?_user', 'u', 'u.user_id=i.user_id');
$q->addField('i.public_id');
$q->addField('u.name_f');
$q->addField('u.name_l');
$q->addField('u.email');
$q->addField('i.user_id');
$q->addField('i.second_total');
$q->addField('i.currency');
$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('invoice_id', 'Invoice#', true, '', array($this, 'renderInvoiceLink'));
$grid->addField('user', 'User')->setRenderFunction(function($obj, $fieldname, $grid, $field){
return sprintf("%s %s (%s)> %s
', ___('Rebill Operation Completed for %s', amDate($value['date'])));
} else {
echo $form;
}
}
public function doRun($paysys_id, $date)
{
$this->getDi()->plugins_payment->load($paysys_id);
$p = $this->getDi()->plugins_payment->get($paysys_id);
// Delete all previous failed attempts for this date in order to rebill these invoices again.
$this->getDi()->db->query("
DELETE FROM ?_cc_rebill
WHERE rebill_date = ? AND paysys_id = ? AND status <> ?
", $date, $paysys_id, ccRebill::SUCCESS);
$p->ccRebill($date);
}
}PK \}0 AdminFieldsController.phpnu [ hasPermission(Bootstrap_Helpdesk::ADMIN_PERM_CATEGORY);
}
protected function getTable()
{
return $this->getDi()->helpdeskTicketTable;
}
public function createGrid()
{
$grid = parent::createGrid();
$grid->addCallback(Am_Grid_Editable::CB_AFTER_DELETE, array($this, 'afterDelete'));
$grid->setPermissionId(Bootstrap_Helpdesk::ADMIN_PERM_CATEGORY);
return $grid;
}
public function createForm()
{
$form = new Am_Form_Admin_CustomField_Ticket($this->grid->getRecord());
$form->setTable($this->getTable());
return $form;
}
public function afterDelete($record)
{
foreach ($this->getDi()->helpdeskCategoryTable->findBy(array()) as $c) {
$fields = $c->unserializeList($c->fields);
if (in_array($record->name, $fields)) {
$fields = array_diff($fields, array($record->name));
$c->fields = $c->serializeList($fields);
$c->save();
}
}
}
}PK \LEE AdminMyController.phpnu [ addWhere('t.owner_id=?d', Am_Di::getInstance()->authAdmin->getUserId());
$q->addWhere('t.status<>?', HelpdeskTicket::STATUS_CLOSED);
return $q;
}
public function getGridTitle()
{
return ___('Tickets Assigned to Me');
}
public function initGridFields()
{
parent::initGridFields();
$this->removeField('owner_id');
}
public function initActions()
{
parent::initActions();
$this->actionAdd(new Am_Grid_Action_Delete());
}
}
class Helpdesk_AdminMyController extends Am_Mvc_Controller_Pages
{
public function checkAdminPermissions(Admin $admin)
{
return $admin->hasPermission(Bootstrap_Helpdesk::ADMIN_PERM_ID);
}
function preDispatch()
{
$this->view->headLink()->appendStylesheet($this->view->_scriptCss('helpdesk-admin.css'));
$this->setActiveMenu('helpdesk-ticket-my');
parent::preDispatch();
}
public function initPages()
{
$this->addPage('Am_Helpdesk_Grid_My', 'index', ___('Tickets'))
->addPage(array($this, 'createController'), 'view', ___('Conversation'));
}
public function renderTabs()
{
return '';
}
public function createController($id, $title, $grid)
{
return new Am_Helpdesk_Controller($grid->getRequest(), $grid->getResponse(), $this->_invokeArgs);
}
}PK \'ʀ
FaqController.phpnu [ getModule()->getConfig('does_not_require_login')) {
$this->getDi()->auth->requireLogin($this->getDi()->url('helpdesk/faq',null,false,2));
}
$this->view->headLink()->appendStylesheet($this->view->_scriptCss('helpdesk-user.css'));
if ($this->getDi()->auth->getUser() && ($page = $this->getDi()->navigationUser->findOneBy('id', 'helpdesk-faq'))) {
$page->setActive(true);
}
parent::preDispatch();
}
public function indexAction()
{
$this->view->categories = $this->getDi()->helpdeskFaqTable->getCategories();
$this->view->catActive = $this->getParam('cat');
$this->view->faq = $this->getDi()->helpdeskFaqTable->findBy(array(
'category' => $this->getParam('cat', null)), null, null, 'sort_order');
if ($this->getParam('cat')) {
$this->view->getHelper('breadcrumbs')->setPath(array($this->getDi()->url('helpdesk/faq',null,false) => ___('FAQ')));
}
$this->view->display('helpdesk/faq.phtml');
}
public function itemAction()
{
$path = array($this->getDi()->url('helpdesk/faq',null,false) => ___('FAQ'));
$faq = $this->getDi()->helpdeskFaqTable->findFirstByTitle($this->getParam('title'));
if ($faq->category) {
$path[$this->getDi()->url('helpdesk/faq/c/' . urldecode($faq->category),null,false)] = $faq->category;
}
$this->view->getHelper('breadcrumbs')->setPath($path);
$this->view->faq = $faq;
$this->view->display('helpdesk/faq-item.phtml');
}
public function searchAction()
{
$result = $this->getDi()->db->selectPage($total, "SELECT * FROM ?_helpdesk_faq WHERE MATCH(`title`,`content`)
AGAINST (? IN NATURAL LANGUAGE MODE)
LIMIT 10", $this->getParam('q'));
$items = array();
foreach ($result as $row)
$items[] = $this->getDi()->helpdeskFaqTable->createRecord($row);
$this->view->items = $items;
$this->view->display('helpdesk/_search-result.phtml');
}
public function suggestAction()
{
$result = $this->getDi()->db->selectPage($total, "SELECT * FROM ?_helpdesk_faq WHERE MATCH(`title`,`content`)
AGAINST (? IN NATURAL LANGUAGE MODE)
LIMIT 10", $this->getParam('q'));
$items = array();
foreach ($result as $row)
$items[] = $this->getDi()->helpdeskFaqTable->createRecord($row);
$this->view->items = $items;
$this->view->display('helpdesk/_suggest.phtml');
}
}PK \-a AdminFaqController.phpnu [ helpdeskFaqTable->getCategories());
$catoptions = array_merge(array('' => ___('-- Without A Category --')), $catoptions);
$this->addSelect('category', array(),
array('intrinsic_validation' => false, 'options' => $catoptions))
->setLabel('Category');
$label_add_category = ___('add category');
$label_title_error = ___('Enter title for your new category');
$this->addScript()
->setScript(<< $label_add_category "));
jQuery("select[name='category']").change(function(){
jQuery(this).toggle(jQuery(this).find('option').length > 1);
}).change();
jQuery(document).on('click',"a#add-category", function(){
var ret = prompt("$label_title_error", "");
if (!ret) return;
var \$sel = jQuery("select#category").append(
jQuery("%s ',
$url, ___('link')), false);
}
}
class Am_Grid_Action_Sort_HelpdeskFaq extends Am_Grid_Action_Sort_Abstract
{
protected function setSortBetween($item, $after, $before)
{
$this->_simpleSort(Am_Di::getInstance()->helpdeskFaqTable, $item, $after, $before);
}
}PK \8 z AdminCategoryController.phpnu [ addText('title', array('size' => 40))
->setLabel(___('Title'));
$options = array();
foreach (Am_Di::getInstance()->adminTable->findBy() as $admin) {
$options[$admin->pk()] = sprintf('%s (%s %s)', $admin->login, $admin->name_f, $admin->name_l);
}
$this->addSelect('owner_id')
->setLabel(___("Owner\n".
'set the following admin as owner of ticket'))
->loadOptions(array('' => '') + $options);
$this->addMagicSelect('watcher_ids')
->setLabel(___("Watchers\n" .
'notify the following admins ' .
'about new messages in this category'))
->loadOptions($options);
$options = array();
foreach(Am_Di::getInstance()->helpdeskTicketTable->customFields()->getAll()
as $f) {
$options[$f->getName()] = $f->title;
}
$url = Am_Di::getInstance()->url('helpdesk/admin-fields');
$this->addSortableMagicSelect('fields')
->setLabel(___("Fields\n" .
"You can add new fields %shere%s",
'', ' '))
->loadOptions($options);
$this->addElement(new Am_Form_Element_ResourceAccess)
->setName('_access')
->setLabel(___("Access Permissions\n" .
'this category will be available only for users ' .
'with proper access permission'))
->setAttribute('without_free_without_login', 'true');
}
}
class Am_Grid_Action_Sort_HelpdeskCategory extends Am_Grid_Action_Sort_Abstract
{
protected function setSortBetween($item, $after, $before)
{
$this->_simpleSort(Am_Di::getInstance()->helpdeskCategoryTable, $item, $after, $before);
}
}
class Helpdesk_AdminCategoryController extends Am_Mvc_Controller_Grid
{
public function checkAdminPermissions(Admin $admin)
{
return $admin->hasPermission(Bootstrap_Helpdesk::ADMIN_PERM_CATEGORY);
}
public function preDispatch()
{
parent::preDispatch();
$this->view->headScript()->appendFile($this->view->_scriptJs("resourceaccess.js"));
}
public function createGrid()
{
$ds = new Am_Query($this->getDi()->helpdeskCategoryTable);
$ds->leftJoin('?_admin', 'a', 't.owner_id=a.admin_id')
->addField("CONCAT(a.login, ' (',a.name_f, ' ', a.name_l, ')')", 'owner');
$ds->setOrder('sort_order');
$grid = new Am_Grid_Editable('_helpdesk_category', ___("Ticket Categories"), $ds, $this->_request, $this->view);
$grid->addField(new Am_Grid_Field('title', ___('Title')));
$grid->addField(new Am_Grid_Field('fields', ___('Fields')))
->setGetFunction(function($r, $grid, $fieldname, $field){
return implode(', ', $r->unserializeList($r->{$fieldname}));
});
$grid->addField(new Am_Grid_Field('owner_id', ___('Owner'), true, '', array($this, 'renderOwner')));
$grid->addField(new Am_Grid_Field_IsDisabled);
$grid->setForm('Am_Form_Admin_HelpdeskCategory');
$grid->addCallback(Am_Grid_Editable::CB_BEFORE_SAVE, array($this, 'beforeSave'));
$grid->setPermissionId(Bootstrap_Helpdesk::ADMIN_PERM_CATEGORY);
$grid->actionAdd(new Am_Grid_Action_Sort_HelpdeskCategory());
$grid->setFormValueCallback('watcher_ids', array('RECORD', 'unserializeIds'), array('RECORD', 'serializeIds'));
$grid->setFormValueCallback('fields', array('RECORD', 'unserializeList'), array('RECORD', 'serializeList'));
$grid->addCallback(Am_Grid_Editable::CB_AFTER_DELETE, array($this, 'afterDelete'));
$grid->addCallback(Am_Grid_Editable::CB_AFTER_SAVE, array($this, 'afterSave'));
$grid->addCallback(Am_Grid_Editable::CB_VALUES_TO_FORM, array($this, 'valuesToForm'));
return $grid;
}
public function renderOwner($record)
{
return $record->owner_id ?
sprintf('%s ', Am_Html::escape($record->owner)) :
'%s
', $intro) : '';
}
public function createController($id, $title, $grid)
{
return new Am_Helpdesk_Controller($grid->getRequest(), $grid->getResponse(), $this->_invokeArgs);
}
}PK 3\b٧܁
AdminQueueController.phpnu [ hasPermission(Bootstrap_Webhooks::ADMIN_PERM_ID);
}
function createGrid()
{
$ds = new Am_Query($this->getDi()->webhookQueueTable);
$grid = new Am_Grid_Editable('_w', ___('Webhooks Queue'), $ds, $this->getRequest(), $this->getView(), $this->getDi());
$grid->setPermissionId(Bootstrap_Webhooks::ADMIN_PERM_ID);
$grid->actionDelete('edit');
$grid->actionDelete('insert');
$grid->actionAdd(new Am_Grid_Action_Group_Delete);
$grid->addField(new Am_Grid_Field_Date('added', ___('Added')));
$grid->addField(new Am_Grid_Field_Date('sent', ___('Sent')));
$grid->addField('event_id', ___('Event'));
$grid->addField('url', ___('Url'));
$grid->addField('failures', ___('Failures'));
$grid->addField('last_error', ___('Last Error'));
$grid->addField(new Am_Grid_Field_Expandable('params', ___('Params'), false))
->setAjax($this->getDi()->url('webhooks/admin-queue/get-queue-details?id={webhook_queue_id}',null,false));
$grid->setFilter(new Am_Grid_Filter_WebhookQueue);
return $grid;
}
function getQueueDetailsAction()
{
$log = $this->getDi()->webhookQueueTable->load($this->getParam('id'));
echo $this->renderQueueDetails($log);
}
public function renderQueueDetails(WebhookQueue $obj)
{
$ret = "";
$ret .= "\n";
if (empty($obj->params)) {
$rows = array();
} else {
$rows = unserialize($obj->params);
}
$open = count($rows) == 1 ? 'open' : '';
foreach ($rows as $name => $array)
{
$ret .= "\t
\n";
$ret .= "\t\t
$name
\n";
$ret .= "\t\t
\n";
$ret .= "\t
\n";
}
$ret .= "