alert('$message');
window.location.href = '$redirectUrl';
";
exit();
} else {
setcookie($_COOKIE["username"], '', time() - 3600, '/');
header("Location: https://blackhoundenterprises.com/invoices/index.php");
exit();
}
}
} else {
setcookie($_COOKIE["username"], '', time() - 3600, '/');
header("Location: https://blackhoundenterprises.com/invoices/index.php");
exit();
}
if(isset($_GET['logout']) && $_GET['logout'] == 1) {
// Delete the cookie by setting its expiration time to a past value
setcookie("username", $_COOKIE["username"], time() - 3600, '/');
// Redirect to the login page or any other page
header("Location: https://blackhoundenterprises.com/invoices/index.php");
exit();
}
// Check if the projects.db file exists, and if not, create it
$dbFile2 = 'database/invoices.db';
if (!file_exists($dbFile2)) {
$db = new SQLite3($dbFile2);
if (!$db) {
die("Failed to create the database file.");
}
// Create the 'projects' table
$createQuery = "CREATE TABLE IF NOT EXISTS figures (
id INTEGER PRIMARY KEY AUTOINCREMENT,
projectname TEXT,
invoicefull TEXT,
createdby TEXT,
createdate TEXT,
totalvalue TEXT,
clientid INTEGER
)";
$db->exec($createQuery);
if (!$db->exec($createQuery)) {
die("Failed to create the 'invoices' table.");
}
$db->close();
} else {
$db = new SQLite3($dbFile2);
if (!$db) {
die("Database connection failed: " . $db->lastErrorMsg());
}
}
// Function to fetch and display data
function displayDataForDue($db) {
$query = "SELECT id, projectname, invoicefull, createdby, createdate, totalvalue, status FROM figures";
$result = $db->query($query);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
if ($row['status'] == "unpaid") {
$projectId = $row['invoicefull'];
$formattedTotalValue = preg_replace("/[^0-9.]+/", "", $row['totalvalue']);
echo "";
echo "| " . $row['projectname'] . " | ";
echo "" . $row['invoicefull'] . " | ";
echo "" . $row['createdby'] . " | ";
echo "" . $row['createdate'] . " | ";
echo "R" . $formattedTotalValue ." | ";
echo ' | ';
echo ' | ';
echo "
";
}
}
}
function displayDataForPaid($db) {
$query = "SELECT id, projectname, invoicefull, createdby, createdate, totalvalue, status FROM figures";
$result = $db->query($query);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
if ($row['status'] == "paid") {
$projectId = $row['invoicefull'];
$formattedTotalValue1 = preg_replace("/[^0-9.]+/", "", $row['totalvalue']);
echo "";
echo "| " . $row['projectname'] . " | ";
echo "" . $row['invoicefull'] . " | ";
echo "" . $row['createdby'] . " | ";
echo "" . $row['createdate'] . " | ";
echo "R" . $formattedTotalValue1 ." | ";
echo ' | ';
echo ' | ';
echo "
";
}
}
}
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["update"])) {
$updatedData = $_POST["updatedData"];
$projectId = $_POST["projectId"];
}
?>
Invoices
INVOICES DUE
| Project Name: |
Invoice No. |
Created By: |
Created Date: |
Total Value: |
|
|
INVOICES PAID
| Project Name: |
Invoice No. |
Created By: |
Created Date: |
Total Value: |
|
|
close();
?>