MSC PROJECT (3) Updated

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 49
At a glance
Powered by AI
The project is about developing an e-commerce website for selling Computer Science books. It discusses the requirements, design, implementation and testing of the website.

The project is about developing an e-commerce website named 'CSE BOOK STORE' to sell Computer Science books online.

The technologies used in the project include HTML, CSS, PHP, SQLite for frontend, backend and database.

E- COMMERCE WEBSITE FOR CSE BOOKS

A MINI PROJECT REPORT

SUBMITTEDFOR THE PARTIAL FULFILMENT FOR

THE A WARD OF THE DEGREE

MASTER OF COMPUTER SCIENCE

BY

JITHIN VIJAYAN

REGISTER NO: 832000177

UNDER THE GUIDANCE OF

MR.B SAMUEL.,MCA.,M.Phil Assistant Professor

2021-2022

DEPARTMENT OF COMPUTER SCIENCE

-------------------------------------------------------------------------------
NO 53, Violet College Road, Menambedu, Ambattur, Chennai-600053
Phone: 26861611/26864684

1
ANNAI VIOLET ARTS AND SCIENCE COLLEGE

DEPARTMENT OF COMPUTER SCIENCE

PROJECT WORK 2021

This is to certify that the project entitled

E-COMMERCE WEBSITE FOR CSE BOOKS

Is a bonafide work done by

JITHIN VIJAYAN

REGISTER NO: 832000177

Of Master of Computer Science during the academic year 2021-2022

------------------------------------ ------------------------------------
Mr.Samuel., MCA., M.Phil Mrs. Gladis Thanka Roobi MCA., M.Phil

Project guide HOD,Department of Computer Science

------------------------------------------------------------------------------------------------------------------------
Submitted for the Viva-Voice Examination Held on At Annai Violet Arts and Science College,
Chennai-600053

------------------------------------------- -----------------------------------------------

Signature of Internal Examiner Signature of External Examiner

2
ACKNOWLEDGEMENT

The success and final outcome of the project required a lot of guidance and assistance from many
people and I am extremely privileged to have got this all along the completion of my project. All
that I have done is only due to such supervision and assistance and I would not forget to thank them.

I respect and thank Dr. Initha LebanonEbency, Principal of Annai Violet Arts and
ScienceCollege for providing me an opportunity to do the project and giving as all support and
guidance which made me complete the project duly. I am extremely thankful to her for providing
such a nice support.

I wholeheartedly thank Mrs. Japhia Solomon, Vice principal of Annai Violet Arts and Science
college for all support and encouragement which motivated us to complete the project successfully.

I would not forget to remember Mrs. Gladis Thanka Roobi., MCA., M.Phil., Head of the
Department for her encouragement and more over for their timely support and guidance till the
completion of my project work

I owe my deep gratitude to my project guide Mr.Samuel.,MCA., M.Phil Assistant Professor who
took interest in my project work and guided me all along, till the completion of my project work by
providing all the necessary information for developing my project work

I am thankful to and fortunate enough to get constant encouragement, support and guidance from all
Teaching staffs and my friends of the computer science department which helped me in successfully
completing my project work.

Also, I would like to extend my sincere esteems to staff in the laboratory for their timely support.

JITHIN VIJAYAN

Enrol No:832000177

H.O.D

Computer Science Department

Table of Contents
3
CHAPTERS Page
No.
ABSTRACT 05

CHAPTER 1: INTRODUCTION 08
1.1 Background 08
1.2 Objectives 08
1.3 Purpose, scope and Applicability 08
1.3.1 Purpose 08
1.3.2 Scope 09
1.3.3 Applicability 09
1.4 Achievements 09
1.5 Organization of Report

CHAPTER 2: SURVEY OF TECHNOLOGIES 11

CHAPTER 3: REQUIREMENTS AND ANALYSIS 13


3.1 Problem Definition 13
3.2 Requirement Specification 13
3.3 Planning and Scheduling 14
3.4 Software and Hardware Requirements 14
3.5 Preliminary Product Description 15
3.6 Conceptual Models 16

CHAPTER 4: SYSTEM DESIGN 24


4.1 Basic Modules 24
4.2 Data Design 25
4.2.1 Schema Design 25
4.2.2 Data Integrity and Constraints 25
4.3 Procedural Design 26
4.3.1 Login Diagrams 26
4.3.2 Data Structures 27
4.3.3 Algorithm Design 28
4.4 User interface design 29
4.5 Security Issues 30
4.6 Test case Design 31

CHAPTER 5: IMPLEMENTATION AND TESTING 34


5.1 Implementation Approaches 35
5.2 Coding Details and Code Efficiency 35
5.2.1 Code Efficiency 41
5.3 Modification and Improvements 42
CHAPTER 6: RESULT AND DISCUSSION 43
6.1 Test Reports 43
6.2 User Documentation 43

CHAPTER 7: CONCLUSION 47
7.1 Conclusion 47
7.2 Limitation of the System4 47
7.3 Future Scope of the Project 47

References 48
Abstract

