"CAME", "UID"=>"camesa", "PWD"=>"camesa", "CharacterSet"=>"UTF-8");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
//echo "Connection established.
";
}else{
echo "数据库连接失败!!
";
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;
}
?>