INSERT INTO `hesk_kb_articles` VALUES (61,1,'2025-08-13 19:17:01',6,'Gerar simulação de quitação futura dos contratos imobiliários','<p>Acesse o contrato em questão, depois clique em <strong>Processos -&gt; Fórmula Visual -&gt; Simula/Atualiza Cálculo de Imóveis</strong></p>\n<p><img src=\"data:image/png;base64,[encoded data, 56744 characters]\" alt=\"w9PC3R7NfOVeQAAAABJRU5ErkJggg==\" width=\"645\" height=\"431\" /></p>\n<p>Após a simulação caso deseje, pode exportar os registros.</p>\n<p><img src=\"data:image/png;base64,[encoded data, 110804 characters]\" alt=\"wK0ceZ0vMu1wgAAAABJRU5ErkJggg==\" width=\"738\" height=\"514\" /></p>','',0,0,12,'0','1','0',20,'<li class=\"smaller\">13-08-2025 16:17:01 | enviado por Vinicio Faria (vinicio_faria)</li>',''),(62,4,'2025-09-11 12:21:45',6,'Diagrama de Movimentos da Coligada 28 - Lajes Corp','<p>Segue abaixo o diagrama de movimentos da coligada 28 - Lajes Corp Empreendimentos</p>\n<p><img src=\"https://suporte.tecpav.com.br/admin/download_attachment.php?kb_att=102\" alt=\"\" width=\"694\" height=\"949\" /></p>','',0,0,2,'1','1','0',30,'<li class=\"smaller\">11-09-2025 09:21:45 | enviado por Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">11-09-2025 09:22:16 | modificado por Vinicio Faria (vinicio_faria)</li>','102#Movimento-1.png,'),(63,4,'2025-09-23 22:17:32',6,'Lista dos tipos de projetos no TOTVS RM','<p>Essa é a lista dos tipos de projetos cadastrados no sistema.</p>\n<table style=\"border-collapse:collapse;width:630px;border-spacing:0px;border-color:#000000;\" border=\"0\" width=\"312\" cellspacing=\"0\" cellpadding=\"0\"><colgroup><col style=\"width:48px;\" width=\"64\" /> <col style=\"width:581px;\" width=\"248\" /> </colgroup>\n<tbody>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;width:48pt;border-color:#000000;\" width=\"64\" height=\"19\">APO</td>\n<td style=\"width:186pt;border-color:#000000;\" width=\"248\">APOIO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">PAV</td>\n<td style=\"border-color:#000000;\">PAVIMENTAÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">ROD</td>\n<td style=\"border-color:#000000;\">RODOVIA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">CAP</td>\n<td style=\"border-color:#000000;\">CAPA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">IND</td>\n<td style=\"border-color:#000000;\">INDIRETO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">OAC</td>\n<td style=\"border-color:#000000;\">OBRA DE ARTE CORRENTE</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">SIN</td>\n<td style=\"border-color:#000000;\">SINALIZAÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">TER</td>\n<td style=\"border-color:#000000;\">TERRAPLANAGEM</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">SES</td>\n<td style=\"border-color:#000000;\">SISTEMA DE ESGOTAMENTO SANTIARIO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">EEE</td>\n<td style=\"border-color:#000000;\">ESTAÇÃO ELEVATÓRIA DE ESGOTO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">RLI</td>\n<td style=\"border-color:#000000;\">REDE DE LIGAÇÃO DE ESGOTO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">ATR</td>\n<td style=\"border-color:#000000;\">ATERRO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">ADM</td>\n<td style=\"border-color:#000000;\">ADMINISTRAÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">IMP</td>\n<td style=\"border-color:#000000;\">IMPLANTAÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">CAL</td>\n<td style=\"border-color:#000000;\">CALÇADA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">GAP</td>\n<td style=\"border-color:#000000;\">GALERIA DE AGUAS PLUVIAIS</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">MRE</td>\n<td style=\"border-color:#000000;\">MICRO REVESTIMENTO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">OAE</td>\n<td style=\"border-color:#000000;\">OBRA DE ARTES ESPECIAL</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">DRE</td>\n<td style=\"border-color:#000000;\">DRENAGEM</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">USN</td>\n<td style=\"border-color:#000000;\">USINAGEM</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">RES</td>\n<td style=\"border-color:#000000;\">RESTAURAÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">BRI</td>\n<td style=\"border-color:#000000;\">BRITADOR</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">SUB</td>\n<td style=\"border-color:#000000;\">SUBEMPREITA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">CON</td>\n<td style=\"border-color:#000000;\">CONSERVA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">MVE</td>\n<td style=\"border-color:#000000;\">MAQUINAS VEICULOS E EQUIPAMENTOS</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">NFT</td>\n<td style=\"border-color:#000000;\">NÃO FATURADO - CMVE</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">ROT</td>\n<td style=\"border-color:#000000;\">ROTATÓRIA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">OPE</td>\n<td style=\"border-color:#000000;\">OPERAÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">OBC</td>\n<td style=\"border-color:#000000;\">OBRAS COMPLEMENTARES</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">AMB</td>\n<td style=\"border-color:#000000;\">AMBIENTAL</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">CNL</td>\n<td style=\"border-color:#000000;\">CANAL</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">URB</td>\n<td style=\"border-color:#000000;\">URBANIZAÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">RED</td>\n<td style=\"border-color:#000000;\">REDE</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">ETE</td>\n<td style=\"border-color:#000000;\">ESTAÇÃO DE TRATAMENTO DE ESGOTO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">LOC</td>\n<td style=\"border-color:#000000;\">LOCAÇÕES</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">MAN</td>\n<td style=\"border-color:#000000;\">MANUTENÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">SAA</td>\n<td style=\"border-color:#000000;\">SISTEMA DE ABASTECIMENTO DE ÁGUA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">EEA</td>\n<td style=\"border-color:#000000;\">ESTAÇÃO ELEVATÓRIA DE ÁGUA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">OFI</td>\n<td style=\"border-color:#000000;\">OFICINA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">IRR</td>\n<td style=\"border-color:#000000;\">IRRIGAÇÃO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">FER</td>\n<td style=\"border-color:#000000;\">FERROVIA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">CCI</td>\n<td style=\"border-color:#000000;\">CONSTRUÇÃO CIVIL</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">COM</td>\n<td style=\"border-color:#000000;\">COMERCIAL</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">MET</td>\n<td style=\"border-color:#000000;\">METROPOLITANA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">LIM</td>\n<td style=\"border-color:#000000;\">LIMPEZA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">BOO</td>\n<td style=\"border-color:#000000;\">LIMBO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">SUP</td>\n<td style=\"border-color:#000000;\">SUPERESTRUTURA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">ALM</td>\n<td style=\"border-color:#000000;\">ALMOXARIFADO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">ARV</td>\n<td style=\"border-color:#000000;\">ARVORE</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">PCA</td>\n<td style=\"border-color:#000000;\">PRAÇAS</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">PLA</td>\n<td style=\"border-color:#000000;\">PLANTIO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">POD</td>\n<td style=\"border-color:#000000;\">PODA</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">VIV</td>\n<td style=\"border-color:#000000;\">VIVEIRO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">PMO</td>\n<td style=\"border-color:#000000;\">PREMOLDADO</td>\n</tr>\n<tr style=\"height:14.4pt;\">\n<td style=\"height:14.4pt;border-color:#000000;\" height=\"19\">PTG</td>\n<td style=\"border-color:#000000;\">PETROENGE</td>\n</tr>\n</tbody>\n</table>\n<p> </p>','',0,0,9,'1','1','1',80,'<li class=\"smaller\">23-09-2025 19:17:32 | enviado por Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">23-09-2025 19:17:48 | modificado por Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">23-09-2025 19:18:00 | modificado por Vinicio Faria (vinicio_faria)</li>',''),(64,4,'2025-10-13 14:16:38',6,'Tipos de centros de custos - TOTVS RM','<p><strong>Tipos de centros de custos - TOTVS RM</strong></p>\n<table style=\"border-collapse:collapse;width:540px;\" border=\"0\" width=\"359\" cellspacing=\"0\" cellpadding=\"0\"><colgroup><col style=\"width:85px;\" width=\"64\" /> <col style=\"width:454px;\" width=\"295\" /> </colgroup>\n<tbody>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;width:48pt;\" width=\"64\" height=\"20\">ADM</td>\n<td style=\"width:221pt;\" width=\"295\">ADMINISTRACAO</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">CNT</td>\n<td>CONTRATOS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">COM</td>\n<td>COMERCIAL</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">DIV</td>\n<td>DIVERSOS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">EMP</td>\n<td>EMPREENDIMENTOS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">EQU</td>\n<td>AGRUPAMENTO DE EQUIPAMENTOS DA CMVE</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">ESG</td>\n<td>MEIO AMBIENTE</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">FIN</td>\n<td>FINANCEIRO</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">IMB</td>\n<td>IMOBILIZACOES</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">IMV</td>\n<td>IMOVEIS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">INV</td>\n<td>INVESTIMENTOS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">LOC</td>\n<td>LOCAÇÕES</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">MAQ</td>\n<td>AGRUPAMENTO DE MAQUINAS DA CMVE</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">MVE</td>\n<td>MAQUINAS, VEICULOS E EQUIPAMENTOS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">OPR</td>\n<td>OPERACOES</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">PLN</td>\n<td>PLANEJAMENTO</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">Q07L14</td>\n<td>Quadra 14 Lote 07</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">TMP</td>\n<td>TEMPORARIO</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">USN</td>\n<td>USINA DE ASFALTOS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">VEI</td>\n<td>AGRUPAMENTO DE VEICULOS DA CMVE</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">APT</td>\n<td>CCUSTOS APT</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">LOT</td>\n<td>LOTES</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">APO</td>\n<td>ESTRUTURAS DE APOIO</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">FND</td>\n<td>FUNDOS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">FSC</td>\n<td>FISCAL</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">FTB</td>\n<td>FUNDO TRABALHISTA</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">SRV</td>\n<td>SECAO TECNICA</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">TER</td>\n<td>MVE DE TERCEIROS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">MSA</td>\n<td>Locação</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">PRD</td>\n<td>PRODUCAO</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">SOC</td>\n<td>PROVISORIO</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">CON</td>\n<td>CONSTRUCAO</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">PEN</td>\n<td>PENDENCIA</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">TST</td>\n<td>TESTE</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">CER</td>\n<td>CERCAS</td>\n</tr>\n<tr style=\"height:15pt;\">\n<td style=\"height:15pt;\" height=\"20\">ENE</td>\n<td>ENERGIA SOLAR</td>\n</tr>\n</tbody>\n</table>','',0,0,5,'1','1','1',90,'<li class=\"smaller\">13-10-2025 11:16:38 | enviado por Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">13-10-2025 11:16:59 | modificado por Vinicio Faria (vinicio_faria)</li>',''),(65,4,'2025-10-14 11:46:27',6,'ATUALIZAÇÃO DO TSS TOTVS RM','<p>Fazer Download das versões atualizadas do APPSERVER, SCHEMAS, URLs, APO, em seguida descompactar.</p>\n<ol>\n<li>Parar Serviço do TSS</li>\n<li>Fazer backup da pasta de instalação do TSS <strong>\"C:\\totvs\\TSS\\\"</strong></li>\n<li>Fazer backup da base TSS<br />Sequencia de atualizações:</li>\n<li>APPSERVER:<br />   - Apagar o conteúdo da pasta <strong>C:\\totvs\\TSS\\</strong><strong>BIN\\APPServer\\</strong> do TSS <strong>exceto</strong> os arquivos<strong> \"Appserver.ini\"</strong> e <strong>\"Appserver - Console\"</strong> TSS e copiar o conteúdo do download APPSERVER.</li>\n<li>SCHEMAS:<br />   - Sobrepor o conteúdo do Download na pasra <strong>C:\\totvs\\TSS\\schemas\\</strong> do TSS</li>\n<li>URL:<br />   Salvar o conteúdo do Download URL na pasta <strong>C:\\totvs\\TSS\\system\\</strong> do TSS, desmarcar a opção de somente leitura nas propriedades</li>\n<li>RPO&gt;<br />   Sobrepor o conteúdo do Download RPO na pasta <strong>C:\\totvs\\TSS\\APO\\</strong></li>\n<li>Reiniciar o serviço do TSS</li>\n</ol>\n<p>Link de exemplo com as instruções:</p>\n<p><a title=\"https://centraldeatendimento.totvs.com/hc/pt-br/articles/360025394911-Cross-Segmentos-TSS-Transmiss%C3%A3o-de-Documentos-Eletr%C3%B4nicos-Atualiza%C3%A7%C3%A3o-das-URLs-do-TSS?source=search\" href=\"https://centraldeatendimento.totvs.com/hc/pt-br/articles/360025394911-Cross-Segmentos-TSS-Transmiss%C3%A3o-de-Documentos-Eletr%C3%B4nicos-Atualiza%C3%A7%C3%A3o-das-URLs-do-TSS?source=search\" target=\"_blank\" rel=\"noreferrer noopener\">https://centraldeatendimento.totvs.com/hc/pt-br/articles/360025394911-Cross-Segmentos-TSS-Transmiss%C3%A3o-de-Documentos-Eletr%C3%B4nicos-Atualiza%C3%A7%C3%A3o-das-URLs-do-TSS?source=search</a></p>','',0,0,5,'1','1','1',100,'<li class=\"smaller\">14-10-2025 08:46:27 | enviado por Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">14-10-2025 08:54:01 | modificado por Disley Oliveira (disley_oliveira)</li>',''),(66,4,'2025-10-14 20:28:41',6,'Tipos de MVE','<p><strong>Tipos de MVE</strong></p>\n<p><strong>TQA</strong> = Tanque do comboio</p>\n<p><strong>MVE</strong> - Máquina, Veículos e Equipamentos - Recebe por mês - Manutenção na obra - Combustível</p>\n<p><strong>TER</strong> = Terceiros - Veículos Maiores - MVE Terceiros - Medição</p>\n<p><strong>AVT</strong> = Avulso - Ferramenta ou veículo de terceiros - Desconto (sem medição, controle gerencial). MVE</p>\n<p><strong>LOC</strong> = TECPAV Locação - 2025 - Vinicius Marra - MVE</p>\n<p><strong>TQC</strong> = Tanque de consumo do MVE - Motor maçarico - MVE</p>\n<p><strong>PTF</strong> = Caminhão Plataforma - MVE - Recebe por viagem </p>\n<p><strong>AVU</strong> = Avulso Próprio</p>','',0,0,5,'1','1','0',290,'<li class=\"smaller\">14-10-2025 17:28:41 | enviado por Vinicio Faria (vinicio_faria)</li>',''),(67,4,'2025-10-29 11:42:28',6,'Parametrização do Tipo de Movimento - Reforma Tributária','<p>Veja o vídeo abaixo da parametrização do tipo de movimento - Reforma Tributária.</p>\n<p> </p>\n<p><iframe  title=\"YouTube video player\" src=\"https://www.youtube.com/embed/ydDyhUbg4as?si=fsV_Lpv--597FhF8\" width=\"560\" height=\"315\" alt=\"ydDyhUbg4as?si=fsV_Lpv--597FhF8\"  frameborder=\"0\" allowfullscreen></iframe></p>','',0,0,2,'1','1','1',110,'<li class=\"smaller\">29-10-2025 08:42:28 | enviado por Vinicio Faria (vinicio_faria)</li>','');

