CHAPTER 1 Research Description A. Overview of the Current State of the Technology Nowadays, businesses are using online and Short Message Service (SMS) systems to automate transactions. It enables the customers to access information. Thus it is observable that businesses are dependent on the current high-technologies to improve their operations. Joan, Dec Robertson, Nathalie, Samantha (JDNS) Company is a cooperative company where the best fresh high quality prawns are sold. Its head office is located in Cebu City. One of its seven branches nationwide is located in Manabay, Ozamiz City.
It is owned by Joan, Dec Robertson, Nathalie and Samantha. With the company’s current system, transactions are done manually, specifically their ordering system. They only sell their products in their branch office. This implies that customers who would like to inquire and buy their products should personally visit the company’s branch office. The researchers made this system for the company to have an efficient way to handle transactions, specifically the ordering system. With the proposed system, a customer can order the company’s product anytime, anywhere.
The researchers will propose this system to JDNS Company to be able to help improve the company’s efficiency in terms of handling transactions, specifically their ordering system. Moreover, since the system is through online and through SMS, the prospective customers of the company will increase. Thus, the system can contribute to the increase of the sales of their products. B. Research Objectives The general objective of our study is to create an efficient Prawn Ordering system in JDNS Company. It specifically aims to: 1. Advertise easily; 2.
Provide a faster response on inquiry about the available products; 3. Provide an exact calculation of payments; 4. Eliminate manual process of monitoring orders; and 5. Develop an Ordering Prawn system via online and through SMS. C. Scope and Delimitations The researchers study is limited only on the online and via SMS services of the JDNS Company. More particularly on the online promotion and ordering of their products. The customer can register and make orders online and via SMS. The study specifically covers and focuses on the Online Ordering process of JDNS Company.
The payment would be through payment before delivery which helps promote the company’s way in rendering services that can gain more customers. It will also minimize the workload of the company that consumes the effort and time in terms of business transactions. Payment through G-Cash/Smart Money is not included in our system. All other transactions not mentioned above are not included in the study. D. Significance of the Research The research project is beneficial to the following: 1. Customer The customers can automatically book orders of products the company is offering.
This will lessen the workload of the customers more particularly those customers who are far from the city because they can save time and money as compared to the manual process. 2. Company There will be a significant improvement of the company’s efficiency in catering the orders of the customers. With the online and via SMS system, the market of the company will increase, which could mean an increase of their sales. 3. Future Researchers The research will serve as a literature to future researchers who are conducting a similar study. E. Operational Definition of Terms ? Short Message Service.
Is a text message to be sent from one cell phone to another cell phone? ? System. Is for the company to have an efficient way to handle transactions specifically the ordering system. ? JDNS. Joan, Dec Robertson, Nathalie, Samantha (JDNS) Company is a cooperative company where the best fresh high quality prawns are sold. CHAPTER 2 REVIEW OF RELATED LITERATURE Online ordering for restaurant of FoodJr is an online ordering that gives restaurants the ability to increase sales and expand their business by giving customers the ability to order online, and by providing restaurants with a professionally designed web site.
New customers are required to register to have access on the account especially in updating records or searching online. In accessing as a new site, customers will secure a E-mail address and Password which they can used it. They use online to easy to advice there product and to increase there customer though online. (www. foodjr. com, 2006) The researchers felt that this type of system is applicable to our proposed system and has the same concept in terms of ordering online which requires registering first before ordering.
The current transactions of JDNS Company are done manually: they only sell and advertise their products in their branch office, other customers who are far from them cannot inquire available products and customers should personally visit their branch office. Papa John’s Short Message Service (SMS) Information Center made ordering hot and fresh Papa John’s pizza easier than ever with their convenient text messaging options. They offer special and more all through the convenience of text messaging. If you are a new customer, you need to visit first the papajohn’s site.
All text ordering must be placed from the mobile number associated to its online account. To add a mobile telephone number to the online customer account, see the Add Your Mobile Number to Your Online Account. Set up at least one preset Favorite associated to the customer online account at papajohn’s site. A Favorite is a preset order saved to the customers account, complete with any combination of pizza, sides and drinks, as well as its delivery address or carry out information and payment type.
The customer can save up to 4 preset Favorites for easy ordering. If a customer has an online customer account, he/she needs to update his/her account to enable text ordering. (www. papajohns. com, 2005) The researchers appreciate their system because it has the same concept with their study. They place order through online as well as via SMS. It promotes their products online and via SMS which helps manages their customers’ orders and cash on delivery services while the JDNS Company’s current system is being left behind by the new trends.
Papa John’s Short Message Service (SMS) Information Center is one of those companies who have updated systems. Online ordering for restaurant of E-bay is an online ordering that gives shopping center the ability to increase sales and expand their business by giving customers the ability to order online, and by providing shopping center with a professionally designed web site. It has the following functions: registration of the customer before they order, a customer will be setting up a UserID and Password that only the customer can use. (www. ebay. com. 2003)
As compared to our proposed system, Online Ordering for restaurant of E-bay is very much applicable to our system because it has the ability to increase the sales and expand their business in which customers have the ability to order online. With that, the current system of JDNS Company which is done manually will improve in terms of business transactions. CHAPTER 3 RESEARCH METHODOLOGY Environment The study’s research location is situated at Manabay, Ozamiz City. Joan, Dec Robertson, Nathalie, Samantha (JDNS) Company is one of seven branches nationwide.
The major research of this study is the Joan, Dec Robertson, Nathalie, Samantha (JDNS) Company at Ozamiz City in which all the transaction they used are still on manual. From all those information gathered in different settings, the researchers now have an idea on how to deal with the proposed application system and where to start in developing such system. Respondents The respondents of the study is the manager of the JDNS Company in Ozamiz City as the interviewee & the 31 randomly chosen customers for the questionnaires.
The proponents had conducted an interview to the manager & a survey to the customer for the gathering of data and information. The Sloven’s formula below is used to get the number of respondents. [pic] Table 1 Total Population and Number of Respondents |Respondent |Total Population |Number of Respondents | |Applicants |36 |31 | Instrument The study used a structured survey questionnaire in gathering information from JDNS Company.
Moreover, a series of interviews were conducted with the JDNS Company, Smart Business Center and Globe Business Center. A questionnaire was also disseminated to the employee of JDNS Company and customers. The questions in the questionnaire and the interview depict the problem of the Customers and Company. See appendix B and D for the questionnaire sample and the interview guide questions. Procedure The researchers secured permission to conduct the study from the manager of the company. The following are the phases that the researchers have undergone in conducting the study. Gathering of Data
The researchers have gathered information through interviews. In conducting the interview using the guide questionnaire (See in Appendix B), the researchers asked the permission of the Dean of the College of Computer Studies to interview the manager of JDNS Company, Globe Business Center and Smart Business Center. The researchers asked questions that are related to their system. In administering the interview the researchers also provided a guide questionnaire. Aside from interviewing the researchers also gave orally to the manager to ensure the clarity of understanding the proposed system.
The results were interpreted by weighing the data according to the total numbers of responses in the following ordinal scale: (1) Always (2) Often (3) Sometimes (4) Seldom (5) Never Analysis of Data The gathered data were analyzed and further studied by the researchers and incorporated to it the proposed system. Treatment of Data The researchers were able to analyze the data being gathered, where in the researchers classify the problem that is present in the ordering process. Below is the formula in getting the range value of each category:
After application of the above formula, the range of each qualitative category was determined. This is useful for the interpreting the average survey result easily. Below shows the qualitative category with corresponding range: Table 2 Treatment of Data |Qualitative Category |Range | |(5)Always |5. 00 – 4. 3 | |(4)Often |4. – 3. 67 | |(3)Sometimes |3. 66 – 2. 7 | |(2)Seldom |2. 6 – 1. 9 | |(1)Never |1. 8 – 1. 00 | After the survey results were tallied, researchers derived its average range value.
The average range was obtained by dividing the sum of all tallied values in each qualitative category and its corresponding tallied values with sample size. Findings The survey result shows that the customers experience problems in the present situation. The situation demands for a concrete reaction to solve the current problems. Below is the survey result of each of the category Table 3 Survey Result |Questions |Weighted Mean |Interpretation | |1. Consumed more time in going to the branch office to inquire and order |3. 72 |Often | |fresh prawns. | | | |2) I experienced that orders are being junk because of lack of information. |2. 51 |Seldom | |3) I experienced queuing in ordering and buying fresh prawns. |3. 42 |Sometimes | |4) I prefer to have the online prawn ordering system to have a fast and easy |4. 6 |Always | |to order. | | |5) I want to have a convenient way of ordering fresh prawns anytime and |4. 82 |Always | |anywhere as long as there is an internet. | | | |6) Most of the time, I thought of having online prawn ordering system. |4. 34 |Often | |7) An online prawn ordering system may help me in accessing the internet in a |4. 65 |Always | |convenient way. | | | | | | | |28. 06 | | |Total | | | As seen in the table 3 survey result the customer was interpreted the results as “always” because the weighted mean are above 4. 6. There are 3. 2 customer had consumed more time in going to the branch office to inquire and order fresh prawns, 2. 51 had experienced that orders are being junk because of lack information, 3. 42 had experienced queuing in ordering and buying fresh prawns, 4. 6 prefer to have the online prawn ordering system to have a fast and easy to order, 4. 82 wants to have a convenient way of ordering fresh prawns anytime and anywhere as long as there is an internet, 4. 34 thought of having online prawn ordering system and 4. 65 online prawn ordering system may help me in accessing the internet in a convenient way.
After the results, the researchers found out that an JDNS Company should be online and SMS so that the customers could not consume a time in ordering the products. CHAPTER 4 THEORETICAL FRAMEWORK Structured Query Language The name Structured Query Language (SQL) is far more than a query tool, although that was its original purpose, and retrieving of data is still one of its most important functions. Furthermore, SQL is used to control all of the functions that a Database Management System provides for its users, including: • Data definition.
SQL lets a user define the structure and organization of the stored data and relationship s among the stored data items. • Data retrieval. SQL allows a user or an application program to retrieve stored data from the database and use it. • Data manipulation. SQL allows a user or an application program to update the database by adding new data, removing old data, and modifying previously stored data. • Access control. SQL can be used to restrict a user’s ability to retrieve, add, and modify data, protecting stored data against unauthorized access.
SQL is thus a comprehensive language for controlling and interacting with a database management system. SQL has emerged as the standard language for using relational databases. SQL is both a powerful language and one that is relatively easy to learn. (Weinberg, 2004). In relation to the study, SQL will be use in retrieving the data, it will be use in restricting a user to retrieve, add and modify data. It will be use to protect the stored data. Apache is primarily used both static content and dynamic Web pages on the World Wide Web. Many web applications are designed expecting the environment and features that Apache provides.
Apache is the web server component of the popular XAMPP web server application stack, alongside MySQL, and the PHP programming languages. The Apache is relevant to the study since it allows searching of products. Hypertext Preprocessor (PHP) is a general-purpose scripting language that is especially suited for web development. In this study, PHP is the primary language being used. PHP runs on a web server, taking PHP code as its input and creating web pages as output. PHP is deployed on web servers, operating systems and platforms, and used with relational database management systems in which in this study is MySQL.
In an JDNS Company, PHP primarily acts as a filter, taking input from a file or stream containing text and/or PHP instructions and outputs another stream of data; most commonly the output will be HTML. It can then automatically detect the language of the user. CHAPTER 5 Prawn Ordering System of Joan, Dec Robertson, Nathalie, Samantha (JDNS) Company System Overview The Prawn Ordering System of Joan, Dec Robertson, Nathalie, Samantha (JDNS) Company facilitates immediate access to product information and handling of online ordering process, advertising and payment via SMS and through cash on delivery.
The system will perform online functions such as customer registration, make order and display product information. Search and update customer profiles is also needed in the system. In this way, the system reduces monitoring effort of the company through the coordination of an authorized personnel in the retrieving of product records, flexibility and manageability of customer’s accounts and information, as well as the security through customer’s and administrator’s accounts and password in order for the customer and administrator to access the authorized pages.
It will also perform SMS function such as registration and confirmation of payments and make order. In ordering prawns online and via SMS, the customer should register first until such he/she completed the registration. All the information of the customer are included in the registration such as their username, password, full name, address, contact number and e-mail address. The customer will receive a confirmation from the company of his/her registration. After its confirmation, as the customer received the available products that the company is selling, the customer is free to order which products he/she would like to.
The payment would be through payment before delivery. System Objectives The research aims to design and develop an Ordering System website for the JDNS Company- Prawn Ordering System It specifically seeks to: 1. Create a database; 2. Create reports for the administrator; 3. Provide a calculation process; 4. Provide a payment confirmation through online and SMS; and 5. Create a user-friendly-interface; Scope and Delimitation of the System The scope of the Prawn Ordering System focuses on ordering services of prawn in JDNS Company into an online. The system access is limited to an authorized administrator or the customer only.
The system covers the submission of online and advertising. The calculation of the total price of the orders is part of the online process only. Things not mention above are not part of our study. Context Diagram Figure 1 2 Context Diagram Figure 1, shows the customer gives all the information to register and get an account to access the system. The system will give all the list of products to be ordered from the customer’s. The administrator will update all the products and reports from the customer’s and the system will also give the list of orders that was ordered from the customer’s.
D1 Admin D2 Order D3 Product URL Address Admin Homepage View Orders Homepage Maintenance Log Out Figure 2, shows it contains the main module of the system. The administrator will enter URL address and the homepage will be displayed. The admin will log in using the correct password and username.
The username and password will be verified in the database (Admin). Afterwards, the admin homepage will now display. The admin will select Orders to view the new order of the customer’s. The new order will be saved in the database Order. And the administrators have the Maintenance to add, delete and update the new or old products. Log out link is also provided. Data Flow Diagram URL Address Homepage log in form D1 Admin Figure 3, shows through URL address, the homepage will be display.
The log in link can be found in the homepage. The admin will enter the username and password, it will verify in the table (Admin). The correct password and username will be the key to access the admin homepage. . Figure 4, shows the admin will enter the URL address to access the system, he will log -in in the system using the correct username and password. Then the administrator homepage will display. D1 Orders Figure 5, shows the admin will enter the URL address to access the system, he will log -in in the system using the correct username and password. The administrator homepage will display.
Administrator will select from the menu. Then it will display all the new orders of the customer. The administrator will print the orders of the customer. D1 Products Figure 6, shows the admin will enter the URL address to access the system, he will log -in in the system using the correct username and password. The administrator homepage will display. The administrator select from the menu, then admin click Products and it will display the list of all products. The administrator can Add, Delete and Update a products then it will save to the database on table (Product).
After Adding, Deleting and updating the product the next will accept the product. Figure 7, shows the URL address well be inputted and the homepage will now be display. A log out link is provided to secure the accounts. After selecting the log out menu the main page will be display. Figure 8, shows the URL address will be inputted and the customer homepage will now be display. The customer will register through Online and SMS. And it will save to the database table (Customer). After the customer registered on online he/she can log in through the used of his username and password.
It will display the customer homepage. The customer can make their orders though clicking the picture and entering the kilos. The customer that registered on SMS, after receiving the information through SMS the customer can order by text ting the name of the product and number of kilos to order. The customer’s that is online will view the products if there is new or available. They have also a security for their account they can change the username and password of their account. Log out link is also provided. D1 Customer . Figure 9, shows the customer will enter the URL address.
The customer homepage of the system will be display. The customer will click registration to enter all the information needed to register. Then save to the database table (Customer). The customer registration will be validated. Figure 10, shows the customers send personal information. Then customers Registration received and saves on the database table (Customer). The administrator will check the registration of the customer from the database table (Customer). Then the admin send a notifications for the customer and it will be save to the database table (Customer).
The customer received a notification for the registration from the admin. URL Address Homepage log in form D1 Customer Figure 11, shows through URL address, the homepage will be display. The log in link can be found in the homepage. The customer will enter the username and password, it will verify in the table (Customer). The correct password and username will be the key to access the customer homepage. . ` Figure 12, shows through URL address, the customer homepage will be display. The log in link can be found in the homepage.
The customer will enter the username and password; the customer order form will be display. The database table (Product) will display the products. The customer will enter the number of kilos to be order. The system will automatically computes the total amount of the customer and save to the database table (Order). Then accept the list of order from the customer. After computing the total amount the customers send the orders. V Figure 13, shows the customers will send a SMS order. The customer orders received and automatically save to the database table (Order).
The system will read the database of the other system then administrator check the customer orders. After checking the customer orders. The admin will send a bill for the customers. Figure 14, shows through URL address, the customer homepage will be display. The log in link can be found in the homepage. The customer will enter the username and password. The customer select form menu then it will display product form. The different product and information will be display. Figure 15 shows through URL address, the customer homepage will be display. The log in link can be found in the homepage.
The customer will enter the username and password. Customer select from menu then click Username & Password it display the form. The customer will edit the username & password for the secure of his/her account. Then verified the account user if it is verified the customer will save his/her account to the database table (Customer). Figure 16, It shows the connections of the database in the functionality of the system. Customer table connects to the order table because customer table use order table to access the system and place the order of the customer.
While admin table is connected to the order table because admin can manage the order of the customer and order table connected by the product table and payment table because the products and payment of the customer will be base from the order. As seen in Figure 17 (Admin side) the admin will enter the username and password to the log in form to view the admin homepage. The username and password will be validated in the table Admin. Afterwards, the admin homepage will be displayed where he can select application to the main form.
The admin verified all the registration form of the Online and SMS customer. All the registration form will save in the table Customer. The admin will update the orders of the customer though clicking the order form. After viewing the order and payment of the customer, the admin will save in the table of Order and Payment. He can add and delete products that will be saved in the table Product, by opening the form products. The admin will print all the orders or transaction that made by the customer, a log out link is provided to secure the page, and the user will be led to the main page of the system.
As seen in Figure 18 (Customer – Online – side) the customer will enter the username and password to the log in form to view the admin homepage. The username and password will be validated in the table Customer. Afterwards, the customer homepage will be displayed where he can select the application to the main form. The customer orders for the product though clicking the picture and entering the number of kilos to be order, by clicking order form. The order will be saving in the table Order. The product will be view by clicking the product form, were the information of the product can be see.
The changing of username and password will be done by clicking the username and password. This is the user change their account for their security in their account. After editing the username and password the user will save in the table Customer. Searching for products this were the customer see for the information of the product, a log out link is provided to secure the page, and the user will be led to the main page of the system. As seen in Figure 19 (Customer – SMS – side) the customer will just send is personal information for registration and save in the table Customer.
After finishing the registration the customer can order though the used of SMS. The customer will send order and accept order message this will be saved in the table Order. Then the admin will send customer bills for their payment. [pic] [pic] 3 [pic] Module name: Webpage Browsing Input: URL Address Process: If URL Address = URL then Display Webpage Else Display error message End If Output: Homepage 4 [pic] 5 6 Figure 22 7 8 Homepage Module name: Main Page Browsing Input: Homepage, Product, Services, Contact Us. links Process: If Product. link = true then Display Product. page Else If Orders. link = true then
Display Orders. page Else If About US. link = true then Display About Us. page Else If Contact Us. link = true then Display Contact Us. page Else If Prawns Us. link = true then Display Prawns Us. page End If Output: Home page [pic] Figure 23 View Products Module name: Product Viewing Input: Product Link Process: Connect ot Prawn (database) Open Product (table) If Product Code Button = Product Code Then Display Product and Information. Page Else Display Error Message End If Output: Products page [pic] Module name: Customer Login Input: Username & Password Process: Connect to Prawn (database) Open log in (table)
If txtUsername. text = Null or txtPassword. text = Null then Display Error Message Else If txtUsername. text = username and txtPassword. text = password then Display Customer. page Else Display Error Message End If Output: Customer Homepage [pic] Module name: Registration Input: Username, Password, Firstname, Middlename, Lastname, Street, City, Municipal, Cellphonenumber, Emailaddress, Register button Process: Connect to jdnsDB (database) Open Customer (table) If txtUsername. text = Null then Display Error Message Else If txtUsername. text = Username then Save Record to: jdnsDB (database)
Display Confirmation Message Else If txtUsername Username then Display Error Message End If Output: Confirmation Message – Successfully Registered [pic] Module name: information of Prawns Input: Prawns Link Process: If Prawns link. button = true then Display Prawn Information. page Else IF Home. button = true then Display Previous Web Page End If Output: Prawns page [pic] Figure 27 Order Module name: Order Input: Kilograms, Product Link, Send button Process: Open Order (table) from Prawn (database) where CustomerID = CustomerID If small. button = true then txtSkilos. enabled = true Else If medium. utton = true then txtMkilos. enabled = true then txtMkilos. enabled = true Else If large. button = true then txtLkilos. enabled = true End If If send. button = true then Save rescord in Order (table) Display Confirmation Message End If Output: Confirmation Message – Successfully Ordered [pic] Contact Us Module name: Contact Us Input: Contact Us Links Process: If Contact. button = true Then Display Contact Us. page Else If Home. button = true then Display Home. page End If Output: Contact us page [pic] Module name: Add Product Input: Browse picture and enter new price for Small, Medium, Large, add button
Process: Open Product (table) from jdnsDB (database) If txtPsmall = Null and txtPmedium = Null and txtPlarge = Null then Display Error Message Else If Product Code Product Code then Save record in jdnsDB (database) where Username = Username Display Confirmation Message Else If Product Code = Product Code then Display Error massage End If End If Output: Confirmation Message – Product Added [pic] Module name: Delete Product Input: Select Product Process: Open Product (table) from jdnsDB (database) If Product Code = product Code then Delete record in jdnsDB (database) Display Confirmation Message
Else Display Error Message End If Output: Confirmation Message – Product has been remove [pic] Module name: Update Product Input: Enter a Description, Price, Size, Product Image, Browse Picture, Product name, Process: Open Product (table )from jdnsDB (database) If Product Code = Product Code then Update record in Prawn (database) Display Confirmation Message Else Display Error message End If Output: Confirmation Message – Product has been Updated [pic] Module name: View Orders Input: View Orders Links Process: If Order. button = true Then Display list of order. page
Output: Contact us page [pic] Module name: Administrator Login Input: Username and Password Process: Open login (table) from jdnsDB (database) If txtUsername. text = NULL or txtPassword. text = NULL Display Admin homepage Else If txtUsername. text = username and txtPassword. txt = password then Display Confirmation Message Else If txtusername. text username or txtPassword. text password then Display Error Massage End If Output: Administrator Homepage Calendar of Activities Gantt Chart Table 4. 0 CALENDAR OF ACTIVITIES | | | | | | | | |Activities |Predecessor |Person Responsible |Time Frame |Expected Output |Remarks | |Software Requirements Analysis | | | | | | |A.
Initial Interview |None |Labadesos, Raval |1 week (Jan |able to meet the personnel |Completed | |Conduct interview | | |7-13) |of the company | | |B.
Gathering of Data |A |Raval, Labadesos, |1 week (Jan |able to gather information |Completed | |Collect data | |Medalle |14-21) |through Interview and | | |Analyze data | | | |Survey | | |C.
Statement of the Problem |B |Raval, Labadesos |1 week ( Jan |able to identify company’s |Completed | |Identify the problem | | |2-Jan 8) |problem and come up with a | | | | | | |title | | |D.
Title Hearing and Defend |B,C |Raval, Labadesos, Medalle |1 week |Defended the title and |Completed | |Title Proposal | | |March 4-10) |approved by the panel list | | |Title Defend | | | | | | |E.
Documentation |D |Raval, Labadesos, | 13weeks |Meet with the thesis | On the process | |Documenting for chapter 1,2,3,4 &5 | |Medalle |(June 23-Sept. 19) |adviser and revise period | | |revision for chapter 1,2,3,4 &5 | | | |Time | | Gantt chart G A N T T C H A R T | | | 9 Figure 34 Ghantt chart 2 ———————– P3 Orders Figure 2 Diagram 0 – Administrator Administrator P5 Logout P1 Log in P2 Display Admin Homepage Administrator P4 Maintenance PO Prawn Ordering System List of Orders Customer’s information Administrator Customer Update Products List of Products P1. 1 Display Homepage P1. 2 Display Log in form P1. 3 Accept Username & Password Administrator P1. 4 Validate the Username & Password
Username & Password Validated Log in Admin Homepage P1. 5 Admin Homepage Administrator Figure 3 Login- Admin URL Address Admin Homepage P2. 1 Display Homepage Administrator Administrator Figure 4 Display Admin Home Page Admin homepage Administrator P3. 1 Display Admin Homepage List of all Orders URL Address P3. 2 Display Orders P3. 3 Display all the list of orders Display all Orders Print Orders P3. 4 Print all Orders Administrator Figure 5 Orders List of Products URL Address Admin homepage P4. 1 Display Admin Homepage Administrator P4. 2 Display Product form P4. 3 Add/Delete/Update products
Add/Delete/Update Products P4. 4 Accepted Add/update products Product Accepted Administrator Figure 6 Add Product Log out Link URL Address Homepage Administrator P5. 2 Display Log out menu P5. 1 Display Admin Homepage P5. 3 Permit Log out Homepage Administrator Figure 7 Log Out D1 Customer Registered Customer Customer Homepage URL Address P1 Register P2 Log in P3 Orders Customer SMS SMS Orders Change Username& Password Customer Orders View Products Log out P6 Log Out P4 View Products P5 Maintenance Customer Figure 8 Diagram 0 – Customer Homepage Registration form P1. 1. 1 Display Customer Homepage
URL Address P1. 1. 2 Display Registration form P1. 1. 3 Enter customer Information and save Customer Registration validated txtMunicipal Figure 28 Customer Figure 9 Registration-Online Save SMS registration Customer Check SMS information Customer Information P1. 2. 1 Received and save customer s SMS information P1. 2. 2 Check registration P1. 2. 3 Send customer notification and save Customer notification OrderDate Architectural Design Customer D3` Customer Figure 10 Registration-SMS Home button large medium small Figure 11 Login- Customer Administrator P2. 5 Customer Homepage Validated Log in Customer
Homepage Username & Password P2. 4 Validate the Username & Password Customer P2. 3 Accept Username & Password P2. 2 Display Log in form P2. 1 Display Homepage Product D1 Check list of Orders Customer P3. 1. 1 Display customer Homepage P3. 1. 2 Display Order form Homepage P3. 1. 3 Accept order list of products URL Address Has Send Orders P3. 1. 4 Compute the total amount of orders and save Total amount P3. 1. 5 Send orders Customer Order D2 Figure 12 Makes Order – Online Order D3 Order D2 Order D1 Customer orders Check orders Customer’s bill P3. 2. 1 Received and save SMS orders Customer SMS order P3. 2. 2
Check customer orders P3. 2. 3 Send customer bills Customer Customer Figure 13 Makes Order – SMS Select menu Homepage URL Address P4. 1 Display customer homepage P4. 2 Select from menu P4. 3 Display Product form Customers Product form Display page P4. 4 Display different products and information Customers txtCity txtStreet Figure 14 View Product Product Prod_Id: varchar (20) Prod_Description: varchar (25) Prod_Size: varchar (30) Prod_Price: int (30) Prod_Picture: varchar (25) Manage Ordered_Product Ordered_Id: int(20) Prod_Id: varchar(25) Kilos: int(5) Amount: int(10) Is basis for P5. 4 Verified User Account
Customer URL Address Display form Homepage P5. 1 Display customer homepage P5. 2 Display Username& Password form P5. 3 Edit Username & Password Edit Username & Password Figure 16 ERD (Entity Relationship Diagram) Log in Username: varchar (30) Password: varchar (30) Customer D1 Verified Account P5. 5 Save new Username & Password Save account Customer Figure 15 Maintenance URL address Figure 21 URL Address Figure 21 Hierarchical Input Process Output-Customer Prawns Login Contact US About Us Orders Product Homepage 2. 0 Prawn Ordering System URL Address 1. 0 Figure 20 Hierarchical Input Process Output-Admin
Login Payments Orders Customer Product Homepage 2. 0 Prawn Ordering System URL Address 1. 0 Figure 19 System Flowchart – SMS-Customer End Send customer bill Save Order Message Accept Order Message Orders Send SMS Order Registration Customer Send SMS customer information Start Figure 18 System Flowchart – Online-Customer End Log out Search for products Save new User account Change Username & Password Form Change Username & Password View for the products View Product Form Save for the orders Orders for products Orders Order Form Select Application Main Form Validate username & password Customer
Log-in Form Enter Username and Password Start Registration Figure 17 System Flowchart: Admin End Log out Printed Orders Products Add/Delete Products Products Payment Update orders and payment Orders Orders Customer Save all registration form Online and SMS Verified all the registration form Online and SMS Main Form Select Application Validate username & Password Admin Log-in Form Enter Username and Password Start Order Order_Id: int (20) Customer_ID: int (20) Cellphone#: int (20) Prod_Id: varchar (20) Order_date: varchr (20) Amount: Int (30) Status: varchar (20) Payment Payment_ID: int (11)
Customer ID: varhar(30) Order_Total_Price: Int (30) Payment_Date: varchar(20) Total_Price: varchar (30) Amount_Paid: varchar (30) Remarks: varchar (30) Places Entity Relationship Diagram Customer Customer_ID: varchar (10) Username: varchar (50) Password: varchar (30) Firstname: varchar (30) MI: varchar (5) Lastname: varchar (30) Street: varchar (50) City/Municipality: varchar (30) Zip Code: int(10) Cellphone #: int (20) EmailAddress: varchar (30) List of orders Include Customer D2 Customer D1 IPO (Input Process Output) Figure 24 Log in – Customer txtpassword txtusername P2. 2 Log in Form cmdRegister mdLogin Home button cmdRegister txtFirstName txtMiddleName txtLastName txtCellphoneNumber cmdCancel txtPassword txtEmailAddress cmdUpdate txtUserName Figure 25 Registration cmdCancel Figure 26 Prawns txtUsername cmdAdd txtPmedium txtPlarge txtPsmall cmdBrowsePicture Figure 29 Add Product txtProductName cmdDelete Figure 30 Delete Product cmdBrowse txtSize txtPrice txtDescription Figure 31 Update Product Figure 28 Figure 32 View Orders Figure 33 Log in – Admin cmdsend txtSkilos txtMkilos txtLkilos lbltotal txtPassword cmdSubmit Homepage P2. 3 Display Admin homepage Log in P5. 4 Display Main Homepage