<?php
//--------------------------常用字符转义---------------------begin
function strSql($str) {
	$str=addslashes($str);
	$str=str_replace("'","''",$str);
	$str=str_replace("--","- -",$str);
	$str=str_replace("exec","",$str);
	$str=str_replace("DECLARE","",$str);
	//$str=str_replace("\"","''",$str);
	return $str;
}
//--------------------------常用字符转义---------------------end

//--------------------------用户查找---------------------begin
function OAUser($adminID,$DataID) {
	$OAUser="";
	if (isset($adminID)){
		global $conn;
		$sql = "select OA_User_ID,OA_User,OA_Name,OA_weixinAvatar,OA_mobile,OA_DepartmentID from OA_User where OA_User_ID=".$adminID;
		$dataDt = sqlsrv_query($conn,$sql);
		if($dataDt == true){
			while($rsDt = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
				$ADMINuserID	= $rsDt['OA_User_ID'];
				$ADMINuser		= $rsDt['OA_User'];
				$ADMINName		= $rsDt['OA_Name'];
				$ADMINMobile	= $rsDt['OA_mobile'];
				$ADMINAvatar	= $rsDt['OA_weixinAvatar'];
				$ADMINDepartmentID	= $rsDt['OA_DepartmentID'];
				If ($ADMINAvatar=="") {$ADMINAvatar="/resources/images/icon_avatar_default.png";}
			}
		}
		else{
			$DataID="adminID";
		}
		switch ($DataID) {
			case "userID":
			  $OAUser .= $ADMINuserID;
			  break;  
			case "UserName":
			  $OAUser .= $ADMINName;
			  break;
			case "UserPhone":
			  $OAUser .= $ADMINMobile;
			  break;
			case "adminID":
			  $OAUser .= $adminID;
			  break;
			case "Avatar":
			  $OAUser .= $ADMINAvatar;
			  break;
			case "DepartmentID":
			  $OAUser .= $ADMINDepartmentID;
			  break;
			case "DepartmentName":
			  $sql = "select vtext from dictionary where vtitle='OA_Department' and vID=".$ADMINDepartmentID;
			  $dataDt = sqlsrv_query($conn,$sql);
			  if($dataDt == true){
				while($rsDt = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
					$OAUser	= $rsDt['vtext'];
				}
			  }
			  break;
			default:
			  $OAUser .=  $adminID;
		}
	}
	return $OAUser;
}
//--------------------------用户查找---------------------end

//--------------------------企业用户查找---------------------begin
Function UnitIntroducer($ServiceOrdIntroducer,$DataID){
$IntroducerName="";
	if (isset($ServiceOrdIntroducer)){
		If (is_numeric($ServiceOrdIntroducer)){
			global $conn;
			$sql = "select IntroducerID,IntroducerName,IntroducerUnitID from IntroducerData where IntroducerID=".$ServiceOrdIntroducer;
			$dataDt = sqlsrv_query($conn,$sql);
			if($dataDt == true){
				while($rsDt = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
					$IntroducerID		= $rsDt['IntroducerID'];
					$IntroducerName		= $rsDt['IntroducerName'];
					$IntroducerUnitID	= $rsDt['IntroducerUnitID'];
				}
			}Else{
			$DataID="TXT";
			}
		}Else{
			$DataID="TXT";
		}
	}else{
		$DataID="TXT";
	}

	switch ($DataID) {
		case "TXT";
			$UnitIntroducer = $ServiceOrdIntroducer;
			break;
		case "UnitName";
			$UnitIntroducer = $IntroducerName;
			break;
		case "UnitID";
			$UnitIntroducer = $IntroducerUnitID;
			break;
		default:
			$UnitIntroducer = $ServiceOrdIntroducer;
	}
	return $UnitIntroducer;
}
//--------------------------企业用户查找---------------------end

//--------------------------数字转字母（用于Excel列标）---------------------begin
/**
 * 数字转字母 （类似于Excel列标）
 * @param Int $index 索引值
 * @param Int $start 字母起始值
 * @return String 返回字母
 echo IntToChr(27);
 */
function IntToChr($index, $start = 65) {
    $str = '';
    if (floor($index / 26) > 0) {
        $str .= IntToChr(floor($index / 26)-1);
    }
    return $str . chr($index % 26 + $start);
}
//--------------------------数字转字母---------------------end

