fix:将开单人跟单人放到服务单中

wanglizhong

2025-04-28 1e955583470b47f7636eaba800c52c258ac24296

 Report_DispatchDetailed_Data.php

@@ -327,15 +327,15 @@
/**

 * 根据 DispatchOrdID 查找开单人及跟单人列表

 * 

 * @param int $DispatchOrdID 调度单 ID

 * @param int $ServiceOrdID 调度单 ID

 * @param object $conn 数据库连接对象

 * @return array 包含开单人及跟单人信息的数组

 */

function getDispatchOrderStaff($DispatchOrdID, $conn) {

function getDispatchOrderStaff($ServiceOrdID, $conn) {

    $staffList = [];



    // 查询开单人信息

    $sqlDispatcher = "select PersonName,CommissionRatio from ServiceOrderCommissionDetails where ServiceOrderID='$DispatchOrdID' and PersonType='Opener'";

    $sqlDispatcher = "select PersonName,CommissionRatio from ServiceOrderCommissionDetails where ServiceOrderID='$ServiceOrdID' and PersonType='Opener'";

                      

    $dataDispatcher = sqlsrv_query($conn, $sqlDispatcher);

    if ($dataDispatcher && sqlsrv_has_rows($dataDispatcher)) {

@@ -345,7 +345,7 @@
    }



    // 查询跟单人列表

    $sqlEntourage = "select PersonName,CommissionRatio from ServiceOrderCommissionDetails where ServiceOrderID='$DispatchOrdID' and PersonType='Follower'";

    $sqlEntourage = "select PersonName,CommissionRatio from ServiceOrderCommissionDetails where ServiceOrderID='$ServiceOrdID' and PersonType='Follower'";

    $dataEntourage = sqlsrv_query($conn, $sqlEntourage);

    if ($dataEntourage) {

        $entourageList = [];

@@ -381,7 +381,7 @@
if($data == true){

   $FormArray=array();

   //表头

   $FormArray[0]=array("序号","服务单号","调度单号","级别","分区","预约类型","调度单状态","日期","时间","班次","联系人","联系电话","患者姓名","销售","介绍人","客服","调度","来源","是否企微成交","主要企微客服","其他企微客服","情景编号","企微绩效","总部下发","支援总部","承包组","区域","类型","出发省份","出发市","出发区","转出医院","转出科室","转出床位","转入省份","转入市","转入区","转入医院","转入科室","总成交价","系统报价参考","等待费","担架费","居家ICU费","距离(公里)","支付方式","使用呼吸机","车牌","出车成员","出车岗位","医护出车时间(分钟)","开单人","开单人提成比例","跟单人","跟单人提成比例","跟单人","跟单人提成比例","跟单人","跟单人提成比例");

   $FormArray[0]=array("序号","服务单号","调度单号","级别","分区","预约类型","调度单状态","日期","时间","班次","联系人","联系电话","患者姓名","销售","介绍人","客服","调度","来源","是否企微成交","主要企微客服","其他企微客服","情景编号","企微绩效","总部下发","支援总部","承包组","区域","类型","出发省份","出发市","出发区","转出医院","转出科室","转出床位","转入省份","转入市","转入区","转入医院","转入科室","总成交价","系统报价参考","等待费","担架费","居家ICU费","距离(公里)","支付方式","使用呼吸机","车牌","出车成员","出车岗位","医护出车时间(分钟)","开单人","开单人提成比例","跟单人","跟单人提成比例","跟单人","跟单人提成比例","跟单人","跟单人提成比例","跟单人","跟单人提成比例");

   if ($is_CSV==1){array_push($FormArray[0],"任务备注");}

   $FormArrayX=count($FormArray[0]);

   if (sqlsrv_rows_affected($data)==0) {

@@ -401,11 +401,11 @@
            $isRespirator="是";

         }

         //读取数据--End

			
         $ServiceOrdID=$rs['ServiceOrdID'];

         //写入数组

         $FormArray[$i][0]=$i+(($page-1)*$page_size);

         If ($OrdType=="2") {

            $FormArray[$i][1]="<a href='ServiceOrder.gds?ServiceOrdID=".$rs['ServiceOrdID']."&OrdDateType=4&OrdClassList=&h_menu1_1=1' target='_blank'>".$rs['ServiceOrdNo']."</a>";

            $FormArray[$i][1]="<a href='ServiceOrder.gds?ServiceOrdID=".$ServiceOrdID."&OrdDateType=4&OrdClassList=&h_menu1_1=1' target='_blank'>".$rs['ServiceOrdNo']."</a>";

            if (!empty($rs['DispatchOrdNo'])) {

               $FormArray[$i][2]="<a href='DispatchOrder.gds?DispatchOrdID=".$rs['DispatchOrdID']."&OrdDateType=4&OrdClassList=&h_menu1_1=1' target='_blank'>".$rs['DispatchOrdNo']."</a>";

            }else{

@@ -522,7 +522,7 @@
         $FormArray[$i][48]=$rs['EntourageName'];

         $FormArray[$i][49]=$rs['EntouragePost'];

         $FormArray[$i][50]=$rs['Stime2'];

         $rs2=getDispatchOrderStaff($rs['DispatchOrdID'], $conn);

         $rs2=getDispatchOrderStaff($ServiceOrdID, $conn);

         //如果 $rs2 为空，设置默认值

         if (empty($rs2)) {

            $FormArray[$i][51]='--';

@@ -541,9 +541,9 @@
               $FormArray[$i][54+$j]=$value['FollowerRatio'];

               $j++;   

            }   

            if($count<3){

               //补足3个

               while($j<3){

            if($count<4){

               //补足4个

               while($j<4){

                  $FormArray[$i][53+$j*2]='--';

                  $FormArray[$i][54+$j*2]='';

                  $j++;

@@ -556,8 +556,10 @@
            $FormArray[$i][56]='';

            $FormArray[$i][57]='--';

            $FormArray[$i][58]='';

            $FormArray[$i][59]='--';

            $FormArray[$i][60]='';

         }

         if ($is_CSV==1){$FormArray[$i][59]=$rs['ServiceOrdTaskRemarks'];}

         if ($is_CSV==1){$FormArray[$i][61]=$rs['ServiceOrdTaskRemarks'];}



         $i++;

         //写入数组--End