clear
set safe off
set talk off
set date to DMY
set clock on

use munc
index on nume tag inume
index on salariu tag isalariu
index on vechime tag ivechime

define window main from 0,0 to 24,79 title 'Muncitori'
define menu m
define window bx from 10,25 to 20,55 title 'Operatiuni' shadow

define popup muncitori from 1,0 to 5,16
define bar 1 of muncitori prompt 'Adaugare'
define bar 2 of muncitori prompt 'Modificare'
define bar 3 of muncitori prompt 'Stergere'
on sele bar 1 of muncitori do adauga
on sele bar 2 of muncitori do modifica
on sele bar 3 of muncitori do sterge

define popup afisari from 1,18 to 6,34
define bar 1 of afisari prompt 'Dupa functie D'
define bar 2 of afisari prompt 'Dupa salariu C'
define bar 3 of afisari prompt 'Individual'
define bar 4 of afisari prompt 'Salariul mediu'
on sele bar 1 of afisari do af_fd
on sele bar 2 of afisari do af_sc
on sele bar 3 of afisari do af_in
on sele bar 4 of afisari do af_med

define popup iesire from 1,36 to 4,52
define bar 1 of iesire prompt 'Din program'
define bar 2 of iesire prompt 'Din FoxPro'
on sele bar 1 of iesire do iesire_p
on sele bar 2 of iesire do iesire_f

define pad p1 of m prompt 'Muncitori      '
define pad p2 of m prompt 'Afisari        '
define pad p3 of m prompt 'Iesire         '
on sele pad p1 of m activate popup muncitori
on sele pad p2 of m activate popup afisari
on sele pad p3 of m activate popup iesire


s=.t.
do while s
activate window main
activate menu m
enddo

procedure iesire_p
s=.f.
deactivate menu m
deactivate window main
release windows
return

procedure iesire_f
quit
return

procedure adauga
hide popup muncitori
activate window bx
clear
accept 'Nume: ' to num
input 'Salariu: ' to sal
input 'Vechime: ' to vec
accept 'Calificat? (d/n) ' to cal
?'Datele ce vor fi introduse:'
?
?'Nume: '
??num
?'Salariu: '
??sal
?'Vechime: '
??vec
if cal = 'd'
?'Calificat.'
else
?'Necalificat.'
endif
?
accept 'Datele sunt corecte? (d/n) ' to ok
wait ''
deactivate window bx
deactivate popup muncitori
return

procedure modifica
hide popup muncitori
activate window bx
clear
accept 'Cautare dupa nume: ' to caut
locate for Nume = caut
if found()
?'Se modifica inregistrarea '
??recno()
??': '
gasit = 1
else
?'Nimic gasit.'
gasit = 0
endif

if gasit = 1
accept 'Nume: ' to nnum
input 'Salariu: ' to nsal
input 'Vechime: ' to nvec
accept 'Calificat? (d/n) ' to ncal
?'Datele ce vor fi suprascrise:'
?
?'Nume: '
??nnum
?'Salariu: '
??nsal
?'Vechime: '
??nvec
if ncal = 'd'
?'Calificat.'
else
?'Necalificat.'
endif
?
accept 'Datele sunt corecte? (d/n) ' to ok
if ok = 'd'
replace nume with nnum, salariu with nsal, vechime with nvec
if ncal = 'd'
replace calificat with .T.
else 
replace calificat with .F.
endif
endif

else
wait 'nimic.'
endif
deactivate window bx
deactivate popup muncitori
return