Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.provider AS provider_2,
  t0.entity_type AS entity_type_3,
  t0.entity_id AS entity_id_4,
  t0.external_id AS external_id_5,
  t0.external_hash AS external_hash_6,
  t0.sync_status AS sync_status_7,
  t0.last_pulled_at AS last_pulled_at_8,
  t0.last_pushed_at AS last_pushed_at_9,
  t0.last_error AS last_error_10,
  t0.raw_payload AS raw_payload_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.company_id AS company_id_14
FROM
  external_reference t0
WHERE
  t0.company_id = ?
  AND t0.provider = ?
  AND t0.entity_type = ?
  AND t0.external_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = 1 AND t0.provider = 'bexio' AND t0.entity_type = 'invoice' AND t0.external_id = '3022' LIMIT 1;

"COMMIT"

"COMMIT";

INSERT INTO order_line (
  position, text, quantity, unit_price,
  discount, total, tax_rate, raw_payload,
  order_entity_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (1, '<strong>Description<br /><br /></strong>Dans le prolongement de notre rencontre de fin d&rsquo;ann&eacute;e derni&egrave;re, nous vous proposons une offre compl&egrave;te et sur mesure pour r&eacute;pondre &agrave; l&rsquo;ensemble de vos besoins en signal&eacute;tique.<br /><br /><span style=\"text-decoration: underline;\">Selon validation par e-mail du 8 juin 2025</span><br />
<ul>
<li>Signal&eacute;tique ext&eacute;rieure pour bureaux et centres</li>
<li>Signal&eacute;tique pour Rue st-Maurice 4</li>
<li>Marquage pour places de parc</li>
<li>Marquage des entr&eacute;es pour St-S&eacute;bastien 4 &agrave; Del&eacute;mont et Route de C&oelig;uve 37 &agrave; Porrentruy</li>
</ul>', NULL, NULL, NULL, NULL, NULL, '{\"id\":3501,\"type\":\"KbPositionText\",\"text\":\"<strong>Description<br \\/><br \\/><\\/strong>Dans le prolongement de notre rencontre de fin d&rsquo;ann&eacute;e derni&egrave;re, nous vous proposons une offre compl&egrave;te et sur mesure pour r&eacute;pondre &agrave; l&rsquo;ensemble de vos besoins en signal&eacute;tique.<br \\/><br \\/><span style=\\\"text-decoration: underline;\\\">Selon validation par e-mail du 8 juin 2025<\\/span><br \\/>\\r\\n<ul>\\r\\n<li>Signal&eacute;tique ext&eacute;rieure pour bureaux et centres<\\/li>\\r\\n<li>Signal&eacute;tique pour Rue st-Maurice 4<\\/li>\\r\\n<li>Marquage pour places de parc<\\/li>\\r\\n<li>Marquage des entr&eacute;es pour St-S&eacute;bastien 4 &agrave; Del&eacute;mont et Route de C&oelig;uve 37 &agrave; Porrentruy<\\/li>\\r\\n<\\/ul>\",\"show_pos_nr\":false,\"pos\":null,\"internal_pos\":1,\"parent_id\":null,\"is_optional\":false}', 235);

INSERT INTO sync_log (
  provider, entity_type, entity_id,
  external_id, direction, status, message,
  payload, created_at, company_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO sync_log (provider, entity_type, entity_id, external_id, direction, status, message, payload, created_at, company_id) VALUES ('bexio', 'invoice', 1715, '3177', 'pull', 'success', 'Facture mise à jour depuis Bexio.', '{\"id\":3177,\"document_nr\":\"POM-FAC2026-03177\",\"title\":\"GF-Divers2026-POM4578\",\"contact_id\":917,\"contact_sub_id\":null,\"user_id\":8,\"project_id\":null,\"logopaper_id\":1,\"language_id\":2,\"bank_account_id\":1,\"currency_id\":1,\"payment_type_id\":4,\"header\":\"Nous vous remercions pour la confiance t&eacute;moign&eacute;e.\",\"footer\":\"&Agrave; disposition pour tout compl&eacute;ment d\'information.<br \\/><br \\/>Merci d&rsquo;effectuer le paiement complet via cette facture uniquement. Nos factures sont payables sous 30 jours. Pass&eacute; ce d&eacute;lai, un rappel automatique sera envoy&eacute; par e-mail. Toutes les factures et rappels sont transmis par e-mail. Si l&rsquo;adresse de destinataire ne devait pas correspondre, nous vous prions d&egrave;s lors de nous transmettre les coordonn&eacute;es exactes. Nos tarifs peuvent &eacute;voluer selon les co&ucirc;ts de nos prestataires.<br \\/><br \\/>Nos conditions g&eacute;n&eacute;rales sont accessibles &agrave; l\'adresse: www.pom-xtd.ch\\/cg\",\"total_gross\":\"3617.000000\",\"total_net\":\"3617.000000\",\"total_taxes\":\"292.9770\",\"total_received_payments\":\"0.000000\",\"total_credit_vouchers\":\"0.000000\",\"total_remaining_payments\":\"3910.0000\",\"total\":\"3910.000000\",\"total_rounding_difference\":0.02,\"mwst_type\":0,\"mwst_is_net\":true,\"show_position_taxes\":true,\"is_valid_from\":\"2026-05-08\",\"is_valid_to\":\"2026-06-06\",\"contact_address\":\"GF R\\u00e9alisations\\nM. Florent Greder\\nCH - 2746 Cr\\u00e9mines\",\"kb_item_status_id\":8,\"reference\":null,\"api_reference\":null,\"viewed_by_client_at\":null,\"updated_at\":\"2026-07-07 12:01:33\",\"esr_id\":2985,\"qr_invoice_id\":2985,\"template_slug\":\"5fbe6df9b774d50dce04b108\",\"taxs\":[{\"percentage\":\"8.10\",\"value\":\"292.9770\"}],\"positions\":[{\"id\":3606,\"type\":\"KbPositionText\",\"text\":\"<strong><\\/strong><strong>Selon discussions avec S. Geiser<\\/strong>\\r\\n<ul>\\r\\n<li>Production de 3 nouveaux drapeaux<\\/li>\\r\\n<li>Nouvelles cartes de visite avec QR code et pictos Sociel Media<\\/li>\\r\\n<li>Stickers en d&eacute;coupe pour v&eacute;hicules en noir et\\/ou orange 80x30 cm, 10 x10 cm<\\/li>\\r\\n<li>Stickers imprim&eacute;s pour outils selon mod&egrave;le existant<\\/li>\\r\\n<li>B&acirc;ches micro-perfor&eacute;es (mesh) grandes et petites selon mod&egrave;les existants<\\/li>\\r\\n<li>T-shirts Engelbert Strauss fournis par le client avec flocage FLEX (comme premi&egrave;re s&eacute;rie)<\\/li>\\r\\n<\\/ul>\",\"show_pos_nr\":false,\"pos\":null,\"internal_pos\":1,\"parent_id\":null,\"is_optional\":false},{\"id\":13076,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Graphisme et mise en page<\\/strong><ul>\\n<li>Adaptation graphique et modification des supports suivants:\\n<ul>\\n<li>Drapeaux (nouveau mod\\u00e8le)<\\/li>\\n<li>Cartes de visite<\\/li>\\n<li>Stickers pour v\\u00e9hicules (2 formats)<\\/li>\\n<\\/ul>\\n<\\/li>\\n<li>Corrections\\/modification jusqu\'au BAT02*<\\/li>\\n<li>Finalisation pour production<\\/li>\\n<\\/ul> <i>*Toute modification survenant apr\\u00e8s le 2e BAT est factur\\u00e9e au tarif horaire de CHF 150.\\u2013<\\/i>\",\"unit_price\":\"300.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"300.000000\",\"pos\":\"1\",\"internal_pos\":2,\"parent_id\":null,\"is_optional\":false,\"article_id\":2},{\"id\":13077,\"type\":\"KbPositionArticle\",\"amount\":\"3.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Drapeaux (Production)<\\/strong><ul class=\\\"ql-rendered-list-container\\\" data-is-root=\\\"true\\\" data-test=\\\"rendered-list-container\\\">\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-thB-UKdZ92\\\" data-test=\\\"rendered-list-item-bullet\\\">Hauteur totale: 346cm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-ZVaXCIa7WS\\\" data-test=\\\"rendered-list-item-bullet\\\">Format de la voile: 80x280cm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-UJ_mKiNnZd\\\" data-test=\\\"rendered-list-item-bullet\\\">Tissu ECO, 160g\\/m2<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-vrYlcvRlhn\\\" data-test=\\\"rendered-list-item-bullet\\\">M\\u00e2t \\u00f840mm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-Lv21gK8fVd\\\" data-test=\\\"rendered-list-item-bullet\\\">Support \\u00e0 visser pour terre ou neige<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-atwpc-6SOo\\\" data-test=\\\"rendered-list-item-bullet\\\">Garantie: 1 an<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-7RsqXVGWjc\\\" data-test=\\\"rendered-list-item-bullet\\\">Il est conseill\\u00e9 de rentrer les drapeaux lors de vents \\u00e0 partir de 60km\\/h<\\/li>\\n<\\/ul> <i>D\\u00e9lai de production: environ 2-3 semaines d\\u00e8s validation du BAT final.<\\/i>\",\"unit_price\":\"425.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"1275.000000\",\"pos\":\"2\",\"internal_pos\":3,\"parent_id\":null,\"is_optional\":false,\"article_id\":3},{\"id\":13078,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Carte de visite (impression) \\u2013 350g \\u2013 OFFSET<\\/strong><ul>\\n<li>REF-<span class=\\\"ref-prod\\\">P24-24-75-35<\\/span><\\/li>\\n<li>85\\u00d755 mm<\\/li>\\n<li>Papier 350g\\/m2 Offset<\\/li>\\n<li>Impression 4\\/4 CMJN \\u2013 recto-verso<\\/li>\\n<li>200 exemplaires<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"145.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"145.000000\",\"pos\":\"3\",\"internal_pos\":4,\"parent_id\":null,\"is_optional\":false,\"article_id\":4},{\"id\":13079,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant v\\u00e9hicules grand - 80x30 cm<\\/strong><ul>\\n<li>Mati\\u00e8re teint\\u00e9 dans la masse<\\/li>\\n<li>D\\u00e9coup\\u00e9 et mis sous tape d\'application<\\/li>\\n<li>5x orange et 8x noir<\\/li>\\n<li>Finitions brillante (existe aussi en mat sur demande)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"375.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"375.000000\",\"pos\":\"4\",\"internal_pos\":5,\"parent_id\":null,\"is_optional\":false,\"article_id\":5},{\"id\":13080,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant v\\u00e9hicules petit - 10x10 cm<\\/strong><ul>\\n<li>Mati\\u00e8re teint\\u00e9 dans la masse<\\/li>\\n<li>D\\u00e9coup\\u00e9 et mis sous tape d\'application<\\/li>\\n<li>30x orange<\\/li>\\n<li>Finitions brillante (existe aussi en mat sur demande)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"135.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"135.000000\",\"pos\":\"5\",\"internal_pos\":6,\"parent_id\":null,\"is_optional\":false,\"article_id\":6},{\"id\":13081,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant pour outillage de chantier<\\/strong><ul>\\n<li>Laminage de protection brillant<\\/li>\\n<li>Impression en quadrichromie&nbsp;<\\/li>\\n<li>Longue dur\\u00e9e<\\/li>\\n<li>Ext\\u00e9rieur et int\\u00e9rieur&nbsp;<\\/li>\\n<li>D\\u00e9coupe au trac\\u00e9&nbsp;<\\/li>\\n<li>Dimension 100x45mm<\\/li>\\n<li>Quantit\\u00e9 60x (20x par couleurs)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"92.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"92.000000\",\"pos\":\"6\",\"internal_pos\":7,\"parent_id\":null,\"is_optional\":false,\"article_id\":7},{\"id\":13082,\"type\":\"KbPositionArticle\",\"amount\":\"2.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>B\\u00e2che micro-perfor\\u00e9 (mesh) - Grande - 2x1<\\/strong><ul>\\n<li>B\\u00e2che mesh 300 g\\/m2<\\/li>\\n<li>Format 2000 x 1000 mm<\\/li>\\n<li>Impression quadrichromie<\\/li>\\n<li>Recto<\\/li>\\n<li>Avec ourlets (bords renforc\\u00e9s)<\\/li>\\n<li>Avec \\u0153illets de 12 mm tout autour, tous les 50 cm<\\/li>\\n<li>1x orange et 1x noire<\\/li>\\n<\\/ul> <i>Le format peut \\u00eatre vertical ou horizontal. Les frais de livraison, ainsi que les \\u00e9ventuels frais de mise en page, ne sont pas inclus dans ce tarif. Les d\\u00e9lais de production sont d\\u2019au minimum 7 jours ouvrables. La qualit\\u00e9 des b\\u00e2ches peut se d\\u00e9t\\u00e9riorer selon les conditions d\\u2019utilisation (int\\u00e9rieur ou ext\\u00e9rieur) et n\\u2019est garantie que pour une dur\\u00e9e d\\u2019un an.<\\/i>\",\"unit_price\":\"170.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"340.000000\",\"pos\":\"7\",\"internal_pos\":8,\"parent_id\":null,\"is_optional\":false,\"article_id\":8},{\"id\":13083,\"type\":\"KbPositionArticle\",\"amount\":\"2.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>B\\u00e2che micro-perfor\\u00e9 (mesh) - Petite - 1000x500<\\/strong><ul>\\n<li>B\\u00e2che mesh 300 g\\/m2<\\/li>\\n<li>Format 1000 x 500 mm<\\/li>\\n<li>Impression quadrichromie<\\/li>\\n<li>Recto<\\/li>\\n<li>Avec ourlets (bords renforc\\u00e9s)<\\/li>\\n<li>Avec \\u0153illets de 12 mm tout autour, tous les 50 cm<\\/li>\\n<li>1x orange et 1x noire<\\/li>\\n<\\/ul> <i>Le format peut \\u00eatre vertical ou horizontal. Les frais de livraison, ainsi que les \\u00e9ventuels frais de mise en page, ne sont pas inclus dans ce tarif. Les d\\u00e9lais de production sont d\\u2019au minimum 7 jours ouvrables. La qualit\\u00e9 des b\\u00e2ches peut se d\\u00e9t\\u00e9riorer selon les conditions d\\u2019utilisation (int\\u00e9rieur ou ext\\u00e9rieur) et n\\u2019est garantie que pour une dur\\u00e9e d\\u2019un an.<\\/i>\",\"unit_price\":\"105.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"210.000000\",\"pos\":\"8\",\"internal_pos\":9,\"parent_id\":null,\"is_optional\":false,\"article_id\":9},{\"id\":13084,\"type\":\"KbPositionArticle\",\"amount\":\"25.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Impression sur textile - FLEX<\\/strong><ul>\\n<li>Textiles fournis par le client (majoration du prix)<\\/li>\\n<li>Technique flex identique \\u00e0 premi\\u00e8re s\\u00e9rie<\\/li>\\n<li>2 emplacements (c\\u0153ur + dos)<\\/li>\\n<li>1 couleur (orange)<\\/li>\\n<li>25 exemplaires<\\/li>\\n<li>Rabais sp\\u00e9cial de 25% (augmentation des prix 2026)<\\/li>\\n<\\/ul> <i>Les visuels doivent respecter des r\\u00e8gles pr\\u00e9cises. Toute adaptation, mise en conformit\\u00e9 ou cr\\u00e9ation sera factur\\u00e9e au tarif horaire. Les prix varient selon la quantit\\u00e9 d\'impression, la taille et la complexit\\u00e9 des visuels.<\\/i>\",\"unit_price\":\"28.000000\",\"discount_in_percent\":\"25.0000\",\"position_total\":\"525.000000\",\"pos\":\"9\",\"internal_pos\":10,\"parent_id\":null,\"is_optional\":false,\"article_id\":10},{\"id\":13085,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Frais annexes (estimation)<\\/strong><p>Nous d\\u00e9finissons un montant estimatif couvrant les frais annexes, suppl\\u00e9ments ou marges, afin d\\u2019\\u00e9viter toute surprise (pour vous et pour nous). Ce montant peut \\u00e9voluer en fonction de l\\u2019avancement et des ajustements du mandat. Ces frais incluent notamment:<\\/p>\\n<ul>\\n<li>La gestion de projet (en compl\\u00e9ment de celle \\u00e9ventuellement incluse dans les autres prestations)<\\/li>\\n<li>Les \\u00e9changes, s\\u00e9ances, pr\\u00e9sentations, etc. \\u2014 marge pr\\u00e9visionnelle en plus des workshops de base<\\/li>\\n<li>Les frais administratifs, techniques et de manutention<\\/li>\\n<li>Les \\u00e9ventuels frais de livraison et de d\\u00e9placement<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"220.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"220.000000\",\"pos\":\"10\",\"internal_pos\":11,\"parent_id\":null,\"is_optional\":false,\"article_id\":11}],\"network_link\":\"https:\\/\\/network.bexio.com\\/invoice\\/d99a479d8ded5b0970d61acff2c6b5987954bed43f0351f498ad557edceaad1c\"}', '2026-07-07 13:01:15', 1);

UPDATE
  integration_connection
SET
  last_sync_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE integration_connection SET last_sync_at = '2026-07-07 13:01:33', updated_at = '2026-07-07 13:01:33' WHERE id = 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.text AS text_3,
  t0.quantity AS quantity_4,
  t0.unit_price AS unit_price_5,
  t0.discount AS discount_6,
  t0.total AS total_7,
  t0.tax_rate AS tax_rate_8,
  t0.raw_payload AS raw_payload_9,
  t0.order_entity_id AS order_entity_id_10
FROM
  order_line t0
WHERE
  t0.order_entity_id = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.discount AS discount_6, t0.total AS total_7, t0.tax_rate AS tax_rate_8, t0.raw_payload AS raw_payload_9, t0.order_entity_id AS order_entity_id_10 FROM order_line t0 WHERE t0.order_entity_id = 235 ORDER BY t0.position ASC, t0.id ASC;

INSERT INTO invoice_line (
  position, text, quantity, unit_price,
  discount, total, tax_rate, raw_payload,
  invoice_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (1, '<strong></strong><strong>Selon discussions avec S. Geiser</strong>
<ul>
<li>Production de 3 nouveaux drapeaux</li>
<li>Nouvelles cartes de visite avec QR code et pictos Sociel Media</li>
<li>Stickers en d&eacute;coupe pour v&eacute;hicules en noir et/ou orange 80x30 cm, 10 x10 cm</li>
<li>Stickers imprim&eacute;s pour outils selon mod&egrave;le existant</li>
<li>B&acirc;ches micro-perfor&eacute;es (mesh) grandes et petites selon mod&egrave;les existants</li>
<li>T-shirts Engelbert Strauss fournis par le client avec flocage FLEX (comme premi&egrave;re s&eacute;rie)</li>
</ul>', NULL, NULL, NULL, NULL, NULL, '{\"id\":3606,\"type\":\"KbPositionText\",\"text\":\"<strong><\\/strong><strong>Selon discussions avec S. Geiser<\\/strong>\\r\\n<ul>\\r\\n<li>Production de 3 nouveaux drapeaux<\\/li>\\r\\n<li>Nouvelles cartes de visite avec QR code et pictos Sociel Media<\\/li>\\r\\n<li>Stickers en d&eacute;coupe pour v&eacute;hicules en noir et\\/ou orange 80x30 cm, 10 x10 cm<\\/li>\\r\\n<li>Stickers imprim&eacute;s pour outils selon mod&egrave;le existant<\\/li>\\r\\n<li>B&acirc;ches micro-perfor&eacute;es (mesh) grandes et petites selon mod&egrave;les existants<\\/li>\\r\\n<li>T-shirts Engelbert Strauss fournis par le client avec flocage FLEX (comme premi&egrave;re s&eacute;rie)<\\/li>\\r\\n<\\/ul>\",\"show_pos_nr\":false,\"pos\":null,\"internal_pos\":1,\"parent_id\":null,\"is_optional\":false}', 1715);

DELETE FROM
  order_line
WHERE
  id = ?

DELETE FROM order_line WHERE id = 58312;

UPDATE
  external_reference
SET
  external_hash = ?,
  last_pulled_at = ?,
  raw_payload = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE external_reference SET external_hash = '5bf9e7ca69a426a4de92d219becd7c568f5cfb9c', last_pulled_at = '2026-07-07 13:01:15', raw_payload = '{\"id\":3177,\"document_nr\":\"POM-FAC2026-03177\",\"title\":\"GF-Divers2026-POM4578\",\"contact_id\":917,\"contact_sub_id\":null,\"user_id\":8,\"project_id\":null,\"logopaper_id\":1,\"language_id\":2,\"bank_account_id\":1,\"currency_id\":1,\"payment_type_id\":4,\"header\":\"Nous vous remercions pour la confiance t&eacute;moign&eacute;e.\",\"footer\":\"&Agrave; disposition pour tout compl&eacute;ment d\'information.<br \\/><br \\/>Merci d&rsquo;effectuer le paiement complet via cette facture uniquement. Nos factures sont payables sous 30 jours. Pass&eacute; ce d&eacute;lai, un rappel automatique sera envoy&eacute; par e-mail. Toutes les factures et rappels sont transmis par e-mail. Si l&rsquo;adresse de destinataire ne devait pas correspondre, nous vous prions d&egrave;s lors de nous transmettre les coordonn&eacute;es exactes. Nos tarifs peuvent &eacute;voluer selon les co&ucirc;ts de nos prestataires.<br \\/><br \\/>Nos conditions g&eacute;n&eacute;rales sont accessibles &agrave; l\'adresse: www.pom-xtd.ch\\/cg\",\"total_gross\":\"3617.000000\",\"total_net\":\"3617.000000\",\"total_taxes\":\"292.9770\",\"total_received_payments\":\"0.000000\",\"total_credit_vouchers\":\"0.000000\",\"total_remaining_payments\":\"3910.0000\",\"total\":\"3910.000000\",\"total_rounding_difference\":0.02,\"mwst_type\":0,\"mwst_is_net\":true,\"show_position_taxes\":true,\"is_valid_from\":\"2026-05-08\",\"is_valid_to\":\"2026-06-06\",\"contact_address\":\"GF R\\u00e9alisations\\nM. Florent Greder\\nCH - 2746 Cr\\u00e9mines\",\"kb_item_status_id\":8,\"reference\":null,\"api_reference\":null,\"viewed_by_client_at\":null,\"updated_at\":\"2026-07-07 12:01:33\",\"esr_id\":2985,\"qr_invoice_id\":2985,\"template_slug\":\"5fbe6df9b774d50dce04b108\",\"taxs\":[{\"percentage\":\"8.10\",\"value\":\"292.9770\"}],\"positions\":[{\"id\":3606,\"type\":\"KbPositionText\",\"text\":\"<strong><\\/strong><strong>Selon discussions avec S. Geiser<\\/strong>\\r\\n<ul>\\r\\n<li>Production de 3 nouveaux drapeaux<\\/li>\\r\\n<li>Nouvelles cartes de visite avec QR code et pictos Sociel Media<\\/li>\\r\\n<li>Stickers en d&eacute;coupe pour v&eacute;hicules en noir et\\/ou orange 80x30 cm, 10 x10 cm<\\/li>\\r\\n<li>Stickers imprim&eacute;s pour outils selon mod&egrave;le existant<\\/li>\\r\\n<li>B&acirc;ches micro-perfor&eacute;es (mesh) grandes et petites selon mod&egrave;les existants<\\/li>\\r\\n<li>T-shirts Engelbert Strauss fournis par le client avec flocage FLEX (comme premi&egrave;re s&eacute;rie)<\\/li>\\r\\n<\\/ul>\",\"show_pos_nr\":false,\"pos\":null,\"internal_pos\":1,\"parent_id\":null,\"is_optional\":false},{\"id\":13076,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Graphisme et mise en page<\\/strong><ul>\\n<li>Adaptation graphique et modification des supports suivants:\\n<ul>\\n<li>Drapeaux (nouveau mod\\u00e8le)<\\/li>\\n<li>Cartes de visite<\\/li>\\n<li>Stickers pour v\\u00e9hicules (2 formats)<\\/li>\\n<\\/ul>\\n<\\/li>\\n<li>Corrections\\/modification jusqu\'au BAT02*<\\/li>\\n<li>Finalisation pour production<\\/li>\\n<\\/ul> <i>*Toute modification survenant apr\\u00e8s le 2e BAT est factur\\u00e9e au tarif horaire de CHF 150.\\u2013<\\/i>\",\"unit_price\":\"300.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"300.000000\",\"pos\":\"1\",\"internal_pos\":2,\"parent_id\":null,\"is_optional\":false,\"article_id\":2},{\"id\":13077,\"type\":\"KbPositionArticle\",\"amount\":\"3.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Drapeaux (Production)<\\/strong><ul class=\\\"ql-rendered-list-container\\\" data-is-root=\\\"true\\\" data-test=\\\"rendered-list-container\\\">\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-thB-UKdZ92\\\" data-test=\\\"rendered-list-item-bullet\\\">Hauteur totale: 346cm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-ZVaXCIa7WS\\\" data-test=\\\"rendered-list-item-bullet\\\">Format de la voile: 80x280cm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-UJ_mKiNnZd\\\" data-test=\\\"rendered-list-item-bullet\\\">Tissu ECO, 160g\\/m2<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-vrYlcvRlhn\\\" data-test=\\\"rendered-list-item-bullet\\\">M\\u00e2t \\u00f840mm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-Lv21gK8fVd\\\" data-test=\\\"rendered-list-item-bullet\\\">Support \\u00e0 visser pour terre ou neige<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-atwpc-6SOo\\\" data-test=\\\"rendered-list-item-bullet\\\">Garantie: 1 an<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-7RsqXVGWjc\\\" data-test=\\\"rendered-list-item-bullet\\\">Il est conseill\\u00e9 de rentrer les drapeaux lors de vents \\u00e0 partir de 60km\\/h<\\/li>\\n<\\/ul> <i>D\\u00e9lai de production: environ 2-3 semaines d\\u00e8s validation du BAT final.<\\/i>\",\"unit_price\":\"425.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"1275.000000\",\"pos\":\"2\",\"internal_pos\":3,\"parent_id\":null,\"is_optional\":false,\"article_id\":3},{\"id\":13078,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Carte de visite (impression) \\u2013 350g \\u2013 OFFSET<\\/strong><ul>\\n<li>REF-<span class=\\\"ref-prod\\\">P24-24-75-35<\\/span><\\/li>\\n<li>85\\u00d755 mm<\\/li>\\n<li>Papier 350g\\/m2 Offset<\\/li>\\n<li>Impression 4\\/4 CMJN \\u2013 recto-verso<\\/li>\\n<li>200 exemplaires<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"145.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"145.000000\",\"pos\":\"3\",\"internal_pos\":4,\"parent_id\":null,\"is_optional\":false,\"article_id\":4},{\"id\":13079,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant v\\u00e9hicules grand - 80x30 cm<\\/strong><ul>\\n<li>Mati\\u00e8re teint\\u00e9 dans la masse<\\/li>\\n<li>D\\u00e9coup\\u00e9 et mis sous tape d\'application<\\/li>\\n<li>5x orange et 8x noir<\\/li>\\n<li>Finitions brillante (existe aussi en mat sur demande)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"375.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"375.000000\",\"pos\":\"4\",\"internal_pos\":5,\"parent_id\":null,\"is_optional\":false,\"article_id\":5},{\"id\":13080,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant v\\u00e9hicules petit - 10x10 cm<\\/strong><ul>\\n<li>Mati\\u00e8re teint\\u00e9 dans la masse<\\/li>\\n<li>D\\u00e9coup\\u00e9 et mis sous tape d\'application<\\/li>\\n<li>30x orange<\\/li>\\n<li>Finitions brillante (existe aussi en mat sur demande)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"135.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"135.000000\",\"pos\":\"5\",\"internal_pos\":6,\"parent_id\":null,\"is_optional\":false,\"article_id\":6},{\"id\":13081,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant pour outillage de chantier<\\/strong><ul>\\n<li>Laminage de protection brillant<\\/li>\\n<li>Impression en quadrichromie&nbsp;<\\/li>\\n<li>Longue dur\\u00e9e<\\/li>\\n<li>Ext\\u00e9rieur et int\\u00e9rieur&nbsp;<\\/li>\\n<li>D\\u00e9coupe au trac\\u00e9&nbsp;<\\/li>\\n<li>Dimension 100x45mm<\\/li>\\n<li>Quantit\\u00e9 60x (20x par couleurs)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"92.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"92.000000\",\"pos\":\"6\",\"internal_pos\":7,\"parent_id\":null,\"is_optional\":false,\"article_id\":7},{\"id\":13082,\"type\":\"KbPositionArticle\",\"amount\":\"2.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>B\\u00e2che micro-perfor\\u00e9 (mesh) - Grande - 2x1<\\/strong><ul>\\n<li>B\\u00e2che mesh 300 g\\/m2<\\/li>\\n<li>Format 2000 x 1000 mm<\\/li>\\n<li>Impression quadrichromie<\\/li>\\n<li>Recto<\\/li>\\n<li>Avec ourlets (bords renforc\\u00e9s)<\\/li>\\n<li>Avec \\u0153illets de 12 mm tout autour, tous les 50 cm<\\/li>\\n<li>1x orange et 1x noire<\\/li>\\n<\\/ul> <i>Le format peut \\u00eatre vertical ou horizontal. Les frais de livraison, ainsi que les \\u00e9ventuels frais de mise en page, ne sont pas inclus dans ce tarif. Les d\\u00e9lais de production sont d\\u2019au minimum 7 jours ouvrables. La qualit\\u00e9 des b\\u00e2ches peut se d\\u00e9t\\u00e9riorer selon les conditions d\\u2019utilisation (int\\u00e9rieur ou ext\\u00e9rieur) et n\\u2019est garantie que pour une dur\\u00e9e d\\u2019un an.<\\/i>\",\"unit_price\":\"170.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"340.000000\",\"pos\":\"7\",\"internal_pos\":8,\"parent_id\":null,\"is_optional\":false,\"article_id\":8},{\"id\":13083,\"type\":\"KbPositionArticle\",\"amount\":\"2.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>B\\u00e2che micro-perfor\\u00e9 (mesh) - Petite - 1000x500<\\/strong><ul>\\n<li>B\\u00e2che mesh 300 g\\/m2<\\/li>\\n<li>Format 1000 x 500 mm<\\/li>\\n<li>Impression quadrichromie<\\/li>\\n<li>Recto<\\/li>\\n<li>Avec ourlets (bords renforc\\u00e9s)<\\/li>\\n<li>Avec \\u0153illets de 12 mm tout autour, tous les 50 cm<\\/li>\\n<li>1x orange et 1x noire<\\/li>\\n<\\/ul> <i>Le format peut \\u00eatre vertical ou horizontal. Les frais de livraison, ainsi que les \\u00e9ventuels frais de mise en page, ne sont pas inclus dans ce tarif. Les d\\u00e9lais de production sont d\\u2019au minimum 7 jours ouvrables. La qualit\\u00e9 des b\\u00e2ches peut se d\\u00e9t\\u00e9riorer selon les conditions d\\u2019utilisation (int\\u00e9rieur ou ext\\u00e9rieur) et n\\u2019est garantie que pour une dur\\u00e9e d\\u2019un an.<\\/i>\",\"unit_price\":\"105.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"210.000000\",\"pos\":\"8\",\"internal_pos\":9,\"parent_id\":null,\"is_optional\":false,\"article_id\":9},{\"id\":13084,\"type\":\"KbPositionArticle\",\"amount\":\"25.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Impression sur textile - FLEX<\\/strong><ul>\\n<li>Textiles fournis par le client (majoration du prix)<\\/li>\\n<li>Technique flex identique \\u00e0 premi\\u00e8re s\\u00e9rie<\\/li>\\n<li>2 emplacements (c\\u0153ur + dos)<\\/li>\\n<li>1 couleur (orange)<\\/li>\\n<li>25 exemplaires<\\/li>\\n<li>Rabais sp\\u00e9cial de 25% (augmentation des prix 2026)<\\/li>\\n<\\/ul> <i>Les visuels doivent respecter des r\\u00e8gles pr\\u00e9cises. Toute adaptation, mise en conformit\\u00e9 ou cr\\u00e9ation sera factur\\u00e9e au tarif horaire. Les prix varient selon la quantit\\u00e9 d\'impression, la taille et la complexit\\u00e9 des visuels.<\\/i>\",\"unit_price\":\"28.000000\",\"discount_in_percent\":\"25.0000\",\"position_total\":\"525.000000\",\"pos\":\"9\",\"internal_pos\":10,\"parent_id\":null,\"is_optional\":false,\"article_id\":10},{\"id\":13085,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Frais annexes (estimation)<\\/strong><p>Nous d\\u00e9finissons un montant estimatif couvrant les frais annexes, suppl\\u00e9ments ou marges, afin d\\u2019\\u00e9viter toute surprise (pour vous et pour nous). Ce montant peut \\u00e9voluer en fonction de l\\u2019avancement et des ajustements du mandat. Ces frais incluent notamment:<\\/p>\\n<ul>\\n<li>La gestion de projet (en compl\\u00e9ment de celle \\u00e9ventuellement incluse dans les autres prestations)<\\/li>\\n<li>Les \\u00e9changes, s\\u00e9ances, pr\\u00e9sentations, etc. \\u2014 marge pr\\u00e9visionnelle en plus des workshops de base<\\/li>\\n<li>Les frais administratifs, techniques et de manutention<\\/li>\\n<li>Les \\u00e9ventuels frais de livraison et de d\\u00e9placement<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"220.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"220.000000\",\"pos\":\"10\",\"internal_pos\":11,\"parent_id\":null,\"is_optional\":false,\"article_id\":11}],\"network_link\":\"https:\\/\\/network.bexio.com\\/invoice\\/d99a479d8ded5b0970d61acff2c6b5987954bed43f0351f498ad557edceaad1c\"}', updated_at = '2026-07-07 13:01:33' WHERE id = 2959;

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.number AS number_3,
  t0.title AS title_4,
  t0.status AS status_5,
  t0.recurring AS recurring_6,
  t0.currency AS currency_7,
  t0.total_net AS total_net_8,
  t0.total_taxes AS total_taxes_9,
  t0.total_gross AS total_gross_10,
  t0.order_date AS order_date_11,
  t0.valid_until AS valid_until_12,
  t0.last_synced_at AS last_synced_at_13,
  t0.sync_status AS sync_status_14,
  t0.repetition_payload AS repetition_payload_15,
  t0.raw_payload AS raw_payload_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.next_due_date AS next_due_date_19,
  t0.company_id AS company_id_20,
  t0.client_id AS client_id_21
FROM
  `order` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.number AS number_3, t0.title AS title_4, t0.status AS status_5, t0.recurring AS recurring_6, t0.currency AS currency_7, t0.total_net AS total_net_8, t0.total_taxes AS total_taxes_9, t0.total_gross AS total_gross_10, t0.order_date AS order_date_11, t0.valid_until AS valid_until_12, t0.last_synced_at AS last_synced_at_13, t0.sync_status AS sync_status_14, t0.repetition_payload AS repetition_payload_15, t0.raw_payload AS raw_payload_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.next_due_date AS next_due_date_19, t0.company_id AS company_id_20, t0.client_id AS client_id_21 FROM `order` t0 WHERE t0.id = 235;

SELECT
  o0_.id AS id_0,
  o0_.external_id AS external_id_1,
  o0_.number AS number_2,
  o0_.title AS title_3,
  o0_.status AS status_4,
  o0_.recurring AS recurring_5,
  o0_.currency AS currency_6,
  o0_.total_net AS total_net_7,
  o0_.total_taxes AS total_taxes_8,
  o0_.total_gross AS total_gross_9,
  o0_.order_date AS order_date_10,
  o0_.valid_until AS valid_until_11,
  o0_.last_synced_at AS last_synced_at_12,
  o0_.sync_status AS sync_status_13,
  o0_.repetition_payload AS repetition_payload_14,
  o0_.raw_payload AS raw_payload_15,
  o0_.created_at AS created_at_16,
  o0_.updated_at AS updated_at_17,
  o0_.next_due_date AS next_due_date_18,
  o0_.company_id AS company_id_19,
  o0_.client_id AS client_id_20
FROM
  `order` o0_
WHERE
  o0_.company_id = ?
  AND o0_.external_id = ?
LIMIT
  1

SELECT o0_.id AS id_0, o0_.external_id AS external_id_1, o0_.number AS number_2, o0_.title AS title_3, o0_.status AS status_4, o0_.recurring AS recurring_5, o0_.currency AS currency_6, o0_.total_net AS total_net_7, o0_.total_taxes AS total_taxes_8, o0_.total_gross AS total_gross_9, o0_.order_date AS order_date_10, o0_.valid_until AS valid_until_11, o0_.last_synced_at AS last_synced_at_12, o0_.sync_status AS sync_status_13, o0_.repetition_payload AS repetition_payload_14, o0_.raw_payload AS raw_payload_15, o0_.created_at AS created_at_16, o0_.updated_at AS updated_at_17, o0_.next_due_date AS next_due_date_18, o0_.company_id AS company_id_19, o0_.client_id AS client_id_20 FROM `order` o0_ WHERE o0_.company_id = 1 AND o0_.external_id = '2483' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.provider AS provider_2,
  t0.label AS label_3,
  t0.enabled AS enabled_4,
  t0.mode AS mode_5,
  t0.access_token AS access_token_6,
  t0.refresh_token AS refresh_token_7,
  t0.expires_at AS expires_at_8,
  t0.last_sync_at AS last_sync_at_9,
  t0.last_error AS last_error_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.company_id AS company_id_13
FROM
  integration_connection t0
WHERE
  t0.company_id = ?
  AND t0.provider = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.provider AS provider_2, t0.label AS label_3, t0.enabled AS enabled_4, t0.mode AS mode_5, t0.access_token AS access_token_6, t0.refresh_token AS refresh_token_7, t0.expires_at AS expires_at_8, t0.last_sync_at AS last_sync_at_9, t0.last_error AS last_error_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.company_id AS company_id_13 FROM integration_connection t0 WHERE t0.company_id = 1 AND t0.provider = 'bexio' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.display_name AS display_name_3,
  t0.company_name AS company_name_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.email AS email_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.website AS website_10,
  t0.street AS street_11,
  t0.house_number AS house_number_12,
  t0.address_addition AS address_addition_13,
  t0.zip_code AS zip_code_14,
  t0.city AS city_15,
  t0.country_code AS country_code_16,
  t0.vat_number AS vat_number_17,
  t0.status AS status_18,
  t0.source AS source_19,
  t0.notes AS notes_20,
  t0.active AS active_21,
  t0.last_synced_at AS last_synced_at_22,
  t0.sync_status AS sync_status_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.company_id AS company_id_26
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.display_name AS display_name_3, t0.company_name AS company_name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.street AS street_11, t0.house_number AS house_number_12, t0.address_addition AS address_addition_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.country_code AS country_code_16, t0.vat_number AS vat_number_17, t0.status AS status_18, t0.source AS source_19, t0.notes AS notes_20, t0.active AS active_21, t0.last_synced_at AS last_synced_at_22, t0.sync_status AS sync_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.company_id AS company_id_26 FROM client t0 WHERE t0.id = 710;

UPDATE
  external_reference
SET
  last_pulled_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE external_reference SET last_pulled_at = '2026-07-07 13:01:35', updated_at = '2026-07-07 13:01:36' WHERE id = 3089;

DELETE FROM
  invoice_line
WHERE
  id = ?

DELETE FROM invoice_line WHERE id = 6410;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.title AS title_3,
  t0.status AS status_4,
  t0.currency AS currency_5,
  t0.total_net AS total_net_6,
  t0.total_taxes AS total_taxes_7,
  t0.total_gross AS total_gross_8,
  t0.invoice_date AS invoice_date_9,
  t0.due_date AS due_date_10,
  t0.paid_at AS paid_at_11,
  t0.external_id AS external_id_12,
  t0.last_synced_at AS last_synced_at_13,
  t0.sync_status AS sync_status_14,
  t0.raw_payload AS raw_payload_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.billing_period_start AS billing_period_start_18,
  t0.billing_period_end AS billing_period_end_19,
  t0.company_id AS company_id_20,
  t0.client_id AS client_id_21,
  t0.friq_contract_id AS friq_contract_id_22
FROM
  invoice t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.title AS title_3, t0.status AS status_4, t0.currency AS currency_5, t0.total_net AS total_net_6, t0.total_taxes AS total_taxes_7, t0.total_gross AS total_gross_8, t0.invoice_date AS invoice_date_9, t0.due_date AS due_date_10, t0.paid_at AS paid_at_11, t0.external_id AS external_id_12, t0.last_synced_at AS last_synced_at_13, t0.sync_status AS sync_status_14, t0.raw_payload AS raw_payload_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.billing_period_start AS billing_period_start_18, t0.billing_period_end AS billing_period_end_19, t0.company_id AS company_id_20, t0.client_id AS client_id_21, t0.friq_contract_id AS friq_contract_id_22 FROM invoice t0 WHERE t0.id = 1715;

UPDATE
  `order`
SET
  order_date = ?,
  last_synced_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE `order` SET order_date = '2026-03-13 00:00:00', last_synced_at = '2026-07-07 13:01:35', updated_at = '2026-07-07 13:01:35' WHERE id = 235;

UPDATE
  invoice
SET
  invoice_date = ?,
  due_date = ?,
  last_synced_at = ?,
  raw_payload = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE invoice SET invoice_date = '2026-05-08 00:00:00', due_date = '2026-06-06 00:00:00', last_synced_at = '2026-07-07 13:01:15', raw_payload = '{\"id\":3177,\"document_nr\":\"POM-FAC2026-03177\",\"title\":\"GF-Divers2026-POM4578\",\"contact_id\":917,\"contact_sub_id\":null,\"user_id\":8,\"project_id\":null,\"logopaper_id\":1,\"language_id\":2,\"bank_account_id\":1,\"currency_id\":1,\"payment_type_id\":4,\"header\":\"Nous vous remercions pour la confiance t&eacute;moign&eacute;e.\",\"footer\":\"&Agrave; disposition pour tout compl&eacute;ment d\'information.<br \\/><br \\/>Merci d&rsquo;effectuer le paiement complet via cette facture uniquement. Nos factures sont payables sous 30 jours. Pass&eacute; ce d&eacute;lai, un rappel automatique sera envoy&eacute; par e-mail. Toutes les factures et rappels sont transmis par e-mail. Si l&rsquo;adresse de destinataire ne devait pas correspondre, nous vous prions d&egrave;s lors de nous transmettre les coordonn&eacute;es exactes. Nos tarifs peuvent &eacute;voluer selon les co&ucirc;ts de nos prestataires.<br \\/><br \\/>Nos conditions g&eacute;n&eacute;rales sont accessibles &agrave; l\'adresse: www.pom-xtd.ch\\/cg\",\"total_gross\":\"3617.000000\",\"total_net\":\"3617.000000\",\"total_taxes\":\"292.9770\",\"total_received_payments\":\"0.000000\",\"total_credit_vouchers\":\"0.000000\",\"total_remaining_payments\":\"3910.0000\",\"total\":\"3910.000000\",\"total_rounding_difference\":0.02,\"mwst_type\":0,\"mwst_is_net\":true,\"show_position_taxes\":true,\"is_valid_from\":\"2026-05-08\",\"is_valid_to\":\"2026-06-06\",\"contact_address\":\"GF R\\u00e9alisations\\nM. Florent Greder\\nCH - 2746 Cr\\u00e9mines\",\"kb_item_status_id\":8,\"reference\":null,\"api_reference\":null,\"viewed_by_client_at\":null,\"updated_at\":\"2026-07-07 12:01:33\",\"esr_id\":2985,\"qr_invoice_id\":2985,\"template_slug\":\"5fbe6df9b774d50dce04b108\",\"taxs\":[{\"percentage\":\"8.10\",\"value\":\"292.9770\"}],\"positions\":[{\"id\":3606,\"type\":\"KbPositionText\",\"text\":\"<strong><\\/strong><strong>Selon discussions avec S. Geiser<\\/strong>\\r\\n<ul>\\r\\n<li>Production de 3 nouveaux drapeaux<\\/li>\\r\\n<li>Nouvelles cartes de visite avec QR code et pictos Sociel Media<\\/li>\\r\\n<li>Stickers en d&eacute;coupe pour v&eacute;hicules en noir et\\/ou orange 80x30 cm, 10 x10 cm<\\/li>\\r\\n<li>Stickers imprim&eacute;s pour outils selon mod&egrave;le existant<\\/li>\\r\\n<li>B&acirc;ches micro-perfor&eacute;es (mesh) grandes et petites selon mod&egrave;les existants<\\/li>\\r\\n<li>T-shirts Engelbert Strauss fournis par le client avec flocage FLEX (comme premi&egrave;re s&eacute;rie)<\\/li>\\r\\n<\\/ul>\",\"show_pos_nr\":false,\"pos\":null,\"internal_pos\":1,\"parent_id\":null,\"is_optional\":false},{\"id\":13076,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Graphisme et mise en page<\\/strong><ul>\\n<li>Adaptation graphique et modification des supports suivants:\\n<ul>\\n<li>Drapeaux (nouveau mod\\u00e8le)<\\/li>\\n<li>Cartes de visite<\\/li>\\n<li>Stickers pour v\\u00e9hicules (2 formats)<\\/li>\\n<\\/ul>\\n<\\/li>\\n<li>Corrections\\/modification jusqu\'au BAT02*<\\/li>\\n<li>Finalisation pour production<\\/li>\\n<\\/ul> <i>*Toute modification survenant apr\\u00e8s le 2e BAT est factur\\u00e9e au tarif horaire de CHF 150.\\u2013<\\/i>\",\"unit_price\":\"300.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"300.000000\",\"pos\":\"1\",\"internal_pos\":2,\"parent_id\":null,\"is_optional\":false,\"article_id\":2},{\"id\":13077,\"type\":\"KbPositionArticle\",\"amount\":\"3.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Drapeaux (Production)<\\/strong><ul class=\\\"ql-rendered-list-container\\\" data-is-root=\\\"true\\\" data-test=\\\"rendered-list-container\\\">\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-thB-UKdZ92\\\" data-test=\\\"rendered-list-item-bullet\\\">Hauteur totale: 346cm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-ZVaXCIa7WS\\\" data-test=\\\"rendered-list-item-bullet\\\">Format de la voile: 80x280cm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-UJ_mKiNnZd\\\" data-test=\\\"rendered-list-item-bullet\\\">Tissu ECO, 160g\\/m2<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-vrYlcvRlhn\\\" data-test=\\\"rendered-list-item-bullet\\\">M\\u00e2t \\u00f840mm<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-Lv21gK8fVd\\\" data-test=\\\"rendered-list-item-bullet\\\">Support \\u00e0 visser pour terre ou neige<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-atwpc-6SOo\\\" data-test=\\\"rendered-list-item-bullet\\\">Garantie: 1 an<\\/li>\\n<li class=\\\"ql-rendered-bullet-list\\\" data-block-id=\\\"block-7RsqXVGWjc\\\" data-test=\\\"rendered-list-item-bullet\\\">Il est conseill\\u00e9 de rentrer les drapeaux lors de vents \\u00e0 partir de 60km\\/h<\\/li>\\n<\\/ul> <i>D\\u00e9lai de production: environ 2-3 semaines d\\u00e8s validation du BAT final.<\\/i>\",\"unit_price\":\"425.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"1275.000000\",\"pos\":\"2\",\"internal_pos\":3,\"parent_id\":null,\"is_optional\":false,\"article_id\":3},{\"id\":13078,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Carte de visite (impression) \\u2013 350g \\u2013 OFFSET<\\/strong><ul>\\n<li>REF-<span class=\\\"ref-prod\\\">P24-24-75-35<\\/span><\\/li>\\n<li>85\\u00d755 mm<\\/li>\\n<li>Papier 350g\\/m2 Offset<\\/li>\\n<li>Impression 4\\/4 CMJN \\u2013 recto-verso<\\/li>\\n<li>200 exemplaires<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"145.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"145.000000\",\"pos\":\"3\",\"internal_pos\":4,\"parent_id\":null,\"is_optional\":false,\"article_id\":4},{\"id\":13079,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant v\\u00e9hicules grand - 80x30 cm<\\/strong><ul>\\n<li>Mati\\u00e8re teint\\u00e9 dans la masse<\\/li>\\n<li>D\\u00e9coup\\u00e9 et mis sous tape d\'application<\\/li>\\n<li>5x orange et 8x noir<\\/li>\\n<li>Finitions brillante (existe aussi en mat sur demande)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"375.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"375.000000\",\"pos\":\"4\",\"internal_pos\":5,\"parent_id\":null,\"is_optional\":false,\"article_id\":5},{\"id\":13080,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant v\\u00e9hicules petit - 10x10 cm<\\/strong><ul>\\n<li>Mati\\u00e8re teint\\u00e9 dans la masse<\\/li>\\n<li>D\\u00e9coup\\u00e9 et mis sous tape d\'application<\\/li>\\n<li>30x orange<\\/li>\\n<li>Finitions brillante (existe aussi en mat sur demande)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"135.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"135.000000\",\"pos\":\"5\",\"internal_pos\":6,\"parent_id\":null,\"is_optional\":false,\"article_id\":6},{\"id\":13081,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Autocollant pour outillage de chantier<\\/strong><ul>\\n<li>Laminage de protection brillant<\\/li>\\n<li>Impression en quadrichromie&nbsp;<\\/li>\\n<li>Longue dur\\u00e9e<\\/li>\\n<li>Ext\\u00e9rieur et int\\u00e9rieur&nbsp;<\\/li>\\n<li>D\\u00e9coupe au trac\\u00e9&nbsp;<\\/li>\\n<li>Dimension 100x45mm<\\/li>\\n<li>Quantit\\u00e9 60x (20x par couleurs)<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"92.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"92.000000\",\"pos\":\"6\",\"internal_pos\":7,\"parent_id\":null,\"is_optional\":false,\"article_id\":7},{\"id\":13082,\"type\":\"KbPositionArticle\",\"amount\":\"2.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>B\\u00e2che micro-perfor\\u00e9 (mesh) - Grande - 2x1<\\/strong><ul>\\n<li>B\\u00e2che mesh 300 g\\/m2<\\/li>\\n<li>Format 2000 x 1000 mm<\\/li>\\n<li>Impression quadrichromie<\\/li>\\n<li>Recto<\\/li>\\n<li>Avec ourlets (bords renforc\\u00e9s)<\\/li>\\n<li>Avec \\u0153illets de 12 mm tout autour, tous les 50 cm<\\/li>\\n<li>1x orange et 1x noire<\\/li>\\n<\\/ul> <i>Le format peut \\u00eatre vertical ou horizontal. Les frais de livraison, ainsi que les \\u00e9ventuels frais de mise en page, ne sont pas inclus dans ce tarif. Les d\\u00e9lais de production sont d\\u2019au minimum 7 jours ouvrables. La qualit\\u00e9 des b\\u00e2ches peut se d\\u00e9t\\u00e9riorer selon les conditions d\\u2019utilisation (int\\u00e9rieur ou ext\\u00e9rieur) et n\\u2019est garantie que pour une dur\\u00e9e d\\u2019un an.<\\/i>\",\"unit_price\":\"170.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"340.000000\",\"pos\":\"7\",\"internal_pos\":8,\"parent_id\":null,\"is_optional\":false,\"article_id\":8},{\"id\":13083,\"type\":\"KbPositionArticle\",\"amount\":\"2.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>B\\u00e2che micro-perfor\\u00e9 (mesh) - Petite - 1000x500<\\/strong><ul>\\n<li>B\\u00e2che mesh 300 g\\/m2<\\/li>\\n<li>Format 1000 x 500 mm<\\/li>\\n<li>Impression quadrichromie<\\/li>\\n<li>Recto<\\/li>\\n<li>Avec ourlets (bords renforc\\u00e9s)<\\/li>\\n<li>Avec \\u0153illets de 12 mm tout autour, tous les 50 cm<\\/li>\\n<li>1x orange et 1x noire<\\/li>\\n<\\/ul> <i>Le format peut \\u00eatre vertical ou horizontal. Les frais de livraison, ainsi que les \\u00e9ventuels frais de mise en page, ne sont pas inclus dans ce tarif. Les d\\u00e9lais de production sont d\\u2019au minimum 7 jours ouvrables. La qualit\\u00e9 des b\\u00e2ches peut se d\\u00e9t\\u00e9riorer selon les conditions d\\u2019utilisation (int\\u00e9rieur ou ext\\u00e9rieur) et n\\u2019est garantie que pour une dur\\u00e9e d\\u2019un an.<\\/i>\",\"unit_price\":\"105.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"210.000000\",\"pos\":\"8\",\"internal_pos\":9,\"parent_id\":null,\"is_optional\":false,\"article_id\":9},{\"id\":13084,\"type\":\"KbPositionArticle\",\"amount\":\"25.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Impression sur textile - FLEX<\\/strong><ul>\\n<li>Textiles fournis par le client (majoration du prix)<\\/li>\\n<li>Technique flex identique \\u00e0 premi\\u00e8re s\\u00e9rie<\\/li>\\n<li>2 emplacements (c\\u0153ur + dos)<\\/li>\\n<li>1 couleur (orange)<\\/li>\\n<li>25 exemplaires<\\/li>\\n<li>Rabais sp\\u00e9cial de 25% (augmentation des prix 2026)<\\/li>\\n<\\/ul> <i>Les visuels doivent respecter des r\\u00e8gles pr\\u00e9cises. Toute adaptation, mise en conformit\\u00e9 ou cr\\u00e9ation sera factur\\u00e9e au tarif horaire. Les prix varient selon la quantit\\u00e9 d\'impression, la taille et la complexit\\u00e9 des visuels.<\\/i>\",\"unit_price\":\"28.000000\",\"discount_in_percent\":\"25.0000\",\"position_total\":\"525.000000\",\"pos\":\"9\",\"internal_pos\":10,\"parent_id\":null,\"is_optional\":false,\"article_id\":10},{\"id\":13085,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Frais annexes (estimation)<\\/strong><p>Nous d\\u00e9finissons un montant estimatif couvrant les frais annexes, suppl\\u00e9ments ou marges, afin d\\u2019\\u00e9viter toute surprise (pour vous et pour nous). Ce montant peut \\u00e9voluer en fonction de l\\u2019avancement et des ajustements du mandat. Ces frais incluent notamment:<\\/p>\\n<ul>\\n<li>La gestion de projet (en compl\\u00e9ment de celle \\u00e9ventuellement incluse dans les autres prestations)<\\/li>\\n<li>Les \\u00e9changes, s\\u00e9ances, pr\\u00e9sentations, etc. \\u2014 marge pr\\u00e9visionnelle en plus des workshops de base<\\/li>\\n<li>Les frais administratifs, techniques et de manutention<\\/li>\\n<li>Les \\u00e9ventuels frais de livraison et de d\\u00e9placement<\\/li>\\n<\\/ul> <i><\\/i>\",\"unit_price\":\"220.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"220.000000\",\"pos\":\"10\",\"internal_pos\":11,\"parent_id\":null,\"is_optional\":false,\"article_id\":11}],\"network_link\":\"https:\\/\\/network.bexio.com\\/invoice\\/d99a479d8ded5b0970d61acff2c6b5987954bed43f0351f498ad557edceaad1c\"}', updated_at = '2026-07-07 13:01:15' WHERE id = 1715;

INSERT INTO `order` (
  external_id, number, title, status,
  recurring, currency, total_net, total_taxes,
  total_gross, order_date, valid_until,
  last_synced_at, sync_status, repetition_payload,
  raw_payload, created_at, updated_at,
  next_due_date, company_id, client_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO `order` (external_id, number, title, status, recurring, currency, total_net, total_taxes, total_gross, order_date, valid_until, last_synced_at, sync_status, repetition_payload, raw_payload, created_at, updated_at, next_due_date, company_id, client_id) VALUES ('2483', 'POM-COMCL2026-02483', 'Pain-Paillasse-F.Jobé-Habillage-vitrine', 'pending', 0, 'CHF', '1733.00', '140.37', '1733.00', '2026-07-07 00:00:00', NULL, '2026-07-07 13:01:38', 'synced', NULL, '{\"id\":2483,\"document_nr\":\"POM-COMCL2026-02483\",\"title\":\"Pain-Paillasse-F.Job\\u00e9-Habillage-vitrine\",\"contact_id\":1342,\"contact_sub_id\":null,\"user_id\":1,\"project_id\":null,\"logopaper_id\":1,\"language_id\":2,\"bank_account_id\":1,\"currency_id\":1,\"payment_type_id\":4,\"header\":\"Merci pour votre commande\",\"footer\":\"Cordialement, l\'\\u00e9quipe\",\"total_gross\":\"1733.000000\",\"total_net\":\"1733.000000\",\"total_taxes\":\"140.3730\",\"total\":\"1873.350000\",\"total_rounding_difference\":-0.02,\"mwst_type\":0,\"mwst_is_net\":true,\"show_position_taxes\":true,\"is_valid_from\":\"2026-07-07\",\"contact_address\":\"Paillasse Marketing SA\\nChemin des L\\u00e9ch\\u00e8res 4\\nCH - 1217 Meyrin\",\"delivery_address_type\":0,\"delivery_address\":\"Paillasse Marketing SA\\nChemin des L\\u00e9ch\\u00e8res 4\\nCH - 1217 Meyrin\",\"kb_item_status_id\":5,\"is_recurring\":false,\"api_reference\":\"\",\"viewed_by_client_at\":null,\"updated_at\":\"2026-07-07 12:22:57\",\"template_slug\":\"5fa0320bc3fe352cc91b5947\",\"taxs\":[{\"percentage\":\"8.10\",\"value\":\"140.3730\"}],\"positions\":[{\"id\":3698,\"type\":\"KbPositionText\",\"text\":\"<strong>Description<\\/strong>Habillage de deux vitrines pour la boulangerie F.Job&eacute; &agrave; Courfaivre, client de Pain Paillasse (Paillasse.ch) + 2 plexis &agrave; changer pour l\'enseigne.\",\"show_pos_nr\":false,\"pos\":null,\"internal_pos\":1,\"parent_id\":null,\"is_optional\":false},{\"id\":13329,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Mati\\u00e8re autocollante - impression<\\/strong><ul>\\n<li>Selon mesures estimatives (fichier client)<\\/li>\\n<li>Mise en conformit\\u00e9 fichier<\\/li>\\n<li>Impression num\\u00e9rique<\\/li>\\n<li>Laminage de protextion et anti-UV<\\/li>\\n<li>Finalisation<\\/li>\\n<\\/ul>\\n<p>Le prix est estimatif et peut \\u00e9voluer en fonction de la complexit\\u00e9 des visuels. Apr\\u00e8s validation du pr\\u00e9sent devis et apr\\u00e8s r\\u00e9ception des fichiers, nous pourrons ajuster avec plus de pr\\u00e9cision au besoin.<\\/p> <i>Les visuels sont r\\u00e9alis\\u00e9s par le client. Ce dernier s\'engage \\u00e0 fournir des fichiers vectoriels \\u00e0 la qualit\\u00e9 requise et exploitables par nos soins. Toute modification client apr\\u00e8s le 2e bon \\u00e0 tirer est factur\\u00e9e au tarif horaire en vigueur.<\\/i>\",\"unit_price\":\"513.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"513.000000\",\"pos\":\"1\",\"internal_pos\":2,\"parent_id\":null,\"is_optional\":false,\"article_id\":2},{\"id\":13330,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Mati\\u00e8re autocollante - teint\\u00e9 dans la masse<\\/strong><ul>\\n<li>Selon mesures estimatives (fichier client)<\\/li>\\n<li>Mise en conformit\\u00e9 fichier<\\/li>\\n<li>D\\u00e9coupe \\u00e0 la forme des lettrages<\\/li>\\n<li>Pose d\'un tape d\'application<\\/li>\\n<li>Finalisation<\\/li>\\n<\\/ul>\\n<p>Le prix est estimatif et peut \\u00e9voluer en fonction de la complexit\\u00e9 des visuels. Apr\\u00e8s validation du pr\\u00e9sent devis et apr\\u00e8s r\\u00e9ception des fichiers, nous pourrons ajuster avec plus de pr\\u00e9cision au besoin.<\\/p> <i>Les visuels sont r\\u00e9alis\\u00e9s par le client. Ce dernier s\'engage \\u00e0 fournir des fichiers vectoriels \\u00e0 la qualit\\u00e9 requise et exploitables par nos soins. Toute modification client apr\\u00e8s le 2e bon \\u00e0 tirer est factur\\u00e9e au tarif horaire en vigueur.<\\/i>\",\"unit_price\":\"450.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"450.000000\",\"pos\":\"2\",\"internal_pos\":3,\"parent_id\":null,\"is_optional\":false,\"article_id\":3},{\"id\":13331,\"type\":\"KbPositionArticle\",\"amount\":\"6.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Pose sur site - Boulangerie F.Job\\u00e9 \\u00e0 Courfaivre<\\/strong><ul>\\n<li>D\\u00e9graissage et pose sur site (2853, Courfaivre)<\\/li>\\n<li>Marquages sur les vitres (bord de route)<\\/li>\\n<li>Mati\\u00e8re teint\\u00e9 dans la masse et impression num\\u00e9rique (selon maquette)<\\/li>\\n<\\/ul> <i>Afin de garantir un travail optimal, nous demandons que les vitres soient nettoy\\u00e9s avant toute intervention. Nous attirons \\u00e9galement votre attention sur le fait que la pr\\u00e9sence de dommages existants sur les fen\\u00eatres peut alt\\u00e9rer la tenue des autocollants ou autres \\u00e9l\\u00e9ments appliqu\\u00e9s. De ce fait, nous d\\u00e9clinons toute responsabilit\\u00e9 concernant ces \\u00e9ventuels probl\\u00e8mes. Cependant, nous restons \\u00e0 votre disposition pour trouver ensemble des solutions adapt\\u00e9es en cas de difficult\\u00e9.<\\/i>\",\"unit_price\":\"110.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"660.000000\",\"pos\":\"3\",\"internal_pos\":4,\"parent_id\":null,\"is_optional\":false,\"article_id\":4},{\"id\":13332,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Frais annexes (estimation)<\\/strong><p>Nous d\\u00e9finissons un montant estimatif pour les frais annexes, qui peut varier en fonction de l\\u2019\\u00e9volution du mandat. Ces frais comprennent la gestion de projet, les diff\\u00e9rents \\u00e9changes, les frais administratifs, les frais techniques, ainsi que les co\\u00fbts de manutention, de livraison et de d\\u00e9placement.<\\/p> <i><\\/i>\",\"unit_price\":\"110.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"110.000000\",\"pos\":\"4\",\"internal_pos\":5,\"parent_id\":null,\"is_optional\":false,\"article_id\":5},{\"id\":18333,\"type\":\"KbPositionCustom\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":null,\"account_id\":101,\"unit_name\":null,\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"Suppl&eacute;ment enseigne<br \\/>Plexi &agrave; changer<br \\/>Prix &agrave; ajouter sur cette commande\",\"unit_price\":\"0.000000\",\"discount_in_percent\":null,\"position_total\":\"0.000000\",\"pos\":\"5\",\"internal_pos\":6,\"parent_id\":null,\"is_optional\":false}],\"network_link\":\"\"}', '2026-07-07 13:01:38', '2026-07-07 13:01:38', NULL, 1, NULL);

INSERT INTO external_reference (
  provider, entity_type, entity_id,
  external_id, external_hash, sync_status,
  last_pulled_at, last_pushed_at,
  last_error, raw_payload, created_at,
  updated_at, company_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO external_reference (provider, entity_type, entity_id, external_id, external_hash, sync_status, last_pulled_at, last_pushed_at, last_error, raw_payload, created_at, updated_at, company_id) VALUES ('bexio', 'order', 354, '2483', '2746c68778a5da80a23662b97eb58009babbfcbf', 'imported', '2026-07-07 13:01:38', NULL, NULL, '{\"id\":2483,\"document_nr\":\"POM-COMCL2026-02483\",\"title\":\"Pain-Paillasse-F.Job\\u00e9-Habillage-vitrine\",\"contact_id\":1342,\"contact_sub_id\":null,\"user_id\":1,\"project_id\":null,\"logopaper_id\":1,\"language_id\":2,\"bank_account_id\":1,\"currency_id\":1,\"payment_type_id\":4,\"header\":\"Merci pour votre commande\",\"footer\":\"Cordialement, l\'\\u00e9quipe\",\"total_gross\":\"1733.000000\",\"total_net\":\"1733.000000\",\"total_taxes\":\"140.3730\",\"total\":\"1873.350000\",\"total_rounding_difference\":-0.02,\"mwst_type\":0,\"mwst_is_net\":true,\"show_position_taxes\":true,\"is_valid_from\":\"2026-07-07\",\"contact_address\":\"Paillasse Marketing SA\\nChemin des L\\u00e9ch\\u00e8res 4\\nCH - 1217 Meyrin\",\"delivery_address_type\":0,\"delivery_address\":\"Paillasse Marketing SA\\nChemin des L\\u00e9ch\\u00e8res 4\\nCH - 1217 Meyrin\",\"kb_item_status_id\":5,\"is_recurring\":false,\"api_reference\":\"\",\"viewed_by_client_at\":null,\"updated_at\":\"2026-07-07 12:22:57\",\"template_slug\":\"5fa0320bc3fe352cc91b5947\",\"taxs\":[{\"percentage\":\"8.10\",\"value\":\"140.3730\"}],\"positions\":[{\"id\":3698,\"type\":\"KbPositionText\",\"text\":\"<strong>Description<\\/strong>Habillage de deux vitrines pour la boulangerie F.Job&eacute; &agrave; Courfaivre, client de Pain Paillasse (Paillasse.ch) + 2 plexis &agrave; changer pour l\'enseigne.\",\"show_pos_nr\":false,\"pos\":null,\"internal_pos\":1,\"parent_id\":null,\"is_optional\":false},{\"id\":13329,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Mati\\u00e8re autocollante - impression<\\/strong><ul>\\n<li>Selon mesures estimatives (fichier client)<\\/li>\\n<li>Mise en conformit\\u00e9 fichier<\\/li>\\n<li>Impression num\\u00e9rique<\\/li>\\n<li>Laminage de protextion et anti-UV<\\/li>\\n<li>Finalisation<\\/li>\\n<\\/ul>\\n<p>Le prix est estimatif et peut \\u00e9voluer en fonction de la complexit\\u00e9 des visuels. Apr\\u00e8s validation du pr\\u00e9sent devis et apr\\u00e8s r\\u00e9ception des fichiers, nous pourrons ajuster avec plus de pr\\u00e9cision au besoin.<\\/p> <i>Les visuels sont r\\u00e9alis\\u00e9s par le client. Ce dernier s\'engage \\u00e0 fournir des fichiers vectoriels \\u00e0 la qualit\\u00e9 requise et exploitables par nos soins. Toute modification client apr\\u00e8s le 2e bon \\u00e0 tirer est factur\\u00e9e au tarif horaire en vigueur.<\\/i>\",\"unit_price\":\"513.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"513.000000\",\"pos\":\"1\",\"internal_pos\":2,\"parent_id\":null,\"is_optional\":false,\"article_id\":2},{\"id\":13330,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Mati\\u00e8re autocollante - teint\\u00e9 dans la masse<\\/strong><ul>\\n<li>Selon mesures estimatives (fichier client)<\\/li>\\n<li>Mise en conformit\\u00e9 fichier<\\/li>\\n<li>D\\u00e9coupe \\u00e0 la forme des lettrages<\\/li>\\n<li>Pose d\'un tape d\'application<\\/li>\\n<li>Finalisation<\\/li>\\n<\\/ul>\\n<p>Le prix est estimatif et peut \\u00e9voluer en fonction de la complexit\\u00e9 des visuels. Apr\\u00e8s validation du pr\\u00e9sent devis et apr\\u00e8s r\\u00e9ception des fichiers, nous pourrons ajuster avec plus de pr\\u00e9cision au besoin.<\\/p> <i>Les visuels sont r\\u00e9alis\\u00e9s par le client. Ce dernier s\'engage \\u00e0 fournir des fichiers vectoriels \\u00e0 la qualit\\u00e9 requise et exploitables par nos soins. Toute modification client apr\\u00e8s le 2e bon \\u00e0 tirer est factur\\u00e9e au tarif horaire en vigueur.<\\/i>\",\"unit_price\":\"450.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"450.000000\",\"pos\":\"2\",\"internal_pos\":3,\"parent_id\":null,\"is_optional\":false,\"article_id\":3},{\"id\":13331,\"type\":\"KbPositionArticle\",\"amount\":\"6.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Pose sur site - Boulangerie F.Job\\u00e9 \\u00e0 Courfaivre<\\/strong><ul>\\n<li>D\\u00e9graissage et pose sur site (2853, Courfaivre)<\\/li>\\n<li>Marquages sur les vitres (bord de route)<\\/li>\\n<li>Mati\\u00e8re teint\\u00e9 dans la masse et impression num\\u00e9rique (selon maquette)<\\/li>\\n<\\/ul> <i>Afin de garantir un travail optimal, nous demandons que les vitres soient nettoy\\u00e9s avant toute intervention. Nous attirons \\u00e9galement votre attention sur le fait que la pr\\u00e9sence de dommages existants sur les fen\\u00eatres peut alt\\u00e9rer la tenue des autocollants ou autres \\u00e9l\\u00e9ments appliqu\\u00e9s. De ce fait, nous d\\u00e9clinons toute responsabilit\\u00e9 concernant ces \\u00e9ventuels probl\\u00e8mes. Cependant, nous restons \\u00e0 votre disposition pour trouver ensemble des solutions adapt\\u00e9es en cas de difficult\\u00e9.<\\/i>\",\"unit_price\":\"110.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"660.000000\",\"pos\":\"3\",\"internal_pos\":4,\"parent_id\":null,\"is_optional\":false,\"article_id\":4},{\"id\":13332,\"type\":\"KbPositionArticle\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":1,\"account_id\":101,\"unit_name\":\"Stk\",\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"<strong>Frais annexes (estimation)<\\/strong><p>Nous d\\u00e9finissons un montant estimatif pour les frais annexes, qui peut varier en fonction de l\\u2019\\u00e9volution du mandat. Ces frais comprennent la gestion de projet, les diff\\u00e9rents \\u00e9changes, les frais administratifs, les frais techniques, ainsi que les co\\u00fbts de manutention, de livraison et de d\\u00e9placement.<\\/p> <i><\\/i>\",\"unit_price\":\"110.000000\",\"discount_in_percent\":\"0.0000\",\"position_total\":\"110.000000\",\"pos\":\"4\",\"internal_pos\":5,\"parent_id\":null,\"is_optional\":false,\"article_id\":5},{\"id\":18333,\"type\":\"KbPositionCustom\",\"amount\":\"1.000000\",\"amount_reserved\":\"0.000000\",\"amount_open\":\"0.000000\",\"amount_completed\":\"0.000000\",\"unit_id\":null,\"account_id\":101,\"unit_name\":null,\"tax_id\":28,\"tax_value\":\"8.10\",\"text\":\"Suppl&eacute;ment enseigne<br \\/>Plexi &agrave; changer<br \\/>Prix &agrave; ajouter sur cette commande\",\"unit_price\":\"0.000000\",\"discount_in_percent\":null,\"position_total\":\"0.000000\",\"pos\":\"5\",\"internal_pos\":6,\"parent_id\":null,\"is_optional\":false}],\"network_link\":\"\"}', '2026-07-07 13:01:38', NULL, 1);

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.text AS text_3,
  t0.quantity AS quantity_4,
  t0.unit_price AS unit_price_5,
  t0.discount AS discount_6,
  t0.total AS total_7,
  t0.tax_rate AS tax_rate_8,
  t0.raw_payload AS raw_payload_9,
  t0.invoice_id AS invoice_id_10
FROM
  invoice_line t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.discount AS discount_6, t0.total AS total_7, t0.tax_rate AS tax_rate_8, t0.raw_payload AS raw_payload_9, t0.invoice_id AS invoice_id_10 FROM invoice_line t0 WHERE t0.invoice_id = 1715 ORDER BY t0.position ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.legal_name AS legal_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.website AS website_6,
  t0.address AS address_7,
  t0.zip_code AS zip_code_8,
  t0.city AS city_9,
  t0.country AS country_10,
  t0.vat_number AS vat_number_11,
  t0.active AS active_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14
FROM
  company t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.website AS website_6, t0.address AS address_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.country AS country_10, t0.vat_number AS vat_number_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM company t0;