public ArrayList datos_tiposubrespuesta() throws Exception {
Conexion co = new Conexion();
ArrayList lista = new ArrayList();
ResultSet rs =
co.listar(
"select c_codresp_mt, c_desresp_mt from tipo_respuesta_mt " + "where c_estregi='ACT'");
Gestion ges = new Gestion();
while (rs.next()) {
ges = new Gestion();
ges.setC_codresp_mt(rs.getString("c_codresp_mt"));
ges.setC_desresp_mt(rs.getString("c_desresp_mt"));
lista.add(ges);
}
return lista;
}
public ArrayList Respuesta_llam(String id_codtcon) throws Exception {
Conexion co = new Conexion();
ArrayList lista = new ArrayList();
ResultSet rs =
co.listar(
"select id_codtres,c_destres from tipo_respuesta "
+ "where c_codest='ACT' and id_codtcon like '"
+ id_codtcon
+ "' || '%'");
Gestion llm = new Gestion();
while (rs.next()) {
llm = new Gestion();
llm.setId_codtres(rs.getString("id_codtres"));
llm.setC_destres(rs.getString("c_destres"));
lista.add(llm);
}
return lista;
}
public ArrayList sub_respuesta_carta(String id_codrspta) throws Exception {
Conexion co = new Conexion();
ArrayList lista = new ArrayList();
ResultSet rs =
co.listar(
"SELECT id_codrspta_sub,c_desrspta_sub FROM rspta_carta "
+ "WHERE c_codest = 'ACT' and id_codrspta like '"
+ id_codrspta
+ "' || '%'");
Gestion ges = new Gestion();
while (rs.next()) {
ges = new Gestion();
ges.setId_codrspta_sub(rs.getString("id_codrspta_sub"));
ges.setC_desrspta_sub(rs.getString("c_desrspta_sub"));
lista.add(ges);
}
return lista;
}
public ArrayList datos_tiposubrespuesta(String id_codtcon, String id_codtres) throws Exception {
Conexion co = new Conexion();
ArrayList lista = new ArrayList();
ResultSet rs =
co.listar(
"SELECT id_codtres_sub,id_codtcon,id_codtres,c_destres_sub FROM tipo_subrspta"
+ " WHERE c_codest='ACT' and id_codtcon='"
+ id_codtcon
+ "' AND id_codtres='"
+ id_codtres
+ "'");
Gestion ges = new Gestion();
while (rs.next()) {
ges = new Gestion();
ges.setId_codrspta_sub(rs.getString("id_codtres_sub"));
ges.setC_desrspta_sub(rs.getString("c_destres_sub"));
lista.add(ges);
}
return lista;
}
public ArrayList gestion_llamada_quitar(
String f_fproceso, String id_codper, String id_codtcon, String id_codtres, String id_codusu)
throws Exception {
Conexion co = new Conexion();
ArrayList lista = new ArrayList();
String cadena =
" SELECT * FROM USP_QRY_GESTION_LLM_QUITAR('"
+ f_fproceso
+ "','"
+ id_codper
+ "','"
+ id_codtcon
+ "','"
+ id_codtres
+ "','"
+ id_codusu
+ "') ";
ResultSet rs = co.listar(cadena);
Gestion ges = new Gestion();
while (rs.next()) {
ges = new Gestion();
ges.setF_fproceso(rs.getString("f_fproceso"));
ges.setC_codcent(rs.getString("c_codcent"));
ges.setC_nrodoc(rs.getString("c_nrodoc"));
ges.setC_nombre(rs.getString("c_nombre"));
ges.setC_contrato(rs.getString("c_contrato"));
ges.setN_idxges(rs.getString("n_idxges"));
ges.setC_destcon(rs.getString("c_destcon"));
ges.setC_destres(rs.getString("c_destres"));
ges.setF_fecresp(rs.getString("f_fecresp"));
ges.setC_destres_sub(rs.getString("c_destres_sub"));
ges.setC_obsges(rs.getString("c_obsges"));
ges.setC_nomusu(rs.getString("c_nomusu"));
ges.setId_codusu(rs.getString("id_codusu"));
ges.setId_codtcon(rs.getString("id_codtcon"));
ges.setId_codtres(rs.getString("id_codtres"));
lista.add(ges);
}
return lista;
}
public ArrayList lista_gestion_contacto(
String id_codper, String c_nrodoc, String c_nombre, String id_codtges) throws Exception {
Conexion co = new Conexion();
ArrayList lista = new ArrayList();
ResultSet rs =
co.listar(
" select * from USP_QRY_GESTION_CONTACTO('"
+ id_codper
+ "','"
+ c_nrodoc
+ "','"
+ c_nombre
+ "','"
+ id_codtges
+ "') ");
Gestion ges = new Gestion();
while (rs.next()) {
ges = new Gestion();
ges.setC_codcent(rs.getString("c_codcent"));
ges.setC_tipodoc(rs.getString("c_tipodoc"));
ges.setC_nrodoc(rs.getString("c_nrodoc"));
ges.setC_nombre(rs.getString("c_nombre"));
ges.setC_direccion(rs.getString("c_direccion"));
ges.setC_distprov(rs.getString("c_distprov"));
ges.setC_telefono(rs.getString("c_telefono"));
ges.setF_fproceso(rs.getString("f_fproceso"));
ges.setF_fecasig(rs.getString("f_fecasig"));
ges.setC_destges(rs.getString("c_destges"));
ges.setN_idxges(rs.getString("n_idxges"));
ges.setId_codusu(rs.getString("id_codusu"));
ges.setId_codtges(rs.getString("id_codtges"));
lista.add(ges);
}
return lista;
}