email_result.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 117 行

PHP
117 行
字号 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_sms1.php");
include_once("inc/utility_sms2.php");
if($fld_str=="")
{
 $query = "SELECT ITEM_ID from SAL_ITEM";
 $cursor= exequery($connection,$query);
 $FLOW_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
    {
    	$STYLE=$STYLE.$ROW["ITEM_ID"].",";
    }
 }
 else
 {
  $STYLE=$fld_str;
  }
$query = "SELECT CONTENT from SAL_FLOW where FLOW_ID='$FLOW_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))$CONTENT=$ROW["CONTENT"];
?>

<html>
<head>
<title>终止工资上报流程</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

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

<?
$SEND_TIME=date("Y-m-d H:i:s",time());
$query="select CONTENT from SAL_FLOW where FLOW_ID=$FLOW_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
   $SUBJECT=$ROW["CONTENT"];
}
if($COPY_TO_ID!="")
   {
   	$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
    $WHERE_STR.=" where USER_ID in ($COPY_TO_ID)";
   }
$query1 = "SELECT USER_ID,USER_NAME from USER ".$WHERE_STR;
$cursor1= exequery($connection,$query1);
while($ROW=mysql_fetch_array($cursor1))
{
  $USERID=$ROW["USER_ID"];
  $USERNAME=$ROW["USER_NAME"];
  $query="select * from SAL_DATA where FLOW_ID=$FLOW_ID and USER_ID='$USERID'";
  $cursor= exequery($connection,$query);
  if($ROW=mysql_fetch_array($cursor))
  {
  	$STYLE_ARRAY=explode(",",$STYLE);
    $ARRAY_COUNT=sizeof($STYLE_ARRAY);
    $COUNT=0;
    if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
    for($I=0;$I<$ARRAY_COUNT;$I++)
    {
      $STR="S".$STYLE_ARRAY[$I];
      $$STR=format_money($ROW["$STR"]);
     }

    $OPERATION=2;
  }
  else
  {
    continue;
  }

 
 $STYLE_ARRAY=explode(",",$STYLE);
 $ARRAY_COUNT=sizeof($STYLE_ARRAY);
 $COUNT=0;
 if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
 $ITEM_COUNT=0;
 for($I=0;$I<$ARRAY_COUNT;$I++)
 {
  $query="select ITEM_ID,ITEM_NAME from SAL_ITEM where ITEM_ID='$STYLE_ARRAY[$I]'";
  $cursor= exequery($connection,$query);
  if($ROW=mysql_fetch_array($cursor))
  {
    $ITEM_COUNT++;
    $ITEM_ID=$ROW["ITEM_ID"];
    $ITEM_NAME=$ROW["ITEM_NAME"];
    $S_ID="S".$ITEM_ID;
    $S_NAME=$S_ID."_NAME";
    if($ITEM_COUNT==1)
       $CONTENT="<br><div align=center><table border=0 cellspacing=1 width=250 class=small bgcolor=#000000 cellpadding=3>";
    $CONTENT.= "<tr class=TableData><td nowrap align=center width=110>".$ITEM_NAME."</td><td nowrap align=center>".$$S_ID."</td></tr>";
  }
 }
 if($ITEM_COUNT>0)
  	$CONTENT.="<thead class=TableHeader><td nowrap align=center>工资项目</td><td nowrap align=center>金额</td></thead></table></div>";

 $query="INSERT
         INTO EMAIL_BODY (FROM_ID,TO_ID2,COPY_TO_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,SEND_FLAG,IMPORTANT)
         SELECT '$LOGIN_USER_ID' as FROM_ID,'$USERID,' as TO_ID2,'' as COPY_TO_ID ,'$SUBJECT' as SUBJECT,'$CONTENT' as CONTENT,'$SEND_TIME' as SEND_TIME,'' as ATTACHMENT_ID,'' as ATTACHMENT_NAME,'1' as SEND_FLAG,'0' as IMPORTANT
         from USER where USER_ID='$USERID' and  NOT_LOGIN='0'";

 exequery($connection,$query);
 $BODY_ID=mysql_insert_id();
 
 $query="INSERT INTO EMAIL(TO_ID,READ_FLAG,DELETE_FLAG,BOX_ID,BODY_ID) values('$USERID','0','0','0','$BODY_ID')";
 exequery($connection,$query);
 $ROW_ID=mysql_insert_id();
 
 $SMS_CONTENT="请查收邮件！\n主题：".csubstr($SUBJECT,0,100);
 send_sms("",$LOGIN_USER_ID,$USERID,2,$SMS_CONTENT,$REMIND_URL);  
}
header("location: index.php");
?>
</body>
</html>

email_result.php - 源码说明

本页面展示了「通达OA官方提供的30源代码,感觉很实在」中的 email_result.php 源码文件，采用 PHP 编程语言编写，共 117 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

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

⌨️ 快捷键说明

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