<?php

namespace UkrSolution\WpLabelsPrinting4\LabelDataMakers\Shortcodes\Woocommerce;

class ProductBatchNumbers extends ProductCustomField
{
    const ORDER = 1970;

    public $display_name = 'Batch numbers';

    public function getValue($post, $field)
    {
        global $wpdb;

        $postId = is_a($post, \WP_Post::class) ? $post->ID : (int)$post;
        $batchNumbers = $wpdb->get_results($wpdb->prepare(
            "SELECT * FROM {$wpdb->prefix}wpo_wcpbn_batch_numbers AS BN, {$wpdb->prefix}wpo_wcpbn_shared_products AS SP 
            WHERE BN.id = SP.batch_id AND SP.product_id = %d;",
            $postId
        ));

        return !empty($batchNumbers) && is_array($batchNumbers)
            ? implode(', ', wp_list_pluck($batchNumbers, 'batch_number'))
            : "";
    }

    public function isEnabled()
    {
        return !function_exists('is_plugin_active')
            ? in_array('woocommerce-product-batch-numbers/woocommerce-product-batch-numbers.php', (array)get_option('active_plugins', array()))
            : is_plugin_active('woocommerce-product-batch-numbers/woocommerce-product-batch-numbers.php');
    }
}