public static function getDoubleShippingSKUArray($campaignArray, $campaignID)
{
self::$DoubleShippingSKUArray = array();
if (!$campaignArray) {
return array();
}
$db = SafeMySQL::getInstance();
$sql = "SELECT cp.`campaign_id`\n FROM `products` as p\n JOIN `campaigns_products` as cp ON p.`product_id` = cp.`product_id`\n WHERE cp.`campaign_id` IN (?a)\n AND p.`product_shipping_sku` != ''";
$result = $db->getAll($sql, $campaignArray);
$resultArray = array();
foreach ($result as $item) {
$resultArray[] = $item['campaign_id'];
}
self::$DoubleShippingSKUArray = in_array($campaignID, $resultArray) ? $resultArray : array();
}
