G .V.

ACHARYA POLYTECHNIC SHELU

Veeracharya Technical Education Campus, Raigad, Shelu, Maharashtra410201

REPORT ON
CAR RENTAL MANAGEMENT SYSTEM

FOR THE SUBJECT

CAPSTONE PROJECT PLANNING

ACADEMIC YEAR
2024-25
MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION
Submitted in partial fulfilment of the requirement of the Diploma of
Information Technology

GROUP MEMBERS
[Link] NAME OF STUDENT ENROLLMENT
1. Pratik Tanaji Kambari 2211440008
2. Sahil Rajendra Kahare 2211440012

3. Ayush Vishnu Mishra 2211440016

4. Yash Ramchandra Sawant 23112230444

GUIDED BY

MRS. MADHURA MAHINDRAKAR

 MAHARASHTRASTATE BOARD OF TECHNICAL
EDUCATION

CERTIFICATE

This is to certify that Mr. Pratik Tanaji Kambari

Of semester – V of diploma in INFORMATION TECHNOLOGY of institute, G V
ACHARAYA POLYTECHNIC, SHELU has completed the Micro project
satisfactorily in subject – CAPSTON PROJECT PLANING (22058) for the
academic year 2024-25 as prescribed in the curriculum.

Place: Shelu Enrollment No.: 2211440008

Date: / / 2024 Seat No.: 140747

Project Guide Head of Department Principal

Mrs. Madhura Mahindrakar Mrs. Madhura Mahindrakar
 MAHARASHTRASTATE BOARD OF TECHNICAL
EDUCATION

CERTIFICATE

This is to certify that Mr. Sahil Rajendra Kahare

Of semester – V of diploma in INFORMATION TECHNOLOGY of institute, G V
ACHARAYA POLYTECHNIC, SHELU has completed the Micro project
satisfactorily in subject – CAPSTON PROJECT PLANING (22058) for the
academic year 2024-25 as prescribed in the curriculum.

Place: Shelu Enrollment No.: 2211440012

Date: / / 2024 Seat No.:140749

Project Guide Head of Department Principal

Mrs. Madhura Mahindrakar Mrs. Madhura Mahindrakar
 MAHARASHTRASTATE BOARD OF TECHNICAL
EDUCATION

CERTIFICATE

This is to certify that Mr. Ayush Vishnu Mishra

Of semester – V of diploma in INFORMATION TECHNOLOGY of institute, G V
ACHARAYA POLYTECHNIC, SHELU has completed the Micro project
satisfactorily in subject – CAPSTON PROJECT PLANING (22058) for the
academic year 2024-25 as prescribed in the curriculum.

Place: Shelu Enrollment No.: 2211440016

Date: / / 2024 Seat No.: 140752

Project Guide Head of Department Principal

Mrs. Madhura Mahindrakar Mrs. Madhura Mahindrakar
 MAHARASHTRASTATE BOARD OF TECHNICAL
EDUCATION

CERTIFICATE

This is to certify that Mr. Yash Ramchandra Sawant

Of semester – V of diploma in INFORMATION TECHNOLOGY of institute, G V
ACHARAYA POLYTECHNIC, SHELU has completed the Micro project
satisfactorily in subject – CAPSTON PROJECT PLANING (22058) for the
academic year 2024-25 as prescribed in the curriculum.

Place: Shelu Enrollment No.: 23112230444

Date: / / 2024 Seat No.: 140771

Project Guide Head of Department Principal

Mrs. Madhura Mahindrakar Mrs. Madhura Mahindrakar
 CANDIDATES DECLARATION

This is to certify that the project titled "CAR RENTAL MANAGEMENT SYSTEM" is a bonafied
work carried out by student of Diploma in Information Technology as a part of curriculum as
prescribed by MSBTE. I hereby declare that the project work has not formed the basis for the award
previously of any Diploma, Associate ship. Fellowship or any other similar title according to my
knowledge.

Signature of
student 1.
2.

3.

4.
 ACKNOWLEDGEMENT

We extend our special thanks to all teaching and non-teaching staff. Success is
nourished under thecombination of perfect guidance, care and blessing. Acknowledgement
is the best way to convey Last few years spend in estimated institution has moulded us into
confident and aspiring engineers. We express our sense of gratitude towards our project
guide MRS. MADHURA MAHINDRAKAR It is because of his valuable guidance,
analytical approach encouragement that we could learn, work and complete the project. We
will always cherish great experience work under the enthusiastic guidance.
We are also grateful to our principal and our vice principal who not only supported
us in our project but also encouraged for every creative activity. We also sincerely give
thanks to our head of department MRS. MADHURA MAHINDRAKAR of computer and
its sector, friends and well-wishers to directly orindirectly contribute for the success of our
maiden mission.
 ABSTRACT

The Car Rental Management System (CRMS) is designed to streamline and

automate the process of vehicle rental operations. This presentation explores the CRMS's
key features, functionalities, and benefits for both rental agencies and customers. The
system facilitates efficient management of vehicle inventory, rental transactions, and
customer data, ensuring a smooth and user-friendly [Link] response to the growing
demand for sustainability, CRMS solutions are increasingly incorporating electric vehicles
(EVs), supporting eco-friendly practices and aligning with environmental goals.
Furthermore, as the market shifts toward mobility-as-a-service (MaaS), CRMS platforms
may also integrate with ride-sharing or subscription-based rental models, providing
customers with more flexible [Link], the adoption of a Car Rental Management
System not only streamlines business operations but also improves customer experiences
through convenience, transparency, and personalized services, positioning rental companies
for growth in an increasingly competitive and technology-driven market.
 INDEX

Chapters Title Page No.

1. Introduction

2 Problem Statement

3. Review of Design

4. Design and Planning

5. Use Case

6 Future Scope

7 Conclusion

8 Reference
 CHAPTER 1
INTRODUCTION
 INTRODUCTION

Welcome to our Car Rental Management System, a cutting-edge platform designed

to streamline and enhance the car rental experience for both customers and operators. Our
system offers a comprehensive suite of tools for seamless vehicle booking, real-time
inventory management, and efficient customer service. With user-friendly interfaces and
robust functionalities, including automated reservation processes, dynamic pricing
adjustments, and detailed reporting features, our solution ensures maximum convenience
and operational efficiency. Whether you're a car rental agency aiming to optimize your
fleet management or a customer seeking a hassle-free rental experience, our system
provides the technological edge to meet your needs with ease and precision
 CHAPTER 2
PROBLEM
STATEMENT
 PROBLEM STATEMENT

