Experience in Developing an Auto Parts Online Store Website Using the Yii Framework and Integration with the Company's Corporate Information System
DOI:
https://doi.org/10.62911/ete.2023.01.02.07Keywords:
database, website, auto parts, PHP, MySQL, MVC, Yii.Abstract
At the current stage of development of information technologies, one of the main tasks of any trade enterprise is to gain new customers, create recognition of brands and trademarks to ensure profitability of business. The using of Internet technologies is relevant when automating tasks and will be requested from post-employees. This results in the acquisition of new clients, as well as a reduction in the cost of recruiting new customers. The requirements for software development were clearly formulated on the basis of the studies of e-commerce processes. This will allow to automate the receipt of orders from clients and increase the efficiency of customer service. Based on the analysis of existing websites, the main functional parts that should be inherent in any online auto parts store are highlighted: a multi-level hierarchy of categories, detailed product characteristics and search by various properties of auto parts. In the course of software development, the need to create an online store using the PHP language, the MySQL DBMS, and the Yii framework was substantiated. A database was designed to solve the problem of increasing trade efficiency using Web technologies. The web site of the online auto parts store was created to ensure electronic trade at enterprises and increase the efficiency of product sales. The created Web site is part of the corporate system of the trading company, facilitates the procedure of placing orders and allows you to obtain an additional sales channel. One of the main functions that the user can perform with the help of the Web site is: viewing the product catalog by categories, groups and subgroups, which greatly facilitates the search for the necessary product. An effective filtering system has been developed for searching for auto parts based on various features. The integration of the website with the enterprise's corporate system has been developed. For the corporate information system, a number of processes and reports were developed for the automatic export of products to the site. At the same time, the export of products is organized in the form of a queue and is uploaded to the site in portions after a certain time interval. At the same time, new products or changed by the user in the system enter the queue.
References
Bramer, M. (2015). Using a MySQL Database I. In: Web Programming with PHP and MySQL. Springer, Cham. https://doi.org/10.1007/978-3-319-22659-0_12
Krogh, Jesper Wisborg. (2020). MySQL workbench. In: MySQL 8 Query Performance Tuning, pp. 199–226. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5584-1_11
Kromann, F.M. (2018). Beginning PHP and MySQL From Novice to Professional. Springer, New York. https://doi.org/10.1007/978-1-4302-6044-8
Kromann, F.M. (2018). MVC and Frameworks. In: Beginning PHP and MySQL. Apress, Berkeley, CA https://doi.org/10.1007/978-1-4302-6044-8_21
Lengstorf, J., & Wald, K. Pro PHP and jQuery. Apress (2016). https://doi.org/10.1007/978-1-4842-1230-1
Naipopuliarnishi movy prohramuvannia u 2023 rotsi. https://kiev.lemon.school/uk/itblog/yaku-movu-programuvannya-vibrati.
Pitt, C. (2012). Pro Php MVC. Apress, New York. https://doi.org/10.1007/978-1-4302-4165-2
TIOBE Index for September 2023. https://www.tiobe.com/tiobe-index/
West, A.W., Prettyman, S. (2018). Create and test a database and table. In: Practical PHP 7, MySQL 8, and MariaDB Website Databases, pp. 1–31. Apress, Berkeley. https://doi.org/10.1007/978-1-4842-3843-1_1
Zandstra M., Vagrant. In. (2016). PHP Objects, Patterns, and Practice., Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1996-6
