public function aGetRoleList($iStart, $iLength, $flag = null) { $option = new Ko_Tool_SQL(); $option->oOffset($iStart)->oLimit($iLength)->oCalcFoundRows(true); $option->oOrderBy('ctime desc'); if (is_int($flag)) { $option->oWhere('flag = ?', $flag); } $aData = $this->aGetList($option); $aResult['total'] = $option->iGetFoundRows(); $aResult['list'] = $aData; return $aResult; }
/** * 用户查看会话消息列表详情,根据消息线id查询 * * @return array */ public function aGetMessageListWithTotal($iUid, $iThread, &$iTotal, $iStart, $iNum, $bAutoRead = true) { if (isset($this->_aConf['userthread'])) { $userthreadDao = $this->_aConf['userthread'] . 'Dao'; $info = $this->{$userthreadDao}->aGet(array('uid' => $iUid, 'mid' => $iThread)); if (empty($info)) { return array(); } if ($bAutoRead && $info['unread']) { $this->{$userthreadDao}->iUpdate(array('uid' => $iUid, 'mid' => $iThread), array('unread' => 0)); } } $oOption = new Ko_Tool_SQL(); if (isset($this->_aConf['userthread'])) { $oOption->oWhere('ctime >= ?', $info['jointime']); } $oOption->oOrderBy('mid desc')->oOffset($iStart)->oLimit($iNum)->oCalcFoundRows(true); $aRet = $this->_aGetMessageList($iUid, $iThread, $oOption); $iTotal = $oOption->iGetFoundRows(); return $aRet; }
private function _aGetAll_Exkey($aExkeyConf, $vHintId) { $exkeyDao = $aExkeyConf['dao'] . 'Dao'; $oOption = new Ko_Tool_SQL(); $oOption->oOrderBy($aExkeyConf['order']); if (!empty($aExkeyConf['option'])) { call_user_func_array(array($oOption, 'oAnd'), $aExkeyConf['option']); } if (strlen($this->{$exkeyDao}->sGetSplitField())) { return $this->{$exkeyDao}->aGetList($vHintId, $oOption); } return $this->{$exkeyDao}->aGetList($oOption); }
/** * 查询关注用户 B 的用户列表 * * @return array */ public function aGetFollowedListWithTotal($iUidb, $iStart, $iNum, &$iTotal) { $oOption = new Ko_Tool_SQL(); $oOption->oOrderBy('sort desc')->oOffset($iStart)->oLimit($iNum)->oCalcFoundRows(true); $info = $this->_aGetFollowedList($iUidb, $oOption); $iTotal = $oOption->iGetFoundRows(); return $info; }
/** * 同步监控代码到当前所有服务器列表 */ public function vSyncAllIp() { $ipApi = $this->_aConf['ipApi']; $option = new Ko_Tool_SQL(); $iplist = $this->{$ipApi}->aGetList($option->oOrderBy('ip')); foreach ($iplist as $ipinfo) { $ip = long2ip($ipinfo['ip']); $this->vSyncOneIp($ip); } }
/** * 用户查看会话消息列表详情,根据最小id查询 * * @return array */ public function aGetMessageListByMinmid($iUid, $iThread, $iMinmid, $iNum) { if (isset($this->_aConf['userthread'])) { $userthreadDao = $this->_aConf['userthread'] . 'Dao'; $info = $this->{$userthreadDao}->aGet(array('uid' => $iUid, 'mid' => $iThread)); if (empty($info)) { return array(); } if ($info['unread']) { $this->{$userthreadDao}->iUpdate(array('uid' => $iUid, 'mid' => $iThread), array('unread' => 0)); } } $oOption = new Ko_Tool_SQL(); if (isset($this->_aConf['userthread'])) { $oOption->oWhere('ctime >= ?', $info['jointime']); } $listDao = $this->_aConf['list'] . 'Dao'; $minfo = $this->{$listDao}->aGet(array('threadmid' => $iThread, 'mid' => $iMinmid)); if (empty($minfo)) { $oOption->oAnd('mid > ?', $iMinmid); } else { $oOption->oAnd('ctime > ?', $minfo['ctime']); } $oOption->oOrderBy('ctime desc')->oLimit($iNum); return $this->_aGetMessageList($iUid, $iThread, $oOption); }