TRlTCfNG DAI HOC AN GIANG
KHOA KY THUAT - CONG NGHE - MOI TRU^NG

NGUYEN THANH PHUC

KHOA LUAN TOTNGHIgP DAI HOC NGANH C^NHAN TIN HQC

XAYDlTNG
WEBSITE QUAN LY CONG VAN
KHOA KY THUAT-CONG NGHE-MOI TRl/CXNG

TRUC5NG DAI HQC
AN GIANG

THUVIEN

GV. hirdng din
Ths. Nguyen Thai Du

An Giang, 05/2006


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trirfrng

Loi noi dau
Ngay nay tin hoc ngay cang khong the thiiu trong moi linh vuc ciia Sai song.
Trong So cong nghe Web ngay cang Suac phdt triin ring rai, nha veto mang
Internet sir hiiu biit ciia con nguai ngay cang Suac nang cao bai khong can phdi
Si ddu xa chi cdn co may tinh vd mang Internet chung ta se dm thdy Suac vo van
thong tin can muon co.

Vai su ho tra cua thdy co khoa Ky Thuat - Cong Nghe - Moi Truang, em S3 co ca
hoi Suac dm hieu va thuc hien viec xay dung Website quan ly cong van khoa Ky
Thuat - Cong Nghe - Moi Truang. Mac dii Suac su giup So nhiet tinh ciia ede thdy^
ede co nhung do hqn chi ve quy thai gian cung nhu khd nang lap trinh vd thieu
kinh nghiem trong viec tqo ra mot Website hodn chinh nen khong trdnh khoi nhung
sai sot nhdt Sinh, kinh mong quy thdy co quan tarn giup So.
Nhdn Say em cungxingai lai cam an chdn thdnh Sen:
Ban Gidm Hieu Truang Dai Hoc An Giang, cung thdy co khoa Ky Thuat - Cong
Nghe - Moi Truang S3 quan tarn vd tqo Sieu kien hoc tap tot cho chung em!
Cdc thdy, co khoa Ky Thuat - Cong Nghe- Moi Truang vd ede thdy, co truang Dai
hoc Khoa hoc Tu nhien S3 tan tarn truyen Sat kien thuc cho chung em trong suit
qua trinh hoc tap!
Thdy Nguyen Thai Du, nguai true dip huang dan vd giup da em hodn thdnh Si tdi

nay!

Trdn trong!

Sinh viin: Nguyin Thanh Phuc.

SVTH: Nguyin Thanh Phuc

MSSV: DTH021757


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trufrng

Tom t^t
•Ten de tai: Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Truong,
trubng Dai Hoc An Giang.

•JVipi dung: Tim hiSu cong tac quan ly Cong van cua Khoa Ky Thuat - Cong Nghe - Moi
Trudng, truong Dai Hoc An Giang, phan tich va thiet ke he thong de xay dung Website quan ly
cong van vdi cac noi dung chu yeu sau:
>Doi voi can bo quan ly:
•Upload cong van:
o Chung.
o Cho doi tuong cu the.
•Siia cong van.
•Xoa cong van.

•Tim kiem cong van duavao:
o Loai cong van. -

o Ngayden.
o Ngaydi.
o ...

•Phan quyen.
•Bao mat.

^ Doi vdi cac giang vien va sinh vien:
•Download cong van ve.
•Xem cong van.

•Tim kiem cong van.
•YSu chu:
^ Tim hieu cac van de ly thuyet lien quan.
>Tim higu he thdng va phan tich yeu c^u.

>Phan tich va thi^t kg he thdng.

>Xay dung Website.
•Moi trwimg thuc Men:

>Ngon ngu phan tich va thiet ke: UML (Unified Modeling Language).
>Ngon ngu lap trinh viet cho Web: PHP (version 5.0.5).
>He quan tri ca sd du lieu: MySQL Server (version 5.0).

SVTH: Nguyln Thanh Phuc

MSSV: DTH021757


Xay dyng Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Tru-frng

MUC LUC
Chuang 1. Tong quan ve quan ly cong van2
1.Gidi thieu cong tac quan ly cong van2
2.Hien trang quan ly cong van khoa Ky Thuat- Cong Nghe - Moi Truang3

Chuang 2. Phan tich va thiet kg he thgng4
1.Cong cu va moi trudng phat trien4

1.1.Gidi thieu so luge ve UML(Unified Modeling Language)4
1.2.Cac mo hinh true quan vai UML5
1.3.He quantri ca so dtr lieu va moi truang cai dat7
2.Phan tich.'.'.'.7

2.1.Hien trang Khoa Ky Thuat r- Cong Nghe - Moi Truang7

2.2.Vln dh cln giai quySt8

