";
exit();
}
$obj_parentchild->db_table="mk_realisasi_anggaran";
$obj_parentchild->item_identifier_field_name="Id";
$obj_parentchild->parent_identifier_field_name="parentId";
$obj_parentchild->item_list_field_name="name";
$obj_parentchild->extra_condition=""; //if required
$obj_parentchild->order_by_phrase=" ORDER BY `Id` ";
$obj_parentchild->level_identifier="";
$obj_parentchild->item_pointer="";
if (!empty($_POST['TGLREG']))
$tahun=$_POST['TGLREG'];
else
$tahun=date('Y/m/d');
$root_item_id='-99';
$all_childs=$obj_parentchild->getAllChilds($root_item_id);
?>
Nama Akun
Tahun
Aksi
getAllFields();
$db->query("CALL pr_eksekutif_total_pendapatan_rekap_bb('".$tahun."',1)");
foreach($all_childs as $item) {
$nilai=0;
if ($item['slave'] == '1' ) {
if($item['Id'] == '01.01.08'){
$query = $db->query('SELECT tanggal,SUM(manajemen) AS manajemen, SUM(rj) AS rj, SUM(ugd) AS ugd, SUM(vk) AS vk, SUM(lab) AS lab, SUM(rad) AS rad, SUM(ri) AS ri, SUM(ok) AS ok, SUM(apotek) AS apotek,SUM(gizi) AS gizi,
SUM(vk_ri) AS vk_ri, SUM(lab_ri) AS lab_ri, SUM(rad_ri) AS rad_ri, SUM(apotek_ri) AS apotek_ri,SUM(gizi_ri) AS gizi_ri, carabayar
FROM xxx_rekap_pendapatan_bulanan
where carabayar = 1');
if($query->numRows() > 0){
$data = $query->fetchAll()[0];
$nilai = $data['manajemen']+$data['rj']+$data['ugd']+$data['vk']+$data['lab']+$data['rad']+$data['gizi']+$data['apotek']+$data['ok']+$data['ri']+$data['vk_ri']+$data['lab_ri']+$data['rad_ri']+$data['gizi_ri']+$data['apotek_ri'];
}else{
$nilai = 0;
}
}else if($item['Id'] == '01.01.09'){
$query2 = $db->query('SELECT tanggal,SUM(manajemen) AS manajemen, SUM(rj) AS rj, SUM(ugd) AS ugd, SUM(vk) AS vk, SUM(lab) AS lab, SUM(rad) AS rad, SUM(ri) AS ri, SUM(ok) AS ok, SUM(apotek) AS apotek,SUM(gizi) AS gizi,
SUM(vk_ri) AS vk_ri, SUM(lab_ri) AS lab_ri, SUM(rad_ri) AS rad_ri, SUM(apotek_ri) AS apotek_ri,SUM(gizi_ri) AS gizi_ri, carabayar
FROM xxx_rekap_pendapatan_bulanan
where carabayar > 1');
if($query2->numRows() > 0){
$data = $query2->fetchAll()[0];
$nilai = $data['manajemen']+$data['rj']+$data['ugd']+$data['vk']+$data['lab']+$data['rad']+$data['gizi']+$data['apotek']+$data['ok']+$data['ri']+$data['vk_ri']+$data['lab_ri']+$data['rad_ri']+$data['gizi_ri']+$data['apotek_ri'];
}else{
$nilai = 1;
}
}else{
$strSQL="SELECT * FROM tk_realisasi_anggaran where tahun='$tahun' and id='$item[Id]'";
$resQuery = $db->query($strSQL);
foreach($resQuery->fetchAll() as $row) {
$nilai=$row["nilai"];
}
}
}
?>