//--------------------------文本日期转实际时间---------------------begin
function TXTDateToDate($TXTDate) {
    $str = '';
    switch ($TXTDate) {
		case "当天":
		  $str = date("Y-m-d");
		  break;  
		case "昨天":
		  $str = date("Y-m-d",strtotime('-1 day'));
		  break;
		case "前天":
		  $str = date("Y-m-d",strtotime('-2 day'));
		  break;
		case "本周":
		  $str = date("Y-m-d",strtotime('last day this week'))."至".date("Y-m-d",strtotime('last day this week +6 days'));
		  break;
		case "上周":
		  $str = date("Y-m-d",strtotime('last day this week -1 week'))."至".date("Y-m-d",strtotime('last day this week -1 days'));
		  break;
		case "本月":
		  $str = date("Y年m月");
		  break;
		case "上月":
		  $str = date("Y年m月",strtotime("last month"));
		  break;
		case "本年":
		  $str = date("Y年");
		  break;
		case "本结算月":
		  $str = date("Y-m-",strtotime("last month"))."25"."至".date("Y-m-")."24";  
		  /*
		  if(date("d")<=24) {
			$str = date("Y-m-",strtotime("last month"))."25"."至".date("Y-m-")."24";
		  }else{
			$str = date("Y-m-")."25"."至".date("Y-m-",strtotime("+1 month"))."24";
		  }
		  */
		  break;
		default:
		  $str = $TXTDate;
	}
    return $str;
}
//--------------------------文本日期转实际时间---------------------end

//--------------------------无限级菜单排序算法---------------------begin
//组成多级数组
function MultiLevelConvert1($arr,$id){
	$res = array();
	foreach ($arr as $key => $value) {
		if ($value["pid"] == $id) {
			$value["child"]=MultiLevelConvert1($arr,$value["id"]);
			array_push($res,$value);
		}
	}
	return $res;
}
//重新整理成一维数组
function MultiLevelConvert2($arr,$level){
	  $res = array();
	  foreach ($arr as $key => $value) {
		if (count($value)>0) {
			$value["level"]=$level;
			if (count($value['child'])>0) {
				$res2=MultiLevelConvert2($value['child'],$level+1);
				array_pop($value);array_push($res,$value);
				foreach ($res2 as $key => $value) {array_push($res,$value);}
			}
			else {array_pop($value);array_push($res,$value);}
		}
	  }
	  return $res;
}
//--------------------------无限级菜单排序算法---------------------end

//--------------------------调度单跟随人员---------------------begin
function EntourageOANameA($EntourageID,$DispatchOrdID,$DataID){
	$res = $EntourageID;
	if (empty($EntourageID)==false and empty($DispatchOrdID)==false) {
		global $conn;
		$sql = "select OA_User_ID,OA_User,OA_Name,OA_weixinAvatar,EntourageLead,EntourageState,EntourageMileageFactor,EntourageDKP,EntourageDKPScale,EntourageOT_is,EntourageLong_is,EntourageBetimesHH,EntourageEnd_Time,EntourageState_Time,Stretcher_is from DispatchOrd_Entourage,OA_User where OA_User_ID=EntourageOAid and EntourageState<>4 and DispatchOrdIDDt=".$DispatchOrdID." and EntourageID=".$EntourageID;
		//echo $sql;exit;
		$dataDt = sqlsrv_query($conn,$sql);
		if($dataDt == true){
			while($EntourageOArs = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
				$EntourageOAuserID	= $EntourageOArs['OA_User_ID'];
				$EntourageOAuser	= $EntourageOArs['OA_User'];
				$EntourageOAName	= $EntourageOArs['OA_Name'];
				$EntourageOAAvatar=empty($EntourageOArs['OA_weixinAvatar'])!=false ? "/resources/images/icon_avatar_default.png" : $EntourageOArs['OA_weixinAvatar'];
				$EntourageLead	= $EntourageOArs['EntourageLead'];
				$EntourageState	= $EntourageOArs['EntourageState'];
				$EntourageMileageFactor	= $EntourageOArs['EntourageMileageFactor'];
				$EntourageOT_is	= $EntourageOArs['EntourageOT_is'];
				$EntourageLong_is	= $EntourageOArs['EntourageLong_is'];
				$EntourageBetimesHH	= $EntourageOArs['EntourageBetimesHH'];
				$EntourageDKP	= $EntourageOArs['EntourageDKP'];
				$EntourageDKPScale	= $EntourageOArs['EntourageDKPScale'];
				$EntourageEnd_Time	= $EntourageOArs['EntourageEnd_Time'];
				$EntourageState_Time	= $EntourageOArs['EntourageState_Time'];
				$Stretcher_is	= $EntourageOArs['Stretcher_is'];
			}
		}Else{
			$DataID="userID";
			$EntourageOAuserID=$EntourageID;
		}
		
		if (isset($EntourageOAuserID)) {
			switch ($DataID)
			{
			case "userID":
				$res= $EntourageOAuserID;
				break;  
			case "UserName":
				$res= $EntourageOAName;
				If ($EntourageOAState==3) {
				  $res = "<font color='#6699ff'>".$res."</font>";
				}
				ElseIf ($EntourageOAState==2) {
				  $res = "<font color='#C3C3C3'>".$res."</font>";
				}
				If ($EntourageOALead==1) { $res = "<img src='/resources/images/2016020401.png'>".$res;}
				break;
			case "UserNameReport":
				$res= $EntourageOAName;
				If ($EntourageMileageFactor!=1) {
				  $res = $res."/".floatval(number_format($EntourageMileageFactor,2,".",""));
				}
				If ($EntourageID==5 Or $EntourageID==6 Or $EntourageID==2) {
					$res="，".$res;
				}
				break;
			default:
				$res="";
			}
		} else {
			$res="";
		}

	}
	return $res;
}
//--------------------------调度单跟随人员---------------------end


