'@case: mem004-03
@description: Search Members - Advanced Search by paid/expired/overdue'

def test_mem004_02_member_search_advance_by_Paid(self):

    self.start()
    self.advancedSearchTest(['expired', 'paid'])
    member = current.s3db['member_membership']
    rows = current.db((member.deleted != 'T')).select()
    dbRowCount = 0
    for row in rows:
        if ((row.paid() == 'expired') or (row.paid() == 'paid')):
            dbRowCount = (dbRowCount + 1)
    self.compareRowCount(dbRowCount)
