attach.inc.php

CRM 不仅仅是一个管理名词和管理概念

<?
	///////////////////////////////////////////
	// 入口参数
	// $Column	栏目
	// $ColumnID	栏目下的ID
?>
      <table width="95%" border="0" cellspacing="0" cellpadding="2" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
        <tr> 
          <td width=80%>&nbsp;<b>附件</b></td>
          <td width=20% align=right> 
            <input type="button" value="上传附件" onClick="javascript:window.open('attach_add.php?Column=<? echo $Column ?>&ColumnID=<? echo $ColumnID ?>','a','status=yes,width=300,height=160')";>
          </td>
        </tr>
      </table>
      <table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#ede5d2">
        <tr> 
          <td><b>附件名</b></td>
          <td><b>文件大小</b></td>
          <td><b>上传者</b></td>
          <td><b>上传时间</b></td>
          <td width="80"><b>删 除</b></td>
        </tr>
<?
	$sql_attach="select * from $tbl_crm_attach where AttachColumnID='$ColumnID' and AttachColumn='$Column' order by AttachID";
	$res_attach=mysql_query($sql_attach);
	while($row_attach=mysql_fetch_array($res_attach)){
		$filesize = $row_attach[FileSize];
		if ($filesize > 1024*1024)
			$fz = floor($filesize/(1024*1024))." MB";
		else if ($filesize > 1024)
			$fz = floor($filesize/1024)." KB";
		else
			$fz = $filesize." 字节";
?> 
        <tr> 
          <td><a href="attach_down.php?AttachID=<? echo $row_attach[AttachID]; ?>&AttachName=<? echo $row_attach[AttachName]; ?>"><? echo $row_attach[FileName]; ?></a>&nbsp;</td>
          <td><? echo $fz; ?>&nbsp;</td>
          <td><? echo $array_crm_id2user[$row_attach[UploaderID]];?>&nbsp;</td>
		  <td><? echo $row_attach[UploadTime];?>&nbsp;</td>
		  <td><input type="button" value="删除" style="width:40" onClick="javascript:window.open('attach_del.php?AttachID=<? echo $row_attach[AttachID] ?>','','width=300,height=160')";></td>
		</tr>
        <?
	}
?> 
      </table>
      <br>