def save_distance(request):
voucher_no = request.GET['voucher']
distance = request.GET['distance']
purchase_order_id = request.GET['order']
purchase_order = PurchaseOrder.objects.get(pk=purchase_order_id)
financialsession = FinancialSession.objects.values('id',\
'session_start_date', 'session_end_date')
today = datetime.now().date()
for value in financialsession:
start_date = value['session_start_date']
end_date = value['session_end_date']
if start_date <= today <= end_date:
session_id = value['id']
session = FinancialSession.objects.get(pk=session_id)
try:
suspense = SuspenseOrder.objects.filter(voucher=voucher_no).\
get(purchase_order=purchase_order_id)
suspense.distance_estimated = distance
suspense.save()
except:
suspense = SuspenseOrder(voucher=voucher_no,
purchase_order=purchase_order, session_id=session,
distance_estimated=distance)
suspense.save()
return HttpResponse('')
def save_charges(request):
if request.method=='GET':
option=request.GET['Purchase_order']
charges=request.GET['distance']
obj = SuspenseOrder(purchase_order_id=option,transportation=charges)
obj.save()
return HttpResponse('Thanks!')
def add_distance(request):
old_post = request.session.get('old_post')
purchase_order_id = request.session.get('purchase_order_id')
items = []
parents = []
field_work = []
suspense = 0
for id in range(0,10):
try:
items.append(old_post['purchaseditem_set-' + str(id) + '-item'])
except:
pass
for item in items:
if item:
parents.append(PurchasedItem.objects.values(
'item__category__parent__name','id').filter(item=item).\
filter(purchase_order=purchase_order_id))
for parent in parents:
for category in parent:
value = category['item__category__parent__name']
key = category['id']
if value.split(':')[1].upper() == 'FIELD WORK' or \
value.split(':')[1].upper() == ' FIELD WORK':
field_work.append(key)
if field_work:
if request.method == 'POST':
request.session['old_post'] = old_post
request.session['purchase_order_id'] = purchase_order_id
return HttpResponseRedirect(\
reverse("librehatti.catalog.views.bill_cal"))
else:
purchase_order = PurchaseOrder.objects.values('date_time').\
get(id=purchase_order_id)
purchase_order_obj = PurchaseOrder.objects.get(id=purchase_order_id)
purchase_order_date = purchase_order['date_time']
financialsession = FinancialSession.objects.\
values('id', 'session_start_date', 'session_end_date')
for value in financialsession:
start_date = value['session_start_date']
end_date = value['session_end_date']
if start_date <= purchase_order_date <= end_date:
session_id = value['id']
financial_obj = FinancialSession.objects.get(id=session_id)
voucher = VoucherId.objects.values('voucher_no',
'purchased_item__item__category__name').\
filter(purchase_order=purchase_order_id).\
filter(session=session_id).distinct()
for voucher_val in voucher:
try:
SuspenseOrder.objects.filter(\
voucher=voucher_val['voucher_no'],\
session_id = financial_obj)
except:
suspense_obj = SuspenseOrder(voucher=voucher_val['voucher_no'],\
purchase_order=purchase_order_obj, session_id=financial_obj)
suspense_obj.save()
return render(request,'suspense/add_distance.html',{
'voucher':voucher, 'purchase_order_id': purchase_order_id})
elif old_post['mode_of_payment'] != '1':
purchase_order = PurchaseOrder.objects.values('date_time').\
get(id=purchase_order_id)
purchase_order_date = purchase_order['date_time']
financialsession = FinancialSession.objects.\
values('id', 'session_start_date', 'session_end_date')
for value in financialsession:
start_date = value['session_start_date']
end_date = value['session_end_date']
if start_date <= purchase_order_date <= end_date:
session_id = value['id']
session = FinancialSession.objects.get(pk=session_id)
voucher = VoucherId.objects.values('voucher_no').\
filter(purchase_order=purchase_order_id)
order = PurchaseOrder.objects.get(pk=purchase_order_id)
for voucher_no in voucher:
suspense = SuspenseOrder(voucher=voucher_no['voucher_no'],
purchase_order=order, session_id=session, distance_estimated = 0)
suspense.save()
request.session['old_post'] = old_post
request.session['purchase_order_id'] = purchase_order_id
return HttpResponseRedirect(\
reverse("librehatti.catalog.views.bill_cal"))
else:
request.session['old_post'] = old_post
request.session['purchase_order_id'] = purchase_order_id
return HttpResponseRedirect(\
reverse("librehatti.catalog.views.bill_cal"))
