/**
* Execute a command and return a response. Does not render
* @param IRequest $Request
* @return IResponse the execution response
*/
function execute(IRequest $Request)
{
$walletOptions = array('Choose a Wallet' => null);
/** @var AbstractWallet[] $WalletTypes */
$WalletTypes = array();
$WalletForms = array();
foreach (AbstractWallet::loadAllWalletTypes() as $WalletType) {
$WalletTypes[$WalletType->getTypeName()] = $WalletType;
$FieldSet = $WalletType->getFieldSet($Request);
$FieldSet->setAttribute('data-' . self::PARAM_WALLET_TYPE, $WalletType->getTypeName());
$FieldSet->setAttribute('disabled', 'disabled');
$WalletForms[] = $FieldSet;
$walletOptions[$WalletType->getDescription()] = $WalletType->getTypeName();
}
$Form = new HTMLForm(self::FORM_METHOD, self::FORM_ACTION, self::FORM_NAME, new HTMLMetaTag(HTMLMetaTag::META_TITLE, self::TITLE), new HTMLHeaderScript(__DIR__ . '\\assets\\create-wallet.js'), new HTMLHeaderStyleSheet(__DIR__ . '\\assets\\create-wallet.css'), new HTMLElement('fieldset', new HTMLElement('legend', 'legend-wallet', 'Create a new Wallet'), new HTMLElement('label', null, "New Wallet type<br/>", new HTMLSelectField(self::PARAM_WALLET_TYPE, $walletOptions, new RequiredValidation())), "<br/><br/>", $WalletForms, "<br/><br/>", new HTMLButton('create', "Create New Wallet")));
$Form->setFormValues($Request);
if (!$Request instanceof IFormRequest) {
return $Form;
}
$walletType = $Form->validateField($Request, self::PARAM_WALLET_TYPE);
$NewWallet = $WalletTypes[$walletType];
$NewWallet->validateRequest($Request, $Form);
// $name = $Request[self::PARAM_WALLET_NAME];
// $email = $Request[self::PARAM_WALLET_EMAIL];
$id = WalletEntry::create($Request, $NewWallet);
return new RedirectResponse(ManageWallet::getRequestURL($id), "Wallet created successfully. Redirecting...", 5);
}
/**
* Execute a command and return a response. Does not render
* @param IRequest $Request
* @return IResponse the execution response
*/
function execute(IRequest $Request)
{
$Table = new ProfitTable();
$StatsQuery = $Table->select(ProfitTable::COLUMN_ACCOUNT_ID, 'account')->select(ProfitTable::COLUMN_PROFIT, 'profit', 'SUM(%s)')->select(ProfitTable::COLUMN_PROFIT, 'count', 'COUNT(%s)')->groupBy(ProfitTable::COLUMN_ACCOUNT_ID)->limit(50);
$StatsTable = new HTMLPDOQueryTable($StatsQuery);
$StatsTable->addColumn('account');
$StatsTable->addColumn('profit');
$StatsTable->addColumn('count');
$StatsTable->addSearchColumn(ProfitTable::COLUMN_ACCOUNT_ID, "account");
$StatsTable->validateRequest($Request);
$Form = new HTMLForm(self::FORM_METHOD, $Request->getPath(), self::FORM_NAME, new HTMLMetaTag(HTMLMetaTag::META_TITLE, self::TITLE), new HTMLHeaderStyleSheet(__DIR__ . '/assets/search-profit.css'), new HTMLElement('fieldset', 'fieldset-search fieldset-filter-search inline', new HTMLElement('legend', 'legend-filter-search', self::TITLE), $StatsTable, "<br/>", new HTMLButton(null, 'Report')), "<br/>");
$Form->setFormValues($Request);
return $Form;
}
/**
* Execute a command and return a response. Does not render
* @param IRequest $Request
* @throws \Exception
* @return IResponse the execution response
*/
function execute(IRequest $Request)
{
$SessionRequest = $Request;
if (!$SessionRequest instanceof ISessionRequest) {
throw new \Exception("Session required");
}
$Form = new HTMLForm(self::FORM_METHOD, $Request->getPath(), self::FORM_NAME, new HTMLMetaTag(HTMLMetaTag::META_TITLE, self::TITLE), new HTMLHeaderScript(__DIR__ . '/assets/account.js'), new HTMLHeaderStyleSheet(__DIR__ . '/assets/account.css'), new HTMLElement('fieldset', 'fieldset-create-account', new HTMLElement('legend', 'legend-account', self::TITLE), new HTMLElement('label', null, "Choose a Account Type<br/>", new HTMLInputField(self::PARAM_ACCOUNT_NAME, new RequiredValidation())), "<br/><br/>", new HTMLElement('label', null, "Status<br/>", new HTMLInputField(self::PARAM_ACCOUNT_PASSWORD, null, 'password', new RequiredValidation())), "<br/><br/>Login:<br/>", new HTMLButton('submit', 'Login', 'submit')), "<br/>");
$Form->setFormValues($Request);
if (!$Request instanceof IFormRequest) {
return $Form;
}
$Form->validateRequest($Request);
$AccountEntry = AccountEntry::search($Request[self::PARAM_ACCOUNT_NAME]);
$Account = $AccountEntry->getAccount();
$Account->assertPassword($Request[self::PARAM_ACCOUNT_PASSWORD]);
$Account->startSession($SessionRequest);
return new RedirectResponse(ManageAccount::getRequestURL($AccountEntry->getID()), "Logged in successfully. Redirecting...", 5);
}
/**
* Execute a command and return a response. Does not render
* @param IRequest $Request
* @throws \Exception
* @return IResponse the execution response
*/
function execute(IRequest $Request)
{
$SessionRequest = $Request;
if (!$SessionRequest instanceof ISessionRequest) {
throw new \Exception("Session required");
}
$Account = AbstractAccountType::loadFromSession($SessionRequest);
$Form = new HTMLForm(self::FORM_METHOD, $Request->getPath(), self::FORM_NAME, new HTMLMetaTag(HTMLMetaTag::META_TITLE, self::TITLE . ' - ' . $Account->getAccountName()), new HTMLHeaderScript(__DIR__ . '/assets/account.js'), new HTMLHeaderStyleSheet(__DIR__ . '/assets/account.css'), new HTMLElement('fieldset', 'fieldset-create-account', new HTMLElement('legend', 'legend-account', self::TITLE . ' - ' . $Account->getAccountName()), new HTMLButton('submit', 'Logout', 'submit')), "<br/>");
$Form->setFormValues($Request);
if (!$Request instanceof IFormRequest) {
return $Form;
}
$Form->validateRequest($Request);
if (!$SessionRequest->isStarted()) {
$SessionRequest->startSession();
}
$SessionRequest->destroySession();
return new RedirectResponse(Login::getRequestURL(), "Logged out successfully. Redirecting...", 5);
}
/**
* Execute a command and return a response. Does not render
* @param IRequest $Request
* @throws RequestException
* @return IResponse the execution response
*/
function execute(IRequest $Request)
{
$SessionRequest = $Request;
if (!$SessionRequest instanceof ISessionRequest) {
throw new RequestException("Session required");
}
$page = 0;
$total = null;
$row_count = 5;
if (isset($Request[self::PARAM_PAGE])) {
$page = $Request[self::PARAM_PAGE];
}
$offset = $page * $row_count;
$Pagination = new HTMLPagination($row_count, $page, $total);
$Table = new TransactionTable();
$SearchQuery = $Table->select()->limit("{$row_count} OFFSET {$offset}");
// $SearchQuery->orderBy(TransactionTable::COLUMN_CREATED, "DESC");
$SearchTable = new HTMLPDOQueryTable($SearchQuery);
$SearchTable->addColumn('id', "transaction");
$SearchTable->addColumn('product', "product");
$SearchTable->addColumn('wallet', "wallet");
$SearchTable->addColumn('created', "created");
$SearchTable->addColumn('status', "status");
$SearchTable->addColumn('amount', "amount");
$SearchTable->addColumn('email', "email");
$SearchTable->addColumn('product', "product");
$SearchTable->addColumn('currency', "currency");
$SearchTable->addSearchColumn(TransactionTable::COLUMN_ID, "transaction");
$SearchTable->addSearchColumn(TransactionTable::COLUMN_WALLET_ID, "wallet");
$SearchTable->addSearchColumn(TransactionTable::COLUMN_PRODUCT_ID, "product");
$SearchTable->addSortColumn(TransactionTable::COLUMN_CREATED, "created");
$SearchTable->addSortColumn(TransactionTable::COLUMN_STATUS, "status");
$SearchTable->addSortColumn(TransactionTable::COLUMN_AMOUNT, "amount");
$SearchTable->validateRequest($Request);
$StatsQuery = $Table->select(TransactionTable::COLUMN_AMOUNT, 'count', 'COUNT(%s)')->select(TransactionTable::COLUMN_AMOUNT, 'total', 'SUM(%s)')->select(TransactionTable::COLUMN_STATUS, 'approves', 'SUM(%s = ' . TransactionEntry::STATUS_APPROVED . ')')->select(TransactionTable::COLUMN_STATUS, 'approves_total', 'SUM(IF(%s = ' . TransactionEntry::STATUS_APPROVED . ', ' . TransactionTable::COLUMN_AMOUNT . ', 0))')->select(TransactionTable::COLUMN_STATUS, 'pending', 'SUM(%s = ' . TransactionEntry::STATUS_PENDING . ')')->select(TransactionTable::COLUMN_STATUS, 'pending_total', 'SUM(IF(%s = ' . TransactionEntry::STATUS_PENDING . ', ' . TransactionTable::COLUMN_AMOUNT . ', 0))')->select(TransactionTable::COLUMN_STATUS, 'declines', 'SUM(%s = ' . TransactionEntry::STATUS_DECLINED . ')')->select(TransactionTable::COLUMN_STATUS, 'declines_total', 'SUM(IF(%s = ' . TransactionEntry::STATUS_DECLINED . ', ' . TransactionTable::COLUMN_AMOUNT . ', 0))')->select(TransactionTable::COLUMN_STATUS, 'refunds', 'SUM(%s = ' . TransactionEntry::STATUS_REFUNDED . ')')->select(TransactionTable::COLUMN_STATUS, 'refunds_total', 'SUM(IF(%s = ' . TransactionEntry::STATUS_REFUNDED . ', ' . TransactionTable::COLUMN_AMOUNT . ', 0))')->select(TransactionTable::COLUMN_STATUS, 'chargebacks', 'SUM(%s = ' . TransactionEntry::STATUS_CHARGE_BACK . ')')->select(TransactionTable::COLUMN_STATUS, 'chargebacks_total', 'SUM(IF(%s = ' . TransactionEntry::STATUS_CHARGE_BACK . ', ' . TransactionTable::COLUMN_AMOUNT . ', 0))')->select(TransactionTable::COLUMN_PAYMENT_SOURCE_ID, PaymentSourceTable::COLUMN_SOURCE, "(Select " . PaymentSourceTable::COLUMN_SOURCE . " FROM " . PaymentSourceTable::TABLE_NAME . " WHERE " . PaymentSourceTable::COLUMN_ID . '=' . TransactionTable::COLUMN_PAYMENT_SOURCE_ID . ")")->select(TransactionTable::COLUMN_PRODUCT_ID, "Product")->groupBy(TransactionTable::COLUMN_PAYMENT_SOURCE_ID . ', ' . TransactionTable::COLUMN_PRODUCT_ID)->limit(50)->addRowCallback(function (&$row) {
/** @var AbstractPaymentSource $Source */
$Source = unserialize($row[PaymentSourceTable::COLUMN_SOURCE]);
unset($row[PaymentSourceTable::COLUMN_SOURCE]);
$cur = $Source->getCurrency();
$row['total '] = vsprintf('(%0d) <span class="total">%1.2f</span>', $row) . ' ' . $cur;
unset($row['count'], $row['total']);
$row['approves '] = vsprintf('(%0d) <span class="total">%1.2f</span>', $row) . ' ' . $cur;
unset($row['approves'], $row['approves_total']);
$row['pending '] = vsprintf('(%0d) <span class="total">%1.2f</span>', $row) . ' ' . $cur;
unset($row['pending'], $row['pending_total']);
$row['declines '] = vsprintf('(%0d) <span class="total">%1.2f</span>', $row) . ' ' . $cur;
unset($row['declines'], $row['declines_total']);
$row['refunds '] = vsprintf('(%0d) <span class="total">%1.2f</span>', $row) . ' ' . $cur;
unset($row['refunds'], $row['refunds_total']);
$row['chargebacks '] = vsprintf('(%0d) <span class="total">%1.2f</span>', $row) . ' ' . $cur;
unset($row['chargebacks'], $row['chargebacks_total']);
});
$StatsTHead = new HTMLPDOQueryTableBody($StatsQuery);
$StatsTBody = new HTMLSequenceTableBody($StatsQuery, self::CLS_TABLE_TRANSACTION_SEARCH);
$Account = AbstractAccountType::loadFromSession($SessionRequest);
if ($Account instanceof MerchantAccount) {
$SearchQuery->where(TransactionTable::COLUMN_PRODUCT_ID, $Account->getID(), "IN (Select " . ProductTable::COLUMN_ID . "\n\tFROM " . ProductTable::TABLE_NAME . "\n\tWHERE " . ProductTable::COLUMN_ACCOUNT_ID . " = ?)");
$StatsQuery->where(TransactionTable::COLUMN_PRODUCT_ID, $Account->getID(), "IN (Select " . ProductTable::COLUMN_ID . "\n\tFROM " . ProductTable::TABLE_NAME . "\n\tWHERE " . ProductTable::COLUMN_ACCOUNT_ID . " = ?)");
} else {
if ($Account instanceof AdministratorAccount) {
// } else if ($Account instanceof ProcessorAccount) {
// $SearchQuery->where(TransactionTable::COLUMN_PAYMENT_SOURCE_ID, $Account->getID(),
// "IN (Select " . PaymentSourceTable::COLUMN_ID
// . "\n\tFROM " . PaymentSourceTable::TABLE_NAME
// . "\n\tWHERE " . PaymentSourceTable::C. " = ?)"
// );
} else {
$SearchQuery->where(TransactionTable::COLUMN_ID, '-1');
}
}
$Form = new HTMLForm(self::FORM_METHOD, $Request->getPath(), self::FORM_NAME, new HTMLMetaTag(HTMLMetaTag::META_TITLE, self::TITLE), new HTMLHeaderStyleSheet(__DIR__ . '/assets/search-transaction.css'), new HTMLElement('fieldset', 'fieldset-search fieldset-filter-search', new HTMLElement('legend', 'legend-filter-search', self::TITLE), new HTMLElement('fieldset', 'fieldset-filter-stats-results', new HTMLElement('legend', 'legend-filter-stats-results', 'Stats'), new HTMLTable($StatsTHead, $StatsTBody)), "<br/>", new HTMLElement('fieldset', 'fieldset-filter-search-results', new HTMLElement('legend', 'legend-filter-search-results', 'Search Results'), $SearchTable, $Pagination), "<br/>", new HTMLSubmit(null, 'Search')), "<br/>");
$Form->setFormValues($Request);
return $Form;
}
/**
* Validate the request
* @param IRequest $Request
* @param HTMLForm $ThrowForm
* @throws \CPath\Request\Validation\Exceptions\ValidationException
* @return array|void optionally returns an associative array of modified field names and values
*/
function validateFeesRequest(IRequest $Request, HTMLForm $ThrowForm = null)
{
$Form = new HTMLForm('POST', $this->getFeesFieldSet($Request));
$Form->setFormValues($Request);
$Form->validateRequest($Request, $ThrowForm);
$this->fees = $Request[self::PARAM_PRODUCT_FEE];
foreach ($Request[self::PARAM_PRODUCT_FEE] as $accountID => $fee) {
$fees = explode(';', $fee);
foreach ($fees as &$f) {
$f = preg_replace('/[^0-9;.%]/', '', $f);
if (!$f) {
$f = null;
} else {
if (strpos($fee, '.') === false) {
$f .= '.00';
}
}
}
$this->fees[$accountID] = implode('; ', $fees) ?: '0.00';
}
}
/**
* Execute a command and return a response. Does not render
* @param IRequest $Request
* @throws \Exception
* @return IResponse the execution response
*/
function execute(IRequest $Request)
{
$SessionRequest = $Request;
if (!$SessionRequest instanceof ISessionRequest) {
throw new \Exception("Session required");
}
$ProductForms = array();
/** @var AbstractWallet[] $WalletTypes */
$WalletTypes = array();
$walletOptions = array('Choose a Wallet' => null);
$WalletForms = array();
$Products = ProductEntry::loadSessionProducts($SessionRequest);
$productOptions = array('Choose a Product' => null);
foreach ($Products as $ProductEntry) {
$Product = $ProductEntry->getProduct();
$productOptions[$Product->getTotalCost() . ' - ' . $Product->getProductTitle()] = $ProductEntry->getID();
$Product = $ProductEntry->getProduct();
$FieldSet = $Product->getOrderFieldSet($Request);
$key = $ProductEntry->getID();
$FieldSet->setAttribute('data-' . self::PARAM_PRODUCT_ID, $key);
$ProductForms[] = $FieldSet;
foreach ($Product->getWalletTypes() as $WalletType) {
$key = $WalletType->getTypeName();
$WalletTypes[$key] = $WalletType;
$FieldSet = $WalletType->getFieldSet($Request);
$FieldSet->setAttribute('data-' . self::PARAM_WALLET_ID, $key);
$FieldSet->setAttribute('disabled', 'disabled');
$WalletForms[] = $FieldSet;
$walletOptions['New ' . $WalletType->getDescription()] = $key;
}
}
$SessionWalletEntries = AbstractWallet::loadSessionWallets($SessionRequest);
foreach ($SessionWalletEntries as $WalletEntry) {
$Wallet = $WalletEntry->getWallet();
$key = $WalletEntry->getID();
$WalletTypes[$key] = $Wallet;
$FieldSet = $Wallet->getFieldSet($Request);
$FieldSet->setAttribute('data-' . self::PARAM_WALLET_ID, $key);
$FieldSet->setAttribute('disabled', 'disabled');
$WalletForms[] = $FieldSet;
$walletOptions[$Wallet->getTitle() . ' - ' . $Wallet->getDescription()] = $key;
}
// $walletTypes = Config::$AvailableWalletTypes;
$Form = new HTMLForm(self::FORM_METHOD, self::FORM_ACTION, self::FORM_NAME, new HTMLMetaTag(HTMLMetaTag::META_TITLE, self::TITLE), new HTMLHeaderScript(__DIR__ . '/assets/transaction.js'), new HTMLHeaderStyleSheet(__DIR__ . '/assets/transaction.css'), new HTMLElement('fieldset', 'fieldset-create-transaction', new HTMLElement('legend', 'legend-wallet', self::TITLE), new HTMLElement('fieldset', 'fieldset-transaction', new HTMLElement('legend', 'legend-transaction', 'Transaction Details'), new HTMLElement('label', null, "Status<br/>", new HTMLSelectField(self::PARAM_TRANSACTION_STATUS, TransactionEntry::$StatusOptions, new RequiredValidation())), "<br/><br/>", new HTMLElement('label', null, "Product<br/>", new HTMLSelectField(self::PARAM_PRODUCT_ID, $productOptions, new RequiredValidation())), "<br/><br/>", $ProductForms), new HTMLElement('fieldset', 'fieldset-choose-wallet', new HTMLElement('legend', 'legend-wallet', 'Choose a Wallet'), new HTMLElement('label', null, new HTMLSelectField(self::PARAM_WALLET_ID, $walletOptions, new RequiredValidation())), "<br/><br/>", $WalletForms), "<br/><br/>Submit:<br/>", new HTMLButton('submit', 'Create Transaction', 'submit')), "<br/>");
if (!$Request instanceof IFormRequest) {
return $Form;
}
$Form->setFormValues($Request);
// $status = (int)$Form->validateField($Request, self::PARAM_TRANSACTION_STATUS);
// $email = $Form->validateField($Request, self::PARAM_TRANSACTION_EMAIL);
$walletType = $Form->validateField($Request, self::PARAM_WALLET_ID);
$ChosenWallet = $WalletTypes[$walletType];
$ChosenWallet->validateRequest($Request, $Form);
$productID = $Form->validateField($Request, self::PARAM_PRODUCT_ID);
$ProductEntry = ProductEntry::get($productID);
$Product = $ProductEntry->getProduct();
$Invoice = $Product->createNewInvoice($Request, $ChosenWallet);
$responses = array();
foreach (PaymentSourceEntry::getActiveSources() as $PaymentSourceEntry) {
$PaymentSource = $PaymentSourceEntry->getPaymentSource();
if ($PaymentSource->supportsWalletType($ChosenWallet)) {
$Response = $PaymentSource->executeWalletTransaction($ChosenWallet);
$responses[] = $Response->getMessage();
$paymentSourceID = $PaymentSourceEntry->getID();
$walletID = WalletEntry::createOrUpdate($Request, $ChosenWallet);
if ($Response->getCode() === TransactionEntry::STATUS_APPROVED) {
$status = TransactionEntry::STATUS_APPROVED;
$id = TransactionEntry::create($Request, $Invoice, $status, $walletID, $productID, $paymentSourceID);
ProfitEntry::update($Request, $id);
return new RedirectResponse(ManageTransaction::getRequestURL($id), "Transaction created successfully. Redirecting...", 5);
} else {
$status = TransactionEntry::STATUS_DECLINED;
$id = TransactionEntry::create($Request, $Invoice, $status, $walletID, $productID, $paymentSourceID);
ProfitEntry::update($Request, $id);
}
}
}
throw new ValidationException($Form, "Transaction declined: \n\t" . implode("\n\t", $responses));
}
