custom/plugins/UltraStoreSwitcher/src/UltraStoreSwitcher.php line 16

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace Ultra\Store\Switcher;
  5. use Shopware\Core\Framework\Plugin;
  6. use Doctrine\DBAL\Connection;
  7. use Shopware\Core\Framework\Plugin\Context\InstallContext;   
  8. use Shopware\Core\Framework\Plugin\Context\ActivateContext;  
  9. use Shopware\Core\Framework\Plugin\Context\DeactivateContext; 
  10. use Shopware\Core\Framework\Plugin\Context\UpdateContext;
  11. use Shopware\Core\Framework\Plugin\Context\UninstallContext;  
  12. use Shopware\Core\System\SystemConfig\SystemConfigService;
  13. use Shopware\Core\System\CustomField\CustomFieldTypes;
  14. use Shopware\Core\Framework\Uuid\Uuid;
  16. class UltraStoreSwitcher extends Plugin
  17. {
  18.     public function install(InstallContext $context): void
  19.     {
  20.         if (!file_exists('../public/bundles/administration/static/css/ultra-config-styler.css')) {        
  21.         copy('../custom/plugins/UltraStoreSwitcher/src/Resources/datas/ultra-config-styler.css', '../public/bundles/administration/static/css/ultra-config-styler.css');
  22.         }    
  23.         
  24.         if (!file_exists('../public/bundles/administration/static/js/ultra-config-styler.js')) {        
  25.         copy('../custom/plugins/UltraStoreSwitcher/src/Resources/datas/ultra-config-styler.js', '../public/bundles/administration/static/js/ultra-config-styler.js');
  26.         }
  27.         
  28.         
  29.         
  30.     $connection = $this->container->get(Connection::class);
  31.        
  32.        $securing="";
  33.        $firsturl="";
  34.        $opt="";
  35.        
  36.        $resulter = $connection->fetchAll('
  37.         SELECT 
  38.     sct.name, lo.code, scd.url, sc.access_key
  39. FROM
  40.     sales_channel  sc
  41. INNER JOIN
  42.     sales_channel_translation sct 
  43.     ON sct.sales_channel_id = sc.id
  44. INNER JOIN    
  45.     sales_channel_domain scd
  46.     ON sc.id = scd.sales_channel_id
  47. INNER JOIN
  48.     language la 
  49.     ON la.id = sc.language_id
  50. INNER JOIN
  51.     locale lo 
  52.     ON lo.id = la.locale_id
  53. where sct.name != "Headless"
  54. group by sc.access_key
  55. order by sct.name ASC');
  56.              
  57.        $myarray="";
  58.        
  59.        $topper='<?xml version="1.0" encoding="UTF-8"?>
  60. <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  61.     xsi:noNamespaceSchemaLocation="https://raw.githubusercontent.com/shopware/platform/master/src/Core/System/SystemConfig/Schema/config.xsd">
  63.     <!-- Card 1. Verkaufskanal Aktivierung -->
  64.     <card>
  65.         <title>Card 1</title>
  66.         <title lang="de-DE">Card 1</title>
  67.         
  68.         <input-field type="text">
  69.             <name>eingabefeld1</name>
  70.             <class>ultra-info-start-button</class>
  71.             <placeholder>1. Activate in this saleschannel</placeholder>
  72.             <placeholder lang="de-DE">1. Aktivierung in diesem Verkaufskanal</placeholder>                 
  73.             <disabled>true</disabled>
  74.         </input-field>
  76.         <!-- Feld 1.1 Verkaufskanal Aktivierung -->
  77.         <input-field type="bool">
  78.             <name>activeKanal</name>
  79.             <label>Sales channel Active</label>
  80.             <label lang="de-DE">Verkaufskanal Aktiv</label>
  81.              <helpText>If selected, plugin will be shown in this shop or subshop.</helpText>
  82.             <helpText lang="de-DE">Wenn gewählt, wird das Plugin in diesem Verkaufskanal angezeigt.</helpText>          
  83.         </input-field>
  84.     </card>
  85.     
  86.     ';
  87.        
  88.        $optionstop = '
  89.        <!-- Card 2. Verkaufskanal Auswahl -->
  90.     <card>
  91.         <title>Card 2</title>
  92.         <title lang="de-DE">Card 2</title>
  93.         
  94.         <input-field type="text">
  95.             <name>eingabefeld2</name>
  96.             <class>ultra-info-start-button</class>
  97.             <placeholder>2. Turn on flag(s)</placeholder>
  98.             <placeholder lang="de-DE">2. Flagge(n) einschalten</placeholder>                 
  99.             <disabled>true</disabled>
  100.         </input-field>
  101.         
  102.         <input-field type="bool">
  103.             <name>flagonoff</name>
  104.             <label>Turn on flag(s)</label>
  105.             <label lang="de-DE">Flagge(n) einschalten</label>
  106.         </input-field>
  107.     </card>
  108. ';
  109.        
  110.        $optionsbottom = '
  112. </config>';
  113.        
  114.        $i=0;
  115.        $file = fopen("../custom/plugins/UltraStoreSwitcher/src/Resources/config/config.xml", "w");
  116.        
  117.        foreach ($resulter as $value) {
  118.         $i=$i+1;
  119.         $opt = "";
  120.         
  121.         $urli = $connection->fetchAll('
  122.         SELECT 
  123.     sct1.name, lo1.code, scd1.url, sc1.access_key
  124. FROM
  125.     sales_channel  sc1
  126. INNER JOIN
  127.     sales_channel_translation sct1 
  128.     ON sct1.sales_channel_id = sc1.id
  129. INNER JOIN    
  130.     sales_channel_domain scd1
  131.     ON sc1.id = scd1.sales_channel_id
  132. INNER JOIN
  133.     language la1 
  134.     ON la1.id = sc1.language_id
  135. INNER JOIN
  136.     locale lo1 
  137.     ON lo1.id = la1.locale_id
  138. where sct1.name != "Headless" and sc1.access_key = "' .$value["access_key"] .'"
  139. order by scd1.url asc
  140.         ');
  141.         $firsturl="";
  142.         
  143.         foreach ($urli as $value1) {
  144.             if ($firsturl == "") {
  145.                 $firsturl = $value1["url"];
  146.             }
  147.             $opt = $opt .'
  148.             <option>
  149.                     <id>' .$value1["url"] .'</id>
  150.                     <name>' .$value1["url"] .'</name>
  151.                     <name lang="de-DE">' .$value1["url"] .'</name>
  152.                 </option>
  153.             ';
  154.         }
  155.         
  156.         
  157.         
  158.         
  159.         $myarray= $myarray .'
  160.         <card>
  161.         
  162.         <title>Card ' .($i+2) .'</title>
  163.         <title lang="de-DE">Card ' .($i+2) .'</title>
  164.         
  165.         <input-field type="text">
  166.             <name>eingabefeld' .($i+2) .'</name>
  167.             <class>ultra-info-start-button</class>
  168.             <placeholder>' .$value["name"] .'</placeholder>
  169.             <placeholder lang="de-DE">' .$value["name"] .'</placeholder>                 
  170.             <disabled>true</disabled>
  171.         </input-field>
  172.         
  173.         <input-field type="bool">
  174.             <name>Kanal' .$i .'langonoff</name>
  175.             <label>Activate</label>
  176.             <label lang="de-DE">Einschalten</label>
  177.         </input-field>
  178.         
  179.         <input-field type="text">
  180.             <name>Kanal' .$i .'name</name>
  181.             <label>Label</label>
  182.             <label lang="de-DE">Bezeichnung</label>
  183.         </input-field>
  184.         
  185.         <input-field type="single-select">
  186.             <name>Kanal' .$i .'kanal</name>
  187.             <label>' .$value["name"] .'</label>
  188.             <label lang="de-DE">' .$value["name"] .'</label>
  189.             <options>
  190.                  <option>
  191.                     <id>' .$value["name"] .";;" .$value["code"] .';;' .$value["access_key"] .'</id>
  192.                     <name>' .$value["name"] .'</name>
  193.                     <name lang="de-DE">' .$value["name"] .'</name>
  194.                 </option>
  195.             </options>
  196.             <disabled>true</disabled>
  197.         </input-field>
  198.         
  199.         
  200.         <input-field type="single-select">
  201.             <name>Kanal' .$i .'url</name>
  202.             <label>Choose URL</label>
  203.             <label lang="de-DE">URL auswählen</label>
  204.             <options>
  205.                  ' .$opt .'
  206.             </options>
  207.         </input-field>
  208.         
  209.         <input-field type="text">
  210.             <name>Kanal' .$i .'title</name>
  211.             <label>Title</label>
  212.             <label lang="de-DE">Title</label>
  213.         </input-field>
  214.         
  215.         <input-field type="bool">
  216.             <name>Kanal' .$i .'ownflagonoff</name>
  217.             <label>Turn on own picture</label>
  218.             <label lang="de-DE">Eigenes Bild einschalten</label>
  219.         </input-field>
  220.         
  221.         <component name="sw-media-field">
  222.             <name>Kanal' .$i .'flagger</name>
  223.             <label>Own picture</label>
  224.             <label lang="de-DE">Eigenes Bild</label>
  225.         </component>
  227.     </card>';
  229.         $this->setValue('Kanal' .$i ."kanal", $value["name"] .";;" .$value["code"] .';;' .$value["access_key"]);
  230.         $this->setValue('Kanal' .$i .'langonoff', 1);
  231.         $this->setValue('flagonoff', 1);
  232.         $this->setValue('Kanal' .$i .'url', $firsturl);
  233.         
  234.         }
  235.         fwrite($file,$topper .$optionstop .$myarray .$optionsbottom);
  236.         fclose($file);
  237.         
  238.         $customFieldSetRepository = $this->container->get('custom_field_set.repository');
  239.         $customFieldSetRepository->upsert([$this->getFieldSet()], $context->getContext());
  240.         
  241.         $sc_name = $connection->fetchAll('SELECT * FROM sales_channel_translation') ;
  243.         foreach ($sc_name as $value2) {
  244.             if($value2["custom_fields"] == '{"custom_verkaufskanal_name": null}' or $value2["custom_fields"] == 'NULL' or $value2["custom_fields"] == '') {
  245.                 $ergebnis='{"custom_verkaufskanal_name": "' .$value2["name"] .'"}';
  246.                 $connection->executeUpdate('UPDATE sales_channel_translation SET custom_fields =' .chr(39) .$ergebnis .chr(39) .' WHERE name="' .$value2["name"] .'"');
  247.             }
  248.             
  249.         }
  250.         $connection->executeUpdate("UPDATE mail_template_translation SET sender_name = REPLACE(sender_name,'{{ salesChannel.name }}','{{salesChannel.customFields.custom_verkaufskanal_name}}')");
  251.         $connection->executeUpdate("UPDATE mail_template_translation SET subject = REPLACE(subject,'{{ salesChannel.translated.name }}','{{salesChannel.customFields.custom_verkaufskanal_name}}')");
  252.         
  253.         
  254.     }
  255.     public function activate(ActivateContext $context): void
  256.    {
  257.        
  258.         
  259.    }
  260.     public function deactivate(DeactivateContext $context): void
  261.     {
  262.         
  263.     }
  264.     
  265.     public function update(UpdateContext $context): void
  266.     {
  267.         copy('../custom/plugins/UltraSidebarCategoryOptimizer/src/Resources/datas/ultra-config-styler.css', '../public/bundles/administration/static/css/ultra-config-styler.css');
  268.         copy('../custom/plugins/UltraSidebarCategoryOptimizer/src/Resources/datas/ultra-config-styler.js', '../public/bundles/administration/static/js/ultra-config-styler.js');
  269.     }
  270.     
  271.     public function uninstall(UninstallContext $context): void
  272.     {
  273.         parent::uninstall($context);
  274.         $connection = $this->container->get(Connection::class);
  275.         $connection->executeUpdate('DELETE FROM custom_field_set where name = "ultra_saleschannel"');
  277.         if ($context->keepUserData()) {
  278.             return;
  279.         }
  280.         $connection->executeUpdate('delete FROM `system_config` where configuration_key like "UltraStoreSwitcher%"');
  281.         $connection->executeUpdate("UPDATE mail_template_translation SET sender_name = REPLACE(sender_name,'{{salesChannel.customFields.custom_verkaufskanal_name}}','{{ salesChannel.name }}')");
  282.         $connection->executeUpdate("UPDATE mail_template_translation SET subject = REPLACE(subject,'{{salesChannel.customFields.custom_verkaufskanal_name}}','{{ salesChannel.translated.name }}')");
  283.         
  284.     }
  286.     
  287.     public function setValue(string $configName, $default = null) : void
  288.     {
  289.         $systemConfigService = $this->container->get(SystemConfigService::class);
  290.         $domain = $this->getName() . '.config.';
  292.         if( $systemConfigService->get($domain . $configName) === null )
  293.         {
  294.             $systemConfigService->set($domain . $configName, $default);
  295.         }
  296.     }
  297.     
  298.     private function getFieldSet()
  299.     {
  300.         return [
  301.             'id' => Uuid::randomHex(),
  302.             'name' => 'ultra_saleschannel',
  303.             'config' => [
  304.                 "translated" => true,
  305.                 'label' => [
  306.                     'de-DE' => 'Verkaufskanal Header Dropdown Menü',
  307.                     'en-GB' => 'Sales channel header dropdown menu'
  308.                 ],
  309.             ],
  310.             'customFields' => [
  312.                 [
  313.                     'id' => Uuid::randomHex(),
  314.                     'name' => 'custom_verkaufskanal_name',
  315.                     'type' => CustomFieldTypes::TEXT,
  316.                     'config' => [
  317.                         'componentName' => 'sw-field',
  318.                         'customFieldType' => 'text',
  319.                         'label' => [
  320.                             'de-DE' => 'Verkaufskanal Name',
  321.                             'en-GB' => 'Saleschannel name',
  322.                         ],
  323.                         'customFieldPosition' => 1
  324.                     ],
  325.                 ],
  326.             ],
  327.             'relations' => [
  328.                 ['id' => Uuid::randomHex(), 'entityName' => 'sales_channel'],
  329.             ]
  330.         ];
  331.     }
  332.     
  333.     
  335. }