Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
-
Upload
georgecraciun -
Category
Documents
-
view
663 -
download
12
Transcript of Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
1/52
ACADEMIA DE STUDII ECONOMICE DIN BUCURETI
FACULTATEA DE CIBERNETIC, STATISTIC I
INFORMATIC ECONOMIC
SPECIALIZAREA INFORMATIC ECONOMIC
LUCRARE DE LICENSolu ie cu baz de date pentru
activitatea logistic a unei
companii
COORDONATOR TIINIFIC
Prof. univ. dr. MANOLE ELICANU
ABSOLENT
!EOR!E CRCIUN
BUCURETI
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
2/52
"#$%
Cuprins
Introducere................................................................................................................. 2
1.Prezentarea activitii de Logistic ntr-o companie............................................3
1.1 Logistica. Concepte generae............................................................................3
1.1.1 !curt istoric.................................................................................................3
1.1.2 "e#nirea conceptuui de ogistic...............................................................$
$." Tr&n'(or)uri*+ +*+-+n) (rini(&* &* &)ivi)/ ii *o0i')i+ .....................................................$
$.% Efii+n)i1&r+& *o0i')iii..............................................................................................%
$.2F*u3uri infor-&4ion&*+ 5n &)ivi)&)+& d+ *o0i')i/...............................................................&
". T+6no*o0ii*+ infor-&)i+ u)i*i1&)+ *& r+&*i1&r+& &(*i& i+i d+ &d-ini')r&r+ & *o0i')iii .......................'
".$ Pr+1+n)&r+ 0+n+r&*/ & un+i &(*i& ii 7+8 .........................................................................'"." 9TML................................................................................................................ 1(
".% CSS....................................................................................................................11
".2 :;u+r M
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
3/52
IntroducereLur&r+& d+ f& / 5 i (ro(un+ '/ :u')ifi+ i-(or)&n & 8&1+*or d+ d&)+ 5n ori+ '+)or i
&)ivi)&)+ & do-+niu*ui +ono-i. E')+ of+ri) & +3+-(*u d+1vo*)&r+& un+i &(*i& ii + u)i*i1+&1/
o 8&1/ d+ d&)+ (+n)ru & &d-ini')r& &)ivi)&)+& ori/r+i fir-+ &r+ &)iv+&1/ 5n do-+niu*
)r&n'(or)uri*or '&u &r+ un d+(&r)&-+n) d+ )r&n'(or)uri ori *o0i')i/ in)+rn/.D&)+*+ &u d+v+ni) 5n u*)i-ii &ni +*+ -&i i-(or)&n)+ r+'ur'+ &*+ un+i o-(&nii d+o&r++
+*+ of+r/ o i-&0in+ d+ &n'&-8*u & &)ivi)/ ii &+')+i& i r+(r+1in)/ 8&1& (r+vi1iuni*or (+n)ru
vii)or. A')f+* / d&)+*+ )r+8ui+ ')o&)+ i -&ni(u*&)+ 5n)run -od ) -&i +fii+n) (+n)ru & (u)+&
of+ri r/'(un'uri vi&8i*+ *& n++'i)/ i*+ fir-+i. D+o&r++ n+ 'i)u/- 5n +r& )+6no*o0i+i infor-& i+i,
ori+ fir-/ &r+ dor+ )+ '/ fi+ +fii+n)/ )r+8ui+ '/ (rofi)+ d+ &v&n)&:+*+ of+ri)+ d+ u)i*i1&r+& un+i
&(*i& ii infor-&)i+ &r+ 'i-(*ifi/ -un& &n0&:& i*or i &:u)/ *& *u&r+& +*or -&i 8un+ d+i1ii 5n
++& + (riv+ )+ &)ivi)&)+& +ono-i/ & fir-+i.A- &*+' & i do-+niu +ono-i d+ in)+r+', *o0i')i& i 5n '(+i&* do-+niu*
)r&n'(or)uri*or d+o&r++ +')+ un '+)or +ono-i din&-i i )o)u i +3i')+n) din +*+ -&i v+6i
)i-(uri. Fir-+*+ &r+ d+'f/ o&r/ &)ivi)/ i + (r+'u(un )r&n'(or)uri &u o -&r+ (rovo&r+ 5n
&d-ini')r&r+& o')uri*or d+ )r&n'(or) d+o&r++ &+')+& &u +& -&i -&r+ (ond+r+ 5n )o)&*i)&)+&
o')uri*or *o0i')i+, &')f+* / +')+ +'+n i&* & &+&')/ &)ivi)&)+ '/ fi+ 0+')ion&)/ or+) (rin
in)+r-+diu* un+i &(*i& ii infor-&)i+.
Co-(&ni& 5n &dru* /r+i& & fo') r+&*i1&)/ dou-+n)&r+& (rivind d+(&r)&-+n)u* d+*o0i')i/, (+ 8&1& /r+i& &u fo') id+n)ifi&)+ +*+-+n)+*+ + )r+8ui+ *u&)+ 5n on'id+r&r+ *&
d+1vo*)&r+& &(*i& i+i +')+ SC R+&*i)&)+& M+di& SA. R+&*i)&)+& M+di& +')+ (ri-& )+*+vi1iun+ din
Ro-ni& d+di&)/ )r&n'-i'i+i "2 d+ or+ din "2 & )iri*or. Fi*o'ofi& (o')u*ui +')+ / +v+ni-+n)u*
0uv+rn+&1/ (ro0r&-u*, &')f+* / 5n ori+ -o-+n) d+'f/ ur/)oru* d+ +-i'i+ (o&)+ fi din&-i1&) u
infor-& ii d+ u*)i-/ or/. !ri*& d+ (ro0r&-+ & R+&*i)&)+& T u(rind+ 5n '(+i&* :urn&*+ d+
)iridin or/ 5n or/G, d&r i +-i'iuni d+ &n&*i1/ (o*i)i/, 'oi&*/, u*)ur&*/ i )iin ifi/.
A- on'id+r&) / &+&')/ o-(&ni+ +')+ un& r+*+v&n)/ (+n)ru do-+niu* +ono-i &*+' i
(+n)ru d+1vo*)&r+& &(*i& i+i, d+o&r++ d+ in+ un (&r &u)o d+ di-+n'iuni -&ri, &(ro3i-&)iv %#
d+ &u)ov+6iu*+, &r+ +f+)u+&1/ un nu-/r -&r+ d+ ur'+ (+ 1i, 5n dif+ri)+ 'o(uriH )r&n'-i'iuni
*iv+, d+(*&'&r+& or+'(ond+n i*or 5n )+ri)oriu, )r&n'(or)u* invi)& i*or, &(rovi1ion&r+ in)+rn/, +).
or8i- d+ &u)ov+6iu*+ d+ )o&)+ &)+0orii*+, in*u'iv d+ +*+ +6i(&)+ (+n)ru )r&n'-i'ii din )+r+n.
Un &*) +*+-+n) r+*+v&n) (+n)ru &+') do-+niu +')+ f&()u* / 'un) 5nr+0i')r&)+ o')uri fo&r)+ -&ri
u *o0i')i& i )r&n'(or)uri*+ ++& + indi/ un 0r&d -&r+ d+ u)i*i1&r+ &* r+'(+)iv+*or
&u)ov+6iu*+.
2
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
4/52
Lur&r+& +')+ ')ru)ur&)/ 5n (&)ru &(i)o*+ + r+&*i1+&1/ (r+1+n)&r+& do-+niu*ui +ono-i
&*+', & )+6no*o0ii*or infor-&)i+ u)i*i1&)+ 5n r+&*i1&r+& &(*i& i+i d+ &d-ini')r&r+ & &)ivi)/ ii
*o0i')i+ i & &(*i& i+i r+1u*)&)+ 5-(r+un/ u -odu* d+ i-(*+-+n)&r+ & &+')+i&.
A')f+*, &(i)o*u* $ d+'ri+ &)ivi)&)+& d+ *o0i')i/ u )o) ++& + (r+'u(un+ +&, (unnd
&+n) (+ o-(on+n)& d+ )r&n'(or)uri. Sun) d+'ri'+ f*u3uri*+ infor-& ion&*+ + &(&r 5nd+'f/ ur&r+& &)ivi)/ ii i &r+ 'un) u)i*+ 5n d+1vo*)&r+& &(*i& i+i d+o&r++ i*u')r+&1/ -odu* 5n
&r+ iru*/ infor-& ii*+ 5n &dru* d+(&r)&-+n)u*ui *o0i')i. C&(i)o*u* " (r+1in)/ )+6no*o0ii*+
infor-&)i+ u)i*i1&)+ (+n)ru r+&*i1&r+& (ro0r&-u*ui, &+n)und (un)+*+ *or for)+ i :u')ifind
&')f+* &*+0+r+& *or. C&(i)o*u* % r+&*i1+&1/ (roi+)&r+& &(*i& i+i i on in+ d+)&*ii )+6ni+
r+f+ri)o&r+ *& -odu* 5n &r+ & fo') i-(*+-+n)&)/ &+&')&. U*)i-u* &(i)o* (r+1in)/ &(*i& i& i
of+r/ indi& ii d+ u)i*i1&r+ & &+')+i&.
1. Prezentarea activitii de Logistic
ntr-o companie
1.1 Logistica. Concepte generale
1.1.1 Scurt istoric
Nu '+ uno& )+ u +3&)i)&)+ ori0in+& )+r-+nu*ui d+ *o0i')i/, d&r +3i')/ -&i -u*)+
i(o)+1+ 5n &+') '+n'. Un& din)r+ &+')+& (r+'u(un+ / &+') uvn) (rovin+ din *i-8& 0r+&/, dinuvn)u* *o0i')iJo'K &r+ 5n'+&-n/ & fi (ri+(u) 5n & f&+ &*u*+.
Cu )o&)+ &+')+&, d+o&r++ )+r-+nu* & fo') u)i*i1&) d+')u* d+ )r1iu 5n i')ori+ 'fri)u*
'+o*u*ui &* III*+& '&u 6i&r 5n+(u)u* '+o*u*ui &* I*+&G & d+)+r-in&) d+')u* d+ -u* i
i')orii i +)i-o*o0i '/ 'u' in/ f&()u* / )+r-+nu* *o0i')i/ (rovin+ din *i-8& fr&n+1/, -&i +3&)
din )+r-+nu* *o0i')i?u+K, )+r-+n fo*o'i) d+')u* d+ -u*) -&i &*+' 5n &-(&nii*+ -i*i)&r+,
d+'+-nnd o(+r& iuni*+ d+ )r&n'(or)&r+ i (o1i ion&r+ & uni)/ i*or (+ -(u* d+ *u()/, d&r i
o(+r& iuni*+ d+'f/ ur&)+ (+n)ru )r&n'(or)u* 6r&n+i i & )u)uror +*or*&*)or +*+-+n)+ &n+3+ un+i
uni)/ i -i*i)&r+ uni)/ i d+ o-uni& i+, uni)/ i -+di&*+, uni)/ i + +f+)u&u dif+ri)+ '+rviii
(+n)ru 'o*d& i, +)G.Un& din)r+ (ri-+*+ (+r'on&*i)/ i &r+ &u u)i*i1&) )+r-+nu* d+ *o0i')i/K, & fo') 8&ronu*
+*v+ i&n An)oin+ 9+nr< +-ini, &r+ *u()&'+ 5n &-(&nii*+ *ui N&(o*+on i &v+& d+i d+')u* d+
-u*)+ uno )in + 5n do-+niu* -i*i)&r i 6i&r *o0i')i. n *ur&r+& '& Su-&r &* &r)+i r/18oiu*uiK,
&(/ru)/ 5n $%, 8&ronu* 'u' in+ / *o0i')i& +')+ unu* din)r+ (i*onii (rini(&*i &i ondu+rii i
)i0/rii unui r/18oi. A(&r+ &')f+* o (ri-/ d+fini i+ & *o0i')iii &r+ (r+'u(un+ -u)&r+& i
(o1i ion&r+& &r-&)+i, d&r i & )u)uror -&)+ri&*+*or n++'&r+ &+')+i&.
3
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
5/52
Un &*) ')udiu &r+ & vi1&) *o0i')i& -i*i)&r/ +')+ Pure Logistics The Science of War
PreparationK Lo0i')i& &8'o*u)/ )iin4& Pr+0/)irii R/18oiu*uiG, (u8*i&) d+ /)r+ -&ioru*
&-+ri&n !+or0+ C. T6or(+ 5n &nu* $$>. So(u* r+'(+)ivu*ui ')udiu +r& d+ & +vid+n4i&
i-(or)&n & )+ori+i -i*i)&r/ & *o0i')iii d+nu-i)/ pure logisticsKG i -&i (u in (&r)+& &(*i&)/ &
&+')+i& d+nu-i)/ d+ /)r+ &u)or applied logisticsKG. Pu)+- '(un+ / &+')& & fo') unu* din)r+(ri-+*+ -&nu&*+ d+ *o0i')i/ (u8*i&)+. E*+-+n)u* (rini(&* 'u' inu) d+ /)r+ T6or(+ +')+
&r&)+ri')i& d+ 5n)r+0 & *o0i')iii. A')f+*, &u)oru* & d+-on')r&) (rin (u)+rni+ +3+-(*+ i')ori+
f&()u* / *o0i')i& n+in)+0r&)/ & + u&) 5n -&:ori)&)+& -&ri*or &-(&nii -i*i)&r+. Pu)+- -+n ion&
&ii R/18oiu* *ui N&(o*+on 5n Ru'i& din $$", '&u R/18oiu* Pru'i+i u Fr&n & din $@# $@$.
T9$>QD+ i T6or(+ & u)i*i1&) )+r-+nu* d+ *o0i')i/, in 'ri+ri*+ '&*+, &+')& nu & r+u i) '/ '+
i-(un/ 5n ')r&)+0ii*+ -i*i)&r+ din &+& (+rio&d/, d&r & /(/)&) )o)u i un ro* i-(or)&n) 5n do-+niu*
-i*i)&r, &')f+* / du(/ +* d+&* Doi*+& R/18oi Mondi&*, *o0i')i& -i*i)&r/ & d+v+ni) un do-+niu
')udi&) (+ *&r0. n do-+niu* +ono-i, *o0i')i& & &(/ru) du(/ $>#.Fi0ur& $.$ indi/ +vo*u4i& &+')+i& 5n )i-(. A')f+*, '+ o8'+rv/ / *& 5n+(u), &)ivi)/4i*+
*o0i')i+ +r&u '+(&r&)+, (+n)ru & 5n (r+1+n) '/ '+ vor8+&'/ d+'(r+ un -&n&0+-+n) in)+0r&) &*
*o0i')iii &r+ 0+')ion+&1/ o-(on+n)+ (r+u-H (*&nifi&r+& +r+rii, &6i1i4ii*+, 0+')iun+&
')ouri*or, d+(o1i)&r+&, di')ri8u4i& i )r&n'(or)u*.To) 5n &nii $># &(&r+ i )+r-+nu* d+ *o0i')i/ & fir-+iK business logisticsKG, &r+
d+'+-n& -&n&0+-+n)u* )u)uror &)ivi)/4i*or &r+ &'i0ur/ )r&n'f+ru* i oordon&r+&
&(rovi1ion/rii i di')ri8u4i+i 5n '+n'u* r+/rii u)i*i)/4ii d+ )i-( i '(&4iuK. 9EI!L>=Q
igura 1.1 !voluia logisticii n cadrul "rmei# $%&'()
)
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
6/52
1.1.* +e"nirea conceptului de logistic
oi (r+1+n)& )+v& d+fini4ii &*+ *o0i')iii (ro(u'+ d+& *un0u* )i-(u*ui.n $>",National Council of Physical istribution !anagement NCPDMG, d+fin+)+
*o0i')i& &')f+*H !ul"imea de activit"i implicate #n tranferul eficient al produselor finite de la
punctele de produc"ie la consumator $i #n unele cazuri a materialelor de la furnizor la unit"ile
de produc"ie% &cestea sunt' transportul( depozitarea( manipularea materialelor( ambalarea(
gestiunea stocurilor( selectarea loca"iilor fabricilor $i depozitelor( procesarea comenzilor(
previzionarea cererii $i serviciul ctre clien"iK.n &nu* $> &(&r+ d+fini4i& d&)/ d+ /)r+ Council of Logistics !anagementCLMG
&r+ 5n0*o8+&1/ (r&)i )+ndin4+*+ *o0i')iii &+*or &niH )Logistica este procesul de planificare(
implementare $i control al flu*urilor $i depozitrii eficiente $i eficace a materiilor prime(
stocurilor #n curs de produc"ie( produselor finite( $i a informa"iilor referitoare la acestea( de lapunctul de origine la punctul de consum al acestora( cu scopul conformrii cerin"elor
consumatorilor+% S+ o8'+rv/ f&()u* / &+&')/ d+fini4i+ (un+ &+n)u* (+ (*&nifi&r+,
i-(*+-+n)&r+ i on)ro*, d+i (+ &)ivi)/4i*+ d+ -&n&0+-+n) d+'f/ur&)+ 5n &dru* *o0i')iii.M&i r++n), 5n "##= &(&r+ (+n)ru *o0i')i/ d+fini4i&H ,a livra un produs( #n bun stare( la
momentul potrivit( #n locul potrivit( #n cantitatea corect $i necesar( #n ambala-ul de prezentare
corespunztor( precedate( #nso"ite $i urmrite de informa"ii corecte $i e*acte #nscrise pe
documente legale( totul #n cele mai bune condi"ii economice+ . AFRDU#=Q .
A+&')/ d+fini4i+ (un+ &+n) (+ dou-+n)+*+ &r+ 5n'o4+', onfir-/ i ur-/r+' f*u3u* d+infor-&4ii i &'i0ur/ ')&8i*ir+& i')oriu*ui )r&'+u*ui (&rur' 5n di')ri8u4i+.
Din d+fini4ii*+ (r+1+n)&)+ (n/ &ii, (o) on*u1ion& / *o0i')i& +')+ &)ivi)&)+& &r+ '+
ou(/ 5n (ri-u* rnd u )r&n'(or)u* -/rfuri*or '&u (rodu'+*or, d&r 'i u &6i1i4i&, d+(o1i)&r+& i
*ivr&r+& &+')or&.Du(/ (/r+r+& -+&, (rini(&*& o-(on+n)/ & &)ivi)/4ii *o0i')i+ '+ r+f+r/ *& )r&n'(or),
d+o&r++ &+')& 0+n+r+&1/ +*+ -&i -&ri o')uri i )o)od&)/ +')+ +* -&i 0r+u d+ 0+')ion&).
1.2 Transporturile element principal al activit ii logisticeTr&n'(or)u* r+(r+1in)/ -i &r+& o&-+ni*or, &ni-&*+*or '&u & 8unuri*or din)ro *o& i+ 5n
&*)&. Mod&*i)/ i*+ d+ )r&n'(or) in*udH &+ru*, &*+& f+r&)/, o'+&u&, &8*u*, ondu)& '&u '(& iu*.
Do-+niu* )r&n'(or)uri*or (o&)+ fi divi1&) 5n infr&')ru)ur/K, v+6iu*+K i o(+r& iuniK. Infr&')ru)ur& on')/ 5n in')&*& ii fi3+ '&u on')ru ii n++'&r+ )r&n'(or)u*ui, u- &r fiH
o'+*+, /i f+r&)+, /i &+ri+n+, &n&*+ f*uvi&*+ i )+r-in&*+ (r+u-H &+ro(or)uri, 0/ri, ')& ii,
d+(o1i)+, +). T+r-in&*+*+ (o) fi fo*o'i)+ &)) (+n)ru '6i-8&r+& (&'&0+ri*or '&u & -/rfuri*or, )
i (+n)ru -+n)+n&n /. +6iu*+*+ &r+ u)i*i1+&1/ &+')+ r+ +*+ (o) in*ud+H &u)o-o8i*+, 8ii*+)+,
&u)o8u1+, )r+nuri, &-io&n+ i &*)+*+. O(+r& iuni*+ 'un) r+(r+1+n)&)+ d+ -odu* 5n &r+ 'un)
$
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
7/52
u)i*i1&)+ v+6iu*+*+ i (ro+duri*+ '+)&)+ (+n)ru 'o(u* (ro(u'. n do-+niu* )r&n'(or)uri*or,
o(+r& iuni*+ i infr&')ru)ur& (o) fi &)) (u8*i+ ) i (riv&)+, 5n fun i+ d+ &r/. Din (un) d+ v+d+r+ +ono-i, (+rfor-&n & '+)oru*ui )r&n'(or)uri*or +')+ '+n'i8i*/ *&
(r+ u* (+)ro*u*ui. D+o&r++ o(+r& iuni*+ 0r&vi)+&1/ 5n :uru* v+6iu*+*or, (r+ u* o-8u')i8i*i*or
r+(r+1in)/ un o') '+-nifi&)iv &* o-(&nii*or + '+ ou(/ u )r&n'(or)uri*+. A)uni nd (r+ u*
(+)ro*u*ui r+ )+, o-(&nii*+ '+ & )+&()/ '/ )i0+ -&i (u in, 5n )i-( + &)uni nd (r+ u*
(+)ro*u*ui +')+ -i, 'i)u& i& fin&ni&r/ & o-(&nii*or +')+ 8un/.
1.3 Eficientizarea logisticii
C& 5n ori+ &*) do-+niu +ono-i, +fii+n)i1&r+& (r+'u(un+ r+du+r+& o')uri*or i
i-(*ii) -&3i-i1&r+& (rofi)u*ui. A')f+*, +for)uri*+ d+ +fii+n)i1&r+ & &)ivi)/4ii 'un) &n&*i1&)+ 5n
(ri-u* rnd /)r+ r+n)&8i*i1&r+& o(+r&4iuni*or *o0i')i+.
Un& din)r+ (ri-+*+ o( iuni *u&)+ in &*u* (+n)ru di-inu&r+& o')uri*or *o0i')i+ +')+
+3)+rn&*i1&r+& &+')or o(+r& iuni, uno'u)/ 'u8 d+nu-ir+& d+ outsourcing. Cu )o&)+ &+')+&, +')+
indi&) & &+&')& v&ri&n)/ '/ fi+ &do()&)/ &)uni nd &*i)&)+& '+rviii*or of+ri)+ d+ /)r+
o(+r&)oru* *o0i')i on)r&)&) +')+ +* (u in 'i-i*&r/ u +& +3i')+n)/ 5n o-(&ni+, i&r (r+ u* +ru)
+')+ onv+n&8i*.O &*)/ o( iun+ (o&)+ fi d+1vo*)&r+& (&ru*ui &u)o *o0i')iG ++& + &r (+r-i)+ of+rir+& d+
'+rviii /)r+ &*)+ fir-+, ++& + &du+ un v+ni) n++'&r &o(+ririi o')uri*or (ro(rii. A')f+* , +')+
d+')u* d+ d+' 5n)*ni)/ '+(&r&r+& &)ivi)/ ii *o0i')i+ 5n)ro +n)i)&)+ d+ 'in+ ')/)/)o&r+, &r+ &o(+r/
&)) n+voi*+ o-(&ni+i, d&r of+r/ i '+rviii /)r+ +3)+rior. Pr&)i, (u)+- '(un+ / +')+ r+&)
o(+r&)oru* *o0i')i n++'&r d+'f/ ur/rii &)ivi)/ ii o-(&ni+i. C+& d+& )r+i& o( iun+ '+ r+f+r/ *& 5n+r&r+& d+ o()i-i1&r+ & &)ivi)/ ii d+'f/ ur&)+ d+
(&ru* *o0i')i, ++& + (r+'u(un+ &d-ini')r&r+& +fii+n)/ & d+(o1i)+*or i & (&ru*ui &u)o, d&r i
5-8un/)/ ir+& (ro+'+*or d+ &(rovi1ion&r+ i di')ri8u i+. A')f+*, +fii+n)i1&r+& o')uri*or *o0i')i+ n++'i)/ o o(+r&4iun+ o-(*+3/ d+'f/ ur&)/ *&
niv+*u* 5n)r+0ii o-(&nii. A+')/ o(+r&4iun+ (r+'u(un+ +3i')+n4& unui 'i')+- infor-&)i &(&8i*
'/ 0+')ion+1+ f*u3uri*+ d+ *uru i '/ ur-/r+&'/ o')uri*+ o(+r&4ion&*+.or8i- d+'(r+ &)ivi)&)+ *o0i')i/ nu nu-&i 5n &dru* fir-+*or d+ di')ri8u4i+ '&u &*
fir-+*or + -&ni(u*+&1/ -&rfuri, ) i 5n &dru* &*)or fir-+ &r+ d+4in un (&r &u)o + i-(*i/
+f+)u&r+& d+ nu-+ro&'+ ur'+ i d+(*&'/ri (+n)ru 5nd+(*inir+& o8i+)iv+*or o-(&ni+i.A')f+*, on'id+r / (rini(&*& &)ivi)&)+ + )r+8ui+ r+n)&8i*i1&)/ +')+ &)ivi)&)+& d+
)r&n'(or)uri, &r+ 0+n+r+&1/ +*+ -&i -&ri o')uri. Din (un) d+ v+d+r+ infor-&)i, && u- &-
(r+i1&) i -&i 'u', +fii+n)i1&r+& (r+'u(un+ +3i')+n4& unor &(*i&4ii + &u &u & 'o( ur-/rir+& i
0+')ion&r+& o')uri*or i & 6+*)ui+*i*or ur+n)+ i vii)o&r+.O &(*i& i+ o-(*+3/ + &r+ & 'o( &d-ini')r&r+& &)ivi)/ ii *o0i')i+ i i-(*ii)
+fii+n)i1&r+& &+')+i&, )r+8ui+ '/ ur-+1+ -&i -u*)+ dir+ ii d+ d+1vo*)&r+H
%
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
8/52
d+finir+& i (*&nifi&r+& ru)+*or (&rur'+ d+ v+6iu*+*+ fir-+i o()i-i1&r+& ru)+*or (*&nifi&)+ 1i*ni (rin &(*i&r+& unor &8*o&n+, (+n)ru & in+ 'u8 on)ro*
o')uri*+ d+ )r&n'(or) 'u(or) (+n)ru +*&8or&r+& unor ')r&)+0ii d+ )r&n'(or)uri (+ )+r-+n *un0, (rin (r+vi1ion&r+&
o')uri*or &d-ini')r&r+& r+'ur'+*or & (+r'on&*u*ui, & v+6iu*+*or i & -&)+ri&*+*or )r&n'(or)&)+G +*&8or&r+& d+ r&(o&r)+ + i*u')r+&1/ &)ivi)&)+& *o0i')i/ & o-(&ni+i.
O(ini& -+& +')+ / +*+ -&i i-(or)&n)+ +*+-+n)+ &*+ un+i &')f+* d+ &(*i& ii 'un) r+(r+1+n)&)+
d+ &d-ini')r&r+& r+'ur'+*or 'i +*&8or&r+& d+ r&(o&r)+ n++'&r+ o8'+rv/rii &)ivi)/ ii o-(&ni+i,
d+o&r++ o &(*i& i+ + on in+ &+')+ -odu*+ (o&)+ fi u)i*i1&)/ &)) + o fir-/ -i/, ) i d+ o
o-(&ni+ &* /r+i o8i+) d+ &)ivi)&)+ +')+ ')ri) *o0i')i& i (ro+'+&1/ o -u*)i)udin+ d+ o-+n1i
i )r&n'(or)uri 1i*ni.
1.4 Fluxuri informaionale n activitatea e logistic
P+n)ru & d+1vo*)& o &(*i& i+ d+ &d-ini')r&r+ & &)ivi)/ ii *o0i')i+, &n&*i')u*
(ro0r&-&)oru* )r+8ui+ '/ 5n +*+&0/ -odu* d+ for-&r+ & f*u3uri*or infor-& ion&*+ id+n)ifi&)+ 5n
&)ivi)&)+& o-(&ni+i.P+n)ru & id+n)ifi& +n)i)/4i*+ + vor fi *u&)+ 5n &*u* *& d+1vo*)&r+& &(*i&4i+i voi (*+& d+
*& o d+fini4i+ & *&n4u*ui d+ &(rovi1ion&r+ supply chainG, &* un+i 5n)r+(rind+ri.A')f+*, &+')&
in*ud+ )o4i furni1orii, &(&i)/4i*+ d+ (rodu4i+, +n)r+*+ d+ di')ri8u4i+, d+(o1i)+*+ i *i+n4ii,5-(r+un/ u -&)+rii*+ (ri-+, ')ou* d+ (rodu'+ '+-if&8ri&)+ i ')ou* d+ (rodu'+ fini)+ i u
)o&)+ r+'ur'+*+ i infor-&4ii*+ i-(*i&)+ 5n '&)i'f&+r+& +rin4+*or *i+n4i*or ++& + 5n'+&-n/ /
*&n4u* d+ &(rovi1ion&r+ +')+ un (ro+' &r+ *+&0/ furni1orii, (rodu/)orii, d+(o1i)+*+, di')ri8ui)orii
i *i+n4ii. LUCO#>QPu)+- &(r+i& / *&n4u* d+ &(rovi1ion&r+ +')+ d+'ri' u &:u)oru* o')uri*or i v+ni)uri*or
i-(*i&)+H o')uri u furni1orii -&)+rii*+ (ri-+ i -&)+ri&*+*+, o')uri d+ )r&n'(or), o')uri d+
(rodu4i+, o')uri d+ d+(o1i)&r+ i di')ri8u4i+ i v+ni)uri d+ *& *i+n4i.
Con+()u* d+ supply chain*&n4 d+ &(rovi1ion&r+G & fo') fo*o'i) ini4i&* (+n)ru & d+fini)r&'+u* (&rur' d+ -&)+ri&*+ -&rf/ d+ *& furni1or *& fir-/.
O &(*i&4i+ infor-&)i/ + &r+ 'o(u* d+ & +fii+n)i1& *o0i')i& )r+8ui+ '/ 0+')ion+1+ i '/
(r+vi1ion+1+ +r+ri*+, 'inroni1nd &(rovi1ion&r+& u +r+r+&. Cor+*&r+& of+r)+i u +r+r+& du+
*& *ivr&r+& (rodu'u*ui o-&nd&) *& *ou* i -o-+n)u* (o)rivi). D&/ &+&')/ &(rovi1ion&r+ +')+
f/u)/ 5n ondi4ii*+ +3i')+n4+i o-+n1ii, &)uni fir-+*+ (o) '/i r+du/ ')ouri*+ i 6i&r '/
*ur+1+ u un ')o &(ro(i&) d+ +* ri)i.n on)inu&r+ voi (r+1+n)& (rini(&*+*+ f*u3uri d+ (ro+'+ infor-&4ion&*+ &*+ unui *&n4 d+
&(rovi1ion&r+, i*u')r&)+ 5n fi0ur& $.% . A')f+*, (u)+- id+n)ifi& +* (u4in ur-/)orii &)ori (rini(&*i+ (&r)ii(/ *& r+&*i1&r+& f*u3uri*or infor-&4ion&*+H
&
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
9/52
Pani#care
ecutare
Contro/anager parc ogistic
0perator
*i+n)u*H u-(/r/ 8unuri i '+rviii furni1oru*H vind+ 8unuri i '+rviii 'i')+-u* d+ &(rovi1ion&r+H &6i1i4ion+&1/8unuri i '+rviii d+ *& furni1ori 'i')+-u* d+ d+'f&+r+H vind+ 8unuri i '+rviii *i+n4i*or 'i')+-u* d+ (rodu4i+H (rodu+ 8unuri i '+rviii 'i')+-u* d+ )r&n'(or)H )r&n'(or)/ 8unuri.
d+(o1i)+*+H 0+')ion+&1/ 8unuri*+ (rodu'+ i'&u &6i1i4ion&)+.
igura 1.* Procese ,i uuri in/ormaionale n lanul de des/acere# $0&233)
D+o&r++, 5n (r+1+n)& *ur&r+ n+ &3/- 5n (ri-u* rnd (+ &)ivi)&)+& d+ )r&n'(or)uri, f*u3u*
infor-& ion&* *u&) 5n &*u* +')+ unu* 'i-(*ifi&) i ur-/r+ )+ do&r *ivr&r+& 8unuri*or '&u
)r&n'(or)u* (+r'o&n+*or 5n)r+ dou/ *o& ii i f&+ *+0/)ur& 5n)r+ '+rviii*+ d+ &(rovi1on&r+ i
*ivr&r+.Fi0ur& $.% (+1in)/ f*u3u* infor-&4ion&* + d+'ri+ &)ivi)&)+& d+ )r&n'(or)uri. O8'+rv/-
&')f+* / o(+r&)oru* *o0i')i of+r, v+6iu*G +3+u)/ ur'&, 5n )i-( + -&n&0+ru* (&ru*ui *o0i')i
'+ ou(/ u oordon&r+& &)ivi)/4ii (*&nifi&r+ i on)ro*G.
igura 1.4 luul in/ormaional al activitii logistice din cadrul unei companii
*
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
10/52
2. Te!nologiile informatice utilizate la realizarea aplica iei e
aministrare a logisticii
n on)inu&r+ vor fi (r+1+n)&)+ )+6no*o0ii*+ u)i*i1&)+ (+n)ru r+&*i1&r+& &(*i& i+i d+
&d-ini')r&r+ & &)ivi)/ ii *o0i')i+. Tr+8ui+ (r+i1&) / &(*i& i& v& fi un& .eb/based(&di/ o
&(*i& i+ + v& (u)+& fi &+'&)/ 5n)run n&vi0&)or 7+8 i v& ru*& (+ un '+rv+r 9TTP.
2.1 "rezentare general a unei aplica ii #e$
T+r-+nu* d+ &(*i& i+ 7+8 +')+ fo*o'i) (+n)ru o &(*i& i+ &r+ +')+ &+'&)/ d+ u)i*i1&)ori
(rin in)+r-+diu* un+i r+ +*+ in)+rn+) in)r&n+)G. A+') )+r-+n (o&)+ d+ &'+-+n+& '/ d+'+-n+1+ o
&(*i& i+ 'of)7&r+ 'ri'/ 5n)run *i-8&: d+ (ro0r&-&r+ 'u(or)&) d+ n&vi0&)or 0bro.ser/supported1
(r+u- &v&Sri() '&u :;u+r< o-8in&) u un *i-8&: d+ -&r&r+ (r+u- 9TML i &r+ '+
8&1+&1/ (+ un 8ro7'+r 7+8 (+n)ru r+d&r+& &(*i& i+i +3+u)&8i*+.A(*i& i& (+n)ru &d-ini')r&r+& &)ivi)/ ii d+ *o0i')i/ '+ v& 8&1& (+ -&i -u*)+ )+6no*o0ii.
9TML, CSS i ;u+r< &u fo') fo*o'i)+ (+n)ru (&r)+& vi1u&*/ i r+&r+& in)+rf+ +i, 5n )i-( + P9P
'+ ou(/ u (r+*ur/ri*+ + &u *o (+ '+rv+r &'i0ur/ fun ion&*i)&)+& &(*i& i+iG i&r M
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
11/52
(&r&0r&f+, *i')+, +)G. 9TML (+r-i)+ & fi+&r+ dou-+n) '/ (o&)/ fi *+0&) d+ &*)+*+ (rin
6i(+r*+0/)uri hyperlin2sG &r+ for-+&1/ .eb/ul.Li-8&:u* 9TML (o&)+ fi i)i) i +di)&) fo*o'ind ori+ +di)or 'i-(*u d+ )+3). Cu )o&)+
&+')+&, 'ri+r+& i -odifi&r+& (&0ini*or 'o*ii)/ un+*+ uno )in + d+ 9TML i on'u-/ )i-(,
&')f+* / d+& *un0u* )i-(u*ui &u &(/ru) (ro0r&-+ u)i*i)&r+ u 'o(u* d+ & f&i*i)& r+&r+& d+
(&0ini 7+8. Edi)o&r+*+ 0r&fi+ d+nu-i)+ 0+n+ri VWSIVW! X .hat you see is .hat you getKG
(r+u- M&ro-+di& Dr+&-7+&v+r, Ado8+ !oLiv+ '&u Miro'of) Fron)P&0+ (+r-i) & (&0ini*+
7+8 '/ (o&)/ fi r+&*i1&)+ u or d+ /)r+ oriin+ &r+ &nu-i)+ uno )in + d+ o(+r&r+ & &*u*&)oru*ui.
D+ i r+&r+& 'i)+uri*or fo*o'ind &+') )i( d+ (ro0r&-+ +')+ -u*) -&i u o&r/, )r+8ui+ (r+i1&) /
d+ +*+ -&i -u*)+ ori odu* 9TML 0+n+r&) d+ &+')+& +')+ d+ o &*i)&)+ '*&8/.VII#$Q.9TML (o&)+ fi 0+n+r&) dir+) (rin u)i*i1&r+& unor )+6no*o0ii d+ (ro0r&-&r+ din (&r)+&
'+rv+ru*ui, (r+u- H P9P9
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
12/52
Prin)r+ 8+n+fiii*+ CSS (u)+- +nu-+r&H for-&)&r+& +')+ in)rodu'/ 5n)run 'in0ur *o (+n)ru
)o) dou-+n)u*, +di)&r+& r&(id/ & +)i6+)+*or, -i or&r+& odu*ui (&0inii i i-(*ii) 5n/r&r+&
-&i r&(id/ & &+')+i&.Sin)&3& CSS +')+ 5-(/r i)/ 5n )r+i &)+0oriiniv+*+H
niv+*u* $ r+(r+1in)/ (ro(ri+)&)i*+ +)i6+)+*or din dou-+n)u* 9TML, fo*o'ind &)ri8u)u* style
0)i( inline16 niv+*u* " r+(r+1in)/ infor-& i& in)rodu'/5n 8*ou* 9EAD, u)i*i1nd -&r&:u* 7style8
0embedded16
niv+*u* % r+(r+1in)/ o-+n1i*+ &f*&)+ 5n (&0ini '+(&r&)+ e*terne1%
C+& -&i -&r+ (riori)&)+ o &r+ 'in)&3& d+ niv+*u* $ inlineG i&r +& -&i -i/ o &r+ +& d+ niv+*u* %.
U)i*i1&r+& niv+*u*ui % fi i+r +3)+rn &r+ on in+ o-+n1i CSSG +')+ (r&)i& r+o-&nd&)/
d+o&r++ (o&)+ fi u)i*i1&) 5n -&i -u*)+ 'i)u& ii -&i -u*)+ fi i+r+ 9TML (o) fo*o'i &+*& i fi i+r
+3)+rn CSSG +*i-innd &')f+* )i-(u* n++'&r in)rodu+rii odu*ui or+'(un1/)or 5n fi+&r+ (&0in/i f&i*i)nd +di)&r+& *or 5n)run 'in0ur *o (+n)ru -&i -u*)+ fi i+r+.
A(*i& i& d+'ri'/ 5n (r+1+n)& *ur&r+ u)i*i1+&1/ CSS (+n)ru for-&)&r+& on inu)u*ui i
(r+1+n)&r+& &)r&)iv/ & (&0ini*or. Fi i+ru* CSS u)i*i1&) +')+ (r+1+n)&) 5n An+3& 2.
2.4 *+uer,
*+uer,+')+ o 8i8*io)+/ &v&Sri() on+(u)/ (+n)ru & 'i-(*ifi& 'ri()uri*+ d+ (+ (&r)+&
d+ *i+n) i &nu-+ 'ri()uri*+ +3+u)&)+ (rin in)+r-+diu* +*+-+n)+*or 9TML. A fo') *&n'&)/ 5n
i&nu&ri+ "##> d+ /)r+ o6n R+'i0. Sin)&3& :;u+r< f&+ -&i u o&r/ n&vi0&r+& 5n)run dou-+n),
'+*+)&r+& +*+-+n)+*or din DOM ocument 9b-ect !odelG, r+&r+& &ni-& ii*or, -&ni(u*&r+&
+v+ni-+n)+*or i 6i&r d+1vo*)&r+& d+ &(*i& ii AA. :;u+r< of+r/ d+ &'+-+n+& (o'i8i*i)&)+&
d+1vo*)&)ori*or d+ & r+& +3)+n'ii (+n)ru 8i8*io)+i*+ d+ &v&Sri(). A')f+*, '+ (o) &8')r&)i1&
in)+r& iuni*+ , &ni-& ii*+ i +f+)+*+.
:;u+r< (+r-i)+ 5nd+(*inir+& unor '&rini (r+u-H &+'&r+& unor &nu-i)+ (/r i din (&0in/ i )r&v+r'&r+& +*+-+n)+*or (&0inii
-odifi&r+& &'(+)u*ui un+i (&0ini i (o'i8i*i)&)+& '6i-8/rii din&-i+ & (ro(ri+)/ i*or du(/ 5n/r&r+& (&0inii
-odifi&r+& on inu)u*ui (&0ini*or )+3), i-&0iniG r/'(un' *& in)+r& iun+& u)i*i1&)oru*ui u +*+-+n)+*+ 9TML &d/u0&r+& d+ &ni-& ii o-(*+3+
Plugin/urile'&u +3)+n'ii*+ 'un) +*+ -&i in)+r+'&n)+ f&i*i)/ i of+ri)+ d+ :;u+r
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
13/52
f&()u* / d+1vo*)&r+& i )+')&r+& o-(on+n)+*or '+ f&+ ono-i)+n) u d+1vo*)&r+& 8i8*io)+ii
(rini(&*+, &')f+* / +')+ +*i-in&)/ ino-(&)i8i*i)&)+&.Du(/ (/r+r+& -+&, +& -&i &)r&)iv/ &r&)+ri')i/ & :;u+r< +')+ f&()u* / (rin
-u*)i)udin+& d+ +3)+n'ii 'i u)i*i1/ri (o&)+ furni1& 'o*u ii ) -&i div+r'ifi&)+, du(/ u- '(un+& i
r+&)oru* 8i8*io)+ii, o6n R+'i0H < love seeing cases .here an &P< that < thought < 2ne. .ell is
turned around and used in ne. and interesting .aysK. RE#Qn &dru* &(*i& i+i d+ *o0i')i/, :;u+r< &'i0ur/ 5n (ri-u* rnd in)+r&)ivi)&)+&
u)i*i1&)oru*ui u -+diu* d+ *uru.
2.- "%"
"%" P5P 5yperte*t Preprocessor( ini i&* Personal 5ome PageG +')+ un *i-8&: d+
(ro0r&-&r+ server/side d+')in&) d+1vo*)/rii 7+8, d&r fo*o'i) d+ &'+-+n+& & un *i-8&: d+
(ro0r&-&r+ d+ u1 0+n+r&*. P9P & fo') r+&) ini i&* d+ /)r+ R&'-u' L+rdorf 5n $=, i&r &u- +')+
(rodu' d+ !ru(u* P9P. Li-8&:u* P9P & &(/ru) 5n $= d+o&r++ R&'-u' L+rdorf dor+& '/ &f*+
)+ vi1i)/ri &r+ Cu* *ui on*in+. P9P 5n+(+ '/ fi+ r+-&r&) din -o-+n)u* 5n &r+ Z++v Sur&'Ji
i Andi !u)-&n' &u r+'ri' -o)oru*, &r+ v& (ur)& nu-+*+ d+ Z+nd, o o-8in& i+ & (r+nu-+*or
+*or doi (ro0r&-&)ori. D&)ori)/ f&()u*ui / +')+ open/source, P9P (rofi)/ d+ f&()u* / &r+ un
'u(or) &)iv din (&r)+& o-uni)/4ii on*in+ i '+ d+1vo*)/ fo&r)+ r&(id. In)+r(r+)oru* P9P +')+ +*
-&i u)i*i1&) *i-8&: d+ (ro0r&-&r+ fo*o'i) (+n)ru r+&*i1&r+& 'i)+uri*or V+8 din&-i+. Dif+r+n4&
f&4/ d+ &*)+ *i-8&:+ d+ (ro0r&-&r+ (r+u- &v&Sri()G +')+ r+(r+1+n)&)/ d+ f&()u* / P9P+3+u)/ o(+r& ii*+ (+ '+rv+r i nu (+ &*u*&)oru* *i+n). A')f+*, P9P (o&)+ &+'& 8&1+ d+ d&)+,
fi i+r+ i &*)+ r+'ur'+ *& &r+ &v&Sri() nu &r+ &+'. n (*u', P9P in)+r(r+)+&1/ in')ru iuni*+ (+
'+rv+r i r+)urn+&1/ od 9TML n++'&r (&0ini*or 7+8. 9TML +')+ un *i-8&: ')&)i, i&r odu*
'ri' 5n 9TML +')+ '&*v&) 5n fi i+r+ + (o) fi vi1u&*i1&)+ (rin &(+*&r+& *or 5n 8ro7'+r. D&/ +')+
n++'&r/ -odifi&r+& on inu)u*ui (&0ini*or 9TML 5n)run -od din&-i i 6i&r r+&r+&
dou-+n)+*or 9TML 5n fun i+ d+ &nu-i)+ ondi ii, v& fi fo*o'i) un *i-8&: d+ 'ri()in0 (+ '+rv+r,
(r+u- P9P, P+r*, ASP '&u &*)+*+. R+'(+)iv+*+ (&0ini (o) on in+ fun ii d+ in)+ro0&r+ & 8&1+i d+ d&)+, (r+*u&r+& d+ d&)+ d+ (+ &*)+ 'i)+uri '&u din &*)+ fi i+r+, i&r 5n fin&* +')+ on')rui)/ o
(&0in/ 9TML )ri-i'/ /)r+ 8ro7'+r. Codu* P9P nu +')+ vi1i8i* vi1i)&)ori*or. E* nu +')+ o-(i*&),
i r/-n+ (+ '+rv+r i *& fi+&r+ +r+r+ din (&r)+& *i+n)u*ui +')+ in)+r(r+)&) i do&r r+1u*)&)u*
9TMLG +')+ vi1i8i*.
P9P & fo') fo*o'i) i 5n &dru* &+')ui (roi+) (+n)ru & i-(*+-+n)& fun ion&*i)&)+&
&(*i& i+i (+ (&r)+& d+ '+rv+r i d+ *uru u d&)+*+.
12
http://www.google.com/search?client=opera&rls=en&q=about+Rasmus+Lerdorf&sourceid=opera&ie=utf-8&oe=utf-8http://www.google.com/search?client=opera&rls=en&q=about+Rasmus+Lerdorf&sourceid=opera&ie=utf-8&oe=utf-8http://www.google.com/search?client=opera&rls=en&q=about+Rasmus+Lerdorf&sourceid=opera&ie=utf-8&oe=utf-8http://www.zend.com/zend/founders.phphttp://www.zend.com/zend/founders.phphttp://www.zend.com/zend/founders.phphttp://www.google.com/search?client=opera&rls=en&q=about+Rasmus+Lerdorf&sourceid=opera&ie=utf-8&oe=utf-8http://www.google.com/search?client=opera&rls=en&q=about+Rasmus+Lerdorf&sourceid=opera&ie=utf-8&oe=utf-8http://www.zend.com/zend/founders.phphttp://www.zend.com/zend/founders.php -
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
14/52
2. &,)/l
&,)+'+')+ un'i')+- d+ 0+')iun+ & 8&1+*or d+ d&)+r+*& ion&* , r+&) d+ o-(&ni&
'u+d+1& M
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
15/52
d+ r&(id i or+). M
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
16/52
Cod+i0ni)+r +')+ d+ &'+-+n+& un (rodu' 'of)7&r+ u 'ur'/ d+'6i'/, &')f+* / +* (o&)+ fi
-odifi&) i u)i*i1&) du(/ u- dor+ )+ fi+&r+ (ro0r&-&)or. Cod+I0ni)+r &r+ un+*+ &r&)+ri')ii
(o1i)iv+ &r+ 5* f& '/ fi+ unu* din)r+ +*+ -&i u)i*i1&)+ &dr+ d+ *uru u P9PH ou(/ fo&r)+ (u in/ -+-ori+ d+o&r++ 'i')+-u* '/u +n)r&* on in+ do&r )+v&
8i8*io)+i -ii, i&r +*+*&*)+ 8i8*io)+i n++'&r+ 'un) 5n/r&)+ din&-i *& +r+r+ +')+ (rin)r+ +*+ -&i r&(id+ &dr+ d+ *uru, 5n (ri-u* rnd d&)ori)/ &r&)+ri')iii
(r+1+n)&)+ *& (un)u* &n)+rior +')+ +3)+n'i8i*H ori+ (ro0r&-&)or 5 i (o&)+ &d/u0& (ro(rii*+ 8i8*io)+i '&u *+ (o&)+
&d&()& (+ +*+ +3i')+n)+ +')+ (u)+rni dou-+n)&) i 'u' inu) d+ o o-uni)&)+ r+*&)iv -&r+ d+ d+1vo*)&)ori fo*o'+ )+ &r6i)+)ur& Mod+*i+7Con)ro**+rUn& din)r+ +*+ -&i i-(or)&n)+ f&i*i)/ i of+ri)+ d+ Cod+i0ni)+r +')+ i-(*+-+n)&r+&
&r6i)+)urii MC &r+ (+r-i)+ '+(&r&r+& *o0iii &(*i& i+i d+ (r+1+n)&r+& &+')+i&.
MC, '&u!odel/3ie./ControllerMod+* i1iun+ Uni)&)+ d+ on)ro*G +')+ un &8*ond+ d+1vo*)&r+ &r+ f&+ & (&0ini*+ 7+8 '/ on in/ ) -&i (u in od 'ur'/ 'ri' (rin)r+
+*+-+n)+*+ d+ (r+1+n)&r+ & &(*i& i+i. Cod+i0ni)+r *ur+&1/ u P9P=, &')f+* / in)rodu+
(ro0r&-&r+& ori+n)&)/ (+ o8i+)+, i&r fi+&r+ +*+-+n) -od+*, vi1iun+, uni)&)+ d+ on)ro*G v& fi
d+fini) & o *&'/ u (ro(ri+)/ i i -+)od+ '(+ifi+. Mod+*u* on in+ fun ii + r+&*i1+&1/ r+0/'ir+&, in'+r&r+& '&u &)u&*i1&r+& infor-& ii*or
din 5n 8&1& d+ d&)+. i1iun+& r+(r+1in)/ infor-& i& (r+1+n)&)/ u)i*i1&)oru*ui. O vi1iun+ (o&)+ fi
&)) o (&0in/ 7+8 ) i do&r un fr&0-+n) din &+&')&, (r+u- 6+&d+r '&u foo)+r. Uni)&)+& d+
on)ro* '+rv+ )+ & i in)+r-+di&r 5n)r+ -od+* i vi1iun+, d&r (o&)+ f&+ *+0/)ur& u ori+ &*)/
r+'ur'/ n++'&r/.n fi0ur& %.$ '+ o8'+rv/ -odu* 5n &r+ in)+r& ion+&1/ +*+ % +*+-+n)+ &*+ &r6i)+)urii.
A')f+*, din vi1iun+ 'un) )ri-i'+ +r+ri /)r+ uni)&)+& d+ on)ro* &r+ *+ (ro+'+&1/ i d&/ &r+
n+voi+ d+ d&)+ &(+*+&1/ -od+*u* i&r &(oi )ri-i)+ r/'(un'u* /)r+ vi1iun+ &r+ &fi +&1/
infor-& ii*+. D&/ nu &r+ n+voi+ d+ 8&1& d+ d&)+, uni)&)+& d+ on)ro* do&r r/'(und+ vi1iunii.A+') -od d+ u)i*i1&r+ (o&)+ fi +3)in', 5n '+n'u* / -od+*+*+ (o) fi &+'&)+ dir+) din vi1iun+,
5n'/ &+&')/ (r&)i/ nu +')+ r+o-&nd&)/ d+o&r++ 5n&r/ (&0in& 7+8vi1iun+&G u od 'ur'/
&r+ 5n -od nor-&* )r+8ui+ (ro+'&) d+ uni)&)+& d+ on)ro*.
igura *.5 6r7itectura %odel 8 9ie: 8 Controller# $;I
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
17/52
(r+1+n)&r+, &+')+& fiind i -o)iv+*+ d&)ori)/ /ror& &- u)i*i1&) Cod+i0ni)+r 5n r+&*i1&r+&
&(*i& i+i.
2. Eclipse
Eclipse +')+ un -+diu d+ d+1vo*)&r+ u 'ur'/ d+'6i'/, in)+0r&) IDE
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
18/52
"ate !otare
emente auiiare
+tiizator
igura 4.= luul in/ormaional ce st la >aza aplicaiei
3.2 "roiectarea $azei e ate
Proi+)&r+& 8&1+i d+ d&)+ (r+'u(un+ uno& )+r+& (ro8*+-+i + )r+8ui+ r+1o*v&)/ d+ /)r+
&(*i& i+ i 5n (ri-u* rnd uno& )+r+& d&)+*or + )r+8ui+ r+ inu)+ di-+n'iun+, )i(o*o0i+, +)G.
3.2.1 5o iuni teoreticen (ri-u* rnd, )r+8ui+ (r+i1&) f&()u* / r+&*i1&r+& un+i &(*i& ii u 8&1+ d+ d&)+ n++'i)/
+3i')+n & unui 'i')+- d+ 8&1+ d+ d&)+ DBS X atabase SystemG, + r+(r+1in)/ un '+) d+ +*+-+n)+
in)+ron+)&)+ (rin in)+r-+diu* /ror& '+ r+&*i1+&1/ o*+)&r+&, ')o&r+& i (ro+'&r+& d&)+*or.Din fi0ur& %." '+ o8'+rv/ f&()u* / u)i*i1&)oru* in)+r& ion+&1/ u 'i')+-u* d+ 8&1+ d+ d&)+
(rin in)+r-+diu* (rodu'+*or 'of)7&r+ in')&*&)+, &r+ r+&*i1+&1/ *+0/)ur& u d&)+*+, d&r i u &*)+
&(*i& ii &u3i*i&r+.
igura 4.( Componentele ar7itecturii unui sistem de >aze de date# $L29!?&3')
Din &)+0ori& (rodu'+*or 'of)7&r+, +* -&i i-(or)&n) +')+ Si')+-u* d+ !+')iun+ & B&1+i d+
D&)+S!BDG, + r+(r+1in)/ un &n'&-8*u d+ (ro0r&-+ + of+r/ o in)+rf& / 5n)r+ 8&1& d+ d&)+ i
u)i*i1&)ori. Un S!BD +')+ o o-(on+n)/ 'of)7&r+ & unui 'i')+- d+ 8&1+ d+ d&)+ &r+
in)+r& ion+&1/ u )o&)+ +*+*+*)+ o-(on+n)+, &'i0urnd on+)&r+& i ind+(+nd+n & din)r+
+*+-+n)+*+ 'i')+-u*ui.K LUEBO#Q. A')f+*, un S!BD &r+ ro*u* d+ & &'i0ur&H d+finir+& i
d+'ri+r+& ')ru)urii 8&1+i d+ d&)+, 5n/r&r+& i v&*id&r+& d&)+*or, &+'u* *& d&)+ (+n)ru o(+r& ii
d+ on'u*)&r+, in)+ro0&r+ '&u &)u&*i1&r+, -+n)+n&n & 8&1+i d+ d&)+ i (ro)+ i& 8&1+i d+ d&)+. Fi0ur& %.% (r+1in)/ fun ii*+ unui S!BD d+'ri+r+, -&ni(u*&r+, &d-ini')r&r+ i u)i*i1&r+G, &r+
'un) in)+ron+)&)+ i &'i0ur/ fun ion&*i)&)+& 5n)r+0u*ui 'i')+-. A')f+*, fun i& d+ u)i*i1&r+ &r+
ro*u* d+ & r+&*i1& in)+rf& & u u)i*i1&)oru*, fun i& d+ d+'ri+r+ d+fin+ )+ ')ru)ur& 8&1+i d+ d&)+
(rin *i-8&:u* d+ d+'ri+r+ & d&)+*or LDDG, fun i& d+ -&ni(u*&r+ r+&*i1+&1/ in'+r&r+& i 1&
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
19/52
utiizare
descrieremanipuare administrare
4aza dedate
utiizatori
(r+*ur&r+& d&)+*or (rin *i-8&:u* d+ -&i(u*&r+ & d&)+*or LMDG, i&r fun i& d+ &d-ini')r&r+
0+')ion+&1/ 8&1& d+ d&)+.
igura 4.@ unciile unui SA?+# $L29!?&3')
n)run 'i')+- d+ &*u*, d&)+*+ 'un) ')o&)+ &)) 5n -+-ori& in)+rn/ )+-(or&r/G, d&r -&i
&*+' 5n -+-ori& +3)+rn/. S)o&r+& d&)+*or 5n -+-ori& +3)+rn/ & fo') ondi ion&)/ d+ &'(+)+
(r+u- H &+'u* r&(id i u or *& d&)+, vo*u-u* d+ d&)+ )o) -&i -&r+, r+ )+r+& o-(*+3i)/ ii
d&)+*or, (+rf+ ion&r+& +6i(&-+n)+*or d+ ')o&r+ i nu 5n u*)i-u* rnd *uru* 5n r+ +*+*+ d+
&*u*&)o&r+.S)o&r+& d&)+*or '+ (o&)+ f&+ &)) 5n fi i+r+, ) i 5n 8&1+ d+ d&)+ &r+ &u +vo*u&)
din fi i+r+G.B&1& d+ d&)+ +')+ un &n'&-8*u d+ o*+ ii d+ d&)+ or0&ni1&) o+r+n), ')ru)ur&) &')f+* 5n)
r+dund&n & '/ fi+ -ini-/ i on)ro*&)/, i&r &+'u* *& d&)+ '/ fi+ (+r-i' -&i -u*)or u)i*i1&)ori
'i-u*)&n i 5n )i-( u)i*. D+ i +3i')/ -&i -u*)+ 0+n+r& ii d+ 8&1+ d+ d&)+ &r8or+'+n)+, r+ +&,
r+*& ion&*+ , ori+n)&)+ o8i+)G, +*+ -&i u)i*i1&)+ 5n (r&)i/ 'un) +*+ r+*& ion&*+ &(ro3i-&)iv
@=] din )o)&*G.P+n)ru & 5n +*+0+ on+(u)u* d+ 8&1/ d+ d&)+, voi (r+1+n)& (+ 'ur) +*+-+n)+*+ un+i 8&1+ d+ d&)+H
omeniul e valorid+'+-n+&1/ -u* i-+& v&*ori*or (o'i8i*+ (+n)ru o &r&)+ri')i/ caracteristicar+(r+1in)/ d+finir+& i d+'ri+r+& unui &nu-i) &'(+) din)ro +n)i)&)+ din *u-+&
r+&*/ familia e caracteristicir+(r+1in)/ &n'&-8*u* (ro(ri+)/ i*or &r+ '+ r+f+r/ *& &++& i +n)i)&)+
din *u-+& r+&*/1*
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
20/52
colec ia e ate r+(r+1in)/ o f&-i*i+ d+ &r&)+ri')ii &'u(r& /r+i& '+ &(*i/ un (r+di&) &r+
r+(r+1in)/ o *+0/)ur/ 5n)r+ o*+ i& ur+n)/ d+ d&)+ i o &*)/ o*+ i+.
Pu)+- d+i '(un+ & 8&1& d+ d&)+ +')+ un &n'&-8*u d+ o*+ ii d+ d&)+ &f*&)+ 5n in)+rd+(+nd+n /
5-(r+un/ u d+'ri+r+& d&)+*or.R+v+nind *& -od+*u* r+*& ion&*, (roi+)&r+& un+i 8&1+ d+ d&)+ (r+'u(un+ d+finir+&
+n)i)/ i*or i & *+0/)uri*or din)r+ &+')+&.A')f+*, +n)i)/ i*+vor fi d+fini)+ 'u8 for-& unor )&8*ouri
8idi-+n'ion&*+ d+nu-i)+ )&8+*+ '&u r+*& ii. Con+()+*+ u)i*i1&)+ 'un) ur-/)o&r+*+H
omeniuld+'+-n+&1/ &n'&-8*u* v&*ori*or + (o) fi u)i*i1&)+ ta$ela '&u relatia+')+ un 'u8&n'&-8*u &* (rodu'u*ui &r)+1i&n din)r+ -&i -u*)+ do-+nii,
&r&)+ri1&) (rin)ro d+nu-ir+ atri$utuli*u')r+&1/ o o*o&n/ din)ro )&8+*/ &r+ &r+ o d+nu-ir+ i &r+ v& *u& v&*ori din)run
do-+niu. Un+*+ &)ri8u)+ (o) &v+& ro*u* d+ 6+i+
tuplul5nr+0i')r&r+r+&*i1&r+in')&n /G +')+ *ini& din)ro )&8+*& c!eiar+(r+1in)/ un &)ri8u) ori un &n'&-8*u d+ &)ri8u)+ u ro*u* d+ & id+n)ifi& un )u(*u din)r
o )&8+*/
D+finir+& *+0/)urii din)r+ +n)i)/ i '+ f&+ *& niv+* *o0i (rin on')ruir+& d+ &'oi+ri u &:u)oru*
unor &)ri8u)+ d+ *+0/)ur/ 6+i +3)+rn+G.An'&-8*u* )&8+*+*or i &* *+0/)uri*or din)r+ &+')+& on')i)ui+ '6+-& 8&1+i d+ d&)+.Un &'(+) i-(or)&n) 5n r+&*i1&r+& un+i 8&1+ d+ d&)+ +')+ r+(r+1+n)&) d+ 5n*/)ur&r+& &no-&*ii*or.
C+& -&i u)i*i1&)/ )+6ni/ (+n)ru r+1o*v&r+& &+')+i 'i)u& ii +')+ )+6ni& nor-&*i1/rii &r+
(r+'u(un+ & )o&)+ r+*& ii*+ '/ r+'(+)+ +*+ ini for-+ nor-&*+.
3.2.2 "roiectarea practic a $azei e ate
Proi+)&r+& un+i 8&1+ d+ d&)+ r+(r+1in)/ (roi+)&r+& '6+-+i on+()u&*+ *o0i+G i fi1i+
& &+')+i& (+n)ru & r/'(und+ +rin +*or un+i& '&u -&i -u*)+ &(*i& ii, '&u -&i +3&) (+n)ru &
r/'(und+ +rin +*or u)i*i1&)ori*or &+')+i&. Proi+)&r+& un+i 8&1+ d+ d&)+ +')+ divi1&)/ &')f+*H
')udiu* +rin +*or &(*i& i+i, (roi+)&r+& on+()u&*/, &*+0+r+& unui S!BD, (roi+)&r+& *o0i/ i
(roi+)&r+& fi1i/ & 8&1+i d+ d&)+.
n (ri-u* rnd )r+8ui+ &n&*i1&)+ +rin +*+ &(*i& i+i i &*+ 'i)u& ii*or + ur-+&1/ & fi
r+1o*v&)+ d+ /)r+ &+&')&. D+o&r++ &(*i& i& ur-+&1/ & fi u)i*i1&)/ d+ /)r+ -&i -u*)+ (+r'o&n+
5n -od onur+n i&* +')+ n+voi+ & &+&')& '/ ur-/r+&'/ o &r6i)+)ur/ *i+n)'+rv+r, d+i i 8&1&
d+ d&)+ u)i*i1&)/ )r+8ui+ '& fi+ &d&()&8i*/ &+')+i 'i)u& ii. P*u'uri (+n)ru fo*o'ir+& &+')+i )i(o*o0ii
'un) r+(r+1+n)&)+ d+ -/ri-+& '+uri)/ ii d&)+*or &r+ 'un) 'i)u&)+ (+ o -& in/'+rv+r i (o) fi
&+'&)+ do&r 5n &nu-i)+ ondi ii d+ /)r+ u)i*i1&)oriG, d+ +*i8+r&r+& -& inii*i+n) d+ (ro+'+*+
d+ &*u* d&r i d+ f&()u* / &(*i& i& i i-(*ii) 8&1& d+ d&)+ (o) fi &+'&)+ d+ (+ ori+ &*u*&)or
din r+ +&u& *o&*/ & o-(&ni+i 5n)ru) vor8i- d+'(r+ o &(*i& i+ 8&1&)/ (+ 7+8G.
1'
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
21/52
Proi+)u* on+()u&* '+ r+&*i1+&1/ ind+(+nd+n) d+ Si')+-u* d+ !+')iun+ & B&1+*or d+ D&)+ &*+', i
'+ r+(r+1in)/ 5n 0+n+r&* (rin -od+*u* En)i)&)+ A'oi+r+ =ntity / 4elationshipG &r+ '+
onr+)i1+&1/ 5n)ro di&0r&-/ En)i)&)+A'oi+r+.n (roi+)&r+& on+()u&*/ & 8&1+i d+ d&)+ vor fi ur-/ri i ur-/)orii (& iH
D+)+r-in&r+& 'o(u*ui 8&1+i d+ d&)+. B&1& d+ d&)+ n++'&r/ &(*i& i+i d+ &d-ini')r&r+ &
&)ivi)/ ii *o0i')i+ (/')r+&1/ infor-& ii d+'(r+ -& ini*+, of+rii i ur'+*+ fir-+i d+
)r&n'(or)uri 5n 'o(u* &*u*/rii d+ r+1u*)&)+ +ono-i+ n++'&r+ &d-ini')r/rii &)ivi)/ ii. -(/r ir+& infor-& ii*or 5n )&8+*+. S+ r+&*i1+&1/ (rin 0/'ir+& +*or -&i i-(or)&n)+ +n)i)/ i
'&u 'u8i+)+ din d+'ri+r+& (ro8*+-+i r+&*+. O8'+rv/- &')f+* / (rini(&*+*+ +n)i)/ i 'un) H
-& in/, of+r, ur'/, d+f+ iun+, &*i-+n)&r+. Tr&n'for-&r+& +*+-+n)+*or d+ infor-& ii 5n o*o&n+. o- d+id+ + infor-& ii vor fi
')o&)+ 5n fi+&r+ )&8+*/. Fi+&r+ +*+-+n) d+vin+ un -( &fi &) 'u8 for-& un+i o*o&n+ &
)&8+*u*ui. S(+ifi&r+& 6+i*or (ri-&r+. S+ &*+0+ o*o&n& '&u o*o&n+*+ &r+ vor id+n)ifi& 5n -od
uni fi+&r+ 5nr+0i')r&r+ din )&8+*/.
n fi0uri*+ %.2 %. '+ o8'+rv/ f&()u* / &)ri8u)+*+ fi+/r+i +n)i)/ i &u fo') )r&n'for-&)+ 5n
o*o&n+ &*+ )&8+*+*or r+'(+)iv+. n (*u' fi+&r+ )&8+*/ &r+ o 6+i+ (ri-&r/ &* /r+i ro* +')+
&+*& d+ & id+n)ifi& fi+&r+ )u(*u.
igura 4.B a>ela Do/eri
igura 4.' a>ela %a,ini
2(
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
22/52
igura 4.13 a>ela Curse
igura 4.11 a>ela +e/eciuni
igura 4.1* a>ela 6limentri
igura 4.14 a>ela 2tilizatori
Confi0ur&r+& r+*& ii*or din)r+ )&8+*+ . Tr+8ui+ d+i' -odu* 5n &r+ '+ &'oi&1/ d&)+*+ din)r
un )&8+* u d&)+*+ din &*)+ )&8+*+. S+ o8'+rv/ din fi0uri*+ %.2 %. / & fo') inu) on) d+
&+') *uru d+o&r++ un+*+ )&8+*+ on in i 6+i +3)+rn+ &r+ 5n &*)+ )&8+*+ &u ro*u* d+ 6+i
(ri-&r+ r+&*i1ndu'+ on+3iun+& din)r+ +n)i)/ i. T&8+*& U)i*i1&)ori nu +')+ *+0&)/ d+ nii
21
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
23/52
o &*)/ )&8+*/ d+o&r++ +')+ u)i*i1&)/ (+n)ru &d-ini')r&r+& &(*i& i+i i nu (+n)ru
fun ion&*i)&)+& &)ivi)/ ii d+ )r&n'(or)uri.
R+(r+1+n)&r+& )&8+*+*or 5-(r+un/ u r+*& ii*+ din)r+ +*+ i*u')r+&1/ '6+-& on+()u&*/ & 8&1+i d+
d&)+ '&u di&0r&-& En)i)&)+ A'oi+r+, (r+1+n)&)/ 5n fi0ur& %.$#.
igura 4.15 Sc7ema conceptual a >azei de date
n fi0ur& d+ -&i 'u' o8'+rv/- +n)i)/ i*+ i *+0/)uri*+ din)r+ +*+. A')f+*, (u)+- d+'ri+ 8&1& d+
d&)+H
un of+r (o&)+ +3+u)& un& '&u -&i -u*)+ ur'+, un of+r (o&)+ 5nr+0i')r& un& '&u -&i
-u*)+ &*i-+n)/ri '&u un of+r (o&)+ 5nr+0i')r& un& '&u -&i -u*)+ d+f+ iuni *& -& in& (+
&r+ o ondu+. -& in/ (o&)+ fi fo*o'i)/ 5n un& '&u -&i -u*)+ ur'+, o -& in/ (o&)+ fi &*i-+n)&)/ o d&)/
'&u d+ -&i -u*)+ ori i o -& in/ '+ (o&)+ d+f+)& d+ un& '&u -&i -u*)+ ori.
L+0&r+& )&8+*+*or +')+ r+&*i1&)/ (rin 6+i +3)+rn+. A')f+*, id\'of+r +')+ 6+i+ (ri-&r/ 5n )&8+*&
'of+ri i 6+i+ +3)+rn/ 5n )&8+*+*+ ur'+, d+f+ iuni i &*i-+n)/ri. A++& i 'i)u& i+ '+ o8'+rv/ i 5n
&1u* &)ri8u)u*ui nr\-&'in&, 6+i& (ri-&r/ din )&8+*& -&'ini. S6+-& on+()u&*/ i*u')r+&1/f&()u* / &v+- un -od+* d+ 8&1/ d+ d&)+ r+*& ion&*, d+o&r++ 'un) (r+1+n)+ do&r *+0/)uri d+ )i(u*
22
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
24/52
unu**&-&i -u* i. n &1u* 5n &r+ &r fi +3i')&) *+0/)uri d+ )i(u* -&i -u* i*&-&i -u* i, &)uni
&+')+& &r fi )r+8ui) '/ fi+ &du'+ *& for-& unu**&-&i -u* i (+n)ru & fi o 8&1/ d+ d&)+ r+*& ion&*/. n &1u* no')ru '6+-& on+()u&*/ oinid+ u +& *o0i/ d+o&r++, & & u- &- +3(*i&)
-&i 'u' nu +3i')/ r+*& ii -&i -u* i*&-&i -u* iK &r+ '/ n++'i)+ )r&n'for-&r+. S6+-& *o0i/
+')+ i-(*+-+n)&)/ in S!BDu* &*+' M
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
25/52
in)+rf+ +i +')+ &+*& d+ & f&+ in)+r& iun+& u)i*i1&)oru*ui ) d+ 'i-(*/ i +fii+n)/ (o'i8i* (+n)ru
& &+')& '& i &)in0/ o8i+)iv+*+. A+') )i( d+ 0ndir+ & in)+rf+ +i +')+ d+ +*+ -&i -u*)+ ori
d+nu-i)H user/centered design i &nu-+ &'(+) +n)r&) (+ u)i*i1&)or i du(/ u- '(un+ d+nu-ir+&
'+ r+f+r/ *& f&()u* / &)uni nd '+ (roi+)+&1/ o in)+rf& /, (+r'o&n& &r+ fo*o'+ )+ &(*i& i&
)r+8ui+ '/ fi+ +* -&i i-(or)&n) +*+-+n) *u&) 5n on'id+r&r+. Pro+'u* d+ d+1vo*)&r+ & in)+rf+ +i)r+8ui+ '/ 8&*&n'+1+ fun ion&*i)&)+& )+6ni/ i +*+-+n)+*+ vi1u&*+ (+n)ru & r+& un 'i')+- &r+
+')+ nu do&r o(+r& ion&* i i u)i*i1&8i* i &d&()&8i* *& '6i-8/ri*+ d+ &r+ &r+ n+voi+ u)i*i1&)oru*. A'(+)u* r+f+ri)or *& (r+1+n)&r+& infor-& i+i +')+ d+'ri' 5n &r)io*u* $" &* ')&nd&rdu*ui ISO "2$
r+f+ri)or *& or0&ni1&r+& infor-& i+i &r&n:&r+, &*ini+r+, 0ru(&r+, +)i6+)&r+, *o& i+G, (rin &()+
&)ri8u)+H
*&ri)&)+H on inu)u* infor-& i+i +')+ r+d&) r&(id i +3&) di'ri-in&8i*i)&)+H infor-& ii*+ r+d&)+ (o) fi di')in'+ +fii+n)
'i-(*i)&)+H u)i*i1&)orii nu 'un) 'u(r&5n/r& i u infor-& ii inu)i*+ on'i')+n /H un &'(+) uni, onfor- u & )+( /ri*+ u)i*i1&)ori*or d+)+)&8i*i)&)+H &)+n i& u)i*i1&)oru*ui +')+ dir+ ion&)/ /)r+ infor-& i& n++'&r/ *i1i8i*i)&)+H infor-& i& +')+ u or d+ i)i) 5n +*+0+r+H infor-& i& +')+ u or d+ 5n +*+', n+&-8i0u/ i u or r+uno'u)/
A'(+)u* &(*i& i+i +')+ unu* *&'i (+n)ru o &(*i& i+ 7+8, d&r nu nu-&i, i +')+ r+(r+1+n)&) d+
5-(/r ir+& f+r+')r+i 8ro7'+ru*ui 5n % (&r i u fun ion&*i)/ i dif+ri)+, u- +')+ (r+1+n)&) 5n fi0ur&
%.$$.
igura 4.1= 6spectul general al aplicaiei
S+ o8'+rv/ / f+r+&')r& 8ro7'+ru*ui +')+ 5-(/r i)/ 5n % 1on+H
&n)+)u* on in+ 'i0*& o-(&ni+i i &*)+ infor-& ii (r+u- nu-+*+ u)i*i1&)oru*ui i or& -+niu* on in+ o( iuni*+ d+ n&vi0&r+ /)r+ -odu*+*+ &(*i& i+i 1on& d+ *uru r+(r+1in)/ 1on& (ro(riu1i'/ 5n &r+ vor fi &fi &)+ for-u*&r+*+, r&(o&r)+*+ i
+*+*&*)+ +*+-+n)+ vi1u&*+ &*+ fi+/rui -odu* &* &(*i& i+i
2)
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
26/52
4. "rezentarea aplica iei privin logistica companiei
4.1 6mplementarea aplica iei
P+n)ru d+1vo*)&r+& &(*i& i+i &- u)i*i1&) )+6no*o0ii*+ (r+1+n)&)+ 5n &(i)o*u* " &* ur+n)+i
*ur/ri. A')f+*, &- fo*o'i) & i -+diu d+ *uru E*i('+ uno v+r'iun+& 2."G. S+rv+ru* 7+8 u)i*i1&)+')+ A(&6+ &r+ on in+ -odu*+*+ d+ M
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
27/52
igura 5.1( 6r7itectura %odel 8 9ie: - Controller
Din (un)u* -+u d+ v+d+r+, u)i*i1&r+& un+i &r6i)+)uri d+ )i(u* MC, +')+ fo&r)+ u)i*/d+o&r++ i-(un+ o &nu-i)/ ri0uro1i)&)+ 5n +*&8or&r+& odu*ui 'ur'/, &r+ 5n &+') -od +')+ -&i
or0&ni1&) i -&i u or d+ ur-/ri) i d+(&n&). n (*u', fo&r)+ -u*)+ fun ii i -+)od+ (o) fi u)i*i1&)+
5n -&i -u*)+ -odu*+ ++& + du+ *& o (ro0r&-&r+ +fii+n)/.A(*i& i& u(rind+ " fun ion&*i)/ i o&r+u- dif+ri)+. Pri-& '+ r+f+r/ *& -&ni(u*&r+&
d&)+*or d+'+-n&)+ d+ +n)i)/ i*+ 8&1+i d+ d&)+, 5n )i-( + & dou& (&r)+ '+ r+f+r/ *& (o'i8i*i)&)+&
o8 in+rii d+ 0r&fi+ i r&(o&r)+. A+&')/ '+(&r&r+ +')+ 'u0+r&)/ 6i&r d+ -+niu* &(*i& i+i. n fi0ur& 2.", &r+ (r+1in)/ -+niu* &(*i& i+i, '+ o8'+rv/ f&()u* / 8u)o&n+*+ of+ri, M& ini,
Cur'+, A*i-+n)/ri i D+f+ iuni r+(r+1in)/ +n)i)/ i+ ')udi&)+ '&u )&8+*+*+ din 8&1& d+ d&)+. A')f+*,
fi+&r+ '+ iun+ &+'&)/ (rin &+')+ 8u)o&n+ v& r+&*i1& o(+r& ii d+ -&ni(u*&r+ & d&)+*or din
)&8+*& r+'(+)iv/ 5n (rini(&*, d&r i din )&8+*+*+ &di&+n)+ 5n &1u* 5n &r+ &+')+& 'un) *+0&)+
5n)r+ +*+. U*)i-& o( iun+ (+r-i)+ (r+1+n)&r+& unor 0r&fi+ r+*+v&n)+ (+n)ru &)ivi)&)+& d+
)r&n'(or)uri.
igura 5.1@ %eniul aplicaiei
2%
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
28/52
4.1.1 6mplementarea $azei e ate i a func ionalit ii acesteia
I-(*+-+n)&r+& 8&1+i d+ d&)+ +')+ r+&*i1&)/ (rin in)+r-+diu* *i-8&:u*ui d+ d+'ri+r+ &
d&)+*or LDDG (+n)ru r+&r+& )&8+*+*or, i&r &(oi (rin *i-8&:u* d+ -&ni(u*&r+ & d&)+*or LMDG
(+n)ru (o(u*&r+&, r+0/'ir+& i &)u&*i1&r+& d&)+*or.
Cr+&r+& 8&1+i d+ d&)+ & fo') r+&*i1&)/ u)i*i1nd &(*i& i& M
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
29/52
/t1is23d423set(5arsta5,/arsta&/t1is23d423set(5data_anga)are5,/data_anga)are&/t1is23d423set(5salari5,/salari&/t1is23d423insert(5soferi5&
6
n *i-8&:u* S;L, odu* d+ -&i 'u' +')+ +6iv&*+n) u H
IN7ERT INTO 7O8ERI (n!e, 'ren!e, cn', arsta, data_anga)are, salari& "ALUE7 (/n!e,/'ren!e, /cn', /arsta, /data_anga)are, /salari&
fun i+ (+n)ru +di)&r+& unui )u(*u din )&8+*& 'of+riKH
function edit_sofer(/id, /n!e, /'ren!e, /cn', /arsta, /data_anga)are, /salari&0
/t1is23d42391ere(5id5,/id&/t1is23d423set(5n!e5,/n!e&/t1is23d423set(5'ren!e5,/'ren!e&/t1is23d423set(5cn'5,/cn'&/t1is23d423set(5arsta5,/arsta&/t1is23d423set(5data_anga)are5,/data_anga)are&
/t1is23d423set(5salari5,/salari&/t1is23d423'date(5soferi5&
6
Limbaj SQL: U+*ATE soferi 7ET n!e : /n!e, 'ren!e : /'ren!e, cn' : /cn', data_anga)are :
/data_anga)are, salari : /salari, telefon : /telefon ;#ERE id: /id
fun i+ (+n)ru ')+r0+r+& un+i 5nr+0i')r/ri din )&8+*& 'of+riKH
fnction delete_sofer(/id&0
/t1is23d42391ere(5id5,/id&/t1is23d423delete(5soferi5&
6Limbaj SQL< *ELETE 8ROM soferi ;#ERE id:/id
fun i+ (+n)ru r+0/'ir+& d&)+*or din )&8+*& 'of+riKH
fnction get_soferi(&0
/retrn_arra= : arra=(&/t1is23d423select(5>5&23fro!(5soferi5&/res : /t1is23d423get(&foreac1(/res23reslt_arra=(& as /ro9&0/retrn_arra=?@ : /ro9
6retrn /retrn_arra=6
Limbaj SQL< 7ELECT > 8ROM soferi OR*ER B n!e, 'ren!e
4.1.2 6mplementarea interfe ei i a func ionalit ii acesteia
In)+rf& & +')+ i-(*+-+n)&)/ u)i*i1nd vi1iuni*+ i uni)/ i*+ d+ on)ro*.Din (r+1+n)&r+& &r6i)+)urii Mod+* i+7 Con)ro**+r, )i- / vi1iuni*+ '+ ou(/ u (r+1+n)&r+& infor-& ii*or /)r+ u)i*i1&)or, d+i u (&r)+& vi1u&*/ & in)+rf+ +i, 5n )i-( + uni)&)+& d+ on)ro* '+ ou(/ u
fun ion&*i)&)+& &+')+i&, 5n)ru) (r+i& +r+ri*+ 0+n+r&)+ d+ & iuni*+ u)i*i1&)oru*ui i *+ (ro+'+&1/, of+rind un r/'(un' + indi/ o nou/ dir+ i+ d+ n&vi0&r+ 5n &dru* &(*i& i+i '&u fi*)r+&1/ o (&r)+ din infor-& ii*+ + )r+8ui+ r+d&)+. o- of+ri & +3+-(*u *&'& Sof+riK, *&'/ +
2*
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
30/52
i-(*+-+n)+&1/ *o0i& un+i uni)/ i d+ on)ro* & &8*onu*ui Mod+*i+7Con)ro**+r. A+&')/ *&'/ r+&*i1+&1/ *i')&r+& of+ri*or fir-+i i o(+r& ii*+ d+ &d/u0&r+, +di)&r+ '&u )+r0+r+ & unui of+r 5n fun i+ d+ &nu-i i (&r&-+)ri )ri-i i 5n ur-& in)+r& iuni*or din)r+ u)i*i1&)or i &(*i& i+.
fun i+ (+n)ru *i')&r+& of+ri*or. Li')& d+ 'of+ri +')+ r+0/'i)/ 5n 8&1& d+ d&)+ (rin &(+*&r+&
fun i+i 0+)\'of+riK din -od+*u* Sof+riK, i&r &(oi +')+ )ri-i'/ /)r+ vi1iun+ 'u8 for-/unui o8i+) :'on -avaScript ob-ect notationG fiind &fi &)/.
'4lic fnction lista(&0
/t1is23load23!odel(5!odel_crse5,5crse5&/t1is23load23!odel(5!odel_soferi5,5soferi5&/crse : /t1is23crse23get_crse(&/reslt : ne9 stdClass(&/i:foreac1(/crse as /ro9&0
/sofer : /t1is23soferi23get_sofer(/ro9?5id_sofer5@&
/ro9?5sofer5@ : 55if(cont(/sofer&3&0/ro9?5sofer5@ : /sofer?5n!e5@. ./sofer?5'ren!e5@6/reslt23ro9s?/i@?5id5@:/ro9?5id5@/reslt23ro9s?/i@?5cell5@: arra=(/iD, /ro9?5'lecare5@, /ro9?5destinatie5@,
/ro9?5id_sofer5@,/ro9?5sofer5@,/ro9?5nr_!asina5@, /ro9?5distanta5@,/ro9?5data5@&/i
6ec1o )son_encode(/reslt&
6
fun i+ (+n)ru &d/u0&r+&, +di)&r+& '&u )+r0+r+& unui of+rH '4lic fnction edit(&0
/o'er : /t1is23in't23get_'ost(5o'er5&/id : /t1is23in't23get_'ost(5id5&/'lecare : /t1is23in't23get_'ost(5'lecare5&/destinatie : /t1is23in't23get_'ost(5destinatie5&/id_sofer : /t1is23in't23get_'ost(5id_sofer5&/!asina : /t1is23in't23get_'ost(5!asina5&/distanta : /t1is23in't23get_'ost(5distanta5&/data : /t1is23in't23get_'ost(5data5&/t1is23load23!odel(5!odel_crse5,5crse5&if(/o'er :: 5add5& /t1is23crse23add_crsa(/'lecare, /destinatie, /id_sofer, /!asina,
/distanta,/data&if(/o'er :: 5edit5& /t1is23crse23edit_crsa(/id,/'lecare, /destinatie, /id_sofer,/!asina,
/distanta,/data&if(/o'er :: 5del5& /t1is23crse23delete_crsa(/id&
6
Din fun ii*+ (r+1+n)&)+ -&i 'u', '+ o8'+rv/ *&r ro*u* uni)/ ii d+ on)ro*, i &nu-+ &+*& d+ & diri:& f*u3u* &(*i& i+i, 5n)r+ (&0ini*+ + )r+8ui+' &fi &)+ i +*+-+n)+*+ d+ *o0i/ + &'i0ur/ fun ion&*i)&)+& &(*i& i+i. To) *& (&r)+& d+ fun ion&*i)&)+ & &(*i& i+i '+ &d&u0/ &+'u* *& &(*i& i+ (+ 8&1& unui nu-+ d+ u)i*i1&)or i & un+i (&ro*+, &r+ id+n)ifi/ fi+&r+ u)i*i1&)or + *ur+&1/ u &(*i& i&. P+n)ru i-(*+-+n)&r+& &+')ui -odu*, &u fo') r+&)+ o vi1iun+ Lo0inK i o uni)&)+ d+ on)ro* u &+*& i nu-+. A+') -odu*, i)+ )+ d&)+*+ d+ &u)+n)ifi&r+ i v+rifi/ d&/ 'un) 0/'i)+ 5n 8&1& d+ d&)+. n &1 &fir-&)iv, +')+ (+r-i' &+'u* u)i*i1&)oru*ui, 5n &1 on)r&r,
2'
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
31/52
&+'u* +')+ in)+r1i'. Con)ro*&r+& &)ivi)/ ii d+ &u)+n)ifi&r+ '+ d+'f/ o&r/ du(/ u- ur-+&1/, fiind 0+')ion&)/ d+ *&'& Lo0inH
class Login etends CI_Controller0
'4lic fnction inde(&0
/t1is23load23ie9(5loginFlogin5&6
'4lic fnction c1ecG(/serna!e,/'ass9ord&0
/t1is23load23li4rar=(5session5&/t1is23load23!odel(5!odel_sers5,5sers5&/c1ecG : /t1is23sers23c1ecG_ser(/serna!e,/'ass9ord&if(/c1ecG 3 &0
ec1o D/t1is23session23set_serdata(arra=(5serna!e5:3/serna!e&&
6else ec1o
6 6
U)i*i1&)orii (o) fi &d-ini')r& i din in)+rioru* &(*i& i+i. S+ of+r/ (o'i8i*i)&)+& d+ & )+r0+ un u)i*i1&)or '&u d+ & &d/u0& &*)u*. I-(*+-+n)&r+& -odu*u*ui d+ &u)+n)ifi&r+ +')+ (r+1+n)&)/ 5nAn+3& $.
n ++& + (riv+ )+ (&r)+& vi1u&*/ & &(*i& i+i, un ro* fo&r)+ i-(or)&n) *& &vu) *i-8&:u* :;u+r< + of+r/ o -u*)i)udin+ d+ +3)+n'ii i )+-+ (+n)ru d+1vo*)&r+& un+i in)+rf+ + 0r&fi+ &)r&)iv+.
A')f+*, (+n)ru *i')&r+& d&)+*or r+0/'i)+ 5n )&8+*+*+ 8&1+i d+ d&)+, & fo') fo*o'i)/ +3)+n'i&pluginG :?!rid, + i-(*+-+n)+&1/ un )&8+* i of+r/ f&i*i)/ i d+ 'or)&r+, +di)&r+ i r+5n/r&r+ &
d&)+*or. A'(+)u* unui )&8+* r+&) u :;u+r< i :?!rid +')+ (r+1+n)&) 5n fi0ur& 2.%H
igura 5.1B a>el EFArid
R+'(+)ivu* )&8+* +')+ on')rui) 5n)ro vi1iun+, &* /r+i od +')+ 'ri' 5n 9TML, :&v&Sri() i:;u+r< i &* /r+i ro* +')+ &+*& d+ & (r+1+n)& d&)+*+ 5n)ro -&ni+r/ u or d+ i)i) i d+ 5n +*+' i d+ & r+&*i1& +r+ri*+ /)r+ '+rv+r. n on)inu&r+, vo- v+d+& u- &r&)/ o &')f+* d+ vi1iun+H
Hscri't3/(function(&0
)er=(Jsoferi_list&.)Krid(0rl
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
32/52
colModel
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
33/52
igura 5.1' 6utenti"care aplicaiei logistic
Du(/ &u)+n)ifi&r+& 5n &(*i& i+, u)i*i1&)oru* &r+ &+' *& +*+ )r+i 1on+ d+ *uru + vor fi(r+1+n)&)+ 5n ++& + ur-+&1/. I-(*+-+n)&r+& (&0inii (rini(&*+ +')+ (r+1+n)&)/ 5n An+3& %.n (ri-u* rnd, 1on& din (&r)+& d+ 'u' & +r&nu*ui on in+ 'i0*& o-(&ni+i, nu-+*+ &(*i& i+i, i&r
5n (&r)+& dr+&()/, or&, nu-+*+ u)i*i1&)oru*ui on+)&), un 8u)on d+ &d-ini')r&r+ & u)i*i1&)ori*or iun 8u)on d+ (/r/'ir+ & &(*i& i+i, du(/ u- +')+ (r+1+n)&) 5n fi0ur& 2.=H
igura 5.*3 eaderul aplicaiei
Ad-ini')r&r+& u)i*i1&)ori*or '+ f&+ 5n)ro f+r+&')r/ d+ di&*o0, -od&*/, &r+ nu (+r-i)+
in)+r& iun+& u r+')u* &(*i& i+i (n/ nd nu +')+ 5n6i'/. A')f+*, '+ (o&)+ on'u*)& *i')&
u)i*i1&)ori*or on+)& i, '+ (o) )+r0+ u)i*i1&)ori 8u)onu* D+*+)+G '&u (o) fi &d/u0& i u)i*i1&)ori noi
8u)onu* Ad&u0/ u)i*i1&)orG.
igura 5.*1 Lista utilizatorilor autorizai
5n cazu n care se dore6te adugarea unui nou utiizator7 va # desc8is o nou
ereastr7 6i aceasta moda7 dup cum urmeaz932
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
34/52
igura 5.** 6dugarea unui nou utilizator
:evenim a partea apicaiei ce ine de domeniu ogisticii 6i anume a meniu
situat n partea st;ng a ecranuui care conine urmtoaree opiuni9 Panou Centra7
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
35/52
igura 5.*5 Lista ,o/erilor
O(+r& ii*+ d+ -&ni(u*&r+ & )&8*+i of+ri din 8&1& d+ d&)+ (o) fi +f+)u&)+ din &+&')/
(&0in/, (rin in)+r-+diu* 8u)o&n+*or 'i)u&)+ &)) d+&'u(r& )&8+*u*ui ) 'i 'u8 &+')&. O8'+rv/-
+3i')+n & & 2 8u)o&n+ d+ &d/u0&r+, +di)&r+ )+r0+r+ i &)u&*i1&r+ & *i')+i. For-u*&r+*+ d+ &d/u0&r+
i +di)&r+ & of+ri*or 'un) (r+1+n)&)+ 5n fi0uri*+ ur-/)o&r+H
igura 5.*= ormular adugare ,o/er
3)
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
36/52
igura 5.*( ormular editare ,o/er
A(/'&r+& 8u)onu*ui d+ )+r0+r+ & un+i 5nr+0i')r/ri v& du+ *& &(&ri i& un+i &'+)+ d+ -+'&: &r+ +r+ u)i*i1&)oru*ui '/ onfir-+ din nou in)+n i& d+ & )+r0+ 5nr+0i')r&r+&.
igura 5.*@ Dtergerea unui ,o/er din list
D+o&r++ un& din)r+ r+0u*i*+ d+ (r+1+n)&r+ & un+i &(*i& ii (r+i1+&1/ & &+&')& )r+8ui+ '/ &i8/
un &'(+) uni)&r, +*+*&*)+ '+ iuni vor &r/)& *& f+* & '+ iun+& of+ri, dif+rind do&r on inu)u*
&+')or&. A+') *uru '+ o8'+rv/ 5n fi0uri*+ + ur-+&1/H
3$
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
37/52
igura 5.*B lista de ma,ini
Listee de curse7 aimentri 6i deeciuni permit n pus #trarea dateor nuncie de o dat de nceput 6i una de s;r6it.
igura 5.*' Lista de curse
3%
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
38/52
igura 5.43 Lista de alimentri
igura 5.41 Lista de de/eciuni
U*)i-& o( iun+ & -+niu*ui (r+1in)/ o '+ri+ d+ 0r&fi+ + of+r/ infor-& ii r+*+v&n)+ d+'(r+ ')&r+&
&)ivi)/ ii d+ )r&n'(or)uri d+& *un0u* )i-(u*ui i (o) fi on'id+r&)+ 'u(or) (+n)ru d+i1ii*+
3&
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
39/52
vii)o&r+. Du(/ u- '+ o8'+rv/ 5n fi0ur& 2.$@, '+ (o&)+ &*+0+ o &)+0ori+ d+ 0r&fi, r+f+ri)o&r+ *&
of+ri, d+f+ iuni, (&ru* &u)o '&u furni1orii d+ o-8u')i8i*.
igura 5.4* Ara"ce
A')f+* , 5n fi0ur& 2.$ +')+ (r+1+n)&) nu-/ru* d+ ur'+ +f+)u&)+ i or+ +f+)iv *ur&)+ d+ /)r+ unof+r, 5n fi+&r+ din *uni*+ &nu*ui ur+n) (n/ *& +& (r+1+n)/.
igura 5.44 0umrul de curse e/ectuate de un ,o/er
Fi0ur& 2.$ (r+1in)/ +vo*u i& nu-/ru*ui d+ d+f+ iuni 5nr+0i')r&)+ d+ /)r+ -& ini*+ fir-+i d+& *un0u* )i-(u*ui. Ef+)und *iJ (+ o 8&r/ & 0r&fiu*ui, vor fi &fi &)+ -& ini*+ + &u &vu) n+voi+ d+ r+(&r& ii 5n *un& r+'(+)iv/, 5-(r+un/ u of+ru* &r+ & 5nr+0i')r&) d+f+ iun+& i d&)& in)r/rii 5n '+rvi+.
3*
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
40/52
igura 5.45 numrul de de/eciuni nregistrate
Fi0ur& 2."# i*u')r+&1/ (ro(or i& -/ri*or -& ini*or din (&ru* &u)o &* fir-+i, i&r *& '+*+)&r+& unui (rodu/)or d+ (+ 0r&fi vor fi &fi &)+ -& ini*+ or+'(un1/)o&r+ &+*ui (rodu/)or.
igura 5.4= Situaie parc auto
3'
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
41/52
5n cee din urm7 #gura ).217 prezint proporia urnizorior de com@usti@i de a careau ost eectuate aimentri.
igura 5.4( Proporia >enzinriilor de unde s-a alimentat
)(
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
42/52
Concluzii
n on*u1i+, (o) '(un+ / )+-& &*+&'/ & fo') un& in)+r+'&n)/ i &)r&)iv/ din (un) d+v+d+r+ +ono-i, d&r -&i &*+' din (un) d+ v+d+r+ infor-&)i. n ++& + (riv+ )+ do-+niu*+ono-i, )+-& & fo') in)+r+'&n)/ d+o&r++ & (r+'u(u' +r+)&r+& unui do-+niu din&-i +i-(*i/ o')uri fo&r)+ ridi&)+ i )r+8ui+ '/ fi+ o()i-i1&). Din (un) d+ v+d+r+ infor-&)i,&)r&)ivi)&)+& )+-+i '& -&nif+')&) (rin 0/'ir+& un+i 'o*u ii d+ &d-in')r&r+ & do-+niu*ui +ono-i')udi&).
C+r+)&r+& & (r+'u(u' o dou-+n)&r+ ri0uro&'/ 5n do-+niu* 8&1+*or d+ d&)+ i &*d+1vo*)/rii 7+8 i '& fin&*i1&) u r+&*i1&r+& un+i &(*i& ii 7+8 + u)i*i1+&1/ o 8&1/ d+ d&)+ i +')+ &(*i&8i*/ ori/r+i fir-+ din do-+niu* )r&n'(or)uri*or. A(*i& i& r+&)/ of+r/ (o'i8i*i)&)+&&d-ini')r/rii &+')+i &)ivi)/ i (rin in+r+& un+i +vid+n + & (+r'on&*u*ui i v+6iu*+*or i of+rir+& unor r&(o&r)+ &* /ror ro* +')+ &+*& d+ & &:u)& *& *u&r+& d+ d+i1ii.
So*u i& infor-&)i/ r+&*i1&)/ (o&)+ fi +3)in'/, i&r un& din)r+ (ri-+*+ id+i d+ +3)ind+r+ +')+i-(*+-+n)&r+& unui -odu* &r+ '/ (+r-i)/ *o&*i1&r+& &u)ov+6iu*+*or (+ 6&r)/ &)uni nd&+')+& 'un) 5n d+(*&'&r+ i un &*) -odu* &r+ '/ &*u*+1+ dru-uri*+ -ini-+ (+n)ru o()i-i1&r+&)r&n'(or)uri*or. Po) fi +3)in'+ i f&i*i)/ i*+ d+:& +3i')+n)+, (rin &d/u0&r+& unui nu-/r -&i -&r+ d+ 'i)u& ii d+ i+ ir+ 0r&fi+, r&(o&r)+G.
)1
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
43/52
7eferin e $i$liografice
9EI!L>=Q$ 9+'J+)), Ivi+ ^ !*&'Jo7'J< Bu'in+'' Lo0i')i' M&n&0+-+n) of
P62AFRDU#=
Q
Mo6&--&d R+1& AJ8&r< oJ&r, W&nniJ Fr+in, Lion+* Du(on) Sur
*_+vo*u)ion du on+() d+ *o0i')i?u+K, RIRL "###T9$>Q $ !+or0+ CNO9U##Q !r&n) Norri', &-+' 9ur*+< E8u'in+'' &nd ERPK, Univ+r'i)< of
C&*iforni&, "###VII#$Q 2 ViJi(+di& V6&) Wou S++ I' V6&) Wou !+)
6))(H+n.7iJi(+di&.or07iJiVWSIVW!RE#Q o6n R+'i0 :;u+r< CooJ8ooJK, O_R+i**< M+di&, "##O#=Q Mi6&+* of*+r T6+ D+fini)iv+ !uid+ )o M
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
44/52
Aigura 1.3 Auu inormaiona a activitii ogistice din cadru unei companii..........'Aigura 2.1 ,r8itectura /ode G Hie G Controer7 BIJI(2.......................................1%Aigura 3.1 Auu inormaiona ce st a @aza apicaiei...........................................1*Aigura 3.2 Componentee ar8itecturii unui sistem de @aze de date7 BL+H40('....1*Aigura 3.3 Aunciie unui !=4"7 BL+H40('............................................................ 1'Aigura 3.) Ka@ea
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
45/52
{$this->load->view(login!login)"
#
public function chec($userna%e&$password){
$this->load->librar'(session)"
$this->load->%odel(%odel_users&users)"$chec $this->users->chec_user($userna%e&$password)"if($chec > ){
$this->session->set_userdata(arra'(*userna%e*>$userna%e))"echo +"
#else echo "
# #
,ht%l>,head>,lin rel*t'lesheet* t'pe*text!css* href*htdocs!./uer'!css!the%es!ui-
lightness!./uer'-ui0%in0css* !>,script srchtdocs!./uer'!.s!./uer'-+01020%in0.s>,!script>,script t'pe*text!.avascript* srchtdocs!./uer'!.s!./uer'-ui-+03020custo%0%in0.s>,!script>,script>
$(function(){
$(*4btn_login*)0button()0clic(function(){if($(4login_userna%e)0val()5** 66 $(*4login_password*)0val()5 **){$0a.ax({
t'pe7post&url7login!chec!8$(4login_userna%e)0val()8!8$(*4login_password*)0val()&success7 function(data){if(data +) {window0location *%ain*"#else
{$(*4login_%essage*)0ht%l(*9u%ele de utili:ator sau!si parola suntincorecte*)"$(*4login_userna%e*)0val(**)"$(*4login_password*)0val(**)"
###)"#elsealert(*Co%pletati nu%ele de utili:ator si parola*)"#)"
$(*4login_dialog*)0dialog({%odal7true&width7;&position7 *center*&title7 *
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
46/52
,!head>
,bod'>
,div idlogin_dialog>
,div idlogin_%essage>,!div>,table>,tr>,td>9u%e utili:ator ,!td>,td>,input t'petext idlogin_userna%e na%e*userna%e*
st'lewidth72px" !>,!td>,!tr>,tr>,td>=arola ,!td>,td>,input t'pepassword idlogin_password na%e*password*
st'lewidth72px" !>,!td>,!tr>,!table>,button idbtn_login>
,!div>,!bod'>,!ht%l>
nexa 2.I-(*+-+n)&r+& -odu*u*ui d+ &d-ini')r&r+ & of+ri*orH!! unitate de control class oferi extends CI_Controller{
public function lista() {
$this->load->%odel(%odel_soferi&soferi)"$soferi $this->soferi->get_soferi()"
$result new stdClass()"$i"foreach($soferi as $row){
$data_ang explode(-&$rowdata_anga.are?)"$an_anga.are $data_ang?"$an_curent date(@)"$rowvechi%e? $an_curent - $an_anga.are"$result->rows$i?id?$rowid?"$result->rows$i?cell?arra'($i8+&$rownu%e?&
$rowprenu%e?&$rowcnp?& $rowvarsta?&$rowdata_anga.are?&$rowsalariu?&$rowvechi%e?)"
$i88"
#echo json_encode($result)"
#
public function edit() { $oper $this->input->get_post(oper)" $id $this->input->get_post(id)" $nu%e $this->input->get_post(nu%e)" $prenu%e $this->input->get_post(prenu%e)" $cnp $this->input->get_post(cnp)" $varsta $this->input->get_post(varsta)" $data_anga.are $this->input->get_post(data_anga.are)"
$salariu $this->input->get_post(salariu)" $this->load->%odel(%odel_soferi&soferi)"
)$
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
47/52
if($oper add) $this->soferi->add_sofer($nu%e&$prenu%e&$cnp&$varsta&$data_anga.are&$salariu)" if($oper edit) $this->soferi->edit_sofer($id&$nu%e&$prenu%e&$cnp&$varsta&$data_anga.are&$salariu)" if($oper del) $this->soferi->delete_sofer($id)"
#
#!! viziune
,script>$(function(){.Auer'(*4soferi_list*)0./Brid({
url7,php echo $this->config->ite%(base_url)">!soferi!lista&editurl7,php echo $this->config->ite%(base_url)">!soferi!edit&datat'pe7 .son&col9a%es79r&9u%e& =renu%e& C9=& Darsta&Eata
load->database()"#
)%
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
48/52
function get_soferi(){
$return_arra' arra'()"$this->db->select(M)->fro%(soferi)"$res $this->db->get()"foreach($res->result_arra'() as $row){$return_arra'? $row"#return $return_arra'"
#
function get_sofer($id){
$this->db->select(M)->fro%(soferi)"$this->db->where(id&$id)"$res $this->db->get()"return $res->row_arra'()"
#
function add_sofer($nu%e&$prenu%e&$cnp&$varsta&$data_anga.are&$salariu){$this->db->set(nu%e&$nu%e)"$this->db->set(prenu%e&$prenu%e)"$this->db->set(cnp&$cnp)"$this->db->set(varsta&$varsta)"$this->db->set(data_anga.are&$data_anga.are)"$this->db->set(salariu&$salariu)"$this->db->insert(soferi)"
#
function delete_sofer($id){
$this->db->where(id&$id)"$this->db->delete(soferi)"#
function edit_sofer($id&$nu%e&$prenu%e&$cnp&$varsta&$data_anga.are&$salariu)
{$this->db->where(id&$id)"$this->db->set(nu%e&$nu%e)"$this->db->set(prenu%e&$prenu%e)"$this->db->set(cnp&$cnp)"$this->db->set(varsta&$varsta)"$this->db->set(data_anga.are&$data_anga.are)"
$this->db->set(salariu&$salariu)"$this->db->update(soferi)"
5E8 3. P&0in& (rini(&*/ & &(*i& i+i
,ht%l>,head>,lin rel*t'lesheet* t'pe*text!css* href*htdocs!st'le0css* !>,lin rel*t'lesheet* t'pe*text!css* href*htdocs!./uer'!css!the%es!ui-lightness!./uer'-ui0css* !>
)&
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
49/52
,lin rel*t'lesheet* t'pe*text!css* href*htdocs!./grid N!css!ui0./grid0css * !>,lin rel*st'lesheet* t'pe*text!css* href*htdocs!./=lot!./uer'0./plot0css*!>
,script srchtdocs!./uer'!.s!./uer'-+01020%in0.s>,!script>,script t'pe*text!.avascript* srchtdocs!./uer'!.s!./uer'-ui-+03020custo%0%in0.s>,!script>,script t'pe*text!.avascript* srchtdocs!./grid N!src!i+3n!grid0locale-en0.s>,!script>,script srchtdocs!./grid N!.s!./uer'0./Brid0%in0.s>,!script>,script srchtdocs!cloc0.s>,!script>,script t'pe*text!.avascript* src*htdocs!./=lot!./uer'0./plot0.s*>,!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0canvasextOenderer0%in0.s*>,!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0canvas,!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0date,!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0canvasextOenderer0%in0.s*>,!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0canvas,!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0categor',!script>
,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0barOenderer0%in0.s*>,!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0pieOenderer0%in0.s*>,!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0categor',!script>,script t'pe*text!.avascript*src*htdocs!./=lot!plugins!./plot0pointLabels0%in0.s*>,!script>
,script t'pe*text!.avascript* src*htdocs!./uer'0nu%eric0.s*>,!script>,script>functionprint_content(id_content& page_title& id_grid){
$(*4*8id_grid)0./Brid(setBridPeight&auto)"vardisp_setting* toolbar'es& locationno&directories'es&
%enubar'es&scrollbars'es& width+& height1& left+& top2G*"varcontent_value docu%ent0getle%entQ'Id(id_content)0innerPFL"vardocprintwindow0open(**&**&disp_setting)"docprint0docu%ent0open()"docprint0docu%ent0write(,ht%l>,head>,title>8page_title8,!title>)"docprint0docu%ent0write(,!head>,bod' onLoad*self0print()*>,center>)"
docprint0docu%ent0write(,!head>,bod'>,center>)"docprint0docu%ent0write(content_value)"docprint0docu%ent0write(,!center>,!bod'>,!ht%l>)"docprint0docu%ent0close()"docprint0focus()"
#
$(function(){
$(*4userna%e_show*)0ht%l(,php echo $userna%e">)"
$(*4btn_logout*)0button({icons7{pri%ar'7ui-icon-power##)0clic(function(){
window0location *login*"#)"
)*
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
50/52
$(*4ad%in*)0button({icons7{pri%ar'7ui-icon-person#&text7false#)0clic(function(){
$(4dialog_users)0load(,php $this->config->ite%(base_url)">users!users_list)"
$(4dialog_users)0dialog({width7G&%odal7 true&title7Lista utili:atori#)"
#)"$(*4print*)0button({icons7{pri%ar'7ui-icon-
print#&text7false#)0clic(function(){print_content(*%ain_center*)"
#)"
$(0%enu_button)0button()0clic(function(){
varcategorie $(this)0attr(categ)"$0a.ax({
t'pe7 post&url7 ,php $this->config->ite% (base_url)"
>%ain!8categorie&success7 function(data){
$(*4%ain_center*)0ht%l(data)"#
#)"#)"$(*4%ain_panel_button*)0trigger(clic)"
#),!script>,!head>,bod'>,div id%ain_top classui-widget-header>,div st'lewidth7+Gpx" displa'7inline-bloc" position7absolute" top7px"left7px"> ,i%g srchtdocs!logo0png st'lebacground-color7transparent"height7Rpx" !>
,!div>,div st'lewidth71px" displa'7inline-bloc" text-align7center">
,h2> ,!div>,div st'lewidth7Npx" displa'7inline-bloc" text-align7right" padding-right7Gpx" position7absolute" top7Gpx" right7Gpx">,5--ceas -->,div class*cloc*> ,div id*Eate*>,!div> ,ul> ,li id*hours*>,!li> ,li id*point*>7,!li> ,li id*%in*>,!li>
,li id*point*>7,!li> ,li id*sec*>,!li> ,!ul>,!div>,5-- ceas --> ,div iduserna%e_show st'lepadding-botto%7Npx" padding-top7+px">,!div> ,button idad%in st'le%argin-right7Gpx" height72px"width72px"> ,button idbtn_logout st'lewidth73px" height7Npx" font-si:e7+2px">Logout,!button>,!div>,!div>
,div id%ain_left >,button id%ain_panel_button class%enu_buttoncategpanou_central>=anou Central,!button>
)'
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
51/52
,button class%enu_button categsoferi> oferi,!button>,button class%enu_button categ%asini>Fa ini,!button>,button class%enu_button categcurse>Curse,!button>,button class%enu_button categali%entari>,button class%enu_button categdefectiuni>Eefec iuni,!button>,button class%enu_button categrapoarte>Brafice,!button>,!div>,div id%ain_center>,!div>,div iddialog_users>,!div>,!bod'>,!ht%l>
ANEXA 40 Ji ierul C al aplica ei
4%ain_top{
position7absolute"
left7px"top7px"height7+px"width7 ++px"border7+px solid silver"text-align7center"
#
4%ain_left {position7 absolute"left7px"top7 +px"width72px"
border7+px solid silver"%in-height7Gpx"color74JJJ"text-align7left"
#
4%ain_center {position7absolute"left72px"top7+px"width733px"%in-height7;3px"border7+px solid silver"
padding7 +px"#
button {font-si:e7+Gpx"padding7Npx"
#
0%enu_button{
width7+T"%argin7 px"padding71px"
#
0cloc { %argin7px" %argin-left7+px" padding-top7Gpx" padding-botto%7+px"#
$(
-
7/26/2019 Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica
52/52
4Eate {font-fa%il'7Qebas9eueOegular&