public function search($params) { $query = Logreport::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['logreport_id' => SORT_DESC]]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_id')); $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_executetime', Proc::Time)); $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_date', Proc::Date)); $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_errors')); $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_updates')); $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_additions')); $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_amount')); $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_missed')); $query->andFilterWhere(Proc::WhereConstruct($this, 'logreport_memoryused')); return $dataProvider; }
private static function DeleteOldReports() { $countreports = Importconfig::findOne(1); if (!empty($countreports)) { $files = glob('importreports/*.xlsx'); if (count($files) > $countreports->logreport_reportcount) { $ToDelete = Logreport::find()->select(['logreport_id'])->orderBy(['logreport_id' => SORT_ASC])->limit(count($files) - $countreports->logreport_reportcount)->asArray()->all(); } if (!empty($ToDelete)) { foreach ($ToDelete as $row) { Traflog::deleteAll(['id_logreport' => $row['logreport_id']]); Matlog::deleteAll(['id_logreport' => $row['logreport_id']]); Employeelog::deleteAll(['id_logreport' => $row['logreport_id']]); Logreport::findOne($row['logreport_id'])->delete(); $fileroot = 'importreports/Отчет импорта в систему Фрегат N' . $row['logreport_id'] . '.xlsx'; if (DIRECTORY_SEPARATOR !== '/') { $fileroot = mb_convert_encoding($fileroot, 'Windows-1251', 'UTF-8'); } unlink($fileroot); } } } }
/** * Сеттер для списока ID отчетов, подлежащих удалению из базы данных и файловой системы. */ private function setNeedDeleteReports() { if ($this->getCountReportsFiles() > $this->getMaxReportsFiles()) { $this->_needDeleteReports = Logreport::find()->select(['logreport_id'])->orderBy(['logreport_id' => SORT_ASC])->limit($this->getCountReportsFiles() - $this->getMaxReportsFiles())->asArray()->all(); } }
/** * @return bool */ protected function isChanged() { $Field = $this->getMaxFileLastDate(); if (!$Field) { return false; } if (empty(Logreport::find()->count()) || $this->getDebug()) { return true; } $fileLastDateFromDB = Logreport::find()->max($Field); if (empty($fileLastDateFromDB)) { return false; } return strtotime($this->fileLastDate) > strtotime($fileLastDateFromDB); }