Advertisement
Bedhoel

ajax table

May 25th, 2018
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.88 KB | None | 0 0
  1. else if($act=="list_rest"){
  2.   $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
  3.  
  4.     // Input method (use $_GET, $_POST or $_REQUEST)
  5.     $input =& $_POST;
  6.     $iColumnCount = count($aColumns);
  7.  
  8.  
  9.     $sLimit = $gen_controller->Paging($input);
  10.     $sOrder = $gen_controller->Ordering($input, $aColumns );
  11.     $sWhere = $gen_controller->Filtering($aColumns, $iColumnCount, $input);
  12.  
  13.     $aQueryColumns = array();
  14.     foreach ($aColumns as $col) {
  15.         if ($col != ' ') {
  16.             $aQueryColumns[] = $col;
  17.         }
  18.     }
  19.  
  20.     $rResult                = $md_cmp->getDataCompany($sWhere,$sOrder,$sLimit);
  21.     $rResultFilterTotal     = $md_cmp->getCountCompany($sWhere);
  22.  
  23.  
  24.     $output = array(
  25.         "sEcho"                => (empty($input['sEcho']) ? '0' : intval($input['sEcho'])),
  26.         "iTotalRecords"        => $rResultFilterTotal,
  27.         "iTotalDisplayRecords" => $rResultFilterTotal,
  28.         "aaData"               => array(),
  29.     );
  30.  
  31.     while($aRow = $rResult->FetchRow()){
  32.  
  33.         $param_id = $gen_controller->encrypt($aRow['company_id']);
  34.         $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>';
  35.         $delete = '&nbsp; <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>';
  36.  
  37.         $edit_delete = $edit.$delete;
  38.         $row = array();
  39.         $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>");
  40.         $output['aaData'][] = $row;
  41.     }
  42.     echo json_encode($output);
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement