Joins 2 Column concat
Joins 2 Column concat
im using ssp class..joins 2 field on one tabel colum htmk with concat,,but not work
$columns = array(
array( 'db' => 'username', 'dt' => 1 ),
array( 'db' => 'nama', 'dt' => 2 ),
array( 'db' => 'level', 'dt' => 3 ),
array( 'db' => 'blokir_admin', 'dt' => 4, 'formatter' => function( $data, $row ) {
// Status Admin
if($data=='T'){
$status = 'Aktif';
$status = "<center><span class='label-aktif'>$status</span></center>";
}else{
$status = 'Diblokir';
$status = "<center><span class='label-nonaktif'>$status</span><center>";
}
return $status;
}
),
array( 'db' => 'CONCAT(kd_administrator," ",foto_admin)', 'dt' => 5, 'formatter' => function( $data, $row ) {
// Tombol Action
$tombol_action = '
';
return $tombol_action;
}
)
);