--
-- Table structure for table `hesk_kb_attachments`
--

CREATE TABLE `hesk_kb_attachments` (
  `att_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `saved_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `real_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `size` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`att_id`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_kb_attachments`
--

INSERT INTO `hesk_kb_attachments` VALUES (32,'e5a152daaab822e298e6f14b34694e4b.png','Fluxo-do-Processo-Financeiro-e-Contabil.png',45168),(36,'349c58056b8ec70616c320cd4efd2ffb.png','Rastreamento-de-movimentos1.png',96289),(35,'2df61d9cf9da35f70cab57c38479b20a.png','Rastreamento-de-movimentos2.png',85977),(37,'e57e8c8a81d92a141b4f44cb1c55b0a4.png','Rastreamento-de-movimentos3.png',73378),(39,'ae927491c2f6abb9576d566bdf589de7.png','filtros-01.png',131351),(40,'0545b6aa8b44563a58aa1ddb440429dd.png','filtros-02.png',132172),(41,'c05642bb90db9d9c3e2b2f521777d371.png','filtros-03.png',164770),(42,'f2f5b5ea779cb4fd4f045df3cbf2c015.png','filtros-05.png',159991),(43,'b8657b69b2472ba37be19024d330e58c.png','filtros-04.png',178714),(44,'40cf6535fc1335663e4bd3eb778756b4.png','Gestao-de-Pessoas.png',67922),(45,'81febeb4b869dc08881c680a3b93b19d.png','Funcoes.png',67374),(46,'476e75ab39336d10a48e9da74c101bdf.png','Funcao.png',31128),(58,'59a5104451892ad676727cdd1a108999.png','Fluxo-do-Processo-de-Compras-e-Aprovacao.png',203320),(49,'7ba842e852c2e3839fa287fe16955f27.png','Folha-de-pagamento.png',52057),(50,'e805e893fe3c4202e5176663128d4a1e.png','Secoes.png',86646),(51,'36c16e3835e1c9a8a4d6a58c7c1ca678.png','Secao.png',42329),(60,'d03cd9b1cc0c459039b09df5ecf0e5f1.png','Arquivos.png',121649),(61,'ee7bcd6f24e93cd3e4b7217f16fd2a80.png','Tags.png',62882),(62,'22762e2691421450fa92fdac8ceab70f.png','Servicos.png',97074),(63,'e4b27326de52744e5ed540008b771121.xlsx','DataServer-para-WebServices.xlsx',5333013),(64,'eca18d03f7d453a7e8dd41085c76bce0.png','Fluig-Plataform.png',81877),(72,'8b9402f46db82d5a7f584ca7540efb39.png','Movimentos1.png',119453),(77,'a0fa3bf3c574f2b83567e4b7ad22b5d5.png','Movimento2.png',92507),(74,'7ebd57254b2b3e6e8fdd0c278a4902d9.png','Movimento3.png',114594),(78,'8aed9422a98f4faf43193b87ed0d843d.png','Movimento1.png',92021),(79,'e3e3b9e1526a991306601956338aaa07.png','Movimento2.png',92507),(80,'86c2a8ef5115f14a9da407be54a4c0ea.png','Movimento3.png',93230),(81,'aebc8a55e690c917953a9f56d826ff75.png','Movimento1.png',125310),(82,'3a7c417522698ded245668d2fc7dfd6b.png','Movimento2.png',88666),(83,'01c1c0e28cb854e9b3d2d08117ce8c45.png','Movimento3.png',97672),(84,'f9e120c2b00b8d482f8c79894cec60e4.png','Movimento1.png',125310),(85,'98f2cb249b4d7b023b65e9dc817369fb.png','Movimento2.png',88666),(86,'32153b0c43c7dbd42dad18f466822346.png','Movimento3.png',97672),(87,'cc7649a3d76ef7157f3865478cc527c1.png','Movimento-1.png',151335),(88,'08e068038d37d6a257cf6048957150c3.png','Movimento-2.png',220956),(89,'0d97a026def23e80daf6da30c27e6149.png','Movimento-3.png',282883),(90,'950bafb074b3b98944014ac8d1ec6984.png','Movimento-1.png',270438),(91,'b16e4b193552e8519cd42d1b580f5f3e.png','Movimento-1.png',295077),(92,'c4c1c68d43c3899111b5e655f2761f7c.png','Movimento-1.png',363115),(93,'8befae4179fe4b2744ffa2f3f7061707.png','Movimento-1.png',289962),(95,'2e03e3d53d9d30bf8af327fe8423a345.png','Movimento-1.png',219042),(96,'5c958700c2d5355a10a624378ef8a214.png','Movimento-1.png',287306),(97,'d759c789428a3072e47ce51e02fa3f9f.png','Movimento-1.png',287306),(98,'244d292c311daf9314b2950354a6ea65.png','Movimento-1.png',281308),(99,'696b25651fcdd448a603edacceb24d52.png','Movimento-1.png',272195),(102,'ee592c542087a86503127dafb723412a.png','Movimento-1.png',93881),(101,'c1dbfc71f81a2de52610791ad693c832.msg','Erro-inesperado-My-Fluig.msg',575488);

--
-- Table structure for table `hesk_kb_categories`
--

CREATE TABLE `hesk_kb_categories` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `parent` smallint unsigned NOT NULL,
  `articles` smallint unsigned NOT NULL DEFAULT '0',
  `articles_private` smallint unsigned NOT NULL DEFAULT '0',
  `articles_draft` smallint unsigned NOT NULL DEFAULT '0',
  `cat_order` smallint unsigned NOT NULL,
  `type` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `parent` (`parent`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_kb_categories`
--

INSERT INTO `hesk_kb_categories` VALUES (1,'Base de conhecimento',0,5,0,0,10,'0'),(4,'TI Sistemas',1,4,36,0,20,'1'),(7,'TI Usuários e Segurança',1,0,1,0,30,'1');

--
-- Table structure for table `hesk_log_overdue`
--

CREATE TABLE `hesk_log_overdue` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ticket` mediumint unsigned NOT NULL,
  `category` smallint unsigned NOT NULL,
  `priority` enum('0','1','2','3') COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` tinyint unsigned NOT NULL,
  `owner` smallint unsigned NOT NULL DEFAULT '0',
  `due_date` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
  `comments` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket` (`ticket`),
  KEY `category` (`category`),
  KEY `priority` (`priority`),
  KEY `status` (`status`),
  KEY `owner` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_log_overdue`
--


--
-- Table structure for table `hesk_logins`
--

CREATE TABLE `hesk_logins` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `number` tinyint unsigned NOT NULL DEFAULT '1',
  `last_attempt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=6561 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_logins`
--

INSERT INTO `hesk_logins` VALUES (147,'74.235.59.81',1,'2025-03-19 20:30:08'),(1122,'170.238.52.79',4,'2025-06-23 23:37:39'),(3315,'177.125.248.129',4,'2025-07-22 16:08:52'),(724,'148.222.206.241',3,'2025-04-25 14:02:30'),(1117,'179.60.172.133',3,'2025-06-23 20:01:21'),(1309,'135.232.19.45',1,'2025-06-25 13:50:50'),(1306,'104.47.73.126',1,'2025-06-25 13:47:36'),(3134,'177.125.248.215',4,'2025-07-18 12:24:09'),(2911,'168.90.249.138',1,'2025-07-15 12:25:17'),(2014,'200.7.9.86',1,'2025-07-01 11:45:47'),(3500,'189.40.79.192',1,'2025-07-23 18:30:27'),(3844,'179.60.172.217',1,'2025-07-30 10:47:56'),(4507,'45.184.217.151',1,'2025-08-11 22:59:07'),(4924,'179.127.250.209',3,'2025-08-23 11:20:15'),(5122,'190.124.54.148',7,'2025-08-28 20:02:25'),(5343,'189.27.20.253',2,'2025-09-04 19:29:35'),(5822,'177.30.66.143',10,'2025-09-26 11:59:51'),(6452,'177.174.213.108',1,'2025-10-24 18:30:31'),(6436,'45.182.72.119',7,'2025-10-23 20:13:22');

--
-- Table structure for table `hesk_mail`
--

CREATE TABLE `hesk_mail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from` smallint unsigned NOT NULL,
  `to` smallint unsigned NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `read` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `deletedby` smallint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `from` (`from`),
  KEY `to` (`to`,`read`,`deletedby`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_mail`
--

INSERT INTO `hesk_mail` VALUES (1,9999,1,'Hesk quick start guide','</p><div style=\"text-align:justify; padding-left: 10px; padding-right: 10px;\">\r\n\r\n<h2 style=\"padding-left:0px\">Welcome to Hesk, an excellent tool for improving your customer support!</h2>\r\n\r\n<h3>Below is a short guide to help you get started.</h3>\r\n\r\n<div class=\"main__content notice-flash \">\r\n<div class=\"notification orange\">\r\nAn up-to-date and expanded guide is available at <a href=\"https://www.hesk.com/knowledgebase/?article=109\" target=\"_blank\">Hesk online Quick Start Guide</a>.</div>\r\n</div>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #1: Set up your profile</h3>\r\n\r\n<ol>\r\n<li>go to <a href=\"profile.php\">Profile</a>,</li>\r\n<li>set your name and email address.</li>\r\n</ol>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #2: Configure Hesk</h3>\r\n\r\n<ol>\r\n<li>go to <a href=\"admin_settings_general.php\">Settings</a>,</li>\r\n<li>for a quick start, modify these settings on the \"General\" tab:<br><br>\r\n<b>Website title</b> - enter the title of your main website (not your help desk),<br>\r\n<b>Website URL</b> - enter the URL of your main website,<br>\r\n<b>Webmaster email</b> - enter an alternative email address people can contact in case your Hesk database is down<br>&nbsp;\r\n</li>\r\n<li>you can come back to the settings page later and explore all the options. To view details about a setting, click the [?]</li>\r\n</ol>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #3: Add support categories</h3>\r\n\r\n<p>Go to <a href=\"manage_categories.php\">Categories</a> to add support ticket categories.</p>\r\n<p>You cannot delete the default category, but you can rename it.</p>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #4: Add your support team members</h3>\r\n\r\n<p>Go to <a href=\"manage_users.php\">Team</a> to create new support staff accounts.</p>\r\n<p>You can use two user types in Hesk:</p>\r\n<ul>\r\n<li><b>Administrators</b> who have full access to all Hesk features</li>\r\n<li><b>Staff</b> who you can restrict access to categories and features</li>\r\n</ul>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #5: Useful tools</h3>\r\n\r\n<p>You can do a lot in the <a href=\"banned_emails.php\">Tools</a> section, for example:</p>\r\n<ul>\r\n<li>create custom ticket statuses,</li>\r\n<li>add custom input fields to the &quot;Submit a ticket&quot; form,</li>\r\n<li>make public announcements (Service messages),</li>\r\n<li>modify email templates,</li>\r\n<li>ban disruptive customers,</li>\r\n<li>and more.</li>\r\n</ul>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #6: Create a Knowledgebase</h3>\r\n\r\n<p>A Knowledgebase is a collection of articles, guides, and answers to frequently asked questions, usually organized in multiple categories.</p>\r\n<p>A clear and comprehensive knowledgebase can drastically reduce the number of support tickets you receive, thereby saving you significant time and effort in the long run.</p>\r\n<p>Go to <a href=\"manage_knowledgebase.php\">Knowledgebase</a> to create categories and write articles for your knowledgebase.</p>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #7: Don\'t repeat yourself</h3>\r\n\r\n<p>Sometimes several support tickets address the same issues - allowing you to use pre-written (&quot;canned&quot;) responses.</p>\r\n<p>To compose canned responses, go to the <a href=\"manage_canned.php\">Templates &gt; Responses</a> page.</p>\r\n<p>Similarly, you can create <a href=\"manage_ticket_templates.php\">Templates &gt; Tickets</a> if your staff will be submitting support tickets on the client\'s behalf, for example, from telephone conversations.</p>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #8: Secure your help desk</h3>\r\n\r\n<p>Make sure your help desk is as secure as possible by going through the <a href=\"https://www.hesk.com/knowledgebase/?article=82\">Hesk security checklist</a>.</p>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #9: Stay updated</h3>\r\n\r\n<p>Hesk regularly receives improvements and bug fixes; make sure you know about them!</p>\r\n<ul>\r\n<li>for fast notifications, <a href=\"https://x.com/HESKdotCOM\" rel=\"nofollow\">follow Hesk on <b>X</b></a></li>\r\n<li>for email notifications, subscribe to our low-volume, zero-spam <a href=\"https://www.hesk.com/newsletter.php\">newsletter</a></li>\r\n</ul>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #10: Look professional</h3>\r\n\r\n<p><a href=\"https://www.hesk.com/get/hesk3-license\">Remove &quot;Powered by&quot; links</a> to support Hesk development and make it look more professional.</p>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Step #11: Too much hassle? Switch to Hesk Cloud for the ultimate experience</h3>\r\n\r\n<p>Experience the best of Hesk by moving your help desk into the Hesk Cloud:</p>\r\n<ul>\r\n<li>exclusive advanced modules,</li>\r\n<li>automated updates,</li>\r\n<li>free migration of your existing Hesk tickets and settings,</li>\r\n<li>we take care of maintenance, server setup and optimization, backups, and more!</li>\r\n</ul>\r\n\r\n<p>&nbsp;<br><a href=\"https://www.hesk.com/get/hesk3-cloud\" class=\"btn btn--blue-border\" style=\"text-decoration:none\">Click here to learn more about Hesk Cloud</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Again, welcome to Hesk, and enjoy using it!</p>\r\n\r\n<p>Klemen Stirn<br>\r\nFounder<br>\r\n<a href=\"https://www.hesk.com\">https://www.hesk.com</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n</div><p>','2025-03-15 21:46:59','1',9999),(2,1,2,'teste','teste<br />\n<br />\n<br />\n','2025-03-17 20:25:18','1',0),(3,2,1,'Re: teste','Testado<br />\n<br />\n<br />\n','2025-03-20 17:51:18','1',0),(4,1,2,'Re: Re: teste','teste ok<br />\n<br />\n<br />\n','2025-03-20 18:08:47','1',0),(5,5,10,'Notas da Totvs Emissão 03/25 Venc.04/25','Acompanhar atendimento:<br />\r\n<br />\r\n<a href=\"https://suporte.tecpav.com.br/ticket.php?track=RUX-DHT-E1QL&amp;e=disley.oliveira%40tecpav.com.br\">https://suporte.tecpav.com.br/ticket.php?track=RUX-DHT-E1QL&amp;e=disley.oliveira%40tecpav.com.br</a><br />\n<br />\n<br />\n','2025-03-28 21:15:18','1',0),(6,1,2,'Atualização no Menu da Aplicação de Help Desk','Prezados(a),<br />\r\n<br />\r\nGostaria de informar que realizei uma pequena atualização na aplicação de Help Desk, referente à exibição do menu principal.<br />\r\n<br />\r\nO nome do menu, que anteriormente estava sendo exibido em letras minúsculas, foi ajustado para letras maiúsculas, com o objetivo de melhorar a padronização visual e a legibilidade da interface.<br />\r\n<br />\r\nEssa alteração já está disponível no ambiente de produção e não impacta outras funcionalidades da aplicação.<br />\r\n<br />\r\nFico à disposição para quaisquer dúvidas ou sugestões.<br />\r\n<br />\r\nAtenciosamente,<br />\r\n<br />\r\nWesley Nunes<br />\n<br />\n<br />\n','2025-04-03 23:46:27','1',0),(7,9999,1,'Congratulations on your 100th ticket!','</p><div style=\"text-align:justify; padding-left: 10px; padding-right: 10px;\">\r\n\r\n<h2 style=\"padding-left:0px\">You are now part of the Hesk family, and we want to serve you better!</h2>\r\n\r\n<h3>&raquo; Rate us</h3>\r\n\r\n<p>Positive ratings and reviews motivate us to continue developing Hesk. Please take a moment to:</p>\r\n\r\n<ul>\r\n<li>rate or review Hesk at <a href=\"https://www.capterra.com/p/156452/HESK/\" rel=\"nofollow\">Capterra</a></li>\r\n<li>rate or review Hesk at <a href=\"https://softaculous.com/apps/customersupport/HESK\" rel=\"nofollow\">Softaculous</a></li>\r\n</ul>\r\n\r\n<h3>&raquo; Stay updated</h3>\r\n\r\n<p>Hesk regularly receives improvements and bug fixes; make sure you know about them!</p>\r\n<ul>\r\n<li>for fast notifications, <a href=\"https://x.com/HESKdotCOM\" rel=\"nofollow\">follow Hesk on <b>X</b></a></li>\r\n<li>for email notifications, subscribe to our low-volume, zero-spam <a href=\"https://www.hesk.com/newsletter.php\">newsletter</a></li>\r\n</ul>\r\n\r\n<h3>&raquo; Look professional</h3>\r\n\r\n<p><a href=\"https://www.hesk.com/get/hesk3-license\">Remove &quot;Powered by&quot; links</a> to support Hesk development and make it look more professional.</p>\r\n\r\n&nbsp;\r\n\r\n<h3>&raquo; Upgrade to Hesk Cloud for the ultimate experience</h3>\r\n\r\n<p>Experience the best of Hesk by moving your help desk into the Hesk Cloud:</p>\r\n<ul>\r\n<li>exclusive advanced modules,</li>\r\n<li>automated updates,</li>\r\n<li>free migration of your existing Hesk tickets and settings,</li>\r\n<li>we take care of maintenance, server setup and optimization, backups, and more!</li>\r\n</ul>\r\n\r\n<p>&nbsp;<br><a href=\"https://www.hesk.com/get/hesk3-cloud\" class=\"btn btn--blue-border\" style=\"text-decoration:none\">Click here to learn more about Hesk Cloud</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Best regards,</p>\r\n\r\n<p>Klemen Stirn<br>\r\nFounder<br>\r\n<a href=\"https://www.hesk.com\">https://www.hesk.com</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n</div><p>','2025-04-07 18:17:16','1',9999),(8,9,1,'Melhorias painel suporte','Gordim so pra vc não esquecer, a correção ortografica que ficou de habilitar para gente.<br />\r\nAbraço....<br />\n<br />\nElyseu Moreira<br />\r\n==============<br />\r\nAnalista de Redes<br />\r\n==============<br />\r\nFone: (62) 3237-3961<br />\r\nE-mail: <a href=\"mailto:elyseu.moreira@tecpav.com.br\">elyseu.moreira@tecpav.com.br</a><br />\r\n==============<br />\r\nTECPAV<br />\n','2025-05-29 11:35:45','1',0),(9,9,1,'Melhorias painel suporte','Gordim so pra vc não esquecer, a correção ortografica que ficou de habilitar para gente.<br />\r\nAbraço....<br />\n<br />\nElyseu Moreira<br />\r\n==============<br />\r\nAnalista de Redes<br />\r\n==============<br />\r\nFone: (62) 3237-3961<br />\r\nE-mail: <a href=\"mailto:elyseu.moreira@tecpav.com.br\">elyseu.moreira@tecpav.com.br</a><br />\r\n==============<br />\r\nTECPAV<br />\n','2025-05-29 11:35:52','1',0),(10,9,1,'Melhorias painel suporte','Gordim so pra vc não esquecer, a correção ortografica que ficou de habilitar para gente.<br />\r\nAbraço....<br />\n<br />\nElyseu Moreira<br />\r\n==============<br />\r\nAnalista de Redes<br />\r\n==============<br />\r\nFone: (62) 3237-3961<br />\r\nE-mail: <a href=\"mailto:elyseu.moreira@tecpav.com.br\">elyseu.moreira@tecpav.com.br</a><br />\r\n==============<br />\r\nTECPAV<br />\n','2025-05-29 11:35:58','1',0),(12,6,1,'Permissões de acessos, Sobrado, Gerencia 00','Permissões de acessos, Sobrado, Gerencia 00<br />\r\nAs solicitações de acessos e permissões de usuários na Sobrado Gerência 0, deverá ser atendida somente quando solicitado pela Meire.<br />\n<br />\nAtt: Vinicio Faria - Analista de Sistemas<br />\r\n062 3237 3965<br />\r\n<a href=\"mailto:vinicio.faria@tecpav.com.br\">vinicio.faria@tecpav.com.br</a><br />\n','2025-06-27 14:55:27','1',6),(13,6,11,'Permissões de acessos, Sobrado, Gerencia 00','Permissões de acessos, Sobrado, Gerencia 00<br />\r\nAs solicitações de acessos e permissões de usuários na Sobrado Gerência 0, deverá ser atendida somente quando solicitado pela Meire.<br />\n<br />\nAtt: Vinicio Faria - Analista de Sistemas<br />\r\n062 3237 3965<br />\r\n<a href=\"mailto:vinicio.faria@tecpav.com.br\">vinicio.faria@tecpav.com.br</a><br />\n','2025-06-27 14:55:44','1',6),(14,6,8,'Permissões de acessos, Sobrado, Gerencia 00','Permissões de acessos, Sobrado, Gerencia 00<br />\r\nAs solicitações de acessos e permissões de usuários na Sobrado Gerência 0, deverá ser atendida somente quando solicitado pela Meire.<br />\n<br />\nAtt: Vinicio Faria - Analista de Sistemas<br />\r\n062 3237 3965<br />\r\n<a href=\"mailto:vinicio.faria@tecpav.com.br\">vinicio.faria@tecpav.com.br</a><br />\n','2025-06-27 14:56:03','1',6),(15,6,10,'Permissões de acessos, Sobrado, Gerencia 00','Permissões de acessos, Sobrado, Gerencia 00<br />\r\nAs solicitações de acessos e permissões de usuários na Sobrado Gerência 0, deverá ser atendida somente quando solicitado pela Meire.<br />\n<br />\nAtt: Vinicio Faria - Analista de Sistemas<br />\r\n062 3237 3965<br />\r\n<a href=\"mailto:vinicio.faria@tecpav.com.br\">vinicio.faria@tecpav.com.br</a><br />\n','2025-06-27 14:56:20','1',6),(16,6,2,'Permissões de acessos, Sobrado, Gerencia 00','Permissões de acessos, Sobrado, Gerencia 00<br />\r\nAs solicitações de acessos e permissões de usuários na Sobrado Gerência 0, deverá ser atendida somente quando solicitado pela Meire.<br />\n<br />\nAtt: Vinicio Faria - Analista de Sistemas<br />\r\n062 3237 3965<br />\r\n<a href=\"mailto:vinicio.faria@tecpav.com.br\">vinicio.faria@tecpav.com.br</a><br />\n','2025-06-27 14:56:35','1',6),(17,6,9,'Permissões de acessos, Sobrado, Gerencia 00','Permissões de acessos, Sobrado, Gerencia 00<br />\r\nAs solicitações de acessos e permissões de usuários na Sobrado Gerência 0, deverá ser atendida somente quando solicitado pela Meire.<br />\n<br />\nAtt: Vinicio Faria - Analista de Sistemas<br />\r\n062 3237 3965<br />\r\n<a href=\"mailto:vinicio.faria@tecpav.com.br\">vinicio.faria@tecpav.com.br</a><br />\n','2025-06-27 14:56:46','1',6),(18,6,5,'Permissões de acessos, Sobrado, Gerencia 00','Permissões de acessos, Sobrado, Gerencia 00<br />\r\nAs solicitações de acessos e permissões de usuários na Sobrado Gerência 0, deverá ser atendida somente quando solicitado pela Meire.<br />\n<br />\nAtt: Vinicio Faria - Analista de Sistemas<br />\r\n062 3237 3965<br />\r\n<a href=\"mailto:vinicio.faria@tecpav.com.br\">vinicio.faria@tecpav.com.br</a><br />\n','2025-06-27 14:56:57','1',6),(19,9,1,'Por favor criar usuario no Portal','Segue o link do chamado.<br />\r\n<br />\r\n<a href=\"https://suporte.tecpav.com.br/admin/admin_ticket.php?track=ZL1-ES6-PP8U&amp;Refresh=38450\">https://suporte.tecpav.com.br/admin/admin_ticket.php?track=ZL1-ES6-PP8U&amp;Refresh=38450</a><br />\n<br />\n<br />\n','2025-06-30 15:03:29','1',0),(20,9,10,'Acesso ao RM','Jow depois da uma olhada nesse chamado o usuario esta tentando usar o palicativo do RM.<br />\r\n<br />\r\n<a href=\"https://suporte.tecpav.com.br/admin/admin_ticket.php?track=51B-D2R-V3PE&amp;Refresh=15741\">https://suporte.tecpav.com.br/admin/admin_ticket.php?track=51B-D2R-V3PE&amp;Refresh=15741</a><br />\r\n<br />\r\nValeu<br />\n<br />\n<br />\n','2025-07-01 22:27:27','1',0);

--
-- Table structure for table `hesk_mfa_backup_codes`
--

CREATE TABLE `hesk_mfa_backup_codes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` smallint unsigned NOT NULL,
  `user_type` varchar(8) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'STAFF',
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_mfa_backup_codes`
--


--
-- Table structure for table `hesk_mfa_verification_tokens`
--

CREATE TABLE `hesk_mfa_verification_tokens` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` smallint unsigned NOT NULL,
  `user_type` varchar(8) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'STAFF',
  `verification_token` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `expires_at` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `verification_token` (`verification_token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_mfa_verification_tokens`
--


--
-- Table structure for table `hesk_notes`
--

CREATE TABLE `hesk_notes` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `ticket` mediumint unsigned NOT NULL,
  `who` smallint unsigned NOT NULL,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `message` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `attachments` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ticketid` (`ticket`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_notes`
--

INSERT INTO `hesk_notes` VALUES (1,32,5,'2025-03-28 20:32:37','Renan solicitou uma retificação:<br />\r\n<br />\r\nDisley, bom dia!<br />\r\n<br />\r\nRetificando a solicitação original, informo que, por se tratar de criação de seção nas coligadas consorciadas, para fins de lotação tributária, deve-se considerar o Tomador da Obra o Consorcio, e não o cliente. Segue abaixo item a ser corrigido:<br />\r\n<br />\r\n7.     Tomador/Cliente: CONSORCIO RODOVIA BR-080 II  - 51.154.832/0001-01',''),(2,33,5,'2025-03-28 20:42:56','A fórmula foi corrigida para:<br />\r\n<br />\r\nDECL VALOR, ADNOTURNOSINDICATO,PERC, FALTAS, DIASDOMES, NOMEFUNCAO;<br />\r\n<br />\r\nSETVAR(ADNOTURNOSINDICATO,VALSIND (\'02\'));<br />\r\n<br />\r\nSETVAR(FALTAS,  N (\'7131\') + N (\'7132\') + N (\'7047\'));<br />\r\n<br />\r\nSETVAR(NOMEFUNCAO,SUBSTR(TABFUNCAO(TABFUNC(\'CODFUNCAO\',\'S\'),\'NOME\'),1,5));<br />\r\n<br />\r\n/*SETVAR(VALOR,0);*/<br />\r\n<br />\r\nSE N(\'6064\') &gt; 0 ENTAO<br />\r\n   SETVAR(DIASDOMES,N(\'6064\')) SENAO<br />\r\n   SETVAR(DIASDOMES,FOR(\'EVR6002\')) <br />\r\nFIMSE;<br />\r\n   <br />\r\nSETVAR(PERC, VALSIND (\'02\')  / 100);<br />\r\n<br />\r\nSE ADNOTURNOSINDICATO=20<br />\r\n   ENTAO<br />\r\n      /*Testa se funcionário tem horário noturno */<br />\r\n      EXECSQL (\'AHORARIO.001\');<br />\r\n      SE COLIGADACORRENTE=7 E (TABFUNC(\'CODSECAO\',\'S\')=\'00.CNT.0003.01\' OU TABFUNC(\'CODSECAO\',\'S\')=\'00.CNT.0448.01\') E NOMEFUNCAO&lt;&gt;\'VIGIA\'<br />\r\n         ENTAO<br />\r\n           <br />\r\n           SETVAR(VALOR,(HC * PERC) * MR(MES, ANO, \'6015\'))<br />\r\n           <br />\r\n        SENAO <br />\r\n           SE RESULTSQL (\'AHORARIO.001\' , \'QTDE\') &gt; 0<br />\r\n             ENTAO<br />\r\n                 <br />\r\n                 SETVAR(VALOR,((RC * PERC) / 30 * (DIASDOMES-FALTAS)   )    )<br />\r\n                 <br />\r\n            SENAO<br />\r\n                 /* Calcula o valor baseado na quantidade de horas lançadas não observando se o horário do func. é noturno */<br />\r\n                 SETVAR(VALOR,(HC * PERC) * MR(MES, ANO, \'5055\'))<br />\r\n           FIMSE<br />\r\n<br />\r\nFIMSE<br />\r\nSENAO  /*Foi adicionada essa condição*/<br />\r\n   0<br />\r\nFIMSE;   <br />\r\n<br />\r\nSE EXISTEEP(\'6015\') &gt; 0 ENTAO C(\'5055\') SENAO<br />\r\nVALOR FIMSE',''),(3,36,5,'2025-03-31 13:28:57','SCRIPT SQL EXECUTADO NESTA SOLUÇÃO:<br />\r\n<br />\r\nINSERT INTO APARFUN(CODCOLIGADA,CHAPA,CODPARCOL,CODNUCLEO,CODHORREL,VALORDSR,VALORFERIADO,TIPOCARENCIA,CARENCIA,COMPENSACAO,JORNADAPER,DESCANSO,TOLERANCIA,MAXENTSAI,MINJORNADA,USAPONTO,CONSFERIADO,PAGAEXTRA,PAGAADNOTURNO,PAGANONAHORA,PAGAHTRAB,PAGADSR,COMPANUALEXTRA,COMPENSAFALTA,DIADIATOTAL,PRIMEIRAFAIXA,CONSPERCENTUAL,USAEXTRADESC,USAEXTRAFERIADO,MAISOUMENOSBAT,TIPOHORARIO,EXTRAAUTO,AUTORIZADO,ULTIMORECALCULODATA,ULTIMORECALCULOHORA,ARMAZENAEXTRA,ARMAZENACOMP,ARMAZENAEXTRACOMP,ARMAZENAATRASOCOMP,ARMAZENAFALTACOMP,TRABOBRIGFER,USAEXTRACOMP,CONSIDERAHORFLEXDIA,DIAHORFLEX,CODTABFOLGA,LIMITECOMPFLEX,DIADIATOTALCOMP,DIADIATOTALDESC,DIADIATOTALFER,ABATECARENCIA,TEMPOMINJOR,CODTABPONTE,VALORDSRPROPORC,TEMPPARFUN,CONSCALCJORNADA,VISMOVCONJORFUN,JORNADA,TIPOJORNADA,INTREFEICAO,NUMPARBAT,TOLEXTRAS,ABATTOLEXTRAS,TOLATRASOS,ABATTOLATRASOS,REDUZHORNOT,FORMULAJOR,DATAINICIOPERIODOTRANSICAO,CARENCIAEXTRAAPOSCOMP,CARENCIAATRASOAPOSCOMP,CONSIDERAHORARIOCHRONUSPROF,RECCREATEDBY,RECCREATEDON,RECMODIFIEDBY,RECMODIFIEDON,CONSIDERAINICIODEFINIRJORNADA,TEMPOCONTJORNADA,TEMPOACRESCDEFJORNSEMTRAB,CONSIDERAJORNSEMTRABCONTINUAS,TEMPOACRESCLIMJORNTRAB,TOTALIZAOCORRENCIACOMPESP,CONSFAIXAEXTRA)<br />\r\nSELECT distinct A.CODCOLIGADA,A.CHAPA,E.CODPARCOL,E.CODNUCLEO,E.CODHORREL,E.VALORDSR,VALORFERIADO,TIPOCARENCIA,CARENCIA,COMPENSACAO,JORNADAPER,DESCANSO,TOLERANCIA,MAXENTSAI,MINJORNADA,USAPONTO,CONSFERIADO,PAGAEXTRA,PAGAADNOTURNO,PAGANONAHORA,PAGAHTRAB,PAGADSR,COMPANUALEXTRA,COMPENSAFALTA,DIADIATOTAL,PRIMEIRAFAIXA,CONSPERCENTUAL,USAEXTRADESC,USAEXTRAFERIADO,MAISOUMENOSBAT,TIPOHORARIO,EXTRAAUTO,AUTORIZADO,A.ULTIMORECALCULODATA,A.ULTIMORECALCULOHORA,ARMAZENAEXTRA,ARMAZENACOMP,ARMAZENAEXTRACOMP,ARMAZENAATRASOCOMP,ARMAZENAFALTACOMP,TRABOBRIGFER,USAEXTRACOMP,CONSIDERAHORFLEXDIA,DIAHORFLEX,CODTABFOLGA,LIMITECOMPFLEX,DIADIATOTALCOMP,DIADIATOTALDESC,DIADIATOTALFER,ABATECARENCIA,TEMPOMINJOR,CODTABPONTE,VALORDSRPROPORC,TEMPPARFUN,CONSCALCJORNADA,VISMOVCONJORFUN,A.JORNADA,TIPOJORNADA,INTREFEICAO,NUMPARBAT,TOLEXTRAS,ABATTOLEXTRAS,TOLATRASOS,ABATTOLATRASOS,REDUZHORNOT,FORMULAJOR,DATAINICIOPERIODOTRANSICAO,CARENCIAEXTRAAPOSCOMP,CARENCIAATRASOAPOSCOMP,CONSIDERAHORARIOCHRONUSPROF, \'system\' \'RECCREATEDBY\',GETDATE() \'RECCREATEDON\', \'system\' \'RECMODIFIEDBY\', GETDATE() \'RECMODIFIEDON\',CONSIDERAINICIODEFINIRJORNADA,TEMPOCONTJORNADA,TEMPOACRESCDEFJORNSEMTRAB,CONSIDERAJORNSEMTRABCONTINUAS,TEMPOACRESCLIMJORNTRAB,TOTALIZAOCORRENCIACOMPESP,CONSFAIXAEXTRA<br />\r\nFROM PFUNC A (NOLOCK)<br />\r\nINNER JOIN PFUNC B (NOLOCK) ON(B.CODPESSOA=A.CODPESSOA AND B.TIPODEMISSAO=\'5\' AND B.DATADEMISSAO BETWEEN \'01/03/2025\' AND \'31/03/2025\')<br />\r\nINNER JOIN PFUNCAO C (NOLOCK) ON(C.CODCOLIGADA=A.CODCOLIGADA AND C.CODIGO=A.CODFUNCAO)<br />\r\nINNER JOIN ABATFUN D (NOLOCK) ON(D.CODCOLIGADA=B.CODCOLIGADA AND D.CHAPA=B.CHAPA AND D.DATA BETWEEN \'26/02/2025\' AND \'25/03/2025\')<br />\r\nINNER JOIN APARFUN E (NOLOCK) ON(E.CODCOLIGADA=B.CODCOLIGADA AND E.CHAPA=B.CHAPA)<br />\r\nWHERE A.DTTRANSFERENCIA  BETWEEN \'01/03/2025\' AND \'31/03/2025\'<br />\r\nAND NOT EXISTS(SELECT X.CODCOLIGADA, X.CHAPA  FROM APARFUN X (NOLOCK) WHERE X.CODCOLIGADA=A.CODCOLIGADA AND X.CHAPA=A.CHAPA)<br />\r\n<br />\r\nINSERT INTO ABATFUN(CODCOLIGADA,CHAPA,DATA,BATIDA,STATUS,NATUREZA,DATAINSERCAO,DATAREFERENCIA,IDJORNADA,RECCREATEDBY,RECCREATEDON,RECMODIFIEDBY,RECMODIFIEDON)<br />\r\nSELECT DISTINCT A.CODCOLIGADA,A.CHAPA,D.DATA,D.BATIDA,D.STATUS,D.NATUREZA,D.DATAINSERCAO,D.DATAREFERENCIA,NULL \'IDJORNADA\',\'system\' \'RECCREATEDBY\',GETDATE() \'RECCREATEDON\', \'system\' \'RECMODIFIEDBY\', GETDATE() \'RECMODIFIEDON\'<br />\r\nFROM PFUNC A (NOLOCK)<br />\r\nINNER JOIN PFUNC B (NOLOCK) ON(B.CODPESSOA=A.CODPESSOA AND B.TIPODEMISSAO=\'5\' AND B.DATADEMISSAO BETWEEN \'01/03/2025\' AND \'31/03/2025\')<br />\r\nINNER JOIN PFUNCAO C (NOLOCK) ON(C.CODCOLIGADA=A.CODCOLIGADA AND C.CODIGO=A.CODFUNCAO)<br />\r\nINNER JOIN ABATFUN D (NOLOCK) ON(D.CODCOLIGADA=B.CODCOLIGADA AND D.CHAPA=B.CHAPA AND D.DATA BETWEEN \'26/02/2025\' AND \'25/03/2025\')<br />\r\nWHERE A.DTTRANSFERENCIA  BETWEEN \'01/03/2025\' AND \'31/03/2025\'<br />\r\nAND NOT EXISTS(SELECT X.CODCOLIGADA, X.CHAPA, X.BATIDA FROM ABATFUN X (NOLOCK) WHERE X.CODCOLIGADA=A.CODCOLIGADA AND X.CHAPA=A.CHAPA AND X.BATIDA=D.BATIDA)<br />\r\n<br />\r\nINSERT INTO AABONFUN(CODCOLIGADA,CHAPA,DATA,CODABONO,HORAINICIO,HORAFIM,DESCONSIDERA,RESPONSAVEL,ABONOFUTURO,COLIGADARESP,SOLUCAOCONFLITO,RECCREATEDBY,RECCREATEDON,RECMODIFIEDBY,RECMODIFIEDON,JUSTIFICATIVA)<br />\r\nSELECT DISTINCT A.CODCOLIGADA,A.CHAPA,E.DATA, E.CODABONO, E.HORAINICIO,E.HORAFIM, E.DESCONSIDERA, E.RESPONSAVEL, E.ABONOFUTURO, E.COLIGADARESP, E.SOLUCAOCONFLITO  , \'system\' \'RECCREATEDBY\', GETDATE() \'RECCREATEDON\', \'system\' \'RECMODIFIEDBY\', GETDATE() \'RECMODIFIEDON\', E.JUSTIFICATIVA<br />\r\nFROM PFUNC A (NOLOCK)<br />\r\nINNER JOIN PFUNC B (NOLOCK) ON(B.CODPESSOA=A.CODPESSOA AND B.TIPODEMISSAO=\'5\' AND B.DATADEMISSAO BETWEEN \'01/03/2025\' AND \'31/03/2025\')<br />\r\nINNER JOIN PFUNCAO C (NOLOCK) ON(C.CODCOLIGADA=A.CODCOLIGADA AND C.CODIGO=A.CODFUNCAO)<br />\r\nINNER JOIN AABONFUN E (NOLOCK) ON(E.CODCOLIGADA=B.CODCOLIGADA AND E.CHAPA=B.CHAPA AND E.DATA BETWEEN \'26/02/2025\' AND \'25/03/2025\')<br />\r\nWHERE A.DTTRANSFERENCIA  BETWEEN \'01/03/2025\' AND \'31/03/2025\'<br />\r\nAND NOT EXISTS(SELECT X.CODCOLIGADA, X.CHAPA, X.DATA, X.CODABONO, X.HORAINICIO FROM AABONFUN X (NOLOCK) WHERE X.CODCOLIGADA=A.CODCOLIGADA AND X.CHAPA=A.CHAPA AND X.CODABONO=E.CODABONO AND X.DATA=E.DATA and X.HORAINICIO=E.HORAINICIO and X.HORAFIM=E.HORAFIM)<br />\r\n<br />\r\nINSERT INTO PFUNCVAL<br />\r\nSELECT DISTINCT A.CODCOLIGADA,A.CHAPA,E.CODVALOR, E.DTVALOR, E.VALOR,E.OBSERVACAO,\'system\' \'RECCREATEDBY\',GETDATE() \'RECCREATEDON\', \'system\' \'RECMODIFIEDBY\', GETDATE() \'RECMODIFIEDON\'<br />\r\nFROM PFUNC A (NOLOCK)<br />\r\nINNER JOIN PFUNC B (NOLOCK) ON(B.CODPESSOA=A.CODPESSOA AND B.TIPODEMISSAO=\'5\' AND B.DATADEMISSAO BETWEEN \'01/03/2025\' AND \'31/03/2025\')<br />\r\nINNER JOIN PFUNCAO C (NOLOCK) ON(C.CODCOLIGADA=A.CODCOLIGADA AND C.CODIGO=A.CODFUNCAO)<br />\r\nINNER JOIN PFUNCVAL E (NOLOCK) ON(E.CODCOLIGADA=B.CODCOLIGADA AND E.CHAPA=B.CHAPA AND E.DTVALOR BETWEEN \'26/02/2025\' AND \'25/03/2025\')<br />\r\nWHERE A.DTTRANSFERENCIA  BETWEEN \'01/03/2025\' AND \'31/03/2025\'<br />\r\nAND NOT EXISTS(SELECT X.CODCOLIGADA, X.CHAPA, X.DTVALOR, X.CODVALOR FROM PFUNCVAL X (NOLOCK) WHERE X.CODCOLIGADA=A.CODCOLIGADA AND X.CHAPA=A.CHAPA AND X.CODVALOR=E.CODVALOR AND X.DTVALOR=E.DTVALOR)<br />\r\n<br />\r\nINSERT INTO PFRATEIOFIXO(CODCOLIGADA,CHAPA,CODCCUSTO,VALOR,RECCREATEDBY,RECCREATEDON,RECMODIFIEDBY,RECMODIFIEDON)<br />\r\nSELECT DISTINCT A.CODCOLIGADA,A.CHAPA, E.CODCCUSTO, E.VALOR , \'system\' \'RECCREATEDBY\', GETDATE() \'RECCREATEDON\', \'system\' \'RECMODIFIEDBY\', GETDATE() \'RECMODIFIEDON\'<br />\r\nFROM PFUNC A (NOLOCK)<br />\r\nINNER JOIN PFUNC B (NOLOCK) ON(B.CODPESSOA=A.CODPESSOA AND B.TIPODEMISSAO=\'5\' AND B.DATADEMISSAO BETWEEN \'01/03/2025\' AND \'31/03/2025\')<br />\r\nINNER JOIN PFUNCAO C (NOLOCK) ON(C.CODCOLIGADA=A.CODCOLIGADA AND C.CODIGO=A.CODFUNCAO)<br />\r\nINNER JOIN PFRATEIOFIXO E (NOLOCK) ON(E.CODCOLIGADA=B.CODCOLIGADA AND E.CHAPA=B.CHAPA) <br />\r\nWHERE A.DTTRANSFERENCIA  BETWEEN \'01/03/2025\' AND \'31/03/2025\'<br />\r\nAND NOT EXISTS(SELECT X.CODCOLIGADA, X.CHAPA FROM PFRATEIOFIXO X (NOLOCK) WHERE X.CODCOLIGADA=A.CODCOLIGADA AND X.CHAPA=A.CHAPA)',''),(4,35,9,'2025-03-31 13:48:51','Bom dia.<br />\r\n<br />\r\nEle disse que perdeu o acesso. Por isso solicitei novamente a liberação de acesso.',''),(5,42,5,'2025-03-31 14:49:55','SCRIPT SQL EXECUTADO NA SOLUÇÃO:<br />\r\n-----------------------------------------------------<br />\r\nDECLARE CR_RATEIOGER CURSOR<br />\r\nFOR<br />\r\n<br />\r\nSELECT \'C\' \'NAT\', CODCOLIGADA, DATA, LCTREF, IDPARTIDA,  CREDITO \'CONTA\', COMPLEMENTO, VALOR <br />\r\nFROM CPARTIDA <br />\r\nWHERE CODCOLIGADA=7 AND CODLOTE=0 AND LCTREF IN(1828470,1828472,1828473,1828475,1828477,1828479,1828546,1828548,1828550,1828552,1828554,1828611,1828613,1828615,1828617,1828619,1828621,1829596,1829597,1829598,1829599,1829600,1829601,1829602,1829619,1829620,1829621,1829638,1829639,1829640,1829664,<br />\r\n1829665,1829666,1829667,1829686,1829687,1829688,1829689,1829690,1829691,1829707,1829708,1830960,1830961,1830980,1830981,1831000,1830512,1830534,1830535,1830548,1830549,1831035,1831036,1831048,1831066,1831115,1831116,1831117,1831130,1831144,1840207,<br />\r\n1840222,1840223,1840224,1840235,1840236,1840237,1839788,1839789,1839790,1839791,1839813,1839840,1839883,1840665,1840686,1840687,1840688,1840704,1840705,1840706,1839913,1839914,1839930,1839943,1839944,1841936,1841937,1841938,1841939,1841940,1841964,<br />\r\n1841965,1841966,1841994,1841995,1841996,1842022,1842023,1842024,1842025,1842026,1842039,1842040,1842041,1842042,1842043,1842044,1842045,1842046,1842061,1842062,1840989,1840990,1840991,1840992,1840993,1840994,1841020,1841021,1841022,1841023,1841024,<br />\r\n1841025,1841044,1841045,1841046,1841047,1841048,1841063,1841064,1841087,1841088,1841089,1841090,1841091,1841092,1841117,1841118,1841119,1841120)<br />\r\n<br />\r\nDECLARE @NAT VARCHAR(1), @COL INT, @DATA DATETIME, @LCTREF INT, @IDPARTIDA INT, @CONTA VARCHAR(25), @VALOR FLOAT, @IDRATEIO INT, @CODGERENCIAL VARCHAR(25), @COMPLEMENTO VARCHAR(150)<br />\r\n<br />\r\nOPEN CR_RATEIOGER<br />\r\nFETCH NEXT FROM CR_RATEIOGER INTO @NAT, @COL, @DATA, @LCTREF, @IDPARTIDA, @CONTA, @COMPLEMENTO,@VALOR<br />\r\nWHILE @@FETCH_STATUS=0<br />\r\nBEGIN<br />\r\n   <br />\r\n   SET @IDRATEIO=(SELECT VALAUTOINC+1 FROM GAUTOINC (NOLOCK) WHERE CODCOLIGADA=@COL AND CODSISTEMA=\'C\' AND CODAUTOINC=\'IDRATEIO\')<br />\r\n   UPDATE GAUTOINC SET VALAUTOINC=@IDRATEIO WHERE CODCOLIGADA=@COL AND CODSISTEMA=\'C\' AND CODAUTOINC=\'IDRATEIO\'<br />\r\n<br />\r\n   --Origem CONTA GERENCIAL<br />\r\n   SET @CODGERENCIAL=<br />\r\n     CASE WHEN @COMPLEMENTO LIKE \'RATEIO CUSTO CONSORCIO 52 - LCTREF:%\' THEN \'2.0000126\'<br />\r\n          WHEN @COMPLEMENTO LIKE \'RATEIO CUSTO CONSORCIO 57 - LCTREF:%\' THEN \'2.0000139\'<br />\r\n          WHEN @COMPLEMENTO LIKE \'RATEIO CUSTO CONSORCIO 60 - LCTREF:%\' THEN \'2.0000224\'<br />\r\n     END<br />\r\n<br />\r\n   IF ISNULL(@CODGERENCIAL,\'\')&lt;&gt;\'\'<br />\r\n      INSERT INTO CRATEIOLC <br />\r\n      SELECT @COL, @LCTREF, @DATA, @CONTA, @CODGERENCIAL, CASE @NAT WHEN \'D\' THEN @VALOR ELSE 0 END AS \'VLRDEBITO\', CASE @NAT WHEN \'C\' THEN @VALOR ELSE 0 END AS \'VLRCREDITO\', @COL \'CODCOLCONTA\', @COL \'CODCOLGERENCIAL\', 0 \'CODLOTE\', @IDRATEIO, @IDPARTIDA,\'System\', GETDATE(),\'System\', GETDATE()<br />\r\n          WHERE @CODGERENCIAL IS NOT NULL<br />\r\n   <br />\r\n<br />\r\n   FETCH NEXT FROM CR_RATEIOGER INTO @NAT, @COL, @DATA, @LCTREF, @IDPARTIDA, @CONTA, @COMPLEMENTO, @VALOR<br />\r\n<br />\r\nEND<br />\r\nCLOSE CR_RATEIOGER<br />\r\nDEALLOCATE CR_RATEIOGER',''),(7,49,9,'2025-04-01 16:29:11','Boa tarde, Rafael.<br />\r\nSegue em anexos os orçamentos atualizados.<br />\r\nMenor valor mão de obra: 3.500,00<br />\r\nMenor valor material logico: 7.954,47<br />\r\nMenor valor material infraestrutura: R$: 657,30<br />\r\nValor total do projeto R$: 12.111,77<br />\r\nObs.: o aluguel do andaime e de responsabilidade da empresa contratante.<br />\r\nQualquer dúvida estou à disposição para esclarecimentos.<br />\r\nObrigado.',''),(8,54,2,'2025-04-02 11:06:37','Foi solicitado ao fornecedor a liberação da licença, aguardando retorno com a liberação da licença.',''),(9,49,9,'2025-04-04 17:15:07','Sim, vamos aguardar a chegada da câmera com a qualidade melhor.<br />\r\n<br />\r\nAtt',''),(10,86,9,'2025-04-08 14:09:48','Algar não atende o endereço.','24#Algar.jpg,'),(11,86,9,'2025-04-11 12:50:02','Vivo não atende o endereço, não existe fibra optica para atender a demanda.<br />\r\nProtocolo: 11042025MD80662732',''),(12,86,9,'2025-04-11 19:03:07','Oi telecom não tem a viabilidade tecnica para o endereço.',''),(13,86,9,'2025-04-11 19:23:04','TIM Live 1G de velocidade valor 149,90 boleto bancario data vencimento dia 15 de todo mês.<br />\r\n72 horas para viabilidade tecnica para instalação.<br />\r\nData provavel para instalação dia 15/04 na partir da manhã<br />\r\nProtocolo atendimento: 7137210665',''),(14,123,9,'2025-04-14 12:36:59','Algar não tem disponibilade para link convencional somente dedicado.','25#algar-comercial.png,'),(17,253,5,'2025-06-25 21:26:21','Wesley, favor gerar listagem em Excel com as colunas solicitadas na planilha modelo &quot;Tabela-de-Pessoas-Cabecalho.xlsx&quot;, filtrar pelas chapas conforme planilha REL_FUNC_TRANSF CONS CN1.','149#REL_FUNC_TRANSF-CONS-CN1-para-Disley.xlsx,'),(16,123,9,'2025-04-23 20:10:17','Instalação agendada para dia 28/04/2025 operadora OI no periodo vespertino a pedido do Sr. Saulo Henrique que vai acompanhar a instalção no local.<br />\r\nNº do contrato: 04748108<br />\r\nNº atendimento: 2025034328523<br />\r\nPlano 1G valor de R$:179,90 boleto bancario com vencimento para todo dia 15 de cada mês.',''),(18,295,5,'2025-06-26 23:09:19','A tabela de Solicitante é a TVEN,  foi migrada<br />\r\nAs consultas abaixo mostram que está presente em ambas bases.<br />\r\n<br />\r\nSELECT * FROM P_RMSped180625..TVEN  WHERE CODCOLIGADA=3 and CODVEN=\'F008642\'<br />\r\nSELECT * FROM P_RMBackoffice..TVEN  WHERE CODCOLIGADA=3  and CODVEN=\'F008642\'',''),(19,325,5,'2025-06-27 15:01:35','Na primeira etapa era Stored Procedure, na segunda eram Consultas QL',''),(20,302,5,'2025-06-27 21:54:04','Os dados já estavam duplicados na tabela FTB4CONT na base de origem.<br />\r\n<br />\r\nSolução com o scritp:<br />\r\nDELETE FROM P_RMBackOffice..FTB4CONT<br />\r\n<br />\r\nINSERT INTO P_RMBackOffice..FTB4CONT(CODCOLIGADA,IDTB4CONT,DEBOUCRED,PERCENTUAL,CODFILIAL,CODDEPARTAMENTO,CODCCUSTO,CODHISTP,COMPLHISTORICO,CODTB4FLX,CODCOLCONTA,CODCONTA,CLASSCONTA,RECCREATEDBY,RECCREATEDON,RECMODIFIEDBY,RECMODIFIEDON)<br />\r\nSELECT CODCOLIGADA, MIN(IDTB4CONT) \'IDTB4CONT\',DEBOUCRED,PERCENTUAL,CODFILIAL,CODDEPARTAMENTO,CODCCUSTO,CODHISTP,COMPLHISTORICO,CODTB4FLX,CODCOLCONTA,CODCONTA,CLASSCONTA, \'system\' \'RECCREATEDBY\', GETDATE() \'RECCREATEDON\', \'system\' \'RECMODIFIEDBY\', GETDATE() \'RECMODIFIEDON\'<br />\r\nFROM P_RMCorporativo..FTB4CONT A<br />\r\nWHERE EXISTS(SELECT X.CODCOLIGADA, X.CODTB4FLX FROM P_RMBackOffice..FTB4 X WHERE X.CODCOLIGADA=A.CODCOLIGADA AND X.CODTB4FLX=A.CODTB4FLX)<br />\r\nGROUP BY CODCOLIGADA, DEBOUCRED,PERCENTUAL,CODFILIAL,CODDEPARTAMENTO,CODCCUSTO,CODHISTP,COMPLHISTORICO,CODTB4FLX,CODCOLCONTA,CODCONTA,CLASSCONTA',''),(21,339,6,'2025-06-30 14:01:53','Veja os detalhes no vídeo do processo: <br />\r\n<br />\r\n<a href=\"https://tecpav-my.sharepoint.com/:v:/g/personal/vinicio_faria_tecpav_com_br/EQyFHDzUUR5AtG4wnZuQdpsBExopyXHkqleRx5CV1te6KQ?e=wMh1m8\">https://tecpav-my.sharepoint.com/:v:/g/personal/vinicio_faria_tecpav_com_br/EQyFHDzUUR5AtG4wnZuQdpsBExopyXHkqleRx5CV1te6KQ?e=wMh1m8</a>',''),(22,344,9,'2025-06-30 15:02:13','Criar usuario no Portal',''),(23,340,5,'2025-06-30 20:35:07','Para a mensagem sobre o DARF -  Desabilitar o parâmetros do RM Fluxus Etapa 22.','215#Param_Financ_Fiscal.png,'),(37,398,6,'2025-07-15 19:50:15','2 - MOV 1.2.13 -&gt; CF Pedindo informar UNIDADE, antes não tinha(Está com erro)<br />\r\nResolvido',''),(25,306,5,'2025-06-30 20:55:31','Enviei para o Gláucio para análise.',''),(26,330,5,'2025-06-30 21:13:13','Qual código de relatório?',''),(27,367,6,'2025-07-02 20:20:16','Lorena Freitas não sabe realizar os processos. A outra pessoa entrou de férias.',''),(28,273,5,'2025-07-02 22:29:03','RELATORIO_AUDITORIA_FINANCEIRO_GER00_GAE',''),(29,390,5,'2025-07-04 15:15:05','Fiz essa alteração para o funcionário aplicando o motivo da transferência e informando o CNPJ da empresa sucessora, funcionou a geração do XML.<br />\r\n<br />\r\nUPDATE PFUNC SET MOTIVOSAIDATRANSFERENCIA=1, CNPJEMPRESASUCESSORA=\'61.067.364/0001-83\' WHERE CODCOLIGADA=3 AND CHAPA=\'206239\'',''),(30,401,6,'2025-07-08 21:38:16','Mesmo relatório utilizado pela Cinthya Apropriação de Custos. Código do relatório: 030303',''),(31,410,10,'2025-07-11 14:54:49','Criar primeiro os logins de rede.',''),(32,415,6,'2025-07-11 20:05:35','Faltava acrescentar o código do departamento na SQL, pois os usuários tem filtros.',''),(33,398,5,'2025-07-11 21:21:46','3 - Relatório 002.08 -&gt; (REPORTS), ordem de pagamento da Folha de Pagamento)<br />\r\nR: Relatório entregue e testado com Danubia',''),(34,259,5,'2025-07-11 21:29:29','Relatórios Prontos:<br />\r\n02.001-1 Extrato de caixa<br />\r\n02.002-2 Relação de cheques emitidos<br />\r\n04.003A-Ger00 - Programação de Pagamentos<br />\r\n--------------------------------------------------------------<br />\r\n04.003B-Ger00 - Programação de Débitos (Observação: Usar o Tipo de Pagamento DÉBITO EM CONTA)<br />\r\n04.003C-Ger00 - Programação de Cheques(Observação: Usar o Tipo de Pagamento CARTEIRA)',''),(35,434,5,'2025-07-11 21:45:50','Solicitei ao Glaucio em 11/07 - 18:42',''),(36,349,6,'2025-07-14 17:13:55','Relatórios mencionados não estão trazendo todas as coligadas, está trazendo apenas uma coligada fixa e não é a coligada do contexto.',''),(38,448,5,'2025-07-15 22:38:24','A importação foi realizada sem a marcação do campo &quot;Cobrança Registrada&quot;, ver anexo.','301#Parametro-Importacao.png,'),(39,458,6,'2025-07-16 17:08:13','Solicitante pediu para que também seja verificado em todas as coligadas',''),(40,508,6,'2025-07-24 19:16:53','Revisar o relatório 03.006 - RECIBO - RECEBIMENTO.','345#Captura-de-tela-2025-07-24-161248.png,'),(41,567,5,'2025-08-06 15:28:59','Precisa parametrizar a coligada 43 no RM Fluxus no servidor 222, igualar os parâmetros conforme está no 141.',''),(42,564,5,'2025-08-06 18:28:05','C.Custo: 6493',''),(43,590,5,'2025-08-12 21:10:13','Verificar qual fornecedor foi informado no lançamento, o atendimento não está devidamente analisado para ser definido como solucionado.',''),(44,643,6,'2025-08-28 11:40:52','Solicitante desejar resetar a sua senha do Portal<br />\r\n<a href=\"http://portal.admltda.com.br/wp-login.php\">http://portal.admltda.com.br/wp-login.php</a>',''),(45,580,5,'2025-09-03 22:06:36','SQL = Desconsiderar segurança','');

--
-- Table structure for table `hesk_oauth_providers`
--

CREATE TABLE `hesk_oauth_providers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `authorization_url` text NOT NULL,
  `token_url` text NOT NULL,
  `client_id` text NOT NULL,
  `client_secret` text NOT NULL,
  `scope` text NOT NULL,
  `no_val_ssl` tinyint NOT NULL DEFAULT '0',
  `verified` smallint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hesk_oauth_providers`
--

INSERT INTO `hesk_oauth_providers` VALUES (2,'Hesk OAuth','https://login.microsoftonline.com/bbdc3dbb-86c0-462c-9b1f-50667ee61c02/oauth2/v2.0/authorize','https://login.microsoftonline.com/bbdc3dbb-86c0-462c-9b1f-50667ee61c02/oauth2/v2.0/token','8312b020-6f2d-4caa-a85f-2502dbc94182','UDr8Q~GqjtnDMAjyO6-VhCw2SHEn6T16YTAZ-cx~','openid offline_access https://outlook.office.com/IMAP.AccessAsUser.All https://outlook.office.com/POP.AccessAsUser.All https://outlook.office.com/SMTP.Send',0,1);

--
-- Table structure for table `hesk_oauth_tokens`
--

CREATE TABLE `hesk_oauth_tokens` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `provider_id` int NOT NULL,
  `token_value` text,
  `token_type` varchar(32) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `expires` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7657 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hesk_oauth_tokens`
--

INSERT INTO `hesk_oauth_tokens` VALUES (7655,2,'eyJ0eXAiOiJKV1QiLCJub25jZSI6IkQ1MXB6d2NrU3Y0alRkWjhzcFRTX0NVUDVUcU1YUEdFSlBubkNxRlhOcTgiLCJhbGciOiJSUzI1NiIsIng1dCI6InlFVXdtWFdMMTA3Q2MtN1FaMldTYmVPYjNzUSIsImtpZCI6InlFVXdtWFdMMTA3Q2MtN1FaMldTYmVPYjNzUSJ9.eyJhdWQiOiJodHRwczovL291dGxvb2sub2ZmaWNlLmNvbSIsImlzcyI6Imh0dHBzOi8vc3RzLndpbmRvd3MubmV0L2JiZGMzZGJiLTg2YzAtNDYyYy05YjFmLTUwNjY3ZWU2MWMwMi8iLCJpYXQiOjE3NjE3ODI3MDEsIm5iZiI6MTc2MTc4MjcwMSwiZXhwIjoxNzYxNzg3MDY3LCJhY2N0IjowLCJhY3IiOiIxIiwiYWlvIjoiQVhRQWkvOGFBQUFBY3F6aWN6ZlFJVHVnNExZQTNMVnpYQ2ZvSWFSZ1V6RGF5RlV1WjgyS0NnQUNXTTV1d1hYNVVWVzhhVWlKSHBON2pzaUVxNm5LaTlBalNvME9pZUxmTk1zQ1hlOCtrSE5JdUVqVnZkOUNiaHRpdnB5V1ZXR3JKMGMrWXBlWHJDM1FoWmdPcDFTRkNaZ3QvaXJoQnl0TjJ3PT0iLCJhbXIiOlsicHdkIl0sImFwcF9kaXNwbGF5bmFtZSI6Ikhlc2sgT0F1dGggIiwiYXBwaWQiOiI4MzEyYjAyMC02ZjJkLTRjYWEtYTg1Zi0yNTAyZGJjOTQxODIiLCJhcHBpZGFjciI6IjEiLCJlbmZwb2xpZHMiOltdLCJpZHR5cCI6InVzZXIiLCJpcGFkZHIiOiIyODA0OjE0YzpiYjgxOjg2YjY6NzdmMzo0ZTIxOmQ2MDM6ODc2MyIsImxvZ2luX2hpbnQiOiJPLkNpUmpPV0poTm1Oa09TMHlZMlptTFRSaU4yRXRPRE01TnkxbU9HTXpZV05tWTJFNU1UUVNKR0ppWkdNelpHSmlMVGcyWXpBdE5EWXlZeTA1WWpGbUxUVXdOalkzWldVMk1XTXdNaG9WYzNWd2IzSjBaVUIwWldOd1lYWXVZMjl0TG1KeUlBaz0iLCJuYW1lIjoiU3Vwb3J0ZSBUSSB8IFRFQ1BBViIsIm9pZCI6ImM5YmE2Y2Q5LTJjZmYtNGI3YS04Mzk3LWY4YzNhY2ZjYTkxNCIsInB1aWQiOiIxMDAzMjAwNDZCOUE0NDI2IiwicmgiOiIxLkFYMEF1ejNjdThDR0xFYWJIMUJtZnVZY0FnSUFBQUFBQVBFUHpnQUFBQUFBQUFCOUFENTlBQS4iLCJzY3AiOiJJTUFQLkFjY2Vzc0FzVXNlci5BbGwgUE9QLkFjY2Vzc0FzVXNlci5BbGwgU01UUC5TZW5kIiwic2lkIjoiMDAzZDVmMDktMDg3MS1lNWE0LWFjNDMtNjQ1NDRkMGY3YzMyIiwic3ViIjoiZV9aTlFYX3BOS09yM09iWGprWm10YllXNEVsam9PQUFGajRjbl92Z003dyIsInRlbmFudF9yZWdpb25fc2NvcGUiOiJTQSIsInRpZCI6ImJiZGMzZGJiLTg2YzAtNDYyYy05YjFmLTUwNjY3ZWU2MWMwMiIsInVuaXF1ZV9uYW1lIjoic3Vwb3J0ZUB0ZWNwYXYuY29tLmJyIiwidXBuIjoic3Vwb3J0ZUB0ZWNwYXYuY29tLmJyIiwidXRpIjoiUXl2QU9TZmZtVU9LZExvVzZlVC1BQSIsInZlciI6IjEuMCIsIndpZHMiOlsiYjc5ZmJmNGQtM2VmOS00Njg5LTgxNDMtNzZiMTk0ZTg1NTA5Il0sInhtc19hY3RfZmN0IjoiMyA5IiwieG1zX2F1ZF9ndWlkIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwIiwieG1zX2Z0ZCI6IjBUMnJJTjkwRnZXUklMdlhTSUFDS2ZScjVKNFowV1VGcEtXcnAwNHVXNVVCZFhOdWIzSjBhQzFrYzIxeiIsInhtc19pZHJlbCI6IjEgMTIiLCJ4bXNfc3ViX2ZjdCI6IjMgNCIsInhtc190bnRfZmN0IjoiMyA4In0.nC-9CF5GYZOTakRJIbtdQaGp2ejAv32ky0GHau9bg12l14m-xpRSKyi2YAB_2DfbA4AXU3_qwSVicbHC2pVozXV7ZJmKGesgyyR_U-VF6kVHv8MAZab2q54ZLJ6EhdR5umF8FLSWP_5oYwaP9YltuejnAxL_y0kGh6J7HlIe1TjDm5ZwgE-h_oR1GLZul4Y07Pi0JoJ3cs6ydGoTiIUcegty1iIp4hW1_Ci-rOSyaoMdaVwDD7kbGZVTz--bneTBmdhb5GiqEL7Qc8tlgHfAVEAPJ-2Li8HQhr4vuNowkMWHqgnhKsRRowIVBSig_jyqoce9WRdqNRyOJVwF6TsdNw','access_token','2025-10-30 00:10:01','2025-10-30 01:17:31'),(7656,2,'1.AX0Auz3cu8CGLEabH1BmfuYcAiCwEoMtb6pMqF8lAtvJQYJ9AD59AA.BQABAwEAAAADAOz_BQD0_xkSoUtyMZQcReGrLn1DOBHZhFfeMZgoP6Ta80XGnuMfNl6GI1oyzg-w5BG33-3ZLJnu0H_P23q55dJ_zGpbua_U3q6C1PoWBnrIFyjZhWN2TA5FQNAo1z1VLevJaqXwjRUacZK7aoEmxa9gNdKn7-mJHzWt1Nnr22Br3kbw55M2edKGVGrQ1mQuoVbIAYbPBIpyPSl8OHlL65S-doHkxPCgXFGMaXx1W8Jziwwo8zcPvAdhst99LZL21EI6Q1z1gKpWTYrUz6_CckEZPYjVZeyutw01FXQY1OxYH2gdGHKtXgf4xsM4vtu2Dk1Sfz1f6Y-nVwCJhJpoyiN1Ou2sc-fQ5ilpkepc33ACl6DgA9GkyLlOX5iZD1DHhc5th77CHkvCe5XcOgoTzktD0xXNuKw-c0cMnGjfZ3kUS7Lw-uQFSi2GyWZ4CxelbpXh7mqw1vzDjXkIyW5AeyQmFwnwMnGc-40uerp-145tAOA055XmAHV_E-V3lvGXN4FDyi4F6Xm5IMyqYGWFp_mUIggRxxMJQdLcDS3Wac6auNAsaaOuQ_dIGTJeZ5hUzbS7-KcFC4HapwOAfHxB6dYaVOSA9UGHq5y_gYy0rkcz86LkzZFdznbSEVgo_w_nuQUv7C_1nsJF5puVHjSqdu2nSjr4xspXo58D3IitnFsEWCUKsnO9c85JH6tOn_xXJD4eFWoQHL82xanBZqWKmfGf6SxzMt5Bv9FEEf3KwzEFKfEMI9rNEykJc_p4eOhyM9i5zs6jjyAvvnBd5EKr4Id4yIaepyx3mM15L3KhdixF_neq0IwClwRUOTGGKelFcwtTl9-VU15V3Bc-FoQU8LbQOxTlZfpLqP6Htx-SI_De-hJc5zCgkA9TgpaEI7UxLnpTfrILHrHaY6mdxFg9ZzndKN2NqnBP6vdZdEodYDEMtq052hbbY2JWdz9hiiKP8Ch63mFnj8y_tt3aZyBAptkuzbasIcWvVSMXBCz0-eEDdIKPtY2SmU6Aotg-0b2RWzZb206-hu2mMOUGkuFA3WDE1W1WwvG67virl3uAwwMdVKEVMM5SIbKexe47t_tUmLg8wUSpppWeyFdzZAObtcDRFlQaO7Hm2c0MdHi6QYKrR00JLRdo9UordC_SIQIVUtSN2MBMgnJ9dTAniP49ciyADWOy8mZQehgyNLqWAbTBC9BTiWZHzA2uB0C_DTLqajtc7Jw8QfSs3B6KXcaGK85jQHMPIzBciDThTFli_hqG_02tQjbtHoP0p-aeEsEN0Z8rcAffn3ur_m_weZ7eYvHqhyhuFGjasDXJCQD729bicvlY8XOLEFz1Yp_tv_-mtIIsA5-33JD1uL53HA','refresh_token','2025-10-30 00:10:01',NULL);

--
-- Table structure for table `hesk_online`
--

CREATE TABLE `hesk_online` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` smallint unsigned NOT NULL,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tmp` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  KEY `dt` (`dt`)
) ENGINE=MyISAM AUTO_INCREMENT=2659 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_online`
--


--
-- Table structure for table `hesk_pending_customer_email_changes`
--

CREATE TABLE `hesk_pending_customer_email_changes` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` mediumint unsigned NOT NULL,
  `new_email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `verification_token` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `expires_at` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
  PRIMARY KEY (`id`),
  KEY `email` (`new_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_pending_customer_email_changes`
--


--
-- Table structure for table `hesk_pipe_loops`
--

CREATE TABLE `hesk_pipe_loops` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `hits` smallint unsigned NOT NULL DEFAULT '0',
  `message_hash` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `email` (`email`,`hits`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_pipe_loops`
--

INSERT INTO `hesk_pipe_loops` VALUES (78,'m365copilotupdates@microsoft.com',0,'83b6ccbaffa0f8ae3f486acda82d1720','2025-10-15 04:06:01');

--
-- Table structure for table `hesk_pipe_rejections`
--

CREATE TABLE `hesk_pipe_rejections` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_pipe_rejections`
--

INSERT INTO `hesk_pipe_rejections` VALUES (1,'2025-06-25 11:26:02','danilo.guimaraes@sobradoconstrucao.com.br'),(2,'2025-06-25 16:59:03','jose.gilmar@tecpav.com.br'),(3,'2025-06-26 11:08:02','wesley.alves@tecpav.com.br'),(4,'2025-06-26 12:22:03','contabilidade@goiasconstrutora.com.br'),(5,'2025-06-26 20:37:02','jose.nogueira@sobradoconstrucao.com.br'),(11,'2025-08-01 12:43:02','juridico@luximovel.com.br'),(7,'2025-06-27 11:58:02','comercial@luximovel.com.br'),(8,'2025-06-28 15:39:02','analistacontabil2@goiasconstrutora.com.br'),(9,'2025-07-08 18:34:02','rubens.freitas@tecpav.com.br'),(10,'2025-07-23 17:31:02','adenilda.silva@tecpav.com.br'),(19,'2025-09-08 17:48:02','info@gitlab.com'),(16,'2025-08-21 12:20:02','joao.morais@tecpav.com.br'),(20,'2025-10-15 04:06:02','m365copilotupdates@microsoft.com');

--
-- Table structure for table `hesk_replies`
--

CREATE TABLE `hesk_replies` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `replyto` mediumint unsigned NOT NULL DEFAULT '0',
  `message` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `message_html` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `attachments` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `staffid` smallint unsigned NOT NULL DEFAULT '0',
  `customer_id` mediumint unsigned DEFAULT NULL,
  `rating` enum('1','5') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `read` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `eid` varchar(1000) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `replyto` (`replyto`),
  KEY `dt` (`dt`),
  KEY `staffid` (`staffid`),
  KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1125 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_replies`
--

INSERT INTO `hesk_replies` VALUES (14,30,'Boa tarde, Fernando!<br />\n<br />\nTabelas copiadas para todas as coligadas onde não estavam presentes.<br />\n<br />\n Peço desculpas pela demora no atendimento.','<p class=\"MsoNormal\"><span style=\"color:#50164a;\">Boa tarde, Fernando!</span></p>\n<p class=\"MsoNormal\"><span style=\"color:#50164a;\">Tabelas copiadas para todas as coligadas onde não estavam presentes.</span></p>\n<p class=\"MsoNormal\"><span style=\"color:#50164a;\"> </span><span style=\"color:#50164a;\">Peço desculpas pela demora no atendimento.</span></p>','2025-03-28 19:51:32','',5,NULL,NULL,'0',NULL),(13,27,'Foi feito a parametrização das coligadas 1,2,3,7,20,29,52,57,59,60,61,62,63,64,67 na base P_RMCorporativo em 25/03/2025.','<p>Foi feito a parametrização das coligadas 1,2,3,7,20,29,52,57,59,60,61,62,63,64,67 na base P_RMCorporativo em 25/03/2025.</p>','2025-03-25 21:04:52','',10,NULL,NULL,'1',NULL),(15,31,'- Ao tentar fazer o zeramento das contas de resultados nos deparamos com erros nos rateios gerenciais dos lançamentos gerados nos rateios dos custos dos consórcios;<br />\n- Foram feitas as correções<br />\n- Foi efetuado o zeramento<br />\n- Foi feita a sincronização entre as bases de dados<br />\n- Foi gerado o arquivo ECD para validação no PVA.','<ul>\n<li>Ao tentar fazer o zeramento das contas de resultados nos deparamos com erros nos rateios gerenciais dos lançamentos gerados nos rateios dos custos dos consórcios;</li>\n<li>Foram feitas as correções</li>\n<li>Foi efetuado o zeramento</li>\n<li>Foi feita a sincronização entre as bases de dados</li>\n<li>Foi gerado o arquivo ECD para validação no PVA.</li>\n</ul>','2025-03-28 20:03:18','',5,NULL,NULL,'0',NULL),(16,32,'Boa tarde!<br />\n<br />\nSeção, CEI do Tomador e Lotação Tributária cadastrados nas coligadas 2,3 e 7','<p class=\"MsoNormal\"><span style=\"font-family:sans-serif;color:#50164a;\">Boa tarde!</span></p>\n<p class=\"MsoNormal\"><span style=\"font-family:sans-serif;color:#50164a;\">Seção, CEI do Tomador e Lotação Tributária cadastrados nas coligadas 2,3 e 7</span></p>','2025-03-28 20:33:16','',5,NULL,NULL,'1',NULL),(17,33,'Havia um erro no algoritmo da fórmula de valor do evento 6015<br />\n<br />\nCódigo da fórmula: EVT6015:<br />\n<br />\nO erro foi corrigido.<br />\n<br />\n ','<p>Havia um erro no algoritmo da fórmula de valor do evento 6015</p>\n<p>Código da fórmula: EVT6015:</p>\n<p>O erro foi corrigido.</p>\n<p> </p>','2025-03-28 20:43:10','',5,NULL,NULL,'0',NULL),(18,34,'Conforme atendimento realizado via ticket.','<p>Conforme atendimento realizado via ticket.</p>','2025-03-31 11:37:23','',2,NULL,NULL,'1',NULL),(19,35,'Bom dia, Dra. Glaucia.<br />\n<br />\nEle já tem permissão na pasta do jurídico com leitura e para modificar para controle total ?<br />\n<br />\nFico no aguardo.<br />\n<br />\nObrigado.','<p class=\"MsoNormal\"><span>Bom dia, Dra. Glaucia.</span></p>\n<p class=\"MsoNormal\"><span>Ele já tem permissão na pasta do jurídico com leitura e para modificar para controle total ?</span></p>\n<p class=\"MsoNormal\"><span>Fico no aguardo.</span></p>\n<p class=\"MsoNormal\"><span>Obrigado.</span></p>','2025-03-31 12:01:14','',9,NULL,NULL,'0',NULL),(20,36,'Inseridos...  Batidas, Abonos, Rateios Fixos e Valores associados.<br />\n<br />\n ','<p><span>Inseridos...  Batidas, Abonos, Rateios Fixos e Valores associados.</span></p>\n<p> </p>','2025-03-31 12:34:06','',5,NULL,NULL,'0',NULL),(21,37,'Ao lançar a diferença de férias é necessário informar os filtros conforme o contexto desejado, neste caso era o período de gozo de férias (início e fim de gozo), o usuário estava informando somente data início e fim dentro do mês de férias.<br />\n<br />\n---------<br />\n<br />\nApós efetuar o lançamento com o filtro ajustado foi observado que não houve nenhuma diferença a ser paga ao funcionário, o que é normal pois podem não ter variações entre o cálculo na data do cálculo e o período de gozo.','<p>Ao lançar a diferença de férias é necessário informar os filtros conforme o contexto desejado, neste caso era o período de gozo de férias (início e fim de gozo), o usuário estava informando somente data início e fim dentro do mês de férias.</p>\n<p>---------</p>\n<p>Após efetuar o lançamento com o filtro ajustado foi observado que não houve nenhuma diferença a ser paga ao funcionário, o que é normal pois podem não ter variações entre o cálculo na data do cálculo e o período de gozo.</p>','2025-03-31 13:26:52','',5,NULL,NULL,'0',NULL),(22,38,'Ao acessar o sistema foi verificado que o molde não havia sido criado para o zeramento:<br />\n<br />\n<br />\n<br />\nUsuário afirmou ter preenchido corretamente;<br />\n<br />\nEntão deduzimos que pode ter preenchido e não salvou o molde.<br />\n<br />\nUsuário respondeu que iria refazer;<br />\n<br />\nAo refazer obteve a mensagem abaixo:<br />\n<br />\n<br />\n<br />\nO usuário foi orientado a prosseguir','<p>Ao acessar o sistema foi verificado que o molde não havia sido criado para o zeramento:</p>\n<p><img src=\"data:image/jpeg;base64,[encoded data, 85960 characters]\" width=\"302\" height=\"194\" alt=\"Z\" /></p>\n<p>Usuário afirmou ter preenchido corretamente;</p>\n<p>Então deduzimos que pode ter preenchido e não salvou o molde.</p>\n<p>Usuário respondeu que iria refazer;</p>\n<p>Ao refazer obteve a mensagem abaixo:</p>\n<p><img src=\"data:image/png;base64,[encoded data, 148044 characters]\" width=\"308\" height=\"155\" alt=\"+yf8H5MuOS9efHvZAAAAAElFTkSuQmCC\" /></p>\n<p>O usuário foi orientado a prosseguir</p>','2025-03-31 13:46:35','',5,NULL,NULL,'0',NULL),(23,35,'Ok, Dra.<br />\n<br />\nVou orientá-lo como deve fazer o acesso as pastas compartilhadas.<br />\n<br />\nObrigado.','<p class=\"MsoNormal\">Ok, Dra.</p>\n<p class=\"MsoNormal\">Vou orientá-lo como deve fazer o acesso as pastas compartilhadas.</p>\n<p class=\"MsoNormal\">Obrigado.</p>','2025-03-31 13:49:06','',9,NULL,NULL,'0',NULL),