/**
* This event deletes entire User Account from Ofuz.
* @param obj : EventControler
* @return void
*/
public function eventDeleteUser(EventControler $evtcl)
{
$do_oex = new OfuzExportXML();
$do_oex->exportUserAccount($evtcl->iduser);
$do_oca = new OfuzCancelAccount();
$do_oca->deleteUserAccount($evtcl->iduser);
}
/**
* Custom method for inactive user backup delete_inactive_users page.
* @cron_delete_inactive_users.php
* @param object $evtcl
*/
function eventDeleteInactiveUsers()
{
$q = new sqlQuery($this->getDbCon());
/*
* Test query
* $sql = "select u.iduser as iduser
from user u left join login_audit la on u.iduser = la.iduser
left join invoice inv on u.iduser=inv.iduser
left join task t on u.iduser=t.iduser
left join project p on u.iduser=p.iduser
where datediff(curdate(),date(la.last_login)) >= '10'
group by u.iduser
having (count(inv.iduser >= 0) and (count(p.iduser)>=0) and (count(t.iduser)>=0))"; */
/* $sql = "select u.iduser as iduser
from user u left join login_audit la on u.iduser = la.iduser
left join invoice inv on u.iduser=inv.iduser
left join task t on u.iduser=t.iduser
left join project p on u.iduser=p.iduser
where datediff(curdate(),date(la.last_login)) >= '60'
group by u.iduser
having (count(inv.iduser >= 10) and (count(p.iduser)>=10) and (count(t.iduser)>=10))"; */
$sql = "select u.iduser as iduser \n\t\t\t\tfrom user u inner join login_audit la on u.iduser = la.iduser \n\t\t\t\twhere datediff(curdate(),date(la.last_login)) >= '60' ";
$q->query($sql);
$nums = $q->getNumRows();
$tmp = 0;
if ($nums >= 1) {
while ($q->fetch()) {
$iduser = $q->getData('iduser');
$count_for_inactive = $this->CountTaskProjectInvoiceContactForUser($iduser);
if ($iduser == 'NULL' || empty($iduser) || $count_for_inactive == 0) {
$nums = 0;
} else {
$expxml = new OfuzExportXML();
$expxml->exportUserAccountandDelete($iduser);
$tmp++;
}
}
}
$msg = "{$tmp} user record has been deleted";
return $msg;
}
