=1 FOR XML PATH('')), 1, 1, '')";
$data = sqlsrv_query($conn,$sql);
if($data == true){
if (sqlsrv_rows_affected($data)!=0) {
while($rs = sqlsrv_fetch_array($data) ) {
$OA_weixinID = $rs['OA_weixinID'];
//$OA_weixinID = "liaojunliang|ylkx_vicgame";
$arr = array('method'=>'OA_MessageSend','APPID'=>'GDS-000001','touser'=>$OA_weixinID,'title'=>$title,'description'=>$description,'url'=>'https://sys.966120.com.cn/m_Invoice.gds?InvoiceID*'.$InvoiceID.'|ServiceOrdID*'.$ServiceOrdID.'|order_type*11','UnixTime'=>time());
ksort($arr);
$stringA='';
$content='';
foreach($arr as $k=>$v){
$stringA=$stringA.$k.urlencode_ch($v);
$content=$content.$k."=".$v."&";
}
$stringSignTemp=$stringA."JR6o8RQItoa2bzlneOCQ";
$stringSignTemp=str_replace(" ", "%20", $stringSignTemp);
echo $stringSignTemp;
$sign=MD5($stringSignTemp);
$content .= 'Sign='.$sign;
$OA_url='https://api.966120.com.cn/v1/?'.$content;
$OA_url=str_replace(" ", "%20", $OA_url);
//var_dump($OA_url);exit;
$addinfo=file_get_contents($OA_url);
}
}
}
//var_dump($ICD_ID);exit;
header("Location: /MyInvoice.php?ServiceOrdID=".$ServiceOrdID."&DispatchOrdID=".$DispatchOrdID."&SMT=3&sign=".MD5($ServiceOrdID.$DispatchOrdID.$GPSKey));exit;
break;
case 12: //诊断情况ICD目录删除
$ICD_ID=empty($_REQUEST['ICDID'])!=false ? "" : $_REQUEST['ICDID'];
if ($ICD_ID=="") {
header("Location: /ICD10.php?SystemMessageType=4&SMT=1");
exit;
}
foreach ($ICD_ID as $key => $ICD_ID) {
if ($ICD_ID!="") {
$sql="update ICD10 set ICDState=0 where id=".$ICD_ID;
$data = sqlsrv_query($conn,$sql);
}
}
//var_dump($ICD_ID);exit;
header("Location: /ICD10.php?SystemMessageType=3&SMT=4");exit;
break;
}
?>