Login

Code:
INSERT INTO `admin__model__order` (`id`, `user_id`, `invoiceaddress_id`, `deliveryaddress_id`, `orderstatetype_id`, `payment_id`, `shipping_id`, `product_id`, `date`, `time`, `datefinished`, `priceproductwithoutvat`, `priceproductwithvat`, `pricetotalwithoutvat`, `pricetotalwithvat`, `ordernumber`, `description`, `folder`, `priceshippingwithoutvat`, `priceshippingwithvat`, `pricepaymentwithoutvat`, `pricepaymentwithvat`, `gopayid`, `gopayurl`, `inpohoda`, `datepayed`, `balikobotstate`, `balikobotid`, `balikobotpackageid`, `balikobottrackingurl`, `balikobotlabeliurl`, `balikobotcarrierid`, `totalweight`, `dateshipmenttransit`, `dateshipped`, `reviewnotifydate`, `coupon_id`, `eshop_id`, `language_id`, `vat_id`, `withoutvat`, `dateheureka`, `sendheureka`, `externalordertype`, `externalordernumber`, `internalnote`, `b2b`, `duedays`) VALUES

Format - .SQL
Size sql file - 3GB
Date - 2023
All Rows - 2kk
Website - rouesecours24.fr

Sample:

Code:

INSERT INTO `admin__model__order` (`id`, `user_id`, `invoiceaddress_id`, `deliveryaddress_id`, `orderstatetype_id`, `payment_id`, `shipping_id`, `product_id`, `date`, `time`, `datefinished`, `priceproductwithoutvat`, `priceproductwithvat`, `pricetotalwithoutvat`, `pricetotalwithvat`, `ordernumber`, `description`, `folder`, `priceshippingwithoutvat`, `priceshippingwithvat`, `pricepaymentwithoutvat`, `pricepaymentwithvat`, `gopayid`, `gopayurl`, `inpohoda`, `datepayed`, `balikobotstate`, `balikobotid`, `balikobotpackageid`, `balikobottrackingurl`, `balikobotlabeliurl`, `balikobotcarrierid`, `totalweight`, `dateshipmenttransit`, `dateshipped`, `reviewnotifydate`, `coupon_id`, `eshop_id`, `language_id`, `vat_id`, `withoutvat`, `dateheureka`, `sendheureka`, `externalordertype`, `externalordernumber`, `internalnote`, `b2b`, `duedays`) VALUES[/align]

