webmatch /
WbmQueryManager
| Conditions | 13 |
| Paths | 2978 |
| Total Lines | 119 |
| Lines | 3 |
| Ratio | 2.52 % |
| Changes | 0 | ||
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 57 | public function runQueryManagerCron() |
||
| 58 | { |
||
| 59 | $now = date('Y-m-d H:i:s'); |
||
| 60 | |||
| 61 | /** @var \Doctrine\ORM\QueryBuilder $qb */ |
||
| 62 | $qb = $this->container->get('models')->createQueryBuilder(); |
||
| 63 | $qb->select( |
||
| 64 | array( |
||
| 65 | 'query' |
||
| 66 | ) |
||
| 67 | ) |
||
| 68 | ->from('WbmQueryManager\Models\Query', 'query') |
||
| 69 | ->where('query.hasCronjob = 1') |
||
| 70 | ->andWhere('query.nextRun <= :nextRun') |
||
| 71 | ->setParameter('nextRun', $now) |
||
| 72 | ->orderBy('query.name', 'ASC'); |
||
| 73 | |||
| 74 | $cronJobs = $qb->getQuery()->getArrayResult(); |
||
| 75 | |||
| 76 | $data = array(); |
||
| 77 | $clearCacheAfter = false; |
||
| 78 | |||
| 79 | foreach($cronJobs as $cronJob){ |
||
| 80 | $i = 0; |
||
| 81 | $numRows = 0; |
||
| 82 | try { |
||
| 83 | /** @var \mysqli|\Zend_Db_Statement_Pdo $query */ |
||
| 84 | $query = $this->container->get('wbm_query_manager.db')->query($cronJob['sqlString']); |
||
| 85 | if($query instanceof \Zend_Db_Statement_Pdo) { |
||
|
|
|||
| 86 | $query->closeCursor(); |
||
| 87 | } |
||
| 88 | |||
| 89 | /** @var \Enlight_Components_Snippet_Namespace $snippets */ |
||
| 90 | $snippets = $this->container->get('snippets')->getNamespace("backend/plugins/wbm/querymanager"); |
||
| 91 | |||
| 92 | do { |
||
| 93 | if($this->container->get('wbm_query_manager.db')->getColumnCount($query)){ |
||
| 94 | $records = $this->container->get('wbm_query_manager.db')->fetchAll($query); |
||
| 95 | $rowCount = $this->container->get('wbm_query_manager.db')->getRowCount($query); |
||
| 96 | $recordFields = array_keys($records[0]); |
||
| 97 | |||
| 98 | $date = new \DateTime(); |
||
| 99 | |||
| 100 | $file = preg_replace("/[^a-z0-9\.]/", "", strtolower($cronJob['name'])) . "_" . $date->format('Y_m_d_h_i_s') . '_' . $i++ . ".csv"; |
||
| 101 | |||
| 102 | $csvPath = $this->container->get('application')->DocPath() . 'var/log/' . $file; |
||
| 103 | |||
| 104 | $outputBuffer = fopen($csvPath, 'w'); |
||
| 105 | View Code Duplication | foreach(array_merge(array(0 => $recordFields),$records) as $val) { |
|
| 106 | fputcsv($outputBuffer, $val, $this->container->get('config')->getByNamespace('WbmQueryManager', 'csv_field_separator')); |
||
| 107 | } |
||
| 108 | fclose($outputBuffer); |
||
| 109 | |||
| 110 | $mailRecipient = $this->container->get('config')->getByNamespace('WbmQueryManager', 'mail_address_receiver'); |
||
| 111 | if(!empty($cronJob['mailRecipient'])){ |
||
| 112 | $mailRecipient = $cronJob['mailRecipient']; |
||
| 113 | } |
||
| 114 | if(!empty($mailRecipient)){ |
||
| 115 | $mail = clone $this->container->get('mail'); |
||
| 116 | $mail->setFrom($this->container->get('config')->get('mail')); |
||
| 117 | $mail->addTo(array_map('trim', explode(',', $mailRecipient))); |
||
| 118 | $mail->setSubject($cronJob['name']); |
||
| 119 | $mail->setBodyText($rowCount . ' ' . $snippets->get('rowsAffected', 'Reihen betroffen')); |
||
| 120 | $mail->createAttachment( |
||
| 121 | fopen($csvPath, 'r'), |
||
| 122 | 'application/pdf', |
||
| 123 | \Zend_Mime::DISPOSITION_ATTACHMENT, |
||
| 124 | \Zend_Mime::ENCODING_BASE64, |
||
| 125 | $file |
||
| 126 | ); |
||
| 127 | $mail->send(); |
||
| 128 | } |
||
| 129 | |||
| 130 | if(!$this->container->get('config')->getByNamespace('WbmQueryManager', 'log_csv')){ |
||
| 131 | unlink($csvPath); |
||
| 132 | } |
||
| 133 | |||
| 134 | $numRows += $rowCount; |
||
| 135 | } else { |
||
| 136 | $numRows += $this->container->get('wbm_query_manager.db')->getRowCount($query); |
||
| 137 | } |
||
| 138 | } while ($this->container->get('wbm_query_manager.db')->nextResult($query)); |
||
| 139 | |||
| 140 | $this->container->get('wbm_query_manager.db')->close($query); |
||
| 141 | |||
| 142 | $result = $numRows . ' ' . $snippets->get('rowsAffected', 'Reihen betroffen'); |
||
| 143 | } catch (\Exception $e) { |
||
| 144 | $result = $e->getMessage(); |
||
| 145 | } |
||
| 146 | /** @var Query $query */ |
||
| 147 | $query = $this->container->get('models')->getRepository('WbmQueryManager\Models\Query')->find($cronJob['id']); |
||
| 148 | $query->setLastLog($result); |
||
| 149 | /** @var \DateTime $lastRun */ |
||
| 150 | $lastRun = $query->getLastRun() ? : new \DateTime(); |
||
| 151 | $query->setLastRun($now); |
||
| 152 | $query->setNextRun($lastRun->add(\DateInterval::createFromDateString($query->getIntervalInt() . ' seconds'))); |
||
| 153 | |||
| 154 | $this->container->get('models')->persist($query); |
||
| 155 | $this->container->get('models')->flush(); |
||
| 156 | $this->container->get('models')->clear(); |
||
| 157 | |||
| 158 | if($cronJob['clear_cache']){ |
||
| 159 | $clearCacheAfter = true; |
||
| 160 | } |
||
| 161 | |||
| 162 | $data[$cronJob['name']] = $result; |
||
| 163 | } |
||
| 164 | |||
| 165 | if($clearCacheAfter){ |
||
| 166 | $cacheManager = $this->container->get('shopware.cache_manager'); |
||
| 167 | $cacheManager->clearHttpCache(); |
||
| 168 | $cacheManager->clearTemplateCache(); |
||
| 169 | $cacheManager->clearConfigCache(); |
||
| 170 | $cacheManager->clearSearchCache(); |
||
| 171 | $cacheManager->clearProxyCache(); |
||
| 172 | } |
||
| 173 | |||
| 174 | return $data; |
||
| 175 | } |
||
| 176 | } |
||
| 177 |
Loading history...
This error could be the result of:
1. Missing dependencies
PHP Analyzer uses your
composer.jsonfile (if available) to determine the dependencies of your project and to determine all the available classes and functions. It expects thecomposer.jsonto be in the root folder of your repository.Are you sure this class is defined by one of your dependencies, or did you maybe not list a dependency in either the
requireorrequire-devsection?2. Missing use statement
PHP does not complain about undefined classes in
ìnstanceofchecks. For example, the following PHP code will work perfectly fine:If you have not tested against this specific condition, such errors might go unnoticed.