📁 Reporte de carpeta: `service`

Detalle de clases, métodos y comentarios extraídos automáticamente

🧩 Clase: `AcreditacioService`

Ubicación: src\main\java\es\uv\saic\service\AcreditacioService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

getById() — ⚪ Interno
AcreditacioPK() — ⚪ Interno
getAll() — ⚪ Interno
getNextsCurrentYear() — ⚪ Interno
getByCursGrup() — ⚪ Interno
getByCursGrupTambit() — ⚪ Interno
getByCurs() — ⚪ Interno
getByOrgan() — ⚪ Interno
getByCentre() — ⚪ Interno
save() — ⚪ Interno

🧩 Clase: `AuthProvider`

Ubicación: src\main\java\es\uv\saic\service\AuthProvider.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

authenticate() — ⚪ Interno
SimpleGrantedAuthority() — ⚪ Interno
SimpleGrantedAuthority() — ⚪ Interno
SimpleGrantedAuthority() — ⚪ Interno
SimpleGrantedAuthority() — ⚪ Interno
UsernamePasswordAuthenticationToken() — ⚪ Interno
BadCredentialsException() — ⚪ Interno
if() — ⚪ Interno
InitialDirContext() — ⚪ Interno
SearchControls() — ⚪ Interno
BadCredentialsException() — ⚪ Interno
BadCredentialsException() — ⚪ Interno
BadCredentialsException() — ⚪ Interno
Date() — ⚪ Interno
SimpleGrantedAuthority() — ⚪ Interno
SimpleGrantedAuthority() — ⚪ Interno
SimpleGrantedAuthority() — ⚪ Interno
UsernamePasswordAuthenticationToken() — ⚪ Interno
AuthenticationServiceException() — ⚪ Interno
BadCredentialsException() — ⚪ Interno
supports() — ⚪ Interno

🧩 Clase: `CalendariService`

Ubicación: src\main\java\es\uv\saic\service\CalendariService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

getAll() — ⚪ Interno
findById() — ⚪ Interno
getNextEvents() — ⚪ Interno
save() — ⚪ Interno
delete() — ⚪ Interno

🧩 Clase: `CategoriaService`

Ubicación: src\main\java\es\uv\saic\service\CategoriaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

getAll() — ⚪ Interno
findById() — ⚪ Interno
findFirstLevel() — ⚪ Interno
findFirstLevelAndU() — ⚪ Interno
findByTipusTambit() — ⚪ Interno
findByTipusTambitAndU() — ⚪ Interno
findByPareTambit() — ⚪ Interno
findByPareTambitAndU() — ⚪ Interno
save() — ⚪ Interno
delete() — ⚪ Interno

🧩 Clase: `DataService`

Ubicación: src\main\java\es\uv\saic\service\DataService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

DataService() — ⚪ Interno
doImport() — ⚪ Interno

StringBuilder() — ⚪ Interno

/*  1) Comprobar columnas obligatorias  */
List<String> mandatoryColumns = new ArrayList<String>();
List<String> knownColumns = new ArrayList<String>();
if(clau.equals("ruct")) {
this.setColumnsRuct(ambit, knownColumns, mandatoryColumns);
}
else {
this.setColumnsCod(ambit, knownColumns, mandatoryColumns);
}

if(!this.checkColumns(header, mandatoryColumns, errors, locale)) {
return errors.append("[ERROR] " + (locale.equals("es") ? "Se han encontrado errores en el fichero proporcionado. No se ha importado ningún registro. " : "S'han trobat errors al fitxer proporcionat. No s'ha importat cap registre.")).append("<br>").toString();
}

/*  2) Eliminar las columnas obligatorias, conocidas e ignoradas. El resto se consideran indicadores a importar */
knownColumns.addAll(mandatoryColumns);
knownColumns.addAll(ignoredColumns);
for(String c : knownColumns) {
headerInds.removeIf(v->v.equalsIgnoreCase(c));
}

/*  3) Comprobar valores y tipos  */
if(!this.checkValues(records, ambit, clau, errors, locale)) {
return errors.append(("[ERROR] " + (locale.equals("es") ? "Se han encontrado errores en el fichero proporcionado. No se ha importado ningún registro. " : "S'han trobat errors al fitxer proporcionat. No s'ha importat cap registre."))).append("<br>").toString();
}

/*  4) Importar datos  */
Integer numRecords = 0;
Integer numTuples = 0;
for (CSVRecord record : records) {
Map<String, String> recordMap = new LinkedCaseInsensitiveMap<>();
recordMap.putAll(record.toMap());
String c = ambit.equals("T") || ambit.equals("C") ? translateCentre(recordMap.get("centre")) : null;
String t = ambit.equals("T") ? translateTitulacio(recordMap.get("titulacio")) : null;  
String type = recordMap.get("tipus");
Integer curs = Integer.parseInt(recordMap.get("curs").replaceAll("\\D+",""));

String cursEnquesta = recordMap.containsKey("curs_enquesta") ? recordMap.get("curs_enquesta") : null;
String titulacioOrigen = recordMap.containsKey("titulacio_origen") ? recordMap.get("titulacio_origen") : null;
String centreOrigen = recordMap.containsKey("centre_origen") ? recordMap.get("centre_origen") : null;
Integer nenq = recordMap.containsKey("nenq") ? Integer.parseInt(recordMap.get("nenq").replaceAll("\\D+","")) : null;
String ructStr = recordMap.containsKey("ruct") ? recordMap.get("ruct").replaceAll("\\D+","") : null;
String cursd = recordMap.containsKey("cursd") ? recordMap.get("cursd") : null;
Integer ruct = null;
    
if(ructStr != null) {
if(!(ructStr.isBlank() || ructStr.isEmpty() || ructStr.equals("NULL") || ructStr.equals("null"))) {
ruct = Integer.parseInt(ructStr);
}
}

Integer centre;
Integer titulacio;
if(clau.equals("ruct") && ambit.equals("T") && ruct != null) {
Organ o = this.orgs.findByRuct(ruct);
if(o == null) {
errors.append("[WARNING] " + (locale.equals("es") ? "No se ha encontrado el RUCT "+ructStr+", se omiten los registros de esta entrada." : "No s'ha trobat el RUCT "+ructStr+", s'ometen els registres d'aquesta entrada.")).append("<br>").toString();
continue;
}
titulacio = o.getId().getLugar();
centre = o.getOrgan().getId().getLugar();
}
else{
centre = ambit.equals("T") || ambit.equals("C") ? Integer.parseInt(c.replaceAll("\\D+","")) : null;
titulacio = ambit.equals("T") ? Integer.parseInt(t) : null;
if(!this.orgs.exists("T", titulacio)){
errors.append("[WARNING] " + (locale.equals("es") ? "No se ha encontrado la titulación con código "+titulacio+" pero se importa igualmente." : "No s'ha trobat la titulació amb codi "+titulacio+" però s'importa igualment")).append("<br>").toString();
}
}
    
if(header.contains("cursd")) {
cursd = recordMap.get("cursd").replaceAll("\\D+","");
}
for(String r : headerInds) {
IndicadorEnquestaTmp ie = new IndicadorEnquestaTmp();
    ie.setEnquesta(enquesta);
ie.setTitulacio(titulacio);
ie.setCentre(centre);
ie.setCurs(curs);
ie.setAmbit(ambit); 
ie.setEstudi(estudi);
    ie.setIndicador(r.replace("_min", "").replace("_max", "").toLowerCase());
    ie.setNum(null);
    ie.setCursd(cursd);
    ie.setTipus(type);
    ie.setUsuari(usuari.getUsuari());
    ie.setData(new Timestamp(System.currentTimeMillis()));
    ie.setCursEnquesta(cursEnquesta);
    ie.setTitulacioOrigen(titulacioOrigen);
    ie.setCentreOrigen(centreOrigen);
    ie.setNenq(nenq);
    ie.setRuct(ruct);
        
    try {
    ie.setValor(record.get(r).replace(",", "."));
    }
    catch(Exception ex) {
    ie.setValor(null);
    }
        
    iets.save(ie);
    numRecords++;
}
numTuples++;
}

/*  5) Notificar administradores y usuario implicado  */
this.sendNotificacion(usuari, enquesta, ambit, estudi);
if(!usuari.isAdmin()){
this.sendConfirmation(usuari.getUsuari(), enquesta, ambit, estudi);
}

