<td class="Big"><img src="template/default/content/images/notify_new.gif" align="absmiddle"><span class="big3"> 图书信息查看</span> <span style="font-size:12px;"> <a href="admin.php?ac=index&fileurl=<?php echo $fileurl; ?> " style="font-size:12px;">返回列表页</a><img src="template/default/content/images/f_ico.png" align="absmiddle"></span> </td> </tr> </table> <form name="save" method="post" action="#"> <table class="TableBlock" border="0" width="90%" align="center" style="border-bottom:#4686c6 solid 0px;"> <tr> <td nowrap class="TableData" width="15%"> 图书类目:</td> <td class="TableData"><?php echo get_book_type_name($blog['booktype']); ?> </td> </tr> <tr> <td nowrap class="TableData"> 图书编号:</td> <td class="TableData"> <?php echo $blog['bookumber']; ?> </td> </tr> <tr> <td nowrap class="TableData"> 图书名称:</td> <td class="TableData"> <?php
if ($filetype = getGP('filetype', 'P')) { $wheresql .= " AND booktype ='" . $filetype . "'"; } //时间 $vstartdate = getGP('vstartdate', 'P'); $venddate = getGP('venddate', 'P'); if ($vstartdate != '' && $venddate != '') { $wheresql .= " AND (date>='" . $vstartdate . "' and date<='" . $venddate . "')"; } $vuidtype = getGP('vuidtype', 'P'); if (!is_superadmin() && $vuidtype == '') { $wheresql .= " AND uid = {$_USER->id}"; } if ($vuidtype != '') { $wheresql .= " " . get_subordinate($_USER->id, 'uid'); } $sql = "SELECT * FROM " . DB_TABLEPRE . "book WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array("" . get_book_type_name($row['booktype']) . "", "" . $row[bookumber] . "", "" . $row[bookname] . "", "" . $row[author] . "", "" . $row[publishing] . "", "" . $row[appendix] . "", "" . $row[booknum] . "", "" . $row[content] . "", "" . str_replace("-", ".", $row[date]) . "", "" . get_realname($row['uid']) . ""); $content[] = $archive; } $excel = new ExcelWriter($outputFileName); if ($excel == false) { echo $excel->error; } foreach ($content as $v) { $excel->writeLine($v); } $excel->sendfile($outputFileName); }
</td> <td width="100"><?php echo $row['bookumber']; ?> </td> <td class="title"> <a href="admin.php?ac=views&do=edit&fileurl=book&id=<?php echo $row['id']; ?> "><?php echo $row['bookname']; ?> </a> </td> <td width="100"><?php echo get_book_type_name($row['booktype']); ?> </td> <td width="120"><?php echo $row['booknum']; ?> 本</td> <td width="80" align="center"><?php echo get_realname($row['uid']); ?> </td> <td class="info"><?php echo $row['date']; ?> </td> <td width="180" align="center">