Àâòîð: Edelhauser E.
Èñòî÷íèê: http://www.emis.de/journals/AUA/acta8/Edelhauser1.pdf
Abstract. The aim of this paper is to design an information system for the personal record in the small/middle firm, but firms that consists of main submits geographical scattered. The application has been made using the triad APACHE-MySQL-PhP offered by Merlin Desktop in the open source vision. The end user needs in use a computer network and an Internet browser. From the analysis system point of view, the application tackles two areas of the human resources management: personnel record and organizational analysis
This model assumes that the independent achievement of the data
stocking system is giving the access system at the data. Using the client-server
model with three levels, has the following advantages:
* High flexibility and adaptive degree on changes
* Possibility of creating and using by the customers
The applications customer achieved on the work-station,
Installing the customer soft can often be organized from the server side and can consists only in installing the given operating system, gifted with webbrowser. All the needed software component parts are in the “open source” category.
1.1. The Apache Web Server – it is a web server (it’s name comes from “a patchy”- a little bit from www soft development), that uses the specification CGI (Common Gateway Interface) that is a communication specification between the server (such as program that generate dynamic documents) and the server itself. This server allow that the CGI program output to be inserted in HTML existent pages, thru directions written direct on the HTML page. 1.2. Data Base MySQL Server in the same time with the development of
1.2. Data Base MySQL Server in the same time with the development of the Internet Network and its employment in accessing the data-base, the applications in this area use exclusive the architecture customer-server. MySQL is a server application (for data base) able to carry out a great number of SQL commands. It is sharable and can be install on the PC working under different operating systems (Windows, Linux, Unix, etc.). To use the data base, I used WinMySQL Admin on Win9x, that is an instrument for administration MySQL.
1.3. The PhP language – Coding in HTML and the ones used in the C CGI scripts, can offer the required support for every Web site. In the mean time with the Internet extension appeared some specialized languages that can contribute to achieve additional functions on a Web page displaying by a browser or that allows to achieve easier the CGI scripts. Name PhP (meaning Personal Home Page) explains its functionality- writing the Web-pages. Being known even as “Hypertext Preprocessor”, it is a scripting language (directly performing), includes the HTML language and rolls up on the server. The language syntax is borrowed from C++, Java and Pearl and allows the writing of the Web pages in real time (fast and dynamic). PhP is a language devoted writing scripts that will be interpreting by the Web server.
The accessing mode of the received variables from the browser is: the data from a form/blank has been sent, the associated scripts receives a row of characters that consists of pairs of value name=value separated thru the character “&”. In a PhP script, the name of the different fields $name become automatic global variables in the script and have the values from the form/blank fields. This is valid no matter on the sending mood (post or get). In any Web site there is a page that in a concise way presents the content of it and contains references thru the pages that details the information. Usually, the file where the page is stocked, it is called “index.html”.
A Web server application is a reacting program. This program runs continuously on a PC connected on the INTERNET (server) waiting to receive a supply from a customer application that rolls up on another PC from the network (Netscape, Internet Explorer, etc.). The Web server controls a collection of files disposed on the computer disk on that this one it is installed. If the application customer demands an existent document, the server application will furnish it compiling with the protocol rules established in the customer demand (http). On a server connected at the Internet can run, besides the Web-server, other server applications (using for instance an SQL server for the data base). The transfer of the files will be achieved using the TCP/IP network protocol.
This application is structured on two levels. The first one (the data base level) consists of a data base called “personnel”. The second one (the applications) consists of PhP programs written around the script index.php.
* Employee – contains employees private data.
* Compartments – contains the services, compartments and office list.
* Grid – contains salary grid.
* Structure/Internal structure – contains the firm structure including the vacant jobs.
* Cm – contains information in relation with the employees record.
The five tables work both with the personal record and the organizational analysis. The relation between the employee (wage-earner), job (Structure), working area (Compartments) and the employee wage has been achieved through MySQL facility.
The PhP program has been made using the development applications platform “Maguma Studio”.The source-code has been structured in 21 programs which function interrelated as it follows.
The designing of the main interface requires HTML (Hypertext Marking Language). Visual options PhP has been also used. Five procedures have been use according with the first five control buttons, corresponding also to the five personnel database tables.
* Index_sal – connecting program with the employee table.
* Index_comp – connecting program with the compartments.
* Index_grid – connecting program with the grid table.
* Index_org – connecting program with the structure table.
* Index_cm – connecting program with the cm table.
The tables direct interface with the written application in PhP has been made thru the following nine subprograms:
* Pers_new, Pers_edit – a program for updating the employee table.
* Comp_new, Comp_edit – is updating the compartment table.
* Grila_new, Grila_edit – is updating the grid table.
* Org_new, Org_edit – is updating the structure.
* Cm_edit – is updating the cm table.
There have been designed the following reports:
* Sectors employees list (fulfilled jobs)
* The whole jobs per sectors list
* Employee records listing
The next figure, 6th, shows the way we did the compartment table loading with differentiation codes of the compartments, the compartment name and the compartment dependence on the upper level.
Based on the compartment and employee tables, we can get the personnel list according to the structure where someone easy can see the vacant jobs. In order to load the structure there have been used data from the organizational analysis of the underground coal mining industry.
The designed and achieved application can be introduced even in the firms. Analysis on application of the informational systems from the human resources management required:
* The achievement of a personnel analysis system for one’s firm human resources function rely on relational interconnected database.
* The data dictionaries designed for different criteria personnel record.
* Information achievement of this system analysis has been made with DNA technology is based on the following components:
* Using the highest technical design for applications rely on the overlapping customer-server applications.
* In this way has been made a client-server application at distance.
* Using the MySQL engine has two advantages : it is free licence, and it is also very strong and robust
* The PhP language is nowadays the most used and best program language on the web which is in fact the future programming.
For running this designed application, the MySQL database servers will be installed on the PC servers and the Apache server applications also, and on the customer PC will be installed the Internet Explorer browser. For an accurate installation, even if the server is the same with the customer workstation, will be installed the Merlin Desktop which contains the Apache- MySQL-Php triad.
For instance, to illustrate the PhP language using for the compartment table connection, I reproduced a part of Index_comp program.
The whole fields extraction from the compartments tables is achieved like this:$strquerry=”SELECT*FROM compartment”.$order;
1. Alter Steven, (1996). “ Information Systems . A management perspective.
Second Edition”, The Benjamin Cummings Publishing Company Inc, Menlo
Park, California
2. Edelhauser Eduard, (2004). “Information System for Human Resources
Management in a Firm”, PhD Thesis, Petrosani
3. Greenspan Jay, Bulger Brad, (2001). “MySQL / PHP Database Applications”,
Wiley, John and Soons Incorporated Publisher
4. Meloni C. Julie, (2002). “Sams Teach Yourself PHP, MySQL and Apache in
24 Hours”, Sams Barns and Noble Publisher
5. Orfali Robert, Harkey Dan, (1998). “ Client / Server Programing with Java
and Corba”. Wiley Computer Publishing
6. Simionescu Aurelian, s.a., (1999). ”Human Resource Management ”, Agir
Publishing House, Bucuresti,
7. Widenius Michael, Axmark David, (2002). “ MySQL Reference Manual”,
Wiley John and Soons Incorporated Publisher