Creation of single api with laravel and implementation to my current joomla site -- 2

Implement 12 hotel api’s into one single common database and one master api Goal of this project is to import all the databases of the 12+ apis that we want to integrate and connect them into one single database that will work as a master api for our systems. Problem is that each provider has different structure, names of countries, cities and hotels. So you have to find a way to merge everything. For example Hotelston: Greece-Crete-Hotel Manos Chania Travco: Grecia-Chania- Hotel Manos Travco: Greca-Chania Town- Manos Tip. If it can be possible to intervene to the combination through an import of the excel that will indicate what is what in each provider Cache the results. In order not to abuse the apis, we want to build a control panel that will cache the results for an x time (according to our indication). Then take the prices from the cache and not from the provider itself. We must have to ability to determine the time of cache of each api provider separately. When a hotel does not exist then take results from the next available in the listing. Lets say we call a specific hotel from a provider. And this hotel does not exist or has no availability to that provider. Then take the price from the next available api according to the listing that we will indicate. For example: We call hotel Best Western Amedia Plus which is situated in Austria, Vienna using the Hotelston provider, and this provider does not have availability or that hotel at all. Then go to the list of the providers, take the next in line and search for the same hotel. Probably at Travco it should search Austria-Wien- Amedia plus. Implementation of this single api into my current joomla customed php site We already have a site that includes api’s separately. We want you to implement this new api into our system so that we will be able to make packages. You can see how we imported the current apis in order to do implementation correctly. Api must have a control panel You must build a control panel from where we can: 1) Configure the caching of each api 2) Be able to configure the wrong implementations of cities, countries and hotel names 3) Change the order of apis from where we can take the results in case the x provider does not have availability 4) Disable or able one of the apis that is included in the single master api 5) Have a search engine from where we can make searches and see results