PROJECT REPORT

“Farmer Merchant Integration”

(Cold Storage Automation)

REPORT SUBMITTED FOR THE PARTIAL FULFILMENT OF THE

REQUIREMENT FOR THE BACHELOR OF TECHNOLOGY IN
“Information Technology”

SUBMITTED TO
“BABU BANARASI DAS ENGINEERING COLLEGE”
LUCKNOW

SUBMITTED BY:
VIVEK PRAJAPATI

(College Enrolment Number- 2005080130056)

2020-2024

Under the Guidance of

Er. Brijesh Mishra
Senior Consultant
SOFTPRO INDIA COMPUTER TECHNOLOGIES (P) LTD
 SPI/ST/2023/114

CERTIFICATE OF COMPLETION

This is to certify that Mr. Vivek Prajapati of B. tech (Information Technology) from Babu Banarasi
Das Engineering College was working on the project entitled “Farmer Merchant Integration (Cold
Storage Automation)” in Softpro India Computer Technologies (P) Ltd. He was engaged with us for
training during July 2023 to September 2023 for 45 days.

She/he has done an excellent job during his engagement with the Software Development & Testing
Division of the company. He has completed his project during the training tenure. His performance has
been good and satisfactory.

I would like to take this opportunity to express my appreciation to Mr. Vivek Prajapati for his work
and wish him all the very best for his future endeavours.

Regards,

Ms. Yashi Asthana

C.E.O
Softpro India Computer Technologies (P) Ltd
Lucknow (U.P.)
 DECLARATION

I Vivek Prajapati hereby, declare that the Project Report submitted to Babu Banarasi Das Engineering

College for the award of Bachelor of Technology in Information Technology was done under the

guidance of Er. Brijesh Mishra, Senior Consultant, Softpro India Computer Technologies (P) Ltd.

I also declare that the information in this report is correct as per my knowledge and I bear any

responsibilities for any error or omission, if any. The matter embodied in this project work has not been

submitted earlier for award of any degree to the best of my knowledge and belief.

Student Name: Vivek Prajapati

Date: 27/09/23
 ACKNOWLEDGEMENT

I would like to express my sincere gratitude to my trainer and mentor Er. Brijesh Mishra, Senior
Consultant, (Softpro India Computer Technologies (P) Ltd.), who gave me his full support and
encouraged me to work in an innovative and challenging project for Educational field. His knowledge
and guidance were extremely helpful in the completion of my training. I would also extend my thanks
to every member of Softpro India Computer Technologies (P) Ltd. for their support and co-operation.

Vivek Prajapati
 INDEX

S. No. Title

1 About the Organisation

2 About Summer Training

3 Technologies Trained During Summer Training

4 Introduction of the Project

5 About the Project

6 Screenshots & Coding of the Project

7 Future Scope
ABOUT THE ORGANISATION
Softpro India Computer Technologies (P) Ltd. is a leading IT firm and the software development
division of Softpro Group of Companies with its headquarter located in the capital city of Uttar Pradesh,
Lucknow. Softpro India was established in 2004 by technocrats from IIT-Kanpur and IET Lucknow.
Softpro Group of Companies is a cluster of companies working in multiple domains like Software
Development, IT Trainings, Research, and Designing. The Founder and Managing Director of Softpro
Group of Companies is Er. Ajay Chaudhary with over 25 years of experience. Softpro India is the fastest
growing IT company with the largest learning center of the region having experienced consultants of
15+ years and industry experts.

Softpro Group of Companies compromises of Softpro Learning Center (Training & Internship division
– 2008), Softpro Innovations (R&D division – 2014) and Softpro Foods (Agro Production division –
2018). Softpro India has global presence with its Head Office and Training Center located in Lucknow,
its International Unit Office located in Malawi, Africa and Virtual Office located in Kuala Lumpur,
Malaysia. Softpro India has successfully delivered Government Projects like the visionary project of
Government of Uttar Pradesh – URISE. Softpro India also has signed MoU with Department of
Technical Education, Government of Uttar Pradesh making it the authorised Training & Development
partners to impart and technically upskill all the engineering students of polytechnics (government,
private & aided) across Uttar Pradesh.

Softpro India’s recent achievements include the MoU signing with Dr. A.P.J. Abdul Kalam Technical
University, Uttar Pradesh. Technologies are transcending boundaries and their volatility is putting
stringent demands on the time and mind-space of techno-professionals. At SPG, we update ourselves
with technologies even before they become norms and master them long before they become redundant.
That's why we are on the roster of clients from across the continents.

