webmatch / WbmQueryManager

Subscriber/Backend/QueryManagerCron.php

Spacing +9 added lines, -9 removed lines

@@ -76,13 +76,13 @@ 
         $data = array();
         $clearCacheAfter = false;
 
-        foreach($cronJobs as $cronJob){
+        foreach ($cronJobs as $cronJob) {
             $i = 0;
             $numRows = 0;
             try {
                 /** @var \mysqli|\Zend_Db_Statement_Pdo $query */
                 $query = $this->container->get('wbm_query_manager.db')->query($cronJob['sqlString']);
-                if($query instanceof \Zend_Db_Statement_Pdo) {
+                if ($query instanceof \Zend_Db_Statement_Pdo) {
                     $query->closeCursor();
                 }
 
@@ -90,7 +90,7 @@ 
                 $snippets = $this->container->get('snippets')->getNamespace("backend/plugins/wbm/querymanager");
 
                 do {
-                    if($this->container->get('wbm_query_manager.db')->getColumnCount($query)){
+                    if ($this->container->get('wbm_query_manager.db')->getColumnCount($query)) {
                         $records = $this->container->get('wbm_query_manager.db')->fetchAll($query);
                         $rowCount = $this->container->get('wbm_query_manager.db')->getRowCount($query);
                         $recordFields = array_keys($records[0]);
@@ -102,7 +102,7 @@ 
                         $csvPath = $this->container->get('application')->DocPath() . 'var/log/' . $file;
 
                         $outputBuffer = fopen($csvPath, 'w');
-                        foreach(array_merge(array(0 => $recordFields),$records) as $val) {
+                        foreach (array_merge(array(0 => $recordFields), $records) as $val) {
                             fputcsv($outputBuffer, $val, $this->container->get('config')->getByNamespace('WbmQueryManager', 'csv_field_separator'));
                         }
                         fclose($outputBuffer);
@@ -111,7 +111,7 @@ 
                         if ($cronJob['mailRecipient']) {
                             $mailRecipient = $cronJob['mailRecipient'];
                         }
-                        if(!empty($mailRecipient)){
+                        if (!empty($mailRecipient)) {
                             $mail = clone $this->container->get('mail');
                             $mail->setFrom($this->container->get('config')->get('mail'));
                             $mail->addTo($mailRecipient);
@@ -127,7 +127,7 @@ 
                             $mail->send();
                         }
 
-                        if(!$this->container->get('config')->getByNamespace('WbmQueryManager', 'log_csv')){
+                        if (!$this->container->get('config')->getByNamespace('WbmQueryManager', 'log_csv')) {
                             unlink($csvPath);
                         }
 
@@ -147,7 +147,7 @@ 
             $query = $this->container->get('models')->getRepository('WbmQueryManager\Models\Query')->find($cronJob['id']);
             $query->setLastLog($result);
             /** @var \DateTime $lastRun */
-            $lastRun = $query->getLastRun() ? : new \DateTime();
+            $lastRun = $query->getLastRun() ?: new \DateTime();
             $query->setLastRun($now);
             $query->setNextRun($lastRun->add(\DateInterval::createFromDateString($query->getIntervalInt() . ' seconds')));
 
@@ -155,14 +155,14 @@ 
             $this->container->get('models')->flush();
             $this->container->get('models')->clear();
 
-            if($cronJob['clear_cache']){
+            if ($cronJob['clear_cache']) {
                 $clearCacheAfter = true;
             }
 
             $data[$cronJob['name']] = $result;
         }
 
-        if($clearCacheAfter){
+        if ($clearCacheAfter) {
             $cacheManager = $this->container->get('shopware.cache_manager');
             $cacheManager->clearHttpCache();
             $cacheManager->clearTemplateCache();

WbmQueryManager.php

Spacing +2 added lines, -2 removed lines

@@ -60,14 +60,14 @@
      */
     public function update(UpdateContext $context)
     {
-        if(version_compare($context->getCurrentVersion(), '2.0.0', '<')) {
+        if (version_compare($context->getCurrentVersion(), '2.0.0', '<')) {
             $sql = "ALTER TABLE `wbm_query_manager` CHANGE `interval` `interval_int` INT(11) NULL DEFAULT '0';
                     ALTER TABLE `wbm_query_manager` CHANGE `sql` `sql_string` LONGTEXT NOT NULL;";
 
             $this->container->get('shopware.db')->query($sql);
         }
 
-        if(version_compare($context->getCurrentVersion(), '2.0.3', '<')) {
+        if (version_compare($context->getCurrentVersion(), '2.0.3', '<')) {
             $sql = "ALTER TABLE `wbm_query_manager` ADD `mail_recipient` VARCHAR (255) NULL DEFAULT NULL AFTER `last_run`;";
 
             $this->container->get('shopware.db')->query($sql);