id; $args = apply_filters('wcmp_report_admin_vendor_tab_query_args', array( 'post_type' => 'shop_order', 'posts_per_page' => -1, 'author' => $vendor_id, 'post_status' => array('wc-processing', 'wc-completed'), 'meta_query' => array( array( 'key' => '_commissions_processed', 'value' => 'yes', 'compare' => '=' ), array( 'key' => '_vendor_id', 'value' => $vendor_id, 'compare' => '=' ) ), 'date_query' => array( 'inclusive' => true, 'after' => array( 'year' => date('Y', $start_date), 'month' => date('n', $start_date), 'day' => date('j', $start_date), ), 'before' => array( 'year' => date('Y', $end_date), 'month' => date('n', $end_date), 'day' => date('j', $end_date), ), ) ) ); $qry = new WP_Query($args); $orders = apply_filters('wcmp_filter_orders_report_vendor', $qry->get_posts()); if ( !empty( $orders ) ) { foreach ( $orders as $order_obj ) { try { $order = wc_get_order($order_obj->ID); $rate = scd_wcmp_get_order_rate($order_obj->post_parent);//ok if ($order) : $vendor_order = wcmp_get_order($order->get_id()); $gross_sales += $order->get_total( 'edit' )*$rate; $vendor_earning += $vendor_order->get_commission_total('edit')*$rate; endif; } catch (Exception $ex) { } } } $total_sales[$vendor_id]['total_sales'] = $gross_sales; $total_sales[$vendor_id]['vendor_earning'] = $vendor_earning; $total_sales[$vendor_id]['admin_earning'] = $gross_sales - $vendor_earning; $total_sales[$vendor_id]['vendor_id'] = $vendor_id; // for report filter } } wp_send_json_success($total_sales); } wp_send_json_error(); } add_filter('wp_ajax_vendor_search', 'scd_wcmp_search_vendor_data'); /** * WCMp Vendor Data Searching */ function scd_wcmp_search_vendor_data() { global $WCMp, $wpdb; $chosen_product_ids = $vendor_id = $vendor = false; $gross_sales = $my_earning = $vendor_earning = 0; $vendor_term_id = isset($_POST['vendor_id']) ? absint($_POST['vendor_id']) : 0; $vendor = get_wcmp_vendor_by_term($vendor_term_id); $vendor_id = $vendor->id; $start_date = isset($_POST['start_date']) ? wc_clean($_POST['start_date']) : ''; $end_date = isset($_POST['end_date']) ? wc_clean($_POST['end_date']) : ''; if ($vendor_id) { if ($vendor) $products = $vendor->get_products_ids(); if (!empty($products)) { foreach ($products as $product) { $chosen_product_ids[] = $product->ID; } } } $args = apply_filters('wcmp_report_admin_vendor_tab_query_args', array( 'post_type' => 'shop_order', 'posts_per_page' => -1, 'author' => $vendor_id, 'post_status' => array('wc-processing', 'wc-completed'), 'meta_query' => array( array( 'key' => '_commissions_processed', 'value' => 'yes', 'compare' => '=' ), array( 'key' => '_vendor_id', 'value' => $vendor_id, 'compare' => '=' ) ), 'date_query' => array( 'inclusive' => true, 'after' => array( 'year' => date('Y', $start_date), 'month' => date('n', $start_date), 'day' => date('j', $start_date), ), 'before' => array( 'year' => date('Y', $end_date), 'month' => date('n', $end_date), 'day' => date('j', $end_date), ), ) ) ); $qry = new WP_Query($args); $orders = apply_filters('wcmp_filter_orders_report_vendor', $qry->get_posts()); if ( ($vendor_id && empty($products) ) || empty($orders)) { $no_vendor = '

' . __("Sales and Earnings", 'dc-woocommerce-multi-vendor') . '

' . __("Month", 'dc-woocommerce-multi-vendor') . '	' . __("Sales", 'dc-woocommerce-multi-vendor') . '
' . __("No Sales :(", 'dc-woocommerce-multi-vendor') . '

'; echo $no_vendor; die; } if (!empty($orders)) { $total_sales = $admin_earning = array(); $max_total_sales = 0; foreach ($orders as $order_obj) { try { $order = wc_get_order($order_obj->ID); $rate = scd_wcmp_get_order_rate($order_obj->post_parent); if ($order) : $vendor_order = wcmp_get_order($order->get_id()); $gross_sales += $order->get_total( 'edit' )*$rate; $vendor_earning += $vendor_order->get_commission_total('edit')*$rate; // Get date $date = date('Ym', strtotime($order->get_date_created())); // Set values $total_sales[$date]['total_sales'] = $gross_sales; $total_sales[$date]['vendor_earning'] = $vendor_earning; $total_sales[$date]['admin_earning'] = $gross_sales - $vendor_earning; endif; } catch (Exception $ex) { } } $report_chart = $report_html = ''; if (count($total_sales) > 0) { foreach ($total_sales as $date => $sales) { $total_sales_width = ( $sales > 0 ) ? ( round($sales['total_sales']) / round( $sales['total_sales'] ) ) * 100 : 0; $admin_earning_width = ( $sales['admin_earning'] > 0 ) ? ( $sales['admin_earning'] / round($sales['total_sales']) ) * 100 : 0; $vendor_earning_width = ( $sales['vendor_earning'] > 0 ) ? ( $sales['vendor_earning'] / round($sales['total_sales']) ) * 100 : 0; $orders_link = admin_url('edit.php?s&post_status=all&post_type=shop_order&action=-1&m=' . date('Ym', strtotime($date . '01')) . '&shop_order_status=' . implode(",", apply_filters('woocommerce_reports_order_statuses', array('completed', 'processing', 'on-hold')))); $orders_link = apply_filters('woocommerce_reports_order_link', $orders_link, $chosen_product_ids ); $report_chart .= '' . date_i18n('F', strtotime($date . '01')) . ' ' . wc_price($sales['total_sales']) . '' . '' . wc_price($sales['admin_earning']) . '' . '' . wc_price($sales['vendor_earning']) . ' '; } $report_html = '

' . $vendor->page_title . '

' . __('Gross Sales', 'dc-woocommerce-multi-vendor') . '

' . __('Admin Earnings', 'dc-woocommerce-multi-vendor') . '

' . __('Vendor Earnings', 'dc-woocommerce-multi-vendor') . '

' . $report_chart . '

' . __("Month", 'dc-woocommerce-multi-vendor') . '	' . __("Vendor Earnings", 'dc-woocommerce-multi-vendor') . '

'; } else { $report_html = '' . __('This vendor did not generate any sales in the given period.', 'dc-woocommerce-multi-vendor') . ''; } } echo $report_html; die; }