--
-- Host: 164.152.61.60    Database: gestornow
-- ------------------------------------------------------


--
-- Table structure for table `acessorios`
--

CREATE TABLE `acessorios` (
  `id_acessorio` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `nome` varchar(255) DEFAULT NULL,
  `descricao` text DEFAULT NULL,
  `quantidade` int(11) DEFAULT NULL,
  `preco_custo` decimal(15,2) DEFAULT NULL,
  `valor` decimal(15,2) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_acessorio`),
  KEY `acessorios_id_empresa_index` (`id_empresa`),
  CONSTRAINT `acessorios_id_empresa_foreign` FOREIGN KEY (`id_empresa`) REFERENCES `empresa` (`id_empresa`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `acessorios`
--


--
-- Table structure for table `assinaturas_planos`
--

CREATE TABLE `assinaturas_planos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_plano` bigint(20) unsigned DEFAULT NULL,
  `id_plano_contratado` bigint(20) unsigned DEFAULT NULL,
  `origem` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `metodo_adesao` varchar(255) DEFAULT NULL,
  `metodo_mensal` varchar(255) DEFAULT NULL,
  `asaas_customer_id` varchar(255) DEFAULT NULL,
  `asaas_subscription_id` varchar(255) DEFAULT NULL,
  `proxima_cobranca_em` date DEFAULT NULL,
  `ultimo_pagamento_em` datetime DEFAULT NULL,
  `inadimplente_desde` date DEFAULT NULL,
  `bloqueada_por_inadimplencia` tinyint(1) NOT NULL DEFAULT 0,
  `observacoes` text DEFAULT NULL,
  `cancelamento_solicitado_em` datetime DEFAULT NULL,
  `cancelamento_efetivo_em` date DEFAULT NULL,
  `motivo_cancelamento` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assinaturas_planos_id_empresa_index` (`id_empresa`),
  KEY `assinaturas_planos_id_plano_index` (`id_plano`),
  KEY `assinaturas_planos_id_plano_contratado_index` (`id_plano_contratado`),
  KEY `assinaturas_planos_asaas_customer_id_index` (`asaas_customer_id`),
  KEY `assinaturas_planos_asaas_subscription_id_index` (`asaas_subscription_id`),
  CONSTRAINT `assinaturas_planos_id_plano_contratado_foreign` FOREIGN KEY (`id_plano_contratado`) REFERENCES `planos_contratados` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assinaturas_planos_id_plano_foreign` FOREIGN KEY (`id_plano`) REFERENCES `planos` (`id_plano`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assinaturas_planos`
--

INSERT INTO `assinaturas_planos` VALUES
(7,4,2,10,'dashboard','ativa','CREDIT_CARD','BOLETO','cus_000166512756','sub_qznyk1fzthd63bmz','2026-05-16','2026-04-02 17:09:18','2026-03-17',0,'Contratação via dashboard do cliente.',NULL,NULL,NULL,'2026-03-17 17:18:02','2026-04-02 17:09:18'),
(8,13,1,13,'comercial','onboarding_dados','PIX','BOLETO',NULL,NULL,NULL,NULL,NULL,0,'Contratação realizada pelo time comercial.',NULL,NULL,NULL,'2026-03-30 22:51:40','2026-03-30 22:51:40');

--
-- Table structure for table `assinaturas_planos_pagamentos`
--

CREATE TABLE `assinaturas_planos_pagamentos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_assinatura_plano` bigint(20) unsigned DEFAULT NULL,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_plano` bigint(20) unsigned DEFAULT NULL,
  `id_plano_contratado` bigint(20) unsigned DEFAULT NULL,
  `tipo_cobranca` varchar(255) DEFAULT NULL,
  `competencia` date DEFAULT NULL,
  `metodo_pagamento` varchar(255) DEFAULT NULL,
  `asaas_payment_id` varchar(255) DEFAULT NULL,
  `asaas_invoice_url` varchar(255) DEFAULT NULL,
  `asaas_bank_slip_url` varchar(255) DEFAULT NULL,
  `asaas_pix_qr_code` varchar(255) DEFAULT NULL,
  `asaas_pix_copy_paste` varchar(255) DEFAULT NULL,
  `valor` decimal(15,2) DEFAULT NULL,
  `data_vencimento` date DEFAULT NULL,
  `data_pagamento` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `json_resposta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`json_resposta`)),
  `json_webhook` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`json_webhook`)),
  `tentativas` int(11) DEFAULT NULL,
  `observacoes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assinaturas_planos_pagamentos_id_assinatura_plano_index` (`id_assinatura_plano`),
  KEY `assinaturas_planos_pagamentos_id_empresa_index` (`id_empresa`),
  KEY `assinaturas_planos_pagamentos_id_plano_index` (`id_plano`),
  KEY `assinaturas_planos_pagamentos_id_plano_contratado_index` (`id_plano_contratado`),
  KEY `assinaturas_planos_pagamentos_asaas_payment_id_index` (`asaas_payment_id`),
  CONSTRAINT `assinaturas_planos_pagamentos_id_assinatura_plano_foreign` FOREIGN KEY (`id_assinatura_plano`) REFERENCES `assinaturas_planos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assinaturas_planos_pagamentos_id_plano_contratado_foreign` FOREIGN KEY (`id_plano_contratado`) REFERENCES `planos_contratados` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assinaturas_planos_pagamentos_id_plano_foreign` FOREIGN KEY (`id_plano`) REFERENCES `planos` (`id_plano`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assinaturas_planos_pagamentos`
--

INSERT INTO `assinaturas_planos_pagamentos` VALUES
(10,7,4,2,NULL,'adesao','2026-03-01','CREDIT_CARD','pay_782q91nqcxybtf69','https://www.asaas.com/i/782q91nqcxybtf69',NULL,NULL,NULL,99.90,'2026-03-17','2026-03-18 00:00:00','pago','{\"object\":\"payment\",\"id\":\"pay_782q91nqcxybtf69\",\"dateCreated\":\"2026-03-17\",\"customer\":\"cus_000166512756\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":99.9,\"netValue\":97.43,\"originalValue\":null,\"interestValue\":null,\"description\":\"Ades\\u00e3o do plano Plano Start\",\"billingType\":\"CREDIT_CARD\",\"confirmedDate\":null,\"creditCard\":null,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-17\",\"originalDueDate\":\"2026-03-17\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/782q91nqcxybtf69\",\"invoiceNumber\":\"767540349\",\"externalReference\":\"ASSINATURA:7:ADESAO:202603\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":null,\"bankSlipUrl\":null,\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}','{\"id\":\"evt_7d80d3d873fd3e32dbd575b350f1b4b5&1266543806\",\"event\":\"PAYMENT_ANTICIPATED\",\"dateCreated\":\"2026-03-23 09:00:11\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_782q91nqcxybtf69\",\"dateCreated\":\"2026-03-17\",\"customer\":\"cus_000166512756\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":99.9,\"netValue\":99.9,\"originalValue\":null,\"interestValue\":null,\"description\":\"Ades\\u00e3o do plano Plano Start\",\"billingType\":\"CREDIT_CARD\",\"confirmedDate\":\"2026-03-18\",\"creditCard\":{\"creditCardNumber\":\"2161\",\"creditCardBrand\":\"MASTERCARD\"},\"pixTransaction\":null,\"status\":\"CONFIRMED\",\"dueDate\":\"2026-03-17\",\"originalDueDate\":\"2026-03-17\",\"paymentDate\":null,\"clientPaymentDate\":\"2026-03-18\",\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/782q91nqcxybtf69\",\"invoiceNumber\":\"767540349\",\"externalReference\":\"ASSINATURA:7:ADESAO:202603\",\"deleted\":false,\"anticipated\":true,\"anticipable\":false,\"creditDate\":\"2026-04-20\",\"estimatedCreditDate\":\"2026-04-20\",\"transactionReceiptUrl\":\"https:\\/\\/www.asaas.com\\/comprovantes\\/2520010383930293\",\"nossoNumero\":null,\"bankSlipUrl\":null,\"lastInvoiceViewedDate\":\"2026-03-18T22:46:49Z\",\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}',0,NULL,'2026-03-17 17:18:03','2026-03-23 09:00:11'),
(11,7,4,2,NULL,'mensalidade','2026-04-01','BOLETO','pay_cnjk9lmx4d880tur','https://www.asaas.com/i/cnjk9lmx4d880tur','https://www.asaas.com/b/pdf/cnjk9lmx4d880tur',NULL,NULL,99.90,'2026-04-16','2026-04-02 00:00:00','pago','{\"object\":\"payment\",\"id\":\"pay_cnjk9lmx4d880tur\",\"dateCreated\":\"2026-03-17\",\"customer\":\"cus_000166512756\",\"subscription\":\"sub_qznyk1fzthd63bmz\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":99.9,\"netValue\":98.91,\"originalValue\":null,\"interestValue\":null,\"description\":\"Assinatura mensal do plano Plano Start\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-16\",\"originalDueDate\":\"2026-04-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/cnjk9lmx4d880tur\",\"invoiceNumber\":\"767540356\",\"externalReference\":\"ASSINATURA:7:SUBSCRIPTION\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"421844472\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/cnjk9lmx4d880tur\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}','{\"id\":\"evt_d26e303b238e509335ac9ba210e51b0f&1279783693\",\"event\":\"PAYMENT_RECEIVED\",\"dateCreated\":\"2026-04-02 17:09:17\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_cnjk9lmx4d880tur\",\"dateCreated\":\"2026-03-17\",\"customer\":\"cus_000166512756\",\"subscription\":\"sub_qznyk1fzthd63bmz\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":99.9,\"netValue\":98.91,\"originalValue\":null,\"interestValue\":null,\"description\":\"Assinatura mensal do plano Plano Start\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"confirmedDate\":\"2026-04-02\",\"pixTransaction\":null,\"status\":\"RECEIVED\",\"dueDate\":\"2026-04-16\",\"originalDueDate\":\"2026-04-16\",\"paymentDate\":\"2026-04-02\",\"clientPaymentDate\":\"2026-04-02\",\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/cnjk9lmx4d880tur\",\"invoiceNumber\":\"767540356\",\"externalReference\":\"ASSINATURA:7:SUBSCRIPTION\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":\"2026-04-02\",\"estimatedCreditDate\":\"2026-04-02\",\"transactionReceiptUrl\":\"https:\\/\\/www.asaas.com\\/comprovantes\\/h\\/UEFZTUVOVF9SRUNFSVZFRDpwYXlfY25qazlsbXg0ZDg4MHR1cg%3D%3D\",\"nossoNumero\":\"421844472\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/cnjk9lmx4d880tur\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}',0,'Mensalidade vinculada a assinatura recorrente do Asaas.','2026-03-17 17:18:03','2026-04-02 17:09:18'),
(12,7,4,2,10,'mensalidade','2026-05-01','BOLETO','pay_n3i5voch3xezt6x5','https://www.asaas.com/i/n3i5voch3xezt6x5','https://www.asaas.com/b/pdf/n3i5voch3xezt6x5',NULL,NULL,99.90,'2026-05-16',NULL,'pendente','{\"object\":\"payment\",\"id\":\"pay_n3i5voch3xezt6x5\",\"dateCreated\":\"2026-04-07\",\"customer\":\"cus_000166512756\",\"subscription\":\"sub_qznyk1fzthd63bmz\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":99.9,\"netValue\":98.91,\"originalValue\":null,\"interestValue\":null,\"description\":\"Assinatura mensal do plano Plano Start\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-05-16\",\"originalDueDate\":\"2026-05-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/n3i5voch3xezt6x5\",\"invoiceNumber\":\"782173593\",\"externalReference\":\"ASSINATURA:7:SUBSCRIPTION\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"428752972\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/n3i5voch3xezt6x5\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}','{\"id\":\"evt_05b708f961d739ea7eba7e4db318f621&1283957186\",\"event\":\"PAYMENT_CREATED\",\"dateCreated\":\"2026-04-07 00:39:02\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_n3i5voch3xezt6x5\",\"dateCreated\":\"2026-04-07\",\"customer\":\"cus_000166512756\",\"subscription\":\"sub_qznyk1fzthd63bmz\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":99.9,\"netValue\":98.91,\"originalValue\":null,\"interestValue\":null,\"description\":\"Assinatura mensal do plano Plano Start\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-05-16\",\"originalDueDate\":\"2026-05-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/n3i5voch3xezt6x5\",\"invoiceNumber\":\"782173593\",\"externalReference\":\"ASSINATURA:7:SUBSCRIPTION\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"428752972\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/n3i5voch3xezt6x5\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}',0,'Cobrança mensal gerada pela assinatura recorrente do Asaas.','2026-04-07 00:39:03','2026-04-07 00:39:03');

--
-- Table structure for table `banco_boleto_config`
--

CREATE TABLE `banco_boleto_config` (
  `id_config` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_bancos` bigint(20) unsigned DEFAULT NULL,
  `id_banco_boleto` bigint(20) unsigned DEFAULT NULL,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `client_secret` text DEFAULT NULL,
  `api_key` varchar(255) DEFAULT NULL,
  `token` longtext DEFAULT NULL,
  `convenio` varchar(255) DEFAULT NULL,
  `carteira` varchar(255) DEFAULT NULL,
  `arquivo_certificado` varchar(255) DEFAULT NULL,
  `arquivo_chave` varchar(255) DEFAULT NULL,
  `juros_mora` decimal(15,2) DEFAULT NULL,
  `multa_atraso` decimal(15,2) DEFAULT NULL,
  `dias_protesto` int(11) DEFAULT NULL,
  `instrucao_1` varchar(255) DEFAULT NULL,
  `instrucao_2` varchar(255) DEFAULT NULL,
  `webhook_ativo` tinyint(1) NOT NULL DEFAULT 0,
  `ativo` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_config`),
  KEY `banco_boleto_config_id_bancos_index` (`id_bancos`),
  KEY `banco_boleto_config_id_banco_boleto_index` (`id_banco_boleto`),
  KEY `banco_boleto_config_id_empresa_index` (`id_empresa`),
  KEY `banco_boleto_config_client_id_index` (`client_id`),
  CONSTRAINT `banco_boleto_config_id_banco_boleto_foreign` FOREIGN KEY (`id_banco_boleto`) REFERENCES `bancos_boleto` (`id_banco_boleto`) ON DELETE SET NULL,
  CONSTRAINT `banco_boleto_config_id_bancos_foreign` FOREIGN KEY (`id_bancos`) REFERENCES `bancos` (`id_bancos`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banco_boleto_config`
--

INSERT INTO `banco_boleto_config` VALUES
(1,2,1,1,NULL,NULL,'$aact_prod_000MzkwODA2MWY2OGM3MWRlMDU2NWM3MzJlNzZmNGZhZGY6OmZlOTVkMTQ0LWZmNWQtNDdkYy1hZGE2LTE2MzYxZjE2ZDk0NTo6JGFhY2hfMThiYjg0NjAtMTc0OS00MmIxLTgwODEtMWIwMGQyMGQ1MmQ4',NULL,NULL,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,1,1,'2026-03-12 15:03:53','2026-03-18 16:29:01'),
(2,NULL,NULL,1,'app-1a14jZQxS4Y1oqSBQx3AoT','df670f26-aebd-4359-ae4b-ea6c8e7036ee',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,0,1,'2026-03-16 10:27:38','2026-03-16 10:27:38'),
(3,NULL,NULL,1,'app-1a14jZQxS4Y1oqSBQx3AoT','df670f26-aebd-4359-ae4b-ea6c8e7036ee',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,0,1,'2026-03-16 12:09:51','2026-03-16 12:09:51'),
(4,NULL,NULL,1,'app-1a14jZQxS4Y1oqSBQx3AoT','df670f26-aebd-4359-ae4b-ea6c8e7036ee',NULL,NULL,NULL,NULL,'boleto_1_5_69a9aff43e28a.crt','boleto_1_5_69a9aff44932b.key',0.00,0.00,NULL,NULL,NULL,0,1,'2026-03-16 12:41:21','2026-03-16 12:41:26'),
(5,NULL,NULL,1,'app-1a14jZQxS4Y1oqSBQx3AoT','df670f26-aebd-4359-ae4b-ea6c8e7036ee',NULL,NULL,NULL,NULL,'boleto_1_6_69a9b70b67f1b.crt','boleto_1_6_69a9b70b707df.key',0.00,0.00,NULL,NULL,NULL,0,1,'2026-03-16 13:43:21','2026-03-16 13:43:27'),
(6,NULL,NULL,1,'app-1a14jZQxS4Y1oqSBQx3AoT','df670f26-aebd-4359-ae4b-ea6c8e7036ee',NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,0,1,'2026-03-16 14:24:52','2026-03-16 14:24:52'),
(7,8,6,1,NULL,NULL,'APP_USR-2191022570663580-031614-53232c0cba5f8c53a285a42d9e8c912f-711799906',NULL,NULL,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,0,1,'2026-03-16 15:23:54','2026-03-16 15:23:54'),
(8,9,7,1,NULL,NULL,'apk_49199247-ZjZisLwhtNnurGEILFfZXQQOlFJkGGNs','8F3P70RO1RJX12NHB9WHETV0E4IVRXW20BQGGFBVRCMA',NULL,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,0,1,'2026-03-16 19:00:56','2026-03-16 19:00:56');

--
-- Table structure for table `bancos`
--

CREATE TABLE `bancos` (
  `id_bancos` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `nome_banco` varchar(255) DEFAULT NULL,
  `agencia` varchar(255) DEFAULT NULL,
  `conta` varchar(255) DEFAULT NULL,
  `saldo_inicial` decimal(15,2) DEFAULT NULL,
  `observacoes` text DEFAULT NULL,
  `gera_boleto` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_bancos`),
  KEY `bancos_id_empresa_index` (`id_empresa`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bancos`
--

INSERT INTO `bancos` VALUES
(1,1,'Inter',NULL,NULL,1000.00,NULL,0,'2026-03-11 22:02:21','2026-03-11 22:02:32'),
(2,1,'Asaas',NULL,NULL,0.00,NULL,1,'2026-03-12 15:03:53','2026-03-12 15:03:53'),
(8,1,'Mercado Pago',NULL,NULL,0.00,NULL,1,'2026-03-16 15:23:54','2026-03-16 15:23:54'),
(9,1,'PagHiper',NULL,NULL,0.00,NULL,1,'2026-03-16 19:00:56','2026-03-16 19:00:56'),
(10,5,'Inter',NULL,NULL,0.00,NULL,0,'2026-03-18 10:51:31','2026-03-18 10:51:31');

--
-- Table structure for table `bancos_boleto`
--

CREATE TABLE `bancos_boleto` (
  `id_banco_boleto` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) DEFAULT NULL,
  `codigo_banco` varchar(255) DEFAULT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT 0,
  `requer_certificado` tinyint(1) NOT NULL DEFAULT 0,
  `requer_chave` tinyint(1) NOT NULL DEFAULT 0,
  `requer_client_id` tinyint(1) NOT NULL DEFAULT 0,
  `requer_client_secret` tinyint(1) NOT NULL DEFAULT 0,
  `requer_api_key` tinyint(1) NOT NULL DEFAULT 0,
  `requer_token` tinyint(1) NOT NULL DEFAULT 0,
  `requer_convenio` tinyint(1) NOT NULL DEFAULT 0,
  `requer_carteira` tinyint(1) NOT NULL DEFAULT 0,
  `instrucoes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_banco_boleto`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bancos_boleto`
--

INSERT INTO `bancos_boleto` VALUES
(1,'Asaas','461',1,0,0,0,0,1,0,0,0,'Passo 1:\nAcesse o painel do Asaas: https://www.asaas.com\nNo menu lateral clique em: Configurações → Integrações\nVá na aba Chaves de API.\nClique em Gerar nova chave.\nCopie a chave gerada e cole abaixo.\nAgora é só salvar e estará pronto.',NULL,'2026-03-16 12:40:14'),
(2,'Inter','077',1,1,1,1,1,0,0,0,0,'Acesse o Internet Banking do Inter em: https://inter.co/empresas/conta-digital/pessoa-juridica/\nFaça login com a conta Inter Empresas.\nNo menu clique em Integrar → Nova Integração.\nSelecione API Cobrança (Boleto + Pix).\nPreencha Client ID e Client Secret da aplicacao do Inter, abaixo.\nEnvie certificado (.crt) e chave (.key) gerados.',NULL,'2026-03-16 12:40:14'),
(6,'Mercado Pago','323',1,0,0,0,0,1,0,0,0,'Integracao Mercado Pago (Orders API): informe o Access Token no campo API Key e gere boleto via payment_method.id=boleto.','2026-03-16 15:22:40','2026-03-16 15:22:40'),
(7,'PagHiper','paghiper',1,0,0,0,0,1,1,0,0,'Integracao PagHiper: informe ApiKey e Token. Emissao via /transaction/create com valor minimo de R$ 3,00 por boleto.','2026-03-16 18:58:33','2026-03-16 18:58:33');

--
-- Table structure for table `boletos`
--

CREATE TABLE `boletos` (
  `id_boleto` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_conta_receber` bigint(20) unsigned DEFAULT NULL,
  `id_bancos` bigint(20) unsigned DEFAULT NULL,
  `id_banco_boleto` bigint(20) unsigned DEFAULT NULL,
  `codigo_solicitacao` varchar(255) DEFAULT NULL,
  `nosso_numero` varchar(255) DEFAULT NULL,
  `linha_digitavel` varchar(255) DEFAULT NULL,
  `codigo_barras` varchar(255) DEFAULT NULL,
  `valor_nominal` decimal(15,2) DEFAULT NULL,
  `valor_pago` decimal(15,2) DEFAULT NULL,
  `data_emissao` date DEFAULT NULL,
  `data_vencimento` date DEFAULT NULL,
  `data_pagamento` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `situacao_banco` varchar(255) DEFAULT NULL,
  `url_pdf` varchar(255) DEFAULT NULL,
  `json_resposta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`json_resposta`)),
  `json_webhook` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`json_webhook`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_boleto`),
  KEY `boletos_id_empresa_index` (`id_empresa`),
  KEY `boletos_id_conta_receber_index` (`id_conta_receber`),
  KEY `boletos_id_bancos_index` (`id_bancos`),
  KEY `boletos_id_banco_boleto_index` (`id_banco_boleto`),
  CONSTRAINT `boletos_id_banco_boleto_foreign` FOREIGN KEY (`id_banco_boleto`) REFERENCES `bancos_boleto` (`id_banco_boleto`) ON DELETE SET NULL,
  CONSTRAINT `boletos_id_bancos_foreign` FOREIGN KEY (`id_bancos`) REFERENCES `bancos` (`id_bancos`) ON DELETE SET NULL,
  CONSTRAINT `boletos_id_conta_receber_foreign` FOREIGN KEY (`id_conta_receber`) REFERENCES `contas_a_receber` (`id_contas`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boletos`
--

