//});
//return false;
//});
//");
//
?>
<h1>Перелік абітурієнтів</h1>
<p>Ви можете використовувати операції порівняння (<b><</b>, <b><=</b>, <b>></b>, <b>>=</b>, <b><></b>
або <b>=</b>) на початку кожного з параметрі що необхідно знайти.
</p>
<?php
// echo CHtml::link('Розширений пошук','#',array('class'=>'search-button'));
?>
<div class="search-form" style="display:none">
<?php
/*$this->renderPartial('_search',array(
'model'=>$model,
)); */
?>
</div><!-- search-form -->
<?php
$edt = CHtml::listData(Personeducationforms::model()->findAll(), 'idPersonEducationForm', 'PersonEducationFormName');
$facs = CHtml::listData(Facultets::model()->findAll(), 'idFacultet', 'FacultetFullName');
$status = CHtml::listData(Personrequeststatustypes::model()->findAll(), 'idPersonRequestStatusType', 'PersonRequestStatusTypeName');
$this->widget('bootstrap.widgets.TbGroupGridView', array('id' => 'person-speciality-view-grid', 'type' => 'striped bordered condensed', 'dataProvider' => $model->search(), 'rowCssClassExpression' => '$data->getRowStyle()', 'filter' => $model, 'mergeColumns' => array('FIO', 'Birthday', "PersonRequestNumber", 'idPerson'), 'columns' => array(array('name' => 'idPerson', 'htmlOptions' => array('style' => 'width: 50px')), array('name' => 'PersonRequestNumber', 'value' => '$data->RequestPrefix.str_pad($data->PersonRequestNumber, 5, "0", STR_PAD_LEFT)', 'htmlOptions' => array('style' => 'width: 100px')), array('name' => 'RequestNumber', 'value' => 'str_pad($data->RequestNumber, 5, "0", STR_PAD_LEFT)', 'htmlOptions' => array('style' => 'width: 50px')), array('name' => 'FIO', 'htmlOptions' => array('style' => 'width: 250px')), 'SpecCodeName', array('name' => 'EducationFormID', 'htmlOptions' => array('style' => 'width: 70px'), 'filter' => $edt, 'value' => '$data->educationform->PersonEducationFormName'), array('name' => 'CreateDate', 'htmlOptions' => array('style' => 'width: 100px')), array('name' => 'StatusID', 'htmlOptions' => array(), 'filter' => $status, 'value' => '$data->status->PersonRequestStatusTypeName'), array('name' => 'isCopyEntrantDoc', 'htmlOptions' => array('style' => 'width: 70px'), 'filter' => array('1' => 'так', '0' => 'ні'), 'value' => '($data->isCopyEntrantDoc=="1")?("так"):("ні")'), array('name' => 'Facultet', 'htmlOptions' => array('style' => 'width: 150px'), 'filter' => $facs, 'value' => '$data->speciality->facultet->FacultetFullName'), array('name' => 'DocumentSubject1Value', 'htmlOptions' => array('style' => 'width: 50px')), array('name' => 'DocumentSubject2Value', 'htmlOptions' => array('style' => 'width: 50px')), array('name' => 'DocumentSubject3Value', 'htmlOptions' => array('style' => 'width: 50px')), array('name' => 'AtestatValue', 'htmlOptions' => array('style' => 'width: 50px')), array('class' => 'bootstrap.widgets.TbButtonColumn', 'template' => '{update}{view}', 'buttons' => array('update' => array('label' => 'Редагувати', 'icon' => 'pencil', 'url' => 'Yii::app()->createUrl("person/update", array("id"=>$data->idPerson))', 'options' => array('class' => 'btn')), 'view' => array('label' => 'Параметри вступу', 'icon' => 'icon-th-list', 'url' => 'Yii::app()->createUrl("person/view", array("id"=>$data->idPerson))', 'options' => array('class' => 'btn'))), 'htmlOptions' => array('style' => 'width: 90px;')))));
?>
<?php
//echo $form->error($model,'EducationFormID');
?>
</div>
<div class="span4">
<?php
if (empty($model->sepciality)) {
$idFacultet = 0;
} else {
$idFacultet = $model->sepciality->FacultetID;
}
echo CHtml::label("Факультет", "idFacultet");
?>
<?php
echo CHtml::dropDownList('idFacultet', $idFacultet, CHtml::listData(Facultets::model()->findAll(array('order' => 'FacultetFullName')), 'idFacultet', 'FacultetFullName'), array('empty' => '', 'disabled' => !$model->isNewRecord, 'onchange' => "PSN.onFacChange(this, '#" . CHtml::activeId($model, "SepcialityID") . "','" . CController::createUrl('personspeciality/speciality') . "');", 'class' => "span12"));
?>
</div>
</div>
</div>
<div class="span4">
<?php
$url = Yii::app()->createUrl("personspeciality/znosubjects", array("personid" => $personid, "specid" => intval($model->idPersonSpeciality)));
echo $form->labelEx($model, 'SepcialityID');
?>
<?php
if (!empty($model->EducationFormID) && !empty($model->QualificationID)) {
echo $form->dropDownList($model, 'SepcialityID', Specialities::DropDownMask($idFacultet, $model->EducationFormID, $model->QualificationID), array('empty' => '', 'class' => "span12", 'disabled' => !$model->isNewRecord));
} else {
echo $form->dropDownList($model, 'SepcialityID', Specialities::DropDown($idFacultet), array('empty' => '', 'class' => "span12", 'disabled' => !$model->isNewRecord));
}
<?php
if (!empty($models)) {
?>
<?php
foreach ($models as $i => $model) {
?>
<div class="row-fluid">
<div class="span3">
<?php
$idFacultet = $model->sepciality->FacultetID;
echo CHtml::label("Факультет", "idFacultet");
?>
<?php
echo CHtml::dropDownList('idFacultet', $idFacultet, CHtml::listData(Facultets::model()->findAll(array('order' => 'FacultetFullName')), 'idFacultet', 'FacultetFullName'), array("disabled" => "disabled", "id" => "idFacultet", 'class' => "span12"));
?>
</div>
<div class="span3">
<?php
$url = Yii::app()->createUrl("personspeciality/znosubjects", array("personid" => $personid, "specid" => intval($model->idPersonSpeciality)));
echo $form->label($model, 'SepcialityID');
?>
<?php
echo $form->dropDownList($model, 'SepcialityID', CHtml::listData(Specialities::model()->findAll(), 'idSpeciality', 'SpecialityDirectionName'), array('class' => "span12", "disabled" => "disabled", "id" => "SepcialityID"));
?>
</div>
<div class="span2">
<?php
echo $form->label($model, 'PaymentTypeID');
public function getLanguagesUrl($faculty, $lang)
{
$WU = new WebUser();
$model = $WU->getUserModel();
if (empty($model->syspk) || empty($model->syspk->printIP)) {
throw new Exception("Необхідно визначити адресу серверу друку документів!");
}
$ip = $model->syspk->printIP;
$_faculty = Facultets::model()->find("idFacultet={$faculty}");
$_lang = Languages::model()->find("idLanguages={$lang}");
if (empty($_faculty) || empty($_lang) && $lang != '0') {
throw new Exception("Помилка вхідних даних!");
}
return "http://" . $ip . ":8080/request_report-1.0/language.jsp?faculty={$faculty}&lang={$lang}&iframe=true&width=1024&height=600";
}
/**
* 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 = Facultets::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
</div>
<div class="row-fluid" >
<div class ="span2">
<?php
echo $form->labelEx($model, 'EducationFormID');
?>
<?php
echo $form->dropDownList($model, 'EducationFormID', CHtml::listData(Personeducationforms::model()->findAll(), "idPersonEducationForm", "PersonEducationFormName"), array('class' => 'span12', "id" => "EducationFormID", 'onchange' => "PSN.changeFacultet(this,'" . Yii::app()->createUrl("personspeciality/speciality") . "')"));
?>
</div>
<div class ="span4">
<?php
echo $form->labelEx($model, 'FacultetID');
?>
<?php
echo $form->dropDownList($model, 'FacultetID', CHtml::listData(Facultets::model()->findAll(), "idFacultet", "FacultetFullName"), array('class' => 'span12', "id" => "FacultetID", 'empty' => "", 'onchange' => "PSN.changeFacultet(this,'" . Yii::app()->createUrl("personspeciality/speciality") . "')"));
?>
</div>
<div class ="span6">
<?php
echo $form->labelEx($model, 'SpecialityID');
?>
<?php
echo $form->dropDownList($model, 'SpecialityID', Specialities::DropDownMask($model->FacultetID, 1, 1, ""), array('class' => 'span12', "id" => "idPreuniGroup"));
?>
</div>
</div>
<div class="row-fluid">
public function getPrintFackultetUrl($fuckultet)
{
$model = $this->getUserModel();
if (empty($model->syspk) || empty($model->syspk->printIP)) {
throw new Exception("Необхідно визначити адресу серверу друку документів!");
}
$ip = $model->syspk->printIP;
$spec = Facultets::model()->find("idFacultet={$fuckultet}");
if (empty($spec)) {
throw new Exception("Необхідно визначити спеціальність!");
}
return "http://" . $ip . ":8080/request_report-1.0/price_sort_facultet.jsp?idFacultet={$fuckultet}&iframe=true&width=1024&height=600";
return "";
}
public function actionStat()
{
$model = new Facultets('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Facultets'])) {
$model->attributes = $_GET['Facultets'];
}
$this->render('stat', array('model' => $model));
}
/**
* Метод повертає архів із фото усіх зарахованих персон для факультету з ID = $id
*/
public function actionGetphotozip()
{
$id = Yii::app()->request->getParam('id', 0);
if (!is_numeric($id)) {
throw new CHttpException(400, 'Помилка: ID має бути цілим числом.');
}
$faculty = Facultets::model()->findByPk($id);
if (!$faculty) {
throw new CHttpException(400, 'Факультет з ID=' . $id . ' не знайдено.');
}
$criteria = new CDbCriteria();
$criteria->with = array('person', 'sepciality', 'sepciality.facultet');
$criteria->compare('sepciality.FacultetID', $id);
$criteria->compare('StatusID', 7);
$criteria->together = true;
$models = Personspeciality::model()->findAll($criteria);
if (count($models) == 0) {
throw new CHttpException(400, 'Помилка: немає даних.');
}
$zipname = 'Facultet_' . $models[0]->sepciality->FacultetID . '.zip';
$zip = new ZipArchive();
$zip->open($zipname, ZipArchive::CREATE);
$def_path = Yii::app()->getBasePath() . '/../images/Photos/';
$count = 0;
foreach ($models as $model) {
$file_entity = $def_path . $model->person->PhotoName;
if (file_exists($file_entity)) {
$file_ext = substr(strrchr($file_entity, '.'), 1);
$res = $zip->addFile($file_entity, $model->PersonID . '.' . $file_ext);
if ($res) {
$count++;
}
}
}
$zip->close();
if ($count > 0) {
$this->redirect(Yii::app()->CreateUrl($zipname));
} else {
throw new CHttpException(400, 'Помилка: не знайдено жодного файлу фотографії.');
}
}
<?php
/* @var $this Specialitiescontroller */
/* @var $model Specialities */
$this->breadcrumbs = array('Specialities' => array('index'), 'Довідник ');
$this->menu = array(array('label' => 'Додати запис', 'url' => array('create'), 'icon' => "icon-plus"));
?>
<h1>Довідник "Спеціальності"</h1>
<?php
$controller = $this;
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'specialities-grid', 'type' => 'striped bordered condensed', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array(array('name' => 'SPEC', 'header' => 'Назва спеціальності', 'value' => '$data->SPEC', 'htmlOptions' => array('class' => 'span6')), array('name' => 'FacultetID', 'header' => 'Факультет', 'filter' => CHtml::listData(Facultets::model()->findAll(), "idFacultet", "FacultetFullName"), 'value' => '$data->facultet->FacultetFullName', 'htmlOptions' => array('class' => 'span2')), array('name' => 'PersonEducationFormID', 'header' => 'Форма', 'filter' => CHtml::listData(Personeducationforms::model()->findAll(), "idPersonEducationForm", "PersonEducationFormName"), 'value' => '$data->eduform->PersonEducationFormName', 'htmlOptions' => array('class' => 'span1')), array('class' => 'bootstrap.widgets.TbEditableColumn', 'name' => 'SpecialityBudgetCount', 'header' => 'Б', 'editable' => array('url' => $this->createUrl('specialities/xedit'), 'placement' => 'right', 'inputclass' => 'span3'), 'headerHtmlOptions' => array('title' => 'Кількість бюджетних місць'), 'htmlOptions' => array('class' => 'span1')), array('class' => 'bootstrap.widgets.TbEditableColumn', 'name' => 'SpecialityContractCount', 'header' => 'К', 'editable' => array('url' => $this->createUrl('specialities/xedit'), 'placement' => 'right', 'inputclass' => 'span3'), 'headerHtmlOptions' => array('title' => 'Кількість контракних місць'), 'htmlOptions' => array('class' => 'span1')), array('class' => 'bootstrap.widgets.TbEditableColumn', 'name' => 'Quota1', 'header' => 'ПК', 'editable' => array('url' => $this->createUrl('specialities/xedit'), 'placement' => 'right', 'inputclass' => 'span3'), 'headerHtmlOptions' => array('title' => 'Квота для тих, хто поступає поза конкурсом'), 'htmlOptions' => array('class' => 'span1')), array('class' => 'bootstrap.widgets.TbEditableColumn', 'name' => 'ZnoKoef1', 'header' => 'K1', 'editable' => array('url' => $this->createUrl('specialities/xedit'), 'placement' => 'right', 'inputclass' => 'span3'), 'headerHtmlOptions' => array('title' => 'Квота для тих, хто поступає поза конкурсом'), 'htmlOptions' => array('class' => 'span1')), array('class' => 'bootstrap.widgets.TbEditableColumn', 'name' => 'ZnoKoef2', 'header' => 'K2', 'editable' => array('url' => $this->createUrl('specialities/xedit'), 'placement' => 'right', 'inputclass' => 'span3'), 'headerHtmlOptions' => array('title' => 'Квота для тих, хто поступає поза конкурсом'), 'htmlOptions' => array('class' => 'span1')), array('class' => 'bootstrap.widgets.TbEditableColumn', 'name' => 'ZnoKoef3', 'header' => 'K3', 'editable' => array('url' => $this->createUrl('specialities/xedit'), 'placement' => 'right', 'inputclass' => 'span3'), 'headerHtmlOptions' => array('title' => 'Квота для тих, хто поступає поза конкурсом'), 'htmlOptions' => array('class' => 'span1')), array('header' => 'ЦН', 'value' => function ($data) use($controller) {
/* @var $data Specialities */
$types = array('info', 'warning', 'success', 'important', 'inverse');
$i = 0;
foreach ($data->specquotes as $squota) {
echo '<a href="' . Yii::app()->CreateUrl('specialityquotes/update', array('id' => $squota->idSpecialityQuotes)) . '" target="_blank" >';
$controller->widget('bootstrap.widgets.TbLabel', array('type' => $types[$i], 'label' => $squota->BudgetPlaces, 'htmlOptions' => array('title' => $squota->quota->QuotaName, 'style' => 'font-size: 12pt !important; width: 21px; text-align: center; font-family: Verdana;')));
echo "</a> ";
$i++;
}
}, 'headerHtmlOptions' => array('title' => 'Квота для тих, хто поступає за цільовим направленням'), 'htmlOptions' => array('class' => 'span1')), array('class' => 'bootstrap.widgets.TbButtonColumn', 'template' => '{view} {update} {delete}', 'buttons' => array(), 'htmlOptions' => array('class' => 'span2')))));
?>
<?php
echo $form->textField($model, 'SpecialityKode', array('class' => 'span12', 'size' => 40, 'maxlength' => 40));
?>
</div>
</div>
<?php
//------------------------------------------------------------------------------------------------------------------------------------//
?>
<div class="row-fluid">
<div class ="span4">
<?php
echo $form->labelEx($model, 'FacultetID');
?>
<?php
echo $form->dropDownList($model, 'FacultetID', Facultets::DropDown(), array('class' => 'span12', 'class' => 'span12'));
?>
</div>
</div>
<?php
//------------------------------------------------------------------------------------------------------------------------------------//
?>
<div class="row-fluid">
<div class ="span4">
<?php
echo $form->label($model, 'SpecialityClasifierCode');
?>
<?php
echo $form->textField($model, 'SpecialityClasifierCode', array('class' => 'span12', 'size' => 12, 'maxlength' => 12));
?>
</div>
$this->endWidget();
?>
</div>
</div>
</div>
</div>
<!-- ----------------------------------------------------------------------- -->
<div class="row-fluid">
<div class="well well-large span6">
<!-- Завантаження фото у вигляді архівів -->
<h3 id="photo7">Фото усіх зарахованих абітурієнтів</h3>
<div class="span12" id="photo7_block" style="display:none;">
<ul>
<?php
if (Yii::app()->user->checkAccess('showProperties')) {
foreach (Facultets::model()->findAll('1 ORDER BY FacultetFullName') as $faculty) {
echo '<li>' . CHtml::link($faculty->FacultetFullName . ' (zip-архів)', Yii::app()->CreateUrl("statistic/stat/getphotozip", array('id' => $faculty->idFacultet)));
echo '</li>';
}
} else {
?>
<h4>Недостатньо прав для перегляду</h4>
<?php
}
?>
</ul>
</div>
</div>
<div class="well well-large span5">
<h3 id="crossentrant"><a href="<?php
echo Yii::app()->createUrl('statistic/stat/crossentrant');
/**
* Формування XLS-файлу з рейтингом для усіх спеціальностей факультету
*/
public function actionRatingcontacts($id)
{
$reqToExcel = Yii::app()->request->getParam('toexcel', 0);
$specs_of_faculty = array();
$faculty_model = false;
if (is_numeric($id) && $id > 0) {
$fcriteria = new CDbCriteria();
$fcriteria->compare('FacultetID', $id);
$fcriteria->order = 'SpecialityName ASC, SpecialityDirectionName ASC, PersonEducationFormID ASC';
$specs_of_faculty = Specialities::model()->findAll($fcriteria);
$faculty_model = Facultets::model()->findByPk($id);
}
if (empty($specs_of_faculty) || !$faculty_model) {
throw new Exception("Помилка: для факультета з ID = " . $id . ' не знайшлося напрямів або такий не існує.');
}
$this->renderPartial('/personspeciality/ratingcontacts_header', array('Faculty' => $faculty_model->idFacultet, 'toexcel' => $reqToExcel));
foreach ($specs_of_faculty as $spec_model) {
$model = new Personspeciality();
$model->SepcialityID = $spec_model->idSpeciality;
$spec_quota_models = Specialityquotes::model()->findAll('SpecialityID=' . $model->SepcialityID);
$Speciality = Specialities::model()->findByPk($model->SepcialityID);
$Faculty = $Speciality->facultet->FacultetFullName;
$license = array();
$license_info = array();
$budget = intval($Speciality->SpecialityBudgetCount);
$license[3] = array(intval($Speciality->Quota1), 1);
$license[2] = array($budget, 1);
$license[1] = array(intval($Speciality->SpecialityContractCount), 1);
$license_info[0] = array('=====================', -1);
$license_info[1] = array('За кошти фізичних або юридичних осіб', $license[1][0]);
$license_info[2] = array('За кошти державного бюджету', $budget);
$license_info[3] = array('Поза конкурсом', $license[3][0]);
//var_dump($license_info);exit();
$rating_data = array();
$general_count = 0;
foreach ($spec_quota_models as $sqm) {
$model->quota_budget_places = intval($sqm->BudgetPlaces);
$license[$sqm->QuotaID] = array($model->quota_budget_places, 0);
$license_info[$sqm->QuotaID] = array($sqm->quota->QuotaName, $license[$sqm->QuotaID][0]);
$model->param_quotaID = $sqm->QuotaID;
$rating_data[$license_info[$sqm->QuotaID][0]] = $this->CreateRatingData($model->rating_search(0));
$general_count += count($rating_data[$license_info[$sqm->QuotaID][0]]);
}
$rating_data[$license_info[3][0]] = $this->CreateRatingData($model->rating_search(1));
$general_count += count($rating_data[$license_info[3][0]]);
$rating_data[$license_info[2][0]] = $this->CreateRatingData($model->rating_search(2));
$general_count += count($rating_data[$license_info[2][0]]);
$rating_data[$license_info[1][0]] = $this->CreateRatingData($model->rating_search(3));
$general_count += count($rating_data[$license_info[1][0]]);
$rating_data[$license_info[0][0]] = $this->CreateRatingData($model->rating_search(4));
$general_count += count($rating_data[$license_info[0][0]]);
//var_dump($rating_data);exit();
if ($general_count > 0) {
$_data = array('data' => $rating_data, 'Speciality' => implode(' ', array($Speciality->SpecialityClasifierCode, mb_substr($Speciality->SpecialityClasifierCode, 0, 1) == '6' ? $Speciality->SpecialityDirectionName : $Speciality->SpecialityName, empty($Speciality->SpecialitySpecializationName) ? "" : '(' . $Speciality->SpecialitySpecializationName . ')', 'форма: ' . $Speciality->eduform->PersonEducationFormName)), 'Faculty' => $Faculty, 'license_info' => $license_info);
$_data['contacts'] = 1;
$this->layout = '//layouts/clear';
$this->renderPartial('/personspeciality/rating_contacts', $_data);
}
unset($model);
}
$this->renderPartial('/personspeciality/ratingcontacts_footer', array());
}
