INSERT INTO `log` (`logID`, `ipAcesso`, `dataHora`, `usuarioID`, `acaoLogID`, `tabelaAcao`, `mensagem`, `sqlAcao`, `dadosAntigos`) VALUES
(7255, '177.131.124.223', '2023-10-09 12:01:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #452', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"452\",\"servicoempresaID\":\"54\",\"datacadastro\":\"0000-00-00\",\"preco\":\"975\",\"datavencimento\":\"2024-01-02\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_822b99defb57eee745e9b5ce067845571689882443.pdf\"}]'),
(7256, '177.131.124.223', '2023-10-09 12:01:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #453', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"453\",\"servicoempresaID\":\"54\",\"datacadastro\":\"0000-00-00\",\"preco\":\"975\",\"datavencimento\":\"2024-02-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_495ebf6919007733d96eb834816a3e831689882452.pdf\"}]'),
(7257, '177.131.124.223', '2023-10-09 12:01:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #454', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"454\",\"servicoempresaID\":\"54\",\"datacadastro\":\"0000-00-00\",\"preco\":\"975\",\"datavencimento\":\"2024-03-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_12fe43b5a7f045c5741e645e04e1c75d1689882464.pdf\"}]'),
(7258, '177.131.124.223', '2023-10-09 12:01:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #455', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"455\",\"servicoempresaID\":\"54\",\"datacadastro\":\"0000-00-00\",\"preco\":\"975\",\"datavencimento\":\"2024-04-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_7d91e7228ae2a025d44f6f8bcc5c52601689882475.pdf\"}]'),
(7259, '177.131.124.223', '2023-10-09 12:01:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #456', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"456\",\"servicoempresaID\":\"54\",\"datacadastro\":\"0000-00-00\",\"preco\":\"975\",\"datavencimento\":\"2024-05-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_0c0e690cce764096ee61e7987e11c28b1689882494.pdf\"}]'),
(7260, '177.131.124.223', '2023-10-09 12:01:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #457', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"457\",\"servicoempresaID\":\"54\",\"datacadastro\":\"0000-00-00\",\"preco\":\"975\",\"datavencimento\":\"2024-06-03\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_f89c41224d35b845d1f5eeb76272a34a1689882536.pdf\"}]'),
(7261, '177.131.124.223', '2023-10-09 12:03:49', 1, 4, 'servicoempresa', 'Usuário Aron Scapinello Selhorst editou em \"servicoempresa\" #38', '{\"ativo\":\"1\",\"descricao\":\"<p>R$ 89,90 mensais ou R$ 950,00 anual&nbsp;</p>\\\\n<p>Op&ccedil;&atilde;o escolhida: R$ 89,90 mensais (a partir de fev 2022)</p>\\\\n<p>&nbsp;</p>\\\\n<p>CPF: 024.391.389-32</p>\"}', '[{\"servicoempresaID\":\"38\",\"empresaID\":\"29\",\"servicoID\":\"11\",\"datacadastro\":\"2021-11-25 00:00:00\",\"ativo\":\"1\",\"preco\":\"89.9\",\"datavencimento\":\"0000-00-00\",\"diavencimento\":\"0\",\"descricao\":\"<p>R$ 89,90 mensais ou R$ 950,00 anual&nbsp;</p>\n<p>Op&ccedil;&atilde;o escolhida: R$ 89,90 mensais (a partir de fev 2022)</p>\n<p>&nbsp;</p>\n<p>CPF: 024.391.389-32</p>\"}]'),
(7262, '177.131.124.223', '2023-10-09 12:03:49', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #430', '{\"servicoempresaID\":\"38\",\"datacadastro\":\"2023-10-05\",\"formapagamentoID\":\"4\",\"preco\":\"89.90\"}', '[]'),
(7263, '177.131.124.223', '2023-10-09 12:06:49', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #431', '{\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-10-02\",\"formapagamentoID\":\"4\",\"preco\":\"975.00\"}', '[]'),
(7264, '177.131.124.223', '2023-10-09 12:06:49', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #374', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"374\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2023-11-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_4971b93c1e96d5182884028af31118301675103200.pdf\"}]'),
(7265, '177.131.124.223', '2023-10-09 12:06:49', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #375', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"375\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_793d9706121e53685d9ebe1e8e6a8a431675103204.pdf\"}]'),
(7266, '177.131.124.223', '2023-10-09 12:06:49', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #376', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"376\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2024-01-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_61539faa546897729af83b247ee5c98c1675103101.pdf\"}]'),
(7267, '177.131.124.223', '2023-10-09 12:10:28', 1, 4, 'servicoempresa', 'Usuário Aron Scapinello Selhorst editou em \"servicoempresa\" #77', '{\"ativo\":\"1\",\"descricao\":\"\"}', '[{\"servicoempresaID\":\"77\",\"empresaID\":\"54\",\"servicoID\":\"14\",\"datacadastro\":\"2022-11-16 00:00:00\",\"ativo\":\"1\",\"preco\":\"975\",\"datavencimento\":\"0000-00-00\",\"diavencimento\":\"0\",\"descricao\":\"\"}]'),
(7268, '177.131.124.223', '2023-10-09 12:10:28', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #432', '{\"servicoempresaID\":\"77\",\"datacadastro\":\"2023-10-02\",\"formapagamentoID\":\"4\",\"preco\":\"975.00\"}', '[]'),
(7269, '177.131.124.223', '2023-10-09 12:10:28', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #311', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"311\",\"servicoempresaID\":\"77\",\"datacadastro\":\"2023-11-01\",\"preco\":\"975\",\"datavencimento\":\"2023-11-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_4d629e7a76a6d388568c665900c82f4e1673491938.pdf\"}]'),
(7270, '177.131.124.223', '2023-10-09 12:10:28', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #312', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"312\",\"servicoempresaID\":\"77\",\"datacadastro\":\"2023-12-01\",\"preco\":\"975\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_3ffdf9d77dee8839ebd24ee5e0f7db971673491862.pdf\"}]'),
(7271, '177.131.124.223', '2023-10-09 12:13:38', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #433', '{\"servicoempresaID\":\"84\",\"datacadastro\":\"2023-10-02\",\"formapagamentoID\":\"4\",\"preco\":\"1200.00\"}', '[]'),
(7272, '177.131.124.223', '2023-10-09 12:13:38', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #490', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"490\",\"servicoempresaID\":\"84\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2023-11-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_957b2fc1395e321ece5a2a295a5589741690315657.pdf\"}]'),
(7273, '177.131.124.223', '2023-10-09 12:13:38', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #491', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"491\",\"servicoempresaID\":\"84\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_a218509a9f8f29c4b3abeb10f85c52b81690315667.pdf\"}]'),
(7274, '177.131.124.223', '2023-10-09 12:13:38', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #492', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"492\",\"servicoempresaID\":\"84\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2024-01-02\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_1ea2961e4e3a6167037c17e781a340ef1690315676.pdf\"}]'),
(7275, '177.131.124.223', '2023-10-09 12:16:00', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #434', '{\"servicoempresaID\":\"85\",\"datacadastro\":\"2023-10-02\",\"formapagamentoID\":\"4\",\"preco\":\"1200.00\"}', '[]'),
(7276, '177.131.124.223', '2023-10-09 12:16:00', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #496', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"496\",\"servicoempresaID\":\"85\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2023-11-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_413a82ad514c528188b8e9fd84341c821690328827.pdf\"}]'),
(7277, '177.131.124.223', '2023-10-09 12:16:00', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #497', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"497\",\"servicoempresaID\":\"85\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_24a364f48cbe47ec6b5320ef8b3d8bb81690328843.pdf\"}]'),
(7278, '177.131.124.223', '2023-10-09 12:16:00', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #498', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"498\",\"servicoempresaID\":\"85\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2024-01-02\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_4c5543d763850a5cf9e80c5ea75b9b661690328883.pdf\"}]'),
(7279, '177.131.124.223', '2023-10-09 16:33:15', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7280, '177.131.124.223', '2023-10-10 11:30:01', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7281, '177.131.124.223', '2023-10-10 13:09:46', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7282, '177.131.124.223', '2023-10-10 14:38:22', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7283, '177.131.124.223', '2023-10-10 18:46:22', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7284, '170.84.57.128', '2023-10-12 14:33:50', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7285, '177.131.124.223', '2023-10-13 13:18:31', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7286, '177.131.124.223', '2023-10-13 19:55:15', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7287, '177.131.124.223', '2023-10-15 10:41:07', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7288, '177.131.124.154', '2023-10-17 14:25:40', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7289, '177.131.124.154', '2023-10-20 15:46:06', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7290, '177.131.124.154', '2023-10-20 23:58:18', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7291, '177.131.124.221', '2023-10-26 11:40:12', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7292, '177.131.124.221', '2023-10-26 11:43:31', 1, 4, 'servicoempresa', 'Usuário Aron Scapinello Selhorst editou em \"servicoempresa\" #92', '{\"ativo\":\"1\",\"descricao\":\"<p>RENEGOCIA&Ccedil;&Atilde;O DE D&Iacute;VIDA</p>\"}', '[{\"servicoempresaID\":\"92\",\"empresaID\":\"57\",\"servicoID\":\"17\",\"datacadastro\":\"2023-07-11 00:00:00\",\"ativo\":\"1\",\"preco\":\"7620\",\"datavencimento\":\"0000-00-00\",\"diavencimento\":\"0\",\"descricao\":\"<p>RENEGOCIA&Ccedil;&Atilde;O DE D&Iacute;VIDA</p>\"}]'),
(7293, '177.131.124.221', '2023-10-26 11:43:31', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #435', '{\"servicoempresaID\":\"92\",\"datacadastro\":\"2023-10-10\",\"formapagamentoID\":\"4\",\"preco\":\"1905.00\"}', '[]'),
(7294, '177.131.124.221', '2023-10-26 11:51:03', 1, 4, 'servicoempresa', 'Usuário Aron Scapinello Selhorst editou em \"servicoempresa\" #88', '{\"ativo\":\"1\",\"descricao\":\"<p>CINCO BPO</p>\"}', '[{\"servicoempresaID\":\"88\",\"empresaID\":\"63\",\"servicoID\":\"13\",\"datacadastro\":\"2023-03-10 00:00:00\",\"ativo\":\"1\",\"preco\":\"1200\",\"datavencimento\":\"0000-00-00\",\"diavencimento\":\"0\",\"descricao\":\"<p>CINCO BPO</p>\"}]'),
(7295, '177.131.124.221', '2023-10-26 11:51:03', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #436', '{\"servicoempresaID\":\"88\",\"datacadastro\":\"2023-10-02\",\"formapagamentoID\":\"4\",\"preco\":\"1500.00\"}', '[]'),
(7296, '177.131.124.221', '2023-10-26 11:51:03', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #410', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"410\",\"servicoempresaID\":\"88\",\"datacadastro\":\"2023-03-15\",\"preco\":\"1200\",\"datavencimento\":\"2023-11-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_097507dc4e7d42d6d33b53cd5c217ed81678913704.pdf\"}]'),
(7297, '177.131.124.221', '2023-10-26 11:51:03', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #411', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"411\",\"servicoempresaID\":\"88\",\"datacadastro\":\"2023-03-15\",\"preco\":\"1200\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_67e7363dc3f6b586ad9b7cbe4c7cf92d1678913710.pdf\"}]'),
(7298, '177.131.124.221', '2023-10-26 11:51:03', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #412', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"412\",\"servicoempresaID\":\"88\",\"datacadastro\":\"2023-03-15\",\"preco\":\"1200\",\"datavencimento\":\"2024-01-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_10785968e9f554620d0b8ce31220b3491678913716.pdf\"}]'),
(7299, '177.131.124.221', '2023-10-26 11:51:03', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #413', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"413\",\"servicoempresaID\":\"88\",\"datacadastro\":\"2023-03-15\",\"preco\":\"1200\",\"datavencimento\":\"2024-02-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_a89e784fe1097b07fec59428d507be9d1678913732.pdf\"}]'),
(7300, '177.131.124.221', '2023-10-26 11:57:15', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #437', '{\"servicoempresaID\":\"93\",\"datacadastro\":\"2023-10-02\",\"formapagamentoID\":\"4\",\"preco\":\"1200.00\"}', '[]'),
(7301, '177.131.124.221', '2023-10-26 11:57:15', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #526', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"526\",\"servicoempresaID\":\"93\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2023-11-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_cfd746fb38a3b86bd18f84fa81929aa01691453558.pdf\"}]'),
(7302, '177.131.124.221', '2023-10-26 11:57:15', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #527', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"527\",\"servicoempresaID\":\"93\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_21a28a252e5b59c37facb9f0e48afaca1691453572.pdf\"}]'),
(7303, '177.131.124.221', '2023-10-26 11:57:15', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #528', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"528\",\"servicoempresaID\":\"93\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2024-01-02\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_3049903abac610c7aaed808548d920991691453583.pdf\"}]'),
(7304, '177.131.124.221', '2023-10-26 13:18:02', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #374', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"374\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2023-11-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_4971b93c1e96d5182884028af31118301675103200.pdf\"}]'),
(7305, '177.131.124.221', '2023-10-26 13:18:02', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #375', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"375\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_793d9706121e53685d9ebe1e8e6a8a431675103204.pdf\"}]'),
(7306, '177.131.124.221', '2023-10-26 13:18:02', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #376', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"376\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2024-01-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_61539faa546897729af83b247ee5c98c1675103101.pdf\"}]'),
(7307, '177.131.124.221', '2023-10-26 13:45:48', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7308, '177.131.124.221', '2023-10-26 15:12:26', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7309, '177.131.124.221', '2023-10-26 16:22:16', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7310, '177.131.124.221', '2023-10-26 20:15:10', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7311, '177.131.124.137', '2023-10-30 12:13:16', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7312, '177.131.124.137', '2023-10-30 13:27:22', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7313, '177.131.124.148', '2023-10-31 11:41:53', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7314, '177.131.124.148', '2023-10-31 11:43:47', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #438', '{\"servicoempresaID\":\"89\",\"datacadastro\":\"2023-10-26\",\"formapagamentoID\":\"4\",\"preco\":\"1530.00\"}', '[]'),
(7315, '177.131.124.1', '2023-10-31 13:37:24', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7316, '177.131.124.1', '2023-10-31 14:11:50', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7317, '177.131.124.1', '2023-10-31 14:26:20', 1, 2, 'servicocobranca', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicocobranca\" #562', '{\"servicoempresaID\":\"89\",\"preco\":\"1500.00\",\"datavencimento\":\"2023-12-10\",\"datacadastro\":\"2023-10-31\",\"statuscobrancaID\":\"1\"}', '[]'),
(7318, '177.131.124.1', '2023-10-31 19:17:32', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7319, '177.131.124.68', '2023-11-01 11:49:30', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7320, '177.131.124.68', '2023-11-01 12:52:17', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7321, '177.174.242.95', '2023-11-01 14:13:29', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7322, '177.174.242.95', '2023-11-01 14:14:03', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7323, '177.131.124.68', '2023-11-01 14:16:31', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7324, '177.131.124.68', '2023-11-01 14:17:21', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7325, '177.131.124.15', '2023-11-01 16:44:45', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7326, '177.131.124.15', '2023-11-01 16:45:07', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7327, '177.131.124.15', '2023-11-01 18:03:31', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7328, '177.131.124.21', '2023-11-01 20:09:41', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7329, '177.131.124.109', '2023-11-02 11:21:01', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7330, '177.131.124.109', '2023-11-02 11:24:58', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7331, '177.131.124.109', '2023-11-02 11:34:32', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7332, '177.131.124.109', '2023-11-02 12:39:37', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7333, '177.131.124.109', '2023-11-02 13:15:06', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7334, '177.131.124.10', '2023-11-03 12:19:54', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7335, '177.131.124.10', '2023-11-03 13:49:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #374', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"374\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2023-11-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_4971b93c1e96d5182884028af31118301675103200.pdf\"}]'),
(7336, '177.131.124.10', '2023-11-03 13:49:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #375', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"375\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_793d9706121e53685d9ebe1e8e6a8a431675103204.pdf\"}]'),
(7337, '177.131.124.10', '2023-11-03 13:49:16', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #376', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"376\",\"servicoempresaID\":\"83\",\"datacadastro\":\"2023-02-01\",\"preco\":\"975\",\"datavencimento\":\"2024-01-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_61539faa546897729af83b247ee5c98c1675103101.pdf\"}]'),
(7338, '177.131.124.10', '2023-11-03 15:19:06', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7339, '177.131.124.10', '2023-11-03 15:19:07', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7340, '177.131.124.122', '2023-11-06 13:58:01', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7341, '177.131.124.122', '2023-11-06 13:58:13', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7342, '177.131.124.122', '2023-11-06 13:59:43', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7343, '177.131.124.122', '2023-11-06 14:12:34', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #467', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"467\",\"servicoempresaID\":\"62\",\"datacadastro\":\"0000-00-00\",\"preco\":\"975\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_113053eab2af95ca4c193d1bb6f243121689884750.pdf\"}]'),
(7344, '177.131.124.122', '2023-11-06 14:12:34', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #468', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"468\",\"servicoempresaID\":\"62\",\"datacadastro\":\"0000-00-00\",\"preco\":\"975\",\"datavencimento\":\"2024-01-02\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_c44a98c5c48a635fb2eba5f564fb1ef11689884789.pdf\"}]'),
(7345, '177.131.124.135', '2023-11-07 12:56:22', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7346, '177.131.124.135', '2023-11-07 12:58:48', 1, 2, 'servicoempresa', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicoempresa\" #97', '{\"empresaID\":\"043\",\"servicoID\":\"06\",\"datacadastro\":\"2023-11-07\",\"ativo\":\"1\",\"preco\":\"2000.00\",\"datavencimento\":\"\",\"diavencimento\":\"\",\"descricao\":\"\"}', '[]'),
(7347, '177.131.124.135', '2023-11-07 14:20:07', 1, 2, 'usuario', 'Usuário Aron Scapinello Selhorst cadastrou em \"usuario\" #53', '{\"login\":\"06209665993\",\"cpf\":\"06209665993\",\"datanascimento\":\"1987-08-19\",\"nomeCompleto\":\"ANA CAROLINA CANELLO MODESTI\",\"email\":\"anacarolina.modesti@hotmail.com\",\"papelDeUsuarioID\":\"1\",\"admin\":\"\",\"status\":\"1\",\"senha\":\"827ccb0eea8a706c4c34a16891f84e7b\"}', '[]'),
(7348, '177.131.124.135', '2023-11-07 14:20:48', 1, 2, 'empresa', 'Usuário Aron Scapinello Selhorst cadastrou em \"empresa\" #71', '{\"nome\":\"ANA CAROLINA CANELLO MODESTI\",\"cnpj\":\"\"}', '[]'),
(7349, '177.131.124.115', '2023-11-13 13:31:24', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7350, '177.131.124.115', '2023-11-13 16:23:19', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7351, '177.131.124.115', '2023-11-13 18:41:46', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7352, '177.131.124.38', '2023-11-14 13:17:09', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7353, '177.131.124.38', '2023-11-14 14:22:37', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7354, '177.131.124.96', '2023-11-16 16:58:00', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7355, '177.131.124.96', '2023-11-17 00:23:41', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7356, '177.131.124.151', '2023-11-17 22:41:54', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7357, '177.131.124.249', '2023-11-20 17:42:28', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7358, '177.131.124.249', '2023-11-20 17:55:02', 1, 4, 'servicoempresa', 'Usuário Aron Scapinello Selhorst editou em \"servicoempresa\" #50', '{\"ativo\":\"1\",\"descricao\":\"<p>Nova senha Instagram: ADarq2022</p>\\\\n<p>&nbsp;</p>\\\\n<p>CPF: 007.678.209-32&nbsp;&nbsp;</p>\\\\n<p>&nbsp;</p>\\\\n<p>-------------------------------------------------------------</p>\\\\n<p>Datas Comemorativas:</p>\\\\n<p>-&gt; 14/08 Dia dos pais</p>\\\\n<p>-&gt; 15/09 Dia do Cliente</p>\\\\n<p>-&gt; 12/10 Dia das Crian&ccedil;as</p>\\\\n<p>- 15/11 Proclama&ccedil;&atilde;o da Rep&uacute;blica</p>\\\\n<p>-&gt; 15/12 Dia do Arquiteto</p>\\\\n<p>-&gt; 25/12 Natal</p>\"}', '[{\"servicoempresaID\":\"50\",\"empresaID\":\"28\",\"servicoID\":\"3\",\"datacadastro\":\"2022-06-01 00:00:00\",\"ativo\":\"1\",\"preco\":\"350\",\"datavencimento\":\"0000-00-00\",\"diavencimento\":\"0\",\"descricao\":\"<p>Nova senha Instagram: ADarq2022</p>\n<p>&nbsp;</p>\n<p>CPF: 007.678.209-32&nbsp;&nbsp;</p>\n<p>&nbsp;</p>\n<p>-------------------------------------------------------------</p>\n<p>Datas Comemorativas:</p>\n<p>-&gt; 14/08 Dia dos pais</p>\n<p>-&gt; 15/09 Dia do Cliente</p>\n<p>-&gt; 12/10 Dia das Crian&ccedil;as</p>\n<p>- 15/11 Proclama&ccedil;&atilde;o da Rep&uacute;blica</p>\n<p>-&gt; 15/12 Dia do Arquiteto</p>\n<p>-&gt; 25/12 Natal</p>\"}]'),
(7359, '177.131.124.249', '2023-11-20 17:55:02', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #439', '{\"servicoempresaID\":\"50\",\"datacadastro\":\"2023-10-31\",\"formapagamentoID\":\"3\",\"preco\":\"350.00\"}', '[]'),
(7360, '177.131.124.249', '2023-11-20 18:07:03', 1, 2, 'servicopagamento', 'Usuário Aron Scapinello Selhorst cadastrou em \"servicopagamento\" #440', '{\"servicoempresaID\":\"79\",\"datacadastro\":\"2023-11-01\",\"formapagamentoID\":\"4\",\"preco\":\"1200.00\"}', '[]'),
(7361, '177.131.124.249', '2023-11-20 18:07:03', 1, 4, 'servicocobranca', 'Usuário Aron Scapinello Selhorst editou em \"servicocobranca\" #480', '{\"statuscobrancaID\":\"1\"}', '[{\"servicocobrancaID\":\"480\",\"servicoempresaID\":\"79\",\"datacadastro\":\"0000-00-00\",\"preco\":\"1200\",\"datavencimento\":\"2023-12-01\",\"statuscobrancaID\":\"1\",\"linkboleto\":\"cobrancaboleto_3ed7c6205d20d7b1c261c8b6e2d5cbc01689885449.pdf\"}]'),
(7362, '177.131.124.173', '2023-11-21 12:53:06', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7363, '177.131.124.173', '2023-11-21 12:55:43', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7364, '177.131.124.74', '2023-11-30 11:32:54', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7365, '177.131.124.74', '2023-11-30 12:41:12', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7366, '177.131.124.152', '2023-12-05 14:27:14', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7367, '177.131.124.204', '2023-12-06 10:07:44', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7368, '177.131.124.204', '2023-12-06 10:13:05', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7369, '177.131.124.204', '2023-12-06 12:36:17', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7370, '177.131.124.164', '2023-12-07 11:08:18', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7371, '177.131.124.164', '2023-12-07 12:19:52', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7372, '177.131.124.18', '2023-12-08 12:16:26', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7373, '177.131.124.18', '2023-12-08 13:24:41', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7374, '177.131.124.74', '2023-12-19 10:59:32', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7375, '177.131.124.89', '2023-12-20 11:43:35', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7376, '177.131.124.89', '2023-12-20 12:52:59', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7377, '177.131.124.63', '2023-12-22 11:27:25', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7378, '177.131.124.63', '2023-12-22 12:32:59', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7379, '177.131.124.169', '2023-12-27 15:10:41', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7380, '177.131.124.61', '2023-12-30 13:10:27', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7381, '177.131.124.137', '2024-01-02 13:25:56', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7382, '177.174.242.119', '2024-01-07 17:55:59', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7383, '177.131.124.237', '2024-01-08 13:11:57', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7384, '177.131.124.237', '2024-01-08 14:12:12', 1, 6, '', 'Usuário Aron Scapinello Selhorst saiu do sistema', '', ''),
(7385, '177.131.124.237', '2024-01-08 15:14:39', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7386, '177.131.124.205', '2024-01-09 13:24:48', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7387, '177.131.124.54', '2024-01-11 12:00:48', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7388, '177.131.124.105', '2024-01-14 10:12:58', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7389, '177.131.124.105', '2024-01-14 19:14:40', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7390, '177.131.124.173', '2024-01-16 10:47:02', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7391, '177.131.124.173', '2024-01-16 13:18:35', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7392, '177.131.124.228', '2024-01-26 11:27:39', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7393, '177.131.124.228', '2024-01-26 11:28:42', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7394, '177.131.124.185', '2024-02-05 13:34:30', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7395, '200.53.23.87', '2024-02-18 13:00:04', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7396, '200.53.23.53', '2024-02-20 12:13:15', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7397, '177.131.124.198', '2024-02-28 11:02:53', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', ''),
(7398, '177.131.124.186', '2024-03-01 11:21:27', 1, 1, '', 'Usuário Aron Scapinello Selhorst realizou login no sistema', '', '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `menu`
--

CREATE TABLE `menu` (
  `menuID` int(11) NOT NULL,
  `titulo` varchar(255) NOT NULL,
  `icone` varchar(255) NOT NULL,
  `ativo` tinyint(1) NOT NULL COMMENT '1 caso queira iniciar aberto',
  `link` varchar(255) NOT NULL,
  `ordem` int(11) NOT NULL,
  `atalho` varchar(1) NOT NULL,
  `flagnovo` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `menu`
--

INSERT INTO `menu` (`menuID`, `titulo`, `icone`, `ativo`, `link`, `ordem`, `atalho`, `flagnovo`) VALUES
(1, 'Cadastros', 'fa fa-pencil-square', 0, '', 1000, 'm', 0),
(3, 'Configurações', 'fa fa-cog', 0, '', 1001, 's', 0),
(5, 'Contatos', 'fa fa-envelope', 0, 'contatos', 456, 'g', 0),
(6, 'Minhas compras', 'fa fa-shopping-cart', 1, 'compras', 1, 'c', 0),
(8, 'Ajuda', 'fa fa-support', 0, '', 99999, 'h', 0),
(10, 'Relatórios', 'fa fa-file-text', 0, 'relatorios', 654, 'r', 0),
(14, 'Painel Inicial', 'fa fa-home', 0, 'home', 0, '', 0),
(18, 'Pagamentos', 'fa fa-money', 0, 'pagamentos', 12, 'p', 0),
(19, 'Afiliados', 'fa fa-cubes', 0, 'afiliado', 33, '', 0),
(20, 'Ferramentas', 'fa fa-cogs', 0, '', 999, '', 0),
(21, 'Minhas empresas', 'fa fa-building', 0, 'minhasempresas', 7, '', 0);

-- --------------------------------------------------------

--
-- Estrutura da tabela `menumaisopcao`
--

CREATE TABLE `menumaisopcao` (
  `menumaisopcaoID` int(11) NOT NULL,
  `menuID` int(11) NOT NULL,
  `titulo` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `icon` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `netpromotescore`
--

CREATE TABLE `netpromotescore` (
  `netpromotescoreID` int(11) NOT NULL,
  `nota` int(11) NOT NULL,
  `datacadastro` date NOT NULL,
  `usuarioID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `netpromotescore`
--

INSERT INTO `netpromotescore` (`netpromotescoreID`, `nota`, `datacadastro`, `usuarioID`) VALUES
(5, 10, '2022-02-13', 1),
(6, 10, '2022-05-16', 1),
(7, 10, '2022-08-17', 1),
(8, 10, '2022-11-02', 2),
(9, 10, '2022-11-18', 1),
(10, 10, '2023-03-02', 1),
(11, 10, '2023-08-02', 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `papeldeusuario`
--

CREATE TABLE `papeldeusuario` (
  `papeldeusuarioID` int(11) NOT NULL,
  `papel` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `papeldeusuario`
--

INSERT INTO `papeldeusuario` (`papeldeusuarioID`, `papel`) VALUES
(1, 'CLIENTE'),
(2, 'ADMINISTRATIVO');

-- --------------------------------------------------------

--
-- Estrutura da tabela `papelrelatorio`
--

CREATE TABLE `papelrelatorio` (
  `papelrelatorioID` int(11) NOT NULL,
  `relatorioID` int(11) NOT NULL,
  `papeldeusuarioID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `parametrorelatorio`
--

CREATE TABLE `parametrorelatorio` (
  `parametrorelatorioID` int(11) NOT NULL COMMENT 'Identificador',
  `nome` varchar(255) NOT NULL COMMENT 'Nome do parâmetro',
  `tipo` varchar(25) NOT NULL COMMENT 'Tipo do parâmetro',
  `nomeCampo` varchar(255) NOT NULL COMMENT 'Nome do campo, sem utilizar espaço',
  `relatorioID` int(11) NOT NULL,
  `tamanhoCampo` varchar(2) NOT NULL COMMENT 'Tamanho que aparecerá na tela do sistema',
  `descricao` varchar(255) NOT NULL COMMENT 'Descrição do campo',
  `valorPadrao` varchar(255) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `permissao`
--

CREATE TABLE `permissao` (
  `permissaoID` int(11) NOT NULL,
  `papelDeUsuarioID` int(11) NOT NULL,
  `link` varchar(255) NOT NULL,
  `ver` tinyint(1) NOT NULL DEFAULT '0',
  `editar` tinyint(1) NOT NULL DEFAULT '0',
  `adicionar` tinyint(1) NOT NULL DEFAULT '0',
  `excluir` tinyint(1) NOT NULL DEFAULT '0',
  `outrasPermissoes` tinyint(4) DEFAULT '0' COMMENT '0-Não 1-Sim'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `permissao`
--

INSERT INTO `permissao` (`permissaoID`, `papelDeUsuarioID`, `link`, `ver`, `editar`, `adicionar`, `excluir`, `outrasPermissoes`) VALUES
(1150, 1, 'home', 1, 1, 1, 1, 0),
(1151, 1, 'compras', 1, 1, 0, 0, 0),
(1152, 1, 'minhasempresas', 1, 1, 0, 0, 0),
(1153, 1, 'https://insource.com.br/whatsapp-link', 1, 0, 0, 0, 0),
(1154, 1, 'https://insource.com.br/#contato', 1, 1, 0, 0, 0),
(1155, 1, 'relatorios', 0, 1, 1, 1, 0),
(1156, 1, 'alterarsenha', 1, 1, 1, 1, 1),
(1157, 1, 'meuperfil', 1, 1, 1, 1, 1),
(1158, 1, 'messages', 1, 1, 1, 1, 1),
(1159, 1, 'https://api.whatsapp.com/send?phone=5549999934272&text=Olá, vim pelo sistema de administração da InSource.', 1, 1, 1, 1, 1),
(1160, 2, 'home', 1, 1, 1, 1, 0),
(1161, 2, 'compras', 1, 1, 1, 1, 0),
(1162, 2, 'minhasempresas', 1, 1, 1, 1, 0),
(1163, 2, 'pagamentos', 1, 1, 1, 1, 0),
(1164, 2, 'afiliado', 1, 1, 1, 1, 0),
(1165, 2, 'contatos', 1, 1, 1, 1, 0),
(1166, 2, 'relatorios', 1, 1, 1, 1, 0),
(1167, 2, 'log', 1, 1, 1, 1, 0),
(1168, 2, 'usuarios', 1, 1, 1, 1, 0),
(1169, 2, 'papeis', 1, 1, 1, 1, 0),
(1170, 2, 'parametros', 1, 1, 1, 1, 0),
(1171, 2, 'menumaisopcao', 1, 1, 1, 1, 0),
(1172, 2, 'https://api.whatsapp.com/send?phone=5549999934272&text=Olá, vim pelo sistema de administração da InSource.', 1, 1, 1, 1, 0),
(1173, 2, 'https://insource.com.br/#contato', 1, 1, 1, 1, 0),
(1174, 2, 'categoria', 1, 1, 1, 1, 0),
(1175, 2, 'empresas', 1, 1, 1, 1, 0),
(1176, 2, 'formadepagamento', 1, 1, 1, 1, 0),
(1177, 2, 'servicos', 1, 1, 1, 1, 0),
(1178, 2, 'https://insource.com.br/whatsapp-link', 1, 1, 1, 1, 0),
(1179, 2, 'alterarsenha', 0, 0, 0, 0, 0),
(1180, 2, 'meuperfil', 0, 0, 0, 0, 0),
(1181, 2, 'messages', 0, 0, 0, 0, 0),
(1182, 2, 'alterarsenha', 1, 1, 1, 1, 1),
(1183, 2, 'meuperfil', 1, 1, 1, 1, 1),
(1184, 2, 'messages', 1, 1, 1, 1, 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `produto`
--

CREATE TABLE `produto` (
  `produtoID` int(11) NOT NULL,
  `valor` double NOT NULL DEFAULT '0',
  `titulo` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estrutura da tabela `produtocategoria`
--

CREATE TABLE `produtocategoria` (
  `produtocategoriaID` int(11) NOT NULL,
  `produtoID` int(11) NOT NULL DEFAULT '0',
  `categoriaID` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estrutura da tabela `produtofoto`
--

CREATE TABLE `produtofoto` (
  `produtofotoID` int(11) NOT NULL,
  `produtoID` int(11) NOT NULL,
  `foto` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estrutura da tabela `relatorio`
--

CREATE TABLE `relatorio` (
  `relatorioID` int(11) NOT NULL COMMENT 'Identificador',
  `nome` varchar(255) NOT NULL COMMENT 'Nome do relatório',
  `tipoRelatorioID` int(11) NOT NULL COMMENT 'Tipo de relatório. Referencia a tabela tipoRelatorio',
  `numeroRelatorio` int(11) NOT NULL,
  `nomeArquivo` varchar(255) NOT NULL COMMENT 'Nome do arquivo do relatório',
  `ireport` tinytext NOT NULL COMMENT '0-n 1-s'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `servico`
--

CREATE TABLE `servico` (
  `servicoID` int(11) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `descricao` varchar(1500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `servico`
--

INSERT INTO `servico` (`servicoID`, `nome`, `descricao`) VALUES
(1, 'WEBSITE', ''),
(2, 'APLICATIVOS', ''),
(3, 'GESTÃO DE REDES SOCIAIS', ''),
(4, 'SISTEMAS PERSONALIZADOS', ''),
(5, 'LOGOTIPO', ''),
(6, 'DESIGN', ''),
(7, 'SUPORTE | MANUTENÇÃO | SERVIDOR', ''),
(8, 'DESIGN DE CARDÁPIO', ''),
(9, 'CURSO AUTO ESCOLA DIGITAL', ''),
(10, 'E-COMMERCE', ''),
(11, 'SUPORTE/SERVIDOR WEBSITE', ''),
(12, 'AFILIADOS', ''),
(13, 'GOOGLE ADS PRO', ''),
(14, 'FACEBOOK ADS PRO', ''),
(15, 'YOUTUBE ADS PRO', ''),
(16, 'MENTORIA ARON SELHORST', ''),
(17, 'RENEGOCIAÇÃO DE DÍVIDA', ''),
(18, 'RESCISÃO CONTRATUAL', '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `servicocobranca`
--

CREATE TABLE `servicocobranca` (
  `servicocobrancaID` int(11) NOT NULL,
  `servicoempresaID` int(11) NOT NULL,
  `datacadastro` date NOT NULL,
  `preco` double NOT NULL,
  `datavencimento` date NOT NULL,
  `statuscobrancaID` int(11) NOT NULL,
  `linkboleto` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `servicocobranca`
--

INSERT INTO `servicocobranca` (`servicocobrancaID`, `servicoempresaID`, `datacadastro`, `preco`, `datavencimento`, `statuscobrancaID`, `linkboleto`) VALUES
(410, 88, '2023-03-15', 1200, '2023-11-01', 1, 'cobrancaboleto_097507dc4e7d42d6d33b53cd5c217ed81678913704.pdf'),
(411, 88, '2023-03-15', 1200, '2023-12-01', 1, 'cobrancaboleto_67e7363dc3f6b586ad9b7cbe4c7cf92d1678913710.pdf'),
(412, 88, '2023-03-15', 1200, '2024-01-01', 1, 'cobrancaboleto_10785968e9f554620d0b8ce31220b3491678913716.pdf'),
(413, 88, '2023-03-15', 1200, '2024-02-01', 1, 'cobrancaboleto_a89e784fe1097b07fec59428d507be9d1678913732.pdf'),
(414, 78, '2023-04-04', 5250, '2023-04-10', 1, 'cobrancaboleto_dd0c02098bed02bc3727f2ca4b2c27771680629026.pdf'),
(429, 67, '2023-06-09', 1500, '2023-06-12', 1, 'cobrancaboleto_955139dfbc74d37f4bcbe1a19080c7dc1686316688.pdf'),
(434, 90, '0000-00-00', 1200, '2023-10-10', 1, 'cobrancaboleto_edc3839f5c30fbf7f71ccb4d525dcb4f1687472678.pdf'),
(435, 90, '0000-00-00', 1200, '2023-11-10', 1, 'cobrancaboleto_41f0da1a6d86615880d33a93c118c11c1687472756.pdf'),
(436, 90, '0000-00-00', 1200, '2023-12-11', 1, 'cobrancaboleto_297918ada546ec38763fecfb43f52b761687472795.pdf'),
(437, 90, '0000-00-00', 1200, '2024-01-10', 1, 'cobrancaboleto_367922476a20a942e9679a4d54f846c11687472902.pdf'),
(438, 90, '0000-00-00', 1200, '2024-02-12', 1, 'cobrancaboleto_8d12df909873f512d74bd321666e25871687472948.pdf'),
(439, 90, '0000-00-00', 1200, '2024-03-11', 1, 'cobrancaboleto_5797881b412b4a02957241c88e7f19c51687473054.pdf'),
(440, 90, '0000-00-00', 1200, '2024-04-10', 1, 'cobrancaboleto_595b21b905508aba43a06473d681a8181687473095.pdf'),
(441, 90, '0000-00-00', 1200, '2024-05-10', 1, 'cobrancaboleto_b176a33727bacf2172eb4f9957c7275d1687473128.pdf'),
(444, 67, '2023-07-03', 1500, '2023-06-10', 1, 'cobrancaboleto_630eaf1806923cb98995be2f4704d4951689885534.pdf'),
(451, 54, '0000-00-00', 975, '2023-12-01', 1, 'cobrancaboleto_b002ccd370626346f8e65058c5fdbbd41689882419.pdf'),
(452, 54, '0000-00-00', 975, '2024-01-02', 1, 'cobrancaboleto_822b99defb57eee745e9b5ce067845571689882443.pdf'),
(453, 54, '0000-00-00', 975, '2024-02-01', 1, 'cobrancaboleto_495ebf6919007733d96eb834816a3e831689882452.pdf'),
(454, 54, '0000-00-00', 975, '2024-03-01', 1, 'cobrancaboleto_12fe43b5a7f045c5741e645e04e1c75d1689882464.pdf'),
(455, 54, '0000-00-00', 975, '2024-04-01', 1, 'cobrancaboleto_7d91e7228ae2a025d44f6f8bcc5c52601689882475.pdf'),
(456, 54, '0000-00-00', 975, '2024-05-01', 1, 'cobrancaboleto_0c0e690cce764096ee61e7987e11c28b1689882494.pdf'),
(457, 54, '0000-00-00', 975, '2024-06-03', 1, 'cobrancaboleto_f89c41224d35b845d1f5eeb76272a34a1689882536.pdf'),
(467, 62, '0000-00-00', 975, '2023-12-01', 1, 'cobrancaboleto_113053eab2af95ca4c193d1bb6f243121689884750.pdf'),
(468, 62, '0000-00-00', 975, '2024-01-02', 1, 'cobrancaboleto_c44a98c5c48a635fb2eba5f564fb1ef11689884789.pdf'),
(473, 61, '0000-00-00', 975, '2023-12-01', 1, 'cobrancaboleto_be38dd8d1ae183f4b9e23f5236bd97311689884961.pdf'),
(475, 61, '0000-00-00', 975, '2024-01-02', 1, 'cobrancaboleto_b1960748a8a83904d9fad215b2961ab11689885007.pdf'),
(491, 84, '0000-00-00', 1200, '2023-12-01', 1, 'cobrancaboleto_a218509a9f8f29c4b3abeb10f85c52b81690315667.pdf'),
(492, 84, '0000-00-00', 1200, '2024-01-02', 1, 'cobrancaboleto_1ea2961e4e3a6167037c17e781a340ef1690315676.pdf'),
(496, 85, '0000-00-00', 1200, '2023-11-01', 1, 'cobrancaboleto_413a82ad514c528188b8e9fd84341c821690328827.pdf'),
(497, 85, '0000-00-00', 1200, '2023-12-01', 1, 'cobrancaboleto_24a364f48cbe47ec6b5320ef8b3d8bb81690328843.pdf'),
(498, 85, '0000-00-00', 1200, '2024-01-02', 1, 'cobrancaboleto_4c5543d763850a5cf9e80c5ea75b9b661690328883.pdf'),
(527, 93, '0000-00-00', 1200, '2023-12-01', 1, 'cobrancaboleto_21a28a252e5b59c37facb9f0e48afaca1691453572.pdf'),
(528, 93, '0000-00-00', 1200, '2024-01-02', 1, 'cobrancaboleto_3049903abac610c7aaed808548d920991691453583.pdf'),
(534, 53, '2023-08-31', 400, '2023-10-01', 1, ''),
(538, 96, '0000-00-00', 1200, '2023-12-01', 1, 'cobrancaboleto_8643a4040be6a433606e81490aea38871694991431.pdf'),
(539, 96, '0000-00-00', 1200, '2024-01-02', 1, 'cobrancaboleto_d7bc796c23d9a76a195deedffde63aec1694991746.pdf'),
(540, 96, '0000-00-00', 1200, '2024-02-01', 1, 'cobrancaboleto_8ff56d74507ae4c1e766fcdb8e2d75771694993441.pdf'),
(542, 90, '0000-00-00', 765, '2023-10-18', 1, 'cobrancaboleto_32016839b3b1d73321d08ded4b1e9d821695415677.pdf'),
(543, 90, '0000-00-00', 765, '2023-11-18', 1, 'cobrancaboleto_095c23f38cc5fefc5118dd9cb21e10341695415694.pdf'),
(544, 90, '0000-00-00', 765, '2023-12-18', 1, 'cobrancaboleto_b478dcbf2235547555d04905077eac8b1695415713.pdf'),
(545, 90, '0000-00-00', 765, '2024-01-18', 1, 'cobrancaboleto_90afba6623a7a4fa790767d3db3c0bc51695415729.pdf'),
(546, 74, '0000-00-00', 706, '2023-09-30', 1, 'cobrancaboleto_1ed06f5d65e74fe95514c69e70bede121695828626.pdf'),
(547, 74, '0000-00-00', 706, '2023-10-10', 1, 'cobrancaboleto_b6b5c7fd5272f44f8f970f73b8288b7c1696008316.pdf'),
(548, 74, '0000-00-00', 706, '2023-11-10', 1, 'cobrancaboleto_58bba5026fe7c7e5b3eb2f678a265dd01696008332.pdf'),
(549, 74, '0000-00-00', 706, '2023-12-10', 1, 'cobrancaboleto_28072530cbffe24733e3f5f4dca7bf3c1696008355.pdf'),
(550, 74, '0000-00-00', 706, '2024-01-10', 1, 'cobrancaboleto_8e9724794dba86f72dff85f08a6d14321696008371.pdf'),
(555, 74, '0000-00-00', 706, '2024-03-10', 1, 'cobrancaboleto_fe134760730df38418df45b3667673001696008393.pdf'),
(556, 74, '0000-00-00', 706, '2024-04-10', 1, 'cobrancaboleto_71d00ebdddbece78f78d2ef9475a13f11696008402.pdf'),
(557, 74, '0000-00-00', 706, '2024-05-10', 1, 'cobrancaboleto_74d09a95bbc4c58462c8b9451427e5131696008420.pdf'),
(558, 74, '0000-00-00', 706, '2024-06-10', 1, 'cobrancaboleto_363adfc1a354f5b822afa91ac32e88751696008431.pdf'),
(559, 74, '0000-00-00', 760, '2024-07-10', 1, 'cobrancaboleto_7c7bd89a9d6b5d1954ddbd210364a3511696008443.pdf'),
(560, 74, '0000-00-00', 760, '2024-08-10', 1, 'cobrancaboleto_e71e8cac780b0090146b223f1b99c2aa1696008454.pdf'),
(561, 74, '0000-00-00', 760, '2024-09-10', 1, 'cobrancaboleto_530505b32d69c7a40c7487efaa36a42c1696008476.pdf');

-- --------------------------------------------------------

--
-- Estrutura da tabela `servicoempresa`
--

CREATE TABLE `servicoempresa` (
  `servicoempresaID` int(11) NOT NULL,
  `empresaID` int(11) NOT NULL,
  `servicoID` int(11) NOT NULL,
  `datacadastro` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `ativo` tinyint(4) NOT NULL,
  `preco` double NOT NULL,
  `datavencimento` date NOT NULL DEFAULT '0001-01-01',
  `diavencimento` int(11) NOT NULL,
  `descricao` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `servicoempresa`
--

INSERT INTO `servicoempresa` (`servicoempresaID`, `empresaID`, `servicoID`, `datacadastro`, `ativo`, `preco`, `datavencimento`, `diavencimento`, `descricao`) VALUES
(1, 1, 5, '2021-03-23 03:10:48', 0, 300, '2021-04-30', 0, '<p>Lucas Arno Agrimpho</p>\n<p>Rua Olivo Lago 574 e</p>\n<p>Bairro quedas do palmital</p>\n<p>CEP 89815200</p>\n<p>CPF: 098.744.249-07</p>'),
(2, 7, 1, '2021-03-23 21:00:51', 0, 500, '0001-01-01', 0, ''),
(3, 9, 5, '2021-03-23 21:00:51', 0, 200, '0001-01-01', 0, ''),
(4, 2, 3, '2021-03-23 21:00:51', 0, 300, '2021-05-01', 1, '<p>https://www.instagram.com/carnestonello</p>\n<p>Senha: malu29</p>\n<p>----------------------------------------------------------------------------------------------------</p>\n<p>CPF: 06524951921</p>\n<p>Luiz Carlos Tonello</p>\n<p>RG 104211380</p>\n<p>Avenida Presidente Get&uacute;lio Vargas 960&nbsp;</p>\n<p>----------------------------------------------------------------------------------------------------</p>\n<p><strong>Observa&ccedil;&otilde;es Gerais de Pagamento:</strong></p>\n<p>Nota Fiscal foi emitida junto com o servi&ccedil;o de Gest&atilde;o de Redes Sociais Ref. 09/2021 no total de R$ 630,00, sendo R$ 300,00 da Gest&atilde;o de Redes Sociais e R$ 330,00 da Logomarca e Identidade Visual; Pagamento efetuado em 13/09/2021 no total de R$ 630,00 (Gest&atilde;o de Redes Sociais 09/2021 + Logomarca)</p>\n<p>----------------------------------------------------------------------------------------------------</p>'),
(5, 5, 5, '2021-03-23 21:00:51', 0, 0, '0001-01-01', 0, ''),
(6, 3, 3, '2021-03-23 21:00:51', 0, 350, '2021-05-01', 1, '<p>https://www.instagram.com/</p>\n<p>Usuario: casanuova_cidadania</p>\n<p>Senha: CasaNuova2016#</p>\n<p>&nbsp;</p>\n<p>-------------------------------------------</p>\n<p>&nbsp;</p>\n<p>**FESTAS ITALIANAS NO BRASIL**</p>\n<p>Festa Nacional da Uva &ndash; Caxias do Sul.</p>\n<p>Festa Tradicional Italiana de Belo Horizonte.</p>\n<p>Festa de S&atilde;o Vito &ndash; S&atilde;o Paulo.</p>\n<p>Festit&aacute;lia &ndash; Blumenau.</p>\n<p>Festa Italiana de S&atilde;o Caetano do Sul.</p>\n<p>Incanto Trentino &ndash; Nova Trento. (cancelado 2021)</p>\n<p>&nbsp;</p>\n<p>-------------------------------------------</p>\n<p>&nbsp;</p>\n<p>Pgts de R$ 420,00 correspondente a Gest&atilde;o de Redes Sociais + Cria&ccedil;&atilde;o de publica&ccedil;&otilde;es para Blog:</p>\n<p>- 06/12/2021</p>\n<p>- 07/01/2022</p>\n<p>- 07/02/2022</p>'),
(7, 3, 1, '2021-03-23 23:41:40', 0, 1600, '0001-01-01', 0, '<p>Info@casanuova.com.br</p>\n<p>CasaNuova2019#</p>\n<p>&nbsp;</p>\n<p>traducao@casanuova.com.br</p>\n<p>CasaNuova2016#</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>'),
(8, 3, 7, '2021-03-24 02:10:09', 0, 500, '2022-03-01', 1, '<p>Servi&ccedil;o referente ao suporte e manuten&ccedil;&atilde;o do site da Casanuova</p>\n<p>V&aacute;lido por 12 meses | At&eacute; 03/2023</p>'),
(9, 2, 8, '2001-01-07 19:00:00', 0, 150, '2021-04-15', 15, '<p>Ser impresso:</p>\n<p>https://www.canva.com/design/DAEYXTaCHHE/share/preview?token=as958xrgjJnS7WY9fUTKCQ&amp;role=EDITOR&amp;utm_content=DAEYXTaCHHE&amp;utm_campaign=designshare&amp;utm_medium=link&amp;utm_source=sharebutton</p>\n<p>&nbsp;</p>\n<p>A4 digital</p>\n<p>https://www.canva.com/design/DAEbG_rkglY/share/preview?token=2KMvyikz1CdlBRy3vrT6Rw&amp;role=EDITOR&amp;utm_content=DAEbG_rkglY&amp;utm_campaign=designshare&amp;utm_medium=link&amp;utm_source=sharebutton</p>'),
(10, 12, 5, '2021-05-01 00:00:00', 0, 450, '0201-05-10', 10, ''),
(11, 13, 3, '2021-05-07 00:00:00', 0, 350, '0000-00-00', 0, '<p>CPF: 022.356.539-36</p>\n<p>Endere&ccedil;o: rua Rio Grande do Norte, 275D, AP 302. Bajrro :Santo Ant&ocirc;nio . CEP 89815-500</p>\n<p>Nilceia Eliza Borges</p>\n<p>-----------------------------------------------</p>\n<p>&nbsp;</p>\n<p>- NICHO: Emagrecimento</p>\n<p>- P&Uacute;BLICO ALVO:</p>\n<p>&nbsp; - 30 &agrave; 55 anos</p>\n<p>&nbsp; - Classe m&eacute;dia, m&eacute;dia-alta</p>\n<p>&nbsp; - Maior parte Feminino</p>\n<p>&nbsp;</p>\n<p>- DORES DO P&Uacute;BLICO:</p>\n<p>&nbsp; - Como conseguir ter disciplina pra fazer dieta?</p>\n<p>&nbsp; - Como n&atilde;o ter mais v&iacute;cio em doces?</p>\n<p>&nbsp; - Como n&atilde;o ter pregui&ccedil;a pra fazer exerc&iacute;cio?</p>\n<p>&nbsp; - Como ado&ccedil;ar um alimento?</p>\n<p>&nbsp; - Como n&atilde;o desistir de uma dieta?</p>\n<p>&nbsp; - Como calcular calorias de uma dieta?</p>\n<p>&nbsp; - Qual exerc&iacute;cio fazer pra emagrecer?</p>\n<p>&nbsp; - Como perder gordura?</p>\n<p>&nbsp; - Como ganhar mais m&uacute;sculo?</p>\n<p>&nbsp; -&nbsp;</p>\n<p>&nbsp;</p>\n<p>- ASPIRA&Ccedil;&Otilde;ES DO P&Uacute;BLICO:</p>\n<p>&nbsp; - Auto Estima</p>\n<p>&nbsp; - Corpo saud&aacute;vel</p>\n<p>&nbsp; - Emagrecer</p>\n<p>&nbsp; - Mais sa&uacute;de</p>\n<p>&nbsp; - Conseguir ter foco na dieta</p>\n<p>&nbsp; - Conseguir ter disciplina na dieta</p>\n<p>&nbsp; - Aprender a cozinhar (Prepara um alimento)</p>\n<p>&nbsp; - Dormir melhor</p>\n<p>&nbsp; - Mais disposi&ccedil;&atilde;o para tarefas/trabalho</p>\n<p>&nbsp; - Conseguir fazer exerc&iacute;cios</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>'),
(12, 14, 7, '2021-05-13 00:00:00', 0, 500, '0000-00-00', 0, '<p>Atualiza&ccedil;&atilde;o de site</p>\n<p>- Criar Blog</p>\n<p>- Alterar menus e p&aacute;ginas</p>\n<p>&nbsp;</p>\n<p>locaweb:</p>\n<p>Matusa1313</p>\n<p>ma3565</p>'),
(13, 15, 3, '2021-05-15 00:00:00', 0, 350, '0000-00-00', 0, '<p>CPF: 04443821945</p>\n<p>INSTAGRAM: academia_life_</p>\n<p>SENHA: 984051217</p>\n<p>-------------------------------</p>\n<p><strong>Hor&aacute;rio de Atendimento:</strong></p>\n<p>Segunda quarta e sexta - 6h as 11h</p>\n<p>Ter&ccedil;a e quinta - 6:30 as 11h</p>\n<p>Todos os dias -15h as 22h</p>\n<p>-------------------------------</p>\n<p>Muay Thai 85,00 2x na semana - Ter&ccedil;a e quinta - 19:30</p>\n<p>Dan&ccedil;a se for s&oacute; dan&ccedil;a - 75 mensal 2x na semana -&nbsp;Quarta e sexta &agrave;s 18:30</p>\n<p>Pump tamb&eacute;m 75 mensal - Ter&ccedil;a e quinta &agrave;s 18:30</p>\n<p>DivertKids - 80 2x na semana - Ter&ccedil;a e quinta &agrave;s 17:30</p>\n<p>-------------------------------</p>\n<p>cnpj: 31.152.420/0001-17</p>\n<p>Academia Life</p>\n<p>Rua Dr Jo&atilde;o Gon&ccedil;alves Padilha 690</p>\n<p>85200-000 - Pitanga PR</p>\n<p>&nbsp;</p>\n<p>--------------------------------------------------------------</p>\n<p>&nbsp;</p>\n<p>Datas Comemorativas:</p>\n<p>-&gt; 08/08 Dia Nacional de Combate ao Colesterol</p>\n<p>-&gt; 14/08 Dia dos pais</p>\n<p>-&gt; 01/09 Dia do Profissional de Educa&ccedil;&atilde;o F&iacute;sica</p>\n<p>-&gt; 07/09 Dia da Independ&ecirc;ncia do Brasil</p>\n<p>-&gt; 15/09 Dia do Cliente</p>\n<p>-&gt; 22/09 In&iacute;cio da Primavera</p>\n<p>-&gt; 23/09 Dia de Combate ao Estresse</p>\n<p>-&gt; 01/10 Dia Internacional das Pessoas Idosas</p>\n<p>-&gt; 05/10 Dia Mundial dos Professores</p>\n<p>-&gt; 09/10 Dia do Atletismo</p>\n<p>-&gt; 12/10 Dia das Crian&ccedil;as</p>\n<p>-&gt; 30/10 Dia do Fisiculturista</p>\n<p>-&gt; 31/10 Dia das Bruxas - Halloween</p>\n<p>-&gt; 15/11 Proclama&ccedil;&atilde;o da Rep&uacute;blica</p>\n<p>-&gt; 25/11 Black Friday</p>\n<p>-&gt; 27/11 Dia Nacional de Combate ao C&acirc;ncer</p>\n<p>-&gt; 21/12 Dia do Atleta</p>\n<p>-&gt; 25/12 Natal</p>\n<p>&nbsp;</p>'),
(14, 14, 7, '2021-04-09 00:00:00', 0, 180, '0000-00-00', 1, '<p>Ajustes no site http://matusalemcastelan.com.br/</p>'),
(15, 16, 3, '2021-05-21 00:00:00', 0, 350, '2021-06-10', 10, '<p>Refer&ecirc;ncias: Seu Elias e Di black</p>\n<p>Senha facebook: 405715</p>\n<p>Senha Insta: dhe282925</p>\n<p>----------------------------------</p>\n<p>CPF: 02164282035</p>\n<p>Daniel Ferreira do Prado&nbsp;</p>\n<p>Rua Minas Gerais&nbsp;</p>\n<p>Bairro Presidente Medici - 759</p>\n<p>--------------------------------</p>\n<p>R$ 50,00 ser&atilde;o utilizados em tr&aacute;fego pago (Posts patrocinados)</p>'),
(16, 3, 4, '2021-06-03 00:00:00', 0, 7000, '0000-00-00', 0, '<p>Servi&ccedil;o referente ao desenvolvimento do sistema da Casanuova</p>\n<p>Feito em 2x de R$ 3.500,00</p>\n<p>&nbsp;</p>\n<p>A nota fiscal do pagamento de&nbsp;<span style=\"background-color: #eeeeee; color: #333333; font-family: Arial, sans-serif;\">06/08/2021</span> est&aacute; no valor de R$ 4950,00 (R$ 3500,00 + R$ 1450,00), sendo R$ 3500,00 a ultima parcela do sistema e R$1450,00 o pre&ccedil;o da parcela de manuten&ccedil;&atilde;o anual. Al&eacute;m disso, a nota foi lan&ccedil;ada no CPF pois o CNPJ da Casanuova foi cancelado pois estava no lucro presumido e na italia, e estava em transi&ccedil;&atilde;o para o Brasil no simples nacional.</p>\n<div class=\"col-xs-4 col-sm-4\" style=\"box-sizing: border-box; margin: 0px; -webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 16px; line-height: 16px; font-family: Arial, sans-serif; position: relative; min-height: 1px; float: left; width: 362.328px; color: #333333; padding: 0px 10px !important 0px 10px !important;\">&nbsp;</div>'),
(17, 1, 6, '2021-06-03 00:00:00', 0, 300, '0000-00-00', 0, '<p>Design de Uniformes referente &agrave; MAB Uniformes e SW Uniformes</p>\n<p>&nbsp;</p>\n<p>Lucas Arno Agrimpho</p>\n<p>Rua Olivo Lago 574 e</p>\n<p>Bairro quedas do palmital</p>\n<p>CEP 89815200</p>\n<p>CPF: 098.744.249-07</p>'),
(18, 3, 7, '2021-06-03 00:00:00', 0, 1450, '0000-00-00', 0, '<p>Servi&ccedil;o referente ao suporte e manuten&ccedil;&atilde;o do sistema personalizado de gest&atilde;o da Casanuova!&nbsp;</p>\n<p>&nbsp;</p>\n<p>Valor Anual: R$ 1450,00</p>\n<p>Valor Mensal: R$ 145,90</p>\n<p>Foi optado pelo Valor Anual de R$ 1450,00</p>\n<p>&nbsp;</p>\n<p>V&aacute;lido por 12 meses |&nbsp;Pr&oacute;xima em 06/08/2022</p>\n<p>*Nota fiscal foi anexada na compra do \"sistema\" no valor de R$ 4950,00 (R$ 1450,00 + R$ 3500,00)</p>\n<p>&nbsp;</p>\n<p>-&gt; Valor de anuidade (pagamento 16/08/2022) quitado em troca de custos com advogado(a) do caso da Giovana.&nbsp;</p>\n<p>&nbsp;</p>'),
(19, 14, 6, '2021-07-21 00:00:00', 0, 90, '0000-00-00', 0, '<p>Desenvolvimento de layout de fluxograma para sistema GEA</p>'),
(20, 2, 6, '2021-07-27 00:00:00', 0, 70, '0000-00-00', 0, ''),
(21, 17, 3, '2021-08-17 00:00:00', 0, 350, '0000-00-00', 10, '<p>Si Pavimenta&ccedil;&otilde;es:</p>\n<p>Email G-mail:</p>\n<p>Login: sipavimentacoes@gmail.com</p>\n<p>Senha: sipavimentacoes2021</p>\n<p>Google Bussiness:</p>\n<p>Login: sipavimentacoes@gmail.com</p>\n<p>Senha: sipavimentacoes2021</p>\n<p>Instagram:</p>\n<p>Login: @sipavimentacoes</p>\n<p>Senha: sipavimantacoes2021</p>\n<p>Alterado senhas para: siPAV1@#</p>\n<p>-----------------------------</p>\n<p>Primeiro m&ecirc;s 08/2021 foi cobrado proporcional aos dias restantes, no total de R$ 270,00</p>'),
(22, 2, 5, '2021-08-25 00:00:00', 0, 400, '0000-00-00', 0, '<p>Nota Fiscal foi emitida junto com o servi&ccedil;o de Gest&atilde;o de Redes Sociais Ref. 09/2021 no total de R$ 630,00, sendo R$ 300,00 da Gest&atilde;o de Redes Sociais e R$ 330,00 da Logomarca e Identidade Visual;</p>\n<p>&nbsp;</p>\n<p>Pagamento efetuado em 13/09/2021 no total de R$ 630,00 (Gest&atilde;o de Redes Sociais 09/2021 + Logomarca)</p>'),
(23, 18, 9, '2021-08-31 00:00:00', 0, 350, '0000-00-00', 0, '<p>Feito pelo pagar.me</p>'),
(24, 19, 6, '2021-09-01 00:00:00', 0, 150, '0000-00-00', 0, '<p>Pacote de Design com 10 artes de modelo para a empresa de cons&oacute;rcios</p>\n<p>&nbsp;</p>\n<p>https://www.canva.com/design/DAEpdEQJgys/share/preview?token=d_uZfPZrB01R8b62EHdv8A&amp;role=EDITOR&amp;utm_content=DAEpdEQJgys&amp;utm_campaign=designshare&amp;utm_medium=link&amp;utm_source=sharebutton</p>\n<p>&nbsp;</p>\n<p><strong>Informa&ccedil;&otilde;es gerais:</strong></p>\n<p>Carla Patr&iacute;cia Antunes&nbsp;</p>\n<p>CPF 06229215926</p>\n<p>carla051018@hotmail.com&nbsp;</p>\n<p>Rua Horaide Prestes de Souza 62E Vila Real</p>'),
(25, 20, 3, '2021-09-28 00:00:00', 0, 350, '0000-00-00', 0, '<p>Gest&atilde;o de Redes Sociais no valor de R$350,00 + 2 an&uacute;ncios para Facebook e Instagram com or&ccedil;amento de R$50,00 cada</p>\n<p>Anuncio 1: 10/10 at&eacute; 17/10</p>\n<p>Anuncio 2: 24/10 at&eacute; 31/10</p>\n<p>-----------------------------------</p>\n<p><strong>Outras informa&ccedil;&otilde;es:</strong></p>\n<p>Igreja do Evangelho Quadrangular,&nbsp;Rua Augusta Muller Bohner 75 D,&nbsp;Bairro Passo dos fortes,&nbsp;CNPJ 62.955.505/0997-83</p>\n<p>Instagram: ieq_engenhobraun | Senha: engenhobraunieq</p>\n<p>&nbsp;</p>'),
(26, 21, 3, '2021-09-30 00:00:00', 0, 350, '0000-00-00', 10, '<p>R$ 140,00 em dinheiro + R$ 210,00 em pizzas ou calzones</p>\n<p>----------------------------------------------</p>\n<p>Instagram Login: pizzariaroma.cco | Senha: Proma7213;</p>\n<p>Hor&aacute;rio de atendimento: 18:30 as 23:00</p>\n<p>&nbsp;</p>\n<p>----------------------------------------------</p>\n<p>Datas Comemorativas:</p>\n<p>&nbsp;</p>\n<p>-&gt; 14/08 Dia dos pais</p>\n<p>-&gt; 07/09 Dia da Independ&ecirc;ncia do Brasil</p>\n<p>-&gt; 15/09 Dia do Cliente</p>\n<p>-&gt; 22/09 In&iacute;cio da Primavera</p>\n<p>-&gt; 12/10 Dia das Crian&ccedil;as</p>\n<p>-&gt; 31/10 Dia das Bruxas - Halloween</p>\n<p>-&gt; 15/11 Proclama&ccedil;&atilde;o da Rep&uacute;blica</p>\n<p>-&gt; 25/11 Black Friday</p>\n<p>-&gt; 25/12 Natal</p>'),
(27, 22, 10, '2021-09-30 00:00:00', 0, 800, '0000-00-00', 0, '<p>leruty.com</p>\n<p>&nbsp;</p>\n<p>nuvemshop: adm@leruty.com Senha: rutyeli753</p>'),
(28, 25, 5, '2021-10-16 00:00:00', 0, 400, '0000-00-00', 0, '<p>Logomarca&nbsp;</p>'),
(29, 26, 5, '2021-10-20 00:00:00', 0, 470, '0000-00-00', 0, '<p>Logo desenvolvida para Leme Servi&ccedil;os em nome de Jonas dos Santos</p>\n<p>&nbsp;</p>\n<p>Link dos arquivos:&nbsp;<a style=\"color: #1155cc; font-family: Arial, Helvetica, sans-serif; font-size: small;\" href=\"https://drive.google.com/drive/folders/1TeRyjBJs_7OhQIJcYfxU-xd3EuKSwC5p?usp=sharing\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https://www.google.com/url?q=https://drive.google.com/drive/folders/1TeRyjBJs_7OhQIJcYfxU-xd3EuKSwC5p?usp%3Dsharing&amp;source=gmail&amp;ust=1636741036015000&amp;usg=AOvVaw3sUvYCcP3Eyr8EOg7XeWKV\">https://drive.google.com/<wbr />drive/folders/1TeRyjBJs_<wbr />7OhQIJcYfxU-xd3EuKSwC5p?usp=<wbr />sharing</a></p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>'),
(30, 27, 5, '2021-11-01 00:00:00', 0, 750, '0000-00-00', 0, '<p>2x de R$ 375,00</p>\n<p>&nbsp;</p>\n<p>Link de arquivos:&nbsp;<a style=\"color: #1155cc; font-family: Arial, Helvetica, sans-serif; font-size: small;\" href=\"https://drive.google.com/drive/folders/1DKeuc6DMMRsiPeF-GUKHygm_25JFYgyX?usp=sharing\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https://www.google.com/url?q=https://drive.google.com/drive/folders/1DKeuc6DMMRsiPeF-GUKHygm_25JFYgyX?usp%3Dsharing&amp;source=gmail&amp;ust=1636913466828000&amp;usg=AOvVaw1brPDxljmES-1gPQ2Gh5yc\">https://drive.google.com/<wbr />drive/folders/<wbr />1DKeuc6DMMRsiPeF-GUKHygm_<wbr />25JFYgyX?usp=sharing</a></p>\n<div class=\"yj6qo ajU\" style=\"cursor: pointer; outline: none; padding: 10px 0px; width: 22px; margin: 2px 0px 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">&nbsp;</div>'),
(31, 27, 1, '2021-11-17 00:00:00', 0, 1400, '0000-00-00', 0, '<p>Login: GBDSA400</p>\n<p>Senha: irisrh@123</p>\n<p>&nbsp;</p>\n<p>BravuHost</p>\n<p>&nbsp;</p>\n<p>Login: gabriel.batistadosantos@gmail.com</p>\n<p>Senha: irisrh@123</p>'),
(32, 28, 5, '2021-11-22 00:00:00', 0, 370, '0000-00-00', 0, '<p>NOTA FISCAL e pagamentos anexados no servi&ccedil;o de WEBSITE. Acesse \"Minhas compras\" e acesse o servi&ccedil;o de Website</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>Cores:</p>\n<p>Azul (RGBA): #0e0c29ff -&gt; #364272ff</p>\n<p>Amarelo (RGBA): #a87d00ff -&gt; #f0c402ff</p>\n<p>&nbsp;</p>\n<p>Cores de fundo:</p>\n<p>Azul (RGBA): #181b3eff</p>\n<p>Amarelo (RGBA): #c39801ff</p>'),
(33, 28, 3, '2021-11-22 00:00:00', 0, 350, '0000-00-00', 0, '<p>R$200,00 no primeiro m&ecirc;s e R$350,00 nos pr&oacute;ximos meses</p>\n<p>&nbsp;</p>\n<p>Nova senha Instagram: ADarq2022</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>'),
(34, 28, 1, '2021-11-22 00:00:00', 0, 1100, '0000-00-00', 0, '<p>DEISI CARBONERA LEIDENS, residente na cidade de Chapec&oacute;, RUA</p>\n<p>CASEMIRO SOBIERAY, 325. Bairro Para&iacute;so inscrita no CPF 007.678.209-32.</p>\n<p>&nbsp;</p>\n<p>NOTA FISCAL anexada no valor de 735,00 inclui LOGOMARCA e WEBSITE</p>\n<p>&nbsp;</p>\n<p>------------------------------------------------------------</p>\n<p>Refer&ecirc;ncias: Glicerio, Georgia gamborgi,&nbsp;</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>BD:<br />Link de acesso: <a href=\"https://mailtrack.io/trace/link/92ca0099286af052f86a6c7c483bbc0b7ab62d5c?url=https%3A%2F%2Fphpmyadmin.locaweb.com.br&amp;userId=7238955&amp;signature=565bfb8aa7a08ff8\">https://phpmyadmin.locaweb.com.br</a><br />Host: <a href=\"http://adarquitetura1.mysql.dbaas.com.br/\">adarquitetura1.mysql.dbaas.com.br</a><br />User: adarquitetura1<br />Pass: uP#m#B#kJ1TrtP<br /><br /><br />FTP<br />Host: <a href=\"http://ftp.adarquiteturacco.hospedagemdesites.ws/\">ftp.adarquiteturacco.hospedagemdesites.ws</a><br />User: adarquiteturacco<br />Pass: R#Tr#l@rYbrTw1</p>\n<p>&nbsp;</p>\n<p>Host: adarquitetura1.mysql.dbaas.com.br</p>\n<p>User: adarquitetura1</p>\n<p>Pass: uP#m#B#kJ1TrtP</p>'),
(35, 28, 11, '2021-11-22 00:00:00', 0, 79.9, '0000-00-00', 0, '<p><span style=\"color: #333333; font-family: verdana, sans-serif;\">BD</span>:<br />Link de acesso:&nbsp;<a href=\"https://mailtrack.io/trace/link/92ca0099286af052f86a6c7c483bbc0b7ab62d5c?url=https%3A%2F%2Fphpmyadmin.locaweb.com.br&amp;userId=7238955&amp;signature=565bfb8aa7a08ff8\" target=\"_blank\" rel=\"noopener noreferrer\">https://phpmyadmin.locaweb.com.br</a><br />Host:&nbsp;<a href=\"http://adarquitetura1.mysql.dbaas.com.br/\" target=\"_blank\" rel=\"noopener noreferrer\">adarquitetura1.mysql.dbaas.com.br</a><br />User: adarquitetura1<br />Pass: uP#m#B#kJ1TrtP<br /><br /><br />FTP<br />Host:&nbsp;<a href=\"http://ftp.adarquiteturacco.hospedagemdesites.ws/\" target=\"_blank\" rel=\"noopener noreferrer\">ftp.adarquiteturacco.hospedagemdesites.ws</a></p>\n<p><span style=\"color: #333333; font-family: verdana, sans-serif;\">User: adarquiteturacco</span></p>\n<div style=\"margin: 0px; padding: 0px; box-sizing: border-box; outline: none; display: block; unicode-bidi: embed; color: #333333; font-family: open-sans, Arial, Helvetica, Tahoma, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">\n<div class=\"x_gmail_signature\" dir=\"ltr\" style=\"margin: 0px; padding: 0px; box-sizing: border-box; outline: none; display: block; unicode-bidi: embed; direction: ltr;\">\n<div dir=\"ltr\" style=\"margin: 0px; padding: 0px; box-sizing: border-box; outline: none; display: block; unicode-bidi: embed; direction: ltr;\">&nbsp;</div>\n</div>\n</div>\n<div class=\"x_gmail_default\" style=\"margin: 0px; padding: 0px; box-sizing: border-box; outline: none; display: block; unicode-bidi: embed; color: #333333; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; font-family: verdana, sans-serif;\">Pass: R#Tr#l@rYbrTw1</div>'),
(36, 29, 5, '2021-11-25 00:00:00', 0, 750, '0000-00-00', 0, '<p>NOTAS FISCAIS e PAGAMENTOS anexados na compra do servi&ccedil;o de WEBSITE.</p>\n<p>Acesse em \"Minhas Compras\" no servi&ccedil;o de Website</p>'),
(37, 29, 1, '2021-11-25 00:00:00', 0, 3600, '0000-00-00', 0, '<p>Nota fiscal (25/11/2021) anexada de LOGOTIPO + Website no total de R$ 2175,00</p>\n<p>-----------------------------------------------------------------</p>\n<p>Pra administrar o site:&nbsp;</p>\n<p>http://curaespiritualchapeco.com.br/adm</p>\n<p>Login: ivacir</p>\n<p>Senha: ivacir@#$123</p>\n<p>-----------------------------------------------------------------</p>'),
(38, 29, 11, '2021-11-25 00:00:00', 1, 89.9, '0000-00-00', 0, '<p>R$ 89,90 mensais ou R$ 950,00 anual&nbsp;</p>\n<p>Op&ccedil;&atilde;o escolhida: R$ 89,90 mensais (a partir de fev 2022)</p>\n<p>&nbsp;</p>\n<p>CPF: 024.391.389-32</p>'),
(39, 30, 12, '2021-12-29 00:00:00', 1, 299.7, '0000-00-00', 0, ''),
(40, 31, 1, '2022-02-25 00:00:00', 0, 800, '0000-00-00', 15, ''),
(41, 32, 1, '2022-03-02 00:00:00', 0, 2200, '0000-00-00', 0, '<p>R$2200,00 em 2x sendo uma entrada no dia 02/03/2022 e outra no dia xx/xx/2022</p>\n<p>&nbsp;</p>\n<p>studiopiki@gmail.com</p>\n<p>&nbsp;</p>\n<p>/adm -&gt; Login:admin | Senha: piki@123#</p>\n<p>Registro.br -&gt; Login: pikistudio.com.br | Senha: wiktid-5doxSa-xyftuw</p>\n<p>&nbsp;</p>\n<p>nome: dorli (piki)</p>\n<p>Nome da empresa: piki</p>\n<p>instagram empresa: piki.studio</p>\n<p>&nbsp;</p>\n<p>REFERENCIA: appbarber - djoi</p>\n<p>✓ cadastro de nome, sobrenome, telefone</p>\n<p>✓ cancelamento at&eacute; 5hrs de antecedencia</p>\n<p>✓ cadastro de servi&ccedil;os e qtd de tempo por servi&ccedil;o</p>\n<p>✓ o app verifica onde tem hor&aacute;rios na soma dos servi&ccedil;os</p>\n<p>✓ Fluxo de caixa (caixa di&aacute;rio e semanal) mais n&uacute;meros finais, menos gr&aacute;ficos&nbsp;</p>\n<p>✓ ADM - N&atilde;o est&aacute; editando os pre&ccedil;os dos servi&ccedil;os</p>\n<p>✓ Hor&aacute;rios de atendimento:</p>\n<p>✓ Mostrar valor total na confirma&ccedil;&atilde;o de agendamento</p>\n<p>✓ Mostrar valor de cada servi&ccedil;o no novo agendamento</p>\n<p>✓ Tirar os hor&aacute;rios cinza</p>\n<p>✓ Puxar os hor&aacute;rios de 15 em 15 minutos</p>\n<p>&nbsp;</p>\n<p>✓ Adicionar servi&ccedil;os em Pr&oacute;ximos agendados</p>\n<p>✓ Ajustar layout servi&ccedil;os na home do site</p>\n<p>&nbsp;</p>\n<p>EMAILs:</p>\n<p>✓ Novo Cadastro de usu&aacute;rio</p>\n<p>✓ Esqueci minha senha</p>\n<p>✓ Pikistudio recebe email todo novo agendamento</p>\n<p>✓ 3 em 3 dias email lembrando horario agendado</p>\n<p>✓ 1 dia antes email lembrando</p>\n<p>✓ 12 horas email ()</p>'),
(42, 32, 11, '2022-04-10 00:00:00', 1, 89.9, '0000-00-00', 10, '<p>R$ 89,90 mensal ou R$899,00 anual</p>\n<p>Optado por ...</p>\n<p>&nbsp;</p>\n<p>cpf:&nbsp; 077.822.449-00</p>\n<p>Registro.br -&gt; Login: pikistudio.com.br | Senha: wiktid-5doxSa-xyftuw</p>'),
(43, 33, 10, '2022-03-23 00:00:00', 0, 800, '0000-00-00', 0, '<p>Email: micaprobassers@gmail.com | Senha: mkpb@123</p>\n<p>&nbsp;</p>\n<p>https://www.canva.com/design/DAE71VDlui8/36N-5fTTaQoupNL92HDBBg/edit?utm_content=DAE71VDlui8&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton</p>\n<p>&nbsp;</p>\n<p>&lt;meta name=\"facebook-domain-verification\" content=\"hdsp6v7sum7f246wchs8eso21jhzkz\" /&gt;</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>C&Ograve;DIGOS FACEBOOK LOGIN:</p>\n<p>CODE #1 0202 0294</p>\n<p>CODE #2 0354 6645</p>\n<p>CODE #3 1272 3404</p>\n<p>CODE #4 2792 5498</p>\n<p>CODE #5 3964 9024</p>\n<p>CODE #6 4908 7644</p>\n<p>CODE #7 4917 1610</p>\n<p>CODE #8 5915 6122</p>\n<p>CODE #9 7970 7207</p>\n<p>CODE #10 8241 2556</p>'),
(44, 34, 10, '2022-04-06 00:00:00', 0, 1600, '0000-00-00', 0, '<p>Email Gmail: barakidsloja@gmail.com | Senha:&nbsp;Barakids2022*@</p>\n<p>Nuvemshop: barakidsloja@gmail.com | Senha:&nbsp;Barakids2022*@</p>\n<p>Hostgator: barakids@outlook.com | Senha:&nbsp;Jeovana0*@</p>\n<p>https://barakids.com.br/</p>\n<p>https://www.canva.com/design/DAE-1kpldOY/jnCOngjb-5zDb_hfVlQUmw/edit?utm_content=DAE-1kpldOY&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton</p>\n<p>https://www.canva.com/design/DAE-weJl47s/ID0t5O9FxFR458biHYN7dA/edit?utm_content=DAE-weJl47s&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton</p>'),
(45, 35, 3, '2022-04-20 00:00:00', 0, 1200, '0000-00-00', 0, '<p><span id=\"docs-internal-guid-9539140d-7fff-25d4-06fc-34aced11dcdc\"><span style=\"font-size: 12pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">CNPJ: 79.312.054/0001-42</span></span></p>\n<p>Senha: @marcon@</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>------------------------------------------------------</p>\n<p>Datas Comemorativas:</p>\n<p>-&gt; 14/08 Dia dos pais</p>\n<p>-&gt; 07/09 Dia da Independ&ecirc;ncia do Brasil</p>\n<p>-&gt; 15/09 Dia do Cliente</p>\n<p>-&gt; 16/09 Dia do Caminhoneiro</p>\n<p>-&gt; 17/09 Dia Nacional do Transportador Rodovi&aacute;rio de Carga</p>\n<p>-&gt; 22/09 In&iacute;cio da Primavera</p>\n<p>-&gt; 12/10 Nossa Senhora Aparecida</p>\n<p>-&gt; 31/10 Dia das Bruxas - Halloween</p>\n<p>-&gt; 15/11 Proclama&ccedil;&atilde;o da Rep&uacute;blica</p>\n<p>-&gt; 25/11 Black Friday</p>\n<p>-&gt; 25/12 Natal</p>'),
(46, 36, 3, '2022-04-21 00:00:00', 0, 1600, '0000-00-00', 0, '<p>(ESTAT&Iacute;STICAS) https://docs.google.com/spreadsheets/d/1IeMxVtKXdsOyL_UGKD36oPm28XL1FXCHkf4qQ7PsUL4/edit?usp=sharing</p>\n<p>(ESTRAT&Eacute;GICO) https://docs.google.com/document/d/1em2n_KAXwGkhaT5LvYHdvxiwFhnKexQ-c6sSCeRLfA0/edit?usp=sharing</p>\n<p>&nbsp;</p>\n<p><span style=\"font-size: 11.5pt; line-height: 115%; font-family: \'Segoe UI\',\'sans-serif\'; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; color: #201f1e; mso-ansi-language: PT-BR; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;\">- Login Instagram: @studioodontofacial<br />- Senha instagram: studio2021</span></p>\n<p><span style=\"font-size: 11.5pt; line-height: 115%; font-family: \'Segoe UI\',\'sans-serif\'; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; color: #201f1e; mso-ansi-language: PT-BR; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;\"><span style=\"font-size: 15.3333px;\">- Nova Senha instagram: Studiolazio2021</span></span></p>\n<p>&nbsp;</p>\n<p>Rodrigo Cenci - CROSC 7122</p>\n<p>Mauren Depr&aacute; Pretto - CROSC 11926</p>\n<p>Jos&eacute; Luiz Pretto - CROSC 6357</p>\n<p>Maria Luiza - CROSC 7131</p>\n<p><span style=\"color: #201f1e; font-family: \'Segoe UI\', \'sans-serif\'; font-size: 15.3333px;\">---------------------------------</span><span style=\"color: #201f1e; font-family: \'Segoe UI\', \'sans-serif\'; font-size: 15.3333px;\">---------------------------------</span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">Datas comemorativas:</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 05/08 Dia Nacional da Sa&uacute;de</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 14/08 Dia dos pais</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 07/09 Dia da Independ&ecirc;ncia do Brasil</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 15/09 Dia do Cliente</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 22/09 In&iacute;cio da Primavera</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 01/10 Dia Nacional do Idoso</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 03/10 Dia Mundial do Dentista</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 07/10 Dia Mundial do Sorriso</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 12/10 Dia das Crian&ccedil;as</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 25/10 Dia do Dentista</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 25/10 Dia Nacional da Sa&uacute;de Bucal</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 31/10 Dia das Bruxas - Halloween</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 15/11 Proclama&ccedil;&atilde;o da Rep&uacute;blica</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 25/11 Dia Nacional do Doador de Sangue</span></span></p>\n<p><span style=\"color: #201f1e; font-family: Segoe UI, sans-serif;\"><span style=\"font-size: 15.3333px;\">-&gt; 25/12 Natal</span></span></p>'),
(47, 37, 10, '2022-05-02 00:00:00', 0, 1600, '0000-00-00', 0, '<p>https://www.nuvemshop.com.br/login</p>\n<p>Usu&aacute;rio: dolloutwear.ester@gmail.com</p>\n<p>Senha: E62724674@</p>\n<p>&nbsp;</p>\n<p>LINKS CANVA:</p>\n<p>(BANNERS ROTATIVOS) https://www.canva.com/design/DAFBzYAHG9I/kPSAMVaYLQRQV5vnghFi8w/edit?utm_content=DAFBzYAHG9I&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton</p>\n<p>(BANNERS CATEGORIA) https://www.canva.com/design/DAFBzaBHoes/e8bW-AeE5MzCFXhWit39Uw/edit?utm_content=DAFBzaBHoes&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton</p>\n<p>(PRODUTOS) https://www.canva.com/design/DAFBAB1ob1U/aybQsC39KVDBxyvHtOetYQ/edit?utm_content=DAFBAB1ob1U&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton</p>'),
(48, 38, 5, '2022-05-10 00:00:00', 0, 750, '0000-00-00', 0, '<p>https://drive.google.com/drive/folders/1t6PMg3y0X0If-vNEh88v49HijsJbL9Pz?usp=sharing</p>'),
(49, 39, 1, '2022-05-27 00:00:00', 0, 1200, '0000-00-00', 0, '<p>Site Facesc</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>mysql</p>\n<p>link: http://ip-45-79-51-225.cloudezapp.io/phpmyadmin/</p>\n<p>User: clinica_lp</p>\n<p>Senha: P7m^!djYiiaq9@</p>\n<p>&nbsp;</p>\n<p>sFTP: ip-45-79-51-225.cloudezapp.io</p>\n<p>Usuario: clinica</p>\n<p>Senha: z67N@BN1#sKg%uI@Q8Q</p>'),
(50, 28, 3, '2022-06-01 00:00:00', 1, 350, '0000-00-00', 0, '<p>Nova senha Instagram: ADarq2022</p>\n<p>&nbsp;</p>\n<p>CPF: 007.678.209-32&nbsp;&nbsp;</p>\n<p>&nbsp;</p>\n<p>-------------------------------------------------------------</p>\n<p>Datas Comemorativas:</p>\n<p>-&gt; 14/08 Dia dos pais</p>\n<p>-&gt; 15/09 Dia do Cliente</p>\n<p>-&gt; 12/10 Dia das Crian&ccedil;as</p>\n<p>- 15/11 Proclama&ccedil;&atilde;o da Rep&uacute;blica</p>\n<p>-&gt; 15/12 Dia do Arquiteto</p>\n<p>-&gt; 25/12 Natal</p>'),
(51, 28, 11, '2022-06-15 00:00:00', 0, 300, '0000-00-00', 0, '<p>Cadastro de informa&ccedil;&otilde;es no website</p>\n<p>CPF 007.678.209-32</p>'),
(52, 26, 1, '2022-06-20 00:00:00', 1, 800, '0000-00-00', 0, ''),
(53, 26, 11, '2022-06-28 00:00:00', 1, 89.9, '0000-00-00', 5, '<p>Anual: R$899,00 ou Mensal: R$89,90</p>'),
(54, 36, 13, '2022-06-28 00:00:00', 1, 1500, '0000-00-00', 0, '<p>Desconto de pontualidade v&aacute;lido para pagamentos no dia 1&ordm; de cada m&ecirc;s.</p>'),
(55, 39, 1, '2022-06-28 00:00:00', 0, 0, '0000-00-00', 0, '<p>Website Dotone</p>\n<p>&nbsp;</p>\n<p>Usu&aacute;rio: dotoneitcp</p>\n<p>Senha: D0ToN3-!t@2022</p>\n<p>Servidor FTP: ftp.dotone.it</p>\n<p>IP/Host de acesso: cpanel06-idc.redeunifique.com.br:2083 ou 189.45.192.59</p>\n<p>Porta: 21</p>'),
(56, 40, 1, '2022-07-08 00:00:00', 0, 800, '0000-00-00', 0, '<p><strong>HOSTINGER</strong></p>\n<p>murifon001@gmail.com</p>\n<p>@jumuIR2021</p>\n<p>------------------</p>'),
(58, 42, 13, '2022-07-28 00:00:00', 1, 975, '0000-00-00', 10, '<p>Cliente Rescindiu.</p>'),
(59, 42, 14, '2022-07-28 00:00:00', 1, 975, '0000-00-00', 10, '<p>Ciente Rescindiu.</p>'),
(60, 42, 3, '2022-07-28 00:00:00', 1, 350, '0000-00-00', 0, '<div>\n<div>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: Trebuchet MS, sans-serif;\">&nbsp;Cliente Rescindiu.&nbsp;</span></p>\n</div>\n<div>&nbsp;</div>\n</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>\n<div>Senha Instagram: pedro2021</div>'),
(61, 43, 13, '2022-07-29 00:00:00', 1, 975, '0000-00-00', 1, '<div>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">O seu&nbsp;Pacote&nbsp;de&nbsp;Servi&ccedil;os&nbsp;Google Ads Pro foi renovado!&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Seguem anexos os boletos referentes &agrave;s Taxas&nbsp;de&nbsp;Gerenciamento Mensal&nbsp;de&nbsp;seu&nbsp;Pacote&nbsp;de&nbsp;Servi&ccedil;<wbr />os.</span></p>\n</div>'),
(62, 43, 14, '2022-07-29 00:00:00', 1, 975, '0000-00-00', 0, '<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">\n<div>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: Trebuchet MS, sans-serif;\">Rescis&atilde;o</span></p>\n</div>\n</div>'),
(63, 44, 1, '2022-08-02 00:00:00', 0, 200, '0000-00-00', 0, '<p>ftp.drax.com.br</p>\n<p>usu&aacute;rio: drax</p>\n<p>senha: cco@2022</p>\n<p>&nbsp;</p>\n<p>mysql.drax.com.br</p>\n<p>usu&aacute;rio: drax</p>\n<p>senha: mydraxsql2022</p>\n<p>&nbsp;</p>\n<p>Instagram: draxsports</p>\n<p>Senha: rmb6696123150</p>'),
(64, 45, 1, '2022-08-08 00:00:00', 0, 1350, '0000-00-00', 0, '<p>Pagamento em 2x</p>\n<p>1&ordf; em 08/08/2022</p>\n<p>2&ordf; em 19/09/2022</p>\n<p>&nbsp;</p>\n<p>E-mail: contato@advvivianayumi.com.br | Senha: Sc65075a@@@</p>\n<div>&nbsp;</div>\n<div><a style=\"color: #1155cc;\" href=\"https://cliente.hostgator.com.br/sites\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https://www.google.com/url?q=https://cliente.hostgator.com.br/sites&amp;source=gmail&amp;ust=1663690072542000&amp;usg=AOvVaw32fOSjU6OXRJUBt8R2b7hS\">https://cliente.hostgator.com.<wbr />br/sites</a></div>\n<div><a style=\"color: #1155cc;\" href=\"mailto:vivian_ayumi@hotmail.com\" target=\"_blank\" rel=\"noopener\">vivian_ayumi@hotmail.com</a></div>\n<div>Sc65075a@@@</div>\n<div>&nbsp;</div>\n<div><a style=\"color: #1155cc;\" href=\"https://drive.google.com/drive/folders/1AUhHDU6qkOC0XtfFO9lIiG0uOQpT1xgi?usp=sharing\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https://www.google.com/url?q=https://drive.google.com/drive/folders/1AUhHDU6qkOC0XtfFO9lIiG0uOQpT1xgi?usp%3Dsharing&amp;source=gmail&amp;ust=1663690072542000&amp;usg=AOvVaw2RmXxjN7ycBlk3OX7IxBIs\">https://drive.google.com/<wbr />drive/folders/<wbr />1AUhHDU6qkOC0XtfFO9lIiG0uOQpT1<wbr />xgi?usp=sharing</a>&nbsp;</div>\n<div>&nbsp;</div>'),
(65, 46, 13, '2022-08-16 00:00:00', 0, 975, '0000-00-00', 1, ''),
(66, 14, 7, '2022-08-17 00:00:00', 0, 120, '0000-00-00', 0, ''),
(67, 47, 14, '2022-09-01 00:00:00', 1, 975, '0000-00-00', 0, '<p>SOLICITADO RESCIS&Atilde;O - N&Atilde;O PAGO</p>\n<p><strong>BOLETOS EM PROTESTO - </strong>BOLETOS ABAIXO N&Atilde;O S&Atilde;O V&Aacute;LIDOS PARA PAGAMENTO</p>'),
(68, 48, 1, '2022-09-19 00:00:00', 0, 3200, '0000-00-00', 0, ''),
(69, 49, 11, '2022-09-28 00:00:00', 0, 50, '0000-00-00', 0, ''),
(71, 50, 11, '2022-09-29 00:00:00', 0, 350, '0000-00-00', 0, ''),
(72, 51, 10, '2022-10-04 00:00:00', 0, 1800, '0000-00-00', 0, ''),
(73, 52, 4, '2022-10-06 00:00:00', 0, 11700, '0000-00-00', 0, '<p>https://www.sys.sisjuridico.com.br/pasta/2022-10-02.zip</p>\n<p>Login: smadvogados</p>\n<p>Senha: uKQ3A16646433</p>\n<p>======================</p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\"><strong>FTP<u></u><u></u></strong></p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\"><a>salvadormaifrede.com.br.<wbr />servicos.ws</a><br />Usu&aacute;rio FTP: salvadormaifrede1<u></u><u></u></p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">Senha: Sm123456789101112!<u></u><u></u></p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\"><u></u>&nbsp;<u></u></p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">Servidor Locaweb</p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">Login: smadvocacia</p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">Senha: Advocacia2020</p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">&nbsp;</p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\"><strong>Banco de Dados<u></u><u></u></strong></p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">Nome: SMAIFREDE<u></u><u></u></p>\n<p class=\"MsoNormal\" style=\"margin: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">Senha: Sm12345!</p>\n<p>======================</p>\n<p>&nbsp;</p>'),
(74, 53, 13, '2022-10-24 00:00:00', 1, 975, '0000-00-00', 0, '<p><strong>RENEGOCIADO</strong></p>\n<p>&nbsp;</p>\n<p><strong>m&ecirc;s 02\\2024 sistema nao cadastra. mas foi enviado boleto pra pagarem.&nbsp;</strong></p>'),
(75, 49, 7, '2022-10-27 00:00:00', 0, 50, '0000-00-00', 0, ''),
(76, 43, 15, '2022-11-04 00:00:00', 1, 3200, '0000-00-00', 0, '<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">Parab&eacute;ns pela contrata&ccedil;&atilde;o&nbsp;<span class=\"gmail-il\">de</span>&nbsp;seu&nbsp;<span class=\"gmail-il\">Pacote</span>&nbsp;<span class=\"gmail-il\">de</span>&nbsp;<span class=\"gmail-il\">Servi&ccedil;os</span>&nbsp;Youtube Ads Pro!&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">Seguem anexos os boletos referentes &agrave;s Taxas&nbsp;<span class=\"gmail-il\">de</span>&nbsp;Gerenciamento Mensal&nbsp;<span class=\"gmail-il\">de</span>&nbsp;seu&nbsp;<span class=\"gmail-il\">Pacote</span>&nbsp;<span class=\"gmail-il\">de</span>&nbsp;<span class=\"gmail-il\">Servi&ccedil;os</span>.</span></p>\n</div>\n<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">&nbsp;</div>\n<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><strong><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">IMPORTANTE:</span></strong></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">1. O&nbsp;<strong>desconto&nbsp;<span class=\"gmail-il\">de</span>&nbsp;20%&nbsp;</strong>concedido&nbsp;<span class=\"gmail-il\">em</span>&nbsp;seu&nbsp;<span class=\"gmail-il\">pacote</span>&nbsp;est&aacute; na descri&ccedil;&atilde;o&nbsp;<span class=\"gmail-il\">de</span>&nbsp;cada&nbsp;boleto&nbsp;<span class=\"gmail-il\">dos</span>&nbsp;<span class=\"gmail-il\">servi&ccedil;os</span>&nbsp;especializados&nbsp;<span class=\"gmail-il\">de</span>&nbsp;acordo&nbsp;<span class=\"gmail-il\">com</span>&nbsp;a pontualidade&nbsp;<span class=\"gmail-il\">de</span>&nbsp;pagamento (Todo dia 1&ordm;), conforme o Contrato&nbsp;<span class=\"gmail-il\">de</span>&nbsp;Presta&ccedil;&atilde;o&nbsp;<span class=\"gmail-il\">de</span>&nbsp;<span class=\"gmail-il\">Servi&ccedil;os</span>.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">2. Pedimos que esteja atento quanto &agrave; modalidade DDA&nbsp;<span class=\"gmail-il\">de</span>&nbsp;pagamentos disponibilizada por alguns bancos. Nossos&nbsp;boletos&nbsp;devem ser pagos atrav&eacute;s&nbsp;<span class=\"gmail-il\">de</span>&nbsp;agendamento manual&nbsp;<strong>para evitar a perda do desconto&nbsp;<span class=\"gmail-il\">de</span> pontualidade.</strong></span></p>\n</div>'),
(77, 54, 14, '2022-11-16 00:00:00', 1, 975, '0000-00-00', 0, ''),
(78, 55, 13, '2022-11-16 00:00:00', 1, 975, '0000-00-00', 0, '<p>48.833.924/0001-03 novo CNPJ</p>\n<p>&nbsp;</p>\n<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\"><strong style=\"font-family: Calibri, \'sans-serif\'; font-size: 16px;\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-origin: initial; background-clip: initial;\">Ol&aacute; Edhy!</span></strong></div>\n<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">Seguem em&nbsp;<strong>anexos&nbsp;</strong>os&nbsp;boletos&nbsp;<wbr />referentes &agrave;s Taxas de Gerenciamento Mensal de seu Pacote de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"color: black; font-family: \'Trebuchet MS\', \'sans-serif\'; font-size: 12pt;\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"color: black; font-family: \'Trebuchet MS\', \'sans-serif\'; font-size: 12pt;\">Voc&ecirc; pode acessar os&nbsp;boletos tamb&eacute;m pelos links abaixo:</span></p>\n</div>\n<p>(02/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_2162ae064603d83426a9ffbb53b80e031675731244.pdf</p>\n<p>(03/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_3ad0f1255f7024056ff26a26a41a01431675732116.pdf</p>\n<p>(04/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_616db6745ccc8c1f4ccdde247eafea811675732024.pdf</p>\n<p>(05/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_cb739e1ae3d8bfb9c65999f80680c7831675732031.pdf</p>\n<p>(06/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_d33d497262d76544236fc8817ff220bf1675732150.pdf</p>\n<p>(07/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_3206c1cdb7e1805831c1f2bb7f0061611675732123.pdf</p>\n<p>(08/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_f4e4adec026ad8cf6734db1146a57d781675732001.pdf</p>\n<p>(09/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_7a24875605b4186eb2fd6779079c336f1675732137.pdf</p>\n<p>(10/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_83959a8cf4cb1307acd995e4d943d3b21675732009.pdf</p>\n<p>(11/2023):&nbsp;http://cliente.insource.com.br/drive/cobrancaboleto_80424f4823428064d7792292ee2fd14f1675732014.pdf</p>\n<p>(12/2023): http://cliente.insource.com.br/drive/cobrancaboleto_02ce2d957f018e0d0e12515fb85108a91675732144.pdf</p>\n<p>&nbsp;</p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><strong><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Importante:</span></strong></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">1. O&nbsp;<strong>desconto de 35% </strong>concedido em seu pacote est&aacute; na descri&ccedil;&atilde;o de cada boleto dos servi&ccedil;os especializados de acordo com a pontualidade de pagamento (Todo dia 1&ordm;), conforme o Contrato de Presta&ccedil;&atilde;o de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">2. Pedimos que esteja atento quanto &agrave; modalidade DDA de pagamentos disponibilizada por alguns bancos. Nossos boletos devem ser pagos atrav&eacute;s de agendamento manual&nbsp;<strong>para evitar a perda do desconto de pontualidade.</strong></span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\"><strong>&nbsp;</strong></span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; color: #000000; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Atenciosamente,</span></p>\n<p>&nbsp;</p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">INSOURCE</span></p>');
INSERT INTO `servicoempresa` (`servicoempresaID`, `empresaID`, `servicoID`, `datacadastro`, `ativo`, `preco`, `datavencimento`, `diavencimento`, `descricao`) VALUES
(79, 35, 13, '2023-01-09 00:00:00', 1, 1200, '0000-00-00', 1, '<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">Parab&eacute;ns pela contrata&ccedil;&atilde;o de seu Pacote de Servi&ccedil;os&nbsp;Google Ads Pro!&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">Seguem anexos os boletos referentes &agrave;s Taxas de Gerenciamento Mensal de seu Pacote de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\">&nbsp;</p>\n</div>\n<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">&nbsp;</div>\n<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">IMPORTANTE:</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">1. O&nbsp;desconto de 20%&nbsp;concedido em seu pacote est&aacute; na descri&ccedil;&atilde;o de cada&nbsp;boleto&nbsp;dos servi&ccedil;os especializados de acordo com a pontualidade de pagamento (Todo dia 1&ordm;), conforme o Contrato de Presta&ccedil;&atilde;o de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\'; color: black;\">2. Pedimos que esteja atento quanto &agrave; modalidade DDA de pagamentos disponibilizada por alguns bancos. Nossos boletos devem ser pagos atrav&eacute;s de agendamento manual para evitar a perda do desconto de pontualidade.</span></p>\n</div>'),
(80, 57, 14, '2023-01-11 00:00:00', 0, 1200, '0000-00-00', 1, '<p>RENEGOCIADO</p>'),
(81, 57, 13, '2023-01-11 00:00:00', 0, 1200, '0000-00-00', 0, '<div style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;\">\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: Trebuchet MS, sans-serif;\">RENEGOCIADO</span></p>\n</div>'),
(82, 58, 13, '2023-01-24 00:00:00', 1, 1200, '0000-00-00', 10, '<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\">Enviar termo e acessos.</p>'),
(83, 59, 14, '2023-01-26 00:00:00', 1, 975, '0000-00-00', 0, '<p>cancelado contrato</p>'),
(84, 60, 14, '2023-01-30 00:00:00', 1, 1200, '0000-00-00', 0, '<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Parab&eacute;ns pela contrata&ccedil;&atilde;o de seu Pacote de Servi&ccedil;os&nbsp;Facebook Ads Pro!&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Seguem em&nbsp;<strong>anexos&nbsp;</strong>os boletos referentes &agrave;s Taxas de Gerenciamento Mensal de seu Pacote de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; color: #222222; font-size: 12pt; font-family: Calibri, \'sans-serif\';\">&nbsp;</p>\n<div>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><strong><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Importante:</span></strong></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">1. O&nbsp;<strong>desconto de 20%&nbsp;</strong>concedido em seu pacote est&aacute; na descri&ccedil;&atilde;o de cada boleto dos servi&ccedil;os especializados de acordo com a pontualidade de pagamento (Todo dia 1&ordm;), conforme o Contrato de Presta&ccedil;&atilde;o de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">2. Pedimos que esteja atento quanto &agrave; modalidade DDA de pagamentos disponibilizada por alguns bancos. Nossos boletos devem ser pagos atrav&eacute;s de agendamento manual&nbsp;<strong>para evitar a perda do desconto de pontualidade.</strong></span></p>\n</div>'),
(85, 60, 13, '2023-01-30 00:00:00', 1, 1200, '0000-00-00', 0, '<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Parab&eacute;ns pela contrata&ccedil;&atilde;o de seu Pacote de Servi&ccedil;os Google Ads Pro!&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Seguem em&nbsp;<strong>anexos&nbsp;</strong>os boletos referentes &agrave;s Taxas de Gerenciamento Mensal de seu Pacote de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\">&nbsp;</p>\n<div>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><strong><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Importante:</span></strong></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">1. O&nbsp;<strong>desconto de 20%&nbsp;</strong>concedido em seu pacote est&aacute; na descri&ccedil;&atilde;o de cada boleto dos servi&ccedil;os especializados de acordo com a pontualidade de pagamento (Todo dia 1&ordm;), conforme o Contrato de Presta&ccedil;&atilde;o de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">2. Pedimos que esteja atento quanto &agrave; modalidade DDA de pagamentos disponibilizada por alguns bancos. Nossos boletos devem ser pagos atrav&eacute;s de agendamento manual&nbsp;<strong>para evitar a perda do desconto de pontualidade.</strong></span></p>\n</div>'),
(86, 61, 1, '2021-02-04 00:00:00', 0, 2500, '0000-00-00', 0, '<p>http://portaletnias.ihgo.org.br/phpmyadmin/</p>\n<p>LOGIN: root</p>\n<p>SENHA PHPMYADMIN: IHGO2017etnias</p>\n<p>&nbsp;</p>\n<p>http://portaletnias.ihgo.org.br/adm</p>\n<p>Senha: Aron#2022</p>\n<p>&nbsp;</p>\n<p>PUTTY</p>\n<p>LOGIN: ihgo</p>\n<p>Senha: IHGO2017etnias</p>'),
(87, 62, 14, '2023-02-07 00:00:00', 0, 1200, '0000-00-00', 0, ''),
(88, 63, 13, '2023-03-10 00:00:00', 1, 1200, '0000-00-00', 0, '<p>CINCO BPO</p>'),
(89, 64, 14, '2023-05-16 00:00:00', 1, 1500, '0000-00-00', 0, '<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Parab&eacute;ns pela contrata&ccedil;&atilde;o de seu Pacote de Servi&ccedil;os&nbsp;Facebook Ads Pro!&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Seguem anexos os&nbsp;<span class=\"gmail-il\">boletos</span>&nbsp;referentes &agrave;s Taxas de Gerenciamento Mensal de seu Pacote de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<div>&nbsp;</div>\n<div>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><strong><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">IMPORTANTE:</span></strong></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">1. O&nbsp;<strong>desconto de 20%&nbsp;</strong>concedido em seu pacote est&aacute; na descri&ccedil;&atilde;o de cada&nbsp;<span class=\"gmail-il\">boleto</span>&nbsp;dos servi&ccedil;os especializados de acordo com a pontualidade de pagamento (Todo dia 1&ordm;), conforme o Contrato de Presta&ccedil;&atilde;o de Servi&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">2. Pedimos que esteja atento quanto &agrave; modalidade DDA de pagamentos disponibilizada por alguns bancos. Nossos&nbsp;<span class=\"gmail-il\">boletos</span>&nbsp;devem ser pagos atrav&eacute;s de agendamento manual&nbsp;<strong>para evitar a perda do desconto de pontualidade.</strong></span></p>\n</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>\n<div>&nbsp;</div>'),
(90, 66, 14, '2023-06-20 00:00:00', 1, 1200, '0000-00-00', 0, '<div>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">RENEGOCIADO ALGUMAS PARCELAS.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\">&nbsp;</p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">________________________________________________</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\">&nbsp;</p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Parab&eacute;ns pela contrata&ccedil;&atilde;o&nbsp;</span><span class=\"gmail-il\" style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">de</span><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;seu&nbsp;</span><span class=\"gmail-il\" style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Pacote</span><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span><span class=\"gmail-il\" style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">de</span><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span><span class=\"gmail-il\" style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Servi&ccedil;os</span><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\"> Facebook Ads Pro!&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">Seguem anexos os boletos referentes &agrave;s Taxas&nbsp;de&nbsp;Gerenciamento Mensal&nbsp;de&nbsp;seu&nbsp;Pacote&nbsp;de&nbsp;Servi&ccedil;<wbr />os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n</div>\n<div>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><strong><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">IMPORTANTE:</span></strong></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">1. O&nbsp;<strong>desconto de 20% </strong>concedido&nbsp;em<wbr />&nbsp;seu&nbsp;pacote&nbsp;est&aacute; na descri&ccedil;&atilde;o&nbsp;de&nbsp;cada&nbsp;boleto&nbsp;dos&nbsp;s<wbr />ervi&ccedil;os&nbsp;especializados&nbsp;de&nbsp;<wbr />acordo&nbsp;com&nbsp;a pontualidade&nbsp;de&nbsp;pagamento (Todo dia 1&ordm;), conforme o Contrato&nbsp;de&nbsp;Presta&ccedil;&atilde;o&nbsp;de&nbsp;Servi<wbr />&ccedil;os.</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">&nbsp;</span></p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, \'sans-serif\';\"><span style=\"font-family: \'Trebuchet MS\', \'sans-serif\';\">2. Pedimos que esteja atento quanto &agrave; modalidade DDA&nbsp;de&nbsp;pagamentos disponibilizada por alguns bancos. Nossos&nbsp;boletos&nbsp;devem ser pagos atrav&eacute;s&nbsp;de&nbsp;agendamento manual&nbsp;<strong>para evitar a perda do desconto de pontualidade.</strong></span></p>\n</div>'),
(91, 67, 13, '2023-07-18 00:00:00', 1, 1200, '0000-00-00', 0, ''),
(92, 57, 17, '2023-07-11 00:00:00', 1, 7620, '0000-00-00', 0, '<p>RENEGOCIA&Ccedil;&Atilde;O DE D&Iacute;VIDA</p>'),
(93, 68, 13, '2023-08-04 00:00:00', 1, 1200, '0000-00-00', 0, '<p dir=\"ltr\" style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">Bom dia,&nbsp;Sr. Anderson!</span></p>\n<p dir=\"ltr\" style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\">&nbsp;</p>\n<p dir=\"ltr\" style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">Parab&eacute;ns pela contrata&ccedil;&atilde;o de seu Pacote de Servi&ccedil;os&nbsp;Google&nbsp;Ads Pro!&nbsp;</span></p>\n<p dir=\"ltr\" style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">Seguem anexos os boletos referentes &agrave;s Taxas de Gerenciamento Mensal de seu Pacote de Servi&ccedil;os.</span></p>\n<p>&nbsp;</p>\n<p dir=\"ltr\" style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">Importante:</span></p>\n<p dir=\"ltr\" style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">1. O desconto de&nbsp;</span><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">20%&nbsp;</span><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">concedido em seu pacote est&aacute; na descri&ccedil;&atilde;o de cada boleto dos servi&ccedil;os especializados de acordo com a pontualidade de pagamento (Todo dia 1&ordm;), conforme o Contrato de Presta&ccedil;&atilde;o de Servi&ccedil;os.</span></p>\n<p>&nbsp;</p>\n<p dir=\"ltr\" style=\"color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">2. Pedimos que esteja atento quanto &agrave; modalidade DDA de pagamentos disponibilizada por alguns bancos. Nossos boletos devem ser pagos atrav&eacute;s de agendamento manual&nbsp;</span><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">para evitar a perda do desconto de pontualidade.&nbsp;</span></p>\n<p><span style=\"font-size: 12pt; font-family: \'Trebuchet MS\', sans-serif; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; vertical-align: baseline; white-space-collapse: preserve;\">&nbsp;</span></p>'),
(94, 69, 1, '2023-08-18 00:00:00', 1, 1600, '0000-00-00', 0, ''),
(95, 42, 18, '2023-08-24 00:00:00', 1, 1925, '0000-00-00', 0, '<p>Enviar acessos das contas (ver com Aron).</p>'),
(96, 70, 14, '2023-09-12 00:00:00', 1, 1200, '0000-00-00', 0, ''),
(97, 43, 6, '2023-11-07 00:00:00', 1, 2000, '0000-00-00', 0, '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `servicopagamento`
--

CREATE TABLE `servicopagamento` (
  `servicopagamentoID` int(11) NOT NULL,
  `servicoempresaID` int(11) NOT NULL,
  `formapagamentoID` int(11) NOT NULL,
  `datacadastro` datetime NOT NULL,
  `preco` double NOT NULL,
  `servicocobrancaID` int(11) NOT NULL,
  `linknf` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `servicopagamento`
--

INSERT INTO `servicopagamento` (`servicopagamentoID`, `servicoempresaID`, `formapagamentoID`, `datacadastro`, `preco`, `servicocobrancaID`, `linknf`) VALUES
(1, 5, 1, '2021-03-24 02:14:51', 0, 0, ''),
(2, 4, 3, '2021-01-01 08:00:00', 300, 0, ''),
(3, 4, 3, '2021-02-01 08:00:00', 300, 0, ''),
(4, 4, 3, '2021-03-01 08:00:00', 300, 0, ''),
(7, 7, 3, '2021-03-09 00:00:00', 1600, 0, ''),
(8, 8, 3, '2021-03-09 00:00:00', 500, 0, ''),
(9, 4, 3, '2021-04-05 00:00:00', 300, 0, 'nfcompra_3b9dfa14df96733cbc1f590809d3bcff1619827175.pdf'),
(11, 9, 4, '2021-04-20 00:00:00', 150, 0, ''),
(12, 6, 3, '2021-04-06 00:00:00', 300, 0, 'nfcompra_d802de8c9a939c0895f137378039c68a1620087583.pdf'),
(13, 6, 3, '2021-05-05 00:00:00', 300, 0, 'nfcompra_f6e00b1af23882b2a3bd8269085d46ea1620241283.pdf'),
(14, 10, 3, '2021-05-07 00:00:00', 450, 0, 'nfcompra_32015ad00013e440db36fcca886611f81620417518.pdf'),
(15, 4, 4, '2021-05-06 00:00:00', 300, 0, 'nfcompra_99efff6fd600ca310147dc354789df8a1620860328.pdf'),
(16, 14, 3, '2021-04-09 00:00:00', 180, 0, 'nfcompra_8fdbf6bce267e99c46291b830d1258df1621445365.pdf'),
(17, 12, 3, '2021-05-20 00:00:00', 550, 0, 'nfcompra_461ccffc6cea5274c618bab0c892419e1621540495.pdf'),
(18, 15, 3, '2021-06-03 00:00:00', 350, 0, 'nfcompra_0c441b22bfcc262cc86d0f91540719e61622738003.pdf'),
(19, 16, 3, '2021-06-03 00:00:00', 3500, 0, 'nfcompra_32d0e7b31e02daf07e55de91e55fce6f1622739425.pdf'),
(20, 6, 3, '2021-06-03 00:00:00', 300, 0, 'nfcompra_28cc9dc0a65b477837a204ffc5caaa581622739684.pdf'),
(21, 11, 4, '2021-06-10 00:00:00', 350, 0, 'nfcompra_4a58b5482bff9a9367c38080642323af1623683043.pdf'),
(22, 4, 3, '2021-06-09 00:00:00', 300, 0, 'nfcompra_fe68ce0137eceef6536783e8337d4e321623682888.pdf'),
(23, 13, 3, '2021-06-14 00:00:00', 350, 0, ''),
(24, 6, 3, '2021-07-05 00:00:00', 300, 0, 'nfcompra_2261982ec125fb857c3382fc7fbf1f211625849592.pdf'),
(25, 4, 3, '2021-07-06 00:00:00', 300, 0, 'nfcompra_a02a94752eeec3d0725690babbf0806c1625849772.pdf'),
(26, 13, 3, '2021-07-13 00:00:00', 350, 0, 'nfcompra_ccd6b163a5aeb7abc1d293b7c655ed4e1626225544.pdf'),
(28, 19, 3, '2021-07-19 00:00:00', 90, 0, 'nfcompra_349a479378bf6450895f970c1208b0ef1626905657.pdf'),
(29, 20, 3, '2021-07-27 00:00:00', 70, 0, 'nfcompra_4757a548f2a1b3644fa91d565e698d621627436466.pdf'),
(30, 6, 3, '2021-08-05 00:00:00', 300, 0, ''),
(31, 18, 3, '2021-08-06 00:00:00', 1450, 0, ''),
(32, 16, 3, '2021-08-06 00:00:00', 3500, 0, 'nfcompra_26a4d0299b0eeb0e15038699608b046a1628379588.pdf'),
(33, 4, 3, '2021-08-10 00:00:00', 370, 0, 'nfcompra_df8a94feb66fe388e8a28fe0889628a91628995736.pdf'),
(34, 13, 3, '2021-08-12 00:00:00', 350, 0, 'nfcompra_50a85705314c3107e6983097376af2911628994572.pdf'),
(35, 21, 1, '2021-08-17 00:00:00', 270, 0, ''),
(36, 23, 4, '2021-08-27 00:00:00', 350, 0, 'nfcompra_60de6c9936ab59b88f9b7a78c684f0a41630426743.pdf'),
(37, 6, 3, '2021-09-08 00:00:00', 300, 0, ''),
(38, 13, 3, '2021-08-14 00:00:00', 350, 0, 'nfcompra_2a68625f6ef99ca24dae359b5046d0731631718489.pdf'),
(39, 24, 3, '2021-09-08 00:00:00', 150, 0, 'nfcompra_0012e9069799b0ec82a3e3fe0b6e3a331631718892.pdf'),
(40, 22, 3, '2021-09-13 00:00:00', 330, 0, ''),
(41, 4, 3, '2021-09-13 00:00:00', 300, 0, 'nfcompra_bff7c21c12e3116e1277dee25cfacb561631720404.pdf'),
(42, 25, 4, '2021-10-06 00:00:00', 520, 0, 'nfcompra_6bcc284ec207a4254075a103e951876c1633653466.pdf'),
(43, 27, 3, '2021-10-16 00:00:00', 400, 0, 'nfcompra_7a2948bb50313c6e3008fbb532baa2791634431389.pdf'),
(44, 4, 3, '2021-10-15 00:00:00', 300, 0, ''),
(45, 6, 3, '2021-10-12 00:00:00', 300, 0, ''),
(46, 28, 1, '2021-10-20 00:00:00', 400, 0, ''),
(47, 13, 4, '2021-10-20 00:00:00', 350, 0, 'nfcompra_a439646891aaa9ea1682acf9006084491635456869.pdf'),
(48, 26, 3, '2021-10-19 00:00:00', 140, 0, ''),
(49, 26, 3, '2021-11-10 00:00:00', 140, 0, ''),
(50, 6, 3, '2021-11-03 00:00:00', 300, 0, ''),
(51, 4, 3, '2021-11-10 00:00:00', 300, 0, 'nfcompra_22ca1514a7eddd21a4287861e6cfa1b31637178779.pdf'),
(52, 29, 3, '2021-11-11 00:00:00', 235, 0, 'nfcompra_5a7d349ec451d9136fac880e002c00a81637177806.pdf'),
(54, 30, 5, '2021-11-01 00:00:00', 375, 0, 'nfcompra_e0e18f5e8cb1e1f271de3ba0dbe0c95b1637177294.pdf'),
(55, 27, 3, '2021-11-17 00:00:00', 400, 0, 'nfcompra_35a17d04925e2cc274ad0dcb057ab6b21637176847.pdf'),
(56, 30, 5, '2021-11-17 00:00:00', 375, 0, 'nfcompra_c8b48b46118d7021041d1dfe4c2caa731637177480.pdf'),
(57, 13, 3, '2021-11-23 00:00:00', 350, 0, 'nfcompra_42633620306b773e05e2fbdf4a964a051637869890.pdf'),
(58, 37, 3, '2021-11-25 00:00:00', 2175, 0, 'nfcompra_6d956f08029425a393deca7615bce2ac1637872545.pdf'),
(59, 34, 3, '2021-11-25 00:00:00', 735, 0, 'nfcompra_9f485b798139e31e473a4af8f6f0e20b1637873892.pdf'),
(60, 6, 3, '2021-12-06 00:00:00', 420, 0, ''),
(61, 4, 3, '2021-12-09 00:00:00', 420, 0, 'nfcompra_23811cd6eba14f0420e70c7aba4203361639167230.pdf'),
(62, 29, 3, '2021-12-09 00:00:00', 235, 0, 'nfcompra_033fc43ef4ccf0f46bb1d3584f38f8b21639167352.pdf'),
(63, 33, 3, '2021-12-08 00:00:00', 200, 0, 'nfcompra_d747997c6bd25331dac91c09510d612a1639167578.pdf'),
(64, 26, 3, '2021-12-14 00:00:00', 140, 0, ''),
(65, 13, 3, '2021-12-21 00:00:00', 350, 0, 'nfcompra_1fb7ca5162f438c13974f134cd861aa11640827722.pdf'),
(66, 39, 5, '2021-12-20 00:00:00', 299.7, 0, 'nfcompra_1a8202cd809be243c5936918c20d10351640827960.pdf'),
(67, 33, 3, '2022-01-10 00:00:00', 350, 0, 'nfcompra_9ff2b2cea21ce93e41a61a504c3570ab1643484559.pdf'),
(68, 6, 3, '2022-01-07 00:00:00', 420, 0, ''),
(69, 26, 3, '2022-01-10 00:00:00', 140, 0, ''),
(70, 4, 4, '2022-01-12 00:00:00', 300, 0, 'nfcompra_b0ef1d9b71a483c6dda0acfb4a48af401643484942.pdf'),
(71, 13, 3, '2022-01-20 00:00:00', 350, 0, 'nfcompra_078be1e24d1d93f74c88abcdc19af2ae1643484452.pdf'),
(72, 37, 3, '2022-01-19 00:00:00', 2175, 0, 'nfcompra_0c790dbd5d8bdee758b624901576fb391643484278.pdf'),
(73, 38, 4, '2022-02-03 00:00:00', 89.9, 0, 'nfcompra_df74c88c3267a62597405dd92cd314371645828341.pdf'),
(74, 33, 3, '2022-02-07 00:00:00', 350, 0, 'nfcompra_08473ff9653f68c498b75dc88f69532f1645828441.pdf'),
(75, 6, 3, '2022-02-07 00:00:00', 420, 0, ''),
(76, 26, 3, '2022-02-12 00:00:00', 110, 0, ''),
(77, 4, 4, '2022-03-16 00:00:00', 300, 0, 'nfcompra_28ce01870b06114eb9560e0f812a97d71645828174.pdf'),
(78, 31, 3, '2022-03-14 00:00:00', 700, 0, 'nfcompra_16133ea8dccc348c7fcd08ba26595f771645828684.pdf'),
(79, 40, 3, '2022-02-25 00:00:00', 400, 0, 'nfcompra_7dee0c42524aa8ee09bef0710849373c1645827787.pdf'),
(80, 13, 3, '2022-02-22 00:00:00', 350, 0, 'nfcompra_b34a08f12b1451c2f4436010cc991bc11645828024.pdf'),
(81, 41, 3, '2022-03-02 00:00:00', 1100, 0, 'nfcompra_f2f9f74d2805d572052f0bea0c4f25841648598402.pdf'),
(82, 33, 3, '2022-03-07 00:00:00', 350, 0, 'nfcompra_8d34ec8965354d9ef46a269c95d587c61648598818.pdf'),
(83, 6, 3, '2022-03-07 00:00:00', 420, 0, ''),
(84, 8, 3, '2022-03-07 00:00:00', 500, 0, ''),
(85, 38, 4, '2022-03-05 00:00:00', 89.9, 0, 'nfcompra_2a67ff97787b2d3607179877bbe4fb021648598720.pdf'),
(86, 40, 3, '2022-03-15 00:00:00', 400, 0, 'nfcompra_c395ab5792c85023ebe9ce270a53b0971648598919.pdf'),
(87, 21, 1, '2022-03-10 00:00:00', 300, 0, ''),
(88, 26, 3, '2022-03-10 00:00:00', 110, 0, ''),
(89, 13, 3, '2022-03-21 00:00:00', 350, 0, 'nfcompra_630095a15790b2dfcf4b9af0b56369d11648598999.pdf'),
(90, 33, 3, '2022-04-07 00:00:00', 350, 0, 'nfcompra_b8896775f09bed7e5de7e96a3bb326031651240322.pdf'),
(91, 38, 4, '2022-04-05 00:00:00', 89.9, 0, 'nfcompra_bed6cbd2cfcbde8e0cafbfc96a946c6f1651240563.pdf'),
(92, 34, 3, '2022-04-07 00:00:00', 735, 0, 'nfcompra_960a2596ff2ddf744cdfd9c8022c80451651240765.pdf'),
(93, 26, 3, '2022-04-12 00:00:00', 110, 0, ''),
(94, 44, 3, '2022-04-13 00:00:00', 800, 0, 'nfcompra_4d31e9e954851ff5c60ee9b7e7a03e791651240909.pdf'),
(95, 13, 3, '2022-04-20 00:00:00', 350, 0, 'nfcompra_c6c81ec5ae57c7caf7f5716132c82a241651240991.pdf'),
(96, 21, 3, '2022-04-20 00:00:00', 300, 0, ''),
(97, 45, 4, '2022-04-22 00:00:00', 1200, 0, 'nfcompra_5bb81fe7e76daa5c6c6f309aa783b40a1651241090.pdf'),
(98, 47, 3, '2022-05-03 00:00:00', 800, 0, 'nfcompra_09f2fce39c15e015ef4c6f63c27ae1291653664422.pdf'),
(99, 38, 4, '2022-05-03 00:00:00', 89.9, 0, 'nfcompra_351a3865c0e29fdfcd964373fbe112cf1652266952.pdf'),
(100, 33, 3, '2022-05-08 00:00:00', 350, 0, 'nfcompra_f72dd71cb1fbeb255777fd758cee52541653665200.pdf'),
(101, 48, 4, '2022-05-11 00:00:00', 750, 0, 'nfcompra_16ad4c2f9d307cd3c6ac24b4fb6bb38a1652488447.pdf'),
(102, 26, 1, '2022-05-12 00:00:00', 110, 0, ''),
(103, 45, 4, '2022-05-08 00:00:00', 1200, 0, 'nfcompra_52e7ccd36437fe465a4581e4eca9e4101653665938.pdf'),
(104, 46, 4, '2022-05-08 00:00:00', 1600, 0, 'nfcompra_33d2dbfda77bfa8317d749fb5b654cb51653665424.pdf'),
(105, 13, 3, '2022-05-20 00:00:00', 350, 0, 'nfcompra_1ca4e90626ca2263c411180c059244541653418288.pdf'),
(106, 44, 3, '2022-05-21 00:00:00', 800, 0, 'nfcompra_c79b7c620f38b6fd976f1395874cb7d61653666039.pdf'),
(107, 49, 3, '2022-05-27 00:00:00', 600, 0, 'nfcompra_196fd76f5ed99a0d4408bb2dc2cdafef1653770958.pdf'),
(108, 47, 3, '2022-05-20 00:00:00', 800, 0, 'nfcompra_cab45846e3fd9de16f86fb005e966d591654215890.pdf'),
(109, 50, 3, '2022-06-01 00:00:00', 350, 0, 'nfcompra_a49b731a033daebfc2122143d2ef94521656444378.pdf'),
(110, 38, 4, '2022-06-07 00:00:00', 89.9, 0, 'nfcompra_3ce2e46aac6e5e0b709aeaab0d420fd01656444630.pdf'),
(111, 45, 4, '2022-06-07 00:00:00', 1200, 0, 'nfcompra_86ba7d30b9e2a6b2c2e973947cb05c651656444501.pdf'),
(112, 46, 4, '2022-06-08 00:00:00', 1600, 0, 'nfcompra_bf2b9109dcd7f4b959ea31e8408761591656444882.pdf'),
(113, 26, 1, '2022-06-12 00:00:00', 110, 0, ''),
(114, 41, 3, '2022-06-10 00:00:00', 1100, 0, 'nfcompra_c488a71196c1b40699f540308df8da0c1656445103.pdf'),
(115, 51, 3, '2022-06-17 00:00:00', 300, 0, 'nfcompra_d6010dcb2c915489a2c6637662493a481656445355.pdf'),
(116, 52, 3, '2022-06-20 00:00:00', 400, 0, 'nfcompra_53564277c3afd29d74272037efad2c5d1656445515.pdf'),
(117, 13, 3, '2022-06-23 00:00:00', 360, 0, 'nfcompra_1f058d51bce30b830b2ef4b596a8c9131656445823.pdf'),
(118, 50, 3, '2022-06-30 00:00:00', 350, 0, 'nfcompra_e246649bf4747c68f7d1758c033b16211656620385.pdf'),
(119, 42, 3, '2022-07-07 00:00:00', 90, 0, 'nfcompra_fb39a3458d196876843aa1945b4186eb1657970837.pdf'),
(120, 38, 4, '2022-07-07 00:00:00', 89.9, 0, 'nfcompra_ca44d5a0b60024a9f6af84249464b85e1657970637.pdf'),
(121, 46, 4, '2022-07-08 00:00:00', 1600, 0, 'nfcompra_d27c73bb27db6a28fdc9d50c1f8b69601657970478.pdf'),
(122, 56, 3, '2022-07-14 00:00:00', 800, 0, 'nfcompra_55f81ea730d3507f8909585c0127ce9a1657971281.pdf'),
(123, 45, 4, '2022-07-08 00:00:00', 1200, 0, 'nfcompra_2ab5c28204935a11b5e13ae82acf34c31657971008.pdf'),
(124, 54, 4, '2022-07-11 00:00:00', 975, 0, 'nfcompra_b831efc0fa1ed968300d2033b270867a1657971167.pdf'),
(125, 26, 1, '2022-07-15 00:00:00', 110, 0, ''),
(126, 13, 3, '2022-07-21 00:00:00', 350, 0, 'nfcompra_d6d5189a78a6b9cd09a1ff95e139664b1658510319.pdf'),
(127, 42, 3, '2022-08-01 00:00:00', 90, 0, 'nfcompra_41a35434adf3001cd290f0dd024ebbef1661462016.pdf'),
(128, 50, 3, '2022-08-01 00:00:00', 350, 0, 'nfcompra_2ccd0fb8febf15318d5afafcc40098381661462091.pdf'),
(129, 17, 3, '2022-08-02 00:00:00', 150, 0, ''),
(130, 17, 3, '2022-05-14 00:00:00', 100, 0, ''),
(131, 63, 3, '2022-01-01 00:00:00', 200, 0, ''),
(132, 39, 5, '2022-08-02 00:00:00', 134.87, 0, 'nfcompra_5487ac472823ac539e3636f7164806f81659473626.pdf'),
(133, 54, 4, '2022-08-01 00:00:00', 975, 0, 'nfcompra_8dfc8998e96605bcf0574c42eb50e5341661460944.pdf'),
(134, 58, 4, '2022-08-05 00:00:00', 975, 0, 'nfcompra_cc157bd5bd2a9c4ddf7dff6971066f0d1661461564.pdf'),
(135, 59, 4, '2022-08-05 00:00:00', 975, 0, 'nfcompra_6385a1f31b832d24623f0c116ac5e6221661461638.pdf'),
(136, 60, 4, '2022-08-05 00:00:00', 350, 0, 'nfcompra_8bab9e3199927ebaea2b912bccb0c6ee1661461785.pdf'),
(137, 38, 4, '2022-08-05 00:00:00', 89.9, 0, 'nfcompra_04f306a2a6f9a64639767c02a9967c451661461943.pdf'),
(138, 64, 4, '2022-08-08 00:00:00', 675, 0, 'nfcompra_1f9df043a0292ead9eb2cff94cfff5231661460758.pdf'),
(139, 26, 1, '2022-08-10 00:00:00', 110, 0, ''),
(140, 18, 1, '2022-08-16 00:00:00', 1450, 0, ''),
(141, 46, 4, '2022-08-08 00:00:00', 1600, 0, 'nfcompra_4959779d7f3a02f1cf6d3d6fd1879dbc1661460856.pdf'),
(142, 45, 4, '2022-08-08 00:00:00', 1200, 0, 'nfcompra_871d8d4203bca9bc5047b207f16959191661461157.pdf'),
(143, 61, 4, '2022-08-11 00:00:00', 975, 0, 'nfcompra_c887797aa90c622f718d1ab175ad8cea1660746930.pdf'),
(144, 62, 4, '2022-08-11 00:00:00', 975, 0, 'nfcompra_42075162cf96687d0c7dfcde665cb5851660746911.pdf'),
(145, 62, 4, '2022-09-01 00:00:00', 975, 0, 'nfcompra_c684e23f3f04e8a758af8b95a6d4ef221660848787.pdf'),
(146, 61, 4, '2022-09-01 00:00:00', 975, 0, 'nfcompra_7ab4a75a97fd56e7251e258eb0e4e96a1660848901.pdf'),
(147, 66, 4, '2022-08-18 00:00:00', 120, 0, ''),
(148, 65, 4, '2022-08-18 00:00:00', 487.5, 0, 'nfcompra_e6ae470d4d165bfae0953abe1ca01ef41661460454.pdf'),
(149, 13, 3, '2022-08-22 00:00:00', 350, 0, 'nfcompra_d8bf2e234c44750783728f438b131aae1661460274.pdf'),
(150, 50, 3, '2022-08-31 00:00:00', 350, 0, 'nfcompra_7504dbfb9670ea1192e8d144ec9bb1341661982034.pdf'),
(151, 49, 3, '2022-09-03 00:00:00', 600, 0, 'nfcompra_64fb8d8dbefc1154f475b9085880dca21664485813.pdf'),
(152, 54, 4, '2022-09-01 00:00:00', 975, 0, 'nfcompra_9e30e67d73ed25e159f47e86242d66c61664484548.pdf'),
(153, 60, 4, '2022-09-01 00:00:00', 350, 0, 'nfcompra_857a679fad3f18c673084197af7c05291664484207.pdf'),
(154, 58, 4, '2022-09-01 00:00:00', 975, 0, 'nfcompra_0fa192155ee95e52507bb9cda4f367a31664484134.pdf'),
(155, 59, 4, '2022-09-01 00:00:00', 975, 0, 'nfcompra_8fc5930105e5e93a361303662378d2e11664484073.pdf'),
(156, 65, 4, '2022-09-01 00:00:00', 975, 0, 'nfcompra_0d170ab67d6d5bb3fffe6563b1e4e61d1664484718.pdf'),
(157, 42, 3, '2022-09-02 00:00:00', 90, 0, 'nfcompra_6a23bc29fde94866a6846841d43745961664484983.pdf'),
(158, 67, 4, '2022-09-05 00:00:00', 975, 0, 'nfcompra_555e7156164d5c3d02cbad8e09bc30f01664484638.pdf'),
(159, 64, 4, '2022-09-19 00:00:00', 675, 0, 'nfcompra_d6d8b0545864857235f755d70af461fc1664486436.pdf'),
(160, 38, 4, '2022-09-05 00:00:00', 89.9, 0, 'nfcompra_e89bb1d5238062e2ac6270dccbd97dfc1664485077.pdf'),
(161, 26, 3, '2022-09-10 00:00:00', 110, 0, ''),
(162, 45, 4, '2022-09-08 00:00:00', 1200, 0, 'nfcompra_38baa8f9038db1b96b26915ec79cef221664485668.pdf'),
(163, 46, 4, '2022-09-08 00:00:00', 1600, 0, 'nfcompra_769951022afc17c8dd5561e645d19fff1664485604.pdf'),
(164, 61, 4, '2022-10-01 00:00:00', 975, 0, 'nfcompra_28f87727594a2073b1cbc16905463ddf1669720981.pdf'),
(165, 62, 4, '2022-10-01 00:00:00', 975, 0, 'nfcompra_925fc8f5685681c1f5e3adc1097843141664395935.pdf'),
(166, 68, 4, '2022-09-19 00:00:00', 1600, 0, 'nfcompra_c1aca3d60c5dd54e0eea39b96c16c3ed1664486960.pdf'),
(167, 69, 3, '2022-09-22 00:00:00', 50, 0, 'nfcompra_60e3e7ebe06f706249f9c0cd599d822e1664487079.pdf'),
(168, 50, 3, '2022-09-29 00:00:00', 350, 0, 'nfcompra_3b6c425d8df3cbdf792f17d231df50091664487192.pdf'),
(169, 58, 4, '2022-10-03 00:00:00', 975, 0, 'nfcompra_f12b612b53e0b6fbf55a050d569942431664896289.pdf'),
(170, 59, 4, '2022-10-03 00:00:00', 975, 0, 'nfcompra_94a86d45d74239161123ceba27e30a7c1664896365.pdf'),
(171, 60, 4, '2022-10-03 00:00:00', 350, 0, 'nfcompra_3912c6b528e31da775482dc2bc0870d91664896433.pdf'),
(172, 65, 4, '2022-10-03 00:00:00', 975, 0, 'nfcompra_0f35182725d2295f26794c2c651952531664896647.pdf'),
(173, 67, 4, '2022-10-03 00:00:00', 975, 0, 'nfcompra_be2a50cfa99486b3f3ec2142704068c11664896767.pdf'),
(174, 54, 4, '2022-10-03 00:00:00', 975, 0, 'nfcompra_fd8008b66ba339811a4fd5bc162fd4241664896877.pdf'),
(175, 26, 3, '2022-10-10 00:00:00', 110, 0, ''),
(176, 71, 4, '2022-10-17 00:00:00', 350, 0, 'nfcompra_67ee614d6dd0756f8e8fb5435d0bebe61666889832.pdf'),
(177, 38, 4, '2022-10-04 00:00:00', 89.9, 0, 'nfcompra_8942e7c41a9d70cf1e66c47e1a98609e1666802108.pdf'),
(178, 42, 3, '2022-10-04 00:00:00', 90, 0, 'nfcompra_bb918d2ed7124d983aa322d3ab24b5611666885684.pdf'),
(179, 46, 4, '2022-10-10 00:00:00', 1600, 0, 'nfcompra_80403d12dc16b3f6f3ec302ac5fb742a1666886822.pdf'),
(180, 45, 4, '2022-10-08 00:00:00', 1200, 0, 'nfcompra_3644778ca166a3322967b354991149031666886926.pdf'),
(181, 73, 4, '2022-10-06 00:00:00', 1950, 0, 'nfcompra_0144a60355877e4a4099ddaa9e7d437b1666887275.pdf'),
(182, 75, 3, '2022-10-13 00:00:00', 50, 0, 'nfcompra_411b0a940d9cbcbe3c558beb7209bcfb1666887713.pdf'),
(183, 62, 4, '2022-11-01 00:00:00', 975, 0, 'nfcompra_a2685bff729cdb129f40a7c4a406614a1666891279.pdf'),
(184, 50, 3, '2022-10-31 00:00:00', 350, 0, 'nfcompra_dd656e3c9b1175e5cf289202c82709ed1667251779.pdf'),
(185, 74, 4, '2022-10-31 00:00:00', 188.71, 0, 'nfcompra_0d6215f6185d8751a97e2f05c2bcb23e1667256963.pdf'),
(186, 1, 3, '2022-10-17 00:00:00', 120, 0, ''),
(187, 59, 4, '2022-11-01 00:00:00', 975, 0, 'nfcompra_7ebe46fa27a4ecc31b5d159f3f6243c81667316169.pdf'),
(188, 58, 4, '2022-11-01 00:00:00', 975, 0, 'nfcompra_1d0811fc5bc5876ca3baa6d06270a82f1667316296.pdf'),
(189, 60, 4, '2022-11-01 00:00:00', 350, 0, 'nfcompra_832c887662d7054c0f125938dfe1496a1667316387.pdf'),
(190, 46, 4, '2022-11-08 00:00:00', 1600, 0, 'nfcompra_f666a561b39d234c4e38daae966497011669653078.pdf'),
(191, 45, 4, '2022-11-08 00:00:00', 1200, 0, 'nfcompra_401cce92afe2a407199e14523f22ce601669660205.pdf'),
(192, 73, 4, '2022-11-06 00:00:00', 1950, 0, 'nfcompra_2616bb9293287c7fdeab690e5f5aac3d1669660300.pdf'),
(193, 26, 3, '2022-11-12 00:00:00', 110, 0, ''),
(194, 67, 4, '2022-11-01 00:00:00', 975, 0, 'nfcompra_f775643559ec660a3e6e7f485756436a1669653231.pdf'),
(195, 65, 4, '2022-11-01 00:00:00', 975, 0, 'nfcompra_9810e96b52712064a43062b1e20046451669653332.pdf'),
(196, 42, 3, '2022-11-02 00:00:00', 90, 0, 'nfcompra_a684d16fcc9cb59434108135c1cc3ef71669659820.pdf'),
(197, 38, 4, '2022-11-03 00:00:00', 89.9, 0, 'nfcompra_34e5e4a3492df5ce576585c64ce2cacd1669659955.pdf'),
(198, 54, 4, '2022-11-01 00:00:00', 975, 0, 'nfcompra_8b8b6c44a75187e9825b58c5a77d46f41669660055.pdf'),
(199, 74, 4, '2022-11-17 00:00:00', 1500, 0, 'nfcompra_4976d0381a590e76bd869c6b234bfcff1669660591.pdf'),
(200, 78, 4, '2022-11-18 00:00:00', 422.5, 0, 'nfcompra_add82bd60a44ed03657a3e5aa9085d401669660686.pdf'),
(201, 61, 4, '2022-11-01 00:00:00', 975, 0, 'nfcompra_48272788a35e6c0731284e35701c2eb71669721186.pdf'),
(202, 62, 4, '2022-12-01 00:00:00', 975, 0, 'nfcompra_fe2719ed458ee970a94fa559be645b1e1669721308.pdf'),
(203, 61, 4, '2022-12-01 00:00:00', 975, 0, 'nfcompra_ba7e02f19344b5def14fd011c0386bbd1669721206.pdf'),
(204, 59, 4, '2022-12-01 00:00:00', 975, 0, 'nfcompra_cb16071184eb2c0164d944514592e7d31669911229.pdf'),
(205, 60, 4, '2022-12-01 00:00:00', 350, 0, 'nfcompra_f2a240995d1f718b09a9e5521e79d5d31669911335.pdf'),
(206, 58, 4, '2022-12-01 00:00:00', 975, 0, 'nfcompra_20ed1d02ab165457ec28e95d6fb738fa1669911403.pdf'),
(207, 78, 4, '2022-12-01 00:00:00', 975, 0, 'nfcompra_2231e76a0e2edcb1ff9bb6a9828c3d6e1672157673.pdf'),
(208, 26, 3, '2022-12-11 00:00:00', 110, 0, ''),
(209, 17, 3, '2022-12-19 00:00:00', 50, 0, ''),
(210, 1, 3, '2022-12-19 00:00:00', 180, 0, ''),
(211, 68, 4, '2022-12-26 00:00:00', 1600, 0, 'nfcompra_445cd320d52cb7e47b74c3f78f2a48e81672085545.pdf'),
(212, 54, 4, '2022-12-01 00:00:00', 975, 0, 'nfcompra_e91c5626a480df12865bc5463b5a70e41672154633.pdf'),
(213, 67, 4, '2022-12-01 00:00:00', 975, 0, 'nfcompra_6290e3eb497d0566411fb8c244dede6c1672154732.pdf'),
(214, 61, 4, '2023-01-01 00:00:00', 975, 0, 'nfcompra_8b8ccda7ae1fc0063420d5ff556c37221672155212.pdf'),
(215, 62, 4, '2023-01-01 00:00:00', 975, 0, 'nfcompra_91ce9d9727025cd264bc9ba7510360941672155360.pdf'),
(216, 74, 4, '2022-12-01 00:00:00', 975, 0, 'nfcompra_addaf4aa6be894e4404318b2c29e2bdf1672155764.pdf'),
(217, 50, 3, '2022-12-01 00:00:00', 350, 0, 'nfcompra_2df7d51234eb6d5da7bab993f1efc1791672155933.pdf'),
(218, 42, 3, '2022-12-01 00:00:00', 90, 0, 'nfcompra_4f7cc1196c7ade6264fe8cad43cc560d1672156064.pdf'),
(219, 38, 4, '2022-12-05 00:00:00', 89.9, 0, 'nfcompra_5d5e87605bbfcceb7797b74ddb6216821672156394.pdf'),
(220, 46, 4, '2022-12-01 00:00:00', 1600, 0, 'nfcompra_9c2c0339178dc4def50d9fe2ca23fb801672156545.pdf'),
(221, 73, 4, '2022-12-08 00:00:00', 1950, 0, 'nfcompra_5f72291bbe4771d03feb4c891e2e36f01672156691.pdf'),
(222, 45, 4, '2022-12-08 00:00:00', 1200, 0, 'nfcompra_93c54442af2a8ec4f380397722bbb3511672156914.pdf'),
(223, 65, 4, '2022-12-08 00:00:00', 1500, 0, 'nfcompra_431c12dbaa2067539c835848c58b1c751672157432.pdf'),
(224, 59, 4, '2023-01-02 00:00:00', 975, 0, 'nfcompra_92d64a72d3d9dfcd1ee2fdcef9d180cd1672677158.pdf'),
(225, 58, 4, '2023-01-02 00:00:00', 975, 0, 'nfcompra_0bb8d1a6528e305c94c16c2baadf3c2e1672677259.pdf'),
(226, 60, 4, '2023-01-02 00:00:00', 350, 0, 'nfcompra_2f7e6f5c6fe32be46dff759d733b775c1672677384.pdf'),
(227, 50, 3, '2022-12-30 00:00:00', 350, 0, 'nfcompra_cebdbae3400c9c3f8e4cdceeb2b829f51672680675.pdf'),
(228, 76, 4, '2023-01-05 00:00:00', 0, 0, ''),
(229, 54, 4, '2023-01-01 00:00:00', 975, 0, 'nfcompra_3cdfaaf0397e3c187fd99eaad38b281f1674743450.pdf'),
(230, 67, 4, '2023-01-01 00:00:00', 975, 0, 'nfcompra_b3a7e58a13788217eb3557dce27d4c1a1674744019.pdf'),
(231, 78, 4, '2023-01-01 00:00:00', 975, 0, 'nfcompra_e0c64ae427e6717f0f9d3b00ef2094651674744195.pdf'),
(232, 42, 3, '2023-01-03 00:00:00', 90, 0, 'nfcompra_30eb3b838102ba55b6e4f367ac5e4a911674744520.pdf'),
(233, 38, 4, '2023-01-05 00:00:00', 89.9, 0, 'nfcompra_d65d08bce7650f0289feec4f44c031d21674744378.pdf'),
(234, 65, 4, '2023-01-05 00:00:00', 1500, 0, 'nfcompra_ed22529074171dd532541cf0db2f2d371674745015.pdf'),
(235, 73, 4, '2023-01-09 00:00:00', 1950, 0, 'nfcompra_8c3e06cec263137fdd0b15c9ff56a2fb1674745287.pdf'),
(236, 46, 4, '2023-01-01 00:00:00', 1600, 0, 'nfcompra_46d09ca88a04f1ab9a5b060f7b9be5511674743675.pdf'),
(237, 77, 4, '2023-01-12 00:00:00', 650, 0, 'nfcompra_118bfd8aa6fac651545627c0f29e40631674745535.pdf'),
(238, 79, 4, '2023-01-19 00:00:00', 560, 0, 'nfcompra_0f85a2fef886909291f328a4937a1c0d1674745690.pdf'),
(239, 74, 4, '2023-01-12 00:00:00', 1530, 0, 'nfcompra_d744cd4c09547d0c3a675b69893b191a1674745420.pdf'),
(240, 80, 4, '2023-01-24 00:00:00', 652.8, 0, 'nfcompra_d890144ad48feaa415514c9351d81dfb1674745904.pdf'),
(241, 81, 4, '2023-01-24 00:00:00', 652.8, 0, 'nfcompra_8522d4afe905eb6f16cb0a47cb32215a1674745933.pdf'),
(242, 61, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_0b9d6d510dfdc4b3f842d59297dcc6101675094559.pdf'),
(243, 62, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_ce4ded7b7449918d6ab491d0cf99d6d21675094581.pdf'),
(244, 76, 4, '2023-03-01 00:00:00', 3200, 0, 'nfcompra_840a6d89fda88807942a299d447e0ae71675094602.pdf'),
(245, 60, 4, '2023-02-01 00:00:00', 350, 0, 'nfcompra_add8c295af48839ca33b0b51a23485cf1675371146.pdf'),
(246, 59, 4, '2023-02-10 00:00:00', 1500, 0, 'nfcompra_61b7e57f0835e39a59fdae4ec4ef20931676317255.pdf'),
(247, 58, 4, '2023-02-10 00:00:00', 1500, 0, 'nfcompra_fd26c55325eb90bf428af3aafb13b6d01676317278.pdf'),
(248, 87, 4, '2023-02-22 00:00:00', 487.5, 0, 'nfcompra_20150227f19475f7dca877302a8fd5281677196021.pdf'),
(249, 73, 4, '2023-02-16 00:00:00', 1950, 0, 'nfcompra_ed5e2c0b2a1f3930d6547306b19645e81677196505.pdf'),
(250, 80, 4, '2023-02-10 00:00:00', 1500, 0, 'nfcompra_01c28f149ab4bf27b5cc31410e8653261677196775.pdf'),
(251, 81, 4, '2023-02-10 00:00:00', 1500, 0, 'nfcompra_3956ecc7facbe2c9c07d65ec93f293f41677196741.pdf'),
(252, 78, 4, '2023-02-08 00:00:00', 975, 0, 'nfcompra_e2985e14f9e6f1a70cee9479ef3fdd171677197147.pdf'),
(253, 46, 4, '2023-02-08 00:00:00', 1600, 0, 'nfcompra_a74f30193ae08d89876744a25b3973931677197274.pdf'),
(254, 42, 3, '2023-02-06 00:00:00', 90, 0, 'nfcompra_be776e7b9814143c57cabc51c54b9a281677197558.pdf'),
(255, 38, 4, '2023-02-02 00:00:00', 89.9, 0, 'nfcompra_2f67fb924420cef538e20268ef0c6e9c1677197668.pdf'),
(256, 85, 4, '2023-02-02 00:00:00', 1200, 0, 'nfcompra_ad28ab06c6bca2b9768d1c82c592cac21677197858.pdf'),
(257, 84, 4, '2023-02-01 00:00:00', 1200, 0, 'nfcompra_c09d51f34429aabd6c0f0177f8d52fb51677197921.pdf'),
(258, 83, 4, '2023-02-01 00:00:00', 975, 0, 'nfcompra_f3661d37174fad1c896e93057761ddfb1677198089.pdf'),
(259, 82, 4, '2023-02-01 00:00:00', 1200, 0, 'nfcompra_0d301bb51eecb8995099ac4f918c91251677198210.pdf'),
(260, 79, 4, '2023-01-30 00:00:00', 1200, 0, 'nfcompra_ad72e1fde75e1b32a6109243c03348c61677198511.pdf'),
(261, 77, 4, '2023-01-31 00:00:00', 975, 0, 'nfcompra_577f0959d86aa7bd705e3527d5fb8f1c1677198627.pdf'),
(262, 50, 3, '2023-01-31 00:00:00', 350, 0, 'nfcompra_ac1e3e612d2ac7a3b7d3d89b705e32401677198723.pdf'),
(263, 54, 4, '2023-02-01 00:00:00', 975, 0, 'nfcompra_d835d5ab0bbb019511b1407b75f7f0491677198836.pdf'),
(264, 74, 4, '2023-02-01 00:00:00', 975, 0, 'nfcompra_519056db2162d9b58e153d1a2e0881651677198936.pdf'),
(265, 67, 4, '2023-02-01 00:00:00', 975, 0, 'nfcompra_d5564084a075ea30127c5d1eef1575c01677199041.pdf'),
(266, 65, 4, '2023-02-01 00:00:00', 975, 0, 'nfcompra_4689a322437b0412eb624dbe38036f7d1677199133.pdf'),
(267, 79, 4, '2023-02-27 00:00:00', 1200, 0, 'nfcompra_a03ceb99cb1f1436c6d2a0110095bee11677787318.pdf'),
(268, 84, 4, '2023-02-28 00:00:00', 1200, 0, 'nfcompra_649a45bd5ee01b698fdedcea6845a5e61677794605.pdf'),
(269, 85, 4, '2023-02-28 00:00:00', 1200, 0, 'nfcompra_32c49a2816e2710a98a0dfc9e639fb0a1677794700.pdf'),
(270, 82, 4, '2023-02-28 00:00:00', 1200, 0, 'nfcompra_645ddf7359a750326733fe907a0de14e1677794792.pdf'),
(271, 77, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_00061a4e5469376bf4eeb4eb38b5626c1677795278.pdf'),
(272, 50, 3, '2023-03-01 00:00:00', 350, 0, 'nfcompra_3bffdba528568bf170ac5635ee6c34341677795395.pdf'),
(273, 59, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_7bcfad5889a82eb8e616b472c689fd8c1677795690.pdf'),
(274, 60, 4, '2023-03-01 00:00:00', 350, 0, 'nfcompra_424e06886e2560ada04f2069a9b430081677795715.pdf'),
(275, 58, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_5e5b3a855dbf7d1a52c0eb402aa4b6231677795740.pdf'),
(276, 78, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_e5d691f2b9cb58bb75c6b5908a61202c1677795900.pdf'),
(277, 83, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_04779d787cb7cca91bf3dbfe277580291677796048.pdf'),
(278, 42, 3, '2023-03-02 00:00:00', 90, 0, 'nfcompra_b7962f13cef783268274ee6d0071847c1677796252.pdf'),
(279, 76, 4, '2023-03-01 00:00:00', 3200, 0, 'nfcompra_6f95432a62b1fe2edec0b48c2d7a9a991677796549.pdf'),
(281, 62, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_6f80ebe855490d70197b7a990ab18dcb1677796599.pdf'),
(282, 61, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_fa03bb0663767085d9aa6bbb82d30e001677796634.pdf'),
(283, 87, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_11d08ab597791515b9f6dd639e26b9641677796987.pdf'),
(284, 38, 4, '2023-03-06 00:00:00', 89.9, 0, 'nfcompra_7df199b85a0154555ccd098bf3952f4f1680028528.pdf'),
(285, 54, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_990e276266426fa661674ec632d7358e1680028860.pdf'),
(286, 46, 4, '2023-03-08 00:00:00', 1600, 0, 'nfcompra_1582a671b01d33a4159940bc9e83ef451680028842.pdf'),
(287, 81, 4, '2023-03-10 00:00:00', 1500, 0, 'nfcompra_63bd186e1700a6eaa794c45c24f56a8b1680029137.pdf'),
(288, 80, 4, '2023-03-10 00:00:00', 1500, 0, 'nfcompra_25ff49c216589e15276c04dd4fab36521680029168.pdf'),
(289, 67, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_755a513e3fdba86e9c2bca1cc088ff8d1680029327.pdf'),
(290, 65, 4, '2023-03-01 00:00:00', 975, 0, 'nfcompra_7649effa9042e93e9a324e5d4119efd71680029435.pdf'),
(291, 73, 4, '2023-03-15 00:00:00', 1950, 0, 'nfcompra_45a27287e4a60dafa618470100d521b81680029706.pdf'),
(292, 74, 4, '2023-03-23 00:00:00', 1530.49, 0, 'nfcompra_2f37ea68fec9bfefff9f134cabbe67b71680029953.pdf'),
(293, 84, 4, '2023-03-27 00:00:00', 1200, 0, 'nfcompra_8f78ee9c3cc7c842dcf893ec04c944511680030426.pdf'),
(294, 85, 4, '2023-03-27 00:00:00', 1200, 0, 'nfcompra_978641dea1870046e5b38b7e53a86ab11680030496.pdf'),
(295, 82, 4, '2023-03-27 00:00:00', 1200, 0, 'nfcompra_d3d60ad9b612df75208411fd2a6f4a221680030607.pdf'),
(296, 76, 4, '2023-03-29 00:00:00', 3200, 0, 'nfcompra_409fd106000e3a27894c41a1c5325c7f1680545655.pdf'),
(297, 62, 4, '2023-03-29 00:00:00', 975, 0, 'nfcompra_988bfeef879cf92cbf26629faa68b3021680545958.pdf'),
(298, 61, 4, '2023-03-29 00:00:00', 975, 0, 'nfcompra_1feaabd3c9dde9435fac367212affb7b1680545936.pdf'),
(299, 50, 3, '2023-03-31 00:00:00', 350, 0, 'nfcompra_9b4bf46fe9126c54ecb7310351a01a8f1680547383.pdf'),
(300, 59, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_e11e2ac95a365c987276c5594e9e5b651680659211.pdf'),
(301, 58, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_39c337a3035cd77400c8d9f4bba9855f1680659620.pdf'),
(302, 60, 4, '2023-04-03 00:00:00', 350, 0, 'nfcompra_643fbec97470bfdb664db3bee77c01b41680660029.pdf'),
(303, 87, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_ecb573842bc480176455b4ac7f28ad021680716985.pdf'),
(304, 67, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_4a13f48867c8df5df3c6c4bf794fa4231680717400.pdf'),
(305, 65, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_5944471738764005aca234868f73dfca1680721224.pdf'),
(306, 54, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_cb8228397d6819b75c93dd1300d3385a1680722369.pdf'),
(307, 83, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_27d370b2088750b897f3df92bef9c6171680722561.pdf'),
(308, 78, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_b04624ac1d43d2f68dc7d720fe27273f1680722812.pdf'),
(309, 77, 4, '2023-04-03 00:00:00', 975, 0, 'nfcompra_c3f70b329bb12507f388c918769434861680723108.pdf'),
(310, 79, 4, '2023-04-03 00:00:00', 1200, 0, 'nfcompra_32c12f51d0ac3743ef36b04fc744f3ce1680723334.pdf'),
(311, 38, 4, '2023-04-03 00:00:00', 89.9, 0, 'nfcompra_60319ab09bfcec8420e54856f421b6f91680724937.pdf'),
(312, 42, 3, '2023-04-05 00:00:00', 90, 0, 'nfcompra_0d40586ec7265cd02a721cdc0a9210311682613301.pdf'),
(313, 46, 4, '2023-04-07 00:00:00', 1600, 0, ''),
(314, 50, 3, '2023-04-28 00:00:00', 350, 0, 'nfcompra_536d8ad81be82c9a4e79340d695f487a1682704992.pdf'),
(315, 87, 4, '2023-04-28 00:00:00', 1125, 0, 'nfcompra_214fe058f297449a9184a3741244ec661682705715.pdf'),
(316, 88, 4, '2023-04-28 00:00:00', 1200, 0, 'nfcompra_f5a162dbb10eabddcfb7df6a0f5d7f581682709004.pdf'),
(317, 65, 4, '2023-04-28 00:00:00', 975, 0, 'nfcompra_0e9beaa777af2384c254f34c0b7ed6491683045143.pdf'),
(318, 60, 4, '2023-04-28 00:00:00', 350, 0, 'nfcompra_d567b8b538f00d2e6de336cd29231a551683045441.pdf'),
(319, 59, 4, '2023-04-28 00:00:00', 975, 0, 'nfcompra_490832182b4cd6daf04f8717267c3b281683045786.pdf'),
(320, 58, 4, '2023-04-28 00:00:00', 975, 0, 'nfcompra_2c737bb3f5c2529e92582af1875b662f1683045945.pdf'),
(321, 84, 4, '2023-04-28 00:00:00', 1200, 0, 'nfcompra_4cc908d8585b3c04f6429bd9d912838c1683048500.pdf'),
(322, 85, 4, '2023-04-28 00:00:00', 1200, 0, 'nfcompra_c7bb3e8ee7d704436b6ce35ca8525dc81683048662.pdf'),
(323, 82, 4, '2023-04-28 00:00:00', 1200, 0, 'nfcompra_cc5e74dcde48ff871ec2744611acf6981683048848.pdf'),
(324, 79, 4, '2023-05-02 00:00:00', 1200, 0, 'nfcompra_162df7494f6062c507a78530281241471683210571.pdf'),
(325, 67, 4, '2023-05-02 00:00:00', 975, 0, 'nfcompra_c5447d2b41704d02014c9c52c7358d4a1683212953.pdf'),
(326, 54, 4, '2023-05-02 00:00:00', 975, 0, 'nfcompra_6990335c086ee26ac5e4eb5fdb65e0091683213339.pdf'),
(327, 61, 4, '2023-05-10 00:00:00', 1500, 0, 'nfcompra_b53f27c5816dabe1a940b1839be125e71683923116.pdf'),
(328, 62, 4, '2023-05-10 00:00:00', 1500, 0, 'nfcompra_d9d670803852c950f9a07dd3f8e52fe91683923062.pdf'),
(329, 76, 4, '2023-05-10 00:00:00', 4000, 0, 'nfcompra_775c8e7375381754d89834d25fd3b1701683922996.pdf'),
(330, 77, 4, '2023-05-12 00:00:00', 975, 0, 'nfcompra_3507e4b0b17597c939c6075c2c71b8ed1684167381.pdf'),
(331, 83, 4, '2023-05-12 00:00:00', 1530.99, 0, 'nfcompra_8c10bbb34a79b1a80ce9c7f5315874ea1684167712.pdf'),
(332, 38, 4, '2023-05-03 00:00:00', 89.9, 0, 'nfcompra_5c1bc0127f5cab1460477f34e57285b71684687699.pdf'),
(333, 76, 4, '2023-05-25 00:00:00', 3200, 0, 'nfcompra_df3e834ae1f7186631a22f144cd07fec1685638261.pdf'),
(334, 62, 4, '2023-05-25 00:00:00', 975, 0, 'nfcompra_064b631e1f18cccc87f9b2fe4fe4106f1685400022.pdf'),
(335, 61, 4, '2023-05-25 00:00:00', 975, 0, 'nfcompra_d31de3eb72c740ded6904e27a6d67e221685638535.pdf'),
(336, 42, 3, '2023-05-03 00:00:00', 90, 0, 'nfcompra_0f7ce3b19823f4143ef5a131a712149b1685564918.pdf'),
(337, 84, 4, '2023-05-29 00:00:00', 1200, 0, 'nfcompra_382821c3de9472f9262a0e9d852a93a91685565249.pdf'),
(338, 85, 4, '2023-05-29 00:00:00', 1200, 0, 'nfcompra_8b3f05355aa6069c8f1deed63e03d00e1685565306.pdf'),
(339, 59, 4, '2023-05-31 00:00:00', 975, 0, 'nfcompra_266fb5c313ccbd05a18430b268085daf1685636877.pdf'),
(340, 60, 4, '2023-05-31 00:00:00', 350, 0, 'nfcompra_67c51cc252b91a4fbd4509c35a0867c31685637071.pdf'),
(341, 58, 4, '2023-05-31 00:00:00', 975, 0, 'nfcompra_a4c548ad48fbdcf31ed3697a27cd374a1685637244.pdf'),
(342, 50, 3, '2023-05-31 00:00:00', 350, 0, 'nfcompra_9c609612383b78341a25028cc67ce9981685638828.pdf'),
(343, 87, 4, '2023-05-31 00:00:00', 1125, 0, 'nfcompra_edd0c8ca76bf82d87348b2e666929cd91685639113.pdf'),
(344, 54, 4, '2023-06-01 00:00:00', 975, 0, 'nfcompra_d71e96ab7b113630943418b9cee4047c1685722783.pdf'),
(345, 65, 4, '2023-06-01 00:00:00', 975, 0, 'nfcompra_c62b456302af5fae0ebb8eeb32e2e58b1685723639.pdf'),
(346, 83, 4, '2023-06-01 00:00:00', 975, 0, 'nfcompra_fe9e35f8c5860664e694f8b72cbf4e301685723995.pdf'),
(347, 88, 4, '2023-06-01 00:00:00', 1200, 0, 'nfcompra_714b04ef68e9124c116793eecbc1c4bc1685724169.pdf'),
(348, 77, 4, '2023-06-01 00:00:00', 975, 0, 'nfcompra_00526f6135b4fb0eeaa00315409c7ede1685724322.pdf'),
(349, 79, 4, '2023-06-01 00:00:00', 1200, 0, 'nfcompra_25813a46c9bd0dc2f0466f4abe50b9c01685724512.pdf'),
(350, 82, 4, '2023-06-02 00:00:00', 1500, 0, 'nfcompra_f0eae586cac59aa0b24dfdebbe07e7a91686676245.pdf'),
(351, 38, 4, '2023-06-05 00:00:00', 89.9, 0, 'nfcompra_24cb17a7cf42480f132a8a71005f9e181686676447.pdf'),
(352, 89, 4, '2023-06-13 00:00:00', 1530, 0, 'nfcompra_5e0455854ba2c754d6fd4510e1afe01f1686757527.pdf'),
(353, 90, 4, '2023-06-23 00:00:00', 360, 0, 'nfcompra_1689bdb82b8f477ded85fbc7b51a31031689882585.pdf'),
(354, 82, 4, '2023-06-29 00:00:00', 1200, 0, 'nfcompra_2548be85ba185a9a5a251837e29d303d1689882893.pdf'),
(355, 85, 4, '2023-06-29 00:00:00', 1200, 0, 'nfcompra_588c45cfdb72e07ae6fe44e66ade52381689882766.pdf'),
(356, 84, 4, '2023-06-29 00:00:00', 1200, 0, 'nfcompra_9bcef518f36eab8b32ec0c4e9dcde0241689882728.pdf'),
(357, 62, 4, '2023-06-29 00:00:00', 975, 0, 'nfcompra_8504ea52b79f29bb3e9d1b1b805223581689884584.pdf'),
(358, 61, 4, '2023-06-29 00:00:00', 975, 0, 'nfcompra_c956e10c44b8f3dc2027efa1a15ab1331689884612.pdf'),
(359, 76, 4, '2023-06-29 00:00:00', 3200, 0, 'nfcompra_6f4dfb429c3071a0b928c819e27b60351689884554.pdf'),
(360, 50, 4, '2023-06-30 00:00:00', 350, 0, 'nfcompra_c7a335c56cf039334c844b212597f4bb1689882940.pdf'),
(361, 65, 4, '2023-06-30 00:00:00', 975, 0, 'nfcompra_40051e83d7c29a017ff530ce5071feeb1689882633.pdf'),
(362, 39, 4, '2023-07-03 00:00:00', 397.27, 0, 'nfcompra_f7fb95733805ed951091a9fde48f118c1689886405.pdf'),
(363, 58, 4, '2023-07-03 00:00:00', 975, 0, 'nfcompra_1f96aa9046105527c2287c8c5ef5452d1689882700.pdf'),
(364, 59, 4, '2023-07-03 00:00:00', 975, 0, 'nfcompra_361e760f0c6cc3a7f201e952da7096041689882659.pdf'),
(365, 60, 4, '2023-07-03 00:00:00', 350, 0, 'nfcompra_d73acb4f8945f55da3dce54ca39075df1689882684.pdf'),
(366, 79, 4, '2023-07-03 00:00:00', 1200, 0, 'nfcompra_5ca818c59441872b2c290f2507c4a7b61689885165.pdf'),
(367, 83, 4, '2023-07-03 00:00:00', 975, 0, 'nfcompra_4f5ef34dfd9d4195e7bbfe6806a71d4f1689883752.pdf'),
(368, 77, 4, '2023-07-03 00:00:00', 975, 0, 'nfcompra_9ddea3776af17dc254f5a0c2577a5b621689883425.pdf'),
(369, 89, 4, '2023-07-03 00:00:00', 1200, 0, 'nfcompra_6b86ee63bb0fb0b8dddd7d03318493041689885089.pdf'),
(370, 38, 4, '2023-07-05 00:00:00', 89.9, 0, 'nfcompra_1b865cd049a8bf45887133dbdc12e5971689885119.pdf'),
(371, 54, 4, '2023-07-17 00:00:00', 975, 0, 'nfcompra_1d311a80ac42d11648ace7f66aaf87531689881968.pdf'),
(372, 90, 4, '2023-07-11 00:00:00', 1530, 0, 'nfcompra_504eb1ca2638aea78975f145ba1ebc621689882595.pdf'),
(373, 54, 4, '2023-07-17 00:00:00', 975, 0, 'nfcompra_007f7b2fde35ecf9f5dfb44eb47294861690474355.pdf'),
(374, 88, 4, '2023-07-10 00:00:00', 1500, 0, 'nfcompra_fa9f4cb5825264c5c9bb2eba2c0779891689883525.pdf'),
(375, 83, 4, '2023-07-03 00:00:00', 975, 0, ''),
(376, 80, 4, '2023-07-11 00:00:00', 1905, 0, 'nfcompra_f5c59a9072258b0425353e191062fab41689883828.pdf'),
(377, 92, 4, '2023-07-11 00:00:00', 1905, 0, 'nfcompra_feaa0244192e5f37a0cf3b5c7a54cd9d1689884020.pdf'),
(378, 76, 4, '2023-07-01 00:00:00', 3200, 0, 'nfcompra_26f5cfeba3b55784cb7d890cd458829d1690473258.pdf'),
(379, 62, 4, '2023-07-01 00:00:00', 975, 0, 'nfcompra_5e792ab7db47bb65d2fe1819dafd26001690473698.pdf'),
(380, 61, 4, '2023-07-01 00:00:00', 975, 0, 'nfcompra_c6e03ef2647e4d7b009dd5afc95e6ca71690474040.pdf'),
(381, 84, 4, '2023-07-01 00:00:00', 1200, 0, 'nfcompra_45ae4d5d58608dd8955cea68ca51a36d1690474212.pdf'),
(382, 85, 4, '2023-07-01 00:00:00', 1200, 0, 'nfcompra_953190edcf165cc11042b82ce7d25d811690474252.pdf'),
(383, 82, 4, '2023-07-01 00:00:00', 1200, 0, 'nfcompra_07694d5ea6e97388fd78dce3dff1aa5b1690474301.pdf'),
(384, 76, 4, '2023-07-25 00:00:00', 3200, 0, 'nfcompra_4dc23100ad30f988c00ddcf55ea239b81691082245.pdf'),
(385, 60, 4, '2023-08-01 00:00:00', 350, 0, ''),
(386, 50, 3, '2023-07-31 00:00:00', 350, 0, 'nfcompra_a6da5b9753f2980dfa43d52b752910fc1691009024.pdf'),
(387, 88, 4, '2023-08-01 00:00:00', 1200, 0, 'nfcompra_7ffdfd4fb2ec95596ce0afb7651ebdba1691009595.pdf'),
(388, 83, 4, '2023-08-01 00:00:00', 975, 0, 'nfcompra_9aef087716a65933344f88d5a977ceea1691009795.pdf'),
(389, 77, 4, '2023-08-01 00:00:00', 975, 0, 'nfcompra_09e7dad1e3841d6b52555dcf17ecd8471691010014.pdf'),
(390, 84, 4, '2023-08-01 00:00:00', 1200, 0, 'nfcompra_099c6a37612329410a895686c6dada511691010217.pdf'),
(391, 85, 4, '2023-08-01 00:00:00', 1200, 0, 'nfcompra_7da1ea5800f38e899af46db3cc82a2781691010357.pdf'),
(392, 58, 4, '2023-08-02 00:00:00', 975, 0, 'nfcompra_670193cb7f126d84e54a02cbb05664a51691080154.pdf'),
(393, 59, 4, '2023-08-02 00:00:00', 975, 0, 'nfcompra_a12752dc39fe890257120572ca9815d91691080568.pdf'),
(394, 82, 4, '2023-07-31 00:00:00', 1200, 0, 'nfcompra_368ee3f428bfc285c2cf3b1b37a6d6c41691081657.pdf'),
(395, 61, 4, '2023-07-26 00:00:00', 975, 0, 'nfcompra_84896a6567c7be85b54f5ae71f5aa0d31691081994.pdf'),
(396, 62, 4, '2023-07-26 00:00:00', 975, 0, 'nfcompra_d5bf1d827391681f0d774be82c27749d1691082108.pdf'),
(397, 54, 4, '2023-08-01 00:00:00', 975, 0, 'nfcompra_d4049d6d29003d6fc98890bf992463c91691082410.pdf'),
(398, 79, 4, '2023-07-31 00:00:00', 1200, 0, 'nfcompra_588254dea44325d39fe5be43944629231691082565.pdf'),
(399, 92, 4, '2023-08-10 00:00:00', 1905, 0, 'nfcompra_44bc455ab78c1094d419155cde9c56b71692365948.pdf'),
(400, 93, 4, '2023-08-08 00:00:00', 1080, 0, 'nfcompra_8a2d2bf030610a433c594c74cf95c3511692366315.pdf'),
(401, 89, 4, '2023-08-17 00:00:00', 1530, 0, 'nfcompra_44e17e10b49041cda469d30a683e3e391692366796.pdf'),
(402, 38, 4, '2023-08-04 00:00:00', 89.9, 0, 'nfcompra_2d108d3971854e501dfff34e28d553cb1692367002.pdf'),
(403, 94, 4, '2023-08-31 00:00:00', 1600, 0, 'nfcompra_58c98a9cd58c622fe44bdc05cd3d17011693492768.pdf'),
(404, 95, 4, '2023-08-30 00:00:00', 1925, 0, 'nfcompra_09cfd3cf1e7168be3c9b1bd70973ccc51693492808.pdf'),
(405, 92, 4, '2023-09-11 00:00:00', 1905, 0, 'nfcompra_d0930a261f291660b81dfe5464e300bb1694526910.pdf'),
(406, 50, 4, '2023-08-31 00:00:00', 350, 0, 'nfcompra_ecae60d8e21b72445c419b05a89ffe191694527093.pdf'),
(407, 79, 4, '2023-09-01 00:00:00', 1200, 0, 'nfcompra_24592818f29a22c2d0e7462fb64606d31694527347.pdf'),
(408, 88, 4, '2023-09-01 00:00:00', 1200, 0, 'nfcompra_8df4d5744beb1dd3c7e238f7661ddb0f1694527726.pdf'),
(409, 54, 4, '2023-09-04 00:00:00', 975, 0, 'nfcompra_31c50adfcef67c142430cf671e739e981694528502.pdf'),
(410, 61, 4, '2023-08-30 00:00:00', 975, 0, 'nfcompra_6b6ae2d221eab3e0e7df5d722ef6acf21694528752.pdf'),
(411, 76, 4, '2023-08-30 00:00:00', 3200, 0, 'nfcompra_695a856ae012b397a8db97a5a0c4aafe1694528890.pdf'),
(412, 38, 4, '2023-09-05 00:00:00', 89.9, 0, 'nfcompra_5795858838e885882e9a4815e7ec40fe1694529461.pdf'),
(413, 83, 4, '2023-09-01 00:00:00', 975, 0, 'nfcompra_48a2b018b0a13da6c04cfc47420148061694529689.pdf'),
(414, 77, 4, '2023-09-01 00:00:00', 975, 0, 'nfcompra_429f933db80acc1c88aad8a21682dba21694529858.pdf'),
(415, 93, 4, '2023-08-31 00:00:00', 1500, 0, 'nfcompra_2d2957374740a12e67cf11c667c1fe5d1694531038.pdf'),
(416, 62, 4, '2023-09-13 00:00:00', 1530, 0, 'nfcompra_b08b4a8c222c5dee4054fe17776d9bcc1694788925.pdf'),
(417, 96, 4, '2023-09-20 00:00:00', 600, 0, 'nfcompra_999a3f132719690fdab4e79667f5e9d61695737826.pdf'),
(418, 96, 4, '2023-10-02 00:00:00', 1200, 0, 'nfcompra_1e39fc090da03d95e1ac843d1ec685011696864820.pdf'),
(419, 96, 4, '2023-11-01 00:00:00', 1200, 0, ''),
(420, 96, 4, '2023-12-01 00:00:00', 1200, 0, ''),
(421, 96, 4, '2024-01-02 00:00:00', 1200, 0, ''),
(422, 82, 4, '2023-09-25 00:00:00', 2250, 0, 'nfcompra_17a702b71b79540cb8596643a8cb044c1695738183.pdf'),
(423, 89, 4, '2023-09-26 00:00:00', 1530, 0, 'nfcompra_4d07eb61c59c2b9e4fe1b0d3ec48bc9e1695825772.pdf'),
(424, 62, 4, '2023-09-25 00:00:00', 975, 0, 'nfcompra_ffb95f05fa951c433a933427742d51791696862395.pdf'),
(425, 61, 4, '2023-09-25 00:00:00', 975, 0, 'nfcompra_e1d4448620e70589adab90668840030b1696862409.pdf'),
(426, 76, 4, '2023-09-25 00:00:00', 3200, 0, 'nfcompra_dee9b34b8fff578987f6f9aaa5c838c71696862367.pdf'),
(427, 50, 4, '2023-09-30 00:00:00', 350, 0, 'nfcompra_0164311be1eef55fd70fd8bc5526d7921696863471.pdf'),
(428, 79, 4, '2023-10-02 00:00:00', 1200, 0, 'nfcompra_ef5e529460ba49b811207a899bd956351696863620.pdf'),
(429, 54, 4, '2023-10-02 00:00:00', 975, 0, 'nfcompra_380697d5bf3dc9dc46c925549bb78bac1696863786.pdf'),
(430, 38, 4, '2023-10-05 00:00:00', 89.9, 0, 'nfcompra_b32ab6b298961f49db7285a0365f410d1696863953.pdf'),
(431, 83, 4, '2023-10-02 00:00:00', 975, 0, 'nfcompra_2f66dd7fb425f614d66d0eb40555db6b1696864133.pdf'),
(432, 77, 4, '2023-10-02 00:00:00', 975, 0, 'nfcompra_952f3191c9c9ad1c07403e2b6c5ecd491696864331.pdf'),
(433, 84, 4, '2023-10-02 00:00:00', 1200, 0, 'nfcompra_3f636c9136a7c0db5aa0b1b98fe035f41696864530.pdf'),
(434, 85, 4, '2023-10-02 00:00:00', 1200, 0, 'nfcompra_63514afc7203eb00a0186b8197c48a111696864655.pdf'),
(435, 92, 4, '2023-10-10 00:00:00', 1905, 0, 'nfcompra_7d897c615157525694950dd39b2478a31698332133.pdf'),
(436, 88, 4, '2023-10-02 00:00:00', 1500, 0, 'nfcompra_53c7f04d9777afc9c799dd41b7af724f1698332110.pdf'),
(437, 93, 4, '2023-10-02 00:00:00', 1200, 0, 'nfcompra_d2ee1cd322874c01503061d77b3c2c901698332373.pdf'),
(438, 89, 4, '2023-10-26 00:00:00', 1530, 0, 'nfcompra_2f0cf85aeab6da7ec7f9340403afb5bd1698763642.pdf'),
(439, 50, 3, '2023-10-31 00:00:00', 350, 0, ''),
(440, 79, 4, '2023-11-01 00:00:00', 1200, 0, '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `statuscobranca`
--

CREATE TABLE `statuscobranca` (
  `statuscobrancaID` int(11) NOT NULL,
  `nome` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `statuscobranca`
--

INSERT INTO `statuscobranca` (`statuscobrancaID`, `nome`) VALUES
(1, 'EM ABERTO'),
(2, 'PAGO'),
(3, 'CANCELADO');

-- --------------------------------------------------------

--
-- Estrutura da tabela `submenu`
--

CREATE TABLE `submenu` (
  `submenuID` int(11) NOT NULL,
  `titulo` varchar(255) NOT NULL,
  `ordem` int(11) NOT NULL,
  `link` varchar(255) NOT NULL,
  `icone` varchar(255) NOT NULL,
  `menuID` int(11) NOT NULL,
  `target` varchar(25) NOT NULL,
  `flagnovo` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `submenu`
--

INSERT INTO `submenu` (`submenuID`, `titulo`, `ordem`, `link`, `icone`, `menuID`, `target`, `flagnovo`) VALUES
(3, 'Usuários', 2, 'usuarios', 'fa fa-users', 3, '', 0),
(4, 'Papéis de usuários', 10, 'papeis', 'fa fa-address-card-o', 3, '', 0),
(5, 'Parâmetros', 20, 'parametros', 'fa fa-cogs', 3, '', 0),
(7, 'Categorias', 0, 'categoria', 'fa fa-cubes', 1, '', 0),
(14, 'Contato WhatsApp', 5, 'https://api.whatsapp.com/send?phone=5549999934272&text=Olá, vim pelo sistema de administração da InSource.', 'fa fa-whatsapp', 8, '_blank', 0),
(15, 'Suporte online', 5, 'https://insource.com.br/#contato', 'fa fa-comments-o', 8, '_blank', 0),
(16, 'Log', 1, 'log', 'fa fa-archive', 3, '', 0),
(35, 'Menu mais opções', 90, 'menumaisopcao', 'fa fa-cubes', 3, '', 0),
(42, 'Empresas', 0, 'empresas', 'fa fa-building', 1, '', 0),
(43, 'Serviços', 0, 'servicos', 'fa fa-cubes', 1, '', 0),
(44, 'Gerador Link WhatsApp', 0, 'https://insource.com.br/whatsapp-link', 'fa fa-whatsapp', 20, '_blank', 0),
(45, 'Forma de Pagamento', 0, 'formadepagamento', 'fa fa-dollar', 1, '', 0);

-- --------------------------------------------------------

--
-- Estrutura da tabela `submenumaisopcao`
--

CREATE TABLE `submenumaisopcao` (
  `submenumaisopcaoID` int(11) NOT NULL,
  `submenuID` int(11) NOT NULL,
  `titulo` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `icon` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `usuarioservico`
--

CREATE TABLE `usuarioservico` (
  `usuarioservicoID` int(11) NOT NULL,
  `usuarioID` int(11) NOT NULL,
  `servicoID` int(11) NOT NULL,
  `datacadastro` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `acaolog`
--
ALTER TABLE `acaolog`
  ADD PRIMARY KEY (`acaoLogID`);

--
-- Indexes for table `afiliado`
--
ALTER TABLE `afiliado`
  ADD PRIMARY KEY (`afiliadoID`);

--
-- Indexes for table `afiliadoservico`
--
ALTER TABLE `afiliadoservico`
  ADD PRIMARY KEY (`afiliadoservicoID`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categoria`
--
ALTER TABLE `categoria`
  ADD PRIMARY KEY (`categoriaID`);

--
-- Indexes for table `contato`
--
ALTER TABLE `contato`
  ADD PRIMARY KEY (`contatoID`);

--
-- Indexes for table `contatomensagem`
--
ALTER TABLE `contatomensagem`
  ADD PRIMARY KEY (`contatomensagemID`);

--
-- Indexes for table `empresa`
--
ALTER TABLE `empresa`
  ADD PRIMARY KEY (`empresaID`);

--
-- Indexes for table `empresausuario`
--
ALTER TABLE `empresausuario`
  ADD PRIMARY KEY (`empresausuarioID`),
  ADD KEY `empresausuario_empresa` (`empresaID`),
  ADD KEY `empresausuario_usuario` (`usuarioID`);

--
-- Indexes for table `favorito`
--
ALTER TABLE `favorito`
  ADD PRIMARY KEY (`favoritoID`);

--
-- Indexes for table `formapagamento`
--
ALTER TABLE `formapagamento`
  ADD PRIMARY KEY (`formapagamentoID`);

--
-- Indexes for table `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`logID`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`menuID`);

--
-- Indexes for table `menumaisopcao`
--
ALTER TABLE `menumaisopcao`
  ADD PRIMARY KEY (`menumaisopcaoID`),
  ADD KEY `menumaisopcao_menu` (`menuID`);

--
-- Indexes for table `netpromotescore`
--
ALTER TABLE `netpromotescore`
  ADD PRIMARY KEY (`netpromotescoreID`);

--
-- Indexes for table `papeldeusuario`
--
ALTER TABLE `papeldeusuario`
  ADD PRIMARY KEY (`papeldeusuarioID`);

--
-- Indexes for table `papelrelatorio`
--
ALTER TABLE `papelrelatorio`
  ADD PRIMARY KEY (`papelrelatorioID`),
  ADD KEY `papelrelatorio_papeldeusuario` (`papeldeusuarioID`),
  ADD KEY `papelrelatorio_relatorio` (`relatorioID`);

--
-- Indexes for table `parametrorelatorio`
--
ALTER TABLE `parametrorelatorio`
  ADD PRIMARY KEY (`parametrorelatorioID`),
  ADD KEY `parametrorelatorio_relatorio` (`relatorioID`);

--
-- Indexes for table `permissao`
--
ALTER TABLE `permissao`
  ADD PRIMARY KEY (`permissaoID`),
  ADD KEY `permissao_papel` (`papelDeUsuarioID`);

--
-- Indexes for table `produto`
--
ALTER TABLE `produto`
  ADD PRIMARY KEY (`produtoID`);

--
-- Indexes for table `produtocategoria`
--
ALTER TABLE `produtocategoria`
  ADD PRIMARY KEY (`produtocategoriaID`);

--
-- Indexes for table `produtofoto`
--
ALTER TABLE `produtofoto`
  ADD PRIMARY KEY (`produtofotoID`);

--
-- Indexes for table `relatorio`
--
ALTER TABLE `relatorio`
  ADD PRIMARY KEY (`relatorioID`),
  ADD KEY `relatorio_tipo` (`tipoRelatorioID`);

--
-- Indexes for table `servico`
--
ALTER TABLE `servico`
  ADD PRIMARY KEY (`servicoID`);

--
-- Indexes for table `servicocobranca`
--
ALTER TABLE `servicocobranca`
  ADD PRIMARY KEY (`servicocobrancaID`),
  ADD KEY `servicocobranca_servicoempresa` (`servicoempresaID`),
  ADD KEY `servicocobranca_statuscobranca` (`statuscobrancaID`);

--
-- Indexes for table `servicoempresa`
--
ALTER TABLE `servicoempresa`
  ADD PRIMARY KEY (`servicoempresaID`),
  ADD KEY `servicoempresa_servico` (`servicoID`),
  ADD KEY `servicoempresa_empresa` (`empresaID`);

--
-- Indexes for table `servicopagamento`
--
ALTER TABLE `servicopagamento`
  ADD PRIMARY KEY (`servicopagamentoID`),
  ADD KEY `servicopagamento_servicoempresa` (`servicoempresaID`),
  ADD KEY `servicopagamento_formapagamento` (`formapagamentoID`);

--
-- Indexes for table `statuscobranca`
--
ALTER TABLE `statuscobranca`
  ADD PRIMARY KEY (`statuscobrancaID`);

--
-- Indexes for table `submenu`
--
ALTER TABLE `submenu`
  ADD PRIMARY KEY (`submenuID`),
  ADD KEY `menu_submenumenu` (`menuID`);

--
-- Indexes for table `submenumaisopcao`
--
ALTER TABLE `submenumaisopcao`
  ADD PRIMARY KEY (`submenumaisopcaoID`),
  ADD KEY `submenumaisopcao_submenu` (`submenuID`);

--
-- Indexes for table `usuarioservico`
--
ALTER TABLE `usuarioservico`
  ADD PRIMARY KEY (`usuarioservicoID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `acaolog`
--
ALTER TABLE `acaolog`
  MODIFY `acaoLogID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `afiliado`
--
ALTER TABLE `afiliado`
  MODIFY `afiliadoID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `afiliadoservico`
--
ALTER TABLE `afiliadoservico`
  MODIFY `afiliadoservicoID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `categoria`
--
ALTER TABLE `categoria`
  MODIFY `categoriaID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `contato`
--
ALTER TABLE `contato`
  MODIFY `contatoID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `contatomensagem`
--
ALTER TABLE `contatomensagem`
  MODIFY `contatomensagemID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `empresa`
--
ALTER TABLE `empresa`
  MODIFY `empresaID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `empresausuario`
--
ALTER TABLE `empresausuario`
  MODIFY `empresausuarioID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `favorito`
--
ALTER TABLE `favorito`
  MODIFY `favoritoID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `formapagamento`
--
ALTER TABLE `formapagamento`
  MODIFY `formapagamentoID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `logID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7399;

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `menuID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `menumaisopcao`
--
ALTER TABLE `menumaisopcao`
  MODIFY `menumaisopcaoID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `netpromotescore`
--
ALTER TABLE `netpromotescore`
  MODIFY `netpromotescoreID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `papeldeusuario`
--
ALTER TABLE `papeldeusuario`
  MODIFY `papeldeusuarioID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `papelrelatorio`
--
ALTER TABLE `papelrelatorio`
  MODIFY `papelrelatorioID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `parametrorelatorio`
--
ALTER TABLE `parametrorelatorio`
  MODIFY `parametrorelatorioID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identificador';

--
-- AUTO_INCREMENT for table `permissao`
--
ALTER TABLE `permissao`
  MODIFY `permissaoID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1185;

--
-- AUTO_INCREMENT for table `produto`
--
ALTER TABLE `produto`
  MODIFY `produtoID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `produtocategoria`
--
ALTER TABLE `produtocategoria`
  MODIFY `produtocategoriaID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `produtofoto`
--
ALTER TABLE `produtofoto`
  MODIFY `produtofotoID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `relatorio`
--
ALTER TABLE `relatorio`
  MODIFY `relatorioID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identificador';

--
-- AUTO_INCREMENT for table `servico`
--
ALTER TABLE `servico`
  MODIFY `servicoID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `servicocobranca`
--
ALTER TABLE `servicocobranca`
  MODIFY `servicocobrancaID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=562;

--
-- AUTO_INCREMENT for table `servicoempresa`
--
ALTER TABLE `servicoempresa`
  MODIFY `servicoempresaID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;

--
-- AUTO_INCREMENT for table `servicopagamento`
--
ALTER TABLE `servicopagamento`
  MODIFY `servicopagamentoID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=441;

--
-- AUTO_INCREMENT for table `statuscobranca`
--
ALTER TABLE `statuscobranca`
  MODIFY `statuscobrancaID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `submenu`
--
ALTER TABLE `submenu`
  MODIFY `submenuID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `submenumaisopcao`
--
ALTER TABLE `submenumaisopcao`
  MODIFY `submenumaisopcaoID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usuarioservico`
--
ALTER TABLE `usuarioservico`
  MODIFY `usuarioservicoID` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Limitadores para a tabela `empresausuario`
--
ALTER TABLE `empresausuario`
  ADD CONSTRAINT `empresausuario_empresa` FOREIGN KEY (`empresaID`) REFERENCES `empresa` (`empresaID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `empresausuario_usuario` FOREIGN KEY (`usuarioID`) REFERENCES `usuario` (`usuarioID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limitadores para a tabela `menumaisopcao`
--
ALTER TABLE `menumaisopcao`
  ADD CONSTRAINT `menumaisopcao_menu` FOREIGN KEY (`menuID`) REFERENCES `menu` (`menuID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limitadores para a tabela `papelrelatorio`
--
ALTER TABLE `papelrelatorio`
  ADD CONSTRAINT `papelrelatorio_papeldeusuario` FOREIGN KEY (`papeldeusuarioID`) REFERENCES `papeldeusuario` (`papeldeusuarioID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `papelrelatorio_relatorio` FOREIGN KEY (`relatorioID`) REFERENCES `relatorio` (`relatorioID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limitadores para a tabela `parametrorelatorio`
--
ALTER TABLE `parametrorelatorio`
  ADD CONSTRAINT `parametrorelatorio_relatorio` FOREIGN KEY (`relatorioID`) REFERENCES `relatorio` (`relatorioID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limitadores para a tabela `permissao`
--
ALTER TABLE `permissao`
  ADD CONSTRAINT `permissao_papel` FOREIGN KEY (`papelDeUsuarioID`) REFERENCES `papeldeusuario` (`papeldeusuarioID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limitadores para a tabela `servicocobranca`
--
ALTER TABLE `servicocobranca`
  ADD CONSTRAINT `servicocobranca_servicoempresa` FOREIGN KEY (`servicoempresaID`) REFERENCES `servicoempresa` (`servicoempresaID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `servicocobranca_statuscobranca` FOREIGN KEY (`statuscobrancaID`) REFERENCES `statuscobranca` (`statuscobrancaID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limitadores para a tabela `servicoempresa`
--
ALTER TABLE `servicoempresa`
  ADD CONSTRAINT `servicoempresa_empresa` FOREIGN KEY (`empresaID`) REFERENCES `empresa` (`empresaID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `servicoempresa_servico` FOREIGN KEY (`servicoID`) REFERENCES `servico` (`servicoID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limitadores para a tabela `servicopagamento`
--
ALTER TABLE `servicopagamento`
  ADD CONSTRAINT `servicopagamento_formapagamento` FOREIGN KEY (`formapagamentoID`) REFERENCES `formapagamento` (`formapagamentoID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `servicopagamento_servicoempresa` FOREIGN KEY (`servicoempresaID`) REFERENCES `servicoempresa` (`servicoempresaID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limitadores para a tabela `submenu`
--
ALTER TABLE `submenu`
  ADD CONSTRAINT `menu_submenumenu` FOREIGN KEY (`menuID`) REFERENCES `menu` (`menuID`) ON DELETE CASCADE;
COMMIT;

