文章介绍 ny{Yr>:2
1、首先在后台修改/dede/templets/diy_main.htm 9d_
Zdc
8\/$cP"<^
1 J-wF2*0r<
<a href="../plus/diy.php?action=daochu&diyid={dede:field.diyid/}" target="_blank">导出为EXCEL</a> &3_.k
Q=~*oYR
修改,后台效果如下图: 6./3w&D;
U+FI^Xrt#
-)LiL
qRnD{g|{1
2、核心内容修改 plus/diy.php +zf[Im%E
Z& W*@(dX
1 X&14;lu%p
$action = isset($action) && in_array($action, array('post', 'list', 'view')) ? $action : 'post'; Yfd0Np~
替换成: v%$c_'d
@&xWd{8'
1 gql^Inx<
$action = isset($action) && in_array($action, array('post', 'list', 'view', 'daochu')) ? $action : 'post'; 3F ]30
再在最后一行下面新加代码: > t~2
O
!
iN
当然,下面输出表头的判断语句你可以自己改! [wv;CUmgc
AREpZ2GiU
001 MlH0
else if($action == 'daochu') YM.Q?p4g
002 6h9Hf$'
{ 'S#D+oF(1~
003 Or<OmxJg
header("Content-type:application/vnd.ms-excel"); K$kI%eGZA
004 XkRPD
Header("Content-Disposition:attachment;filename={$diy->table}_".date("Y-m-d").".xls"); Of.%rpgy
005 !si}m~K!_
$query = "desc `{$diy->table}`"; HyGu3
006 7;r Jr&.)
$res = mysql_query($query); ZWXA%u7V
007 Hkzx(yTi
echo "<table><tr>";
4"~F
008 dh K<5E
//导出表头(也就是表中拥有的字段) JxmFUheLt
009 D*}_L
while($row = mysql_fetch_array($res)){ OKV/=]GS
010 ^t}8E2mq
$t_field[] = $row['Field']; //Field中的F要大写,否则没有结果 H7CWAQPfj
011 12LGWhDp
/* echo "<th>".$row['Field']."</th>"; */ 8fWk C<f}
012 ~djHtd>
if($row['Field']=='id'){ $A^OP{
013 0P l>k'9
echo "<th>ID</th>"; 4_W*LG~2s
014 dM)x|b3z
}elseif($row['Field']=='zhaiwutype'){ /Y0oA3am
015 "'*Qq@!3?
echo "<th>债务类型</th>"; bx:j`5Uj`
016 N7UGgn=
}elseif($row['Field']=='zhaiquanfang'){ }9~U5UXWU
017 @_H
L{q%h
echo "<th>债权方</th>"; (d*~Qpi{7
018 {]Ec:6
}elseif($row['Field']=='name'){ dhV6r
019 _g%,/y 9y
echo "<th>名称</th>"; :&J1#% t
020 4uE|$
}elseif($row['Field']=='jigouhaoma'){ `M!'PMX
021 q$kx/6=k
echo "<th>身份证号/机构代码</th>"; {sF;R.P&r
022 !@[@&.
}elseif($row['Field']=='path'){ 09J,!NN
023 uJU;C.LX
echo "<th>住址/地址</th>"; an)Z.x
024 }BAe
}elseif($row['Field']=='tel'){ ;^ff35EE8
025 o3Z<tI8-V
echo "<th>联系电话</th>"; 0}9
026 nU/x,W[}
}elseif($row['Field']=='zhaiwufang'){ grE'ySX0
027 x,Z:12H0
echo "<th>债务方</th>"; s]Z++Lh<{
028 3bagL)'iz
}elseif($row['Field']=='zhaiwufangname'){ }[: i!t.m
029 c>+hY5?C
echo "<th>债务方名称</th>"; pt%Y1<9Eh?
030 N3ccn
}elseif($row['Field']=='zhaiwufanghaoma'){ ?3do-tTp
031 :8Ugz ~i
echo "<th>债务方身份证号/机构代码</th>"; vs{xr*Ft
032 M-A{{q
}elseif($row['Field']=='zhaiwufangpath'){ xpWY4Q
033 G!U
`8R
echo "<th>债务方地址</th>"; g3c,x kaO
034 A[H"(E#k
}elseif($row['Field']=='zhaiwufangtel'){ z`!f'I--!
035 -NUA
echo "<th>债务方电话</th>"; bl[2VM7P
036 \'+P5,
}elseif($row['Field']=='danbaofang1'){ Nx<fj=VJ
037 k.wm{d]J
echo "<th>担保方</th>"; P=.T|l1
038 T*rz#O
}elseif($row['Field']=='danbao1name'){ dyt.(2
039 !$#8Z".{v{
echo "<th>担保方名称</th>"; &W
N
R{
040 @O
HsM?nW
}elseif($row['Field']=='danbao1haoma'){ Y"E*#1/
041 9.Yn]O
echo "<th>身份证号/机构代码</th>"; vn ^*
042 I1W~;2cK
}elseif($row['Field']=='danbao1tel'){ V(OD^GU
043 RT"JAJTi/
echo "<th>联系电话</th>"; )gNVJ
044 qnnP*15`
}elseif($row['Field']=='zhaiwushuoming'){ wZ/b;%I!
045 /y-8dgv0a
echo "<th>债务说明</th>"; $rH}2
046 K(Ak+&[
}elseif($row['Field']=='fayuanzhixing'){ KHoDD=O
047 mh8)yy5\
echo "<th>法院是否强制执行</th>"; 6<9gVh<=w
048 Kj*$'('
}elseif($row['Field']=='zhixingfayuan'){ D*!9K8<o
049 m]/sR3yF
echo "<th>执行法院</th>"; hmJa1fw=
050 A(wuRXnVWK
}elseif($row['Field']=='lianxiren'){ "sUmk e-#
051 rIJd(=
echo "<th>联系人</th>"; Ypw:Vp
052 wQN/MYF[
}elseif($row['Field']=='lianxidianhua'){ CF/8d6}Vf
053 2Z*^)ZQB
echo "<th>电话</th>"; X5c)T}pyv
054 YUQKy2
}elseif($row['Field']=='zhaiwujine'){ 7kh(WtUz
055 |Q*{yvfEo
echo "<th>债务金额</th>"; wak'L5GQE
056 .@3bz
}elseif($row['Field']=='nativeplace1'){ i
E)Fo.H
057 &