Export Hazard propose
user_9481960
mysql
19 days ago
2.6 kB
5
Indexable
SELECT hazard.id as `Hazard ID`, hazard.isafe_no as `No Isafe Pelapor`, pelapor.nik as `NIK Pelapor`, pelapor.name as `Nama Pelapor`, pelapor.position as `Posisi Pelapor`, pelapor.department as `Departemen Pelapor`, pelapor.company as `Perusahaan Pelapor`, penanggung_jawab.isafe_no as `No Isafe PenindakLanjut`, penanggung_jawab.nik as `NIK PenindakLanjut`, penanggung_jawab.name as `Nama PenindakLanjut`, penanggung_jawab.position as `Posisi PenindakLanjut`, penanggung_jawab.department as `Department PenindakLanjut`, penanggung_jawab.company as `Perusahaan PenindakLanjut`, hazard.title as `Judul Laporan`, hazard.description as `Deskripsi Laporan`, hazard.ktadantta as `Jenis Temuan (KTA\TTA)`, hazard.risk as `Resiko Temuan`, hazard.source_of_cause as `Penyebab`, nc.tta as `Penyebab langsung (TTA)`, nc.kta as `Penyebab langsung (KTA)`, nc.faktor_manusia as `Penyebab dasar (Pribadi)`, nc.faktor_pekerjaan as `Penyebab dasar (Pekerjaan)`, hazard.createdAt as `Tanggal Laporan`, loc.location_name as `Lokasi Laporan`, subloc.name as `Sub lokasi Laporan`, hazard.detail_loc as `Detail Lokasi`, h1.history_date as `Tanggal Follow Up`, h2.history_date as `Tanggal Close`, hazard.status as `Status Laporan`, hazard.categories as `Ketidaksesuaian`, hazard.source_of_cause as `Sub Ketidaksesuaian` FROM dsis_hse_hazard_isafe hazard LEFT JOIN ( SELECT s1.* FROM dsis_hse_simper s1 INNER JOIN ( SELECT isafe_no, MIN(id) as min_id FROM dsis_hse_simper WHERE status_karyawan = 0 GROUP BY isafe_no ) s2 ON s1.id = s2.min_id ) pelapor ON pelapor.isafe_no = hazard.isafe_no LEFT JOIN ( SELECT s1.* FROM dsis_hse_simper s1 INNER JOIN ( SELECT isafe_no, MIN(id) as min_id FROM dsis_hse_simper WHERE status_karyawan = 0 GROUP BY isafe_no ) s2 ON s1.id = s2.min_id ) penanggung_jawab ON penanggung_jawab.isafe_no = hazard.assignTo LEFT JOIN dsis_hse_nc nc ON nc.hazard_id = hazard.id LEFT JOIN dsis_hse_nc_history h1 ON h1.nc_id = nc.id AND h1.status = 'FOLLOWUP' LEFT JOIN dsis_hse_nc_history h2 ON h2.nc_id = nc.id AND h2.status = 'END' LEFT JOIN dsis_master_location loc ON loc.id = hazard.location_id LEFT JOIN dsis_master_sub_lokasi subloc ON subloc.id = hazard.id_sublocation WHERE hazard.id = 1303287 ORDER BY hazard.id DESC
Editor is loading...
Leave a Comment