public function handle_request_internal() { $request = APF::get_instance()->get_request(); $params = $request->get_parameters(); $city = $params['city']; $company = $params['company']; $storeName = $params['kw']; $storeName = sprintf('%%%s%%', $storeName); $area_id = $params['areaid']; $block_id = $params['block_id']; $type = $params['type']; if ($block_id == 0) { $areacode = 0; } else { // 根据type 获取areacode. $type = intval($type); $rst = DAO_Common_common::getCommTypeDetail($type); $areacode = @$rst['TYPECODE']; } $storeList = Model_Broker_AjkCstBrokerCompany::getStoreListByKeyword($company, $city, $storeName); $store = array(); $other = array('id' => 0, 'name' => '其他门店', 'AreaId' => 0, 'AreaName' => null, 'BlockId' => 0, 'BlockName' => null); array_push($store, $other); foreach ($storeList as $k => $v) { //$area = DAO_Common_common::getAreaInfo(substr($v['areaCode'], 0, 8)); //$block = DAO_Common_common::getAreaInfo($v['areaCode']); $block = Model_City_TypeCode::getAreaInfo($v['areaCode']); $area = Model_City_TypeCode::getAreaInfoByTypeIdEx($block['parentId']); $swap = array('id' => $v['comanyId'], 'name' => $v['comanyName'], 'AreaId' => $area['typeId'], 'AreaName' => $area['typeName'], 'BlockId' => $block['typeId'], 'BlockName' => $block['typeName']); array_push($store, $swap); } echo json_encode($store); }
/** * 获得门店的客户经理 * @param int $store_id * @return int */ public function get_store_worknum($store_id) { apf_require_class('DAO_Common_common'); $store = DAO_Common_common::getStoreDetail($store_id); return $store['WORKERNUM']; }
/** * 获取公司信息 */ function getAgency($p_intAgcyId, $p_bolUseMaster = false, $p_bolFreshCache = false) { $objORM = new ORM_AgencyORM('agcy_agency', $p_bolUseMaster); $objORM->AGENCYID = $p_intAgcyId; $arrAgency = $objORM->getRow($p_bolFreshCache); if (!empty($arrAgency)) { apf_require_class('DAO_Common_common'); $arrCompany = DAO_Common_common::getCompanyDetail($arrAgency['COMPANYID']); if (!empty($arrCompany)) { $arrAgency['company'] = $arrCompany; } } return $arrAgency; }
/** * modified by wujie @2011-10-27 for pmt3134 * 查询虚假房源 * @param unknown_type $p_arrParams * @param int $p_IsWeeklyView 1-查寻7日内信息,0-查询30日内信息 */ public static function getFalsePropertys($p_arrParams = array(), $p_IsWeeklyView = 0) { apf_require_class('Util_Memcache'); apf_require_class("DAO_Broker_common"); //查询违规经纪人列表(加过滤判断) if (isset($p_arrParams['daydate']) and !empty($p_arrParams['daydate'])) { $intDate = $p_arrParams['daydate']; } else { $intDate = date('Ymd', time() - 86400); } $intCityId = isset($p_arrParams['cityid']) ? (int) $p_arrParams['cityid'] : 11; //判断是否是查询7日数据 if ($p_IsWeeklyView) { $intLastTime = time() - 7 * 86400; $strSQL = "CITYID=? AND DAYDATE=? AND PUNISHTIME>=?"; $arrParams = array($intCityId, $intDate, $intLastTime); } else { $strSQL = "CITYID=? AND DAYDATE=?"; $arrParams = array($intCityId, $intDate); } $strListSQL = $strSQL . ' ORDER BY FALSENUM DESC,PUNISHTIME DESC'; $intPage = isset($p_arrParams['page']) ? (int) $p_arrParams['page'] : 1; $intPageSize = isset($p_arrParams['pagesize']) ? (int) $p_arrParams['pagesize'] : 10; $intStart = ($intPage - 1) * $intPageSize; $strListSQL .= ' limit ' . $intStart . ', ' . $intPageSize; $arrBrokersList = Util_Memcache::memcached('DAO_Property_etc', 'getFalsePropertyStat', array($strListSQL, $arrParams, true), 7200); if (empty($arrBrokersList)) { return array('arrList' => array(), 'intBrokerTotalNum' => 0, 'intFalsePropertyTotalNum' => 0); } $arrProIds = array(); foreach ($arrBrokersList as $arrItem) { $arrProId = json_decode($arrItem['LATESTFALSEPRO'], true); if (!empty($arrProId) && is_array($arrProId)) { $arrProIds = array_merge($arrProIds, $arrProId); } } //获取房源信息(LATESTFALSEPRO中所有房源,无过滤判断) $arrProData = array(); if (!empty($arrProIds)) { $strProSql = "PROID IN (" . join(',', $arrProIds) . ")"; $arrPropertys = DAO_Property_etc::getFalseProperty($strProSql, array()); if (!empty($arrPropertys)) { foreach ($arrPropertys as $arrItem) { $intProId = $arrItem['PROID']; $arrProData[$intProId] = $arrItem; } } } //组织经纪人信息(加过滤判断) $arrBrokerData = array(); foreach ($arrBrokersList as $arrItem) { $arrProId = json_decode($arrItem['LATESTFALSEPRO'], true); //判断是否是查询7日数据 if ($p_IsWeeklyView) { $arrProIdTmp = array(); //过滤出$arrItem['LATESTFALSEPRO']中7日内房源ID $strSql = "CITYID = ? and BROKERID = ? and PUNISHTIME >= ? order by DID asc"; $arrFalseProps = Util_Memcache::memcached('DAO_Property_etc', 'getFalsePropByBrokerID', array($strSql, array($intCityId, $arrItem['BROKERID'], $intLastTime)), 7200); foreach ($arrFalseProps as $id => $arrFalseProp) { if (in_array($arrFalseProp['PROID'], $arrProId)) { array_push($arrProIdTmp, $arrFalseProp['PROID']); } } $arrProId = $arrProIdTmp; } $arrItem['arrPropertys'] = array(); foreach ($arrProId as $intProId) { if (isset($arrProData[$intProId]) && !empty($arrProData[$intProId])) { $arrItem['arrPropertys'][] = $arrProData[$intProId]; } } $arrBrokerInfo = DAO_Broker_common::getBrokerInfo($arrItem['BROKERID']); //区域板块显示优先级:门店 > 注册 > 违规记录 > 空 if ($arrBrokerInfo) { if ($arrBrokerInfo['CST_BROKER_COMPANY_ID']) { $arrStore = DAO_Common_common::getStoreDetail($arrBrokerInfo['CST_BROKER_COMPANY_ID']); $strAreaCode = $arrStore['AREACODE']; } else { $strAreaCode = $arrBrokerInfo['AREACODE']; } if (!$strAreaCode) { $strAreaCode = $arrItem['AREACODE']; } } if (strlen($strAreaCode) > 8) { $arrArea = DAO_Common_common::getAreaInfo(substr($strAreaCode, 0, 8)); $arrBlock = DAO_Common_common::getAreaInfo($strAreaCode); } else { $arrArea = DAO_Common_common::getAreaInfo($strAreaCode); $arrBlock = array(); } $arrItem['AREAINFO'] = isset($arrArea['TYPENAME']) ? $arrArea['TYPENAME'] : ''; $arrItem['BLOCKINFO'] = isset($arrBlock['TYPENAME']) ? $arrBlock['TYPENAME'] : ''; $arrBrokerData[] = $arrItem; } //查询违规经纪人数量 $arrBrokersCnt = Util_Memcache::memcached('DAO_Property_etc', 'getFalsePropertyStatCnt', array($strSQL, $arrParams, true), 7200); //查询违规房源数量 if ($p_IsWeeklyView) { $strSQL = "CITYID = ? and PUNISHTIME >= ?"; $arrFalsePropertyCnt = Util_Memcache::memcached('DAO_Property_etc', 'getFalsePropertysCnt', array($strSQL, array($intCityId, $intLastTime)), 7200); } else { $strSQL = "select sum(falsenum) from false_propertys_stat where cityid=? and daydate=?"; $arrFalsePropertyCnt = Util_Memcache::memcached('DAO_Property_etc', 'getFalsePropertyCnt', array($strSQL, array($intCityId, $intDate)), 7200); } return array('arrList' => $arrBrokerData, 'intBrokerTotalNum' => $arrBrokersCnt, 'intFalsePropertyTotalNum' => $arrFalsePropertyCnt); }