Liren Large Software Subsidy 5/05.iso/a/a031/samples.exe/EMPLOYEE.FRG

Text File | 1992-03-10 | 6.2 KB | 306 lines

* Program............: E:employee.FRG
* Date...............: 3-10-92
* Versions...........: dBASE IV, Report 1.5
*
* Notes:
* ------
* Prior to running this procedure with the DO command
* it is necessary use LOCATE because the CONTINUE
* statement is in the main loop.
*
*-- Parameters
PARAMETERS gl_noeject, gl_plain, gl_summary, gc_heading, gc_extra
** The first three parameters are of type Logical.
** The fourth parameter is a string.  The fifth is extra.
PRIVATE _peject, _wrap

*-- Test for no records found
IF EOF() .OR. .NOT. FOUND()
   RETURN
ENDIF

*-- turn word wrap mode off
_wrap=.F.

IF _plength < (_pspacing * 3 + 1) + (_pspacing + 1) + 2
   SET DEVICE TO SCREEN
   DEFINE WINDOW gw_report FROM 7,17 TO 11,62 DOUBLE
   ACTIVATE WINDOW gw_report
   @ 0,1 SAY "Increase the page length for this report."
   @ 2,1 SAY "Press any key ..."
   x=INKEY(0)
   DEACTIVATE WINDOW gw_report
   RELEASE WINDOW gw_report
   RETURN
ENDIF

_plineno=0          && set lines to zero
*-- NOEJECT parameter
IF gl_noeject
   IF _peject="BEFORE"
      _peject="NONE"
   ENDIF
   IF _peject="BOTH"
      _peject="AFTER"
   ENDIF
ENDIF

*-- Set-up environment
ON ESCAPE DO Prnabort
IF SET("TALK")="ON"
   SET TALK OFF
   gc_talk="ON"
ELSE
   gc_talk="OFF"
ENDIF
gc_space=SET("SPACE")
SET SPACE OFF
gc_time=TIME()      && system time for predefined field
gd_date=DATE()      && system date  "    "    "     "
gl_fandl=.F.        && first and last page flag
gl_prntflg=.T.      && Continue printing flag
gl_widow=.T.        && flag for checking widow bands
gn_length=LEN(gc_heading)  && store length of the HEADING
gn_level=2          && current band being processed
gn_page=_pageno     && grab current page number
gn_pspace=_pspacing && get current print spacing


*-- Set up procedure for page break
gn_atline=_plength - (_pspacing + 1)
ON PAGE AT LINE gn_atline EJECT PAGE

*-- Print Report

PRINTJOB

*-- Initialize summary variables.
r_msum1=0

IF gl_plain
   ON PAGE AT LINE gn_atline DO Pgplain
ELSE
   ON PAGE AT LINE gn_atline DO Pgfoot
ENDIF

DO Pghead

gl_fandl=.T.        && first physical page started

DO Rintro

*-- File Loop
DO WHILE FOUND() .AND. .NOT. EOF() .AND. gl_prntflg
   gn_level=0
   *-- Detail lines
   IF gl_summary
      DO Upd_Vars
   ELSE
      DO __Detail
   ENDIF
   gl_widow=.T.         && enable widow checking
   CONTINUE
ENDDO

IF gl_prntflg
   DO Rsumm
   IF _plineno <= gn_atline
      EJECT PAGE
   ENDIF
ELSE
   DO Rsumm
   DO Reset
   RETURN
ENDIF

ON PAGE

ENDPRINTJOB

DO Reset
RETURN
* EOP: E:employee.FRG

*-- Update summary fields and/or calculated fields.
PROCEDURE Upd_Vars
*-- Count
r_msum1=r_msum1+1
RETURN
* EOP: Upd_Vars

*-- Set flag to get out of DO WHILE loop when escape is pressed.
PROCEDURE Prnabort
gl_prntflg=.F.
RETURN
* EOP: Prnabort

PROCEDURE Pghead
PRIVATE ll_heading, ln_width
ll_heading = .T.
ln_width = _rmargin - _lmargin
?
*-- Print HEADING parameter - if it doesn't fit on line one
*-- Value added to gn_length is the last column on line one times two
IF .NOT. gl_plain .AND. gn_length + 158 > ln_width
   ?? gc_heading FUNCTION "I;V"+LTRIM(STR(ln_width))
   ?
   ll_heading = .F.
ENDIF

