public function getClasses() { return ClassInfo::model()->findAllBySql('select class_info.* from class_info left join instructor_assignment on instructor_assignment.class_id = class_info.id where instructor_assignment.instructor_id = :iid and class_info.session_id = :sid', array('sid' => ClassSession::savedSessionId(), 'iid' => $this->id)); }
public function getClasses() { return ClassInfo::model()->findAllBySql('select class_info.* from signup left join class_info on signup.class_id = class_info.id where signup.student_id = :stid and class_info.session_id = :ssid', array('ssid' => ClassSession::savedSessionId(), 'stid' => $this->id)); }
public function actionAutoPopulate() { foreach (ClassInfo::model()->findAllBySQL("select class_info.* from class_info where session_id = :sess", array('sess' => ClassSession::savedSessionId())) as $model) { if ($model->active_mtg_count < 1) { $model->populate_meetings(Yii::app()->params['defaultNumMeetings']); } } //TODO: flash it! $this->redirect($this->redirect(Yii::app()->user->returnUrl)); }
<div class="row"> <?php echo $form->labelEx($model, 'class_id'); if (isset($model->class_id) && !$model->hasErrors()) { echo CHtml::encode($model->class->summary); echo $form->hiddenField($model, "class_id"); } else { $classparams = array(); $constraint = ""; if (isset($model->instructor_id)) { $classparams = array('condition' => 'company_id = :coid', 'params' => array(':coid' => $model->instructor->company_id)); $constraint = " (this instructor is " . $model->instructor->company->name . ')'; } echo $form->dropDownList($model, 'class_id', CHtml::listData(ClassInfo::model()->findAll($classparams), 'id', 'summary')); echo $constraint; } echo $form->error($model, 'class_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'percentage'); ?> <?php echo $form->textField($model, 'percentage', array('size' => 3, 'maxlength' => 3)); echo CHtml::encode(' %'); ?>
<h3>Choose class to copy from <?php echo $fromsession->summary; ?> to <?php echo ClassSession::current()->summary; ?> </h3> <?php echo CHtml::form(); echo CHtml::dropDownList('ClassInfo[id]', '', CHtml::listData(ClassInfo::model()->findAllBySql('select class_info.* from class_info where session_id = :sid', array('sid' => $fromsession->id)), 'id', 'summary'), array('submit' => '', 'empty' => 'Choose One')); echo CHtml::submitButton('Change'); echo CHtml::endForm();
<?php return array('title' => 'Enter a check', 'showErrorSummary' => true, 'elements' => array('check' => array('type' => 'form', 'title' => 'Check Details', 'showErrorSummary' => true, 'elements' => array('amount' => array('type' => 'text', 'maxlength' => 20), 'check_num' => array('type' => 'text', 'maxlength' => 10), 'check_date' => array('type' => 'zii.widgets.jui.CJuiDatePicker', 'attribute' => 'check_date', 'model' => 'check', 'options' => array('showAnim' => 'fold', 'showButtonPanel' => true, 'autoSize' => true, 'dateFormat' => 'yy-mm-dd')), 'payee_id' => array('items' => CHtml::listData(Company::model()->findAll(), 'id', 'name'), 'type' => 'dropdownlist'), 'payer' => array('type' => 'text', 'maxlength' => 128), 'deposit_id' => array('items' => CHtml::listData(DepositDetails::model()->findAll(), 'id', 'deposited_date'), 'type' => 'dropdownlist'))), 'income' => array('type' => 'form', 'title' => 'Apply Payment', 'showErrorSummary' => true, 'elements' => array('student_id' => array('maxlength' => 10, 'prompt' => "Choose student...", 'items' => CHtml::listData(Student::model()->findAll(), 'id', 'full_name'), 'type' => 'dropdownlist'), 'class_id' => array('maxlength' => 10, 'prompt' => "Choose class...", 'items' => CHtml::listData(ClassInfo::model()->findAll(), 'id', 'class_name'), 'type' => 'dropdownlist'), 'amount' => array('type' => 'text', 'maxlength' => 10)))), 'buttons' => array('entry_form' => array('type' => 'submit', 'label' => 'Save')));
</div> <div class="row"> <?php echo $form->labelEx($model, 'class_id'); ?> <?php // I cannot use the multiendeddropdown here, because of the odd dropdown if (isset($model->class_id) && !$model->hasErrors()) { echo CHtml::encode($model->class->summary); echo $form->hiddenField($model, "class_id"); } else { echo $form->dropDownList($model, 'class_id', array('In Grade Range' => CHtml::listData(ClassInfo::model()->findAll('(:grade >= min_grade_allowed and :grade <= max_grade_allowed) and session_id = :sid', array('grade' => $model->student->grade, 'sid' => ClassSession::savedSessionId())), 'id', 'summary'), 'Outside Grade Range' => CHtml::listData(ClassInfo::model()->findAll('(:grade < min_grade_allowed or :grade > max_grade_allowed) and session_id = :sid', array('grade' => $model->student->grade, 'sid' => ClassSession::savedSessionId())), 'id', 'summary')), array('class' => 'chzn-select', 'empty' => 'Choose One', 'ajax' => array('type' => 'POST', 'dataType' => 'json', 'data' => 'js:{id:$("#Signup_class_id").val()}', 'url' => CController::createUrl('ClassInfo/json'), 'success' => "function(data){\n\$('#Signup_additional_info').text( data['enrolled_count'] + ' signed up (' + data['max_students'] + ' max)');\nif(parseInt(data['enrolled_count']) > parseInt(data['max_students'])){\n \$('#Signup_status').val('Waitlist');\n} else{\n \$('#Signup_status').val('Enrolled');\n}\n;}"))); } ?> <?php echo $form->error($model, 'class_id'); ?> <div id="Signup_additional_info" class="infoMessage" ></div> </div> <div class="row">
<?php $es = $form->errorSummary($model); if (isset($es)) { echo '<tr><td colspan="5">' . $es . '</td></tr>'; } ?> <tr> <td> <?php // I cannot use the multiendeddropdown here, because of the odd dropdown if (isset($model->class_id) && !$model->hasErrors()) { echo CHtml::encode($model->class->summary); echo $form->hiddenField($model, "[{$index}]class_id"); } else { echo $form->dropDownList($model, "[{$index}]class_id", array('In Grade Range' => CHtml::listData(ClassInfo::model()->findAll('(:grade >= min_grade_allowed and :grade <= max_grade_allowed) and session_id = :sid', array('grade' => $model->student->grade, 'sid' => ClassSession::savedSessionId())), 'id', 'summary'), 'Outside Grade Range' => CHtml::listData(ClassInfo::model()->findAll('(:grade < min_grade_allowed or :grade > max_grade_allowed) and session_id = :sid', array('grade' => $model->student->grade, 'sid' => ClassSession::savedSessionId())), 'id', 'summary')), array('class' => 'chzn-select', 'empty' => "Choose a class")); } echo $form->error($model, "[{$index}]class_id"); echo '<div id="Signup_' . $index . '_additional_info" >'; ?> </td> <td> <?php echo $form->textField($model, "[{$index}]signup_date", array('size' => 20)); echo $form->error($model, "[{$index}]signup_date"); ?> </td>
public function actionIntegrityCheck() { $unassigned = CheckIncome::model()->findAllBySql("select check_income.*\nfrom check_income\nleft join (select sum(income.amount) as total, \n income.check_id as check_id\n from income\n group by income.check_id) as assigned\non assigned.check_id = check_income.id\nwhere coalesce(assigned.total,0) != coalesce(check_income.amount,0)\nand (check_income.returned is null or check_income.returned < '2000-01-01')\nand check_income.session_id = :sid\n", array('sid' => ClassSession::savedSessionId())); $instructorbalance = ClassInfo::model()->findAllBySql("select class_info.*\nfrom class_info\nleft join (select sum(instructor_assignment.percentage) as total, \n instructor_assignment.class_id as class_id\n from instructor_assignment\n group by instructor_assignment.class_id) as assigned\non assigned.class_id = class_info.id\nwhere coalesce(assigned.total,0) != 100\nand class_info.session_id = :sid\n", array('sid' => ClassSession::savedSessionId())); $this->render('integrity_check', array('unassigned' => $unassigned, 'instructorbalance' => $instructorbalance)); }
public static function findAllWeekdays($weekdays, $session) { $classes = array(); // only weekdays, no sat/sun foreach ($weekdays as $n) { // XXX the current session is hardcoded in here! // needs to be defaulted programatically and saved in cookie! foreach (ClassInfo::model()->findAllBySql("select class_info.* \nfrom class_info\nwhere class_info.day_of_week = :wkd\n and class_info.session_id = :sess\norder by class_info.class_name\n; ", array('wkd' => $n, 'sess' => $session)) as $c) { $classes[$n][] = $c; } } return $classes; }
function getClasses() { return ClassInfo::model()->findAllBySql("select class_info.*\nfrom class_info\nleft join instructor_assignment\n on instructor_assignment.class_id = class_info.id\nleft join instructor\n on instructor_assignment.instructor_id = instructor.id\nwhere instructor.company_id = :id\n and class_info.session_id = :sid\norder by class_info.class_name asc", array('id' => $this->id, 'sid' => ClassSession::savedSessionId())); }
/** * Gives the class status as json */ public function actionJson() { $model = ClassInfo::model()->findByPk($_POST['id']); echo CJSON::encode(array('min_grade_allowed' => $model->min_grade_allowed, 'max_grade_allowed' => $model->max_grade_allowed, 'min_students' => $model->min_students, 'max_students' => $model->max_students, 'cost_per_class' => $model->cost_per_class, 'enrolled_count' => $model->enrolled_count)); }