2.3.Yeu c^u dugc dat ra (Website c^n phai lam nhung gi)8
2.4.Mo hinh quan niem xu ly he thong8
2.5.Mo hinh ky thuat9
3.Thi^tk^'."10
3.1.Mo hinh chuc nang ciia Website10
3.2.So d6 kign true11
3.3.Thigt kg xtr ly12
3.4.Thigt kg ca sd dd lieu46
Chuang 3. Demo50
1.Mo ta vg hoat dong ciia trang web50
2.Man hinh dang nhap51
3.Trang quan ly thong tin ngudi dung:52
4.Trang quanly cong van53
5.Trang thgm nidi cong van.-.54
6.Trang tint kigm cong van55

SVTH: Nguyln Thanh Phuc

MSSV: DTH021757


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trirfrng

Danh sach cac hinh

Hinh 2.1 Mo hinh true quan hoa voi UML4
Hinh 2.2 Mo hinh quan niem x^ ly^9

Hinh 2.3 Mo hinh ky thuat9
Hinh 2.4 So do cau tnic chitc nang cua he thong10

Hinh 2.5 So d6 lien ket cac trang11
Hinh 2.6 So d6 kiln true.II
Hinh 2.7 Mo hinh chuc nang cua he thing12

Hinh 2.8 So dl lop cho xir ly Bang Nhap13
Hinh 2.9 So dl tuan tu cho xu ly Bang Nhap15

Hinh 2.10 So dl hop tac cho xu ly Bang Nhap16
Hinh 2.11 So dl lop cho xir ly Them Cong Van...17

Hinh 2.12 So dl tuan tu cho xir ty Them Cong Van19
Hinh 2.13 Sodl cong tac cho xir ly them cong van20

Hinh 2.14 So dl lop cho khli xir ly quan ly cong van21
Hinh 2.15 So do tuan tu cho xir ly chinh sira cong van23
Hinh 2.16 So dl hep tac cho xir ly chinh sira cong van24
Hinh 2.17 So dl tuln tu cho xu ly xoa cong van26
Hinh 2.18 So do hop tac cho xu ly xoa cong van27
Hinh 2.19 So do man tu cho xirly xem cong van:29
Hinh 2.20 So dl hop tac cho xir ly xem cong van30
Hinh 2.21 So d6 tu!n tu cho xir ly tai cong van32
Hinh 2.22 So do hop tac cho xir ly tai cong van33

Hinh 2.23 So do lop cho xir ^^ tim kilm cong van34
Hinh 2.24 So d6 man tu cho xu ty tim kilm cong van36
Hinh 2.25 So d6 hop tac cho xir ty tim kilm cong van.....37

Hinh 2.26 So do lop cho khoi xir ty nguoi dung38 Hinh 2.27 So d6 man tu cho xir ty d6i mat khau40
Hinh 2.28 So d6 hep tac cho xir ty dli mat kh^u41
Hinh 2.29 So do man tu cho xir ty phan quyen nguoi dimg43

Hinh 2.30 So do hop tac cho xir ty phan quyen nguoi dimg44
Hinh 2.31 Mo hinh lop tong quat45
Hinh 3.1 So d6 ting quan ve hoat dong cua trang web50
Hinh 3.2 Trang index.php?act=dangnhap51
Hinh 3:3 Man hinh sau khi dang nhap thanh cong51

Hinh 3.4 Man hinh quan ty thong tin nguoi dung52
Hinh 3.5 Man hinh quan ty cong van53
Hinh 3.6 Man hinh them moi cong van54
Hinh 3.7 Man hinh tim kilm cong van55

SVTH: Nguyen Thanh Phiic

MSSV: DTH021757


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trufrng

Chwmg 1. Tong quan ve quan ly cong van
1. Gioi thieu cong tac quan ly cong van
Cong tac quan ly cong van la mot hoat dong can thiet trong viec quan \y va phd bien cac
chu truang chihh sach cua dang va phap luat cua nha nude, no dugc a^ dung doi voi cac ca quan
nha nude, to chiic xa hoi, to chiic xa hpi-nghe nghiep, to chile kinh te, ... (sau day goi chung la
ca quan va to chiic).
^ Cong tac quan ly cong van bao gom cac cong viec sau day:
•Soan thao van ban.
•Ban hanh van ban.

•Chuyen cong van di.
•Nhan cong van d^n.

•Luu tru van ban.

•Nhan ban (ban sao).
>• Tilp nhan cong van din
Tat ca cong van den dlu phai thong qua bo phan van thu de chuyen cho doi tuong
nhan (neu co) dong thai de tien hanh luu tru lai tien cho viec thong ke va tim kiem sau nay khi co
van de phat sinh.
Khi tiep nhan cong van cln phai dong dau de xac nhan da qua bo phan van thu.
^• Chuyen cong van di
Tat ca cong van di phai thong qua bo phan van thu de tien hanh kiem tra tinh chinh
xac cua van ban ban hanh nhu: ky hieu, nai nhan, ngay thang, ten ca quan to chile ban hanh van
ban (tru truang hap doi vdi luat va phap lenh), the thiic trinh bay van ban phu hop vdi hinh thiic

