FileXXXXXXXXXXX

File manager - Edit - /home/verseaumee/middletvnew/wp-content/plugins/armember/core/views/arm_report_analytics.php

Back
<?php global $wp, $wpdb, $ARMember, $arm_slugs, $arm_global_settings, $arm_members_class, $arm_subscription_plans, $arm_payment_gateways, $arm_transaction, $arm_pay_per_post_feature; $all_members = $arm_members_class->arm_get_all_members_without_administrator(0,1); $recent_members = $arm_members_class->arm_get_all_members_without_administrator(1,1,1); $total_members = (!empty($all_members)) ? $all_members : 0; $general_settings = isset($arm_global_settings->global_settings) ? $arm_global_settings->global_settings : array(); $arm_currency_decimal = isset($general_settings['arm_currency_decimal_digit']) ? $general_settings['arm_currency_decimal_digit'] : 2; $current_time = current_time('mysql'); $before_week = strtotime('-6 days', strtotime($current_time)); $before_week = date('Y-m-d 00:00:00', $before_week); $current_date = date('Y-m-d 23:59:00', strtotime($current_time)); $recent_query_payment = $wpdb->prepare("SELECT SUM(arm_amount) recent_amount FROM ".$ARMember->tbl_arm_payment_log." WHERE (arm_transaction_status=%s \|\| arm_transaction_status=%s) AND arm_payment_date >= %s AND arm_payment_date <= %s AND arm_is_post_payment = %d AND arm_is_gift_payment = %d",'success','1',$before_week,$current_date,0,0); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $recent_query_payment = "SELECT IFNULL((".$recent_query_payment."),0) AS recent_amount"; $total_query = $wpdb->prepare("SELECT IFNULL((SELECT SUM(arm_amount) FROM ".$ARMember->tbl_arm_payment_log." WHERE (arm_transaction_status=%s \|\| arm_transaction_status=%s) AND arm_is_post_payment = %d AND arm_is_gift_payment =%d),0) as total_amount",'success','1', 0, 0);//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $total_payment = $wpdb->get_row($total_query);//phpcs:ignore --Reason $total_query is a query $total_payment = !empty($total_payment) ? sprintf("%.2f", $total_payment->total_amount) : sprintf("%.2f",0); $total_payment = number_format($total_payment,$arm_currency_decimal); $recent_payment = $wpdb->get_row($recent_query_payment);//phpcs:ignore --Reason $recent_query_payment is a query $recent_payment = !empty($recent_payment) ? sprintf("%.2f", $recent_payment->recent_amount) : sprintf("%.2f",0); $recent_payment = number_format($recent_payment,$arm_currency_decimal); $currency = ""; $place = ""; $all_global_settings = $arm_global_settings->arm_get_all_global_settings(); if(!empty($all_global_settings)) { $general_settings = $all_global_settings['general_settings']; $global_currency = $arm_payment_gateways->arm_get_global_currency(); $all_currency = $arm_payment_gateways->arm_get_all_currencies(); $currency = $all_currency[strtoupper($global_currency)]; //$currency = $general_settings['paymentcurrency']; $place = isset($general_settings['custom_currency']['place']) ? $general_settings['custom_currency']['place'] : 'prefix'; $total_payment = ('sufix' == $place) ? $total_payment." ".$currency : $currency." ".$total_payment; $recent_payment = ('sufix' == $place) ? $recent_payment." ".$currency : $currency." ".$recent_payment; } global $arm_members_activity; $setact = 0; global $check_sorting; $setact = $arm_members_activity->$check_sorting(); ?> <div class="wrap arm_page arm_report_analytics_main_wrapper"> <?php if ($setact != 1) { if($ARMember->arm_licence_notice_status()){ $admin_css_url = admin_url('admin.php?page=arm_manage_license'); $nonce = wp_create_nonce('arm_wp_nonce'); ?> <div class="armember_notice_warning armember_licence_notice_warning">ARMember License is not activated. Please activate license from <a href="<?php echo esc_url($admin_css_url); ?>">here</a><span class="armember_close_licence_notice_icon" id="armember_close_licence_notice_icon" data-nonce="<?php echo $nonce;?>" data-type="armember" title="<?php esc_html_e('Dismiss for 7 days', 'ARMember'); ?>"></span></div> <?php } } ?> <div class="content_wrapper arm_report_analytics_content" id="content_wrapper"> <div class="popup_header arm_member_popup_header_wrapper arm_border_bottom_0"> <div class="page_title"> <?php esc_html_e('Reports','ARMember');?> </div> </div> <div class="arm_report_summary_text arm_padding_left_64 arm_padding_right_64"> <div class="arm_report_member_summary"> <a href="<?php echo esc_url( admin_url('admin.php?page='.$arm_slugs->report_analytics.'&action=member_report') );?>" class="welcome-icon"> <div class="arm_total_members arm_member_summary"> <div class="arm_member_summary_label"><?php esc_html_e('Total Members', 'ARMember');?></div> <div class="arm_member_summary_count"> <div class="arm_member_summery_icon_wrapper"> <img class="arm_member_summery_icon" src="<?php echo MEMBERSHIP_IMAGES_URL; //phpcs:ignore?>/arm_total_members_icon.svg" alt="<?php esc_html_e('Total Members', 'ARMember');?>"> </div> <div class="arm_member_summary_count"><?php echo esc_html($total_members);?></div> </div> </div> </a> <a href="<?php echo esc_url( admin_url('admin.php?page='.$arm_slugs->report_analytics.'&action=member_report') );?>" class="welcome-icon"> <div class="arm_active_members arm_member_summary"> <div class="arm_member_summary_label"><?php echo sprintf(esc_html__('Recent Members %slast week%s', 'ARMember'),'(',')'); //phpcs:ignore?></div> <div class="arm_member_summary_count"> <div class="arm_member_summery_icon_wrapper"> <img class="arm_member_summery_icon" src="<?php echo MEMBERSHIP_IMAGES_URL; //phpcs:ignore?>/arm_recent_members_icon.svg" alt="<?php esc_html_e('Recent Members', 'ARMember');?>"> </div> <div class="arm_member_summary_count"><?php echo esc_html($recent_members);?></div> </div> </div> </a> <a href="<?php echo esc_url(admin_url('admin.php?page='.$arm_slugs->report_analytics.'&action=payment_report') );?>" class="welcome-icon"> <div class="arm_inactive_members arm_member_summary"> <div class="arm_member_summary_label"><?php esc_html_e('Total Payments', 'ARMember');?></div> <div class="arm_member_summary_count"> <div class="arm_member_summery_icon_wrapper"> <img class="arm_member_summery_icon" src="<?php echo MEMBERSHIP_IMAGES_URL; //phpcs:ignore?>/arm_total_payments_icon.svg" alt="<?php esc_html_e('Total Payments', 'ARMember');?>"> </div> <div class="arm_member_summary_count"><?php echo esc_html($total_payment);?></div> </div> </div> </a> <a href="<?php echo esc_url(admin_url('admin.php?page='.$arm_slugs->report_analytics.'&action=payment_report') );?>" class="welcome-icon"> <div class="arm_membership_plans arm_member_summary"> <div class="arm_member_summary_label"><?php echo sprintf(esc_html__('Recent Payments %slast week%s', 'ARMember'),'(',')'); //phpcs:ignore?></div> <div class="arm_member_summary_count"> <div class="arm_member_summery_icon_wrapper"> <img class="arm_member_summery_icon" src="<?php echo MEMBERSHIP_IMAGES_URL; //phpcs:ignore?>/arm_recent_payments_icon.svg" alt="<?php echo sprintf(esc_html__('Recent Payments %slast week%s', 'ARMember'),'(',')');?>"> </div> <div class="arm_member_summary_count"><?php echo esc_html($recent_payment);?></div> </div> </div> </a> </div> <div class= "arm_report_member_summary_cards"> <div class="arm_half_section"> <div class="page_title"> <?php esc_html_e('Recent Members','ARMember');?> </div> <?php $recent_entries_display_numberof='5'; $type = 'monthly'; $graph_type = 'line'; $is_export_to_csv = false; $is_pagination = false; $recent_month = date('m', strtotime($current_time)); $recent_year = date('Y', strtotime($current_time)); if(empty($_REQUEST)) { $_REQUEST = array(); } $_REQUEST['type'] ='monthly'; $_REQUEST['graph_type'] ='line'; $_REQUEST['plan_type'] = 'members'; $_REQUEST['plan_id'] = ''; $_REQUEST['year_filter'] = date('Y', strtotime($current_time)); $_REQUEST['month_filter'] = date('m', strtotime($current_time)); $_REQUEST['date_filter'] = ''; $_REQUEST['gateway_filter'] =''; $_REQUEST['current_page'] = 1; $arm_disable_next_prev_btn = 1; include(MEMBERSHIP_VIEWS_DIR . '/arm_graph_ajax.php'); $arm_recent_members = array(); $user_arg = array( 'orderby' => 'ID', 'order' => 'DESC', 'number' => $recent_entries_display_numberof, 'role__not_in' => 'administrator', 'date_query'=>array('year' =>$new_month_year,'month' =>$new_month) ); $arm_recent_members = get_users($user_arg); ?> </div> <div class="arm_half_section"> <div class="page_title"> <?php esc_html_e('Recent Member Payments','ARMember');?> </div> <?php $type = 'monthly'; $graph_type = 'line'; $is_export_to_csv = false; $is_pagination = false; if(empty($_REQUEST)) { $_REQUEST = array(); } $_REQUEST['type'] ='monthly'; $_REQUEST['graph_type'] ='line'; $_REQUEST['plan_type'] = 'payment_history'; $_REQUEST['plan_id'] = ''; $_REQUEST['year_filter'] = $recent_year; $_REQUEST['month_filter'] = $recent_month; $_REQUEST['date_filter'] = ''; $_REQUEST['gateway_filter'] =''; $_REQUEST['current_page'] = 1; $arm_disable_next_prev_btn = 1; include(MEMBERSHIP_VIEWS_DIR . '/arm_graph_ajax.php'); $payment_log = $wpdb->get_results( $wpdb->prepare("SELECT * FROM `".$ARMember->tbl_arm_payment_log."` WHERE YEAR( arm_created_date ) = %s AND MONTH( arm_created_date ) = %s ORDER BY `arm_created_date` DESC",$recent_year,$recent_month), ARRAY_A); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $transactions = array(); if (!empty($payment_log)) { $i = 0; foreach ($payment_log as $log) { $date = strtotime($log['arm_created_date']); if (isset($newLog[$date]) && !empty($newLog[$date])) { $date += $i; $transactions[$date] = $log; } else { $transactions[$date] = $log; } $i++; } krsort($transactions); } ?> <?php $wpnonce = wp_create_nonce( 'arm_wp_nonce' );?> <input type="hidden" name="arm_wp_nonce" value="<?php echo esc_attr($wpnonce);?>"/> </div> <div class="arm_half_section"> <div class="page_title"> <?php esc_html_e('Recent Member List','ARMember');?> </div> <div class="armclear"></div> <div class="arm_recent_members_container arm_report_analytics_inner_content"> <table cellpadding="0" cellspacing="0" border="0" id="arm_recent_members_table" class="display"> <thead> <tr> <th align="left" width="30%"><?php esc_html_e('User Name', 'ARMember');?></th> <th align="left" width="40%"><?php esc_html_e('Email', 'ARMember');?></th> <th align="left" width="30%"><?php esc_html_e('Membership', 'ARMember');?></th> </tr> </thead> <tbody> <?php if (!empty($arm_recent_members)) { foreach($arm_recent_members as $recent_member):?> <tr> <td width="30%"><a href="javascript:void(0)" class="arm_openpreview_popup" data-id="<?php echo esc_attr($recent_member->ID);?>" data-arm_hide_edit='1'><?php echo esc_html($recent_member->user_login);?></a></td> <td width="40%"><?php echo esc_html($recent_member->user_email);?></td> <td width="30%"><?php $plan_ids = get_user_meta($recent_member->ID, 'arm_user_plan_ids', true); $paid_post_ids = get_user_meta($recent_member->ID, 'arm_user_post_ids', true); if(!empty($paid_post_ids)) { foreach($plan_ids as $key => $val) { if(!empty($paid_post_ids[$val])) { unset($plan_ids[$key]); } } } $arm_gift_ids = get_user_meta($recent_member->ID, 'arm_user_gift_ids', true); if(!empty($arm_gift_ids)) { foreach($plan_ids as $arm_plan_key => $arm_plan_val) { if(in_array($arm_plan_val, $arm_gift_ids)) { unset($plan_ids[$arm_plan_key]); } } } $plan_name = $arm_subscription_plans->arm_get_comma_plan_names_by_ids($plan_ids); echo (!empty($plan_name)) ? esc_html(stripslashes($plan_name)) : '<span class="arm_empty">--</span>'; ?></td> </tr> <?php endforeach; }else { ?> <tr><td colspan="3" class="center"><?php esc_html_e('There is no any recent members found.', 'ARMember');?></td></tr> <?php } ?> </tbody> </table> </div> <div class="armclear"></div> </div> <div class="arm_half_section"> <div class="page_title"> <?php esc_html_e('Recent Member Payments List','ARMember');?> </div> <div class="armclear"></div> <div class="arm_recent_transactions_content arm_report_analytics_inner_content"> <table cellpadding="0" cellspacing="0" border="0" id="arm_recent_transactions_table" class="display"> <thead> <tr> <th align="left" width="30%"><?php esc_html_e('User', 'ARMember');?></th> <th align="left" width="30%"><?php esc_html_e('Membership', 'ARMember');?></th> <th class="arm_align_right" width="20%"><?php esc_html_e('Amount', 'ARMember');?></th> <th align="center" width="20%"><?php esc_html_e('Status', 'ARMember');?></th> </tr> </thead> <tbody> <?php if (!empty($transactions)) { $global_currency = $arm_payment_gateways->arm_get_global_currency(); $all_currencies = $arm_payment_gateways->arm_get_all_currencies(); $global_currency_sym = $all_currencies[strtoupper($global_currency)]; $j = 1;foreach($transactions as $recent_transaction): $recent_transaction = (object) $recent_transaction;?> <?php if ($j > $recent_entries_display_numberof) { continue; } $j++; ?> <tr> <td width="30%"><a href="javascript:void(0)" class="arm_openpreview_popup" data-id="<?php echo esc_attr($recent_transaction->arm_user_id);?>" data-arm_hide_edit='1'><?php $data = get_userdata($recent_transaction->arm_user_id); if (!empty($data)) { echo esc_html($data->user_login); } ?></a></td> <td width="30%"><?php $plan_name = $arm_subscription_plans->arm_get_plan_name_by_id($recent_transaction->arm_plan_id); echo (!empty($plan_name)) ? esc_html($plan_name) : '<span class="arm_empty">--</span>'; ?></td> <td class="arm_align_right" width="20%"><?php if (!empty($recent_transaction->arm_amount) && $recent_transaction->arm_amount > 0 ) { $t_currency = isset($recent_transaction->arm_currency) ? strtoupper($recent_transaction->arm_currency) : strtoupper($global_currency); $currency = (isset($all_currencies[$t_currency])) ? $all_currencies[$t_currency] : $global_currency_sym; echo $arm_payment_gateways->arm_prepare_amount($recent_transaction->arm_currency, $recent_transaction->arm_amount); //phpcs:ignore if ($global_currency_sym == $currency && strtoupper($global_currency) != $t_currency) { echo ' ('. esc_html($t_currency) .')'; } } else { echo $arm_payment_gateways->arm_prepare_amount($recent_transaction->arm_currency, $recent_transaction->arm_amount); //phpcs:ignore } $arm_transaction_status = $recent_transaction->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 = $recent_transaction->arm_transaction_status; break; } ?></td> <td width="20%"><?php echo $arm_transaction->arm_get_transaction_status_text($arm_transaction_status); //phpcs:ignore?></td> </tr> <?php endforeach; }else { ?> <tr><td colspan="4" class="center"><?php esc_html_e('There is no any recent transactions found.', 'ARMember');?></td></tr> <?php } ?> </tbody> </table> </div> <div class="armclear"></div> <?php $wpnonce = wp_create_nonce( 'arm_wp_nonce' );?> <input type="hidden" name="arm_wp_nonce" value="<?php echo esc_attr($wpnonce);?>"/> </div> </div> </div> </div> </div> <?php require_once(MEMBERSHIPLITE_VIEWS_DIR.'/arm_view_member_details.php')?> <?php echo $ARMember->arm_get_need_help_html_content('members-report-analysis'); //phpcs:ignore ?>

| ver. 1.4 | Github | . | PHP 8.5.7 | Generation time: 0 | proxy | phpinfo | Settings