Jump to content
  • разработка интернет магазинов на opencart
  • доработка интернет магазинов на opencart

Кастомное поле в товаре


Fritkkov4ik1
 Share

Recommended Posts

Здравствуйте всем , вообещём созданы 3 кастомных поля для карточки товара https://prnt.sc/106yo1g

Первые 2 рилииют нормально. 

Поле "Серия" не в какую не хочет записывать данные , но к примеру если в бд добавить значение для товара как на скрине выше , и удалить его уже из админки то связь поля с бд рилииет ( на удноние)

могдель 

$this->db->query("DELETE FROM " . DB_PREFIX . "product_apps_2 WHERE product_id = '" . (int)$product_id . "'");
		$this->db->query("DELETE FROM " . DB_PREFIX . "product_apps_2 WHERE related_id = '" . (int)$product_id . "'");

		if (isset($data['product_apps_2'])) {
			foreach ($data['product_apps_2'] as $related_id) {
				$this->db->query("DELETE FROM " . DB_PREFIX . "product_apps_2 WHERE product_id = '" . (int)$product_id . "' AND related_id = '" . (int)$related_id . "'");
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_apps_2 SET product_id = '" . (int)$product_id . "', related_id = '" . (int)$related_id . "'");
				//$this->db->query("DELETE FROM " . DB_PREFIX . "product_apps_2 WHERE product_id = '" . (int)$related_id . "' AND related_id = '" . (int)$product_id . "'");
				//$this->db->query("INSERT INTO " . DB_PREFIX . "product_apps_2 SET product_id = '" . (int)$related_id . "', related_id = '" . (int)$product_id . "'");
			}
		}

		$this->db->query("DELETE FROM " . DB_PREFIX . "product_apps_3 WHERE product_id = '" . (int)$product_id . "'");
		$this->db->query("DELETE FROM " . DB_PREFIX . "product_apps_3 WHERE related_id = '" . (int)$product_id . "'");

		if (isset($data['product_apps_3'])) {
			foreach ($data['product_apps_3'] as $related_id) {
				$this->db->query("DELETE FROM " . DB_PREFIX . "product_apps_3 WHERE product_id = '" . (int)$product_id . "' AND related_id = '" . (int)$related_id . "'");
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_apps_3 SET product_id = '" . (int)$product_id . "', related_id = '" . (int)$related_id . "'");
				//$this->db->query("DELETE FROM " . DB_PREFIX . "product_apps_3 WHERE product_id = '" . (int)$related_id . "' AND related_id = '" . (int)$product_id . "'");
				//$this->db->query("INSERT INTO " . DB_PREFIX . "product_apps_3 SET product_id = '" . (int)$related_id . "', related_id = '" . (int)$product_id . "'");
			}
		}

полная аналогия с apps_2 , ггде ошибка не пойму. 

Link to comment
Share on other sites


Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share


×
×
  • Create New...

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.