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