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