[eluser]dblackherod[/eluser]
public function getArrayData($table, $afield) {
$limit = $this->CI->input->get_post('rows');
$limitstart = $this->CI->input->get_post('limitstart');
$filter = $this->CI->input->get_post('searchField');
$filtertext = $this->CI->input->get_post('searchString');
$oper = $this->CI->input->get_post('searchOper');
$sortby = $this->CI->input->get_post('sidx');
$sortdir = $this->CI->input->get_post('sord');
$page = $this->CI->input->get_post('page');
$fields2 = array();
$response = array();
$this->CI->db->select($afield);
$this->CI->db->from($table);
/*if( false == empty($filter) ) {
switch ($oper) {
case 'cn':
$this->CI->db->like( $table .'.' . $filter, $filtertext );
break;
case 'eq':
$this->CI->db->where( $table .'.' . $filter , $filtertext );
break;
case 'ge':
$this->CI->db->where( "$table .{$filter} >=", $filtertext );
break;
case 'le':
$this->CI->db->where( "$table .{$filter} <=", $filtertext );
break;
default:
$this->CI->db->like( $table .'.' . $filter, $filtertext );
break;
}
}*/
$total = $this->CI->db->get();
$count = $total->num_rows;
if( $count >0 ) {
$total_pages = ceil($count/$limit);
} else { $total_pages = 0; }
$response['records'] = $count;
$response['total'] = $total_pages;
$response['page'] = $page;
if ($page > $total_pages){
$page=$total_pages;
}
$limitstart = $limit*$page - $limit; // do not put $limit*($page - 1)
$limitstart = ($limitstart < 0)?0:$limitstart;
/*if( false == empty($filter) ) {
switch ($oper) {
case 'cn':
$this->CI->db->like( $table .'.' . $filter, $filtertext );
break;
case 'eq':
$this->CI->db->where( $table .'.' . $filter , $filtertext );
break;
case 'ge':
$this->CI->db->where( "$table .{$filter} >=", $filtertext );
break;
case 'le':
$this->CI->db->where( "$table .{$filter} <=", $filtertext );
break;
default:
$this->CI->db->like( $table .'.' . $filter, $filtertext );
break;
}
}*/
/*if( empty($sortdir) ) {
$sortdir = 'asc';
}
if( !empty($sortby) ) {
$this->CI->db->order_by( $sortby, $sortdir );
}
if( !isset($limitstart) || $limitstart == '' ) {
$limitstart = 0;
}
if( isset($limitstart) && !empty($limit) ) {
$this->CI->db->limit( $limit, $limitstart );
}
if(false == empty($joinmodel)){
if(is_array($joinmodel)){
foreach($joinmodel as $model){
if(isset($model['table']) && isset($model['join'])){
$this->CI->db->join($model['table']/*tablename*, /*$model['join']/*join fields*, /*(isset($model['type']))?$model['type']:'inner'/*join type*);
/*if(isset($model['fields']) && false == empty($model['fields']) && $prefix){
foreach($model['fields'] as $field){
$fields2[] = "{$model['table']}.{$field} AS {$model['table']}_{$field}";
}
}else{
if(isset($model['fields']) && false == empty($model['fields'])){
foreach($model['fields'] as $field){
$fields2[] = "{$model['table']}.{$field}";
}
}
}
}
}
}
if(empty($fields) && $prefix){
$fieldstable = $this->CI->db->list_fields($table);
foreach($fieldstable as $field){
//$fields = array_push((array)$fields, (array)"{$field} AS {$table}_{$field}" );
$fields[] = "{$table}.{$field} AS {$table}_{$field}";
}
}else{
if(empty($fields)){
$fieldstable = $this->CI->db->list_fields($table);
foreach($fieldstable as $field){
//$fields = array_push((array)$fields, (array)"{$field} AS {$table}_{$field}" );
$fields[] = "{$table}.{$field}";
}
}
}
$fields = array_merge($fields, $fields2);
$this->CI->db->select($fields);
$this->CI->db->from($table);
$rs = $this->CI->db->get()->result_array();
}else{
$rs = $this->CI->db->get()->result_array();
}*/
//echo $this->CI->db->last_query();
$this->CI->db->select($afield);
$this->CI->db->from($table);
$rs = $this->CI->db->get()->result_array();
$queryString = $this->CI->db->last_query();
$querydata = array( 'dtgQuery' => $this->CI->db->last_query(), );
$this->CI->session->set_userdata($querydata);
$
