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, clientid FROM figures";
$result = $db->query($query);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
if ($row['status'] == "unpaid") {
$clientId = isset($_GET['client-id']) ? $_GET['client-id'] : 'No tracking number provided';
$clientIdDecode = base64_decode($clientId);
if (intval($clientIdDecode) == $row['clientid']) {
$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 "" . $row['clientid'] . " | ";
// echo ' | ';
// echo ' | ';
// echo ' | ';
echo "
";
}
}
}
}
function displayDataForPaid($db) {
$query = "SELECT id, projectname, invoicefull, createdby, createdate, totalvalue, status, clientid FROM figures";
$result = $db->query($query);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
if ($row['status'] == "paid") {
$clientId = isset($_GET['client-id']) ? $_GET['client-id'] : 'No tracking number provided';
$clientIdDecode = base64_decode($clientId);
//echo "";
if (intval($clientIdDecode) == $row['clientid']) {
$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 "" . $row['clientid'] . " | ";
// echo ' | ';
// echo ' | ';
// echo ' | ';
echo "
";
}
}
}
}
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["update"])) {
$updatedData = $_POST["updatedData"];
$projectId = $_POST["projectId"];
// $_SESSION['invoiceNumber'] = $invoiceNumber
}
?>
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();
?>