<?php
if ($_SERVER["REQUEST_METHOD"] === "POST") {

 if (isset($_POST['data'])) {
     
    $projectid = isset($_POST['data']) ? $_POST['data'] : 'No project id provided';

    $currentDirectory = __DIR__;
    $parentDirectory = dirname($currentDirectory);


    // Check if the projects.db file exists, and if not, create it
    $dbFile = $parentDirectory . '/invoices/database/projects.db';

    if (!file_exists($dbFile)) {
        $db = new SQLite3($dbFile);

        if (!$db) {
            die("Failed to load database file.");
           
        }

        $db->close();
    } else {
        $db = new SQLite3($dbFile);

        if (!$db) {
            die("Database connection failed: " . $db->lastErrorMsg());
            
        }
    }
    
        $query = "SELECT id, projectname, clientprogress FROM projects";
        $result = $db->query($query);
        
        $projectprogress = "";
        
        while ($row = $result->fetchArray(SQLITE3_ASSOC)) {

        if ($projectid == $row['id']) {
            
            $projectprogress = $row['clientprogress'];
        }
        }
        
		echo json_encode(['successfull' => $projectprogress]);
        
        
 } else {
		$successfull = "Not Successfull";
		echo json_encode(['successfull' => $successfull]);
    }
	
	  
}
?>