/** * 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)); }