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

cTabImp = cRet024

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

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

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

nSelect = "SELECT Tslv025.*,Tslc003.CODBAR,Tslv021.QUANT AS QUANTC,Tslv021.QUANTR FROM Tslv025 "
nSelect = nSelect + "LEFT JOIN Tslc003 ON Tslv025.CODPROD = Tslc003.CODIGO "
nSelect = nSelect + "LEFT JOIN Tslv021 ON Tslv025.SEQV021 = Tslv021.SEQ "
nSelect = nSelect + "WHERE ?cTabImp = Tslv025.CUPOM AND Tslv025.EXCLUI <> 'S' "
TSEXEC("T",nSelect,"TSLV025_1")

GERACURSOR("TSLV025_1","TSLV025")

SELECT TSLV025
UPDATE TSLV025 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)

nValPag = 1
*SYS(1037) && INDICAR IMPRESSORA

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

??? CABECA + "Cod.  Descricao                        COMPRADO   RETIRADO      QUANT      SALDO"+chr(13)+chr(10)
??? Replicate("-",80)+chr(13)+chr(10)
Select TSLV025
Go Top IN TSLV025
nLinha = 9
cTotal = 0

Do While ! Eof("TSLV025")
   
      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
      ??? Substr(TSLV025.CODBAR,9,5) + " " + Substr(TSLV025.DESCRICAO,1,30) + " " +;
      TRANSFORM(TSLV025.QUANTC,"999,999.99") + " "+ TRANSFORM(TSLV025.QUANTR - TSLV025.QUANT,"999,999.99") + " " + ;
      TRANSFORM(TSLV025.QUANT,"999,999.99") + " " + TRANSFORM(TSLV025.QUANTC - TSLV025.QUANTR,"999,999.99")+CHR(13)+CHR(10)
      
      Skip In TSLV025
   Loop
Enddo

If nlinha > 25
   ??? chr(12)
   ??? cabeca + CHR(10)+CHR(13)
   nLinha = 9
Endif

??? Replicate("-",80)+chr(13)+chr(10)

IF nLinha > 24
   ??? CHR(12)
   ??? CABECA + CHR(10)+CHR(13)
ENDIF

??? "OBS: "+ TSLV024.OBS  + CHR(10)+CHR(13)
??? "     "+ TSLV024.OBS2 + CHR(10)+CHR(13)
??? space(int((80 - len(AllTrim(AllTrim(TSL.OMENS01) + " - " + AllTrim(TSL.OMENS02)))) / 2))+AllTrim(AllTrim(TSL.OMENS01) + " - " + AllTrim(TSL.OMENS02))+chr(13)+chr(10)
??? space(int((80 - len(AllTrim(AllTrim(TSL.OMENS03)))) / 2))+AllTrim(AllTrim(TSL.OMENS03))+chr(13)+chr(10)
??? " " + CHR(10)+CHR(13)
??? "  /    /       Ass.............................   RG........................"+chr(13)+chr(10)
??? Replicate("=",80)+chr(13)+chr(10)
??? "_______________             __________________"+CHR(10)+CHR(13)
??? "Ass. Conferente               Ass. Motorista"+CHR(10)+CHR(13)
??? chr(12)

Set Printer To

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

ENDIF