/**
* This function displays all Jobs in the system
*/
function displayAllJobs()
{
$field = 'JobID';
$sort = 'ASC';
if (isset($_GET['sorting'])) {
if ($_GET['sorting'] == 'ASC') {
$sort = 'ASC';
} else {
$sort = 'DESC';
}
}
if (isset($_GET['field'])) {
switch ($_GET['field']) {
case "JobTitle":
$field = 'JobTitle';
break;
case "MinSalary":
$field = 'MinSalary';
break;
case "MaxSalary":
$field = 'MaxSalary';
break;
default:
$field = 'JobID';
}
}
global $db_conn;
$stmt = mysqli_stmt_init($db_conn);
$sql = "SELECT * FROM `jobs` ORDER BY {$field} {$sort}";
if (!mysqli_stmt_prepare($stmt, $sql)) {
print "Failed to prepare statement\n";
} else {
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
mysqli_stmt_close($stmt);
?>
<h1>Jobs</h1>
<br/>
<input type="button" onclick="document.location.href='?action=addJob';" value="Add Job" />
<br/>
<br/>
<table>
<tr>
<th>Job ID <br/> <?php
echo parseSorting("jobs", "JobID", $field, $sort);
?>
</th>
<th>Title <br/> <?php
echo parseSorting("jobs", "JobTitle", $field, $sort);
?>
</th>
<th>Minimum Salary <br/> <?php
echo parseSorting("jobs", "MinSalary", $field, $sort);
?>
</th>
<th>Maximum Salary <br/> <?php
echo parseSorting("jobs", "MaxSalary", $field, $sort);
?>
</th>
<th>Action</th>
</tr>
<?php
$count = 1;
while ($row = mysqli_fetch_assoc($result)) {
$count++;
?>
<tr <?php
if ($count % 2 == 0) {
echo "class=\"highlight\" ";
}
?>
>
<td><?php
echo $row['JobID'];
?>
</td>
<td><?php
echo $row['JobTitle'];
?>
</td>
<td><?php
echo $row['MinSalary'];
?>
</td>
<td><?php
echo $row['MaxSalary'];
?>
</td>
<td>
<a href="index.php?action=editJob&id=<?php
echo $row['JobID'];
?>
">Edit</a>|<a class="delete" href="javascript:confirmAction('Are you sure?', 'index.php?action=deleteJob&id=<?php
echo $row['JobID'];
?>
');">Remove</a>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
}
/**
* This is a template rendering function. As such it
* serves illustrative purposes and in general needs to
* be configured for specific needs.
*
* This function makes a report of all the records in the
* Jobs table. It outputs HTML and can sort records in the
* table based on a predefined field and sortation order.
*/
function displayAllJobs()
{
global $db_conn;
#references connection to the database
$field = 'JobID';
#default sort column
$sort = 'ASC';
#default sorting order
// Set the sortation order requested via the URL
if (isset($_GET['sorting'])) {
if ($_GET['sorting'] == 'ASC') {
$sort = 'ASC';
} else {
$sort = 'DESC';
}
}
// Set the sortation field requested by URL
// on which soration should be applied
if (isset($_GET['field'])) {
switch ($_GET['field']) {
case "JobTitle":
$field = 'JobTitle';
break;
case "MinSalary":
$field = 'MinSalary';
break;
case "MaxSalary":
$field = 'MaxSalary';
break;
default:
$field = 'JobID';
}
}
// initializes a statement and return an object for use
// with mysqli_stmt_prepare
$stmt = mysqli_stmt_init($db_conn);
// the query that should be parsed
$sql = "SELECT * FROM `jobs` ORDER BY {$field} {$sort}";
if (!mysqli_stmt_prepare($stmt, $sql)) {
// if things go wrong we sent a message to the screen
add_to_message_stack("Query could not be parsed. This message is logged", true);
// and a message to the system log. Note we do not give information
// about SQL to the user.
log_message("Query could not be parsed: " . $sql);
} else {
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
mysqli_stmt_close($stmt);
?>
<h1>Jobs</h1>
<br/>
<input type="button" onclick="document.location.href='?action=addJob';" value="Add Job" />
<br/>
<br/>
<table>
<tr>
<th>Job ID <br/> <?php
echo parseSorting("jobs", "JobID", $field, $sort);
?>
</th>
<th>Title <br/> <?php
echo parseSorting("jobs", "JobTitle", $field, $sort);
?>
</th>
<th>Minimum Salary <br/> <?php
echo parseSorting("jobs", "MinSalary", $field, $sort);
?>
</th>
<th>Maximum Salary <br/> <?php
echo parseSorting("jobs", "MaxSalary", $field, $sort);
?>
</th>
<th>Action</th>
</tr>
<?php
$count = 1;
while ($row = mysqli_fetch_assoc($result)) {
$count++;
?>
<tr <?php
if ($count % 2 == 0) {
echo "class=\"highlight\" ";
}
?>
>
<td><?php
echo $row['JobID'];
?>
</td>
<td><?php
echo $row['JobTitle'];
?>
</td>
<td><?php
echo $row['MinSalary'];
?>
</td>
<td><?php
echo $row['MaxSalary'];
?>
</td>
<td>
<a href="index.php?action=editJob&id=<?php
echo $row['JobID'];
?>
">Edit</a>|<a class="delete" href="javascript:confirmAction('Are you sure?', 'index.php?action=deleteJob&id=<?php
echo $row['JobID'];
?>
');">Remove</a>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
}
/**
* This function shows all the employees
*/
function displayAllEmployees()
{
$field = 'EmployeeID';
$sort = 'ASC';
if (isset($_GET['sorting'])) {
if ($_GET['sorting'] == 'ASC') {
$sort = 'ASC';
} else {
$sort = 'DESC';
}
}
if (isset($_GET['field'])) {
switch ($_GET['field']) {
case "FirstName":
$field = 'FirstName';
break;
case "LastName":
$field = 'LastName';
break;
case "Email":
$field = 'Email';
break;
case "PhoneNumber":
$field = 'PhoneNumber';
break;
case "HireDate":
$field = 'HireDate';
break;
case "JobID":
$field = 'JobID';
break;
case "Salary":
$field = 'Salary';
break;
case "CommissionPCT":
$field = 'CommissionPCT';
break;
case "ManagerID":
$field = 'ManagerID';
break;
case "DepartmentID":
$field = 'DepartmentID';
break;
default:
$field = 'EmployeeID';
}
}
global $db_conn;
$stmt = mysqli_stmt_init($db_conn);
$sql = "SELECT * FROM `employees` ORDER BY {$field} {$sort}";
if (!mysqli_stmt_prepare($stmt, $sql)) {
print "Failed to prepare statement\n";
} else {
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
mysqli_stmt_close($stmt);
?>
<h1>Employees</h1>
<br/>
<input type="button" onclick="document.location.href='?action=addEmployee';" value="Add Employee" />
<br/>
<br/>
<table>
<tr>
<th>EmployeeID <br/> <?php
echo parseSorting("employees", "EmployeeID", $field, $sort);
?>
</th>
<th>FirstName <br/> <?php
echo parseSorting("employees", "FirstName", $field, $sort);
?>
</th>
<th>Lastname <br/> <?php
echo parseSorting("employees", "LastName", $field, $sort);
?>
</th>
<th>Email <br/> <?php
echo parseSorting("employees", "Email", $field, $sort);
?>
</th>
<th>Phone <br/> <?php
echo parseSorting("employees", "PhoneNumber", $field, $sort);
?>
</th>
<th>Hire Date <br/> <?php
echo parseSorting("employees", "HireDate", $field, $sort);
?>
</th>
<th>JobID <br/> <?php
echo parseSorting("employees", "JobID", $field, $sort);
?>
</th>
<th>Salary <br/> <?php
echo parseSorting("employees", "Salary", $field, $sort);
?>
</th>
<th>Commission PCT <br/> <?php
echo parseSorting("employees", "CommissionPCT", $field, $sort);
?>
</th>
<th>ManagerID <br/> <?php
echo parseSorting("employees", "JobTitle", $field, $sort);
?>
</th>
<th>DepartmentID <br/> <?php
echo parseSorting("employees", "ManagerID", $field, $sort);
?>
</th>
<th>Action</th>
</tr>
<?php
$count = 1;
while ($row = mysqli_fetch_assoc($result)) {
$count++;
?>
<tr <?php
if ($count % 2 == 0) {
echo "class=\"highlight\" ";
}
?>
>
<td><?php
echo $row['EmployeeID'];
?>
</td>
<td><?php
echo $row['FirstName'];
?>
</td>
<td><?php
echo $row['LastName'];
?>
</td>
<td><?php
echo $row['Email'];
?>
</td>
<td><?php
echo $row['PhoneNumber'];
?>
</td>
<td><?php
echo date("d-m-Y", strtotime($row['HireDate']));
?>
</td>
<td><?php
echo $row['JobID'];
?>
</td>
<td><?php
echo $row['Salary'];
?>
</td>
<td><?php
echo $row['CommissionPCT'];
?>
</td>
<td><?php
echo $row['ManagerID'];
?>
</td>
<td><?php
echo $row['DepartmentID'];
?>
</td>
<td>
<a href="index.php?action=editEmployee&id=<?php
echo $row['EmployeeID'];
?>
">Edit</a>|<a class="delete" href="javascript:confirmAction('Are you sure?', 'index.php?action=deleteEmployee&id=<?php
echo $row['EmployeeID'];
?>
');">Remove</a>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
}
/**
* This is a template rendering function. As such it
* serves illustrative purposes and in general needs to
* be configured for specific needs.
*
* This function makes a report of all the records in the
* Jobs table. It outputs HTML and can sort records in the
* table based on a predefined field and sortation order.
*/
function displayAllCustomers()
{
log_message("Backtrace: displayAllCustomers() called. ");
global $db_conn;
#references connection to the database
$field = 'Wcode';
#default sort column
$sort = 'ASC';
#default sorting order
// Set the sortation order requested via the URL
if (isset($_GET['sorting'])) {
if ($_GET['sorting'] == 'ASC') {
$sort = 'ASC';
} else {
$sort = 'DESC';
}
}
// Set the sortation field requested by URL
// on which soration should be applied
if (isset($_GET['field'])) {
switch ($_GET['field']) {
case "Wcode":
$field = 'Wcode';
break;
case "Naam":
$field = 'Naam';
break;
case "Adres":
$field = 'Adres';
break;
case "Plaats":
$field = 'Plaats';
break;
case "Telefoonnr":
$field = 'Plaats';
break;
default:
$field = 'JobID';
}
}
// initializes a statement and return an object for use
// with mysqli_stmt_prepare
$stmt = mysqli_stmt_init($db_conn);
// the query that should be parsed
$sql = "SELECT * FROM `winkel` ORDER BY {$field} {$sort}";
if (!mysqli_stmt_prepare($stmt, $sql)) {
// if things go wrong we sent a message to the screen
add_to_message_stack("Query could not be parsed. This message is logged", true);
// and a message to the system log. Note we do not give information
// about SQL to the user.
log_message("Query could not be parsed: " . $sql);
} else {
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
mysqli_stmt_close($stmt);
?>
<h1>Customers</h1>
<br/>
<input type="button" onclick="document.location.href='?action=displayAddCustomer';" value="Add Customer" />
<br/>
<br/>
<table>
<tr>
<th>Wcode <br/> <?php
echo parseSorting("showCustomers", "Wcode", $field, $sort);
?>
</th>
<th>Name <br/> <?php
echo parseSorting("showCustomers", "Naam", $field, $sort);
?>
</th>
<th>Address <br/> <?php
echo parseSorting("showCustomers", "Adres", $field, $sort);
?>
</th>
<th>Place <br/> <?php
echo parseSorting("showCustomers", "Plaats", $field, $sort);
?>
</th>
<th>Phone number <br/> <?php
echo parseSorting("showCustomers", "Telefoonnr", $field, $sort);
?>
</th>
<th>Action</th>
</tr>
<?php
$count = 1;
while ($row = mysqli_fetch_assoc($result)) {
$count++;
?>
<tr <?php
if ($count % 2 == 0) {
echo "class=\"highlight\" ";
}
?>
>
<td><?php
echo $row['Wcode'];
?>
</td>
<td><?php
echo $row['Naam'];
?>
</td>
<td><?php
echo $row['Adres'];
?>
</td>
<td><?php
echo $row['Plaats'];
?>
</td>
<td><?php
echo $row['Telefoonnr'];
?>
</td>
<td>
<a href="index.php?action=displayEditCustomer&id=<?php
echo $row['Wcode'];
?>
">Edit</a>|<a class="delete" href="javascript:confirmAction('Are you sure?', 'index.php?action=deleteCustomer&id=<?php
echo $row['Wcode'];
?>
');">Remove</a>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
}
/**
* This function displays all Locations in the system
*/
function displayAllLocations()
{
$field = 'LocationID';
$sort = 'ASC';
if (isset($_GET['sorting'])) {
if ($_GET['sorting'] == 'ASC') {
$sort = 'ASC';
} else {
$sort = 'DESC';
}
}
if (isset($_GET['field'])) {
switch ($_GET['field']) {
case "StreetAddress":
$field = 'StreetAddress';
break;
case "PostalCode":
$field = 'PostalCode';
break;
case "City":
$field = 'City';
break;
case "StateProvince":
$field = 'StateProvince';
break;
case "CountryID":
$field = 'CountryID';
break;
default:
$field = 'LocationID';
}
}
global $db_conn;
$stmt = mysqli_stmt_init($db_conn);
$sql = "SELECT * FROM `locations` ORDER BY {$field} {$sort}";
if (!mysqli_stmt_prepare($stmt, $sql)) {
print "Failed to prepare statement\n";
} else {
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
mysqli_stmt_close($stmt);
?>
<h1>Locations</h1>
<br/>
<input type="button" onclick="document.location.href='?action=addLocation';" value="Add Location" />
<br/>
<br/>
<table>
<tr>
<th> Location ID <br/> <?php
echo parseSorting("locations", "LocationID", $field, $sort);
?>
</th>
<th>Street Adress <br/> <?php
echo parseSorting("locations", "StreetAddress", $field, $sort);
?>
</th>
<th>Postalcode <br/> <?php
echo parseSorting("locations", "PostalCode", $field, $sort);
?>
</th>
<th>City <br/> <?php
echo parseSorting("locations", "City", $field, $sort);
?>
</th>
<th>State or Province <br/> <?php
echo parseSorting("locations", "StateProvince", $field, $sort);
?>
</th>
<th>CountryID <br/> <?php
echo parseSorting("locations", "CountryID", $field, $sort);
?>
</th>
<th>Action</th>
</tr>
<?php
$count = 1;
while ($row = mysqli_fetch_assoc($result)) {
$count++;
?>
<tr <?php
if ($count % 2 == 0) {
echo "class=\"highlight\" ";
}
?>
>
<td><?php
echo $row['LocationID'];
?>
</td>
<td><?php
echo $row['StreetAddress'];
?>
</td>
<td><?php
echo $row['PostalCode'];
?>
</td>
<td><?php
echo $row['City'];
?>
</td>
<td><?php
echo $row['StateProvince'];
?>
</td>
<td><?php
echo $row['CountryID'];
?>
</td>
<td>
<a href="index.php?action=editLocation&id=<?php
echo $row['LocationID'];
?>
">Edit</a>|<a class="delete" href="javascript:confirmAction('Are you sure?', 'index.php?action=deleteLocation&id=<?php
echo $row['LocationID'];
?>
');">Remove</a>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
}