Example #1
0
    <td class="Big"><img src="template/default/content/images/notify_new.gif" align="absmiddle"><span class="big3"> 图书信息查看</span>&nbsp;&nbsp;&nbsp;&nbsp;
	<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 
Example #2
0
    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);
}
Example #3
0
</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">