2020-02-24 10:20:31 DEBUG 110.145.2.87 - This is an already logged session. _SESSION['dol_login']=Benjamin.Broad _SESSION['dol_entity']=1 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_user as u LEFT JOIN doli_c_country as c ON u.fk_country = c.rowid LEFT JOIN doli_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benjamin.Broad' ORDER BY u.entity ASC 2020-02-24 10:20:31 INFO 110.145.2.87 fetch_name_optionals_label elementtype=user 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM doli_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT rowid, total_hsup_remunerees, total_hsup_rattrapees, dept, date_last_hsup, emptype, fk_service FROM doli_user_extrafields WHERE fk_object = 71 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT param, value FROM doli_user_param WHERE fk_user = 71 AND entity = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT rowid, entity, type, page, param, value FROM doli_default_values WHERE entity IN (1) AND user_id IN (0, 71) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_user_rights as ur, doli_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 71 AND r.perms IS NOT NULL 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_usergroup_rights as gr, doli_usergroup_user as gu, doli_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 71 AND r.perms IS NOT NULL 2020-02-24 10:20:31 INFO 110.145.2.87 --- Access to /index.php - action=, massaction= 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:31 DEBUG 110.145.2.87 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-02-24 10:20:31 DEBUG 110.145.2.87 InfoBox::listBoxes get default box list for mode=activated userid= 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM doli_boxes as b, doli_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user = 0 ORDER BY b.box_order 2020-02-24 10:20:31 WARNING 110.145.2.87 functions::dol_include_once Tried to load unexisting file: /scrumboard/core/boxes/scrumboard_box.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Failed to load box 'scrumboard_box' into file '/scrumboard/core/boxes/scrumboard_box.php' 2020-02-24 10:20:31 WARNING 110.145.2.87 functions::dol_include_once Tried to load unexisting file: /parts/core/boxes/partswidget1.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Failed to load box 'partswidget1' into file '/parts/core/boxes/partswidget1.php' 2020-02-24 10:20:31 DEBUG 110.145.2.87 form::get_subordinate role=1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT usr.rowid as userid FROM doli_user AS usr WHERE usr.fk_user in (71) AND usr.rowid not in (71) 2020-02-24 10:20:31 DEBUG 110.145.2.87 timesheet::report::projectList 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT tk.fk_projet as project ,tk.rowid as task FROM doli_projet_task as tk JOIN doli_element_contact AS ec ON tk.fk_projet= ec.element_id LEFT JOIN doli_c_type_contact as ctc ON ctc.rowid=ec.fk_c_type_contact WHERE ctc.element in ('project') AND ctc.active='1' AND ctc.code LIKE '%LEADER%' AND fk_socpeople='71' UNION SELECT tk.fk_projet as project ,tk.rowid as task FROM doli_projet_task as tk JOIN doli_element_contact as ec on (tk.rowid= element_id ) LEFT JOIN doli_c_type_contact as ctc ON ctc.rowid=ec.fk_c_type_contact WHERE ctc.element in ('project_task') AND ctc.active='1' AND ctc.code LIKE '%EXECUTIVE%' AND ec.fk_socpeople='71' 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT COUNT(DISTINCT t.rowid) as nbtsk, count(DISTINCT fk_project_task_timesheet) as nbtm ,t.recipient FROM doli_project_task_time_approval as t WHERE t.status IN (2,8,6) AND ((t.recipient=1 AND t.fk_userid in (0)) OR (t.recipient=2 and fk_projet_task in (0))) GROUP BY t.recipient 2020-02-24 10:20:31 INFO 110.145.2.87 box_approval::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT t.rowid as id, t.ref, t.track_id, t.fk_soc, t.fk_user_create, t.fk_user_assign, t.subject, t.message, t.fk_statut, t.type_code, t.category_code, t.severity_code, t.datec, t.date_read, t.date_close, t.origin_email , type.label as type_label, category.label as category_label, severity.label as severity_label, s.nom as company_name FROM doli_ticket as t LEFT JOIN doli_c_ticket_type as type ON type.code=t.type_code LEFT JOIN doli_c_ticket_category as category ON category.code=t.category_code LEFT JOIN doli_c_ticket_severity as severity ON severity.code=t.severity_code LEFT JOIN doli_societe as s ON s.rowid=t.fk_soc WHERE t.entity = 1 ORDER BY t.tms DESC, t.rowid DESC LIMIT 5 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 INFO 110.145.2.87 box_last_modified_ticket::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, c.rowid, c.ref, c.statut as contract_status, c.ref_customer, c.ref_supplier, cd.rowid as cdid, cd.label, cd.description, cd.tms as datem, cd.statut, cd.product_type as type, p.rowid as product_id, p.ref as product_ref, p.label as plabel, p.fk_product_type as ptype, p.entity FROM (doli_societe as s INNER JOIN doli_contrat as c ON s.rowid = c.fk_soc INNER JOIN doli_contratdet as cd ON c.rowid = cd.fk_contrat LEFT JOIN doli_product as p ON cd.fk_product = p.rowid) WHERE c.entity = 1 ORDER BY c.tms DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_services_contracts::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 box_prospect::loadBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.email, s.code_fournisseur, s.fournisseur, s.logo, s.fk_stcomm, s.datec, s.tms, s.status FROM doli_societe as s WHERE s.client IN (2, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_prospect::showBox 2020-02-24 10:20:31 INFO 110.145.2.87 PropaleStats::getNbByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/PropaleStats_getNbByMonthWithPrevYear_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type=bars,bars this->MaxValue=9 2020-02-24 10:20:31 INFO 110.145.2.87 PropaleStats::getAmountByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/PropaleStats_getAmountByMonthWithPrevYear_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type=bars,bars this->MaxValue=400000 2020-02-24 10:20:31 INFO 110.145.2.87 box_graph_propales_permonth::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.code_client, s.logo, f.ref, f.date_lim_reglement as datelimite, f.type, f.amount, f.datef as df, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.fk_statut, f.rowid as facid, sum(pf.amount) as am FROM doli_societe as s, doli_facture as f LEFT JOIN doli_paiement_facture as pf ON f.rowid=pf.fk_facture WHERE f.fk_soc = s.rowid AND f.entity IN (1) AND f.paye = 0 AND fk_statut = 1 GROUP BY s.nom, s.rowid, s.code_client, s.logo, f.ref, f.date_lim_reglement, f.type, f.amount, f.datef, f.total, f.tva, f.total_ttc, f.paye, f.fk_statut, f.rowid ORDER BY datelimite ASC, f.ref ASC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_factures_imp::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 box_clients::loadBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.code_fournisseur, s.fournisseur, s.code_compta, s.code_compta_fournisseur, s.logo, s.email, s.datec, s.tms, s.status FROM doli_societe as s WHERE s.client IN (1, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_clients::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.fk_statut, SUM(p.total) as Mnttot, COUNT(*) as nb FROM (doli_societe as s, doli_propal as p) WHERE p.entity IN (1) AND p.fk_soc = s.rowid AND p.datep >= '2019-11-24 10:20:31' AND p.date_cloture IS NULL GROUP BY p.fk_statut ORDER BY p.fk_statut DESC 2020-02-24 10:20:31 DEBUG 110.145.2.87 Translate::loadCacheCurrencies 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT code_iso, label, unicode FROM doli_c_currencies WHERE active = 1 AND code_iso = 'AUD' 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT c.fk_statut, sum(c.total_ttc) as Mnttot, count(*) as nb FROM (doli_societe as s, doli_commande as c) WHERE c.entity = 1 AND c.fk_soc = s.rowid AND c.date_commande >= '2019-11-24 10:20:31' GROUP BY c.fk_statut ORDER BY c.fk_statut DESC 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT f.fk_statut, SUM(f.total_ttc) as Mnttot, COUNT(*) as nb FROM (doli_societe as s,doli_facture as f) WHERE f.entity IN (1) AND f.fk_soc = s.rowid AND f.datef >= '2019-11-24 10:20:31' AND f.paye=1 GROUP BY f.fk_statut ORDER BY f.fk_statut DESC 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT f.fk_statut, SUM(f.total_ttc) as Mnttot, COUNT(*) as nb FROM doli_societe as s,doli_facture as f WHERE f.entity IN (1) AND f.fk_soc = s.rowid AND f.datef >= '2019-11-24 10:20:31' AND f.paye=0 GROUP BY f.fk_statut ORDER BY f.fk_statut DESC 2020-02-24 10:20:31 INFO 110.145.2.87 box_activity::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid, p.label, p.price, p.ref, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.seuil_stock_alerte, p.entity, SUM(IF(s.reel IS NULL,0,s.reel)) as total_stock FROM doli_product as p LEFT JOIN doli_product_stock as s on p.rowid = s.fk_product WHERE p.entity IN (1) AND p.tosell = 1 AND p.seuil_stock_alerte > 0 GROUP BY p.rowid, p.ref, p.label, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.seuil_stock_alerte, p.entity HAVING SUM(IF(s.reel IS NULL,0,s.reel)) < p.seuil_stock_alerte ORDER BY p.seuil_stock_alerte DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 files.lib.php::dol_dir_list path=/opt/bitnami/apache2/htdocs/erp/documents/produit/4047/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-24 10:20:31 INFO 110.145.2.87 HookManager::initHooks Loading hook class for context fileslib: actions_dcloud.class.php 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_ecm_files WHERE filepath = 'produit/4047' AND entity = 1 2020-02-24 10:20:31 INFO 110.145.2.87 files.lib.php::dol_dir_list path=/opt/bitnami/apache2/htdocs/erp/documents/produit/UFM-PPBL-M-SM/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_ecm_files WHERE filepath = 'produit/UFM-PPBL-M-SM' AND entity = 1 2020-02-24 10:20:31 INFO 110.145.2.87 box_produits_alerte_stock::showBox 2020-02-24 10:20:31 INFO 110.145.2.87 CommandeStats::getNbByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type= this->MaxValue=80 2020-02-24 10:20:31 INFO 110.145.2.87 CommandeStats::getAmountByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type= this->MaxValue=90000 2020-02-24 10:20:31 INFO 110.145.2.87 box_graph_orders_permonth::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid, p.label, p.ref, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.fk_price_expression, p.entity FROM doli_product as p WHERE p.entity IN (1) ORDER BY p.datec DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 files.lib.php::dol_dir_list path=/opt/bitnami/apache2/htdocs/erp/documents/produit/Extra_shelf_900L/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_ecm_files WHERE filepath = 'produit/Extra_shelf_900L' AND entity = 1 2020-02-24 10:20:31 INFO 110.145.2.87 files.lib.php::dol_dir_list path=/opt/bitnami/apache2/htdocs/erp/documents/produit/2012-6-TS_EXTRA_Shelf/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_ecm_files WHERE filepath = 'produit/2012-6-TS_EXTRA_Shelf' AND entity = 1 2020-02-24 10:20:31 INFO 110.145.2.87 files.lib.php::dol_dir_list path=/opt/bitnami/apache2/htdocs/erp/documents/produit/LSW/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_ecm_files WHERE filepath = 'produit/LSW' AND entity = 1 2020-02-24 10:20:31 INFO 110.145.2.87 files.lib.php::dol_dir_list path=/opt/bitnami/apache2/htdocs/erp/documents/produit/EB2012-6-TS_GRY/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_ecm_files WHERE filepath = 'produit/EB2012-6-TS_GRY' AND entity = 1 2020-02-24 10:20:31 INFO 110.145.2.87 files.lib.php::dol_dir_list path=/opt/bitnami/apache2/htdocs/erp/documents/produit/EB2012-6-TS/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-24 10:20:31 DEBUG 110.145.2.87 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 doli_ecm_files WHERE filepath = 'produit/EB2012-6-TS' AND entity = 1 2020-02-24 10:20:31 INFO 110.145.2.87 box_produits::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, f.rowid as facid, f.ref, f.ref_supplier, f.date_lim_reglement as datelimite, f.amount, f.datef as df, f.total_ht as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.fk_statut, f.type FROM doli_societe as s,doli_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 AND f.paye=0 AND fk_statut = 1 ORDER BY datelimite DESC, f.ref_supplier DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_factures_fourn_imp::showBox 2020-02-24 10:20:31 INFO 110.145.2.87 FactureStats::getNbByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type= this->MaxValue=0 2020-02-24 10:20:31 INFO 110.145.2.87 FactureStats::getAmountByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type= this->MaxValue=0 2020-02-24 10:20:31 INFO 110.145.2.87 box_graph_invoices_supplier_permonth::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT c.rowid, c.ref, c.statut as fk_statut, c.date_contrat, c.ref_customer, c.ref_supplier, s.nom as name, s.rowid as socid, s.email, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, MIN(cd.date_fin_validite) as date_line, COUNT(cd.rowid) as nb_services FROM doli_contrat as c, doli_societe s, doli_contratdet as cd WHERE cd.statut = 4 AND cd.date_fin_validite <= '2020-02-24 10:20:31' AND c.entity = 1 AND c.fk_soc=s.rowid AND cd.fk_contrat=c.rowid AND c.statut > 0 GROUP BY c.rowid, c.ref, c.statut, c.date_contrat, c.ref_customer, c.ref_supplier, s.nom, s.rowid ORDER BY date_line ASC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_services_expired::showBox 2020-02-24 10:20:31 INFO 110.145.2.87 ModeleBoxes::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT t.rowid as id, t.ref, t.track_id, t.fk_soc, t.fk_user_create, t.fk_user_assign, t.subject, t.message, t.fk_statut, t.type_code, t.category_code, t.severity_code, t.datec, t.date_read, t.date_close, t.origin_email , type.label as type_label, category.label as category_label, severity.label as severity_label, s.nom as company_name FROM doli_ticket as t LEFT JOIN doli_c_ticket_type as type ON type.code=t.type_code LEFT JOIN doli_c_ticket_category as category ON category.code=t.category_code LEFT JOIN doli_c_ticket_severity as severity ON severity.code=t.severity_code LEFT JOIN doli_societe as s ON s.rowid=t.fk_soc WHERE t.entity = 1 ORDER BY t.datec DESC, t.rowid DESC LIMIT 5 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 WARNING 110.145.2.87 Functions.lib::dol_print_date function called with a bad value from page /index.php 2020-02-24 10:20:31 INFO 110.145.2.87 box_last_ticket::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 box_ficheinter::loadBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT f.rowid, f.ref, f.fk_soc, f.fk_statut, f.datec, f.date_valid as datev, f.tms as datem, s.nom as name, s.rowid as socid, s.client FROM doli_societe as s, doli_fichinter as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_ficheinter::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, p.rowid, p.ref, p.fk_statut, p.datep as dp, p.datec, p.fin_validite, p.date_cloture, p.total_ht, p.tva as total_tva, p.total as total_ttc, p.tms FROM doli_societe as s, doli_propal as p WHERE p.fk_soc = s.rowid AND p.entity = 1 ORDER BY p.tms DESC, p.ref DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_propales::showBox 2020-02-24 10:20:31 INFO 110.145.2.87 FactureStats::getNbByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type= this->MaxValue=3 2020-02-24 10:20:31 INFO 110.145.2.87 FactureStats::getAmountByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type= this->MaxValue=3000 2020-02-24 10:20:31 INFO 110.145.2.87 box_graph_invoices_permonth::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT sp.rowid as id, sp.lastname, sp.firstname, sp.civility as civility_id, sp.datec, sp.tms, sp.fk_soc, sp.statut as status, sp.address, sp.zip, sp.town, sp.phone, sp.phone_perso, sp.phone_mobile, s.nom as socname, s.name_alias, s.client, s.fournisseur, s.code_client, s.code_fournisseur FROM doli_socpeople as sp LEFT JOIN doli_societe as s ON sp.fk_soc = s.rowid WHERE sp.entity IN (1) ORDER BY sp.tms DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_contacts::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.datec, s.tms, s.status, s.code_fournisseur, s.logo FROM doli_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_fournisseurs::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.code_fournisseur, s.logo, f.rowid as facid, f.ref, f.ref_supplier, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut, f.datef as df, f.datec as datec, f.date_lim_reglement as datelimite, f.tms, f.type FROM doli_societe as s, doli_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.ref DESC LIMIT 5 2020-02-24 10:20:31 DEBUG 110.145.2.87 FactureFournisseur::fetch 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM doli_facture_fourn as t LEFT JOIN doli_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN doli_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN doli_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN doli_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=2 2020-02-24 10:20:31 INFO 110.145.2.87 fetch_name_optionals_label elementtype=facture_fourn 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM doli_extrafields WHERE elementtype = 'facture_fourn' ORDER BY pos 2020-02-24 10:20:31 DEBUG 110.145.2.87 FactureFournisseur::fetch_lines 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM doli_facture_fourn_det as f LEFT JOIN doli_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=2 ORDER BY f.rang, f.rowid 2020-02-24 10:20:31 DEBUG 110.145.2.87 FactureFournisseur::getSommePaiement 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM doli_paiementfourn_facturefourn WHERE fk_facturefourn = 2 2020-02-24 10:20:31 DEBUG 110.145.2.87 FactureFournisseur::fetch 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM doli_facture_fourn as t LEFT JOIN doli_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN doli_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN doli_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN doli_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=1 2020-02-24 10:20:31 INFO 110.145.2.87 fetch_name_optionals_label elementtype=facture_fourn 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM doli_extrafields WHERE elementtype = 'facture_fourn' ORDER BY pos 2020-02-24 10:20:31 DEBUG 110.145.2.87 FactureFournisseur::fetch_lines 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM doli_facture_fourn_det as f LEFT JOIN doli_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=1 ORDER BY f.rang, f.rowid 2020-02-24 10:20:31 DEBUG 110.145.2.87 FactureFournisseur::getSommePaiement 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM doli_paiementfourn_facturefourn WHERE fk_facturefourn = 1 2020-02-24 10:20:31 INFO 110.145.2.87 box_factures_fourn::showBox 2020-02-24 10:20:31 INFO 110.145.2.87 CommandeStats::getNbByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type= this->MaxValue=70 2020-02-24 10:20:31 INFO 110.145.2.87 CommandeStats::getAmountByMonthWithPrevYear read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type= this->MaxValue=20000 2020-02-24 10:20:31 INFO 110.145.2.87 box_graph_orders_supplier_permonth::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid, p.ref, p.title, p.fk_statut, p.public FROM doli_projet as p WHERE p.fk_statut = 1 ORDER BY p.datec DESC 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(*) as nb, sum(progress) as totprogress FROM doli_projet as p LEFT JOIN doli_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 691 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(*) as nb, sum(progress) as totprogress FROM doli_projet as p LEFT JOIN doli_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 687 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(*) as nb, sum(progress) as totprogress FROM doli_projet as p LEFT JOIN doli_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 686 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(*) as nb, sum(progress) as totprogress FROM doli_projet as p LEFT JOIN doli_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 684 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(*) as nb, sum(progress) as totprogress FROM doli_projet as p LEFT JOIN doli_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 683 2020-02-24 10:20:31 INFO 110.145.2.87 box_project::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, s.email, c.ref, c.tms, c.rowid, c.date_commande, c.ref_client, c.fk_statut, c.fk_user_valid, c.facture, c.total_ht, c.tva as total_tva, c.total_ttc FROM doli_societe as s, doli_commande as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_commandes::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT f.rowid as facid, f.ref, f.type, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.datef as df, f.paye, f.fk_statut, f.datec, f.tms, s.rowid as socid, s.nom as name, s.code_client, s.email, s.tva_intra, s.code_compta, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, f.date_lim_reglement as datelimite FROM (doli_societe as s,doli_facture as f) WHERE f.fk_soc = s.rowid AND f.entity IN (1) ORDER BY f.tms DESC, f.ref DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_factures::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 Box_actions::loadBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT a.id, a.label, a.datep as dp, a.percent as percentage, ta.code, ta.libelle as type_label, s.nom as name, s.rowid as socid, s.code_client FROM doli_c_actioncomm AS ta, doli_actioncomm AS a LEFT JOIN doli_societe as s ON a.fk_soc = s.rowid WHERE a.fk_action = ta.id AND a.entity = 1 AND a.percent >= 0 AND a.percent < 100 ORDER BY a.datec DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_actions::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, c.rowid, c.ref, c.statut as fk_statut, c.date_contrat, c.datec, c.fin_validite, c.date_cloture FROM doli_societe as s, doli_contrat as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 fetch_name_optionals_label elementtype=contratdet 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM doli_extrafields WHERE elementtype = 'contratdet' ORDER BY pos 2020-02-24 10:20:31 DEBUG 110.145.2.87 Contrat::fetch_lines 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.label as product_label, p.description as product_desc, p.ref as product_ref, d.rowid, d.fk_contrat, d.statut, d.description, d.price_ht, d.vat_src_code, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.localtax1_type, d.localtax2_type, d.qty, d.remise_percent, d.subprice, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht, d.total_ht, d.total_tva, d.total_localtax1, d.total_localtax2, d.total_ttc, d.info_bits, d.fk_product, d.date_ouverture_prevue, d.date_ouverture, d.date_fin_validite, d.date_cloture, d.fk_user_author, d.fk_user_ouverture, d.fk_user_cloture, d.fk_unit FROM doli_contratdet as d LEFT JOIN doli_product as p ON d.fk_product = p.rowid WHERE d.fk_contrat = 1 ORDER by d.rowid ASC 2020-02-24 10:20:31 INFO 110.145.2.87 box_contracts::showBox 2020-02-24 10:20:31 INFO 110.145.2.87 FactureStats::getAllByProductEntry read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/FactureStats_getAllByProductEntry_customer_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type=pie this->MaxValue=2 2020-02-24 10:20:31 INFO 110.145.2.87 PropaleStats::getAllByProductEntry read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/PropaleStats_getAllByProductEntry_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type=pie this->MaxValue=4 2020-02-24 10:20:31 INFO 110.145.2.87 CommandeStats::getAllByProductEntry read data from cache file /opt/bitnami/apache2/htdocs/erp/documents/users/temp/CommandeStats_getAllByProductEntry_customer_en_AU_entity.1_user71.cache 1582488579. 2020-02-24 10:20:31 INFO 110.145.2.87 DolGraph::draw_jflot this->type=pie this->MaxValue=2 2020-02-24 10:20:31 INFO 110.145.2.87 box_graph_product_distribution::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.code_fournisseur, s.logo, s.email, c.rowid, c.ref, c.tms, c.date_commande, c.total_ht, c.tva as total_tva, c.total_ttc, c.fk_statut FROM doli_societe as s, doli_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5 2020-02-24 10:20:31 INFO 110.145.2.87 box_supplier_orders::showBox 2020-02-24 10:20:31 INFO 110.145.2.87 ModeleBoxes::showBox 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(u.rowid) as nb FROM doli_user as u WHERE u.statut > 0 AND u.entity IN (0,1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(s.rowid) as nb, s.client FROM doli_societe as s WHERE s.client IN (1,2,3) AND s.entity IN (1) GROUP BY s.client 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(s.rowid) as nb FROM doli_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(sp.rowid) as nb FROM doli_socpeople as sp WHERE sp.entity IN (1) AND (sp.priv='0' OR (sp.priv='1' AND sp.fk_user_creat=71)) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(p.rowid) as nb, fk_product_type FROM doli_product as p WHERE p.entity IN (1) GROUP BY fk_product_type 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(p.rowid) as nb FROM doli_propal as p LEFT JOIN doli_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(co.rowid) as nb FROM doli_commande as co LEFT JOIN doli_societe as s ON co.fk_soc = s.rowid WHERE co.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(f.rowid) as nb FROM doli_facture as f LEFT JOIN doli_societe as s ON f.fk_soc = s.rowid WHERE f.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(c.rowid) as nb FROM doli_contrat as c LEFT JOIN doli_societe as s ON c.fk_soc = s.rowid WHERE c.entity = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(fi.rowid) as nb FROM doli_fichinter as fi LEFT JOIN doli_societe as s ON fi.fk_soc = s.rowid WHERE fi.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(co.rowid) as nb FROM doli_commande_fournisseur as co LEFT JOIN doli_societe as s ON co.fk_soc = s.rowid WHERE co.entity = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(f.rowid) as nb FROM doli_facture_fourn as f LEFT JOIN doli_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(p.rowid) as nb FROM doli_supplier_proposal as p LEFT JOIN doli_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(p.rowid) as nb FROM doli_projet as p WHERE p.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(ex.rowid) as nb FROM doli_expensereport as ex WHERE ex.fk_statut > 0 AND ex.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT count(h.rowid) as nb FROM doli_holiday as h WHERE h.statut > 1 AND h.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT a.id, a.datep as dp FROM doli_actioncomm as a LEFT JOIN doli_societe as s ON a.fk_soc = s.rowid WHERE 1 = 1 AND a.percent >= 0 AND a.percent < 100 AND a.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid, p.fk_statut as status, p.fk_opp_status, p.datee as datee FROM (doli_projet as p) LEFT JOIN doli_societe as s on p.fk_soc = s.rowid WHERE p.fk_statut = 1 AND p.entity IN (1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT ctc.rowid, ctc.code FROM doli_c_type_contact as ctc WHERE ctc.element = 'project' AND ctc.source = 'internal' 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT DISTINCT p.rowid, p.ref FROM doli_projet as p, doli_element_contact as ec WHERE p.entity IN (1) AND ec.element_id = p.rowid AND ( p.public = 1 OR ( ec.fk_c_type_contact IN (161,160) AND ec.fk_socpeople = 71) ) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid as projectid, p.fk_statut as projectstatus, t.rowid as taskid, t.progress as progress, t.fk_statut as status, t.dateo as date_start, t.datee as datee FROM doli_projet as p LEFT JOIN doli_societe as s on p.fk_soc = s.rowid, doli_projet_task as t WHERE p.entity IN (1) AND p.fk_statut = 1 AND t.fk_projet = p.rowid AND t.progress < 100 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin, p.total_ht FROM doli_propal as p WHERE p.entity IN (1) AND p.fk_statut = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin, p.total_ht FROM doli_propal as p WHERE p.entity IN (1) AND p.fk_statut = 2 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid, p.ref, p.datec as datec FROM doli_supplier_proposal as p WHERE p.entity IN (1) AND p.fk_statut = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT p.rowid, p.ref, p.datec as datec FROM doli_supplier_proposal as p WHERE p.entity IN (1) AND p.fk_statut = 2 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut, c.total_ht FROM doli_commande as c WHERE c.entity IN (1) AND ((c.fk_statut IN (1,2)) OR (c.fk_statut = 3 AND c.facture = 0)) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date FROM doli_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (1, 2) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT cd.rowid, cd.date_ouverture_prevue as datefin FROM doli_contrat as c, doli_contratdet as cd, doli_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 0 AND c.fk_soc = s.rowid AND c.entity = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT cd.rowid, cd.date_fin_validite as datefin FROM doli_contrat as c, doli_contratdet as cd, doli_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 4 AND c.fk_soc = s.rowid AND c.entity = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT f.rowid, f.date_lim_reglement as datefin,f.fk_statut, f.total FROM doli_facture as f WHERE f.paye=0 AND f.entity IN (1) AND f.fk_statut = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut FROM doli_facture_fourn as ff WHERE ff.paye=0 AND ff.fk_statut > 0 AND ff.entity = 1 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::loadParentOf 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT fk_user as id_parent, rowid as id_son FROM doli_user WHERE fk_user <> 0 AND entity IN (0,1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::get_full_tree get user list 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM doli_user as u WHERE u.entity IN (0,1) 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::get_full_tree call to build_path_from_id_user 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=1 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=2 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=3 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=4 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=5 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=6 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=7 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=8 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=10 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=11 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=12 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=13 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=14 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=15 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=16 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=17 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=18 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=19 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=20 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=21 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=22 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=25 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=29 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=30 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=31 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=33 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=34 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=36 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=37 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=38 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=40 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=41 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=42 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=43 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=46 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=47 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=48 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=49 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=50 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=51 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=52 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=53 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=54 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=55 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=56 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=57 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=58 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=59 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=60 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=61 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=62 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=63 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=64 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=65 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=66 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=67 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=68 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=69 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=70 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::build_path_from_id_user id_user=71 protection=0 2020-02-24 10:20:31 DEBUG 110.145.2.87 User::get_full_tree dol_sort_array 2020-02-24 10:20:31 INFO 110.145.2.87 Build childid for id = 71 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT ex.rowid, ex.date_valid FROM doli_expensereport as ex WHERE ex.fk_statut = 2 AND ex.entity IN (1) AND (ex.fk_user_author IN (71) OR ex.fk_user_validator IN (71)) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT ex.rowid, ex.date_valid FROM doli_expensereport as ex WHERE ex.fk_statut = 5 AND ex.entity IN (1) AND (ex.fk_user_author IN (71) OR ex.fk_user_validator IN (71)) 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT h.rowid, h.date_debut FROM doli_holiday as h WHERE h.statut = 2 AND h.entity IN (1) AND (h.fk_user IN (71) OR h.fk_validator IN (71)) 2020-02-24 10:20:31 INFO 110.145.2.87 --- End access to /index.php 2020-02-24 10:20:31 INFO 110.145.2.87 --- Access to /custom/dcloud/css/dropbox.css.php - action=, massaction= 2020-02-24 10:20:31 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:31 INFO 110.145.2.87 --- End access to /custom/dcloud/css/dropbox.css.php 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /custom/autos/css/autos.css.php - action=, massaction= 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:32 DEBUG 110.145.2.87 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0 2020-02-24 10:20:32 DEBUG 110.145.2.87 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 doli_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /custom/autos/css/autos.css.php 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /custom/parts/css/parts.css.php - action=, massaction= 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:32 DEBUG 110.145.2.87 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0 2020-02-24 10:20:32 DEBUG 110.145.2.87 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 doli_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /custom/parts/css/parts.css.php 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /custom/wip/css/wip.css.php - action=, massaction= 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:32 DEBUG 110.145.2.87 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0 2020-02-24 10:20:32 DEBUG 110.145.2.87 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 doli_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /custom/wip/css/wip.css.php 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /theme/eldy/style.css.php - action=, massaction= 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:32 DEBUG 110.145.2.87 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0 2020-02-24 10:20:32 DEBUG 110.145.2.87 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 doli_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-02-24 10:20:32 DEBUG 110.145.2.87 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 doli_user as u LEFT JOIN doli_c_country as c ON u.fk_country = c.rowid LEFT JOIN doli_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'Benjamin.Broad' ORDER BY u.entity ASC 2020-02-24 10:20:32 INFO 110.145.2.87 fetch_name_optionals_label elementtype=user 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM doli_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT rowid, total_hsup_remunerees, total_hsup_rattrapees, dept, date_last_hsup, emptype, fk_service FROM doli_user_extrafields WHERE fk_object = 71 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT param, value FROM doli_user_param WHERE fk_user = 71 AND entity = 1 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT rowid, entity, type, page, param, value FROM doli_default_values WHERE entity IN (1) AND user_id IN (0, 71) 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_user_rights as ur, doli_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 71 AND r.perms IS NOT NULL 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_usergroup_rights as gr, doli_usergroup_user as gu, doli_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 71 AND r.perms IS NOT NULL 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /theme/eldy/style.css.php 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /core/js/lib_notification.js.php - action=, massaction= 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /core/js/lib_notification.js.php 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /core/js/lib_head.js.php - action=, massaction= 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /core/js/lib_head.js.php 2020-02-24 10:20:32 DEBUG 110.145.2.87 - This is an already logged session. _SESSION['dol_login']=Benjamin.Broad _SESSION['dol_entity']=1 2020-02-24 10:20:32 DEBUG 110.145.2.87 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 doli_user as u LEFT JOIN doli_c_country as c ON u.fk_country = c.rowid LEFT JOIN doli_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'Benjamin.Broad' ORDER BY u.entity ASC 2020-02-24 10:20:32 INFO 110.145.2.87 fetch_name_optionals_label elementtype=user 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM doli_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT rowid, total_hsup_remunerees, total_hsup_rattrapees, dept, date_last_hsup, emptype, fk_service FROM doli_user_extrafields WHERE fk_object = 71 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT param, value FROM doli_user_param WHERE fk_user = 71 AND entity = 1 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT rowid, entity, type, page, param, value FROM doli_default_values WHERE entity IN (1) AND user_id IN (0, 71) 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_user_rights as ur, doli_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 71 AND r.perms IS NOT NULL 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM doli_usergroup_rights as gr, doli_usergroup_user as gu, doli_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 71 AND r.perms IS NOT NULL 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /custom/upbuttons/js/upbuttons.js.php - action=, massaction= 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:32 DEBUG 110.145.2.87 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0 2020-02-24 10:20:32 DEBUG 110.145.2.87 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 doli_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /custom/upbuttons/js/upbuttons.js.php 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /core/js/lib_foot.js.php - action=, massaction= 2020-02-24 10:20:32 DEBUG 110.145.2.87 sql=SELECT transkey, transvalue FROM doli_overwrite_trans where lang='en_AU' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /core/js/lib_foot.js.php 2020-02-24 10:20:32 INFO 110.145.2.87 --- Access to /viewimage.php - action=, massaction= 2020-02-24 10:20:32 INFO 110.145.2.87 modulepart=mycompany original_file=logos/thumbs/Finch Web Logos-11_mini.png entity=1 2020-02-24 10:20:32 INFO 110.145.2.87 viewimage.php return file /opt/bitnami/apache2/htdocs/erp/documents/mycompany/logos/thumbs/Finch Web Logos-11_mini.png filename=Finch Web Logos-11_mini.png content-type=image/png 2020-02-24 10:20:32 INFO 110.145.2.87 --- End access to /viewimage.php