links_to_marketplaces.php 1.3 KB

12345678910111213141516171819202122232425262728
  1. <?php
  2. class ModelExtensionModuleLinksToMarketplaces extends Model {
  3. public function addColumnsToTable() {
  4. $has_url_ozon_column = $this->db->query("SHOW COLUMNS FROM " . DB_PREFIX . "product WHERE Field='url_ozon'")->num_rows > 0;
  5. if (!$has_url_ozon_column) {
  6. $this->db->query("ALTER TABLE " . DB_PREFIX . "product ADD COLUMN url_ozon VARCHAR(255) NULL");
  7. }
  8. $has_url_wildberries_column = $this->db->query("SHOW COLUMNS FROM " . DB_PREFIX . "product WHERE Field='url_wildberries'")->num_rows > 0;
  9. if (!$has_url_wildberries_column) {
  10. $this->db->query("ALTER TABLE " . DB_PREFIX . "product ADD COLUMN url_wildberries VARCHAR(255) NULL");
  11. }
  12. $has_url_yandex_market_column = $this->db->query("SHOW COLUMNS FROM " . DB_PREFIX . "product WHERE Field='url_yandex_market'")->num_rows > 0;
  13. if (!$has_url_yandex_market_column) {
  14. $this->db->query("ALTER TABLE " . DB_PREFIX . "product ADD COLUMN url_yandex_market VARCHAR(255) NULL");
  15. }
  16. $has_url_megamarket_column = $this->db->query("SHOW COLUMNS FROM " . DB_PREFIX . "product WHERE Field='url_megamarket'")->num_rows > 0;
  17. if (!$has_url_megamarket_column) {
  18. $this->db->query("ALTER TABLE " . DB_PREFIX . "product ADD COLUMN url_megamarket VARCHAR(255) NULL");
  19. }
  20. }
  21. }