<cfif Not isDefined('session.AgencyId') or session.AgencyId eq ''>
 <div style='margin:20px;'>
  Your session has Timed Out.
   <br/><br/>
  Please <a href='/'>Sign In</a> again to continue.
 </div>
 <cfexit>
</cfif>
    
<cfset url.sid   = decrypt(#url.sid#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex") />
<cfquery name="GetSchedule" datasource="#Application.DataSrc#">
 SELECT Employee.Employee_Id, Employee.Last_Name, Employee.First_Name,
        patient.Patient_Id, patient.Last_Name_M0040, patient.First_Name_M0040, patient.Agency_Assigned_Id,
        ScheduleItems.ScheduleItems_Id, ScheduleItems.Visit_Date, ScheduleItems.Visit_Type, ScheduleItems.StartTime,
        ScheduleItems.EndTime, ScheduleItems.Mileage, ScheduleItems.Visit_Notes, ScheduleItems.Signature, ScheduleItems.Location,
		ScheduleItems.Signed_date
 FROM  #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems
 WHERE ScheduleItems.ScheduleItems_Id = '#url.sid#'
 And   patient.Patient_Id = ScheduleItems.Patient_Id
 And   ScheduleItems.Employee_Id = Employee.Employee_Id
 AND   Employee.EmployeeType != 'Physician'
</cfquery>

<cfoutput>
<img src="data:image/jpeg;base64,#GetSchedule.Signature#" />
<!---<iframe src="data:image/jpeg;base64,#GetSchedule.Signature#" height="200" width="100" height="100" width="100"></iframe>--->
</cfoutput>

