2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code_user_general, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, s.label as label_establishment, u.fk_establishment FROM llxaj_user as u LEFT JOIN llxaj_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxaj_c_departements as d ON u.fk_state = d.rowid LEFT JOIN llxaj_establishment as s ON u.fk_establishment = s.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxaj_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT param, value FROM llxaj_user_param WHERE fk_user = 1 AND entity = 1 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 DefaultValues::fetchAll 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT rowid, type, user_id, page, param, value FROM llxaj_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,1)) AND (entity IN (0,1))) 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxaj_user_rights as ur, llxaj_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT DISTINCT r.module, r.perms, r.subperms, r.entity FROM llxaj_usergroup_rights as gr, llxaj_usergroup_user as gu, llxaj_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2025-12-11 21:50:47 NOTICE 199.244.54.204 164126 33188 --- Access to POST /actg24/core/ajax/ajaxtooltip.php - action=, massaction= NOTOKENRENEWAL=1 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT transkey, transvalue FROM llxaj_overwrite_trans where (lang='en_US' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 Facture::fetch 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT f.rowid, f.entity, f.ref, f.ref_client, f.ref_ext, f.type, f.subtype, f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, 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 as status, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.fk_user_modif, f.model_pdf, f.last_main_doc, f.fk_input_reason, 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 label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llxaj_facture as f LEFT JOIN llxaj_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llxaj_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llxaj_c_input_reason as dr ON dr.rowid = f.fk_input_reason LEFT JOIN llxaj_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid = 63 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxaj_extrafields WHERE elementtype = 'facture' ORDER BY pos 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 Facture::fetch_lines 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 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.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.batch, l.fk_warehouse, 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.extraparams, 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, p.barcode as product_barcode FROM llxaj_facturedet as l LEFT JOIN llxaj_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 63 ORDER BY l.rang, l.rowid 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxaj_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 Facture::getSommePaiement 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llxaj_paiement_facture WHERE fk_facture = 63 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 DiscountAbsolute::getSumCreditNotesUsed 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxaj_societe_remise_except as rc, llxaj_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 63 AND f.type IN (0,2,5) 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 DiscountAbsolute::getSumDepositsUsed 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxaj_societe_remise_except as rc, llxaj_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 63 AND f.type = 3 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 Translate::loadCacheCurrencies 2025-12-11 21:50:47 DEBUG 199.244.54.204 164126 33188 sql=SELECT code_iso, label, unicode FROM llxaj_c_currencies WHERE active = 1 AND code_iso = 'USD' 2025-12-11 21:50:47 INFO 199.244.54.204 164126 33188 --- End access to /actg24/core/ajax/ajaxtooltip.php 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code_user_general, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, s.label as label_establishment, u.fk_establishment FROM llxaj_user as u LEFT JOIN llxaj_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxaj_c_departements as d ON u.fk_state = d.rowid LEFT JOIN llxaj_establishment as s ON u.fk_establishment = s.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxaj_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT param, value FROM llxaj_user_param WHERE fk_user = 1 AND entity = 1 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 DefaultValues::fetchAll 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT rowid, type, user_id, page, param, value FROM llxaj_default_values as t WHERE 1 = 1 AND ((t.user_id IN (0,1)) AND (entity IN (0,1))) 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxaj_user_rights as ur, llxaj_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT DISTINCT r.module, r.perms, r.subperms, r.entity FROM llxaj_usergroup_rights as gr, llxaj_usergroup_user as gu, llxaj_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2025-12-11 21:50:53 NOTICE 199.244.54.204 164332 33188 --- Access to GET /actg24/compta/facture/card.php - action=, massaction= 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT transkey, transvalue FROM llxaj_overwrite_trans where (lang='en_US' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position, m.showtopmenuinframe FROM llxaj_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.type DESC, m.position, m.rowid 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxaj_extrafields WHERE elementtype = 'facture' ORDER BY pos 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 Facture::fetch 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT f.rowid, f.entity, f.ref, f.ref_client, f.ref_ext, f.type, f.subtype, f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, 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 as status, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.fk_user_modif, f.model_pdf, f.last_main_doc, f.fk_input_reason, 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 label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llxaj_facture as f LEFT JOIN llxaj_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llxaj_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llxaj_c_input_reason as dr ON dr.rowid = f.fk_input_reason LEFT JOIN llxaj_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid = 63 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 Facture::fetch_lines 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 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.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.batch, l.fk_warehouse, 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.extraparams, 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, p.barcode as product_barcode FROM llxaj_facturedet as l LEFT JOIN llxaj_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 63 ORDER BY l.rang, l.rowid 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxaj_extrafields WHERE elementtype = 'facturedet' ORDER BY pos 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT t.localtax1, t.localtax2 FROM llxaj_c_tva as t, llxaj_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax1_type <> '0' 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT t.localtax1, t.localtax2 FROM llxaj_c_tva as t, llxaj_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax2_type <> '0' 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT t.localtax1, t.localtax2 FROM llxaj_c_tva as t, llxaj_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax1_type <> '0' 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT t.localtax1, t.localtax2 FROM llxaj_c_tva as t, llxaj_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax2_type <> '0' 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT t.localtax1, t.localtax2 FROM llxaj_c_tva as t, llxaj_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax1_type <> '0' 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT t.localtax1, t.localtax2 FROM llxaj_c_tva as t, llxaj_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'US' AND t.active = 1 AND t.entity IN (1) AND t.localtax2_type <> '0' 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.phone_mobile, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.accountancy_code_customer_general, s.code_compta, s.accountancy_code_supplier_general, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxaj_societe as s LEFT JOIN llxaj_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxaj_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxaj_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxaj_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxaj_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxaj_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxaj_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxaj_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 2055 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxaj_extrafields WHERE elementtype = 'societe' ORDER BY pos 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.phone_mobile, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.accountancy_code_customer_general, s.code_compta, s.accountancy_code_supplier_general, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxaj_societe as s LEFT JOIN llxaj_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxaj_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxaj_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxaj_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxaj_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxaj_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxaj_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxaj_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 2055 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 useRevenueStamp 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT COUNT(*) as nb FROM llxaj_c_revenuestamp as r, llxaj_c_country as c WHERE r.fk_pays = c.rowid AND c.code = 'US' AND r.active = 1 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 Facture::getSommePaiement 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llxaj_paiement_facture WHERE fk_facture = 63 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 DiscountAbsolute::getSumCreditNotesUsed 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxaj_societe_remise_except as rc, llxaj_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 63 AND f.type IN (0,2,5) 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 DiscountAbsolute::getSumDepositsUsed 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxaj_societe_remise_except as rc, llxaj_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 63 AND f.type = 3 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 DiscountAbsolute::getAvailableDiscounts discount_type=0 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxaj_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 = 2055 AND (fk_facture_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS RECEIVED)%')) 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 DiscountAbsolute::getAvailableDiscounts discount_type=0 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llxaj_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 = 2055 AND (fk_facture_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS RECEIVED)%')) 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code_user_general, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, s.label as label_establishment, u.fk_establishment FROM llxaj_user as u LEFT JOIN llxaj_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxaj_c_departements as d ON u.fk_state = d.rowid LEFT JOIN llxaj_establishment as s ON u.fk_establishment = s.rowid WHERE u.rowid = 1 ORDER BY u.entity ASC 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, aiprompt, css, cssview, csslist FROM llxaj_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT rowid FROM llxaj_facture WHERE fk_facture_source = 63 AND type < 2 ORDER BY fk_statut DESC 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 Facture::liste_contact 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 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.gender, t.fk_country as country_id, t.civility as civility, t.lastname as lastname, t.firstname, t.email, t.address, t.zip, t.town, tc.source, tc.element, tc.code, tc.libelle as type_label, co.label as country FROM llxaj_c_type_contact as tc, llxaj_element_contact as ec LEFT JOIN llxaj_user as t on ec.fk_socpeople = t.rowid LEFT JOIN llxaj_c_country as co ON co.rowid = t.fk_country WHERE ec.element_id = 63 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 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 Facture::liste_contact 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 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.fk_pays as country_id, t.civility as civility, t.lastname as lastname, t.firstname, t.email, t.address, t.zip, t.town, tc.source, tc.element, tc.code, tc.libelle as type_label, co.label as country FROM llxaj_c_type_contact as tc, llxaj_element_contact as ec LEFT JOIN llxaj_socpeople as t on ec.fk_socpeople = t.rowid LEFT JOIN llxaj_c_country as co ON co.rowid = t.fk_pays WHERE ec.element_id = 63 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 2025-12-11 21:50:53 INFO 199.244.54.204 164332 33188 files.lib.php::dol_dir_list path=/home3/lkeeton/dolibarrdata/facture/09157 types=files recursive=0 filter="" excludefilter="(\\.meta|_preview.*\\.png)$" 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT COUNT(rowid) as nb FROM llxaj_links WHERE objecttype = 'facture' AND objectid = 63 AND entity = 1 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT COUNT(id) as nb FROM llxaj_actioncomm WHERE fk_element = 63 AND elementtype = 'invoice' 2025-12-11 21:50:53 DEBUG 199.244.54.204 164332 33188 sql=SELECT cc.code FROM llxaj_c_country as cc WHERE cc.eec = 1 2025-12-11 21:50:53 INFO 199.244.54.204 164332 33188 --- End access to /actg24/compta/facture/card.php