The paper describes development of computer model for manufactory logistic and creating client application for semi-automatic logistics management. Object of this study is metal processing company. PHP programming language, MySQL database, and Apache web server were used to create client application. The interface developed using HTML5, CSS and javascript.
Description
Amount in one package Size of a package (W) Size of a package (L) Size of a package (H) Fragility
mm. mm. mm.
Y\N. This attribute is used in the product's card for record at packing and loading the product 9 10 The role model of application implies restrict of access to view orders statuses for various users. An example of such a restriction can be "Driver" role - these users have access to view only those product units that they are linked to.
When order is received, a product unit card is generated. Access to it is received by master from manager. All product unit records in the database that have status "Ready for delivery" are automatically processed by application at the moment of products batch preparation. Based on information about their mass and size, products are automatically linked to transport units [2] that have status "Active" and their drivers receive access to these products' cards.
Next step is create routes for all loaded transport units using interaction with GIS API [3]. Main criteria for distribution and construction of routes: 1. No fragmentation of the order by one customer to different transport units (if possible); 2. Minimize total fuel expenses for loaded transport units (fuel expenses are determined by data from database and distance of route).
The result should be a set of routes for minimum number of required transport units, which will be used to deliver all products that are ready to delivery to customers. Product units of orders with "Delivery order" set as "Only full batch" are not loaded if there are pending product units from the same batch for the customer. 3
For creating prototype version, it was decided to use the PHP programming language and the BoltCMS content management system. This choice has been taken because PHP is optimal for the development and support the project, and also there are many ready-made solutions in free access that used PHP. And the CMS is based on the convenient Symfony framework and tools such an administrative interface, standard functionality for restrict access rights and built-in templates.
At first step, integration with the Google Maps GIS API was used to test functionality, make a list of necessary improvements and get feedback from potential users. In future versions there will be used a selection of optimal routes from different systems, instead of using a single GIS. Ant algorithms [4] will be used for the analysis of these optimal routes.
The server part of the system required to use PHP version above 7.0 and MySQL database version 5 or higher [5]. It can be placed both at customer's or external server by an individual arrangement with customer. Access to the client part is realized via the web interface and through SSL encryption protocols (if it's possible) to ensure the security of the transmitted information.
The process of changing orders statuses and checking conditions is shown in Figure 1. Models that described in par.1 was put in form of a database using DBMS MySQL. Scheme of this database is shown in Figure 2.
Access to modify data in database is limited according to role model presented in Figure 1. Only administrators and director of the company have full access.
Data is generated in database in application working process. It contains information about incoming orders, ordered products, customers and transport. This data is used to calculate the summary values for GIS API. These values include data about transport units, products and customers' addresses.
Linking product units to transport units is automated process in the system with two conditions to be fulfilled: status of product unit must be set to "Ready for delivery"; delivery order of order must be set to "In pieces". If delivery order is set to "Only full batch" then product unit is not taken to linking process to transport units, until all other product units from this order will be ready.
Linking transport unit to a product unit is carried out according to conditions: to load transport unit maximally according to its carrying capacity and to minimize number of transport units per order [6]. Limits for this process are carrying capacity and size of transport unit, as well as weight, quantity and size of product units. As a result, we obtain parameters of each loaded transport units (final weight, fuel expenses).
Customer's address is delivery point. Linking address to a product unit was carried out through an order card, which contains links to all products ordered by customer. Information about departure point was set by default from the place of production.
GIS uses received data to create optimal routes for all loaded transport units, according to all addresses (arrival points), fuel expenses (in case of need to add refueling points to the route) and total weight of transport units with cargo (it's important for traffic weight restrictions).
Presented system allows to optimize logistics of the company using automated distribution of products and creating routes with minimizing probability of operator errors. Implementation in form of a web application provided minimal requirements to hardware solutions and allowed us to consider in future development new options by creating mobile applications or integrating with external services and systems.
Further improvement of developed solution was planned through implementation of searching for optimal routes by using data from multiple GIS and addition of an internal system for orders distribution with new attributes and checks based on feedback after testing.
The work was supported by Act 211 Government of the Russian Federation, contract № 02.A03.21.0006. 3. Hsieh F.-S., Huang, H.W. Vehicle routing based on discrete particle swarm optimization and google maps API.
Proceedings of the international conference on electronic business (ICEB), 292, 2014. 4. Rutger Claes, Tom Holvoet. Ant colony optimization applied to route planning using link travel time predictions.
IEEE international symposium on parallel and distributed processing workshops and phd forum, 358, 2011. 5. Sangnoree A. A Modification of Wireless and Internet Technologies for Logistics’ analysis. Proceedings of World
Academy of Science Engineering and Technology, 18:245-249, 2006. 6. Brijesh Krishna, R.P., Sahay, M. Preplanned truck optimization using cargowiz. Proceedings of the international conference on industrial engineering and operations management,1080, 2017. 7. Borodin, A., Kiselev, Y., Mirvoda, S., Porshnev, S.: On design of domain-specific query language for the metallurgical industry. In: Proceedings of 11th International Conference BDAS: Beyond Databases, Architectures and Structures: Communications in Computer and Information Science, pp. 505–515 (2015) 8. Aksyonov K., Antonova A. The use of simulation in the management of converter production logistics processes.
Advances in Intelligent Systems and Computing. International Symposium on Intelligent Systems Technologies and Applications, ISTA 2016; Jaipur; India; 21 September 2016 through 24 September 2016; Volume 530, pp. 675-682.
DOI: 10.1007/978-3-319-47952-1_54 9. Aksyonov K., Antonova A., Goncharova N. (2018) Analysis of the Electric Arc Furnace Workshop Logistic Processes Using Multiagent Simulation. In: Thampi S.M., Krishnan S., Corchado Rodriguez J.M., Das S., Wozniak M., AlJumeily D. (eds) Advances in Signal Processing and Intelligent Recognition Systems. SIRS 2017. Advances in Intelligent Systems and Computing, vol 678. Springer, Cham. DOI https://doi.org/10.1007/978-3-319-67934-1_35 Pages 390-397. https://link.springer.com/chapter/10.1007/978-3-319-67934-1_35 10. Aksyonov K., Bykov E., Aksyonova O., Goncharova N., Nevolina A. Analysis of Simulation Modeling Systems Illustrated with the Problem of Model Design for the Subject of Technological Logistics (WIP) // Society for Modeling & Simulation International (SCS). 2015 Summer Simulation Multi-Conference (SummerSim'15). Chicago. USA. 2629 July, 2015. Simulation Series. Volume 47, Issue 10, 2015, P. 345-348. 11. Aksyonov K., Bykov E., Aksyonova O., Goncharova N., Nevolina A. Perspectives of Modeling in Metallurgical Production (WIP) // Society for Modeling & Simulation International (SCS). 2015 Summer Simulation MultiConference (SummerSim'15). Chicago. USA. 26-29 July, 2015. Simulation Series. Volume 47, Issue 10, 2015, P. 341344. 12. Alexandrov, V. V., Kuleshov, S. V., Zaytseva, A. A.: Active Data in Digital Software Defined Systems Based on SEMS Structures. Logical Analysis of Data and Knowledge with Uncertainties in SEMS – Smart Electromechanical Systems, Studies in Systems, Decision and Control. Gorodetskiy, A. E. (ed.). 49, 61–69 (2016)