Custom Part Number Lookup - Prestashop

What I need the search to do is facilitate a Part Number Lookup: [login to view URL] someone searches for a part# a. Do a database look-up on ps_product_part_number table for the part number b. Do a query that joins the two tables and resolves the ID to the ps_product and ps_product_lang tables c. Return to the user the product details on the search results page with the API, Clients Part #, and Swaim Part #'s listed i. I also need this to return the product details, such as image, description, and add to cart option, etc. d. If the part number does not resolve, simply give the end user a customization message e. If the user is not logged in, only search for the API and SWAIM part numbers i. If no results are returned, present the end user with a login option 2. It would be nice if the API, Client ID, and Part Numbers could be modified from the back-end through a module