Example #1
0
 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;
 }
Example #2
0
 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();
 }
Example #3
0
 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));
 }
Example #4
0
 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();
 }
Example #5
0
 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");
 }