errors.append("[INFO] " + (locale.equals("es") ? ("Se han importado "+numRecords.toString()+" nuevos registros para un total de "+numTuples.toString()+" titulaciones") : ("[INFO] S'han importat "+numRecords.toString()+" nous registres per a un total de "+numTuples.toString()+" titulacions")));
return errors.toString();
}

public String doDbImport(Integer dbOrigen, String vista, Integer srcCurs, Integer dstCurs, Usuari usuari, String enquesta, String ambit, 
String estudi, String locale, String clau, List<String> ignoredColumns) throws SQLException, ClassNotFoundException {

StringBuilder errors = new StringBuilder();
Datasource source = this.dss.findById(dbOrigen);
if(source == null){
return errors.append("[ERROR] " + (locale.equals("es") ? "No se ha proporcionado un origen de datos válido." : "No s'ha proporcionat un origen de dades vàlid.")).append("<br>").toString();
}
String query = "SELECT * FROM "+vista+ " WHERE curs = "+srcCurs;
Class.forName(source.getDriver());
Integer numRecords = 0;
Integer numTuples = 0;
try (Connection connection = DriverManager.getConnection(source.getConn())) {

/*  1) Ejecutar consulta  */
Statement statement = connection.createStatement();
ResultSet resultset = statement.executeQuery(query);

ResultSetMetaData resultMetadata = resultset.getMetaData();
int columns = resultMetadata.getColumnCount();

/*  2) Obtener resultados para procesar online y cerrar conexión  */
RowSetFactory factory = RowSetProvider.newFactory();
CachedRowSet result = factory.createCachedRowSet();
result.populate(resultset);
connection.close();

/*  3) Comprobar columnas obligatorias  */
List<String> mandatoryColumns = new ArrayList<String>();
List<String> knownColumns = new ArrayList<String>();
if(clau.equals("ruct")) {
this.setColumnsRuct(ambit, knownColumns, mandatoryColumns);
}
else {
this.setColumnsCod(ambit, knownColumns, mandatoryColumns);
}

List<String> allColNames = new ArrayList<String>();
for(int i = 1; i <= columns; i++){
allColNames.add(resultMetadata.getColumnLabel(i).toLowerCase());
}
List<String> colnames = new ArrayList<String>(allColNames);

if(!this.checkColumns(colnames, mandatoryColumns, errors, locale)) {
return errors.append("[ERROR] " + (locale.equals("es") ? "Se han encontrado errores al procesar la vista seleccionada. No se ha importado ningún registro. " : "S'han trobat errors al processar la vista seleccionada. No s'ha importat cap registre.")).append("<br>").toString();
}

knownColumns.addAll(mandatoryColumns);
knownColumns.addAll(ignoredColumns);
for(String c : knownColumns) {
colnames.removeIf(v->v.equalsIgnoreCase(c));
}

if(ambit.equals("T") && !clau.equals("ruct")){
return errors.append("[ERROR] " + (locale.equals("es") ? "Los datos de titulación deben de importarse por código RUCT" : "Les dades de titulació s'han d'importar per códi RUCT.")).append("<br>").toString();
}

/*  4) Importar datos  */
while(result.next()) {
Integer ruct = null;
Integer titulacio = null;
Integer centre = null;
String c = ambit.equals("C") ? translateCentre(result.getString("centre")) : null;
boolean isValid = true; 

if(ambit.equals("T")) {
String ructStr = result.getString("ruct");
if(ructStr != null) {
if(!(ructStr.isBlank() || ructStr.isEmpty() || ructStr.equals("NULL") || ructStr.equals("null"))) {
ruct = Integer.parseInt(ructStr);
}
else{
isValid = false;
}
}
else{
isValid = false;
}
Organ o = this.orgs.findByRuct(ruct);
if(o == null) {
errors.append("[WARNING] " + (locale.equals("es") ? "No se ha encontrado el RUCT "+ructStr+", se omiten los registros de esta entrada." : "No s'ha trobat el RUCT "+ructStr+", s'ometen els registres d'aquesta entrada.")).append("<br>").toString();
continue;
}
titulacio = o.getId().getLugar();
centre = o.getOrgan().getId().getLugar();
}
else if(ambit.equals("C")) {
centre = ambit.equals("T") || ambit.equals("C") ? Integer.parseInt(c.replaceAll("\\D+","")) : null;
if(centre == null){
isValid = false;
}
}

if(isValid) {
Integer curs = dstCurs == null ? result.getInt("curs") : dstCurs;
String tipus = allColNames.contains("tipus") ? result.getString("tipus") : "avg";
String cursEnquesta = allColNames.contains("curs_enquesta") ? result.getString("curs_enquesta") : null;
String titulacioOrigen = allColNames.contains("titulacio_origen") ? result.getString("titulacio_origen") : null;
String centreOrigen = allColNames.contains("centre_origen") ? result.getString("centre_origen") : null;
Integer nenq = allColNames.contains("nenq") ? result.getInt("nenq") : null;
String cursd = allColNames.contains("cursd") ? result.getString("cursd") : null;
for(String colName : colnames) {
IndicadorEnquestaTmp ie = new IndicadorEnquestaTmp();

ie.setEnquesta(enquesta);
ie.setTitulacio(titulacio);
ie.setCentre(centre);
ie.setCurs(curs);
ie.setAmbit(ambit); 
ie.setEstudi(estudi);
ie.setIndicador(colName.replace("_min", "").replace("_max", "").toLowerCase());
ie.setNum(null);
ie.setCursd(cursd);
ie.setTipus(tipus);
ie.setUsuari(usuari.getUsuari());
ie.setData(new Timestamp(System.currentTimeMillis()));
ie.setCursEnquesta(cursEnquesta);
ie.setTitulacioOrigen(titulacioOrigen);
ie.setCentreOrigen(centreOrigen);
ie.setNenq(nenq);
ie.setRuct(ruct);

try {
ie.setValor(result.getString(colName).replace(",", "."));
}
catch(Exception ex) {
ie.setValor(null);
}

iets.save(ie);
numRecords++;
} 
numTuples++;  
}
}
}

/*  5) Notificar administradores y usuario implicado  */
this.sendNotificacion(usuari, enquesta, ambit, estudi);
if(!usuari.isAdmin()){
this.sendConfirmation(usuari.getUsuari(), enquesta, ambit, estudi);
}
errors.append("[INFO] " + (locale.equals("es") ? ("Se han importado "+numRecords.toString()+" nuevos registros para un total de "+numTuples.toString()+" titulaciones") : ("[INFO] S'han importat "+numRecords.toString()+" nous registres per a un total de "+numTuples.toString()+" titulacions")));
return errors.toString();
}

public List<String> listTableColumns(Integer dbOrigen, String vista, String locale) throws SQLException, ClassNotFoundException {

Datasource source = this.dss.findById(dbOrigen);
String query = "SELECT * FROM "+vista+" LIMIT 1;";
Class.forName(source.getDriver());
List<String> colNames = new ArrayList<String>();
try (Connection connection = DriverManager.getConnection(source.getConn())) {

Statement statement = connection.createStatement();
ResultSet resultset = statement.executeQuery(query);

ResultSetMetaData resultMetadata = resultset.getMetaData();
int columns = resultMetadata.getColumnCount();

for(int i = 1; i <= columns; i++){
colNames.add(resultMetadata.getColumnLabel(i));
}

}

return colNames;
}

public List<IndicadorEnquestaTmpRepository.IndicadorEnquestaTmpDup> checkDuplicates(String enquesta) {
return this.iets.checkDuplicates(enquesta);
}

public Integer consolidateByEnquesta(String enquesta) {
if(this.iets.checkDuplicates(enquesta).size() > 0) {
return -1;
}
else {
Integer i = this.ies.consolidateByEnquesta(enquesta);
this.iets.deleteByEnquesta(enquesta);
return i;
}
}

public Integer countByEnquesta(String enquesta) {
return this.iets.countByEnquesta(enquesta);
}

public List<IndicadorEnquestaTmpRepository.IndicadorEnquestaTmpDup> checkIntegrity(String enquesta){
return this.iets.checkIntegrity(enquesta);
}

public Integer deleteFromCurrent(String enquesta){
return this.iets.deleteFromCurrent(enquesta);
}

public Integer deleteFromPending(String enquesta){
return this.iets.deleteFromPending(enquesta);
}

