商城后台与订单排查

$key['shop_product'] = array(
    'score'          => 0,
    'sales_volume'   => 0,
    'views'          => 0,
    'favorite_count' => 0,
);

'/wp-admin/edit-comments.php?p=' . $id . '&comment_status=approved';

function zib_shop_get_discount_config($discount_id, $key = null, $default = '')
{
    return zib_shop_get_term_config('shop_discount', $discount_id, $key, $default);
}

zib_shop_get_discount_meta_options();

function zib_shop_add_meta_box_product_discount()
{
    add_meta_box('shop_product_discount', __('优惠活动', 'zib_language'), 'zib_shop_meta_box_product_discount', array('shop_product'), 'side', 'high');
}
add_action('add_meta_boxes', 'zib_shop_add_meta_box_product_discount');

if (!empty($_POST['meta_box_save_product_discount'])) {
    $discount_ids = !empty($_POST['meta_box_product_discount']) ? array_map('intval', (array) $_POST['meta_box_product_discount']) : array();
    wp_set_post_terms($post_id, $discount_ids, 'shop_discount', false);
}

if (!empty($_GET['post_type']) && $_GET['post_type'] === 'shop_product') {
    add_action('bulk_edit_custom_box', 'zib_shop_bulk_edit_custom_box_product', 50, 2);
    add_action('quick_edit_custom_box', 'zib_shop_bulk_edit_custom_box_product', 50, 2);
}
add_action('save_post', 'zib_shop_bulk_edit_save_post_product', 10, 3);

wp_set_post_terms($post_ID, $discount_ids, 'shop_discount', false);

add_filter('comment_text', array($this, 'manage_comments_comment_text'), 8, 3);

function zibpay_ajax_order_query($args = array())
{
    $query_args = array_merge(array(
        'orderby'  => $orderby,
        'order'    => $order,
        'paged'    => $paged,
        'per_page' => $pagesize,
    ), $args);

    $db_data = zibpay::order_query($query_args);
}

$data_1 = $db_1->field('sum(count) as count,sum(order_price) as order_price')->where('pay_type', '!=', 'points')->find()->toArray();
$data_2 = $db_2->field('sum(count) as count,sum(order_price) as order_price')->where('pay_type', '=', 'points')->find()->toArray();

$data_3 = $db_3->field('sum(income_price) as income_price,sum(rebate_price) as rebate_price')->where(array(array('status', '=', 1)))->find()->toArray();
$data_4 = $db_4->field('sum(income_price) as income_price')->where(array(array('status', '=', 1), array('income_status', '!=', 1)))->find()->toArray();
$data_5 = $db_5->field('sum(rebate_price) as rebate_price')->where(array(array('status', '=', 1), array('rebate_status', '!=', 1)))->find()->toArray();

if ($order['pay_type'] === 'points') {
    if (!(int) $order['order_price'] && !empty($order['pay_detail']['points'])) {
        $order['order_price'] = $order['pay_detail']['points'];
    }

    if ($order['status'] == 1 && !empty($order['pay_detail']['points'])) {
        if (!(int) $order['pay_price']) {
            $order['pay_price'] = $order['pay_detail']['points'];
        }

        if (!empty($order['income_detail']['points']) && !(int) $order['income_status']) {
            $order['income_status'] = 1;
        }
    }
}

$meta_order_data['prices'] = array(
    'pay_price'   => $order['order_price'],
    'total_price' => $order['order_price'],
    'unit_price'  => $order['order_price'],
);

'user_order_count_' . $user_id . '_' . $status

add_action('save_order_meta', 'zib_shop_user_order_count_cache_delete', 10, 2);

<el-form v-if="[-1,0].includes(~~payment_dialog_data.status)" class="order-edit-form">
    <el-select v-model="payment_dialog_data.payment_method"></el-select>
    <el-input v-model="payment_dialog_data.pay_price"></el-input>
    <el-input v-model="payment_dialog_data.pay_num"></el-input>
</el-form>

function zibpay_ajax_admin_payment_submit()
{
    zib_ajax_verify_nonce('admin_order_page_ajax_submit');

    if (!current_user_can('administrator')) {
        zib_send_json_error(__('权限不足', 'zib_language'));
    }
}

