METHOD OF THE FRAMES
Causes AQP Method: Consequences
Lack of a record A: Gedec Store Complaints about the lack of
updated from the information about the
products that exist Products productos disponibles
in the warehouse. in the warehouse at
Inventory management moment to realize
a sale or receive
a query.
Errores al momento
to carry out the control
of inventory.
Contributions
Web System
Variable Dependiente Design
Inventory management
Second Independent: Experimental
Web System
Title
Web system for managing the inventory of the company Gedec Sac
Problem statement:
The store, which currently stands out in the sale of computer equipment,
It has the problem of managing the existing stock in the store.
efficiently. There are situations where the sellers do not have a
correct idea of how many products are available from brands
specific, causing in some cases uncomfortable moments for
the customers who, upon not finding the sought product and waiting in vain,
They decide to go to other stores and avoid our business in the future.
Variables:
Salesperson: Inventory Management
The quantity and existence of certain items are verified in the
store inventory, to get an exact idea of the current stock
in order to meet the needs of our clients
Dimensions Indicators Scales
Reception of Confirmation of Numerical
products product reception
Purchase volume
Supplier audit
Storage - Economic value of the Numeric
inventory
Cost per unit
stored
Unit cost
dispatched
Control of Available products Numeric
inventories Out of stock products
Stock rotation
Distribution Returns Numeric
Delivered orders
satisfactorily
Logistical costs
Prism;
Base of Identification Selection Eligibility Inclusion
data
Google 426000 37100 1680 4
Academic
Redalyc 356474 371 9 2
Springer 733180 38204 5046 3
Scielo 604 83 83 17
Total 1516258 75758 6818 26
Theoretical Framework
Web System
Web Browser
b. Client
c. Server
d. HTML 5
e. JavaScript
JavaScript is a programming language that is used
mainly for creating dynamic web pages. A
A dynamic web page is one that incorporates effects.
like text that appears and disappears, animations,
actions that are activated by pressing buttons and windows with
warning messages to the user. Technically, JavaScript is
an interpreted programming language, so it is not
It is necessary to compile the programs to run them.
In other words, programs written in JavaScript are
you can test directly in any browser without
need for intermediate processes. Pérez, J. E. (2019).
Introduction to JavaScript.
f. SQL server
It is Microsoft's professional database system.
It contains a variety of features and tools.
that can be used to develop and manage databases
data and solutions of all kinds based on them. Pérez,
M. (2011). Microsoft SQL Server 2008 R2. Database engine and
administration. RC Books.
g. MySQL
It is a database management system
fast, solid, and flexible relational. It is ideal for creating
databases accessible from dynamic web pages,
for the creation of online transaction systems or
for any other professional solution that involves
store data, having the possibility to perform
multiple and rapid queries. Cobo, Á. (2005). PHP and MySQL:
Technology for the development of web applications. Díaz editions
Saints.
h. MVC Environment
El patrón MVC es un paradigma que divide las partes que
form an application in the Model, the Views and the
Controllers, allowing implementation by
separated from each element, thus ensuring the
software update and maintenance in a timely manner
simple and in a short period of time
Model: It is the object that represents the data of the
program. It manages the data and controls all its
transformations. It has the responsibility to
maintain links between the Model and its Views, and
notify the Views when the Model changes.
View: It is the object that handles the visual presentation
of the data represented by the Model. Generates
a visual representation of the Model and shows the
user data.
● Controller: It is the object that provides
meaning at the user's orders, acting upon
the data represented by the Model focuses entirely on the
interaction between the View and the Model. When it
make some change, take action, either by
change in the information of the Model or by
vision disturbances.
González, Y. D., & Romero, Y. F. (2012). Model-View-Controller Pattern.
Telematics, 11(1), 47-57.
2. Inventory management
a. Reception of Products
b. Storage
c. Inventory control
d. Distribution