-- MySQL dump 10.13 Distrib 8.0.44, for macos12.7 (arm64) -- -- Host: localhost Database: tefnet_erp -- ------------------------------------------------------ -- Server version 8.0.44 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `agente_apuracao_periodos` -- DROP TABLE IF EXISTS `agente_apuracao_periodos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `agente_apuracao_periodos` ( `id` int NOT NULL AUTO_INCREMENT, `cod_Representante` int NOT NULL COMMENT 'O agente (idNatureza=3)', `competencia` char(7) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'YYYY-MM', `modalidade_snap` enum('pct_parceiro','pct_cliente_final','tabela_preco') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pct_padrao_snap` decimal(8,4) DEFAULT NULL, `total_titulos_pagos` decimal(14,2) NOT NULL DEFAULT '0.00', `total_comissao` decimal(14,2) NOT NULL DEFAULT '0.00', `total_disponivel` decimal(14,2) NOT NULL DEFAULT '0.00', `total_em_lote` decimal(14,2) NOT NULL DEFAULT '0.00', `total_liquidado` decimal(14,2) NOT NULL DEFAULT '0.00', `status_ciclo` enum('prevista','apurada','fechada') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'prevista', `apurada_at` datetime DEFAULT NULL, `apurada_by` int DEFAULT NULL, `fechada_at` datetime DEFAULT NULL, `fechada_by` int DEFAULT NULL, `reaberta_at` datetime DEFAULT NULL, `reaberta_by` int DEFAULT NULL, `dirty` tinyint(1) NOT NULL DEFAULT '0', `dirty_em` datetime DEFAULT NULL, `dirty_motivo` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `situacao` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `uk_apur_agente_competencia` (`cod_Representante`,`competencia`), KEY `idx_apur_status` (`status_ciclo`,`dirty`), KEY `idx_apur_competencia` (`competencia`) ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agente_apuracao_periodos` -- LOCK TABLES `agente_apuracao_periodos` WRITE; /*!40000 ALTER TABLE `agente_apuracao_periodos` DISABLE KEYS */; INSERT INTO `agente_apuracao_periodos` VALUES (10,278,'2024-10','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(11,417,'2024-10','pct_cliente_final',10.0000,172.00,17.20,0.00,17.20,0.00,'fechada','2026-05-09 22:12:14',0,'2026-05-09 22:12:50',0,NULL,NULL,0,NULL,NULL,1),(12,278,'2025-12','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(13,417,'2025-12','pct_cliente_final',10.0000,1767.00,176.70,0.00,176.70,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(14,278,'2026-01','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(15,417,'2026-01','pct_cliente_final',10.0000,2087.00,208.70,0.00,208.70,0.00,'apurada','2026-05-10 15:17:33',0,'2026-05-10 17:52:24',0,'2026-05-10 17:52:24',0,1,'2026-05-10 17:52:24','reabertura: restauracao spec UI#23 Onda 5',1),(16,278,'2026-02','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(17,417,'2026-02','pct_cliente_final',10.0000,3778.83,375.70,0.00,375.70,0.00,'apurada','2026-05-10 15:17:33',0,'2026-05-09 22:51:06',0,'2026-05-09 22:51:27',0,0,NULL,NULL,1),(18,417,'2025-10','pct_cliente_final',10.0000,1287.00,128.70,0.00,128.70,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(19,417,'2025-09','pct_cliente_final',10.0000,940.91,94.09,94.09,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(20,417,'2025-08','pct_cliente_final',10.0000,715.19,70.40,70.40,0.00,0.00,'apurada','2026-05-10 22:52:37',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(21,278,'2026-05','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(22,417,'2026-05','pct_cliente_final',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(23,278,'2026-04','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(24,417,'2026-04','pct_cliente_final',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(25,278,'2026-03','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(26,417,'2026-03','pct_cliente_final',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(27,278,'2025-11','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(28,417,'2025-11','pct_cliente_final',10.0000,1485.85,148.20,0.00,148.20,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(29,278,'2025-10','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(30,278,'2025-09','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(31,278,'2025-08','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(32,278,'2025-07','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(33,417,'2025-07','pct_cliente_final',10.0000,175.80,17.20,17.20,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(34,278,'2025-06','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(35,417,'2025-06','pct_cliente_final',10.0000,176.11,17.20,17.20,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(36,278,'2025-05','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(37,417,'2025-05','pct_cliente_final',10.0000,172.00,17.20,0.00,17.20,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(38,278,'2025-04','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(39,417,'2025-04','pct_cliente_final',10.0000,176.00,17.20,0.00,17.20,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(40,278,'2025-03','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(41,417,'2025-03','pct_cliente_final',10.0000,172.00,17.20,17.20,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(42,278,'2025-02','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(43,417,'2025-02','pct_cliente_final',10.0000,172.00,17.20,0.00,17.20,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(44,278,'2025-01','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(45,417,'2025-01','pct_cliente_final',10.0000,172.00,17.20,0.00,17.20,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(46,278,'2024-12','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(47,417,'2024-12','pct_cliente_final',10.0000,172.00,17.20,0.00,17.20,0.00,'fechada','2026-05-10 15:17:33',0,'2026-05-10 15:19:18',0,NULL,NULL,0,NULL,NULL,1),(48,278,'2024-11','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(49,417,'2024-11','pct_cliente_final',10.0000,172.00,17.20,0.00,17.20,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(50,278,'2024-09','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(51,417,'2024-09','pct_cliente_final',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(52,278,'2024-08','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(53,417,'2024-08','pct_cliente_final',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(54,278,'2024-07','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(55,417,'2024-07','pct_cliente_final',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(56,278,'2024-06','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(57,417,'2024-06','pct_cliente_final',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-10 15:17:33',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1); /*!40000 ALTER TABLE `agente_apuracao_periodos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `agente_apuracao_itens` -- DROP TABLE IF EXISTS `agente_apuracao_itens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `agente_apuracao_itens` ( `id` int NOT NULL AUTO_INCREMENT, `apuracao_id` int NOT NULL, `cod_Pedido_snap` int NOT NULL, `id_titulo_snap` int NOT NULL COMMENT 'tbl_Boleto.id ou tbl_Faturamento.id', `fonte_titulo` enum('boleto','faturamento') COLLATE utf8mb4_unicode_ci NOT NULL, `cod_Cliente` int NOT NULL, `data_pag` date NOT NULL, `valor_base` decimal(14,2) NOT NULL, `pct_aplicado` decimal(8,4) DEFAULT NULL, `comissao` decimal(14,2) NOT NULL, `regra_aplicada` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Texto humano-legivel da regra', `status_item` enum('disponivel','em_lote','liquidado','estornado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'disponivel', `lote_id` int DEFAULT NULL, `situacao` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `uk_apur_titulo` (`id_titulo_snap`,`fonte_titulo`) COMMENT 'idempotencia: 1 titulo so pode estar em 1 apuracao', KEY `idx_apur_item_apur` (`apuracao_id`,`status_item`), KEY `idx_apur_item_lote` (`lote_id`) ) ENGINE=InnoDB AUTO_INCREMENT=280 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agente_apuracao_itens` -- LOCK TABLES `agente_apuracao_itens` WRITE; /*!40000 ALTER TABLE `agente_apuracao_itens` DISABLE KEYS */; INSERT INTO `agente_apuracao_itens` VALUES (2,11,6340,78797,'faturamento',5812,'2024-11-18',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',1,1),(188,17,6340,104575,'faturamento',5812,'2026-03-17',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',5,1),(189,17,7692,104615,'faturamento',6887,'2026-03-16',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',5,1),(190,17,7780,104618,'faturamento',7078,'2026-03-16',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',5,1),(191,17,7867,104623,'faturamento',7146,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',5,1),(192,17,7878,104624,'faturamento',7157,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',5,1),(193,17,7941,104625,'faturamento',7214,'2026-03-16',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',5,1),(194,17,8135,104635,'faturamento',7387,'2026-03-19',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',5,1),(195,17,8246,104640,'faturamento',7487,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',5,1),(196,17,8293,104653,'faturamento',7531,'2026-03-17',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',5,1),(197,17,8356,104660,'faturamento',7589,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',5,1),(198,17,8377,104664,'faturamento',7610,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',5,1),(199,17,8414,104666,'faturamento',7647,'2026-03-16',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',5,1),(200,17,8415,104667,'faturamento',7648,'2026-03-16',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',5,1),(201,17,8417,104668,'faturamento',7650,'2026-03-19',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',5,1),(202,17,8418,104669,'faturamento',7651,'2026-03-18',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',5,1),(203,17,8419,104670,'faturamento',7652,'2026-03-16',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',5,1),(204,17,8420,104671,'faturamento',7653,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',5,1),(205,17,8421,104672,'faturamento',7654,'2026-03-16',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',5,1),(206,17,8498,104676,'faturamento',7726,'2026-03-16',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',5,1),(207,17,8499,104677,'faturamento',7728,'2026-03-16',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',5,1),(208,17,8502,104678,'faturamento',7730,'2026-03-19',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',5,1),(209,15,6340,102740,'faturamento',5812,'2026-02-18',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',3,1),(210,15,7692,102780,'faturamento',6887,'2026-02-18',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',3,1),(211,15,7780,102783,'faturamento',7078,'2026-02-18',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',3,1),(212,15,7867,102788,'faturamento',7146,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',3,1),(213,15,7878,102789,'faturamento',7157,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',3,1),(214,15,7941,102790,'faturamento',7214,'2026-02-18',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',3,1),(215,15,8135,102800,'faturamento',7387,'2026-02-18',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',3,1),(216,15,8246,102805,'faturamento',7487,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',3,1),(217,15,8293,102817,'faturamento',7531,'2026-02-18',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',3,1),(218,15,8356,102824,'faturamento',7589,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',3,1),(219,15,8377,102828,'faturamento',7610,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',3,1),(220,13,6340,101025,'faturamento',5812,'2026-01-15',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',11,1),(221,13,7692,101066,'faturamento',6887,'2026-01-15',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',11,1),(222,13,7780,101069,'faturamento',7078,'2026-01-15',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',11,1),(223,13,7867,101074,'faturamento',7146,'2026-01-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',11,1),(224,13,7878,101075,'faturamento',7157,'2026-01-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',11,1),(225,13,7941,101076,'faturamento',7214,'2026-01-15',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',11,1),(226,13,8135,101086,'faturamento',7387,'2026-01-15',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',11,1),(227,13,8246,101091,'faturamento',7487,'2026-01-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',11,1),(228,13,8293,101103,'faturamento',7531,'2026-01-15',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',11,1),(229,28,6340,99228,'faturamento',5812,'2025-12-23',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',7,1),(230,28,7692,99269,'faturamento',6887,'2025-12-15',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',7,1),(231,28,7780,99272,'faturamento',7078,'2025-12-15',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',7,1),(232,28,7867,99277,'faturamento',7146,'2025-12-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',7,1),(233,28,7878,99278,'faturamento',7157,'2025-12-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',7,1),(234,28,7941,99279,'faturamento',7214,'2025-12-15',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',7,1),(235,28,8135,99289,'faturamento',7387,'2025-12-15',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','em_lote',7,1),(236,18,6340,97447,'faturamento',5812,'2025-11-17',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',8,1),(237,18,7692,97488,'faturamento',6887,'2025-11-17',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',8,1),(238,18,7780,97491,'faturamento',7078,'2025-11-17',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','em_lote',8,1),(239,18,7867,97496,'faturamento',7146,'2025-11-17',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',8,1),(240,18,7878,97497,'faturamento',7157,'2025-11-17',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','em_lote',8,1),(241,18,7941,97498,'faturamento',7214,'2025-11-26',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','em_lote',8,1),(242,19,6340,95593,'faturamento',5812,'2025-10-15',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','disponivel',NULL,1),(243,19,7692,95635,'faturamento',6887,'2025-10-15',326.48,10.0000,32.65,'10% sobre valor cobrado do cliente final — 10% de R$ 326,48 = R$ 32,65','disponivel',NULL,1),(244,19,7780,95638,'faturamento',7078,'2025-10-15',122.43,10.0000,12.24,'10% sobre valor cobrado do cliente final — 10% de R$ 122,43 = R$ 12,24','disponivel',NULL,1),(245,19,7867,95643,'faturamento',7146,'2025-10-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(246,19,7878,95644,'faturamento',7157,'2025-10-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(250,33,6340,92105,'faturamento',5812,'2025-08-22',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','disponivel',NULL,1),(251,35,6340,90406,'faturamento',5812,'2025-07-28',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','disponivel',NULL,1),(252,37,6340,89785,'faturamento',5812,'2025-06-16',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',19,1),(253,39,6340,88130,'faturamento',5812,'2025-05-26',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',18,1),(254,41,6340,86501,'faturamento',5812,'2025-04-15',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','disponivel',NULL,1),(255,43,6340,84897,'faturamento',5812,'2025-03-17',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',15,1),(256,45,6340,83403,'faturamento',5812,'2025-02-17',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',13,1),(257,47,6340,81792,'faturamento',5812,'2025-01-15',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',2,1),(258,49,6340,80335,'faturamento',5812,'2024-12-16',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',14,1),(277,20,6340,93912,'faturamento',5812,'2025-09-15',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','disponivel',NULL,1),(278,20,7692,93954,'faturamento',6887,'2025-09-19',407.00,10.0000,40.70,'10% sobre valor cobrado do cliente final — 10% de R$ 407,00 = R$ 40,70','disponivel',NULL,1),(279,20,7780,93958,'faturamento',7078,'2025-09-17',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1); /*!40000 ALTER TABLE `agente_apuracao_itens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `agente_lote_resgate` -- DROP TABLE IF EXISTS `agente_lote_resgate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `agente_lote_resgate` ( `id` int NOT NULL AUTO_INCREMENT, `numero_humano` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'LR-YYYY-NNNN', `cod_Representante` int NOT NULL, `competencia` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'YYYY-MM, denormalizado pra preservar agrupamento mesmo apos resgate_reprovar deletar agente_lote_item (B#13)', `data_resgate` datetime NOT NULL COMMENT 'capturado no cliente', `total` decimal(14,2) NOT NULL, `status_lote` enum('pendente_aprovacao','aguardando_pagamento','pago','liquidado','estornado','reprovado_tef_net') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pendente_aprovacao' COMMENT 'Estado do lote no fluxo conta corrente (ADR-0010). pendente_aprovacao = default novo.', `data_pag` datetime DEFAULT NULL, `data_prev_pag` date DEFAULT NULL COMMENT 'Data programada para pagamento (Tef.Net interno define ao aprovar ou depois)', `forma_pag` enum('pix','ted','boleto','outros') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comprovante_hash` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'hash_temp pos-upload', `observacao` text COLLATE utf8mb4_unicode_ci, `liquidado_at` datetime DEFAULT NULL, `liquidado_by` int DEFAULT NULL, `estornado_at` datetime DEFAULT NULL, `estornado_by` int DEFAULT NULL, `estorno_motivo` varchar(240) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reprovado_motivo` varchar(240) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reprovado_em` datetime DEFAULT NULL, `reprovado_by` int DEFAULT NULL, `situacao` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `uk_lote_numero` (`numero_humano`), KEY `idx_lote_repr_status` (`cod_Representante`,`status_lote`), KEY `idx_lote_data` (`data_resgate`), KEY `idx_lote_reprovado_em` (`reprovado_em`), KEY `idx_lote_competencia` (`competencia`), KEY `idx_lote_data_prev_pag` (`data_prev_pag`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agente_lote_resgate` -- LOCK TABLES `agente_lote_resgate` WRITE; /*!40000 ALTER TABLE `agente_lote_resgate` DISABLE KEYS */; INSERT INTO `agente_lote_resgate` VALUES (1,'LR-2024-0001',417,'2024-10','2026-05-09 22:13:02',17.20,'aguardando_pagamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(2,'LR-2024-0002',417,'2024-12','2026-05-10 15:26:47',17.20,'aguardando_pagamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(3,'LR-2026-0001',417,'2026-01','2026-05-10 21:13:31',208.70,'aguardando_pagamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(4,'LR-2026-0002',417,'','2026-05-10 21:13:32',375.70,'reprovado_tef_net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Teste automatizado RES#2 Sprint B — falta NF para esta competencia.','2026-05-10 21:32:44',NULL,1),(5,'LR-2026-0003',417,'2026-02','2026-05-10 21:33:50',375.70,'aguardando_pagamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(6,'LR-2025-0001',417,'','2026-05-10 21:33:50',176.70,'reprovado_tef_net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Teste automatizado RES#2 Sprint B — falta NF para esta competencia.','2026-05-10 21:33:56',NULL,1),(7,'LR-2025-0002',417,'2025-11','2026-05-10 21:34:19',148.20,'aguardando_pagamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(8,'LR-2025-0003',417,'2025-10','2026-05-10 21:34:19',128.70,'aguardando_pagamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(11,'LR-2025-0004',417,'2025-12','2026-05-10 21:52:11',176.70,'aguardando_pagamento',NULL,NULL,'boleto',NULL,'smoke C fix',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(12,'LR-2025-0005',417,'','2026-05-10 21:53:24',94.09,'reprovado_tef_net',NULL,NULL,'pix',NULL,'Spec automatizado RES#2 Sprint C T8',NULL,NULL,NULL,NULL,NULL,'Teste automatizado RES#2 Sprint B — falta NF para esta competencia.','2026-05-10 21:53:33',NULL,1),(13,'LR-2025-0006',417,'2025-01','2026-05-10 21:54:14',17.20,'aguardando_pagamento',NULL,NULL,'pix',NULL,'Spec auto RES#2 Sprint C T8 comp=2025-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(14,'LR-2024-0003',417,'2024-11','2026-05-10 21:54:58',17.20,'aguardando_pagamento',NULL,NULL,'pix',NULL,'Spec auto RES#2 Sprint C T8 comp=2024-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(15,'LR-2025-0007',417,'2025-02','2026-05-10 21:58:29',17.20,'aguardando_pagamento',NULL,NULL,'pix',NULL,'Spec auto RES#2 Sprint C T8 comp=2025-02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(16,'LR-2025-0008',417,'','2026-05-10 21:58:35',17.20,'reprovado_tef_net',NULL,NULL,'pix',NULL,'Spec auto RES#2 Sprint C T8 comp=2025-03',NULL,NULL,NULL,NULL,NULL,'Teste automatizado RES#2 Sprint B — falta NF para esta competencia.','2026-05-10 21:58:37',NULL,1),(17,'LR-2025-0009',417,'2025-03','2026-05-10 22:50:45',17.20,'reprovado_tef_net',NULL,NULL,'pix',NULL,'Spec auto RES#2 Sprint C T8 comp=2025-03',NULL,NULL,NULL,NULL,NULL,'Teste automatizado RES#2 Sprint B — falta NF para esta competencia.','2026-05-10 22:52:30',NULL,1),(18,'LR-2025-0010',417,'2025-04','2026-05-10 22:51:20',17.20,'aguardando_pagamento',NULL,NULL,'pix',NULL,'Spec auto RES#2 Sprint C T8 comp=2025-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(19,'LR-2025-0011',417,'2025-05','2026-05-10 22:52:29',17.20,'aguardando_pagamento',NULL,NULL,'pix',NULL,'Spec auto RES#2 Sprint C T8 comp=2025-05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1); /*!40000 ALTER TABLE `agente_lote_resgate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `agente_lote_item` -- DROP TABLE IF EXISTS `agente_lote_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `agente_lote_item` ( `id` int NOT NULL AUTO_INCREMENT, `lote_id` int NOT NULL, `apuracao_item_id` int NOT NULL, `valor_snap` decimal(14,2) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_lote_item` (`apuracao_item_id`) COMMENT '1 item de apuracao em no maximo 1 lote nao-estornado', KEY `idx_lote_item_lote` (`lote_id`) ) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agente_lote_item` -- LOCK TABLES `agente_lote_item` WRITE; /*!40000 ALTER TABLE `agente_lote_item` DISABLE KEYS */; INSERT INTO `agente_lote_item` VALUES (1,1,2,17.20),(2,2,257,17.20),(3,3,209,17.20),(4,3,210,33.50),(5,3,211,12.50),(6,3,212,16.00),(7,3,213,16.00),(8,3,214,33.50),(9,3,215,19.50),(10,3,216,16.00),(11,3,217,12.50),(12,3,218,16.00),(13,3,219,16.00),(35,5,188,17.20),(36,5,189,33.50),(37,5,190,12.50),(38,5,191,16.00),(39,5,192,16.00),(40,5,193,33.50),(41,5,194,19.50),(42,5,195,16.00),(43,5,196,12.50),(44,5,197,16.00),(45,5,198,16.00),(46,5,199,19.50),(47,5,200,19.50),(48,5,201,19.50),(49,5,202,19.50),(50,5,203,12.50),(51,5,204,16.00),(52,5,205,12.50),(53,5,206,19.50),(54,5,207,12.50),(55,5,208,16.00),(65,7,229,17.20),(66,7,230,33.50),(67,7,231,12.50),(68,7,232,16.00),(69,7,233,16.00),(70,7,234,33.50),(71,7,235,19.50),(72,8,236,17.20),(73,8,237,33.50),(74,8,238,12.50),(75,8,239,16.00),(76,8,240,16.00),(77,8,241,33.50),(96,11,220,17.20),(97,11,221,33.50),(98,11,222,12.50),(99,11,223,16.00),(100,11,224,16.00),(101,11,225,33.50),(102,11,226,19.50),(103,11,227,16.00),(104,11,228,12.50),(110,13,256,17.20),(111,14,258,17.20),(112,15,255,17.20),(115,18,253,17.20),(116,19,252,17.20); /*!40000 ALTER TABLE `agente_lote_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `agente_critica_resgate` -- DROP TABLE IF EXISTS `agente_critica_resgate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `agente_critica_resgate` ( `id` int NOT NULL AUTO_INCREMENT, `cod_Representante` int NOT NULL, `competencia` char(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'NULL=critica geral; preenchido=especifica', `motivo` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `bloqueia_resgate` tinyint(1) NOT NULL DEFAULT '1', `ativa` tinyint(1) NOT NULL DEFAULT '1', `criado_at` datetime NOT NULL, `criado_by` int NOT NULL, `resolvido_at` datetime DEFAULT NULL, `resolvido_by` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_critica_repr` (`cod_Representante`,`ativa`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agente_critica_resgate` -- LOCK TABLES `agente_critica_resgate` WRITE; /*!40000 ALTER TABLE `agente_critica_resgate` DISABLE KEYS */; /*!40000 ALTER TABLE `agente_critica_resgate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `agente_log_cron` -- DROP TABLE IF EXISTS `agente_log_cron`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `agente_log_cron` ( `id` int NOT NULL AUTO_INCREMENT, `iniciado_at` datetime NOT NULL, `finalizado_at` datetime DEFAULT NULL, `competencia` char(7) COLLATE utf8mb4_unicode_ci NOT NULL, `agentes_processados` int NOT NULL DEFAULT '0', `agentes_com_erro` int NOT NULL DEFAULT '0', `erro_msg` text COLLATE utf8mb4_unicode_ci, `duracao_ms` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_log_data` (`iniciado_at`) ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agente_log_cron` -- LOCK TABLES `agente_log_cron` WRITE; /*!40000 ALTER TABLE `agente_log_cron` DISABLE KEYS */; INSERT INTO `agente_log_cron` VALUES (1,'2026-05-06 01:11:51','2026-05-05 22:11:51','2026-04',0,0,NULL,2),(2,'2026-05-09 22:28:01','2026-05-09 19:28:01','2026-05',0,2,'agente #278: SQLSTATE[01000]: Warning: 1265 Data truncated for column \'modalidade_snap\' at row 1\nagente #417: SQLSTATE[01000]: Warning: 1265 Data truncated for column \'modalidade_snap\' at row 1',3),(3,'2026-05-09 22:28:01','2026-05-09 19:28:01','2026-04',0,2,'agente #278: SQLSTATE[01000]: Warning: 1265 Data truncated for column \'modalidade_snap\' at row 1\nagente #417: SQLSTATE[01000]: Warning: 1265 Data truncated for column \'modalidade_snap\' at row 1',1),(4,'2026-05-09 22:28:01','2026-05-09 19:28:01','2026-03',0,2,'agente #278: SQLSTATE[01000]: Warning: 1265 Data truncated for column \'modalidade_snap\' at row 1\nagente #417: SQLSTATE[01000]: Warning: 1265 Data truncated for column \'modalidade_snap\' at row 1',1),(5,'2026-05-09 22:56:19','2026-05-09 19:56:19','2024-10',0,2,'agente #278: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: \'0000-00-00\'\nagente #417: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: \'0000-00-00\'',5),(6,'2026-05-09 22:56:19','2026-05-09 19:56:19','2025-12',0,2,'agente #278: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: \'0000-00-00\'\nagente #417: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: \'0000-00-00\'',2),(7,'2026-05-09 22:56:19','2026-05-09 19:56:19','2026-01',0,2,'agente #278: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: \'0000-00-00\'\nagente #417: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: \'0000-00-00\'',2),(8,'2026-05-09 22:56:19','2026-05-09 19:56:19','2026-02',0,2,'agente #278: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: \'0000-00-00\'\nagente #417: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: \'0000-00-00\'',1),(9,'2026-05-09 22:56:50','2026-05-09 19:56:50','2024-10',2,0,NULL,5),(10,'2026-05-10 01:12:14','2026-05-09 22:12:14','2024-10',2,0,NULL,5),(11,'2026-05-10 01:12:14','2026-05-09 22:12:14','2025-12',2,0,NULL,3),(12,'2026-05-10 01:12:14','2026-05-09 22:12:14','2026-01',2,0,NULL,4),(13,'2026-05-10 01:12:14','2026-05-09 22:12:14','2026-02',2,0,NULL,4),(14,'2026-05-10 18:17:06','2026-05-10 15:17:06','2026-05',2,0,NULL,3),(15,'2026-05-10 18:17:06','2026-05-10 15:17:06','2026-04',2,0,NULL,2),(16,'2026-05-10 18:17:06','2026-05-10 15:17:06','2026-03',2,0,NULL,2),(17,'2026-05-10 18:17:06','2026-05-10 15:17:06','2026-02',2,0,NULL,4),(18,'2026-05-10 18:17:06','2026-05-10 15:17:06','2026-01',2,0,NULL,3),(19,'2026-05-10 18:17:06','2026-05-10 15:17:06','2025-12',2,0,NULL,3),(20,'2026-05-10 18:17:06','2026-05-10 15:17:06','2025-11',2,0,NULL,2),(21,'2026-05-10 18:17:06','2026-05-10 15:17:06','2025-10',2,0,NULL,2),(22,'2026-05-10 18:17:06','2026-05-10 15:17:06','2025-09',2,0,NULL,3),(23,'2026-05-10 18:17:06','2026-05-10 15:17:06','2025-08',2,0,NULL,2),(24,'2026-05-10 18:17:06','2026-05-10 15:17:06','2025-07',2,0,NULL,2),(25,'2026-05-10 18:17:06','2026-05-10 15:17:06','2025-06',2,0,NULL,2),(26,'2026-05-10 18:17:33','2026-05-10 15:17:33','2026-05',2,0,NULL,5),(27,'2026-05-10 18:17:33','2026-05-10 15:17:33','2026-04',2,0,NULL,3),(28,'2026-05-10 18:17:33','2026-05-10 15:17:33','2026-03',2,0,NULL,2),(29,'2026-05-10 18:17:33','2026-05-10 15:17:33','2026-02',2,0,NULL,4),(30,'2026-05-10 18:17:33','2026-05-10 15:17:33','2026-01',2,0,NULL,3),(31,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-12',2,0,NULL,3),(32,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-11',2,0,NULL,3),(33,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-10',2,0,NULL,3),(34,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-09',2,0,NULL,2),(35,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-08',2,0,NULL,2),(36,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-07',2,0,NULL,2),(37,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-06',2,0,NULL,2),(38,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-05',2,0,NULL,2),(39,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-04',2,0,NULL,2),(40,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-03',2,0,NULL,2),(41,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-02',2,0,NULL,2),(42,'2026-05-10 18:17:33','2026-05-10 15:17:33','2025-01',2,0,NULL,2),(43,'2026-05-10 18:17:33','2026-05-10 15:17:33','2024-12',2,0,NULL,2),(44,'2026-05-10 18:17:33','2026-05-10 15:17:33','2024-11',2,0,NULL,2),(45,'2026-05-10 18:17:33','2026-05-10 15:17:33','2024-10',1,0,NULL,1),(46,'2026-05-10 18:17:33','2026-05-10 15:17:33','2024-09',2,0,NULL,1),(47,'2026-05-10 18:17:33','2026-05-10 15:17:33','2024-08',2,0,NULL,2),(48,'2026-05-10 18:17:33','2026-05-10 15:17:33','2024-07',2,0,NULL,2),(49,'2026-05-10 18:17:33','2026-05-10 15:17:33','2024-06',2,0,NULL,2); /*!40000 ALTER TABLE `agente_log_cron` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `agente_log_acao` -- DROP TABLE IF EXISTS `agente_log_acao`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `agente_log_acao` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `usuario_id` int NOT NULL DEFAULT '0' COMMENT 'tbl_Usuario.id (0 quando DEV sem login)', `usuario_nome` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'snapshot do nome no momento da acao', `usuario_tpuser` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tef.Net | Revenda | Agente', `cod_Representante` int DEFAULT NULL COMMENT 'agente alvo da acao', `competencia` char(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'AAAA-MM', `acao` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'apurar | fechar | reabrir | resgate_solicitar | lote_liquidar | lote_estornar | rollback_executar | cron_manual', `status_resultado` enum('OK','ERRO') COLLATE utf8mb4_unicode_ci NOT NULL, `mensagem` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apuracao_id` bigint unsigned DEFAULT NULL, `lote_id` bigint unsigned DEFAULT NULL, `payload_resumo` text COLLATE utf8mb4_unicode_ci COMMENT 'JSON pequeno com contexto (max 500 chars)', `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ambiente` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'PROD' COMMENT 'DEV | PROD (DEV quando ?dev=1)', PRIMARY KEY (`id`), KEY `idx_log_data` (`created_at`), KEY `idx_log_acao_data` (`acao`,`created_at`), KEY `idx_log_cod_comp` (`cod_Representante`,`competencia`), KEY `idx_log_apuracao` (`apuracao_id`), KEY `idx_log_lote` (`lote_id`) ) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AUDIT#1 — log estruturado de acoes do app web/agente. Aprovado em 10/05/2026.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agente_log_acao` -- LOCK TABLES `agente_log_acao` WRITE; /*!40000 ALTER TABLE `agente_log_acao` DISABLE KEYS */; INSERT INTO `agente_log_acao` VALUES (1,'2026-05-10 12:00:06',999999,'DEV (sem login)','DEV',417,'2025-10','apurar','OK','Apurada: 6 titulos, comissao R$ 128,70',18,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":1287}','::1','curl/8.7.1','DEV'),(2,'2026-05-10 12:00:24',999999,'DEV (sem login)','DEV',417,'2025-09','apurar','OK','Apurada: 5 titulos, comissao R$ 94,09',19,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":940.91}','::1','curl/8.7.1','DEV'),(3,'2026-05-10 12:07:29',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_150729.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_150729.sql\",\"tamanho_kb\":25,\"duracao_ms\":356,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','curl/8.7.1','DEV'),(4,'2026-05-10 12:10:56',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_151056.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_151056.sql\",\"tamanho_kb\":25,\"duracao_ms\":27,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','curl/8.7.1','DEV'),(5,'2026-05-10 12:20:58',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(6,'2026-05-10 12:21:00',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_152100.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_152100.sql\",\"tamanho_kb\":26,\"duracao_ms\":37,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(7,'2026-05-10 12:23:41',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(8,'2026-05-10 12:23:41',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(9,'2026-05-10 12:23:42',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_152342.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_152342.sql\",\"tamanho_kb\":28,\"duracao_ms\":33,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(10,'2026-05-10 12:23:49',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(11,'2026-05-10 12:23:49',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(12,'2026-05-10 12:23:53',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_152353.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_152353.sql\",\"tamanho_kb\":29,\"duracao_ms\":28,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(13,'2026-05-10 12:24:13',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(14,'2026-05-10 15:17:06',0,'CLI/cron','CLI',NULL,NULL,'cron_manual','OK','Cron manual: 12 compet. 24 agentes-processados 0 erros (0.04s)',NULL,NULL,'{\"modo\":\"manual\",\"competencias\":[\"2026-05\",\"2026-04\",\"2026-03\",\"2026-02\",\"2026-01\",\"2025-12\",\"2025-11\",\"2025-10\",\"2025-09\",\"2025-08\",\"2025-07\",\"2025-06\"],\"agentes_processados\":24,\"agentes_com_erro\":0,\"duracao_s\":0.04}',NULL,NULL,'CLI'),(15,'2026-05-10 15:17:33',0,'CLI/cron','CLI',NULL,NULL,'cron_manual','OK','Cron manual: 24 compet. 47 agentes-processados 0 erros (0.07s)',NULL,NULL,'{\"modo\":\"manual\",\"competencias\":[\"2026-05\",\"2026-04\",\"2026-03\",\"2026-02\",\"2026-01\",\"2025-12\",\"2025-11\",\"2025-10\",\"2025-09\",\"2025-08\",\"2025-07\",\"2025-06\",\"2025-05\",\"2025-04\",\"2025-03\",\"2025-02\",\"2025-01\",\"2024-12\",\"2024-11\",\"2024-10\",\"2024-09\",\"2024-08\",\"2024-07\",\"2024-06\"],\"agentes_processados\":47,\"agentes_com_erro\":0,\"duracao_s\":0.07}',NULL,NULL,'CLI'),(16,'2026-05-10 15:19:18',999999,'DEV (sem login)','DEV',417,'2024-12','fechar','OK','Transicao fechar executada (status_novo=fechada)',47,NULL,NULL,'::1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36','DEV'),(17,'2026-05-10 15:26:47',999999,'DEV (sem login)','DEV',417,'2024-12','resgate_solicitar','OK','Lote LR-2024-0002 criado: 1 itens, total R$ 17,20',47,2,NULL,'::1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36','DEV'),(18,'2026-05-10 17:02:47',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(19,'2026-05-10 17:02:59',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(20,'2026-05-10 17:02:59',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(21,'2026-05-10 17:02:59',999999,'DEV (sem login)','DEV',417,'2025-08','reabrir','OK','Transicao reabrir executada (status_novo=apurada)',20,NULL,'{\"motivo\":\"spec DT#23 — teste de regressão\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(22,'2026-05-10 17:02:59',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(23,'2026-05-10 17:03:05',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(24,'2026-05-10 17:03:05',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(25,'2026-05-10 17:03:05',999999,'DEV (sem login)','DEV',417,'2025-08','reabrir','OK','Transicao reabrir executada (status_novo=apurada)',20,NULL,'{\"motivo\":\"spec DT#23 — teste de regressão\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(26,'2026-05-10 17:03:05',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(27,'2026-05-10 17:50:14',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(28,'2026-05-10 17:50:43',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(29,'2026-05-10 17:51:17',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(30,'2026-05-10 17:51:40',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(31,'2026-05-10 17:51:52',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(32,'2026-05-10 17:51:52',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(33,'2026-05-10 17:51:52',999999,'DEV (sem login)','DEV',417,'2025-08','reabrir','OK','Transicao reabrir executada (status_novo=apurada)',20,NULL,'{\"motivo\":\"spec DT#23 — teste de regressão\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(34,'2026-05-10 17:51:52',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(35,'2026-05-10 17:51:52',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(36,'2026-05-10 17:51:58',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_205158.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_205158.sql\",\"tamanho_kb\":47,\"duracao_ms\":42,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(37,'2026-05-10 17:52:07',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(38,'2026-05-10 17:52:20',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(39,'2026-05-10 17:52:24',999999,'DEV (sem login)','DEV',417,'2026-01','fechar','OK','Transicao fechar executada (status_novo=fechada)',15,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(40,'2026-05-10 17:52:24',999999,'DEV (sem login)','DEV',417,'2026-01','reabrir','OK','Transicao reabrir executada (status_novo=apurada)',15,NULL,'{\"motivo\":\"restauracao spec UI#23 Onda 5\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(41,'2026-05-10 17:52:42',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(42,'2026-05-10 17:52:42',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(43,'2026-05-10 17:52:42',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(44,'2026-05-10 17:52:42',999999,'DEV (sem login)','DEV',417,'2025-08','reabrir','OK','Transicao reabrir executada (status_novo=apurada)',20,NULL,'{\"motivo\":\"spec DT#23 — teste de regressão\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(45,'2026-05-10 17:52:42',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(46,'2026-05-10 17:52:48',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_205248.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_205248.sql\",\"tamanho_kb\":51,\"duracao_ms\":31,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(47,'2026-05-10 17:52:57',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(48,'2026-05-10 17:53:09',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(49,'2026-05-10 17:54:42',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(50,'2026-05-10 17:54:54',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":50,\"title_changed\":false,\"version_new\":2}','::1','curl/8.7.1','DEV'),(51,'2026-05-10 17:55:03',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":50,\"hint_new_len\":85,\"title_changed\":false,\"version_new\":3}','::1','curl/8.7.1','DEV'),(52,'2026-05-10 18:09:36',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":4}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(53,'2026-05-10 18:10:28',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":4}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(54,'2026-05-10 18:38:15',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(55,'2026-05-10 18:38:15',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(56,'2026-05-10 18:38:15',999999,'DEV (sem login)','DEV',417,'2025-08','reabrir','OK','Transicao reabrir executada (status_novo=apurada)',20,NULL,'{\"motivo\":\"spec DT#23 — teste de regressão\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(57,'2026-05-10 18:38:15',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(58,'2026-05-10 18:38:15',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(59,'2026-05-10 18:38:22',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_213822.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_213822.sql\",\"tamanho_kb\":55,\"duracao_ms\":107,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(60,'2026-05-10 18:38:27',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":4}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(61,'2026-05-10 18:38:45',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(62,'2026-05-10 18:40:14',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(63,'2026-05-10 18:40:14',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(64,'2026-05-10 18:40:14',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(65,'2026-05-10 18:40:14',999999,'DEV (sem login)','DEV',417,'2025-08','reabrir','OK','Transicao reabrir executada (status_novo=apurada)',20,NULL,'{\"motivo\":\"spec DT#23 — teste de regressão\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(66,'2026-05-10 18:40:14',999999,'DEV (sem login)','DEV',417,'2025-08','fechar','OK','Transicao fechar executada (status_novo=fechada)',20,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(67,'2026-05-10 18:40:22',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_214022.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_214022.sql\",\"tamanho_kb\":58,\"duracao_ms\":56,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(68,'2026-05-10 18:40:27',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":4}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(69,'2026-05-10 18:40:40',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(70,'2026-05-10 19:45:07',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(71,'2026-05-10 19:46:05',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":4}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(72,'2026-05-10 19:46:30',999999,'DEV (sem login)','DEV',NULL,NULL,'hint_edit','OK','hint_edit key=nav-dashboard',NULL,NULL,'{\"key\":\"nav-dashboard\",\"hint_old_len\":85,\"hint_new_len\":55,\"title_changed\":false,\"version_new\":4}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(73,'2026-05-10 20:56:59',999999,'DEV (sem login)','DEV',NULL,NULL,'diretrizes_nf_save','OK','diretrizes_nf_save size=72',NULL,NULL,'{\"size_bytes\":72,\"updated_at\":\"2026-05-10T23:56:59+00:00\"}','::1','curl/8.7.1','DEV'),(74,'2026-05-10 20:57:59',999999,'DEV (sem login)','DEV',NULL,NULL,'diretrizes_nf_save','OK','diretrizes_nf_save size=963',NULL,NULL,'{\"size_bytes\":963,\"updated_at\":\"2026-05-10T23:57:59+00:00\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(75,'2026-05-10 20:58:38',999999,'DEV (sem login)','DEV',NULL,NULL,'diretrizes_nf_save','OK','diretrizes_nf_save size=996',NULL,NULL,'{\"size_bytes\":996,\"updated_at\":\"2026-05-10T23:58:38+00:00\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(76,'2026-05-10 20:58:46',999999,'DEV (sem login)','DEV',NULL,NULL,'backup_criar','OK','Backup gerado: snapshot_20260510_235846.sql',NULL,NULL,'{\"arquivo\":\"snapshot_20260510_235846.sql\",\"tamanho_kb\":61,\"duracao_ms\":106,\"tabelas\":[\"agente_apuracao_periodos\",\"agente_apuracao_itens\",\"agente_lote_resgate\",\"agente_lote_item\",\"agente_critica_resgate\",\"agente_log_cron\",\"agente_log_acao\"]}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(77,'2026-05-10 20:58:48',999999,'DEV (sem login)','DEV',NULL,NULL,'diretrizes_nf_save','OK','diretrizes_nf_save size=1029',NULL,NULL,'{\"size_bytes\":1029,\"updated_at\":\"2026-05-10T23:58:48+00:00\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(78,'2026-05-10 20:59:48',999999,'DEV (sem login)','DEV',NULL,NULL,'diretrizes_nf_save','OK','diretrizes_nf_save size=963',NULL,NULL,'{\"size_bytes\":963,\"updated_at\":\"2026-05-10T23:59:48+00:00\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(79,'2026-05-10 21:00:12',999999,'DEV (sem login)','DEV',NULL,NULL,'diretrizes_nf_save','OK','diretrizes_nf_save size=1034',NULL,NULL,'{\"size_bytes\":1034,\"updated_at\":\"2026-05-11T00:00:12+00:00\"}','::1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36','DEV'),(80,'2026-05-10 21:13:31',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Lote LR-2026-0001 criado: 11 itens, total R$ 208,70',15,3,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(81,'2026-05-10 21:13:31',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(82,'2026-05-10 21:13:32',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Lote LR-2026-0002 criado: 21 itens, total R$ 375,70',17,4,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(83,'2026-05-10 21:13:52',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=pendente_aprovacao, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(84,'2026-05-10 21:13:52',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0002 ja existia (status=pendente_aprovacao, total R$ 375,70)',17,4,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(85,'2026-05-10 21:13:52',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(86,'2026-05-10 21:14:45',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0002 ja existia (status=pendente_aprovacao, total R$ 375,70)',17,4,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','curl/8.7.1','DEV'),(87,'2026-05-10 21:15:10',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=pendente_aprovacao, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(88,'2026-05-10 21:15:10',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0002 ja existia (status=pendente_aprovacao, total R$ 375,70)',17,4,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(89,'2026-05-10 21:15:10',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(90,'2026-05-10 21:32:44',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2026-0001 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 208,70)',NULL,3,'{\"numero_humano\":\"LR-2026-0001\",\"total\":208.7}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(91,'2026-05-10 21:32:44',999999,'DEV (sem login)','DEV',417,NULL,'resgate_reprovar','OK','Lote LR-2026-0002 reprovado (Tef.Net): motivo=Teste automatizado RES#2 Sprint B — falta NF para esta competencia.; itens devolvidos=21',NULL,4,'{\"numero_humano\":\"LR-2026-0002\",\"motivo_resumo\":\"Teste automatizado RES#2 Sprint B — falta NF para esta competencia.\",\"itens_devolvidos\":21,\"itens_restaurados\":21,\"total\":375.7}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(92,'2026-05-10 21:33:50',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Lote LR-2026-0003 criado: 21 itens, total R$ 375,70',17,5,NULL,'::1','curl/8.7.1','DEV'),(93,'2026-05-10 21:33:50',999999,'DEV (sem login)','DEV',417,'2025-12','resgate_solicitar','OK','Lote LR-2025-0001 criado: 9 itens, total R$ 176,70',13,6,NULL,'::1','curl/8.7.1','DEV'),(94,'2026-05-10 21:33:56',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2026-0003 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 375,70)',NULL,5,'{\"numero_humano\":\"LR-2026-0003\",\"total\":375.7}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(95,'2026-05-10 21:33:56',999999,'DEV (sem login)','DEV',417,NULL,'resgate_reprovar','OK','Lote LR-2025-0001 reprovado (Tef.Net): motivo=Teste automatizado RES#2 Sprint B — falta NF para esta competencia.; itens devolvidos=9',NULL,6,'{\"numero_humano\":\"LR-2025-0001\",\"motivo_resumo\":\"Teste automatizado RES#2 Sprint B — falta NF para esta competencia.\",\"itens_devolvidos\":9,\"itens_restaurados\":9,\"total\":176.7}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(96,'2026-05-10 21:34:19',999999,'DEV (sem login)','DEV',417,'2025-11','resgate_solicitar','OK','Lote LR-2025-0002 criado: 7 itens, total R$ 148,20',28,7,NULL,'::1','curl/8.7.1','DEV'),(97,'2026-05-10 21:34:19',999999,'DEV (sem login)','DEV',417,'2025-10','resgate_solicitar','OK','Lote LR-2025-0003 criado: 6 itens, total R$ 128,70',18,8,NULL,'::1','curl/8.7.1','DEV'),(98,'2026-05-10 21:47:32',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2025-0003 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 128,70)',NULL,8,'{\"numero_humano\":\"LR-2025-0003\",\"total\":128.7}','::1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36','DEV'),(99,'2026-05-10 21:47:38',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2025-0002 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 148,20)',NULL,7,'{\"numero_humano\":\"LR-2025-0002\",\"total\":148.2}','::1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36','DEV'),(100,'2026-05-10 21:49:49',999999,'DEV (sem login)','DEV',417,'2025-12','resgate_solicitar','OK','Lote LR-2025-0004 criado (Sprint C): 9 itens, total R$ 176,70, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',13,9,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":176.7}','::1','curl/8.7.1','DEV'),(101,'2026-05-10 21:50:23',999999,'DEV (sem login)','DEV',417,'2025-12','resgate_solicitar','OK','Lote LR-2025-0004 criado (Sprint C): 9 itens, total R$ 176,70, forma_pag=boleto, NF=resgate/2026-05/3e02cdb5f99308d6.pdf, Boleto=resgate/2026-05/3e02cdb5f99308d6.pdf',13,10,'{\"forma_pag\":\"boleto\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"total\":176.7}','::1','curl/8.7.1','DEV'),(102,'2026-05-10 21:50:39',999999,'DEV (sem login)','DEV',417,'2025-12','resgate_solicitar','OK','Idempotente: lote LR-2025-0004 ja existia',13,10,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','curl/8.7.1','DEV'),(103,'2026-05-10 21:52:11',999999,'DEV (sem login)','DEV',417,'2025-12','resgate_solicitar','OK','Lote LR-2025-0004 criado (Sprint C): 9 itens, total R$ 176,70, forma_pag=boleto, NF=resgate/2026-05/3e02cdb5f99308d6.pdf, Boleto=resgate/2026-05/3e02cdb5f99308d6.pdf',13,11,'{\"forma_pag\":\"boleto\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"total\":176.7}','::1','curl/8.7.1','DEV'),(104,'2026-05-10 21:52:11',999999,'DEV (sem login)','DEV',417,'2025-12','resgate_solicitar','OK','Idempotente: lote LR-2025-0004 ja existia',13,11,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','curl/8.7.1','DEV'),(105,'2026-05-10 21:53:24',999999,'DEV (sem login)','DEV',417,'2025-09','resgate_solicitar','OK','Lote LR-2025-0005 criado (Sprint C): 5 itens, total R$ 94,09, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',19,12,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":94.09}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(106,'2026-05-10 21:53:31',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(107,'2026-05-10 21:53:31',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(108,'2026-05-10 21:53:31',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(109,'2026-05-10 21:53:31',999999,'DEV (sem login)','DEV',417,'2025-09','resgate_solicitar','OK','Idempotente: lote LR-2025-0005 ja existia',19,12,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(110,'2026-05-10 21:53:33',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2025-0004 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 176,70)',NULL,11,'{\"numero_humano\":\"LR-2025-0004\",\"total\":176.7}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(111,'2026-05-10 21:53:33',999999,'DEV (sem login)','DEV',417,NULL,'resgate_reprovar','OK','Lote LR-2025-0005 reprovado (Tef.Net): motivo=Teste automatizado RES#2 Sprint B — falta NF para esta competencia.; itens devolvidos=5',NULL,12,'{\"numero_humano\":\"LR-2025-0005\",\"motivo_resumo\":\"Teste automatizado RES#2 Sprint B — falta NF para esta competencia.\",\"itens_devolvidos\":5,\"itens_restaurados\":5,\"total\":94.09}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(112,'2026-05-10 21:54:14',999999,'DEV (sem login)','DEV',417,'2025-01','resgate_solicitar','OK','Lote LR-2025-0006 criado (Sprint C): 1 itens, total R$ 17,20, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',45,13,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(113,'2026-05-10 21:54:19',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(114,'2026-05-10 21:54:19',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(115,'2026-05-10 21:54:19',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(116,'2026-05-10 21:54:19',999999,'DEV (sem login)','DEV',417,'2025-01','resgate_solicitar','OK','Idempotente: lote LR-2025-0006 ja existia',45,13,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(117,'2026-05-10 21:54:20',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2025-0006 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 17,20)',NULL,13,'{\"numero_humano\":\"LR-2025-0006\",\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(118,'2026-05-10 21:54:29',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(119,'2026-05-10 21:54:29',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(120,'2026-05-10 21:54:29',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(121,'2026-05-10 21:54:29',999999,'DEV (sem login)','DEV',417,'2025-01','resgate_solicitar','OK','Idempotente: lote LR-2025-0006 ja existia',45,13,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(122,'2026-05-10 21:54:58',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(123,'2026-05-10 21:54:58',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(124,'2026-05-10 21:54:58',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(125,'2026-05-10 21:54:58',999999,'DEV (sem login)','DEV',417,'2024-11','resgate_solicitar','OK','Lote LR-2024-0003 criado (Sprint C): 1 itens, total R$ 17,20, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',49,14,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(126,'2026-05-10 21:54:59',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2024-0003 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 17,20)',NULL,14,'{\"numero_humano\":\"LR-2024-0003\",\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(127,'2026-05-10 21:55:21',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(128,'2026-05-10 21:55:21',999999,'DEV (sem login)','DEV',417,'2025-12','resgate_solicitar','OK','Idempotente: lote LR-2025-0004 ja existia (status=aguardando_pagamento, total R$ 176,70)',13,11,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(129,'2026-05-10 21:57:00',999999,'DEV (sem login)','DEV',417,'2024-11','resgate_solicitar','OK','Idempotente: lote LR-2024-0003 ja existia',49,14,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(130,'2026-05-10 21:57:12',999999,'DEV (sem login)','DEV',417,'2024-11','resgate_solicitar','OK','Idempotente: lote LR-2024-0003 ja existia',49,14,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(131,'2026-05-10 21:58:29',999999,'DEV (sem login)','DEV',417,'2024-11','resgate_solicitar','OK','Idempotente: lote LR-2024-0003 ja existia',49,14,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(132,'2026-05-10 21:58:29',999999,'DEV (sem login)','DEV',417,'2025-01','resgate_solicitar','OK','Idempotente: lote LR-2025-0006 ja existia',45,13,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(133,'2026-05-10 21:58:29',999999,'DEV (sem login)','DEV',417,'2025-02','resgate_solicitar','OK','Lote LR-2025-0007 criado (Sprint C): 1 itens, total R$ 17,20, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',43,15,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(134,'2026-05-10 21:58:34',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(135,'2026-05-10 21:58:35',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(136,'2026-05-10 21:58:35',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(137,'2026-05-10 21:58:35',999999,'DEV (sem login)','DEV',417,'2024-11','resgate_solicitar','OK','Idempotente: lote LR-2024-0003 ja existia',49,14,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(138,'2026-05-10 21:58:35',999999,'DEV (sem login)','DEV',417,'2025-01','resgate_solicitar','OK','Idempotente: lote LR-2025-0006 ja existia',45,13,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(139,'2026-05-10 21:58:35',999999,'DEV (sem login)','DEV',417,'2025-02','resgate_solicitar','OK','Idempotente: lote LR-2025-0007 ja existia',43,15,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(140,'2026-05-10 21:58:35',999999,'DEV (sem login)','DEV',417,'2025-03','resgate_solicitar','OK','Lote LR-2025-0008 criado (Sprint C): 1 itens, total R$ 17,20, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',41,16,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(141,'2026-05-10 21:58:37',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2025-0007 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 17,20)',NULL,15,'{\"numero_humano\":\"LR-2025-0007\",\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(142,'2026-05-10 21:58:37',999999,'DEV (sem login)','DEV',417,NULL,'resgate_reprovar','OK','Lote LR-2025-0008 reprovado (Tef.Net): motivo=Teste automatizado RES#2 Sprint B — falta NF para esta competencia.; itens devolvidos=1',NULL,16,'{\"numero_humano\":\"LR-2025-0008\",\"motivo_resumo\":\"Teste automatizado RES#2 Sprint B — falta NF para esta competencia.\",\"itens_devolvidos\":1,\"itens_restaurados\":1,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(143,'2026-05-10 22:50:45',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(144,'2026-05-10 22:50:45',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(145,'2026-05-10 22:50:45',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(146,'2026-05-10 22:50:45',999999,'DEV (sem login)','DEV',417,'2024-11','resgate_solicitar','OK','Idempotente: lote LR-2024-0003 ja existia',49,14,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(147,'2026-05-10 22:50:45',999999,'DEV (sem login)','DEV',417,'2025-01','resgate_solicitar','OK','Idempotente: lote LR-2025-0006 ja existia',45,13,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(148,'2026-05-10 22:50:45',999999,'DEV (sem login)','DEV',417,'2025-02','resgate_solicitar','OK','Idempotente: lote LR-2025-0007 ja existia',43,15,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(149,'2026-05-10 22:50:45',999999,'DEV (sem login)','DEV',417,'2025-03','resgate_solicitar','OK','Lote LR-2025-0009 criado (Sprint C): 1 itens, total R$ 17,20, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',41,17,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(150,'2026-05-10 22:51:20',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(151,'2026-05-10 22:51:20',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(152,'2026-05-10 22:51:20',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(153,'2026-05-10 22:51:20',999999,'DEV (sem login)','DEV',417,'2024-11','resgate_solicitar','OK','Idempotente: lote LR-2024-0003 ja existia',49,14,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(154,'2026-05-10 22:51:20',999999,'DEV (sem login)','DEV',417,'2025-01','resgate_solicitar','OK','Idempotente: lote LR-2025-0006 ja existia',45,13,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(155,'2026-05-10 22:51:20',999999,'DEV (sem login)','DEV',417,'2025-02','resgate_solicitar','OK','Idempotente: lote LR-2025-0007 ja existia',43,15,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(156,'2026-05-10 22:51:20',999999,'DEV (sem login)','DEV',417,'2025-03','resgate_solicitar','OK','Idempotente: lote LR-2025-0009 ja existia',41,17,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(157,'2026-05-10 22:51:20',999999,'DEV (sem login)','DEV',417,'2025-04','resgate_solicitar','OK','Lote LR-2025-0010 criado (Sprint C): 1 itens, total R$ 17,20, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',39,18,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(158,'2026-05-10 22:51:21',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2025-0010 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 17,20)',NULL,18,'{\"numero_humano\":\"LR-2025-0010\",\"total\":17.2,\"data_prev_pag\":null}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(159,'2026-05-10 22:51:58',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(160,'2026-05-10 22:51:58',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(161,'2026-05-10 22:51:58',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(162,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2026-01','resgate_solicitar','OK','Idempotente: lote LR-2026-0001 ja existia (status=aguardando_pagamento, total R$ 208,70)',15,3,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(163,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2026-02','resgate_solicitar','OK','Idempotente: lote LR-2026-0003 ja existia (status=aguardando_pagamento, total R$ 375,70)',17,5,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(164,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(165,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2024-11','resgate_solicitar','OK','Idempotente: lote LR-2024-0003 ja existia',49,14,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(166,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2025-01','resgate_solicitar','OK','Idempotente: lote LR-2025-0006 ja existia',45,13,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(167,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2025-02','resgate_solicitar','OK','Idempotente: lote LR-2025-0007 ja existia',43,15,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(168,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2025-03','resgate_solicitar','OK','Idempotente: lote LR-2025-0009 ja existia',41,17,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(169,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2025-04','resgate_solicitar','OK','Idempotente: lote LR-2025-0010 ja existia',39,18,'{\"codigo\":\"LOTE_JA_EXISTENTE\",\"forma_pag\":\"pix\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(170,'2026-05-10 22:52:29',999999,'DEV (sem login)','DEV',417,'2025-05','resgate_solicitar','OK','Lote LR-2025-0011 criado (Sprint C): 1 itens, total R$ 17,20, forma_pag=pix, NF=resgate/2026-05/3e02cdb5f99308d6.pdf',37,19,'{\"forma_pag\":\"pix\",\"nf_key\":\"resgate/2026-05/3e02cdb5f99308d6.pdf\",\"boleto_key\":null,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(171,'2026-05-10 22:52:30',999999,'DEV (sem login)','DEV',417,NULL,'resgate_aprovar','OK','Lote LR-2025-0011 aprovado (Tef.Net): pendente_aprovacao -> aguardando_pagamento (total R$ 17,20)',NULL,19,'{\"numero_humano\":\"LR-2025-0011\",\"total\":17.2,\"data_prev_pag\":null}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(172,'2026-05-10 22:52:30',999999,'DEV (sem login)','DEV',417,NULL,'resgate_reprovar','OK','Lote LR-2025-0009 reprovado (Tef.Net): motivo=Teste automatizado RES#2 Sprint B — falta NF para esta competencia.; itens devolvidos=1',NULL,17,'{\"numero_humano\":\"LR-2025-0009\",\"motivo_resumo\":\"Teste automatizado RES#2 Sprint B — falta NF para esta competencia.\",\"itens_devolvidos\":1,\"itens_restaurados\":1,\"total\":17.2}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(173,'2026-05-10 22:52:37',999999,'DEV (sem login)','DEV',417,'2025-08','apurar','OK','Apurada: 3 titulos, comissao R$ 70,40',20,NULL,'{\"modalidade_snap\":\"pct_cliente_final\",\"total_titulos_pagos\":715.19}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'),(174,'2026-05-10 22:52:37',999999,'DEV (sem login)','DEV',417,'2024-10','resgate_solicitar','OK','Idempotente: lote LR-2024-0001 ja existia (status=aguardando_pagamento, total R$ 17,20)',11,1,'{\"codigo\":\"LOTE_JA_EXISTENTE\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.7727.15 Safari/537.36','DEV'); /*!40000 ALTER TABLE `agente_log_acao` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-05-10 22:52:46