$pay_data = array(
    'order_num' => $order_num,
    'pay_type'  => $payment_method,
    'pay_price' => $pay_price,
    'pay_num'   => $pay_num,
);

$order = ZibPay::payment_order($pay_data);

$pay_detail = array(
    $payment_method  => $pay_price,
    'payment_method' => $payment_method,
);
$wpdb->update($wpdb->zibpay_order, array('pay_detail' => $pay_detail), array('id' => $order->id));

function zibpay_get_order_pay_over_time(array &$order)
{
    if ($order['status'] != 0) {
        return false;
    }

    $max_time  = zibpay_get_order_pay_max_time();
    $last_time = strtotime('+' . $max_time * 60 . ' Second', strtotime($order['create_time']));
    if (strtotime(current_time('Y-m-d H:i:s')) > $last_time) {
        $order['status'] = -1;
        zibpay::close_order($order['id'], 'timeout', __('超时自动关闭', 'zib_language'));
        return 'over';
    }

    return $last_time;
}

function zibpay_get_order_pay_max_time()
{
    $max_time = (int) _pz('order_pay_max_minutes', 30) ?: 30;
    $max_time = $max_time < 5 ? 5 : $max_time;

    return $max_time;
}

public static function close_order($order_id, $type = 'timeout', $reason = '')
{
    $get_order = self::get_order($order_id, 'payment_id');
    if (!empty($get_order['payment_id'])) {
        return self::close_payment($get_order['payment_id'], $type, $reason);
    }

    return self::close_order_single($order_id, $type, $reason);
}

public static function clear_order($days_ago = 15)
{
    $ago_time = date('Y-m-d H:i:s', strtotime("-$days_ago day", strtotime(current_time('Y-m-d H:i:s'))));
    $where    = "`status` = -1 and `create_time` < '$ago_time'";
    $wpdb->query("DELETE FROM $wpdb->zibpay_payment WHERE $where");

    $order_ids = $wpdb->get_col("SELECT id FROM $wpdb->zibpay_order WHERE $where");
    if (!empty($order_ids)) {
        $wpdb->query("DELETE FROM $wpdb->zibpay_order WHERE id IN ($order_ids)");
        $wpdb->query("DELETE FROM $wpdb->zibpay_order_meta WHERE order_id IN ($order_ids)");
    }
}

function zib_pay_auto_clear_order()
{
    ZibPay::clear_order(14);
}

add_action('zib_auto_clear_order', 'zib_pay_auto_clear_order');

$mini_card_data = array(
    'rebate_all'      => zibpay_get_rebate_statistics_totime('all'),
    'rebate_pending'  => zibpay_get_rebate_statistics_totime('0'),
    'income_all'      => zibpay_get_income_statistics_totime('all'),
    'income_pending'  => zibpay_get_income_statistics_totime('0'),
);

function zib_docs_shop_order_health_check($order_id)
{
    $order_id = (int) $order_id;
    if (!$order_id) {
        return new WP_Error('order_id_empty', __('订单ID不能为空', 'zib_language'));
    }

    $order = zibpay::get_order($order_id);
    if (!$order || $order['order_type'] != zib_shop_get_order_type()) {
        return new WP_Error('order_invalid', __('订单不存在或不是商城订单', 'zib_language'));
    }

    $order_data = zibpay::get_meta($order_id, 'order_data');
    $result     = array(
        'order_id'          => $order_id,
        'status'            => $order['status'],
        'shipping_status'   => zib_shop_get_order_shipping_status($order_id),
        'comment_status'    => zib_shop_get_order_comment_status($order_id),
        'after_sale_status' => zib_shop_get_order_after_sale_status($order_id),
        'refund_price'      => zibpay::get_meta($order_id, 'refund_price'),
        'receive_time'      => $order_data['shipping_data']['receive_time'] ?? '',
        'after_sale_type'   => $order_data['after_sale_data']['type'] ?? '',
    );

    $result['tips'] = array();
    if ($result['shipping_status'] == 2 && $result['comment_status'] === 0 && empty($result['receive_time'])) {
        $result['tips'][] = __('订单已收货但缺少收货时间，评价时效可能无法计算', 'zib_language');
    }
    if ($result['after_sale_status'] && empty($order_data['after_sale_data'])) {
        $result['tips'][] = __('售后状态存在但缺少售后数据', 'zib_language');
    }

    return $result;
}