<?php /*?><?php $this->widget('zii.widgets.CListView', array( 'dataProvider'=>$dataProvider, 'itemView'=>'_view', )); ?><?php */ $data = CHtml::listData(Batches::model()->findAll("is_deleted=:x", array(':x' => 0)), 'id', 'name'); if (isset($_REQUEST['bat'])) { $sel = $_REQUEST['bat']; } else { $sel = ''; } echo CHtml::dropDownList('id', '', $data, array('prompt' => 'Select', 'onchange' => 'course()', 'id' => 'bat', 'options' => array($sel => array('selected' => true)))); echo '<br>'; if (isset($_REQUEST['bat'])) { // $results=PeriodEntries::model()->findAllBySql('SELECT month_date WHERE batch_id='.$_REQUEST['bat']); $dates = PeriodEntries::model()->findAll("MONTH(month_date)=:x AND batch_id=:y", array(':x' => 4, ':y' => $_REQUEST['bat'])); $num = count($dates); // 31 ?> <div class="atnd_Con"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <th>Name</th> <?php foreach ($dates as $dates_1) { echo '<th>' . date('D', strtotime($dates_1->month_date)) . '<span>' . date('d', strtotime($dates_1->month_date)) . '</span></th>'; $i = date('d', strtotime($dates_1->month_date)); } ?> </tr> <?php
public function actionPublish() { $model = new Weekdays(); $start_date = Configurations::model()->findByAttributes(array('id' => '13')); $end_date = Configurations::model()->findByAttributes(array('id' => '14')); $present = PeriodEntries::model()->findByAttributes(array('batch_id' => $_REQUEST['id'])); if (count($present) !== 0) { $perii = PeriodEntries::model()->findAll("batch_id=:x", array(':x' => $_REQUEST['id'])); foreach ($perii as $perii_1) { $perii_1->delete(); } //$this->redirect(array('timetable','id'=>$_REQUEST['id'])); } $i = 0; $date = strtotime(date("Y-m-d", strtotime($start_date->config_value)) . " +" . $i . " day"); do { $date = strtotime(date("Y-m-d", strtotime($start_date->config_value)) . " +" . $i . " day"); $week = date('N', strtotime(date('Y-m-d', $date))); if ($week == 1) { $day = 7; } else { $day = $week + 1; } $flag = Weekdays::model()->findByAttributes(array('batch_id' => $_REQUEST['id'], 'weekday' => $day)); if (count($flag) != 0) { $period = new PeriodEntries(); $period->month_date = date('Y-m-d', $date); $period->batch_id = $_REQUEST['id']; $period->save(); } else { $period = new PeriodEntries(); $period->month_date = date('Y-m-d', $date); $period->batch_id = $_REQUEST['id']; $period->save(); } $i++; /*{ $this->redirect(array('timetable','id'=>$_REQUEST['id'])); }*/ } while (date('Y-m-d', $date) == $end_date->config_value); //exit; $this->redirect(array('timetable', 'id' => $_REQUEST['id'])); /*$this->render('timetable',array( 'model'=>$model, ));*/ }
<li> <?php echo CHtml::link('<span>' . Yii::t('timetable', 'Set Week Days') . '</span>', array('/timetable/weekdays', 'id' => $_REQUEST['id']), array('class' => 'addbttn')); ?> </li> <li> <?php echo CHtml::link('<span>' . Yii::t('timetable', 'Set Class Timings') . '</span>', array('/timetable/classTiming', 'id' => $_REQUEST['id']), array('class' => 'addbttn last')); ?> </li> </ul> <div class="clear"></div> </div> </div> <?php $present = PeriodEntries::model()->findByAttributes(array('batch_id' => $_REQUEST['id'])); /*if($present!=NULL){ echo CHtml::link(Yii::t('timetable','Publish Time Table'), array('Weekdays/Publish', 'id'=>$_REQUEST['id']),array('class'=>'cbut')); }*/ ?> <?php $criteria = new CDbCriteria(array("order" => "STR_TO_DATE(start_time,'%h:%i%p') ASC")); $criteria->addCondition('batch_id=:x'); $criteria->params = array(':x' => $_REQUEST['id']); $timing = ClassTimings::model()->findAll($criteria); // Display pdf button only if there is class timings. if ($timing != NULL) { echo CHtml::link(Yii::t('timetable', 'Generate PDF'), array('Weekdays/pdf', 'id' => $_REQUEST['id']), array('class' => 'cbut', 'target' => '_blank')); }