Skip to content

OmriGawi/Flower-Chain-Management-System

Repository files navigation

Contributors Forks Stargazers Issues LinkedIn


Logo

Zerli - A Flower Chain Management System


Explore the docs »

View Demo · Report Bug · Request Feature

Table of Contents
  1. About The Project
  2. Getting Started
  3. Usage
  4. Contributing
  5. Contact

About The Project

Zerli is a Client-Server application, multi-user, RDBMS system, used to manage a flower chain.

(back to top)

Tech Stack

Environment

(back to top)

Getting Started

Installation

  1. Make sure MySQL is installed properly and running at port 3306 with username 'root'

  2. Clone the repository:

    git clone https://github.com/OmriGawi/Flower-Chain-Management-System"
  3. Open MySQL Workbench and login to your root account

  4. Create a new schema named zerli

  5. From Server menu click Data Import

    1. Click on Import from Self-Contained File and navigate to ../Flower-Chain-Management-System/ and select zerli_final_db.sql file
    2. Select Default Target Schema as zerli
    3. Click on Start Import
  6. Navigate to ../Flower-Chain-Management-System/jar/

  7. Open CMD/Terminal and type: java -jar ZerliServer.jar

  8. Enter your password and click on Connect Button

  9. Open CMD/Terminal and type: java -jar ZerliClient.jar

  10. You're all set!

(back to top)

Usage

Here is a list of users with a different type of functionality:
Feel free to check any of them, they are unique!

User Type Username Password
Client client client
Company Marketing Worker cmw cmw
Ceo ceo ceo
Customer Service Worker csw csw
Store Manager sm sm
Delivery Man dm dm
Store Worker sw sw
Service Expert se se

Functionallity

  • Client: Create new orders
  • Company Marketing Worker: Edit catalog, Add new items, Remove items, Enable or Disable sales.
  • Ceo: View reports on all stores.
  • Customer Service Worker: Add new complaints, View complaints.
  • Store Manager: Approve & Cancel orders, View reports, Set permisions to users.
  • Delivery Man: Confirm arrival of oders to the destination.
  • Store Worker: Add Surveys
  • Service Expert: Add conclusions to the surveys.

Database Structure

Database

A little peek at how the project looks like, of course it contains a lot more functionality!

Server GUI: ServerGUI

Login:
Login

Here is the catalog, also a custom item can be added by the user Catalog

Auto generated reports (Income, Orders, Complaints) each month/quarter.
Used Quartz-Scheduler for implementation

reports

(back to top)

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!

  1. Fork the Project
  2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
  3. Commit your Changes (git commit -m 'Add some AmazingFeature')
  4. Push to the Branch (git push origin feature/AmazingFeature)
  5. Open a Pull Request

(back to top)

Collaborators

(back to top)

Contact

Project Link: https://github.com/OmriGawi/Flower-Chain-Management-System

(back to top)

About

Client-Server Application built with Java and MySQL

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published