Decision Support System Of Fruit Cultivation Using Technique For Other Reference Method By Similarity To Ideal Solution ( TOPSIS )

Fruit cultivation is very promising for farmers. But there are problems faced by farmers, namely the lack of understanding of farmers with natural conditions that can affect crop yields. So with the selection of plants that are not appropriate, it does not get satisfactory results. Various types of fruit crops can be cultivated by farmers, such as oranges, guava, rambutan, watermelon, avocado, and so on. But it should be noted, that in the cultivation is expected to be cultivated plants in accordance with natural circumstances. This Designing created application to help determine the cultivation of fruit crops. In determining the cultivation of fruit crops in accordance with the criteria using the Technique Method for Others Reference by Similarity to Ideal Solution (TOPSIS) as a tool to facilitate decision-making process with several criteria of comparison, namely: temperature, sunlight, rainfall and humidity, height, harvest, selling power, susceptibility to disease, and care levels. This application is made based on the web by using PHP as a programming language and MySQL as the data storage. The use of decision support system application of the cultivation of these fruit crops can provide an output or alternative in accordance with the natural state of the area. And helps in making decisions to determine which fruits are suitable for cultivating for users based on selected criteria.


Introduction
The pattern of life by always eating fruits every day is a healthy lifestyle.This is because the fruits contain a variety of vitamins, minerals, and fiber that is needed by the body.For example, oranges.In the citrus fruit contained vitamin C is very good for maintaining endurance.So it is very good to be consumed every day.
Besides the purchase price of fruits that are affordable by consumers, cultivating fruits is also very promising for farmers.With proper cultivation and consideration of the natural state (temperature, sunlight, rainfall and humidity, altitude), harvesting, selling power, susceptibility to disease, and the level of care required, with appropriate action, it will most likely result in satisfying.But there are problems faced by farmers, namely the lack of understanding of farmers with natural conditions that can affect crop yields.So with the selection of plants that do not fit, then do not get optimal results.
Various types of fruit crops can be cultivated by farmers, such as oranges, guava, rambutan, watermelon, avocado, and so on.It should be noted, however, that in the cultivation it is expected that the crops will be cultivated in accordance with the natural conditions, such as temperature, sunlight, rainfall and humidity, and the altitude in West Pasaman Regency.
And also need support criteria, such as easy maintenance, long harvest, high selling power, and free from disease.
With the use of computer technology, then this can help users / farmers in choosing plants in accordance with the above-mentioned considerations contained in the area.The term system is mentioned with Decision Support System (Decision Support System), which is a system that can assist users in making decisions on what plants are suitable cultivated.How to use the system is designed as easy as possible, ie after the user to register, then the next user can log into his account.Furthermore, the user simply select the name of the fruits that can be compared by the user to get the highest or the best value by using the Technique Method For Others Reference by Similarity to Ideal Solution (TOPSIS).The results of the assessment process are recommended to users based on the highest score.So by making the right decision through the utilization of the system, it is expected that farmers will get maximum and optimal cultivation results.
TOPSIS method is one of the methods used to solve the problem of Multi Attribute Decision Making (MADM).This method is based on the concept that the best chosen alternative not only has the shortest distance from the positive solution, but also has the longest distance from the ideal solution.The TOPSIS method has advantages, including simple and easy-to-MATEC Web of Conferences 215, 01006 (2018) https://doi.org/10.1051/matecconf/201821501006ICTIS 2018 understand concepts, efficient computing that produces precise calculations with computers, and has the ability to measure the relative (non-fixed) performance of alternatives or multiple decision options in simple mathematical form.

Decision Support system
Decision support systems are defined as a system intended to support managerial decision-makers in certain situations.Decision support systems are meant to be a tool for decision-makers to expand their capabilities, but not to replace their judgments.
Decision support system is an interactive computer-based system that helps decision makers utilize data and models to solve unstructured problems.There are several reasons for the use of Decision Support Systems, which are the unstable economic conditions, increased competition in the business world, the need for accurate new information, timely provision of information and efforts to reduce operating costs.
In addition, another reason in the development of Decision Support Systems is the change in end-user computing behavior, end-users are not programmers, so they need tools and procedures that are easy to use (Turban, 2005).

Technique For Others Reference by Similarity to Ideal Solution (TOPSIS) Method
The TOPSIS method is one of the methods used to solve MADM problems.The TOPSIS method is based on the concept that the best chosen alternative not only has the shortest distance from the ideal ideal solution, but also has the longest distance from the ideal solution.This concept is widely used in some MADM models to solve practical decision problems.This is because the concept is simple and easy to understand, computing efficient, and has the ability to measure the relative performance of decision alternatives in a simple mathematical form.
In general, TOPSIS procedure follows the following steps : (1) Make a normalized decision matrix.Topsis requires a rating on every criterion or subcriteria that is normalized.The normalized matrix is formed from the equation below : Description : rij is the normalized value of each alternative (i) to criterion (j) with i = 1,2, ..., m; and j = 1,2, ..., n.Xij is the value of an alternative (i) to criterion (j) with i = 1,2, .., m; and j = 1,2, ...n.
After calculating the normalized value, the next step is to calculate the weighted normalization value by multiplying the value in each alternative of the normalized matrix by the weights given by the decision maker.The equations in use are : Description : yij is a weighted normalized value wi is the weight of each criterion rij is the normalized value of each alternative where rij is the normalization value of each alternative (i) against criterion (j) with i = 1,2, ..., m; and j = 1,2, ..., n.

