arm_check_user_cap($arm_capabilities_global['arm_manage_transactions'], '1'); $column_list = isset($_POST['column_list']) ? $_POST['column_list'] : ''; if ($column_list != "") { $user_id = get_current_user_id(); $column_list = explode(',', $column_list); $transaction_columns = maybe_serialize($column_list); update_user_meta($user_id, 'arm_transaction_hide_show_columns', $transaction_columns); } die(); } function arm_get_transaction($field = '', $value = '', $output_type = ARRAY_A) { global $wp, $wpdb, $ARMember, $arm_slugs, $arm_members_class, $arm_global_settings, $arm_subscription_plans; $log_data = array(); if (!empty($field) && !empty($value) && $value != 0) { $log_data = $wpdb->get_results("SELECT * FROM `" . $ARMember->tbl_arm_payment_log . "` WHERE `" . $field . "`='" . $value . "'", $output_type); } return $log_data; } function arm_get_single_transaction($log_id = 0, $output_type = ARRAY_A) { global $wp, $wpdb, $ARMember, $arm_slugs, $arm_members_class, $arm_global_settings, $arm_subscription_plans; $log_data = array(); if (!empty($log_id) && $log_id != 0) { $log_data = $wpdb->get_row("SELECT * FROM `" . $ARMember->tbl_arm_payment_log . "` WHERE `arm_log_id`='" . $log_id . "'", $output_type); } return $log_data; } function arm_preview_failed_log_detail() { global $wp, $wpdb, $current_user, $arm_errors, $ARMember, $arm_global_settings, $arm_subscription_plans; $log_id = $_POST['log_id']; $date_time_format = $arm_global_settings->arm_get_wp_date_time_format(); if (!empty($log_id) && $log_id != 0) { $log_detail = $this->arm_get_single_transaction($log_id); if (!empty($log_detail)) { $extraVars = (isset($log_detail['arm_extra_vars'])) ? maybe_unserialize($log_detail['arm_extra_vars']) : array(); ?>
user_login)) ? $data->user_login : '--'; } else { echo '--'; } ?>
arm_get_plan_name_by_id($log_detail['arm_plan_id']): '--';?>
arm_check_user_cap($arm_capabilities_global['arm_manage_transactions'], '1'); $gateways = $arm_payment_gateways->arm_get_all_payment_gateways(); $bank_transfer_gateways_opts = $gateways['bank_transfer']; $log_id = intval($_POST['log_id']); $log_type = sanitize_text_field($_POST['log_type']); $date_time_format = $arm_global_settings->arm_get_wp_date_time_format(); /* Get Edit Rule Form HTML */ if (!empty($log_id) && $log_id != 0) { if($log_type == 'bt_log'){ $log_data = $wpdb->get_row("SELECT * FROM `" . $ARMember->tbl_arm_bank_transfer_log . "` WHERE `arm_log_id`='" . $log_id . "'"); if(!empty($log_data)){ $lStatus = 'pending'; if ($log_data->arm_status == '1') { $lStatus = 'success'; } if ($log_data->arm_status == '2') { $lStatus = 'canceled'; } $log_detail = array( 'arm_log_id' => $log_data->arm_log_id, 'arm_invoice_id' => $log_data->arm_invoice_id, 'arm_user_id' => $log_data->arm_user_id, 'arm_plan_id' => $log_data->arm_plan_id, 'arm_payment_gateway' => 'bank_transfer', 'arm_payment_type' => 'one_time', 'arm_token' => '', 'arm_payer_email' => $log_data->arm_payer_email, 'arm_receiver_email' => '', 'arm_transaction_id' => $log_data->arm_transaction_id, 'arm_transaction_payment_type' => '-', 'arm_transaction_status' => $lStatus, 'arm_payment_date' => $log_data->arm_created_date, 'arm_amount' => $log_data->arm_amount, 'arm_currency' => $log_data->arm_currency, 'arm_extra_vars' => $log_data->arm_extra_vars, 'arm_response_text' => maybe_serialize((array) $log_data), 'arm_created_date' => $log_data->arm_created_date ); } } else { $log_detail = $this->arm_get_single_transaction($log_id); } if(!empty($log_detail)) { $extra_vars = (isset($log_detail['arm_extra_vars'])) ? maybe_unserialize($log_detail['arm_extra_vars']) : array(); $response_text = (isset($log_detail['arm_response_text'])) ? maybe_unserialize($log_detail['arm_response_text']) : array(); ?>
user_login)) ? $data->user_login : '--'; } else { echo '--'; } ?>
arm_get_plan_name_by_id($log_detail['arm_plan_id']): '--';?>
arm_gateway_name_by_key($log_detail['arm_payment_gateway']) : '--'; ?>
arm_amount_set_separator($log_detail['arm_currency'], $log_detail['arm_amount']) . ' ' . strtoupper($log_detail['arm_currency']); //echo (!empty($log_detail['arm_amount']) && $log_detail['arm_amount'] > 0) ? number_format((float) $log_detail['arm_amount'], 2) . ' ' . strtoupper($log_detail['arm_currency']) : '0.00';?>
1) ? __('Years', 'ARMember') : __('Year', 'ARMember'); } elseif ($extra_vars['trial']['period'] == 'M') { $trialData .= ($trialInterval > 1) ? __('Months', 'ARMember') : __('Month', 'ARMember'); } elseif ($extra_vars['trial']['period'] == 'W') { $trialData .= ($trialInterval > 1) ? __('Weeks', 'ARMember') : __('Week', 'ARMember'); } else { $trialData .= ($trialInterval > 1) ? __('Days', 'ARMember') : __('Day', 'ARMember'); } echo $trialData; ?>
arm_check_user_cap($arm_capabilities_global['arm_manage_transactions'], '1'); if (!isset($_POST)) { return; } $action = esc_attr($_POST['act']); $id = intval($_POST['id']); $type = esc_attr($_POST['type']); if ($action == 'delete') { if (empty($id)) { $errors[] = __('Invalid action.', 'ARMember'); } else { if (!current_user_can('arm_manage_transactions')) { $errors[] = __('Sorry, You do not have permission to perform this action.', 'ARMember'); } else { if ($type == 'bt_log') { $res_var = $wpdb->delete($ARMember->tbl_arm_bank_transfer_log, array('arm_log_id' => $id)); } else { $res_var = $wpdb->delete($ARMember->tbl_arm_payment_log, array('arm_log_id' => $id)); } if ($res_var) { $message = __('Record is deleted successfully.', 'ARMember'); } else { $errors[] = __('Sorry, Something went wrong. Please try again.', 'ARMember'); } } } } $return_array = $arm_global_settings->handle_return_messages(@$errors, @$message); echo json_encode($return_array); exit; } function arm_bulk_delete_transactions() { global $wpdb, $ARMember, $arm_members_class, $arm_global_settings, $arm_capabilities_global; $ARMember->arm_check_user_cap($arm_capabilities_global['arm_manage_transactions'], '1'); if (!isset($_POST)) { return; } $bulkaction = $arm_global_settings->get_param('action1'); if ($bulkaction == -1) { $bulkaction = $arm_global_settings->get_param('action2'); } $btids = $arm_global_settings->get_param('bt-item-action', ''); $ids = $arm_global_settings->get_param('item-action', ''); if ( empty($ids) && empty($btids) ) { $errors[] = __('Please select one or more records.', 'ARMember'); } else { if (!current_user_can('arm_manage_transactions')) { $errors[] = __('Sorry, You do not have permission to perform this action.', 'ARMember'); } else { if ($bulkaction == 'delete_transaction') { $btids = (!is_array($btids)) ? explode(',', $btids) : $btids; $ids = (!is_array($ids)) ? explode(',', $ids) : $ids; if (is_array($btids)) { foreach ($btids as $id) { $res_var = $wpdb->delete($ARMember->tbl_arm_bank_transfer_log, array('arm_log_id' => $id)); } } if (is_array($ids)) { foreach ($ids as $id) { $res_var = $wpdb->delete($ARMember->tbl_arm_payment_log, array('arm_log_id' => $id)); } } $message = __('Transaction(s) has been deleted successfully.', 'ARMember'); } else { $errors[] = __('Please select valid action.', 'ARMember'); } } } $return_array = $arm_global_settings->handle_return_messages(@$errors, @$message); $ARMember->arm_set_message('success', __('Transaction(s) has been deleted successfully.', 'ARMember')); echo json_encode($return_array); exit; } function arm_filter_transactions_list() { global $ARMember, $arm_capabilities_global; $ARMember->arm_check_user_cap($arm_capabilities_global['arm_manage_transactions'], '1'); if( file_exists( MEMBERSHIPLITE_VIEWS_DIR.'/arm_transactions_list_records.php') ){ include( MEMBERSHIPLITE_VIEWS_DIR.'/arm_transactions_list_records.php'); } die(); } function arm_add_manual_payment($data = array()) { global $wp, $wpdb, $ARMember, $arm_slugs, $arm_global_settings, $arm_subscription_plans; $redirect_to = admin_url('admin.php?page=' . $arm_slugs->transactions); if (!empty($data)) { $manual_data = $data['manual_payment']; $user_id = intval($manual_data['user_id']); $plan_id = intval($manual_data['plan_id']); $user_info = get_user_by('id', $user_id); $plan = new ARM_Plan($plan_id); /* Add transaction payment log */ $manual_log = array( 'arm_user_id' => $user_id, 'arm_plan_id' => $plan_id, 'arm_payment_gateway' => 'manual', 'arm_payer_email' => $user_info->user_email, 'arm_payment_type' => $plan->payment_type, 'arm_transaction_payment_type' => 'manual', 'arm_transaction_status' => sanitize_text_field($manual_data['transaction_status']), 'arm_amount' => sanitize_text_field($manual_data['amount']), 'arm_currency' => sanitize_text_field($manual_data['currency']), 'arm_response_text' => maybe_serialize($manual_data), ); $log_id = $this->arm_add_transaction($manual_log); if($log_id) { /* Action After Adding Plan */ do_action('arm_saved_manual_payment', $data); $ARMember->arm_set_message('success', __('Manual payment has been added successfully.', 'ARMember')); wp_redirect($redirect_to); exit; } else { $ARMember->arm_set_message('error', __('Sorry, Something went wrong. please try again.', 'ARMember')); $redirect_to = $arm_global_settings->add_query_arg("action", "new", $redirect_to); wp_redirect($redirect_to); exit; } } return; } function arm_add_transaction($log_data = array()) { global $wp, $wpdb, $ARMember, $arm_subscription_plans, $arm_payment_gateways; $currency = $arm_payment_gateways->arm_get_global_currency(); $default_log_data = array( 'arm_invoice_id' => 0, 'arm_user_id' => 0, 'arm_plan_id' => 0, 'arm_payment_gateway' => '', 'arm_payment_type' => '', 'arm_token' => '', 'arm_payer_email' => '', 'arm_receiver_email' => '', 'arm_transaction_id' => '', 'arm_transaction_payment_type' => '', 'arm_transaction_status' => '', 'arm_payment_mode' => '', 'arm_payment_date' => current_time('mysql'), 'arm_amount' => 0, 'arm_currency' => $currency, 'arm_extra_vars' => '', 'arm_response_text' => '', 'arm_coupon_code' => '', 'arm_coupon_discount' => 0, 'arm_coupon_discount_type' => '', 'arm_is_trial' => '0', 'arm_created_date' => current_time('mysql'), 'arm_display_log' => '1' ); $log_data = shortcode_atts($default_log_data, $log_data); /* Merge Default Values */ switch (strtolower($log_data['arm_transaction_status'])) { case 'completed': case 'paid': case 'active': case 'trialing': case 'succeeded': case 'success': $log_data['arm_transaction_status'] = 'success'; break; case 'pending': case 'past_due': $log_data['arm_transaction_status'] = 'pending'; break; case 'canceled': case 'unpaid': $log_data['arm_transaction_status'] = 'canceled'; $log_data['arm_coupon_code'] = $_REQUEST['arm_coupon_code'] = ''; break; case 'failed': $log_data['arm_transaction_status'] = 'failed'; $log_data['arm_coupon_code'] = $_REQUEST['arm_coupon_code'] = ''; break; case 'expired': $log_data['arm_transaction_status'] = 'expired'; $log_data['arm_coupon_code'] = $_REQUEST['arm_coupon_code'] = ''; break; default: break; } $coupon_code = !empty($log_data['arm_coupon_code']) ? $log_data['arm_coupon_code'] : ''; if (!empty($coupon_code) && $arm_manage_coupons->isCouponFeature) { $log_data['arm_coupon_code'] = $coupon_code; $log_data['arm_coupon_discount'] = !empty($log_data['arm_coupon_discount']) ? $log_data['arm_coupon_discount'] : 0; $log_data['arm_coupon_discount_type'] = !empty($log_data['arm_coupon_discount_type']) ? $log_data['arm_coupon_discount_type'] : ''; if($coupon_code != ''){ $arm_manage_coupons->arm_update_coupon_used_count($coupon_code); } } else { $log_data['arm_coupon_code'] = ''; } /* Insert Payment Log Data. */ $arm_last_invoice_id = get_option('arm_last_invoice_id', 0); $arm_last_invoice_id++; $log_data['arm_invoice_id'] = $arm_last_invoice_id; do_action('arm_before_add_transaction', $log_data); $payment_log = $wpdb->insert($ARMember->tbl_arm_payment_log, $log_data); $payment_log_id = $wpdb->insert_id; if (!empty($payment_log_id) && $payment_log_id != 0) { update_option('arm_last_invoice_id', $arm_last_invoice_id); do_action('arm_after_add_transaction', $log_data); return $payment_log_id; } else { return false; } } function arm_mask_credit_card_number($cc_number = '') { $masked = 'xxxx-xxxx-xxxx-' . substr($cc_number, -4); return $masked; } function arm_get_total_transaction($user_id = 0) { global $ARMember, $wp, $wpdb; $where_plog = " WHERE arm_display_log = 1 "; if(isset($user_id) && $user_id != '' && $user_id != 0) { $where_plog.= " AND `arm_user_id`='$user_id' "; } $total_payment_log_rows = "SELECT COUNT(*) as count_plog FROM `".$ARMember->tbl_arm_payment_log."` {$where_plog}"; $count_payment_rows = $wpdb->get_results($total_payment_log_rows); $total_bank_log_rows = "SELECT COUNT(*) as count_blog FROM `".$ARMember->tbl_arm_bank_transfer_log."` {$where_plog}"; $count_bank_rows = $wpdb->get_results($total_bank_log_rows); $totalRecord = intval($count_payment_rows[0]->count_plog) + intval($count_bank_rows[0]->count_blog); return $totalRecord; } function arm_get_all_transaction($user_id = 0, $offset = 0, $perPage = 5) { global $ARMember, $wp, $wpdb; $ctquery = "SELECT pt.arm_log_id,pt.arm_invoice_id,pt.arm_user_id,pt.arm_plan_id,pt.arm_transaction_id,pt.arm_amount,pt.arm_currency,pt.arm_payment_gateway,pt.arm_transaction_status,pt.arm_payment_type,pt.arm_extra_vars,wpu.user_login as arm_user_login,pt.arm_display_log as arm_display_log, pt.arm_payment_date, pt.arm_coupon_code, pt.arm_coupon_discount_type, pt.arm_coupon_discount, pt.arm_created_date FROM `" . $ARMember->tbl_arm_payment_log . "` pt LEFT JOIN `" . $ARMember->tbl_arm_subscription_plans . "` sp ON pt.arm_plan_id = sp.arm_subscription_plan_id LEFT JOIN `" . $wpdb->users . "` wpu ON pt.arm_user_id = wpu.ID "; $ptquery = "{$ctquery}"; $cbquery = "SELECT bt.arm_log_id,bt.arm_invoice_id,bt.arm_user_id,bt.arm_plan_id,bt.arm_transaction_id,bt.arm_amount,bt.arm_currency,'bank_transfer' as arm_payment_gateway, bt.arm_status as arm_transaction_status,'one_time' as arm_payment_type,bt.arm_extra_vars as arm_extra_vars,wpu.user_login as arm_user_login,bt.arm_display_log as arm_display_log, bt.arm_created_date as arm_payment_date, bt.arm_coupon_code, bt.arm_coupon_discount_type, bt.arm_coupon_discount, bt.arm_created_date FROM `" . $ARMember->tbl_arm_bank_transfer_log . "` bt LEFT JOIN `" . $ARMember->tbl_arm_subscription_plans . "` sp ON bt.arm_plan_id = sp.arm_subscription_plan_id LEFT JOIN `" . $wpdb->users . "` wpu ON bt.arm_user_id = wpu.ID"; $btquery = "{$cbquery}"; $where_plog = " WHERE arm_display_log = 1 "; if(isset($user_id) && $user_id != '' && $user_id != 0) { $where_plog.= " AND `arm_user_id`='$user_id' "; } $orderby = " order by arm_payment_date desc, arm_invoice_id desc "; $phlimit = " LIMIT {$offset},{$perPage}"; $payment_grid_query = "SELECT * FROM (" . $ptquery . " UNION " . $btquery . ") AS arm_payment_history_log {$where_plog} {$orderby} {$phlimit}"; $user_plogs = $wpdb->get_results($payment_grid_query, ARRAY_A); return $user_plogs; } function arm_get_user_transactions_with_pagging($user_id, $current_page = 1, $perPage = 2, $plan_id_name_array = array()) { global $wp, $wpdb, $ARMember, $arm_slugs, $arm_members_class, $arm_global_settings, $arm_subscription_plans,$arm_payment_gateways, $global_currency_sym; $log_data = $temp_logs = array(); $date_format = $arm_global_settings->arm_get_wp_date_time_format(); $global_currency = $arm_payment_gateways->arm_get_global_currency(); if (!empty($user_id) && $user_id != 0) { $perPage = (!empty($perPage) && is_numeric($perPage)) ? $perPage : 5; $offset = 0; if (!empty($current_page) && $current_page > 1) { $offset = ($current_page - 1) * $perPage; } $totalRecord = $this->arm_get_total_transaction($user_id); $user_logs = $this->arm_get_all_transaction($user_id, $offset, $perPage); $trans_records = ''; $trans_records .= '
'; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $i = 1; $plan_ids_array = array(); $plan_ids_name_array = array(); foreach($user_logs as $user_log) { $rc = (object) $user_log; if(in_array($rc->arm_plan_id, $plan_ids_array)){ $subs_plan = $plan_ids_name_array[$rc->arm_plan_id]; } else{ $subs_plan = $plan_id_name_array[$rc->arm_plan_id]; } $plan_ids_name_array[$rc->arm_plan_id] = $subs_plan; $plan_ids_array[] = $rc->arm_plan_id; $membership = (!empty($subs_plan)) ? $subs_plan : '-'; $payment_type = ($rc->arm_payment_type == 'subscription') ? __('Subscription', 'ARMember') : __('One Time', 'ARMember'); $extraVars = (!empty($rc->arm_extra_vars)) ? maybe_unserialize($rc->arm_extra_vars) : array(); if(!empty($extraVars)) { if(isset($extraVars['manual_by'])){ $payment_type.= '
(' . __($extraVars['manual_by'], 'ARMember') . ')
'; } } $arm_transaction_status = $rc->arm_transaction_status; switch ($arm_transaction_status) { case '0': $arm_transaction_status = 'pending'; break; case '1': $arm_transaction_status = 'success'; break; case '2': $arm_transaction_status = 'canceled'; break; default: $arm_transaction_status = $rc->arm_transaction_status; break; } $arm_transaction_status = $this->arm_get_transaction_status_text($arm_transaction_status); $arm_gateway = ($rc->arm_payment_gateway != '') ? $arm_payment_gateways->arm_gateway_name_by_key($rc->arm_payment_gateway) : __('Manual', 'ARMember'); $t_currency = (isset($rc->arm_currency) && !empty($rc->arm_currency)) ? strtoupper($rc->arm_currency) : strtoupper($global_currency); $currency = (isset($all_currencies[$t_currency])) ? $all_currencies[$t_currency] : $global_currency_sym; $transAmount = ''; if (!empty($extraVars) && !empty($extraVars['plan_amount']) && $extraVars['plan_amount'] != 0 ) { $arm_plan_amount = $arm_payment_gateways->arm_amount_set_separator($t_currency, $extraVars['plan_amount']); if($arm_plan_amount != $rc->arm_amount){ $transAmount .= ''.$arm_payment_gateways->arm_prepare_amount($t_currency, $extraVars['plan_amount']).''; } } $transAmount .= ''; if (!empty($rc->arm_amount) && $rc->arm_amount > 0 ) { $transAmount .= $arm_payment_gateways->arm_prepare_amount($t_currency, $rc->arm_amount); if ($global_currency_sym == $currency && strtoupper($global_currency) != $t_currency) { $transAmount .= ' ('.$t_currency.')'; } } else { $transAmount .= $arm_payment_gateways->arm_prepare_amount($t_currency, $rc->arm_amount); } $transAmount .= ''; if (!empty($extraVars) && isset($extraVars['trial'])) { $trialInterval = $extraVars['trial']['interval']; $transAmount .= ''; $transAmount .= __('Trial Period', 'ARMember').": {$trialInterval} "; if ($extraVars['trial']['period'] == 'Y') { $transAmount .= ($trialInterval > 1) ? __('Years', 'ARMember') : __('Year', 'ARMember'); } elseif ($extraVars['trial']['period'] == 'M') { $transAmount .= ($trialInterval > 1) ? __('Months', 'ARMember') : __('Month', 'ARMember'); } elseif ($extraVars['trial']['period'] == 'W') { $transAmount .= ($trialInterval > 1) ? __('Weeks', 'ARMember') : __('Week', 'ARMember'); } elseif ($extraVars['trial']['period'] == 'D') { $transAmount .= ($trialInterval > 1) ? __('Days', 'ARMember') : __('Day', 'ARMember'); } $transAmount .= ''; } $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; $i++; } if( $totalRecord <= 0 ){ $trans_records .= ''; $trans_records .= ''; $trans_records .= ''; } $trans_records .= '
#'.__('Membership','ARMember').''.__('Payment Type','ARMember').''.__('Transaction Status','ARMember').''.__('Gateway','ARMember').''.__('Amount','ARMember').''.__('Payment Date','ARMember').'
'.$i.''.$membership.''.$payment_type.''.$arm_transaction_status.''.$arm_gateway.''.$transAmount.''.date_i18n($date_format, strtotime($rc->arm_payment_date)).'
' . __('No Payment History Found.', 'ARMember') . '
'; $trans_records .= '
'; $transPaging = $arm_global_settings->arm_get_paging_links($current_page, $totalRecord, $perPage, ''); $trans_records .= '
' . $transPaging . '
'; $trans_records .= '
'; $trans_records .= '
'; } return $trans_records; } function arm_get_user_transactions_paging_action() { global $wp, $wpdb, $ARMember, $arm_global_settings, $arm_payment_gateways, $arm_subscription_plans, $arm_capabilities_global; if (isset($_POST['action']) && $_POST['action'] == 'arm_get_user_transactions_paging_action') { $user_id = isset($_POST['user_id']) ? intval($_POST['user_id']) : 0; $current_page = isset($_POST['page']) ? intval($_POST['page']) : 1; $per_page = isset($_POST['per_page']) ? intval($_POST['per_page']) : 5; $plan_id_name_array = $arm_subscription_plans->arm_get_plan_name_by_id_from_array(); $ARMember->arm_check_user_cap($arm_capabilities_global['arm_manage_members'], '1'); echo $this->arm_get_user_transactions_with_pagging($user_id, $current_page, $per_page, $plan_id_name_array); } exit; } function arm_get_bank_transfer_logs($filter_gateway = 0, $filter_ptype = 0, $filter_pstatus = 0, $limit = 0) { global $wp, $wpdb, $current_user, $arm_errors, $ARMember, $arm_global_settings, $arm_subscription_plans; $bt_logs = array(); if (empty($filter_gateway) || $filter_gateway == 'bank_transfer' || $filter_gateway == '0') { if (empty($filter_ptype) || $filter_ptype == 'one_time' || $filter_ptype == '0') { $where_btlog = 'WHERE 1=1'; if (!empty($filter_pstatus) && $filter_pstatus != '0') { if ($filter_pstatus == 'success') { $where_btlog .= " AND `arm_status`='1'"; } if ($filter_pstatus == 'pending') { $where_btlog .= " AND `arm_status`='0'"; } if ($filter_pstatus == 'canceled') { $where_btlog .= " AND `arm_status`='2'"; } } $sqlLimit = ''; if (!empty($limit) && $limit != 0) { $sqlLimit = "LIMIT {$limit}"; } $logs = $wpdb->get_results("SELECT * FROM `".$ARMember->tbl_arm_bank_transfer_log."` $where_btlog ORDER BY `arm_created_date` DESC {$sqlLimit}"); if (!empty($logs)) { foreach ($logs as $l) { $bt_logs[] = $this->arm_convert_bt_to_main_log($l); } } } } return $bt_logs; } function arm_convert_bt_to_main_log($data) { $main_logs = array(); if (!empty($data)) { $lStatus = 'pending'; if ($data->arm_status == '1') { $lStatus = 'success'; } if ($data->arm_status == '2') { $lStatus = 'canceled'; } $main_log = array( 'arm_log_id' => $data->arm_log_id, 'arm_invoice_id' => $data->arm_invoice_id, 'arm_user_id' => $data->arm_user_id, 'arm_plan_id' => $data->arm_plan_id, 'arm_payment_gateway' => 'bank_transfer', 'arm_payment_type' => 'one_time', 'arm_token' => '', 'arm_payer_email' => $data->arm_payer_email, 'arm_receiver_email' => '', 'arm_transaction_id' => $data->arm_transaction_id, 'arm_transaction_payment_type' => '', 'arm_transaction_status' => $lStatus, 'arm_payment_date' => $data->arm_created_date, 'arm_amount' => $data->arm_amount, 'arm_currency' => $data->arm_currency, 'arm_response_text' => maybe_serialize($data), 'arm_extra_vars' => maybe_unserialize($data->arm_extra_vars), 'arm_created_date' => $data->arm_created_date ); } return $main_log; } function arm_change_bank_transfer_status($log_id = 0, $new_status = 0) { global $wp, $wpdb, $current_user, $arm_errors, $ARMember, $arm_global_settings, $arm_subscription_plans, $arm_capabilities_global; $ARMember->arm_check_user_cap($arm_capabilities_global['arm_manage_transactions'], '1'); $logid_exit_flag = '1'; if(empty($log_id)) { $log_id = intval($_POST['log_id']); $logid_exit_flag = ''; } if(empty($new_status)) { $new_status = sanitize_text_field($_POST['log_status']); } $response = array('status' => 'error', 'message' => __('Sorry, Something went wrong. Please try again.', 'ARMember')); if (!empty($log_id) && $log_id != 0) { $log_data = $wpdb->get_row("SELECT `arm_log_id`, `arm_user_id`, `arm_plan_id`, `arm_payment_cycle` FROM `" . $ARMember->tbl_arm_bank_transfer_log . "` WHERE `arm_log_id`='" . $log_id . "'"); if(!empty($log_data)) { $user_id = $log_data->arm_user_id; $plan_id = $log_data->arm_plan_id; $payment_cycle = $log_data->arm_payment_cycle; if ($new_status == '1') { $nowDate = current_time('mysql'); $arm_last_payment_status = $wpdb->get_var($wpdb->prepare("SELECT `arm_transaction_status` FROM `" . $ARMember->tbl_arm_payment_log . "` WHERE `arm_user_id`=%d AND `arm_plan_id`=%d AND `arm_created_date`<=%s ORDER BY `arm_log_id` DESC LIMIT 0,1", $user_id, $plan_id, $nowDate)); $arm_subscription_plans->arm_update_user_subscription_for_bank_transfer($user_id, $plan_id, 'bank_transfer', $payment_cycle, $arm_last_payment_status); $wpdb->update($ARMember->tbl_arm_bank_transfer_log, array('arm_status' => 1), array('arm_log_id' => $log_id)); do_action('arm_after_accept_bank_transfer_payment',$user_id,$plan_id); $response = array('status' => 'success', 'message' => __('Bank transfer request has been approved.', 'ARMember')); } else { delete_user_meta($user_id, 'arm_change_plan_to'); $wpdb->update($ARMember->tbl_arm_bank_transfer_log, array('arm_status' => 2), array('arm_log_id' => $log_id)); do_action('arm_after_decline_bank_transfer_payment',$user_id,$plan_id); $response = array('status' => 'success', 'message' => __('Bank transfer request has been cancelled.', 'ARMember')); } } } if(empty($logid_exit_flag)) { echo json_encode($response); exit; } } function arm_get_transaction_status_text($statuses = '') { $statusClass = 'active'; $lStatus = 'success'; switch ($statuses) { case 'success': $statusClass = 'active'; $lStatus = __('success', 'ARMember'); break; case 'pending': $statusClass = 'pending'; $lStatus = __('pending', 'ARMember'); break; case 'canceled': case 'cancelled': $statusClass = 'canceled'; $lStatus = __('cancelled', 'ARMember'); break; case 'failed': $statusClass = 'failed'; $lStatus = __('failed', 'ARMember'); break; case 'expired': $statusClass = 'expired'; $lStatus = __('expired', 'ARMember'); break; default: break; } return '' . ucfirst($lStatus) . ''; } function arm_load_transaction_grid() { global $wpdb, $ARMember, $arm_slugs, $arm_members_class, $arm_global_settings, $arm_payment_gateways, $arm_subscription_plans, $armlite_default_user_details_text, $arm_capabilities_global; $ARMember->arm_check_user_cap($arm_capabilities_global['arm_manage_transactions'], '1'); $date_format = $arm_global_settings->arm_get_wp_date_format(); $date_time_format = $arm_global_settings->arm_get_wp_date_time_format(); $global_currency = $arm_payment_gateways->arm_get_global_currency(); $filter_gateway = isset($_REQUEST['gateway']) ? $_REQUEST['gateway'] : ''; $filter_ptype = isset($_REQUEST['payment_type']) ? $_REQUEST['payment_type'] : ''; $filter_pmode = isset($_REQUEST['payment_mode']) ? $_REQUEST['payment_mode'] : ''; $filter_pstatus = isset($_REQUEST['payment_status']) ? $_REQUEST['payment_status'] : ''; $payment_start_date = isset($_REQUEST['payment_start_date']) ? $_REQUEST['payment_start_date'] : ''; $payment_end_date = isset($_REQUEST['payment_end_date']) ? $_REQUEST['payment_end_date'] : ''; $response_data = array(); $nowDate = current_time('mysql'); $where_plog = "WHERE 1=1 AND arm_display_log = 1 "; if (!empty($filter_gateway) && $filter_gateway != '0') { $where_plog .= " AND `arm_payment_gateway`='$filter_gateway'"; } if (!empty($filter_ptype) && $filter_ptype != '0') { $where_plog .= " AND `arm_payment_type`='$filter_ptype'"; } if (!empty($filter_pmode) && $filter_pmode != '0') { $where_plog .= " AND `arm_payment_mode`='$filter_pmode'"; } if (!empty($filter_pstatus) && $filter_pstatus != '0') { $filter_pstatus = strtolower($filter_pstatus); $status_query = " AND ( LOWER(`arm_transaction_status`)='$filter_pstatus'"; if( !in_array($filter_pstatus,array('success','pending','canceled')) ){ $status_query .= ")"; } switch ($filter_pstatus) { case 'success': $status_query .= " OR `arm_transaction_status`='1')"; break; case 'pending': $status_query .= " OR `arm_transaction_status`='0')"; break; case 'canceled': $status_query .= " OR `arm_transaction_status`='2')"; break; } $where_plog .= $status_query; } $total_count = $wpdb->get_results('SELECT COUNT(*) as total_logs FROM `' . $ARMember->tbl_arm_payment_log . '`'); $fbt_logs = $this->arm_get_bank_transfer_logs(0, 0, 0); $total_fpaylog = $total_count[0]->total_logs; $total_fbtlog = count($fbt_logs); $total_counter = $total_fpaylog + $total_fbtlog; $sorting_ord = isset($_REQUEST['sSortDir_0']) ? strtoupper($_REQUEST['sSortDir_0']) : 'DESC'; $sorting_col = (isset($_REQUEST['iSortCol_0']) && $_REQUEST['iSortCol_0'] > 0) ? $_REQUEST['iSortCol_0'] : ''; if( isset($_REQUEST['iSortCol_0']) && $_REQUEST['iSortCol_0'] == 0){ $sorting_ord = 'DESC'; } $offset = isset($_REQUEST['iDisplayStart']) ? $_REQUEST['iDisplayStart'] : 0; $limit = isset($_REQUEST['iDisplayLength']) ? $_REQUEST['iDisplayLength'] : 10; $phlimit = " LIMIT {$offset},{$limit}"; switch ($sorting_col) { case 1: $column_name = "`arm_transaction_id`"; break; case 2: $column_name = "`first_name`"; break; case 3: $column_name = "`last_name`"; break; case 5: $column_name = "`arm_subscription_plan_name`"; break; case 6: $column_name = "`arm_payment_gateway`"; break; case 7: $column_name = "`arm_payment_type`"; break; case 8: $column_name = "`arm_payer_email`"; break; case 9: $column_name = "`arm_transaction_status`"; break; case 10: $column_name = "`arm_created_date`"; break; case 11: $column_name = "`arm_amount`"; break; default: $column_name = "`arm_created_date`"; break; } $orderby = "ORDER BY `arm_payment_history_log`.{$column_name} {$sorting_ord}"; $sSearch = isset($_REQUEST['sSearch']) ? $_REQUEST['sSearch'] : ''; $search_ = ""; if ($sSearch != '') { $search_ = " AND (`arm_payment_history_log`.`arm_transaction_id` LIKE '%{$sSearch}%' OR `arm_payment_history_log`.`arm_payer_email` LIKE '%{$sSearch}%' OR `arm_payment_history_log`.`arm_created_date` LIKE '%{$sSearch}%' ) "; } $pt_where = $bt_where = ""; if(!empty($payment_start_date)) { $payment_start_date = date("Y-m-d", strtotime($payment_start_date)); $pt_where .= " WHERE `pt`.`arm_created_date` >= '$payment_start_date' "; $bt_where .= " WHERE `bt`.`arm_created_date` >= '$payment_start_date' "; } if(!empty($payment_end_date)) { $payment_end_date = date("Y-m-d", strtotime("+1 day", strtotime($payment_end_date))); if($pt_where != "") $pt_where .= " AND "; else $pt_where = " WHERE "; $pt_where .= " `pt`.`arm_created_date` < '$payment_end_date' "; if($bt_where != "") $bt_where .= " AND "; else $bt_where = " WHERE "; $bt_where .= " `bt`.`arm_created_date` < '$payment_end_date' "; } $ctquery = "SELECT pt.arm_log_id,pt.arm_invoice_id,pt.arm_user_id,pt.arm_plan_id,pt.arm_payer_email,pt.arm_transaction_id,pt.arm_amount,pt.arm_currency,pt.arm_is_trial,pt.arm_payment_gateway,pt.arm_payment_mode,pt.arm_transaction_status,pt.arm_created_date,pt.arm_payment_type,pt.arm_extra_vars,sp.arm_subscription_plan_name,wpu.user_login as arm_user_login,pt.arm_display_log as arm_display_log FROM `" . $ARMember->tbl_arm_payment_log . "` pt LEFT JOIN `" . $ARMember->tbl_arm_subscription_plans . "` sp ON pt.arm_plan_id = sp.arm_subscription_plan_id LEFT JOIN `" . $wpdb->users . "` wpu ON pt.arm_user_id = wpu.ID ".$pt_where; $ptquery = "{$ctquery}"; $cbquery = "SELECT bt.arm_log_id,bt.arm_invoice_id,bt.arm_user_id,bt.arm_plan_id,bt.arm_payer_email,bt.arm_transaction_id,bt.arm_amount,bt.arm_currency,bt.arm_is_trial,'bank_transfer' as arm_payment_gateway,bt.arm_payment_mode, bt.arm_status as arm_transaction_status,bt.arm_created_date,'one_time' as arm_payment_type,'' as arm_extra_vars,sp.arm_subscription_plan_name,wpu.user_login as arm_user_login,bt.arm_display_log as arm_display_log FROM `" . $ARMember->tbl_arm_bank_transfer_log . "` bt LEFT JOIN `" . $ARMember->tbl_arm_subscription_plans . "` sp ON bt.arm_plan_id = sp.arm_subscription_plan_id LEFT JOIN `" . $wpdb->users . "` wpu ON bt.arm_user_id = wpu.ID".$bt_where; $btquery = "{$cbquery}"; $total_payment_rows = "SELECT (SELECT COUNT(*) FROM `".$ARMember->tbl_arm_payment_log."` WHERE `arm_display_log` = 1) as total_payment_log, (SELECT COUNT(*) FROM `".$ARMember->tbl_arm_bank_transfer_log."` WHERE `arm_display_log` = 1) as total_bank_log"; $payment_rows = $wpdb->get_results($total_payment_rows); $before_filter = intval($payment_rows[0]->total_payment_log) + intval($payment_rows[0]->total_bank_log); $payment_logs_before_limit = "SELECT COUNT(*) AS total_payments FROM (" . $ptquery . " UNION " . $btquery . ") AS arm_payment_history_log {$where_plog} {$search_} {$orderby}"; $ex_query = $wpdb->get_results($payment_logs_before_limit); $after_filter = intval($ex_query[0]->total_payments); $payment_grid_query = "SELECT * FROM (" . $ptquery . " UNION " . $btquery . ") AS arm_payment_history_log {$where_plog} {$search_} {$orderby} {$phlimit}"; $phquery = $wpdb->get_results($payment_grid_query, ARRAY_A); $payment_log = $phquery; if (!empty($payment_log)) { $effectiveData = array(); $ai = 0; foreach ($payment_log as $rc) { $rc = (object) $rc; $transactionID = $rc->arm_log_id; $arm_transaction_status = $rc->arm_transaction_status; switch ($arm_transaction_status) { case '0': $arm_transaction_status = 'pending'; break; case '1': $arm_transaction_status = 'success'; break; case '2': $arm_transaction_status = 'canceled'; break; default: $arm_transaction_status = $rc->arm_transaction_status; break; } $log_type = ($rc->arm_payment_gateway == 'bank_transfer') ? 'bt_log' : 'other'; $extraVars = (isset($rc->arm_extra_vars)) ? maybe_unserialize($rc->arm_extra_vars) : array(); if ($rc->arm_payment_gateway == 'bank_transfer'): $response_data[$ai][0] = ''; else: $response_data[$ai][0] = ''; endif; $response_data[$ai][1] = (!empty($rc->arm_transaction_id)) ? $rc->arm_transaction_id : __('Manual', 'ARMember'); $data = get_userdata($rc->arm_user_id); if (!empty($data)) { $response_data[$ai][2] = $data->first_name; $response_data[$ai][3] = $data->last_name; $response_data[$ai][4] = $data->user_login; } else { $response_data[$ai][2] = $armlite_default_user_details_text; $response_data[$ai][3] = $armlite_default_user_details_text; $response_data[$ai][4] = $armlite_default_user_details_text; } $response_data[$ai][5] = $arm_subscription_plans->arm_get_plan_name_by_id($rc->arm_plan_id); $userPlanData = get_user_meta($rc->arm_user_id, 'arm_user_plan_'.$rc->arm_plan_id, true); $change_plan = $subscr_effective = ''; if(!empty($userPlanData)){ $change_plan = $userPlanData['arm_change_plan_to']; $subscr_effective = $userPlanData['arm_subscr_effective']; } if (!isset($effectiveData[$rc->arm_user_id]) && !empty($change_plan) && $change_plan == $rc->arm_plan_id && $subscr_effective > strtotime($nowDate)) { $response_data[$ai][5] .= '
' . __('Effective from', 'ARMember') . ' ' . date_i18n($date_format, $subscr_effective) . '
'; $effectiveData[$rc->arm_user_id][] = $change_plan; } if($rc->arm_payment_gateway == '') { $payment_gateway = __('Manual', 'ARMember'); } else { $payment_gateway = $arm_payment_gateways->arm_gateway_name_by_key($rc->arm_payment_gateway); } $response_data[$ai][6] = $payment_gateway; $payment_type = $rc->arm_payment_type; $payment_type_text = ''; $plan_id = $rc->arm_plan_id; $plan_info = new ARM_Plan($plan_id); $user_payment_mode = ""; $log_payment_mode = isset($rc->arm_payment_mode) ? $rc->arm_payment_mode : ''; if( $plan_info->is_recurring() ){ if($log_payment_mode != '') { if($log_payment_mode == 'manual_subscription'){ $user_payment_mode .= ""; } else { $user_payment_mode .= "(".__('Automatic','ARMember').")"; } } $payment_type = 'subscription'; } if($payment_type =='one_time'){ $payment_type_text = __('One Time', 'ARMember'); } else if($payment_type == 'subscription'){ $payment_type_text = __('Subscription', 'ARMember'); } $arm_trial_tran = ($rc->arm_is_trial == 1) ? ' (Trial Transaction)' : ''; $response_data[$ai][7] = $payment_type_text.' '.$user_payment_mode.$arm_trial_tran; $payer_email = ''; if($rc->arm_payer_email == '') { $extra = maybe_unserialize($rc->arm_extra_vars); if($extra != '') { if(array_key_exists('manual_by',$extra)){ $payer_email = '' . __($extra['manual_by'], 'ARMember') . ''; } } } else { $payer_email = $rc->arm_payer_email; } if($payer_email=='') { $payer_email = $armlite_default_user_details_text; } $response_data[$ai][8] = $payer_email; $transStatus = $this->arm_get_transaction_status_text($arm_transaction_status); $failed_reason = (isset($extraVars['error']) && !empty($extraVars['error'])) ? $extraVars['error'] : ''; if ($rc->arm_transaction_status == 'failed' && !empty($failed_reason)) { $transStatus = '' . $transStatus . ''; } $response_data[$ai][9] = $transStatus; $response_data[$ai][10] = date_i18n($date_time_format, strtotime($rc->arm_created_date)); $rc->arm_currency = (isset($rc->arm_currency) && !empty($rc->arm_currency)) ? strtoupper($rc->arm_currency) : strtoupper($global_currency); $response_data[$ai][11] = $arm_payment_gateways->arm_amount_set_separator($rc->arm_currency, $rc->arm_amount) . ' ' . strtoupper($rc->arm_currency); $response_data[$ai][12] = (isset($extraVars['card_number']) && !empty($extraVars['card_number'])) ? $extraVars['card_number'] : '-'; $gridAction = "
"; if ($rc->arm_payment_gateway == 'bank_transfer' && $arm_transaction_status == 'pending') { $gridAction .= ""; $gridAction .= ""; } $gridAction .= ""; $gridAction .= ""; $gridAction .= $arm_global_settings->arm_get_confirm_box($transactionID, __("Are you sure you want to delete this transaction?", 'ARMember'), 'arm_transaction_delete_btn', $log_type); $gridAction .= "
"; $response_data[$ai][13] = $gridAction; $ai++; } } $columns = ',' . __('Transaction ID', 'ARMember') .',' . __('User', 'ARMember') . ',' . __('Membership', 'ARMember') . ',' . __('Gateway', 'ARMember') . ',' . __('Payment Type', 'ARMember') . ',' . __('Payer Email', 'ARMember') . ',' . __('Transaction Status', 'ARMember') . ',' . __('Payment Date', 'ARMember') . ',' . __('Amount', 'ARMember') . ',' . __('Credit Card Number', 'ARMember') . ','; $sEcho = isset($_REQUEST['sEcho']) ? intval($_REQUEST['sEcho']) : ''; $output = array( 'sColumn' => $columns, 'sEcho' => $sEcho, 'iTotalRecords' => $before_filter, // Before Filtered Records 'iTotalDisplayRecords' => $after_filter, // After filter records, 'aaData' => $response_data ); echo json_encode($output); die(); } } } global $arm_transaction; $arm_transaction = new ARM_transaction();