I need help with a wordpress web app project (see sketch attached).
A manufacturing company with over 30 Regional Offices with each regional offices having 20 branches each.
Now each branch prepares a weekly report of their activity which includes Week, Number of attendance, Punctuality of staff , meeting location, donations,payments,branch name and region name--say Week1, Week2, Week3, Week4 and Week5.....I can create a custom post type with custom post meta to handle this.
However, my challenge is with creating a report post list for a Region(this will be monthly) with aggregated details from the custom post type and details created above....
Region 1 for example will have the following tables => Branch, Number of attendance(this will be total for all the weeks in the month for a specific branch), Punctuality of staff(total for the week for a branch) , meeting location, donations(total for the week for a branch) and payments(total for the week for a branch).
How can i handle this especially to create a post list for each Region. Remember i already have an exiting post list from the custom post type for each Branch weekly report.
please note that everything must be in the wp-admin backend..
Someone suggested Wp-list table api but How can i build a Post lists by using the wp-list table api for wordpress backend?The contents of the this table will be a special query taken from a custom post type content. I dont want to use sql queries , i want to remain native with wordpress post queries.