<?php include "./inc/odbc.php"; ?>
|
<?php require '/inc/function.php';?>
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
<head>
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
<meta name="viewport" content="width=device-width, height=device-height, initial-scale=1, maximum-scale=1, user-scalable=no">
|
<title>记录中..</title>
|
</head>
|
<?php
|
|
$MySave=empty($_REQUEST['MySave'])!=false ? "" : $_REQUEST['MySave'];
|
|
switch ($MySave)
|
{
|
case 1: //绑定新手机
|
include "./inc/OAuth2.php";
|
if(!isset($openid)){header("Location: /MyPhone.php");exit;}
|
$UserName=empty($_REQUEST['UserName'])!=false ? "" : strSql($_REQUEST['UserName']);
|
$UserPhone=empty($_REQUEST['UserPhone'])!=false ? "" : strSql($_REQUEST['UserPhone']);
|
if ($UserName=="" or $UserPhone=="") {
|
header("Location: /MyPhone.php");exit;
|
}else{
|
$sql = "select wxID from weixinOpenIDToPhone where weixinOpenID='$openid' and UserPhone='$UserPhone'" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)==0) {
|
$sql="insert into weixinOpenIDToPhone (weixinOpenID,UserPhone,UserName) values ('".$openid."','".$UserPhone."','".$UserName."')";
|
$UPsql = sqlsrv_query($conn,$sql);
|
} else {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$wxID = $rs['wxID'];
|
$sql="update weixinOpenIDToPhone set UserName='".$UserName."',LoginTime=getdate(),weixinState=1 where wxID=".$wxID;
|
$UPsql = sqlsrv_query($conn,$sql);
|
}
|
}
|
}
|
}
|
header("Location: /MyCenter.php?SMT=3");exit;
|
break;
|
case 2: //保存发票信息
|
$ServiceOrdID = empty($_REQUEST['ServiceOrdID'])!=false ? "" : strSql($_REQUEST['ServiceOrdID']);
|
$DispatchOrdID = empty($_REQUEST['DispatchOrdID'])!=false ? "" : strSql($_REQUEST['DispatchOrdID']);
|
$InvoiceID = empty($_REQUEST['InvoiceID'])!=false ? 0 : strSql($_REQUEST['InvoiceID']);
|
$InvoiceType = empty($_REQUEST['InvoiceType'])!=false ? "" : strSql($_REQUEST['InvoiceType']);
|
$InvoiceName = empty($_REQUEST['InvoiceName'])!=false ? "" : strSql($_REQUEST['InvoiceName']); //发票抬头
|
$InvoiceMakeout = empty($_REQUEST['InvoiceMakeout'])!=false ? "" : strSql($_REQUEST['InvoiceMakeout']); //发票备注
|
$InvoiceCompanyPhone= empty($_REQUEST['InvoiceCompanyPhone'])!=false ? "" : strSql($_REQUEST['InvoiceCompanyPhone']);//企业电话
|
$InvoiceCompanyID = empty($_REQUEST['InvoiceCompanyID'])!=false ? "" : strSql($_REQUEST['InvoiceCompanyID']); //纳税识别号
|
$InvoiceCompanyAdd = empty($_REQUEST['InvoiceCompanyAdd'])!=false ? "" : strSql($_REQUEST['InvoiceCompanyAdd']); //企业注册地址
|
$InvoiceCompanyBank = empty($_REQUEST['InvoiceCompanyBank'])!=false ? "" : strSql($_REQUEST['InvoiceCompanyBank']);//企业开户银行
|
$InvoiceCompanyBankNo= empty($_REQUEST['InvoiceCompanyBankNo'])!=false ? "" : strSql($_REQUEST['InvoiceCompanyBankNo']);//企业银行账号
|
$InvoiceZipCode = empty($_REQUEST['InvoiceZipCode'])!=false ? "" : strSql($_REQUEST['InvoiceZipCode']); //邮编
|
$Invoice_strAdd = empty($_REQUEST['Invoice_strAdd'])!=false ? "" : strSql($_REQUEST['Invoice_strAdd']); //邮寄地址
|
$Invoice_strName = empty($_REQUEST['Invoice_strName'])!=false ? "" : strSql($_REQUEST['Invoice_strName']); //联系人
|
$Invoice_strPhone = empty($_REQUEST['Invoice_strPhone'])!=false ? "" : strSql($_REQUEST['Invoice_strPhone']); //联系电话
|
if ($ServiceOrdID=="") {
|
header("Location: /MyCenter.php");
|
exit;
|
}
|
|
if ($InvoiceID==0) {
|
$sql="insert into InvoiceData (ServiceOrderIDPK, InvoiceType, InvoiceName, InvoiceMakeout, InvoiceCompanyPhone, InvoiceCompanyID, InvoiceCompanyAdd, InvoiceCompanyBank, InvoiceCompanyBankNo, InvoiceZipCode, Invoice_strAdd, Invoice_strName, Invoice_strPhone) values (".$ServiceOrdID.",".$InvoiceType.",'".$InvoiceName."','".$InvoiceMakeout."','".$InvoiceCompanyPhone."','".$InvoiceCompanyID."','".$InvoiceCompanyAdd."','".$InvoiceCompanyBank."','".$InvoiceCompanyBankNo."','".$InvoiceZipCode."','".$Invoice_strAdd."','".$Invoice_strName."','".$Invoice_strPhone."')";
|
$UPsql = sqlsrv_query($conn,$sql);
|
$title="新的发票申请(H5)";
|
$description=$InvoiceName.",有一个新的发票申请,请即时处理";
|
}else{
|
$sql="update InvoiceData set InvoiceType=".$InvoiceType.",InvoiceName='".$InvoiceName."',InvoiceMakeout='".$InvoiceMakeout."',InvoiceCompanyPhone='".$InvoiceCompanyPhone."',InvoiceCompanyID='".$InvoiceCompanyID."',InvoiceCompanyAdd='".$InvoiceCompanyAdd."',InvoiceCompanyBank='".$InvoiceCompanyBank."',InvoiceCompanyBankNo='".$InvoiceCompanyBankNo."',InvoiceZipCode='".$InvoiceZipCode."',Invoice_strAdd='".$Invoice_strAdd."',Invoice_strName='".$Invoice_strName."',Invoice_strPhone='".$Invoice_strPhone."' where InvoiceID=".$InvoiceID;
|
$UPsql = sqlsrv_query($conn,$sql);
|
$title="发票申请修改(H5)";
|
$description=$InvoiceName.",有一个发票申请修改了,请即时处理";
|
}
|
|
//信息推送相关人员
|
$sql="SELECT OA_weixinID=STUFF((SELECT '|' + OA_weixinUserID from OA_User where OA_Power like '%030205%' and OA_execLevel>=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;
|
}
|
?>
|
