[web2py] Hiding details from view without deleting them from a database when certain condition is satisfied

[mostwanted]

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.