Pekanbaru City Snack E-Commerce Application Design Based on Android

ABSTRACT


INTRODUCTION
Nowadays, technology development is very advanced.Almost all of people connected using internet.By using this technology, it can help people become more effective and efficient.Because today human become more productive, and then likes everything practical.
The business of buying and selling food is becoming a trend in all circles.It can be seen from many social media accounts selling foods by online or offline.As an example, so many social media account that selling foods, dessert, and drinks, using Instagram as a pioneer to promote their goods [1].The location of the food seller, which is sometimes far from the buyer's location, makes it difficult for buyers to buy the food.And sometimes, buyers don't know where the exact location of food sellers is.
Snacks in Pekanbaru are convently growing rapidly and can be found everywhere.Associated with technological developments and human needs, the idea come to create a snack application that aims to make it easier for consumers and sellers [2].Kenneth J. Laudon, Jane P. Laudon defined e-commerce as, "The process of buying and selling goods electronically by consumers and from company to company through computerized business transaction" [3].E-Commerce technology is a business mechanism which works electronically by focusing only online business transactions and has the opportunity to build more human and personalized relationship with customers [4].
From the background of these problems, through this research, author will develop an online snack application.The purpose from this research is to produce Pekanbaru City Snack E-Commerce Application Based on Android.

RESEARCH METHOD
In this research, author using literature study, interview, and observation for collecting data, analyze current system, and design a system using diagram to build an application using android technology.
Explaining research chronological, including research design, research procedure (in the form of algorithms, Pseudocode or other), how to test and data acquisition [1]- [3].The description of the course of research should be supported references, so the explanation can be accepted scientifically [2], [4].

Literature Study
By doing research in the library, looking for books, journals, and articles relate for this research.First journal is about creating an e-commerce app based on android for market snack.This research focused on how people troubled to find snacks in the market, because they sold in conventional way, or we must attend the market to buy snacks.The problem is, not every people know when seller start and stop selling snacks, what day, and where are they in the market.Using Customer Relationship Management (CRM) method, this research produces an e-commerce app for people who wants to buy snack and place an order online [5].Shortcomings of this study, we don't know when seller send snack, and there will be possibility that snack ordered is stale, because not all snacks can last long.
Next journal is research focused on how an e-commerce app based on android can helping self-help groups in the village of Margakaya Pringsewu, with the aim of monitoring the marketing of small and medium business product.This research using System Development Life-Cycle method for development [6].
The third one is about how an android application can help ordering some food.This research focuses on customer satisfaction.The more customer happy, more snacks they buy.Question is how we can make customer happy.To make customer happy, we must focus on service.Good service not only about the price, there's also so many aspects if we want to give good service.Information about food, availability, portion size, even calories contain in food.This can help people who on diet, or have any disease [7].
Next research article is about how to design and implementation e-commerce for online cloth store sales based on android [8].Based on whitebox method testing, customer satisfaction buy cloth using e-commerce application increase 70%.
This research also discusses how snack ordered can be sent to the customer who buy it, and ensure the snack ordered safely reaches its destination.Next article is about how to monitor the courier on the petshop.This research using websocket to provide real-time location information so that it can display location points [9].

Interview
Esterberg says about interview is, "a meeting of two persons to exchange information and idea through question and responses, resulting in communication and joint construction of meaning about a particular topic" [10].Author also doing an interview with sellers to get data for development and creating good quality service for customers.First question author always ask to seller is how good customers knowing this snack.This question is not about how it taste, but also price, location, even when customer can buy this snack.At first, sellers always answer customers knowing well about their goods, they can tell how and when to operate, or when they must close.But at some point, there is inconsistent from sellers, like place to selling their snack, how to give good portion, ingredients for snack, even price for snack.Because of this inconsistent, customer can't know their goods anymore, so author can draw conclusions, this inconsistent can lower customer satisfaction.
Next interview, author ask for how customers find snacks, which is this question is for customers.Most of them said, they find snack accidentally, in the way home, going for somewhere, and sometimes because they get bored, so they buy it randomly.But in some cases, to satisfy their desires, most of them can't find good snack.Is it due to inconsistent selling times, taste, or they cannot find at all, or when customers at some place they never been there before, and they want something to eat, but they can't find snack right for their condition?Even customers cannot describe what they want, like example they want something spicy, soup based, and right to eat in the afternoon.As Susan Stainback said, "Interviewing provide the researcher a means to gain a deeper understanding of how the participant interpret a situation or phenomenon than can be gained through observation alone" [11], author now understand how sellers feels about selling their goods, and how customer feels to find something good.

Observation
Susan Stainback said, "In participant observation, the researcher observes what people do, listen to what they say, and participates in their activities" [11].Author using this opportunity to observe how sellers prepare and selling their goods, and how customers find snacks, buying it, and how customers think about snack their buy.And also, Marhsal said, "Through observation, the researcher learn about behavior and the meaning attached to those behavior" [12].

Ongoing System Analysis
Before this snack e-commerce application designed, current process is start from sellers or customers visiting outlet and ordered snack want to buy by looking at the prices listed on the menu.Then customers pay their selected snack to the seller, and seller making a memorandum payment for customers, based on snack they ordered.For ongoing system analysis can be seen at figure 1.

Figure 1. Ongoing System Analysis
This system runs conventionally, and this system is fragile.The question is why this system is fragile, if more customers come, and sellers can't handle properly, it can cause chaos between sellers and buyers, and top of it all, it can decrease customer satisfaction.Remember, the more customer happy, the more money can be made.In this research, will be design system that can help several parties involved.Explained that a customer opens this application, and then choosing menu from outlet and snacks.After that, system will receive and calculate total order automatically.Customer will receive total order and get a courier to deliver foods.Last, seller will proceed preparing food that ordered, for next step will be send by courier which provide from application.

System Development
The difference between ongoing system and that developed is in ongoing system customers must find and locate where's seller, must know what time to visit seller, and there's time when customers can't describe and doesn't know what snack want to buy, or when customers at some place never been there, they don't know what good for them.In developed system, customers don't have to face all of it, even the application can describe what customers want based on customers profile.
While developing this system, author using data flow diagram, and entity relationship diagram design database.According to Andi Rahman, data flow diagram are used for describes the process of data flow occurs in the system from the highest level to the lowest, which makes it possible to divide the system into smaller and simpler parts [13].In this research, author using android platform to running application that has been developed.Android is a Linux based operating system, designed for mobile device like smartphone and tablet pc [14].Android is a operating system based linux for mobile device, covered operating system, middleware, and application.Smartphone that using operating system android, is more accepted in the community than smartphones that have an operating system other than android.

MySQL
Author using MySQL for database in this research.MySQL is a Database Management System SQL or as well known as DBMS (Database Management System) [14].According to Raharjo, MySQL is RDBMS software, which can manage database quickly, can accommodate large amount of data, can be accessed by multi-user, and it can perform a process synchronously or concurrently(multi-threaded) [15].

PHP
PHP is an interpreter programming.It means the process of translating a line of source code into machine code that computer understands directly when line of code is executed [16].PHP is called as server-side programming, this because all of process running on server, not on a client.
PHP is an open source language, it means users can develop PHP function code as their needs [17].

Implementation 1. Main Page
Main page is a main menu that have three options, which are snack order menu to viewed merchant and snacks, ordered menu to view snacks that had been ordered by customers, and history menu that contains information about order that had been ordered by customers.
Figure 3. Application Main Menu

Order Menu
This page viewed all snacks that sell using this application.In this menu, customers can choose snacks that they want, and after customers choosing merchant, it shows every snack that merchant sell.

Table 1 .
Application Blackbox Testing