IF MESSAGEBOX("Confirma Impresso   ",36,"Impresso") = 6

cValor1 = LEN(ALLTRIM("ORCAMENTO"))
cVal1 = 27 - cValor1

TSEXEC("T","SELECT * FROM Tsl ","TSL")

nSelect = "SELECT Tslv020.*,Tslc001.CLINOM,Tslc001.PESSOA,Tslc001.CLIEND,Tslc001.CLIBAI,Tslc001.CLICID,Tslc001.CLITEL,Tslc001.CLICPF,"
nSelect = nSelect + "Tslc001.CLICGC,Tslc004.NOME "
nSelect = nSelect + "FROM Tslv020 LEFT JOIN Tslc001 ON Tslv020.CODCLI = Tslc001.CLICOD "
nSelect = nSelect + "LEFT JOIN Tslc004 ON Tslv020.CODVEN = Tslc004.CODIGO WHERE ?cTabImp = Tslv020.SEQ "
TSEXEC("T",nSelect,"TSLV020")

nSelect = "SELECT Tslv021.*,Tslc003.CODBAR FROM Tslv021 LEFT JOIN Tslc003 ON Tslv021.CODPROD = Tslc003.CODIGO "
nSelect = nSelect + "WHERE ?cTabImp = CUPOM AND EXCLUI <> 'S' "
TSEXEC("T",nSelect,"TSLV021_1")

GERACURSOR("TSLV021_1","TSLV021")

SELECT TSLV021
UPDATE TSLV021 SET CODBAR = PADL(ALLTRIM(STR(CODPROD,16)),16,"0") WHERE EMPTY(ALLTRIM(CODBAR))

IF ! USED("PARAMETRO")
   USE PARAMETRO IN 44 SHARED
ENDIF

SELECT PARAMETRO
APRINTERS(cImp)
   
*SET PRINTER TO NAME cImp(PARAMETRO.IMPORC)

nPagina = 1

*DO WHILE nPagina < 2

nValPag = 1

CABECA = " " + space(int((70 - len(AllTrim(TSL.NOME))) / 2)) + alltrim(TSL.NOME)+space(int((70 - len(AllTrim(TSL.NOME))) / 2))+dToc(TSLV020.DATA) + chr(13)
CABECA = CABECA + space(int((72 - len(AllTrim(TSL.ENDERECO))) / 2)) + alltrim(TSL.ENDERECO)+space(int((72 - len(AllTrim(TSL.ENDERECO))) / 2)) + TIME()+chr(13)
CABECA = CABECA + space(int((80 - len(Alltrim(TSL.FONE))) / 2)) + AllTrim(TSL.FONE)+chr(13)
CABECA = CABECA + "ORC. N.: " + PADL(ALLTRIM(STR(TSLV020.SEQ,6)),6,"0") + Replicate(" ",12) + "< CUPOM SEM VALOR FISCAL >" + REPLICATE(" ",cVal1) + ALLTRIM("ORCAMENTO")+CHR(13)
CABECA = CABECA + Replicate("-",80)+chr(13)
IF TSLV020.PESSOA = "FSICA"
   cCpfCgc = "CPF: " + TSLV020.CLICPF
ELSE
   cCpfCgc = "CNPJ: " + TSLV020.CLICGC
ENDIF
CABECA = CABECA + "Nome.....: " + PADL(ALLTRIM(STR(TSLV020.CODCLI,6)),6,"0") + " - " + TSLV020.CLINOM + cCpfCgc + CHR(13)
CABECA = CABECA + "Endereco.: " + AllTrim(TSLV020.CLIEND) + " " + " Tel.: " + TSLV020.CLITEL + CHR(13)
CABECA = CABECA + "Bairro...: " + ALLTRIM(TSLV020.CLIBAI) + "  Cidade.: " + ALLTRIM(TSLV020.CLICID) + CHR(13)
CABECA = CABECA + "Vendedor.: " + PADL(ALLTRIM(STR(TSLV020.CODVEN,5)),5,"0") + " - " + ALLTRIM(TSLV020.NOME) + "  Comprador.: " + ALLTRIM(TSLV020.COMPRADO) + CHR(13)
CABECA = CABECA + Replicate("-",80)+chr(13)

cImprimir = CABECA + "Cod.  Descricao                        UN   ST         Qtde    Unit.R$  Valor R$"+chr(13)
cImprimir = cImprimir + Replicate("-",80)+chr(13)
Select TSLV021
Go Top IN TSLV021
nLinha = 9
cTotal = 0

