<?php
session_start();

$currentDirectory = __DIR__;
$rootDirectory = dirname(dirname($currentDirectory));
$dbFileProjects = $rootDirectory . '/invoices/database/projects.db';
$dbFileInvoices = $rootDirectory . '/invoices/database/invoices.db';

// Initialize arrays to store data
$projectnamesRenders = [];
$totalInvoicesRenders = [];
$totalSumRenders = 0;  
$projectnamesArchi = [];
$totalInvoicesArchi = [];
$totalSumArchi = 0; 

try {
    
    
$dbFile = 'datalist.db';
$key = 'dewald_test'; // Replace with your actual encryption key

// Check if the database file exists
if (!file_exists($dbFile)) {
    // Initialize SQLite3 with SQLCipher for creating a new encrypted database
    $db = new SQLite3($dbFile);
    $db->exec("ATTACH DATABASE '{$dbFile}' AS encrypted KEY '{$key}'");
    $db->exec("CREATE TABLE invoices (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        projectname TEXT,
        invoicedate TEXT,
        movevalue TEXT,
        invoiceid TEXT,
        type TEXT,
        totalvalue TEXT)");

    // Detach the encrypted database
    $db->exec("DETACH DATABASE encrypted");
} else {
    
    // Connect to existing encrypted database
    $db = new SQLite3($dbFile);
    $db->exec("ATTACH DATABASE '{$dbFile}' AS encrypted KEY '{$key}'");
    $db->close();
    
    $pdoProjects = new PDO('sqlite:' . $dbFile);
    $pdoProjects->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


    // Query to count the number of rows in the projects table
    $queryCount = 'SELECT COUNT(*) as count FROM invoices';
    $statementCount = $pdoProjects->query($queryCount);
    $resultCount = $statementCount->fetch(PDO::FETCH_ASSOC);





    // Check if the count is zero
    if ($resultCount['count'] == 0) {
        
        
        

    // Connect to the SQLite database for invoices
    $pdoInvoices = new PDO('sqlite:' . $dbFileInvoices);
    $pdoInvoices->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Query to fetch invoices data
    $queryInvoices = 'SELECT * FROM figures';
    $statementInvoices = $pdoInvoices->query($queryInvoices);
    $resultsInvoices = $statementInvoices->fetchAll(PDO::FETCH_ASSOC);



    // Fetch project names
    foreach ($resultsInvoices as $row) {
        $rowID = $row['id'];
        $projectname = $row['projectname'];
        $statusofinvoice = $row['status'];

    if ($statusofinvoice =="paid"){
    
         // Check if the ID is already in the list
        if (!in_array($rowID, $processedIDs)) {
            // Add the ID to the list
            $processedIDs[] = $rowID;

            // Check if the project name contains 'render'
            if (stripos($projectname, 'render') !== false) {
                $projectnamesRenders[] = $projectname;
            } else {
                $projectnamesArchi[] = $projectname;
            }
        }   
    
    }

    }
    
    
    $processedIDsRenders = [];
    $processedIDsArchi = [];
    


    // Loop through each project name and fetch corresponding invoice totals
   foreach ($projectnamesRenders as $name1) {
        foreach ($resultsInvoices as $row2) {
            $projectname1 = $row2['projectname'];
            $rowIDRenders = $row2['id'];
            $statusofinvoice = $row2['status'];

            if ($statusofinvoice =="paid"){
             if (stripos($projectname1, $name1) !== false) {
                    
                if (!in_array($rowIDRenders, $processedIDsRenders)) {
                    
                // Add the ID to the list
                $processedIDsRenders[] = $rowIDRenders;   
                
                
                    $createdDate1 = $row2['createdate'];
                    $createdID1 = $row2['id'];
                    $totalvalue1 = str_replace(' ', '', ltrim($row2['totalvalue'], 'R'));
                    $totalInvoicesRenders[] = [
                        'projectname1' => $name1,
                        'createdDate1' => $createdDate1,
                        'splitFigures1' => "NO",
                        'createdID1' => $createdID1,
                        'Type1' => "renders",
                        'totalvalue1' => $totalvalue1
                    ];
                    
                     $totalSumRenders += floatval($totalvalue1); 
                    
    
                }
                
                
             }
            
        }
            
        }
    }
    
    
    foreach ($projectnamesArchi as $name2) {
        foreach ($resultsInvoices as $row3) {
         
          $projectname2 = $row3['projectname'];
          
         // Split the string by "-"
        $parts = explode("-", $projectname2);
        $firstPart = $parts[0];
        $rowIDsArchi = $row3['id'];
        
        $statusofinvoice = $row3['status'];

        if ($statusofinvoice =="paid"){
        
        if (stripos($projectname2, $firstPart) !== false) {
          
           if (stripos($name2, $projectname2) !== false) {
               
                if (!in_array($rowIDsArchi, $processedIDsArchi)) {
                    
                // Add the ID to the list
                $processedIDsArchi[] = $rowIDsArchi;  


               
                $createdDate2 = $row3['createdate'];
                $createdID2 = $row3['id'];
                $totalvalue2 = str_replace(' ', '', ltrim($row3['totalvalue'], 'R'));
                $totalInvoicesArchi[] = [
                    'projectname2' => $name2,
                    'createdDate2' => $createdDate2,
                    'splitFigures2' => "NO",
                    'createdID2' => $createdID2,
                    'Type2' => "architecture",
                    'totalvalue2' => $totalvalue2
                ];
                
             
                 $totalSumArchi += floatval($totalvalue2); 


                }

            }
            
        }
        
        }
        
        
        }
    
    }
    
        

        
        
    } else {
        
      // echo 'The database has entries';
        

        
    // Connect to the SQLite database for projects
    $pdoProjects = new PDO('sqlite:' . $dbFile);
    $pdoProjects->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Query to fetch projects data
    $queryProjects = 'SELECT * FROM invoices';
    $statementProjects = $pdoProjects->query($queryProjects);
    $resultsProjects = $statementProjects->fetchAll(PDO::FETCH_ASSOC);
        
    $uniqueInvoiceIds = array();    

        
    // Fetch project names
    foreach ($resultsProjects as $row) {
 
            $projectname = $row['projectname'];

            // Check if the project name contains 'render'
            if (stripos($projectname, 'render') !== false) {
                $projectnamesRenders[] = $projectname;
            } else {
                $projectnamesArchi[] = $projectname;
            }
            
            
            $invoiceidNum = $row['invoiceid'];
    
            // Check if the invoice ID is already in the array
            if (!in_array($invoiceidNum, $uniqueInvoiceIds)) {
                $uniqueInvoiceIds[] = $invoiceidNum;
            }
            
            


    }
        
        
    $processedIDsRenders = [];
    $processedIDsArchi = [];
        
    // Connect to the SQLite database for invoices
    $pdoInvoices = new PDO('sqlite:' . $dbFile);
    $pdoInvoices->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Query to fetch invoices data
    $queryInvoices = 'SELECT * FROM invoices';
    $statementInvoices = $pdoInvoices->query($queryInvoices);
    $resultsInvoices = $statementInvoices->fetchAll(PDO::FETCH_ASSOC);




    // Loop through each project name and fetch corresponding invoice totals
   foreach ($projectnamesRenders as $name1) {
        foreach ($resultsInvoices as $row2) {
            $projectname1 = $row2['projectname'];
            $rowIDRenders = $row2['invoiceid'];

        if (stripos($projectname1, $name1) !== false) {

                if (!in_array($rowIDRenders, $processedIDsRenders)) {
                    // Add the ID to the list
                    $processedIDsRenders[] = $rowIDRenders; 
  
        
                            $createdDate1 = $row2['invoicedate'];
                            $createdID1 = $row2['invoiceid'];
                            $movevalue1 = $row2['$movevalue'];
                            $idForEachRow1 = $row2['id'];
                            $type1 = $row2['type'];
                            $totalvalue1 = str_replace(' ', '', ltrim($row2['totalvalue'], 'R'));
                            $totalInvoicesRenders[] = [
                                'id1' => $idForEachRow1,
                                'projectname1' => $name1,
                                'createdDate1' => $createdDate1,
                                'splitFigures1' => $movevalue1,
                                'createdID1' => $createdID1,
                                'Type1' => "renders",
                                'totalvalue1' => $totalvalue1
                            ];
                            
                            $totalSumRenders += floatval($totalvalue1); 
                            
            
                }
                
                
        }
        }
            
            
        }

        
    foreach ($projectnamesArchi as $name2) {
        foreach ($resultsInvoices as $row3) {
         
          $projectname2 = $row3['projectname'];
          
         // Split the string by "-"
        $parts = explode("-", $projectname2);
        $firstPart = $parts[0];
        
        
        $rowIDsArchi = $row3['invoiceid'];
        
        if (stripos($projectname2, $firstPart) !== false) {
          
           if (stripos($name2, $projectname2) !== false) {
               
                if (!in_array($rowIDsArchi, $processedIDsArchi)) {
                    
                // Add the ID to the list
                $processedIDsArchi[] = $rowIDsArchi;  

                $createdDate2 = $row3['invoicedate'];
                $createdID2 = $row3['invoiceid'];
                $movevalue2 = $row2['$movevalue'];
                $idForEachRow2 = $row3['id'];
                $type2 = $row3['type'];
                $totalvalue2 = str_replace(' ', '', ltrim($row3['totalvalue'], 'R'));
                $totalInvoicesArchi[] = [
                    'id2' => $idForEachRow2,
                    'projectname2' => $name2,
                    'createdDate2' => $createdDate2,
                    'splitFigures2' => $movevalue2,
                    'createdID2' => $createdID2,
                    'Type2' => "architecture",
                    'totalvalue2' => $totalvalue2
                ];
                
             
                 $totalSumArchi += floatval($totalvalue2); 


                }

            }
            
        }
        
        
        
        
        }
    
    }
    

/////// NOW CHECKING INVOICE 


$uniqueIdsForNewInvoices = array();  




    // Connect to the SQLite database for invoices
    $pdoInvoices = new PDO('sqlite:' . $dbFileInvoices);
    $pdoInvoices->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Query to fetch invoices data
    $queryInvoices = 'SELECT * FROM figures';
    $statementInvoices = $pdoInvoices->query($queryInvoices);
    $resultsInvoices2 = $statementInvoices->fetchAll(PDO::FETCH_ASSOC);


$projectnamesRenders2 = [];
$projectnamesArchi2 =  [];




        foreach ($resultsInvoices2 as $row2) {
            
            $rowID = $row2['id'];
            $projectname = $row2['projectname'];
            $statusofinvoice = $row2['status'];

            if ($statusofinvoice == "paid"){
            
                if (stripos($projectname, 'render') !== false) {
                    $projectnamesRenders2[] = $projectname;
                } else {
                    $projectnamesArchi2[] = $projectname;
                }
            
                if (!in_array($rowID, $uniqueInvoiceIds)) {
                        
                    // Add the ID to the list
                    $uniqueInvoiceIds[] = $rowID;  
                    $uniqueIdsForNewInvoices[] = $rowID;   
    
                }
           
           
            }
            
            
        }





    

    foreach ($uniqueIdsForNewInvoices as $invoiceid) {
        
    foreach ($resultsInvoices2 as $row2) {    
        
         $projectname = $row2['projectname'];
         $rowID = $row2['id'];
         $statusofinvoice = $row2['status'];
         
        if ($statusofinvoice == "paid"){

        if ($rowID == $invoiceid){
            
  
           if (stripos($projectname, 'render') !== false) {
               // $projectnamesRenders2[] = $projectname;
               // echo "Invoice ID:" . $invoiceid . " - $projectname". "<br>";

                            $processedIDsRenders[] = $rowIDRenders; 

                            $createdDate1 = $row2['createdate'];
                            $createdID1 = $row2['invoiceid'];
                            $movevalue1 = "NO";
                            $idForEachRow1 = $row2['id'];
                            $totalvalue1 = str_replace(' ', '', ltrim($row2['totalvalue'], 'R'));
                            $totalInvoicesRenders[] = [
                                'id1' => $idForEachRow1,
                                'projectname1' => $projectname,
                                'createdDate1' => $createdDate1,
                                'splitFigures1' => $movevalue1,
                                'createdID1' => $idForEachRow1,
                                'Type1' => "renders",
                                'totalvalue1' => $totalvalue1
                            ];
                            
                            $totalSumRenders += floatval($totalvalue1); 
                
                
                
                
                
 
                
            } else {

                $processedIDsArchi[] = $rowIDsArchi;  

                $createdDate2 = $row2['createdate'];
                $movevalue2 = "NO";
                $idForEachRow2 = $row2['id'];
                $totalvalue2 = str_replace(' ', '', ltrim($row2['totalvalue'], 'R'));
                $totalInvoicesArchi[] = [
                    'id2' => $idForEachRow2,
                    'projectname2' => $projectname,
                    'createdDate2' => $createdDate2,
                    'splitFigures2' => $movevalue2,
                    'createdID2' => $idForEachRow2,
                    'Type2' => "architecture",
                    'totalvalue2' => $totalvalue2
                ];
                
             
                 $totalSumArchi += floatval($totalvalue2); 
                

            }
                
                
            
        }

    }
    }  

}










    
       
       
 
                

    }
 
}

    

    
    
    
    
    
    
    
    
    
    
} catch (PDOException $e) {
    echo 'Connection or query failed: ' . $e->getMessage();
}






