public function getDetail($id)
{
$customer = array('cid', 'esid', 'name', 'broker_code');
$broker_new = array('sid', 'company_name', 'broker_name','phone_number');
$select = $this->select()
->setIntegrityCheck(false)
->from(array('c' => 'customer'),$customer);
$select->join(array('b' => 'broker_new'), 'b.broker_code=c.broker_code', $broker_new);
$select->where('c.cid =?',$id);
$row = $this->fetchRow($select);
if($row){
return $row;
}else{
return false;
}
}