|
The program below it's a program for the staff management. It does registration of work time and calculation of salary.
The technology basis of the program is traditional - "Client-server", but the program uses components for cached updates, which typically are for programs with middle tier.
There are some features of the program.
Interface:
- Printing of each tables(forms) in the program.
- Configuration of tables(forms).
- Two ways of sorting. A quick, after the click on the header, and permanent.
- Configuration of the predefined reports.
- Three types of filters: quick, usual - a tree of the conditions (AND,OR, NOT), and on basis of sets of data.
Last one is the best. It's a possibility to remember a set of employees and then find in the other tables(forms) such records, that belongs to the remembered set of employees.
A little know-how may be?
- Quick access to the permanently saved filters
- Bookmarks in the main tables(forms)
- Highlights the changed records before sending to the database.
- Export in the Excel with preliminary formatted result.
Functionality:
- Calculation of salary with different algorithms as a function of work time.
For example: limiting the maximal salary, but reducing the salary in case of absence on work place
and with increasing salary over the limit in case of overwork, having in view the factor of overwork.
- Quick realization of new algorithms (demands programmer's work yet ).
- Calculation of different periods within the calculated month, when employee had different salary.
- Possibility to calculate the salary of en employee who had several posts in one time.
- Support of different currencies. The salary is calculating in basic currency using rate on the end of calculation period.
- Schedule. - Selection of amount of working days in the month for groups of the employees.(The clear interface.)
- Temporary separating of the employee from the schedule. (The convenient interface).
- Example of the predefined report: A list of the presence on work place in the certain day on separate work location.
You could see the program, if you have the Oracle Client (up to 8.1.5) , having adjusted Oracle Client for example so:
In the file TNSNAMES.ORA :
ALFA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 92.49.20.24)(PORT = 1521)))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = tenplanets.net)))
and in the register of Windows in the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\YOUR_HOME :
NLS_DATE_FORMAT - DD/MM/YYYY hh24:mi:ss
NLS_LANG - RUSSIAN_CIS.CL8MSWIN1251
NLS_NUMERIC_CHARACTERS - .,
The values for the specified keys should match the current options of Windows.
For example if your date format is MM/dd/yyyy and time format is HН.mm.ss , then the key
NLS_DATE_FORMAT will be MM/DD/YYYY hh24.mi.ss
Earlier versions Oracle Client than 8.1.5 I did not try.
Program need two files in one directory:
employees.enu
employees.exe
employees.zip
Start of the program as usual. In case of using English, close the program, and restart. After restart you will see text in proper view.
Don't forget run the file employees.reg, before starting the program.
In result, in the register of Windows will appear node HKEY_CURRENT_USER\Software\JCode that contents such of the options as name and length of cols, filters, sorts.
The materials submitted on this page are only for presentation not for public usage.
|
|
