查看文件: cuser.php

大小: 7.91 KB

类型: application/octet-stream

<?php require('system/login.php');  ?>
<?php require_once('../Connections/BE2.php'); ?>
<?php
if ((isset($_GET['check_id'])) && ($_GET['check_id'] != "")) {

// $deleteSQL = sprintf("DELETE FROM cuser WHERE level<'%s' AND cuid='%s'",$_SESSION['login_lv'],$_GET['check_id']);
 // mysql_select_db($database_BE2, $BE2);
 // $Result1= mysql_query($deleteSQL, $BE2) or die(mysql_error());
 
}

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Rt2 = 15;
$pageNum_Rt2 = 0;
if (isset($_GET['pageNum_Rt2'])) {
  $pageNum_Rt2 = $_GET['pageNum_Rt2'];
}
$startRow_Rt2 = $pageNum_Rt2 * $maxRows_Rt2;
mysql_select_db($database_BE2, $BE2);

$colname_Rt2 = "-1";
if (isset($_GET['keyword'])) {
  $colname_Rt2 = $_GET['keyword'];
}
if ($colname_Rt2=='-1') {
 	  $query_Rt2 = "SELECT * FROM cuser where fn='Y' AND ukid=1 ORDER BY idate DESC";
   }else{
	 $query_Rt2 = sprintf("SELECT * FROM cuser where fn='Y' AND ukid=1 AND webname like '%s' ORDER BY idate DESC",'%'.$colname_Rt2.'%');
	 //$query_Rt2 = "SELECT * FROM cuser where fn='Y' ORDER BY idate DESC";
	}

$query_limit_Rt2 = sprintf("%s LIMIT %d, %d", $query_Rt2, $startRow_Rt2, $maxRows_Rt2);
$Rt2 = mysql_query($query_limit_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);

if (isset($_GET['totalRows_Rt2'])) {
  $totalRows_Rt2 = $_GET['totalRows_Rt2'];
} else {
  $all_Rt2 = mysql_query($query_Rt2);
  $totalRows_Rt2 = mysql_num_rows($all_Rt2);
}
$totalPages_Rt2 = ceil($totalRows_Rt2/$maxRows_Rt2)-1;

$queryString_Rt2 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Rt2") == false && 
        stristr($param, "totalRows_Rt2") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Rt2 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Rt2 = sprintf("&totalRows_Rt2=%d%s", $totalRows_Rt2, $queryString_Rt2);
?>
 
<?php if ($totalRows_Rt2 > 0) { // Show if recordset not empty ?>
<form id="form1" name="form1" method="GET" action="">
  公司抬頭
    <input name="keyword" type="text" id="keyword" value="<?=  ($colname_Rt2<>-1)?$colname_Rt2:"" ;?>" />
    <input name="act" type="hidden" id="act" value="cuser" />
<input type="submit" name="Submit" value="送出" />

</form>

<div id="content" align="center">
 <table width="96%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <th align="center" valign="top" nowrap="nowrap" class="font2">資料編輯</th>
          <th align="center" valign="top" nowrap="nowrap" class="font2">使用者帳號</th>
          <th valign="top" nowrap="nowrap" class="font2">公司抬頭</th>
          <th align="center" valign="top" class="font2">簡短抬頭</th>
          <th align="center" valign="top" class="font2">聯絡人</th>
          <th align="center" valign="top" class="font2">廣告模板</th>
          <th width="8%" align="center" valign="top" nowrap="nowrap" class="font2">建立日期</th>
          <th align="center" valign="middle" nowrap="nowrap" class="font2">啟用/ </th>
          <th align="center" valign="middle" nowrap="nowrap" class="font2">刪除</th>
        </tr>
        <?php do { ?>
        <tr>
          <th width="8%" align="center" valign="top" nowrap="nowrap" class="font3"><a href="main.php?act=cuser_edit&id=<?php echo $row_Rt2['cuid']; ?>"><img src="images/edit.png" alt="修改項目名稱" width="16" height="16" border="0" /></a></th>
          <th width="10%" align="center" valign="top" nowrap="nowrap" class="font3"><?php echo $row_Rt2['name']; ?></th>
          <td width="29%" align="center" valign="top" nowrap="nowrap" class="font3"><a href="/<?php echo $row_Rt2['webname']; ?>" target="_blank"><?php echo $row_Rt2['webname']; ?></a></td>
          <td width="16%" align="center" valign="top" class="font3"><?= mb_substr( $row_Rt2['webname'],0,$row_Rt2['weblen'],"utf-8");?></td>
          <td width="11%" align="center" valign="top" class="font3"><font color="#FF0000"><?php echo $row_Rt2['name2']; ?></font></td>
          <td width="11%" align="center" valign="top" class="font3">
          <? if($row_Rt2['webaddr']<>''){?><a href="<?php echo $row_Rt2['webaddr']; ?>" target="_blank" ><img src="images/w.png" alt="名稱" width="32" height="32" border="0" /></a> <? }else{?>
          <a href="main.php?act=cuser_ad2&webid=<?php echo $row_Rt2['cuid']; ?>"><img src="images/browse.png" alt="修改項目名稱" width="32" height="32" border="0" /></a><? } ?></td>
          <td align="center" valign="top" class="font3"><?= $row_Rt2['idate']; ?></td>
          <td width="4%" align="center" valign="middle" class="font3"><?=  $row_Rt2['flag']; ?></td>
          <td width="3%" align="center" valign="middle" class="font3"><a href="javascript:if(confirm('確定要刪除嗎?'))location='<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, $pageNum_Rt2 , $queryString_Rt2)?><? echo "&check_id=".$row_Rt2['cuid']; ?>'"><img src="images/del.png" alt="刪除項目" width="16" height="16" border="0"/></a></td>
        </tr>
 
        <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); ?>
        <tr>
          <td height="3" colspan="9" align="center" ><table width="100%" border="0" align="left" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="34%">總筆數：<?php echo $totalRows_Rt2 ?>筆 </td>
                  <td width="66%"><div id="font_s">
                      <p>
                        <?php if ($pageNum_Rt2 > 0) { // Show if not first page ?>
                        <a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, max(0, $pageNum_Rt2 - 1), $queryString_Rt2); ?>"><img src="images/First.gif" alt="上一頁" title="上一頁" width="18" height="13" border="0" /></a>
                        <?php } // Show if not first page ?>
                        第
                        <select name="jumpMenu" id="jumpMenu" onchange="MM_jumpMenu('self',this,0)">
                          <? for($i=0;$i<=$totalPages_Rt2;$i++){?>
                          <option value="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, $i, $queryString_Rt2); ?>" <? if($pageNum_Rt2==$i){ ?>selected="selected" <? }?>><? echo $i+1 ;?></option>
                          <? }?>
                        </select>
                        頁
                        <?php
	    //分頁程式
if($totalPages_Rt2<9){
		 $start=0;
		 $end=$totalPages_Rt2;
		}else{  
	    $start=$pageNum_Rt2-5;
		$end=$pageNum_Rt2+5;
        if ($start<0){
		 $start=0;
		 $end=10; } 
		 else { $end=$start+10 ;}
		 if ($end>$totalPages_Rt2){ 
		   $start = $end-$totalPages_Rt2-5;
		   $end=$totalPages_Rt2;
		   }
		 if ($end-$start>10){ 
		   $start = $end-10;
		   }  
		 }
		   
		for($i=$start;$i<=$end;$i++){
		if($i==$pageNum_Rt2){ echo "[".($i+1)."]";} else {?>
                        <a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, min($totalPages_Rt2, $i), $queryString_Rt2); ?>"> <? echo $i+1 ;?></a>
                        <?	}   }  ?>
                        <?php if ($pageNum_Rt2 < $totalPages_Rt2) { // Show if not last page ?>
                        <a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, min($totalPages_Rt2, $pageNum_Rt2 + 1), $queryString_Rt2); ?>"><img src="images/Next.gif" alt="下一頁" title="下一頁" width="14" height="13" border="0" /></a>
                        <?php } // Show if not last page ?>
                      </p>
                  </div></td>
  </tr>
</table></td>
        </tr>
  </table>
</div>
<?php } // Show if recordset not empty ?>


<?php if ($totalRows_Rt2 == 0) { // Show if recordset empty ?>
<table width="600" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>尚無使用者、請新增</td>
  </tr>
</table>
<?php } // Show if recordset empty ?>

<?php
mysql_free_result($Rt2);
?>