小計算
關於總total 計算
https://stackoverflow.com/questions/70045275/how-to-save-shipping-information-when-proceed-with-payment-in-django-razorpay-gadef place_order(request,total= 0,quantity = 0):
cart = Cart.objects.get(cart_id = _cart_id(request))
cart_items = CartItem.objects.filter(cart = cart, status = True)
# cart_items = CartItem.objects.filter(user= current_user)
cart_count = cart_items.count()
if cart_count <= 0:
return redirect('login')
tax= 0
grant_total = 0
for item in cart_items:
total += (item.product.sale_price * item.quantity)
quantity += item.quantity
tax = (3*total)/100
grant_total = total+tax
if request.method == "POST":
order_number = request.POST.get('order_number')
full_name = request.POST.get('full_name')
mobile = request.POST.get('mobile')
email = request.POST.get('email')
address_line1 = request.POST.get('address_line1')
address_line2 = request.POST.get('address_line2')
country = request.POST.get('country')
state = request.POST.get('state')
city = request.POST.get('city')
order_note = request.POST.get('order_note')
tax = request.POST.get('tax')
grant_total = int(request.POST.get('order_total'))*100
status = request.POST.get('status')
amount = int(request.POST.get('amount')) * 100
# Create Rezorpay Client
client = razorpay.Client(auth=('rzp_test_ertermiaBf1212','ertgghg56Qp27UYlPEsghtedfes'))
# Create Order
callback_url = 'http://'+ str(get_current_site(request))+"/payment/handlerequest/"
response_payment = client.order.create(dict(amount=amount,
currency="INR")
)
order_id = response_payment['id']
order_status = response_payment['status']
if order_status == 'created':
order = Order(
order_number = order_number,
full_name = full_name,
mobile = mobile,
email = email,
address_line1 = address_line1,
address_line2 = address_line2,
country = country,
state = state,
city = city,
order_total = grant_total,
order_note = order_note,
amount =amount,
status = status,
tax =tax,
order_id = order_id,
)
order.save()
form = Order(request.POST or None)
return render(request, 'frontend/store/payment.html', {'form':form, 'pay':response_payment,'callback_url':callback_url})
form = OrderForm()
return render(request, 'frontend/store/payment.html', {'form':form})
Table Search in Django
def listOrder(request):
if request.method == "POST":
order_number = request.POST.get('order_number')
product_name = request.POST.get('product_name')
quantity = request.POST.get('quantity')
supplier_name = request.POST.get('supplier_name')
procurement_staff = request.POST.get('procurement_staff')
add_date = request.POST.get('add_date')
mod_date = request.POST.get('mod_date')
qs_filter = MeatOrder.objects.raw(
order_number=order_number,
product_name=product_name,
quantity=quantity,
supplier_name=supplier_name,
procurement_staff=procurement_staff,
add_date=add_date,
mod_date=mod_date,
)
context = {
'qs_filter': qs_filter,
}
return render(request, 'meatOrder/index.html', context)
else:
qs = MeatOrder.objects.all()
context = {
'queryset': qs,
}
return render(request, 'meatOrder/index.html', context)