Internet Marketing By Implementing Enterprise Resource Planning (Erp) At The Mukomuko Milk Center Using Php Programming Language And Mysql Database

This study describes about design of internet marketing by implementing ERP which is supported by a MySQL database and the PHP programming language. From the research conducted at Sentra Susus Sapi Mukomuko, it can be concluded that the old system used was ineffective because the process take a long time and space, thus making the performance of employees less efficient. After conducting research at Senstra Susu Sapi Mukomuko the researcher using interview methods and other methods, it can be concluded that the information system used is still not optimal. Therefore, the output design, input design, file design and program flow of the new system are carried out. The results of the analysis are applied to an ERP program. The new information system designed is expected to improve the quality of information and performance in the future.


Introduction
Today's dynamic business is increasingly complex with functional units requiring more inter-departmental data flows for decision making, timely and efficient spare parts procurement, inventory management, accounting, human resources and distribution of goods.In this regard, efficient information systems will increase competitiveness through reduced costs and better logistics.There is also an emphasis on greater interaction between customers and suppliers, to achieve the production of goods and services according to customer specifications.Enterprise Resource Planning (ERP) is a strategic tool that synchronizes, integrates and streamlines organizational data and processes into a single system to gain competitive advantage in an uncertain business environment.
In developing countries, there is a tendency for departments to work independently so that different sections compete rather than work together.This has compromised the operational efficiency of a large number of manufacturing entities.Thus the resulting product cannot compete both within and outside the country of origin in terms of cost, quality and on time delivery.With ERP, companies can manipulate large amounts of data or information to be processed and displayed as desired.
Therefore, ERP has a vital role for competitive advantage in a company.Given the facts above, it is undeniable that the Enterprise Resource Planning (ERP) system is not new and has even become one of the crucial things that must be owned by companies.However, in practice in Indonesia, especially in Mukomuko, not all companies use an ERP system because of the high cost and complex complexity.The existence of these factors finally makes the middle to lower companies decide that they have not been able to use the ERP system.
From the background that has been described, to get better results due to the limitations of the research, the problem is limited to how to present a system so that the problems faced are not too broad.The goal is that problem solving does not deviate from the objectives to be achieved and in accordance with the title that the author presents.Therefore, the author limits the problem in general, namely the author only limits internet marketing problems by implementing Enterprise Resource Planning at the Mukomuko Cow Milk Center using the PHP programming language and MySql database to produce an output that can help factory owners see raw material information and sales transaction information.clearly at the Mukomuko Cow Milk Center.
The most important requirement of an ERP system is integration.The integration is meant to combine various requirements on one software in one logical database, making it easier for all departments to share information and communicate.The implementation of an ERP system depends on the size of the company/organization, the scope of the change, the role, and the customers/members of the company/organization.In implementing this ERP the organization/company requires consulting, customization and support services (Syahdindo et al., 2019)

MySql
MySQL is one type of database server that is very well known.Its popularity is due to MySQL using SQL as the basic language to access its database.Mysql is a type of RDBMS (Relational Database Management System).In MySQL, a database contains one or more tables.A table consists of a number of rows and each row contains one or more columns.
There are several ways to manage the Mysql database, namely through the DOS prompt (command line tool) (Maulana, 2016).

PHP (Hypertext Preprocessor)
PHP is the most widely used script programming language today.PHP is widely used to program dynamic websites, although it is possible to use it for other uses (Syahdindo et al., 2019)

Methodology
In conducting research so that the results are as expected, a research framework is needed, where the research framework carried out is described as Figure 1 describes the stages carried out in the research.

Figure 1 Research Framework
The research method carried out is as follows: a. Preliminary Research This preliminary research was conducted with the aim of understanding and analyzing a problem and the constraints that occur in the object under study so that researchers can find some temporary solutions for solving problems that occur in the object under study.
In this preliminary research, the researcher can also determine whether or not this research is suitable for the object under study.

b. Data collection
In conducting the data collection process, the authors conducted direct interviews with Mr. Rudi as the owner of the Mukomuko Cow Milk Center.The author gets some important information related to the research being carried out.

Research Time
The research was carried out on January 12, 2021 for data collection and ended on May 30, 2021 at the Mukomuko Cow Milk Center.