Do While ! Eof("TSLV021")
   
*      If nLinha > 36
*         ??? Replicate("-",80)+chr(13)+chr(10)
*         ??? chr(12)
*         ??? cabeca + CHR(13)+CHR(10)
*         nLinha = 9
*      Endif
   
      nLinha = nLinha + 1
   
      SET DECIMALS TO 3
      cImprimir = cImprimir + Substr(TSLV021.CODBAR,12,5) + " " + Substr(TSLV021.DESCRICAO,1,31) + "  " +;
      TSLV021.UNIDADE + "  " + TSLV021.ST + "  " + TRANSFORM(TSLV021.QUANT,"999,999.99") + " "+;
      TRANSFORM(TSLV021.UNIT,"99,999.999") + " " + TRANSFORM(TSLV021.TOTAL,"99,999.99")+CHR(13)
      
      cTotal = cTotal + TSLV021.TOTAL
      
      Skip In TSLV021
   Loop
Enddo

cImprimir = cImprimir + Replicate("-",80)+chr(13)
cImprimir = cImprimir + Replicate(" ",60) + "Total R$: " + TRANSFORM(cTotal,"999,999.99")+chr(13)
IF TSLV020.DESCONTO > 0
   cImprimir = cImprimir + Replicate(" ",60) + "Desconto: " + TRANSFORM(TSLV020.DESCONTO,"999,999.99")+chr(13)
   cImprimir = cImprimir + Replicate(" ",60) + "Total R$: " + TRANSFORM((cTotal - TSLV020.DESCONTO),"999,999.99")+chr(13)
ENDIF
cImprimir = cImprimir + Replicate("-",80)+chr(13)

cImprimir = cImprimir + "Vencimentos..." + chr(13)

nselect = "SELECT * FROM Tsm003 WHERE ?cTabImp = SEQCUP AND FLAG = 'O' AND RECEST = 0 "
TSEXEC("T",nSelect,"TMP_VENCTOS")
SELECT TMP_VENCTOS
go top IN TMP_VENCTOS
DO WHILE ! EOF("TMP_VENCTOS")
   cImprimir = cImprimir + DTOC(TMP_VENCTOS.RECVENCI) + " " + TRANSFORM(TMP_VENCTOS.RECVALOR,"9,999,999.99") + CHR(13)
   
   SKIP IN TMP_VENCTOS
   LOOP

ENDDO

cImprimir = cImprimir + Replicate("-",80)+chr(13)
cImprimir = cImprimir + space(int((80 - len(AllTrim(AllTrim(TSL.OMENS01) + " - " + AllTrim(TSL.OMENS02)))) / 2))+AllTrim(AllTrim(TSL.OMENS01) + " - " + AllTrim(TSL.OMENS02))+chr(13)
*cImprimir = cImprimir + space(int((80 - len(AllTrim(AllTrim(TSL.OMENS03)))) / 2))+AllTrim(AllTrim(TSL.OMENS03))+chr(13)
cImprimir = cImprimir + " " + CHR(13)
cImprimir = cImprimir + "  /    /       Ass.............................   RG........................"+chr(13)

*IF nPagina < 2
   cImprimir = cImprimir + REPLICATE("- ",40) + CHR(13)+CHR(10)
*ENDIF

nPagina = nPagina + 1
*LOOP
*ENDDO

CREATE CURSOR TMP_IMPRIMIR (CODIGO M(04))
SELECT TMP_IMPRIMIR
INSERT INTO TMP_IMPRIMIR (CODIGO) VALUES (cImprimir)
SELECT TSLV021
IF RECCOUNT() > 8
   cReim = 1
ELSE
   cReim = 0
   INSERT INTO TMP_IMPRIMIR (CODIGO) VALUES (cImprimir)
ENDIF

SELECT TMP_IMPRIMIR
GO TOP IN TMP_IMPRIMIR
cReport = FULLPATH(CURDIR()) + "IMPRESS\TSORC.FRX"

REPORT FORM &cReport TO PRINTER PROMPT

IF cReim = 1
   SELECT TMP_IMPRIMIR
   GO TOP IN TMP_IMPRIMIR
   cReport = FULLPATH(CURDIR()) + "IMPRESS\TSORC.FRX"
   
   REPORT FORM &cReport TO PRINTER PROMPT
ENDIF

ENDIF