resource->getConnection(); $table = $this->resource->getTableName('esun_lingxing_sync_log'); $successCutoff = gmdate('Y-m-d H:i:s', time() - ($this->config->getSuccessLogRetentionDays() * 86400)); $errorCutoff = gmdate('Y-m-d H:i:s', time() - ($this->config->getErrorLogRetentionDays() * 86400)); $deleted = $connection->delete($table, [ 'status IN (?)' => self::COMPACT_STATUSES, 'created_at < ?' => $successCutoff, ]); $deleted += $connection->delete($table, [ 'status NOT IN (?)' => self::COMPACT_STATUSES, 'created_at < ?' => $errorCutoff, ]); return $deleted; } }