redirectToErrorPage(); } //-------------------- Setup the direct db access methods ------------------------------// $fetch_object_function = _mmmd() . "_fetch_object"; $free_result_function = _mmmd() . "_free_result"; $error_function = _mmmd() . "_error"; //-------------------- Setup the filename and file type (header generation also) ------------------------------// //TODO: set charset to utf-8 $fileType = "application/csv"; $fileName = "export.csv"; header("Content-type: " . $fileType); header("Content-Disposition: filename=" . $fileName); header("Pragma: no-cache"); //-------------------- Generate Data ------------------------------// if ($_REQUEST['module'] == "MM_ManageTransactionsView") { $view = new MM_ManageTransactionsView(); $dataGrid = new MM_DataGrid($_REQUEST, "transaction_date", "desc"); $csvHeaders = $view->getCSVHeaders(); //headers array is keyed by the db fieldname $handle = fopen("php://output", "w"); fputcsv($handle, $csvHeaders); $query = $view->constructQuery($_REQUEST, $dataGrid); $result = _mmmq($query); while ($row = @$fetch_object_function($result)) { $outputArray = array(); //csv fields are type(transaction_type), date(transaction_date), order#(order_number), amount(transaction_amount), name(last_name), email(user_email), description //do some translations $fullName = "{$row->last_name}, {$row->first_name}"; $transactionTypeLabel = ""; switch ($row->transaction_type) { case MM_TransactionLog::$TRANSACTION_TYPE_PAYMENT:
<?php /** * * MemberMouse(TM) (http://www.membermouse.com) * (c) MemberMouse, LLC. All rights reserved. */ // get data based on search criteria and datagrid settings $view = new MM_ManageTransactionsView(); $dataGrid = new MM_DataGrid($_REQUEST, "transaction_date", "desc"); $data = $view->search($_REQUEST, $dataGrid); $dataGrid->setTotalRecords($data); $dataGrid->recordName = "transaction"; $headers = $view->getGridHeaders(); $datagridRows = array(); // process data foreach ($data as $key => $item) { $fullName = "{$item->last_name}, {$item->first_name}"; $transactionTypeIcons = ""; switch ($item->transaction_type) { case MM_TransactionLog::$TRANSACTION_TYPE_PAYMENT: $transactionTypeIcons .= MM_Utils::getIcon('money', 'green', '1.4em', '2px', "Initial Payment or One-Time Payment"); break; case MM_TransactionLog::$TRANSACTION_TYPE_RECURRING_PAYMENT: $transactionTypeIcons .= MM_Utils::getIcon('refresh', 'green', '1.4em', '2px', "Recurring Payment", "padding-left:2px;"); break; case MM_TransactionLog::$TRANSACTION_TYPE_REFUND: $transactionTypeIcons .= MM_Utils::getIcon('money', 'red', '1.4em', '2px', "Refund"); break; default: $transactionTypeIcons .= MM_NO_DATA;
<?php /** * * MemberMouse(TM) (http://www.membermouse.com) * (c) MemberMouse, LLC. All rights reserved. */ $view = new MM_ManageTransactionsView(); $showSearch = false; //only show 'export csv' option if current user is an administrator global $current_user; $showCsvExportButton = false; if (isset($current_user) && isset($current_user->ID)) { $employee = MM_Employee::findByUserId($current_user->ID); if ($employee->isValid() && ($employee->getRoleId() == MM_Role::$ROLE_ADMINISTRATOR || $employee->doAllowExport())) { $showCsvExportButton = true; $exportDataUrl = MM_MODULES_URL . "/export_data.php"; echo "<script type='text/javascript'>export_transactions_url = '{$exportDataUrl}';</script>\n"; } echo "<input type='hidden' id='mm-admin-id' value='{$current_user->ID}' />"; // determine if this user's preference is to have the advanced search open $showSearchOptionName = MM_OptionUtils::$OPTION_KEY_SHOW_TRANSACTIONS_SEARCH . "-" . $current_user->ID; $showSearchOptionValue = MM_OptionUtils::getOption($showSearchOptionName); if ($showSearchOptionValue == "1") { $showSearch = true; } } ?> <div class="mm-wrap"> <div style="margin-top:20px;" class="mm-button-container"> <a id="mm-show-search-btn" onclick="mmjs.showSearch()" class="mm-ui-button blue" <?php