Docstoc

Point of Sale System

Document Sample
Point of Sale System Powered By Docstoc
					Point of Sale System
With Remote Capabilities
          by Justin Dansby




            CPSC 463 SPRING 2004 Dr. Pargas
Introduction

• Design new Point of Sale System (POS)
  for Mellow Mushroom
• Current POS system ALOHA is limited in
  remote access
• Incorporate new functions
• Decrease time to access data
Problem Statement


• Current POS System does not allow an easy means of
  remote access
• Current POS tracks inventory by what is sold
• Use ASP.NET to create real-time database functionality
• Use ASP.NET to ease access to data
• Current POS System food database hard to maintain and
  requires a restart between changes
• Develop a new POS System that solves these problems
Tables Used

• All tables are in 3NF
• Kitchen Tickets Table – tick#, svrid, ourcost,
  salecost, food id, date sold
• Employee Tickets Table – tick#, svrid, tableid,
  date, description
• Clock Table – svrid, clock in time, clock out time
• Inventory – pizza id, quantity
Employee Functions


• Clock In/Clock Out
• View timesheet
• Open a new ticket
• Sell pizza
• Close ticket
• Open closed ticket
Manager Functions

• Obtain quantity, profit, and sales
  information remotely
• View employees currently working
• View inventory
• Update inventory
Technology Used

• C#, PHP, Perl, VB.NET
• ASP.NET Calendar control
• ASP.NET DataView, DataTable
• WML
• Login ties directly into Clemson network
• Web Service – SOAP, PHP, Perl
Login

      Netware
    Authentication




        Hogwarts     Web Space




        Client
Web Service

    Hogwarts Webservice               MS Sql Server




 Dirty Network PHP/Perl SOAP client                   Client
Future Work

• Increase WML functionality
• Increase Efficiency
• POS system will determine what supplies
  kitchen needs
• Add a drop down list of login names
Conclusions

 Spend more time seeing what is
  available before trying solution
 I learned a lot of SQL, WML, SOAP,
  PHP, C#, VB.NET, WebServices

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:18
posted:3/14/2012
language:English
pages:11