qq_37298647 2019-12-11 17:45 采纳率: 50%
浏览 443

后台动态数据,怎么增加一个导出功能,导出选中的数据

怎么增加一个导出功能,导出选中的数据

<!-- inc:header -->
<div class="notice"><div class="p">
    <table width="100%" cellpadding="0" cellspacing="0">
    <tr>
        <td><span class="lead">&nbsp;&raquo; 推荐客户列表</span></td>
        <td>
            <table>
            <form method="post" action="#" onsubmit="to_search();return false;">
            <tr>
                <td>
                    <select name="status" id="status">
                        <option value="">不限审核</option>
                        <option value="1"{if($status == 1)} selected{end}>已审核</option>
                        <option value="2"{if($status == 2)} selected{end}>未审核</option>
                        <option value="3"{if($status == 3)} selected{end}>已过期</option>
                    </select>
                </td>
                <td>&nbsp; 时间:</td>
                <td><input type="text" name="startdate" id="startdate" onfocus="show_date('startdate')" style="width:75px;" value="{:$startdate}"></td>
                <td>&nbsp;-&nbsp;</td>
                <td><input type="text" name="enddate" id="enddate" onfocus="show_date('enddate')" style="width:75px;" value="{:$enddate}"></td>
                <td>&nbsp; 关键字:</td>
                <td>
                    <select name="keytype" id="keytype">
                        <option value="">不限</option>
                        <option value="cellphone"{if($keytype == "cellphone")} selected{end}>手机</option>
                        <option value="username"{if($keytype == "username")} selected{end}>姓名</option>
                    </select>
                </td>
                <td><input type="text" name="keywords" value="{:$keywords}" id="keywords"></td>
                <td><input type="submit" value="搜索" class="btn2"></td>
            </tr>
            </form>
            </table>
        </td>
        <td align="right"><a class="status0"></a></td>
        <td>未审核</td>
        <td align="right"><a class="status1"></a></td>
        <td>已审核</td>
        <td align="right"><a class="status2"></a></td>
        <td>已过期</td>
        <td align="right"><a href="{:site_url('customer,set')}module_id={:$m_rs[id]}&" class="button">添加新推荐人</a></td>
    </tr>
    </table>
</div></div>

<div class="main">
<table width="100%" style="layout:fixed;" cellpadding="0" cellspacing="0">
<tr>
    <td class="t_sub" width="40px">&nbsp;</td>
    <td class="t_sub" width="50px">ID</td>
    <td class="t_sub" width="35px">状态</td>
    <td class="t_sub">合伙人</td>
    <td class="t_sub">客户姓名</td>
    <td class="t_sub">客户手机</td>
    <td class="t_sub">项目名称</td>
    <td class="t_sub">预约时间</td>
    <td class="t_sub" width="110px">注册时间</td>
    <td class="t_sub" width="45px">操作</td>
</tr>
<!-- $rslist AS $key=>$value -->
<tr class="tr_out" onMouseOver="over_tr(this)" onMouseOut="out_tr(this)">
    <td align="center" class="tc_left"><input type="checkbox" value="{:$value[id]}"></td>
    <td align="center" class="tc_right">{:$value[id]}</td>
    <td align="center" class="tc_right" id="status_{:$value['id']}"><a href="javascript:status({:$value[id]},{:intval($value['status'])});void(0);" class="status{:intval($value['status'])}"></a></td>
    <td align='center' class="tc_right">&nbsp;<a href="javascript:show_user('{:$value[uid]}');void(0);">{:$value[uname]}</a></a></td>
    <td align='center' class="tc_right">&nbsp;{:$value[username]}</a></td>
    <td align='center' class="tc_right">&nbsp;{:$value[cellphone]}</td>
    <td align='center' class="tc_right">&nbsp;{:$value[proname]}</td>
    <td align='center' class="tc_right">&nbsp;{:$value[appointment_date]}&nbsp;{:$value[appointment_time]}</td>
    <td  align='center' class="tc_right">{:date('Y-m-d H:i',$value[postdate])}</td>
    <td align="center" class="tc_right">
        <a href="{:site_url('customer,set')}module_id={:$m_rs[id]}&id={:$value[id]}" class="btn edit" title="编辑"></a>
        <a href="javascript:del({:$value['id']});void(0);" class="btn del" title="删除"></a>
    </td>
</tr>
<!-- end -->
</table>
</div>
<div class="table">
    <table width="100%">
    <tr>
        <td>
            <input type="button" value="全选" onclick="select_all()" class="btn2">
            <input type="button" value="全不选" onclick="select_none()" class="btn3">
            <input type="button" value="反选" onclick="select_anti()" class="btn2">
            &nbsp;
            <input type="button" value="批量审核" onclick="update_pl('1')" class="btn4">
            <input type="button" value="批量未审核" onclick="update_pl('0')" class="btn4">
            <input type="button" value="批量已过期" onclick="update_pl('2')" class="btn4">
            &nbsp;
            <input type="button" value="批量删除" onclick="del_pl()" class="btn4">
        </td>
        <td align="right">{:$pagelist}</td>
    </tr>
    </table>
</div>

<script type="text/javascript">
function to_search()
{
    url = base_url;
    //状态
    var st = getid("status").value;
    if(st)
    {
        url += "status="+st+"&";
    }
    var startdate = getid("startdate").value;
    if(startdate)
    {
        url += "startdate="+EncodeUtf8(startdate)+"&";
    }
    var enddate = getid("enddate").value;
    if(enddate)
    {
        url += "enddate="+EncodeUtf8(enddate)+"&";
    }
    var keytype = getid("keytype").value;
    var keywords = getid("keywords").value;
    if(keytype && keywords)
    {
        url += "keytype="+EncodeUtf8(keytype)+"&keywords="+EncodeUtf8(keywords)+"&";
    }
    direct(url);
    return false;
}
function update_pl(st)
{
    var id = join_checkbox();
    if(!id)
    {
        alert("请选择要更新的信息");
        return false;
    }
    var url = base_url + base_func + "=pl_status&status="+st+"&id="+id;
    var msg = get_ajax(url);
    if(msg == "ok")
    {
        direct(window.location.href);
        return true;
    }
    else
    {
        if(!msg) msg = "error: 操作错误";
        alert(msg);
        return false;
    }
}
function del_pl()
{
    var id = join_checkbox();
    if(!id)
    {
        alert("请选择要删除的信息");
        return false;
    }
    var qc = confirm("确定要删除该信息吗?删除后是不能恢复!");
    if(qc == "0")
    {
        return false;
    }
    var url = base_url + base_func + "=pl_del&id="+id;
    var msg = get_ajax(url);
    if(msg == "ok")
    {
        direct(window.location.href);
        return true;
    }
    else
    {
        if(!msg) msg = "error: 操作错误";
        alert(msg);
        return false;
    }
}
function to_del(id)
{
    var qc = confirm("确定要删除该信息吗?删除后是不能恢复!");
    if(qc == "0")
    {
        return false;
  • 写回答

1条回答 默认 最新

  • 代码的灵魂是bug! 2019-12-11 18:09
    关注

    可以查查PHPexcel这个库

    评论

报告相同问题?

悬赏问题

  • ¥15 树莓派与pix飞控通信
  • ¥15 自动转发微信群信息到另外一个微信群
  • ¥15 outlook无法配置成功
  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题