<!DOCTYPE html>
<html>
<head>
<style>
</style>
<meta charset="UTF-8">
<script src="http://libs.baidu.com/jquery/1.9.0/jquery.js"></script>
<title>Demo</title>
</head>
<body>
<p style="color:skyblue;font-weight:900;">数据导出</p>
<form action="{:url('index/Demo/index')}" method="post" id='myform'>
查找:<input type='search' name='search' class='search' value='{$a}'>
<input type='submit' value='搜索' name='sub' class='sub'>
<input type='hidden' value='9' id='other' name='others'>
<input type='hidden' value='' id='inpu' name="inpu">
</form>
<input type="button" onclick="data()" value="导出">
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th><input type="checkbox" id="all" onchange="al()"></th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>电话</th>
</tr>
{volist name="list" id="vo"}
<tr>
<td><input type="checkbox" name="select" value="{$vo.id}" onchange="al()"></td>
<td>{$vo.name}</td>
<td>{if condition="$vo.sex eq '男'"}男{elseif condition="$vo.sex eq '女'"}女{else/}保密{/if}</td>
<td>{$vo.age}</td>
<td>{$vo.tel}</td>
</tr>
{/volist}
</table>
<script type="text/javascript">
var all = document.getElementById("all");
var select = document.getElementsByName("select");
all.onclick = function(){
var arr=new Array();
for(var i = 0; i < select.length; i++){
if(all.checked == true){
select[i].checked = true;
var oi=select[i].value;
arr.push(oi);
var inpu=document.getElementById('inpu').value=arr;
}else{
select[i].checked = false;
for(let b=0;b<arr.length;b++){
arr.splice(0,arr.length)
var inpu=document.getElementById('inpu').value=arr;
}
}
}
}
function al(){
var arr=new Array();
$('input[name="select"]:checked').each(function(index, element) {
arr.push($(this).val());
});
var inpu=document.getElementById('inpu').value=arr;
console.log(arr);
}
for(var i = 0; i < select.length; i++){
select[i].index = i;
select[i].onclick = function(){
var count = 0;
if(select[this.index].checked == false){
all.checked = false;
}
for(var j = 0; j < select.length; j++){
if(select[j].checked == true){
count += 1;
}
}
if(count == select.length){
all.checked = true;
}
}
}
function data(){
document.getElementById('other').value=2;
document.getElementById('myform').submit();
}
</script>
</body>
</html>
<?php
namespace app\index\controller;
use think\Db;
use think\Controller;
class Demo extends \think\Controller
{
public function index()
{
$map= input('search');
$inpu = input('inpu');
$others = input('others');
if($inpu == ""){
if($map == "" && $others == 2){
$data = db('user')->select();
$this->pine($data);
}
}elseif($inpu!==''){
$ar = explode(",",$inpu);
if($map== "" && count($ar) >= 1 && $others==2){
$lists = [];
foreach($ar as $a){
$lists[] = db('user')->where('id',$a)->find();
}
$this->pine($lists);
}
}
if($map){
$orange = db('user')->where('name|sex|age|tel','like','%'.$map.'%')->select();
}else{
$orange = db('user')->select();
}
if(!empty($map) && empty(input('sub'))&&$others==2){
$data=db('user')->where('name|sex|age|tel','like','%'.$map.'%')->select();
$this->pine($data);
}
$this->assign("a" ,$map);
$this->assign( "list",$orange);
return $this->fetch( "index");
}
public function pine($data){
$Table ='<table border="1">';
$Table .='<tr>';
$Table .='<td>姓名</td>';
$Table .='<td>性别</td>';
$Table .='<td>年龄</td>';
$Table .='<td>电话</td>';
$Table .='</tr>';
foreach($data as $k=>$val){
$Table .='<tr>';
$Table .='<td>'.$val['name'].'</td>';
$Table .='<td>'.$val['sex'].'</td>';
$Table .='<td>'.$val['age'].'</td>';
$Table .='<td>'.$val['tel'].'</td>';
$Table .='</tr>';
}
$Table .='</table>';
header("Content-type: application/vnd.ms-excel");
header("Content-Type: application/force-download");
header("Content-Disposition: attachment; filename=".'员工表'."_".date('Y-m-d').".xls");
header('Expires:0');
header('Pragma:public');
echo '<html><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />'.$Table.'</html>';
}
}