</div> <!-- noteTxt -->
</td></tr><tr><td colspan=2 class="tblHeader">
<h3>Tax</h3></td></tr>
<tr><td colspan=2>
<p><i>Provided tax rates are used to create database views. As such,
descriptions should be DB-legal syntax (e.g., no spaces). A rate of
0% with ID 0 is automatically included. Enter exact values - e.g.,
0.05 to represent 5%.</i></p></td></tr>
<tr><td colspan=2>
<?php
$rates = array();
if ($gotDBs == 2) {
$sql = new \COREPOS\pos\lib\SQLManager(CoreLocal::get('localhost'), CoreLocal::get('DBMS'), CoreLocal::get('tDatabase'), CoreLocal::get('localUser'), CoreLocal::get('localPass'));
if (CoreLocal::get('laneno') == 0 && CoreLocal::get('laneno') !== '') {
// server-side rate table is in op database
$sql = new \COREPOS\pos\lib\SQLManager(CoreLocal::get('localhost'), CoreLocal::get('DBMS'), CoreLocal::get('pDatabase'), CoreLocal::get('localUser'), CoreLocal::get('localPass'));
}
if ($sql->table_exists('taxrates')) {
$ratesR = $sql->query("SELECT id,rate,description FROM taxrates ORDER BY id");
while ($row = $sql->fetch_row($ratesR)) {
$rates[] = array($row[0], $row[1], $row[2]);
}
}
}
echo "<table><tr><th>ID</th><th>Rate</th><th>Description</th></tr>";
foreach ($rates as $rate) {
printf("<tr><td>%d</td><td><input type=text name=TAX_RATE[] value=\"%f\" /></td>\n <td><input type=text name=TAX_DESC[] value=\"%s\" /></td></tr>", $rate[0], $rate[1], $rate[2]);
}
printf("<tr><td>(Add)</td><td><input type=text name=TAX_RATE[] value=\"\" /></td>\n <td><input type=text name=TAX_DESC[] value=\"\" /></td></tr></table>");
?>
</td></tr><tr><td colspan=2 class="submitBtn">
body {
line-height: 1.5em;
}
</style>
</head>
<body>
<?php
include 'tabs.php';
?>
<div id="wrapper">
<h2>IT CORE Lane Installation: Sample Data</h2>
<form action=extra_data.php method=post>
<div class="alert success"><b>
<?php
$db = new \COREPOS\pos\lib\SQLManager(CoreLocal::get('localhost'), CoreLocal::get('DBMS'), CoreLocal::get('pDatabase'), CoreLocal::get('localUser'), CoreLocal::get('localPass'));
if (isset($_REQUEST['employees'])) {
echo "Loading employees";
$db->query("TRUNCATE TABLE employees");
InstallUtilities::loadSampleData($db, 'employees');
} elseif (isset($_REQUEST['custdata'])) {
echo "Loading custdata";
$db->query("TRUNCATE TABLE custdata");
InstallUtilities::loadSampleData($db, 'custdata');
} elseif (isset($_REQUEST['products'])) {
echo "Loading products";
$db->query("TRUNCATE TABLE products");
InstallUtilities::loadSampleData($db, 'products');
} elseif (isset($_REQUEST['tenders'])) {
echo "Loading tenders";
$db->query("TRUNCATE TABLE tenders");