ProjectINT303WebProg : JKT Shop

Initial Project

To begin this project:

Clone the repo: https://github.com/safesit23/ProjectINT303WebProg.git

Project Structure

ProjectINT303WebProg/
└── databaseJKT.sql
└── ProjectJKTShop/
    ├── web/
    │   ├── css             : เขียน css
    │   ├── bootstrap
    │   ├── images/
    |   |      ├── content  : เก็บภาพที่ใช้ตามหน้าต่างๆ
    |   |      ├── carousel : เก็บภาพ Promotion
    |   |      └── shoes    : เก็บภาพสินค้าทั้งหมด
    │   ├── include/
    |   |      ├── header.jsp
    |   |      ├── navbar.jsp
    |   |      └── footer.jsp
    │   ├── index.jsp
    │   └── Page.jsp       (หน้า JSP ทุกหน้า)
    └── src/java/
        ├── model
        ├── servlet
        └── controller

Database

Database Name: projectint303
UserName/Password: app
Execute SQL Command sql: databaseJKT

Table

Have 6 Table:

Account
shoe
sizeSpecific
orders
orderDetail
voucher

Data

Account

Username: test@test.com
Password: test

Shoe

Brand: nike, adidas, fila, skechers, new balance
Insert ('shoeId','shoeName','color','type','type2','brand','price')
example : ('NI001SH200','NikeAir','black','running','MEN','nike',3000)

SizeSpecific

example : ('NI001SH200',7)

Voucher Table

example : insert into voucher(voucherId,voucherValue,minSpend) values ('NEW100',100,1500);

TOOLS (For project)

Material

for icon in website

Example: <i class="material-icons">person</i>
Change color to white: class="md-light"

fontawesome

Bootstrap v4.1.3

Development & Product Management

Sourcetree or GithubDesktop

Allow to use Branch DEV Only
Every Commit must have prefix

[ADD] for add new file
[UPDATE] for edit in file (add/update/remove code)
[REMOVE] for remove file

Should commit-->pull-->config-->commt-->push

Trello

for viewing todolist that you must be done

Now has 6 list : todopage,todo, doing, done, problem, resolve problem
color : RED-hard, Orange-normal, Green-Easy, Violet-Important
You can move card to update work

Figma

for watching wireframe of this web site.

Google Drive

for upload picture or add file if you cannot use git and use to write Proposal document

safesit23/ProjectINT303WebProg