<?php
require '../conn/conn.php';
require '../conn/function.php';
require 'admin_check.php';

$page=$_GET["page"];
$action=$_GET["action"];
$G_id=intval($_GET["G_id"]);

if($G_id!=""){
	$aa="reply&G_id=".$G_id;
	$sql="select * from sl_guestbook where G_id=".$G_id;
	$result = mysqli_query($conn, $sql);
	$row = mysqli_fetch_assoc($result);
	if (mysqli_num_rows($result) > 0) {
		$G_title=htmlspecialchars($row["G_title"]);
		$G_name=htmlspecialchars($row["G_name"]);
		$G_mail=htmlspecialchars($row["G_mail"]);
		$G_phone=htmlspecialchars($row["G_phone"]);
		$G_msg=htmlspecialchars($row["G_msg"]);
		$G_time=$row["G_time"];
		$G_reply=$row["G_reply"];
	}
}

if($action=="reply"){
	if($_POST["G_reply"]!=""){
		
		mysqli_query($conn,"update sl_guestbook set G_reply='".$_POST["G_reply"]."' where G_id=".$G_id);
		mysqli_query($conn,"insert into sl_log(L_aid,L_time,L_add,L_ip,L_title) values(".$_SESSION["A_id"].",'".date('Y-m-d H:i:s')."','".$_SESSION["add"]."','".getip()."','回复留言')");
		$info=sendmail("您的留言有回复","<p>留言标题：".$G_title."</p><p>留言时间：".$G_time."</p><p>留言内容：".$G_msg."</p><p>留言回复：".$_POST["G_reply"]."</p>",$G_mail);
		if($info=="success"){
            die("{\"msg\":\"success\",\"id\":\"".$G_id."\"}");
        }else{
            die("{\"msg\":\"".$info."\"}");
        }
	}else{
		die("{\"msg\":\"请填全信息\"}");
	}
}

if($action=="delall"){
	$id=$_POST["id"];
	if(count($id)>0) {
		$shu=0 ;
		for ($i=0 ;$i<count($id);$i++ ) {
			mysqli_query($conn,"update sl_guestbook set G_del=1 where G_id=".intval($id[$i]));
			$shu=$shu+1;
			$ids=$ids.$id[$i].",";
		}
		$ids= substr($ids,0,strlen($ids)-1);
		if($shu>0) {
			mysqli_query($conn,"insert into sl_log(L_aid,L_time,L_add,L_ip,L_title) values(".$_SESSION["A_id"].",'".date('Y-m-d H:i:s')."','".$_SESSION["add"]."','".getip()."','批量删除留言')");
			die("{\"msg\":\"success\",\"ids\":\"".$ids."\"}");
		} else {
			die("{\"msg\":\"删除失败\"}");
		}
	} else {
		die("{\"msg\":\"未选择要删除的内容\"}");
	}
}

$sql="select count(G_id) as G_count from sl_guestbook where G_del=0";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$G_counts=$row["G_count"];
?>
<!DOCTYPE html>
<html lang="en">
	<head>

		<meta charset="UTF-8">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<title>留言管理 - 后台管理</title>

		<!--favicon -->
		<link rel="icon" href="../media/<?php echo $C_ico?>" type="image/x-icon"/>

		<!--Bootstrap.min css-->
		<link rel="stylesheet" href="assets/plugins/bootstrap/css/bootstrap.min.css">

		<!--Icons css-->
		<link rel="stylesheet" href="assets/css/icons.css">

		<!--Style css-->
		<link rel="stylesheet" href="assets/css/style.css">

		<!--mCustomScrollbar css-->
		<link rel="stylesheet" href="assets/plugins/scroll-bar/jquery.mCustomScrollbar.css">

		<!--Sidemenu css-->
		<link rel="stylesheet" href="assets/plugins/toggle-menu/sidemenu.css">



		<!--Toastr css-->
		<link rel="stylesheet" href="assets/plugins/toastr/build/toastr.css">


		<script type="text/javascript" src="../upload/upload.js"></script>
		<style type="text/css">
		.showpic{height: 100px;border: solid 1px #DDDDDD;padding: 5px;}
		.showpicx{width: 100%;max-width: 500px}
		.list-group a{text-decoration:none}
		.part{display:inline-block;width:80%;overflow:hidden;text-overflow:ellipsis;white-space: nowrap;}


#buy label {
	padding: 1px 5px;
	cursor: pointer;
	border: #CCCCCC solid 2px;
	-moz-border-radius: 3px;
	-webkit-border-radius: 3px;
	border-radius: 3px;
}