It’s a thing of massive gratification for us  to present this Second Year Project Report on the project
CSE BOOK STORE.
Information Technology adoption is on the rise and recent technological innovation have
dramatically enhanced the capability of the organization performance leveraging the power of these
technologies , various business sectors are working together to offer a wide array of  services
internal as well as external to the organization.
CSE BOOK STORE is a web based e-commerce application to support Environment sustainability
by selling used books. CSE BOOK STORE is based on idea to understand what customers want:
Fair price quotes, fast payment, good communication, excellent customer service, and an easy to
use website. By buying and selling used books CSE BOOK STORE will help to prevent waste and
to protect our environment.
CSE BOOK STORE has several advantages and it could be of immense help customers as it can
provide Effective Performance and Greater Economic Efficiency, improved and Secured Business
Transaction, Customers can check for order history, Wish list and Newsletters. Also, Users can
create their account for shopping as well as for making their own online library and check for book
publishers and read & write review comments.

5
CHAPTER 1: INTRODUCTION

6
CHAPTER 1: INTRODUCTION
1.1Background

Information Technology adoption is on the rise and recent technological innovation have
dramatically enhanced the capability of the organization performance leveraging the power of these
technologies , various business sectors are working together to offer a wide array of  services
internal as well as external to the organization.

In this growing world, everyone wants to the access of knowledge and books play an important role.
However, books are help for us but making of books cost negative effects on environment. Hence,
CSE BOOK STORE application is as challenge for us because the idea behind scene is to help not
only human being but also environment.

1.2Objectives

CSE BOOK STORE is a web based e-commerce application to support environment sustainability
by selling used books. CSE BOOK STORE is based on idea to understand what customers want:
Fair price qotes, fast payment, good communication, excellent customer service, and an easy to use
website. By buying and selling used books My Book card will help to prevent waste and to protect
our environment.

1.3Purpose, scope and Applicability

1.3.1 Purpose

Our proposed solution to the problem is to provide the Book readers or sellers with better and more
efficient means of managing, marketing and keeping a record of books online. “CSE BOOK
STORE” is based on e-commerce where customer can sell any kind of books in more economic and
efficient way. Moreover, It will help customers and users to do improved and secured business
transactions.

1.3.2 Scope

Like any other application CSE BOOK STORE has a great scope of evolving in the future. The
application will also have a desktop widget which will show the current status of the book on the
desktop to prevent frequent login. Also a mobile version of the application is proposed which
would run on Windows Mobile platform which would enhance the portability as well as flexibility.

1.3.3 Applicability

CSE BOOK STORE is a web application followed by e-commerce principal. We have to


PHP,Html, Javascript and CSS to design user friendly web pages. Our application uses Sql lite to
store databases. Currently, there is no url for our website so we are using Apache to run application
on server. There is admin page which maintain and track all the activities like uploading and
deleting details of upcoming or old books and tracking the product, customer details, sales details
and review comment by customer. If users or customers want to purchase any book then it is

7
necessary to have an account in CSE BOOK STORE. If users or customers won’t have any account
on CSE BOOK STORE then they get information about books but cannot by it. This feature is
implemented from the security prospects.

1.4 Achievements

CSE BOOK STORE provides the Customers with better and more efficient means of managing
land utilization and keeping a record of books. Technologies such as PHP: Hypertext
Preprocessor(a server-side scripting language designed for Web development but also used as a
general-purpose programming language) and HTML(Hyper Text Markup Language),
CSS(Cascading Style sheet), Java Script and Wamp Server have been used in building this
application. I got know about how data is fetched form Server and how server based application
works. Moreover, I was working on a completely new platform to implement new idea.
Successfully completing my idea is a biggest achievement for me.

1.4Organization of Report

This is project report contains information regarding CSE BOOK STORE Application. Report has
covered all the points as how do we get idea of implementing CSE BOOK STORE application.
Hardware and software requirement for implement and running web application followed by use
case diagrams, class diagrams, E-R diagram, Activity diagram and Collaboration diagram.
Moreover, project report has also covered unit and integration test cases which are run during
testing of application to ensure the quality. At the end of report, appendix and reference books &
site are added which were used during coding and implementation of application.

8
CHAPTER 2: SURVEY OF TECHNOLGIES

9
CHAPTER 2: SURVEY OF TECHNOLGIES

CSE BOOK STORE is based on MVC (Model- View- Controller) architecture. The information is
presented through a rich user interface experience, using

 PHP (at least 5.2)


 HTML
 Java script
 CSS

PHP :

 PHP stands for PHP: Hypertext Preprocessor


 PHP is a widely-used, open source scripting language
 PHP scripts are executed on the server
 PHP is free to download and use

HTML:

HTML is a language for describing web pages.

 HTML stands for Hyper Text Markup Language


 HTML is a markup language
 A markup language is a set of markup tags
 The tags describe document content
 HTML documents contain HTML tags and plain text
 HTML documents are also called web pages

JAVA SCRIPT :

 A scripting language is a lightweight programming language.


 JavaScript is programming code that can be inserted into HTML pages.
 JavaScript inserted into HTML pages, can be executed by all modern web browsers.

