phpwind 房产 数据来源经纪人数据 增加个人中介公司调用分类

phpwind 房产 数据来源经纪人数据 增加个人中介公司调用分类  如图下所示  台州住房网

个人调用继承原来功能不变。

增加中介公司类别功能如下

所有调用字段

agencyid#4
name#路桥名益房产中介事务所
address#路桥名益房产中介事务所
icon#agency/625edbec7e.png
bgimg#
mainbusiness#1
adminname#admin   -------------管理者
isopen#1
vieworder#0
phone#[phone]   
tel#[phone]         ------------phone 和tel 值相同都是调用管理者的联系方式
url#index.php?m=house&q=agency&agencyid=4
title#路桥名益房产中介事务所
image#/attachment/agency/625edbec7e.png   icon 图片地址

以上调用条件

isopen =1 

排序为 vieworder 升序

修改文件

house/lib/db/house_agencydb.class.php

step1

添加变量

第5行

var $_secondpostTableName = "pw_house_broker";

第26行 添加方法

/** *  * 中介公司自定义查询 */function findAll_li($condition,$page, $perpage, $order){$condition = $this->_checkAllowField($condition, $this->getStruct());$_sql = 'SELECT ha.*,hb.phone,hb.tel FROM '.$this->_tableName.' ha left join '.$this->_secondpostTableName.' hb on hb.username=ha.adminname ';$_sql.= $this->getStrSql($condition);$order && $_sql.= " ORDER BY " . $order;$page = intval($page);$perpage = intval($perpage);$page <= 0 && $page=1;$_sql.= S::sqlLimit(($page-1)*$perpage, $perpage);$query = $this->_db->query($_sql);$result = array();while ($rt = $this->_db->fetch_array($query)) {$result[] =$rt;}return $result;}

文件2

house/lib/service/houseagencyservice.class.php

line33添加新方法

/** * 搜索中介公司 * @param array $param搜索条件 * @param int $page页面 * @param int $perPage每页显示数 * @return array */function findAgencys($condition = array(), $page=1, $perpage=20, $order="vieworder"){$page = (int) $page;$page < 1 && $page = 1;$con = $this->_cookData($condition);$result = $this->agencydb->findAll_li($con,intval($page), intval($perpage), $order);foreach ($result as $key => $value) {$result[$key] = $value;}$count = $this->agencydb->count($con);return array($result,$count);}

文件三

house/lib/source/brokersource.class.php

查找 getSourceData 方法 修改为如下

/** * 获取提交的数据 * @param array $config * @param int $num * @return array $result */function getSourceData($config, $num) {$config = $this->_initConfig($config);if($config['sorttype']=='broker'){$_tmp = $this->_getData($config, $num);$_tmp = $_tmp ? $_tmp : array();$_userids = array();foreach ($_tmp as $key => $value) {$_tmp[$key] = $this->_cookData($value);$_userids[$key] = $value['uid'];}$_info = $this->_getFacesAndOnline($_userids);foreach ($_tmp as $key => $value) {$value && $_info[$value['uid']] && $result[] = array_merge($value, $_info[$value['uid']]);}}else{$result = $this->_getData($config, $num,$config['sorttype']);$result = $result ? $result : array();$_userids = array();foreach ($result as $key => $value) {$result[$key] = $this->_cookAgencyidData($value);}}return $result;}

查找getSourceConfig 方法 修改为如下

/** * 选择项 * @return array */function getSourceConfig() {return array('sort' => array('name' => '排序方式','type' => 'select','value' => array('salenum' => '出售房数量','hirenum' => '出租房数量','lastsaletime' => '最近发布','createtime' => '开通时间')),'sorttype' => array('name' => '中介类型','type' => 'select','value' => array('broker' => '个人','agency' => '中介公司')),);}

查找一下方法修改为如下

/** * 处理传入的数据 * @param array $config * @return array $temp */function _initConfig($config) {$temp = array();$temp['sort'] = $config['sort'];$temp['sorttype'] = isset($config['sorttype']) ? $config['sorttype'] : '';return $temp;}

查找一下方法修改为如下

/** * 查找符合条件的数据 * @param array $config * @param int $num * @return array */function _getData($config, $num,$type='broker') {$brokerService = $this->_getBrokerService();$AgencyService = $this->_getAgencyService();switch ($type) {case 'broker':$result = $brokerService->findBrokers(array('ifactive'=>1), 1, $num, $config['sort']);return $result[0];case 'agency':$result = $AgencyService->findAgencys(array('isopen'=>1), 1, $num,"vieworder");return $result[0];default:return array();}}

添加新方法

/** * 处理数据  * @param unknown_type $data 数据库取得的数据 * @return unknown_type $data 处理后的数据 */function _cookAgencyidData($data) {if (!S::isArray($data) || empty($data['agencyid'])) return $data;$data['url'] = 'index.php?m=house&q=agency&agencyid=' . $data['agencyid'];$data['title'] = $data['name'];$data['tel'] = $data['phone'] ? $data['phone'] : $data['tel'];$data['phone'] = $data['phone'] ? $data['phone'] : $data['tel'];$data['image'] = '/attachment/'. $data['icon'];$_tes='';foreach ($data as $key => $value) {$_tes .= $key .'#'.$value.'@';}$data['test4'] = $_tes . 'test4';return $data;}

添加新方法

/** * 载入中介公司服务类 */function _getAgencyService() {return House::loadService('HouseAgencyService');}

到此修改完成。然后到房产也修改数据来源 测试成功。