$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 */