Research Place
The research location for data collection and collection was carried out at the Mukomuko Cow Milk Center.

Research methods
In writing this final report, the author uses several methods to collect data, namely:

c) Laboratorium Research
This research is processing the data -the data that has been collected is related to produce valid information.In this case the research is carried out by designing programs or software that are in accordance with the topics and problems encountered and also in terms of preparing the overall report.
c. Analysis

Data Analysis
This data analysis is carried out after collecting data and information that has been taken through direct interviews, this data analysis stage is a process of processing data to obtain the steps that will be used during the design to match the expectations of the research objectives.

Process Analysis
In this study using the Enterprise Reosurce Planning method in the process, and process analysis is useful in designing system processes in data processing which can later provide suggestions and descriptions of system performance, so that they can understand the system processes that will later be used.

System Analysis
Analyze what system design is appropriate to be designed at the Mukomuko Cow Milk Center, by carrying out this stage it is intended that the system designed is suitable for the needs of the Mukomuko Cow Milk Center.

Class Diagram
Class diagrams describe the relationship between database tables, can be seen in Figure 3:

System Implementation
The system implementation stage (System Implementation) is the stage of placing the system so that it is ready for operation.In carrying out implementation activities, several things need to be done, namely implementing an implementation plan.Is the initial activity of the system implementation stage, the implementation plan is intended primarily to manage the costs and time needed, implementation activities are carried out on the basis of the activities that have been planned in the implementation plan.Follow-up implementation is done by testing the system acceptance (system acceptable test) against the actual data within a certain period of time which is carried out together with the user.Implementation activities are carried out on the basis of activities that have been planned in implementation activities, including personnel selection and training, site selection, and hardware and software installation, program testing, system testing and system conversion.

Results and Discussion
In the testing section of this program will be explained about the use of the program created.The explanation of the program made includes the appearance of the program, the control functions in the program, and how to use it.This sub-chapter will explain the use of the program per menu system, starting from the main menu display, functions and how to use it until it's finished.

Main Page Display
This main page displays the initial appearance of the website.For more details, see Figure 7 below: The following is a display that shows the admin home view, for more details, it can be seen in Figure 8 below:

Input Item Data
The item data input form displays a list of item data on the admin display, for more details, it can be seen in Figure 9 below: The results form displays the results of all input data items that have been inputted, for more details, it can be seen in Figure 4 below:  The leadership input form for more details can be seen in Figure 12 below: The sales transaction input form for more details can be seen in Figure 13 below: Sales invoice report form for more details can be seen in Figure 14 below: The daily sales report form for more details can be seen in Figure 15 below: Monthly sales report form for more details can be seen in Figure 16 below: The annual sales report form for more details can be seen in Figure 17 below: carried out directly on the object of research at the Mukomuko Cow Milk Center to collect primary data using data collection techniques b) Library Research Research conducted to collect secondary data by reading books, journals, literature related to research to support an information.
d. System planningIn this design stage, the researcher uses the Unified Modeling Language (UML) as a tool in explaining the flow of program analysis where UML is used, namely:1.Use Case DiagramUse case diagrams are used to explain the benefits of the application when viewed from the point of view of people who are outside the system (actors).In designing this application, the use case diagram consists of admin and customers.These two users are users of the application who can carry out activities within the application according to their rights.

Figure 5 :
Figure 5: Sequence Diagram Info Order c.Sequence diagram Sale The sales sequence diagram shows how the user sees sales transactions in the system.The work structure and interactions when executed look as follows:

Figure
Figure 7. Main page 2. Admin Home Page Display

Figure 8 .
Figure 8. Admin Home Page

Figure 9 .
Figure 9. Item Data Input Page

Figure 4 .
Figure 4. Item Data Display Page5.Input Data PetugasThe officer data input report form for more details can be seen in Figure11below:

Figure
Figure 11.Officer Data Input Display Page

Figure
Figure 13.Sales Transaction Display Page 8.Sales Invoice Report

Figure 14 .
Figure 14.Sales Invoice Display Page 9. Daily Sales Report

Figure
Figure 15.Daily Sales Report Display Page

Figure
Figure 16 Monthly Sales Report Display Pages

Figure 17 .
Figure 17.Annual Sales Report Display Page