$postData['date_preset'], "startDate" => $postData['start'], "endDate" => $postData['end'], "splitMode" => $postData['split_mode'] ); if(isset($_REQUEST["level_filter"])){ if(!empty($postData["rdv"])){ $rdv = ($postData["rdv"] == "rdv") ? 1 : 0; $filter .= " AND s.rdv = ".$rdv; } if($date_preset == "custom-year"){ $selects .= ", YEAR(date_arrivee) as annee"; $groupBy[] = "YEAR(date_arrivee)"; $orderBy[] = "YEAR(date_arrivee)"; } if($split_mode){ switch($split_mode){ case 'non_split': break; case 'agence': $joins .= " LEFT JOIN ca_agences agence ON agence.id_agence = s.id_agence"; $selects .= (strpos($selects, 'agence.nom_agence') == FALSE) ? ", agence.nom_agence" : ""; $filter .= " AND agence.supp = 0"; $splitModeHeader = "
Année | " : ""; $table .= $split_mode ? $splitModeHeader : ""; $table .= $hierarchical_mode ? implode('',$hierarchicalModeHeaders) : ""; $table .= 'Nombre | '; $table .= $time_split ? 'Moyenne | ' : ""; $table .= (!$rdv_filter || $rdv_filter == "rdv") ? 'RDV | ' : ""; $table .= (!$rdv_filter || $rdv_filter == "srdv") ? 'SRDV | ' : ""; $table .= $nfc_enabled ? "NFC | " : ""; $table .= 'DMA | DME | '; $table .= (!$rdv_filter || $rdv_filter == "rdv") ? ('DMA RDV | DME RDV | ') : ""; $table .= (!$rdv_filter || $rdv_filter == "srdv") ? ('DMA SRDV | DME SRDV | ') : ""; $table .= $motifs_enabled ? getMotifsHeaders($motifs) : ""; $table .= "||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
".$res["annee"]." | ") : ""; if($split_mode && $split_mode != "non_split"){ $res[$splitModeColumn] = formatSplitColumn($split_mode, $res[$splitModeColumn]); $line .= "".($res[$splitModeColumn])." | "; } if($hierarchical_mode){ foreach($hierarchicalModeColumns as $hierarchicalModeColumn){ $res[$hierarchicalModeColumn] = $res[$hierarchicalModeColumn]; $line .= "".$res[$hierarchicalModeColumn]." | "; } } $line .= "".$res["nbVisits"]." | "; if($time_split){ $avg = get_avg($res['nbVisits'],$startDate,$endDate,$split_mode,$res[$splitModeColumn]); $line .= "".$avg." | "; } $line .= (!$rdv_filter || $rdv_filter == "rdv") ? ("".$res["appointment"]." | ") : ""; $line .= (!$rdv_filter || $rdv_filter == "srdv") ? ("".$res["noAppointment"]." | ") : ""; $line .= ($nfc_enabled) ? ("".$res["nb_nfc"]." | ") : ""; $line .= "".gmdate('H:i:s',$res["avgWaiting"])." | ".gmdate('H:i:s',$res["avgMeeting"])." | "; $line .= (!$rdv_filter || $rdv_filter == "rdv") ? ("".gmdate('H:i:s',$res["appointmentAttente"])." | ".gmdate('H:i:s',$res["appointmentEntretien"])." | ") : ""; $line .= (!$rdv_filter || $rdv_filter == "srdv") ? ("".gmdate('H:i:s',$res["noAppointmentAttente"])." | ".gmdate('H:i:s',$res["noAppointmentEntretien"])." | ") : ""; $line .= ($motifs_enabled) ? getMotfisValues($motifs, $res) : ""; $line .= "