public function postList() { $search = array(); $is_search = false; if (Input::get('sSearch', TRUE) != "") { $is_search = true; foreach ($this->col as $key) { if (isset($key['boolean']) and $key['unsearchable'] == false) { if (strtolower(Input::get('sSearch', TRUE)) == 'yes') { $search[$key['name']] = 1; } else { if (strtolower(Input::get('sSearch', TRUE)) == 'no') { $search[$key['name']] = 0; } } } else { if ($key['unsearchable'] == false) { $search[$key['name']] = Input::get('sSearch', TRUE); } } if ($key['type'] == 'ENTITY_DECODE') { $search[$key['name']] = htmlentities(Input::get('sSearch', TRUE)); } } } $options = array('iDisplayLength' => Input::get('iDisplayLength', TRUE), 'iDisplayStart' => Input::get('iDisplayStart', TRUE), 'sort_column' => Input::get('iSortCol_0', TRUE), 'sort_direction' => Input::get('sSortDir_0', TRUE), 'columns' => $this->col, 'sSearch' => $search, 'isSearch' => $is_search, 'filter' => Input::get('filter')); $rowset = Promo::getDatatable($options); $aaData = array(); foreach ($rowset['data'] as $row) { array_push($aaData, $row); } $cleanSet = json_decode(json_encode($aaData)); $aaData = array(); foreach ($cleanSet as $clean) { $cleanArr = get_object_vars($clean); $arr = array(); foreach ($cleanArr as $data) { array_push($arr, $data); } array_push($arr, ""); //to enable 1 extra column for Actions array_push($aaData, $arr); } $iTotalRecords = $rowset['total_data']; $iTotalDisplayRecords = $rowset['total_data']; $result = array("aaData" => $aaData, "iTotalRecords" => $iTotalRecords, "iTotalDisplayRecords" => $iTotalDisplayRecords); echo json_encode($result); }