Abstract
This paper describes the design and implementation of a workflow-driven web application to manage the inventory and business operations for the recycling and reprocessing businesses. On the backend, the relational database is built with flexibilities and extensibilities for future organization expansion. The user management is customized to the company needs with tiered role-based data access control. For the front end, the graphical user-friendly interface is tailored for non-IT users to efficiently update and search inventory items, track incoming and outgoing orders, and manage their business workflow. For the middleware, the business logics, operational workflow managements, the data processing, the system optimizations, and web-page connections are integrated into the design and development for the various business operations. The system has been implemented using MySQL and PHP with the XAMPP the web service package. Additional dashboards, graphic user interfaces, and data analytical functions have also been implemented. This system can be easily transformed to other database management systems and other middleware tools. The overall database design can be conveniently adopted by other businesses where inventory management is a challenge.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Peterson, R., Silver, E.A.: Decision Systems for Inventory Management and Production Planning, p. 799. Wiley, New York (1979)
Gill, S., Bhullar, S., Singh, N.P., Khullar, P.: A review paper on various approaches of spare parts inventory management system. In: 3rd National Conference, p. 304, February 2016
Li, S.G., Kuo, X.: The inventory management system for automobile spare parts in a central warehouse. Expert Syst. Appl. 34(2), 1144–1153 (2008)
Bahrom, M.Z., Roslin, E.N., Razak, S.N.A., Rahman, M.A.A.: A conceptual model of inventory management system using an EOQ technique–a case study in automotive service industry (2015)
Ozguven, E.E., Ozbay, K.: A secure and efficient inventory management system for disasters. Transp. Res. Part C Emerg. Technol. 29, 171–196 (2013)
Zhang, J., Wu, H.: Page file-oriented web application design. In: The Proceedings of 2016 8th International Conference on IT in Medicine and Education (ITME 2016), pp. 1–6 (2016)
Baker, D.C.: An innovative project-driven senior-level antennas course. IEEE Trans. Educ. 40(3), 190–194 (1997)
Zhang, Y., Chen, S.Y.: Cultivating program of software talents based on project-driven. Comput. Educ. 9, 21–23 (2010)
Ohlsson, L., Johansson, C.: A practice driven approach to software engineering education. IEEE Trans. Educ. 38(3), 291–295 (1995)
Liu, J.: Application of ‘Project-driven’ teaching method in teaching of SQL SERVER database technology. J. Bohai Univ. (Natural Science Education) 30(4), 366–370 (2009)
Xing, G.H., Chan, J.K.Y., Leung, A.O.W., Wu, S.C., Wong, M.H.: Environmental impact and human exposure to PCBs in Guiyu, an electronic waste recycling site in China. Environ. Int. 35(1), 76–82 (2009)
Byström, S., Lönnstedt, L.: Paper recycling: environmental and economic impact. Resour. Conserv. Recycl. 21(2), 109–127 (1997)
Arena, U., Ardolino, F., Di Gregorio, F.: Technological, environmental and social aspects of a recycling process of post-consumer absorbent hygiene products. J. Clean. Prod. 127, 289–301 (2016)
Kara, S.S., Onut, S.: A stochastic optimization approach for paper recycling reverse logistics network design under uncertainty. Int. J. Environ. Sci. Technol. 7(4), 717–730 (2010)
Louis, G., Shih, J.S.: A flexible inventory model for municipal solid waste recycling. Socio-Econ. Plan. Sci. 41(1), 61–89 (2007)
Waller, M.A., Fawcett, S.E.: Data science, predictive analytics, and big data: a revolution that will transform supply chain design and management. J. Bus. Logist. 34(2), 77–84 (2013)
Hazen, B.T., Boone, C.A., Ezell, J.D., Jones-Farmer, L.A.: Data quality for data science, predictive analytics, and big data in supply chain management: an introduction to the problem and suggestions for research and applications. Int. J. Prod. Econ. 154, 72–80 (2014)
Garcia, D.J., You, F.: Supply chain design and optimization: challenges and opportunities. Comput. Chem. Eng. 81, 153–170 (2015)
Brandenburg, M., Govindan, K., Sarkis, J., Seuring, S.: Quantitative models for sustainable supply chain management: developments and directions. Eur. J. Oper. Res. 233(2), 299–312 (2014)
Pariatamby, A., Tanaka, M.: Municipal solid waste management in Asia and the Pacific Islands. Environmental Science. Springer, Singapore (2014)
Rahmaninia, M., Khosravani, A.M.I.R.: Improving the paper recycling process of old corrugated container wastes. Cellul. Chem. Technol. 49(2), 203–208 (2015)
Cheung, W.M., Pachisia, V., Hasan, R.: Facilitating waste paper recycling and remanufacturing via a cost modelling approach (2014)
Macaluso, A.: Characterization of biofilms on medical device materials with application to reusable surgical instruments (2014)
Rivier, C., Roudil, D., Rigaux, C., Camès, B., Adnet, J.M., Eysseric, C., Organista, M., et al.: Validation of analytical methods for nuclear spent fuel reprocessing. Prog. Nucl. Energy 72, 115–118 (2014)
Wu, H., Ambavane, A., Mukherjee, S., Mao, S.: A coherent healthcare system with RDBMS, NoSQL and GIS databases. In: The Proceeding of the 2017 32nd International Conference on Computers and Their Applications (CATA 2017), pp. 1–6 (2017)
Acknowledgments
This work is partially supported by Science and Technology Development Project of Henan Province (No. 152102410033).
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Wu, H., Zhang, J., Mukherjee, S., Deng, M. (2017). A Workflow-Driven Web Inventory Management System for Reprocessing Businesses. In: Uden, L., Lu, W., Ting, IH. (eds) Knowledge Management in Organizations. KMO 2017. Communications in Computer and Information Science, vol 731. Springer, Cham. https://doi.org/10.1007/978-3-319-62698-7_27
Download citation
DOI: https://doi.org/10.1007/978-3-319-62698-7_27
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-62697-0
Online ISBN: 978-3-319-62698-7
eBook Packages: Computer ScienceComputer Science (R0)