yii，join l联查，及分页，最简单的jquery,全选反选，批删

来源：互联网发布：闲鱼淘宝介入多久编辑：程序博客网时间：2024/05/22 20:52

控制器方法

//显示话题
    public function actionPub_list(){
        //获取班级id
        $c_id=yii::$app->request->get('cid');

        // //实例化查询类
        $query=new \yii\db\Query();
        $query->select(['topiczk1.t_id','topiczk1.title','topiczk1.content','topiczk1.file','topiczk1.add_time'])
        ->from('topiczk1')
        ->leftJoin('loginzk1','topiczk1.lid=loginzk1.l_id');
         $command = $query->createCommand();
         $data = $command->queryAll();

        //var_dump($data);die;
          //分页
        $pagination=new pagination(['totalCount'=>$query->count()]);
        $pagination->setPageSize(2);
        $data=$query->offset($pagination->offset)->limit($pagination->limit)->all();
              // var_dump($data);die;
      //查询数据表显示话题
       // $data=yii::$app->db->createCommand("select * from topiczk1 join loginzk1 on topiczk1.lid=loginzk1.l_id")->queryAll();

       return $this->render('pub_list',['data'=>$data,'pagination'=>$pagination]);
    }

视图层

<?php
use yii\widgets\LinkPager;
?>
<h5><a href="?r=stud/pub">继续添加</a>   <a href="?r=stud/addclass">返回空间</a></h5>
        <h3 align="center">话题列表</h3>
   <input type="button" class="quan" value="全选"> <input type="button" class="fan" value="反选">
   <input type="button" class="pl" value="批量删除">
<center>

   <table class="table">
       <tr>
           <td>标题</td>
           <td>作者</td>
            <td>图片</td>
           <td>发布时间</td>
            <td>操作</td>
       </tr>
       <?php foreach($data as $key=>$val){?>
           <td><input type="checkbox" class="box" name="box" value=
           "<?php echo $val['t_id']; ?>"><?=$val['title']?></td>
           <td><?php echo yii::$app->session->get('username')?></td>
           <td><img src="<?php echo $val['file']?>" alt="" width="150"/></td>
            <td><?=$val['add_time']?></td>
            <td><a href="?r=stud/pub_edit">编辑</a></td>
            </tr>
       <?php }?>
   </table>
   <?php echo LinkPager::widget([
    'pagination' =>$pagination]); ?>
</center>
<script src="jquery.1.12.js"></script>
<script>

   $(function(){
         //全选
       $(".quan").click(function(){

      var box=$(".box");//获取对象
           for(var i=0;i<box.length;i++){
             box.eq(i).prop("checked",true);
          }
   })
       //反选
       $(".fan").click(function(){
          var box=$('.box');
          for(var i=0;i<box.length;i++){
              if(box.eq(i).prop("checked")){
              box.eq(i).prop("checked",false);
             }else{
              box.eq(i).prop("checked",true);
             }
          }
              })
//批量删除
       $(".pl").click(function(){
          var box=$(".box");

          var str="";
            for(i=0;i<box.length;i++){
          if(box[i].checked==true){
          str=str+","+box[i].value;
               }
               }
      var id=str.substr(1);
      var url="?r=stud/del";
          $.get(url,{id:id},function(msg){
             alert(msg)
          })
       })
   });

</script>

0 0