<?php
|
header("Content-Type: text/html; charset=utf-8");
|
session_start();
|
//echo phpinfo();
|
//exit;
|
$serverName = "120.25.98.119,1432";//服务器的名字，本地localhost
|
$connectionInfo = array( "Database"=>"Welcab", "UID"=>"camesa", "PWD"=>"camesa", "CharacterSet"=>"UTF-8");
|
$conn = sqlsrv_connect( $serverName, $connectionInfo);
|
if( $conn ) {
|
//echo "Connection established.<br />";
|
}else{
|
echo "数据库连接失败!!<br />";
|
die( print_r( sqlsrv_errors(), true));
|
}
|
|
$GPSKey = "wx966120";
|
$APPkey = "y4Zx8UC1esErKTxt";
|
//员工照片网址
|
$OAImgURL = "https://api.966120.com.cn/OA_img/";
|
|
$errcode = 1;
|
$webJson = array();
|
|
|
//API权限校验
|
$APPID = empty($_REQUEST['APPID'])!=false ? "" : $_REQUEST['APPID'];
|
$method = empty($_REQUEST['method'])!=false ? "" : $_REQUEST['method'];
|
If (empty($APPID)==false) {
|
$sql="select top 1 UnitID,UnitName,APPSECRET,UnitState,is_test,wx_APPID,pay_mch_id from IntroducerUnitData where APPID='$APPID'";
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$UnitID = $rs['UnitID'];
|
$UnitName = $rs['UnitName'];
|
$UnitState = $rs['UnitState'];
|
$APPSECRET = $rs['APPSECRET'];
|
$wx_APPID = $rs['wx_APPID'];
|
$pay_mch_id = $rs['pay_mch_id'];
|
$is_test = $rs['is_test'];
|
if ($UnitState==0) {
|
$errcode=40002;
|
$errmsg="invalid Unit";
|
}elseif (strlen($APPSECRET)<6) {
|
$errcode=40003;
|
$errmsg="No permission";
|
}
|
}
|
}else{
|
$errcode=40001;
|
$errmsg="invalid APPID";
|
}
|
}
|
}Else{
|
//$errcode=40000;
|
//$errmsg="empty APPID";
|
}
|
|
If (substr($errcode,0,1)=="4") {
|
$webJson['APPID'] = $APPID;
|
$webJson['method'] = $method;
|
$webJson['result'] = 2;
|
$webJson['errcode'] = $errcode;
|
$webJson['errmsg'] = $errmsg;
|
echo json_encode($webJson,JSON_UNESCAPED_UNICODE);
|
exit;
|
}
|
?>
|
