Forum Kurallarını Okumak İçin Lütfen Tıklayınız .

Database Leaked Smartfuel.es Sql © Chucky 

Sql © Chucky Database Leaked Smartfuel.es
Joined
Jun 7, 2021
Messages
4,299
Reaction score
56,164
#CR
261

logo.png

Database Leaked Smartfuel.es
INSERT INTO `sales` (`id_sales`, `id_supply_transactions`, `id_app`, `id_users`, `id_vehicle`, `id_station`, `id_type_product`, `price`, `source`, `environment`, `date_time`, `device`, `model`, `version`, `app_version`, `device_id`, `device_os`, `device_os_version`, `promo_code`, `discount`, `station_data`, `price_purchase`, `station_tax`) VALUES

INSERT INTO `bill` (`id_bill`, `date_created`, `number`, `cod_client`, `tax_id`, `country`, `state`, `city`, `adress`, `zip_code`, `iva_total`, `iva`, `descuento`, `total`, `id_sales`, `id_supply_transactions`, `user_name`, `user_last_name`, `smartfuel_tax_id`, `smartfuel_name`, `smartfuel_address`, `smartfuel_city`, `smartfuel_state`, `smartfuel_country`, `smartfuel_zip_code`, `eess_tax_id`, `eess_company_name`, `eess_company_address`, `eess_company_city`, `eess_company_state`, `eess_company_country`, `eess_site_name`, `eess_site_address`, `eess_site_city`, `eess_site_state`, `eess_site_country`, `dispensed_quantity`, `dispensed_price`, `dispensed_amount`, `discount_price`) VALUES
Format - .SQL
Size sql file - 300mb
Date - 2023
All Rows - 300k
Website - smartfuel.es
Leaked by Chucky​


