CORE POS - IS4C
The CORE POS front end
|
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('
', $row['Balance']);
} }