RXpharmaLAB 0){ $sql = 'SELECT * FROM leso WHERE empnomembre = "'.$nomembrececlient.'" ORDER BY nooffre DESC'; $listeOFFREScompleteCECLIENT = $db_handle->runQuery($sql); $_SESSION['listeOFFREScompleteCECLIENT'] = $listeOFFREScompleteCECLIENT; $nowcheck = time(); if(isset($listeOFFREScompleteCECLIENT)){ foreach($listeOFFREScompleteCECLIENT as $k=>$v) { if(strlen($listeOFFREScompleteCECLIENT[$k]["effaceparadmin"]) < 1){ if(strlen($listeOFFREScompleteCECLIENT[$k]["effaceparclient"]) < 1){ if($listeOFFREScompleteCECLIENT[$k]["empAPPROUVE"] !== '99'){ $ceclientoffretotale = $ceclientoffretotale+1; if($listeOFFREScompleteCECLIENT[$k]["empAPPROUVE"] == 'W'){ $ceclientenpause = $ceclientenpause +1; } if(($listeOFFREScompleteCECLIENT[$k]["empDEBUT"] < $nowcheck) && ($listeOFFREScompleteCECLIENT[$k]["empFIN"] > $nowcheck)) { $ceclientoffreencours = $ceclientoffreencours+1; $moins7jours = $nowcheck+604800; if($listeOFFREScompleteCECLIENT[$k]["empFIN"] < $moins7jours) { $ceclientecheancebientot = $ceclientecheancebientot+1; } } $ceclientoffreterminees = $ceclientoffretotale - $ceclientoffreencours; if($ceclientoffreterminees < 0){ $ceclientoffreterminees = 0; } }}} } } } $_SESSION['ceclientoffreencours'] = $ceclientoffreencours; $_SESSION['ceclientoffreterminees'] = $ceclientoffreterminees; $_SESSION['ceclientecheancebientot'] = $ceclientecheancebientot; $_SESSION['ceclientenpause'] = $ceclientenpause; $_SESSION['jaiunforfait'] = ''; $totalforfait = 0; if($ceclientoffretotale > 0){ $_SESSION['jaidesoffres'] = $ceclientoffretotale; } else { $_SESSION['jaidesoffres'] = 0; /*** si le client n'a pas d'offre, vérifier si il a un forfait de publication disponible mais pas encore utilisé ***/ $sql = 'SELECT * FROM forfaitmulti WHERE nomembre = "'.$nomembrececlient.'" ORDER BY NOSEQ DESC'; $listeForfaitCECLIENT = $db_handle->runQuery($sql); $_SESSION['listeForfaitCECLIENT'] = $listeForfaitCECLIENT; if(isset($listeForfaitCECLIENT)){ foreach($listeForfaitCECLIENT as $k=>$v) { $totalforfait = 1+$totalforfait; } if($totalforfait > 0){ $_SESSION['jaiunforfait'] = 'oui'; } } } /** FIN verification si membre en cours a des offres d'emploi **/ ?>

ABBCMBNBNLNSNTNUONPEQCSKYT Across Canada
QC NB ON Across Canada MORE +
Post A Job Offer
EN FR

We use cookies to enhance your experience on our website. By accepting them, you agree to the collection of information that enriches and personalizes your visit. If you choose not to accept them or to withdraw your consent later, this may limit some features of our site.

For more details, please see our privacy policy.

Accept All
Accept Essential Cookies Only

Your perfect candidate is just a click away, get noticed!

Pharma jobs made easy - 26K+ members and counting. Get noticed today!

Post a job offer +