function _on_execute()
{
debug_push_class(__CLASS__, __FUNCTION__);
if (!$_MIDCOM->auth->request_sudo('fi.kilonkipinat.accountregistration')) {
$msg = "Could not get sudo, aborting operation, see error log for details";
$this->print_error($msg);
debug_add($msg, MIDCOM_LOG_ERROR);
debug_pop();
return;
}
$time_for_old = date('Y-m-d 00:00', time() - 3600 * 24);
$qb_resetrequests = fi_kilonkipinat_accountregistration_resetrequest_dba::new_query_builder();
$qb_resetrequests->add_constraint('metadata.revised', '<', $time_for_old);
$qb_resetrequests->add_constraint('status', '=', FI_KILONKIPINAT_ACCOUNTREGISTRATION_PASSWORDRESETREQUEST_STATUS_NEW);
$results = $qb_resetrequests->execute();
foreach ($results as $result) {
$result->status = FI_KILONKIPINAT_ACCOUNTREGISTRATION_PASSWORDRESETREQUEST_STATUS_INVALID;
$result->update();
}
$time_for_old = date('Y-m-d 00:00', time() - 3600 * 24 * 31);
$qb_accounts = fi_kilonkipinat_accountregistration_accountrequest_dba::new_query_builder();
$qb_accounts->add_constraint('metadata.revised', '<', $time_for_old);
$qb_accounts->add_constraint('status', '=', FI_KILONKIPINAT_ACCOUNTREGISTRATION_ACCOUNT_STATUS_NEW);
$results2 = $qb_accounts->execute();
foreach ($results2 as $result) {
$result->status = FI_KILONKIPINAT_ACCOUNTREGISTRATION_ACCOUNT_STATUS_INVALID;
$result->update();
}
$_MIDCOM->auth->drop_sudo();
debug_pop();
}
/**
* The handler for the index article.
*
* @param mixed $handler_id the array key from the request array
* @param array $args the arguments given to the handler
* @param Array &$data The local request data.
* @return boolean Indicating success.
*/
function _handler_listPending($handler_id, $args, &$data)
{
$_MIDCOM->auth->require_admin_user();
$this->_request_data['name'] = "fi.kilonkipinat.accountregistration";
$this->_update_breadcrumb_line($handler_id);
$title = $this->_l10n_midcom->get('fi.kilonkipinat.accountregistration');
$_MIDCOM->set_pagetitle(":: {$title}");
$prefix = $this->_request_data['prefix'];
$qb = fi_kilonkipinat_accountregistration_accountrequest_dba::new_query_builder();
$qb->add_constraint('status', '=', FI_KILONKIPINAT_ACCOUNTREGISTRATION_ACCOUNT_STATUS_EMAILVALIDATED);
$results = $qb->execute();
$this->_request_data['pending'] = $results;
return true;
}
