$sql.=" JOIN ".$crudTableJoin2." ".$crudTableJoin2." ON ".$crudTableJoin1.".".$crudIdJoin2. "=" .$crudTableJoin2.".".$crudIdJoin2;
 	
 			}
 			if(!empty($crudTableJoin1) && !empty($crudTableJoin2) && !empty($crudTableJoin3)){
 	
 				   $sql.=" JOIN ".$crudTableJoin3." ".$crudTableJoin3." ON ".$crudTableName.".".$crudIdJoin3. "=" .$crudTableJoin3.".".$crudIdJoin3;
 	
 			}*/
 if (!empty($Filter) && $postConfig['search'] == 'false') {
     $sql .= " WHERE  " . $Filter . " = '" . $NilaiFilter . "' ";
 }
 if (!empty($Filter) && $postConfig['search'] == 'true') {
     $sql .= " WHERE " . $Filter . " = '" . $NilaiFilter . "' AND UPPER(" . $postConfig['searchField'] . ") " . fnSearchCondition($_POST['searchOper'], $postConfig['searchStr']);
 }
 if (empty($Filter) && $postConfig['search'] == 'true') {
     $sql .= " WHERE UPPER(" . $postConfig['searchField'] . ") " . fnSearchCondition($_POST['searchOper'], $postConfig['searchStr']);
 }
 //if(!empty($crudTableJoin1)){
 $sql .= ' ORDER BY ' . $crudTableName . '.' . $postConfig['id'] . ' ' . $postConfig['sortOrder'];
 //}else{
 //	$sql .= ' ORDER BY '.$postConfig['id'].' ' . $postConfig['sortOrder'];
 //}
 //echo $sql;
 //if($postConfig['search'] == true){ $sql .= ' where '.$searchCondition; }
 if ($DEBUGMODE == 1) {
     $firephp->info($sql, 'query');
 }
 $result = gcms_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
 /*Create the output object*/
 $o->page = $intPage;
 $o->total = $total_pages;

            //$sql = 'select FIRST '.$intLimit.' SKIP '.$intStart.' '.implode(',',$crudColumns).' from '.$crudTableName;
            $sql = 'SELECT 
				  PENDAFTARAN.PENDAFTARAN_ID as id,
				  PENDAFTARAN.NO_PENDAFTARAN,
				  PENDAFTARAN.TANGGAL_KARTU,
				  BADAN_USAHA.NAMA,
				  PENDAFTARAN.JENIS_PENDAFTARAN,
				  PENDAFTARAN.NPWP
				FROM
				  PENDAFTARAN
				  INNER JOIN BADAN_USAHA ON (BADAN_USAHA.ID = PENDAFTARAN.ID_PEMOHON)
				WHERE PENDAFTARAN.OBJEK_PDRD=\'BU\'		
				';
        }
        if ($postConfig['search'] == 'true') {
            $sql .= ' and UPPER(' . $postConfig['searchField'] . ') ' . fnSearchCondition($_POST['searchOper'], $postConfig['searchStr']);
        }
        $sql .= ' ORDER BY ' . $postConfig['sortColumn'] . ' ' . $postConfig['sortOrder'];
        //if($postConfig['search'] == true){ $sql .= ' where '.$searchCondition; }
        if ($DEBUGMODE == 1) {
            $firephp->info($sql, 'query');
        }
        $result = gcms_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
        /*Create the output object*/
        $o->page = $intPage;
        $o->total = $total_pages;
        $o->records = $count;
        $i = 0;
        while ($row = gcms_fetch_row($result)) {
            /* 1st column needs to be the id, even if it's not named ID */
            $o->rows[$i]['id'] = $row[0];

     $total_pages = ceil($count / $intLimit);
 } else {
     $total_pages = 1;
 }
 if ($DEBUGMODE == 1) {
     $firephp->info($total_pages, 'total_pages');
 }
 $intPage = $postConfig['page'];
 if ($intPage > $total_pages) {
     $intPage = $total_pages;
 }
 $intStart = ($intPage - 1) * $intLimit;
 /*Run the data query*/
 $sql = 'select ' . implode(',', $crudColumns) . ' from ' . $crudTableName;
 if ($postConfig['search'] == 'true') {
     $sql .= ' WHERE ' . $postConfig['searchField'] . ' ' . fnSearchCondition($_POST['searchOper'], $postConfig['searchStr']);
 }
 $sql .= ' ORDER BY ' . $postConfig['sortColumn'] . ' ' . $postConfig['sortOrder'];
 $sql .= ' LIMIT ' . $intStart . ',' . $intLimit;
 //if($postConfig['search'] == true){ $sql .= ' where '.$searchCondition; }
 if ($DEBUGMODE == 1) {
     $firephp->info($sql, 'query');
 }
 $result = mysql_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
 /*Create the output object*/
 $o->page = $intPage;
 $o->total = $total_pages;
 $o->records = $count;
 $i = 0;
 while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
     /* 1st column needs to be the id, even if it's not named ID */