<?php
defined( 'ABSPATH' ) || exit;

class WVRD_Shortcode {

    public function __construct() {
        add_shortcode( 'vip_redeem', array( $this, 'render' ) );
    }

    public function render( $atts ) {
        $atts = shortcode_atts( array(
            'remark' => '',
            'ids'    => '',
            'title'  => '兑换码领取',
            'desc'   => '领取限量兑换码，错过等下一波',
        ), $atts );

        global $wpdb;
        $table = $wpdb->prefix . WVRD_TABLE;

        if ( $atts['ids'] ) {
            $ids   = array_map( 'intval', explode( ',', $atts['ids'] ) );
            $in    = implode( ',', $ids );
            $items = $wpdb->get_results( "SELECT id, code, status FROM {$table} WHERE id IN ({$in}) AND status != 2 ORDER BY id ASC" );
        } elseif ( $atts['remark'] ) {
            $remark = sanitize_text_field( $atts['remark'] );
            $items  = $wpdb->get_results( $wpdb->prepare(
                "SELECT id, code, status FROM {$table} WHERE remark = %s AND status != 2 ORDER BY id ASC",
                $remark
            ) );
        } else {
            return '';
        }

        if ( empty( $items ) ) return '';

        ob_start();
        include WVRD_PATH . 'templates/shortcode-redeem.php';
        return ob_get_clean();
    }
}