Tag: jQuery

Posted on

Bookstore Management System PHP MySQL Project

Purpose of Project

The main purpose of a Book-store Management System is to focus on the solution of all the problems related to the paperwork for different reasons. It provides a facility to handle all the activities in one place. With the help of this application, the admin can perform a different kinds of operations at the same time and place. Bookstore management System has the ability to keep records safe related to Books.  We provide the best service on our website or focus on user choice. We will improve the new feat so users can easily understand and trust our system.

Project Background

  • This Bookstore Management System Software allows the Admin to store the book details and the customer details.
  • Easier access to information like customer information and
  • Provide a facility for storing data to reduce the paperwork.
  • In Bookstore Management System Users can buy a book and Admin shows their name and another background of the user.
  • A new idea about Project how Bookstore Management System works.
  • To make a system computerized.

Scope of Project

  • The intentions of the Bookstore Management System are to reduce overtime pay and increase the number of records that can be treated accurately; Requirements statements in this document are both functional and non-functional.
  • Correct and Accurate Searching provides the result by applying the search operation.
  • Customers can book a book with just a few clicks.
  • Give flexibility to admin to use the database effectively and utilize the word, not pad, and calculator Unambiguous and understandable by all level facilities effectively.
  • Unambiguous and understandable at all levels.

Applicability of Project:

  • For customers who want to buy books anywhere or anytime.
  • Admin is applicable for insert books, list of books.
  • The database is used for storing and fetching data from or to the database so both users and admin can fetch or read data.

Requirement Specification

As per the Bookstore Management System Requirements, it contains two (2) Modules:

1)  Admin

2)  Client

Functionalities of Admin:

  • This Module includes the mainly following tasks:
    • Entry of Category.
    • Category List.
    • Add a New Book.
    • View Book.
    • View Message which Sends by Client.

Functionalities of Client:

  • This Module includes the mainly following tasks:
    • View Books.
    • Add books to Cart.
    • Search Books.
    • View or Add items to Cart.

Hardware requirement

  • System type 32-bit Operating System.
  • Windows 7/8/8.1/10
  • Linux  Ubuntu / Light ubuntu
  • Mac OS
  • 350MB RAM

Software Requirement

  • Wamp Server
  • MySQL
  • Browser
  • PHPMyAdmin

Project Analysis and Planning

The Bookstore Management System is critical to set up online orders, for customers to browse through book categories. This is a small-scale project for Bookstore Management System. The basic idea is that customers can buy a book from anywhere at any time with cash through.

User

  • Users can Register, Login, Logout the system.
  • View different categories and books.
  • Contact with Admin
  • Add Books to Cart
  • Order Books

 Functionality

  • One or more users visit the web page at a time.

Usability

  • In any browser run this webpage.

Performance

  • It performs the webpage as per User’s operating system.

Admin

  • Admin can manage the system.
  • Provide books.

Functionality

  • Admin can insert a book or manage the records.

Database Design & Structure Design

Various tables used in the System are as follows:

  1. Admin
  2. Book
  3. Category
  4. Contact
  5. Register
  6. Order

Conclusion

  • At first look, we can say that Bookstore Management System is a perfect system but it has many limitations that are as follow :
  • This is also used to list the category and books also manage the customer and books of the Bookstore.
  • The Bookstore Management System is used to give information about the Books to the customer.
  • We faced problems like Database creation, the Flow of our system, designing front-end and back-end tools, coding, etc.
  • Only a single user can use a system at a time.
  • In this system, we cannot add a service module.
  • We learned new languages like jQuery, PHP, Bootstrap, HTML, CSS, etc.

Limitation of system

Help

 Currently, the help feature is not available. Using this functionality users can get help with the system.

Payment

Currently, the feature of online payment is not available. Users cannot give payment online.

Multilingual

Multilingualism is not supported in our system. Therefore users cannot work in different languages.

Backup & Recovery:

Users cannot take the backup or recover the data in this system.

Many More Others.

Future Scope of the System

Help module

Using this module users can get help on how to access the system. All functionalities of the system are described in this module. And user can easily access the entire module using this feature.

Online payment module

User can do their payment online using this functionality. In the future, we will add an online payment to make payment easier for the user.

Multilingual

In this system we will add the multilingual therefore users can work in different languages and understand easily.

Input / Output Design

1. Home Page – Home Page of Bookstore Management System without logged-in User.
2. Selected Category – The detective Category is selected. Shows the Books of Detective Category.
3. Book Details (Before Login) – Book Detail for Visitors. Visitors Can’t add Books to Add to Cart.
4. Visitor Login Page – Login Page for Viewers.
5. Register Page – Register Page for Viewers.
6. Contact Us Page
7. Cart Page
8. Order Page – Only Cash On Delivery is Available for Orders.
9. Home Page (Logged In) – Automatically Navigation Bar Changed. The user Can Log Out.
10. Book Details (Logged In) – Users can Add Books To Add to the cart. Removed Sign in Link.
11. Add to Cart (Logged In) – Users Can add books to add to cart. Details of books and price. Click Recalculate to Qty, Rate, and Total will Calculate. Users can order Books.
12. Search Books – Book Search Feature.
13. Admin Login Page (New Template)
14. Admin Home Page – New Template.
15. Add Category (Admin)
16. View Category – List of Books.
17. Add Books.
18. View Books – List Books for Admin.
19. View Contacted List – List of People who Contacted using Contacted Page.
20. Users List
21. Forget the Password

Download the complete Bookstore Management System Php Project Source Code, Project report, and PPT.

Posted on

Portfolio Management System MCA Project using PHP and MySQL

ABSTRACT

The main objective of the portfolio management system is to design and develop a web service that is useful for job seekers and job providers to meet. Create a portfolio website to show off your projects and achievements to prospective employers.

Here, the database is used to collect all the personal information of the candidate for generating their resume profile on the portal. The system admin will generate a report according to the company’s needs and requirements.

INTRODUCTION

Project Description

  • The Portfolio Management system refers to building a strong resume for the candidate who is seeking jobs online.
  • This system introduced a way of hiring employees for the organization that contains all the information of the employees and according to their skill and job requirements, they get selected for the particular post.
  • The purpose of Portfolio management is the selection, prioritization, and control of an organization’s programs and projects, in line with its strategic objectives and capacity to deliver.

The world is growing digitally, and for job seekers, there are more opportunities to seek employment. This system introduced a way of hiring employees for the organization that contains all the information of the employees and according to their skill and job requirements, they get selected for the particular post.

Scope

A Portfolio system is a dynamic and continuous process. The following are the scopes of portfolio management:
1. Monitoring the performance of the portfolio by incorporating the latest conditions.
2. Identifying the objectives, preferences, and constraints.
3. Compare with the latest targets and achievements.
4. There is no need of keeping a physical resume for the candidate.
5. Users have their own login ID and password, with which they can secure their documents.
6. If a wrong password is given three times in succession, that user account will be locked and the user will not be able to use it.
7. Once provided with internet access, users can take part in the system from everywhere.

Purpose

The purpose of Portfolio management is the selection, prioritization, and control of an organization’s programs and projects, in line with its strategic objectives and capacity to deliver. It is a collection of projects and programs used to structure and manage investments at an organizational or functional level to optimize strategic benefits or operational efficiency.

Product function & User classes

User:-

  • Users have to register into the system first.
  • Users can provide their achievements, resumes, and skills in extra detail.
  • Users have to login into the system.
  • Users can view their portfolios according to their details.
  • Users can change their details in the system.
  • Users can provide feedback to the organizations.

Admin:-

  • Admin has to login into the system.
  • Admin can change their details.
  • Admin can view/block the latest registered details.
  • Admin can filter the details.
  • Admin can search the candidate by their skills, name, achievements, and degree.
  • Admin can select appropriate candidates.
  • Admin can send emails to the selected candidates.

Updating the details

  • As we can clarify the profile photo of the user has been updated with the profile and database as well.
  • As follows the update procedure, all the details would be updated with the same result as shown in the image.

Category

Portfolio management is an online web-based application so the main advantage is that there is no more system compatibility requirement problem.

Advantages

  • It improves the candidate selection process.
  • It is used to make smart decisions in the organization.
  • It provides more accurate user performance data.
  • It helps to achieve better productivity in the organization.
  • It also helps to make projects successful.

Design Phase Diagrams:

User Side Activity Diagram:

Admin Side Activity Diagram:

Database Design:

Functional Requirement

