Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica

download Lucrare Licenta - Aplicatie web cu baze de date - gestionare logistica

of 52

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&