vindi/vindi-woocommerce

<?php
 
namespace VindiPaymentGateways;
 
class PostMeta
{
    /**
     * Check if exists a duplicate $meta on database
     * @param int $post_id
     * @param string $meta
     * @return int $post_id
     */
    public function check_vindi_item_id($post_id, $meta)
    {
        global $wpdb;
        $vindi_id = get_post_meta($post_id, $meta, true);
 
        if (!$vindi_id) {
            return 0;
        }
        
        $sql = "SELECT 
                  post_id as id 
                FROM {$wpdb->prefix}postmeta
                WHERE 
                  meta_key LIKE '$meta' AND
                  meta_value LIKE $vindi_id
                ";
 
        $result = $wpdb->get_results($sql);
 
        if (is_array($result) && !empty($result)) {
            return count($result);
        }
 
        return 0;
    }
}