Changes Implemented on the Customer Map Page

[carlos0424]

Summary of Changes:

• Removed pagination from the customer map.
• Added the ability to search for customers by username.
• Enabled filtering of customers by city.

customers-map.tpl

{include file="sections/header.tpl"}

    <label for="city" style="margin-left: 10px;">Ciudad:</label>
    <select name="city" class="form-control" style="margin-left: 10px; width: auto;">
        <option value="">Seleccione una ciudad</option>
        {foreach $cities as $city}
            <option value="{$city.city}" {if $selected_city == $city.city}selected{/if}>{$city.city}</option>
        {/foreach}
    </select>

    <div class="input-group-btn">
        <button class="btn btn-success" type="submit">{Lang::T('Search')}</button>
    </div>
</div>

{literal}
<script>
function getLocation() {
if (window.location.protocol == "https:" && navigator.geolocation) {
navigator.geolocation.getCurrentPosition(showPosition);
} else {
setupMap(51.505, -0.09);
}
}

    function showPosition(position) {
        setupMap(position.coords.latitude, position.coords.longitude);
    }

    function setupMap(lat, lon) {
        var map = L.map('map').setView([lat, lon], 13);
        var group = L.featureGroup().addTo(map);

        var customers = {/literal}{$customers|json_encode}{literal};

        L.tileLayer('https://{s}.basemaps.cartocdn.com/rastertiles/light_all/{z}/{x}/{y}.png', {
            attribution:
                '&copy; <a href="https://www.openstreetmap.org/copyright">OpenStreetMap</a> contributors &copy; <a href="https://carto.com/attributions">CARTO</a>',
            subdomains: 'abcd',
            maxZoom: 20
        }).addTo(map);

        customers.forEach(function(customer) {
            var name = customer.id;
            var name = customer.name;
            var info = customer.info;
            var direction = customer.direction;
            var coordinates = customer.coordinates;
            var address = customer.address;

            // Create a popup for the marker
            var popupContent = "<strong>Name</strong>: " + name + "<br>" +
                "<strong>Info</strong>: " + info + "<br>" +
                "<strong>Address</strong>: " + address + "<br>" +
                "<a href='{/literal}{$_url}{literal}customers/view/"+ customer.id +"'>More Info</a> &bull; " +
                "<a href='https://www.google.com/maps/dir//" + direction + "' target='maps'>Get Direction</a><br>";

            // Add marker to map
            var marker = L.marker(JSON.parse(coordinates)).addTo(group);
            marker.bindPopup(popupContent);

        });

        map.fitBounds(group.getBounds());
    }
    window.onload = function() {
        getLocation();
    }
</script>

{/literal}
{include file="sections/footer.tpl"}

map.php

assign('_system_menu', 'map'); $action = $routes['1']; $ui->assign('_admin', $admin); if (empty($action)) { $action = 'customer'; } switch ($action) { case 'customer': // Obtener la lista de ciudades distintas $cities = ORM::for_table('tbl_customers') ->select('city') ->distinct() ->where_not_equal('city', '') ->where_not_null('city') ->find_array(); $ui->assign('cities', $cities); // Manejo de búsqueda y filtrado $search = _req('search'); $selected_city = _req('city'); $query = ORM::for_table('tbl_customers')->where_not_equal('coordinates', ''); // Filtrar por ciudad si se selecciona if (!empty($selected_city)) { $query->where('city', $selected_city); } // Filtrar por búsqueda si se proporciona if (!empty($search)) { $query->whereRaw("fullname LIKE '%$search%' OR username LIKE '%$search%' OR email LIKE '%$search%' OR phonenumber LIKE '%$search%'"); } $c = $query->find_many(); $customerData = []; foreach ($c as $customer) { if (!empty($customer->coordinates)) { $customerData[] = [ 'id' => $customer->id, 'name' => $customer->fullname, 'balance' => $customer->balance, 'address' => $customer->address, 'direction' => $customer->coordinates, 'info' => Lang::T("Username") . ": " . $customer->username . " - " . Lang::T("Full Name") . ": " . $customer->fullname . " - " . Lang::T("Email") . ": " . $customer->email . " - " . Lang::T("Phone") . ": " . $customer->phonenumber . " - " . Lang::T("Service Type") . ": " . $customer->service_type, 'coordinates' => '[' . $customer->coordinates . ']', ]; } } $ui->assign('search', $search); $ui->assign('selected_city', $selected_city); $ui->assign('customers', $customerData); $ui->assign('xheader', ''); $ui->assign('_title', Lang::T('Customer Geo Location Information')); $ui->assign('xfooter', '<script src="https://unpkg.com/leaflet@1.9.3/dist/leaflet.js"></script>'); $ui->display('customers-map.tpl'); break; default: r2(U . 'map/customer', 'e', 'action not defined'); break; }