def get_investor_nums(self, year, month):
# 统计借款人数
bid_request_query = BidRequest.objects.filter(
(Q(bidRequestState=BidConst.GET_BIDREQUEST_STATE_PAYING_BACK())
| Q(bidRequestState=BidConst.GET_BIDREQUEST_STATE_BIDDING()))
& Q(applyTime__month=month) & Q(applyTime__year=year))
if bid_request_query.exists():
return bid_request_query.count()
else:
return 0
def getavailable_amount_total(self, year, month):
# 统计投资金额
bid_request_query = BidRequest.objects.filter(
Q(bidRequestState=BidConst.GET_BIDREQUEST_STATE_PAYING_BACK())
& Q(applyTime__month=month) & Q(applyTime__year=year))
if bid_request_query.exists():
available_amount_total = bid_request_query.aggregate(
Sum('bidRequestAmount'))
return available_amount_total['bidRequestAmount__sum']
else:
return 0
def get_borrower_nums(self, year, month):
# 统计投资人数
bid_request_query = BidRequest.objects.filter(
Q(bidRequestState=BidConst.GET_BIDREQUEST_STATE_PAYING_BACK())
& Q(applyTime__month=month) & Q(applyTime__year=year))
if bid_request_query.exists():
list_id = []
for br in bid_request_query:
bids = br.bids.values_list('bidUser')
# 取出所有投标用户id, 并去重
bid_user_ids = list(set((list(zip(*bids)))[0]))
list_id.extend(bid_user_ids)
list_id = list(set(list_id))
return len(list_id)
else:
return 0
def save_models(self):
#获取保持对象
obj = self.new_obj
obj.save()
if obj is not None:
bid_audit = obj
bid_audit.auditor = self.user.username
bid_audit.audiTime = timezone.now()
bid_request = bid_audit.bidRequestId
#如果审核成功
if bid_audit.state == BitStatesUtils.STATE_AUDIT():
# // 1, 对借款要做什么事情?
# // ** 1.1
# 修改借款状态(还款中)
bid_request.bidRequestState = BidConst.GET_BIDREQUEST_STATE_PAYING_BACK() #还款状态
bid_request.note = bid_audit.remark
#添加满标二审历史
self.createBrAuditHistory(bid_request)
# // 2, 对借款人要做什么事情?
# // ** 2.1
# 借款人收款操作
borrow_account = Account.objects.get(userProfile=bid_request.createUser.userProfile)
# // ** *2.1.1 账户余额增加,
borrow_account.usableAmount = borrow_account.usableAmount + bid_request.bidRequestAmount
# // ** *2.1.2生成收款流水;
self.generateBorrowSuccessFlow(borrow_account=borrow_account,br=bid_request)
# // ** *2.1.3修改待还本息;
borrow_account.unReturnAmount = borrow_account.unReturnAmount + bid_request.bidRequestAmount + bid_request.totalRewardAmount
# // ** *2.1.4修改可用信用额度;
borrow_account.remainBorrowLimit = borrow_account.remainBorrowLimit - bid_request.bidRequestAmount
# // ** 2.2移除借款人借款进行中状态码;
bid_request.createUser.userProfile.removeState(BitStatesUtils.GET_OP_HAS_BIDREQUEST_PROCESS())
bid_request.createUser.userProfile.save()
# // ** 2.3支付借款手续费计算
manage_charge_fee = CalculatetUtil.calAccountManagementCharge(bid_request.bidRequestAmount)
# // ** *2.3.1可用余额减少
borrow_account.usableAmount = borrow_account.usableAmount - manage_charge_fee
borrow_account.save()
# // ** *2.3.2生成支付借款手续费流水;
self.generateBorrowChargeFeeFlow(borrow_account=borrow_account,br=bid_request,manageChargeFee=manage_charge_fee)
# // ** *2.3.3平台收取借款手续费;
self.systemReceiveChargeFeeFromBorrow(br=bid_request,manage_charge_fee=manage_charge_fee)
# // 3, 对投资人要做什么事情?
# // ** 3.1遍历投标;
bids = bid_request.bids.values_list('bidUser')
# 取出所有投标用户id, 并去重
bid_user_ids = list(set((list(zip(*bids)))[0]))
# // 汇总利息, 用于最后一个投标的用户的利息计算
totalBidInterest = Decimal('0')
for idx, bid_user_id in enumerate(bid_user_ids):
#获取投资人
bids_temp_query = bid_request.bids.filter(bidUser_id=bid_user_id)
# 获取相同投资人投的标数量
# 统计投资金额
available_amount_total = bids_temp_query.aggregate(Sum('availableAmount'))
# 获取投资人账户
investor_account = Account.objects.get(userProfile=bids_temp_query.first().bidUser.userProfile)
# 冻结余额减少
investor_account.freezedAmount = investor_account.freezedAmount - available_amount_total['availableAmount__sum']
# // ** 3.3生成成功投标流水
self.bidSuccessFlow(bid=bids_temp_query.first(),account=investor_account, total_bid_amount=available_amount_total['availableAmount__sum'])
# // ** 3.4计算待收利息和待收本金
# // ** 3.4.1待收本金
investor_account.unReceivePrincipal = investor_account.unReceivePrincipal + available_amount_total['availableAmount__sum']
#临时利息变量
bidInterest = Decimal('0')
# // ** 3.4.2待收利息
# // 待收利息 = 投标金额 / 借款总金额 * 借款总回报利息
# // 如果当前投标是整个投标列表中的最后一个投标;这个投标的利息 = 借款总回报利息 - 累加的投标利息
if idx == len(bid_user_ids) - 1:
#计算最后投标人的利息
bidInterest = bid_request.totalRewardAmount - totalBidInterest
else:
bidInterest = (available_amount_total['availableAmount__sum'] / bid_request.bidRequestAmount) * bid_request.totalRewardAmount
bidInterest = DecimalFormatUtil.formatBigDecimal(bidInterest, BidConst.STORE_SCALE())
#累加总的利息 用于最后利息的计算
totalBidInterest = totalBidInterest + bidInterest
investor_account.unReceiveInterest = investor_account.unReceiveInterest + bidInterest
investor_account.save()
# // 4, 思考满标二审之后的流程(还款)对满标二审有什么影响
# // ** 4生成还款对象和回款对象
self.createPaymentSchedules(bid_request)
elif bid_audit.state == BitStatesUtils.STATE_REJECT():
#审核失败，修改借款状态
bid_request.bidRequestState = BidConst.GET_BIDREQUEST_STATE_REJECTED() #满标审核拒绝
#进行退款
self.retureMoney(bid_request)
# 审核失败，移出用户招标状态
bid_request.createUser.userProfile.removeState(BitStatesUtils.GET_OP_HAS_BIDREQUEST_PROCESS())
bid_request.createUser.userProfile.save()
#保存模型
bid_request.save()
bid_audit.save()
