Tunjukkan bahwa korporasi tergabung dalam asosiasi bisnis/perkumpulan profesi.
', 23, 2, 'Indicate that the corporation belongs to a business association/professional society
'); 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', 'Tunjukkan bahwa korporasi terlibat dalam aksi kolektif kolaborasi antikorupsi.
', 24, 2, 'Whether or not the business association/professional association has an agenda that addresses corruption issues.
'); 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', 'Bukti keanggotaan korporasi dalam asosiasi bisnis/perkumpulan profesi.
', 'f', 59, 10, 2, 'Proof of corporate membership in a business association/professional association.
'); 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', 'Asosiasi bisnis/perkumpulan profesi tersebut memiliki agenda yang membahas isu korupsi atau tidak.
', 'f', 60, 10, 2, 'Whether or not the business association/professional association has an agenda that addresses corruption issues.
'); 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', 'Bukti adanya keterlibatan aktif korporasi dalam forum komunikasi antarpemangku kepentingan dalam suatu kelompok kerja antikorupsi (contoh: laporan, workshop, dokumentasi, dll).
', 'f', 61, 10, 2, 'Evidence of the corporation''s active involvement in a communication forum between stakeholders in an anticorruption working group (for example: reports, workshops, documentation, etc.)
'); 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', 'Bukti adanya keterlibatan aktif korporasi dalam forum komunikasi lintas sektoral meliputi lembaga nonpemerintah, yayasan, akademisi, instansi pemerintah, dan lain-lain yang mengangkat isu antikorupsi.
', 'f', 62, 10, 2, 'Evidence of active corporate involvement in crosssectoral communication forums including nongovernmental organizations, foundations, academics, government agencies, and others that raise anticorruption issues.
'); "); } public function down() { self::$connection->execute(" 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; "); } }