public static function hasApplied($jobid) { $user = User::getCurrentUser(); $application = Application::model()->find("jobid=:jobid AND userid=:userid", array(":jobid" => $jobid, ":userid" => $user->id)); return $application != null; }
public function cascade_delete() { $id = $this->id; // delete basic info mappings $basic_info = BasicInfo::model()->findByAttributes(array('userid' => $id)); if (isset($basic_info)) { $basic_info->delete(); } // delete company info mapping $comp_info = CompanyInfo::model()->findByAttributes(array('FK_userid' => $id)); if (isset($comp_info)) { $comp_info->delete(); } // delete sms mappings $sms_mappings = SMS::model()->findAll("sender_id=:id OR receiver_id=:id ", array(':id' => $id)); foreach ($sms_mappings as $sms_mapping) { $sms_mapping->delete(); } // delete education mapping $edu_mappings = Education::model()->findAllByAttributes(array('FK_user_id' => $id)); foreach ($edu_mappings as $edu_mapping) { $edu_mapping->delete(); } // delete skills mappings $skills_mappings = StudentSkillMap::model()->findAllByAttributes(array('userid' => $id)); foreach ($skills_mappings as $skills_mapping) { $skills_mapping->delete(); } // delete application mappings $app_mappings = Application::model()->findAllByAttributes(array('userid' => $id)); foreach ($app_mappings as $app_mapping) { $app_mapping->delete(); } // delete jobs mappings $job_mappings = Job::model()->findAllByAttributes(array('FK_poster' => $id)); foreach ($job_mappings as $job_mapping) { $job_mapping->cascade_delete(); } $this->delete(); }
public function actionViewApplication($jobid, $userid) { $applicationModel = Application::model()->find("jobid=:jobid AND userid=:userid", array("jobid" => $jobid, "userid" => $userid)); $job = Job::model()->findByPk($applicationModel->jobid); $this->render('viewApplication', array('application' => $applicationModel, 'job' => $job)); }
public function cascade_delete() { $id = $this->id; // remove any skill mappings $skill_mappigns = JobSkillMap::model()->findAllByAttributes(array('jobid' => $id)); foreach ($skill_mappigns as $skill_mapping) { $skill_mapping->delete(); } // remove any applications mappings $app_mappings = Application::model()->findAllByAttributes(array('jobid' => $id)); foreach ($app_mappings as $app_mapping) { $app_mapping->delete(); } // remove any handshake mappings $hs_mappings = Handshake::model()->findAllByAttributes(array('jobid' => $id)); foreach ($hs_mappings as $hs_mapping) { $hs_mapping->delete(); } // finally remove job $this->delete(); }
public function actionDeleteJob() { $id = $_POST['id']; $modle = Job::model()->find("id=:id", array(':id' => $id)); $modle1 = JobSkillMap::model()->findAllByAttributes(array('jobid' => $id)); $modle2 = Application::model()->findAllByAttributes(array('jobid' => $id)); foreach ($modle1 as $job) { $job->delete(); } foreach ($modle2 as $job1) { $job1->delete(); } //print "<pre>"; print_r($modle->username);print "</pre>"; $modle->delete(); $this->redirect("/JobFair/index.php/home/adminhome"); }