van ban dugc sii dung (dugc quy dinh tat Nghi dinh si 110/2004/NB-CP ngay 08 thang 04 nam
2004 cua Chinh phu vl cong tac van thu), ...
Boi vai cong van di can luu lai hai ban, mot luu tai nod ban hanh cong van, mot luu tai
bo phan van thu de tien viec tra ciiu va phuc vu khi sau nay can den.
> Cong tac luu trQ
Luu tr& la cat gitJ cac loai giay ta vao trong kho de cd the sir dung lai sau nay khi can.
Khi luu trft can phan loai, va xac djnh gia tri cua cac loai van ban de tir do vdi moi
loai se cd che do luu tru, bao quan khac nhau.

SVTH: Nguyen Thanh Phuc

MSSV: DTH021757


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trirbmg

2. Hien trang quan ly cong van khoa Ky Thuat - Cong Nghe - Moi

Trirdug
Viec quan ly cong van khoa Ky Thuat - Cong Nghe - Moi Truong la nhiem vu cua bp
phan van thu khoa, tit ca c&c loai cong van den va di cua khoa phai thong qua bo phan van thu de
tien hanh kiem tra, phan loai va luu tru: lai.
Bang liru tru cac cong van din va di dugc luu theo mlu sau vao so:
Ky hieu cong

Ngay

Tom

van

Tinh
chat

NgirM

Cong

(Han

van den

tra

dupe
chuyen

tat


nhan
cong

s6

Ngay

van

cong

cong

van

van

noi
dung

Noi lira

Noi goi

Ngay

Ghi

chuyen


clni

lbi)

(loai
cong
van)

Bang 1.1 Bang liru tru* cong van khoa

> Chiic nang cua bo phan van thu khoa
•Tiep nhan va xu ly cac loai van ban den va di theo qui trinh va thu tuc hanh chinh.
•Ban hanh cac loai van ban theo yeu cau cong tac.
^* Nhiem vu cua bo phan van thu khoa
•Lap ho so luu tru* va tien hanh luu tru* cac loai van ban den va di.
•Chuyen cac loai van ban lien quan den doi tucmg cu the trong khoa neu la cac loai van
ban den va chuyen cho ca nhan hoac tap the, neu la cac van ban pho bien thi phai pho bien cho tat
ca sinh vien va cac can bo khoa (b^ng each dan trong bang tin cua khoa de moi nguoi deu co the
tham khao).
•Dam bao viec xu* ly phai kip thai, nhanh chong, chinh xac.
•Khi chuyen cac van ban di phai kiem tra lai tinh chinh xac, the thiic trinh bay, ... sau
do chuyen cho phong Hanh Chinh T6ng Hap ciia Trucrng d^ gai di.

SVTH: Nguyen Thanh Phiic

MSSV: DTH0217S7


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Mui Trufrng


Chmrag 2. Phan tich va thiet ke he thong
1. Cong cu va moi truong phat trien
1.1. Giol thieu so* luoc ve UML(Unificd Modeling Language)
>Ngon ngu mo hinh hop nhat UML la ngon ngif giiip:
•Dae ta.
•True quan hoa.

•Xay dung.
•Lam tai lieu cua mot he thong phan mem.
>Mo hinh (modeling): la viec thiet ke nhung ting dung phan mem truoc khi viet ma lenh.
>Ngon ngit: Khong la ngoti ngtr tu nhien hay ngon ngu lap trinh, nhung no co mot tap cac
qui luat xac dinh each sir dung.
>UML cho kha nang xay dung mot vat kieu bieu do true quan de bieu dien cac khia canh
khac nhau cua he thong. No bao gom 9 bieu do chuan:

Hinh 2.1 Mo hinh true quan hoa voi UML

• M6 hinh c'6 the chia lam 2 nhom:
o Cac loai bieu do tlnh: bieu do truong hop sir dung (Use Case Diagram), bieu do lap

(Class Diagram), bi^u do d6i tuqng (Object Diagram), bieu d6 thanh phln (Component
Diagram), bieu do trien khai (Deployment Diagram).

SVTH: Nguyen Thanh Phtic

MSSV: DTH021757