INSERT INTO `boletos` VALUES
(1,1,4,2,1,'pay_flkxyj1ah2hsim03','420363587','46191110000000000004220363587013113870000010000','46191138700000100001110000000000042036358701',100.00,NULL,'2026-03-12','2026-03-16',NULL,'cancelado','CANCELLED','https://www.asaas.com/b/pdf/flkxyj1ah2hsim03','{\"object\":\"payment\",\"id\":\"pay_flkxyj1ah2hsim03\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/flkxyj1ah2hsim03\",\"invoiceNumber\":\"764139627\",\"externalReference\":\"4\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"420363587\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/flkxyj1ah2hsim03\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}','{\"id\":\"evt_d545b50fbb17a226c5f4f4fd193922b7&1256587493\",\"event\":\"PAYMENT_DELETED\",\"dateCreated\":\"2026-03-13 18:36:40\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_flkxyj1ah2hsim03\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/flkxyj1ah2hsim03\",\"invoiceNumber\":\"764139627\",\"externalReference\":\"4\",\"deleted\":true,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":\"https:\\/\\/www.asaas.com\\/comprovantes\\/h\\/UEFZTUVOVF9ERUxFVEVEOnBheV9mbGt4eWoxYWgyaHNpbTAz\",\"nossoNumero\":\"420363587\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/flkxyj1ah2hsim03\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":\"2026-03-12T18:06:03Z\",\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}','2026-03-12 15:05:48','2026-03-13 18:36:41'),
(2,1,4,2,1,'pay_wjz4lu72yl5r74h7','420392845','46191110000000000004220392845010413870000010000','46194138700000100001110000000000042039284501',100.00,NULL,'2026-03-12','2026-03-16',NULL,'gerado','PENDING','https://www.asaas.com/b/pdf/wjz4lu72yl5r74h7','{\"object\":\"payment\",\"id\":\"pay_wjz4lu72yl5r74h7\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/wjz4lu72yl5r74h7\",\"invoiceNumber\":\"764189691\",\"externalReference\":\"4\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"420392845\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/wjz4lu72yl5r74h7\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}','{\"id\":\"evt_d545b50fbb17a226c5f4f4fd193922b7&1256587372\",\"event\":\"PAYMENT_DELETED\",\"dateCreated\":\"2026-03-13 18:36:35\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_wjz4lu72yl5r74h7\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/wjz4lu72yl5r74h7\",\"invoiceNumber\":\"764189691\",\"externalReference\":\"4\",\"deleted\":true,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":\"https:\\/\\/www.asaas.com\\/comprovantes\\/h\\/UEFZTUVOVF9ERUxFVEVEOnBheV93ano0bHU3MnlsNXI3NGg3\",\"nossoNumero\":\"420392845\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/wjz4lu72yl5r74h7\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":\"2026-03-12T18:59:04Z\",\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}','2026-03-12 15:58:50','2026-03-16 22:37:36'),
(3,1,4,8,6,'ORD01KKVY88Z90D6BP21C0591A6JQ','10558884368','37690001040010567100200113052187813880000010000','37698138800000100000001000105671000011305218',100.00,100.00,'2026-03-16','2026-03-16','2026-03-19 00:03:57','pago','expired','https://www.mercadopago.com.br/payments/150615176998/ticket?caller_id=3271155889&payment_method_id=bolbradesco&payment_id=150615176998&payment_method_reference_id=10558884368&hash=554b405b-be28-4096-a993-05f4b9c40392','{\"id\":\"ORD01KKVY88Z90D6BP21C0591A6JQ\",\"type\":\"online\",\"processing_mode\":\"automatic\",\"external_reference\":\"4\",\"description\":\"Alguel\",\"total_amount\":\"100.00\",\"total_paid_amount\":\"100.00\",\"country_code\":\"BRA\",\"user_id\":\"711799906\",\"status\":\"canceled\",\"status_detail\":\"expired\",\"capture_mode\":\"automatic_async\",\"currency\":\"BRL\",\"created_date\":\"2026-03-16T18:24:09.716Z\",\"last_updated_date\":\"2026-03-19T03:03:55.221Z\",\"integration_data\":{\"application_id\":\"2191022570663580\"},\"transactions\":{\"payments\":[{\"id\":\"PAY01KKVY88ZMV8JAXJ7G77C0ASTG\",\"amount\":\"100.00\",\"expiration_time\":\"P1D\",\"date_of_expiration\":\"2026-03-18T02:59:59.000+00:00\",\"reference_id\":\"000a22y6fx\",\"status\":\"expired\",\"status_detail\":\"expired\",\"payment_method\":{\"id\":\"bolbradesco\",\"type\":\"ticket\",\"ticket_url\":\"https:\\/\\/www.mercadopago.com.br\\/payments\\/150615176998\\/ticket?caller_id=3271155889&payment_method_id=bolbradesco&payment_id=150615176998&payment_method_reference_id=10558884368&hash=554b405b-be28-4096-a993-05f4b9c40392\",\"barcode_content\":\"37698138800000100000001000105671000011305218\",\"reference\":\"10558884368\",\"verification_code\":\"00011305218\",\"digitable_line\":\"37690001040010567100200113052187813880000010000\"}}]}}','{\"action\":\"order.canceled\",\"api_version\":\"v1\",\"application_id\":\"2191022570663580\",\"data\":{\"currency_id\":\"BRL\",\"external_reference\":\"4\",\"id\":\"ORD01KKVY88Z90D6BP21C0591A6JQ\",\"status\":\"canceled\",\"status_detail\":\"expired\",\"total_amount\":\"100.00\",\"total_paid_amount\":\"100.00\",\"transactions\":{\"payments\":[{\"amount\":\"100.00\",\"id\":\"PAY01KKVY88ZMV8JAXJ7G77C0ASTG\",\"payment_method\":{\"id\":\"bolbradesco\",\"installments\":0,\"type\":\"ticket\"},\"reference\":{\"id\":\"000a22y6fx\"},\"status\":\"expired\",\"status_detail\":\"expired\"}]},\"type\":\"online\",\"version\":3},\"date_created\":\"2026-03-19T03:03:55.220878271Z\",\"live_mode\":true,\"type\":\"order\",\"user_id\":\"711799906\"}','2026-03-16 15:24:14','2026-03-19 00:03:57'),
(4,1,7,8,6,'ORD01KKVYHRQETAN4DGN7YKX1437A','10558885620','42297115040006489731709042591025213910000000500','42292139100000005007115000064897310904259102',5.00,5.00,'2026-03-16','2026-03-20','2026-03-16 18:28:59','pago','accredited','https://www.mercadopago.com.br/payments/149892642579/ticket?caller_id=3271155889&payment_method_id=bolbradesco&payment_id=149892642579&payment_method_reference_id=10558885620&hash=d5ffbe46-ad1d-4895-b2c2-1851f75e6e4f','{\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\",\"type\":\"online\",\"processing_mode\":\"automatic\",\"external_reference\":\"7\",\"description\":\"Teste MP\",\"total_amount\":\"5.00\",\"total_paid_amount\":\"5.00\",\"country_code\":\"BRA\",\"user_id\":\"711799906\",\"status\":\"processed\",\"status_detail\":\"accredited\",\"capture_mode\":\"automatic_async\",\"currency\":\"BRL\",\"created_date\":\"2026-03-16T18:29:20.762Z\",\"last_updated_date\":\"2026-03-16T18:52:34.457Z\",\"integration_data\":{\"application_id\":\"2191022570663580\"},\"transactions\":{\"payments\":[{\"id\":\"PAY01KKVYHRQT9FGPX5RM1ZNYSPVF\",\"amount\":\"5.00\",\"expiration_time\":\"P4D\",\"date_of_expiration\":\"2026-03-21T02:59:59.000+00:00\",\"paid_amount\":\"5.00\",\"reference_id\":\"000a233y8f\",\"status\":\"processed\",\"status_detail\":\"accredited\",\"payment_method\":{\"id\":\"bolbradesco\",\"type\":\"ticket\",\"ticket_url\":\"https:\\/\\/www.mercadopago.com.br\\/payments\\/149892642579\\/ticket?caller_id=3271155889&payment_method_id=bolbradesco&payment_id=149892642579&payment_method_reference_id=10558885620&hash=d5ffbe46-ad1d-4895-b2c2-1851f75e6e4f\",\"barcode_content\":\"42292139100000005007115000064897310904259102\",\"reference\":\"10558885620\",\"verification_code\":\"090425910\",\"digitable_line\":\"42297115040006489731709042591025213910000000500\"}}]}}','{\"action\":\"order.processed\",\"api_version\":\"v1\",\"application_id\":\"2191022570663580\",\"data\":{\"currency_id\":\"BRL\",\"external_reference\":\"7\",\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\",\"status\":\"processed\",\"status_detail\":\"accredited\",\"total_amount\":\"5.00\",\"total_paid_amount\":\"5.00\",\"transactions\":{\"payments\":[{\"amount\":\"5.00\",\"id\":\"PAY01KKVYHRQT9FGPX5RM1ZNYSPVF\",\"paid_amount\":\"5.00\",\"payment_method\":{\"id\":\"bolbradesco\",\"installments\":0,\"type\":\"ticket\"},\"reference\":{\"id\":\"000a233y8f\"},\"status\":\"processed\",\"status_detail\":\"accredited\"}]},\"type\":\"online\",\"version\":3},\"date_created\":\"2026-03-16T18:52:34.457258883Z\",\"live_mode\":true,\"type\":\"order\",\"user_id\":\"711799906\"}','2026-03-16 15:29:23','2026-03-16 18:28:59'),
(5,1,8,9,7,'03ZZMPC3V7TBD726','GN-8-20260316190146-TR8V4','34191.09461 35653.470241 61514.190000 1 14010000000500',NULL,5.00,5.00,'2026-03-16','2026-03-30','2026-03-16 19:05:00','pago','paid','https://www.paghiper.com/checkout/boleto/be6480beb8e77647df22c6cb9f5b60fe7dc9d1f07e0717a6a60b414e38465ea02edbab3bae3cc33773d5ac3a2cd2089d6079435d53a053e48ec68a33f8f35481/03ZZMPC3V7TBD726/20256231','{\"transaction_id\":\"03ZZMPC3V7TBD726\",\"order_id\":\"GN-8-20260316190146-TR8V4\",\"status\":\"paid\",\"notification_id\":null,\"bank_slip\":{\"url_slip\":null,\"digitable_line\":null,\"barcode_number\":null},\"value_cents\":null,\"value\":null,\"paid_value_cents\":500,\"paid_value\":null,\"paid_date\":\"2026-03-16 19:05:00\",\"due_date\":null}','{\"transaction_id\":\"03ZZMPC3V7TBD726\",\"order_id\":\"GN-8-20260316190146-TR8V4\",\"status\":\"paid\",\"paid_value_cents\":500,\"paid_date\":\"2026-03-16 19:05:00\",\"token\":\"8F3P70RO1RJX12NHB9WHETV0E4IVRXW20BQGGFBVRCMA\"}','2026-03-16 19:01:48','2026-03-16 19:13:49'),
(6,1,9,2,1,'pay_oafwvqkk47fz0vrw','422172700','46191110000000000004222172700019114120000002500','46191141200000025001110000000000042217270001',25.00,NULL,'2026-03-18','2026-04-10',NULL,'gerado','PENDING','https://www.asaas.com/b/pdf/oafwvqkk47fz0vrw','{\"object\":\"payment\",\"id\":\"pay_oafwvqkk47fz0vrw\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/oafwvqkk47fz0vrw\",\"invoiceNumber\":\"768217812\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422172700\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/oafwvqkk47fz0vrw\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}',NULL,'2026-03-18 15:58:22','2026-03-18 15:58:22'),
(7,1,9,2,1,'pay_rir3di5zchcemr0y','422176236','46191110000000000004222176236010714120000002500','46197141200000025001110000000000042217623601',25.00,NULL,'2026-03-18','2026-04-10',NULL,'gerado','PENDING','https://www.asaas.com/b/pdf/rir3di5zchcemr0y','{\"object\":\"payment\",\"id\":\"pay_rir3di5zchcemr0y\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/rir3di5zchcemr0y\",\"invoiceNumber\":\"768224598\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422176236\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/rir3di5zchcemr0y\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}',NULL,'2026-03-18 16:05:58','2026-03-18 16:05:58'),
(8,1,9,2,1,'pay_n37m583qs1favgky','422179472','46191110000000000004222179472018314120000002500','46193141200000025001110000000000042217947201',25.00,NULL,'2026-03-18','2026-04-10',NULL,'gerado','PENDING','https://www.asaas.com/b/pdf/n37m583qs1favgky','{\"object\":\"payment\",\"id\":\"pay_n37m583qs1favgky\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/n37m583qs1favgky\",\"invoiceNumber\":\"768230705\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422179472\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/n37m583qs1favgky\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}',NULL,'2026-03-18 16:12:57','2026-03-18 16:12:57'),
(9,1,9,2,1,'pay_x04cstes15abqhl0','422186246','46191110000000000004222186246017514120000002500','46195141200000025001110000000000042218624601',25.00,NULL,'2026-03-18','2026-04-10',NULL,'gerado','PENDING','https://www.asaas.com/b/pdf/x04cstes15abqhl0','{\"object\":\"payment\",\"id\":\"pay_x04cstes15abqhl0\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/x04cstes15abqhl0\",\"invoiceNumber\":\"768242557\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422186246\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/x04cstes15abqhl0\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}',NULL,'2026-03-18 16:25:46','2026-03-18 16:25:46'),
(10,1,9,2,1,'pay_x8nthvevjxckepx1','422188483','46191110000000000004222188483014414120000002500','46194141200000025001110000000000042218848301',25.00,NULL,'2026-03-18','2026-04-10',NULL,'gerado','PENDING','https://www.asaas.com/b/pdf/x8nthvevjxckepx1','{\"object\":\"payment\",\"id\":\"pay_x8nthvevjxckepx1\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/x8nthvevjxckepx1\",\"invoiceNumber\":\"768245943\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422188483\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/x8nthvevjxckepx1\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}',NULL,'2026-03-18 16:29:01','2026-03-18 16:29:01'),
(11,1,9,2,1,'pay_xtnoevt7b7bm57mw','422189073','46191110000000000004222189073012414120000002500','46194141200000025001110000000000042218907301',25.00,NULL,'2026-03-18','2026-04-10',NULL,'gerado','PENDING','https://www.asaas.com/b/pdf/xtnoevt7b7bm57mw','{\"object\":\"payment\",\"id\":\"pay_xtnoevt7b7bm57mw\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/xtnoevt7b7bm57mw\",\"invoiceNumber\":\"768246932\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422189073\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/xtnoevt7b7bm57mw\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}',NULL,'2026-03-18 16:30:02','2026-03-18 16:30:02'),
(12,1,11,9,7,'03J9Q90Z1MI7VR26','GN-11-20260324210018-M8QM9','34191.09461 42868.930241 61514.190000 1 14250000002000',NULL,20.00,NULL,'2026-03-24','2026-04-23',NULL,'gerado','pending','https://www.paghiper.com/checkout/boleto/5d16ee03774bdfcac1a71c4408caf906009d3156ba195f5ef7043e93611d8c5ebf3ab3a8c6d756ffcb5b9e02a4bbf459631ceb0ce4f1762affc60c48d188701d/03J9Q90Z1MI7VR26/155160356/pdf','{\"create_request\":{\"result\":\"success\",\"response_message\":\"transacao criada\",\"transaction_id\":\"03J9Q90Z1MI7VR26\",\"created_date\":\"2026-03-24 21:00:18\",\"value_cents\":\"2000\",\"status\":\"pending\",\"order_id\":\"GN-11-20260324210018-M8QM9\",\"due_date\":\"2026-04-23\",\"bank_slip\":{\"digitable_line\":\"34191.09461 42868.930241 61514.190000 1 14250000002000\",\"url_slip\":\"https:\\/\\/www.paghiper.com\\/checkout\\/boleto\\/5d16ee03774bdfcac1a71c4408caf906009d3156ba195f5ef7043e93611d8c5ebf3ab3a8c6d756ffcb5b9e02a4bbf459631ceb0ce4f1762affc60c48d188701d\\/03J9Q90Z1MI7VR26\\/155160356\",\"url_slip_pdf\":\"https:\\/\\/www.paghiper.com\\/checkout\\/boleto\\/5d16ee03774bdfcac1a71c4408caf906009d3156ba195f5ef7043e93611d8c5ebf3ab3a8c6d756ffcb5b9e02a4bbf459631ceb0ce4f1762affc60c48d188701d\\/03J9Q90Z1MI7VR26\\/155160356\\/pdf\",\"bar_code_number_to_image\":\"34191142500000020001094642868930246151419000\"},\"http_code\":201,\"http_cod\":201}}',NULL,'2026-03-24 21:00:20','2026-03-24 21:00:20');

--
-- Table structure for table `boletos_historico`
--

