2021-01-25 22:14:08 DEBUG 93.45.84.67 - This is an already logged session. _SESSION['dol_login']=andrea _SESSION['dol_entity']=1 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'andrea' ORDER BY u.entity ASC 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 3 AND entity = 1 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 3) 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 3 AND r.perms IS NOT NULL 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 3 AND r.perms IS NOT NULL 2021-01-25 22:14:08 INFO 93.45.84.67 --- Access to /fourn/commande/card.php - action=updateline, massaction= 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='it_IT' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' ORDER BY pos 2021-01-25 22:14:08 DEBUG 93.45.84.67 CommandeFournisseur::fetch 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=45 2021-01-25 22:14:08 DEBUG 93.45.84.67 CommandeFournisseur::fetch get lines 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 45 ORDER BY l.rang, l.rowid 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 13 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2021-01-25 22:14:08 DEBUG 93.45.84.67 BEGIN Transaction 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT cd.rowid, cd.fk_commande, cd.fk_product, cd.product_type, cd.description, cd.qty, cd.tva_tx, cd.special_code, cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.ref, cd.remise, cd.remise_percent, cd.subprice, cd.info_bits, cd.total_ht, cd.total_tva, cd.total_ttc, cd.total_localtax1, cd.total_localtax2, p.ref as product_ref, p.label as product_libelle, p.description as product_desc, cd.date_start, cd.date_end, cd.fk_unit, cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc FROM llx_commande_fournisseurdet as cd LEFT JOIN llx_product as p ON cd.fk_product = p.rowid WHERE cd.rowid = 687 2021-01-25 22:14:08 INFO 93.45.84.67 get_localtax tva=22 local=1 thirdparty_buyer id=0/country_code=IT thirdparty_seller id=13/country_code=IT thirdparty_seller localtax1_assuj= thirdparty_seller localtax2_assuj= 2021-01-25 22:14:08 INFO 93.45.84.67 get_localtax tva=22 local=2 thirdparty_buyer id=0/country_code=IT thirdparty_seller id=13/country_code=IT thirdparty_seller localtax1_assuj= thirdparty_seller localtax2_assuj= 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2021-01-25 22:14:08 INFO 93.45.84.67 CommandeFournisseur::updateline 687, , 12.00, 1, 0, 22, HT, 0, 0, 2021-01-25 22:14:08 INFO 93.45.84.67 getLocalTaxesFromRate vatrate=22 local=0 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT t.taux as rate, t.code, t.localtax1, t.localtax1_type, t.localtax2, t.localtax2_type, t.accountancy_code_sell, t.accountancy_code_buy FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IT' AND t.taux = 22 AND t.active = 1 2021-01-25 22:14:08 INFO 93.45.84.67 get_localtax tva=22 local=1 thirdparty_buyer id=0/country_code=IT thirdparty_seller id=13/country_code=IT thirdparty_seller localtax1_assuj= thirdparty_seller localtax2_assuj= 2021-01-25 22:14:08 INFO 93.45.84.67 get_localtax tva=22 local=2 thirdparty_buyer id=0/country_code=IT thirdparty_seller id=13/country_code=IT thirdparty_seller localtax1_assuj= thirdparty_seller localtax2_assuj= 2021-01-25 22:14:08 INFO 93.45.84.67 Price.lib::calcul_price_total qty=1 pu=12 remise_percent_ligne=0 txtva=22 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2021-01-25 22:14:08 INFO 93.45.84.67 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=12 qty=1 price_base_type=HT total_ht=12-total_vat=2.64-total_ttc=14.64 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT cd.rowid, cd.fk_commande, cd.fk_product, cd.product_type, cd.description, cd.qty, cd.tva_tx, cd.special_code, cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.ref, cd.remise, cd.remise_percent, cd.subprice, cd.info_bits, cd.total_ht, cd.total_tva, cd.total_ttc, cd.total_localtax1, cd.total_localtax2, p.ref as product_ref, p.label as product_libelle, p.description as product_desc, cd.date_start, cd.date_end, cd.fk_unit, cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc FROM llx_commande_fournisseurdet as cd LEFT JOIN llx_product as p ON cd.fk_product = p.rowid WHERE cd.rowid = 687 2021-01-25 22:14:08 DEBUG 93.45.84.67 CommandeFournisseurLigne::updateline 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=UPDATE llx_commande_fournisseurdet SET description='', ref='', subprice='12', remise_percent='0', vat_src_code = '', tva_tx='22', localtax1_tx='0', localtax2_tx='0', localtax1_type='0', localtax2_type='0', qty='1', date_start=null, date_end=null, info_bits='0', total_ht='12', total_tva='2.64', total_localtax1='0', total_localtax2='0', total_ttc='14.64', product_type=0, special_code=0, fk_unit=null, multicurrency_subprice=12, multicurrency_total_ht=12, multicurrency_total_tva=2.64, multicurrency_total_ttc=14.64 WHERE rowid = 687 2021-01-25 22:14:08 DEBUG 93.45.84.67 CommandeFournisseur::update_price 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT rowid, qty, subprice as up, remise_percent, total_ht, total_tva as total_tva, total_ttc, total_localtax1 as total_localtax1, total_localtax2 as total_localtax2, tva_tx as vatrate, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, info_bits, product_type, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc FROM llx_commande_fournisseurdet WHERE fk_commande = 45 ORDER by rowid 2021-01-25 22:14:08 WARNING 93.45.84.67 Price.lib::calcul_price_total Warning: function is called with parameter seller that is missing 2021-01-25 22:14:08 INFO 93.45.84.67 Price.lib::calcul_price_total qty=1 pu=12.00000000 remise_percent_ligne=0 txtva=22.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2021-01-25 22:14:08 INFO 93.45.84.67 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=12.00000000 qty=1 price_base_type=HT total_ht=12-total_vat=2.64-total_ttc=14.64 2021-01-25 22:14:08 DEBUG 93.45.84.67 CommandeFournisseur::update_price 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=UPDATE llx_commande_fournisseur SET total_ht='12', tva='2.64', localtax1='0', localtax2='0', total_ttc='14.64', multicurrency_total_ht='12', multicurrency_total_tva='2.64', multicurrency_total_ttc='14.64' WHERE rowid = 45 2021-01-25 22:14:08 DEBUG 93.45.84.67 CommandeFournisseur::fetch 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=45 2021-01-25 22:14:08 DEBUG 93.45.84.67 CommandeFournisseur::fetch get lines 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 45 ORDER BY l.rang, l.rowid 2021-01-25 22:14:08 INFO 93.45.84.67 commonGenerateDocument modele=muscadet outputlangs->defaultlang=it_IT 2021-01-25 22:14:08 INFO 93.45.84.67 pdf_getFormat Get paper format with mode=setup MAIN_PDF_FORMAT=null outputlangs->defaultlang=null and langs->defaultlang=it_IT 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT code, label, width, height, unit FROM llx_c_paper_format WHERE code = 'EUA4' 2021-01-25 22:14:08 DEBUG 93.45.84.67 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 13 2021-01-25 22:14:08 INFO 93.45.84.67 functions.lib::dol_mkdir: dir=/opt/bitnami/dolibarr/documents/admin/temp/ 2021-01-25 22:14:37 DEBUG 95.237.77.116 CommandeFournisseur::fetchObjectLink 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 80 AND sourcetype = 'order_supplier') OR (fk_target = 80 AND targettype = 'order_supplier') ORDER BY sourcetype 2021-01-25 22:14:37 DEBUG 95.237.77.116 CommandeFournisseur::getIdContact 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT ec.fk_socpeople FROM llx_element_contact as ec, llx_user as c, llx_c_type_contact as tc WHERE ec.element_id = 80 AND ec.fk_socpeople = c.rowid AND c.entity IN (0,1) AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'order_supplier' AND tc.source = 'internal' AND tc.code = 'SALESREPFOLL' AND tc.active = 1 2021-01-25 22:14:37 DEBUG 95.237.77.116 CommandeFournisseur::getIdContact 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT ec.fk_socpeople FROM llx_element_contact as ec, llx_socpeople as c, llx_c_type_contact as tc WHERE ec.element_id = 80 AND ec.fk_socpeople = c.rowid AND c.entity IN (1) AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'order_supplier' AND tc.source = 'external' AND tc.code = 'CUSTOMER' AND tc.active = 1 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' ORDER BY pos 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2021-01-25 22:14:37 INFO 95.237.77.116 ProductFournisseur::fetch id=720 ref= ref_ext= 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 720 2021-01-25 22:14:37 INFO 95.237.77.116 ProductFournisseur::fetch id=721 ref= ref_ext= 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 721 2021-01-25 22:14:37 DEBUG 95.237.77.116 Company.lib::getFormeJuridiqueLabel 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT libelle FROM llx_c_forme_juridique WHERE code='305' 2021-01-25 22:14:37 DEBUG 95.237.77.116 EcmFiles::fetch 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT t.rowid, t.ref, t.label, t.share, t.entity, t.filename, t.filepath, t.fullpath_orig, t.description, t.keywords, t.cover, t.position, t.gen_or_uploaded, t.extraparams, t.date_c, t.date_m, t.fk_user_c, t.fk_user_m, t.acl, t.src_object_type, t.src_object_id FROM llx_ecm_files as t WHERE 1 = 1 AND t.filepath = 'fournisseur/commande/(PROV80)' AND t.filename = '(PROV80).pdf' AND t.entity = 1 2021-01-25 22:14:37 DEBUG 95.237.77.116 EcmFiles::update 2021-01-25 22:14:37 DEBUG 95.237.77.116 BEGIN Transaction 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=UPDATE llx_ecm_files SET ref = '0858ba663fa5a5ddff0bc1baef270e6d', label = '38d8f2ec9e8585d4231d2dc56b701c7a', share = null, entity = 1, filename = '(PROV80).pdf', filepath = 'fournisseur/commande/(PROV80)', fullpath_orig = '', description = '', keywords = null, cover = null, position = 1, gen_or_uploaded = 'generated', extraparams = null, date_c = '2021-01-25 22:11:32', fk_user_m = 2, acl = null, src_object_id = 80, src_object_type = 'commande_fournisseur' WHERE rowid=107 2021-01-25 22:14:37 DEBUG 95.237.77.116 COMMIT Transaction 2021-01-25 22:14:37 DEBUG 95.237.77.116 CommandeFournisseur::fetch 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=80 2021-01-25 22:14:37 DEBUG 95.237.77.116 CommandeFournisseur::fetch get lines 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 80 ORDER BY l.rang, l.rowid 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 2 ORDER BY u.entity ASC 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2021-01-25 22:14:37 DEBUG 95.237.77.116 CommandeFournisseur::liste_contact 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, '-1' as socid, t.statut as statuscontact, t.login, t.photo, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =80 AND ec.fk_c_type_contact=tc.rowid AND tc.element='order_supplier' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC 2021-01-25 22:14:37 DEBUG 95.237.77.116 CommandeFournisseur::liste_contact 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =80 AND ec.fk_c_type_contact=tc.rowid AND tc.element='order_supplier' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC 2021-01-25 22:14:37 INFO 95.237.77.116 files.lib.php::dol_dir_list path=/opt/bitnami/dolibarr/documents/fournisseur/commande/(PROV80) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'order_supplier' AND objectid = 80 AND entity = 1 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT MAX(te.ref) FROM llx_commande_fournisseur as te WHERE te.ref < '(PROV80)' AND te.entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT MIN(te.ref) FROM llx_commande_fournisseur as te WHERE te.ref > '(PROV80)' AND te.entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 DiscountAbsolute::getAvailableDiscounts discount_type=1 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')) 2021-01-25 22:14:37 DEBUG 95.237.77.116 DiscountAbsolute::getAvailableDiscounts discount_type=1 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%')) 2021-01-25 22:14:37 DEBUG 95.237.77.116 Form::load_cache_conditions_paiements 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2021-01-25 22:14:37 DEBUG 95.237.77.116 Form::load_cache_types_paiements 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 Translate::getLabelFromKey 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 Translate::getLabelFromKey 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'RIBA' AND entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 ProductFournisseur::find_min_price_product_fournisseur 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days ,pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.entity = 1 AND pfp.fk_product = 720 AND pfp.fk_soc = s.rowid AND s.status = 1 AND pfp.quantity <= 1 2021-01-25 22:14:37 INFO 95.237.77.116 ProductFournisseur::fetch id=1 ref= ref_ext= 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1 2021-01-25 22:14:37 DEBUG 95.237.77.116 ProductFournisseur::find_min_price_product_fournisseur 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days ,pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.entity = 1 AND pfp.fk_product = 721 AND pfp.fk_soc = s.rowid AND s.status = 1 AND pfp.quantity <= 1 2021-01-25 22:14:37 INFO 95.237.77.116 ProductFournisseur::fetch id=1 ref= ref_ext= 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1 2021-01-25 22:14:37 DEBUG 95.237.77.116 Translate::loadCacheCurrencies 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2021-01-25 22:14:37 INFO 95.237.77.116 Product::fetch id=720 ref= ref_ext= 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 720 2021-01-25 22:14:37 INFO 95.237.77.116 files.lib.php::dol_dir_list path=/opt/bitnami/dolibarr/documents/produit/ROGER_ROGKT217/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/ROGER_ROGKT217' AND entity = 1 2021-01-25 22:14:37 INFO 95.237.77.116 Product::fetch id=721 ref= ref_ext= 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 721 2021-01-25 22:14:37 INFO 95.237.77.116 files.lib.php::dol_dir_list path=/opt/bitnami/dolibarr/documents/produit/INTEGRA_AUTINTBLINKER-SLIM/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/INTEGRA_AUTINTBLINKER-SLIM' AND entity = 1 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2021-01-25 22:14:37 INFO 95.237.77.116 DolEditor::DolEditor htmlname=dp_desc width= height=100 toolbarname=dolibarr_details 2021-01-25 22:14:37 DEBUG 95.237.77.116 Form::load_cache_vatrates 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT DISTINCT t.rowid, t.code, t.taux, t.localtax1, t.localtax1_type, t.localtax2, t.localtax2_type, t.recuperableonly FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND t.active > 0 AND c.code IN ('IT') ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC 2021-01-25 22:14:37 INFO 95.237.77.116 get_default_tva: seller use vat=1, seller country=IT, seller in cee=1, buyer vat number=04463170169 buyer country=IT, buyer in cee=1, idprod=0, idprodfournprice=0, SERVICE_ARE_ECOMMERCE_200238EC= 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT t.taux as vat_rate, t.code as default_vat_code FROM llx_c_tva as t, llx_c_country as c WHERE t.active=1 AND t.fk_pays = c.rowid AND c.code='IT' ORDER BY t.taux DESC, t.code ASC, t.recuperableonly ASC LIMIT 1 2021-01-25 22:14:37 INFO 95.237.77.116 get_product_vat_for_country: ret=22 2021-01-25 22:14:37 DEBUG 95.237.77.116 CommandeFournisseur::fetchObjectLink 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 80 AND sourcetype = 'order_supplier') OR (fk_target = 80 AND targettype = 'order_supplier') ORDER BY sourcetype 2021-01-25 22:14:37 INFO 95.237.77.116 files.lib.php::dol_dir_list path=/opt/bitnami/dolibarr/documents/fournisseur/commande/(PROV80) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2021-01-25 22:14:37 DEBUG 95.237.77.116 /core/lib/function2.lib.php::getListOfModels 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'order_supplier' AND entity IN (0,1) ORDER BY description DESC 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llx_societe as s, llx_propal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llx_societe as s, llx_commande as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total as total_ht FROM llx_societe as s, llx_facture as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total as total_ht FROM llx_societe as s, llx_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2021-01-25 22:14:37 DEBUG 95.237.77.116 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref FROM llx_societe as s, llx_fichinter as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2021-01-25 22:14:38 DEBUG 95.237.77.116 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, '' as ref_supplier, t.total_ht FROM llx_societe as s, llx_supplier_proposal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2021-01-25 22:14:38 DEBUG 95.237.77.116 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, t.total_ht FROM llx_societe as s, llx_facture_fourn as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2021-01-25 22:14:38 DEBUG 95.237.77.116 CommandeFournisseur::fetchObjectLink 2021-01-25 22:14:38 DEBUG 95.237.77.116 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 80 AND sourcetype = 'order_supplier') OR (fk_target = 80 AND targettype = 'order_supplier') ORDER BY sourcetype 2021-01-25 22:14:38 DEBUG 95.237.77.116 ActionComm::getActions 2021-01-25 22:14:38 DEBUG 95.237.77.116 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_soc = 3 AND a.fk_element = 80 AND a.elementtype = 'order_supplier' ORDER BY a.datep DESC, a.id DESC 2021-01-25 22:14:38 INFO 95.237.77.116 --- End access to /fourn/commande/card.php