Category: MySQL Projects

MySQL is the backend database system, We have developed projects with MySQL DB. Students and Projects Lovers can Download Projects with MySQL Database and enjoy executing.

Posted on

Secure Web Portal for Water Distribution and Quality Assurance

Abstract:

Water Distribution and management is a web application which enhances and emphasizes the way water is distributed and maintaining the quality. The people who are in search of water for their regular uses can contact us by using this application. We Provide water to different areas in the city with monthly packages at affordable rates. We also construct the harvesting pits based on square feet’s in different areas. In this application, there are two modules.

The Water Distribution and Quality Assurance Web application used for water distribution and quality assurance. The users can order water tankers. This portal also helps the user to check the amount of water distributed in each locality of the city limits.

UML Diagrams:

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

The web portal also describes the different levels of quality assurance tests done on the water before its supply.

  1. Admin
  2. User

Modules:

Admin:

Admin will log in into the application using username and password and he can add the locations to which he wants to make service available for that location. Admin can add packages for water and harvesting pits and he can view the user request and accept accordingly and admin also view the user feedback and he will give the quality assurance for each location.

The admin module manages the service providers. That is the admin has to provide the services such as

1. The online payments for monthly payments of water distributed to different houses.

2. Onlinetanker booking.

3. Quality assurance of the water supply

User:

The user will register and login into the application using username and password and he can view the services added by admin and user will search services based on location and he can book the service then the request will be sent to admin and he can also view the status of the booking.

Any user whether he/she is registered or unregistered can access the portal, except for the ones who order water tankers have to use their given username and password for payment details and to make online payments for monthly water distribution. The unregistered users can register by filling the registration form.

Output Screens:

Home Page:

Admin Login:

Admin Home Page:

User Login:

User Home Page:

User Search Results:

Existing System:

In the existing system, the water distribution having a lot of problems all the people cannot able receive the tankers and if at all they need the service they need to visit the nearest want maintaining service agencies and book a request, this is a lengthy process.

Proposed System:

In the Proposed system, the water distribution is reachable to many users they can just login into the application and complete the process in an easy manner and they can also see the quality assurance of the service provided by admin.

All Output Screens:

  • Home Page
  • Admin Login
  • Admin Home
  • View Users
  • View User Requests
  • Add Location
  • Add Service
  • Water Services
  • Add Harvest Pit Services
  • Add Package
  • Quality Assurance
  • View User Feedback
  • User Login
  • User Registration
  • User Home
  • Search Water Tankers
  • Search Results
  • Search Pits Results
  • View Status
  • Guest Page

Software Requirements:

  • JDK 1.8
  • NetBeans 8.0.2
  • MySQL 5.5
  • SQLYog
Posted on

ABC Courier Management System PHP Project

ABC Courier Management System

ABSTRACT

Courier management application will be a comprehensive and complete application wherein ABC systems will be able to manage all its operations and also the franchise/dealer related registration, manage their employees and dealer employees, manage delivery info all registered consignments or packages, manage customer related information and provide necessary info to  the same as notifications when he or she logs in to check the status of booked package or consignment.

It will allow the addition of ABC systems necessary information through the admin panel. Will also allow registration of employees working in ABC systems directly. Also, manage various departments in ABC systems. Will also allow adding a different type of packages or consignments that ABC systems deal with. Will also have necessary reports to check monthly wise packages delivered and amount earned by the company in a month. ABC systems can also register their own customers from their branches.

It will also allow registration of dealers who register themselves as franchises to ABC systems. Once registered dealers will be able to book packages or consignments which ABC systems deal with. Dealers can also log in and manage their employees who work for maintaining the courier process whichever are all involved. It will have the option to manage the packages that have been booked by dealers and also allow them to update the delivery status. Dealers can also register customers and manage their bookings.

Both dealers and ABC systems will have modules specifically to manage the packages that are booked, update the information related to the delivery of booked and confirmed packages, also have the option to cancel any packages or consignments. Once delivered registered delivery employees will be able to update the status of package delivery or it can be managed by respective admins.  

User Types: Super Admin, Admin, Employee, Customer, Executive

Modules:

ABC Admin module: It is accessible only to Super admin. This Module will have the option to first save data related to ABC systems and then add departments in the company and the additional locations and then add branch as per location. Roles will also be added by super admin. Once departments are saved super admin will be registering the employees working in ABC system and assign them to related departments and also assign to location. Super admin will also add the service types in the sense different type of packages that they deal with.

In the registration process super admin will create the logins too for the employees who can thereafter login to the application. This module will also have a reporting module. In reporting they will have a different type of reports like Package report, employees report, dealer report. This will application will basically automate the whole process of managing employees, package handling, handling branches and locations.

There will be no need to write down and maintain all documents in the form of files and papers. It will also have the option to book packages for customers and can also cancel any packages. While booking packages necessary info will be saved like the cost of the package, a number of packages, location, customer details, delivery address, customer delivery details, phone number, email id etc.

Booked packages can also be canceled within 2 hours of time. Super admin will also approve dealer registration and assign dealer manager who will manage all related operations of a dealer whichever assigned to him.

UML Diagrams:

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

Submodules will basically be the one listed below:

  • ABC Info
  • Add Department
  • Add Location
  • Add Branches
  • Add Roles
  • Add Service Types and their cost
  • Manage Service Types and their cost
  • Add Employees
  • Manage Dealers
  •  Add Customer
  • Manage Customers
  • Manage Customer Packages
  • Book Packages
  • Manage Delivery
  • Reporting
  • Login / Logout

Dealers Module:

Dealers will register and in this process will create their login too. Once their registration is approved by Super admin they can log in. Registered dealers will have the option to register customer first and once they add that info they can book the packages which need to be delivered for a customer.

For delivery of packages, employee executive will be assigned. Info related to delivery can also be updated in the delivery module. The option will be provided to update info related to the delivery of package as delivered or pending. Booked packages can also be canceled within 2 hours of time. Submodules for Dealers will be as listed below:

  • Add Customer
  • Manage Customers
  • Manage Customer Packages
  • Book Packages
  • Manage Delivery
  • Reporting
  • Login / Logout

Customers Module:

This module is for customers who will register online via the application. The will be asked to provide all the important info at the time of registration. Once registered they can log in and book package.

They will have the option to add their profile info wherein the address, email id, phone number etc can be updated.  The option will be provided to view the status of the packages that are booked online.

  • Registration
  • Book Package
  • View delivery
  • My Profile
  • Logout / Login  

Employees Modules:

This module will be available for Managers and executives. Executives once logged can update the status of delivery. Managers once logged in can view the status of all packages that are being managed by dealers. Managers will have the option to cancel dealer registrations too.

  • Delivery management
  • Manage dealers

Output Screens:

Admin Sign In Page:

Admin Home Page:

Admin Add Dealership Request page:

Admin View Dealership Request page:

Admin Add Branch Address:

Admin View Branch Page:

Add Consignment Details Page:

Add Delivery Page:

Add Receiver Page:

View Receiver Page:

Get Corporate ID Page:

View Consignment List:

Advantages:

The following are the advantages of the proposed system

  1. Easy to track the status of applications at any level at any point in time
  2. Can generate required reports easily
  3. The centralized database helps in avoiding conflicts
  4. Easy to use GUI that does not require specific training.

Future Enhancements:

  • Notifications via email for registration approval, package delivery
  • Online payment for booking packages

Software Requirements:

Technical Aspects:
Database: MySQL
Language: PHP
Front-end: HTML, CSS,

Hardware Requirements:

Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Download ABC Courier Management System PHP Project Code, Database and Screens.

Posted on

Exam Branch Management System Java Project

Abstract

It emphasizes two main concepts of the examination branch that results in the analysis and distribution of memoranda. The results analysis focuses on the percentage of class passes in each subject and the number of students approved in all subjects. The note distribution includes information about the list of students who took the memos and the date of receipt.

Existing System

• Maintaining all the data manually by records.
• Don’t have Subject wise marks display process in Examination branch related to class or Subject.

Disadvantages

  • Take Time consuming process for search memorandums.
  • No Efficiency for usage.
  • Maintaining records as Cost effective.

Proposed System

An application is developed so that the information of the students who have received the memos and the date of issue of their memos is stored.
Along with the pass percentage of every class, we can also view pass percentage of every subject of a class.

UML Diagrams:

Use Case Diagram:

Student sequence Diagram:

Lecturer Sequence diagram:

Admin Sequence diagram:

Student Collaboration Diagram:

Admin Collaboration Diagram:

Class Diagram:

ER Diagram:

Deployment Diagram:

Component Diagram:

DFD Diagram:

Implementation

Admin Module:

Here admin can log in and maintain student and store their details in the database. Distribute required details to students.

Students Module:

Student contains authentication process mean registration and login fields. The student has individual hall ticket number and also views total result with overall subjects and related results. In this Module, the Students can view their marks information and with the particular subject marks of every class.

Output Screens:

Home Page:

Admin Login Page:

Admin Home Page:

Faculty Allocation Page:

Add Time Table:

Exam Fee Details:

Student Memos:

Students List:

Memorandum:

Students Full List:

Exam Time Table:

Student Registration Form:

Student Login:

Download Exam Branch Management System Java Project Code, Report, Database

Posted on

Campus Pedia – College Management System PHP Project

Introduction:

Campus Management System is educational network project which aims to completely managing colleges, institutes and universities by providing better interaction between students, faculty, and administration. It will provide seamless interaction between the stakeholders enables small administration and management of various teaching, non-teaching and administrative activities.

Motivation:

To have unique projects and develop our own innovative ideas. To become an original thinker by weighing up differing arguments and draw your own conclusions without copying others work.

The objective of the thesis:  

To produce Campus Management System in the undergraduate projects and create awareness about it.

Proposed Work:

Campus Management System is an advanced network information sharing system. Here we can share the information in an effective manner. We can post our ideas and any information instantly. It is interrelated with the different management systems. It will help full to exchanging and providing the latest information and updates quickly. It will provides seamless interaction between the different users.

Database Design:

Here we have seven modules. They are:

  • Admin
  • HOD
  • Counselor
  • Staff
  • Librarian
  • Student
  • TPO

Admin Module: Admin is the person, who works in the administrative department. In Campus Management System he has the ability to activate new users, who are accessing the application, like STUDENT, HOD, COUNSELOR. He can Track the details of any staff or student from his Account.

HOD Module: Person how Are acting as a head of the Department, they having their own account to control the department activities. Like: Assign Councilor’s, Adding new users like Staff and Student etc.

