<?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'));
}
