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; }