// Get the current year
$currentYear = date('Y');

// Generate years for the dropdown
$years = [];
for ($i = 0; $i < 4; $i++) {
    $years[] = $currentYear - $i;
}






?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Project Invoices</title>
        <style>
        
        
        table {
          font-family: 'Work Sans', sans-serif;
          border-collapse: collapse;
          width: 80%;
          margin: 0 auto;
        
        }
        th, td {
            border: 1px solid #000;
            padding: 8px;
            text-align: left; /* Align text to the left */
        }
        th {
            background-color: #f2f2f2;
        }
        
        
        body {
        margin: 0;
        font-family: 'Work Sans', sans-serif;
        font-weight: 400;
        
        }
        
        .headingForTable{
              margin-left: 10%;
        }
        
        .hidden {
                display: none;
        } 
        
        
        .context-menu {
            display: none;
            position: absolute;
            z-index: 1000;
            width: 150px;
            background-color: white;
            border: 1px solid #ccc;
            box-shadow: 2px 2px 5px rgba(0, 0, 0, 0.2);
        }
        
        .context-menu ul {
            list-style-type: none;
            margin: 0;
            padding: 0;
        }
        
        .context-menu ul li {
            padding: 10px;
            cursor: pointer;
        }
        
        .context-menu ul li:hover {
            background-color: #f0f0f0;
        }  
        
        .highlighted {
            background-color: #E8E8E8; /* Yellow background */
        }



        /* Split Popup Styling */
        .split-popup {
            display: none;
            position: fixed;
            z-index: 1001;
            width: 300px;
            background-color: white;
            border: 1px solid #ccc;
            box-shadow: 2px 2px 5px rgba(0, 0, 0, 0.2);
            padding: 20px;
            top: 50%;
            left: 50%;
            margin-top: -150px; /* Half of height */
            margin-left: -150px; /* Half of width */
        }
        


        .split-popup input[type="text"] {
            width: calc(100% - 20px);
            padding: 5px;
            margin-bottom: 10px;
        }

        .split-popup button {
            padding: 5px 10px;
        }



