static function getBrokerHonestyCount($p_intBrokerID, $search_str = '')
{
$objORM = new ORM_UserORM('ajk_honesty_index_log');
$strWhere = 'broker_id = ? ' . $search_str . ' order by log_time asc ';
$arrParams = array($p_intBrokerID);
return $objORM->getCnt($strWhere, $arrParams);
}
public static function getDataCnt($p_intBrokerID)
{
$orm = new ORM_UserORM('broker_profile_photo');
$strWhere = 'brokerid = ? and dstatus=1';
$arrParams = array($p_intBrokerID);
return $orm->getCnt($strWhere, $arrParams, true);
}
/**
* 根据经纪人id获取经纪人一定时间内兑换数
* @param int $p_intBrokerID
* @param int $CreateTime
* @param boolean $p_bolStrictFreshCache
*/
public static function getGradeExchangesNum($p_intBrokerID, $CreateTime, $p_bolStrictFreshCache = false)
{
$objORM = new ORM_UserORM('ajk_grade_exchanges');
$strWhere = 'BrokerID = ? and CreateTime > ? and (ExchangesType = 1 or ExchangesType = 2)';
$arrParams = array($p_intBrokerID, $CreateTime);
return $objORM->getCnt($strWhere, $arrParams, $p_bolStrictFreshCache);
}
/**
* 获得经纪人填的有效求购信息数量
* @param unknown_type $p_intBrokerID
* @param unknown_type $p_bolStrictFreshCache
*/
public static function getProNeedNum($p_intBrokerID, $p_bolStrictFreshCache = true)
{
$objORM = new ORM_UserORM('ajk_proneed');
$strWhere = 'BrokerId = ? and Status = 1';
$arrParams = array($p_intBrokerID);
return $objORM->getCnt($strWhere, $arrParams, $p_bolStrictFreshCache);
}
public static function countLabersDao($brokerid, $type = 1)
{
$objORM = new ORM_UserORM('broker_label');
$strWhere = 'brokerid=' . $brokerid . '&& dstatus=1 && typeid=' . $type;
$arrGroup = $objORM->getCnt($strWhere, array(), true, false);
if ($arrGroup) {
return $arrGroup;
} else {
return 0;
}
}
/**
* 根据公共委托房源列表
* @param int $p_intBrokerID,$p_intActivityID
* @return array/NULL
* */
static function getPublicCommissionCnt($condition, $params, $refresh = false)
{
$objORM = new ORM_UserORM('commission_property');
$result = $objORM->getCnt($condition, $params, $refresh);
return $result;
}
/**
* 查询经纪人受到申请条数
* @param $p_OpenOrdeBrokerId
* @param $p_bolStrictFreshCache
* caoyang 2011.11.8
*/
public static function getOpenOrderRequestNum($p_OpenOrdeBrokerId, $p_bolStrictFreshCache = false)
{
$objORM = new ORM_UserORM('ajk_openorder_request');
$strWhere = 'OpenOrdeBrokerId=? and Status <> 2 and IsDel = 0';
$arrParams = array($p_OpenOrdeBrokerId);
return $objORM->getCnt($strWhere, $arrParams, $p_bolStrictFreshCache);
}
