$value) { $normalizedLabel = $normalizeImportKey((string)$label); if ($normalizedLabel === '' || $value === null || trim((string)$value) === '') { continue; } if ($normalizedLabel === $normalizedCandidate || str_contains($normalizedLabel, $normalizedCandidate)) { return trim((string)$value); } } } return ''; }; $normalizeDateInputValue = static function ($rawValue): string { $rawValue = trim((string)$rawValue); if ($rawValue === '') { return ''; } if (preg_match('/^\d+(?:[\.,]\d+)?$/', $rawValue)) { $normalizedNumber = (float) str_replace(',', '.', $rawValue); if ($normalizedNumber >= 20000 && $normalizedNumber <= 70000) { $days = (int) floor($normalizedNumber); $seconds = (int) round(($normalizedNumber - $days) * 86400); $baseDate = new \DateTimeImmutable('1899-12-30 00:00:00'); $formattedDate = $baseDate->modify('+' . $days . ' days'); if ($formattedDate !== false) { if ($seconds > 0) { $formattedDate = $formattedDate->modify('+' . $seconds . ' seconds'); } return $formattedDate->format('Y-m-d'); } } } foreach (['Y-m-d', 'd/m/Y', 'd-m-Y', 'd.m.Y'] as $format) { $date = \DateTimeImmutable::createFromFormat($format, $rawValue); if ($date instanceof \DateTimeImmutable) { return $date->format('Y-m-d'); } } $timestamp = strtotime($rawValue); return $timestamp !== false ? date('Y-m-d', $timestamp) : ''; }; $buildRaccordementEditPayload = static function (array $ticket) use ($decodeExtraFields, $findImportedField, $normalizeDateInputValue): array { $extraFields = $decodeExtraFields($ticket['extra_fields'] ?? null); $selectedBoxPlaque = trim((string)($ticket['selected_box_plaque'] ?? '')); $selectedBoxJdv = trim((string)($ticket['selected_box_hub'] ?? '')); $selectedBoxPco = trim((string)(($ticket['selected_box_code'] ?? '') ?: ($ticket['selected_otb_label'] ?? ''))); $ticketId = (int)($ticket['ticket_id'] ?? $ticket['id'] ?? 0); return [ 'id' => $ticketId, 'ref_code' => (string)($ticket['ref_code'] ?? ''), 'client_code' => (string)(($ticket['client_code'] ?? '') ?: $findImportedField($extraFields, ['NumeroAbonnement', 'Numéro Abonnement'])), 'client_name' => (string)(($ticket['client_name'] ?? '') ?: $findImportedField($extraFields, ['NomClient'])), 'client_phone' => (string)(($ticket['client_phone'] ?? '') ?: $findImportedField($extraFields, ['Contact1'])), 'client_phone2' => (string)(($ticket['client_phone2'] ?? '') ?: $findImportedField($extraFields, ['Contact2'])), 'client_address' => (string)(($ticket['client_address'] ?? '') ?: $findImportedField($extraFields, ['Localisation'])), 'raccordement_city' => $findImportedField($extraFields, ['Ville']), 'raccordement_commune' => $findImportedField($extraFields, ['Commune']), 'raccordement_latitude' => (string)(($ticket['client_lat'] ?? '') ?: $findImportedField($extraFields, ['Latitude_Terrai'])), 'raccordement_longitude' => (string)(($ticket['client_lng'] ?? '') ?: $findImportedField($extraFields, ['Longitude_Terrain'])), 'sro_client' => (string)($selectedBoxPlaque !== '' ? $selectedBoxPlaque : (($ticket['sro_client'] ?? '') ?: $findImportedField($extraFields, ['PLAQUE']))), 'jdv_client' => (string)($selectedBoxJdv !== '' ? $selectedBoxJdv : (($ticket['jdv_client'] ?? '') ?: $findImportedField($extraFields, ['JDV']))), 'pco_client' => (string)($selectedBoxPco !== '' ? $selectedBoxPco : (($ticket['pco_client'] ?? '') ?: $findImportedField($extraFields, ['PCO']))), 'company_name' => (string)(($ticket['company_name'] ?? '') ?: $findImportedField($extraFields, ['EntrepriseFTTH', 'Entreprise'])), 'raccordement_snont' => $findImportedField($extraFields, ['SNONT']), 'raccordement_nd' => $findImportedField($extraFields, ['ND']), 'raccordement_date_enregistrement' => $normalizeDateInputValue($findImportedField($extraFields, ['Date_Enregistrement_Instances'])), 'raccordement_date_envoi_prestataires' => $normalizeDateInputValue($findImportedField($extraFields, ['Date_Envoi_Instances_Prestataires'])), 'raccordement_duree_attente' => $findImportedField($extraFields, ['Duree_attente_j']), 'raccordement_team' => $findImportedField($extraFields, ['Equipe_raccordement']), 'raccordement_etude_technique' => $findImportedField($extraFields, ['Etude_Technique']), 'avancement' => (string)(($ticket['avancement'] ?? '') ?: $findImportedField($extraFields, ['Avancement'])), 'priority' => (string)($ticket['priority'] ?? 'Moyenne'), 'status' => (string)($ticket['status'] ?? 'nouveau'), 'description' => (string)(($ticket['description'] ?? '') ?: $findImportedField($extraFields, ['Commentaires'])), 'cause_comment' => (string)(($ticket['cause_comment'] ?? '') ?: $findImportedField($extraFields, ['Problèmes', 'Problemes'])), ]; }; $queryBase = array_filter([ 'q' => $search ?? '', 'status' => $status ?? '', 'sro' => $sro ?? '', 'company' => $company ?? '', 'progress' => $progress ?? '', 'source' => $source ?? '', ], static fn($value) => $value !== null && $value !== ''); $queryString = !empty($queryBase) ? '?' . http_build_query($queryBase) : ''; $exportUrl = route_url($moduleBasePath . '/export' . $queryString); $exportPdfUrl = route_url($moduleBasePath . '/export-pdf' . $queryString); $activeFilterCount = count($queryBase); $openTicketCount = (int)(($stats['nouveau'] ?? 0) + ($stats['assigné'] ?? 0) + ($stats['en_cours'] ?? 0)); $activeAssignedCity = trim((string)($cu['assigned_city'] ?? '')); ?>

