echo edit_checkbox('<th width="23"><input type="checkbox" id="select-all" accesskey="A" title="Select all [Alt+Shift+A]" class="tooltip"></th>', 6);
?>
<th>Sheet No.</th>
<th>Started date</th>
<th>Completed date</th>
<th>Status</th>
<th>Counted by</th>
</tr>
</thead>
<tbody>
<?php
while ($row_count = mysqli_fetch_array($result_count)) {
?>
<tr>
<?php
echo edit_checkbox('<td><input type="checkbox" name="checkbox[]" title="Select this item" class="checkbox tooltip" value="' . $row_count['countSheetID'] . '" id="' . $row_count['countSheetID'] . '"></td>', 6);
?>
<td><?php
echo $row_count['countSheetID'];
?>
</td>
<td><?php
echo $row_count['startdate'];
?>
</td>
<td><?php
echo $row_count['enddate'];
?>
</td>
<td>
<?php
$iFilteredTotal = $aResultFilterTotal[0];
/* Total data set length */
$sQuery = "\r\n\t\tSELECT COUNT(" . $sIndexColumn . ")\r\n\t\tFROM {$sTable}\r\n\t";
$rResultTotal = mysql_query($sQuery, $gaSql['link']) or die(mysql_error());
$aResultTotal = mysql_fetch_array($rResultTotal);
$iTotal = $aResultTotal[0];
/*
* Output
*/
$output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
for ($i = 1; $i < count($aColumns); $i++) {
if ($aColumns[$i] == "version") {
/* Special output formatting for 'version' column */
$row[] = $aRow[$aColumns[$i]] == "0" ? '-' : $aRow[$aColumns[$i]];
} else {
if ($aColumns[$i] != ' ') {
/* General output */
$ids = $aRow['userID'];
$checkbox = edit_checkbox("<input type='checkbox' name='checkbox[]' class='checkbox' value='{$ids}' />", 1);
if ($checkbox) {
$row[0] = $checkbox;
}
$row[] = $aRow[$aColumns[$i]];
}
}
}
$output['aaData'][] = $row;
}
echo json_encode($output);
?>
<th>Name</th>
<th>Contact person</th>
<th>Address</th>
<th>Phone</th>
<th>Fax</th>
<th>Email</th>
</tr>
</thead>
<tbody>
<?php
while ($row_supplier = mysqli_fetch_array($result_supplier)) {
?>
<tr>
<?php
echo edit_checkbox('<td><input type="checkbox" name="checkbox[]" title="Select this supplier" class="checkbox tooltip" value="' . $row_supplier['supplierID'] . '" id="' . $row_supplier['supplierID'] . '"></td>', 4);
?>
<td><?php
echo $row_supplier['supplierName'];
?>
</td>
<td><?php
echo $row_supplier['supplierContactPerson'];
?>
</td>
<td><?php
echo $row_supplier['supplierAddress'];
?>
</td>
<td><?php
echo $row_supplier['supplierPhone'];
<th>Customer</th>
<th>Address</th>
<th>Sale date</th>
<th>Due date</th>
<th>Status</th>
<th>Total</th>
<th>Paid</th>
</tr>
</thead>
<tbody>
<?php
while ($row_sale = mysqli_fetch_array($result_sales)) {
?>
<tr class="view tooltip" title="Click to view">
<?php
echo edit_checkbox('<td><input type="checkbox" name="checkbox[]" title="Select this sale" class="checkbox tooltip" value="' . $row_sale['invoiceID'] . '" id="' . $row_sale['invoiceID'] . '"></td>', 7);
?>
<td><?php
echo $row_sale['invoiceID'];
?>
</td>
<td><?php
echo $row_sale['customerName'];
?>
</td>
<td><?php
echo $row_sale['customerAddress'];
?>
</td>
<td><?php
echo $row_sale['invoiceDate'];
$handle = opendir($dir);
$i = 1;
if ($handle) {
while (false !== ($entry = readdir($handle))) {
if ($entry != '.' && $entry != '..') {
?>
<tr <?php
if ($i % 2 === 0) {
echo 'class="even"';
} else {
echo 'class="odd"';
}
?>
>
<?php
echo edit_checkbox('<td><input type="checkbox" name="checkbox[]" title="Select this backup" class="checkbox tooltip" value="' . $entry . '" id="' . $entry . '"></td>', 3);
?>
<td><?php
echo date("d M, Y H:i:s", filemtime($dir . $entry));
?>
</td>
<td><?php
echo $entry;
?>
</td>
<td><?php
echo human_filesize(filesize($dir . $entry));
?>
</td>
<td><a href="backups/<?php
echo $entry;
?>
<h1>All Users of the System</h1>
<div class="hr-line"></div>
<form action="action.php" method="post" onSubmit="">
<div class="actions">
<?php
echo edit_button('<button class="edit tooltip" accesskey="E" title="Edit [Alt+Shift+E]" name="action[]" value="EDIT">Edit</button>', 1);
echo edit_button('<button class="block tooltip" accesskey="B" title="Block [Alt+Shift+B]" name="action[]" value="BLOCK" onClick="return confirm(\'Are you sure you want to block user(s)?\')">Block</button>', 1);
echo edit_button('<button class="activate tooltip" accesskey="I" title="Activate [Alt+Shift+I]" name="action[]" value="ACTIVATE" onClick="return confirm(\'Are you sure you want to activate user(s)\')">Activate</button>', 1);
?>
</div>
<table cellpadding="0" cellspacing="0" border="0" id="dataTable">
<thead>
<tr>
<?php
echo edit_checkbox('<th width="23"><input type="checkbox" id="select-all" accesskey="A" title="Select all [Alt+Shift+A]" class="tooltip"></th>', 1);
?>
<th>Full name</th>
<th>E-mail</th>
<th>Username</th>
<th>User group</th>
<th>Status</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</form>
<!-- end .content --></div>
<!-- end .container --></div>
?>
<th>Name</th>
<th>Contact person</th>
<th>Address</th>
<th>Phone</th>
<th>Fax</th>
<th>Email</th>
</tr>
</thead>
<tbody>
<?php
while ($row_customer = mysqli_fetch_array($result_customer)) {
?>
<tr>
<?php
echo edit_checkbox('<td><input type="checkbox" name="checkbox[]" title="Select this customer" class="checkbox tooltip" value="' . $row_customer['customerID'] . '" id="' . $row_customer['customerID'] . '"></td>', 8);
?>
<td><?php
echo $row_customer['customerName'];
?>
</td>
<td><?php
echo $row_customer['customerContactPerson'];
?>
</td>
<td><?php
echo $row_customer['customerAddress'];
?>
</td>
<td><?php
echo $row_customer['customerPhone'];