private void setColumnsCod(String ambit, List<String> knownColumns, List<String> mandatoryColumns) {
knownColumns.addAll(Arrays.asList("ruct", "curs_enquesta", "centre_origen", "titulacio_origen", "nenq", "cursd"));
if(ambit.equals("U")) {
mandatoryColumns.addAll(Arrays.asList("curs", "tipus"));
}
else if(ambit.equals("C")) {
mandatoryColumns.addAll(Arrays.asList("curs", "centre", "tipus"));
}
else {
mandatoryColumns.addAll(Arrays.asList("curs", "titulacio", "centre", "tipus"));
}
}

private void setColumnsRuct(String ambit, List<String> knownColumns, List<String> mandatoryColumns) {
knownColumns.addAll(Arrays.asList("curs_enquesta", "centre_origen", "titulacio_origen", "nenq", "cursd"));
if(ambit.equals("U")) {
mandatoryColumns.addAll(Arrays.asList("curs", "tipus"));
}
else if(ambit.equals("C")) {
mandatoryColumns.addAll(Arrays.asList("curs", "tipus", "ruct"));
knownColumns.add("centre");
}
else {
mandatoryColumns.addAll(Arrays.asList("curs", "tipus", "ruct"));
knownColumns.addAll(Arrays.asList("centre", "titulacio"));
}
}

private boolean checkColumns(List<String> header, List<String> mandatoryColumns, StringBuilder errors, String locale) {
boolean isvalid = true;
for(String c : mandatoryColumns) {
if(!header.stream().anyMatch(c::equalsIgnoreCase)) {
isvalid = false;
errors.append((locale.equals("es") ? "[ERROR] No se ha encontrado la columna " : "[ERROR] No s'ha trobat la columna ") +c).append("<br>");
}
}
return isvalid;
}

private boolean checkValues(List<CSVRecord> records, String ambit, String clau, StringBuilder errors, String locale) {
boolean isvalid = true;
Integer numRecords = 0;
for (CSVRecord record : records) {
Map<String, String> recordMap = new LinkedCaseInsensitiveMap<>();
recordMap.putAll(record.toMap());

String type = recordMap.get("tipus");
numRecords++;

if((ambit.equals("T") || ambit.equals("C")) && !clau.equals("ruct")) {
String c = recordMap.get("centre");
c = translateCentre(c);
if(!StringUtils.isNumeric(c.replace("C", ""))) {
isvalid = false;
errors.append("[ERROR] " + (locale.equals("es") ? "En la linea " : "A la línia ") + numRecords.toString() + ": " + (locale.equals("es") ? c+" no es un valor válido para la columna centre." : c+" no es un valor vàlid per la columna centre.")).append("<br>");
} 
}

if(ambit.equals("T")) {
String t = recordMap.get("titulacio");
if(!clau.equals("ruct")) {
t = translateTitulacio(t);
if(!StringUtils.isNumeric(t)) {
isvalid = false;
errors.append("[ERROR] " + (locale.equals("es") ? "En la linea " : "A la línia ") + numRecords.toString() + ": " + (locale.equals("es") ? t+" no es un valor válido para la columna titulacio." : t+" no es un valor vàlid per la columna titulacio.")).append("<br>");
}
}
else {
String ructStr = recordMap.get("ruct");
if(!ructStr.isBlank() && ructStr.isEmpty() && ructStr.equals("NULL") && ructStr.equals("null") && !StringUtils.isNumeric(t)) {
isvalid = false;
errors.append("[ERROR] " + (locale.equals("es") ? "En la linea " : "A la línia ") + numRecords.toString() + ": " + (locale.equals("es") ? ructStr+" no es un valor válido para la columna ruct." : ructStr+" no es un valor vàlid per la columna ruct.")).append("<br>");
}
}
}

if(!type.equals("avg") && !type.equals("min") && !type.equals("max")) {
isvalid = false;
errors.append("[ERROR] " + (locale.equals("es") ? "En la linea " : "A la línia ") + numRecords.toString() + ": " + (locale.equals("es") ? type+" no es un valor válido para la columna tipus." : type+" no es un valor vàlid per la columna tipus.")).append("<br>");
}
}
return isvalid;
}

private void sendNotificacion(Usuari usuari, String enquesta, String ambit, String estudi) {
try {
this.ems.sendMail("saic@uv.es", "[SYS] Datos pendientes de consolidar", "Estimado/a administrador: \n"
+ "\n"
+ "El usuario "+usuari.getUsuari()+" ha importado nuevos datos referentes a: \n"
+ "Origen: "+enquesta+"\n"
+ "Ámbito: "+ambit+"\n"
+ "Tipo titulación: "+estudi+"\n"
+ "\n"
+ "Acceda a https://saic.uv.es y realice las acciones pertinentes para consolidar los datos. ");
} catch (MessagingException e) {
e.printStackTrace();
}
}

private void sendConfirmation(String to, String enquesta, String ambit, String estudi) {
try {
this.ems.sendMail(to, "[SYS] Nuevos datos importados", "Estimado/a usuario: \n"
+ "\n"
+ "Se han importado correctamente nuevos datos referentes a: \n"
+ "Origen: "+enquesta+"\n"
+ "Ámbito: "+ambit+"\n"
+ "Tipo titulación: "+estudi+"\n"
+ "\n"
+ "Los datos se quedarán en estado pendiente de consolidar hasta que un administrador inicie el proceso de consolidación.");
} catch (MessagingException e) {
e.printStackTrace();
}
}

/* Exepciones en el código de titulación que hay que traducir a código SAIC */

translateTitulacio() — ⚪ Interno

/* Exepciones en el código de centro que hay que traducir a código SAIC */

translateCentre() — ⚪ Interno

🧩 Clase: `DatasourceService`

Ubicación: src\main\java\es\uv\saic\service\DatasourceService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findById() — ⚪ Interno

🧩 Clase: `DocumentService`

Ubicación: src\main\java\es\uv\saic\service\DocumentService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

getAll() — ⚪ Interno
findById() — ⚪ Interno
findAllByCategoriaOrgan() — ⚪ Interno
findByCategoriaOrgan() — ⚪ Interno
findByCategoriaNom() — ⚪ Interno
findByCategoriaTipus() — ⚪ Interno
archive() — ⚪ Interno
archiveByOrgan() — ⚪ Interno
exists() — ⚪ Interno
save() — ⚪ Interno
delete() — ⚪ Interno
upload() — ⚪ Interno
File() — ⚪ Interno

🧩 Clase: `EmailService`

Ubicación: src\main\java\es\uv\saic\service\EmailService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

EmailService() — ⚪ Interno
sendActiveTaskNext() — ⚪ Interno
addEmail() — ⚪ Interno
getNextEmail() — ⚪ Interno
getPendingQueue() — ⚪ Interno
pendingQueueIsEmpty() — ⚪ Interno
sendMail() — ⚪ Interno
SimpleMailMessage() — ⚪ Interno
sendNewTaskMail() — ⚪ Interno

Qualitat() — ⚪ Interno

//saic.uv.es per a accedir al Sistema d'Assegurament Intern de l

Qualitat() — ⚪ Interno

Calidad() — ⚪ Interno

//saic.uv.es para acceder al Sistema de Aseguramiento Interno de l

Calidad() — ⚪ Interno
sendCalendarMail() — ⚪ Interno
SimpleDateFormat() — ⚪ Interno

🧩 Clase: `EvidenciaIndicadorEnquestaService`

Ubicación: src\main\java\es\uv\saic\service\EvidenciaIndicadorEnquestaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

getIndicadors() — ⚪ Interno
getByProcesEvidencia() — ⚪ Interno
getAll() — ⚪ Interno
removeByProcesEvidencia() — ⚪ Interno
save() — ⚪ Interno

🧩 Clase: `GraficaService`

Ubicación: src\main\java\es\uv\saic\service\GraficaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findLikeAmbit() — ⚪ Interno
findLikeAmbitAndEstudi() — ⚪ Interno

🧩 Clase: `IndicadorEnquestaService`

Ubicación: src\main\java\es\uv\saic\service\IndicadorEnquestaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findTypes() — ⚪ Interno
findByEnquestaCursAmbitEstudi() — ⚪ Interno
findByEnquestaCursAmbitEstudiCentre() — ⚪ Interno
findByEnquestaCursAmbitEstudiCentreTitulacio() — ⚪ Interno
getAssociatedInds() — ⚪ Interno
getAllInds() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
getAllInds() — ⚪ Interno
getGraphData() — ⚪ Interno
getGraphData() — ⚪ Interno
contains() — ⚪ Interno
deleteCentroNoAdscrito() — ⚪ Interno
deleteByEnquesta() — ⚪ Interno
deleteByEnquestaCurs() — ⚪ Interno
fixBiennials() — ⚪ Interno
consolidateByEnquesta() — ⚪ Interno
deleteAll() — ⚪ Interno
save() — ⚪ Interno
saveAll() — ⚪ Interno

