Implementación de aplicación web con acceso a base de datos para manejo de inventario de la empresa Orange Business Services Colombia S.A

Abstract

For the practitioners of the Orange Business Services company, they must perform several tasks, but one of the most important is to keep the internal inventory of the company in order and up to date, currently the registration of this inventory is managed by means of 4 sheets of Excel calculation that are: entry of new equipment, exit of new equipment, entry of used equipment and exit of used equipment. Normally when new equipment arrives at the company, the practitioners are responsible for receiving them, verifying that everything is in perfect condition and the information such as the equipment model, brand, purchase order and serial matches what was expected, this information is what is Stores new equipment in the incoming inventory with the location where it will be stored in the warehouse. In cases where it is necessary to carry out an exit of these equipment, the information found in the entry register of new equipment is taken and moved to the exit of new equipment with the date it left. For the process of used equipment it is quite similar, the only difference is that these are equipment that has already been used previously and these equipment no longer have, for the most part, a purchase order, the use of these equipment is normally for the internal use of the company or some loan to engineers for testing. The problem to be addressed here is how this information is being handled, since when going through several practitioners there are times when, due to simple human error, the information can be disorganized and this generates problems when looking for the data equipment that is needed, generating waste of time, which for the company is very important to optimize, in addition, the program to be used is not very safe and that is without counting that the computer equipment that stores the inventory is in constant movement, running the risk that they will be damaged and all the information that is stored is lost and cannot be recovered. For this reason, the idea of ​​this project seeks to systematize the inventory process and make the information more secure. The management of information in companies is of vital importance for its operation, but there is always the risk of losing it due to some type of failure or malfunction of the equipment that contains this information, currently companies save their data on servers and internal networks, not only to keep them safe but also so that company personnel who are connected to that server can access easily and safely Currently, many companies manage their internal information through platforms, web applications or private software that are connected to their servers, one of the advantages of a web application compared to the private software that some companies handle is that software is not necessary in computer equipment for its operation but requires the use of a web browser that has an internet connection. To this end, it seeks to create a web application for the company with HTML, PHP and MySQL code, where all the company's inventory information is stored in a database that helps to quickly access the location of the equipment either by its purchase order, serials, warehouse location, etc. This information can be accessed only by people who carry out inventory management in the company, in which they can enter through a username and password, the application will also allow adding new information for teams that arrive at the company as well as the option to release them for when they are dispatched from the company. The interface is intended to be simple and easy to understand for the end user.