public static function storeRelatedItemsById($relatedString, $productId)
{
if ((int) $productId > 0) {
$db = Factory::getDBO();
$query = ' DELETE ' . ' FROM #__phocacart_product_related' . ' WHERE product_a = ' . (int) $productId;
$db->setQuery($query);
$db->execute();
if (isset($relatedString) && $relatedString != '') {
$relatedArray = explode(",", $relatedString);
$values = array();
$valuesString = '';
foreach ($relatedArray as $k => $v) {
$values[] = ' (' . (int) $productId . ', ' . (int) $v . ')';
}
if (!empty($values)) {
$valuesString = implode(',', $values);
$query = ' INSERT INTO #__phocacart_product_related (product_a, product_b)' . ' VALUES ' . (string) $valuesString;
$db->setQuery($query);
$db->execute();
}
}
}
}