//--------------------------服务单类型---------------------begin
Function ServiceOrdTypeA($ServiceOrdType) {
	global $conn;
	$sql = "select vtext from dictionary where vtitle='ServiceOrderType' and vID=".$ServiceOrdType;
	//echo $sql;exit;
	$dataDt = sqlsrv_query($conn,$sql);
	if($dataDt == true){
		while($ServiceOrdTypers = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
			return $ServiceOrdTypers['vtext'];
		}
	}Else{
		return $ServiceOrdType;
	}
}
//--------------------------服务单类型---------------------end


//--------------------------单据状态---------------------begin
function OrdState_A($ServiceOrdState,$DispatchOrdState) {
	$OrdState="";
	if ($ServiceOrdState==1) {
		$OrdState="咨询";
	}
	elseif ($ServiceOrdState==4) {
		$OrdState="取消";
	}
	else {
		if ($DispatchOrdState==4 or $DispatchOrdState==5) {
			$OrdState="已出车";
		}
		elseif ($DispatchOrdState==6) {
			$OrdState="转运途中";
		}
		elseif ($DispatchOrdState==8 or $DispatchOrdState==7) {
			$OrdState="已完成";
		}
		elseif ($DispatchOrdState==9 or $DispatchOrdState==10) {
			$OrdState="已取消";
		}
		else {
			$OrdState="处理中";
		}
	}
	return $OrdState;

}
//--------------------------单据状态---------------------end

//--------------------------科室---------------------begin
Function PtServices_A($ServiceOrdPtServicesID) {
	global $conn;
	$sql = "select vId,vtext from dictionary where vType=1 and vtitle='HospitalDepartment' and vId=".$ServiceOrdPtServicesID;
	//echo $sql;exit;
	$dataDt = sqlsrv_query($conn,$sql);
	if($dataDt == true){
		while($PtServicesrs = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
			return $PtServicesrs['vtext'];
		}
	}Else{
		return $ServiceOrdPtServicesID;
	}
}
//--------------------------科室---------------------end

//--------------------------车牌信息---------------------begin
Function CarDataA($CarID) {
	global $conn;
	$sql = "select * from CarData where CarID=".$CarID;
	//echo $sql;exit;
	$dataDt = sqlsrv_query($conn,$sql);
	if($dataDt == true){
		while($CarDatars = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
			return $CarDatars['CarLicense'];
		}
	}Else{
		return $CarID;
	}
}
//--------------------------车牌信息---------------------end

//--------------------------信息加签---------------------begin
Function PHP_Sign($GetUrl,$GetArgs,$APPSECRET) {
	//$arr = str_split($GetArgs,"&");
	$str=str_replace('=', '', $GetArgs);
	$arr = explode('&', $str);
	asort($arr);
	$str=implode('',$arr);
	$str=$str.$APPSECRET;
	$Sign=MD5($str);
	return $Sign;
}
//--------------------------信息加签---------------------end
?>