2019-09-19 17:01:15 DEBUG 00.000.000.00 - This is an already logged session. _SESSION['dol_login']=r.kerrinckx _SESSION['dol_entity']=1 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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_int, 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 = 'r.kerrinckx' ORDER BY u.entity ASC 2019-09-19 17:01:15 INFO 00.000.000.00 fetch_name_optionals_label elementtype=user 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 2 AND entity = 1 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 2) 2019-09-19 17:01:15 DEBUG 00.000.000.00 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= 2 AND r.perms IS NOT NULL 2019-09-19 17:01:15 DEBUG 00.000.000.00 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND r.perms IS NOT NULL 2019-09-19 17:01:15 INFO 00.000.000.00 --- Access to /compta/index.php - action=, massaction= 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-09-19 17:01:15 DEBUG 00.000.000.00 Menubase::menuLoad mymainmenu=billing myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-09-19 17:01:15 DEBUG 00.000.000.00 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 2019-09-19 17:01:15 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context toprightmenu: actions_ultimatepdf.class.php 2019-09-19 17:01:15 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsUltimatepdf, module=ultimatepdf, action= context=toprightmenu 2019-09-19 17:01:15 DEBUG 00.000.000.00 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2019-09-19 17:01:15 DEBUG 00.000.000.00 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2019-09-19 17:01:15 DEBUG 00.000.000.00 useLocalTax 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-09-19 17:01:15 DEBUG 00.000.000.00 useLocalTax 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT f.rowid, f.ref, f.datef as date, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.ref_client, f.type, s.nom as name, s.rowid as socid, s.email, s.code_client, s.code_compta, s.code_fournisseur, s.code_compta_fournisseur FROM llx_facture as f, llx_societe as s WHERE s.rowid = f.fk_soc AND f.fk_statut = 0 AND f.entity IN (1) 2019-09-19 17:01:15 DEBUG 00.000.000.00 Translate::loadCacheCurrencies 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT f.ref, f.rowid, f.total_ht, f.total_tva, f.total_ttc, f.type, f.ref_supplier, s.nom as name, s.rowid as socid, s.email, s.code_fournisseur, s.code_compta_fournisseur, cc.rowid as country_id, cc.code as country_code FROM llx_facture_fourn as f, llx_societe as s LEFT JOIN llx_c_country as cc ON cc.rowid = s.fk_pays WHERE s.rowid = f.fk_soc AND f.fk_statut = 0 AND f.entity IN (1) 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT f.rowid, f.ref, f.fk_statut, f.type, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.tms, f.date_lim_reglement as datelimite, s.nom as name, s.rowid as socid, s.code_client, s.code_compta, s.email, cc.rowid as country_id, cc.code as country_code, sum(pf.amount) as am FROM llx_societe as s LEFT JOIN llx_c_country as cc ON cc.rowid = s.fk_pays, llx_facture as f LEFT JOIN llx_paiement_facture as pf on f.rowid=pf.fk_facture WHERE s.rowid = f.fk_soc AND f.entity IN (1) GROUP BY f.rowid, f.ref, f.fk_statut, f.type, f.total, f.tva, f.total_ttc, f.paye, f.tms, f.date_lim_reglement, s.nom, s.rowid, s.code_client, s.code_compta, s.email, cc.rowid, cc.code ORDER BY f.tms DESC LIMIT 3 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/(PROV2815) types=files recursive=0 filter=\(PROV2815\)[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/(PROV2812) types=files recursive=0 filter=\(PROV2812\)[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1906-1923 types=files recursive=0 filter=FA1906\-1923[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT ff.rowid, ff.ref, ff.fk_statut, ff.libelle, ff.total_ht, ff.total_tva, ff.total_ttc, ff.tms, ff.paye, s.nom as name, s.rowid as socid, s.code_fournisseur, s.code_compta_fournisseur, SUM(pf.amount) as am FROM llx_societe as s, llx_facture_fourn as ff LEFT JOIN llx_paiementfourn_facturefourn as pf on ff.rowid=pf.fk_facturefourn WHERE s.rowid = ff.fk_soc AND ff.entity = 1 GROUP BY ff.rowid, ff.ref, ff.fk_statut, ff.libelle, ff.total_ht, ff.tva, ff.total_tva, ff.total_ttc, ff.tms, ff.paye, s.nom, s.rowid, s.code_fournisseur, s.code_compta_fournisseur ORDER BY ff.tms DESC LIMIT 3 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT c.rowid, c.amount, c.date_ech, c.paye, cc.libelle, SUM(pc.amount) as sumpaid FROM (llx_c_chargesociales as cc, llx_chargesociales as c) LEFT JOIN llx_paiementcharge as pc ON pc.fk_charge = c.rowid WHERE c.fk_type = cc.id AND c.entity = 1 AND c.paye = 0 GROUP BY c.rowid, c.amount, c.date_ech, c.paye, cc.libelle 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT sum(f.total) as tot_fht, sum(f.total_ttc) as tot_fttc, s.nom as name, s.email, s.rowid as socid, s.code_client, s.code_compta, c.rowid, c.ref, c.facture, c.fk_statut, c.total_ht, c.tva as total_tva, c.total_ttc, cc.rowid as country_id, cc.code as country_code FROM llx_societe as s LEFT JOIN llx_c_country as cc ON cc.rowid = s.fk_pays, llx_commande as c LEFT JOIN llx_element_element as el ON el.fk_source = c.rowid AND el.sourcetype = 'commande' LEFT JOIN llx_facture AS f ON el.fk_target = f.rowid AND el.targettype = 'facture' WHERE c.fk_soc = s.rowid AND c.entity = 1 AND c.fk_statut = 3 AND c.facture = 0 GROUP BY s.nom, s.email, s.rowid, s.code_client, s.code_compta, c.rowid, c.ref, c.facture, c.fk_statut, c.total_ht, c.tva, c.total_ttc, cc.rowid, cc.code 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/commande/CO1906-0171 types=files recursive=0 filter=CO1906\-0171[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/commande/CO1908-0199 types=files recursive=0 filter=CO1908\-0199[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/commande/CO1907-0192 types=files recursive=0 filter=CO1907\-0192[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/commande/CO1909-0207 types=files recursive=0 filter=CO1909\-0207[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT f.rowid, f.ref, f.fk_statut, f.datef, f.type, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.tms, f.date_lim_reglement as datelimite, s.nom as name, s.rowid as socid, s.email, s.code_client, s.code_compta, cc.rowid as country_id, cc.code as country_code, sum(pf.amount) as am FROM llx_societe as s LEFT JOIN llx_c_country as cc ON cc.rowid = s.fk_pays,llx_facture as f LEFT JOIN llx_paiement_facture as pf on f.rowid=pf.fk_facture WHERE s.rowid = f.fk_soc AND f.paye = 0 AND f.fk_statut = 1 AND f.entity IN (1) GROUP BY f.rowid, f.ref, f.fk_statut, f.datef, f.type, f.total, f.tva, f.total_ttc, f.paye, f.tms, f.date_lim_reglement, s.nom, s.rowid, s.email, s.code_client, s.code_compta, cc.rowid, cc.code ORDER BY f.datef ASC, f.ref ASC 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1905-1861 types=files recursive=0 filter=FA1905\-1861[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1905-1872 types=files recursive=0 filter=FA1905\-1872[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1906-1897 types=files recursive=0 filter=FA1906\-1897[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1906-1902 types=files recursive=0 filter=FA1906\-1902[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1908-1988 types=files recursive=0 filter=FA1908\-1988[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1907-1975 types=files recursive=0 filter=FA1907\-1975[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1908-2004 types=files recursive=0 filter=FA1908\-2004[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1908-2010 types=files recursive=0 filter=FA1908\-2010[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1908-2011 types=files recursive=0 filter=FA1908\-2011[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2044 types=files recursive=0 filter=FA1909\-2044[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2043 types=files recursive=0 filter=FA1909\-2043[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2045 types=files recursive=0 filter=FA1909\-2045[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2046 types=files recursive=0 filter=FA1909\-2046[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2047 types=files recursive=0 filter=FA1909\-2047[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2048 types=files recursive=0 filter=FA1909\-2048[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2049 types=files recursive=0 filter=FA1909\-2049[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2050 types=files recursive=0 filter=FA1909\-2050[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/FA1909-2051 types=files recursive=0 filter=FA1909\-2051[^\-]+ excludefilter="\\.meta$|\\.png$" 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT ff.rowid, ff.ref, ff.fk_statut, ff.libelle, ff.total_ht, ff.total_tva, ff.total_ttc, ff.paye, ff.date_lim_reglement, s.nom as name, s.rowid as socid, s.email, s.code_client, s.code_compta, s.code_fournisseur, s.code_compta_fournisseur, sum(pf.amount) as am FROM llx_societe as s, llx_facture_fourn as ff LEFT JOIN llx_paiementfourn_facturefourn as pf on ff.rowid=pf.fk_facturefourn WHERE s.rowid = ff.fk_soc AND ff.entity = 1 AND ff.paye = 0 AND ff.fk_statut = 1 GROUP BY ff.rowid, ff.ref, ff.fk_statut, ff.libelle, ff.total_ht, ff.tva, ff.total_tva, ff.total_ttc, ff.paye, ff.date_lim_reglement, s.nom, s.rowid, s.email, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur ORDER BY ff.date_lim_reglement ASC 2019-09-19 17:01:15 INFO 00.000.000.00 --- End access to /compta/index.php 2019-09-19 17:01:15 INFO 00.000.000.00 --- Access to /custom/ultimatepdf/css/ultimatepdf.css.php - action=, massaction= 2019-09-19 17:01:15 DEBUG 00.000.000.00 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-09-19 17:01:15 INFO 00.000.000.00 --- End access to /custom/ultimatepdf/css/ultimatepdf.css.php 2019-09-19 17:01:16 INFO 00.000.000.00 --- Access to /viewimage.php - action=, massaction= 2019-09-19 17:01:16 INFO 00.000.000.00 modulepart=mycompany original_file=logos/thumbs/2019-07 - Logo GroupeV2_mini.png entity=1 2019-09-19 17:01:16 INFO 00.000.000.00 viewimage.php return file /var/www/html/www.moi.com/dolibarr/documents/mycompany/logos/thumbs/2019-07 - Logo GroupeV2_mini.png filename=2019-07 - Logo GroupeV2_mini.png content-type=image/png 2019-09-19 17:01:16 INFO 00.000.000.00 --- End access to /viewimage.php 2019-09-19 17:01:20 DEBUG 00.000.000.00 - This is an already logged session. _SESSION['dol_login']=r.kerrinckx _SESSION['dol_entity']=1 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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_int, 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 = 'r.kerrinckx' ORDER BY u.entity ASC 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=user 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 2 AND entity = 1 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 2) 2019-09-19 17:01:20 DEBUG 00.000.000.00 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= 2 AND r.perms IS NOT NULL 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND r.perms IS NOT NULL 2019-09-19 17:01:20 INFO 00.000.000.00 --- Access to /compta/facture/card.php - action=, massaction= 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-09-19 17:01:20 DEBUG 00.000.000.00 Menubase::menuLoad mymainmenu=billing myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::fetch 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as libelle_incoterms FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=2812 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_facture_extrafields WHERE fk_object = 2812 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context invoicecard: actions_ultimatepdf.class.php 2019-09-19 17:01:20 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context invoicecard: actions_milestone.class.php 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context toprightmenu: actions_ultimatepdf.class.php 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:20 DEBUG 00.000.000.00 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2019-09-19 17:01:20 DEBUG 00.000.000.00 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2019-09-19 17:01:20 DEBUG 00.000.000.00 useLocalTax 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-09-19 17:01:20 DEBUG 00.000.000.00 useLocalTax 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::fetch 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as libelle_incoterms FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=2812 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_facture_extrafields WHERE fk_object = 2812 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:20 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:20 DEBUG 00.000.000.00 useRevenueStamp 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT COUNT(*) as nb FROM llx_c_revenuestamp as r, llx_c_country as c WHERE r.fk_pays = c.rowid AND c.code = 'FR' AND r.active = 1 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::getSommePaiement 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiement_facture WHERE fk_facture = 2812 2019-09-19 17:01:20 DEBUG 00.000.000.00 DiscountAbsolute::getSumCreditNotesUsed 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 2812 AND (f.type = 2 OR f.type = 0) 2019-09-19 17:01:20 DEBUG 00.000.000.00 DiscountAbsolute::getSumDepositsUsed 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 2812 AND f.type = 3 2019-09-19 17:01:20 DEBUG 00.000.000.00 DiscountAbsolute::getAvailableDiscounts discount_type=0 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 208 AND (fk_facture_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS RECEIVED)%')) 2019-09-19 17:01:20 DEBUG 00.000.000.00 DiscountAbsolute::getAvailableDiscounts discount_type=0 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 208 AND (fk_facture_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS RECEIVED)%')) 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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_int, 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 = 16 ORDER BY u.entity ASC 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=user 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_facture WHERE fk_facture_source = 2812 AND type < 2 ORDER BY fk_statut DESC 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::liste_contact 2019-09-19 17:01:20 DEBUG 00.000.000.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 llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =2812 AND ec.fk_c_type_contact=tc.rowid AND tc.element='facture' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::liste_contact 2019-09-19 17:01:20 DEBUG 00.000.000.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 llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =2812 AND ec.fk_c_type_contact=tc.rowid AND tc.element='facture' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT COUNT(pfd.rowid) as nb FROM llx_prelevement_facture_demande as pfd WHERE pfd.fk_facture = 2812 2019-09-19 17:01:20 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/(PROV2812) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'facture' AND objectid = 2812 AND entity = 1 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formConfirm of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT MAX(te.ref) FROM llx_facture as te WHERE te.ref < '(PROV2812)' AND te.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT MIN(te.ref) FROM llx_facture as te WHERE te.ref > '(PROV2812)' AND te.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_facture WHERE fk_facture_source = 2812 AND type = 2 2019-09-19 17:01:20 DEBUG 00.000.000.00 Form::load_cache_conditions_paiements 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2019-09-19 17:01:20 DEBUG 00.000.000.00 Form::load_cache_types_paiements 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PRO' AND entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'URI' AND entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CA' AND entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LOCM' AND entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LOCT' AND entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 Account::fetch 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT ba.rowid, ba.ref, ba.label, ba.bank, ba.number, ba.courant, ba.clos, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation, ba.proprio, ba.owner_address, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.fk_accountancy_journal, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, ba.datec as date_creation, ba.tms as date_update, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state , aj.code as accountancy_journal FROM llx_bank_account as ba LEFT JOIN llx_c_country as c ON ba.fk_pays = c.rowid LEFT JOIN llx_c_departements as d ON ba.state_id = d.rowid LEFT JOIN llx_accounting_journal as aj ON aj.rowid=ba.fk_accountancy_journal WHERE ba.entity IN (1) AND ba.rowid = 2 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=bank_account 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'bank_account' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:20 DEBUG 00.000.000.00 ActionsUltimatepdf::formObjectOptions 2019-09-19 17:01:20 DEBUG 00.000.000.00 ExtraFields:showOutputField:$type=sellist 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT code as rowid, label FROM llx_c_ultimatepdf_line WHERE code='0' 2019-09-19 17:01:20 DEBUG 00.000.000.00 ExtraFields:showOutputField:$type=sellist 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT code as rowid, label FROM llx_c_ultimatepdf_title WHERE code='0' 2019-09-19 17:01:20 DEBUG 00.000.000.00 Translate::loadCacheCurrencies 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT p.datep as dp, p.ref, p.num_paiement, p.rowid, p.fk_bank, c.code as payment_code, c.libelle as payment_label, pf.amount, ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal FROM llx_paiement_facture as pf, llx_paiement as p LEFT JOIN llx_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid WHERE pf.fk_facture = 2812 AND pf.fk_paiement = p.rowid AND p.entity IN (1) ORDER BY p.datep, p.tms 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_facture_source FROM llx_societe_remise_except as re WHERE fk_facture = 2812 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 Product::fetch id=1198 ref= ref_ext= 2019-09-19 17:01:20 DEBUG 00.000.000.00 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, 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_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 = 1198 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=product 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/produit/8/9/1198/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-09-19 17:01:20 DEBUG 00.000.000.00 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/8/9/1198/photos' AND entity = 1 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 Form::select_produits_list search product 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT p.rowid, p.label, p.ref, p.description, p.barcode, p.fk_product_type, p.price, p.price_ttc, p.price_base_type, p.tva_tx, p.duration, p.fk_price_expression, p.stock FROM llx_product as p WHERE p.entity IN (1) ORDER BY p.ref LIMIT 1000 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formCreateProductOptions of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 DolEditor::DolEditor htmlname=dp_desc width= height=100 toolbarname=dolibarr_details 2019-09-19 17:01:20 DEBUG 00.000.000.00 Form::load_cache_vatrates 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 ('FR') ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC 2019-09-19 17:01:20 INFO 00.000.000.00 get_default_tva: seller use vat=1, seller country=FR, seller in cee=1, buyer vat number= buyer country=FR, buyer in cee=1, idprod=0, idprodfournprice=0, SERVICE_ARE_ECOMMERCE_200238EC= 2019-09-19 17:01:20 DEBUG 00.000.000.00 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='FR' ORDER BY t.taux DESC, t.code ASC, t.recuperableonly ASC LIMIT 1 2019-09-19 17:01:20 INFO 00.000.000.00 get_product_vat_for_country: ret=20 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formAddObjectLine of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 INFO 00.000.000.00 DolEditor::DolEditor htmlname=milestone_desc width= height=100 toolbarname=dolibarr_details 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:20 DEBUG 00.000.000.00 DiscountAbsolute::fetch 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT sr.rowid, sr.fk_soc, sr.discount_type, sr.fk_user, sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx, sr.multicurrency_amount_ht, sr.multicurrency_amount_tva, sr.multicurrency_amount_ttc, sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source, sr.fk_invoice_supplier_line, sr.fk_invoice_supplier, sr.fk_invoice_supplier_source, sr.description, sr.datec, f.ref as ref_facture_source, fsup.ref as ref_invoice_supplier_source FROM llx_societe_remise_except as sr LEFT JOIN llx_facture as f ON sr.fk_facture_source = f.rowid LEFT JOIN llx_facture as fsup ON sr.fk_invoice_supplier_source = fsup.rowid WHERE sr.entity = 1 AND sr.fk_facture_source=2812 2019-09-19 17:01:20 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/(PROV2812) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2019-09-19 17:01:20 DEBUG 00.000.000.00 /core/lib/function2.lib.php::getListOfModels 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice' AND entity IN (0,1) ORDER BY description DESC 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:20 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, '' as total_ht FROM llx_societe as s, llx_contrat as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (208) AND t.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 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_commande_fournisseur as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (208) AND t.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:20 DEBUG 00.000.000.00 Facture::fetchObjectLink 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 2812 AND sourcetype = 'facture') OR (fk_target = 2812 AND targettype = 'facture') ORDER BY sourcetype 2019-09-19 17:01:20 DEBUG 00.000.000.00 Commande::fetch 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT c.rowid, c.entity, c.date_creation, c.ref, c.fk_soc, c.fk_user_author, c.fk_user_valid, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_tva, c.localtax1 as total_localtax1, c.localtax2 as total_localtax2, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_availability, c.fk_input_reason, c.fk_account, c.date_commande, c.date_valid, c.tms, c.date_livraison, c.fk_shipping_method, c.fk_warehouse, c.fk_projet as fk_project, c.remise_percent, c.remise, c.remise_absolue, c.source, c.facture as billed, c.note_private, c.note_public, c.ref_client, c.ref_ext, c.ref_int, c.model_pdf, c.last_main_doc, c.fk_delivery_address, c.extraparams, c.fk_incoterms, c.location_incoterms, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, c.module_source, c.pos_source, i.libelle as libelle_incoterms, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, ca.code as availability_code, ca.label as availability_label, dr.code as demand_reason_code FROM llx_commande 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_availability as ca ON c.fk_availability = ca.rowid LEFT JOIN llx_c_input_reason as dr ON c.fk_input_reason = dr.rowid LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=174 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commande 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_commande_extrafields WHERE fk_object = 174 2019-09-19 17:01:20 DEBUG 00.000.000.00 Commande::fetch_lines 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 174 ORDER BY l.rang, l.rowid 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 Expedition::fetch 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT e.rowid, e.ref, e.fk_soc as socid, e.date_creation, e.ref_customer, e.ref_ext, e.ref_int, e.fk_user_author, e.fk_statut, e.fk_projet as fk_project, e.billed, e.date_valid, e.weight, e.weight_units, e.size, e.size_units, e.width, e.height, e.date_expedition as date_expedition, e.model_pdf, e.fk_address, e.date_delivery, e.fk_shipping_method, e.tracking_number, e.note_private, e.note_public, e.fk_incoterms, e.location_incoterms, i.libelle as libelle_incoterms, s.libelle as shipping_method, el.fk_source as origin_id, el.sourcetype as origin FROM llx_expedition as e LEFT JOIN llx_element_element as el ON el.fk_target = e.rowid AND el.targettype = 'shipping' LEFT JOIN llx_c_incoterms as i ON e.fk_incoterms = i.rowid LEFT JOIN llx_c_shipment_mode as s ON e.fk_shipping_method = s.rowid WHERE e.entity IN (1) AND e.rowid=191 2019-09-19 17:01:20 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:20 INFO 00.000.000.00 fetch_name_optionals_label elementtype=expedition 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'expedition' ORDER BY pos 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_expedition_extrafields WHERE fk_object = 191 2019-09-19 17:01:20 DEBUG 00.000.000.00 Expedition::fetch_lines 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT cd.rowid, cd.fk_product, cd.label as custom_label, cd.description, cd.qty as qty_asked, cd.product_type, cd.total_ht, cd.total_localtax1, cd.total_localtax2, cd.total_ttc, cd.total_tva, cd.vat_src_code, cd.tva_tx, cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.info_bits, cd.price, cd.subprice, cd.remise_percent,cd.buy_price_ht as pa_ht, cd.fk_multicurrency, cd.multicurrency_code, cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc, ed.rowid as line_id, ed.qty as qty_shipped, ed.fk_origin_line, ed.fk_entrepot, p.ref as product_ref, p.label as product_label, p.fk_product_type, p.weight, p.weight_units, p.length, p.length_units, p.surface, p.surface_units, p.volume, p.volume_units, p.tobatch as product_tobatch FROM llx_expeditiondet as ed, llx_commandedet as cd LEFT JOIN llx_product as p ON p.rowid = cd.fk_product WHERE ed.fk_expedition = 191 AND ed.fk_origin_line = cd.rowid ORDER BY cd.rang, ed.fk_origin_line 2019-09-19 17:01:20 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:20 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:20 INFO 00.000.000.00 Price.lib::calcul_price_total qty=2 pu=66.62000000 remise_percent_ligne=50 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:20 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=66.62000000 qty=2 price_base_type=HT total_ht=66.62-total_vat=13.32-total_ttc=79.94 2019-09-19 17:01:20 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:20 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:20 INFO 00.000.000.00 Price.lib::calcul_price_total qty=6 pu=66.62000000 remise_percent_ligne=50 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:20 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=66.62000000 qty=6 price_base_type=HT total_ht=199.86-total_vat=39.97-total_ttc=239.83 2019-09-19 17:01:20 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:20 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:20 INFO 00.000.000.00 Price.lib::calcul_price_total qty=3 pu=92.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:20 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=92.00000000 qty=3 price_base_type=HT total_ht=276-total_vat=55.2-total_ttc=331.2 2019-09-19 17:01:20 DEBUG 00.000.000.00 ActionComm::getActions 2019-09-19 17:01:20 DEBUG 00.000.000.00 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 2812 AND a.elementtype = 'invoice' ORDER BY a.datep DESC, a.id DESC 2019-09-19 17:01:20 INFO 00.000.000.00 --- End access to /compta/facture/card.php 2019-09-19 17:01:21 INFO 00.000.000.00 --- Access to /custom/ultimatepdf/css/ultimatepdf.css.php - action=, massaction= 2019-09-19 17:01:21 DEBUG 00.000.000.00 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-09-19 17:01:21 INFO 00.000.000.00 --- End access to /custom/ultimatepdf/css/ultimatepdf.css.php 2019-09-19 17:01:21 INFO 00.000.000.00 --- Access to /viewimage.php - action=, massaction= 2019-09-19 17:01:21 INFO 00.000.000.00 modulepart=mycompany original_file=logos/thumbs/2019-07 - Logo GroupeV2_mini.png entity=1 2019-09-19 17:01:21 INFO 00.000.000.00 viewimage.php return file /var/www/html/www.moi.com/dolibarr/documents/mycompany/logos/thumbs/2019-07 - Logo GroupeV2_mini.png filename=2019-07 - Logo GroupeV2_mini.png content-type=image/png 2019-09-19 17:01:21 INFO 00.000.000.00 --- End access to /viewimage.php 2019-09-19 17:01:25 DEBUG 00.000.000.00 - This is an already logged session. _SESSION['dol_login']=r.kerrinckx _SESSION['dol_entity']=1 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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_int, 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 = 'r.kerrinckx' ORDER BY u.entity ASC 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=user 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 2 AND entity = 1 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 2) 2019-09-19 17:01:25 DEBUG 00.000.000.00 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= 2 AND r.perms IS NOT NULL 2019-09-19 17:01:25 DEBUG 00.000.000.00 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND r.perms IS NOT NULL 2019-09-19 17:01:25 INFO 00.000.000.00 --- Access to /compta/facture/card.php - action=valid, massaction= 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-09-19 17:01:25 DEBUG 00.000.000.00 Menubase::menuLoad mymainmenu=billing myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-09-19 17:01:25 DEBUG 00.000.000.00 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 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::fetch 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as libelle_incoterms FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=2812 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_facture_extrafields WHERE fk_object = 2812 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context invoicecard: actions_ultimatepdf.class.php 2019-09-19 17:01:25 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context invoicecard: actions_milestone.class.php 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsUltimatepdf, module=ultimatepdf, action=valid context=invoicecard 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsMilestone, module=milestone, action=valid context=invoicecard 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::fetch 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as libelle_incoterms FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=2812 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_facture_extrafields WHERE fk_object = 2812 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context toprightmenu: actions_ultimatepdf.class.php 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:25 DEBUG 00.000.000.00 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2019-09-19 17:01:25 DEBUG 00.000.000.00 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2019-09-19 17:01:25 DEBUG 00.000.000.00 useLocalTax 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-09-19 17:01:25 DEBUG 00.000.000.00 useLocalTax 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::fetch 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as libelle_incoterms FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=2812 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_facture_extrafields WHERE fk_object = 2812 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:25 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:25 DEBUG 00.000.000.00 useRevenueStamp 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT COUNT(*) as nb FROM llx_c_revenuestamp as r, llx_c_country as c WHERE r.fk_pays = c.rowid AND c.code = 'FR' AND r.active = 1 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::getSommePaiement 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiement_facture WHERE fk_facture = 2812 2019-09-19 17:01:25 DEBUG 00.000.000.00 DiscountAbsolute::getSumCreditNotesUsed 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 2812 AND (f.type = 2 OR f.type = 0) 2019-09-19 17:01:25 DEBUG 00.000.000.00 DiscountAbsolute::getSumDepositsUsed 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 2812 AND f.type = 3 2019-09-19 17:01:25 DEBUG 00.000.000.00 DiscountAbsolute::getAvailableDiscounts discount_type=0 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 208 AND (fk_facture_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS RECEIVED)%')) 2019-09-19 17:01:25 DEBUG 00.000.000.00 DiscountAbsolute::getAvailableDiscounts discount_type=0 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 208 AND (fk_facture_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS RECEIVED)%')) 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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_int, 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 = 16 ORDER BY u.entity ASC 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=user 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_facture WHERE fk_facture_source = 2812 AND type < 2 ORDER BY fk_statut DESC 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::liste_contact 2019-09-19 17:01:25 DEBUG 00.000.000.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 llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =2812 AND ec.fk_c_type_contact=tc.rowid AND tc.element='facture' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::liste_contact 2019-09-19 17:01:25 DEBUG 00.000.000.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 llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =2812 AND ec.fk_c_type_contact=tc.rowid AND tc.element='facture' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT COUNT(pfd.rowid) as nb FROM llx_prelevement_facture_demande as pfd WHERE pfd.fk_facture = 2812 2019-09-19 17:01:25 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/(PROV2812) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'facture' AND objectid = 2812 AND entity = 1 2019-09-19 17:01:25 DEBUG 00.000.000.00 Call getNextNumRef with FACTURE_ADDON = mod_facture_terre, thirdparty=C.C.H.L.E.M, type=TE_ADMIN 2019-09-19 17:01:25 DEBUG 00.000.000.00 mod_facture_terre::getNextValue mode=next 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT MAX(CAST(SUBSTRING(ref FROM 8) AS SIGNED)) as max FROM llx_facture WHERE ref LIKE 'FA____-%' AND entity IN (1) 2019-09-19 17:01:25 INFO 00.000.000.00 mod_facture_terre::getNextValue return FA1909-2052 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formConfirm of class ActionsMilestone, module=milestone, action=valid context=invoicecard 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT MAX(te.ref) FROM llx_facture as te WHERE te.ref < '(PROV2812)' AND te.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT MIN(te.ref) FROM llx_facture as te WHERE te.ref > '(PROV2812)' AND te.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_facture WHERE fk_facture_source = 2812 AND type = 2 2019-09-19 17:01:25 DEBUG 00.000.000.00 Form::load_cache_conditions_paiements 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2019-09-19 17:01:25 DEBUG 00.000.000.00 Form::load_cache_types_paiements 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PRO' AND entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'URI' AND entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CA' AND entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LOCM' AND entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LOCT' AND entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 Account::fetch 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT ba.rowid, ba.ref, ba.label, ba.bank, ba.number, ba.courant, ba.clos, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation, ba.proprio, ba.owner_address, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.fk_accountancy_journal, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, ba.datec as date_creation, ba.tms as date_update, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state , aj.code as accountancy_journal FROM llx_bank_account as ba LEFT JOIN llx_c_country as c ON ba.fk_pays = c.rowid LEFT JOIN llx_c_departements as d ON ba.state_id = d.rowid LEFT JOIN llx_accounting_journal as aj ON aj.rowid=ba.fk_accountancy_journal WHERE ba.entity IN (1) AND ba.rowid = 2 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=bank_account 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'bank_account' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsUltimatepdf, module=ultimatepdf, action=valid context=invoicecard 2019-09-19 17:01:25 DEBUG 00.000.000.00 ActionsUltimatepdf::formObjectOptions 2019-09-19 17:01:25 DEBUG 00.000.000.00 ExtraFields:showOutputField:$type=sellist 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT code as rowid, label FROM llx_c_ultimatepdf_line WHERE code='0' 2019-09-19 17:01:25 DEBUG 00.000.000.00 ExtraFields:showOutputField:$type=sellist 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT code as rowid, label FROM llx_c_ultimatepdf_title WHERE code='0' 2019-09-19 17:01:25 DEBUG 00.000.000.00 Translate::loadCacheCurrencies 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT p.datep as dp, p.ref, p.num_paiement, p.rowid, p.fk_bank, c.code as payment_code, c.libelle as payment_label, pf.amount, ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal FROM llx_paiement_facture as pf, llx_paiement as p LEFT JOIN llx_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid WHERE pf.fk_facture = 2812 AND pf.fk_paiement = p.rowid AND p.entity IN (1) ORDER BY p.datep, p.tms 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_facture_source FROM llx_societe_remise_except as re WHERE fk_facture = 2812 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=valid context=invoicecard 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=valid context=invoicecard 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=valid context=invoicecard 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=valid context=invoicecard 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=valid context=invoicecard 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=valid context=invoicecard 2019-09-19 17:01:25 INFO 00.000.000.00 Product::fetch id=1198 ref= ref_ext= 2019-09-19 17:01:25 DEBUG 00.000.000.00 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, 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_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 = 1198 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=product 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/produit/8/9/1198/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-09-19 17:01:25 DEBUG 00.000.000.00 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/8/9/1198/photos' AND entity = 1 2019-09-19 17:01:25 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/(PROV2812) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2019-09-19 17:01:25 DEBUG 00.000.000.00 /core/lib/function2.lib.php::getListOfModels 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice' AND entity IN (0,1) ORDER BY description DESC 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:25 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:25 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, '' as total_ht FROM llx_societe as s, llx_contrat as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (208) AND t.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 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_commande_fournisseur as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (208) AND t.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:25 DEBUG 00.000.000.00 Facture::fetchObjectLink 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 2812 AND sourcetype = 'facture') OR (fk_target = 2812 AND targettype = 'facture') ORDER BY sourcetype 2019-09-19 17:01:25 DEBUG 00.000.000.00 Commande::fetch 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT c.rowid, c.entity, c.date_creation, c.ref, c.fk_soc, c.fk_user_author, c.fk_user_valid, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_tva, c.localtax1 as total_localtax1, c.localtax2 as total_localtax2, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_availability, c.fk_input_reason, c.fk_account, c.date_commande, c.date_valid, c.tms, c.date_livraison, c.fk_shipping_method, c.fk_warehouse, c.fk_projet as fk_project, c.remise_percent, c.remise, c.remise_absolue, c.source, c.facture as billed, c.note_private, c.note_public, c.ref_client, c.ref_ext, c.ref_int, c.model_pdf, c.last_main_doc, c.fk_delivery_address, c.extraparams, c.fk_incoterms, c.location_incoterms, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, c.module_source, c.pos_source, i.libelle as libelle_incoterms, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, ca.code as availability_code, ca.label as availability_label, dr.code as demand_reason_code FROM llx_commande 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_availability as ca ON c.fk_availability = ca.rowid LEFT JOIN llx_c_input_reason as dr ON c.fk_input_reason = dr.rowid LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=174 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commande 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_commande_extrafields WHERE fk_object = 174 2019-09-19 17:01:25 DEBUG 00.000.000.00 Commande::fetch_lines 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 174 ORDER BY l.rang, l.rowid 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 Expedition::fetch 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT e.rowid, e.ref, e.fk_soc as socid, e.date_creation, e.ref_customer, e.ref_ext, e.ref_int, e.fk_user_author, e.fk_statut, e.fk_projet as fk_project, e.billed, e.date_valid, e.weight, e.weight_units, e.size, e.size_units, e.width, e.height, e.date_expedition as date_expedition, e.model_pdf, e.fk_address, e.date_delivery, e.fk_shipping_method, e.tracking_number, e.note_private, e.note_public, e.fk_incoterms, e.location_incoterms, i.libelle as libelle_incoterms, s.libelle as shipping_method, el.fk_source as origin_id, el.sourcetype as origin FROM llx_expedition as e LEFT JOIN llx_element_element as el ON el.fk_target = e.rowid AND el.targettype = 'shipping' LEFT JOIN llx_c_incoterms as i ON e.fk_incoterms = i.rowid LEFT JOIN llx_c_shipment_mode as s ON e.fk_shipping_method = s.rowid WHERE e.entity IN (1) AND e.rowid=191 2019-09-19 17:01:25 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:25 INFO 00.000.000.00 fetch_name_optionals_label elementtype=expedition 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'expedition' ORDER BY pos 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_expedition_extrafields WHERE fk_object = 191 2019-09-19 17:01:25 DEBUG 00.000.000.00 Expedition::fetch_lines 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT cd.rowid, cd.fk_product, cd.label as custom_label, cd.description, cd.qty as qty_asked, cd.product_type, cd.total_ht, cd.total_localtax1, cd.total_localtax2, cd.total_ttc, cd.total_tva, cd.vat_src_code, cd.tva_tx, cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.info_bits, cd.price, cd.subprice, cd.remise_percent,cd.buy_price_ht as pa_ht, cd.fk_multicurrency, cd.multicurrency_code, cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc, ed.rowid as line_id, ed.qty as qty_shipped, ed.fk_origin_line, ed.fk_entrepot, p.ref as product_ref, p.label as product_label, p.fk_product_type, p.weight, p.weight_units, p.length, p.length_units, p.surface, p.surface_units, p.volume, p.volume_units, p.tobatch as product_tobatch FROM llx_expeditiondet as ed, llx_commandedet as cd LEFT JOIN llx_product as p ON p.rowid = cd.fk_product WHERE ed.fk_expedition = 191 AND ed.fk_origin_line = cd.rowid ORDER BY cd.rang, ed.fk_origin_line 2019-09-19 17:01:25 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:25 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:25 INFO 00.000.000.00 Price.lib::calcul_price_total qty=2 pu=66.62000000 remise_percent_ligne=50 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:25 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=66.62000000 qty=2 price_base_type=HT total_ht=66.62-total_vat=13.32-total_ttc=79.94 2019-09-19 17:01:25 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:25 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:25 INFO 00.000.000.00 Price.lib::calcul_price_total qty=6 pu=66.62000000 remise_percent_ligne=50 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:25 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=66.62000000 qty=6 price_base_type=HT total_ht=199.86-total_vat=39.97-total_ttc=239.83 2019-09-19 17:01:25 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:25 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:25 INFO 00.000.000.00 Price.lib::calcul_price_total qty=3 pu=92.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:25 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=92.00000000 qty=3 price_base_type=HT total_ht=276-total_vat=55.2-total_ttc=331.2 2019-09-19 17:01:25 DEBUG 00.000.000.00 ActionComm::getActions 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 2812 AND a.elementtype = 'invoice' ORDER BY a.datep DESC, a.id DESC 2019-09-19 17:01:25 INFO 00.000.000.00 --- End access to /compta/facture/card.php 2019-09-19 17:01:25 INFO 00.000.000.00 --- Access to /custom/ultimatepdf/css/ultimatepdf.css.php - action=, massaction= 2019-09-19 17:01:25 DEBUG 00.000.000.00 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-09-19 17:01:25 INFO 00.000.000.00 --- End access to /custom/ultimatepdf/css/ultimatepdf.css.php 2019-09-19 17:01:26 INFO 00.000.000.00 --- Access to /viewimage.php - action=, massaction= 2019-09-19 17:01:26 INFO 00.000.000.00 modulepart=mycompany original_file=logos/thumbs/2019-07 - Logo GroupeV2_mini.png entity=1 2019-09-19 17:01:26 INFO 00.000.000.00 viewimage.php return file /var/www/html/www.moi.com/dolibarr/documents/mycompany/logos/thumbs/2019-07 - Logo GroupeV2_mini.png filename=2019-07 - Logo GroupeV2_mini.png content-type=image/png 2019-09-19 17:01:26 INFO 00.000.000.00 --- End access to /viewimage.php 2019-09-19 17:01:28 DEBUG 00.000.000.00 - This is an already logged session. _SESSION['dol_login']=r.kerrinckx _SESSION['dol_entity']=1 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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_int, 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 = 'r.kerrinckx' ORDER BY u.entity ASC 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=user 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 2 AND entity = 1 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 2) 2019-09-19 17:01:28 DEBUG 00.000.000.00 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= 2 AND r.perms IS NOT NULL 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND r.perms IS NOT NULL 2019-09-19 17:01:28 INFO 00.000.000.00 --- Access to /compta/facture/card.php - action=confirm_valid, massaction= 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-09-19 17:01:28 DEBUG 00.000.000.00 Menubase::menuLoad mymainmenu=billing myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetch 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as libelle_incoterms FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=2812 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_facture_extrafields WHERE fk_object = 2812 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context invoicecard: actions_ultimatepdf.class.php 2019-09-19 17:01:28 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context invoicecard: actions_milestone.class.php 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsUltimatepdf, module=ultimatepdf, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetch 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as libelle_incoterms FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=2812 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_facture_extrafields WHERE fk_object = 2812 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:28 INFO 00.000.000.00 Facture::validate user=2, force_number=, idwarehouse= 2019-09-19 17:01:28 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 BEGIN Transaction 2019-09-19 17:01:28 DEBUG 00.000.000.00 Call getNextNumRef with FACTURE_ADDON = mod_facture_terre, thirdparty=C.C.H.L.E.M, type=TE_ADMIN 2019-09-19 17:01:28 DEBUG 00.000.000.00 mod_facture_terre::getNextValue mode=next 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT MAX(CAST(SUBSTRING(ref FROM 8) AS SIGNED)) as max FROM llx_facture WHERE ref LIKE 'FA____-%' AND entity IN (1) 2019-09-19 17:01:28 INFO 00.000.000.00 mod_facture_terre::getNextValue return FA1909-2052 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::update_price 2019-09-19 17:01:28 DEBUG 00.000.000.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, situation_percent, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc FROM llx_facturedet WHERE fk_facture = 2812 AND product_type <> 9 ORDER by rowid 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::update_price 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=UPDATE llx_facture SET total='542.48', tva='108.49', localtax1='0', localtax2='0', total_ttc='650.97', multicurrency_total_ht='542.48', multicurrency_total_tva='108.49', multicurrency_total_ttc='650.97' WHERE rowid = 2812 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::validate 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=UPDATE llx_facture SET ref='FA1909-2052', fk_statut = 1, fk_user_valid = 2, date_valid = '2019-09-19 17:01:28' WHERE rowid = 2812 2019-09-19 17:01:28 ERR 00.000.000.00 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 'facnumber' in 'NEW' 2019-09-19 17:01:28 ERR 00.000.000.00 Error url=/compta/facture/card.php?facid=2812&action=confirm_valid&confirm=yes&token=a7319a1afeda54374bede5e027c526ba, query_string=facid=2812&action=confirm_valid&confirm=yes&token=a7319a1afeda54374bede5e027c526ba, sql=UPDATE llx_facture SET ref='FA1909-2052', fk_statut = 1, fk_user_valid = 2, date_valid = '2019-09-19 17:01:28' WHERE rowid = 2812, db_error=Unknown column 'facnumber' in 'NEW' 2019-09-19 17:01:28 DEBUG 00.000.000.00 ROLLBACK Transaction 2019-09-19 17:01:28 WARNING 00.000.000.00 Try to add a message in stack with empty message 2019-09-19 17:01:28 INFO 00.000.000.00 HookManager::initHooks Loading hook class for context toprightmenu: actions_ultimatepdf.class.php 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:28 DEBUG 00.000.000.00 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2019-09-19 17:01:28 DEBUG 00.000.000.00 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2019-09-19 17:01:28 DEBUG 00.000.000.00 useLocalTax 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-09-19 17:01:28 DEBUG 00.000.000.00 useLocalTax 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetch 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as libelle_incoterms FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=2812 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_facture_extrafields WHERE fk_object = 2812 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facture 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:28 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:28 DEBUG 00.000.000.00 useRevenueStamp 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT COUNT(*) as nb FROM llx_c_revenuestamp as r, llx_c_country as c WHERE r.fk_pays = c.rowid AND c.code = 'FR' AND r.active = 1 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::getSommePaiement 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiement_facture WHERE fk_facture = 2812 2019-09-19 17:01:28 DEBUG 00.000.000.00 DiscountAbsolute::getSumCreditNotesUsed 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 2812 AND (f.type = 2 OR f.type = 0) 2019-09-19 17:01:28 DEBUG 00.000.000.00 DiscountAbsolute::getSumDepositsUsed 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 2812 AND f.type = 3 2019-09-19 17:01:28 DEBUG 00.000.000.00 DiscountAbsolute::getAvailableDiscounts discount_type=0 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 208 AND (fk_facture_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS RECEIVED)%')) 2019-09-19 17:01:28 DEBUG 00.000.000.00 DiscountAbsolute::getAvailableDiscounts discount_type=0 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 208 AND (fk_facture_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS RECEIVED)%')) 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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_int, 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 = 16 ORDER BY u.entity ASC 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=user 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_facture WHERE fk_facture_source = 2812 AND type < 2 ORDER BY fk_statut DESC 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::liste_contact 2019-09-19 17:01:28 DEBUG 00.000.000.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 llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =2812 AND ec.fk_c_type_contact=tc.rowid AND tc.element='facture' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::liste_contact 2019-09-19 17:01:28 DEBUG 00.000.000.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 llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =2812 AND ec.fk_c_type_contact=tc.rowid AND tc.element='facture' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT COUNT(pfd.rowid) as nb FROM llx_prelevement_facture_demande as pfd WHERE pfd.fk_facture = 2812 2019-09-19 17:01:28 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/(PROV2812) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'facture' AND objectid = 2812 AND entity = 1 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formConfirm of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT MAX(te.ref) FROM llx_facture as te WHERE te.ref < '(PROV2812)' AND te.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT MIN(te.ref) FROM llx_facture as te WHERE te.ref > '(PROV2812)' AND te.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid FROM llx_facture WHERE fk_facture_source = 2812 AND type = 2 2019-09-19 17:01:28 DEBUG 00.000.000.00 Form::load_cache_conditions_paiements 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2019-09-19 17:01:28 DEBUG 00.000.000.00 Form::load_cache_types_paiements 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PRO' AND entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'URI' AND entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CA' AND entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LOCM' AND entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 Translate::getLabelFromKey 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LOCT' AND entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 Account::fetch 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT ba.rowid, ba.ref, ba.label, ba.bank, ba.number, ba.courant, ba.clos, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation, ba.proprio, ba.owner_address, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.fk_accountancy_journal, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, ba.datec as date_creation, ba.tms as date_update, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state , aj.code as accountancy_journal FROM llx_bank_account as ba LEFT JOIN llx_c_country as c ON ba.fk_pays = c.rowid LEFT JOIN llx_c_departements as d ON ba.state_id = d.rowid LEFT JOIN llx_accounting_journal as aj ON aj.rowid=ba.fk_accountancy_journal WHERE ba.entity IN (1) AND ba.rowid = 2 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=bank_account 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'bank_account' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsUltimatepdf, module=ultimatepdf, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 DEBUG 00.000.000.00 ActionsUltimatepdf::formObjectOptions 2019-09-19 17:01:28 DEBUG 00.000.000.00 ExtraFields:showOutputField:$type=sellist 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT code as rowid, label FROM llx_c_ultimatepdf_line WHERE code='0' 2019-09-19 17:01:28 DEBUG 00.000.000.00 ExtraFields:showOutputField:$type=sellist 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT code as rowid, label FROM llx_c_ultimatepdf_title WHERE code='0' 2019-09-19 17:01:28 DEBUG 00.000.000.00 Translate::loadCacheCurrencies 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT p.datep as dp, p.ref, p.num_paiement, p.rowid, p.fk_bank, c.code as payment_code, c.libelle as payment_label, pf.amount, ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal FROM llx_paiement_facture as pf, llx_paiement as p LEFT JOIN llx_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid WHERE pf.fk_facture = 2812 AND pf.fk_paiement = p.rowid AND p.entity IN (1) ORDER BY p.datep, p.tms 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_facture_source FROM llx_societe_remise_except as re WHERE fk_facture = 2812 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetch_lines 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.situation_percent, l.fk_prev_id, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 2812 ORDER BY l.rang, l.rowid 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 INFO 00.000.000.00 Product::fetch id=1198 ref= ref_ext= 2019-09-19 17:01:28 DEBUG 00.000.000.00 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, 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_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 = 1198 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=product 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/produit/8/9/1198/photos/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-09-19 17:01:28 DEBUG 00.000.000.00 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/8/9/1198/photos' AND entity = 1 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=facturedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 Form::select_produits_list search product 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT p.rowid, p.label, p.ref, p.description, p.barcode, p.fk_product_type, p.price, p.price_ttc, p.price_base_type, p.tva_tx, p.duration, p.fk_price_expression, p.stock FROM llx_product as p WHERE p.entity IN (1) ORDER BY p.ref LIMIT 1000 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formCreateProductOptions of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:28 INFO 00.000.000.00 DolEditor::DolEditor htmlname=dp_desc width= height=100 toolbarname=dolibarr_details 2019-09-19 17:01:28 DEBUG 00.000.000.00 Form::load_cache_vatrates 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 ('FR') ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC 2019-09-19 17:01:28 INFO 00.000.000.00 get_default_tva: seller use vat=1, seller country=FR, seller in cee=1, buyer vat number= buyer country=FR, buyer in cee=1, idprod=0, idprodfournprice=0, SERVICE_ARE_ECOMMERCE_200238EC= 2019-09-19 17:01:28 DEBUG 00.000.000.00 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='FR' ORDER BY t.taux DESC, t.code ASC, t.recuperableonly ASC LIMIT 1 2019-09-19 17:01:28 INFO 00.000.000.00 get_product_vat_for_country: ret=20 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formAddObjectLine of class ActionsMilestone, module=milestone, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 INFO 00.000.000.00 DolEditor::DolEditor htmlname=milestone_desc width= height=100 toolbarname=dolibarr_details 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsUltimatepdf, module=ultimatepdf, action=confirm_valid context=invoicecard 2019-09-19 17:01:28 DEBUG 00.000.000.00 DiscountAbsolute::fetch 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT sr.rowid, sr.fk_soc, sr.discount_type, sr.fk_user, sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx, sr.multicurrency_amount_ht, sr.multicurrency_amount_tva, sr.multicurrency_amount_ttc, sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source, sr.fk_invoice_supplier_line, sr.fk_invoice_supplier, sr.fk_invoice_supplier_source, sr.description, sr.datec, f.ref as ref_facture_source, fsup.ref as ref_invoice_supplier_source FROM llx_societe_remise_except as sr LEFT JOIN llx_facture as f ON sr.fk_facture_source = f.rowid LEFT JOIN llx_facture as fsup ON sr.fk_invoice_supplier_source = fsup.rowid WHERE sr.entity = 1 AND sr.fk_facture_source=2812 2019-09-19 17:01:28 INFO 00.000.000.00 files.lib.php::dol_dir_list path=/var/www/html/www.moi.com/dolibarr/documents/facture/(PROV2812) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2019-09-19 17:01:28 DEBUG 00.000.000.00 /core/lib/function2.lib.php::getListOfModels 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice' AND entity IN (0,1) ORDER BY description DESC 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsUltimatepdf, module=ultimatepdf, action= context=invoicecard 2019-09-19 17:01:28 DEBUG 00.000.000.00 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsMilestone, module=milestone, action= context=invoicecard 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, '' as total_ht FROM llx_societe as s, llx_contrat as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (208) AND t.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 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_commande_fournisseur as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (208) AND t.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 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 (208) AND t.entity IN (1) 2019-09-19 17:01:28 DEBUG 00.000.000.00 Facture::fetchObjectLink 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 2812 AND sourcetype = 'facture') OR (fk_target = 2812 AND targettype = 'facture') ORDER BY sourcetype 2019-09-19 17:01:28 DEBUG 00.000.000.00 Commande::fetch 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT c.rowid, c.entity, c.date_creation, c.ref, c.fk_soc, c.fk_user_author, c.fk_user_valid, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_tva, c.localtax1 as total_localtax1, c.localtax2 as total_localtax2, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_availability, c.fk_input_reason, c.fk_account, c.date_commande, c.date_valid, c.tms, c.date_livraison, c.fk_shipping_method, c.fk_warehouse, c.fk_projet as fk_project, c.remise_percent, c.remise, c.remise_absolue, c.source, c.facture as billed, c.note_private, c.note_public, c.ref_client, c.ref_ext, c.ref_int, c.model_pdf, c.last_main_doc, c.fk_delivery_address, c.extraparams, c.fk_incoterms, c.location_incoterms, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, c.module_source, c.pos_source, i.libelle as libelle_incoterms, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, ca.code as availability_code, ca.label as availability_label, dr.code as demand_reason_code FROM llx_commande 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_availability as ca ON c.fk_availability = ca.rowid LEFT JOIN llx_c_input_reason as dr ON c.fk_input_reason = dr.rowid LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=174 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commande 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_commande_extrafields WHERE fk_object = 174 2019-09-19 17:01:28 DEBUG 00.000.000.00 Commande::fetch_lines 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.weight, p.weight_units, p.volume, p.volume_units FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 174 ORDER BY l.rang, l.rowid 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=commandedet 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commandedet' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 Expedition::fetch 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT e.rowid, e.ref, e.fk_soc as socid, e.date_creation, e.ref_customer, e.ref_ext, e.ref_int, e.fk_user_author, e.fk_statut, e.fk_projet as fk_project, e.billed, e.date_valid, e.weight, e.weight_units, e.size, e.size_units, e.width, e.height, e.date_expedition as date_expedition, e.model_pdf, e.fk_address, e.date_delivery, e.fk_shipping_method, e.tracking_number, e.note_private, e.note_public, e.fk_incoterms, e.location_incoterms, i.libelle as libelle_incoterms, s.libelle as shipping_method, el.fk_source as origin_id, el.sourcetype as origin FROM llx_expedition as e LEFT JOIN llx_element_element as el ON el.fk_target = e.rowid AND el.targettype = 'shipping' LEFT JOIN llx_c_incoterms as i ON e.fk_incoterms = i.rowid LEFT JOIN llx_c_shipment_mode as s ON e.fk_shipping_method = s.rowid WHERE e.entity IN (1) AND e.rowid=191 2019-09-19 17:01:28 DEBUG 00.000.000.00 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 208 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=societe 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, aa99 FROM llx_societe_extrafields WHERE fk_object = 208 2019-09-19 17:01:28 INFO 00.000.000.00 fetch_name_optionals_label elementtype=expedition 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'expedition' ORDER BY pos 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT rowid, newline, newtitle FROM llx_expedition_extrafields WHERE fk_object = 191 2019-09-19 17:01:28 DEBUG 00.000.000.00 Expedition::fetch_lines 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT cd.rowid, cd.fk_product, cd.label as custom_label, cd.description, cd.qty as qty_asked, cd.product_type, cd.total_ht, cd.total_localtax1, cd.total_localtax2, cd.total_ttc, cd.total_tva, cd.vat_src_code, cd.tva_tx, cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.info_bits, cd.price, cd.subprice, cd.remise_percent,cd.buy_price_ht as pa_ht, cd.fk_multicurrency, cd.multicurrency_code, cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc, ed.rowid as line_id, ed.qty as qty_shipped, ed.fk_origin_line, ed.fk_entrepot, p.ref as product_ref, p.label as product_label, p.fk_product_type, p.weight, p.weight_units, p.length, p.length_units, p.surface, p.surface_units, p.volume, p.volume_units, p.tobatch as product_tobatch FROM llx_expeditiondet as ed, llx_commandedet as cd LEFT JOIN llx_product as p ON p.rowid = cd.fk_product WHERE ed.fk_expedition = 191 AND ed.fk_origin_line = cd.rowid ORDER BY cd.rang, ed.fk_origin_line 2019-09-19 17:01:28 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:28 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:28 INFO 00.000.000.00 Price.lib::calcul_price_total qty=2 pu=66.62000000 remise_percent_ligne=50 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:28 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=66.62000000 qty=2 price_base_type=HT total_ht=66.62-total_vat=13.32-total_ttc=79.94 2019-09-19 17:01:28 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:28 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:28 INFO 00.000.000.00 Price.lib::calcul_price_total qty=6 pu=66.62000000 remise_percent_ligne=50 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:28 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=66.62000000 qty=6 price_base_type=HT total_ht=199.86-total_vat=39.97-total_ttc=239.83 2019-09-19 17:01:28 INFO 00.000.000.00 get_localtax tva=20.000 local=1 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:28 INFO 00.000.000.00 get_localtax tva=20.000 local=2 thirdparty_buyer id=208/country_code=FR thirdparty_seller id=0/country_code=FR thirdparty_seller localtax1_assuj=0 thirdparty_seller localtax2_assuj=0 2019-09-19 17:01:28 INFO 00.000.000.00 Price.lib::calcul_price_total qty=3 pu=92.00000000 remise_percent_ligne=0 txtva=20.000 uselocaltax1_rate=0 uselocaltax2_rate=0 remise_percent_global=0 price_base_type=HT type= progress=100 2019-09-19 17:01:28 INFO 00.000.000.00 Price.lib::calcul_price_total MAIN_ROUNDING_RULE_TOT= pu=92.00000000 qty=3 price_base_type=HT total_ht=276-total_vat=55.2-total_ttc=331.2 2019-09-19 17:01:28 DEBUG 00.000.000.00 ActionComm::getActions 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 2812 AND a.elementtype = 'invoice' ORDER BY a.datep DESC, a.id DESC 2019-09-19 17:01:28 INFO 00.000.000.00 --- End access to /compta/facture/card.php 2019-09-19 17:01:28 INFO 00.000.000.00 --- Access to /custom/ultimatepdf/css/ultimatepdf.css.php - action=, massaction= 2019-09-19 17:01:28 DEBUG 00.000.000.00 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-09-19 17:01:28 INFO 00.000.000.00 --- End access to /custom/ultimatepdf/css/ultimatepdf.css.php 2019-09-19 17:01:29 INFO 00.000.000.00 --- Access to /viewimage.php - action=, massaction= 2019-09-19 17:01:29 INFO 00.000.000.00 modulepart=mycompany original_file=logos/thumbs/2019-07 - Logo GroupeV2_mini.png entity=1 2019-09-19 17:01:29 INFO 00.000.000.00 viewimage.php return file /var/www/html/www.moi.com/dolibarr/documents/mycompany/logos/thumbs/2019-07 - Logo GroupeV2_mini.png filename=2019-07 - Logo GroupeV2_mini.png content-type=image/png 2019-09-19 17:01:29 INFO 00.000.000.00 --- End access to /viewimage.php