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 = 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 process_request(request): req = request.REQUEST p = Person(pk=req['person.id']) number = validators.RegexValidator('^([0-9])+(\.[0-9]{1,2})?$', code=_('Amount')) amount=req['amount'] #validate amount number(amount) reason=req['reason'] if not reason or reason.strip() == '': raise ValidationError(_('Required'), code=_('Reason')) date=DateService.invert(req['date']) l = Loan(person=p, amount=amount, reason=reason, remain=amount, date=date) if param_exist("id",req): l.pk = req['id'] l.remain = "%.2f" % getPaymentRemain(l) if param_exist("instalments",req): l.instalments = req['instalments'] else: l.instalments = 1 return l
def calc(request): req = request.REQUEST if param_exist("date",req): date = DateService.parse(req['date']) else: date = DateService.today() fromDate = DateService.firstDateOfMonth(date) toDate = DateService.lastDateOfMonth(date) q = Expense.objects.filter(date__gte=fromDate, date__lte=toDate) 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']) sum=0 for exp in q: sum+=exp.amount today = DateService.today() if today.tm_year==date.tm_year and today.tm_mon==date.tm_mon: days=today.tm_mday else: days=DateService.lastDayOfMonth(date) avg = sum / days data = '{"data":{"total":%s,"avg":%s}}' % (sum,avg) return data
def monthCalc(request): req = request.REQUEST if param_exist("date",req): date = DateService.parse(req['date']) else: date = DateService.today() fromDate = DateService.firstDateOfMonth(date) toDate = DateService.lastDateOfMonth(date) q = Expense.objects.extra(select={'sum': 'sum(amount)'}).values('sum','date') #q = Expense.objects.filter(date__gte=fromDate, date__lte=toDate) q = q.filter(date__gte=fromDate, date__lte=toDate).order_by('date') 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']) q.query.group_by = ['date'] list = [] for exp in q: list.append('[%d,%s]' % (int(DateService.toLong(exp['date'])),exp['sum'])) data = "[" + ",".join(list) + "]" 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 from_request(request): req = request.REQUEST p = Person(pk=req['person.id']) l = Loan(person=p,amount=req['amount'],date=DateService.invert(req['date']), reason=req['reason'], remain=req['amount']) if param_exist("id",req): l.pk = req['id'] if param_exist("instalments",req): l.instalments = req['instalments'] else: l.instalments = 1 return l
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 fromParams(req): s = SubCategory.objects.get(pk=req['subCategory.id']) p = PaymentType(pk=req['paymentType.id']) if param_exist("text",req): text = req['text'] else: text = s.name if param_exist("id",req): e = Expense.objects.get(pk=req['id']) else: e = Expense() e.text=text e.date=DateService.invert(req['date']) e.amount=req['amount'] e.subCategory=s e.paymentType=p return e
def pay(request): req = request.REQUEST e = Tax.objects.get(pk=req['id']) if e: if param_exist("nextExpire",req): e.expire = DateService.invert(req['nextExpire']) else: e.expire = e.nextExpire if param_exist("nextExpire2",req): e.nextExpire = DateService.invert(req['nextExpire2']) else: e.nextExpire = None e.amount = req['amount'] e.lastPay = DateService.todayDate() if e.account=="": service = e.service else: service = "%s (%s)" % (e.service, e.account) expense = Expense(date=DateService.todayDate(), text=service, amount=e.amount, subCategory=e.subCategory, paymentType=e.paymentType) data = '{"success":true}' safe = True try: e.save() except _mysql_exceptions.Warning: pass except Exception, e1: safe = False transaction.rollback() data = '{"success":false, "msg": "%s"}' % (e1.args) if safe: try: expense.save() transaction.commit() except _mysql_exceptions.Warning: transaction.commit() except Exception, e2: safe = False transaction.rollback() data = '{"success":false, "msg": "%s"}' % (e2.args)
def fromParams(req): s = SubCategory.objects.get(pk=req['subCategory.id']) p = PaymentType(pk=req['paymentType.id']) if param_exist("id",req): e = Tax.objects.get(pk=req['id']) else: e = Tax() e.service=req['service'] e.amount=req['amount'] e.expire=DateService.invert(req['expire']) if param_exist("nextExpire",req): e.nextExpire=DateService.invert(req['nextExpire']) if param_exist("lastPay",req): e.lastPay=DateService.invert(req['lastPay']) e.account=req['account'] e.subCategory=s e.paymentType=p return e
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
def fromParams(req): if param_exist("id",req): e = CardData(pk=req['id']) else: e = CardData() c = Card(pk=req['card.id']) e.date=DateService.invert(req['date']) e.shop=req['shop'] e.instalments=req['instalments'] e.total=req['total'] e.card = c return e
def fromParams(req): if not req['date']: raise ValidationError(_('Enter a valid date')) amount = req['amount'] number = validators.RegexValidator('^-?([0-9])+(\.[0-9]{1,2})?$', message=_('Enter a valid amount')) number(amount) if not amount or float(amount) == 0.0: raise ValidationError(_('Enter a valid amount')) try: s = SubCategory.objects.get(pk=req['subCategory.id']) except SubCategory.DoesNotExist: raise ValidationError(_('Select a valid category')) try: p = PaymentType.objects.get(pk=req['paymentType.id']) except PaymentType.DoesNotExist: raise ValidationError(_('Select a valid payment type')) if param_exist("text",req): text = req['text'] else: text = s.name if param_exist("id",req): e = Expense.objects.get(pk=req['id']) else: e = Expense() e.text=text e.date=DateService.invert(req['date']) e.amount=amount e.subCategory=s e.paymentType=p return e
def sixMonthCalc(request): req = request.REQUEST if param_exist("date",req): date = DateService.parse(req['date']) else: date = DateService.today() fromDate = DateService.addMonth(DateService.firstDateOfMonth(date),-6) toDate = DateService.lastDateOfMonth(date) query = "SELECT sum(amount), date FROM expense "\ "WHERE date between '%s' and '%s'" % (str(fromDate), str(toDate)) if param_exist("subC",req): query += " AND sub_category_id = '%s'" % req['subC'] elif param_exist("cat",req): c = SubCategory.objects.filter(category=req['cat']) query += " AND sub_category_id in (%s)" % ",".join(["'"+str(s.id)+"'" for s in c]) if param_exist("payT",req): query += " AND payment_type_id = '%s'" % req['payT'] query += " group by month(date)" cursor = connection.cursor() cursor.execute(query) list = [] for exp in cursor.fetchall(): sum, date = exp i = Income.objects.extra(select={'sum': 'sum(amount)'}).values('sum') i = i.filter(period = DateService.firstDateOfMonth(date.timetuple())) val = i[0]['sum'] if val is None: val = 0 list.append({'date': date, 'expense': sum, 'income': val}) data = '{"rows": %s}' % (JsonParser.parse(list)) return data
def save(request): req = request.REQUEST p = fromParams(req); if param_exist("loan",req): p.own = False else: p.own = True data = '{"success":true}' safe = True try: p.save() except _mysql_exceptions.Warning: pass except Exception, e1: safe = False data = '{"success":false, msg: "%s"}' % (e1.args)
p.own = False else: p.own = True data = '{"success":true}' safe = True try: p.save() except _mysql_exceptions.Warning: pass except Exception, e1: safe = False data = '{"success":false, msg: "%s"}' % (e1.args) if safe: if param_exist("addloan",req): pe = Person(pk=req['person.id']) l = Loan(person=pe, amount=p.total, date=p.date, reason=p.shop) try: l.save() except _mysql_exceptions.Warning: pass except Exception, e1: safe = False data = '{"success":false, "msg": "%s"}' % (e1.args) return data @json_response def update(request): req = request.REQUEST
def calcPayment(request): req = request.REQUEST q = Loan.objects.filter() q = q.filter(person=req['person.id']) exclude = [] if param_exist('exclude',req): exc = string.split(req['exclude'],";") for e in exc: exclude.append(long(e)) modf = dict() if param_exist('modf',req): moda = json.loads(req['modf']) for md in moda: modf[md['id']] = md['value'] total = Decimal(req['amount']) remain = total res = [] for exp in q: cursor = connection.cursor() cursor.execute("SELECT sum(amount) as sum FROM payment WHERE loan_id = %s", [exp.id]) row = cursor.fetchone() sum = exp.amount if row[0]!=None: sum = exp.amount - row[0] partial = exp.amount / exp.instalments pay = 0 dr = False if exp.id in modf.keys(): remain -= modf[exp.id] pay = modf[exp.id] sum -= pay dr = True if sum > 0: res.append({'id': exp.id, 'amount': exp.amount, 'date': exp.date, 'reason': exp.reason, 'balance': sum, 'partial': partial, 'pay': pay, 'remain': sum, 'dirty': dr}) while remain > 0: resto = 0 for l in res: if not l['id'] in exclude: if not l['id'] in modf.keys(): if l['remain'] < l['partial']: if l['remain'] > remain: l['pay'] += remain l['remain'] = l['balance'] - l['pay'] remain = 0 else: l['pay'] += l['remain'] remain -= l['remain'] l['remain'] = l['balance'] - l['pay'] else: if l['partial'] > remain: l['pay'] += remain l['remain'] = l['balance'] - l['pay'] remain = 0 else: l['pay'] += l['partial'] l['remain'] = l['balance'] - l['pay'] remain -= l['partial'] resto += l['remain'] if remain <= 0: break if resto == 0: break data = '{"total": "0", "rows": %s}' % (JsonParser.parse(res)) return data
data = '{"total": %s, "rows": %s}' % (Payment.objects.count(), JsonParser.parse(list)) return data @json_response def save_or_update(request): data = '{"success":true}' req = request.REQUEST number = validators.RegexValidator('^([0-9])+(\.[0-9]{1,2})?$', code=_('Amount')) amount=req['amount'] try: number(amount) except ValidationError, va1: return '{"success":false, "msg": "%s: %s"}' % (va1.code, "".join(va1.messages)) l = Loan.objects.get(pk=req['loan.id']) if param_exist("id",req): p = Payment.objects.get(pk=req['id']) prevAmount = p.amount else: p = Payment(loan=l) prevAmount = None if checkPayment(l,amount,prevAmount): if prevAmount: diff = float(prevAmount) - float(amount) l.remain = unicode(float(l.remain) + diff) else: l.remain = unicode(float(l.remain) - float(amount)) p.amount=amount