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()