Administrator:- Responsible for managing clients of the system, taking system backup, generating reports, and maintaining the organization’s whole details.
Manage Users:- The administrator can manage the user information and the admin can mail and send the details to the appropriate user.
Maintain Details:- The administrator maintains the entire details of the system including details of the users.
Taking System Backup:- The administrator takes a backup of the database in order to prevent loss of the data on system crashes. He takes backup of the entire database in a particular section.
Generate Reports:- Responsible for checking the logs of different system users for auditing and maintaining the whole system.
Use Registration & Login:- The first thing is to register yourself by giving a proper mail id and password then move forward to login into the system.
Filtering as per need:- The administrator can filter the candidate & can view the information related to the filtering.
Non-Functional Requirements
User Interactive:- The response of the website should be high and the website should behave as per the user’s action. Users should be acknowledged in the form of visual changes or feedback on the site to enhance the interaction. The portal should be maintained across all the web pages.
Security:- Secure login option to the users to avoid unauthorized access to the system and the information. 
Reliability:- Portal should provide the users with valid information at all times.
Business Rules:- This requirement contains all the rules and regulations on behalf of the system.

Software tools:-

Front End:- HTML, CSS, Bootstrap, jQuery.
Back End:- MySQL, PHP.
Front End tool:- VS code, Wamp server.

Hardware Specification:-

Hardware platforms support banking transactions. A Portfolio system is effective when the correct software application and hardware configuration are used.
Processor: Intel Pentium 4 or above
RAM: 256 MB OR above
Hard Disk: 160GB or above

System Advantages

  • Building a resume online may save you time which can be utilized in a better way.
  • Candidates may instantly customize their details with one click or add some new details with the same.
  • The site built confidence to boost since you can make your resume professional and you may able to impress the recruiters with your resume.
  • Since the admin can generate reports the process of selecting candidates will be easy.
  • The system is used to make smart and effective decisions for the organizations while selecting a candidate.
  • The system provides more accurate user performance data.
  • The system is helpful to achieve better productivity in the organization.

Limitations of the system

  • The major limitation of the system is that is they work purely online, and lacks the functionality to enable the user to save a copy of their resume in other word processing software like Microsoft Word.
  • Another limitation of the system is that they mostly offer a limited choice of formats. 

Future Scope of the system

  • The system is having currently a static base design that can be chosen by the user, according to their needs they can choose whatever resume type.
  • To increase the system enhancement and database security for the future.
  • Users can delete their account from the site, as they got hired or for some other reasons.

Conclusion

  • The portal has been successfully completed. The goal of the system is achieved and problems are solved. The package is developed in a manner that is user-friendly and required help is provided at different levels.
  • Different types of reports can be generated which help the management to take the correct decision and reduce the time delay which automatically increases the company’s work standards as well as the economical state of the company.
  • This system never decreases the manpower but helps the development of available manpower and optimizes the manpower by which the company’s standards and capabilities can be scaled to higher dimensions.

Download the complete Source Code of the Portfolio Management System MCA Final Year Project Using PHP, MySQL, HTML, CSS, Bootstrap, jQuery

Posted on

Design & Development of Educational Institutions Grievances Portal Project

Currently, there is a portal name Grievances portal similar to this. In the grievances, portal people can share their local problems and their solutions are provided by anyone. But in our portal people can share problems of any region and they are taken up by colleges of the region facing problems. This helps several institutes to work collaboratively on a large scale.

Introduction: 

This Educational Institutions Grievances Portal Project report gives a scope description and overview of everything included in the Project Report.

The following is the overview:

Purpose:

The purpose of this report is to give a detailed description of finding and solving common issues with educational institutions. It will illustrate the complete declaration and purpose for the development of the system. It will illustrate an interaction, constraints, and interface between different users of the system.

System Overview:

This Grievances Portal Project takes the problems faced by students of a particular institute as input in the form of upvotes or posting a problem. All users have to log in using Google authentication facebook or any social media platform. This helps to keep the track of users participating.

The institute first has to register so that it is possible to keep a track of which colleges are participating. All the passwords of institutes are encoded using ​md5 ​and the colleges can then take up the problems about a particular locality and can do collaborative projects to solve them.

The solutions are generally provided in the form of videos which is easily understandable to the local public. But before posting solutions, the colleges have to first check for the authenticity of the problems. They can mark any solution as duplicate or bogus.

This ensures any unrelevant problems from reaching admin and the system is thus maintained. Finally, a report is generated in the form of an excel sheet that helps the admin to know the problems existing in our country. This file can be downloaded as well.

Model of Solution:

Goals:

The Grievances Portal Project aims for semantic text/web page classifications. It provides a better and more comprehensible platform for posting college-level problems and finding solutions. It is extremely user-friendly and easy to use.