🧩 Clase: `IndicadorEnquestaTmpService`

Ubicación: src\main\java\es\uv\saic\service\IndicadorEnquestaTmpService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findByEnquestaCursAmbitEstudi() — ⚪ Interno
deleteByEnquesta() — ⚪ Interno
deleteByEnquestaCursAmbitEstudi() — ⚪ Interno
checkDuplicates() — ⚪ Interno
deleteFromCurrent() — ⚪ Interno
deleteFromPending() — ⚪ Interno
deleteDuplicates() — ⚪ Interno
countByEnquesta() — ⚪ Interno
checkIntegrity() — ⚪ Interno
deleteAll() — ⚪ Interno
save() — ⚪ Interno
saveAll() — ⚪ Interno

🧩 Clase: `IndicadorService`

Ubicación: src\main\java\es\uv\saic\service\IndicadorService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

IndicadorService() — ⚪ Interno
getFromTitulacion() — ⚪ Interno
URL() — ⚪ Interno
String() — ⚪ Interno
extract() — ⚪ Interno
InputSource() — ⚪ Interno
```
// has subin
```
for() — ⚪ Interno
Indicador() — ⚪ Interno
if() — ⚪ Interno
Indicador() — ⚪ Interno
if() — ⚪ Interno
getGraphData() — ⚪ Interno
URL() — ⚪ Interno
String() — ⚪ Interno
extractAll() — ⚪ Interno
InputSource() — ⚪ Interno
```
// has subin
```
for() — ⚪ Interno
Indicador() — ⚪ Interno
Indicador() — ⚪ Interno

🧩 Clase: `InformeService`

Ubicación: src\main\java\es\uv\saic\service\InformeService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findByGrupWeb() — ⚪ Interno
findByGrupWebTambit() — ⚪ Interno
findById() — ⚪ Interno

🧩 Clase: `InstanciaService`

Ubicación: src\main\java\es\uv\saic\service\InstanciaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findByID() — ⚪ Interno
getReportFromInstancia() — ⚪ Interno
filterSupervisables() — ⚪ Interno
filterSupervisable() — ⚪ Interno
filterSupervisablesByEvidencies() — ⚪ Interno
save() — ⚪ Interno
findAll() — ⚪ Interno
findAllIds() — ⚪ Interno
findByOrganCursNom() — ⚪ Interno
findByCentreCursNom() — ⚪ Interno
findByIdProces() — ⚪ Interno
findByOrganBetweenCurs() — ⚪ Interno
exists() — ⚪ Interno
exists() — ⚪ Interno
instantiateT() — ⚪ Interno
BigInteger() — ⚪ Interno
instantiateC() — ⚪ Interno
BigInteger() — ⚪ Interno
instantiateU() — ⚪ Interno
BigInteger() — ⚪ Interno
deleteInstance() — ⚪ Interno
clearInstance() — ⚪ Interno

🧩 Clase: `InstanciaTascaService`

Ubicación: src\main\java\es\uv\saic\service\InstanciaTascaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findByInstancia() — ⚪ Interno
findByInstanciaTascap() — ⚪ Interno
findOlderVersions() — ⚪ Interno
TascaVersioTransfer() — ⚪ Interno
findActiveByInstancia() — ⚪ Interno
findActivesByType() — ⚪ Interno
isUserAuthorized() — ⚪ Interno
if() — ⚪ Interno
getReportFromProcesOrgan() — ⚪ Interno
getReportFromNomProcesOrgan() — ⚪ Interno
system() — ⚪ Interno
ProcessBuilder() — ⚪ Interno
ProcessBuilder() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
ProcessBuilder() — ⚪ Interno
if() — ⚪ Interno
File() — ⚪ Interno
File() — ⚪ Interno
if() — ⚪ Interno
saveChanges() — ⚪ Interno
Date() — ⚪ Interno
if() — ⚪ Interno
Date() — ⚪ Interno
InstanciaTasca() — ⚪ Interno
Date() — ⚪ Interno
BigInteger() — ⚪ Interno
Email() — ⚪ Interno
findOlderByProces() — ⚪ Interno
EvidenciaTransfer() — ⚪ Interno
findById() — ⚪ Interno
getPastTasks() — ⚪ Interno
getNext() — ⚪ Interno
getUsers() — ⚪ Interno
getLastByProcName() — ⚪ Interno
deactivateAll() — ⚪ Interno
remove() — ⚪ Interno
removeAllVersions() — ⚪ Interno
save() — ⚪ Interno

🧩 Clase: `InstanciaTascaVerService`

Ubicación: src\main\java\es\uv\saic\service\InstanciaTascaVerService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findById() — ⚪ Interno
findByIdInstanciaTasca() — ⚪ Interno
save() — ⚪ Interno
delete() — ⚪ Interno
deleteByIdInstancia() — ⚪ Interno

🧩 Clase: `LinkService`

Ubicación: src\main\java\es\uv\saic\service\LinkService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findById() — ⚪ Interno
findByToken() — ⚪ Interno
findByRuct() — ⚪ Interno
increase() — ⚪ Interno
save() — ⚪ Interno
delete() — ⚪ Interno

🧩 Clase: `NoticiaService`

Ubicación: src\main\java\es\uv\saic\service\NoticiaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findVisibles() — ⚪ Interno

🧩 Clase: `OrganService`

Ubicación: src\main\java\es\uv\saic\service\OrganService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findByID() — ⚪ Interno
findByRuct() — ⚪ Interno
exists() — ⚪ Interno
findAll() — ⚪ Interno
findCurrentCentres() — ⚪ Interno
findTitulacionsByCentre() — ⚪ Interno
getTitulacions() — ⚪ Interno
getCentres() — ⚪ Interno
getActiveCentres() — ⚪ Interno
getTitulacionsByCentre() — ⚪ Interno
getUsuariTitulacions() — ⚪ Interno
getUsuariCentres() — ⚪ Interno
getTitulacionsByCentres() — ⚪ Interno
getTitulacionsByTypeCentre() — ⚪ Interno
findActiveTitulacionsByCentreTambit() — ⚪ Interno
getEquivalents() — ⚪ Interno

🧩 Clase: `ParserService`

Ubicación: src\main\java\es\uv\saic\service\ParserService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

ParserService() — ⚪ Interno
doParse() — ⚪ Interno
parseOtros() — ⚪ Interno
parsePas() — ⚪ Interno
parseEvalProf() — ⚪ Interno
parseGrauFromUqServer() — ⚪ Interno
parseMasterFromUqServer() — ⚪ Interno
parseDoctorado() — ⚪ Interno
execute() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
IndicadorEnquesta() — ⚪ Interno
if() — ⚪ Interno
executeRows() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
IndicadorEnquesta() — ⚪ Interno
if() — ⚪ Interno
translate() — ⚪ Interno
parseGrauDades1er() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
parseGrauDades3er() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
parseGrauDadesGraduats() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
parseGrauProfes() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
parseDadesPas() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
parseMasterData() — ⚪ Interno

CONCAT() — ⚪ Interno

/*+ "AND a.TIT NOT IN(SELECT DISTINCT(TIT) FROM MDB_master.Mitjanes_final_codigeneric) "
+ "UNION "
+ "SELECT 'data' AS enquesta, b.tit AS tit, c.cmostrar AS centre, CONCAT('20', RIGHT(ACURS, 2)) AS curs, null AS cursd, 'T' AS ambit, 'm' AS estudi, "
+ "IT01 AS it01, IT02 AS it02, IT03 AS it03, IT04 AS it04, IT05 AS it05, IT06 AS it06, "
+ "IT07 AS it07, IT08 AS it08, IT09 AS it09, IT10 AS it10, IT11 AS it11, IT12 AS it12, "
+ "IT13 AS it13, IT14 AS it14, IT15 AS it15, IT16 AS it16, IT17 AS it17, IT18 AS it18, "
+ "IT19 AS it19, IT21 AS it21, IT22 AS it22, IT23 AS it23, IT24 AS it24, IT25 AS it25, "
+ "IT26 AS it26, IT27 AS it27, IT28 AS it28, IT29 AS it29, IT30 AS it30, IT30 AS it30, "
+ "IT31 AS it31, IT32 AS it32, IT33 AS it33, G_satis AS g_satis, G_RelQP AS g_relqp, "
+ "G_QProf AS g_qprof, G_Postg AS g_postg, G_Interes AS g_interes, G_Util AS g_util, gcovidm AS gcovid "
+ "FROM MDB_master.Mitjanes_final_codigeneric a "
+ "LEFT JOIN MDB_master.ESTUDIS b ON a.tit = b.tit "
+ "LEFT JOIN MDB_master.Centre c ON b.centre = c.centre "
+ "WHERE Total >= 3 AND CONCAT('20', RIGHT(ACURS, 2)) >= "+year+";",*/

