EasyUI Forum

<table id="tgKALAKD" class="easyui-treegrid"	
	data-options="		
		fit:true,
		url:'_modul/mod_kalakd/aksi_kalakd.php?act=listKALAKD',
		rownumbers: true,
		idField: 'kalid',
		treeField: 'nama',
		onBeforeLoad: function(row,param){
			if (!row) {				// load top level rows
				param.id = 0;		// set id=0, indicate to load new page rows
			}
		}
	"
>

$id = isset($_POST['id']) ? intval($_POST['id']) : 0;

$where="pParent=".$id;
$result = array();
if ($id == 0){		
	$qry = "SELECT * FROM uj_akad_kalender WHERE ".$where;
	$res = $conDB->query($qry);
	$result["total"] = $res->num_rows;

	$qry = "SELECT t2.*, (SELECT COUNT(*) FROM uj_akad_kalender AS t1 WHERE t1.pParent = t2.kalid) AS count_parents FROM uj_akad_kalender AS t2 ";
	$qry.= "where ".$where;
	$res = $conDB->query($qry);
	$items = array();
	while($row = $res->fetch_assoc()){
		if($row['count_parents']>0) {
			$row['state']='closed';
		} else {
			$row['state']='open';
		}
		if (!is_null($row[tgl_awal])) { 
		$nyatgl=strtotime($row[tgl_awal]); $row[tgl_awal]=date("d-m-Y",$nyatgl);
		} else { $row[tgl_awal]=""; }
		if (!is_null($row[tgl_akhir])) { 
		$nyatgl=strtotime($row[tgl_akhir]); $row[tgl_akhir]=date("d-m-Y",$nyatgl);
		} else { $row[tgl_akhir]=""; }
		$row['caption']=trim($row['nama']." ".$row['ketambah']);
		array_push($items, $row);
	}
	$result["rows"] = $items;
} else {	
	$qry = "SELECT t2.*, (SELECT COUNT(*) FROM uj_akad_kalender AS t1 WHERE t1.pParent = t2.kalid) AS count_parents FROM uj_akad_kalender AS t2 ";
	$qry.= "where ".$where;
	$res = $conDB->query($qry);
	$items = array();
	while($row = $res->fetch_assoc()){
		if($row['count_parents']>0) {
			$row['state']='closed';
		} else {
			$row['state']='open';
		}
		if (!is_null($row[tgl_awal])) { 
		$nyatgl=strtotime($row[tgl_awal]); $row[tgl_awal]=date("d-m-Y",$nyatgl);
		} else { $row[tgl_awal]=""; }
		if (!is_null($row[tgl_akhir])) { 
		$nyatgl=strtotime($row[tgl_akhir]); $row[tgl_akhir]=date("d-m-Y",$nyatgl);
		} else { $row[tgl_akhir]=""; }
		$row['caption']=trim($row['nama']." ".$row['ketambah']);
		array_push($result, $row);
	}		
}	
echo json_encode($result);