protected static function _execute($query, $parameters = array(), $connection_name = self::DEFAULT_CONNECTION) {
            $statement = self::get_db($connection_name)->prepare($query);
            self::$_last_statement = $statement;
            $time = microtime(true);
 
            foreach ($parameters as $key => &$param) {
                if (is_null($param)) {
                    $type = PDO::PARAM_NULL;
                } else if (is_bool($param)) {
                    $type = PDO::PARAM_BOOL;
                } else if (is_int($param)) {
                    $type = PDO::PARAM_INT;
                } else {
                    $type = PDO::PARAM_STR;
                }
 
                $statement->bindParam(is_int($key) ? ++$key : $key, $param, $type);
            }
 
            $q = $statement->execute();
            self::_log_query($query, $parameters, $connection_name, (microtime(true)-$time));
 
            return $q;
        }
 
        /**
         * Add a query to the internal query log. Only works if the
         * 'logging' config option is set to true.
         *
         * This works by manually binding the parameters to the query - the
         * query isn't executed like this (PDO normally passes the query and
         * parameters to the database which takes care of the binding) but
         * doing it this way makes the logged queries more readable.
         * @param string $query
         * @param array $parameters An array of parameters to be bound in to the query
         * @param string $connection_name Which connection to use
         * @param float $query_time Query time
         * @return bool
         */
        protected static function _log_query($query, $parameters, $connection_name, $query_time) {

 
        /**
         * Execute the SELECT query that has been built up by chaining methods
         * on this class. Return an array of rows as associative arrays.
         */
        protected function _run() {
            $query = $this->_build_select();
            $caching_enabled = self::$_config[$this->_connection_name]['caching'];
 
            if ($caching_enabled) {
                $cache_key = self::_create_cache_key($query, $this->_values, $this->_table_name, $this->_connection_name);
                $cached_result = self::_check_query_cache($cache_key, $this->_table_name, $this->_connection_name);
 
                if ($cached_result !== false) {
                    $this->_reset_idiorm_state();
                    return $cached_result;
                }
            }
 
            self::_execute($query, $this->_values, $this->_connection_name);
            $statement = self::get_last_statement();
 
            $rows = array();
            while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
                $rows[] = $row;
            }
 
            if ($caching_enabled) {
                self::_cache_query_result($cache_key, $rows, $this->_table_name, $this->_connection_name);
            }
 
            $this->_reset_idiorm_state();
            return $rows;
        }
 
        /**
         * Reset the Idiorm instance state
         */
        private function _reset_idiorm_state() {
            $this->_values = array();

        }
 
        /**
         * Tell the ORM that you are expecting multiple results
         * from your query, and execute it. Will return a result set object
         * containing instances of the ORM class.
         * @return \IdiormResultSet
         */
        public function find_result_set() {
            return new IdiormResultSet($this->_find_many());
        }
 
        /**
         * Tell the ORM that you are expecting multiple results
         * from your query, and execute it. Will return an array,
         * or an empty array if no rows were returned.
         * @return array
         */
        public function find_array() {
            return $this->_run(); 
        }
 
        /**
         * Tell the ORM that you wish to execute a COUNT query.
         * Will return an integer representing the number of
         * rows returned.
         */
        public function count($column = '*') {
            return $this->_call_aggregate_db_function(__FUNCTION__, $column);
        }
 
        /**
         * Tell the ORM that you wish to execute a MAX query.
         * Will return the max value of the choosen column.
         */
        public function max($column)  {
            return $this->_call_aggregate_db_function(__FUNCTION__, $column);
        }
 
        /**

                                        'color6' =>$merek.'_color6',
                                         'small6' =>$merek.'_small6',
                                         'big6' =>$merek.'_big6',
                                        'color7' =>$merek.'_color7',
                                         'small7' =>$merek.'_small7',
                                         'big7' =>$merek.'_big7',
                                         'type_id',
                                         'rotate',
                                        'ukuran_id',
                                        'cjfi_ukuran.ukuran_text',
                                         'cjfi_ukuran.ukuran_w',
                                         'cjfi_ukuran.ukuran_h',
                                         'cjfi_ukuran.ukuran_type',
                                        'motif_id'
                                     ])
                             ->where($this->where_build($param))
                             ->join('cjfi_ukuran',
                                 [$this->table.'.ukuran_id', '=', 'cjfi_ukuran.id']
                             )
                             ->find_array();
    }
    protected function where_build(array $val)
    {
        unset($val['brands']);
        if(isset($val['prod_id']))
        {
            $val[$this->table.'.id'] = $val['prod_id'];
            unset($val['prod_id']);
        }
        return $val;
    }
}

$pagename = "koleksi-merek-detail.php";
$pagetitle = "Koleksi Merek Detail";

/* Variabel */
$prod_id = isset($_GET['prod_id'])?$_GET['prod_id']:null;
$brands = isset($_GET['brands'])?$_GET['brands']:null;
$type = isset($_GET['type'])?$_GET['type']:null;
$size = isset($_GET['size'])?$_GET['size']:null;
$theme = isset($_GET['theme'])?$_GET['theme']:null;
$language = isset($language)?$language:'en';

include "includes/header.php";

// bikin objek query list keramik 
$param = HelperClass::get_param(); // ambil base url
$url = HelperClass::get_url(); // ambil parameter nya
// dump($param,$url);
$obj = new KoleksiMerekDetailModel();
$data = $obj->get_list_detail($url,$param)[0];

$view_detail = $obj->view_detail(compact('data'));

?>


<div id="main">
  <div id="koleksi" class="row-fluid">
    <div class="span3 sidebar">
      <?php include "includes/product-sidebar.php"; ?>
    </div>
    <div class="span9 content">
        <?= $view_detail ?>
    </div>
  </div>
</div>

<?php
include "includes/footer.php";
?>