<!---
This file is Copyright © 1998-2009 by Home Care Business Services. This work may not be reproduced, in whole or in part, 
using any medium, including, but not limited to, electronic transmission, CD-ROM or published in print, without the express 
permission of Home Care Business Services.

$Revision: 1.6 $
$Id: getitems.cfm,v 1.6 2010/05/04 16:01:58 arlen Exp $
$Date: 2010/05/04 16:01:58 $
--->

<cfparam name=t default="">
<cfparam name=id default=0>
<cfparam name="url.roles" default="">
<cfparam name="url.empids" default="">
<cfparam name="url.checkboxname" default="">

<cfif NOT isdefined("session.agencyid")>
	<h2>Your Session has timed out.</h2><br /> <p>Please Login again.<br /></p> 
<cfelse>
	<cfif url.t eq "employees">
			<cfset roleslist = url.roles />
			<!--- <cfset roleslist = REReplace(roleslist,"@","%'","ALL") />
			<cfset roleslist = REReplace(roleslist,"~","'%","ALL") /> --->	
			<cfquery  name="GetEmps" datasource="#Application.DataSrc#">
				SELECT Emp_ID, Emp_Last, Emp_First, Status, Loc_ID, Emp_Type, employee_auth.eaRole 
				 FROM   #Request.prefix_db_lookup#.pEmployee
				JOIN  #Request.prefix_db_agency#.employee_auth ON employee_auth.eaID = pEmployee.Emp_ID
				WHERE  Loc_ID = '#session.AgencyId#'
				AND Status  = 0
				AND Emp_Type  = "Employee"
				<cfif listlen(roleslist) EQ 1 AND listlen(roleslist) NEQ 0>
					AND eaRole like '%#roleslist#%'
				<cfelseif listlen(roleslist) NEQ 0 AND listlen(roleslist) GT 1 >
					AND  (
					<cfloop list="#roleslist#" index="rolename">
						eaRole like '%#rolename#%' OR 
					</cfloop>
					eaRole like '%#rolename#%'
					)
				</cfif>
				GROUP BY Emp_ID
				ORDER BY Status, Emp_Last, Emp_First				
			</cfquery>	

			<cfif url.checkboxname NEQ ''>
				<cfset checkbox_name= #url.checkboxname# />
			<cfelse>
				<cfset checkbox_name=  "Employee_ID" />
			</cfif>

			<cfif isdefined('GetEmps.Recordcount') and GetEmps.Recordcount gt 0>				
				<div class="checkbox-list">
					<div class="row">
						<cfoutput query="GetEmps">
							<div class="col-md-4" >
								<input type="checkbox"  name="#checkbox_name#" class="Emp_ID" value="#GetEmps.Emp_ID#" <cfif  listFind(url.empids, Emp_ID) GT  0>checked</cfif>/>
								
								<span <cfif Emp_Type EQ 'Physician'>style="background-color:yellow;"</cfif>>
								<cfif Emp_Type EQ 'Physician'>
									#GetEmps.Phys_Last#, #GetEmps.Phys_First# 
								<cfelse>
									#GetEmps.Emp_Last#, #GetEmps.Emp_First# 
								</cfif>
								</span>
							</div>
						</cfoutput>
					</div>
				</div>
							
			</cfif>
	</cfif>
</cfif>