?? remind.php
字號(hào):
<?
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>
function Remind_Report()
{
if(document.form1.QUERY_DATE1.value=="" && document.form1.QUERY_DATE2.value=="")
{
alert("請(qǐng)確定時(shí)間范圍");
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">
查詢 <select name="QUERY_TYPE" class="SmallSelect">
<option value="0" selected>合同到期人員</option>
<option value="1">合同轉(zhuǎn)正人員</option>
<option value="2">退休人員</option>
</select>
從<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();">
</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">共 <span class="big4"><?=$HRMS_COUNT?></span> 條信息</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>
<?
}
//------合同轉(zhuǎn)正-----
$CUR_DATE=date("Y-m-d",time());
$CUR_YEAR=date("Y",time());
$CUR_MONTH=date("n",time());
//在合同起始日到轉(zhuǎn)正提醒日之間提醒
$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"> 合同轉(zhuǎn)正人員</span><br>
</td>
<td valign="bottom" align="right"><span class="small1">共 <span class="big4"><?=$HRMS_COUNT?></span> 條信息</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> <span class="small1"><a href="javascript:set_age()">設(shè)定退休年齡</a></span><br>
</td>
<td valign="bottom" align="right"><span class="small1">共 <span class="big4"><?=$HRMS_COUNT?></span> 條信息</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> <span class="small1"><a href="javascript:set_age()">設(shè)定退休年齡</a></span><br>
</td>
</tr>
</table>
<br>
<div align="center">
<?
Message("","本月無(wú)退休人員!");
?>
</div>
<?
}
?>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -