<?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']);
- Output for 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- Warning: Undefined variable $auteur_index_cp in /in/lGhOR on line 273
array(42) {
[0]=>
array(4) {
["label"]=>
string(13) "Réf. dossier"
["width"]=>
int(15)
["value"]=>
string(15) ""%ref_dossier%""
["write_method"]=>
string(12) "write_string"
}
[1]=>
array(4) {
["label"]=>
string(28) "Date d'inscription du client"
["width"]=>
int(25)
["value"]=>
string(41) "format_date_to_excel("%dateInscription%")"
["format"]=>
string(8) "datetime"
}
[2]=>
array(4) {
["label"]=>
string(15) "Inscription par"
["width"]=>
int(30)
["value"]=>
string(95) "utf8_decode (nettoyage_csv (p2e_sinon(trim("%createurNom%".' '."%createurPrenom%"), 'client')))"
["write_method"]=>
string(12) "write_string"
}
[3]=>
array(4) {
["label"]=>
string(28) "Date de création du dossier"
["width"]=>
int(25)
["value"]=>
string(34) "format_date_to_excel("%dateCrea%")"
["format"]=>
string(8) "datetime"
}
[4]=>
array(4) {
["label"]=>
string(36) "Code de type de travaux (opération)"
["width"]=>
int(30)
["value"]=>
string(53) "utf8_decode (nettoyage_csv ("%code_operation_type%"))"
["write_method"]=>
string(12) "write_string"
}
[5]=>
array(4) {
["label"]=>
string(28) "Type de travaux (opération)"
["width"]=>
int(50)
["value"]=>
string(42) "utf8_decode (nettoyage_csv ("%lib_trav%"))"
["write_method"]=>
string(12) "write_string"
}
[6]=>
array(4) {
["label"]=>
string(33) "Date d'engagement de l'opération"
["width"]=>
int(26)
["value"]=>
string(41) "format_date_to_excel("%date_engagement%")"
["format"]=>
string(4) "date"
}
[7]=>
array(4) {
["label"]=>
string(34) "Date d'achèvement de l'opération"
["width"]=>
int(26)
["value"]=>
string(38) "format_date_to_excel("%date_facture%")"
["format"]=>
string(4) "date"
}
[8]=>
array(4) {
["label"]=>
string(17) "Date d'expiration"
["width"]=>
int(20)
["value"]=>
string(64) "format_date_to_excel(filtre_get_date_expiration("%id_dossier%"))"
["format"]=>
string(4) "date"
}
[9]=>
array(4) {
["label"]=>
string(12) "Réf. client"
["width"]=>
int(10)
["value"]=>
string(14) ""%ref_client%""
["write_method"]=>
string(12) "write_string"
}
[10]=>
array(4) {
["label"]=>
string(9) "Civilité"
["width"]=>
int(10)
["value"]=>
string(62) "formater_nom(array('code_civilite' => "%code_civilite%"),'@s')"
["write_method"]=>
string(12) "write_string"
}
[11]=>
array(4) {
["label"]=>
string(3) "Nom"
["width"]=>
int(30)
["value"]=>
string(56) "utf8_decode (formater_nom(array('nom' => "%nom%"),'@N'))"
["write_method"]=>
string(12) "write_string"
}
[12]=>
array(4) {
["label"]=>
string(7) "Prénom"
["width"]=>
int(30)
["value"]=>
string(62) "utf8_decode (formater_nom(array('prenom' => "%prenom%"),'@p'))"
["write_method"]=>
string(12) "write_string"
}
[13]=>
array(4) {
["label"]=>
string(14) "Adresse client"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%cli_adr0%" .' '. "%cli_adr1%" .' '. "%cli_adr2%" .' '. "%cli_adr3%")))"
["write_method"]=>
string(12) "write_string"
}
[14]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[15]=>
array(4) {
["label"]=>
string(12) "Ville client"
["width"]=>
int(30)
["value"]=>
string(46) "utf8_decode (nettoyage_csv ("%auteur_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[16]=>
array(4) {
["label"]=>
string(11) "Pays client"
["width"]=>
int(10)
["value"]=>
string(50) "utf8_decode (nettoyage_csv ("%auteur_code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[17]=>
array(4) {
["label"]=>
string(14) "Tél. Domicile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_fixe%""
["format"]=>
string(9) "telephone"
}
[18]=>
array(4) {
["label"]=>
string(12) "Tél. Mobile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_port%""
["format"]=>
string(9) "telephone"
}
[19]=>
array(4) {
["label"]=>
string(19) "Tél. Professionnel"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_prof%""
["format"]=>
string(9) "telephone"
}
[20]=>
array(4) {
["label"]=>
string(5) "Email"
["width"]=>
int(40)
["value"]=>
string(39) "utf8_decode (nettoyage_csv ("%email%"))"
["write_method"]=>
string(12) "write_string"
}
[21]=>
array(5) {
["label"]=>
string(17) "Prime attribuable"
["width"]=>
int(20)
["value"]=>
string(17) ""%prime_estimee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[22]=>
array(5) {
["label"]=>
string(16) "Prime attribuée"
["width"]=>
int(20)
["value"]=>
string(19) ""%prime_attribuee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[23]=>
array(4) {
["label"]=>
string(5) "Kwatt"
["width"]=>
int(15)
["value"]=>
string(9) ""%kwatt%""
["write_method"]=>
string(12) "write_number"
}
[24]=>
array(4) {
["label"]=>
string(1) "R"
["width"]=>
int(5)
["value"]=>
string(121) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%r%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[25]=>
array(4) {
["label"]=>
string(3) "COP"
["width"]=>
int(20)
["value"]=>
string(153) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_cop_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[26]=>
array(4) {
["label"]=>
string(22) "Surface (ou Quantité)"
["width"]=>
int(20)
["value"]=>
string(134) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (surface_ou_quantite_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%"))))"
["write_method"]=>
string(12) "write_string"
}
[27]=>
array(4) {
["label"]=>
string(27) "Information supplémentaire"
["width"]=>
int(30)
["value"]=>
string(122) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_info_supp_chauff("%cop%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[28]=>
array(4) {
["label"]=>
string(17) "Surface habitable"
["width"]=>
int(20)
["value"]=>
string(137) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%surface_habitable%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[29]=>
array(4) {
["label"]=>
string(30) "Travaux année de construction"
["width"]=>
int(35)
["value"]=>
string(97) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_annee_construction_'."%annee_construction%")))"
["write_method"]=>
string(12) "write_string"
}
[30]=>
array(4) {
["label"]=>
string(21) "Travaux type logement"
["width"]=>
int(50)
["value"]=>
string(87) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_logement_'."%type_logement%")))"
["write_method"]=>
string(12) "write_string"
}
[31]=>
array(4) {
["label"]=>
string(22) "Travaux type chauffage"
["width"]=>
int(35)
["value"]=>
string(89) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_chauffage_'."%type_chauffage%")))"
["write_method"]=>
string(12) "write_string"
}
[32]=>
array(4) {
["label"]=>
string(14) "Statut dossier"
["width"]=>
int(40)
["value"]=>
string(48) "utf8_decode (nettoyage_csv ("%statut_dossier%"))"
["write_method"]=>
string(12) "write_string"
}
[33]=>
array(4) {
["label"]=>
string(22) "Date changement statut"
["width"]=>
int(20)
["value"]=>
string(30) "format_date_to_excel("%date%")"
["format"]=>
string(8) "datetime"
}
[34]=>
array(4) {
["label"]=>
string(24) "Auteur changement statut"
["width"]=>
int(30)
["value"]=>
string(76) "utf8_decode (nettoyage_csv ("%auteurModifPrenom%" .' '. "%auteurModifNom%"))"
["write_method"]=>
string(12) "write_string"
}
[35]=>
array(4) {
["label"]=>
string(15) "Travaux adresse"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%adr_lib1%" .' '. "%adr_lib2%" .' '. "%adr_lib3%" .' '. "%adr_lib4%")))"
["write_method"]=>
string(12) "write_string"
}
[36]=>
array(5) {
["label"]=>
string(10) "Travaux CP"
["width"]=>
int(15)
["value"]=>
string(40) "utf8_decode (nettoyage_csv ("%adr_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[37]=>
array(4) {
["label"]=>
string(13) "Travaux Ville"
["width"]=>
int(30)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%adr_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[38]=>
array(5) {
["label"]=>
string(20) "Travaux Département"
["width"]=>
int(25)
["value"]=>
string(20) ""%code_departement%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "departement"
}
[39]=>
array(4) {
["label"]=>
string(12) "Travaux Pays"
["width"]=>
int(20)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[40]=>
array(4) {
["label"]=>
string(8) "Lot emmy"
["width"]=>
int(20)
["value"]=>
string(41) "utf8_decode (nettoyage_csv ("%lib_lot%"))"
["write_method"]=>
string(12) "write_string"
}
[""]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_string"
["format"]=>
string(11) "code_postal"
}
}
- Output for 7.3.16 - 7.3.31, 7.4.0 - 7.4.33
- Notice: Undefined variable: auteur_index_cp in /in/lGhOR on line 273
array(42) {
[0]=>
array(4) {
["label"]=>
string(13) "Réf. dossier"
["width"]=>
int(15)
["value"]=>
string(15) ""%ref_dossier%""
["write_method"]=>
string(12) "write_string"
}
[1]=>
array(4) {
["label"]=>
string(28) "Date d'inscription du client"
["width"]=>
int(25)
["value"]=>
string(41) "format_date_to_excel("%dateInscription%")"
["format"]=>
string(8) "datetime"
}
[2]=>
array(4) {
["label"]=>
string(15) "Inscription par"
["width"]=>
int(30)
["value"]=>
string(95) "utf8_decode (nettoyage_csv (p2e_sinon(trim("%createurNom%".' '."%createurPrenom%"), 'client')))"
["write_method"]=>
string(12) "write_string"
}
[3]=>
array(4) {
["label"]=>
string(28) "Date de création du dossier"
["width"]=>
int(25)
["value"]=>
string(34) "format_date_to_excel("%dateCrea%")"
["format"]=>
string(8) "datetime"
}
[4]=>
array(4) {
["label"]=>
string(36) "Code de type de travaux (opération)"
["width"]=>
int(30)
["value"]=>
string(53) "utf8_decode (nettoyage_csv ("%code_operation_type%"))"
["write_method"]=>
string(12) "write_string"
}
[5]=>
array(4) {
["label"]=>
string(28) "Type de travaux (opération)"
["width"]=>
int(50)
["value"]=>
string(42) "utf8_decode (nettoyage_csv ("%lib_trav%"))"
["write_method"]=>
string(12) "write_string"
}
[6]=>
array(4) {
["label"]=>
string(33) "Date d'engagement de l'opération"
["width"]=>
int(26)
["value"]=>
string(41) "format_date_to_excel("%date_engagement%")"
["format"]=>
string(4) "date"
}
[7]=>
array(4) {
["label"]=>
string(34) "Date d'achèvement de l'opération"
["width"]=>
int(26)
["value"]=>
string(38) "format_date_to_excel("%date_facture%")"
["format"]=>
string(4) "date"
}
[8]=>
array(4) {
["label"]=>
string(17) "Date d'expiration"
["width"]=>
int(20)
["value"]=>
string(64) "format_date_to_excel(filtre_get_date_expiration("%id_dossier%"))"
["format"]=>
string(4) "date"
}
[9]=>
array(4) {
["label"]=>
string(12) "Réf. client"
["width"]=>
int(10)
["value"]=>
string(14) ""%ref_client%""
["write_method"]=>
string(12) "write_string"
}
[10]=>
array(4) {
["label"]=>
string(9) "Civilité"
["width"]=>
int(10)
["value"]=>
string(62) "formater_nom(array('code_civilite' => "%code_civilite%"),'@s')"
["write_method"]=>
string(12) "write_string"
}
[11]=>
array(4) {
["label"]=>
string(3) "Nom"
["width"]=>
int(30)
["value"]=>
string(56) "utf8_decode (formater_nom(array('nom' => "%nom%"),'@N'))"
["write_method"]=>
string(12) "write_string"
}
[12]=>
array(4) {
["label"]=>
string(7) "Prénom"
["width"]=>
int(30)
["value"]=>
string(62) "utf8_decode (formater_nom(array('prenom' => "%prenom%"),'@p'))"
["write_method"]=>
string(12) "write_string"
}
[13]=>
array(4) {
["label"]=>
string(14) "Adresse client"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%cli_adr0%" .' '. "%cli_adr1%" .' '. "%cli_adr2%" .' '. "%cli_adr3%")))"
["write_method"]=>
string(12) "write_string"
}
[14]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[15]=>
array(4) {
["label"]=>
string(12) "Ville client"
["width"]=>
int(30)
["value"]=>
string(46) "utf8_decode (nettoyage_csv ("%auteur_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[16]=>
array(4) {
["label"]=>
string(11) "Pays client"
["width"]=>
int(10)
["value"]=>
string(50) "utf8_decode (nettoyage_csv ("%auteur_code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[17]=>
array(4) {
["label"]=>
string(14) "Tél. Domicile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_fixe%""
["format"]=>
string(9) "telephone"
}
[18]=>
array(4) {
["label"]=>
string(12) "Tél. Mobile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_port%""
["format"]=>
string(9) "telephone"
}
[19]=>
array(4) {
["label"]=>
string(19) "Tél. Professionnel"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_prof%""
["format"]=>
string(9) "telephone"
}
[20]=>
array(4) {
["label"]=>
string(5) "Email"
["width"]=>
int(40)
["value"]=>
string(39) "utf8_decode (nettoyage_csv ("%email%"))"
["write_method"]=>
string(12) "write_string"
}
[21]=>
array(5) {
["label"]=>
string(17) "Prime attribuable"
["width"]=>
int(20)
["value"]=>
string(17) ""%prime_estimee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[22]=>
array(5) {
["label"]=>
string(16) "Prime attribuée"
["width"]=>
int(20)
["value"]=>
string(19) ""%prime_attribuee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[23]=>
array(4) {
["label"]=>
string(5) "Kwatt"
["width"]=>
int(15)
["value"]=>
string(9) ""%kwatt%""
["write_method"]=>
string(12) "write_number"
}
[24]=>
array(4) {
["label"]=>
string(1) "R"
["width"]=>
int(5)
["value"]=>
string(121) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%r%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[25]=>
array(4) {
["label"]=>
string(3) "COP"
["width"]=>
int(20)
["value"]=>
string(153) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_cop_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[26]=>
array(4) {
["label"]=>
string(22) "Surface (ou Quantité)"
["width"]=>
int(20)
["value"]=>
string(134) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (surface_ou_quantite_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%"))))"
["write_method"]=>
string(12) "write_string"
}
[27]=>
array(4) {
["label"]=>
string(27) "Information supplémentaire"
["width"]=>
int(30)
["value"]=>
string(122) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_info_supp_chauff("%cop%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[28]=>
array(4) {
["label"]=>
string(17) "Surface habitable"
["width"]=>
int(20)
["value"]=>
string(137) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%surface_habitable%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[29]=>
array(4) {
["label"]=>
string(30) "Travaux année de construction"
["width"]=>
int(35)
["value"]=>
string(97) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_annee_construction_'."%annee_construction%")))"
["write_method"]=>
string(12) "write_string"
}
[30]=>
array(4) {
["label"]=>
string(21) "Travaux type logement"
["width"]=>
int(50)
["value"]=>
string(87) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_logement_'."%type_logement%")))"
["write_method"]=>
string(12) "write_string"
}
[31]=>
array(4) {
["label"]=>
string(22) "Travaux type chauffage"
["width"]=>
int(35)
["value"]=>
string(89) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_chauffage_'."%type_chauffage%")))"
["write_method"]=>
string(12) "write_string"
}
[32]=>
array(4) {
["label"]=>
string(14) "Statut dossier"
["width"]=>
int(40)
["value"]=>
string(48) "utf8_decode (nettoyage_csv ("%statut_dossier%"))"
["write_method"]=>
string(12) "write_string"
}
[33]=>
array(4) {
["label"]=>
string(22) "Date changement statut"
["width"]=>
int(20)
["value"]=>
string(30) "format_date_to_excel("%date%")"
["format"]=>
string(8) "datetime"
}
[34]=>
array(4) {
["label"]=>
string(24) "Auteur changement statut"
["width"]=>
int(30)
["value"]=>
string(76) "utf8_decode (nettoyage_csv ("%auteurModifPrenom%" .' '. "%auteurModifNom%"))"
["write_method"]=>
string(12) "write_string"
}
[35]=>
array(4) {
["label"]=>
string(15) "Travaux adresse"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%adr_lib1%" .' '. "%adr_lib2%" .' '. "%adr_lib3%" .' '. "%adr_lib4%")))"
["write_method"]=>
string(12) "write_string"
}
[36]=>
array(5) {
["label"]=>
string(10) "Travaux CP"
["width"]=>
int(15)
["value"]=>
string(40) "utf8_decode (nettoyage_csv ("%adr_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[37]=>
array(4) {
["label"]=>
string(13) "Travaux Ville"
["width"]=>
int(30)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%adr_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[38]=>
array(5) {
["label"]=>
string(20) "Travaux Département"
["width"]=>
int(25)
["value"]=>
string(20) ""%code_departement%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "departement"
}
[39]=>
array(4) {
["label"]=>
string(12) "Travaux Pays"
["width"]=>
int(20)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[40]=>
array(4) {
["label"]=>
string(8) "Lot emmy"
["width"]=>
int(20)
["value"]=>
string(41) "utf8_decode (nettoyage_csv ("%lib_lot%"))"
["write_method"]=>
string(12) "write_string"
}
[""]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_string"
["format"]=>
string(11) "code_postal"
}
}
- Output for 7.3.32 - 7.3.33
- array(42) {
[0]=>
array(4) {
["label"]=>
string(13) "Réf. dossier"
["width"]=>
int(15)
["value"]=>
string(15) ""%ref_dossier%""
["write_method"]=>
string(12) "write_string"
}
[1]=>
array(4) {
["label"]=>
string(28) "Date d'inscription du client"
["width"]=>
int(25)
["value"]=>
string(41) "format_date_to_excel("%dateInscription%")"
["format"]=>
string(8) "datetime"
}
[2]=>
array(4) {
["label"]=>
string(15) "Inscription par"
["width"]=>
int(30)
["value"]=>
string(95) "utf8_decode (nettoyage_csv (p2e_sinon(trim("%createurNom%".' '."%createurPrenom%"), 'client')))"
["write_method"]=>
string(12) "write_string"
}
[3]=>
array(4) {
["label"]=>
string(28) "Date de création du dossier"
["width"]=>
int(25)
["value"]=>
string(34) "format_date_to_excel("%dateCrea%")"
["format"]=>
string(8) "datetime"
}
[4]=>
array(4) {
["label"]=>
string(36) "Code de type de travaux (opération)"
["width"]=>
int(30)
["value"]=>
string(53) "utf8_decode (nettoyage_csv ("%code_operation_type%"))"
["write_method"]=>
string(12) "write_string"
}
[5]=>
array(4) {
["label"]=>
string(28) "Type de travaux (opération)"
["width"]=>
int(50)
["value"]=>
string(42) "utf8_decode (nettoyage_csv ("%lib_trav%"))"
["write_method"]=>
string(12) "write_string"
}
[6]=>
array(4) {
["label"]=>
string(33) "Date d'engagement de l'opération"
["width"]=>
int(26)
["value"]=>
string(41) "format_date_to_excel("%date_engagement%")"
["format"]=>
string(4) "date"
}
[7]=>
array(4) {
["label"]=>
string(34) "Date d'achèvement de l'opération"
["width"]=>
int(26)
["value"]=>
string(38) "format_date_to_excel("%date_facture%")"
["format"]=>
string(4) "date"
}
[8]=>
array(4) {
["label"]=>
string(17) "Date d'expiration"
["width"]=>
int(20)
["value"]=>
string(64) "format_date_to_excel(filtre_get_date_expiration("%id_dossier%"))"
["format"]=>
string(4) "date"
}
[9]=>
array(4) {
["label"]=>
string(12) "Réf. client"
["width"]=>
int(10)
["value"]=>
string(14) ""%ref_client%""
["write_method"]=>
string(12) "write_string"
}
[10]=>
array(4) {
["label"]=>
string(9) "Civilité"
["width"]=>
int(10)
["value"]=>
string(62) "formater_nom(array('code_civilite' => "%code_civilite%"),'@s')"
["write_method"]=>
string(12) "write_string"
}
[11]=>
array(4) {
["label"]=>
string(3) "Nom"
["width"]=>
int(30)
["value"]=>
string(56) "utf8_decode (formater_nom(array('nom' => "%nom%"),'@N'))"
["write_method"]=>
string(12) "write_string"
}
[12]=>
array(4) {
["label"]=>
string(7) "Prénom"
["width"]=>
int(30)
["value"]=>
string(62) "utf8_decode (formater_nom(array('prenom' => "%prenom%"),'@p'))"
["write_method"]=>
string(12) "write_string"
}
[13]=>
array(4) {
["label"]=>
string(14) "Adresse client"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%cli_adr0%" .' '. "%cli_adr1%" .' '. "%cli_adr2%" .' '. "%cli_adr3%")))"
["write_method"]=>
string(12) "write_string"
}
[14]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[15]=>
array(4) {
["label"]=>
string(12) "Ville client"
["width"]=>
int(30)
["value"]=>
string(46) "utf8_decode (nettoyage_csv ("%auteur_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[16]=>
array(4) {
["label"]=>
string(11) "Pays client"
["width"]=>
int(10)
["value"]=>
string(50) "utf8_decode (nettoyage_csv ("%auteur_code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[17]=>
array(4) {
["label"]=>
string(14) "Tél. Domicile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_fixe%""
["format"]=>
string(9) "telephone"
}
[18]=>
array(4) {
["label"]=>
string(12) "Tél. Mobile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_port%""
["format"]=>
string(9) "telephone"
}
[19]=>
array(4) {
["label"]=>
string(19) "Tél. Professionnel"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_prof%""
["format"]=>
string(9) "telephone"
}
[20]=>
array(4) {
["label"]=>
string(5) "Email"
["width"]=>
int(40)
["value"]=>
string(39) "utf8_decode (nettoyage_csv ("%email%"))"
["write_method"]=>
string(12) "write_string"
}
[21]=>
array(5) {
["label"]=>
string(17) "Prime attribuable"
["width"]=>
int(20)
["value"]=>
string(17) ""%prime_estimee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[22]=>
array(5) {
["label"]=>
string(16) "Prime attribuée"
["width"]=>
int(20)
["value"]=>
string(19) ""%prime_attribuee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[23]=>
array(4) {
["label"]=>
string(5) "Kwatt"
["width"]=>
int(15)
["value"]=>
string(9) ""%kwatt%""
["write_method"]=>
string(12) "write_number"
}
[24]=>
array(4) {
["label"]=>
string(1) "R"
["width"]=>
int(5)
["value"]=>
string(121) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%r%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[25]=>
array(4) {
["label"]=>
string(3) "COP"
["width"]=>
int(20)
["value"]=>
string(153) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_cop_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[26]=>
array(4) {
["label"]=>
string(22) "Surface (ou Quantité)"
["width"]=>
int(20)
["value"]=>
string(134) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (surface_ou_quantite_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%"))))"
["write_method"]=>
string(12) "write_string"
}
[27]=>
array(4) {
["label"]=>
string(27) "Information supplémentaire"
["width"]=>
int(30)
["value"]=>
string(122) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_info_supp_chauff("%cop%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[28]=>
array(4) {
["label"]=>
string(17) "Surface habitable"
["width"]=>
int(20)
["value"]=>
string(137) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%surface_habitable%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[29]=>
array(4) {
["label"]=>
string(30) "Travaux année de construction"
["width"]=>
int(35)
["value"]=>
string(97) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_annee_construction_'."%annee_construction%")))"
["write_method"]=>
string(12) "write_string"
}
[30]=>
array(4) {
["label"]=>
string(21) "Travaux type logement"
["width"]=>
int(50)
["value"]=>
string(87) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_logement_'."%type_logement%")))"
["write_method"]=>
string(12) "write_string"
}
[31]=>
array(4) {
["label"]=>
string(22) "Travaux type chauffage"
["width"]=>
int(35)
["value"]=>
string(89) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_chauffage_'."%type_chauffage%")))"
["write_method"]=>
string(12) "write_string"
}
[32]=>
array(4) {
["label"]=>
string(14) "Statut dossier"
["width"]=>
int(40)
["value"]=>
string(48) "utf8_decode (nettoyage_csv ("%statut_dossier%"))"
["write_method"]=>
string(12) "write_string"
}
[33]=>
array(4) {
["label"]=>
string(22) "Date changement statut"
["width"]=>
int(20)
["value"]=>
string(30) "format_date_to_excel("%date%")"
["format"]=>
string(8) "datetime"
}
[34]=>
array(4) {
["label"]=>
string(24) "Auteur changement statut"
["width"]=>
int(30)
["value"]=>
string(76) "utf8_decode (nettoyage_csv ("%auteurModifPrenom%" .' '. "%auteurModifNom%"))"
["write_method"]=>
string(12) "write_string"
}
[35]=>
array(4) {
["label"]=>
string(15) "Travaux adresse"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%adr_lib1%" .' '. "%adr_lib2%" .' '. "%adr_lib3%" .' '. "%adr_lib4%")))"
["write_method"]=>
string(12) "write_string"
}
[36]=>
array(5) {
["label"]=>
string(10) "Travaux CP"
["width"]=>
int(15)
["value"]=>
string(40) "utf8_decode (nettoyage_csv ("%adr_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[37]=>
array(4) {
["label"]=>
string(13) "Travaux Ville"
["width"]=>
int(30)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%adr_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[38]=>
array(5) {
["label"]=>
string(20) "Travaux Département"
["width"]=>
int(25)
["value"]=>
string(20) ""%code_departement%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "departement"
}
[39]=>
array(4) {
["label"]=>
string(12) "Travaux Pays"
["width"]=>
int(20)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[40]=>
array(4) {
["label"]=>
string(8) "Lot emmy"
["width"]=>
int(20)
["value"]=>
string(41) "utf8_decode (nettoyage_csv ("%lib_lot%"))"
["write_method"]=>
string(12) "write_string"
}
[""]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_string"
["format"]=>
string(11) "code_postal"
}
}
- Output for 7.0.18 - 7.0.31, 7.1.4 - 7.1.23, 7.2.0 - 7.2.33
- Notice: Undefined variable: auteur_index_cp in /in/lGhOR on line 270
array(42) {
[0]=>
array(4) {
["label"]=>
string(13) "Réf. dossier"
["width"]=>
int(15)
["value"]=>
string(15) ""%ref_dossier%""
["write_method"]=>
string(12) "write_string"
}
[1]=>
array(4) {
["label"]=>
string(28) "Date d'inscription du client"
["width"]=>
int(25)
["value"]=>
string(41) "format_date_to_excel("%dateInscription%")"
["format"]=>
string(8) "datetime"
}
[2]=>
array(4) {
["label"]=>
string(15) "Inscription par"
["width"]=>
int(30)
["value"]=>
string(95) "utf8_decode (nettoyage_csv (p2e_sinon(trim("%createurNom%".' '."%createurPrenom%"), 'client')))"
["write_method"]=>
string(12) "write_string"
}
[3]=>
array(4) {
["label"]=>
string(28) "Date de création du dossier"
["width"]=>
int(25)
["value"]=>
string(34) "format_date_to_excel("%dateCrea%")"
["format"]=>
string(8) "datetime"
}
[4]=>
array(4) {
["label"]=>
string(36) "Code de type de travaux (opération)"
["width"]=>
int(30)
["value"]=>
string(53) "utf8_decode (nettoyage_csv ("%code_operation_type%"))"
["write_method"]=>
string(12) "write_string"
}
[5]=>
array(4) {
["label"]=>
string(28) "Type de travaux (opération)"
["width"]=>
int(50)
["value"]=>
string(42) "utf8_decode (nettoyage_csv ("%lib_trav%"))"
["write_method"]=>
string(12) "write_string"
}
[6]=>
array(4) {
["label"]=>
string(33) "Date d'engagement de l'opération"
["width"]=>
int(26)
["value"]=>
string(41) "format_date_to_excel("%date_engagement%")"
["format"]=>
string(4) "date"
}
[7]=>
array(4) {
["label"]=>
string(34) "Date d'achèvement de l'opération"
["width"]=>
int(26)
["value"]=>
string(38) "format_date_to_excel("%date_facture%")"
["format"]=>
string(4) "date"
}
[8]=>
array(4) {
["label"]=>
string(17) "Date d'expiration"
["width"]=>
int(20)
["value"]=>
string(64) "format_date_to_excel(filtre_get_date_expiration("%id_dossier%"))"
["format"]=>
string(4) "date"
}
[9]=>
array(4) {
["label"]=>
string(12) "Réf. client"
["width"]=>
int(10)
["value"]=>
string(14) ""%ref_client%""
["write_method"]=>
string(12) "write_string"
}
[10]=>
array(4) {
["label"]=>
string(9) "Civilité"
["width"]=>
int(10)
["value"]=>
string(62) "formater_nom(array('code_civilite' => "%code_civilite%"),'@s')"
["write_method"]=>
string(12) "write_string"
}
[11]=>
array(4) {
["label"]=>
string(3) "Nom"
["width"]=>
int(30)
["value"]=>
string(56) "utf8_decode (formater_nom(array('nom' => "%nom%"),'@N'))"
["write_method"]=>
string(12) "write_string"
}
[12]=>
array(4) {
["label"]=>
string(7) "Prénom"
["width"]=>
int(30)
["value"]=>
string(62) "utf8_decode (formater_nom(array('prenom' => "%prenom%"),'@p'))"
["write_method"]=>
string(12) "write_string"
}
[13]=>
array(4) {
["label"]=>
string(14) "Adresse client"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%cli_adr0%" .' '. "%cli_adr1%" .' '. "%cli_adr2%" .' '. "%cli_adr3%")))"
["write_method"]=>
string(12) "write_string"
}
[14]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[15]=>
array(4) {
["label"]=>
string(12) "Ville client"
["width"]=>
int(30)
["value"]=>
string(46) "utf8_decode (nettoyage_csv ("%auteur_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[16]=>
array(4) {
["label"]=>
string(11) "Pays client"
["width"]=>
int(10)
["value"]=>
string(50) "utf8_decode (nettoyage_csv ("%auteur_code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[17]=>
array(4) {
["label"]=>
string(14) "Tél. Domicile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_fixe%""
["format"]=>
string(9) "telephone"
}
[18]=>
array(4) {
["label"]=>
string(12) "Tél. Mobile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_port%""
["format"]=>
string(9) "telephone"
}
[19]=>
array(4) {
["label"]=>
string(19) "Tél. Professionnel"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_prof%""
["format"]=>
string(9) "telephone"
}
[20]=>
array(4) {
["label"]=>
string(5) "Email"
["width"]=>
int(40)
["value"]=>
string(39) "utf8_decode (nettoyage_csv ("%email%"))"
["write_method"]=>
string(12) "write_string"
}
[21]=>
array(5) {
["label"]=>
string(17) "Prime attribuable"
["width"]=>
int(20)
["value"]=>
string(17) ""%prime_estimee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[22]=>
array(5) {
["label"]=>
string(16) "Prime attribuée"
["width"]=>
int(20)
["value"]=>
string(19) ""%prime_attribuee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[23]=>
array(4) {
["label"]=>
string(5) "Kwatt"
["width"]=>
int(15)
["value"]=>
string(9) ""%kwatt%""
["write_method"]=>
string(12) "write_number"
}
[24]=>
array(4) {
["label"]=>
string(1) "R"
["width"]=>
int(5)
["value"]=>
string(121) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%r%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[25]=>
array(4) {
["label"]=>
string(3) "COP"
["width"]=>
int(20)
["value"]=>
string(153) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_cop_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[26]=>
array(4) {
["label"]=>
string(22) "Surface (ou Quantité)"
["width"]=>
int(20)
["value"]=>
string(134) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (surface_ou_quantite_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%"))))"
["write_method"]=>
string(12) "write_string"
}
[27]=>
array(4) {
["label"]=>
string(27) "Information supplémentaire"
["width"]=>
int(30)
["value"]=>
string(122) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_info_supp_chauff("%cop%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[28]=>
array(4) {
["label"]=>
string(17) "Surface habitable"
["width"]=>
int(20)
["value"]=>
string(137) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%surface_habitable%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[29]=>
array(4) {
["label"]=>
string(30) "Travaux année de construction"
["width"]=>
int(35)
["value"]=>
string(97) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_annee_construction_'."%annee_construction%")))"
["write_method"]=>
string(12) "write_string"
}
[30]=>
array(4) {
["label"]=>
string(21) "Travaux type logement"
["width"]=>
int(50)
["value"]=>
string(87) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_logement_'."%type_logement%")))"
["write_method"]=>
string(12) "write_string"
}
[31]=>
array(4) {
["label"]=>
string(22) "Travaux type chauffage"
["width"]=>
int(35)
["value"]=>
string(89) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_chauffage_'."%type_chauffage%")))"
["write_method"]=>
string(12) "write_string"
}
[32]=>
array(4) {
["label"]=>
string(14) "Statut dossier"
["width"]=>
int(40)
["value"]=>
string(48) "utf8_decode (nettoyage_csv ("%statut_dossier%"))"
["write_method"]=>
string(12) "write_string"
}
[33]=>
array(4) {
["label"]=>
string(22) "Date changement statut"
["width"]=>
int(20)
["value"]=>
string(30) "format_date_to_excel("%date%")"
["format"]=>
string(8) "datetime"
}
[34]=>
array(4) {
["label"]=>
string(24) "Auteur changement statut"
["width"]=>
int(30)
["value"]=>
string(76) "utf8_decode (nettoyage_csv ("%auteurModifPrenom%" .' '. "%auteurModifNom%"))"
["write_method"]=>
string(12) "write_string"
}
[35]=>
array(4) {
["label"]=>
string(15) "Travaux adresse"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%adr_lib1%" .' '. "%adr_lib2%" .' '. "%adr_lib3%" .' '. "%adr_lib4%")))"
["write_method"]=>
string(12) "write_string"
}
[36]=>
array(5) {
["label"]=>
string(10) "Travaux CP"
["width"]=>
int(15)
["value"]=>
string(40) "utf8_decode (nettoyage_csv ("%adr_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[37]=>
array(4) {
["label"]=>
string(13) "Travaux Ville"
["width"]=>
int(30)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%adr_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[38]=>
array(5) {
["label"]=>
string(20) "Travaux Département"
["width"]=>
int(25)
["value"]=>
string(20) ""%code_departement%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "departement"
}
[39]=>
array(4) {
["label"]=>
string(12) "Travaux Pays"
["width"]=>
int(20)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[40]=>
array(4) {
["label"]=>
string(8) "Lot emmy"
["width"]=>
int(20)
["value"]=>
string(41) "utf8_decode (nettoyage_csv ("%lib_lot%"))"
["write_method"]=>
string(12) "write_string"
}
[""]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_string"
["format"]=>
string(11) "code_postal"
}
}
- Output for 5.5.0 - 5.5.38, 5.6.0 - 5.6.38, 7.0.0 - 7.0.17, 7.1.0 - 7.1.3
- Notice: Undefined variable: auteur_index_cp in /in/lGhOR on line 280
array(42) {
[0]=>
array(4) {
["label"]=>
string(13) "Réf. dossier"
["width"]=>
int(15)
["value"]=>
string(15) ""%ref_dossier%""
["write_method"]=>
string(12) "write_string"
}
[1]=>
array(4) {
["label"]=>
string(28) "Date d'inscription du client"
["width"]=>
int(25)
["value"]=>
string(41) "format_date_to_excel("%dateInscription%")"
["format"]=>
string(8) "datetime"
}
[2]=>
array(4) {
["label"]=>
string(15) "Inscription par"
["width"]=>
int(30)
["value"]=>
string(95) "utf8_decode (nettoyage_csv (p2e_sinon(trim("%createurNom%".' '."%createurPrenom%"), 'client')))"
["write_method"]=>
string(12) "write_string"
}
[3]=>
array(4) {
["label"]=>
string(28) "Date de création du dossier"
["width"]=>
int(25)
["value"]=>
string(34) "format_date_to_excel("%dateCrea%")"
["format"]=>
string(8) "datetime"
}
[4]=>
array(4) {
["label"]=>
string(36) "Code de type de travaux (opération)"
["width"]=>
int(30)
["value"]=>
string(53) "utf8_decode (nettoyage_csv ("%code_operation_type%"))"
["write_method"]=>
string(12) "write_string"
}
[5]=>
array(4) {
["label"]=>
string(28) "Type de travaux (opération)"
["width"]=>
int(50)
["value"]=>
string(42) "utf8_decode (nettoyage_csv ("%lib_trav%"))"
["write_method"]=>
string(12) "write_string"
}
[6]=>
array(4) {
["label"]=>
string(33) "Date d'engagement de l'opération"
["width"]=>
int(26)
["value"]=>
string(41) "format_date_to_excel("%date_engagement%")"
["format"]=>
string(4) "date"
}
[7]=>
array(4) {
["label"]=>
string(34) "Date d'achèvement de l'opération"
["width"]=>
int(26)
["value"]=>
string(38) "format_date_to_excel("%date_facture%")"
["format"]=>
string(4) "date"
}
[8]=>
array(4) {
["label"]=>
string(17) "Date d'expiration"
["width"]=>
int(20)
["value"]=>
string(64) "format_date_to_excel(filtre_get_date_expiration("%id_dossier%"))"
["format"]=>
string(4) "date"
}
[9]=>
array(4) {
["label"]=>
string(12) "Réf. client"
["width"]=>
int(10)
["value"]=>
string(14) ""%ref_client%""
["write_method"]=>
string(12) "write_string"
}
[10]=>
array(4) {
["label"]=>
string(9) "Civilité"
["width"]=>
int(10)
["value"]=>
string(62) "formater_nom(array('code_civilite' => "%code_civilite%"),'@s')"
["write_method"]=>
string(12) "write_string"
}
[11]=>
array(4) {
["label"]=>
string(3) "Nom"
["width"]=>
int(30)
["value"]=>
string(56) "utf8_decode (formater_nom(array('nom' => "%nom%"),'@N'))"
["write_method"]=>
string(12) "write_string"
}
[12]=>
array(4) {
["label"]=>
string(7) "Prénom"
["width"]=>
int(30)
["value"]=>
string(62) "utf8_decode (formater_nom(array('prenom' => "%prenom%"),'@p'))"
["write_method"]=>
string(12) "write_string"
}
[13]=>
array(4) {
["label"]=>
string(14) "Adresse client"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%cli_adr0%" .' '. "%cli_adr1%" .' '. "%cli_adr2%" .' '. "%cli_adr3%")))"
["write_method"]=>
string(12) "write_string"
}
[14]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[15]=>
array(4) {
["label"]=>
string(12) "Ville client"
["width"]=>
int(30)
["value"]=>
string(46) "utf8_decode (nettoyage_csv ("%auteur_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[16]=>
array(4) {
["label"]=>
string(11) "Pays client"
["width"]=>
int(10)
["value"]=>
string(50) "utf8_decode (nettoyage_csv ("%auteur_code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[17]=>
array(4) {
["label"]=>
string(14) "Tél. Domicile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_fixe%""
["format"]=>
string(9) "telephone"
}
[18]=>
array(4) {
["label"]=>
string(12) "Tél. Mobile"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_port%""
["format"]=>
string(9) "telephone"
}
[19]=>
array(4) {
["label"]=>
string(19) "Tél. Professionnel"
["width"]=>
int(15)
["value"]=>
string(12) ""%tel_prof%""
["format"]=>
string(9) "telephone"
}
[20]=>
array(4) {
["label"]=>
string(5) "Email"
["width"]=>
int(40)
["value"]=>
string(39) "utf8_decode (nettoyage_csv ("%email%"))"
["write_method"]=>
string(12) "write_string"
}
[21]=>
array(5) {
["label"]=>
string(17) "Prime attribuable"
["width"]=>
int(20)
["value"]=>
string(17) ""%prime_estimee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[22]=>
array(5) {
["label"]=>
string(16) "Prime attribuée"
["width"]=>
int(20)
["value"]=>
string(19) ""%prime_attribuee%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(5) "prime"
}
[23]=>
array(4) {
["label"]=>
string(5) "Kwatt"
["width"]=>
int(15)
["value"]=>
string(9) ""%kwatt%""
["write_method"]=>
string(12) "write_number"
}
[24]=>
array(4) {
["label"]=>
string(1) "R"
["width"]=>
int(5)
["value"]=>
string(121) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%r%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[25]=>
array(4) {
["label"]=>
string(3) "COP"
["width"]=>
int(20)
["value"]=>
string(153) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_cop_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[26]=>
array(4) {
["label"]=>
string(22) "Surface (ou Quantité)"
["width"]=>
int(20)
["value"]=>
string(134) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (surface_ou_quantite_facteur("%facteur_1%", "%facteur_2%", "%facteur_3%"))))"
["write_method"]=>
string(12) "write_string"
}
[27]=>
array(4) {
["label"]=>
string(27) "Information supplémentaire"
["width"]=>
int(30)
["value"]=>
string(122) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_info_supp_chauff("%cop%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[28]=>
array(4) {
["label"]=>
string(17) "Surface habitable"
["width"]=>
int(20)
["value"]=>
string(137) "utf8_decode( nettoyage_csv( nettoyage_caracteres_speciaux (affichage_surface_habitable("%surface_habitable%", "%code_operation_type%"))))"
["write_method"]=>
string(12) "write_string"
}
[29]=>
array(4) {
["label"]=>
string(30) "Travaux année de construction"
["width"]=>
int(35)
["value"]=>
string(97) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_annee_construction_'."%annee_construction%")))"
["write_method"]=>
string(12) "write_string"
}
[30]=>
array(4) {
["label"]=>
string(21) "Travaux type logement"
["width"]=>
int(50)
["value"]=>
string(87) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_logement_'."%type_logement%")))"
["write_method"]=>
string(12) "write_string"
}
[31]=>
array(4) {
["label"]=>
string(22) "Travaux type chauffage"
["width"]=>
int(35)
["value"]=>
string(89) "utf8_decode( nettoyage_csv( _T('p2e_saisies:saisie_type_chauffage_'."%type_chauffage%")))"
["write_method"]=>
string(12) "write_string"
}
[32]=>
array(4) {
["label"]=>
string(14) "Statut dossier"
["width"]=>
int(40)
["value"]=>
string(48) "utf8_decode (nettoyage_csv ("%statut_dossier%"))"
["write_method"]=>
string(12) "write_string"
}
[33]=>
array(4) {
["label"]=>
string(22) "Date changement statut"
["width"]=>
int(20)
["value"]=>
string(30) "format_date_to_excel("%date%")"
["format"]=>
string(8) "datetime"
}
[34]=>
array(4) {
["label"]=>
string(24) "Auteur changement statut"
["width"]=>
int(30)
["value"]=>
string(76) "utf8_decode (nettoyage_csv ("%auteurModifPrenom%" .' '. "%auteurModifNom%"))"
["write_method"]=>
string(12) "write_string"
}
[35]=>
array(4) {
["label"]=>
string(15) "Travaux adresse"
["width"]=>
int(50)
["value"]=>
string(107) "utf8_decode (nettoyage_csv ( trim( "%adr_lib1%" .' '. "%adr_lib2%" .' '. "%adr_lib3%" .' '. "%adr_lib4%")))"
["write_method"]=>
string(12) "write_string"
}
[36]=>
array(5) {
["label"]=>
string(10) "Travaux CP"
["width"]=>
int(15)
["value"]=>
string(40) "utf8_decode (nettoyage_csv ("%adr_cp%"))"
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "code_postal"
}
[37]=>
array(4) {
["label"]=>
string(13) "Travaux Ville"
["width"]=>
int(30)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%adr_ville%"))"
["write_method"]=>
string(12) "write_string"
}
[38]=>
array(5) {
["label"]=>
string(20) "Travaux Département"
["width"]=>
int(25)
["value"]=>
string(20) ""%code_departement%""
["write_method"]=>
string(12) "write_number"
["format"]=>
string(11) "departement"
}
[39]=>
array(4) {
["label"]=>
string(12) "Travaux Pays"
["width"]=>
int(20)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%code_pays%"))"
["write_method"]=>
string(12) "write_string"
}
[40]=>
array(4) {
["label"]=>
string(8) "Lot emmy"
["width"]=>
int(20)
["value"]=>
string(41) "utf8_decode (nettoyage_csv ("%lib_lot%"))"
["write_method"]=>
string(12) "write_string"
}
[""]=>
array(5) {
["label"]=>
string(9) "CP client"
["width"]=>
int(10)
["value"]=>
string(43) "utf8_decode (nettoyage_csv ("%auteur_cp%"))"
["write_method"]=>
string(12) "write_string"
["format"]=>
string(11) "code_postal"
}
}
preferences:
340.81 ms | 426 KiB | 286 Q