通达OA2007SE源代码 非常好的

								  include_once 'inc/auth.php';
				  include_once 'inc/check_type.php';
				  include_once 'inc/utility_all.php';
				  echo '
				
				人事合同到期
				
				';
				  echo '				  echo 'cript>
				function operate(USER_ID)
				{
				  window.opener.location="hrms.php?USER_ID="+USER_ID+"&SOURCE=remind";
				  window.close();
				}
				
				
				
				
				';
				  $query = ' and USER.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				  }
				  $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))
				    {
				      continue;
				    }
				    else
				    {
				      ++$HRMS_COUNT;
				      continue;
				    }
				  }
				  if (($HRMS_COUNT != 0))
				  {
				    echo '
				  
				    ';
				    echo '				    echo 'pan class="big3"> 合同到期人员
				    
				    ';
				    echo '				    echo 'pan class="small1">共 ';
				    echo '				    echo 'pan class="big4">';
				    echo $HRMS_COUNT;
				    echo ' 条信息
				    
				  
				
				
				';
				    $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))
				      {
				        continue;
				      }
				      else
				      {
				        ++$HRMS_COUNT;
				        if (($SEX == '0'))
				        {
				          $SEX_DESC = '男';
				        }
				        else
				        {
				          if (($SEX == '1'))
				          {
				            $SEX_DESC = '女';
				          }
				          else
				          {
				            $SEX_DESC = '';
				          }
				        }
				        if ((($HR_BIRTHDAY == '0000-00-00') OR ($HR_BIRTHDAY == '1900-01-01')))
				        {
				          $HR_BIRTHDAY = '';
				        }
				        if (($HRMS_COUNT == 1))
				        {
				          echo '
				  
				  	  部门
				      姓名
				      性别
				      合同期
				      操作
				    
				';
				        }
				        echo ' 
				      ';
				        echo $DEPT_NAME;
				        echo '
				      ';
				        echo $USER_NAME;
				        echo '
				      ';
				        echo $SEX_DESC;
				        echo '
				      ';
				        echo $CONTRACT_DATE1;
				        echo '至';
				        echo $CONTRACT_DATE2;
				        echo '
				      
				       				        echo $USER_ID;
				        echo '\')"> 详情
				      
				    
				';
				        continue;
				      }
				    }
				    echo '
				';
				  }
				  else
				  {
				    message ('', '无符合条件的纪录!');
				  }
				  echo '
				
				  
				    
				
				
				';
				?>