Skip to content
TheChatArchiveThe Chat Archive
gpt-4o-2024-08-06· OpenAIAi2 WildChat-4.8M (AI2)

i get this error : Fatal error: Uncaught Exception: The PHP GD extension is required,…

  1. User

    i get this error :

    Fatal error: Uncaught Exception: The PHP GD extension is required, but is not installed. in C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\lib\Cpdf.php:5835 Stack trace: #0 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\Adapter\CPDF.php(668): Dompdf\Cpdf->addPngFromFile('C:\Users\DIGIHA...', 267.64, 746.0142519685, 90, 31.86) #1 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\Renderer\Image.php(63): Dompdf\Adapter\CPDF->image('C:\Users\DIGIHA...', 267.64, 64.015748031496, 90, 31.86, 'normal') #2 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\Renderer.php(305): Dompdf\Renderer\Image->render(Object(Dompdf\FrameDecorator\Image)) #3 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\Renderer.php(140): Dompdf\Renderer->_render_frame('image', Object(Dompdf\FrameDecorator\Image)) #4 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\Renderer.php(207): Dompdf\Renderer->render(Object(Dompdf\FrameDecorator\Image)) #5 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\Renderer.php(207): Dompdf\Renderer->render(Object(Dompdf\FrameDecorator\Block)) #6 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\Renderer.php(207): Dompdf\Renderer->render(Object(Dompdf\FrameDecorator\Block)) #7 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\FrameReflower\Page.php(149): Dompdf\Renderer->render(Object(Dompdf\FrameDecorator\Block)) #8 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\FrameDecorator\AbstractFrameDecorator.php(905): Dompdf\FrameReflower\Page->reflow(NULL) #9 C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\src\Dompdf.php(808): Dompdf\FrameDecorator\AbstractFrameDecorator->reflow() #10 C:\xampp\htdocs\generate_service_pdf.php(162): Dompdf\Dompdf->render() #11 {main} thrown in C:\xampp\htdocs\dompdf\vendor\dompdf\dompdf\lib\Cpdf.php on line 5835

    fix the code and provide the complete code :

  2. Assistant

    The error you're encountering indicates that the PHP GD extension is not installed or enabled on your server. The GD extension is used in PHP to manipulate images, and Dompdf relies on it for certain types of image processing, such as rendering PNG images.

    Here's how you can resolve this issue:

    Step 1: Enable the GD Extension

    1. Open your php.ini file:
      Locate the php.ini file. If you're using XAMPP, it is usually located at C:\xampp\php\php.ini.

    2. Enable the GD extension:
      Find the following line in the php.ini file:

      ;extension=gd
      

      Remove the semicolon (;) at the beginning to enable the extension:

      extension=gd
      
    3. Restart the Apache server:
      Use the XAMPP control panel to stop and start the Apache server to apply the changes.

    Step 2: Correct PHP Code (Optional)

    There is a mistake in your PHP code with respect to a string that is not closed which can cause a syntax error. Let's fix this:

    1. Correct the base URL quote: There is a missing closing quote in your base URL string. Correct the following line:

      Change:

      $base_url = 'http://localhost/; // Ensure the base URL is correct
      

      To:

      $base_url = 'http://localhost/'; // Ensure the base URL is correct
      

    Here is the corrected snippet with the base_url fix:

    <?php
    // Require Dompdf and database connection
    require_once 'dompdf/vendor/autoload.php';
    require 'db.php';
    
    use Dompdf\Dompdf;
    use Dompdf\Options;
    
    // Function to fetch store details
    function fetchStoreDetails($pdo) {
        $stmt = $pdo->query("SELECT store_name, address, phone_number, logo_path FROM settings WHERE id = 1");
        return $stmt->fetch(PDO::FETCH_ASSOC);
    }
    
    // Fetch service details if service ID is provided
    if (isset($_GET['id'])) {
        $service_id = (int)$_GET['id'];
    
        // Prepare and execute query to get service details
        $stmt = $pdo->prepare("SELECT s.*, c.full_name, d.type, d.brand, d.model, cd.serial_number
                               FROM services s
                               JOIN customers c ON s.customer_id = c.id
                               JOIN customer_devices cd ON s.device_id = cd.device_id
                               JOIN devices d ON cd.device_id = d.id
                               WHERE s.id = ?");
        $stmt->execute([$service_id]);
        $service = $stmt->fetch(PDO::FETCH_ASSOC);
    
        if ($service) {
            $storeDetails = fetchStoreDetails($pdo);
    
            // Escape and prepare store details for HTML
            $store_name = htmlspecialchars($storeDetails['store_name'], ENT_QUOTES, 'UTF-8');
            $store_address = htmlspecialchars($storeDetails['address'], ENT_QUOTES, 'UTF-8');
            $store_phone = htmlspecialchars($storeDetails['phone_number'], ENT_QUOTES, 'UTF-8');
            $logo_path = htmlspecialchars($storeDetails['logo_path'], ENT_QUOTES, 'UTF-8');
            $base_url = 'http://localhost/'; // Ensure the base URL is correct
            $logo_url = !empty($logo_path) ? $base_url . '/' . ltrim($logo_path, '/') : '';
    
            // Create HTML content with enhanced design
            $html = "
            <style>
                ...
            </style>
            <div class='container'>
                ...
            </div>";
    
            // Initialize and configure Dompdf
            $options = new Options();
            $options->set('isRemoteEnabled', true);
            $dompdf = new Dompdf($options);
            $dompdf->loadHtml($html);
    
            // Set paper size and orientation
            $dompdf->setPaper('A4', 'portrait');
    
            // Render and output the PDF to the browser
            $dompdf->render();
            $dompdf->stream("service_report_$service_id.pdf", array("Attachment" => false));
        } else {
            echo "Service not found.";
        }
    } else {
        echo "No service ID provided.";
    }
    ?>
    

    By enabling the GD extension and fixing the PHP script, this should address the error and allow the script to run correctly. If issues persist, ensure all other extensions and configuration settings required for your application are correctly set.

  3. User

    when i edit a customer and add a new device and save it the change is not being saved please fix and provide me with the complete code :

    <div class="container">
        <div class="content">
            <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
            <?php if (isset($_GET['status']) && $_GET['status'] == 'success'): ?>
                <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
            <?php endif; ?>
    
            <!-- Κουμπί ενεργοποίησης modal -->
            <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                Προσθήκη Νέου Πελάτη
            </button>
    
            <!-- Modal για προσθήκη νέου πελάτη -->
            <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-body">
                            <form action="customers.php" method="post">
                                <input type="hidden" name="action" value="add_customer">
                                <div class="form-group">
                                    <label for="full_name">Ονοματεπώνυμο</label>
                                    <input type="text" class="form-control" id="full_name" name="full_name" required>
                                </div>
                                <div class="form-row">
                                    <div class="form-group col-md-6">
                                        <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                        <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="cellphone_number">Αριθμός Κινητού</label>
                                        <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                    </div>
                                </div>
                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                <div id="device_list">
                                    <div class="device-item d-flex align-items-end">
                                        <div class="form-group mr-2">
                                            <label for="device_id">Επιλογή Συσκευής</label>
                                            <select class="form-control device-select" id="device_id" name="devices[0][device_id]" required onchange="toggleSerialInput(this)">
                                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                <option value="none">Χωρίς συσκευή</option>
                                                <?php foreach ($devices as $device): ?>
                                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                            <input type="text" class="form-control serial-number" id="serial_number" name="devices[0][serial_number]" required>
                                        </div>
                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                    </div>
                                </div>
                                <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
    
            <!-- Λίστα Πελατών -->
            <h2>Λίστα Πελατών</h2>
            <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
            <?php if (count($customers) > 0): ?>
                <table class="table table-bordered table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>ID</th>
                            <th>Ονοματεπώνυμο</th>
                            <th>Τηλέφωνο Σταθερό</th>
                            <th>Αριθμός Κινητού</th>
                            <th>Ημερομηνία Εγγραφής</th>
                            <th>Ενέργειες</th>
                        </tr>
                    </thead>
                    <tbody id="customerTable">
                        <?php foreach ($customers as $customer): ?>
                        <tr>
                            <td><?= htmlspecialchars($customer['id']) ?></td>
                            <td><?= htmlspecialchars($customer['full_name']) ?></td>
                            <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                            <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                            <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                            <td>
                                <!-- Προβολή, Επεξεργασία, Διαγραφή, Εκτύπωση -->
                                <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                            </td>
                        </tr>
                        <!-- Modal Προβολής Πελάτη -->
                        <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                        <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                        <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                        <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                        <h4>Συσκευές σε Κατοχή:</h4>
                                        <ul>
                                            <?php
                                            $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                            foreach ($customer_devices as $device):
                                            ?>
                                            <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                            <?php endforeach; ?>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <!-- Modal Επεξεργασίας Πελάτη -->
                        <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="edit_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <div class="form-group">
                                                <label for="full_name">Ονοματεπώνυμο</label>
                                                <input type="text" class="form-control" id="full_name" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                            </div>
                                            <div class="form-row">
                                                <div class="form-group col-md-6">
                                                    <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                                    <input type="text" class="form-control" id="landline_phone" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                </div>
                                                <div class="form-group col-md-6">
                                                    <label for="cellphone_number">Αριθμός Κινητού</label>
                                                    <input type="text" class="form-control" id="cellphone_number" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                </div>
                                            </div>
                                            <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                            <div id="edit_device_list<?= $customer['id'] ?>">
                                                <?php
                                                foreach ($customer_devices as $index => $device):
                                                ?>
                                                <div class="device-item d-flex align-items-end">
                                                    <div class="form-group mr-2">
                                                        <label for="device_id">Επιλογή Συσκευής</label>
                                                        <select class="form-control device-select" id="device_id" name="devices[<?= $index ?>][device_id]" required onchange="toggleSerialInput(this)">
                                                            <option value="" disabled>Επιλέξτε συσκευή</option>
                                                            <option value="none" <?= $device['device_id'] == 'none' ? 'selected' : '' ?>>Χωρίς συσκευή</option>
                                                            <?php foreach ($devices as $d): ?>
                                                                <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                            <?php endforeach; ?>
                                                        </select>
                                                    </div>
                                                    <div class="form-group">
                                                        <label for="serial_number">Σειριακός Αριθμός</label>
                                                        <input type="text" class="form-control serial-number" id="serial_number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>" <?= $device['device_id'] == 'none' ? 'disabled' : '' ?>>
                                                    </div>
                                                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                </div>
                                                <?php endforeach; ?>
                                            </div>
                                            <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                            <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <!-- Modal Διαγραφής Πελάτη -->
                        <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="delete_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <?php endforeach; ?>
                    </tbody>
                </table>
            <?php else: ?>
                <p>Δεν βρέθηκαν πελάτες.</p>
            <?php endif; ?>
        </div>
    </div>
    
    <div class="footer">
        <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
    </div>
    
    <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script>
        $(document).ready(function() {
            $('.device-select').select2({
                placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                allowClear: true
            });
    
            $('.modal').on('shown.bs.modal', function () {
                $(this).find('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            });
        });
    
        function addDevice(customerId) {
            let index = document.querySelectorAll('#edit_device_list' + customerId + ' .device-item').length;
            let newDevice = `
                <div class="device-item d-flex align-items-end">
                    <div class="form-group mr-2">
                        <label for="device_id">Επιλογή Συσκευής</label>
                        <select class="form-control device-select" id="device_id" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                            <option value="" selected disabled>Επιλέξτε συσκευή</option>
                            <option value="none">Χωρίς συσκευή</option>
                            <?php foreach ($devices as $device): ?>
                                <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="form-group">
                        <label for="serial_number">Σειριακός Αριθμός</label>
                        <input type="text" class="form-control serial-number" id="serial_number" name="devices[${index}][serial_number]" required>
                    </div>
                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                </div>`;
            document.getElementById('edit_device_list' + customerId).insertAdjacentHTML('beforeend', newDevice);
            $('.device-select').select2({
                placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                allowClear: true
            });
        }
    
        document.getElementById('add_device').addEventListener('click', function() {
            let index = document.querySelectorAll('#device_list .device-item').length;
            let newDevice = `
                <div class="device-item d-flex align-items-end">
                    <div class="form-group mr-2">
                        <label for="device_id">Επιλογή Συσκευής</label>
                        <select class="form-control device-select" id="device_id" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                            <option value="" selected disabled>Επιλέξτε συσκευή</option>
                            <option value="none">Χωρίς συσκευή</option>
                            <?php foreach ($devices as $device): ?>
                                <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="form-group">
                        <label for="serial_number">Σειριακός Αριθμός</label>
                        <input type="text" class="form-control serial-number" id="serial_number" name="devices[${index}][serial_number]" required>
                    </div>
                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                </div>`;
            document.getElementById('device_list').insertAdjacentHTML('beforeend', newDevice);
            $('.device-select').select2({
                placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                allowClear: true
            });
        });
    
        function toggleSerialInput(selectElement) {
            const serialInput = selectElement.closest('.device-item').querySelector('.serial-number');
            if (selectElement.value === 'none') {
                serialInput.value = '';
                serialInput.disabled = true;
            } else {
                serialInput.disabled = false;
            }
        }
    
        function removeDevice(button) {
            button.closest('.device-item').remove();
        }
    
        document.getElementById('customerSearch').addEventListener('input', function() {
            let filter = this.value.toLowerCase();
            document.querySelectorAll('#customerTable tr').forEach(row => {
                let text = row.textContent.toLowerCase();
                row.style.display = text.includes(filter) ? '' : 'none';
            });
        });
    
        function printCustomer(customerId) {
            window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
        }
    </script>
    
  4. Assistant

    When editing a customer and adding a new device, changes might not be saved properly if certain steps are missed in handling the form data and database interactions. Below, I have examined the PHP code and added improvements to ensure devices are processed correctly when a customer is edited. This primarily involves ensuring that devices are appended correctly to the devices array in the editing modal, and this same index reference is used when adding new devices.

    Here's the improved code, emphasizing the resolution of issues you might face with adding new devices during the customer edit process:

    <?php
    // customers.php
    include 'db.php';
    
    // Handle form submissions
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action']) && $_POST['action'] == 'add_customer') {
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
            $registration_date = date('Y-m-d');
    
            $stmt = $pdo->prepare("INSERT INTO customers (full_name, landline_phone, cellphone_number, registration_date) VALUES (?, ?, ?, ?)");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $registration_date]);
    
            $customer_id = $pdo->lastInsertId();
    
            // Insert new devices
            foreach ($_POST['devices'] as $device) {
                if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                    $device_id = $device['device_id'];
                    $serial_number = $device['serial_number'];
                    $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                    $stmt->execute([$customer_id, $device_id, $serial_number]);
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] == 'edit_customer') {
            $customer_id = $_POST['customer_id'];
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
    
            $stmt = $pdo->prepare("UPDATE customers SET full_name = ?, landline_phone = ?, cellphone_number = ? WHERE id = ?");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $customer_id]);
    
            // Clear old devices and insert updated devices
            if (!empty($_POST['devices'])) {
                $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
                $stmt->execute([$customer_id]);
    
                foreach ($_POST['devices'] as $device) {
                    if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                        $device_id = $device['device_id'];
                        $serial_number = $device['serial_number'];
                        $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                        $stmt->execute([$customer_id, $device_id, $serial_number]);
                    }
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] == 'delete_customer') {
            $customer_id = $_POST['customer_id'];
    
            // Delete related data and customer 
            $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
            $stmt->execute([$customer_id]);
    
            $stmt = $pdo->prepare("DELETE FROM customers WHERE id = ?");
            $stmt->execute([$customer_id]);
        }
    
        header('Location: customers.php?status=success');
        exit;
    }
    
    // Retrieve available devices for selection
    $devices = $pdo->query("SELECT id, type, brand, model FROM devices")->fetchAll(PDO::FETCH_ASSOC);
    
    // Retrieve customer details for modals (view, edit, delete, print)
    $customers = $pdo->query("SELECT * FROM customers ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
    
    function fetchCustomerDevices($pdo, $customer_id) {
        $stmt = $pdo->prepare("SELECT cd.device_id, cd.serial_number, d.type, d.brand, d.model FROM customer_devices cd JOIN devices d ON cd.device_id = d.id WHERE cd.customer_id = ?");
        $stmt->execute([$customer_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    ?>
    
    <!DOCTYPE html>
    <html lang="el">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Πελάτες - Digihack</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
        <style>
            body {
                display: flex;
                flex-direction: column;
                min-height: 100vh;
                background-color: #f4f6f8;
                font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
                color: #333;
            }
            .container {
                flex: 1;
                margin-top: 20px;
            }
            .navbar {
                background-color: #282828;
            }
            .navbar-brand img {
                height: 40px;
            }
            .nav-link {
                color: #fff !important;
            }
            .nav-link.active {
                font-weight: bold;
                color: #d32f2f !important;
            }
            .content {
                margin-top: 40px;
            }
            .content .form-group label {
                font-weight: bold;
            }
            .content .form-control, .content .form-control-file {
                border-radius: 5px;
            }
            .content .modal-content {
                border-radius: 10px;
            }
            .btn-custom {
                background-color: #007bff;
                color: #fff;
                border: none;
                transition: background-color 0.3s ease;
            }
            .btn-custom:hover {
                background-color: #0056b3;
            }
            .table th, .table td {
                vertical-align: middle;
            }
            .table-hover tbody tr:hover {
                background-color: #f1f1f1;
            }
            .device-item {
                margin-bottom: 15px;
            }
            .device-item .form-group {
                flex: 1 1 auto;
            }
            .device-item .select2-container {
                width: 100% !important;
            }
            .select2-container--default .select2-selection--single {
                border-radius: 0.25rem;
                height: calc(1.5em + 0.75rem + 2px);
                border-color: #ced4da;
            }
            .select2-selection__rendered {
                line-height: 1.5em;
            }
            .select2-selection__arrow {
                top: 50%;
                transform: translateY(-50%);
            }
            @media (max-width: 768px) {
                .device-item {
                    flex-direction: column;
                    align-items: flex-start;
                }
                .device-item .form-group, .device-item .close-btn {
                    width: 100%;
                }
                .device-item .close-btn {
                    text-align: right;
                }
            }
            .footer {
                background-color: #282828;
                color: white;
                border-radius: 10px;
                padding: 20px;
                text-align: center;
            }
            .footer a {
                color: #d32f2f;
                text-decoration: none;
            }
            .footer a:hover {
                text-decoration: underline;
            }
        </style>
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-dark">
            <a class="navbar-brand" href="#"><img src="uploads/digihack-logo-new.png" alt="Digihack"></a>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ml-auto">
                    <li class="nav-item">
                        <a class="nav-link <?= ($page == 'customers') ? 'active' : '' ?>" href="customers.php">Πελάτες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link <?= ($page == 'services') ? 'active' : '' ?>" href="services.php">Υπηρεσίες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link <?= ($page == 'devices') ? 'active' : '' ?>" href="devices.php">Συσκευές</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link <?= ($page == 'settings') ? 'active' : '' ?>" href="settings.php">Ρυθμίσεις</a>
                    </li>
                </ul>
            </div>
        </nav>
    
        <div class="container">
            <div class="content">
                <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
                <?php if (isset($_GET['status']) && $_GET['status'] == 'success'): ?>
                    <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
                <?php endif; ?>
    
                <!-- Button for adding new customer -->
                <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                    Προσθήκη Νέου Πελάτη
                </button>
    
                <!-- Modal for adding new customer -->
                <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <form action="customers.php" method="post">
                                    <input type="hidden" name="action" value="add_customer">
                                    <div class="form-group">
                                        <label for="full_name">Ονοματεπώνυμο</label>
                                        <input type="text" class="form-control" id="full_name" name="full_name" required>
                                    </div>
                                    <div class="form-row">
                                        <div class="form-group col-md-6">
                                            <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                            <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                        </div>
                                        <div class="form-group col-md-6">
                                            <label for="cellphone_number">Αριθμός Κινητού</label>
                                            <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                        </div>
                                    </div>
                                    <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                    <div id="device_list">
                                        <div class="device-item d-flex align-items-end">
                                            <div class="form-group mr-2">
                                                <label for="device_id">Επιλογή Συσκευής</label>
                                                <select class="form-control device-select" id="device_id" name="devices[0][device_id]" required onchange="toggleSerialInput(this)">
                                                    <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                    <option value="none">Χωρίς συσκευή</option>
                                                    <?php foreach ($devices as $device): ?>
                                                        <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                            <div class="form-group">
                                                <label for="serial_number">Σειριακός Αριθμός</label>
                                                <input type="text" class="form-control serial-number" id="serial_number" name="devices[0][serial_number]" required>
                                            </div>
                                            <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                        </div>
                                    </div>
                                    <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                    <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
    
                <!-- Customer List -->
                <h2>Λίστα Πελατών</h2>
                <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
                <?php if (count($customers) > 0): ?>
                    <table class="table table-bordered table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>ID</th>
                                <th>Ονοματεπώνυμο</th>
                                <th>Τηλέφωνο Σταθερό</th>
                                <th>Αριθμός Κινητού</th>
                                <th>Ημερομηνία Εγγραφής</th>
                                <th>Ενέργειες</th>
                            </tr>
                        </thead>
                        <tbody id="customerTable">
                            <?php foreach ($customers as $customer): ?>
                            <tr>
                                <td><?= htmlspecialchars($customer['id']) ?></td>
                                <td><?= htmlspecialchars($customer['full_name']) ?></td>
                                <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                                <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                                <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                                <td>
                                    <!-- View, Edit, Delete, Print -->
                                    <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                    <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                    <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                    <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                                </td>
                            </tr>
                            <!-- View Customer Modal -->
                            <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                            <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                            <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                            <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                            <h4>Συσκευές σε Κατοχή:</h4>
                                            <ul>
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $device):
                                                ?>
                                                <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                                <?php endforeach; ?>
                                            </ul>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <!-- Edit Customer Modal -->
                            <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <form action="customers.php" method="post">
                                                <input type="hidden" name="action" value="edit_customer">
                                                <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                                <div class="form-group">
                                                    <label for="full_name">Ονοματεπώνυμο</label>
                                                    <input type="text" class="form-control" id="full_name" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                                </div>
                                                <div class="form-row">
                                                    <div class="form-group col-md-6">
                                                        <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                                        <input type="text" class="form-control" id="landline_phone" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                    </div>
                                                    <div class="form-group col-md-6">
                                                        <label for="cellphone_number">Αριθμός Κινητού</label>
                                                        <input type="text" class="form-control" id="cellphone_number" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                    </div>
                                                </div>
                                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                                <div id="edit_device_list<?= $customer['id'] ?>">
                                                    <?php
                                                    foreach ($customer_devices as $index => $device):
                                                    ?>
                                                    <div class="device-item d-flex align-items-end">
                                                        <div class="form-group mr-2">
                                                            <label for="device_id">Επιλογή Συσκευής</label>
                                                            <select class="form-control device-select" id="device_id" name="devices[<?= $index ?>][device_id]" required onchange="toggleSerialInput(this)">
                                                                <option value="" disabled>Επιλέξτε συσκευή</option>
                                                                <option value="none" <?= $device['device_id'] == 'none' ? 'selected' : '' ?>>Χωρίς συσκευή</option>
                                                                <?php foreach ($devices as $d): ?>
                                                                    <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                                <?php endforeach; ?>
                                                            </select>
                                                        </div>
                                                        <div class="form-group">
                                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                                            <input type="text" class="form-control serial-number" id="serial_number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>" <?= $device['device_id'] == 'none' ? 'disabled' : '' ?>>
                                                        </div>
                                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                    </div>
                                                    <?php endforeach; ?>
                                                </div>
                                                <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <!-- Delete Customer Modal -->
                            <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                            <form action="customers.php" method="post">
                                                <input type="hidden" name="action" value="delete_customer">
                                                <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                                <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                <?php else: ?>
                    <p>Δεν βρέθηκαν πελάτες.</p>
                <?php endif; ?>
            </div>
        </div>
    
        <div class="footer">
            <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
        </div>
    
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
        <script>
            $(document).ready(function() {
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
    
                $('.modal').on('shown.bs.modal', function () {
                    $(this).find('.device-select').select2({
                        placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                        allowClear: true
                    });
                });
            });
    
            function addDevice(customerId) {
                let index = document.querySelectorAll('#edit_device_list' + customerId + ' .device-item').length;
                let newDevice = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" id="device_id" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <option value="none">Χωρίς συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" id="serial_number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                document.getElementById('edit_device_list' + customerId).insertAdjacentHTML('beforeend', newDevice);
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            }
    
            document.getElementById('add_device').addEventListener('click', function() {
                let index = document.querySelectorAll('#device_list .device-item').length;
                let newDevice = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" id="device_id" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <option value="none">Χωρίς συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" id="serial_number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                document.getElementById('device_list').insertAdjacentHTML('beforeend', newDevice);
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            });
    
            function toggleSerialInput(selectElement) {
                const serialInput = selectElement.closest('.device-item').querySelector('.serial-number');
                if (selectElement.value === 'none') {
                    serialInput.value = '';
                    serialInput.disabled = true;
                } else {
                    serialInput.disabled = false;
                }
            }
    
            function removeDevice(button) {
                button.closest('.device-item').remove();
            }
    
            document.getElementById('customerSearch').addEventListener('input', function() {
                let filter = this.value.toLowerCase();
                document.querySelectorAll('#customerTable tr').forEach(row => {
                    let text = row.textContent.toLowerCase();
                    row.style.display = text.includes(filter) ? '' : 'none';
                });
            });
    
            function printCustomer(customerId) {
                window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
            }
        </script>
    </body>
    </html>
    

    Key Changes Made:

    1. Ensure Device Array is Handled Properly: When removing and adding devices, it's crucial to maintain proper indexing within your form inputs to ensure each device item has unique access and is correctly processed in the PHP script.

    2. Check for devices Input: When deleting old devices and inserting new ones upon editing, ensure the devices post variable is checked before performing database operations to avoid unnecessary errors or notices.

    This revised version should help address issues with not saving customer edits correctly, especially when adding new devices to existing customers. Ensure your browser caching does not affect this by clearing any cache or using an incognito window to test your changes.

  5. User

    when i edit the customer the customer and add a device and press save when i view or edit the customer the added edited device is not being saved please provide the complete adjusted code

  6. Assistant

    To resolve the issue of the device not being saved when you edit and update a customer, let's make sure we process the form data correctly when updating existing customers. We will also verify that when adding or editing devices, changes reflect accurately in the database. Below is the adjusted code with the necessary modifications:

    <?php
    // customers.php
    include 'db.php';
    
    // Handle form submissions
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action']) && $_POST['action'] == 'add_customer') {
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
            $registration_date = date('Y-m-d');
    
            $stmt = $pdo->prepare("INSERT INTO customers (full_name, landline_phone, cellphone_number, registration_date) VALUES (?, ?, ?, ?)");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $registration_date]);
    
            $customer_id = $pdo->lastInsertId();
    
            // Insert new devices
            foreach ($_POST['devices'] as $device) {
                if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                    $device_id = $device['device_id'];
                    $serial_number = $device['serial_number'];
                    $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                    $stmt->execute([$customer_id, $device_id, $serial_number]);
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] == 'edit_customer') {
            $customer_id = $_POST['customer_id'];
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
    
            $stmt = $pdo->prepare("UPDATE customers SET full_name = ?, landline_phone = ?, cellphone_number = ? WHERE id = ?");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $customer_id]);
    
            // Clear old devices and insert updated devices
            if (isset($_POST['devices'])) {
                $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
                $stmt->execute([$customer_id]);
    
                foreach ($_POST['devices'] as $device) {
                    if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                        $device_id = $device['device_id'];
                        $serial_number = $device['serial_number'];
                        $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                        $stmt->execute([$customer_id, $device_id, $serial_number]);
                    }
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] == 'delete_customer') {
            $customer_id = $_POST['customer_id'];
    
            // Delete related data and customer 
            $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
            $stmt->execute([$customer_id]);
    
            $stmt = $pdo->prepare("DELETE FROM customers WHERE id = ?");
            $stmt->execute([$customer_id]);
        }
    
        header('Location: customers.php?status=success');
        exit;
    }
    
    // Retrieve available devices for selection
    $devices = $pdo->query("SELECT id, type, brand, model FROM devices")->fetchAll(PDO::FETCH_ASSOC);
    
    // Retrieve customer details for modals (view, edit, delete, print)
    $customers = $pdo->query("SELECT * FROM customers ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
    
    function fetchCustomerDevices($pdo, $customer_id) {
        $stmt = $pdo->prepare("SELECT cd.device_id, cd.serial_number, d.type, d.brand, d.model FROM customer_devices cd JOIN devices d ON cd.device_id = d.id WHERE cd.customer_id = ?");
        $stmt->execute([$customer_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    ?>
    
    <!DOCTYPE html>
    <html lang="el">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Πελάτες - Digihack</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
        <style>
            body {
                display: flex;
                flex-direction: column;
                min-height: 100vh;
                background-color: #f4f6f8;
                font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
                color: #333;
            }
            .container {
                flex: 1;
                margin-top: 20px;
            }
            .navbar {
                background-color: #282828;
            }
            .navbar-brand img {
                height: 40px;
            }
            .nav-link {
                color: #fff !important;
            }
            .nav-link.active {
                font-weight: bold;
                color: #d32f2f !important;
            }
            .content {
                margin-top: 40px;
            }
            .content .form-group label {
                font-weight: bold;
            }
            .content .form-control, .content .form-control-file {
                border-radius: 5px;
            }
            .content .modal-content {
                border-radius: 10px;
            }
            .btn-custom {
                background-color: #007bff;
                color: #fff;
                border: none;
                transition: background-color 0.3s ease;
            }
            .btn-custom:hover {
                background-color: #0056b3;
            }
            .table th, .table td {
                vertical-align: middle;
            }
            .table-hover tbody tr:hover {
                background-color: #f1f1f1;
            }
            .device-item {
                margin-bottom: 15px;
            }
            .device-item .form-group {
                flex: 1 1 auto;
            }
            .device-item .select2-container {
                width: 100% !important;
            }
            .select2-container--default .select2-selection--single {
                border-radius: 0.25rem;
                height: calc(1.5em + 0.75rem + 2px);
                border-color: #ced4da;
            }
            .select2-selection__rendered {
                line-height: 1.5em;
            }
            .select2-selection__arrow {
                top: 50%;
                transform: translateY(-50%);
            }
            @media (max-width: 768px) {
                .device-item {
                    flex-direction: column;
                    align-items: flex-start;
                }
                .device-item .form-group, .device-item .close-btn {
                    width: 100%;
                }
                .device-item .close-btn {
                    text-align: right;
                }
            }
            .footer {
                background-color: #282828;
                color: white;
                border-radius: 10px;
                padding: 20px;
                text-align: center;
            }
            .footer a {
                color: #d32f2f;
                text-decoration: none;
            }
            .footer a:hover {
                text-decoration: underline;
            }
        </style>
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-dark">
            <a class="navbar-brand" href="#"><img src="uploads/digihack-logo-new.png" alt="Digihack"></a>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ml-auto">
                    <li class="nav-item">
                        <a class="nav-link <?= ($page == 'customers') ? 'active' : '' ?>" href="customers.php">Πελάτες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link <?= ($page == 'services') ? 'active' : '' ?>" href="services.php">Υπηρεσίες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link <?= ($page == 'devices') ? 'active' : '' ?>" href="devices.php">Συσκευές</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link <?= ($page == 'settings') ? 'active' : '' ?>" href="settings.php">Ρυθμίσεις</a>
                    </li>
                </ul>
            </div>
        </nav>
    
        <div class="container">
            <div class="content">
                <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
                <?php if (isset($_GET['status']) && $_GET['status'] == 'success'): ?>
                    <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
                <?php endif; ?>
    
                <!-- Button for adding new customer -->
                <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                    Προσθήκη Νέου Πελάτη
                </button>
    
                <!-- Modal for adding new customer -->
                <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <form action="customers.php" method="post">
                                    <input type="hidden" name="action" value="add_customer">
                                    <div class="form-group">
                                        <label for="full_name">Ονοματεπώνυμο</label>
                                        <input type="text" class="form-control" id="full_name" name="full_name" required>
                                    </div>
                                    <div class="form-row">
                                        <div class="form-group col-md-6">
                                            <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                            <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                        </div>
                                        <div class="form-group col-md-6">
                                            <label for="cellphone_number">Αριθμός Κινητού</label>
                                            <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                        </div>
                                    </div>
                                    <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                    <div id="device_list">
                                        <div class="device-item d-flex align-items-end">
                                            <div class="form-group mr-2">
                                                <label for="device_id">Επιλογή Συσκευής</label>
                                                <select class="form-control device-select" name="devices[0][device_id]" required onchange="toggleSerialInput(this)">
                                                    <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                    <option value="none">Χωρίς συσκευή</option>
                                                    <?php foreach ($devices as $device): ?>
                                                        <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                            <div class="form-group">
                                                <label for="serial_number">Σειριακός Αριθμός</label>
                                                <input type="text" class="form-control serial-number" id="serial_number" name="devices[0][serial_number]" required>
                                            </div>
                                            <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                        </div>
                                    </div>
                                    <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                    <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
    
                <!-- Customer List -->
                <h2>Λίστα Πελατών</h2>
                <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
                <?php if (count($customers) > 0): ?>
                    <table class="table table-bordered table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>ID</th>
                                <th>Ονοματεπώνυμο</th>
                                <th>Τηλέφωνο Σταθερό</th>
                                <th>Αριθμός Κινητού</th>
                                <th>Ημερομηνία Εγγραφής</th>
                                <th>Ενέργειες</th>
                            </tr>
                        </thead>
                        <tbody id="customerTable">
                            <?php foreach ($customers as $customer): ?>
                            <tr>
                                <td><?= htmlspecialchars($customer['id']) ?></td>
                                <td><?= htmlspecialchars($customer['full_name']) ?></td>
                                <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                                <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                                <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                                <td>
                                    <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                    <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                    <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                    <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                                </td>
                            </tr>
                            <!-- View Customer Modal -->
                            <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                            <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                            <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                            <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                            <h4>Συσκευές σε Κατοχή:</h4>
                                            <ul>
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $device):
                                                ?>
                                                <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                                <?php endforeach; ?>
                                            </ul>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <!-- Edit Customer Modal -->
                            <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <form action="customers.php" method="post">
                                                <input type="hidden" name="action" value="edit_customer">
                                                <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                                <div class="form-group">
                                                    <label for="full_name_<?= $customer['id'] ?>">Ονοματεπώνυμο</label>
                                                    <input type="text" class="form-control" id="full_name_<?= $customer['id'] ?>" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                                </div>
                                                <div class="form-row">
                                                    <div class="form-group col-md-6">
                                                        <label for="landline_phone_<?= $customer['id'] ?>">Τηλέφωνο Σταθερό</label>
                                                        <input type="text" class="form-control" id="landline_phone_<?= $customer['id'] ?>" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                    </div>
                                                    <div class="form-group col-md-6">
                                                        <label for="cellphone_number_<?= $customer['id'] ?>">Αριθμός Κινητού</label>
                                                        <input type="text" class="form-control" id="cellphone_number_<?= $customer['id'] ?>" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                    </div>
                                                </div>
                                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                                <div id="edit_device_list_<?= $customer['id'] ?>">
                                                    <?php
                                                    $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                    foreach ($customer_devices as $index => $device):
                                                    ?>
                                                    <div class="device-item d-flex align-items-end">
                                                        <div class="form-group mr-2">
                                                            <label for="device_id">Επιλογή Συσκευής</label>
                                                            <select class="form-control device-select" name="devices[<?= $index ?>][device_id]" required onchange="toggleSerialInput(this)">
                                                                <option value="" disabled>Επιλέξτε συσκευή</option>
                                                                <option value="none" <?= $device['device_id'] == 'none' ? 'selected' : '' ?>>Χωρίς συσκευή</option>
                                                                <?php foreach ($devices as $d): ?>
                                                                    <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                                <?php endforeach; ?>
                                                            </select>
                                                        </div>
                                                        <div class="form-group">
                                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                                            <input type="text" class="form-control serial-number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>" <?= $device['device_id'] == 'none' ? 'disabled' : '' ?>>
                                                        </div>
                                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                    </div>
                                                    <?php endforeach; ?>
                                                </div>
                                                <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <!-- Delete Customer Modal -->
                            <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                            <form action="customers.php" method="post">
                                                <input type="hidden" name="action" value="delete_customer">
                                                <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                                <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                <?php else: ?>
                    <p>Δεν βρέθηκαν πελάτες.</p>
                <?php endif; ?>
            </div>
        </div>
    
        <div class="footer">
            <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
        </div>
    
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
        <script>
            $(document).ready(function() {
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
    
                $('.modal').on('shown.bs.modal', function () {
                    $(this).find('.device-select').select2({
                        placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                        allowClear: true
                    });
                });
            });
    
            function addDevice(customerId) {
                const deviceList = `#edit_device_list_${customerId}`;
                let index = document.querySelectorAll(`${deviceList} .device-item`).length;
                let newDevice = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <option value="none">Χωρίς συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                document.querySelector(deviceList).insertAdjacentHTML('beforeend', newDevice);
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            }
    
            document.getElementById('add_device').addEventListener('click', function() {
                let index = document.querySelectorAll('#device_list .device-item').length;
                let newDevice = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <option value="none">Χωρίς συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                document.getElementById('device_list').insertAdjacentHTML('beforeend', newDevice);
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            });
    
            function toggleSerialInput(selectElement) {
                const serialInput = selectElement.closest('.device-item').querySelector('.serial-number');
                if (selectElement.value === 'none') {
                    serialInput.value = '';
                    serialInput.disabled = true;
                } else {
                    serialInput.disabled = false;
                }
            }
    
            function removeDevice(button) {
                button.closest('.device-item').remove();
            }
    
            document.getElementById('customerSearch').addEventListener('input', function() {
                let filter = this.value.toLowerCase();
                document.querySelectorAll('#customerTable tr').forEach(row => {
                    let text = row.textContent.toLowerCase();
                    row.style.display = text.includes(filter) ? '' : 'none';
                });
            });
    
            function printCustomer(customerId) {
                window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
            }
        </script>
    </body>
    </html>
    

    Key Changes:

    1. Ensure Device Array Parsing: We ensured that when adding or editing a device, the form properly names the devices arrays with correct indexes. This ensures that all data is sent and parsed correctly.

    2. Proper Variable Scope: The use of template strings (${}) in JavaScript helps assign unique div IDs, preventing cross-modal interactions.

    3. Device Form Submission Handling: We've ensured that if the devices array is sent, processing is enabled during updates—i.e., existing devices are deleted and new data is inserted based on form data.

    These changes help ensure that new devices associated with a customer are saved accurately during the update process. Let me know if you need further adjustments or if there are specific issues when executing this code.

  7. User

    same issue persists maybe apply the same method as when adding the customer and choosing the devices then its being saved but when i edit the device add or delete and view the customer after the save it's not being saved please adjusted and provide the complete code

  8. Assistant

    It looks like the issue may lie in how the devices are being handled during the update process. To resolve this, I'll ensure the device handling logic for editing customers closely mirrors the logic for adding customers. This includes managing how devices are added, deleted, and updated within the form.

    Here's an adjusted version of your code, ensuring proper handling of device lists during the editing of a customer:

    <?php
    // customers.php
    include 'db.php';
    
    // Handle form submissions
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action']) && $_POST['action'] === 'add_customer') {
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
            $registration_date = date('Y-m-d');
    
            $stmt = $pdo->prepare("INSERT INTO customers (full_name, landline_phone, cellphone_number, registration_date) VALUES (?, ?, ?, ?)");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $registration_date]);
    
            $customer_id = $pdo->lastInsertId();
    
            // Insert new devices
            foreach ($_POST['devices'] as $device) {
                if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                    $device_id = $device['device_id'];
                    $serial_number = $device['serial_number'];
                    $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                    $stmt->execute([$customer_id, $device_id, $serial_number]);
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] === 'edit_customer') {
            $customer_id = $_POST['customer_id'];
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
    
            $stmt = $pdo->prepare("UPDATE customers SET full_name = ?, landline_phone = ?, cellphone_number = ? WHERE id = ?");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $customer_id]);
    
            // Delete old devices and insert updated ones
            $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
            $stmt->execute([$customer_id]);
    
            if (isset($_POST['devices'])) {
                foreach ($_POST['devices'] as $device) {
                    if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                        $device_id = $device['device_id'];
                        $serial_number = $device['serial_number'];
                        $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                        $stmt->execute([$customer_id, $device_id, $serial_number]);
                    }
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] === 'delete_customer') {
            $customer_id = $_POST['customer_id'];
    
            // Delete customer's devices and the customer record itself
            $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
            $stmt->execute([$customer_id]);
    
            $stmt = $pdo->prepare("DELETE FROM customers WHERE id = ?");
            $stmt->execute([$customer_id]);
        }
    
        header('Location: customers.php?status=success');
        exit;
    }
    
    // Retrieve available devices for selection
    $devices = $pdo->query("SELECT id, type, brand, model FROM devices")->fetchAll(PDO::FETCH_ASSOC);
    
    // Retrieve customer details for modals (view, edit, delete, print)
    $customers = $pdo->query("SELECT * FROM customers ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
    
    function fetchCustomerDevices($pdo, $customer_id) {
        $stmt = $pdo->prepare("SELECT cd.device_id, cd.serial_number, d.type, d.brand, d.model FROM customer_devices cd JOIN devices d ON cd.device_id = d.id WHERE cd.customer_id = ?");
        $stmt->execute([$customer_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    ?>
    
    <!DOCTYPE html>
    <html lang="el">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Πελάτες - Digihack</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
        <style>
            body {
                display: flex;
                flex-direction: column;
                min-height: 100vh;
                background-color: #f4f6f8;
                font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
                color: #333;
            }
            .container {
                flex: 1;
                margin-top: 20px;
            }
            .navbar {
                background-color: #282828;
            }
            .navbar-brand img {
                height: 40px;
            }
            .nav-link {
                color: #fff !important;
            }
            .nav-link.active {
                font-weight: bold;
                color: #d32f2f !important;
            }
            .content {
                margin-top: 40px;
            }
            .content .form-group label {
                font-weight: bold;
            }
            .content .form-control, .content .form-control-file {
                border-radius: 5px;
            }
            .content .modal-content {
                border-radius: 10px;
            }
            .btn-custom {
                background-color: #007bff;
                color: #fff;
                border: none;
                transition: background-color 0.3s ease;
            }
            .btn-custom:hover {
                background-color: #0056b3;
            }
            .table th, .table td {
                vertical-align: middle;
            }
            .table-hover tbody tr:hover {
                background-color: #f1f1f1;
            }
            .device-item {
                margin-bottom: 15px;
            }
            .device-item .form-group {
                flex: 1 1 auto;
            }
            .device-item .select2-container {
                width: 100% !important;
            }
            .select2-container--default .select2-selection--single {
                border-radius: 0.25rem;
                height: calc(1.5em + 0.75rem + 2px);
                border-color: #ced4da;
            }
            .select2-selection__rendered {
                line-height: 1.5em;
            }
            .select2-selection__arrow {
                top: 50%;
                transform: translateY(-50%);
            }
            @media (max-width: 768px) {
                .device-item {
                    flex-direction: column;
                    align-items: flex-start;
                }
                .device-item .form-group, .device-item .close-btn {
                    width: 100%;
                }
                .device-item .close-btn {
                    text-align: right;
                }
            }
            .footer {
                background-color: #282828;
                color: white;
                border-radius: 10px;
                padding: 20px;
                text-align: center;
            }
            .footer a {
                color: #d32f2f;
                text-decoration: none;
            }
            .footer a:hover {
                text-decoration: underline;
            }
        </style>
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-dark">
            <a class="navbar-brand" href="#"><img src="uploads/digihack-logo-new.png" alt="Digihack"></a>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ml-auto">
                    <li class="nav-item">
                        <a class="nav-link active" href="customers.php">Πελάτες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="services.php">Υπηρεσίες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="devices.php">Συσκευές</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="settings.php">Ρυθμίσεις</a>
                    </li>
                </ul>
            </div>
        </nav>
    
        <div class="container">
            <div class="content">
                <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
                <?php if (isset($_GET['status']) && $_GET['status'] == 'success'): ?>
                    <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
                <?php endif; ?>
    
                <!-- Button for adding new customer -->
                <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                    Προσθήκη Νέου Πελάτη
                </button>
    
                <!-- Modal for adding new customer -->
                <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <form action="customers.php" method="post">
                                    <input type="hidden" name="action" value="add_customer">
                                    <div class="form-group">
                                        <label for="full_name">Ονοματεπώνυμο</label>
                                        <input type="text" class="form-control" id="full_name" name="full_name" required>
                                    </div>
                                    <div class="form-row">
                                        <div class="form-group col-md-6">
                                            <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                            <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                        </div>
                                        <div class="form-group col-md-6">
                                            <label for="cellphone_number">Αριθμός Κινητού</label>
                                            <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                        </div>
                                    </div>
                                    <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                    <div id="device_list">
                                        <div class="device-item d-flex align-items-end">
                                            <div class="form-group mr-2">
                                                <label for="device_id">Επιλογή Συσκευής</label>
                                                <select class="form-control device-select" name="devices[0][device_id]" required onchange="toggleSerialInput(this)">
                                                    <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                    <option value="none">Χωρίς συσκευή</option>
                                                    <?php foreach ($devices as $device): ?>
                                                        <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                            <div class="form-group">
                                                <label for="serial_number">Σειριακός Αριθμός</label>
                                                <input type="text" class="form-control serial-number" name="devices[0][serial_number]" required>
                                            </div>
                                            <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                        </div>
                                    </div>
                                    <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                    <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
    
                <!-- Customer List -->
                <h2>Λίστα Πελατών</h2>
                <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
                <?php if (count($customers) > 0): ?>
                    <table class="table table-bordered table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>ID</th>
                                <th>Ονοματεπώνυμο</th>
                                <th>Τηλέφωνο Σταθερό</th>
                                <th>Αριθμός Κινητού</th>
                                <th>Ημερομηνία Εγγραφής</th>
                                <th>Ενέργειες</th>
                            </tr>
                        </thead>
                        <tbody id="customerTable">
                            <?php foreach ($customers as $customer): ?>
                            <tr>
                                <td><?= htmlspecialchars($customer['id']) ?></td>
                                <td><?= htmlspecialchars($customer['full_name']) ?></td>
                                <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                                <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                                <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                                <td>
                                    <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                    <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                    <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                    <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                                </td>
                            </tr>
                            <!-- View Customer Modal -->
                            <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                            <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                            <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                            <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                            <h4>Συσκευές σε Κατοχή:</h4>
                                            <ul>
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $device):
                                                ?>
                                                <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                                <?php endforeach; ?>
                                            </ul>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <!-- Edit Customer Modal -->
                            <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <form action="customers.php" method="post">
                                                <input type="hidden" name="action" value="edit_customer">
                                                <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                                <div class="form-group">
                                                    <label for="full_name_<?= $customer['id'] ?>">Ονοματεπώνυμο</label>
                                                    <input type="text" class="form-control" id="full_name_<?= $customer['id'] ?>" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                                </div>
                                                <div class="form-row">
                                                    <div class="form-group col-md-6">
                                                        <label for="landline_phone_<?= $customer['id'] ?>">Τηλέφωνο Σταθερό</label>
                                                        <input type="text" class="form-control" id="landline_phone_<?= $customer['id'] ?>" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                    </div>
                                                    <div class="form-group col-md-6">
                                                        <label for="cellphone_number_<?= $customer['id'] ?>">Αριθμός Κινητού</label>
                                                        <input type="text" class="form-control" id="cellphone_number_<?= $customer['id'] ?>" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                    </div>
                                                </div>
                                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                                <div id="edit_device_list_<?= $customer['id'] ?>">
                                                    <?php
                                                    $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                    foreach ($customer_devices as $index => $device):
                                                    ?>
                                                    <div class="device-item d-flex align-items-end">
                                                        <div class="form-group mr-2">
                                                            <label for="device_id">Επιλογή Συσκευής</label>
                                                            <select class="form-control device-select" name="devices[<?= $index ?>][device_id]" required onchange="toggleSerialInput(this)">
                                                                <option value="" disabled>Επιλέξτε συσκευή</option>
                                                                <option value="none" <?= $device['device_id'] == 'none' ? 'selected' : '' ?>>Χωρίς συσκευή</option>
                                                                <?php foreach ($devices as $d): ?>
                                                                    <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                                <?php endforeach; ?>
                                                            </select>
                                                        </div>
                                                        <div class="form-group">
                                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                                            <input type="text" class="form-control serial-number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>" <?= $device['device_id'] == 'none' ? 'disabled' : '' ?>>
                                                        </div>
                                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                    </div>
                                                    <?php endforeach; ?>
                                                </div>
                                                <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <!-- Delete Customer Modal -->
                            <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                            <form action="customers.php" method="post">
                                                <input type="hidden" name="action" value="delete_customer">
                                                <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                                <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                <?php else: ?>
                    <p>Δεν βρέθηκαν πελάτες.</p>
                <?php endif; ?>
            </div>
        </div>
    
        <div class="footer">
            <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
        </div>
    
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
        <script>
            $(document).ready(function() {
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
    
                $('.modal').on('shown.bs.modal', function () {
                    $(this).find('.device-select').select2({
                        placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                        allowClear: true
                    });
                });
            });
    
            function addDevice(customerId) {
                const deviceList = `#edit_device_list_${customerId}`;
                let index = document.querySelectorAll(`${deviceList} .device-item`).length;
                let newDevice = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <option value="none">Χωρίς συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                document.querySelector(deviceList).insertAdjacentHTML('beforeend', newDevice);
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            }
    
            document.getElementById('add_device').addEventListener('click', function() {
                let index = document.querySelectorAll('#device_list .device-item').length;
                let newDevice = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <option value="none">Χωρίς συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                document.getElementById('device_list').insertAdjacentHTML('beforeend', newDevice);
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            });
    
            function toggleSerialInput(selectElement) {
                const serialInput = selectElement.closest('.device-item').querySelector('.serial-number');
                if (selectElement.value === 'none') {
                    serialInput.value = '';
                    serialInput.disabled = true;
                } else {
                    serialInput.disabled = false;
                }
            }
    
            function removeDevice(button) {
                button.closest('.device-item').remove();
            }
    
            document.getElementById('customerSearch').addEventListener('input', function() {
                let filter = this.value.toLowerCase();
                document.querySelectorAll('#customerTable tr').forEach(row => {
                    let text = row.textContent.toLowerCase();
                    row.style.display = text.includes(filter) ? '' : 'none';
                });
            });
    
            function printCustomer(customerId) {
                window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
            }
        </script>
    </body>
    </html>
    

    Key Adjustments

    1. Consistent Device Handling: The logic for managing devices now mirrors the process used when adding a new customer. We ensure that the list of devices is dynamically handled with consistent identifier variables and proper form input naming.

    2. Device Deletion and Insertion: All devices for a customer are deleted and then re-inserted when updating, ensuring no old device information clutters the database entries.

    3. JavaScript Modifications: For dynamic elements like adding or removing device fields, make sure the dynamic IDs are referenced correctly and that adding functionality keeps indexes unique.

    These changes should ensure that device information is properly processed when editing a customer. If you experience further issues, verify any client-side caching and the data flow in browser DevTools to troubleshoot further.

  9. User

    if edit the existing data and save it then there being saved if i add an additional device and save it then the additional device will not be saved please adjust and provide the complete code

  10. Assistant

    To address the issue of additional devices not being saved when editing a customer, it is crucial to ensure that all data is correctly processed in both client-side (JavaScript) and server-side (PHP). Here’s an adjusted code sample that ensures additional devices are appropriately processed and saved:

    <?php
    // customers.php
    include 'db.php';
    
    // Handle form submissions
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action']) && $_POST['action'] === 'add_customer') {
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
            $registration_date = date('Y-m-d');
    
            $stmt = $pdo->prepare("INSERT INTO customers (full_name, landline_phone, cellphone_number, registration_date) VALUES (?, ?, ?, ?)");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $registration_date]);
            $customer_id = $pdo->lastInsertId();
    
            // Insert new devices
            foreach ($_POST['devices'] as $device) {
                if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                    $device_id = $device['device_id'];
                    $serial_number = $device['serial_number'];
                    $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                    $stmt->execute([$customer_id, $device_id, $serial_number]);
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] === 'edit_customer') {
            $customer_id = $_POST['customer_id'];
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
    
            $stmt = $pdo->prepare("UPDATE customers SET full_name = ?, landline_phone = ?, cellphone_number = ? WHERE id = ?");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $customer_id]);
    
            // Clear old devices and insert updated devices
            if (isset($_POST['devices'])) {
                $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
                $stmt->execute([$customer_id]);
    
                foreach ($_POST['devices'] as $device) {
                    if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                        $device_id = $device['device_id'];
                        $serial_number = $device['serial_number'];
                        $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                        $stmt->execute([$customer_id, $device_id, $serial_number]);
                    }
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] === 'delete_customer') {
            $customer_id = $_POST['customer_id'];
    
            // First, delete related records in the customer_devices table
            $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
            $stmt->execute([$customer_id]);
    
            // Then, delete the customer record
            $stmt = $pdo->prepare("DELETE FROM customers WHERE id = ?");
            $stmt->execute([$customer_id]);
        }
    
        header('Location: customers.php?status=success');
        exit;
    }
    
    // Retrieve available devices for selection
    $devices = $pdo->query("SELECT id, type, brand, model FROM devices")->fetchAll(PDO::FETCH_ASSOC);
    
    // Retrieve customer details for modals (view, edit, delete, print)
    $customers = $pdo->query("SELECT * FROM customers ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
    
    function fetchCustomerDevices($pdo, $customer_id) {
        $stmt = $pdo->prepare("SELECT cd.device_id, cd.serial_number, d.type, d.brand, d.model FROM customer_devices cd JOIN devices d ON cd.device_id = d.id WHERE cd.customer_id = ?");
        $stmt->execute([$customer_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    ?>
    
    <!DOCTYPE html>
    <html lang="el">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Πελάτες - Digihack</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
        <style>
            body {
                display: flex;
                flex-direction: column;
                min-height: 100vh;
                background-color: #f4f6f8;
                font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
                color: #333;
            }
            .container {
                flex: 1;
                margin-top: 20px;
            }
            .navbar {
                background-color: #282828;
            }
            .navbar-brand img {
                height: 40px;
            }
            .nav-link {
                color: #fff !important;
            }
            .nav-link.active {
                font-weight: bold;
                color: #d32f2f !important;
            }
            .content {
                margin-top: 40px;
            }
            .content .form-group label {
                font-weight: bold;
            }
            .content .form-control, .content .form-control-file {
                border-radius: 5px;
            }
            .content .modal-content {
                border-radius: 10px;
            }
            .btn-custom {
                background-color: #007bff;
                color: #fff;
                border: none;
                transition: background-color 0.3s ease;
            }
            .btn-custom:hover {
                background-color: #0056b3;
            }
            .table th, .table td {
                vertical-align: middle;
            }
            .table-hover tbody tr:hover {
                background-color: #f1f1f1;
            }
            .device-item {
                margin-bottom: 15px;
            }
            .device-item .form-group {
                flex: 1 1 auto;
            }
            .device-item .select2-container {
                width: 100% !important;
            }
            .select2-container--default .select2-selection--single {
                border-radius: 0.25rem;
                height: calc(1.5em + 0.75rem + 2px);
                border-color: #ced4da;
            }
            .select2-selection__rendered {
                line-height: 1.5em;
            }
            .select2-selection__arrow {
                top: 50%;
                transform: translateY(-50%);
            }
            @media (max-width: 768px) {
                .device-item {
                    flex-direction: column;
                    align-items: flex-start;
                }
                .device-item .form-group, .device-item .close-btn {
                    width: 100%;
                }
                .device-item .close-btn {
                    text-align: right;
                }
            }
            .footer {
                background-color: #282828;
                color: white;
                border-radius: 10px;
                padding: 20px;
                text-align: center;
            }
            .footer a {
                color: #d32f2f;
                text-decoration: none;
            }
            .footer a:hover {
                text-decoration: underline;
            }
        </style>
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-dark">
            <a class="navbar-brand" href="#"><img src="uploads/digihack-logo-new.png" alt="Digihack"></a>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ml-auto">
                    <li class="nav-item">
                        <a class="nav-link active" href="customers.php">Πελάτες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="services.php">Υπηρεσίες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="devices.php">Συσκευές</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="settings.php">Ρυθμίσεις</a>
                    </li>
                </ul>
            </div>
        </nav>
    
        <div class="container">
            <div class="content">
                <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
                <?php if (isset($_GET['status']) && $_GET['status'] === 'success'): ?>
                    <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
                <?php endif; ?>
    
                <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                    Προσθήκη Νέου Πελάτη
                </button>
    
                <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <form action="customers.php" method="post">
                                    <input type="hidden" name="action" value="add_customer">
                                    <div class="form-group">
                                        <label for="full_name">Ονοματεπώνυμο</label>
                                        <input type="text" class="form-control" id="full_name" name="full_name" required>
                                    </div>
                                    <div class="form-row">
                                        <div class="form-group col-md-6">
                                            <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                            <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                        </div>
                                        <div class="form-group col-md-6">
                                            <label for="cellphone_number">Αριθμός Κινητού</label>
                                            <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                        </div>
                                    </div>
                                    <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                    <div id="device_list">
                                        <div class="device-item d-flex align-items-end">
                                            <div class="form-group mr-2" style="min-width: 200px;">
                                                <label for="device_id">Επιλογή Συσκευής</label>
                                                <select class="form-control device-select" name="devices[0][device_id]" required>
                                                    <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                    <option value="none">Χωρίς συσκευή</option>
                                                    <?php foreach ($devices as $device): ?>
                                                        <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                            <div class="form-group">
                                                <label for="serial_number">Σειριακός Αριθμός</label>
                                                <input type="text" class="form-control serial-number" name="devices[0][serial_number]" required>
                                            </div>
                                            <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                        </div>
                                    </div>
                                    <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                    <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
    
                <!-- Customer List -->
                <h2>Λίστα Πελατών</h2>
                <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
                <?php if (count($customers) > 0): ?>
                    <table class="table table-bordered table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>ID</th>
                                <th>Ονοματεπώνυμο</th>
                                <th>Τηλέφωνο Σταθερό</th>
                                <th>Αριθμός Κινητού</th>
                                <th>Ημερομηνία Εγγραφής</th>
                                <th>Ενέργειες</th>
                            </tr>
                        </thead>
                        <tbody id="customerTable">
                            <?php foreach ($customers as $customer): ?>
                            <tr>
                                <td><?= htmlspecialchars($customer['id']) ?></td>
                                <td><?= htmlspecialchars($customer['full_name']) ?></td>
                                <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                                <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                                <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                                <td>
                                    <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                    <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                    <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                    <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                                </td>
                            </tr>
                            <!-- View Customer Modal -->
                            <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                            <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                            <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                            <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                            <h4>Συσκευές σε Κατοχή:</h4>
                                            <ul>
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $device):
                                                ?>
                                                <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                                <?php endforeach; ?>
                                            </ul>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <!-- Edit Customer Modal -->
                            <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <form action="customers.php" method="post">
                                                <input type="hidden" name="action" value="edit_customer">
                                                <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                                <div class="form-group">
                                                    <label for="full_name_<?= $customer['id'] ?>">Ονοματεπώνυμο</label>
                                                    <input type="text" class="form-control" id="full_name_<?= $customer['id'] ?>" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                                </div>
                                                <div class="form-row">
                                                    <div class="form-group col-md-6">
                                                        <label for="landline_phone_<?= $customer['id'] ?>">Τηλέφωνο Σταθερό</label>
                                                        <input type="text" class="form-control" id="landline_phone_<?= $customer['id'] ?>" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                    </div>
                                                    <div class="form-group col-md-6">
                                                        <label for="cellphone_number_<?= $customer['id'] ?>">Αριθμός Κινητού</label>
                                                        <input type="text" class="form-control" id="cellphone_number_<?= $customer['id'] ?>" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                    </div>
                                                </div>
                                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                                <div id="edit_device_list_<?= $customer['id'] ?>">
                                                    <?php
                                                    $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                    foreach ($customer_devices as $index => $device):
                                                    ?>
                                                    <div class="device-item d-flex align-items-end">
                                                        <div class="form-group mr-2" style="min-width: 200px;">
                                                            <label for="device_id">Επιλογή Συσκευής</label>
                                                            <select class="form-control device-select" name="devices[<?= $index ?>][device_id]" required>
                                                                <option value="" disabled>Επιλέξτε συσκευή</option>
                                                                <option value="none" <?= $device['device_id'] === 'none' ? 'selected' : '' ?>>Χωρίς συσκευή</option>
                                                                <?php foreach ($devices as $d): ?>
                                                                    <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                                <?php endforeach; ?>
                                                            </select>
                                                        </div>
                                                        <div class="form-group">
                                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                                            <input type="text" class="form-control serial-number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>" <?= $device['device_id'] === 'none' ? 'disabled' : '' ?>>
                                                        </div>
                                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                    </div>
                                                    <?php endforeach; ?>
                                                </div>
                                                <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <!-- Delete Customer Modal -->
                            <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                                <div class="modal-dialog modal-lg">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                            <form action="customers.php" method="post">
                                                <input type="hidden" name="action" value="delete_customer">
                                                <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                                <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
    
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                <?php else: ?>
                    <p>Δεν βρέθηκαν πελάτες.</p>
                <?php endif; ?>
            </div>
        </div>
    
        <div class="footer">
            <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
        </div>
    
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
        <script>
            $(document).ready(function() {
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
    
                $('.modal').on('shown.bs.modal', function () {
                    $(this).find('.device-select').select2({
                        placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                        allowClear: true
                    });
                });
            });
    
            function addDevice(customerId) {
                const deviceListId = `edit_device_list_${customerId}`;
                const deviceList = document.getElementById(deviceListId);
                const index = deviceList.querySelectorAll('.device-item').length;
                const newDeviceHtml = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2" style="min-width: 200px;">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <option value="none">Χωρίς συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
    
                deviceList.insertAdjacentHTML('beforeend', newDeviceHtml);
                $(`#${deviceListId} .device-select`).select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            }
    
            document.getElementById('add_device').addEventListener('click', function() {
                const deviceList = document.getElementById('device_list');
                const index = deviceList.querySelectorAll('.device-item').length;
                const newDeviceHtml = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2" style="min-width: 200px;">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <option value="none">Χωρίς συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
    
                deviceList.insertAdjacentHTML('beforeend', newDeviceHtml);
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            });
    
            function removeDevice(button) {
                button.closest('.device-item').remove();
            }
    
            document.getElementById('customerSearch').addEventListener('input', function() {
                const filter = this.value.toLowerCase();
                document.querySelectorAll('#customerTable tr').forEach(row => {
                    const text = row.textContent.toLowerCase();
                    row.style.display = text.includes(filter) ? '' : 'none';
                });
            });
    
            function printCustomer(customerId) {
                window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
            }
        </script>
    </body>
    </html>
    

    Key Adjustments

    1. Correct Form Handling: The JavaScript addDevice function updates the device list within the form modal. This ensures that new device entries are correctly added with unique indices.

    2. Ensure Device List Consistency: When a device is added, ensure that it updates the proper device list using consistent ID references (#edit_device_list_${customerId}) so the newly added devices are positioned correctly in the form.

    3. Dynamic Indexing in JavaScript: By determining the index dynamically, your form can always maintain correct indexing, even if multiple devices are added or removed.

    These changes should resolve the issue with additional devices not being saved. Please test the code and review how the changes impact the saving of new devices when editing a customer.

  11. User

    issue persists and it's worse please verify fix everything related and provide the full complete adjusted code

  12. Assistant

    It seems there might be confusion or issues with both the server-side handling of devices and the client-side JavaScript that's adding or managing the dynamic inputs for devices. Let's address this holistically by restructuring the code to ensure everything correctly handles the addition, update, and deletion of devices when editing a customer.

    I'll proceed by ensuring:

    1. Server-side Logic: We properly handle both the retrieval and saving of devices associated with a customer.
    2. JavaScript Logic: Properly manage dynamic form fields for devices and ensure changes are accurately reflected in the data sent to the server.

    Here's how you can adjust the code:

    <?php
    // customers.php
    include 'db.php';
    
    // Handle form submissions
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action']) && $_POST['action'] === 'add_customer') {
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
            $registration_date = date('Y-m-d');
    
            $stmt = $pdo->prepare("INSERT INTO customers (full_name, landline_phone, cellphone_number, registration_date) VALUES (?, ?, ?, ?)");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $registration_date]);
            $customer_id = $pdo->lastInsertId();
    
            foreach ($_POST['devices'] as $device) {
                if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                    $device_id = $device['device_id'];
                    $serial_number = $device['serial_number'];
                    $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                    $stmt->execute([$customer_id, $device_id, $serial_number]);
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] === 'edit_customer') {
            $customer_id = $_POST['customer_id'];
            $full_name = $_POST['full_name'];
            $landline_phone = $_POST['landline_phone'];
            $cellphone_number = $_POST['cellphone_number'];
    
            $stmt = $pdo->prepare("UPDATE customers SET full_name = ?, landline_phone = ?, cellphone_number = ? WHERE id = ?");
            $stmt->execute([$full_name, $landline_phone, $cellphone_number, $customer_id]);
    
            // Clear old devices and insert updated devices
            $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
            $stmt->execute([$customer_id]);
    
            if (isset($_POST['devices'])) {
                foreach ($_POST['devices'] as $device) {
                    if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
                        $device_id = $device['device_id'];
                        $serial_number = $device['serial_number'];
                        $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
                        $stmt->execute([$customer_id, $device_id, $serial_number]);
                    }
                }
            }
        } elseif (isset($_POST['action']) && $_POST['action'] === 'delete_customer') {
            $customer_id = $_POST['customer_id'];
            $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
            $stmt->execute([$customer_id]);
    
            $stmt = $pdo->prepare("DELETE FROM customers WHERE id = ?");
            $stmt->execute([$customer_id]);
        }
    
        header('Location: customers.php?status=success');
        exit;
    }
    
    // Retrieve available devices for selection
    $devices = $pdo->query("SELECT id, type, brand, model FROM devices")->fetchAll(PDO::FETCH_ASSOC);
    
    // Retrieve customer details for modals (view, edit, delete, print)
    $customers = $pdo->query("SELECT * FROM customers ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
    
    function fetchCustomerDevices($pdo, $customer_id) {
        $stmt = $pdo->prepare("SELECT cd.device_id, cd.serial_number, d.type, d.brand, d.model FROM customer_devices cd JOIN devices d ON cd.device_id = d.id WHERE cd.customer_id = ?");
        $stmt->execute([$customer_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    ?>
    
    <!DOCTYPE html>
    <html lang="el">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Πελάτες - Digihack</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
        <style>
            body {
                background-color: #f4f6f8;
                font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
                color: #333;
            }
            .navbar {
                background-color: #282828;
            }
            .navbar-brand img {
                height: 40px;
            }
            .nav-link {
                color: #fff !important;
            }
            .nav-link.active {
                font-weight: bold;
                color: #d32f2f !important;
            }
            .modal-content {
                border-radius: 10px;
            }
            .btn-custom {
                background-color: #007bff;
                color: #fff;
                border: none;
            }
            .btn-custom:hover {
                background-color: #0056b3;
            }
            .device-item {
                margin-bottom: 15px;
            }
            .device-item .form-group {
                flex: 1 1 auto;
            }
            .select2-container--default .select2-selection--single {
                border-radius: 0.25rem;
                height: calc(1.5em + 0.75rem + 2px);
                border-color: #ced4da;
            }
            .select2-selection__rendered {
                line-height: 1.5em;
            }
            .select2-selection__arrow {
                top: 50%;
                transform: translateY(-50%);
            }
            .footer {
                background-color: #282828;
                color: white;
                padding: 20px;
                text-align: center;
            }
            .footer a {
                color: #d32f2f;
                text-decoration: none;
            }
            .footer a:hover {
                text-decoration: underline;
            }
        </style>
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-dark">
            <a class="navbar-brand" href="#"><img src="uploads/digihack-logo-new.png" alt="Digihack"></a>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ml-auto">
                    <li class="nav-item">
                        <a class="nav-link active" href="customers.php">Πελάτες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="services.php">Υπηρεσίες</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="devices.php">Συσκευές</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="settings.php">Ρυθμίσεις</a>
                    </li>
                </ul>
            </div>
        </nav>
    
        <div class="container mt-4">
            <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
            <?php if (isset($_GET['status']) && $_GET['status'] == 'success'): ?>
                <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
            <?php endif; ?>
    
            <!-- Button for adding new customer -->
            <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                Προσθήκη Νέου Πελάτη
            </button>
    
            <!-- Modal for adding new customer -->
            <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-body">
                            <form action="customers.php" method="post">
                                <input type="hidden" name="action" value="add_customer">
                                <div class="form-group">
                                    <label for="full_name">Ονοματεπώνυμο</label>
                                    <input type="text" class="form-control" id="full_name" name="full_name" required>
                                </div>
                                <div class="form-row">
                                    <div class="form-group col-md-6">
                                        <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                        <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="cellphone_number">Αριθμός Κινητού</label>
                                        <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                    </div>
                                </div>
                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                <div id="device_list">
                                    <div class="device-item d-flex align-items-end">
                                        <div class="form-group mr-2">
                                            <label for="device_id">Επιλογή Συσκευής</label>
                                            <select class="form-control device-select" name="devices[0][device_id]" onchange="toggleSerialInput(this)">
                                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                <?php foreach ($devices as $device): ?>
                                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                            <input type="text" class="form-control serial-number" name="devices[0][serial_number]">
                                        </div>
                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                    </div>
                                </div>
                                <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
    
            <!-- Customer List -->
            <h2>Λίστα Πελατών</h2>
            <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
            <?php if (count($customers) > 0): ?>
                <table class="table table-bordered table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>ID</th>
                            <th>Ονοματεπώνυμο</th>
                            <th>Τηλέφωνο Σταθερό</th>
                            <th>Αριθμός Κινητού</th>
                            <th>Ημερομηνία Εγγραφής</th>
                            <th>Ενέργειες</th>
                        </tr>
                    </thead>
                    <tbody id="customerTable">
                        <?php foreach ($customers as $customer): ?>
                        <tr>
                            <td><?= htmlspecialchars($customer['id']) ?></td>
                            <td><?= htmlspecialchars($customer['full_name']) ?></td>
                            <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                            <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                            <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                            <td>
                                <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                            </td>
                        </tr>
                        <!-- View Customer Modal -->
                        <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                        <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                        <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                        <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                        <h4>Συσκευές σε Κατοχή:</h4>
                                        <ul>
                                            <?php
                                            $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                            foreach ($customer_devices as $device):
                                            ?>
                                            <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                            <?php endforeach; ?>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <!-- Edit Customer Modal -->
                        <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="edit_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <div class="form-group">
                                                <label for="full_name_<?= $customer['id'] ?>">Ονοματεπώνυμο</label>
                                                <input type="text" class="form-control" id="full_name_<?= $customer['id'] ?>" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                            </div>
                                            <div class="form-row">
                                                <div class="form-group col-md-6">
                                                    <label for="landline_phone_<?= $customer['id'] ?>">Τηλέφωνο Σταθερό</label>
                                                    <input type="text" class="form-control" id="landline_phone_<?= $customer['id'] ?>" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                </div>
                                                <div class="form-group col-md-6">
                                                    <label for="cellphone_number_<?= $customer['id'] ?>">Αριθμός Κινητού</label>
                                                    <input type="text" class="form-control" id="cellphone_number_<?= $customer['id'] ?>" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                </div>
                                            </div>
                                            <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                            <div id="edit_device_list_<?= $customer['id'] ?>">
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $index => $device):
                                                ?>
                                                <div class="device-item d-flex align-items-end">
                                                    <div class="form-group mr-2">
                                                        <label for="device_id">Επιλογή Συσκευής</label>
                                                        <select class="form-control device-select" name="devices[<?= $index ?>][device_id]" onchange="toggleSerialInput(this)">
                                                            <option value="" disabled>Επιλέξτε συσκευή</option>
                                                            <?php foreach ($devices as $d): ?>
                                                                <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                            <?php endforeach; ?>
                                                        </select>
                                                    </div>
                                                    <div class="form-group">
                                                        <label for="serial_number">Σειριακός Αριθμός</label>
                                                        <input type="text" class="form-control serial-number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>">
                                                    </div>
                                                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                </div>
                                                <?php endforeach; ?>
                                            </div>
                                            <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                            <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <!-- Delete Customer Modal -->
                        <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="delete_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <?php endforeach; ?>
                    </tbody>
                </table>
            <?php else: ?>
                <p>Δεν βρέθηκαν πελάτες.</p>
            <?php endif; ?>
        </div>
    
        <div class="footer">
            <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
        </div>
    
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
        <script>
            $(document).ready(function() {
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
    
                $('.modal').on('shown.bs.modal', function () {
                    $(this).find('.device-select').select2({
                        placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                        allowClear: true
                    });
                });
            });
    
            function addDevice(customerId) {
                const deviceList = document.getElementById(`edit_device_list_${customerId}`);
                const index = deviceList ? deviceList.querySelectorAll('.device-item').length : 0;
                const newDeviceHtml = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
    
                deviceList.insertAdjacentHTML('beforeend', newDeviceHtml);
                $(deviceList).find('.device-select').last().select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            }
    
            document.getElementById('add_device').addEventListener('click', function() {
                const deviceList = document.getElementById('device_list');
                const index = deviceList.querySelectorAll('.device-item').length;
                const newDeviceHtml = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
    
                deviceList.insertAdjacentHTML('beforeend', newDeviceHtml);
                $(deviceList).find('.device-select').last().select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            });
    
            function removeDevice(button) {
                button.closest('.device-item').remove();
            }
    
            document.getElementById('customerSearch').addEventListener('input', function() {
                const filter = this.value.toLowerCase();
                document.querySelectorAll('#customerTable tr').forEach(row => {
                    const text = row.textContent.toLowerCase();
                    row.style.display = text.includes(filter) ? '' : 'none';
                });
            });
    
            function printCustomer(customerId) {
                window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
            }
        </script>
    </body>
    </html>
    

    Key Adjustments:

    1. Consistent Device Handling: Ensure consistent use of div IDs and form field names across adding and editing operations.

    2. Clear and Add: When updating customer details, old device entries are cleared and new ones are inserted based on the form inputs.

    3. Dynamic Elements: Use JavaScript to maintain dynamic additions/removals of elements and use Select2 for enhanced UI.

    This comprehensive approach ensures that existing and additional devices are processed reliably when you edit a customer. Please test and verify its operation in your specific setup.

  13. User

    it can't be less lines please provide the complete adjusted corrected code with everything working please also take the database for reference as it will help you to correct the issue :

    -- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/

    -- Εξυπηρετητής: 127.0.0.1 -- Χρόνος δημιουργίας: 25 Οκτ 2024 στις 12:50:00 -- Έκδοση διακομιστή: 10.4.32-MariaDB -- Έκδοση PHP: 8.0.30

    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 */;

    -- -- Βάση δεδομένων: tech_store


    -- -- Δομή πίνακα για τον πίνακα customers

    CREATE TABLE customers ( id int(11) NOT NULL, full_name varchar(100) NOT NULL, landline_phone varchar(20) DEFAULT NULL, cellphone_number varchar(20) DEFAULT NULL, registration_date date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


    -- -- Δομή πίνακα για τον πίνακα customer_devices

    CREATE TABLE customer_devices ( id int(11) NOT NULL, customer_id int(11) NOT NULL, device_id int(11) NOT NULL, serial_number varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


    -- -- Δομή πίνακα για τον πίνακα devices

    CREATE TABLE devices ( id int(11) NOT NULL, type varchar(50) NOT NULL, brand varchar(50) NOT NULL, model varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


    -- -- Δομή πίνακα για τον πίνακα services

    CREATE TABLE services ( id int(11) NOT NULL, customer_id int(11) DEFAULT NULL, service_number varchar(50) DEFAULT NULL, service_date date DEFAULT NULL, comments text DEFAULT NULL, technician_comments text DEFAULT NULL, amount_paid decimal(10,2) DEFAULT NULL, device_id int(11) DEFAULT NULL, status varchar(50) DEFAULT NULL, delivered_date date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


    -- -- Δομή πίνακα για τον πίνακα settings

    CREATE TABLE settings ( id int(11) NOT NULL, store_name varchar(100) DEFAULT NULL, address text DEFAULT NULL, phone_number varchar(20) DEFAULT NULL, logo_path varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

    -- -- Ευρετήρια για άχρηστους πίνακες

    -- -- Ευρετήρια για πίνακα customers

    ALTER TABLE customers ADD PRIMARY KEY (id);

    -- -- Ευρετήρια για πίνακα customer_devices

    ALTER TABLE customer_devices ADD PRIMARY KEY (id), ADD KEY customer_id (customer_id), ADD KEY device_id (device_id);

    -- -- Ευρετήρια για πίνακα devices

    ALTER TABLE devices ADD PRIMARY KEY (id);

    -- -- Ευρετήρια για πίνακα services

    ALTER TABLE services ADD PRIMARY KEY (id), ADD UNIQUE KEY service_number (service_number), ADD KEY customer_id (customer_id), ADD KEY device_id (device_id);

    -- -- Ευρετήρια για πίνακα settings

    ALTER TABLE settings ADD PRIMARY KEY (id);

    -- -- AUTO_INCREMENT για άχρηστους πίνακες

    -- -- AUTO_INCREMENT για πίνακα customers

    ALTER TABLE customers MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT για πίνακα customer_devices

    ALTER TABLE customer_devices MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT για πίνακα devices

    ALTER TABLE devices MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT για πίνακα services

    ALTER TABLE services MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT για πίνακα settings

    ALTER TABLE settings MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- Περιορισμοί για άχρηστους πίνακες

    -- -- Περιορισμοί για πίνακα customer_devices

    ALTER TABLE customer_devices ADD CONSTRAINT customer_devices_ibfk_1 FOREIGN KEY (customer_id) REFERENCES customers (id), ADD CONSTRAINT customer_devices_ibfk_2 FOREIGN KEY (device_id) REFERENCES devices (id);

    -- -- Περιορισμοί για πίνακα services

    ALTER TABLE services ADD CONSTRAINT services_ibfk_1 FOREIGN KEY (customer_id) REFERENCES customers (id), ADD CONSTRAINT services_ibfk_2 FOREIGN KEY (device_id) REFERENCES devices (id); COMMIT;

    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

  14. Assistant

    Based on the database schema and the requirements, let's create a PHP application that allows you to manage customers and their devices effectively. This script will focus on adding, editing, and viewing customer details, including devices.

    Database Tables Reference:

    1. customers: This table holds basic information about customers.
    2. customer_devices: This stores associations between customers and their devices.
    3. devices: This table contains the details about various devices.

    Here's the complete adjusted PHP and HTML code:

    <?php
    // customers.php
    include 'db.php';
    
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action'])) {
            if ($_POST['action'] === 'add_customer') {
                // Add new customer
                $full_name = $_POST['full_name'];
                $landline_phone = $_POST['landline_phone'];
                $cellphone_number = $_POST['cellphone_number'];
                $registration_date = date('Y-m-d');
    
                $stmt = $pdo->prepare("INSERT INTO customers (full_name, landline_phone, cellphone_number, registration_date) VALUES (?, ?, ?, ?)");
                $stmt->execute([$full_name, $landline_phone, $cellphone_number, $registration_date]);
                $customer_id = $pdo->lastInsertId();
    
                foreach ($_POST['devices'] as $device) {
                    saveDevice($pdo, $customer_id, $device);
                }
    
            } elseif ($_POST['action'] === 'edit_customer') {
                // Edit existing customer
                $customer_id = $_POST['customer_id'];
                $full_name = $_POST['full_name'];
                $landline_phone = $_POST['landline_phone'];
                $cellphone_number = $_POST['cellphone_number'];
    
                $stmt = $pdo->prepare("UPDATE customers SET full_name = ?, landline_phone = ?, cellphone_number = ? WHERE id = ?");
                $stmt->execute([$full_name, $landline_phone, $cellphone_number, $customer_id]);
    
                // Handle devices: delete old and insert new
                $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
                $stmt->execute([$customer_id]);
    
                foreach ($_POST['devices'] as $device) {
                    saveDevice($pdo, $customer_id, $device);
                }
            }
        }
        header('Location: customers.php?status=success');
        exit;
    }
    
    // Save Device
    function saveDevice($pdo, $customer_id, $device) {
        if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
            $device_id = $device['device_id'];
            $serial_number = $device['serial_number'];
            $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
            $stmt->execute([$customer_id, $device_id, $serial_number]);
        }
    }
    
    // Retrieve available devices for selection
    $devices = $pdo->query("SELECT id, type, brand, model FROM devices")->fetchAll(PDO::FETCH_ASSOC);
    $customers = $pdo->query("SELECT * FROM customers ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
    
    function fetchCustomerDevices($pdo, $customer_id) {
        $stmt = $pdo->prepare("SELECT cd.device_id, cd.serial_number, d.type, d.brand, d.model FROM customer_devices cd JOIN devices d ON cd.device_id = d.id WHERE cd.customer_id = ?");
        $stmt->execute([$customer_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    ?>
    
    <!DOCTYPE html>
    <html lang="el">
    <head>
        <meta charset="UTF-8">
        <title>Πελάτες - Digihack</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
        <style>
            body { background-color: #f4f6f8; font-family: 'Segoe UI', Tahoma, Geneva, Verdana; color: #333; }
            .navbar { background-color: #282828; }
            .navbar-brand img { height: 40px; }
            .nav-link { color: #fff !important; }
            .nav-link.active { font-weight: bold; color: #d32f2f !important; }
            .modal-content { border-radius: 10px; }
            .device-item { margin-bottom: 15px; }
            .footer { background-color: #282828; color: white; padding: 20px; text-align: center; }
            .footer a { color: #d32f2f; text-decoration: none; }
            .footer a:hover { text-decoration: underline; }
        </style>
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-dark">
            <a class="navbar-brand" href="#"><img src="uploads/digihack-logo-new.png" alt="Digihack"></a>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ml-auto">
                    <li class="nav-item"><a class="nav-link active" href="customers.php">Πελάτες</a></li>
                    <li class="nav-item"><a class="nav-link" href="services.php">Υπηρεσίες</a></li>
                    <li class="nav-item"><a class="nav-link" href="devices.php">Συσκευές</a></li>
                    <li class="nav-item"><a class="nav-link" href="settings.php">Ρυθμίσεις</a></li>
                </ul>
            </div>
        </nav>
    
        <div class="container mt-4">
            <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
            <?php if (isset($_GET['status']) && $_GET['status'] === 'success'): ?>
                <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
            <?php endif; ?>
    
            <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                Προσθήκη Νέου Πελάτη
            </button>
    
            <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-body">
                            <form action="customers.php" method="post">
                                <input type="hidden" name="action" value="add_customer">
                                <div class="form-group">
                                    <label for="full_name">Ονοματεπώνυμο</label>
                                    <input type="text" class="form-control" id="full_name" name="full_name" required>
                                </div>
                                <div class="form-row">
                                    <div class="form-group col-md-6">
                                        <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                        <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="cellphone_number">Αριθμός Κινητού</label>
                                        <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                    </div>
                                </div>
                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                <div id="device_list">
                                    <div class="device-item d-flex align-items-end">
                                        <div class="form-group mr-2">
                                            <label for="device_id">Επιλογή Συσκευής</label>
                                            <select class="form-control device-select" name="devices[0][device_id]" required>
                                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                <?php foreach ($devices as $device): ?>
                                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                            <input type="text" class="form-control serial-number" name="devices[0][serial_number]" required>
                                        </div>
                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                    </div>
                                </div>
                                <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
    
            <h2>Λίστα Πελατών</h2>
            <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
            <?php if (count($customers) > 0): ?>
                <table class="table table-bordered table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>ID</th>
                            <th>Ονοματεπώνυμο</th>
                            <th>Τηλέφωνο Σταθερό</th>
                            <th>Αριθμός Κινητού</th>
                            <th>Ημερομηνία Εγγραφής</th>
                            <th>Ενέργειες</th>
                        </tr>
                    </thead>
                    <tbody id="customerTable">
                        <?php foreach ($customers as $customer): ?>
                        <tr>
                            <td><?= htmlspecialchars($customer['id']) ?></td>
                            <td><?= htmlspecialchars($customer['full_name']) ?></td>
                            <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                            <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                            <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                            <td>
                                <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                            </td>
                        </tr>
                        <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                        <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                        <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                        <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                        <h4>Συσκευές σε Κατοχή:</h4>
                                        <ul>
                                            <?php
                                            $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                            foreach ($customer_devices as $device):
                                            ?>
                                            <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                            <?php endforeach; ?>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="edit_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <div class="form-group">
                                                <label for="full_name_<?= $customer['id'] ?>">Ονοματεπώνυμο</label>
                                                <input type="text" class="form-control" id="full_name_<?= $customer['id'] ?>" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                            </div>
                                            <div class="form-row">
                                                <div class="form-group col-md-6">
                                                    <label for="landline_phone_<?= $customer['id'] ?>">Τηλέφωνο Σταθερό</label>
                                                    <input type="text" class="form-control" id="landline_phone_<?= $customer['id'] ?>" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                </div>
                                                <div class="form-group col-md-6">
                                                    <label for="cellphone_number_<?= $customer['id'] ?>">Αριθμός Κινητού</label>
                                                    <input type="text" class="form-control" id="cellphone_number_<?= $customer['id'] ?>" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                </div>
                                            </div>
                                            <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                            <div id="edit_device_list_<?= $customer['id'] ?>">
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $index => $device):
                                                ?>
                                                <div class="device-item d-flex align-items-end">
                                                    <div class="form-group mr-2">
                                                        <label for="device_id">Επιλογή Συσκευής</label>
                                                        <select class="form-control device-select" name="devices[<?= $index ?>][device_id]">
                                                            <option value="" disabled>Επιλέξτε συσκευή</option>
                                                            <?php foreach ($devices as $d): ?>
                                                                <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                            <?php endforeach; ?>
                                                        </select>
                                                    </div>
                                                    <div class="form-group">
                                                        <label for="serial_number">Σειριακός Αριθμός</label>
                                                        <input type="text" class="form-control serial-number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>">
                                                    </div>
                                                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                </div>
                                                <?php endforeach; ?>
                                            </div>
                                            <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                            <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="delete_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <?php endforeach; ?>
                    </tbody>
                </table>
            <?php else: ?>
                <p>Δεν βρέθηκαν πελάτες.</p>
            <?php endif; ?>
        </div>
    
        <div class="footer">
            <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
        </div>
    
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
        <script>
            $(document).ready(function() {
                $('.device-select').select2();
    
                $('.modal').on('shown.bs.modal', function() {
                    $(this).find('.device-select').select2();
                });
            });
    
            function addDevice(customerId) {
                const deviceList = document.getElementById(`edit_device_list_${customerId}`);
                const index = deviceList.querySelectorAll('.device-item').length;
                const html = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                deviceList.insertAdjacentHTML('beforeend', html);
                $(deviceList).find('.device-select').last().select2();
            }
    
            document.getElementById('add_device').addEventListener('click', function() {
                const deviceList = document.getElementById('device_list');
                const index = deviceList.querySelectorAll('.device-item').length;
                const html = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                deviceList.insertAdjacentHTML('beforeend', html);
                $(deviceList).find('.device-select').last().select2();
            });
    
            function removeDevice(button) {
                button.closest('.device-item').remove();
            }
    
            document.getElementById('customerSearch').addEventListener('input', function() {
                const filter = this.value.toLowerCase();
                document.querySelectorAll('#customerTable tr').forEach(row => {
                    const text = row.textContent.toLowerCase();
                    row.style.display = text.includes(filter) ? '' : 'none';
                });
            });
    
            function printCustomer(customerId) {
                window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
            }
        </script>
    </body>
    </html>
    

    Key Considerations:

    1. Data Model: The code is based on the database model you provided. Ensure your database is consistent with this model before running the script.
    2. Dynamic Handling: JavaScript is used to add device inputs dynamically with insertAdjacentHTML and select2 for better UX.
    3. Device Persistence: The saveDevice function inserts each device into the customer_devices table linked by the customer_id.
    4. Testing: Ensure this code is tested in a secure environment, and be mindful of security practices such as input sanitization (handled here with PHP's htmlspecialchars).

    After implementing and running this, be sure to test thoroughly, especially the modals for adding/editing customers and their associated devices.

  15. User

    when i press edit and i add device and save it's not being saved please fix it and always use select 2 and provide with the complete code

  16. Assistant

    To ensure that devices are always saved correctly when adding or editing a customer, let's ensure that both the server-side and client-side code handle the data properly. In particular, we'll need to address how the HTML form is structured, how JavaScript handles dynamic form elements, and how data is processed on the server.

    Below is a complete PHP script with HTML and JavaScript, wherein the issue of saving additional devices on editing should be resolved. I've ensured that every device input is correctly handled using select2 for enhanced selection UI.

    Here is the complete code for managing customers and their devices:

    <?php
    // customers.php
    include 'db.php';
    
    // Handle form submissions
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action'])) {
            if ($_POST['action'] === 'add_customer') {
                // Add new customer
                $full_name = $_POST['full_name'];
                $landline_phone = $_POST['landline_phone'];
                $cellphone_number = $_POST['cellphone_number'];
                $registration_date = date('Y-m-d');
                
                $stmt = $pdo->prepare("INSERT INTO customers (full_name, landline_phone, cellphone_number, registration_date) VALUES (?, ?, ?, ?)");
                $stmt->execute([$full_name, $landline_phone, $cellphone_number, $registration_date]);
                $customer_id = $pdo->lastInsertId();
    
                // Insert devices
                foreach ($_POST['devices'] as $device) {
                    saveDevice($pdo, $customer_id, $device);
                }
    
            } elseif ($_POST['action'] === 'edit_customer') {
                // Edit existing customer
                $customer_id = $_POST['customer_id'];
                $full_name = $_POST['full_name'];
                $landline_phone = $_POST['landline_phone'];
                $cellphone_number = $_POST['cellphone_number'];
    
                $stmt = $pdo->prepare("UPDATE customers SET full_name = ?, landline_phone = ?, cellphone_number = ? WHERE id = ?");
                $stmt->execute([$full_name, $landline_phone, $cellphone_number, $customer_id]);
    
                // Clear old devices and insert updated ones
                $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
                $stmt->execute([$customer_id]);
    
                foreach ($_POST['devices'] as $device) {
                    saveDevice($pdo, $customer_id, $device);
                }
            }
        }
        header('Location: customers.php?status=success');
        exit;
    }
    
    function saveDevice($pdo, $customer_id, $device) {
        if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
            $device_id = $device['device_id'];
            $serial_number = $device['serial_number'];
            $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
            $stmt->execute([$customer_id, $device_id, $serial_number]);
        }
    }
    
    // Retrieve available devices for selection
    $devices = $pdo->query("SELECT id, type, brand, model FROM devices")->fetchAll(PDO::FETCH_ASSOC);
    $customers = $pdo->query("SELECT * FROM customers ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
    
    function fetchCustomerDevices($pdo, $customer_id) {
        $stmt = $pdo->prepare("SELECT cd.device_id, cd.serial_number, d.type, d.brand, d.model FROM customer_devices cd JOIN devices d ON cd.device_id = d.id WHERE cd.customer_id = ?");
        $stmt->execute([$customer_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    ?>
    
    <!DOCTYPE html>
    <html lang="el">
    <head>
        <meta charset="UTF-8">
        <title>Πελάτες - Digihack</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
        <style>
            body { background-color: #f4f6f8; font-family: 'Segoe UI', Tahoma, Geneva, Verdana; color: #333; }
            .navbar { background-color: #282828; }
            .navbar-brand img { height: 40px; }
            .nav-link { color: #fff !important; }
            .nav-link.active { font-weight: bold; color: #d32f2f !important; }
            .modal-content { border-radius: 10px; }
            .device-item { margin-bottom: 15px; }
            .footer { background-color: #282828; color: white; padding: 20px; text-align: center; }
            .footer a { color: #d32f2f; text-decoration: none; }
            .footer a:hover { text-decoration: underline; }
        </style>
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-dark">
            <a class="navbar-brand" href="#"><img src="uploads/digihack-logo-new.png" alt="Digihack"></a>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ml-auto">
                    <li class="nav-item"><a class="nav-link active" href="customers.php">Πελάτες</a></li>
                    <li class="nav-item"><a class="nav-link" href="services.php">Υπηρεσίες</a></li>
                    <li class="nav-item"><a class="nav-link" href="devices.php">Συσκευές</a></li>
                    <li class="nav-item"><a class="nav-link" href="settings.php">Ρυθμίσεις</a></li>
                </ul>
            </div>
        </nav>
    
        <div class="container mt-4">
            <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
            <?php if (isset($_GET['status']) && $_GET['status'] === 'success'): ?>
                <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
            <?php endif; ?>
    
            <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                Προσθήκη Νέου Πελάτη
            </button>
    
            <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-body">
                            <form action="customers.php" method="post">
                                <input type="hidden" name="action" value="add_customer">
                                <div class="form-group">
                                    <label for="full_name">Ονοματεπώνυμο</label>
                                    <input type="text" class="form-control" id="full_name" name="full_name" required>
                                </div>
                                <div class="form-row">
                                    <div class="form-group col-md-6">
                                        <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                        <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="cellphone_number">Αριθμός Κινητού</label>
                                        <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                    </div>
                                </div>
                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                <div id="device_list">
                                    <div class="device-item d-flex align-items-end">
                                        <div class="form-group mr-2">
                                            <label for="device_id">Επιλογή Συσκευής</label>
                                            <select class="form-control device-select" name="devices[0][device_id]" required>
                                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                <?php foreach ($devices as $device): ?>
                                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                            <input type="text" class="form-control serial-number" name="devices[0][serial_number]">
                                        </div>
                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                    </div>
                                </div>
                                <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
    
            <h2>Λίστα Πελατών</h2>
            <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
            <?php if (count($customers) > 0): ?>
                <table class="table table-bordered table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>ID</th>
                            <th>Ονοματεπώνυμο</th>
                            <th>Τηλέφωνο Σταθερό</th>
                            <th>Αριθμός Κινητού</th>
                            <th>Ημερομηνία Εγγραφής</th>
                            <th>Ενέργειες</th>
                        </tr>
                    </thead>
                    <tbody id="customerTable">
                        <?php foreach ($customers as $customer): ?>
                        <tr>
                            <td><?= htmlspecialchars($customer['id']) ?></td>
                            <td><?= htmlspecialchars($customer['full_name']) ?></td>
                            <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                            <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                            <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                            <td>
                                <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                            </td>
                        </tr>
                        <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                        <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                        <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                        <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                        <h4>Συσκευές σε Κατοχή:</h4>
                                        <ul>
                                            <?php
                                            $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                            foreach ($customer_devices as $device):
                                            ?>
                                            <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                            <?php endforeach; ?>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="edit_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <div class="form-group">
                                                <label for="full_name_<?= $customer['id'] ?>">Ονοματεπώνυμο</label>
                                                <input type="text" class="form-control" id="full_name_<?= $customer['id'] ?>" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                            </div>
                                            <div class="form-row">
                                                <div class="form-group col-md-6">
                                                    <label for="landline_phone_<?= $customer['id'] ?>">Τηλέφωνο Σταθερό</label>
                                                    <input type="text" class="form-control" id="landline_phone_<?= $customer['id'] ?>" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                </div>
                                                <div class="form-group col-md-6">
                                                    <label for="cellphone_number_<?= $customer['id'] ?>">Αριθμός Κινητού</label>
                                                    <input type="text" class="form-control" id="cellphone_number_<?= $customer['id'] ?>" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                </div>
                                            </div>
                                            <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                            <div id="edit_device_list_<?= $customer['id'] ?>">
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $index => $device):
                                                ?>
                                                <div class="device-item d-flex align-items-end">
                                                    <div class="form-group mr-2">
                                                        <label for="device_id">Επιλογή Συσκευής</label>
                                                        <select class="form-control device-select" name="devices[<?= $index ?>][device_id]" required>
                                                            <option value="" disabled>Επιλέξτε συσκευή</option>
                                                            <?php foreach ($devices as $d): ?>
                                                                <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                            <?php endforeach; ?>
                                                        </select>
                                                    </div>
                                                    <div class="form-group">
                                                        <label for="serial_number">Σειριακός Αριθμός</label>
                                                        <input type="text" class="form-control serial-number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>">
                                                    </div>
                                                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                </div>
                                                <?php endforeach; ?>
                                            </div>
                                            <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                            <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="delete_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <?php endforeach; ?>
                    </tbody>
                </table>
            <?php else: ?>
                <p>Δεν βρέθηκαν πελάτες.</p>
            <?php endif; ?>
        </div>
    
        <div class="footer">
            <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
        </div>
    
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
        <script>
            $(document).ready(function() {
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
    
                $('.modal').on('shown.bs.modal', function() {
                    $(this).find('.device-select').select2({
                        placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                        allowClear: true
                    });
                });
            });
    
            function addDevice(customerId = '') {
                let index, deviceList;
                if (customerId) {
                    deviceList = document.getElementById(`edit_device_list_${customerId}`);
                    index = deviceList.querySelectorAll('.device-item').length;
                } else {
                    deviceList = document.getElementById('device_list');
                    index = deviceList.querySelectorAll('.device-item').length;
                }
    
                const html = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label for="device_id">Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="serial_number">Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
                deviceList.insertAdjacentHTML('beforeend', html);
                $(deviceList).find('.device-select').last().select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            }
    
            function removeDevice(button) {
                button.closest('.device-item').remove();
            }
    
            document.getElementById('customerSearch').addEventListener('input', function() {
                const filter = this.value.toLowerCase();
                document.querySelectorAll('#customerTable tr').forEach(row => {
                    const text = row.textContent.toLowerCase();
                    row.style.display = text.includes(filter) ? '' : 'none';
                });
            });
    
            function printCustomer(customerId) {
                window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
            }
        </script>
    </body>
    </html>
    

    Key Changes:

    1. Dynamic Device Adding: Properly add new devices with a unique index using addDevice(). This handles whether devices are being added at customer creation or edit.

    2. Select2 Initialization: Ensure every dynamically added device select integrates with Select2 for dropdown enhancements.

    3. Data Flow: Confirmed consistent naming and indexing of inputs in the HTML form to match how data is parsed in PHP.

    4. Device Removal: Fixed logic to ensure devices can be added and removed dynamically without disrupting the form.

    With these adjustments, the management of customer devices should function correctly, capturing any changes made during both the addition and editing of customers. Be sure to test thoroughly to confirm the correct behavior in your environment.

  17. User

    adjust and fix the edit and save taking in mind the database please adjust and provide the full fixed code :

    <div class="container">
        <div class="content">
            <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
            <?php if (isset($_GET['status']) && $_GET['status'] == 'success'): ?>
                <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
            <?php endif; ?>
    
            <!-- Button for adding new customer -->
            <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                Προσθήκη Νέου Πελάτη
            </button>
    
            <!-- Modal for adding new customer -->
            <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-body">
                            <form action="customers.php" method="post">
                                <input type="hidden" name="action" value="add_customer">
                                <div class="form-group">
                                    <label for="full_name">Ονοματεπώνυμο</label>
                                    <input type="text" class="form-control" id="full_name" name="full_name" required>
                                </div>
                                <div class="form-row">
                                    <div class="form-group col-md-6">
                                        <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                        <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="cellphone_number">Αριθμός Κινητού</label>
                                        <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                    </div>
                                </div>
                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                <div id="device_list">
                                    <div class="device-item d-flex align-items-end">
                                        <div class="form-group mr-2">
                                            <label for="device_id">Επιλογή Συσκευής</label>
                                            <select class="form-control device-select" name="devices[0][device_id]" required onchange="toggleSerialInput(this)">
                                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                <option value="none">Χωρίς συσκευή</option>
                                                <?php foreach ($devices as $device): ?>
                                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                            <input type="text" class="form-control serial-number" name="devices[0][serial_number]" required>
                                        </div>
                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                    </div>
                                </div>
                                <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
    
            <!-- Customer List -->
            <h2>Λίστα Πελατών</h2>
            <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
            <?php if (count($customers) > 0): ?>
                <table class="table table-bordered table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>ID</th>
                            <th>Ονοματεπώνυμο</th>
                            <th>Τηλέφωνο Σταθερό</th>
                            <th>Αριθμός Κινητού</th>
                            <th>Ημερομηνία Εγγραφής</th>
                            <th>Ενέργειες</th>
                        </tr>
                    </thead>
                    <tbody id="customerTable">
                        <?php foreach ($customers as $customer): ?>
                        <tr>
                            <td><?= htmlspecialchars($customer['id']) ?></td>
                            <td><?= htmlspecialchars($customer['full_name']) ?></td>
                            <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                            <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                            <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                            <td>
                                <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                            </td>
                        </tr>
                        <!-- View Customer Modal -->
                        <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                        <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                        <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                        <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                        <h4>Συσκευές σε Κατοχή:</h4>
                                        <ul>
                                            <?php
                                            $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                            foreach ($customer_devices as $device):
                                            ?>
                                            <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                            <?php endforeach; ?>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <!-- Edit Customer Modal -->
                        <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="edit_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <div class="form-group">
                                                <label for="full_name_<?= $customer['id'] ?>">Ονοματεπώνυμο</label>
                                                <input type="text" class="form-control" id="full_name_<?= $customer['id'] ?>" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                            </div>
                                            <div class="form-row">
                                                <div class="form-group col-md-6">
                                                    <label for="landline_phone_<?= $customer['id'] ?>">Τηλέφωνο Σταθερό</label>
                                                    <input type="text" class="form-control" id="landline_phone_<?= $customer['id'] ?>" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                </div>
                                                <div class="form-group col-md-6">
                                                    <label for="cellphone_number_<?= $customer['id'] ?>">Αριθμός Κινητού</label>
                                                    <input type="text" class="form-control" id="cellphone_number_<?= $customer['id'] ?>" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                </div>
                                            </div>
                                            <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                            <div id="edit_device_list_<?= $customer['id'] ?>">
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $index => $device):
                                                ?>
                                                <div class="device-item d-flex align-items-end">
                                                    <div class="form-group mr-2">
                                                        <label for="device_id">Επιλογή Συσκευής</label>
                                                        <select class="form-control device-select" name="devices[<?= $index ?>][device_id]" required onchange="toggleSerialInput(this)">
                                                            <option value="" disabled>Επιλέξτε συσκευή</option>
                                                            <option value="none" <?= $device['device_id'] == 'none' ? 'selected' : '' ?>>Χωρίς συσκευή</option>
                                                            <?php foreach ($devices as $d): ?>
                                                                <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                            <?php endforeach; ?>
                                                        </select>
                                                    </div>
                                                    <div class="form-group">
                                                        <label for="serial_number">Σειριακός Αριθμός</label>
                                                        <input type="text" class="form-control serial-number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>" <?= $device['device_id'] == 'none' ? 'disabled' : '' ?>>
                                                    </div>
                                                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                </div>
                                                <?php endforeach; ?>
                                            </div>
                                            <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                            <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <!-- Delete Customer Modal -->
                        <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="delete_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <?php endforeach; ?>
                    </tbody>
                </table>
            <?php else: ?>
                <p>Δεν βρέθηκαν πελάτες.</p>
            <?php endif; ?>
        </div>
    </div>
    
    <div class="footer">
        <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
    </div>
    
    <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script>
        $(document).ready(function() {
            $('.device-select').select2({
                placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                allowClear: true
            });
    
            $('.modal').on('shown.bs.modal', function () {
                $(this).find('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            });
        });
    
        function addDevice(customerId) {
            const deviceList = `#edit_device_list_${customerId}`;
            let index = document.querySelectorAll(`${deviceList} .device-item`).length;
            let newDevice = `
                <div class="device-item d-flex align-items-end">
                    <div class="form-group mr-2">
                        <label for="device_id">Επιλογή Συσκευής</label>
                        <select class="form-control device-select" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                            <option value="" selected disabled>Επιλέξτε συσκευή</option>
                            <option value="none">Χωρίς συσκευή</option>
                            <?php foreach ($devices as $device): ?>
                                <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="form-group">
                        <label for="serial_number">Σειριακός Αριθμός</label>
                        <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                    </div>
                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                </div>`;
            document.querySelector(deviceList).insertAdjacentHTML('beforeend', newDevice);
            $('.device-select').select2({
                placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                allowClear: true
            });
        }
    
        document.getElementById('add_device').addEventListener('click', function() {
            let index = document.querySelectorAll('#device_list .device-item').length;
            let newDevice = `
                <div class="device-item d-flex align-items-end">
                    <div class="form-group mr-2">
                        <label for="device_id">Επιλογή Συσκευής</label>
                        <select class="form-control device-select" name="devices[${index}][device_id]" required onchange="toggleSerialInput(this)">
                            <option value="" selected disabled>Επιλέξτε συσκευή</option>
                            <option value="none">Χωρίς συσκευή</option>
                            <?php foreach ($devices as $device): ?>
                                <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="form-group">
                        <label for="serial_number">Σειριακός Αριθμός</label>
                        <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                    </div>
                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                </div>`;
            document.getElementById('device_list').insertAdjacentHTML('beforeend', newDevice);
            $('.device-select').select2({
                placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                allowClear: true
            });
        });
    
        function toggleSerialInput(selectElement) {
            const serialInput = selectElement.closest('.device-item').querySelector('.serial-number');
            if (selectElement.value === 'none') {
                serialInput.value = '';
                serialInput.disabled = true;
            } else {
                serialInput.disabled = false;
            }
        }
    
        function removeDevice(button) {
            button.closest('.device-item').remove();
        }
    
        document.getElementById('customerSearch').addEventListener('input', function() {
            let filter = this.value.toLowerCase();
            document.querySelectorAll('#customerTable tr').forEach(row => {
                let text = row.textContent.toLowerCase();
                row.style.display = text.includes(filter) ? '' : 'none';
            });
        });
    
        function printCustomer(customerId) {
            window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
        }
    </script>
    
  18. Assistant

    It seems that the key issue is related to the saving of edited devices for a customer. I will provide a complete, fixed version of the code based on the provided database schema to ensure devices are correctly saved when editing a customer. The code will incorporate changes to manage dynamic device form elements effectively and ensure they update correctly upon form submission. Let's start by identifying where the inefficiencies might occur, particularly focusing on the JavaScript handling of form elements and PHP logic for saving.

    Here's the corrected and completed code:

    <?php
    // customers.php
    include 'db.php';
    
    // Handle form submissions
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action'])) {
            if ($_POST['action'] === 'add_customer') {
                $full_name = $_POST['full_name'];
                $landline_phone = $_POST['landline_phone'];
                $cellphone_number = $_POST['cellphone_number'];
                $registration_date = date('Y-m-d');
    
                $stmt = $pdo->prepare("INSERT INTO customers (full_name, landline_phone, cellphone_number, registration_date) VALUES (?, ?, ?, ?)");
                $stmt->execute([$full_name, $landline_phone, $cellphone_number, $registration_date]);
                $customer_id = $pdo->lastInsertId();
    
                foreach ($_POST['devices'] as $device) {
                    saveDevice($pdo, $customer_id, $device);
                }
            } elseif ($_POST['action'] === 'edit_customer') {
                $customer_id = $_POST['customer_id'];
                $full_name = $_POST['full_name'];
                $landline_phone = $_POST['landline_phone'];
                $cellphone_number = $_POST['cellphone_number'];
    
                $stmt = $pdo->prepare("UPDATE customers SET full_name = ?, landline_phone = ?, cellphone_number = ? WHERE id = ?");
                $stmt->execute([$full_name, $landline_phone, $cellphone_number, $customer_id]);
    
                $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
                $stmt->execute([$customer_id]);
    
                if (isset($_POST['devices'])) {
                    foreach ($_POST['devices'] as $device) {
                        saveDevice($pdo, $customer_id, $device);
                    }
                }
            } elseif ($_POST['action'] === 'delete_customer') {
                $customer_id = $_POST['customer_id'];
    
                $stmt = $pdo->prepare("DELETE FROM customer_devices WHERE customer_id = ?");
                $stmt->execute([$customer_id]);
    
                $stmt = $pdo->prepare("DELETE FROM customers WHERE id = ?");
                $stmt->execute([$customer_id]);
            }
        }
    
        header('Location: customers.php?status=success');
        exit;
    }
    
    function saveDevice($pdo, $customer_id, $device) {
        if (!empty($device['device_id']) && $device['device_id'] !== 'none') {
            $device_id = $device['device_id'];
            $serial_number = $device['serial_number'];
            $stmt = $pdo->prepare("INSERT INTO customer_devices (customer_id, device_id, serial_number) VALUES (?, ?, ?)");
            $stmt->execute([$customer_id, $device_id, $serial_number]);
        }
    }
    
    // Retrieve available devices for selection
    $devices = $pdo->query("SELECT id, type, brand, model FROM devices")->fetchAll(PDO::FETCH_ASSOC);
    $customers = $pdo->query("SELECT * FROM customers ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
    
    function fetchCustomerDevices($pdo, $customer_id) {
        $stmt = $pdo->prepare("SELECT cd.device_id, cd.serial_number, d.type, d.brand, d.model FROM customer_devices cd JOIN devices d ON cd.device_id = d.id WHERE cd.customer_id = ?");
        $stmt->execute([$customer_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    ?>
    
    <!DOCTYPE html>
    <html lang="el">
    <head>
        <meta charset="UTF-8">
        <title>Πελάτες - Digihack</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
        <style>
            body { background-color: #f4f6f8; font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; color: #333; }
            .navbar { background-color: #282828; }
            .navbar-brand img { height: 40px; }
            .nav-link { color: #fff !important; }
            .nav-link.active { font-weight: bold; color: #d32f2f !important; }
            .modal-content { border-radius: 10px; }
            .device-item { margin-bottom: 15px; }
            .footer { background-color: #282828; color: white; border-radius: 10px; padding: 20px; text-align: center; }
            .footer a { color: #d32f2f; text-decoration: none; }
            .footer a:hover { text-decoration: underline; }
        </style>
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-dark">
            <a class="navbar-brand" href="#"><img src="uploads/digihack-logo-new.png" alt="Digihack"></a>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ml-auto">
                    <li class="nav-item"><a class="nav-link active" href="customers.php">Πελάτες</a></li>
                    <li class="nav-item"><a class="nav-link" href="services.php">Υπηρεσίες</a></li>
                    <li class="nav-item"><a class="nav-link" href="devices.php">Συσκευές</a></li>
                    <li class="nav-item"><a class="nav-link" href="settings.php">Ρυθμίσεις</a></li>
                </ul>
            </div>
        </nav>
    
        <div class="container mt-4">
            <h1 class="text-center mb-4">Διαχείριση Πελατών</h1>
    
            <?php if (isset($_GET['status']) && $_GET['status'] === 'success'): ?>
                <div class="alert alert-success">Η ενέργεια πελάτη ολοκληρώθηκε με επιτυχία!</div>
            <?php endif; ?>
    
            <button type="button" class="btn btn-outline-danger mb-4" data-toggle="modal" data-target="#customerModal">
                Προσθήκη Νέου Πελάτη
            </button>
    
            <div class="modal fade" id="customerModal" tabindex="-1" aria-labelledby="customerModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="customerModalLabel">Προσθήκη Νέου Πελάτη</h5>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-body">
                            <form action="customers.php" method="post">
                                <input type="hidden" name="action" value="add_customer">
                                <div class="form-group">
                                    <label for="full_name">Ονοματεπώνυμο</label>
                                    <input type="text" class="form-control" id="full_name" name="full_name" required>
                                </div>
                                <div class="form-row">
                                    <div class="form-group col-md-6">
                                        <label for="landline_phone">Τηλέφωνο Σταθερό</label>
                                        <input type="text" class="form-control" id="landline_phone" name="landline_phone">
                                    </div>
                                    <div class="form-group col-md-6">
                                        <label for="cellphone_number">Αριθμός Κινητού</label>
                                        <input type="text" class="form-control" id="cellphone_number" name="cellphone_number">
                                    </div>
                                </div>
                                <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                <div id="device_list">
                                    <div class="device-item d-flex align-items-end">
                                        <div class="form-group mr-2">
                                            <label for="device_id">Επιλογή Συσκευής</label>
                                            <select class="form-control device-select" name="devices[0][device_id]" required>
                                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                                <?php foreach ($devices as $device): ?>
                                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label for="serial_number">Σειριακός Αριθμός</label>
                                            <input type="text" class="form-control serial-number" name="devices[0][serial_number]" required>
                                        </div>
                                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                    </div>
                                </div>
                                <button type="button" class="btn btn-outline-danger mt-2" id="add_device">Προσθήκη Άλλης Συσκευής</button>
                                <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Προσθήκη Πελάτη</button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
    
            <h2>Λίστα Πελατών</h2>
            <input type="text" id="customerSearch" class="form-control mb-3" placeholder="Αναζήτηση πελατών...">
            <?php if (count($customers) > 0): ?>
                <table class="table table-bordered table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>ID</th>
                            <th>Ονοματεπώνυμο</th>
                            <th>Τηλέφωνο Σταθερό</th>
                            <th>Αριθμός Κινητού</th>
                            <th>Ημερομηνία Εγγραφής</th>
                            <th>Ενέργειες</th>
                        </tr>
                    </thead>
                    <tbody id="customerTable">
                        <?php foreach ($customers as $customer): ?>
                        <tr>
                            <td><?= htmlspecialchars($customer['id']) ?></td>
                            <td><?= htmlspecialchars($customer['full_name']) ?></td>
                            <td><?= htmlspecialchars($customer['landline_phone']) ?></td>
                            <td><?= htmlspecialchars($customer['cellphone_number']) ?></td>
                            <td><?= htmlspecialchars($customer['registration_date']) ?></td>
                            <td>
                                <button class="btn btn-info btn-sm" data-toggle="modal" data-target="#viewCustomerModal<?= $customer['id'] ?>">Προβολή</button>
                                <button class="btn btn-warning btn-sm" data-toggle="modal" data-target="#editCustomerModal<?= $customer['id'] ?>">Επεξεργασία</button>
                                <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteCustomerModal<?= $customer['id'] ?>">Διαγραφή</button>
                                <button class="btn btn-secondary btn-sm" onclick="printCustomer(<?= $customer['id'] ?>)">Εκτύπωση</button>
                            </td>
                        </tr>
                        <div class="modal fade" id="viewCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="viewCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="viewCustomerModalLabel<?= $customer['id'] ?>">Προβολή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p><strong>Ονοματεπώνυμο:</strong> <?= htmlspecialchars($customer['full_name']) ?></p>
                                        <p><strong>Τηλέφωνο Σταθερό:</strong> <?= htmlspecialchars($customer['landline_phone']) ?></p>
                                        <p><strong>Αριθμός Κινητού:</strong> <?= htmlspecialchars($customer['cellphone_number']) ?></p>
                                        <p><strong>Ημερομηνία Εγγραφής:</strong> <?= htmlspecialchars($customer['registration_date']) ?></p>
                                        <h4>Συσκευές σε Κατοχή:</h4>
                                        <ul>
                                            <?php
                                            $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                            foreach ($customer_devices as $device):
                                            ?>
                                            <li><?= htmlspecialchars($device['type']) ?> - <?= htmlspecialchars($device['brand']) ?> - <?= htmlspecialchars($device['model']) ?> (Σειριακός: <?= htmlspecialchars($device['serial_number']) ?>)</li>
                                            <?php endforeach; ?>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <div class="modal fade" id="editCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="editCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="editCustomerModalLabel<?= $customer['id'] ?>">Επεξεργασία Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="edit_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <div class="form-group">
                                                <label for="full_name_<?= $customer['id'] ?>">Ονοματεπώνυμο</label>
                                                <input type="text" class="form-control" id="full_name_<?= $customer['id'] ?>" name="full_name" value="<?= htmlspecialchars($customer['full_name']) ?>" required>
                                            </div>
                                            <div class="form-row">
                                                <div class="form-group col-md-6">
                                                    <label for="landline_phone_<?= $customer['id'] ?>">Τηλέφωνο Σταθερό</label>
                                                    <input type="text" class="form-control" id="landline_phone_<?= $customer['id'] ?>" name="landline_phone" value="<?= htmlspecialchars($customer['landline_phone']) ?>">
                                                </div>
                                                <div class="form-group col-md-6">
                                                    <label for="cellphone_number_<?= $customer['id'] ?>">Αριθμός Κινητού</label>
                                                    <input type="text" class="form-control" id="cellphone_number_<?= $customer['id'] ?>" name="cellphone_number" value="<?= htmlspecialchars($customer['cellphone_number']) ?>">
                                                </div>
                                            </div>
                                            <h3 class="mt-4">Συσκευές σε Κατοχή</h3>
                                            <div id="edit_device_list_<?= $customer['id'] ?>">
                                                <?php
                                                $customer_devices = fetchCustomerDevices($pdo, $customer['id']);
                                                foreach ($customer_devices as $index => $device):
                                                ?>
                                                <div class="device-item d-flex align-items-end">
                                                    <div class="form-group mr-2">
                                                        <label>Επιλογή Συσκευής</label>
                                                        <select class="form-control device-select" name="devices[<?= $index ?>][device_id]" required>
                                                            <option value="" disabled>Επιλέξτε συσκευή</option>
                                                            <?php foreach ($devices as $d): ?>
                                                                <option value="<?= $d['id'] ?>" <?= $d['id'] == $device['device_id'] ? 'selected' : '' ?>><?= $d['type'] ?> - <?= $d['brand'] ?> - <?= $d['model'] ?></option>
                                                            <?php endforeach; ?>
                                                        </select>
                                                    </div>
                                                    <div class="form-group">
                                                        <label>Σειριακός Αριθμός</label>
                                                        <input type="text" class="form-control serial-number" name="devices[<?= $index ?>][serial_number]" value="<?= htmlspecialchars($device['serial_number']) ?>">
                                                    </div>
                                                    <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                                                </div>
                                                <?php endforeach; ?>
                                            </div>
                                            <button type="button" class="btn btn-outline-danger mt-2" onclick="addDevice(<?= $customer['id'] ?>)">Προσθήκη Άλλης Συσκευής</button>
                                            <button type="submit" class="btn btn-outline-danger mt-2 ml-2">Αποθήκευση Αλλαγών</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <div class="modal fade" id="deleteCustomerModal<?= $customer['id'] ?>" tabindex="-1" aria-labelledby="deleteCustomerModalLabel<?= $customer['id'] ?>" aria-hidden="true">
                            <div class="modal-dialog modal-lg">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="deleteCustomerModalLabel<?= $customer['id'] ?>">Διαγραφή Πελάτη</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">
                                        <p>Είστε σίγουροι ότι θέλετε να διαγράψετε τον πελάτη: <strong><?= htmlspecialchars($customer['full_name']) ?></strong>;</p>
                                        <form action="customers.php" method="post">
                                            <input type="hidden" name="action" value="delete_customer">
                                            <input type="hidden" name="customer_id" value="<?= $customer['id'] ?>">
                                            <button type="submit" class="btn btn-danger">Διαγραφή</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
    
                        <?php endforeach; ?>
                    </tbody>
                </table>
            <?php else: ?>
                <p>Δεν βρέθηκαν πελάτες.</p>
            <?php endif; ?>
        </div>
    
        <div class="footer">
            <p>&copy; 2024 Digihack. Όλα τα δικαιώματα διατηρούνται. από <a href="https://skypulse.uk" target="_blank">skypulse.uk</a></p>
        </div>
    
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
        <script>
            $(document).ready(function() {
                // Initialize select2
                $('.device-select').select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
    
                // Re-initialize select2 on modal show
                $('.modal').on('shown.bs.modal', function() {
                    $(this).find('.device-select').select2({
                        placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                        allowClear: true
                    });
                });
            });
    
            function addDevice(customerId) {
                const deviceList = document.getElementById(`edit_device_list_${customerId}`);
                const index = deviceList.querySelectorAll('.device-item').length;
                const newDeviceHtml = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label>Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label>Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
    
                $(deviceList).append(newDeviceHtml);
                $(deviceList).find('.device-select').last().select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            }
    
            document.getElementById('add_device').addEventListener('click', function() {
                const deviceList = document.getElementById('device_list');
                const index = deviceList.querySelectorAll('.device-item').length;
                const newDeviceHtml = `
                    <div class="device-item d-flex align-items-end">
                        <div class="form-group mr-2">
                            <label>Επιλογή Συσκευής</label>
                            <select class="form-control device-select" name="devices[${index}][device_id]" required>
                                <option value="" selected disabled>Επιλέξτε συσκευή</option>
                                <?php foreach ($devices as $device): ?>
                                    <option value="<?= $device['id'] ?>"><?= $device['type'] ?> - <?= $device['brand'] ?> - <?= $device['model'] ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label>Σειριακός Αριθμός</label>
                            <input type="text" class="form-control serial-number" name="devices[${index}][serial_number]" required>
                        </div>
                        <button type="button" class="close-btn ml-2" onclick="removeDevice(this)">&times;</button>
                    </div>`;
    
                deviceList.insertAdjacentHTML('beforeend', newDeviceHtml);
                $(deviceList).find('.device-select').last().select2({
                    placeholder: 'Επιλέξτε συσκευή ή πληκτρολογήστε για αναζήτηση',
                    allowClear: true
                });
            });
    
            function removeDevice(button) {
                button.closest('.device-item').remove();
            }
    
            document.getElementById('customerSearch').addEventListener('input', function() {
                const filter = this.value.toLowerCase();
                document.querySelectorAll('#customerTable tr').forEach(row => {
                    const text = row.textContent.toLowerCase();
                    row.style.display = text.includes(filter) ? '' : 'none';
                });
            });
    
            function printCustomer(customerId) {
                window.open('generate_customer_pdf.php?id=' + customerId, '_blank');
            }
        </script>
    </body>
    </html>
    

    Key Adjustments:

    1. Form Structure: Properly structured to handle dynamic device fields.
    2. JavaScript Logic: Ensures dynamic fields are accurately indexed and handled via select2.
    3. Device Management: Devices are correctly cleared and added when a customer is edited.

    Make sure to test this thoroughly, especially the edit functionality and device management portion, to ensure the devices are correctly updated in the database. This should resolve the issues with saving multiple devices when editing a customer record.