Xay (lung Website quan ly cong van Klioa Ky Tliuat - Cong Nghe - Moi Tru'crng


o Cac loai bieu do dong: bieu do tuan tu (Sequence Diagram), bieu do cong tac
(Collaboration Diagram), bilu d6 trang thai (Statechart Diagram), bi^u d6 hoat dong (Activity
Diagram).

1.2. Cac mo hinh true quan vol UML
1.2.1. Bieu do cac truong hop su dung (Use Case Diagrams)
Bi^u d6 nay tap trung quan sat trang thai tmh cua cac chuc nang trong he thdng duai goc
do cua nguoi dung. No dac biet quan trong trong viec to chuc va mo hinh hoa he thong.

Ky hieu

Khai niem
Actor (tac nhan)

Y nghia
Tac nhan la con nguoi hay he
thong khac cung cap hay thu
nhan thong tin tu he thong
dang xay dung.

Use Case (tinh huong su dung)

C^

Use Case bieu dien chiic nang
cua he thong tir goc do ngucri
dung.

Bang 2.1. Bieu do Use Case


1.2.2. Biiu do lop (Class Diagram)
Bieu do nay chi ra tucmg tac giua cac lop trong he thong, no la bieu do quan trong nhat
trong hau het cac phumtg phap huong doi tuqng.

Ky hieu

Khai niem

Class (lap)

I

class module

I

Database

!i^$m_Iink = 1alse

Y nghia
Mot lap bieu dien cho su
mo ta trim tuqng mot tap
cac doi tuqng co cung tich
chat. Lap co the duqc xem
la mot kieu du lieu.

|liConnectO: Boolean
SExecute(String): Boolean

Attribute (thuoc tinh)
Operation (thao tac)

$m_link=false
Connect(): Boolean
Execute(String): Boolean

Bang 2.1 Bleu do Class Diagram

SVTH: Nguyen Thanh Phuc

MSSV: DTH021757

Bieu dien cho mot kieu
thong tin ben trong lap
La chuc nang hoac hanh vi
cua mot lop.


Xay dung Website quan ly eong van Khoa Ky Thuat - Cong Nghe - Moi Trirfrng

1.2.3. Bieu do trinh tu (Sequence Diagram)
Bieu do nay chi ra luong ch\ic nang xuyen qua cac Use Case, no la bieu do mo ta tucng
tac giaa cac doi tuong va tap trung vao mo ta trat tir cac thong diep theo thai gian.
Khai niem

Ky hieu

Y nghla


Actor (tac nhan)

Object (doi tuqng)
:Name

Message (thong diep)

ThOng dip

Di tit doi tuong nay den doi
turang khac

Time (thai gian)
:Name1

Messaget

Message3

Bang 2.3. Bieu do trinh tu

1.2.4. Biiu do hop tac (Collaboration Diagram)
Nhu bieu do trinh tir (Sequence Diagram), nhung no tap trung vao to chuc cau true cua
doi tuang gui va nhan thong diep chu khong quan tarn dn trinh tu thai gian.

SVTH: Nguyen Thanh Phuc

MSSV: DTH021757



Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Tru-frng

1.3. He quan tri cop so' dir lieu va moi truong cai dat
1.3.1.He quan tri cff s& du' lieu MySQL
1.3.1.1.T6ng quan ve MySQL
o MySQL la mot he quan tri ca sa dtt lieu.
o MySQL la mot he quan tri ca sa du lieu quan he.
o MySQL la ph^n mSm nguon ma.
o Ca sa da lieu MySQL rit nhanh, tin cay va dl dung.
o MySQL server hoat dong trong cac he thdng nhiing hoac Client/Server.
1.3.1.2.Mot so a6i tupng trong MySQL
o Databases: Chua cac Table, ...

o Tables: bao gom cac cot chua tat ca du lieu, moi hang trong Table chua thong tin
ve mot doi tuang nao do
1.3.1.3.Bao mat trong MySQL
MySQL Server chay nhu mot dich vu trong moi truang Windows. Do vay, Account
cua ban phai du quyen de chay duac no dong thai khi truy cap vdi quyen cao nhat (-u root) thi
ban phai nhap vao password n^^a.
1.3.1.4.Xuat (Export)
MySQL Server (version 5.0) cho phep ban xuat ca cau true va du lieu ra ben ngoai vai
nhi^u dang du lieu khac nhau (SQL, LaTeX, Microsoft Excel 2000, Microsoft Word 2000, CSV for MS
Excel, CSV, XML), va tu nhung file do chung ta co the tao Iai ca sa da lieu mot each dl dang.
1.3.2.Moi trubug cai dat
Cai dat tren moi truang MySQL Server 5.0.

2. Phan tich
2.1. Hien trang Khoa Ky Thuat - Cong Nghe - Moi Trirtmg
Hien nay khoa Ky Thuat — Cong Nghe - Moi Truang gom 3 bo mon: Bp mon Tin Hoc,
Bo mon Ky Thuat, va Bo mon Moi Truang va Phat TriSn B^n VOng, hoat dong duai su quan Iy

chung cua Ban chu nhiem Khoa. Hien tai co 2 nganh dao tao la Tin Hoc va Cong Nghe Moi
Truang va trong tuang Iai se phat trien them nhieu chuyen nganh khac. Duai su phat trien nhu
the thi viec quan ly cua can bp khoa ngay cang tra nen kho khan va phuc tap bai da s6 hien tai
viec quan ly cua khoa chu yeu bang phuang phap thu cong, trong do viec quan ly cong van cung
khong ngoai hien trang hien nay cua khoa: Vi vay viec xay dung Website quan ly cong van khoa
se gop phan giai quyet dupe mot phan nao kho khan do.

SVTH: Nguyln Thanh Phuc

MSSV: DTH0217S7


Xay dn-ng Website quan ly eong van Khoa Ky Thuat - Cong Nghe - Moi Trirfrng

2.2.Van de can giai quyct
>Xay dung Website quan ly cong van khoa Ky Thuat - Cong Nghe - Moi Truong.
>Chuyen cong tac quan ly bang phuong phap thu cong sang quan ly bang may.
>Tao ra su dl dang vathuan loi cho viec quan ly.

2.3.Yeu cau duoc dat ra (Website can phai lam nhu-ng gi)
>Cac yeu clu chiic nang
•Cho them cong van.
•Sua ch&a cong van.
•Xoa cong van.

•Tim kiem cong van.
•Chuyen cong van cho mot doi tugng cu the.
•Xem cong van.

•Cho tai c6ng van vg (Download).

•Them nguai dung vai nhimg quyen cu the.
>Cac yeu cau phi chitc nang
•Giao dien than thien nguoi dung.
•Trang Web phai tucmg thich vai nhieu trinh duyet khac nhau.
•Phai co ca che bao mat.
•De sii dung.

2.4.Mo hinh quan niem xti ly he thong
Ngucri true tigp sir dung Website quan ly cong van khoa KT-CN-MT bao gom: can bo
quan ly van thu cua khoa, va mot so can bo khac... Trong do can bo quan ly van thu khoa se
chju trach nhiem quan ly toan bp cac thong tin cua he thong.
Do Website duac xay dung hoan toan mai nen chi trinh bay mo hinh quan niem xu ly cho
he thong mdi:

SVTH: Nguyln Thanh Phiic

MSSV: DTH021757


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trtrfrng

on

Web
Server

Internet V''

^'i


Ngu&i truy capNgi/fli quan ly
Hinh 2.2 Mo hinh quan niem x^' ly

Hogt dgng:
Nguai truy cap truy cap den Website co the xem cac cong van da duac dua len.
Ngudi quan tri quan ly cac thong tin ve cong van (them, sua, xoa, ...), va kiem tra tinh
chtnh xac cua cong van.

2.5. Mo hinh ky thuat
Web

Webserver

Browser

Cac trang
*.php

Ngu'ai quan

Co so dtr

iy

lieu

Ngooi truy
cap
Hinh 2.3 Mo hinh ky thuat
Hogt (long:

Cac trang *.php se lay dtl lieu trong ccr so dtr lieu dua len Webserver va nguai truy cap
xem cac thong tin ve cong van thong qua Internet.
Nguai quan ly thong qua Web Browser de vao trang quan.trj, thong qua trang quan tri do
co the tai, them, xoa, sua,... cong van.

SVTH: Nguyln Thanh Phuc

MSSV: DTH021757


Xay dung Website quan Iy cong van Khoa Ky Thuat - Cong Nghe - Moi Trufrng

3. Thiet ke
3.1. Mo hinh chiic nang cua Website
3.1.1. Sc d6 cdu true chile nang
Website quan Iy.cong'van khoa KT.- CN - MT

—

•H**%QuSrviy^".-<--^-

Them
•Tai1 •
..,

'Sila

•
••- -


Xoa
\ Tim kiem

—

fti?He:th6ngfr-.^s

Dang nhap
Dang xuat
Phan quyen •.',

;<$^i*Tr
:

Hinh 2.4 Stf do call true chii'C nang cua he thong

SVTH: Nguyen Thanh Phuc

MSSV: DTH0217S7

10


Xay dung Website quan ly cSng van Khoa Ky Thuat - Cong Nghc - Moi Trufrng

3.1.2. So- d6 lien kit cac trang

Tr
the

Hinh 2.S So- do lien ket cac trang

3.2. SWebsite quan ly cong van khoa Ky Thuat - Cong Nghe - Moi Truong duqc thiit ki theo
mo hinh da tang nhu hinh duoi:

/

J
J

/

Lap giao dien
(User Interface layer)
i
t

/

/

Lap xlp ly
(Business layer)
i

/

Lap da lieu

(Data layer)

/

Hinh 2.6 So- do kien true

Lop giao dien(User Interface Layer): Tat ca nhung gi hien thi len man hinh phai thong qua
lop nay.

SVTH: Nguyin Thanh Phuc

MSSV: DTH021757


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trirfrng

Lop xur ly(Business Layer): Tat ca nhung thao tac, yeu cau cua nguoi diing phai thong qua
lop nay.
Lap du" liu(Data Layer): Co nhiem vu ket noi co so du' li?u, thao tac true tiep tren co so du
lieu.

3.3. Thiet ke xu- ly
Moi chiic nang cua he thong se duoc mo ta bang mot UC (Use Case).
Moi kich ban (Scenario) cua UC se duoc trinh bay bSng bieu do tuan tu (Sequence

Diagram)
3.3.1. MS hinh User Case mo ta cac chuc nang cua he thong

Quan ly cong van

Hinh 2.7 Mo hinh chirc nang cua h^ thong

3.3.2.1. Xfrly Bang Nhap
• Mo ta: Use case Dang Nhap cho phep mot nguoi co the dang nhap vao he thSng cua
Website thong qua UserName va Password voi quyen Administrator.

SVTH: Nguyen Thanh Phuc

MSSV: DTH02175712


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trirfrng

• Sa do lap cho xu ly dang nhap

Class Module

DangNhap
Web Fonw
_gg

TrangDangNhap

SJm MatKhau

^^KiemTraDangNhapO
Class Module

MySQLDB
link

Class Module

XLJDangNhap

iconstruct()
Ca_destructO

tKiemTraDangNhap(i_NguoiDung. iMatKhau)

E^ConnectO
0ExecuteQuery(i_sqI)
LExecuteNonQuery(i_sqI)

Hinh 2.8 So' do lop cho xir ly Dang Nhap

• M6 ta kich ban (Scenario)
o Di6u kien tien quyet
Khong co.
o Luong chinh
1.UC bat dau khi nguoi dung nhan vao nut Dang Nhap.
2.TrangDangNhap (index.php?act=dangnhap) se dirge goi.
3.Trang Dan^ Nhap se hi^n thj Form cho ngucri dung nhap vao cac thong tin can
thi^t dk dang nhap vao he thong.
4.Nguoi dung nhap vao thong tin.
5.Ngirai dung nhan vao nut dang nhap hoac Enter.
6.Thong tin dirge dira vao lop DangNhap.
7.Lop DangNhap goi den lop XLDangNhap de lay thong tin can thiet.

8.Lcp XLJDangNhap goi dgn lop MySQLDB dg lay dtr lieu tir co so du lieu dua

tro lai lop DangNhap.
9.Tir dir lieu ldy vg, lcp DangNhap se kigm tra thong tin ngirai dung nhap vao

diing hay khong? Ngu khong dung thi thgc hien Iu6ng Al.
10.Hign thi cac chuc nang cua he thong tiiy theo nguoi dung nhap vao ten dang
nhap vdi quygn gi.
11.Hien ra thong bao dang nhap thanh cong ciing vdi quyen cua tgn nguoi diing
dang nhap vao.

SVTH: Nguyen Thanh Phuc

MSSV: DTH021757

13


Xay du-ng Website quan ly cong van Klioa Ky Thuat - Cong Nghe - Moi Trirfrng

12. UCk^tthiic.
o LuongAl
1.Xult thong bao ii, yeu cku nguoi diing thir lai.
2.UCk^tthuc.
o Dieu kien theo sau
1.Bi^n $_SESSION['login_state']= true;
2.Tuy theo ngiroi diing dang nhap voi quyen gi ma cac bien
$_SESSION['admin_state'], $_SESSION['operator_state'], $_SESSION['user_state'] se duoc
batlen.

SVTH: Nguyen Thanh Phuc

MSSV: DTH02175714


Xay dung Website quan ly c5ng van Khoa Ky Thuat - Cong Nghe - Moi Trirfrng

Sa d6 tuin tir cho xir ly dang nhap

: Tran^Chu

: TraneDaneNhan

: DaneNhan

: XL DaneNhap

^^MySOLDB

r

l:Nhanv

oi trang D^ngNMp

Hjenjhi

4: Nh?p thong tin

|

5:NhanniitBangNhap

6: Btfa thong tin
in tra thong tin

I

8: Gpi \ km kiem tra d3qg nhap

10; Kiem tn thong tin dang nhap

lllKet qua dangnnap
1 12: Thong bio ket qua dang nhap

o<

~]

"

Hinh 2.9 So do tuan tif cho xir ly Dang Nhap

SVTH: Nguyen Thanh Phiic

MSSV: DTH021757

15


Xay dyng Website quan ly c5ng van Khoa Ky Thuat - Cong Nghe - Moi Triromg

> Sa do hop tac cho xir ly Dang Nhap

7: Kiem tra th&ngtin

3:Hienthi

4: Nhp th6ng tin
5:Nh5'nnutDangNhap

6: Dura thong tin
: DaneNhan

: TrangDangNhap

pi hiim k em tra dang nhap
2: Gpi trang Ding Nh$p
12: Th6ng bdo-kt qua dang nhap
1: Nhanvaomi^DSngNhp

/
: TrangChu

11: Ketquad ngnhap
10: Kiem tra thong tin dang nhap

_LMySQLDB

: XL DanENhap

Hinh 2.10 So- do h^p tac cho xir ly Dang Nhap

3.3.2.2. Xir ly Them Cong Van
• Mo ta: Use Case Them Cong Van cho phep ngiroi quan ly co the them mot cong van
vao ca so dur lieu.

SVTH: Nguyin Thanh Phiic.

MSSV: DTH021757

16


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Truong

> So db lap cho xir ly Them Cong Van

Class Module

CongVan
Web Fornt

^ThemCongVanO

ThemCongVan

'^SuaCongVanO

^XoaCongVanO
^TaiCongVanO
2TimKiemCongVan()

Class Module
<
MySQLDB

XLCongVan

link
SThemMoiCongVan(cv: CongVan)

i_constructO

SSuaCongVan(cv: CongVan)

fS_destructO

SSXoaCongVan(MaCongVan: Integer)
STaiCongVanO
^frunKiemCongVanCcv: CongVan)

