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); }