**REGION converte-valores-decimais Text.FromNumber Number: CSVTable[linha][3] DecimalPlaces: 2 UseThousandsSeparator: True FormattedNumber=> valor_decimal **ENDREGION IF (WebAutomation.IfWebPageContains.WebPageContainsElement BrowserInstance: sei Control: appmask['Web Page \'h ... 274d1fe3de\'']['Image \'Reabrir Processo\'']) THEN WebAutomation.Click.Click BrowserInstance: sei Control: appmask['Web Page \'h ... e97cfa4f2a\'']['Image \'Reabrir Processo\' 2'] ClickType: WebAutomation.ClickType.LeftClick MouseClick: True WaitForPageToLoadTimeout: 60 MousePositionRelativeToElement: WebAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 END WAIT 3 WebAutomation.Click.Click BrowserInstance: sei Control: appmask['Web Page \'h ... add3bdd7eb\'']['Image \'Incluir Documento\''] ClickType: WebAutomation.ClickType.LeftClick MouseClick: True WaitForPageToLoadTimeout: 60 MousePositionRelativeToElement: WebAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 IF (UIAutomation.IfImage.ExistsOnScreen Images: [imgrepo['Image_2']] FindAllImages: False Tolerance: 10 SearchAlgorithm: UIAutomation.ImageFinderAlgorithm.Legacy) THEN WebAutomation.Click.Click BrowserInstance: sei Control: appmask['Web Page \'h ... add3bdd7eb\'']['Image \'Exibir todos os tipos\''] ClickType: WebAutomation.ClickType.LeftClick MouseClick: True WaitForPageToLoadTimeout: 60 MousePositionRelativeToElement: WebAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 END MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: sei TextToSend: $'''despacho{Tab}{Tab}{Tab}{Tab}{Tab}{Tab}{Tab}{Tab}{Enter}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: False WAIT 3 MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: sei TextToSend: $'''{Tab}{Tab}{Tab}{Tab}{Tab}Compensação Previdenciária - %processo%{Tab}%processo%-%mes_competencia%''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: False WebAutomation.SelectRadioButton.SelectRadioButton BrowserInstance: sei Control: appmask['Web Page \'h ... 7db448640d\'']['Label'] WaitForPageToLoadTimeout: 60 WAIT 2 WebAutomation.PressButton.PressButton BrowserInstance: sei Control: appmask['Web Page \'h ... be05284498\'']['Span \'S\''] WaitForPageToLoadTimeout: 60 WAIT 5 MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Tab}{Tab}{Tab}''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{LControlKey}({F})Destinatário(s): @destinatarios_virgula_espaco@''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Escape}{Delete}Destinatário(s): Departamento de Execução da Despesa - Compensação Previdenciária (IPSEMG/DEED-COMPREV)''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{LControlKey}({F})[Inserir texto do despacho].''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False IF processo = $'''Valores a pagar''' THEN DISABLE MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Escape}Prezados, Segue o %processo% conforme as informações abaixo, referente a compensação previdenciária. CNPJ: 29.986.312/0001-06 Participante: ESPIRITO SANTO Vencimento: 19/02/2025 Valor: 32285,95 Estado Banco: BANCO DO ESTADO DO ESPIRITO SANTO S/A Número: 21 Conta corrente: 2745781 DV: 1 Agência: 675 DV: Atenciosamente, Departamento de Compensação Financeira Previdenciária''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False IF lista_cnpj[linha][2] = $'''29.979.036/0001-40''' THEN MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Escape}Prezados, Seguem as informações de {Control}({B})%processo%{Control}({B}) referente à compensação previdenciária. Informamos que o pagamento para o RPPS de Dep. de Central. Serv. de Inativos e Pens., será efetuado através de guia de GRU e a mesma será anexada a esse SEI com validade de 2 dias de utilização. CNPJ: %CSVTable[linha][0]% Participante: %CSVTable[linha][1]% Competência: %mes_competencia% Vencimento: %vencimento% {Control}({B})Valor:%valor_decimal%{Control}({B}) Banco: %CSVTable[linha][5]% Número: %CSVTable[linha][6]% Conta corrente: %CSVTable[linha][7]% DV: %CSVTable[linha][8]% Agência: %CSVTable[linha][9]% DV:%CSVTable[linha][10]% Atenciosamente, Departamento de Compensação Financeira Previdenciária''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False ELSE IF lista_cnpj[linha][2] = $'''00.394.460/0562-87''' THEN MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Escape}Prezados, Seguem as informações de {Control}({B})%processo%{Control}({B}) referente à compensação previdenciária. Informamos que o pagamento para o RPPS de Dep. de Central. Serv. de Inativos e Pens., será efetuado através de guia de GRU e a mesma será anexada a esse SEI com validade de 2 dias de utilização. CNPJ: %CSVTable[linha][0]% Participante: %CSVTable[linha][1]% Competência: %mes_competencia% Vencimento: %vencimento% {Control}({B})Valor: %valor_decimal%{Control}({B}) Banco: %CSVTable[linha][5]% Número: %CSVTable[linha][6]% Conta corrente: %CSVTable[linha][7]% DV: %CSVTable[linha][8]% Agência: %CSVTable[linha][9]% DV:%CSVTable[linha][10]% Atenciosamente, Departamento de Compensação Financeira Previdenciária''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False END MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Escape}Prezados, Seguem as informações de {Control}({B})%processo%{Control}({B}) referente à compensação previdenciária. CNPJ: %CSVTable[linha][0]% Participante: %CSVTable[linha][1]% Competência: %mes_competencia% Vencimento: %vencimento% {Control}({B})Valor: %valor_decimal%{Control}({B}) Banco: %CSVTable[linha][5]% Número: %CSVTable[linha][6]% Conta corrente: %CSVTable[linha][7]% DV: %CSVTable[linha][8]% Agência: %CSVTable[linha][9]% DV:%CSVTable[linha][10]% Atenciosamente, Departamento de Compensação Financeira Previdenciária''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False ELSE IF processo = $'''Valores a receber''' THEN DISABLE MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Escape}Prezados, Segue o %processo% conforme as informações abaixo, referente a compensação previdenciária. CNPJ: 29.986.312/0001-06 Participante: ESPIRITO SANTO Vencimento: 19/02/2025 Valor: 32285,95 Estado Banco: BANCO DO ESTADO DO ESPIRITO SANTO S/A Número: 21 Conta corrente: 2745781 DV: 1 Agência: 675 DV: Atenciosamente, Departamento de Compensação Financeira Previdenciária''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Escape}Prezados, Seguem as informações de {Control}({B})%processo%,{Control}({B}) referente à compensação previdenciária. CNPJ: %CSVTable[linha][0]% Participante: %CSVTable[linha][1]% {Control}({B})Vencimento: %vencimento% {Control}({B}) Competência: %mes_competencia% Valor:%valor_decimal% Atenciosamente, Departamento de Compensação Financeira Previdenciária''' DelayBetweenKeystrokes: 50 SendTextAsHardwareKeys: False END MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Control}({Alt}({S})) ''' DelayBetweenKeystrokes: 600 SendTextAsHardwareKeys: True WAIT 2 MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{Alt}({F4}) ''' DelayBetweenKeystrokes: 600 SendTextAsHardwareKeys: True WAIT 2 **REGION inclui_bloco WAIT 1 WebAutomation.Click.Click BrowserInstance: sei Control: appmask['Web Page \'h ... 52b070567c\'']['Image \'Incluir em Bloco de Assinatura\''] ClickType: WebAutomation.ClickType.LeftClick MouseClick: True WaitForPageToLoadTimeout: 60 MousePositionRelativeToElement: WebAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 WAIT 2 WAIT (WebAutomation.WaitForWebPageContent.WebPageToContainText BrowserInstance: sei Text: $'''Incluir em Bloco de Assinatura''') WAIT 2 MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: sei TextToSend: $'''{Tab}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: False MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: sei TextToSend: $'''{LShiftKey}({Tab})''' DelayBetweenKeystrokes: 30 SendTextAsHardwareKeys: False LABEL seleciona_bloco IF (WebAutomation.IfWebPageContains.WebPageDoesNotContainText BrowserInstance: sei Text: $'''6402164 - Financeiro da Compensação''') THEN MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: sei TextToSend: $'''{Down}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: False WAIT 2 GOTO seleciona_bloco END WebAutomation.Click.Click BrowserInstance: sei Control: appmask['Web Page \'h ... 9a3c385e66\'']['Button \'Incluir\''] ClickType: WebAutomation.ClickType.LeftClick MouseClick: True WaitForPageToLoadTimeout: 60 MousePositionRelativeToElement: WebAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 WAIT 1 **ENDREGION WebAutomation.Click.Click BrowserInstance: sei Control: appmask['Web Page \'h ... a37674985a\'']['Image \'Controle de Processos\''] ClickType: WebAutomation.ClickType.LeftClick MouseClick: True WaitForPageToLoadTimeout: 60 MousePositionRelativeToElement: WebAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 # [ControlRepository][PowerAutomateDesktop] { "ControlRepositorySymbols": [ { "IgnoreImagesOnSerialization": false, "Repository": "{\r\n \"Screens\": [\r\n {\r\n \"Controls\": [\r\n {\r\n \"AutomationProtocol\": \"uia3\",\r\n \"ScreenShot\": null,\r\n \"ElementTypeName\": \"Image\",\r\n \"InstanceId\": \"43227180-95b0-4038-82c6-88a769275f75\",\r\n \"Name\": \"Image 'Reabrir Processo'\",\r\n \"SelectorCount\": 1,\r\n \"Selectors\": [\r\n {\r\n \"CustomSelector\": null,\r\n \"Elements\": [\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Body 'GOVERNO DO ESTADO DE MINAS GERAIS Versão d ... otstrap(\\\"procedimento_trabalhar\\\") Processo'\",\r\n \"Tag\": \"body\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"vh-100 vw-100 d-flex flex-column m-0 border-0\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"divInfraAreaGlobal\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'GOVERNO DO ESTADO DE MINAS GERAIS Versão d ... otstrap(\\\"procedimento_trabalhar\\\") Processo'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"w-100 flex-grow-1 d-flex flex-row divInfraAreaTela\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"divInfraAreaTela\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'Acompanhamento Especial Base de Conhecimento Blocos ... otstrap(\\\"procedimento_trabalhar\\\") Processo'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \" flex-grow-1 px-3\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"divInfraAreaTelaD\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'Processo'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"w-100 d-flex flex-grow-1 flex-lg-row\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"divConteudo\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'divConteudo'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"flex-grow-1 d-none d-lg-block h-100 divLinha\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"divIframeVisualizacao\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'divIframeVisualizacao'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \" w-100\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"ifrVisualizacao\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"ifrVisualizacao\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Src\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"controlador.php?acao=arvore_visualizar&acao_origem=procedimento_visualizar&id_procedimento=885407751&infra_sistema=100000100&infra_unidade_atual=110027981&infra_hash=f104bd5a2ea9c06ad6234c02ce09b4a08d0b0cb3ca42a8b0970b982d913afe8e\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"SrcDoc\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Inline frame 'ifrVisualizacao'\",\r\n \"Tag\": \"iframe\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"HTML document 'SEI - Visualizar Árvore