public static function degreeArray()
{
$degreeObject = new Degree();
$arr = $degreeObject->model()->findAll();
$degreeArray = array();
foreach ($arr as $object) {
$degreeArray[$object->id] = $object->title;
}
return $degreeArray;
}
public function actionSearch($q)
{
$result = array();
$term = trim(addcslashes($q, '%_'));
// escape LIKE's special characters
if (!empty($term)) {
if (isset($_SESSION['uid'])) {
$param = new CDbCriteria(array('condition' => "name LIKE :match AND university_id=" . $_SESSION['uid'], 'params' => array(':match' => "%{$term}%")));
} else {
$param = new CDbCriteria(array('condition' => "name LIKE :match", 'params' => array(':match' => "%{$term}%")));
}
$cursor = Degree::model()->findAll($param);
if (!empty($cursor)) {
foreach ($cursor as $id => $value) {
$result[] = array('id' => $value['did'], 'name' => $value['name']);
}
}
}
echo json_encode($result);
Yii::app()->end();
}
public function saveDegreeGroupInfo($data, $degree_id)
{
$group = DegreeGroup::model()->findByPk($data->getProperty('id'));
if ($group == null) {
$group = new DegreeGroup();
}
$degree = new Degree();
$degree = Degree::model()->findByPk($degree_id);
$group->cid = $data->getProperty('id');
$group->name = $data->getProperty('name');
//$datetime->add(new DateInterval('PT1H'));
$group->email = $data->getProperty('email');
if (null != $data->getProperty('owner')) {
$group->owner_id = $data->getProperty('owner')->getProperty('id');
$this->saveMemberInfo($data->getProperty('owner'));
$this->saveGroupMember($data->getProperty('owner'), $data->getProperty('id'), 'Degree');
}
$group->description = $data->getProperty('description');
$group->degree_id = $degree_id;
$group->save();
}
public function setSecondLevelCategory($degree_group_id, $type)
{
if ($type) {
$degree_group = DegreeGroup::model()->findByPk($degree_group_id);
//$first_level_id = $this->setFirstLevelCategory($degree_group->city);
$first_level_id = $this->setFirstLevelCategory($degree_group->degree_id);
$degree = Degree::model()->findByPk($degree_group->degree_id);
} else {
$first_level_id = $this->setFirstLevelCategory($degree_group_id);
$degree = Degree::model()->findByPk($degree_group_id);
}
$category_id = qa_db_category_slug_to_id($first_level_id, $degree->name);
if (!isset($category_id)) {
$category_id = qa_db_category_create($first_level_id, $degree->name, $degree->name);
}
return $category_id;
}