Softpro India offers training for all the ranches of engineering (Computer Science, Information
Technology, Electronics, Electrical, Civil, Mechanical) for updated and trending technologies. Softpro
India also has several online and offline trainings like Summer Training, Industrial Training, Vocational
Training, Apprenticeship Program, Employment Training Program and Online Courses. The learning
material and other resources are available on Softpro India’s Learning Management System (LMS) –
“Polyprep – Knowledge @ Your Doorstep” and mobile application – “e-Study Zone”.
Come to think of it, we have engineered ourselves to be at the very forefront in Web based technology.
Our core competencies span a spectrum of web-intensive services that range from website designing to
robust backend management.

SUMMER TRAINING
Summer training is an important part of the engineering curriculum. The summer training helps a
student in getting acquainted with the manner in which his knowledge is being practically used outside
his/ institute and this is normally different from what he has learnt from books. Hence, when the student
switches from the process of learning to that of implementing his knowledge, he finds an abrupt change.
This is exactly why summer training session during the AKTU curriculum becomes all the more
important. Summer training is prescribed for the student of Technical College as a part of the four-year
degree course of engineering by the AICTE. We are required to undergo summer training for a period
of 45 days after the completion of the 3rd year.

Summer Training allows industry exposure and understanding the working environment & it gives the
industrial exposure. It is essential and helps to attain in-depth knowledge of the engineering stream. It
enhances professional skills in a real-time environment. It helps us understand the area of interest and
selection of an area of specialization. It also allows students to learn the basics of how to work as a team
member to complete given tasks. It improves awareness of the industrial environment and work culture
of the specific industry. It gives real-time work and the projects help to learn more analytically. It allows
interaction with experts to solve queries with practical exposure. The Certificate obtained from reputed
organization give weightage to resume or CV.

TECHNOLOGIES TRAINED DURING SUMMER

TRAINING
• HTML: - HTML is stand for hypertext markup language, this markup language is used to
design static web pages. HTML contain pre-defined tags, which are useful to design web pages.
HTML describes the structure of a Web page. HTML consists of a series of elements. HTML
 elements tell the browser how to display the content. HTML elements label pieces of content
such as "this is a heading", "this is a paragraph", "this is a link", etc.
• CSS: - CSS stands for Cascading Style Sheets. CSS describes how HTML elements are to be
displayed on screen, paper, or in other media. CSS is the language we use to style an HTML
document. CSS describes how HTML elements should be displayed. CSS saves a lot of work.
It can control the layout of multiple web pages all at once. External stylesheets are stored in
CSS files.
• Javascript: - JavaScript is a scripting or programming language that allows you to implement
complex features on web pages — every time a web page does more than just sit there and
display static information for you to look at — displaying timely content updates, interactive
maps, animated 2D/3D graphics, scrolling video jukeboxes, etc. — you can bet that JavaScript
is probably involved. It is the third layer of the layer cake of standard web technologies, two of
which (HTML and CSS).
• Bootstrap: - Bootstrap is the most popular HTML, CSS and JavaScript framework for
developing a responsive and mobile friendly website. It is absolutely free to download and
use.It is a front-end framework used for easier and faster web development. It includes HTML
and CSS based design templates for typography, forms, buttons, tables, navigation, modals,
image carousels and many others.It can also use JavaScript plug-ins. It facilitates you to create
responsive designs.
• Database: - A database is an organized collection of data, so that it can be easily accessed and
managed. You can organize data into tables, rows, columns, and index it to make it easier to
find relevant information. Database handlers create a database in such a way that only one set
of software program provides access of data to all the users. The main purpose of the database
is to operate a large amount of information by storing, retrieving, and managing data. There are
many dynamic websites on the World Wide Web nowadays which are handled through
databases. For example, a model that checks the availability of rooms in a hotel. It is an example
of a dynamic website that uses a database. There are many databases available like MySQL,
Sybase, Oracle, MongoDB, Informix, PostgreSQL, SQL Server, etc.

• Java: - Java is an open source, object oriented, high level programming language. Java is a
general-purpose programming language. By using java language, you can develop different
kinds of applications like desktop applications, web applications, mobile applications, ERP,
etc. In project development, we use java as main programming language. In this internship
program we develop a web-based application named “Farmer Merchant Integration (Cold
Storage Automation)”, In this web application we used Java, JSP and JDBC. We use Java as
 programming language, JSP and JDBC as software technology. JSP is a software technology
to create dynamic web application using Java. JDBC stands for Java Database Connectivity, it
is also a software technology to connect java application with database. In this web application
we use mysql as database management system. For development we use Netbeans 8.0 as IDE
(Integrated development environment).

