public function getFilteredBrokerCustomers($search_text) {
$broker_customers = array('cid', 'esid', 'name', 'broker_code');
$broker_new = array('company_name');
$select = $this->select()
->setIntegrityCheck(false)
->from(array('b_c' => 'broker_customer'), $broker_customers);
$select->join(array('b' => 'broker_new'), 'b_c.broker_code=b.broker_code', $broker_new);
$select->where('b_c.name LIKE ?', $search_text);
$select->where('b_c.status = ?', 1);
$select->where('b_c.renewal = ?', 1);
return $this->fetchAll($select);
}
