def list(request): req = request.REQUEST q = Debits.objects.filter() if param_exist("sort", req): q = q.order_by(sortMethod(req)) if param_exist("limit", req): start = req["start"] limit = req["limit"] list = q[start : start + limit] else: list = q res = [] for exp in list: res.append( { "id": exp.id, "amount": exp.amount, "since": exp.since, "text": exp.text, "paymentType_name": exp.paymentType.name, "subCategory_name": exp.subCategory.name, "paymentTypeId": exp.paymentType.id, "subCategoryId": exp.subCategory.id, "day": exp.day, "last": exp.last, } ) data = '{"total": %s, "rows": %s}' % (q.count(), JsonParser.parse(res)) return data
def list(request): req = request.REQUEST q = Expense.objects.filter() if param_exist("amountStart",req): q = q.filter(amount__gte=req['amountStart']) if param_exist("amountEnd",req): q = q.filter(amount__lte=req['amountEnd']) if param_exist("dateStart",req): q = q.filter(date__gte=DateService.invert(req['dateStart'])) if param_exist("dateEnd",req): q = q.filter(date__lte=DateService.invert(req['dateEnd'])) if param_exist("subC",req): q = q.filter(subCategory=req['subC']) elif param_exist("cat",req): c = SubCategory.objects.filter(category=req['cat']) q = q.filter(subCategory__in=c) if param_exist("payT",req): q = q.filter(paymentType=req['payT']) if param_exist("sort",req): q = q.order_by(sortMethod(req)) if param_exist("limit",req): list = q[req['start']:req['start']+req['limit']] else: list = q res = [] for exp in list: res.append({'id': exp.id, 'amount': exp.amount, 'date': exp.date, 'text': exp.text, 'paymentType_name': exp.paymentType.name, 'subCategory_name': exp.subCategory.name, 'paymentTypeId': exp.paymentType.id, 'subCategoryId': exp.subCategory.id}) data = '{"total": %s, "rows": %s}' % (q.count(), JsonParser.parse(res)) return data
def list(request): req = request.REQUEST q = Loan.objects.filter() if param_exist("person.id",req): q = q.filter(person=req['person.id']) if param_exist("sort",req): q = q.order_by(sortMethod(req)) if not param_exist("all",req): q = q.filter(remain__gt=0) if param_exist("limit",req): start = int(req['start']) limit = int(req['limit']) list = q[start:start+limit] else: list = q res = [] for exp in list: if exp.remain == 0: partial = 0 else: partial = exp.amount / exp.instalments if exp.remain < partial: partial = exp.remain res.append({'id': exp.id, 'amount': exp.amount, 'date': exp.date, 'reason': exp.reason, 'person': exp.person.name, 'instalments': exp.instalments, 'personId': exp.person.id, 'balance': exp.remain, 'partial': partial}) data = '{"total": %s, "rows": %s}' % (q.count(), JsonParser.parse(res)) return data
def list(request): req = request.REQUEST # find close date dateQuery = CardDates.objects.filter(closeDate__gt=DateService.todayDate()) dateQuery = dateQuery.order_by('closeDate') if dateQuery.count()>0: dt = dateQuery[:1][0] else: dt = CardDates(closeDate=DateService.todayDate(), expireDate=DateService.todayDate()) q = CardData.objects.extra(where=["ADDDATE(date, INTERVAL ((instalments+1) * 30) DAY) > '%s'" % DateService.invert(dt.closeDate)]) if param_exist("sort",req): q = q.order_by(sortMethod(req)) if param_exist("limit",req): start = req['start'] limit = req['limit'] list = q[start:start+limit] else: list = q res = [] for exp in list: rem = FinancialService.remainInstalments(exp.date, dt.closeDate, exp.instalments) if rem >= 0: res.append({'id': exp.id, 'date': exp.date, 'shop': exp.shop, 'instalments': exp.instalments, 'card_id': exp.card.id, 'card_name': exp.card.name, 'total': exp.total, 'own': exp.own, 'partial': exp.total / exp.instalments, 'remain': rem }) data = '{"total": %s,"close": "%s", "expire": "%s", "rows": %s}' % (CardData.objects.count(), DateService.format(dt.closeDate),DateService.format(dt.expireDate), JsonParser.parse(res)) return data
def list(request): req = request.REQUEST q = Category.objects.filter() if param_exist("sort",req): q = q.order_by(sortMethod(req)) if param_exist("limit",request.REQUEST): start = request.REQUEST['start'] limit = request.REQUEST['limit'] lst = q[start:start+limit] else: lst = q data = '{"total": %s, "rows": %s}' % (Category.objects.count(), JsonParser.parse(lst)) return data
def list(request): req = request.REQUEST q = Payment.objects.filter() if param_exist("loan.id",req): q = q.filter(loan=req['loan.id']) if param_exist("sort",req): q = q.order_by(sortMethod(req)) if param_exist("limit",req): start = req['start'] limit = req['limit'] list = q[start:start+limit] else: list = q data = '{"total": %s, "rows": %s}' % (Payment.objects.count(), JsonParser.parse(list)) return data
def list(request): req = request.REQUEST q = Person.objects.filter() if param_exist("sort",req): q = q.order_by(sortMethod(req)) if param_exist("limit",req): start = req['start'] limit = req['limit'] list = q[start:start+limit] else: list = q res = [] for p in list: res.append({'id': p.id, 'name': p.name, 'count': p.loans.active().count()}) data = '{"total": %s, "rows": %s}' % (Person.objects.count(), JsonParser.parse(res)) return data
def list(request): req = request.REQUEST q = CardDates.objects.filter() if param_exist("sort",req): q = q.order_by(sortMethod(req)) if param_exist("limit",req): start = req['start'] limit = req['limit'] list = q[start:limit] else: list = q res = [] for exp in list: res.append({'id': exp.id, 'closeDate': exp.closeDate, 'expireDate': exp.expireDate, 'card': exp.card.name, 'card_id': exp.card.id}) data = '{"total": %s, "rows": %s}' % (CardDates.objects.count(), JsonParser.parse(res)) return data
def list(request): req = request.REQUEST q = Tax.objects.filter() if param_exist("sort",req): q = q.order_by(sortMethod(req)) if param_exist("limit",req): start = req['start'] limit = req['limit'] list = q[start:start+limit] else: list = q res = [] for it in list: res.append({'id': it.id, 'service': it.service, 'expire': it.expire, 'amount': it.amount, 'nextExpire': it.nextExpire, 'subCategory': it.subCategory.name, 'subCategoryId': it.subCategory.id, 'nextExpire': it.nextExpire, 'lastPay': it.lastPay, 'paymentType': it.paymentType.name, 'paymentTypeId': it.paymentType.id, 'account': it.account}) data = '{"total": %s, "rows": %s}' % (q.count(), JsonParser.parse(res)) return data