"SELECT 'data' AS enquesta, NULL AS tit, b.cmostrar AS centre, CONCAT('20', RIGHT(ACURS, 2)) AS curs, null AS cursd, 'C' AS ambit, 'm' AS estudi, "
+ "IT01 AS it01, IT02 AS it02, IT03 AS it03, IT04 AS it04, IT05 AS it05, IT06 AS it06, "
+ "IT07 AS it07, IT08 AS it08, IT09 AS it09, IT10 AS it10, IT11 AS it11, IT12 AS it12, IT13 AS it13, "
+ "IT14 AS it14, IT15 AS it15, IT16 AS it16, IT17 AS it17, IT18 AS it18, IT19 AS it19, "
+ "IT21 AS it21, IT22 AS it22, IT23 AS it23, IT24 AS it24, IT25 AS it25, IT26 AS it26, "
+ "IT27 AS it27, IT28 AS it28, IT29 AS it29, IT30 AS it30, IT30 AS it30, IT31 AS it31, "
+ "IT32 AS it32, IT33 AS it33, G_satis AS g_satis, G_RelQP AS g_relqp, G_QProf AS g_qprof, "
+ "G_Postg AS g_postg, G_Interes AS g_interes, G_Util AS g_util "
+ "FROM MDB_master.Mitjanes_final_xcentre a "
+ "LEFT JOIN MDB_master.Centre b ON a.centre = b.centre WHERE CONCAT('20', RIGHT(ACURS, 2)) >= "+year+";",

"SELECT 'data' AS enquesta, NULL AS tit, NULL AS centre, CONCAT('20', RIGHT(ACURS, 2)) AS curs, null AS cursd, 'U' AS ambit, 'm' AS estudi, "
+ "IT01 AS it01, IT02 AS it02, IT03 AS it03, IT04 AS it04, IT05 AS it05, IT06 AS it06, "
+ "IT07 AS it07, IT08 AS it08, IT09 AS it09, IT10 AS it10, IT11 AS it11, IT12 AS it12, IT13 AS it13, "
+ "IT14 AS it14, IT15 AS it15, IT16 AS it16, IT17 AS it17, IT18 AS it18, IT19 AS it19, "
+ "IT21 AS it21, IT22 AS it22, IT23 AS it23, IT24 AS it24, IT25 AS it25, IT26 AS it26, "
+ "IT27 AS it27, IT28 AS it28, IT29 AS it29, IT30 AS it30, IT30 AS it30, IT31 AS it31, "
+ "IT32 AS it32, IT33 AS it33, G_satis AS g_satis, G_RelQP AS g_relqp, G_QProf AS g_qprof, "
+ "G_Postg AS g_postg, G_Interes AS g_interes, G_Util AS g_util "
+ "FROM MDB_master.Mitjanes_final_global "
+ "WHERE CONCAT('20', RIGHT(ACURS, 2)) >= "+year+";",

"SELECT 'data' AS enquesta, NULL AS tit, b.cmostrar AS centre, CONCAT('20', RIGHT(ACURS, 2)) AS curs, null AS cursd, 'C' AS ambit, 'm' AS estudi, "
+ "max_it13m AS it13_max, min_it13m AS it13_min, max_it14m AS it14_max, min_it14m AS it14_min, "
+ "max_it15m AS it15_max, min_it15m AS it15_min, max_it16m AS it16_max, min_it16m AS it16_min, "
+ "max_it17m AS it17_max, min_it17m AS it17_min "
+ "FROM MDB_master.MinMax_final_xcentre a "
+ "LEFT JOIN MDB_master.Centre b ON a.centre = b.centre WHERE CONCAT('20', RIGHT(ACURS, 2)) >= "+year+";"};

return this.execute(statement, queries);
}