ISConnectO
EExecuteQuery(i_sqI)

ESExecuteNonQuery(i_sql)

Hinh 2.11 So do lop cho xii ly Them Cong Van

• M6 ta kich ban (Scenario) cho xir ly them cong van
o Di^u kien tien quyet
Nguoi dung phai dang nhap thanh cong voi quyen Administrator hoac Operator,

o Luong chinh
1.UC bat dau khi nguoi dung nhap vao niit Them moi cong van.
2.TrangThemCongVan (index.php?act=them&code=congvan) se duoc goi.
3.Trang them cong van se hien thi form cho nguoi dung nhap vao thong tin.
4.Nguoi dung nhap vao thong tin cua cong van.
5.Chi den tap tin cong van duoc luu trohg 6 dTa cung hoac cac loai luu trit khac
(USB, dTa mbm, dia CD, ...).
6.Nhan vao nut them mm.

7.Nhung thong tin ve cong van va tap tin cong van duoc dua den lop CongVan.

TRUC5NG D/=tl HQC
ANGIANG

THUVIEN
SVTH: Nguyln Thanh Phuc

MSSV: DTH021757

17


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trufrng

8.Lop CongVan se tidn hanh tai tap tin cong van duac ngudi dung chi ra vao thu
muc liru tru" cua trang Web vdi tdn tarn thai. Neu tai tap tin cong van khdng thanh cong thi
chuyen qua ludng Al.
9.Kiem tra tinh hop le tCr nhttng thong tin ngudi dung dua vao'. Neu khong hop le
thi chuyen qua ludng A2.
10.Goi ham Them mdi tir lop XLCongVan va dua vao do cac tham so ciia Idp