INTRODUCTION
The Farmer-Merchant integration is a web-based application for the Cold Storage. The main objective
of this system is to provide quality products to the merchants by the farmers from the Cold Storage and
the products will be supplied to the merchant’s time to time.

This project deals with developing Cold Storage Web based application. It provides the interaction
between the farmer and cold storage and also between cold storage and merchant. The system is
implemented using a 3-tier approach, with a backend database, a middle tier of Java with JSP, and a
web browser as the front-end client.

In order to develop a Cold Storage Web based application, a number of Technologies must be studied
and understood. These include multi-tiered architecture, server and client-side scripting techniques,
implementation technologies such as Java with JSP, programming language (Java & JavaScript etc.)
and relational databases (MySql).

This project provides common platform for the farmers and merchants on business level. This Farmer
and Merchant integration or FM Integration will act as a mediator between two parties i.e. Farmers and
Merchants. FM Integration is being used for procurement of many food products in an effective and
efficient way.

There are 3 most important entities used, they are:

• Farmer
• Merchant
• Owner
FM Integration has some rules which both parties have to follow. FM Integration will allot katte
(packets) to the farmers according to their requirements. Farmers will be allotted the katte and they will
store products like potato, onions, tomato etc. Farmers will also apply for loans through the FM
Integration system. Accounting process is used systematically. Stocks of particular farmers will be
maintained. Merchant’s information will also be maintained. Transactions information will be
maintained. Merchant will borrow the products from FM Integration. Quality products will be supplied.

FEATURES
This project is providing a very good platform for farmers and merchants. Farmers will use the system
by storing their materials in cold storage through allotted katte. Merchants will borrow the products
from cold storage. There are various attractive features of FM Integration like: -

• Provides good accessibility of database.

• Maintain the consistency of the data.
• Reduce the overhead from the database handler which presently depends on the manual work.
• Provide the good portability feature that means anyone can access this system from anywhere
at any time on the basis of their need.

PROBLEMS IN EXISTING SYSTEM

In Manual working system, so many problems occurred like:
• Human Error during entry process.
• Wrong Transaction can be done so fake transaction may be possible.
• They don’t have centralized database to maintain information.
• Complexity in working process.

PROPOSED SYSTEM
• Fully Automated System is used.
• Centralized database with no redundancy i.e. proper normalization.
• Common platform for farmers and merchants.
• Both parties will be benefited.
OBJECTIVE
ABOUT CLIENT
The client of this project is BABA Cold Storage, Fatehpur, Barabanki, Availability of proper cold
storages are important for preserving perishable commodities like milk, meat, eggs, vegetables, fruits,
ornamental flowers and other floricultural goods.

OBJECTIVES
The client’s requirement in the portal was to broadly categorize users in the web application. The three
categories are:
• Farmer
• Merchant
• Owner
Farmers have to preserve their products which are in stock and afterwards sell those products in a
profitable manner. For that purpose, they need such type of system which should provide facility
for storing their products in an effective and efficient manner. The farmers preserve their products
in different cold storages for the same purpose. This FM Management portal is the automation of
such system which provides facility to the farmers to store their products and sell their products to
the merchants. Merchants will also buy those products in stock from cold storage in an effective
price. Therefore, in this manner all the users will be satisfied.

ABOUT THE PROJECT

This Project is a web-based application for automation of cold storage. The analysis steps of project
are given below: -

• Feasibility Study

Feasibility study is the measure of how beneficial or practical the development of an information system
will be to an organization. The Feasibility analysis is a cross life cycle activity and should be
continuously performed throughout the system life cycle.

• Operational Feasibility: -
By providing the web-based application, all the users will get a very good facility of accessing the
service to get their products. All the user information, accounting and transaction process is done
properly.
Users will feel comfortable by reduction of their work. The system will make handling of large
databases easy. Losing of records will be avoided. Considering all these factors, we can conclude that
all the users and end users will be satisfied by the system.

• Technical Feasibility: -

For the design and development of the system, several software products have been accommodated.
• Database design – MySql
• Interface design – HTML, CSS, Java Script and Bootstrap.
• Coding – Java with JSP

The technology (Java with JSP) has enough efficiency for the development of the system. Therefore,
the project is technically feasible.

• Schedule Feasibility: -

The duration of time required for the project has been planned appropriately and it is the same as the
duration of time expected by the client. Therefore, the website can be delivered to the client within the
expected time duration, satisfying the client. Hence the project is feasible in scheduling.

• Economic Feasibility: -

