public String elimina_registro_llamada(
String f_fproceso,
String c_contrato,
String c_codcent,
String id_codtcon,
String id_codtres,
String id_codusu,
String n_idxges)
throws Exception {
Conexion co = new Conexion();
String cad =
" { call USP_DEL_GESTION_LLM('"
+ f_fproceso
+ "','"
+ c_contrato
+ "','"
+ c_codcent
+ "','"
+ id_codtcon
+ "','"
+ id_codtres
+ "','"
+ id_codusu
+ "','"
+ n_idxges
+ "') } ";
return co.Ejecutar(cad);
}
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;
}
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 String graba_gestion_contrato(
String c_codcent,
String c_contrato,
String f_fproceso,
String f_fecasig,
String f_fecmod,
int n_idxges,
String id_codtges,
String id_codtcon,
String id_codtres,
String id_codtres_sub,
String f_fecresp,
String f_fecrevi,
String f_fecprog,
String c_obsges,
String id_codusu,
String n_impprom,
String c_codresp_mt,
String estado_ges,
String numubi)
throws Exception {
Conexion co = new Conexion();
String cadena =
" { call USP_UPD_GESTION_CONTRATO3("
+ c_codcent
+ ","
+ c_contrato
+ ","
+ f_fproceso
+ ","
+ f_fecasig
+ ","
+ f_fecmod
+ ","
+ n_idxges
+ ","
+ id_codtges
+ ","
+ id_codtcon
+ ","
+ id_codtres
+ ","
+ id_codtres_sub
+ ","
+ f_fecresp
+ ","
+ f_fecrevi
+ ","
+ f_fecprog
+ ","
+ c_obsges
+ ",'"
+ id_codusu
+ "',"
+ n_impprom
+ ","
+ c_codresp_mt
+ ","
+ estado_ges
+ ","
+ numubi
+ ") }";
return co.Ejecutar(cadena);
}
public String numero_ubicado(String c_codcent) throws Exception {
Conexion co = new Conexion();
return co.Nomusu("select distinct c_numubi from contrato where c_codcent='" + c_codcent + "'");
}