控制器
//用户班级列表 班级总人数 ,拒绝加入信息 status:0管理员未查看 view显示等待审核 1通过审核 view显示进入班级 2拒绝加入 view显示决绝申请
{ //所有班级
$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>
效果