1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / cando / application / views / admin / events /
Filename : exhibitors_report.php
back
<div class="main-panel">
    <div class="content-wrapper">
        <div class="page-header">
            <h3 class="page-title">Exhibitors Report Lists</h3>
            <!-- <div class="header-right d-flex flex-wrap">
						<a href="<?= base_url() . 'add' ?>" class="btn btn-icon-text"><i class="mdi mdi-plus-circle"></i> Add </a>
					</div> -->
        </div>
        <div class="row">
            <div class="col-lg-12 grid-margin stretch-card">
                <div class="card">
                    <div class="card-body">
                        <div class="row mb-5">
                            <div class="col-md-4">
                                <label>Evenet Name</label>
                                <input type="text" class="form-control" id="searchInput" placeholder="Enter Event Name">
                                <input type="hidden" id="selectedCompany" name="selectedCompany">
                                <ul id="resultsContainer">
                                    <!-- <?php foreach ($exhibitors as $row) : ?>
                                        <li class="result-item"><?php echo $row->company_name; ?></li>
                                    <?php endforeach; ?> -->
                                </ul>
                            </div>
                        </div>
                        <div class="row" style="display: flex;justify-content: end;margin-bottom: 10px;color:white;">
                            <div class="form-group">
                                <form action="<?= base_url() . 'export_event' ?>" method="POST">
                                    <button class="btn" name="downloadExcel" style="color: white;float:right;background-color:#12A4A1">Download Excel</button>
                                </form>
                            </div>
                        </div>
                        <div class="table-responsive">
                            <table class="table table-bordered" id="exhibitorsTable">
                                <thead>
                                    <tr>
                                        <th>S.NO</th>
                                        <th>Company Name</th>
                                        <th>Employee Name</th>
                                        <th>Email</th>
                                        <th>Phone Number</th>
                                        <th>Floor Name</th>
                                        <th>Floor dimension</th>
                                    </tr>
                                </thead>
                                <tbody id="exhibitorsTableBody">
                                    <?php $i = 1;
                                    foreach ($floor_plan_mappings as $row) : ?>
                                        <tr>
                                            <td><?php echo $i++; ?></td>
                                            <td><?php echo get_exhibitor($row->exhibitors_id); ?></td>
                                            <td><?php echo $row->employee_name; ?></td>
                                            <td><?php echo $row->email; ?></td>
                                            <td><?php echo $row->phone_number; ?></td>
                                            <td><?php echo $row->floor_name; ?></td>
                                            <td><?php echo $row->floor_size; ?></td>
                                        </tr>
                                    <?php endforeach; ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- content-wrapper ends -->
    <style>
        #resultsContainer {
            display: none;
            position: absolute;
            list-style-type: none;
            padding: 0;
            margin: 0;
            border: 1px solid #ddd;
            background: #fff;
            width: 200px;
        }

        .result-item {
            padding: 8px;
            cursor: pointer;
        }

        .result-item:hover {
            background-color: #f0f0f0;
        }
    </style>
    <link rel="stylesheet" href="//cdn.datatables.net/2.1.4/css/dataTables.dataTables.min.css">
	<script src="//cdn.datatables.net/2.1.4/js/dataTables.min.js"></script>
	<script>
		let table = new DataTable('#exhibitorsTable');
	</script>
    <script>
        document.addEventListener('DOMContentLoaded', () => {
            const searchInput = document.getElementById('searchInput');
            const resultsContainer = document.getElementById('resultsContainer');
            const event = <?php echo json_encode($event); ?>;

            searchInput.addEventListener('input', () => {
                const searchTerm = searchInput.value.toLowerCase();
                resultsContainer.innerHTML = ''; // Clear previous results

                if (searchTerm) {
                    event.forEach(exhibitor => {
                        const companyName = exhibitor.event_name.toLowerCase();
                        if (companyName.includes(searchTerm)) {
                            const li = document.createElement('li');
                            li.className = 'result-item';
                            li.textContent = exhibitor.event_name;
                            li.addEventListener('click', () => {
                                searchInput.value = exhibitor.event_name;
                                document.getElementById('selectedCompany').value = exhibitor.event_name;
                                resultsContainer.style.display = 'none';
                                filterExhibitors(exhibitor.event_name);
                            });
                            resultsContainer.appendChild(li);
                        }
                    });
                    resultsContainer.style.display = 'block';
                } else {
                    resultsContainer.style.display = 'none';
                }
            });

            function filterExhibitors(companyName) {
                const xhr = new XMLHttpRequest();
                xhr.open('POST', '<?= base_url("Events/filter_exhibitors") ?>', true);
                xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
                xhr.onreadystatechange = function() {
                    if (xhr.readyState === 4 && xhr.status === 200) {
                        const response = JSON.parse(xhr.responseText);
                        updateExhibitorsTable(response);
                    }
                };
                xhr.send('company_name=' + encodeURIComponent(companyName));
            }

            function updateExhibitorsTable(exhibitors) {
                const tableBody = document.getElementById('exhibitorsTableBody');
                tableBody.innerHTML = ''; // Clear existing table rows
                let i = 1;
                exhibitors.forEach(exhibitor => {
                    const row = `<tr>
                <td>${i++}</td>
                <td>${exhibitor.company_name}</td>
                <td>${exhibitor.employee_name}</td>
                <td>${exhibitor.email}</td>
                <td>${exhibitor.phone_number}</td>
                <td>${exhibitor.floor_name}</td>
                <td>${exhibitor.floor_size}</td>
            </tr>`;
                    tableBody.innerHTML += row;
                });
            }
        });
    </script>