yii1.1分页，上车活动

清疚 2022-06-09 09:06 146阅读 0赞

//控制器

public function actionIndex()
    {
        $user_id =Yii::app()->user->id;
           $model = array('id'=>'','driver'=>'');
           $criteria = new CDbCriteria();
           #post请求赋值
           if (Yii::app()->request->isPostRequest) {
               foreach ($model as $key => $val) {
                   if (isset($_POST[$key]) && $_POST[$key] !== '' && $_POST[$key] !== 'null')
                       $model[$key] = $_POST[$key]; //给model赋值
               }
           }
           if(Yii::app()->request->getParam('id'))
           {
               $criteria->compare('id',Yii::app()->request->getParam('id'));
           }
           if(Yii::app()->request->getParam('name'))
           {
               $criteria->compare('driver',Yii::app()->request->getParam('name'));
           }
           $criteria->compare('car_type',1);
           $criteria->compare('check_status',1);
           $criteria->order = 'upcart_amount desc';
           $result = CarUserCar::model()->count($criteria);

//分页
           $pager = new CPagination($result);
           $pager->pageSize = 6;
           $pager->applyLimit($criteria);
           $list = CarUserCar::model()->findAll($criteria);
           $carUserUpcar = CarUserUpcar::model()->findAllByAttributes(array('user_id' => $user_id));
           $carUserUpcar = PublicFunHelper::arrayKey($carUserUpcar,"car_id");
       $this->render('index',compact('list','result','carUserUpcar','pager'));
    }

//HTML代码

<div class="box paihang_list">	 <div class="clear"></div>
    <div style="width: 100%;margin-top: 4.4rem;float:left;">
        <img style="width: 100%;display: block;" src="<?php echo Yii::app()->versionUrl->changeUrl(COMMONSTATICFILE."/1st_Anniversary_Celebration/images/car_rank.png") ?>">
    </div>
    <div class="search" style="float: left;margin-top: 0;">
        <form method="get" action="#" enctype="multipart/form-data">
            <label>ID:</label><p><span class="layer"></span><input type="text" name="id" value=""></p>
            <label>老司机名:</label><div><span class="layer"></span><input type="text" name="name"></div>
            <a href="javascript:;" ><input type="submit" value="搜索" ></a>
        </form>
    </div>
    <div class="clear"></div>
    <div class="content">
        <div class="top">
            <div class="layer"></div>
            <ul>
                <li>排名</li>
                <li>ID</li>
                <li>老司机</li>
                <li>速度值</li>
                <li><img src="<?php echo Yii::app()->versionUrl->changeUrl(COMMONSTATICFILE."/1st_Anniversary_Celebration/images/car3.png" )?>"></li>
            </ul>
        </div>
        <div class="con">
            <div class="layer"></div>
            <ul>
                <?php
                $funs = CarUser::model()->findByPk(Yii::app()->user->id);
                foreach ($list as $key=>$item) :?>
    
                    <li class="zhuli; ?>">
                        <ul> 			//利用分页展示排名                        <li><?php $pageCurent = empty($_GET['page'])?1:$_GET['page']; if($pageCurent==1){ echo ++$key ;} else {
       echo ($pageCurent-1)*6+(++$key) ;}?></li>                         <li><?php echo $item['id']; ?></li>
                            <li>
                                <?php
                                    $count=mb_strlen($item['driver'],'utf-8');
                                    if($count<5) {
                                        echo $item['driver'];
                                    }
                                    else{
                                        echo mb_substr($item['driver'],0,2,'utf-8').'*'.mb_substr($item['driver'],$count-1,1,'utf-8');
                                    }?>
                            </li>
                            <li><?php echo $item['upcart_amount']*10; ?></li>
                            <li >
                                <?php  if(!in_array($item['id'],$carUserUpcar)): ?>
                                <a href="javascript:void (0);" οnclick="upCar(<?php echo $item['id'];?>)">上车</a>
                                    <?php else: ?>
                                <a href="javascript:void (0);" οnclick="alert('您已经的这辆车上了')" >已上车</a>
                                <?php endif; ?>
                                <a href="/site/timeline?uid=<?php echo $item['user_id']; ?>">帮他助力</a>
                            </li>
                        </ul>
                    </li>
                <?php endforeach;?>
            </ul>
        </div>       <div class="bottom">
        <div class="layer"></div>
        <?php //获取当前页和总记录条数
        $pageCurent = empty($_GET['page'])?1:$_GET['page'];
        $count =$pager->getItemCount();
        ?>
        <div class="left">
            <i οnclick="document.location.href='/rank/chi/page/<?php echo $pageCurent-1 ?>'"></i>
            <span><?php echo $pageCurent ?>/<?php echo ceil($count/6) ?></span>
            <em οnclick="document.location.href='/rank/chi/page/<?php if ($pageCurent<ceil($count/6)) {
        echo $pageCurent+1 ;} else{
        echo $pageCurent;} ?>'"></em>
        </div>
        <div class="right">
            <form>
                <span οnclick="document.location.href='/rank/chi/page/'+$("#go").val();">GO</span>
                <label>页</label>
                <div>
                    <input type="text" name="" id="go">
                    <div  class="layer"></div>
                </div>
                <label>第</label>
            </form>
        </div>
    </div>
    <?php endif;?>   <div class="bot_nav">
            <div>
                <ul>
                    <li class="active"><a href="/">首页</a></li>
                    <li><a href="/rank">排行</a></li>
                    <li><a href="/site/icar">我的车队</a></li>
                    <li>
                        <a href="javascript:void(0);" class="more">抽奖 * 奖品</a>
                        <ul>
                            <li><a href="/luckdraw/index">抽奖</a></li>
                          
                        </ul>
                    </li>
                </ul>
            </div>
        </div>
    
        <div class="layer_black"></div>
    
        <div class=" wx_guanzhu" >
            <div>
                <i οnclick="show_wx_colse();return false;"></i>
                <img src="<?php echo Yii::app()->versionUrl->changeUrl(COMMONSTATICFILE."/1st_Anniversary_Celebration/images/wx_guanzhu.png" )?>">
            </div>
        </div>
    </div>
    
    <script>
        $(document).ready(function(){
            $('.more').click(function(){
                $(this).next().stop().fadeToggle('fast');
    
            });
        });
    </script>
    
    
    
    <script type="text/javascript">
        $(document).ready(function(){
    
            $('.paihang_list>div.top_nav>ul>li').click(function(){
                $('.paihang_list>div.top_nav>ul>li').removeClass('active');
                $(this).addClass('active');
            });
    
        });
    
    </script>
    
    <script type="text/javascript">
        $(document).ready(function() {
            var W = $('.box').css('width');
            $('.bot_nav, .top_nav').css({
                "width": W
            });
        });
    </script>
    
    <script type="text/javascript">
        $(document).ready(function(){
            var H = screen.height;
            $('.box').css({
         'min-height':H});
            $('body').css({
                'padding-bottom':0,
                'min-height':'inherit'
            });
        });
    </script>
    
    <script>
    
        function upCar(id) {
            $.post(
                '/site/upcar',
                {
         car_id:id},
                function (data) {
                    if(data.status == 200){
                        alert('成功上车！');
                        $('.paihang_list>div.content>div.con>ul>li.zhuli_'+ data.msg.id+'>ul>li:last-child>a:first-child').text('已上车');
                        if(data.msg.can_draw){
                            document.location.href='/luckdraw/';
                        }
    
    
                    }else {
                        alert(data.msg);
                    }
    
                },'json'
            );
    
        }
    </script>