通达OA2019对接联通一信通短信平台

<?
include_once 'auth.php';
include_once 'inc/utility_all.php';
include_once 'inc/utility_org.php';
include_once 'inc/utility_msg.php';

/*****/
$CUR_YEAR = date('Y');
$CUR_MONTH = date('m');
$CUR_WEEK = date('w');
$CUR_DAY = date('j');
$CUR_DATE = date('Y-m-d H:i:s');
$CUR_TIME = date('H:i:s');
$query = "select * from OFFICE_TASK where USE_FLAG='1' and TASK_CODE='sms_hadian' limit 0,1";
$cursor = exequery(TD::conn(), $query);

if (!$cursor) {
	echo '-ERR ' . get_err_msg($query, $TASK_ID);
	exit();
}

//18002601839	
	
		$zuotian=date("Y-m-d H:i:s",strtotime("-1 day"));       
//echo $zuotian;
$query="delete from  sms2  where send_time<='$zuotian'";
exequery(TD::conn(),$query);
	
	

	$query = "select distinct(content) from sms2 where send_flag = 0 and SEND_TIME<='$CUR_DATE' LIMIT 0,1000";
	$cursor= exequery(TD::conn(),$query); 
	while($ROW=mysql_fetch_array($cursor))
	{
		
		$content= $ROW["content"];
		//echo $content."<br>";
		$sms_id_str="";//id字符串
		$phone_str="";//手机号字符串
		$query1="select sms_id,phone from sms2 where send_flag = 0 and content='".$content."' limit 0,200";//每次最多提交的短信条数50*n
		$cursor1=mysql_query($query1);
		while($row1=mysql_fetch_array($cursor1)){
			$sms_id_str.=$row1["sms_id"].",";
			$phone_str.=$row1["phone"].",";
			}
		$sms_id_str=substr($sms_id_str,0,-1);
		$phone_str=substr($phone_str,0,-1);	
	/**************************************/			
	

		
	//$SpCode="21217";  //企业编码
	//$LoginName="b_bsxy";
	//$Password="baie@2018";
	//$SpCode="22444";  //企业编码
	//$LoginName="lzx_xxjs";
	//$Password="aiohYg0SAeQLC";
	$SpCode="257285";  //企业编码
	$LoginName="zx_lx";
	$Password="zM0Hg6suxzTQGW"; //JwZtHsPP123  //zM0Hg6suxzTQGW
	//https://api.ums86.com:9600/sms/Api/Send.do?SpCode=257285&LoginName=zx_lzx&Password=zM0Hg6suxzTQGW&MessageContent=你有一项编号为123456789的事务需要处理。&UserNumber=18248035486&SerialNumber=&ScheduleTime=&f=1 

	//$MessageContent="尊敬的张三,您本次验证码为123456,请在10分钟内使用";//$content;//
	$MessageContent=$content;//
	$UserNumber=$phone_str;

	   $url = "https://api.ums86.com:9600/sms/Api/Send.do";
	 //  $url="http://gd.ums86.com:8899/sms/Api/Send.do";
        $post_data['SpCode']       = $SpCode;
        $post_data['LoginName']      = $LoginName;
        $post_data['Password'] =$Password;
        $post_data['MessageContent']    =$MessageContent;
        $post_data['UserNumber']=$UserNumber;
		 $post_data['SerialNumber']='';
		  $post_data['ScheduleTime']='';
		   $post_data['ExtendAccessNum']='';
		    $post_data['f']='1';
			$o1="";
	  foreach ( $post_data as $k => $v ) 
	  { 
		  $o1.= "$k=" . urlencode( $v ). "&" ;
	  }
	  $post_data1 = substr($o1,0,-1);
	  
	  $res1 =request_post($url, $post_data1); 
	//  echo $res1;     
	$res1_arr=explode("&",$res1);
	  if($res1_arr[0]=="result=0"){
		//  echo "ssssuccess";
		  $query2 = "update  sms2 set send_flag = 1 where find_in_set(sms_id,'".$sms_id_str."')";
			  //echo "<br>".$query2."<br><br>";
			  exequery(TD::conn(),$query2);  
	  } else {
		  //提交失败
		  //逻辑代码
	  }
	  /**************************************/
	}





function request_post($url = '', $param = '') {
        if (empty($url) || empty($param)) {
            return false;
        }
        
        $postUrl = $url;
        $curlPost = $param;
        $ch = curl_init();//初始化curl
        curl_setopt($ch, CURLOPT_URL,$postUrl);//抓取指定网页
        curl_setopt($ch, CURLOPT_HEADER, 0);//设置header
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);//要求结果为字符串且输出到屏幕上
        curl_setopt($ch, CURLOPT_POST, 1);//post提交方式
		curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE); // https请求 不验证证书和hosts
		curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $curlPost);
        $data = curl_exec($ch);//运行curl
        curl_close($ch);
        
        return $data;
    }
  
	    
    

update_office_task($TASK_ID, '1', date('Y-m-d H:i:s', time()));
echo '+OK';


?>

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

hai7425

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值