query("SELECT *,(select nilai from m_tarifdetil where komponen like '%SARANA%' and kode_tarif = m_tarif_rs.kode_tarif) as jasa_sarana, (select nilai from m_tarifdetil where komponen like '%LAYANAN%' and kode_tarif = m_tarif_rs.kode_tarif) as jasa_pelayanan,pengguna from m_tarif_rs join m_tarifpengguna on m_tarif_rs.kode_tarif = m_tarifpengguna.kode_tarif join m_tarifkelas on m_tarif_rs.kelas_tarif = m_tarifkelas.kelas where kelompok_tarif in('PERAWATAN') and m_tarif_rs.aktif = 1");
if($m_tarif_akomodasi->numRows() > 0)
{
$arr_tarif = array();
$js_tarif_data = array();
foreach($m_tarif_akomodasi->fetchAll() as $ds) {
$arr_tarif[$ds['kode_tarif']] = $ds['uraian_tarif'].' - '.$ds['kelas'].' - '.$ds['pengguna'].'(Rp. '.format_uang($ds['jumlah']).')';
$js_tarif_data[$ds['kode_tarif']] = $ds['jumlah'];
}
}
?>