public function getUniversityList() { // $u1[]='Select university'; // $u2[0]='Select university'; $u2 = Chtml::listData(University::model()->findAll(), 'uid', 'uname'); //$u=array_merge($u1,$u2); return $u2; }
public function actionSetSessionVar() { if (isset($_POST['uid'])) { $university = new University(); if (!is_numeric($_POST['uid'])) { $max_id = University::model()->find(array('order' => 'did DESC')); $university->name = $_POST['uid']; $university->did = $max_id->did + 1; $university->validate(); $university->save(); } else { $university->did = $_POST['uid']; } $_SESSION['uid'] = $university->did; } if (isset($_POST['did'])) { $degree = new Degree(); if (!is_numeric($_POST['did'])) { $max_id = Degree::model()->find(array('order' => 'did DESC')); $degree->name = $_POST['did']; $degree->did = $max_id->did + 1; $degree->university_id = $_SESSION['uid']; $degree->validate(); $degree->save(); } else { $degree->did = $_POST['did']; } $_SESSION['did'] = $degree->did; } }
/** * @var string the default layout for the views. Defaults to '//layouts/column2', meaning * using two-column layout. See 'protected/views/layouts/column2.php'. */ public function loadUniversity($uid) { if ($this->_university === null) { $this->_university = University::model()->findbyPk($uid); if ($this->_university === null) { throw new CHttpException(404, 'The requested university does not exist.'); } } return $this->_university; }
public function actionSearch($q) { $result = array(); $term = trim(addcslashes($q, '%_')); // escape LIKE's special characters if (!empty($term)) { $param = new CDbCriteria(array('condition' => "name LIKE :match", 'params' => array(':match' => "%{$term}%"))); $cursor = University::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(); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = University::model()->findByPk((int) $id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function setFirstLevelCategory($degree_id) { $degree = Degree::model()->findByPk($degree_id); $university = University::model()->findByPk($degree->university_id); $category_id = qa_db_category_slug_to_id(null, $university->name); if (!isset($category_id)) { $category_id = qa_db_category_create(null, $university->name, $university->name); } return $category_id; }
public function getUniversityName() { $uni = University::model()->findByPk($this->university_id); if ($uni == NULL) { return "FIU"; } return $uni->name; }
function getMenteColumns($model) { //get or initialize the current column order $columnArrayOrder = getColumnArrayOrder(); //only if make a cache of the columns if needed if (isset($_GET['sourceColumn']) && isset($_GET['destinationColumn'])) { $source = $_GET['sourceColumn']; $destination = $_GET['destinationColumn']; $sourceIndex = $source[0]; $destIndex = $destination[0]; ReportUtils::moveColumnsByIndex($sourceIndex, $destIndex, $columnArrayOrder); Yii::app()->session['MenteeColumnOrder'] = $columnArrayOrder; } //Now render the columns $columns = array(); for ($i = 0; $i < count($columnArrayOrder); $i++) { switch ($columnArrayOrder[$i]) { case MenteeColumns::userId: $menteeUserID = array('name' => 'UserID', 'header' => 'Mentee User ID', 'filter' => CHtml::activeNumberField($model, 'UserID'), 'headerHtmlOptions' => array('width' => '75')); $columns[] = $menteeUserID; break; case MenteeColumns::menteeName: $menteeName = array('name' => 'Name', 'header' => 'Mentee Name', 'filter' => CHtml::activeTextField($model, 'Name'), 'headerHtmlOptions' => array('width' => '200')); $columns[] = $menteeName; break; case MenteeColumns::menteeEmail: $menteeEmail = array('name' => 'Email', 'header' => 'Mentee Email', 'filter' => CHtml::activeEmailField($model, 'Email'), 'headerHtmlOptions' => array('width' => '150')); $columns[] = $menteeEmail; break; case MenteeColumns::menteeUserName: $menteeUserName = array('name' => 'UserName', 'header' => 'Mentee User Name', 'filter' => CHtml::activeTextField($model, 'UserName'), 'headerHtmlOptions' => array('width' => '100')); $columns[] = $menteeUserName; break; case MenteeColumns::menteeDisabled: $menteeDisabled = array('name' => 'Disabled', 'header' => 'Mentee Disabled', 'value' => 'ReportUtils::getZeroOneToYesNo($data->Disabled)', 'filter' => array('1' => 'Yes', '0' => 'No'), 'headerHtmlOptions' => array('width' => '100')); $columns[] = $menteeDisabled; break; case MenteeColumns::menteeUniversityName: $universityName = array('name' => 'UniversityName', 'header' => 'Mentee University', 'filter' => CHtml::activeDropDownList($model, 'UniversityID', CHtml::listData(University::model()->findAll(), 'id', 'name'), array('empty' => ' ')), 'headerHtmlOptions' => array('width' => '220')); $columns[] = $universityName; break; case MenteeColumns::menteePersonalMentorID: $PersonalMentorID = array('name' => 'PersonalMentorID', 'header' => 'Personal Mentor (ID)', 'filter' => CHtml::activeNumberField($model, 'PersonalMentorID'), 'headerHtmlOptions' => array('width' => '100')); $columns[] = $PersonalMentorID; break; case MenteeColumns::menteePersonalMentorName: $PersonalMentorName = array('name' => 'PersonalMentorName', 'header' => 'Personal Mentor (Name)', 'filter' => CHtml::activeTextField($model, 'PersonalMentorName'), 'headerHtmlOptions' => array('width' => '150')); $columns[] = $PersonalMentorName; break; case MenteeColumns::menteePersonalMentorEmail: $PersonalMentorEmail = array('name' => 'PersonalMentorEmail', 'header' => 'Personal Mentor (Email)', 'filter' => CHtml::activeEmailField($model, 'PersonalMentorEmail'), 'headerHtmlOptions' => array('width' => '150')); $columns[] = $PersonalMentorEmail; break; case MenteeColumns::menteePersonalMentorDisabled: $PersonalMentorDisabled = array('name' => 'PersonalMentorDisabled', 'header' => 'Personal Mentor (Disabled)', 'value' => 'ReportUtils::getZeroOneToYesNo($data->PersonalMentorDisabled)', 'filter' => array('1' => 'Yes', '0' => 'No'), 'headerHtmlOptions' => array('width' => '150')); $columns[] = $PersonalMentorDisabled; break; case MenteeColumns::menteeProjectTitle: $menteeProjectTitle = array('name' => 'menteeProjectTitle', 'header' => 'Project Title', 'filter' => CHtml::activeDropDownList($model, 'menteeProjectID', CHtml::listData(Project::model()->findAll(), 'id', 'title'), array('empty' => ' ')), 'headerHtmlOptions' => array('width' => '300')); $columns[] = $menteeProjectTitle; break; case MenteeColumns::menteeProjectStartDate: $menteeProjectTitle = array('name' => 'menteeProjectStartDate', 'header' => 'Project Start Date', 'value' => 'ReportUtils::dateformat($data->menteeProjectStartDate)', 'filter' => CHtml::activeDateField($model, 'menteeProjectStartDate'), 'headerHtmlOptions' => array('width' => '160')); $columns[] = $menteeProjectTitle; break; case MenteeColumns::menteeProjectDueDate: $menteeProjectDueDate = array('name' => 'menteeProjectDueDate', 'header' => 'Project Due Date', 'value' => 'ReportUtils::dateformat($data->menteeProjectDueDate)', 'filter' => CHtml::activeDateField($model, 'menteeProjectDueDate'), 'headerHtmlOptions' => array('width' => '160')); $columns[] = $menteeProjectDueDate; break; case MenteeColumns::menteeProjectCustomerName: $menteeProjectCustomerName = array('name' => 'menteeProjectCustomerName', 'header' => 'Project Customer', 'filter' => CHtml::activeTextField($model, 'menteeProjectCustomerName'), 'headerHtmlOptions' => array('width' => '150')); $columns[] = $menteeProjectCustomerName; break; } } return $columns; }
public static function universityById($id) { $uni = University::model()->findBySql("SELECT * from university WHERE id = " . $id); return $uni->name; }
public function actionPersonal() { $model = new ApplicationPersonalMentor(); $students = new User(); $unis = array(); if (Yii::app()->getRequest()->isPostRequest) { // on application submit $user = User::model()->getCurrentUser(); // pull application data and save $model->attributes = $_POST['ApplicationPersonalMentor']; $model->status = 'Admin'; $model->user_id = $user->id; $model->date_created = new CDbExpression('NOW()'); if (!isset($model->university_id) || $model->university_id == 0) { $model->university_id = NULL; } $model->save(false); // save user picks $mypicks = $_POST['picks']; $mypicks = explode(',', $mypicks); foreach ($mypicks as $pick) { if ($pick > 0) { $dbpick = new ApplicationPersonalMentorPick(); $dbpick->app_id = $model->id; $dbpick->user_id = $pick; $dbpick->approval_status = 'Proposed by Mentor'; $dbpick->save(false); } } // save system picks $systempicks = $_POST['systempicks']; $systempicks = explode(',', $systempicks); foreach ($systempicks as $pick) { if ($pick > 0) { $dbpick = new ApplicationPersonalMentorPick(); $dbpick->app_id = $model->id; $dbpick->user_id = $pick; $dbpick->approval_status = 'Proposed by System'; $dbpick->save(false); } } // redirect to application portal $this->redirect("/coplat/index.php/application/portal"); } else { // on initial load $students->unsetAttributes(); $students->isMentee = 1; $student = User::model()->returnUsersForApp($students->searchNoPagination()); $universities = University::model()->getUniversities(); $unis[0] = 'Any'; foreach ($universities as $uni) { $unis[$uni->id] = $uni->name; } $model->system_pick_amount = 0; } $error = ''; $this->render('personal', array('model' => $model, 'user' => $students, 'universities' => $unis, 'students' => $student, 'error' => $error)); }