private int parseMasterDataG(Connection connection, String year) throws SQLException {

Statement statement = connection.createStatement();
String[] queries = {
"SELECT 'data_g' AS enquesta, b.tit AS tit, c.cmostrar AS centre, CONCAT('20', RIGHT(cursf, 2)) AS curs, null AS cursd, 'T' AS ambit, 'm' AS estudi, "
+ "IT01m_pf AS it01_pf, IT02m_pf AS it02_pf, IT03m_pf AS it03_pf, IT04m_comp AS it04_comp, "
+ "IT04m_comp AS it05_comp, IT06m_comp AS it06_comp, IT07m_comp AS it07_comp, "
+ "IT08m_comp AS it08_comp, IT09m_comp AS it09_comp, IT10m_comp AS it10_comp, "
+ "IT11m_de AS it11_de, IT12m_de AS it12_de, IT13m_de AS it13_de, IT14m_de AS it14_de, "
+ "IT15m_de AS it15_de, IT16m_de AS it16_de, (IT17_pe_S/(IT17_pe_S+IT17_pe_N))*100 AS it17_pe, "
+ "IT18m_pe AS it18_pe, IT19m_pe AS it19_pe, IT20m_pe AS it20_pe, IT21m_pe AS it21_pe, "
+ "IT22m_pe AS it22_pe, IT23m_pe AS it23_pe, (IT24_mob_S/(IT24_mob_S+IT24_mob_N))*100 AS it24_mob, "
+ "IT25_mob1 AS it25_mob1, IT25_mob2 AS it25_mob2, IT25_mob3 AS it25_mob3, IT25_mob4 AS it25_mob4, "
+ "IT26m_mob AS it26_mob, IT27m_mob AS it27_mob, IT28m_mob AS it28_mob, IT29m_mob AS it29_mob, "
+ "IT30m_mob AS it30_mob, IT26m_mob AS it26_mob, IT31m_mob AS it31_mob, IT32m_mob AS it32_mob, "
+ "IT33m_mob AS it33_mob, IT34m_tfm AS it34_tfm, IT35m_tfm AS it35_tfm, IT36m_tfm AS it36_tfm, "
+ "IT37m_tfm AS it37_tfm, IT38m_tfm AS it38_tfm, IT40m_treb AS it40_treb, IT41m_treb AS it41_treb, "
+ "IT41m_treb AS it41_treb, IT42m_treb AS it42_treb, IT43m_treb AS it43_treb, gm_Qprof AS g_qprof, "
+ "gm_instal AS g_instal, gm_exp AS g_exp, gm_recomana AS g_recomana "
+ "FROM MDB_master.Mitjanes_Gxtitcursf a "
+ "LEFT JOIN MDB_master.ESTUDIS b ON a.tit = b.tit "
+ "LEFT JOIN MDB_master.Centre c ON b.centre = c.centre WHERE CONCAT('20', RIGHT(cursf, 2)) >= "+year+";",

"SELECT 'data_g' AS enquesta, NULL AS tit, b.cmostrar AS centre, CONCAT('20', RIGHT(cursf, 2)) AS curs, null AS cursd, 'C' AS ambit, 'm' AS estudi, "
+ "IT01m_pf AS it01_pf, IT02m_pf AS it02_pf, IT03m_pf AS it03_pf, IT04m_comp AS it04_comp, "
+ "IT04m_comp AS it05_comp, IT06m_comp AS it06_comp, IT07m_comp AS it07_comp, "
+ "IT08m_comp AS it08_comp, IT09m_comp AS it09_comp, IT10m_comp AS it10_comp, "
+ "IT11m_de AS it11_de, IT12m_de AS it12_de, IT13m_de AS it13_de, IT14m_de AS it14_de, "
+ "IT15m_de AS it15_de, IT16m_de AS it16_de, (IT17_pe_S/(IT17_pe_S+IT17_pe_N))*100 AS it17_pe, "
+ "IT18m_pe AS it18_pe, IT19m_pe AS it19_pe, IT20m_pe AS it20_pe, IT21m_pe AS it21_pe, "
+ "IT22m_pe AS it22_pe, IT23m_pe AS it23_pe, (IT24_mob_S/(IT24_mob_S+IT24_mob_N))*100 AS it24_mob, "
+ "IT25_mob1 AS it25_mob1, IT25_mob2 AS it25_mob2, IT25_mob3 AS it25_mob3, IT25_mob4 AS it25_mob4, "
+ "IT26m_mob AS it26_mob, IT27m_mob AS it27_mob, IT28m_mob AS it28_mob, IT29m_mob AS it29_mob, "
+ "IT30m_mob AS it30_mob, IT26m_mob AS it26_mob, IT31m_mob AS it31_mob, IT32m_mob AS it32_mob, "
+ "IT33m_mob AS it33_mob, IT34m_tfm AS it34_tfm, IT35m_tfm AS it35_tfm, IT36m_tfm AS it36_tfm, "
+ "IT37m_tfm AS it37_tfm, IT38m_tfm AS it38_tfm, IT40m_treb AS it40_treb, IT41m_treb AS it41_treb, "
+ "IT41m_treb AS it41_treb, IT42m_treb AS it42_treb, IT43m_treb AS it43_treb, gm_Qprof AS g_qprof, "
+ "gm_instal AS g_instal, gm_exp AS g_exp, gm_recomana AS g_recomana "
+ "FROM MDB_master.Mitjanes_Gxcentrecursf a "
+ "LEFT JOIN MDB_master.Centre b ON a.centre = b.centre WHERE CONCAT('20', RIGHT(cursf, 2)) >= "+year+";",

"SELECT 'data_g' AS enquesta, NULL AS tit, NULL AS centre, CONCAT('20', RIGHT(cursf, 2)) AS curs, null AS cursd, 'U' AS ambit, 'm' AS estudi, "
+ "IT01m_pf AS it01_pf, IT02m_pf AS it02_pf, IT03m_pf AS it03_pf, IT04m_comp AS it04_comp, "
+ "IT04m_comp AS it05_comp, IT06m_comp AS it06_comp, IT07m_comp AS it07_comp, "
+ "IT08m_comp AS it08_comp, IT09m_comp AS it09_comp, IT10m_comp AS it10_comp, "
+ "IT11m_de AS it11_de, IT12m_de AS it12_de, IT13m_de AS it13_de, IT14m_de AS it14_de, "
+ "IT15m_de AS it15_de, IT16m_de AS it16_de, (IT17_pe_S/(IT17_pe_S+IT17_pe_N))*100 AS it17_pe, "
+ "IT18m_pe AS it18_pe, IT19m_pe AS it19_pe, IT20m_pe AS it20_pe, IT21m_pe AS it21_pe, "
+ "IT22m_pe AS it22_pe, IT23m_pe AS it23_pe, (IT24_mob_S/(IT24_mob_S+IT24_mob_N))*100 AS it24_mob, "
+ "IT25_mob1 AS it25_mob1, IT25_mob2 AS it25_mob2, IT25_mob3 AS it25_mob3, IT25_mob4 AS it25_mob4, "
+ "IT26m_mob AS it26_mob, IT27m_mob AS it27_mob, IT28m_mob AS it28_mob, IT29m_mob AS it29_mob, "
+ "IT30m_mob AS it30_mob, IT26m_mob AS it26_mob, IT31m_mob AS it31_mob, IT32m_mob AS it32_mob, "
+ "IT33m_mob AS it33_mob, IT34m_tfm AS it34_tfm, IT35m_tfm AS it35_tfm, IT36m_tfm AS it36_tfm, "
+ "IT37m_tfm AS it37_tfm, IT38m_tfm AS it38_tfm, IT40m_treb AS it40_treb, IT41m_treb AS it41_treb, "
+ "IT41m_treb AS it41_treb, IT42m_treb AS it42_treb, IT43m_treb AS it43_treb, gm_Qprof AS g_qprof, "
+ "gm_instal AS g_instal, gm_exp AS g_exp, gm_recomana AS g_recomana "
+ "FROM MDB_master.Mitjanes_Gxcursf WHERE CONCAT('20', RIGHT(cursf, 2)) >= "+year+";",

"SELECT 'data_g' AS enquesta, NULL AS tit, b.cmostrar AS centre, CONCAT('20', RIGHT(cursf, 2)) AS curs, null AS cursd, 'C' AS ambit, 'm' AS estudi, "
+ "max_IT26m_mob AS it26_mob_max, min_IT26m_mob AS it26_mob_min, "
+ "max_IT27m_mob AS it27_mob_max, min_IT27m_mob AS it27_mob_min, "
+ "max_IT28m_mob AS it28_mob_max, min_IT28m_mob AS it28_mob_min, "
+ "max_IT29m_mob AS it29_mob_max, min_IT29m_mob AS it29_mob_min, "
+ "max_IT30m_mob AS it30_mob_max, min_IT30m_mob AS it30_mob_min, "
+ "max_IT31m_mob AS it31_mob_max, min_IT31m_mob AS it31_mob_min, "
+ "max_IT32m_mob AS it32_mob_max, min_IT32m_mob AS it32_mob_min, "
+ "max_IT33m_mob AS it33_mob_max, min_IT33m_mob AS it33_mob_min, "
+ "max_gm_instal AS g_instal_max, min_gm_instal AS g_instal_min "
+ "FROM MDB_master.MinMax_Gxcursfcentre a "
+ "LEFT JOIN MDB_master.Centre b ON a.centre = b.centre WHERE CONCAT('20', RIGHT(cursf, 2)) >= "+year+";"
};

return this.execute(statement, queries);
}

private int parseMasterProfes(Connection connection, String year) throws SQLException {

Statement statement = connection.createStatement();
String[] queries = {
"SELECT 'profes_tancades' AS enquesta, b.tit AS tit, c.cmostrar AS centre, CONCAT('20', RIGHT(ACURS, 2)) AS curs, null AS cursd, 'T' AS ambit, 'm' AS estudi, "
+ "A1 AS a1, A2 AS a2, A3 AS a3, A4 AS a4, A5 AS a5, A6 AS a6, A7 AS a7, A8 AS a8, A9 AS a9, A10 AS a10, "
+ "A11 AS a11, A12 as a12, A13 AS a13, A14 AS a14, A15_1 AS a15_1, A15_2 AS a15_2, A15_3 AS a15_3, "
+ "A15_4 AS a15_4, A15_5 AS a15_5, A16 AS a16, A17 AS a17, A18 AS a18, A19 AS a19, A20 AS a20, "
+ "A21 AS a21, A26 AS a26, A27 AS a27, A28 AS a28, A29 AS a29, A30 AS a30, A31 AS a31, A32 AS a32 "
+ "FROM MDB_master.Mitjanes_profesXtit a "
+ "LEFT JOIN MDB_master.ESTUDIS b ON a.tit = b.tit "
+ "LEFT JOIN MDB_master.Centre c ON b.centre = c.centre WHERE CONCAT('20', RIGHT(ACURS, 2)) >= "+year+";",

"SELECT 'profes_tancades' AS enquesta, NULL AS tit, c.cmostrar AS centre, CONCAT('20', RIGHT(ACURS, 2)) AS curs, null AS cursd, 'C' AS ambit, 'm' AS estudi, "
+ "A1 AS a1, A2 AS a2, A3 AS a3, A4 AS a4, A5 AS a5, A6 AS a6, A7 AS a7, A8 AS a8, A9 AS a9, A10 AS a10, "
+ "A11 AS a11, A12 as a12, A13 AS a13, A14 AS a14, A15_1 AS a15_1, A15_2 AS a15_2, A15_3 AS a15_3, "
+ "A15_4 AS a15_4, A15_5 AS a15_5, A16 AS a16, A17 AS a17, A18 AS a18, A19 AS a19, A20 AS a20, "
+ "A21 AS a21, A26 AS a26, A27 AS a27, A28 AS a28, A29 AS a29, A30 AS a30, A31 AS a31, A32 AS a32 "
+ "FROM MDB_master.Mitjanes_profesxCurscentre a "
+ "LEFT JOIN MDB_master.periodesCurs p ON p.curs = CONCAT('20', RIGHT(ACURS, 2)) "
+ "LEFT JOIN MDB_master.Centre c ON a.centre = c.centre WHERE p.ProfesComplet = 1 AND CONCAT('20', RIGHT(ACURS, 2)) >= "+year+";",

"SELECT 'profes_tancades' AS enquesta, NULL AS tit, NULL AS centre, CONCAT('20', RIGHT(ACURS, 2)) AS curs, null AS cursd, 'U' AS ambit, 'm' AS estudi,"
+ "A1 AS a1, A2 AS a2, A3 AS a3, A4 AS a4, A5 AS a5, A6 AS a6, A7 AS a7, A8 AS a8, A9 AS a9, A10 AS a10, "
+ "A11 AS a11, A12 as a12, A13 AS a13, A14 AS a14, A15_1 AS a15_1, A15_2 AS a15_2, A15_3 AS a15_3, "
+ "A15_4 AS a15_4, A15_5 AS a15_5, A16 AS a16, A17 AS a17, A18 AS a18, A19 AS a19, A20 AS a20, "
+ "A21 AS a21, A26 AS a26, A27 AS a27, A28 AS a28, A29 AS a29, A30 AS a30, A31 AS a31, A32 AS a32 "
+ "FROM MDB_master.Mitjanes_profesxCurs a"
+ "LEFT JOIN MDB_master.periodesCurs p ON p.curs = CONCAT('20', RIGHT(ACURS, 2)) "
+ "WHERE p.ProfesComplet = 1 AND CONCAT('20', RIGHT(ACURS, 2)) >= "+year+";",

"SELECT 'profes_tancades' AS enquesta, NULL AS tit, c.cmostrar AS centre, CONCAT('20', RIGHT(ACURS, 2)) AS curs, null AS cursd, 'C' AS ambit, 'm' AS estudi, "
+ "max_A16m AS a16_max, min_A16m AS a16_min, max_A17m AS a17_max, min_A17m AS a17_min, "
+ "max_A19m AS a19_max, min_A19m AS a19_min "
+ "FROM MDB_master.MinMax_profesxCurscentre a "
+ "LEFT JOIN MDB_master.periodesCurs p ON p.curs = CONCAT('20', RIGHT(ACURS, 2)) "
+ "LEFT JOIN MDB_master.Centre c ON a.centre = c.centre WHERE p.ProfesComplet = 1 AND CONCAT('20', RIGHT(ACURS, 2)) >= "+year+";"};

return this.execute(statement, queries);
}


private int parseEvalProfBD(Connection connection, String year) throws SQLException {
 
Statement statement = connection.createStatement();
String[] queries = {
"SELECT 'evalprof' AS enquesta, t.cod_titula AS tit, c.cod_actual AS centre, CONCAT('20', anyo) AS curs, null AS cursd, 'T' AS ambit, tipus AS estudi, "
+ "it01, it02, it03, it04, it05, it06, it07, it08, it09, it10, it11, it12, it13, it14, b1, b2, b3, b4, b5, b6, global "
+ "FROM MDB_evalProf.MediasTitulacion m "
+ "LEFT JOIN MDB_evalProf.Titulaciones t ON m.estudio = t.estudio "
+ "LEFT JOIN MDB_evalProf.Centros c ON t.cod_centro = c.cod_centro "
+ "WHERE c.cod_actual IS NOT NULL AND c.cod_actual <> '' AND num_encues >= 3 AND CONCAT('20', anyo) >= "+year+"; ",

"SELECT 'evalprof' AS enquesta, NULL AS tit, c.cod_actual AS centre, CONCAT('20', anyo) AS curs, null AS cursd, 'C' AS ambit, tipus AS estudi, "
+ "it01, it02, it03, it04, it05, it06, it07, it08, it09, it10, it11, it12, it13, it14, b1, b2, b3, b4, b5, b6, global "
+ "FROM MDB_evalProf.MediasCentro m "
+ "LEFT JOIN MDB_evalProf.Centros c ON m.centre = c.cod_centro "
+ "LEFT JOIN MDB_master.periodesCurs p ON p.curs = CONCAT('20', anyo) "
+ "WHERE c.cod_actual IS NOT NULL AND c.cod_actual <> '' AND CONCAT('20', anyo) >= "+year+"; ",

"SELECT 'evalprof' AS enquesta, NULL AS tit, NULL AS centre, CONCAT('20', anyo) AS curs, null AS cursd, 'U' AS ambit, tipus AS estudi, "
+ "it01, it02, it03, it04, it05, it06, it07, it08, it09, it10, it11, it12, it13, it14, b1, b2, b3, b4, b5, b6, global "
+ "FROM MDB_evalProf.MediasUniversidad "
+ "LEFT JOIN MDB_master.periodesCurs p ON p.curs = CONCAT('20', anyo) "
+ "WHERE CONCAT('20', anyo) >= "+year+"; "};

return this.execute(statement, queries);

}

private int parseOtrosProfes(Connection connection) throws SQLException {
 
Statement statement = connection.createStatement();
String[] queries = {
"SELECT 'otros' AS enquesta, t.cod_titula AS tit, c.cod_actual AS centre, curs, null AS cursd, ambit, estudi, "
+ "I_RH2_06, I_RH2_07, I_RH2_08, I_RH2_profcursos, I_RH2_totpdi "
+ "FROM MDB_otros.profesorado m "
+ "LEFT JOIN MDB_evalProf.Titulaciones t ON m.titulacion = t.estudio "
+ "LEFT JOIN MDB_evalProf.Centros c ON t.cod_centro = c.cod_centro "
+ "WHERE c.cod_actual IS NOT NULL AND c.cod_actual <> '';"};

return this.execute(statement, queries);

}

private int parseOtrosEncuestas(Connection connection) throws SQLException {
 
Statement statement = connection.createStatement();
String[] queries = {
"SELECT 'enquestes' AS enquesta, titulacio AS tit, centre, curs, null AS cursd, ambit, estudi, "
+ "1er_modul_cod, 1er_modul_nom, 1er_modul_obs, 3er_modul_cod, 3er_modul_nom, 3er_modul_obs "
+ "FROM MDB_otros.asignaturas_encuestas;"};

return this.execute(statement, queries);

}

private int parseOtrosTasas(Connection connection) throws SQLException {
 
Statement statement = connection.createStatement();
String[] queries = {
"SELECT 'otros' AS enquesta, t.cod_titula AS tit, c.cod_actual AS centre, curs, null AS cursd, ambit, estudi, "
+ "i_oe1_nb_nuevos, i_oe1_nb_plazas, i_oe1_tasa_mat, i_oe1_tasa_ofedem "
+ "FROM MDB_otros.tasas m "
+ "LEFT JOIN MDB_evalProf.Titulaciones t ON m.titulacion = t.estudio "
+ "LEFT JOIN MDB_evalProf.Centros c ON t.cod_centro = c.cod_centro "
+ "WHERE c.cod_actual IS NOT NULL AND c.cod_actual <> '';"};

return this.execute(statement, queries);

}

private int parseOtrosDocentia(Connection connection) throws SQLException {
 
Statement statement = connection.createStatement();
String[] queries = {
"SELECT *  "
+ "FROM MDB_otros.docentia_evaluacion "
+ "WHERE centre IS NOT NULL;"};

return this.execute(statement, queries);

}

/* ToDo */

parseDocEstud() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
parseDocEtesi() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
parseDocProf() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
CONCAT() — ⚪ Interno
parseDocTasas() — ⚪ Interno
parseDocInds() — ⚪ Interno
parseDocRecom() — ⚪ Interno
LOWER() — ⚪ Interno
doAction() — ⚪ Interno
precargaEvalProf() — ⚪ Interno
CAST() — ⚪ Interno
CAST() — ⚪ Interno
CAST() — ⚪ Interno
precargaMaster() — ⚪ Interno
precargaDoctorado() — ⚪ Interno

🧩 Clase: `PlantillaService`

Ubicación: src\main\java\es\uv\saic\service\PlantillaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

DecimalFormat() — ⚪ Interno
findAll() — ⚪ Interno
findByID() — ⚪ Interno
findByVersioCodiAmbit() — ⚪ Interno
save() — ⚪ Interno
delete() — ⚪ Interno
isUsed() — ⚪ Interno
addTemplateData() — ⚪ Interno
data() — ⚪ Interno
addTemplateData() — ⚪ Interno
data() — ⚪ Interno
addHeaderData() — ⚪ Interno
ClassPathResource() — ⚪ Interno
ClassPathResource() — ⚪ Interno
iterateLoopAttr() — ⚪ Interno
iterateLoopTag() — ⚪ Interno
replaceValues() — ⚪ Interno
if() — ⚪ Interno
Element() — ⚪ Interno
getTemplateData() — ⚪ Interno
replaceValuesLoop() — ⚪ Interno
formatValue() — ⚪ Interno
savePDF() — ⚪ Interno
File() — ⚪ Interno
PrintWriter() — ⚪ Interno
ProcessBuilder() — ⚪ Interno
toPDF() — ⚪ Interno
File() — ⚪ Interno
File() — ⚪ Interno
PrintWriter() — ⚪ Interno
ProcessBuilder() — ⚪ Interno
parseComments() — ⚪ Interno
String() — ⚪ Interno
ObjectMapper() — ⚪ Interno
replaceSection() — ⚪ Interno
extractTemplateAnchor() — ⚪ Interno
clear() — ⚪ Interno
asString() — ⚪ Interno
InputStreamReader() — ⚪ Interno
UncheckedIOException() — ⚪ Interno
readFileToString() — ⚪ Interno
DefaultResourceLoader() — ⚪ Interno
asString() — ⚪ Interno

