/** * @param Product $product */ private function saveSpecials($product) { if ($product->isSpecialsModified()) { $this->getDb()->query("DELETE FROM product_special WHERE product_id = '" . (int) $product->getId() . "'"); foreach ($product->getSpecials() as $product_special) { $this->getDb()->query("INSERT INTO product_special SET product_id = '" . (int) $product->getId() . "', customer_group_id = '" . (int) $product_special['customer_group_id'] . "', priority = '" . (int) $product_special['priority'] . "', price = '" . (double) $product_special['price'] . "', date_start = '" . $this->getDb()->escape($product_special['date_start']) . "', date_end = '" . $this->getDb()->escape($product_special['date_end']) . "'"); } } }