/** * 获得经纪人填的有效求购信息 * @param $p_intBrokerID * @param $p_bolStrictFreshCache */ public static function getProNeedList($p_intBrokerID, $LimitNum, $p_bolStrictFreshCache = true) { $objORM = new ORM_UserORM('ajk_proneed'); $strWhere = 'BrokerId = ? and Status = 1 limit ' . $LimitNum; $arrParams = array($p_intBrokerID); return $objORM->getList($strWhere, $arrParams, $p_bolStrictFreshCache); }
static function getBrokerHonesty($p_intBrokerID, $limits, $search_str = '') { $objORM = new ORM_UserORM('ajk_honesty_index_log'); $strWhere = 'broker_id = ? ' . $search_str . ' order by log_time desc ' . $limits; $arrParams = array($p_intBrokerID); return $objORM->getList($strWhere, $arrParams); }
public static function getOneDataByBrokerId($brokerId) { $objORM = new ORM_UserORM('broker_profile_photo'); $arrGroup = $objORM->getList('BROKERID=?', array($brokerId)); if (!empty($arrGroup)) { return $arrGroup[0]; } else { return NULL; } }
/** * 根据经纪人id获取经纪人最后兑换的数据 * @param int $p_intBrokerID * @param int $Num */ public static function getGradeExchangesByBrokerID($p_intBrokerID, $Num, $p_bolStrictFreshCache = false) { if (!is_numeric($Num) || $Num < 1) { $Num = 1; } $objORM = new ORM_UserORM('ajk_grade_exchanges'); $strWhere = 'BrokerID = ? and (ExchangesType = 1 or ExchangesType = 2) order by CreateTime desc limit ' . $Num; $arrParams = array($p_intBrokerID); return $objORM->getList($strWhere, $arrParams, $p_bolStrictFreshCache); }
/** * 获取一条帖子的分享记录 * @param $p_intFuid,$p_intTid * @return array */ public static function getOneMySharedThreads($p_intFuid, $p_intTid) { $tmp1 = array('ID' => "", 'INSHARED' => "", 'POSTTIME' => "", 'FUID' => "", 'TID' => "", 'DSTATUS' => 1); $tmp = array(); $tmp[0] = $tmp1; $objORM = new ORM_UserORM('cdb_sharethreads'); //$objORM = new ORM_ForumORM('cdb_sharethreads'); $arrMyThr = $objORM->getList("Fuid=? and Tid=? and dstatus=1 order by PostTime desc limit 1 ", array($p_intFuid, $p_intTid), true); return empty($arrMyThr) ? $tmp : $arrMyThr; }
/** * 获得经济人的省市信息 */ public static function getBrokerFrom($condition, $params, $refresh = false) { $orm = new ORM_UserORM('broker_profile'); $result = $orm->getList($condition, $params, $refresh); return $result[0]; }
/** * 获取指定$Id绑定的经济人信息 */ public static function getWeiboUserInfoById($condition, $params, $refresh = false) { $orm = new ORM_UserORM('ajk_property_sns'); return $orm->getList($condition, $params, $refresh); }
/** * 根据公共委托房源列表 * @param int $p_intBrokerID,$p_intActivityID * @return array/NULL * */ static function getPublicCommissionList($condition, $params, $refresh = false) { $objORM = new ORM_UserORM('commission_property'); $result = $objORM->getList($condition, $params, $refresh); return $result; }
/** * 查询经纪人受到申请列表 * @param $p_OpenOrdeBrokerId * @param $p_bolStrictFreshCache * caoyang 2011.11.8 */ public static function getOpenOrderRequestList($p_OpenOrdeBrokerId, $Page, $PageSize, $p_bolStrictFreshCache = false) { $objORM = new ORM_UserORM('ajk_openorder_request'); if (!is_numeric($PageSize) || $PageSize < 1) { $PageSize = 10; } if (!is_numeric($Page) || $Page < 1) { $Page = 1; } $start = ($Page - 1) * $PageSize; //查询数据开始位置 $strWhere = 'OpenOrdeBrokerId=? and Status <> 2 and IsDel = 0 order by Status limit ' . $start . ',' . $PageSize; return $objORM->getList($strWhere, array($p_OpenOrdeBrokerId), $p_bolStrictFreshCache); }
/** * 获取勋章 */ static function getMedalByBrokerid($brokerid) { $objORM = new ORM_UserORM("broker_medal_relation"); $result = $objORM->getList("BROKER_ID=? AND STATE=? AND USER_DEFINED=? AND DELETE_FLAG=? ORDER BY ID ASC limit 3", array($brokerid, 1, 1, 0)); if (!empty($result)) { return $result; } else { return null; } }