FiveTech Software tech support forums

www.FiveTechSoft.com

Skip to content

Filter on Xbrowse

Post a reply

Re: Filter on Xbrowse

Postby karinha » Sun May 05, 2024 11:29 am

https://imgur.com/A4uV7ac

Image

Un agradecimiento especial a Silvio Falconi por la idea original.

Special thanks to Silvio Falconi for the original idea.

Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
User avatar
karinha
 
Posts: 7835
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil
Top

Re: Filter on Xbrowse

Postby Silvio.Falconi » Sun May 05, 2024 3:08 pm

karinha wrote:https://imgur.com/A4uV7ac

Image

Un agradecimiento especial a Silvio Falconi por la idea original.

Special thanks to Silvio Falconi for the original idea.

Regards, saludos.

I Wish the filtrr on the same dialog
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 7075
Joined: Thu Oct 18, 2012 7:17 pm
Top

Re: Filter on Xbrowse

Postby Otto » Sun May 05, 2024 3:41 pm

Hello Marc, hello João,
We are now replacing the dummy JSON.
The function sendFilterData() makes a request to the server, and it responds with a JSON.
At the moment, we are not yet evaluating any indexes and filters, but simply querying the database.

Image

Image
Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm
Top

Re: Filter on Xbrowse

Postby Marc Venken » Sun May 05, 2024 5:12 pm

Otto wrote:Marc,

sure, I can post the source code.

Do you have a Mod Harbour server installed?

Best regards,
Otto


Otto,

I have it installed and it seems to work with the old samples (periode : 07/2020)

The code from the sample, can you post it so that I can change it as sample ?
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1446
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium
Top

Re: Filter on Xbrowse

Postby Otto » Sun May 05, 2024 5:24 pm

Marc, here is the link to this sample:


https://mybergland.com/fwforum/challenge.zip

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm
Top

Re: Filter on Xbrowse

Postby Otto » Sun May 05, 2024 10:00 pm

Silvio sent me an email with a very interesting approach to setting filter conditions.
I think this is really a good way to set extensive filters.
I coded this query for webview and mod harbour use.
Best regards,
Otto

Image


Code: Select all  Expand view  RUN


<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <title>Dynamic Filter Archive with Checkboxes</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <!-- Include Font Awesome -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
    <style>
        .checkbox-row {
            display: flex;
            flex-wrap: nowrap;
            gap: 10px;
        }
       
        .form-check {
            width: auto;
            margin-right: 5px;
        }
       
        .form-check .form-check-input {
            margin-right: 5px;
        }
       
       
        /* Add this to the <style> section */
            .container {
                border: 2px solid #000; /* Example: 2px solid black border */
                padding: 15px; /* Optional: Add padding for better visual separation */
                border-radius: 10px; /* Optional: Add rounded corners */
            }
           
           
            /* Set flex-grow to 0 so elements do not grow beyond their intrinsic size */
            #filtersContainer > div {
                flex: 0 0 auto;
                max-width: 300px; /* Optional: Adjust the max-width if needed */
            }
           
            /* Make the checkboxes visible and flexible */
            .checkbox-row {
                display: flex;
                flex-wrap: nowrap;
                gap: 10px;
            }
           
            .form-check {
                width: auto;
                margin-right: 5px;
            }
           
            .form-check .form-check-input {
                margin-right: 5px;
            }
           
           
           
           
           
        </style>
    </head>
   
    <body>
        <div class="container">
            <h1 class="mt-4">Archive Filters</h1>
            <div id="filtersContainer" class="d-flex flex-wrap gap-3">
                <div id="itemTypeSection" class="col-md-4 d-none">
                    <label for="itemTypeFilter" class="form-label">Item Type</label>
                    <select id="itemTypeFilter" class="form-select">
                        <option>All</option>
                        <option>Goods</option>
                        <option>Service</option>
                        <option>Bill of Materials</option>
                    </select>
                </div>
               
                <div id="productCategorySection" class="col-md-4 d-none">
                    <label for="productCategoryFilter" class="form-label">Product Category</label>
                    <select id="productCategoryFilter" class="form-select">
                        <option>Master Category</option>
                        <option>Sub Category</option>
                    </select>
                </div>
               
                <div id="departmentSection" class="col-md-4 d-none">
                    <label for="departmentFilter" class="form-label">Department</label>
                    <select id="departmentFilter" class="form-select">
                        <option>HR</option>
                        <option>Finance</option>
                        <option>IT</option>
                    </select>
                </div>
               
                <div id="brandSection" class="col-md-4 d-none">
                    <label for="brandFilter" class="form-label">Brand</label>
                    <select id="brandFilter" class="form-select">
                        <option>Brand A</option>
                        <option>Brand B</option>
                    </select>
                </div>
               
                <div id="supplierSection" class="col-md-4 d-none">
                    <label for="supplierFilter" class="form-label">Supplier</label>
                    <select id="supplierFilter" class="form-select">
                        <option>Supplier 1</option>
                        <option>Supplier 2</option>
                    </select>
                </div>
               
                <div id="warehouseSection" class="col-md-4 d-none">
                    <label for="warehouseFilter" class="form-label">Warehouse</label>
                    <select id="warehouseFilter" class="form-select">
                        <option>Warehouse A</option>
                        <option>Warehouse B</option>
                    </select>
                </div>
               
                <div id="locationSection" class="col-md-4 d-none">
                    <label for="locationFilter" class="form-label">Location</label>
                    <select id="locationFilter" class="form-select">
                        <option>Location A</option>
                        <option>Location B</option>
                    </select>
                </div>
               
                <div id="existenceSection" class="col-md-4 d-none">
                    <label for="existenceFilter" class="form-label">Existence</label>
                    <select id="existenceFilter" class="form-select">
                        <option>Greater than Zero</option>
                    </select>
                </div>
               
                <div id="creationDateSection" class="col-md-4 d-none">
                    <label for="creationDateFilter" class="form-label">Creation Date</label>
                    <input type="date" id="creationDateFilter" class="form-control">
                </div>
               
                <div id="movementDateSection" class="col-md-4 d-none">
                    <label for="movementDateFilter" class="form-label">Movement Date</label>
                    <input type="date" id="movementDateFilter" class="form-control">
                    <div class="form-check">
                        <input class="form-check-input" type="radio" name="movementRadio" id="movedRadio">
                        <label class="form-check-label" for="movedRadio">Moved</label>
                    </div>
                    <div class="form-check">
                        <input class="form-check-input" type="radio" name="movementRadio" id="notMovedRadio">
                        <label class="form-check-label" for="notMovedRadio">Not Moved</label>
                    </div>
                </div>
               
               
            </div>
           
            <div class="checkbox-row mb-4">
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleItemType">
                    <label class="form-check-label" for="toggleItemType">Item Type</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleProductCategory">
                    <label class="form-check-label" for="toggleProductCategory">Product Category</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleDepartment">
                    <label class="form-check-label" for="toggleDepartment">Department</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleBrand">
                    <label class="form-check-label" for="toggleBrand">Brand</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleSupplier">
                    <label class="form-check-label" for="toggleSupplier">Supplier</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleWarehouse">
                    <label class="form-check-label" for="toggleWarehouse">Warehouse</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleLocation">
                    <label class="form-check-label" for="toggleLocation">Location</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleExistence">
                    <label class="form-check-label" for="toggleExistence">Existence</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleCreationDate">
                    <label class="form-check-label" for="toggleCreationDate">Creation Date</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleDateMovement">
                    <label class="form-check-label" for="toggleDateMovement">Date of Movement</label>
                </div>
            </div>
           
           
            <div class="col-12 mt-3">
                <button type="button" id="applyFilters" class="btn btn-primary">Apply Filters</button>
                <button type="button" id="clearFilters" class="btn btn-secondary">Clear All</button>
            </div>
           
            <div id="result" class="mt-4">
                <!-- The filtered results will be displayed here -->
            </div>
        </div>
       
        <script>
            $(document).ready(function () {
                $('#toggleItemType').change(function () {
                    $('#itemTypeSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleProductCategory').change(function () {
                    $('#productCategorySection').toggleClass('d-none', !this.checked);
                });
                $('#toggleDepartment').change(function () {
                    $('#departmentSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleBrand').change(function () {
                    $('#brandSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleSupplier').change(function () {
                    $('#supplierSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleWarehouse').change(function () {
                    $('#warehouseSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleLocation').change(function () {
                    $('#locationSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleExistence').change(function () {
                    $('#existenceSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleCreationDate').change(function () {
                    $('#creationDateSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleDateMovement').change(function () {
                    $('#movementDateSection').toggleClass('d-none', !this.checked);
                });
               
                $('#applyFilters').click(function () {
                    let filters = {
                        itemType: $('#itemTypeSection').is(':visible') ? $('#itemTypeFilter').val() : null,
                        productCategory: $('#productCategorySection').is(':visible') ? $('#productCategoryFilter').val() : null,
                        department: $('#departmentSection').is(':visible') ? $('#departmentFilter').val() : null,
                        brand: $('#brandSection').is(':visible') ? $('#brandFilter').val() : null,
                        supplier: $('#supplierSection').is(':visible') ? $('#supplierFilter').val() : null,
                        warehouse: $('#warehouseSection').is(':visible') ? $('#warehouseFilter').val() : null,
                        location: $('#locationSection').is(':visible') ? $('#locationFilter').val() : null,
                        existence: $('#existenceSection').is(':visible') ? $('#existenceFilter').val() : null,
                        creationDate: $('#creationDateSection').is(':visible') ? $('#creationDateFilter').val() : null,
                        movementDate: $('#movementDateSection').is(':visible') ? $('#movementDateFilter').val() : null,
                        movementStatus: $('#movementDateSection').is(':visible') ? $('input[name="movementRadio"]:checked').next('label').text() : null
                    };
                    // Showing the values in an alert
                    alert(JSON.stringify(filters, null, 2) );
                    //     $('#result').html('<pre>' + JSON.stringify(filters, null, 2) + '</pre>');
                   
                    // Logic to filter and display the data based on the filters
                    // This is where you would integrate with your data source to fetch and display the filtered data
                });
            });
           
           
            // Function to clear all filters
            function clearAllFilters() {
                // Explicitly handle the controlling checkboxes
                $('#toggleItemType, #toggleProductCategory, #toggleDepartment, #toggleBrand, #toggleSupplier, #toggleWarehouse, #toggleLocation, #toggleExistence, #toggleCreationDate, #toggleDateMovement')
                .prop('checked', false)
                .trigger('change'); // Trigger change to hide sections
               
                // Reset the values of all filter input fields and selects
                $('#filtersContainer select').each(function () {
                    $(this).prop('selectedIndex', 0); // Reset to first option
                });
               
                $('#filtersContainer input[type="radio"], #filtersContainer input[type="checkbox"]').not('[id^="toggle"]').each(function () {
                    $(this).prop('checked', false); // Clear checkboxes/radios that are not section toggles
                });
               
                $('#filtersContainer input[type="text"], #filtersContainer input[type="date"]').each(function () {
                    $(this).val(''); // Clear text and date inputs
                });
               
                // Hide all selection sections directly
                $('#filtersContainer > div').addClass('d-none');
            }
           
            // Event listener for the Clear All button
            $('#clearFilters').click(function () {
                clearAllFilters(); // Call the function to clear all filters
                $('#applyFilters').click(); // Trigger the Apply Filters button click
            });
           
           
           
        </script>
       
    </body>
   
    </html>
   

 
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm
Top

Re: Filter on Xbrowse

Postby Silvio.Falconi » Mon May 06, 2024 9:02 am

Otto wrote:Silvio sent me an email with a very interesting approach to setting filter conditions.
I think this is really a good way to set extensive filters.
I coded this query for webview and mod harbour use.
Best regards,
Otto

Image


Code: Select all  Expand view  RUN


<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <title>Dynamic Filter Archive with Checkboxes</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <!-- Include Font Awesome -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
    <style>
        .checkbox-row {
            display: flex;
            flex-wrap: nowrap;
            gap: 10px;
        }
       
        .form-check {
            width: auto;
            margin-right: 5px;
        }
       
        .form-check .form-check-input {
            margin-right: 5px;
        }
       
       
        /* Add this to the <style> section */
            .container {
                border: 2px solid #000; /* Example: 2px solid black border */
                padding: 15px; /* Optional: Add padding for better visual separation */
                border-radius: 10px; /* Optional: Add rounded corners */
            }
           
           
            /* Set flex-grow to 0 so elements do not grow beyond their intrinsic size */
            #filtersContainer > div {
                flex: 0 0 auto;
                max-width: 300px; /* Optional: Adjust the max-width if needed */
            }
           
            /* Make the checkboxes visible and flexible */
            .checkbox-row {
                display: flex;
                flex-wrap: nowrap;
                gap: 10px;
            }
           
            .form-check {
                width: auto;
                margin-right: 5px;
            }
           
            .form-check .form-check-input {
                margin-right: 5px;
            }
           
           
           
           
           
        </style>
    </head>
   
    <body>
        <div class="container">
            <h1 class="mt-4">Archive Filters</h1>
            <div id="filtersContainer" class="d-flex flex-wrap gap-3">
                <div id="itemTypeSection" class="col-md-4 d-none">
                    <label for="itemTypeFilter" class="form-label">Item Type</label>
                    <select id="itemTypeFilter" class="form-select">
                        <option>All</option>
                        <option>Goods</option>
                        <option>Service</option>
                        <option>Bill of Materials</option>
                    </select>
                </div>
               
                <div id="productCategorySection" class="col-md-4 d-none">
                    <label for="productCategoryFilter" class="form-label">Product Category</label>
                    <select id="productCategoryFilter" class="form-select">
                        <option>Master Category</option>
                        <option>Sub Category</option>
                    </select>
                </div>
               
                <div id="departmentSection" class="col-md-4 d-none">
                    <label for="departmentFilter" class="form-label">Department</label>
                    <select id="departmentFilter" class="form-select">
                        <option>HR</option>
                        <option>Finance</option>
                        <option>IT</option>
                    </select>
                </div>
               
                <div id="brandSection" class="col-md-4 d-none">
                    <label for="brandFilter" class="form-label">Brand</label>
                    <select id="brandFilter" class="form-select">
                        <option>Brand A</option>
                        <option>Brand B</option>
                    </select>
                </div>
               
                <div id="supplierSection" class="col-md-4 d-none">
                    <label for="supplierFilter" class="form-label">Supplier</label>
                    <select id="supplierFilter" class="form-select">
                        <option>Supplier 1</option>
                        <option>Supplier 2</option>
                    </select>
                </div>
               
                <div id="warehouseSection" class="col-md-4 d-none">
                    <label for="warehouseFilter" class="form-label">Warehouse</label>
                    <select id="warehouseFilter" class="form-select">
                        <option>Warehouse A</option>
                        <option>Warehouse B</option>
                    </select>
                </div>
               
                <div id="locationSection" class="col-md-4 d-none">
                    <label for="locationFilter" class="form-label">Location</label>
                    <select id="locationFilter" class="form-select">
                        <option>Location A</option>
                        <option>Location B</option>
                    </select>
                </div>
               
                <div id="existenceSection" class="col-md-4 d-none">
                    <label for="existenceFilter" class="form-label">Existence</label>
                    <select id="existenceFilter" class="form-select">
                        <option>Greater than Zero</option>
                    </select>
                </div>
               
                <div id="creationDateSection" class="col-md-4 d-none">
                    <label for="creationDateFilter" class="form-label">Creation Date</label>
                    <input type="date" id="creationDateFilter" class="form-control">
                </div>
               
                <div id="movementDateSection" class="col-md-4 d-none">
                    <label for="movementDateFilter" class="form-label">Movement Date</label>
                    <input type="date" id="movementDateFilter" class="form-control">
                    <div class="form-check">
                        <input class="form-check-input" type="radio" name="movementRadio" id="movedRadio">
                        <label class="form-check-label" for="movedRadio">Moved</label>
                    </div>
                    <div class="form-check">
                        <input class="form-check-input" type="radio" name="movementRadio" id="notMovedRadio">
                        <label class="form-check-label" for="notMovedRadio">Not Moved</label>
                    </div>
                </div>
               
               
            </div>
           
            <div class="checkbox-row mb-4">
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleItemType">
                    <label class="form-check-label" for="toggleItemType">Item Type</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleProductCategory">
                    <label class="form-check-label" for="toggleProductCategory">Product Category</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleDepartment">
                    <label class="form-check-label" for="toggleDepartment">Department</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleBrand">
                    <label class="form-check-label" for="toggleBrand">Brand</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleSupplier">
                    <label class="form-check-label" for="toggleSupplier">Supplier</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleWarehouse">
                    <label class="form-check-label" for="toggleWarehouse">Warehouse</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleLocation">
                    <label class="form-check-label" for="toggleLocation">Location</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleExistence">
                    <label class="form-check-label" for="toggleExistence">Existence</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleCreationDate">
                    <label class="form-check-label" for="toggleCreationDate">Creation Date</label>
                </div>
                <div class="form-check">
                    <input class="form-check-input" type="checkbox" id="toggleDateMovement">
                    <label class="form-check-label" for="toggleDateMovement">Date of Movement</label>
                </div>
            </div>
           
           
            <div class="col-12 mt-3">
                <button type="button" id="applyFilters" class="btn btn-primary">Apply Filters</button>
                <button type="button" id="clearFilters" class="btn btn-secondary">Clear All</button>
            </div>
           
            <div id="result" class="mt-4">
                <!-- The filtered results will be displayed here -->
            </div>
        </div>
       
        <script>
            $(document).ready(function () {
                $('#toggleItemType').change(function () {
                    $('#itemTypeSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleProductCategory').change(function () {
                    $('#productCategorySection').toggleClass('d-none', !this.checked);
                });
                $('#toggleDepartment').change(function () {
                    $('#departmentSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleBrand').change(function () {
                    $('#brandSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleSupplier').change(function () {
                    $('#supplierSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleWarehouse').change(function () {
                    $('#warehouseSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleLocation').change(function () {
                    $('#locationSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleExistence').change(function () {
                    $('#existenceSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleCreationDate').change(function () {
                    $('#creationDateSection').toggleClass('d-none', !this.checked);
                });
                $('#toggleDateMovement').change(function () {
                    $('#movementDateSection').toggleClass('d-none', !this.checked);
                });
               
                $('#applyFilters').click(function () {
                    let filters = {
                        itemType: $('#itemTypeSection').is(':visible') ? $('#itemTypeFilter').val() : null,
                        productCategory: $('#productCategorySection').is(':visible') ? $('#productCategoryFilter').val() : null,
                        department: $('#departmentSection').is(':visible') ? $('#departmentFilter').val() : null,
                        brand: $('#brandSection').is(':visible') ? $('#brandFilter').val() : null,
                        supplier: $('#supplierSection').is(':visible') ? $('#supplierFilter').val() : null,
                        warehouse: $('#warehouseSection').is(':visible') ? $('#warehouseFilter').val() : null,
                        location: $('#locationSection').is(':visible') ? $('#locationFilter').val() : null,
                        existence: $('#existenceSection').is(':visible') ? $('#existenceFilter').val() : null,
                        creationDate: $('#creationDateSection').is(':visible') ? $('#creationDateFilter').val() : null,
                        movementDate: $('#movementDateSection').is(':visible') ? $('#movementDateFilter').val() : null,
                        movementStatus: $('#movementDateSection').is(':visible') ? $('input[name="movementRadio"]:checked').next('label').text() : null
                    };
                    // Showing the values in an alert
                    alert(JSON.stringify(filters, null, 2) );
                    //     $('#result').html('<pre>' + JSON.stringify(filters, null, 2) + '</pre>');
                   
                    // Logic to filter and display the data based on the filters
                    // This is where you would integrate with your data source to fetch and display the filtered data
                });
            });
           
           
            // Function to clear all filters
            function clearAllFilters() {
                // Explicitly handle the controlling checkboxes
                $('#toggleItemType, #toggleProductCategory, #toggleDepartment, #toggleBrand, #toggleSupplier, #toggleWarehouse, #toggleLocation, #toggleExistence, #toggleCreationDate, #toggleDateMovement')
                .prop('checked', false)
                .trigger('change'); // Trigger change to hide sections
               
                // Reset the values of all filter input fields and selects
                $('#filtersContainer select').each(function () {
                    $(this).prop('selectedIndex', 0); // Reset to first option
                });
               
                $('#filtersContainer input[type="radio"], #filtersContainer input[type="checkbox"]').not('[id^="toggle"]').each(function () {
                    $(this).prop('checked', false); // Clear checkboxes/radios that are not section toggles
                });
               
                $('#filtersContainer input[type="text"], #filtersContainer input[type="date"]').each(function () {
                    $(this).val(''); // Clear text and date inputs
                });
               
                // Hide all selection sections directly
                $('#filtersContainer > div').addClass('d-none');
            }
           
            // Event listener for the Clear All button
            $('#clearFilters').click(function () {
                clearAllFilters(); // Call the function to clear all filters
                $('#applyFilters').click(); // Trigger the Apply Filters button click
            });
           
           
           
        </script>
       
    </body>
   
    </html>
   

 


It seems like a great solution but you should write it in fwh because I'm not using modharbour/html/webview
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 7075
Joined: Thu Oct 18, 2012 7:17 pm
Top

Re: Filter on Xbrowse

Postby karinha » Mon May 06, 2024 11:13 am

Good morning Master Otto, could you send me the FILE.DBF? It seems very EASY to create the filters in FWH according to your beautiful image, in WEBVIEW.

Buenos días Maestro Otto, ¿podría enviarme el FILE.DBF? Parece muy FÁCIL crear los filtros en FWH según tu bella imagen, en WEBVIEW.

Tks, gracias.

Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
User avatar
karinha
 
Posts: 7835
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil
Top

Re: Filter on Xbrowse

Postby Marc Venken » Mon May 06, 2024 3:24 pm

João, have also a look in the filter setting of xbrowse self.

The advantidge is that you already have all the field you want to filter on.

Code: Select all  Expand view  RUN

#include "fivewin.ch"

function Main()

   local oDlg, oBrw, oFont
   local aData

   USE CUSTOMER
   aData := FW_DbfToArray( "FIRST,LAST,CITY" )
   CLOSE CUSTOMER

   DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-14
   DEFINE DIALOG oDlg SIZE 700,500 PIXEL TRUEPIXEL FONT oFont

   @ 60,20 XBROWSE oBrw SIZE -20,-20 PIXEL OF oDlg ;
      DATASOURCE aData AUTOCOLS HEADERS "First", "Last", "City" ;
      CELL LINES NOBORDER AUTOSORT FOOTERS

   WITH OBJECT oBrw
      :aCols[ 1 ]:bFooter  := { || "Records : " + Str( oBrw:nLen ) }
      //
      :uBarGetVals   := Space( 10 )
      :bClrEdits     := { || { CLR_BLACK, CLR_YELLOW } }
      :lBarGetOnKeys := .t.
      :lGetBar       := .t.
      //
      :CreateFromCode()
   END

   @ 10, 20 BTNBMP PROMPT "Set Filter" SIZE 200,40 PIXEL OF oDlg FLAT ;
      ACTION ( xSetFilter( oBrw ), oBrw:SetFocus() )

   @ 10,240 BTNBMP PROMPT "Clear Filter" SIZE 200,40 PIXEL OF oDlg FLAT ;
      ACTION ( xClearFilter( oBrw ), oBrw:SetFocus() )

   ACTIVATE DIALOG oDlg CENTERED
   RELEASE FONT oFont

return nil

function xSetFilter( oBrw )

   local cFilter  := ""
   local oCol, c

   for each oCol in oBrw:aCols
      if !Empty( oCol:uBarGetVal )
         c  := Upper( AllTrim( oCol:uBarGetVal ) )
//         c  := "'" + c + "' $ Upper( aRow[" + LTrim( Str( oCol:nArrayCol ) ) + "] )"
         c  := "'" + c + "' $ Upper( cValToChar( aRow[" + LTrim( Str( oCol:nArrayCol ) ) + "] ) )"  // can be char,date,num
         if !Empty( cFilter )
            cFilter  += " .AND. "
         endif
         cFilter  += c
      endif
   next

   if Empty( cFilter )
      xClearFilter( oBrw )
   else
      cFilter  := "{ |c,aRow,oBrw| " + cFilter + " }"
      oBrw:bFilterExp  := &( cFilter )
      oBrw:ArrayIncrFilter( "dummy" )
      oBrw:Refresh()
      oBrw:SetFocus()
   endif

return .t.

function xClearFilter( oBrw )

   AEval( oBrw:aCols, { |o| If( o:oBarGet == nil, nil, o:oBarGet:cText := uValBlank( o:uBarGetVal ) ) } )
   if oBrw:nLen < Len( oBrw:aArrayData )
      oBrw:bKeyCount    := { || Len( oBrw:aArrayData ) }
      oBrw:Refresh()
   endif
   oBrw:SetFocus()

return .t.

 
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1446
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium
Top

Re: Filter on Xbrowse

Postby karinha » Mon May 06, 2024 3:40 pm

Excellent Marc. But this model does not help with the type of work that Silvio Falconi needs. Ask him to send you a video of how he would like to make the filters. Super complicated, expensive (many Euros) and time-consuming (laborious)

Excelente Marc. Pero este modelo no ayuda con el tipo de trabajo que necesita Silvio Falconi. Pídele que te envíe un vídeo de cómo le gustaría hacer los filtros. Súper complicado, caro (muchos euros) y lento (laborioso)

I wouldn't develop it for free for anyone here in Brazil. I would charge in dollars. hahahaha.

No lo desarrollaría gratis para nadie aquí en Brasil. Cobraría en dólares. jajajaja.

Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
User avatar
karinha
 
Posts: 7835
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil
Top

Re: Filter on Xbrowse

Postby Otto » Mon May 06, 2024 5:19 pm

Dear João,
I don't have a .dbf file.
Here, I've only attempted to replicate the filter input as seen in Silvio's video.
I think it's a lot of work until it functions properly.
Regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm
Top

Re: Filter on Xbrowse

Postby karinha » Mon May 06, 2024 5:49 pm

How sad, Master Otto. I understand. That's what I'm trying to explain to Silvio, without the databases to "Tie" the codes, it gets complicated, as everything depends on the databases. And like I said, this is expensive and very time-consuming.

Qué triste, Maestro Otto. Entiendo. Eso es lo que le intento explicar a Silvio, sin las bases de datos para "Atar" los códigos, se complica, ya que todo depende de las bases de datos. Y como dije, esto es costoso y requiere mucho tiempo.

Tks, gracias.

Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
User avatar
karinha
 
Posts: 7835
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil
Top

Re: Filter on Xbrowse

Postby Silvio.Falconi » Wed May 08, 2024 10:25 am

It was not what I had to do, but in part I solved my problem.

- is compatible with all archives
-for each table or archive create an ini file
- all the filters and many lines for each filter are saved in the ini file


Image


I still have to perfect it but it seems to work
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 7075
Joined: Thu Oct 18, 2012 7:17 pm
Top
Previous
Post a reply

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 35 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group