$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;
}
?>