📄 list.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>表单设置</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function delete_form(FORM_ID)
{
 msg=\'确认要删除该表单么？这将删除表单描述与字段设置且不可恢复！\';
 if(window.confirm(msg))
 {
  URL="delete.php?FORM_ID="+FORM_ID;
  window.location=URL;
 }
}
function edit_form(FORM_ID)
{
  window.open("cool_form?FORM_ID="+FORM_ID,"cool_form","menubar=0,toolbar=0,scrollbars=no,status=0,resizable=1")
}
</script>
</head>
<body class="bodycolo';
  echo 'r" topmargin="5">
';
  $query = ((''.'SELECT * from FLOW_SORT where SORT_ID=').$SORT_ID);
  $cursor0 = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor0))
  {
    $SORT_NO = $ROW['SORT_NO'];
    $SORT_NAME = $ROW['SORT_NAME'];
    $SORT_NAME = str_replace ('<', '&lt', $SORT_NAME);
    $SORT_NAME = str_replace ('>', '&gt', $SORT_NAME);
    $SORT_NAME = stripslashes ($SORT_NAME);
  }
  else
  {
    $SORT_NAME = '未分类表单 <font color=red>注意：表单是跟随流程分类的</font>';
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 管理表单 - ';
  echo $SORT_NAME;
  echo '</span><br>
    </td>
  </tr>
</table>
';
  if (($SORT_ID != 0))
  {
    $query = (((''.'SELECT * from FLOW_FORM_TYPE,FLOW_TYPE where FLOW_FORM_TYPE.FORM_ID=FLOW_TYPE.FORM_ID and FLOW_SORT=').$SORT_ID).' order by FLOW_NO');
    $cursor = exequery ($connection, $query);
    $FORM_COUNT = 0;
    $FORM_ID_STR = '';
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$FORM_COUNT;
      $FORM_ID = $ROW['FORM_ID'];
      $FORM_NAME = $ROW['FORM_NAME'];
      if (find_id ($FORM_ID_STR, $FORM_ID))
      {
        continue;
      }
      ($FORM_ID_STR .= ($FORM_ID.','));
      $FORM_NAME = str_replace ('<', '&lt', $FORM_NAME);
      $FORM_NAME = str_replace ('>', '&gt', $FORM_NAME);
      $FORM_NAME = stripslashes ($FORM_NAME);
      if (($FORM_COUNT == 1))
      {
        echo '  <table border="0" cellspacing="1" width="100%" align="center" class="small" bgcolor="#000000" cellpadding="3">
    <tr class="TableHeader">
      <td nowrap align="center">表单名称</td>
      <td nowrap align="center">操作</td>
    </tr>
';
      }
      if ((($FORM_COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '
    <tr class="';
      echo $TableLine;
      echo '">
      <td width="250" align="center">';
      echo $FORM_NAME;
      echo '</td>
      <td nowrap>
          <a href="edit.php?FORM_ID=';
      echo $FORM_ID;
      echo '">编辑表单名称</a>&nbsp;&nbsp;
          <a href="javascript:edit_form(';
      echo $FORM_ID;
      echo ')">表单智能设计器</a>&nbsp;&nbsp;
          <a href="form_view.php?FORM_ID=';
      echo $FORM_ID;
      echo '" target="_blank" title="表单预览">预览</a>&nbsp;&nbsp;
          <a href="import.php?SORT_ID=';
      echo $SORT_ID;
      echo '&FORM_ID=';
      echo $FORM_ID;
      echo '" title="可将一些备份的表单或优秀的表单导入">导入</a>&nbsp;&nbsp;
          <a href="export.php?FORM_ID=';
      echo $FORM_ID;
      echo '" title="可以将表单导出后，与其他OA用户分享" target="_blank">导出</a>&nbsp;&nbsp;
';
      $query1 = (((''.'SELECT * from FLOW_TYPE,FLOW_RUN where FLOW_TYPE.FORM_ID=').$FORM_ID).' and FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID');
      $cursor1 = exequery ($connection, $query1);
      if (!$ROW = mysql_fetch_array ($cursor1))
      {
        echo '          <a href="javascript:delete_form(';
        echo $FORM_ID;
        echo ');">删除</a>&nbsp;
';
      }
      echo '      </td>
    </tr>
';
    }
  }
  else
  {
    $query = 'SELECT * from FLOW_FORM_TYPE order by FORM_NAME';
    $cursor = exequery ($connection, $query);
    $FORM_COUNT = 0;
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $FORM_ID = $ROW['FORM_ID'];
      $FORM_NAME = $ROW['FORM_NAME'];
      $query = ((''.'SELECT * from FLOW_TYPE where FORM_ID=').$FORM_ID);
      $cursor1 = exequery ($connection, $query);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        continue;
      }
      else
      {
        ++$FORM_COUNT;
        $FORM_NAME = str_replace ('<', '&lt', $FORM_NAME);
        $FORM_NAME = str_replace ('>', '&gt', $FORM_NAME);
        $FORM_NAME = stripslashes ($FORM_NAME);
        if (($FORM_COUNT == 1))
        {
          echo '  <table border="0" cellspacing="1" width="100%" align="center" class="small" bgcolor="#000000" cellpadding="3">
    <tr class="TableHeader">
      <td nowrap align="center">表单名称</td>
      <td nowrap align="center">操作</td>
    </tr>
';
        }
        if ((($FORM_COUNT % 2) == 1))
        {
          $TableLine = 'TableLine1';
        }
        else
        {
          $TableLine = 'TableLine2';
        }
        echo '
    <tr class="';
        echo $TableLine;
        echo '">
      <td width="250" align="center">';
        echo $FORM_NAME;
        echo '</td>
      <td nowrap>
          <a href="edit.php?FORM_ID=';
        echo $FORM_ID;
        echo '">编辑表单名称</a>&nbsp;&nbsp;
          <a href="javascript:edit_form(';
        echo $FORM_ID;
        echo ')">表单智能设计器</a>&nbsp;&nbsp;
          <a href="form_view.php?FORM_ID=';
        echo $FORM_ID;
        echo '" target="_blank" title="表单预览">预览</a>&nbsp;&nbsp;
          <a href="import.php?SORT_ID=';
        echo $SORT_ID;
        echo '&FORM_ID=';
        echo $FORM_ID;
        echo '" title="可将一些备份的表单或优秀的表单导入">导入</a>&nbsp;&nbsp;
          <a href="export.php?FORM_ID=';
        echo $FORM_ID;
        echo '" title="可以将表单导出后，与其他OA用户分享" target="_blank">导出</a>&nbsp;&nbsp;
';
        $query1 = (((''.'SELECT * from FLOW_TYPE,FLOW_RUN where FLOW_TYPE.FORM_ID=').$FORM_ID).' and FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID');
        $cursor1 = exequery ($connection, $query1);
        if (!$ROW = mysql_fetch_array ($cursor1))
        {
          echo '          <a href="javascript:delete_form(';
          echo $FORM_ID;
          echo ');">删除</a>&nbsp;
';
        }
        echo '      </td>
    </tr>
';
        continue;
      }
    }
  }
  if ((0 < $FORM_COUNT))
  {
    echo '</table>';
  }
  if (($FORM_COUNT == 0))
  {
    message ('', '尚未定义表单');
  }
  echo '
</body>
</html>';
?>
⌨️ 快捷键说明

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