user_list1.php

通达OA官方提供的30源代码,感觉很实在

<?
include_once("inc/auth.php");
//选择离职用户

$MENU_TOP=array();

$PRIV_NO_FLAG="2";
$MANAGE_FLAG="1";
$MODULE_ID=9;
include_once("inc/my_priv.php");

if($DEPT_PRIV=="1")
{
   $target="hrms";
   $user_list=array(
   "PARA_URL1" => "",
   "PARA_URL2" => "/general/hrms/manage/hrms.php",
   "PARA_TARGET" => $target,
   "PRIV_NO_FLAG" => "1",
   "MANAGE_FLAG" => "1",
   "MODULE_ID" => "9",
   "xname" => "hrms_manage",
   "showButton" => "0",
   "xtree" => "/general/hrms/manage/tree.php",
   "include_file" => "inc/user_list/index.php");
   
   $MENU_LEFT[count($MENU_LEFT)] = array("text" => "已记录所属部门", "href" => "", "onclick" => "clickMenu", "target" => $target, "title" => "点击伸缩列表", "img" => "", "module" => $user_list, "module_style" => $module_style);

   $query = "SELECT * from USER_PRIV where USER_PRIV=$LOGIN_USER_PRIV";
   $cursor= exequery($connection,$query);
   if($ROW=mysql_fetch_array($cursor))
      $PRIV_NO=$ROW["PRIV_NO"];
   
   $user_out='<table class="TableBlock" width="100%" align="center">';

   $query = "SELECT USER.USER_ID,USER_NAME,PRIV_NAME from USER_PRIV,USER left join HRMS on USER.USER_ID=HRMS.USER_ID where USER.DEPT_ID=0 and (HRMS.DEPT_ID=0 or HRMS.DEPT_ID is null) and USER.USER_PRIV=USER_PRIV.USER_PRIV";
   if($LOGIN_USER_PRIV!="1")
   {
      if($ROLE_PRIV=="0")
         $query .= " and USER_PRIV.PRIV_NO>$PRIV_NO";
      else if($ROLE_PRIV=="1")
         $query .= " and USER_PRIV.PRIV_NO>=$PRIV_NO";
      else if($ROLE_PRIV=="3")
         $query .= " and find_in_set(USER.USER_PRIV,'$PRIV_ID_STR')";
      if($PRIV_NO_FLAG=="3")
         $query .= " and USER_PRIV.USER_PRIV!=1";
      if($DEPT_PRIV=="3")
         $query .= " and find_in_set(USER.USER_ID,'$USER_ID_STR')";
   }
   $query.= " order by PRIV_NO,USER_NO,USER_NAME";//echo $query;exit;
   $cursor= exequery($connection,$query);
   while($ROW=mysql_fetch_array($cursor))
   {
      $USER_COUNT++;
      $USER_ID=$ROW["USER_ID"];
      $USER_NAME=$ROW["USER_NAME"];
      $PRIV_NAME=$ROW["PRIV_NAME"];

      $target="hrms";
      $user_out.='
   <tr class="TableData" align="center">
     <td nowrap width="80">'.$PRIV_NAME.'</td>
     <td nowrap><a href="hrms.php?USER_ID='.$USER_ID.'&DEPT_ID=0" target='.$target.'>'.$USER_NAME.'</a></td>
   </tr>';
   }
   $user_out.='</table>';
   $module_style="display:none;";
   
   $MENU_LEFT[count($MENU_LEFT)] = array("text" => "未记录所属部门", "href" => "", "onclick" => "clickMenu", "target" => $target, "title" => "点击伸缩列表", "img" => "", "module" => $user_out, "module_style" => $module_style);
}

include_once("inc/menu_left.php");
?>