CSS:

 CSS stands for Cascading Style Sheets


 Styles define how to display HTML elements
 Styles were added to HTML 4.0 to solve a problem
 External Style Sheets can save a lot of work
 External Style Sheets are stored in CSS files

10
CHAPTER 3: REQUIREMENTS AND ANALYSIS

11
CHAPTER 3: REQUIREMENTS AND ANALYSIS
3.1 Problem Definition

The theme that we have opted for is “Web based centralized system”. The main objective of
making “CSE BOOK STORE” is to provide a platform to customers where they can experience a
effective performance of selling books to anyone followed by improved business transactions.

3.2 Requirement Specification

CSE BOOK STORE provides the Customers with better and more efficient means of online book
shopping and wide range of books from all over the world. Technologies such as PHP: Hypertext
Preprocessor(a server-side scripting language designed for Web development but also used as a
general-purpose programming language) and HTML(Hyper Text Markup Language),
CSS(Cascading Style sheet), Java Script and Wamp Server have been used in building this
application. Main requirements involve :
1. Design of Admin page
2. Design of Home page
Admin page will cover all the aspect like managing, maintenances as well as flow of selling of
books. While Home page will involve interaction with user in user friendly manner and home page
will cover all the aspects such as My Account, Information, Extras and Customer Services.

12
3.3 Planning and Scheduling

GANTT CHARTS
No. Of Days

0 10 20 30 40 50

Task

Fig 1. Gantt Chart

3.4 Software and Hardware Requirements


13
Hardware Used
1. Intel Core 2 Quad Q9550,E0 revision
2. 4 GB PC2-6400 800Mhz RAM
3. 500 GB Hard disk drive

Software Requirements
1. Windows 7 Ultimate
2. IE8/Firefox/Safari
3. Web Server (preferably Apache)
4. PHP (at least 5.2)
5. MySQL
6. Curl

3.5Preliminary Product Description


14
We indulged ourselves into a lot of research before we started the actual work on the “CSE BOOK
STORE Application”. We studied about the different kinds of web designing tools and scripting
languages as PHP, HTML, CSS, and JavaScript, that were needed to build our application.
CSE BOOK STORE is a web based e-commerce application to support Environment sustainability
by selling used books. CSE BOOK STORE is based on idea to understand what customers want:
Fair price quotes, fast payment, good communication, excellent customer service, and an easy to
use website. By buying and selling used books My Book card will help to prevent waste and to
protect our environment.

Common Tasks:-

Major functions and operations of CSE BOOK STORE are as follows:-


1. Admin Login Page.
2. Basic home screen
3. Information page
4. My Account
5. Shopping list
6. Extras and /customer list
7. Mobile Version
8. Desktop Widget

Our study showed us that it would be really difficult for us to develop a “CSE BOOK STORE with
all features due to the time constraint as well as provide facility of e-commerce because for e-
commerce, admin requires internet certifications. The functionality that we were going to
implement in our “CSE BOOK STORE Application” are home screen and admin page, mobile
simulator for using application on mobile and desktop widget.

3.6 Conceptual Models

15
DATA FLOW DIAGRAM

1. Data Flow

An arrow represents data flow; it represents the path over which data travels in the system? A data
flow can move between processes, flow into or out of data stores, to and from external entities.

2. Bubbles (Process)

A circle or bubble represents that transforms data from once form to another by performing some
tasks with the data.

3. Data store

A data store is a place where data is held temporarily from one transaction to the next or is stored
permanently.

4. Entity

External Entity symbol represents sources of data to the system or destinations of data from the
system

CLASS DIAGRAM

16
A class diagram is used to support functional requirement of system. The class diagram used to
model the vocabulary of the system.

Fig 5. Class Diagram

USE CASE DIAGRAM

17
A use case shows a set of use cases, actors and their relationship. The use case diagram make
system and classes approachable by presenting an outside view of how the elements may be used in
context.

Admin
General User

Shopping
cart

Wish List
My Account

Review/
Information Comment

Home Screen

Order History
<<include >>

Registered Customer
User Service
<<include >>

Extras

Shopping
Fig 6. Use Case Diagram
cart

E-R DIAGRAM

18
1. Entity

Entity has a set of attribute whose value is uniquely, identify the entity or distinguish the
entityfrom the other thingor entity in the world.

2. Attribute

Are used to difinean entity that is the propertythat discribe an entity.


That is the properly that describean entity.

3. Relationship

Is asscoiation among different/several,entites. It connect to one or more entittes.

4. Derived Attribute

Any attribute which is derived from the relationship is called derived attribute.

5. Cardinality

Cardinality refers to the multiplicity of the entities. How many entity are actually engaged in the
relationship

Types of cardinality:-
1. Many to 1
2. 1 to 1
3. 1 to Many
4. Many to Many

19
COLLABORATION DIAGRAM

A collaboration diagram describes interactions among objects in terms of sequenced messages.

Admin
Shopping cart

My Account Wish list

Application Home page

General User

Information Order history

Review/comment

Extras

Customer service

ADMIN Login
Registered User

Statistics

Fig 8. Collaboration Diagram

20
ACTIVITY CLASS DIAGRAM

