public function getAllAcademicDegreeFromCollege(College $college)
{
$qb = $this->createQueryBuilder('t');
$query = $qb->leftJoin('t.academic_degrees', 'c')->where($qb->expr()->eq('c.id', ':id'));
$query->setParameter('id', $college->getId());
return $query;
}
public function showSpecificCollege()
{
$collegeIDInput = Input::get('college-dropdown');
$college = College::find($collegeIDInput);
$collegedepartments = $college->departments()->whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38));
$q->where('degreelevel', 'U');
})->get();
//ave students per year and ave difference
$programids = $college->programs()->whereNotIn('programid', array(62, 66, 38))->where('degreelevel', 'U')->lists('programid');
//To get batches of program whithin 2000-2009
$yearsArray = Studentterm::whereIn('programid', $programids)->where('year', '>', 1999)->where('year', '<', 2014)->groupBy('year')->orderBy('year', 'asc')->lists('year');
$yearlyStudentAverage = [];
$collegeDepartmentsAverage = [];
foreach ($yearsArray as $yearData) {
$aveStudents = round($college->getYearlyAveStudents($yearData), 2);
if ($aveStudents > 1) {
$yearlyStudentAverage[$yearData] = $aveStudents;
}
}
foreach ($collegedepartments as $collegedepartment) {
$collegeDepartmentsAverage[$collegedepartment->unitname] = round($collegedepartment->getAveStudents(), 2);
}
$aveAttrition = $college->getAveAttrition();
$aveShiftRate = $college->getAveShiftRate();
$aveYearsBeforeDropout = $college->getAveYearsBeforeDropout();
$aveYearsBeforeShifting = $college->getAveYearsBeforeShifting();
$batchAttrition = $college->getBatchAttrition();
$departmentsAttrition = $college->getDepartmentsAveBatchAttrition();
$gradeCount = $college->getGradeCount();
$shiftGradeCount = $college->getShiftGradeCount();
$stbracketCount = $college->getSTBracketCount();
$shiftBracketCount = $college->getShiftSTBracketCount();
return View::make('college.college-specific', ['college' => $college, 'yearlyStudentAverage' => $yearlyStudentAverage, 'collegedepartments' => $collegedepartments, 'collegeDepartmentsAverage' => $collegeDepartmentsAverage, 'aveAttrition' => $aveAttrition, 'batchAttrition' => $batchAttrition, 'aveShiftRate' => $aveShiftRate, 'aveYearsBeforeDropout' => $aveYearsBeforeDropout, 'aveYearsBeforeShifting' => $aveYearsBeforeShifting, 'departmentsAttrition' => $departmentsAttrition, 'gradeCount' => $gradeCount, 'shiftGradeCount' => $shiftGradeCount, 'stbracketCount' => $stbracketCount, 'shiftBracketCount' => $shiftBracketCount]);
}
public function showModal()
{
$id = Input::get('collegeId');
$college = $this->college->getCollegeById($id);
return response()->json(['collegeId' => $college->id, 'collegeName' => $college->name, 'collegeDetail' => $college->detail, 'collegeImage' => $college->image, 'collegeSource' => $college->source, 'collegeStreet1' => $college->street1, 'collegeStreet2' => $college->street2, 'collegeCity' => $college->city, 'collegeState' => $college->state, 'collegePincode' => $college->pincode, 'token' => csrf_token(), 'action' => url('favourite/store')]);
// return view('college.college_modal')->with(compact('college'));
}
public static function getProgramsByCollege($college_id)
{
$college = College::model()->cache(Yii::app()->params['dbCacheInterval'])->findByPk($college_id);
if ($college != null) {
return $college->programs;
} else {
return array();
}
}
public function __construct($collegeId)
{
$this->thread = new Thread();
$this->postItem = new PostItem();
$this->postItem->post_type_id = 7;
// type Thread
$this->thread->college_id = $collegeId;
$this->collegeName = College::model()->findByPk($collegeId)->college_name;
}
public function listAction()
{
if ($this->request->isAjax()) {
$validate = new \Validate();
$id = (int) $validate->getPost('id');
if (!$id) {
$this->end(404);
}
$this->end((new \College())->delCollege($id, $this->session->get('id')));
}
//当前页码
$page_id = (int) $this->request->getQuery('page');
$page_id = $page_id < 1 ? 1 : $page_id;
//省份code
$pro_code = (int) $this->request->getQuery('pro_code');
//城市code
$city_code = (int) $this->request->getQuery('city_code');
//性质
$col_type = (int) $this->request->getQuery('col_type');
//关键字
$keyword = preg_replace('/[^\\da-z\\x{4e00}-\\x{9fa5}]/iu', '', mb_substr($this->request->getQuery('keyword'), 0, 10, 'utf-8'));
//关键字长度小于10，并且只能是字符数字中文
//每页显示条数
$limit = 20;
//省市区县
$site = new \Site();
$provinces = $site->getProvince();
//省
$cities = $site->getCity($pro_code);
//城市
//查询数据
$college = new \College();
$result = $college->getList($page_id, $limit, $pro_code, $city_code, $col_type, $keyword);
//数据
$page_html = $this->pageHtml($result['page']);
//分页html
//加载js
$this->assets->addJs('backend/mt-js/college-list.js');
$this->view->setVars(['pro_code' => $pro_code, 'city_code' => $city_code, 'col_type' => $col_type, 'keyword' => $keyword, 'provinces' => $provinces, 'cities' => $cities, 'list' => $result['list'], 'page_html' => $page_html]);
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$batches = [2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009];
$allStudents = [];
$colleges = College::select('unitid')->get();
foreach ($colleges as $college) {
$collegeid = $college->unitid;
foreach ($batches as $batch) {
$allStudents[$batch] = Studentterm::getBatchStudentsCollege($batch * 100000, $collegeid);
}
$this->seedEmployment($batches, $allStudents, $collegeid);
$this->seedGrades($batches, $allStudents, $collegeid);
$this->seedStbracket($batches, $allStudents, $collegeid);
$this->seedRegion($batches, $allStudents, $collegeid);
}
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('correlations', function (Blueprint $table) {
//
});
$batches = [2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009];
$allStudents = [];
$colleges = College::select('unitid')->get();
foreach ($colleges as $college) {
$collegeid = $college->unitid;
foreach ($batches as $batch) {
$allStudents[$batch] = Studentterm::getBatchStudentsCollege($batch * 100000, $collegeid);
}
$this->seedHighGrades($batches, $allStudents, $collegeid);
}
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'review' page.
*/
public function actionCreate($programId = null, $semesterId = null)
{
$this->areaSmall = 'New Post';
Yii::log($this->module->basePath);
$college = College::getUserCollege();
$this->forumBreadcrumb = array('Programs' => array('forum/index'));
if ($programId) {
$program = Program::model()->findByPk($programId);
$this->programId = $programId;
$this->forumBreadcrumb = array_merge($this->forumBreadcrumb, array($program->program_name => array('forum/programView', 'programId' => $programId)));
}
if ($semesterId) {
$semester = Semester::model()->findByPk($semesterId);
$this->semesterId = $semesterId;
$this->forumBreadcrumb = array_merge($this->forumBreadcrumb, array($semester->semester_name => array('forum/viewTopics', 'programId' => $programId, 'semesterId' => $semesterId)));
}
$this->forumBreadcrumb = array_merge($this->forumBreadcrumb, array('New Post'));
$model = new ThreadForm($college->college_id);
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['PostItem'])) {
$model->postItem->attributes = $_POST['PostItem'];
$model->thread->attributes = $_POST['Thread'];
$fileUpload = CUploadedFile::getInstance($model->thread, 'attachment');
Yii::log(CVarDumper::dumpAsString($fileUpload));
if ($fileUpload !== null) {
$model->thread->attachment = $fileUpload;
}
if ($model->validate()) {
if ($model->save()) {
if ($fileUpload !== null) {
$model->thread->attachment->saveAs($this->module->basePath . '/files/' . $model->thread->attachment . "_" . $model->thread->getPrimaryKey());
}
//$model->thread->attachment->saveAs(Yii::app()->basePath . '/../files/' . $model->thread->attachment);
$this->redirect(array('review', 'id' => $model->postItem->post_item_id));
exit;
} else {
Yii::app()->user->setFlash('error', 'Unable to post your thread.');
}
}
}
$this->render('create', array('model' => $model, 'collegeId' => $college->college_id));
}
public function actionSearchTopics($string, $progId = null, $semesterId = null)
{
$college = College::getUserCollege();
$this->areaLarge = $college->college_name;
$this->areaSmall = Yii::t('forum', 'forum.area.search');
if (!empty($progId)) {
$this->areaSmall .= " (In " . Program::model()->findByPk($progId)->program_name;
if (!empty($semesterId)) {
$this->areaSmall .= " / " . Semester::model()->findByPk($semesterId)->semester_name;
}
$this->areaSmall .= " )";
}
$this->canPost = false;
Yii::log($string);
$threads = Thread::model()->searchTopics($string, $college->college_id, $progId, $semesterId);
Yii::log(CVarDumper::dumpAsString($threads));
$topicRows = array();
foreach ($threads as $i => $thread) {
$row = array('id' => $thread['thread_id'], 'topic' => $thread['title'], 'program_name' => $thread['program_name'], 'program' => $thread['program_id'], 'semester' => CHtml::link($thread['semester_name'], array('viewTopics', 'programId' => $thread['program_id'], 'semesterId' => $thread['semester_id'])), 'progCode' => $thread['program_code'], 'postDate' => $thread['date_created'], 'numReplies' => $thread['reply_count']);
$topicRows[] = $row;
}
$gridColumns = array(array('name' => 'topic', 'header' => 'Topic', 'type' => 'raw', 'value' => 'CHtml::link($data["topic"], array("post/readTopic", "id" => $data["id"]));'), array('name' => 'program_name', 'header' => 'Program', 'type' => 'raw', 'value' => 'CHtml::link($data["program_name"], array("programView", "programId" => $data["program"]));'), array('name' => 'semester', 'header' => 'Semester', 'type' => 'raw'), array('name' => 'postDate', 'header' => 'Post Date', 'filter' => false, 'value' => 'Yii::app()->timeagoFormat->timeago(new DateTime($data["postDate"]))'), array('name' => 'numReplies', 'header' => 'Replies', 'filter' => false));
$filtersForm = new FiltersForm();
if (isset($_GET['FiltersForm'])) {
$filtersForm->filters = $_GET['FiltersForm'];
}
$filteredData = $filtersForm->filter($topicRows);
$forumGridData = new CommunityArrayDataProvider(array_values($filteredData), array('sort' => array('attributes' => array('topic', 'program', 'postDate', 'numReplies')), 'pagination' => array('pageSize' => Yii::app()->params['forum_pageSize'])));
$forumGridData->setPagination(false);
$this->emptyText = "No topics could be found";
$this->render('topics', array('gridColumns' => $gridColumns, 'forumGridData' => $forumGridData, 'filtersForm' => $filtersForm));
}
<?php
/* @var $this Controller */
$deleteResumesActionUrl = Yii::app()->createAbsoluteUrl('resume/employerFav/deleteSelected');
$ajaxUrl = $this->createUrl('index');
$dataProvider = $model->searchByEmployer(Yii::app()->user->id);
/* @var $this EmployerController */
/* @var $model ViewStudentJobTitle */
$this->widget('bootstrap.widgets.TbEnhancedExtendedGridView', array('id' => 'resume-grid-view', 'dataProvider' => $dataProvider, 'type' => 'striped bordered ', 'enablePageSizeDropdown' => true, 'pageSizeDropdownOptions' => array('selectedValue' => $model->pageSize, 'htmlOptions' => array('class' => 'pageSize-dropdown')), 'filter' => $model, 'ajaxUrl' => $ajaxUrl, 'bulkActions' => array('actionButtons' => array(array('id' => 'btn-download-resume-zip', 'type' => 'primary', 'buttonType' => 'submit', 'icon' => 'white download-alt', 'size' => 'small', 'label' => Yii::t('view', 'employer.resume_grid_detail.download_selected_resumes_lb'), 'click' => 'js:function(values){submitResumeDownloadZip(values);}'), array('id' => 'btn-del-resumes', 'buttonType' => 'submit', 'type' => 'danger', 'icon' => 'trash', 'size' => 'small', 'label' => Yii::t('view', 'employer.resume_grid_detail.del_selected_resumes_lb'), 'click' => "js:function(values){\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tif(!confirm('Are you sure you want to delete all selected items?'))return false;\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\$(values).attr('name','stu_job_id[]');\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tvar data=\$(values).serialize();\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tjQuery('#resume-grid-view').yiiGridView('update', {\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ttype: 'POST',\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\turl: '{$deleteResumesActionUrl}',\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tdata: data,\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsuccess: function(data) {\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\$('#alert-div').html(data);\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tjQuery('#resume-grid-view').yiiGridView('update');\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t},\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t});\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}")), 'checkBoxColumnConfig' => array('name' => 'stu_job_id')), 'columns' => array(array('class' => 'bootstrap.widgets.TbRelationalColumnExtended', 'header' => "Resume ID", 'name' => 'stu_job_id', 'type' => 'raw', 'value' => 'CHtml::tag("span",array(),$data->stu_job_id,true).
$data->getInterviewIcon().
$data->getExpiredIcon().
$data->getStudentHiredIcon()
', 'url' => Yii::app()->createAbsoluteUrl('resume/employer/viewResumeDetails', array('view' => 'fav')), 'cssClassExpression' => '"resume_id".$data->stu_job_id', 'afterAjaxUpdate' => 'js:function(tr, rowid, data){tr.addClass("resume-detail-row");}'), array('header' => Yii::t('model', 'viewStudentJobTitle.first_name'), 'name' => 'first_name', 'type' => 'raw', 'value' => 'CHtml::link($data->first_name, "#",array("data-value"=>$data->student_id,"onclick"=>new CJavaScriptExpression("return viewProfile(this)")))'), array('header' => Yii::t('model', 'viewStudentJobTitle.last_name'), 'name' => 'last_name'), array('filter' => CHtml::listData(JobCat::getAllCategories(), 'job_cat_id', 'job_cat_name'), 'header' => Yii::t('model', 'viewStudentJobTitle.job_cat_name'), 'name' => 'job_cat_id', 'value' => '$data->job_cat_name'), array('header' => Yii::t('model', 'viewStudentJobTitle.job_title_name'), 'name' => 'job_title_name'), array('filter' => CHtml::listData(College::getAllCollege(), 'college_name', 'college_name'), 'header' => Yii::t('model', 'viewStudent.college_name'), 'name' => 'college_id', 'value' => '$data->collegeName'), array('name' => 'skills', 'sortable' => false, 'filter' => false, 'header' => Yii::t('model', 'viewStudentJobTitle.skills'), 'type' => 'raw', 'value' => '"<div class=\\"btn btn-mini\\"><i class=\\"center icon icon-info-sign\\"></i></div>". CHtml::tag("div",array("id"=>"skill".$data->stu_job_id,"class"=>"hide skill-containter-div"),$data->skills)', 'class' => 'bootstrap.widgets.TbPickerColumnExtended', 'containerTag' => 'div', 'containerHtmlOptions' => array('class' => 'skills-picker-div text-center'), 'pickerOptions' => array('html' => true, 'title' => Yii::t('model', 'viewStudentJobTitle.skills'), 'content' => 'js:function(){
var skills=$(this).children(".skill-containter-div").text().split(",");
var content="";
$(skills).each(function(){content+="<span class=\\"label label-info\\">"+ this + "</span> ";});
return content;
}')), array('class' => 'bootstrap.widgets.TbButtonColumnExtended', 'template' => '{interview} {delete}', 'id' => '"resume-actions".$data->stu_job_id', 'afterDelete' => 'function(link,success,data){ if(success) $("#alert-div").html(data); }', 'buttons' => array('delete' => array('icon' => 'trash', 'label' => Yii::t('view', 'delete_lb'), 'url' => 'Yii::app()->createAbsoluteUrl("resume/employerFav/delete",array("id"=>$data->stu_job_id))', 'options' => array('class' => 'delete-resume')), 'interview' => array('icon' => 'calendar', 'label' => Yii::t('view', 'interview_lb'), 'visible' => '$data->allowInterview()', 'options' => array('class' => 'interview-resume')))))));
<fieldset>
<legend>
<?php
echo Yii::t('forum', 'forum.post.postIn');
?>
</legend>
<?php
echo $form->textFieldRow($model, 'collegeName', array('disabled' => true));
?>
<?php
echo $form->dropDownListRow($model->thread, 'program_id', CHtml::listData(College::getProgramsByCollege($collegeId), 'program_id', 'program_name'), array('options' => array($this->programId => array('selected' => 'selected'))));
?>
<?php
echo $form->dropDownListRow($model->thread, 'semester_id', CHtml::listData(Semester::model()->findAll(), 'semester_id', 'semester_name'), array('options' => array($this->semesterId => array('selected' => 'selected'))));
?>
<?php
echo $form->textFieldRow($model->thread, 'program_code');
?>
<legend>
<?php
echo Yii::t('forum', 'forum.post.details');
?>
public function ActionAjaxCollegePrograms()
{
if (isset($_POST['college'])) {
$programs = CHtml::listData(College::getProgramsByCollege($_POST['college']), 'program_id', 'program_name');
echo '<option>' . Yii::t('model', 'student.program_id_empty') . '</option>';
foreach ($programs as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
}
<?php
echo $form->timepickerRow($model->event, 'end_time', array('class' => 'span12', 'prepend' => '<i class="icon-time"></i>'));
?>
<?php
//echo $form->textFieldRow($model->event,'event_image',array('class'=>'span12','maxlength'=>100));
?>
<?php
if ($isAdminAccess) {
if ($model->event->isNewRecord || !$model->postedByCollegeAdmin()) {
echo $form->dropDownListRow($model->event, 'college_id', CHtml::listData(College::getAllCollege(), 'college_id', 'college_name'), array('prompt' => Yii::t('model', 'event.college_id_empty')));
echo $form->hiddenField($model, 'isPublic');
} else {
echo $form->checkBoxRow($model, 'isPublic', array('checked' => $model->event->isPublic()));
}
} else {
echo $form->checkBoxRow($model, 'isPublic');
}
?>
<?php
echo $form->hiddenField($model, 'form');
?>
</fieldset>
<div class="clearfix"></div>
?>
<span><a href="<?php
echo $this->createUrl('ehighschool');
?>
" id="chighschool" onclick="showAddress(this.href);return false;">修改</a></span>
<?php
echo $form->error($model, 'highschool');
?>
</div>
<hr class="space" />
<div class="row">
<?php
echo $form->labelEx($model, 'university');
?>
<span id="universityHolder"><?php
echo College::model()->getCollegeName($model->university);
?>
</span>
<?php
echo $form->hiddenField($model, 'university', array('size' => 20, 'maxlength' => 20, 'class' => 'span-9 poshy', 'title' => '您就读的大学'));
?>
<span><a href="<?php
echo $this->createUrl('euniversity');
?>
" id="cuniversity" onclick="showAddress(this.href);return false;">修改</a></span>
<?php
echo $form->error($model, 'university');
?>
</div>
<hr class="space" />
<div class="row">
/**
* @todo 利用上面获取得的相关信息，把其写入文件或数据库，当然写入数据库之前要建立数据库
*
* 结构如下：
*
* CREATE TABLE `college` (
* `id` int(11) NOT NULL AUTO_INCREMENT,
* `name` varchar(200) NOT NULL COMMENT '高校名称',
* `type` int(11) NOT NULL COMMENT '高校类型',
* `province` int(11) NOT NULL COMMENT '高校所在省份',
* `homepage` varchar(200) NOT NULL COMMENT '高校主页\r\n',
* PRIMARY KEY (`id`),
* KEY `province` (`province`)
* ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
*
*注意：这里只是Yii版的范例，如果需要使用，则需要对应修改一下下面的代码
*/
public static function generateCollegesInfo($output = 'file')
{
$str = '';
//获取网址
$urls = self::getCollegesLocation();
foreach ($urls as $province => $url) {
/**获取provinceID*/
$criteria = new CDbCriteria();
$criteria->addSearchCondition('region', $province);
$region = Region::model()->find($criteria);
// UtilHelper::dump($region->attributes);
$provinceID = $region->id;
// UtilHelper::dump($province.'-=-'.$provinceID);
foreach ($url as $k => $v) {
$type = $k;
// UtilHelper::dump($province.'-'.$k.'=>'.$v);
$colleges = self::getColleges($v);
// UtilHelper::dump($colleges);
foreach ($colleges as $name => $homepage) {
/**在这里把要写入数据库的信息写入文件**/
$str .= $province . "\t" . $type . "\t" . $name . "\t" . $homepage . "\r\n";
$college = new College();
$college->province = $provinceID;
$college->type = $type;
$college->name = $name;
$college->homepage = $homepage;
if ($college->save()) {
echo 'yes-' . $college->id . '<br />';
} else {
echo CHtml::errorSummary($college);
}
}
}
}
if ($output == 'file') {
$fp = fopen('./public/colleges.txt', 'w+');
fwrite($fp, $str);
fclose($fp);
}
}
echo $form->textFieldRow($model->user, 'last_name', array('class' => 'span5', 'maxlength' => 20));
?>
<?php
echo $form->passwordFieldRow($model->user, 'password', array('class' => 'span5', 'maxlength' => 255));
?>
<?php
echo $form->passwordFieldRow($model, 'confirmPassword', array('class' => 'span5', 'maxlength' => 255));
?>
<?php
echo $form->hiddenField($model->user, 'user_group_id');
?>
<?php
echo $form->hiddenField($model, 'consented', array('value' => '1'));
?>
<?php
echo $form->dropDownListRow($model->collegeAdmin, 'college_id', CHtml::listData(College::model()->findAll(), 'college_id', 'college_name'), array('prompt' => Yii::t('model', 'student.college_id_empty')));
?>
<div class="form-actions">
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'submit', 'type' => 'primary', 'label' => 'Create'));
?>
</div>
<?php
$this->endWidget();
/**
* 高校比较
*/
public function compareAction()
{
//判断是否是ajax请求
if ($this->request->isAjax()) {
$validate = new \Validate();
$data['id1'] = (int) $validate->getPost('id1');
$data['id2'] = (int) $validate->getPost('id2');
if ($data['id1'] == 0) {
$this->end(400);
}
$this->end(json_encode((new \Search())->getSchool($data)));
}
$data['id1'] = (int) $this->request->getQuery('id1');
$data['id2'] = (int) $this->request->getQuery('id2');
if ($data['id1'] == 0 || $data['id2'] == 0) {
$this->notFound();
}
$college = new \College();
$college1 = $college->getCollegeCompare($data['id1']);
$college2 = $college->getCollegeCompare($data['id2']);
if (empty($college1) || empty($college2)) {
$this->notFound();
}
//设置标题
$this->tag->setTitle("51升学网-学校比较");
$this->assets->addCss("fontend/css/school/compare.css");
$this->assets->addJs("fontend/js/school_compare.js");
$this->view->setVars(['college1' => $college1, 'college2' => $college2]);
}
<h1>Manage Community Forums</h1>
<?php
if (!empty($this->area)) {
echo "<h1>({$this->area})</h1>";
}
?>
<p>
You may optionally enter a comparison operator (<b><</b>, <b><=</b>, <b>></b>, <b>>=</b>, <b><></b>
or <b>=</b>) at the beginning of each of your search values to specify how the comparison should be done.
</p>
<?php
echo CHtml::link('Advanced Search', '#', array('class' => 'search-button btn'));
?>
<div class="search-form" style="display:none">
<?php
$this->renderPartial('_search', array('model' => $model));
?>
</div><!-- search-form -->
<?php
$this->widget('bootstrap.widgets.TbAlert', array('block' => true, 'fade' => true, 'closeText' => '×', 'alerts' => array('error' => array('block' => true, 'fade' => true, 'closeText' => '×'), 'success' => array('block' => true, 'fade' => true, 'closeText' => '×')), 'htmlOptions' => array('class' => 'forum-alert')));
?>
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'thread-grid', 'dataProvider' => $dataProvider, 'filter' => $model, 'columns' => array(array('name' => 'post_item_id', 'filter' => false, 'type' => 'html', 'value' => 'CHtml::link($data->post_item_id, array("/post/readTopic", "id"=>$data->post_item_id))', 'header' => 'ID', 'htmlOptions' => array('style' => 'width: 50px;')), array('header' => 'Title', 'name' => 'post_item_id', 'type' => 'html', 'value' => 'CHtml::link($data->postItem->title, array("/post/readTopic", "id"=>$data->post_item_id))'), 'program_code', array('name' => 'college_id', 'value' => '$data->college->college_name', 'filter' => CHtml::listData(College::getCollegeFilter(Yii::app()->user->user_group_id), 'college_id', 'college_name')), array('name' => 'program_id', 'value' => '$data->program->program_name', 'filter' => CHtml::listData(Program::getProgramFilter(), 'program_id', 'program_name')), array('name' => 'semester_id', 'filter' => CHtml::dropDownList('Thread[semester_id]', $model->semester_id, array('1' => 1, 2, 3, 4, 5, 6), array('empty' => '(Select)')), 'htmlOptions' => array('style' => 'width: 105px;')), array('name' => 'attachment', 'filter' => false, 'type' => 'html', 'value' => '!empty($data->attachment) ? CHtml::link("Yes", array("post/downloadAttachment", "fileName"=>$data->attachment, "threadId" => $data->post_item_id)) : "No"'), array('class' => 'bootstrap.widgets.TbButtonColumn', 'template' => '{view} {delete}', 'viewButtonUrl' => 'Yii::app()->controller->createUrl("/post/readTopic", array("id"=>$data->post_item_id))', 'buttons' => array('disable' => array('label' => 'Disable', 'icon' => 'remove-sign', 'url' => 'Yii::app()->createUrl("users/email", array("id"=>$data->post_item_id))'))), array('class' => 'bootstrap.widgets.TbToggleColumn', 'toggleAction' => 'toggle', 'filter' => array('0' => 'No', '1' => 'Yes'), 'name' => 'postItem.is_active', 'value' => 0, 'checkedButtonLabel' => 'Active', 'uncheckedButtonLabel' => 'Disabled', 'header' => false))));
?>
<!--'CHtml::link($data["topic"], array("post/readTopic", "id" => $data["id"]));'-->
/**
* 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 = College::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
/* @var $this EmployerController */
/* @var $model ViewStudentJobTitle */
$ajaxUrl = $this->createUrl('index');
$dataProvider = $model->searchHiredArchiveByEmployer(Yii::app()->user->id);
$this->widget('bootstrap.widgets.TbEnhancedExtendedGridView', array('id' => 'resume-grid-view-archive', 'dataProvider' => $dataProvider, 'type' => 'striped bordered ', 'enablePageSizeDropdown' => true, 'pageSizeDropdownOptions' => array('selectedValue' => $model->pageSize, 'htmlOptions' => array('class' => 'pageSize-dropdown')), 'filter' => $model, 'ajaxUrl' => $ajaxUrl, 'bulkActions' => array('actionButtons' => array(array('id' => 'btn-download-resume-archive-zip', 'type' => 'primary', 'buttonType' => 'submit', 'icon' => 'white download-alt', 'size' => 'small', 'label' => Yii::t('view', 'employer.resume_grid_detail.download_selected_resumes_lb'), 'click' => 'js:function(values){submitResumeDownloadZip(values);}')), 'checkBoxColumnConfig' => array('name' => 'stu_job_id')), 'columns' => array(array('class' => 'bootstrap.widgets.TbRelationalColumnExtended', 'header' => "Resume ID", 'name' => 'stu_job_id', 'type' => 'raw', 'value' => 'CHtml::tag("span",array(),$data->stu_job_id,true).
$data->getFavIcon()
', 'url' => Yii::app()->createAbsoluteUrl('resume/employer/viewResumeDetails'), 'cssClassExpression' => '"resume_archive_id".$data->stu_job_id', 'cssClass' => 'tbrelational-column hired-archive', 'afterAjaxUpdate' => 'js:function(tr, rowid, data){tr.addClass("resume-detail-row");}'), array('header' => Yii::t('model', 'viewStudentJobTitle.first_name'), 'name' => 'first_name', 'type' => 'raw', 'value' => 'CHtml::link($data->first_name, "#",array("data-value"=>$data->student_id,"onclick"=>new CJavaScriptExpression("return viewProfile(this)")))'), array('header' => Yii::t('model', 'viewStudentJobTitle.last_name'), 'name' => 'last_name'), array('filter' => CHtml::listData(JobCat::getAllCategories(), 'job_cat_id', 'job_cat_name'), 'header' => Yii::t('model', 'viewStudentJobTitle.job_cat_name'), 'name' => 'job_cat_id', 'value' => '$data->job_cat_name'), array('header' => Yii::t('model', 'viewStudentJobTitle.job_title_name'), 'name' => 'job_title_name'), array('filter' => CHtml::listData(College::getAllCollege(), 'college_name', 'college_name'), 'header' => Yii::t('model', 'viewStudent.college_name'), 'name' => 'college_id', 'value' => '$data->collegeName'), array('header' => Yii::t('model', 'viewStudentJobTitle.date_hired'), 'name' => 'date_hired'))));
<?php
/* @var $this EmployerController */
/* @var $model ViewStudentJobTitle */
$deleteResumesActionUrl = Yii::app()->createAbsoluteUrl('resume/employerHired/unhireSelected');
$ajaxUrl = $this->createUrl('index');
$dataProvider = $model->searchCurrentHiredByEmployer(Yii::app()->user->id);
$this->widget('bootstrap.widgets.TbEnhancedExtendedGridView', array('id' => 'resume-grid-view', 'dataProvider' => $dataProvider, 'type' => 'striped bordered ', 'enablePageSizeDropdown' => true, 'pageSizeDropdownOptions' => array('selectedValue' => $model->pageSize, 'htmlOptions' => array('class' => 'pageSize-dropdown')), 'filter' => $model, 'ajaxUrl' => $ajaxUrl, 'bulkActions' => array('actionButtons' => array(array('id' => 'btn-download-resume-zip', 'type' => 'primary', 'buttonType' => 'submit', 'icon' => 'white download-alt', 'size' => 'small', 'label' => Yii::t('view', 'employer.resume_grid_detail.download_selected_resumes_lb'), 'click' => 'js:function(values){submitResumeDownloadZip(values);}'), array('id' => 'btn-unhire-resumes', 'buttonType' => 'submit', 'type' => 'danger', 'icon' => 'remove', 'size' => 'small', 'label' => Yii::t('view', 'employer.resume_grid_detail.unhire_selected_resumes_lb'), 'click' => "js:function(values){\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tif(!confirm('Are you sure you want to un-hire all selected students?\\nNote: This cannot be undone.'))return false;\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\$(values).attr('name','stu_job_id[]');\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tvar data=\$(values).serialize();\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tjQuery('#resume-grid-view').yiiGridView('update', {\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ttype: 'POST',\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\turl: '{$deleteResumesActionUrl}',\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tdata: data,\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsuccess: function(data) {\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\$('#alert-div').html(data);\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tjQuery('#resume-grid-view').yiiGridView('update');\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tjQuery('#resume-grid-view-archive').yiiGridView('update');\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t},\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t});\r\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}")), 'checkBoxColumnConfig' => array('name' => 'stu_job_id')), 'columns' => array(array('class' => 'bootstrap.widgets.TbRelationalColumnExtended', 'header' => "Resume ID", 'name' => 'stu_job_id', 'type' => 'raw', 'value' => 'CHtml::tag("span",array(),$data->stu_job_id,true).
$data->getFavIcon()
', 'url' => Yii::app()->createAbsoluteUrl('resume/employer/viewResumeDetails'), 'cssClassExpression' => '"resume_id".$data->stu_job_id', 'cssClass' => 'tbrelational-column current-hired', 'afterAjaxUpdate' => 'js:function(tr, rowid, data){tr.addClass("resume-detail-row");}'), array('header' => Yii::t('model', 'viewStudentJobTitle.first_name'), 'name' => 'first_name', 'type' => 'raw', 'value' => 'CHtml::link($data->first_name, "#",array("data-value"=>$data->student_id,"onclick"=>new CJavaScriptExpression("return viewProfile(this)")))'), array('header' => Yii::t('model', 'viewStudentJobTitle.last_name'), 'name' => 'last_name'), array('filter' => CHtml::listData(JobCat::getAllCategories(), 'job_cat_id', 'job_cat_name'), 'header' => Yii::t('model', 'viewStudentJobTitle.job_cat_name'), 'name' => 'job_cat_id', 'value' => '$data->job_cat_name'), array('header' => Yii::t('model', 'viewStudentJobTitle.job_title_name'), 'name' => 'job_title_name'), array('filter' => CHtml::listData(College::getAllCollege(), 'college_name', 'college_name'), 'header' => Yii::t('model', 'viewStudent.college_name'), 'name' => 'college_id', 'value' => '$data->collegeName'), array('name' => 'date_hired'), array('class' => 'bootstrap.widgets.TbButtonColumnExtended', 'template' => '{delete}', 'id' => '"resume-actions".$data->stu_job_id', 'afterDelete' => 'function(link,success,data){ if(success) $("#alert-div").html(data); $("#resume-grid-view-archive").yiiGridView("update");}', 'deleteConfirmation' => "Are you sure you want to un-hire this student? \nNote: This cannot be undone.", 'buttons' => array('delete' => array('icon' => 'remove', 'label' => Yii::t('view', 'unhire_lb'), 'url' => 'Yii::app()->createAbsoluteUrl("resume/employerHired/unhire",array("stu_job_id"=>$data->stu_job_id))', 'options' => array('class' => 'unhire-resume'), 'visible' => '$data->is_current_hired=="1"'))))));
<?php
$this->renderPartial('application.modules.account.views.common.register._form', array('model' => $model, 'form' => $form));
?>
</fieldset>
<fieldset>
<legend><?php
echo Yii::t('view', 'student_info_lb');
?>
</legend>
<?php
echo $form->dropDownListRow($model->student, 'college_id', CHtml::listData(College::model()->findAll(), 'college_id', 'college_name'), array('prompt' => Yii::t('model', 'student.college_id_empty'), 'ajax' => array('type' => 'POST', 'url' => $this->createUrl('register/ajaxCollegePrograms'), 'update' => '#' . CHtml::activeId($model->student, 'program_id'), 'data' => array('college' => 'js:this.value'))));
?>
<!--
<?php
echo $form->dropDownListRow($model->student, 'program_id', CHtml::listData(College::getProgramsByCollege($model->student->college_id), 'program_id', 'program_name'), array('prompt' => Yii::t('model', 'student.program_id_empty')));
?>
<?php
echo $form->textFieldRow($model->student, 'program_code');
?>
-->
<?php
echo $form->dropDownListRow($model->student, 'education_level_id', CHtml::listData(EducationLevel::model()->findAll(), 'education_level_id', 'education_level_name'), array('prompt' => Yii::t('model', 'student.education_level_id_empty')));
?>
<?php
echo $form->textFieldRow($model->student, 'major_name');
?>
<!--
<?php
echo $form->datepickerRow($model->student, 'enrollment_date', array('options' => array('format' => 'yyyy-mm-dd')));
?>
public function schoolAction($id, $page)
{
$data['action'] = "school";
$data['id'] = (int) $id;
$data['type'] = $this->request->getQuery('type') ? $this->request->getQuery('type') : 1;
$data['id'] = $this->request->getQuery('id') ? $this->request->getQuery('id') : 0;
$page = (int) $page < 1 ? 1 : $page;
$detail = (new \Major())->getDetail($id);
$list = (new \Major())->getList($detail['maj_type']);
foreach ($list as &$val1) {
$val1['url'] = "/major/list?type=" . $data['type'] . "&id=" . $val1['maj_par_par_id'];
}
$web_key = "51升学网-" . $detail['maj_name'];
$web_desc = strip_tags($detail['maj_explain']);
$this->tag->setTitle($detail['maj_name'] . "-51升学网");
$school = (new \Major())->getSchool($id, $page);
$page_html = $this->pageHtml($school['page']);
$attribute = new \College();
foreach ($school['list'] as &$val) {
$val['attribute'] = $attribute->getAttribute($val['col_id']);
$val['test'] = "/college/test_" . $val['col_id'] . ".html";
$val['url'] = "/college/detail_" . $val['col_id'] . ".html";
}
$this->view->setLayout("major");
//引入js 和css
$this->assets->addCss("fontend/css/major/detail-schools.css");
$this->assets->addJs("fontend/js/major_detail_school.js");
$this->view->setVars(['list' => $list, 'detail' => $detail, 'school' => $school['list'], 'data' => $data, 'page_html' => $page_html, 'page' => $school['page'], 'web_key' => $web_key, 'web_desc' => $web_desc]);
}
/* @var $this ProfileController */
?>
<div class="row-fluid">
<div class="span-12">
<div class="snippet-header">
<h1><?php
echo Yii::t('view', 'event.upcoming');
?>
</h1>
</div>
<?php
$this->widget('bootstrap.widgets.TbExtendedGridView', array('dataProvider' => Event::getLatestEventsSnippet(Yii::app()->params['defaultLatestEventsToGet'], College::getUserCollege()->college_id), 'selectableCells' => true, 'selectableRows' => 1, 'columns' => array(array('name' => 'title', 'header' => 'Title'), array('name' => 'city', 'header' => 'Location'), array('header' => 'Date', 'type' => 'raw', 'value' => '$data["start_date"] . CHtml::tag("br") . $data["end_date"]'), array('header' => 'Time', 'type' => 'raw', 'value' => '$data["start_time"] . CHtml::tag("br") . $data["end_time"]'), array('value' => 'Yii::app()->getController()->createAbsoluteUrl("/event/event/view", array("id" => $data["id"]))', 'headerHtmlOptions' => array('style' => 'display: none;'), 'htmlOptions' => array('class' => 'link', 'style' => 'display: none;'))), 'template' => "{items}", 'emptyText' => "There are currently no Events", 'type' => 'bordered', 'rowCssClassExpression' => '"link-row"', 'htmlOptions' => array('class' => 'snippetEventGrid')));
$btn = $this->widget('bootstrap.widgets.TbButton', array('label' => Yii::t('view', 'event.more'), 'type' => 'primary', 'url' => array('/event/event/index'), 'size' => 'large', 'icon' => 'flag'), true);
echo CHtml::tag('div', array('class' => 'snippet-more-area'), $btn);
?>
</div>
</div>
<script>
$(document).ready(function (){
$('.snippetEventGrid tbody tr.link-row').click(function(){
var link = $(this).children("td.link").html();
window.location.assign(link);
/**
* 获取用户的大学学校信息
* @param unknown_type $uid
*/
public function getUserUniversity($uid = null)
{
$model = self::getProfileModel($uid);
return College::model()->getCollege($model->profiles->university);
}
$this->breadcrumbs = array('Events' => array('index'), 'Manage');
$this->menu = array(array('label' => 'List Event', 'url' => array('index')), array('label' => 'Create Event', 'url' => array('create')));
$isAdminAccess = Yii::app()->user->isAdmin() || Yii::app()->user->isSuperAdmin();
Yii::app()->clientScript->registerScript('search', "\r\r\n\$('.search-button').click(function(){\r\r\n\t\$('.search-form').toggle();\r\r\n\treturn false;\r\r\n});\r\r\n\$('.search-form form').submit(function(){\r\r\n\t\$.fn.yiiGridView.update('event-grid', {\r\r\n\t\tdata: \$(this).serialize()\r\r\n\t});\r\r\n\treturn false;\r\r\n});\r\r\n");
?>
<h1>Manage Events</h1>
<p>
You may optionally enter a comparison operator (<b><</b>, <b><=</b>, <b>></b>, <b>>=</b>, <b><></b>
or <b>=</b>) at the beginning of each of your search values to specify how the comparison should be done.
</p>
<?php
echo CHtml::link('Advanced Search', '#', array('class' => 'search-button btn'));
?>
<div class="search-form" style="display:none">
<div class="well well-small">
<?php
$this->renderPartial('_search', array('model' => $model));
?>
</div>
</div><!-- search-form -->
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'event-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array('post_item_id', array('name' => 'userId', 'visible' => $isAdminAccess), 'title', 'start_date:date', 'end_date:date', 'start_time:time', 'end_time:time', array('name' => 'college_id', 'header' => 'Signup Type', 'value' => '$data->getSignupType()', 'filter' => CHtml::listData(College::getAllCollege(), 'college_id', 'college_name'), 'type' => 'raw', 'visible' => $isAdminAccess), array('name' => 'college_id', 'header' => 'Public Signup', 'value' => 'Yii::app()->format->formatBoolean($data->isPublic())', 'visible' => yii::app()->user->isCollegeAdmin()), array('name' => 'is_active', 'class' => 'bootstrap.widgets.TbToggleColumn', 'toggleAction' => 'toggle', 'filter' => array('1' => 'Yes', '0' => 'No'), 'visible' => $isAdminAccess), array('class' => 'bootstrap.widgets.TbButtonColumn', 'buttons' => array('delete' => array('visible' => '$data->is_active=="1"'))))));
?>
<?php $objCollege = new College(); $college = $objCollege->getCollegeFacts(Url::getSchoolUrl()); ?> <h1>College Profile</h1> <p> <?php echo $college['name']; ?> </p>
<div class="row-fluid">
<div class="span-12">
<div class="snippet-header">
<h1><?php
echo Yii::t('view', 'topic.today');
?>
</h1>
</div>
<?php
$this->widget('bootstrap.widgets.TbGridView', array('dataProvider' => Thread::getTodaysThreadsSnippet(College::getUserCollege()->college_id), 'columns' => array(array('header' => 'Title', 'name' => 'title', 'type' => 'raw', 'value' => 'CHtml::link($data["title"], array("/community/post/readTopic", "id" => $data["id"]));'), array('header' => 'Forum', 'name' => 'program_name', 'type' => 'raw', 'value' => 'CHtml::link($data["program_name"], array("/community/forum/programView", "programId" => $data["program_id"]));'), array('header' => 'Semester', 'name' => 'semester_name', 'type' => 'raw', 'value' => 'CHtml::link($data["semester_name"], array("/community/forum/viewTopics", "programId" => $data["program_id"], "semesterId" => $data["semester_id"]));'), array('header' => 'Program Code', 'name' => 'program_code'), array('header' => 'Date Posted', 'name' => 'date_created', 'value' => 'Yii::app()->timeagoFormat->timeago(new DateTime($data["date_created"]))')), 'template' => "{items}", 'emptyText' => "There are currently no Topics today", 'type' => 'bordered', 'htmlOptions' => array('class' => 'snippetTopicGrid')));
$btn = $this->widget('bootstrap.widgets.TbButton', array('label' => Yii::t('view', 'topic.more'), 'type' => 'primary', 'size' => 'large', 'url' => array('/community/forum/todaysTopics'), 'icon' => 'comment'), true);
echo CHtml::tag('div', array('class' => 'snippet-more-area'), $btn);
?>
</div>
</div>
public function actionTest4()
{
$filename = './public/highscholls.txt';
$school = file($filename);
$school = array_map('check', $school);
// foreach ($school as $k=>$v)
// {
//// $school = str_replace($ufo, '',str_replace("\r", '',str_replace("\n", '', $v),$v),$v);
//
//// $school[$k] = str_replace("\r", '',str_replace("\n", '', $v),$v);
// if (intval($v)||trim($v) == ''||trim($v)==' '||trim($v) ==' '||strpos(' ', $v))
// {
// unset($school[$k]);
// }
// }
$school = array_chunk($school, 2);
foreach ($school as $value) {
// $todo[$value[1]] = $value[0];
$province = $value[0];
$name = $value[1];
echo $province;
echo $name;
/**获取provinceID*/
$criteria = new CDbCriteria();
$criteria->addSearchCondition('region', $province);
$region = Region::model()->find($criteria);
UtilHelper::dump($region->attributes);
$provinceID = $region->id;
$type = College::COLLEGE_TYPE_GAOZHONG;
$college = new College();
$college->province = $provinceID;
$college->type = $type;
$college->name = $name;
if ($college->isNewRecord && $college->save()) {
echo 'yes-' . $college->id . '<br />';
} else {
echo CHtml::errorSummary($college);
}
}
// UtilHelper::dump($todo);
}
