/** * 获取用户账户明细 * @param $userId * @param $parentLogId * @return array */ public static function getAccountListInfoByUserId($userId, $parentLogIdArr = array(), $order = false, $limit = false) { $userId = intval($userId); if (empty($userId) || empty($parentLogIdArr)) { return array(); } $parentLogIdArr = array_unique($parentLogIdArr); $subAccoutList = Model_Log_AccountBalanceLogSub::data_access(date('m'))->filter_by_op('userId', '=', $userId)->filter('parentLogId', $parentLogIdArr); if ($order) { $subAccoutList = $subAccoutList->sort('id', 'desc'); } if ($limit) { $subAccoutList = $subAccoutList->limit($limit); } return $subAccoutList->find(); }
/** * 根据用户id查询账户日志明细表2个id之间的数据 * * @param $userId 用户id * @param $startId 起始id * @param $endId 结束id * @return array * @throws Exception sql或者其他错误 */ public function getDifferentSubBalanceLog($userId, $startId, $endId) { return Model_Log_AccountBalanceLogSub::data_access(date('m'))->filter_by_op('userId', '=', $userId)->filter_by_op('id', '=', $startId)->filter_by_op('id', '<=', $endId)->find(); }