<cfcomponent displayname="Dashboard Functions" hint="I Return Dashboard Information" output="false">
    <cfparam name="client.Loc_ID" default = "0">
    <cffunction name="init" displayname="Initialize Component" access="public" returntype="Patients" hint="I initialize and return the Employees object.">
		<cfreturn this>
	</cffunction>
    
   	<cffunction name="update_procedureQA"   access="remote" output="Yes" returnFormat= "plain" >
	    <cfargument name="Careplan_ID" required="yes" hint="Careplan_ID" >
	    <cfargument name="Proc_QA" required="yes" hint="Proc_QA" >
	    <cfscript>
       		 pgcfc = CreateObject("Component", "components.general.progressnotes");
       		 retiredcareplans = pgcfc.retire_careplans(#arguments.Careplan_ID#); 
        </cfscript>
	    <cfquery name="update_pCareplan" datasource="#Application.DataSrc#"  result="result">
		       UPDATE #Request.prefix_db_agency#.pCareplan SET 
		       Proc_QA   = <cfqueryparam VALUE="#arguments.Proc_QA#"  cfsqltype="cf_sql_integer">,      
		       Date_Change = <cfqueryparam VALUE="#now()#"  cfsqltype="cf_sql_timestamp">,
		       Change_by = <cfqueryparam VALUE="#session.employeeid#"  cfsqltype="cf_sql_integer">
		       WHERE Careplan_ID = <cfqueryparam VALUE="#arguments.Careplan_ID#"  cfsqltype="cf_sql_integer">
		       ANd Status = 0
		</cfquery>
		<cfreturn  'Success'>
	</cffunction>

	<cffunction name="update_goalsQA"   access="remote" output="Yes" returnFormat= "plain" >
	    <cfargument name="Careplan_ID" required="yes" hint="Careplan_ID" >
	    <cfargument name="QA_approve" required="yes" hint="Proc_QA" >
	    <cfscript>
       		 pgcfc = CreateObject("Component", "components.general.progressnotes");
       		 retiredcareplans = pgcfc.retire_careplans(#arguments.Careplan_ID#); 
        </cfscript>
	    <cfquery name="update_pCareplan" datasource="#Application.DataSrc#"  result="result">
		       UPDATE #Request.prefix_db_agency#.pCareplan SET 
			   <cfif arguments.QA_approve EQ 2 >
			   		Status = 0,
			   </cfif>
		       QA_approve   = <cfqueryparam VALUE="#arguments.QA_approve#"  cfsqltype="cf_sql_integer">,      
		       Date_Change = <cfqueryparam VALUE="#now()#"  cfsqltype="cf_sql_timestamp">,
		       Change_by = <cfqueryparam VALUE="#session.employeeid#"  cfsqltype="cf_sql_integer">
		       WHERE Careplan_ID = <cfqueryparam VALUE="#arguments.Careplan_ID#"  cfsqltype="cf_sql_integer">
		       ANd Status = 1
		</cfquery>
		<cfreturn  'Success'>
	</cffunction>



	<cffunction name="update_dischargeapproval"   access="remote" output="Yes" returnFormat= "plain" >
	    <cfargument name="Assmt_ID" required="yes" hint="Assmt_ID" >
	    <cfargument name="QA_Count" required="yes" hint="QA_Count" >
	    <cfscript>
       		 pgcfc = CreateObject("Component", "components.general.progressnotes");
       		 retiredcareplans = pgcfc.retire_assessments(#arguments.Assmt_ID#); 
        </cfscript>
	    <cfquery name="update_pCareplan" datasource="#Application.DataSrc#"  result="result">
		       UPDATE #Request.prefix_db_agency#.pAssessments SET 
		       QA_Count   = <cfqueryparam VALUE="#arguments.QA_Count#"  cfsqltype="cf_sql_integer">,      
		       Record_Mod_Date = <cfqueryparam VALUE="#now()#"  cfsqltype="cf_sql_timestamp">,
		       Record_Mod_By = <cfqueryparam VALUE="#session.employeeid#"  cfsqltype="cf_sql_integer">
		       WHERE Assmt_ID = <cfqueryparam VALUE="#arguments.Assmt_ID#"  cfsqltype="cf_sql_integer">
		       ANd Status = 0
		</cfquery>
		<cfreturn  'Success'>
	</cffunction>

	<cffunction name="update_progressQA"   access="remote" output="Yes" returnFormat= "plain" >
	    <cfargument name="Schedule_ID" required="yes" hint="Schedule_ID" >
	    <cfargument name="QA_View" required="yes" hint="QA_View" >
	    <cfscript>
       		 pgcfc = CreateObject("Component", "components.general.progressnotes");
       		 retiredschedules = pgcfc.retire_schedules(#arguments.Schedule_ID#); 
        </cfscript>
	    <cfquery name="update_pSchedules" datasource="#Application.DataSrc#"  result="result">
		       UPDATE #Request.prefix_db_agency#.pSchedules SET 
		       	QA_View   = <cfqueryparam VALUE="#arguments.QA_View#"  cfsqltype="cf_sql_integer">, 
		       Date_Change = <cfqueryparam VALUE="#now()#"  cfsqltype="cf_sql_timestamp">,
		       Change_by = <cfqueryparam VALUE="#session.employeeid#"  cfsqltype="cf_sql_integer">
		       WHERE Schedule_ID = <cfqueryparam VALUE="#arguments.Schedule_ID#"  cfsqltype="cf_sql_integer">
		       ANd Status = 0
		</cfquery>
		<cfreturn  'Success'>
	</cffunction>


	<cffunction name="update_requiredproceduresQA"   access="remote" output="Yes" returnFormat= "plain" >
	    <cfargument name="Schedule_ID" required="yes" hint="Schedule_ID" >
	    <cfargument name="QA_Proc" required="yes" hint="QA_Proc" >
	    <cfscript>
       		 pgcfc = CreateObject("Component", "components.general.progressnotes");
       		 retiredschedules = pgcfc.retire_schedules(#arguments.Schedule_ID#); 
        </cfscript>
	    <cfquery name="update_pSchedules" datasource="#Application.DataSrc#"  result="result">
		       UPDATE #Request.prefix_db_agency#.pSchedules SET 
		       QA_Proc   = <cfqueryparam VALUE="#arguments.QA_Proc#"  cfsqltype="cf_sql_integer">,   
		       <cfif arguments.QA_Proc EQ 2>
		       		pgnotesdraft   = <cfqueryparam VALUE="1"  cfsqltype="cf_sql_integer">, 
		       </cfif>    
		       Date_Change = <cfqueryparam VALUE="#now()#"  cfsqltype="cf_sql_timestamp">,
		       Change_by = <cfqueryparam VALUE="#session.employeeid#"  cfsqltype="cf_sql_integer">
		       WHERE Schedule_ID = <cfqueryparam VALUE="#arguments.Schedule_ID#"  cfsqltype="cf_sql_integer">
		       ANd Status = 0
		</cfquery>
		<cfreturn  'Success'>
	</cffunction>


</cfcomponent>	