Пример #1
0
/**
 * 获得特定的Tag列表
 *
 * @param unknown_type $dsql
 * @param unknown_type $pageno
 * @param unknown_type $pagesize
 * @param unknown_type $orderby
 */
function GetTagList($dsql, $pageno, $pagesize, $orderby = 'aid')
{
    global $cfg_phpurl, $addsql;
    $start = ($pageno - 1) * $pagesize;
    $printhead = "<table width='98%' border='0' cellpadding='1' cellspacing='1' align='center'  class='tbtitle' style='background:#E2F5BC;margin-bottom:5px;'>\r\n\t\t<tr align='center' bgcolor='#FBFCE2'>\r\n          <td width='5%' class='tbsname'><a href='#' onclick=\"ReloadPage('aid')\"><u>ID</u></a></td>\r\n\t\t  <td width='20%' class='tbsname'>列表名称</td>\r\n\t\t  <td width='20%' class='tbsname'>模板文件</td>\r\n\t\t  <td width='5%' class='tbsname'><a href='#' onclick=\"ReloadPage('click')\"><u>点击</u></a></td>\r\n\t\t  <td width='15%' class='tbsname'>创建时间</td>\r\n\t\t  <td class='tbsname'>管理</td>\r\n  \t\t  </tr>\r\n";
    echo $printhead;
    $dsql->SetQuery("Select aid,title,templet,click,edtime,namerule,listdir,defaultpage,nodefault From #@__freelist {$addsql} order by {$orderby} desc limit {$start},{$pagesize} ");
    $dsql->Execute();
    while ($row = $dsql->GetArray()) {
        $listurl = GetFreeListUrl($row['aid'], $row['namerule'], $row['listdir'], $row['defaultpage'], $row['nodefault']);
        $line = "\r\n\t<tr align='center' bgcolor='#FFFFFF' onMouseMove=\"javascript:this.bgColor='#FCFEDA';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n        <td>{$row['aid']}</td>\r\n        <td> <a href='{$listurl}' target='_blank'>{$row['title']}</a> </td>\r\n        <td> {$row['templet']} </td>\r\n        <td> {$row['click']} </td>\r\n        <td>" . MyDate("y-m-d", $row['edtime']) . "</td>\r\n        <td> <a href='#' onclick='EditNote({$row['aid']})'>更改</a> |\r\n    \t<a href='#' onclick='CreateNote({$row['aid']})'>更新</a> |\r\n     \t<a href='#' onclick='DelNote({$row['aid']})'>删除</a>\r\n\t</td>\r\n  </tr>";
        echo $line;
    }
    echo "</table>\r\n";
}
Пример #2
0
function GetTagList($dsql,$pageno,$pagesize,$orderby='aid'){
	global $cfg_phpurl,$addsql;
	$start = ($pageno-1) * $pagesize;
	$printhead ="<table width='96%' border='0' cellpadding='1' cellspacing='1' align='center' style='margin:0px auto' class='tblist'>
		<tr align='center'>
          <td width='5%' class='tbsname'><a href='#' onclick=\"ReloadPage('aid')\"><u>ID</u></a></td>
		  <td width='20%' class='tbsname'>列表名称</td>
		  <td width='20%' class='tbsname'>模板文件</td>
		  <td width='5%' class='tbsname'><a href='#' onclick=\"ReloadPage('click')\"><u>点击</u></a></td>
		  <td width='15%' class='tbsname'>创建时间</td>
		  <td class='tbsname'>管理</td>
  		  </tr>\r\n";


	
    echo $printhead;
    $dsql->SetQuery("Select aid,title,templet,click,edtime,namerule,listdir,defaultpage,nodefault From #@__freelist $addsql order by $orderby desc limit $start,$pagesize ");
	  $dsql->Execute();
    while($row = $dsql->GetArray()){
    $listurl = GetFreeListUrl($row['aid'],$row['namerule'],$row['listdir'],$row['defaultpage'],$row['nodefault']);
    $line = "
		<tr align='center' onMouseMove=\"javascript:this.bgColor='#FCFEDA';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\"> 
        <td>{$row['aid']}</td>
        <td> <a href='$listurl' target='_blank'>{$row['title']}</a> </td>
        <td> {$row['templet']} </td>
        <td> {$row['click']} </td>
        <td>".strftime("%y-%m-%d",$row['edtime'])."</td>
        <td>
			  <a href='#' onclick='EditNote({$row['aid']})'>更改</a> | 
    		  <a href='#' onclick='CreateNote({$row['aid']})'>更新</a> | 
     		  <a href='#' onclick='DelNote({$row['aid']})'>删除</a>
		</td>
  </tr>";
    echo $line;
   }
	 echo "</table>\r\n";
}