Objective / Future scope:

● Define a mechanism to decide ​the count of votes needed to approve an issue
● Once voting is closed for an issue i.e. when the issue is upvoted by the number of users count of votes needed to approve an issue, then the upvote facility will be closed and the system immediately sends a notification to all the related institutes.
● There should be a way to maintain “Reputed Institutes”
● Admin should be able to see which Institutes are working on that problem.
● Each problem should have a thread on which registered users may discuss its solution or upvote or downvote the solutions also.
● The emails of users sending “bogus approved issues” may be blocked when marked as bogus as colleges​

Functional and non-functional requirements:

Grievances Portal Project website there three types of users:

● Citizens
● Institute
● Admin

All users get the same view of the website with similar functionalities but they all perform different tasks.

Functional Requirements:

User Functions

1. Sign Up
2. Can change his/her profile
3. To add an issue
4. Users may also look for issues in any region
5. Can visit a problem description directly through a URL and upvote for it.
6. Users cannot upvote the same issue more than once.
7. Will be notified through email to approve if any solution is available for any of the problems he has upvoted for.

Institute Functions

1. Institutes will have a login

2. After login they will be able to see the issues of ​their region only​ like

a. Unsolved issues (approved)
b. Issues with solutions

System Functions

1. Knows list of Institutes per district
2. Gets added issues and stores
3. Keeps a track of upvotes per issue – Once upvotes reach a ​threshold ​the issue is notified to all the Institutes in that region or district via email. (Institutes can see approved issues of their region via their login as well).

  • Problems of a district may be shown to that region instead of that district
  • Institutes of nearby districts may fall under the same region.
  • Or simply it can be forwarded to the Institutes falling in the same district.

4. Once an Institute submits a solution, the system notifies all the users who upvoted for that issue. So that they may approve the solution.

5. Will know how many solutions an Institute has provided. It means how many of them are solved issues.
6. Long pending issues should be notified to UGC who then will notify the Institutes
7. Institute should be notified when its solution is approved.

Administrator Function

Reports to be generated

The technology stack used:

Backend: PHP.
Frontend: Html, Jquery, javascript, Ajax, bootstrap.

Implementation strategy:

1. Initially, the whole template was designed to suit our requirements.
2. Bootstrap was used for the development of the template of this website (SB Admin 2)
3. All pages were then linked which made the division of work easier.
4. The whole backend was made using PHP.
5. There were various event listeners used in this system like on focus, click, change, etc., which were implemented using JS and Jquery.
6. Almost all pages had the same page refresh and reload for which we have used AJAX.

Conclusion:

1. Our team has completed a Web Application
2. Product Design was a crucial point in the development
3. We now have a complete understanding of how a website works from start to end
4. We learned a new language – AJAX. We also strengthened our knowledge in PHP, JS, and Jquery.
5. Most importantly, we learned how to work in a team.
6. The future scope of our specified in the Goals -> Objectives section.

Posted on

Online Restaurant Food Ordering & Management System Python Project

Online Restaurant Food Ordering & Management System works as a restaurant hub where people can browse and order food online easily. Nowadays, many people especially the young generation, often want to order food from restaurants online with a home delivery service. Thus, we built a restaurant management system where all the restaurant’s information and services will be available. We also offer deliverymen will deliver the food as well, in case a restaurant does not have delivery support.

Users of the Project

This Online Restaurant Food Ordering & Management System has four (4) kinds of users. They are:

  • Customers
  • Restaurant Managers
  • Restaurant Branch Managers
  • Deliveryman

Apart from the users, there is a superuser named admin. Anyone can connect to the system as a customer, restaurant manager, or deliveryman. admin will verify the Trade Licence No. and many other details of a restaurant before connecting it to the system. Similarly, a deliveryman will also get checked by the admin about whether s/he is capable enough to work as a deliveryman.

Project Features

Many features are implemented in the project. Among these, the key features of our project are as follows.

  • Dashboard for the restaurant managers
  • Search and filter food items
  • Our delivery module
  • Bi-directional rating system between deliveryman and customer
  • Offers and Discounts
  • Rating and review submission system

User Guide

This is a sample user guide that will work as a walk-through of the major functionalities of the Online Restaurant Food Ordering & Management System website. As mentioned above, there are 4 kinds of users in this system. A user guide is provided for each kind of user below.

Customer User Guide

Restaurant Homepage

