echo "<h5>District : {$res["District"]}</h5>";
echo "<h5>State : {$res["State"]}</h5>";
echo "<h4>Phone : {$res["Phone"]} </h4>";
echo "<h4>Email : {$res["Email"]} </h4>";
echo "<h4>Pending Amount : {$amt} </h4>";
//BILL RECORDS
$sql = "Select Date,Bill_ID,Amount from bill_record where Cust_ID={$_GET['query']}";
$res = $mysqli->query($sql);
if ($res->num_rows > 0) {
echo "<h3>Bill Records for {$cname} : </h3>";
table_bill();
while ($row = $res->fetch_assoc()) {
bill_details($row);
}
end_table();
} else {
echo "No Bill Records for {$cname} Yet";
}
//Payment Records
$sql = "Select Date,Payment_ID,Amount from payment_record where Cust_ID={$_GET['query']}";
$res = $mysqli->query($sql);
if ($res->num_rows > 0) {
echo "<h3>Payment Records for {$cname} : </h3>";
table_pay();
while ($row = $res->fetch_assoc()) {
pay_details($row);
}
end_table();
} else {
echo "No Payment Records for {$cname} Yet";
}
table_ask_close();
break;
case 'close':
$err = table_close($_SESSION['sourceid']);
status_report('CLOSE', $err);
if (!$err) {
table_closed_interface();
} else {
orders_list();
}
break;
case 'closed':
table_closed_interface();
break;
case 'pay':
$err = table_pay($start_data['paid']);
status_report('PAYMENT', $err);
$err = table_clear();
status_report('CLEARING', $err);
table_cleared_interface();
break;
case 'clear':
if (!$err) {
table_cleared_interface();
} else {
table_closed_interface();
}
break;
case 'none':
break;
default:
function table_closed_interface_pos()
{
global $tpl;
date_default_timezone_set(get_conf(__FILE__, __LINE__, "default_timezone"));
if (bill_orders_to_print($_SESSION['sourceid'])) {
$_SESSION['select_all'] = 1;
$err = bill_select_pos();
if ($err) {
error_display($err);
}
return 0;
}
$tpl->set_waiter_template_file('closed_table_pos');
$paid = get_db_data(__FILE__, __LINE__, $_SESSION['common_db'], 'sources', "paid", $_SESSION['sourceid']);
$total = table_total($_SESSION['sourceid']);
$discount = get_db_data(__FILE__, __LINE__, $_SESSION['common_db'], 'sources', 'discount', $_SESSION['sourceid']);
if ($total == 0 && $paid == 0) {
$err = table_pay(1);
status_report('PAYMENT', $err);
$paid = get_db_data(__FILE__, __LINE__, $_SESSION['common_db'], 'sources', "paid", $_SESSION['sourceid']);
}
$tmp = navbar_tables_only_pos();
$user = new user($_SESSION['userid']);
if ($user->level[USER_BIT_CASHIER]) {
$tmp = navbar_empty_pos();
}
$tpl->assign('navbar', $tmp);
$tmp = '
' . ucfirst(phr('TABLE_TOTAL_DISCOUNTED')) . ': <b>' . country_conf_currency(true) . ' ' . $total . '</b>
';
if ($discount != 0) {
$discount = sprintf("%01.2f", abs($discount));
$tmp .= '
(' . ucfirst(phr('DISCOUNT')) . ': ' . country_conf_currency(true) . ' ' . $discount . ')';
}
$tmp .= '<br />' . "\n";
$tpl->assign('total', $tmp);
if ($paid) {
$tmp = '
<FORM ACTION="orders.php" METHOD=POST>
<INPUT TYPE="HIDDEN" NAME="command" VALUE="clear">
' . ucfirst(phr('PAID_ALREADY')) . '<br/>
' . ucfirst(phr('EMPTY_TABLE_EXPLAIN')) . '
<INPUT TYPE="submit" value="' . ucfirst(phr('EMPTY_TABLE_BUTTON')) . '">
</FORM>
';
$tmp .= '<br />' . "\n";
$tpl->assign('clear', $tmp);
}
// user is not allowed to pay, so don't display the button
if (!access_allowed(USER_BIT_MONEY)) {
return 0;
}
$tmp = '
<FORM ACTION="orders.php" METHOD=POST>
<INPUT TYPE="HIDDEN" NAME="command" VALUE="pay">
' . ucfirst(phr('PAID_ASK')) . '<br/>
';
if ($paid) {
$tmp .= '
<INPUT TYPE="hidden" name="data[paid]" value="0">
<INPUT TYPE="submit" value="' . ucfirst(phr('NOT_PAID_BUTTON')) . '">
<br/><br/>';
} else {
$tmp .= '
<INPUT TYPE="hidden" name="data[paid]" value="1">
<INPUT TYPE="submit" value="' . ucfirst(phr('PAID_BUTTON')) . '">
<br/><br/>';
}
$tmp .= '
</FORM>';
$tmp .= '<br />' . "\n";
$tpl->assign('pay', $tmp);
return 0;
}