CREATE TABLE `boletos_historico` (
  `id_historico` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_boleto` bigint(20) unsigned DEFAULT NULL,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `tipo` varchar(255) DEFAULT NULL,
  `conteudo` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id_historico`),
  KEY `boletos_historico_id_boleto_index` (`id_boleto`),
  KEY `boletos_historico_id_empresa_index` (`id_empresa`),
  CONSTRAINT `boletos_historico_id_boleto_foreign` FOREIGN KEY (`id_boleto`) REFERENCES `boletos` (`id_boleto`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boletos_historico`
--

INSERT INTO `boletos_historico` VALUES
(1,1,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":100,\"dueDate\":\"2026-03-16\",\"description\":\"Alguel\",\"externalReference\":\"4\"},\"etapa\":\"iniciando\"}','2026-03-12 15:05:48'),
(2,1,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":100,\"dueDate\":\"2026-03-16\",\"description\":\"Alguel\",\"externalReference\":\"4\"},\"response\":{\"object\":\"payment\",\"id\":\"pay_flkxyj1ah2hsim03\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/flkxyj1ah2hsim03\",\"invoiceNumber\":\"764139627\",\"externalReference\":\"4\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"420363587\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/flkxyj1ah2hsim03\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-12 15:05:48'),
(3,1,1,'webhook','{\"id\":\"evt_05b708f961d739ea7eba7e4db318f621&1254998490\",\"event\":\"PAYMENT_CREATED\",\"dateCreated\":\"2026-03-12 15:05:49\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_flkxyj1ah2hsim03\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/flkxyj1ah2hsim03\",\"invoiceNumber\":\"764139627\",\"externalReference\":\"4\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"420363587\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/flkxyj1ah2hsim03\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}','2026-03-12 15:05:50'),
(4,1,1,'webhook','{\"id\":\"evt_454d76fe883fd17f74ebbbb453a6dd09&1254998825\",\"event\":\"PAYMENT_BANK_SLIP_VIEWED\",\"dateCreated\":\"2026-03-12 15:06:04\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_flkxyj1ah2hsim03\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/flkxyj1ah2hsim03\",\"invoiceNumber\":\"764139627\",\"externalReference\":\"4\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"420363587\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/flkxyj1ah2hsim03\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":\"2026-03-12T18:06:03Z\",\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}','2026-03-12 15:06:04'),
(5,2,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":100,\"dueDate\":\"2026-03-16\",\"description\":\"Alguel\",\"externalReference\":\"4\"},\"etapa\":\"iniciando\"}','2026-03-12 15:58:49'),
(6,2,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":100,\"dueDate\":\"2026-03-16\",\"description\":\"Alguel\",\"externalReference\":\"4\"},\"response\":{\"object\":\"payment\",\"id\":\"pay_wjz4lu72yl5r74h7\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/wjz4lu72yl5r74h7\",\"invoiceNumber\":\"764189691\",\"externalReference\":\"4\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"420392845\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/wjz4lu72yl5r74h7\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-12 15:58:49'),
(7,2,1,'webhook','{\"id\":\"evt_05b708f961d739ea7eba7e4db318f621&1255061103\",\"event\":\"PAYMENT_CREATED\",\"dateCreated\":\"2026-03-12 15:58:51\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_wjz4lu72yl5r74h7\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/wjz4lu72yl5r74h7\",\"invoiceNumber\":\"764189691\",\"externalReference\":\"4\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"420392845\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/wjz4lu72yl5r74h7\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}','2026-03-12 15:58:51'),
(8,2,1,'webhook','{\"id\":\"evt_454d76fe883fd17f74ebbbb453a6dd09&1255061363\",\"event\":\"PAYMENT_BANK_SLIP_VIEWED\",\"dateCreated\":\"2026-03-12 15:59:06\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_wjz4lu72yl5r74h7\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/wjz4lu72yl5r74h7\",\"invoiceNumber\":\"764189691\",\"externalReference\":\"4\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"420392845\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/wjz4lu72yl5r74h7\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":\"2026-03-12T18:59:04Z\",\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}','2026-03-12 15:59:06'),
(9,2,1,'webhook','{\"id\":\"evt_d545b50fbb17a226c5f4f4fd193922b7&1256587372\",\"event\":\"PAYMENT_DELETED\",\"dateCreated\":\"2026-03-13 18:36:35\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_wjz4lu72yl5r74h7\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/wjz4lu72yl5r74h7\",\"invoiceNumber\":\"764189691\",\"externalReference\":\"4\",\"deleted\":true,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":\"https:\\/\\/www.asaas.com\\/comprovantes\\/h\\/UEFZTUVOVF9ERUxFVEVEOnBheV93ano0bHU3MnlsNXI3NGg3\",\"nossoNumero\":\"420392845\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/wjz4lu72yl5r74h7\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":\"2026-03-12T18:59:04Z\",\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}','2026-03-13 18:36:36'),
(10,1,1,'webhook','{\"id\":\"evt_d545b50fbb17a226c5f4f4fd193922b7&1256587493\",\"event\":\"PAYMENT_DELETED\",\"dateCreated\":\"2026-03-13 18:36:40\",\"account\":{\"id\":\"bf0e448f-b995-4e06-ba92-c20cef54439d\",\"ownerId\":null},\"payment\":{\"object\":\"payment\",\"id\":\"pay_flkxyj1ah2hsim03\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/flkxyj1ah2hsim03\",\"invoiceNumber\":\"764139627\",\"externalReference\":\"4\",\"deleted\":true,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":\"https:\\/\\/www.asaas.com\\/comprovantes\\/h\\/UEFZTUVOVF9ERUxFVEVEOnBheV9mbGt4eWoxYWgyaHNpbTAz\",\"nossoNumero\":\"420363587\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/flkxyj1ah2hsim03\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":\"2026-03-12T18:06:03Z\",\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null}}','2026-03-13 18:36:41'),
(11,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"eb4cef65-1b5f-e03d-2969-d49549436244\"}','2026-03-16 10:28:06'),
(12,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"idempotency_key\":\"eb4cef65-1b5f-e03d-2969-d49549436244\"}','2026-03-16 10:28:07'),
(13,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"eb4cef65-1b5f-e03d-2969-d49549436244\"}','2026-03-16 10:30:14'),
(14,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"idempotency_key\":\"eb4cef65-1b5f-e03d-2969-d49549436244\"}','2026-03-16 10:30:15'),
(15,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"eb4cef65-1b5f-e03d-2969-d49549436244\"}','2026-03-16 10:30:44'),
(16,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"idempotency_key\":\"eb4cef65-1b5f-e03d-2969-d49549436244\"}','2026-03-16 10:30:45'),
(17,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"cef2b439-0b5e-4a43-986e-c55953594bfc\"}','2026-03-16 10:34:03'),
(18,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"idempotency_key\":\"cef2b439-0b5e-4a43-986e-c55953594bfc\"}','2026-03-16 10:34:04'),
(19,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"62486898-554a-40ff-abe2-6e16fa5924ab\"}','2026-03-16 10:56:19'),
(20,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"41949d85-a257-4532-955e-f4e85ec1c73c\"}','2026-03-16 10:59:23'),
(21,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"b82ede25-42fb-4cd5-90a9-12eb306615be\"}','2026-03-16 12:10:11'),
(22,NULL,1,'geracao','{\"request\":{\"code\":\"4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"ee4dbc2e-e8f9-4058-a591-1659abea9040\"}','2026-03-16 12:18:43'),
(23,NULL,1,'geracao','{\"request\":{\"code\":\"GN-1-4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\",\"country\":\"BR\"}},\"services\":[{\"name\":\"Cobranca\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"etapa\":\"iniciando_emissao_cora\"}','2026-03-16 12:42:04'),
(24,NULL,1,'geracao','{\"request\":{\"code\":\"GN-1-4\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"email\":\"gestornow0@gmail.com\",\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\",\"country\":\"BR\"}},\"services\":[{\"name\":\"Cobranca\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\",\"PIX\"]},\"idempotency_key\":\"8b669f3f-c6eb-40cd-b1a4-9f272b132fe8\",\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400}','2026-03-16 12:42:05'),
(25,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316134330\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"integracao\":\"cora\"}','2026-03-16 13:43:30'),
(26,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316134330\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"integracao\":\"cora\"}','2026-03-16 13:43:31'),
(27,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316134646\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"integracao\":\"cora\"}','2026-03-16 13:46:46'),
(28,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316134646\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"integracao\":\"cora\"}','2026-03-16 13:46:47'),
(29,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316135012\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"integracao\":\"cora\"}','2026-03-16 13:50:12'),
(30,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316135012\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"integracao\":\"cora\"}','2026-03-16 13:50:13'),
(31,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316135105\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"integracao\":\"cora\"}','2026-03-16 13:51:05'),
(32,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316135105\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"integracao\":\"cora\"}','2026-03-16 13:51:06'),
(33,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316135233\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"integracao\":\"cora\"}','2026-03-16 13:52:33'),
(34,NULL,1,'geracao','{\"request\":{\"code\":\"conta_4_20260316135233\",\"customer\":{\"name\":\"PRIME VIDEO LTDA\",\"email\":\"gestornow0@gmail.com\",\"document\":{\"identity\":\"68634245000104\",\"type\":\"CNPJ\"},\"address\":{\"street\":\"AVENIDA SUBURBANA\",\"number\":\"7471\",\"district\":\"ABOLICAO\",\"city\":\"S\\u00e3o Paulo\",\"state\":\"SP\",\"complement\":\"SALA 201 PARTE\",\"zip_code\":\"20751000\"}},\"services\":[{\"name\":\"Alguel\",\"description\":\"Alguel\",\"amount\":10000}],\"payment_terms\":{\"due_date\":\"2026-03-16\"},\"payment_forms\":[\"BANK_SLIP\"]},\"response\":{\"code\":\"invalid_request\",\"message\":\"Request has invalid parameters\",\"errors\":[{\"code\":\"Authorization\",\"message\":\"header is required\"}]},\"http_code\":400,\"integracao\":\"cora\"}','2026-03-16 13:52:34'),
(35,3,1,'geracao','{\"request\":{\"type\":\"online\",\"external_reference\":\"4\",\"processing_mode\":\"automatic\",\"total_amount\":\"100.00\",\"description\":\"Alguel\",\"payer\":{\"email\":\"gestornow0@gmail.com\",\"first_name\":\"PRIME\",\"last_name\":\"VIDEO LTDA\",\"identification\":{\"type\":\"CNPJ\",\"number\":\"68634245000104\"},\"address\":{\"street_name\":\"AVENIDA SUBURBANA\",\"street_number\":\"7471\",\"zip_code\":\"20751000\",\"neighborhood\":\"ABOLICAO\",\"state\":\"SP\",\"city\":\"S\\u00e3o Paulo\"}},\"transactions\":{\"payments\":[{\"amount\":\"100.00\",\"payment_method\":{\"id\":\"boleto\",\"type\":\"ticket\"},\"expiration_time\":\"P1D\"}]}},\"etapa\":\"iniciando_mercado_pago_order\"}','2026-03-16 15:24:09'),
(36,3,1,'geracao','{\"request\":{\"type\":\"online\",\"external_reference\":\"4\",\"processing_mode\":\"automatic\",\"total_amount\":\"100.00\",\"description\":\"Alguel\",\"payer\":{\"email\":\"gestornow0@gmail.com\",\"first_name\":\"PRIME\",\"last_name\":\"VIDEO LTDA\",\"identification\":{\"type\":\"CNPJ\",\"number\":\"68634245000104\"},\"address\":{\"street_name\":\"AVENIDA SUBURBANA\",\"street_number\":\"7471\",\"zip_code\":\"20751000\",\"neighborhood\":\"ABOLICAO\",\"state\":\"SP\",\"city\":\"S\\u00e3o Paulo\"}},\"transactions\":{\"payments\":[{\"amount\":\"100.00\",\"payment_method\":{\"id\":\"boleto\",\"type\":\"ticket\"},\"expiration_time\":\"P1D\"}]}},\"response\":{\"id\":\"ORD01KKVY88Z90D6BP21C0591A6JQ\",\"type\":\"online\",\"processing_mode\":\"automatic\",\"external_reference\":\"4\",\"description\":\"Alguel\",\"total_amount\":\"100.00\",\"total_paid_amount\":\"100.00\",\"country_code\":\"BRA\",\"user_id\":\"711799906\",\"status\":\"action_required\",\"status_detail\":\"waiting_payment\",\"capture_mode\":\"automatic_async\",\"currency\":\"BRL\",\"created_date\":\"2026-03-16T18:24:09.716Z\",\"last_updated_date\":\"2026-03-16T18:24:14.396Z\",\"integration_data\":{\"application_id\":\"2191022570663580\"},\"transactions\":{\"payments\":[{\"id\":\"PAY01KKVY88ZMV8JAXJ7G77C0ASTG\",\"amount\":\"100.00\",\"expiration_time\":\"P1D\",\"date_of_expiration\":\"2026-03-18T02:59:59.000+00:00\",\"reference_id\":\"000a22y6fx\",\"status\":\"action_required\",\"status_detail\":\"waiting_payment\",\"payment_method\":{\"id\":\"boleto\",\"type\":\"ticket\",\"ticket_url\":\"https:\\/\\/www.mercadopago.com.br\\/payments\\/150615176998\\/ticket?caller_id=3271155889&payment_method_id=bolbradesco&payment_id=150615176998&payment_method_reference_id=10558884368&hash=554b405b-be28-4096-a993-05f4b9c40392\",\"barcode_content\":\"37698138800000100000001000105671000011305218\",\"reference\":\"10558884368\",\"verification_code\":\"00011305218\",\"digitable_line\":\"37690001040010567100200113052187813880000010000\"}}]}},\"http_code\":201,\"idempotency_key\":\"1bb2c027-c76e-454b-9179-1483040c79e6\"}','2026-03-16 15:24:14'),
(37,NULL,1,'geracao','{\"request\":{\"type\":\"online\",\"external_reference\":\"7\",\"processing_mode\":\"automatic\",\"total_amount\":\"2.50\",\"description\":\"Teste MP\",\"payer\":{\"email\":\"gestornow0@gmail.com\",\"first_name\":\"PRIME\",\"last_name\":\"VIDEO LTDA\",\"identification\":{\"type\":\"CNPJ\",\"number\":\"68634245000104\"},\"address\":{\"street_name\":\"AVENIDA SUBURBANA\",\"street_number\":\"7471\",\"zip_code\":\"20751000\",\"neighborhood\":\"ABOLICAO\",\"state\":\"SP\",\"city\":\"S\\u00e3o Paulo\"}},\"transactions\":{\"payments\":[{\"amount\":\"2.50\",\"payment_method\":{\"id\":\"boleto\",\"type\":\"ticket\"},\"expiration_time\":\"P4D\"}]}},\"etapa\":\"iniciando_mercado_pago_order\"}','2026-03-16 15:28:59'),
(38,NULL,1,'geracao','{\"request\":{\"type\":\"online\",\"external_reference\":\"7\",\"processing_mode\":\"automatic\",\"total_amount\":\"2.50\",\"description\":\"Teste MP\",\"payer\":{\"email\":\"gestornow0@gmail.com\",\"first_name\":\"PRIME\",\"last_name\":\"VIDEO LTDA\",\"identification\":{\"type\":\"CNPJ\",\"number\":\"68634245000104\"},\"address\":{\"street_name\":\"AVENIDA SUBURBANA\",\"street_number\":\"7471\",\"zip_code\":\"20751000\",\"neighborhood\":\"ABOLICAO\",\"state\":\"SP\",\"city\":\"S\\u00e3o Paulo\"}},\"transactions\":{\"payments\":[{\"amount\":\"2.50\",\"payment_method\":{\"id\":\"boleto\",\"type\":\"ticket\"},\"expiration_time\":\"P4D\"}]}},\"response\":{\"errors\":[{\"code\":\"unprocessable_content\",\"message\":\"Unprocessable Entity\"}]},\"http_code\":422,\"idempotency_key\":\"1e504170-d268-4bc8-b5a6-1574badc8d85\"}','2026-03-16 15:29:00'),
(39,4,1,'geracao','{\"request\":{\"type\":\"online\",\"external_reference\":\"7\",\"processing_mode\":\"automatic\",\"total_amount\":\"5.00\",\"description\":\"Teste MP\",\"payer\":{\"email\":\"gestornow0@gmail.com\",\"first_name\":\"PRIME\",\"last_name\":\"VIDEO LTDA\",\"identification\":{\"type\":\"CNPJ\",\"number\":\"68634245000104\"},\"address\":{\"street_name\":\"AVENIDA SUBURBANA\",\"street_number\":\"7471\",\"zip_code\":\"20751000\",\"neighborhood\":\"ABOLICAO\",\"state\":\"SP\",\"city\":\"S\\u00e3o Paulo\"}},\"transactions\":{\"payments\":[{\"amount\":\"5.00\",\"payment_method\":{\"id\":\"boleto\",\"type\":\"ticket\"},\"expiration_time\":\"P4D\"}]}},\"etapa\":\"iniciando_mercado_pago_order\"}','2026-03-16 15:29:20'),
(40,4,1,'geracao','{\"request\":{\"type\":\"online\",\"external_reference\":\"7\",\"processing_mode\":\"automatic\",\"total_amount\":\"5.00\",\"description\":\"Teste MP\",\"payer\":{\"email\":\"gestornow0@gmail.com\",\"first_name\":\"PRIME\",\"last_name\":\"VIDEO LTDA\",\"identification\":{\"type\":\"CNPJ\",\"number\":\"68634245000104\"},\"address\":{\"street_name\":\"AVENIDA SUBURBANA\",\"street_number\":\"7471\",\"zip_code\":\"20751000\",\"neighborhood\":\"ABOLICAO\",\"state\":\"SP\",\"city\":\"S\\u00e3o Paulo\"}},\"transactions\":{\"payments\":[{\"amount\":\"5.00\",\"payment_method\":{\"id\":\"boleto\",\"type\":\"ticket\"},\"expiration_time\":\"P4D\"}]}},\"response\":{\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\",\"type\":\"online\",\"processing_mode\":\"automatic\",\"external_reference\":\"7\",\"description\":\"Teste MP\",\"total_amount\":\"5.00\",\"total_paid_amount\":\"5.00\",\"country_code\":\"BRA\",\"user_id\":\"711799906\",\"status\":\"action_required\",\"status_detail\":\"waiting_payment\",\"capture_mode\":\"automatic_async\",\"currency\":\"BRL\",\"created_date\":\"2026-03-16T18:29:20.762Z\",\"last_updated_date\":\"2026-03-16T18:29:22.887Z\",\"integration_data\":{\"application_id\":\"2191022570663580\"},\"transactions\":{\"payments\":[{\"id\":\"PAY01KKVYHRQT9FGPX5RM1ZNYSPVF\",\"amount\":\"5.00\",\"expiration_time\":\"P4D\",\"date_of_expiration\":\"2026-03-21T02:59:59.000+00:00\",\"reference_id\":\"000a233y8f\",\"status\":\"action_required\",\"status_detail\":\"waiting_payment\",\"payment_method\":{\"id\":\"boleto\",\"type\":\"ticket\",\"ticket_url\":\"https:\\/\\/www.mercadopago.com.br\\/payments\\/149892642579\\/ticket?caller_id=3271155889&payment_method_id=bolbradesco&payment_id=149892642579&payment_method_reference_id=10558885620&hash=d5ffbe46-ad1d-4895-b2c2-1851f75e6e4f\",\"barcode_content\":\"42292139100000005007115000064897310904259102\",\"reference\":\"10558885620\",\"verification_code\":\"090425910\",\"digitable_line\":\"42297115040006489731709042591025213910000000500\"}}]}},\"http_code\":201,\"idempotency_key\":\"40fadc85-d055-4327-9a1b-b231ca933985\"}','2026-03-16 15:29:23'),
(41,4,1,'webhook','{\"action\":\"order.action_required\",\"api_version\":\"v1\",\"application_id\":\"2191022570663580\",\"data\":{\"currency_id\":\"BRL\",\"external_reference\":\"7\",\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\",\"status\":\"action_required\",\"status_detail\":\"waiting_payment\",\"total_amount\":\"5.00\",\"total_paid_amount\":\"5.00\",\"transactions\":{\"payments\":[{\"amount\":\"5.00\",\"id\":\"PAY01KKVYHRQT9FGPX5RM1ZNYSPVF\",\"payment_method\":{\"id\":\"boleto\",\"installments\":0,\"type\":\"ticket\"},\"reference\":{\"id\":\"000a233y8f\"},\"status\":\"action_required\",\"status_detail\":\"waiting_payment\"}]},\"type\":\"online\",\"version\":1},\"date_created\":\"2026-03-16T18:29:22.887287102Z\",\"live_mode\":true,\"type\":\"order\",\"user_id\":\"711799906\"}','2026-03-16 15:29:24'),
(42,4,1,'webhook','{\"action\":\"order.action_required\",\"api_version\":\"v1\",\"application_id\":\"2191022570663580\",\"data\":{\"currency_id\":\"BRL\",\"external_reference\":\"7\",\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\",\"status\":\"action_required\",\"status_detail\":\"waiting_payment\",\"total_amount\":\"5.00\",\"total_paid_amount\":\"5.00\",\"transactions\":{\"payments\":[{\"amount\":\"5.00\",\"id\":\"PAY01KKVYHRQT9FGPX5RM1ZNYSPVF\",\"payment_method\":{\"id\":\"bolbradesco\",\"installments\":0,\"type\":\"ticket\"},\"reference\":{\"id\":\"000a233y8f\"},\"status\":\"action_required\",\"status_detail\":\"waiting_payment\"}]},\"type\":\"online\",\"version\":2},\"date_created\":\"2026-03-16T18:29:23.223437952Z\",\"live_mode\":true,\"type\":\"order\",\"user_id\":\"711799906\"}','2026-03-16 15:29:59'),
(43,4,1,'webhook','{\"action\":\"payment.updated\",\"api_version\":\"v1\",\"data\":{\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\"},\"date_created\":\"2026-03-16T15:00:00Z\",\"id\":\"evt_test_mercadopago_001\",\"live_mode\":false,\"type\":\"payment\",\"user_id\":711799906}','2026-03-16 15:35:18'),
(44,4,1,'webhook','{\"status_detail\":\"accredited\",\"action\":\"payment.updated\",\"data\":{\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\"},\"id\":\"evt_test_paid_001\",\"type\":\"payment\",\"live_mode\":false,\"status\":\"approved\",\"date_created\":\"2026-03-16T15:36:37.1065980-03:00\",\"api_version\":\"v1\",\"user_id\":711799906}','2026-03-16 15:36:38'),
(45,4,1,'webhook','{\"action\":\"payment.updated\",\"api_version\":\"v1\",\"data\":{\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\"},\"date_created\":\"2026-03-16T15:00:00Z\",\"id\":\"evt_test_mercadopago_001\",\"live_mode\":false,\"type\":\"payment\",\"user_id\":711799906}','2026-03-16 15:39:04'),
(46,4,1,'webhook','{\"action\":\"order.processed\",\"api_version\":\"v1\",\"application_id\":\"2191022570663580\",\"data\":{\"currency_id\":\"BRL\",\"external_reference\":\"7\",\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\",\"status\":\"processed\",\"status_detail\":\"accredited\",\"total_amount\":\"5.00\",\"total_paid_amount\":\"5.00\",\"transactions\":{\"payments\":[{\"amount\":\"5.00\",\"id\":\"PAY01KKVYHRQT9FGPX5RM1ZNYSPVF\",\"paid_amount\":\"5.00\",\"payment_method\":{\"id\":\"bolbradesco\",\"installments\":0,\"type\":\"ticket\"},\"reference\":{\"id\":\"000a233y8f\"},\"status\":\"processed\",\"status_detail\":\"accredited\"}]},\"type\":\"online\",\"version\":3},\"date_created\":\"2026-03-16T18:52:34.457258883Z\",\"live_mode\":true,\"type\":\"order\",\"user_id\":\"711799906\"}','2026-03-16 15:52:35'),
(47,4,1,'webhook','{\"action\":\"order.processed\",\"api_version\":\"v1\",\"application_id\":\"2191022570663580\",\"data\":{\"currency_id\":\"BRL\",\"external_reference\":\"7\",\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\",\"status\":\"processed\",\"status_detail\":\"accredited\",\"total_amount\":\"5.00\",\"total_paid_amount\":\"5.00\",\"transactions\":{\"payments\":[{\"amount\":\"5.00\",\"id\":\"PAY01KKVYHRQT9FGPX5RM1ZNYSPVF\",\"paid_amount\":\"5.00\",\"payment_method\":{\"id\":\"bolbradesco\",\"installments\":0,\"type\":\"ticket\"},\"reference\":{\"id\":\"000a233y8f\"},\"status\":\"processed\",\"status_detail\":\"accredited\"}]},\"type\":\"online\",\"version\":3},\"date_created\":\"2026-03-16T18:52:34.457258883Z\",\"live_mode\":true,\"type\":\"order\",\"user_id\":\"711799906\"}','2026-03-16 18:26:21'),
(48,4,1,'webhook','{\"action\":\"order.processed\",\"api_version\":\"v1\",\"application_id\":\"2191022570663580\",\"data\":{\"currency_id\":\"BRL\",\"external_reference\":\"7\",\"id\":\"ORD01KKVYHRQETAN4DGN7YKX1437A\",\"status\":\"processed\",\"status_detail\":\"accredited\",\"total_amount\":\"5.00\",\"total_paid_amount\":\"5.00\",\"transactions\":{\"payments\":[{\"amount\":\"5.00\",\"id\":\"PAY01KKVYHRQT9FGPX5RM1ZNYSPVF\",\"paid_amount\":\"5.00\",\"payment_method\":{\"id\":\"bolbradesco\",\"installments\":0,\"type\":\"ticket\"},\"reference\":{\"id\":\"000a233y8f\"},\"status\":\"processed\",\"status_detail\":\"accredited\"}]},\"type\":\"online\",\"version\":3},\"date_created\":\"2026-03-16T18:52:34.457258883Z\",\"live_mode\":true,\"type\":\"order\",\"user_id\":\"711799906\"}','2026-03-16 18:28:59'),
(49,5,1,'geracao','{\"request\":{\"apiKey\":\"apk_49199247-ZjZisLwhtNnurGEILFfZXQQOlFJkGGNs\",\"token\":\"8F3P70RO1RJX12NHB9WHETV0E4IVRXW20BQGGFBVRCMA\",\"order_id\":\"GN-8-20260316190146-TR8V4\",\"payer_email\":\"gestornow0@gmail.com\",\"payer_name\":\"PRIME VIDEO LTDA\",\"payer_cpf_cnpj\":\"68634245000104\",\"days_due_date\":14,\"type_bank_slip\":\"boletoA4\",\"items\":[{\"description\":\"Teste PH\",\"quantity\":\"1\",\"item_id\":\"8\",\"price_cents\":\"500\"}],\"per_day_interest\":false,\"notification_url\":\"https:\\/\\/nowgestor.gestornow.com\\/api\\/webhooks\\/boletos\\/paghiper\",\"payer_phone\":\"19986116778\",\"payer_street\":\"AVENIDA SUBURBANA\",\"payer_number\":\"7471\",\"payer_complement\":\"SALA 201 PARTE\",\"payer_district\":\"ABOLICAO\",\"payer_city\":\"S\\u00e3o Paulo\",\"payer_state\":\"SP\",\"payer_zip_code\":\"20751000\"},\"etapa\":\"iniciando_paghiper_create\"}','2026-03-16 19:01:46'),
(50,5,1,'geracao','{\"request\":{\"apiKey\":\"apk_49199247-ZjZisLwhtNnurGEILFfZXQQOlFJkGGNs\",\"token\":\"8F3P70RO1RJX12NHB9WHETV0E4IVRXW20BQGGFBVRCMA\",\"order_id\":\"GN-8-20260316190146-TR8V4\",\"payer_email\":\"gestornow0@gmail.com\",\"payer_name\":\"PRIME VIDEO LTDA\",\"payer_cpf_cnpj\":\"68634245000104\",\"days_due_date\":14,\"type_bank_slip\":\"boletoA4\",\"items\":[{\"description\":\"Teste PH\",\"quantity\":\"1\",\"item_id\":\"8\",\"price_cents\":\"500\"}],\"per_day_interest\":false,\"notification_url\":\"https:\\/\\/nowgestor.gestornow.com\\/api\\/webhooks\\/boletos\\/paghiper\",\"payer_phone\":\"19986116778\",\"payer_street\":\"AVENIDA SUBURBANA\",\"payer_number\":\"7471\",\"payer_complement\":\"SALA 201 PARTE\",\"payer_district\":\"ABOLICAO\",\"payer_city\":\"S\\u00e3o Paulo\",\"payer_state\":\"SP\",\"payer_zip_code\":\"20751000\"},\"response\":{\"create_request\":{\"result\":\"success\",\"response_message\":\"transacao criada\",\"transaction_id\":\"03ZZMPC3V7TBD726\",\"created_date\":\"2026-03-16 19:01:47\",\"value_cents\":\"500\",\"status\":\"pending\",\"order_id\":\"GN-8-20260316190146-TR8V4\",\"due_date\":\"2026-03-30\",\"bank_slip\":{\"digitable_line\":\"34191.09461 35653.470241 61514.190000 1 14010000000500\",\"url_slip\":\"https:\\/\\/www.paghiper.com\\/checkout\\/boleto\\/be6480beb8e77647df22c6cb9f5b60fe7dc9d1f07e0717a6a60b414e38465ea02edbab3bae3cc33773d5ac3a2cd2089d6079435d53a053e48ec68a33f8f35481\\/03ZZMPC3V7TBD726\\/20256231\",\"url_slip_pdf\":\"https:\\/\\/www.paghiper.com\\/checkout\\/boleto\\/be6480beb8e77647df22c6cb9f5b60fe7dc9d1f07e0717a6a60b414e38465ea02edbab3bae3cc33773d5ac3a2cd2089d6079435d53a053e48ec68a33f8f35481\\/03ZZMPC3V7TBD726\\/20256231\\/pdf\",\"bar_code_number_to_image\":\"34191140100000005001094635653470246151419000\"},\"http_code\":201,\"http_cod\":201}},\"http_code\":201}','2026-03-16 19:01:48'),
(51,5,1,'webhook','{\"transaction_id\":\"03ZZMPC3V7TBD726\",\"order_id\":\"GN-8-20260316190146-TR8V4\",\"status\":\"paid\",\"paid_value_cents\":500,\"paid_date\":\"2026-03-16 19:05:00\",\"token\":\"8F3P70RO1RJX12NHB9WHETV0E4IVRXW20BQGGFBVRCMA\"}','2026-03-16 19:13:49'),
(52,2,1,'consulta','{\"response\":{\"object\":\"payment\",\"id\":\"pay_wjz4lu72yl5r74h7\",\"dateCreated\":\"2026-03-12\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":100,\"netValue\":99.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Alguel\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-03-16\",\"originalDueDate\":\"2026-03-16\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/wjz4lu72yl5r74h7\",\"invoiceNumber\":\"764189691\",\"externalReference\":\"4\",\"deleted\":true,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":\"https:\\/\\/www.asaas.com\\/comprovantes\\/h\\/UEFZTUVOVF9ERUxFVEVEOnBheV93ano0bHU3MnlsNXI3NGg3\",\"nossoNumero\":\"420392845\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/wjz4lu72yl5r74h7\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":\"2026-03-12T18:59:04Z\",\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-16 22:37:36'),
(53,6,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"etapa\":\"iniciando\"}','2026-03-18 15:58:21'),
(54,6,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"response\":{\"object\":\"payment\",\"id\":\"pay_oafwvqkk47fz0vrw\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/oafwvqkk47fz0vrw\",\"invoiceNumber\":\"768217812\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422172700\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/oafwvqkk47fz0vrw\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-18 15:58:22'),
(55,7,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"etapa\":\"iniciando\"}','2026-03-18 16:05:58'),
(56,7,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"response\":{\"object\":\"payment\",\"id\":\"pay_rir3di5zchcemr0y\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/rir3di5zchcemr0y\",\"invoiceNumber\":\"768224598\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422176236\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/rir3di5zchcemr0y\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-18 16:05:58'),
(57,8,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"etapa\":\"iniciando\"}','2026-03-18 16:12:56'),
(58,8,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"response\":{\"object\":\"payment\",\"id\":\"pay_n37m583qs1favgky\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/n37m583qs1favgky\",\"invoiceNumber\":\"768230705\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422179472\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/n37m583qs1favgky\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-18 16:12:57'),
(59,9,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"etapa\":\"iniciando\"}','2026-03-18 16:25:45'),
(60,9,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"response\":{\"object\":\"payment\",\"id\":\"pay_x04cstes15abqhl0\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/x04cstes15abqhl0\",\"invoiceNumber\":\"768242557\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422186246\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/x04cstes15abqhl0\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-18 16:25:45'),
(61,10,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"etapa\":\"iniciando\"}','2026-03-18 16:29:01'),
(62,10,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"response\":{\"object\":\"payment\",\"id\":\"pay_x8nthvevjxckepx1\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/x8nthvevjxckepx1\",\"invoiceNumber\":\"768245943\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422188483\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/x8nthvevjxckepx1\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-18 16:29:01'),
(63,11,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"etapa\":\"iniciando\"}','2026-03-18 16:30:02'),
(64,11,1,'geracao','{\"request\":{\"customer\":\"cus_000165729598\",\"billingType\":\"BOLETO\",\"value\":25,\"dueDate\":\"2026-04-10\",\"description\":\"Teste\",\"externalReference\":\"9\"},\"response\":{\"object\":\"payment\",\"id\":\"pay_xtnoevt7b7bm57mw\",\"dateCreated\":\"2026-03-18\",\"customer\":\"cus_000165729598\",\"checkoutSession\":null,\"paymentLink\":null,\"value\":25,\"netValue\":24.01,\"originalValue\":null,\"interestValue\":null,\"description\":\"Teste\",\"billingType\":\"BOLETO\",\"canBePaidAfterDueDate\":true,\"pixTransaction\":null,\"status\":\"PENDING\",\"dueDate\":\"2026-04-10\",\"originalDueDate\":\"2026-04-10\",\"paymentDate\":null,\"clientPaymentDate\":null,\"installmentNumber\":null,\"invoiceUrl\":\"https:\\/\\/www.asaas.com\\/i\\/xtnoevt7b7bm57mw\",\"invoiceNumber\":\"768246932\",\"externalReference\":\"9\",\"deleted\":false,\"anticipated\":false,\"anticipable\":false,\"creditDate\":null,\"estimatedCreditDate\":null,\"transactionReceiptUrl\":null,\"nossoNumero\":\"422189073\",\"bankSlipUrl\":\"https:\\/\\/www.asaas.com\\/b\\/pdf\\/xtnoevt7b7bm57mw\",\"lastInvoiceViewedDate\":null,\"lastBankSlipViewedDate\":null,\"discount\":{\"value\":0,\"limitDate\":null,\"dueDateLimitDays\":0,\"type\":\"FIXED\"},\"fine\":{\"value\":0,\"type\":\"FIXED\"},\"interest\":{\"value\":0,\"type\":\"PERCENTAGE\"},\"postalService\":false,\"escrow\":null,\"refunds\":null},\"http_code\":200}','2026-03-18 16:30:02'),
(65,3,1,'webhook','{\"action\":\"order.canceled\",\"api_version\":\"v1\",\"application_id\":\"2191022570663580\",\"data\":{\"currency_id\":\"BRL\",\"external_reference\":\"4\",\"id\":\"ORD01KKVY88Z90D6BP21C0591A6JQ\",\"status\":\"canceled\",\"status_detail\":\"expired\",\"total_amount\":\"100.00\",\"total_paid_amount\":\"100.00\",\"transactions\":{\"payments\":[{\"amount\":\"100.00\",\"id\":\"PAY01KKVY88ZMV8JAXJ7G77C0ASTG\",\"payment_method\":{\"id\":\"bolbradesco\",\"installments\":0,\"type\":\"ticket\"},\"reference\":{\"id\":\"000a22y6fx\"},\"status\":\"expired\",\"status_detail\":\"expired\"}]},\"type\":\"online\",\"version\":3},\"date_created\":\"2026-03-19T03:03:55.220878271Z\",\"live_mode\":true,\"type\":\"order\",\"user_id\":\"711799906\"}','2026-03-19 00:03:56'),
(66,12,1,'geracao','{\"request\":{\"apiKey\":\"apk_49199247-ZjZisLwhtNnurGEILFfZXQQOlFJkGGNs\",\"token\":\"8F3P70RO1RJX12NHB9WHETV0E4IVRXW20BQGGFBVRCMA\",\"order_id\":\"GN-11-20260324210018-M8QM9\",\"payer_email\":\"gestornow0@gmail.com\",\"payer_name\":\"Renato teste\",\"payer_cpf_cnpj\":\"12696984000\",\"days_due_date\":30,\"type_bank_slip\":\"boletoA4\",\"items\":[{\"description\":\"Faturamento Loca\\u00e7\\u00e3o #011\",\"quantity\":\"1\",\"item_id\":\"11\",\"price_cents\":\"2000\"}],\"per_day_interest\":false,\"notification_url\":\"https:\\/\\/nowgestor.gestornow.com\\/api\\/webhooks\\/boletos\\/paghiper\",\"payer_phone\":\"19986116778\",\"payer_street\":\"RUA OUVIDOR PELEJA\",\"payer_number\":\"611\",\"payer_district\":\"VILA MARIANA\",\"payer_city\":\"S\\u00e3o Paulo\",\"payer_state\":\"SP\",\"payer_zip_code\":\"04128001\"},\"etapa\":\"iniciando_paghiper_create\"}','2026-03-24 21:00:18'),
(67,12,1,'geracao','{\"request\":{\"apiKey\":\"apk_49199247-ZjZisLwhtNnurGEILFfZXQQOlFJkGGNs\",\"token\":\"8F3P70RO1RJX12NHB9WHETV0E4IVRXW20BQGGFBVRCMA\",\"order_id\":\"GN-11-20260324210018-M8QM9\",\"payer_email\":\"gestornow0@gmail.com\",\"payer_name\":\"Renato teste\",\"payer_cpf_cnpj\":\"12696984000\",\"days_due_date\":30,\"type_bank_slip\":\"boletoA4\",\"items\":[{\"description\":\"Faturamento Loca\\u00e7\\u00e3o #011\",\"quantity\":\"1\",\"item_id\":\"11\",\"price_cents\":\"2000\"}],\"per_day_interest\":false,\"notification_url\":\"https:\\/\\/nowgestor.gestornow.com\\/api\\/webhooks\\/boletos\\/paghiper\",\"payer_phone\":\"19986116778\",\"payer_street\":\"RUA OUVIDOR PELEJA\",\"payer_number\":\"611\",\"payer_district\":\"VILA MARIANA\",\"payer_city\":\"S\\u00e3o Paulo\",\"payer_state\":\"SP\",\"payer_zip_code\":\"04128001\"},\"response\":{\"create_request\":{\"result\":\"success\",\"response_message\":\"transacao criada\",\"transaction_id\":\"03J9Q90Z1MI7VR26\",\"created_date\":\"2026-03-24 21:00:18\",\"value_cents\":\"2000\",\"status\":\"pending\",\"order_id\":\"GN-11-20260324210018-M8QM9\",\"due_date\":\"2026-04-23\",\"bank_slip\":{\"digitable_line\":\"34191.09461 42868.930241 61514.190000 1 14250000002000\",\"url_slip\":\"https:\\/\\/www.paghiper.com\\/checkout\\/boleto\\/5d16ee03774bdfcac1a71c4408caf906009d3156ba195f5ef7043e93611d8c5ebf3ab3a8c6d756ffcb5b9e02a4bbf459631ceb0ce4f1762affc60c48d188701d\\/03J9Q90Z1MI7VR26\\/155160356\",\"url_slip_pdf\":\"https:\\/\\/www.paghiper.com\\/checkout\\/boleto\\/5d16ee03774bdfcac1a71c4408caf906009d3156ba195f5ef7043e93611d8c5ebf3ab3a8c6d756ffcb5b9e02a4bbf459631ceb0ce4f1762affc60c48d188701d\\/03J9Q90Z1MI7VR26\\/155160356\\/pdf\",\"bar_code_number_to_image\":\"34191142500000020001094642868930246151419000\"},\"http_code\":201,\"http_cod\":201}},\"http_code\":201}','2026-03-24 21:00:20');

--
-- Table structure for table `categoria_contas`
--

CREATE TABLE `categoria_contas` (
  `id_categoria_contas` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `nome` varchar(255) DEFAULT NULL,
  `tipo` varchar(255) DEFAULT NULL,
  `descricao` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_categoria_contas`),
  KEY `categoria_contas_id_empresa_index` (`id_empresa`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categoria_contas`
--

INSERT INTO `categoria_contas` VALUES
(1,1,'Locação','receita',NULL,'2026-03-11 22:03:15','2026-03-11 22:03:15');

--
-- Table structure for table `categorias_menu`
--

CREATE TABLE `categorias_menu` (
  `id_categoria` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) DEFAULT NULL,
  `cor` varchar(255) DEFAULT NULL,
  `icone` varchar(255) DEFAULT NULL,
  `ordem` int(11) DEFAULT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_categoria`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categorias_menu`
--

INSERT INTO `categorias_menu` VALUES
(1,'Dashboard',NULL,NULL,0,1,'2026-03-11 11:00:35','2026-03-11 11:00:35'),
(2,'Cadastros',NULL,NULL,1,1,'2026-03-11 11:00:41','2026-03-11 11:00:41'),
(3,'Locações',NULL,NULL,2,1,'2026-03-11 11:00:47','2026-03-11 11:00:47'),
(4,'Vendas',NULL,NULL,3,1,'2026-03-11 11:01:00','2026-03-11 11:01:00'),
(5,'Financeiro',NULL,NULL,4,1,'2026-03-11 11:01:06','2026-03-11 11:01:06'),
(6,'Admin',NULL,NULL,5,1,'2026-03-11 11:01:12','2026-03-11 11:01:12');

--
-- Table structure for table `client_contracts`
--

CREATE TABLE `client_contracts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_plano` bigint(20) unsigned DEFAULT NULL,
  `id_plano_contratado` bigint(20) unsigned DEFAULT NULL,
  `cliente_razao_social` varchar(255) DEFAULT NULL,
  `cliente_cnpj_cpf` varchar(255) DEFAULT NULL,
  `cliente_email` varchar(255) DEFAULT NULL,
  `cliente_endereco` varchar(255) DEFAULT NULL,
  `valor_adesao` decimal(15,2) DEFAULT NULL,
  `valor_mensalidade` decimal(15,2) DEFAULT NULL,
  `limites_contratados` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`limites_contratados`)),
  `versao_contrato` varchar(255) DEFAULT NULL,
  `titulo_contrato` varchar(255) DEFAULT NULL,
  `corpo_contrato` longtext DEFAULT NULL,
  `hash_documento` varchar(255) DEFAULT NULL,
  `assinatura_base64` longtext DEFAULT NULL,
  `assinado_por_nome` varchar(255) DEFAULT NULL,
  `assinado_por_documento` varchar(255) DEFAULT NULL,
  `assinado_por_email` varchar(255) DEFAULT NULL,
  `ip_aceite` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `aceito_em` datetime DEFAULT NULL,
  `recibo_gerado` tinyint(1) NOT NULL DEFAULT 0,
  `recibo_path` varchar(255) DEFAULT NULL,
  `recibo_gerado_em` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `motivo_revogacao` text DEFAULT NULL,
  `revogado_em` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_contracts_id_empresa_index` (`id_empresa`),
  KEY `client_contracts_id_plano_index` (`id_plano`),
  KEY `client_contracts_id_plano_contratado_index` (`id_plano_contratado`),
  CONSTRAINT `client_contracts_id_plano_contratado_foreign` FOREIGN KEY (`id_plano_contratado`) REFERENCES `planos_contratados` (`id`) ON DELETE SET NULL,
  CONSTRAINT `client_contracts_id_plano_foreign` FOREIGN KEY (`id_plano`) REFERENCES `planos` (`id_plano`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client_contracts`
--

INSERT INTO `client_contracts` VALUES
(1,1,1,3,'GestorNow Tecnologia Inova Simples (I.S)','64904128000162','gestornow0@gmail.com','RUA OUVIDOR PELEJA, N 611, VILA MARIANA, São Paulo, SP, CEP: 04128001',5.00,199.90,'{\"admin\":0,\"usu_rios\":0,\"logs\":0,\"clientes\":0,\"cadastrar_cliente\":0,\"listar_clientes\":0,\"dashboard\":0,\"financeiro\":0,\"contas_a_pagar\":0,\"contas_a_receber\":0,\"fluxo_de_caixa\":0,\"categorias\":0,\"bancos\":0,\"boletos\":0,\"loca_es\":0,\"nova_loca_o\":0,\"lista_de_loca_es\":0,\"novo_or_amento\":0,\"lista_de_or_amentos\":0,\"contrato_de_medi_o\":0,\"pdv\":0,\"nova_venda\":0,\"lista_de_vendas\":0,\"lista_de_produtos\":0,\"relat_rio_de_vendas\":0,\"formas_de_pagamento\":0,\"expedi_o\":0,\"log_stica\":0,\"pedidos_do_dia\":0,\"troca_de_produto\":0,\"faturas\":true,\"faturamento\":0,\"faturas_emitidas\":0,\"permiss_es\":0,\"criar_permiss_o\":0,\"listar_permiss_es\":0,\"produtos\":0,\"cadastrar_produto\":0,\"listar_produtos\":0,\"configura_es\":0,\"empresa\":0,\"modelos_de_contratos\":0,\"relatorios\":true,\"bancos_boleto\":true,\"assinatura_digital\":true,\"modelos_contrato\":\"Ilimitado\",\"usuarios\":1,\"locacoes\":\"completo\"}','1.0','Termos de Uso e Licenciamento de Software - Gestor Now','TERMOS DE USO E LICENCIAMENTO DE SOFTWARE - GESTOR NOW\nPelo presente instrumento, a empresa CONTRATANTE adere ao plano de licenciamento de uso do software Gestor Now, declarando ciencia e concordancia integral com as clausulas abaixo:\n\nCLAUSULA PRIMEIRA - DO OBJETO E LIMITES\nA CONTRATADA (Gestor Now) outorga a CONTRATANTE uma licenca de uso, em carater nao exclusivo e intransferivel, do sistema de gestao, restrito aos limites de cadastros (clientes, produtos, locacoes e usuarios) estipulados no plano contratado no momento deste aceite.\n\nCLAUSULA SEGUNDA - DOS VALORES E REAJUSTE\nA CONTRATANTE declara ciencia de que a taxa de adesao (setup) e devida no ato da contratacao, e as mensalidades possuem vencimento recorrente.\nParagrafo Unico: O valor da mensalidade sera reajustado a cada 12 (doze) meses, contados da data de aceite deste termo, com base no indice de inflacao acumulado do periodo (IGP-M/FGTS ou IPCA/IBGE). Em caso de deflacao (indice negativo), as partes concordam em manter o valor vigente, nao aplicando reducao a mensalidade.\n\nCLAUSULA TERCEIRA - DA INADIMPLENCIA E SUSPENSAO\nEm caso de atraso no pagamento da mensalidade superior a 5 (cinco) dias, o acesso ao sistema sera suspenso automaticamente.\nParagrafo Unico: Apos a suspensao, a liberacao do acesso ocorrera exclusivamente apos a compensacao e baixa automatica do pagamento pelos provedores financeiros (gateways) integrados a Gestor Now. Nao serao aceitos comprovantes de agendamento para liberacao manual.\n\nCLAUSULA QUARTA - DA MIGRACAO DE DADOS\nA eventual migracao de dados (importacao de planilhas e cadastros) de sistemas anteriores da CONTRATANTE para a Gestor Now sera realizada no prazo de ate 10 (dez) dias uteis apos o envio das informacoes formatadas.\nParagrafo Unico: O prazo de migracao nao impede o faturamento e a utilizacao imediata do sistema pela CONTRATANTE para novas operacoes.\n\nCLAUSULA QUINTA - DE DESENVOLVIMENTOS CUSTOMIZADOS\nO licenciamento nao inclui o desenvolvimento de funcoes exclusivas. A execucao de qualquer nova funcionalidade solicitada pela CONTRATANTE sera analisada pela equipe tecnica da Gestor Now e, se viavel, sera objeto de orcamento e cobranca adicional, mediante aprovacao previa.\n\nCLAUSULA SEXTA - DA PROTECAO DE DADOS (LGPD)\nEm estrito cumprimento a Lei Geral de Protecao de Dados Pessoais (Lei n 13.853/2019), a Gestor Now compromete-se a manter em sigilo absoluto e hospedar com seguranca todos os dados da CONTRATANTE e de seus respectivos clientes. A Gestor Now atua apenas como processadora dos dados, sendo a CONTRATANTE a unica responsavel legal pela coleta e autorizacao dos dados de seus clientes finais inseridos na plataforma.\n\nCLAUSULA SETIMA - DO CANCELAMENTO\nO presente contrato nao possui fidelidade (salvo negociacao especifica). A CONTRATANTE podera solicitar o cancelamento a qualquer momento, mediante aviso previo de 30 (trinta) dias.\nParagrafo Unico: O cancelamento nao isenta a CONTRATANTE de faturas ja emitidas ou do ciclo vigente de 30 dias, nao havendo estorno ou devolucao de valores proporcionais.\n\nA assinatura digital registrada neste aceite, atrelada ao IP e dados de conexao, possui validade juridica, representando concordancia integral com os termos deste contrato.\n\nDADOS DO CLIENTE\nNome/Razao Social: GestorNow Tecnologia Inova Simples (I.S)\nCNPJ/CPF: 64904128000162\nE-mail: gestornow0@gmail.com\nEndereco: RUA OUVIDOR PELEJA, N 611, VILA MARIANA, São Paulo, SP, CEP: 04128001\n\nDADOS DA GESTOR NOW\nNome/Razao Social: GestorNow Tecnologia Inova Simples (I.S)\nCNPJ/CPF: 64904128000162\nE-mail: gestornow0@gmail.com\nEndereco: RUA OUVIDOR PELEJA, N 611, VILA MARIANA, São Paulo, SP, CEP: 04128001\n\nDADOS DO PLANO CONTRATADO\nNome do Plano: Plano Gestor\nValor Adesao: R$ 5,00\nValor Mensalidade: R$ 199,90\nLimites: Admin: Ilimitado | Usu rios: Ilimitado | Logs: Ilimitado | Limite de Clientes: Ilimitado | Cadastrar cliente: Ilimitado | Listar clientes: Ilimitado | Dashboard: Ilimitado | Modulo Financeiro: Ilimitado | Contas a pagar: Ilimitado | Contas a receber: Ilimitado | Fluxo de caixa: Ilimitado | Categorias: Ilimitado | Bancos: Ilimitado | Boletos: Ilimitado | Loca es: Ilimitado | Nova loca o: Ilimitado | Lista de loca es: Ilimitado | Novo or amento: Ilimitado | Lista de or amentos: Ilimitado | Contrato de medi o: Ilimitado | Pdv: Ilimitado | Nova venda: Ilimitado | Lista de vendas: Ilimitado | Lista de produtos: Ilimitado | Relat rio de vendas: Ilimitado | Formas de pagamento: Ilimitado | Expedi o: Ilimitado | Log stica: Ilimitado | Pedidos do dia: Ilimitado | Troca de produto: Ilimitado | Faturas: Disponivel | Faturamento: Ilimitado | Faturas emitidas: Ilimitado | Permiss es: Ilimitado | Criar permiss o: Ilimitado | Listar permiss es: Ilimitado | Limite de Produtos: Ilimitado | Cadastrar produto: Ilimitado | Listar produtos: Ilimitado | Configura es: Ilimitado | Empresa: Ilimitado | Modelos de contratos: Ilimitado | Relatorios: Disponivel | Bancos para Boleto: Disponivel | Assinatura Digital: Disponivel | Modelos de Contrato: Ilimitado | Limite de Usuarios: 1 | Modulo de Locacoes: Completo\n\nData e Hora do Aceite: 11/03/2026 14:38:14\nIP e Dispositivo: 2804:868:d054:7615:e873:744b:2056:7cc7 - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','fdf2e0bdf24f40969b59070c578906aeb85053a5929abfe15ad0fe34817f8537','data:image/png;base64,[encoded data, 14480 characters]','GestorNow','64904128000162','gestornow0@gmail.com','2804:868:d054:7615:e873:744b:2056:7cc7','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-11 14:38:14',1,'recibos/adesao/recibo-64904128000162-20260311-1.pdf','2026-03-13 18:14:04','ativo',NULL,NULL,'2026-03-11 14:38:14','2026-03-13 18:14:04'),
(4,4,2,10,'BNS ENGENHARIA E CONSTRUÇÕES LTDA','30456657000129','loc@bnsengenharia.com','salvador, N 61, CASA, paralela, Salvador, BA, CEP: 41730101',99.90,99.90,'{\"admin\":0,\"usu_rios\":2,\"logs\":0,\"clientes\":0,\"cadastrar_cliente\":500,\"listar_clientes\":500,\"dashboard\":0,\"financeiro\":0,\"contas_a_pagar\":0,\"contas_a_receber\":0,\"fluxo_de_caixa\":0,\"categorias\":0,\"bancos\":0,\"loca_es\":0,\"nova_loca_o\":0,\"lista_de_loca_es\":0,\"novo_or_amento\":0,\"lista_de_or_amentos\":0,\"contrato_de_medi_o\":0,\"pdv\":0,\"nova_venda\":0,\"lista_de_vendas\":0,\"lista_de_produtos\":0,\"relat_rio_de_vendas\":0,\"formas_de_pagamento\":0,\"expedi_o\":0,\"log_stica\":0,\"pedidos_do_dia\":0,\"troca_de_produto\":0,\"faturas\":true,\"faturamento\":0,\"faturas_emitidas\":0,\"permiss_es\":0,\"criar_permiss_o\":0,\"listar_permiss_es\":0,\"produtos\":0,\"cadastrar_produto\":500,\"listar_produtos\":500,\"configura_es\":0,\"empresa\":0,\"documentos\":1,\"fornecedores\":0,\"relatorios\":true,\"bancos_boleto\":true,\"assinatura_digital\":true,\"modelos_contrato\":\"Ilimitado\",\"usuarios\":1,\"locacoes\":\"completo\"}','1.0','Termos de Uso e Licenciamento de Software - Gestor Now','TERMOS DE USO E LICENCIAMENTO DE SOFTWARE - GESTOR NOW\nPelo presente instrumento, a empresa CONTRATANTE adere ao plano de licenciamento de uso do software Gestor Now, declarando ciencia e concordancia integral com as clausulas abaixo:\n\nCLAUSULA PRIMEIRA - DO OBJETO E LIMITES\nA CONTRATADA (Gestor Now) outorga a CONTRATANTE uma licenca de uso, em carater nao exclusivo e intransferivel, do sistema de gestao, restrito aos limites de cadastros (clientes, produtos, locacoes e usuarios) estipulados no plano contratado no momento deste aceite.\n\nCLAUSULA SEGUNDA - DOS VALORES E REAJUSTE\nA CONTRATANTE declara ciencia de que a taxa de adesao (setup) e devida no ato da contratacao, e as mensalidades possuem vencimento recorrente.\nParagrafo Unico: O valor da mensalidade sera reajustado a cada 12 (doze) meses, contados da data de aceite deste termo, com base no indice de inflacao acumulado do periodo (IGP-M/FGTS ou IPCA/IBGE). Em caso de deflacao (indice negativo), as partes concordam em manter o valor vigente, nao aplicando reducao a mensalidade.\n\nCLAUSULA TERCEIRA - DA INADIMPLENCIA E SUSPENSAO\nEm caso de atraso no pagamento da mensalidade superior a 5 (cinco) dias, o acesso ao sistema sera suspenso automaticamente.\nParagrafo Unico: Apos a suspensao, a liberacao do acesso ocorrera exclusivamente apos a compensacao e baixa automatica do pagamento pelos provedores financeiros (gateways) integrados a Gestor Now. Nao serao aceitos comprovantes de agendamento para liberacao manual.\n\nCLAUSULA QUARTA - DA MIGRACAO DE DADOS\nA eventual migracao de dados (importacao de planilhas e cadastros) de sistemas anteriores da CONTRATANTE para a Gestor Now sera realizada no prazo de ate 10 (dez) dias uteis apos o envio das informacoes formatadas.\nParagrafo Unico: O prazo de migracao nao impede o faturamento e a utilizacao imediata do sistema pela CONTRATANTE para novas operacoes.\n\nCLAUSULA QUINTA - DE DESENVOLVIMENTOS CUSTOMIZADOS\nO licenciamento nao inclui o desenvolvimento de funcoes exclusivas. A execucao de qualquer nova funcionalidade solicitada pela CONTRATANTE sera analisada pela equipe tecnica da Gestor Now e, se viavel, sera objeto de orcamento e cobranca adicional, mediante aprovacao previa.\n\nCLAUSULA SEXTA - DA PROTECAO DE DADOS (LGPD)\nEm estrito cumprimento a Lei Geral de Protecao de Dados Pessoais (Lei n 13.853/2019), a Gestor Now compromete-se a manter em sigilo absoluto e hospedar com seguranca todos os dados da CONTRATANTE e de seus respectivos clientes. A Gestor Now atua apenas como processadora dos dados, sendo a CONTRATANTE a unica responsavel legal pela coleta e autorizacao dos dados de seus clientes finais inseridos na plataforma.\n\nCLAUSULA SETIMA - DO CANCELAMENTO\nO presente contrato nao possui fidelidade (salvo negociacao especifica). A CONTRATANTE podera solicitar o cancelamento a qualquer momento, mediante aviso previo de 30 (trinta) dias.\nParagrafo Unico: O cancelamento nao isenta a CONTRATANTE de faturas ja emitidas ou do ciclo vigente de 30 dias, nao havendo estorno ou devolucao de valores proporcionais.\n\nA assinatura digital registrada neste aceite, atrelada ao IP e dados de conexao, possui validade juridica, representando concordancia integral com os termos deste contrato.\n\nDADOS DO CLIENTE\nNome/Razao Social: BNS ENGENHARIA E CONSTRUÇÕES LTDA\nCNPJ/CPF: 30456657000129\nE-mail: loc@bnsengenharia.com\nEndereco: salvador, N 61, CASA, paralela, Salvador, BA, CEP: 41730101\n\nDADOS DA GESTOR NOW\nNome/Razao Social: GestorNow Tecnologia Inova Simples (I.S)\nCNPJ/CPF: 64904128000162\nE-mail: gestornow0@gmail.com\nEndereco: RUA OUVIDOR PELEJA, N 611, VILA MARIANA, São Paulo, SP, CEP: 04128001\n\nDADOS DO PLANO CONTRATADO\nNome do Plano: Plano Start\nValor Adesao: R$ 99,90\nValor Mensalidade: R$ 99,90\nLimites: Clientes - Limite: 500 | Produtos - Limite: 500 | Locacoes Completas | 1 Modelo de contrato | Financeiro Completo | Sem emissao de Boleto | Usuarios - Limite: 1\n\nData e Hora do Aceite: 18/03/2026 19:51:05\nIP e Dispositivo: 2804:14d:7244:82ca:b52d:2662:ec43:83f3 - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0','fe1c80b7b460575f5096a201e99eebd72da32a8d8c9d04f1858ae90f344adcb1','data:image/png;base64,[encoded data, 21264 characters]','BONIFÁCIO NEVES DE SOUZA','05744291580','loc@bnsengenharia.com','2804:14d:7244:82ca:b52d:2662:ec43:83f3','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0','2026-03-18 19:51:05',1,'recibos/adesao/recibo-30456657000129-20260318-4.pdf','2026-03-18 19:51:28','ativo',NULL,NULL,'2026-03-18 19:51:05','2026-03-18 19:51:28');

--
-- Table structure for table `clientes`
--

CREATE TABLE `clientes` (
  `id_clientes` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_filial` bigint(20) unsigned DEFAULT NULL,
  `nome` varchar(255) DEFAULT NULL,
  `cep` varchar(255) DEFAULT NULL,
  `endereco` varchar(255) DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `complemento` varchar(255) DEFAULT NULL,
  `rg_ie` varchar(255) DEFAULT NULL,
  `cpf_cnpj` varchar(255) DEFAULT NULL,
  `razao_social` varchar(255) DEFAULT NULL,
  `bairro` varchar(255) DEFAULT NULL,
  `cidade` varchar(255) DEFAULT NULL,
  `uf` char(2) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `endereco_entrega` varchar(255) DEFAULT NULL,
  `numero_entrega` varchar(255) DEFAULT NULL,
  `complemento_entrega` varchar(255) DEFAULT NULL,
  `cep_entrega` varchar(255) DEFAULT NULL,
  `telefone` varchar(255) DEFAULT NULL,
  `data_nascimento` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `id_tipo_pessoa` bigint(20) unsigned DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `nomeImagemCliente` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_clientes`),
  KEY `clientes_id_empresa_index` (`id_empresa`),
  KEY `clientes_id_filial_index` (`id_filial`),
  KEY `clientes_id_tipo_pessoa_index` (`id_tipo_pessoa`),
  CONSTRAINT `clientes_id_empresa_foreign` FOREIGN KEY (`id_empresa`) REFERENCES `empresa` (`id_empresa`) ON DELETE SET NULL,
  CONSTRAINT `clientes_id_filial_foreign` FOREIGN KEY (`id_filial`) REFERENCES `empresa` (`id_empresa`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clientes`
--

INSERT INTO `clientes` VALUES
(1,1,NULL,'PRIME VIDEO LTDA','20751000','AVENIDA SUBURBANA','7471','SALA 201 PARTE',NULL,'68634245000104',NULL,'ABOLICAO','Brasília','DF','gestornow0@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,'ativo',2,NULL,NULL,'2026-03-11 15:31:28','2026-03-20 00:00:31',NULL),
(2,1,NULL,'Renato teste','13481450',NULL,NULL,NULL,NULL,'12696984000','Renato teste',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ativo',1,NULL,NULL,'2026-03-11 19:45:05','2026-03-26 22:00:25',NULL),
(4,5,NULL,'ALVES DA CUNHA ENGENHARIA, CONSTRUCOES E SERVICOS LTDA','41820768','R CORONEL ALMERINDO REHEM','000082','SALA 901 9 ANDAR EDIF BAH EXE CENTER',NULL,'48.955.788/0001-16','GRUPO ALVES DA CUNHA','CAMINHO DAS ARVORES',NULL,NULL,'contato@alvesdacunha.com.br',NULL,NULL,NULL,NULL,'(71) 3345-6486',NULL,'ativo',2,NULL,NULL,'2026-03-18 08:04:43','2026-03-18 08:04:43',NULL),
(5,5,NULL,'MATSU CONCEICAO SATO 00269943560','45690000','RUA AGENOR MIRANDA','35',NULL,NULL,'14.109.296/0001-98',NULL,'CENTRO',NULL,NULL,'matsu-sato@hotmail.com',NULL,NULL,NULL,NULL,'(73) 9828-9985',NULL,'ativo',2,NULL,NULL,'2026-03-18 12:22:00','2026-03-18 12:22:24','2026-03-18 12:22:24'),
(6,5,NULL,'CLINICA DE PSICOLOGIA E DESENVOLVIMENTO INCLUSIVA TOY LTDA','30190912','AVENIDA AUGUSTO DE LIMA','407','SALA 1307 1308',NULL,'53.978.812/0001-72','INCLUSIVA TOY','CENTRO',NULL,NULL,'contato@conectagc.com.br',NULL,NULL,NULL,NULL,'(31) 3467-1317',NULL,'ativo',2,NULL,NULL,'2026-03-18 12:54:03','2026-03-18 12:59:10','2026-03-18 12:59:10'),
(7,5,NULL,'ARCA DA ALIANCA MATERIAIS DE CONSTRUCAO LTDA','37430000','RUA MAJOR BENEDITO PROSPERI','69','B',NULL,'03.111.941/0001-90',NULL,'CENTRO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ativo',2,NULL,NULL,'2026-03-18 12:58:38','2026-03-18 12:59:10','2026-03-18 12:59:10'),
(8,5,NULL,'49.604.013 MARCELO GLORIA DA SILVA','94465210','RUA CAMPO REAL','329','CASA 1',NULL,'49.604.013/0001-69',NULL,'SAO TOME',NULL,NULL,'marmoong19@gmail.com',NULL,NULL,NULL,NULL,'(51) 9938-6641',NULL,'ativo',2,NULL,NULL,'2026-03-18 13:06:49','2026-03-18 13:12:31','2026-03-18 13:12:31'),
(9,5,NULL,'50.455.777 CAROLINE NYCOLLE LIRA CHAGAS','08061000','AVENIDA ANTONIO LOUZADA ANTUNES','267',NULL,NULL,'50.455.777/0001-19',NULL,'JARDIM PEDRO JOSE NUNES',NULL,NULL,'carol.nycolle@outlook.com',NULL,NULL,NULL,NULL,'(0) 0-',NULL,'ativo',2,NULL,NULL,'2026-03-18 13:07:10','2026-03-18 13:12:31','2026-03-18 13:12:31'),
(10,7,NULL,'Marina Zequin','13482-791','Rua Osvaldo Galiza','367',NULL,NULL,'079.828.506-00','MZequin','Jardim Águas da Serra',NULL,NULL,'actlocarthur@gmail.com','Rua Osvaldo Galiza','367',NULL,'13482-791','(19) 98235-9243','1942-10-06','ativo',1,NULL,NULL,'2026-03-18 14:38:55','2026-03-18 14:38:55',NULL),
(11,5,NULL,'INTERMARITIMA PORTOS E LOGISTICA S/A','43813000','V MATOIM','482','ZIP',NULL,'96.825.575/0017-80','INTER - TMI','CENTRO INDUSTRIAL DE ARATU',NULL,NULL,'railton@intermaritima.com.br',NULL,NULL,NULL,NULL,'(71) 38799-717',NULL,'ativo',2,NULL,NULL,'2026-03-19 13:21:02','2026-03-19 13:21:02',NULL),
(12,5,NULL,'CONSTRUTORA FG LTDA','40015010','RUA MIGUEL CALMON','290','ED. BELO HORIZONTE SALA 703',NULL,'20.068.669/0001-22','FG SERVICOS ADMINISTRATIVOS EIRELI','COMERCIO',NULL,NULL,'lfbguerreiro@gmail.com',NULL,NULL,NULL,NULL,'(71) 99372-2299',NULL,'ativo',2,NULL,NULL,'2026-03-19 13:55:20','2026-03-19 13:55:20',NULL),
(13,5,NULL,'JULIANA DE ALMEIDA BARROS 40272602876','18411-120','Rua Rui França','106',NULL,NULL,'36.065.730/0001-18',NULL,'Jardim Virgínia','Itapeva','SP',NULL,NULL,NULL,NULL,NULL,'(15) 9702-5132',NULL,'ativo',2,NULL,NULL,'2026-03-20 00:35:32','2026-03-20 00:36:51','2026-03-20 00:36:51'),
(14,5,NULL,'REVITALIZA CLINICA ESTETICA AVANCADA LTDA','29630000','RUA CARMEN ALZERINA DE SOUZA ULIANA','231',NULL,NULL,'43.872.313/0001-42','REVITALIZA CLINICA ESTETICA AVANCADA','BELLARMINO ULIANA',NULL,NULL,'marcia.martins1989@hotmail.com',NULL,NULL,NULL,NULL,'(27) 9845-2837',NULL,'ativo',2,NULL,NULL,'2026-03-20 00:36:26','2026-03-20 00:36:51','2026-03-20 00:36:51'),
(18,4,NULL,'DJANIRA PEREIRA DE MORAES 66411050163','75790000','RUA 03','S/N','QUADRA 02;LOTE 12',NULL,'36.112.179/0001-16',NULL,'BAIRRO VISTA ALEGRE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'(62) 8412-5681',NULL,'ativo',2,NULL,NULL,'2026-03-23 23:26:19','2026-03-23 23:26:30','2026-03-23 23:26:30'),
(19,14,NULL,'Bruno Vargas',NULL,NULL,NULL,NULL,NULL,'350.593.288-48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ativo',1,NULL,NULL,'2026-03-30 13:08:13','2026-03-30 13:08:13',NULL);

--
-- Table structure for table `contas_a_pagar`
--

CREATE TABLE `contas_a_pagar` (
  `id_contas` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_clientes` bigint(20) unsigned DEFAULT NULL,
  `id_fornecedores` bigint(20) unsigned DEFAULT NULL,
  `id_venda` bigint(20) unsigned DEFAULT NULL,
  `id_locacao` bigint(20) unsigned DEFAULT NULL,
  `id_origem` bigint(20) unsigned DEFAULT NULL,
  `id_bancos` bigint(20) unsigned DEFAULT NULL,
  `id_categoria_contas` bigint(20) unsigned DEFAULT NULL,
  `id_usuario` bigint(20) unsigned DEFAULT NULL,
  `descricao` text DEFAULT NULL,
  `documento` varchar(255) DEFAULT NULL,
  `boleto` varchar(255) DEFAULT NULL,
  `valor_total` decimal(15,2) DEFAULT NULL,
  `valor_pago` decimal(15,2) DEFAULT NULL,
  `juros` decimal(15,2) DEFAULT NULL,
  `multa` decimal(15,2) DEFAULT NULL,
  `desconto` decimal(15,2) DEFAULT NULL,
  `data_emissao` date DEFAULT NULL,
  `data_vencimento` date DEFAULT NULL,
  `data_pagamento` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `origem` varchar(255) DEFAULT NULL,
  `id_forma_pagamento` bigint(20) unsigned DEFAULT NULL,
  `observacoes` text DEFAULT NULL,
  `numero_parcela` varchar(255) DEFAULT NULL,
  `total_parcelas` varchar(255) DEFAULT NULL,
  `id_parcelamento` varchar(36) DEFAULT NULL,
  `tipo_recorrencia` varchar(255) DEFAULT NULL,
  `quantidade_recorrencias` varchar(255) DEFAULT NULL,
  `id_recorrencia` varchar(36) DEFAULT NULL,
  `is_recorrente` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_contas`),
  KEY `contas_a_pagar_id_empresa_index` (`id_empresa`),
  KEY `contas_a_pagar_id_clientes_index` (`id_clientes`),
  KEY `contas_a_pagar_id_fornecedores_index` (`id_fornecedores`),
  KEY `contas_a_pagar_id_venda_index` (`id_venda`),
  KEY `contas_a_pagar_id_locacao_index` (`id_locacao`),
  KEY `contas_a_pagar_id_origem_index` (`id_origem`),
  KEY `contas_a_pagar_id_bancos_index` (`id_bancos`),
  KEY `contas_a_pagar_id_categoria_contas_index` (`id_categoria_contas`),
  KEY `contas_a_pagar_id_usuario_index` (`id_usuario`),
  KEY `contas_a_pagar_id_forma_pagamento_index` (`id_forma_pagamento`),
  KEY `contas_a_pagar_id_parcelamento_index` (`id_parcelamento`) USING BTREE,
  KEY `contas_a_pagar_id_recorrencia_index` (`id_recorrencia`) USING BTREE,
  CONSTRAINT `contas_a_pagar_id_bancos_foreign` FOREIGN KEY (`id_bancos`) REFERENCES `bancos` (`id_bancos`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_pagar_id_categoria_contas_foreign` FOREIGN KEY (`id_categoria_contas`) REFERENCES `categoria_contas` (`id_categoria_contas`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_pagar_id_clientes_foreign` FOREIGN KEY (`id_clientes`) REFERENCES `clientes` (`id_clientes`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_pagar_id_forma_pagamento_foreign` FOREIGN KEY (`id_forma_pagamento`) REFERENCES `forma_pagamento` (`id_forma_pagamento`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_pagar_id_fornecedores_foreign` FOREIGN KEY (`id_fornecedores`) REFERENCES `fornecedores` (`id_fornecedores`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_pagar_id_usuario_foreign` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contas_a_pagar`
--

INSERT INTO `contas_a_pagar` VALUES
(1,1,NULL,NULL,NULL,2,2,NULL,NULL,NULL,'Locação #O001 - Combustivel para entraga',NULL,NULL,90.00,NULL,NULL,NULL,NULL,'2026-03-11','2026-03-12',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-11 21:01:45','2026-03-11 21:01:45',NULL),
(2,1,NULL,NULL,NULL,3,3,NULL,NULL,NULL,'Locação #O002 - Combustivel para entraga',NULL,NULL,80.00,NULL,NULL,NULL,NULL,'2026-03-11','2026-03-12',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-11 21:12:30','2026-03-11 21:12:30',NULL),
(3,1,NULL,NULL,NULL,4,4,NULL,NULL,NULL,'Locação #O002 - Combustivel',NULL,NULL,60.00,0.00,NULL,NULL,NULL,'2026-03-11','2026-03-12',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-11 21:26:26','2026-03-11 22:14:03',NULL),
(4,1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'teste',NULL,NULL,100.00,0.00,0.00,0.00,0.00,NULL,'2026-03-12',NULL,'pendente',NULL,NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-12 19:03:05','2026-03-12 19:03:18','2026-03-12 19:03:18'),
(5,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tste (Parcela 1/2)',NULL,NULL,50.00,50.00,0.00,0.00,0.00,NULL,'2026-03-12','2026-03-12','pago',NULL,NULL,NULL,'1','2','cb1ae312-92ab-4f58-9df2-39c3f06dc32e','mensal','12',NULL,NULL,'2026-03-12 19:25:43','2026-03-12 19:26:04','2026-03-12 19:26:04'),
(6,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tste (Parcela 2/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-04-11',NULL,'pendente',NULL,NULL,NULL,'2','2','cb1ae312-92ab-4f58-9df2-39c3f06dc32e','mensal','12',NULL,NULL,'2026-03-12 19:25:43','2026-03-12 19:25:43',NULL),
(7,1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'teste (Parcela 1/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-03-12',NULL,'pendente',NULL,NULL,NULL,'1','2','96ee820e-3fa8-4cc9-83ce-00c50d5651fe','mensal','12',NULL,NULL,'2026-03-12 19:26:37','2026-03-12 19:27:00','2026-03-12 19:27:00'),
(8,1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'teste (Parcela 2/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-04-11',NULL,'pendente',NULL,NULL,NULL,'2','2','96ee820e-3fa8-4cc9-83ce-00c50d5651fe','mensal','12',NULL,NULL,'2026-03-12 19:26:37','2026-03-12 19:26:37',NULL),
(9,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'teste (Parcela 1/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-03-12',NULL,'pendente',NULL,NULL,NULL,'1','2','22070ceb-cfcf-420b-980b-5e74d8caf49c','mensal','12',NULL,NULL,'2026-03-12 19:27:24','2026-03-12 19:27:37','2026-03-12 19:27:37'),
(10,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'teste (Parcela 2/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-04-11',NULL,'pendente',NULL,NULL,NULL,'2','2','22070ceb-cfcf-420b-980b-5e74d8caf49c','mensal','12',NULL,NULL,'2026-03-12 19:27:24','2026-03-12 19:27:24',NULL),
(11,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'teste (Parcela 1/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-03-12',NULL,'pendente',NULL,NULL,NULL,'1','2','9cbcf709-df4a-4bb2-8b1f-959ff3036276','mensal','12',NULL,NULL,'2026-03-12 19:28:10','2026-03-12 19:35:04','2026-03-12 19:35:04'),
(12,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'teste (Parcela 2/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-04-11',NULL,'pendente',NULL,NULL,NULL,'2','2','9cbcf709-df4a-4bb2-8b1f-959ff3036276','mensal','12',NULL,NULL,'2026-03-12 19:28:10','2026-03-12 19:28:10',NULL),
(13,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'teste (Parcela 1/2)',NULL,NULL,50.00,50.00,0.00,0.00,0.00,NULL,'2026-03-12','2026-03-12','pago',NULL,NULL,NULL,'1','2','1634674e-d2e5-49e0-8314-d4ad96d8b526','mensal','12',NULL,NULL,'2026-03-12 19:56:40','2026-03-12 20:04:29','2026-03-12 20:04:29'),
(14,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'teste (Parcela 2/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-04-11',NULL,'pendente',NULL,NULL,NULL,'2','2','1634674e-d2e5-49e0-8314-d4ad96d8b526','mensal','12',NULL,NULL,'2026-03-12 19:56:40','2026-03-12 19:56:40',NULL),
(15,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'teste (Parcela 1/2)',NULL,NULL,50.00,50.00,0.00,0.00,0.00,NULL,'2026-03-12','2026-03-12','pago',NULL,NULL,NULL,'1','2','e2c7b7a5-6956-4ac0-993e-f47a07e0fc78','mensal','12',NULL,NULL,'2026-03-12 20:04:49','2026-03-12 20:07:29','2026-03-12 20:07:29'),
(16,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'teste (Parcela 2/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-04-11',NULL,'pendente',NULL,NULL,NULL,'2','2','e2c7b7a5-6956-4ac0-993e-f47a07e0fc78','mensal','12',NULL,NULL,'2026-03-12 20:04:49','2026-03-12 20:04:49',NULL),
(17,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tstes (Parcela 1/2)',NULL,NULL,50.00,0.00,0.00,0.00,0.00,NULL,'2026-03-12',NULL,'pendente',NULL,NULL,NULL,'1','2','a76fd787-634d-49b3-b590-fb8bf2a64256','mensal','12',NULL,NULL,'2026-03-12 20:15:12','2026-03-12 21:59:03',NULL),
(18,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tstes (Parcela 2/2)',NULL,NULL,50.00,50.00,0.00,0.00,0.00,NULL,'2026-04-11','2026-03-13','pago',NULL,NULL,NULL,'2','2','a76fd787-634d-49b3-b590-fb8bf2a64256','mensal','12',NULL,NULL,'2026-03-12 20:15:12','2026-03-12 21:58:27',NULL),
(19,1,NULL,NULL,NULL,8,8,NULL,NULL,NULL,'Locação #006 - Combustivel',NULL,NULL,50.00,NULL,NULL,NULL,NULL,'2026-03-13','2026-03-13',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-13 18:36:08','2026-03-13 18:36:08',NULL),
(20,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TSTE',NULL,NULL,100.00,0.00,0.00,0.00,0.00,NULL,'2026-03-13',NULL,'pendente',NULL,NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-13 18:38:15','2026-03-13 18:38:24','2026-03-13 18:38:24'),
(21,1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'ENERGIA',NULL,NULL,100.00,0.00,0.00,0.00,0.00,NULL,'2026-03-24',NULL,'pendente',NULL,NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-13 18:41:36','2026-03-13 18:42:32',NULL),
(22,1,NULL,NULL,NULL,9,9,NULL,NULL,NULL,'Locação #007 - Combustivel',NULL,NULL,50.00,NULL,NULL,NULL,NULL,'2026-03-13','2026-03-13',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-13 19:04:37','2026-03-13 19:04:37',NULL),
(23,1,NULL,NULL,NULL,10,NULL,NULL,NULL,NULL,'Locação #O002 - Martelete 10KG (Parcela 1/2)',NULL,NULL,25.00,NULL,NULL,NULL,NULL,'2026-03-16','2026-03-25',NULL,'pendente','locacao_terceiro',NULL,'Gerado automaticamente para produto de terceiro na locação','1','2','c4ab66b2-ed74-42b5-8303-e1c344e05b4e',NULL,NULL,NULL,NULL,'2026-03-16 18:35:41','2026-03-17 17:07:47','2026-03-17 17:07:47'),
(24,1,NULL,NULL,NULL,10,NULL,NULL,NULL,NULL,'Locação #O002 - Martelete 10KG (Parcela 2/2)',NULL,NULL,25.00,NULL,NULL,NULL,NULL,'2026-03-16','2026-04-25',NULL,'pendente','locacao_terceiro',NULL,'Gerado automaticamente para produto de terceiro na locação','2','2','c4ab66b2-ed74-42b5-8303-e1c344e05b4e',NULL,NULL,NULL,NULL,'2026-03-16 18:35:41','2026-03-17 17:07:47','2026-03-17 17:07:47'),
(25,1,NULL,NULL,NULL,11,NULL,NULL,NULL,NULL,'Locação #008 - Martelete 10KG',NULL,NULL,189.90,NULL,NULL,NULL,NULL,'2026-03-17','2026-03-30',NULL,'pendente','locacao_terceiro',NULL,'Gerado automaticamente para produto de terceiro na locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-17 17:07:15','2026-03-17 17:07:15',NULL),
(26,7,NULL,NULL,NULL,14,14,NULL,NULL,NULL,'Locação #009 - Combustível',NULL,NULL,5.00,NULL,NULL,NULL,NULL,'2026-03-18','2026-03-18',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-18 14:50:05','2026-03-18 14:50:05',NULL),
(27,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,'Teste Fornecedor',NULL,NULL,1200.00,0.00,0.00,0.00,0.00,NULL,'2026-03-20',NULL,'pendente',NULL,NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-18 15:42:00','2026-03-18 15:42:00',NULL),
(28,5,NULL,2,NULL,NULL,NULL,10,NULL,8,'FRETE',NULL,NULL,1000.00,0.00,0.00,0.00,0.00,NULL,'2026-03-05',NULL,'pendente',NULL,NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-19 13:23:01','2026-03-19 13:27:36',NULL),
(29,1,NULL,NULL,NULL,18,18,NULL,NULL,NULL,'Locação #012 - Mão de obra do funcionário',NULL,NULL,120.00,NULL,NULL,NULL,NULL,'2026-03-26','2026-03-27',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-26 20:11:09','2026-03-26 20:11:49','2026-03-26 20:11:49'),
(30,1,NULL,NULL,NULL,18,18,NULL,NULL,NULL,'Locação #012 - Mão de obra do funcionário',NULL,NULL,120.00,NULL,NULL,NULL,NULL,'2026-03-26','2026-03-27',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-26 20:11:49','2026-03-26 20:13:51','2026-03-26 20:13:51'),
(31,1,NULL,NULL,NULL,18,18,NULL,NULL,1,'Locação #012 - Mão de obra do funcionário',NULL,NULL,120.00,NULL,NULL,NULL,NULL,'2026-03-26','2026-03-26',NULL,'pendente','compra',NULL,'Gerado automaticamente para despesa da locação','1','1',NULL,NULL,NULL,NULL,NULL,'2026-03-26 20:13:51','2026-03-26 20:13:51',NULL),
(32,1,NULL,1,NULL,NULL,NULL,NULL,NULL,7,'teste notificação',NULL,NULL,100.00,0.00,0.00,0.00,0.00,NULL,'2026-03-26',NULL,'pendente',NULL,NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-26 21:40:31','2026-03-26 22:25:13',NULL);

--
-- Table structure for table `contas_a_receber`
--

CREATE TABLE `contas_a_receber` (
  `id_contas` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_clientes` bigint(20) unsigned DEFAULT NULL,
  `id_fornecedores` bigint(20) unsigned DEFAULT NULL,
  `id_venda` bigint(20) unsigned DEFAULT NULL,
  `id_locacao` bigint(20) unsigned DEFAULT NULL,
  `id_bancos` bigint(20) unsigned DEFAULT NULL,
  `id_categoria_contas` bigint(20) unsigned DEFAULT NULL,
  `id_usuario` bigint(20) unsigned DEFAULT NULL,
  `descricao` text DEFAULT NULL,
  `documento` varchar(255) DEFAULT NULL,
  `valor_total` decimal(15,2) DEFAULT NULL,
  `valor_pago` decimal(15,2) DEFAULT NULL,
  `juros` decimal(15,2) DEFAULT NULL,
  `multa` decimal(15,2) DEFAULT NULL,
  `desconto` decimal(15,2) DEFAULT NULL,
  `data_emissao` date DEFAULT NULL,
  `data_vencimento` date DEFAULT NULL,
  `data_pagamento` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `id_forma_pagamento` bigint(20) unsigned DEFAULT NULL,
  `observacoes` text DEFAULT NULL,
  `numero_parcela` varchar(255) DEFAULT NULL,
  `total_parcelas` varchar(255) DEFAULT NULL,
  `id_parcelamento` bigint(20) unsigned DEFAULT NULL,
  `tipo_recorrencia` varchar(255) DEFAULT NULL,
  `quantidade_recorrencias` varchar(255) DEFAULT NULL,
  `id_recorrencia` bigint(20) unsigned DEFAULT NULL,
  `is_recorrente` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_contas`),
  KEY `contas_a_receber_id_empresa_index` (`id_empresa`),
  KEY `contas_a_receber_id_clientes_index` (`id_clientes`),
  KEY `contas_a_receber_id_fornecedores_index` (`id_fornecedores`),
  KEY `contas_a_receber_id_venda_index` (`id_venda`),
  KEY `contas_a_receber_id_locacao_index` (`id_locacao`),
  KEY `contas_a_receber_id_bancos_index` (`id_bancos`),
  KEY `contas_a_receber_id_categoria_contas_index` (`id_categoria_contas`),
  KEY `contas_a_receber_id_usuario_index` (`id_usuario`),
  KEY `contas_a_receber_id_forma_pagamento_index` (`id_forma_pagamento`),
  KEY `contas_a_receber_id_parcelamento_index` (`id_parcelamento`),
  KEY `contas_a_receber_id_recorrencia_index` (`id_recorrencia`),
  CONSTRAINT `contas_a_receber_id_bancos_foreign` FOREIGN KEY (`id_bancos`) REFERENCES `bancos` (`id_bancos`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_receber_id_categoria_contas_foreign` FOREIGN KEY (`id_categoria_contas`) REFERENCES `categoria_contas` (`id_categoria_contas`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_receber_id_clientes_foreign` FOREIGN KEY (`id_clientes`) REFERENCES `clientes` (`id_clientes`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_receber_id_forma_pagamento_foreign` FOREIGN KEY (`id_forma_pagamento`) REFERENCES `forma_pagamento` (`id_forma_pagamento`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_receber_id_fornecedores_foreign` FOREIGN KEY (`id_fornecedores`) REFERENCES `fornecedores` (`id_fornecedores`) ON DELETE SET NULL,
  CONSTRAINT `contas_a_receber_id_usuario_foreign` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contas_a_receber`
--

INSERT INTO `contas_a_receber` VALUES
(1,1,1,NULL,NULL,4,NULL,NULL,NULL,'Faturamento Locação #003','003',610.00,610.00,NULL,NULL,NULL,'2026-03-11','2026-04-12','2026-03-12','pago',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-11 21:40:37','2026-03-11 22:05:44',NULL),
(2,1,1,NULL,NULL,3,NULL,NULL,NULL,'Faturamento Locação #002','002',230.00,230.00,NULL,NULL,NULL,'2026-03-11','2026-03-12','2026-03-11','pago',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-11 21:50:15','2026-03-11 21:52:06',NULL),
(3,1,1,NULL,NULL,1,NULL,NULL,NULL,'Faturamento Locação #001','001',599.00,599.00,NULL,NULL,NULL,'2026-03-11','2026-03-11','2026-03-12','pago',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-11 22:47:06','2026-03-11 22:49:08',NULL),
(4,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'Alguel',NULL,100.00,0.00,0.00,0.00,0.00,NULL,'2026-03-16',NULL,'pendente',NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-12 15:05:25','2026-03-18 15:55:48','2026-03-18 15:55:48'),
(5,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUTO 113 - BETONEIRA VENDA',NULL,100.00,0.00,0.00,0.00,0.00,NULL,'2026-03-13',NULL,'pendente',NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-13 18:33:45','2026-03-18 15:55:48','2026-03-18 15:55:48'),
(6,1,2,NULL,NULL,9,NULL,NULL,NULL,'Faturamento Locação #007','007',850.00,850.00,NULL,NULL,NULL,'2026-03-13','2026-03-16','2026-03-16','pago',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-13 19:10:02','2026-03-13 19:15:03',NULL),
(7,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'Teste MP',NULL,5.00,5.00,0.00,0.00,0.00,NULL,'2026-03-20','2026-03-16','pago',NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-16 15:28:50','2026-03-16 18:28:59',NULL),
(8,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'Teste PH',NULL,5.00,5.00,0.00,0.00,0.00,NULL,'2026-03-30','2026-03-16','pago',NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-16 19:01:32','2026-03-16 19:13:49',NULL),
(9,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'Teste',NULL,25.00,0.00,0.00,0.00,0.00,NULL,'2026-04-10',NULL,'pendente',NULL,NULL,NULL,'2',NULL,'mensal','12',NULL,NULL,'2026-03-18 15:57:48','2026-03-18 15:58:06',NULL),
(10,5,12,NULL,NULL,16,NULL,NULL,NULL,'Faturamento Locação #010','010',15199.80,0.00,NULL,NULL,NULL,'2026-03-19','2026-03-20',NULL,'pendente',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-19 14:11:18','2026-03-19 14:11:18',NULL),
(11,1,2,NULL,NULL,17,NULL,NULL,NULL,'Faturamento Locação #011','011',20.00,0.00,NULL,NULL,NULL,'2026-03-24','2026-04-23',NULL,'pendente',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-24 20:57:35','2026-03-24 20:57:35',NULL);

--
-- Table structure for table `empresa`
--

CREATE TABLE `empresa` (
  `id_empresa` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `razao_social` varchar(255) DEFAULT NULL,
  `cnpj` varchar(255) DEFAULT NULL,
  `cpf` varchar(255) DEFAULT NULL,
  `id_tipo_pessoa` bigint(20) unsigned DEFAULT NULL,
  `nome_empresa` varchar(255) DEFAULT NULL,
  `endereco` varchar(255) DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `bairro` varchar(255) DEFAULT NULL,
  `cidade` varchar(255) DEFAULT NULL,
  `complemento` varchar(255) DEFAULT NULL,
  `uf` varchar(255) DEFAULT NULL,
  `cep` varchar(255) DEFAULT NULL,
  `ie` varchar(255) DEFAULT NULL,
  `im` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `id_plano` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `data_bloqueio` datetime DEFAULT NULL,
  `data_cancelamento` datetime DEFAULT NULL,
  `data_fim_teste` datetime DEFAULT NULL,
  `id_plano_teste` bigint(20) unsigned DEFAULT NULL,
  `telefone` varchar(255) DEFAULT NULL,
  `cnae` varchar(255) DEFAULT NULL,
  `id_regime_tributario` bigint(20) unsigned DEFAULT NULL,
  `configuracoes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`configuracoes`)),
  `dados_cadastrais` varchar(255) DEFAULT NULL,
  `codigo` varchar(255) DEFAULT NULL,
  `filial` varchar(255) DEFAULT NULL,
  `c_produtos` varchar(255) DEFAULT NULL,
  `c_clientes` varchar(255) DEFAULT NULL,
  `c_fornecedores` varchar(255) DEFAULT NULL,
  `id_empresa_matriz` bigint(20) unsigned DEFAULT NULL,
  `orcamentos_contratos` int(11) DEFAULT NULL,
  `locacao_numero_manual` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_empresa`),
  KEY `empresa_id_tipo_pessoa_index` (`id_tipo_pessoa`),
  KEY `empresa_id_plano_index` (`id_plano`),
  KEY `empresa_id_plano_teste_index` (`id_plano_teste`),
  KEY `empresa_id_regime_tributario_index` (`id_regime_tributario`),
  KEY `empresa_id_empresa_matriz_index` (`id_empresa_matriz`),
  CONSTRAINT `empresa_id_empresa_matriz_foreign` FOREIGN KEY (`id_empresa_matriz`) REFERENCES `empresa` (`id_empresa`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `empresa`
--

INSERT INTO `empresa` VALUES
(1,'GestorNow Tecnologia Inova Simples (I.S)','64904128000162','47559087019',NULL,'GestorNow Tecnologia Inova Simples (I.S)','RUA OUVIDOR PELEJA','611','VILA MARIANA','São Paulo',NULL,'SP','04128001',NULL,NULL,'gestornow0@gmail.com',NULL,'ativo',NULL,NULL,NULL,2,'19986116778',NULL,NULL,'{\"logo_url\":\"https:\\/\\/nowgestor.gestornow.com\\/assets\\/logos-empresa\\/logo_empresa_1_1774570866.jpeg\",\"logo_updated_at\":\"2026-03-26 21:21:06\"}','completo','1','Unica','S','S','S',NULL,0,0,'2026-03-11 10:53:12','2026-03-26 21:21:06',NULL),
(4,'BNS ENGENHARIA E CONSTRUÇÕES LTDA','30456657000129','05744291580',NULL,'BNS ENGENHARIA E CONSTRUÇÕES LTDA','salvador','61','paralela','Salvador','CASA','BA','41730101',NULL,NULL,'loc@bnsengenharia.com',NULL,'ativo',NULL,NULL,NULL,2,'71993478420',NULL,NULL,NULL,'completo','2','Unica','S','S','S',NULL,NULL,NULL,'2026-03-13 19:37:14','2026-03-18 19:50:36',NULL),
(5,'AMC LOCACOES DE MAQUINAS LTDA','30.315.999/0001-29',NULL,NULL,'AMC LOCACOES DE MAQUINAS','AVENIDA ULYSSES GUIMARAES','2531','SUSSUARANA','SALVADOR',NULL,'BA','41213000',NULL,NULL,'contato@amclocacao.com.br',NULL,'teste bloqueado','2026-03-22 00:01:02',NULL,'2026-03-21 23:59:00',2,'7193722299',NULL,NULL,'{\"motivo_bloqueio\":\"Per\\u00edodo de teste expirado\",\"bloqueado_automaticamente\":true,\"data_bloqueio_automatico\":\"2026-03-22 00:01:02\"}','completo','3','Unica','S','S','S',NULL,NULL,NULL,'2026-03-17 12:42:00','2026-03-22 00:01:02',NULL),
(7,'vishmariaseila','10100400000132',NULL,NULL,'vishmariaseila',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'mineiromc2023@gmail.com',NULL,'teste bloqueado','2026-03-24 00:01:01',NULL,'2026-03-23 14:32:17',5,NULL,NULL,NULL,'{\"motivo_bloqueio\":\"Per\\u00edodo de teste expirado\",\"bloqueado_automaticamente\":true,\"data_bloqueio_automatico\":\"2026-03-24 00:01:01\"}','completo','4','Unica','S','S','S',NULL,NULL,NULL,'2026-03-18 14:30:01','2026-03-24 00:01:01',NULL),
(10,'Renato teste1','74043767000134',NULL,NULL,'Renato teste1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'santanarenatop1706@gmail.com',NULL,'teste bloqueado','2026-03-31 00:01:01',NULL,'2026-03-30 22:34:27',3,NULL,NULL,NULL,'{\"motivo_bloqueio\":\"Per\\u00edodo de teste expirado\",\"bloqueado_automaticamente\":true,\"data_bloqueio_automatico\":\"2026-03-31 00:01:01\"}','completo','5','Unica','S','S','S',NULL,NULL,NULL,'2026-03-25 22:33:26','2026-03-31 00:01:01',NULL),
(11,'Gustavo Teste','69089560000160',NULL,NULL,'Gustavo Teste',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'guu.henrique06@outlook.com',NULL,'validacao',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pendente','6','Unica','S','S','S',NULL,NULL,NULL,'2026-03-26 22:19:11','2026-03-26 22:19:11',NULL),
(12,'Teste','25738187000156',NULL,NULL,'Teste',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'guu.henrique05@outlook.com',NULL,'validacao',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pendente','7','Unica','S','S','S',NULL,NULL,NULL,'2026-03-26 22:37:14','2026-03-26 22:37:14',NULL),
(13,'Teste Gestor','50785513000123',NULL,NULL,'Teste Gestor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'renatogestornow@gmail.com',NULL,'ativo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'incompleto','9','Unica',NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-29 23:39:38','2026-04-01 01:19:47',NULL),
(14,'BRUNO VARGAS SPINA MARCHINI LTDA','26.426.803/0001­04',NULL,NULL,'HUB VIDEO LOCADORA','AVENIDA DOUTOR HEITOR PENTEADO','1677','PARQUE TAQUARAL',NULL,NULL,NULL,'1677',NULL,NULL,NULL,NULL,'teste bloqueado','2026-04-05 00:01:02',NULL,NULL,5,'19988197288',NULL,NULL,'{\"motivo_bloqueio\":\"Per\\u00edodo de teste expirado\",\"bloqueado_automaticamente\":true,\"data_bloqueio_automatico\":\"2026-04-05 00:01:02\"}',NULL,'8','Unica','S','S','S',NULL,NULL,NULL,'2026-03-30 12:59:31','2026-04-05 00:01:02',NULL),
(15,'Gestor Now','64904128000162',NULL,NULL,'Plano Gestor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ativo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'completo',NULL,'Unica',NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-30 22:50:29','2026-03-30 22:50:29',NULL);

--
-- Table structure for table `empresa_contratos_software`
--

CREATE TABLE `empresa_contratos_software` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `versao_contrato` varchar(255) DEFAULT NULL,
  `titulo_contrato` varchar(255) DEFAULT NULL,
  `corpo_contrato` longtext DEFAULT NULL,
  `hash_documento` varchar(255) DEFAULT NULL,
  `assinatura_base64` longtext DEFAULT NULL,
  `assinado_por_nome` varchar(255) DEFAULT NULL,
  `assinado_por_documento` varchar(255) DEFAULT NULL,
  `assinatura_ip` varchar(255) DEFAULT NULL,
  `assinado_em` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `empresa_contratos_software_id_empresa_index` (`id_empresa`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `empresa_contratos_software`
--


--
-- Table structure for table `estados`
--

CREATE TABLE `estados` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `CodigoUf` int(11) NOT NULL,
  `Nome` varchar(50) NOT NULL,
  `Uf` char(2) NOT NULL,
  `Regiao` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `estados`
--

INSERT INTO `estados` VALUES
(1,12,'Acre','AC',1),
(2,27,'Alagoas','AL',2),
(3,16,'Amapá','AP',1),
(4,13,'Amazonas','AM',1),
(5,29,'Bahia','BA',2),
(6,23,'Ceará','CE',2),
(7,53,'Distrito Federal','DF',5),
(8,32,'Espírito Santo','ES',3),
(9,52,'Goiás','GO',5),
(10,21,'Maranhão','MA',2),
(11,51,'Mato Grosso','MT',5),
(12,50,'Mato Grosso do Sul','MS',5),
(13,31,'Minas Gerais','MG',3),
(14,15,'Pará','PA',1),
(15,25,'Paraíba','PB',2),
(16,41,'Paraná','PR',4),
(17,26,'Pernambuco','PE',2),
(18,22,'Piauí','PI',2),
(19,33,'Rio de Janeiro','RJ',3),
(20,24,'Rio Grande do Norte','RN',2),
(21,43,'Rio Grande do Sul','RS',4),
(22,11,'Rondônia','RO',1),
(23,14,'Roraima','RR',1),
(24,42,'Santa Catarina','SC',4),
(25,35,'São Paulo','SP',3),
(26,28,'Sergipe','SE',2),
(27,17,'Tocantins','TO',1);

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `faturamento_locacoes`
--

CREATE TABLE `faturamento_locacoes` (
  `id_faturamento_locacao` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_locacao` bigint(20) unsigned DEFAULT NULL,
  `id_usuario` bigint(20) unsigned DEFAULT NULL,
  `numero_fatura` varchar(255) DEFAULT NULL,
  `id_cliente` bigint(20) unsigned DEFAULT NULL,
  `id_conta_receber` bigint(20) unsigned DEFAULT NULL,
  `id_grupo_faturamento` bigint(20) unsigned DEFAULT NULL,
  `descricao` text DEFAULT NULL,
  `valor_total` decimal(15,2) DEFAULT NULL,
  `data_faturamento` date DEFAULT NULL,
  `data_vencimento` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `origem` varchar(255) DEFAULT NULL,
  `observacoes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_faturamento_locacao`),
  KEY `faturamento_locacoes_id_empresa_index` (`id_empresa`),
  KEY `faturamento_locacoes_id_locacao_index` (`id_locacao`),
  KEY `faturamento_locacoes_id_usuario_index` (`id_usuario`),
  KEY `faturamento_locacoes_id_cliente_index` (`id_cliente`),
  KEY `faturamento_locacoes_id_conta_receber_index` (`id_conta_receber`),
  KEY `faturamento_locacoes_id_grupo_faturamento_index` (`id_grupo_faturamento`),
  CONSTRAINT `faturamento_locacoes_id_cliente_foreign` FOREIGN KEY (`id_cliente`) REFERENCES `clientes` (`id_clientes`) ON DELETE SET NULL,
  CONSTRAINT `faturamento_locacoes_id_conta_receber_foreign` FOREIGN KEY (`id_conta_receber`) REFERENCES `contas_a_receber` (`id_contas`) ON DELETE SET NULL,
  CONSTRAINT `faturamento_locacoes_id_usuario_foreign` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faturamento_locacoes`
--

INSERT INTO `faturamento_locacoes` VALUES
(1,1,4,5,'1',1,1,NULL,'Faturamento Locação #003',610.00,'2026-03-11','2026-04-12','faturado','encerramento_locacao',NULL,'2026-03-11 21:40:37','2026-03-11 21:40:37',NULL),
(2,1,3,5,'2',1,2,NULL,'Faturamento Locação #002',230.00,'2026-03-11','2026-03-12','faturado','encerramento_locacao',NULL,'2026-03-11 21:50:15','2026-03-11 21:50:15',NULL),
(3,1,1,5,'3',1,3,NULL,'Faturamento Locação #001',599.00,'2026-03-11','2026-03-11','faturado','encerramento_locacao',NULL,'2026-03-11 22:47:06','2026-03-11 22:47:06',NULL),
(5,1,9,5,'4',2,6,NULL,'Faturamento Locação #007',850.00,'2026-03-13','2026-03-16','faturado','encerramento_locacao',NULL,'2026-03-13 19:10:02','2026-03-13 19:10:02',NULL),
(6,5,16,8,'1',12,10,NULL,'Faturamento Locação #010',15199.80,'2026-03-19','2026-03-20','faturado','encerramento_locacao',NULL,'2026-03-19 14:11:18','2026-03-19 14:11:18',NULL),
(7,1,17,1,'5',2,11,NULL,'Faturamento Locação #011',20.00,'2026-03-24','2026-04-23','faturado','encerramento_locacao',NULL,'2026-03-24 20:57:35','2026-03-24 20:57:35',NULL);

--
-- Table structure for table `fluxo_caixa`
--

CREATE TABLE `fluxo_caixa` (
  `id_fluxo` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `tipo` varchar(255) DEFAULT NULL,
  `descricao` text DEFAULT NULL,
  `valor` decimal(15,2) DEFAULT NULL,
  `data_movimentacao` date DEFAULT NULL,
  `id_conta_pagar` bigint(20) unsigned DEFAULT NULL,
  `id_conta_receber` bigint(20) unsigned DEFAULT NULL,
  `id_bancos` bigint(20) unsigned DEFAULT NULL,
  `id_categoria_fluxo` bigint(20) unsigned DEFAULT NULL,
  `id_forma_pagamento` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `referencia_tipo` varchar(50) DEFAULT NULL,
  `referencia_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_fluxo`),
  KEY `fluxo_caixa_id_empresa_index` (`id_empresa`),
  KEY `fluxo_caixa_id_conta_pagar_index` (`id_conta_pagar`),
  KEY `fluxo_caixa_id_conta_receber_index` (`id_conta_receber`),
  KEY `fluxo_caixa_id_bancos_index` (`id_bancos`),
  KEY `fluxo_caixa_id_categoria_fluxo_index` (`id_categoria_fluxo`),
  KEY `fluxo_caixa_id_forma_pagamento_index` (`id_forma_pagamento`),
  CONSTRAINT `fluxo_caixa_id_bancos_foreign` FOREIGN KEY (`id_bancos`) REFERENCES `bancos` (`id_bancos`) ON DELETE SET NULL,
  CONSTRAINT `fluxo_caixa_id_categoria_fluxo_foreign` FOREIGN KEY (`id_categoria_fluxo`) REFERENCES `categoria_contas` (`id_categoria_contas`) ON DELETE SET NULL,
  CONSTRAINT `fluxo_caixa_id_conta_pagar_foreign` FOREIGN KEY (`id_conta_pagar`) REFERENCES `contas_a_pagar` (`id_contas`) ON DELETE SET NULL,
  CONSTRAINT `fluxo_caixa_id_conta_receber_foreign` FOREIGN KEY (`id_conta_receber`) REFERENCES `contas_a_receber` (`id_contas`) ON DELETE SET NULL,
  CONSTRAINT `fluxo_caixa_id_forma_pagamento_foreign` FOREIGN KEY (`id_forma_pagamento`) REFERENCES `forma_pagamento` (`id_forma_pagamento`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fluxo_caixa`
--

INSERT INTO `fluxo_caixa` VALUES
(1,1,'entrada','Recebimento: Faturamento Locação #002',230.00,'2026-03-11',NULL,2,NULL,NULL,NULL,'2026-03-11 21:52:06','2026-03-11 21:52:06',NULL,NULL),
(3,1,'entrada','Recebimento: Faturamento Locação #003',610.00,'2026-03-12',NULL,1,1,NULL,2,'2026-03-11 22:05:44','2026-03-11 22:05:44',NULL,NULL),
(4,1,'entrada','Recebimento: Faturamento Locação #001',599.00,'2026-03-12',NULL,3,1,NULL,2,'2026-03-11 22:49:08','2026-03-11 22:49:08',NULL,NULL),
(6,1,'saida','Pagamento: teste (Parcela 1/2)',50.00,'2026-03-12',13,NULL,NULL,NULL,NULL,'2026-03-12 19:56:47','2026-03-12 19:56:47',NULL,NULL),
(7,1,'saida','Pagamento: teste (Parcela 1/2)',50.00,'2026-03-12',15,NULL,NULL,NULL,NULL,'2026-03-12 20:04:56','2026-03-12 20:04:56',NULL,NULL),
(9,1,'saida','Pagamento: tstes (Parcela 2/2)',50.00,'2026-03-13',18,NULL,NULL,NULL,NULL,'2026-03-12 21:58:27','2026-03-12 21:58:27',NULL,NULL),
(11,1,'entrada','Recebimento: Faturamento Locação #007',850.00,'2026-03-16',NULL,6,1,NULL,2,'2026-03-13 19:15:02','2026-03-13 19:15:02',NULL,NULL),
(12,1,'entrada','Venda PDV #1 - Debito',47.50,'2026-03-13',NULL,NULL,NULL,NULL,2,'2026-03-13 19:23:25','2026-03-13 19:23:25','venda',1),
(13,1,'entrada','Venda PDV #2 - Debito',25.00,'2026-03-24',NULL,NULL,NULL,NULL,2,'2026-03-24 20:43:46','2026-03-24 20:43:46','venda',2);

--
-- Table structure for table `forma_pagamento`
--

CREATE TABLE `forma_pagamento` (
  `id_forma_pagamento` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `nome` varchar(255) DEFAULT NULL,
  `descricao` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_forma_pagamento`),
  KEY `forma_pagamento_id_empresa_index` (`id_empresa`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `forma_pagamento`
--

INSERT INTO `forma_pagamento` VALUES
(1,1,'Dinheiro',NULL,'2026-03-11 22:04:46','2026-03-11 22:04:46',NULL),
(2,1,'Debito',NULL,'2026-03-11 22:04:58','2026-03-11 22:04:58',NULL),
(3,1,'Pix',NULL,'2026-03-11 22:05:05','2026-03-11 22:05:05',NULL);

--
-- Table structure for table `fornecedores`
--

CREATE TABLE `fornecedores` (
  `id_fornecedores` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `nome` varchar(255) DEFAULT NULL,
  `cep` varchar(255) DEFAULT NULL,
  `endereco` varchar(255) DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `complemento` varchar(255) DEFAULT NULL,
  `rg_ie` varchar(255) DEFAULT NULL,
  `cpf_cnpj` varchar(255) DEFAULT NULL,
  `razao_social` varchar(255) DEFAULT NULL,
  `nome_empresa` varchar(255) DEFAULT NULL,
  `data_abertura` date DEFAULT NULL,
  `bairro` varchar(255) DEFAULT NULL,
  `uf` varchar(255) DEFAULT NULL,
  `data_nascimento` date DEFAULT NULL,
  `contato_nome` varchar(255) DEFAULT NULL,
  `contato_cargo` varchar(255) DEFAULT NULL,
  `telefone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `prazo_medio_entrega_dias` varchar(255) DEFAULT NULL,
  `id_categoria_fornecedor` bigint(20) unsigned DEFAULT NULL,
  `banco_agencia` varchar(255) DEFAULT NULL,
  `banco_conta` varchar(255) DEFAULT NULL,
  `observacoes` text DEFAULT NULL,
  `id_tipo_pessoa` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_fornecedores`),
  KEY `fornecedores_id_empresa_index` (`id_empresa`),
  KEY `fornecedores_id_categoria_fornecedor_index` (`id_categoria_fornecedor`),
  KEY `fornecedores_id_tipo_pessoa_index` (`id_tipo_pessoa`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fornecedores`
--

INSERT INTO `fornecedores` VALUES
(1,1,'36.724.690 GUSTAVO HENRIQUE DA SILVA','13481432','RUA SERGIO ROBERTO BUCCI','746',NULL,NULL,'36724690000179',NULL,NULL,NULL,'JARDIM RESIDENCIAL DONA SANTINA PAROLI PECCININI','SP',NULL,NULL,NULL,'1982919967','gustavohenrique-silva@outlook.com.br',NULL,NULL,NULL,NULL,NULL,2,'ativo','2026-03-18 15:41:30','2026-03-18 15:41:30',NULL),
(2,5,'AFM TRANSPORTES E REBOQUES LTDA','40015070','RUA CONSELHEIRO DANTAS','22','EDIF BRADESCO SALA 908',NULL,'48337118000136','AFM TRANSPORTES',NULL,NULL,'COMERCIO','BA',NULL,NULL,NULL,'7184232134','sidineia@carvalhoelima.com.br',NULL,NULL,NULL,NULL,NULL,2,'ativo','2026-03-19 13:21:58','2026-03-19 13:21:58',NULL);

--
-- Table structure for table `grupos_permissoes`
--

CREATE TABLE `grupos_permissoes` (
  `id_grupo` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned NOT NULL,
  `nome` varchar(100) NOT NULL,
  `descricao` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_grupo`),
  UNIQUE KEY `grupos_permissoes_id_empresa_nome_unique` (`id_empresa`,`nome`),
  KEY `grupos_permissoes_id_empresa_index` (`id_empresa`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupos_permissoes`
--

INSERT INTO `grupos_permissoes` VALUES
(1,1,'Permissões teste','teste','2026-03-16 21:41:11','2026-03-18 00:37:35'),
(2,5,'Admin',NULL,'2026-03-17 12:43:49','2026-03-18 15:43:10'),
(3,7,'Admin',NULL,'2026-03-18 14:36:30','2026-03-18 15:43:30'),
(4,4,'Admin',NULL,'2026-03-18 23:41:20','2026-03-18 23:41:20'),
(36,1,'Permissões do Eduuuu',NULL,'2026-03-30 22:33:12','2026-03-30 22:33:12'),
(37,1,'Permissões do Gorila',NULL,'2026-03-30 22:34:07','2026-03-30 22:34:07');

--
-- Table structure for table `grupos_permissoes_itens`
--

CREATE TABLE `grupos_permissoes_itens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_grupo` bigint(20) unsigned NOT NULL,
  `chave` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `grupos_permissoes_itens_id_grupo_chave_unique` (`id_grupo`,`chave`),
  KEY `grupos_permissoes_itens_id_grupo_index` (`id_grupo`)
) ENGINE=InnoDB AUTO_INCREMENT=1121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupos_permissoes_itens`
--

INSERT INTO `grupos_permissoes_itens` VALUES
(506,1,'admin.logs.visualizar'),
(508,1,'admin.visualizar'),
(509,1,'clientes.criar'),
(510,1,'clientes.excluir'),
(511,1,'clientes.visualizar'),
(512,1,'expedicao.logistica.checklist'),
(514,1,'expedicao.logistica.checklist.confirmar'),
(513,1,'expedicao.logistica.checklist.foto'),
(515,1,'expedicao.logistica.imprimir-checklist'),
(516,1,'expedicao.logistica.mover-card'),
(517,1,'expedicao.logistica.visualizar'),
(518,1,'expedicao.pedidos.alterar-status'),
(519,1,'expedicao.pedidos.criar'),
(520,1,'expedicao.pedidos.editar'),
(521,1,'expedicao.pedidos.excluir'),
(522,1,'expedicao.pedidos.visualizar'),
(523,1,'expedicao.troca.executar'),
(524,1,'expedicao.troca.visualizar'),
(525,1,'expedicao.visualizar'),
(527,1,'financeiro.bancos'),
(528,1,'financeiro.boletos'),
(529,1,'financeiro.categorias'),
(526,1,'financeiro.contas-pagar.baixa'),
(531,1,'financeiro.contas-pagar.visualizar'),
(532,1,'financeiro.contas-receber.visualizar'),
(530,1,'financeiro.formas-pagamento'),
(533,1,'financeiro.visualizar'),
(534,1,'locacoes.criar'),
(535,1,'locacoes.visualizar'),
(536,1,'pdv.acessar'),
(537,1,'pdv.cancelar-venda'),
(539,1,'pdv.relatorio'),
(538,1,'produtos-venda.gerenciar'),
(540,1,'produtos.criar'),
(541,1,'produtos.editar'),
(542,1,'produtos.manutencao'),
(543,1,'produtos.tabela-precos'),
(544,1,'produtos.visualizar'),
(545,1,'usuarios.criar'),
(546,1,'usuarios.editar'),
(547,1,'usuarios.excluir'),
(507,1,'usuarios.permissoes'),
(548,1,'usuarios.visualizar'),
(770,2,'admin.logs.visualizar'),
(772,2,'admin.visualizar'),
(709,2,'clientes.criar'),
(710,2,'clientes.editar'),
(711,2,'clientes.excluir'),
(712,2,'clientes.visualizar'),
(773,2,'configuracoes.documentos.gerenciar'),
(774,2,'configuracoes.documentos.visualizar'),
(775,2,'configuracoes.empresa.editar'),
(776,2,'configuracoes.empresa.visualizar'),
(777,2,'configuracoes.permissoes.criar'),
(778,2,'configuracoes.permissoes.editar'),
(779,2,'configuracoes.permissoes.excluir'),
(780,2,'configuracoes.permissoes.visualizar'),
(734,2,'expedicao.logistica.checklist'),
(736,2,'expedicao.logistica.checklist.confirmar'),
(735,2,'expedicao.logistica.checklist.foto'),
(737,2,'expedicao.logistica.imprimir-checklist'),
(738,2,'expedicao.logistica.mover-card'),
(739,2,'expedicao.logistica.visualizar'),
(740,2,'expedicao.pedidos.alterar-status'),
(741,2,'expedicao.pedidos.criar'),
(742,2,'expedicao.pedidos.editar'),
(743,2,'expedicao.pedidos.excluir'),
(744,2,'expedicao.pedidos.visualizar'),
(745,2,'expedicao.troca.executar'),
(746,2,'expedicao.troca.visualizar'),
(747,2,'expedicao.visualizar'),
(754,2,'financeiro.bancos'),
(755,2,'financeiro.boletos'),
(756,2,'financeiro.categorias'),
(752,2,'financeiro.contas-pagar.baixa'),
(757,2,'financeiro.contas-pagar.criar'),
(759,2,'financeiro.contas-pagar.editar'),
(761,2,'financeiro.contas-pagar.excluir'),
(767,2,'financeiro.contas-pagar.visualizar'),
(753,2,'financeiro.contas-receber.baixa'),
(758,2,'financeiro.contas-receber.criar'),
(760,2,'financeiro.contas-receber.editar'),
(762,2,'financeiro.contas-receber.excluir'),
(768,2,'financeiro.contas-receber.visualizar'),
(763,2,'financeiro.faturamento'),
(764,2,'financeiro.fluxo-caixa'),
(765,2,'financeiro.formas-pagamento'),
(766,2,'financeiro.relatorios'),
(769,2,'financeiro.visualizar'),
(781,2,'fornecedores.criar'),
(782,2,'fornecedores.editar'),
(783,2,'fornecedores.excluir'),
(784,2,'fornecedores.visualizar'),
(722,2,'locacoes.alterar-status'),
(723,2,'locacoes.assinatura-digital'),
(728,2,'locacoes.contrato-pdf'),
(724,2,'locacoes.criar'),
(725,2,'locacoes.editar'),
(726,2,'locacoes.excluir'),
(727,2,'locacoes.expedicao'),
(729,2,'locacoes.medicao'),
(731,2,'locacoes.renovar'),
(730,2,'locacoes.retornar'),
(732,2,'locacoes.trocar-produto'),
(733,2,'locacoes.visualizar'),
(748,2,'pdv.acessar'),
(749,2,'pdv.cancelar-venda'),
(751,2,'pdv.relatorio'),
(750,2,'produtos-venda.gerenciar'),
(713,2,'produtos.acessorios'),
(714,2,'produtos.criar'),
(715,2,'produtos.editar'),
(716,2,'produtos.excluir'),
(717,2,'produtos.manutencao'),
(718,2,'produtos.movimentacao'),
(719,2,'produtos.patrimonio'),
(720,2,'produtos.tabela-precos'),
(721,2,'produtos.visualizar'),
(785,2,'relatorios.clientes'),
(788,2,'relatorios.financeiro'),
(786,2,'relatorios.locacoes'),
(787,2,'relatorios.produtos'),
(789,2,'usuarios.criar'),
(790,2,'usuarios.editar'),
(791,2,'usuarios.excluir'),
(771,2,'usuarios.permissoes'),
(792,2,'usuarios.visualizar'),
(854,3,'admin.logs.visualizar'),
(856,3,'admin.visualizar'),
(793,3,'clientes.criar'),
(794,3,'clientes.editar'),
(795,3,'clientes.excluir'),
(796,3,'clientes.visualizar'),
(857,3,'configuracoes.documentos.gerenciar'),
(858,3,'configuracoes.documentos.visualizar'),
(859,3,'configuracoes.empresa.editar'),
(860,3,'configuracoes.empresa.visualizar'),
(861,3,'configuracoes.permissoes.criar'),
(862,3,'configuracoes.permissoes.editar'),
(863,3,'configuracoes.permissoes.excluir'),
(864,3,'configuracoes.permissoes.visualizar'),
(818,3,'expedicao.logistica.checklist'),
(820,3,'expedicao.logistica.checklist.confirmar'),
(819,3,'expedicao.logistica.checklist.foto'),
(821,3,'expedicao.logistica.imprimir-checklist'),
(822,3,'expedicao.logistica.mover-card'),
(823,3,'expedicao.logistica.visualizar'),
(824,3,'expedicao.pedidos.alterar-status'),
(825,3,'expedicao.pedidos.criar'),
(826,3,'expedicao.pedidos.editar'),
(827,3,'expedicao.pedidos.excluir'),
(828,3,'expedicao.pedidos.visualizar'),
(829,3,'expedicao.troca.executar'),
(830,3,'expedicao.troca.visualizar'),
(831,3,'expedicao.visualizar'),
(838,3,'financeiro.bancos'),
(839,3,'financeiro.boletos'),
(840,3,'financeiro.categorias'),
(836,3,'financeiro.contas-pagar.baixa'),
(841,3,'financeiro.contas-pagar.criar'),
(843,3,'financeiro.contas-pagar.editar'),
(845,3,'financeiro.contas-pagar.excluir'),
(851,3,'financeiro.contas-pagar.visualizar'),
(837,3,'financeiro.contas-receber.baixa'),
(842,3,'financeiro.contas-receber.criar'),
(844,3,'financeiro.contas-receber.editar'),
(846,3,'financeiro.contas-receber.excluir'),
(852,3,'financeiro.contas-receber.visualizar'),
(847,3,'financeiro.faturamento'),
(848,3,'financeiro.fluxo-caixa'),
(849,3,'financeiro.formas-pagamento'),
(850,3,'financeiro.relatorios'),
(853,3,'financeiro.visualizar'),
(865,3,'fornecedores.criar'),
(866,3,'fornecedores.editar'),
(867,3,'fornecedores.excluir'),
(868,3,'fornecedores.visualizar'),
(806,3,'locacoes.alterar-status'),
(807,3,'locacoes.assinatura-digital'),
(812,3,'locacoes.contrato-pdf'),
(808,3,'locacoes.criar'),
(809,3,'locacoes.editar'),
(810,3,'locacoes.excluir'),
(811,3,'locacoes.expedicao'),
(813,3,'locacoes.medicao'),
(815,3,'locacoes.renovar'),
(814,3,'locacoes.retornar'),
(816,3,'locacoes.trocar-produto'),
(817,3,'locacoes.visualizar'),
(832,3,'pdv.acessar'),
(833,3,'pdv.cancelar-venda'),
(835,3,'pdv.relatorio'),
(834,3,'produtos-venda.gerenciar'),
(797,3,'produtos.acessorios'),
(798,3,'produtos.criar'),
(799,3,'produtos.editar'),
(800,3,'produtos.excluir'),
(801,3,'produtos.manutencao'),
(802,3,'produtos.movimentacao'),
(803,3,'produtos.patrimonio'),
(804,3,'produtos.tabela-precos'),
(805,3,'produtos.visualizar'),
(869,3,'relatorios.clientes'),
(872,3,'relatorios.financeiro'),
(870,3,'relatorios.locacoes'),
(871,3,'relatorios.produtos'),
(873,3,'usuarios.criar'),
(874,3,'usuarios.editar'),
(875,3,'usuarios.excluir'),
(855,3,'usuarios.permissoes'),
(876,3,'usuarios.visualizar'),
(938,4,'admin.logs.visualizar'),
(940,4,'admin.visualizar'),
(877,4,'clientes.criar'),
(878,4,'clientes.editar'),
(879,4,'clientes.excluir'),
(880,4,'clientes.visualizar'),
(941,4,'configuracoes.documentos.gerenciar'),
(942,4,'configuracoes.documentos.visualizar'),
(943,4,'configuracoes.empresa.editar'),
(944,4,'configuracoes.empresa.visualizar'),
(945,4,'configuracoes.permissoes.criar'),
(946,4,'configuracoes.permissoes.editar'),
(947,4,'configuracoes.permissoes.excluir'),
(948,4,'configuracoes.permissoes.visualizar'),
(902,4,'expedicao.logistica.checklist'),
(904,4,'expedicao.logistica.checklist.confirmar'),
(903,4,'expedicao.logistica.checklist.foto'),
(905,4,'expedicao.logistica.imprimir-checklist'),
(906,4,'expedicao.logistica.mover-card'),
(907,4,'expedicao.logistica.visualizar'),
(908,4,'expedicao.pedidos.alterar-status'),
(909,4,'expedicao.pedidos.criar'),
(910,4,'expedicao.pedidos.editar'),
(911,4,'expedicao.pedidos.excluir'),
(912,4,'expedicao.pedidos.visualizar'),
(913,4,'expedicao.troca.executar'),
(914,4,'expedicao.troca.visualizar'),
(915,4,'expedicao.visualizar'),
(922,4,'financeiro.bancos'),
(923,4,'financeiro.boletos'),
(924,4,'financeiro.categorias'),
(920,4,'financeiro.contas-pagar.baixa'),
(925,4,'financeiro.contas-pagar.criar'),
(927,4,'financeiro.contas-pagar.editar'),
(929,4,'financeiro.contas-pagar.excluir'),
(935,4,'financeiro.contas-pagar.visualizar'),
(921,4,'financeiro.contas-receber.baixa'),
(926,4,'financeiro.contas-receber.criar'),
(928,4,'financeiro.contas-receber.editar'),
(930,4,'financeiro.contas-receber.excluir'),
(936,4,'financeiro.contas-receber.visualizar'),
(931,4,'financeiro.faturamento'),
(932,4,'financeiro.fluxo-caixa'),
(933,4,'financeiro.formas-pagamento'),
(934,4,'financeiro.relatorios'),
(937,4,'financeiro.visualizar'),
(949,4,'fornecedores.criar'),
(950,4,'fornecedores.editar'),
(951,4,'fornecedores.excluir'),
(952,4,'fornecedores.visualizar'),
(890,4,'locacoes.alterar-status'),
(891,4,'locacoes.assinatura-digital'),
(896,4,'locacoes.contrato-pdf'),
(892,4,'locacoes.criar'),
(893,4,'locacoes.editar'),
(894,4,'locacoes.excluir'),
(895,4,'locacoes.expedicao'),
(897,4,'locacoes.medicao'),
(899,4,'locacoes.renovar'),
(898,4,'locacoes.retornar'),
(900,4,'locacoes.trocar-produto'),
(901,4,'locacoes.visualizar'),
(916,4,'pdv.acessar'),
(917,4,'pdv.cancelar-venda'),
(919,4,'pdv.relatorio'),
(918,4,'produtos-venda.gerenciar'),
(881,4,'produtos.acessorios'),
(882,4,'produtos.criar'),
(883,4,'produtos.editar'),
(884,4,'produtos.excluir'),
(885,4,'produtos.manutencao'),
(886,4,'produtos.movimentacao'),
(887,4,'produtos.patrimonio'),
(888,4,'produtos.tabela-precos'),
(889,4,'produtos.visualizar'),
(953,4,'relatorios.clientes'),
(956,4,'relatorios.financeiro'),
(954,4,'relatorios.locacoes'),
(955,4,'relatorios.produtos'),
(957,4,'usuarios.criar'),
(958,4,'usuarios.editar'),
(959,4,'usuarios.excluir'),
(939,4,'usuarios.permissoes'),
(960,4,'usuarios.visualizar'),
(1018,36,'admin.logs.visualizar'),
(1020,36,'admin.visualizar'),
(1021,36,'configuracoes.documentos.gerenciar'),
(1022,36,'configuracoes.documentos.visualizar'),
(1023,36,'configuracoes.empresa.editar'),
(1024,36,'configuracoes.empresa.visualizar'),
(1025,36,'configuracoes.permissoes.criar'),
(1026,36,'configuracoes.permissoes.editar'),
(1027,36,'configuracoes.permissoes.excluir'),
(1028,36,'configuracoes.permissoes.visualizar'),
(982,36,'expedicao.logistica.checklist'),
(984,36,'expedicao.logistica.checklist.confirmar'),
(983,36,'expedicao.logistica.checklist.foto'),
(985,36,'expedicao.logistica.imprimir-checklist'),
(986,36,'expedicao.logistica.mover-card'),
(987,36,'expedicao.logistica.visualizar'),
(988,36,'expedicao.pedidos.alterar-status'),
(989,36,'expedicao.pedidos.criar'),
(990,36,'expedicao.pedidos.editar'),
(991,36,'expedicao.pedidos.excluir'),
(992,36,'expedicao.pedidos.visualizar'),
(993,36,'expedicao.troca.executar'),
(994,36,'expedicao.troca.visualizar'),
(995,36,'expedicao.visualizar'),
(1002,36,'financeiro.bancos'),
(1003,36,'financeiro.boletos'),
(1004,36,'financeiro.categorias'),
(1000,36,'financeiro.contas-pagar.baixa'),
(1005,36,'financeiro.contas-pagar.criar'),
(1007,36,'financeiro.contas-pagar.editar'),
(1009,36,'financeiro.contas-pagar.excluir'),
(1015,36,'financeiro.contas-pagar.visualizar'),
(1001,36,'financeiro.contas-receber.baixa'),
(1006,36,'financeiro.contas-receber.criar'),
(1008,36,'financeiro.contas-receber.editar'),
(1010,36,'financeiro.contas-receber.excluir'),
(1016,36,'financeiro.contas-receber.visualizar'),
(1011,36,'financeiro.faturamento'),
(1012,36,'financeiro.fluxo-caixa'),
(1013,36,'financeiro.formas-pagamento'),
(1014,36,'financeiro.relatorios'),
(1017,36,'financeiro.visualizar'),
(1029,36,'fornecedores.criar'),
(1030,36,'fornecedores.editar'),
(1031,36,'fornecedores.excluir'),
(1032,36,'fornecedores.visualizar'),
(970,36,'locacoes.alterar-status'),
(971,36,'locacoes.assinatura-digital'),
(976,36,'locacoes.contrato-pdf'),
(972,36,'locacoes.criar'),
(973,36,'locacoes.editar'),
(974,36,'locacoes.excluir'),
(975,36,'locacoes.expedicao'),
(977,36,'locacoes.medicao'),
(979,36,'locacoes.renovar'),
(978,36,'locacoes.retornar'),
(980,36,'locacoes.trocar-produto'),
(981,36,'locacoes.visualizar'),
(996,36,'pdv.acessar'),
(997,36,'pdv.cancelar-venda'),
(999,36,'pdv.relatorio'),
(998,36,'produtos-venda.gerenciar'),
(961,36,'produtos.acessorios'),
(962,36,'produtos.criar'),
(963,36,'produtos.editar'),
(964,36,'produtos.excluir'),
(965,36,'produtos.manutencao'),
(966,36,'produtos.movimentacao'),
(967,36,'produtos.patrimonio'),
(968,36,'produtos.tabela-precos'),
(969,36,'produtos.visualizar'),
(1033,36,'relatorios.clientes'),
(1036,36,'relatorios.financeiro'),
(1034,36,'relatorios.locacoes'),
(1035,36,'relatorios.produtos'),
(1037,36,'usuarios.criar'),
(1038,36,'usuarios.editar'),
(1039,36,'usuarios.excluir'),
(1019,36,'usuarios.permissoes'),
(1040,36,'usuarios.visualizar'),
(1102,37,'admin.logs.visualizar'),
(1104,37,'admin.visualizar'),
(1041,37,'clientes.criar'),
(1042,37,'clientes.editar'),
(1043,37,'clientes.excluir'),
(1044,37,'clientes.visualizar'),
(1105,37,'configuracoes.documentos.gerenciar'),
(1106,37,'configuracoes.documentos.visualizar'),
(1107,37,'configuracoes.empresa.editar'),
(1108,37,'configuracoes.empresa.visualizar'),
(1109,37,'configuracoes.permissoes.criar'),
(1110,37,'configuracoes.permissoes.editar'),
(1111,37,'configuracoes.permissoes.excluir'),
(1112,37,'configuracoes.permissoes.visualizar'),
(1066,37,'expedicao.logistica.checklist'),
(1068,37,'expedicao.logistica.checklist.confirmar'),
(1067,37,'expedicao.logistica.checklist.foto'),
(1069,37,'expedicao.logistica.imprimir-checklist'),
(1070,37,'expedicao.logistica.mover-card'),
(1071,37,'expedicao.logistica.visualizar'),
(1072,37,'expedicao.pedidos.alterar-status'),
(1073,37,'expedicao.pedidos.criar'),
(1074,37,'expedicao.pedidos.editar'),
(1075,37,'expedicao.pedidos.excluir'),
(1076,37,'expedicao.pedidos.visualizar'),
(1077,37,'expedicao.troca.executar'),
(1078,37,'expedicao.troca.visualizar'),
(1079,37,'expedicao.visualizar'),
(1086,37,'financeiro.bancos'),
(1087,37,'financeiro.boletos'),
(1088,37,'financeiro.categorias'),
(1084,37,'financeiro.contas-pagar.baixa'),
(1089,37,'financeiro.contas-pagar.criar'),
(1091,37,'financeiro.contas-pagar.editar'),
(1093,37,'financeiro.contas-pagar.excluir'),
(1099,37,'financeiro.contas-pagar.visualizar'),
(1085,37,'financeiro.contas-receber.baixa'),
(1090,37,'financeiro.contas-receber.criar'),
(1092,37,'financeiro.contas-receber.editar'),
(1094,37,'financeiro.contas-receber.excluir'),
(1100,37,'financeiro.contas-receber.visualizar'),
(1095,37,'financeiro.faturamento'),
(1096,37,'financeiro.fluxo-caixa'),
(1097,37,'financeiro.formas-pagamento'),
(1098,37,'financeiro.relatorios'),
(1101,37,'financeiro.visualizar'),
(1113,37,'fornecedores.criar'),
(1114,37,'fornecedores.editar'),
(1115,37,'fornecedores.excluir'),
(1116,37,'fornecedores.visualizar'),
(1054,37,'locacoes.alterar-status'),
(1055,37,'locacoes.assinatura-digital'),
(1060,37,'locacoes.contrato-pdf'),
(1056,37,'locacoes.criar'),
(1057,37,'locacoes.editar'),
(1058,37,'locacoes.excluir'),
(1059,37,'locacoes.expedicao'),
(1061,37,'locacoes.medicao'),
(1063,37,'locacoes.renovar'),
(1062,37,'locacoes.retornar'),
(1064,37,'locacoes.trocar-produto'),
(1065,37,'locacoes.visualizar'),
(1080,37,'pdv.acessar'),
(1081,37,'pdv.cancelar-venda'),
(1083,37,'pdv.relatorio'),
(1082,37,'produtos-venda.gerenciar'),
(1045,37,'produtos.acessorios'),
(1046,37,'produtos.criar'),
(1047,37,'produtos.editar'),
(1048,37,'produtos.excluir'),
(1049,37,'produtos.manutencao'),
(1050,37,'produtos.movimentacao'),
(1051,37,'produtos.patrimonio'),
(1052,37,'produtos.tabela-precos'),
(1053,37,'produtos.visualizar'),
(1117,37,'relatorios.clientes'),
(1120,37,'relatorios.financeiro'),
(1118,37,'relatorios.locacoes'),
(1119,37,'relatorios.produtos'),
(1103,37,'usuarios.permissoes');

--
-- Table structure for table `locacao`
--

CREATE TABLE `locacao` (
  `id_locacao` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_cliente` bigint(20) unsigned DEFAULT NULL,
  `id_usuario` bigint(20) unsigned DEFAULT NULL,
  `numero_contrato` varchar(255) DEFAULT NULL,
  `data_inicio` date DEFAULT NULL,
  `hora_inicio` varchar(255) DEFAULT NULL,
  `data_fim` date DEFAULT NULL,
  `hora_fim` varchar(255) DEFAULT NULL,
  `locacao_por_hora` tinyint(1) NOT NULL DEFAULT 0,
  `quantidade_dias` int(11) DEFAULT NULL,
  `data_transporte_ida` datetime DEFAULT NULL,
  `hora_transporte_ida` varchar(255) DEFAULT NULL,
  `data_transporte_volta` datetime DEFAULT NULL,
  `hora_transporte_volta` varchar(255) DEFAULT NULL,
  `local_entrega` varchar(255) DEFAULT NULL,
  `local_retirada` varchar(255) DEFAULT NULL,
  `contato_responsavel` varchar(255) DEFAULT NULL,
  `telefone_responsavel` varchar(255) DEFAULT NULL,
  `nome_obra` varchar(255) DEFAULT NULL,
  `contato_local` varchar(255) DEFAULT NULL,
  `telefone_contato` varchar(255) DEFAULT NULL,
  `local_evento` varchar(255) DEFAULT NULL,
  `endereco_entrega` varchar(255) DEFAULT NULL,
  `cidade` varchar(255) DEFAULT NULL,
  `estado` varchar(255) DEFAULT NULL,
  `cep` varchar(255) DEFAULT NULL,
  `numero_nf` varchar(255) DEFAULT NULL,
  `serie_nf` varchar(255) DEFAULT NULL,
  `vencimento` date DEFAULT NULL,
  `valor_total` decimal(15,2) DEFAULT NULL,
  `valor_frete` decimal(15,2) DEFAULT NULL,
  `valor_despesas_extras` decimal(15,2) DEFAULT NULL,
  `valor_desconto` decimal(15,2) DEFAULT NULL,
  `valor_acrescimo` decimal(15,2) DEFAULT NULL,
  `valor_imposto` decimal(15,2) DEFAULT NULL,
  `valor_final` decimal(15,2) DEFAULT NULL,
  `valor_limite_medicao` decimal(15,2) DEFAULT NULL,
  `forma_pagamento` varchar(255) DEFAULT NULL,
  `condicao_pagamento` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `status_logistica` varchar(255) DEFAULT NULL,
  `responsavel` varchar(255) DEFAULT NULL,
  `observacoes` text DEFAULT NULL,
  `observacoes_recibo` text DEFAULT NULL,
  `observacoes_entrega` text DEFAULT NULL,
  `observacoes_checklist` text DEFAULT NULL,
  `aditivo` int(11) DEFAULT NULL,
  `renovacao_automatica` tinyint(1) NOT NULL DEFAULT 0,
  `id_locacao_origem` bigint(20) unsigned DEFAULT NULL,
  `id_locacao_anterior` bigint(20) unsigned DEFAULT NULL,
  `numero_orcamento` int(11) DEFAULT NULL,
  `numero_orcamento_origem` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `valor_frete_entrega` decimal(15,2) NOT NULL DEFAULT 0.00,
  `valor_frete_retirada` decimal(15,2) NOT NULL DEFAULT 0.00,
  `observacoes_orcamento` text DEFAULT NULL,
  PRIMARY KEY (`id_locacao`),
  KEY `locacao_id_empresa_index` (`id_empresa`),
  KEY `locacao_id_cliente_index` (`id_cliente`),
  KEY `locacao_id_usuario_index` (`id_usuario`),
  KEY `locacao_id_locacao_origem_index` (`id_locacao_origem`),
  KEY `locacao_id_locacao_anterior_index` (`id_locacao_anterior`),
  CONSTRAINT `locacao_id_cliente_foreign` FOREIGN KEY (`id_cliente`) REFERENCES `clientes` (`id_clientes`) ON DELETE SET NULL,
  CONSTRAINT `locacao_id_empresa_foreign` FOREIGN KEY (`id_empresa`) REFERENCES `empresa` (`id_empresa`) ON DELETE SET NULL,
  CONSTRAINT `locacao_id_locacao_anterior_foreign` FOREIGN KEY (`id_locacao_anterior`) REFERENCES `locacao` (`id_locacao`) ON DELETE SET NULL,
  CONSTRAINT `locacao_id_locacao_origem_foreign` FOREIGN KEY (`id_locacao_origem`) REFERENCES `locacao` (`id_locacao`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locacao`
--

INSERT INTO `locacao` VALUES
(1,1,1,4,'001','2026-03-11','08:00','2026-03-15','18:00',0,5,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,599.00,0.00,0.00,0.00,0.00,0.00,599.00,0.00,NULL,NULL,'aprovado',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,1,'2026-03-11 15:32:39','2026-03-11 15:32:39',NULL,0.00,0.00,NULL),
(2,1,1,5,'O001','2026-03-11','08:00','2026-03-12','18:00',0,2,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.00,0.00,0.00,30.00,80.00,0.00,150.00,0.00,NULL,NULL,'orcamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,1,'2026-03-11 21:01:45','2026-03-11 21:01:45',NULL,0.00,0.00,NULL),
(3,1,1,5,'002','2026-03-11','08:00','2026-03-12','18:00',0,2,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,200.00,0.00,0.00,20.00,50.00,0.00,230.00,0.00,NULL,NULL,'aprovado',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,2,2,'2026-03-11 21:12:30','2026-03-11 21:13:10',NULL,0.00,0.00,NULL),
(4,1,1,5,'003','2026-03-11','08:00','2026-03-13','18:00',0,3,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,600.00,0.00,0.00,10.00,20.00,0.00,610.00,0.00,NULL,NULL,'aprovado',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,2,2,'2026-03-11 21:26:26','2026-03-11 21:27:03',NULL,0.00,0.00,NULL),
(6,1,1,1,'004','2026-03-12','08:00','2026-03-15','18:00',0,4,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,400.00,0.00,0.00,0.00,0.00,0.00,400.00,0.00,NULL,NULL,'aprovado','para_separar',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,2,2,'2026-03-12 15:28:57','2026-03-12 15:44:13',NULL,0.00,0.00,NULL),
(7,1,1,1,'005','2026-03-12','08:00','2026-03-12','08:00',0,1,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL,'medicao','para_separar',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,2,2,'2026-03-12 16:06:04','2026-03-16 18:34:19',NULL,0.00,0.00,NULL),
(8,1,2,5,'006','2026-03-13','08:00','2026-03-16','18:00',0,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,950.00,0.00,0.00,0.00,100.00,0.00,1050.00,0.00,NULL,NULL,'aprovado','em_rota',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,2,2,'2026-03-13 18:36:08','2026-03-17 23:52:57',NULL,0.00,0.00,NULL),
(9,1,2,5,'007','2026-03-13','08:00','2026-03-16','18:00',0,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,750.00,0.00,0.00,0.00,100.00,0.00,850.00,0.00,NULL,NULL,'aprovado','para_separar',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,2,2,'2026-03-13 19:04:37','2026-03-16 18:34:17',NULL,0.00,0.00,NULL),
(10,1,1,1,'O002','2026-03-16','08:00','2026-03-20','18:00',0,5,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.00,0.00,0.00,15.00,135.00,0.00,220.00,0.00,NULL,NULL,'orcamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,2,2,'2026-03-16 18:35:41','2026-03-17 17:08:32',NULL,50.00,85.00,'Teste do orçamento'),
(11,1,1,1,'008','2026-03-17','08:00','2026-03-20','18:00',0,4,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,359.90,0.00,0.00,0.00,0.00,0.00,359.90,0.00,NULL,NULL,'aprovado',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,3,3,'2026-03-17 17:02:42','2026-03-17 17:07:15',NULL,0.00,0.00,NULL),
(12,5,4,8,'O001','2026-03-18','08:00','2026-04-17','18:00',0,31,NULL,NULL,NULL,NULL,'R CORONEL ALMERINDO REHEM, 000082, SALA 901 9 ANDAR EDIF BAH EXE CENTER, CAMINHO DAS ARVORES, CEP 41820768',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14000.00,0.00,0.00,0.00,2400.00,0.00,16400.00,0.00,NULL,NULL,'orcamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,1,'2026-03-18 08:16:49','2026-03-18 08:19:45',NULL,1200.00,1200.00,'- CONDIÇÕES DE PAGAMENTO: 50% A VISTA + 50% (5 DIAS APÓS A MEDIÇÃO)\r\n\r\n- COMBUSTÍVEL E OPERADOR POR CONTA DO CONTRATANTE'),
(13,1,1,1,'O003','2026-03-18','08:00','2026-03-24','18:00',0,7,NULL,NULL,NULL,NULL,'AVENIDA SUBURBANA, 7471, SALA 201 PARTE, ABOLICAO, CEP 20751000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,419.30,0.00,0.00,0.00,0.00,0.00,419.30,0.00,NULL,NULL,'orcamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,3,3,'2026-03-18 12:32:09','2026-03-18 12:32:09',NULL,0.00,0.00,NULL),
(14,7,10,12,'009','2026-03-18','08:00','2026-03-18','18:00',0,1,NULL,NULL,NULL,NULL,'Rua Osvaldo Galiza, 367, CEP 13482-791',NULL,'Marina','19999999999',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,160.00,0.00,0.00,0.00,0.00,0.00,160.00,0.00,NULL,NULL,'aprovado','pronto_patio',NULL,'TESTE LOCAL CONTRATO','TESTE LOCAL RECIBO','TESTE LOCAL ENTREGA','TESTE LOCAL CHECKLIST',NULL,0,NULL,NULL,1,1,'2026-03-18 14:50:05','2026-03-18 14:58:08',NULL,0.00,0.00,'TESTE LOCAL ORÇAMENTO'),
(15,5,12,8,'O002','2026-03-19','08:00','2026-04-17','18:00',0,30,NULL,NULL,NULL,NULL,'RUA MIGUEL CALMON, 290, ED. BELO HORIZONTE SALA 703, COMERCIO, CEP 40015010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15999.90,0.00,0.00,0.00,7200.00,0.00,23199.90,0.00,NULL,NULL,'orcamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,2,2,'2026-03-19 13:57:33','2026-03-19 14:01:07',NULL,3600.00,3600.00,'Obs para orçametno'),
(16,5,12,8,'010','2026-03-19','08:00','2026-04-17','18:00',0,30,NULL,NULL,NULL,NULL,'RUA MIGUEL CALMON, 290, ED. BELO HORIZONTE SALA 703, COMERCIO, CEP 40015010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13999.80,0.00,0.00,0.00,1200.00,0.00,15199.80,0.00,NULL,NULL,'aprovado','entregue',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,3,3,'2026-03-19 14:04:38','2026-03-19 14:09:11',NULL,600.00,600.00,'teste'),
(17,1,2,1,'011','2026-03-24','08:00','2026-03-25','18:00',0,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20.00,0.00,0.00,0.00,0.00,0.00,20.00,0.00,NULL,NULL,'aprovado',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,4,4,'2026-03-24 20:55:36','2026-03-24 20:55:36',NULL,0.00,0.00,NULL),
(18,1,2,5,'012','2026-03-26','20:00','2026-03-30','20:00',0,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1799.00,0.00,0.00,50.00,200.00,0.00,1949.00,0.00,NULL,NULL,'aprovado',NULL,NULL,'Olhar atentamente','Emitir recibo','Ajudante Carlos vai auxiliar na entrega e retirada','Verificar e tirar as devidas fotos',NULL,0,NULL,NULL,4,4,'2026-03-26 20:11:09','2026-03-26 20:13:51',NULL,100.00,100.00,'Locação direta');

--
-- Table structure for table `locacao_assinaturas_digitais`
--

CREATE TABLE `locacao_assinaturas_digitais` (
  `id_assinatura` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_empresa` bigint(20) unsigned DEFAULT NULL,
  `id_locacao` bigint(20) unsigned DEFAULT NULL,
  `id_cliente` bigint(20) unsigned DEFAULT NULL,
  `id_modelo` bigint(20) unsigned DEFAULT NULL,
  `email_destinatario` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `assinatura_tipo` varchar(255) DEFAULT NULL,
  `assinatura_cliente_url` varchar(255) DEFAULT NULL,
  `assinado_em` datetime DEFAULT NULL,
  `solicitado_em` datetime DEFAULT NULL,
  `ip_assinatura` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `hash_documento` varchar(255) DEFAULT NULL,
  `corpo_contrato_assinado` longtext DEFAULT NULL,
  `assinado_por_nome` varchar(255) DEFAULT NULL,
  `assinado_por_documento` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_assinatura`),
  KEY `locacao_assinaturas_digitais_id_empresa_index` (`id_empresa`),
  KEY `locacao_assinaturas_digitais_id_locacao_index` (`id_locacao`),
  KEY `locacao_assinaturas_digitais_id_cliente_index` (`id_cliente`),
  KEY `locacao_assinaturas_digitais_id_modelo_index` (`id_modelo`),
  CONSTRAINT `locacao_assinaturas_digitais_id_cliente_foreign` FOREIGN KEY (`id_cliente`) REFERENCES `clientes` (`id_clientes`) ON DELETE SET NULL,
  CONSTRAINT `locacao_assinaturas_digitais_id_empresa_foreign` FOREIGN KEY (`id_empresa`) REFERENCES `empresa` (`id_empresa`) ON DELETE SET NULL,
  CONSTRAINT `locacao_assinaturas_digitais_id_locacao_foreign` FOREIGN KEY (`id_locacao`) REFERENCES `locacao` (`id_locacao`) ON DELETE SET NULL,
  CONSTRAINT `locacao_assinaturas_digitais_id_modelo_foreign` FOREIGN KEY (`id_modelo`) REFERENCES `locacao_modelos_contrato` (`id_modelo`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locacao_assinaturas_digitais`
--

INSERT INTO `locacao_assinaturas_digitais` VALUES
(1,1,6,1,NULL,'contato@amclocacao.com.br','cevnjbhgaagl8daunqxnrhbczdxcru5cowg5vou9i20veuu89d1k86y6tyblbhsbnyhuhqke','assinado','digitada','https://gestornow.com/uploads/assinaturas/1/assinatura-cliente-locacao-6-20260312153955.png','2026-03-12 15:39:56','2026-03-12 15:36:39','2804:1b3:6243:c6eb:602f:f611:35fc:be89','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36',NULL,NULL,NULL,NULL,'2026-03-12 15:36:39','2026-03-12 15:39:56'),
(2,1,4,1,NULL,'gestornow0@gmail.com','90u3jfcfamos28dqkv5k298rfm2hssr2dhsdafmx4hgwszmvynfmph0dxikton8suyiwisek','pendente',NULL,NULL,NULL,'2026-03-12 19:47:59',NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-12 19:47:32','2026-03-12 19:47:59'),
(3,1,1,1,1,'gestornow0@gmail.com','wj3nuod8onln8odu5und8p21gjcy7if2zvw8sljpjvmmukbcypyze7dedzexppnzjyzohagj','assinado','desenho','https://gestornow.com/uploads/assinaturas/1/assinatura-cliente-locacao-1-20260313153635.png','2026-03-13 15:36:35','2026-03-13 15:35:53','2804:868:d054:7615:ad0b:104d:ca5e:4f27','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','8b99357d0ffaaa3d2902baa708eb564f2089791474afd66fd8931fc819810de9','<!DOCTYPE html>\n<html lang=\"pt-BR\">\n<head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <title>Contrato de Loca&ccedil;&atilde;o #001</title>\n    <style>\n        * {\n            margin: 0;\n            padding: 0;\n            box-sizing: border-box;\n        }\n        body {\n            font-family: \'DejaVu Sans\', Arial, sans-serif;\n            font-size: 12px;\n            line-height: 1.5;\n            color: #333;\n            padding: 20px;\n        }\n        .page {\n            max-width: 800px;\n            margin: 0 auto;\n        }\n        h1 { font-size: 18px; margin-bottom: 10px; }\n        h2 { font-size: 16px; margin-bottom: 8px; }\n        h3 { font-size: 14px; margin-bottom: 6px; margin-top: 15px; }\n        table {\n            width: 100%;\n            border-collapse: collapse;\n            margin: 10px 0;\n        }\n        th, td {\n            border: 1px solid #ddd;\n            padding: 8px;\n            text-align: left;\n        }\n        th {\n            background-color: #f5f5f5;\n        }\n        .text-right { text-align: right; }\n        .text-center { text-align: center; }\n        .mt-20 { margin-top: 20px; }\n        .mb-20 { margin-bottom: 20px; }\n        .assinaturas {\n            display: flex;\n            justify-content: space-between;\n            margin-top: 50px;\n        }\n        .assinatura {\n            width: 45%;\n            text-align: center;\n        }\n        .assinatura-linha {\n            border-top: 1px solid #000;\n            padding-top: 5px;\n            margin-top: 40px;\n        }\n        @media print {\n            body { padding: 0; }\n            .no-print { display: none; }\n        }\n        \n            body { font-family: DejaVu Sans, Arial, sans-serif; color: #1f2937; font-size: 10px; background: #ffffff; margin: 0; }\n            .contrato-wrapper { overflow: hidden; margin: -20px -20px 0 -20px; }\n            .faixa-topo { background: #008ee6; height: 20px; }\n            .cabecalho-principal { padding: 10px 24px 2px 24px; }\n            .cabecalho-table { width: 100%; border-collapse: collapse; }\n            .cabecalho-table td { vertical-align: middle; }\n            .documento-titulo { font-size: 20px; letter-spacing: .4px; color: #2f4858; font-weight: 700; text-transform: uppercase; line-height: 1; }\n            .titulo-dots { font-size: 9px; color: #6b7280; margin-left: 7px; vertical-align: middle; }\n            .documento-subtitulo { font-size: 11px; color: #2f4858; margin-top: 3px; }\n            .numero-area { text-align: center; vertical-align: middle; white-space: nowrap; }\n            .numero-contrato { display: inline-block; font-size: 12px; color: #2f4858; font-weight: 700; }\n            .logo-area { text-align: right; font-size: 16px; color: #2f4858; text-transform: uppercase; vertical-align: middle; }\n            .logo-img { display: inline-block; max-height: 52px; max-width: 130px; width: auto; height: auto; }\n            .partes-table { width: 100%; border-collapse: separate; border-spacing: 8px 0; margin-top: 10px; }\n            .bloco-parte { border: 1px solid #008ee6; border-radius: 3px; padding: 6px; min-height: 82px; background: #fff; }\n            .bloco { border: 1px solid #008ee6; border-radius: 3px; padding: 7px; margin-top: 10px; background: #fff; }\n            .bloco-produtos { border: 1px solid #cbd5e1; border-radius: 3px; padding: 7px; background: #fff; }\n            .bloco-titulo { font-size: 11px; font-weight: 700; color: #2f4858; margin-bottom: 5px; }\n            .item-linha { line-height: 1.25; margin-bottom: 1px; font-size: 9px; }\n            .largura-partes { width: 96%; margin-left: auto; margin-right: auto; box-sizing: border-box; }\n            .largura-partes.bloco { margin-top: 10px; }\n            .clausulas-wrap { margin-top: 10px; }\n            .bloco-clausulas { border: 1px solid #cbd5e1; border-radius: 3px; padding: 7px; background: #fff; overflow: hidden; }\n            .tabela-produtos-wrap { border: none; padding: 0; margin-top: 0; }\n            .tabela-produtos { width: 100%; border-collapse: collapse; margin-top: 4px; table-layout: fixed; }\n            .tabela-produtos th, .tabela-produtos td { border: 1px solid #008ee6; padding: 4px; font-size: 9px; }\n            .tabela-produtos th { background: #f1f5f9; color: #2f4858; font-weight: 700; }\n            .tabela-produtos .linha-zebra { background: #f8fafc; }\n            .tabela-produtos td { word-wrap: break-word; overflow-wrap: anywhere; }\n            .total-produtos { margin-top: 6px; font-size: 9px; color: #334155; text-align: right; }\n            .resumo-financeiro { margin-top: 8px; border: 1px solid #cbd5e1; border-radius: 3px; overflow: hidden; }\n            .resumo-financeiro .linha-resumo { display: table; width: 100%; border-bottom: 1px solid #e2e8f0; font-size: 9px; }\n            .resumo-financeiro .linha-resumo:last-child { border-bottom: none; }\n            .resumo-financeiro .linha-resumo span { display: table-cell; padding: 5px 6px; }\n            .resumo-financeiro .linha-resumo span:last-child { text-align: right; font-weight: 600; }\n            .resumo-financeiro .linha-resumo.total { background: #eff6ff; color: #2f4858; font-weight: 700; }\n            .clausulas-texto { margin-top: 4px; font-size: 9px; line-height: 1.4; text-align: justify; word-break: break-word; overflow-wrap: anywhere; max-width: 100%; }\n            .clausulas-texto * { word-break: break-word; overflow-wrap: anywhere; max-width: 100%; }\n            .clausulas-texto ul, .clausulas-texto ol { padding-left: 0; margin-left: 0; list-style-position: inside; }\n            .clausulas-texto img { max-width: 100%; height: auto; }\n            .clausulas-texto table { width: 100%; table-layout: fixed; }\n            .data-local { margin-top: 16px; font-size: 9px; color: #334155; text-align: right; }\n            .assinaturas { margin-top: 20px; }\n            .assinaturas-table { width: 100%; border-collapse: collapse; }\n            .assinatura-cell { width: 50%; text-align: center; padding-top: 26px; vertical-align: bottom; }\n            .assinatura-imagem { margin-bottom: 6px; }\n            .assinatura-img { max-height: 70px; max-width: 220px; }\n            .assinatura-placeholder { height: 70px; }\n            .assinatura-linha { border-top: 1px solid #111; padding-top: 4px; font-size: 9px; color: #334155; margin: 0 16px; }\n            .clausula-box { margin-top: 8px; border: 1px solid #bfd3f2; border-radius: 4px; overflow: hidden; }\n            .clausula-head { background: #eaf1fb; color: #0f3f7d; font-size: 9.5px; font-weight: 700; padding: 6px 8px; text-transform: uppercase; }\n            .clausula-body { background: #fff; padding: 8px; font-size: 9px; line-height: 1.4; color: #1f2937; }\n        \n    </style>\n</head>\n<body>\n    <div class=\"page\">\n        <div class=\"cabecalho\">\n            \n        </div>\n        \n        <div class=\"conteudo\">\n            \n            \n            <div class=\"contrato-wrapper\">\n                <div class=\"faixa-topo\"></div>\n                <div class=\"cabecalho-principal\">\n                    <table class=\"cabecalho-table\">\n                        <tr>\n                            <td style=\"width:68%;\">\n                                <div class=\"documento-titulo\">Contrato <span class=\"titulo-dots\">&#9679; &#9679; &#9679;</span></div>\n                                <div class=\"documento-subtitulo\">Loca&ccedil;&atilde;o de Bens M&oacute;veis</div>\n                            </td>\n                            <td style=\"width:14%;\" class=\"numero-area\">\n                                <span class=\"numero-contrato\">N&ordm; 001</span>\n                            </td>\n                            <td style=\"width:18%;\" class=\"logo-area\">\n                                <img src=\"/var/www/html/public/assets/logos-empresa/logo_empresa_1_1773250786.jpeg\" alt=\"Logo\" class=\"logo-img\">\n                            </td>\n                        </tr>\n                    </table>\n                </div>\n            </div>\n        \n\n            \n                <table class=\"partes-table\">\n                    <tr>\n                        <td style=\"width:50%;\">\n                            <div class=\"bloco-parte\">\n                                <div class=\"bloco-titulo\">Contratante</div>\n                                <div class=\"item-linha\">Nome: PRIME VIDEO LTDA</div>\n                                <div class=\"item-linha\">CPF/CNPJ: 68634245000104</div>\n                                <div class=\"item-linha\">Endere&ccedil;o: AVENIDA SUBURBANA, 7471, ABOLICAO, 20751000</div>\n                                <div class=\"item-linha\">E mail: gestornow0@gmail.com</div>\n                            </div>\n                        </td>\n                        <td style=\"width:50%;\">\n                            <div class=\"bloco-parte\">\n                                <div class=\"bloco-titulo\">Contratado</div>\n                                <div class=\"item-linha\">Nome: GestorNow Tecnologia Inova Simples (I.S)</div>\n                                <div class=\"item-linha\">CPF/CNPJ: 64904128000162</div>\n                                <div class=\"item-linha\">Endere&ccedil;o: RUA OUVIDOR PELEJA, 611, VILA MARIANA, S&atilde;o Paulo, SP, 04128001</div>\n                                <div class=\"item-linha\">E mail: gestornow0@gmail.com</div>\n                            </div>\n                        </td>\n                    </tr>\n                </table>\n            \n\n            <div class=\"bloco largura-partes bloco-produtos\">\n                <div class=\"bloco-titulo\">Tabela de Itens (Produtos e Servi&ccedil;os)</div>\n                <div class=\"tabela-produtos-wrap\"><table class=\"tabela-produtos\"><thead><tr><th>Produto</th><th>Qtd</th><th>Dias</th><th>Valor Unit.</th><th>Subtotal</th></tr></thead><tbody><tr><td>Betoneira 500L</td><td>1</td><td>5</td><td>R$ 59,90</td><td>R$ 299,50</td></tr><tr class=\"linha-zebra\"><td>Betoneira 500L</td><td>1</td><td>5</td><td>R$ 59,90</td><td>R$ 299,50</td></tr></tbody></table></div><div class=\"total-produtos\">Total de itens: 2</div>\n\n                <div class=\"resumo-financeiro\">\n                    <div class=\"linha-resumo\"><span>Subtotal Produtos</span><span>R$ 599,00</span></div>\n                    <div class=\"linha-resumo\"><span>Subtotal Servi&ccedil;os</span><span>R$ 0,00</span></div>\n                    <div class=\"linha-resumo\"><span>Frete</span><span>R$ 0,00</span></div>\n                    <div class=\"linha-resumo\"><span>Desconto</span><span>R$ 0,00</span></div>\n                    <div class=\"linha-resumo total\"><span>Valor Total do Contrato</span><span>R$ 599,00</span></div>\n                </div>\n            </div>\n\n            <div class=\"largura-partes clausulas-wrap bloco-clausulas\">\n                <div class=\"clausulas-texto\"><div class=\"clausula-box\"><div class=\"clausula-head\">PER&Iacute;ODO</div><div class=\"clausula-body\">11/03/2026 &agrave;s 08:00 horas at&eacute; 15/03/2026 &agrave;s 18:00 horas totalizando 5 dia(s), totalizando R$599,00, quinhentos e noventa e nove reais.</div></div><div class=\"clausula-box\"><div class=\"clausula-head\">FORMA E PRAZO DE PAGAMENTO</div><div class=\"clausula-body\">Forma de Pagamento: A combinar / Prazo de Pagamento: A definir</div></div><div class=\"clausula-box\"><div class=\"clausula-head\">CL&Aacute;USULA I - \"DO PRAZO CONTRATUAL\"</div><div class=\"clausula-body\">O prazo de vig&ecirc;ncia do presente contrato ser&aacute; de 5 dia(s) contando a partir da data de recebimento do equipamento, podendo as partes, entretanto rescindi-lo ou prorrog&aacute;-lo conforme sua necessidade.</div></div><div class=\"clausula-box\"><div class=\"clausula-head\">CL&Aacute;USULA II - \"DO PRAZO DE PAGAMENTO\"</div><div class=\"clausula-body\">a) O LOCAT&Aacute;RIO ter&aacute; o prazo de (A DEFINIR) dias para efetuar o pagamento da loca&ccedil;&atilde;o conforme acordado na data de entrega do equipamento efetuado pelo LOCADOR.<br>b) Caso n&atilde;o seja efetuado o pagamento em atraso at&eacute; 10 dias ap&oacute;s o vencimento, o LOCADOR poder&aacute; retirar o(s) equipamento(s) locado(s) sem aviso pr&eacute;vio.</div></div><div class=\"clausula-box\"><div class=\"clausula-head\">CL&Aacute;USULA III - \"DA RESPONSABILIDADE DO LOCAT&Aacute;RIO\"</div><div class=\"clausula-body\">a) O LOCAT&Aacute;RIO compromete-se a fazer o bom uso do(s) equipamento(s) locado(s) conforme especifica&ccedil;&otilde;es do fabricante e orienta&ccedil;&otilde;es fornecidas pelo LOCADOR, respondendo pelo uso e indevido ou impr&oacute;prio do mesmo, e se responsabilizar por eventuais custos, indeniza&ccedil;&otilde;es ou despesas decorrentes pelos danos causados pelo mal uso e acidentes causados a terceiros.<br>b) O LOCAT&Aacute;RIO compromete-se a indenizar o LOCADOR, o valor total do equipamento locado em caso de inc&ecirc;ndio, roubo, furto, acidentes com avarias, em caso de fortuito ou for&ccedil;a maior.<br>c) O LOCAT&Aacute;RIO responder&aacute; pelo crime de apropria&ccedil;&atilde;o ind&eacute;bita no caso de reten&ccedil;&atilde;o indevida do equipamento locado.<br>d) O LOCAT&Aacute;RIO &eacute; o respons&aacute;vel pelo abastecimento de combust&iacute;vel, reposi&ccedil;&atilde;o de acess&oacute;rios, convers&atilde;o de acess&oacute;rios, convers&atilde;o e lubrifica&ccedil;&atilde;o do equipamento, cuidados necess&aacute;rios para o bom desempenho do servi&ccedil;o.<br>e) Em caso de acidente com o equipamento, o presente contrato continuar&aacute; em vigor at&eacute; a devolu&ccedil;&atilde;o ou entrega do bem avariado em perfeitas condi&ccedil;&otilde;es de uso.<br>f) O LOCAT&Aacute;RIO dever&aacute; entrar em contato com o LOCADOR caso o equipamento apresente algum problema, quebra, entre outros defeitos, solicitando a troca imediata do mesmo.</div></div><div class=\"clausula-box\"><div class=\"clausula-head\">CL&Aacute;USULA IV - \"DA RESPONSABILIDADE DO LOCADOR\"</div><div class=\"clausula-body\">a) O LOCADOR compromete-se a entregar o equipamento em perfeitas condi&ccedil;&otilde;es de uso, bem como, fornecer todas as orienta&ccedil;&otilde;es necess&aacute;rias ao bom uso do equipamento locado.<br>b) &Eacute; responsabilidade do LOCADOR o transporte do equipamento at&eacute; o LOCAT&Aacute;RIO e a retirada do mesmo sem cobran&ccedil;a de frete adicional.<br>c) O LOCADOR compromete-se efetuar troca imediata do equipamento quando o mesmo, apresente algum problema, quebra, entre outros defeitos.<br>CL&Aacute;USULA V - \"DAS DISPOSI&Ccedil;&Otilde;ES GERAIS\"<br>O LOCAT&Aacute;RIO n&atilde;o poder&aacute; transferir este contrato, sublocar ou emprestar o equipamento.</div></div><p><br></p></div>\n            </div>\n\n            <div class=\"data-local largura-partes\">S&atilde;o Paulo, 13 de mar&ccedil;o de 2026</div><div class=\"assinaturas largura-partes\"><table class=\"assinaturas-table\"><tr><td class=\"assinatura-cell\"><div class=\"assinatura-imagem\"><img src=\"/var/www/html/public/uploads/assinaturas/1/assinatura_locadora_1_cJTDFehr.png\" alt=\"Assinatura Locadora\" class=\"assinatura-img\"></div><div class=\"assinatura-linha\">GestorNow Tecnologia Inova Simples (I.S)<br><small>CNPJ: 64904128000162</small></div></td><td class=\"assinatura-cell\"><div class=\"assinatura-imagem\"><img src=\"/var/www/html/public/uploads/assinaturas/1/assinatura-cliente-locacao-1-20260313153635.png\" alt=\"Assinatura Cliente\" class=\"assinatura-img\"></div><div class=\"assinatura-linha\">PRIME VIDEO LTDA<br><small>CNPJ: 68634245000104</small></div></td></tr></table></div>\n        \n        </div>\n        \n        <div class=\"rodape\">\n            \n        </div>\n    </div>\n</body>\n</html>\n','PRIME VIDEO LTDA','68634245000104','2026-03-13 15:35:53','2026-03-13 16:50:42');

--