According to the resources available and the project scheduling process it is estimated that the expenses
allocated for the web application to be developed, by the client is sufficient enough. Hence the
economical factor has been considered feasible.

• Project Planning & Scheduling: -

Planning is very important part of any software development. In the planning phase we decide which
features are to be included in the system to make a good system, how much time do we need to complete
the project, what will be the cost of the system etc…
A Software Life Cycle or software process is a series of identifiable stages that a software product
undergoes during its development. A software product development effort usually starts with a project
identification and selection stage and then requirements analysis; design, coding, testing,
implementation and maintenance are undertaken.

A life cycle model identifies all the activities required to develop and maintain a software product and
establishes a precedence ordering among the different activities.
The various phases of Software Development Life Cycle-

• Requirement Analysis
• System Design
• Coding
• Testing
• Implementation

SOFTWARE REQUIREMENT FOR DEVELOPMENT

User Interface Designing HTML5, CSS3, Java Script, Bootstrap

Programming Language Java with JSP

Database MySql

IDE Netbeans 8.0

HIGH LEVEL DESIGNING
DATA FLOW DIAGRAM (0 – Level DFD)
DATA FLOW DIAGRAM (1 – Level DFD)
ER – DIAGRAM

LOW LEVEL DESIGNING

DATABASE DESIGNING: -
Database Name: - fmidb
Table Name: FarmerInfo

Column Name Data Type

Regid varchar(16) primary key
Name varchar(50)
Fname varchar(50)
Mname varchar(50)
 Gender Varchar(6)
Village varchar(100)
Post Varchar(100)
District Varchar(100)
State Varchar(100)
Contactno Varchar(10)
Aadharno Varchar(12)
Panno Varchar(10)
Regdate Varchar(30)

Table Name: Enquiry

Column Name Data Type

Id int primary key auto_increment
Name varchar(50)
Gender varchar(6)
address varchar(100)
contactno varchar(10)
emailaddress varchar(50)
enquirytext varchar(500)
enquirydate varchar(30)

Table Name: Login

Column Name Data Type

Userid varchar(50) primary key
Password varchar(20)

Table Name: Booking

Column Name Data Type

Regid varchar(16)
Name Varchar(50)
Village Varchar(100)
 Post Varchar(100)
District Varchar(100)
State Varchar(100)
Pincode varchar(6)
contactno varchar(10)
aadharno varchar(12) primary key
noofpacket Int
duration Int
Rate Int
totalamt Int
advance Int
Restamt Int
bookingdate varchar(30)

Table Name: News

Column Name Data Type

Id int primary key auto_increment
newstext varchar(255)
newdate varchar(30)

Modules in Project
There are following modules in project: -

• Farmer Management System

• Merchant Management System
• Booking Management
• Stock Management
• News and Events Management
• Enquiry Management
• Login Management

• SMS API Integration

Modules Description
• Farmer Management System: - Farmer is an important entity in this project, this module

keeps farmer information.

• Merchant Management System: - This module keeps merchant information.

• Booking Management: - This is an important module of project. In this module farmer can do

booking in cold storage for his/her vegetables and fruits.

• Stock Management: - In this module cold storage administrator maintains the stock.

• News and Events Management: - In this module cold storage administrator can publish news

and events, which are displayed on notice board.

• Enquiry Management: - If any person wants to do any enquiry, he/she can submit their

enquiry which will be displayed on admin panel and administrator can resolve that enquiry.

• Login Management: - Login Management module contains user login, change password and

reset password.

• SMS API Integration: - In this module a system generated SMS will be sent after successful

submission of enquiry.
SNAP SHOTS
HOME PAGE

FARMER REGISTRATION PAGE

LOGIN PAGE

ENQUIRY PAGE
ADMIN HOME PAGE

ENQUIRY MANAGEMENT PAGE

BOOKING MANAGEMENT PAGE

BOOKING MANAGEMENT PAGE – 2

BOOKING MANAGEMENT PAGE – 3

CLOSING OF FARMER ACCOUNT

CLOSING OF FARMER ACCOUNT PAGE -2

CHANGE PASSWORD PAGE

FUTURE SCOPE OF PROJECT

Although Farmer Merchant Integration is a complete solution for cold storage automation, yet there are
certain enhancements that can be done in future. Some of them are given below: -

• Transaction can be done by online mode using Payment Gateway API.

• In this solution there are only booking, stock maintenance and closing modules are available
for farmer. In future, same modules can be developed for merchant also.
• Booking module can be available for farmer and merchant end.
• Daily, weekly, monthly, and yearly closing can be added.
• Android Application can also be developed for the portal.