我做了一些尝试，往email和email_body表各插一条数据，email表的BODY_ID的值为email_body表对应的BODY_ID，然后用send_sms这个函数推送消息。
但还是不行，两张表的数据是插进去了，但是并没有显示我收到邮件。附代码：
<?php
include_once("../../inc/utility_all.php");
include_once("../../inc/auth.inc.php");
include_once("../../inc/conn.php");
include_once("../../inc/utility_sms1.php");
include_once("../../inc/check_type.php");
include_once("../../inc/header.inc.php");
mysql_connect("localhost:3336","root","myoa888");
mysql_select_db("TD_OA");
$SEND_TIME = date();
$LOGIN_USER_ID = 'admin';
$query = "insert into TD_OA.email_body ( `FROM_ID`, `TO_ID2`, `COPY_TO_ID`, `SECRET_TO_ID`, `SUBJECT`, `CONTENT`, `SEND_TIME`, `ATTACHMENT_ID`,
`ATTACHMENT_NAME`, `SEND_FLAG`, `SMS_REMIND`, `IMPORTANT`, `SIZE`, `FROM_WEBMAIL_ID`, `FROM_WEBMAIL`, `TO_WEBMAIL`,
`COMPRESS_CONTENT`, `WEBMAIL_CONTENT`, `WEBMAIL_FLAG`, `RECV_FROM_NAME`, `RECV_FROM`, `RECV_TO_ID`, `RECV_TO`,
`IS_WEBMAIL`, `IS_WF`, `KEYWORD`, `SECRET_LEVEL`, `AUDIT_MAN`, `AUDIT_REMARK`, `COPY_TO_WEBMAIL`, `SECRET_TO_WEBMAIL`)
values('admin','admin','','','这是主题','这是内容','1582423553','',
'',1,'',0,0,'','','',
'','',0,'','','','',
0,0,'',0,'','','','')
";
mysql_query($query);
$BODY_ID=mysql_insert_id();
$query2="insert into TD_OA.email(`TO_ID`, `READ_FLAG`, `DELETE_FLAG`, `BOX_ID`, `BODY_ID`, `RECEIPT`, `IS_F`, `IS_R`, `SIGN`)
values ('$LOGIN_USER_ID','1','0','0','$BODY_ID','0','','','')";
mysql_query($query2);
$ROW_ID=mysql_insert_id();
$REMIND_URL="email/?MAIN_URL=".urlencode("inbox/read_email/?BOX_ID=0&EMAIL_ID=".$ROW_ID);
$SMS_CONTENT="请查收我的邮件！\n主题：".csubstr('这是主题',0,100);
send_sms("",$LOGIN_USER_ID,$LOGIN_USER_ID,2,$SMS_CONTENT,$REMIND_URL);
?>
|
发表于 2015-8-28 11:12:26
发表于 2015-11-9 16:12:27