Councilor Module: Councilor is the person who monitoring particular students, who assigned by the HOD. He/ She can update student profiles based on student`s request.

Staff Module: Staff can see the timetables belong to their Own department. And the can update their own profiles. The can ask quires and they can give their answer for the quires which is sent by others.

Librarian Module: In this module home posts gallery, library, settings. Librarian can handle the student requests. He can update the book’s information.

Student Module: He/She can able to post any ideas can able to reserve books from the library.Can give feedback to their HOD or Councilor or ADMIN. He can see his profile if any modification is there in his profile he can post some message to his counselor as a feedback.

TPO Module: He can post the any latest information about placements. And he can track the student profile based on their academics and backlogs.

System Design:

Class Diagram:

Usecase Diagram:

Sequence Diagram:

Collaboration Diagram:

Activity Diagram:

Software Requirements:

Operating System: Windows Family.

Application Server:    Xampp.

Web designing languages :  HTML5, CSS3.

Scripts :   JavaScScripts:

Server side Script :   PHP.

IDE IDE: beans

Database: MySQL.

Database Connectivity : PhpMyAdmin.

Browsers support: IE9, Firefox, Chrome, and Opera

Hardware Requirements:

Processor Speed: 1.1GHZ

RAM:   512MB RAM & above

Hard Disk:   80GB & above

Keyboard: Standard Windows Keyboard

Mouse:   Two or Three button

Monitor:   VGA

OUTPUT RESULTS:

Fig: 7.1 Login page

Fig: 7.2.Admin Home Page

Fig: 7.3 : HOD Home Page

Fig.7.4: Student Home Page

Fig.7.5: Counselor Home Page

Fig.7.6: TPO Home Page

Fig.7.7: Librarian Home Page

Fig.7.8: TPO track

Fig.7.9: TPO Upload

Fig.7.10: Change password

Fig.7.11: Posts

Fig.7.12: Library reservation

Fig.7.13: Ask queries

Fig.7.14: Student feedback panel

Fig.7.15: Assign counselor

Fig.7.16: Feedbacks

Fig.7.17: Activate new users

Fig.7.18: See timetables

Fig.7.19: Track User

Fig.7.20: Student requests library

Fig.7.21: Upload Books Details:

Fig.7.22: Counselor track

Conclusion:

Campus Management System is an Educational Network Which Will Helpful To Share The Information between the different users Effectively and quickly and also provide good interaction between the different users.

Future Scope:

1. Now in our project, we are using the MySql Database, in future, we would like to implement in Oracle.

2. In future, we would like to provide more services to the users.

Posted on

Chores Made Easy Home Repairs Java Project

Introduction

We have management systems for different applications such as schools, library, hospital etc. but our main objective is to develop a web-based application for homeowners with critical home repairs, accessibility modifications, and energy-efficient upgrades. This project helps to bring the communities together in efforts to assist those in need of general home repair and improvements. In this project, the Homeowners must submit an application form with a request. Then the admin review the received application and assign work to the respective employee based on skills and availability

Proposed Web Application Portal

  • Application portal being designed will help to integrate different functionalities of the organization by coordinating different users of the application through the single portal.

Modules of the System:

  • Applicant (Home Owner)
  • Admin
  • Employee (persons skilled at a wide range of repairs, typically around the home)

Current Work Flow:

  • Homeowners must submit an application form with a request.
  • The admin reviews the received application and match the information to the eligibility criteria and accept/decline applications accordingly.
  • The admin later makes a list of all the home repairs that need to be scheduled.
  • The scheduled work orders are then allocated to respective Employee based on skill set, availability etc.,
  • Admin also maintains employee information in their database.
  • An employee can register online and view projects assigned to them through the portal.

 Applications Module:

  • New Application: All applications sent through the mail are keyed into the system through this page. This is same as the online application form.
  • If there are any type of repairs related to home, then homeowners can simply visit our website and can send a request for serving all those home related repairs through this application module

Admin module:

  • Review/Modify Applications: Applications are modified and are approved or rejected by the admin through this page. Applications to be modified can be searched by three options. From date to date, by the last name and by status which can be pending, approved or rejected.

System Design:

Data Flow Diagrams:

UML Diagrams:

Employee Use Case Diagram:

Volunteer Use Case Diagram:

Applicant (Home Owner) Use case Diagram:

Employee Sequence Diagram:

Volunteer Sequence Diagram:

Employee Collaboration Diagram:

Volunteers Collaboration Diagram:

Employee State chart Diagram:

Volunteer Sate Chart Diagram:

Employee Activity Diagram:

Volunteer Activity Diagram:

ER_Diagram:

Class Diagram:

Projects Tab

  • New project: Projects are created for all approved applications. Application for which project is to be created is selected using the search button. Pop up should open on clicking search and should display all approved applications with no projects created on the dashboard by default.
  • View/Modify Project Details: Project is selected from dashboard which is displayed when searched with the last name. Click on Project ID should redirect to View/Modify Project page. This is same as new Project page but with all editable fields except Project ID.
  • View/Modify Employee Details: Project search page is same as view/modify project details. Click on Project ID should redirect to View/Modify Employee page. “NO Employees Assigned” message should be displayed if no employees are assigned. Employees assigned are displayed in a table. Task and House captain fields should be editable.
  • Assign Employee: Click on Search button for Project ID should open a pop-up. It should display project ids with no employee assigned. On selecting a project all details related to that project should be displayed on assign employees page.

Handyman Module:

Handyman Sign-in

  • A new user should register by providing all details given in Personal details page.

Handyman Home

  • First time sign into the portal for the current year (May 2108 – April 2018) should display a message
  • “Do you wish to be Handyman for the XXXX year (current 2018)”.

Project Table Structure:

1. Add project table:


2. Online application table


3. Project materials table


4. sponsors table

5. volunteer table

Download Chores Made Easy Home Repairs Java Project.

Posted on

Tutor Student Portal PHP Project

This is Tutor Student Portal PHP website based on HTML, CSS, and PHP and below is the project idea.

The main aim and objective of this  “Tutor Student Portal” web application is the place where a student can easily find a tutor and vise versa.

Student Features:

  • He should give all his details like Name, Email, Phone Number area and pin code at the time of sign up.
  • After the LogIn student must have an option to post his need of a tutor. In that he needs to give his class, subjects need to be taught. This should be controlled by the student. When he gets the tutor he can delete his need in the site.
  • Based on the details filled by the student, a tutor can find the student.
  • In the home page of the student, he should be able to find the tutor based on the pin code, location through a filter (just as online shopping filters) so that student can get the information and contact details of the tutors who are available nearby him.

Tutor Features:

  • He should give all his details like Name, profile pic, Email, Phone Number, age, subjects he can teach, qualification, area and pin code at the time of sign up.
  • Tutor profile should also have the filters as in students profile to find the student. So that the tutor can get student details how to require the tutor.

Needs HTML CSS coding for Student profile and Tutor profile, filters and displaying the search result and all the PHP coding stuff.

  1. Admin Module: In this module the admin can view the user’s details and allow them to perform view User, uploading, downloading files operations.
  2. User Module: User should log in with his registered account and view the status, download files.

UML Diagrams:

Class Diagram:

Use case Diagram:

Sequence Diagram:

Collaboration Diagram:

Activity Diagram:

Output Screens:

Home Page for Student Login:

Account Registration for Tutor:

User Profile:

Add Requirements Page:

Php My Admin Details:

Tutor Feedback Page:

Download Tutor Student Portal PHP Project.

Posted on

Employee Pay Management System C# / PHP Project Synopsis

Project Understanding: This Employee Pay Management System application will basically handle salary management for employees that work on an hourly basis and contract basis. It will allow employees to register and login to access various modules including Timesheet module which actually allows the employee to save their days work on hourly basis. Employee can update his or her details after login. Information will be like educational qualification, technical experience, personal information etc. Employees can also enter their salary rate. The option will be provided to view salary slips on monthly basis. He or she can also apply leaves and also view their leave history.

User Types: Admin, Employee

Basic Modules involved in the project:

Login / Registration / Dashboard → Every employee working on contractual basis will register and once admin approves it will be able to log in. Once they log in they will be provided with different options to save their personal details, emergency details, permanent address, current address etc. They can add experience details related to all previous companies, add skill sets like proficiency in Java or .net etc.

Timesheet → This module will allow the employee to select the client, then select the project he or she is working, task and then provide comments like activity is done and add no of hours worked for any task. Multiple entries can be posted in a day with different no of hours. Depending upon no of hours saved, the monthly payment will be calculated. The option will be provided to mark a day as leave or weekly off. It will have a view wherein there will be a count, hours, work time and Off time. An employee can also enter his / her off hours like half n hour for lunch.

Leaves →  This module will allow employee to save or request leave type for a day or more. It will also have leave history grid to check the history of leaves.

Admin → Admin will actually manage the admin panel in the back end. Admin will create leave types. Will add projects. Will have option to approve employees registration. Will add different skill names, Add company profile with all details including logo, Employer ID, Address Currency, Owner etc,. Add clients and also add tasks. Admin will approve timesheets submitted by employees and then come up with pay calculations. Admin will approve hourly rate submitted by the employee.

Pay module → This module will have a grid wherein it will have the option to pull up employee working hours details and calculate their pay as per hourly rates approved by admin. This module will be accessible to admin only.

 Future Enhancements: 

  • We can come up with employee alerts wherein they will get alerts for approved leaves, approved timesheets.
  • We can provide reports module with a different type of reports.
  • We can also introduce invoice module too.

Software Requirements:

Technical Aspects:
Database: SQL Server 2008  and more
Language: C# and Asp
Framework: .Net
Front-end: HTML, CSS, Javascript

It can also be done in Php, MySql as backend

Hardware Requirements:

Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Posted on

Image Encryption and Decryption using Blow Fish Algorithm

Abstract: 

Generally, we send many pictures to our friend’s relatives and others. The photos that may contain personal information so keeping them to at most secure is the important thing. So in this project, we implement the idea of encrypting and decrypting the image using BLOWFISH algorithm.

Encryption Process:

Data image as a plaintext and the encryption key are two inputs of the encryption process. In this case, original image data bit stream is divided into the length of the block of Blowfish algorithm.

Decryption Process:

The encrypted image is divided into the same block length of Blowfish algorithm from top to bottom. The first block is entered to the decryption function and the same encryption key is used to decrypt the image but the application of subkeys is reversed. The process of decryption is continued with other blocks of the image from top to bottom

The Single Module Present in the application is

User:

In this application user will register and log in with the username and password, after logging in the user will upload the image which is to be encrypted and then after encrypting the user will get a secret key to the user registered email id using the key and encrypted image

Existing System:

The existing system for this project the text information is encrypted by ASCII values or any special characters. In the existing system, didn’t use the safely sent the encrypted information into the mail. The hackers easily access that information. The encrypted text is didn’t restrict any secret key. So that information easily decrypted. Two common drawbacks of the visual cryptography scheme (VCS) are the large pixel expansion of each shared image and the small contrast of the recovered secret image

Proposed System:

Blowfish to be a publicly available cryptographic algorithm with the potential to replace DES. Blowfish is a 64-bit symmetric block cipher that uses a variable-length key from 32 to 448-bits (14 bytes). The algorithm was developed to encrypt 64-bits of plaintext into 64-bits of ciphertext efficiently and securely. The operations selected for the algorithm were table lookup, modulus, addition and bitwise exclusive-or to minimize the time required to encrypt and decrypt data on 32-bit processors

Screens:

 

Fig: Home Page

This page shows the default view of the Image Encryption and Decryption application and showing the number of modules present in it.

Fig: User Registration

In this page, new users will register the Image Encryption and Decryption application by entering all necessary details.

Fig: User Login

In this page, the user will log in by giving username and password.

Fig: User Home

This page shows after the successful login and showing the basic functionalities that user can perform in this Image Encryption and Decryption application.

Fig: Encrypt Image

In this page, the user will upload the normal image to encrypt the image.

Fig: decrypt Image

In this page, the user needs to upload the encrypted image and secret key which is sent to user mail id.

Software Requirements:

 JDK 1.8, NetBeans 8.0.2, MySQL5.5, SQLYog

Posted on

Online College Voting System Java Project

ABSTRACT

This system provides an online tool for the students to vote on different questions posted by admin. In this system, there will be two main pages to be able to access: Admin page and user Page.

From the Admin, page administrator will be able to design the voting application and upload new questions on different topics which are relevant to college students. From the Voting page, the user will be able to view all questions and vote for the interesting question.

According to the login credentials, the system will determine if the user is Administrator or the user and open the pages given access to the user credentials.

Modules Implementation:

Admin:

Admin can log in with username and password and upload information like questions and four options for each question.  Admin can view answers given by students in graphical view in percentage.

User:

The user will log in with student roll number and view all questions posted by admin and student can vote for all questions.

EXISTING SYSTEM:

In the existing system, there are no specific websites dedicated to colleges who can participate voting from any location. There are many applications on e-voting for political parties but there are very few web applications which are used for voting or general questions or college-related topics questions. 

PROPOSED SYSTEM:

In the proposed system, we are developing e-voting system for college purpose which will have features of admin and user. Here admin will post questions based on social topics or subject related topics related to college. Students can log in and vote to topics and view percentage of votes for each question.

SOFTWARE REQUIREMENTS:

  • Operating system: Windows XP/7.
  • Coding Language: Java
  • Tool: Netbeans
  • Database: MYSQL
Posted on

Grocery Ekart Management Real Time Project

Project Understanding:

The reference website link provided to the developer and also need few clarifications and inputs from the customer side specifically to understand the project flow. In this document, we present our understanding of what needs to be accomplished in the project along with the budget and time estimation.
Reference site link: https://www.bigbasket.com/  (checked only to have an idea regarding the features that will be there in the app)

Project Statement:

→ To design and develop an ekart marketplace and mobile app for Android platform which will provide an option to browse through various household groceries and related products.

Project Description in Brief:

The requirement is to develop and implement a fully functional ekart module which will allow customers register and browse through all products online. They can add products to kart and order them. It will also involve admin panel to manage the addition of products, editing details related to a product. It will manage payment gateway also. We will also provide an option to manage offers via offer management module in the admin panel.

1. Admin Module
2. Kart Module
3. User Module
4. Payment Gateway Integration (Let us know which all need to be integrated like Paytm, PayPal, VISA MasterCard etc)
5. Coupon / Offers Management
6. Employee and Executive Management
7. Order Management
8. Review and Rating Management
9. About Us
10. Careers
11. Privacy Policy (Client needs to provide us the info related to terms and conditions)
12. Terms and Conditions (Client needs to provide us the info related to terms and conditions)
13. Blogs (Let us know if this is needed)
14. Logo design
15. Notifications (Email and SMS , client need to purchase SMS package and it will be integrated)
16. Delivery management

Quality Control:

At the end of the development cycle, you will have a properly functioning and quality assured site. By ensuring implementation of the following points we maintain quality in the products we deliver.

➔    W3C validated semantic HTML code
➔    Well commented and indented PHP code
➔    Proper escaping of user entered data, the addition of captcha to web forms for preventing XSS, CSRF and other security issues
➔    Properly Optimized and indexed database tables for speed and consistency
➔    Minified CSS, JS and optimized images for faster loading of the site
➔    Implementation of meta tags, descriptions, open graph tags for help in SEO

User Types: Admin, Customer, Employee logins (no vendor login as discussed)

→ Admin will have access to all modules on web and can monitor everything the application.
→ Customer will have access to products view and can browse through and access offers and then finally add products to the kart and order the same.
→ Employee is basically the delivery executive login who will actually manage the deliveries and will have access to the related delivery management screens only

Module Details:

Web development: 

SL NO Type Time Estimation (in MD)
1. Users Module:
Login / Registration / Logout (Sign In with Google / Facebook social logins)
My Basket ( This actually deals with products being added to kart and manage it)
My Orders  ( This deals with history of  transactions  and orders for a logged in customer)
My Profile (Edit Profile , Delivery Address mgmt, Change Password , Email Address)		 10 MD
       2. Common Admin panel:
Admin login features
Manages Employee executive delivery history
Manage Customers
Manage Products addition to applicationManage Reviews and Ratings in applicationManage Coupons and Offers in applicationsManage new offers (to be displayed in splash screen )
About Us submissions
Blogs management (if needed)
Categories / Sub-categories management
Brand management
Filter management
Location Settings		 20 MD
       3. Designing:
Homepage design with splash screen, Banner with sliders and effects, offer views, products display designs, admin panel design, About Us (including smtp configurations), Careers, Privacy Policy, Terms & Conditions , Blogs design , Individual page designs , Menus and Submenus, Location selection design		 15 MD
      4. Delivery management: status of products delivery  and related notifications, Pending / Confirmation option , a grid to view and manage all deliveries for executive login , option to update payment status for orders delivered 5 MD
      5. Testing, bug fixes, changes from client feedback 12 MD
      6. Total 62 MD (approximate)

 

Mobile: (2 Android Apps)

User App: Will follow all modules mentioned above except admin panel as it will be maintained only on the web.

Executive App: Will have screens designed for tracking deliveries, managing the delivery status, update the delivery and payment status 

SL NO Type Time Estimation (in MD)
1. Users Module:
Login / Registration / Logout (Sign In with Google / Facebook social logins)
My Basket ( This actually deals with products being added to kart and manage it)
My Orders  ( This deals with the history of  transactions  and orders for a logged in customer)
My Profile (Edit Profile , Delivery Address mgmt, Change Password , Email Address)		 15 MD
        2. Designing:
Homepage design with a splash screen, Banner with sliders and effects, offer views, products display designs, admin panel design, About Us (including SMTP configurations), Careers, Privacy Policy, Terms & Conditions, Blogs design, Individual page designs, Menus and Submenus, Location selection design		 15 MD
     3. Delivery management: status of products delivery  and related notifications, Pending / Confirmation option, a grid to view and manage all deliveries for executive login, option to update payment status for orders delivered 10 MD
     4. Total 40 MD (approximate) + 10 MD for testing and feedback changes

 

Technology to Use

Design and Markup

– HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behavior

– Bootstrap / Angular JS will be used for making the site responsive and as a framework.

Server-side language (anyone can be used depending upon your preference)

– PHP (codeigniter, CakePHP, Phalcon or Laravel)

Database Software (anyone can be used depending upon your preference and server setup)

– MySQL

– SQL Server

Android: Java  (Android v 5.1 and higher)

Time frame for execution of the project ( Total 112 Days  approximate)

Designs & Web Services : 30 Days

Admin Panel :- 20 Days

Android App: 40 Days

Testing: 22 Days