CongVan.
11.Lop XL_CongVan se tao ra cac lenh SQL sau do goi den cac ham lien quan

trong lop MySQLDB dd thuc thi cau lenh.
12.Lop MySQLDB se k^t ndi d^n ca sd dft lieu va thuc hien cau lenh sql do lop
XL_CongVan dua vao va tra k^t qua lai cho Idp XL_CongVan. Neu ket noi khong duqc hoac
khong thuc thi duac cau lenh SQL thi thuc hien luong A3.

13.Lop XL_CongVan nhan kdt qua dua v^ tCr Idp MySQLDB va truydn kdt qua
vao Idp CongVan.
14.Ldp CongVan se goi lap XL_CongVan mot ISn n&a de lay ma so cong van vua
mdi luu thanh cong.
15.Ldp XL_CongVan tidn hanh liy ma sd cong van mdi luu thanh cong va tra ve
ldp CongVan.
16.Dua vao ma sd cong van dua ve Idp CongVan se tien hanh ddi ten tap tin tarn
trong thu muc luu tru cua trang Web lai cho triing vdi ma cong van. Neu ddi ten khong duac thi
thuc hien ludng A4.
17.Thong bao them mdi cong van thanh cong cho ngudi dung,
o Luong Al
1.Thong bao tai tap tin cong van khong thanh cong.
2.Ket thuc UC.
o Luong A2
1.Thong bao thong tin ve cong van nhap vao khong hap le.
2.KdtthucUC.
o Luong A3
1.Thong bao them mdi khong thanh cong.
2.KSt thuc UC.

