/**
* 根据经纪人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);
}
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);
}
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);
}
/**
* 获取一条求购信息
* @param array $p_arrParam
* @param blooean $p_bolStrictFreshCache
*/
public static function getProNeed($p_arrParam, $p_bolStrictFreshCache = true)
{
$objORM = new ORM_UserORM('ajk_proneed');
foreach ($p_arrParam as $strKey => $mixValue) {
$objORM->{$strKey} = $mixValue;
}
return $objORM->getRow($p_bolStrictFreshCache);
}
/**
* 更新微博$id的绑定信息
*/
public static function updatePropertySnsById($id, $data)
{
$orm = new ORM_UserORM('ajk_property_sns');
$orm->ID = $id;
foreach ($data as $field => $value) {
$orm->{$field} = $value;
}
return $orm->updData();
}
public static function updateMyShareThreadsDstatus($p_intID, $p_arrParams)
{
$objORM = new ORM_UserORM('cdb_sharethreads');
//$objORM = new ORM_ForumORM('cdb_sharethreads');
$objORM->ID = $p_intID;
foreach ($p_arrParams as $field => $value) {
$objORM->{$field} = $value;
}
return $objORM->updData(true);
}
public function updateCommissionDao($id, $params)
{
$orm = new ORM_UserORM('commission_relation');
$orm->RELATIONID = $id;
foreach ($params as $field => $value) {
$orm->{$field} = $value;
}
return $orm->updData(true);
}
public function delMyLabel($brokerid, $id, $data)
{
$objORM = new ORM_UserORM('broker_label');
$objORM->BROKERID = $brokerid;
$objORM->LBLID = $id;
foreach ($data as $strField => $mixValue) {
$objORM->{$strField} = $mixValue;
}
return $objORM->updData(true);
}
/**
* 获得经济人的省市信息
*/
public static function getBrokerFrom($condition, $params, $refresh = false)
{
$orm = new ORM_UserORM('broker_profile');
$result = $orm->getList($condition, $params, $refresh);
return $result[0];
}
/**
* 得到业主委托的房源信息
* @param int $p_intPropertyID
* @return array
*/
static function getCommissionProperty($p_intPropertyID)
{
apf_require_class('ORM_UserORM');
$objORM = new ORM_UserORM('commission_property');
$objORM->PROPERTYID = $p_intPropertyID;
return $objORM->getRow();
}
/**
* 根据合作开单id更新合作市场数据
* @param $p_intBrokerID
* @param $Num
*/
public static function delOpenOrderMarket($OpenOrderId)
{
if (!is_numeric($OpenOrderId)) {
return false;
}
$objORM = new ORM_UserORM('ajk_openorder_market');
$strSql = "update ajk_openorder_market set IsDel = 1 where OpenOrderId = " . $OpenOrderId;
return $objORM->executeSQL($strSql);
}
static function getMedalInfoById($medal_id)
{
$objORM = new ORM_UserORM("broker_medal_type");
$objORM->ID = $medal_id;
return $objORM->getRow();
}
public static function getOneDataById($id)
{
$orm = new ORM_UserORM('ajk_broker_opinion');
$orm->ID = $id;
return $orm->getRow();
}