Activity diagrams are graphical representations of workflows of stepwise activities and actions
with support for choice, iteration and concurrency.

Enter User name


(U)and Password(P)

Invalid
user name N If U=PS3
and &
Password

My Account Information Extras Customer


Service

Shopping cart
If
Registered
Useer
Wish List

Add to cart
Login
NPage

Review
Comment

If U=PS3
&

21
My Account Information Extras Customer
Service

Y
Y

If
If My information is Y
account is selected
selected

N N

Login page Y
for Y About us, If Extras
unregistered Delivery is selected
user information
for
unregistere
Wish list, Delivery in
d user
Oder for and
History, policy for N
My registered Y
account user
details Home
will be screen
displayed
Options will
be displayed

STOP

Fig 9. Activity Diagram

22
CHAPTER 4: SYSTEM DESIGN

23
CHAPTER 4: SYSTEM DESIGN

4.1Basic Modules

5. About CSE BOOK STORE.

CSE BOOK STORE is a web based e-commerce application to support Environment sustainability
by selling used books. CSE BOOK STORE is based on idea to understand what customers want:
Fair price quotes, fast payment, good communication, excellent customer service, and an easy to
use website. By buying and selling used books
6. Login of Administrator.

Administrator module is responsible for managing sales, orders, transactions done by customers. By
means of this admin can evaluate total sales and eventually profit drawn from the website which
makes the website economical and profitable.
7. Login of Registered User.

A registered user can search books, add books to wish list, select books from wish list and add to
shopping cart, check out books from cart and make order and payment of books through Book Cart
8. Register of new account.

New User can save own information by means of database of website so that user’s identity is kept
protected for secure browsing and buying.
9. My account information.

My account information alloes user to edit own information and shop in the website using a secure
ID for ensuring privacy and avoiding theft activities.
10. Search of book list by keyword.

By searching user can shortlist the useful books and select from the search result.
11. Management of wish list by registered user.

Wish list comprises of one more round of shortlisting of books from various modules available in
the website

12. Management of wish list by guest user.

Wish list comprises of one more round of shortlisting of books from various modules available in
the website. The best thing is that you need not be registered to select books and add to wish list.
13. Management of shopping cart by registered user.

Shopping cart lists the books selected to buy by the user.


14. Management of shopping cart by guest user.

Shopping cart lists the books selected to buy by the user. One needs to register to buy a book.
15. Check out of books from shopping cart.

Check out functionality is to buy selected books from the cart after successful regsiteration.

24
16. Logout of registered user.
For a secure connection and browsing, exit functionality is implemented.

4.2Data Design
Designing data is about discovering and completely defining your application's data characteristics
and processes.

4.2.2 Data Integrity and Constraints

CSE BOOK STORE has been entrusted with sensitive, personal data to accomplish its goals. The
success of CSE BOOK STORE depends on the availability, integrity and confidentially of data.
One of the mechanisms to protect data is to implement data integrity and validation controls. Data
integrity controls are used to protect data from accidental or malicious alteration or destruction and
to provide assurance to the user that the information meets the expectations about its quality and
that it has not been altered. Validation controls refer to tests and evaluations used to determine
compliance with security specifications and requirements. To maintain data integrity, I have used
following validations in my code.

1) Reporting errors so that users can contact the account holder and correct, prior to submission.
This saves on unnecessary bank charges for failed transactions.
2) Map a CSE BOOK STORE account holder with a personal ID number or company registration
number
3) Rest assured that the correct legal entity is being debited or credited
4) Check that the information as provided by your client is correct, current and valid
5) Document-type declaration (DTD) must be declared for CSE BOOK STORE.
6) HTML and CSS validations are used so that correct HTML page should be displayed.
7) Only authorized uses can buy books from CSE BOOK STORE.
8) Each user has customer ID created in Database. This id is a email id of user
9) Guest users have separate entry in data bases so that proper record can be maintain.
10) User has to accept privacy policy before performing any transactions.
11) In Registration account, all mandatory fields should be filled before submitting account.

4.3 Procedural Design

25
26
Fig 12. Home Page

Fig 13. Catalogs

27
Fig 14. Check out Page

28
Fig 15. Admin Login Page

29
4.5 Security Issues
1. Hackers can install malware that gets CSE BOOK STORE site
banned from Google and your customer details exposed to
cybercriminals
2. Problems with passwords

Most systems use passwords to restrict access. It is possible to obtain a password in several ways:

 guessing
If you choose a particularly simple password (your mother's maiden name, your pet's name,
your favorite sports team) then people may be able to guess the password
 brute-forcesearch
There are programs which can try many passwords, for example by going through every word in
a dictionary
 social engineering
It is often possible to trick people into revealing passwords, for example by phoning up and
pretending to be the Internet service provider or a member of the company
 obtaining stored passwords
Sometimes people store passwords on their computer, on post-it notes, in their diary, etc. In this
case, the password can easily be obtained by somebody with physical access
 obtaining shared passwords
When the same password is used for several systems, anybody who obtains the password for
one system already has it for all others
 installing trojans
