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