|
|
 Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'MONTHNAMEES' AND `proc`.`type` = 'FUNCTION'
|
rknet_bd |
MONTHNAMEES |
FUNCTION |
MONTHNAMEES |
SQL |
CONTAINS_SQL |
YES |
DEFINER |
`monthNum` INT
|
varchar(20) CHARSET latin1 COLLATE latin1_swedish_ci
|
BEGIN
RETURN CASE monthNum
WHEN 01 THEN 'ENERO'
WHEN 02 THEN 'FEBRERO'
WHEN 03 THEN 'MARZO'
WHEN 04 THEN 'ABRIL'
WHEN 05 THEN 'MAYO'
WHEN 06 THEN 'JUNIO'
WHEN 07 THEN 'JULIO'
WHEN 08 THEN 'AGOSTO'
WHEN 09 THEN 'SEPTIEMBRE'
WHEN 10 THEN 'OCTUBRE'
WHEN 11 THEN 'NOVIEMBRE'
WHEN 12 THEN 'DICIEMBRE'
ELSE ''
END;
END
|
rknettar@localhost |
2026-08-03 11:36:38 |
2026-08-03 11:36:38 |
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_... |
|
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_general_ci |
BEGIN
RETURN CASE monthNum
WHEN 01 THEN 'ENERO'
WHEN 02 THEN 'FEBRERO'
WHEN 03 THEN 'MARZO'
WHEN 04 THEN 'ABRIL'
WHEN 05 THEN 'MAYO'
WHEN 06 THEN 'JUNIO'
WHEN 07 THEN 'JULIO'
WHEN 08 THEN 'AGOSTO'
WHEN 09 THEN 'SEPTIEMBRE'
WHEN 10 THEN 'OCTUBRE'
WHEN 11 THEN 'NOVIEMBRE'
WHEN 12 THEN 'DICIEMBRE'
ELSE ''
END;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ACTIVAR_CLIENTE' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ACTIVAR_CLIENTE |
PROCEDURE |
SP_ACTIVAR_CLIENTE |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
UPDATE cliente SET
estado_cliente='ACTIVO'
WHERE id_cliente = ID;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
UPDATE cliente SET
estado_cliente='ACTIVO'
WHERE id_cliente = ID;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_CAMBIAR_ESTADO_RECORDATORIO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_CAMBIAR_ESTADO_RECORDATORIO |
PROCEDURE |
SP_CAMBIAR_ESTADO_RECORDATORIO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
UPDATE record_pago SET
estado='ENVIADO'
WHERE id_record_pago = ID;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
UPDATE record_pago SET
estado='ENVIADO'
WHERE id_record_pago = ID;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_CAMBIAR_ESTADO_RECORDATORIO2' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_CAMBIAR_ESTADO_RECORDATORIO2 |
PROCEDURE |
SP_CAMBIAR_ESTADO_RECORDATORIO2 |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
SET @cliente:=(SELECT id_cliente FROM record_suspension where id_record_suspension=ID);
UPDATE record_suspension SET
estado='SUSPENDIDO'
WHERE id_record_suspension = ID;
UPDATE cliente SET
estado_cliente='SUSPENDIDO'
WHERE id_cliente = @cliente;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SET @cliente:=(SELECT id_cliente FROM record_suspension where id_record_suspension=ID);
UPDATE record_suspension SET
estado='SUSPENDIDO'
WHERE id_record_suspension = ID;
UPDATE cliente SET
estado_cliente='SUSPENDIDO'
WHERE id_cliente = @cliente;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_CANCELAR_CLIENTE' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_CANCELAR_CLIENTE |
PROCEDURE |
SP_CANCELAR_CLIENTE |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
UPDATE cliente SET
estado_cliente='CANCELADO'
WHERE id_cliente = ID;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
UPDATE cliente SET
estado_cliente='CANCELADO'
WHERE id_cliente = ID;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ELIMINAR_ADELANTO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ELIMINAR_ADELANTO |
PROCEDURE |
SP_ELIMINAR_ADELANTO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
DELETE FROM adelantos WHERE id_adelanto = ID;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
DELETE FROM adelantos WHERE id_adelanto = ID;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ELIMINAR_CLIENTE' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ELIMINAR_CLIENTE |
PROCEDURE |
SP_ELIMINAR_CLIENTE |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
DECLARE IDUSU INT;
SET @IDUSU:=(SELECT usuario_id FROM cliente WHERE id_cliente=ID);
DELETE FROM usuario WHERE usu_id = @IDUSU;
DELETE FROM cliente WHERE id_cliente = ID;
DELETE FROM pagos WHERE id_cliente = ID AND estado_pago='PENDIENTE';
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
DECLARE IDUSU INT;
SET @IDUSU:=(SELECT usuario_id FROM cliente WHERE id_cliente=ID);
DELETE FROM usuario WHERE usu_id = @IDUSU;
DELETE FROM cliente WHERE id_cliente = ID;
DELETE FROM pagos WHERE id_cliente = ID AND estado_pago='PENDIENTE';
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ELIMINAR_GASTO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ELIMINAR_GASTO |
PROCEDURE |
SP_ELIMINAR_GASTO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
DELETE FROM gastos WHERE id_gasto = ID;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
DELETE FROM gastos WHERE id_gasto = ID;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ELIMINAR_PAGO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ELIMINAR_PAGO |
PROCEDURE |
SP_ELIMINAR_PAGO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
DELETE FROM pagos WHERE id_pagos = ID;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
DELETE FROM pagos WHERE id_pagos = ID;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ELIMINAR_RC1_PAGO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ELIMINAR_RC1_PAGO |
PROCEDURE |
SP_ELIMINAR_RC1_PAGO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
DELETE FROM record_pago WHERE id_record_pago = ID;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
DELETE FROM record_pago WHERE id_record_pago = ID;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ELIMINAR_RC2_PAGO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ELIMINAR_RC2_PAGO |
PROCEDURE |
SP_ELIMINAR_RC2_PAGO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
DELETE FROM record_suspension WHERE id_record_suspension = ID;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
DELETE FROM record_suspension WHERE id_record_suspension = ID;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ELIMINAR_RECORDATORIO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ELIMINAR_RECORDATORIO |
PROCEDURE |
SP_ELIMINAR_RECORDATORIO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
BEGIN
SET @conteo:=(SELECT COUNT(*) FROM record_pago where f_registro < CURDATE());
IF @conteo > 0 THEN
SET @dia_actual = DAY(NOW());
IF (@dia_actual < 10) THEN
SET @dia_actual = CONCAT('0', @dia_actual);
END IF;
DELETE FROM record_pago
WHERE SUBSTRING(d_recordatorio, 5, 2) < @dia_actual AND estado='ENVIADO'; -- Cambiar la condición a < en lugar de =
SELECT 1;
ELSE
SELECT 2;
END IF;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SET @conteo:=(SELECT COUNT(*) FROM record_pago where f_registro < CURDATE());
IF @conteo > 0 THEN
SET @dia_actual = DAY(NOW());
IF (@dia_actual < 10) THEN
SET @dia_actual = CONCAT('0', @dia_actual);
END IF;
DELETE FROM record_pago
WHERE SUBSTRING(d_recordatorio, 5, 2) < @dia_actual AND estado='ENVIADO'; -- Cambiar la condición a < en lugar de =
SELECT 1;
ELSE
SELECT 2;
END IF;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_ADELANTOS' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_ADELANTOS |
PROCEDURE |
SP_LISTAR_ADELANTOS |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `MES` VARCHAR(50), IN `ANIO` INT
|
|
SELECT
id_adelanto,
nombre_adelanto,
pago_adelanto,
observacion_adelanto,
monto_adelanto,
mes_adelanto,
fecha_adelanto,
registrado_adelanto
FROM
adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
SELECT
id_adelanto,
nombre_adelanto,
pago_adelanto,
observacion_adelanto,
monto_adelanto,
mes_adelanto,
fecha_adelanto,
registrado_adelanto
FROM
adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_COUNTCLIENTE' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_COUNTCLIENTE |
PROCEDURE |
SP_LISTAR_COUNTCLIENTE |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
SELECT
t_docu_cliente,
dni_cliente,
nombres_cliente,
CONCAT(apellido_pat_cliente, ' ', apellido_mat_cliente) AS apellidos_cliente,
celular_cliente,
direccion_cliente,
precio_plan,
estado_cliente,
d_pago,
d_corte
FROM
cliente
WHERE usuario_id = ID
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
SELECT
t_docu_cliente,
dni_cliente,
nombres_cliente,
CONCAT(apellido_pat_cliente, ' ', apellido_mat_cliente) AS apellidos_cliente,
celular_cliente,
direccion_cliente,
precio_plan,
estado_cliente,
d_pago,
d_corte
FROM
cliente
WHERE usuario_id = ID
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_GASTOS' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_GASTOS |
PROCEDURE |
SP_LISTAR_GASTOS |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `MES` VARCHAR(50), IN `ANIO` INT
|
|
BEGIN
SELECT
id_gasto,
nombre_gasto,
pago_gasto,
observacion_gasto,
monto_gasto,
mes_gasto,
anio_gasto,
fecha_gasto,
registrado_gasto
FROM
gastos WHERE mes_gasto=MES AND anio_gasto=ANIO;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SELECT
id_gasto,
nombre_gasto,
pago_gasto,
observacion_gasto,
monto_gasto,
mes_gasto,
anio_gasto,
fecha_gasto,
registrado_gasto
FROM
gastos WHERE mes_gasto=MES AND anio_gasto=ANIO;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_ELIMINAR_RECORDATORIO2' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_ELIMINAR_RECORDATORIO2 |
PROCEDURE |
SP_ELIMINAR_RECORDATORIO2 |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
BEGIN
SET @conteo:=(SELECT COUNT(*) FROM record_suspension where f_registro < CURDATE());
IF @conteo > 0 THEN
SET @dia_actual = DAY(NOW());
IF (@dia_actual < 10) THEN
SET @dia_actual = CONCAT('0', @dia_actual);
END IF;
DELETE FROM record_suspension
WHERE SUBSTRING(d_corte, 5, 2) < @dia_actual AND estado='SUSPENDIDO'; -- Cambiar la condición a < en lugar de =
SELECT 1;
ELSE
SELECT 2;
END IF;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SET @conteo:=(SELECT COUNT(*) FROM record_suspension where f_registro < CURDATE());
IF @conteo > 0 THEN
SET @dia_actual = DAY(NOW());
IF (@dia_actual < 10) THEN
SET @dia_actual = CONCAT('0', @dia_actual);
END IF;
DELETE FROM record_suspension
WHERE SUBSTRING(d_corte, 5, 2) < @dia_actual AND estado='SUSPENDIDO'; -- Cambiar la condición a < en lugar de =
SELECT 1;
ELSE
SELECT 2;
END IF;
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_CLIENTE' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_CLIENTE |
PROCEDURE |
SP_LISTAR_CLIENTE |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
SELECT
c.id_cliente,
c.t_docu_cliente,
c.dni_cliente,
c.nombres_cliente,
c.apellido_pat_cliente,
c.apellido_mat_cliente,
CONCAT_WS(' ', c.apellido_pat_cliente, c.apellido_mat_cliente) as apellidos_cliente,
c.celular_cliente,
c.direccion_cliente,
c.ip_cliente,
c.ip_cliente,
c.plan_cliente,
p.plan_nombre,
c.precio_plan,
c.estado_cliente,
c.d_crear_factura,
c.h_crear_factura,
c.d_pago,
c.d_corte,
c.h_corte,
c.suspender,
c.f_creacion,
c.creado_x,
c.usuario_id,
c.iptv_s,
c.iptv_p,
c.iptv_f
FROM
cliente c
JOIN plan p ON c.plan_cliente = p.plan_id
|
rknettar@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_... |
|
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_general_ci |
SELECT
c.id_cliente,
c.t_docu_cliente,
c.dni_cliente,
c.nombres_cliente,
c.apellido_pat_cliente,
c.apellido_mat_cliente,
CONCAT_WS(' ', c.apellido_pat_cliente, c.apellido_mat_cliente) as apellidos_cliente,
c.celular_cliente,
c.direccion_cliente,
c.ip_cliente,
c.ip_cliente,
c.plan_cliente,
p.plan_nombre,
c.precio_plan,
c.estado_cliente,
c.d_crear_factura,
c.h_crear_factura,
c.d_pago,
c.d_corte,
c.h_corte,
c.suspender,
c.f_creacion,
c.creado_x,
c.usuario_id,
c.iptv_s,
c.iptv_p,
c.iptv_f
FROM
cliente c
JOIN plan p ON c.plan_cliente = p.plan_id
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_EMPRESA' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_EMPRESA |
PROCEDURE |
SP_LISTAR_EMPRESA |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
SELECT
configuracion.confi_id,
configuracion.confi_razon_social,
configuracion.confi_ruc,
configuracion.confi_nombre_representante,
configuracion.confi_direccion,
configuracion.confi_celular,
configuracion.confi_telefono,
configuracion.confi_correo,
configuracion.config_foto,
configuracion.confi_estado,
configuracion.confi_url,
configuracion.confi_cnta01,
configuracion.confi_nro_cuenta01,
configuracion.confi_cnta02,
configuracion.confi_nro_cuenta02
FROM
configuracion
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
SELECT
configuracion.confi_id,
configuracion.confi_razon_social,
configuracion.confi_ruc,
configuracion.confi_nombre_representante,
configuracion.confi_direccion,
configuracion.confi_celular,
configuracion.confi_telefono,
configuracion.confi_correo,
configuracion.config_foto,
configuracion.confi_estado,
configuracion.confi_url,
configuracion.confi_cnta01,
configuracion.confi_nro_cuenta01,
configuracion.confi_cnta02,
configuracion.confi_nro_cuenta02
FROM
configuracion
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_PAGO_MES_ANIO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_PAGO_MES_ANIO |
PROCEDURE |
SP_LISTAR_PAGO_MES_ANIO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `MES` VARCHAR(50), IN `ANIO` INT
|
|
BEGIN
SELECT
p.id_pagos,
p.id_cliente,
p.dni_cliente,
p.nombres_cliente,
p.apellidos_cliente,
p.f_pago,
p.mes_recarga,
p.anio_recarga,
p.descripcion_pago,
p.dia_pago,
p.tipo_pago,
p.estado_pago,
p.fecha_registro,
p.nombre_plan,
p.precio_plan,
p.registrado_x,
c.ip_cliente
FROM
pagos p
JOIN
cliente c ON p.id_cliente = c.id_cliente
WHERE
p.mes_recarga = MES AND p.anio_recarga = ANIO AND p.estado_pago = 'PENDIENTE';
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SELECT
p.id_pagos,
p.id_cliente,
p.dni_cliente,
p.nombres_cliente,
p.apellidos_cliente,
p.f_pago,
p.mes_recarga,
p.anio_recarga,
p.descripcion_pago,
p.dia_pago,
p.tipo_pago,
p.estado_pago,
p.fecha_registro,
p.nombre_plan,
p.precio_plan,
p.registrado_x,
c.ip_cliente
FROM
pagos p
JOIN
cliente c ON p.id_cliente = c.id_cliente
WHERE
p.mes_recarga = MES AND p.anio_recarga = ANIO AND p.estado_pago = 'PENDIENTE';
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_PAGO_S_CLIENTE' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_PAGO_S_CLIENTE |
PROCEDURE |
SP_LISTAR_PAGO_S_CLIENTE |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `ID` INT
|
|
BEGIN
SELECT
p.id_pagos,
p.id_cliente,
p.dni_cliente,
p.nombres_cliente,
p.apellidos_cliente,
p.f_pago,
p.mes_recarga,
p.anio_recarga,
p.descripcion_pago,
p.dia_pago,
p.tipo_pago,
p.estado_pago,
p.fecha_registro,
p.nombre_plan,
p.precio_plan,
p.registrado_x
FROM
pagos p
INNER JOIN cliente c ON p.id_cliente = c.id_cliente
WHERE c.usuario_id = ID AND p.estado_pago='PAGADO';
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SELECT
p.id_pagos,
p.id_cliente,
p.dni_cliente,
p.nombres_cliente,
p.apellidos_cliente,
p.f_pago,
p.mes_recarga,
p.anio_recarga,
p.descripcion_pago,
p.dia_pago,
p.tipo_pago,
p.estado_pago,
p.fecha_registro,
p.nombre_plan,
p.precio_plan,
p.registrado_x
FROM
pagos p
INNER JOIN cliente c ON p.id_cliente = c.id_cliente
WHERE c.usuario_id = ID AND p.estado_pago='PAGADO';
END
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_PLAN' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_PLAN |
PROCEDURE |
SP_LISTAR_PLAN |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
SELECT
plan.plan_id,
plan.plan_nombre,
plan_precio,
plan_velocidad,
plan.plan_fregistro,
plan.plan_estatus
FROM
plan
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
SELECT
plan.plan_id,
plan.plan_nombre,
plan_precio,
plan_velocidad,
plan.plan_fregistro,
plan.plan_estatus
FROM
plan
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_RECORD_PAGO' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_RECORD_PAGO |
PROCEDURE |
SP_LISTAR_RECORD_PAGO |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
SELECT
id_record_pago,
id_cliente,
nombres_cliente,
apellidos_cliente,
celular_cliente,
d_recordatorio,
d_pago,
d_corte,
estado
FROM
record_pago
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
SELECT
id_record_pago,
id_cliente,
nombres_cliente,
apellidos_cliente,
celular_cliente,
d_recordatorio,
d_pago,
d_corte,
estado
FROM
record_pago
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_ROL' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_ROL |
PROCEDURE |
SP_LISTAR_ROL |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
SELECT
rol.rol_id,
rol.rol_nombre,
rol.rol_fregistro,
rol.rol_estatus
FROM
rol
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
SELECT
rol.rol_id,
rol.rol_nombre,
rol.rol_fregistro,
rol.rol_estatus
FROM
rol
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_SELECT_ESTUDIANTE' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_SELECT_ESTUDIANTE |
PROCEDURE |
SP_LISTAR_SELECT_ESTUDIANTE |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
SELECT
id_estudiante,
dni_estudiante,
CONCAT_WS(' ',apellido_pat_estudiante,apellido_mat_estudiante,nombres_estudiante) AS estudiantenc,
grado_estudiante,
nivel_estudiante
FROM
estudiante
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
SELECT
id_estudiante,
dni_estudiante,
CONCAT_WS(' ',apellido_pat_estudiante,apellido_mat_estudiante,nombres_estudiante) AS estudiantenc,
grado_estudiante,
nivel_estudiante
FROM
estudiante
|
NONE |
|
|
Editar
|
Copiar
|
Borrar
DELETE FROM proc WHERE `proc`.`db` = 'rknet_bd' AND `proc`.`name` = 'SP_LISTAR_ADELANTOS_TOTAL' AND `proc`.`type` = 'PROCEDURE'
|
rknet_bd |
SP_LISTAR_ADELANTOS_TOTAL |
PROCEDURE |
SP_LISTAR_ADELANTOS_TOTAL |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `MES` VARCHAR(50), IN `ANIO` INT
|
|
BEGIN
SELECT
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND nombre_adelanto='KEPLER') as suma_adelantos_t_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='EFECTIVO' AND nombre_adelanto='KEPLER') as suma_adelantos_e_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BCP' AND nombre_adelanto='KEPLER') as suma_adelantos_bcp_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BN' AND nombre_adelanto='KEPLER') as suma_adelantos_bn_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='YAPE' AND nombre_adelanto='KEPLER') as suma_adelantos_y_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND nombre_adelanto='AYB') as suma_adelantos_t_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='EFECTIVO' AND nombre_adelanto='AYB') as suma_adelantos_e_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BCP' AND nombre_adelanto='AYB') as suma_adelantos_bcp_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BN' AND nombre_adelanto='AYB') as suma_adelantos_bn_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='YAPE' AND nombre_adelanto='AYB') as suma_adelantos_y_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND nombre_adelanto='TITO') as suma_adelantos_t_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='EFECTIVO' AND nombre_adelanto='TITO') as suma_adelantos_e_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BCP' AND nombre_adelanto='TITO') as suma_adelantos_bcp_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BN' AND nombre_adelanto='TITO') as suma_adelantos_bn_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='YAPE' AND nombre_adelanto='TITO') as suma_adelantos_y_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND nombre_adelanto='CAJA') as suma_adelantos_t_caja,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='EFECTIVO' AND nombre_adelanto='CAJA') as suma_adelantos_e_caja,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BCP' AND nombre_adelanto='CAJA') as suma_adelantos_bcp_caja,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BN' AND nombre_adelanto='CAJA') as suma_adelantos_bn_caja,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='YAPE' AND nombre_adelanto='CAJA') as suma_adelantos_y_caja;
END
|
root@localhost |
2026-08-03 11:36:39 |
2026-08-03 11:36:39 |
|
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SELECT
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND nombre_adelanto='KEPLER') as suma_adelantos_t_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='EFECTIVO' AND nombre_adelanto='KEPLER') as suma_adelantos_e_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BCP' AND nombre_adelanto='KEPLER') as suma_adelantos_bcp_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BN' AND nombre_adelanto='KEPLER') as suma_adelantos_bn_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='YAPE' AND nombre_adelanto='KEPLER') as suma_adelantos_y_kepler,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND nombre_adelanto='AYB') as suma_adelantos_t_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='EFECTIVO' AND nombre_adelanto='AYB') as suma_adelantos_e_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BCP' AND nombre_adelanto='AYB') as suma_adelantos_bcp_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BN' AND nombre_adelanto='AYB') as suma_adelantos_bn_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='YAPE' AND nombre_adelanto='AYB') as suma_adelantos_y_ayb,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND nombre_adelanto='TITO') as suma_adelantos_t_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='EFECTIVO' AND nombre_adelanto='TITO') as suma_adelantos_e_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BCP' AND nombre_adelanto='TITO') as suma_adelantos_bcp_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BN' AND nombre_adelanto='TITO') as suma_adelantos_bn_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='YAPE' AND nombre_adelanto='TITO') as suma_adelantos_y_tito,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND nombre_adelanto='CAJA') as suma_adelantos_t_caja,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='EFECTIVO' AND nombre_adelanto='CAJA') as suma_adelantos_e_caja,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BCP' AND nombre_adelanto='CAJA') as suma_adelantos_bcp_caja,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='BN' AND nombre_adelanto='CAJA') as suma_adelantos_bn_caja,
(SELECT SUM(monto_adelanto) FROM adelantos WHERE mes_adelanto=MES AND anio_adelanto=ANIO AND pago_adelanto='YAPE' AND nombre_adelanto='CAJA') as suma_adelantos_y_caja;
END
|
NONE |