Symbol Description:
The positive Ideal solution (A + ) is obtained by finding the maximum value of the weighted normalization value (yij) if the attribute is a gain attribute and searching for the minimum value of the weighted normalization value (yij) if the attribute is the cost attribute.
The negative Ideal solution (A -) is obtained by searching for the minimum value of the weighted normalization value (yij) if the attribute is the profit attribute and the maximum value of the weighted normalization value (yij) if the attribute is the cost attribute.The distance between alternatives Ai with the positive ideal solution (yj + ) expressed in the Di + symbol is derived from the root value of the total value of each alternative obtained with the positive ideal solution (yi + ) minus the weighted normalization values for each latern (yij) then in the second.
The distance between alternatives Ai with the positive ideal solution (yj -) expressed in symbol (Di -) is derived from the root value of the sum of values of each alternative obtained with the weighted normalization value for each latern (yij) minus the positive ideal solution (yi -) then in the second power.
(5) Determine the value of proximity of each alternative to the ideal solution (preference).The value of Preferences for each alternative (Vi) as follows : .......... (7) Symbol Description: Vi (The value of preference for each alternative) is obtained from the value of the ideal ideal solution distance (Di -) divided by the total value of the ideal solution solution negative (Di -) plus the value of the ideal solution solution negative (Di + ).

Context Diagram
Context Diagram is a system design tool globally that shows the system in general and the parts of the sub system involved in the system as a whole, interconnection, and interaction between sub-systems.The relationship between some data in the database will be seen in the Entity Relational Diagram (ERD).ERD is a chart that describes for the means of database design, which consists of real objects.

Home Page
The home page is the first page that appears when users or visitors visit the website.On this page there are main menus, namely Home menu, About, List, and Login.This page view is shown in the following figure.

Registration Page
The registration page is the page used by the end user to register.Thus, after successful registration then he can just make the determination of fruits in accordance with the conditions of land in the district.This page view is shown in the following figure.

Login Page
The login page is the page that is used as the entrance by the end user or the application manager.Thus, only those who have been granted permission can enter next.This page view is shown in the following figure.The admin page is the page that displays the data of all the admin / managers who are granted permissions to manage the application.To access this page, it must be logged in as admin or operator.This page view is shown in the following figure.

User Pages
The user page is the page that displays all user data that has been registered.There displayed username, name, address, and registration date.This page view is shown in the following figure.

Fruit Pages
The fruits page is a page that is used to display a selection of fruits that can later be compared by the user, thus displaying the best option for the user based on the state of the land in the district.This page view is shown in the following figure.

Assessment Page
An assessment page is a page that can be used by users who need advice / recommendations and as decision support in the determination of cultivation of fruit crops.Users simply choose the name of the fruits that are felt in accordance with his wishes.Then press the Process button, to start the judgment.This page view is shown in the following figure.

Calculation of TOPSIS Method
The following is an example of a case solved using the TOPSIS Method.
(1) A farmer in Pasaman wants to cultivate fruits that match the weather conditions in the area.(2) Assessment   To obtain a normalized matrix, it can use the following formula.For example, to obtain a normalized matrix value for Oranges in Criterion 1 (temperature).
Thus, the normalized matrix values for Oranges in Criterion 1 (temperature) were 0.26 as shown in Table 4.To obtain a normalized weighted, it can use the following formula.For example, to obtain a weighted normalized value for Oranges in Criterion 1 (temperature) with a weight of 15%.Thus, the weighted normalized values for Citrus in Criterion 1 (temperature) x with a weight of 15% are 0.04, as shown in Table 5.Thus, the value of a positive ideal solution for Oranges in Criterion 1 (temperature) was 0.077032, as seen in Table 7.Thus, the preference value for Orange is 0.715375293, as in Table 10.

( 3 )
Identify positive ideal solutions and ideal negative solutions.Positive ideal solutions and negative ideal solutions can be calculated based on the weighted normalization values as follows: ,2, … .

Figure 5
Figure 5: Login Page 1.8 Admin PageThe admin page is the page that displays the data of all the admin / managers who are granted permissions to manage the application.To access this page, it must be logged in as admin or operator.This page view is shown in the following figure.

Figure 8 :
Figure 8: Criteria Pages .1.11Fruit PagesThe fruits page is a page that is used to display a selection of fruits that can later be compared by the user, thus displaying the best option for the user based on the state of the land in the district.This page view is shown in the following figure.

Figure 10 :
Figure 10: Assessment Page The results of the assessment and suggestions for the best fruits are shown in the following figure.

Figure 11 :
Figure 11: Assessment Result Page1.13History PageA history page is a page that shows all the results of decision support processes or suggestions received by users based on the fruits they choose.This page view is shown in the following figure.

Figure
Figure 12: History Page

3 ( 3 )
Give the weight of each criterion

( 7 )
Search for D + and D -any alternativesTo obtain a positive ideal solution, then can use the following formula.For example, to get the value of Orange in Criterion 1 (temperature).

( 8 )
Search for V / resultsTo get a preference value, then can use the following formula.For example, to get the value of Orange .

Table 3 :
Roots result per rank

Table 5 :
Normalized weighted table

Table 6 :
Max and min values

Table 7 :
D + Value N o .

Table 10 :
Final Result