📄 end_work.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_org.php");
include_once("check_priv.php");
?>
<html>
<head>
<title>人事合同到期</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function operate(USER_ID)
{
  window.opener.location="hrms.php?USER_ID="+USER_ID+"&SOURCE=remind";
  window.close();
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<br>
<?
$query=" and b.DEPT_ID!='0' and CONTRACT_DATE2!='0000-00-00'";
if($QUERY_DATE1!="")
	  $query.=" and (CONTRACT_DATE2>='$QUERY_DATE1')";
if($QUERY_DATE2!="")
	  $query.=" and (CONTRACT_DATE2<='$QUERY_DATE2')";  
$query1="select *  from HRMS a 
         LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID
         LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
         LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV";
$query1.=" where 1=1";
$query1.=$query.$WHERE_STR;
$cursor= exequery($connection,$query1);//echo $query1;
$HRMS_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
   	$DEPT_ID=$ROW["DEPT_ID"];
    $USER_ID=$ROW["USER_ID"];
    $HRMS_COUNT++;
}
if($HRMS_COUNT!=0)
{
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/hrms.gif" HEIGHT="20"><span class="big3"> 合同到期人员</span><br>
    </td>
    <td valign="bottom" align="right"><span class="small1">共&nbsp;<span class="big4"><?=$HRMS_COUNT?></span>&nbsp;条信息</span>
    </td>
  </tr>
</table>
<br>
<?
 $HRMS_COUNT=0;
 $query1="select *  from HRMS a 
         LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID
         LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
         LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV";
 $query1.=" where 1=1";
 $query1.=$query.$WHERE_STR;
 $cursor= exequery($connection,$query1);//echo $query1;
 while($ROW=mysql_fetch_array($cursor))
 {
 	 $NATIVE_PLACENAME="";
   $USER_ID=$ROW["USER_ID"];
   $USER_NAME=$ROW["USER_NAME"];
   $DEPT_NAME=$ROW["DEPT_NAME"];
   $DEPT_ID=$ROW["DEPT_ID"];
   $SEX=$ROW["SEX"];
   $HR_BIRTHDAY=$ROW["HR_BIRTHDAY"];
   $CONTRACT_DATE1=$ROW["CONTRACT_DATE1"];
   $CONTRACT_DATE2=$ROW["CONTRACT_DATE2"];
   $query1 = "SELECT CODE_NAME from SYS_CODE where PARENT_NO='AREA' and CODE_NO='$NATIVE_PLACE'";
   $cursor1= exequery($connection,$query1);
   if($ROW=mysql_fetch_array($cursor1))$NATIVE_PLACENAME=$ROW["CODE_NAME"];

   $HRMS_COUNT++;
   if($SEX=="0")
      $SEX_DESC="男";
   else if($SEX=="1")
      $SEX_DESC="女";
   else
      $SEX_DESC="";

   if($HR_BIRTHDAY=="0000-00-00"||$HR_BIRTHDAY=="1900-01-01")
      $HR_BIRTHDAY="";

   if($HRMS_COUNT==1)
   {
?>
<table width="100%" class="TableList">
  <tr class="TableHeader">
  	  <td nowrap align="center">部门</td>
      <td nowrap align="center">姓名</td>
      <td nowrap align="center">性别</td>
      <td nowrap align="center">合同期</td>
      <td nowrap align="center">操作</td>
    </tr>
<?
   }
?>
 <tr class="TableData">
      <td nowrap align="center"><?=$DEPT_NAME?></td>
      <td nowrap align="center"><?=$USER_NAME?></td>
      <td nowrap align="center"><?=$SEX_DESC?></td>
      <td nowrap align="center"><?=$CONTRACT_DATE1?>至<?=$CONTRACT_DATE2?></td>
      <td nowrap align="center">
       <a href="#" onClick="operate('<?=$USER_ID?>')"> 详情</a>
      </td>
    </tr>
<?
}
?>
</table>
<?
}
else
{
  Message("","无符合条件的记录!");
}
?>
<br>
<div align="center">
  <input type="button" class="SmallButton" value="关闭" onClick="window.close();">
</div>    
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -