极限网络智能办公系统 - Office Automation 2008 官方100％ 源码
源代码在线查看： start_work.php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
echo "\r\n\r\n人事合同转正\r\n\r\n\r\nfunction operate(USER_ID)\r\n{\r\n window.opener.location=\"hrms.php?USER_ID=\"+USER_ID+\"&SOURCE=remind\";\r\n window.close();\r\n}\t\r\n\r\n\r\n\r\n\r\n";
$query = " and USER.DEPT_ID!='0' and CONTRACT_DATE1!='0000-00-00'";
if ( $QUERY_DATE1 != "" )
{
$query .= " and (CONTRACT_DATE1>'".$QUERY_DATE1."')";
}
if ( $QUERY_DATE2 != "" )
{
$query .= " and (CONTRACT_DATE1 }
$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";
}
$query1 .= $query;
$cursor = exequery( $connection, $query1 );
$HRMS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
$USER_ID = $ROW['USER_ID'];
if ( !( is_dept_priv( $DEPT_ID ) == 0 ) )
{
++$HRMS_COUNT;
}
}
if ( $HRMS_COUNT != 0 )
{
echo "\r\n \r\n 人事合同转正\r\n \r\n 共 ";
echo $HRMS_COUNT;
echo " 条信息\r\n \r\n \r\n\r\n\r\n";
$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";
}
$query1 .= $query;
$cursor = exequery( $connection, $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 ( !( is_dept_priv( $DEPT_ID ) == 0 ) )
{
++$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 )
{
echo "\r\n \r\n \t 部门\r\n 姓名\r\n 性别\r\n 合同期\r\n 操作\r\n \r\n";
}
echo " \r\n ";
echo $DEPT_NAME;
echo "\r\n ";
echo $USER_NAME;
echo "\r\n ";
echo $SEX_DESC;
echo "\r\n ";
echo $CONTRACT_DATE1;
echo "至";
echo $CONTRACT_DATE2;
echo "\r\n \r\n echo $USER_ID;
echo "')\"> 详情\r\n \r\n \r\n";
}
}
echo "\r\n";
}
else
{
message( "", "无符合条件的纪录!" );
}
echo "\r\n\r\n \r\n \r\n\r\n\r\n";
?>
