<?php require '/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
|
|
$admin_save=empty($_REQUEST['admin_save'])!=false ? "" : $_REQUEST['admin_save'];
|
if(isset($_SESSION['SMT_URL'])){unset($_SESSION['SMT_URL']);}
|
|
switch ($admin_save)
|
{
|
case 10: //诊断情况ICD目录新增
|
$ICD_code=empty($_REQUEST['icd_code'])!=false ? "" : $_REQUEST['icd_code'];
|
$ICD_name=empty($_REQUEST['icd_name'])!=false ? "" : $_REQUEST['icd_name'];
|
$ICD_zjm=empty($_REQUEST['zjm'])!=false ? "" : $_REQUEST['zjm'];
|
if ($ICD_name!="") {
|
$sql = "select id,ICDState from ICD10 where ICD_name='$ICD_name'" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)==0) {
|
$sql="insert into ICD10 (icd_code,icd_name,zjm) values ('".$ICD_code."','".$ICD_name."','".$ICD_zjm."')";
|
$UPsql = sqlsrv_query($conn,$sql);
|
} else {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$id = $rs['id'];
|
$ICDState= $rs['ICDState'];
|
if ($ICDState==0){
|
$sql="update ICD10 set icd_code='".$ICD_code."',icd_name='".$ICD_name."',zjm='".$ICD_zjm."',ICDState=1 where id=".$id;
|
$UPsql = sqlsrv_query($conn,$sql);
|
}else{
|
header("Location: /ICD10.php?SystemMessageType=4&SMT=5"); exit;
|
}
|
}
|
}
|
}
|
}
|
header("Location: /ICD10.php?SystemMessageType=3&SMT=3");exit;
|
break;
|
case 11: //诊断情况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) {
|
$ICD_code=empty($_REQUEST['ICD_code_'.$ICD_ID])!=false ? "" : $_REQUEST['ICD_code_'.$ICD_ID];
|
$ICD_name=empty($_REQUEST['ICD_name_'.$ICD_ID])!=false ? "" : $_REQUEST['ICD_name_'.$ICD_ID];
|
$ICD_zjm=empty($_REQUEST['ICD_zjm_'.$ICD_ID])!=false ? "" : $_REQUEST['ICD_zjm_'.$ICD_ID];
|
if ($ICD_name!="") {
|
$sql = "select id,ICDState from ICD10 where ICD_name='$ICD_name' and ICDState=1 and id<>".$ICD_ID ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)==0) {
|
$sql="update ICD10 set icd_code='".$ICD_code."',icd_name='".$ICD_name."',zjm='".$ICD_zjm."' where id=".$ICD_ID;
|
$UPsql = sqlsrv_query($conn,$sql);
|
} else {
|
header("Location: /ICD10.php?SystemMessageType=4&SMT=5"); exit;
|
}
|
}
|
}
|
}
|
//var_dump($ICD_ID);exit;
|
header("Location: /ICD10.php?SystemMessageType=3&SMT=2");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;
|
|
case 13: //保存发票信息
|
$searchTXT = empty($_REQUEST['searchTXT'])!=false ? "" : $_REQUEST['searchTXT'];
|
$page = empty($_REQUEST['page'])!=false ? "" : $_REQUEST['page'];
|
$ServiceOrdID = empty($_REQUEST['ServiceOrdID'])!=false ? "" : $_REQUEST['ServiceOrdID'];
|
$InvoiceID = empty($_REQUEST['InvoiceID'])!=false ? 0 : $_REQUEST['InvoiceID'];
|
$InvoiceType = empty($_REQUEST['InvoiceType'])!=false ? "" : $_REQUEST['InvoiceType'];
|
$InvoiceName = empty($_REQUEST['InvoiceName'])!=false ? "" : $_REQUEST['InvoiceName']; //发票抬头
|
$InvoiceMakeout = empty($_REQUEST['InvoiceMakeout'])!=false ? "" : $_REQUEST['InvoiceMakeout']; //发票备注
|
$InvoiceCompanyPhone= empty($_REQUEST['InvoiceCompanyPhone'])!=false ? "" : $_REQUEST['InvoiceCompanyPhone'];//企业电话
|
$InvoiceCompanyID = empty($_REQUEST['InvoiceCompanyID'])!=false ? "" : $_REQUEST['InvoiceCompanyID']; //纳税识别号
|
$InvoiceCompanyAdd = empty($_REQUEST['InvoiceCompanyAdd'])!=false ? "" : $_REQUEST['InvoiceCompanyAdd']; //企业注册地址
|
$InvoiceCompanyBank = empty($_REQUEST['InvoiceCompanyBank'])!=false ? "" : $_REQUEST['InvoiceCompanyBank'];//企业开户银行
|
$InvoiceCompanyBankNo= empty($_REQUEST['InvoiceCompanyBankNo'])!=false ? "" : $_REQUEST['InvoiceCompanyBankNo'];//企业银行账号
|
$InvoiceZipCode = empty($_REQUEST['InvoiceZipCode'])!=false ? "" : $_REQUEST['InvoiceZipCode']; //邮编
|
$Invoice_strAdd = empty($_REQUEST['Invoice_strAdd'])!=false ? "" : $_REQUEST['Invoice_strAdd']; //邮寄地址
|
$Invoice_strName = empty($_REQUEST['Invoice_strName'])!=false ? "" : $_REQUEST['Invoice_strName']; //联系人
|
$Invoice_strPhone = empty($_REQUEST['Invoice_strPhone'])!=false ? "" : $_REQUEST['Invoice_strPhone']; //联系电话
|
$Invoice_strEmail = empty($_REQUEST['Invoice_strEmail'])!=false ? "" : $_REQUEST['Invoice_strEmail']; //联系电话
|
|
$AuditStatus = empty($_REQUEST['AuditStatus'])!=false ? "0" : $_REQUEST['AuditStatus']; //处理状态
|
$AuditMakeout = empty($_REQUEST['AuditMakeout'])!=false ? "" : $_REQUEST['AuditMakeout']; //处理备注
|
$InvoiceNo = empty($_REQUEST['InvoiceNo'])!=false ? "" : $_REQUEST['InvoiceNo']; //发票号码
|
$InvoiceMoney = empty($_REQUEST['InvoiceMoney'])!=false ? 0 : $_REQUEST['InvoiceMoney']; //发票金额
|
|
$InvoiceURL = empty($_REQUEST['InvoiceURL'])!=false ? "" : $_REQUEST['InvoiceURL']; //发票链接
|
$InvoiceOddNo = empty($_REQUEST['InvoiceOddNo'])!=false ? "" : $_REQUEST['InvoiceOddNo']; //发票物流单号
|
if ($ServiceOrdID=="") {
|
header("Location: /Invoice_List.php?SMT=2&SystemMessageType=4&searchTXT=$searchTXT&page=$page");
|
exit;
|
}
|
if ($InvoiceID==0) {
|
$sql="insert into InvoiceData (ServiceOrderIDPK,InvoiceType,InvoiceName,InvoiceMakeout,InvoiceCompanyPhone,InvoiceCompanyID,InvoiceCompanyAdd,InvoiceCompanyBank,InvoiceCompanyBankNo,InvoiceZipCode,Invoice_strAdd,Invoice_strEmail,Invoice_strName,Invoice_strPhone,AuditStatus,AuditMakeout,InvoiceNo,InvoiceURL,InvoiceOddNo,InvoiceMoney,AuditOAID,AuditTime) values (".$ServiceOrdID.",".$InvoiceType.",'".$InvoiceName."','".$InvoiceMakeout."','".$InvoiceCompanyPhone."','".$InvoiceCompanyID."','".$InvoiceCompanyAdd."','".$InvoiceCompanyBank."','".$InvoiceCompanyBankNo."','".$InvoiceZipCode."','".$Invoice_strAdd."','".$Invoice_strEmail."','".$Invoice_strName."','".$Invoice_strPhone."',".$AuditStatus.",'".$AuditMakeout."','".$InvoiceNo."','".$InvoiceURL."','".$InvoiceOddNo."',".$InvoiceMoney.",".$adminID.",getdate())";
|
$UPsql = sqlsrv_query($conn,$sql);
|
}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_strEmail='".$Invoice_strEmail."',Invoice_strName='".$Invoice_strName."',Invoice_strPhone='".$Invoice_strPhone."',AuditStatus=".$AuditStatus.",AuditMakeout='".$AuditMakeout."',InvoiceNo='".$InvoiceNo."',InvoiceURL='".$InvoiceURL."',InvoiceOddNo='".$InvoiceOddNo."',InvoiceMoney=".$InvoiceMoney.",AuditOAID=".$adminID.",AuditTime=getdate() where InvoiceID=".$InvoiceID;
|
$UPsql = sqlsrv_query($conn,$sql);
|
}
|
//var_dump($ICD_ID);exit;
|
header("Location: /weixin/message_send_OAInvoice.gds?InvoiceID=$InvoiceID");exit;
|
break;
|
|
case 14: //医院科室目录新增
|
$Hospital_vID=empty($_REQUEST['Hospital_vID'])!=false ? 1 : $_REQUEST['Hospital_vID'];
|
$Hospital_vtext=empty($_REQUEST['Hospital_vtext'])!=false ? "" : $_REQUEST['Hospital_vtext'];
|
$Hospital_vOrder=empty($_REQUEST['Hospital_vOrder'])!=false ? 100 : $_REQUEST['Hospital_vOrder'];
|
if ($Hospital_vtext!="") {
|
$sql = "select id,vType from dictionary where vtitle='HospitalDepartment' and vtext='$Hospital_vtext'" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)==0) {
|
$sql="insert into dictionary (vtitle,vID,vtext,vOrder,vType) values ('HospitalDepartment',".$Hospital_vID.",'".$Hospital_vtext."',".$Hospital_vOrder.",1)";
|
$UPsql = sqlsrv_query($conn,$sql);
|
} else {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$ID = $rs['id'];
|
$vType = $rs['vType'];
|
if ($vType==0){
|
$sql="update dictionary set vtext='".$Hospital_vtext."',vOrder=".$Hospital_vOrder.",vType=1 where id=".$ID;
|
$UPsql = sqlsrv_query($conn,$sql);
|
}else{
|
header("Location: /HospitalDepartment.php?SystemMessageType=4&SMT=5"); exit;
|
}
|
}
|
}
|
}
|
}
|
header("Location: /HospitalDepartment.php?SystemMessageType=3&SMT=3");exit;
|
break;
|
|
case 15: //医院科室目录修改
|
$ID=empty($_REQUEST['ID'])!=false ? "" : $_REQUEST['ID'];
|
if ($ID=="") {
|
header("Location: /HospitalDepartment.php?SystemMessageType=4&SMT=1");
|
exit;
|
}
|
foreach ($ID as $key => $ID) {
|
$Hospital_vtext=empty($_REQUEST['Hospital_vtext_'.$ID])!=false ? "" : $_REQUEST['Hospital_vtext_'.$ID];
|
$Hospital_vOrder=empty($_REQUEST['Hospital_vOrder_'.$ID])!=false ? "" : $_REQUEST['Hospital_vOrder_'.$ID];
|
if ($Hospital_vtext!="") {
|
$sql = "select id,vType from dictionary where vtitle='HospitalDepartment' and vType=1 and vtext='$Hospital_vtext' and id<>".$ID ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)==0) {
|
$sql="update dictionary set vtext='".$Hospital_vtext."',vOrder=".$Hospital_vOrder." where id=".$ID;
|
$UPsql = sqlsrv_query($conn,$sql);
|
} else {
|
header("Location: /HospitalDepartment.php?SystemMessageType=4&SMT=5"); exit;
|
}
|
}
|
}
|
}
|
//var_dump($ICD_ID);exit;
|
header("Location: /HospitalDepartment.php?SystemMessageType=3&SMT=2");exit;
|
break;
|
|
case 16: //医院科室目录删除
|
$ID=empty($_REQUEST['ID'])!=false ? "" : $_REQUEST['ID'];
|
if ($ID=="") {
|
header("Location: /HospitalDepartment.php?SystemMessageType=4&SMT=1");
|
exit;
|
}
|
foreach ($ID as $key => $ID) {
|
if ($ID!="") {
|
$sql="update dictionary set vType=0 where id=".$ID;
|
$data = sqlsrv_query($conn,$sql);
|
}
|
}
|
//var_dump($ICD_ID);exit;
|
header("Location: /HospitalDepartment.php?SystemMessageType=3&SMT=4");exit;
|
break;
|
|
case 17: //手机后台优惠券派送
|
$ID=empty($_REQUEST['ID'])!=false ? 0 : $_REQUEST['ID'];
|
$sql = "select CouponNO,CouponMoney,CouponName from Coupon where id=".$ID ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$CouponNO=$rs["CouponNO"];
|
$CouponMoney=$rs["CouponMoney"];
|
$CouponName=$rs["CouponName"];
|
$sql="update Coupon set CouponState=0 where CouponState=-1 and id=".$ID;
|
$UPsql = sqlsrv_query($conn,$sql);
|
header("Location: https://api.966120.com.cn/User/UserCoupons.php?D_No=".$CouponNO."&CouponName=".$CouponName); exit;
|
}
|
} else {
|
header("Location: CouponAdminList.php?as=1"); exit;
|
}
|
}
|
//var_dump($ICD_ID);exit;
|
break;
|
}
|
?>
|