The The Car Rental Industry faces several operational challenges that impact both customer
satisfaction and business efficiency. Traditional car rental processes are often manual, fragmented,
and prone to errors, leading to inefficiencies in managing fleet availability, booking, billing, and
maintenance. As a result, car rental companies struggle with issues such as vehicle overbooking,
underutilization of fleet assets, delayed maintenance, and a lack of real-time data to optimize pricing
and availability. Furthermore, customers face difficulties in finding the right vehicle, experiencing
long check-in/check-out processes, and dealing with lack of transparency in pricing and booking
policies. The absence of a centralized, user-friendly platform makes it difficult to manage customer
preferences, track rental histories, and ensure timely communication. Additionally, the increasing
demand for electric vehicles (EVs), sustainable mobility options, and integration with ride-sharing
platforms introduces complexity in fleet management and service offerings. Car rental companies
also need to adapt to evolving customer expectations for seamless, mobile-first, and contactless
experiences, which traditional systems are ill-equipped to handle. To address these challenges, there
is a critical need for a Car Rental Management System (CRMS) that automates key processes,
integrates real-time data, supports fleet optimization, and enhances the overall customer experience.
Such a system should enable efficient fleet tracking, dynamic pricing, predictive maintenance, and
seamless booking experiences, while also providing flexible options for modern mobility solutions
such as EVs and subscription-based rentals.
 CHAPTER 3

REVIEW OF DESIGN
 REVIEW OF DESIGN

1. Requirements Analysis :
- Gather and document user requirements.
- Identify key functionalities (e.g., booking, inventory management, billing).

2. System Design :
- Define system architecture (e.g., client-server, cloud-based).
- Create detailed design specifications (e.g., database schema, user interface design) .

3. Technology Selection :
- Choose appropriate technologies (e.g., programming languages, frameworks).
- Select a database management system (e.g., SQL, NoSQL).

4. Development :

- Implement core modules (e.g., reservation system, user management).

- Develop user interfaces (e.g., web application, mobile app).

5. Testing :
- Perform unit testing, integration testing, and system testing.
- Conduct user acceptance testing (UAT) to ensure the system meets requirements.

6. Deployment :

- Deploy the system to a production environment.

- Ensure proper configuration and setup (e.g., server setup, domain registration).
7. Maintenance and Support :
- Provide ongoing support and address bugs or issues.
- Implement updates and enhancements based on user feedback.

8. Documentation :
- Create user manuals and technical documentation.

- Document system architecture, APIs, and operational procedures.

.
 CHAPTER 4

DESIGN AND PLANNING

 DESIGN AND PLANNING

1. System Requirements :
- Admin : Manages car fleet customer data, reservations and generation
- Customer : Can search for, book, and manage rental.

2. System Architecture:
- The architecture can follow a client-server model, whhere the frontend interacts with the backend
which handles data and business logic, connecting to a database
- Frontend (UI):
- Customer UI: A responsive web/mobile interface where customers can sign in, search for cars,
and manage their bookings.
- Admin UI: A dashboard to manage cars, customers, bookings, payments, and generate reports.
- Technologies: HTML, CSS, JavaScript (React, Angular, or [Link] for dynamic UI), Flutter for
mobile apps.

- Backend (Server):
- Restful API: For communication between the frontend and the backend, with endpoints for
user authentication, car booking, payments, etc.
- Technologies: [Link] with [Link], or Python with Django/Flask, or Java with Spring Boot.
- Authentication: JWT tokens or OAuth for user authentication and authorization.
- Database:
- A relational database is ideal for this use case since the data involves structured relationships like users,
cars, and bookings.
- Technologies: PostgreSQL, MySQL, or SQLite (for smaller scale).

3. System Flow and Use case :

- Admin Workflow:
- Car Management: Admin adds, updates, or removes cars from the system
- Booking Management: Admin views and manages all customer bookings
 - Report Generation: Admin generates monthly or yearly reports based on car utilization and
financial transactions.
- Customer Workflow:
- Account Management: A customer creates an account or logs in to the system.
- Payment: Customer enters payment details and confirms the booking.
- Car Pickup and Return: Customer picks up the car, uses it, and returns it on the scheduled date.
- Post-Rental Feedback: Optionally, the customer can rate the car and service after return.

4. Design Considerations:
- Scalability: The system should be able to scale with an increasing number of customers, cars,
and bookings. A cloud-based solution like AWS or Azure can be used for this.
- Security: Implement SSL for secure connections, encrypted passwords (bcrypt), and protection against
common vulnerabilities (XSS, SQL Injection).
- Availability: The system should be highly available, with redundancy in the backend and database
(e.g., using load balancing, failover strategies).
- Usability: The system should have a clean, intuitive user interface to make car bookings smooth
and straightforward.
- Performance: Optimize for fast loading times, especially when searching for available cars, and
ensure that the booking process is seamless.

5. Technological Stack:
- Frontend:

- Languages: HTML5, CSS3, JavaScript

- Frameworks: React, Angular, [Link] for dynamic web interfaces; Flutter for mobile apps.

- Backend:

- Languages: JavaScript ([Link]), Python (Django/Flask), or Java (Spring Boot).

- Databases: PostgreSQL or MySQL for relational data.

- Authentication: JWT (JSON Web Tokens) or OAuth2.

- Payment Integration: Stripe, PayPal, or Razorpay for payments.

- Deployment:

- Server: Nginx or Apache for hosting.

 - Cloud: AWS, Azure, or Google Cloud for hosting the app and database.

- CI/CD: GitHub Actions, Jenkins, or GitLab for continuous integration and deployment.

6. Testing and Qualitu Assuarance :

- Unit Testing: Test individual components and functions.
- Integration Testing: Test the flow between backend and frontend.
- Load Testing: Ensure that the system can handle a large number of concurrent users, especially
during peak booking times.
- Security Testing: Perform vulnerability scanning, SQL injection prevention, and XSS prevention.
- Usability Testing: Conduct testing with real users to ensure the system is intuitive.

7. Deployment and Maintenance:

- Staging Environment: Deploy to a staging environment for final testing before production release.
- Backup Strategy: Regular backups of customer and booking data.
- Control: Git for version control, and GitHub/GitLab for repository management.

8. Future Enhacements :
-Mobile App: A native mobile app for both Android and iOS for customer convenience.
-AI Recommendations: Use machine learning to recommend cars based on customer preferences
-Dynamic Pricing: Implement dynamic pricing based on demand, availability, and booking time.
-GPS Integration: For tracking car location in case of emergencies or to assist with fleet management.
 CHAPTER 5
