<cfcomponent extends="components.common.formObject">
	<cfset variables.idProject=0>
	<cfset variables.project="">
	<cfset variables.idProvider=0>
	<cfset variables.provider="">
	<cfset module.list.orderBy="project">
	
	<cffunction name="init" access="public" output="false">
		<cfset variables.idProject=0>
		<cfset variables.project="">
		<cfset variables.idProvider=0>
		<cfset variables.provider="">
	</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="remote" output="false">
		<cfargument name="idProject" type="numeric" required="yes" default="0">
		<cfset variables.idProject=arguments.idProject>
	</cffunction>

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

	<cffunction name="getProject" access="remote" returntype="components.corporate.project" output="false">
		<cfif not IsObject("variables.project")><cfset variables.project=CreateObject("component", "components.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", "components.corporate.project")>
			<cfset variables.project.setIdProject(variables.idProject)>
			<cfset variables.project.get()>
		</cfif>
		<cfreturn variables.project>
	</cffunction>

	<cffunction name="setIdProvider" access="remote" output="false">
		<cfargument name="idProvider" type="numeric" required="yes" default="0">
		<cfset variables.idProvider=arguments.idProvider>
	</cffunction>

	<cffunction name="getIdProvider" access="remote" returntype="numeric" output="false">
		<cfreturn variables.idProvider>
	</cffunction>
	
	<cffunction name="getProvider" access="remote" returntype="components.corporate.provider" output="false">
		<cfif not IsObject("variables.provider")><cfset variables.provider=CreateObject("component", "components.corporate.provider")></cfif>
		<cfif (Compare(module.form.pageAction, "add") and not variables.provider.isRetrievedFromDB()) or variables.provider.getIdProvider() neq variables.idProvider>
			<cfset variables.provider=CreateObject("component", "components.corporate.provider")>
			<cfset variables.provider.setIdProvider(variables.idProvider)>
			<cfset variables.provider.get()>
		</cfif>
		<cfreturn variables.provider>
	</cffunction>

	<cffunction name="setVariablesFromQuery" access="private" output="false">
		<cfargument name="getQuery" type="query" required="yes">
		<cfif getQuery.recordcount gt 0>
			<cfset variables.idProject=getQuery.idProject>
			<cfset variables.idProvider=getQuery.idProvider>
		</cfif>
	</cffunction>
	
	<cffunction name="get" access="remote" output="false">
		<cfquery name="getQuery" datasource="#application.datasource#">
			SELECT 
				#getQueryString()#
			WHERE
				projectProvider.idProject=<cfqueryparam value="#variables.idProject#" cfsqltype="cf_sql_integer">
				AND projectProvider.idProvider=<cfqueryparam value="#variables.idProvider#" cfsqltype="cf_sql_integer">
		</cfquery>
		<cfif getQuery.recordcount gt 0>
			<cfset setVariablesFromQuery(getQuery)>
		</cfif>
		<!--- ADDED: set that object was retrieved from DB --->
		<cfset module.retrievedFromDB=true>
	</cffunction>

	<cffunction name="getList" access="remote" output="false" returntype="query">
		<cfargument name="orderBy" required="no" type="string" default="">
		<cfquery name="getListQuery" datasource="#application.datasource#">
			SELECT 
				#getQueryString()#
			WHERE 
				1=1
				<cfif variables.idProject gt 0>
				AND projectProvider.idProject=<cfqueryparam value="#variables.idProject#" cfsqltype="cf_sql_integer">
				</cfif>
				<cfif variables.idProvider gt 0>
				AND projectProvider.idProvider=<cfqueryparam value="#variables.idProvider#" cfsqltype="cf_sql_integer">
				</cfif>
			ORDER BY <cfif Len(arguments.orderBy)>#URLDecode(arguments.orderBy)#<cfelse>#URLDecode(module.list.orderBy)#</cfif>
		</cfquery>
		<cfreturn getListQuery>
	</cffunction>
	
	<cffunction name="getQueryString" access="private" output="false" returntype="string">
		<cfset var result="
				projectProvider.idProject, project.name AS project,
				projectProvider.idProvider, provider.name as provider
			FROM 
				projectProvider 
			LEFT JOIN project ON projectProvider.idProject=project.idProject
			LEFT JOIN provider ON projectProvider.idProvider=provider.idProvider
			">
		<cfreturn result>
	</cffunction>

	<cffunction name="create" access="remote" returntype="struct" output="false">
		<cfset var result=StructNew()>
		<cfset result.id=0>
		<cfset result.message="">
		<!--- check parameters --->
		<cftry>
			<cfquery name="createQuery" datasource="#application.datasource#">
				INSERT IGNORE INTO projectProvider
					(
					idProject, 
					idProvider
					) 
				VALUES 
					(
					<cfqueryparam value="#variables.idProject#" cfsqltype="cf_sql_integer">, 
					<cfqueryparam value="#variables.idProvider#" cfsqltype="cf_sql_integer">
					)
			</cfquery>
			<cfset result.id=variables.idProject>
			<!--- catch any error --->
			<cfcatch type="any">
				<cfset result.id=-1>
				<cfset result.message="Error [projectProvider.create()]: " & cfcatch.Message & "<br>Details: " & cfcatch.Detail>
			</cfcatch>
		</cftry>
		<cfreturn result>
	</cffunction>
	
	<cffunction name="update" access="remote" returntype="struct" output="false">
		<cfreturn create()>
	</cffunction>

	<cffunction name="delete" access="remote" returntype="struct" output="false">
		<cfset var result=StructNew()>
		<cfset result.id=0>
		<cfset result.message="">
		<!--- check parameters --->
		<cftry>
			<cfquery name="deleteQuery" datasource="#application.datasource#">
				DELETE FROM projectProvider
				WHERE 
					idProject=<cfqueryparam value="#variables.idProject#" cfsqltype="cf_sql_integer">
					AND idProvider=<cfqueryparam value="#variables.idProvider#" cfsqltype="cf_sql_integer">
			</cfquery>
			<cfset result.id=0>
			<cfset init()>
			<!--- catch any error --->
			<cfcatch type="any">
				<cfset result.id=-1>
				<cfset result.message="Error [projectProvider.delete()]: " & cfcatch.Message & "<br>Details: " & cfcatch.Detail>
			</cfcatch>
		</cftry>
		<cfreturn result>
	</cffunction>
	
	<cffunction name="createProjectOptions" access="public" returntype="numeric" output="true">
		<cfargument name="selected" required="yes" type="numeric" default="0">
		<cfset var list=getList("project.name")>
		<cfset var result=0>
		<cfif list.idProject gt 0><cfset result=list.idProject></cfif>
		<cfloop query="list">
			<cfif Len(list.idProject)>
				<cfif list.idProject eq arguments.selected><cfset _selected=" selected"><cfset result=list.idProject><cfelse><cfset _selected=""></cfif>
				<cfoutput><option value="#list.idProject#"#_selected#>#list.project#</option></cfoutput>
			</cfif>
		</cfloop>
		<cfreturn result>
	</cffunction>

	<cffunction name="createProviderOptions" access="public" returntype="numeric" output="true">
		<cfargument name="selected" required="yes" type="numeric" default="0">
		<cfset var list=getList("provider.name")>
		<cfset var result=0>
		<cfif list.idProvider gt 0><cfset result=list.idProvider></cfif>
		<cfloop query="list">
			<cfif Len(list.idProvider)>
				<cfif list.idProvider eq arguments.selected><cfset _selected=" selected"><cfset result=list.idProvider><cfelse><cfset _selected=""></cfif>
				<cfoutput><option value="#list.idProvider#"#_selected#>#list.provider#</option></cfoutput>
			</cfif>
		</cfloop>
		<cfreturn result>
	</cffunction>
</cfcomponent>