(43427, NULL, 84027, NULL, 4, 8, 5, NULL, '2023-04-27', '23:01:00', NULL, 164.00, 200.00, 164.00, 200.00, '23070327', '', 'sVDOTIlLyBtJ3XGY', 0.00, 0.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-27', NULL, '983145', '13097054', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845066736372', 'https://pdf.balikobot.cz/dpd/eNqzNDc2VdBVMDIwN7K0MLZcMFwwFwsC7Q..', '13845066736372', 13.00, '2023-04-28', '2023-05-05', '2023-05-08', NULL, 3, 4, 5, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43428, NULL, 84028, NULL, 4, 5, 3, NULL, '2023-04-27', '23:49:00', NULL, 168.00, 203.00, 180.00, 218.00, '23080443', '', 'jomD7F2wIQ9umFNh', 12.40, 15.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-27', NULL, '984457', '13109696', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845057177524', 'https://pdf.balikobot.cz/dpd/eNqzNDc2V9BVMDIwN7EwMTQFXDAXFgLn', '13845057177524', 16.00, '2023-05-02', '2023-05-08', '2023-05-11', NULL, 2, 3, 6, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43429, NULL, 84029, NULL, 1, 48, 29, NULL, '2023-04-28', '04:10:00', NULL, 195.00, 244.00, 274.00, 343.00, '23110181', '', 'oqiG1yhxUmUgnfQv', 79.20, 99.00, 0.00, 0.00, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3.00, NULL, NULL, NULL, NULL, 10, 10, 12, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43430, NULL, 84030, NULL, 4, 25, 13, NULL, '2023-04-28', '06:08:00', NULL, 204.00, 244.00, 213.00, 256.00, '23020371', '', 'uaW2Yh5bwAIWawKx', 7.50, 9.00, 2.50, 3.00, NULL, NULL, 1, NULL, NULL, '983168', '13097234', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13875018572098', 'https://pdf.balikobot.cz/dpd/eNozNTEzVtBVMDIwNzYwNLJcMFwwFn4C1w..', '13875018572098', 13.00, '2023-04-28', '2023-05-02', '2023-05-05', NULL, 6, 6, 8, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43431, NULL, 84033, 84032, 4, 27, 9, NULL, '2023-04-28', '06:57:00', NULL, 3136.00, 3795.00, 3267.00, 3954.00, '23012756', '', 'n5AQeVKuXoEYIPWO', 90.08, 109.00, 41.32, 50.00, NULL, NULL, 1, NULL, NULL, '983173', '13097264', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13875018485795', 'https://pdf.balikobot.cz/dpd/eNozNTEzVNBVMDIwNzYwNLMEXDAWbwLa', '13875018485795', 14.00, '2023-04-28', '2023-05-02', '2023-05-05', NULL, 4, 2, 1, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43432, 20755, 84034, NULL, 4, 14, 9, NULL, '2023-04-28', '06:58:00', NULL, 4639.00, 5566.00, 4729.00, 5675.00, '23012757', '', 'FlHoyHQ2cXxRdAU1', 90.08, 109.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-28', NULL, '983139', '13096981', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13875018485791', 'https://pdf.balikobot.cz/dpd/eNozNTEzVNBVMDIwN7I0N7JcMFwwFpcC4w..', '13875018485791', 17.00, '2023-04-28', '2023-05-02', '2023-05-05', NULL, 4, 2, 1, 0, '2023-04-28', 1, NULL, NULL, NULL, 0, 7),

(43433, NULL, 84036, 84035, 4, 25, 13, NULL, '2023-04-28', '07:56:00', NULL, 145.00, 174.00, 159.00, 192.00, '23020372', '', 'n4aEvSppEY45Bbam', 12.50, 15.00, 2.50, 3.00, NULL, NULL, 1, NULL, NULL, '983169', '13097231', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13875018572097', 'https://pdf.balikobot.cz/dpd/eNozNTEzVtBVMDIwNzYwNDIBXDAWegLT', '13875018572097', 23.00, '2023-04-28', '2023-05-02', '2023-05-05', NULL, 6, 6, 8, 1, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43434, NULL, 84037, NULL, 4, 52, 32, NULL, '2023-04-28', '08:38:00', NULL, 909.00, 1082.00, 958.00, 1141.00, '23090451', '', 'X3X8f2bvgDTkeVxt', 41.18, 49.00, 8.40, 10.00, NULL, NULL, 1, NULL, NULL, '1158188', '11068638', 'https://gls-group.eu/RO/ro/urmarire-colet?match=90361527065', 'https://pdf.balikobot.cz/gls/eNozNDKxNNc1tDAwNbM0MgFcMBU4Atg.', '90361527065', 16.00, '2023-04-28', '2023-05-04', '2023-05-07', NULL, 8, 8, 10, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43435, 20756, 84040, NULL, 4, 18, 11, NULL, '2023-04-28', '08:49:00', NULL, 193.00, 230.00, 201.00, 240.00, '23041298', '', 'yYuc5zhVNvv45a6h', 8.40, 10.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-28', NULL, '983254', '13098541', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845057211500', 'https://pdf.balikobot.cz/dpd/eNozNTEzVdBVMDIwNza0NDEBXDAWsgLg', '13845057211500', 13.00, '2023-04-28', '2023-05-04', '2023-05-07', NULL, 5, 5, 7, 0, NULL, 0, NULL, NULL, NULL, 0, 7),

(43436, NULL, 84041, NULL, 4, 7, 5, NULL, '2023-04-28', '08:50:00', NULL, 222.00, 271.00, 222.00, 271.00, '23070328', '', 'bp3OBOQ51dTCRner', 0.00, 0.00, 0.00, 0.00, NULL, NULL, 1, NULL, NULL, '986312', '13131701', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845066736385', 'https://pdf.balikobot.cz/dpd/eNqzNDc2VdBVMDIwtzAwMDEBXDAW6wLf', '13845066736385', 13.00, '2023-05-03', '2023-05-09', '2023-05-12', NULL, 3, 4, 5, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43437, NULL, 84042, NULL, 4, 48, 29, NULL, '2023-04-28', '08:59:00', NULL, 1580.00, 1975.00, 1659.00, 2074.00, '23110182', '', 'aOV8Y1ctDXC3IzCo', 79.20, 99.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-28', NULL, '983259', '13098629', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845066483328', 'https://pdf.balikobot.cz/dpd/eNozNDKxtFTQVTAyMDc2MjAzA1wwGdwDEQ..', '13845066483328', 15.00, '2023-04-28', '2023-05-18', '2023-05-21', NULL, 10, 10, 12, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43438, NULL, 84043, NULL, 4, 13, 9, NULL, '2023-04-28', '09:11:00', NULL, 3679.00, 4452.00, 3769.00, 4561.00, '23012758', '', 'GWggxRKR4vquf7AZ', 90.08, 109.00, 0.00, 0.00, NULL, NULL, 1, NULL, NULL, '984845', '13116738', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13875018485828', 'https://pdf.balikobot.cz/dpd/eNozNTEzVNBVMDIwN7UwNDMEXDAWkQLc', '13875018485828', 13.00, '2023-05-03', '2023-05-04', '2023-05-07', NULL, 4, 2, 1, 0, '2023-04-28', 1, NULL, NULL, NULL, NULL, 7),

(43439, NULL, 84044, NULL, 4, 14, 9, NULL, '2023-04-28', '09:16:00', NULL, 3569.00, 4319.00, 3659.00, 4428.00, '23012759', '', 'UmsTIn1EnulpII4B', 90.08, 109.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-28', NULL, '983251', '13098506', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13875018485798', 'https://pdf.balikobot.cz/dpd/eNozNTEzVNBVMDIwNza0sDQDXDAWiwLi', '13875018485798', 13.00, '2023-04-28', '2023-05-02', '2023-05-05', NULL, 4, 2, 1, 0, '2023-04-28', 1, NULL, NULL, NULL, NULL, 7),

(43440, NULL, 84045, NULL, 4, 9, 5, NULL, '2023-04-28', '09:52:00', NULL, 507.00, 619.00, 507.00, 619.00, '23070329', 'SI PREGA DI FATTURARE LA VENDITA CODICE SDI USAL8PV', 'ham1Hu8ZTJkdD92H', 0.00, 0.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-28', NULL, '984470', '13109751, 13109752, 13109753', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845066736373', 'https://pdf.balikobot.cz/dpd/eNqzNDc21TUyMDexMDUwB1wwEqICpw..', '13845066736373', 43.00, '2023-05-02', '2023-05-08', '2023-05-11', NULL, 3, 4, 5, 1, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43441, NULL, 84050, 84049, 4, 18, 11, NULL, '2023-04-28', '10:44:00', NULL, 86.00, 102.00, 94.00, 112.00, '23041299', '', 'pS64dX7DqbG2pJkp', 8.40, 10.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-28', NULL, '983730', '13103118', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845057211502', 'https://pdf.balikobot.cz/dpd/eNozNTEzVdBVMDIwN7awMDQFXDAWxgLk', '13845057211502', 13.00, '2023-04-28', '2023-05-04', '2023-05-07', NULL, 5, 5, 7, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43442, NULL, 84051, 84370, 4, 3, 1, NULL, '2023-04-28', '10:48:00', NULL, 193.00, 231.00, 209.00, 251.00, '23061595', '', 'LVogNk4R3i5WLRkC', 16.67, 20.00, 0.00, 0.00, NULL, NULL, 1, '2023-04-28', NULL, '989327', '13162534', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845053015621', 'https://pdf.balikobot.cz/dpd/eNqzMDGyVNBVMDKwMDI1NbNcMFwwFugC6Q..', '13845053015621', 18.00, '2023-05-05', '2023-05-12', '2023-05-15', NULL, 1, 1, 4, 0, NULL, 0, NULL, NULL, 'PALETY', NULL, 7),

(43443, NULL, 84052, NULL, 4, 16, 11, NULL, '2023-04-28', '11:11:00', NULL, 144.00, 171.00, 152.00, 181.00, '23041300', '', 'z7b0nAwreQwSQDeL', 8.40, 10.00, 0.00, 0.00, NULL, NULL, 1, NULL, NULL, '989383', '13162736', 'https://www.dpdgroup.com/cz/mydpd/my-parcels/track?parcelNumber=13845057211572', 'https://pdf.balikobot.cz/dpd/eNozNTEzVdBVMDKwMDK1NDBcMFwwFrcC3A..', '13845057211572', 14.00, '2023-05-05', '2023-05-11', '2023-05-14', NULL, 5, 5, 7, 0, NULL, 0, NULL, NULL, NULL, NULL, 7),

(43444, NULL, 84053, NULL, 5, 25, 13, NULL, '2023-04-28', '11:14:00', NULL, 185.00, 222.00, 194.00, 234.00, '23020373', '', 'AJR48cSkHx1SwJGr', 7.50, 9.00, 2.50, 3.00, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18.00, NULL, NULL, NULL, NULL, 6, 6, 8, 0, '2023-04-28', 1, NULL, NULL, NULL, NULL, 7),

INSERT INTO `admin__model__order_log` (`id`, `order_id`, `user_id`, `datetime`, `action`, `note`) VALUES

(497209, 34964, NULL, '2023-01-16 18:09:43', 'Informační email', 'E-mail "[rouesecours24.fr] Commande traitée - 23060057" odeslán na [email protected] <hr>\n\n<style>\n    @media (prefers-color-scheme: dark ) {\n        /*TODO: Dark mode?*/\n    }\n</style>\n<body style=''font-size:14px;font-weight:400;padding:20px 0;text-align:center;font-family:-apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"''>\n    <div style="display:inline-block;width:auto;margin:auto;max-width:720px;">\n        <a href="https://www.rouesecours24.fr" target="_blank"><img src="/files/front/logos/rouesecours24.png" alt="rouesecours24.fr" style="display:block;vertical-align:middle;max-width:250px;padding:10px;margin:auto auto 10px"></a>\n        <div style="border:1px solid #e7e7ee;padding:24px 12px;border-radius:6px;text-align:left;min-width:400px;">\n                <div style="height:30px;width:30px;padding:10px;text-align:center;background:#f5f5f9;border-radius:25px;margin:auto auto 10px;vertical-align:middle">\n                    <img src="/files/email/icons/cart.png" alt="Icon" style="height:auto;width:auto;max-width:100%;max-height:100%;display:inline-block;position:relative;top:50%;transform:translateY(-50%);">\n                </div>\n\n                <h1 style="text-align:center;font-weight:400;margin:0 0 20px;font-size:18px;line-height:20px;color:#666;">\n    Commande <b style="color:#0076be;">#23060057</b>\n                </h1>\n    <p>Bonjour,</p>\n<div>Votre commande sur <strong>rouesecours24.fr</strong> a &eacute;t&eacute; finalis&eacute;e avec succ&egrave;s.</div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Commande</h2>\n            \n        <b style="font-weight:200;color:#0076be;">Commande no. </b>: 23060057<br>\n            \n        <b style="font-weight:200;color:#0076be;">E-mail</b>: [email protected]<br>\n            \n        <b style="font-weight:200;color:#0076be;">Numéro de téléphone</b>: +33 662433329\n    </div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Détails de facturation</h2>\n        \n        christian BRYSELBOUT<br>\n        Gaspard Médecin 12<br>\n        MENTON 06500<br>\n        \n        France\n\n    <hr style="border:none;height:1px;background:#0076be;margin:15px -12px;background:linear-gradient(90deg, transparent 0, #0076be66 20%, #0076be66 80%, transparent 100%);">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Adresse de livraison</h2>\n            \n            christian BRYSELBOUT<br>\n            Gaspard Médecin 12    Rés.  L&amp;amp;#039;olivaie<br>\n            MENTON 06500<br>\n            \n            France\n    </div>\n\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">URL de suivi des envois</h2>\n<a href="https://tracking.dpd.de/status/fr_FR/parcel/13845053014274" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">https://tracking.dpd.de/status/fr_FR/parcel/13845053014274</a>        </div>\n\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;text-align:left;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Items commandés</h2>\n        <table style="border:none;font-size: 12px;border-collapse:collapse;">\n            <thead>\n                <tr>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Nom de produit</td>\n                    \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prix par pièce (TTC)</td>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Quantité</td>\n                        \n                        \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prix TTC</td>\n                </tr>\n            </thead>\n            <tbody>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.rouesecours24.fr/p/kit-roue-de-secours-kia-picanto-iii-r15-4x100x54-cle-gola-cric-housse-pour-cric" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">Kit - Roue de secours KIA PICANTO III R15 4x100x54,1 + Clé gola + Cric + House pour cric</a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">191 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">191 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;" colspan="3">Transport : Chronopost</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">20 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;" colspan="3">Paiement : Paypal</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;text-align:right">0 €</td>\n                </tr>\n            </tbody>\n            <tfoot>\n                <tr>\n                    \n                    \n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;" colspan="3">Prix total TTC</td>\n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;text-align:right">211 €</td>\n                </tr>\n            </tfoot>\n        </table>\n    </div>\n                <div style="text-align:center;margin-top:25px;">\n    \n    \n<a href="https://www.rouesecours24.fr/customer/order/hash/nV4Bn6Q3REuxOVGn" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">Voir le détail de la commande</a>\n                </div>\n                <div style="margin:20px 0 -20px;color:#acacac;font-size:12px;font-style:italic;">\n                </div>\n        </div>\n        <footer style="width:max-content; margin: 25px auto 0;">\n            <div style="text-align:center;margin-top:10px;font-size:0;white-space: nowrap;">\n                <a href="mailto:[email protected]" style="min-width:max-content;text-align:right;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">[email protected]</a>\n                <a target="_blank" href="https://www.rouesecours24.fr" style="min-width:max-content;text-align:left;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">rouesecours24.fr</a>\n            </div>\n        </footer>\n    </div>\n</body>'),

(497210, 34964, NULL, '2023-01-16 18:09:43', 'Balikobot state', 'Aktualizace stavu balíčku: 1.2 (Zásilka byla doručena příjemci.)'),

(497211, 34967, NULL, '2023-01-16 18:09:45', 'Aktualizace stavu', 'Stav nastaven na "Finalisée"'),

(497212, 34967, NULL, '2023-01-16 18:09:45', 'Informační email', 'E-mail "[thuiskomer24.nl] Bestelling voltooid - 23100027" odeslán na [email protected] <hr>\n\n<style>\n    @media (prefers-color-scheme: dark ) {\n        /*TODO: Dark mode?*/\n    }\n</style>\n<body style=''font-size:14px;font-weight:400;padding:20px 0;text-align:center;font-family:-apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"''>\n    <div style="display:inline-block;width:auto;margin:auto;max-width:720px;">\n        <a href="https://www.thuiskomer24.nl" target="_blank"><img src="/files/front/logos/thuiskomer24.png" alt="thuiskomer24.nl" style="display:block;vertical-align:middle;max-width:250px;padding:10px;margin:auto auto 10px"></a>\n        <div style="border:1px solid #e7e7ee;padding:24px 12px;border-radius:6px;text-align:left;min-width:400px;">\n                <div style="height:30px;width:30px;padding:10px;text-align:center;background:#f5f5f9;border-radius:25px;margin:auto auto 10px;vertical-align:middle">\n                    <img src="/files/email/icons/cart.png" alt="Icon" style="height:auto;width:auto;max-width:100%;max-height:100%;display:inline-block;position:relative;top:50%;transform:translateY(-50%);">\n                </div>\n\n                <h1 style="text-align:center;font-weight:400;margin:0 0 20px;font-size:18px;line-height:20px;color:#666;">\n    Bestelling <b style="color:#0076be;">#23100027</b>\n                </h1>\n    <p>Beste klant,&nbsp;</p>\n<p>Uw bestelling bij thuiskomer24.nl is voltooid. Wij zullen het op prijs stellen om uw beoordeling te ontvangen. Uw beoordeling kunt u bekendmaken via een nieuwe email die u binnen paar dagen ontvangt.</p>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Bestelling</h2>\n            \n        <b style="font-weight:200;color:#0076be;">Bestelling nr.</b>: 23100027<br>\n            \n        <b style="font-weight:200;color:#0076be;">E-mailadres</b>: [email protected]<br>\n            \n        <b style="font-weight:200;color:#0076be;">Telefoon</b>: +31 655792589\n    </div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Factuurgegevens</h2>\n        \n        Auto bedrijf m de jager de Jager<br>\n        De werf  13<br>\n        Gorredijk  8401je<br>\n        \n        Nederland\n\n    <hr style="border:none;height:1px;background:#0076be;margin:15px -12px;background:linear-gradient(90deg, transparent 0, #0076be66 20%, #0076be66 80%, transparent 100%);">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Bezorgadres</h2>\n            \n            <br>\n            <br>\n            <br>\n            \n            \n    </div>\n\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">URL-adres voor het volgen van uw zending</h2>\n<a href="https://tracking.dpd.de/status/nl_NL/parcel/13845066526347" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">https://tracking.dpd.de/status/nl_NL/parcel/13845066526347</a>        </div>\n\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;text-align:left;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Bestelitems</h2>\n        <table style="border:none;font-size: 12px;border-collapse:collapse;">\n            <thead>\n                <tr>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Artikelnaam</td>\n                    \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prijs per stuk (incl. btw)</td>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Aantal</td>\n                        \n                        \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prijs incl. btw</td>\n                </tr>\n            </thead>\n            <tbody>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.thuiskomer24.nl/p/set-thuiskomer-land-rover-discovery-r19-5x120x72-6-sleutel-krik-opbergzak-voor-krik" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">Set – Thuiskomer LAND ROVER DISCOVERY R19 5x120x72,6 + sleutel + krik + opbergzak voor krik</a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">278 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">278 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;" colspan="3">Bezorging : DPD</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">15 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;" colspan="3">Betaling : Betalen met iDEAL</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;text-align:right">0 €</td>\n                </tr>\n            </tbody>\n            <tfoot>\n                <tr>\n                    \n                    \n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;" colspan="3">Totaalprijs incl. btw</td>\n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;text-align:right">293 €</td>\n                </tr>\n            </tfoot>\n        </table>\n    </div>\n                <div style="text-align:center;margin-top:25px;">\n    \n    \n<a href="https://www.thuiskomer24.nl/customer/order/hash/phscdMHHQ0FU6gwX" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">Details bestelling tonen</a>\n                </div>\n                <div style="margin:20px 0 -20px;color:#acacac;font-size:12px;font-style:italic;">\n                </div>\n        </div>\n        <footer style="width:max-content; margin: 25px auto 0;">\n            <div style="text-align:center;margin-top:10px;font-size:0;white-space: nowrap;">\n                <a href="mailto:[email protected]" style="min-width:max-content;text-align:right;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">[email protected]</a>\n                <a target="_blank" href="https://www.thuiskomer24.nl" style="min-width:max-content;text-align:left;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">thuiskomer24.nl</a>\n            </div>\n        </footer>\n    </div>\n</body>'),

(497213, 34967, NULL, '2023-01-16 18:09:45', 'Balikobot state', 'Aktualizace stavu balíčku: 1.2 (Zásilka byla doručena příjemci.)'),

(497214, 34972, NULL, '2023-01-16 18:09:47', 'Aktualizace stavu', 'Stav nastaven na "Finalisée"'),

(497215, 34972, NULL, '2023-01-16 18:09:47', 'Informační email', 'E-mail "[ruotinodiscorta24.it] Ordine completato - 23070018" odeslán na [email protected] <hr>\n\n<style>\n    @media (prefers-color-scheme: dark ) {\n        /*TODO: Dark mode?*/\n    }\n</style>\n<body style=''font-size:14px;font-weight:400;padding:20px 0;text-align:center;font-family:-apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"''>\n    <div style="display:inline-block;width:auto;margin:auto;max-width:720px;">\n        <a href="https://www.ruotinodiscorta24.it" target="_blank"><img src="/files/front/logos/ruotinodiscorta24.png" alt="ruotinodiscorta24.it" style="display:block;vertical-align:middle;max-width:250px;padding:10px;margin:auto auto 10px"></a>\n        <div style="border:1px solid #e7e7ee;padding:24px 12px;border-radius:6px;text-align:left;min-width:400px;">\n                <div style="height:30px;width:30px;padding:10px;text-align:center;background:#f5f5f9;border-radius:25px;margin:auto auto 10px;vertical-align:middle">\n                    <img src="/files/email/icons/cart.png" alt="Icon" style="height:auto;width:auto;max-width:100%;max-height:100%;display:inline-block;position:relative;top:50%;transform:translateY(-50%);">\n                </div>\n\n                <h1 style="text-align:center;font-weight:400;margin:0 0 20px;font-size:18px;line-height:20px;color:#666;">\n    Ordine <b style="color:#0076be;">#23070018</b>\n                </h1>\n    <p><span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;Buongiorno,\\n\\nil tuo ordine su ruotinodiscorta24.it &egrave; stato completato con successo.&nbsp;&quot;}" data-sheets-userformat="{&quot;2&quot;:14593,&quot;3&quot;:{&quot;1&quot;:0,&quot;3&quot;:1},&quot;11&quot;:4,&quot;14&quot;:{&quot;1&quot;:3,&quot;3&quot;:1},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}">Buongiorno,<br /><br />il tuo ordine su <strong>ruotinodiscorta24.it</strong> &egrave; stato completato con successo.&nbsp;</span></p>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Ordine</h2>\n            \n        <b style="font-weight:200;color:#0076be;">Ordine no.</b>: 23070018<br>\n            \n        <b style="font-weight:200;color:#0076be;">E-mail</b>: [email protected]<br>\n            \n        <b style="font-weight:200;color:#0076be;">Telefono</b>: +39 3497221555\n    </div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Dati di fatturazione</h2>\n        \n        Fabio Battegazzore<br>\n        Corso della Repubblica  32/D<br>\n        Tortona 15057<br>\n        \n        Italia\n\n    </div>\n\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">URL di monitoraggio della spedizione </h2>\n<a href="https://tracking.dpd.de/status/it_IT/parcel/13845066736085" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">https://tracking.dpd.de/status/it_IT/parcel/13845066736085</a>        </div>\n\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;text-align:left;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Articoli dell''ordine</h2>\n        <table style="border:none;font-size: 12px;border-collapse:collapse;">\n            <thead>\n                <tr>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Nome del prodotto</td>\n                    \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prezzo al pezzo (con IVA)</td>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Quantità</td>\n                        \n                        \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prezzo con IVA</td>\n                </tr>\n            </thead>\n            <tbody>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.ruotinodiscorta24.it/p/set-ruotino-di-scorta-seat-leon-iii-r15-5x112x57-giradadi-crick-custodia-per-crick" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">Set - Ruotino di scorta SEAT LEON III R15 5x112x57,1 + Giradadi + Crick + Custodia per crick</a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">188 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">188 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.ruotinodiscorta24.it/p/custodia-ruotino-di-scorta" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">CUSTODIA RUOTINO DI SCORTA </a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">15 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">15 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;" colspan="3">Spedizione : BRT</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">0 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;" colspan="3">Pagamento : Paypal</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;text-align:right">0 €</td>\n                </tr>\n            </tbody>\n            <tfoot>\n                <tr>\n                    \n                    \n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;" colspan="3">Prezzo totale con IVA</td>\n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;text-align:right">203 €</td>\n                </tr>\n            </tfoot>\n        </table>\n    </div>\n                <div style="text-align:center;margin-top:25px;">\n    \n    \n<a href="https://www.ruotinodiscorta24.it/customer/order/hash/s1mrrfWBD8Iqu8mg" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">Visualizza i dettagli dell''ordine</a>\n                </div>\n                <div style="margin:20px 0 -20px;color:#acacac;font-size:12px;font-style:italic;">\n                </div>\n        </div>\n        <footer style="width:max-content; margin: 25px auto 0;">\n            <div style="text-align:center;margin-top:10px;font-size:0;white-space: nowrap;">\n                <a href="mailto:[email protected]" style="min-width:max-content;text-align:right;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">[email protected]</a>\n                <a target="_blank" href="https://www.ruotinodiscorta24.it" style="min-width:max-content;text-align:left;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">ruotinodiscorta24.it</a>\n            </div>\n        </footer>\n    </div>\n</body>'),

(497216, 34972, NULL, '2023-01-16 18:09:47', 'Balikobot state', 'Aktualizace stavu balíčku: 1.2 (Zásilka byla doručena příjemci.)'),

(497217, 34975, NULL, '2023-01-16 18:09:47', 'Balikobot state', 'Aktualizace stavu balíčku: 2.2 (Zásilka je v přepravě.)'),

(497218, 34980, NULL, '2023-01-16 18:09:48', 'Balikobot state', 'Aktualizace stavu balíčku: 2.2 (Zásilka je v přepravě.)'),

(497219, 34987, NULL, '2023-01-16 18:09:48', 'Aktualizace stavu', 'Stav nastaven na "Finalisée"'),

(497220, 34987, NULL, '2023-01-16 18:09:48', 'Informační email', 'E-mail "[rouesecours24.fr] Commande traitée - 23060065" odeslán na [email protected] <hr>\n\n<style>\n    @media (prefers-color-scheme: dark ) {\n        /*TODO: Dark mode?*/\n    }\n</style>\n<body style=''font-size:14px;font-weight:400;padding:20px 0;text-align:center;font-family:-apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"''>\n    <div style="display:inline-block;width:auto;margin:auto;max-width:720px;">\n        <a href="https://www.rouesecours24.fr" target="_blank"><img src="/files/front/logos/rouesecours24.png" alt="rouesecours24.fr" style="display:block;vertical-align:middle;max-width:250px;padding:10px;margin:auto auto 10px"></a>\n        <div style="border:1px solid #e7e7ee;padding:24px 12px;border-radius:6px;text-align:left;min-width:400px;">\n                <div style="height:30px;width:30px;padding:10px;text-align:center;background:#f5f5f9;border-radius:25px;margin:auto auto 10px;vertical-align:middle">\n                    <img src="/files/email/icons/cart.png" alt="Icon" style="height:auto;width:auto;max-width:100%;max-height:100%;display:inline-block;position:relative;top:50%;transform:translateY(-50%);">\n                </div>\n\n                <h1 style="text-align:center;font-weight:400;margin:0 0 20px;font-size:18px;line-height:20px;color:#666;">\n    Commande <b style="color:#0076be;">#23060065</b>\n                </h1>\n    <p>Bonjour,</p>\n<div>Votre commande sur <strong>rouesecours24.fr</strong> a &eacute;t&eacute; finalis&eacute;e avec succ&egrave;s.</div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Commande</h2>\n            \n        <b style="font-weight:200;color:#0076be;">Commande no. </b>: 23060065<br>\n            \n        <b style="font-weight:200;color:#0076be;">E-mail</b>: [email protected]<br>\n            \n        <b style="font-weight:200;color:#0076be;">Numéro de téléphone</b>: +33 687410800\n    </div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Détails de facturation</h2>\n        \n        Gerard dumas<br>\n        rue du 11 novembre 1918 22<br>\n        saint seurin sur l&amp;#039;isle 33660<br>\n        \n        France\n\n    </div>\n\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">URL de suivi des envois</h2>\n<a href="https://tracking.dpd.de/status/fr_FR/parcel/13845053014271" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">https://tracking.dpd.de/status/fr_FR/parcel/13845053014271</a>        </div>\n\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;text-align:left;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Items commandés</h2>\n        <table style="border:none;font-size: 12px;border-collapse:collapse;">\n            <thead>\n                <tr>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Nom de produit</td>\n                    \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prix par pièce (TTC)</td>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Quantité</td>\n                        \n                        \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prix TTC</td>\n                </tr>\n            </thead>\n            <tbody>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.rouesecours24.fr/p/roue-de-secours-renault-arkana-r18-5x114-3x66-1" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">Roue de secours RENAULT ARKANA R18 5x114,3x66,1</a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">186 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">186 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;" colspan="3">Transport : Chronopost</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">20 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;" colspan="3">Paiement : Paiement par CB</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;text-align:right">0 €</td>\n                </tr>\n            </tbody>\n            <tfoot>\n                <tr>\n                    \n                    \n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;" colspan="3">Prix total TTC</td>\n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;text-align:right">206 €</td>\n                </tr>\n            </tfoot>\n        </table>\n    </div>\n                <div style="text-align:center;margin-top:25px;">\n    \n    \n<a href="https://www.rouesecours24.fr/customer/order/hash/Nby5iAqX1KbPL01K" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">Voir le détail de la commande</a>\n                </div>\n                <div style="margin:20px 0 -20px;color:#acacac;font-size:12px;font-style:italic;">\n                </div>\n        </div>\n        <footer style="width:max-content; margin: 25px auto 0;">\n            <div style="text-align:center;margin-top:10px;font-size:0;white-space: nowrap;">\n                <a href="mailto:[email protected]" style="min-width:max-content;text-align:right;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">[email protected]</a>\n                <a target="_blank" href="https://www.rouesecours24.fr" style="min-width:max-content;text-align:left;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">rouesecours24.fr</a>\n            </div>\n        </footer>\n    </div>\n</body>'),

(497221, 34987, NULL, '2023-01-16 18:09:48', 'Balikobot state', 'Aktualizace stavu balíčku: 1.2 (Zásilka byla doručena příjemci.)'),

(497222, 34989, NULL, '2023-01-16 18:09:50', 'Aktualizace stavu', 'Stav nastaven na "Finalisée"'),

(497223, 34989, NULL, '2023-01-16 18:09:50', 'Informační email', 'E-mail "[ruotinodiscorta24.it] Ordine completato - 23070020" odeslán na [email protected] <hr>\n\n<style>\n    @media (prefers-color-scheme: dark ) {\n        /*TODO: Dark mode?*/\n    }\n</style>\n<body style=''font-size:14px;font-weight:400;padding:20px 0;text-align:center;font-family:-apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"''>\n    <div style="display:inline-block;width:auto;margin:auto;max-width:720px;">\n        <a href="https://www.ruotinodiscorta24.it" target="_blank"><img src="/files/front/logos/ruotinodiscorta24.png" alt="ruotinodiscorta24.it" style="display:block;vertical-align:middle;max-width:250px;padding:10px;margin:auto auto 10px"></a>\n        <div style="border:1px solid #e7e7ee;padding:24px 12px;border-radius:6px;text-align:left;min-width:400px;">\n                <div style="height:30px;width:30px;padding:10px;text-align:center;background:#f5f5f9;border-radius:25px;margin:auto auto 10px;vertical-align:middle">\n                    <img src="/files/email/icons/cart.png" alt="Icon" style="height:auto;width:auto;max-width:100%;max-height:100%;display:inline-block;position:relative;top:50%;transform:translateY(-50%);">\n                </div>\n\n                <h1 style="text-align:center;font-weight:400;margin:0 0 20px;font-size:18px;line-height:20px;color:#666;">\n    Ordine <b style="color:#0076be;">#23070020</b>\n                </h1>\n    <p><span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;Buongiorno,\\n\\nil tuo ordine su ruotinodiscorta24.it &egrave; stato completato con successo.&nbsp;&quot;}" data-sheets-userformat="{&quot;2&quot;:14593,&quot;3&quot;:{&quot;1&quot;:0,&quot;3&quot;:1},&quot;11&quot;:4,&quot;14&quot;:{&quot;1&quot;:3,&quot;3&quot;:1},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}">Buongiorno,<br /><br />il tuo ordine su <strong>ruotinodiscorta24.it</strong> &egrave; stato completato con successo.&nbsp;</span></p>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Ordine</h2>\n            \n        <b style="font-weight:200;color:#0076be;">Ordine no.</b>: 23070020<br>\n            \n        <b style="font-weight:200;color:#0076be;">E-mail</b>: [email protected]<br>\n            \n        <b style="font-weight:200;color:#0076be;">Telefono</b>: +39 3348411986\n    </div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Dati di fatturazione</h2>\n        Michele Fedeli<br>\n        Michele  Fedeli<br>\n        Girolamo Mechelli  1158<br>\n        Morlupo 00067<br>\n        \n        Italia\n\n    <hr style="border:none;height:1px;background:#0076be;margin:15px -12px;background:linear-gradient(90deg, transparent 0, #0076be66 20%, #0076be66 80%, transparent 100%);">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Indirizzo di consegna</h2>\n            \n            Augusto Fedeli<br>\n            Carlo Ludovico Bragaglia 190<br>\n            Roma 00139<br>\n            \n            Italia\n    </div>\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Informazioni sull''azienda</h2>\n            Michele Fedeli<br>\n            \n            <b style="font-weight:200;color:#0076be;">CF</b>: <br>\n            \n            <b style="font-weight:200;color:#0076be;">Partita IVA</b>: IT10998501000\n        </div>\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">URL di monitoraggio della spedizione </h2>\n<a href="https://tracking.dpd.de/status/it_IT/parcel/13845066736084" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">https://tracking.dpd.de/status/it_IT/parcel/13845066736084</a>        </div>\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Nota</h2>\n            citofono Cosentino - Fedeli\n        </div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;text-align:left;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Articoli dell''ordine</h2>\n        <table style="border:none;font-size: 12px;border-collapse:collapse;">\n            <thead>\n                <tr>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Nome del prodotto</td>\n                    \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prezzo al pezzo</td>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Quantità</td>\n                        \n                        \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prezzo senza IVA</td>\n                </tr>\n            </thead>\n            <tbody>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.ruotinodiscorta24.it/p/set-ruotino-di-scorta-ford-ecosport-r16-4x108x63-3-giradadi-crick-custodia-per-crick" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">Set - Ruotino di scorta FORD ECOSPORT R16 4x108x63,3 + Giradadi + Crick + Custodia per crick</a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">166 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">166 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;" colspan="3">Spedizione : BRT</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">0 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;" colspan="3">Pagamento : Pagamento con carta di credito</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;text-align:right">0 €</td>\n                </tr>\n            </tbody>\n            <tfoot>\n                <tr>\n                    \n                    \n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;" colspan="3">Prezzo totale senza IVA</td>\n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;text-align:right">166 €</td>\n                </tr>\n            </tfoot>\n        </table>\n    </div>\n                <div style="text-align:center;margin-top:25px;">\n    \n    \n<a href="https://www.ruotinodiscorta24.it/customer/order/hash/Srq1riWX8dJaVY5m" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">Visualizza i dettagli dell''ordine</a>\n                </div>\n                <div style="margin:20px 0 -20px;color:#acacac;font-size:12px;font-style:italic;">\n    Tutti i prezzi sono senza IVA\n                </div>\n        </div>\n        <footer style="width:max-content; margin: 25px auto 0;">\n            <div style="text-align:center;margin-top:10px;font-size:0;white-space: nowrap;">\n                <a href="mailto:[email protected]" style="min-width:max-content;text-align:right;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">[email protected]</a>\n                <a target="_blank" href="https://www.ruotinodiscorta24.it" style="min-width:max-content;text-align:left;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">ruotinodiscorta24.it</a>\n            </div>\n        </footer>\n    </div>\n</body>'),

(497224, 34989, NULL, '2023-01-16 18:09:50', 'Balikobot state', 'Aktualizace stavu balíčku: 1.2 (Zásilka byla doručena příjemci.)'),

(497225, 34993, NULL, '2023-01-16 18:09:52', 'Aktualizace stavu', 'Stav nastaven na "Finalisée"');

INSERT INTO `admin__model__order_log` (`id`, `order_id`, `user_id`, `datetime`, `action`, `note`) VALUES

(497226, 34993, NULL, '2023-01-16 18:09:52', 'Informační email', 'E-mail "[rouesecours24.fr] Commande traitée - 23060067" odeslán na [email protected] <hr>\n\n<style>\n    @media (prefers-color-scheme: dark ) {\n        /*TODO: Dark mode?*/\n    }\n</style>\n<body style=''font-size:14px;font-weight:400;padding:20px 0;text-align:center;font-family:-apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"''>\n    <div style="display:inline-block;width:auto;margin:auto;max-width:720px;">\n        <a href="https://www.rouesecours24.fr" target="_blank"><img src="/files/front/logos/rouesecours24.png" alt="rouesecours24.fr" style="display:block;vertical-align:middle;max-width:250px;padding:10px;margin:auto auto 10px"></a>\n        <div style="border:1px solid #e7e7ee;padding:24px 12px;border-radius:6px;text-align:left;min-width:400px;">\n                <div style="height:30px;width:30px;padding:10px;text-align:center;background:#f5f5f9;border-radius:25px;margin:auto auto 10px;vertical-align:middle">\n                    <img src="/files/email/icons/cart.png" alt="Icon" style="height:auto;width:auto;max-width:100%;max-height:100%;display:inline-block;position:relative;top:50%;transform:translateY(-50%);">\n                </div>\n\n                <h1 style="text-align:center;font-weight:400;margin:0 0 20px;font-size:18px;line-height:20px;color:#666;">\n    Commande <b style="color:#0076be;">#23060067</b>\n                </h1>\n    <p>Bonjour,</p>\n<div>Votre commande sur <strong>rouesecours24.fr</strong> a &eacute;t&eacute; finalis&eacute;e avec succ&egrave;s.</div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Commande</h2>\n            \n        <b style="font-weight:200;color:#0076be;">Commande no. </b>: 23060067<br>\n            \n        <b style="font-weight:200;color:#0076be;">E-mail</b>: [email protected]<br>\n            \n        <b style="font-weight:200;color:#0076be;">Numéro de téléphone</b>: +33 671646827\n    </div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Détails de facturation</h2>\n        \n        Thierry Lehning<br>\n        12 Rue Charles Vaillant 12<br>\n        Montgeron 91230<br>\n        \n        France\n\n    </div>\n\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">URL de suivi des envois</h2>\n<a href="https://tracking.dpd.de/status/fr_FR/parcel/13845053014270" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">https://tracking.dpd.de/status/fr_FR/parcel/13845053014270</a>        </div>\n\n        <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;">\n            \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Note</h2>\n            12 Rue Charles Vaillant\n        </div>\n\n\n    <div style="background:#f6f6f6;margin:15px 0;padding: 10px 12px;text-align:left;">\n        \n    <h2 style="font-size:16px;margin:0 0 5px;font-weight:400;color:#0076be;">Items commandés</h2>\n        <table style="border:none;font-size: 12px;border-collapse:collapse;">\n            <thead>\n                <tr>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Nom de produit</td>\n                    \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prix par pièce (TTC)</td>\n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Quantité</td>\n                        \n                        \n                    <td style="padding:3px 5px;font-weight:400;border-bottom:1px solid #888;font-size:14px;">Prix TTC</td>\n                </tr>\n            </thead>\n            <tbody>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.rouesecours24.fr/p/housse-pour-galette" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">HOUSSE POUR GALETTE</a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">14 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">14 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.rouesecours24.fr/p/gilet-de-signalisation-reflechissant-jaune" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">Gilet de signalisation réfléchissant jaune</a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">2 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">2 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;">\n<a href="https://www.rouesecours24.fr/p/roue-de-secours-hyundai-santa-fe-iii-r17-5x114-3x67-1-1" target="_blank" style="color:#005488;font-weight:400;text-decoration:none;">Roue de secours HYUNDAI SANTA FE III R17 5x114,3x67,1</a>                    </td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">190 €</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:center">1</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">190 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;" colspan="3">Transport : Chronopost</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #ddd;font-size:12px;text-align:right">20 €</td>\n                </tr>\n                <tr>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;" colspan="3">Paiement : Paypal</td>\n                    <td style="padding:3px 5px;border-bottom:1px solid #bbb;font-size:12px;text-align:right">0 €</td>\n                </tr>\n            </tbody>\n            <tfoot>\n                <tr>\n                    \n                    \n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;" colspan="3">Prix total TTC</td>\n                    <td style="padding:3px 5px;font-weight:500;font-size:14px;text-align:right">226 €</td>\n                </tr>\n            </tfoot>\n        </table>\n    </div>\n                <div style="text-align:center;margin-top:25px;">\n    \n    \n<a href="https://www.rouesecours24.fr/customer/order/hash/H56OkFWfCYHzKyms" target="_blank" style="height:21px;vertical-align:middle;line-height:21px;display:inline-block;padding:3px 7px;border-radius:4px;background:#0076be;border:1px solid #0076be;text-decoration:none;color:#ffffff;font-weight:400;">Voir le détail de la commande</a>\n                </div>\n                <div style="margin:20px 0 -20px;color:#acacac;font-size:12px;font-style:italic;">\n                </div>\n        </div>\n        <footer style="width:max-content; margin: 25px auto 0;">\n            <div style="text-align:center;margin-top:10px;font-size:0;white-space: nowrap;">\n                <a href="mailto:[email protected]" style="min-width:max-content;text-align:right;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">[email protected]</a>\n                <a target="_blank" href="https://www.rouesecours24.fr" style="min-width:max-content;text-align:left;display:inline-block;text-decoration:none;color:#0076be;width:49%;font-size:14px;padding:0 5px;">rouesecours24.fr</a>\n            </div>\n        </footer>\n    </div>\n</body>'),

(497227, 34993, NULL, '2023-01-16 18:09:52', 'Balikobot state', 'Aktualizace stavu balíčku: 1.2 (Zásilka byla doručena příjemci.)'),

[align=center](497228, 34994, NULL, '2023-01-16 18:09:54', 'Aktualizace stavu', 'Stav nastaven na "Finalisée"'),

Download:

Hidden Content

You must

[To see links please register here]

or

[To see links please register here]

to view this content.

Tartışmaya katkınız için teşekkürler!

Very Niceeee

Thank youyou

תודה על הפוסט שלך!

Very Niceeeeeee

thankssssssssss

Your post is a true game-changer!

okkkkkkkkkkkkkkkkkkkkkkkkk

Obrigado pelo seu post!

paths50708

koumisses51303

coleopteroidlzopf

Mrendbrain4

leciennkqndvj

peterus443

refreezing340083

minnesotatwjpfhsmj

nuncupative755087

conveyorized754118