Sunshine
This system has two part. Web portal and mobile apps. I responsible to develop portal and manage all api called.
Import Total Production Data - Incoming transaction master csv everyday
Review Stock Allocation - Adjust Stock Quantity by Product & Routes
System will Auto Allocate Adjust Stock Quantity (in %) according to Routes
Export Final Quantity for Distribution to Apps
Proceed with Sales Process in Apps - Create 18 Api.
Import 16 csv file into web portal. The csv need to be placed in the linux server. Those csv file is coming from another ERP system. Then, go to upload files in portal. Choose date and click import buton. I need to mapping each of the csv files into the database.
I'm using ajax jquery for front end meanwhile in backend, I'm using laravel queue jobs. When in live server, I insert command php artisan queue:work --timeout=8000 into linux. So, this command set up in 9am. The reason of using queue jobs , some of the csv consist of huge amount data.