exec($createQuery);
if (!$db->exec($createQuery)) {
die("Failed to create the 'projects' table.");
}
$db->close();
} else {
$db = new SQLite3($dbFile);
if (!$db) {
die("Database connection failed: " . $db->lastErrorMsg());
}
}
// echo "";
// Function to fetch and display data
function displayData($db) {
$clientId = isset($_GET['client-id']) ? $_GET['client-id'] : 'No client id provided';
$ClientIDNumber = base64_decode($clientId);
$ClientIDNumber = intval($ClientIDNumber);
$query = "SELECT id, projectname, erfno, allotment, client, clientid, clientprogress FROM projects";
$result = $db->query($query);
$projectNameUpdate = $row['projectname'];
$projectNameUpdate = str_replace('-LBR', '&', $projectNameUpdate);
$projectName = $projectNameUpdate;
$_SESSION['selectedName'] = $projectName;
if ($ClientId == 'No client id provided'){
//////////////////
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
$projectData = $row['clientprogress'];
$dataParts = explode('«', $projectData );
$projectOverallProgress = $dataParts[3];
$projectNumber = $dataParts[2];
$overallProgress = str_replace("%", "", $projectOverallProgress);
$projectNameUpdate = $row['projectname'];
$projectNameUpdate = str_replace('-LBR', '&', $projectNameUpdate);
if ($overallProgress == 100){
} else {
$projectId = $row['id'];
echo "";
echo "| " . $projectNameUpdate . " | ";
echo "" . $row['erfno'] . " | ";
echo "" . $row['allotment'] . " | ";
echo "" . $row['clientid'] . " | ";
echo "" . $row['clientprogress'] . " | ";
echo "" . $projectNumber . " | ";
echo "
";
}
}
////////////////
} else {
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
$projectData = $row['clientprogress'];
$dataParts = explode('«', $projectData );
$projectOverallProgress = $dataParts[3];
$projectNumber = $dataParts[2];
$overallProgress = str_replace("%", "", $projectOverallProgress);
if ($overallProgress == 100){
} else {
if ($ClientIDNumber == $row['clientid']){
$projectNameUpdate = $row['projectname'];
$projectNameUpdate = str_replace('-LBR', '&', $projectNameUpdate);
// echo '';
// echo '';
$projectId = $row['id'];
echo "";
echo "| " . $projectNameUpdate . " | ";
echo "" . $row['erfno'] . " | ";
echo "" . $row['allotment'] . " | ";
echo "" . $row['clientid'] . " | ";
echo "" . $row['clientprogress'] . " | ";
echo "" . $projectNumber . " | ";
echo "
";
}
}
} // end of while
}
}
// Function to fetch and display data
function displayDataCompleted($db) {
$clientId = isset($_GET['client-id']) ? $_GET['client-id'] : 'No client id provided';
$ClientIDNumber = base64_decode($clientId);
$ClientIDNumber = intval($ClientIDNumber);
$query = "SELECT id, projectname, erfno, allotment, client, clientid, clientprogress FROM projects";
$result = $db->query($query);
$projectNameUpdate = $row['projectname'];
$projectNameUpdate = str_replace('-LBR', '&', $projectNameUpdate);
$_SESSION['selectedName'] = $projectNameUpdate;
if ($ClientId == 'No client id provided'){
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
$projectData = $row['clientprogress'];
$dataParts = explode('«', $projectData );
$projectOverallProgress = $dataParts[3];
$projectNumber = $dataParts[2];
$overallProgress = str_replace("%", "", $projectOverallProgress);
//echo '';
if ($overallProgress == 100.00){
if ($ClientIDNumber == $row['clientid']){
$projectId = $row['id'];
$projectNameUpdate = $row['projectname'];
$projectNameUpdate = str_replace('-LBR', '&', $projectNameUpdate);
echo "";
echo "| " . $projectNameUpdate . " | ";
echo "" . $row['erfno'] . " | ";
echo "" . $row['allotment'] . " | ";
echo "" . $row['clientid'] . " | ";
echo "" . $row['clientprogress'] . " | ";
echo "" . $projectNumber . " | ";
echo "
";
}
}
}
}
}
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["update"])) {
$updatedData = $_POST["updatedData"];
$projectId = $_POST["projectId"];
$updateQuery = "UPDATE projects SET projectname = :projectname, erfno = :erfno, allotment = :allotment, client = :client WHERE id = :id";
$stmt = $db->prepare($updateQuery);
if (!$stmt) {
die("Prepare failed: " . $db->lastErrorMsg());
}
$stmt->bindValue(':projectname', $updatedData['projectname'], SQLITE3_TEXT);
$stmt->bindValue(':erfno', $updatedData['erfno'], SQLITE3_TEXT);
$stmt->bindValue(':allotment', $updatedData['allotment'], SQLITE3_TEXT);
$stmt->bindValue(':client', $updatedData['client'], SQLITE3_TEXT);
$stmt->bindValue(':id', $projectId, SQLITE3_INTEGER);
$result = $stmt->execute();
if (!$result) {
die("Execute failed: " . $db->lastErrorMsg());
}
// Close the prepared statement
$stmt->close();
}
?>
Projects
ACTIVE PROJECTS
| Project Name: |
Erf No.: |
Allotment: |
COMPLETED PROJECTS
| Project Name: |
Erf No.: |
Allotment: |
close();
?>
close();
?>