@media screen and (max-width: 600px) {

    td:nth-child(1) {
    font-size: 10px;
    white-space: nowrap; 
    overflow: hidden;    
    text-overflow: ellipsis; 
    max-width: 150px;
  }
  
  
   td:nth-child(2) {
    font-size: 10px;
    white-space: nowrap; 
    overflow: hidden;    
    text-overflow: ellipsis; 
    max-width: 100px;
  }
  

   th:nth-child(1) {
    font-size: 10px;
  }
  
   th:nth-child(2) {
    font-size: 10px;
  }
  

}
  
        
    </style>
</head>
<body>
    <br>
    
    
<!-- Dropdown for selecting year -->
<label for="YearSelect" class="headingForTable" >Select Year:</label>
<select id="YearSelect" onchange="updateList()">
    <option value="All">All</option>
    <?php foreach ($years as $year): ?>
    
        <option value="<?php echo $year; ?>"><?php echo $year; ?></option>

    <?php endforeach; ?>
</select>
    
    
    <h3 class="headingForTable" id="renderTitle">RENDERING PROJECTS</h3>

    <table id="tableRenders">
        <thead>
            <tr>
                <th>Project Name</th>
                <th class="hidden">created Date</th>
                <th class="hidden"></th>
                <th class="hidden"></th>
                <th class="hidden"></th>
                <th>Total Invoice Value</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($totalInvoicesRenders as $invoice1): ?>
                <tr data-id='<?php echo $invoice1['id1']; ?>'>
                    <td width="250"><?php echo $invoice1['projectname1']; ?></td>
                    <td class="hidden"><?php echo $invoice1['createdDate1']; ?></td>
                    <td id="moveValue" class="hidden">NO</td>
                    <td class="hidden"><?php echo $invoice1['createdID1']; ?></td>
                    <td class="hidden"><?php echo $invoice1['Type1']; ?></td>
                    <td width="150" style="text-align: right;"><div style="display: flex; justify-content: space-between; align-items: center;"><div class="left-align">R </div><div class="right-align"><?php echo str_replace(',', ' ', number_format($invoice1['totalvalue1'], 2)); ?></div></div></td>
                </tr>
            <?php endforeach; ?>
            <tr>
                <td style="background-color: #f2f2f2;"><strong>Total Sum</strong></td>
                <td class="hidden">N</td>
                <td class="hidden">N</td>
                <td class="hidden">N</td>
                <td class="hidden">N</td>
                <td style="background-color: #f2f2f2;"><div style="display: flex; justify-content: space-between; align-items: center;"><strong><div class="left-align">R </div></strong><strong><div class="right-align" id="renderTotal"><?php echo str_replace(',', ' ', number_format($totalSumRenders, 2)); ?></div></strong></div></td>
            </tr>
        </tbody>
    </table>
    
    <br>
    <br>
    
    <h3 class="headingForTable" id="archiTitle">ARCHITECTURE PROJECTS</h3>

    <table id="tableArchi">
        <thead>
            <tr>
                <th>Project Name</th>
                <th class="hidden">created Date</th>
                <th class="hidden"></th>
                <th class="hidden"></th>
                <th class="hidden"></th>
                <th>Total Invoice Value</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($totalInvoicesArchi as $invoice2): ?>
                <tr data-id='<?php echo $invoice2['id2']; ?>'>
                    <td width="250"><?php echo $invoice2['projectname2']; ?></td>
                    <td class="hidden"><?php echo $invoice2['createdDate2']; ?></td>
                    <td id="moveValue" class="hidden">NO</td>
                    <td class="hidden"><?php echo $invoice2['createdID2']; ?></td>
                    <td class="hidden"><?php echo $invoice2['Type2']; ?></td>
                    <td width="150" style="text-align: right;"><div style="display: flex; justify-content: space-between; align-items: center;"><div class="left-align">R </div><div class="right-align"><?php echo str_replace(',', ' ', number_format($invoice2['totalvalue2'], 2)); ?></div></div></td>
                </tr>
            <?php endforeach; ?>
            <tr>
              <td style="background-color: #f2f2f2;"><strong>Total Sum</strong></td>
              <td class="hidden">N</td>
              <td class="hidden">N</td>
              <td class="hidden">N</td>
              <td class="hidden">N</td>
              <td style="background-color: #f2f2f2;"><div style="display: flex; justify-content: space-between; align-items: center;"><strong><div class="left-align">R </div></strong><strong><div class="right-align" id="archiTotal"><?php echo str_replace(',', ' ', number_format($totalSumArchi, 2)); ?></div></strong></div></td>
            </tr>
        </tbody>
    </table>
    
    
    <br>
    <br>
    
    <div id="contextMenu" class="context-menu">
        <ul>
            <li id="delete">Delete</li>
            <li id="edit">Edit</li>
            <li id="split">Split figures</li>
        </ul>
    </div>

    <div id="splitPopup" class="split-popup">
        <label for="actualValue">Actual Value:</label>
        <input type="text" id="actualValue" name="actualValue">
        
        
        <label for="splitValue1">Architecture:</label>
        <input type="text" id="splitValue1" name="splitValue">
        
        <label for="splitValue2">Rendering:</label>
        <input type="text" id="splitValue2" name="splitValue">
        
        <br>
        <button id="splitConfirm">Confirm</button>
        <button id="splitCancel">Cancel</button>
    </div>




