<cfinclude template = '../__Security-Block.cfm' />
<cfsetting enablecfoutputonly="Yes">
<cfprocessingdirective suppresswhitespace="Yes">
 <cfparam name='url.id' default='-1' />

 <cfquery  name='getFile' datasource='#Application.DataSrc#'>
    SELECT FileName, FileType, File
    FROM    #Request.prefix_db_agency#.pg_files
    WHERE  id = '#url.id#'
    AND    Agency_Id = '#session.AgencyId#'
 </cfquery>
 
<cfquery  name='getFilename' datasource='#Application.DataSrc#'>
  SELECT * FROM    #Request.prefix_db_agency#.pg_files
  WHERE  id = '#url.id#'
  AND    Agency_Id = '#session.AgencyId#' 
 </cfquery>
 
<cfif getFilename.Recordcount gt 0 >
  <cfset path = 'Progress_files/agency_'&#session.AgencyId# />
  <cfheader name="Content-Disposition" value="attachment; filename=#Rereplace(getFilename.FileName,',','','all')#" />
  <cfcontent type="#getFile.FileType#" file="s3://#Request.bucket_accesskey#:#Request.bucket_secretkey#@#Request.bucket_name#/#path#/#getFilename.Dup_file_name#" />
<cfelse>
   <cfheader name="content-length" value="#ArrayLen(getFile.File)#" />
   <cfheader name="content-disposition" value="attachment; filename=#Rereplace(getFile.FileName,',','','all')#" />
   <cfcontent type="#getFile.FileType#" variable="#getFile.File#" />
</cfif>
</cfprocessingdirective>
