<cfcomponent extends="proventas31.common.formObject">
	<cfset variables.idProject=0>
	<cfset variables.project="">
	<cfset variables.idEmployee=0>
	<cfset variables.employee="">
	<cfset variables.dateStart="">
	<cfset variables.dateEnd="">

	<cfset variables.chartStyle="pie">
	<cfset module.list.orderBy="employee">

	<cffunction name="init" access="public" output="false">
		<cfset variables.idProject=0>
		<cfset variables.project="">
		<cfset variables.idEmployee=0>
		<cfset variables.employee="">
		<cfset variables.dateStart="">
		<cfset variables.dateEnd="">

		<cfset variables.chartStyle="pie">
	</cffunction>
	
	<cffunction name="getFormObjectId" access="public" output="false" returntype="numeric">
		<cfreturn getIdProject()>
	</cffunction>
	
	<cffunction name="setFormObjectId" access="public" output="false">
		<cfargument name="objectId" type="numeric" required="yes">
		<cfset setIdProject(arguments.objectId)>
	</cffunction>

	<cffunction name="setIdProject" access="public" output="false">
		<cfargument name="idProject" type="numeric" required="yes" default="0">
		<cfset variables.idProject=arguments.idProject>
	</cffunction>

	<cffunction name="getIdProject" access="public" returntype="numeric" output="false">
		<cfreturn variables.idProject>
	</cffunction>

	<cffunction name="getProject" access="public" returntype="proventas31.corporate.project" output="false">
		<cfif not IsObject("variables.project")><cfset variables.project=CreateObject("component", "proventas31.corporate.project")></cfif>
		<cfif (Compare(module.form.pageAction, "add") and not variables.project.isRetrievedFromDB()) or variables.project.getIdProject() neq variables.idProject>
			<cfset variables.project=CreateObject("component", "proventas31.corporate.project")>
			<cfset variables.project.setIdProject(variables.idProject)>
			<cfset variables.project.get()>
		</cfif>
		<cfreturn variables.project>
	</cffunction>

	<cffunction name="setIdEmployee" access="public" output="false">
		<cfargument name="idEmployee" type="numeric" required="yes" default="0">
		<cfset variables.idEmployee=arguments.idEmployee>
	</cffunction>

	<cffunction name="getIdEmployee" access="public" returntype="numeric" output="false">
		<cfreturn variables.idEmployee>
	</cffunction>

	<cffunction name="getEmployee" access="public" returntype="proventas31.corporate.employee" output="false">
		<cfif not IsObject("variables.employee")><cfset variables.employee=CreateObject("component", "proventas31.corporate.employee")></cfif>
		<cfif (Compare(module.form.pageAction, "add") and not variables.employee.isRetrievedFromDB()) or variables.employee.getIdEmployee() neq variables.idEmployee>
			<cfset variables.employee=CreateObject("component", "proventas31.corporate.employee")>
			<cfset variables.employee.setIdEmployee(variables.idEmployee)>
			<cfset variables.employee.get()>
		</cfif>
		<cfreturn variables.employee>
	</cffunction>
	
	<cffunction name="setChartStyle" access="public" output="false">
		<cfargument name="chartStyle" type="string" required="yes" default="pie">
		<cfset variables.chartStyle=arguments.chartStyle>
	</cffunction>

	<cffunction name="getChartStyle" access="public" returntype="string" output="false">
		<cfreturn variables.chartStyle>
	</cffunction>
	
	<cffunction name="setDateStart" access="public" output="false">
		<cfargument name="dateStart" type="string" required="yes" default="">
		<cfset variables.dateStart=arguments.dateStart>
	</cffunction>
	
	<cffunction name="getDateStart" access="public" returntype="string" output="false">
		<cfreturn variables.dateStart>
	</cffunction>

	<cffunction name="setDateEnd" access="public" output="false">
		<cfargument name="dateEnd" type="string" required="yes" default="">
		<cfset variables.dateEnd=arguments.dateEnd>
	</cffunction>
	
	<cffunction name="getDateEnd" access="public" returntype="string" output="false">
		<cfreturn variables.dateEnd>
	</cffunction>
	
	<cffunction name="getList" access="public" output="false" returntype="query">
		<cfset var _query="">
		<cfset var _step=20000>
		<cfloop from="200000" to="280000" step="#_step#" index="idx">
			<cfset _query=_query & "(select distinct count(salesClientUnit.idSalesClientUnit) from salesClientUnit where (sellPrice between #idx# and #(idx+_step-1)#)">
			<cfif Len(variables.dateStart)>
				<cfset _query=_query & ' and CAST(dateRegistration AS DATE) >= "#LSDateFormat(parseDate(variables.dateStart), "yyyy-mm-dd")#"'>
			</cfif>
			<cfif Len(variables.dateEnd)>
				<cfset _query=_query & ' and CAST(dateRegistration AS DATE) <= "#LSDateFormat(parseDate(variables.dateEnd), "yyyy-mm-dd")#"'>
			</cfif>
			<cfif variables.idProject gt 0>
				<cfset _query=_query & " and salesClientUnit.idProject=#variables.idProject#">
			</cfif>
			<cfset _query=_query & ") AS range#idx#, ">
		</cfloop>
		<!--- last range --->
		<cfset _query=_query & "(select distinct count(salesClientUnit.idSalesClientUnit) from salesClientUnit where (sellPrice > 300000)">
		<cfif Len(variables.dateStart)>
			<cfset _query=_query & ' and CAST(dateRegistration AS DATE) >= "#LSDateFormat(parseDate(variables.dateStart), "yyyy-mm-dd")#"'>
		</cfif>
		<cfif Len(variables.dateEnd)>
			<cfset _query=_query & ' and CAST(dateRegistration AS DATE) <= "#LSDateFormat(parseDate(variables.dateEnd), "yyyy-mm-dd")#"'>
		</cfif>
		<cfif variables.idProject gt 0>
			<cfset _query=_query & " and salesClientUnit.idProject=#variables.idProject#">
		</cfif>
		<cfset _query=_query & ") AS rangeLast">
		<!--- /last range --->
		<cfquery name="getListQuery" datasource="#application.datasource#">
			SELECT 
				#_query#
		</cfquery>
		<cfreturn getListQuery>
	</cffunction>

	<cffunction name="createChartStyleOptions" access="public" output="true">
		<cfargument name="selected" required="yes" type="string" default="pie">
		<cfset var list="Pie,Bar,Curve,Line,Scatter,Step,Area">
		<cfoutput><select name="#getFormPrefix()#chartStyle" id="#getFormPrefix()#chartStyle"></cfoutput>
		<cfloop list="#list#" index="idx">
			<cfoutput><option value="#LCase(idx)#"<cfif not CompareNoCase(arguments.selected, idx)> selected</cfif>>#idx#</option></cfoutput>
		</cfloop>
		<cfoutput></select></cfoutput>
	</cffunction>
	
</cfcomponent>