def list_table_data(quotation):
data = [
[
Paragraph('<para fontSize=9><b>S/N</b></para>', style["BodyText"]), \
Paragraph('<para fontSize=9><b>Product ID</b></para>', style["BodyText"]), \
Paragraph('<para fontSize=9><b>Reference</b></para>', style["BodyText"]), \
Paragraph('<para fontSize=9><b>Description</b></para>', style["BodyText"]), \
Paragraph('<para fontSize=9><b>Qty</b></para>', style["BodyText"]), \
Paragraph('<para fontSize=9><b>Price/Unit (GBP)</b></para>', style["BodyText"]), \
Paragraph('<para fontSize=9><b>Total (GBP)</b></para>', style["BodyText"])
]
]
line_item_list = h.change_id_serialno(list(quotation.lineitem_set.all()))
for l in line_item_list:
row = []
row.append(str(l.id))
row.append(str(l.product.product.code))
row.append(str(l.product.part_number))
row.append(Paragraph(l.product.description, style["BodyText"]))
row.append(str(l.quantity))
row.append(str(l.cost_per_unit))
row.append(str(l.cost))
data.append(row)
quotation_details = return_quote_details(quotation.cost, quotation.courier_charge)
data.append(["", "", "", "", "", "Sub-Total", str(quotation_details[0])])
data.append(["", "", "", "", "", "VAT @ 5%", str(quotation_details[1])])
data.append(["", "", "", "", "", "Logistics", str(quotation_details[2])])
data.append(["", "", "", "", "", Paragraph('<b>Grand Total</b>', style["BodyText"]), str(quotation_details[3])])
return data
def fetch_quote(request, quotation_id, form_class=UserDetailCheckForm, template="quote/quotation.html", **kwargs):
quotation = get_object_or_404(Quotation, pk=quotation_id)
quotation.VAT = settings.VAT/100.0 * int(quotation.cost)
user_account = get_user_account(quotation.user.id)
form = form_class()
line_item_list = h.change_id_serialno(list(quotation.lineitem_set.all()))
return render_to_response(template, {
"menu": APP_MENU,
"quotation": quotation,
"line_items": line_item_list,
"user_account": user_account,
"user_detail_form": form,
}, context_instance=RequestContext(request))
