简单申请列表状态数据处理 yii2

来源：互联网发布：unity3d动画状态转移编辑：程序博客网时间：2024/06/06 09:38

控制器

//用户班级列表班级总人数 ,拒绝加入信息 status:0管理员未查看 view显示等待审核 1通过审核 view显示进入班级 2拒绝加入 view显示决绝申请

    public function actionUgetlist($user_id)
    {           //所有班级
                $class_arr = $this->actionGetclass();
                //每个班级拒绝加入信息
                $untreated_arr = \Yii::$app->db->createCommand("SELECT class_id,status from class_user WHERE   user_id={$user_id} GROUP BY class_id ")->queryAll();
                //每个班级的人数
                $classuser_num = \Yii::$app->db->createCommand("SELECT class_id,count(user_id) as amount from class_user WHERE status=1 GROUP BY class_id ")->queryAll();
                $amount = count($class_arr);
                //整合数据为每个班级对应的数据
                foreach ($class_arr as $k1 => $v1) {
                    foreach ($untreated_arr as $k2 => $v2) {
                        if (isset($untreated_arr[$k2]['status'])&&$v1['id']==$v2['class_id']) {
                            $class_arr[$k1]['status']=$v2['status'];
                            // unset($untreated_arr[$k2]['status']);
                        }
                    }
                    foreach ($classuser_num as $k3 => $v3) {
                        if (isset($classuser_num[$k3]['amount'])&&$v1['id']==$v3['class_id']) {
                            $class_arr[$k1]['amount']=$v3['amount'];
                            unset($untreated_arr[$k3]['amount']);
                        }
                    }
                }
                // var_dump($class_arr);die();
        return $class_arr;

}

view层

<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
?>
<h1>学生界面</h1>
<table class='table'>
    <tr>
        <td>班级名称</td>
        <td>班级总人数</td>
        <td>操作</td>
    </tr>
    <?php foreach ($arr as $key => $value) {?>
    <tr>
        <td><?php echo $value['class_name']?></td>
        <td><?php if(isset($value['amount'])){ echo $value['amount'];}else{
            echo "0";
            }?>
        </td>
        <td>
        <?php if ($value['astrict']==0) {echo "禁止添加";}else{
                    if(isset($value['status'])){
                      switch ($value['status']) {
                          case '0':
                              echo "等待审核";
                              break;
                          case '1': ?>
        <a href="index.php?r=classee/class_user&class_id=<?php echo $value['id']; ?>">进入班级</a>
       <?php
                              break;
                          default:
                              echo "拒绝申请";
                              break;
                      }
                    }else{
        ?>
        <a href="index.php?r=classee/addclass&class_id=<?php echo $value['id']; ?>">申请加入班级</a>
        <?php }}?>
        </td>
    </tr>
    <?php } ?>
</table>
<script src='/css/jq.js'></script>
<script>

</script>

效果

0 0