Xây dựng website quản lý lịch biểu thiết bị và phòng máy
Bạn đang xem bản rút gọn của tài liệu. Xem và tải ngay bản đầy đủ của tài liệu tại đây (4.03 MB, 65 trang )
TRtfCfNG DAI HOC AN GIANG
KHOA K^ THUAT - CONG NGHE - MOI TR^CING
NGUYEN PHAM TUAN AN - DTH082035
KHOA LUAN TOT NGHIEP D^I HQC NGANH CVf NHAN TIN HQC
XAYDlTNG
WEBSITE QUAN LY LICH BIEU
THIET BIVA PHONG MAY
TRUONG DAI HOC
AN GIANG
th^vien
An Giang, 05/2012
Giang vien huong dfin:
TS. Nguyln Van Hoa
LOU CAM ON
T6i xin gui ldi cam on chan thanh den Ban lanh dao Tnrdng Bai hpc An Giang,
Khoa Ky Thuat - Cong Nghe - Moi Trudng.
Toi xin gui Idi cam on sau sac nhat den thay Nguyen Van Hda - ngufri da tan
tinh hudng dan, chi bao va giiip &a toi trong sudt qua trinh nghien cuu va thuc hien de
tai.
Xin chan thanh cam on den sir giup da cua cac thay co, cam on ban Tran
Nguyin Khanh An DH8TH, cac ban sinh vien BH9TH Khoa Ky Thuat - C6ng Nghe Moi Trudng.
Toi xin cam on gia dinh, ban be nhung ngudi da luon ben toi, giup do va tao
di^u kien tot nhat di toi hpc tap, nghien cuu va hoan thanh d tai.
Du da rlt c6 gSng, song khong thl tranh khoi nhung thi^u sot va han ch^ Kinh
mong su ddng gop y kien cua quy th^y co va cac ban.
Mot Ian nua toi xin chan thanh cam on!
An Giang, ngay 18 thang 5 nam 2012
Sinh vien thuc hien
NguySn Pham Tufin An
••
MUC LUC
CHUGNG1.T0NGQUAN1
I. Batvlndg1
n. Li do chon d tai1
CHUQNG 2. NOl DUNG VA KET QUA NGHIEN CUU2
I.Mo ta he thdng2
1.Motanghiepvu2
2.Pham vi ciia dg tai2
2.1.Phat bilu v^n dg2
2.2.Muc tigu cua h? thdng2
2.3.Chiic nang chinh cua he thgng•3
2.3.1Chiic nang cho ling dung:3
2.3.2Chi tigt chiic nang cho ling dyng:3
3.Danh giakha thi4
3.1.Kha thi vg kinh t4
3.2.Kha thi vg ky thuat4
II.Co so ly thuygt5
1.NgonnguPHP5
2.Framework Codelgniter5
3.Gidi thieu Dhtmlx7
3.1.Gidi thieu7
3.2.Cach thiic lam viec7
3.3.Cach su dung DHTMLX7
4.He quan tri co sd du lieu MySQL8
HI.- Phan tich he thdng8
1.Phan tich Men trang8
1.1.Mo ta Men trang8
1.2.Danh gia Men trang9
2.Phan tich yeu clu,9
2.1.Yeu c^u chiic nang9
2.2.Yeu cauphi chiic nang11
3. Phan tich chinh11
3.1.So d6 Usecase11
3.2.Sod616p17
3.3.Sa <16 tain tyr18
IV. ThiStkS26
1.Thi8tkSt6ngth826
2.ThiStkSchitiSt27
3.ThiStkScosadulieu28
3.1.SodSquanhS28
3.2.Mo ta cac bang29
4.ThiSt k8 giao dien33
KET LUAN VA HLT6NG PHAT TRIEN41
I. K8t qua dat duqc41
I.Lythuygt41
2.1Canbpquanly41
2.2Can bp giang viSn41
II.Huong phat triin41
m. Huong giai quy8t,42
tAilieuthamkhao43
website tham khao43
PHULUC44
DANH SACH CAC HINH VE
Hinh 1: Sadousecase tong quat..12
Hinh2: So do usecase quan lynhanvien13
Hinh 3: So d6 usecase qudn ly phong14
Hinh 4: So d6 usecase quan ly thiet bi15
Hinh 5: Sa do usecase dang ky su kien vai thiet bi;16
Hinh 6: Sa d6 usecase dat lich hen vai dong nghiep16
Hinh 7: Sa d6 lap17
Hinh 8: Sa id tuto tu Dang nhap he th6ng18
Hinh 9: Sa d6 tuln tu Tra cuu thiet bi18
Hinh 10: Sa d6 tuan tu: tra ciiu phong19
Hinh 11: So ddtulntu Them thiSt bi19
Hinh 12: So d6 tu^n tu Cap nhat thi8t bi20
Hinh 13: So detulntu Dat lich thit bi21
Hinh 14: So d6 tuSn tu Them phong hoc22
Hinh 15: So d6 tu^n tu Cap nhat phong thong tin phong22
Hinh 16: So d6 tuin tu Them khoa;23
Hinh 17: So d6 tuin tu Cap nhat khoa23
Hinh 18: So d6 tu^n tu tao Muc thiet bi mdi24
Hinh 19: So d6 tun tu cap nhat Muc thit bi24
Hinh 20: So d6 tu^n tu c^p nhat Lich phong may25
Hinh 21: Mo hinh Client-Server26
Hinh 22: Mo hinh MVC:27
Hinh 23: So d6 kien true 3 lap phdn mhm28
Hmh 24: Sa d6 quan he29
Hinh 25: Giao dien chuc nang Tra cuu thiet bi33
Hmh 26: Giao dien chuc nang Dat lich thiet bi34
Hmh 27: Giao dien chuc nang Dat lich thiet bi35
Hinh 28: Giao dien Tao su kifn mai36
Hinh 29: Giao dien chuc nang Lich ca nhan37
Hinh 30: Giao dien chuc nang Quan Iy can bo:38
Hinh 31: Giao dien chuc nang Cap nhat lich bilu phong may39
Hinh 32: Giao dien chiic nang Xem lich phong may40
^:" -f.:^
^"•' "v
DANH SACH CAC BANG BlU
Bang 1: Mo ta usecase Bang nhap44
Bang 2: Mo ta usecase Bang xuat:44
Bang 3: Mo ta usecase Boi mat khau45
Bang 4: Mo ta usecase Them thiet bi45
Bang 5: Mo ta usecase Cap nhat thiet bi46
Bang 6: Mo ta usecase Xoa thiet bi46
Bang 7: Mo ta usecase Th8m loai thi^t bi.'1.47
Bang 8: Mo ta usecase Cap nhat loai thiet bi47
Bang 9: Mo ta usecase Xoa loai thiet bi48
Bang 10: Mo ta usecase Them khoa49
Bang ll:M6tausecaseCapnhatkhoa:49
Bang 12: Mo ta usecase Xoa phan khoa:50
Bang 13: Mo ta usecase Them phong ..^50
Bang 14: Mo ta usecase Cap nhat phong51
Bang 15: Mo ta usecase Xoa phong....51
Bang 16: Mo ta usecase Them phan khu52
Bang 17: Mo ta usecase Cap nhat phan khu53
Bang 18: Mo ta usecase Xoa phan khu....53
Bang 19: Mo ta usecase Tra ciru thi^t bi54
Bang 20: Mo ta usecase Tra cuu phong54
Bang 21: Mo ta usecase Tra cuu nhan vien55
Bang 22: Mo ta usecase Bat lich thiSt bi55
Bang 23: Mo ta usecase Bat lich ctong nghiep56
Bang 24: Mo ta usecase Cap nhat lich phong may57
DANH SACH CAC KIHIEU VA TlT VIET TAT
Danh sich cic ky hieu:
Kliii itiem
Ky hieu
Actor
(Tic nhan)
Actor
Mot ngudi hoac mot
nhdm ngudi tac ddng
ho^c thao tac den he
thing.
Mot chudi cac hanh dpng
Use-case
ma h| thdng thuc hien
(Trudng hop sir dung)
mang lai ket qua quan six
duqc doi vdi Actor.
Quan he mo r$ng, the
hien quan he giua cac
extend
Usecase vdi nhau.
Quan he bao g6m, thl
include
hien quan he giua cac
Usecase vdi nhau.
Quan he tong quit hda,
la quan he giua Actor
Communication
vdi Actor.
The hien mot trinh ty xu
ly cua he thdng trong
mot hay nhidu usecase.
Control class
(Ldp diSu khiln)
Database
La ting didu khiln tuong
Ctrl: ThlelBI
1 Database: Table
tic cua ngudi ding, lam
viec true tilp vdi Model
va cudi cimg truyen du
lieu cho tang View de
hien thi.
Nod luu tru du lieu.
(Co sd du lieu)
Model
Procedure
(Phuong thuc)
Model: ThietBI
lay du lieu can bo
va Phong0
Tang truy xuat va lam
viec vdi co sd du lieu.
La phuang thiic cua doi
tuong ben phii thvrc
hien yeu cau cua ddi
tugng ben trii.
Ting hign thi kgt qua xu
9
View
(Thg hien)
ly mot yeu cau cua actor
Viewer: LoalThletBI
w
len trang web.
CHlTONG 1. TONG QUAN
I. Bat vSn al
Cong nghd thong tin ngay nay dttoc xem la mot thanh tpu tuyet vdi ciia nhan
loai. Bdi kha nang tinh toan, ti^ dpng hoa mpt each chinh xac va nhanh chdng da giup
con ngudi trong rit nhidu llnh vpc nhu: kinh td, chinh Pi, quan su, van hoa... Ngay
cang co nhidu san phim phin mdm la nhung ung dpng thong minh co kha nang thay
the con ngudi mang lai hidu qua vd kinh td cao.
Trudng Bai hoc An Giang la mot Pong nhung trudng dai hoc Ion a khu vpc
ddng bang song Cuu Long nen so hrpng co so vat chat kha Ion va da dang. VI vay
cong tac quan ly ca sd vat chit phiic tap va mit nhidu thai gian, ddi hoi phai co sp hd
Pp vide quan ly thu cong bang qua Pinh quan ly tp dpng.
Hien nay viec quan ly mupn Pa cac thiet bi ho Pp cho cong tac day hoc d moi
khoa d6u co cac quy Pinh rieng. Nhung co mot dilm chung la giao vien phai den van
phdng khoa di kiim Pa thiit bi minh cin con Pdng hay khdng, sau do dang ky thai
gian mupn va pa may. Cach lam thu cong nay chua khoa hoc do giang vien khong chu
dpng nam dupe lich bidu cua cac thiit bi nay.
Ngoai ra chiic nang thong bao lich bieu phdng may Pen website cua Trung tam
tin hpc vln phai thpc hien cap nhSt thu cong. Nguyen nhan la Phdng dao tao co he
thing sip xip lich bieu rieng va he thong khong Prong thich vdi website cua Trung
tam tin hpc la noi true tiep quan ly cac phdng may.
II. Li do chon &h tai
Cong nghe thong tin phat Pidn nhanh, ngudi dung dupe hudng lpi tu cac ling
dung Internet vdi cac dich vp nhu thu dien tu, tim kidm tai nguyen, tin Pic, quang cao,
lap lich bieu va nhidu loai hinh khac. So vdi nhung phan mem khach chu
(client/server) khac dang co Pen thi Pudng, ling dung Web dupe xem nhu ling dung
ma Pinh khach co thi chay Pen nhidu loai thilt bi khac nhau tit may tinh dd ban, may
tinh xach tay, thidt bi di dpng Ian cac thiet bi sd khac, ngudi dung co thd su dung
chiing nhu mdt tie^ ich dd co thd Puy cap ndi dung cua nha cung cip dich vp d bat ki
thai gian nao va bat ki dau Pen thd gidi.
Be vide quan ly mupn Pa cac thiet bi ho Pp day hpc dupe thuan lpi han. Tdi da
tidn hanh nghidn ciiu va quydt dinh thpc hien dd tai: "Website quan ly lich bieu thidt bi
va phdng may" vdi kha nang quan ly lich bidu thidt bi, lich bidu phdng may va cac
chuc nang bo Pp khac nham ho Pp cac giang vien thuan lpi han Pong qua Pinh cong
tac va giang day, quan ly thidt bi va phdng mot each nhanh chong va thuan tidn.
VI vay, vide xay dung mot ung dpng web hd Pp can bp quan ly vd cong tac
quan Pi thidt bi, quan Pj lich bidu la hoan toan can thidt.
CHUONG 2. NOI DUNG VA KET QUA NGHIEN CUU
I. Mo ta he th6ng
1.M6 ta nghiep vu
Quan ly lich bilu thilt bi: Moi khi thilt bi mod dupe giao vl khoa. Can bp
quan ly he thing se nhap thong tin cua thilt bi nay vao he thing. Khi cac giang vien co
nhu clu muan thilt bi, giang vien se truy cap vao website cua he thong va chpn thiet
bi minh muln mupn dl xem lich bilu cua thilt bi nay (mac dinh he thong se dua ra
danh sach cac thilt bi thubc so him khoa ma nguai dung dang cong tac). Neu lich bieu
thilt bi nay phu hop vdd thai gian cua giang vien. Giang vien se dang ky vai he thing
thai gian ma minh muon mugn thiet bi bang each chpn vimg thai gian thiet bi khbng
ban. Nhap cac thong tin can thiet ma h thdng yeu cau va hoan tat qua trinh dang ky
dat muon thit bi. N6u thiSt bi khfing dap ling dupe thai gian ma giang vien y6u cau,
giang vien se ti6p tuc tra ciiu lich bi6u ciia mot thiSt bi khac cho d6n khi dat dupe yeu
cau ve thai gian.
Qu^n ly lich bieu ca nhan: M6i nguod dung se co mot lich biu rieng. Tai day
nguod dung co the quan ly cac su kien ca nhan nhu: tao su kien, them, xoa. Khi tao su
kien nguod dung co the mai nguai dung khac tham gia su kien cua minh. Ngoai ra khi
nguai dung co sir dung chiic nang dat lich thiet bi thi su kien nay cung se dupe the
hien tren lich bieu ca nhan.
Quan 1^ lich phong may: De cap nhat lich bieu, nguai quan tri se sir dung mpt
cong cu rieng dl chuyln dinh dang du lieu. Cong cu nay se dich file du lieu g6c cira
Phong dao tao sang thai khoa bilu hang tuiin nham tuang thich vai dinh dang du lipu
cua he thdng mdi. Nguai quan tri se ddng bo file du lieu nay len he thdng va du lieu
thai khoa bieu mai se dupe cap nhat.
2.Pham vi cua dl tai
2.1.Ph^t bilu vin de
Truang DH An Giang hien dang ma rpng phat trien a ca sa mai. Ca sa vat chat
ngay cang dupe dau tu. Moi khoa se quan ly mot so lupng Ion cac thiet bi. Neu viec
quan ly khong khoa hoc va sa sai se gay philn toai cho can bp quan ly hay nguod diing
cuoi. Ngoai ra viec cap nhat lich bieu cac phong may tinh vai website vSn chua the
hien dupe tinh chuyen nghiep khi van phai thuc hien hoan toan bang tay.
2.2.Muc tieu cua h thong
- Chiic nang dat lich thilt bi giiip giang vien tilt kiem thai gian, chu dpng bilt
dupe lich bieu cua tung thiet bi tu do thuan tien trong cong tac quan ly, mupn, tra.
Ngoai ra he thong con co module quan ly lich bieu ca nhan giup ngubi dung nam bat
theo doi lich bidu ciia ban than hay dong nghiep tir do co each lam vide hop ly va khoa
hpc hem.
- Chiic nang quan ly lich bidu phong may: giup ngudi quan tri dong bo lich bidu
tir phong dao tao vdi website. Tidt kidm thai gian, chi phi giam cac rui ro va sai sot.
Thong tin lich bieu den nguai dung nhanh chdng va true quan.
2.3. Chile nang chinh cua he thong
2.3.1Chile nang cho ling dung:
+ Dang nhap (ten nguai dung va mat khau)
+ Dang xuat
2.3.2Chi tilt chile nang cho ling dung:
+ Quan ly danh sach ngudi dung: Nguai quan tri he thong se co quydn truy
cap vao thong tin cac tai khoan nguai dung trong he thing va toan quyen chinh
sira cac thong tin nay. Thong tin vd nguai dung se duac phan loai theo tirng
khoa rieng bipt.
+ Quan ly danh sach can bo giang vien: Ngudi quan tri he th6ng se co quyen
truy cap vao thong tin v^ danh sach can b nhan vien dang c6ng tac tai trudng
toan quyen chinh sira cac thong tin nay.
+ Quan ly danh sach phong: Ngudi quan tri he thong co quyen truy cap vao
danh sach cac phong, co quygn tao phong mdi hoac thay ddi thong tin cac
phong da co san.
+ Quan ly danh sach thiet bi: Ngudi quan tri he thong co quyen truy cap vao
danh sach cac thiet bi, co quyen tao thiet bi mdi hoac thay ddi thong tin cac
thiet bi da co san. Thong tin cua mdi
+ Lich ca nhan: Moi su kien co lien quan ddn ngudi dung se duac thd hien d
day bao gdm: su kien dat thiet bi (mau xanh bien), su kien dupe mdi (mau do)
va cac su kien ca nhan ma chinh ngudi dung khdi tao (mau vang). Ngudi dung
se cd quydn xda hay chinh sira su kien do chinh ngudi dung tao ra va chi cd
quyen xem ma khdng the chinh sua ddi vdi cac sir kien duac mdi tham du.
+ Dat lich thiet bi: He thong se tu dong lpc danh sach cac thidt bi thudc khoa
ma ngudi dung dang cdng tac. Ngudi dung chon thiet bi ma minh cd nhu c^u
sir dung de xem lich bieu cua thiet bi nay. Neu thiet bi cd lich bieu trdng va phu
hop vdi nhu cau cua ngudi dung thi ngudi dung se tidn hanh dat lich thidt bi vdi
he thong.
* Trudng hap ngudi dung khdng tim dupe thiet bi phu hop vai lich
bieu cua ho, ngudi dung co the tien hanh mupn thiet bi a cac khoa
khac. Bang each chpn chiic nang Tra cuu thiet bi.
-Danh sach phong: Chiic nang nay giup ngudi dung co the xem thong tin ve
danh sach c&c phong hpc trong he thong.
-Danh sach ngudi dung.
•Xem lich bieu ngudi dung khac: Chiic nang nay giup ngudi dung
co the xem lich bieu cua ngudi dung khac trong he thong.
•Tao su kien vai ngudi dung khde.
-Quan ly lich bieu phong may tinh.
•C^p nhat lich bidu phong may: Giup h thing cap nhat cac du
lieu mdi ve thai khoa bieu cua cac phong. Bang each tai len he
thong file du lieu thai khoa bieu hoc ky co dinh dang ".CSV".
3. Banh gia kha thi
3.1.Kh^ thi ve kinh te
Khi chua co he thdng cac ca nhan d6u phai chu ddng ghi nhd lich bidu cua bin
than. Lich bieu phong may phai cdp nhat thu cdng. Lam cho tien dp cdng viec chung
khdng dupe chinh xac, de gay sai sot nham Ian. Anh hudng den cdng tac giang day
chung cua giang vien va nhan vien.
Khi co he thdng mdi, tao dieu kien cho giang vien co quan ly lich bieu bat cu
ddu. Tiet kiem thai gian chi phi di lai de cap nhat cac thdng tin velich bieu.
3.2.Kha thi vl ky thu^t
-Dp ldn cua du an:
+ He thdng quan ly cac thdng tin ve can bp giang vien, ca sd vat chit bao gom
phong va thidt bi va cac du lieu vd sir kipn cua toan trudng, ddi hoi phai co mot ca sd
du lieu chat che va day du.
+ Do he thdng co nhieu ngudi dimg vdi vai trd khac nhau nen cin phai phan
quyen chat che.
-Cdng cu phat tridn:
+ He didu hanh: Mac OS X (ver 10.6.8).
+ Cdng cu lap trinh: TextWrangler, MAMP, Visual Studio.
+ Cong cu phan tich thidt kd: OmniGraffle Professional.
+ Cong cu vidt bao cao: Microsoft Word 2011, Microsoft PowerPoint 2011.
II. Cc s& ly thuyt
1.NgdnngirPHP
PHP (Hypertext Preprocessor) la mot ngon ngii lap trinh kich ban hay mot loai ma
lgnh chu ydu dugc dung dd phat tridn cac fmg dung viet cho may chu, ma ngudn mo, dung
cho muc dich tdng quat. No rat thich hop vdi web va co the dd dang nhung vao trang
HTML. Do dugc t6i uu hda cho cac ling dung web, toe dp nhanh, nhd gpn, cu phap gidng
C va Java, dd hpc va thai gian xay dung san phim tuang doi ngan han so vdi cac ngon
ngu khac nen PHP da nhanh chong tra thanh mot ngon ngu lap trinh web pho bien nhat
thigidi.
Ngon ngu PHP ra ddi nam 1994 bdi Rasmus Lerdorf (1968, GreenLand) sau
do dugc phat triln bdi nhiSu ngudi trai qua nhidu phien ban. Phien ban dang pho
bidn la PHP 5.0 da dugc cdng bd 7/2004. Phien ban mdi nh^t la 5.3.8.
Soan ma sau minh hpa giup each vit PHP ldng vao cac trang HTML dl dang nhu thd nao:
<html>
<head>
<title>Ma mlu</title>
</head>
<body>
echo "Chaothdgidi PHP!";
?>
</body>
</html>
The <?php va the ?> se danh dlu su bat ddu va su kdt thuc cua ph^n ma PHP
qua do may chu bidt de xii ly va dich ma cho dung. Day la mot dilm kha tien lpi cda
PHP giup cho viec viet ma PHP trd nen kha true quan va de dang trong vide xay dung
phan giao didn ling dung HTTP.
2.Framework Codelgniter
2.1 T6ng quan
Codelgniter la mot nen tang ling dung web nguon md dugc viet bang ngon ngu
PHP bdi Rick Ellis (CEO cua EllisLab, Inc). Phien ban ddu tien dugc phat hanh
ngay 28.02.2006, phien ban Men tai: 2.0.3. Y tudng xay dung Codelgniter dugc dua
trdn Ruby on Rails, mot nen tang ling dung web dugc viet bang ngon
ngu Ruby. Hien tai, Codelgniter dang dupe phat trien bcri ExpressionEngine
Development Team thuoc EllisLab, Inc.
2.2Nhung diim nii bat
Dupe thiSt kg theo mo hinh Model-View-Controller: Mo hinh MVC giiip tach
thanh phan hien thi giao dipn (presentation) va xir ly (business logic) cua mpt phan
mem thanh nhung thanh phan doc lap, tu do giup cho viec thiet ke, xir ly va bao tri
ma nguon de d{ng, dong thai tang kha nang mo rong cua phan mem. Codelgniter
van dung mo hinh nay trong thiet ke, giup tach biet cac tap tin giao dien vai cac tap
tin xu ly du lieu, nang cao kha nang quan ly va de bao tri.
Toe dg nhanh: Codelgniter dupe danh gia la PHP framework co toe do nhanh
nhit hien nay. B5ng ca che luu npi dung vao bo dem (cache), kiem tra bp dem truac
khi tien hanh thuc hien yeu cau, Codelgniter giam so Ian truy cap va xu ly du lieu,
tu do tgi uu hoa toe dp tai trang. Miln phi: Codelgniter dupe phat hanh duai giay
phep Apache/BSD mo rpng, cho phep nguai dung tu do thay doi, phat trien va phan
ph6i ma ngugn. H trp Search Engine Optimization: Cdu true URL cua Codelgniter
rit than thien vdd cac robot tim kiem.
He th6ng thu vign phong phii: Codelgniter cung dp cac thu vien phuc v\t cho
nhung tac vu thucmg gap nhat trong lap trinh web, chang han nhu truy cap ca sa du
lieu, gtSti email, kilm tra du lipu, quan ly session, xtt 1^ dnh...d6n nhirng chuc nang
nang cao nhu XML-RPC, ma hoa, bao mdt... Bao mat he thgng: Ca chg kilm tra du
lieu chat che, ngan ngua XSS va SQL Injection cua Codelgniter giup giam thilu cac
nguy ca bao mat cho he thong.
2.3Nhirng diim han chi
Chtra h trp Object-Relational Mapping: Object Relational Mapping (ORM)
la mot ky thuat lap trinh, trong do cac bang cua ca sa du lieu dupe &nh xa thanh
cac d6i tupng trong chuang trinh. Ky thuat nay giup cho viec thuc hipn cac thao tac
trong ca sa du lieu (Create Read Update Delate - CRUD) di dang, ma nguin ngdn
gpn han. Hien tai, Codelgniter van chua hi trp ORM.
Chira hi trp AJAX: AJAX (Asynchronous JavaScript and XML) da tra thanh
mot phan khong the thieu trong bat ky ung dung Web 2.0 nao. AJAX giup nang cao
tinh tuang tac giua nguai dung va he thong, giiip cho nguai dung co cam giac nhu
dang sit dung ting dung desktop vi cac thao tac diu diin ra "tire thai". Hien tai,
Codelgniter van chua co thu vien dung san nao de ho trp xay dung ung dung
AJAX. Lap trinh vien phai sir dung ede thu vien ben ngoai nhu j Query, Prototype
hay Mootools...
Chua ho trp mot so module thong dung: So sanh vai framework khac,
Codelgniter khong co cac module thuc thi mot so tac vu thuong gap trong qua trinh
xay dung ling dung web nhu Chung thuc nguai dung (User Authorization), Trinh
phan tich RSS (RSS Parser) hay Trinh xir ly PDF...
Chua h6 tra Event-Driven Programming: Event-Driven Programming (EDP) la
mot nguyen ly lap trinh, trong do cac ludng xir Iy cua he thing se dua vao cdc su
ki?n, chiing han nhu click chuQt, go ban phim.. .Day khong phai la mot khuyet diem
to 16n ciia Codelgniter vi hifn tai, chi co mot so it framework ho tr^ EDP, bao gom
Prado, QPHP va Yii.
3. Gidi thiu Dhtmlx
3.1.Gidithieu
DHTMLX la san pham cua mot cong ty phat trien phan mem c6 try sd tai Saint
Petersburg, Nga. Cong ty nay chuyen phat trien cac ling dung dua tren web vdi giao
dien ngufri dung tien tien va chiic nang hang dau tir nam 1998.
Nam 1998, khi hau het cac trang web va cac ling dung duoc xay dung bang
c^ch su dung HTML don gian, DHTMLX da co mot niem tin manh me rang trong
tuomg lai, cac giao dien nguoi dung (UI) cua cac ling dung web se tro thanh nhu giao
dien ngudi diing ciia cac ling dung doc lap Windows. Vao hie do, Java la cong nghe
d^y du nhit cho phep su phat triln cua cac UI tien ti6n cho cac ling dung web. Vi vay,
bang each su dung n8n tang t6t nhit cua thai gian do, DHTMLX phat triin mpt tap
hop cac Java applet de thuc hien day du cac ling dung cho nguoi dung. Do la san
phSm da tro thanh mot trong nhung trang web pho bien nhat ve thanh phan giao dien
nguoi dung tren the gidi.
3.2.Cach thuc lam viec
De dung DHTMLX chac chan khong the thieu cac goi tich hop di kem. Nen
chiing ta can khai bao cac file duoc cung cap trong SDK vao phan Head cua trang
Web.
<head>
<script src="[full path to this file]/dhtmlxcommon.js"></script>
</head>
Tap tin "dhtmlxcommon.js" la thu vien dinh nghia cac phuong thiic dung
chung.
Ngoai ra con co mot thu vien hinh anh rieng cho tung ling dung tu DHTMLX.
3.3. Cach su-dung DHTMLX
Tuy theo cac cac thu vi^n giao dien ling dung ma ngudi dung se co cac phucrng
thiic dinh nghia va cai dat cac thuoc tinh ban dau nhu sau:
Vi du khi xay dung mot giao dien form tir thu vien DHTMLX
Trade tien chung ta can khai bao cac thu vien js va ess co lien quan
<link relE:"stylG!sheet'* type^>"fcext/css" href!"codebaBe/skins/dhtialxfonii__diiK_skyblue^CEj3''>
<Bcript src^codebase/dhthlxco[moii. js"x/8cript>
rscript src^ucodebase/dht^lxforn.JB"x/scripfc>
D6i vdd form da co san mu6n ap dung dhtmlx vao chung ta chi can dinh nghla form
nhir sau:
var dhxForm = row dhtralXForm{nmy_fom");
4. H quan tri cct sd dw lieu MySQL
MySQL la he quan tri CSDL ma nguon md pho Men nh^t the gidi va dupe cac
nha phat trien web rat ua chuong trong qua trinh ling dung. Vi MySQL la CSDL toe
do cao, on dinh va de su: dung, co tinh kha chuyen, hoat dpng tren nhieu he dieu hanh
cung cip mot he th6ng Ion cac ham tien ich rit manh. Vdi t6c do va tinh bao mat cao,
MySQL rit thich hop chp cac ling dung co tray cap CSDL tren Internet. MySQL miin
phi hoan toan cho nen co the tai ve tvr trang chu. No co nhieu phien ban cho cac he
dieu hanh khac nhau: phien ban Win 32 cho cac he digu hanh dong Window, Linux,
Mac OSX, Unix, FreeBSD, NetBSD, Novell NetWare,...
MySQL la mdt trong nhung vi du ca ban ve he quan tri co so du lieu quan he sir
dung ngon ngir tray vin co cau tnic (SQL).
MySQL dupe sir dung cho viec bo trp PHP, Perl va nhiSu ngon ngu khac, no la
noi luu trir nhiing thong tin tren cac trang web viet bang PHP hay Perl,...
III. Phan tfch he th6ng
1. PhSn tfch Men trang
1.1. M6 ta Men trang
Mo ta he thing nham dua ra nhung han chi ma cong tac quan ly Men tai chua
giai quyet. Cach khac phuc van de, dua ra giai phap giai quyet, xac dinh muc tieu cua
ling dung quan ly thiet bi va lich bieu mdi, cac yeu cdu chiic nang ma he thong se
dupe thuc Men.
Nhan thilt bj vl Khoa: Phong quan ly thilt bi se giao cac thilt bi vl Khoa.
Khoa se hoan toan chu dpng trong cong tac quan ly cua minh. Nhin chung cac Khoa se
ghi lai ma so Serial cua cac bi va fir dat ten mdi ngan gpn hon cho cong tdc quan ly
rieng cdaminh (Vi du: MayChieul, MayChieu2).
Cong tac quan ly mupn tra: Qua trinh quan ly lich bieu hien tai hoan toan thu
cong nhu sau: Giang vien can sd dung thiet bi den van phong quan If thiet bi d Khoa
de kiem tra co thiet bi trong hay khong. Neu cd giang vien nay se dang ky vdi nhan
vien quan ly d day va dupe nhan vien hudng dan diln cac thong tin can thiet vao so
nhat ky bao glm: Ngay mupn thilt bi, Ten ngudi mupn, Ten thilt bi (ma thilt bi), Ky
ten mupn, Ky ten tra. Quy trinh nay chua giup cho ngudi dung chu dpng kiem tra thidt
bi ma minh muon mupn. Vi vay se cd nhung khoang thdi gian cao diem khi cac thidt
bi dlu ban. Se mlt thdi gian cua cac giang vien phai tim kiem cac giai phap thay the
phong hoc...
Cap nhat lich bilu phong may tinh: Phong Dao tao cd chuong trinh sip xlp va
quan ly lich bieu ridng. Mdi tuan se xuat ra mot file du lieu thdi khda bieu (hoc ky)
dupe cap nhat (cd the xem trdn Microsoft Excel) va chuydn den cac don vi bo phan cd
nhu cau. Trung tam Tin hoc se sir dung file nay de nhdp vao du lidu lich bilu cho
phong may va kem theo mot sd bang du lieu kem theo khac.
1.2. Banh gia hidn trang
Cong tac quan ly mupn tra thiet bi tai cac khoa:
-Qua trinh mupn tra thiet bi dupe quan ly mot each don gian ndn cd the
gay khd khan cho giang vien vao nhung tidt cao dilm, do khong chu dpng nlm
dupe lich bieu cua cac thilt bi.
Cong tac cap nhat lich bilu cho cac phong may tinh:
-Vide cap nhat du lieu tir phdn mem cua Phong dao tao den website
Trung tam Tin hpc phai thuc hien thu cong, mat thdi gian de ddi chidu va cap nhat.
-Chua the hien dupe tinh chuydn nghidp trong cong tac quan ly.
2. Phan tich yeu clu
2.1. Yeu clu chuc nang
- Yeu clu vl luu tru
+ Luu tru ngudi dung: Thong tin ngudi dung, can bd giang vien thudc nhilu khoa
khac nhau.
+ Luu tru thong tin vl cp sd vat chit: phong, thilt bi, phan loai thilt bi, phan loai
phong.
'il
+ Luu tru thong tin ve lich bieu: su kien ve lich ca nhan, lich thiet bi, lich phdng
may.
- Yeu cau ve nghiep vu
+ Module can bo quan ly:
•Dang nhap va dang xuat he thong.
•Quan ly thiSt bi: them mod thiet bi, cap nhat thong tin v thiet bi, phan loai
thiSt bi, phan b6 cac thiSt bi vh khoa.
•Quan ly ngudi dung: them mod ngudi dung, cdp nhap diong tin ngurdi dung, thong
tin can bp, phan loai can bo theo khoa.
•Quan ly phdng: them mod phdng, cdp nhap thong tin phdng, thong tin tda nha,
phan loai chSc nang cua moi phdng.
•Quan ly lich bieu phdng may: quan ly danh sach can bo sir dung phdng may, quan
lydanhsach phdng may, cap nhat thdi khoa bilu phdng may.
+ Module dat lich thiet bi:
•Dang nhap va dang xudt he thdng
•Hin thi danh sach thiSt bi va bang lich biu.
•Fonn dat lich thiSt bi.
+ Module Lich cd nhan:
•Dang nhap va dang xuat he thong.
•Xem lich bieu ca nhan.
•Form tao su kien ca nhan.
•Mdi ngudi dung khac trong cung he thong tham gia su kien.
+ Module thdng tin:
•Danh sach thidt bi
•Xem lich bilu cua thiet bi trong he thdng
•Danh sach phdng
•Danh sach ngudi dung trong he thdng.
•Xem lich bieu cua ngudi dung khac trong hd thdng.
2.2. Yeu cSu phi chile nang
-He th6ng mai phai hoat dong chinh xac, nhanh chong va de nang cip trong
tuang lai.
-Giao dien than thien de su dung.
-Dam bao cac yeu cau ve bao mat, an toan he thong: cac chiic nang tren he
thdng phai duoc truy xuat boi ngubi dung co quyen han tucmg ting.
-Chay tot tren cac trinh duyet thong thuong: Firefox, Internet Explorer,
Opera.
3. Phan rich chinh
3.1. So'doUsecase
Danh sach Actor
STT Actor
Ngiroi quan tri.
1
Nguoi dung.
2
Y nghia
Quan ly bao qudt he thong.
Svr dung cac chiic nang co ban cua he thong.
Danh sach Usecase
STT
Usecase
1.
DangNhap
2.
4.
DangXuat
DoiMatKhau
DangKy
5.
QuanLyNguoiDung
6.
QuanLyThietBi
Y nghia
Dang nhap vao he thong.
Thoat khoi he thong.
Thay d6i mat khau ciia thanh vien.
Dang ky thanh vien.
Duyet kiem tra danh sach ngrroi dung trong he
thbng.
Duyet kiem tra cap nhat danh sach thi^t bi.
7.
8.
QuanLyPhongOc
XemLich
Duyet kiem tra cap nhat danh sach phong.
Xem lich bieu cua d6i tucmg cin kiSm tra.
9.
Datlich
10.
TraCuuThietBi
TraCuuPhongOc
TraCuuNhanVien
QuanLyPhongMay
Dat lich voi doi tuqng dang duqc kiem tra
Tra ciiu thong tin v thiet bi trong he thong.
Tra ciiu thong tin v cac phong trong he thdng.
Tra ciiu thong tin v cac nhan vien trong h? thdng.
Cap nhat thai khoa bieu phong may tinh.
3.
11.
12.
13
HInh 2: Sir do usecase qiian ly nhan vien
II"
-a
:i.- ,•'.
:-.
•_* ^.
N
H'mh 5: So' do usecase dang ky sir kien viri thiet bi
N
Hinh 6: So db usecase dat Ijch hen voi dong nghiep
- Bac ta use case: Xem ph^n PHU LUC I
r ^ I 'M ^\ i? .^
^ ^k '-
[^^^S
.fe^Ji.
3.2. Sfffldlop
Phong
MaPhong
TenPhong
ThongTin
ThongWThlelBi
SucChua
MaToaNha
Them()
TimKlemO
Xoa()
Sua()
CapNhatQ
TenKhoa
MaToaNha
ThernO
TimKlemO
Xoa()
Suafl
CapNhalQ
NguolDung
MaNguoiDung
TenNguolOung
MatKhau
HoVaTen
SoDIenThoai
MaKTioa
LoalNguoiDung
TrangTiiai
THem()
TlmKiemO
^1..^
i
•
XoaQ
Sua()
CapNhalfl
aThietBI
TenTWeiBi
LoaiThielBi
Serial
ThuocKhoa
HuongDanSuDung
HinhAnh
ThemO
TimKlemO
XoaO
SuaO
LoalNguolDunq
aiuoc
'—">
TenLoaiNguciDung
1^ THemQ
TlmKlemQ
Xoa()
Sua()
Ca^NhaK)
MaLoaiThletBI
TenLoalThletBI
ThemO
lirnKfemQ
Xoa()
Sua()
CapNhaQ
CapNhaQ
Hinh 7: So' 38 ]8p
TR^CiNG DAI HQC
AN GIANG
THifVIEN
.-* •
