PC Toledo

Código: Selecionar todos

STATIC FUNCTION JPUFcreateSQL()

   RETURN ;
      "CREATE TABLE IF NOT EXISTS JPUF ( " + ;
      "UFUF VARCHAR(2) NOT NULL DEFAULT '', " + ;
      "UFDESCRI VARCHAR(80) NOT NULL DEFAULT '', " + ;
      "UFTRIUF VARCHAR(6) NOT NULL DEFAULT '', " + ;
      "UFINFINC VARCHAR(80) NOT NULL DEFAULT '', " + ;
      "UFINFALT VARCHAR(80) NOT NULL DEFAULT '', " + ;
      "PRIMARY KEY ( UFUF ) " + ;
      ") COLLATE=latin1_swedish_ci ENGINE=InnoDB"

Código: Selecionar todos

STATIC FUNCTION JPUFCreateSQL()
#pragma __binarystreaminclude "tabelas\jpuf.sql"   | RETURN %s

Código: Selecionar todos

Static function SQLFerias()
    Local cSQL
    Text into cSQL
        select campo07 as IDSap,
            pfunc.chapa,
            nome,
            dataadmissao,
            datademissao,
            Convert(datetime,DTVENCFERIAS,103) as DtVencFerias,
            CODSITUACAO+'.'+PCODSITUACAO.DESCRICAO as CodTipo,
            DtIniPerAquis,pfhstfer.DtFimPerAquis,NroPeriodo as Periodo,
            Convert(datetime,DtIniGozo,103) as DtIniGozo,Convert(DateTime,DtFimGozo,103) as DtFimGozo,
            pf.datapagto,
            DiasAbono,NroFaltas as Faltas
        from  pfunc
            left join pfhstfer on pfunc.chapa=pfhstfer.chapa 
            LEFT JOIN PCODSITUACAO ON CODSITUACAO = PCODSITUACAO.CODCLIENTE
            left join PFUFERIASPER as PF on pfhstfer.codcoligada=pf.codcoligada and 
                pf.chapa=pfhstfer.chapa and  
                pfhstfer.dtfimperaquis=PF.FimPerAquis and 
                pfhstfer.DtIniGozo=pf.datainicio
    
            left join c_txtSeparado on '0'+campo01=pfunc.chapa
        where datademissao is null or datademissao >= convert(date,'01-03-2021',103)
            --and pfunc.chapa='01000'
            --and dtvencferias=dtfimperaquis
            order by chapa,pfhstfer.dtfimperaquis desc,Periodo desc    
    EndText
    Return cSQL