HTML:
(110035, '1475334332', 4514, 7354, 15423, 150, 1, '57.07', 'ANDROID_APP', 'PRO', '2022-09-08 17:54:03', 'Xiaomi', 'M2004J19C', '', '1.2.20', 'flLyIer2f5o:APA91bFtjWGQ5wdX8fYUV_r8xGFcB3kGs', 'ANDROID', '11', '', '7.18', '{\"transactionID\":\"1475334332\",\"status\":300,\"transactionDocument\":{\"vendor\":{\"taxID\":\"B96260880\",\"companyName\":\"American Petrol\",\"companyAddress\":\"C\\/ Aladrers, 16 (Esquina C\\/ Fusters)\",\"companyCity\":\"Alacuas\",\"companyState\":\"Valencia\",\"companyCountry\":\"\",\"siteName\":\"2 Cuart de Poblet\",\"siteAddress\":null,\"siteCity\":null,\"siteState\":\"VALENCIA\",\"siteCountry\":\"ES\"},\"customer\":{\"taxID\":\"B66843194\",\"name\":\"14481 Smart Fuel Technologies, S.L\",\"address\":\"Rbla. Catalunya 116, 2\\u00ba, 5\\u00aa\",\"city\":\"Barcelona\",\"state\":null,\"country\":\"\",\"zipCode\":\"08008\"},\"receiptDate\":\"2022-09-08T05:53:52.797Z\",\"receiptNumber\":\"C22040457\",\"lineItems\":[{\"productCode\":1,\"description\":\"DIESEL\",\"regularSellPrice\":1.969,\"actualSalesPrice\":1.719,\"unitPriceDiscount\":0.25,\"discountRate\":0,\"salesQuantity\":32.63078,\"salesAmount\":64.25,\"discountAmount\":8.16,\"taxItem\":{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":46.36,\"taxCollectedAmount\":9.73}}],\"transactionSummary\":{\"transactionTotalGrossAmount\":53.1,\"transactionTotalNetAmount\":46.36,\"transactionTotalTaxSalesAmount\":9.73,\"transactionTotalAmount\":56.09,\"taxItems\":[{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":46.36,\"taxCollectedAmount\":9.73}]},\"remarks1\":\"\",\"remarks2\":\"Ha obtenido una bonificaci\\u00f3n de 0,20 euros por litro, bonificados por el Estado seg\\u00fan RD-ley 6\\/2022 de marzo de 2022.\",\"remarks3\":\"\"},\"dispensedQuantity\":32.63078,\"dispensedPrice\":1.749,\"dispensedAmount\":57.07}', 1.719, 'B96260880'),
(110036, '5588627319', 4512, 6384, 6644, 72, 1, '66.64', 'IPHONE_APP', 'PRO', '2022-09-08 18:02:03', 'Apple', 'iPhone', '', '1.3.2', 'fEzEoqBR9UaDhcKtfq__D2:APA91bG7TSutrwwnPxLvl7', 'iOS', '15.6.1', '', '8.38', '{\"vendor\":{\"taxID\":\"B86591021\",\"companyName\":\"PUNTOS BAJO COSTE S.L.\",\"companyAddress\":\"C\\/ Juan Bravo n\\u00ba3\",\"companyCity\":\"MADRID\",\"companyState\":\"MADRID\",\"companyCountry\":\"ES\",\"siteName\":\"SBC A ESTRADA\",\"siteAddress\":\"Crt. PO 841 PK19.800\",\"siteCity\":\"A ESTRADA\",\"siteState\":\"PONTEVEDRA\",\"siteCountry\":\"ES\"},\"customer\":{\"taxID\":null,\"name\":\"COLECTIVO A GRELA 2\",\"address\":null,\"city\":null,\"state\":null,\"country\":\"\",\"zipCode\":null},\"receiptDate\":\"2022-09-08T06:01:18.000Z\",\"receiptNumber\":\"FE000310\",\"billNumber\":\"\",\"lineItems\":[{\"productCode\":1,\"description\":\"Gas\\u00f3leo A\",\"regularSellPrice\":1.79,\"actualSalesPrice\":1.59,\"unitPriceDiscount\":0.2,\"discountRate\":0,\"salesQuantity\":41.91061,\"salesAmount\":75.02,\"discountAmount\":8.38,\"taxItem\":{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":55.07,\"taxCollectedAmount\":11.57}}],\"payments\":[{\"paymentMethod\":\"Smart Fuel\",\"amount\":66.64}],\"promotionReward\":{\"discountCardNumber\":null,\"pointsCardNumber\":null,\"rewardedPointsQuantity\":0},\"transactionSummary\":{\"transactionTotalGrossAmount\":62,\"transactionTotalNetAmount\":55.07,\"transactionTotalTaxSalesAmount\":11.57,\"transactionTotalAmount\":66.64,\"taxItems\":[{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":55.07,\"taxCollectedAmount\":11.57}]},\"remarks1\":\"\",\"remarks2\":\"En el precio por litro de carburante se ha aplicado la bonificaci\\u00f3n establecida en el RDL 6\\/2022\",\"remarks3\":\"\"}', 0, ''),
(110037, '3787798869', 4514, 7870, 14180, 26, 5, '30.67', 'ANDROID_APP', 'PRO', '2022-09-08 18:08:02', 'Xiaomi', 'Mi MIX 2S', '', '1.2.20', 'e4duuAGi6JE:APA91bG7K7Rw3Ir1ASTqEJBoxgp_y_kS8', 'ANDROID', '10', '', '4.12', '{\"vendor\":{\"taxID\":\"B86591021\",\"companyName\":\"PUNTOS BAJO COSTE S.L.\",\"companyAddress\":\"C\\/ Juan Bravo n\\u00ba3\",\"companyCity\":\"MADRID\",\"companyState\":\"MADRID\",\"companyCountry\":\"ES\",\"siteName\":\"SBC CORU\\u00d1A\",\"siteAddress\":\"C\\/ Severo Ochoa n\\u00ba39 - Pol. Ind. A Grela\",\"siteCity\":\"CORU\\u00d1A, A\",\"siteState\":\"LA CORU\\u00d1A\",\"siteCountry\":\"ES\"},\"customer\":{\"taxID\":null,\"name\":\"Smart Fuel\",\"address\":null,\"city\":null,\"state\":null,\"country\":\"\",\"zipCode\":null},\"receiptDate\":\"2022-09-08T06:07:57.000Z\",\"receiptNumber\":\"FC000443\",\"billNumber\":\"\",\"lineItems\":[{\"productCode\":5,\"description\":\"Sin Plomo 95\",\"regularSellPrice\":1.689,\"actualSalesPrice\":1.489,\"unitPriceDiscount\":0.2,\"discountRate\":0,\"salesQuantity\":20.59799,\"salesAmount\":34.79,\"discountAmount\":4.12,\"taxItem\":{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":25.35,\"taxCollectedAmount\":5.32}}],\"payments\":[{\"paymentMethod\":\"Smart Fuel\",\"amount\":30.67}],\"promotionReward\":{\"discountCardNumber\":null,\"pointsCardNumber\":null,\"rewardedPointsQuantity\":0},\"transactionSummary\":{\"transactionTotalGrossAmount\":28.75,\"transactionTotalNetAmount\":25.35,\"transactionTotalTaxSalesAmount\":5.32,\"transactionTotalAmount\":30.67,\"taxItems\":[{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":25.35,\"taxCollectedAmount\":5.32}]},\"remarks1\":\"\",\"remarks2\":\"En el precio por litro de carburante se ha aplicado la bonificaci\\u00f3n establecida en el RDL 6\\/2022\",\"remarks3\":\"\"}', 0, ''),
(110038, '5556135553', 4512, 13506, 15178, 52, 5, '66.56', 'IPHONE_APP', 'PRO', '2022-09-08 18:19:02', 'Apple', 'iPhone', '', '1.3.2', 'dSQlvNinf0y9ppqPTarLGp:APA91bHoWQnHh8UzjZQGq2', 'iOS', '15.4.1', '', '9.90', '{\"transactionID\":\"5556135553\",\"status\":300,\"transactionDocument\":{\"vendor\":{\"taxID\":\"B66099441\",\"companyName\":\"GOOD PRICE PALAU S.L\",\"companyAddress\":\"Menorca, 7\",\"companyCity\":\"PALAU DE PLEGAMANS\",\"companyState\":\"BARCELONA\",\"companyCountry\":\"ES\",\"siteName\":\"GP GOOD PRICE\",\"siteAddress\":\"Av. Badalona 22\",\"siteCity\":\"Mollet del Vall\\u00e9s\",\"siteState\":\"Barcelona\",\"siteCountry\":\"ES\"},\"customer\":{\"taxID\":\"B66843194\",\"name\":\"Smart Fuel Technologies S.L.\",\"address\":\"Rbla. Catalunya, 116, 5\\u00ba, 2\\u00aa\",\"city\":\"BARCELONA\",\"state\":\"BARCELONA\",\"country\":\"ES\",\"zipCode\":\"08008\"},\"receiptDate\":\"2022-09-08T06:18:53.000Z\",\"receiptNumber\":\"A000813\",\"lineItems\":[{\"productCode\":5,\"description\":\"Sin Plomo 95\",\"regularSellPrice\":1.699,\"actualSalesPrice\":1.499,\"unitPriceDiscount\":0.2,\"discountRate\":0,\"salesQuantity\":45.00294,\"salesAmount\":76.46,\"discountAmount\":9,\"taxItem\":{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":55.75,\"taxCollectedAmount\":11.71}}],\"transactionSummary\":{\"transactionTotalGrossAmount\":63.19,\"transactionTotalNetAmount\":55.75,\"transactionTotalTaxSalesAmount\":11.71,\"transactionTotalAmount\":67.46,\"taxItems\":[{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":55.75,\"taxCollectedAmount\":11.71}]},\"remarks1\":\"\",\"remarks2\":\"En el precio por litro de carburante se ha aplicado la bonificaci\\u00f3n establecida en el RDL 6\\/2022\",\"remarks3\":\"\"},\"dispensedQuantity\":45.00294,\"dispensedPrice\":1.479,\"dispensedAmount\":66.56}', 1.499, 'B66099441'),
(110039, '7174887265', 4514, 12966, 13303, 91, 1, '82.37', 'ANDROID_APP', 'PRO', '2022-09-08 19:00:08', 'Xiaomi', 'Redmi Note 9 Pro', '', '1.2.20', 'f5VVgJaRROI:APA91bHhOcxeWbevNLPLXCRH1pUyMSpOI', 'ANDROID', '11', '', '9.93', '{\"vendor\":{\"taxID\":\"B86591021\",\"companyName\":\"PUNTOS BAJO COSTE S.L.\",\"companyAddress\":\"C\\/ Juan Bravo n\\u00ba3\",\"companyCity\":\"MADRID\",\"companyState\":\"MADRID\",\"companyCountry\":\"ES\",\"siteName\":\"SBC CAMBADOS\",\"siteAddress\":\"Lg. As Laxes s\\/n - Corbillon\",\"siteCity\":\"CAMBADOS\",\"siteState\":\"PONTEVEDRA\",\"siteCountry\":\"ES\"},\"customer\":{\"taxID\":\"44076538M\",\"name\":\"FERNANDEZ LOPEZ PABLO\",\"address\":\"Pazos n\\u00ba 60A\",\"city\":\"MARCON (SAN MIGUEL)\",\"state\":\"PONTEVEDRA\",\"country\":\"ES\",\"zipCode\":\"36158\"},\"receiptDate\":\"2022-09-08T06:59:10.236Z\",\"receiptNumber\":\"SFAC000110\",\"billNumber\":\"22FSFK000026\",\"lineItems\":[{\"productCode\":1,\"description\":\"Gas\\u00f3leo A\",\"regularSellPrice\":1.859,\"actualSalesPrice\":1.659,\"unitPriceDiscount\":0.2,\"discountRate\":0,\"salesQuantity\":49.65035,\"salesAmount\":92.3,\"discountAmount\":9.93,\"taxItem\":{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":68.07,\"taxCollectedAmount\":14.3}}],\"payments\":[{\"paymentMethod\":\"Smart Fuel\",\"amount\":82.37}],\"promotionReward\":{\"discountCardNumber\":null,\"pointsCardNumber\":null,\"rewardedPointsQuantity\":0},\"transactionSummary\":{\"transactionTotalGrossAmount\":76.28,\"transactionTotalNetAmount\":68.07,\"transactionTotalTaxSalesAmount\":14.3,\"transactionTotalAmount\":82.37,\"taxItems\":[{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":68.07,\"taxCollectedAmount\":14.3}]},\"remarks1\":\"\",\"remarks2\":\"En el precio por litro de carburante se ha aplicado la bonificaci\\u00f3n establecida en el RDL 6\\/2022\",\"remarks3\":\"\"}', 0, ''),
(110040, '9839199367', 4512, 119, 62, 23, 1, '78.58', 'IPHONE_APP', 'PRO', '2022-09-08 19:25:02', 'Apple', 'iPhone', '', '1.3.2', 'e3fEbGK3mkIMuEGsOIH8li:APA91bGR8-A64dKvTGx99C', 'iOS', '15.6.1', '', '10.98', '{\"transactionID\":\"9839199367\",\"status\":300,\"transactionDocument\":{\"vendor\":{\"taxID\":\"B66119082\",\"companyName\":\"PETROLIS INDEPENDENTS S.L.\",\"companyAddress\":\"C\\/ Colom 389\",\"companyCity\":\"TERRASSA\",\"companyState\":\"BARCELONA\",\"companyCountry\":\"ES\",\"siteName\":\"E.S. CENTELLES\",\"siteAddress\":\"Av. Ildefons Cerda, 121\",\"siteCity\":\"CENTELLES\",\"siteState\":\"BARCELONA\",\"siteCountry\":\"ES\"},\"customer\":{\"taxID\":\"B66843194\",\"name\":\"Cr\\u00e8dit Smart Fuel\",\"address\":\"Rbla. Catalunya 116, 2\\u00ba, 5\\u00aa\",\"city\":\"BARCELONA\",\"state\":\"BARCELONA\",\"country\":\"ES\",\"zipCode\":\"08008\"},\"receiptDate\":\"2022-09-08T07:24:07.947Z\",\"receiptNumber\":\"AVC005034\",\"lineItems\":[{\"productCode\":1,\"description\":\"Gasoil A  \",\"regularSellPrice\":1.794,\"actualSalesPrice\":1.594,\"unitPriceDiscount\":0.2,\"discountRate\":0,\"salesQuantity\":49.92196,\"salesAmount\":89.56,\"discountAmount\":9.98,\"taxItem\":{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":65.77,\"taxCollectedAmount\":13.81}}],\"transactionSummary\":{\"transactionTotalGrossAmount\":74.02,\"transactionTotalNetAmount\":65.77,\"transactionTotalTaxSalesAmount\":13.81,\"transactionTotalAmount\":79.58,\"taxItems\":[{\"taxName\":\"Normal\",\"taxRate\":21,\"taxBaseAmount\":65.77,\"taxCollectedAmount\":13.81}]},\"remarks1\":\"\",\"remarks2\":\"(Blob)\",\"remarks3\":\"\"},\"dispensedQuantity\":49.92196,\"dispensedPrice\":1.574,\"dispensedAmount\":78.58}', 1.594, 'B66119082'),