o Ludng A4
1.Xoa cong van vua luu ra khdi ca sd dft lieu.

2.Thong bao them mdi khong thanh cong.
3.K6t thuc UC.
o Dieukientheo sau: KJidngcd

SVTH: Nguyln Thanh Phuc

MSSV: DTH02175718


Xay dung Website quail ly cong van Khoa Ky Tliuat - Cong Nghe - Moi Trirtmg

i So do tuan tir cho xu ly Them Cong Van

A

: TrangThemConpVan

: Ngtffliauaniv

: ConpVan

: XL ComrVanll : MvSOLDBJ

L_L,i

1: Nhfin ndt Them C6n^ Van
)i trang ThemCtmglVan
3: LS^y thong tin

A

4: II en thi Form

T
5: Nhf^p v^o th^^ng tin vk chi ra tap tin com* van
6: Nhan m|t Them Mdi
7: Thong tin C6nc Van
i tarn tap tin ngtfi i diing chi ra v^o'thi/ muc hiu triT
9:K ;m tra hdp le

r

i: Goilhim th6m mdi cti:
10: G.
ing van
11: ^ifti xu6'ng erf st'f dp lieu

!i

12:Luu
13: Ket qua

Ket qua them n

T1
|IS: Ddi ten tap tin tijhng vdi ten cua ma c6ng van

