Duração (h)Interna / ExternaÁrea de formaçãoRequer avaliação?Gestor da FormaçãoAvaliador da formaçãoData prevista de avaliação
Objetivos e sumárioParticipantesCertificado de formaçãoCertificado emitido porData de emissão / receçãoCertificados emitidos / recebidos?
Clique para inserir material de formação e outros anexosClique para imprimir os registo de formaçãoClique para imprimir os registo de presençasClique para imprimir os certificados
aTipo de FormaçãoFormador / EntidadeData de início e fimSelecione o plano formaçãoData de registo
Incluída no plano de formação?Tipo de planoNotas da formaçãoID AGIRIDLinhaJustificação
Cancelar formação
Clique para cancelarFormaçãoModo de criaçãoRegistado porDepartmento/UnidadeCusto (€)DominioClique para inserir presenças de utilizadores não Agir
0 - Mau a 5 -Excelente. Caso a avaliação seja feita por entidade externa numa outra escala, faça sempre a conversão para a escala Standard (0 a 5) Média da avaliação da formaçãoEvaluationOfTrainingMetodologiaNotas de avaliação da eficáciaAvaliado porData de avaliação
Lista de presenças e avaliação da eficácia
Table Column
Table Column
Nº de participantesCriar os pedidos de avaliação pelos formandos
",
"css": "",
"js": "// CONVERT(nvarchar, idDate, 103) AS 'idDate' para datas caso o Chrome esteja INGLES\r\n\r\nvar PlanoFormacoesNome = 'Plano de formação'; //Colocar nome do workflow Plano de formacao\r\nvar EstadoFormacao = 'Implementação'; //Estado em que workflow precisa de estar\r\n\r\nlet origin = lpa_sql(\"select count(AssociacaoEsturturaID) as C from AssociacaoTabelaEstrutura where AssociacaoEstruturaID = @id\", {\r\n id: lpa_wkf_id()\r\n})\r\nconsole.log(origin)\r\nmoment().locale('pt')\r\nid = 956\r\n/* LOAD */\r\nConditionalVisibility();\r\ncheckCriacao(true)\r\nDefaultDataPrevistaAvaliacao()\r\nCarregarFormacoes();\r\n\r\n\r\nfunction checkCriacao(load) {\r\n if (lpa_val('CreateType') == 'Modo Catálogo de Formação') {\r\n lpa_visible('TrainingCombo', true)\r\n lpa_visible('Training', false)\r\n lpa_visible('PlanoDeFormacao', true)\r\n lpa_visible('PlanoDeFormacaoL', true)\r\n formacoes = lpa_sql(\"select EstruturaID, EstruturaCodigo from Estrutura inner join EstruturaWorkflow on EstruturaWorkflowID = WorkflowID inner join EstruturaConfigEstado on EstadoID=EstruturaEstado WHERE WorkflowNome = @PlanoFormacoesNome and EstadoNome = @EstadoFormacao and (select COUNT(PermissaoID) FROM EstruturaPermissao where PermissaoEstruturaID = EstruturaID AND PermissaoColaboradorID = @ColaboradorID) > 0 order by EstruturaID DESC\", {\r\n PlanoFormacoesNome: PlanoFormacoesNome,\r\n EstadoFormacao: EstadoFormacao,\r\n ColaboradorID: lpa_user_id()\r\n })\r\n\r\n lpa_json_content('PlanoDeFormacao', formacoes, 'EstruturaCodigo', 'EstruturaID')\r\n } else if (lpa_val('CreateType') == 'Extra Plano' && lpa_status() == 'Planeada') {\r\n lpa_visible('TrainingCombo', false)\r\n lpa_visible('Training', true)\r\n lpa_visible('PlanoDeFormacao', false)\r\n lpa_visible('PlanoDeFormacaoL', false)\r\n checkFormacao(load)\r\n } else {\r\n lpa_visible('PlanoDeFormacao', false)\r\n lpa_visible('PlanoDeFormacaoL', false)\r\n lpa_visible('TrainingCombo', false)\r\n lpa_visible('Training', true)\r\n checkFormacao(load)\r\n }\r\n}\r\n\r\nfunction checkFormacao(load) {\r\n if (lpa_val('TrainingCombo') !== '' && lpa_val('CreateType') == 'Modo Catálogo de Formação') {\r\n var formacao = lpa_sql(\"select TipoFormacao, CONVERT(nvarchar, StartDate, 103) AS 'StartDate', CONVERT(nvarchar, EndDate, 103) AS 'EndDate', Trainer, Recipients, Duration, TrainingManager, Cost From TrainingPlan where TrainingPlanID = @linha\", {\r\n linha: lpa_val('TrainingCombo')\r\n })\r\n var campos = lpa_wkf_val(lpa_val('PlanoDeFormacao'))\r\n console.log(campos)\r\n lpa_val('Training', lpa_value('TrainingCombo'))\r\n lpa_value('TipoFormacao', formacao.TipoFormacao)\r\n lpa_value('IDLinha', lpa_val('TrainingCombo'))\r\n lpa_value('StartDate', lpa_date(formacao.StartDate).format('DD/MM/YYYY'))\r\n lpa_value('EndDate', lpa_date(formacao.EndDate).format('DD/MM/YYYY'))\r\n // lpa_value('StartDate', lpa_date(formacao.StartDate).format('DD/MM/YYYY'))\r\n // lpa_value('EndDate', lpa_date(formacao.EndDate).format('DD/MM/YYYY'))\r\n lpa_value('Trainer', formacao.Trainer)\r\n lpa_value('Recipients', formacao.Recipients)\r\n lpa_value('Duration', formacao.Duration)\r\n lpa_value('TrainingManager', formacao.TrainingManager)\r\n lpa_value('IncludedInTrainingPlan', 'Sim')\r\n lpa_value('Department', campos.Department)\r\n lpa_value('Cost', formacao.Cost)\r\n } else if(!load) {\r\n lpa_val('TrainingCombo', '')\r\n lpa_val('Training', '')\r\n lpa_value('TipoFormacao', '')\r\n lpa_value('StartDate', '')\r\n lpa_value('EndDate', '')\r\n lpa_value('Trainer', '')\r\n lpa_value('Recipients', '')\r\n lpa_value('Duration', '')\r\n lpa_value('TrainingManager', '')\r\n lpa_value('IncludedInTrainingPlan', '')\r\n lpa_val('Department', '')\r\n lpa_value('Cost', '')\r\n }\r\n}\r\n\r\n\r\n\r\n\r\n// function gerirTabela() {\r\n// // var fatherID = lpa_sql(\"select EstruturaID From TrainingPlan where TrainingPlanID = @linha\",{\r\n// // linha:lpa_val('IDLinha')\r\n// // })\r\n// if (lpa_val('CreateType') == 'Modo Catálogo de Formação') {\r\n// lpa_table_save('Participants')\r\n// if (lpa_status() === 'Avaliação') {\r\n// sql = 'insert into TrainingPlanHistory (EstruturaID,Formando,Training,TipoFormacao,StartDate,EndDate,Trainer,Recipients,Duration,TrainingManager,wkfFormacao,Estado) values (@id,@Formando,@Training,@TipoFormacao,@StartDate,@EndDate,@Trainer,@Recipients,@Duration,@TrainingManager,@wkfFormacao, @Estado)'\r\n\r\n// } else if (lpa_status() === 'Fechado' || lpa_status() === 'Cancelado') {\r\n\r\n// sql = 'update TrainingPlanHistory set Formando = @Formando,Training = @Training,TipoFormacao = @TipoFormacao,StartDate = @StartDate,EndDate = @EndDate,Trainer = @Trainer,Recipients = @Recipients,Duration = @Duration,TrainingManager = @TrainingManager,wkfFormacao = @wkfFormacao, Estado=@Estado, EvaluationOfTraining=@EvaluationOfTraining where EstruturaID = @id and wkfFormacao=@wkfFormacao'\r\n// }\r\n// lpa_sql(sql, {\r\n// id: lpa_value('IDAGIR'),\r\n// Formando: lpa_val('RegistadoPor'),\r\n// Training: lpa_val('Training'),\r\n// TipoFormacao: lpa_value('TipoFormacao'),\r\n// StartDate: moment.utc(lpa_value('StartDate'), \"DD/MM/YYYY\"),\r\n// EndDate: moment.utc(lpa_value('EndDate'), \"DD/MM/YYYY\"),\r\n// Trainer: lpa_value('Trainer'),\r\n// Recipients: lpa_value('Recipients'),\r\n// Duration: lpa_value('Duration'),\r\n// TrainingManager: lpa_value('TrainingManager'),\r\n// wkfFormacao: lpa_wkf_id(),\r\n// Estado: lpa_status(),\r\n// EvaluationOfTraining: lpa_value('EvaluationOfTraining')\r\n// })\r\n// }\r\n// }\r\n\r\nfunction gerirTabela(insert) {\r\n console.log('testes')\r\n var Associacao = insert\r\n var fatherID = lpa_sql(\"select EstruturaID From TrainingPlan where TrainingPlanID = @linha\", {\r\n linha: lpa_val('TrainingCombo')\r\n })\r\n if (fatherID != null) {\r\n if (insert) {\r\n sql = 'insert into TrainingPlanHistory (EstruturaID,Formando,Training,TipoFormacao,StartDate,EndDate,Trainer,Cost,Recipients,Duration,TrainingManager,wkfFormacao) values (@id,@Formando,@Training,@TipoFormacao,@StartDate,@EndDate,@Trainer,@Cost,@Recipients,@Duration,@TrainingManager,@wkfFormacao)'\r\n } else {\r\n sql = 'update TrainingPlanHistory set Formando = @Formando,Training = @Training,TipoFormacao = @TipoFormacao,StartDate = @StartDate,EndDate = @EndDate,Trainer = @Trainer,Recipients = @Recipients,Duration = @Duration,TrainingManager = @TrainingManager where EstruturaID = @id and wkfFormacao = @wkfFormacao'\r\n }\r\n lpa_sql(sql, {\r\n id: fatherID.EstruturaID,\r\n Formando: lpa_val('RegistadoPor'),\r\n Training: lpa_val('Training'),\r\n TipoFormacao: lpa_value('TipoFormacao'),\r\n StartDate: lpa_date_sql(lpa_val('StartDate')),\r\n EndDate: lpa_date_sql(lpa_val('EndDate')),\r\n Trainer: lpa_value('Trainer'),\r\n Cost: lpa_value('Cost'),\r\n Recipients: lpa_value('Recipients'),\r\n Duration: lpa_value('Duration'),\r\n TrainingManager: lpa_value('TrainingManager'),\r\n wkfFormacao: lpa_wkf_id()\r\n })\r\n if (Associacao) {\r\n var RecemCriado = lpa_sql(\"Select * From TrainingPlanHistory where wkfFormacao = @id\", {\r\n id: lpa_wkf_id()\r\n }, false)\r\n lpa_sql('INSERT INTO AssociacaoTabelaEstrutura (AssociacaoTabela, AssociacaoLinhaID, AssociacaoEstruturaID) VALUES (@tabela, @linha, @wkf)', {\r\n tabela: 'TrainingPlanHistory',\r\n linha: RecemCriado.TrainingPlanHistoryID,\r\n wkf: lpa_wkf_id()\r\n });\r\n }\r\n }\r\n}\r\n\r\n/* TABLE & TABLE FUNCTIONS */\r\n\r\nfunction tableOptions() {\r\n\r\n if (lpa_status() == 'Planeada') {\r\n lpa_table_column_visible('Participants', 'MeetingObjectives', false)\r\n lpa_table_column_visible('Participants', 'WorkforceApplicability', false)\r\n lpa_table_column_visible('Participants', 'ParticipantEvaluation', false)\r\n lpa_table_column_visible('Participants', 'EvaluationOfTraining', false)\r\n lpa_table_column_visible('Participants', 'EvaliatioComments', false)\r\n lpa_table_column_visible('Participants', 'Link', false)\r\n lpa_table_column_visible('Participants', 'agirstatus', false)\r\n lpa_table_allow_new('Participants', true);\r\n lpa_table_allow_remove('Participants', true);\r\n LPA('Participants').find(\"a.linkCriarNovoWorkflow\").parent().prev('td').hide();\r\n }\r\n if (lpa_status() == 'Avaliação') {\r\n\r\n if (lpa_value('RequerAvaliacaoEficacia')==='Sim') {\r\n lpa_table_column_visible('Participants', 'MeetingObjectives', true)\r\n lpa_table_column_visible('Participants', 'ParticipantEvaluation', true)\r\n lpa_table_column_visible('Participants', 'EvaluationOfTraining', true)\r\n lpa_table_column_visible('Participants', 'EvaliatioComments', true)\r\n lpa_table_column_visible('Participants', 'WorkforceApplicability', true)\r\n\r\n }else {\r\n lpa_table_column_visible('Participants', 'MeetingObjectives', false)\r\n lpa_table_column_visible('Participants', 'ParticipantEvaluation', false)\r\n lpa_table_column_visible('Participants', 'EvaluationOfTraining', false)\r\n lpa_table_column_visible('Participants', 'EvaliatioComments', false)\r\n lpa_table_column_visible('Participants', 'WorkforceApplicability', false)\r\n }\r\n\r\n lpa_table_column_required('Participants', 'Participant', true);\r\n lpa_table_column_required('Participants', 'Hours', true);\r\n lpa_table_column_visible('Participants', 'Link', true)\r\n lpa_table_column_visible('Participants', 'agirstatus', true)\r\n lpa_table_allow_new('Participants', false);\r\n lpa_table_allow_remove('Participants', false);\r\n LPA('Participants').find(\"a.linkCriarNovoWorkflow\").parent().prev('td').show();\r\n if (lpa_value('EfficacyAssessmentMethodology') == 'Standard') {\r\n lpa_table_column_required('Participants', 'MeetingObjectives', true);\r\n lpa_table_column_required('Participants', 'WorkforceApplicability', true);\r\n } else {\r\n lpa_table_column_required('Participants', 'MeetingObjectives', false);\r\n lpa_table_column_required('Participants', 'WorkforceApplicability', false);\r\n }\r\n } else {\r\n lpa_table_column_required('Participants', 'Participant', false);\r\n lpa_table_column_required('Participants', 'Hours', false);\r\n }\r\n if (lpa_status() === 'Fechado'|| lpa_status() === 'Cancelado') {\r\n if (lpa_value('RequerAvaliacaoEficacia')==='Sim') {\r\n lpa_table_column_visible('Participants', 'MeetingObjectives', true)\r\n lpa_table_column_visible('Participants', 'ParticipantEvaluation', true)\r\n lpa_table_column_visible('Participants', 'EvaluationOfTraining', true)\r\n lpa_table_column_visible('Participants', 'EvaliatioComments', true)\r\n lpa_table_column_visible('Participants', 'WorkforceApplicability', true)\r\n\r\n }else {\r\n lpa_table_column_visible('Participants', 'MeetingObjectives', false)\r\n lpa_table_column_visible('Participants', 'ParticipantEvaluation', false)\r\n lpa_table_column_visible('Participants', 'EvaluationOfTraining', false)\r\n lpa_table_column_visible('Participants', 'EvaliatioComments', false)\r\n lpa_table_column_visible('Participants', 'WorkforceApplicability', false)\r\n }\r\n \r\n \r\n lpa_table_allow_new('Participants', false);\r\n lpa_table_allow_remove('Participants', false);\r\n lpa_table_column_visible('Participants', 'Link', true)\r\n lpa_table_column_visible('Participants', 'agirstatus', true)\r\n lpa_table_allow_new('Participants', false);\r\n lpa_table_allow_remove('Participants', false);\r\n LPA('Participants').find(\"a.linkCriarNovoWorkflow\").parent().prev('td').show();\r\n }\r\n\r\n lpa_table_column_readonly('Participants', 'ParticipantEvaluation', true);\r\n}\r\n\r\nlpa_table('Participants', function() {\r\n \r\n LPA('Participants').find(\"a.linkCriarNovoWorkflow\").parent().hide();\r\n if(lpa_status() === 'Planeada'){\r\n LPA('Participants').find(\"a.linkCriarNovoWorkflow\").parent().prev('td').hide();\r\n }\r\n \r\n LPA('Participants').find('[data-lpacolumntype=\"Workflow\"]').hide();\r\n LPA('Participants').find(\"[data-lpacelltype='Workflow']\").hide();\r\n $('[data-lpacelltype=\"Attachments\"]').html('Anexos');\r\n $('[data-lpacelltype=\"Tasks\"]').html('Ações');\r\n lpa_val('NumeroParticipants', lpa_table_rows_number('Participants'));\r\n lpa_table_rows('Participants', function(row) {\r\n if (row.columnchildrenstatus === '') {\r\n $('#LPACTRL_Participants tr[data-lpa-rowid=' + row.id + ']').find('a.create_wkf').hide()\r\n } else {\r\n $('#LPACTRL_Participants tr[data-lpa-rowid=' + row.id + ']').find('a.create_wkf').show()\r\n }\r\n lpa_style(row.Participant, 'background-color', '#ccf2ff');\r\n lpa_style(row.EvaluationOfTraining, 'font-weight', 'bold');\r\n lpa_style(row.EvaluationOfTraining, 'font-size', '18px');\r\n lpa_change(row.Participant, function() {\r\n if (lpa_val(row.Participant) !== '') {\r\n lpa_val(row.ID, lpa_user(lpa_val(row.Participant)).identity_number);\r\n lpa_val(row.ParticipantEmail, lpa_user(lpa_val(row.Participant)).email);\r\n } else {\r\n lpa_val(row.ID, '');\r\n lpa_val(row.ParticipantEmail, '');\r\n }\r\n })\r\n lpa_change(row.MeetingObjectives, function() {\r\n Evaluation();\r\n TrainingEvaluationAverage();\r\n });\r\n lpa_change(row.WorkforceApplicability, function() {\r\n Evaluation();\r\n TrainingEvaluationAverage();\r\n });\r\n lpa_change(row.EvaluationOfTraining, function() {\r\n VerificacaoValoresAvaliacao();\r\n TrainingEvaluationAverage();\r\n });\r\n TableWkfNewText(row)\r\n });\r\n //Requireds\r\n tableOptions()\r\n // ColumnsVisibility();\r\n Horas();\r\n Evaluation();\r\n TrainingEvaluationAverage();\r\n //CRIAR WKF FILHO\r\n criacaoFilho() \r\n if(lpa_table_rows_number('Participants') > 0){ \r\n lpa_visible('BtnCreateEvaTrainingL', true);\r\n }else{\r\n lpa_visible('BtnCreateEvaTrainingL', false); \r\n } \r\n});\r\n\r\n\r\nfunction DefaultDataPrevistaAvaliacao() {\r\n if (lpa_value('EndDate') !== '' && lpa_value('EvaluationPlannedDate') === '') {\r\n lpa_value('EvaluationPlannedDate', lpa_date('EndDate').add('3', 'M').format('DD/MM/YYYY'))\r\n }\r\n}\r\n\r\nfunction criacaoFilho() {\r\n /////////CRIAR WKF FILHO\r\n // criar link na coluna criada:\r\n // associar código às links criadas anteriormente se forem create_wkf:\r\n $('.create_wkf').unbind('click');\r\n $('.create_wkf').on('click', function() {\r\n lpa_table_save('Participants');\r\n var row = $(this).closest('tr').attr('data-lpa-rowid');\r\n var intervenient = $(this).closest('tr').find('select[data-lpatablecolumn=\"Participant\"]').val();\r\n var intervenient_name = lpa_text($(this).closest('tr').find('select[data-lpatablecolumn=\"Participant\"]').attr('data-lpacellid'));\r\n var wkf = lpa_wkf_new('Avaliação da Formação', lpa_number(intervenient), {\r\n title: lpa_val('Training'),\r\n fields: {\r\n Training: lpa_val('Training'),\r\n StartDate: lpa_val('StartDate'),\r\n Participant: intervenient_name\r\n }\r\n });\r\n lpa_sql('INSERT INTO AssociacaoTabelaEstrutura (AssociacaoTabela, AssociacaoLinhaID, AssociacaoEstruturaID) VALUES (@tabela, @linha, @wkf)', {\r\n tabela: 'Participants',\r\n linha: row,\r\n wkf: wkf\r\n });\r\n lpa_table_load('Participants')\r\n LPA_OPEN('workflow.aspx?id=' + wkf);\r\n });\r\n}\r\n\r\nfunction TableWkfNewText(row) {\r\n console.log('TESTES')\r\n var td = lpa(row.Link).closest('td');\r\n var tr = td.closest('tr');\r\n if (tr.find('.linkCriarNovoWorkflow').hasClass('links_open'))\r\n td.html('Abrir AVAL');\r\n else{\r\n td.html('Criar AVAL');\r\n }\r\n}\r\n\r\n/* LOAD */\r\nTabSelect();\r\n\r\n\r\n\r\n/* SUBMIT */\r\nlpa_submit(function() {\r\n if (lpa_submit_validate())\r\n TestMandatoryFields();\r\n if (lpa_submit_validate())\r\n WorkflowStop();\r\n if (lpa_submit_validate())\r\n ConditionalSteps();\r\n if (lpa_submit_validate())\r\n SendEvaluation();\r\n if (lpa_submit_validate())\r\n VerificacaoValoresAvaliacao();\r\n if (lpa_submit_validate())\r\n PendingTasks();\r\n\r\n if (lpa_submit_validate())\r\n lpa_wkf_next();\r\n else\r\n lpa_wkf_stop(false);\r\n});\r\n\r\n/* STATUS CHANGE */\r\nlpa_status_change(function() {\r\n ConditionalVisibility();\r\n tableOptions()\r\n gerirTabela();\r\n TabSelect();\r\n});\r\n\r\n// lpa_save(function() {\r\n// CreateLink()\r\n// })\r\n\r\nlpa_save(function(){\r\n var sql = ''\r\n if(lpa_val('CreateType') == 'Modo Catálogo de Formação'){\r\n if(lpa_origin() == 0){\r\n gerirTabela(true)\r\n }else{\r\n gerirTabela(false)\r\n }\r\n }\r\n})\r\n\r\n\r\n\r\n/* FIELDS */\r\nlpa_field_event('EvaluationOfTraining', function() {\r\n ConditionalVisibility();\r\n});\r\nlpa_field_event('EfficacyAssessmentMethodology', function() {\r\n Evaluation();\r\n TrainingEvaluationAverage();\r\n});\r\nlpa_field_event('CertificateL', function() {\r\n LinkToReport();\r\n});\r\n\r\nlpa_field_event('Report2L', function() {\r\n LinkToReport2();\r\n});\r\n\r\nlpa_field_event('Report3L', function() {\r\n LinkToReport3();\r\n});\r\n\r\n\r\nlpa_field_event('AnexoL', function() {\r\n OpenAttachments();\r\n});\r\nlpa_field_event('CancelarL', function() {\r\n CancelFormacao();\r\n});\r\nlpa_field_event('CancelarFormacao', function() {\r\n ConditionalVisibility();\r\n});\r\nlpa_change('CreateType', function() {\r\n checkCriacao(false);\r\n})\r\nlpa_click('PrintCertificatesL', function() {\r\n LinkToReport();\r\n});\r\nlpa_field_event('PlanoDeFormacao', function() {\r\n CarregarFormacoes();\r\n checkFormacao();\r\n});\r\nlpa_field_event('RequerAvaliacaoEficacia', function() {\r\n ConditionalVisibility();\r\n tableOptions();\r\n});\r\nlpa_change('EndDate', function() {\r\n DefaultDataPrevistaAvaliacao();\r\n})\r\nlpa_change('TrainingCombo', function() {\r\n checkFormacao(true)\r\n})\r\nlpa_click('BtnCreateEvaTrainingL', function(){\r\n CreateEvaTraining();\r\n});\r\n\r\nlpa_click('InserirUtilizadoresNaoAgirL', function(){\r\n // lpa_table_save('Participants');\r\n InserirUtilizadorNaoAgir();\r\n});\r\n\r\n\r\n\r\n/* FUNCTIONS */\r\n\r\nfunction InserirUtilizadorNaoAgir(){\r\n lpa_modal_builder(\"Registo de Participante\", \"Por favor, preencha os seguintes dados:\", {\r\n fields: [{\r\n id: \"nomeParticipante\",\r\n label: \"Nome de Participante\",\r\n datatype: \"text\",\r\n required: true,\r\n colWidth: 12\r\n },\r\n {\r\n id: \"nIdentificacao\",\r\n label: \"Nº de Identificação\",\r\n datatype: \"text\",\r\n required: true,\r\n colWidth: 6\r\n },\r\n {\r\n id: \"emailParticipante\",\r\n label: \"Email\",\r\n datatype: \"text\",\r\n required: true,\r\n colWidth: 6\r\n },\r\n {\r\n id: \"horasParticipacao\",\r\n label: \"Horas\",\r\n datatype: \"numeric\",\r\n required: true,\r\n defaultValue: lpa_value('Duration'),\r\n dataOptions: {\r\n decimals: 1,\r\n symbol: \"⏱\"\r\n },\r\n colWidth: 6\r\n }\r\n\r\n ],\r\n buttons: [{\r\n id: \"cancelarBtn\",\r\n label: \"Cancelar\",\r\n css: {\r\n \"background-color\": \"#dc3545\",\r\n \"color\": \"#fff\"\r\n },\r\n function: function() { lpa_modal_hide() }\r\n },\r\n {\r\n id: \"confirmarBtn\",\r\n label: \"Confirmar\",\r\n css: {\r\n \"background-color\": \"#28a745\",\r\n \"color\": \"#fff\"\r\n },\r\n function: function() { AdicionarParticipante() }\r\n }\r\n ],\r\n modalOptions: {\r\n id: \"participanteModal\",\r\n allowHide: \"true\",\r\n showX: \"true\"\r\n }\r\n});\r\n}\r\n\r\nfunction AdicionarParticipante() {\r\n\r\n let Participant = $(\"#nomeParticipante\").val();\r\n let ID = $(\"#nIdentificacao\").val();\r\n let ParticipantEmail = $(\"#emailParticipante\").val();\r\n let Hours = $(\"#horasParticipacao\").val();\r\n console.log(Hours)\r\n if (Participant !== '' && ID !== '' && ParticipantEmail !== '' && Hours !== '') {\r\n lpa_sql(\"Insert into Participants (EstruturaID, Participant, [ID], ParticipantEmail, Hours) values (@EstruturaID, @Participant, @ID, @ParticipantEmail, @Hours)\", {\r\n EstruturaID: lpa_wkf_id(),\r\n Participant: Participant,\r\n ID: ID,\r\n ParticipantEmail: ParticipantEmail,\r\n Hours: Hours\r\n })\r\n lpa_table_load('Participants')\r\n lpa_modal_hide();\r\n lpa_message('Utilizador Adicionado com sucesso', {\r\n type: 'success'\r\n })\r\n } else {\r\n lpa_message('Por favor preencha todos os campos para adicionar participante', {\r\n type: 'warning'\r\n })\r\n }\r\n\r\n}\r\n\r\nfunction generateUrlCode() {\r\n var code = '';\r\n var characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';\r\n var charactersLength = characters.length;\r\n for (var i = 0; i < 54; i++) {\r\n code += characters.charAt(Math.floor(Math.random() * charactersLength));\r\n }\r\n return code;\r\n}\r\n\r\n//CarregarFormacoes\r\nfunction CarregarFormacoes() {\r\n if (lpa_value('PlanoDeFormacao') !== '') {\r\n var tiposFormacao = lpa_sql(\"select TrainingPlanID, Training From TrainingPlan where EstruturaID = @EstruturaID ORDER BY Training\", {\r\n EstruturaID: lpa_val('PlanoDeFormacao')\r\n })\r\n lpa_json_content('TrainingCombo', tiposFormacao, 'Training', 'TrainingPlanID')\r\n }\r\n}\r\n\r\n// CreateLink\r\nfunction CreateLink() {\r\n if (lpa_value('PlanoDeFormacao') !== '' && lpa_value('IDAGIR') !== '') {\r\n var count = lpa_sql(\"select COUNT(LinkID) as count FROM EstruturaWebLink where LinkEstruturaID = @EstruturaID and LinkLinkEstruturaID = @IDAGIR\", {\r\n EstruturaID: lpa_wkf_id(),\r\n IDAGIR: lpa_value('IDAGIR')\r\n }, false)\r\n if (lpa_number(count.count) === 0) {\r\n lpa_link(lpa_value('IDAGIR'))\r\n }\r\n }\r\n}\r\n\r\n// LinkToReport\r\nfunction LinkToReport() {\r\n LPA_REPORT_OPEN('Certificado de Formação');\r\n}\r\n\r\n// LPA_REPORT_OPEN\r\nfunction LPA_REPORT_OPEN(reportName) {\r\n var site = LPA_SITE();\r\n var relatorio = lpa_sql(\"SELECT ReportID FROM Report WHERE ReportName = @reportName\", {\r\n reportName: reportName\r\n });\r\n lpa_open(site + '/report_viewer.aspx?id=' + relatorio.ReportID + '&ID AGIR=' + LPA_EST_ID());\r\n\r\n}\r\n\r\n// Function: ConditionalVisibility\r\nfunction ConditionalVisibility() {\r\n if (lpa_value('EfficacyAssessmentMethodology') == 'Standard' || lpa_value('EfficacyAssessmentMethodology') == 'Outro') {\r\n lpa_visible(\"EvaluationOfTrainingL\", true);\r\n lpa_visible(\"TitleL\", true);\r\n } else {\r\n lpa_visible(\"EvaluationOfTrainingL\", false);\r\n lpa_visible(\"TitleL\", false);\r\n }\r\n if (lpa_status() != 'Cancelado') {\r\n lpa_visible(\"CancelarL\", true);\r\n } else {\r\n lpa_visible(\"CancelarL\", false);\r\n }\r\n\r\n\r\n if (lpa_status() == 'Planeada') {\r\n lpa_visible(\"InserirUtilizadoresNaoAgirL\", true);\r\n } else {\r\n lpa_visible(\"InserirUtilizadoresNaoAgirL\", false);\r\n }\r\n\r\n\r\n\r\n if (lpa_value('CancelarFormacao') == true) {\r\n lpa_visible(\"CancelarFormacaoJustificacao\", true);\r\n lpa_visible(\"CancelarFormacaoJustificacaoL\", true);\r\n } else {\r\n lpa_visible(\"CancelarFormacaoJustificacao\", false);\r\n lpa_visible(\"CancelarFormacaoJustificacaoL\", false);\r\n }\r\n\r\n if (lpa_value('configPlan') == 'A - Modo Normal') {\r\n lpa_visible(\"CreateType\", true);\r\n lpa_visible(\"CreateTypeL\", true);\r\n } else {\r\n lpa_visible(\"CreateType\", false);\r\n lpa_visible(\"CreateTypeL\", false);\r\n }\r\n\r\n if (lpa_value('RequerAvaliacaoEficacia') == 'Sim') {\r\n lpa_visible(\"Avaliador\", true);\r\n lpa_visible(\"AvaliadorL\", true);\r\n lpa_visible(\"EvaluationPlannedDate\", true);\r\n lpa_visible(\"EvaluationPlannedDateL\", true);\r\n } else {\r\n lpa_visible(\"Avaliador\", false);\r\n lpa_visible(\"AvaliadorL\", false);\r\n lpa_visible(\"EvaluationPlannedDate\", false);\r\n lpa_visible(\"EvaluationPlannedDateL\", false);\r\n }\r\n\r\n\r\n\r\n}\r\n\r\n// Function: TrainingEvaluationAverage\r\nfunction TrainingEvaluationAverage() {\r\n var methodology = lpa_value('EfficacyAssessmentMethodology');\r\n\r\n if (methodology === 'Standard' || methodology === 'Outro') {\r\n LPA_NUMERIC('EvaluationOfTraining', {\r\n mDec: '2'\r\n });\r\n var total = 0;\r\n var sum = 0;\r\n\r\n lpa_table_rows('Participants', function(row) {\r\n\r\n var evaluation = LPA_NUMBER(row.EvaluationOfTraining);\r\n var participant = lpa_value(row.Participant);\r\n\r\n if (participant !== '') {\r\n total++;\r\n if (evaluation !== '' && evaluation !== 0) {\r\n sum += evaluation;\r\n }\r\n }\r\n });\r\n\r\n\r\n\r\n var average = (sum / total).toFixed(2);\r\n var value = lpa_value('EvaluationOfTraining', average);\r\n // LPA_GAGE('EvaluationOfTrainingL', '', value, { 'min': 0, 'max': 5 });\r\n\r\n\r\n LPA_GAGE('EvaluationOfTrainingL', '', value, {\r\n 'decimals': true,\r\n 'min': 0.0,\r\n 'max': 5.0,\r\n 'pointer': true,\r\n 'counter': true,\r\n levelColors: [\"#ff0000\", \"#ffff00\", \"#00ff00\"],\r\n pointerOptions: {\r\n toplength: -15,\r\n bottomlength: 10,\r\n bottomwidth: 12,\r\n color: '#8e8e93',\r\n stroke: '#ffffff',\r\n stroke_width: 3,\r\n stroke_linecap: 'round'\r\n },\r\n });\r\n\r\n } else if (methodology === 'Não aplicável') {\r\n //LPA_TEXT('EvaluationOfTraining', 'Não aplicável');\r\n }\r\n}\r\n\r\n\r\n// Function: TestMandatoryFields\r\nfunction TestMandatoryFields() {\r\n if (lpa_status() == 'Planeada') {\r\n lpa_required(\"Training\", true);\r\n lpa_required(\"Duration\", true);\r\n lpa_required(\"StartDate\", true);\r\n lpa_required(\"EndDate\", true);\r\n lpa_required(\"Summary\", true);\r\n lpa_required(\"IncludedInTrainingPlan\", true);\r\n lpa_required(\"AreaFormacao\", true);\r\n lpa_required(\"TipoFormacao\", true);\r\n lpa_required(\"TrainingManager\", true);\r\n lpa_required(\"RequerAvaliacaoEficacia\", true);\r\n lpa_required(\"CertificateIssuedBy\", true);\r\n lpa_required(\"CertificatesIssuedReceived\", true);\r\n lpa_required(\"Avaliador\", true);\r\n lpa_required(\"EvaluationPlannedDate\", true);\r\n }\r\n if (lpa_status() == 'Avaliação') {\r\n lpa_required(\"EfficacyAssessmentMethodology\", true);\r\n lpa_table(\"Participants\", function() {\r\n lpa_table_column_required(\"Participants\", \"Participant\", true);\r\n });\r\n var flag = false\r\n var flagVazio = false\r\n lpa_table_rows('Participants', function(row) {\r\n if (lpa_val(row.EvaluationOfTraining) < 2.5 && lpa_val(row.EvaliatioComments) == '' && lpa_val(row.EvaluationOfTraining) !== '') {\r\n lpa_wkf_stop()\r\n flag = true\r\n }\r\n if (lpa_val(row.EvaluationOfTraining) == '') {\r\n lpa_wkf_stop()\r\n flagVazio = true\r\n }\r\n })\r\n if (flag)\r\n lpa_message('Existem avaliações inferiores a 2.5. Por favor preencha os comentários e acções a executar em caso de não eficácia.', {\r\n type: 'error'\r\n })\r\n if (flagVazio)\r\n lpa_message('Existem participantes sem avaliação. Por favor, proceda à avaliação antes de submeter.', {\r\n type: 'error'\r\n })\r\n if (lpa_value('NumeroParticipants') == 0) {\r\n lpa_wkf_stop();\r\n lpa_message(\"Verifique se preencheu corretamenta a tabela de participantes\", {\r\n title: \"Dados dos participantes em falta\",\r\n type: \"info\"\r\n });\r\n }\r\n }\r\n}\r\n\r\n// Function: SendEvaluation\r\nfunction SendEvaluation() {\r\n if (lpa_status() === 'Avaliação' && lpa_value('IncludedInTrainingPlan') === 'Sim') {\r\n var evaluation = lpa_text('EvaluationOfTraining');\r\n if(lpa_origin() !== 0){\r\n lpa_sql(\"UPDATE TrainingPlan SET EvaluationOfTraining=@evaluation WHERE wkfFormacao=@wkfFormacao\", {\r\n wkfFormacao: lpa_wkf_id(),\r\n evaluation: evaluation\r\n });\r\n }\r\n }\r\n}\r\n\r\n// Function: Evaluation\r\nfunction Evaluation() {\r\n var methodology = LPA_VAL('EfficacyAssessmentMethodology');\r\n\r\n lpa_table_rows('Participants', function(row) {\r\n\r\n var objectives = LPA_NUMBER(row.MeetingObjectives);\r\n var applicability = LPA_NUMBER(row.WorkforceApplicability);\r\n\r\n if (methodology === 'Standard') {\r\n var evaluation = ((objectives + applicability) / 2);\r\n lpa_val(row.EvaluationOfTraining, evaluation);\r\n lpa_table_column_readonly('Participants', 'EvaluationOfTraining', true);\r\n lpa_table_column_readonly('Participants', 'MeetingObjectives', false);\r\n lpa_table_column_readonly('Participants', 'WorkforceApplicability', false);\r\n\r\n } else if (methodology === 'Outro') {\r\n lpa_table_column_readonly('Participants', 'EvaluationOfTraining', false);\r\n lpa_table_column_readonly('Participants', 'MeetingObjectives', true);\r\n lpa_table_column_readonly('Participants', 'WorkforceApplicability', true);\r\n } \r\n\r\n });\r\n}\r\n\r\n// Function: VerificacaoValoresAvaliacao\r\nfunction VerificacaoValoresAvaliacao() {\r\n if (lpa_status() === 'Avaliação' && lpa_val('EfficacyAssessmentMethodology') === 'Outro') {\r\n\r\n lpa_table_rows('Participants', function(row) {\r\n\r\n var avaliacao = lpa_value(row.EvaluationOfTraining);\r\n\r\n if (lpa_number(avaliacao) > 5 || lpa_number(avaliacao) < 0) {\r\n lpa_message('O valor introduzido não é permitido, introduza um valor de 1 a 5', {\r\n type: 'info',\r\n title: 'Valor incorreto'\r\n });\r\n lpa_val(row.EvaluationOfTraining, '')\r\n lpa_wkf_stop();\r\n\r\n }\r\n });\r\n }\r\n}\r\n\r\n// Function: Horas\r\nfunction Horas() {\r\n var horas = lpa_value('Duration');\r\n\r\n lpa_table_rows('Participants', function(row) {\r\n\r\n if (lpa_val(row.Hours) === '') {\r\n lpa_val(row.Hours, horas);\r\n }\r\n });\r\n}\r\n\r\n// Function: PendingTasks\r\nfunction PendingTasks() {\r\n if (lpa_status() == 'Avaliação' && lpa_wkf_tasks_pending() > 0) {\r\n lpa_message(\"Este registo possui \" + lpa_wkf_tasks_pending() + \" ações pendentes. Não pode fechar o processo sem assegurar que as ações são Fechadas.\", {\r\n title: \"Ações Pendentes!\",\r\n type: \"info\"\r\n });\r\n lpa_wkf_stop();\r\n }\r\n}\r\n\r\n// Function: LinkToReport\r\nfunction LinkToReport() {\r\n var site = LPA_SITE();\r\n var relatorio = lpa_sql(\"SELECT ReportID FROM Report WHERE ReportName = 'Certificado de Formação'\");\r\n lpa_open(site + '/report_viewer.aspx?id=' + relatorio.ReportID + '&ID AGIR=' + LPA_EST_CODE());\r\n}\r\n\r\n\r\nfunction LinkToReport2() {\r\n var site = LPA_SITE();\r\n var relatorio = lpa_sql(\"SELECT ReportID FROM Report WHERE ReportName = 'Registo de formação e presenças'\");\r\n lpa_open(site + '/report_viewer.aspx?id=' + relatorio.ReportID + '&Código=' + lpa_wkf_id());\r\n}\r\n\r\nfunction LinkToReport3() {\r\n var site = LPA_SITE();\r\n var relatorio = lpa_sql(\"SELECT ReportID FROM Report WHERE ReportName = 'Registo de presenças'\");\r\n lpa_open(site + '/report_viewer.aspx?id=' + relatorio.ReportID + '&Código=' + lpa_wkf_id());\r\n}\r\n\r\n\r\n\r\n\r\n\r\n// Function: OpenAttachments\r\nfunction OpenAttachments() {\r\n lpa_show_attachments()\r\n}\r\n\r\n\r\n// Function: CancelFormacao\r\nfunction CancelFormacao() {\r\n if (lpa_value('CancelarFormacaoJustificacao') != '') {\r\n lpa_modal_yesno('Tem a certeza que deseja cancelar esta formação?', {\r\n yes: function() {\r\n LPA_WORKFLOW_MOVE('Cancelado', 'Cancelamento - Manual');\r\n lpa_modal_yesno_hide();\r\n\r\n },\r\n no: function() {\r\n lpa_modal_yesno_hide();\r\n }\r\n });\r\n } else {\r\n lpa_message(\"Por favor justifique a razão do cancelamento.\", {\r\n title: \"Justificação em falta\",\r\n type: \"error\"\r\n });\r\n }\r\n}\r\n\r\n\r\n// Function: ConditionalSteps\r\nfunction ConditionalSteps() {\r\n if (lpa_status() == 'Planeada' && lpa_value('RequerAvaliacaoEficacia') == 'Não') {\r\n lpa_status_next(\"Fechado\");\r\n lpa_message(\"Esta formação não requer avaliação da eficácia pelo que será Fechada de imediato. \", {\r\n title: \"Formação Fechada\",\r\n type: \"info\"\r\n });\r\n }\r\n\r\n if (lpa_status() == 'Planeada' && lpa_value('RequerAvaliacaoEficacia') == 'Sim') {\r\n lpa_wkf_taskowner_next_filter(\"\" + lpa_value('Avaliador') + \"\");\r\n lpa_wkf_taskowner_next(\"\" + lpa_value('Avaliador') + \"\");\r\n lpa_wkf_date_next(\"\" + lpa_value('EvaluationPlannedDate') + \"\");\r\n lpa_message(\"A avaliação de eficácia deve ser efetuada pelo \" + lpa_value('Avaliador') + \" até ao dia \" + lpa_value('EvaluationPlannedDate') + \".\", {\r\n title: \"Formação aguarda avaliação\",\r\n type: \"info\"\r\n });\r\n }\r\n\r\n}\r\n\r\n// Function: WorkflowStop\r\nfunction WorkflowStop() {\r\n if (lpa_status() == 'Planeada' && lpa_value('NumeroParticipants') == 0) {\r\n lpa_wkf_stop();\r\n lpa_message(\"Certifique-se que preencheu a tabela de participantes na formação.\", {\r\n title: \"Dados em falta\",\r\n type: \"info\"\r\n });\r\n }\r\n}\r\n\r\n// Function: TabSelect\r\nfunction TabSelect() {\r\n\tif (lpa_status()=='Fechado' || lpa_status()=='Cancelado') {\r\n\t\tlpa_tab_select(\"Tab1\");\r\n\t}\r\n}\r\n\r\nfunction CreateEvaTraining() {\r\n if (lpa_table_rows_number('Participants') > 0) {\r\n if (lpa_val('Training') != '') {\r\n lpa_modal_yesno('Confirma que pretende enviar os pedidos de avaliação da formação aos formandos?', {\r\n yes_text: 'Sim',\r\n no_text: 'Não',\r\n yes: function() {\r\n lpa_modal_yesno_hide();\r\n lpa_wkf_save();\r\n lpa_table_rows('Participants', function(row) {\r\n let urlCode = (generateUrlCode() + row.id);\r\n if (row.columnchildrenstatus == '' && lpa_val(row.Participant) != '') {\r\n let newID = 0;\r\n newID = lpa_wkf_new('Avaliação da Formação', lpa_val(row.Participant), {\r\n title: lpa_val('Training'),\r\n fields: {\r\n Training: lpa_val('Training'),\r\n StartDate: lpa_val('StartDate'),\r\n Participant: lpa_value(row.Participant),\r\n URL_CODE: urlCode\r\n }\r\n });\r\n if (newID != 0 && lpa_is_number(newID)) {\r\n var texto = '';\r\n texto += 'Caro colega, ';\r\n texto += 'Por favor proceda à avaliação da seguinte ação de formação: