Wordpress tables from a database table
Budget: $8 – $15 USD
I'm looking for a WordPress expert to create a dynamic web page that displays ranking tables for bank stores and allows users to view detailed rankings of store representatives within a pop-up window. The page should also feature date range filters for both tables.
Main Page: Store Rankings
Table 1: Store Rankings
Display a table showing the ranking of stores based on the number of credits issued and the total disbursed amount.
Data source: wp_mis_prestamos table.
SQL Query:
SELECT
TIENDA,
COUNT(*) AS Credit_Count,
SUM(MONTO_TOTAL_DESEMBOLSOS) AS Total_Amount
FROM
wp_mis_prestamos
WHERE
FECHA_APERTURA BETWEEN 'Start_Date' AND 'End_Date' -- Apply Date Range Filter
GROUP BY
TIENDA
ORDER BY
SUM(MONTO_TOTAL_DESEMBOLSOS) DESC
Date Range Filters
Implement filters to set a date range (Start Date and End Date) for Table 1.
Table Interaction
Enable a click event on store names in Table 1 to open the pop-up window.
Pop-up Window: Store Representatives
Pop-up Content
Create a pop-up window that displays rankings of store representatives for a selected store.
The pop-up should include a table with details for store representatives, such as representative name, credit count, and total disbursed amount.
Data source: wp_mis_prestamos table.
SQL Query (example for '101 - MAIN OFFICE'):
SELECT
NOM_USER_DESEMBOLSO AS Representative_Name,
COUNT(*) AS Credit_Count,
SUM(MONTO_TOTAL_DESEMBOLSOS) AS Total_Amount
FROM
wp_mis_prestamos
WHERE
TIENDA = '101 - MAIN OFFICE'
AND FECHA_APERTURA BETWEEN 'Start_Date' AND 'End_Date' -- Apply Date Range Filter
GROUP BY
USER_DESEMBOLSO, NOM_USER_DESEMBOLSO
ORDER BY
Total_Amount DESC
Pop-up Activation
The pop-up should be triggered by a click event on a store name in Table 1.
It should display the ranking details for the corresponding store representative.
Requirements:
Needs to be a page in WordPress, and the use of plugins is allowed.
Implement user-friendly date range filters.
Ensure the pop-up is visually appealing and user-friendly.
Mobile responsiveness is required.
In my wordpress base is used wpdatatables plugin but another plugin is allowed.
I have .wpress file from All-in-One WP Migration plugin.
Video example attached.
Main Page: Store Rankings
Table 1: Store Rankings
Display a table showing the ranking of stores based on the number of credits issued and the total disbursed amount.
Data source: wp_mis_prestamos table.
SQL Query:
SELECT
TIENDA,
COUNT(*) AS Credit_Count,
SUM(MONTO_TOTAL_DESEMBOLSOS) AS Total_Amount
FROM
wp_mis_prestamos
WHERE
FECHA_APERTURA BETWEEN 'Start_Date' AND 'End_Date' -- Apply Date Range Filter
GROUP BY
TIENDA
ORDER BY
SUM(MONTO_TOTAL_DESEMBOLSOS) DESC
Date Range Filters
Implement filters to set a date range (Start Date and End Date) for Table 1.
Table Interaction
Enable a click event on store names in Table 1 to open the pop-up window.
Pop-up Window: Store Representatives
Pop-up Content
Create a pop-up window that displays rankings of store representatives for a selected store.
The pop-up should include a table with details for store representatives, such as representative name, credit count, and total disbursed amount.
Data source: wp_mis_prestamos table.
SQL Query (example for '101 - MAIN OFFICE'):
SELECT
NOM_USER_DESEMBOLSO AS Representative_Name,
COUNT(*) AS Credit_Count,
SUM(MONTO_TOTAL_DESEMBOLSOS) AS Total_Amount
FROM
wp_mis_prestamos
WHERE
TIENDA = '101 - MAIN OFFICE'
AND FECHA_APERTURA BETWEEN 'Start_Date' AND 'End_Date' -- Apply Date Range Filter
GROUP BY
USER_DESEMBOLSO, NOM_USER_DESEMBOLSO
ORDER BY
Total_Amount DESC
Pop-up Activation
The pop-up should be triggered by a click event on a store name in Table 1.
It should display the ranking details for the corresponding store representative.
Requirements:
Needs to be a page in WordPress, and the use of plugins is allowed.
Implement user-friendly date range filters.
Ensure the pop-up is visually appealing and user-friendly.
Mobile responsiveness is required.
In my wordpress base is used wpdatatables plugin but another plugin is allowed.
I have .wpress file from All-in-One WP Migration plugin.
Video example attached.