Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- else if($act=="list_rest"){
- $aColumns = array('cmp.company_name','cmp.company_initial','cmp.created_date','us_crt.username','cmp.last_update','us_updt.username','cmp.company_id'); //Kolom Pada Tabel
- // Input method (use $_GET, $_POST or $_REQUEST)
- $input =& $_POST;
- $iColumnCount = count($aColumns);
- $sLimit = $gen_controller->Paging($input);
- $sOrder = $gen_controller->Ordering($input, $aColumns );
- $sWhere = $gen_controller->Filtering($aColumns, $iColumnCount, $input);
- $aQueryColumns = array();
- foreach ($aColumns as $col) {
- if ($col != ' ') {
- $aQueryColumns[] = $col;
- }
- }
- $rResult = $md_cmp->getDataCompany($sWhere,$sOrder,$sLimit);
- $rResultFilterTotal = $md_cmp->getCountCompany($sWhere);
- $output = array(
- "sEcho" => (empty($input['sEcho']) ? '0' : intval($input['sEcho'])),
- "iTotalRecords" => $rResultFilterTotal,
- "iTotalDisplayRecords" => $rResultFilterTotal,
- "aaData" => array(),
- );
- while($aRow = $rResult->FetchRow()){
- $param_id = $gen_controller->encrypt($aRow['company_id']);
- $edit = '<button data-toggle="modal" data-target="#edit_company" type="button" onclick="do_edit(\''.$param_id.'\')" class="btn btn-primary btn-xs"><i class="fa fa-pencil m-r-5"></i> Update</button>';
- $delete = ' <button type="button" onclick="do_delete(\''.$param_id.'\')" class="btn btn-danger btn-xs"><i class="fa fa-trash-o m-r-5"></i> Delete</button>';
- $edit_delete = $edit.$delete;
- $row = array();
- $row = array($aRow['company_name'],$aRow['company_initial'],$gen_controller->get_date_indonesia($aRow['created_date'])." ".substr($aRow['created_date'],10,9),$aRow['pembuat'],$gen_controller->get_date_indonesia($aRow['last_update'])." ".substr($aRow['last_update'],10,9),$aRow['perubah'],"<center>".$edit_delete."</center>");
- $output['aaData'][] = $row;
- }
- echo json_encode($output);
- }
Advertisement
Add Comment
Please, Sign In to add comment