(13107,'2026-04-06',2,0.00,0.00,912.00,912.00,15.650000,10,'Carburant',1212,1),(13108,'2026-04-06',3,0.00,0.00,310.00,310.00,15.250000,10,'Carburant',1212,1),(13109,'2026-04-06',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1212,1),(13110,'2026-04-07',1,0.00,0.00,5141.00,5141.00,14.650000,10,'Carburant',1213,1),(13111,'2026-04-07',2,0.00,0.00,843.00,843.00,15.650000,10,'Carburant',1213,1),(13112,'2026-04-07',3,0.00,0.00,592.00,592.00,15.250000,10,'Carburant',1213,1),(13113,'2026-04-07',109,0.00,0.00,8.60,8.60,12.500000,20,'Carburant',1213,1),(13114,'2026-04-08',1,0.00,0.00,6348.00,6348.00,14.650000,10,'Carburant',1214,1),(13115,'2026-04-08',2,0.00,0.00,827.00,827.00,15.650000,10,'Carburant',1214,1),(13116,'2026-04-08',3,0.00,0.00,395.00,395.00,15.250000,10,'Carburant',1214,1),(13117,'2026-04-08',109,0.00,0.00,17.10,17.10,12.500000,20,'Carburant',1214,1),(13118,'2026-04-09',2,4000.00,4000.00,0.00,0.00,13.682700,10,'Alimentation',511,1),(13119,'2026-04-09',1,0.00,0.00,7364.00,7364.00,14.650000,10,'Carburant',1215,1),(13120,'2026-04-09',2,0.00,0.00,873.00,873.00,15.650000,10,'Carburant',1215,1),(13121,'2026-04-09',3,0.00,0.00,520.00,520.00,15.250000,10,'Carburant',1215,1),(13122,'2026-04-09',109,0.00,0.00,8.10,8.10,12.500000,20,'Carburant',1215,1),(13130,'2026-04-10',1,0.00,0.00,5792.00,5792.00,14.650000,10,'Carburant',1216,1),(13129,'2026-04-10',2,0.00,0.00,691.00,691.00,15.650000,10,'Carburant',1216,1),(13128,'2026-04-10',3,0.00,0.00,435.00,435.00,15.250000,10,'Carburant',1216,1),(13127,'2026-04-10',109,0.00,0.00,19.00,19.00,12.500000,20,'Carburant',1216,1),(13131,'2026-04-11',1,0.00,0.00,6202.00,6202.00,14.650000,10,'Carburant',1217,1),(13132,'2026-04-11',2,0.00,0.00,768.00,768.00,15.650000,10,'Carburant',1217,1),(13133,'2026-04-11',3,0.00,0.00,315.00,315.00,15.250000,10,'Carburant',1217,1),(13134,'2026-04-11',109,0.00,0.00,1.60,1.60,12.500000,20,'Carburant',1217,1),(13135,'2026-04-12',1,0.00,0.00,3028.00,3028.00,14.650000,10,'Carburant',1218,1),(13136,'2026-04-12',2,0.00,0.00,661.00,661.00,15.650000,10,'Carburant',1218,1),(13137,'2026-04-12',3,0.00,0.00,396.00,396.00,15.250000,10,'Carburant',1218,1),(13138,'2026-04-12',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1218,1),(13139,'2026-04-13',1,33000.00,33000.00,0.00,0.00,12.818200,10,'Alimentation',512,1),(13151,'2026-04-13',1,0.00,0.00,7427.00,7427.00,14.650000,10,'Carburant',1219,1),(13150,'2026-04-13',2,0.00,0.00,762.00,762.00,15.650000,10,'Carburant',1219,1),(13149,'2026-04-13',3,0.00,0.00,552.00,552.00,15.250000,10,'Carburant',1219,1),(13148,'2026-04-13',109,0.00,0.00,59.30,59.30,12.500000,20,'Carburant',1219,1),(13152,'2026-04-14',1,0.00,0.00,4473.00,4473.00,14.650000,10,'Carburant',1220,1),(13153,'2026-04-14',2,0.00,0.00,879.00,879.00,15.650000,10,'Carburant',1220,1),(13154,'2026-04-14',3,0.00,0.00,397.00,397.00,15.250000,10,'Carburant',1220,1),(13155,'2026-04-14',109,0.00,0.00,34.50,34.50,12.500000,20,'Carburant',1220,1),(13156,'2026-04-14',1,0.00,0.00,663.00,0.00,0.000000,10,'Verification',1220,1),(13157,'2026-04-14',2,0.00,0.00,89.00,0.00,0.000000,10,'Verification',1220,1),(13158,'2026-04-14',3,0.00,0.00,273.00,0.00,0.000000,10,'Verification',1220,1),(13192,'2026-04-15',1,0.00,0.00,8142.00,8142.00,14.650000,10,'Carburant',1221,1),(13191,'2026-04-15',2,0.00,0.00,808.00,808.00,15.650000,10,'Carburant',1221,1),(13190,'2026-04-15',3,0.00,0.00,534.00,534.00,15.250000,10,'Carburant',1221,1),(13189,'2026-04-15',109,0.00,0.00,63.20,63.20,12.500000,20,'Carburant',1221,1),(13163,'2026-03-26',113,16.00,16.00,0.00,0.00,33.333333,20,'Alimentation',513,1),(13164,'2026-04-16',2,4000.00,4000.00,0.00,0.00,13.682700,10,'Alimentation',514,1),(13172,'2026-04-16',1,0.00,0.00,11771.00,11771.00,14.650000,10,'Carburant',1222,1),(13171,'2026-04-16',2,0.00,0.00,814.00,814.00,15.650000,10,'Carburant',1222,1),(13170,'2026-04-16',3,0.00,0.00,575.00,575.00,15.250000,10,'Carburant',1222,1),(13169,'2026-04-16',109,0.00,0.00,39.00,39.00,12.500000,20,'Carburant',1222,1),(13188,'2026-04-17',1,0.00,0.00,370.00,370.00,14.650000,10,'Carburant',1223,1),(13187,'2026-04-17',2,0.00,0.00,25.00,25.00,15.650000,10,'Carburant',1223,1),(13186,'2026-04-17',3,0.00,0.00,0.00,0.00,15.250000,10,'Carburant',1223,1),(13185,'2026-04-17',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1223,1),(13193,'2026-04-17',1,0.00,0.00,6680.00,6680.00,15.650000,10,'Carburant',1224,1),(13194,'2026-04-17',2,0.00,0.00,758.00,758.00,15.650000,10,'Carburant',1224,1),(13195,'2026-04-17',3,0.00,0.00,368.00,368.00,16.250000,10,'Carburant',1224,1),(13196,'2026-04-17',109,0.00,0.00,61.70,61.70,12.500000,20,'Carburant',1224,1),(13197,'2026-04-18',1,0.00,0.00,5398.00,5398.00,15.650000,10,'Carburant',1225,1),(13198,'2026-04-18',2,0.00,0.00,835.00,835.00,15.650000,10,'Carburant',1225,1),(13199,'2026-04-18',3,0.00,0.00,429.00,429.00,16.250000,10,'Carburant',1225,1),(13200,'2026-04-18',109,0.00,0.00,20.00,20.00,12.500000,20,'Carburant',1225,1),(13201,'2026-04-19',1,0.00,0.00,1665.00,1665.00,15.650000,10,'Carburant',1226,1),(13202,'2026-04-19',2,0.00,0.00,599.00,599.00,15.650000,10,'Carburant',1226,1),(13203,'2026-04-19',3,0.00,0.00,1423.00,1423.00,16.250000,10,'Carburant',1226,1),(13204,'2026-04-19',109,0.00,0.00,40.00,40.00,12.500000,20,'Carburant',1226,1),(13205,'2026-04-20',1,33000.00,33000.00,0.00,0.00,13.727300,10,'Alimentation',515,1),(13206,'2026-04-20',1,0.00,0.00,1942.00,1942.00,15.650000,10,'Carburant',1227,1),(13207,'2026-04-20',2,0.00,0.00,876.00,876.00,15.650000,10,'Carburant',1227,1),(13208,'2026-04-20',3,0.00,0.00,2746.00,2746.00,16.250000,10,'Carburant',1227,1),(13209,'2026-04-20',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1227,1),(13210,'2026-04-22',1,20000.00,20000.00,0.00,0.00,13.727300,10,'Alimentation',516,1),(13211,'2026-04-22',2,5000.00,5000.00,0.00,0.00,13.700900,10,'Alimentation',516,1),(13212,'2026-04-22',3,8000.00,8000.00,0.00,0.00,14.136400,10,'Alimentation',516,1),(13213,'2026-04-21',1,0.00,0.00,5349.00,5349.00,15.650000,10,'Carburant',1228,1),(13214,'2026-04-21',2,0.00,0.00,871.00,871.00,15.650000,10,'Carburant',1228,1),(13215,'2026-04-21',3,0.00,0.00,394.00,394.00,16.250000,10,'Carburant',1228,1),(13216,'2026-04-21',109,0.00,0.00,40.00,40.00,12.500000,20,'Carburant',1228,1),(13217,'2026-04-22',1,0.00,0.00,5182.00,5182.00,15.650000,10,'Carburant',1229,1),(13218,'2026-04-22',2,0.00,0.00,686.00,686.00,15.650000,10,'Carburant',1229,1),(13219,'2026-04-22',3,0.00,0.00,497.00,497.00,16.250000,10,'Carburant',1229,1),(13220,'2026-04-22',109,0.00,0.00,17.10,17.10,12.500000,20,'Carburant',1229,1),(13221,'2026-04-23',1,0.00,0.00,7830.00,7830.00,15.650000,10,'Carburant',1230,1),(13222,'2026-04-23',2,0.00,0.00,725.00,725.00,15.650000,10,'Carburant',1230,1),(13223,'2026-04-23',3,0.00,0.00,462.00,462.00,16.250000,10,'Carburant',1230,1),(13224,'2026-04-23',109,0.00,0.00,51.70,51.70,12.500000,20,'Carburant',1230,1),(13232,'2026-04-24',1,0.00,0.00,5974.00,5974.00,15.650000,10,'Carburant',1231,1),(13231,'2026-04-24',2,0.00,0.00,674.00,674.00,15.650000,10,'Carburant',1231,1),(13230,'2026-04-24',3,0.00,0.00,542.00,542.00,16.250000,10,'Carburant',1231,1),(13229,'2026-04-24',109,0.00,0.00,50.00,50.00,12.500000,20,'Carburant',1231,1),(13233,'2026-04-25',134,240.00,240.00,0.00,0.00,35.000000,20,'Alimentation',517,1),(13234,'2026-04-25',134,36.00,36.00,0.00,0.00,0.000000,20,'Alimentation',518,1),(13235,'2026-04-25',1,0.00,0.00,5812.00,5812.00,15.650000,10,'Carburant',1232,1),(13236,'2026-04-25',2,0.00,0.00,964.00,964.00,15.650000,10,'Carburant',1232,1),(13237,'2026-04-25',3,0.00,0.00,447.00,447.00,16.250000,10,'Carburant',1232,1),(13238,'2026-04-25',109,0.00,0.00,25.40,25.40,12.500000,20,'Carburant',1232,1),(13239,'2026-04-26',1,0.00,0.00,2867.00,2867.00,15.650000,10,'Carburant',1233,1),(13240,'2026-04-26',2,0.00,0.00,709.00,709.00,15.650000,10,'Carburant',1233,1),(13241,'2026-04-26',3,0.00,0.00,506.00,506.00,16.250000,10,'Carburant',1233,1),(13242,'2026-04-26',109,0.00,0.00,10.00,10.00,12.500000,20,'Carburant',1233,1),(13244,'2026-04-27',1,33000.00,33000.00,0.00,0.00,12.818200,10,'Alimentation',519,1),(13245,'2026-04-27',1,0.00,0.00,8262.00,8262.00,15.650000,10,'Carburant',1234,1),(13246,'2026-04-27',2,0.00,0.00,836.00,836.00,15.650000,10,'Carburant',1234,1),(13247,'2026-04-27',3,0.00,0.00,420.00,420.00,16.250000,10,'Carburant',1234,1),(13248,'2026-04-27',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1234,1),(13249,'2026-04-28',111,3000.00,3000.00,0.00,0.00,13.636364,10,'Alimentation',521,1),(13250,'2026-04-28',1,0.00,0.00,4369.00,4369.00,15.650000,10,'Carburant',1235,1),(13251,'2026-04-28',2,0.00,0.00,558.00,558.00,15.650000,10,'Carburant',1235,1),(13252,'2026-04-28',3,0.00,0.00,308.00,308.00,16.250000,10,'Carburant',1235,1),(13253,'2026-04-28',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1235,1),(13254,'2026-04-29',1,0.00,0.00,4796.00,4796.00,15.650000,10,'Carburant',1236,1),(13255,'2026-04-29',2,0.00,0.00,903.00,903.00,15.650000,10,'Carburant',1236,1),(13256,'2026-04-29',3,0.00,0.00,726.00,726.00,16.250000,10,'Carburant',1236,1),(13257,'2026-04-29',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1236,1),(13258,'2026-04-30',2,3000.00,3000.00,0.00,0.00,13.700900,10,'Alimentation',522,1),(13266,'2026-04-30',1,0.00,0.00,5433.00,5433.00,15.650000,10,'Carburant',1237,1),(13265,'2026-04-30',2,0.00,0.00,653.00,653.00,15.650000,10,'Carburant',1237,1),(13264,'2026-04-30',3,0.00,0.00,518.00,518.00,16.250000,10,'Carburant',1237,1),(13263,'2026-04-30',109,0.00,0.00,20.00,20.00,12.500000,20,'Carburant',1237,1),(13267,'2026-05-01',1,0.00,0.00,5113.00,5113.00,15.650000,10,'Carburant',1238,1),(13268,'2026-05-01',2,0.00,0.00,918.00,918.00,15.650000,10,'Carburant',1238,1),(13269,'2026-05-01',3,0.00,0.00,559.00,559.00,16.250000,10,'Carburant',1238,1),(13270,'2026-05-01',109,0.00,0.00,16.20,16.20,12.500000,20,'Carburant',1238,1),(13271,'2026-05-02',1,0.00,0.00,4416.00,4416.00,15.650000,10,'Carburant',1239,1),(13272,'2026-05-02',2,0.00,0.00,1064.00,1064.00,15.650000,10,'Carburant',1239,1),(13273,'2026-05-02',3,0.00,0.00,475.00,475.00,16.250000,10,'Carburant',1239,1),(13274,'2026-05-02',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1239,1),(13282,'2026-05-03',1,0.00,0.00,2956.00,2956.00,15.650000,10,'Carburant',1240,1),(13281,'2026-05-03',2,0.00,0.00,723.00,723.00,15.650000,10,'Carburant',1240,1),(13280,'2026-05-03',3,0.00,0.00,225.00,225.00,16.250000,10,'Carburant',1240,1),(13279,'2026-05-03',109,0.00,0.00,7.00,7.00,12.500000,20,'Carburant',1240,1),(13283,'2026-05-04',1,0.00,0.00,6773.00,6773.00,14.640000,10,'Carburant',1241,1),(13284,'2026-05-04',2,0.00,0.00,567.00,567.00,14.990000,10,'Carburant',1241,1),(13285,'2026-05-04',3,0.00,0.00,586.00,586.00,15.240000,10,'Carburant',1241,1),(13286,'2026-05-04',109,0.00,0.00,12.60,12.60,12.500000,20,'Carburant',1241,1),(13287,'2026-05-05',1,24000.00,24000.00,0.00,0.00,12.818200,10,'Alimentation',524,1),(13288,'2026-05-05',2,6000.00,6000.00,0.00,0.00,12.700900,10,'Alimentation',524,1),(13289,'2026-05-05',3,3000.00,3000.00,0.00,0.00,13.227300,10,'Alimentation',524,1),(13290,'2026-05-05',1,0.00,0.00,6834.00,6834.00,14.640000,10,'Carburant',1242,1),(13291,'2026-05-05',2,0.00,0.00,558.00,558.00,14.990000,10,'Carburant',1242,1),(13292,'2026-05-05',3,0.00,0.00,439.00,439.00,15.240000,10,'Carburant',1242,1),(13293,'2026-05-05',109,0.00,0.00,168.30,168.30,12.500000,20,'Carburant',1242,1),(13294,'2026-05-06',1,0.00,0.00,7314.00,7314.00,14.640000,10,'Carburant',1243,1),(13295,'2026-05-06',2,0.00,0.00,760.00,760.00,14.990000,10,'Carburant',1243,1),(13296,'2026-05-06',3,0.00,0.00,758.00,758.00,15.240000,10,'Carburant',1243,1),(13297,'2026-05-06',109,0.00,0.00,83.80,83.80,12.500000,20,'Carburant',1243,1),(13298,'2026-05-06',1,0.00,415.00,0.00,0.00,0.000000,10,'Verification',1243,1),(13299,'2026-05-06',2,0.00,65.00,0.00,0.00,0.000000,10,'Verification',1243,1),(13300,'2026-05-06',3,0.00,0.00,22.00,0.00,0.000000,10,'Verification',1243,1),(13304,'2026-05-07',2,3000.00,3000.00,0.00,0.00,12.700900,10,'Alimentation',525,1),(13303,'2026-05-07',1,30000.00,30000.00,0.00,0.00,12.818200,10,'Alimentation',525,1),(13305,'2026-05-07',1,0.00,0.00,5245.00,5245.00,14.640000,10,'Carburant',1244,1),(13306,'2026-05-07',2,0.00,0.00,837.00,837.00,14.990000,10,'Carburant',1244,1),(13307,'2026-05-07',3,0.00,0.00,211.00,211.00,15.240000,10,'Carburant',1244,1),(13308,'2026-05-07',109,0.00,0.00,4.10,4.10,12.500000,20,'Carburant',1244,1),(13309,'2026-05-08',1,0.00,0.00,6356.00,6356.00,14.640000,10,'Carburant',1245,1),(13310,'2026-05-08',2,0.00,0.00,751.00,751.00,14.990000,10,'Carburant',1245,1),(13311,'2026-05-08',3,0.00,0.00,575.00,575.00,15.240000,10,'Carburant',1245,1),(13312,'2026-05-08',109,0.00,0.00,18.90,18.90,12.500000,20,'Carburant',1245,1),(13313,'2026-05-09',1,0.00,0.00,4710.00,4710.00,14.640000,10,'Carburant',1246,1),(13314,'2026-05-09',2,0.00,0.00,693.00,693.00,14.990000,10,'Carburant',1246,1),(13315,'2026-05-09',3,0.00,0.00,409.00,409.00,15.240000,10,'Carburant',1246,1),(13316,'2026-05-09',109,0.00,0.00,17.10,17.10,12.500000,20,'Carburant',1246,1),(13317,'2026-05-10',1,0.00,0.00,3342.00,3342.00,14.640000,10,'Carburant',1247,1),(13318,'2026-05-10',2,0.00,0.00,904.00,904.00,14.990000,10,'Carburant',1247,1),(13319,'2026-05-10',3,0.00,0.00,202.00,202.00,15.240000,10,'Carburant',1247,1),(13320,'2026-05-10',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1247,1),(13321,'2026-05-11',1,0.00,0.00,6546.00,6546.00,14.640000,10,'Carburant',1248,1),(13322,'2026-05-11',2,0.00,0.00,750.00,750.00,14.990000,10,'Carburant',1248,1),(13323,'2026-05-11',3,0.00,0.00,599.00,599.00,15.240000,10,'Carburant',1248,1),(13324,'2026-05-11',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1248,1),(13325,'2026-05-12',1,26000.00,26000.00,0.00,0.00,12.818200,10,'Alimentation',526,1),(13326,'2026-05-12',2,4000.00,4000.00,0.00,0.00,12.700900,10,'Alimentation',526,1),(13327,'2026-05-12',3,3000.00,3000.00,0.00,0.00,13.227300,10,'Alimentation',526,1),(13328,'2026-05-12',1,0.00,0.00,6222.00,6222.00,14.640000,10,'Carburant',1249,1),(13329,'2026-05-12',2,0.00,0.00,732.00,732.00,14.990000,10,'Carburant',1249,1),(13330,'2026-05-12',3,0.00,0.00,665.00,665.00,15.240000,10,'Carburant',1249,1),(13331,'2026-05-12',109,0.00,0.00,40.00,40.00,12.500000,20,'Carburant',1249,1),(13358,'2026-05-13',1,0.00,0.00,4807.00,4807.00,14.640000,10,'Carburant',1250,1),(13357,'2026-05-13',2,0.00,0.00,754.00,754.00,14.990000,10,'Carburant',1250,1),(13356,'2026-05-13',3,0.00,0.00,326.00,326.00,15.240000,10,'Carburant',1250,1),(13355,'2026-05-13',109,0.00,0.00,56.80,56.80,12.500000,20,'Carburant',1250,1),(13336,'2026-05-14',1,0.00,0.00,6174.00,6174.00,14.640000,10,'Carburant',1251,1),(13337,'2026-05-14',2,0.00,0.00,564.00,564.00,14.990000,10,'Carburant',1251,1),(13338,'2026-05-14',3,0.00,0.00,417.00,417.00,15.240000,10,'Carburant',1251,1),(13339,'2026-05-14',109,0.00,0.00,31.10,31.10,12.500000,20,'Carburant',1251,1),(13340,'2026-05-15',1,0.00,0.00,4885.00,4885.00,14.640000,10,'Carburant',1252,1),(13341,'2026-05-15',2,0.00,0.00,636.00,636.00,14.990000,10,'Carburant',1252,1),(13342,'2026-05-15',3,0.00,0.00,443.00,443.00,15.240000,10,'Carburant',1252,1),(13343,'2026-05-15',109,0.00,0.00,46.20,46.20,12.500000,20,'Carburant',1252,1),(13344,'2026-05-16',1,0.00,0.00,6240.00,6240.00,14.640000,10,'Carburant',1253,1),(13345,'2026-05-16',2,0.00,0.00,1139.00,1139.00,14.990000,10,'Carburant',1253,1),(13346,'2026-05-16',3,0.00,0.00,595.00,595.00,15.240000,10,'Carburant',1253,1),(13347,'2026-05-16',109,0.00,0.00,21.50,21.50,12.500000,20,'Carburant',1253,1),(13348,'2026-05-17',1,0.00,0.00,5114.00,5114.00,14.640000,10,'Carburant',1254,1),(13349,'2026-05-17',2,0.00,0.00,679.00,679.00,15.040000,10,'Carburant',1254,1),(13350,'2026-05-17',3,0.00,0.00,406.00,406.00,15.240000,10,'Carburant',1254,1),(13351,'2026-05-17',109,0.00,0.00,108.20,108.20,12.500000,20,'Carburant',1254,1),(13352,'2026-05-18',1,26000.00,26000.00,0.00,0.00,12.818200,10,'Alimentation',527,1),(13353,'2026-05-18',2,4000.00,4000.00,0.00,0.00,12.700900,10,'Alimentation',527,1),(13354,'2026-05-18',3,3000.00,3000.00,0.00,0.00,13.227300,10,'Alimentation',527,1),(13359,'2026-05-18',1,0.00,0.00,5506.00,5506.00,14.640000,10,'Carburant',1255,1),(13360,'2026-05-18',2,0.00,0.00,827.00,827.00,15.040000,10,'Carburant',1255,1),(13361,'2026-05-18',3,0.00,0.00,371.00,371.00,15.240000,10,'Carburant',1255,1),(13362,'2026-05-18',109,0.00,0.00,38.10,38.10,12.500000,20,'Carburant',1255,1),(13363,'2026-05-19',1,0.00,0.00,6713.00,6713.00,14.640000,10,'Carburant',1256,1),(13364,'2026-05-19',2,0.00,0.00,1100.00,1100.00,15.040000,10,'Carburant',1256,1),(13365,'2026-05-19',3,0.00,0.00,222.00,222.00,15.240000,10,'Carburant',1256,1),(13366,'2026-05-19',109,0.00,0.00,216.50,216.50,12.500000,20,'Carburant',1256,1),(13367,'2026-05-20',1,0.00,0.00,5729.00,5729.00,14.640000,10,'Carburant',1257,1),(13368,'2026-05-20',2,0.00,0.00,918.00,918.00,15.040000,10,'Carburant',1257,1),(13369,'2026-05-20',3,0.00,0.00,450.00,450.00,15.240000,10,'Carburant',1257,1),(13370,'2026-05-20',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1257,1),(13371,'2026-05-21',1,26000.00,26000.00,0.00,0.00,12.818200,10,'Alimentation',528,1),(13372,'2026-05-21',2,4000.00,4000.00,0.00,0.00,13.155400,10,'Alimentation',528,1),(13373,'2026-05-21',3,3000.00,3000.00,0.00,0.00,13.227300,10,'Alimentation',528,1),(13374,'2026-05-21',1,0.00,0.00,5672.00,5672.00,14.640000,10,'Carburant',1258,1),(13375,'2026-05-21',2,0.00,0.00,940.00,940.00,15.040000,10,'Carburant',1258,1),(13376,'2026-05-21',3,0.00,0.00,394.00,394.00,15.240000,10,'Carburant',1258,1),(13377,'2026-05-21',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1258,1),(13378,'2026-05-22',1,0.00,0.00,5554.00,5554.00,14.640000,10,'Carburant',1259,1),(13379,'2026-05-22',2,0.00,0.00,824.00,824.00,15.040000,10,'Carburant',1259,1),(13380,'2026-05-22',3,0.00,0.00,446.00,446.00,15.240000,10,'Carburant',1259,1),(13381,'2026-05-22',109,0.00,0.00,60.50,60.50,12.500000,20,'Carburant',1259,1),(13382,'2026-05-23',1,0.00,0.00,5761.00,5761.00,14.640000,10,'Carburant',1260,1),(13383,'2026-05-23',2,0.00,0.00,969.00,969.00,15.040000,10,'Carburant',1260,1),(13384,'2026-05-23',3,0.00,0.00,515.00,515.00,15.240000,10,'Carburant',1260,1),(13385,'2026-05-23',109,0.00,0.00,11.60,11.60,12.500000,20,'Carburant',1260,1),(13386,'2026-05-24',1,0.00,0.00,4464.00,4464.00,14.640000,10,'Carburant',1261,1),(13387,'2026-05-24',2,0.00,0.00,1034.00,1034.00,15.040000,10,'Carburant',1261,1),(13388,'2026-05-24',3,0.00,0.00,582.00,582.00,15.240000,10,'Carburant',1261,1),(13389,'2026-05-24',109,0.00,0.00,32.60,32.60,12.500000,20,'Carburant',1261,1),(13390,'2026-05-25',1,26000.00,26000.00,0.00,0.00,12.818200,10,'Alimentation',529,1),(13391,'2026-05-25',2,4000.00,4000.00,0.00,0.00,13.155400,10,'Alimentation',529,1),(13392,'2026-05-25',3,3000.00,3000.00,0.00,0.00,13.227300,10,'Alimentation',529,1),(13393,'2026-05-25',1,0.00,0.00,6973.00,6973.00,14.640000,10,'Carburant',1262,1),(13394,'2026-05-25',2,0.00,0.00,1238.00,1238.00,15.040000,10,'Carburant',1262,1),(13395,'2026-05-25',3,0.00,0.00,502.00,502.00,15.240000,10,'Carburant',1262,1),(13396,'2026-05-25',109,0.00,0.00,28.30,28.30,12.500000,20,'Carburant',1262,1),(13407,'2026-05-26',1,0.00,0.00,4983.00,4983.00,14.640000,10,'Carburant',1263,1),(13406,'2026-05-26',2,0.00,0.00,1247.00,1247.00,15.040000,10,'Carburant',1263,1),(13405,'2026-05-26',3,0.00,0.00,332.00,332.00,15.240000,10,'Carburant',1263,1),(13404,'2026-05-26',109,0.00,0.00,19.50,19.50,12.500000,20,'Carburant',1263,1),(13401,'2026-05-26',1,0.00,1581.00,0.00,0.00,0.000000,10,'Verification',1263,1),(13402,'2026-05-26',2,0.00,0.00,160.00,0.00,0.000000,10,'Verification',1263,1),(13403,'2026-05-26',3,0.00,32.00,0.00,0.00,0.000000,10,'Verification',1263,1),(13419,'2026-05-27',1,0.00,0.00,1071.00,1071.00,14.640000,10,'Carburant',1264,1),(13418,'2026-05-27',2,0.00,0.00,521.00,521.00,15.040000,10,'Carburant',1264,1),(13417,'2026-05-27',3,0.00,0.00,155.00,155.00,15.240000,10,'Carburant',1264,1),(13416,'2026-05-27',109,0.00,0.00,52.10,52.10,12.500000,20,'Carburant',1264,1),(13427,'2026-05-28',1,0.00,0.00,3666.00,3666.00,14.640000,10,'Carburant',1265,1),(13426,'2026-05-28',2,0.00,0.00,691.00,691.00,15.040000,10,'Carburant',1265,1),(13425,'2026-05-28',3,0.00,0.00,269.00,269.00,15.240000,10,'Carburant',1265,1),(13424,'2026-05-28',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1265,1),(13428,'2026-05-29',1,0.00,0.00,2368.00,2368.00,14.640000,10,'Carburant',1266,1),(13429,'2026-05-29',2,0.00,0.00,710.00,710.00,15.040000,10,'Carburant',1266,1),(13430,'2026-05-29',3,0.00,0.00,222.00,222.00,15.240000,10,'Carburant',1266,1),(13431,'2026-05-29',109,0.00,0.00,12.30,12.30,12.500000,20,'Carburant',1266,1),(13432,'2026-05-30',1,0.00,0.00,4235.00,4235.00,14.640000,10,'Carburant',1267,1),(13433,'2026-05-30',2,0.00,0.00,1032.00,1032.00,15.040000,10,'Carburant',1267,1),(13434,'2026-05-30',3,0.00,0.00,497.00,497.00,15.240000,10,'Carburant',1267,1),(13435,'2026-05-30',109,0.00,0.00,4.00,4.00,12.500000,20,'Carburant',1267,1),(13436,'2026-05-31',1,0.00,0.00,3160.00,3160.00,14.640000,10,'Carburant',1268,1),(13437,'2026-05-31',2,0.00,0.00,611.00,611.00,15.040000,10,'Carburant',1268,1),(13438,'2026-05-31',3,0.00,0.00,244.00,244.00,15.240000,10,'Carburant',1268,1),(13439,'2026-05-31',109,0.00,0.00,5.00,5.00,12.500000,20,'Carburant',1268,1),(13440,'2026-06-01',111,3000.00,3000.00,0.00,0.00,12.454545,10,'Alimentation',532,1),(13441,'2026-06-01',1,0.00,0.00,7795.00,7795.00,14.640000,10,'Carburant',1269,1),(13442,'2026-06-01',2,0.00,0.00,1206.00,1206.00,15.040000,10,'Carburant',1269,1),(13443,'2026-06-01',3,0.00,0.00,418.00,418.00,15.240000,10,'Carburant',1269,1),(13444,'2026-06-01',109,0.00,0.00,13.60,13.60,12.500000,20,'Carburant',1269,1),(13445,'2026-06-02',2,7000.00,7000.00,0.00,0.00,13.155400,10,'Alimentation',533,1),(13446,'2026-06-02',1,26000.00,26000.00,0.00,0.00,12.336400,10,'Alimentation',533,1),(13447,'2026-06-02',1,0.00,0.00,5762.00,5762.00,14.640000,10,'Carburant',1270,1),(13448,'2026-06-02',2,0.00,0.00,1265.00,1265.00,15.040000,10,'Carburant',1270,1),(13449,'2026-06-02',3,0.00,0.00,285.00,285.00,15.240000,10,'Carburant',1270,1),(13450,'2026-06-02',109,0.00,0.00,4.80,4.80,12.500000,20,'Carburant',1270,1),(13451,'2026-06-03',1,0.00,0.00,7269.00,7269.00,14.640000,10,'Carburant',1271,1),(13452,'2026-06-03',2,0.00,0.00,873.00,873.00,15.190000,10,'Carburant',1271,1),(13453,'2026-06-03',3,0.00,0.00,227.00,227.00,15.240000,10,'Carburant',1271,1),(13454,'2026-06-03',109,0.00,0.00,65.90,65.90,12.500000,20,'Carburant',1271,1),(13455,'2026-06-04',1,0.00,0.00,5083.00,5083.00,14.640000,10,'Carburant',1272,1),(13456,'2026-06-04',2,0.00,0.00,754.00,754.00,15.190000,10,'Carburant',1272,1),(13457,'2026-06-04',3,0.00,0.00,670.00,670.00,15.240000,10,'Carburant',1272,1),(13458,'2026-06-04',109,0.00,0.00,55.40,55.40,12.500000,20,'Carburant',1272,1),(13459,'2026-06-05',1,0.00,0.00,4999.00,4999.00,14.640000,10,'Carburant',1273,1),(13460,'2026-06-05',2,0.00,0.00,674.00,674.00,15.190000,10,'Carburant',1273,1),(13461,'2026-06-05',3,0.00,0.00,477.00,477.00,15.240000,10,'Carburant',1273,1),(13462,'2026-06-05',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1273,1),(13463,'2026-06-06',1,0.00,0.00,4204.00,4204.00,14.640000,10,'Carburant',1274,1),(13464,'2026-06-06',2,0.00,0.00,718.00,718.00,15.190000,10,'Carburant',1274,1),(13465,'2026-06-06',3,0.00,0.00,608.00,608.00,15.240000,10,'Carburant',1274,1),(13466,'2026-06-06',109,0.00,0.00,25.10,25.10,12.500000,20,'Carburant',1274,1),(13467,'2026-06-07',1,0.00,0.00,3030.00,3030.00,14.640000,10,'Carburant',1275,1),(13468,'2026-06-07',2,0.00,0.00,790.00,790.00,15.190000,10,'Carburant',1275,1),(13469,'2026-06-07',3,0.00,0.00,225.00,225.00,15.240000,10,'Carburant',1275,1),(13470,'2026-06-07',109,0.00,0.00,7.20,7.20,12.500000,20,'Carburant',1275,1),(13471,'2026-06-08',1,26000.00,26000.00,0.00,0.00,12.336400,10,'Alimentation',534,1),(13472,'2026-06-08',2,4000.00,4000.00,0.00,0.00,13.155400,10,'Alimentation',534,1),(13473,'2026-06-08',3,3000.00,3000.00,0.00,0.00,12.745500,10,'Alimentation',534,1),(13474,'2026-06-08',1,0.00,0.00,6339.00,6339.00,14.640000,10,'Carburant',1276,1),(13475,'2026-06-08',2,0.00,0.00,805.00,805.00,15.190000,10,'Carburant',1276,1),(13476,'2026-06-08',3,0.00,0.00,349.00,349.00,15.240000,10,'Carburant',1276,1),(13477,'2026-06-08',109,0.00,0.00,45.00,45.00,12.500000,20,'Carburant',1276,1),(13478,'2026-06-09',1,0.00,0.00,4000.00,4000.00,14.190000,10,'Carburant',1277,1),(13479,'2026-06-09',2,0.00,0.00,786.00,786.00,15.190000,10,'Carburant',1277,1),(13480,'2026-06-09',3,0.00,0.00,357.00,357.00,14.790000,10,'Carburant',1277,1),(13481,'2026-06-09',109,0.00,0.00,10.30,10.30,12.500000,20,'Carburant',1277,1),(13482,'2026-06-10',1,0.00,0.00,4805.00,4805.00,14.190000,10,'Carburant',1278,1),(13483,'2026-06-10',2,0.00,0.00,602.00,602.00,15.190000,10,'Carburant',1278,1),(13484,'2026-06-10',3,0.00,0.00,376.00,376.00,14.790000,10,'Carburant',1278,1),(13485,'2026-06-10',109,0.00,0.00,4.30,4.30,12.500000,20,'Carburant',1278,1),(13493,'2026-06-11',1,0.00,0.00,5149.00,5149.00,14.190000,10,'Carburant',1279,1),(13492,'2026-06-11',2,0.00,0.00,818.00,818.00,15.190000,10,'Carburant',1279,1),(13491,'2026-06-11',3,0.00,0.00,410.00,410.00,14.790000,10,'Carburant',1279,1),(13490,'2026-06-11',109,0.00,0.00,44.10,44.10,12.500000,20,'Carburant',1279,1),(13505,'2026-06-12',1,0.00,0.00,3633.00,3633.00,14.190000,10,'Carburant',1280,1),(13504,'2026-06-12',2,0.00,0.00,726.00,726.00,15.190000,10,'Carburant',1280,1),(13503,'2026-06-12',3,0.00,0.00,530.00,530.00,14.790000,10,'Carburant',1280,1),(13502,'2026-06-12',109,0.00,0.00,22.30,22.30,12.500000,20,'Carburant',1280,1),(13543,'2026-06-13',1,0.00,0.00,4814.00,4814.00,14.190000,10,'Carburant',1281,1),(13542,'2026-06-13',2,0.00,0.00,805.00,805.00,15.190000,10,'Carburant',1281,1),(13541,'2026-06-13',3,0.00,0.00,350.00,350.00,14.790000,10,'Carburant',1281,1),(13540,'2026-06-13',109,0.00,0.00,21.60,21.60,12.500000,20,'Carburant',1281,1),(13506,'2026-06-14',1,0.00,0.00,4703.00,4703.00,14.190000,10,'Carburant',1282,1),(13507,'2026-06-14',2,0.00,0.00,565.00,565.00,15.190000,10,'Carburant',1282,1),(13508,'2026-06-14',3,0.00,0.00,444.00,444.00,14.790000,10,'Carburant',1282,1),(13509,'2026-06-14',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1282,1),(13510,'2026-06-16',2,5000.00,5000.00,0.00,0.00,13.155400,10,'Alimentation',535,1),(13511,'2026-06-15',1,0.00,0.00,5214.00,5214.00,14.190000,10,'Carburant',1283,1),(13512,'2026-06-15',2,0.00,0.00,808.00,808.00,15.190000,10,'Carburant',1283,1),(13513,'2026-06-15',3,0.00,0.00,1252.00,1252.00,14.790000,10,'Carburant',1283,1),(13514,'2026-06-15',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1283,1),(13515,'2026-06-16',1,0.00,0.00,748.00,748.00,14.190000,10,'Carburant',1284,1),(13516,'2026-06-16',2,0.00,0.00,787.00,787.00,15.190000,10,'Carburant',1284,1),(13517,'2026-06-16',3,0.00,0.00,2558.00,2558.00,14.790000,10,'Carburant',1284,1),(13518,'2026-06-16',109,0.00,0.00,58.00,58.00,12.500000,20,'Carburant',1284,1),(13519,'2026-06-17',1,28000.00,28000.00,0.00,0.00,11.972700,10,'Alimentation',536,1),(13520,'2026-06-17',3,5000.00,5000.00,0.00,0.00,12.381900,10,'Alimentation',536,1),(13521,'2026-06-17',1,0.00,0.00,5789.00,5789.00,14.190000,10,'Carburant',1285,1),(13522,'2026-06-17',2,0.00,0.00,838.00,838.00,15.190000,10,'Carburant',1285,1),(13523,'2026-06-17',3,0.00,0.00,328.00,328.00,14.790000,10,'Carburant',1285,1),(13524,'2026-06-17',109,0.00,0.00,40.10,40.10,12.500000,20,'Carburant',1285,1),(13525,'2026-06-18',1,26000.00,26000.00,0.00,0.00,11.972700,10,'Alimentation',537,1),(13526,'2026-06-18',2,4000.00,4000.00,0.00,0.00,12.610000,10,'Alimentation',537,1),(13527,'2026-06-18',3,3000.00,3000.00,0.00,0.00,12.381900,10,'Alimentation',537,1),(13528,'2026-06-18',1,0.00,0.00,3915.00,3915.00,14.190000,10,'Carburant',1286,1),(13529,'2026-06-18',2,0.00,0.00,283.00,283.00,15.190000,10,'Carburant',1286,1),(13530,'2026-06-18',3,0.00,0.00,125.00,125.00,14.790000,10,'Carburant',1286,1),(13531,'2026-06-18',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1286,1),(13539,'2026-06-19',1,0.00,0.00,3615.00,3615.00,13.790000,10,'Carburant',1287,1),(13538,'2026-06-19',2,0.00,0.00,503.00,503.00,15.190000,10,'Carburant',1287,1),(13537,'2026-06-19',3,0.00,0.00,164.00,164.00,14.390000,10,'Carburant',1287,1),(13536,'2026-06-19',109,0.00,0.00,33.50,33.50,12.500000,20,'Carburant',1287,1),(13544,'2026-06-19',1,0.00,0.00,6939.00,6939.00,13.790000,10,'Carburant',1288,1),(13545,'2026-06-19',2,0.00,0.00,716.00,716.00,15.190000,10,'Carburant',1288,1),(13546,'2026-06-19',3,0.00,0.00,459.00,459.00,14.390000,10,'Carburant',1288,1),(13547,'2026-06-19',109,0.00,0.00,39.10,39.10,12.500000,20,'Carburant',1288,1),(13548,'2026-06-20',1,0.00,0.00,7065.00,7065.00,13.790000,10,'Carburant',1289,1),(13549,'2026-06-20',2,0.00,0.00,771.00,771.00,15.190000,10,'Carburant',1289,1),(13550,'2026-06-20',3,0.00,0.00,554.00,554.00,14.390000,10,'Carburant',1289,1),(13551,'2026-06-20',109,0.00,0.00,45.00,45.00,12.500000,20,'Carburant',1289,1),(13552,'2026-06-21',1,0.00,0.00,4215.00,4215.00,13.790000,10,'Carburant',1290,1),(13553,'2026-06-21',2,0.00,0.00,678.00,678.00,15.190000,10,'Carburant',1290,1),(13554,'2026-06-21',3,0.00,0.00,357.00,357.00,14.390000,10,'Carburant',1290,1),(13555,'2026-06-21',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1290,1),(13556,'2026-06-22',1,0.00,0.00,5715.00,5715.00,13.790000,10,'Carburant',1291,1),(13557,'2026-06-22',2,0.00,0.00,617.00,617.00,15.190000,10,'Carburant',1291,1),(13558,'2026-06-22',3,0.00,0.00,336.00,336.00,14.390000,10,'Carburant',1291,1),(13559,'2026-06-22',109,0.00,0.00,25.90,25.90,12.500000,20,'Carburant',1291,1),(13560,'2026-06-23',1,30000.00,30000.00,0.00,0.00,11.972700,10,'Alimentation',538,1),(13561,'2026-06-23',2,3000.00,3000.00,0.00,0.00,12.610000,10,'Alimentation',538,1),(13562,'2026-06-23',1,0.00,0.00,5451.00,5451.00,13.790000,10,'Carburant',1292,1),(13563,'2026-06-23',2,0.00,0.00,916.00,916.00,15.190000,10,'Carburant',1292,1),(13564,'2026-06-23',3,0.00,0.00,340.00,340.00,14.390000,10,'Carburant',1292,1),(13565,'2026-06-23',109,0.00,0.00,45.40,45.40,12.500000,20,'Carburant',1292,1),(13566,'2026-06-24',111,3000.00,3000.00,0.00,0.00,11.727273,10,'Alimentation',540,1),(13567,'2026-06-24',1,0.00,0.00,7497.00,7497.00,13.790000,10,'Carburant',1293,1),(13568,'2026-06-24',2,0.00,0.00,632.00,632.00,15.190000,10,'Carburant',1293,1),(13569,'2026-06-24',3,0.00,0.00,483.00,483.00,14.390000,10,'Carburant',1293,1),(13570,'2026-06-24',109,0.00,0.00,103.30,103.30,12.500000,20,'Carburant',1293,1),(13578,'2026-06-25',1,0.00,0.00,6055.00,6055.00,13.790000,10,'Carburant',1294,1),(13577,'2026-06-25',2,0.00,0.00,649.00,649.00,15.190000,10,'Carburant',1294,1),(13576,'2026-06-25',3,0.00,0.00,345.00,345.00,14.390000,10,'Carburant',1294,1),(13575,'2026-06-25',109,0.00,0.00,27.00,27.00,12.500000,20,'Carburant',1294,1),(13579,'2026-06-26',1,0.00,0.00,4904.00,4904.00,13.790000,10,'Carburant',1295,1),(13580,'2026-06-26',2,0.00,0.00,658.00,658.00,15.190000,10,'Carburant',1295,1),(13581,'2026-06-26',3,0.00,0.00,457.00,457.00,14.390000,10,'Carburant',1295,1),(13582,'2026-06-26',109,0.00,0.00,85.20,85.20,12.500000,20,'Carburant',1295,1),(13583,'2026-06-27',1,0.00,0.00,6138.00,6138.00,13.790000,10,'Carburant',1296,1),(13584,'2026-06-27',2,0.00,0.00,735.00,735.00,15.190000,10,'Carburant',1296,1),(13585,'2026-06-27',3,0.00,0.00,408.00,408.00,14.390000,10,'Carburant',1296,1),(13586,'2026-06-27',109,0.00,0.00,19.50,19.50,12.500000,20,'Carburant',1296,1),(13587,'2026-06-28',1,0.00,0.00,4789.00,4789.00,13.790000,10,'Carburant',1297,1),(13588,'2026-06-28',2,0.00,0.00,684.00,684.00,15.190000,10,'Carburant',1297,1),(13589,'2026-06-28',3,0.00,0.00,376.00,376.00,14.390000,10,'Carburant',1297,1),(13590,'2026-06-28',109,0.00,0.00,57.00,57.00,12.500000,20,'Carburant',1297,1),(13591,'2026-06-29',1,0.00,0.00,5101.00,5101.00,13.790000,10,'Carburant',1298,1),(13592,'2026-06-29',2,0.00,0.00,666.00,666.00,15.190000,10,'Carburant',1298,1),(13593,'2026-06-29',3,0.00,0.00,317.00,317.00,14.390000,10,'Carburant',1298,1),(13594,'2026-06-29',109,0.00,0.00,26.00,26.00,12.500000,20,'Carburant',1298,1),(13595,'2026-06-30',1,0.00,0.00,4392.00,4392.00,13.790000,10,'Carburant',1299,1),(13596,'2026-06-30',2,0.00,0.00,843.00,843.00,15.190000,10,'Carburant',1299,1),(13597,'2026-06-30',3,0.00,0.00,392.00,392.00,14.390000,10,'Carburant',1299,1),(13598,'2026-06-30',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1299,1),(13599,'2026-07-01',1,30000.00,30000.00,0.00,0.00,11.090900,10,'Alimentation',541,1),(13600,'2026-07-01',3,3000.00,3000.00,0.00,0.00,11.500000,10,'Alimentation',541,1),(13608,'2026-07-01',1,0.00,0.00,4929.00,4929.00,13.790000,10,'Carburant',1300,1),(13607,'2026-07-01',2,0.00,0.00,944.00,944.00,15.190000,10,'Carburant',1300,1),(13606,'2026-07-01',3,0.00,0.00,1150.00,1150.00,14.390000,10,'Carburant',1300,1),(13605,'2026-07-01',109,0.00,0.00,11.00,11.00,12.500000,20,'Carburant',1300,1),(13616,'2026-07-02',1,0.00,0.00,1088.00,1088.00,13.790000,10,'Carburant',1301,1),(13615,'2026-07-02',2,0.00,0.00,142.00,142.00,15.190000,10,'Carburant',1301,1),(13614,'2026-07-02',3,0.00,0.00,42.00,42.00,14.390000,10,'Carburant',1301,1),(13613,'2026-07-02',109,0.00,0.00,5.60,5.60,12.500000,20,'Carburant',1301,1),(13617,'2026-07-02',1,24000.00,24000.00,0.00,0.00,11.090900,10,'Alimentation',542,1),(13618,'2026-07-02',2,6000.00,6000.00,0.00,0.00,12.191800,10,'Alimentation',542,1),(13619,'2026-07-02',3,3000.00,3000.00,0.00,0.00,11.500000,10,'Alimentation',542,1),(13620,'2026-07-02',1,0.00,0.00,4760.00,4760.00,12.790000,10,'Carburant',1302,1),(13621,'2026-07-02',2,0.00,0.00,825.00,825.00,14.990000,10,'Carburant',1302,1),(13622,'2026-07-02',3,0.00,0.00,461.00,461.00,13.390000,10,'Carburant',1302,1),(13623,'2026-07-02',109,0.00,0.00,10.00,10.00,12.500000,20,'Carburant',1302,1),(13624,'2026-07-03',1,0.00,0.00,6423.00,6423.00,12.790000,10,'Carburant',1303,1),(13625,'2026-07-03',2,0.00,0.00,753.00,753.00,14.990000,10,'Carburant',1303,1),(13626,'2026-07-03',3,0.00,0.00,533.00,533.00,13.390000,10,'Carburant',1303,1),(13627,'2026-07-03',109,0.00,0.00,29.80,29.80,12.500000,20,'Carburant',1303,1),(13628,'2026-07-04',1,0.00,0.00,4689.00,4689.00,12.790000,10,'Carburant',1304,1),(13629,'2026-07-04',2,0.00,0.00,632.00,632.00,14.990000,10,'Carburant',1304,1),(13630,'2026-07-04',3,0.00,0.00,770.00,770.00,13.390000,10,'Carburant',1304,1),(13631,'2026-07-04',109,0.00,0.00,5.30,5.30,12.500000,20,'Carburant',1304,1),(13643,'2026-07-05',1,0.00,0.00,5379.00,5379.00,12.790000,10,'Carburant',1305,1),(13642,'2026-07-05',2,0.00,0.00,705.00,705.00,14.990000,10,'Carburant',1305,1),(13641,'2026-07-05',3,0.00,0.00,265.00,265.00,13.390000,10,'Carburant',1305,1),(13640,'2026-07-05',109,0.00,0.00,40.00,40.00,12.500000,20,'Carburant',1305,1),(13636,'2026-07-06',1,0.00,0.00,4736.00,4736.00,12.790000,10,'Carburant',1306,1),(13637,'2026-07-06',2,0.00,0.00,764.00,764.00,14.990000,10,'Carburant',1306,1),(13638,'2026-07-06',3,0.00,0.00,262.00,262.00,13.390000,10,'Carburant',1306,1),(13639,'2026-07-06',109,0.00,0.00,5.00,5.00,12.500000,20,'Carburant',1306,1),(13644,'2026-07-07',1,0.00,0.00,7756.00,7756.00,12.790000,10,'Carburant',1307,1),(13645,'2026-07-07',2,0.00,0.00,903.00,903.00,14.990000,10,'Carburant',1307,1),(13646,'2026-07-07',3,0.00,0.00,615.00,615.00,13.390000,10,'Carburant',1307,1),(13647,'2026-07-07',109,0.00,0.00,55.10,55.10,12.500000,20,'Carburant',1307,1),(13648,'2026-07-08',1,25000.00,25000.00,0.00,0.00,11.090900,10,'Alimentation',543,1),(13649,'2026-07-08',2,5000.00,5000.00,0.00,0.00,12.191800,10,'Alimentation',543,1),(13650,'2026-07-08',3,3000.00,3000.00,0.00,0.00,11.500000,10,'Alimentation',543,1),(13651,'2026-07-08',1,0.00,0.00,4920.00,4920.00,12.790000,10,'Carburant',1308,1),(13652,'2026-07-08',2,0.00,0.00,746.00,746.00,14.990000,10,'Carburant',1308,1),(13653,'2026-07-08',3,0.00,0.00,656.00,656.00,13.390000,10,'Carburant',1308,1),(13654,'2026-07-08',109,0.00,0.00,12.00,12.00,12.500000,20,'Carburant',1308,1),(13655,'2026-07-09',1,0.00,0.00,6248.00,6248.00,12.790000,10,'Carburant',1309,1),(13656,'2026-07-09',2,0.00,0.00,656.00,656.00,14.990000,10,'Carburant',1309,1),(13657,'2026-07-09',3,0.00,0.00,276.00,276.00,13.390000,10,'Carburant',1309,1),(13658,'2026-07-09',109,0.00,0.00,31.30,31.30,12.500000,20,'Carburant',1309,1),(13659,'2026-07-10',1,0.00,0.00,6942.00,6942.00,12.790000,10,'Carburant',1310,1),(13660,'2026-07-10',2,0.00,0.00,675.00,675.00,14.990000,10,'Carburant',1310,1),(13661,'2026-07-10',3,0.00,0.00,294.00,294.00,13.390000,10,'Carburant',1310,1),(13662,'2026-07-10',109,0.00,0.00,105.70,105.70,12.500000,20,'Carburant',1310,1),(13663,'2026-07-11',1,0.00,0.00,7716.00,7716.00,12.790000,10,'Carburant',1311,1),(13664,'2026-07-11',2,0.00,0.00,794.00,794.00,14.990000,10,'Carburant',1311,1),(13665,'2026-07-11',3,0.00,0.00,342.00,342.00,13.390000,10,'Carburant',1311,1),(13666,'2026-07-11',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1311,1),(13667,'2026-07-12',1,0.00,0.00,3782.00,3782.00,12.790000,10,'Carburant',1312,1),(13668,'2026-07-12',2,0.00,0.00,752.00,752.00,14.990000,10,'Carburant',1312,1),(13669,'2026-07-12',3,0.00,0.00,458.00,458.00,13.390000,10,'Carburant',1312,1),(13670,'2026-07-12',109,0.00,0.00,0.00,0.00,12.500000,20,'Carburant',1312,1),(13671,'2026-07-13',113,53.00,53.00,0.00,0.00,33.333333,20,'Alimentation',544,1);

