class AdminDetailPengajuansController extends \crocodicstudio\crudbooster\controllers\CBController {

public function __construct() {
$this->table = "detail_pengajuans";
$this->primary_key = "id";
$this->title_field = "id";
$this->limit = 20;
$this->index_orderby = ["id"=>"desc"];
$this->button_show_data = true;
$this->button_new_data = true;
$this->button_delete_data = true;
$this->button_sort_filter = true;
$this->button_export_data = true;
$this->button_table_action = true;
$this->button_import_data = true;

$this->col = array();
#this->col[] = array("label"=>"Pengajuans","name"=>"id_pengajuans","join"=>"pengajuans,id");
#$this->col[] = array("label"=>"Pengajuans","name"=>"jenis","join"=>"list_jenis,jenis_pengeluaran");
$this->col[] = array("label"=>"Status","name"=>"status" );
$this->col[] = array("label"=>"Tujuan","name"=>"tujuan" );
$this->col[] = array("label"=>"Jumlah","name"=>"jumlah" );

$this->form = array();
$this->form[] = array("label"=>"Pengajuans","name"=>"id_pengajuans","type"=>"hidden","required"=>TRUE,"validation"=>"required|integer|min:0","datatable"=>"pengajuans,id");
// $this->form[] = array("label"=>"Jenis","name"=>"jenis","type"=>"text","required"=>TRUE,"validation"=>"required|min:3|max:255");
$this->form[] = array("label"=>"Pengajuans","name"=>"jenis","type"=>"select","required"=>TRUE,"validation"=>"required|integer|min:0","datatable"=>"list_jenis,jenis_pengeluaran");
$this->form[] = array("label"=>"Status","name"=>"status","type"=>"radio","required"=>TRUE,"validation"=>"required|min:3|max:255","dataenum"=>array('terbayar','belum'));
$this->form[] = array("label"=>"Deskripsi Pengeluaran","name"=>"tujuan","type"=>"textarea","required"=>TRUE,"validation"=>"required|string|min:5|max:5000");
$this->form[] = array("label"=>"Jumlah","name"=>"jumlah","type"=>"number","required"=>TRUE,"validation"=>"required|integer|min:0");



/*
| ----------------------------------------------------------------------
| Hook for manipulate query of index result
| ----------------------------------------------------------------------
| @query = current database query
|
*/
public function hook_query_index(&$query) {
//Your code here
$query->where('detail_pengajuans.status','belum');
$query->where('detail_pengajuans.id_pengajuans', '7')->sum('jumlah');
}