user_list.ihtml

phpShop是一个基于php的分布式电子商务模块

<?php 
  search_header($user_list_lbl, $modulename, "user_list"); 
?>
<?php
  // Enable the multi-page search result display
  if (empty($offset))
 	$offset=0;
  if ($keyword) {
     $list  = "SELECT * FROM auth_user_md5, user_info WHERE ";
     $count = "SELECT count(*) as num_rows FROM auth_user_md5, user_info WHERE ";
     $q  = "(auth_user_md5.username LIKE '%$keyword%' OR ";
     $q .= "auth_user_md5.perms LIKE '%$keyword%' OR ";
     $q .= "user_info.last_name LIKE '%$keyword%' OR ";
     $q .= "user_info.first_name LIKE '%$keyword%' OR ";
     $q .= "user_info.phone_1 LIKE '%$keyword%' ";
     $q .= ") ";
     $q .= "AND auth_user_md5.user_id=user_info.user_id ";
     $q .= "AND user_info.address_type='BT' ";
     $q .= "ORDER BY auth_user_md5.username, auth_user_md5.perms ";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;   
  }
  else 
  {
     $list  = "SELECT * FROM auth_user_md5, user_info ";
     $list .= "WHERE auth_user_md5.user_id=user_info.user_id ";
     $list .= "AND user_info.address_type='BT' ";
     $list .= "ORDER BY auth_user_md5.username, auth_user_md5.perms ";
     $list .= "LIMIT $offset, " . SEARCH_ROWS;
     $count = "SELECT count(*) as num_rows FROM auth_user_md5, user_info ";
     $count .= "WHERE auth_user_md5.user_id=user_info.user_id ";
     $count .= "AND user_info.address_type='BT' ";
  }
  $db->query($count);
  $db->next_record();
  $num_rows = $db->f("num_rows");
  if ($num_rows == 0) {
     echo "Your search returned 0 results.<BR>";
  }
  else {
?>
 <table width="100%" border="0" cellspacing="0" cellpadding="5" class="RecordsTable"> 
  <tr> 
     <td width="23%" class="RecordsTableHeader"><?php echo $user_list_username ?></td> 
     <td width="50%" class="RecordsTableHeader"><?php echo $user_list_full_name ?></td> 
     <td width="27%" class="RecordsTableHeader"><?php echo $user_list_group ?></td> 
   </tr> 
  <?php

$db->query($list);
while ($db->next_record()) { 

             if ($i++ % 2) 
                $bgcolor=SEARCH_COLOR_1;
             else
                $bgcolor=SEARCH_COLOR_2;
?> 
  <tr bgcolor="<?php echo $bgcolor ?>" nowrap="nowrap"> 
     <td width="23%"> 
      <?php
$url = SECUREURL . "?page=$modulename/user_form&user_id=";
$url .= $db->f("user_id");
echo "<A HREF=" . $sess->url($url) . " class=\"bLink\">";
echo $db->f("username"); 
echo "</A>"; ?> 
    </td> 
     <td width="50%"><?php echo $db->f("first_name") . " ";
echo $db->f("middle_name") . " ";
echo $db->f("last_name"); ?></td> 
     <td width="27%"> 
      <?php
// $url = SECUREURL . "?page=$modulename/user_by_group_list&perms=";
//$url .= $db->f("perms");
//echo "<A HREF=" . $sess->url($url) . ">";
echo $db->f("perms");  
//echo "</A>";
?> 
&nbsp;</td> 
   </tr> 
  <?php } ?> 
</table> 
<?php 
  search_footer($modulename, "user_list", $offset, $num_rows, $keyword); 
}
?>