CORE POS - IS4C
The CORE POS front end
/var/www/html/git/IS4C/pos/is4c-nf/lib/Notifier.php

Show current member IOU balance

class MemBalanceNotifier extends Notifier { public function draw() { if (CoreLocal::get('memberID') == 0 || CoreLocal::get('memberID') == CoreLocal::get('defaultNonMem')) { return ''; }

    $db = Database::pDataConnect();

$query = $db->prepare_statement('SELECT Balance FROM custdata WHERE CardNo=?'); $result = $db->exec_statement($query, array(CoreLocal::get('memberID')));

non-valid member number apparently if ($db->num_rows($result) == 0) { return ''; }

$row = $db->fetch_row($result);

return sprintf('

Balance $%.2f

', $row['Balance']);

} }