public function getHasRankExam($BrokerId)
{
$objORM = new ORM_AnjukeORM('ajk_question_broker');
$strWhere = 'BrokerId = ? and rankexam = 1';
$arrParams = array($BrokerId);
return $objORM->getList($strWhere, $arrParams, true);
}
public function getCommMapCorrectTrackList($userid, $opentime, $start, $limit)
{
apf_require_class("ORM_AnjukeORM");
$orm = new ORM_AnjukeORM('log_modify_commmap');
$rst = $orm->getList('UserId=? and PostTime > ? order by PostTime desc limit ' . $start . ',' . $limit, array($userid, $opentime), true);
return empty($rst) ? array() : $rst;
}
public function getAreaCodesByParentId($p_parentId)
{
apf_require_class("ORM_AnjukeORM");
$objORM = new ORM_AnjukeORM('ajk_commtype');
$areaCodesList = $objORM->getList("ParentId = ?", array($p_parentId), true);
return empty($areaCodesList) ? array() : $areaCodesList;
}
/**
* 获取该城市的自定义内容
* @param string $p_strHTMLTag
* @param int $p_intCityID
* @param array
*/
static function getHTMLContent($p_strHTMLTag, $p_intCityID)
{
$objORM = new ORM_AnjukeORM('ajk_html_content');
$arrContent = $objORM->getList('CITYID=? and ID=?', array($p_intCityID, $p_strHTMLTag));
if (1 == count($arrContent)) {
return $arrContent[0];
}
return array();
}
static function getActiveAccountExecutive($p_strWhere, $p_arrParams)
{
$objORM = new ORM_AnjukeORM('ajk_admin_manager');
$arrAccountExecutive = $objORM->getList($p_strWhere, $p_arrParams);
if (!empty($arrAccountExecutive)) {
return $arrAccountExecutive[0];
} else {
return array();
}
}
public static function getShopStyleList()
{
$objORM = new ORM_AnjukeORM('shop_style_list');
$arrGroup = $objORM->getList();
if (!empty($arrGroup)) {
return $arrGroup;
} else {
return NULL;
}
}
public function handle_request_internal()
{
//组织数据
if (!isset($this->_params["num"]) || $this->_params["num"] > 500) {
return '图片数目不合法,1-500';
}
$_objAjkORM = new ORM_AnjukeORM('ajk_communitys');
$comm_list = $_objAjkORM->getList('typeflag=0 limit 0,500', array(), true, true);
//print_r($comm_list);die;
$return_urls = array();
$no = 0;
foreach ($comm_list as $k => $comm) {
$params['commId'] = $comm['COMMID'];
$params['pageNo'] = 1;
$params['pageSize'] = 20;
$params['imgSize'] = '800x600';
$params['rommNum'] = 2;
$params['hallNum'] = 1;
$params['toiletNum'] = 1;
$params['forward'] = '南';
$params['forward'] = urlencode($params['forward']);
//通过java接口获取数据
$api_url = "image/houseModuleImg/" . $params['commId'];
$_params = array();
foreach ($params as $key => $value) {
$_params[] = "{$key}={$value}";
}
$api_url = $api_url . '?' . implode('&', $_params);
$houseImg = Util_CallAPI::get_data_from_java_ga($api_url, '', false);
//print_r($houseImg);die;
if ($houseImg['data']['status'] == 'ok') {
$houseImg = $houseImg['data'];
if (!empty($houseImg['imgs'])) {
foreach ($houseImg['imgs'] as $k => $img) {
if ($no >= $this->_params["num"]) {
break 2;
}
$return_urls[] = $houseImg['imgs'][$k]['url'];
$no++;
// print_r($houseImg['imgs'][$k]['url']) . "\n";
}
} else {
continue;
}
unset($houseImg['status']);
} else {
continue;
}
}
$return = array();
$return["status"] = "ok";
$return['data'] = $return_urls;
return $return;
}
/**
* 获取地铁站点
* @param array $p_arrParam
* @return array
*/
static function getMetroStation($p_arrParam)
{
$strSQL = '';
$arrParam = array();
if (isset($p_arrParam['METROID'])) {
$strSQL .= ' and METRO_ID=?';
$arrParam[] = $p_arrParam['METROID'];
}
if (isset($p_arrParam['STATUS'])) {
$strSQL .= ' and STATUS=?';
$arrParam[] = $p_arrParam['STATUS'];
}
if (isset($strSQL[0])) {
$strSQL = substr($strSQL, 4);
}
$objORM = new ORM_AnjukeORM('map_metro_stations');
return $objORM->getList($strSQL . ' order by DISPLAY_ORDER asc', $arrParam);
}
public static function get_prop_usetype($cityId, $typeId)
{
$_objAjkORM = new ORM_AnjukeORM('ajk_usetype');
$result = current($_objAjkORM->getList('`CityId`=? and TypeId=? and TypeFlag=0 limit 0,1', array($cityId, $typeId), true, true));
return empty($result) ? array() : $result;
}
/**
* 获取公司列表
*/
public static function list_companys($condition, $params, $refresh = false)
{
$orm = new ORM_AnjukeORM('cst_company');
return $orm->getList($condition, $params, $refresh);
}
/**
* 获取无缓存的配置
* @param $p_Flag
* @param $p_intCityid
* @return string
*/
public function getHtmlContentNoCache($p_Flag, $p_intCityid)
{
if (!$p_intCityid) {
$p_intCityid = 11;
}
$objORM = new ORM_AnjukeORM("ajk_html_content");
if (is_array($p_Flag)) {
$strSQL = "CITYID=? and ID in(" . implode(',', array_fill_keys($p_Flag, '?')) . ") ";
$arrParams[] = $p_intCityid;
$arrParams = array_merge($arrParams, $p_Flag);
} else {
$strSQL = "ID=? and CITYID=? limit 1";
$arrParams = array($p_Flag, $p_intCityid);
}
$arrRtn = $objORM->getList($strSQL, $arrParams, true);
return !empty($arrRtn) ? $arrRtn : array();
}
public static function get_citys()
{
$objAjkORM = new ORM_AnjukeORM('ajk_commtype');
return $objAjkORM->getList("`ParentId`=? and `TypeFlag`=?", array(0, 0));
}
/**
* 根据小区ID获取小区信息
* @param $comm_id
* @param $flush_cache
*/
public static function get_community_info_byid($comm_id, $flush_cache = false)
{
$_objAjkORM = new ORM_AnjukeORM('ajk_communitys');
return current($_objAjkORM->getList('`commid`=? and typeflag=0 limit 0,1', array($comm_id), $flush_cache, $flush_cache));
}
public static function chkShop($brokerId)
{
$objORM = new ORM_AnjukeORM('shop_list');
$intCnt = $objORM->getList('BROKERID=?', array($brokerId));
return !empty($intCnt);
}
/**
* 根据条件获得公司列表
* @param string $p_strWhere
* @param array $p_arrParams
* @return array/NULL
*/
static function getCompanyList($p_strWhere, $p_arrParams)
{
$objORM = new ORM_AnjukeORM('cst_company');
return $objORM->getList($p_strWhere, $p_arrParams);
}
/**
* 获得经纪人列表
* @static
* @param string $p_strWhere
* @param array $p_arrParam
* @return array
*/
static function getBrokerList($p_strWhere, $p_arrParam)
{
$objORM = new ORM_AnjukeORM('ajk_brokerextend');
$arrBrokerList = $objORM->getList($p_strWhere, $p_arrParam);
return $arrBrokerList;
}
/**
* 获取好友列表
*/
public static function getFriendsList($condition, $params, $refresh = false)
{
$orm = new ORM_AnjukeORM('friend_list');
return $orm->getList($condition, $params, $refresh);
}
public function getVipWorkNumDao($cityid, $type)
{
$orm = new ORM_AnjukeORM('cst_boss');
$arrFrmMem = $orm->getList("cityid = ? and type=?", array($cityid, $type), true);
return empty($arrFrmMem) ? array() : $arrFrmMem[0];
}
/**
* 获得门店信息
* @param int $intCompanyId
* @return array/NULL
*/
static function getCompanyStore($CityId, $CompanyId, $p_bolStrictFreshCache = false)
{
apf_require_class("ORM_AnjukeORM");
$objORM = new ORM_AnjukeORM('cst_broker_company');
$where = 'CityId=? and cst_company_id=? and IsActive=1 order by SortNum asc';
$arrList = $objORM->getList($where, array($CityId, $CompanyId), $p_bolStrictFreshCache);
return empty($arrList) ? array() : $arrList;
}
static function getArea($Areacode)
{
$objORM = new ORM_AnjukeORM('ajk_commtype');
$strWhere = "TypeCode=?";
$arrParams = array($Areacode);
return $objORM->getList($strWhere, $arrParams);
}
/**
* 根据UserId获得经济人真名
*/
static function getBrokerInfoByBid($condition, $params, $refresh = false)
{
$objORM = new ORM_AnjukeORM('ajk_brokerextend');
$result = $objORM->getList($condition, $params);
return $result[0];
}
/**
* 获取房源信息
* @param int $p_intPropertyID
* @param boolean $p_bolForceMaster
* @param boolean $p_bolSynIDC
* @return array
*/
static function getPropertyDetail($p_intPropertyID, $p_bolStrictRefreshCache = false, $p_bolStrictMaster = false, $p_bolSynIDC = false)
{
$objORM = new ORM_PropertyORM('ajk_propertys', $p_bolStrictMaster);
$objORM->PROID = $p_intPropertyID;
$arrProperty = $objORM->getRow($p_bolStrictRefreshCache, $p_bolSynIDC);
apf_require_class('DAO_Property_sp');
if ($arrProperty['TRADETYPE'] == 1) {
$arrExt = DAO_Property_sp::getPropertySale($p_intPropertyID, $p_bolStrictRefreshCache, $p_bolStrictMaster);
} else {
$arrExt = DAO_Property_sp::getPropertyRent($p_intPropertyID, $p_bolStrictRefreshCache, $p_bolStrictMaster);
}
if (!is_array($arrProperty)) {
$arrProperty = array();
}
if (!is_array($arrExt)) {
$arrExt = array();
}
$objORM = new ORM_AnjukeORM('ajk_app_video', $p_bolStrictMaster);
$arrVideo = $objORM->getList('PROPID=? and STATUS=?', array($p_intPropertyID, 0));
if (!empty($arrProperty)) {
$arrProperty['VIDEO'] = $arrVideo;
}
unset($arrExt['URICODE']);
return array_merge($arrProperty, $arrExt);
}
static function getAccountMappingDao($condition, $params, $p_bolStrictMaster = true, $refresh = false)
{
$objORM = new ORM_AnjukeORM('account_mapping', $p_bolStrictMaster);
$result = $objORM->getList($condition, $params, $refresh);
return $result[0];
}
public function getBrokerEmailDao($userid)
{
$orm = new ORM_AnjukeORM('ajk_members');
$arrFrmMem = $orm->getList("UserId = ?", array($userid), true);
return empty($arrFrmMem) ? array() : $arrFrmMem[0];
}
