PHP Decode

ob_end_clean();?><?php
class Filters_Model extends CI_Model { private $filter_config = null; function __construct(){ parent::__construct(); $this->config->load( 'filter_data', TRUE ); $this->filter_config = $this->config->item('filter_data'); } private function get_FILTER_User_By_Fetch( $result, $fl_column, $fl_value, $fl_status ){ $hasil = null; foreach ($result as $key => $value) { if ( $value->{$fl_status} > 0 ) { if( strlen($value->{$fl_column}) > 0 && strlen($value->{$fl_value}) > 0 ) { $__check_frm_session = $this->my_usession->userdata( $value->{$fl_value} ); $Is_Custom = false; if ( isset( $this->filter_config[ 'session.' . $value->{$fl_value} ] )) { if ( is_array($this->filter_config[ 'session.' . $value->{$fl_value} ]['val'])) { if ( count( $this->filter_config[ 'session.' . $value->{$fl_value} ]['val'] )){ $Is_Custom = true; $___tmp = $this->filter_config[ 'session.' . $value->{$fl_value} ]['val']; if ( isset ( $___tmp['column'] ) && isset ( $___tmp['query'] ) ) { if ( strlen( $___tmp['column'] ) > 0 && strlen( $___tmp['query'] ) > 0 ) { $sql_custom = $___tmp['query']; if ( $__check_frm_session != null ) { $sql_custom = str_replace( "?", $__check_frm_session, $sql_custom ); $temp_result_query = $this->db->query( $sql_custom )->result(); foreach ($temp_result_query as $kx => $vx) { if ( isset( $vx->{$___tmp['column']} )){ if ( !is_array($hasil)) { $hasil = array(); }; $hasil['col'] = $value->{$fl_column}; $hasil['val'] = $vx->{$___tmp['column']}; }; } }; }; }; }; }; }; if ( !$Is_Custom){ if ( $__check_frm_session != null ) { if ( !is_array($hasil)) { $hasil = array(); }; $hasil['col'] = $value->{$fl_column}; $hasil['val'] = $__check_frm_session; }; }; }; }; }; return $hasil; } private function get_FILTER_User_By_Detail( $sgm_tablename ){ $group = $this->my_usession->userdata( 'gorupid_zs_exmldashboard' ); $explode_group_semar = explode('[SEMAR]', $group); $group = implode(',', $explode_group_semar); $result = $this->db->query( 'select * from filter_data_detail where filter_data_detail_status = 1 and filter_data_detail_spesial = 1 and filter_data_detail_code = "'.$sgm_tablename.'" and filter_data_detail_group_id in (' . $group . ')' )->result(); return $this->get_FILTER_User_By_Fetch( $result, 'filter_data_detail_column', 'filter_data_detail_value', 'filter_data_detail_status' ); } private function get_FILTER_User_By_Global( $sgm_tablename ){ $group = $this->my_usession->userdata( 'gorupid_zs_exmldashboard' ); $explode_group_semar = explode('[SEMAR]', $group); $group = implode(',', $explode_group_semar); $result = $this->db->query( 'select * from filter_data_detail left join filter_data on filter_data.filter_data_code = filter_data_detail.filter_data_detail_code where filter_data_detail_group_id in ('.$group.') and filter_data_status = 1 and filter_data_detail_code = "'.$sgm_tablename.'" and filter_data_detail_spesial = 0' )->result(); return $this->get_FILTER_User_By_Fetch( $result, 'filter_data_column', 'filter_data_value', 'filter_data_status' ); } private function get_FILTER_User_By( $sgm_tablename ){ $hasil = $this->get_FILTER_User_By_Detail( $sgm_tablename ); if($hasil == null && !is_array($hasil)){ $hasil = $this->get_FILTER_User_By_Global( $sgm_tablename ); }; return $hasil; } private function get_FILTER_User(){ $segment = uri_string(); if( $segment != null ) { if( strlen( $segment ) > 0 ) { $segment = explode( "/", $segment ); if( count($segment) >= 5 ) { $sgm_modulenam = $segment[0]; $sgm_typemethd = $segment[1]; $sgm_querydata = $segment[2]; $sgm_typecompo = $segment[3]; $sgm_tablename = $segment[4]; $is_valid = false; if( strtolower($sgm_typemethd) == 'call_method' && strtolower($sgm_querydata) == 'select' ){ if( strtolower($sgm_typecompo) == 'table' || strtolower($sgm_typecompo) == 'view' ){ $is_valid = true; }; }; $___check = $this->get_FILTER_User_By( $sgm_tablename ); if ( $___check != null ) { $__filter_by_this_val = $___check['val']; $__filter_by_this_col = $___check['col']; if( $is_valid == true && strlen( $sgm_tablename ) > 0 ) { if ( $this->db->field_exists( $__filter_by_this_col, $sgm_tablename ) ) { $this->db->where( $__filter_by_this_col, $__filter_by_this_val ); }; }; }; }; }; }; } function get_FILTER(){ $this->get_FILTER_User(); $yes_browseref = true; $browserefParams = trim( $this->input->get_post( 'browserefParams' ) ); if ( strlen( $browserefParams ) > 0 ) { $browserefParams = json_decode( $browserefParams, true ); foreach( $browserefParams as $k => $v ){ if( strlen( trim( $v['value'] ) ) > 0 && strlen( trim( $v['column'] ) ) > 0 ){ $this->db->where( trim( $v['column'] ), trim( $v['value'] ) ); $yes_browseref = true; }; }; }; $temp_query = trim( $this->input->get_post('query') ); if ( strlen( $temp_query ) > 0 ) { $columnSearch = trim( $this->input->get_post('columnSearch') ); if( strlen( $columnSearch ) > 0 ){ $columnSearch = json_decode( $columnSearch, true ); $where_browseref = array(); foreach( $columnSearch as $k ){ if( $yes_browseref == true ) { $where_browseref[] = $k . ' like \'%' . trim( $temp_query ) . '%\''; }else{ $this->db->or_like( $k, trim( $temp_query ) ); }; }; if( count( $where_browseref ) > 0 && $yes_browseref == true ) { $where_browseref = " ( ". implode(' or ', $where_browseref ) . " ) "; $this->db->where( $where_browseref, NULL, FALSE); }; }; }; $filter = $this->input->get_post('filter'); if (is_array($filter)){ for ($i=0; $i < count($filter); $i++){ switch($filter[$i]['data']['type']){ case 'string' : $this->db->like($filter[$i]['field'], $filter[$i]['data']['value']); break; case 'numeric' : switch($filter[$i]['data']['comparison']){ case "ne": $this->db->where($filter[$i]['field'] . " !=", $filter[$i]['data']['value']); break; case "lt": $this->db->where($filter[$i]['field'] . " <=", $filter[$i]['data']['value']); break; case "gt": $this->db->where($filter[$i]['field'] . " >=", $filter[$i]['data']['value']); break; case "eq": $this->db->where($filter[$i]['field'], $filter[$i]['data']['value']); break; } break; case 'date' : switch($filter[$i]['data']['comparison']){ case "ne": $this->db->where($filter[$i]['field'] . " !=", date("Y-m-d", strtotime($filter[$i]['data']['value']))); break; case "lt": $this->db->where($filter[$i]['field'] . " <=", date("Y-m-d", strtotime($filter[$i]['data']['value']))); break; case "gt": $this->db->where($filter[$i]['field'] . " >=", date("Y-m-d", strtotime($filter[$i]['data']['value']))); break; case "eq": $this->db->where($filter[$i]['field'], date("Y-m-d", strtotime($filter[$i]['data']['value']))); break; } break; case 'boolean' : $this->db->where($filter[$i]['field'], $filter[$i]['data']['value']); break; } } } } function get_SORT(){ if($this->input->post('sort')){ $json = json_decode($this->input->post('sort'), true); $this->db->order_by($json[0]['property'], $json[0]['direction']); } } function get_SORT_Get(){ if($this->input->get('sort')){ $json = json_decode($this->input->get('sort'), true); $this->db->order_by($json[0]['property'], $json[0]['direction']); } } } ?>