add_filter( 'woocomerce_lottery_history', 'woocomerce_lottery_history_sort_by_ticket_number', 15 , 4 );
function woocomerce_lottery_history_sort_by_ticket_number( $history, $product_id, $user_id, $relisteddate ){
global $wpdb;
$wheredatefrom = '';
$datefrom = FALSE;
$relisteddate = get_post_meta( $product_id, '_lottery_relisted', true );
if(!is_admin() && !empty($relisteddate)){
$datefrom = $relisteddate;
}
if($datefrom){
$wheredatefrom =" AND CAST(date AS DATETIME) > '$datefrom' ";
}
if($user_id){
$wheredatefrom =" AND wc_lottery_log.userid = $user_id";
}
$history = $wpdb->get_results( 'SELECT * FROM '.$wpdb->prefix.'wc_lottery_log LEFT JOIN '.$wpdb->prefix.'wc_lottery_pn_log on '.$wpdb->prefix.'wc_lottery_log.id = '.$wpdb->prefix.'wc_lottery_pn_log.log_id WHERE '.$wpdb->prefix.'wc_lottery_log.lottery_id =' . $product_id . $wheredatefrom.' ORDER BY `ticket_number` ASC');
return $history;
}
Comments
0 B
|👍
/👎
0 B
|👍
/👎