<!--- #10583 / #10584 / #10585 - Refresh Dash_emp_count from a report's live results.
     Expects:
       Request.dashEmpCountHeader (string) - Header value in Dash_emp_count
       Request.dashEmpCounts (struct) - Emp_ID => count
--->
<cfparam name="Request.dashEmpCountHeader" default="">
<cfparam name="Request.dashEmpCounts" default="#StructNew()#">

<cfif Len(Trim(Request.dashEmpCountHeader))>
	<cfquery name="deactivateDashEmpCountForHeader" datasource="#Application.DataSrc#">
		UPDATE #Request.prefix_db_agency#.Dash_emp_count
		SET status = <cfqueryparam value="1" cfsqltype="CF_SQL_INTEGER">
		WHERE Header = <cfqueryparam value="#Trim(Request.dashEmpCountHeader)#" cfsqltype="CF_SQL_VARCHAR">
		  AND status = <cfqueryparam value="0" cfsqltype="CF_SQL_INTEGER">
	</cfquery>

	<cfloop collection="#Request.dashEmpCounts#" item="dashEmpId">
		<cfif IsNumeric(dashEmpId) AND Val(dashEmpId) GT 0 AND Val(Request.dashEmpCounts[dashEmpId]) GTE 0>
			<cfquery name="insertDashEmpCountFromReport" datasource="#Application.DataSrc#">
				INSERT INTO #Request.prefix_db_agency#.Dash_emp_count
				(Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status)
				VALUES (
					<cfqueryparam value="#DateFormat(Now(), 'yyyy-mm-dd')#" cfsqltype="CF_SQL_DATE">,
					<cfqueryparam value="#Val(dashEmpId)#" cfsqltype="CF_SQL_INTEGER">,
					<cfqueryparam value="#Val(Request.dashEmpCounts[dashEmpId])#" cfsqltype="CF_SQL_INTEGER">,
					<cfqueryparam value="#Trim(Request.dashEmpCountHeader)#" cfsqltype="CF_SQL_VARCHAR">,
					<cfqueryparam value="#Now()#" cfsqltype="CF_SQL_TIMESTAMP">,
					<cfqueryparam value="0" cfsqltype="CF_SQL_INTEGER">
				)
			</cfquery>
		</cfif>
	</cfloop>
</cfif>