There are 'trojan horse' software programs which install invisibly on your computer, monitoring
keystrokes. These are often associated with computer viruses
 interception
If passwords are sent across an unencrypted connection, it may be possible to intercept the
password as it is transmitted (this is usually a relatively low risk)

Handling Security issues:


1. Using passwords securely

User can avoid these problems by:

 using a good password

Choose a password that is reasonably long (at least 8 characters) and is not made up of simple
words. Use punctuation and numbers if possible

 ensure systems limit password attempts


If possible, make sure that the system allows only a certain number of password attempts
before locking out the account
 not storing passwords
Do not store important passwords on your computer, or write them down
 not sharing passwords
Use different passwords for all important systems
 never giving out passwords
Do not give out your password to anybody
30
 maintaining general levels of computer security
Use a virus checker and ensure that your email program is configured securely and kept up to
date
 using secure connections for passwords
Make sure that passwords are sent across secure connections so that they cannot be intercepted
in transit

2. Detects malware present on CSE BOOK STORE website.


3. Audits CSE BOOK STORE website for security issues.
4. Daily website backups.
5. Avoid getting blacklisted by Google.
6. Keep your website content and customer data safe.
7. Get alerted to suspicious hacker activity.
8. Securing information in transit
9. Reducing consequences of failure
10. Hiding Credit card details by not saving it in database.

4.6 Test case Design

31
Test
S.N Descriptio Pre- Expected Actual
Case Steps Status
o n condition Result Result
ID
TC_1 Verify 1.Applicatio 1. Start “Home” Same as Pass
functionalit n should be browser. page Expected
y of added in 2. Enter should be
“Home Wamp server url displayed.
1. “button folder. 3. Tap on
2. Home “Home”
screen button
should be
displayed
TC_2 Verify 1.Applicatio 1. Start “Account Same as Pass
functionalit n should be browser. Login” Expected
y of “wish added in 2. Enter page
list” button Wamp server url should be
2. folder. 3. Tap on displayed.
2. Home “Wish
screen List”
should be button
displayed
TC_3 Verify 1.Applicatio 1. Start “Account Same as Pass
functionalit n should be browser. Login” Expected
y of “My added in 2. Enter page
Account” Wamp server url should be
3. button folder. 3. Tap on displayed.
2. Home “My
screen Account”
should be button
displayed
TC_4 Verify 1.Applicatio 1. Start Shopping Same as Pass
functionalit n should be browser. cart” page Expected
y of added in 2. Enter should be
“Shopping Wamp server url dplayed.
4. cart” folder. 3. Tap on
button 2. Home “Shoppin
screen g cart”
should be button
displayed
TC_5 Verify 1.Applicatio 1. Start “Checkou Same as Pass
functionalit n should be browser. t” page Expected
y of added in 2. Enter should be
“Checkout Wamp server url displayed
5. ” button folder. 3. Tap on
2. Home “Checkou
screen t” button
should be
displayed
6. TC_6 Verify 1.Applicatio 1. Start “Register Same as Pass
functionalit n should be browser. Account” Expected
y of added in 2. Enter page
“Create an Wamp server url should be
account” folder. 3. Create displayed.
32
button 2. Home an
screen account”
should be button
displayed
TC_7 Verify 1.Applicatio 1. Start “Account Same as Pass
functionalit n should be browser. Login” Expected
y of added in 2. Enter page
“Login” Wamp server url should be
7. button folder. 3. Tap on displayed.
2. Home “Login”
screen button
should be
displayed
TC_8 Verify 1.Applicatio 1. Start Currency Same as Pass
functionalit n should be browser. should be Expected
y of added in 2. Enter changed
“Currency” Wamp server url to
8. button folder. 3. Tap on dollor/pou
2. Home currency nd/euro
screen “Dollar/P
should be ound
displayed Euro”.

33
CHAPTER 5: IMPLEMENTATION AND TESTING

34
CHAPTER 5: IMPLEMENTATION AND TESTING

5.1 Implementation Approaches

CSE BOOK STORE application is a web based application which requires to review and test a
code every time so that quality and expected result can be obtained from efficient code
implementation. Hence, We used waterfall model for the implementation of this project so that
proper project can be implemented under guidance.

Requirements

Design

Implementation

Verification

Maintenance

Fig 17. Waterfall Model

The waterfall model is a sequential design process, often used in software development processes,
in which progress is seen as flowing steadily downwards (like a waterfall) through the phases of
Conception, Initiation, Analysis, Design, Construction, Testing, Production/Implementation, and
Maintenance. The waterfall development model originates in the manufacturing and construction
industries; highly structured physical environments in which after-the-fact changes are prohibitively
costly, if not impossible. Since no formal software development methodologies existed at the time,
this hardware-oriented model was simply adapted for software development

35
5.2 Coding Details and Code Efficiency

5.2.1 Coding Details

Registration Screen:

registration.php

