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(); }