(13287, '2021-06-02 14:49:02', '21FV00013286', '490', '46595534H', 'España', 'Barcelona', 'Aiguafreda', 'C/Abadessa Emma 25 B', '08591', 3.47, 21, 0.237373, 20, 79713, '5922715935', 'Sergio Caler Lozano', '', 'B66843194', 'Crèdit Smart Fuel', 'Rbla. Catalunya 116, 2º, 5ª', 'BARCELONA', 'BARCELONA', 'ES', '08008', 'B66119082', 'PETROLIS INDEPENDENTS S.L.', 'C/ Colom 389', 'TERRASSA', 'BARCELONA', 'ES', 'E.S. CENTELLES', 'Av. Ildefons Cerda, 121', 'CENTELLES', 'BARCELONA', 'ES', 15.8249, 1.264, 20, 0.015),
(13288, '2021-06-02 15:12:02', '21FV00013287', '2916', '46454500c', '724', 'Barcelona', 'Sant Fost De Campsentelles', 'Carrer Major, 1-E', '08105', 10.65, 21, 0.22845, 61.36, 79715, '9372837963', 'Oriol Jara', '', 'B66843194', 'Smart Fuel Technologies, S.L.', 'Rbla. Catalunya 116, 2º, 5ª', 'BARCELONA', 'BARCELONA', 'ES', '08008', 'B60287935', 'E.S. SANT FOST,S.L.', 'Ctra. de la Roca km 11,6 ', 'Sant Fost de Campsentelles', 'Barcelona', 'ES', 'E.S. SANT FOST,S.L.', 'Ctra. de la Roca km 11,6', 'Sant Fost Campsentelles', 'Barcelona', 'ES', 45.6899, 1.343, 61.36, 0.005),
(13289, '2021-06-02 17:30:02', '21FV00013288', '7318', '', '724', 'Barcelona', 'Mollet Del Vallés', 'Girona 16', '08100', 2.08, 21, 0.150869, 12, 79719, '6669982831', 'Bryan', '', 'B66843194', 'Smart Fuel Technologies S.L.', 'Rbla. Catalunya, 116, 5º, 2ª', 'BARCELONA', 'BARCELONA', 'ES', '08008', 'B66099441', 'GOOD PRICE PALAU S.L', 'Menorca, 7', 'PALAU DE PLEGAMANS', 'BARCELONA', 'ES', 'GP GOOD PRICE', 'Av. Badalona 22', 'Mollet del Vallés', 'Barcelona', 'ES', 10.058, 1.193, 12, 0.015),
(13290, '2021-06-02 18:07:02', '21FV00013289', '7902', NULL, 'España', 'Girona', 'lloret de Mar', 'Vila de Blanes 156, eso 12 p 1-4', '17310', 5.34, 21, 0.248199, 30.75, 79723, '9752325796', 'Cristian Macias', '', 'B66843194', 'SMART FUEL TECHNOLOGIES, S.L.', 'Rbla. Catalunya 116, 2n, 5ª', 'BARCELONA', 'BARCELONA', 'ES', '08008', 'A08921462', 'FEIXAS AULET, S.A.', 'C/ Bac de Roda 52', 'Roda de Ter', 'Barcelona', 'ES', 'ZONA DIESEL PALAFOLLS', '', 'PALAFOLLS', 'BARCELONA', 'ES', 24.8199, 1.239, 30.75, 0.01),
(13291, '2021-06-02 18:47:03', '21FV00013290', '6106', NULL, 'España', 'Barcelona', 'Santa Coloma de Gramenet', 'Carretera Font de l’Alzina 115', '08924', 1.3, 21, 0.0272133, 7.47, 79728, '4715917139', 'Isuma', '', 'B66843194', 'Smart Fuel Technologies, S.L.', 'Rbla. Catalunya 116, 2º, 5ª', 'BARCELONA', 'BARCELONA', 'ES', '08008', 'B66534371', 'VILACARBURANTS, S.L.', 'Bac de Roda, 140bis, 1.1', 'BARCELONA', 'BARCELONA', 'ES', '**CAN ZAM oil**', 'Avgda Francesc Macià, 226', 'STA COLOMA DE GRAMENET', 'BARCELONA', 'ES', 5.44267, 1.373, 7.47, 0.005),
(13292, '2021-06-02 19:33:03', '21FV00013291', '4308', '', '724', 'Barcelona', 'Sant Vicenç Dels Horts', 'Jacinto Verdaguer 88', '08620', 5.21, 21, 0.11505, 30, 79730, '3665353986', 'Oskkarito', '', 'B66843194', 'Cliente Crédito Smartfuel', 'Rbla. Catalunya 116, 2º, 5ª', 'Barcelona', 'Barcelona', 'ES', '08008', 'B65674293', 'EXPRESS SUMINISTRO GASOLEO, S.L.', 'Ctra de Torrelles Nº28', 'Sant Vicenç dels Horts', 'Barcelona', '', 'EXPRESS SANT VICENÇ', 'Ctra TORRELLES BV 2005 nº28', 'SANT VICENÇ DELS HORTS', 'BARCELONA', '', 23.0099, 1.304, 30, 0.005),
(13293, '2021-06-02 20:10:02', '21FV00013292', '4406', '', '724', 'Bizkaia', 'Ermua', 'Komentukua Kalea, 2', '48260', 10.36, 21, 0.534557, 59.71, 79734, '6619522328', 'Emi', '', 'B66843194', 'SMART FUEL TECHNOLOGIES S.L.', 'RBLA. CATALUNYA Nº116, 2º ,5ª', 'BARCELONA', 'BARCELONA', 'ES', '08008', 'B95761805', 'Low Cost Euskadi SL', 'Barrio Salcedillo 39 C', 'Trapagarán', 'Bizkaia', '', 'E.S. BERRIZ', 'Barrio Salcedillo 39C', 'VALLE DE TRAPAGA-TRAPAGARAN', 'VIZCAYA', 'ES', 53.4557, 1.117, 59.71, 0.01),
(13294, '2021-06-02 21:20:02', '21FV00013293', '11047', '', '724', 'Cadiz', 'Cádiz', 'Avenida Segunda Aguada 13 3°C', '11012', 1.72, 21, 0.112867, 9.89, 79737, '4611595132', 'Emilio Gavira', '', 'B66843194', 'Cliente Crédito Smartfuel', 'Rbla. Catalunya 116, 2º, 5ª', 'BARCELONA', 'BARCELONA', 'ES', '08008', 'B11851870', 'E.S. NTRA SRA DE LA SIERRA S.L.', 'C/ LOS ALMENDROS Nº 32', 'VILLAMARTIN', 'CADIZ', 'ES', 'E.S CADIZ', 'C/ Algeciras 4', 'CADIZ', 'CADIZ', 'ES', 7.52445, 1.314, 9.89, 0.015),

 
  • Post hidden due to user being banned.
Amazing, thanks so much! Whoever seeks will always find, thanks for sharing info, bro!
 

Users who are viewing this thread

Home Register
Top Bottom