2022-03-18 10:56:57 DEBUG 00.00.00.00 Removed file /home/iavb7835/dolibarrdata/dolibarr.log 2022-03-18 10:56:57 INFO 00.00.00.00 functions.lib::dol_mkdir: dir=/home/iavb7835/dolibarrdata/api/temp 2022-03-18 10:56:57 INFO 00.00.00.00 functions.lib::dol_mkdir: dir=/home/iavb7835/dolibarrdata/users/temp 2022-03-18 10:56:57 INFO 00.00.00.00 --- End access to /admin/tools/purge.php 2022-03-18 10:57:01 DEBUG 00.00.00.00 - This is an already logged session. _SESSION['dol_login']=dferrand _SESSION['dol_entity']=1 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, 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.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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 doli_user as u LEFT JOIN doli_c_country as c ON u.fk_country = c.rowid LEFT JOIN doli_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'dferrand' ORDER BY u.entity ASC 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM doli_extrafields WHERE elementtype = 'user' ORDER BY pos 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, fk_service FROM doli_user_extrafields WHERE fk_object = 1 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT param, value FROM doli_user_param WHERE fk_user = 1 AND entity = 1 2022-03-18 10:57:01 DEBUG 00.00.00.00 DefaultValues::fetchAll 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid,type,user_id,page,param,value FROM doli_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1)) 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_user_rights as ur, doli_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_usergroup_rights as gr, doli_usergroup_user as gu, doli_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2022-03-18 10:57:01 NOTICE 00.00.00.00 --- Access to POST /fourn/commande/card.php - action=addline, massaction= 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM doli_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 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM doli_extrafields WHERE elementtype = 'commande_fournisseur' ORDER BY pos 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetch 2022-03-18 10:57:01 DEBUG 00.00.00.00 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.total_tva, 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 delivery_date, 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_label, cr.libelle_facture as cond_reglement_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 doli_commande_fournisseur as c LEFT JOIN doli_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN doli_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN doli_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN doli_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=37 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetch get lines 2022-03-18 10:57:01 DEBUG 00.00.00.00 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, p.tobatch as product_tobatch, p.barcode as product_barcode, 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, pfp.rowid as fk_pfp, pfp.packaging, MAX(pfp.quantity) as max_qty FROM doli_commande_fournisseurdet as l LEFT JOIN doli_product as p ON l.fk_product = p.rowid LEFT JOIN doli_product_fournisseur_price as pfp ON pfp.entity IN (1) AND l.fk_product = pfp.fk_product and l.ref = pfp.ref_fourn AND pfp.fk_soc = 68 WHERE l.fk_commande = 37 AND l.qty >= pfp.quantity GROUP BY l.rowid HAVING max_qty = MAX(pfp.quantity) ORDER BY l.rang, l.rowid 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, 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.model_pdf, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_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, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM doli_societe as s LEFT JOIN doli_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN doli_c_country as c ON s.fk_pays = c.rowid LEFT JOIN doli_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN doli_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN doli_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN doli_c_regions as r ON d.fk_region = r.code_region LEFT JOIN doli_c_typent as te ON s.fk_typent = te.id LEFT JOIN doli_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 68 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM doli_extrafields WHERE elementtype = 'societe' ORDER BY pos 2022-03-18 10:57:01 DEBUG 00.00.00.00 BEGIN Transaction 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM doli_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2022-03-18 10:57:01 INFO 00.00.00.00 get_localtax tva=20 local=1 thirdparty_buyer id=0/country_code=FR thirdparty_seller id=68/country_code=FR thirdparty_seller localtax1_assuj= thirdparty_seller localtax2_assuj= 2022-03-18 10:57:01 INFO 00.00.00.00 get_localtax tva=20 local=2 thirdparty_buyer id=0/country_code=FR thirdparty_seller id=68/country_code=FR thirdparty_seller localtax1_assuj= thirdparty_seller localtax2_assuj= 2022-03-18 10:57:01 INFO 00.00.00.00 CommandeFournisseur::addline test3, 100, 1, 20, 0, 0, 0, 0, test3, 0, HT, , 0, , , , , , 0, , 0 2022-03-18 10:57:01 INFO 00.00.00.00 getLocalTaxesFromRate vatrate=20 local=0 2022-03-18 10:57:01 DEBUG 00.00.00.00 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 doli_c_tva as t, doli_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.taux = 20 AND t.active = 1 2022-03-18 10:57:01 INFO 00.00.00.00 get_localtax tva=20 local=1 thirdparty_buyer id=0/country_code=FR thirdparty_seller id=68/country_code=FR thirdparty_seller localtax1_assuj= thirdparty_seller localtax2_assuj= 2022-03-18 10:57:01 INFO 00.00.00.00 get_localtax tva=20 local=2 thirdparty_buyer id=0/country_code=FR thirdparty_seller id=68/country_code=FR thirdparty_seller localtax1_assuj= thirdparty_seller localtax2_assuj= 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total qty=1 pu=100 remise_percent_ligne=0 txtva=20 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=100 qty=1 price_base_type=HT total_ht=100-total_vat=20-total_ttc=120 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::line_max 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT max(rang) FROM doli_commande_fournisseurdet WHERE fk_commande = 37 2022-03-18 10:57:01 INFO 00.00.00.00 CommandeFournisseurLigne::insert rang=6 2022-03-18 10:57:01 DEBUG 00.00.00.00 MultiCurrency::getIdAndTxFromCode 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT m.rowid, mc.rate FROM doli_multicurrency m LEFT JOIN doli_multicurrency_rate mc ON (m.rowid = mc.fk_multicurrency) WHERE m.code = 'EUR' AND m.entity IN (1) ORDER BY mc.date_sync DESC LIMIT 1 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseurLigne::insert 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=INSERT INTO doli_commande_fournisseurdet (fk_commande, label, description, date_start, date_end, fk_product, product_type, special_code, rang, qty, vat_src_code, tva_tx, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice, ref, total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_unit, fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc) VALUES (37, '','test3', null, null,null,'0','0','6','1', '', 20, 0, 0, '0', '0', 0, 100, 'test3', 100, 20, 0, 0, 120,null, null, 'EUR', 100, 100, 20, 120) 2022-03-18 10:57:01 INFO 00.00.00.00 Mycyber executed by LINEORDER_SUPPLIER_CREATE::Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:98.0) Gecko/20100101 Firefox/98.0 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::update_price 2022-03-18 10:57:01 DEBUG 00.00.00.00 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 doli_commande_fournisseurdet WHERE fk_commande = 37 AND product_type <> 9 ORDER by rowid 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total qty=1 pu=10.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=10.00000000 qty=1 price_base_type=HT total_ht=10-total_vat=2-total_ttc=12 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total qty=1 pu=10.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=10.00000000 qty=1 price_base_type=HT total_ht=10-total_vat=2-total_ttc=12 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total qty=1 pu=10.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=10.00000000 qty=1 price_base_type=HT total_ht=10-total_vat=2-total_ttc=12 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total qty=1 pu=10.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=10.00000000 qty=1 price_base_type=HT total_ht=10-total_vat=2-total_ttc=12 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total qty=1 pu=10.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=10.00000000 qty=1 price_base_type=HT total_ht=10-total_vat=2-total_ttc=12 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total qty=1 pu=100.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type=0 progress=100 2022-03-18 10:57:01 INFO 00.00.00.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=100.00000000 qty=1 price_base_type=HT total_ht=100-total_vat=20-total_ttc=120 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::update_price 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=UPDATE doli_commande_fournisseur SET total_ht = 150, total_tva = 30, localtax1 = 0, localtax2 = 0, total_ttc = 180, multicurrency_total_ht = 150, multicurrency_total_tva = 30, multicurrency_total_ttc = 180 WHERE rowid = 37 2022-03-18 10:57:01 DEBUG 00.00.00.00 COMMIT Transaction 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetch 2022-03-18 10:57:01 DEBUG 00.00.00.00 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.total_tva, 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 delivery_date, 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_label, cr.libelle_facture as cond_reglement_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 doli_commande_fournisseur as c LEFT JOIN doli_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN doli_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN doli_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN doli_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=37 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetch get lines 2022-03-18 10:57:01 DEBUG 00.00.00.00 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, p.tobatch as product_tobatch, p.barcode as product_barcode, 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, pfp.rowid as fk_pfp, pfp.packaging, MAX(pfp.quantity) as max_qty FROM doli_commande_fournisseurdet as l LEFT JOIN doli_product as p ON l.fk_product = p.rowid LEFT JOIN doli_product_fournisseur_price as pfp ON pfp.entity IN (1) AND l.fk_product = pfp.fk_product and l.ref = pfp.ref_fourn AND pfp.fk_soc = 68 WHERE l.fk_commande = 37 AND l.qty >= pfp.quantity GROUP BY l.rowid HAVING max_qty = MAX(pfp.quantity) ORDER BY l.rang, l.rowid 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetch 2022-03-18 10:57:01 DEBUG 00.00.00.00 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.total_tva, 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 delivery_date, 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_label, cr.libelle_facture as cond_reglement_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 doli_commande_fournisseur as c LEFT JOIN doli_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN doli_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN doli_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN doli_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=37 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetch get lines 2022-03-18 10:57:01 DEBUG 00.00.00.00 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, p.tobatch as product_tobatch, p.barcode as product_barcode, 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, pfp.rowid as fk_pfp, pfp.packaging, MAX(pfp.quantity) as max_qty FROM doli_commande_fournisseurdet as l LEFT JOIN doli_product as p ON l.fk_product = p.rowid LEFT JOIN doli_product_fournisseur_price as pfp ON pfp.entity IN (1) AND l.fk_product = pfp.fk_product and l.ref = pfp.ref_fourn AND pfp.fk_soc = 68 WHERE l.fk_commande = 37 AND l.qty >= pfp.quantity GROUP BY l.rowid HAVING max_qty = MAX(pfp.quantity) ORDER BY l.rang, l.rowid 2022-03-18 10:57:01 INFO 00.00.00.00 commonGenerateDocument modele=muscadet outputlangs->defaultlang=fr_FR 2022-03-18 10:57:01 INFO 00.00.00.00 pdf_getFormat Get paper format with mode=setup MAIN_PDF_FORMAT=EUA4 outputlangs->defaultlang=null and langs->defaultlang=fr_FR 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT code, label, width, height, unit FROM doli_c_paper_format WHERE code = 'EUA4' 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, 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.model_pdf, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_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, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM doli_societe as s LEFT JOIN doli_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN doli_c_country as c ON s.fk_pays = c.rowid LEFT JOIN doli_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN doli_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN doli_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN doli_c_regions as r ON d.fk_region = r.code_region LEFT JOIN doli_c_typent as te ON s.fk_typent = te.id LEFT JOIN doli_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 68 2022-03-18 10:57:01 INFO 00.00.00.00 functions.lib::dol_mkdir: dir=/home/iavb7835/dolibarrdata/admin/temp/ 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetchObjectLink 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM doli_element_element WHERE (fk_source = 37 AND sourcetype = 'order_supplier') OR (fk_target = 37 AND targettype = 'order_supplier') ORDER BY sourcetype 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::getIdContact 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT ec.fk_socpeople FROM doli_element_contact as ec, doli_user as c, doli_c_type_contact as tc WHERE ec.element_id = 37 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 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::getIdContact 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT ec.fk_socpeople FROM doli_element_contact as ec, doli_socpeople as c, doli_c_type_contact as tc WHERE ec.element_id = 37 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 2022-03-18 10:57:01 DEBUG 00.00.00.00 Company.lib::getFormeJuridiqueLabel 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT libelle FROM doli_c_forme_juridique WHERE code='57' 2022-03-18 10:57:01 DEBUG 00.00.00.00 Translate::loadCacheCurrencies 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT code_iso, label, unicode FROM doli_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2022-03-18 10:57:01 INFO 00.00.00.00 dol_delete_file file=/home/iavb7835/dolibarrdata/fournisseur/commande/(PROV37)/(PROV37).pdf_preview.png disableglob=1 nophperrors=0 nohook=0 2022-03-18 10:57:01 DEBUG 00.00.00.00 HookManager::initHooks Loading hooks: context=fileslib-path=/mycyberoffice/class/actions_mycyberoffice.class.php 2022-03-18 10:57:01 DEBUG 00.00.00.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method ActionsMycyberoffice->deleteFile, context=fileslib, module=mycyberoffice, action= 2022-03-18 10:57:01 DEBUG 00.00.00.00 ActionsMycyberoffice::deleteFile:::: 2022-03-18 10:57:01 DEBUG 00.00.00.00 Removed file /home/iavb7835/dolibarrdata/fournisseur/commande/(PROV37)/(PROV37).pdf_preview.png 2022-03-18 10:57:01 DEBUG 00.00.00.00 EcmFiles::fetch 2022-03-18 10:57:01 DEBUG 00.00.00.00 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.tms as date_m, t.fk_user_c, t.fk_user_m, t.note_private, t.note_public, t.acl, t.src_object_type, t.src_object_id FROM doli_ecm_files as t WHERE 1 = 1 AND t.filepath = 'fournisseur/commande/(PROV37)' AND t.filename = '(PROV37).pdf' AND t.entity = 1 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM doli_extrafields WHERE elementtype = 'ecm_files' ORDER BY pos 2022-03-18 10:57:01 DEBUG 00.00.00.00 EcmFiles::update 2022-03-18 10:57:01 DEBUG 00.00.00.00 BEGIN Transaction 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=UPDATE doli_ecm_files SET ref = 'a0156d13b006651c362aa3571603f654', label = 'a142ec283ffc42aea7d32b5f61a3fe36', share = null, entity = 1, filename = '(PROV37).pdf', filepath = 'fournisseur/commande/(PROV37)', fullpath_orig = '', description = '', keywords = '', cover = null, position = 1, gen_or_uploaded = 'generated', extraparams = null, date_c = '2022-03-18 09:20:48', fk_user_m = 1, acl = null, src_object_id = 37, src_object_type = 'commande_fournisseur' WHERE rowid=3048 2022-03-18 10:57:01 INFO 00.00.00.00 Mycyber executed by ECMFILES_MODIFY::Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:98.0) Gecko/20100101 Firefox/98.0 2022-03-18 10:57:01 DEBUG 00.00.00.00 COMMIT Transaction 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=UPDATE doli_commande_fournisseur SET last_main_doc = 'fournisseur/commande/(PROV37)/(PROV37).pdf' WHERE rowid = 37 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetch 2022-03-18 10:57:01 DEBUG 00.00.00.00 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.total_tva, 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 delivery_date, 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_label, cr.libelle_facture as cond_reglement_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 doli_commande_fournisseur as c LEFT JOIN doli_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN doli_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN doli_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN doli_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=37 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetch get lines 2022-03-18 10:57:01 DEBUG 00.00.00.00 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, p.tobatch as product_tobatch, p.barcode as product_barcode, 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, pfp.rowid as fk_pfp, pfp.packaging, MAX(pfp.quantity) as max_qty FROM doli_commande_fournisseurdet as l LEFT JOIN doli_product as p ON l.fk_product = p.rowid LEFT JOIN doli_product_fournisseur_price as pfp ON pfp.entity IN (1) AND l.fk_product = pfp.fk_product and l.ref = pfp.ref_fourn AND pfp.fk_soc = 68 WHERE l.fk_commande = 37 AND l.qty >= pfp.quantity GROUP BY l.rowid HAVING max_qty = MAX(pfp.quantity) ORDER BY l.rang, l.rowid 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, 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.model_pdf, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_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, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM doli_societe as s LEFT JOIN doli_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN doli_c_country as c ON s.fk_pays = c.rowid LEFT JOIN doli_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN doli_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN doli_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN doli_c_regions as r ON d.fk_region = r.code_region LEFT JOIN doli_c_typent as te ON s.fk_typent = te.id LEFT JOIN doli_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 68 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, 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.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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 doli_user as u LEFT JOIN doli_c_country as c ON u.fk_country = c.rowid LEFT JOIN doli_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM doli_extrafields WHERE elementtype = 'user' ORDER BY pos 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, fk_service FROM doli_user_extrafields WHERE fk_object = 1 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::liste_contact 2022-03-18 10:57:01 DEBUG 00.00.00.00 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 doli_c_type_contact tc, doli_element_contact ec LEFT JOIN doli_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 37 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 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::liste_contact 2022-03-18 10:57:01 DEBUG 00.00.00.00 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 doli_c_type_contact tc, doli_element_contact ec LEFT JOIN doli_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 37 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 2022-03-18 10:57:01 INFO 00.00.00.00 files.lib.php::dol_dir_list path=/home/iavb7835/dolibarrdata/fournisseur/commande/(PROV37) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2022-03-18 10:57:01 DEBUG 00.00.00.00 HookManager::initHooks Loading hooks: context=fileslib-path=/mycyberoffice/class/actions_mycyberoffice.class.php 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT COUNT(rowid) as nb FROM doli_links WHERE objecttype = 'order_supplier' AND objectid = 37 AND entity = 1 2022-03-18 10:57:01 DEBUG 00.00.00.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method ActionsMycyberoffice->formConfirm, context=fileslib, module=mycyberoffice, action=, object id=37, object element=order_supplier 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT MAX(te.ref) FROM doli_commande_fournisseur as te WHERE te.ref < '(PROV37)' AND te.entity IN (1) 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT MIN(te.ref) FROM doli_commande_fournisseur as te WHERE te.ref > '(PROV37)' AND te.entity IN (1) 2022-03-18 10:57:01 DEBUG 00.00.00.00 DiscountAbsolute::getAvailableDiscounts discount_type=1 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM doli_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 = 68 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')) 2022-03-18 10:57:01 DEBUG 00.00.00.00 DiscountAbsolute::getAvailableDiscounts discount_type=1 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM doli_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 = 68 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%')) 2022-03-18 10:57:01 DEBUG 00.00.00.00 Form::load_cache_conditions_paiements 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, code, libelle as label FROM doli_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM doli_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2022-03-18 10:57:01 DEBUG 00.00.00.00 Form::select_produits_fournisseurs_list 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT p.rowid, p.ref, p.label, p.price, p.duration, p.fk_product_type, p.stock, pfp.ref_fourn, pfp.rowid as idprodfournprice, pfp.price as fprice, pfp.quantity, pfp.remise_percent, pfp.remise, pfp.unitprice, pfp.fk_supplier_price_expression, pfp.fk_product, pfp.tva_tx, pfp.default_vat_code, pfp.fk_soc, s.nom as name, pfp.supplier_reputation ,pfp.desc_fourn as description, pfp.barcode FROM doli_product as p LEFT JOIN doli_product_fournisseur_price as pfp ON ( p.rowid = pfp.fk_product AND pfp.entity IN (1) ) AND pfp.fk_soc = 68 LEFT JOIN doli_societe as s ON pfp.fk_soc = s.rowid WHERE p.entity IN (1) AND p.tobuy = 1 ORDER BY pfp.ref_fourn DESC, pfp.quantity ASC 2022-03-18 10:57:01 INFO 00.00.00.00 DolEditor::DolEditor htmlname=dp_desc width= height=100 toolbarname=dolibarr_details 2022-03-18 10:57:01 DEBUG 00.00.00.00 Form::load_cache_vatrates 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT DISTINCT t.rowid, t.code, t.taux, t.localtax1, t.localtax1_type, t.localtax2, t.localtax2_type, t.recuperableonly FROM doli_c_tva as t, doli_c_country as c WHERE t.fk_pays = c.rowid AND t.active > 0 AND c.code IN ('FR') ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT cc.code FROM doli_c_country as cc WHERE cc.eec = 1 2022-03-18 10:57:01 INFO 00.00.00.00 get_default_tva: seller use vat=1, seller country=FR, seller in cee=1, buyer vat number=FR56908617186 buyer country=FR, buyer in cee=1, idprod=0, idprodfournprice=0, SERVICE_ARE_ECOMMERCE_200238EC= 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT t.taux as vat_rate, t.code as default_vat_code FROM doli_c_tva as t, doli_c_country as c WHERE t.active=1 AND t.fk_pays = c.rowid AND c.code='FR' ORDER BY t.taux DESC, t.code ASC, t.recuperableonly ASC LIMIT 1 2022-03-18 10:57:01 INFO 00.00.00.00 get_product_vat_for_country: ret=20 2022-03-18 10:57:01 DEBUG 00.00.00.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method ActionsMycyberoffice->addMoreActionsButtons, context=fileslib, module=mycyberoffice, action=, object id=37, object element=order_supplier 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetchObjectLink 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM doli_element_element WHERE (fk_source = 37 AND sourcetype = 'order_supplier') OR (fk_target = 37 AND targettype = 'order_supplier') ORDER BY sourcetype 2022-03-18 10:57:01 DEBUG 00.00.00.00 HookManager::initHooks Loading hooks: context=formfile-path=/mycyberoffice/class/actions_mycyberoffice.class.php 2022-03-18 10:57:01 INFO 00.00.00.00 files.lib.php::dol_dir_list path=/home/iavb7835/dolibarrdata/fournisseur/commande/(PROV37) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2022-03-18 10:57:01 DEBUG 00.00.00.00 HookManager::initHooks Loading hooks: context=fileslib-path=/mycyberoffice/class/actions_mycyberoffice.class.php 2022-03-18 10:57:01 DEBUG 00.00.00.00 /core/lib/function2.lib.php::getListOfModels 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM doli_document_model WHERE type = 'order_supplier' AND entity IN (0,1) ORDER BY description DESC 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, tms as date_m, fk_user_c, fk_user_m, acl, position, share FROM doli_ecm_files WHERE entity = 1 AND filepath = 'fournisseur/commande/(PROV37)' 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM doli_societe as s, doli_propal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (68) AND t.entity IN (1) 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM doli_societe as s, doli_commande as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (68) AND t.entity IN (1) 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM doli_societe as s, doli_facture as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (68) AND t.entity IN (1) 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total_ht FROM doli_societe as s, doli_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (68) AND t.entity IN (1) 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, t.total_ht FROM doli_societe as s, doli_facture_fourn as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (68) AND t.entity IN (1) 2022-03-18 10:57:01 DEBUG 00.00.00.00 CommandeFournisseur::fetchObjectLink 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM doli_element_element WHERE (fk_source = 37 AND sourcetype = 'order_supplier') OR (fk_target = 37 AND targettype = 'order_supplier') ORDER BY sourcetype 2022-03-18 10:57:01 DEBUG 00.00.00.00 ActionComm::getActions 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT a.id FROM doli_actioncomm as a WHERE a.entity IN (1) AND a.fk_soc = 68 AND a.fk_element = 37 AND a.elementtype = 'order_supplier' ORDER BY a.datep DESC, a.id DESC 2022-03-18 10:57:01 DEBUG 00.00.00.00 CActionComm::liste_array 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT id, code, libelle as label, module, type, color, picto FROM doli_c_actioncomm WHERE 1=1 AND active=1 ORDER BY type, position, module 2022-03-18 10:57:01 INFO 00.00.00.00 --- End access to /fourn/commande/card.php 2022-03-18 10:57:01 DEBUG 00.00.00.00 - This is an already logged session. _SESSION['dol_login']=dferrand _SESSION['dol_entity']=1 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, 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.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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 doli_user as u LEFT JOIN doli_c_country as c ON u.fk_country = c.rowid LEFT JOIN doli_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'dferrand' ORDER BY u.entity ASC 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM doli_extrafields WHERE elementtype = 'user' ORDER BY pos 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid, fk_service FROM doli_user_extrafields WHERE fk_object = 1 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT param, value FROM doli_user_param WHERE fk_user = 1 AND entity = 1 2022-03-18 10:57:01 DEBUG 00.00.00.00 DefaultValues::fetchAll 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT rowid,type,user_id,page,param,value FROM doli_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1)) 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_user_rights as ur, doli_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2022-03-18 10:57:01 DEBUG 00.00.00.00 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_usergroup_rights as gr, doli_usergroup_user as gu, doli_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2022-03-18 10:57:01 NOTICE 00.00.00.00 --- Access to GET /viewimage.php - action=, massaction= NOTOKENRENEWAL=1 2022-03-18 10:57:01 INFO 00.00.00.00 dol_check_secure_access_document modulepart=apercusupplier_order original_file=(PROV37)/(PROV37).pdf_preview.png entity=1 2022-03-18 10:57:01 INFO 00.00.00.00 viewimage.php return file /home/iavb7835/dolibarrdata/fournisseur/commande/(PROV37)/(PROV37).pdf_preview.png filename=(PROV37).pdf_preview.png content-type=image/png 2022-03-18 10:57:01 INFO 00.00.00.00 --- End access to /viewimage.php