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

📄 others.php

📁 通达OA3.0源代码
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("../../prcs_role.php");

if(!run_role($RUN_ID,$PRCS_ID))
    exit;
?>

<html>
<head>
<title>委托代办人</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor" topmargin="5">

<?
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID=$FLOW_ID";
$cursor1= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
{
   $FLOW_NAME=$ROW["FLOW_NAME"];
   $FORM_ID=$ROW["FORM_ID"];
}

$query = "SELECT * from FLOW_RUN WHERE RUN_ID=$RUN_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
   $RUN_NAME=$ROW["RUN_NAME"];
}
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/green_arrow.gif" align="absmiddle"><span class="big3"> 委托代办人/转交主办权</span><br>
    </td>
  </tr>
</table>

<br>

<form action="others_submit.php" method="post" name="form1">
<table border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center" width="90%">
    <tr class="TableHeader">
      <td nowrap align="center" class="Big" colspan="2"><b><?=$FLOW_NAME?></b></td>
    </tr>

<?
 for($PRCS_ID_I=1;$PRCS_ID_I<=$PRCS_ID;$PRCS_ID_I++)
 {
    $query = "SELECT * from FLOW_RUN_PRCS where RUN_ID=$RUN_ID and PRCS_ID=$PRCS_ID_I";
    $cursor= exequery($connection,$query);
    $USER_NAME_STR="";
    $USER_COUNT=0;
    while($ROW=mysql_fetch_array($cursor))
    {
       $USER_COUNT++;
       $USER_ID=$ROW["USER_ID"];
       $FLOW_PRCS=$ROW["FLOW_PRCS"];

       $query1 = "SELECT * from USER where USER_ID='$USER_ID'";
       $cursor1= exequery($connection,$query1);
       if($ROW=mysql_fetch_array($cursor1))
          $USER_NAME_STR.=$ROW["USER_NAME"].",";
    }

    $query1 = "SELECT * from FLOW_PROCESS WHERE FLOW_ID=$FLOW_ID and PRCS_ID=$FLOW_PRCS";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $PRCS_NAME=$ROW["PRCS_NAME"];
       $PRCS_USER=$ROW["PRCS_USER"];
       $PRCS_DEPT=$ROW["PRCS_DEPT"];
       $PRCS_PRIV=$ROW["PRCS_PRIV"];
    }

    $USER_NAME_STR=SUBSTR($USER_NAME_STR,0,STRLEN($USER_NAME_STR)-1);

    if($PRCS_ID_I!=$PRCS_ID)
    {
?>

       <tr class="TableData">
         <td nowrap width="10%"><?=$PRCS_ID_I?>:<?=$PRCS_NAME?></td>
         <td><?=$USER_NAME_STR?></td>
       </tr>
<?
    }
    else
    {
?>
       <tr class="TableData">
         <td nowrap width="10%"><?=$PRCS_ID_I?>:<?=$PRCS_NAME?> (当前步骤)</td>
         <td nowrap>
<?
       if($USER_COUNT>1 && !$OP_FLAG)
          echo "本步骤为会签步骤,不能指定代办人;且您不是主办人,不能转交主办权";
       else
       {

         if($USER_COUNT==1)
         {
            if($PRCS_DEPT!="")
            {
              $PRCS_DEPT=SUBSTR($PRCS_DEPT,0,STRLEN($PRCS_DEPT)-1);
              $query1 = "SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID in($PRCS_DEPT) order by PRIV_NO,USER_NO,USER_NAME";
              $cursor1= exequery($connection,$query1);
              while($ROW=mysql_fetch_array($cursor1))
              {
                 $USER_ID=$ROW["USER_ID"];
                 if(!find_id($PRCS_USER,$USER_ID))
                    $PRCS_USER.=$USER_ID.",";
              }
            }

            if($PRCS_PRIV!="")
            {
               $PRCS_PRIV=SUBSTR($PRCS_PRIV,0,STRLEN($PRCS_PRIV)-1);
               $query1 = "SELECT * from USER,USER_PRIV WHERE USER.USER_PRIV=USER_PRIV.USER_PRIV and USER.USER_PRIV in($PRCS_PRIV) order by PRIV_NO,USER_NO,USER_NAME";
               $cursor1= exequery($connection,$query1);
               while($ROW=mysql_fetch_array($cursor1))
               {
                  $USER_ID=$ROW["USER_ID"];
                  if(!find_id($PRCS_USER,$USER_ID))
                     $PRCS_USER.=$USER_ID.",";
               }
            }
         }
         else
         {
             $PRCS_USER="";
             $query = "SELECT * from FLOW_RUN_PRCS where RUN_ID=$RUN_ID and PRCS_ID=$PRCS_ID_I";
             $cursor= exequery($connection,$query);
             while($ROW=mysql_fetch_array($cursor))
             {
                $USER_ID=$ROW["USER_ID"];
                if(!find_id($PRCS_USER,$USER_ID))
                   $PRCS_USER.=$USER_ID.",";
             }
         }

         $MY_ARRAY=explode(",",$PRCS_USER);
         $ARRAY_COUNT=sizeof($MY_ARRAY);
         if($MY_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
         $OTHER_COUNT=0;
         for($I=0;$I<$ARRAY_COUNT;$I++)
         {
            if($MY_ARRAY[$I]!=$LOGIN_USER_ID)
            {
              $OTHER_COUNT++;
              $query1 = "SELECT * from USER where USER_ID='$MY_ARRAY[$I]'";
              $cursor1= exequery($connection,$query1);
              if($ROW=mysql_fetch_array($cursor1))
                 $USER_NAME=$ROW["USER_NAME"];

              if($I==0)
              {
                 if($USER_COUNT==1)
                    echo "<b>委托代办人:</b><br>";
                 else
                    echo "<b>转交主办权:</b><br>";
              }
?>
              <input type="radio" name="USER_ID" value="<?=$MY_ARRAY[$I]?>" <?if($OTHER_COUNT==1)echo "checked";?>><?=$USER_NAME?><br>
<?
            }
         }

         if($MY_ARRAY[0]==$LOGIN_USER_ID && $ARRAY_COUNT==1)
            $I=0;

         if($I==0)
            echo "本步骤无可供选择的代办人";
       }
?>
         </td>
       </tr>
<?
    }
 }

 if($USER_COUNT==1 || $OP_FLAG)
 {
?>
    <tr class="TableHeader">
      <td colspan="2"><b>短信提醒</b></td>
    </tr>
    <tr class="TableData">
      <td colspan="2">
        <input type="checkbox" name="SMS_REMIND" id="SMS_REMIND" <?if($SMS_REMIND=="1" or $SMS_REMIND=="") echo "checked";?>><label for="SMS_REMIND">使用内部短信提醒经办人</label>
<?
  $query = "select * from SMS2_PRIV";
  $cursor=exequery($connection,$query);
  if($ROW=mysql_fetch_array($cursor))
     $TYPE_PRIV=$ROW["TYPE_PRIV"];

  if(find_id($TYPE_PRIV,7)) //检查该模块是否允许手机提醒
  {
?>
        <input type="checkbox" name="SMS2_REMIND" id="SMS2_REMIND"><label for="SMS2_REMIND">使用手机短信提醒经办人</label>
<?
  }

  if($USER_COUNT==1)
     $SMS_CONTENT="工作流委托提醒:".$RUN_NAME;
  else
     $SMS_CONTENT="工作流主办权转交提醒:".$RUN_NAME;
?>
<br>
短信内容:<input type="text" name="SMS_CONTENT" value="<?=$SMS_CONTENT?>" size="62" maxlength="100" class="SmallInput">
     </td>
    </tr>
<?
}
?>
    <tr class="TableControl">
      <td nowrap align="center" colspan="2">
      	<input type="hidden"  name="RUN_ID" value="<?=$RUN_ID?>">
        <input type="hidden"  name="USER_COUNT" value="<?=$USER_COUNT?>">
        <input type="hidden" name="MENU_FLAG" value="<?=$MENU_FLAG?>">
        <input type="hidden" name="FLOW_ID" value="<?=$FLOW_ID?>">
        <input type="hidden"  name="PRCS_ID" value="<?=$PRCS_ID?>">
<?
        if($I!=0)
        {
?>
        <input type="submit"  value="确定" class="BigButton" name="submit">&nbsp;&nbsp;
<?
        }
?>
        <input type="button"  value="返回" class="BigButton" name="back" onClick="history.back();">
      </td>
    </tr>
</table>
</form>

</body>
</html>

⌨️ 快捷键说明

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