<!DOCTYPE html>
<html lang="en">
<head>
<title>社团人员管理</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="../club/css/bootstrap.min.css">
<link rel="icon" href="../images/logo220.png" type="image/x-icon"/>
<script src="https://cdn.staticfile.org/jquery/3.2.1/jquery.min.js"></script>
<script src="https://cdn.staticfile.org/popper.js/1.15.0/umd/popper.min.js"></script>
<script src="https://cdn.staticfile.org/twitter-bootstrap/4.3.1/js/bootstrap.min.js"></script>
<style>
.fakeimg {
height: 200px;
background: #aaa;
}
.img {
background: url("../club/images/logo.jpeg");
background-size: 100% auto;
height: 150px;
}
</style>
</head>
<body>
<?php
echo "<script>
document.cookie='comNumber= -1';
document.cookie='stuID= -1';
document.cookie='position= -1';
document.cookie='power= -1';
</script>";
require_once 'DB.php';
$conn = DB::connect('mysqli://root:password@localhost/club');
$conn->query("set names utf8");
session_start();
//$post_comCode = $_GET['comNo']; //合并之后用这句传值，下面那一句注释掉
$post_comCode='0001';
$sql_select_comName = $conn->query("SELECT clubName FROM clubinfo WHERE No='$post_comCode'");
$r = $sql_select_comName->fetchRow();
$comName = $r[0];
$sql_select_applyinfo = $conn->query("SELECT * FROM comApply WHERE community='$comName' AND status='Y'");
if ($sql_select_applyinfo) {
$res_select_applyinfo = [];
$count_select_applyinfo = 0;
while($r=$sql_select_applyinfo->fetchRow()){
$count_select_applyinfo++;
$res_select_applyinfo[] = $r;
}
for($applyinfo_i=0;$applyinfo_i<$count_select_applyinfo;$applyinfo_i++){
$row = $res_select_applyinfo[$applyinfo_i];
$stuNo = $row[2];
$stuName = $row[0];
$gender = $row[1];
$phone = $row[3];
$institute = $row[4];
$major = $row[5];
$community=$row[6];
$dept = $row[7];
$post="部员";
$stat=3;
$score=0;
$sql_check=$conn->query("SELECT * FROM comMember where comNumber = '".$post_comCode."' and stuID='".$stuNo."' ");
$check=$sql_check->fetchRow();
if(!$check){
$sql_add_mem = $conn->query("INSERT INTO `commember`(`comNumber`, `comName`, `depName`, `stuID`, `stuName`, `memPosition`, `memPower`, `memScore`) VALUES ('$post_comCode','$community','$dept','$stuNo','$stuName','$post','$stat','$score')");
if (DB::isError($sql_add_mem)) { die("添加成员失败！ − " . $sql_add_mem->getMessage() . "<br>"); }
}
//添加成功后删除该申请
$sql="DELETE FROM `comapply` WHERE stuID='".$stuNo."' AND community = '".$community."' AND dept= '".$dept."'";
$sql_del_appl=$conn->query($sql);
//echo $sql;
if (DB::isError($sql_del_appl)) { die("删除申请失败！ − " . $sql_del_appl->getMessage() . "<br>"); }
}
}
$sql="SELECT * FROM clubinfo WHERE No='$post_comCode'";
$q = $conn->query("SELECT * FROM clubinfo WHERE No='$post_comCode'");
//echo $sql;
if (DB::isError($q)) { die("查询失败！ − " . $q->getMessage() . "<br>"); }
$r = $q->fetchRow();
?>
<div class="img"></div>
<nav class="navbar navbar-expand-sm bg-dark navbar-dark">
<a class="navbar-brand" href="#">导航</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#collapsibleNavbar">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="collapsibleNavbar">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" href="HomePage.html">首页</a>
</li>
</div>
</nav>
<div class="container" style="margin-top:30px">
<div class="row">
<div class="col-sm-3">
<ul class="nav nav-pills flex-column">
<li class="nav-item">
<a class="nav-link" href="s_infoManage.php">管理社团信息</a>
</li>
<li class="nav-item">
<a class="nav-link active" href="s_manager2_memManage.php">管理社团人员</a>
</li>
</ul>
<hr class="d-sm-none">
</div>
<div class="col-sm-8">
<?php
$sql_select_dep = $conn->query("SELECT distinct depName FROM comMember WHERE comNumber='$post_comCode'");
$res_select_dep = [];
$count_select_dep = 0;
?>
<form>
<div class="form-group">
<select class="form-control" id="sel" onchange="jump(this.options[this.options.selectedIndex].value)">
<option value="">请选择部门</option>
<?php
while($r=$sql_select_dep->fetchRow()){
$count_select_dep++;
$res_select_dep[] = $r;
?>
<option value="<?php echo $r[0];?>"><?php echo $r[0];?></option>
<?php }?>
</select>
<br>
</div>
</form>
<?php
//有部门选择时
if(isset($_COOKIE["selDep"] ) && $_COOKIE["selDep"] != -1) {
?>
<table class="table table-striped" id="table" cellspacing="0">
<thead>
<tr>
<th>社团编号</th>
<th>社团</th>
<th>部门</th>
<th>学号</th>
<th>姓名</th>
<th>职位</th>
<th>权限</th>
<th>阳光信用积分</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$selDepart=$_COOKIE["selDep"] ;
$sql_select_mem = $conn->query("SELECT * FROM comMember WHERE comNumber='$post_comCode' AND depName= '$selDepart'");
$row=0;
while($r=$sql_select_mem->fetchRow()){
$row++;
?>
<tr>
<?php
for($attribute=0; $attribute<8; $attribute++){ ?>
<td><?php echo $r[$attribute]; ?></td>
<?php } ?>
<td><button class="btn btn-light" onclick="update(this,<?php echo $row; ?>)">修改</button></td>
</tr>
<?php } ?>
</tbody>
</table>
<?php } else {
?>
<table class="table table-striped" id="table" cellspacing="0">
<thead>
<tr>
<th>社团编号</th>
<th>社团</th>
<th>部门</th>
<th>学号</th>
<th>姓名</th>
<th>职位</th>
<th>权限</th>
<th>阳光信用积分</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
//默认显示
$sql_select_mem = $conn->query("SELECT * FROM comMember WHERE comNumber='$post_comCode' ORDER BY depName");
$row=0;
while($r=$sql_select_mem->fetchRow()){
$row++;
?>
<tr>
<?php
for($attribute=0; $attribute<8; $attribute++){ ?>
<td><?php echo $r[$attribute]; ?></td>
<?php } ?>
<td><button class="btn btn-light" onclick="update(this,<?php echo $row ;?>)">修改</button></td>
</tr>
<?php }?>
</tbody>
</table>
</div>
<?php } ?>
<script>
var item = [ 'comNumber','comName','depName','stuID','stuName','memPosition','memPower','memScore' ];
function update(obj,x){
var table = document.getElementById("table");
console.log("table1"+table.rows[x].cells[5].innerHTML);
console.log("table1"+table.rows[x].cells[6].innerHTML);
var comNumber = table.rows[x].cells[0].innerHTML;
var stuID = table.rows[x].cells[3].innerHTML;
var position = table.rows[x].cells[5].innerHTML;
var power = table.rows[x].cells[6].innerHTML;
table.rows[x].cells[5].innerHTM
毕设&课设&项目&实训-社团管理系统--数据库课程设计.zip
版权申诉
90 浏览量
2024-02-08
11:20:43
上传
评论 1
收藏 36.45MB ZIP 举报
毕设&课设&项目&实训-社团管理系统--数据库课程设计.zip （206个子文件） 
bootstrap.css 170KB bootstrap.css 170KB bootstrap.min.css 138KB bootstrap.min.css 138KB layui.css 59KB bootstrap-grid.css 37KB bootstrap-grid.min.css 28KB style.css 24KB layer.css 14KB layer.css 14KB weadmin.css 12KB layui.mobile.css 10KB laydate.css 7KB layer.css 5KB bootstrap-reboot.css 5KB C.css 4KB bootstrap-reboot.min.css 4KB Community.css 3KB C2.css 3KB Community.css 3KB c.css 3KB studentInfo.css 3KB shetuanshenqing.css 1KB code.css 1KB font.css 505B iconfont.eot 48KB iconfont.eot 39KB
loading-0.gif 6KB loading-0.gif 6KB loading-2.gif 2KB loading-2.gif 2KB loading-1.gif 701B loading-1.gif 701B
page2.html 7KB Administrator.html 3KB HomePage.html 3KB try.html 3KB a_add_clubinfo.html 3KB a_add_Commember.html 3KB update.html 2KB a_add_student.html 2KB p_topFrame.html 1KB a_select_commemberid.html 1KB a_select_cominfoprincipal.html 1KB a_select_commembername.html 1KB a_select_stucominfo.html 1KB a_select_commemberstuid.html 1KB a_select_cominfoname.html 1KB a_select_sname.html 1KB a_select_cominfoid.html 1015B a_select_stuID.html 1015B logo.jpeg 74KB logo1.jpeg 10KB
fig2.jpg 17.38MB fig4.jpg 17.14MB fig1.jpg 573KB fig3.jpg 238KB layui.all.js 226KB jquery.js 95KB jquery-3.2.0.min.js 85KB mobile.js 33KB laydate.js 27KB layer.js 22KB layer.js 21KB treeGird.js 21KB table.js 20KB tabmenu.js 16KB layedit.js 12KB admin.js 12KB form.js 9KB code.js 8KB element.js 7KB upload.js 7KB layui.js 6KB laypage.js 4KB weadmin.js 4KB carousel.js 4KB layer.js 3KB tree.js 3KB rate.js 3KB util.js 3KB eleDel.js 2KB flow.js 2KB laytpl.js 2KB Clock.js 1KB code.js 1KB index.js 211B weadmin.less 15KB bootstrap.min.css.map 549KB bootstrap.css.map 420KB bootstrap-grid.css.map 96KB bootstrap-grid.min.css.map 67KB bootstrap-reboot.css.map 59KB bootstrap-reboot.min.css.map 25KB s_manager2_memManage.php 11KB messages.php 10KB s_apply_deal.php 9KB s_member.php 7KB s_date_modi_ren.php 7KB s_infoManage.php 7KB共 206 条
- 1
- 2
- 3
资源评论