Exporter la liste Exporter PDF
tickets dans le portefeuille
tickets encore ouverts
rapports validés
filtre 1 ? 's' : '' ?> actif 1 ? 's' : '' ?>
ticket(s) importé(s) 0 ? ', ' . (int)$_GET['skipped'] . ' ignoré(s)' : '' ?> 0 ? ' dont ' . (int)$_GET['resolved_skipped'] . ' ligne(s) au statut RESOLU' : '' ?>.
Ce contenu correspond a un fichier deja importe' . htmlspecialchars(date('d/m/Y H:i', $duplicateAt)) . '' : '' ?> sous le nom 1 ? ' (' . $duplicateCount . ' import(s) anterieurs)' : '' ?>.
Ticket supprimé.
ticket(s) supprimé(s) depuis la sélection.
Déclaration créée avec succès.
Raccordement mis à jour avec succès.
Criticité requalifiée avec succès.
Ticket assigné et notifications envoyées.
Assignation retirée avec succès.
Assignation rapide exécutée sur ticket(s).
Ville de rattachement active: Seuls les tickets correspondant à cette ville sont affichés dans la liste, les exports et les actions associées.
['label'=>'Nouveaux', 'icon'=>'fas fa-inbox', 'color'=>'primary'], 'assigné' => ['label'=>'Assignés', 'icon'=>'fas fa-user-check', 'color'=>'warning'], 'en_cours' => ['label'=>'En cours', 'icon'=>'fas fa-spinner', 'color'=>'info'], 'traité' => ['label'=>'Traités', 'icon'=>'fas fa-tools', 'color'=>'success'], 'validé' => ['label'=>'Validés', 'icon'=>'fas fa-check-double', 'color'=>'success'], 'clôturé' => ['label'=>'Clôturés', 'icon'=>'fas fa-archive', 'color'=>'secondary'], ]; foreach ($statConf as $key => $conf): $cnt = $stats[$key] ?? 0; ?>
Filtres opérationnels

Isolez rapidement les tickets par état, zone réseau, entreprise ou avancement terrain.

filtre 1 ? 's' : '' ?> actif 1 ? 's' : '' ?>
Exporter CSV Exporter PDF

ticket 1 ? 's' : '' ?>

Aucun ticket trouvé.

'danger','Haute'=>'warning','Moyenne'=>'primary','Basse'=>'secondary'][$tk['priority']] ?? 'secondary'; $stColor = ['nouveau'=>'primary','assigné'=>'warning','en_cours'=>'info','traité'=>'success','validé'=>'success','clôturé'=>'secondary'][$tk['status']] ?? 'secondary'; $assignmentLocked = in_array((string)($tk['status'] ?? ''), ['validé', 'clôturé'], true); $sourceLabel = (($tk['source_channel'] ?? '') === 'e-intervention') ? 'e-Intervention' : 'Opérateur direct'; $sourceIcon = (($tk['source_channel'] ?? '') === 'e-intervention') ? 'fa-mobile-screen-button' : 'fa-headset'; $extraFields = $decodeExtraFields($tk['extra_fields'] ?? null); $raccordementName = $tk['client_name'] ?: $findImportedField($extraFields, ['NomClient']); $raccordementSubscription = $tk['client_code'] ?: $findImportedField($extraFields, ['NumeroAbonnement', 'Numéro Abonnement']); $raccordementAddress = $tk['client_address'] ?: $findImportedField($extraFields, ['Localisation']); $raccordementContact1 = $tk['client_phone'] ?: $findImportedField($extraFields, ['Contact1']); $raccordementContact2 = $tk['client_phone2'] ?: $findImportedField($extraFields, ['Contact2']); $raccordementCity = $findImportedField($extraFields, ['Ville']); $raccordementCommune = $findImportedField($extraFields, ['Commune']); $raccordementPlaque = $findImportedField($extraFields, ['PLAQUE']); $selectedBoxPlaque = trim((string)($tk['selected_box_plaque'] ?? '')); $selectedBoxJdv = trim((string)($tk['selected_box_hub'] ?? '')); $selectedBoxPco = trim((string)(($tk['selected_box_code'] ?? '') ?: ($tk['selected_otb_label'] ?? ''))); $displayPlaque = $selectedBoxPlaque !== '' ? $selectedBoxPlaque : ($raccordementPlaque ?: (string)($tk['sro_client'] ?? '')); $displayJdv = $selectedBoxJdv !== '' ? $selectedBoxJdv : trim((string)($tk['jdv_client'] ?? '')); $displayPco = $selectedBoxPco !== '' ? $selectedBoxPco : trim((string)($tk['pco_client'] ?? '')); $raccordementSnont = $findImportedField($extraFields, ['SNONT']); $raccordementNd = $findImportedField($extraFields, ['ND']); $raccordementCompany = $tk['company_name'] ?: $findImportedField($extraFields, ['EntrepriseFTTH', 'Entreprise']); $raccordementProgress = $tk['avancement'] ?: $findImportedField($extraFields, ['Avancement']); $networkRefs = array_values(array_filter([ !empty($isRaccordementClients ? $displayPlaque : $tk['sro_client']) ? ($isRaccordementClients ? 'PLAQUE ' . $displayPlaque : 'SRO ' . $tk['sro_client']) : null, !empty($isRaccordementClients ? $displayJdv : $tk['jdv_client']) ? 'JDV ' . ($isRaccordementClients ? $displayJdv : $tk['jdv_client']) : null, !empty($isRaccordementClients ? $displayPco : $tk['pco_client']) ? 'PCO ' . ($isRaccordementClients ? $displayPco : $tk['pco_client']) : null, ])); $networkPath = implode(' => ', $networkRefs); $lastReportSavedAt = !empty($tk['report_updated_at']) ? date('d/m/Y à H:i', strtotime((string)$tk['report_updated_at'])) : ''; ?>
Abonnement
Ligne fixe
,
Origine
Avancement
Cause Renseignée
Affecté à
Affectation Non affecté
Aucun repère réseau renseigné.
Dernier enregistrement du formulaire :
Détail
0 sélectionné(s) Sélectionnez plusieurs tickets pour lancer rapidement une assignation, une suppression ou une édition de rapport imprimable.
'danger','Haute'=>'warning','Moyenne'=>'primary','Basse'=>'secondary'][$tk['priority']] ?? 'secondary'; $stColor = ['nouveau'=>'primary','assigné'=>'warning','en_cours'=>'info','attente_planification'=>'dark','traité'=>'success','validé'=>'success','clôturé'=>'secondary'][$tk['status']] ?? 'secondary'; $assignmentLocked = in_array((string)($tk['status'] ?? ''), ['validé', 'clôturé'], true); $sourceLabel = (($tk['source_channel'] ?? '') === 'e-intervention') ? 'e-Intervention' : 'Opérateur direct'; $sourceIcon = (($tk['source_channel'] ?? '') === 'e-intervention') ? 'fa-mobile-screen-button' : 'fa-headset'; $extraFields = $decodeExtraFields($tk['extra_fields'] ?? null); $raccordementName = $tk['client_name'] ?: $findImportedField($extraFields, ['NomClient']); $raccordementSubscription = $tk['client_code'] ?: $findImportedField($extraFields, ['NumeroAbonnement', 'Numéro Abonnement']); $raccordementAddress = $tk['client_address'] ?: $findImportedField($extraFields, ['Localisation']); $raccordementContact1 = $tk['client_phone'] ?: $findImportedField($extraFields, ['Contact1']); $raccordementContact2 = $tk['client_phone2'] ?: $findImportedField($extraFields, ['Contact2']); $raccordementCity = $findImportedField($extraFields, ['Ville']); $raccordementCommune = $findImportedField($extraFields, ['Commune']); $raccordementPlaque = $findImportedField($extraFields, ['PLAQUE']); $selectedBoxPlaque = trim((string)($tk['selected_box_plaque'] ?? '')); $selectedBoxJdv = trim((string)($tk['selected_box_hub'] ?? '')); $selectedBoxPco = trim((string)(($tk['selected_box_code'] ?? '') ?: ($tk['selected_otb_label'] ?? ''))); $displayPlaque = $selectedBoxPlaque !== '' ? $selectedBoxPlaque : ($raccordementPlaque ?: (string)($tk['sro_client'] ?? '')); $displayJdv = $selectedBoxJdv !== '' ? $selectedBoxJdv : trim((string)($tk['jdv_client'] ?? '')); $displayPco = $selectedBoxPco !== '' ? $selectedBoxPco : trim((string)($tk['pco_client'] ?? '')); $raccordementSnont = $findImportedField($extraFields, ['SNONT']); $raccordementNd = $findImportedField($extraFields, ['ND']); $raccordementCompany = $tk['company_name'] ?: $findImportedField($extraFields, ['EntrepriseFTTH', 'Entreprise']); $raccordementProgress = $tk['avancement'] ?: $findImportedField($extraFields, ['Avancement']); $networkRefs = array_values(array_filter([ !empty($isRaccordementClients ? $displayPlaque : $tk['sro_client']) ? ($isRaccordementClients ? 'PLAQUE ' . $displayPlaque : 'SRO ' . $tk['sro_client']) : null, !empty($isRaccordementClients ? $displayJdv : $tk['jdv_client']) ? 'JDV ' . ($isRaccordementClients ? $displayJdv : $tk['jdv_client']) : null, !empty($isRaccordementClients ? $displayPco : $tk['pco_client']) ? 'PCO ' . ($isRaccordementClients ? $displayPco : $tk['pco_client']) : null, ])); $networkPath = implode(' => ', $networkRefs); $rpSt = $tk['report_status'] ?? null; $visitStatus = $tk['client_visit_status'] ?? null; $visitMap = ['intervention_effectuee'=>['success','Intervention réalisée'],'client_indisponible'=>['warning','Client indisponible'],'reprogrammation_demandee'=>['info','Reprogrammation demandée']]; $plannedSlot = ''; if (!empty($tk['planned_intervention_date'])) { $plannedSlot = date('d/m/Y', strtotime((string)$tk['planned_intervention_date'])); if (!empty($tk['planned_intervention_time'])) { $plannedSlot .= ' à ' . substr((string)$tk['planned_intervention_time'], 0, 5); } } $lastReportSavedAt = !empty($tk['report_updated_at']) ? date('d/m/Y à H:i', strtotime((string)$tk['report_updated_at'])) : ''; $rpMap = ['brouillon'=>['secondary','Brouillon'],'soumis'=>['warning','En attente'],'validé'=>['success','Validé'],'rejeté'=>['danger','Rejeté']]; ?>
État Affectation Actions
Abonnement Ligne fixe
Téléphones , Origine Entreprise
Aucun repère réseau renseigné
Avancement Cause Renseignée
Rapport Rapport non démarré
Importé
Non affecté
Détail
1): ?>