?? IIF(gl_plain,'',gd_date) AT 0,;
 IIF(gl_plain,'' , "PAGE " ) AT 70,;
 IIF(gl_plain,'',_pageno) PICTURE "999"

*-- Print HEADING parameter - if it fits on line one
IF .NOT. gl_plain .AND. gn_length > 0 .AND. ll_heading
   ?? " "
   ?? gc_heading FUNCTION "I;V"+LTRIM(STR(ln_width-(_pcolno*2)))
ENDIF
?
?
RETURN
* EOP: Pghead

PROCEDURE Rintro
DEFINE BOX FROM 23 TO 51 HEIGHT 4 DOUBLE
?
?? "A-T FURNITURE INDUSTRIES" AT 26
?
?? "EMPLOYEE REPORT" AT 30
?
?
?
?? ;
"══════════════════════════════════════════════════════════════════════";
+ "══════════";
AT 0
?
RETURN
* EOP: Rintro

PROCEDURE __Detail
IF 11 * gn_pspace < gn_atline - (_pspacing * 3 + 1)
   IF gl_widow .AND. _plineno+11 * gn_pspace > gn_atline + 1
      EJECT PAGE
   ENDIF
ENDIF
DO Upd_Vars
?
?? Lastname FUNCTION "T" AT 0,;
 ", " ,;
 Firstname FUNCTION "T" ,;
 " " ,;
 Initial FUNCTION "T" ,;
 "." ,;
 "ID:" AT 38,;
 Emp_id FUNCTION "T" AT 42,
?? Phone FUNCTION "T" AT 57
?
?? Address1 FUNCTION "T" AT 0,;
 " " ,;
 Address2 FUNCTION "T"
?
?? City FUNCTION "T" AT 0,;
 ", " ,;
 State FUNCTION "T" ,;
 " " ,;
 Zip FUNCTION "T"
?
?? "DEPARTMENT:" AT 5,;
 Department FUNCTION "T" AT 17,;
 "SALARY:  $" AT 57,;
 Salary PICTURE "99,999.99" AT 71
?
?? Title FUNCTION "T" AT 17,;
 Specialty FUNCTION "T" AT 38,;
 "COMMISSION RATE:  " AT 57,;
 Rate PICTURE "99.9" ,;
 "%"
?
?? "DATE HIRED: " AT 5,;
 Date_hired ,;
 "DEGREE:" AT 38,;
 Degree FUNCTION "T" AT 46,;
 "YEARS EXPERIENCE: " AT 57,;
 Yrs_exper PICTURE "99.9"
?
?? "EXEMPT: " AT 5,;
 Exempt PICTURE "Y" ,;
 "FULLTIME:" AT 38,;
 Full_time PICTURE "Y" AT 50
?
?? "AWARDS: " AT 5,;
 Awards FUNCTION "T" ,;
 "LABORGRADE:" AT 38,;
 Laborgrade PICTURE "9" AT 50
?
?? "COMMENTS: " AT 5,;
 Comments FUNCTION "T"
?
?? ;
"──────────────────────────────────────────────────────────────────────";
+ "──────────";
AT 0
?
RETURN
* EOP: __Detail

PROCEDURE Rsumm
?
?
?? ;
"──────────────────────────────────────────────────────────────────────";
+ "──────────";
AT 0
?
?? "NUMBER OF EMPLOYEES:" AT 0,;
 r_msum1 PICTURE "99,999" AT 21
?
?? ;
"──────────────────────────────────────────────────────────────────────";
+ "──────────";
AT 0
gl_fandl=.F.        && last page finished
?
RETURN
* EOP: Rsumm

PROCEDURE Pgfoot
PRIVATE _box, _pspacing
gl_widow=.F.         && disable widow checking
_pspacing=1
?
IF .NOT. gl_plain
   _pspacing=gn_pspace
ENDIF
EJECT PAGE
*-- is the page number greater than the ending page
IF _pageno > _pepage
   GOTO BOTTOM
   SKIP
   gn_level=0
ENDIF
IF .NOT. gl_plain .AND. gl_fandl
   _pspacing=gn_pspace
   DO Pghead
ENDIF
RETURN
* EOP: Pgfoot

*-- Process page break when PLAIN option is used.
PROCEDURE Pgplain
PRIVATE _box
EJECT PAGE
RETURN
* EOP: Pgplain

*-- Reset dBASE environment prior to calling report
PROCEDURE Reset
SET SPACE &gc_space.
SET TALK &gc_talk.
ON ESCAPE
ON PAGE
RETURN
* EOP: Reset