A web-based database tracking system, custom-built to fit INL Bogotá requirements.
ViewTrack exists to give authorized government logistics personnel a single, secure, web-accessible view of cargo as it moves through the supply chain — from the moment it is received into the warehouse until it departs for its final destination. By extending our locally developed Cargo Management System to the web, we make accurate, real-time shipment status available to the people who need it, wherever they are.
The platform is based on reports from a locally developed Cargo Management System (CMS) that powers most of our functions. The CMS is a Microsoft Access database, highly customizable for our purposes. Its major functions are to track cargo from receipt into the warehouse until departure; provide basic warehouse management capability for storage and inventory; produce a “loading guide” for shipments (consolidations); and deliver order and shipment status to our customers through a variety of customized reports. It can detail line items received and line items shipped, and is suitable for the preparation of all required shipping documentation.
ViewTrack brings these capabilities online. Data from the CMS is exported and uploaded through the Archives module to feed the web platform, where authorized users query it through secure, role-based reports.
Clients — user accounts are created here so personnel can access the archives; accounts can be activated or deactivated at any time. Archives — Excel data is uploaded here to feed the system.
Manage warehouses, statuses and report parameters, toggle reCAPTCHA and phone (SMS) verification, and review the audit log.
The system provides role-based logins for Reports, Warehouse and Web Administration. Each is protected by Google reCAPTCHA to prevent robot and script-based attacks, and by phone (SMS) verification — a one-time code sent to the user's registered phone number at sign-in. The Clients submodule lets administrators activate or deactivate any user account, and client accounts are restricted to shipments in their assigned region.
ViewTrack runs on a GoDaddy Linux server with 100 GB of storage, PHP 5.6.30, and MySQL. The front-end is built with HTML5, CSS3, JavaScript and the jQuery framework.
README.md for credentials and notes on connecting it to the live PHP/MySQL backend.