public function postIndex()
 {
     $this->fields = array(array('DESCR', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('DB_CODE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('LAST_CHANGE_DATETIME', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)));
     $this->def_order_by = 'LAST_CHANGE_DATETIME';
     $this->def_order_dir = 'ASC';
     $this->place_action = 'none';
     $this->show_select = false;
     $this->sql_key = 'DB_CODE';
     $this->sql_table_name = 'db_defn';
     $this->sql_connection = 'mysql3';
     return parent::postSQLIndex();
 }
 public function postIndex()
 {
     $this->fields = array(array('ACNT_CODE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('DESCR', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('S_HEAD', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('LOOKUP', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'attr' => array('class' => 'expander'), 'show' => true)), array('LONG_DESCR', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'attr' => array('class' => 'expander'), 'show' => true)), array('LAST_CHANGE_DATETIME', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)));
     $this->def_order_by = 'ACNT_CODE';
     $this->def_order_dir = 'ASC';
     $this->place_action = 'none';
     $this->show_select = false;
     $this->sql_key = 'TRANS_DATETIME';
     $this->sql_table_name = 'j10_acnt';
     $this->sql_connection = 'mysql2';
     return parent::postSQLIndex();
 }
 public function postIndex()
 {
     $this->fields = array(array('id', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('merchantname', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('group_id', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('mc_url', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'attr' => array('class' => 'expander'), 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'attr' => array('class' => 'expander'), 'show' => true)), array('phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('street', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('created', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)));
     /*
     $categoryFilter = Input::get('categoryFilter');
     if($categoryFilter != ''){
         $this->additional_query = array('shopcategoryLink'=>$categoryFilter, 'group_id'=>4);
     }
     */
     $this->def_order_by = 'created';
     $this->place_action = 'first';
     return parent::postSQLIndex();
 }