Ponto de Entrada
Descrição: | Ponto de Entrada que alteração do layout do workflow de envio de alerta de O.S. liberada. |
Eventos: | Workflow (MNTW215) |
Programa Fonte: | MNTW215.PRW |
Função: | MNTW2151() |
Retorno: | Nome | Tipo | Descrição | Obrigatório | cBody
| caracter | HTML do workflow | Sim |
|
Exemplo:
#Include 'Protheus.ch'
User Function MNTW2151()
Local cBody := ParamIXB[1]
Local n
Local cPlano
Local cOrdem
Local cCodBem
Local cNomBem
Local cServico
Local cNomSer
Local cCCusto
Local cNCusto
Local cPriorid
Local cDtPrev
Local cHrPrev
Local aInsumos := {}
dbSelectArea("STJ")
cPlano := STJ->TJ_PLANO
cOrdem := STJ->TJ_ORDEM
cCodBem := STJ->TJ_CODBEM
cNomBem := If(STJ->TJ_TIPOOS = "B",Posicione("ST9",1,xFilial("ST9")+STJ->TJ_CODBEM,"T9_NOME"),;
Posicione("TAF",7,xFilial("TAF")+"X2"+Substr(STJ->TJ_CODBEM,1,3),"TAF_NOMNIV"))
cServico := STJ->TJ_SERVICO
cNomSer := Posicione("ST4",1,xFilial("ST4")+STJ->TJ_SERVICO,'T4_NOME')
cCCusto := STJ->TJ_CCUSTO
cNCusto := Posicione("CTT",1,xFilial("CTT")+STJ->TJ_CCUSTO,'CTT_DESC01')
cPriorid := STJ->TJ_PRIORID
cDtPrev := STJ->TJ_DTMPINI
cHrPrev := STJ->TJ_HOMPINI
dbSelectArea("STL")
dbSetOrder(1)
dbSeek(xFilial("STL")+cOrdem+cPlano)
While !Eof() .And. STL->TL_ORDEM == cOrdem .And. cPlano == STL->TL_PLANO
aAdd(aInsumos,{STL->TL_CODIGO, STL->TL_TIPOREG, STL->TL_QUANTID, STL->TL_UNIDADE,;
STL->TL_SEQRELA, STL->TL_DTINICI, STL->TL_HOINICI, STL->TL_DTFIM, STL->TL_HOFIM})
dbSkip()
EndDo
//----Workflow padrão----
cBody := '<html>'
cBody += ' <head>'
cBody += ' <meta http-equiv="Content-Language" content="pt-br">'
cBody += ' <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">'
cBody += ' <meta name="GENERATOR" content="Microsoft FrontPage 4.0">'
cBody += ' <meta name="ProgId" content="FrontPage.Editor.Document">'
cBody += ' <title>Aviso sobre Solicitaçãoo de Serviços</title>'
cBody += ' </head>'
cBody += ' <body bgcolor="#FFFFFF">'
cBody += ' <noscript><b><U><font face="Arial" size=2 color="#FF0000"></font></b>'
cBody += ' </noscript>'
cBody += ' <p><b><font face="Arial"> '+"O.S. Liberada"+'</font></b></p>'
cBody += ' <table border=0 WIDTH=100% cellpadding="1">'
cBody += ' <tr>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Ordem"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Plano"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Bem"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Descrição"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Serviço"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Descrição"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Centro de Custo"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Descrição"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">'+"Prioridade"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="center"><b><font face="Arial" size="2">'+"Data Prev. Início"+'</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="center"><b><font face="Arial" size="2">'+"Hora Prev. Início"+'</font></b></td>'
cBody += ' </tr>'
cBody += ' <tr>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cOrdem+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cPlano+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cCodBem+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cNomBem+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cServico+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cNomSer+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cCCusto+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cNCusto+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+cPriorid+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="center"><font face="Arial" size="1">'+DToC(cDtPrev)+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="center"><font face="Arial" size="1">'+cValToChar(cHrPrev)+'</font></td>'
cBody += ' </tr>'
cBody += ' </table>'
//----Inicio-Customização----
cBody += ' <p><b><font face="Arial">Insumos Previstos</font></b></p>'
cBody += ' <Table>'
cBody += ' <tr>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Codigo</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Tipo</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Quant. Utiliz.</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Unidade</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Sequência</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Dt. Inicio</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Hr. Inicio</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Dt. Fim</font></b></td>'
cBody += ' <td bgcolor="#C0C0C0" align="left"><b><font face="Arial" size="2">Hr. Fim</font></b></td>'
cBody += ' </tr>'
For n := 1 To Len(aInsumos)
cBody += ' <tr>'
cBody += ' <td bgcolor="#EEEEEE" align="left"><font face="Arial" size="1">'+aInsumos[n,1]+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="center"><font face="Arial" size="1">'+aInsumos[n,2]+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="right"><font face="Arial" size="1">'+cValToChar(aInsumos[n,3])+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="center"><font face="Arial" size="1">'+aInsumos[n,4]+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="right"><font face="Arial" size="1">'+aInsumos[n,5]+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="center"><font face="Arial" size="1">'+DtoC(aInsumos[n,6])+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="center"><font face="Arial" size="1">'+cValToChar(aInsumos[n,7])+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="center"><font face="Arial" size="1">'+DtoC(aInsumos[n,8])+'</font></td>'
cBody += ' <td bgcolor="#EEEEEE" align="center"><font face="Arial" size="1">'+cValToChar(aInsumos[n,9])+'</font></td>'
cBody += ' </tr>'
Next n
//-------Fim-Customização----
cBody += ' </table>'
cBody += ' <br><hr>'
cBody += ' </body>'
cBody += '</html>'
Return cBody