#INCLUDE "PROTHEUS.CH"

User Function GFEA0706GFEA0707()
	Local aRet := {'',.F.}
	Local cQuery
	Local aOldAreacAliasGW3
	Local cMV_XDTOF := GetAreaGetMv("MV_XDTOF")
	Local aRotinadData := STOD('00000000')
	
	If cMV_XDTOF == PARAMIXB[1]
	
	ADD OPTION aRotina TITLE "Título" ACTION <FUNCAO()> OPERATION 4 ACCESS 0
	
	RestArea(aOldArea)
Return aRotina1
		cQuery := 'SELECT DISTINCT GW3_DTFIS, GW3_DTREC, GW3_NRDF,'
		cQuery += ' GV5_SENTID FROM '+RetSqlName('GW3')+" GW3"
		cQuery += ' INNER JOIN '+RetSqlName('GW4')+" GW4"
		cQuery += ' ON GW4_FILIAL = GW3_FILIAL
		cQuery += ' AND GW4_EMISDF = GW3_EMISDF
		cQuery += ' AND GW4_CDESP  = GW3_CDESP
		cQuery += ' AND GW4_SERDF  = GW3_SERDF
		cQuery += ' AND GW4_NRDF   = GW3_NRDF
		cQuery += ' AND GW4_DTEMIS = GW3_DTEMIS
		cQuery += " AND GW4.D_E_L_E_T_ = ' '"
		cQuery += ' LEFT JOIN '+RetSqlName('GW1')+" GW1"
		cQuery += ' ON GW1_FILIAL = GW4_FILIAL
		cQuery += ' AND GW1_CDTPDC = GW4_TPDC
		cQuery += ' AND GW1_EMISDC = GW4_EMISDC
		cQuery += ' AND GW1_SERDC  = GW4_SERDC
		cQuery += ' AND GW1_NRDC   = GW4_NRDC
		cQuery += " AND GW1.D_E_L_E_T_ = ' '"
		cQuery += ' INNER JOIN '+RetSqlName('GV5')+" GV5"
		cQuery += ' ON GV5_CDTPDC = GW1_CDTPDC'
		cQuery += " WHERE GW3_FILIAL = '"+GW6->GW6_FILIAL+"'"
		cQuery += " AND GW3_EMIFAT = '"+GW6->GW6_EMIFAT +"'"
		cQuery += " AND GW3_SERFAT = '"+GW6->GW6_SERFAT+"'"
		cQuery += " AND GW3_NRFAT = '"+GW6->GW6_NRFAT+"'"
		cQuery += " AND GW3_DTEMIS = '"+DTOS(GW6->GW6_DTEMIS)+"'"
		cQuery += " AND GW3.D_E_L_E_T_ = ''"
		cQuery := ChangeQuery(cQuery)
		cAliasGW3 := GetNextAlias()
		DbUseArea(.T.,'TOPCONN',TcGenQry(,,cQuery),cAliasGW3,.F.,.T.)
		
		While !(cAliasGW3)->( Eof() )
			If EMPTY((cAliasGW3)->GW3_DTFIS) .and. EMPTY((cAliasGW3)->GW3_DTREC)
				Msginfo("Documento de Frete "+(cAliasGW3)->GW3_NRDF+" não está integrado no módulo Fiscal.";
				+" Integração com o Financeiro não permitida","Documento de Frete ínvalido")
				dData := ''
				Exit
			EndIf
			
			if !EMPTY((cAliasGW3)->GW3_DTFIS) .and. (cAliasGW3)->GV5_SENTID == '2'
				If (cAliasGW3)->GW3_DTFIS > DTOS(dData)
					dData := STOD((cAliasGW3)->GW3_DTFIS)
				EndIF
			ElseIf !EMPTY((cAliasGW3)->GW3_DTREC) .and. (cAliasGW3)->GV5_SENTID == '1'
				If (cAliasGW3)->GW3_DTREC > DTOS(dData)
					dData := STOD((cAliasGW3)->GW3_DTREC)
				EndIF
			EndIf
			(cAliasGW3)->( dbSkip() )
		EndDo
		
		If !EMPTY(dData)
			aRet[1] := dData
			aRet[2] := .T.
		EndIf
	EndIf
Return aRet