= '{$tgl_awal}'"; } elseif ($tgl_awal == '' && $tgl_akhir != '') { $where_tgl = " and date(tgl) <= '{$tgl_akhir}'"; } elseif ($tgl_awal != '' && $tgl_akhir != '') { $where_tgl = " and date(tgl) between '{$tgl_awal}' and '{$tgl_akhir}'"; } $query_hist = "SELECT a.*,case when (a.perawat <> 0 ) then b.NAMA when a.kddokter is not null then c.NAMADOKTER end as nama_ppa,d.nama_ppa as jenis_ppa FROM t_detail_diagnosakep a left join m_perawat b on a.perawat = b.IDPERAWAT left join m_dokter c on a.kddokter = c.KDDOKTER left join m_ppa d on a.kategori = d.id_ppa WHERE (a.nomr = '" . $norm . "') ORDER BY a.tgl"; $query_hist_filter = "SELECT a.*,case when (a.perawat <> 0 ) then b.NAMA when a.kddokter is not null then c.NAMADOKTER end as nama_ppa,d.nama_ppa as jenis_ppa FROM t_detail_diagnosakep a left join m_perawat b on a.perawat = b.IDPERAWAT left join m_dokter c on a.kddokter = c.KDDOKTER left join m_ppa d on a.kategori = d.id_ppa WHERE (a.nomr = '" . $norm . "') $where_tgl ORDER BY a.tgl"; $tmp_hist_all = $db->query($query_hist); $tmp_hist_filter = $db->query($query_hist_filter); $html = ''; if ($tmp_hist_filter->numRows() > 0) { $no = 1; $flag_dokter = ''; foreach ($tmp_hist_filter->fetchAll() as $row) { $arr_data[] = [ 'id_detail_diagnosakep' => $row['id_detail_diagnosakep'], 'no' => $no, 'tgl' => datetime_to_id($row['tgl']), 'jenis_ppa' => $row['jenis_ppa'], 'nama_ppa' => $row['nama_ppa'], 'soap' => (($row['jenis_ppa'] != 'Gizi') ? 'S : ' . $row['evaluasi_s'] . '

O : ' . $row['evaluasi_o'] . '

A : ' . $row['evaluasi_a'] . '

P : ' . $row['evaluasi_p'] . '
' : 'A : ' . $row['evaluasi_s'] . '

D : ' . $row['evaluasi_o'] . '

I : ' . $row['evaluasi_a'] . '

ME : ' . $row['evaluasi_p'] . '
'), 'review' => $row['review'], ]; $no++; } } $output = array( "draw" => intval($_GET['draw']), "recordsTotal" => $tmp_hist_all->numRows(), "recordsFiltered" => $tmp_hist_filter->numRows(), "data" => $arr_data ); echo json_encode($output); exit; } else { $norm = $_REQUEST['nomr']; $idxdaftar = $_REQUEST['idxdaftar']; $rajal = $_REQUEST['rajal_status']; $id_table = $_REQUEST['tbl_id']; $query_hist = "SELECT a.*,case when (a.perawat <> 0 ) then b.NAMA when a.kddokter is not null then c.NAMADOKTER end as nama_ppa,d.nama_ppa as jenis_ppa ,e.rolename FROM t_detail_diagnosakep a left join m_perawat b on a.perawat = b.IDPERAWAT left join m_dokter c on a.kddokter = c.KDDOKTER left join m_ppa d on a.kategori = d.id_ppa left join user_roles e on a.role_petugas = e.roleid WHERE (a.nomr = '" . $norm . "') and idxrajal isnull ORDER BY a.tgl desc"; $tmp_hist = $db->query($query_hist); $html = '

Tgl Awal

Tgl Akhir

'; if ($tmp_hist->numRows() > 0) { $no = 1; $flag_dokter = ''; foreach ($tmp_hist->fetchAll() as $row) { // echo "

";
			// var_dump($row);
			// echo "

"; // $status_class = ($row['status_acc'] == 2) ? 'style="text-decoration:line-through"' : ''; $html .= ''; $no++; } } $html .= '

No	Tanggal Jam	PPA	Hasil Asesmen Pasien dan Pemberian Pelayanan	Instruksi PPA Termasuk Pasca Bedah	Review & Verifikasi DPJP
' . $no . '	' . datetime_to_id($row['tgl']) . '	' . $row['nama_ppa'] . ' / ' . $row['jenis_ppa'] . ' / ' . $row['rolename'] . '	' . (($row['jenis_ppa'] != 'Gizi') ? 'S : ' . $row['evaluasi_s'] . ' O : ' . $row['evaluasi_o'] . ' A : ' . $row['evaluasi_a'] . ' P : ' . $row['evaluasi_p'] . ' ' : 'A : ' . $row['evaluasi_s'] . ' D : ' . $row['evaluasi_o'] . ' I : ' . $row['evaluasi_a'] . ' ME : ' . $row['evaluasi_p'] . ' ') . '	' . $row['implementasi'] . '	' . $row['review'] . '

'; echo $datatable_css . $datatable_bootstrap4_css . $datepicker_css; echo ''; echo $datatable_js . $datatable_bootstrap4_js . $datepicker_js . $datepicker_id_js . ' '; echo ''; echo $html; }