2024-04-18 08:19:22 DEBUG 10.10.10.202 - This is an already logged session. _SESSION['dol_login']=Administrateur _SESSION['dol_entity']=1 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_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, 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 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 = 'Administrateur' ORDER BY u.entity ASC 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2024-04-18 08:19:22 DEBUG 10.10.10.202 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity 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 2024-04-18 08:19:22 NOTICE 10.10.10.202 --- Access to GET /compta/index.php - action=, massaction= 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang='fr_FR' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM 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 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position 2024-04-18 08:19:22 DEBUG 10.10.10.202 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' 2024-04-18 08:19:22 DEBUG 10.10.10.202 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' 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT sum((CASE WHEN f.date_lim_reglement < '2024-03-19' THEN 1 ELSE 0 END)) as nblate30, sum((CASE WHEN f.date_lim_reglement < '2024-04-03' THEN 1 ELSE 0 END)) as nblate15, sum((CASE WHEN f.date_lim_reglement < '2024-04-18' THEN 1 ELSE 0 END)) as nblatenow, sum((CASE WHEN f.date_lim_reglement >= '2024-04-18' OR f.date_lim_reglement IS NULL THEN 1 ELSE 0 END)) as nbnotlatenow, sum((CASE WHEN f.date_lim_reglement > '2024-05-03' THEN 1 ELSE 0 END)) as nbnotlate15, sum((CASE WHEN f.date_lim_reglement > '2024-05-18' THEN 1 ELSE 0 END)) as nbnotlate30 FROM llx_facture as f WHERE f.entity IN (1) AND f.type <> 2 AND f.fk_statut = 1 2024-04-18 08:19:22 INFO 10.10.10.202 DolGraph::draw_chart this->type=bars,bars,bars,bars,bars,bars this->MaxValue=0 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT sum((CASE WHEN f.date_lim_reglement < '2024-03-19' THEN 1 ELSE 0 END)) as nblate30, sum((CASE WHEN f.date_lim_reglement < '2024-04-03' THEN 1 ELSE 0 END)) as nblate15, sum((CASE WHEN f.date_lim_reglement < '2024-04-18' THEN 1 ELSE 0 END)) as nblatenow, sum((CASE WHEN f.date_lim_reglement >= '2024-04-18' OR f.date_lim_reglement IS NULL THEN 1 ELSE 0 END)) as nbnotlatenow, sum((CASE WHEN f.date_lim_reglement > '2024-05-03' THEN 1 ELSE 0 END)) as nbnotlate15, sum((CASE WHEN f.date_lim_reglement > '2024-05-18' THEN 1 ELSE 0 END)) as nbnotlate30 FROM llx_facture_fourn as f WHERE f.entity IN (1) AND f.type <> 2 AND f.fk_statut = 1 2024-04-18 08:19:22 INFO 10.10.10.202 DolGraph::draw_chart this->type=bars,bars,bars,bars,bars,bars this->MaxValue=0 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT f.rowid, f.ref, f.datef as date, f.total_ht, f.total_tva, f.total_ttc, f.ref_client, f.type, f.fk_statut as status, f.paye, s.nom as name, s.rowid as socid, s.email, s.code_client, s.code_compta, s.code_fournisseur, s.code_compta_fournisseur, cc.rowid as country_id, cc.code as country_code FROM llx_facture 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) GROUP BY f.rowid, f.ref, f.datef, f.total_ht, f.total_tva, f.total_ttc, f.ref_client, f.type, f.fk_statut, f.paye, s.nom, s.rowid, s.email, s.code_client, s.code_compta, s.code_fournisseur, s.code_compta_fournisseur, cc.rowid, cc.code 2024-04-18 08:19:22 DEBUG 10.10.10.202 Translate::loadCacheCurrencies 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT f.ref, f.rowid, f.total_ht, f.total_tva, f.total_ttc, f.type, f.ref_supplier, f.fk_statut as status, f.paye, s.nom as name, s.rowid as socid, s.email, s.code_client, s.code_compta, 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) 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT f.rowid, f.ref, f.fk_statut as status, f.type, f.total_ht, f.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_ht, f.total_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 2024-04-18 08:19:22 INFO 10.10.10.202 files.lib.php::dol_dir_list path=/srv/hosting/gestion/public_html/documents/facture/FA2404-2749 types=files recursive=0 filter=^FA2404\-2749\. excludefilter="\\.meta$|\\.png$" 2024-04-18 08:19:22 INFO 10.10.10.202 files.lib.php::dol_dir_list path=/srv/hosting/gestion/public_html/documents/facture/FA2403-2710 types=files recursive=0 filter=^FA2403\-2710\. excludefilter="\\.meta$|\\.png$" 2024-04-18 08:19:22 INFO 10.10.10.202 files.lib.php::dol_dir_list path=/srv/hosting/gestion/public_html/documents/facture/FA2404-2748 types=files recursive=0 filter=^FA2404\-2748\. excludefilter="\\.meta$|\\.png$" 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT ff.rowid, ff.ref, ff.fk_statut as status, ff.type, ff.libelle, ff.total_ht, ff.total_tva, ff.total_ttc, ff.tms, ff.paye, ff.ref_supplier, s.nom as name, s.rowid as socid, s.code_fournisseur, s.code_compta_fournisseur, s.email, 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.type, ff.libelle, ff.total_ht, ff.tva, ff.total_tva, ff.total_ttc, ff.tms, ff.paye, ff.ref_supplier, s.nom, s.rowid, s.code_fournisseur, s.code_compta_fournisseur, s.email ORDER BY ff.tms DESC LIMIT 3 2024-04-18 08:19:22 DEBUG 10.10.10.202 FactureFournisseur::getSommePaiement 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 2924 2024-04-18 08:19:22 DEBUG 10.10.10.202 FactureFournisseur::getSommePaiement 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 2946 2024-04-18 08:19:22 DEBUG 10.10.10.202 FactureFournisseur::getSommePaiement 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 2941 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT c.rowid, c.amount, c.date_ech, c.paye, cc.libelle as label, 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 IN (1) AND c.paye = 0 GROUP BY c.rowid, c.amount, c.date_ech, c.paye, cc.libelle 2024-04-18 08:19:22 DEBUG 10.10.10.202 sql=SELECT sum(f.total_ht) 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 as status, c.total_ht, c.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.total_tva, c.total_ttc, cc.rowid, cc.code 2024-04-18 08:19:22 INFO 10.10.10.202 files.lib.php::dol_dir_list path=/srv/hosting/gestion/public_html/documents/commande/CO2404-1681 types=files recursive=0 filter=^CO2404\-1681\. excludefilter="\\.meta$|\\.png$" 2024-04-18 08:19:22 INFO 10.10.10.202 --- End access to /compta/index.php 2024-04-18 08:19:26 DEBUG 10.10.10.202 - This is an already logged session. _SESSION['dol_login']=Administrateur _SESSION['dol_entity']=1 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_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, 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 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 = 'Administrateur' ORDER BY u.entity ASC 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2024-04-18 08:19:26 DEBUG 10.10.10.202 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity 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 2024-04-18 08:19:26 NOTICE 10.10.10.202 --- Access to GET /compta/sociales/list.php - action=, massaction= 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang='fr_FR' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM 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 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position 2024-04-18 08:19:26 DEBUG 10.10.10.202 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' 2024-04-18 08:19:26 DEBUG 10.10.10.202 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' 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT COUNT(DISTINCT cs.rowid) as nbtotalofrecords, SUM(pc.amount) as alreadypayed FROM llx_c_chargesociales as c, llx_chargesociales as cs LEFT JOIN llx_bank_account as ba ON (cs.fk_account = ba.rowid) LEFT JOIN llx_c_paiement as pay ON (cs.fk_mode_reglement = pay.id) LEFT JOIN llx_projet as p ON p.rowid = cs.fk_projet LEFT JOIN llx_paiementcharge as pc ON pc.fk_charge = cs.rowid LEFT JOIN llx_user as u ON (cs.fk_user = u.rowid) WHERE cs.fk_type = c.id AND cs.entity = 1 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT cs.rowid, cs.fk_type as type, cs.fk_user, cs.amount, cs.date_ech, cs.libelle as label, cs.paye, cs.periode, cs.fk_account, p.rowid as project_id, p.ref as project_ref, p.title as project_label, c.libelle as type_label, c.accountancy_code as type_accountancy_code, ba.label as blabel, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.iban_prefix as iban, ba.bic, ba.currency_code, ba.clos, pay.code as payment_code, SUM(pc.amount) as alreadypayed FROM llx_c_chargesociales as c, llx_chargesociales as cs LEFT JOIN llx_bank_account as ba ON (cs.fk_account = ba.rowid) LEFT JOIN llx_c_paiement as pay ON (cs.fk_mode_reglement = pay.id) LEFT JOIN llx_projet as p ON p.rowid = cs.fk_projet LEFT JOIN llx_paiementcharge as pc ON pc.fk_charge = cs.rowid LEFT JOIN llx_user as u ON (cs.fk_user = u.rowid) WHERE cs.fk_type = c.id AND cs.entity = 1 GROUP BY cs.rowid, cs.fk_type, cs.fk_user, cs.amount, cs.date_ech, cs.libelle, cs.paye, cs.periode, cs.fk_account, c.libelle, c.accountancy_code, ba.label, ba.ref, ba.number, ba.account_number, ba.iban_prefix, ba.bic, ba.currency_code, ba.clos, pay.code, p.rowid, p.ref, p.title ORDER BY cs.date_ech DESC LIMIT 26 2024-04-18 08:19:26 DEBUG 10.10.10.202 Form::select_type_socialcontrib 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT c.id, c.libelle as type FROM llx_c_chargesociales as c WHERE c.active = 1 AND c.fk_pays = 1 ORDER BY c.libelle ASC 2024-04-18 08:19:26 DEBUG 10.10.10.202 Form::select_dolusers 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut as status, u.login, u.admin, u.entity, u.photo FROM llx_user as u WHERE u.entity IN (0, 1) ORDER BY u.statut DESC, u.firstname ASC, u.lastname ASC 2024-04-18 08:19:26 DEBUG 10.10.10.202 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_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, 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 FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 2 ORDER BY u.entity ASC 2024-04-18 08:19:26 INFO 10.10.10.202 --- End access to /compta/sociales/list.php 2024-04-18 08:19:28 DEBUG 10.10.10.202 - This is an already logged session. _SESSION['dol_login']=Administrateur _SESSION['dol_entity']=1 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_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, 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 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 = 'Administrateur' ORDER BY u.entity ASC 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2024-04-18 08:19:28 DEBUG 10.10.10.202 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity 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 2024-04-18 08:19:28 NOTICE 10.10.10.202 --- Access to GET /compta/sociales/payments.php - action=, massaction= 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang='fr_FR' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM 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 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position 2024-04-18 08:19:28 DEBUG 10.10.10.202 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' 2024-04-18 08:19:28 DEBUG 10.10.10.202 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' 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT c.id, c.libelle as type_label, cs.rowid, cs.libelle as label_sc, cs.fk_type as type, cs.periode, cs.date_ech, cs.amount as total, cs.paye, pc.rowid as pid, pc.datep, pc.amount as totalpaid, pc.num_paiement as num_payment, pc.fk_bank, pct.code as payment_code, u.rowid as uid, u.lastname, u.firstname, u.email, u.login, u.admin, u.statut, ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.fk_accountancy_journal, ba.label as blabel, ba.iban_prefix as iban, ba.bic, ba.currency_code, ba.clos, aj.label as account_journal FROM llx_c_chargesociales as c, llx_chargesociales as cs INNER JOIN llx_paiementcharge as pc ON pc.fk_charge = cs.rowid LEFT JOIN llx_c_paiement as pct ON pc.fk_typepaiement = pct.id LEFT JOIN llx_bank as b ON pc.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid LEFT JOIN llx_accounting_journal as aj ON ba.fk_accountancy_journal = aj.rowid LEFT JOIN llx_user as u ON u.rowid = cs.fk_user WHERE cs.fk_type = c.id AND cs.entity IN (1) ORDER BY cs.date_ech DESC 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT c.id, c.libelle as type_label, cs.rowid, cs.libelle as label_sc, cs.fk_type as type, cs.periode, cs.date_ech, cs.amount as total, cs.paye, pc.rowid as pid, pc.datep, pc.amount as totalpaid, pc.num_paiement as num_payment, pc.fk_bank, pct.code as payment_code, u.rowid as uid, u.lastname, u.firstname, u.email, u.login, u.admin, u.statut, ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.fk_accountancy_journal, ba.label as blabel, ba.iban_prefix as iban, ba.bic, ba.currency_code, ba.clos, aj.label as account_journal FROM llx_c_chargesociales as c, llx_chargesociales as cs INNER JOIN llx_paiementcharge as pc ON pc.fk_charge = cs.rowid LEFT JOIN llx_c_paiement as pct ON pc.fk_typepaiement = pct.id LEFT JOIN llx_bank as b ON pc.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid LEFT JOIN llx_accounting_journal as aj ON ba.fk_accountancy_journal = aj.rowid LEFT JOIN llx_user as u ON u.rowid = cs.fk_user WHERE cs.fk_type = c.id AND cs.entity IN (1) ORDER BY cs.date_ech DESC LIMIT 26 2024-04-18 08:19:28 DEBUG 10.10.10.202 Form::select_type_socialcontrib 2024-04-18 08:19:28 DEBUG 10.10.10.202 sql=SELECT c.id, c.libelle as type FROM llx_c_chargesociales as c WHERE c.active = 1 AND c.fk_pays = 1 ORDER BY c.libelle ASC 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 WARNING 10.10.10.202 Functions.lib::dol_print_date function called with a bad value from page /compta/sociales/payments.php 2024-04-18 08:19:28 INFO 10.10.10.202 --- End access to /compta/sociales/payments.php 2024-04-18 08:19:36 DEBUG 10.10.10.202 - This is an already logged session. _SESSION['dol_login']=Administrateur _SESSION['dol_entity']=1 2024-04-18 08:19:36 DEBUG 10.10.10.202 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_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, 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 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 = 'Administrateur' ORDER BY u.entity ASC 2024-04-18 08:19:36 DEBUG 10.10.10.202 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2024-04-18 08:19:36 DEBUG 10.10.10.202 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2024-04-18 08:19:36 DEBUG 10.10.10.202 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance' 2024-04-18 08:19:36 DEBUG 10.10.10.202 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity 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 2024-04-18 08:19:36 NOTICE 10.10.10.202 --- Access to GET /compta/payment_sc/card.php - action=, massaction= 2024-04-18 08:19:36 DEBUG 10.10.10.202 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang='fr_FR' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM 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 2024-04-18 08:19:37 DEBUG 10.10.10.202 PaymentSocialContribution::fetch 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT t.rowid, t.fk_charge, t.datec, t.tms, t.datep, t.amount, t.fk_typepaiement, t.num_paiement as num_payment, t.note, t.fk_bank, t.fk_user_creat, t.fk_user_modif, pt.code as type_code, pt.libelle as type_label, b.fk_account FROM llx_paiementcharge as t LEFT JOIN llx_c_paiement as pt ON t.fk_typepaiement = pt.id LEFT JOIN llx_bank as b ON t.fk_bank = b.rowid WHERE t.rowid = 327 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT COUNT(dbt.rowid) as nb FROM llx_paiementcharge as dbt, llx_chargesociales as dbtp WHERE dbt.fk_charge = dbtp.rowid AND dbt.rowid IN (319) AND dbtp.entity IN (1) 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position 2024-04-18 08:19:37 DEBUG 10.10.10.202 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' 2024-04-18 08:19:37 DEBUG 10.10.10.202 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' 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='bank' AND ab.fk_doc = 6035 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT MAX(te.rowid) FROM llx_paiementcharge as te WHERE te.rowid < '327' 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT MIN(te.rowid) FROM llx_paiementcharge as te WHERE te.rowid > '327' 2024-04-18 08:19:37 DEBUG 10.10.10.202 Translate::loadCacheCurrencies 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2024-04-18 08:19:37 DEBUG 10.10.10.202 AccountLine::fetch 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT b.rowid, b.datec, b.datev, b.dateo, b.amount, b.label as label, b.fk_account, b.fk_user_author, b.fk_user_rappro, b.fk_type, b.num_releve, b.num_chq, b.rappro, b.note, b.fk_bordereau, b.banque, b.emetteur, ba.ref as bank_account_ref, ba.label as bank_account_label FROM llx_bank as b, llx_bank_account as ba WHERE b.fk_account = ba.rowid AND ba.entity IN (1) AND b.rowid = 6035 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'bank' ORDER BY pos 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT COUNT(rowid) as nb FROM llx_accounting_bookkeeping WHERE doc_type = 'bank' AND fk_doc = 6035 2024-04-18 08:19:37 DEBUG 10.10.10.202 compta/payment_sc/card.php 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT f.rowid as scid, f.libelle as label, f.paye, f.amount as sc_amount, pf.amount, pc.libelle as sc_type FROM llx_paiementcharge as pf,llx_chargesociales as f, llx_c_chargesociales as pc WHERE pf.fk_charge = f.rowid AND f.fk_type = pc.id AND f.entity = 1 AND pf.rowid = 327 2024-04-18 08:19:37 DEBUG 10.10.10.202 ChargeSociales::fetch 2024-04-18 08:19:37 DEBUG 10.10.10.202 sql=SELECT cs.rowid, cs.date_ech, cs.libelle as label, cs.fk_type, cs.amount, cs.fk_projet as fk_project, cs.paye, cs.periode, cs.import_key, cs.fk_account, cs.fk_mode_reglement, cs.fk_user, note_public, note_private, c.libelle as type_label, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle FROM llx_chargesociales as cs LEFT JOIN llx_c_chargesociales as c ON cs.fk_type = c.id LEFT JOIN llx_c_paiement as p ON cs.fk_mode_reglement = p.id WHERE cs.entity IN (1) AND cs.rowid = 319 2024-04-18 08:19:37 INFO 10.10.10.202 --- End access to /compta/payment_sc/card.php