generate_pdf_invoice | 2025-02-17 10:09:15 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1556;
generate_pdf_invoice | 2025-02-17 10:09:20 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1556;
generate_pdf_invoice | 2025-02-17 10:18:10 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1557;
generate_pdf_invoice | 2025-02-17 10:18:16 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1557;
generate_pdf_invoice | 2025-02-17 10:24:23 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1558;
generate_pdf_invoice | 2025-02-17 10:24:23 | TRACE: CHECK GENERATE PDF INVOICE: 1
generate_pdf_invoice | 2025-02-17 10:24:23 | TRACE: HTML IS READY WHERE DO I PUT THE FILE: AMATOOLS - AMA Admin_DOC_1558_2025009_1739784263.pdf
generate_pdf_invoice | 2025-02-17 10:24:23 | TRACE: FILE LOCATIONS: /home/dupvift/amatools/amagestion/documents/AMA Admin_DOC_1558_2025009_1739784263.pdf - https://tools.ama.be/amagestion/documents/AMA Admin_DOC_1558_2025009_1739784263.pdf
generate_pdf_invoice | 2025-02-17 10:24:29 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1558;
generate_pdf_invoice | 2025-02-17 10:24:29 | TRACE: CHECK GENERATE PDF INVOICE: 0
generate_pdf_invoice | 2025-02-17 10:30:09 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1559;
generate_pdf_invoice | 2025-02-17 10:30:09 | TRACE: CHECK GENERATE PDF INVOICE: 1
generate_pdf_invoice | 2025-02-17 10:30:09 | TRACE: HTML IS READY WHERE DO I PUT THE FILE: AMATOOLS - AMA Admin_DOC_1559_2025010_1739784609.pdf
generate_pdf_invoice | 2025-02-17 10:30:10 | TRACE: FILE LOCATIONS: /home/dupvift/amatools/amagestion/documents/AMA Admin_DOC_1559_2025010_1739784609.pdf - https://tools.ama.be/amagestion/documents/AMA Admin_DOC_1559_2025010_1739784609.pdf
generate_pdf_invoice | 2025-02-17 10:30:15 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1559;
generate_pdf_invoice | 2025-02-17 10:30:15 | TRACE: CHECK GENERATE PDF INVOICE: 0
generate_pdf_invoice | 2025-02-17 10:38:11 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1560;
generate_pdf_invoice | 2025-02-17 10:38:11 | TRACE: CHECK GENERATE PDF INVOICE: 1
generate_pdf_invoice | 2025-02-17 10:38:12 | TRACE: HTML IS READY WHERE DO I PUT THE FILE: AMATOOLS - AMA Admin_DOC_1560_2025011_1739785092.pdf
generate_pdf_invoice | 2025-02-17 10:38:12 | TRACE: FILE LOCATIONS: /home/dupvift/amatools/amagestion/documents/AMA Admin_DOC_1560_2025011_1739785092.pdf - https://tools.ama.be/amagestion/documents/AMA Admin_DOC_1560_2025011_1739785092.pdf
generate_pdf_invoice | 2025-02-17 10:38:17 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1560;
generate_pdf_invoice | 2025-02-17 10:38:17 | TRACE: CHECK GENERATE PDF INVOICE: 0
generate_pdf_invoice | 2025-02-17 10:45:30 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1561;
generate_pdf_invoice | 2025-02-17 10:45:30 | TRACE: CHECK GENERATE PDF INVOICE: 1
generate_pdf_invoice | 2025-02-17 10:45:32 | TRACE: HTML IS READY WHERE DO I PUT THE FILE: AMATOOLS - AMA Admin_DOC_1561_2025012_1739785532.pdf
generate_pdf_invoice | 2025-02-17 10:45:32 | TRACE: FILE LOCATIONS: /home/dupvift/amatools/amagestion/documents/AMA Admin_DOC_1561_2025012_1739785532.pdf - https://tools.ama.be/amagestion/documents/AMA Admin_DOC_1561_2025012_1739785532.pdf
generate_pdf_invoice | 2025-02-17 10:45:37 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1561;
generate_pdf_invoice | 2025-02-17 10:45:37 | TRACE: CHECK GENERATE PDF INVOICE: 0
generate_pdf_invoice | 2025-02-17 10:50:44 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1562;
generate_pdf_invoice | 2025-02-17 10:50:44 | TRACE: CHECK GENERATE PDF INVOICE: 1
generate_pdf_invoice | 2025-02-17 10:50:45 | TRACE: HTML IS READY WHERE DO I PUT THE FILE: AMATOOLS - AMA Admin_DOC_1562_2025013_1739785845.pdf
generate_pdf_invoice | 2025-02-17 10:50:45 | TRACE: FILE LOCATIONS: /home/dupvift/amatools/amagestion/documents/AMA Admin_DOC_1562_2025013_1739785845.pdf - https://tools.ama.be/amagestion/documents/AMA Admin_DOC_1562_2025013_1739785845.pdf
generate_pdf_invoice | 2025-02-17 10:50:51 | TRACE: FIRST SQL STATEMENT:  SELECT d.ID, d.id_entite, d.id_place, d.id_client, d.id_place_client, d.description, d.date_emission, d.communication, 
                            d.titre, year(d.date_emission) as year_emi, d.date_echeance, DATE_ADD(d.date_emission, INTERVAL 7 DAY) as def_echeance, 
                            d.doc_status, d.doc_type, d.numero, d.last_user, d.last_timestamp, d.last_action, 
                            e.societe as entite, a.adresse as adresse_entite, a.cp as cp_entite, a.localisation as localisation_entite,
                            e.num_entreprise as tva_entite, c.nom,
                            c.societe as client, ac.adresse as adresse_client, ac.cp as cp_client, ac.localisation as localisation_client,
                            c.num_entreprise as tva_client, COALESCE(mef.meta_value, '') as logo_footer,
                            COALESCE(mp.meta_value, COALESCE(me.meta_value, '')) as invoice_logo, COALESCE(mpi.meta_value, '') as info_payment_message,
                            ad.description as doc_client_details
                        FROM ts_documents d
                        LEFT JOIN ts_entites e ON d.id_entite = e.ID
                        LEFT JOIN ts_document_details ad ON ad.id_document = d.ID AND ad.type = 'client_details'
                        LEFT JOIN ts_adresses a ON e.ID = a.id_source and a.source = 'entite' AND a.type = 'INVOICE' AND a.status = 'ACTIVE'
                        LEFT JOIN ts_clients c ON d.id_client = c.ID
                        LEFT JOIN ts_adresses ac ON c.ID = ac.id_source and ac.source = 'client' AND ac.type = 'INVOICE' AND ac.status = 'ACTIVE'
                        LEFT JOIN ts_entite_meta me ON d.id_entite = me.id_entite AND me.meta_key = 'LOGO'
                        LEFT JOIN ts_entite_meta mef ON d.id_entite = mef.id_entite AND mef.meta_key = 'LOGO_FOOTER'
                        LEFT JOIN ts_entite_meta mpi ON d.id_entite = mpi.id_entite AND mpi.meta_key = 'PAYMENT_INFO'
                        LEFT JOIN ts_place_meta mp ON d.id_place = mp.id_place AND mp.meta_key = 'LOGO'
                        WHERE d.id_entite in (SELECT rc.val_num 
                                        FROM ts_data_roles dr, ts_data_roles_content rc, ts_users_data_role ud 
                                        WHERE dr.data_type = 'entite' AND dr.ID = ud.id_data_role AND dr.ID = rc.id_data_role
                                        AND ud.id_user = 999)
                        AND d.doc_status <> 'DELETED' AND d.ID = 1562;
generate_pdf_invoice | 2025-02-17 10:50:51 | TRACE: CHECK GENERATE PDF INVOICE: 0