#buy .checked {
	border: #ff0000 solid 2px;
	-moz-border-radius: 3px;
	-webkit-border-radius: 3px;
	border-radius: 3px;
	color: #ff0000;
}

#buy input[type="radio"] {
	display: none;
}
	</style>
	</head>

	<body class="app ">

		<div id="spinner"></div>

		<div id="app">
			<div class="main-wrapper" >
				
					<?php
					require 'nav.php';
					?>

				<div class="app-content">
					<a href="recycle.php" class="btn btn-info pull-right" style="z-index: 2;position: relative;"><i class="fa fa-recycle"></i> 回收站</a>
					<section class="section">
                    	<ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="index.php">后台管理</a></li>
                            <li class="breadcrumb-item active" aria-current="page">留言管理</li>
                        </ol>


						<div class="section-body ">
							
							<div class="row">
								
								<div class="col-lg-4">
									<form id="list">
									<div class="card card-primary">

										<div class="card-header">
											<h4>留言列表</h4>
										</div>
												<ul class="list-group">
													
													<?php 
														$sql="select * from sl_guestbook where G_del=0 order by G_id desc limit 20";
																$result = mysqli_query($conn, $sql);
																if (mysqli_num_rows($result) > 0) {
																while($row = mysqli_fetch_assoc($result)) {
																	if($row["G_id"]==$G_id){
																		$active="active";
																	}else{
																		$active="";
																	}
																	if($row["G_reply"]==""){
																		$reply="未回复";
																	}else{
																		$reply="";
																	}
																	
																	echo "<a id=\"".$row["G_id"]."\" href=\"?G_id=".$row["G_id"]."\" class=\"list-group-item ".$active."\">
																	<div class=\"part\"><input type=\"checkbox\" name=\"id[]\" value=\"".$row["G_id"]."\"> ".htmlspecialchars($row["G_title"])."</div> 
																	<div class=\"pull-right\">$reply</div>
																	</a>";
																}
															}
													?>
													
												</ul>
									</div>
									<label><input type="checkbox" id="selectAll" name="selectAll"> 全选</label>
									<button class="btn btn-sm btn-danger" type="button" onClick="guestbook_delall()"><i class="fa fa-times-circle" ></i> 删除</button>
									
									<ul class="pagination" id="pagination" style="float: right;"></ul>
									<input type="hidden" id="PageCount" runat="server" />
        <input type="hidden" id="PageSize" runat="server" value="20" />
        <input type="hidden" id="countindex" runat="server" value="20"/>
        <!--设置最多显示的页码数 可以手动设置 默认为7-->
        <input type="hidden" id="visiblePages" runat="server" value="7" />
								</form>
								</div>
								<?php if($action!="menu"){?>
								
								<div class="col-lg-8">
									<form id="form">
									<div class="card card-primary">
										<div class="card-header ">
											<h4>留言管理</h4>
										</div>
										<div class="card-body">
											<div class="form-group row">
													<label class="col-md-3 col-form-label" >时间</label>
													<div class="col-md-9" style="margin-top: 7px">
														<?php echo $G_time?>
													</div>
												</div>
												<div class="form-group row">
													<label class="col-md-3 col-form-label" >标题</label>
													<div class="col-md-9" style="margin-top: 7px">
														<?php echo $G_title?>
													</div>
												</div>
												<div class="form-group row">
													<label class="col-md-3 col-form-label" >电话</label>
													<div class="col-md-9" style="margin-top: 7px">
														<?php echo $G_phone?>
													</div>
												</div>
												<div class="form-group row">
													<label class="col-md-3 col-form-label" >邮箱</label>
													<div class="col-md-9" style="margin-top: 7px">
														<?php echo $G_mail?>
													</div>
												</div>
												<div class="form-group row">
													<label class="col-md-3 col-form-label" >姓名</label>
													<div class="col-md-9" style="margin-top: 7px">
														<?php echo $G_name?>
													</div>
												</div>
												<div class="form-group row">
													<label class="col-md-3 col-form-label" >内容</label>
													<div class="col-md-9" style="margin-top: 7px">
														<?php echo $G_msg?>
													</div>
												</div>

												<div class="form-group row">
													<label class="col-md-3 col-form-label">回复</label>
													<div class="col-md-9" style="margin-top: 7px">
														<textarea class="form-control" name="G_reply" rows="10"><?php echo $G_reply?></textarea>
													</div>
												</div>

												<div class="form-group row">
													<label class="col-md-3 col-form-label" ></label>
													<div class="col-md-9">
														<button class="btn btn-info" type="button" onClick="guestbook_save()">回复</button>
													</div>
												</div>
										</div>
									</div>
									</form>
								</div>
							
							<?php }?>
							
							</div>
							
						</div>
					</section>
				</div>

			</div>
		</div>

		<script src="assets/js/jquery.min.js"></script>
		<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
		<script src="assets/plugins/toggle-menu/sidemenu.js"></script>
		<script src="assets/plugins/scroll-bar/jquery.mCustomScrollbar.concat.min.js"></script>
		<script src="assets/js/scripts.js"></script>
		<script src="assets/js/help.js"></script>
		<script src="assets/plugins/toastr/build/toastr.min.js"></script>
		<script src="assets/js/jqPaginator.min.js" type="text/javascript"></script>
		<script src="ajax.js"></script>
		<script type="text/javascript">