Most of the users of the website will be in this category. Initially, a customer will be able to browse through the website even without a login. Thus, every time a customer enters the website, the customer home page will be loaded.

Customer Location Prompt

But when the customer will try to order something from the website, a location prompt will appear.

Customer Registration

After entering the location, the customer will be able to browse the website as before but cannot order until login/register is done.

View Restaurants

While browsing the items, a customer can filter the items via many different search categories. Among these, on the Restaurants page, a user will be able to see only the restaurants that are close to him/her.

Browse Cuisines

Also, on the Browse Cuisines page, a user can browse items based on many filters and search options. For example, a user can filter the items based on ratings on the items, price range, etc.

Branch Unavailability

Depending on the location, restaurant branch availability will be determined and some of the restaurants may not be able to deliver to the intended location of the customer.

Adding food to cart and Checkout

After browsing, customers can order from a nearby restaurant, check out the cart, and then the customer will be taken to the checkout page where delivery details will be asked for.

Payment method

Customers can use either cash on delivery or an online payment method.

Order Placing notification

At this point, an order has been placed. Now it will be approved by the restaurant manager. Usually, the manager approves the order within a short time. By this time a notification will appear stating that the order has been placed and sent to the restaurant authority.

Rate the Deliveryman

By this time the customer can browse through the website and wait. As the order information keeps getting propagated, the customer will be getting notifications for his order. Once the deliveryman arrives with the order, the customer will be able to rate the deliveryman for the service on the homepage.

Rate and Comment Items

Also, a customer can rate a particular item of a restaurant by clicking on View Item in that item while browsing. S/he can also provide feedback as a comment.

Restaurant Manager User Guide

Manager Register

A restaurant manager will need to open up an account as a restaurant manager on the website. The registration form will look like this. When the admin approves the request, an email is sent stating the activation of the account.

Restaurant Manager Homepage

On the restaurant manager’s homepage, there will be a key to identify the restaurant. This key will be used for opening up the restaurant branches.

Restaurant Branch Creation

Opening up a restaurant branch is just the same as opening up a new restaurant. On the restaurant register page, there is also an option to create a restaurant branch. Providing all the relevant fields along with the restaurant key from the restaurant manager homepage (mentioned above), a new branch of the restaurant can be created.

Add Items

A restaurant manager can add items to his restaurant. In the Add Item tab, the manager will be able to introduce a new item in the restaurant.

Manager Dashboard

Also, a manager can see the restaurant statistics on the Dashboard page. The Dashboard page contains many of the common statistics which will help him understand the restaurant sales progress. Outlet revenue, sales trends in different branches, etc. are shown on this page.

Restaurant Branch Manager

A restaurant branch manager will be in charge of a branch of a restaurant. So, his role on this website is also different from a Restaurant Manager. When the restaurant manager sets up the profile for the branch manager, she/he can manage this branch independently.

Item Availability in the branch

The Branch Manager can declare which items are currently available on the homepage.

Add offer

The Branch Manager can add offers on an item by clicking on that item.

Manage and Accept Orders

This is the most important task of a branch manager. Whenever a customer orders something, the order request comes to the branch manager who has to accept it and forward it to the deliveryman.

Deliveryman User Guide

In our system, anyone can become a deliveryman if s/he is willing to be. Anyone can open up a profile on the website as a deliveryman, but it will need approval from the admin.

Deliveryman Register

While opening an account, the delivery man has to assign himself/herself to one of the zones. S/he will be getting deliveries for that zone only.

Deliveryman Homepage

Once logged in, a deliveryman’s homepage will have currently pending requests of orders in his/her zone. To take an order for delivery, the Take Delivery button is to be pressed.

Complete the Delivery Process

Then, that order entry will be updated and will be waiting for the delivery man to pick up and deliver. Once delivered to the customer, the deliveryman needs to press the Mark As Delivered button. This will also prompt the deliveryman to rate the customer for his/her behavior.

Previous Deliveries

For a deliveryman who has been on the website and delivered many orders, s/he can check all his/her past deliveries in the Delivered Order.

Tools and Frameworks

Frontend

HTML, CSS, Bootstrap
Javascript, Angular JS, JQuery, Google Maps API

Backend – Django

Database – Postgresql v10.2

Specifications:

  • Web Framework: Django 2.2
  • Database Server: PostgreSQL 12.3

Visit Here and download the complete Online Restaurant Food Ordering & Management System Python Project