/**
* 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 = Subjects::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function codes($attribute, $params)
{
$flag = 0;
$subject = Subjects::model()->findAllByAttributes(array('batch_id' => $this->batch_id, 'is_deleted' => 0));
foreach ($subject as $subject_1) {
if ($subject_1->name == $this->name) {
$flag = 1;
}
}
if ($flag == 1) {
$this->addError($attribute, 'This subject is already added');
}
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Exams();
$model_1 = new ExamGroups();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Exams'])) {
//$model->attributes=$_POST['Exams'];
if (isset($_REQUEST['exam_group_id'])) {
$insert_id = $_REQUEST['exam_group_id'];
} else {
$model_1->attributes = $_POST['ExamGroups'];
$model_1->batch_id = $_REQUEST['id'];
$model_1->save();
$insert_id = Yii::app()->db->getLastInsertID();
}
$posts = Subjects::model()->findAll("batch_id=:x AND no_exams=:y", array(':x' => $_REQUEST['id'], ':y' => 0));
$list = $_POST['Exams'];
$count = count($list['subject_id']);
$j = 0;
for ($i = 0; $i < $count; $i++) {
if ($list['maximum_marks'][$i] != NULL and $list['minimum_marks'][$i] != NULL and $list['start_time'][$i] != NULL and $list['end_time'][$i] != NULL) {
$model = new Exams();
$model->exam_group_id = $insert_id;
$model->subject_id = $list['subject_id'][$i];
$model->maximum_marks = $list['maximum_marks'][$i];
$model->minimum_marks = $list['minimum_marks'][$i];
$model->start_time = $list['start_time'][$i];
$model->end_time = $list['end_time'][$i];
if ($model->start_time) {
$date1 = date('Y-m-d H:i', strtotime($model->start_time));
$model->start_time = $date1;
}
if ($model->end_time) {
$date2 = date('Y-m-d H:i', strtotime($model->end_time));
$model->end_time = $date2;
}
$model->grading_level_id = $list['grading_level_id'];
$model->weightage = $list['weightage'];
$model->event_id = $list['event_id'];
$model->created_at = $list['created_at'];
$model->updated_at = $list['updated_at'];
$model->save();
}
}
$this->redirect(array('exams/create', 'id' => $_REQUEST['id'], 'exam_group_id' => $_REQUEST['exam_group_id']));
}
$this->render('create', array('model' => $model, 'model_1' => $model_1));
}
public static function DropDown($SepcialityID = 0, $Level = 0)
{
$res = array();
$c = new CDbCriteria();
$c->order = 'SubjectName';
//if ($SepcialityID == 0){
foreach (Subjects::model()->findAll($c) as $record) {
$res[$record->idSubjects] = $record->SubjectName;
}
// } else {
//
// $ssubj = Specialitysubjects::model()->find("SpecialityID=:SpecialityID and LevelID = :LevelID",
// array(":SpecialityID"=>$SepcialityID,":LevelID"=>$Level));
// if (!empty($ssubj->subject)){
// $res[$ssubj->subject->idSubjects] = $ssubj->subject->SubjectName;
// } else {
// foreach(Subjects::model()->findAll() as $record) {
// $res[$record->idSubjects] = $record->SubjectName;
// }
// }
// }
return $res;
}
public function subjectname($data, $row)
{
$subject = Subjects::model()->findByAttributes(array('id' => $data->subject_id));
return $subject->name;
}
</table>
<h3><?php
echo Yii::t('examination', ' Enter exam related details here:');
?>
</h3>
<div class="tableinnerlist">
<table width="95%" cellspacing="0" cellpadding="0">
<?php
if (isset($_REQUEST['id'])) {
$posts = Subjects::model()->findAll("batch_id=:x AND no_exams=:y", array(':x' => $_REQUEST['id'], ':y' => 0));
if (count($posts) != 0) {
$c = count($posts);
$i = 1;
$j = 0;
foreach ($posts as $posts_1) {
$c--;
$checksub = Exams::model()->findByAttributes(array('exam_group_id' => $_REQUEST['exam_group_id'], 'subject_id' => $posts_1->id));
if ($checksub == NULL) {
if ($j == 0) {
?>
<?php
echo $form->labelEx($model, 'max_mark');
?>
<?php
echo $form->textField($model, 'max_mark', array('id' => 'max_mark'));
/**
* Метод асинхронно повертає список предметів ЗНО
*/
public function actionZno()
{
$models = Subjects::model()->findAll('idZNOSubject>0 ORDER BY SubjectName ASC');
$result = array();
foreach ($models as $model) {
/* @var $model Subjects */
$result[] = array('text' => $model->SubjectName, 'id' => $model->idSubjects);
}
echo CJSON::encode($result);
}
/**
* Deletes a particular model.
* If deletion is successful, the browser will be redirected to the 'admin' page.
* @param integer $id the ID of the model to be deleted
*/
public function actionDelete($id)
{
if (Yii::app()->request->isPostRequest) {
$model = ExamScores::model()->findByAttributes(array('id' => $id));
$student = Students::model()->findByAttributes(array('id' => $model->student_id));
$student_name = ucfirst($student->first_name) . ' ' . ucfirst($student->middle_name) . ' ' . ucfirst($student->last_name);
$exam = Exams::model()->findByAttributes(array('id' => $model->exam_id));
$subject_name = Subjects::model()->findByAttributes(array('id' => $exam->subject_id));
$examgroup = ExamGroups::model()->findByAttributes(array('id' => $exam->exam_group_id));
$batch = Batches::model()->findByAttributes(array('id' => $examgroup->batch_id));
$exam_name = ucfirst($subject_name->name) . ' - ' . ucfirst($examgroup->name) . ' (' . ucfirst($batch->name) . '-' . ucfirst($batch->course123->course_name) . ')';
$goal_name = $student_name . ' for the exam ' . $exam_name;
// we only allow deletion via POST request
$this->loadModel($id)->delete();
//Adding activity to feed via saveFeed($initiator_id,$activity_type,$goal_id,$goal_name,$field_name,$initial_field_value,$new_field_value)
ActivityFeed::model()->saveFeed(Yii::app()->user->Id, '22', $model->id, $goal_name, NULL, NULL, NULL);
// we only allow deletion via POST request
//$this->loadModel($id)->delete();
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
if (!isset($_GET['ajax'])) {
$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
}
} else {
throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
}
}
<?php
echo '<span>' . Yii::t('Batch', 'Notice') . '</span>';
?>
<?php
echo Yii::t('Batch', 'Time Table Not Created.');
?>
<br />
<?php
echo CHtml::link(Yii::t('Batch', 'Create Now'), array('weekdays/timetable', 'id' => $_REQUEST['id']));
?>
</div>
<?php
}
?>
<?php
$sub = Subjects::model()->findByAttributes(array('batch_id' => $batch->id));
if ($sub == NULL) {
?>
<div class="notifications nt_red">
<?php
echo '<span>' . Yii::t('Batch', 'Notice') . '</span>';
?>
<?php
echo Yii::t('Batch', 'No Subjects Added');
?>
.<br />
<?php
echo CHtml::link(Yii::t('Batch', 'Add Now'), array('#'), array('id' => 'add_subjects-side'));
?>
</div>
<?php
// 'Specialitysubjects'=>array('index'),
// 'Manage',
//);
$this->menu = array(array('label' => 'Перелік предметів напрямів', 'url' => array('admin'), 'icon' => "icon-plus"), array('label' => 'Додати предмет напрямкку', 'url' => array('create'), 'icon' => "icon-plus"));
Yii::app()->clientScript->registerScript('search', "\r\n\$('.search-button').click(function(){\r\n\t\$('.search-form').toggle();\r\n\treturn false;\r\n});\r\n\$('.search-form form').submit(function(){\r\n\t\$.fn.yiiGridView.update('specialitysubjects-grid', {\r\n\t\tdata: \$(this).serialize()\r\n\t});\r\n\treturn false;\r\n});\r\n");
?>
<h1>Управління предметами напрямків</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
$data = $model->search();
$Specialities = new Specialities();
$d = $Specialities->getSpecialityFullNames();
$this->widget('bootstrap.widgets.TbGroupGridView', array('id' => 'specialitysubjects-grid', 'type' => 'striped bordered condensed', 'dataProvider' => $data, 'filter' => $model, 'mergeColumns' => array('SpecialityID'), 'columns' => array(array('name' => 'SpecialityID', 'value' => '$data->speciality->SpecialityDirectionName." ".$data->speciality->SpecialitySpecializationName." (".
(($data->speciality->PersonEducationFormID==1)?("денна"):(($data->speciality->PersonEducationFormID==2)?("заочна"):("екстернат"))).")"', 'filter' => $d), array('name' => 'SubjectID', 'value' => '$data->subject->SubjectName', 'filter' => CHtml::listData(Subjects::model()->findAll(), "idSubjects", "SubjectName")), array('name' => 'LevelID', 'filter' => array("1" => "1", "2" => "2", "3" => "3"), "htmlOptions" => array("style" => "width: 100px")), array('name' => 'isProfile', 'filter' => array('1' => 'так', '0' => 'ні'), "htmlOptions" => array("style" => "width: 100px"), 'value' => '($data->isProfile)? "так":"ні"'), array('class' => 'bootstrap.widgets.TbButtonColumn'))));
public function actionBookSearch()
{
if (isset($_POST['search'])) {
if (isset($_POST['search']) && isset($_POST['text'])) {
$criteria = new CDbCriteria();
$criteria->compare('is_deleted', 0);
// normal DB field
$criteria->condition = 'is_deleted=:is_del';
$criteria->params = array(':is_del' => 0);
if ($_POST['search'] == 1) {
$sub = Subjects::model()->findByAttributes(array('name' => $_POST['text']));
if ($sub != NULL) {
$criteria->condition = 'subject LIKE :match';
$criteria->params = array(':match' => $sub->id . '%');
}
}
if ($_POST['search'] == 2) {
$criteria->condition = 'title LIKE :match';
$criteria->params = array(':match' => $_POST['text'] . '%');
}
if ($_POST['search'] == 3) {
$author = Author::model()->findByAttributes(array('author_name' => $_POST['text']));
if ($author != NULL) {
$criteria->condition = 'author LIKE :match';
$criteria->params = array(':match' => $author->auth_id . '%');
}
}
if ($_POST['search'] == 4) {
$criteria->condition = 'isbn LIKE :match';
$criteria->params = array(':match' => $_POST['text'] . '%');
}
}
$total = Book::model()->count($criteria);
$pages = new CPagination($total);
$pages->setPageSize(Yii::app()->params['listPerPage']);
$pages->applyLimit($criteria);
// the trick is here!
$posts = Book::model()->findAll($criteria);
$this->render('booksearch', array('list' => $posts, 'pages' => $pages, 'item_count' => $total, 'page_size' => Yii::app()->params['listPerPage']));
} else {
$this->render('booksearch');
}
}
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'specialitysubjects-form', 'enableAjaxValidation' => false));
$form = new TbActiveForm();
?>
<p class="help-block">Fields with <span class="required">*</span> are required.</p>
<?php
if (empty($SpecialityID)) {
$SpecialityID = 0;
}
echo CHtml::dropDownList("SpecialityID", $SpecialityID, Specialities::DropDown(), array('empty' => "", 'class' => 'span5'));
$c = new CDbCriteria();
$c->order = 'SubjectName';
$c->compare('idZNOSubject', '>0');
$data = CHtml::listData(Subjects::model()->findAll($c), "idSubjects", "SubjectName");
$dataCount = count($data);
?>
<div class ="row-fluid">
<?php
echo $form->error($models[0], "SpecialityID");
?>
</div>
<div class ="row-fluid">
<?php
foreach ($models as $i => $model) {
?>
<div class="span4">
<?php
echo $form->error($model, "[{$i}]SubjectID");
public function actionWhoHasSubjectTomorrow($subject_id)
{
$semester = Semesters::model()->actual();
if (!$semester) {
throw new CException('Нет семестра');
}
$tomorrow_date = (new DateTime())->add(new DateInterval("P1D"))->format('Y-m-d');
$tomorrow_time = strtotime($tomorrow_date);
if (Holiday::model()->findByAttributes(['date' => $tomorrow_date]) || date('N', $tomorrow_time) == 7) {
throw new CException('Завтра выходной');
}
$week_number = ($semester->week_number + (date('W', $tomorrow_time) - date('W', strtotime($semester->start_date)))) % 2 ? 1 : 2;
$week_day = date('N', $tomorrow_time);
/** @var Subjects $subject */
$subject = Subjects::model()->findByPk($subject_id);
if (!$subject) {
throw new CException('Нет такого предмета');
}
/** @var GroupReplace[] $replaces */
$replaces = $subject->getRelated('replaces', true, ['with' => 'group', 'condition' => 'date = :tomorrow_date', 'params' => [':tomorrow_date' => $tomorrow_date]]);
/** @var ScheduleElement[] $schedule_elements */
$schedule_elements = $subject->getRelated('schedule_elements', true, ['with' => 'group', 'condition' => 'week_number = :week_number AND week_day = :week_day AND semester_id = :semester_id', 'params' => [':week_number' => $week_number, ':week_day' => $week_day, ":semester_id" => $semester->id]]);
$schedule = [];
if ($schedule_elements) {
foreach ($schedule_elements as $schedule_element) {
/** @var GroupReplace $replace */
if ($replace = GroupReplace::model()->findByAttributes(['date' => $tomorrow_date, 'number' => $schedule_element->number, 'group_id' => $schedule_element->group_id])) {
if ($replace->subject_id != $subject_id) {
continue;
}
}
$schedule[$schedule_element->number][] = (int) $schedule_element->group->number;
}
}
if ($replaces) {
foreach ($replaces as $replace) {
if (!isset($schedule[$replace->number])) {
$schedule[$replace->number] = [];
}
if (!in_array((int) $replace->group->number, $schedule[$replace->number])) {
$schedule[$replace->number][] = (int) $replace->group->number;
}
}
}
ksort($schedule);
$schedule_text = 'У кого завтра ' . $subject->name . '?' . PHP_EOL;
if (count($schedule)) {
foreach ($schedule as $number => $groups) {
$schedule_text .= $number . ') ' . implode(', ', $groups) . PHP_EOL;
}
} else {
$schedule_text .= 'А мы не знаем :-(' . PHP_EOL;
}
$schedule_text .= PHP_EOL . 'Данные предоставлены проектом @studyschedule (Расписание ККЭП)';
$params = http_build_query(['owner_id' => $this->owner_id, 'message' => $schedule_text, 'from_group' => 1, 'access_token' => $this->access_token]);
if ($result = file_get_contents('https://api.vk.com/method/wall.post?' . $params)) {
var_dump(json_decode($result, true));
} else {
echo 'Error when send request...';
}
echo PHP_EOL;
}
public function actionUpdate($id)
{
$model = ExamScores::model()->findByAttributes(array('id' => $id));
$old_model = $model->attributes;
// For activity feed
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['ExamScores'])) {
$model->attributes = $_POST['ExamScores'];
$exam = Exams::model()->findByAttributes(array('id' => $_REQUEST['exam_id']));
if ($model->marks < $exam->minimum_marks) {
$model->is_failed = 1;
} else {
$model->is_failed = '';
}
if ($model->save()) {
// Saving to activity feed
$results = array_diff_assoc($model->attributes, $old_model);
// To get the fields that are modified.
foreach ($results as $key => $value) {
if ($key != 'updated_at') {
$student = Students::model()->findByAttributes(array('id' => $model->student_id));
$student_name = ucfirst($student->first_name) . ' ' . ucfirst($student->middle_name) . ' ' . ucfirst($student->last_name);
$subject_name = Subjects::model()->findByAttributes(array('id' => $exam->subject_id));
$examgroup = ExamGroups::model()->findByAttributes(array('id' => $exam->exam_group_id));
$batch = Batches::model()->findByAttributes(array('id' => $examgroup->batch_id));
$exam_name = ucfirst($subject_name->name) . ' - ' . ucfirst($examgroup->name) . ' (' . ucfirst($batch->name) . '-' . ucfirst($batch->course123->course_name) . ')';
$goal_name = $student_name . ' for the exam ' . $exam_name;
if ($key == 'is_failed') {
if ($value == 1) {
$value = 'Fail';
} else {
$value = 'Pass';
}
if ($old_model[$key] == 1) {
$old_model[$key] = 'Fail';
} else {
$old_model[$key] = 'Pass';
}
}
//Adding activity to feed via saveFeed($initiator_id,$activity_type,$goal_id,$goal_name,$field_name,$initial_field_value,$new_field_value)
ActivityFeed::model()->saveFeed(Yii::app()->user->Id, '21', $model->id, $goal_name, $model->getAttributeLabel($key), $old_model[$key], $value);
}
}
//END saving to activity feed
if ($_REQUEST['allexam'] == 1) {
$url = 'default/allexam';
} else {
$url = 'default/classexam';
}
$this->redirect(array($url, 'bid' => $_REQUEST['bid'], 'exam_group_id' => $_REQUEST['exam_group_id'], 'r_flag' => $_REQUEST['r_flag'], 'exam_id' => $_REQUEST['exam_id']));
}
}
$this->render('examination/examination', array('model' => $model));
}
$sel = '';
}
echo '<div class="formCon"><div class="formConInner"><div style="float:left; width:380px;"><span style="font-size:14px; font-weight:bold; color:#666;">Course</span> ';
echo CHtml::dropDownList('id', '', $data, array('prompt' => 'Select', 'onchange' => 'course()', 'id' => 'cou', 'options' => array($sel => array('selected' => true))));
echo '</div>';
echo '<div style="float:left; width:300px;"><span style="font-size:14px; font-weight:bold; color:#666;">Subject</span> ';
?>
<?php
$data_1 = array();
if (isset($_REQUEST['cou'])) {
$batches = Batches::model()->findAll("course_id=:x and is_deleted=:y", array(':x' => $_REQUEST['cou'], ':y' => 0));
/*$data_1=Subjects::model()->findAll(array('join' => 'JOIN batches ON batch_id = batches.id','condition'=>'batches.course_id=:id',
'params'=>array(':id'=>(int) $_REQUEST['cou'])));*/
$data_1 = CHtml::listData(Subjects::model()->findAll(array('join' => 'JOIN batches ON batch_id = batches.id', 'condition' => 'batches.course_id=:id and elective_group_id=:x', 'params' => array(':id' => (int) $_REQUEST['cou'], ':x' => 0))), 'id', 'batchname');
}
if (isset($_REQUEST['sub'])) {
$sel_1 = $_REQUEST['sub'];
} else {
$sel_1 = '';
}
echo CHtml::dropDownList('sub', '', $data_1, array('prompt' => 'Select', 'onchange' => 'course()', 'id' => 'sub', 'onchange' => 'batch()', 'options' => array($sel_1 => array('selected' => true))));
echo '<br/></div><div class="clear"></div></div></div>';
?>
<?php
if (isset($_REQUEST['sub'])) {
$emp_sub = EmployeesSubjects::model()->findAll("subject_id=:x", array(':x' => $_REQUEST['sub']));
if (count($emp_sub) == 0) {
echo '<br> <br>' . Yii::t('employees', '<i>No Employee assigned yet.</i>') . '<br> <br>';
public function actionRemove()
{
$val = $_GET['val1'];
$model = Batches::model()->findByPk($val);
$model->is_active = 0;
$model->is_deleted = 1;
$model->employee_id = ' ';
if ($model->save()) {
// Student Deletion
$students = Students::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($students as $student) {
//Making student user inactive
if ($student->uid != NULL and $student->uid != 0) {
$student_user = User::model()->findByAttributes(array('id' => $student->uid));
if ($student_user != NULL) {
$student_user->saveAttributes(array('status' => '0'));
}
}
//Making parent user inactive
$parent = Guardians::model()->findByAttributes(array('ward_id' => $student->id));
if ($parent->uid != NULL and $parent->uid != 0) {
$parent_user = User::model()->findByAttributes(array('id' => $parent->uid));
if ($parent_user != NULL) {
$parent_user->saveAttributes(array('status' => '0'));
}
}
$student->saveAttributes(array('is_active' => '0', 'is_deleted' => '1'));
// Student Deleted
}
// Subject Association Deletion
$subjects = Subjects::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($subjects as $subject) {
EmployeesSubjects::model()->DeleteAllByAttributes(array('subject_id' => $subject->id));
$subject->delete();
}
// Exam Group Deletion
$examgroups = ExamGroups::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($examgroups as $examgroup) {
// Exams Deletion
$exams = Exams::model()->findAllByAttributes(array('exam_group_id' => $examgroup->id));
foreach ($exams as $exam) {
//Exam Score Deletion
$examscores = ExamScores::model()->DeleteAllByAttributes(array('exam_id' => $exam->id));
$exam->delete();
//Exam Deleted
}
$examgroup->delete();
//Exam Group Deleted
}
//Fee Collection Deletion
$collections = FinanceFeeCollections::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($collections as $collection) {
// Finance Fees Deletion
$student_fees = FinanceFees::model()->DeleteAllByAttributes(array('fee_collection_id' => $collection->id));
$collection->delete();
// Fee Collection Deleted
}
//Fee Category Deletion
$categories = FinanceFeeCategories::model()->findAllByAttributes(array('batch_id' => $model->id));
foreach ($categories as $category) {
// Fee Particular Deletion
$particulars = FinanceFeeParticulars::model()->DeleteAllByAttributes(array('finance_fee_category_id' => $category->id));
$category->delete();
// Fee Category Deleted
}
//Timetable Entry Deletion
$periods = TimetableEntries::model()->DeleteAllByAttributes(array('batch_id' => $model->id));
//Class Timings Deletion
$class_timings = ClassTimings::model()->DeleteAllByAttributes(array('batch_id' => $model->id));
//Delete Weekdays
$weekdays = Weekdays::model()->DeleteAllByAttributes(array('batch_id' => $model->id));
}
echo $val;
}
<div class="formCon" style="width:60%">
<div class="formConInner" >
<?php
$exam = Subjects::model()->findByAttributes(array('id' => $model->subject_id));
$exam_group = ExamGroups::model()->findByAttributes(array('id' => $model->exam_group_id));
?>
<table width="50%">
<tr>
<td><strong><?php
echo Yii::t('examination', 'Examination:');
?>
</strong><?php
echo ucfirst($exam_group->name);
?>
</td>
<td><strong><?php
echo Yii::t('examination', 'Subject:');
?>
</strong><?php
echo ucfirst($exam->name);
?>
</td>
</tr>
</table>
</div>
</div>
<div class="formCon" style="width:60%">
public function actionAjax_delete()
{
$id = $_POST['id'];
$subject = Subjects::model()->findByAttributes(array('elective_group_id' => $id));
$timetable = TimetableEntries::model()->deleteAllByAttributes(array('subject_id' => $subject->id));
$examgroup = Exams::model()->deleteAllByAttributes(array('subject_id' => $subject->id));
EmployeeElectiveSubjects::model()->deleteAllByAttributes(array('subject_id' => $subject->id));
$subject->delete();
$deleted = $this->loadModel($id);
if ($deleted->delete()) {
echo json_encode(array('success' => true));
exit;
} else {
echo json_encode(array('success' => false));
exit;
}
}
public function actionSubject()
{
$data = Subjects::model()->findAll(array('join' => 'JOIN batches ON batch_id = batches.id', 'condition' => 'batches.course_id=:id', 'params' => array(':id' => (int) $_POST['id'])));
$data = CHtml::listData($data, 'id', 'name');
foreach ($data as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
* @copyright Copyright © 2011-2012 Spiros Kabasakalis
* @since 1.0
* @ver 1.3
-->
<?php
if (!$model->isNewRecord) {
$criteria = new CDbCriteria();
$criteria->condition = 'batch_id=:bat_id';
$criteria->params = array(':bat_id' => $model->batch_id);
$criteria->compare('is_deleted', 0);
}
$data = CHtml::listData(SubjectName::model()->findAll(), 'id', 'name');
?>
<?php
$data1 = CHtml::listData(Subjects::model()->findAll($criteria), 'id', 'name');
?>
<div id="subjects_form_con" class="client-val-form" style="width:350px">
<?php
if ($model->isNewRecord) {
?>
<h3 id="create_header"><?php
echo Yii::t('Subjects', 'Add New Subject');
?>
</h3>
<?php
} elseif (!$model->isNewRecord) {
?>
<h3 id="update_header"><?php
echo Yii::t('Subjects', 'Update Subject');
?>
break;
case 3:
return 'W<br>';
break;
case 4:
return 'T<br>';
break;
case 5:
return 'F<br>';
break;
case 6:
return 'S<br>';
break;
}
}
$subjects = Subjects::model()->findAll("batch_id=:x", array(':x' => $_REQUEST['id']));
//echo CHtml::dropDownList('batch_id','',CHtml::listData(Subjects::model()->findAll("batch_id=:x",array(':x'=>$_REQUEST['id'])), 'id', 'name'), array('empty'=>'Select Type'));
$model = new EmployeeAttendances();
if (isset($_REQUEST['id'])) {
if (!isset($_REQUEST['mon'])) {
$mon = date('F');
$mon_num = date('n');
$curr_year = date('Y');
} else {
$mon = $model->getMonthname($_REQUEST['mon']);
$mon_num = $_REQUEST['mon'];
$curr_year = date('Y');
}
$num = cal_days_in_month(CAL_GREGORIAN, $mon_num, $curr_year);
// 31
?>
<td align="center"><?php
echo Yii::t('library', 'Total Copies');
?>
</td>
<td align="center"><?php
echo Yii::t('library', 'Book Position');
?>
</td>
<td align="center"><?php
echo Yii::t('library', 'Shelf No');
?>
</td>
</tr>
<?php
foreach ($list as $list_1) {
$sub = Subjects::model()->findByAttributes(array('id' => $list_1->subject));
$author = Author::model()->findByAttributes(array('auth_id' => $list_1->author));
$total_copies = $list_1->copy + $list_1->copy_taken;
?>
<tr>
<td align="center"><?php
echo $sub->name;
?>
</td>
<td align="center"><?php
echo $list_1->title;
?>
</td>
<td align="center"><?php
echo $list_1->isbn;
?>
</h1>
<div class="formCon" >
<div class="formConInner">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10%">
<?php
//echo CHtml::dropDownList('',isset($_REQUEST['id'])? $_REQUEST['id'] : '',CHtml::listData(Subjects::model()->findAll(),'id','name'),
//array('prompt'=>'select', 'onchange'=>"javascript:booklist();", 'id'=>'id'));
echo CHtml::label(Yii::t('library', 'Subject'), '') . '</td><td> ';
$criteria = new CDbCriteria();
$criteria->compare('is_deleted', 0);
echo CHtml::dropDownList('subject', '', CHtml::listData(Subjects::model()->findAll($criteria), 'id', 'name'), array('prompt' => 'Select', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('/library/book/subjects'), 'update' => '#book_id', 'data' => 'js:$(this).serialize()'))) . '</td></tr><tr><td> </td></tr><tr><td>';
echo CHtml::label(Yii::t('library', 'Book'), '') . '</td><td>';
echo CHtml::dropDownList('book', '', array(), array('prompt' => 'Select', 'id' => 'book_id', 'submit' => array('/library/book/booklist')));
?>
</td>
</tr>
</table>
</div>
</div>
</div>
</td>
</tr>
</table>
<?php
}
}
//echo $form->labelEx($model,'class_timing_id');
?>
<?php
echo $form->hiddenField($model, 'class_timing_id', array('value' => $class_timing_id));
?>
<?php
//echo $form->error($model,'class_timing_id');
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><?php
echo $form->labelEx($model, Yii::t('timetable', 'subject_id'));
?>
</td>
<td><?php
echo $form->dropDownList($model, 'subject_id', CHtml::listData(Subjects::model()->findAll('batch_id=:x', array(':x' => $batch_id)), 'id', 'name'), array('prompt' => 'Select Subject', 'style' => 'width:200px;', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('TimetableEntries/dynamiccities'), 'update' => '#emp_id')));
?>
<?php
//echo $form->error($model,'subject_id');
?>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td><?php
echo $form->labelEx($model, Yii::t('timetable', 'employee_id'));
?>
</td>
<td><?php
<?php
for ($i = 0; $i < $count_timing; $i++) {
echo ' <td class="td">
<div onclick="" style="position: relative; ">
<div class="tt-subject">
<div class="subject">';
$set = TimetableEntries::model()->findByAttributes(array('batch_id' => $_REQUEST['id'], 'weekday_id' => $weekdays[6]['weekday'], 'class_timing_id' => $timing[$i]['id']));
if (count($set) == 0) {
$is_break = ClassTimings::model()->findByAttributes(array('id' => $timing[$i]['id'], 'is_break' => 1));
if ($is_break == NULL) {
echo CHtml::ajaxLink(Yii::t('weekdays', 'Assign'), $this->createUrl('TimetableEntries/settime'), array('onclick' => '$("#jobDialog' . $timing[$i]['id'] . $weekdays[6]['weekday'] . '").dialog("open"); return false;', 'update' => '#jobDialog' . $timing[$i]['id'] . $weekdays[6]['weekday'], 'type' => 'GET', 'data' => array('batch_id' => $_REQUEST['id'], 'weekday_id' => $weekdays[6]['weekday'], 'class_timing_id' => $timing[$i]['id']), 'dataType' => 'text'), array('id' => 'showJobDialog' . $timing[$i]['id'] . $weekdays[6]['weekday']));
} else {
echo Yii::t('weekdays', 'Break');
}
} else {
$time_sub = Subjects::model()->findByAttributes(array('id' => $set->subject_id));
if ($time_sub != NULL) {
echo $time_sub->name . '<br>';
}
$time_emp = Employees::model()->findByAttributes(array('id' => $set->employee_id));
if ($time_emp != NULL) {
echo '<div class="employee">' . $time_emp->first_name . '</div>';
}
echo CHtml::link('', array('timetableEntries/remove', 'id' => $set->id, 'batch_id' => $_REQUEST['id']), array('confirm' => 'Are you sure?', 'class' => 'delete'));
}
echo '</div>
</div>
</div>
<div id="jobDialog' . $timing[$i]['id'] . $weekdays[6]['weekday'] . '"></div>
</td>';
}
public function actionDeactivate($id)
{
$model = Courses::model()->findByPk($id);
$model->is_deleted = 1;
if ($model->save()) {
// Batch Deletion
$batches = Batches::model()->findAllByAttributes(array('course_id' => $id));
//Selecting all batches under the course with id = $id
foreach ($batches as $batch) {
// Student Deletion
$students = Students::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($students as $student) {
//Making student user inactive
if ($student->uid != NULL and $student->uid != 0) {
$student_user = User::model()->findByAttributes(array('id' => $student->uid));
if ($student_user != NULL) {
$student_user->saveAttributes(array('status' => '0'));
}
}
//Making parent user inactive
$parent = Guardians::model()->findByAttributes(array('ward_id' => $student->id));
if ($parent->uid != NULL and $parent->uid != 0) {
$parent_user = User::model()->findByAttributes(array('id' => $parent->uid));
if ($parent_user != NULL) {
$parent_user->saveAttributes(array('status' => '0'));
}
}
$student->saveAttributes(array('is_active' => '0', 'is_deleted' => '1'));
// Student Deleted
}
// Subject Association Deletion
$subjects = Subjects::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($subjects as $subject) {
EmployeesSubjects::model()->DeleteAllByAttributes(array('subject_id' => $subject->id));
$subject->delete();
}
// Exam Group Deletion
$examgroups = ExamGroups::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($examgroups as $examgroup) {
// Exams Deletion
$exams = Exams::model()->findAllByAttributes(array('exam_group_id' => $examgroup->id));
foreach ($exams as $exam) {
//Exam Score Deletion
$examscores = ExamScores::model()->DeleteAllByAttributes(array('exam_id' => $exam->id));
$exam->delete();
//Exam Deleted
}
$examgroup->delete();
//Exam Group Deleted
}
//Fee Collection Deletion
$collections = FinanceFeeCollections::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($collections as $collection) {
// Finance Fees Deletion
$student_fees = FinanceFees::model()->DeleteAllByAttributes(array('fee_collection_id' => $collection->id));
$transaction = FinanceTransaction::model()->DeleteAllByAttributes(array('collection_id' => $collection->id));
$collection->delete();
// Fee Collection Deleted
}
//Fee Category Deletion
$categories = FinanceFeeCategories::model()->findAllByAttributes(array('batch_id' => $batch->id));
foreach ($categories as $category) {
// Fee Particular Deletion
$particulars = FinanceFeeParticulars::model()->DeleteAllByAttributes(array('finance_fee_category_id' => $category->id));
$category->delete();
// Fee Category Deleted
}
//Timetable Entry Deletion
$periods = TimetableEntries::model()->DeleteAllByAttributes(array('batch_id' => $batch->id));
//Class Timings Deletion
$class_timings = ClassTimings::model()->DeleteAllByAttributes(array('batch_id' => $batch->id));
//Delete Weekdays
$weekdays = Weekdays::model()->DeleteAllByAttributes(array('batch_id' => $batch->id));
$batch->is_active = 0;
$batch->is_deleted = 1;
$batch->employee_id = ' ';
$batch->save();
// Batch Deleted
}
Yii::app()->user->setFlash('success', "Selected course is deleted!");
$this->redirect(array('managecourse'));
}
}
public function actionPdf()
{
$batch_name = Batches::model()->findByAttributes(array('id' => $_REQUEST['id']));
$exam = Exams::model()->findByAttributes(array('id' => $_REQUEST['examid']));
$examgroup = ExamGroups::model()->findByAttributes(array('id' => $exam->exam_group_id));
$subject = Subjects::model()->findByAttributes(array('id' => $exam->subject_id));
$filename = $batch_name->name . ' ' . $examgroup->name . ' ' . $subject->name . '.pdf';
# HTML2PDF has very similar syntax
$html2pdf = Yii::app()->ePdf->HTML2PDF();
$html2pdf->WriteHTML($this->renderPartial('scorepdf', array(), true));
$html2pdf->Output($filename);
}
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><?php
echo $form->labelEx($model, Yii::t('library', 'subject'));
?>
</td>
<td> </td>
<td><?php
$criteria = new CDbCriteria();
$criteria->compare('is_deleted', 0);
echo $form->dropDownList($model, 'subject', CHtml::listData(Subjects::model()->findAll($criteria), 'id', 'name'), array('prompt' => 'Select'));
?>
<?php
//echo $form->error($model,'subject');
?>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><?php
echo $form->labelEx($model, Yii::t('library', 'category'));
?>
if ($exam == NULL) {
echo '<tr><td align="center" colspan="4"><i>' . Yii::t('parentportal', 'No Assessments') . '</i></td></tr>';
} else {
$displayed_flag = '';
foreach ($exam as $exams) {
$exm = Exams::model()->findByAttributes(array('id' => $exams->exam_id));
$group = ExamGroups::model()->findByAttributes(array('id' => $exm->exam_group_id, 'result_published' => 1));
$grades = GradingLevels::model()->findAllByAttributes(array('batch_id' => $exams->grading_level_id));
$t = count($grades);
if ($group != NULL and count($group) > 0) {
echo '<tr>';
if ($exm != NULL) {
$displayed_flag = 1;
//$group=ExamGroups::model()->findByAttributes(array('id'=>$exm->exam_group_id));
echo '<td>' . $group->name . '</td>';
$sub = Subjects::model()->findByAttributes(array('id' => $exm->subject_id));
if ($sub->elective_group_id != 0 and $sub->elective_group_id != NULL) {
$student_elective = StudentElectives::model()->findByAttributes(array('student_id' => $student->id));
if ($student_elective != NULL) {
$electname = Electives::model()->findByAttributes(array('id' => $student_elective->elective_id, 'elective_group_id' => $sub->elective_group_id));
if ($electname != NULL) {
echo '<td>' . $electname->name . '</td>';
}
}
} else {
echo '<td>' . $sub->name . '</td>';
}
if ($group->exam_type == 'Marks') {
echo "<td>" . $exams->marks . "</td>";
} else {
if ($group->exam_type == 'Grades') {
public function actionAssign()
{
$model = new EmployeeElectiveSubjects();
$elective = Electives::model()->findByAttributes(array('id' => $_REQUEST['elect']));
$subject = Subjects::model()->findByAttributes(array('elective_group_id' => $elective->elective_group_id));
$model->employee_id = $_REQUEST['emp_id'];
$model->elective_id = $_REQUEST['elect'];
$model->subject_id = $subject->id;
$model->save();
$this->redirect(array('employeesSubjects/create', 'bid' => $_REQUEST['bid'], 'elect' => $_REQUEST['elect'], 'dep' => $_REQUEST['dep']));
}
