remind.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 569 行 · 第 1/2 页

PHP
569 行
字号
12
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '<html>
<head>
<title>人事合同到期提醒</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function Rem';
  echo 'ind_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+"&Q';
  echo 'UERY_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_';
  echo '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.avail';
  echo 'Width-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+",resiza';
  echo 'ble=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellpadding="3" cellspacing="1" align="center" bgcolor="#000000">
 <form method="post" name="form1">
  <tr>
  	<td class="TableHeader">
    &nbsp;查询 &nbsp;';
  echo '<s';
  echo 'elect 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="';
  echo $QUERY_DATE1;
  echo '">
     <img src="/images/menu/calendar.gif" align=absbottom border="0" style="cursor:hand" onclick="td_calendar(\'form1.QUERY_DATE1\');">
     至<input type="text" name="QUERY_DATE2" size="10" class="SmallInput" value="';
  echo $QUERY_DATE2;
  echo '">
     <img src="/images/menu/calendar.gif" align=absbottom border="0" style="cursor:hand" onclick="td_calendar(\'form1.QUERY_DATE2\');">
     <input type="button" value="确定" class="SmallButton" onclick="Remind_Report();">&nbsp;&nbsp;
   </td>
  </tr>
 </form>
</table>
';
  $CUR_YEAR = date ('Y', time ());
  $query = (((''.' and USER.DEPT_ID!=\'0\' and (CONTRACT_DATE2!=\'0000-00-00\' and YEAR(CONTRACT_DATE2)=\'').$CUR_YEAR).'\')');
  $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 '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/hrms.gif" HEIGHT="20">';
    echo '<s';
    echo 'pan class="big3"> 合同到期人员</span><br>
    </td>
    <td valign="bottom" align="right">';
    echo '<s';
    echo 'pan class="small1">共&nbsp;';
    echo '<s';
    echo 'pan class="big4">';
    echo $HRMS_COUNT;
    echo '</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');
    }
    ($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 '<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <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>
';
        }
        echo ' <tr class="TableData">
      <td nowrap align="center">';
        echo $DEPT_NAME;
        echo '</td>
      <td nowrap align="center">';
        echo $USER_NAME;
        echo '</td>
      <td nowrap align="center">';
        echo $SEX_DESC;
        echo '</td>
      <td nowrap align="center">';
        echo $CONTRACT_DATE1;
        echo '至';
        echo $CONTRACT_DATE2;
        echo '</td>
      <td nowrap align="center">
       <a href="hrms.php?USER_ID=';
        echo $USER_ID;
        echo '&SOURCE=remind"> 详情</a>
      </td>
    </tr>
';
        continue;
      }
    }
    echo '</table>
';
  }
  $CUR_DATE = date ('Y-m-d', time ());
  $CUR_YEAR = date ('Y', time ());
  $query = (((''.' and USER.DEPT_ID!=\'0\' and (CONTRACT_DATE1!=\'0000-00-00\' and YEAR(CONTRACT_DATE1)=\'').$CUR_YEAR).'\')');
  $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 '<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/hrms.gif" HEIGHT="20">';
    echo '<s';
    echo 'pan class="big3"> 合同转正人员</span><br>
    </td>
    <td valign="bottom" align="right">';
    echo '<s';
    echo 'pan class="small1">共&nbsp;';
    echo '<s';
    echo 'pan class="big4">';
    echo $HRMS_COUNT;
    echo '</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');
12

remind.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 remind.php 源码文件，采用 PHP 编程语言编写，共 569 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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