Hi guys, I need help achieving a certain task, I have a system which creates credit accounts for clients, this information is displayed in a view called *credit_details *, what I want is for this information to stop displaying once the customer has paid all of their credit but without deleting the credit information from the *credit_info and credit_invoice *tables, that information is vital for some accounting calculations, how can achieve this task?
*CONTROLLER* def credit_details(): session.details=db.Client_Details(request.args(0, cast=int)) resCompany=db(db.resident_company).select() db.credit_info.customer.default=session.details.id form=SQLFORM(db.credit_info) if form.process().accepted: response.flash=T('Payment Made') return locals() def credit_calculations(): customer=db(db.credit_info.customer==session.details.id).select() payment=db(db.credit_info.customer==session.details.id).select(db.credit_info.amount_paid.sum().with_alias('payment_total')) total_amount=db(db.credit_invoice.customer==session.details.id).select(db.credit_invoice.Amount.sum().with_alias('total')) return locals() *VIEW* <table> <th>AMOUNT PAID</th> <th>ATTENDED BY</th> <th>DATE & TIME</th> {{for customer in customer:}} <tr> <td style="font-weight: bold;">{{=MoneyFormat(customer.amount_paid)}}</td> <td style="font-weight: bold;">{{=customer.attended_by.first_name}} {{=customer.attended_by.last_name}}</td> <td style="font-weight: bold;">{{=customer.paid_on}}</td> </tr> {{pass}} <tr> {{for total_amount in total_amount: if total_amount.total is None: total_amount.total=0 }} <td style="font-weight: bold; color: red; font-size: 20px;">THIS CLIENT HAS NO CREDIT!!!</td> </tr> {{pass}} <tr> <td style="font-weight: bold; border: solid 2px red; border-radius: 10px; padding: 5px;">CREDIT DUE: {{=MoneyFormat(total_amount.total)}}</td> {{for payment in payment:}} {{if payment.payment_total is None:}} {{payment.payment_total=0}} <td style="font-weight: bold; border: solid 2px green; border-radius: 10px; padding: 5px;">CREDIT BALANCE AFTER PAYMENTS: {{=MoneyFormat(total_amount.total-payment.payment_total)}}</td> <td style="font-weight: bold; border: solid 2px green; border-radius: 10px; padding: 5px;">TOTAL AMOUNT PAID THUS FAR: {{=MoneyFormat(payment.payment_total)}}</td> <td style="font-weight: bold; color: red;">No Payment Made Yet!</td> {{else:}} <td style="font-weight: bold;border: solid 2px green; border-radius: 10px; padding: 5px;">CREDIT BALANCE AFTER PAYMENTS: {{=MoneyFormat(total_amount.total-payment.payment_total)}}</td> <td style="font-weight: bold; border: solid 2px green; border-radius: 10px; padding: 5px;">TOTAL AMOUNT PAID THUS FAR: {{=MoneyFormat(payment.payment_total)}}</td> {{pass}} {{pass}} {{pass}} {{pass}} </tr> </table> <script> $('document').ready(function(){ $(".delete").click(function(){ return confirm('Are you sure you want to clear this CLIENT?!'); }); }); </script> <div id="delete"><a class="delete" href="{{=URL('delete_credit_client', args=session.details.id)}}">Clear Client From Credit</a></div> Regards -- 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/6e268345-5965-4b6a-8fac-dd24ed3a16c2n%40googlegroups.com.