3v4l.org

run code in 300+ PHP versions simultaneously
<?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 git.master, git.master_jit, rfc.property-hooks
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" } }

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

preferences:
54.93 ms | 425 KiB | 8 Q