<?php
class Controller Account Register extends Controller {
private $error = array();

public function index() {


if ($this->customer->is Logged()) {
$this->redirect($this->url->link('account/account', '', 'SSL'));
}

$this->language->load('account/register');

$this->document->setTitle($this->language->get('heading_title'));
$this->document->addScript('catalog/view/javascript/jquery/colorbox/jquery.colorbox-min.js');
$this->document->addStyle('catalog/view/javascript/jquery/colorbox/colorbox.css');

$this->load->model('account/customer');

if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validate()) {


$this->model_account_customer->addCustomer($this->request->post);

$this->customer->login($this->request->post['email'], $this->request->post['password']);

unset($this->session->data['guest']);

// Default Shipping Address


if ($this->config->get('config_tax_customer') == 'shipping') {
$this->session->data['shipping_country_id'] = $this->request->post['country_id'];
$this->session->data['shipping_zone_id'] = $this->request->post['zone_id'];
$this->session->data['shipping_postcode'] = $this->request->post['postcode'];
}

// Default Payment Address


if ($this->config->get('config_tax_customer') == 'payment') {
$this->session->data['payment_country_id'] = $this->request->post['country_id'];
$this->session->data['payment_zone_id'] = $this->request->post['zone_id'];
}

$this->redirect($this->url->link('account/success'));
}

36
$this->data['breadcrumbs'] = array();

$this->data['breadcrumbs'][] = array(
'text' => $this->language->get('text_home'),
'href' => $this->url->link('common/home'),
'separator' => false
);

$this->data['breadcrumbs'][] = array(
'text' => $this->language->get('text_account'),
'href' => $this->url->link('account/account', '', 'SSL'),
'separator' => $this->language->get('text_separator')
);

$this->data['breadcrumbs'][] = array(
'text' => $this->language->get('text_register'),
'href' => $this->url->link('account/register', '', 'SSL'),
'separator' => $this->language->get('text_separator')
);

$this->data['heading_title'] = $this->language->get('heading_title');

$this->data['text_account_already'] = sprintf($this->language->get('text_account_already'), $this-


>url->link('account/login', '', 'SSL'));
$this->data['text_your_details'] = $this->language->get('text_your_details');
$this->data['text_your_address'] = $this->language->get('text_your_address');
$this->data['text_your_password'] = $this->language->get('text_your_password');
$this->data['text_newsletter'] = $this->language->get('text_newsletter');
$this->data['text_yes'] = $this->language->get('text_yes');
$this->data['text_no'] = $this->language->get('text_no');
$this->data['text_select'] = $this->language->get('text_select');
$this->data['text_none'] = $this->language->get('text_none');

$this->data['entry_firstname'] = $this->language->get('entry_firstname');
$this->data['entry_lastname'] = $this->language->get('entry_lastname');
$this->data['entry_email'] = $this->language->get('entry_email');
$this->data['entry_telephone'] = $this->language->get('entry_telephone');
$this->data['entry_fax'] = $this->language->get('entry_fax');
$this->data['entry_company'] = $this->language->get('entry_company');
$this->data['entry_customer_group'] = $this->language->get('entry_customer_group');
$this->data['entry_company_id'] = $this->language->get('entry_company_id');
$this->data['entry_tax_id'] = $this->language->get('entry_tax_id');
$this->data['entry_address_1'] = $this->language->get('entry_address_1');
$this->data['entry_address_2'] = $this->language->get('entry_address_2');
$this->data['entry_postcode'] = $this->language->get('entry_postcode');
$this->data['entry_city'] = $this->language->get('entry_city');
$this->data['entry_country'] = $this->language->get('entry_country');
$this->data['entry_zone'] = $this->language->get('entry_zone');
$this->data['entry_newsletter'] = $this->language->get('entry_newsletter');
$this->data['entry_password'] = $this->language->get('entry_password');
37
$this->data['entry_confirm'] = $this->language->get('entry_confirm');

$this->data['button_continue'] = $this->language->get('button_continue');

if (isset($this->error['warning'])) {
$this->data['error_warning'] = $this->error['warning'];
} else {
$this->data['error_warning'] = '';
}

if (isset($this->error['firstname'])) {
$this->data['error_firstname'] = $this->error['firstname'];
} else {
$this->data['error_firstname'] = '';
}

if (isset($this->error['lastname'])) {
$this->data['error_lastname'] = $this->error['lastname'];
} else {
$this->data['error_lastname'] = '';
}

if (isset($this->error['email'])) {
$this->data['error_email'] = $this->error['email'];
} else {
$this->data['error_email'] = '';
}

if (isset($this->error['telephone'])) {
$this->data['error_telephone'] = $this->error['telephone'];
} else {
$this->data['error_telephone'] = '';
}

if (isset($this->error['password'])) {
$this->data['error_password'] = $this->error['password'];
} else {
$this->data['error_password'] = '';
}

if (isset($this->error['confirm'])) {
$this->data['error_confirm'] = $this->error['confirm'];
} else {
$this->data['error_confirm'] = '';
}

if (is_array($this->config->get('config_customer_group_display'))) {
$customer_groups = $this->model_account_customer_group->getCustomerGroups();

38
foreach ($customer_groups as $customer_group) {
if (in_array($customer_group['customer_group_id'], $this->config-
>get('config_customer_group_display'))) {
$this->data['customer_groups'][] = $customer_group;
}
}
}

if (isset($this->request->post['customer_group_id'])) {
$this->data['customer_group_id'] = $this->request->post['customer_group_id'];
} else {
$this->data['customer_group_id'] = $this->config->get('config_customer_group_id');
}

// Company ID
if (isset($this->request->post['company_id'])) {
$this->data['company_id'] = $this->request->post['company_id'];
} else {
$this->data['company_id'] = '';
}

// Tax ID
if (isset($this->request->post['tax_id'])) {
$this->data['tax_id'] = $this->request->post['tax_id'];
} else {
$this->data['tax_id'] = '';
}

if (isset($this->request->post['address_1'])) {
$this->data['address_1'] = $this->request->post['address_1'];
} else {
$this->data['address_1'] = '';
}

if (isset($this->request->post['address_2'])) {
$this->data['address_2'] = $this->request->post['address_2'];
} else {
$this->data['address_2'] = '';
}

if (isset($this->request->post['postcode'])) {
$this->data['postcode'] = $this->request->post['postcode'];
} elseif (isset($this->session->data['shipping_postcode'])) {
$this->data['postcode'] = $this->session->data['shipping_postcode'];
} else {
$this->data['postcode'] = '';
}

if (isset($this->request->post['city'])) {
$this->data['city'] = $this->request->post['city'];
39
} else {
$this->data['city'] = '';
}

if (isset($this->request->post['country_id'])) {
$this->data['country_id'] = $this->request->post['country_id'];
} elseif (isset($this->session->data['shipping_country_id'])) {
$this->data['country_id'] = $this->session->data['shipping_country_id'];
} else {
$this->data['country_id'] = $this->config->get('config_country_id');
}

if (isset($this->request->post['zone_id'])) {
$this->data['zone_id'] = $this->request->post['zone_id'];
} elseif (isset($this->session->data['shipping_zone_id'])) {
$this->data['zone_id'] = $this->session->data['shipping_zone_id'];
} else {
$this->data['zone_id'] = '';
}

$this->load->model('localisation/country');

$this->response->setOutput($this->render());
}

