| | |
|---|
| | | while ($rsEntourage = sqlsrv_fetch_array($dataEntourage)) {
|
|---|
| | | $entourageList[$i]["Follower"] = $rsEntourage['PersonName'];
|
|---|
| | | $entourageList[$i]["FollowerRatio"] = $rsEntourage['CommissionRatio'];
|
|---|
| | | $i++;
|
|---|
| | | }
|
|---|
| | | $staffList['entourage'] = $entourageList;
|
|---|
| | | }
|
|---|
| | |
|---|
| | | $sqlPage="" ;
|
|---|
| | | }
|
|---|
| | | $sql = "select * $Additional_sql from ($Result_sql) sqlData ".$sqlPage." order by sqlData.n" ;
|
|---|
| | | // echo $sql;exit;
|
|---|
| | | // echo $sql;exit;
|
|---|
| | |
|
|---|
| | | // 初始化变量，确保在所有情况下都被定义
|
|---|
| | | $FormArrayX = 0;
|
|---|
| | | $FormArray = array();
|
|---|
| | |
|
|---|
| | | $data = sqlsrv_query($conn,$sql);
|
|---|
| | | if($data == true){
|
|---|
| | | $FormArray=array();
|
|---|
| | | //表头
|
|---|
| | | $FormArray[0]=array("序号","服务单号","调度单号","级别","分区","预约类型","调度单状态","日期","时间","班次","联系人","联系电话","患者姓名","销售","介绍人","客服","调度","来源","是否企微成交","主要企微客服","其他企微客服","情景编号","企微绩效","总部下发","支援总部","承包组","区域","类型","出发省份","出发市","出发区","转出医院","转出科室","转出床位","转入省份","转入市","转入区","转入医院","转入科室","总成交价","系统报价参考","等待费","担架费","居家ICU费","距离(公里)","支付方式","使用呼吸机","车牌","出车成员","出车岗位","医护出车时间(分钟)","开单人","开单人提成比例","跟单人","跟单人提成比例","跟单人","跟单人提成比例","跟单人","跟单人提成比例","跟单人","跟单人提成比例");
|
|---|
| | | if ($is_CSV==1){array_push($FormArray[0],"任务备注");}
|
|---|
| | |
|---|
| | | }
|
|---|
| | | if (!empty($rs2['entourage'])) {
|
|---|
| | | //$rs2['entourage']的长度
|
|---|
| | | $count=count($rs2['entourage']);
|
|---|
| | | |
|---|
| | | $FormArray[$i][53]='--';
|
|---|
| | | $FormArray[$i][54]='';
|
|---|
| | | $FormArray[$i][55]='--';
|
|---|
| | | $FormArray[$i][56]='';
|
|---|
| | | $FormArray[$i][57]='--';
|
|---|
| | | $FormArray[$i][58]='';
|
|---|
| | | $FormArray[$i][59]='--';
|
|---|
| | | $FormArray[$i][60]='';
|
|---|
| | | $j=0;
|
|---|
| | |
|
|---|
| | | foreach ($rs2['entourage'] as $key => $value) {
|
|---|
| | | $FormArray[$i][53+$j]=$value['Follower'];
|
|---|
| | | $FormArray[$i][54+$j]=$value['FollowerRatio'];
|
|---|
| | | $j++; |
|---|
| | | $FormArray[$i][53+$j*2]=$value['Follower'];
|
|---|
| | | $FormArray[$i][54+$j*2]=$value['FollowerRatio'];
|
|---|
| | | $j++;
|
|---|
| | | }
|
|---|
| | | if($count<4){
|
|---|
| | | //补足4个
|
|---|
| | | while($j<4){
|
|---|
| | | $FormArray[$i][53+$j*2]='--';
|
|---|
| | | $FormArray[$i][54+$j*2]='';
|
|---|
| | | $j++;
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | |
|---|
| | | }else{
|
|---|
| | | $FormArray[$i][53]='--';
|
|---|
| | | $FormArray[$i][54]='';
|
|---|