USE CASE DIAGRAM
USE CASE
 CHAPTER 6
IMPLEMENTATION
 IMPLEMENTATION
SQLCODE :
phpMyAdmin SQL Dump
version 4.4.14
[Link]

Host: [Link]
Generation Time: Jun 28, 2017 at 07:57 PM
Server version: 5.6.26
PHP Version: 5.5.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

Database: carrental

-
Table structure for table admin

CREATE TABLE IF NOT EXISTS admin (

id int(11) NOT NULL,
UserName varchar(100) NOT NULL,
Password varchar(100) NOT NULL,
updationDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

Dumping data for table admin

INSERT INTO admin (id, UserName, Password, updationDate) VALUES

(1, 'admin', '5c428d8875d2948607f3e3fe134d71b4', '2017-06-18 12:22:38');

Table structure for table tblbooking

CREATE TABLE IF NOT EXISTS tblbooking (

id int(11) NOT NULL,
 userEmail varchar(100) DEFAULT NULL,
VehicleId int(11) DEFAULT NULL,
FromDate varchar(20) DEFAULT NULL,
ToDate varchar(20) DEFAULT NULL,
message varchar(255) DEFAULT NULL,
Status int(11) DEFAULT NULL,
PostingDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

Dumping data for table tblbooking

INSERT INTO tblbooking (id, userEmail, VehicleId, FromDate, ToDate, message, Status, PostingDate) VALUES
(1, 'test@[Link]', 2, '22/06/2017', '25/06/2017', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do
eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation
ullamco', 1, '2017-06-19 20:15:43'),
(2, 'test@[Link]', 3, '30/06/2017', '02/07/2017', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do
eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation
ullamco', 2, '2017-06-26 20:15:43'),
(3, 'test@[Link]', 4, '02/07/2017', '07/07/2017', 'Lorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ', 0, '2017-06-26 21:10:06');

Table structure for table tblbrands

CREATE TABLE IF NOT EXISTS tblbrands (

id int(11) NOT NULL,
BrandName varchar(120) NOT NULL,
CreationDate timestamp NULL DEFAULT CURRENT_TIMESTAMP,
UpdationDate timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

Dumping data for table tblbrands

INSERT INTO tblbrands (id, BrandName, CreationDate, UpdationDate) VALUES

(1, 'Maruti', '2017-06-18 16:24:34', '2017-06-19 06:42:23'),
(2, 'BMW', '2017-06-18 16:24:50', NULL),
(3, 'Audi', '2017-06-18 16:25:03', NULL),
(4, 'Nissan', '2017-06-18 16:25:13', NULL),
(5, 'Toyota', '2017-06-18 16:25:24', NULL),
(7, 'Marutiu', '2017-06-19 06:22:13', NULL);

Table structure for table tblcontactusinfo

CREATE TABLE IF NOT EXISTS tblcontactusinfo
( id int(11) NOT NULL,
Address tinytext,
EmailId varchar(255) DEFAULT NULL,
ContactNo char(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

Dumping data for table tblcontactusinfo

INSERT INTO tblcontactusinfo (id, Address, EmailId, ContactNo) VALUES

(1, 'Test Demo test demo
',
'test@[Link]', '8585233222');

Table structure for table tblcontactusquery

CREATE TABLE IF NOT EXISTS tblcontactusquery

( id int(11) NOT NULL,
name varchar(100) DEFAULT NULL,
EmailId varchar(120) DEFAULT NULL,
ContactNumber char(11) DEFAULT NULL,
Message longtext,
PostingDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
status int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

Dumping data for table tblcontactusquery

INSERT INTO tblcontactusquery (id, name, EmailId, ContactNumber, Message, PostingDate, status) VALUES
(1, 'Harry Den', 'webhostingamigo@[Link]', '2147483647', 'Lorem Ipsum is simply dummy text of the printing and
typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown
printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but
also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the
release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like
Aldus PageMaker including versions of Lorem Ipsum', '2017-06-18 10:03:07', 1);

Table structure for table tblpages

CREATE TABLE IF NOT EXISTS tblpages
( id int(11) NOT NULL,
PageName varchar(255) DEFAULT NULL,
type varchar(255) NOT NULL DEFAULT '',
detail longtext NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

Dumping data for table tblpages

INSERT INTO tblpages (id, PageName, type, detail) VALUES

(1, 'Terms and Conditions', 'terms', '<P align=justify><FONT size=2><STRONG><FONT color=#990000>(1)
ACCEPTANCE OF TERMS</FONT><BR><BR></STRONG>Welcome to Yahoo! India. 1Yahoo Web Services India
Private Limited Yahoo", "we" or "us" as the case may be) provides the Service (defined below) to you, subject to the
following Terms of Service ("TOS"), which may be updated by us from time to time without notice to you. You can
review the most current version of the TOS at any time at: <A
href="[Link] In addition, when using
particular Yahoo services or third party services, you and Yahoo shall be subject to any posted guidelines or rules
applicable to such services which may be posted from time to time. All such guidelines or rules, which maybe subject to
change, are hereby incorporated by reference into the TOS. In most cases the guides and rules are specific to a particular
part of the Service and will assist you in applying the TOS to that part, but to the extent of any inconsistency between the
TOS and any guide or rule, the TOS will prevail. We may also offer other services from time to time that are governed
by different Terms of Services, in which case the TOS do not apply to such other services if and to the extent expressly
excluded by such different Terms of Services. Yahoo also may offer other services from time to time that are governed
by different Terms of Services. These TOS do not apply to such other services that are governed by different Terms of
Service. </FONT></P>\r\n<P align=justify><FONT size=2>Welcome to Yahoo! India. Yahoo Web Services India
Private Limited Yahoo", "we" or "us" as the case may be) provides the Service (defined below) to you, subject to the
following Terms of Service ("TOS"), which may be updated by us from time to time without notice to you. You can
review the most current version of the TOS at any time at: </FONT><A
href="[Link] size=2>[Link]
size=2>. In addition, when using particular Yahoo services or third party services, you and Yahoo shall be subject to any
posted guidelines or rules applicable to such services which may be posted from time to time. All such guidelines or
rules, which maybe subject to change, are hereby incorporated by reference into the TOS. In most cases the guides and
rules are specific to a particular part of the Service and will assist you in applying the TOS to that part, but to the extent
of any inconsistency between the TOS and any guide or rule, the TOS will prevail. We may also offer other services
from time to time that are governed by different Terms of Services, in which case the TOS do not apply to such other
services if and to the extent expressly excluded by such different Terms of Services. Yahoo also may offer other services
from time to time that are governed by different Terms of Services. These TOS do not apply to such other services that
are governed by different Terms of Service. </FONT></P>\r\n<P align=justify><FONT size=2>Welcome to Yahoo!
India. Yahoo Web Services India Private Limited Yahoo", "we" or "us" as the case may be) provides the Service
(defined below) to you, subject to the following Terms of Service ("TOS"), which may be updated by us from time to
time without notice to you. You can review the most current version of the TOS at any time at: </FONT><A
href="[Link] size=2>[Link]
size=2>. In addition, when using particular Yahoo services or third party services, you and Yahoo shall be subject to any
posted guidelines or rules applicable to such services which may be posted from time to time. All such guidelines or
rules, which maybe subject to change, are hereby incorporated by reference into the TOS. In most cases the guides and
rules are specific to a particular part of the Service and will assist you in applying the TOS to that part, but to the extent
of any inconsistency between the TOS and any guide or rule, the TOS will prevail. We may also offer other services
from time to time that are governed by different Terms of Services, in which case the TOS do not apply to such other
services if and to the extent expressly excluded by such different Terms of Services. Yahoo also may offer other services
from time to time that are governed by different Terms of Services. These TOS do not apply to such other services that
are governed by different Terms of Service. </FONT></P>'),
(2, 'Privacy Policy', 'privacy', '<span style="color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif;
font-size: 14px; text-align: justify;">At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis
praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non
provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem
rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit
quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus.
Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae
sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus
maiores alias consequatur aut perferendis doloribus asperiores repellat</span>'),
(3, 'About Us ', 'aboutus', '<span style="color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-
align: justify;">At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum
deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in
culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita
distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime
placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut
officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae.
Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut
perferendis doloribus asperiores repellat</span>'),
(11, 'FAQs', 'faqs', '

<span style="color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-

serif; font-size: 14px; text-align: justify;">Address Test &nbsp; &nbsp;dsfdsfds</span>');

Table structure for table tblsubscribers

CREATE TABLE IF NOT EXISTS tblsubscribers

( id int(11) NOT NULL,
SubscriberEmail varchar(120) DEFAULT NULL,
PostingDate timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

Dumping data for table tblsubscribers

INSERT INTO tblsubscribers (id, SubscriberEmail, PostingDate) VALUES

(1, 'anuj.lpu1@[Link]', '2017-06-22 16:35:32');

Table structure for table tbltestimonial

CREATE TABLE IF NOT EXISTS tbltestimonial

( id int(11) NOT NULL,
UserEmail varchar(100) NOT NULL,
 Testimonial mediumtext NOT NULL,
PostingDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
status int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

Dumping data for table tbltestimonial

INSERT INTO tbltestimonial (id, UserEmail, Testimonial, PostingDate, status) VALUES

(1, 'test@[Link]', 'Test Test', '2017-06-18 07:44:31', 1),
(2, 'test@[Link]', '\nLorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam nibh. Nunc varius facilis', '2017-
06-18 07:46:05', 1);

Table structure for table tblusers

CREATE TABLE IF NOT EXISTS tblusers

( id int(11) NOT NULL,
FullName varchar(120) DEFAULT
NULL, EmailId varchar(100) DEFAULT
NULL, Password varchar(100) DEFAULT
NULL, ContactNo char(11) DEFAULT
NULL, dob varchar(100) DEFAULT
NULL, Address varchar(255) DEFAULT
NULL, City varchar(100) DEFAULT
NULL, Country varchar(100) DEFAULT
NULL,
RegDate timestamp NULL DEFAULT CURRENT_TIMESTAMP,
UpdationDate timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

Dumping data for table tblusers

INSERT INTO tblusers (id, FullName, EmailId, Password, ContactNo, dob, Address, City, Country, RegDate,
UpdationDate) VALUES
(1, 'Harry Den', 'demo@[Link]', 'f925916e2754e5e03f75dd58a5733251', '2147483647', NULL, NULL, NULL,
NULL, '2017-06-17 19:59:27', '2017-06-26 21:02:58'),
(2, 'AK', 'anuj@[Link]', 'f925916e2754e5e03f75dd58a5733251', '8285703354', NULL, NULL, NULL,
NULL, '2017-06-17 20:00:49', '2017-06-26 21:03:09'),
(3, 'Mark K', 'webhostingamigo@[Link]', 'f09df7868d52e12bba658982dbd79821', '09999857868', '03/02/1990',
'PKL', 'PKL', 'PKL', '2017-06-17 20:01:43', '2017-06-17 21:07:41'),
(4, 'Tom K', 'test@[Link]', '5c428d8875d2948607f3e3fe134d71b4', '9999857868', '', 'PKL', 'XYZ', 'XYZ', '2017-06-
17 20:03:36', '2017-06-26 19:18:14');
 Table structure for table tblvehicles

CREATE TABLE IF NOT EXISTS tblvehicles (

id int(11) NOT NULL,
VehiclesTitle varchar(150) DEFAULT NULL,
VehiclesBrand int(11) DEFAULT NULL,
VehiclesOverview longtext,
PricePerDay int(11) DEFAULT NULL,
FuelType varchar(100) DEFAULT NULL,
ModelYear int(6) DEFAULT NULL,
SeatingCapacity int(11) DEFAULT NULL,
Vimage1 varchar(120) DEFAULT NULL,
Vimage2 varchar(120) DEFAULT NULL,
Vimage3 varchar(120) DEFAULT NULL,
Vimage4 varchar(120) DEFAULT NULL,
Vimage5 varchar(120) DEFAULT NULL,
AirConditioner int(11) DEFAULT NULL,
PowerDoorLocks int(11) DEFAULT NULL,
AntiLockBrakingSystem int(11) DEFAULT NULL,
BrakeAssist int(11) DEFAULT NULL,
PowerSteering int(11) DEFAULT NULL,
DriverAirbag int(11) DEFAULT NULL,
PassengerAirbag int(11) DEFAULT NULL,
PowerWindows int(11) DEFAULT NULL,
CDPlayer int(11) DEFAULT NULL,
CentralLocking int(11) DEFAULT NULL,
CrashSensor int(11) DEFAULT NULL,
LeatherSeats int(11) DEFAULT NULL,
RegDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
UpdationDate timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

Dumping data for table tblvehicles

INSERT INTO tblvehicles (id, VehiclesTitle, VehiclesBrand, VehiclesOverview, PricePerDay, FuelType, ModelYear,
SeatingCapacity, Vimage1, Vimage2, Vimage3, Vimage4, Vimage5, AirConditioner, PowerDoorLocks,
AntiLockBrakingSystem, BrakeAssist, PowerSteering, DriverAirbag, PassengerAirbag, PowerWindows, CDPlayer,
CentralLocking, CrashSensor, LeatherSeats, RegDate, UpdationDate) VALUES
(1, 'ytb rvtr', 2, 'vtretrvet', 345345, 'Petrol', 3453, 7, 'knowledge_base_bg.jpg', '20170523_145633.jpg', 'phpgurukul-
[Link]', '[Link]', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2017-06-19 11:46:23', '2017-06-20 18:38:13'),
(2, 'Test Demoy', 2, 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam nibh. Nunc varius facilisis eros. Sed
erat. In in velit quis arcu ornare laoreet. Curabitur adipiscing luctus massa. Integer ut purus ac augue commodo
commodo. Nunc nec mi eu justo tempor consectetuer. Etiam vitae nisl. In dignissim lacus ut ante. Cras elit lectus,
bibendum a, adipiscing vitae, commodo et, dui. Ut tincidunt tortor. Donec nonummy, enim in lacinia pulvinar, velit tellus
scelerisque augue, ac posuere libero urna eget neque. Cras ipsum. Vestibulum pretium, lectus nec venenatis volutpat,
purus lectus ultrices risus, a condimentum risus mi et quam. Pellentesque auctor fringilla neque. Duis eu massa ut lorem
iaculis vestibulum. Maecenas facilisis elit sed justo. Quisque volutpat malesuada velit. ', 859, 'CNG', 2015, 4,
'car_755x430.png', '[Link]', '[Link]', 'about_services_faq_bg.jpg', '', 1, 1, 1, 1, 1, 1, 1, NULL, 1,
1, NULL, NULL, '2017-06-19 16:16:17', '2017-06-21 16:57:11'),
(3, 'Lorem ipsum', 4, 'Lorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsum', 563, 'CNG', 2012, 5, '[Link]', '[Link]', 'img_390x390.jpg', 'listing_img3.jpg', '', 1, 1, 1, 1, 1,
1, NULL, 1, 1, NULL, NULL, NULL, '2017-06-19 16:18:20', '2017-06-20 18:40:11'),
(4, 'Lorem ipsum', 1, 'Lorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsum', 5636, 'CNG', 2012, 5, '[Link]', '[Link]', '[Link]', '[Link]', '', 1, 1,
1, 1, 1, 1, 1, 1, 1, NULL, NULL, NULL, '2017-06-19 16:18:43', '2017-06-20 18:44:12'),
(5, 'ytb rvtr', 5, 'vtretrvet', 345345, 'Petrol', 3453, 7, 'car_755x430.png', NULL, NULL, NULL, NULL, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, '2017-06-20 17:57:09', '2017-06-21 16:56:43');

Indexes for dumped tables

Indexes for table admin

ALTER TABLE admin

ADD PRIMARY KEY (id);

Indexes for table tblbooking

ALTER TABLE tblbooking

ADD PRIMARY KEY (id);

Indexes for table tblbrands

ALTER TABLE tblbrands

ADD PRIMARY KEY (id);

Indexes for table tblcontactusinfo

ALTER TABLE tblcontactusinfo

ADD PRIMARY KEY (id);

Indexes for table tblcontactusquery

ALTER TABLE tblcontactusquery

ADD PRIMARY KEY (id);-
- Indexes for table tblpages
ALTER TABLE tblpages
ADD PRIMARY KEY (id);

Indexes for table tblsubscribers

ALTER TABLE tblsubscribers

ADD PRIMARY KEY (id);

Indexes for table tbltestimonial

ALTER TABLE tbltestimonial

ADD PRIMARY KEY (id);

Indexes for table tblusers

ALTER TABLE tblusers

ADD PRIMARY KEY (id);

Indexes for table tblvehicles

ALTER TABLE tblvehicles

ADD PRIMARY KEY (id);

AUTO_INCREMENT for dumped tables

AUTO_INCREMENT for table admin

ALTER TABLE admin

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

AUTO_INCREMENT for table tblbooking

ALTER TABLE tblbooking

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;

AUTO_INCREMENT for table tblbrands

ALTER TABLE tblbrands

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;

AUTO_INCREMENT for table tblcontactusinfo

ALTER TABLE tblcontactusinfo

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
AUTO_INCREMENT for table tblcontactusquery

ALTER TABLE tblcontactusquery

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

AUTO_INCREMENT for table tblpages

ALTER TABLE tblpages

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;

AUTO_INCREMENT for table tblsubscribers

ALTER TABLE tblsubscribers

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;

AUTO_INCREMENT for table tbltestimonial

ALTER TABLE tbltestimonial

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;

AUTO_INCREMENT for table tblusers

ALTER TABLE tblusers

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;

AUTO_INCREMENT for table tblvehicles

ALTER TABLE tblvehicles

MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */
 JAVASCRIPT CODE:

$(document).ready(function () {

$(".ts-sidebar-menu li a").each(function ()
{ if ($(this).next().length > 0) {
$(this).addClass("parent");
};
})
var menux = $('.ts-sidebar-menu li [Link]');
$('<div class="more"><i class="fa fa-angle-down"></i></div>').insertBefore(menux);
$('.more').click(function () {
$(this).parent('li').toggleClass('open');
});
$('.parent').click(function (e) {
[Link]();
$(this).parent('li').toggleClass('open');
});
$('.menu-btn').click(function () {
$('[Link]-sidebar').toggleClass('menu-open');
});

$('#zctb').DataTable();

$("#input-
43").fileinput({ showPrevie
w: false,
allowedFileExtensions: ["zip", "rar", "gz", "tgz"],
elErrorContainer: "#errorBlock43"
// you can configure msgErrorClass and msgInvalidFileExtension as well
});

});

20
CSS:-@import url([Link]
@import url([Link]
/****************************
* FOR RESPONSIVENESS *
****************************/
::selection
{ background:
#4f5362;
/* WebKit/Blink Browsers */
color: #fff;
}
::-moz-selection {
background: #4f5362;
/* Gecko Browsers */
color: #fff;
}
html {
font-size: 14px;
}
@media only screen and (min-width: 480px)
{ html {
font-size: 17px;
}
}
@media only screen and (min-width: 768px)
{ html {
font-size: 14px;
}
}
@media only screen and (min-width: 1024px) {
p{
font-size: 1em;
margin-bottom: 1.8em;
}
}
/****************************
* BODY DEFAULTS *
****************************/
body {
font-size: 1em;
}
a{
color: #37a6c4;
}
a:hover {
text-decoration: none;
color: #5db9d1;
}
/****************************
* Buttons *
****************************/
.btn {
font-family: 'Oswald', sans-serif;
}
.btn i {
position: relative;
top: -2px;
}
.[Link]-left {
text-align: left;
}
.btn-brand
{ background:
#37a6c4; color: #fff;
}
.btn-brand:hover
{ color: #fff;
background: #2c849c;
}
.btn-dark {
background:
#272727; color: #fff;
}
.btn-dark:hover {
color: #fff;
background: #2c849c;
}
.btn-red {
background: #4f5362;
color: #fff;
}
.btn-red:hover {
color: #fff;
background: #383b46;
}
.btn-alt {
background: #f0f0f0;
color: #222;
}
.btn-alt:hover {
color: #fff;
background: #2c849c;
}
/****************************
* Background Colors *
****************************/
.bk-primary {
background: #325d88;
}
.bk-success
{ background:
#93c54b;
}
.bk-warning {
background: #f47c3c;
}
.bk-danger {
background: #d9534f;
}
.bk-info {
background: #29abe0;
}
.bk-white,
.bk-light {
background: #fff;
}
.bk-brand
{ background:
#37a6c4;
}
.bk-dark
{ background:
#222;
}
.bk-blue {
background: #0010ce;
}
.bk-alt {
background: #f7f7f7;
}
.bk-ghost {
background: transparent;
}
.bk-img {
position: relative;
width: 100%;
background-position: center;
background-repeat: no-repeat;
background-size: cover;
background-image: url(../../img/[Link]);
}
.bk-fixed {
background-attachment: fixed;
}
.hr-green {
height: 2px;
background: #37a6c4;
}
.hr-grey {
height: 2px;
background: #f0f0f0;
}
.hr-dashed {
background-color: transparent;
border-top: 1px dotted
#edf0f5; color: transparent;
height: 1px;
margin: 20px 0;
}
.panel {
 overflow: hidden;
}
/****************************
* Border *
****************************/
.brdr {
border: 1px solid #f0f0f0;
}
/****************************
* Text size color *
****************************/
.font-one {
font-family: 'Oswald', sans-serif;
}
.text-bold {
font-weight: bold;
}
.text-normal {
font-weight: normal;
}
.text-thin {
font-weight: 100;
}
.text-lowercase {
text-transform: none;
}
.text-sm {
font-size: 13px;
}
.text-lg {
font-size: 18px;
}
.text-xl {
font-size: 1.6em;
}
.text-2x {
font-size: 2em;
}
.text-3x {
font-size: 2.4em;
}
.text-4x {
font-size: 3em;
}
.text-white,
.text-light {
color: #fff !important;
}
.link-white a
{ color: #fff;
}
.text-grey {
 color: #ccc;
}
.text-dgrey
{ color:
#818181;
}
.text-brand
{ color:
#37a6c4;
}
.text-yellow {
color: #ffff00;
}
.title .line {
display: inline-block;
padding-bottom: 10px;
border-bottom: 3px solid #222;
}
/****************************
* Margins *
****************************/
.mt {
margin-top: 18px;
}
.mt-0x {
margin-top: 0 !important;
}
.mt-2x {
margin-top: 36px;
}
.mt-3x {
margin-top: 54px;
}
.mt-4x {
margin-top: 90px;
}
.mt-5x {
margin-top: 144px;
}
.mb {
margin-bottom: 18px;
}
.mb-0x {
margin-bottom: 0 !important;
}
.mb-2x {
margin-bottom: 36px;
}
.mb-3x {
margin-bottom: 54px;
}
.mb-4x {
margin-bottom: 90px;
}
.mb-5x {
margin-bottom: 144px;
}
.pt {
padding-top: 18px;
}
.pt-2x {
padding-top: 36px;
}
.pt-3x {
padding-top: 54px;
}
.pt-4x {
padding-top: 90px;
}
.pt-5x {
padding-top: 144px;
}
.pb {
padding-bottom: 18px;
}
.pb-2x {
padding-bottom: 36px;
}
.pb-3x {
padding-bottom: 54px;
}
.pb-4x {
padding-bottom: 90px;
}
.pb-5x {
padding-bottom: 144px;
}
/* Content boxes */
.content-box {
padding: 15px;
}
.block-anchor {
display: block;
}
/****************************
* Content Typography *
****************************/
.content-format {
line-height: 1.6em;
font-weight: 400;
letter-spacing: .01em;
font-style: normal;
word-wrap: break-word;
}
.content-format .h1,
.content-format .h2,
.content-format .h3,
.content-format .h4,
.content-format .h5,
.content-format .h6,
.content-format h1,
.content-format h2,
.content-format h3,
.content-format h4,
.content-format h5,
.content-format h6 {
font-family: 'Oswald', sans-
serif; font-weight: 700;
font-weight: bold;
font-style: normal;
color: rgba(0, 0, 0, 0.8);
margin-top: 40px;
}
.content-format .h1 a,
.content-format .h2 a,
.content-format .h3 a,
.content-format .h4 a,
.content-format .h5 a,
.content-format .h6 a,
.content-format h1 a,
.content-format h2 a,
.content-format h3 a,
.content-format h4 a,
.content-format h5 a,
.content-format h6 a {
font-size: inherit;
}
.content-format .h2,
.content-format h2 {
font-size: 3em;
line-height: 1;
margin-bottom: 10px;
padding-bottom: 10px;
border-bottom: 4px solid #f0f0f0;
}
.content-format .h3,
.content-format h3 {
font-size: 2em;
line-height: 1.2;
margin-bottom: 4px;
margin: 1em 0 0.5em;
}
.content-format .h4,
.content-format h4
{ font-size: 1.7em;
line-height: 1.4;
margin-bottom: 6px;
}
.content-format .h5,
.content-format h5
{ font-size: 1.5em;
line-height: 1.4;
margin-bottom: 8px;
}
.content-format .h6,
.content-format h6 {
font-size: 1.3em;
line-height: 1.4;
margin-bottom: 10px;
}
.content-format strong {
font-weight: bold;
}
.content-format ul:not(.social-awesome) {
list-style: disc outside;
margin: 1.714285714rem 0
1.714285714rem; line-height: 1.714285714;
}
.content-format ul:not(.social-awesome) li
{ margin: 0 0 0 36px;
margin: 0 1rem 0 2.571428571rem;
}
.content-format ul:not(.social-awesome).list-unstyled {
list-style: none;
}
.content-format ul:not(.social-awesome).list-unstyled li {
margin: 0 0 0 24px;
}
.content-format em
{ font-style: italic;
}
.content-format p {
margin-bottom: 1.8em;
}
.content-format figure {
margin-bottom: 42px;
}
.content-format figure .caption
{ color: #999;
font-size: 14px;
}
.content-format img
{ border: 0;
height: auto;
max-width: 100%;
vertical-align: middle;
}
.content-format .fa {
color: #37a6c4;
margin-right: 10px;
}
.content-format blockquote
{ border-left: 4px solid
#c3c3c3;
border-left: 4px solid rgba(51, 51, 51, 0.17);
color: #707070;
color: rgba(51, 51, 51,
0.7); font-size: 1.2em;
font-style: italic;
line-height:
1.6667;
margin-bottom: 1em;
padding-left: 0.7778em;
}
.content-format [Link]-quote {
border-left: none;
padding-left: 1em;
}
.content-format pre
{ background: #fff;
border: 1px solid #ededed;
color: #666;
font-family: Consolas, Monaco, Lucida Console,
monospace; font-size: .9em;
line-height: 1.714285714;
margin: 24px 0;
margin: 1.714285714rem 0;
overflow: auto;
}
.content-format ol
{ margin: 24px 0 24px;
margin: 1.714285714rem 0
1.714285714rem; line-height: 1.714285714;
list-style: decimal outside;
}
.content-format [Link]-smiley,
.content-format [Link]
{ display: inline !important;
border: none !important;
box-shadow: none !
important; height: 1em !
important; width: 1em !
important; margin: 0 .07em !
important;
vertical-align: -0.1em !important;
background: none !important;
padding: 0 !important;
}
/*
* Theme Struck - Harmony - Free responsive Bootstrap admin template by [Link] ([Link]
* Code licensed under the MIT
* For details, see #
*/
ul,
li {
 margin: 0;
padding: 0;
list-style: none;
}
/* Social Button Modifications */
.btn {
text-transform: none;
}
.btn-social > :first-child
{ width: 42px;
line-height: 46px;
}
.btn-social
{ padding-left:
58px;
}
/* Circle buttons */
.btn-circle
{ width: 30px;
height: 30px;
padding: 6px 0;
border-radius: 15px;
text-align: center;
font-size: 12px;
line-height: 1.428571429;
}
.[Link]-lg {
width: 50px;
height: 50px;
padding: 10px
16px; border-radius:
25px; font-size:
18px;
line-height: 1.33;
}
.[Link]-xl {
width: 70px;
height: 70px;
padding: 10px
16px; border-radius:
35px; font-size:
24px;
line-height: 1.33;
}
/* Chart design */
/* Charts */
.chart-dot-list
{ display: block;
margin-top: 60px;
margin-left: 20px;
}
.chart-dot-list li {
margin-bottom: 4px;
}
.chart-dot-list li:before {
 content: '';
height: 12px;
width: 12px;
margin-right: 6px;
display: inline-block;
background: #222;
border-radius: 50%;
}
.chart-dot-list li.a1:before
{ background: #F7464A;
}
.chart-dot-list li.a2:before
{ background: #46BFBD;
}
.chart-dot-list li.a3:before
{ background: #FDB45C;
}
.chart-doughnut
{ padding: 41px 0;
}
/* component */
.page-title {
padding-bottom: 15px;
margin-bottom: 20px;
border-bottom: 1px solid #f0f0f0;
}
.brand {
background: #3e454c;
position: relative;
z- index: 3;
position: fixed;
width: 100%;
top: 0;
}
.brand .logo {
box-sizing: border-box;
padding: 20px;
float: left;
display: block;
width: 200px;
}
@media only screen and (min-width: 992px) {
.brand .logo
{ width:
250px;
}
}
.brand .logo img
{ height: 20px;
}
.brand .menu-btn
{ float: right;
background: #232d3b;
 text-align: center;
cursor: pointer;
color: #fff;
padding: 20px 20px;
}
@media only screen and (min-width: 992px) {
.brand .menu-btn
{ display: none;
}
}
.brand .ts-profile-nav
{ float: right;
display: none;
}
.brand .ts-profile-nav li
{ float: left;
position: relative;
}
.brand .ts-profile-nav li a {
display: block;
padding: 20px;
color: #fff;
}
.brand .ts-profile-nav li ul
{ visibility: hidden;
opacity: 0;
right: 0;
position: absolute;
}
.brand .ts-profile-nav li ul li
{ float: none;
width: 180px;
}
.brand .ts-profile-nav li ul li a {
padding: 10px 20px;
background: #222;
}
.brand .ts-profile-nav .ts-account .fa-angle-down
{ float: right;
}
.brand .ts-profile-nav .ts-account > a
{ width: 180px;
background: #2c3136;
}
.brand .ts-profile-nav .ts-account .ts-avatar {
border-radius: 50%;
height: 28px;
margin: -10px 0;
margin-right: 10px;
}
.brand .ts-profile-nav .ts-account:hover ul
{ visibility: visible;
 opacity: 1;
}
@media only screen and (min-width: 992px) {
.brand .ts-profile-nav
{ display: block;
}
}
.ts-sidebar::-webkit-scrollbar-track {
background-color: transparent;
}
.ts-sidebar::-webkit-scrollbar
{ width: 5px;
background-color: transparent;
}
.ts-sidebar::-webkit-scrollbar-thumb {
background-color: #b4b4b4;
}
.ts-sidebar
{ background:
#2c3136; max-height:
0;
transition: max-height 0.3s;
overflow: hidden;
position: fixed;
z-index: 2;
width: 100%;
bottom: 0;
top: 60px;
overflow-y: auto;
}
.ts-sidebar .hidden-side
{ display: none;
}
.ts-sidebar .ts-sidebar-search
{ width: 100%;
background: #25292a;
border: none;
padding: 10px 15px;
color: #fff;
}
@media only screen and (min-width: 992px) {
.ts-sidebar .ts-profile-nav
{ display: none;
}
}
@media only screen and (min-width: 992px) {
.ts-sidebar {
max-height: 100%;
bottom: 0;
}
}
.ts-sidebar-menu .ts-label
{ color: #585c64;
 font-weight: bold;
padding: 8px 15px;
text-transform: uppercase;
font-size: 10px;
letter-spacing:
3px; margin-top:
10px;
}
.ts-sidebar-menu a
{ display: block;
text-decoration: none;
padding: 12px 15px;
color: #fff;
}
.ts-sidebar-menu li
{ position: relative;
}
.ts-sidebar-menu li i {
color: #585c64;
margin-right: 10px;
}
.ts-sidebar-menu li ul
{ display: block;
background: rgba(255, 0, 0, 0.12);
background: rgba(0, 0, 0, 0.32);
max-height: 0;
overflow: hidden;
transition: all 0.3s ease;
}
.menu-open,
.ts-sidebar-menu .open > ul {
max-height: 2000px;
}
.ts-sidebar-menu .open > a
{ background: rgba(51, 56, 62,
0.35);
}
.ts-sidebar-menu > .open > a
{ background: #33383e;
border-left: 3px solid #37a6c4;
}
.ts-sidebar-menu .open > .more i
{ transform: rotate(180deg);
}
.more i {
color: #fff;
padding: 15px;
transition: transform 0.3s;
}
.more {
float: right;
min-width: 10%;
cursor: pointer;
}
.ts-main-content .content-wrapper {
padding-top: 15px;
margin-top: 60px;
}
@media only screen and (min-width: 992px) {
.ts-main-content .ts-sidebar
{ width: 250px;
float: left;
}
.ts-main-content .content-wrapper {
margin-left: 250px;
}
}
/* Login page */
.login-page {
position: absolute;
height: 100%;
width: 100%
CHAPTER 7
FUTURE
SCOPE
 FUTURE SCOPE

1. Integration of Artificial Intelligence (AI):

- AI will Real-time Vehicle Tracking: Using IoT devices, car rental companies can track vehicle
locations, monitor fuel levels, driving behavior, and vehicle health, providing real-time updates for both
the customer and the fleet manager.
- Predictive Maintenance: IoT sensors in vehicles can detect mechanical issues before they become
serious, ensuring fleet reliability and reducing downtime.
2. AI-Powered Fleet Management
- Smart Routing: AI algorithms can optimize routes for rental vehicles based on traffic patterns, weather
conditions, and customer demand, ensuring better customer experiences and reducing operational costs.
- Dynamic Pricing: AI can analyze various factors (e.g., demand, time of day, location, and customer
behavior) to adjust rental prices dynamically, increasing revenue and improving customer satisfaction.
3. Integration with Autonomous Vehicles
- As autonomous vehicles become more widespread, car rental systems may offer self-driving cars as
part of their fleets. This would reduce the need for human drivers and enhance convenience for
customers.
- AI and Self-Driving Cars: Car rental companies will need to implement systems that handle fleet
scheduling, maintenance, and customer interaction with autonomous vehicles.
4. Blockchain for Transparency and Security
- Digital Contracts: Blockchain technology can be used for secure, transparent, and tamper-proof rental
agreements, improving trust between the rental company and customers.
- Decentralized Payment Systems: Cryptocurrencies and blockchain-based payments could streamline
financial transactions, especially for international customers, reducing fees and fraud.
5. Sustainability and Electric Vehicles (EVs)
- EV Fleet Expansion: As the demand for electric vehicles rises, car rental companies will likely expand
their fleets to include more EVs, with CRMS supporting the charging station network, vehicle tracking,
and maintenance.
- Eco-friendly Features: CRMS can incorporate green initiatives, allowing users to easily book EVs,
track carbon savings, and contribute to sustainability goals.
6. Mobile and Contactless Services
- Mobile App Enhancements: Rental systems will continue to evolve with mobile apps offering more
features like remote vehicle unlocking, keyless entry, and personalized vehicle recommendations based
on customer preferences.
- Contactless Check-In/Out: Automated kiosks and app-based check-ins could allow customers to rent
and return vehicles with minimal physical contact, improving the customer experience, especially post-
 pandemic.
7. Cloud-Based Management
- Multi-location Support: As rental companies expand globally, CRMS systems hosted on the cloud will
support seamless management of a global fleet, integrating reservations, billing, maintenance, and
customer data from multiple locations.
- Real-Time Data Analytics: Cloud platforms will allow rental companies to leverage big data and
analytics for better decision-making, customer insights, and personalized offers.
8. Inttegration with Ride-Sharing Platforms
- As ride-sharing platforms like Uber and Lyft gain traction, car rental systems could evolve into hybrid
models, offering users the ability to choose between renting a car for long-term use or booking short-
term rides. This creates a new business opportunity for car rental companies.
9. Subscription-Based Car Rentals
- Instead of traditional rentals, customers could opt for subscription services where they pay a monthly
fee to access a variety of cars for different needs. CRMS would manage these subscriptions, user
preferences, and flexible vehicle allocations.
10. Advanced Customer Experience (CX)
- Voice Assistants and Chatbots: AI-driven voice assistants and chatbots can assist customers in booking
cars, providing real-time support, or offering personalized recommendations based on past preferences.
- Virtual Showrooms: Augmented Reality (AR) could be used to let customers explore cars virtually
before making a booking.
11. Regulations and Legal Compliance
- Automated Compliance: With stricter environmental and safety regulations, CRMS could automatically
ensure that vehicles meet required standards, including emissions and insurance requirements.
- Geo-Fencing and Regional Regulations: CRMS systems could automatically adjust based on local
regulations, ensuring customers don’t face penalties or fines for geographical restrictions (e.g.,
restricted zones for certain vehicles).
CHAPTER 8
CONCLUSION
 CONCLUSION

In conclusion, a Car Rental Management System (CRMS) plays a pivotal role in streamlining
operations, improving customer satisfaction, and enhancing fleet management for rental businesses.
As the industry evolves with technological advancements such as IoT, AI, and blockchain, the future
of CRMS is poised for significant transformation. By embracing these innovations, car rental
companies can offer smarter, more efficient services, including dynamic pricing, real-time vehicle
tracking, and personalized customer experiences.

Furthermore, the integration of electric vehicles, autonomous technology, and cloud-based solutions
will enable car rental companies to adapt to changing market demands and environmental concerns.
The shift towards contactless services, sustainability, and flexible rental models like subscriptions
will cater to the growing expectations of modern consumers.

Ultimately, a well-implemented CRMS not only drives operational efficiency but also supports
business growth by improving customer loyalty, reducing costs, and staying ahead of industry
trends. As technology continues to shape the future of mobility, CRMS will be a key enabler in the
evolution of the car rental sector.
CHAPTER 9
REFERENCE
 REFERENCE

 [Link]
 [Link]
 [Link]
 [Link]

30