page_number = (!empty($_GET['page-id']) && is_numeric($_GET['page-id'])) ? SH_Secure($_GET['page-id']) : 1; $filter_keyword = (!empty($_GET['query'])) ? SH_Secure($_GET['query']) : ''; $db->pageLimit = 20; if(isset($_GET['approved']) && $_GET['approved'] == 1){ $db->where('approved',1); }else{ $db->where('approved',0); } if (!empty($filter_keyword)) { $sql = "( `username` LIKE '%$filter_keyword%' OR `email` LIKE '%$filter_keyword%' OR `first_name` LIKE '%$filter_keyword%' OR `ip_address` LIKE '%$filter_keyword%' OR `phone_number` LIKE '%$filter_keyword%' OR `last_name` LIKE '%$filter_keyword%' )"; $mediafiles = $db->orderBy('approved_at', 'DESC')->orderBy('id', 'DESC')->objectbuilder()->paginate('bank_receipts', $pt->page_number); } else { $mediafiles = $db->objectbuilder()->orderBy('approved_at', 'DESC')->orderBy('id', 'DESC')->paginate('bank_receipts', $pt->page_number); } if (($pt->page_number > $db->totalPages) && !empty($_GET['page-id'])) { header("Location: " . PT_LoadAdminLinkSettings('bank-receipts')); exit(); } $approved_count = $db->where('approved',1)->getValue('bank_receipts','count(id)'); $disapproved_count = $db->where('approved',0)->getValue('bank_receipts','count(id)'); $db->where('recipient_id',0)->where('admin',1)->where('seen',0)->where('type','bank')->update(T_NOTIFICATIONS,array('seen' => time())); ?>

Manage Bank Receipts

Approved receipts

Disapproved receipts

Manage bank receipts

No data available in table

'; }else { foreach ($mediafiles as $mediafilelist) { $pt->mediafilelist = $mediafilelist; $pt->mediafilelist->user = PT_UserData($mediafilelist->user_id); echo PT_LoadAdminPage('bank-receipts/list'); } } ?>

User	Type	Price	Created	Receipt	Action

page_number out of " . $db->totalPages; ?>