mysql 在管理订单列表中显示按状态分组的客户订单计数

cotxawn7  于 2024-01-05  发布在  Mysql
关注(0)|答案(1)|浏览(148)

我使用的代码在WooCommerce管理订单列表中添加一列，显示来自特定订单状态的客户订单。
问题是，有时当我刷新订单页面时，会发生一些事情，它会给我10/15/30这样的缓慢请求：
x1c 0d1x的数据
我使用的代码是这样的。有人知道问题可能来自哪里吗？

  1. add_action('manage_shop_order_posts_custom_column', 'display_order_count_column');
  2. function display_order_count_column($column) {
  3.     global $post;
  5.     if ($column === 'order_count') {
  6.         $customer_phone = get_post_meta($post->ID, '_billing_phone', true);
  8.         // Премахване на разстоянията от телефонния номер
  9.         $customer_phone = str_replace(' ', '', $customer_phone);
  11.         if (!empty($customer_phone)) {
  12.             $order_count = count(get_posts(array(
  13.                 'post_type'      => 'shop_order',
  14.                 'post_status'    => array('wc-completed', 'wc-order-rdy'),
  15.                 'meta_key'       => '_billing_phone',
  16.                 'meta_value'     => $customer_phone,
  17.                 'posts_per_page' => -1,
  18.             )));
  20.             if ($order_count >= 2) {
  21.                 echo '<a href="' . admin_url("edit.php?s=" . $customer_phone . "&post_status=all&post_type=shop_order&action=-1&m=0&_customer_user&paged=1&action2=-1") . '" class="Button_all_status" title="Числото показва броя на успешно завършените поръчки, които клиента има.">' . $order_count . '</a>';
  22.             } else {
  23.                 echo '';
  24.             }
  25.         } else {
  26.             echo '';
  27.         }
  28.     }
  30.     if ($column === 'order_count') {
  31.         $customer_phone = get_post_meta($post->ID, '_billing_phone', true);
  33.         if (!empty($customer_phone)) {
  34.             $order_count = count(get_posts(array(
  35.                 'post_type'      => 'shop_order',
  36.                 'post_status'    => array('wc-on-hold', 'wc-processing', 'wc-order-rdy'),
  37.                 'meta_key'       => '_billing_phone',
  38.                 'meta_value'     => $customer_phone,
  39.                 'posts_per_page' => -1,
  40.             )));
  42.             if ($order_count >= 2) {
  43.                 echo '<a href="' . admin_url("edit.php?s=" . $customer_phone . "&post_status=all&post_type=shop_order&action=-1&m=0&_customer_user&paged=1&action2=-1") . '" class="Button_in_process" title="Числото показва броя на поръчките, които клиента има в обработка.">' . $order_count . '</a>';
  44.             } else {
  45.                 echo '';
  46.             }
  47.         } else {
  48.             echo '';
  49.         }
  50.     }
  52.     if ($column === 'order_count') {
  53.         $customer_phone = get_post_meta($post->ID, '_billing_phone', true);
  55.         if (!empty($customer_phone)) {
  56.             $completed_processing_count = count(get_posts(array(
  57.                 'post_type'      => 'shop_order',
  58.                 'post_status'    => array('wc-completed', 'wc-processing', 'wc-order-rdy'),
  59.                 'meta_key'       => '_billing_phone',
  60.                 'meta_value'     => $customer_phone,
  61.                 'posts_per_page' => -1,
  62.             )));
  64.             $cancelled_failed_count = count(get_posts(array(
  65.                 'post_type'      => 'shop_order',
  66.                 'post_status'    => 'wc-cancelleddonttake',
  67.                 'meta_key'       => '_billing_phone',
  68.                 'meta_value'     => $customer_phone,
  69.                 'posts_per_page' => -1,
  70.             )));
  73.             if ($cancelled_failed_count > $completed_processing_count) {
  74.                 echo '<a href="' . admin_url("edit.php?s=" . $customer_phone . "&post_status=all&post_type=shop_order&action=-1&m=0&_customer_user&paged=1&action2=-1") . '" class="Button_bad_client" title="Рисков клиент. Моля, проверете поръчките на клиента.Клиента има повече провалени от колкото изпълнени поръчки">' . $cancelled_failed_count . '</a>';
  75.             } else {
  76.                 echo '';
  77.             }
  78.         } else {
  79.             echo '';
  80.         }
  81.     }

字符串
我不知道会有什么问题。

mysql

1条答案

按热度按时间
7lrncoxx

7lrncoxx1#

你的代码是执行4重职位查询行时显示管理订单列表页面，所以它是正常的，你得到缓慢的请求...
相反，您可以使用一个独特的轻量级自定义SQL查询（按行），它将按订单状态为您提供给予客户订单计数组。
请尝试以下操作：

  1. // Utility function: get customer orders count grouped by order status (Lightweight SQL query)
  2. function get_customer_orders_count_grouped_by_status( $billing_phone ) {
  3.     global $wpdb; 
  4.     return $wpdb->get_results( $wpdb->prepare( "
  5.         SELECT p.post_status as status, COUNT(p.ID) as count 
  6.         FROM {$wpdb->prefix}posts p
  7.         LEFT JOIN {$wpdb->prefix}postmeta pm ON p.ID = pm.post_id 
  8.         WHERE p.post_type  = 'shop_order'
  9.         AND pm.meta_key = '_billing_phone'
  10.         AND pm.meta_value LIKE '%s'
  11.         GROUP BY p.post_status
  12.     ", $billing_phone ) );
  13. }
  15. add_action('manage_shop_order_posts_custom_column', 'display_customer_orders_count_column', 10 , 2);
  16. function display_customer_orders_count_column( $column, $order_id ) {
  17.     if ($column === 'order_count') {
  18.         global $the_order;
  20.         $billing_phone = $the_order->get_billing_phone();
  21.         if ( ! empty($billing_phone) ) {
  22.             $orders_count = get_customer_orders_count_grouped_by_status( $billing_phone );
  23.             $count_paid   = $count_in_process = $count_cancelled = 0; // Initialize variables
  25.             // Loop through customer orders count grouped by status
  26.             foreach ( $orders_count as $order_data ) {
  27.                 if( in_array($order_data->status, ['wc-completed', 'wc-order-rdy'])) {
  28.                     $count_paid += $order_data->count;
  29.                 }
  30.                 if( in_array($order_data->status, ['wc-on-hold', 'wc-processing', 'wc-order-rdy'])) {
  31.                     $count_in_process += $order_data->count;
  32.                 }
  33.                 if( $order_data->status == 'wc-cancelleddonttake' ) {
  34.                     $count_cancelled += $order_data->count;
  35.                 }
  36.             }
  38.             if ($count_paid >= 2) {
  39.                 echo '<a href="' . admin_url("edit.php?s=" . $billing_phone . "&post_status=all&post_type=shop_order&action=-1&m=0&_customer_user&paged=1&action2=-1") . '" class="Button_all_status" title="Числото показва броя на успешно завършените поръчки, които клиента има.">' . $count_paid . '</a>';
  40.             }
  42.             if ($count_in_process >= 2) {
  43.                 echo '<a href="' . admin_url("edit.php?s=" . $billing_phone . "&post_status=all&post_type=shop_order&action=-1&m=0&_customer_user&paged=1&action2=-1") . '" class="Button_in_process" title="Числото показва броя на поръчките, които клиента има в обработка.">' . $count_in_process . '</a>';
  44.             }
  46.             if ($count_cancelled > $count_in_process) {
  47.                 echo '<a href="' . admin_url("edit.php?s=" . $billing_phone . "&post_status=all&post_type=shop_order&action=-1&m=0&_customer_user&paged=1&action2=-1") . '" class="Button_bad_client" title="Рисков клиент. Моля, проверете поръчките на клиента.Клиента има повече провалени от колкото изпълнени поръчки">' . $count_cancelled . '</a>';
  48.             }
  49.         }
  50.     }
  51. }

字符串
代码放在你的子主题的functions.php文件中（或插件中）。测试和工作。
对于其他读者，这里是缺少的功能，添加一个“计数”列到管理员WooCommerce订单列表：

  1. add_filter( 'manage_edit-shop_order_columns', 'add_customer_orders_count_column' );
  2. function add_customer_orders_count_column( $columns ) {
  3.     $new_columns = array();
  5.     foreach ( $columns as $column_key => $column_label ) {
  6.         if ( 'order_total' === $column_key ) {
  7.             $new_columns['order_count'] = __('Count', 'woocommerce');
  8.         }
  10.         $new_columns[$column_key] = $column_label;
  11.     }
  12.     return $new_columns;
  13. }

型

展开查看全部
赞(0）分享  回复(0）举报  2024-01-05
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com