通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
源代码在线查看： start_work.php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_org.php" );
include_once( "check_priv.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 b.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 a \r\n LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID\r\n 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 )
{
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 a \r\n LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID\r\n 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 );
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 )
{
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";
?>
