<?php

namespace UkrSolution\WpLabelsPrinting4\LabelDataMakers\Shortcodes\Woocommerce;

class ProductBatchTrackingNumber extends ProductCustomField
{
    const ORDER = 1970;

    public $display_name = 'Batch tracking 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}webis_pbet AS BN WHERE BN.post_id = %d;",
            $postId
        ));

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

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