1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
|
<cffunction name="upload_and_insert_cv_02" access="public" returntype="any">
<cfargument name="path_cv" type="string" required="yes" >
<!---<cfargument name="lng_resized_in_px" type="numeric" required="no" default=800>
<cfargument name="lng_thumbnail_in_px" type="numeric" required="no" default=200>--->
<cfargument name="file_field_name" type="string" required="yes">
<cfargument name="user_id" type="numeric" required="yes" >
<cfargument name="cv_id" type="numeric" required="yes" >
<cfargument name="table" type="string" required="yes" >
<cfargument name="description" type="string" required="no" default="">
<cfargument name="datasource" type="string" required="yes">
<cfargument name="filo_id" type="numeric" required="yes">
<cfargument name="cv_jobs_id" type="numeric" required="yes">
<!---===================== UPLOAD =====================--->
<cfoutput>
<!--- Get the absolute path from this file --->
<cfset LOCAL.rootPathThisPage = "#GetDirectoryFromPath(GetBaseTemplatePath())#">
<cfset LOCAL.rootPathcv = "#LOCAL.rootPathThisPage##ARGUMENTS.path_cv#">
<!--- Upload from form filefield --->
<cffile action="upload" destination="#LOCAL.rootPathcv#" nameConflict="overwrite" fileField="#ARGUMENTS.file_field_name#" >
</cfoutput>
<!---===================== END UPLOAD =====================--->
<!---===================== INSERT =====================--->
<cfquery datasource="#ARGUMENTS.datasource#">
INSERT
INTO #ARGUMENTS.table#
(
CV_id
,CV_FILO_id
,CV_description
, CV_JOBS_ID
)
VALUES
(
<!--- id --->
<cfif IsDefined('ARGUMENTS.cv_id') AND #ARGUMENTS.cv_id# NEQ "">
<cfqueryparam value="#ARGUMENTS.cv_id#" cfsqltype="cf_sql_integer" >
<cfelse>
NULL
</cfif>
<!--- CV_FILO_id --->
<cfif IsDefined('ARGUMENTS.filo_id') AND #ARGUMENTS.filo_id# NEQ "">
,<cfqueryparam value="#ARGUMENTS.filo_id#" cfsqltype="cf_sql_integer" >
<cfelse>
,NULL
</cfif>
<!--- FONT_description --->
<cfif IsDefined('ARGUMENTS.description') AND #ARGUMENTS.description# NEQ "">
,<cfqueryparam value="#ARGUMENTS.description#" cfsqltype="cf_sql_longvarchar" >
<cfelse>
,NULL
</cfif>
<!--- cv_jobs_id --->
<cfif IsDefined('form.jobsId') AND #form.jobsId# NEQ "">
,<cfqueryparam value="#form.jobsId#" cfsqltype="cf_sql_integer" >
<cfelse>
,NULL
</cfif>
);
</cfquery>
<cfzip action="zip"
file="#ExpandPath('cv/jobs_#form.jobsId#.zip')#"
source="#form.cv#"
/> |
Partager