Add function to saveResume

Tartuffe
Topic Author
Offline
Junior Boarder

14 years 5 months ago - 14 years 5 months ago #1273 by Tartuffe

Replied by Tartuffe on topic Add function to saveResume

Hi !
I\'m damned, it doesn\'t work on line !!!
I have a sql error with my first query :

$db =&$this->getDBO();
		$uid = &JRequest::getString(\'uid\',\'none\');
		$resumequery = \"SELECT * FROM \".$db->nameQuote(\'#__js_job_resume\').\" WHERE uid = \".$uid.\"\";
		$db->setQuery( $resumequery );
		$minicv = $db->loadObject() or die(\'Erreur SQL minicv <br>\'.mysql_error());

I really don\'t understand !!!!!!
Thanks for your help

Last edit: 14 years 5 months ago by Tartuffe.

Tartuffe
Topic Author
Offline
Junior Boarder

14 years 5 months ago - 14 years 5 months ago #1274 by Tartuffe

Replied by Tartuffe on topic Add function to saveResume

Is that because my php config on server is OFF for define_syslog_variables?
Could you really help me quickly, productive site should be on line as soon as possible.

Best regards
Matine44

PS : It happens where I add the first resume.
What Should I add to
function canAddNewResume($uid) at line 372 ?

Last edit: 14 years 5 months ago by Tartuffe.

Tartuffe
Topic Author
Offline
Junior Boarder

14 years 5 months ago - 14 years 5 months ago #1281 by Tartuffe

Replied by Tartuffe on topic Add function to saveResume

Hi Admin,
I\'m already try to find a solution and i have a question :
Is that in function storeNewinJSJobs() I should add code ?
I have no problem to add resume if jobseeker already had a resume, but if it\'s a first resume\'s creation, I can\'t do it.

PLEASE I really need your help !!

Thanks
Best regards
Matine44

Last edit: 14 years 5 months ago by Tartuffe.

Tartuffe
Topic Author
Offline
Junior Boarder

14 years 5 months ago - 14 years 5 months ago #1288 by Tartuffe

Replied by Tartuffe on topic Add function to saveResume

Ok, I found problem.
I just move my code in /models/jsjobs.php in function storeResume() here:

After :

if (!$row->store())
		{
			$this->setError($this->_db->getErrorMsg());
			return false;
		}

Before :

$returnvalue = $this->uploadResume($row->id);
		$returnvalue = $this->uploadPhoto($row->id);
		}

Ok you can close this post !

Last edit: 14 years 5 months ago by Tartuffe.

Tartuffe
Topic Author
Offline
Junior Boarder

14 years 4 months ago #1347 by Tartuffe

Replied by Tartuffe on topic Add function to saveResume

Hi, I have a nex problem !
When a user update his resume it duplicate it in my new table jos_js_jos_minicv.
So I tried this code, always in function storeResume(), but it doesn't work.

//verification si le cv existe deja dans la table jos_js_job_minicv
$resultat_minicv = "SELECT * FROM #__js_job_minicv WHERE id_candidat='$id_candidat' ";
$resultat_minicv = "SELECT COUNT(fabrik_internal_id) FROM ".$db->nameQuote('#__js_job_minicv')." WHERE id_candidat = ".$id_candidat;
$db->setQuery($resultat_minicv);
$total_minicv = $db->loadResult();
	echo $total_minicv;
		
si cv vide insertion des informations
	if ($total_minicv > 0){
//mise a jour de la ligne dans la table jos_js_job_minicv
//suppression du CV
$supprimer_minicv = "DELETE FROM ".$db->nameQuote('#__js_job_minicv')." WHERE id_candidat=$id_candidat AND profil_candidat=$profil_candidat ";
$db->setQuery($supprimer_minicv);			
}else{
//insertion des donnees dans la table jos_js_job_minicv

Could you help me please ?
Best regards

Time to create page: 0.085 seconds