⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 remind.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 src="/inc/js/module.js"></script>
<script>

function Remind_Report()
{
	if(document.form1.QUERY_DATE1.value=="" && document.form1.QUERY_DATE2.value=="")
	{
		alert("请确定时间范围");
		return
	} 
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
  if(document.form1.QUERY_TYPE.value=="0")
  {
  	URL="end_work.php?QUERY_DATE1="+document.form1.QUERY_DATE1.value+"&QUERY_DATE2="+document.form1.QUERY_DATE2.value;
    myleft=(screen.availWidth-500)/2;
    window.open(URL,"discard","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
  if(document.form1.QUERY_TYPE.value=="1")
  {
  	URL="start_work.php?QUERY_DATE1="+document.form1.QUERY_DATE1.value+"&QUERY_DATE2="+document.form1.QUERY_DATE2.value;
    myleft=(screen.availWidth-500)/2;
    window.open(URL,"discard","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
  if(document.form1.QUERY_TYPE.value=="2")
  {
  	URL="retire.php?QUERY_DATE1="+document.form1.QUERY_DATE1.value+"&QUERY_DATE2="+document.form1.QUERY_DATE2.value;
    myleft=(screen.availWidth-500)/2;
    window.open(URL,"discard","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
}
function set_age()
{
	URL="set_age.php";
	myleft=(screen.availWidth-500)/2;
    window.open(URL,"set_age","height=200,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<form method="post" name="form1">

<table border="0" width="100%" cellpadding="3" cellspacing="1" align="center" bgcolor="#000000">

  <tr>
  	<td class="TableHeader">
    &nbsp;查询 &nbsp;<select name="QUERY_TYPE" class="SmallSelect">
       <option value="0" selected>合同到期人员</option>
       <option value="1">合同转正人员</option>
       <option value="2">退休人员</option>
     </select>&nbsp;
    从<input type="text" name="QUERY_DATE1" size="10" class="SmallInput" value="<?=$QUERY_DATE1?>">
     <img src="/images/menu/calendar.gif" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.QUERY_DATE1');">
     至<input type="text" name="QUERY_DATE2" size="10" class="SmallInput" value="<?=$QUERY_DATE2?>">
     <img src="/images/menu/calendar.gif" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.QUERY_DATE2');">
     
     <input type="button" value="确定" class="SmallButton" onClick="Remind_Report();">&nbsp;&nbsp;
   </td>
  </tr>

</table>
</form>
<?
$CUR_YEAR=date("Y",time());
$CUR_MONTH=date("n",time());

$query=" and b.DEPT_ID!='0' and CURDATE()<=CONTRACT_DATE2 and CURDATE()>=EXPIRE_DATE and EXPIRE_DATE!='0000-00-00'";
$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);
$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>
<?
 $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="hrms.php?USER_ID=<?=$USER_ID?>&SOURCE=remind"> 详情</a>
      </td>
    </tr>
<?
}
?>
</table>
<?
}
//------合同转正-----
$CUR_DATE=date("Y-m-d",time());
$CUR_YEAR=date("Y",time());
$CUR_MONTH=date("n",time());
//在合同起始日到转正提醒日之间提醒
$query=" and b.DEPT_ID!='0' and CURDATE()>=CONTRACT_DATE1 and CURDATE()<=POSITIVE_DATE and CONTRACT_DATE1!='0000-00-00'";
$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)
{
?>
<br>
<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>
<?
 $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="hrms.php?USER_ID=<?=$USER_ID?>&SOURCE=remind"> 详情</a>
      </td>
    </tr>
<?
}
?>
</table>
<?
}

//------退休人员-----
$query = "SELECT * from SYS_PARA where PARA_NAME='RETIRE_AGE'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
   $PARA_NAME=$ROW["PARA_NAME"];
   $PARA_VALUE=$ROW["PARA_VALUE"];
}
$AGE_ARRAY=explode(",",$PARA_VALUE);
$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.=$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"];
   	$SEX=$ROW["SEX"];
   	$HR_BIRTHDAY=$ROW["HR_BIRTHDAY"];
    if($HR_BIRTHDAY=="0000-00-00"||$HR_BIRTHDAY=="1900-01-01")continue;
   	if($SEX=="0")
      {
      	$YEAR_MIN=date("Y",time())-$AGE_ARRAY[0];
      	$YEAR_BIRTHDAY=date("Y",strtotime($HR_BIRTHDAY));
		$MONTH_MIN=date("n",time());
        $MONTH_BIRTHDAY=date("n",strtotime($HR_BIRTHDAY));
      	if($YEAR_MIN!=$YEAR_BIRTHDAY)
        continue;
		if($MONTH_MIN!=$MONTH_BIRTHDAY)
		continue;
      }
    else
      {
      	$YEAR_MIN=date("Y",time())-$AGE_ARRAY[1];
        $YEAR_BIRTHDAY=date("Y",strtotime($HR_BIRTHDAY));
		$MONTH_MIN=date("n",time());
        $MONTH_BIRTHDAY=date("n",strtotime($HR_BIRTHDAY));
      	if($YEAR_MIN!=$YEAR_BIRTHDAY)
        continue;
		if($MONTH_MIN!=$MONTH_BIRTHDAY)
		continue;
      }
    $HRMS_COUNT++;
}

if($HRMS_COUNT!=0)
{
?>
<br>
<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>&nbsp;&nbsp;<span class="small1"><a href="javascript:set_age()">设定退休年龄</a></span><br>
    </td>
    <td valign="bottom" align="right"><span class="small1">共&nbsp;<span class="big4"><?=$HRMS_COUNT?></span>&nbsp;条信息</span>
    </td>
  </tr>
</table>
<?
 $HRMS_COUNT=0;
 $query1="select * from HRMS,USER,USER_PRIV";
 if($DEPT_ID!="0")
     $query1.=",DEPARTMENT";
 $query1.=" where HRMS.USER_ID=USER.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV";
 if($DEPT_ID!="0")
    $query1.=" and USER.DEPT_ID=DEPARTMENT.DEPT_ID";
 $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"];
   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")continue;
   if($SEX=="0")
      {
      	$YEAR_MIN=date("Y",time())-$AGE_ARRAY[0];
        $YEAR_BIRTHDAY=date("Y",strtotime($HR_BIRTHDAY));
		$MONTH_MIN=date("n",time());
        $MONTH_BIRTHDAY=date("n",strtotime($HR_BIRTHDAY));
      	if($YEAR_MIN!=$YEAR_BIRTHDAY)
        continue;
		if($MONTH_MIN!=$MONTH_BIRTHDAY)
		continue;
      }
   else
      {
      	$YEAR_MIN=date("Y",time())-$AGE_ARRAY[1];
        $YEAR_BIRTHDAY=date("Y",strtotime($HR_BIRTHDAY));
		$MONTH_MIN=date("n",time());
        $MONTH_BIRTHDAY=date("n",strtotime($HR_BIRTHDAY));
      	if($YEAR_MIN!=$YEAR_BIRTHDAY)
        continue;
		if($MONTH_MIN!=$MONTH_BIRTHDAY)
		continue;
      }
   $HRMS_COUNT++;
   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"><?=$HR_BIRTHDAY?></td>
      <td nowrap align="center">
        <a href="hrms.php?USER_ID=<?=$USER_ID?>&SOURCE=remind"> 详情</a>
      </td>
    </tr>
<?
}
?>
</table>
<?
}
else
{
?>
<br>
<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>&nbsp;&nbsp;<span class="small1"><a href="javascript:set_age()">设定退休年龄</a></span><br>
    </td>
  </tr>
</table>
<br>
<div align="center">
<?
   Message("","本月无退休人员!");
?>	
</div>	
<?
}
?>
</body>
</html>

⌨️ 快捷键说明

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