static function queryCertificatesWhichExpire() { $config = new PluginCertificatesConfig(); $notif = new PluginCertificatesNotificationState(); $config->getFromDB('1'); $delay = $config->fields["delay_whichexpire"]; $query = "SELECT *\n FROM `glpi_plugin_certificates_certificates`\n WHERE `date_expiration` IS NOT NULL\n AND `is_deleted` = '0'\n AND DATEDIFF(CURDATE(),`date_expiration`) > -{$delay} \n AND DATEDIFF(CURDATE(),`date_expiration`) < 0 "; $query .= "AND `plugin_certificates_certificatestates_id` NOT IN (999999"; $query .= $notif->findStates(); $query .= ") "; return $query; }