protected function validate() {


if ((utf8_strlen($this->request->post['firstname']) < 1) || (utf8_strlen($this->request-
>post['firstname']) > 32)) {
$this->error['firstname'] = $this->language->get('error_firstname');
}
$this->load->model('localisation/zone');

$json = array(
'country_id' => $country_info['country_id'],
'name' => $country_info['name'],
'iso_code_2' => $country_info['iso_code_2'],
'iso_code_3' => $country_info['iso_code_3'],
'address_format' => $country_info['address_format'],
'postcode_required' => $country_info['postcode_required'],
'zone' => $this->model_localisation_zone->getZonesByCountryId($this->request-
>get['country_id']),
'status' => $country_info['status']
);
}

$this->response->setOutput(json_encode($json));
}
}
?>
40
?>

5.2.2 Code Efficiency

CSE BOOK STORE application is based on MVC architecture. Model–view–controller (MVC) is a


software architecture pattern which separates the representation of information from the user's
interaction with it. There is usually a kind of hierarchy in the MVC pattern. The Model knows only
about itself. That is, the source code of the Model has no references to either the View or Controller.

The View however, knows about the Model. It will poll the Model about the state, to know what to
display. That way, the View can display something that is based on what the Model has done. But
the View knows nothing about the Controller.

The Controller knows about both the Model and the View. To take an example from a game: If you
click on the "fire" button on the mouse, the Controller knows what fire function in the Model to
call. If you press the button for switching between first and third person, the Controller knows what
function in the View to call to request the display change.

The reason to keep it this way is to minimize dependencies. No matter how the View class is
modified, the Model will still work. Even if the system is moved from a desktop operating system to
a smart phone, the Model can be moved with no changes. But the View probably needs to be
updated, as will the Controller.

- Substitutable user interface :


Different views and controllers can be substituted to provide alternate user interfaces for the same
model.

- User interface components:


Because MVC demands that the user interface of an application be structured into a hierarchy of
objects and defines a standard relationship between these objects, generic versions of these objects
are possible. They are usually called user interface components and no modern GUI environment is
without a full complement of them usually combining view and controller into a single object.

- Multiple simultaneous views of the same model :


Multiple different views can be active at the same time. Each view simultaneously and
independently presents the same information from the model.

- Synchronized views :
The change propagation mechanism insures that all views simultaneously reflect the current state of
the model.

- Easier user interface changes :


Changes affecting just the user interface of the application logic become easier to make.
- Easier testing :
With MVC it can be easier to test the core of the application, as encapsulated by the model.
41
5.3 Modification and Improvements

Like any other application CSE BOOK STORE has a great scope of evolving in the future. The
application will also have a desktop widget which will show the current status of the book on the
desktop to prevent frequent login. Also a mobile version of the application is proposed which
would run on Windows Mobile platform which would enhance the portability as well as flexibility.

There are following things are still need to modify or improved.


(1) Application supports e-commerce and e- payment system but it requires payment
gateway to start application as it should work.
(2) Implementation of mobile version for the CSE BOOK STORE.
(3) Implementation of CSE BOOK STORE widget.
(4) Improvement in UI to make website more user friendly.