🧩 Clase: `ProcesService`

Ubicación: src\main\java\es\uv\saic\service\ProcesService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findByID() — ⚪ Interno
findByName() — ⚪ Interno
findByNameCurs() — ⚪ Interno
getAll() — ⚪ Interno
getSupervisableCursos() — ⚪ Interno
getSupervisableProcedures() — ⚪ Interno
save() — ⚪ Interno
deleteById() — ⚪ Interno
delete() — ⚪ Interno
getFlowDiagram() — ⚪ Interno

🧩 Clase: `RolService`

Ubicación: src\main\java\es\uv\saic\service\RolService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findOne() — ⚪ Interno
findAssignables() — ⚪ Interno

🧩 Clase: `SysStatusService`

Ubicación: src\main\java\es\uv\saic\service\SysStatusService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findByType() — ⚪ Interno
log() — ⚪ Interno
SysStatus() — ⚪ Interno
Timestamp() — ⚪ Interno
err() — ⚪ Interno
SysStatus() — ⚪ Interno
Timestamp() — ⚪ Interno
warn() — ⚪ Interno
SysStatus() — ⚪ Interno
Timestamp() — ⚪ Interno
save() — ⚪ Interno

🧩 Clase: `TascaService`

Ubicación: src\main\java\es\uv\saic\service\TascaService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findByProces() — ⚪ Interno
getByID() — ⚪ Interno
getByProcesTascap() — ⚪ Interno
getAllEvidencies() — ⚪ Interno
getEvidenciesByCentreTitulacioCurs() — ⚪ Interno
getEvidencesByProcedure() — ⚪ Interno
getAllAvailableEvidences() — ⚪ Interno
create() — ⚪ Interno
save() — ⚪ Interno
deleteById() — ⚪ Interno
delete() — ⚪ Interno

🧩 Clase: `TipusService`

Ubicación: src\main\java\es\uv\saic\service\TipusService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findOne() — ⚪ Interno

🧩 Clase: `UsuariService`

Ubicación: src\main\java\es\uv\saic\service\UsuariService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
findByUsername() — ⚪ Interno
hasActiveRol() — ⚪ Interno
getActiveInstanciaTasques() — ⚪ Interno
getActiveInstancies() — ⚪ Interno
getSupervisableProcessos() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
if() — ⚪ Interno
```
// Role
```
especiales() — ⚪ Interno
getSupervisableCentres() — ⚪ Interno
getInstanceAsignedUsers() — ⚪ Interno
findByRolCentre() — ⚪ Interno
save() — ⚪ Interno

🧩 Clase: `UsuarisRolService`

Ubicación: src\main\java\es\uv\saic\service\UsuarisRolService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findAll() — ⚪ Interno
exists() — ⚪ Interno
find() — ⚪ Interno
findActive() — ⚪ Interno
findLast() — ⚪ Interno
findLastNum() — ⚪ Interno
hasActiveRol() — ⚪ Interno
findActiveRols() — ⚪ Interno
isGrantedUser() — ⚪ Interno
isGrantedSupervisor() — ⚪ Interno
isAdminUser() — ⚪ Interno
isDataTestUser() — ⚪ Interno
hasActiveRol() — ⚪ Interno
hasActiveRoles() — ⚪ Interno
hasActiveAmbit() — ⚪ Interno
hasAssociatedProcs() — ⚪ Interno
findAssociatedProcs() — ⚪ Interno
findManagerByCentre() — ⚪ Interno
findManagerByTitulacio() — ⚪ Interno
findManagerByCentres() — ⚪ Interno
findManagerByTitulacions() — ⚪ Interno
getSpecialRoles() — ⚪ Interno
save() — ⚪ Interno
delete() — ⚪ Interno

🧩 Clase: `WikiService`

Ubicación: src\main\java\es\uv\saic\service\WikiService.java Estado de revisión: ⚠️ Pendiente

🔍 Métodos detectados:

findByCategoria() — ⚪ Interno
save() — ⚪ Interno

📈 Estadísticas finales

Total de clases: 30
Total de métodos: 438
Total de comentarios: 8

✅ Fin del reporte de carpeta.

reporte_service.md 54 KB History Raw

📁 Reporte de carpeta: service

🧩 Clase: AcreditacioService

🔍 Métodos detectados:

🧩 Clase: AuthProvider

🔍 Métodos detectados:

🧩 Clase: CalendariService

🔍 Métodos detectados:

🧩 Clase: CategoriaService

🔍 Métodos detectados:

🧩 Clase: DataService

🔍 Métodos detectados:

🧩 Clase: DatasourceService

🔍 Métodos detectados:

🧩 Clase: DocumentService

🔍 Métodos detectados:

🧩 Clase: EmailService

🔍 Métodos detectados:

🧩 Clase: EvidenciaIndicadorEnquestaService

🔍 Métodos detectados:

🧩 Clase: GraficaService

🔍 Métodos detectados:

🧩 Clase: IndicadorEnquestaService

🔍 Métodos detectados:

🧩 Clase: IndicadorEnquestaTmpService

🔍 Métodos detectados:

🧩 Clase: IndicadorService

🔍 Métodos detectados:

🧩 Clase: InformeService

🔍 Métodos detectados:

🧩 Clase: InstanciaService

🔍 Métodos detectados:

🧩 Clase: InstanciaTascaService

🔍 Métodos detectados:

🧩 Clase: InstanciaTascaVerService

🔍 Métodos detectados:

🧩 Clase: LinkService

🔍 Métodos detectados:

🧩 Clase: NoticiaService

🔍 Métodos detectados:

🧩 Clase: OrganService

🔍 Métodos detectados:

🧩 Clase: ParserService

🔍 Métodos detectados:

🧩 Clase: PlantillaService

🔍 Métodos detectados:

🧩 Clase: ProcesService

🔍 Métodos detectados:

🧩 Clase: RolService

🔍 Métodos detectados:

🧩 Clase: SysStatusService

🔍 Métodos detectados:

🧩 Clase: TascaService

🔍 Métodos detectados:

🧩 Clase: TipusService

🔍 Métodos detectados:

🧩 Clase: UsuariService

🔍 Métodos detectados:

🧩 Clase: UsuarisRolService

🔍 Métodos detectados:

🧩 Clase: WikiService

🔍 Métodos detectados:

📈 Estadísticas finales

reporte_service.md 54 KB

History Raw

📁 Reporte de carpeta: `service`

🧩 Clase: `AcreditacioService`

🧩 Clase: `AuthProvider`

🧩 Clase: `CalendariService`

🧩 Clase: `CategoriaService`

🧩 Clase: `DataService`

🧩 Clase: `DatasourceService`

🧩 Clase: `DocumentService`

🧩 Clase: `EmailService`

🧩 Clase: `EvidenciaIndicadorEnquestaService`

🧩 Clase: `GraficaService`

🧩 Clase: `IndicadorEnquestaService`

🧩 Clase: `IndicadorEnquestaTmpService`

🧩 Clase: `IndicadorService`

🧩 Clase: `InformeService`

🧩 Clase: `InstanciaService`

🧩 Clase: `InstanciaTascaService`

🧩 Clase: `InstanciaTascaVerService`

🧩 Clase: `LinkService`

🧩 Clase: `NoticiaService`

🧩 Clase: `OrganService`

🧩 Clase: `ParserService`

🧩 Clase: `PlantillaService`

🧩 Clase: `ProcesService`

🧩 Clase: `RolService`

🧩 Clase: `SysStatusService`

🧩 Clase: `TascaService`

🧩 Clase: `TipusService`

🧩 Clase: `UsuariService`

🧩 Clase: `UsuarisRolService`

🧩 Clase: `WikiService`