2024-08-24 19:19:07 DEBUG 202.134.172.203 DefaultValues::fetchAll 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT rowid,type,user_id,page,param,value FROM llxmy_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,0) AND entity IN (1,1)) 2024-08-24 19:19:07 NOTICE 202.134.172.203 --- Access to GET /public/onlinesign/newonlinesign.php - action=, massaction= 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT transkey, transvalue FROM llxmy_overwrite_trans where (lang='en_IN' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2024-08-24 19:19:07 DEBUG 202.134.172.203 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 llxmy_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.type DESC, m.position, m.rowid 2024-08-24 19:19:07 DEBUG 202.134.172.203 Propal::fetch 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT p.rowid, p.ref, p.entity, p.fk_soc, p.total_ttc, p.total_tva, p.localtax1, p.localtax2, p.total_ht, p.datec, p.date_signature as dates, p.date_valid as datev, p.datep as dp, p.fin_validite as dfv, p.date_livraison as delivery_date, p.model_pdf, p.last_main_doc, p.ref_client, ref_ext, p.extraparams, p.note_private, p.note_public, p.fk_projet as fk_project, p.fk_statut, p.fk_user_author, p.fk_user_valid, p.fk_user_cloture, p.fk_delivery_address, p.fk_availability, p.fk_input_reason, p.fk_cond_reglement, p.fk_mode_reglement, p.fk_account, p.fk_shipping_method, p.fk_warehouse, p.fk_incoterms, p.location_incoterms, p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc, p.tms as date_modification, i.libelle as label_incoterms, c.label as statut_label, ca.code as availability_code, ca.label as availability, dr.code as demand_reason_code, dr.label as demand_reason, cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc, p.deposit_percent, cp.code as mode_reglement_code, cp.libelle as mode_reglement FROM llxmy_propal as p LEFT JOIN llxmy_c_propalst as c ON p.fk_statut = c.id LEFT JOIN llxmy_c_paiement as cp ON p.fk_mode_reglement = cp.id AND cp.entity IN (1) LEFT JOIN llxmy_c_payment_term as cr ON p.fk_cond_reglement = cr.rowid AND cr.entity IN (1) LEFT JOIN llxmy_c_availability as ca ON p.fk_availability = ca.rowid LEFT JOIN llxmy_c_input_reason as dr ON p.fk_input_reason = dr.rowid LEFT JOIN llxmy_c_incoterms as i ON p.fk_incoterms = i.rowid WHERE p.entity = 1 AND p.ref='EH-PR0005/08/2024-25' 2024-08-24 19:19:07 DEBUG 202.134.172.203 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 llxmy_extrafields WHERE elementtype = 'propal' ORDER BY pos 2024-08-24 19:19:07 DEBUG 202.134.172.203 Propal::fetch_lines 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT d.rowid, d.fk_propal, d.fk_parent_line, d.label as custom_label, d.description, d.price, d.vat_src_code, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.localtax1_type, d.localtax2_type, d.qty, d.fk_remise_except, d.remise_percent, d.subprice, d.fk_product, d.info_bits, d.total_ht, d.total_tva, d.total_localtax1, d.total_localtax2, d.total_ttc, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht, d.special_code, d.rang, d.product_type, d.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.barcode as product_barcode, p.weight, p.weight_units, p.volume, p.volume_units, d.date_start, d.date_end, d.fk_multicurrency, d.multicurrency_code, d.multicurrency_subprice, d.multicurrency_total_ht, d.multicurrency_total_tva, d.multicurrency_total_ttc FROM llxmy_propaldet as d LEFT JOIN llxmy_product as p ON (d.fk_product = p.rowid) WHERE d.fk_propal = 14 ORDER by d.rang 2024-08-24 19:19:07 DEBUG 202.134.172.203 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 llxmy_extrafields WHERE elementtype = 'propaldet' ORDER BY pos 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT rowid, tax_value FROM llxmy_propaldet_extrafields WHERE fk_object = 30 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT rowid, tax_value FROM llxmy_propaldet_extrafields WHERE fk_object = 32 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxmy_societe as s LEFT JOIN llxmy_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxmy_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxmy_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxmy_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxmy_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxmy_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxmy_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxmy_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 19 2024-08-24 19:19:07 DEBUG 202.134.172.203 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 llxmy_extrafields WHERE elementtype = 'societe' ORDER BY pos 2024-08-24 19:19:07 DEBUG 202.134.172.203 Translate::loadCacheCurrencies 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT code_iso, label, unicode FROM llxmy_c_currencies WHERE active = 1 AND code_iso = 'INR' 2024-08-24 19:19:07 DEBUG 202.134.172.203 EcmFiles::fetch 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT t.rowid, t.ref, t.label, t.share, t.entity, t.filename, t.filepath, t.fullpath_orig, t.description, t.keywords, t.cover, t.position, t.gen_or_uploaded, t.extraparams, t.date_c, t.tms as date_m, t.fk_user_c, t.fk_user_m, t.note_private, t.note_public, t.acl, t.src_object_type, t.src_object_id FROM llxmy_ecm_files as t WHERE 1 = 1 AND t.filepath = 'propale/EH-PR0005_08_2024-25' AND t.filename = 'EH-PR0005_08_2024-25.pdf' AND t.entity = 1 2024-08-24 19:19:07 DEBUG 202.134.172.203 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 llxmy_extrafields WHERE elementtype = 'ecm_files' ORDER BY pos 2024-08-24 19:19:07 INFO 202.134.172.203 --- End access to /public/onlinesign/newonlinesign.php 2024-08-24 19:19:07 DEBUG 202.134.172.203 DefaultValues::fetchAll 2024-08-24 19:19:07 DEBUG 202.134.172.203 sql=SELECT rowid,type,user_id,page,param,value FROM llxmy_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,0) AND entity IN (1,1)) 2024-08-24 19:19:07 NOTICE 202.134.172.203 --- Access to GET /viewimage.php - action=, massaction= NOTOKENRENEWAL=1 2024-08-24 19:19:07 INFO 202.134.172.203 dol_check_secure_access_document modulepart=mycompany original_file=logos/thumbs/eHom_Logo_small.png entity=1 2024-08-24 19:19:07 INFO 202.134.172.203 viewimage.php return file /home/ehomindia/dolibarrdata/mycompany/logos/thumbs/eHom_Logo_small.png filename=eHom_Logo_small.png content-type=image/png 2024-08-24 19:19:07 INFO 202.134.172.203 --- End access to /viewimage.php 2024-08-24 19:19:12 DEBUG 202.134.172.203 DefaultValues::fetchAll 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT rowid,type,user_id,page,param,value FROM llxmy_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,0) AND entity IN (1,1)) 2024-08-24 19:19:12 NOTICE 202.134.172.203 --- Access to POST /public/onlinesign/newonlinesign.php - action=dosign, massaction= 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT transkey, transvalue FROM llxmy_overwrite_trans where (lang='en_IN' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2024-08-24 19:19:12 DEBUG 202.134.172.203 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 llxmy_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.type DESC, m.position, m.rowid 2024-08-24 19:19:12 DEBUG 202.134.172.203 Propal::fetch 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT p.rowid, p.ref, p.entity, p.fk_soc, p.total_ttc, p.total_tva, p.localtax1, p.localtax2, p.total_ht, p.datec, p.date_signature as dates, p.date_valid as datev, p.datep as dp, p.fin_validite as dfv, p.date_livraison as delivery_date, p.model_pdf, p.last_main_doc, p.ref_client, ref_ext, p.extraparams, p.note_private, p.note_public, p.fk_projet as fk_project, p.fk_statut, p.fk_user_author, p.fk_user_valid, p.fk_user_cloture, p.fk_delivery_address, p.fk_availability, p.fk_input_reason, p.fk_cond_reglement, p.fk_mode_reglement, p.fk_account, p.fk_shipping_method, p.fk_warehouse, p.fk_incoterms, p.location_incoterms, p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc, p.tms as date_modification, i.libelle as label_incoterms, c.label as statut_label, ca.code as availability_code, ca.label as availability, dr.code as demand_reason_code, dr.label as demand_reason, cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc, p.deposit_percent, cp.code as mode_reglement_code, cp.libelle as mode_reglement FROM llxmy_propal as p LEFT JOIN llxmy_c_propalst as c ON p.fk_statut = c.id LEFT JOIN llxmy_c_paiement as cp ON p.fk_mode_reglement = cp.id AND cp.entity IN (1) LEFT JOIN llxmy_c_payment_term as cr ON p.fk_cond_reglement = cr.rowid AND cr.entity IN (1) LEFT JOIN llxmy_c_availability as ca ON p.fk_availability = ca.rowid LEFT JOIN llxmy_c_input_reason as dr ON p.fk_input_reason = dr.rowid LEFT JOIN llxmy_c_incoterms as i ON p.fk_incoterms = i.rowid WHERE p.entity = 1 AND p.ref='EH-PR0005/08/2024-25' 2024-08-24 19:19:12 DEBUG 202.134.172.203 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 llxmy_extrafields WHERE elementtype = 'propal' ORDER BY pos 2024-08-24 19:19:12 DEBUG 202.134.172.203 Propal::fetch_lines 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT d.rowid, d.fk_propal, d.fk_parent_line, d.label as custom_label, d.description, d.price, d.vat_src_code, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.localtax1_type, d.localtax2_type, d.qty, d.fk_remise_except, d.remise_percent, d.subprice, d.fk_product, d.info_bits, d.total_ht, d.total_tva, d.total_localtax1, d.total_localtax2, d.total_ttc, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht, d.special_code, d.rang, d.product_type, d.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_tobatch, p.barcode as product_barcode, p.weight, p.weight_units, p.volume, p.volume_units, d.date_start, d.date_end, d.fk_multicurrency, d.multicurrency_code, d.multicurrency_subprice, d.multicurrency_total_ht, d.multicurrency_total_tva, d.multicurrency_total_ttc FROM llxmy_propaldet as d LEFT JOIN llxmy_product as p ON (d.fk_product = p.rowid) WHERE d.fk_propal = 14 ORDER by d.rang 2024-08-24 19:19:12 DEBUG 202.134.172.203 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 llxmy_extrafields WHERE elementtype = 'propaldet' ORDER BY pos 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT rowid, tax_value FROM llxmy_propaldet_extrafields WHERE fk_object = 30 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT rowid, tax_value FROM llxmy_propaldet_extrafields WHERE fk_object = 32 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxmy_societe as s LEFT JOIN llxmy_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxmy_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxmy_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxmy_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxmy_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxmy_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxmy_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxmy_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 19 2024-08-24 19:19:12 DEBUG 202.134.172.203 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 llxmy_extrafields WHERE elementtype = 'societe' ORDER BY pos 2024-08-24 19:19:12 DEBUG 202.134.172.203 Translate::loadCacheCurrencies 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT code_iso, label, unicode FROM llxmy_c_currencies WHERE active = 1 AND code_iso = 'INR' 2024-08-24 19:19:12 DEBUG 202.134.172.203 EcmFiles::fetch 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT t.rowid, t.ref, t.label, t.share, t.entity, t.filename, t.filepath, t.fullpath_orig, t.description, t.keywords, t.cover, t.position, t.gen_or_uploaded, t.extraparams, t.date_c, t.tms as date_m, t.fk_user_c, t.fk_user_m, t.note_private, t.note_public, t.acl, t.src_object_type, t.src_object_id FROM llxmy_ecm_files as t WHERE 1 = 1 AND t.filepath = 'propale/EH-PR0005_08_2024-25' AND t.filename = 'EH-PR0005_08_2024-25.pdf' AND t.entity = 1 2024-08-24 19:19:12 DEBUG 202.134.172.203 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 llxmy_extrafields WHERE elementtype = 'ecm_files' ORDER BY pos 2024-08-24 19:19:12 INFO 202.134.172.203 --- End access to /public/onlinesign/newonlinesign.php 2024-08-24 19:19:12 DEBUG 202.134.172.203 DefaultValues::fetchAll 2024-08-24 19:19:12 DEBUG 202.134.172.203 sql=SELECT rowid,type,user_id,page,param,value FROM llxmy_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,0) AND entity IN (1,1)) 2024-08-24 19:19:12 NOTICE 202.134.172.203 --- Access to GET /viewimage.php - action=, massaction= NOTOKENRENEWAL=1 2024-08-24 19:19:12 INFO 202.134.172.203 dol_check_secure_access_document modulepart=mycompany original_file=logos/thumbs/eHom_Logo_small.png entity=1 2024-08-24 19:19:12 INFO 202.134.172.203 viewimage.php return file /home/ehomindia/dolibarrdata/mycompany/logos/thumbs/eHom_Logo_small.png filename=eHom_Logo_small.png content-type=image/png 2024-08-24 19:19:12 INFO 202.134.172.203 --- End access to /viewimage.php 2024-08-24 19:19:19 DEBUG 202.134.172.203 DefaultValues::fetchAll 2024-08-24 19:19:19 DEBUG 202.134.172.203 sql=SELECT rowid,type,user_id,page,param,value FROM llxmy_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,0) AND entity IN (1,1)) 2024-08-24 19:19:19 NOTICE 202.134.172.203 --- Access to POST /core/ajax/onlineSign.php - action=importSignature, massaction= NOTOKENRENEWAL=1 2024-08-24 19:19:19 DEBUG 202.134.172.203 sql=SELECT transkey, transvalue FROM llxmy_overwrite_trans where (lang='en_IN' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC 2024-08-24 19:19:20 INFO 202.134.172.203 --- End access to /core/ajax/onlineSign.php