Employers can get Resumes via Email

8 years 8 months ago #2353 by open
Many thanks,
But I am not quite good in PHP codes, could you guide me changing what to what?
8 years 8 months ago #2354 by Super User
Hi,

Replace this code
$jobquery = "SELECT users.name, users.email, job.title, job.sendemail FROM ".$db->nameQuote('#__users') ."AS users, ".$db->nameQuote('#__js_job_jobs') ." AS job  
		WHERE users.id = job.uid  AND job.id = ".$jobid;

With
$jobquery = "SELECT company.contactname AS name, company.contactemail AS email, job.title, job.sendemail 
			FROM ".$db->nameQuote('#__js_job_companies') ."AS comapney
			JOIN ".$db->nameQuote('#__js_job_jobs') ." AS job ON job.companyid = company.id  
			WHERE job.id = ".$jobid;

Best regards,

Ahmad Bilal
8 years 8 months ago #2356 by open
I know that I bothered you, but it didn't work. any idea?
8 years 8 months ago #2358 by Super User
Hi,

Please open a ticket.

Best regards,

Ahmad Bilal
8 years 5 months ago #2575 by tammys gordon
Hi Bilal,


Thanks for your Information, it helped me too. Once again thanks for your valuable info.
8 years 2 months ago #2657 by Jeffrey C Schork
When changing the code in jsjobs.php, is this "
function sendMail($jobid, $uid,$resumeid)" the new code or original?
Time to create page: 0.143 seconds

Please publish modules in offcanvas position.