42
CHAPTER 6: RESULT AND DISCUSSION

43
CHAPTER 6: RESULT AND DISCUSSION

6.1 Test Reports


On the basis of test case, the application is working properly. I am getting same output
as input given by me. Still there are some limitations due to which bank transaction
and book cannot be bought.

6.2 User Documentation

Diagram above is the home screen of CSE BOOK STORE Application. It has following parts:
1. Search
2. Currency
3. Create an account and login
4. My Account
5. Wish list
6. Shopping cart
7. Checkout
8. Featured
9. Publisher
10. Information
11. Customer Service
12. Extras
13. My account

1. Search : User can search for any book by entering text in search field and corresponding search
result will be displayed.

44
2. Currency : There are three different types of currency converter are displayed.
(a) Euro
(b) Pound
(c) Dollor
By default, all prices will be displayed in dollor. By clicking any of the
above currency, user can see desired currency format.

3. Create an account and login : If users are not registered then to do shopping , they need to
register themselves. When user click on create an account then Registration page will open and
all information will be stored in database. If users are already registered then they need to click
on login where they can enter username and password for shopping.

4. My Account: By clicking on My account, users can do login and see their purchase history .

5. Wish List: It could be possible that users cannot get books for which they looking for. By
clicking on wish list, users can add their desired books and CSE BOOK STORE admin will
inform him through mail that book can be arranged or not.

6. Shopping cart: When users click on shopping cart then it will indirect to a page where users
can see shopped items and by clicking continue button, users can complete shopping process.

7. Checkout: When users will click on checkout button then it will indirect to checkout page from
where they can continue shopping.

8. Featured: Featured will display favorite or in demand books.

9. Publisher: It will display list publishers whom books are available on CSE BOOK STORE. By
clicking on any publisher, it will display corresponding publisher’s page and books.

10. Information: Information page contains following links:

 About us: About us page will contain information about CSE BOOK STORE.
 Delivery information : Delivery information page will contain information about delivery
reports.
 Privacy policy: Privacy policy page will contain policies that CSE BOOK STORE follow
to maintain integrity and confidentiality of data.
 Terms & Conditions: This page will include terms and conditions that users have to follow.

11. Customer Service: Customer service page contains following links:

 Contact us: If users want to contact with CSE BOOK STORE admin then they can click on
Contact us to get contact details.
 Returns: If users want to return book then they need to fill their details in Returns page.
 Site map: Site map will display the locations where CSE BOOK STORE office is available.
45
12. Extras: Extras page contains following links:

 Brands: By clicking on brands link, users can get info about brands which support CSE
BOOK STORE site.
 Gift Vouchers: By clicking on Gift voucher link, users can get info about Gift vouchers
available for shopping.
 Affiliates: By clicking on affiliates link, users will redirect to affiliated .
a. Specials: This page will info about special books and events.

13. My account: My Account page contains following links:

 My Account: By clicking on My account, users can do login and see their purchase
history .
 Order History : Users can get to know about their order history by clicking on order
history.
 Wish list: It could be possible that users cannot get books for which they looking for. By
clicking on wish list, users can add their desired books and CSE BOOK STORE admin will
inform him through mail that book can be arranged or not.
 Newsletter: This page will include news related to books and users can subscribe for news
by filling their detail.

46
CHAPTER 7: CONCLUSION

47
CHAPTER 7: CONCLUSION

7.1 Conclusion
CSE BOOK STORE has been entrusted with sensitive, personal data to accomplish its goals. The
success of CSE BOOK STORE depends on the availability, integrity and confidentially of data.
One of the mechanisms to protect data is to implement data integrity and validation controls. Data
integrity controls are used to protect data from accidental or malicious alteration or destruction and
to provide assurance to the user that the information meets the expectations about its quality and
that it has not been altered

7.2 Limitation of the System


Our study showed us that it would be really difficult for us to develop a “CSE BOOK STORE with
all features due to the time constraint as well as provide facility of e-commerce because for e-
commerce, admin requires internet certifications.

7.3 Future Scope of the Project


The functionality that we were going to implement in our “CSE BOOK STORE Application” are
home screen and admin page, mobile simulator for using application on mobile and desktop widget.

48
REFERENCES

Bibliography:

1. Html Black Book by Steven Holzner


2. CSS: The Definitive Guide by Ryan Moore and Darren Lutz
3. Visual Studio Tools for Office 2007 by Eric Carter, Eric Lippert
4. Beginning Silverlight 3 by Robert Lair
5. SQLite by Matthew MacDonald
6. Microsoft SQL Server 2008 For Dummies by Mike Chapple

Websites :
1. http://en.wikipedia.org/wiki/PHP

2. http://in.php.net/

3. http://www.w3schools.com/php/default.asp

4. http://www.sqlite.org/
5. http://en.wikipedia.org/wiki/SQLite

6. http://www.functionx.com/sqlserver/

7. http://www.quackit.com/sql_server/tutorial/

8. http://www.tutorialized.com/tutorials/MsSQL/1

49

You might also like