Posted: July 3rd, 2015

Entity relationship diagram, sequence diagram, class diagram

Entity relationship diagram, sequence diagram, class diagram

Project description
ERD, Sequence and Class diagram required to be made for my project
———-
Added on 02.07.2015 14:46
it show the structure of my website and how it is built.

Foreword
The system is an online store. It includes the main modules and components necessary for the online store. Below is a complete description of the system. On the software side are fully completed by hand from 0. He used the most current and popular programming languages and technologies that nowadays the correct functioning of the site. Currently the system is fully tested and designed to make the customer aware of all its components. Any modification of the system components / Add / Remove available as soon as possible. Test and also added a bit of information about information. The system consists of two sides:
1. Management System
Website contents of which are managed, what is visible to users of the site. Products, description, texts, and all other components are held slideshow from the management system.
2. The user side
In this module, the user interacts with the site, browsing the various products registered, go through the authorization, buying products, etc ..

Key technologies
PHP, MYSQL, HTML, JAVASCRIPT, JQUERY, CSS
1. PHP
The main site is the programming language PHP. Through it all happens in a major operation. For example, the user runs the authorization / registration, browsing, buying products and pursuing a variety of activities, this will provide the programming language PHP. It interacts with databases, stores, better modification and deletes the information from the databases. It may be a basic life-giving nucleus PHP- vutsudot site. Is practically impossible without the creation of an interactive website.

2. MYSQL (databases)
Any information stored on the website MYSQL databases. Information in the database is distributed to different tables that are connected together. Text pages, product information, information about the slide, the information about users, sales of existing information stored in the database and another for the rest of the tables. More detailed information about the tables in the database will be down.

3. HTML (Hyper Text Markup Language)
This is the Hypertext Markup Language, PHP and MYSQL Site operations can not see, these operations are carried out systematically on the server, and returns a response to the browser HTML code in the browser and shows the transformation of the customer. In other words, HTML is fully responsible for the visual side. HTML is a static code that comes in your browser.

4. JAVASCRIPT
This is a scripting programming language that is used and the site makes it more interactive with HTML-. For example, with its help, we can send and receive mail without having to re-boot the information, do the menu system, slide show, and more. JAVASCRIPT more vibrant and easier to use a Web site. As mentioned above, HTML is static, it can not create the rolling elements. All this provides JAVASCRIPT.

5. JQUERY
This is JAVASCRIPT-‘s library, which makes things easier for programmers and JAVASCRIPT- capability allows for widespread use. The single can be created in different directions JAVASCRIPT- use.

6. CSS
It is responsible for the visual side. HTML code into different visual angles. Can HTML elements (tags) to move the desired shapes, sizes, colors, and to many other things. CSS is not possible without creating normal and beautiful site.

Site structure

The website consists of the following basic and essential modules:
1. Login
2. Register
3. Personal Cabinet
4. Purchase Cart
5. The system of favorites
6. Purchased Products
7. The text pages
8. Product Pages
9. The product detail page
10. The filtration product category, keyword and other parameters.
11. Contact form
12. Slideshow
All modules are managed from the management system.

Content Management System
Management system after the main navigation menu on the left side.
In each sub-menu and then click opens where you can be 1 or two points, the module for this purpose. Let’s review each of them.

We have:
1. Product Management Module
2. User Modules
3. Text pages Management Module
4. stats page
5. System Settings
6. Slide Management
7. The control system, the username and password to edit a page

Add product

Added to fill the page can be found in the following fields:
Title – the title of the product
Category – Category
Visibility – The products to be displayed or not (maybe just add a management system products and temporarily hide users)
Selling price – Sale price
Pictures – pictures of a maximum of 6 pieces
Description – the product description.

After you click the Add button and fill in all of the products will be added. After moving to the product listing page.

Listed products

Here is the complete list of the products that we have. They can delete or edit the single buttons. She becomes easy to edit and delete.

For example, we can install additional options to edit a page from the product color, size, etc ..

Sold products

This page shows all the products sold, who bought what I bought, how much was paid, etc ..

Users
There seems to be much momkhamrebelia registered in the system, their name, email address and date of registration.

Add text page
From here we can add a new text pages. There are two simple field, a text page title and body text.

Existing text pages
This page lists all the text page that is added to the system.
It is their deletion and editing keys. Also link field, this field can copy and use the link on our website at will.
View statistics
This is where the simple statistics page displays information about the number of products, their sales and consumers.

System parameters

This is a basic system settings page. Which is written:
Site title – Site Title
Site description – Site Description
Site off – site circuit shutdown
Site off reason – the reason for the shutdown
Email – e-mail, where the row of letters sent by users or other messages as needed.

Slideshow

Add this page from the slideshow and management.

Redact user and password

Edit the username and password.

Database tables and structure
Database consists of 12 tables on it.

1. cart
2. category
3. dinamic_banners
4. favorites
5. orders
6. parameters
7. products
8. product_options
9. sold
10. text_pages
11. users
12. log

1. cart – customers buying a basket Table
id
user¬_id
product_id
price
order_id
quantity
product_options
add_date

2. category – Category Table
id
title
position
3. dinamic_banners – slide table
id
title
content

4. favorites – consumers of the products stored in the table’s favorites
id
user_id
pruduct_id
add_date
5. log – systematic errors and other information to feed table
id
log_text
log_date

6. orders – Procurement Support for table
id
user_id
paymentmethod
amount
status
orderdate

7. parameters – system settings table
id
title
description
site_off
site_off_reason
mail
option_1
option_2
option_3
option_4
option_5
option_6
option_7
option_8
option_9
option_10
option_11
option_12
option_13
last_update

8. product_options – products with additional options to the table
id
parent_id
product_id
title

9. products – Product Table
id
category
visibility
position
title
description
price
photo_1
photo_2
photo_3
photo_4
photo_5
photo_6
sold_count
add_date

10. sold – sold products Table
id
user_id
product_id
order_id
quantity
product_options
payment_method
price
transfer_time

11. text_pages – text pages Table
id
title
text
12. users – users Table
id
firstname
lastname
gender
email
pass
birthdate
regdate