<script>





document.addEventListener('DOMContentLoaded', function() {
            
            const actualValueInput = document.getElementById('actualValue');
            const splitValue1Input = document.getElementById('splitValue1');
            const splitValue2Input = document.getElementById('splitValue2');
            const table = document.getElementById('tableArchi');
            
            function numberFormat(value) {
                
                        // Convert value to number and round to two decimal places
                        const roundedValue = Number(value).toFixed(2);
                    
                        // Add thousands separators
                        const parts = roundedValue.toString().split(".");
                        parts[0] = parts[0].replace(/\B(?=(\d{3})+(?!\d))/g, " ");
                    
                        return parts.join(".");
            }
            

            const contextMenu = document.getElementById('contextMenu');
            const splitPopup = document.getElementById('splitPopup');
            const splitValueInput = document.getElementById('actualValue');
            let targetRow;
            let previousRow;


if (table) {
table.addEventListener('contextmenu', function(event) {
    event.preventDefault();
    let targetCell = event.target.closest('td');
    if (targetCell) {
        let targetRow = targetCell.parentNode;

        // Remove highlighting from the previously clicked row
        if (previousRow) {
            previousRow.classList.remove('highlighted');
        }

        // Highlight the clicked row
        targetRow.classList.add('highlighted');

        // Store the clicked row as the previous row for next time
        previousRow = targetRow;

        // Calculate position using the row's position for Y and mouse position for X
        const rect = targetRow.getBoundingClientRect();
        let posX = event.clientX + 20;
        let posY = rect.top + window.scrollY - 80;

        // Check if the menu goes beyond the right edge of the viewport
        const contextMenu = document.getElementById('contextMenu'); // Replace with your actual context menu ID
        if (contextMenu) {
            if ((posX + contextMenu.offsetWidth) > window.innerWidth) {
                posX = event.clientX - contextMenu.offsetWidth - 10;
            }

            contextMenu.style.top = `${posY}px`;
            contextMenu.style.left = `${posX}px`;
            contextMenu.style.display = 'block';
        }
    }
});




table.addEventListener('click', function(event) {
                
                
                    const clickedRow = event.target.closest('tr'); // Get the closest <tr> element clicked

                    // Check if the clicked element is a table row and is not the same as the previous row
                    if (clickedRow && clickedRow !== previousRow) {
                        // Disable editing on the previously edited row
                        if (targetRow) {
                            
                            const cells = targetRow.querySelectorAll('td');
                            let contentEditableRemoved = false; // Flag to track if contenteditable was removed
                
                            cells.forEach(cell => {
                                if (cell.getAttribute('contenteditable') === 'true') {
                                    cell.removeAttribute('contenteditable');
                                    contentEditableRemoved = true; // Set flag to true if removed
                                }
                            });
                            
                            

                            // Alert only if contenteditable was removed
                            if (contentEditableRemoved) {
                                
                                
                                
                               // alert('Contenteditable attribute removed from the row.');
                                
                                    var targetRowId = targetRow.getAttribute('data-id');
                                    var targetprojectName = targetRow.cells[0].innerText;
                                    var targetcreatedDate = targetRow.cells[1].innerText;
                                    var targetFigures = targetRow.cells[2].innerText;
                                    var targetcreatedID = targetRow.cells[3].innerText;         
                                    var targetType1 = targetRow.cells[4].innerText;  
                                    var targetTotalValue = targetRow.cells[5].innerText; 
                                    
                                    let cleanedText = targetTotalValue.replace(/[\sR]/g, '');
                                    
                                    const formattedTargetTotalValue = numberFormat(cleanedText);
                                    
                                    var invoiceData3 = {
                                        id: targetRowId,
                                        projectname: targetprojectName,
                                        invoicedate: targetcreatedDate,
                                        movevalue: targetFigures,
                                        invoiceid: targetcreatedID,
                                        type: targetType1,
                                        totalvalue: formattedTargetTotalValue
                                        };
                                    
                                    
                                    UpdateRow(invoiceData3);
                            }
                            
                            
                    var total5 = 0;
                
                    // Iterate over each row in the table body
                    var rows5 = tableRenders.getElementsByTagName('tbody')[0].rows;
                    for (var i = 0; i < rows5.length; i++) {
                      var cell5 = rows5[i].cells[5]; // Column 6 (index 5)
                      var totalText5 = cell5.querySelector('.right-align').textContent.trim().replace('R', '').replace(' ', '').replace(/,/g, ''); // Extract text, remove 'R' and commas

                      var sub5= rows5[i].cells[4].textContent;
                      if (sub5 !== "N") {
                      
                      var value5 = parseFloat(totalText5); // Convert to float
                      total5 += value5; // Accumulate total
                      }
                      
                    }

                    const renderTotalsFormat5 = numberFormat(total5);
                    document.getElementById("renderTotal").textContent = renderTotalsFormat5; 

                    var total6 = 0;
                    const tableArchi6 = document.getElementById('tableArchi');
                
                    // Iterate over each row in the table body
                    var rows6 = tableArchi6.getElementsByTagName('tbody')[0].rows;
                    for (var i = 0; i < rows6.length; i++) {
                      var cell6 = rows6[i].cells[5]; // Column 6 (index 5)
                      var totalText6 = cell6.querySelector('.right-align').textContent.trim().replace('R', '').replace(' ', '').replace(/,/g, ''); // Extract text, remove 'R' and commas

                      
                      var sub6 = rows6[i].cells[4].textContent;
                      if (sub6 !== "N") {
                      
                      var value6 = parseFloat(totalText6); // Convert to float
                      total6 += value6; // Accumulate total
                      }

                    }
                

                    const ArchiTotalsFormat6 = numberFormat(total6);
                    // Update the total in the #archiTotal element
                    document.getElementById("archiTotal").textContent = ArchiTotalsFormat6; 

                    targetRow = null;
                    
                    
                    
                        } 
                    }
                    
                    

                
                if (event.target.tagName === 'TD') {
                    
                    if (previousRow) {
                        previousRow.classList.remove('highlighted');


                    } 
                    
                                targetRow = event.target.parentNode;
                                targetRow.classList.add('highlighted');
                                previousRow = targetRow;
   
                                
                } else {
                    
                    
                    if (targetRow) {
                            const cells = targetRow.querySelectorAll('td');

                            cells.forEach(cell => {
                                if (cell.getAttribute('class') === 'highlighted') {
                                    cell.removeAttribute('class');
                                }
                            });

                    }
                    


                    
       
                }


              if (!contextMenu.contains(event.target) && !splitPopup.contains(event.target)) {
                   contextMenu.style.display = 'none';
                    splitPopup.style.display = 'none';

                    if (previousRow) {
                        previousRow.classList.remove('highlighted');
                        
                        if (targetRow == previousRow ){
                        } else {
                            
                            const cells = previousRow.querySelectorAll('td');
                            cells.forEach(cell => {
                                if (cell.getAttribute('contenteditable') === 'true') {
                                    cell.removeAttribute('contenteditable');
                                }
                            });
                          
                        }
                        

                        
                        
                        

                    }

                   if (targetRow) {
                        targetRow.classList.remove('highlighted');
                        
                    }
       
       
       
       
       
                        
                }
       
});


}


if (tableRenders) {
    
    
   tableRenders.addEventListener('contextmenu', function(event) {
    event.preventDefault();
    let targetCell = event.target.closest('td');
    if (targetCell) {
        let targetRow = targetCell.parentNode;

        // Remove highlighting from the previously clicked row
        if (previousRow) {
            previousRow.classList.remove('highlighted');
        }

        // Highlight the clicked row
        targetRow.classList.add('highlighted');

        // Store the clicked row as the previous row for next time
        previousRow = targetRow;

        // Calculate position using the row's position for Y and mouse position for X
        const rect = targetRow.getBoundingClientRect();
        let posX = event.clientX + 20;
        let posY = rect.top + window.scrollY - 80;

        // Check if the menu goes beyond the right edge of the viewport
        const contextMenu = document.getElementById('contextMenu'); // Replace with your actual context menu ID
        if (contextMenu) {
            if ((posX + contextMenu.offsetWidth) > window.innerWidth) {
                posX = event.clientX - contextMenu.offsetWidth - 10;
            }

            contextMenu.style.top = `${posY}px`;
            contextMenu.style.left = `${posX}px`;
            contextMenu.style.display = 'block';
        }
    }
});




tableRenders.addEventListener('click', function(event) {
                
                
                    const clickedRow = event.target.closest('tr'); // Get the closest <tr> element clicked

                    // Check if the clicked element is a table row and is not the same as the previous row
                    if (clickedRow && clickedRow !== previousRow) {
                        // Disable editing on the previously edited row
                        if (targetRow) {
                            
                            const cells = targetRow.querySelectorAll('td');
                            let contentEditableRemoved = false; // Flag to track if contenteditable was removed
                
                            cells.forEach(cell => {
                                if (cell.getAttribute('contenteditable') === 'true') {
                                    cell.removeAttribute('contenteditable');
                                    contentEditableRemoved = true; // Set flag to true if removed
                                }
                            });
                            
                            

                            // Alert only if contenteditable was removed
                            if (contentEditableRemoved) {
                                
                                
                                
                               // alert('Contenteditable attribute removed from the row.');
                                
                                    var targetRowId = targetRow.getAttribute('data-id');
                                    var targetprojectName = targetRow.cells[0].innerText;
                                    var targetcreatedDate = targetRow.cells[1].innerText;
                                    var targetFigures = targetRow.cells[2].innerText;
                                    var targetcreatedID = targetRow.cells[3].innerText;         
                                    var targetType1 = targetRow.cells[4].innerText;  
                                    var targetTotalValue = targetRow.cells[5].innerText; 
                                    
                                    let cleanedText = targetTotalValue.replace(/[\sR]/g, '');
                                    
                                    const formattedTargetTotalValue = numberFormat(cleanedText);
                                    
                                    var invoiceData3 = {
                                        id: targetRowId,
                                        projectname: targetprojectName,
                                        invoicedate: targetcreatedDate,
                                        movevalue: targetFigures,
                                        invoiceid: targetcreatedID,
                                        type: targetType1,
                                        totalvalue: formattedTargetTotalValue
                                        };
                                    
                                    
                                    UpdateRow(invoiceData3);
                            }
                            
                            
                    var total5 = 0;
                
                    // Iterate over each row in the table body
                    var rows5 = tableRenders.getElementsByTagName('tbody')[0].rows;
                    for (var i = 0; i < rows5.length; i++) {
                      var cell5 = rows5[i].cells[5]; // Column 6 (index 5)
                      var totalText5 = cell5.querySelector('.right-align').textContent.trim().replace('R', '').replace(' ', '').replace(/,/g, ''); // Extract text, remove 'R' and commas

                      var sub5= rows5[i].cells[4].textContent;
                      if (sub5 !== "N") {
                      
                      var value5 = parseFloat(totalText5); // Convert to float
                      total5 += value5; // Accumulate total
                      }
                      
                    }

                    const renderTotalsFormat5 = numberFormat(total5);
                    document.getElementById("renderTotal").textContent = renderTotalsFormat5; 

                    var total6 = 0;
                    const tableArchi6 = document.getElementById('tableArchi');
                
                    // Iterate over each row in the table body
                    var rows6 = tableArchi6.getElementsByTagName('tbody')[0].rows;
                    for (var i = 0; i < rows6.length; i++) {
                      var cell6 = rows6[i].cells[5]; // Column 6 (index 5)
                      var totalText6 = cell6.querySelector('.right-align').textContent.trim().replace('R', '').replace(' ', '').replace(/,/g, ''); // Extract text, remove 'R' and commas

                      
                      var sub6 = rows6[i].cells[4].textContent;
                      if (sub6 !== "N") {
                      
                      var value6 = parseFloat(totalText6); // Convert to float
                      total6 += value6; // Accumulate total
                      }

                    }
                

                    const ArchiTotalsFormat6 = numberFormat(total6);
                    // Update the total in the #archiTotal element
                    document.getElementById("archiTotal").textContent = ArchiTotalsFormat6; 

                    targetRow = null;
                    
                    
                    
                        } 
                    }
                    
                    

               
                
                if (event.target.tagName === 'TD') {
                    
                    if (previousRow) {
                        previousRow.classList.remove('highlighted');


                    } 
                    
                                targetRow = event.target.parentNode;
                                targetRow.classList.add('highlighted');
                                previousRow = targetRow;
   
                                
                } else {
                    
                    
                    if (targetRow) {
                            const cells = targetRow.querySelectorAll('td');

                            cells.forEach(cell => {
                                if (cell.getAttribute('class') === 'highlighted') {
                                    cell.removeAttribute('class');
                                }
                            });

                    }
                    


                    
       
                }


              if (!contextMenu.contains(event.target) && !splitPopup.contains(event.target)) {
                   contextMenu.style.display = 'none';
                    splitPopup.style.display = 'none';

                    if (previousRow) {
                        previousRow.classList.remove('highlighted');
                        
                        if (targetRow == previousRow ){
                        } else {
                            
                            const cells = previousRow.querySelectorAll('td');
                            cells.forEach(cell => {
                                if (cell.getAttribute('contenteditable') === 'true') {
                                    cell.removeAttribute('contenteditable');
                                }
                            });
                          
                        }
                        

                        
                        
                        

                    }

                   if (targetRow) {
                        targetRow.classList.remove('highlighted');
                        
                    }
       
       
       
       
       
                        
                }
       
}); 
    
    
    
    
    
    
    
    
    
}




















































            document.getElementById('delete').addEventListener('click', function() {
                if (targetRow) {
                 //   targetRow.remove();
                   contextMenu.style.display = 'none';
                   targetRow.classList.remove('highlighted');
                   alert('delete action triggered');
                   
                   
                }
            });
            
            document.getElementById('edit').addEventListener('click', function() {
                if (targetRow) {
                    // Remove any existing highlighting or context menu display
                    contextMenu.style.display = 'none';
                    targetRow.classList.remove('highlighted');
            
                    // Make cells in targetRow editable
                    const cells = targetRow.querySelectorAll('td');
                    targetRow.cells[0].setAttribute('contenteditable', 'true');
                    targetRow.cells[5].setAttribute('contenteditable', 'true');
            
                    // Optionally, focus on the first editable cell for user convenience
                    if (cells.length > 0) {
                        cells[0].focus();
                    }
            
                  //  alert('Edit mode activated for the selected row.');
                }
                
                
                if (previousRow) {

                 //  alert('Here');
                   
                    contextMenu.style.display = 'none';
                    previousRow.classList.remove('highlighted');
            
                    // Make cells in targetRow editable
                    const cells = previousRow.querySelectorAll('td');
                    previousRow.cells[0].setAttribute('contenteditable', 'true');
                    previousRow.cells[5].setAttribute('contenteditable', 'true');
            
                    // Optionally, focus on the first editable cell for user convenience
                    if (cells.length > 0) {
                        cells[0].focus();
                    }
                   
                   
                }
                
                
                
                
            });

            
            
            

            document.getElementById('split').addEventListener('click', function() {
                if (targetRow) {
                    contextMenu.style.display = 'none';

                // Get the data from the fifth column (index 4) of the clicked row
                const splitValue = targetRow.cells[5].innerText;
                
                
                // Step 1: Remove 'R' character and spaces
                let cleanedString = splitValue.replace(/[R\s]/g, '');
                
                // Step 2: Convert to number with decimal
                let number = parseFloat(cleanedString);
                
                
                splitValueInput.value = number;

                // Center the split popup in the middle of the screen
                const posX = window.innerWidth / 2 - splitPopup.offsetWidth / 2;
                const posY = window.innerHeight / 2 - splitPopup.offsetHeight / 2;

                splitPopup.style.top = `${posY}px`;
                splitPopup.style.left = `${posX}px`;
                splitPopup.style.display = 'block';
                

                }
            });
            
            document.getElementById('splitConfirm').addEventListener('click', function() {
                splitPopup.style.display = 'none';
                targetRow.classList.remove('highlighted');
                
            if (!(splitValue1Input.value === "" || splitValue1Input.value === "0") && !(splitValue2Input.value === "" || splitValue2Input.value === "0")) {
              //  alert('Value is not Zero');
              
              
                const projectNameSplit = targetRow.cells[0].innerText;
                const createdDate = targetRow.cells[1].innerText;
                //const splitFigures = targetRow.cells[2].innerText;
                const createdID = targetRow.cells[3].innerText;         
                const Type1 = targetRow.cells[4].innerText;  

                const newRow1 = document.createElement('tr');
                const td11 = document.createElement('td');
                const td21 = document.createElement('td');
                const td31 = document.createElement('td');
                const td41 = document.createElement('td');
                const td51 = document.createElement('td');
                const td61 = document.createElement('td');

                td11.textContent = projectNameSplit + ' - Architecture'; // Adjust with actual content as needed
                td21.textContent = createdDate; // Adjust with actual content as needed
                td31.textContent = 'YES'; // Use split value or any other data
                td41.textContent = createdID; // Adjust with actual content as needed
                td51.textContent = Type1; // Adjust with actual content as needed
                
                
                const formattedSplitValue1 = numberFormat(splitValue1Input.value);
                td61.innerHTML = `
                    <div style="display: flex; justify-content: space-between; align-items: center;">
                        <div class="left-align">R </div>
                        <div class="right-align">${formattedSplitValue1}</div>
                    </div>
                `;

                // Add class names to the new row's cells
               // td11.classList.add('classname1');
                td21.classList.add('hidden');
                td31.classList.add('hidden');
                td41.classList.add('hidden');
                td51.classList.add('hidden');
               // td61.classList.add('classname6');

                newRow1.appendChild(td11);
                newRow1.appendChild(td21);
                newRow1.appendChild(td31);
                newRow1.appendChild(td41);
                newRow1.appendChild(td51);
                newRow1.appendChild(td61);

                // Insert the new row below the targetRow
                targetRow.parentNode.insertBefore(newRow1, targetRow.nextSibling);
              
                
                
                var targetMovevalue = targetRow.cells[2].innerText;
              
                // Loop through each row in the table, excluding the last row
                var invoiceData = {
                    invoiceid: createdID,
                    movevalue: targetMovevalue
                };
                

                DeleteOldEntryForSplit(invoiceData);
                targetRow.remove();
                
                

              /// RENDERS ROW
              
                const tableRenders = document.getElementById('tableRenders');
                const Type2 = "renders"; 

                const newRow2 = document.createElement('tr');
                const td12 = document.createElement('td');
                const td22 = document.createElement('td');
                const td32 = document.createElement('td');
                const td42 = document.createElement('td');
                const td52 = document.createElement('td');
                const td62 = document.createElement('td');

                td12.textContent = projectNameSplit + ' - Rendering'; // Adjust with actual content as needed
                td22.textContent = createdDate; // Adjust with actual content as needed
                td32.textContent = 'YES'; // Use split value or any other data
                td42.textContent = createdID; // Adjust with actual content as needed
                td52.textContent = Type2; // Adjust with actual content as needed
                
                
                const formattedSplitValue2 = numberFormat(splitValue2Input.value);
                td62.innerHTML = `
                    <div style="display: flex; justify-content: space-between; align-items: center;">
                        <div class="left-align">R </div>
                        <div class="right-align">${formattedSplitValue2}</div>
                    </div>
                `;

                // Add class names to the new row's cells
               // td11.classList.add('classname1');
                td22.classList.add('hidden');
                td32.classList.add('hidden');
                td42.classList.add('hidden');
                td52.classList.add('hidden');
               // td61.classList.add('classname6');

                newRow2.appendChild(td12);
                newRow2.appendChild(td22);
                newRow2.appendChild(td32);
                newRow2.appendChild(td42);
                newRow2.appendChild(td52);
                newRow2.appendChild(td62);


            
                const tbodyRenders = tableRenders.querySelector('tbody');
                const rows = tbodyRenders.querySelectorAll('tr');
                const secondLastRow = rows[rows.length - 2];
            
                // Insert the new row just above the second last row in tableRenders
                if (secondLastRow) {
                    tbodyRenders.insertBefore(newRow2, secondLastRow.nextSibling);
                } else {
                    tbodyRenders.appendChild(newRow2); // If there are fewer than 2 rows, simply append
                }
                

                var projectNameSplitRendering = projectNameSplit + ' - Rendering';
                
                var invoiceData1 = {
                    projectname: projectNameSplitRendering,
                    invoicedate: createdDate,
                    movevalue: td31.textContent,
                    invoiceid: createdID,
                    type: Type2,
                    totalvalue: formattedSplitValue2
                };


                var projectNameSplitArchi = projectNameSplit + ' - Architecture';

                var invoiceData2 = {
                    projectname: projectNameSplitArchi,
                    invoicedate: createdDate,
                    movevalue: td32.textContent,
                    invoiceid: createdID,
                    type: Type1,
                    totalvalue: formattedSplitValue1
                };
                
                
                var invoiceDataArray = [invoiceData1, invoiceData2];
                
                // Loop through the array and send data for each row
                invoiceDataArray.forEach(function(invoiceData) {
                    sendData(invoiceData);
                });
                



                
                
                    /// Recalculate the totals for both Tables
                

                    var total2 = 0;
                
                    // Iterate over each row in the table body
                    var rows3 = tableRenders.getElementsByTagName('tbody')[0].rows;
                    for (var i = 0; i < rows3.length; i++) {
                      var cell2 = rows3[i].cells[5]; // Column 6 (index 5)
                      var totalText2 = cell2.querySelector('.right-align').textContent.trim().replace('R', '').replace(' ', '').replace(/,/g, ''); // Extract text, remove 'R' and commas

                      var sub2= rows3[i].cells[4].textContent;
                      if (sub2 !== "N") {
                      
                      var value2 = parseFloat(totalText2); // Convert to float
                      total2 += value2; // Accumulate total
                      }
                      
                    }
                

                    const renderTotalsFormat = numberFormat(total2);
                    // Update the total in the #archiTotal element
                    document.getElementById("renderTotal").textContent = renderTotalsFormat; 


    
                    var total1 = 0;
                    const tableArchi = document.getElementById('tableArchi');
                
                    // Iterate over each row in the table body
                    var rows4 = tableArchi.getElementsByTagName('tbody')[0].rows;
                    for (var i = 0; i < rows4.length; i++) {
                      var cell1 = rows4[i].cells[5]; // Column 6 (index 5)
                      var totalText1 = cell1.querySelector('.right-align').textContent.trim().replace('R', '').replace(' ', '').replace(/,/g, ''); // Extract text, remove 'R' and commas

                      
                      var sub1= rows4[i].cells[4].textContent;
                      if (sub1 !== "N") {
                      
                      var value1 = parseFloat(totalText1); // Convert to float
                      total1 += value1; // Accumulate total
                      }

                    }
                

                    const ArchiTotalsFormat = numberFormat(total1);
                    // Update the total in the #archiTotal element
                    document.getElementById("archiTotal").textContent = ArchiTotalsFormat; 
    
    

                    sortTable('tableRenders');
                    sortTable('tableArchi');
                   


    
    
    
            } 
                            
                
                
            });

            document.getElementById('splitCancel').addEventListener('click', function() {
                splitPopup.style.display = 'none';
                targetRow.classList.remove('highlighted');
            });
            
           

                    
                    
            // Add event listeners to detect input changes
            splitValue1Input.addEventListener('input', function() {
                // Clear splitValue2 and update it based on actualValue and splitValue1
                const actualValue = parseFloat(actualValueInput.value) || 0;
                const splitValue1 = parseFloat(splitValue1Input.value) || 0;
                splitValue2Input.value = (actualValue - splitValue1).toFixed(2);
            });
            
            splitValue2Input.addEventListener('input', function() {
                // Clear splitValue1 and update it based on actualValue and splitValue2
                const actualValue = parseFloat(actualValueInput.value) || 0;
                const splitValue2 = parseFloat(splitValue2Input.value) || 0;
                splitValue1Input.value = (actualValue - splitValue2).toFixed(2);
            });
                    
                    
            
            function sendData(invoiceData) {
                var xhr = new XMLHttpRequest();
                xhr.open('POST', 'save_entries.php', true);
                xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
            
                var dataString = Object.keys(invoiceData).map(function(key) {
                    return encodeURIComponent(key) + '=' + encodeURIComponent(invoiceData[key]);
                }).join('&');
            
                xhr.send(dataString);
            
                xhr.onreadystatechange = function () {
                    if (xhr.readyState == 4 && xhr.status == 200) {
                        console.log(xhr.responseText);
            
                        // Parse the response JSON to check if the data was saved
                        try {
                            var response = JSON.parse(xhr.responseText);
                            if (response.status === 'success') {
                                console.log('Invoice inserted successfully!');
                            } else {
                                console.log('Error:', response.message);
                            }
                        } catch (e) {
                            console.log('Invalid JSON response:', xhr.responseText);
                        }
                    }
                };
            }

                        
                        
            function DeleteOldEntryForSplit(invoiceData) {
                var xhr = new XMLHttpRequest();
                xhr.open('POST', 'delete_entries.php', true);
                xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
            
                var dataString = Object.keys(invoiceData).map(function(key) {
                    return encodeURIComponent(key) + '=' + encodeURIComponent(invoiceData[key]);
                }).join('&');
            
                xhr.send(dataString);
            
                xhr.onreadystatechange = function () {
                    if (xhr.readyState == 4 && xhr.status == 200) {
                        console.log(xhr.responseText);
            
                        // Parse the response JSON to check if the data was saved
                        try {
                            var response = JSON.parse(xhr.responseText);
                            if (response.status === 'success') {
                                console.log('Row deleted successfully!');
                            } else {
                                console.log('Error:', response.message);
                            }
                        } catch (e) {
                            console.log('Invalid JSON response:', xhr.responseText);
                        }
                    }
                };
            }
            
        
        function UpdateRow(invoiceData) {
                var xhr = new XMLHttpRequest();
                xhr.open('POST', 'update_row.php', true);
                xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
            
                var dataString = Object.keys(invoiceData).map(function(key) {
                    return encodeURIComponent(key) + '=' + encodeURIComponent(invoiceData[key]);
                }).join('&');
            
                xhr.send(dataString);
            
                xhr.onreadystatechange = function () {
                    if (xhr.readyState == 4 && xhr.status == 200) {
                        console.log(xhr.responseText);
            
                        // Parse the response JSON to check if the data was saved
                        try {
                            var response = JSON.parse(xhr.responseText);
                            if (response.status === 'success') {
                                console.log('Row updated successfully!');
                            } else {
                                console.log('Error:', response.message);
                            }
                        } catch (e) {
                            console.log('Invalid JSON response:', xhr.responseText);
                        }
                    }
                };
            }



            var table1 = document.getElementById('tableRenders');            
            var table2 = document.getElementById('tableArchi');

            var numRows1 = table1.rows.length;
            var numRows2 = table2.rows.length;

            // Loop through each row in the table, excluding the last row
            for (var i = 1; i < numRows1 - 1; i++) {
                var row = table1.rows[i];
                var invoiceData = {
                    projectname: row.cells[0].innerText,
                    invoicedate: row.cells[1].innerText,
                    movevalue: row.cells[2].innerText,
                    invoiceid: row.cells[3].innerText,
                    type: row.cells[4].innerText,
                    totalvalue: row.cells[5].innerText
                };

                // Send data for each row
                sendData(invoiceData);
            }





            // Loop through each row in the table, excluding the last row
            for (var i = 1; i < numRows2 - 1; i++) {
                var row = table2.rows[i];
                var invoiceData = {
                    projectname: row.cells[0].innerText,
                    invoicedate: row.cells[1].innerText,
                    movevalue: row.cells[2].innerText,
                    invoiceid: row.cells[3].innerText,
                    type: row.cells[4].innerText,
                    totalvalue: row.cells[5].innerText
                };

                // Send data for each row
                sendData(invoiceData);
            }


            
            
            
            
            
        });





