CodeExplorer
You are a developer and looking for Shopware projects?
Apply Now!
addSql example
SQL;
$this->addSql($sql);
if ($modus === self::MODUS_INSTALL) {
$sql = <<<'SQL' SET @elementId = (SELECT id FROM s_core_config_elements WHERE name = 'mainFeatures'); UPDATE s_core_config_elements SET value = :value WHERE id = @elementId; SQL;
$stmt = $this->getConnection()->prepare($sql);
$value = serialize('{if $sBasketItem.purchaseunit && $sBasketItem.purchaseunit != 0} <span class="price--label label--purchase-unit is--bold is--nowrap"> Inhalt: </span> <span class="is--nowrap"> {$sBasketItem.purchaseunit|floatval} {$sBasketItem.additional_details.sUnit.description} </span> {/if} {if $sBasketItem.purchaseunit && $sBasketItem.additional_details.referenceunit && $sBasketItem.purchaseunit != $sBasketItem.additional_details.referenceunit} <span class="is--nowrap"> ({$sBasketItem.additional_details.referenceprice|currency} * / {$sBasketItem.additional_details.referenceunit} {$sBasketItem.additional_details.sUnit.description}) </span> {/if}');
$this->addSql($sql);
if ($modus === self::MODUS_INSTALL) {
$sql = <<<'SQL' SET @elementId = (SELECT id FROM s_core_config_elements WHERE name = 'mainFeatures'); UPDATE s_core_config_elements SET value = :value WHERE id = @elementId; SQL;
$stmt = $this->getConnection()->prepare($sql);
$value = serialize('{if $sBasketItem.purchaseunit && $sBasketItem.purchaseunit != 0} <span class="price--label label--purchase-unit is--bold is--nowrap"> Inhalt: </span> <span class="is--nowrap"> {$sBasketItem.purchaseunit|floatval} {$sBasketItem.additional_details.sUnit.description} </span> {/if} {if $sBasketItem.purchaseunit && $sBasketItem.additional_details.referenceunit && $sBasketItem.purchaseunit != $sBasketItem.additional_details.referenceunit} <span class="is--nowrap"> ({$sBasketItem.additional_details.referenceprice|currency} * / {$sBasketItem.additional_details.referenceunit} {$sBasketItem.additional_details.sUnit.description}) </span> {/if}');
SQL;
$sql .= <<<'EOD' UPDATE `s_core_config_mails` SET `context` = 'a:5:{s:11:"sNotifyData";a:5:{s:2:"id";s:1:"1";s:11:"ordernumber";s:7:"SW10239";s:4:"mail";s:12:"test@test.de";s:8:"language";s:1:"1";s:9:"attribute";a:2:{s:2:"id";s:1:"1";s:14:"notificationID";s:1:"1";}}s:12:"sArticleLink";s:91:"http://shopware.dev.localhost/genusswelten/koestlichkeiten/272/spachtelmasse?number=SW10239";s:12:"sOrdernumber";s:7:"SW10239";s:5:"sData";N;s:7:"product";a:94:{s:9:"articleID";i:272;s:16:"articleDetailsID";i:827;s:11:"ordernumber";s:7:"SW10239";s:9:"highlight";b:0;s:11:"description";s:0:"";s:16:"description_long";s:406:"<p>qui dux somniculosus lascivio vel res compendiose Oriens propitius, alo ita pax galactinus emo. Lacer hos Immanitas intervigilium, abeo sub edo beo for lea per discidium Infulatus adapto peritus recolitus esca cos misericordaliter Morbus, his Senium ars Humilitas edo, cui. Sis sacrilegus Fatigo almus vae excedo, aut vegetabiliter Erogo villa periclitatus, for in per no sors capulus se Quies, mox.</p>";s:3:"esd";b:0;s:11:"articleName";s:13:"Spachtelmasse";s:5:"taxID";i:4;s:3:"tax";i:7;s:7:"instock";i:5555;s:11:"isAvailable";b:1;s:19:"hasAvailableVariant";b:1;s:6:"weight";i:0;s:12:"shippingtime";N;s:16:"pricegroupActive";b:0;s:12:"pricegroupID";N;s:6:"length";i:0;s:6:"height";i:0;s:5:"width";i:0;s:9:"laststock";b:0;s:14:"additionaltext";s:0:"";s:5:"datum";s:10:"2012-08-31";s:6:"update";s:10:"2018-11-06";s:5:"sales";i:0;s:13:"filtergroupID";N;s:17:"priceStartingFrom";N;s:18:"pseudopricePercent";N;s:15:"sVariantArticle";N;s:13:"sConfigurator";b:0;s:9:"metaTitle";s:0:"";s:12:"shippingfree";b:0;s:14:"suppliernumber";s:0:"";s:12:"notification";b:1;s:3:"ean";s:0:"";s:8:"keywords";s:0:"";s:12:"sReleasedate";s:0:"";s:8:"template";s:0:"";s:10:"attributes";a:2:{s:4:"core";a:23:{s:2:"id";s:3:"865";s:9:"articleID";s:3:"272";s:16:"articledetailsID";s:3:"827";s:5:"attr1";s:0:"";s:5:"attr2";s:0:"";s:5:"attr3";s:0:"";s:5:"attr4";s:0:"";s:5:"attr5";s:0:"";s:5:"attr6";s:0:"";s:5:"attr7";s:0:"";s:5:"attr8";s:0:"";s:5:"attr9";s:0:"";s:6:"attr10";s:0:"";s:6:"attr11";s:0:"";s:6:"attr12";s:0:"";s:6:"attr13";s:0:"";s:6:"attr14";s:0:"";s:6:"attr15";s:0:"";s:6:"attr16";s:0:"";s:6:"attr17";N;s:6:"attr18";s:0:"";s:6:"attr19";s:0:"";s:6:"attr20";s:0:"";}s:9:"marketing";a:4:{s:5:"isNew";b:0;s:11:"isTopSeller";b:0;s:10:"comingSoon";b:0;s:7:"storage";a:0:{}}}s:17:"allowBuyInListing";b:1;s:5:"attr1";s:0:"";s:5:"attr2";s:0:"";s:5:"attr3";s:0:"";s:5:"attr4";s:0:"";s:5:"attr5";s:0:"";s:5:"attr6";s:0:"";s:5:"attr7";s:0:"";s:5:"attr8";s:0:"";s:5:"attr9";s:0:"";s:6:"attr10";s:0:"";s:6:"attr11";s:0:"";s:6:"attr12";s:0:"";s:6:"attr13";s:0:"";s:6:"attr14";s:0:"";s:6:"attr15";s:0:"";s:6:"attr16";s:0:"";s:6:"attr17";N;s:6:"attr18";s:0:"";s:6:"attr19";s:0:"";s:6:"attr20";s:0:"";s:12:"supplierName";s:15:"The Deli Garage";s:11:"supplierImg";s:61:"http://shopware.localhost/media/image/70/ff/d6/deligarage.png";s:10:"supplierID";i:4;s:19:"supplierDescription";s:0:"";s:19:"supplier_attributes";a:0:{}s:10:"newArticle";b:0;s:9:"sUpcoming";b:0;s:9:"topseller";b:0;s:7:"valFrom";i:1;s:5:"valTo";N;s:4:"from";i:1;s:2:"to";N;s:5:"price";s:5:"17,08";s:11:"pseudoprice";s:1:"0";s:14:"referenceprice";s:1:"0";s:15:"has_pseudoprice";b:0;s:13:"price_numeric";d:17.08;s:19:"pseudoprice_numeric";i:0;s:16:"price_attributes";a:0:{}s:10:"pricegroup";s:2:"EK";s:11:"minpurchase";i:1;s:11:"maxpurchase";s:3:"100";s:13:"purchasesteps";i:1;s:12:"purchaseunit";N;s:13:"referenceunit";N;s:8:"packunit";s:0:"";s:6:"unitID";N;s:5:"sUnit";a:2:{s:4:"unit";N;s:11:"description";N;}s:15:"unit_attributes";a:0:{}s:5:"image";a:12:{s:2:"id";i:769;s:8:"position";N;s:6:"source";s:64:"http://shopware.localhost/media/image/91/ee/35/spachtelmasse.jpg";s:11:"description";s:0:"";s:9:"extension";s:3:"jpg";s:4:"main";b:1;s:8:"parentId";N;s:5:"width";i:380;s:6:"height";i:276;s:10:"thumbnails";a:3:{i:0;a:6:{s:6:"source";s:72:"http://shopware.localhost/media/image/0e/8e/f0/spachtelmasse_200x200.jpg";s:12:"retinaSource";s:75:"http://shopware.localhost/media/image/c5/fe/f6/spachtelmasse_200x200@2x.jpg";s:9:"sourceSet";s:152:"http://shopware.localhost/media/image/0e/8e/f0/spachtelmasse_200x200.jpg, http://shopware.localhost/media/image/c5/fe/f6/spachtelmasse_200x200@2x.jpg 2x";s:8:"maxWidth";s:3:"200";s:9:"maxHeight";s:3:"200";s:10:"attributes";a:0:{}}i:1;a:6:{s:6:"source";s:72:"http://shopware.localhost/media/image/96/0c/99/spachtelmasse_600x600.jpg";s:12:"retinaSource";s:75:"http://shopware.localhost/media/image/05/70/1e/spachtelmasse_600x600@2x.jpg";s:9:"sourceSet";s:152:"http://shopware.localhost/media/image/96/0c/99/spachtelmasse_600x600.jpg, http://shopware.localhost/media/image/05/70/1e/spachtelmasse_600x600@2x.jpg 2x";s:8:"maxWidth";s:3:"600";s:9:"maxHeight";s:3:"600";s:10:"attributes";a:0:{}}i:2;a:6:{s:6:"source";s:74:"http://shopware.localhost/media/image/28/g0/7e/spachtelmasse_1280x1280.jpg";s:12:"retinaSource";s:77:"http://shopware.localhost/media/image/6e/5f/c6/spachtelmasse_1280x1280@2x.jpg";s:9:"sourceSet";s:156:"http://shopware.localhost/media/image/28/g0/7e/spachtelmasse_1280x1280.jpg, http://shopware.localhost/media/image/6e/5f/c6/spachtelmasse_1280x1280@2x.jpg 2x";s:8:"maxWidth";s:4:"1280";s:9:"maxHeight";s:4:"1280";s:10:"attributes";a:0:{}}}s:10:"attributes";a:0:{}s:9:"attribute";a:0:{}}s:6:"prices";a:1:{i:0;a:22:{s:7:"valFrom";i:1;s:5:"valTo";N;s:4:"from";i:1;s:2:"to";N;s:5:"price";s:5:"17,08";s:11:"pseudoprice";s:1:"0";s:14:"referenceprice";s:1:"0";s:18:"pseudopricePercent";N;s:15:"has_pseudoprice";b:0;s:13:"price_numeric";d:17.08;s:19:"pseudoprice_numeric";i:0;s:16:"price_attributes";a:0:{}s:10:"pricegroup";s:2:"EK";s:11:"minpurchase";i:1;s:11:"maxpurchase";s:3:"100";s:13:"purchasesteps";i:1;s:12:"purchaseunit";N;s:13:"referenceunit";N;s:8:"packunit";s:0:"";s:6:"unitID";N;s:5:"sUnit";a:2:{s:4:"unit";N;s:11:"description";N;}s:15:"unit_attributes";a:0:{}}}s:10:"linkBasket";s:42:"shopware.php?sViewport=basket&sAdd=SW10239";s:11:"linkDetails";s:42:"shopware.php?sViewport=detail&sArticle=272";s:11:"linkVariant";s:57:"shopware.php?sViewport=detail&sArticle=272&number=SW10239";}}' WHERE `s_core_config_mails`.`name` = 'sARTICLEAVAILABLE'; EOD;
$this->addSql($sql);
}
}
$sql .= <<<'EOD' UPDATE `s_core_config_mails` SET `context` = 'a:5:{s:11:"sNotifyData";a:5:{s:2:"id";s:1:"1";s:11:"ordernumber";s:7:"SW10239";s:4:"mail";s:12:"test@test.de";s:8:"language";s:1:"1";s:9:"attribute";a:2:{s:2:"id";s:1:"1";s:14:"notificationID";s:1:"1";}}s:12:"sArticleLink";s:91:"http://shopware.dev.localhost/genusswelten/koestlichkeiten/272/spachtelmasse?number=SW10239";s:12:"sOrdernumber";s:7:"SW10239";s:5:"sData";N;s:7:"product";a:94:{s:9:"articleID";i:272;s:16:"articleDetailsID";i:827;s:11:"ordernumber";s:7:"SW10239";s:9:"highlight";b:0;s:11:"description";s:0:"";s:16:"description_long";s:406:"<p>qui dux somniculosus lascivio vel res compendiose Oriens propitius, alo ita pax galactinus emo. Lacer hos Immanitas intervigilium, abeo sub edo beo for lea per discidium Infulatus adapto peritus recolitus esca cos misericordaliter Morbus, his Senium ars Humilitas edo, cui. Sis sacrilegus Fatigo almus vae excedo, aut vegetabiliter Erogo villa periclitatus, for in per no sors capulus se Quies, mox.</p>";s:3:"esd";b:0;s:11:"articleName";s:13:"Spachtelmasse";s:5:"taxID";i:4;s:3:"tax";i:7;s:7:"instock";i:5555;s:11:"isAvailable";b:1;s:19:"hasAvailableVariant";b:1;s:6:"weight";i:0;s:12:"shippingtime";N;s:16:"pricegroupActive";b:0;s:12:"pricegroupID";N;s:6:"length";i:0;s:6:"height";i:0;s:5:"width";i:0;s:9:"laststock";b:0;s:14:"additionaltext";s:0:"";s:5:"datum";s:10:"2012-08-31";s:6:"update";s:10:"2018-11-06";s:5:"sales";i:0;s:13:"filtergroupID";N;s:17:"priceStartingFrom";N;s:18:"pseudopricePercent";N;s:15:"sVariantArticle";N;s:13:"sConfigurator";b:0;s:9:"metaTitle";s:0:"";s:12:"shippingfree";b:0;s:14:"suppliernumber";s:0:"";s:12:"notification";b:1;s:3:"ean";s:0:"";s:8:"keywords";s:0:"";s:12:"sReleasedate";s:0:"";s:8:"template";s:0:"";s:10:"attributes";a:2:{s:4:"core";a:23:{s:2:"id";s:3:"865";s:9:"articleID";s:3:"272";s:16:"articledetailsID";s:3:"827";s:5:"attr1";s:0:"";s:5:"attr2";s:0:"";s:5:"attr3";s:0:"";s:5:"attr4";s:0:"";s:5:"attr5";s:0:"";s:5:"attr6";s:0:"";s:5:"attr7";s:0:"";s:5:"attr8";s:0:"";s:5:"attr9";s:0:"";s:6:"attr10";s:0:"";s:6:"attr11";s:0:"";s:6:"attr12";s:0:"";s:6:"attr13";s:0:"";s:6:"attr14";s:0:"";s:6:"attr15";s:0:"";s:6:"attr16";s:0:"";s:6:"attr17";N;s:6:"attr18";s:0:"";s:6:"attr19";s:0:"";s:6:"attr20";s:0:"";}s:9:"marketing";a:4:{s:5:"isNew";b:0;s:11:"isTopSeller";b:0;s:10:"comingSoon";b:0;s:7:"storage";a:0:{}}}s:17:"allowBuyInListing";b:1;s:5:"attr1";s:0:"";s:5:"attr2";s:0:"";s:5:"attr3";s:0:"";s:5:"attr4";s:0:"";s:5:"attr5";s:0:"";s:5:"attr6";s:0:"";s:5:"attr7";s:0:"";s:5:"attr8";s:0:"";s:5:"attr9";s:0:"";s:6:"attr10";s:0:"";s:6:"attr11";s:0:"";s:6:"attr12";s:0:"";s:6:"attr13";s:0:"";s:6:"attr14";s:0:"";s:6:"attr15";s:0:"";s:6:"attr16";s:0:"";s:6:"attr17";N;s:6:"attr18";s:0:"";s:6:"attr19";s:0:"";s:6:"attr20";s:0:"";s:12:"supplierName";s:15:"The Deli Garage";s:11:"supplierImg";s:61:"http://shopware.localhost/media/image/70/ff/d6/deligarage.png";s:10:"supplierID";i:4;s:19:"supplierDescription";s:0:"";s:19:"supplier_attributes";a:0:{}s:10:"newArticle";b:0;s:9:"sUpcoming";b:0;s:9:"topseller";b:0;s:7:"valFrom";i:1;s:5:"valTo";N;s:4:"from";i:1;s:2:"to";N;s:5:"price";s:5:"17,08";s:11:"pseudoprice";s:1:"0";s:14:"referenceprice";s:1:"0";s:15:"has_pseudoprice";b:0;s:13:"price_numeric";d:17.08;s:19:"pseudoprice_numeric";i:0;s:16:"price_attributes";a:0:{}s:10:"pricegroup";s:2:"EK";s:11:"minpurchase";i:1;s:11:"maxpurchase";s:3:"100";s:13:"purchasesteps";i:1;s:12:"purchaseunit";N;s:13:"referenceunit";N;s:8:"packunit";s:0:"";s:6:"unitID";N;s:5:"sUnit";a:2:{s:4:"unit";N;s:11:"description";N;}s:15:"unit_attributes";a:0:{}s:5:"image";a:12:{s:2:"id";i:769;s:8:"position";N;s:6:"source";s:64:"http://shopware.localhost/media/image/91/ee/35/spachtelmasse.jpg";s:11:"description";s:0:"";s:9:"extension";s:3:"jpg";s:4:"main";b:1;s:8:"parentId";N;s:5:"width";i:380;s:6:"height";i:276;s:10:"thumbnails";a:3:{i:0;a:6:{s:6:"source";s:72:"http://shopware.localhost/media/image/0e/8e/f0/spachtelmasse_200x200.jpg";s:12:"retinaSource";s:75:"http://shopware.localhost/media/image/c5/fe/f6/spachtelmasse_200x200@2x.jpg";s:9:"sourceSet";s:152:"http://shopware.localhost/media/image/0e/8e/f0/spachtelmasse_200x200.jpg, http://shopware.localhost/media/image/c5/fe/f6/spachtelmasse_200x200@2x.jpg 2x";s:8:"maxWidth";s:3:"200";s:9:"maxHeight";s:3:"200";s:10:"attributes";a:0:{}}i:1;a:6:{s:6:"source";s:72:"http://shopware.localhost/media/image/96/0c/99/spachtelmasse_600x600.jpg";s:12:"retinaSource";s:75:"http://shopware.localhost/media/image/05/70/1e/spachtelmasse_600x600@2x.jpg";s:9:"sourceSet";s:152:"http://shopware.localhost/media/image/96/0c/99/spachtelmasse_600x600.jpg, http://shopware.localhost/media/image/05/70/1e/spachtelmasse_600x600@2x.jpg 2x";s:8:"maxWidth";s:3:"600";s:9:"maxHeight";s:3:"600";s:10:"attributes";a:0:{}}i:2;a:6:{s:6:"source";s:74:"http://shopware.localhost/media/image/28/g0/7e/spachtelmasse_1280x1280.jpg";s:12:"retinaSource";s:77:"http://shopware.localhost/media/image/6e/5f/c6/spachtelmasse_1280x1280@2x.jpg";s:9:"sourceSet";s:156:"http://shopware.localhost/media/image/28/g0/7e/spachtelmasse_1280x1280.jpg, http://shopware.localhost/media/image/6e/5f/c6/spachtelmasse_1280x1280@2x.jpg 2x";s:8:"maxWidth";s:4:"1280";s:9:"maxHeight";s:4:"1280";s:10:"attributes";a:0:{}}}s:10:"attributes";a:0:{}s:9:"attribute";a:0:{}}s:6:"prices";a:1:{i:0;a:22:{s:7:"valFrom";i:1;s:5:"valTo";N;s:4:"from";i:1;s:2:"to";N;s:5:"price";s:5:"17,08";s:11:"pseudoprice";s:1:"0";s:14:"referenceprice";s:1:"0";s:18:"pseudopricePercent";N;s:15:"has_pseudoprice";b:0;s:13:"price_numeric";d:17.08;s:19:"pseudoprice_numeric";i:0;s:16:"price_attributes";a:0:{}s:10:"pricegroup";s:2:"EK";s:11:"minpurchase";i:1;s:11:"maxpurchase";s:3:"100";s:13:"purchasesteps";i:1;s:12:"purchaseunit";N;s:13:"referenceunit";N;s:8:"packunit";s:0:"";s:6:"unitID";N;s:5:"sUnit";a:2:{s:4:"unit";N;s:11:"description";N;}s:15:"unit_attributes";a:0:{}}}s:10:"linkBasket";s:42:"shopware.php?sViewport=basket&sAdd=SW10239";s:11:"linkDetails";s:42:"shopware.php?sViewport=detail&sArticle=272";s:11:"linkVariant";s:57:"shopware.php?sViewport=detail&sArticle=272&number=SW10239";}}' WHERE `s_core_config_mails`.`name` = 'sARTICLEAVAILABLE'; EOD;
$this->addSql($sql);
}
}
if (!\in_array('less_compatible', $result)) {
$this->addLessCompatibleFlag();
}
}
private function addLessCompatibleFlag()
{
$sql = <<<SQL ALTER TABLE `s_core_templates_config_elements` ADD `less_compatible` INT(1) NOT NULL DEFAULT '1' ; SQL;
$this->addSql($sql);
}
}
$this->addLessCompatibleFlag();
}
}
private function addLessCompatibleFlag()
{
$sql = <<<SQL ALTER TABLE `s_core_templates_config_elements` ADD `less_compatible` INT(1) NOT NULL DEFAULT '1' ; SQL;
$this->addSql($sql);
}
}
$sql = <<<'SQL'
SET @parent = (SELECT id FROM s_core_config_forms WHERE name = 'Frontend33' LIMIT 1);
SET @elementId = (SELECT id FROM `s_core_config_elements` WHERE `name` = 'showCompanySelectField' and form_id=@parent LIMIT 1);
UPDATE s_core_config_elements set type='select', options='%s', value='i:0;' where id=@elementId;
UPDATE s_core_config_values SET value = 'i:1;' WHERE element_id = @elementId AND value = 'b:0;';
UPDATE s_core_config_values SET value = 'i:0;' WHERE element_id = @elementId AND value = 'b:1;';
UPDATE `s_core_config_elements` SET `description` = 'Das Auswahlfeld wird nur bei der Registrierung ausgeblendet, danach ist es beim Ändern der Benutzerdaten trotzdem verfügbar.' WHERE `id` = @element;
UPDATE `s_core_config_element_translations` SET `description` = 'This option only affects the registration, it is still available when editing user data.' WHERE `element_id` = @element;
SQL;
$this->addSql(sprintf($sql, serialize($options)));
}
}
$this->addSql(sprintf($sql, serialize($options)));
}
}
class Migrations_Migration388 extends Shopware\Components\Migrations\AbstractMigration
{
public function up($modus)
{
$this->addSql('ALTER TABLE s_library_component_field ADD position INT NULL;');
$this->addSql('UPDATE s_library_component_field SET position = id;');
$this->addSql("SET @parent = (SELECT id FROM `s_library_component` WHERE `x_type`='emotion-components-article-slider' AND template = 'component_article_slider' AND pluginID IS NULL LIMIT 1);");
$this->addSql("SET @maxNumberPosition = (SELECT id FROM `s_library_component_field` WHERE `name`='article_slider_max_number' AND componentID = @parent LIMIT 1);");
$this->addSql('UPDATE s_library_component_field SET position = position+1 WHERE componentID = @parent AND id >= @maxNumberPosition;');
}
}
/*
* Column case change does not flush cache and we still get in the constraint upper case column name
* We need to rename it to a another name and then back
* @ticket: https://jira.mariadb.org/browse/MDEV-13671
*/
if ($modus === self::MODUS_INSTALL) {
return;
}
// When this system comes form the 5.5 Beta / RC if (!$this->isIdUpperCase() && !$this->isMySql8()) {
$this->addSql(
'ALTER TABLE `s_order_documents_attributes` DROP FOREIGN KEY `s_order_documents_attributes_ibfk_1`;'
);
$this->addSql(
'ALTER TABLE `s_order_documents` CHANGE COLUMN `id` `id_tmp` INT(11) NOT NULL AUTO_INCREMENT FIRST;'
);
}
}
private function isMySql8()
{
$result = false;
if ($modus === self::MODUS_INSTALL) {
return;
}
// When this system comes form the 5.5 Beta / RC if (!$this->isIdUpperCase() && !$this->isMySql8()) {
$this->addSql(
'ALTER TABLE `s_order_documents_attributes` DROP FOREIGN KEY `s_order_documents_attributes_ibfk_1`;'
);
$this->addSql(
'ALTER TABLE `s_order_documents` CHANGE COLUMN `id` `id_tmp` INT(11) NOT NULL AUTO_INCREMENT FIRST;'
);
}
}
private function isMySql8()
{
$result = false;
public function up($modus)
{
$sql = <<<SQL UPDATE `s_core_config_mails` SET `context` = 'a:15:{s:5:\"sMAIL\";s:14:\"xy@example.org\";s:7:\"sConfig\";a:0:{}s:6:\"street\";s:15:\"Musterstraße 1\";' 's:7:\"zipcode\";s:5:\"12345\";s:4:\"city\";s:11:\"Musterstadt\";s:7:\"country\";s:1:\"2\";s:5:\"state\";N;s:13:\"customer_type\";' 's:7:\"private\";s:10:\"salutation\";s:4:\"Herr\";s:5:\"title\";s:3:\"Dr.\";s:9:\"firstname\";s:3:\"Max\";s:8:\"lastname\";' 's:10:\"Mustermann\";s:11:\"accountmode\";s:1:\"0\";s:5:\"email\";s:14:\"xy@example.org\";s:10:\"additional\";a:1:{s:13:\"customer_type\";s:7:\"private\";}}' WHERE `name` = 'sREGISTERCONFIRMATION' SQL;
$this->addSql($sql);
}
}
"SET @localePrefix = (
SELECT MID(`locale`, 1, 2) AS localePrefix
FROM `s_core_locales`
WHERE `id` = (
SELECT locale_id
FROM `s_core_shops`
WHERE `default` = '1'
LIMIT 1
)
LIMIT 1
);";
$this->addSql($sql);
// Update mail template, if english update and not dirty $sql = <<<'EOD' UPDATE `s_core_config_mails` SET `subject` = 'Please confirm your registration at {config name=shopName}', `content` = '{include file="string:{config name=emailheaderplain}"} Hello, thank you for signing up at {$sShop}. Please confirm your registration by clicking the following link: {$sConfirmLink} With this confirmation you also agree that we may send you further e-mails within the scope of the fulfilment of the contract. {include file="string:{config name=emailfooterplain}"}', `contentHTML` = '<div style="font-family:arial; font-size:12px;"> {include file="string:{config name=emailheaderhtml}"} <br/><br/> <p> Hello,<br/> <br/> thank you for signing up at {$sShop}.<br/> Please confirm your registration by clicking the following link:<br/> <br/> <a href="{$sConfirmLink}">Confirm registration</a><br/> <br/> With this confirmation you also agree that we may send you further e-mails within the scope of the fulfilment of the contract. </p> {include file="string:{config name=emailfooterhtml}"} </div>' WHERE `name` = 'sOPTINREGISTER' AND `dirty` = '0' AND @localePrefix = 'en'
$this->addSql($sql);
// Update mail template, if english update and not dirty $sql = <<<'EOD' UPDATE `s_core_config_mails` SET `subject` = 'Please confirm your registration at {config name=shopName}', `content` = '{include file="string:{config name=emailheaderplain}"} Hello, thank you for signing up at {$sShop}. Please confirm your registration by clicking the following link: {$sConfirmLink} With this confirmation you also agree that we may send you further e-mails within the scope of the fulfilment of the contract. {include file="string:{config name=emailfooterplain}"}', `contentHTML` = '<div style="font-family:arial; font-size:12px;"> {include file="string:{config name=emailheaderhtml}"} <br/><br/> <p> Hello,<br/> <br/> thank you for signing up at {$sShop}.<br/> Please confirm your registration by clicking the following link:<br/> <br/> <a href="{$sConfirmLink}">Confirm registration</a><br/> <br/> With this confirmation you also agree that we may send you further e-mails within the scope of the fulfilment of the contract. </p> {include file="string:{config name=emailfooterhtml}"} </div>' WHERE `name` = 'sOPTINREGISTER' AND `dirty` = '0' AND @localePrefix = 'en'
$this->addProductBoxLayoutColumn();
$this->addSearchProductBoxLayoutSwitch();
}
private function addProductBoxLayoutColumn()
{
$sql = <<<EOT ALTER TABLE s_categories ADD product_box_layout varchar(50) NULL DEFAULT NULL EOT;
$this->addSql($sql);
}
private function addSearchProductBoxLayoutSwitch()
{
$sql = <<<'EOD' INSERT IGNORE INTO `s_core_config_elements` (`form_id`, `name`, `value`, `label`, `description`, `type`, `required`, `position`, `scope`, `filters`, `validators`, `options`) VALUES (190, 'searchProductBoxLayout', 's:5:"basic"', 'Produkt Layout', 'Mit Hilfe des Produkt Layouts können Sie entscheiden, wie Ihre Produkte auf der Suchergebnis-Seite dargestellt werden sollen. Wählen Sie eines der drei unterschiedlichen Layouts um die Ansicht perfekt auf Ihr Produktsortiment abzustimmen.', 'product-box-layout-select', 0, 0, 1, NULL, NULL, NULL); SET @elementId = (SELECT `id` FROM `s_core_config_elements` WHERE `form_id`= 190 AND `name`="searchProductBoxLayout" LIMIT 1); INSERT IGNORE INTO `s_core_config_element_translations` (`label`, `description`, `locale_id`, `element_id`) VALUES ('Product layout', 'Product layout allows you to control how your products are presented on the search result page. Choose between three different layouts to fine-tune your product display.', 2, @elementId);
private function updateEmailFooterPlain()
{
$sql = <<<'EOD' UPDATE `s_core_config_elements` SET `value` = 's:63:" Mit freundlichen Grüßen Ihr Team von {config name=shopName}";' WHERE `name` = 'emailfooterplain' AND `value` = 's:64:" Mit freundlichen Grüßen, Ihr Team von {config name=shopName}";' AND `label` = 'E-Mail Footer Plaintext' AND ISNULL(`description`) AND `type` = 'textarea' AND `required` = 0 AND `position` = 0 AND `scope` = 1 AND ISNULL(`options`); EOD;
$this->addSql($sql);
}
private function updateEmailFooterHtml()
{
$sql = <<<'EOD' UPDATE `s_core_config_elements` SET `value` = 's:84:"<br/> Mit freundlichen Grüßen<br/><br/> Ihr Team von {config name=shopName}</div>";' WHERE `name` = 'emailfooterhtml' AND `value` = 's:85:"<br/> Mit freundlichen Grüßen,<br/><br/> Ihr Team von {config name=shopName}</div>";' AND `label` = 'E-Mail Footer HTML' AND ISNULL(`description`) AND `type` = 'textarea' AND `required` = 0 AND `position` = 0 AND `scope` = 1 AND ISNULL(`options`);
{
$sql = <<<'EOD' UPDATE `s_core_config_elements` SET `value` = 's:63:" Mit freundlichen Grüßen Ihr Team von {config name=shopName}";' WHERE `name` = 'emailfooterplain' AND `value` = 's:64:" Mit freundlichen Grüßen, Ihr Team von {config name=shopName}";' AND `label` = 'E-Mail Footer Plaintext' AND ISNULL(`description`) AND `type` = 'textarea' AND `required` = 0 AND `position` = 0 AND `scope` = 1 AND ISNULL(`options`); EOD;
$this->addSql($sql);
}
private function updateEmailFooterHtml()
{
$sql = <<<'EOD' UPDATE `s_core_config_elements` SET `value` = 's:84:"<br/> Mit freundlichen Grüßen<br/><br/> Ihr Team von {config name=shopName}</div>";' WHERE `name` = 'emailfooterhtml' AND `value` = 's:85:"<br/> Mit freundlichen Grüßen,<br/><br/> Ihr Team von {config name=shopName}</div>";' AND `label` = 'E-Mail Footer HTML' AND ISNULL(`description`) AND `type` = 'textarea' AND `required` = 0 AND `position` = 0 AND `scope` = 1 AND ISNULL(`options`);
class Migrations_Migration780 extends Shopware\Components\Migrations\AbstractMigration
{
public function up($modus)
{
$this->addSql("UPDATE `s_core_paymentmeans` SET `table` = '' WHERE `name` = 'debit' AND `table` = 's_user_debit';");
}
}
$this->addVideoElementFields();
}
/** * @return string */
protected function addFullscreenField()
{
$sql = <<<'EOD' ALTER TABLE `s_emotion` ADD `fullscreen` INT NOT NULL DEFAULT '0' ; EOD;
$this->addSql($sql);
return $sql;
}
/** * @return string */
protected function addModeField()
{
$sql = <<<'EOD' ALTER TABLE `s_emotion` ADD `mode` VARCHAR(255) NOT NULL DEFAULT 'masonry';
}
/** * @return string */
protected function addFullscreenField()
{
$sql = <<<'EOD' ALTER TABLE `s_emotion` ADD `fullscreen` INT NOT NULL DEFAULT '0' ; EOD;
$this->addSql($sql);
return $sql;
}
/** * @return string */
protected function addModeField()
{
$sql = <<<'EOD' ALTER TABLE `s_emotion` ADD `mode` VARCHAR(255) NOT NULL DEFAULT 'masonry';
EOD;
$this->addSql($sql);
}
}
$this->addSql($sql);
}
}
/**
* Update all mail templates
*/
private function updateTemplate()
{
$content = '{include file=\"string:{config name=emailheaderhtml}\"}\r\n<br/><br/>\r\n<p>\nHallo {$billingaddress.firstname} {$billingaddress.lastname},<br/><br/>\n\nvielen Dank fuer Ihre Bestellung bei {config name=shopName} (Nummer: {$sOrderNumber}) am {$sOrderDay|date:\"DATE_MEDIUM\"} um {$sOrderTime|date:\"TIME_SHORT\"}.\n<br/>\n<br/>\n<strong>Informationen zu Ihrer Bestellung:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Artikel</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Menge</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Preis</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Summe</strong></td>\n </tr>\n\n {foreach item=details key=position from=$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if $details.image.src.0}<img style=\"height: 57px;\" height=\"57\" src=\"{$details.image.src.0}\" alt=\"{$details.articlename}\" />{else} {/if}</td>\n <td>{$position+1|fill:4} </td>\n <td>{$details.ordernumber|fill:20}</td>\n <td>{$details.quantity|fill:6}</td>\n <td>{$details.price|padding:8}{$sCurrency}</td>\n <td>{$details.amount|padding:8} {$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Versandkosten: {$sShippingCosts}<br/>\n Gesamtkosten Netto: {$sAmountNet}<br/>\n {if !$sNet}\n Gesamtkosten Brutto: {$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Gewählte Zahlungsart:</strong> {$additional.payment.description}<br/>\n {include file=\"string:{$additional.payment.additionaldescription}\"}\n {if $additional.payment.name == \"debit\"}\n Ihre Bankverbindung:<br/>\n Kontonr: {$sPaymentTable.account}<br/>\n BLZ:{$sPaymentTable.bankcode}<br/>\n Wir ziehen den Betrag in den nächsten Tagen von Ihrem Konto ein.<br/>\n {/if}\n <br/>\n <br/>\n {if $additional.payment.name == \"prepayment\"}\n Unsere Bankverbindung:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Gewählte Versandart:</strong> {$sDispatch.name}<br/>{$sDispatch.description}\n</p>\n<p>\n {if $sComment}\n <strong>Ihr Kommentar:</strong><br/>\n {$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Rechnungsadresse:</strong><br/>\n {$billingaddress.company}<br/>\n {$billingaddress.firstname} {$billingaddress.lastname}<br/>\n {$billingaddress.street}<br/>\n {$billingaddress.zipcode} {$billingaddress.city}<br/>\n {$billingaddress.phone}<br/>\n {$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Lieferadresse:</strong><br/>\n {$shippingaddress.company}<br/>\n {$shippingaddress.firstname} {$shippingaddress.lastname}<br/>\n {$shippingaddress.street}<br/>\n {$shippingaddress.zipcode} {$shippingaddress.city}<br/>\n {$additional.countryShipping.countryname}<br/>\n <br/>\n {if $billingaddress.ustid}\n Ihre Umsatzsteuer-ID: {$billingaddress.ustid}<br/>\n Bei erfolgreicher Prüfung und sofern Sie aus dem EU-Ausland<br/>\n bestellen, erhalten Sie Ihre Ware umsatzsteuerbefreit.<br/>\n {/if}\n <br/>\n <br/>\n Für Rückfragen stehen wir Ihnen jederzeit gerne zur Verfügung. Sie erreichen uns wie folgt: <br/>{config name=address}\n</p>\r\n<br/><br/>\r\n{include file=\"string:{config name=emailfooterhtml}\"}';
$sql = <<<SQL UPDATE `s_core_config_mails` SET `contentHTML` = "$content" WHERE `name` = "sORDER" AND dirty = 0 SQL;
$this->addSql($sql);
}
}
private function updateTemplate()
{
$content = '{include file=\"string:{config name=emailheaderhtml}\"}\r\n<br/><br/>\r\n<p>\nHallo {$billingaddress.firstname} {$billingaddress.lastname},<br/><br/>\n\nvielen Dank fuer Ihre Bestellung bei {config name=shopName} (Nummer: {$sOrderNumber}) am {$sOrderDay|date:\"DATE_MEDIUM\"} um {$sOrderTime|date:\"TIME_SHORT\"}.\n<br/>\n<br/>\n<strong>Informationen zu Ihrer Bestellung:</strong></p>\n <table width=\"80%\" border=\"0\" style=\"font-family:Arial, Helvetica, sans-serif; font-size:10px;\">\n <tr>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Artikel</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Pos.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Art-Nr.</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Menge</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Preis</strong></td>\n <td bgcolor=\"#F7F7F2\" style=\"border-bottom:1px solid #cccccc;\"><strong>Summe</strong></td>\n </tr>\n\n {foreach item=details key=position from=$sOrderDetails}\n <tr>\n <td rowspan=\"2\" style=\"border-bottom:1px solid #cccccc;\">{if $details.image.src.0}<img style=\"height: 57px;\" height=\"57\" src=\"{$details.image.src.0}\" alt=\"{$details.articlename}\" />{else} {/if}</td>\n <td>{$position+1|fill:4} </td>\n <td>{$details.ordernumber|fill:20}</td>\n <td>{$details.quantity|fill:6}</td>\n <td>{$details.price|padding:8}{$sCurrency}</td>\n <td>{$details.amount|padding:8} {$sCurrency}</td>\n </tr>\n <tr>\n <td colspan=\"5\" style=\"border-bottom:1px solid #cccccc;\">{$details.articlename|wordwrap:80|indent:4}</td>\n </tr>\n {/foreach}\n\n </table>\n\n<p>\n <br/>\n <br/>\n Versandkosten: {$sShippingCosts}<br/>\n Gesamtkosten Netto: {$sAmountNet}<br/>\n {if !$sNet}\n Gesamtkosten Brutto: {$sAmount}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Gewählte Zahlungsart:</strong> {$additional.payment.description}<br/>\n {include file=\"string:{$additional.payment.additionaldescription}\"}\n {if $additional.payment.name == \"debit\"}\n Ihre Bankverbindung:<br/>\n Kontonr: {$sPaymentTable.account}<br/>\n BLZ:{$sPaymentTable.bankcode}<br/>\n Wir ziehen den Betrag in den nächsten Tagen von Ihrem Konto ein.<br/>\n {/if}\n <br/>\n <br/>\n {if $additional.payment.name == \"prepayment\"}\n Unsere Bankverbindung:<br/>\n {config name=bankAccount}\n {/if}\n <br/>\n <br/>\n <strong>Gewählte Versandart:</strong> {$sDispatch.name}<br/>{$sDispatch.description}\n</p>\n<p>\n {if $sComment}\n <strong>Ihr Kommentar:</strong><br/>\n {$sComment}<br/>\n {/if}\n <br/>\n <br/>\n <strong>Rechnungsadresse:</strong><br/>\n {$billingaddress.company}<br/>\n {$billingaddress.firstname} {$billingaddress.lastname}<br/>\n {$billingaddress.street}<br/>\n {$billingaddress.zipcode} {$billingaddress.city}<br/>\n {$billingaddress.phone}<br/>\n {$additional.country.countryname}<br/>\n <br/>\n <br/>\n <strong>Lieferadresse:</strong><br/>\n {$shippingaddress.company}<br/>\n {$shippingaddress.firstname} {$shippingaddress.lastname}<br/>\n {$shippingaddress.street}<br/>\n {$shippingaddress.zipcode} {$shippingaddress.city}<br/>\n {$additional.countryShipping.countryname}<br/>\n <br/>\n {if $billingaddress.ustid}\n Ihre Umsatzsteuer-ID: {$billingaddress.ustid}<br/>\n Bei erfolgreicher Prüfung und sofern Sie aus dem EU-Ausland<br/>\n bestellen, erhalten Sie Ihre Ware umsatzsteuerbefreit.<br/>\n {/if}\n <br/>\n <br/>\n Für Rückfragen stehen wir Ihnen jederzeit gerne zur Verfügung. Sie erreichen uns wie folgt: <br/>{config name=address}\n</p>\r\n<br/><br/>\r\n{include file=\"string:{config name=emailfooterhtml}\"}';
$sql = <<<SQL UPDATE `s_core_config_mails` SET `contentHTML` = "$content" WHERE `name` = "sORDER" AND dirty = 0 SQL;
$this->addSql($sql);
}
}
class Migrations_Migration1604 extends Shopware\Components\Migrations\AbstractMigration
{
public function up($modus)
{
$sql = <<<'SQL' INSERT IGNORE INTO `s_core_config_elements` (`name`, `value`, `required`, `position`, `scope`, `options`) VALUES ('minifyHtml', 'b:1;', 1, 0, 0, ''); SQL;
$this->addSql($sql);
}
}