home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
workdb.zip
/
REPORT.PRG
< prev
next >
Wrap
Text File
|
1988-08-15
|
9KB
|
289 lines
*!!* dBASE CONVERT - dBASE III File Conversion Aid v2.01 1/10/86
*
SET HEADING OFF
SET SAFETY OFF
* report.sig 08/18/83
STORE .T. TO MORE
DO WHILE MORE
STORE CHR(PEEK (063)) TO dr
CLEAR
STORE 'Y' TO PRINTER
STORE 'N' TO DISK
STORE ' ' TO FILENAME
STORE '?' TO COMMAND
@ 2, 0 SAY "--------------------------------------------------------------------------------"
@ 2,18 SAY "> > > R E P O R T M E N U < < <"
@ 5,18 SAY "1. Print return address labels"
@ 6,18 SAY "2. Print shipping labels"
@ 7,18 SAY "3. Print shipping documents"
@ 8,18 SAY "4. Print report of orders shipped"
@ 9,18 SAY "5. Print report of orders completed"
@ 10,18 SAY "6. Print backorder report"
@ 11,18 SAY "7. Display Records on screen"
@ 12,18 SAY "8. Make WordStar-MailMerge File"
@ 13,18 SAY "9. Return to Main Menu"
@ 17, 0 SAY "--------------------------------------------------------------------------------"
@ 20,30 SAY "WHAT NEXT"
@ 20,40 GET COMMAND PICTURE '!'
READ
IF COMMAND >'3' .AND. COMMAND < '7'
@ 20,00
@ 19,22 SAY "Send Report to the Printer (Y/N)"
@ 19,55 GET PRINTER PICTURE '!'
READ
@ 21,22 SAY "Send Report to a Disk File (Y/N)"
@ 21,55 GET DISK PICTURE '!'
READ
IF DISK ='Y'
@ 21,00
@ 21,22 SAY "Enter Disk File Name"
@ 21,44 GET FILENAME PICTURE '!!!!!!!!'
@ 21,54 SAY "(.TXT will be added )"
READ
@ 21,00
@ 21,22 SAY 'SELECT DRIVE TO PUT FILES ON ' GET DR PICTURE '!'
READ
DO WHILE AT(dr,'ABCDM') = 0
@ 21,00
@ 21,22 SAY 'SELECT DRIVE TO PUT FILES ON ' GET DR PICTURE '!'
READ
ENDDO WHILE @
ENDIF DISK = Y
IF PRINTER = 'Y'
@ 23,00 SAY 'MAKE PRINTER READY AND HIT ANY KEY'
SET CONSOLE OFF
WAIT
SET CONSOLE ON
SET PRINT ON
ENDIF PRINTER = Y
IF DISK = 'Y' .AND. FILENAME <> ' '
* make a proper REPORT file name that is of type TXT
STORE AT('.',filename) TO length
IF LENGTH = 0 .OR. LENGTH > 8
STORE 9 TO LENGTH
ENDIF LENGTH
STORE SUBSTR(filename,1,length-1) TO filename
STORE '&DR.:'+FILENAME+'.TXT' TO FILENAME
SET ALTERNATE TO &FILENAME
SET ALTERNATE ON
ENDIF DISK = Y AND FILENAME <> ''
ENDIF DISK = Y
CLEAR
DO CASE
CASE COMMAND = '1'
SET PRINT ON
SET CONSOLE OFF
* set printer codes for small type
? CHR(29)
? CHR(27) + chr(56)
SET PRINT OFF
SET CONSOLE ON
CLEAR
STORE .T. TO LINEUP
DO WHILE LINEUP
STORE '?' TO COMMAND
@ 10,00
@ 11,00
@ 10,10 SAY 'PLEASE LINE UP THE TOP OF THE RIBBON WITH THE TOP OF THE LABEL'
@ 11,10 SAY 'WHEN LINED UP HIT ENTER FOR A PRINT CHECK.'
SET CONSOLE OFF
WAIT
SET PRINT ON
SET MARGIN TO 0
? 'THE TOP OF THE TOP LINE SHOULD BE ABOUT'
? '1/4" FROM THE TOP OF THE LABEL'
? ' '
SET PRINT OFF
SET CONSOLE ON
@ 10,00
@ 11,00
@ 10,10 SAY 'Are you lined up to print (Y/N) '
@ 10,44 GET COMMAND PICTURE '!'
READ
CLEAR GETS
IF COMMAND = 'Y'
SET PRINT ON
? ' '
? ' '
? ' '
? ' '
? ' '
SET PRINT OFF
STORE .F. TO LINEUP
STORE .T. TO PRINTLAB
ENDIF COMMAND = Y
ENDDO WHILE LINEUP
CLEAR
DO WHILE PRINTLAB = .T.
STORE '?' TO COMMAND
STORE 0 TO PRNTNO
@ 10,00
@ 11,00
@ 12,00
@ 13,00
@ 15,00
@ 13,12 SAY " How many return address labels shall we print ? " GET PRNTNO
READ
DO WHILE PRNTNO > 0
SET PRINT ON
SET CONSOLE OFF
SET MARGIN TO 5
? ' '
? ' SIG/M SOFTWARE'
? ' BOX 97'
? 'ISELIN, NJ 08830'
? ' '
? ' '
? ' '
? ' '
STORE PRNTNO - 1 TO PRNTNO
ENDDO WHILE PRNTNO
SET PRINT OFF
SET CONSOLE ON
SET PRINT ON
? CHR(30)
? CHR(27) + CHR(54)
EJECT
SET PRINT OFF
SET CONSOLE ON
STORE .F. TO PRINTLAB
ENDDO WHILE PRINTLAB
CLEAR
RELEASE ALL
STORE .T. TO FIRST
STORE .T. TO MORE
STORE '?' TO COMMAND
CASE COMMAND = '2'
@ 19,22 SAY "Send Report to a Disk File (Y/N)"
@ 19,55 GET DISK PICTURE '!'
READ
IF DISK ='Y'
@ 19,00
@ 19,22 SAY "Enter Disk File Name"
@ 19,44 GET FILENAME PICTURE '!!!!!!!!'
@ 19,54 SAY "(.TXT will be added )"
READ
@ 19,00
@ 19,22 SAY 'SELECT DRIVE TO PUT FILES ON ' GET DR PICTURE '!'
READ
DO WHILE AT(dr,'ABCDM') = 0
@ 19,00
@ 19,22 SAY 'SELECT DRIVE TO PUT FILES ON ' GET DR PICTURE '!'
READ
ENDDO WHILE @
ENDIF DISK = Y
@ 19,00
@ 20,22 SAY "Send Report to the Printer (Y/N)"
@ 20,55 GET PRINTER PICTURE '!'
READ
IF PRINTER = 'Y'
SET PRINT ON
SET CONSOLE OFF
? CHR(28)
SET PRINT OFF
SET CONSOLE ON
CLEAR
STORE .T. TO LINEUP
DO WHILE LINEUP
STORE '?' TO COMMAND
@ 10,00
@ 11,00
@ 10,10 SAY 'PLEASE LINE UP THE TOP OF THE RIBBON WITH THE TOP OF THE LABEL'
@ 11,10 SAY 'WHEN LINED UP HIT ENTER FOR A PRINT CHECK.'
SET CONSOLE OFF
WAIT
SET PRINT ON
SET MARGIN TO 0
? 'THE TOP OF THE TOP LINE SHOULD BE ABOUT'
? '1/4" FROM THE TOP OF THE LABEL'
? ' '
SET PRINT OFF
SET CONSOLE ON
@ 10,00
@ 11,00
@ 10,10 SAY 'Are you lined up to print (Y/N) '
@ 10,44 GET COMMAND PICTURE '!'
READ
CLEAR GETS
IF COMMAND = 'Y'
SET PRINT ON
? ' '
? ' '
? ' '
? ' '
? ' '
STORE .F. TO LINEUP
STORE .T. TO PRINTLAB
ENDIF COMMAND = Y
ENDDO WHILE LINEUP
ENDIF PRINTER = Y
DO LABELS.PRG
CASE COMMAND = '3'
DO SHIPDOC.PRG
CASE COMMAND = '4'
DO SHIPPED.PRG
CASE COMMAND = '5'
DO COMPLETE.PRG
CASE COMMAND = '6'
DO BACKORDR.PRG
CASE COMMAND = '7'
CLEAR
@ 02,12 SAY 'RECORDS ARE DISPLAYED BY LAST NAMES'
@ 05,12 SAY 'YOU MAY CHOOSE THE FIRST LETTER'
@ 06,12 SAY 'OF THE STARTING LOCATION OF THE RECORDS'
@ 09,12 SAY 'WHEN WAITING HIT SPACE BAR TO'
@ 10,12 SAY 'CONTINUE... OR ESCAPE TO QUIT'
* get a starting point in file
STORE 'A' TO STLETTER
@ 17,12 SAY 'LETTER OF ALPHABET AT WHICH TO START DISPLAY'
@ 17,57 GET STLETTER PICTURE '!'
READ
* goto starting point or next if no find
*!! EOF() will be true if NO FIND, and RECNO() will equal BOTTOM, not 0.
FIND &STLETTER
DO WHILE (EOF() .OR. BOF())
STORE 'ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ' TO ALPHABET
STORE AT(stletter,ALPHABET) + 1 TO NEXL
STORE SUBSTR(ALPHABET,NEXL,1) TO stletter
*!! EOF() will be true if NO FIND, and RECNO() will equal BOTTOM, not 0.
FIND &STLETTER
RELEASE ALPHABET
ENDDO WHILE #
* display selected list
CLEAR
SET ESCAPE OFF
DISPLAY NEXT 65000 LNAME,ZIP,COMP,ENTERED,SHIPPED
IF EOF()
WAIT
ENDIF
SET ESCAPE ON
CASE COMMAND = '8'
DO WSFILE.PRG
CASE (command = '9' .OR. COMMAND = 'Q')
STORE .F. TO MORE
ENDCASE
SET PRINT OFF
SET ALTERNATE OFF
ENDDO WHILE MORE
RELEASE ALL
STORE .T. TO MORE
STORE .T. TO FIRST
STORE '?' TO COMMAND