function numberFormat1(value) {
                
// Convert value to number and round to two decimal places
const roundedValue = Number(value).toFixed(2);
                    
// Add thousands separators
const parts = roundedValue.toString().split(".");
parts[0] = parts[0].replace(/\B(?=(\d{3})+(?!\d))/g, " ");
                    
return parts.join(".");
}
            

function numberFormat2(value) {
                
// Convert value to number and round to two decimal places
const roundedValue = Number(value).toFixed(2);
                    
// Add thousands separators
const parts = roundedValue.toString().split(".");
parts[0] = parts[0].replace(/\B(?=(\d{3})+(?!\d))/g, " ");
                    
return parts.join(".");
}






function updateList() {
    var tableRenders = document.getElementById("tableRenders")
    var tableArchi6 = document.getElementById('tableArchi');
    
    var select = document.getElementById("YearSelect");
    var year = select.value;
    var totals1 = 0;
    var totals2 = 0;
 
    var tables = ["tableRenders", "tableArchi"];
    tables.forEach(function(tableId) {
        var table = document.getElementById(tableId);
        var rows = table.getElementsByTagName("tr");
        
        for (let i = 1; i < rows.length; i++) {
            var dateCell = rows[i].getElementsByTagName("td")[1];
            var dateText = dateCell.textContent;
            var rowYear = dateText.split("-")[0];
            

            if (year === "All" || rowYear === year || rowYear === "N") {
                rows[i].style.display = "";
                
                
                    
                    
                    if (table == tableRenders){
                        

                          var cell60 = rows[i].cells[5]; // Column 6 (index 5)
                          var totalText60 = cell60.querySelector('.right-align').textContent.trim().replace('R', '').replace(' ', '').replace(/,/g, ''); // Extract text, remove 'R' and commas
    
                          
                          var sub60 = rows[i].cells[4].textContent;
                          if (sub60 !== "N") {
                          
                          var value60 = parseFloat(totalText60); // Convert to float
                          totals1 += value60; // Accumulate total
                          }
                        
                        
                    }



                    ///////////
                
                   
                    
                
                    if (table == tableArchi6){
                        
                          var cell60 = rows[i].cells[5]; // Column 6 (index 5)
                          var totalText60 = cell60.querySelector('.right-align').textContent.trim().replace('R', '').replace(' ', '').replace(/,/g, ''); // Extract text, remove 'R' and commas
    
                          
                          var sub60 = rows[i].cells[4].textContent;
                          if (sub60 !== "N") {
                          
                          var value60 = parseFloat(totalText60); // Convert to float
                          totals2 += value60; // Accumulate total
                          }
                    }



           
                


                

            } else {
                rows[i].style.display = "none";
                

            }
        }
        
  

                    var totalsofTotals = totals2 + totals1;
                    
                    var renderPrecentage = (totals1 / totalsofTotals) * 100;
                    var archiPrecentage = (totals2 / totalsofTotals) * 100;
                    

                    

                    const ArchiTotalsFormat60 = numberFormat2(totals2);
                    const renderTotals1Format = numberFormat1(totals1);
                    
                    
                    document.getElementById("archiTotal").textContent = ArchiTotalsFormat60; 
                    document.getElementById("renderTotal").textContent = renderTotals1Format; 
                    
                    
                    document.getElementById("renderTitle").innerText = "RENDERING PROJECTS - (" + renderPrecentage.toFixed(2) + " %)";
                    document.getElementById("archiTitle").innerText = "ARCHITECTURE PROJECTS - (" + archiPrecentage.toFixed(2) + " %)";
                    

                   
        
    });
    
    sortTable('tableRenders');
    sortTable('tableArchi');
                   
    
    
    
    totals1 = 0;
    totals2 = 0;
    
}



 function sortTable(tableId) {
    var table, rows, switching, i, x, y, shouldSwitch;
    table = document.getElementById(tableId);
    switching = true;

    // Make a loop that will continue until no switching has been done
    while (switching) {
      switching = false;
      rows = table.rows;

      // Loop through all table rows (except the first, which contains table headers, and the last row)
      for (i = 1; i < (rows.length - 2); i++) { // Note the '- 2' to exclude the last row
        shouldSwitch = false;
        // Get the two elements you want to compare, one from the current row and one from the next
        x = rows[i].getElementsByTagName("TD")[0];
        y = rows[i + 1].getElementsByTagName("TD")[0];

        // Check if the two rows should switch place
        if (x.innerHTML.toLowerCase() > y.innerHTML.toLowerCase()) {
          // If so, mark as a switch and break the loop
          shouldSwitch = true;
          break;
        }
      }
      if (shouldSwitch) {
        // Perform the switch and mark that a switch has been done
        rows[i].parentNode.insertBefore(rows[i + 1], rows[i]);
        switching = true;
      }
    }
  }



                    sortTable('tableRenders');
                    sortTable('tableArchi');


</script>
    
    
    
    
</body>
</html>