16: Thong \>Aa ket qua

Hinh 2.12 Sor do tuan tir cho xtr ly Them Cong Van

SVTH: Nguyen Thanh Phuc

MSSV: DTH021757

19


Xay diing Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trtrfrng

> Scr do cong tac cho xu ly Them Cong Van

4: Hien thi Form

5: Nhap vdo thong tin va chi ra tap tin c6ng van
6: Nhan nut Them Mdi
: TrangThemCongVan
-~4^Nha'n ndt Them Cong Van
:NgUMqudnly

"^\^2: dpi trang ThemCongVam^^'
iXrangChu " "_^-"'

16: Thongi^^o kS't qua

<7>Thong tin Cong Van3: L i'y thong tin

8: Llfu tarn tap tin ngirdhdhng chi ra vao thit muc luu trff
15: Ddi thntaptintriingvdijen cua ma cdng van 12:
12^ LUU

em mdLcong^an_

11: LUU xuong cd set duf lipu

i ^X^.CpngVan

14: Ket qua thSm mdi

jJv&SQLDB.
13: Ket qua

Hinh 2.13 Sir (16 cong tac cho xu- ly them cong van

3.3.2.3. Xfr ly Quan Ly Cong Van
• Mo ta: Use Case Quan ly cong van cho phep nguoi dung co the chinh sura, xoa cong
van, xem cong van,...

SVTH: Nguyln Thanh Phuc

MSSV: DTH021757

20


Xay dung Website quan ly cong van Khoa Ky Thuat - Cong Nghe - Moi Trirfrng

> Sct d6 lap cho xir ly Quan Ly Cong Van

Web Fomi
TrangSuaCongVan

Web Fonrt

TrangQuanLyCongVan
Web Fomv
TrangXemCongVan

Wcb FonH
li.

TrangTaiCongVan

CIass Module

CongVan
Web Fomt

LSThemCongVanO
[5>SuaCongVan()

TrangXoaCongVan

ffiXoaCongVanO
[^TimKiemCongVan()

Class Module

MySQLDB

Class Module
XL_CongVan

,?m link

^?iThemMoiCongVan(cv: CongVan)
ESSuaCongVan(cv: CongVan)
ESXoaCongVan(MaCongVan: Integer)
CSTimKiernCongVan(cv: CongVan)

constructO

!!S_destruct()
ESConnectO •
ESjExecuteQueryO
f^xecuteNonQueryO

Hinh 2.14 So* do ldp cho khoi xir ly quan ly cong van

• M6 ta kjch ban (Scenario) cho xu ly chinh sira cong van
o Mo ta: UC cho phep chinh sua cong van khi da dang nhap vao he thong,

o Di^u kien tien quyet
1. Ngucri dung phai dang nhap voi quyen Administrator hoac Operator,
o Luong chinh
1.UC bit dilu khi nguoi ditng nh5p chon sita cong van tu* trang quan ly cong van.
2.TrangSuaCongVan (index.php?act=sua&code=congvan&id=< macongvan >)
duac goi.
3.Trang sua cong van se goi d^n cac lap CongVan de lay nhOng thong tin ve cong

van can sua tu* ma cong van dua vao.

SVTH: Nguyen Thanh Phuc

MSSV: DTH021757

21