Edition Personnalisée/Documentation utilisateur
Description et utilisation
Le module d'édition personnalisée permet de générer les documents au format PDF et/ou ODT correspondant à une proposition commerciale, commande ou facture standard de dolibarr. Ce module vient en supplément à la génération standard de document de dolibarr.
Les documents sont générés à partir de modèle(s) téléversable via l'administration du module : Accueil => Configuration => Modules => Odtdocs : Config.
Pour générer un document via ce module, il suffit d'accéder à l'onglet "Edition Personnalisée" qui se trouve sur la fiche d'une proposition commerciale, commande ou facture lorsque le module est activé. Une fois sur cette page il suffit de choisir un modèle (préalablement téléversé) et de cliquer sur "Générer" pour avoir un document au format .ODT, ou sur "Générer en PDF" pour un document au format .PDF.
Pour chaque fiche proposition commerciale, commande ou facture, une liste des différents documents générés via le module d'édition personnalisée est disponible via l'onglet du même nom.
Modèles de documents
Les modèles de documents doivent être au format ODT et conçu au format TinyButStrong
Les différentes variables accessible dans ces modèles sont :
1 - Propales
[doc] => Propal Object ( [element] => propal [table_element] => propal [table_element_line] => propaldet [fk_element] => fk_propal [ismultientitymanaged:protected] => 1 [id] => 2 [socid] => 11 [client] => [contactid] => [fk_project] => [author] => [ref] => PR1311-0001 [ref_client] => [statut] => 0 [datec] => 1384961438 [datev] => 1385045875 [date] => 1384902000 [datep] => 1384902000 [date_livraison] => [fin_validite] => 1386241200 [user_author_id] => 2 [user_valid_id] => 2 [user_close_id] => [total_ht] => 105000.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => 105000.00000000 [price] => [tva] => [total] => 105000.00000000 [cond_reglement_id] => 1 [cond_reglement_code] => RECEP [mode_reglement_id] => 0 [mode_reglement_code] => [remise] => 0 [remise_percent] => [remise_absolue] => [note] => [note_private] => [note_public] => [fk_delivery_address] => [fk_address] => [address_type] => [address] => [availability_id] => 0 [availability_code] => [demand_reason_id] => 0 [demand_reason_code] => [products] => Array ( ) [line] => [origin] => [origin_id] => [labelstatut] => Array ( [0] => Brouillon (à valider) [1] => Validée (propale ouverte) [2] => Signée (à facturer) [3] => Non signée (fermée) [4] => Facturée ) [labelstatut_short] => Array ( [0] => Brouillon [1] => Ouvert [2] => Signée [3] => Non signée [4] => Facturée ) [nbtodo] => [nbtodolate] => [specimen] => [error] => [errors] => [canvas] => [lastname] => [firstname] => [name] => [nom] => [civility_id] => [array_options] => Array ( ) [linkedObjectsIds] => Array ( ) [linkedObjects] => Array ( ) [duree_validite] => 15 [modelpdf] => azur [statut_libelle] => Brouillon [date_creation] => 1384961438 [date_validation] => 1385045875 [availability] => [demand_reason] => [mode_reglement] => - [cond_reglement] => A réception de facture [cond_reglement_doc] => Réception de facture [brouillon] => 1 [total_ht_devise] => 105000.00000 [total_tva_devise] => 0 [total_ttc_devise] => 105000.00000 ) [societe] => Societe Object ( [element] => societe [table_element] => societe [fk_element] => fk_soc [childtables:protected] => Array ( [0] => propal [1] => commande [2] => facture [3] => contrat [4] => facture_fourn [5] => commande_fournisseur ) [ismultientitymanaged:protected] => 1 [id] => 11 [name] => ATM [nom] => ATM [firstname] => [lastname] => [particulier] => [civility_id] => [address] => [zip] => 26000 [town] => Valence [status] => 1 [state_id] => 667 [state_code] => MA11 [state] => Plateau de Lautagne [departement_id] => [departement_code] => [departement] => [pays] => [country_id] => 12 [country_code] => FR [country] => France [tel] => 0426781781 [phone] => 0426781781 [fax] => [email] => [url] => www.atm-consulting.fr [barcode] => [barcode_type] => [barcode_type_code] => [barcode_type_label] => [barcode_type_coder] => [idprof1] => [idprof2] => [idprof3] => [idprof4] => [idprof5] => [idprof6] => [prefix_comm] => [tva_assuj] => 1 [tva_intra] => [localtax1_assuj] => [localtax2_assuj] => [capital] => 45000000 [typent_id] => 0 [typent_code] => TE_UNKNOWN [effectif_id] => [forme_juridique_code] => [forme_juridique] => [remise_percent] => 0 [mode_reglement_id] => [cond_reglement_id] => [remise_client] => 0 [mode_reglement] => [cond_reglement] => [client] => 1 [prospect] => 0 [fournisseur] => 0 [code_client] => CL00011 [code_fournisseur] => [code_compta] => 411CL00011 [code_compta_fournisseur] => [note] => [note_private] => [note_public] => [stcomm_id] => 0 [statut_commercial] => Jamais contacté [price_level] => [datec] => 1380668336 [date_update] => 1380668336 [commercial_id] => [parent] => [default_lang] => [ref_int] => [import_key] => [logo] => [logo_small] => [logo_mini] => [array_options] => [oldcopy] => [error] => [errors] => [canvas] => [linkedObjectsIds] => [linkedObjects] => [entity] => 1 [ref] => 11 [ref_ext] => [effectif] => [fk_prospectlevel] => ) [mysoc] => Societe Object ( [element] => societe [table_element] => societe [fk_element] => fk_soc [ismultientitymanaged:protected] => 1 [id] => 0 [name] => MyCompany [nom] => MyCompany [firstname] => [lastname] => [particulier] => [civility_id] => [address] => [zip] => 20000 [town] => Valence [status] => 1 [state_id] => [state_code] => [state] => [departement_id] => [departement_code] => [departement] => [pays] => [country_id] => 12 [country_code] => FR [country] => France [tel] => 0426781781 [phone] => 0426781781 [fax] => 0426781781 [email] => info@test.com [url] => http://www.test.fr [barcode] => [barcode_type] => [barcode_type_code] => [barcode_type_label] => [barcode_type_coder] => [idprof1] => 239489 [idprof2] => [idprof3] => 40417086 [idprof4] => 8811722 [idprof5] => [idprof6] => [prefix_comm] => [tva_assuj] => 1 [tva_intra] => [localtax1_assuj] => 0 [localtax2_assuj] => 0 [capital] => [typent_id] => 0 [typent_code] => [effectif_id] => 0 [forme_juridique_code] => [forme_juridique] => [remise_percent] => [mode_reglement_id] => [cond_reglement_id] => [remise_client] => [mode_reglement] => [cond_reglement] => [client] => 0 [prospect] => 0 [fournisseur] => 0 [code_client] => [code_fournisseur] => [code_compta] => [code_compta_fournisseur] => [note] => [note_private] => [note_public] => [stcomm_id] => [statut_commercial] => [price_level] => [datec] => [date_update] => [commercial_id] => [parent] => [default_lang] => [ref_int] => [import_key] => [logo] => MyLogo_0.jpg [logo_small] => MyLogo_0_small.jpg [logo_mini] => MyLogo_0_mini.jpg [array_options] => [oldcopy] => [error] => [errors] => [canvas] => [linkedObjectsIds] => [linkedObjects] => ) [tableau] => Array ( [0] => Array ( [error] => [oldline] => [rowid] => 6 [fk_propal] => 2 [fk_parent_line] => 10 [desc] => [fk_product] => 681 [product_type] => 0 [qty] => 5000 [tva_tx] => 0.000 [subprice] => 15.00000000 [remise_percent] => [fk_remise_except] => [rang] => 1 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => 100 [special_code] => 0 [info_bits] => 0 [total_ht] => 75000.00000000 [total_tva] => 0.00000000 [total_ttc] => 75000.00000000 [remise] => [price] => 15 [ref] => P001 [libelle] => Un Produit [product_desc] => Un produit de test [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [date_start] => [date_end] => [skip_update_total] => [label] => [product_ref] => P001 [product_label] => Un Produit [fk_product_type] => 0 [product_photo] => [devise_pu] => 15.00000 [devise_mt_ligne] => 75000.00000 [unite] => M3 ) [1] => Array ( [error] => [oldline] => [rowid] => 10 [fk_propal] => 2 [fk_parent_line] => [desc] => PHASE 1 [fk_product] => [product_type] => 9 [qty] => 0 [tva_tx] => 0.000 [subprice] => 0.00000000 [remise_percent] => [fk_remise_except] => [rang] => 1 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => [special_code] => 1790 [info_bits] => 0 [total_ht] => 75000.00000000 [total_tva] => 0.00000000 [total_ttc] => 75000.00000000 [remise] => [price] => 0 [ref] => [libelle] => [product_desc] => [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [date_start] => [date_end] => [skip_update_total] => [label] => [product_ref] => [product_label] => [fk_product_type] => [description] => [devise_pu] => 0.00000000 [devise_mt_ligne] => 75000.00000000 [unite] => ) [2] => Array ( [error] => [oldline] => [rowid] => 11 [fk_propal] => 2 [fk_parent_line] => [desc] => PHASE 2 [fk_product] => [product_type] => 9 [qty] => 0 [tva_tx] => 0.000 [subprice] => 0.00000000 [remise_percent] => [fk_remise_except] => [rang] => 2 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => [special_code] => 1790 [info_bits] => 0 [total_ht] => 30000.00000000 [total_tva] => 0.00000000 [total_ttc] => 30000.00000000 [remise] => [price] => 0 [ref] => [libelle] => [product_desc] => [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [date_start] => [date_end] => [skip_update_total] => [label] => [product_ref] => [product_label] => [fk_product_type] => [description] => [devise_pu] => 0.00000000 [devise_mt_ligne] => 30000.00000000 [unite] => ) [3] => Array ( [error] => [oldline] => [rowid] => 9 [fk_propal] => 2 [fk_parent_line] => 11 [desc] => [fk_product] => 681 [product_type] => 0 [qty] => 2000 [tva_tx] => 0.000 [subprice] => 15.00000000 [remise_percent] => [fk_remise_except] => [rang] => 4 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => 100 [special_code] => 0 [info_bits] => 0 [total_ht] => 30000.00000000 [total_tva] => 0.00000000 [total_ttc] => 30000.00000000 [remise] => [price] => 15 [ref] => P002 [libelle] => Intitulé d'un deuxième problème [product_desc] => Description deuxième produit [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [date_start] => [date_end] => [skip_update_total] => [label] => [product_ref] => P002 [product_label] => Intitulé d'un deuxième problème [fk_product_type] => 0 [product_photo] => [devise_pu] => 15.00000 [devise_mt_ligne] => 30000.00000 [unite] => U3 ) ) [contact] => Array ( [CUSTOMER] => Array ( [id] => 1 [civility] => [firstname] => Test [lastname] => Contact [address] => [cp] => [ville] => [pays] => [email] => [phone] => [fax] => [societe] => ATM Consulting ) [BILLING] => Array ( [id] => 1 [civility] => [firstname] => Test [lastname] => Contact [address] => [cp] => [ville] => [pays] => [email] => [phone] => [fax] => [societe] => ATM Consulting ) [SALESREPFOLL] => Array ( [id] => 1 [firstname] => [lastname] => SuperAdmin [address] => [cp] => [ville] => [pays] => [email] => support@atm-consulting.fr [phone] => [fax] => ) ) [linkedObjects] => Array ( ) [autre] => Array ( [devise] => Euros [incoterm] => EXW [date_devis_fr] => 22/11/2013 [fin_validite] => 05/12/2013 [projet] => Intitulé projet )
2 - Commandes
[doc] => Commande Object ( [element] => commande [table_element] => commande [table_element_line] => commandedet [class_element_line] => OrderLine [fk_element] => fk_commande [ismultientitymanaged:protected] => 1 [id] => 2 [socid] => 1 [client] => [ref] => CO1309-0002 [ref_client] => [ref_ext] => [ref_int] => [contactid] => [fk_project] => [statut] => 2 [facturee] => 0 [brouillon] => [cond_reglement_id] => 1 [cond_reglement_code] => RECEP [mode_reglement_id] => 51 [mode_reglement_code] => TRA [availability_id] => 3 [availability_code] => AV_2W [demand_reason_id] => 5 [demand_reason_code] => [fk_delivery_address] => [address] => [date] => 1380146400 [date_commande] => 1380146400 [date_livraison] => 1383174000 [fk_remise_except] => [remise_percent] => 0 [total_ht] => 3158.89000000 [total_ttc] => 3158.89000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [remise_absolue] => [modelpdf] => einstein [info_bits] => [rang] => [special_code] => [source] => [note] => Note Privée [note_private] => Note Privée [note_public] => Note publique qui apparaît dans les documents générés [extraparams] => Array ( )
[origin] => [origin_id] => [linked_objects] => Array ( )
[user_author_id] => 1 [lines] => Array ( [0] => OrderLine Object ( [db] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => 1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [oldline] => [rowid] => 4 [fk_parent_line] => [fk_facture] => [label] => [desc] => Nos fabrications sont conformes aux normes européennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tolérances dimensionnelles du fil EN 10218-2, Classe T1 * Revêtement Galvanisé EN 10244-2 * Tolérances mailles hexagonales EN 10223-3
(Code douane: 7326203000)
[fk_product] => 417 [product_type] => 0 [qty] => 1 [tva_tx] => 0.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [subprice] => 0.00000000 [remise_percent] => 0 [fk_remise_except] => [rang] => 1 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => [info_bits] => 0 [special_code] => 0 [total_ht] => 0.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => 0.00000000 [remise] => [price] => 0 [ref] => GA8A27201010VA1DT2DIR [libelle] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [product_ref] => GA8A27201010VA1DT2DIR [product_label] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [product_desc] => Nos fabrications sont conformes aux normes européennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tolérances dimensionnelles du fil EN 10218-2, Classe T1 * Revêtement Galvanisé EN 10244-2 * Tolérances mailles hexagonales EN 10223-3 [date_start] => [date_end] => [skip_update_total] => [id] => 4 [fk_commande] => 2 [commande_id] => 2 [fk_product_type] => 0 )
[1] => OrderLine Object ( [db] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [oldline] => [rowid] => 5 [fk_parent_line] => [fk_facture] => [label] => [desc] => tyersta zedazf zad [fk_product] => [product_type] => 0 [qty] => 1 [tva_tx] => 0.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [subprice] => 1000.00000000 [remise_percent] => 0 [fk_remise_except] => [rang] => 2 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => 100 [info_bits] => 0 [special_code] => 0 [total_ht] => 1000.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => 1000.00000000 [remise] => [price] => 1000 [ref] => [libelle] => [product_ref] => [product_label] => [product_desc] => [date_start] => [date_end] => [skip_update_total] => [id] => 5 [fk_commande] => 2 [commande_id] => 2 [fk_product_type] => ) )
[nbtodo] => [nbtodolate] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [lastname] => [firstname] => [name] => [nom] => [civility_id] => [array_options] => Array ( )
[linkedObjectsIds] => Array ( [facture] => Array ( [0] => 4 )
[shipping] => Array ( [0] => 1 )
[propal] => Array ( [0] => 1 )
)
[linkedObjects] => Array ( [facture] => Array ( [0] => Facture Object ( [element] => facture [table_element] => facture [table_element_line] => facturedet [fk_element] => fk_facture [ismultientitymanaged:protected] => 1 [id] => 4 [socid] => 1 [client] => [author] => [fk_user_author] => [fk_user_valid] => [date] => 1380146400 [date_creation] => 1380206693 [date_validation] => 1381356000 [datem] => 1381909620 [ref] => FA1309-0002 [ref_client] => [ref_ext] => [ref_int] => [type] => 0 [remise_absolue] => [remise_percent] => [total_ht] => 3158.89000000 [total_tva] => 0.00000000 [total_ttc] => 3158.89000000 [revenuestamp] => 0.00000000 [note] => Note Privée [note_private] => Note Privée [note_public] => Note publique qui apparaît dans les documents générés [statut] => 1 [close_code] => [close_note] => [paye] => 0 [fk_facture_source] => [origin] => [origin_id] => [linked_objects] => Array ( )
[fk_project] => 5 [date_lim_reglement] => 1380146400 [cond_reglement_id] => 1 [cond_reglement_code] => RECEP [mode_reglement_id] => 51 [mode_reglement_code] => TRA [fk_bank] => [modelpdf] => crabe [products] => Array ( )
[lines] => Array ( [0] => FactureLigne Object ( [db] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [oldline] => [rowid] => 14 [fk_facture] => [fk_parent_line] => [label] => [desc] => Nos fabrications sont conformes aux normes européennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tolérances dimensionnelles du fil EN 10218-2, Classe T1 * Revêtement Galvanisé EN 10244-2 * Tolérances mailles hexagonales EN 10223-3
(Code douane: 7326203000)
[fk_product] => 417 [product_type] => 0 [qty] => 1 [tva_tx] => 0.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [subprice] => 0.00000000 [remise_percent] => 0 [fk_remise_except] => [rang] => 1 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => [info_bits] => 0 [special_code] => 0 [origin] => [origin_id] => [total_ht] => 0.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => 0.00000000 [fk_code_ventilation] => 0 [date_start] => [date_end] => [ref] => [product_ref] => GA8A27201010VA1DT2DIR [libelle] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [product_label] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [product_desc] => Nos fabrications sont conformes aux normes européennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tolérances dimensionnelles du fil EN 10218-2, Classe T1 * Revêtement Galvanisé EN 10244-2 * Tolérances mailles hexagonales EN 10223-3 [skip_update_total] => [fk_product_type] => 0 [code_ventilation] => 0 )
[1] => FactureLigne Object ( [db] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [oldline] => [rowid] => 15 [fk_facture] => [fk_parent_line] => [label] => [desc] => tyersta zedazf zad [fk_product] => [product_type] => 0 [qty] => 1 [tva_tx] => 0.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [subprice] => 1000.00000000 [remise_percent] => 0 [fk_remise_except] => [rang] => 2 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => 100 [info_bits] => 0 [special_code] => 0 [origin] => [origin_id] => [total_ht] => 1000.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => 1000.00000000 [fk_code_ventilation] => 0 [date_start] => [date_end] => [ref] => [product_ref] => [libelle] => [product_label] => [product_desc] => [skip_update_total] => [fk_product_type] => [code_ventilation] => 0 ) )
[line] => [extraparams] => Array ( )
[nbtodo] => [nbtodolate] => [specimen] => [fac_rec] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [lastname] => [firstname] => [name] => [nom] => [civility_id] => [array_options] => Array ( )
[linkedObjectsIds] => [linkedObjects] => [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [mode_reglement] => Traite [cond_reglement] => A réception de facture [cond_reglement_doc] => Réception de facture [user_author] => 1 [user_valid] => 1 )
)
[shipping] => Array ( [0] => Expedition Object ( [element] => shipping [fk_element] => fk_expedition [table_element] => expedition [ismultientitymanaged:protected] => 1 [id] => 1 [socid] => 1 [ref_customer] => [ref_ext] => [ref_int] => [brouillon] => 1 [entrepot_id] => [modelpdf] => rouget [origin] => commande [origin_id] => 2 [lines] => Array ( [0] => ExpeditionLigne Object ( [db] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[qty] => 1 [qty_shipped] => 1 [fk_product] => 417 [qty_asked] => 1 [libelle] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [product_desc] => [ref] => GA8A27201010VA1DT2DIR [remise_percent] => 0 [total_ht] => 0.00000000 [total_ttc] => 0.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [fk_origin_line] => 4 [origin_line_id] => 4 [entrepot_id] => [fk_product_type] => 0 [product_ref] => GA8A27201010VA1DT2DIR [product_label] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [label] => [description] => Nos fabrications sont conformes aux normes européennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tolérances dimensionnelles du fil EN 10218-2, Classe T1 * Revêtement Galvanisé EN 10244-2 * Tolérances mailles hexagonales EN 10223-3
(Code douane: 7326203000)
[weight] => 17 [weight_units] => [length] => [length_units] => [surface] => [surface_units] => [volume] => 2 [volume_units] => [desc] => Nos fabrications sont conformes aux normes européennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tolérances dimensionnelles du fil EN 10218-2, Classe T1 * Revêtement Galvanisé EN 10244-2 * Tolérances mailles hexagonales EN 10223-3
(Code douane: 7326203000)
[tva_tx] => 0.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [price] => 0 [subprice] => 0.00000000 )
[1] => ExpeditionLigne Object ( [db] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[qty] => 1 [qty_shipped] => 1 [fk_product] => [qty_asked] => 1 [libelle] => [product_desc] => [ref] => [remise_percent] => 0 [total_ht] => 1000.00000000 [total_ttc] => 1000.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [fk_origin_line] => 5 [origin_line_id] => 5 [entrepot_id] => [fk_product_type] => [product_ref] => [product_label] => [label] => [description] => tyersta zedazf zad [weight] => [weight_units] => [length] => [length_units] => [surface] => [surface_units] => [volume] => [volume_units] => [desc] => tyersta zedazf zad [tva_tx] => 0.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [price] => 1000 [subprice] => 1000.00000000 )
)
[shipping_method_id] => 2 [tracking_number] => 123456789 [tracking_url] => 123456789 [statut] => 0 [billed] => 0 [note_public] => Note publique qui apparaît dans les documents générés [note_private] => Note Privée [model_pdf] => [trueWeight] => 250 [weight_units] => 0 [trueWidth] => 1 [width_units] => 0 [trueHeight] => 1 [height_units] => 0 [trueDepth] => 0 [depth_units] => 0 [trueSize] => 0x1x1 [date_delivery] => 1383174000 [date_expedition] => [date_creation] => 1380269479 [date_valid] => [total_ht] => 2158.89 [total_ttc] => 2158.89 [total_tva] => 0 [total_localtax1] => 0 [total_localtax2] => 0 [listmeths] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [lastname] => [firstname] => [name] => [nom] => [civility_id] => [array_options] => Array ( )
[linkedObjectsIds] => [linkedObjects] => [products] => Array ( )
[statuts] => Array ( [-1] => StatusSendingCanceled [0] => StatusSendingDraft [1] => StatusSendingValidated [2] => StatusSendingProcessed )
[ref] => (PROV1) [user_author_id] => 1 [date] => [date_shipping] => [fk_delivery_address] => [size_units] => 0 [pdf_filename] => /var/www/maccaferri/dolibarr/documents/expedition/1/0//1.pdf [client] => Societe Object ( [element] => societe [table_element] => societe [fk_element] => fk_soc [childtables:protected] => Array ( [0] => propal [1] => commande [2] => facture [3] => contrat [4] => facture_fourn [5] => commande_fournisseur )
[ismultientitymanaged:protected] => 1 [id] => 1 [name] => ATM Consulting [nom] => ATM Consulting [firstname] => [lastname] => [particulier] => [civility_id] => [address] => 14 allée Edith Piaf [zip] => 26000 [town] => Valence [status] => 1 [state_id] => 28 [state_code] => 26 [state] => Drôme [departement_id] => [departement_code] => [departement] => [pays] => [country_id] => 1 [country_code] => FR [country] => France [tel] => [phone] => [fax] => [email] => [url] => [barcode] => [barcode_type] => [barcode_type_code] => [barcode_type_label] => [barcode_type_coder] => [idprof1] => [idprof2] => [idprof3] => [idprof4] => [idprof5] => [idprof6] => [prefix_comm] => [tva_assuj] => 1 [tva_intra] => [localtax1_assuj] => [localtax2_assuj] => [capital] => 0 [typent_id] => 0 [typent_code] => TE_UNKNOWN [effectif_id] => [forme_juridique_code] => [forme_juridique] => [remise_percent] => 0 [mode_reglement_id] => [cond_reglement_id] => [remise_client] => 0 [mode_reglement] => [cond_reglement] => [client] => 1 [prospect] => 0 [fournisseur] => 0 [code_client] => CL00001 [code_fournisseur] => [code_compta] => 411CL00001 [code_compta_fournisseur] => [note] => [note_private] => [note_public] => [stcomm_id] => 0 [statut_commercial] => Jamais contacté [price_level] => [datec] => 1377689978 [date_update] => 1378288912 [commercial_id] => [parent] => [default_lang] => [ref_int] => [import_key] => [logo] => [logo_small] => [logo_mini] => [array_options] => [oldcopy] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [linkedObjectsIds] => [linkedObjects] => [entity] => 1 [ref] => 1 [ref_ext] => [effectif] => [fk_prospectlevel] => )
[thirdparty] => Societe Object ( [element] => societe [table_element] => societe [fk_element] => fk_soc [childtables:protected] => Array ( [0] => propal [1] => commande [2] => facture [3] => contrat [4] => facture_fourn [5] => commande_fournisseur )
[ismultientitymanaged:protected] => 1 [id] => 1 [name] => ATM Consulting [nom] => ATM Consulting [firstname] => [lastname] => [particulier] => [civility_id] => [address] => 14 allée Edith Piaf [zip] => 26000 [town] => Valence [status] => 1 [state_id] => 28 [state_code] => 26 [state] => Drôme [departement_id] => [departement_code] => [departement] => [pays] => [country_id] => 1 [country_code] => FR [country] => France [tel] => [phone] => [fax] => [email] => [url] => [barcode] => [barcode_type] => [barcode_type_code] => [barcode_type_label] => [barcode_type_coder] => [idprof1] => [idprof2] => [idprof3] => [idprof4] => [idprof5] => [idprof6] => [prefix_comm] => [tva_assuj] => 1 [tva_intra] => [localtax1_assuj] => [localtax2_assuj] => [capital] => 0 [typent_id] => 0 [typent_code] => TE_UNKNOWN [effectif_id] => [forme_juridique_code] => [forme_juridique] => [remise_percent] => 0 [mode_reglement_id] => [cond_reglement_id] => [remise_client] => 0 [mode_reglement] => [cond_reglement] => [client] => 1 [prospect] => 0 [fournisseur] => 0 [code_client] => CL00001 [code_fournisseur] => [code_compta] => 411CL00001 [code_compta_fournisseur] => [note] => [note_private] => [note_public] => [stcomm_id] => 0 [statut_commercial] => Jamais contacté [price_level] => [datec] => 1377689978 [date_update] => 1378288912 [commercial_id] => [parent] => [default_lang] => [ref_int] => [import_key] => [logo] => [logo_small] => [logo_mini] => [array_options] => [oldcopy] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [linkedObjectsIds] => [linkedObjects] => [entity] => 1 [ref] => 1 [ref_ext] => [effectif] => [fk_prospectlevel] => )
)
)
[propal] => Array ( [0] => Propal Object ( [element] => propal [table_element] => propal [table_element_line] => propaldet [fk_element] => fk_propal [ismultientitymanaged:protected] => 1 [id] => 1 [socid] => 1 [client] => [contactid] => [fk_project] => 5 [author] => [ref] => PR1308-0001 [ref_client] => [statut] => 2 [datec] => 1377692182 [datev] => 1380201823 [date] => 1377640800 [datep] => 1377640800 [date_livraison] => [fin_validite] => 1378980000 [user_author_id] => 1 [user_valid_id] => 1 [user_close_id] => 1 [total_ht] => 3158.89000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => 3158.89000000 [price] => [tva] => [total] => 3158.89000000 [cond_reglement_id] => 1 [cond_reglement_code] => RECEP [mode_reglement_id] => 0 [mode_reglement_code] => [remise] => 0 [remise_percent] => [remise_absolue] => [note] => [note_private] => [note_public] => [fk_delivery_address] => [fk_address] => [address_type] => [address] => [availability_id] => 0 [availability_code] => [demand_reason_id] => 0 [demand_reason_code] => [products] => Array ( )
[extraparams] => Array ( )
[lines] => Array ( [0] => PropaleLigne Object ( [db] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [oldline] => [rowid] => 1 [fk_propal] => 1 [fk_parent_line] => [desc] => Nos fabrications sont conformes aux normes européennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tolérances dimensionnelles du fil EN 10218-2, Classe T1 * Revêtement Galvanisé EN 10244-2 * Tolérances mailles hexagonales EN 10223-3
(Code douane: 7326203000)
[fk_product] => 417 [product_type] => 0 [qty] => 1 [tva_tx] => 0.000 [subprice] => 0.00000000 [remise_percent] => 0 [fk_remise_except] => [rang] => 1 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => [special_code] => 0 [info_bits] => 0 [total_ht] => 0.00000000 [total_tva] => 0.00000000 [total_ttc] => 0.00000000 [remise] => [price] => 0 [ref] => GA8A27201010VA1DT2DIR [libelle] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [product_desc] => Nos fabrications sont conformes aux normes européennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tolérances dimensionnelles du fil EN 10218-2, Classe T1 * Revêtement Galvanisé EN 10244-2 * Tolérances mailles hexagonales EN 10223-3 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [date_start] => [date_end] => [skip_update_total] => [label] => [product_ref] => GA8A27201010VA1DT2DIR [product_label] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [fk_product_type] => 0 )
[1] => PropaleLigne Object ( [db] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [oldline] => [rowid] => 2 [fk_propal] => 1 [fk_parent_line] => [desc] => tyersta zedazf zad [fk_product] => [product_type] => 0 [qty] => 1 [tva_tx] => 0.000 [subprice] => 1000.00000000 [remise_percent] => 0 [fk_remise_except] => [rang] => 2 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => 100 [special_code] => 0 [info_bits] => 0 [total_ht] => 1000.00000000 [total_tva] => 0.00000000 [total_ttc] => 1000.00000000 [remise] => [price] => 1000 [ref] => [libelle] => [product_desc] => [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [date_start] => [date_end] => [skip_update_total] => [label] => [product_ref] => [product_label] => [fk_product_type] => )
)
[line] => [origin] => [origin_id] => [labelstatut] => Array ( [0] => Brouillon (à valider) [1] => Validée (propale ouverte) [2] => Signée (à facturer) [3] => Non signée (fermée) [4] => Facturée )
[labelstatut_short] => Array ( [0] => Brouillon [1] => Ouvert [2] => Signée [3] => Non signée [4] => Facturée )
[nbtodo] => [nbtodolate] => [specimen] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [lastname] => [firstname] => [name] => [nom] => [civility_id] => [array_options] => Array ( )
[linkedObjectsIds] => [linkedObjects] => [duree_validite] => 15 [modelpdf] => azur [statut_libelle] => Signée [date_creation] => 1377692182 [date_validation] => 1380201823 [availability] => [demand_reason] => [mode_reglement] => - [cond_reglement] => A réception de facture [cond_reglement_doc] => Réception de facture )
)
)
[remise] => 0 [products] => Array ( )
[billed] => 0 [mode_reglement] => Traite [cond_reglement] => A réception de facture [cond_reglement_doc] => Réception de facture [user_creation] => User Object ( [element] => user [table_element] => user [ismultientitymanaged:protected] => 1 [id] => 1 [ref] => 1 [ref_ext] => [ldap_sid] => [search_sid] => [lastname] => SuperAdmin [firstname] => [note] => [email] => support@atm-consulting.fr [job] => [signature] => [office_phone] => 04 26 78 17 81 [office_fax] => [user_mobile] => [admin] => 1 [login] => admin [entity] => 0 [pass] => 0868GOD!kiss [pass_indatabase] => 0868GOD!kiss [pass_indatabase_crypted] => cc0be3b45925645e52253be6eaeeb0ff [datec] => 1373280314 [datem] => 1373638502 [societe_id] => [contact_id] => [fk_member] => [fk_user] => [clicktodial_url] => [clicktodial_login] => [clicktodial_password] => [clicktodial_poste] => [datelastlogin] => 1386771108 [datepreviouslogin] => 1386769430 [statut] => 1 [photo] => [lang] => [rights] => stdClass Object ( [user] => stdClass Object ( [user] => stdClass Object ( )
[self] => stdClass Object ( )
)
)
[all_permissions_are_loaded] => 0 [_tab_loaded:User:private] => Array ( )
[conf] => stdClass Object ( )
[oldcopy] => [users] => [parentof] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [name] => [nom] => [civility_id] => [array_options] => Array ( )
[linkedObjectsIds] => [linkedObjects] => [liste_limit] => 0 [clicktodial_loaded] => 0 [ref_int] => [pass_temp] => [openid] => )
[user_validation] => User Object ( [element] => user [table_element] => user [ismultientitymanaged:protected] => 1 [id] => 1 [ref] => 1 [ref_ext] => [ldap_sid] => [search_sid] => [lastname] => SuperAdmin [firstname] => [note] => [email] => support@atm-consulting.fr [job] => [signature] => [office_phone] => 04 26 78 17 81 [office_fax] => [user_mobile] => [admin] => 1 [login] => admin [entity] => 0 [pass] => 0868GOD!kiss [pass_indatabase] => 0868GOD!kiss [pass_indatabase_crypted] => cc0be3b45925645e52253be6eaeeb0ff [datec] => 1373280314 [datem] => 1373638502 [societe_id] => [contact_id] => [fk_member] => [fk_user] => [clicktodial_url] => [clicktodial_login] => [clicktodial_password] => [clicktodial_poste] => [datelastlogin] => 1386771108 [datepreviouslogin] => 1386769430 [statut] => 1 [photo] => [lang] => [rights] => stdClass Object ( [user] => stdClass Object ( [user] => stdClass Object ( )
[self] => stdClass Object ( )
)
)
[all_permissions_are_loaded] => 0 [_tab_loaded:User:private] => Array ( )
[conf] => stdClass Object ( )
[oldcopy] => [users] => [parentof] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [name] => [nom] => [civility_id] => [array_options] => Array ( )
[linkedObjectsIds] => [linkedObjects] => [liste_limit] => 0 [clicktodial_loaded] => 0 [ref_int] => [pass_temp] => [openid] => )
[date_creation] => 1380201891 [date_modification] => 1380269479 [date_validation] => 1380201898 [date_cloture] => [total_ht_devise] => 2282.64844 [total_tva_devise] => 0 [total_ttc_devise] => )
[societe] => Societe Object ( [element] => societe [table_element] => societe [fk_element] => fk_soc [childtables:protected] => Array ( [0] => propal [1] => commande [2] => facture [3] => contrat [4] => facture_fourn [5] => commande_fournisseur )
[ismultientitymanaged:protected] => 1 [id] => 1 [name] => ATM Consulting [nom] => ATM Consulting [firstname] => [lastname] => [particulier] => [civility_id] => [address] => 14 allée Edith Piaf [zip] => 26000 [town] => Valence [status] => 1 [state_id] => 28 [state_code] => 26 [state] => Drôme [departement_id] => [departement_code] => [departement] => [pays] => [country_id] => 1 [country_code] => FR [country] => France [tel] => [phone] => [fax] => [email] => [url] => [barcode] => [barcode_type] => [barcode_type_code] => [barcode_type_label] => [barcode_type_coder] => [idprof1] => [idprof2] => [idprof3] => [idprof4] => [idprof5] => [idprof6] => [prefix_comm] => [tva_assuj] => 1 [tva_intra] => [localtax1_assuj] => [localtax2_assuj] => [capital] => 0 [typent_id] => 0 [typent_code] => TE_UNKNOWN [effectif_id] => [forme_juridique_code] => [forme_juridique] => [remise_percent] => 0 [mode_reglement_id] => [cond_reglement_id] => [remise_client] => 0 [mode_reglement] => [cond_reglement] => [client] => 1 [prospect] => 0 [fournisseur] => 0 [code_client] => CL00001 [code_fournisseur] => [code_compta] => 411CL00001 [code_compta_fournisseur] => [note] => [note_private] => [note_public] => [stcomm_id] => 0 [statut_commercial] => Jamais contacté [price_level] => [datec] => 1377689978 [date_update] => 1378288912 [commercial_id] => [parent] => [default_lang] => [ref_int] => [import_key] => [logo] => [logo_small] => [logo_mini] => [array_options] => [oldcopy] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [linkedObjectsIds] => [linkedObjects] => [entity] => 1 [ref] => 1 [ref_ext] => [effectif] => [fk_prospectlevel] => )
[mysoc] => Societe Object ( [element] => societe [table_element] => societe [fk_element] => fk_soc [childtables:protected] => Array ( [0] => propal [1] => commande [2] => facture [3] => contrat [4] => facture_fourn [5] => commande_fournisseur )
[ismultientitymanaged:protected] => 1 [id] => 0 [name] => Maccaferri Maghreb SARL [nom] => Maccaferri Maghreb SARL [firstname] => [lastname] => [particulier] => [civility_id] => [address] => 62 Boulevard d'Anfa
Résidence Bab Abdelaziz N°31
[zip] => 20000 [town] => Cassablanca [status] => 1 [state_id] => [state_code] => [state] => [departement_id] => [departement_code] => [departement] => [pays] => [country_id] => 12 [country_code] => MA [country] => Maroc [tel] => 00212665401256 [phone] => 00212665401256 [fax] => 00212522397317 [email] => [url] => http://www.maccaferri.ma [barcode] => [barcode_type] => [barcode_type_code] => [barcode_type_label] => [barcode_type_coder] => [idprof1] => 239489 [idprof2] => [idprof3] => 40417086 [idprof4] => 8811722 [idprof5] => [idprof6] => [prefix_comm] => [tva_assuj] => 1 [tva_intra] => [localtax1_assuj] => 0 [localtax2_assuj] => 0 [capital] => [typent_id] => 0 [typent_code] => [effectif_id] => 0 [forme_juridique_code] => [forme_juridique] => [remise_percent] => [mode_reglement_id] => [cond_reglement_id] => [remise_client] => [mode_reglement] => [cond_reglement] => [client] => 0 [prospect] => 0 [fournisseur] => 0 [code_client] => [code_fournisseur] => [code_compta] => [code_compta_fournisseur] => [note] => [note_private] => [note_public] => [stcomm_id] => [statut_commercial] => [price_level] => [datec] => [date_update] => [commercial_id] => [parent] => [default_lang] => [ref_int] => [import_key] => [logo] => 39830292.jpg [logo_small] => 39830292_small.jpg [logo_mini] => 39830292_mini.jpg [array_options] => [oldcopy] => [db:protected] => DoliDBMysqli Object ( [db] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.34-0ubuntu0.12.04.1 [server_version] => 50534 [stat] => Uptime: 195177 Threads: 1 Questions: 31645 Slow queries: 2 Opens: 20498 Flush tables: 1 Open tables: 400 Queries per second avg: 0.162 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2825 [warning_count] => 0 )
[type] => mysqli [forcecharset] => utf8 [forcecollate] => utf8_general_ci [_results:DoliDBMysqli:private] => mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 10 )
[num_rows] => 1 [type] => 0 )
[connected] => 1 [database_selected] => 1 [database_name] => dolibarr_maccaferri [database_user] => root [transaction_opened] => 0 [lastquery] => SELECT devise_mt_total
FROM llx_commande WHERE rowid = 2
[lastqueryerror] => [lasterror] => [lasterrno] => [ok] => 1 [error] => )
[error] => [errors] => [canvas] => [linkedObjectsIds] => [linkedObjects] => )
[tableau] => Array ( [0] => Array ( [error] => [oldline] => [rowid] => 4 [fk_parent_line] => [fk_facture] => [label] => [desc] => Nos fabrications sont conformes aux normes europ�ennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tol�rances dimensionnelles du fil EN 10218-2, Classe T1 * Rev�tement Galvanis� EN 10244-2 * Tol�rances mailles hexagonales EN 10223-3
(Code douane: 7326203000)
[fk_product] => 417 [product_type] => 0 [qty] => 1 [tva_tx] => 0.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [subprice] => 0.00000000 [remise_percent] => [fk_remise_except] => [rang] => 1 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => [info_bits] => 0 [special_code] => 0 [total_ht] => 0.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => 0.00000000 [remise] => [price] => 0 [ref] => GA8A27201010VA1DT2DIR [libelle] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [product_ref] => GA8A27201010VA1DT2DIR [product_label] => Gabion NF Acier maille 80x100 fil 2.70 mm GALMAC 2.00x1.00x1.00 m avec diaphragme detache [product_desc] => Nos fabrications sont conformes aux normes europ�ennes et internationales suivantes : * Charge de rupture et d'allongement EN 10016 & 10223-3 * Tol�rances dimensionnelles du fil EN 10218-2, Classe T1 * Rev�tement Galvanis� EN 10244-2 * Tol�rances mailles hexagonales EN 10223-3 [date_start] => [date_end] => [skip_update_total] => [id] => 4 [fk_commande] => 2 [commande_id] => 2 [fk_product_type] => 0 [devise_pu] => 0.00000 [devise_mt_ligne] => 0.00000 [unite] => )
[1] => Array ( [error] => [oldline] => [rowid] => 5 [fk_parent_line] => [fk_facture] => [label] => [desc] => tyersta zedazf zad [fk_product] => [product_type] => 0 [qty] => 1 [tva_tx] => 0.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [subprice] => 1000.00000000 [remise_percent] => [fk_remise_except] => [rang] => 2 [fk_fournprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => 100 [info_bits] => 0 [special_code] => 0 [total_ht] => 1000.00000000 [total_tva] => 0.00000000 [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => 1000.00000000 [remise] => [price] => 1000 [ref] => [libelle] => [product_ref] => [product_label] => tyersta zedazf zad [product_desc] => [date_start] => [date_end] => [skip_update_total] => [id] => 5 [fk_commande] => 2 [commande_id] => 2 [fk_product_type] => [devise_pu] => 89.46000 [devise_mt_ligne] => 89.46000 [unite] => )
)
[contact] => Array ( )
[autre] => Array ( [devise] => Euro [incoterm] => EXW - Ex Works, au départ non chargé, non dédouané sortie d'usine (uniquement adapté aux flux domestiques, nationaux) [date_commande_fr] => 11/12/2013 [date_livraison] => 31/10/2013 [projet] => )