网站技术 2024-01-23 151

wordpress获取当前文章页所属分类下所有用户的购买记录

最近模板兔在给某个客户开发一个功能：访问文章页时，随机推荐当前分类下文章资源的购买记录，把这个购买记录弹出来，做一个延时弹出提醒，有助于提高转化。

主要获取代码如下：

$bought_barrage_ids = $wpdb->get_results("SELECT ice_post FROM $wpdb->icealipay where ice_post in (select tr.object_id from ".$wpdb->prefix."term_relationships tr join ".$wpdb->prefix."term_taxonomy t ON tr.term_taxonomy_id = t.term_taxonomy_id WHERE t.term_id = ".$category[0]->term_id.") and ice_success=1 and ice_time>DATE_SUB(CURDATE(), INTERVAL 7 DAY) order by rand() limit 1,3");

$bought_barrage_ids = $wpdb->get_results("SELECT ice_post FROM $wpdb->icealipay where ice_post in (select tr.object_id from ".$wpdb->prefix."term_relationships tr join ".$wpdb->prefix."term_taxonomy t ON tr.term_taxonomy_id = t.term_taxonomy_id WHERE t.term_id = ".$category[0]->term_id.") and ice_success=1 and ice_time>DATE_SUB(CURDATE(), INTERVAL 7 DAY) order by rand() limit 1,3");