static function setOrdenDeCompraParcial($id)
{
$params = array();
$query = 'update SolicitudEntrega_OrdenDeCompra set entregaCompleta = 0 where ordenDeCompraId =' . $id;
GenericDao::executeQuery($query, $params);
}
static function getRolesByMail($mail)
{
$sql = 'select r.id, r.name, r.module, r.section, r.description, r.enabled, r.createDate, r.updateDate ' . 'from Role r ' . 'inner join User_Role ur on ur.roleId = r.id ' . 'inner join User u on ur.userId = u.id ' . 'where u.mail = :mail ';
$params = array(':mail' => $mail);
return GenericDao::executeQuery($sql, $params, "Role", true, false, false);
}
