/** * Query used for check accounts which expire * * @return query **/ private static function queryAccountsWhichExpire() { $config = new PluginAccountsConfig(); $notif = new PluginAccountsNotificationState(); $config->getFromDB('1'); $delay = $config->fields["delay_whichexpire"]; $query = "SELECT *\n FROM `glpi_plugin_accounts_accounts`\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_accounts_accountstates_id` NOT IN (999999"; $query .= $notif->findStates(); $query .= ") "; return $query; }