<?php
$GLOBALS['export_xls']['dossiers'] = array(
'cols' => array(
array(
'label' => 'Réf. dossier',
'width' => 15,
'value' => '"%ref_dossier%"',
'write_method' => 'write_string'
),
array(
'label' => 'Date d\'inscription du client',
'width' => 25,
'value' => 'format_date_to_excel("%dateInscription%")',
'format' => 'datetime'
),
array(
'label' => 'Inscription par',
'width' => 30,
'value' => 'utf8_decode (nettoyage_csv (p2e_sinon(trim("%createurNom%".\' \'."%createurPrenom%"), \'client\')))',
'write_method' => 'write_string'
),
array(
'label' => 'Date de création du dossier',
'width' => 25,
'value' => 'format_date_to_excel("%dateCrea%")',
'format' => 'datetime'
),
array(
'label' => 'Code de type de travaux (opération)',
'width' => 30,
'value' => 'utf8_decode (nettoyage_csv ("%code_operation_type%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Type de travaux (opération)',
'width' => 50,
'value' => 'utf8_decode (nettoyage_csv ("%lib_trav%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Date d\'engagement de l\'opération',
'width' => 26,
'value' => 'format_date_to_excel("%date_engagement%")',
'format' => 'date'
),
array(
'label' => 'Date d\'achèvement de l\'opération',
'width' => 26,
'value' => 'format_date_to_excel("%date_facture%")',
'format' => 'date'
),
array(
'label' => 'Date d\'expiration',
'width' => 20,
'value' => 'format_date_to_excel(filtre_get_date_expiration("%id_dossier%"))',
'format' => 'date'
),
array(
'label' => 'Réf. client',
'width' => 10,
'value' => '"%ref_client%"',
'write_method' => 'write_string'
),
array(
'label' => 'Civilité',
'width' => 10,
'value' => 'formater_nom(array(\'code_civilite\' => "%code_civilite%"),\'@s\')',
'write_method' => 'write_string'
),
array(
'label' => 'Nom',
'width' => 30,
'value' => 'utf8_decode (formater_nom(array(\'nom\' => "%nom%"),\'@N\'))',
'write_method' => 'write_string'
),
array(
'label' => 'Prénom',
'width' => 30,
'value' => 'utf8_decode (formater_nom(array(\'prenom\' => "%prenom%"),\'@p\'))',
'write_method' => 'write_string'
),
array(
'label' => 'Adresse client',
'width' => 50,
'value' => 'utf8_decode (nettoyage_csv ( trim( "%cli_adr0%" .\' \'. "%cli_adr1%" .\' \'. "%cli_adr2%" .\' \'. "%cli_adr3%")))',
'write_method' => 'write_string'
),
array(
'label' => 'CP client',
'width' => 10,
'value' => 'utf8_decode (nettoyage_csv ("%auteur_cp%"))',
'write_method' => 'write_number',
'format' => 'code_postal'
),
array(
'label' => 'Ville client',
'width' => 30,
'value' => 'utf8_decode (nettoyage_csv ("%auteur_ville%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Pays client',
'width' => 10,
'value' => 'utf8_decode (nettoyage_csv ("%auteur_code_pays%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Tél. Domicile',
'width' => 15,
'value' => '"%tel_fixe%"',
'format' => 'telephone'
),
array(
'label' => 'Tél. Mobile',
'width' => 15,
'value' => '"%tel_port%"',
'format' => 'telephone'
),
array(
'label' => 'Tél. Professionnel',
'width' => 15,
'value' => '"%tel_prof%"',
'format' => 'telephone'
),
array(
'label' => 'Email',
'width' => 40,
'value' => 'utf8_decode (nettoyage_csv ("%email%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Prime attribuable',
'width' => 20,
'value' => '"%prime_estimee%"',
'write_method' => 'write_number',
'format' => 'prime'
),
array(
'label' => 'Prime attribuée',
'width' => 20,
'value' => '"%prime_attribuee%"',
'write_method' => 'write_number',
'format' => 'prime'
),
array(
'label' => 'Kwatt',
'width' => 15,
'value' => '"%kwatt%"',
'write_method' => 'write_number'
),
array(
'label' => 'R',
'width' => 5,
'value' => 'utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%r%", "%code_operation_type%"))))',
'write_method' => 'write_string'
),
array(
'label' => 'COP',
'width' => 20,
'value' => 'utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_cop_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%", "%code_operation_type%"))))',
'write_method' => 'write_string'
),
array(
'label' => 'Surface (ou Quantité)',
'width' => 20,
'value' => 'utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (surface_ou_quantite_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%"))))',
'write_method' => 'write_string'
),
array(
'label' => 'Information supplémentaire',
'width' => 30,
'value' => 'utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_info_supp_chauff("%cop%", "%code_operation_type%"))))',
'write_method' => 'write_string'
),
array(
'label' => 'Surface habitable',
'width' => 20,
'value' => 'utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%surface_habitable%", "%code_operation_type%"))))',
'write_method' => 'write_string'
),
array(
'label' => 'Travaux année de construction',
'width' => 35,
'value' => 'utf8_decode( nettoyage_csv( _T(\'p2e_saisies:saisie_annee_construction_\'."%annee_construction%")))',
'write_method' => 'write_string'
),
array(
'label' => 'Travaux type logement',
'width' => 50,
'value' => 'utf8_decode( nettoyage_csv( _T(\'p2e_saisies:saisie_type_logement_\'."%type_logement%")))',
'write_method' => 'write_string'
),
array(
'label' => 'Travaux type chauffage',
'width' => 35,
'value' => 'utf8_decode( nettoyage_csv( _T(\'p2e_saisies:saisie_type_chauffage_\'."%type_chauffage%")))',
'write_method' => 'write_string'
),
array(
'label' => 'Statut dossier',
'width' => 40,
'value' => 'utf8_decode (nettoyage_csv ("%statut_dossier%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Date changement statut',
'width' => 20,
'value' => 'format_date_to_excel("%date%")',
'format' => 'datetime'
),
array(
'label' => 'Auteur changement statut',
'width' => 30,
'value' => 'utf8_decode (nettoyage_csv ("%auteurModifPrenom%" .\' \'. "%auteurModifNom%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Travaux adresse',
'width' => 50,
'value' => 'utf8_decode (nettoyage_csv ( trim( "%adr_lib1%" .\' \'. "%adr_lib2%" .\' \'. "%adr_lib3%" .\' \'. "%adr_lib4%")))',
'write_method' => 'write_string'
),
array(
'label' => 'Travaux CP',
'width' => 15,
'value' => 'utf8_decode (nettoyage_csv ("%adr_cp%"))',
'write_method' => 'write_number',
'format' => 'code_postal'
),
array(
'label' => 'Travaux Ville',
'width' => 30,
'value' => 'utf8_decode (nettoyage_csv ("%adr_ville%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Travaux Département',
'width' => 25,
'value' => '"%code_departement%"',
'write_method' => 'write_number',
'format' => 'departement'
),
array(
'label' => 'Travaux Pays',
'width' => 20,
'value' => 'utf8_decode (nettoyage_csv ("%code_pays%"))',
'write_method' => 'write_string'
),
array(
'label' => 'Lot emmy',
'width' => 20,
'value' => 'utf8_decode (nettoyage_csv ("%lib_lot%"))',
'write_method' => 'write_string'
),
)
);
$auteur_cp_index = array_search( array(
'label' => 'CP client',
'width' => 10,
'value' => 'utf8_decode (nettoyage_csv ("%auteur_cp%"))',
'write_method' => 'write_number',
'format' => 'code_postal'
), $GLOBALS['export_xls']['dossiers']['cols']);
$GLOBALS['export_xls']['dossiers']['cols'] =
array_replace($GLOBALS['export_xls']['dossiers']['cols'], array(
$auteur_index_cp =>
array(
'label' => 'CP client',
'width' => 10,
'value' => 'utf8_decode (nettoyage_csv ("%auteur_cp%"))',
'write_method' => 'write_string',
'format' => 'code_postal'
)
));
var_dump($GLOBALS['export_xls']['dossiers']['cols']);
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename: /in/lGhOR
function name: (null)
number of ops: 35
compiled vars: !0 = $auteur_cp_index, !1 = $auteur_index_cp
line #* E I O op fetch ext return operands
-------------------------------------------------------------------------------------
3 0 E > FETCH_W global $2 'GLOBALS'
1 FETCH_DIM_W $3 $2, 'export_xls'
2 ASSIGN_DIM $3, 'dossiers'
6 3 OP_DATA <array>
259 4 INIT_FCALL 'array_search'
260 5 SEND_VAL <array>
265 6 FETCH_R global ~5 'GLOBALS'
7 FETCH_DIM_R ~6 ~5, 'export_xls'
8 FETCH_DIM_R ~7 ~6, 'dossiers'
9 FETCH_DIM_R ~8 ~7, 'cols'
10 SEND_VAL ~8
11 DO_ICALL $9
259 12 ASSIGN !0, $9
268 13 INIT_FCALL 'array_replace'
14 FETCH_R global ~15 'GLOBALS'
15 FETCH_DIM_R ~16 ~15, 'export_xls'
16 FETCH_DIM_R ~17 ~16, 'dossiers'
17 FETCH_DIM_R ~18 ~17, 'cols'
18 SEND_VAL ~18
273 19 INIT_ARRAY ~19 <array>, !1
20 SEND_VAL ~19
21 DO_ICALL $20
267 22 FETCH_W global $11 'GLOBALS'
23 FETCH_DIM_W $12 $11, 'export_xls'
24 FETCH_DIM_W $13 $12, 'dossiers'
25 ASSIGN_DIM $13, 'cols'
273 26 OP_DATA $20
282 27 INIT_FCALL 'var_dump'
28 FETCH_R global ~21 'GLOBALS'
29 FETCH_DIM_R ~22 ~21, 'export_xls'
30 FETCH_DIM_R ~23 ~22, 'dossiers'
31 FETCH_DIM_R ~24 ~23, 'cols'
32 SEND_VAL ~24
33 DO_ICALL
34 > RETURN 1
Generated using Vulcan Logic Dumper, using php 8.0.0
preferences:
193.21 ms | 1396 KiB | 19 Q