public function checkErrorLogsDb()
{
$conf = Config::getSystemConfig();
$config = $conf->applicationlog;
if ($config->mail_notification->send_log_summary) {
$receivers = preg_split("/,|;/", $config->mail_notification->mail_receiver);
array_walk($receivers, function (&$value) {
$value = trim($value);
});
$logLevel = (int) $config->mail_notification->filter_priority;
$db = \Pimcore\Db::get()->getResource();
$query = "SELECT * FROM " . \Pimcore\Log\Handler\ApplicationLoggerDb::TABLE_NAME . " WHERE maintenanceChecked IS NULL AND priority <= {$logLevel} order by id desc";
$rows = $db->fetchAll($query);
$limit = 100;
$rowsProcessed = 0;
$rowCount = count($rows);
if ($rowCount) {
while ($rowsProcessed < $rowCount) {
$entries = array();
if ($rowCount <= $limit) {
$entries = $rows;
} else {
for ($i = $rowsProcessed; $i < $rowCount && count($entries) < $limit; $i++) {
$entries[] = $rows[$i];
}
}
$rowsProcessed += count($entries);
$html = var_export($entries, true);
$html = "<pre>{$html}</pre>";
$mail = new \Pimcore\Mail();
$mail->setIgnoreDebugMode(true);
$mail->setBodyHtml($html);
$mail->addTo($receivers);
$mail->setSubject('Error Log ' . \Pimcore_Tool::getHostUrl());
$mail->send();
}
}
$db->query("UPDATE " . \Pimcore\Log\Handler\ApplicationLoggerDb::TABLE_NAME . " set maintenanceChecked = 1");
}
}
/**
* Gets file information for replacement
*
* @static
* @param string $path
* @param Document | null $document
* @return array
* @throws Exception
*/
public static function getNormalizedFileInfo($path, $document = null)
{
if ($document && $document instanceof Document == false) {
throw new Exception('$document has to be an instance of Document');
}
$fileInfo = array();
$hostUrl = Pimcore_Tool::getHostUrl();
if ($path[0] != '/') {
$fileInfo['fileUrl'] = $hostUrl . $document . "/{$path}";
//relative eg. ../file.css
} else {
$fileInfo['fileUrl'] = $hostUrl . $path;
}
$fileInfo['fileExtension'] = substr($path, strrpos($path, '.') + 1);
$netUrl = new Net_URL2($fileInfo['fileUrl']);
$fileInfo['fileUrlNormalized'] = $netUrl->getNormalizedURL();
$fileInfo['filePathNormalized'] = PIMCORE_DOCUMENT_ROOT . str_replace($hostUrl, '', $fileInfo['fileUrlNormalized']);
return $fileInfo;
}
