⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index1.php

📁 通达OA2007SE源代码 非常好的
💻 PHP
字号:
🔍 
<?
  include_once 'inc/auth.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 plan_detail(PLAN_ID)
{
 URL="../show/plan_detail.php?PLAN_ID="+PLAN_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"plan_detail","height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=120,left="+myleft+",resizable=yes");
}
function delete_work_plan(PLAN_ID)
{
 msg=\'确认要删除该项工作计划么？\';
 if(window.confirm(msg))
 {
  URL="de';
  echo 'lete.php?PLAN_ID=" + PLAN_ID;
  window.location=URL;
 }
}
function delete_all()
{
 msg=\'确认要删除所有工作计划么？\';
 if(window.confirm(msg))
 {
  URL="delete_all.php";
  window.location=URL;
 }
}
function change_type(WORK_TYPE)
{
  window.location="index1.php?WORK_TYPE="+WORK_TYPE;
}
function order_by(field,asc_desc)
{
  window.location="index1.php?TPYE=';
  echo $TPYE;
  echo '&WORK_TYPE=';
  echo $WORK_TYPE;
  echo '&FIELD="+field+"&ASC_DESC="+asc_desc;
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  if (($WORK_TYPE == ''))
  {
    $WORK_TYPE = 0;
  }
  if (($WORK_TYPE != 0))
  {
    $RANGE_STR = (((''.' and TYPE=\'').$WORK_TYPE).'\'');
  }
  if (($LOGIN_USER_PRIV != '1'))
  {
    $query = ((((''.'SELECT count(*) from WORK_PLAN where CREATOR=\'').$LOGIN_USER_ID).'\'').$RANGE_STR);
  }
  else
  {
    $query = ('SELECT count(*) from WORK_PLAN where 1=1'.$RANGE_STR);
  }
  $cursor = exequery ($connection, $query);
  $WORK_PLAN_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $WORK_PLAN_COUNT = $ROW[0];
  }
  if (($WORK_PLAN_COUNT == 0))
  {
    echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/work_plan.gif" width="22" height="20" align="absmiddle">';
    echo '<s';
    echo 'pan class="big3"> 工作计划管理 </span>&nbsp;
      ';
    echo '<s';
    echo 'elect name="WORK_TYPE" class="BigSelect" onchange="change_type(this.value);">
          <option value="0" ';
    if (($WORK_TYPE == '0'))
    {
      echo ' selected';
    }
    echo '>所有类别</option>
';
    $query = 'SELECT * from PLAN_TYPE order by TYPE_NO';
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $TYPE_ID = $ROW['TYPE_ID'];
      $TYPE_NAME = $ROW['TYPE_NAME'];
      echo '         <option value="';
      echo $TYPE_ID;
      echo '" ';
      if (($WORK_TYPE == $TYPE_ID))
      {
        echo 'selected';
      }
      echo '>';
      echo $TYPE_NAME;
      echo '</option>
';
    }
    echo '       </select>
    </td>
  </tr>
</table>
<br>
';
    message ('', '无工作计划');
    exit ();
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/work_plan.gif" width="22" height="20">';
  echo '<s';
  echo 'pan class="big3"> 工作计划管理 </span>&nbsp;
      ';
  echo '<s';
  echo 'elect name="WORK_TYPE" class="BigSelect" onchange="change_type(this.value);">
          <option value="0"';
  if (($WORK_TYPE == '0'))
  {
    echo ' selected';
  }
  echo '>所有类别</option>
';
  $query = 'SELECT * from PLAN_TYPE order by TYPE_NO';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $TYPE_ID = $ROW['TYPE_ID'];
    $TYPE_NAME = $ROW['TYPE_NAME'];
    echo '         <option value="';
    echo $TYPE_ID;
    echo '" ';
    if (($WORK_TYPE == $TYPE_ID))
    {
      echo 'selected';
    }
    echo '>';
    echo $TYPE_NAME;
    echo '</option>
';
  }
  echo '       </select>
    </td>
    <td valign="bottom" class="small1">共';
  echo '<s';
  echo 'pan class="big4">&nbsp;';
  echo $WORK_PLAN_COUNT;
  echo '</span>&nbsp;条工作计划
    </td>
  </tr>
</table>
';
  if (($ASC_DESC == ''))
  {
    $ASC_DESC = '1';
  }
  if (($ASC_DESC == '0'))
  {
    $ORDER_IMG = '<img border=0 src="/images/arrow_up.gif" width="11" height="10">';
  }
  else
  {
    $ORDER_IMG = '<img border=0 src="/images/arrow_down.gif" width="11" height="10">';
  }
  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" onclick="order_by(\'NAME\',\'';
  if (($FIELD == 'NAME'))
  {
    echo (1 - $ASC_DESC);
  }
  else
  {
    echo '1';
  }
  echo '\');" style="cursor:hand;"><u>计划名称</u>';
  if (($FIELD == 'NAME'))
  {
    echo $ORDER_IMG;
  }
  echo '</td>     
   <td nowrap align="center" onclick="order_by(\'BEGIN_DATE\',\'';
  if (($FIELD == 'BEGIN_DATE'))
  {
    echo (1 - $ASC_DESC);
  }
  else
  {
    echo '1';
  }
  echo '\');" style="cursor:hand;"><u>开始时间</u>';
  if ((($FIELD == 'BEGIN_DATE') OR ($FIELD == '')))
  {
    echo $ORDER_IMG;
  }
  echo '</td>
   <td nowrap align="center">结束时间</td>
   <td nowrap align="center" onclick="order_by(\'TYPE\',\'';
  if (($FIELD == 'TYPE'))
  {
    echo (1 - $ASC_DESC);
  }
  else
  {
    echo '1';
  }
  echo '\');" style="cursor:hand;"><u>计划类别</u>';
  if (($FIELD == 'TYPE'))
  {
    echo $ORDER_IMG;
  }
  echo '</td>
   <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>
';
  $CUR_DATE = date ('Y-m-d', time ());
  if (($LOGIN_USER_PRIV != '1'))
  {
    $query = (((''.'SELECT * from WORK_PLAN where CREATOR=\'').$LOGIN_USER_ID).'\'');
  }
  else
  {
    $query = 'SELECT * from WORK_PLAN where 1=1';
  }
  ($query .= $RANGE_STR);
  if (($FIELD == ''))
  {
    ($query .= ' order by CREATE_DATE desc,BEGIN_DATE desc');
  }
  else
  {
    ($query .= (' order by '.$FIELD));
    if (($ASC_DESC == '1'))
    {
      ($query .= ' desc');
    }
    else
    {
      ($query .= ' asc');
    }
  }
  $cursor = exequery ($connection, $query);
  $WORK_PLAN_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$WORK_PLAN_COUNT;
    $PLAN_ID = $ROW['PLAN_ID'];
    $NAME = $ROW['NAME'];
    $BEGIN_DATE = $ROW['BEGIN_DATE'];
    $END_DATE = $ROW['END_DATE'];
    $TYPE = $ROW['TYPE'];
    $TO_ID = $ROW['TO_ID'];
    $MANAGER = $ROW['MANAGER'];
    $PARTICIPATOR = $ROW['PARTICIPATOR'];
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    $TO_PERSON_ID = $ROW['TO_PERSON_ID'];
    $SUSPEND_FLAG = $ROW['SUSPEND_FLAG'];
    $CREATOR = $ROW['CREATOR'];
    $query = (((''.'SELECT * from PLAN_TYPE where TYPE_ID=\'').$TYPE).'\'');
    $cursor1 = exequery ($connection, $query);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $TYPE_DESC = $ROW1['TYPE_NAME'];
    }
    else
    {
      $TYPE_DESC = '';
    }
    $TO_PERSON_NAME = '';
    $TOK = strtok ($TO_PERSON_ID, ',');
    while (($TOK != ''))
    {
      if (($TO_PERSON_NAME != ''))
      {
        ($TO_PERSON_NAME .= '，');
      }
      $query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $DEPT_ID = $ROW1['DEPT_ID'];
        $DEPT_NAME = dept_long_name ($DEPT_ID);
        ($TO_PERSON_NAME .= (((('<u title="部门：'.$DEPT_NAME).'" style="cursor:hand">').$ROW1['USER_NAME']).'</u>'));
      }
      $TOK = strtok (',');
    }
    $MANAGE_NAME = '';
    $TOK = strtok ($MANAGER, ',');
    while (($TOK != ''))
    {
      if (($MANAGE_NAME != ''))
      {
        ($MANAGE_NAME .= '，');
      }
      $query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $USER_ID1 = $ROW1['USER_ID'];
        $DEPT_ID = $ROW1['DEPT_ID'];
        $DEPT_NAME = dept_long_name ($DEPT_ID);
        ($MANAGE_NAME .= (((((((''.'<a href="javascript:;" onClick="window.open(\'arrange_work/index.php?USER_ID=').$USER_ID1).'\',\'\',\'height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes\');"><u title="部门：').$DEPT_NAME).'" style="cursor:hand">').$ROW1['USER_NAME']).'</u></a>'));
      }
      $TOK = strtok (',');
    }
    $MANAGE_NAME = substr ($MANAGE_NAME, 0, -1);
    $PARTICIPATOR_NAME = '';
    $TOK = strtok ($PARTICIPATOR, ',');
    while (($TOK != ''))
    {
      if (($PARTICIPATOR_NAME != ''))
      {
        ($PARTICIPATOR_NAME .= '，');
      }
      $query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $USER_ID1 = $ROW['USER_ID'];
        $DEPT_ID = $ROW['DEPT_ID'];
        $DEPT_NAME = dept_long_name ($DEPT_ID);
        ($PARTICIPATOR_NAME .= (((((((''.'<a href="javascript:;" onClick="window.open(\'arrange_work/index.php?USER_ID=').$USER_ID1).'\',\'\',\'height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes\');"><u title="部门：').$DEPT_NAME).'" style="cursor:hand">').$ROW['USER_NAME']).'</u></a>'));
      }
      $TOK = strtok (',');
    }
    $PARTICIPATOR_NAME = substr ($PARTICIPATOR_NAME, 0, -1);
    if (($SUSPEND_FLAG == 1))
    {
      if ((compare_date ($CUR_DATE, $BEGIN_DATE) < 0))
      {
        $STATUS = 1;
        $STATUS_DESC = '未开始';
      }
      else
      {
        $STATUS = 2;
        $STATUS_DESC = '<font color=\'#00AA00\'><b>进行中</b></font>';
      }
      if (($END_DATE != '0000-00-00'))
      {
        if ((0 < compare_date ($CUR_DATE, $END_DATE)))
        {
          $STATUS = 3;
          $STATUS_DESC = '<font color=\'#FF0000\'><b>已结束</b></font>';
        }
      }
    }
    else
    {
      $STATUS = 2;
      $STATUS_DESC = '<font color=\'#FF0000\'><b>暂停</b></font>';
    }
    if ((($WORK_PLAN_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    if (($END_DATE == '0000-00-00'))
    {
      $END_DATE = '';
    }
    echo '   <tr class="';
    echo $TableLine;
    echo '">
     <td align="center">';
    echo $WORK_PLAN_COUNT;
    echo '</td>   
     <td align="center"><a href="javascript:plan_detail(\'';
    echo $PLAN_ID;
    echo '\');">';
    echo $NAME;
    echo '</a></td>
     <td nowrap align="center">';
    echo $BEGIN_DATE;
    echo '</td>
     <td nowrap align="center">';
    echo $END_DATE;
    echo '</a></td>
     <td nowrap align="center">';
    echo $TYPE_DESC;
    echo '</td>
     <td align="center">';
    echo $MANAGE_NAME;
    echo '</td>
     <td align="center">';
    echo $PARTICIPATOR_NAME;
    echo '</td>
     <td align="left">
';
    if (($ATTACHMENT_NAME == ''))
    {
      echo '无';
    }
    else
    {
      echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 0, 0);
    }
    echo '     </td>
     <td nowrap align="center">';
    echo $STATUS_DESC;
    echo '</td>
     <td nowrap align="center">
';
    if (($STATUS == 1))
    {
      echo '     <a href="new?PLAN_ID=';
      echo $PLAN_ID;
      echo '"> 修改</a>  
     <a href="javascript:delete_work_plan(\'';
      echo $PLAN_ID;
      echo '\');"> 删除</a>
';
    }
    else
    {
      if ((($LOGIN_USER_PRIV == 1) OR ($CREATOR == $LOGIN_USER_ID)))
      {
        echo '     <a href="new?PLAN_ID=';
        echo $PLAN_ID;
        echo '"> 修改</a>  
     <a href="javascript:delete_work_plan(\'';
        echo $PLAN_ID;
        echo '\');"> 删除</a>
';
      }
    }
    echo '     <a href="javascript:;" onClick="window.open(\'add_opinion.php?PLAN_ID=';
    echo $PLAN_ID;
    echo '\',\'\',\'height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes\');">批注</a><br>
';
    if (($STATUS == 1))
    {
      echo '     <a href="manage.php?PLAN_ID=';
      echo $PLAN_ID;
      echo '&OPERATION=1&WORK_TYPE=';
      echo $WORK_TYPE;
      echo '"> 生效</a>
';
    }
    else
    {
      if (($STATUS == 2))
      {
        if (($SUSPEND_FLAG == 1))
        {
          echo (((((''.'<a href="manage.php?PLAN_ID=').$PLAN_ID).'&OPERATION=4&WORK_TYPE=').$WORK_TYPE).'"> 暂停</a>');
        }
        else
        {
          echo (((((''.'<a href="manage.php?PLAN_ID=').$PLAN_ID).'&OPERATION=5&WORK_TYPE=').$WORK_TYPE).'"> 继续</a>');
        }
        echo '         
     <a href="manage.php?PLAN_ID=';
        echo $PLAN_ID;
        echo '&OPERATION=2&WORK_TYPE=';
        echo $WORK_TYPE;
        echo '"> 结束</a>
     ';
      }
      else
      {
        if (($STATUS == 3))
        {
          echo '     <a href="manage.php?PLAN_ID=';
          echo $PLAN_ID;
          echo '&OPERATION=3&WORK_TYPE=';
          echo $WORK_TYPE;
          echo '"> 生效</a>
     ';
        }
      }
    }
    echo '        <a href="javascript:;" onClick="window.open(\'../show/progress_map.php?PLAN_ID=';
    echo $PLAN_ID;
    echo '\',\'\',\'height=550,width=800,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=110,top=60,resizable=yes\');">进度图</a>     
     </td>
   </tr>
';
  }
  echo '
<tr class="TableControl">
<td colspan="11" align="center">
    <input type="button"  value="全部删除" class="SmallButton" onClick="delete_all()" title="删除所有自己发布的工作计划">
</td>
</tr>
</table>
</body>
</html>
';
?>

⌨️ 快捷键说明

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