PHP PluginCertificatesNotificationState::findStates Examples

Example #1

File: certificate.class.php Project: paisdelconocimiento/glpi-smartcities

 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;
 }