var $aa="<?php echo $aa?>";
		function loadData(num) {
            $("#PageCount").val("<?php echo $G_counts?>");
        }
function loadpage(id) {
    var myPageCount = parseInt($("#PageCount").val());
    var myPageSize = parseInt($("#PageSize").val());
    var countindex = myPageCount % myPageSize > 0 ? (myPageCount / myPageSize) + 1 : (myPageCount / myPageSize);
    $("#countindex").val(countindex);

    $.jqPaginator('#pagination', {
        totalPages: parseInt($("#countindex").val()),
        visiblePages: parseInt($("#visiblePages").val()),
        currentPage: id,
        first: '<li class="first page-item"><a href="javascript:;" class="page-link">|<</a></li>',
        prev: '<li class="prev page-item"><a href="javascript:;" class="page-link"><i class="arrow arrow2"></i><</a></li>',
        next: '<li class="next page-item"><a href="javascript:;" class="page-link">><i class="arrow arrow3"></i></a></li>',
        last: '<li class="last page-item"><a href="javascript:;" class="page-link">>|</a></li>',
        page: '<li class="page page-item"><a href="javascript:;" class="page-link">{{page}}</a></li>',
        onPageChange: function (num, type) {
            if (type == "change") {
                window.location="text.php?page="+num;
            }
        }
    });
}
$(function () {
    loadData(<?php echo $page?>);
    loadpage(<?php echo $page?>);

});

		

$('input[name="selectAll"]').on("click",function(){
        if($(this).is(':checked')){
            $('input[name="id[]"]').each(function(){
                $(this).prop("checked",true);
            });
        }else{
            $('input[name="id[]"]').each(function(){
                $(this).prop("checked",false);
            });
        }
    });


		</script>
		
	</body>
</html>
