FileXXXXXXXXXXX

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

Back
<?php global $wpdb, $ARMember, $arm_global_settings, $arm_subscription_plans,$arm_payment_gateways, $arm_report_analytics, $arm_pay_per_post_feature, $arm_default_user_details_text; $new_day = $new_month = $new_month_year = $new_year = $new_day_month = $new_day_year = ''; $plan_type = isset($_REQUEST['plan_type']) && !empty($_REQUEST['plan_type']) ? sanitize_text_field($_REQUEST['plan_type']) : ''; $current_time = current_time('timestamp'); $current_month = date('m', $current_time); $current_year = date('Y', $current_time); $current_date = date('Y-m-d', $current_time); $global_currency = $arm_payment_gateways->arm_get_global_currency(); $all_currency = $arm_payment_gateways->arm_get_all_currencies(); $currency_symbol = $all_currency[strtoupper($global_currency)]; $date_format = $arm_global_settings->arm_get_wp_date_format(); $is_export_to_csv = isset($is_export_to_csv) ? $is_export_to_csv : ''; if (empty($plan_type)) return; $graph_type = (isset($_REQUEST['graph_type']) && $_REQUEST['graph_type'] != 'undefined') ? sanitize_text_field($_REQUEST['graph_type']) : 'line'; $type = isset($_REQUEST['type']) ? sanitize_text_field($_REQUEST['type']) : ''; $filter_plan_id = isset($_REQUEST['plan_id']) ? intval($_REQUEST['plan_id']) : ''; $filter_year = isset($_REQUEST['year_filter']) ? intval($_REQUEST['year_filter']) : $current_year; $filter_month = isset($_REQUEST['month_filter']) ? intval($_REQUEST['month_filter']) : $current_month; $filter_date = isset($_REQUEST['date_filter']) ? sanitize_text_field($_REQUEST['date_filter']) : ''; $gateway_filter = isset($_REQUEST['gateway_filter']) ? sanitize_text_field($_REQUEST['gateway_filter']) : ""; $current_page = isset($_REQUEST['current_page']) ? intval($_REQUEST['current_page']) : 1; $arm_search_coupon = isset($_REQUEST['arm_search_coupon']) ? sanitize_text_field($_REQUEST['arm_search_coupon']) : ''; if (isset($_REQUEST['calculate']) && $_REQUEST['calculate'] != '' && ($_REQUEST['calculate'] == 'next' \|\| $_REQUEST['calculate'] == 'pre')) { if (isset($_REQUEST['new_year']) && $_REQUEST['new_year'] != '') { $filter_year = $new_year = intval($_REQUEST['new_year']); } elseif (isset($_REQUEST['new_month']) && $_REQUEST['new_month'] != '') { $filter_month = $new_month = intval($_REQUEST['new_month']); $new_month_year = intval($_REQUEST['new_month_year']);//phpcs:ignore } elseif (isset($_REQUEST['new_day']) && $_REQUEST['new_day'] != '') { $new_day = intval($_REQUEST['new_day']);//phpcs:ignore $new_day_month = intval($_REQUEST['new_day_month']);//phpcs:ignore $new_day_year = intval($_REQUEST['new_day_year']);//phpcs:ignore } } else { $new_year = date('Y', $current_time); $new_month = date('m', $current_time); $new_month_year = date('Y', $current_time); $new_day = date('d'); $new_day_month = date('m'); $new_day_year = date('Y'); } if(!empty($filter_date) && (!isset($_REQUEST['new_day']))) { $filter_date_exp = explode("-", $filter_date); $new_day = $filter_date_exp[2]; $new_day_month = $filter_date_exp[1]; $new_day_year = $filter_date_exp[0]; } else { if(!empty($filter_month) && !isset($_REQUEST['new_month'])) { $monthName = $filter_month; $new_month = $filter_month; } if(!empty($filter_year) && !isset($_REQUEST['new_year']) && $type != 'monthly') { $new_month_year = $filter_year; $new_year = $filter_year; } if($type == "daily" && $is_export_to_csv == '1') { $new_day = intval($_REQUEST['current_day']);//phpcs:ignore $new_day_month = intval($_REQUEST['current_day_month']);//phpcs:ignore $new_day_year = intval($_REQUEST['current_day_year']);//phpcs:ignore } } $min_year = date('Y', $current_time); $min_month = date('m', $current_time); $min_date = date('d', $current_time); $user_table = $wpdb->users; $usermeta_table = $wpdb->usermeta; if ($plan_type == "members") { $wp_date_time_format = ""; if (is_multisite()) { $wp_date_time_format = get_option('date_format') . " " . get_option('time_format'); } else { $wp_date_time_format = get_site_option('date_format') . " " . get_site_option('time_format'); } $min_full_date = $wpdb->get_var("SELECT min(user_registered) FROM `{$user_table}`"); //phpcs:ignore --Reason $user_table is a table name and query witout where clause if (!empty($min_full_date)) { $min_month = date('m', strtotime($min_full_date)); $min_date = date('d', strtotime($min_full_date)); } $capability_column = $wpdb->get_blog_prefix($GLOBALS['blog_id']) . 'capabilities'; $super_admin_ids = array(); if (is_multisite()) { $super_admin = get_super_admins(); if (!empty($super_admin)) { foreach ($super_admin as $skey => $sadmin) { if ($sadmin != '') { $user_obj = get_user_by('login', $sadmin); if ($user_obj->ID != '') { $user = get_user_by('id', $user_id); if((!empty($user_roles) && !in_array('administrator',$user_roles))) { $super_admin_ids[] = $user_obj->ID; } } } } } } $join_clause = ""; $user_where = " WHERE 1=1"; if (!empty($super_admin_ids)) { $super_admin_placeholders = ' AND u.ID IN ('; $super_admin_placeholders .= rtrim( str_repeat( '%s,', count( $super_admin_ids ) ), ',' ); $super_admin_placeholders .= ')'; array_unshift( $super_admin_ids, $super_admin_placeholders ); // $user_where .= ' AND u.ID NOT IN (' . implode( ',', $super_admin_ids ) . ')'; $user_where .= call_user_func_array(array( $wpdb, 'prepare' ), $super_admin_ids ); } if(!empty($filter_plan_id)) { $arm_user_table = $ARMember->tbl_arm_members; $join_clause = " LEFT JOIN `{$arm_user_table}` armu ON u.ID = armu.arm_user_id"; $user_where .= $wpdb->prepare(" AND ( armu.arm_user_plan_ids LIKE %s OR armu.arm_user_plan_ids LIKE %s)","%{$filter_plan_id}%",'%i:'.$filter_plan_id.'%'); } $operator = " AND "; $user_where .= $operator; $user_where .= $wpdb->prepare(" um.meta_key = %s AND um.meta_value NOT LIKE %s ",$capability_column,'%administrator%'); if ($type == "yearly") { $from_year = "{$new_year}-01-01 00:00:00"; $end_year = "{$new_year}-12-31 23:59:59"; $day_arr = $wpdb->get_results( $wpdb->prepare("SELECT YEAR(u.user_registered) AS Year, MONTH(u.user_registered) AS Month,COUNT() AS total FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered >= %s AND u.user_registered <= %s Group By YEAR(u.user_registered), MONTH(u.user_registered) ORDER BY u.user_registered DESC",$from_year,$end_year), 'ARRAY_A'); //phpcs:ignore --Reason $user_table and $usermeta_table is a table name $arm_max_year_entry = 0; if (count($day_arr) > 0) { $totalRec = count($day_arr); foreach ($day_arr as $arr_month) { $month[$arr_month['Month']] = $arr_month['total']; } $arm_max_year_entry = 0; foreach ($month as $key => $val) { $arm_max_year_entry = max($arm_max_year_entry, $val); } if ($arm_max_year_entry < 5) $arm_max_year_entry = $arm_max_year_entry; } $arm_max_year = 0; if ($arm_max_year_entry < 5) { $arm_max_year = 5; } $arm_disable_class_next = ''; $arm_enable_next = 1; if ($new_year >= date('Y', $current_time)) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $arm_disable_class_prev = ''; $arm_enable_prev = 1; /if ($new_year <= $min_year) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; }/ $monthToDisplay = ''; for ($i = 1; $i <= 12; $i++) { if (empty($month[$i])) { if ($i == 12) $monthToDisplay .= 0; else $monthToDisplay .= "0,"; }else { if ($i == 12) $monthToDisplay .= $month[$i]; else $monthToDisplay .= $month[$i] . ","; } } /for data table/ $table_data_arr = array(); $table_data_cnt = 0; $perPage = 10; $offset = ($current_page - 1) $perPage; if($type == "yearly") { $first_day = $from_year; $last_day = $end_year; $table_data_cnt = $wpdb->get_results( $wpdb->prepare("SELECT count(u.ID) FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered BETWEEN %s AND %s GROUP BY u.ID ORDER BY u.user_registered DESC",$first_day,$last_day), 'ARRAY_A');//phpcs:ignore --Reason user_table is a table name if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $table_data_arr = $wpdb->get_results( $wpdb->prepare("SELECT u.ID,u.user_registered,u.user_login,u.user_email FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered BETWEEN %s AND %s GROUP BY u.ID ORDER BY u.user_registered DESC",$first_day,$last_day), 'ARRAY_A'); //phpcs:ignore --Reason $user_table and $usermeta_table is a table name } else { $table_data_arr = $wpdb->get_results( $wpdb->prepare("SELECT u.ID,u.user_registered,u.user_login,u.user_email FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered BETWEEN %s AND %s GROUP BY u.ID ORDER BY u.user_registered DESC LIMIT ".$perPage." OFFSET ".$offset,$first_day,$last_day), 'ARRAY_A'); //phpcs:ignore --Reason $user_table and $usermeta_table is a table name } $table_data_cnt = count($table_data_cnt); $dataPaging = $arm_global_settings->arm_get_paging_links($current_page, $table_data_cnt, $perPage, ''); } $table_content_html = ""; $tab_row_cnt = 0; $arm_charts_plan_data=array(); $table_data_cnt_arr = $wpdb->get_results( $wpdb->prepare("SELECT u.ID,u.user_registered,u.user_login,u.user_email FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered BETWEEN %s AND %s GROUP BY u.ID ORDER BY u.user_registered DESC",$first_day,$last_day), 'ARRAY_A'); //phpcs:ignore --Reason $user_table and $usermeta_table is a table name if(!empty($table_data_cnt_arr)) { foreach($table_data_cnt_arr as $key => $table_data_cnt_val) { // $arm_registered_date = date_i18n($wp_date_time_format, strtotime($table_data_cnt_val['user_registered'])); $arm_registered_date = get_date_from_gmt( $table_data_cnt_val['user_registered'], $wp_date_time_format ); $plan_name = ""; $plan_arr = get_user_meta($table_data_cnt_val['ID'], "arm_user_plan_ids", true); $paid_post_ids = get_user_meta($table_data_cnt_val['ID'], 'arm_user_post_ids', true); if(!empty($paid_post_ids)) { foreach($plan_arr as $key => $val) { if(!empty($paid_post_ids[$val])) { unset($plan_arr[$key]); } } } $arm_gift_ids = get_user_meta($table_data_cnt_val['ID'], 'arm_user_gift_ids', true); if(!empty($arm_gift_ids)) { foreach($plan_arr as $arm_plan_key => $arm_plan_val) { if(in_array($arm_plan_val, $arm_gift_ids)) { unset($plan_arr[$arm_plan_key]); } } } if(!empty($plan_arr)) { foreach ($plan_arr as $key => $plan) { $arm_plan_name = $arm_subscription_plans->arm_get_plan_name_by_id($plan); if(!empty($arm_plan_name) && isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){ $arm_charts_plan_data[$plan]['plan_name']=$arm_plan_name; $arm_charts_plan_data[$plan]['plan_users'][]=$table_data_cnt_val['ID']; } $plan_name .=$arm_plan_name; $plan_name .= ", "; } } else { $plan_name = "-"; } } } if(!empty($table_data_arr)) { if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $arm_report_analytics->arm_export_report_to_csv($table_data_arr, $arm_report_type); exit; } foreach ($table_data_arr as $key => $table_data) { // $arm_registered_date = date_i18n($wp_date_time_format, strtotime($table_data['user_registered'])); $arm_registered_date = get_date_from_gmt( $table_data['user_registered'], $wp_date_time_format ); $plan_name = ""; $arm_next_recurring_date=""; $arm_expire_date=""; $plan_arr = get_user_meta($table_data['ID'], "arm_user_plan_ids", true); $paid_post_ids = get_user_meta($table_data['ID'], 'arm_user_post_ids', true); if(!empty($paid_post_ids)) { foreach($plan_arr as $key => $val) { if(!empty($paid_post_ids[$val])) { unset($plan_arr[$key]); } } } $arm_gift_ids = get_user_meta($table_data['ID'], 'arm_user_gift_ids', true); if(!empty($arm_gift_ids)) { foreach($plan_arr as $arm_plan_key => $arm_plan_val) { if(in_array($arm_plan_val, $arm_gift_ids)) { unset($plan_arr[$arm_plan_key]); } } } if(!empty($plan_arr)) { foreach ($plan_arr as $key => $plan) { $arm_plan_name = $arm_subscription_plans->arm_get_plan_name_by_id($plan); $plan_name .=$arm_plan_name; $plan_name .= ", "; $plan_data = get_user_meta($table_data['ID'], "arm_user_plan_".$plan, true); $arm_expire = !empty($plan_data['arm_expire_plan']) ? $plan_data['arm_expire_plan'] : ''; $arm_next_recurring = !empty($plan_data['arm_next_due_payment']) ? $plan_data['arm_next_due_payment'] : ''; if(!empty($arm_expire)) { $arm_expire_date.= date_i18n($date_format,$arm_expire); $arm_expire_date .= ", "; } else { $arm_expire_date.= esc_html__('Never Expire', 'ARMember'); $arm_expire_date .= ", "; } if(!empty($arm_next_recurring)) { $arm_next_recurring_date.= date_i18n($date_format,$arm_next_recurring); $arm_next_recurring_date.= ", "; } else { $arm_next_recurring_date.= "-"; $arm_next_recurring_date.= ", "; } } } else { $plan_name = "-"; } $plan_name = rtrim($plan_name, ", "); $arm_next_recurring_date = rtrim($arm_next_recurring_date,", "); $arm_expire_date =rtrim($arm_expire_date,", "); $arm_next_recurring_date = (!empty($arm_next_recurring_date)) ? $arm_next_recurring_date : "-"; $arm_expire_date = (!empty($arm_expire_date)) ? $arm_expire_date : "-"; $userlogin = (!empty($table_data['user_login'])) ? "<a class='arm_openpreview_popup' href='javascript:void(0)' data-id='".$table_data['ID']."' data-arm_hide_edit='1'>".$table_data['user_login']."</a>" : $arm_default_user_details_text; $useremail = (!empty($table_data['user_email'])) ? $table_data['user_email'] : "-"; $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $table_content_html .= "<td>".$userlogin."</td>"; $table_content_html .= "<td>".$useremail."</td>"; $table_content_html .= "<td>".$plan_name."</td>"; $table_content_html .= "<td>".$arm_next_recurring_date."</td>"; $table_content_html .= "<td>".$arm_expire_date."</td>"; $table_content_html .= "<td>".$arm_registered_date."</td>"; $table_content_html .= "</tr>"; $tab_row_cnt++; } } else { $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $table_content_html .= "<th class='arm_report_grid_no_data' colspan='6'>".esc_html__( 'No records found', 'ARMember')."</th>"; $table_content_html .= "</tr>"; } if( $is_pagination ){ echo $table_content_html.'[ARM_REPORT_SEPARATOR]'.str_replace("\n", "", $dataPaging); //phpcs:ignore die; } else { ?> <script type="text/javascript" data-cfasync="false"> jQuery(".arm_members_table_body_content").html("<?php echo $table_content_html; //phpcs:ignore?>"); jQuery("#arm_members_table_paging").html('<?php echo str_replace("\n","", $dataPaging); //phpcs:ignore?>'); jQuery.noConflict(); jQuery(document).ready(function($){ var chart_type = ''; var graph_type = "<?php echo $graph_type; //phpcs:ignore?>"; if(graph_type == 'bar'){ chart_type ='column'; } else if(graph_type == 'line'){ chart_type ='areaspline'; } var ticks_year = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']; var year1 = [<?php echo $monthToDisplay; //phpcs:ignore?>]; if(graph_type == 'bar' \|\| graph_type == 'line') { if(graph_type =='bar') { var armChart = Highcharts.chart('chart3_members', { chart: { type: chart_type, }, credits: { enabled : false }, title: { text: '' }, subtitle: { text: '' }, xAxis: { categories: ticks_year, crosshair: true }, legend : { enabled : false }, yAxis: { min: 0, allowDecimals: false, title: { text: 'Members' } <?php if (isset($arm_max_year) and $arm_max_year == 5) { echo ',max : 6'; } ?> }, tooltip: { headerFormat: '<span style="font-size:10px">Month : {point.key}</span><span style="visibility: hidden">{point.y:1f}</span><table>', pointFormat: '<tr><td style="color:{series.color};padding:0;">{series.name}: </td>' +'<td><b>{point.y:1f}</b></td></tr>', footerFormat: '</table>', shared: true, useHTML: true }, plotOptions: { column: { pointPadding: 0, borderWidth: 1, pointWidth: 27 } }, series: [{ name: 'Members', data: year1 }] }); } else { var armChart = Highcharts.chart('chart3_members', { chart: { type: chart_type, }, credits: { enabled : false }, title: { text: '' }, subtitle: { text: '' }, xAxis: { categories: ticks_year, crosshair: true, }, yAxis: { min: 0, allowDecimals: false, title: { text: 'Members' } }, legend: {enabled: false}, plotOptions: { column: { pointPadding: 0, borderWidth: 1, pointWidth: 27, }, areaspline: { fillOpacity: 0.5, dataLabels: { enabled: false, format: '{point.y}' }, lineColor: '#0077ff', }, }, tooltip: { headerFormat: '<span style="font-size:10px">Month : {point.key}</span><span style="visibility: hidden">{point.y:1f}</span><table>', pointFormat: '<tr><td style="color:{series.color};padding:0;min-width:45px;">{series.name}:</td>' + '<td><b>{point.y:1f}</b></td></tr>', footerFormat: '</table>', shared: true, useHTML: true }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, name: "Members", data: year1 }] }); } var normalState = new Object(); normalState.stroke_width1 = 1; normalState.stroke = '#afcaff'; normalState.fill = 'rgba(255,255,255,0.9)'; normalState.padding = 10; normalState.r = 6; normalState.width = 16; normalState.height = 16; normalState.align = 'center'; var hoverState = new Object(); hoverState = normalState; var pressedState = new Object(); pressedState = normalState; armChart.renderer.button('', 56, 70, function(){arm_change_graph_pre('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_prev; //phpcs:ignore?>', 'members')}, normalState, hoverState, pressedState).attr({id:'arm_prev_button',class:'<?php echo $arm_disable_class_prev;?>'}).add().toFront(); armChart.renderer.button('', (armChart.chartWidth - 30), 70, function(){arm_change_graph_next('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_next; //phpcs:ignore?>', 'members')}, normalState, hoverState, pressedState).attr({id:'arm_next_button',class:'<?php echo $arm_disable_class_next; //phpcs:ignore?>'}).add().toFront(); jQuery('.highcharts-container').find('#arm_prev_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_prev_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M1.221,8.318l8.002,8.002l2.001-2L5.221,8.316l6.003-6.003 l-2.001-2L1.221,8.315l0.001,0.001L1.221,8.318z"/></svg>'); jQuery('.highcharts-container').find('#arm_next_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_next_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M11.431,8.601l-8.002,8.002l-2.001-2l6.003-6.003L1.428,2.596 l2.001-2l8.002,8.002L11.43,8.599L11.431,8.601z"/></svg>'); } }); </script> <?php } } else { if ($type == "monthly") { $date = $new_month_year.'-'.$new_month.'-'.date('m', $current_time); } else { $date = $new_day_year.'-'.$new_day_month.'-'.date('m', $current_time); if(isset($_REQUEST['new_day']) && $_REQUEST['new_day'] != '') { $date = $new_day_year.'-'.$new_day_month."-".$new_day; } } if ($type == "monthly") { $day_first = date('01', strtotime($date)); $day_last = date('t', strtotime($date)); if(!empty($filter_year) && !empty($filter_month)) { $first = "{$filter_year}-{$filter_month}-{$day_first}"; $last = "{$filter_year}-{$filter_month}-{$day_last}"; } else { $first = "{$new_month_year}-{$new_month}-{$day_first}"; $last = "{$new_month_year}-{$new_month}-{$day_last}"; } } else { $first = "{$current_date}"; $last = "{$current_date}"; if(!empty($filter_date)) { $first = "{$filter_date}"; $last = "{$filter_date}"; } else { $first = "{$new_day_year}-{$new_day_month}-{$new_day}"; $last = "{$new_day_year}-{$new_day_month}-{$new_day}"; } } $day_array = $arm_report_analytics->arm_makeDayArray($first, $last); foreach ($day_array as $day) { $day_arr[$day] = $wpdb->get_results( $wpdb->prepare("SELECT u.ID,u.user_registered,u.user_login,u.user_email FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered LIKE %s GROUP BY u.ID ORDER BY u.user_registered DESC",date("Y-m-d",strtotime($day)). '%'), 'ARRAY_A'); //phpcs:ignore --Reason $user_table and $usermeta_table is a table name } if( 'daily' == $type ){ $hour_array =array(' ', '00:00', '01:00', '02:00', '03:00', '04:00', '05:00', '06:00', '07:00', '08:00', '09:00', '10:00', '11:00', '12:00', '13:00', '14:00', '15:00', '16:00', '17:00', '18:00', '19:00', '20:00', '21:00', '22:00', '23:00'); $time_arr = array(); $n = 0; foreach( $day_arr[$day] as $k => $darr ){ $timeFormat = date('H:i',strtotime($darr['user_registered'])); if( array_key_exists( $timeFormat, $time_arr ) ){ $time_arr[$timeFormat] = $time_arr[$timeFormat] + 1; } else { $time_arr[$timeFormat] = 1; $n++; } } $final_time_arr = array(0); $uk = 1; for( $i = 0; $i <= 24; $i++ ){ $hour = mktime($i,0); $current_hour = date('H:i', $hour); $next_hour = date('H:i', strtotime("+1 hour", $hour)); $begin = DateTime::createFromFormat( 'H:i', $current_hour ); $end = DateTime::createFromFormat( 'H:i', $next_hour ); foreach( $time_arr as $time_key => $time ){ $now = DateTime::createFromFormat( 'H:i', $time_key ); if( $now > $begin && $now < $end ){ $final_time_arr[$i + 1][] = $time; } } $uk++; } } $formatted_time_arr = array(0); if( 'daily' == $type ){ for( $i = 0; $i <= 24; $i++ ){ if( !isset( $final_time_arr[$i] ) ){ $formatted_time_arr[$i] = 0; } else { if( is_array( $final_time_arr[$i] ) && count( $final_time_arr[$i] ) == 1 ){ $formatted_time_arr[$i] = $final_time_arr[$i][0]; } else if( is_array($final_time_arr[$i]) && count( $final_time_arr[$i] ) > 0 ){ $t = 0; if(!empty($final_time_arr[$i])) { foreach( $final_time_arr[$i] as $tk => $tv ){ $formatted_time_arr[$i] = $tv + $t; $t++; } } } } } } /for data table/ $table_data_arr = array(); $table_data_cnt = 0; $perPage = 10; $offset = ($current_page - 1) * $perPage; if($type == "monthly" \|\| $type == "daily") { $first_day = $first." 00:00:00"; $last_day = $last." 23:59:59"; $table_data_cnt = $wpdb->get_results( $wpdb->prepare("SELECT count(u.ID) FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered BETWEEN %s AND %s GROUP BY u.ID ORDER BY u.user_registered DESC",$first_day,$last_day), 'ARRAY_A'); //phpcs:ignore --Reason $user_table and $usermeta_table is a table name if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $table_data_arr = $wpdb->get_results( $wpdb->prepare("SELECT u.ID,u.user_registered,u.user_login,u.user_email FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered BETWEEN %s AND %s GROUP BY u.ID ORDER BY u.user_registered DESC",$first_day,$last_day), 'ARRAY_A'); //phpcs:ignore --Reason $user_table and $usermeta_table is a table name } else { $table_data_arr = $wpdb->get_results( $wpdb->prepare("SELECT u.ID,u.user_registered,u.user_login,u.user_email FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered BETWEEN %s AND %s GROUP BY u.ID ORDER BY u.user_registered DESC LIMIT ".$perPage." OFFSET ".$offset,$first_day,$last_day), 'ARRAY_A'); //phpcs:ignore --Reason $user_table and $usermeta_table is a table name } $table_data_cnt = count($table_data_cnt); $dataPaging = $arm_global_settings->arm_get_paging_links($current_page, $table_data_cnt, $perPage, ''); } $arm_charts_plan_data=array(); $table_data_cnt_arr = $wpdb->get_results( $wpdb->prepare("SELECT u.ID,u.user_registered,u.user_login,u.user_email FROM `{$user_table}` u LEFT JOIN `{$usermeta_table}` um ON u.ID = um.user_id {$join_clause} {$user_where} AND u.user_registered BETWEEN %s AND %s GROUP BY u.ID ORDER BY u.user_registered DESC",$first_day,$last_day), 'ARRAY_A');//phpcs:ignore --Reason $user_table and $usermeta_table is a table name if(!empty($table_data_cnt_arr)) { foreach($table_data_cnt_arr as $key => $table_data_cnt_val) { $arm_registered_date = get_date_from_gmt( $table_data_cnt_val['user_registered'], $wp_date_time_format ); // $arm_registered_date = date_i18n($wp_date_time_format, strtotime($table_data_cnt_val['user_registered'])); $plan_name = ""; $plan_arr = get_user_meta($table_data_cnt_val['ID'], "arm_user_plan_ids", true); $paid_post_ids = get_user_meta($table_data_cnt_val['ID'], 'arm_user_post_ids', true); if(!empty($paid_post_ids)) { foreach($plan_arr as $key => $val) { if(!empty($paid_post_ids[$val])) { unset($plan_arr[$key]); } } } $arm_gift_ids = get_user_meta($table_data_cnt_val['ID'], 'arm_user_gift_ids', true); if(!empty($arm_gift_ids) && !empty($plan_arr)) { foreach($plan_arr as $arm_plan_key => $arm_plan_val) { if(in_array($arm_plan_val, $arm_gift_ids)) { unset($plan_arr[$arm_plan_key]); } } } if(!empty($plan_arr)) { foreach ($plan_arr as $key => $plan) { $arm_plan_name=$arm_subscription_plans->arm_get_plan_name_by_id($plan); if(!empty($arm_plan_name) && isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){ $arm_charts_plan_data[$plan]['plan_name']=$arm_plan_name; $arm_charts_plan_data[$plan]['plan_users'][]=$table_data_cnt_val['ID']; } $plan_name .= $arm_plan_name; $plan_name .= ", "; } } else { $plan_name = "-"; } } } $table_content_html = ""; $tab_row_cnt = 0; if(!empty($table_data_arr)) { if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $arm_report_analytics->arm_export_report_to_csv($table_data_arr, $arm_report_type); exit; } foreach ($table_data_arr as $key => $table_data) { $arm_registered_date = get_date_from_gmt( $table_data['user_registered'], $wp_date_time_format ); // $arm_registered_date = date_i18n($wp_date_time_format, strtotime($table_data['user_registered'])); $plan_name = ""; $plan_arr = get_user_meta($table_data['ID'], "arm_user_plan_ids", true); $paid_post_ids = get_user_meta($table_data['ID'], 'arm_user_post_ids', true); if(!empty($paid_post_ids)) { foreach($plan_arr as $key => $val) { if(!empty($paid_post_ids[$val])) { unset($plan_arr[$key]); } } } $arm_gift_ids = get_user_meta($table_data['ID'], 'arm_user_gift_ids', true); if(!empty($arm_gift_ids) && !empty($plan_arr)) { foreach($plan_arr as $arm_plan_key => $arm_plan_val) { if(in_array($arm_plan_val, $arm_gift_ids)) { unset($plan_arr[$arm_plan_key]); } } } $arm_expire_date =""; $arm_next_recurring_date =""; if(!empty($plan_arr)) { foreach ($plan_arr as $key => $plan) { $arm_plan_name=$arm_subscription_plans->arm_get_plan_name_by_id($plan); $plan_name .= addslashes($arm_plan_name); $plan_name .= ", "; $plan_data=get_user_meta($table_data['ID'], "arm_user_plan_".$plan, true); $arm_expire = !empty($plan_data['arm_expire_plan']) ? $plan_data['arm_expire_plan'] : ''; $arm_next_recurring = !empty($plan_data['arm_next_due_payment']) ? $plan_data['arm_next_due_payment'] : ''; if(!empty($arm_expire)) { $arm_expire_date.= date_i18n($date_format,$arm_expire); $arm_expire_date .= ", "; } else { $arm_expire_date.= esc_html__('Never Expire', 'ARMember'); $arm_expire_date .= ", "; } if(!empty($arm_next_recurring)) { $arm_next_recurring_date.= date_i18n($date_format,$arm_next_recurring); $arm_next_recurring_date.= ", "; } else { $arm_next_recurring_date.= "-"; $arm_next_recurring_date.= ", "; } } } else { $plan_name = "-"; } $plan_name = rtrim($plan_name, ", "); $arm_next_recurring_date = rtrim($arm_next_recurring_date,", "); $arm_expire_date =rtrim($arm_expire_date,", "); $arm_next_recurring_date = (!empty($arm_next_recurring_date)) ? $arm_next_recurring_date : "-"; $arm_expire_date = (!empty($arm_expire_date)) ? $arm_expire_date : "-"; $userlogin = (!empty($table_data['user_login'])) ? "<a class='arm_openpreview_popup' href='javascript:void(0)' data-id='".$table_data['ID']."' data-arm_hide_edit='1'>".$table_data['user_login']."</a>" : $arm_default_user_details_text; $useremail = (!empty($table_data['user_email'])) ? $table_data['user_email'] : "-"; $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $table_content_html .= "<td>".$userlogin."</td>"; $table_content_html .= "<td>".$useremail."</td>"; $table_content_html .= "<td>".$plan_name."</td>"; $table_content_html .= "<td>".$arm_next_recurring_date."</td>"; $table_content_html .= "<td>".$arm_expire_date."</td>"; $table_content_html .= "<td>".$arm_registered_date."</td>"; $table_content_html .= "</tr>"; $tab_row_cnt++; } } else { $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $table_content_html .= "<th class='arm_report_grid_no_data' colspan='6'>".esc_html__( 'No records found', 'ARMember')."</th>"; $table_content_html .= "</tr>"; } if (!empty($day_arr) && $type == 'monthly') { $day_var = $val_var = '['; $max_day = 0; foreach ($day_arr as $key => $value) { $total_users = intval(count($value)); $day = date("d-M", strtotime($key)); $day_var .= "'{$day}', "; $val_var .= $total_users. ', '; $max_day = max($max_day, $total_users); } $day_var .= ']'; $val_var .= ']'; } if ($type == "monthly") { $chart = "chart2_members"; $max_month_limit = date('Y-m',mktime(0, 0, 0, $new_month,1 , $new_month_year)); $arm_disable_class_next = ''; $arm_enable_next = 1; if ($max_month_limit >= date('Y-m')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $arm_disable_class_prev = ''; $arm_enable_prev = 1; $month_limit = date('Y-m-d',mktime(0, 0, 0, $new_month, 1, $new_month_year)); $min_month_limit = date('Y-m-d',mktime(0, 0, 0, $min_month, 1, $min_year)); } else { $chart = "chart1_members"; $day_var = json_encode( $hour_array ); $val_var = json_encode( $formatted_time_arr ); $max_date_limit = date('Y-m-d',mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $arm_disable_class_next = ''; $arm_enable_next = 1; if ($max_date_limit >= date('Y-m-d')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $arm_disable_class_prev = ''; $arm_enable_prev = 1; $date_limit = date('Y-m-d',mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $min_date_limit = date('Y-m-d',mktime(0, 0, 0, $min_month, $min_date, $min_year)); } if( $is_pagination ){ echo $table_content_html.'[ARM_REPORT_SEPARATOR]'.str_replace("\n", "", $dataPaging); //phpcs:ignore die; } else { ?> <script type="text/javascript"> jQuery(".arm_members_table_body_content").html("<?php echo $table_content_html; //phpcs:ignore?>"); jQuery("#arm_members_table_paging").html('<?php echo str_replace("\n","", $dataPaging); //phpcs:ignore?>'); jQuery.noConflict(); jQuery(document).ready(function($){ var buttonOptions = {}; var chart_type = ''; var graph_type = "<?php echo $graph_type; //phpcs:ignore?>"; if (graph_type == 'bar') { chart_type ='column'; } else if (graph_type == 'line') { chart_type ='areaspline'; } var s1 = <?php echo $val_var; //phpcs:ignore?>; if(graph_type == 'bar' \|\| graph_type == 'line'){ var tooltipHeader; tooltipHeader = '<?php echo ('monthly' == $type) ? 'Date' : 'Hour'; ?>'; if(graph_type == 'bar'){ var gbarOpt = { chart : { type : chart_type }, credits: { enabled : false }, title: { text: '' }, subtitle: { text: '' }, legend: { enabled: false }, xAxis: { categories: <?php echo $day_var; //phpcs:ignore?>, crosshair: true }, yAxis: { min: 0, allowDecimals: false, title: { text: 'Members' } <?php if (!empty($max_day) && $max_day != 0) { echo ',max : '.($max_day+1); //phpcs:ignore } ?> }, tooltip: { headerFormat: '<span style="font-size:10px">'+tooltipHeader+' : {point.key}</span><span style="visibility: hidden">{point.y:1f}</span><table>', pointFormat: '<tr><td style="color:{series.color};padding:0;width:60px;">{series.name}: </td>' + '<td><b>{point.y:1f}</b></td></tr>', footerFormat: '</table>', shared: true, useHTML: true }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], plotOptions: { column: { pointPadding: 0.2, borderWidth: 1, pointWidth: 10, //width of the column lineColor: '#0077ff', color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth:2 } }, series: [{ name: 'Members', data: s1 }], }; var armChart = Highcharts.chart("<?php echo $chart; //phpcs:ignore?>", gbarOpt); } else { var opt2 = { chart : { type : chart_type }, title: { text: '' }, subtitle: { text: '' }, credits: { enabled : false }, legend : { enabled: false }, xAxis: { categories: <?php echo $day_var; //phpcs:ignore?>, crosshair: true }, yAxis: { min: 0, allowDecimals: false, title: { text: 'Members' } <?php if (!empty($max_day) && $max_day != 0) { echo ',max : '.($max_day+1); //phpcs:ignore } ?> }, tooltip: { headerFormat: '<span style="font-size:10px">'+tooltipHeader+' : {point.key}</span><span style="visibility:hidden">{point.y:1f}</span><table>', pointFormat: '<tr><td style="color:{series.color};padding:0;width:60px;">{series.name}: </td>' + '<td><b>{point.y:1f}</b></td></tr>', footerFormat: '</table>', shared: true, useHTML: true }, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: { enabled: false, format: '{point.y}' }, lineColor: '#0077ff', } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, name: "Members", data: s1 }], }; var armChart = Highcharts.chart("<?php echo $chart; //phpcs:ignore?>", opt2); } var normalState = new Object(); normalState.stroke_width = 1; normalState.stroke = '#afcaff'; normalState.fill = 'rgba(255,255,255,0.9)'; normalState.padding = 10; normalState.r = 6; normalState.width = 16; normalState.height = 16; normalState.align = 'center'; var hoverState = new Object(); hoverState = normalState; var pressedState = new Object(); pressedState = normalState; <?php if(empty($arm_disable_next_prev_btn)) { ?> armChart.renderer.button('', 56, 70, function(){arm_change_graph_pre('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_prev; //phpcs:ignore?>', 'members')}, normalState, hoverState, pressedState).attr({id:'arm_prev_button',class:'<?php echo $arm_disable_class_prev;?>'}).add().toFront(); armChart.renderer.button('', (armChart.chartWidth - 30), 70, function(){arm_change_graph_next('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_next; //phpcs:ignore?>', 'members')}, normalState, hoverState, pressedState).attr({id:'arm_next_button',class:'<?php echo $arm_disable_class_next; //phpcs:ignore?>'}).add().toFront(); <?php } ?> jQuery('.highcharts-container').find('#arm_prev_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_prev_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M1.221,8.318l8.002,8.002l2.001-2L5.221,8.316l6.003-6.003 l-2.001-2L1.221,8.315l0.001,0.001L1.221,8.318z"/></svg>'); jQuery('.highcharts-container').find('#arm_next_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_next_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M11.431,8.601l-8.002,8.002l-2.001-2l6.003-6.003L1.428,2.596 l2.001-2l8.002,8.002L11.43,8.599L11.431,8.601z"/></svg>'); } else { } }); </script> <?php } } ?> <?php if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){?> <?php if($type == 'daily'){?> <div class="armchart_display_title arm_ml_5"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <?php }?> <?php if($type == 'monthly'){?> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title arm_ml_5"> <?php $month_year_lbl = !empty($filter_year) ? $filter_year : $new_month_year; ?> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($month_year_lbl); ?></label> </div> <?php }?> <?php if($type == 'yearly'){?> <div class="armchart_display_title arm_ml_5"> <label class="armcharttitle"><?php echo esc_html($new_year); ?></label> </div> <?php }?> <div class="armchart_plan_section"> <?php if(isset($arm_charts_plan_data) && count($arm_charts_plan_data)>0){ foreach ($arm_charts_plan_data as $arm_charts_plan_key => $arm_charts_plan_row) { ?> <div class="armchart_plan_item"> <label class="armchart_plan_title"><?php echo esc_html($arm_charts_plan_row['plan_name']); ?></label> <p class="armchart_plan_item_desc"><?php echo esc_html__("Members:", "ARMember");?> <?php echo count($arm_charts_plan_row['plan_users']); ?></p> </div> <?php } }else{ echo '<div class="armchart_plan_no_item">'. esc_html__("Recently No Membership Plan purchased", "ARMember").'</div>'; } ?> </div> <div class="armchart_view_section"> <div class="page_title"> <span><?php esc_html_e('Membership','ARMember');?></span> <div class="arm_chart_view_section arm_float_right"> <?php $selected_line_class = ($graph_type == 'line') ? 'selected' :''; $selected_bar_class = ($graph_type == 'bar') ? 'selected' :''; ?> <div class="armgraphtype armgraphtype_line armgraphtype_members <?php echo esc_attr($selected_line_class)?>" id="armgraphtype_members_div_line" onclick="arm_change_graph_type('line', 'members')"> <input type="radio" value="line" id="armgraphtype_members_line" name="armgraphtype_members" <?php echo checked($graph_type, 'line');?>> </div> <div class="armgraphtype armgraphtype_bar armgraphtype_members arm_margin_right_0 <?php echo esc_attr($selected_bar_class)?>" id="armgraphtype_members_div_bar" onclick="arm_change_graph_type('bar', 'members')"> <input type="radio" id="armgraphtype_members_bar" value="bar" name="armgraphtype_members" <?php echo checked( $graph_type,'bar');?>> </div> </div> </div> <?php }?> <div id="daily_members" class="arm_padding_20" style="<?php echo ($type == 'daily') ? 'display:block;' : 'display:none'; ?>"> <?php if(!isset($_REQUEST['action'])){?> <div class="armchart_display_title"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <?php }?> <div id="chart1_members" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_day); ?>" name="current_day" id="current_day" /> <input type="hidden" value="<?php echo esc_attr($new_day_month); ?>" name="current_day_month" id="current_day_month" /> <input type="hidden" value="<?php echo esc_attr($new_day_year); ?>" name="current_day_year" id="current_day_year" /> </div> <div id="monthly_members" class="arm_padding_20" style="<?php echo ($type == 'monthly') ? 'display:block;' : 'display:none'; ?>"> <?php if(!isset($_REQUEST['action'])){?> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($new_month_year); ?></label> </div> <?php }?> <div id="chart2_members" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_month); ?>" name="current_month" id="current_month" /> <input type="hidden" value="<?php echo esc_attr($new_month_year); ?>" name="current_month_year" id="current_month_year" /> </div> <div id="yearly_members" class="arm_padding_20" style="<?php echo ($type == 'yearly') ? 'display:block;' : 'display:none'; ?>"> <div class="arlinks link_align"></div> <?php if(!isset($_REQUEST['action'])){?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_html($new_year); ?></label> </div> <?php }?> <div id="chart3_members" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_year); ?>" name="current_year" id="current_year" /> </div> <?php if(isset($_REQUEST['action']) && isset($_REQUEST['member_report'])){?> </div> <?php }?> <?php } else if ($plan_type == 'members_plan') { $plans_info = $wpdb->get_results( $wpdb->prepare("SELECT `arm_subscription_plan_id` as id, `arm_subscription_plan_name` as name FROM `{$ARMember->tbl_arm_subscription_plans}` WHERE `arm_subscription_plan_is_delete` = %d",0) ); //phpcs:ignore --Reason $ARMember->tbl_arm_subscription_plans is a table name if (!empty($plans_info)) { $chart = "chart2_members_plan"; $plan_name = $plan_users = "["; $plan_name .= "' ', "; $plan_users .= "0, "; $activity = $ARMember->tbl_arm_activity; $min_full_date = $wpdb->get_var("SELECT min(arm_date_recorded) FROM `{$activity}`");//phpcs:ignore --Reason activity is a table name and query is without where clause if (!empty($min_full_date)) { $min_year = date('Y', strtotime($min_full_date)); $min_month = date('m', strtotime($min_full_date)); $min_date = date('d', strtotime($min_full_date)); } $arm_disable_class_next = ''; $arm_disable_class_prev = ''; $arm_enable_next = 1; $arm_enable_prev = 1; if ($type == 'yearly') { if ($new_year >= date('Y', $current_time)) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } if ($new_year <= $min_year) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $chart = "chart3_members_plan"; $from_year = "{$new_year}-01-01 00:00:00"; $end_year = "{$new_year}-12-31 23:59:59"; $members_activity = $wpdb->get_results( $wpdb->prepare("SELECT * FROM `{$activity}` WHERE arm_date_recorded BETWEEN %s AND %s AND arm_action = %s ORDER BY arm_date_recorded DESC",$from_year,$end_year,'new_subscription'), 'ARRAY_A'); //phpcs:ignore --Reason activity is a table name } else if ($type == 'monthly') { $chart = "chart2_members_plan"; $date = $new_month_year.'-'.$new_month.'-'.date('m', $current_time); $day_first = date('01', strtotime($date)); $day_last = date('t', strtotime($date)); $first = "{$new_month_year}-{$new_month}-{$day_first}"; $last = "{$new_month_year}-{$new_month}-{$day_last}"; $max_month_limit = date('Y-m',mktime(0, 0, 0, $new_month,1 , $new_month_year)); if ($max_month_limit >= date('Y-m')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $month_limit = date('Y-m-d',mktime(0, 0, 0, $new_month, 1, $new_month_year)); $min_month_limit = date('Y-m-d',mktime(0, 0, 0, $min_month, 1, $min_year)); if ($min_month_limit >= $month_limit) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $first_day = "{$first} 00:00:00"; $last_day = "{$last} 23:59:59"; $members_activity = $wpdb->get_results( $wpdb->prepare("SELECT * FROM `{$activity}` WHERE arm_date_recorded BETWEEN %s AND %s AND arm_action = 'new_subscription' ORDER BY arm_date_recorded DESC",$first_day,$last_day), 'ARRAY_A'); //phpcs:ignore --Reason $activity is a table name } else if ($type == 'daily') { $chart = "chart1_members_plan"; $date = "{$new_day_year}-{$new_day_month}-{$new_day}"; $date = date("Y-m-d", mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $max_date_limit = date('Y-m-d',mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); if ($max_date_limit >= date('Y-m-d')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $date_limit = date('Y-m-d', mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $min_date_limit = date('Y-m-d', mktime(0, 0, 0, $min_month, $min_date, $min_year)); if ($min_date_limit >= $date_limit) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $members_activity = $wpdb->get_results( $wpdb->prepare("SELECT DISTINCT * FROM `{$activity}` WHERE arm_date_recorded LIKE %s AND arm_action = %s ORDER BY arm_date_recorded DESC",$date.'%','new_subscription'), 'ARRAY_A'); //phpcs:ignore --Reason $activity is a table name } $users = array(); $count = ""; if (!empty($members_activity)) { foreach ($members_activity as $member_users_id) { $user_id = $member_users_id['arm_user_id']; $arm_content = maybe_unserialize($member_users_id['arm_content']); $arm_date_recorded = $member_users_id['arm_date_recorded']; if (in_array($user_id, $users)) { continue; } $users[] = $user_id; $arm_user_plans = get_user_meta($user_id, 'arm_user_plan_ids', true); if (empty($arm_user_plans)) { continue; } $plan_id = $members_activity['arm_item_id']; $count[$plan_id] = $count[$plan_id] + 1; } } foreach ($plans_info as $plan) { $plan_name .= "'".stripslashes($plan->name) . "', "; $plan_users .= isset($count[$plan->id]) && !empty($count[$plan->id]) ? intval($count[$plan->id]).", " : intval(0).", "; } $plan_name .= "]"; $plan_users .= "]"; if (!empty($plan_name) && !empty($plan_users)) { ?> <script type="text/javascript" data-cfasync="false"> jQuery.noConflict(); jQuery(document).ready(function($){ var graph_type = "<?php echo $graph_type; //phpcs:ignore?>"; var plan_users = <?php echo $plan_users; //phpcs:ignore?>; var plan_names = <?php echo $plan_name; //phpcs:ignore?>; if(graph_type == 'bar'){ var armChart = Highcharts.chart(<?php echo $chart; //phpcs:ignore?>, { chart: { type: 'column', }, title: { text: '' }, subtitle: { text: '' }, credits : { enabled : false }, xAxis: { categories: plan_names, crosshair: true, labels: { rotation: - 60 }, min : 0.5 }, yAxis: { min: 0, allowDecimals: false, title: {text: 'Members'} }, legend: { enabled: false }, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: {enabled: false, format: '{point.y}'}, lineColor: '#0077ff', } }, tooltip: { formatter: function() { var tooltip = ""; var index = this.point.index; var name = plan_names[index]; if (index == 0) { name = '0'; } tooltip = '<span style="font-size:12px">' + name + ':</span>'; tooltip += '<div style="color:' + this.series.color + '">(</div><b>' + this.y + '</b><div style="color:' + this.series.color + '">)</div>'; return tooltip; } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ name: "Membership", color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, data: plan_users, }], }); } else if(graph_type == 'line'){ var armChart = Highcharts.chart(<?php echo $chart; //phpcs:ignore?>, { chart: { type: 'areaspline', }, credits : { enabled : false }, title: { text: '' }, subtitle: { text: '' }, xAxis: { categories: plan_names, crosshair: true, labels: { rotation: - 60 }, min : 0.5 }, yAxis: { min: 0, allowDecimals: false, title: { text: 'Members' } }, legend: {enabled: false}, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: { enabled: false, format: '{point.y}' }, lineColor: '#0077ff', } }, tooltip: { formatter: function() { var tooltip = ""; var index = this.point.index; var name = plan_names[index]; if (index == 0) { name = '0'; } tooltip = '<span style="font-size:12px">' + name + ':</span>'; tooltip += '<div style="color:' + this.series.color + '">(</div><b>' + this.y + '</b><div style="color:' + this.series.color + '">)</div>'; return tooltip; } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, data: plan_users, }], }); } var normalState = new Object(); normalState.stroke_width1 = 1; normalState.stroke = '#afcaff'; normalState.fill = 'rgba(255,255,255,0.9)'; normalState.padding = 10; normalState.r = 6; normalState.width = 16; normalState.height = 16; normalState.align = 'center'; var hoverState = new Object(); hoverState = normalState; var pressedState = new Object(); pressedState = normalState; armChart.renderer.button('', 56, 70, function(){arm_change_graph_pre('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_prev; //phpcs:ignore?>', 'members_plan')}, normalState, hoverState, pressedState).attr({id:'arm_prev_button',class:'<?php echo $arm_disable_class_prev; //phpcs:ignore?>'}).add().toFront(); armChart.renderer.button('', (armChart.chartWidth - 30), 70, function(){arm_change_graph_next('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_next; //phpcs:ignore?>', 'members_plan')}, normalState, hoverState, pressedState).attr({id:'arm_next_button',class:'<?php echo $arm_disable_class_next; //phpcs:ignore?>'}).add().toFront(); jQuery('.highcharts-container').find('#arm_prev_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_prev_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M1.221,8.318l8.002,8.002l2.001-2L5.221,8.316l6.003-6.003 l-2.001-2L1.221,8.315l0.001,0.001L1.221,8.318z"/></svg>'); jQuery('.highcharts-container').find('#arm_next_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_next_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M11.431,8.601l-8.002,8.002l-2.001-2l6.003-6.003L1.428,2.596 l2.001-2l8.002,8.002L11.43,8.599L11.431,8.601z"/></svg>'); }); </script> <?php } } ?> <div id="daily_members_plan" class="arm_padding_20" style="<?php echo ($type == 'daily') ? 'display:block;' : 'display:none'; ?>"> <div class="armchart_display_title"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <div id="chart1_members_plan" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_day); ?>" name="current_day" id="current_day" /> <input type="hidden" value="<?php echo esc_attr($new_day_month); ?>" name="current_day_month" id="current_day_month" /> <input type="hidden" value="<?php echo esc_attr($new_day_year); ?>" name="current_day_year" id="current_day_year" /> </div> <div id="monthly_members_plan" class="arm_padding_20" style="<?php echo ($type == 'monthly') ? 'display:block;' : 'display:none'; ?>"> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($new_month_year); ?></label> </div> <div id="chart2_members_plan" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_month); ?>" name="current_month" id="current_month" /> <input type="hidden" value="<?php echo esc_attr($new_month_year); ?>" name="current_month_year" id="current_month_year" /> </div> <div id="yearly_members_plan" class="arm_padding_20" style="<?php echo ($type == 'yearly') ? 'display:block;' : 'display:none'; ?>"> <div class="arlinks link_align"></div> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_attr($new_year); ?></label> </div> <div id="chart3_members_plan" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_year); ?>" name="current_year" id="current_year" /> </div> <?php } else if ($plan_type == 'payment_history') { $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; $chart = "chart2_payment_history"; $gateway_name = $total_amount = $tool_tip = "["; $gateway_name .= "' ', "; $tool_tip .= "' ', "; $total_amount .= "0, "; $ptquery = $wpdb->get_var("SELECT min(arm_created_date) FROM `{$ARMember->tbl_arm_payment_log}`"); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name and query without where clause $ctquery = ""; $cbquery = ""; $ctquery_where = ""; if(!empty($filter_plan_id)) { $ctquery_where .= $wpdb->prepare(" AND pt.arm_plan_id=%s",$filter_plan_id); } if(!empty($gateway_filter)) { $ctquery_where .= $wpdb->prepare(" AND pt.arm_payment_gateway=%s",$gateway_filter); } if (!empty($ptquery)) { $min_year = date('Y', strtotime($ptquery)); $min_month = date('m', strtotime($ptquery)); $min_date = date('d', strtotime($ptquery)); } $arm_disable_class_next = $arm_disable_class_prev = ''; $arm_enable_next = $arm_enable_prev = 1; $chart = "chart3_payment_history"; if ($type == 'yearly') { if ($new_year >= date('Y', $current_time)) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } if ($new_year <= $min_year) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $chart = "chart3_payment_history"; $from_year = "{$new_year}-01-01 00:00:00"; $end_year = "{$new_year}-12-31 23:59:59"; $ctquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway, MONTH(pt.arm_created_date) AS time, SUM(pt.arm_amount) as Total FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s Group By pt.arm_payment_gateway, MONTH(pt.arm_created_date)",1,'success','1',0,0,$from_year,$end_year); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount, pt.arm_created_date, pt.arm_payment_gateway FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s",1,'success','1',0,0,$from_year,$end_year);//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } else if ($type == 'monthly') { $chart = "chart2_payment_history"; $date = $new_month_year.'-'.$new_month.'-'.date('m', $current_time); $day_first = date('01', strtotime($date)); $day_last = date('t', strtotime($date)); if(!empty($filter_year) && !empty($filter_month)) { $first = "{$filter_year}-{$filter_month}-{$day_first}"; $last = "{$filter_year}-{$filter_month}-{$day_last}"; } else { $first = "{$new_month_year}-{$new_month}-{$day_first}"; $last = "{$new_month_year}-{$new_month}-{$day_last}"; } $max_month_limit = date('Y-m',mktime(0, 0, 0, $new_month,1 , $new_month_year)); if ($max_month_limit >= date('Y-m')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $month_limit = date('Y-m-d',mktime(0, 0, 0, $new_month, 1, $new_month_year)); $min_month_limit = date('Y-m-d',mktime(0, 0, 0, $min_month, 1, $min_year)); if ($min_month_limit >= $month_limit) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $first_day = "{$first} 00:00:00"; $last_day = "{$last} 23:59:59"; $ctquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway, DAY(pt.arm_created_date) as time, SUM(pt.arm_amount) as Total FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s Group By pt.arm_payment_gateway, DAY(pt.arm_created_date)",1,'success','1',0,0,$first_day,$last_day); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount, pt.arm_created_date, pt.arm_payment_gateway FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE 1=1 AND pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s",1,'success','1',0,0,$first_day,$last_day);//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } else if ($type == 'daily') { $chart = "chart1_payment_history"; $date = "{$new_day_year}-{$new_day_month}-{$new_day}"; $date = date("Y-m-d", mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $max_date_limit = date('Y-m-d',mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); if ($max_date_limit >= date('Y-m-d')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $date_limit = date('Y-m-d', mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $min_date_limit = date('Y-m-d', mktime(0, 0, 0, $min_month, $min_date, $min_year)); if ($min_date_limit >= $date_limit) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $ctquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway, TIME(pt.arm_created_date) as time, SUM(pt.arm_amount) as Total FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date LIKE %s",1,'success','1',0,0,$date.'%'); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount, pt.arm_created_date, pt.arm_payment_gateway FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE 1=1 AND pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date LIKE %s",1,'success','1',0,0,$date.'%');//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } /for data table/ $table_data_arr = array(); $table_data_cnt = 0; $table_data_cnt_arr = $wpdb->get_results("SELECT arm_log_id, arm_created_date, arm_payment_gateway, arm_user_id, arm_amount, arm_plan_id FROM ({$ctgquery}) AS arm_payment_history_log_data", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a query $perPage = 10; $offset = ($current_page - 1) * $perPage; if(!empty($gateway_filter)) { $payment_grid_query = $wpdb->get_results("SELECT arm_payment_gateway, time, Total FROM ({$ctquery}) AS arm_payment_history_log", 'ARRAY_A');//phpcs:ignore --Reason $ctquery is a query /for data table/ $table_data_cnt = count($payment_grid_query); if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $payment_data_query = $wpdb->get_results("SELECT , u.user_login FROM ({$ctgquery}) as arm_payment_history_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_payment_history_log_data.arm_user_id", 'ARRAY_A');//phpcs:ignore --Reason $ctgquery is a query } else { $payment_data_query = $wpdb->get_results("SELECT arm_log_id,arm_plan_id, arm_created_date, arm_payment_gateway, arm_user_id, arm_payer_email, arm_invoice_id, arm_amount, arm_currency, u.user_login FROM ({$ctgquery}) as arm_payment_history_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_payment_history_log_data.arm_user_id LIMIT {$perPage} OFFSET {$offset}", 'ARRAY_A');//phpcs:ignore --Reason $ctgquery is a query } $table_data_cnt2 = $wpdb->get_var( "SELECT COUNT() as total FROM ({$ctgquery}) AS arm_payment_history_log_data" );//phpcs:ignore --Reason $ctgquery is a query } else if(empty($gateway_filter)) { $payment_grid_query = $wpdb->get_results("SELECT arm_payment_gateway, time, Total FROM ({$ctquery}) AS arm_payment_history_log", 'ARRAY_A');//phpcs:ignore --Reason $ctquery is a query /for data table/ $table_data_cnt = count($payment_grid_query); if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $payment_data_query = $wpdb->get_results("SELECT , u.user_login FROM ({$ctgquery}) as arm_payment_history_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_payment_history_log_data.arm_user_id", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a query } else { $payment_data_query = $wpdb->get_results("SELECT arm_log_id,arm_plan_id,arm_created_date, arm_payment_gateway, arm_user_id, arm_payer_email, arm_invoice_id, arm_amount, arm_currency, u.user_login FROM ({$ctgquery}) as arm_payment_history_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_payment_history_log_data.arm_user_id ORDER BY arm_log_id DESC LIMIT {$perPage} OFFSET {$offset}", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a query } $table_data_cnt2 = $wpdb->get_var( "SELECT COUNT() as total FROM ({$ctgquery}) AS arm_payment_history_log_data" );//phpcs:ignore --Reason $ctgquery is a query } $wp_date_time_format = ""; if (is_multisite()) { $wp_date_time_format = get_option('date_format') . " " . get_option('time_format'); } else { $wp_date_time_format = get_site_option('date_format') . " " . get_site_option('time_format'); } $dataPaging = $arm_global_settings->arm_get_paging_links($current_page, $table_data_cnt2, $perPage, ''); $table_content_html = ""; $tab_row_cnt = 0; $arm_charts_plan_data=array(); if(!empty($table_data_cnt_arr)) { foreach($table_data_cnt_arr as $key => $table_data_cnt_val) { $arm_created_date = date_i18n($wp_date_time_format, strtotime($table_data_cnt_val['arm_created_date'])); $payment_gateway = ucfirst( str_replace('_', ' ', $table_data_cnt_val['arm_payment_gateway'] ) ); if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts" && !empty($table_data_cnt_val['arm_user_id'])){ $arm_plan_id = $table_data_cnt_val['arm_plan_id']; if(!empty($arm_plan_id)) { if(empty($arm_charts_plan_data[$arm_plan_id])) { $arm_plan_name = $arm_subscription_plans->arm_get_plan_name_by_id($arm_plan_id); $arm_charts_plan_data[$arm_plan_id]['plan_name'] = $arm_plan_name; $arm_charts_plan_data[$arm_plan_id]['total_amount'] = 0; } $arm_charts_plan_data[$arm_plan_id]['plan_transaction_user_ids'][] = $table_data_cnt_val['arm_user_id']; if(!isset($arm_charts_plan_data[$arm_plan_id]['total_amount'])) { $arm_charts_plan_data[$arm_plan_id]['total_amount'] = 0; } $arm_charts_plan_data[$arm_plan_id]['total_amount'] = $arm_charts_plan_data[$arm_plan_id]['total_amount'] + $table_data_cnt_val['arm_amount']; } } } } if(!empty($payment_data_query)) { if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $arm_report_analytics->arm_export_report_to_csv($payment_data_query, $arm_report_type); exit; } $arm_plan_default_arr=array(); foreach ($payment_data_query as $key => $table_data) { $arm_created_date = date_i18n($wp_date_time_format, strtotime($table_data['arm_created_date'])); $payment_gateway = ucfirst( str_replace('_', ' ', $table_data['arm_payment_gateway'] ) ); if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts" && !empty($table_data['arm_user_id'])){ $plan_arr = get_user_meta($table_data['arm_user_id'], "arm_user_plan_ids", true); $paid_post_ids = get_user_meta($table_data['arm_user_id'], 'arm_user_post_ids', true); if(!empty($paid_post_ids)) { foreach($plan_arr as $key => $val) { if(!empty($paid_post_ids[$val])) { unset($plan_arr[$key]); } } } $arm_gift_ids = get_user_meta($table_data['arm_user_id'], 'arm_user_gift_ids', true); if(!empty($arm_gift_ids)) { foreach($plan_arr as $arm_plan_key => $arm_plan_val) { if(in_array($arm_plan_val, $arm_gift_ids)) { unset($plan_arr[$arm_plan_key]); } } } if(!empty($plan_arr)) { foreach ($plan_arr as $key => $plan) { $arm_plan_name=$arm_subscription_plans->arm_get_plan_name_by_id($plan); } } } $user_login = !empty($table_data['user_login']) ? "<a class='arm_openpreview_popup' href='javascript:void(0)' data-id='".$table_data['arm_user_id']."' data-arm_hide_edit='1'>".$table_data['user_login']."</a>" : $arm_default_user_details_text; $paid_by = !empty($table_data['arm_payer_email']) ? $table_data['arm_payer_email'] : '-'; $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $arm_invoice_id = $arm_global_settings->arm_manipulate_invoice_id($table_data['arm_invoice_id']); $arm_log_type = ($table_data['arm_payment_gateway'] == 'bank_transfer') ? 'bt_log' : 'other'; $arm_invoice_id = "<a class='armhelptip arm_invoice_detail tipso_style' href='javascript:void(0)' data-log_type='".$arm_log_type."' data-log_id='".$table_data['arm_log_id']."'>".$arm_invoice_id."</a>"; if(!empty($arm_plan_default_arr[$table_data['arm_plan_id']])) { $arm_plan_name = $arm_plan_default_arr[$table_data['arm_plan_id']]; } else { $arm_plan_name = $arm_subscription_plans->arm_get_plan_name_by_id($table_data['arm_plan_id']); $arm_plan_name = !empty($arm_plan_name) ? addslashes($arm_plan_name) : '-' ; $arm_plan_default_arr[$table_data['arm_plan_id']] = $arm_plan_name; } $table_content_html .= "<td>".$arm_invoice_id."</td>"; $table_content_html .= "<td>".$user_login."</td>"; $table_content_html .= "<td>".$paid_by."</td>"; $table_content_html .= "<td>".$arm_plan_name."</td>"; $table_content_html .= "<td class='arm_align_right'>".number_format($table_data['arm_amount'],$arm_currency_decimal)." ".$table_data['arm_currency']."</td>"; $table_content_html .= "<td class='arm_align_center'>".$payment_gateway."</td>"; $table_content_html .= "<td>".$arm_created_date."</td>"; $table_content_html .= "</tr>"; $tab_row_cnt++; } } else { $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $table_content_html .= "<th class='arm_report_grid_no_data' colspan='7'>".esc_html__( 'No records found', 'ARMember')."</th>"; $table_content_html .= "</tr>"; } $payment_gt_data = array(); if (!empty($payment_grid_query)) { $j = 0; foreach ($payment_grid_query as $key => $payment_gt) { if ($type == "daily") { $date = !empty($_POST['date_filter']) ? sanitize_text_field($_POST['date_filter']) :'';//phpcs:ignore $get_time = $payment_gt['time']; if(empty($date)) { $year = !empty($_POST['new_day_year']) ? intval($_POST['new_day_year']) : '';//phpcs:ignore $month = !empty($_POST['new_day_month']) ? intval($_POST['new_day_month']) : '';//phpcs:ignore $day = !empty( $_POST['new_day'] ) ? intval($_POST['new_day']) : '';//phpcs:ignore $date = $year.'-'.$month.'-'.$day; } if(!empty($get_time) && !empty($date) && $date != '--') { $ctime = explode(':',$get_time); $cdate = date_create($date.' '.$ctime[0].':00'); $time = date_format($cdate, "H:i"); } else { $time_hr = $payment_gt['time']; if(str_contains($payment_gt['time'],':')) { $time_arr = explode(':',$payment_gt['time']); $time_hr = $time_arr[0]; } $time = date("H:i", mktime($time_hr, 0)); } } else { $time = $payment_gt['time']; } $payment_gt['Total'] = $value_total = str_replace(',','', $payment_gt['Total']); $payment_gt['Total'] = floatval($value_total); $payment_gt_data[$time][] = array( "name" => $payment_gt['arm_payment_gateway'], "total" => !empty($total) ? $total : number_format( $payment_gt['Total'], $arm_currency_decimal), ); $j++; } } $tooltip = ""; if ($type == "yearly") { for ($i = 1; $i <= 12; $i++) { $amount = 0; $new_month_year = empty($new_month_year) ? $new_year : $new_month_year; $gateway_name .= "'".date('M',mktime(0, 0, 0, $i, 1, $new_month_year))."', "; if (isset($payment_gt_data[$i]) && !empty($payment_gt_data[$i])) { $name = ""; foreach ($payment_gt_data[$i] as $key => $value) { $value_total = str_replace(",","",$value['total']); $value_total = floatval($value_total); if ($value['name'] == "manual") { $name .= esc_html__("Paid By Admin", "ARMember")." : ".number_format($value_total,$arm_currency_decimal)."<br>"; } else { $title = ucwords(str_replace("_", " ", $value['name'])); $name .= "{$title} : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } $amount += $value_total; } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $amount = number_format($amount,$arm_currency_decimal,'.',''); $total_amount .= "{$amount}, "; } } else if ($type == "monthly") { $month_name = date("M", mktime(0, 0, 0, $new_month, 1)); for ($i = 1; $i <= $day_last; $i++) { $amount = 0; $gateway_name .= "'{$i}-{$month_name}', "; if (isset($payment_gt_data[$i]) && !empty($payment_gt_data[$i])) { $name = ""; foreach ($payment_gt_data[$i] as $key => $value) { $value_total = str_replace(",","",$value['total']); $value_total = floatval($value_total); if ($value['name'] == "manual") { $name .= esc_html__("Paid By Admin", "ARMember")." : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } else { $title = ucwords(str_replace("_", " ", $value['name'])); $name .= "{$title} : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } $amount += number_format($value_total,$arm_currency_decimal,'.',''); } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $amount = number_format($amount,$arm_currency_decimal,'.',''); $total_amount .= "{$amount}, "; } } else { for ($i = 0; $i <= 23; $i++) { $amount = 0; $hour = mktime("{$i}", 0); $current_hour = date('H:i', $hour); $next_hour = date('H:i', strtotime("+1 hour", $hour)); $gateway_name .= "'{$current_hour}', "; $name = ""; $previous_amt = 0; if (isset($payment_gt_data[$current_hour]) && !empty($payment_gt_data[$current_hour])) { foreach ($payment_gt_data[$current_hour] as $key => $value) { $value_total = str_replace(",","",$value['total']); $value_total = floatval($value_total); $amount += $value_total; $value['name'] = str_replace("manual", esc_html__("Paid By Admin", "ARMember"), $value['name']); $value['name'] = ucwords(str_replace("_", " ", $value['name'])); if (!empty($name) && strpos($name, $value['name']) === false) { $total = number_format( $value_total, $arm_currency_decimal,'.','' ); $name .= "{$value['name']} : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } else { $total = number_format( $previous_amt, $arm_currency_decimal,'.','' ) + number_format( $value_total, $arm_currency_decimal,'.','' ); $name = str_replace($previous_amt, $total, $name); } $previous_amt = number_format($total,$arm_currency_decimal,'.',''); } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $amount = number_format($amount,$arm_currency_decimal,'.',''); $total_amount .= "{$amount}, "; } } $gateway_name .= "]"; $tool_tip .= "]"; $total_amount .= "]"; if( $is_pagination ){ echo $table_content_html.'[ARM_REPORT_SEPARATOR]'.str_replace("\n", "", $dataPaging); //phpcs:ignore die; } ?> <script type="text/javascript" data-cfasync="false"> jQuery(".arm_payments_table_body_content").html("<?php echo $table_content_html; //phpcs:ignore?>"); jQuery("#arm_payments_table_paging").html('<?php echo str_replace("\n","", $dataPaging); //phpcs:ignore?>'); jQuery.noConflict(); jQuery(document).ready(function($){ var graph_type = "<?php echo $graph_type;//phpcs:ignore?>"; var gateway_name = <?php echo $gateway_name; //phpcs:ignore?>; var total_amount = <?php echo $total_amount; //phpcs:ignore?>; var tool_tip = <?php echo $tool_tip; //phpcs:ignore?>; var currency_symbol = '<?php echo html_entity_decode($currency_symbol); //phpcs:ignore?>'; if(graph_type == 'bar'){ var armChart = Highcharts.chart(<?php echo $chart; //phpcs:ignore?>, { chart: { type: 'column', }, title: { text: '' }, subtitle: { text: '' }, credits : { enabled : false }, xAxis: { categories: gateway_name, crosshair: true, labels: { rotation: - 60 }, min : 0.5 }, yAxis: { min: 0, allowDecimals: false, title: {text: 'Amount'} }, legend: { enabled: false }, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: {enabled: false, format: '{point.y}'}, lineColor: '#0077ff', } }, tooltip: { formatter: function() { var tooltip = ""; var index = this.point.index; var name = tool_tip[index]; if (name != ' ') { tooltip = '<span style="font-size:12px">' + name + '</span>'; tooltip += '<div style="color:' + this.series.color + '">Total : </div><b>' + currency_symbol + ' ' + this.y.toFixed(2) + '</b><div style="color:' + this.series.color + '"></div>'; } else { tooltip = '<div style="color:' + this.series.color + '">Total : </div><b>0.00' + currency_symbol + ' ' +'</b><div style="color:' + this.series.color + '"></div>'; } return tooltip; } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ name: "Membership", color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, data: total_amount, }], }); } else if(graph_type == 'line'){ var armChart = Highcharts.chart(<?php echo $chart; //phpcs:ignore?>, { chart: { type: 'areaspline', }, credits : { enabled : false }, title: { text: '' }, subtitle: { text: '' }, xAxis: { categories: gateway_name, crosshair: true, labels: { rotation: - 60 }, min : 0.5 }, yAxis: { min: 0, allowDecimals: false, title: { text: 'Amount' } }, legend: {enabled: false}, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: { enabled: false, format: '{point.y}' }, lineColor: '#0077ff', } }, tooltip: { formatter: function() { var tooltip = ""; var index = this.point.index; var name = tool_tip[index]; if (name != ' ') { tooltip = '<span style="font-size:12px">' + name + '</span>'; tooltip += '<div style="color:' + this.series.color + '">Total : </div><b>' + currency_symbol + ' ' + this.y.toFixed(2) + '</b><div style="color:' + this.series.color + '"></div>'; } else { tooltip = '<div style="color:' + this.series.color + '">Total : </div><b>' + currency_symbol + ' ' + '0.00</b><div style="color:' + this.series.color + '"></div>'; } return tooltip; } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, data: total_amount, }], }); } var normalState = new Object(); normalState.stroke_width1 = 1; normalState.stroke = '#afcaff'; normalState.fill = 'rgba(255,255,255,0.9)'; normalState.padding = 10; normalState.r = 6; normalState.width = 16; normalState.height = 16; normalState.align = 'center'; var hoverState = new Object(); hoverState = normalState; var pressedState = new Object(); pressedState = normalState; <?php if(empty($arm_disable_next_prev_btn)) { ?> armChart.renderer.button('', 56, 70, function(){arm_change_graph_pre('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_prev; //phpcs:ignore?>', 'payment_history')}, normalState, hoverState, pressedState).attr({id:'arm_prev_button',class:'<?php echo $arm_disable_class_prev; //phpcs:ignore?>'}).add().toFront(); armChart.renderer.button('', (armChart.chartWidth - 30), 70, function(){arm_change_graph_next('<?php echo $type; ?>','<?php echo $arm_enable_next; //phpcs:ignore?>', 'payment_history')}, normalState, hoverState, pressedState).attr({id:'arm_next_button',class:'<?php echo $arm_disable_class_next; //phpcs:ignore?>'}).add().toFront(); <?php } ?> jQuery('.highcharts-container').find('#arm_prev_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_prev_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M1.221,8.318l8.002,8.002l2.001-2L5.221,8.316l6.003-6.003 l-2.001-2L1.221,8.315l0.001,0.001L1.221,8.318z"/></svg>'); jQuery('.highcharts-container').find('#arm_next_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_next_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M11.431,8.601l-8.002,8.002l-2.001-2l6.003-6.003L1.428,2.596 l2.001-2l8.002,8.002L11.43,8.599L11.431,8.601z"/></svg>'); }); </script> <?php if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){?> <?php if($type == 'daily'){?> <div class="armchart_display_title arm_ml_5"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <?php }?> <?php if($type == 'monthly'){?> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title arm_ml_5"> <?php $month_year_lbl = !empty($filter_year) ? $filter_year : $new_month_year; ?> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($month_year_lbl) ?></label> </div> <?php }?> <?php if($type == 'yearly'){?> <div class="armchart_display_title arm_ml_5"> <label class="armcharttitle"><?php echo esc_html($new_year); ?></label> </div> <?php }?> <div class="armchart_plan_section"> <?php if(isset($arm_charts_plan_data) && count($arm_charts_plan_data)>0){ foreach ($arm_charts_plan_data as $arm_charts_plan_key => $arm_charts_plan_row) { ?> <div class="armchart_plan_item"> <label class="armchart_plan_title"><?php echo esc_html($arm_charts_plan_row['plan_name']); ?></label> <p class="armchart_plan_item_desc"><?php echo esc_html__("Total Transactions:", "ARMember");?> <?php echo count($arm_charts_plan_row['plan_transaction_user_ids']); //phpcs:ignore?><span class="arm_chart_total_amount"><?php echo esc_html__("Total Amount:", "ARMember");?> <?php echo number_format($arm_charts_plan_row['total_amount'], $arm_currency_decimal); //phpcs:ignore?></p> </div> <?php } }else{ echo '<div class="armchart_plan_no_item">'. esc_html__("Recently No Membership Plan purchased", "ARMember").'</div>'; } ?> </div> <div class="armchart_view_section"> <div class="page_title"> <span><?php esc_html_e('Payment History','ARMember');?></span> <div class="arm_chart_view_section arm_float_right"> <?php $selected_line_class = ($graph_type == 'line') ? 'selected' :''; $selected_bar_class = ($graph_type == 'bar') ? 'selected' :''; ?> <div class="armgraphtype armgraphtype_line armgraphtype_payment_history <?php echo esc_attr($selected_line_class);?>" id="armgraphtype_payment_history_div_line" onclick="arm_change_graph_type('line', 'payment_history')"> <input type="radio" value="line" id="armgraphtype_payment_history_line" name="armgraphtype_payment_history" <?php echo checked( $graph_type,'line');?>> </div> <div class="armgraphtype armgraphtype_bar armgraphtype_payment_history arm_margin_right_0 <?php echo esc_attr($selected_bar_class);?>" id="armgraphtype_payment_history_div_bar" onclick="arm_change_graph_type('bar', 'payment_history')"> <input type="radio" id="armgraphtype_payment_history_bar" value="bar" name="armgraphtype_payment_history" <?php echo checked( $graph_type,'bar');?>> </div> </div> </div> <?php }?> <div id="daily_payment_history" class="arm_padding_20" style="<?php echo ($type == 'daily') ? 'display:block;' : 'display:none'; ?>"> <?php if(!isset($_REQUEST['action'])){?> <div class="armchart_display_title"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <?php }?> <div id="chart1_payment_history" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_day); ?>" name="current_day" id="current_day" /> <input type="hidden" value="<?php echo esc_attr($new_day_month); ?>" name="current_day_month" id="current_day_month" /> <input type="hidden" value="<?php echo esc_attr($new_day_year); ?>" name="current_day_year" id="current_day_year" /> </div> <div id="monthly_payment_history" class="arm_padding_20" style="<?php echo ($type == 'monthly') ? 'display:block;' : 'display:none'; ?>"> <?php if(!isset($_REQUEST['action'])){?> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($new_month_year); ?></label> </div> <?php }?> <div id="chart2_payment_history" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_month); ?>" name="current_month" id="current_month" /> <input type="hidden" value="<?php echo esc_attr($new_month_year); ?>" name="current_month_year" id="current_month_year" /> </div> <div id="yearly_payment_history" class="arm_padding_20" style="<?php echo ($type == 'yearly') ? 'display:block;' : 'display:none'; ?>"> <div class="arlinks link_align"></div> <?php if(!isset($_REQUEST['action'])){?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_attr($new_year); ?></label> </div> <?php }?> <div id="chart3_payment_history" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_year); ?>" name="current_year" id="current_year" /> </div> <?php if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){?> </div> <?php }?> <?php } else if ($plan_type == 'pay_per_post_report') { $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; $chart = "chart2_pay_per_post_report"; $gateway_name = $total_amount = $tool_tip = "["; $gateway_name .= "' ', "; $tool_tip .= "' ', "; $total_amount .= "0, "; $ptquery = $wpdb->get_var("SELECT min(arm_created_date) FROM `{$ARMember->tbl_arm_payment_log}`"); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctquery = ""; $cbquery = ""; $ctquery_where = ""; $armctlist_query = ""; if(!empty($filter_plan_id)) { $ctquery_where .= $wpdb->prepare(" AND pt.arm_plan_id=%s",$filter_plan_id); } if(!empty($gateway_filter)) { $ctquery_where .= $wpdb->prepare(" AND pt.arm_payment_gateway=%s",$gateway_filter); } if (!empty($ptquery)) { $min_year = date('Y', strtotime($ptquery)); $min_month = date('m', strtotime($ptquery)); $min_date = date('d', strtotime($ptquery)); } $arm_disable_class_next = $arm_disable_class_prev = ''; $arm_enable_next = $arm_enable_prev = 1; $chart = "chart3_pay_per_post_report"; if ($type == 'yearly') { if ($new_year >= date('Y', $current_time)) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } if ($new_year <= $min_year) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $chart = "chart3_pay_per_post_report"; $from_year = "{$new_year}-01-01 00:00:00"; $end_year = "{$new_year}-12-31 23:59:59"; $ctquery = $wpdb->prepare("SELECT pt.arm_log_id,pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway, MONTH(pt.arm_created_date) AS time, SUM(pt.arm_amount) as Total FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s Group By pt.arm_payment_gateway, MONTH(pt.arm_created_date)",1,'success','1',1,0,$from_year,$end_year); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id,pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount, pt.arm_created_date, pt.arm_payment_gateway FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s",1,'success','1',1,0,$from_year,$end_year);//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $armctlist_query = $wpdb->prepare("SELECT pt.arm_user_id, pt.arm_amount, pt.arm_plan_id, pt.arm_created_date, pt.arm_payment_gateway, MONTH(pt.arm_created_date) AS time FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s",1,'success','1',1,0,$from_year,$end_year);//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } else if ($type == 'monthly') { $chart = "chart2_pay_per_post_report"; $date = $new_month_year.'-'.$new_month.'-'.date('m', $current_time); $day_first = date('01', strtotime($date)); $day_last = date('t', strtotime($date)); if(!empty($filter_year) && !empty($filter_month)) { $first = "{$filter_year}-{$filter_month}-{$day_first}"; $last = "{$filter_year}-{$filter_month}-{$day_last}"; } else { $first = "{$new_month_year}-{$new_month}-{$day_first}"; $last = "{$new_month_year}-{$new_month}-{$day_last}"; } $max_month_limit = date('Y-m',mktime(0, 0, 0, $new_month,1 , $new_month_year)); if ($max_month_limit >= date('Y-m')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $month_limit = date('Y-m-d',mktime(0, 0, 0, $new_month, 1, $new_month_year)); $min_month_limit = date('Y-m-d',mktime(0, 0, 0, $min_month, 1, $min_year)); if ($min_month_limit >= $month_limit) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $first_day = "{$first} 00:00:00"; $last_day = "{$last} 23:59:59"; $ctquery = $wpdb->prepare("SELECT pt.arm_log_id,pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway, DAY(pt.arm_created_date) as time, SUM(pt.arm_amount) as Total FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s Group By pt.arm_payment_gateway, DAY(pt.arm_created_date)",1,'success', '1',1,0,$first_day,$last_day); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id,pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount, pt.arm_created_date, pt.arm_payment_gateway FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE 1=1 AND pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s",1,'success', '1',1,0,$first_day,$last_day); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $armctlist_query = $wpdb->prepare("SELECT pt.arm_user_id, pt.arm_amount, pt.arm_plan_id, pt.arm_created_date, pt.arm_payment_gateway, DAY(pt.arm_created_date) as time FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s",1,'success', '1',1,0,$first_day,$last_day); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } else if ($type == 'daily') { $chart = "chart1_pay_per_post_report"; $date = "{$new_day_year}-{$new_day_month}-{$new_day}"; $date = date("Y-m-d", mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $max_date_limit = date('Y-m-d',mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); if ($max_date_limit >= date('Y-m-d')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $date_limit = date('Y-m-d', mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $min_date_limit = date('Y-m-d', mktime(0, 0, 0, $min_month, $min_date, $min_year)); if ($min_date_limit >= $date_limit) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $ctquery = $wpdb->prepare("SELECT pt.arm_log_id,pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway, TIME(pt.arm_created_date) as time, SUM(pt.arm_amount) as Total FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date LIKE %s",1,'success','1',1,0,$date.'%'); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id,pt.arm_user_id,pt.arm_plan_id,pt.arm_invoice_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount, pt.arm_created_date, pt.arm_payment_gateway FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE 1=1 AND pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date LIKE %s",1,'success','1',1,0,$date.'%');//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $armctlist_query = $wpdb->prepare("SELECT pt.arm_user_id, pt.arm_amount, pt.arm_plan_id, pt.arm_created_date, pt.arm_payment_gateway, TIME(pt.arm_created_date) as time FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) AND arm_is_post_payment = %d AND arm_is_gift_payment = %d {$ctquery_where} AND pt.arm_created_date LIKE %s",1,'success','1',1,0,$date.'%');//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } /for data table/ $table_data_arr = array(); $table_data_cnt = 0; $table_data_cnt_arr = $wpdb->get_results("SELECT arm_created_date, arm_payment_gateway, arm_user_id FROM ({$ctquery}) AS arm_pay_per_post_report_log", 'ARRAY_A');//phpcs:ignore --Reason $ctquery is a predefined Query $table_data_plan_list_arr = $wpdb->get_results("SELECT arm_plan_id, arm_amount, arm_created_date, arm_payment_gateway, arm_user_id FROM ({$armctlist_query}) AS arm_pay_per_post_report_log", 'ARRAY_A');//phpcs:ignore --Reason $armctlist_query is a predefined Query $perPage = 10; $offset = ($current_page - 1) * $perPage; if(!empty($gateway_filter)) { $payment_grid_query = $wpdb->get_results("SELECT arm_payment_gateway, time, Total FROM ({$ctquery}) AS arm_pay_per_post_report_log", 'ARRAY_A'); //phpcs:ignore --Reason $ctquery is a predefined Query /for data table/ $table_data_cnt = count($payment_grid_query); if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $payment_data_query = $wpdb->get_results("SELECT , u.user_login FROM ({$ctgquery}) as arm_pay_per_post_report_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_pay_per_post_report_log_data.arm_user_id", 'ARRAY_A');//phpcs:ignore --Reason $ctgquery is a predefined Query } else { $payment_data_query = $wpdb->get_results("SELECT arm_log_id,arm_created_date,arm_plan_id,arm_payment_gateway, arm_user_id, arm_payer_email, arm_invoice_id, arm_amount, arm_currency, u.user_login FROM ({$ctgquery}) as arm_pay_per_post_report_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_pay_per_post_report_log_data.arm_user_id LIMIT {$perPage} OFFSET {$offset}", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a predefined Query } $table_data_cnt2 = $wpdb->get_var( "SELECT COUNT() as total FROM ({$ctgquery}) AS arm_pay_per_post_report_log_data" );//phpcs:ignore --Reason $ctgquery is a predefined Query } else if(empty($gateway_filter)) { $payment_grid_query = $wpdb->get_results("SELECT arm_payment_gateway, time, Total FROM ({$ctquery}) AS arm_pay_per_post_report_log", 'ARRAY_A'); //phpcs:ignore --Reason $ctquery is a predefined Query /for data table/ $table_data_cnt = count($payment_grid_query); if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $payment_data_query = $wpdb->get_results("SELECT , u.user_login FROM ({$ctgquery}) as arm_pay_per_post_report_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_pay_per_post_report_log_data.arm_user_id", 'ARRAY_A');//phpcs:ignore --Reason $ctgquery is a predefined Query } else { $payment_data_query = $wpdb->get_results("SELECT arm_log_id,arm_created_date,arm_plan_id, arm_payment_gateway, arm_user_id, arm_payer_email, arm_invoice_id, arm_amount, arm_currency, u.user_login FROM ({$ctgquery}) as arm_pay_per_post_report_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_pay_per_post_report_log_data.arm_user_id ORDER BY arm_log_id DESC LIMIT {$perPage} OFFSET {$offset}", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a predefined Query } $table_data_cnt2 = $wpdb->get_var( "SELECT COUNT() as total FROM ({$ctgquery}) AS arm_pay_per_post_report_log_data" );//phpcs:ignore --Reason $ctgquery is a predefined Query } $wp_date_time_format = ""; if (is_multisite()) { $wp_date_time_format = get_option('date_format') . " " . get_option('time_format'); } else { $wp_date_time_format = get_site_option('date_format') . " " . get_site_option('time_format'); } $dataPaging = $arm_global_settings->arm_get_paging_links($current_page, $table_data_cnt2, $perPage, ''); $table_content_html = ""; $tab_row_cnt = 0; $arm_charts_plan_data=array(); if(!empty($table_data_plan_list_arr)) { foreach($table_data_plan_list_arr as $key => $table_data_cnt_val) { $arm_created_date = date_i18n($wp_date_time_format, strtotime($table_data_cnt_val['arm_created_date'])); $payment_gateway = ucfirst( str_replace('_', ' ', $table_data_cnt_val['arm_payment_gateway'] ) ); if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){ $arm_plan_id = $table_data_cnt_val['arm_plan_id']; if(!isset($arm_charts_plan_data[$arm_plan_id])) { $arm_plan_name = $arm_subscription_plans->arm_get_plan_name_by_id($arm_plan_id); $arm_charts_plan_data[$arm_plan_id]['plan_name'] = $arm_plan_name; } $arm_charts_plan_data[$arm_plan_id]['plan_transaction_user_ids'][] = $table_data_cnt_val['arm_user_id']; if(!isset($arm_charts_plan_data[$arm_plan_id]['total_amount'])) { $arm_charts_plan_data[$arm_plan_id]['total_amount'] = 0; } $arm_charts_plan_data[$arm_plan_id]['total_amount'] = $arm_charts_plan_data[$arm_plan_id]['total_amount'] + $table_data_cnt_val['arm_amount']; } } } if(!empty($payment_data_query)) { if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $arm_report_analytics->arm_export_report_to_csv($payment_data_query, $arm_report_type); exit; } $arm_plan_default_arr = array(); foreach ($payment_data_query as $key => $table_data) { $arm_created_date = date_i18n($wp_date_time_format, strtotime($table_data['arm_created_date'])); $payment_gateway = ucfirst( str_replace('_', ' ', $table_data['arm_payment_gateway'] ) ); if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts" && !empty($table_data['arm_user_id'])){ $plan_arr = get_user_meta($table_data['arm_user_id'], "arm_user_plan_ids", true); $paid_post_ids = get_user_meta($table_data['arm_user_id'], 'arm_user_post_ids', true); if(!empty($paid_post_ids)) { foreach($plan_arr as $key => $val) { if(empty($paid_post_ids[$val])) { unset($plan_arr[$key]); } } } $arm_gift_ids = get_user_meta($table_data['arm_user_id'], 'arm_user_gift_ids', true); if(!empty($arm_gift_ids)) { foreach($plan_arr as $arm_plan_key => $arm_plan_val) { if(in_array($arm_plan_val, $arm_gift_ids)) { unset($plan_arr[$arm_plan_key]); } } } if(!empty($plan_arr)) { foreach ($plan_arr as $key => $plan) { $arm_plan_name=$arm_subscription_plans->arm_get_plan_name_by_id($plan); } } } $member = !empty($table_data['user_login']) ? "<a class='arm_openpreview_popup' href='javascript:void(0)' data-id='".$table_data['arm_user_id']."' data-arm_hide_edit='1'>".$table_data['user_login']."</a>" : '-'; $paid_by = !empty($table_data['arm_payer_email']) ? $table_data['arm_payer_email'] : '-'; $arm_invoice_id = $arm_global_settings->arm_manipulate_invoice_id($table_data['arm_invoice_id']); $arm_log_type = ($table_data['arm_payment_gateway'] == 'bank_transfer') ? 'bt_log' : 'other'; $arm_invoice_id = "<a class='armhelptip arm_invoice_detail tipso_style' href='javascript:void(0)' data-log_type='".$arm_log_type."' data-log_id='".$table_data['arm_log_id']."'>".$arm_invoice_id."</a>"; if(!empty($arm_plan_default_arr[$table_data['arm_plan_id']])) { $arm_plan_name = $arm_plan_default_arr[$table_data['arm_plan_id']]; } else { $arm_plan_name = $arm_subscription_plans->arm_get_plan_name_by_id($table_data['arm_plan_id']); $arm_plan_name = !empty($arm_plan_name) ? $arm_plan_name : '-' ; $arm_plan_default_arr[$table_data['arm_plan_id']] = $arm_plan_name; } $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $table_content_html .= "<td>".$arm_invoice_id."</td>"; $table_content_html .= "<td>".$member."</tb>"; $table_content_html .= "<td>".$paid_by."</td>"; $table_content_html .= "<td>".$arm_plan_name."</td>"; $table_content_html .= "<td class='arm_align_right'>".number_format($table_data['arm_amount'],$arm_currency_decimal)." ".$table_data['arm_currency']."</td>"; $table_content_html .= "<td class='arm_align_center'>".$payment_gateway."</td>"; $table_content_html .= "<td>".$arm_created_date."</td>"; $table_content_html .= "</tr>"; $tab_row_cnt++; } } else { $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $table_content_html .= "<th class='arm_report_grid_no_data' colspan='7'>".esc_html__( 'No records found', 'ARMember')."</th>"; $table_content_html .= "</tr>"; } $payment_gt_data = array(); if (!empty($payment_grid_query)) { $j = 0; foreach ($payment_grid_query as $key => $payment_gt) { if ($type == "daily") { $payment_gt['time'] = !empty($payment_gt['time']) ? (int)$payment_gt['time'] : 0; $time = date("H:i", mktime($payment_gt['time'], 0)); } else { $time = $payment_gt['time']; } $payment_gt_data[$time][] = array( "name" => $payment_gt['arm_payment_gateway'], "total" => number_format( $payment_gt['Total'], $arm_currency_decimal, '.', ''), ); } } $tooltip = ""; if ($type == "yearly") { for ($i = 1; $i <= 12; $i++) { $amount = 0; $new_month_year = empty($new_month_year) ? $new_year : $new_month_year; $gateway_name .= "'".date('M',mktime(0, 0, 0, $i, 1, $new_month_year))."', "; if (isset($payment_gt_data[$i]) && !empty($payment_gt_data[$i])) { $name = ""; foreach ($payment_gt_data[$i] as $key => $value) { $value_total = str_replace(",","",$value['total']); $value_total = floatval($value_total); if ($value['name'] == "manual") { $name .= esc_html__("Paid By Admin", "ARMember")." : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } else { $title = ucwords(str_replace("_", " ", $value['name'])); $name .= "{$title} : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } $amount += $value_total; } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $amount = number_format($amount,$arm_currency_decimal,'.',''); $total_amount .= "{$amount}, "; } } else if ($type == "monthly") { $month_name = date("M", mktime(0, 0, 0, $new_month, 1)); for ($i = 1; $i <= $day_last; $i++) { $amount = 0; $gateway_name .= "'{$i}-{$month_name}', "; if (isset($payment_gt_data[$i]) && !empty($payment_gt_data[$i])) { $name = ""; foreach ($payment_gt_data[$i] as $key => $value) { $value_total = str_replace(",","",$value['total']); $value_total = floatval($value_total); if ($value['name'] == "manual") { $name .= esc_html__("Paid By Admin", "ARMember")." : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } else { $title = ucwords(str_replace("_", " ", $value['name'])); $name .= "{$title} : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } $amount += number_format($value_total,$arm_currency_decimal,'.',''); } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $amount = number_format($amount,$arm_currency_decimal,'.',''); $total_amount .= "{$amount}, "; } } else { for ($i = 0; $i <= 23; $i++) { $amount = 0; $hour = mktime("{$i}", 0); $current_hour = date('H:i', $hour); $next_hour = date('H:i', strtotime("+1 hour", $hour)); $gateway_name .= "'{$current_hour}', "; $name = ""; $previous_amt=0; if (isset($payment_gt_data[$current_hour]) && !empty($payment_gt_data[$current_hour])) { foreach ($payment_gt_data[$current_hour] as $key => $value) { $value_total = str_replace(",","",$value['total']); $value_total = floatval($value_total); $amount += $value_total; $value['name'] = str_replace("manual", esc_html__("Paid By Admin", "ARMember"), $value['name']); $value['name'] = ucwords(str_replace("_", " ", $value['name'])); if (!empty($name) && strpos($name, $value['name']) === false) { $total = number_format( $value_total, $arm_currency_decimal,'.','' ); $name .= "{$value['name']} : ".number_format($value_total,$arm_currency_decimal,'.','')."<br>"; } else { $total = number_format( $previous_amt, $arm_currency_decimal,'.','' ) + number_format( $value_total, $arm_currency_decimal,'.','' ); $name = str_replace($previous_amt, $total, $name); } $previous_amt = number_format($total,$arm_currency_decimal,'.',''); } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $amount = number_format($amount,$arm_currency_decimal,'.',''); $total_amount .= "{$amount}, "; } } $gateway_name .= "]"; $tool_tip .= "]"; $total_amount .= "]"; if( $is_pagination ){ echo $table_content_html.'[ARM_REPORT_SEPARATOR]'.str_replace("\n", "", $dataPaging); //phpcs:ignore die; } ?> <script type="text/javascript" data-cfasync="false"> jQuery(".arm_pay_per_post_report_table_body_content").html("<?php echo $table_content_html; //phpcs:ignore?>"); jQuery("#arm_payments_table_paging").html('<?php echo str_replace("\n","", $dataPaging); //phpcs:ignore?>'); jQuery.noConflict(); jQuery(document).ready(function($){ var graph_type = "<?php echo $graph_type; //phpcs:ignore?>"; var gateway_name = <?php echo $gateway_name; //phpcs:ignore?>; var total_amount = <?php echo $total_amount; //phpcs:ignore?>; var tool_tip = <?php echo $tool_tip;//phpcs:ignore ?>; var currency_symbol = '<?php echo html_entity_decode($currency_symbol); //phpcs:ignore?>'; if(graph_type == 'bar'){ var armChart = Highcharts.chart(<?php echo $chart; //phpcs:ignore?>, { chart: { type: 'column', }, title: { text: '' }, subtitle: { text: '' }, credits : { enabled : false }, xAxis: { categories: gateway_name, crosshair: true, labels: { rotation: - 60 }, min : 0.5 }, yAxis: { min: 0, allowDecimals: false, title: {text: 'Amount'} }, legend: { enabled: false }, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: {enabled: false, format: '{point.y}'}, lineColor: '#0077ff', } }, tooltip: { formatter: function() { var tooltip = ""; var index = this.point.index; var name = tool_tip[index]; if (name != ' ') { tooltip = '<span style="font-size:12px">' + name + '</span>'; tooltip += '<div style="color:' + this.series.color + '">Total : </div><b>' + currency_symbol + ' ' + this.y.toFixed(2) + '</b><div style="color:' + this.series.color + '"></div>'; } else { tooltip = '<div style="color:' + this.series.color + '">Total : </div><b>0.00' + currency_symbol + ' ' +'</b><div style="color:' + this.series.color + '"></div>'; } return tooltip; } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ name: "Membership", color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, data: total_amount, }], }); } else if(graph_type == 'line'){ var armChart = Highcharts.chart(<?php echo $chart; //phpcs:ignore?>, { chart: { type: 'areaspline', }, credits : { enabled : false }, title: { text: '' }, subtitle: { text: '' }, xAxis: { categories: gateway_name, crosshair: true, labels: { rotation: - 60 }, min : 0.5 }, yAxis: { min: 0, allowDecimals: false, title: { text: 'Amount' } }, legend: {enabled: false}, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: { enabled: false, format: '{point.y}' }, lineColor: '#0077ff', } }, tooltip: { formatter: function() { var tooltip = ""; var index = this.point.index; var name = tool_tip[index]; if (name != ' ') { tooltip = '<span style="font-size:12px">' + name + '</span>'; tooltip += '<div style="color:' + this.series.color + '">Total : </div><b>' + currency_symbol + ' ' + this.y.toFixed(2) + '</b><div style="color:' + this.series.color + '"></div>'; } else { tooltip = '<div style="color:' + this.series.color + '">Total : </div><b>' + currency_symbol + ' ' + '0.00</b><div style="color:' + this.series.color + '"></div>'; } return tooltip; } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, data: total_amount, }], }); } var normalState = new Object(); normalState.stroke_width1 = 1; normalState.stroke = '#afcaff'; normalState.fill = 'rgba(255,255,255,0.9)'; normalState.padding = 10; normalState.r = 6; normalState.width = 16; normalState.height = 16; normalState.align = 'center'; var hoverState = new Object(); hoverState = normalState; var pressedState = new Object(); pressedState = normalState; <?php if(empty($arm_disable_next_prev_btn)) { ?> armChart.renderer.button('', 56, 70, function(){arm_change_graph_pre('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_prev; //phpcs:ignore?>', 'pay_per_post_report')}, normalState, hoverState, pressedState).attr({id:'arm_prev_button',class:'<?php echo $arm_disable_class_prev; //phpcs:ignore?>'}).add().toFront(); armChart.renderer.button('', (armChart.chartWidth - 30), 70, function(){arm_change_graph_next('<?php echo $type; ?>','<?php echo $arm_enable_next; //phpcs:ignore?>', 'pay_per_post_report')}, normalState, hoverState, pressedState).attr({id:'arm_next_button',class:'<?php echo $arm_disable_class_next;//phpcs:ignore ?>'}).add().toFront(); <?php } ?> jQuery('.highcharts-container').find('#arm_prev_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_prev_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M1.221,8.318l8.002,8.002l2.001-2L5.221,8.316l6.003-6.003 l-2.001-2L1.221,8.315l0.001,0.001L1.221,8.318z"/></svg>'); jQuery('.highcharts-container').find('#arm_next_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_next_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M11.431,8.601l-8.002,8.002l-2.001-2l6.003-6.003L1.428,2.596 l2.001-2l8.002,8.002L11.43,8.599L11.431,8.601z"/></svg>'); }); </script> <?php if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){?> <?php if($type == 'daily'){?> <div class="armchart_display_title arm_ml_5"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <?php }?> <?php if($type == 'monthly'){?> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title arm_ml_5"> <?php $month_year_lbl = !empty($filter_year) ? $filter_year : $new_month_year; ?> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($month_year_lbl); ?></label> </div> <?php }?> <?php if($type == 'yearly'){?> <div class="armchart_display_title arm_ml_5"> <label class="armcharttitle"><?php echo esc_html($new_year); ?></label> </div> <?php }?> <div class="armchart_plan_section"> <?php if(isset($arm_charts_plan_data) && count($arm_charts_plan_data)>0){ foreach ($arm_charts_plan_data as $arm_charts_plan_key => $arm_charts_plan_row) { ?> <div class="armchart_plan_item"> <label class="armchart_plan_title"><?php echo esc_html($arm_charts_plan_row['plan_name']); ?></label> <p class="armchart_plan_item_desc"><?php echo esc_html__("Total Transactions:", "ARMember");?> <?php echo count($arm_charts_plan_row['plan_transaction_user_ids']); ?><span class="arm_chart_total_amount"><?php echo esc_html__("Total Amount:", "ARMember");?> <?php echo esc_html($arm_charts_plan_row['total_amount']); ?></span></p> </div> <?php } }else{ echo '<div class="armchart_plan_no_item">'. esc_html__("Recently No Membership Plan purchased", "ARMember").'</div>'; } ?> </div> <div class="armchart_view_section"> <div class="page_title"> <span><?php esc_html_e('Pay per post history','ARMember');?></span> <div class="arm_chart_view_section arm_float_right"> <?php $selected_line_class = ($graph_type == 'line') ? 'selected' :''; $selected_bar_class = ($graph_type == 'bar') ? 'selected' :''; ?> <div class="armgraphtype armgraphtype_line armgraphtype_pay_per_post_report <?php echo esc_attr($selected_line_class);?>" id="armgraphtype_pay_per_post_report_div_line" onclick="arm_change_graph_type('line', 'pay_per_post_report')"> <input type="radio" value="line" id="armgraphtype_pay_per_post_report_line" name="armgraphtype_pay_per_post_report" <?php echo checked( $graph_type, 'line');?>> </div> <div class="armgraphtype armgraphtype_bar armgraphtype_pay_per_post_report arm_margin_right_0 <?php echo esc_attr($selected_bar_class);?>" id="armgraphtype_pay_per_post_report_div_bar" onclick="arm_change_graph_type('bar', 'pay_per_post_report')"> <input type="radio" id="armgraphtype_pay_per_post_report_bar" value="bar" name="armgraphtype_pay_per_post_report" <?php echo checked( $graph_type, 'bar');?>> </div> </div> </div> <?php }?> <div id="daily_pay_per_post_report" class="arm_padding_20" style="<?php echo ($type == 'daily') ? 'display:block;' : 'display:none'; ?>"> <?php if(!isset($_REQUEST['action'])){?> <div class="armchart_display_title"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <?php }?> <div id="chart1_pay_per_post_report" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_day); ?>" name="current_day" id="current_day" /> <input type="hidden" value="<?php echo esc_attr($new_day_month); ?>" name="current_day_month" id="current_day_month" /> <input type="hidden" value="<?php echo esc_attr($new_day_year); ?>" name="current_day_year" id="current_day_year" /> </div> <div id="monthly_pay_per_post_report" class="arm_padding_20" style="<?php echo ($type == 'monthly') ? 'display:block;' : 'display:none'; ?>"> <?php if(!isset($_REQUEST['action'])){?> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($new_month_year); ?></label> </div> <?php }?> <div id="chart2_pay_per_post_report" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_month); ?>" name="current_month" id="current_month" /> <input type="hidden" value="<?php echo esc_attr($new_month_year); ?>" name="current_month_year" id="current_month_year" /> </div> <div id="yearly_pay_per_post_report" class="arm_padding_20" style=" <?php echo ($type == 'yearly') ? 'display:block;' : 'display:none'; ?>"> <div class="arlinks link_align"></div> <?php if(!isset($_REQUEST['action'])){?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_html($new_year); ?></label> </div> <?php }?> <div id="chart3_pay_per_post_report" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_year); ?>" name="current_year" id="current_year" /> </div> <?php if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){?> </div> <?php }?> <?php } elseif($plan_type == 'coupon_report') { $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; $chart = "chart2_coupon_report"; $coupon_name = $total_user = $tool_tip = "["; $coupon_name .= "' ', "; $tool_tip .= "' ', "; $total_user .= "0, "; $ptquery = $wpdb->get_var("SELECT min(arm_created_date) FROM `{$ARMember->tbl_arm_payment_log}`"); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctquery = ""; $cbquery = ""; $ctquery_where = ""; $cou_dis_zero = $wpdb->prepare("AND pt.arm_coupon_code != %s ",''); if(!empty($gateway_filter)) { $ctquery_where .= $wpdb->prepare(" AND pt.arm_payment_gateway=%s",$gateway_filter); } if (!empty($arm_search_coupon)) { $ctquery_where .= $wpdb->prepare(" AND pt.arm_coupon_code LIKE %s",$arm_search_coupon.'%'); } if (!empty($ptquery)) { $min_year = date('Y', strtotime($ptquery)); $min_month = date('m', strtotime($ptquery)); $min_date = date('d', strtotime($ptquery)); } $arm_disable_class_next = $arm_disable_class_prev = ''; $arm_enable_next = $arm_enable_prev = 1; $chart = "chart3_coupon_report"; if ($type == 'yearly') { if ($new_year >= date('Y', $current_time)) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } if ($new_year <= $min_year) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $chart = "chart3_coupon_report"; $from_year = "{$new_year}-01-01 00:00:00"; $end_year = "{$new_year}-12-31 23:59:59"; $ctquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway,pt.arm_coupon_code,pt.arm_coupon_discount,pt.arm_coupon_discount_type, MONTH(pt.arm_created_date) AS time,count(pt.arm_coupon_code) as Number_of_user FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) {$cou_dis_zero} {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s Group By pt.arm_coupon_code, MONTH(pt.arm_created_date)",1,'success','1',$from_year,$end_year); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount,pt.arm_created_date, pt.arm_payment_gateway,pt.arm_coupon_code,pt.arm_coupon_discount,pt.arm_coupon_discount_type, pt.arm_plan_id FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) {$cou_dis_zero} {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s",1,'success','1',$from_year,$end_year);//phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } else if ($type == 'monthly') { $chart = "chart2_coupon_report"; $date = $new_month_year.'-'.$new_month.'-'.date('m', $current_time); $day_first = date('01', strtotime($date)); $day_last = date('t', strtotime($date)); if(!empty($filter_year) && !empty($filter_month)) { $first = "{$filter_year}-{$filter_month}-{$day_first} 00:00:00"; $last = "{$filter_year}-{$filter_month}-{$day_last} 23:59:59"; } else { $first = "{$new_month_year}-{$new_month}-{$day_first} 00:00:00"; $last = "{$new_month_year}-{$new_month}-{$day_last} 23:59:59"; } $max_month_limit = date('Y-m',mktime(0, 0, 0, $new_month,1 , $new_month_year)); if ($max_month_limit >= date('Y-m')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $month_limit = date('Y-m-d',mktime(0, 0, 0, $new_month, 1, $new_month_year)); $min_month_limit = date('Y-m-d',mktime(0, 0, 0, $min_month, 1, $min_year)); if ($min_month_limit >= $month_limit) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $first_day = "{$first} 00:00:00"; $last_day = "{$last} 23:59:59"; $ctquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway,pt.arm_coupon_code,pt.arm_coupon_discount,pt.arm_coupon_discount_type, DAY(pt.arm_created_date) as time, count(pt.arm_coupon_code) as Number_of_user FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) {$cou_dis_zero} {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s Group By pt.arm_coupon_code, DAY(pt.arm_created_date)",1,'success','1',$first_day,$last_day); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount, pt.arm_created_date, pt.arm_payment_gateway,pt.arm_coupon_code,pt.arm_coupon_discount,pt.arm_coupon_discount_type, pt.arm_plan_id FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE 1=1 AND pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) {$cou_dis_zero} {$ctquery_where} AND pt.arm_created_date BETWEEN %s AND %s",1,'success','1',$first_day,$last_day); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } else if ($type == 'daily') { $chart = "chart1_coupon_report"; $date = "{$new_day_year}-{$new_day_month}-{$new_day}"; $date = date("Y-m-d", mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $max_date_limit = date('Y-m-d',mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); if ($max_date_limit >= date('Y-m-d')) { $arm_disable_class_next = 'arm_disabled_class_next'; $arm_enable_next = 0; } $date_limit = date('Y-m-d', mktime(0, 0, 0, $new_day_month, $new_day, $new_day_year)); $min_date_limit = date('Y-m-d', mktime(0, 0, 0, $min_month, $min_date, $min_year)); if ($min_date_limit >= $date_limit) { $arm_disable_class_prev = 'arm_disabled_class_prev'; $arm_enable_prev = 0; } $filtered_date = $date.'%'; $ctquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id, pt.arm_payer_email, pt.arm_amount, pt.arm_created_date, pt.arm_payment_gateway,pt.arm_coupon_code,pt.arm_coupon_discount,pt.arm_coupon_discount_type, TIME(pt.arm_created_date) as time, count(pt.arm_coupon_code) as Number_of_user FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) {$cou_dis_zero}{$ctquery_where} AND pt.arm_created_date LIKE %s",1,'success','1',$filtered_date); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name $ctgquery = $wpdb->prepare("SELECT pt.arm_log_id, pt.arm_user_id, pt.arm_payer_email, pt.arm_currency, pt.arm_amount AS arm_amount, pt.arm_created_date, pt.arm_payment_gateway,pt.arm_coupon_code,pt.arm_coupon_discount,pt.arm_coupon_discount_type, pt.arm_plan_id FROM `{$ARMember->tbl_arm_payment_log}` pt WHERE 1=1 AND pt.arm_display_log = %d AND (pt.arm_transaction_status = %s \|\| pt.arm_transaction_status = %s) {$cou_dis_zero}{$ctquery_where} AND pt.arm_created_date LIKE %s",1,'success','1',$filtered_date); //phpcs:ignore --Reason $ARMember->tbl_arm_payment_log is a table name } /for data table/ $table_data_arr = array(); $table_data_cnt = 0; $table_data_cnt_arr = $wpdb->get_results("SELECT arm_log_id, arm_amount, arm_created_date, arm_payment_gateway,arm_coupon_code,arm_coupon_discount,arm_coupon_discount_type, arm_user_id FROM ({$ctgquery}) AS arm_payment_history_log_data", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a query name $perPage = 10; $offset = ($current_page - 1) * $perPage; if(!empty($gateway_filter) \|\| !empty($arm_search_coupon)) { $payment_grid_query = $wpdb->get_results("SELECT arm_coupon_code,Number_of_user, time FROM ({$ctquery}) AS arm_payment_history_log", 'ARRAY_A'); //phpcs:ignore --Reason $ctquery is a query name /for data table/ $table_data_cnt = count($payment_grid_query); if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $payment_data_query = $wpdb->get_results("SELECT , u.user_login FROM ({$ctgquery}) as arm_payment_history_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_payment_history_log_data.arm_user_id", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a query name } else { $payment_data_query = $wpdb->get_results("SELECT arm_log_id, arm_created_date, arm_payment_gateway, arm_user_id, arm_payer_email, arm_amount, arm_currency,arm_coupon_code,arm_coupon_discount,arm_coupon_discount_type, arm_plan_id, u.user_login, p.arm_subscription_plan_name FROM ({$ctgquery}) as arm_payment_history_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_payment_history_log_data.arm_user_id LEFT JOIN `{$ARMember->tbl_arm_subscription_plans}` p ON p.arm_subscription_plan_id = arm_payment_history_log_data.arm_plan_id LIMIT {$perPage} OFFSET {$offset}", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a query name } $table_data_cnt2 = $wpdb->get_var( "SELECT COUNT() as total FROM ({$ctgquery}) AS arm_payment_history_log_data" ); //phpcs:ignore --Reason $ctgquery is a query name } else if(empty($gateway_filter)) { $payment_grid_query = $wpdb->get_results("SELECT arm_coupon_code,Number_of_user, time FROM ({$ctquery}) AS arm_payment_history_log", 'ARRAY_A'); //phpcs:ignore --Reason $ctquery is a query name /for data table/ $table_data_cnt = count($payment_grid_query); if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $payment_data_query = $wpdb->get_results("SELECT , u.user_login, p.arm_subscription_plan_name FROM ({$ctgquery}) as arm_payment_history_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_payment_history_log_data.arm_user_id LEFT JOIN `{$ARMember->tbl_arm_subscription_plans}` p ON p.arm_subscription_plan_id = arm_payment_history_log_data.arm_plan_id", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a query name } else { $payment_data_query = $wpdb->get_results("SELECT arm_log_id, arm_created_date, arm_payment_gateway,arm_coupon_code,arm_coupon_discount,arm_coupon_discount_type, arm_user_id, arm_payer_email, arm_amount, arm_currency, arm_plan_id, u.user_login, p.arm_subscription_plan_name FROM ({$ctgquery}) as arm_payment_history_log_data LEFT JOIN `{$user_table}` u ON u.ID = arm_payment_history_log_data.arm_user_id LEFT JOIN `{$ARMember->tbl_arm_subscription_plans}` p ON p.arm_subscription_plan_id = arm_payment_history_log_data.arm_plan_id ORDER BY arm_log_id DESC LIMIT {$perPage} OFFSET {$offset}", 'ARRAY_A'); //phpcs:ignore --Reason $ctgquery is a query name } $table_data_cnt2 = $wpdb->get_var( "SELECT COUNT() as total FROM ({$ctgquery}) AS arm_payment_history_log_data" ); //phpcs:ignore --Reason $ctgquery is a query name } $wp_date_time_format = ""; if (is_multisite()) { $wp_date_time_format = get_option('date_format') . " " . get_option('time_format'); } else { $wp_date_time_format = get_site_option('date_format') . " " . get_site_option('time_format'); } $dataPaging = $arm_global_settings->arm_get_paging_links($current_page, $table_data_cnt2, $perPage, ''); $table_content_html = ""; $tab_row_cnt = 0; $arm_charts_plan_data=array(); $arm_charts_plan_cnt = 0; if(!empty($table_data_cnt_arr)) { foreach($table_data_cnt_arr as $key => $table_data_cnt_val) { $arm_created_date = date_i18n($wp_date_time_format, strtotime($table_data_cnt_val['arm_created_date'])); $payment_gateway = ucfirst( str_replace('_', ' ', $table_data_cnt_val['arm_payment_gateway'] ) ); if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts" ){ $coupon_code = isset($table_data_cnt_val['arm_coupon_code']) ? $table_data_cnt_val['arm_coupon_code'] : ''; if(!empty($coupon_code)) { $arm_charts_plan_data[$coupon_code]['coupon_label']=$coupon_code; $arm_charts_plan_data[$coupon_code]['coupon_users'][]=$table_data_cnt_val['arm_user_id']; $arm_charts_plan_cnt++; if(!isset($arm_charts_plan_data[$coupon_code]['total_amount'])) { $arm_charts_plan_data[$coupon_code]['total_amount'] = 0; } $arm_charts_plan_data[$coupon_code]['total_amount'] = $arm_charts_plan_data[$coupon_code]['total_amount'] + $table_data_cnt_val['arm_amount']; } } } } if(!empty($payment_data_query)) { if($is_export_to_csv == true \|\| $is_export_to_csv == '1') { $arm_report_analytics->arm_export_report_to_csv($payment_data_query, $arm_report_type); exit; } foreach ($payment_data_query as $key => $table_data) { $arm_created_date = date_i18n($wp_date_time_format, strtotime($table_data['arm_created_date'])); $payment_gateway = ucfirst( str_replace('_', ' ', $table_data['arm_payment_gateway'] ) ); $paid_by = !empty($table_data['user_login']) ? "<a class='arm_openpreview_popup' href='javascript:void(0)' data-id='".$table_data['arm_user_id']."' data-arm_hide_edit='1'>".$table_data['user_login']."</a>" : $arm_default_user_details_text; $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $arm_log_type = ($table_data['arm_payment_gateway'] == 'bank_transfer') ? 'bt_log' : 'other'; $arm_coupon_discount = $table_data['arm_coupon_discount']; $arm_coupon_code = $table_data['arm_coupon_code']; $arm_coupon_discount_type = $table_data['arm_coupon_discount_type']; $arm_plan_name = $table_data['arm_subscription_plan_name']; $table_content_html .= "<td>".$arm_coupon_code."</td>"; $table_content_html .= "<td class='arm_align_right'>".number_format($arm_coupon_discount,$arm_currency_decimal)." ".$arm_coupon_discount_type."</td>"; $table_content_html .= "<td>".$paid_by."</td>"; $table_content_html .= "<td>".$arm_plan_name."</td>"; $table_content_html .= "<td class='arm_align_right'>".number_format($table_data['arm_amount'],$arm_currency_decimal)." ".$table_data['arm_currency']."</td>"; $table_content_html .= "<td class='arm_align_center'>".$payment_gateway."</td>"; $table_content_html .= "<td>".$arm_created_date."</td>"; $table_content_html .= "</tr>"; $tab_row_cnt++; } } else { $table_content_html .= "<tr class='arm_member_last_subscriptions_data'>"; $table_content_html .= "<th class='arm_report_grid_no_data' colspan='7'>".esc_html__( 'No records found', 'ARMember')."</th>"; $table_content_html .= "</tr>"; } $payment_gt_data = array(); if (!empty($payment_grid_query)) { $j = 0; foreach ($payment_grid_query as $key => $payment_gt) { $arm_coupon_code=isset($payment_gt['arm_coupon_code']) ? $payment_gt['arm_coupon_code'] : ''; $arm_coupon_label= $wpdb->get_var($wpdb->prepare("SELECT `arm_coupon_label` FROM `$ARMember->tbl_arm_coupons` WHERE `arm_coupon_code` = %s", $arm_coupon_code)); //phpcs:ignore --Reason $ARMember->tbl_arm_coupons is a table name if ($type == "daily") { $time_hr = $payment_gt['time']; if(str_contains($time_hr,':')) { $time_arr = explode(':',$time_hr); $time_hr = $time_arr[0]; } $time = date("H:i", mktime($time_hr, 0)); } else { $time = $payment_gt['time']; } $payment_gt_data[$time][] = array( "name" => $arm_coupon_label, "total" => number_format( $payment_gt['Number_of_user']), ); } } $tooltip = ""; if ($type == "yearly") { for ($i = 1; $i <= 12; $i++) { $user = 0; $new_month_year = empty($new_month_year) ? $new_year : $new_month_year; $coupon_name .= "'".date('M',mktime(0, 0, 0, $i, 1, $new_month_year))."', "; if (isset($payment_gt_data[$i]) && !empty($payment_gt_data[$i])) { $name = ""; foreach ($payment_gt_data[$i] as $key => $value) { $value_total = str_replace(",","",$value['total']); $value_total = floatval($value_total); if ($value['name'] == "manual") { $name .= esc_html__("Paid By Admin", "ARMember")." : ".number_format($value_total)."<br>"; } else { $title = ucwords(str_replace("_", " ", $value['name'])); $name .= "{$title} : ".number_format($value_total)."<br>"; } $user += $value_total; } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $user = number_format($user); $total_user .= "{$user}, "; } } else if ($type == "monthly") { $month_name = date("M", mktime(0, 0, 0, $new_month, 1)); for ($i = 1; $i <= $day_last; $i++) { $user= 0; $coupon_name .= "'{$i}-{$month_name}', "; if (isset($payment_gt_data[$i]) && !empty($payment_gt_data[$i])) { $name = ""; foreach ($payment_gt_data[$i] as $key => $value) { $value_total = str_replace(",","",$value['total']); if ($value['name'] == "manual") { $name .= esc_html__("Paid By Admin", "ARMember")." : ".number_format($value_total)."<br>"; } else { $title = ucwords(str_replace("_", " ", $value['name'])); $name .= "{$title} : ".number_format($value_total)."<br>"; } $user += number_format($value_total); } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $user = number_format($user); $total_user .= "{$user}, "; } } else { for ($i = 0; $i <= 23; $i++) { $user = 0; $hour = mktime("{$i}", 0); $current_hour = date('H:i', $hour); $next_hour = date('H:i', strtotime("+1 hour", $hour)); $coupon_name .= "'{$current_hour}', "; $name = ""; $previous_amt = 0; if (isset($payment_gt_data[$current_hour]) && !empty($payment_gt_data[$current_hour])) { foreach ($payment_gt_data[$current_hour] as $key => $value) { $value_total = str_replace(",","",$value['total']); $value_total = floatval($value_total); $user += $value_total; $value['name'] = str_replace("manual", esc_html__("Paid By Admin", "ARMember"), $value['name']); $value['name'] = ucwords(str_replace("_", " ", $value['name'])); if (!empty($name) && strpos($name, $value['name']) === false) { $total = number_format( $value_total); $name .= "{$value['name']} : ".number_format($value_total,2,'.','')."<br>"; } else { $total = number_format( $previous_amt) + number_format( $value_total ); $name = str_replace($previous_amt, $total, $name); } $previous_amt = number_format($total); } $tool_tip .= "'{$name}', "; } else { $tool_tip .= "' ', "; } $user = number_format($user); $total_user .= "{$user}, "; } } $coupon_name .= "]"; $tool_tip .= "]"; $total_user .= "]"; if( $is_pagination ){ echo $table_content_html.'[ARM_REPORT_SEPARATOR]'.str_replace("\n", "", $dataPaging); //phpcs:ignore die; } ?> <script type="text/javascript" data-cfasync="false"> jQuery(".arm_coupon_report_table_body_content").html("<?php echo $table_content_html; //phpcs:ignore?>"); jQuery("#arm_coupon_report_table_paging").html('<?php echo str_replace("\n","", $dataPaging); //phpcs:ignore?>'); jQuery.noConflict(); jQuery(document).ready(function($){ var graph_type = "<?php echo $graph_type; //phpcs:ignore?>"; var gateway_name = <?php echo $coupon_name; //phpcs:ignore?>; var total_amount = <?php echo $total_user; //phpcs:ignore?>; var tool_tip = <?php echo $tool_tip; //phpcs:ignore?>; var currency_symbol = '<?php echo html_entity_decode(''); //phpcs:ignore?>'; if(graph_type == 'bar'){ var armChart = Highcharts.chart(<?php echo $chart; //phpcs:ignore?>, { chart: { type: 'column', }, title: { text: '' }, subtitle: { text: '' }, credits : { enabled : false }, xAxis: { categories: gateway_name, crosshair: true, labels: { rotation: - 60 }, min : 0.5 }, yAxis: { min: 0, allowDecimals: false, title: {text: 'Coupons'} }, legend: { enabled: false }, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: {enabled: false, format: '{point.y}'}, lineColor: '#0077ff', } }, tooltip: { formatter: function() { var tooltip = ""; var index = this.point.index; var name = tool_tip[index]; if (name != ' ') { tooltip += '<div style="color:' + this.series.color + '">Total Coupons: </div><b>' + this.y + '</b><div style="color:' + this.series.color + '"></div>'; } else { tooltip = '<div style="color:' + this.series.color + '">Total Coupons: </div><b>0</b><div style="color:' + this.series.color + '"></div>'; } return tooltip; } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ name: "Membership", color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, data: total_amount, }], }); } else if(graph_type == 'line'){ var armChart = Highcharts.chart(<?php echo $chart; //phpcs:ignore?>, { chart: { type: 'areaspline', }, credits : { enabled : false }, title: { text: '' }, subtitle: { text: '' }, xAxis: { categories: gateway_name, crosshair: true, labels: { rotation: - 60 }, min : 0.5 }, yAxis: { min: 0, allowDecimals: false, title: { text: 'Coupons' } }, legend: {enabled: false}, plotOptions: { areaspline: { fillOpacity: 0.05, dataLabels: { enabled: false, format: '{point.y}' }, lineColor: '#0077ff', } }, tooltip: { formatter: function() { var tooltip = ""; var index = this.point.index; var name = tool_tip[index]; if (name != ' ') { tooltip += '<div style="color:' + this.series.color + '">Total Coupons: </div><b>' + this.y + '</b><div style="color:' + this.series.color + '"></div>'; } else { tooltip = '<div style="color:' + this.series.color + '">Total Coupons: </div><b>0</b><div style="color:' + this.series.color + '"></div>'; } return tooltip; } }, colors: ['#766ed2;', '#fbc32b', '#fc6458', '#a7db1b', '#20d381', '#0077ff', '#4da4fe'], series: [{ color: 'rgb(0, 119, 255)', colorByPoint: true, lineWidth: 2, data: total_amount, }], }); } var normalState = new Object(); normalState.stroke_width1 = 1; normalState.stroke = '#afcaff'; normalState.fill = 'rgba(255,255,255,0.9)'; normalState.padding = 10; normalState.r = 6; normalState.width = 16; normalState.height = 16; normalState.align = 'center'; var hoverState = new Object(); hoverState = normalState; var pressedState = new Object(); pressedState = normalState; <?php if(empty($arm_disable_next_prev_btn)) { ?> armChart.renderer.button('', 56, 70, function(){arm_change_graph_pre('<?php echo $type;//phpcs:ignore ?>','<?php echo $arm_enable_prev; //phpcs:ignore?>', 'coupon_report')}, normalState, hoverState, pressedState).attr({id:'arm_prev_button',class:'<?php echo $arm_disable_class_prev;//phpcs:ignore?>'}).add().toFront(); armChart.renderer.button('', (armChart.chartWidth - 30), 70, function(){arm_change_graph_next('<?php echo $type; //phpcs:ignore?>','<?php echo $arm_enable_next;?>', 'coupon_report')}, normalState, hoverState, pressedState).attr({id:'arm_next_button',class:'<?php echo $arm_disable_class_next; //phpcs:ignore?>'}).add().toFront(); <?php } ?> jQuery('.highcharts-container').find('#arm_prev_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_prev_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M1.221,8.318l8.002,8.002l2.001-2L5.221,8.316l6.003-6.003 l-2.001-2L1.221,8.315l0.001,0.001L1.221,8.318z"/></svg>'); jQuery('.highcharts-container').find('#arm_next_button').find('text').remove(); jQuery('.highcharts-container').find('#arm_next_button').append('<svg version="1.1" xmlns="http://www.w3.org/2000/svg" x="12" y="10"><path xmlns="http://www.w3.org/2000/svg" fill-rule="evenodd" clip-rule="evenodd" fill="#4786ff" d="M11.431,8.601l-8.002,8.002l-2.001-2l6.003-6.003L1.428,2.596 l2.001-2l8.002,8.002L11.43,8.599L11.431,8.601z"/></svg>'); }); </script> <?php if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){?> <?php if($type == 'daily'){?> <div class="armchart_display_title arm_ml_5"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <?php }?> <?php if($type == 'monthly'){?> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title arm_ml_5"> <?php $month_year_lbl = !empty($filter_year) ? $filter_year : $new_month_year; ?> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($month_year_lbl); ?></label> </div> <?php }?> <?php if($type == 'yearly'){?> <div class="armchart_display_title arm_ml_5"> <label class="armcharttitle"><?php echo esc_html($new_year); ?></label> </div> <?php }?> <div class="armchart_plan_section"> <?php if(isset($arm_charts_plan_data) && count($arm_charts_plan_data)>0){ foreach ($arm_charts_plan_data as $arm_charts_plan_key => $arm_charts_plan_row) { ?> <div class="armchart_plan_item"> <label class="armchart_plan_title"><?php echo esc_attr($arm_charts_plan_row['coupon_label']); ?></label> <p class="armchart_plan_item_desc"><?php echo esc_html__("Coupon Code Used:", "ARMember");?> <?php echo count($arm_charts_plan_row['coupon_users']);?><span class="arm_chart_total_amount"><?php echo esc_html__("Total Amount:", "ARMember");?> <?php echo number_format($arm_charts_plan_row['total_amount'], $arm_currency_decimal);?></p> </div> <?php } }else { echo '<div class="armchart_plan_no_item">'. esc_html__("Recently No Membership Plan purchased using coupon", "ARMember").'</div>'; } ?> </div> <div class="armchart_view_section"> <div class="page_title"> <span><?php esc_html_e('Coupon history','ARMember');?></span> <div class="arm_chart_view_section arm_float_right"> <?php $selected_line_class = ($graph_type == 'line') ? 'selected' :''; $selected_bar_class = ($graph_type == 'bar') ? 'selected' :''; ?> <div class="armgraphtype armgraphtype_line armgraphtype_coupon_report <?php echo esc_attr($selected_line_class);?>" id="armgraphtype_coupon_report_div_line" onclick="arm_change_graph_type('line', 'coupon_report')"> <input type="radio" value="line" id="armgraphtype_coupon_report_line" name="armgraphtype_coupon_report" <?php echo checked( $graph_type, 'line');?>> </div> <div class="armgraphtype armgraphtype_bar armgraphtype_coupon_report arm_margin_right_0 <?php echo esc_attr($selected_bar_class);?>" id="armgraphtype_coupon_report_div_bar" onclick="arm_change_graph_type('bar', 'coupon_report')"> <input type="radio" id="armgraphtype_coupon_report_bar" value="bar" name="armgraphtype_coupon_report" <?php echo checked( $graph_type, 'bar');?>> </div> </div> </div> <?php }?> <div id="daily_coupon_report" class="arm_padding_20" style="<?php echo ($type == 'daily') ? 'display:block;' : 'display:none'; ?>"> <?php if(!isset($_REQUEST['action'])) { ?> <div class="armchart_display_title"> <label class="armcharttitle"> <?php echo date(get_option('date_format'), strtotime($new_day . '-' . $new_day_month . '-' . $new_day_year)); //phpcs:ignore?> </label> </div> <?php }?> <div id="chart1_coupon_report" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_html($new_day); ?>" name="current_day" id="current_day" /> <input type="hidden" value="<?php echo esc_html($new_day_month); ?>" name="current_day_month" id="current_day_month" /> <input type="hidden" value="<?php echo esc_html($new_day_year); ?>" name="current_day_year" id="current_day_year" /> </div> <div id="monthly_coupon_report" class="arm_padding_20" style="<?php echo ($type == 'monthly') ? 'display:block;' : 'display:none'; ?>"> <?php if(!isset($_REQUEST['action'])){?> <?php $monthName = date("F", mktime(0, 0, 0, (int)$new_month, 10)); ?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_html($monthName) . "-" . esc_html($new_month_year); ?></label> </div> <?php }?> <div id="chart2_coupon_report" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_month); ?>" name="current_month" id="current_month" /> <input type="hidden" value="<?php echo esc_attr($new_month_year); ?>" name="current_month_year" id="current_month_year" /> </div> <div id="yearly_coupon_report" class="arm_padding_20" style="<?php echo ($type == 'yearly') ? 'display:block;' : 'display:none'; ?>"> <div class="arlinks link_align"></div> <?php if(!isset($_REQUEST['action'])){?> <div class="armchart_display_title"> <label class="armcharttitle"><?php echo esc_html($new_year); ?></label> </div> <?php }?> <div id="chart3_coupon_report" class="arm_width_100_pct" style="<?php echo ($graph_type == 'countries') ? 'height:400px;' : 'height:300px;';?>" ></div> <input type="hidden" value="<?php echo esc_attr($new_year); ?>" name="current_year" id="current_year" /> </div> <?php if(isset($_REQUEST['action']) && $_REQUEST['action']=="armupdatecharts"){?> </div> <?php }?> <?php }

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