<?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="";
|
$ADMINName ='';
|
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";}
|
}
|
}
|
ElseIf ($adminID="177" And $DataID="UserName"){
|
$ADMINName="无";
|
}
|
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
|
|
//--------------------------个人绩效提成算法2---------------------begin
|
function EntourageDKP_Money_B($DispatchOrdPerfomance,$EntourageOT_is,$EntourageLong_is,$EntourageBetimesHH,$EntourageDKP,$EntourageDKPScale,$EntourageState_Time,$StretcherM) {
|
$EntourageDKP_Money=0;
|
If ($EntourageOT_is=1) { //加班绩效提成计算方式
|
If ($DispatchOrdPerfomance<=1000) {
|
If ($EntourageName="医生") {
|
$EntourageDKP_Money=100;
|
}
|
ElseIf ($EntourageName="护士") {
|
$EntourageDKP_Money=80;
|
}
|
Else {
|
$EntourageDKP_Money=70;
|
}
|
}
|
ElseIf ($DispatchOrdPerfomance>1000 And $DispatchOrdPerfomance<=2000) {
|
If ($EntourageName="医生") {
|
$EntourageDKP_Money=200;
|
}
|
ElseIf ($EntourageName="护士") {
|
$EntourageDKP_Money=160;
|
}Else{
|
$EntourageDKP_Money=140;
|
}
|
}
|
ElseIf ($DispatchOrdPerfomance>2000 And $DispatchOrdPerfomance<=3000) {
|
If ($EntourageName="医生") {
|
$EntourageDKP_Money=300;
|
}
|
ElseIf ($EntourageName="护士") {
|
$EntourageDKP_Money=240;
|
} Else {
|
$EntourageDKP_Money=210;
|
}
|
} Else {
|
If ($EntourageName="医生") {
|
$EntourageDKP_Money=number_format($DispatchOrdPerfomance*0.1,1);
|
}
|
ElseIf ($EntourageName="护士") {
|
$EntourageDKP_Money=number_format($DispatchOrdPerfomance*0.08,1);
|
} Else {
|
$EntourageDKP_Money=number_format($DispatchOrdPerfomance*0.07,1);
|
}
|
}
|
} Else { //正常上班时间
|
If ($EntourageBetimesHH>0) {
|
//If ($EntourageBetimesHH>2 And DateDiff("d",EntourageState_Time,"2016-12-5")<=0)) {$EntourageBetimesHH=2;}
|
$EntourageDKP_Money=$EntourageBetimesHH*30;
|
}
|
$EntourageDKP_Money=$EntourageDKP_Money+number_format($EntourageDKP*$EntourageDKPScale,1);
|
}
|
//$EntourageDKP_Money_B=$EntourageDKP_Money+$StretcherM;
|
return $EntourageDKP_Money+$StretcherM;
|
|
}
|
//--------------------------个人绩效提成算法2---------------------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 OrderClassA($OrderClass) {
|
global $conn;
|
$sql = "select top 1 vtext from dictionary where vtitle='OrderClass' and vOrder2='".$OrderClass."' order by vType desc";
|
//echo $sql;exit;
|
$dataDt = sqlsrv_query($conn,$sql);
|
if($dataDt == true){
|
while($OrderClassrs = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
|
return $OrderClassrs['vtext'];
|
}
|
}Else{
|
return $OrderClass;
|
}
|
}
|
//--------------------------订单分区---------------------end
|
|
//--------------------------订单级别查询---------------------begin
|
Function OrderLevelA($OrderLevel) {
|
global $conn;
|
$sql = "select top 1 vtext from dictionary where vtitle='OrderLevel' and vID=".$OrderLevel." order by vType desc";
|
//echo $sql;exit;
|
$dataDt = sqlsrv_query($conn,$sql);
|
if($dataDt == true){
|
while($OrderLevelrs = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
|
return $OrderLevelrs['vtext'];
|
}
|
}Else{
|
return $OrderLevel;
|
}
|
}
|
//--------------------------订单级别查询---------------------end
|
|
//--------------------------订单出发类型查询---------------------begin
|
Function DepartureTypeA($DepartureType) {
|
global $conn;
|
$sql = "select top 1 vtext from dictionary where vtitle='DepartureType' and vID=".$DepartureType." order by vType desc";
|
//echo $sql;exit;
|
$dataDt = sqlsrv_query($conn,$sql);
|
if($dataDt == true){
|
while($DepartureTypers = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
|
return $DepartureTypers['vtext'];
|
}
|
}Else{
|
return $DepartureType;
|
}
|
}
|
//--------------------------订单出发类型查询---------------------end
|
|
//--------------------------车辆资料查询---------------------begin
|
Function CarDataA($CarID,$CarLicense,$DataID) {
|
global $conn;
|
$sql='';
|
If ($CarID!="") {
|
$CarDataA=$CarID;
|
$sql = "select * from CarData where CarID=".$CarID;
|
} ElseIf ($CarLicense!="") {
|
$CarDataA=$CarLicense;
|
$sql = "select * from CarData where CarLicense='".$CarLicense."'";
|
}
|
if ($sql!='') {
|
//echo $sql;exit;
|
$dataDt = sqlsrv_query($conn,$sql);
|
if($dataDt == true){
|
while($ServiceOrdTypers = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
|
if ($DataID=='CarLicense'){
|
return $ServiceOrdTypers['CarLicense'];
|
}else{
|
return $ServiceOrdTypers['CarID'];
|
}
|
}
|
}Else{
|
return $CarID;
|
}
|
}else{
|
return '--';
|
}
|
}
|
//--------------------------车辆资料查询---------------------end
|
|
//--------------------------客户评价(2020.12.22)---------------------begin
|
Function Guest_PointEA($Guest_PointE) {
|
$Guest_PointEA="";
|
$Guest_PointE_arr=explode(",",$Guest_PointE);
|
foreach ($Guest_PointE_arr as $key => $value) {
|
if (!empty($value)){
|
if ($value == "9") {
|
$Guest_PointEA = $Guest_PointEA.",满意";
|
}elseif ($value == "8") {
|
$Guest_PointEA = $Guest_PointEA.",满意";
|
}elseif ($value == "1") {
|
$Guest_PointEA = $Guest_PointEA.",不满意技能水平";
|
}elseif ($value == "2") {
|
$Guest_PointEA = $Guest_PointEA.",不满意服务水平";
|
}else{
|
$Guest_PointEA = $Guest_PointE;
|
}
|
}
|
}
|
if (!empty($Guest_PointEA)) {$Guest_PointEA=substr($Guest_PointEA,1);}
|
return $Guest_PointEA;
|
}
|
//--------------------------客户评价---------------------end
|
|
//--------------------------个人绩效提成算法3 2018-10-25开始使用---------------------begin
|
Function EntourageDKP_Money_C($OA_User_ID,$DispatchOrdID,$ServiceOrdType,$OrdDistance,$TimeLength_Program,$TimeLength_ICU,$TimeLength_Wait,$EntourageMileageFactor,$EntourageOT_is,$EntourageBetimesHH,$Stretcher_Money,$EntourageP1,$Condition_is) {
|
$ConversionDistance=0;
|
$EntourageOT_Money=0;
|
$Condition_Money=0;
|
$CompetencyID=0;
|
//select top 1 @CompetencyID=OA_CompetencyID from OA_User,OA_Competency where OA_CompetencyUserID=OA_User_ID and OA_User_ID=@OA_User_ID order by OA_CompetencyID
|
|
//是否加班/提前出车
|
if ($EntourageOT_is=1 or $EntourageBetimesHH>0) {
|
$EntourageOT_Money=30;
|
}
|
|
//折算行驾里程
|
if ($OrdDistance>=0 and $OrdDistance<=50) {
|
$ConversionDistance = 50;
|
}elseif ($OrdDistance>50 and $OrdDistance<=100 and $ServiceOrdType!=9) {
|
$ConversionDistance = 100;
|
}elseif ($OrdDistance>100 and $OrdDistance<=150 and $ServiceOrdType!=9) {
|
$ConversionDistance = 150;
|
}elseif ($OrdDistance>150 and $OrdDistance<=200 and $ServiceOrdType!=9) {
|
$ConversionDistance = 200;
|
}elseif ($OrdDistance>200 and $OrdDistance<=250 and $ServiceOrdType!=9) {
|
$ConversionDistance = 250;
|
}else{
|
$ConversionDistance = $OrdDistance;
|
}
|
|
//里程为-1时,行驾里程为0公里
|
if ($ConversionDistance<0) {
|
$ConversionDistance = 0;
|
}
|
|
//大型活动保障时长
|
if ($TimeLength_Program>0) {
|
$ConversionDistance=$ConversionDistance+($TimeLength_Program*30);
|
}
|
//居家ICU
|
if ($TimeLength_ICU>0) {
|
$ConversionDistance=$ConversionDistance+($TimeLength_ICU*50);
|
}
|
//等待时长
|
if ($TimeLength_Wait>0) {
|
$ConversionDistance=$ConversionDistance+($TimeLength_Wait*20);
|
}
|
//机场单
|
if ($ServiceOrdType==4) {
|
if ($OrdDistance==0){$ConversionDistance=0;}
|
$ConversionDistance=$ConversionDistance+150;
|
}
|
//救援单
|
if ($ServiceOrdType==10) {
|
if ($OrdDistance<50) {
|
$ConversionDistance = 50;
|
}else{
|
$ConversionDistance = $OrdDistance;
|
}
|
}
|
//高铁,航空单
|
if ($ServiceOrdType==8 or $ServiceOrdType==5){
|
$ConversionDistance=0;
|
}
|
//司机单独出车系数
|
//if ($CompetencyID=2 and $EntourageMileageFactor=1.2 and $ConversionDistance>250)
|
// $EntourageMileageFactor=1.5
|
|
//计算个人系数
|
$ConversionDistance = $ConversionDistance*$EntourageMileageFactor;
|
|
//人工绩效计提修改
|
//select $ConversionDistance=EntourageMileageEdit from DispatchOrd_Entourage where EntourageMileageEdit is not null and DispatchOrdIDDt=$DispatchOrdID and EntourageOAid=$OA_User_ID
|
|
|
//特殊项目金额(使用呼吸机,保温箱,ECMO 医生50元/单/人,护士30元/单/人)
|
if ($CompetencyID==3 and $Condition_is>0){
|
$Condition_Money=50;
|
}
|
if ($CompetencyID==4 and $Condition_is>0){
|
$Condition_Money=30;
|
}
|
return array($ConversionDistance,$EntourageOT_Money,$Stretcher_Money,$EntourageMileageFactor,$Condition_Money);
|
}
|
//--------------------------个人绩效提成算法3 2018-10-25开始使用---------------------end
|
?>
|
