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

红太狼 2022-07-15 13:19 134阅读 0赞

控制器

//用户班级列表 班级总人数 ,拒绝加入信息 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>

效果![Center][]

[Center]: /images/20220715/eabe774f779644faaa6ba9545f0b2124.png