<?php

use Phalcon\Mvc\Model\Migration;

class InsertIndikatorPancekMigration_545 extends Migration
{
    public function up() {
        self::$connection->execute("
            INSERT INTO jaga.pancek_konsep_sistem_pencegahan (code, label, label_en, view_order, formulir_type) VALUES ('K', 'KOMITMEN', 'COMMITMENT', 1, 3);
            INSERT INTO jaga.pancek_konsep_sistem_pencegahan (code, label, label_en, view_order, formulir_type) VALUES ('P', 'PERENCANAAN', 'PLAN', 2, 3);
            INSERT INTO jaga.pancek_konsep_sistem_pencegahan (code, label, label_en, view_order, formulir_type) VALUES ('D', 'PELAKSANAAN', 'Implementation (DO)', 3, 3);
            INSERT INTO jaga.pancek_konsep_sistem_pencegahan (code, label, label_en, view_order, formulir_type) VALUES ('C', 'EVALUASI', 'Evaluation (CHECK)', 4, 3);
            INSERT INTO jaga.pancek_konsep_sistem_pencegahan (code, label, label_en, view_order, formulir_type) VALUES ('A', 'PERBAIKAN', 'Improvement (ACTION)', 5, 3);
            INSERT INTO jaga.pancek_konsep_sistem_pencegahan (code, label, label_en, view_order, formulir_type) VALUES ('R', 'RESPON', 'RESPONSE', 6, 3);

            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('K.1', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'K' AND formulir_type = 3), '<p>Tunjukkan bahwa pimpinan tertinggi korporasi, seperti pemilik, direksi, dan komisaris, memiliki komitmen tertulis antipenyuapan seperti berikut ini:</p>', '<p>Show that the highest corporate leaders, such as owners, directors and commissioners, have a written anti-corruption commitment as follows:</p>', 1, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('K.2', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'K' AND formulir_type = 3), '<p>Tunjukkan pernyataan antipenyuapan yang harus ditandatangani semua pegawai korporasi seperti tercantum dalam kontrak kerja atau formulir pernyataan sebagai berikut:</p>', '<p>Show the anti-corruption statement that must be signed by all corporate employees as stated in the employment contract or statement form as follows:</p>', 2, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('K.3', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'K' AND formulir_type = 3), '<p>Tunjukkan bahwa kebijakan dan/atau peraturan antipenyuapan korporasi memiliki definisi tentang korupsi.</p>', '<p>Demonstrate that corporate anti-bribery policies and/or regulations have a definition of corruption.</p>', 3, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('K.4', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'K' AND formulir_type = 3), '<p>Tunjukkan bahwa kebijakan dan/atau peraturan antipenyuapan tertulis telah mengacu pada UU Tipikor dan wajib ditaati semua pegawai korporasi.</p>', '<p>Show that written anti-bribery policies and/or regulations refer to the Corruption Law and must be adhered to by all corporate employees.</p>', 4, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('K.5', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'K' AND formulir_type = 3), '<p>Tunjukkan bahwa kebijakan dan/atau peraturan antipenyuapan tersebut memuat penjelasan di area mana saja penyuapan kemungkinan besar terjadi.</p>', '<p>Show that the anti-bribery policy and/or regulations contain an explanation of the areas where corruption is most likely to occur.</p>', 5, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('K.6', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'K' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi mempunyai unit atau individu tertentu yang memastikan upaya kontrol dalam mencegah korupsi.</p>', '<p>Show that the corporation has certain units or individuals who ensure control efforts to prevent corruption.</p>', 6, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('K.7', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'K' AND formulir_type = 3), '<p>Tunjukkan bahwa unit atau individu tertentu itu melaksanakan upaya komunikasi dan pelatihan terhadap upaya pencegahan korupsi.</p>', '<p>Demonstrate that the specific unit or individual is implementing communication and training efforts towards corruption prevention efforts.</p>', 7, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('P.1', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'P' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi telah melakukan identifikasi dan pemetaan risiko yang mencakup titik rawan dan modus penyuapan.</p>', '<p>Show that the corporation has carried out risk identification and mapping which includes vulnerable points and modes of bribery.</p>', 8, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('P.2', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'P' AND formulir_type = 3), '<p>Tunjukkan bahwa penilaian risiko korupsi telah dilakukan terhadap semua aktivitas korporasi.</p>', '<p>Demonstrate that a corruption risk assessment has been conducted for all corporate activities.</p>', 9, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('P.3', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'P' AND formulir_type = 3), '<p>Tunjukkan bahwa penilaian risiko korupsi dilakukan secara berkala dan diperbarui berdasarkan perkembangan modus korupsi.</p>', '<p>Demonstrate that corruption risk assessments are conducted periodically and updated based on developments in corruption modes.</p>', 10, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('D.1', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'D' AND formulir_type = 3), '<p>Tunjukkan bahwa kebijakan dan/atau peraturan antipenyuapan juga mengikat pihak eksternal, seperti distributor, mitra usaha, pihak ketiga (konsultan, akuntan publik, pengacara), agen, dan vendor yang berhubungan dengan korporasi.</p>', '<p>Show that anti-bribery policies and/or regulations also bind external parties, such as distributors, business partners, third parties (consultants, public accountants, lawyers), agents and vendors related to the corporation.</p>', 11, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('D.2', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'D' AND formulir_type = 3), '<p>Tunjukkan kebijakan dan/atau peraturan antipenyuapan yang mencakup sistem pengawasan, pemberian sanksi, dan evaluasi kepada pihak internal dan eksternal korporasi.</p>', '<p>Demonstrate anti-bribery policies and/or regulations that include monitoring, sanctioning, and evaluation systems for internal and external parties of the corporation.</p>', 12, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('D.3', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'D' AND formulir_type = 3), '<p>Tunjukkan kebijakan dan/atau peraturan antipenyuapan yang memuat tentang:</p><ul><li>pengaturan gratifikasi yang diberikan kepada pegawai negeri atau penyelenggara negara (sektor publik);</li><li>pengaturan praktik pemberian fasilitas, hadiah, dan sponsor baik di lingkup internal maupun eksternal;</li><li>pengaturan kontribusi dana politik;</li></ul>', '<p>Show anti-bribery policies and/or regulations that contain:</p><ul><li>regulations on gratuities given to civil servants or state administrators (public sector);</li><li>regulations on the practice of providing facilities, gifts, and sponsorships both internally and externally;</li><li>regulations on political fund contributions;</li></ul>', 13, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('D.5', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'D' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi menerapkan prinsip mengenali pemilik manfaat dari korporasi.</p>', '<p>Demonstrate that the corporation applies the principle of recognizing the beneficial owners of the corporation.</p>', 14, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('D.6', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'D' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi mempunyai sistem pelaporan dan pengaduan atas dugaan adanya penyuapan yang menjamin kerahasiaan, perlindungan, dan keamanan bagi pelapor di lingkup eksternal.</p>', '<p>Demonstrate that the corporation has a reporting and complaint system for suspected bribery that guarantees confidentiality, protection and security for external whistleblowers.</p>', 15, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('D.7', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'D' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi menyosialisasikan kebijakan dan/atau peraturan antipenyuapan secara berkala kepada semua pegawai.</p>', '<p>Show that the corporation regularly socializes anti-bribery policies and/or regulations to all employees.</p>', 16, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('C.1', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'C' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi mempunyai sistem pemantauan dan evaluasi terhadap peraturan antipenyuapan.</p>', '<p>Demonstrate that the corporation has a monitoring and evaluation system for anti-bribery regulations.</p>', 17, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('C.2', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'C' AND formulir_type = 3), '<p>Tunjukkan bahwa sistem pemantauan dan evaluasi antipenyuapan telah dikomunikasikan secara berkala kepada semua pegawai korporasi.</p>', '<p>Demonstrate that the anti-bribery monitoring and evaluation system has been communicated regularly to all corporate employees.</p>', 18, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('C.3', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'C' AND formulir_type = 3), '<p>Tunjukkan bahwa hasil pemantauan dan evaluasi terkait korupsi dikomunikasikan secara berkala kepada seluruh pimpinan korporasi sebagai pembelajaran.</p>', '<p>Show that the results of monitoring and evaluation related to corruption are communicated regularly to all corporate leaders as a learning experience.</p>', 19, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('A.1', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'A' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi telah memiliki mekanisme pemberian sanksi bagi tindakan pelanggaran terhadap peraturan antipenyuapan perusahaan yang berlaku.</p>', '<p>Demonstrate that the corporation has a mechanism for imposing sanctions for violations of applicable corporate anti-bribery regulations.</p>', 20, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('A.2', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'A' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi telah memiliki mekanisme pemberian penghargaan bagi pegawai yang berperan aktif dalam membangun budaya korporasi yang berintegritas.</p>', '<p>Show that the corporation has a reward mechanism for employees who play an active role in building a corporate culture of integrity.</p>', 21, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('A.3', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'A' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi menindaklanjuti hasil evaluasi pelaksanaan penerapan program pencegahan korupsi.</p>', '<p>Demonstrate that the corporation follows up on the results of the evaluation of the implementation of the corruption prevention program.</p>', 22, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('R.1', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'R' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi tergabung dalam asosiasi bisnis/perkumpulan profesi.</p>', '<p>Indicate that the corporation belongs to a business association/professional society</p>', 23, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('R.2', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'R' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi terlibat dalam aksi kolektif kolaborasi antikorupsi.</p>', '<p>Whether or not the business association/professional association has an agenda that addresses corruption issues.</p>', 24, 3);
            INSERT INTO jaga.pancek_indikator (code, konsep_sistem_pencegahan_id, label, label_en, view_order, formulir_type) VALUES ('R.3', (SELECT id FROM pancek_konsep_sistem_pencegahan WHERE code = 'R' AND formulir_type = 3), '<p>Tunjukkan bahwa korporasi melaporkan indikasi tindak pidana korupsi, suap, pemerasan, atau bentuk pungutan liar lainnya yang dilakukan oleh oknum regulator dan/atau penegak hukum.</p>', '<p>Show that the corporation reports indications of criminal acts of corruption, bribery, extortion, or other forms of illegal levies committed by regulators and/or law enforcers.</p>', 25, 3);

            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.1'), 'K.1.a', null, '<p>Komitmen tertulis antipenyuapan.</p>', '<p>Written anti-bribery commitment.</p>', FALSE, 1, 4.75, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.1'), 'K.1.b', null, '<p>Bukti deklarasi komitmen antipenyuapan dan pihak yang menghadiri deklarasi tersebut.</p>', '<p>Evidence of the anti-bribery commitment declaration and the parties attending the declaration.</p>', FALSE, 2, 4.75, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.1'), 'K.1.c', null, '<p>Komunikasi terhadap komitmen tertulis melalui surat elektronik, sesi diskusi, dan lain-lain.</p>', '<p>Communication of written commitments via e-mail, discussion sessions, etc.</p>', FALSE, 3, 4.75, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.1'), 'K.1.d', null, '<p>Bukti bahwa komitmen pimpinan tertinggi telah menghasilkan kebijakan antipenyuapan.</p>', '<p>Evidence that the commitment of top leadership has resulted in anti-bribery policies</p>', FALSE, 4, 4.75, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.2'), 'K.2.a', null, '<p>Pakta integritas/kontrak kerja (sampel dari level manajer).</p>', '<p>Integrity pact/employment contract (sample from manager level).</p>', FALSE, 5, 9, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.2'), 'K.2.b', null, '<p>Pakta berisi larangan pemberian uang pelicin ataupun suap kepada pembuat kebijakan.</p>', '<p>The pact contain a prohibition on giving kickbacks or bribes to policy makers.</p>', FALSE, 6, 9, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.3'), 'K.3.a', null, '<p>Kebijakan dan/atau peraturan tersebut memiliki definisi korupsi yang telah dibandingkan dengan berbagai sumber.</p>', '<p>The policies and/or regulations have a definition of corruption that has been compared with various sources.</p>', FALSE, 7, 9, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.4'), 'K.4.a', null, '<p>Kebijakan dan/atau peraturan antipenyuapan tersebut telah mengacu pada UU Tipikor.</p>', '<p>The anti-bribery policies and/or regulations refer to the Corruption Eradication Law.</p>', FALSE, 8, 18, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.5'), 'K.5.a', null, '<p>Kebijakan dan/atau peraturan tersebut mengandung penjelasan peta rawan korupsi.</p>', '<p>The policy and/or regulations contain an explanation of the corruption-prone map.</p>', FALSE, 9, 18, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.6'), 'K.6.a', null, '<p>Unit atau individu yang menyelenggarakan fungsi kepatuhan.</p>', '<p>The unit or individual who carries out the compliance function.</p>', FALSE, 10, 1.8, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.6'), 'K.6.b', null, '<p>Surat pengangkatan dan wewenang individu tersebut.</p>', '<p>The letter of appointment and authority of the individual.</p>', FALSE, 11, 1.8, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.6'), 'K.6.c', null, '<p>Prosedur operasi standar (standard operating procedure/SOP) unit tersebut.</p>', '<p>The unit''s standard operating procedure (SOP).</p>', FALSE, 12, 1.8, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.6'), 'K.6.d', null, '<p>Rasio perbandingan antara jumlah pegawai yang menjalankan fungsi kepatuhan dan total pegawai korporasi mengacu pada best practice.</p>', '<p>The comparative ratio between the number of employees carrying out compliance functions and the total number of corporate employees refers to best practice.</p>>).', FALSE, 13, 1.8, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.6'), 'K.6.e', null, '<p>Bukti kompetensi individu yang menangani kepatuhan (contoh: sertifikat auditor, CCO, API, SPIP, dll).</p>', '<p>Evidence of the competency of the individual handling compliance (examples: auditor certificate, CCO, API, SPIP, etc.).</p>', FALSE, 14, 1.8, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.7'), 'K.7.a', null, '<p>Komitmen tertulis unit atau individu untuk melaksanakan komunikasi dan pelatihan terhadap pencegahan korupsi (contoh: rencana kerja, agenda kegiatan, dll).</p>', '<p>Written commitment of the unit or individual to implement communication and training on corruption prevention (examples: work plan, activity agenda, etc.).</p>', FALSE, 15, 3, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.7'), 'K.7.b', null, '<p>Bukti pelaksanaan kegiatan (contoh: laporan pelaksanaan kegiatan, dokumentasi, dll).</p>', '<p>Evidence of activity implementation (examples: activity implementation reports, documentation, etc.).</p>', FALSE, 16, 3, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'K.7'), 'K.7.c', null, '<p>Bukti evaluasi pelaksanaan kegiatan.</p>', '<p>Evidence of evaluation of activity implementation.</p>', FALSE, 17, 3, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'P.1'), 'P.1.a', null, '<p>Bukti adanya fungsi pelaksana yang mengidentifikasi dan memetakan risiko yang mencakup titik rawan dan modus penyuapan.</p>', '<p>Evidence of the existence of an implementing function that identifies and maps risks including vulnerable points and bribery modes.</p>', FALSE, 18, 16.67, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'P.1'), 'P.1.b', null, '<p>Bukti kertas kerja pemetaan risiko yang mencakup titik rawan dan modus penyuapan (daftar risiko/risk register, perencanaan mitigasi, serta monitoring dan evaluasi/monev mitigasi).</p>', '<p>Evidence of risk mapping working papers covering vulnerable points and bribery modes (risk register, mitigation planning, and mitigation monitoring and evaluation).</p>', FALSE, 19, 16.67, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'P.1'), 'P.1.c', null, '<p>Penentuan tingkat kerawanan risiko.</p>', '<p>Determination of risk vulnerability level.</p>', FALSE, 20, 16.66, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'P.2'), 'P.2.a', null, '<p>Bukti penilaian risiko korupsi dilakukan di semua atau beberapa unit.</p>', '<p>Evidence of corruption risk assessments conducted in all or some units.</p>', FALSE, 21, 15, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'P.3'), 'P.3.a', null, '<p>Bukti penilaian risiko dilakukan secara berkala dan diperbarui berdasarkan modus korupsi dan praktik baik (contoh: laporan pelaksanaan mitigasi risiko dan beberapa daftar risiko/risk register yang diperbarui).</p>', '<p>Evidence of risk assessments is conducted periodically and updated based on corruption modes and good practices (examples: risk mitigation implementation reports and several updated risk registers).</p>', FALSE, 22, 35, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.1'), 'D.1.a', null, '<p>Perjanjian atau kontrak yang menunjukkan peraturan antipenyuapan untuk mengikat pihak eksternal yang berhubungan dengan korporasi (sampel).</p>', '<p>Agreement or contract indicating anti-bribery regulations to bind external parties dealing with the corporation (sample).</p>', FALSE, 23, 18.84, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.2'), 'D.2.a', null, '<p>Perjanjian kerja yang menunjukkan peraturan antipenyuapan, yang mencakup sistem pengawasan, pemberian sanksi, dan evaluasi bagi pihak internal korporasi (sampel).</p>', '<p>Employment agreement that shows anti-bribery regulations, including a system of supervision, sanctions and evaluation for internal corporate parties (sample).</p>', FALSE, 24, 18.84, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.3'), 'D.3.a', null, '<p>Bukti kebijakan atau peraturan antipenyuapan untuk:</p>', '<p>Evidence of anti-bribery policies or regulations for:</p>', TRUE, 25, 4.73, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.3'), 'D.3.a.1', 'D.3.a', '<p>Pengaturan gratifikasi yang diberikan kepada pegawai negeri atau penyelenggara negara (sektor publik).</p>', '<p>Regulation of gratuities given to civil servants or state administrators (public sector).</p>', FALSE, 26, 1.58, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.3'), 'D.3.a.2', 'D.3.a', '<p>Pengaturan praktik pemberian fasilitas, hadiah, dan sponsor di lingkup eksternal.</p>', '<p>Regulation of the practice of providing facilities, gifts and sponsorships in the external sphere.</p>', FALSE, 27, 1.58, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.3'), 'D.3.a.3', 'D.3.a', '<p>Pengaturan kontribusi dana politik.</p>', '<p>Regulation of political fund contributions.</p>', FALSE, 28, 1.57, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.3'), 'D.3.b', null, '<p>Bukti klausul yang memuat batasan nilai dan bentuk gratifikasi yang boleh atau tidak boleh diberikan kepada pegawai negeri atau penyelenggara negar</p>', '<p>Evidence of a clause containing limits on the value and form of gratuities that may or may not be given to civil servants or state administrators.</p>', FALSE, 29, 4.7, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.3'), 'D.3.c', null, '<p>Bukti klausul yang memuat batasan nilai dan bentuk praktik pemberian fasilitas hadiah dan sponsor yang boleh dan tidak boleh di lingkup eksternal.</p>', '<p>Evidence of clauses containing limits on the value and form of gift and sponsorship practices that are permitted and prohibited in the external scope.</p>', FALSE, 30, 4.7, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.3'), 'D.3.d', null, '<p>Bukti klausul yang memuat tentang pengaturan kontribusi dana politik yang boleh dan tidak boleh.</p>', '<p>Evidence of clauses containing provisions regarding political funding contributions that are permitted and prohibited.</p>', FALSE, 31, 4.7, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.5'), 'D.5.a', null, '<p>Bukti atas penetapan pemilik manfaat korporasi kepada instansi berwenang melalui salah satu dokumen berikut:</p><p>- anggaran dasar;</p><p>-        dokumen pengikatan pendirian korporasi;</p><p>- dokumen keputusan rapat umum pemegang saham, organ yayasan, rapat pengurus, atau rapat anggota;</p><p>- informasi instansi berwenang;</p><p>- informasi lembaga swasta yang menerima penempatan atau pentransferan dana dalam rangka pembelian saham perseroan terbatas;</p><p>-        informasi lembaga swasta yang memberikan atau menyediakan manfaat dari korporasi bagi pemilik manfaat;</p><p>-  pernyataan dari anggota direksi, anggota dewan komisaris, pembina, pengurus, pengawas, dan/atau pejabat/pegawai korporasi yang dapat dipertanggungjawabkan kebenarannya;</p><p>-        dokumen yang dimiliki oleh korporasi atau pihak lain yang menunjukkan bahwa orang yang dimaksud merupakan pemilik sebenarnya dari dana atas kepemilikan perseroan;</p><p>- dokumen yang dimiliki oleh korporasi atau pihak lain yang menunjukkan bahwa orang yang dimaksud merupakan pemilik sebenarnya dari dana atas kekayaan lain atau penyertaan dalam korporasi;</p><p>- dan/atau informasi lain yang dapat dipertanggungjawabkan kebenarannya (Pasal 11 Perpres No.13/2018).</p>', '<p>Evidence of the determination of the beneficial owner of the corporation to the competent authority through one of the following documents:</p> <p>- articles of association;</p> <p>- documents binding the establishment of the corporation;</p> <p>- documents of decisions of the general meeting of shareholders, foundation organs, management meetings, or member meetings;</p> <p>- information from the competent authority;</p> <p>- information from private institutions that receive placement or transfer of funds in order to purchase shares of a limited liability company;</p><p>- information from private institutions that provide or provide benefits from the corporation for beneficial owners;</p> <p>- statements from members of the board of directors, members of the board of commissioners, advisors, administrators, supervisors, and/or officers/employees of the corporation whose truth can be accounted for;</p><p>- documents owned by the corporation or other parties that show that the person in question is the actual owner of funds for ownership of the corporation;</p><p>- documents owned by the corporation or other parties that show that the person in question is the actual owner of funds for other assets or participation in the corporation;</p> <p>- and/or other information whose truth can be accounted for (Article 11 of Presidential Regulation No. 13/2018).</p>', FALSE, 32, 10.83, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.6'), 'D.6.a', null, '<p>Bukti sosialisasi tentang sistem pelaporan dan pengaduan secara periodik.</p>', '<p>Evidence of socialization of the periodic reporting and complaint system.</p>', FALSE, 33, 2.69, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.6'), 'D.6.b', null, '<p>Prosedur operasi standar (standard operating procedur/SOP) sistem pelaporan dan pengaduan.</p>', '<p>Standard operating procedure (SOP) for reporting and complaints system.</p>', FALSE, 34, 2.69, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.6'), 'D.6.c', null, '<p>Saluran pelaporan yang ada (contoh: aplikasi, call centre, SMS, datang langsung, dll).</p>', '<p>Existing reporting channels (examples: application, call center, SMS, direct visit, etc.).</p>', FALSE, 35, 2.69, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.6'), 'D.6.d', null, '<p>Bukti fungsi pelaksana internal ataupun eksternal pengelola sistem pelaporan dan pengaduan (contoh: surat keputusan (SK)/dokumen uraian pekerjaan (job description), dan surat perjanjian kerja sama dengan eksternal).</p>', '<p>Evidence of the internal or external implementing function of the reporting and complaint system manager (examples: decree (SK)/job description document, and external cooperation agreement letter).</p>', FALSE, 36, 2.69, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.6'), 'D.6.e', null, '<p>Bukti penanganan berjenjang.</p>', '<p>Evidence of tiered handling.</p>', FALSE, 37, 2.69, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.6'), 'D.6.f', null, '<p>Bukti statistik pelaporan yang masuk dan diselesaikan, serta rekomendasinya.</p>', '<p>Statistical evidence of incoming and completed reports, as well as recommendations.</p>', FALSE, 38, 2.69, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.6'), 'D.6.g', null, '<p>Bukti evaluasi terhadap sistem pelaporan dan pengaduan secara periodik.</p>', '<p>Evidence of periodic evaluation of the reporting and complaints system.</p>', FALSE, 39, 2.69, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.7'), 'D.7.a', null, '<p>Kebijakan adanya program sosialisasi/peraturan antipenyuapan.</p>', '<p>Policy on the existence of anti-bribery socialization programs/regulations.</p>', FALSE, 40, 3.46, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.7'), 'D.7.b', null, '<p>Bukti kegiatan sosialisasi (contoh: laporan kegiatan dan dokumentasi).</p>', '<p>Evidence of socialization activities (examples: activity reports and documentation).</p>', FALSE, 41, 3.46, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.7'), 'D.7.c', null, '<p>Media yang digunakan menjangkau semua pegawai (contoh: surat elektronik, poster, dll).</p>', '<p>The media used reaches all employees (example: electronic mail, posters, etc.).</p>', FALSE, 42, 3.46, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'D.7'), 'D.7.d', null, '<p>Korporasi menerima atau tidak umpan balik (feedback) dari pegawai, baik terhadap program antipenyuapan maupun fakta lapangan (contoh: survei pegawai).</p>', '<p>Corporation does accept or does not receive feedback from employees, both regarding anti-bribery programs and field facts (e.g. employee surveys).</p>', FALSE, 43, 3.45, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'C.1'), 'C.1.a', null, '<p>Korporasi memiliki kebijakan pemantauan dan evaluasi peraturan antipenyuapan (contoh: peraturan monitoring dan evaluasi/monev).</p>', '<p>The corporation has a policy of monitoring and evaluating anti-bribery regulations (e.g. monitoring and evaluation/monev regulations).</p>', FALSE, 44, 8.67, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'C.1'), 'C.1.b', null, '<p>Korporasi telah menentukan area yang perlu dievaluasi dan menentukan cara pengukurannya.</p>', '<p>The corporation has identified the areas that need to be evaluated and determined how they will be measured.</p>', FALSE, 45, 8.67, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'C.1'), 'C.1.c', null, '<p>Unit yang melakukan pemantauan dan evaluasi di korporasi.</p>', '<p>The unit that carries out monitoring and evaluation in corporations.</p>', FALSE, 46, 8.67, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'C.1'), 'C.1.d', null, '<p>Jadwal pemantauan dan evaluasi yang dilakukan oleh unit yang melakukan pemantauan.</p>', '<p>Monitoring and evaluation schedule carried out by the unit conducting monitoring.</p>', FALSE, 47, 8.67, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'C.1'), 'C.1.e', null, '<p>Hasil pemantauan telah dievaluasi bersama dan telah ditentukan rencana tindak lanjutnya.</p>', '<p>The monitoring results have been evaluated together and a follow-up plan has been determined.</p>', FALSE, 48, 8.66, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'C.2'), 'C.2.a', null, '<p>Media untuk mengomunikasikan sistem pemantauan dan evaluasi antipenyuapan kepada semua pegawai korporasi secara berkala (contoh: rapat, pertemuan, surat elektronik, dll).</p>', '<p>Media to communicate the anti-bribery monitoring and evaluation system to all corporate employees on a regular basis (e.g. meetings, gatherings, e-mails, etc.).</p>', FALSE, 49, 28.33, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'C.3'), 'C.3.a', null, '<p>Hasil pemantauan telah disampaikan kepada pimpinan (contoh: rapat, pertemuan, surat elektronik, dll).</p>', '<p>The monitoring results have been conveyed to the leadership (examples: meetings, gatherings, emails, etc.).</p>', FALSE, 50, 14.17, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'C.3'), 'C.3.b', null, '<p>Evaluasi dilakukan untuk meningkatkan efisiensi dan efektivitas peraturan antipenyuapan melalui hasil audit.</p>', '<p>Evaluations are conducted to improve the efficiency and effectiveness of anti-bribery regulations through audit results.</p>', FALSE, 51, 14.16, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'A.1'), 'A.1.a', null, '<p>Mekanisme pemberian sanksi terhadap tindakan pelanggaran.</p>', '<p>Mechanism for imposing sanctions for violations.</p>', FALSE, 52, 17.5, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'A.1'), 'A.1.b', null, '<p>Bukti pelaksanaan pemberian sanksi.</p>', '<p>Evidence of the implementation of sanctions.</p>', FALSE, 53, 17.5, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'A.2'), 'A.2.a', null, '<p>Bukti adanya kualifikasi penerima penghargaan bagi pegawai yang berperan aktif dalam membangun budaya korporasi yang berintegritas.</p>', '<p>Evidence of award recipient qualifications for employees who play an active role in building a corporate culture of integrity.</p>', FALSE, 54, 11.67, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'A.2'), 'A.2.b', null, '<p>Mekanisme pemberian penghargaan.</p>', '<p>Reward mechanism.</p>', FALSE, 55, 11.67, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'A.2'), 'A.2.c', null, '<p>Bukti pelaksanaan pemberian penghargaan.</p>', '<p>Evidence of the implementation of the award.</p>', FALSE, 56, 11.66, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'A.3'), 'A.3.a', null, '<p>Adanya perubahan peraturan/kebijakan/prosedur operasi standar (standar operating procedure/SOP) terhadap evaluasi yang dilaksanakan.</p>', '<p>Changes to regulations/policies/standard operating procedures (SOP) regarding the evaluation carried out.</p>', FALSE, 57, 15, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'A.3'), 'A.3.b', null, '<p>Korporasi telah menentukan sasaran baru dalam pencegahan korupsi.</p>', '<p>Corporations have set new goals in preventing corruption.</p>', FALSE, 58, 15, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'R.1'), 'R.1.a', null, '<p>Bukti keanggotaan korporasi dalam asosiasi bisnis/perkumpulan profesi.</p>', '<p>Proof of corporate membership in a business association/professional association.</p>', FALSE, 59, 10, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'R.1'), 'R.1.b', null, '<p>Asosiasi bisnis/perkumpulan profesi tersebut memiliki agenda yang membahas isu korupsi atau tidak.</p>', '<p>Whether or not the business association/professional association has an agenda that addresses corruption issues.</p>', FALSE, 60, 10, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'R.2'), 'R.2.a', null, '<p>Bukti adanya keterlibatan aktif korporasi dalam forum komunikasi antarpemangku kepentingan dalam suatu kelompok kerja antikorupsi (contoh: laporan, workshop, dokumentasi, dll).</p>', '<p>Evidence of the corporation''s active involvement in a communication forum between stakeholders in an anticorruption working group (for example: reports, workshops, documentation, etc.)</p>', FALSE, 61, 10, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'R.2'), 'R.2.b', null, '<p>Bukti adanya keterlibatan aktif korporasi dalam forum komunikasi lintas sektoral meliputi lembaga nonpemerintah, yayasan, akademisi, instansi pemerintah, dan lain-lain yang mengangkat isu antikorupsi.</p>', '<p>Evidence of active corporate involvement in crosssectoral communication forums including nongovernmental organizations, foundations, academics, government agencies, and others that raise anticorruption issues.</p>', FALSE, 62, 10, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'R.3'), 'R.3.a', null, '<p>Prosedur operasi standar (standard operating procedur/SOP) pelaporan indikasi tindak pidana korupsi, suap, pemerasan, atau bentuk pungutan liar lainnya yang dilakukan oleh oknum regulator dan/atau penegak hukum.</p>', '<p>Standard operating procedures (SOP) for reporting indications of criminal acts of corruption, bribery, extortion or other forms of illegal levies committed by regulators and/or law enforcers.</p>', FALSE, 63, 30, 3);
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, parent_code, label, label_en, is_header,view_order,bobot, formulir_type) VALUES ((SELECT id FROM pancek_indikator WHERE formulir_type = 3 AND code = 'R.3'), 'R.3.b', null, '<p>Bila ada, tunjukkan data statistik korporasi terhadap pelaporan indikasi tindak pidana korupsi, suap, pemerasan, atau bentuk pungutan liar lainnya yang dilakukan oleh oknum regulator dan/atau penegak hukum.</p>', '<p>If available, show corporate statistical data regarding reporting indications of criminal acts of corruption, bribery, extortion, or other forms of illegal levies committed by regulators and/or law enforcers.</p>', FALSE, 64, 30, 3);
            
            DELETE FROM jaga.pancek_answer WHERE komponen_indikator_id IN ((SELECT id FROM jaga.pancek_komponen_indikator WHERE indikator_id = (SELECT id FROM jaga.pancek_indikator WHERE code = 'R.1' AND formulir_type = 2)));
            DELETE FROM jaga.pancek_answer WHERE komponen_indikator_id IN ((SELECT id FROM jaga.pancek_komponen_indikator WHERE indikator_id = (SELECT id FROM jaga.pancek_indikator WHERE code = 'R.2' AND formulir_type = 2)));
            
            DELETE FROM jaga.pancek_komponen_indikator WHERE indikator_id = (SELECT id FROM jaga.pancek_indikator WHERE code = 'R.1' AND formulir_type = 2);
            DELETE FROM jaga.pancek_komponen_indikator WHERE indikator_id = (SELECT id FROM jaga.pancek_indikator WHERE code = 'R.2' AND formulir_type = 2);
            DELETE FROM jaga.pancek_indikator WHERE code = 'R.1' AND formulir_type = 2;
            DELETE FROM jaga.pancek_indikator WHERE code = 'R.2' AND formulir_type = 2;

            UPDATE jaga.pancek_indikator SET code = 'R.1', view_order = 23 WHERE code = 'R.3' AND formulir_type = 2;
            UPDATE jaga.pancek_komponen_indikator SET code = 'R.1.a', view_order = 59, bobot = 50 WHERE code = 'R.3.a' AND formulir_type = 2;
            UPDATE jaga.pancek_komponen_indikator SET code = 'R.1.b', view_order = 60, bobot = 50 WHERE code = 'R.3.b' AND formulir_type = 2;
        ");
    }

    public function down() {
        self::$connection->execute("
            DELETE FROM jaga.pancek_konsep_sistem_pencegahan WHERE formulir_type = 3;
            DELETE FROM jaga.pancek_indikator WHERE formulir_type = 3;
            DELETE FROM jaga.pancek_komponen_indikator WHERE formulir_type = 3;

            UPDATE jaga.pancek_indikator SET code = 'R.3', view_order = 25 WHERE code = 'R.1' AND formulir_type = 2;
            UPDATE jaga.pancek_komponen_indikator SET code = 'R.3.a', view_order = 63, bobot = 30 WHERE code = 'R.1.a' AND formulir_type = 2;
            UPDATE jaga.pancek_komponen_indikator SET code = 'R.3.b', view_order = 64, bobot = 30 WHERE code = 'R.1.b' AND formulir_type = 2;
            
            INSERT INTO jaga.pancek_indikator (konsep_sistem_pencegahan_id, code, label, view_order, formulir_type, label_en) VALUES ((SELECT id FROM jaga.pancek_konsep_sistem_pencegahan WHERE code = 'R' AND formulir_type = 2), 'R.1', '<p>Tunjukkan bahwa korporasi tergabung dalam asosiasi bisnis/perkumpulan profesi.</p>', 23, 2, '<p>Indicate that the corporation belongs to a business association/professional society</p>');
            INSERT INTO jaga.pancek_indikator (konsep_sistem_pencegahan_id, code, label, view_order, formulir_type, label_en) VALUES ((SELECT id FROM jaga.pancek_konsep_sistem_pencegahan WHERE code = 'R' AND formulir_type = 2), 'R.2', '<p>Tunjukkan bahwa korporasi terlibat dalam aksi kolektif kolaborasi antikorupsi.</p>', 24, 2, '<p>Whether or not the business association/professional association has an agenda that addresses corruption issues.</p>');
            
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, label, is_header, view_order, bobot, formulir_type, label_en) VALUES ((SELECT id FROM jaga.pancek_indikator WHERE code = 'R.1' AND formulir_type = 2), 'R.1.a', '<p>Bukti keanggotaan korporasi dalam asosiasi bisnis/perkumpulan profesi.</p>', 'f', 59, 10, 2, '<p>Proof of corporate membership in a business association/professional association.</p>');
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, label, is_header, view_order, bobot, formulir_type, label_en) VALUES ((SELECT id FROM jaga.pancek_indikator WHERE code = 'R.1' AND formulir_type = 2), 'R.1.b', '<p>Asosiasi bisnis/perkumpulan profesi tersebut memiliki agenda yang membahas isu korupsi atau tidak.</p>', 'f', 60, 10, 2, '<p>Whether or not the business association/professional association has an agenda that addresses corruption issues.</p>');
            
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, label, is_header, view_order, bobot, formulir_type, label_en) VALUES ((SELECT id FROM jaga.pancek_indikator WHERE code = 'R.2' AND formulir_type = 2), 'R.2.a', '<p>Bukti adanya keterlibatan aktif korporasi dalam forum komunikasi antarpemangku kepentingan dalam suatu kelompok kerja antikorupsi (contoh: laporan, workshop, dokumentasi, dll).</p>', 'f', 61, 10, 2, '<p>Evidence of the corporation''s active involvement in a communication forum between stakeholders in an anticorruption working group (for example: reports, workshops, documentation, etc.)</p>');
            INSERT INTO jaga.pancek_komponen_indikator (indikator_id, code, label, is_header, view_order, bobot, formulir_type, label_en) VALUES ((SELECT id FROM jaga.pancek_indikator WHERE code = 'R.2' AND formulir_type = 2), 'R.2.b', '<p>Bukti adanya keterlibatan aktif korporasi dalam forum komunikasi lintas sektoral meliputi lembaga nonpemerintah, yayasan, akademisi, instansi pemerintah, dan lain-lain yang mengangkat isu antikorupsi.</p>', 'f', 62, 10, 2, '<p>Evidence of active corporate involvement in crosssectoral communication forums including nongovernmental organizations, foundations, academics, government agencies, and others that raise anticorruption issues.</p>');
        ");
    }
}
