Export Hazard propose

 avatar
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