{ "wkf": { "name": "Auditorias de Avaliação Legal", "category": "Avaliação Legal", "type": "Auditoria", "type_ref": "AUD", "reference": "AUDL-CHECK", "encoding_year": "True", "encoding_sub": "", "email": "True", "equip_type": "", "equip": "False", "WFplan": "False", "title_suggestion": "Agir_Workflow created by Agir_Issuer on Agir_Date", "title_tags": "False", "att_preview": "False", "trs": [ { "name": "Registo e Checklist", "status_start_name": "Registo", "status_start_rgb": "107, 208, 208", "status_end_name": "Follow-Up", "status_end_rgb": "255, 202, 2", "deadline": "3", "TRdelay": "0", "approvals": "1", "TRorder": "1", "tab": "Checklist", "method": "Manual", "code": "", "equip_start": "False", "equip_end": "False", "alts": [] }, { "name": "Follow-up e Fecho", "status_start_name": "Follow-Up", "status_start_rgb": "255, 202, 2", "status_end_name": "Fechado", "status_end_rgb": "162, 227, 14", "deadline": "3", "TRdelay": "0", "approvals": "1", "TRorder": "2", "tab": "Follow-up e Fecho", "method": "Manual", "code": "", "equip_start": "False", "equip_end": "False", "alts": [] } ] }, "form": { "name": "Audits 13-06-2016 2 2 2 2 2 3", "html": "
Conclusões e Observações
Clique para gerar nova Auditoria (apenas em ambiente AGIR)Deseja gerar nova auditoria?Número de tarefas concluídasDataO plano de ação foi concluído?Seguimento porNúmero de tarefas atribuídas
Table ColumnTable Column
Clique para gerar a checklist da auditoria:Clique para abrir o relatórioPara gerar a checklist da avaliação, clique aqui:Score GlobalAplicar resposta a todas as questões%ChartGlobalMorada(s)Data do registoObservaçõesEmpresaData da AuditoriaAuditadosRegistado porAuditor(es)Duração
ÁreaTipo de Auditoria
Checklist
", "css": "", "js": "lpa_plugin('PopulateSitesByUser')\r\nPopulateSitesByUser('Site')\r\n// TEMP:\r\nlpa_table('AuditChecklist', function() {\r\n lpa_table_column_visible('AuditChecklist', 'Titulo', false)\r\n\r\n if (lpa_version > 3) {\r\n lpa_table_allow_sort('AuditChecklist', false)\r\n lpa_table_allow_new('AuditChecklist', false)\r\n lpa_table_allow_remove('AuditChecklist', false)\r\n lpa_table_column_visible('AuditChecklist', 'CodeID', false)\r\n } else {\r\n LPA_TABLE_REMOVEROW_VISIBLE('AuditChecklist', false)\r\n LPA_TABLE_ADDROW_VISIBLE('AuditChecklist', false)\r\n $('.DataTables_sort_wrapper span').removeAttr('onclick')\r\n\r\n\r\n }\r\n\r\n})\r\n\r\n$('#estrutura_accoes').on('hidden.bs.modal', function() {\r\n PopulateTasks();\r\n})\r\nlpa_save(function() {\r\n PopulateTasks();\r\n})\r\n\r\nlpa_table('AuditChecklist', function() {\r\n TableConditionalVisibilityAndFormats();\r\n var countTitle = 0;\r\n\r\n if (lpa_table_rows_number('AuditChecklist') === 0) {\r\n lpa_visible('GlobalIndicator', false);\r\n lpa_visible('GlobalIndicatorL', false);\r\n lpa_visible('Symbol1L', false);\r\n lpa_visible('GlobalAll', false);\r\n lpa_visible('GlobalAllL', false);\r\n lpa_visible('ChartGlobalL', false);\r\n\r\n lpa_value('TableRespostas', 'Não');\r\n\r\n } else {\r\n lpa_visible('GlobalIndicator', true);\r\n lpa_visible('GlobalIndicatorL', true);\r\n lpa_visible('Symbol1L', true);\r\n lpa_visible('GlobalAll', true);\r\n lpa_visible('GlobalAllL', true);\r\n lpa_visible('ChartGlobalL', true);\r\n lpa_value('TableRespostas', 'Sim');\r\n }\r\n\r\n lpa_table_column_readonly('AuditChecklist', 'NumberAudit', true);\r\n lpa_table_column_readonly('AuditChecklist', 'CriteriaAudit', true);\r\n lpa_table_column_readonly('AuditChecklist', 'GroupAudit', true);\r\n lpa_table_column_readonly('AuditChecklist', 'Assunto', true);\r\n lpa_table_column_readonly('AuditChecklist', 'Diploma', true); \r\n lpa_table_column_readonly('AuditChecklist', 'Artigo', true); \r\n\r\n lpa_table_rows('AuditChecklist', function(rows) {\r\n if (lpa_version <= 3) {\r\n if (lpa_val(rows.CodeID) !== '') {\r\n var td = rows.CodeID\r\n rows.CodeID.hide();\r\n td.parent().children('.teste').remove()\r\n td.parent().append('Consultar Diploma')\r\n }\r\n\r\n if (lpa_val(rows.Titulo) === 'Yes') {\r\n countTitle++;\r\n $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).closest('td').attr('colspan', 9);\r\n $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).closest('td').addClass('teste');\r\n $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).closest('td').prev('td').style('display', 'none');\r\n $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).style('text-align', 'center');\r\n $('#LPACTRLCELL_AuditChecklist_Critical_' + rows.id).closest('td').next('td').style('display', 'none');\r\n // $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).closest('td').css(\"backgroundColor\", \"#438cd5\");\r\n $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).closest('td').attr('style', 'background-color: #ccf5ff !important');\r\n console.log('Color Here <---')\r\n $('#LPACTRLCELL_AuditChecklist_Critical_' + rows.id).closest('td').style('display', 'none');\r\n $('#LPACTRLCELL_AuditChecklist_weight_' + rows.id).closest('td').next('td').style('display', 'none');\r\n $('#LPACTRLCELL_AuditChecklist_GroupAudit_' + rows.id).closest('tr').find('.linkCriarNovoWorkflow, .linkAbrirTarefas, .linkAbrirAnexos').parent('td').hide();\r\n lpa_val(rows.CriteriaAudit, lpa_val(rows.GroupAudit));\r\n lpa_value('GroupL' + countTitle, lpa_val(rows.GroupAudit));\r\n lpa_value('IndicatorGroupL' + countTitle, lpa_val(rows.GroupAudit));\r\n lpa_val('Group' + countTitle + 'AllL', lpa_val(rows.GroupAudit));\r\n $('#LPACTRLCELL_AuditChecklist_GroupAudit_' + rows.id).closest('td').next('td').style('display', 'none');\r\n $('#LPACTRLCELL_AuditChecklist_NumberAudit_' + rows.id).closest('td').style('display', 'none');\r\n $('#LPACTRLCELL_AuditChecklist_NumberAudit_' + rows.id).style('text-align', 'center');\r\n $('#LPACTRLCELL_AuditChecklist_RemarksAudit_' + rows.id).closest('td').style('display', 'none');\r\n $('#LPACTRLCELL_AuditChecklist_AnswerAudit_' + rows.id).closest('td').style('display', 'none');\r\n $('#LPACTRLCELL_AuditChecklist_GroupAudit_' + rows.id).closest('td').style('display', 'none');\r\n // $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).closest('td').css(\"backgroundColor\", \"#438cd5\");\r\n $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_188').closest('td').attr('style', 'background-color: #ccf5ff !important');\r\n } else {\r\n // $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).closest('td').css(\"backgroundColor\", \"#438cd5\");\r\n // $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).closest('td').css('backgroundColor', '#82C1FF !important');\r\n if (lpa_val(rows.Titulo) === '' && lpa_val(rows.Critical) === 'Yes') {\r\n $('#LPACTRLCELL_AuditChecklist_CriteriaAudit_' + rows.id).style('color', 'rgb(204, 245, 255)');\r\n }\r\n }\r\n }\r\n\r\n\r\n if (lpa_version <= 3) {\r\n lpa_input(rows.AnswerAudit, function() {\r\n TableConditionalVisibilityAndFormats();\r\n })\r\n }\r\n\r\n })\r\n\r\n if (lpa_version >= 4) {\r\n lpa_table_column_event('AuditChecklist', 'AnswerAudit', function() {\r\n console.log('event')\r\n TableConditionalVisibilityAndFormats();\r\n })\r\n }\r\n\r\n // LPA_TABLE_REMOVEROW_VISIBLE('AuditChecklist', false)\r\n // LPA_TABLE_ADDROW_VISIBLE('AuditChecklist', false)\r\n TableConditionalVisibilityAndFormats();\r\n // $('.DataTables_sort_wrapper span').removeAttr('onclick')\r\n // lpa_val('.ALL','');\r\n // lpa_value('.ALL','');\r\n\r\n if (lpa_version > 3) {\r\n // lpa_visible('GlobalIndicator', false);\r\n // lpa_visible('GlobalIndicatorL', false);\r\n }\r\n\r\n\r\n Gage();\r\n\r\n})\r\n\r\nif (lpa_val('TypeOfAssessment') !== '') {\r\n lpa_val('NewAudit', 'Não');\r\n}\r\n\r\n\r\n/* ----- LPA WIZARD ----- */\r\n/* WARNING: DO NOT MAKE ANY CHANGES BELOW THIS LINE, AS THEY WILL BE LOST */\r\n\r\n/* LOAD */\r\nConditionalFormats();\r\nPopulateTasks();\r\nTableConditionalVisibilityAndFormats();\r\nGage();\r\nEvaluateRows();\r\nDefaultValues();\r\nTabSelect();\r\n\r\n/* SUBMIT */\r\nlpa_submit(function () {\r\n\tif (lpa_submit_validate())\r\n\t\tMandatoryFields();\r\n\tif (lpa_submit_validate())\r\n\t\tPendingTasks();\r\n\tif (lpa_submit_validate())\r\n\t\tConditionalSteps();\r\n\r\n\tif (lpa_submit_validate())\r\n\t\tlpa_wkf_next();\r\n\telse\r\n\t\tlpa_wkf_stop(false);\r\n});\r\n\r\n/* STATUS CHANGE */\r\nlpa_status_change(function () {\r\n\tPopulateTasks();\r\n\tFillRequisitoLegal();\r\n});\r\n\r\n/* FIELDS */\r\nlpa_field_event('TableIconL', function() {\r\n\tTableCreator();\r\n});\r\nlpa_field_event('EvaluationEffectiveness', function() {\r\n\tConditionalFormats();\r\n});\r\nlpa_field_event('NewRAL2', function() {\r\n\tClone();\r\n\tTableConditionalVisibilityAndFormats();\r\n});\r\nlpa_field_event('LinkToReportL', function() {\r\n\tLinkToReport();\r\n});\r\nlpa_field_event('NewRA', function() {\r\n\tTableConditionalVisibilityAndFormats();\r\n});\r\nlpa_field_event('GlobalAll', function() {\r\n\tRespostaEmLote();\r\n});\r\n\r\n/* FUNCTIONS */\r\n\r\n// Function: TableCreator\r\nfunction TableCreator() {\r\n\tvar type = lpa_value('TypeOfAssessment');\r\nvar site = lpa_value('Site');\r\nif (type === '') {\r\n\tlpa_message('Por favor, selecione o tipo de avaliação!', {\r\n type: 'warning'\r\n })\r\n} else {\r\n\tvar new_audit = (lpa_table_rows_number('AuditChecklist') === 0)\r\n\t\r\n\tlpa_modal_yesno('Deseja ' + (new_audit ? 'criar um' : 'alterar a auditoria atual para') + ' tipo de auditoria - ' + type + '?' + (!new_audit ? ' Os dados anteriores serão eliminados.' : '') + ' Pode demorar alguns segundos!',\r\n\t{\r\n\t\tyes_text: 'Sim',\r\n\t\tno_text: 'Não',\r\n\t\tyes: function() {\r\n\t\t\tif (!new_audit) {\r\n\t\t\t\tlpa_sql('DELETE LegalChecklist WHERE EstruturaID = @id', {\r\n id: lpa_wkf_id()\r\n })\r\n\t\t\t}\r\n\t\t\t\r\n// \t\t\tlpa_sql(\"INSERT INTO AuditChecklist (EstruturaID, NumberAudit, CriteriaAudit, GroupAudit, RemarksAudit, Titulo, Critical) SELECT @id, Number, Criteria, Grupo, Remarks, Title, Critical FROM ExtChecklistMaster WHERE Active = 'Yes' AND AuditType = @type\", {\r\n //lpa_sql(\"Insert Into AuditChecklist (EstruturaID, NumberAudit, Assunto, Diploma, Artigo, CriteriaAudit, AuditType, [weight], [Required]) Select @id, NumeroRequisito, Assunto, Diploma, Artigo, Requisito, @type, 1, 'Yes'] From WKF_RequisitosLegais inner join AvaliacaoLegalRequisitosBase On AvaliacaoLegalRequisitosBase.EstruturaID = [WKF ID] Where Estado <> 'Revogado' And AvaliacaoRegular = 'Sim' And (Select Count(*) From LegislacaoEmpresas Where Empresa = @site And LegislacaoEmpresas.EstruturaID = AvaliacaoLegalRequisitosBase.EstruturaID)>0 And IsNull(Requisito,'') <>'' Order By Assunto ASC, NumeroRequisito ASC\", { \r\n lpa_sql(\"Insert Into LegalChecklist (EstruturaID, NumberAudit, Assunto, Diploma, Artigo, CriteriaAudit, AuditType, [weight], [Required], CodeID) Select @id, NumeroRequisito, Assunto, Diploma, Artigo, Requisito, @type, 1, 'Yes', [WKF ID] From WKF_RequisitosLegais inner join AvaliacaoLegalRequisitosBase On AvaliacaoLegalRequisitosBase.EstruturaID = [WKF ID] Where Estado <> 'Revogado' And AvaliacaoRegular = 'Sim' And (Select Count(*) From LegislacaoEmpresas Where Empresa = @site And LegislacaoEmpresas.EstruturaID = AvaliacaoLegalRequisitosBase.EstruturaID)>0 And IsNull(Requisito,'') <>'' Order By Assunto ASC, Diploma ASC, NumeroRequisito ASC\", { \r\n id: lpa_wkf_id(),\r\n type: type,\r\n site:site\r\n })\r\n\t\t\t\r\n\t\t\tif (lpa_version>3) {\r\n\t\t\t lpa_table_load('AuditChecklist')\r\n\t\t\t}\r\n\t\t\telse{\r\n\t\t\t lpa_table_load('AuditChecklist')\r\n\t\t\t}\r\n\t\t\t\r\n\t\t\tlpa_modal_yesno_hide()\r\n\t\t},\r\n\t\tno: function () {\r\n\t\t\tlpa_modal_yesno_hide()\r\n\t\t}\r\n\t})\r\n\t\r\n\tGage();\r\n}\r\n}\r\n\r\n// Function: MandatoryFields\r\nfunction MandatoryFields() {\r\n\tif (lpa_status()=='Registo') {\r\n\t\tlpa_required(\"TypeOfAssessment\", true);\r\n\t\tlpa_required(\"AssessmentDate\", true);\r\n\t\tlpa_required(\"Participants\", true);\r\n\t\tlpa_required(\"TypeOfVisit\", true);\r\n\t\tlpa_required(\"Auditor\", true);\r\n\t\tlpa_required(\"Site\", true);\r\n\t\tlpa_required(\"Areas\", true);\r\n\t\t var flagObservacoes = false\r\n // var flagConstatacoes = false\r\n lpa_table_rows('AuditChecklist', function(row) {\r\n var status = ''\r\n if (lpa_value(row.AnswerAudit) == 'OM' || lpa_value(row.AnswerAudit) == 'Não Conforme') {\r\n if (lpa_val(row.RemarksAudit) === '') {\r\n flagObservacoes = true;\r\n }\r\n\r\n }\r\n })\r\n if (flagObservacoes) {\r\n lpa_wkf_stop();\r\n lpa_message('Deve preencher a descrição de cada uma das OM ou NC no campo de Observações.', {\r\n type: 'warning',\r\n title: 'Observações em falta'\r\n });\r\n }\r\n\t}\r\n\tif (lpa_status()=='Follow-Up') {\r\n\t\tlpa_required(\"EvaluationEffectiveness\", true);\r\n\t\tlpa_required(\"NewRA\", true);\r\n\t}\r\n\t\r\nif (lpa_table_rows_number('AuditChecklist') === 0) {\r\n lpa_wkf_stop();\r\n lpa_message('Por favor crie a Checklist de Avaliação antes de submeter !',{type: 'warning', title: 'Checklist em falta'})\r\n}\r\n\r\n\r\nvar countRows = 0;\r\nlpa_table_rows('AuditChecklist',function(rows){\r\n if(lpa_value(rows.Titulo) !== 'Yes' && lpa_value(rows.Required) === 'Yes' && lpa_value(rows.AnswerAudit) === '' ){\r\n countRows++\r\n }\r\n})\r\nif(countRows > 0){\r\n lpa_wkf_stop();\r\n lpa_message('Todas as avaliações obrigatórias precisam ser preenchidas!',{type: 'warning', title: 'Aviso - Avaliações vazias'})\r\n}\r\n}\r\n\r\n// Function: ConditionalFormats\r\nfunction ConditionalFormats() {\r\n\tif (lpa_value('EvaluationEffectiveness')=='Sim') {\r\n\t\tlpa_style(\"EvaluationEffectiveness\", \"background-color\", '#80ff00');\r\n\t}\r\n\tif (lpa_value('EvaluationEffectiveness')=='Não') {\r\n\t\tlpa_style(\"EvaluationEffectiveness\", \"background-color\", '#ff8080');\r\n\t}\r\n\tif (lpa_value('EvaluationEffectiveness')=='') {\r\n\t\tlpa_style_remove(\"EvaluationEffectiveness\");\r\n\t}\r\n\tif (lpa_number(lpa_value('GlobalIndicator'))>90){\r\n lpa_style(\"GlobalIndicator\", \"background-color\", '#80ff00');\r\n} else if (lpa_number(lpa_value('GlobalIndicator'))>75) {\r\n lpa_style(\"GlobalIndicator\", \"background-color\", '#b3ffcc');\r\n} else if (lpa_number(lpa_value('GlobalIndicator'))>=50) {\r\n lpa_style(\"GlobalIndicator\", \"background-color\", '#ffff1a');\r\n\r\n} else if (lpa_number(lpa_value('GlobalIndicator'))>0) {\r\n lpa_style(\"GlobalIndicator\", \"background-color\", '#ff6666');\r\n\r\n} else if (lpa_number(lpa_value('GlobalIndicator'))==0) {\r\n lpa_style_remove(\"GlobalIndicator\");\r\n\r\n} else if (lpa_number(lpa_value('GlobalIndicator'))=='') {\r\n lpa_style_remove(\"GlobalIndicator\");\r\n}\r\n\r\n\r\n\r\n if (lpa_version>3) {\r\n lpa_style(\"GlobalIndicator\", \"font-weight\", 'bold');\r\n lpa_style(\"GlobalIndicator\", \"font-size\", '25px');\r\n }\r\n \r\n\r\n\r\n}\r\n\r\n// Function: ConditionalSteps\r\nfunction ConditionalSteps() {\r\n\tif (lpa_status()=='Registo' && lpa_value('GlobalIndicator')==0) {\r\n\t\tlpa_message(\" Verifique se pretende enviar uma avaliação com pontuação de zero?\", {title: \"Sua pontuação é zero\", type: \"info\"});\r\n\t}\r\n\tif (lpa_status()=='Follow-Up' && lpa_value('EvaluationEffectiveness')!='Sim') {\r\n\t\tlpa_message(\"Não pode fechar a Auditoria sem concluir o plano de Ações.\", {title: \"Plano de Ação não Concluído\", type: \"info\"});\r\n\t\tlpa_wkf_stop();\r\n\t}\r\n}\r\n\r\n// Function: PopulateTasks\r\nfunction PopulateTasks() {\r\n\tvar TasksTotal = lpa_sql(\"SELECT COUNT(*) AS total FROM EstruturaAccoes AS AccoesMaster WHERE AccoesID=(CASE WHEN AccoesModoAtribuicao='partilhada' THEN (SELECT MAX(AccoesID) FROM EstruturaAccoes AS SubQuery WHERE AccoesMaster.AccoesCodigoPartilha=SubQuery.AccoesCodigoPartilha AND AccoesEstruturaID=@EstruturaID) ELSE AccoesID END) AND AccoesEstruturaID=@EstruturaID\",{EstruturaID: lpa_wkf_id()})\r\nlpa_val('TotalTasks', TasksTotal.total);\r\n\r\n\r\nvar TasksCompleted = lpa_sql(\"SELECT COUNT(*) AS total FROM EstruturaAccoes AS AccoesMaster WHERE AccoesID=(CASE WHEN AccoesModoAtribuicao='partilhada' THEN (SELECT MAX(AccoesID) FROM EstruturaAccoes AS SubQuery WHERE AccoesMaster.AccoesCodigoPartilha=SubQuery.AccoesCodigoPartilha AND AccoesEstruturaID=@EstruturaID) ELSE AccoesID END) AND AccoesEstruturaID=@EstruturaID AND AccoesEstado = 'Terminada'\",{EstruturaID: lpa_wkf_id()})\r\nlpa_val('CompletedTasks', TasksCompleted.total);\r\n\r\n}\r\n\r\n// Function: Clone\r\nfunction Clone() {\r\n\tif (lpa_version <= 3) {\r\n\r\n lpa_modal_yesno('Tem certeza de que deseja copiar este workflow e gerar nova auditoria?', {\r\n yes: function() {\r\n var link = LPA_WORKFLOW_CLONE(lpa_wkf_id(), 'Auditorias - Checklist 2', undefined, undefined, ['Checklist']);\r\n var id = link.split('=');\r\n var meses = 6;\r\n \r\n lpa_wkf_val(id[1], {\r\n AssessmentDate: moment().add(meses, 'M').format('DD/MM/YYYY'),\r\n DateOfRegistration: ''\r\n })\r\n lpa_sql(\"UPDATE EstruturaWorkflowAccoes SET AccoesDataFinal = @data where AccoesID = (SELECT TOP 1 AccoesID FROM EstruturaWorkflowAccoes WHERE AccoesEstruturaID = @ID ORDER BY AccoesID DESC)\", {\r\n data: moment().add(meses, 'M').format('YYYY-MM-DD HH:mm:ss:000'),\r\n ID: id[1]\r\n })\r\n lpa_sql('Delete FROM AuditChecklist where EstruturaID = @id', {\r\n id: id[1]\r\n });\r\n lpa_modal_yesno_hide();\r\n lpa_open(link);\r\n },\r\n no: function() {\r\n lpa_modal_yesno_hide();\r\n }\r\n\r\n\r\n });\r\n\r\n}\r\n}\r\n\r\n// Function: LinkToReport\r\nfunction LinkToReport() {\r\n\t\tvar site = lpa_agir();\r\n\tvar relatorio = lpa_sql(\"SELECT ReportID FROM Report WHERE ReportName = 'Auditoria de Avaliação Legal'\");\r\n\tlpa_open(site + 'report_viewer.aspx?id=' + relatorio.ReportID+ '&AGIR CODE=' + lpa_wkf_code());\r\n}\r\n\r\n// Function: TabSelect\r\nfunction TabSelect() {\r\n\tif (lpa_status()!='Follow-Up') {\r\n\t\tlpa_tab_select ('Checklist');\r\n\t}\r\n}\r\n\r\n// Function: TableConditionalVisibilityAndFormats\r\nfunction TableConditionalVisibilityAndFormats() {\r\n\tlpa_table('AuditChecklist', function () {\r\n\r\n if (lpa_version>3) {\r\n lpa_table_column_visible('AuditChecklist', 'GroupAudit', true) \r\n }\r\n else {\r\n lpa_table_column_visible('AuditChecklist', 'GroupAudit', false) \r\n }\r\n \r\n lpa_table_column_event('AuditChecklist', 'AnswerAudit', function() {\r\n\r\n EvaluateRows()\r\n })\r\n EvaluateRows()\r\n \r\n});\r\n\tif (lpa_value('NewRA')=='Sim') {\r\n\t\tlpa_visible(\"NewRAL2\", true);\r\n\t} else {\r\n\t\tlpa_visible(\"NewRAL2\", false);\r\n\t}\r\n}\r\n\r\n// Function: Gage\r\nfunction Gage() {\r\n\t if (lpa_version<=3) {\r\n \r\n var value = lpa_value('GlobalIndicator');\r\n LPA_GAGE('ChartGlobalL', '', value, { 'decimals':true, 'min': 0.0, 'max': 100.0,'pointer' : true, 'counter': true,levelColors : [ \"#ff0000\", \"#ffff00\", \"#00ff00\" ] ,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}\r\n\r\n// Function: EvaluateRows\r\nfunction EvaluateRows() {\r\n\t var yes = 0;\r\n var no = 0;\r\n var om = 0;\r\n console.log(om)\r\n var groups = {}\r\n var GlobalValue = 0;\r\n \r\n lpa_table_rows('AuditChecklist', function(row) {\r\n groups[lpa_val(row.GroupAudit)] = groups[lpa_val(row.GroupAudit)] || { yes: 0, no: 0, om: 0 } \r\n\r\n lpa_style_remove(row.AnswerAudit)\r\n \r\n if (lpa_value(row.AnswerAudit)==='Conforme') {\r\n yes++\r\n // yes = yes + lpa_number(row.weight);\r\n groups[lpa_val(row.GroupAudit)].yes++\r\n lpa_style(row.AnswerAudit,'background-color','Chartreuse')\r\n } \r\n if (lpa_value(row.AnswerAudit)==='OM') {\r\n om++\r\n // yes = yes + lpa_number(row.weight);\r\n groups[lpa_val(row.GroupAudit)].om++\r\n lpa_style(row.AnswerAudit,'background-color','#ffb347')\r\n } \r\n if (lpa_value(row.AnswerAudit)==='Não Conforme') {\r\n no++\r\n // no = no + lpa_number(row.weight);\r\n groups[lpa_val(row.GroupAudit)].no++\r\n lpa_style(row.AnswerAudit,'background-color','Tomato')\r\n } \r\n if (lpa_value(row.AnswerAudit)==='Não Aplicável') {\r\n lpa_style(row.AnswerAudit,'background-color','Gray')\r\n }\r\n \r\n if (lpa_version >= 4) { \r\n if (lpa_value(row.Titulo) === 'Yes') {\r\n Object.keys(row).forEach(function (col) {\r\n if (col !== 'id') {\r\n lpa_style(row[col], 'background-color', 'LightSkyBlue')\r\n lpa_enabled(row[col], false)\r\n }\r\n })\r\n }\r\n }\r\n })\r\n GlobalValue = (om * 0.5 + yes * 1.00) / (yes + no + om) * 100;\r\n if(isNaN(GlobalValue))\r\n GlobalValue = 0;\r\n lpa_value('GlobalIndicator', lpa_round(GlobalValue,2))\r\n Gage();\r\n ConditionalFormats();\r\n\r\n\r\n\r\n}\r\n\r\n// Function: PendingTasks\r\nfunction PendingTasks() {\r\n\tif (lpa_status()=='Follow-Up' && lpa_wkf_tasks_pending()!=0) {\r\n\t\tlpa_wkf_stop();\r\n\t\tlpa_message(\"Este workflow possui \" + lpa_wkf_tasks_pending() + \" tarefas pendentes! Por favor feche as ações antes de encerrar esta auditoria.\", {title: \"Tarefas Pendentes\", type: \"info\"});\r\n\t}\r\n}\r\n\r\n// Function: RespostaEmLote\r\nfunction RespostaEmLote() {\r\n\t\r\n var Changes = lpa_value('GlobalAll')\r\n \r\n if (Changes !=='') {\r\n \r\n var changeResponse = ('Deseja aplicar a resposta ' + Changes +' a todas as questões? Após esta operação poderá editar individualmente cada resposta. '+'? Pode demorar alguns segundos!');\r\n lpa_modal_yesno(changeResponse,{yes_text:'Sim',no_text:'Não',\r\n yes: function() {\r\n lpa_table_rows('AuditChecklist', function(rows) {\r\n if (lpa_value(rows.Titulo) !== 'Yes') {\r\n lpa_value(rows.AnswerAudit, Changes);\r\n } \r\n })\r\n EvaluateRows();\r\n Gage();\r\n lpa_value('GlobalAll','')\r\n \r\n lpa_modal_yesno_hide();\r\n }, //yes\r\n no: function() {\r\n \r\n lpa_value('GlobalAll','')\r\n lpa_modal_yesno_hide();\r\n } //no\r\n })\r\n \r\n }\r\n\r\n}\r\n\r\n// Function: DefaultValues\r\nfunction DefaultValues() {\r\n\tif (lpa_value('Auditor')=='') {\r\n\t\tlpa_value(\"Auditor\", \"\" + lpa_user_info('name') + \"\");\r\n\t}\r\n}\r\n\r\n// Function: FillRequisitoLegal\r\nfunction FillRequisitoLegal() {\r\n\tif (lpa_status() == 'Follow-Up') {\r\n\t\tvar linhas = lpa_sql(\"select DISTINCT CodeID FROM LegalChecklist WHERE EstruturaID = @EstruturaID\", {EstruturaID: lpa_wkf_id()})\r\nlpa_message('Por favor aguarde até os requisitos estarem sincronizados')\r\nlpa_sql(\"delete from AvaliacaoLegalRequisitos where WKF_Avaliacao_Code = @WKF_Avaliacao_Code \", {WKF_Avaliacao_Code: lpa_wkf_id()})\r\nlpa_each(linhas, function(linha){\r\n console.log(linha)\r\n\t\r\n lpa_sql(\"insert into AvaliacaoLegalRequisitos (EstruturaID, DataAvaliacao, Avaliador, Empresa, WKF_Avaliacao_Code) VALUES (@EstruturaID, @DataAvaliacao, @Avaliador, @Empresa, @WKF_Avaliacao_Code)\", {EstruturaID: linha.CodeID, DataAvaliacao: lpa_date_sql(lpa_value('AssessmentDate')), Avaliador: lpa_value('Auditor'), Empresa: lpa_value('Site'), WKF_Avaliacao_Code: lpa_wkf_id()})\r\n})\r\nlpa_message('Requisitos sincronizados com sucesso', {type:'success'})\r\n\t}\r\n}", "version": 3 }, "tbls": [ { "name": "LegalChecklist", "cols": [ { "name": "NumberAudit", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Nº", "auto_order": "False", "width": "" }, { "name": "Assunto", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Descritor", "auto_order": "False", "width": "150" }, { "name": "Diploma", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Diploma", "auto_order": "False", "width": "200" }, { "name": "Artigo", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Artigo", "auto_order": "False", "width": "" }, { "name": "CriteriaAudit", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Critério", "auto_order": "False", "width": "250" }, { "name": "AuditType", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Tipo de Auditoria", "auto_order": "False", "width": "" }, { "name": "AnswerAudit", "col_type": "[nvarchar](max)", "ctrl": "Combo", "addnew": "False", "items": "Conforme\r\nNão Conforme\r\nNão Aplicável\r\nNão Avaliado\r\nOM", "label": "Avaliação", "auto_order": "True", "width": "100" }, { "name": "RemarksAudit", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Observações", "auto_order": "False", "width": "200" }, { "name": "GroupAudit", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Grupo", "auto_order": "False", "width": "" }, { "name": "Titulo", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Título", "auto_order": "False", "width": "" }, { "name": "Critical", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Crítico", "auto_order": "False", "width": "" }, { "name": "weight", "col_type": "[decimal](19,4)", "ctrl": "Numeric", "addnew": "False", "items": "", "label": "weight", "auto_order": "False", "width": "" }, { "name": "Required", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Required", "auto_order": "False", "width": "" }, { "name": "CodeID", "col_type": "[nvarchar](max)", "ctrl": "Text", "addnew": "False", "items": "", "label": "Diploma", "auto_order": "False", "width": "" } ] } ], "wiz": { "project": "{\"load\":[\"ConditionalFormats\",\"PopulateTasks\",\"TableConditionalVisibilityAndFormats\",\"Gage\",\"EvaluateRows\",\"DefaultValues\",\"TabSelect\"],\"submit\":[\"MandatoryFields\",\"PendingTasks\",\"ConditionalSteps\"],\"statuschange\":[\"PopulateTasks\",\"FillRequisitoLegal\"],\"field\":[{\"field\":\"TableIconL\",\"fn\":[\"TableCreator\"]},{\"field\":\"EvaluationEffectiveness\",\"fn\":[\"ConditionalFormats\"]},{\"field\":\"NewRAL2\",\"fn\":[\"Clone\",\"TableConditionalVisibilityAndFormats\"]},{\"field\":\"LinkToReportL\",\"fn\":[\"LinkToReport\"]},{\"field\":\"NewRA\",\"fn\":[\"TableConditionalVisibilityAndFormats\"]},{\"field\":\"GlobalAll\",\"fn\":[\"RespostaEmLote\"]}]}", "functions": "{\"TableCreator\":{\"name\":\"TableCreator\",\"desc\":\"\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"var type = lpa_value('TypeOfAssessment');\\r\\nvar site = lpa_value('Site');\\r\\nif (type === '') {\\r\\n\\tlpa_message('Por favor, selecione o tipo de avaliação!', {\\r\\n type: 'warning'\\r\\n })\\r\\n} else {\\r\\n\\tvar new_audit = (lpa_table_rows_number('AuditChecklist') === 0)\\r\\n\\t\\r\\n\\tlpa_modal_yesno('Deseja ' + (new_audit ? 'criar um' : 'alterar a auditoria atual para') + ' tipo de auditoria - ' + type + '?' + (!new_audit ? ' Os dados anteriores serão eliminados.' : '') + ' Pode demorar alguns segundos!',\\r\\n\\t{\\r\\n\\t\\tyes_text: 'Sim',\\r\\n\\t\\tno_text: 'Não',\\r\\n\\t\\tyes: function() {\\r\\n\\t\\t\\tif (!new_audit) {\\r\\n\\t\\t\\t\\tlpa_sql('DELETE LegalChecklist WHERE EstruturaID = @id', {\\r\\n id: lpa_wkf_id()\\r\\n })\\r\\n\\t\\t\\t}\\r\\n\\t\\t\\t\\r\\n// \\t\\t\\tlpa_sql(\\\"INSERT INTO AuditChecklist (EstruturaID, NumberAudit, CriteriaAudit, GroupAudit, RemarksAudit, Titulo, Critical) SELECT @id, Number, Criteria, Grupo, Remarks, Title, Critical FROM ExtChecklistMaster WHERE Active = 'Yes' AND AuditType = @type\\\", {\\r\\n //lpa_sql(\\\"Insert Into AuditChecklist (EstruturaID, NumberAudit, Assunto, Diploma, Artigo, CriteriaAudit, AuditType, [weight], [Required]) Select @id, NumeroRequisito, Assunto, Diploma, Artigo, Requisito, @type, 1, 'Yes'] From WKF_RequisitosLegais inner join AvaliacaoLegalRequisitosBase On AvaliacaoLegalRequisitosBase.EstruturaID = [WKF ID] Where Estado <> 'Revogado' And AvaliacaoRegular = 'Sim' And (Select Count(*) From LegislacaoEmpresas Where Empresa = @site And LegislacaoEmpresas.EstruturaID = AvaliacaoLegalRequisitosBase.EstruturaID)>0 And IsNull(Requisito,'') <>'' Order By Assunto ASC, NumeroRequisito ASC\\\", { \\r\\n lpa_sql(\\\"Insert Into LegalChecklist (EstruturaID, NumberAudit, Assunto, Diploma, Artigo, CriteriaAudit, AuditType, [weight], [Required], CodeID) Select @id, NumeroRequisito, Assunto, Diploma, Artigo, Requisito, @type, 1, 'Yes', [WKF ID] From WKF_RequisitosLegais inner join AvaliacaoLegalRequisitosBase On AvaliacaoLegalRequisitosBase.EstruturaID = [WKF ID] Where Estado <> 'Revogado' And AvaliacaoRegular = 'Sim' And (Select Count(*) From LegislacaoEmpresas Where Empresa = @site And LegislacaoEmpresas.EstruturaID = AvaliacaoLegalRequisitosBase.EstruturaID)>0 And IsNull(Requisito,'') <>'' Order By Assunto ASC, Diploma ASC, NumeroRequisito ASC\\\", { \\r\\n id: lpa_wkf_id(),\\r\\n type: type,\\r\\n site:site\\r\\n })\\r\\n\\t\\t\\t\\r\\n\\t\\t\\tif (lpa_version>3) {\\r\\n\\t\\t\\t lpa_table_load('AuditChecklist')\\r\\n\\t\\t\\t}\\r\\n\\t\\t\\telse{\\r\\n\\t\\t\\t lpa_table_load('AuditChecklist')\\r\\n\\t\\t\\t}\\r\\n\\t\\t\\t\\r\\n\\t\\t\\tlpa_modal_yesno_hide()\\r\\n\\t\\t},\\r\\n\\t\\tno: function () {\\r\\n\\t\\t\\tlpa_modal_yesno_hide()\\r\\n\\t\\t}\\r\\n\\t})\\r\\n\\t\\r\\n\\tGage();\\r\\n}\"}}]},\"MandatoryFields\":{\"name\":\"MandatoryFields\",\"desc\":\"\",\"actions\":[{\"action\":\"if\",\"parameters\":{\"condition\":\".Status='Registo'\",\"actions\":[{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"TypeOfAssessment\",\"value\":\"true\"}},{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"AssessmentDate\",\"value\":\"true\"}},{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"Participants\",\"value\":\"true\"}},{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"TypeOfVisit\",\"value\":\"true\"}},{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"Auditor\",\"value\":\"true\"}},{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"Site\",\"value\":\"true\"}},{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"Areas\",\"value\":\"true\"}},{\"action\":\"lpa_script\",\"parameters\":{\"code\":\" var flagObservacoes = false\\r\\n // var flagConstatacoes = false\\r\\n lpa_table_rows('AuditChecklist', function(row) {\\r\\n var status = ''\\r\\n if (lpa_value(row.AnswerAudit) == 'OM' || lpa_value(row.AnswerAudit) == 'Não Conforme') {\\r\\n if (lpa_val(row.RemarksAudit) === '') {\\r\\n flagObservacoes = true;\\r\\n }\\r\\n\\r\\n }\\r\\n })\\r\\n if (flagObservacoes) {\\r\\n lpa_wkf_stop();\\r\\n lpa_message('Deve preencher a descrição de cada uma das OM ou NC no campo de Observações.', {\\r\\n type: 'warning',\\r\\n title: 'Observações em falta'\\r\\n });\\r\\n }\"}}],\"else\":[]}},{\"action\":\"if\",\"parameters\":{\"condition\":\".Status='Follow-Up'\",\"actions\":[{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"EvaluationEffectiveness\",\"value\":\"true\"}},{\"action\":\"lpa_required\",\"parameters\":{\"id\":\"NewRA\",\"value\":\"true\"}}],\"else\":[]}},{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"\\r\\nif (lpa_table_rows_number('AuditChecklist') === 0) {\\r\\n lpa_wkf_stop();\\r\\n lpa_message('Por favor crie a Checklist de Avaliação antes de submeter !',{type: 'warning', title: 'Checklist em falta'})\\r\\n}\\r\\n\\r\\n\\r\\nvar countRows = 0;\\r\\nlpa_table_rows('AuditChecklist',function(rows){\\r\\n if(lpa_value(rows.Titulo) !== 'Yes' && lpa_value(rows.Required) === 'Yes' && lpa_value(rows.AnswerAudit) === '' ){\\r\\n countRows++\\r\\n }\\r\\n})\\r\\nif(countRows > 0){\\r\\n lpa_wkf_stop();\\r\\n lpa_message('Todas as avaliações obrigatórias precisam ser preenchidas!',{type: 'warning', title: 'Aviso - Avaliações vazias'})\\r\\n}\"}}]},\"ConditionalFormats\":{\"name\":\"ConditionalFormats\",\"desc\":\"\",\"actions\":[{\"action\":\"if\",\"parameters\":{\"condition\":\"#EvaluationEffectiveness='Sim'\",\"actions\":[{\"action\":\"lpa_style\",\"parameters\":{\"id\":\"EvaluationEffectiveness\",\"prop\":\"background-color\",\"value\":\"#80ff00\"}}],\"else\":[]}},{\"action\":\"if\",\"parameters\":{\"condition\":\"#EvaluationEffectiveness='Não'\",\"actions\":[{\"action\":\"lpa_style\",\"parameters\":{\"id\":\"EvaluationEffectiveness\",\"prop\":\"background-color\",\"value\":\"#ff8080\"}}],\"else\":[]}},{\"action\":\"if\",\"parameters\":{\"condition\":\"#EvaluationEffectiveness=''\",\"actions\":[{\"action\":\"lpa_style_remove\",\"parameters\":{\"id\":\"EvaluationEffectiveness\"}}],\"else\":[]}},{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"if (lpa_number(lpa_value('GlobalIndicator'))>90){\\n lpa_style(\\\"GlobalIndicator\\\", \\\"background-color\\\", '#80ff00');\\n} else if (lpa_number(lpa_value('GlobalIndicator'))>75) {\\n lpa_style(\\\"GlobalIndicator\\\", \\\"background-color\\\", '#b3ffcc');\\n} else if (lpa_number(lpa_value('GlobalIndicator'))>=50) {\\n lpa_style(\\\"GlobalIndicator\\\", \\\"background-color\\\", '#ffff1a');\\n\\n} else if (lpa_number(lpa_value('GlobalIndicator'))>0) {\\n lpa_style(\\\"GlobalIndicator\\\", \\\"background-color\\\", '#ff6666');\\n\\n} else if (lpa_number(lpa_value('GlobalIndicator'))==0) {\\n lpa_style_remove(\\\"GlobalIndicator\\\");\\n\\n} else if (lpa_number(lpa_value('GlobalIndicator'))=='') {\\n lpa_style_remove(\\\"GlobalIndicator\\\");\\n}\\n\\n\\n\\n if (lpa_version>3) {\\n lpa_style(\\\"GlobalIndicator\\\", \\\"font-weight\\\", 'bold');\\n lpa_style(\\\"GlobalIndicator\\\", \\\"font-size\\\", '25px');\\n }\\n \\n\\n\"}}]},\"ConditionalSteps\":{\"name\":\"ConditionalSteps\",\"desc\":\"\",\"actions\":[{\"action\":\"if\",\"parameters\":{\"condition\":\".Status='Registo' and #GlobalIndicator=0\",\"actions\":[{\"action\":\"lpa_message\",\"parameters\":{\"type\":\"info\",\"title\":\"Sua pontuação é zero\",\"text\":\" Verifique se pretende enviar uma avaliação com pontuação de zero?\"}}],\"else\":[]}},{\"action\":\"if\",\"parameters\":{\"condition\":\".Status='Follow-Up' and #EvaluationEffectiveness<>'Sim'\",\"actions\":[{\"action\":\"lpa_message\",\"parameters\":{\"type\":\"info\",\"title\":\"Plano de Ação não Concluído\",\"text\":\"Não pode fechar a Auditoria sem concluir o plano de Ações.\"}},{\"action\":\"lpa_wkf_stop\",\"parameters\":{}}],\"else\":[]}}]},\"PopulateTasks\":{\"name\":\"PopulateTasks\",\"desc\":\"\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"var TasksTotal = lpa_sql(\\\"SELECT COUNT(*) AS total FROM EstruturaAccoes AS AccoesMaster WHERE AccoesID=(CASE WHEN AccoesModoAtribuicao='partilhada' THEN (SELECT MAX(AccoesID) FROM EstruturaAccoes AS SubQuery WHERE AccoesMaster.AccoesCodigoPartilha=SubQuery.AccoesCodigoPartilha AND AccoesEstruturaID=@EstruturaID) ELSE AccoesID END) AND AccoesEstruturaID=@EstruturaID\\\",{EstruturaID: lpa_wkf_id()})\\r\\nlpa_val('TotalTasks', TasksTotal.total);\\r\\n\\r\\n\\r\\nvar TasksCompleted = lpa_sql(\\\"SELECT COUNT(*) AS total FROM EstruturaAccoes AS AccoesMaster WHERE AccoesID=(CASE WHEN AccoesModoAtribuicao='partilhada' THEN (SELECT MAX(AccoesID) FROM EstruturaAccoes AS SubQuery WHERE AccoesMaster.AccoesCodigoPartilha=SubQuery.AccoesCodigoPartilha AND AccoesEstruturaID=@EstruturaID) ELSE AccoesID END) AND AccoesEstruturaID=@EstruturaID AND AccoesEstado = 'Terminada'\\\",{EstruturaID: lpa_wkf_id()})\\r\\nlpa_val('CompletedTasks', TasksCompleted.total);\\r\\n\"}}]},\"Clone\":{\"name\":\"Clone\",\"desc\":\"\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"if (lpa_version <= 3) {\\r\\n\\r\\n lpa_modal_yesno('Tem certeza de que deseja copiar este workflow e gerar nova auditoria?', {\\r\\n yes: function() {\\r\\n var link = LPA_WORKFLOW_CLONE(lpa_wkf_id(), 'Auditorias - Checklist 2', undefined, undefined, ['Checklist']);\\r\\n var id = link.split('=');\\r\\n var meses = 6;\\r\\n \\r\\n lpa_wkf_val(id[1], {\\r\\n AssessmentDate: moment().add(meses, 'M').format('DD/MM/YYYY'),\\r\\n DateOfRegistration: ''\\r\\n })\\r\\n lpa_sql(\\\"UPDATE EstruturaWorkflowAccoes SET AccoesDataFinal = @data where AccoesID = (SELECT TOP 1 AccoesID FROM EstruturaWorkflowAccoes WHERE AccoesEstruturaID = @ID ORDER BY AccoesID DESC)\\\", {\\r\\n data: moment().add(meses, 'M').format('YYYY-MM-DD HH:mm:ss:000'),\\r\\n ID: id[1]\\r\\n })\\r\\n lpa_sql('Delete FROM AuditChecklist where EstruturaID = @id', {\\r\\n id: id[1]\\r\\n });\\r\\n lpa_modal_yesno_hide();\\r\\n lpa_open(link);\\r\\n },\\r\\n no: function() {\\r\\n lpa_modal_yesno_hide();\\r\\n }\\r\\n\\r\\n\\r\\n });\\r\\n\\r\\n}\"}}]},\"LinkToReport\":{\"name\":\"LinkToReport\",\"desc\":\"\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"\\tvar site = lpa_agir();\\n\\tvar relatorio = lpa_sql(\\\"SELECT ReportID FROM Report WHERE ReportName = 'Auditoria de Avaliação Legal'\\\");\\n\\tlpa_open(site + 'report_viewer.aspx?id=' + relatorio.ReportID+ '&AGIR CODE=' + lpa_wkf_code());\"}}]},\"TabSelect\":{\"name\":\"TabSelect\",\"desc\":\"\",\"actions\":[{\"action\":\"if\",\"parameters\":{\"condition\":\".Status<>'Follow-Up'\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"lpa_tab_select ('Checklist');\"}}],\"else\":[]}}]},\"TableConditionalVisibilityAndFormats\":{\"name\":\"TableConditionalVisibilityAndFormats\",\"desc\":\"\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"lpa_table('AuditChecklist', function () {\\r\\n\\r\\n if (lpa_version>3) {\\r\\n lpa_table_column_visible('AuditChecklist', 'GroupAudit', true) \\r\\n }\\r\\n else {\\r\\n lpa_table_column_visible('AuditChecklist', 'GroupAudit', false) \\r\\n }\\r\\n \\r\\n lpa_table_column_event('AuditChecklist', 'AnswerAudit', function() {\\r\\n\\r\\n EvaluateRows()\\r\\n })\\r\\n EvaluateRows()\\r\\n \\r\\n});\"}},{\"action\":\"if\",\"parameters\":{\"condition\":\"#NewRA='Sim'\",\"actions\":[{\"action\":\"lpa_visible\",\"parameters\":{\"id\":\"NewRAL2\",\"value\":\"true\"}}],\"else\":[{\"action\":\"lpa_visible\",\"parameters\":{\"id\":\"NewRAL2\",\"value\":\"false\"}}]}}]},\"Gage\":{\"name\":\"Gage\",\"desc\":\"\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\" if (lpa_version<=3) {\\n \\n var value = lpa_value('GlobalIndicator');\\n LPA_GAGE('ChartGlobalL', '', value, { 'decimals':true, 'min': 0.0, 'max': 100.0,'pointer' : true, 'counter': true,levelColors : [ \\\"#ff0000\\\", \\\"#ffff00\\\", \\\"#00ff00\\\" ] ,pointerOptions: {\\n toplength: -15,\\n bottomlength: 10,\\n bottomwidth: 12,\\n color: '#8e8e93',\\n stroke: '#ffffff',\\n stroke_width: 3,\\n stroke_linecap: 'round'\\n },});\\n \\n }\"}}]},\"EvaluateRows\":{\"name\":\"EvaluateRows\",\"desc\":\"\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\" var yes = 0;\\r\\n var no = 0;\\r\\n var om = 0;\\r\\n console.log(om)\\r\\n var groups = {}\\r\\n var GlobalValue = 0;\\r\\n \\r\\n lpa_table_rows('AuditChecklist', function(row) {\\r\\n groups[lpa_val(row.GroupAudit)] = groups[lpa_val(row.GroupAudit)] || { yes: 0, no: 0, om: 0 } \\r\\n\\r\\n lpa_style_remove(row.AnswerAudit)\\r\\n \\r\\n if (lpa_value(row.AnswerAudit)==='Conforme') {\\r\\n yes++\\r\\n // yes = yes + lpa_number(row.weight);\\r\\n groups[lpa_val(row.GroupAudit)].yes++\\r\\n lpa_style(row.AnswerAudit,'background-color','Chartreuse')\\r\\n } \\r\\n if (lpa_value(row.AnswerAudit)==='OM') {\\r\\n om++\\r\\n // yes = yes + lpa_number(row.weight);\\r\\n groups[lpa_val(row.GroupAudit)].om++\\r\\n lpa_style(row.AnswerAudit,'background-color','#ffb347')\\r\\n } \\r\\n if (lpa_value(row.AnswerAudit)==='Não Conforme') {\\r\\n no++\\r\\n // no = no + lpa_number(row.weight);\\r\\n groups[lpa_val(row.GroupAudit)].no++\\r\\n lpa_style(row.AnswerAudit,'background-color','Tomato')\\r\\n } \\r\\n if (lpa_value(row.AnswerAudit)==='Não Aplicável') {\\r\\n lpa_style(row.AnswerAudit,'background-color','Gray')\\r\\n }\\r\\n \\r\\n if (lpa_version >= 4) { \\r\\n if (lpa_value(row.Titulo) === 'Yes') {\\r\\n Object.keys(row).forEach(function (col) {\\r\\n if (col !== 'id') {\\r\\n lpa_style(row[col], 'background-color', 'LightSkyBlue')\\r\\n lpa_enabled(row[col], false)\\r\\n }\\r\\n })\\r\\n }\\r\\n }\\r\\n })\\r\\n GlobalValue = (om * 0.5 + yes * 1.00) / (yes + no + om) * 100;\\r\\n if(isNaN(GlobalValue))\\r\\n GlobalValue = 0;\\r\\n lpa_value('GlobalIndicator', lpa_round(GlobalValue,2))\\r\\n Gage();\\r\\n ConditionalFormats();\\r\\n\\r\\n\\r\\n\"}}]},\"PendingTasks\":{\"name\":\"PendingTasks\",\"desc\":\"\",\"actions\":[{\"action\":\"if\",\"parameters\":{\"condition\":\".Status='Follow-Up' and .PendingTasks<>0\",\"actions\":[{\"action\":\"lpa_wkf_stop\",\"parameters\":{}},{\"action\":\"lpa_message\",\"parameters\":{\"type\":\"info\",\"title\":\"Tarefas Pendentes\",\"text\":\"Este workflow possui .PendingTasks tarefas pendentes! Por favor feche as ações antes de encerrar esta auditoria.\"}}],\"else\":[]}}]},\"RespostaEmLote\":{\"name\":\"RespostaEmLote\",\"desc\":\"\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"\\r\\n var Changes = lpa_value('GlobalAll')\\r\\n \\r\\n if (Changes !=='') {\\r\\n \\r\\n var changeResponse = ('Deseja aplicar a resposta ' + Changes +' a todas as questões? Após esta operação poderá editar individualmente cada resposta. '+'? Pode demorar alguns segundos!');\\r\\n lpa_modal_yesno(changeResponse,{yes_text:'Sim',no_text:'Não',\\r\\n yes: function() {\\r\\n lpa_table_rows('AuditChecklist', function(rows) {\\r\\n if (lpa_value(rows.Titulo) !== 'Yes') {\\r\\n lpa_value(rows.AnswerAudit, Changes);\\r\\n } \\r\\n })\\r\\n EvaluateRows();\\r\\n Gage();\\r\\n lpa_value('GlobalAll','')\\r\\n \\r\\n lpa_modal_yesno_hide();\\r\\n }, //yes\\r\\n no: function() {\\r\\n \\r\\n lpa_value('GlobalAll','')\\r\\n lpa_modal_yesno_hide();\\r\\n } //no\\r\\n })\\r\\n \\r\\n }\\r\\n\"}}]},\"DefaultValues\":{\"name\":\"DefaultValues\",\"desc\":\"\",\"actions\":[{\"action\":\"if\",\"parameters\":{\"condition\":\"#Auditor=''\",\"actions\":[{\"action\":\"lpa_value\",\"parameters\":{\"id\":\"Auditor\",\"value\":\".User\"}}],\"else\":[]}}]},\"FillRequisitoLegal\":{\"name\":\"FillRequisitoLegal\",\"desc\":\"\",\"actions\":[{\"action\":\"if\",\"parameters\":{\"condition\":\".Status = 'Follow-Up'\",\"actions\":[{\"action\":\"lpa_script\",\"parameters\":{\"code\":\"var linhas = lpa_sql(\\\"select DISTINCT CodeID FROM LegalChecklist WHERE EstruturaID = @EstruturaID\\\", {EstruturaID: lpa_wkf_id()})\\nlpa_message('Por favor aguarde até os requisitos estarem sincronizados')\\nlpa_sql(\\\"delete from AvaliacaoLegalRequisitos where WKF_Avaliacao_Code = @WKF_Avaliacao_Code \\\", {WKF_Avaliacao_Code: lpa_wkf_id()})\\nlpa_each(linhas, function(linha){\\n console.log(linha)\\n\\t\\n lpa_sql(\\\"insert into AvaliacaoLegalRequisitos (EstruturaID, DataAvaliacao, Avaliador, Empresa, WKF_Avaliacao_Code) VALUES (@EstruturaID, @DataAvaliacao, @Avaliador, @Empresa, @WKF_Avaliacao_Code)\\\", {EstruturaID: linha.CodeID, DataAvaliacao: lpa_date_sql(lpa_value('AssessmentDate')), Avaliador: lpa_value('Auditor'), Empresa: lpa_value('Site'), WKF_Avaliacao_Code: lpa_wkf_id()})\\n})\\nlpa_message('Requisitos sincronizados com sucesso', {type:'success'})\"}}],\"else\":[]}}]}}" } }