This is my controler.
public function actionAdmin()
{
/* fix for search */
if(isset($_GET['dispId']))
{
return $this->actionDView($_GET["dispId"]);
}
$model=new Tasks('search');
$model->unsetAttributes(); // clear any default values
if(isset($_GET['Tasks']))
$model->attributes=$_GET['Tasks'];
$data = Yii::app()->db->createCommand()
->select('t.*,e.v_first_name,s.v_status_text')
->from('tasks t')
->join('routes r', 'r.b_id=t.b_route_id')
->join('employee_users e', 'e.b_id=r.b_employee_id')
->join('status s', 's.b_id=t.b_status_id')
->where('t.b_status_id !=2 and t.b_status_id !=6 and t.b_status_id !=9 and t.v_status="enable" and r.v_route_status="Active" and r.v_status="enable" and s.v_status != "enable_admin"')
->order(array('t.b_id desc'))
->limit(200)
->queryAll();
//print_r($user);exit;
//print_r($data);exit;
//$empname = EmployeeUsers::model()->findAll(array("condition"=>"v_status = 'enable'"));
//$routs = Yii::app()->db->createCommand()->select(array())->from('routes')->where(array('and',"v_status='enable'"))->order('b_employee_id'." ".'ASC')->queryAll();
$empname = Yii::app()->db->createCommand()
->select('r.b_id,eu.v_first_name,r.v_route')
->from('employee_users eu')
->join('routes r', 'r.b_employee_id=eu.b_id')
->where('eu.v_status="enable" and r.v_route_status="Active" and r.v_status="enable" ')
->order(array('eu.b_id ASC'))
->queryAll();
//print_r($empname);exit;
//$task = $model->findAll(array("condition"=>"v_status = 'enable' order by b_id asc"));
$maxloop = Yii::app()->db->createCommand()
->select('count(b_route_id) as m')
->from('tasks t')
->join('status s', 's.b_id=t.b_status_id')
->where('t.b_status_id !=2 and t.b_status_id !=6 and t.b_status_id !=9 and t.v_status="enable"')
->group('b_route_id')
->order(array('m desc'))
->limit(1)
->queryAll();
//print_r($maxloop);exit;
//echo $maxloop[0]['m'];exit;
$this->render('admin',array(
//'model'=>$model,
'empname'=>$empname,
//'routs'=>$routs,
//'task'=>$task,
'data'=>$data,
'maxloop'=>$maxloop,
));
}
//ajax filter status
and this is my model
public function search()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria=new CDbCriteria;
$criteria->compare('b_id',$this->b_id,true);
$criteria->compare('b_taskperformed_id',$this->b_taskperformed_id,true);
$criteria->compare('b_route_id',$this->b_route_id,true);
$criteria->compare('b_status_id',$this->b_status_id,true);
$criteria->compare('b_payment_id',$this->b_payment_id,true);
$criteria->compare('b_old_status_id',$this->b_old_status_id,true);
$criteria->compare('v_dispatch_id',$this->v_dispatch_id,true);
$criteria->compare('t_task',$this->t_task,true);
$criteria->compare('create_time',$this->create_time,true);
$criteria->compare('update_time',$this->update_time,true);
$criteria->compare('v_status','enable',true);
$criteria->compare('i_ip',$this->i_ip);
$criteria->compare('t_note',$this->t_note,true);
$criteria->compare('b_part1_id',$this->b_part1_id,true);
$criteria->compare('b_part2_id',$this->b_part2_id,true);
$criteria->compare('b_part3_id',$this->b_part3_id,true);
$criteria->compare('b_part4_id',$this->b_part4_id,true);
$criteria->compare('b_part5_id',$this->b_part5_id,true);
$criteria->compare('b_part6_static_id',$this->b_part6_static_id,true);
$criteria->compare('t_part_note',$this->t_part_note,true);
$criteria->limit =5;
return new CActiveDataProvider(get_class($this), array(
'pagination'=>false,
'criteria'=>$criteria,
));
}
and this is admin view
<!–<script>
timer(j=14,i=60);
function timer(j,i)
{
//alert(j);
myVar = setInterval(
function()
{
// if(i>=0)
//{
//}
/*if(i==0)
{
$('.Timer').text('Page Refreshing...');
//location.reload(true);
//$('.Timer').text('');
}*/
i--;
if(i==-1)
{
j--;
timer(j,i=59);
}
if(j==0)
{
i=0;
}
$('.Timer').text("Time Left : "+pad(j)+':'+pad(i));
if(j==0)
{
//alert(j);
//setTimeout(function(){location.reload(true);},1000);
location.reload(true);
}
}, 1000);
//setTimeout(function(){location.reload(true);},900000);
//setTimeout(function(){location.reload(true);},59000);
}
function pad(n) {
return (n < 10) ? ("0" + n) : n;
}
</script>–>
<script type="text/javascript">
setTimeout(function(){location.reload(true);},900000);
$(document).ready(function() {
/*$('#taskupdate').fixheadertable({
height : 450,
minWidthAuto : true,
pager : true
});*/
//$('#taskupdate').dataTable();
/*$('#taskupdate').dataTable( {
"sScrollY": "200px",
"bPaginate": false
});*/
});
//$(window).bind("load", function() {
// code here
$('.btn-toolbar').css('top','-105px');
//$('.dataTables_scrollBody').css('height','300px');
//});
function setreturnurl(){
//alert('<?php echo Yii::app()->request->url;?>');return false;
<?php Yii::app()->user->setState("taskreturnurl",Yii::app()->request->url);?>
}
</script>
<style>
/*a.lnkdispatch{
color: #0088CC !important;
text-decoration: none;
}
#taskupdate_length{
display:none;
}
#taskupdate_filter{
display:none;
}
.ui-icon{
display:none;
}
#content.container-fluid.btn-toolbar{
position:relative;
float:right;
top:-105px !important;
}*/
.alert{
margin-bottom:0px !important;
}
</style>
<?php
/* @var $this TasksController */
/* @var $model Tasks */
$s = explode(’/’,$_SERVER[‘REQUEST_URI’]);
if(isset($s)){
$sa = isset($s[6]) ? $s[6] : '12';
}else{
$sa = '12';
}
//echo $sa;
$this->breadcrumbs=array(
'Tasks'=>array('admin'),
'Manage',
'titlecustom'=>'Manage Tasks',
);
$this->menu=array(
array('label'=>'<i class="icon-plus" style="vertical-align:text-bottom;"></i>&nbsp;Create Tasks', 'url'=>array('create'),'linkOptions'=> array('class' => 'btn btn-primary')),
);
Yii::app()->clientScript->registerScriptFile(Yii::app()->baseUrl . ‘/js/custom.js’);
?>
<!–<div class="Timer" style="left: -25px;position: relative;text-align: right;top: 20px;">Time Left : 15:00</div>–>
<link rel="stylesheet" href="<?php echo Yii::app()->request->baseUrl; ?>/css/fullcalendar.css" />
<input type="hidden" id="hdnbaseurl" value="<?php echo Yii::app()->request->baseUrl; ?>">
<div style="margin-left: 250px; position: absolute; top: 30px;" >
<form action="<?php echo Yii::app()->request->baseUrl; ?>/admin/tasks/admin" method="get" class="form-inline">
<div class="form-group">
<?php
$statuslist = CHtml::listData(Status::model()->findAll(array("condition"=>"v_status like 'enable%'")), 'b_id', 'v_status_text');
//$statuslist = CHtml::listData(Status::model()->findAll(array("condition"=>"v_status = 'enable'")), 'b_id', 'v_status_text');
//$statuslist['0']='All Status';
$statuslist['12']='Current Dispatch';
//echo CHtml::dropDownList('statusname',$sa, $statuslist,array('options' => array('12'=>array('selected'=>true))));
echo CHtml::dropDownList('statusname',$sa, $statuslist);
//echo CHtml::dropDownList('statusname',$sa, $statuslist,array('empty'=>array('0'=>'All Status')));
?>
<input type="search" placeholder="Dispatchid" name="dispId" value="<?=isset($_GET['dispId']) ? CHtml::encode($_GET['dispId']) : '' ; ?>" />
<input class="btn btn-primary" type="submit" value="Search" />
</div>
</form>
<br>
</div>
<div class="container-fluid">
<div class="row-fluid">
<div class="span12" style="margin-top: -75px;">
<div id="statusMsg">
<?php
foreach(Yii::app()->user->getFlashes() as $key => $message) {
echo '<div class="alert alert-' . $key . '"><button class="close" data-dismiss="alert">×</button>' . $message . "</div>\n";
}
?>
<?php if(Yii::app()->user->hasFlash('error')):?>
<?php echo Yii::app()->user->getFlash('error'); ?>
<?php endif; ?>
</div>
<div class="widget-box widget-calendar">
<div class="widget-title">
<span class="icon"><i class="icon-calendar"></i>
</span>
<h5>Manage Tasks</h5>
<!--<div class="buttons"> <a id="add-event" data-toggle="modal" href="#modal-add-event" class="btn btn-success btn-mini"><i class="icon-plus icon-white"></i> Add new event</a>
<div class="modal hide" id="modal-add-event">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h3>Add a new event</h3>
</div>
<div class="modal-body">
<p>Enter event name:</p>
<p>
<input type="text" id="event-name">
</p>
</div>
<div class="modal-footer"> <a href="#" class="btn" data-dismiss="modal">Cancel</a> <a href="#" id="add-event-submit" class="btn btn-primary">Add event</a> </div>
</div>
</div>-->
</div>
<div class="widget-content nopadding">
<div class="panel-left" style="margin-right: 0px;">
<div id="fullcalendar" class="fc">
<div style="width: 100%" class="fc-header">
<!--<div>
<div class="fc-header-left"><span class="fc-button fc-button-prev fc-state-default fc-corner-left"><span class="fc-button-inner"><span class="fc-button-content"></span></span></span><span class="fc-button fc-button-next fc-state-default fc-corner-right"><span class="fc-button-inner"><span class="fc-button-content"></span></span></span></div>
<div class="fc-header-center"><span class="fc-header-title"><strong>January 2014</strong></span></div>
<div class="fc-header-right"><span class="fc-button fc-button-month fc-state-default fc-corner-left fc-state-active"><span class="fc-button-inner"><span class="fc-button-content">month</span></span></span><span class="fc-button fc-button-basicWeek fc-state-default"><span class="fc-button-inner"><span class="fc-button-content">week</span></span></span><span class="fc-button fc-button-basicDay fc-state-default fc-corner-right"><span class="fc-button-inner"><span class="fc-button-content">day</span></span></span></div>
</div>-->
</div>
<div style="position: relative; min-height: 1px;" class="fc-content">
<div style="position: relative; -moz-user-select: none;" class="fc-view fc-view-month fc-grid" unselectable="on">
<table cellspacing="0" style="width: 100%" class="data-table" id="taskupdate">
<thead>
<tr class="fc-first fc-last">
<?php //print_r($empname);exit;
//echo count($empname);exit;
if(count($empname) > 0){
for($i=0;$i<count($empname);$i++)
{//echo $empname[$i]->v_route;exit;
?>
<th class="fc-mon fc-widget-header" style="font-size: 16px;"><?php echo $empname[$i]['v_first_name'].'<br/>('.$empname[$i]['v_route'].')';?></th>
<?php
$emparrayids[$i]=$empname[$i]['b_id'];
}
}else{
?>
<th class="fc-mon fc-widget-header" style="font-size: 16px;"></th>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
for($m=0;$m<count($empname);$m++)
{
for($n=0;$n<count($data);$n++)
{
if($empname[$m]['b_id']==$data[$n]['b_route_id'])
{
$col[$m][] = $data[$n]['b_id'].'||||'.$data[$n]['v_dispatch_id'].'|||||'.$data[$n]['v_status_text'].'|||||'.date('m-d-Y',strtotime($data[$n]['create_time']));
}
}
}
// unset($data);
if(isset($maxloop[0]['m']))
{
for($j=0;$j<$maxloop[0]['m'];$j++)
{
?>
<tr class="fc-week1">
<?php
for($k=0;$k<count($empname);$k++)
{
?>
<td class="fc-sun fc-widget-content">
<div style="min-height: 80px; min-width: 100px;">
<div style="text-align: center !important; padding: 3px 5px;">
<?php
if(isset($col[$k][$j]))
{
$temp = explode('|||||',$col[$k][$j]);
for($y=0;$y<count($temp);$y++)
{
if($y==0)
{
$temp1 = explode('||||',$col[$k][$j]);
?>
<?php /*?><a href="<?php echo Yii::app()->request->baseUrl; ?>/admin/tasks/update/id/<?php echo $temp1[0]; ?>"><?php echo $temp1[1]."<br/>"; ?></a><?php */?>
<a onclick="setreturnurl();" class="lnkdispatch" href="<?php echo Yii::app()->request->baseUrl; ?>/admin/tasks/view/id/<?php echo $temp1[0]; ?>"><?php echo $temp1[1]."<br/>"; ?></a>
<?php
}
else
{
echo $temp[$y]."<br/>";
}
}
}
?>
</div>
<div class="fc-day-content">
<div style="position: relative; height: 0px;">&nbsp;</div>
</div>
</div>
</td>
<?php
}
?>
</tr>
<?php
}
//unset($col);
}
else
{
?>
<tr class="fc-week1">
<td class="fc-sun fc-widget-content" colspan="20">
<div style="min-height: 109px;">
<div style="text-align: center !important; padding: 40px;"> No Task Created.</div>
<div class="fc-day-content">
<div style="position: relative; height: 0px;">&nbsp;</div>
</div>
</div>
</td>
</tr>
<?php
}
?>
</tbody>
</div>
</div>
</div>
</div>
</table>
<div style="position: absolute; z-index: 8; top: 0; left: 0"></div>
</div>
</div>
</div>
</div>
<!--<div id="external-events" class="panel-right">
<div class="panel-title">
<h5>Events</h5>
</div>
<div class="panel-content">
<div class="external-event ui-draggable label label-inverse" style="position: relative;">My Event 1</div>
<div class="external-event ui-draggable label label-inverse" style="position: relative;">My Event 2</div>
<div class="external-event ui-draggable label label-inverse" style="position: relative;">My Event 3</div>
<div class="external-event ui-draggable label label-inverse" style="position: relative;">My Event 4</div>
<div class="external-event ui-draggable label label-inverse" style="position: relative;">My Event 5</div>
</div>
</div>
</div>-->
</div>
</div>
</div>
<div class="row-fluid">
</div>
</div>
<?php
//Yii::app()->clientScript->registerScriptFile(Yii::app()->baseUrl . '/js/fullcalendar.min.js');
//Yii::app()->clientScript->registerScriptFile(Yii::app()->baseUrl . '/js/unicorn.calendar.js');
?>
</div>
please tell me how i set the pagination in data table.