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