织梦DEDECMS自定义表单导出为excel功能

    发布时间:2019-02-19

    阅读量

    后台-系统设置-扩展变量-手机广告位-内容页头部广告位

    1、首先在后台修改/dede/templets/diy_main.htm
    <a href="../plus/diy.php?action=daochu&diyid={dede:field.diyid/}" target="_blank">导出为EXCEL</a>

    修改,后台效果如下图:

    织梦DEDECMS自定义表单导出为excel功能

    2、核心内容修改  plus/diy.php

    $action = isset($action) && in_array($action, array('post', 'list', 'view')) ? $action : 'post';
    替换成:
    $action = isset($action) && in_array($action, array('post', 'list', 'view', 'daochu')) ? $action : 'post';
    复制代码
    再在最后一行下面新加代码:
    当然,下面输出表头的判断语句你可以自己改!


    else if($action == 'daochu')
    {
    header("Content-type:application/vnd.ms-excel");
    Header("Content-Disposition:attachment;filename={$diy->table}_".date("Y-m-d").".xls");   
    $query = "desc `{$diy->table}`";
    $res = mysql_query($query);
    echo "<table><tr>";
    //导出表头(也就是表中拥有的字段)
    while($row = mysql_fetch_array($res)){
      $t_field[] = $row['Field']; //Field中的F要大写,否则没有结果
    /*   echo "<th>".$row['Field']."</th>"; */
            if($row['Field']=='id'){
                echo "<th>ID</th>";
            }elseif($row['Field']=='zhaiwutype'){
                echo "<th>债务类型</th>";
            }elseif($row['Field']=='zhaiquanfang'){
                echo "<th>债权方</th>";
            }elseif($row['Field']=='name'){
                echo "<th>名称</th>";
            }elseif($row['Field']=='jigouhaoma'){
                echo "<th>身份证号/机构代码</th>";
            }elseif($row['Field']=='path'){
                echo "<th>住址/地址</th>";
            }elseif($row['Field']=='tel'){
                echo "<th>联系电话</th>";
            }elseif($row['Field']=='zhaiwufang'){
                echo "<th>债务方</th>";
            }elseif($row['Field']=='zhaiwufangname'){
                echo "<th>债务方名称</th>";
            }elseif($row['Field']=='zhaiwufanghaoma'){
                echo "<th>债务方身份证号/机构代码</th>";
            }elseif($row['Field']=='zhaiwufangpath'){
                echo "<th>债务方地址</th>";
            }elseif($row['Field']=='zhaiwufangtel'){
                echo "<th>债务方电话</th>";
            }elseif($row['Field']=='danbaofang1'){
                echo "<th>担保方</th>";
            }elseif($row['Field']=='danbao1name'){
                echo "<th>担保方名称</th>";
            }elseif($row['Field']=='danbao1haoma'){
                echo "<th>身份证号/机构代码</th>";
            }elseif($row['Field']=='danbao1tel'){
                echo "<th>联系电话</th>";
            }elseif($row['Field']=='zhaiwushuoming'){
                echo "<th>债务说明</th>";
            }elseif($row['Field']=='fayuanzhixing'){
                echo "<th>法院是否强制执行</th>";
            }elseif($row['Field']=='zhixingfayuan'){
                echo "<th>执行法院</th>";
            }elseif($row['Field']=='lianxiren'){
                echo "<th>联系人</th>";
            }elseif($row['Field']=='lianxidianhua'){
                echo "<th>电话</th>";
            }elseif($row['Field']=='zhaiwujine'){
                echo "<th>债务金额</th>";
            }elseif($row['Field']=='nativeplace1'){
                echo "<th>住址/地址</th>";
            }elseif($row['Field']=='jiamengtype'){
                echo "<th>加入类型</th>";
            }elseif($row['Field']=='groupname'){
                echo "<th>公司(机构)名称</th>";
            }elseif($row['Field']=='grouppath'){
                echo "<th>公司地址</th>";
            }elseif($row['Field']=='groupjianjie'){
                echo "<th>公司简介</th>";
            }elseif($row['Field']=='lianxiren'){
                echo "<th>联系人</th>";
            }elseif($row['Field']=='lianxitel'){
                echo "<th>联系电话</th>";
            }elseif($row['Field']=='lianximobile'){
                echo "<th>手机</th>";
            }elseif($row['Field']=='qq'){
                echo "<th>QQ</th>";
            }elseif($row['Field']=='name'){
                echo "<th>姓名</th>";
            }elseif($row['Field']=='xingbie'){
                echo "<th>性别</th>";
            }elseif($row['Field']=='nianling'){
                echo "<th>年龄</th>";
            }elseif($row['Field']=='danwei'){
                echo "<th>工作单位</th>";
            }elseif($row['Field']=='zhiwu'){
                echo "<th>职务</th>";
            }elseif($row['Field']=='dianhua'){
                echo "<th>联系电话</th>";
            }elseif($row['Field']=='mobile'){
                echo "<th>手机</th>";
            }elseif($row['Field']=='mail'){
                echo "<th>E-mail</th>";
            }elseif($row['Field']=='ifcheck'){
                echo "<th>  </th>";
            }else{
                echo "<th>  </th>";
            }
    }
    echo "</tr>";
    //导出数据
    $sql = "select * from `{$diy->table}`";
    $res = mysql_query($sql);
    while($row = mysql_fetch_array($res)){
      echo "<tr>";
        foreach($t_field as $f_key){
            echo "<td>".$row[$f_key]."</td>";
        }
      echo "</tr>";
    }
    echo "</table>";
    }

    导出效果:

    织梦DEDECMS自定义表单导出为excel功能
    后台-系统设置-扩展变量-手机广告位-内容页头部广告位
    留言与评论(共有 0 条评论)
       
    验证码: