Naxum Full Stack Web Developer interview questions

Commission Report: Build a page where we can pull a report of all orders that are in the database with the following columns: 1. Invoice: Invoice number of the order 2. Purchaser: Purchaser of the order 3. Distributor: The person who referred the Purchaser. Also known as the Referrer. If the Purchaser’s referrer is not a Distributor, leave this column blank. 4. Referred Distributors: The number of Distributors that the Referrer/Distributor (from the 3rd column) has referred by the �me the order was made. Note that this number gradually increases as the Referrer refers more Distributors over �me. 5. Order Date: Date the order was placed 6. Percentage: Commission percentage that the Distributor (Referrer) will get paid. Note that this is dependent on the number of Referred Distributors he/she has. If the purchaser is not a Customer, the Distributor does not earn a commission. 7. Commission: Percentage x Order Total ● Add a feature that would allow us to filter the result by Order Date and Distributor. Note that the Distributor input box is an autocomplete field. TASK 2 Rank Report: Build a page where we can see the Top 100 Distributors with the most sales. Sales are the total amount of orders that have been purchased by the customers and distributors they have referred. Note that if 2 or more Distributors have achieved the same amount of sales, they would have the same # on the list. PART B REQUIREMENTS: - Programming Language: PHP - Framework: Use Na�ve PHP. Do not use a framework. - DBMS: MySQL - Database Schema: Design your own database model. TASK 3 Build a Registra�on Page that would require a user to submit the following info: ● Name ● Birthdate ● Complete Address ● Profile Picture ● Credit Card Info EXPECTED OUTPUT ● All 3 pages must load in less than 10 seconds. ● All features outlined in the instruc�ons above are working. ● A video demo explaining how to use the 3 tools you’ve built. ● In submi�ng your output, please provide the following files separately: a. Source Codes for Part A (Task 1-2) in a ZIP file b. Source Codes for Part B (Task 3) in a ZIP file c. SQL file used in Part A d. SQL file used in Part B e. Video demo of your Part A output f. Video demo of your Part B output