--
-- Table structure for table `stocks_produit_ancien`
--

CREATE TABLE `stocks_produit_ancien` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(34) DEFAULT NULL,
  `prix_vente` decimal(11,2) DEFAULT NULL,
  `prix_achat` decimal(11,6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nom` (`nom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `stocks_produit_ancien`
--


--
-- Table structure for table `stocks_produits`
--

CREATE TABLE `stocks_produits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  `type_vente` varchar(20) NOT NULL,
  `prix_achat` decimal(20,6) NOT NULL,
  `prix_vente` decimal(20,6) NOT NULL,
  `tva` int(11) NOT NULL,
  `en_stock_initial` int(11) NOT NULL,
  `en_stock` int(11) NOT NULL,
  `en_vert` int(11) NOT NULL DEFAULT 0,
  `en_rouge` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `stocks_produits`
--

INSERT INTO `stocks_produits` VALUES (1,'Gasoil Advanced','carburant',9.709100,14.000000,10,0,45675,276084,288563),(2,'Super Sans Plomb 95','carburant',11.319100,14.000000,10,0,8123,88395,93246),(3,'Gasoil Excellium','carburant',10.118200,14.000000,10,0,6038,55468,49340),(4,'LAVAGE VOITURE SIMPLE','service',0.000000,60.000000,20,0,0,0,0),(5,'LAVAGE VOITURE COMPLET','service',0.000000,60.000000,20,0,0,0,0),(6,'GRAISSAGE CAMION','service',0.000000,80.000000,20,0,0,0,0),(7,'QUARTZ 5000 15W40 20L','produit',651.666700,933.000000,20,0,0,0,0),(8,'QUARTZ 5000 15W40 5L','produit',195.000000,247.000000,20,0,0,0,0),(9,'QUARTZ 5000 15W40 1L','produit',43.000000,57.000000,20,0,0,0,0),(10,'LAVAGE VOITURE EXTERIEUR','service',0.000000,25.000000,20,0,0,0,0),(11,'LAVAGE VOITURE INTERIEUR','service',0.000000,25.000000,20,0,0,0,0),(12,'LAVAGE VOITURE COMPLET (PRO)','service',0.000000,400.000000,20,0,0,0,0),(13,'LAVAGE TRACTEUR AGRICOLE','service',0.000000,35.000000,20,0,0,0,0),(14,'LAVAGE TRACTEUR  & EQUIPEMENT AGRICOLE','service',0.000000,65.000000,20,0,0,0,0),(15,'GRAISSAGE VOITURE','service',0.000000,30.000000,20,0,0,0,0),(16,'GRAISSAGE TRACTEUR AGRICOLE','service',0.000000,30.000000,20,0,0,0,0),(17,'GRAISSAGE TRACTEUR & EQUIPEMENT AGRICOLE','service',0.000000,60.000000,20,0,0,0,0),(18,'LAVAGE ENGIN (P)','service',0.000000,100.000000,20,0,0,0,0),(19,'LAVAGE ENGIN (G)','service',0.000000,200.000000,20,0,0,0,0),(20,'LAVAGE','service',0.000000,10.000000,20,0,0,0,0),(21,'MAIN D\'OEUVRE','service',0.000000,120.000000,20,0,0,0,0),(22,'QUARTZ 5000 15W40 211L','produit',6476.666700,9200.000000,20,0,0,0,0),(23,'MULTAGRI MS 15W40 5L','produit',190.000000,250.000000,20,0,0,0,0),(24,'QUARTZ 7000 S 10W40 5L','produit',225.000000,337.000000,20,0,0,0,0),(25,'RUBIA FLEET HD 300 15W40 20L','produit',720.000000,1031.000000,20,0,0,0,0),(26,'ADBLUE TOTAL 5L','produit',115.000000,159.000000,20,0,0,0,0),(27,'QUARTZ 7000 S 10W40 1L','produit',52.500000,74.000000,20,0,0,0,0),(28,'QUARTZ 9000 5W40 1L','produit',78.333300,134.000000,20,0,0,0,0),(29,'QUARTZ 9000 5W40 5L','produit',375.000000,590.000000,20,0,0,0,0),(30,'QUARTZ INEO L LIFE 0W30 5L','produit',480.000000,840.000000,20,0,0,0,0),(31,'QUARTZ INEO L LIFE 0W30 1L','produit',105.000000,172.000000,20,0,0,0,0),(32,'QUARTZ INEO L LIFE 5W30 1L','produit',89.596800,161.000000,20,0,0,0,0),(33,'QUARTZ INEO L LIFE 5W30 5L','produit',432.744200,779.000000,20,0,0,0,0),(34,'RUBIA FLEET HD 300 15W40 5L','produit',190.000000,235.000000,20,0,0,0,0),(35,'MULTIS EP 2 15KG','produit',816.670000,1058.000000,20,0,0,0,0),(36,'MULTIS 2 1KG','produit',41.000000,47.000000,20,0,0,0,0),(37,'MULTIS 2 15KG','produit',585.000000,770.000000,20,0,0,0,0),(38,'MULTAGRI MS 15W40 20L','produit',720.000000,950.000000,20,0,0,0,0),(39,'AZOLLA ZS 68 20L','produit',700.000000,780.000000,20,0,0,0,0),(40,'COOLTECH ECO BS 5L','produit',75.000000,105.000000,20,0,0,0,0),(41,'LIQUIDE DE REFROIDISSEMENT 5L','produit',50.000000,63.000000,20,0,0,0,0),(42,'LIQUIDE DE FREIN HBF 4 0.5L','produit',39.000000,50.000000,20,0,0,0,0),(43,'QUARTZ 5000 20W50 1L','produit',40.000000,51.000000,20,0,0,0,0),(44,'LAVE GLACE 5L','produit',55.000000,70.000000,20,0,0,0,0),(45,'FLUID MATIC D II MV 1L','produit',52.770800,65.000000,20,0,0,0,0),(46,'FLUIDMATIC D3 1L','produit',65.000000,92.000000,20,0,-12,0,0),(47,'LAVAGE MINI-BUS SIMPLE','service',0.000000,75.000000,20,0,0,0,0),(48,'LAVAGE CAMION SIMPLE','service',0.000000,75.000000,20,0,0,0,0),(49,'LAVAGE CAMION COMPLET','service',0.000000,100.000000,20,0,0,0,0),(50,'LAVAGE CAMION EAU','service',0.000000,30.000000,20,0,0,0,0),(51,'COOLTECH ECO BS 1L','produit',19.000000,27.000000,20,0,0,0,0),(56,'TRACTORELF ST3 15W40 208L','produit',7176.000000,10147.000000,20,0,0,0,0),(52,'LIQUIDE DE REFROIDISSEMENT TOTAL 1L','produit',12.500000,17.000000,20,0,0,0,0),(55,'TRACTORELF ST3 15W40 20L','produit',710.000000,950.000000,20,0,0,0,0),(53,'QUARTZ INEO MDC 5W30 5L','produit',380.000000,694.000000,20,0,0,0,0),(54,'MULTAGRI MS 15W40 190K','produit',7174.000000,10550.000000,20,0,0,0,0),(57,'QUARTZ INEO MDC 5W30 1L','produit',85.000000,154.000000,20,0,0,0,0),(58,'RUBIA TIR 7400 15W40 20L','produit',840.000000,1194.000000,20,0,0,0,0),(59,'TRANSTEC 4 85W140 20L','produit',720.000000,973.000000,20,0,0,0,0),(60,'DIESEL OIL SAE 50 20L','produit',600.000000,778.000000,20,0,0,0,0),(61,'INJECTEUR XTREM CLEANER DIESEL 250ML','produit',32.625000,50.000000,20,0,0,0,0),(63,'TRANSTEC 4 85W90 20L','produit',700.000000,970.000000,20,0,0,0,0),(64,'TRACTORELF ST3 15W40 5L','produit',187.500000,250.000000,20,0,0,0,0),(62,'TRANSTEC 4 85W90 20L','service',0.000000,700.000000,20,0,0,0,0),(65,'LAVAGE VOITURE EAU','service',0.000000,10.000000,20,0,0,0,0),(76,'LAIT CHAUD','restaurant',0.000000,8.000000,10,0,0,0,0),(71,'ADBLUE 10L TOTAL','produit',200.000000,282.000000,20,0,0,0,0),(66,'QUARTZ 7000 FGO 5W40 5L','produit',345.000000,604.000000,20,0,0,0,0),(67,'DIESEL OIL SAE 50 5L','produit',160.000000,204.000000,20,0,0,0,0),(68,'DIESEL OIL SAE 50 1L','produit',35.000000,47.000000,20,0,0,0,0),(69,'LAVE GLACE 1L','produit',15.000000,20.000000,20,0,0,0,0),(75,'CAFE AU LAIT','restaurant',0.000000,8.000000,10,0,0,0,0),(70,'QUARTZ 7000 FGO 5W40 1L','produit',78.000000,136.000000,20,0,0,0,0),(74,'CAFE NOIR','restaurant',0.000000,8.000000,10,0,0,0,0),(77,'THE VERT PETIT','restaurant',0.000000,8.000000,10,0,0,0,0),(78,'THE VERT MOYEN','restaurant',0.000000,12.000000,10,0,0,0,0),(79,'THE VERT GRAND','restaurant',0.000000,15.000000,10,0,0,0,0),(80,'BOISSON GAZEUSE','restaurant',0.000000,8.000000,10,0,0,0,0),(81,'LAIT FROID','restaurant',0.000000,7.000000,10,0,0,0,0),(82,'SIDI ALI 1,50L','restaurant',0.000000,10.000000,10,0,0,0,0),(83,'SIDI ALI 0,50L','restaurant',0.000000,6.000000,10,0,0,0,0),(84,'SIDI ALI 0,33L','restaurant',0.000000,3.000000,10,0,0,0,0),(85,'CAFE NESPRESSO','restaurant',0.000000,12.000000,10,0,0,0,0),(86,'LAIT AU CHOCOLAT','restaurant',0.000000,8.000000,10,0,0,0,0),(87,'THE NOIR','restaurant',0.000000,8.000000,10,0,0,0,0),(88,'JUS D\'ORANGE','restaurant',0.000000,15.000000,10,0,0,0,0),(89,'JUS D\'AVOCAT','restaurant',0.000000,18.000000,10,0,0,0,0),(90,'MILK CHECK BANANE','restaurant',0.000000,15.000000,10,0,0,0,0),(91,'MILK CHECK POMME','restaurant',0.000000,15.000000,10,0,0,0,0),(92,'JUS MULTIFRUITS','restaurant',0.000000,18.000000,10,0,0,0,0),(93,'OULMES 0.33L','restaurant',0.000000,8.000000,10,0,0,0,0),(94,'MENU FTOUR BELDI','restaurant',0.000000,40.000000,10,0,0,0,0),(99,'TRANSTEC 4 85W90 208L TOTAL','produit',6752.000000,9568.000000,20,0,0,0,0),(95,'TRAX. GEAR 8 75W80 2L','produit',140.000000,240.000000,20,0,0,0,0),(96,'NETTOYANT TEXTILLE','produit',31.916700,50.000000,20,0,0,0,0),(97,'STOP CREVAISION 400ML','produit',51.083300,73.000000,20,0,0,0,0),(98,'AZOLLA ZS 68 190K TOTAL','produit',6963.000000,7917.000000,20,0,0,0,0),(100,'COOLTECH SUPER -2C 5L TOTAL','produit',75.000000,107.000000,20,0,0,0,0),(101,'COOLTECH PLUS -7 5L TOTAL','produit',0.000000,107.000000,20,0,0,0,0),(102,'COOLTECH EXTRA -10 5L TOTAL','produit',76.700000,107.000000,20,0,0,0,0),(103,'MOTOR OIL SAE 40 5L','produit',170.000000,229.000000,20,0,0,0,0),(106,'RUBIA TIR 7400 15W40 5L ','produit',220.000000,314.000000,20,0,0,0,0),(104,'HI-PERF 2T 500 1L','produit',38.000000,57.000000,20,0,0,0,0),(105,'MOTOR OIL SAE 40 1L','produit',37.000000,49.000000,20,0,0,0,0),(107,'TRANSTEC 4 85W90 1L','produit',43.000000,58.000000,20,0,0,0,0),(108,'COOLTECH EXTRA -10 C 1L','produit',20.900000,27.000000,20,0,0,0,0),(109,'Adblue','carburant',7.500000,12.000000,20,0,4263,0,0),(111,'GASOIL CG','produit',11.363636,13.790000,10,0,0,0,0),(110,'RUBIA TIR 8800 10W40 20L','produit',1180.000000,1678.000000,20,0,0,0,0),(112,'COOLTECH PLUS -7°C 1L','produit',0.000000,17.000000,20,0,0,0,0),(114,'LAVAGE VOITURE SIMPLE (PROMO)','service',0.000000,50.000000,20,0,0,0,0),(115,'LAVAGE MINI-BUS EAU','service',0.000000,20.000000,20,0,0,0,0),(113,'CARTE STATION NFC','produit',33.333333,50.000000,20,0,0,0,0),(116,'LAVAGE MOTEUR','service',0.000000,20.000000,20,0,0,0,0),(117,'SOUFFLAGE VOITURE','service',0.000000,10.000000,20,0,0,0,0),(118,'LAVAGE MINI-BUS EXTÉRIEUR','service',0.000000,30.000000,20,0,0,0,0),(119,'LAVAGE VOITURE SIMPLE','service',0.000000,30.000000,20,0,0,0,0),(120,'LAVAGE TRACTEUR EAU','service',0.000000,50.000000,20,0,0,0,0),(123,'LAVAGE CAMIONNETTE EXTÉRIEUR ','service',0.000000,50.000000,20,0,0,0,0),(122,'LAVAGE TRACTEUR CAMION','service',0.000000,75.000000,20,0,0,0,0),(121,'LAVAGE MINI-BUS INTÉRIEUR ','service',0.000000,45.000000,20,0,0,0,0),(124,'QUARTZ INEO X.EC6 0W20 5L','produit',650.000000,1120.000000,20,0,0,0,0),(125,'QUARTZ 4000 SL SEA 50 5L TOTAL','produit',162.670000,225.000000,20,0,0,0,0),(126,'QUARTZ 5000 SL 10W40 5L TOTAL','produit',217.000000,300.000000,20,0,0,0,0),(127,'QUARTZ 5000 SL 10W40 1L TOTAL','produit',51.000000,70.000000,20,0,0,0,0),(130,'QUARTZ INEO MC3 5W30 5L','produit',424.966667,765.000000,20,0,0,0,0),(131,'QUARTZ INEO MC3 5W30 1L','produit',94.000000,170.000000,20,0,0,0,0),(128,'QUARTZ INEO FIRST 0W30 1L TOTAL','produit',105.000000,172.000000,20,0,0,0,0),(129,'QUARTZ INEO FIRST 0W30 5L TOTAL','produit',480.000000,840.000000,20,0,0,0,0),(132,'QUARTZ 4000 SL SEA 50 1L TOT','produit',35.000000,50.000000,20,0,0,0,0),(133,'LAVAGE VOITURE SIMPLE','service',0.000000,40.000000,20,0,0,0,0),(134,'QUARTZ 4000 SL SEA 40 1L','produit',35.000000,50.000000,20,0,0,0,0);

--
-- Table structure for table `stocks_produits_quantite`
--

CREATE TABLE `stocks_produits_quantite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_stock` int(11) NOT NULL,
  `id_produit` int(11) NOT NULL,
  `en_stock` int(11) NOT NULL,
  `en_stock_initial` int(11) NOT NULL DEFAULT 0,
  `valeur_initial` decimal(10,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `stocks_produits_quantite`
--

INSERT INTO `stocks_produits_quantite` VALUES (1,1,1,45675,0,0.00),(2,2,2,8123,0,0.00),(3,3,3,6038,0,0.00),(13,6,8,117,0,0.00),(12,6,24,0,0,0.00),(15,6,38,0,0,0.00),(14,6,23,0,0,0.00),(16,4,24,225,0,0.00),(17,4,8,3,0,0.00),(18,4,38,176,0,0.00),(19,4,23,414,0,0.00),(20,4,9,0,0,0.00),(21,4,43,0,0,0.00),(22,4,35,0,0,0.00),(23,4,44,33,0,0.00),(24,4,45,0,0,0.00),(25,6,35,0,0,0.00),(26,6,9,0,0,0.00),(27,6,43,0,0,0.00),(28,6,44,88,0,0.00),(29,6,45,96,0,0.00),(30,6,46,-12,0,0.00),(31,6,51,0,0,0.00),(32,6,52,0,0,0.00),(33,6,53,114,0,0.00),(34,6,39,0,0,0.00),(35,6,54,4,0,0.00),(36,6,55,0,0,0.00),(37,6,56,0,0,0.00),(38,6,57,84,0,0.00),(39,6,27,192,0,0.00),(40,6,58,0,0,0.00),(41,6,59,0,0,0.00),(42,6,60,16,0,0.00),(43,6,40,0,0,0.00),(44,6,42,0,0,0.00),(45,6,61,0,0,0.00),(46,6,63,0,0,0.00),(47,6,64,0,0,0.00),(48,6,36,0,0,0.00),(49,6,31,84,0,0.00),(50,6,66,0,0,0.00),(51,6,67,0,0,0.00),(52,6,68,0,0,0.00),(53,6,69,0,0,0.00),(54,6,70,0,0,0.00),(55,6,37,0,0,0.00),(56,6,30,0,0,0.00),(57,6,71,155,0,0.00),(58,4,67,0,0,0.00),(59,4,41,0,0,0.00),(60,4,68,0,0,0.00),(61,4,39,0,0,0.00),(62,6,41,0,0,0.00),(63,6,29,0,0,0.00),(64,6,95,0,0,0.00),(65,6,96,0,0,0.00),(66,6,97,0,0,0.00),(67,6,98,0,0,0.00),(68,6,99,0,0,0.00),(69,6,100,0,0,0.00),(70,6,101,0,0,0.00),(71,6,102,0,0,0.00),(72,6,103,0,0,0.00),(73,6,34,0,0,0.00),(74,6,104,0,0,0.00),(75,6,105,0,0,0.00),(76,6,106,0,0,0.00),(77,6,107,0,0,0.00),(78,6,108,0,0,0.00),(79,9,109,4263,0,0.00),(80,6,110,0,0,0.00),(81,4,111,0,0,0.00),(82,6,112,0,0,0.00),(83,6,28,0,0,0.00),(84,6,33,0,0,0.00),(85,6,113,0,0,0.00),(86,6,26,24,0,0.00),(87,11233,71,-50,0,0.00),(88,11234,60,-14,0,0.00),(89,11235,27,-168,0,0.00),(90,11236,31,-60,0,0.00),(91,11237,57,-60,0,0.00),(92,11238,26,-24,0,0.00),(93,11239,71,-5,0,0.00),(94,11240,60,-2,0,0.00),(95,11241,27,-24,0,0.00),(96,11242,31,-24,0,0.00),(97,11243,57,-24,0,0.00),(98,11351,53,0,0,0.00),(99,11352,45,0,0,0.00),(100,11355,53,-24,0,0.00),(101,11356,45,-12,0,0.00),(102,11359,53,-60,0,0.00),(103,11360,45,-84,0,0.00),(104,4,54,56,0,0.00),(105,11610,38,-29,0,0.00),(106,11611,54,-14,0,0.00),(107,4,113,0,0,0.00),(108,11659,23,-180,0,0.00),(109,11660,38,-51,0,0.00),(110,11663,23,-45,0,0.00),(111,11664,38,-33,0,0.00),(112,11667,71,-100,0,0.00),(113,11670,44,-80,0,0.00),(114,11672,44,-8,0,0.00),(115,6,124,51,0,0.00),(116,11682,124,-15,0,0.00),(117,11684,124,-6,0,0.00),(118,11687,53,-15,0,0.00),(119,11688,124,-15,0,0.00),(120,11689,8,-60,0,0.00),(121,11693,53,-15,0,0.00),(122,11694,124,-15,0,0.00),(123,11695,8,-60,0,0.00),(124,11812,54,-26,0,0.00),(125,11814,54,-16,0,0.00),(126,12013,54,-4,0,0.00),(127,12523,38,0,0,0.00),(128,12527,38,0,0,0.00),(129,12529,38,-50,0,0.00),(130,4,26,44,0,0.00),(131,4,108,264,0,0.00),(132,4,69,264,0,0.00),(133,4,36,120,0,0.00),(134,4,37,15,0,0.00),(135,12582,26,0,0,0.00),(136,12583,108,0,0,0.00),(137,12584,69,0,0,0.00),(138,12585,36,0,0,0.00),(139,12586,37,0,0,0.00),(140,12596,37,-15,0,0.00),(141,12592,26,-40,0,0.00),(142,12593,108,-240,0,0.00),(143,12594,69,-240,0,0.00),(144,12595,36,-120,0,0.00),(145,12602,26,-4,0,0.00),(146,12603,108,-24,0,0.00),(147,12604,69,-24,0,0.00),(148,4,104,276,0,0.00),(149,4,31,0,0,0.00),(150,4,30,0,0,0.00),(151,4,57,84,0,0.00),(152,12608,104,-240,0,0.00),(153,12609,31,0,0,0.00),(154,12610,30,0,0,0.00),(155,12611,57,-60,0,0.00),(156,12616,104,-36,0,0.00),(157,12617,31,0,0,0.00),(158,12618,30,0,0,0.00),(159,12619,57,-24,0,0.00),(160,4,125,48,0,0.00),(161,4,126,48,0,0.00),(162,4,127,36,0,0.00),(163,4,27,180,0,0.00),(164,12624,125,-42,0,0.00),(165,12625,126,-42,0,0.00),(166,12626,127,-36,0,0.00),(167,12627,24,-180,0,0.00),(168,12628,27,-144,0,0.00),(169,12634,125,-6,0,0.00),(170,12635,126,-6,0,0.00),(171,12636,24,-45,0,0.00),(172,12637,27,-36,0,0.00),(173,6,128,48,0,0.00),(174,6,129,42,0,0.00),(175,12643,129,-30,0,0.00),(176,12642,128,-36,0,0.00),(177,12649,129,-12,0,0.00),(178,12648,128,-12,0,0.00),(179,12710,44,-30,0,0.00),(180,12712,44,-3,0,0.00),(181,4,130,63,0,0.00),(182,4,131,84,0,0.00),(183,12714,130,-45,0,0.00),(184,12715,131,-60,0,0.00),(185,12718,130,-18,0,0.00),(186,12719,131,-24,0,0.00),(187,12764,38,-13,0,0.00),(188,12807,23,-150,0,0.00),(189,12809,23,-39,0,0.00),(190,4,132,828,0,0.00),(191,12924,132,-720,0,0.00),(192,12926,132,-108,0,0.00),(193,4,53,42,0,0.00),(194,13110,53,-30,0,0.00),(195,13112,53,-12,0,0.00),(196,4,134,276,0,0.00),(197,13301,134,-240,0,0.00),(198,13303,134,-36,0,0.00);

--
-- Table structure for table `stocks_transfert`
--

CREATE TABLE `stocks_transfert` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_transfert` datetime NOT NULL,
  `id_source` int(11) NOT NULL,
  `id_destination` int(11) NOT NULL,
  `id_creation` int(11) NOT NULL,
  `date_creation` datetime NOT NULL,
  `id_cloture` int(11) DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `stocks_transfert`
--

INSERT INTO `stocks_transfert` VALUES (2,'2023-04-20 12:40:00',4,6,2,'2023-04-20 12:40:27',2,'2023-04-20 12:41:40');

--
-- Table structure for table `telecollect`
--

CREATE TABLE `telecollect` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `numero` int(11) NOT NULL,
  `du` datetime DEFAULT NULL,
  `au` datetime NOT NULL,
  `id_creation` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `telecollect`
--

INSERT INTO `telecollect` VALUES (1,1,'2025-06-24 17:08:04','2025-06-24 17:08:04',3),(2,2,'2025-06-24 17:08:04','2025-06-24 17:45:10',3),(3,3,'2025-06-24 17:45:10','2025-06-25 08:11:05',3),(4,4,'2025-07-02 19:59:03','2025-07-02 19:59:03',5),(5,5,'2025-08-24 14:29:09','2025-08-24 14:29:09',2),(6,6,'2025-06-25 08:11:05','2025-10-06 17:54:04',3),(7,7,'2025-07-02 19:59:03','2025-10-31 08:15:39',5);

--
-- Table structure for table `user_path`
--

CREATE TABLE `user_path` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `path` varchar(250) NOT NULL,
  `date_creation` datetime NOT NULL,
  `info_post` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `user_path`
--


--
-- Table structure for table `user_profil`
--

CREATE TABLE `user_profil` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nom` (`nom`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `user_profil`
--

INSERT INTO `user_profil` VALUES (1,'admin'),(2,'Administrateur'),(3,'Utilisateur');

--
-- Table structure for table `users_space`
--

CREATE TABLE `users_space` (
  `id` int(11) NOT NULL,
  `tresorie` int(11) NOT NULL DEFAULT 0,
  `coffre` int(11) NOT NULL DEFAULT 0,
  `compte` int(11) NOT NULL DEFAULT 0,
  `vente` int(11) NOT NULL DEFAULT 0,
  `achat` int(11) NOT NULL DEFAULT 0,
  `stock` int(11) NOT NULL DEFAULT 0,
  `service` int(11) NOT NULL DEFAULT 0,
  `restaurant` int(11) DEFAULT 0,
  `employe` int(11) NOT NULL DEFAULT 0,
  `interne` int(11) NOT NULL DEFAULT 0,
  `comptabilite` int(11) NOT NULL DEFAULT 0,
  `statistique` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users_space`
--

INSERT INTO `users_space` VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1),(2,1,1,1,1,1,1,1,1,1,1,1,1),(3,1,1,1,1,1,1,1,0,0,0,0,0),(4,1,1,1,1,1,1,1,0,0,0,0,0),(5,1,1,1,1,1,1,1,1,1,1,1,1),(6,0,0,2,0,0,0,0,0,0,0,0,0),(7,0,0,2,0,0,0,0,0,0,0,0,0),(8,0,0,2,0,0,0,0,0,0,0,0,0),(9,1,1,1,1,1,1,1,0,0,1,1,0);

--
-- Table structure for table `vignette_administration`
--

CREATE TABLE `vignette_administration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vignette_administration`
--


--
-- Table structure for table `vignette_description`
--

CREATE TABLE `vignette_description` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_bon` int(11) NOT NULL,
  `id_produit` int(11) NOT NULL,
  `qte` decimal(10,2) NOT NULL,
  `prix` decimal(10,2) NOT NULL,
  `montant` decimal(10,2) NOT NULL,
  `type` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vignette_description`
--


--
-- Table structure for table `vignette_ont`
--

CREATE TABLE `vignette_ont` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_administration` int(11) NOT NULL,
  `serie` varchar(50) NOT NULL,
  `date_ont` date NOT NULL,
  `code` int(11) NOT NULL DEFAULT 0,
  `intervenant` varchar(50) NOT NULL,
  `matricule` varchar(50) NOT NULL,
  `montant` decimal(10,2) NOT NULL,
  `type_bon` int(11) NOT NULL,
  `source` varchar(30) NOT NULL,
  `id_source` int(11) NOT NULL,
  `id_creation` int(11) DEFAULT NULL,
  `date_creation` int(11) DEFAULT NULL,
  `id_etat` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vignette_ont`
--



