In my Guest House booking system I function that is intended to do invoice
calculations for clients using values from different database tables &
display the information in a table in the view.
The problem now is some information is not being displayed in the table in
the view when a client has not ordered some services. E.G;
- When a client books in and just orders meals and does not request an
extra room the meals information does not show in the invoice table only
the room information displays but the total amount charges are not
displayed.
- When a client books a room and an extra room the total amount charges
are not displayed.
- Only when a client has booked a room, booked an extra room and ordered
meals thats when all the information is displayed in the invoices including
calculations.
I am doing something wrong somewhere in my code but i can not figure it
out. I need assistance.
*CONTROLLER:*
def viewInvoices():
invoice=db.ClientDetails(request.args(0, cast=int))
resCompany=db(db.my_company).select()
room=db((db.book_client2.ClientDetails==invoice.id) &
(db.book_client2.determinant==1)).select()
add_room=db((db.additionalRooms2.book_client==invoice.id) &
(db.additionalRooms2.determinant==1)).select()
room_service=db((db.room_service_orders.customer==invoice.id)
&(db.room_service_orders.determinant==1)).select()
return locals()
*VIEW:*
<div>
<table>
<tr>
<th>Quantity</th>
<th>Description</th>
<th>Order Price</th>
<th>Value</th>
</tr>
<tr>
*<!------------------------Information for room service----------->*
{{for invoice in room:}}
<td>{{=invoice.No_Days}} (days)</td>
<td>{{=invoice.Room.Room_Number}}</td>
<td>BWP {{=invoice.roomAmount}}</td>
<td>BWP {{=invoice.Amount}}</td>
</tr>
<tr>
*<!---------------------------Information for an extra room
booking------------->*
{{for add_r in add_room:}}
<td>{{=add_r.No_Days}} (days)</td>
<td>{{=add_r.Room.Room_Number}}</td>
<td>BWP {{=add_r.roomAmount}}</td>
<td>BWP {{=add_r.Amount}}</td>
</tr>
<tr>
*<!-----------------------------Information for miscellaneous
orders------------------------------>*
{{for orders in room_service:}}
<td>{{=orders.quantity}}</td>
<td>{{=orders.client_order}}</td>
<td>BWP {{=orders.price}}</td>
<td>BWP {{=orders.totalPrice}}</td>
</tr>
{{
*#Total Calculations of all services rendered*
tourism_levy=10.00
total=float(invoice.Amount)+float(add_r.Amount)+float(orders.totalPrice)
totalPrice=float(invoice.Amount)+float(add_r.Amount)+float(orders.totalPrice)+tourism_levy
}}
<tr>
*<!------------------------------------Display of total
calculations------------------------------------>*
<td></td><td style="font-weight: bold; font-size: 14px; color:
black;" width: 29px;>(Levy EXCLUSIVE)</td><td style="font-weight: bold;
font-size: 14px; color: green;" width: 29px;>Sub-Total:</td><td
style="font-weight: bold; font-size: 14px; color: green;" width: 29px>BWP
{{=total}}</td>
</tr>
<tr>
<td></td><td></td><td style="font-weight: bold; font-size: 14px;
color: red;" width: 29px;> Tourism Levy: </td><td style="font-weight: bold;
font-size: 14px; color: red;" width: 29px>BWP {{=tourism_levy}}</td>
</tr>
<tr>
<td></td><td style="font-weight: bold; font-size: 14px; color:
black;" width: 29px;>(Levy INCLUSIVE)</td><td style="font-weight: bold;
font-size: 14px; color: green;" width: 29px;>Total: </td><td
style="font-weight: bold; font-size: 14px; color: green;" width: 29px>BWP
{{=totalPrice}}</td>
</tr>
{{pass}}
{{pass}}
{{pass}}
</table>
</div>
<br />
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/40a6b893-19b6-48e4-a112-60024b7c0076n%40googlegroups.com.
