db_host=$hostname; $obj_parentchild->db_user=$username; $obj_parentchild->db_pass=$password; $obj_parentchild->db_database=$database; if(!$obj_parentchild->db_connect()) { echo "
Sorry! Could not connect to the database server.
"; exit(); } $obj_parentchild->db_table="mk_arus_kas"; $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['tahun'])) $tahun=$_POST['tahun']; else $tahun=date('Y'); $root_item_id='-99'; $all_childs=$obj_parentchild->getAllChilds($root_item_id); ?>
Tahun
Nama Akun
Tahun
Aksi
getAllFields(); foreach($all_childs as $item) { $nilai=0; if ($item['slave'] == '1' ) { $strSQL="SELECT * FROM tk_arus_kas where tahun='$tahun' and id='$item[Id]'"; $resQuery = $db->query($strSQL); foreach($resQuery, MYSQL_ASSOC->fetchAll() as $row) { $nilai=$row["nilai"]; } } ?>
">
">
" style="display:none;" />
db_disconnect(); ?>
