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