def travel_add(request):
if request.method == "POST":
obj = travel()
obj.name = request.POST.get("name")
obj.source = stor(request.POST.get("source"))
obj.destination1 = stor(request.POST.get("destination1"))
obj.destination2 = stor(request.POST.get("destination2", False))
obj.destination3 = stor(request.POST.get("destination3", False))
obj.destination4 = stor(request.POST.get("destination4", False))
obj.distance = request.POST.get("distance")
obj.date = request.POST.get("date")
petrol_price = request.POST.get("petrol_price")
state = stor(request.POST.get("state"))
pet = petrol.objects.get(state=state)
pet.petrol_price = petrol_price
obj.petrol_price = petrol_price
obj.total_cost = request.POST.get("total_cost")
if request.FILES:
obj.bill = request.FILES['bill']
obj.save()
pet.save()
ob = log()
ob.log = obj.tid
ob.fields = QueryDict(request.body).dict()
ob.href = '/users/tasks/add/'
ob.go = '/logs/add/'
ob.save()
return HttpResponse("<script>alert('Successfully Added ');</script>")
else:
context = {
'name': user.objects.values('name'),
'distance': distance.objects.all(),
'petrol_price': petrol.objects.all()
}
return render(request, 'traveladd.html', context)
def edit(request, tid):
edit = user.objects.get(tid=tid)
if request.method == "POST":
ob = log()
ob.pfields = "{ 'tid':'" + str(edit.tid) + "','name':'" + str(
edit.name) + "','phone':'" + str(
edit.phone) + "','address':'" + str(
edit.address) + "','designation':'" + str(
edit.designation) + "','bloodgroup':'" + str(
edit.bloodgroup) + "','dateofjoining':'" + str(
edit.dateofjoining) + "','status':'" + str(
edit.status) + "' }"
user.objects.filter(tid=tid).update(
name=request.POST.get("name"),
phone=request.POST.get("phone"),
address=request.POST.get("address"),
designation=request.POST.get("designation"),
bloodgroup=request.POST.get("bloodgroup"),
dateofjoining=request.POST.get("dateofjoining"),
status=request.POST.get("status"))
ob.log = tid
ob.fields = QueryDict(request.body).dict()
ob.href = '/users/edit/'
ob.go = '/logs/edit/'
ob.save()
return HttpResponse("<script>alert('Successfully Updated ');</script>")
else:
context = {'edit': edit}
return render(request, 'useredit.html', context)
def add(request):
if request.method == "POST":
phone = request.POST.get("phone")
if user_exist(phone) == False:
obj = user()
obj.name = request.POST.get("name")
obj.phone = phone
obj.address = request.POST.get("address")
obj.designation = request.POST.get("designation")
obj.bloodgroup = request.POST.get("bloodgroup")
obj.dateofjoining = request.POST.get("dateofjoining")
obj.status = request.POST.get("status")
obj.save()
ob = log()
ob.log = obj.tid
ob.fields = QueryDict(request.body).dict()
ob.href = '/users/add/'
ob.go = '/logs/add/'
ob.save()
return HttpResponse(
"<script>alert('Successfully Added ');</script>")
else:
return HttpResponse("<script>alert('Already Exist');</script>")
else:
return render(request, 'useradd.html')
def travel_edit(request, tid):
edit = travel.objects.get(tid=tid)
if request.method == "POST":
ob = log()
ob.log = tid
ob.pfields = "{ 'tid':'" + str(edit.tid) + "','name':'" + str(
edit.name
) + "','source':'" + str(edit.source) + "','destination1':'" + str(
edit.destination1) + "','destination2':'" + str(
edit.destination2) + "','destination3':'" + str(
edit.destination3) + "','destination4':'" + str(
edit.destination4) + "','distance':'" + str(
edit.distance) + "','date':'" + str(
edit.date) + "','petrol_price':'" + str(
edit.petrol_price
) + "','total_cost':'" + str(
edit.total_cost) + "','bill':'" + str(
edit.bill) + "' }"
ob.fields = QueryDict(request.body).dict()
ob.href = '/users/tasks/edit/'
ob.go = '/logs/edit/'
ob.save()
source = request.POST.get("source")
source = stor(request.POST.get("source"))
destination1 = stor(request.POST.get("destination1"))
petrol_price = request.POST.get("petrol_price")
state = stor(request.POST.get("state"))
pet = petrol.objects.get(state=state)
pet.petrol_price = petrol_price
pet.save()
destination2 = stor(request.POST.get("destination2", False))
destination3 = stor(request.POST.get("destination3", False))
destination4 = stor(request.POST.get("destination4", False))
travel.objects.filter(tid=tid).update(
name=request.POST.get("name"),
source=source,
destination1=destination1,
destination2=destination2,
destination3=destination3,
destination4=destination4,
distance=request.POST.get("distance"),
date=request.POST.get("date"),
petrol_price=petrol_price,
total_cost=request.POST.get("total_cost"))
if request.FILES:
edit.bill = bill = request.FILES["bill"]
edit.save()
return HttpResponse("<script>alert('Successfully Updated ');</script>")
else:
context = {
'name': user.objects.values('name'),
'distance': distance.objects.all(),
'petrol_price': petrol.objects.all(),
'old': edit
}
return render(request, 'traveledit.html', context)
def destination_delete(request, tid):
dele = distance.objects.get(tid=tid)
ob = log()
ob.log = tid
ob.pfields = "{'tid':'" + str(dele.tid) + "','address':'" + str(
dele.address) + "','latitude':'" + str(
dele.latitude) + "','longitude':'" + str(dele.longitude) + "' }"
ob.fields = QueryDict(request.body).dict()
ob.href = '/users/tasks/destination/'
ob.go = '/logs/delete/'
ob.save()
dele.delete()
return HttpResponseRedirect('/users/tasks/destination/')
def delete(request, tid):
dele = user.objects.get(tid=tid)
ob = log()
ob.log = tid
ob.pfields = "{ 'tid':'" + str(dele.tid) + "','name':'" + str(
dele.name) + "','phone':'" + str(dele.phone) + "','address':'" + str(
dele.address) + "','designation':'" + str(
dele.designation) + "','bloodgroup':'" + str(
dele.bloodgroup) + "','dateofjoining':'" + str(
dele.dateofjoining) + "','status':'" + str(
dele.status) + "' }"
ob.href = '/users/'
ob.go = '/logs/delete/'
ob.save()
dele.delete()
return HttpResponseRedirect('/users/')
def destination_add(request):
print(request.body)
if request.method == "POST":
obj = distance()
obj.address = request.POST.get("address")
obj.latitude = request.POST.get("latitude")
obj.longitude = request.POST.get("longitude")
obj.save()
ob = log()
ob.log = obj.tid
ob.fields = QueryDict(request.body).dict()
ob.href = '/users/tasks/destination/add/'
ob.go = '/logs/add/'
ob.save()
return HttpResponse("<script>alert('Successfully Updated ');</script>")
else:
return render(request, 'destinationadd.html')
def destination_edit(request, tid):
edit = distance.objects.get(tid=tid)
if request.method == "POST":
ob = log()
ob.pfields = "{ 'tid':'" + str(edit.tid) + "','address':'" + str(
edit.address) + "','latitude':'" + str(
edit.latitude) + "','longitude':'" + str(
edit.longitude) + "' }"
ob.log = tid
ob.fields = QueryDict(request.body).dict()
ob.href = '/users/tasks/destination/edit/'
ob.go = '/logs/edit/'
ob.save()
distance.objects.filter(tid=tid).update(
address=request.POST.get("address"),
latitude=request.POST.get("latitude"),
longitude=request.POST.get("longitude"))
return HttpResponse("<script>alert('Successfully Updated ');</script>")
else:
context = {'edit': edit}
return render(request, 'destinationedit.html', context)
def travel_delete(request, tid):
dele = travel.objects.get(tid=tid)
dele.delete()
ob = log()
ob.log = tid
ob.pfields = "{'tid':'" + str(dele.tid) + "','name':'" + str(
dele.name
) + "','source':'" + str(dele.source) + "','destination1':'" + str(
dele.destination1) + "','destination2':'" + str(
dele.destination2) + "','destination3':'" + str(
dele.destination3) + "','destination4':'" + str(
dele.destination4) + "','distance':'" + str(
dele.distance) + "','date':'" + str(
dele.date) + "','petrol_price':'" + str(
dele.petrol_price) + "','total_cost':'" + str(
dele.total_cost) + "','bill':'" + str(
dele.bill) + "' }"
ob.fields = QueryDict(request.body).dict()
ob.href = '/users/tasks/'
ob.go = '/logs/delete/'
ob.save()
return HttpResponseRedirect('/users/tasks/')