</td>
<td><?php
echo Yii::app()->dateFormatter->format('MM/dd/yyyy', $jobs[$i]->post_date);
?>
</td>
<!-- <td>--><?php
//echo Yii::app()->dateFormatter->format('MM/dd/yyyy', $jobs[$i]->deadline);
?>
<!--</td>-->
<td><?php
echo $jobs[$i]->compensation;
?>
</td>
<td>
<?php
$temp = JobSkillMap::model()->findAllByAttributes(array('jobid' => $jobs[$i]->id));
foreach ($temp as $one) {
$cur_skill = Skillset::model()->findByAttributes(array('id' => $one->skillid))->name;
$this->widget('bootstrap.widgets.TbLabel', array('type' => 'default', 'label' => strtolower($cur_skill)));
echo ' ';
}
if (count($temp) <= 0) {
$this->widget('bootstrap.widgets.TbLabel', array('type' => 'inverse', 'label' => 'N/A'));
}
?>
</td>
<td><?php
echo "CareerPath";
?>
</td>
</tr>
</div>
<div id="mostwanted">
<div class="titlebox">MOST WANTED SKILLS</div><br><br>
<ul>
<?php
foreach ($mostwanted as $mmm) {
?>
<li class="mostwantedskills"><?php
echo $mmm->name;
$thecount = 0;
/*$criteria1= new CDbCriteria();
$criteria1=array(
'select'=>'count(*) as count',
'condition'=>" skillid=".$mmm->id."",
);*/
$sk = JobSkillMap::model()->findAllByAttributes(array('skillid' => $mmm->id));
foreach ($sk as $sk2) {
$thejob = Job::model()->findByPk($sk2->jobid);
if ($thejob->active) {
$thecount++;
}
}
?>
<a class="mostwantedtext" href="/JobFair/index.php/home/Search2/?key=<?php
echo $mmm->name;
?>
"><?php
echo " - [ " . $thecount . " ] Jobs";
?>
</a>
</li>
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 actionConsolidate()
{
$model = new Skillset('search');
$model->unsetAttributes();
// clear any default values
$error = '';
if (isset($_GET['Skillset'])) {
$model->attributes = $_GET['Skillset'];
}
if (isset($_POST['skill_one']) && isset($_POST['skill_two'])) {
// make sure skill one exists on database
$skill_one = Skillset::model()->find("name=:name", array(':name' => $_POST['skill_one']));
if (!isset($skill_one)) {
$error = "Skill A not found!";
} else {
// make sure skill two exists on database
$skill_two = Skillset::model()->find("name=:name", array(':name' => $_POST['skill_two']));
if (!isset($skill_two)) {
$error = "Skill B not found!";
} else {
// make sure both skills are not the same one
if (strcmp($skill_one->name, $skill_two->name) != 0) {
// merge skill one to skill two (skill two remains)
$jobskill_mappings = JobSkillMap::model()->findAll("skillid=:skillid", array(':skillid' => $skill_one->id));
foreach ($jobskill_mappings as $jobskill_mapping) {
$jobskill_mapping->skillid = $skill_two->id;
$jobskill_mapping->save(false);
}
$studentskill_mappings = StudentSkillMap::model()->findAll("skillid=:skillid", array(':skillid' => $skill_one->id));
foreach ($studentskill_mappings as $studentskill_mapping) {
$studentskill_mapping->skillid = $skill_two->id;
$studentskill_mapping->save(false);
}
$skill_one->delete();
$this->redirect(array('admin'));
} else {
$error = "Skill A and Skill B cannot be the same!";
}
}
}
}
$this->render('consolidate', array('model' => $model, 'error' => $error, 'skill1' => isset($_POST['skill_one']) ? $_POST['skill_one'] : '', 'skill2' => isset($_POST['skill_two']) ? $_POST['skill_two'] : ''));
}
public function actionMergeSkills()
{
$skillname1 = $_POST['skill1'];
$skillname2 = $_POST['skill2'];
$skill1 = Skillset::model()->find("name=:name", array(":name" => $skillname1));
$skill2 = Skillset::model()->find("name=:name", array(":name" => $skillname2));
$jobskills = JobSkillMap::model()->findAll("skillid=:skillid", array(":skillid" => $skill2->id));
$studentskills = StudentSkillMap::model()->findAll("skillid=:skillid", array(":skillid" => $skill2->id));
foreach ($jobskills as $skill) {
if (JobSkillMap::model()->find("skillid=:skillid", array(":skillid" => $skill1->id)) == null) {
$skill->skillid = $skill1->id;
$skill->save();
} else {
$skill->delete();
}
}
foreach ($studentskills as $skill) {
if (StudentSkillMap::model()->find("skillid=:skillid", array(":skillid" => $skill1->id)) == null) {
$skill->skillid = $skill1->id;
$skill->save();
} else {
$skill->delete();
}
}
$skill2->delete();
$this->redirect("/JobFair/index.php/home/adminhome");
}
