コード例 #1
0
 /**
  * Execute a command and return a response. Does not render
  * @param IRequest $Request
  * @return IResponse the execution response
  */
 function execute(IRequest $Request)
 {
     $SessionRequest = $Request;
     if (!$SessionRequest instanceof ISessionRequest) {
         throw new \Exception("Session required");
     }
     $Table = new ProductTable();
     $StatsQuery = $Table->select()->limit(50);
     $StatsTable = new HTMLPDOQueryTable($StatsQuery);
     $StatsTable->addColumn('product');
     $StatsTable->addColumn('type');
     $StatsTable->addColumn('total');
     $StatsTable->addColumn('account');
     $StatsTable->addColumn('description');
     $StatsTable->addColumn('fees');
     $StatsTable->addColumn('test-url');
     $StatsTable->addSearchColumn(ProductTable::COLUMN_ID, "product");
     $StatsTable->addSearchColumn(ProductTable::COLUMN_ACCOUNT_ID, "account");
     $StatsTable->addSortColumn(ProductTable::COLUMN_ID, "product");
     $StatsTable->addSortColumn(ProductTable::COLUMN_ACCOUNT_ID, "account");
     $StatsTable->validateRequest($Request);
     $Account = AbstractAccountType::loadFromSession($SessionRequest);
     if ($Account instanceof AdministratorAccount) {
     } else {
         if ($Account instanceof MerchantAccount) {
             $StatsQuery->where(ProductTable::COLUMN_ACCOUNT_ID, $Account->getID());
         } else {
             $StatsQuery->where(ProductTable::COLUMN_ACCOUNT_ID, -1);
         }
     }
     $Form = new HTMLForm(self::FORM_METHOD, $Request->getPath(), self::FORM_NAME, new HTMLMetaTag(HTMLMetaTag::META_TITLE, self::TITLE), new HTMLElement('fieldset', new HTMLElement('legend', 'legend-submit', self::TITLE), $StatsTable, new HTMLButton('submit', 'Submit', 'submit')), "<br/>");
     return $Form;
 }
コード例 #2
0
 /**
  * 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;
 }