

CREATE TABLE `closed_months` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `closed_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `month` (`month`,`year`),
  KEY `closed_by` (`closed_by`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;



CREATE TABLE `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `address` mediumtext DEFAULT NULL,
  `area` varchar(100) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `is_exempt` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `meter_id` varchar(100) DEFAULT NULL,
  `system_type` enum('meter','ampere') DEFAULT 'meter',
  `sub_no` varchar(50) DEFAULT NULL,
  `box_no` varchar(50) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `initial_reading` decimal(10,2) DEFAULT 0.00,
  `ampere_qty` decimal(10,2) DEFAULT 0.00,
  `custom_amp_price` decimal(10,2) DEFAULT 0.00,
  `monthly_fixed_fee` decimal(12,2) DEFAULT 0.00,
  `old_balance` decimal(10,2) DEFAULT 0.00,
  `insurance` decimal(10,2) DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=842 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `customers` VALUES ('1','احمد ابو زيد','','','','','1','0','2025-12-25 07:14:27',NULL,'ampere','926','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('2','حسن شرعان','','','','','1','0','2025-12-25 07:15:04',NULL,'ampere','913','الجامع','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('3','خالت رضا السوري','','','','','1','0','2025-12-25 07:15:39',NULL,'ampere','908','الجامع','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('4','خالد دعبول','','','','','1','0','2025-12-25 07:16:10',NULL,'ampere','918','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('5','خلف ادهم','','','','','1','0','2025-12-25 07:16:43',NULL,'ampere','921','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('7','علي عبد الله','','','','','1','0','2025-12-25 07:17:36',NULL,'ampere','919','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('8','صليبة','','','','','1','0','2025-12-25 07:18:24',NULL,'ampere','923','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('10','محمد حسين','','','','','1','0','2025-12-25 07:21:01',NULL,'ampere','933','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('11','محمد خالد','','','','','1','0','2025-12-25 07:21:29',NULL,'ampere','920','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('12','محمود سعد','','','','','1','0','2025-12-25 07:25:48',NULL,'ampere','917','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('13','مهند كرمو','','','','','1','0','2025-12-25 07:26:54',NULL,'ampere','922','الجامع','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('14','بشار رمو','','','','','1','0','2025-12-25 07:30:25',NULL,'ampere','2501','عبد عجينة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('812','يوسف نبهاني','','','','','1','0','2026-03-27 05:14:19',NULL,'ampere','893','صيدلية فاطمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('18','ابو لينا','','','','','1','0','2025-12-25 07:34:57',NULL,'ampere','998','ابو الروس','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('19','احمد العفيس','','','','','1','0','2025-12-25 07:40:14',NULL,'ampere','1000','ابو الروس','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('750','عادل اصلان','81627399','','','','1','0','2025-12-31 11:14:15',NULL,'ampere','1428','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('21','صالح داوود مكتب','','','','','1','0','2025-12-25 07:52:18',NULL,'ampere','996','ابو الروس','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('22','ربيع الاعرج','','','','','1','1','2025-12-25 08:03:41',NULL,'ampere','997','ابو الروس','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('23','عبد حسكاوي','','','','','1','0','2025-12-25 08:05:17',NULL,'ampere','995','ابو الروس','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('24','ميرفت مراد','','','','','1','0','2025-12-25 08:05:55',NULL,'ampere','999','ابو الروس','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('25','ابو السعيد عبد الهادي','','','','','1','0','2025-12-25 08:07:07',NULL,'ampere','818','ابو باهي','4','0.00','3.00','20.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('26','ابو باهي','','','','','1','0','2025-12-25 08:08:53',NULL,'ampere','827','ابو باهي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('27','احمد احمد','','','','','1','0','2025-12-25 08:09:35',NULL,'ampere','1104','ابو باهي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('28','احمد حمدان','','','','','1','0','2025-12-25 08:10:11',NULL,'ampere','1103','ابو باهي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('29','بسام قطب','','','','','1','0','2025-12-25 08:17:51',NULL,'ampere','1108','ابو باهي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('30','حمودة العدنان المصطفى','','','','','1','0','2025-12-25 08:18:34',NULL,'ampere','1107','ابو باهي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('31','خالد عبد الهادي','','','','','1','1','2025-12-25 08:19:10',NULL,'ampere','817','ابو باهي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('32','عبد الحميد الحويش','','','','','1','0','2025-12-25 08:20:13',NULL,'ampere','820','ابو باهي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('33','عصام القاسم','','','','','1','0','2025-12-25 08:22:03',NULL,'ampere','823','ابو باهي','4','0.00','3.00','13.33','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('34','عمر شعبان','','','','','1','0','2025-12-25 08:22:56',NULL,'ampere','824','ابو باهي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('35','عوض هايل','','','','','1','0','2025-12-25 08:23:25',NULL,'ampere','816','ابو باهي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('36','فادي ابو هارون','','','','','1','1','2025-12-25 08:24:11',NULL,'ampere','826','ابو باهي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('37','فوزي ناصر','','','','','1','0','2025-12-25 08:25:09',NULL,'ampere','822','ابو باهي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('38','محمد احمد احمد','','','','','1','0','2025-12-25 08:25:46',NULL,'ampere','825','ابو باهي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('39','محمد حميدي','','','','','1','0','2025-12-25 08:26:35',NULL,'ampere','1106','ابو باهي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('41','وليد توفيق','','','','10 الشهر','1','0','2025-12-25 08:28:27',NULL,'ampere','815','ابو باهي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('42','يوسف الاحول','','','','','1','0','2025-12-25 08:29:30',NULL,'ampere','819','ابو باهي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('43','ادهم سليمان','','','','','1','0','2025-12-25 08:30:14',NULL,'ampere','812','ابو باهي','4','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('45','محمد محمود','','','','','1','0','2025-12-25 08:31:41',NULL,'ampere','821','ابو باهي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('46','ابو فادي السعدي','','','','','1','0','2025-12-25 08:35:30',NULL,'ampere','1181','ابو تركي','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('47','ابو فادي السعدي دكان','','','','','1','0','2025-12-25 08:38:07',NULL,'ampere','1183','ابو تركي','4','0.00','8.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('48','الدكتور جمال الحسيني','','','','موتير المحلات','1','0','2025-12-25 08:39:12',NULL,'ampere','1207','ابو تركي','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('49','انارة زاروب ابو تركي','','','','','1','1','2025-12-25 08:42:18',NULL,'ampere','1200','ابو تركي','4','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('50','اية سنترال','','','','موتير المحلات','1','0','2025-12-25 08:44:31',NULL,'ampere','1208','ابو تركي','4','0.00','1.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('813','سامر دروبي','','','','','1','0','2026-03-29 12:26:53',NULL,'ampere','801','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('53','جهاد سليم','','','','','1','1','2025-12-25 08:48:27',NULL,'ampere','1191','ابو تركي','4','0.00','30.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('54','حسان الاسمر','','','','','1','0','2025-12-25 08:49:42',NULL,'ampere','1187','ابو تركي','4','0.00','3.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('55','حسن ابو تركي','','','','','1','0','2025-12-25 08:50:39',NULL,'ampere','1188','ابو تركي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('56','حسين الملك','','','','','1','0','2025-12-25 08:51:25',NULL,'ampere','1189','ابو تركي','4','0.00','3.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('57','حمادة عابد','','','','','1','0','2025-12-25 08:54:05',NULL,'ampere','1186','ابو تركي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('58','حمشو','','','','','1','0','2025-12-25 08:54:53',NULL,'ampere','1197','ابو تركي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('59','خالد الحبال','','','','','1','0','2025-12-25 08:55:37',NULL,'ampere','1184','ابو تركي','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('60','خالد علوش','','','','','1','0','2025-12-25 08:57:18',NULL,'ampere','1194','ابو تركي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('61','زياد شعبان','','','','','1','0','2025-12-25 08:58:01',NULL,'ampere','1192','ابو تركي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('62','عبد اسماعيل','','','','','1','0','2025-12-25 08:58:40',NULL,'ampere','1198','ابو تركي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('63','عبد تبعنا','','','','','1','1','2025-12-25 08:59:10',NULL,'ampere','1193','ابو تركي','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('64','عماد اللحام','','','','','1','0','2025-12-25 08:59:51',NULL,'ampere','1180','ابو تركي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('65','فؤاد الحسين','','','','','1','0','2025-12-25 09:02:11',NULL,'ampere','1199','ابو تركي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('67','محمد الشيخ','','','','','1','0','2025-12-25 09:06:28',NULL,'ampere','1196','ابو تركي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('68','محمد المصري','','','','','1','0','2025-12-25 09:08:56',NULL,'ampere','1182','ابو تركي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('69','محمد ناجي','','','','','1','0','2025-12-25 09:09:33',NULL,'ampere','1202','ابو تركي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('70','محمود شواخ','','','','','1','0','2025-12-25 09:10:18',NULL,'ampere','1179','ابو تركي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('71','ابو داوود (فؤاد)','','','','','1','0','2025-12-25 09:12:28',NULL,'ampere','836','ابو خضر','4','0.00','10.00','33.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('72','احمد جاسم','','','','','1','0','2025-12-25 09:13:14',NULL,'ampere','841','ابو خضر','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('73','ام عبد الله حلب','','','','','1','0','2025-12-25 09:14:09',NULL,'ampere','833','ابو خضر','4','0.00','2.00','27.50','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('74','ايمن العجوز','','','','','1','0','2025-12-25 09:14:45',NULL,'ampere','834','ابو خضر','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('75','تركية محمد','','','','','1','0','2025-12-25 09:15:14',NULL,'ampere','844','ابو خضر','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('76','خالد الشامان','','','','','1','0','2025-12-25 09:16:02',NULL,'ampere','835','ابو خضر','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('77','سخني العبد الله','','','','','1','0','2025-12-25 09:16:39',NULL,'ampere','843','ابو خضر','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('78','محمد الحلو','','','','','1','0','2025-12-25 09:17:32',NULL,'ampere','838','ابو خضر','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('79','مصطفى عبد الهادي','','','','','1','0','2025-12-25 09:18:10',NULL,'ampere','837','ابو خضر','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('80','ياسر جابر','81652319','','','','1','0','2025-12-25 09:18:49',NULL,'ampere','832','ابو خضر','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('81','ابو سليم','','','','','1','0','2025-12-25 09:20:30',NULL,'ampere','546','ابو رصاص','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('82','خلف الهارون','','','','','1','0','2025-12-25 09:21:38',NULL,'ampere','548','ابو رصاص','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('601','عبد الواحد','','','','','1','1','2025-12-27 06:58:27',NULL,'ampere','15','الميعاري','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('85','علي حسين الصفوري','','','','','1','0','2025-12-25 09:23:56',NULL,'ampere','543','ابو رصاص','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('86','ماهر صابر','','','','','1','0','2025-12-25 09:24:47',NULL,'ampere','560','ابو رصاص','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('90','ناجي حسين','','','','','1','0','2025-12-25 09:28:00',NULL,'ampere','542','ابو رصاص','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('91','هيثم كنجو','','','','','1','0','2025-12-25 09:28:34',NULL,'ampere','558','ابو رصاص','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('92','حسن دادا','','','','','1','0','2025-12-25 09:29:50',NULL,'ampere','1260','ابو نصرا','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('93','خالد شراب','','','','','1','0','2025-12-25 09:30:19',NULL,'ampere','1264','ابو نصرا','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('94','محمد نور بنغلادش','','','','','1','0','2025-12-25 09:31:00',NULL,'ampere','1261','ابو نصرا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('95','شادي ابو خميس','','','','','1','0','2025-12-25 09:31:38',NULL,'ampere','1268','ابو نصرا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('96','طريف الخالد','','','','16 الشهر','1','0','2025-12-25 09:32:26',NULL,'ampere','1280','ابو نصرا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('97','طه لوباني','','','','','1','0','2025-12-25 09:33:04',NULL,'ampere','1278','ابو نصرا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('836','خالد الحسن','','','','','1','0','2026-04-26 09:57:44',NULL,'ampere','2506','عبد عجينة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('99','عبد الله خالد مصطفى','','','','','1','0','2025-12-25 09:35:57',NULL,'ampere','1263','ابو نصرا','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('100','عدنان خالد','','','','','1','0','2025-12-25 09:36:43',NULL,'ampere','1259','ابو نصرا','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('101','علاء حسين ابو اكرم','','','','','1','0','2025-12-25 09:37:33',NULL,'ampere','1269','ابو نصرا','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('102','علي الاحمد','','','','','1','0','2025-12-25 09:38:12',NULL,'ampere','1272','ابو نصرا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('104','محمود الفرن','','','','','1','0','2025-12-25 09:39:14',NULL,'ampere','1267','ابو نصرا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('106','ابو حزيفة','','','','','1','0','2025-12-25 09:41:10',NULL,'ampere','845','ابو وسيم فرحات','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('107','احمد الشيخ','','','','','1','0','2025-12-25 09:42:01',NULL,'ampere','851','ابو وسيم فرحات','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('109','ام خالد  بيومي','','','','بالعلبة 2.5','1','0','2025-12-25 09:43:50',NULL,'ampere','846','ابو وسيم فرحات','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('110','انارة ابو وسيم','','','','','1','1','2025-12-25 09:44:24',NULL,'ampere','863','ابو وسيم فرحات','4','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('112','حمزة جاد','','','','','1','0','2025-12-25 09:46:02',NULL,'ampere','857','ابو وسيم فرحات','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('113','عمر انور','','','','','1','0','2025-12-25 09:47:07',NULL,'ampere','852','ابو وسيم فرحات','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('115','مصطفى عطور','','','','','1','0','2025-12-25 09:48:28',NULL,'ampere','848','ابو وسيم فرحات','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('116','الجبهة الشعبية','','','','','1','0','2025-12-25 09:51:28',NULL,'ampere','481','الاسطبل','4','0.00','7.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('117','جميلة','','','','','1','1','2025-12-25 09:52:39',NULL,'ampere','480','الاسطبل','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('119','عبد عجينة','','','','','1','1','2025-12-25 09:55:04',NULL,'ampere','484','الاسطبل','4','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('120','عبد عجينة','','','','','1','1','2025-12-25 09:55:33',NULL,'ampere','485','الاسطبل','4','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('121','عدنان الحاج','','','','','1','0','2025-12-25 09:57:55',NULL,'ampere','497','الاسطبل','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('122','محمد الحلاء السنغري','','','','','1','0','2025-12-25 09:58:38',NULL,'ampere','494','الاسطبل','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('123','محمد الحلاء السنغري بيت اهلو','','','','','1','0','2025-12-25 09:59:11',NULL,'ampere','479','الاسطبل','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('124','محمد الحلاق ','','','','موتير المحلات','1','0','2025-12-25 09:59:53',NULL,'ampere','495','الاسطبل','4','0.00','1.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('125','محمد عبد الله','','','','','1','0','2025-12-25 10:01:05',NULL,'ampere','483','الاسطبل','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('126','محمود دوالي','','','','موتير المحلات','1','0','2025-12-25 10:02:40',NULL,'ampere','493','الاسطبل','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('127','وائل علي','','','','','1','0','2025-12-25 10:03:26',NULL,'ampere','486','الاسطبل','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('128','ابو علاء الدين','','','','بالعلبة 3 امبير','1','0','2025-12-25 10:04:49',NULL,'ampere','669','البليار','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('129','اكرم مجدلاني','','','','','1','0','2025-12-25 10:05:38',NULL,'ampere','684','البليار','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('130','احمد الحمد','','','','','1','0','2025-12-25 10:06:17',NULL,'ampere','681','البليار','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('131','بسام وليد كايد','','','','','1','0','2025-12-25 10:07:15',NULL,'ampere','672','البليار','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('132','ابراهيم شاويش','','','','','1','0','2025-12-25 10:07:44',NULL,'ampere','677','البليار','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('133','حسين علي حمزة','','','','','1','0','2025-12-25 10:08:18',NULL,'ampere','694','البليار','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('134','حميد حمزة','','','','','1','0','2025-12-25 10:08:54',NULL,'ampere','691','البليار','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('136','زياد المغير','','','','','1','0','2025-12-25 10:10:08',NULL,'ampere','671','البليار','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('137','ساري العشي','','','','','1','0','2025-12-25 10:10:38',NULL,'ampere','674','البليار','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('139','سليمان الحسن','','','','','1','0','2025-12-25 10:12:06',NULL,'ampere','693','البليار','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('140','ام محمد نهر البارد','','','','','1','1','2025-12-25 10:12:42',NULL,'ampere','676','البليار','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('141','ماهر العمري','','','','','1','0','2025-12-25 10:13:24',NULL,'ampere','678','البليار','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('142','محمد الحسين','','','','','1','0','2025-12-25 10:13:59',NULL,'ampere','689','البليار','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('143','محمد صلاح صالح','','','','موتير المحلات','1','0','2025-12-25 10:14:56',NULL,'ampere','686','البليار','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('144','هاني المصري','','','','','1','0','2025-12-25 10:17:29',NULL,'ampere','680','البليار','4','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('145','احمد ابو داوود','','','','','1','0','2025-12-25 10:22:09',NULL,'ampere','1453','التضامن','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('146','انارة زاروب التضامن','','','','','1','1','2025-12-25 10:22:46',NULL,'ampere','1476','التضامن','4','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('147','حميد حيتو','','','','','1','0','2025-12-25 10:23:35',NULL,'ampere','1150','جمال قداح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('148','خالد الحلو','','','','','1','0','2025-12-25 10:24:10',NULL,'ampere','1459','التضامن','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('149','خالد شريف','','','','','1','0','2025-12-25 10:25:17',NULL,'ampere','1457','التضامن','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('150','جمعية أبشر','','','','','1','0','2025-12-25 10:26:20',NULL,'ampere','1451','التضامن','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('151','صالح ابو داوود','','','','','1','0','2025-12-25 10:26:51',NULL,'ampere','1452','التضامن','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('152','فارس محمود','','','','','1','0','2025-12-25 10:27:22',NULL,'ampere','1472','التضامن','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('153','محمد سليمان','','','','','1','0','2025-12-25 10:27:54',NULL,'ampere','1450','التضامن','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('154','محمود ابو داوود','','','','بالعلبة 2.5 امبير','1','0','2025-12-25 10:29:31',NULL,'ampere','1458','التضامن','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('155','محمود الحلو','','','','','1','0','2025-12-25 10:30:06',NULL,'ampere','1455','التضامن','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('156','محمود معروف','','','','','1','0','2025-12-25 10:30:37',NULL,'ampere','1460','التضامن','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('158','هيال الاحمد','','','','','1','0','2025-12-25 10:31:39',NULL,'ampere','1469','التضامن','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('159','اسامة صالح','','','','','1','0','2025-12-25 10:33:08',NULL,'ampere','944','التعاونية','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('160','احمد الخطيب','','','','','1','0','2025-12-25 10:33:49',NULL,'ampere','964','التعاونية','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('161','احمد رعد','','','','','1','0','2025-12-25 10:34:35',NULL,'ampere','957','التعاونية','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('162','احمد عياش','','','','','1','0','2025-12-25 10:35:13',NULL,'ampere','959','التعاونية','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('163','اخت هاني المصري','','','','','1','1','2025-12-25 10:35:52',NULL,'ampere','946','التعاونية','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('164','بلال طنطوري','','','','','1','0','2025-12-25 10:36:27',NULL,'ampere','962','التعاونية','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('165','جمال دراج','','','','','1','0','2025-12-25 10:37:31',NULL,'ampere','940','التعاونية','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('168','عمر هلال','','','','','1','0','2025-12-25 10:42:48',NULL,'ampere','945','التعاونية','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('169','محمد فرحات ابو مجاهد','','','','15 الشهر','1','0','2025-12-25 10:43:18',NULL,'ampere','948','التعاونية','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('170','مرت عم اسامة','','','','','1','1','2025-12-25 10:43:55',NULL,'ampere','965','التعاونية','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('171','نبهان الحريري','','','','','1','0','2025-12-25 10:44:40',NULL,'ampere','951','التعاونية','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('172','نجاح زعرورة','','','','10 الشهر','1','0','2025-12-25 10:45:35',NULL,'ampere','961','التعاونية','4','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('173','يوسف الموسى','','','','','1','0','2025-12-25 10:47:31',NULL,'ampere','950','التعاونية','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('174','ابو عمر','','','','13 الشهر','1','0','2025-12-25 12:16:37',NULL,'ampere','22222','صبرا','4','0.00','6.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('175','اخو سنترال اية','','','','','1','0','2025-12-25 12:17:36',NULL,'ampere','3005','صبرا','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('176','حمودة الصافي','','','','','1','0','2025-12-25 12:18:21',NULL,'ampere','2001-1','صبرا','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('177','محمد طعمة','','','','','1','0','2025-12-25 12:19:00',NULL,'ampere','44444','صبرا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('178','اسامة الصالح','','','','','1','0','2025-12-25 12:20:49',NULL,'ampere','1400','البيبي فوت','4','0.00','12.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('179','ابو زيد','','','','','1','0','2025-12-25 12:21:32',NULL,'ampere','1410','البيبي فوت','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('180','احمد خليف','','','','','1','0','2025-12-25 12:22:17',NULL,'ampere','1413','البيبي فوت','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('181','احمد سوادي','','','','','1','0','2025-12-25 12:22:58',NULL,'ampere','1429','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('182','انارة زاروب البيبي فوت','','','','','1','1','2025-12-25 12:23:42',NULL,'ampere','1431','البيبي فوت','4','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('183','تركي','','','','','1','0','2025-12-25 12:24:17',NULL,'ampere','1422','البيبي فوت','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('184','حسن ابراهيم','','','','','1','0','2025-12-25 12:25:52',NULL,'ampere','1407','البيبي فوت','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('185','حسن ابراهيم 1','','','','','1','0','2025-12-25 12:26:22',NULL,'ampere','1412','البيبي فوت','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('186','حسن العلي','','','','','1','0','2025-12-25 12:27:01',NULL,'ampere','1432','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('187','حسن المصري','','','','','1','1','2025-12-25 12:28:23',NULL,'ampere','1433','البيبي فوت','4','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('188','حسين علي صالح','','','','','1','0','2025-12-25 12:29:17',NULL,'ampere','1424','البيبي فوت','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('189','حسين فريجة','','','','','1','0','2025-12-25 12:29:59',NULL,'ampere','1409','البيبي فوت','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('190','خالد العبد الله','','','','','1','0','2025-12-25 12:30:55',NULL,'ampere','1427','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('191','خالد ياسين','','','','بالعلبة 2.5 امبير','1','0','2025-12-25 12:32:00',NULL,'ampere','1411','البيبي فوت','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('192','خليل رمضان','','','','','1','0','2025-12-25 12:32:41',NULL,'ampere','1421','البيبي فوت','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('193','خليل عليوي','','','','','1','0','2025-12-25 12:33:32',NULL,'ampere','1425','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('804','زهراة اسامة','','','','','1','0','2026-03-16 08:30:26',NULL,'ampere','282','بركة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('195','سمير القاسم','','','','','1','0','2025-12-25 12:35:14',NULL,'ampere','1417','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('196','صيدلية الشفاء','','','','موتير المحلات','1','0','2025-12-25 12:36:30',NULL,'ampere','3000','البيبي فوت','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('197','عبد منصور','','','','','1','0','2025-12-25 12:37:08',NULL,'ampere','1406','البيبي فوت','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('198','علي ابو عزئة','','','','','1','1','2025-12-25 12:37:49',NULL,'ampere','1402','البيبي فوت','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('199','علي سعد','','','','','1','0','2025-12-25 12:38:18',NULL,'ampere','1414','البيبي فوت','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('200','عماد حورية','','','','','1','0','2025-12-25 12:39:00',NULL,'ampere','1435','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('201','ابو هاني قتناني','','','','بالعلبة 5 امبير','1','0','2025-12-25 12:40:12',NULL,'ampere','1403','البيبي فوت','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('202','رمضان  الحسين','','','','','1','0','2025-12-25 12:41:08',NULL,'ampere','1430','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('203','محمود ابو ستيتة','','','','','1','0','2025-12-25 12:41:57',NULL,'ampere','1420','البيبي فوت','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('210','ابو عبدو ناصر','','','','','1','0','2025-12-25 12:54:36',NULL,'ampere','1328','الجهاد','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('205','محمود المحمد','','','','','1','0','2025-12-25 12:42:59',NULL,'ampere','1252','الحايك','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('206','مرت عم مؤمن','','','','','1','1','2025-12-25 12:43:50',NULL,'ampere','1404','البيبي فوت','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('207','مركز عبد الرحمن','','','','موتير المحلات','1','0','2025-12-25 12:45:09',NULL,'ampere','3001','البيبي فوت','4','0.00','4.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('602','	علي الميعاري','','','','','1','1','2025-12-27 06:58:54',NULL,'ampere','5','الميعاري','5','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('209','ياسين دريلمي','','','','','1','0','2025-12-25 12:47:05',NULL,'ampere','1419','البيبي فوت','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('211','ابو يوسف الدبوري','','','','','1','0','2025-12-25 12:55:25',NULL,'ampere','1331','الجهاد','4','0.00','3.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('213','احمد صالح','','','','','1','0','2025-12-25 12:56:55',NULL,'ampere','1330','الجهاد','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('214','ام علي معروف','','','','','1','0','2025-12-25 12:57:57',NULL,'ampere','1333','الجهاد','4','0.00','2.00','27.50','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('215','بشار محمد العبد','','','','','1','0','2025-12-25 12:58:48',NULL,'ampere','1327','الجهاد','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('216','جمعة الحسن','','','','','1','0','2025-12-25 12:59:24',NULL,'ampere','1352','الجهاد','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('217','رياض الدهش','','','','','1','0','2025-12-25 13:00:26',NULL,'ampere','1346','الجهاد','4','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('218','عبد الهادي مستأجر دبوري','','','','','1','0','2025-12-25 13:01:19',NULL,'ampere','1339','الجهاد','4','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('219','عدنان صالح جمعة','','','','','1','0','2025-12-25 13:02:12',NULL,'ampere','1340','الجهاد','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('220','فادي العبد الله','','','','','1','0','2025-12-25 13:03:28',NULL,'ampere','1345','الجهاد','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('221','فادي دحويش','','','','','1','0','2025-12-25 13:04:18',NULL,'ampere','1354','الجهاد','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('222','مالك الحوراني','','','','','1','0','2025-12-25 13:04:55',NULL,'ampere','1329','الجهاد','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('223','محمد ابراهيم','','','','','1','0','2025-12-25 13:05:37',NULL,'ampere','1343','الجهاد','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('224','محمود مارندي','','','','','1','0','2025-12-25 13:06:18',NULL,'ampere','1324','الجهاد','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('225','انارة الحايك','','','','','1','1','2025-12-25 13:08:13',NULL,'ampere','1248','الحايك','4','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('226','شيماء','','','','','1','0','2025-12-25 13:09:21',NULL,'ampere','1234','الحايك','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('227','عامر بغدادي','','','','','1','0','2025-12-25 13:09:55',NULL,'ampere','1245','الحايك','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('229','عدنان محمد العراقي','','','','','1','0','2025-12-25 13:11:13',NULL,'ampere','1235','الحايك','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('230','عيادة الاندلس','','','','','1','0','2025-12-25 13:11:44',NULL,'ampere','1236','الحايك','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('231','محمود الصالحاني','','','','موتير المحلات','1','0','2025-12-25 13:13:42',NULL,'ampere','1244','الحايك','4','0.00','2.50','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('232','نادية حمدان','','','','','1','0','2025-12-25 13:14:13',NULL,'ampere','1229','الحايك','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('233','وسيم ابو جاموس','','','','بالعلبة 3 امبير','1','0','2025-12-25 13:15:00',NULL,'ampere','1228','الحايك','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('811','يوسف رمضان العلي','','','','','1','0','2026-03-27 04:11:58',NULL,'ampere','653','العيوطي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('235','الحجة ام اسماعيل','','','','','1','0','2025-12-25 13:16:28',NULL,'ampere','171','الحنون','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('236','شادي الميعاري','','','','موتير المحلات','1','0','2025-12-25 13:17:06',NULL,'ampere','179','الحنون','4','0.00','4.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('237','صيدلية الميعاري','','','','موتير المحلات','1','0','2025-12-25 13:17:40',NULL,'ampere','177','الحنون','4','0.00','10.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('238','عاهد ابو صلاح','','','','','1','0','2025-12-25 13:18:14',NULL,'ampere','169','الحنون','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('239','نداء','','','','','1','0','2025-12-25 13:18:45',NULL,'ampere','168','الحنون','4','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('240','احمد اخو ابو فادي','','','','موتير المحلات','1','0','2025-12-25 13:22:10',NULL,'ampere','1372','الصمود','4','0.00','10.00','5.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('241','حكيم الحريري','','','','','1','0','2025-12-25 13:22:34',NULL,'ampere','1374','الصمود','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('242','محمد فجر ','','','','','1','0','2025-12-25 13:23:02',NULL,'ampere','1375','الصمود','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('243','احمد اليوسف','','','','','1','0','2025-12-25 13:24:26',NULL,'ampere','883','العشقة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('244','ام وسام العمشى','','','','','1','0','2025-12-25 13:26:03',NULL,'ampere','878','العشقة','4','0.00','2.50','16.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('245','ريما حسين','','','','','1','0','2025-12-25 13:26:35',NULL,'ampere','884','العشقة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('246','وسام العمشى','','','','','1','0','2025-12-25 13:27:07',NULL,'ampere','877','العشقة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('247','ابو عرب عيادة','','','','موتير المحلات','1','0','2025-12-25 13:29:42',NULL,'ampere','665','العيوطي','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('248','احمد ابو عنتر','','','','','1','0','2025-12-25 13:30:17',NULL,'ampere','651','العيوطي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('249','احمد الاحمد','','','','','1','0','2025-12-25 13:30:50',NULL,'ampere','657','العيوطي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('802','حيدر حمود','','','','','1','0','2026-03-09 14:00:12',NULL,'ampere','1105','ابو باهي','4','0.00','1.00','45.00','0.00','40.00','0.00');
INSERT INTO `customers` VALUES ('251','الايوبي سنترال','','','','','1','1','2025-12-25 13:32:01',NULL,'ampere','640','العيوطي','4','0.00','3.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('252','ام ناصر','','','','','1','0','2025-12-25 13:32:25',NULL,'ampere','649','العيوطي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('254','جهاد الشاويش','','','','','1','0','2025-12-25 13:33:25',NULL,'ampere','659','العيوطي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('255','عائشة جهجاه','','','','','1','0','2025-12-25 13:34:02',NULL,'ampere','660','العيوطي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('256','عامر سليم','','','','','1','0','2025-12-25 13:34:28',NULL,'ampere','662','العيوطي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('257','عبد الله اللحام','','','','','1','0','2025-12-25 13:35:26',NULL,'ampere','639','العيوطي','4','0.00','2.50','28.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('258','عقاب حبيب','','','','','1','0','2025-12-25 13:35:58',NULL,'ampere','664','العيوطي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('259','علاء عز الدين','','','','','1','1','2025-12-25 13:36:28',NULL,'ampere','646','العيوطي','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('260','علاء غاز','','','','','1','1','2025-12-25 13:36:53',NULL,'ampere','654','العيوطي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('261','فاتن صلاح','','','','','1','0','2025-12-25 13:37:21',NULL,'ampere','642','العيوطي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('262','ماهر الاحمد','','','','','1','0','2025-12-25 13:37:49',NULL,'ampere','643','العيوطي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('263','ماهر محمود ديراوي','','','','','1','0','2025-12-25 13:38:20',NULL,'ampere','650','العيوطي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('264','محمد الزايد','','','','','1','0','2025-12-25 13:38:45',NULL,'ampere','648','العيوطي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('265','محمد العيوطي','','','','','1','0','2025-12-25 13:39:16',NULL,'ampere','644','العيوطي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('267','محمد سعد','','','','','1','0','2025-12-25 13:40:25',NULL,'ampere','658','العيوطي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('268','محمد محمود ابراهيم','','','','','1','0','2025-12-25 13:40:50',NULL,'ampere','641','العيوطي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('269','مصطفى تلفزيونات','','','','','1','0','2025-12-25 13:41:49',NULL,'ampere','637','العيوطي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('271','مصطفى محسن','','','','','1','0','2025-12-25 13:42:59',NULL,'ampere','638','العيوطي','4','0.00','6.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('272','وليد العيسى','','','','','1','0','2025-12-25 13:43:20',NULL,'ampere','652','العيوطي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('274','ابو بكر النجار','','','','','1','0','2025-12-25 13:45:20',NULL,'ampere','1060','الكفاح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('275','ابو محمد العبد الله','','','','','1','0','2025-12-25 13:45:56',NULL,'ampere','1054','الكفاح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('276','الحج ابو عاطف','','','','','1','1','2025-12-25 13:46:28',NULL,'ampere','1058','الكفاح','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('277','ام حسام','','','','','1','1','2025-12-25 13:46:59',NULL,'ampere','1056','الكفاح','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('278','امين العامر','','','','','1','0','2025-12-25 13:47:42',NULL,'ampere','1069','الكفاح','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('279','حنين ضاهر','','','','','1','0','2025-12-25 13:48:11',NULL,'ampere','1070','الكفاح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('280','راغب العبد الله','','','','','1','0','2025-12-25 13:48:40',NULL,'ampere','1067','الكفاح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('281','علي عنبتاوي','','','','','1','0','2025-12-25 13:49:14',NULL,'ampere','1051','الكفاح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('282','علي فطايرجي','','','','','1','0','2025-12-25 13:49:39',NULL,'ampere','1061','الكفاح','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('283','محمود العفيفي','','','','','1','0','2025-12-25 13:50:10',NULL,'ampere','1068','الكفاح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('284','مرعي البندر','','','','','1','0','2025-12-25 13:50:43',NULL,'ampere','1071','الكفاح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('285','وسيم احمد','','','','','1','0','2025-12-25 13:51:08',NULL,'ampere','1053','الكفاح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('286','يوسف المصري','','','','','1','0','2025-12-25 13:51:41',NULL,'ampere','1055','الكفاح','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('287','ابو مصطفى جارنا','','','','بالعلبة 5 امبير','1','0','2025-12-25 13:53:53',NULL,'ampere','735','بنايتنا','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('288','الحجة ام محمود','','','','','1','1','2025-12-25 13:54:24',NULL,'ampere','740','بنايتنا','4','0.00','15.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('289','ام خليل','','','','','1','0','2025-12-25 13:54:48',NULL,'ampere','737','بنايتنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('290','ام سيدرا','','','','','1','0','2025-12-25 13:55:11',NULL,'ampere','744','بنايتنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('291','بهاء عبيدات','','','','','1','0','2025-12-25 13:55:46',NULL,'ampere','741','بنايتنا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('292','ثامر فرحان','','','','','1','0','2025-12-25 13:56:19',NULL,'ampere','734','بنايتنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('293','زياد النعسان','','','','','1','0','2025-12-25 13:56:52',NULL,'ampere','739','بنايتنا','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('294','مؤمن البيت','','','','','1','1','2025-12-25 13:57:21',NULL,'ampere','733','بنايتنا','4','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('295','محمود السلوم','','','','بالعلبة 4 امبير','1','0','2025-12-25 13:57:54',NULL,'ampere','736','بنايتنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('296','مصطفى داوود','','','','','1','0','2025-12-25 13:58:21',NULL,'ampere','738','بنايتنا','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('297','يحيى ابراهيم','','','','','1','0','2025-12-25 13:58:46',NULL,'ampere','742','بنايتنا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('298','ابو الياس','','','','','1','0','2025-12-25 14:00:10',NULL,'ampere','1137','جمال قداح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('299','ابو عمر سنترال','','','','بالعلبة 3 امبير','1','0','2025-12-25 14:00:48',NULL,'ampere','1136','جمال قداح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('300','ابو مهند عسكر','','','','','1','0','2025-12-25 14:01:31',NULL,'ampere','1146','جمال قداح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('301','احمد غزلان','','','','','1','0','2025-12-25 14:02:09',NULL,'ampere','1127','جمال قداح','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('302','الشيخ محمد هاشم','','','','','1','0','2025-12-25 14:02:37',NULL,'ampere','1135','جمال قداح','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('303','الصفوري بيت عمو','','','','','1','0','2025-12-25 14:03:10',NULL,'ampere','1125','جمال قداح','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('304','ام العبد غزلان','','','','','1','0','2025-12-25 14:03:41',NULL,'ampere','1120','جمال قداح','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('305','جمال قداح','','','','','1','0','2025-12-25 14:04:31',NULL,'ampere','1115','جمال قداح','4','0.00','5.00','23.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('306','جهاد البياض','','','','','1','0','2025-12-25 14:05:02',NULL,'ampere','1122','جمال قداح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('788','علي صطوف','','','','','1','0','2026-01-30 07:08:00',NULL,'ampere','839','ابو خضر','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('308','حسين الاغا','','','','','1','0','2025-12-25 14:06:02',NULL,'ampere','1131','جمال قداح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('309','حسين المصور','','','','','1','0','2025-12-25 14:06:25',NULL,'ampere','1134','جمال قداح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('310','حمزة ابو النور','','','','10 الشهر','1','0','2025-12-25 14:07:07',NULL,'ampere','1133','جمال قداح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('816','محمود العسكري','','','','','1','0','2026-03-30 03:37:59',NULL,'ampere','695','البليار','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('312','علي الدايا','','','','','1','0','2025-12-25 14:08:27',NULL,'ampere','1143','جمال قداح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('313','علي حميدي','','','','','1','0','2025-12-25 14:08:55',NULL,'ampere','1149','جمال قداح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('315','فادي الصالح','','','','','1','0','2025-12-25 14:10:01',NULL,'ampere','1148','جمال قداح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('316','فادي علي','','','','','1','0','2025-12-25 14:10:26',NULL,'ampere','1145','جمال قداح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('317','محمد الزمار','','','','','1','0','2025-12-25 14:10:52',NULL,'ampere','1118','جمال قداح','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('318','محمد الشنتف','','','','','1','0','2025-12-25 14:11:15',NULL,'ampere','1146','جمال قداح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('319','مروان فرج','','','','','1','0','2025-12-25 14:11:44',NULL,'ampere','1132','جمال قداح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('320','وائل حاج علي','','','','','1','0','2025-12-25 14:12:17',NULL,'ampere','1116','جمال قداح','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('321','ابو سليمان البلاط','','','','بالعلبة 3 امبير','1','0','2025-12-25 14:14:21',NULL,'ampere','595','حاتم','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('322','احمد علي','','','','','1','0','2025-12-25 14:14:46',NULL,'ampere','593','حاتم','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('323','احمد موسى','','','','','1','0','2025-12-25 14:15:15',NULL,'ampere','591','حاتم','4','0.00','7.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('324','امين كريم','','','','','1','0','2025-12-25 14:15:42',NULL,'ampere','592','حاتم','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('325','رامي ابو جاموس','','','','','1','0','2025-12-25 14:16:09',NULL,'ampere','573','حاتم','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('326','ربيع فيومي','','','','','1','1','2025-12-25 14:16:38',NULL,'ampere','588','حاتم','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('327','سامر دحويش','','','','','1','0','2025-12-25 14:17:11',NULL,'ampere','574','حاتم','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('600','شاكر الصالح','','','','','1','0','2025-12-27 06:57:30',NULL,'ampere','7','الميعاري','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('330','عبد حمود','','','','','1','0','2025-12-25 14:18:44',NULL,'ampere','578','حاتم','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('331','عبد الله حالول','','','','','1','0','2025-12-25 14:19:18',NULL,'ampere','575','حاتم','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('332','عمر النعمان','','','','','1','0','2025-12-25 14:19:52',NULL,'ampere','590','حاتم','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('333','محمد درعاوي فرن','','','','','1','0','2025-12-25 14:20:20',NULL,'ampere','589','حاتم','4','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('334','محمود تبعنا','','','','','1','1','2025-12-25 14:20:43',NULL,'ampere','580','حاتم','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('335','يوسف خليل الحسين','','','','','1','0','2025-12-25 14:21:10',NULL,'ampere','581','حاتم','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('338','الدكتور محمد خليل','','','','موتير المحلات','1','0','2025-12-25 14:29:41',NULL,'ampere','6003','حسنين','4','0.00','4.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('339','الدكتور معن','','','','موتير المحلات','1','0','2025-12-25 14:30:25',NULL,'ampere','6002','حسنين','4','0.00','5.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('340','الصفوري عيادة اول المخيم','','','','','1','0','2025-12-25 14:31:04',NULL,'ampere','7322','حسنين','4','0.00','24.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('341','ام خليل التركية','','','','','1','0','2025-12-25 14:31:36',NULL,'ampere','713','حسنين','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('342','اياد العباس','','','','','1','0','2025-12-25 14:31:59',NULL,'ampere','710','حسنين','4','0.00','7.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('343','بلال ابو شليح','','','','','1','0','2025-12-25 14:32:23',NULL,'ampere','703','حسنين','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('344','حزيفة كنعان','','','','','1','0','2025-12-25 14:32:57',NULL,'ampere','7320','حسنين','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('345','حسن قاسم','','','','موتير المحلات','1','0','2025-12-25 14:34:38',NULL,'ampere','6000','حسنين','4','0.00','1.50','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('346','حمزة طه','','','','','1','0','2025-12-25 14:35:03',NULL,'ampere','705','حسنين','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('347','خالد الزمار','','','','','1','0','2025-12-25 14:35:32',NULL,'ampere','714','حسنين','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('599','حمادي صالح','','','','','1','0','2025-12-27 06:56:35',NULL,'ampere','23','الميعاري','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('349','سلوى ابو شليح','','','','','1','0','2025-12-25 14:37:09',NULL,'ampere','702','حسنين','4','0.00','2.50','16.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('350','صلاح داوود','','','','','1','0','2025-12-25 14:37:36',NULL,'ampere','721','حسنين','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('351','صلاح عبد الهادي','','','','','1','0','2025-12-25 14:38:10',NULL,'ampere','719','حسنين','4','0.00','3.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('352','صيدلية سيلين','','','','موتير المحلات','1','0','2025-12-25 14:38:57',NULL,'ampere','6004','حسنين','4','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('353','عبد العفيس','','','','','1','0','2025-12-25 14:39:22',NULL,'ampere','707','حسنين','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('354','علي الجاسم','','','','','1','0','2025-12-25 14:39:47',NULL,'ampere','730','حسنين','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('355','علي الفرن','','','','','1','0','2025-12-25 14:40:11',NULL,'ampere','701','حسنين','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('356','غالب الشامي','','','','20 الشهر','1','0','2025-12-25 14:40:56',NULL,'ampere','716','حسنين','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('357','كرم الحسين','','','','','1','0','2025-12-25 14:41:20',NULL,'ampere','732','حسنين','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('358','محمصة الشامي','','','','موتير المحلات','1','0','2025-12-25 14:42:11',NULL,'ampere','6001','حسنين','4','0.00','6.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('359','محمد الكفري','','','','','1','0','2025-12-25 14:42:46',NULL,'ampere','728','حسنين','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('360','محمد غلايني','','','','','1','0','2025-12-25 14:43:14',NULL,'ampere','711','حسنين','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('361','محمد مصطفى','','','','','1','0','2025-12-25 14:43:42',NULL,'ampere','715','حسنين','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('362','محمد وحيد','','','','','1','0','2025-12-25 14:44:13',NULL,'ampere','729','حسنين','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('363','محمد وسام الحوت','','','','10 الشهر','1','0','2025-12-25 14:44:43',NULL,'ampere','712','حسنين','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('364','نعمة عيوطي','','','','','1','0','2025-12-25 14:45:09',NULL,'ampere','731','حسنين','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('365','ياسين فرن','','','','','1','0','2025-12-25 14:45:31',NULL,'ampere','7321','حسنين','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('366','احمد كساب','','','','','1','0','2025-12-25 14:47:05',NULL,'ampere','751','حليمة','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('367','الحجة ام محمود','','','','','1','1','2025-12-25 14:47:33',NULL,'ampere','779','حليمة','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('369','توفيق ابو سويد','','','','','1','0','2025-12-25 14:48:25',NULL,'ampere','748','حليمة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('370','صفاء الحلبي','','','','','1','0','2025-12-25 14:48:50',NULL,'ampere','750','حليمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('372','فادي حليمة','','','','','1','1','2025-12-25 14:49:50',NULL,'ampere','758','حليمة','4','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('373','فاطمة العرب','','','','','1','0','2025-12-25 14:50:19',NULL,'ampere','759','حليمة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('374','فوزي جمعة','','','','','1','0','2025-12-25 14:50:51',NULL,'ampere','766','حليمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('375','محمد حمود','','','','','1','0','2025-12-25 14:51:13',NULL,'ampere','763','حليمة','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('377','وسيم جار اهلي','','','','','1','0','2025-12-25 14:52:09',NULL,'ampere','749','حليمة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('378','يحيى العشي','','','','','1','0','2025-12-25 14:52:34',NULL,'ampere','755','حليمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('379','بلال دحويش','','','','','1','0','2025-12-25 15:01:09',NULL,'ampere','978','سالم الوالي','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('380','حسان شيخو','','','','','1','0','2025-12-25 15:01:32',NULL,'ampere','986','سالم الوالي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('381','حسن الحامد','','','','','1','0','2025-12-25 15:01:55',NULL,'ampere','975','سالم الوالي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('382','عبد الباسط ابراهيم','','','','','1','0','2025-12-25 15:02:23',NULL,'ampere','994','سالم الوالي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('385','عثمان الحامد','','','','','1','0','2025-12-25 15:03:43',NULL,'ampere','993','سالم الوالي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('386','فخري اسماعيل','','','','','1','0','2025-12-25 15:04:14',NULL,'ampere','988','سالم الوالي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('389','قاسم ابو زيد','','','','','1','0','2025-12-25 15:05:49',NULL,'ampere','987','سالم الوالي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('390','محمد الحامد','','','','','1','0','2025-12-25 15:06:12',NULL,'ampere','976','سالم الوالي','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('392','ابراهيم الحلبي','','','','','1','0','2025-12-25 15:08:18',NULL,'ampere','894','صيدلية فاطمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('393','ابو الوليد ','','','','','1','0','2025-12-25 15:08:41',NULL,'ampere','892','صيدلية فاطمة','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('394','ابو سهيل','','','','','1','0','2025-12-25 15:09:07',NULL,'ampere','896','صيدلية فاطمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('395','امبوبا','','','','','1','1','2025-12-25 15:09:42',NULL,'ampere','899','صيدلية فاطمة','4','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('396','امبوبا 2','','','','موتير المحلات','1','0','2025-12-25 15:10:23',NULL,'ampere','898-1','صيدلية فاطمة','4','0.00','5.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('397','جابر مقدسي','','','','','1','0','2025-12-25 15:10:49',NULL,'ampere','902','صيدلية فاطمة','4','0.00','10.00','31.50','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('398','دكتور محمد عيادة','','','','موتير المحلات','1','0','2025-12-25 15:11:22',NULL,'ampere','897','صيدلية فاطمة','4','0.00','5.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('400','صالون ليا','','','','','1','0','2025-12-25 15:12:09',NULL,'ampere','900','صيدلية فاطمة','4','0.00','2.50','0.00','0.00','87.50','0.00');
INSERT INTO `customers` VALUES ('401','علي ابو جاموس','','','','','1','0','2025-12-25 15:12:33',NULL,'ampere','901','صيدلية فاطمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('403','ام محمد','','','','','1','0','2025-12-25 15:13:51',NULL,'ampere','606','عاطف','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('404','حمد الصفري','','','','','1','0','2025-12-25 15:14:15',NULL,'ampere','615','عاطف','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('405','عاطف','','','','','1','1','2025-12-25 15:14:36',NULL,'ampere','605','عاطف','4','0.00','17.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('817','سارة مقداد','','','','','1','0','2026-03-30 03:38:37',NULL,'ampere','687','البليار','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('407','علاء عابد علي','','','','','1','0','2025-12-25 15:15:28',NULL,'ampere','609','عاطف','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('408','غسان عبد الهادي','','','','','1','0','2025-12-25 15:16:03',NULL,'ampere','610','عاطف','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('409','محمد خليل','','','','','1','0','2025-12-25 15:16:27',NULL,'ampere','608','عاطف','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('410','منال العفيفي','','','','','1','0','2025-12-25 15:16:55',NULL,'ampere','613','عاطف','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('411','ابراهيم الخضر ','','','','','1','0','2025-12-25 15:24:59',NULL,'ampere','805','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('412','ابو شملي','','','','','1','0','2025-12-25 15:25:26',NULL,'ampere','786','عبد سلامة','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('413','احمد النجار','','','','','1','0','2025-12-25 15:25:58',NULL,'ampere','791','عبد سلامة','4','0.00','2.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('414','احمد اليوسف','','','','','1','0','2025-12-25 15:26:27',NULL,'ampere','803','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('416','احمد غدار','','','','','1','0','2025-12-25 15:27:23',NULL,'ampere','782','عبد سلامة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('417','احمد غدار 1','','','','','1','0','2025-12-25 15:28:52',NULL,'ampere','795','عبد سلامة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('418','اشرف الحريري','','','','','1','0','2025-12-25 15:29:28',NULL,'ampere','787','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('420','ام خالد البرجا','','','','','1','0','2025-12-25 15:30:54',NULL,'ampere','799','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('421','ام رشيد بعلبي','','','','','1','1','2025-12-25 15:31:44',NULL,'ampere','800','عبد سلامة','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('422','باسل ناصر','','','','','1','0','2025-12-25 15:33:23',NULL,'ampere','810','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('423','بسام النجار','','','','بالعلبة 3 امبير','1','0','2025-12-25 15:34:31',NULL,'ampere','793','عبد سلامة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('424','حسين الحديدي','','','','','1','0','2025-12-25 15:35:30',NULL,'ampere','789','عبد سلامة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('425','حليمة','','','','','1','0','2025-12-25 15:36:06',NULL,'ampere','792','عبد سلامة','4','0.00','7.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('426','حمزة جاد','','','','','1','0','2025-12-25 15:36:48',NULL,'ampere','783','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('428','عصام عبد العال','','','','','1','0','2025-12-25 15:38:05',NULL,'ampere','781','عبد سلامة','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('429','علاء دياب','','','','','1','0','2025-12-25 15:38:31',NULL,'ampere','802','عبد سلامة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('430','عماد حمد','','','','بالعلبة 3 امبير','1','0','2025-12-25 15:39:12',NULL,'ampere','785','عبد سلامة','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('431','عماد ندوة','','','','','1','0','2025-12-25 15:39:53',NULL,'ampere','780','عبد سلامة','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('432','مالك عقلة','','','','','1','0','2025-12-25 15:40:17',NULL,'ampere','796','عبد سلامة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('754','محمد الجوني','','','','','1','0','2026-01-08 08:42:48',NULL,'ampere','798','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('839','وائل الحريري','','','','','1','0','2026-04-28 05:11:23',NULL,'ampere','814','ابو باهي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('437','ندى عبد الرحيم','','','','بالعلبة 4 امبير','1','0','2025-12-25 15:43:29',NULL,'ampere','788','عبد سلامة','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('438','هاني المصري','','','','','1','0','2025-12-25 15:44:09',NULL,'ampere','797','عبد سلامة','4','0.00','6.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('439','هدى العزبة','','','','','1','1','2025-12-25 15:44:39',NULL,'ampere','784','عبد سلامة','4','0.00','1.00','0.00','0.00','110.00','0.00');
INSERT INTO `customers` VALUES ('837','سماح باكير','','','','','1','0','2026-04-27 10:27:08',NULL,'ampere','847','ابو وسيم فرحات','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('441','ابو صالح','','','','','1','0','2025-12-25 15:46:43',NULL,'ampere','1292','قاعة الشعب','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('442','احمد العمر','','','','','1','0','2025-12-25 15:47:18',NULL,'ampere','1303','قاعة الشعب','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('443','الخال ابو فارس','','','','','1','0','2025-12-25 15:47:52',NULL,'ampere','1299','قاعة الشعب','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('444','توفيق شرشرة','','','','','1','0','2025-12-25 15:48:16',NULL,'ampere','1301','قاعة الشعب','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('445','حسن المزيد','','','','','1','0','2025-12-25 15:48:38',NULL,'ampere','1304','قاعة الشعب','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('446','حسن دوالي','','','','','1','1','2025-12-25 15:49:05',NULL,'ampere','1295','قاعة الشعب','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('447','حسن كنعان','','','','','1','0','2025-12-25 15:49:32',NULL,'ampere','1317','قاعة الشعب','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('448','درويش شنير','','','','','1','0','2025-12-25 15:50:26',NULL,'ampere','1296','قاعة الشعب','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('450','رضوان الاحمد','','','','','1','0','2025-12-25 15:51:23',NULL,'ampere','1318','قاعة الشعب','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('451','زكريا خانتوماني','','','','','1','0','2025-12-25 15:52:14',NULL,'ampere','1293','قاعة الشعب','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('452','عبد السلام غنام','','','','','1','0','2025-12-25 15:52:40',NULL,'ampere','1298','قاعة الشعب','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('453','علي ابو عزئة','','','','','1','1','2025-12-25 15:53:04',NULL,'ampere','1306','قاعة الشعب','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('454','عمار حمادة','','','','','1','0','2025-12-25 15:53:28',NULL,'ampere','1307','قاعة الشعب','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('455','عمر المزيد','','','','','1','0','2025-12-25 15:53:52',NULL,'ampere','1302-1','قاعة الشعب','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('456','محمود عادل بيتو','','','','','1','1','2025-12-25 15:54:47',NULL,'ampere','1313','قاعة الشعب','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('457','محمود عادل','','','','','1','0','2025-12-25 15:55:50',NULL,'ampere','1294','قاعة الشعب','4','0.00','2.50','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('459','نجوى حزينة','','','','','1','0','2025-12-25 15:56:43',NULL,'ampere','1305','قاعة الشعب','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('460','نشأت مرة','','','','','1','0','2025-12-25 15:57:09',NULL,'ampere','1308','قاعة الشعب','4','0.00','3.00','33.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('461','ابو ايمن حبوش','','','','','1','0','2025-12-25 15:58:45',NULL,'ampere','453','محلنا','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('462','ابو علي فرن','','','','','1','0','2025-12-25 15:59:07',NULL,'ampere','448','محلنا','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('463','ابو فادي المسمط','','','','موتير المحلات','1','1','2025-12-25 15:59:50',NULL,'ampere','454','محلنا','4','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('464','ابو قاسم عبد الهادي','','','','','1','0','2025-12-25 16:00:48',NULL,'ampere','460','محلنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('465','احمد الصالح','','','','','1','0','2025-12-25 16:01:10',NULL,'ampere','449','محلنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('466','احمد عبد الله الحسن','','','','','1','0','2025-12-25 16:01:41',NULL,'ampere','468','محلنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('467','احمد ناصر','','','','','1','0','2025-12-25 16:02:22',NULL,'ampere','4771','محلنا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('468','اروى','','','','','1','0','2025-12-25 16:02:44',NULL,'ampere','467','محلنا','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('469','اسامة محل','','','','موتير المحلات','1','1','2025-12-25 16:03:20',NULL,'ampere','447','محلنا','4','0.00','20.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('470','الدكتور خليل','','','','','1','1','2025-12-25 16:03:49',NULL,'ampere','456','محلنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('471','الصالحاني','','','','','1','0','2025-12-25 16:04:16',NULL,'ampere','452','محلنا','4','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('472','ام لولو','','','','','1','0','2025-12-25 16:04:38',NULL,'ampere','459','محلنا','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('473','ام هاني السواس','','','','','1','0','2025-12-25 16:05:06',NULL,'ampere','475','محلنا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('474','بسام عبد الهادي','','','','','1','0','2025-12-25 16:05:43',NULL,'ampere','4550','محلنا','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('819','محمود احمد العبد','','','','','1','0','2026-03-31 06:56:32',NULL,'ampere','1109','ابو باهي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('476','بلال اخو عاطف','','','','','1','0','2025-12-25 16:06:55',NULL,'ampere','446','محلنا','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('477','جامع التقوى','','','','','1','1','2025-12-25 16:07:32',NULL,'ampere','450','محلنا','4','0.00','6.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('478','جهاد عبد الهادي','','','','موتير المحلات','1','0','2025-12-25 16:08:15',NULL,'ampere','465','محلنا','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('480','زجاج','','','','','1','0','2025-12-25 16:09:14',NULL,'ampere','445','محلنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('481','سمية عبد الهادي','','','','','1','0','2025-12-25 16:09:42',NULL,'ampere','455','محلنا','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('482','شادي ابو القطن','','','','','1','0','2025-12-25 16:10:15',NULL,'ampere','477','محلنا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('483','عبد شراب','','','','','1','0','2025-12-25 16:10:49',NULL,'ampere','458','محلنا','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('818','وليد عبارة','','','','','1','0','2026-03-30 06:40:27',NULL,'ampere','1279','ابو نصرا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('485','فارس خليفة','','','','','1','0','2025-12-25 16:11:40',NULL,'ampere','476','محلنا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('486','ليث محمد','','','','','1','0','2025-12-25 16:12:03',NULL,'ampere','466','محلنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('488','محمد الشريف','','','','','1','0','2025-12-25 16:12:52',NULL,'ampere','471','محلنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('489','محمود حنجول','','','','','1','0','2025-12-25 16:13:24',NULL,'ampere','464','محلنا','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('490','محمود ديراوي','','','','','1','0','2025-12-25 16:13:48',NULL,'ampere','462','محلنا','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('491','وليد عثمان','','','','','1','0','2025-12-25 16:14:30',NULL,'ampere','463','محلنا','4','0.00','1.00','45.00','0.00','40.00','0.00');
INSERT INTO `customers` VALUES ('492','ابو جلال المورق','','','','','1','0','2025-12-25 16:18:02',NULL,'ampere','1020','نفيسة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('493','ابو صادق خنزالا','','','','','1','0','2025-12-25 16:18:31',NULL,'ampere','1008','نفيسة','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('494','احمد اسماعيل','','','','','1','0','2025-12-25 16:19:10',NULL,'ampere','1011','نفيسة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('495','احمد محمود الحافي','','','','','1','0','2025-12-25 16:19:38',NULL,'ampere','1023','نفيسة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('497','ام حسن نفيسة','','','','','1','0','2025-12-25 16:20:37',NULL,'ampere','1004','نفيسة','4','0.00','6.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('498','حسين الصفح','','','','','1','0','2025-12-25 16:21:06',NULL,'ampere','1015','نفيسة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('499','رائد ابراهيم','','','','','1','0','2025-12-25 16:21:31',NULL,'ampere','1010','نفيسة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('500','شادي السقا','','','','','1','0','2025-12-25 16:21:58',NULL,'ampere','1003','نفيسة','4','0.00','5.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('501','علي الشريف','','','','','1','0','2025-12-25 16:22:20',NULL,'ampere','1014','نفيسة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('502','فضيلة الجربي','','','','17 الشهر','1','0','2025-12-25 16:22:52',NULL,'ampere','1009','نفيسة','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('503','محمد الداعوق','','','','','1','0','2025-12-25 16:23:51',NULL,'ampere','1012','نفيسة','4','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('504','محمود الاسمر','','','','','1','0','2025-12-25 16:24:23',NULL,'ampere','1017','نفيسة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('505','مهند العمر','','','','','1','0','2025-12-25 16:24:49',NULL,'ampere','1021','نفيسة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('506','وسيم العلي','','','','','1','0','2025-12-25 16:25:13',NULL,'ampere','1013','نفيسة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('508','العسكري','','','','','1','0','2025-12-25 16:26:37',NULL,'ampere','522','وائل الغوراني','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('510','شادي عسلي','','','','','1','0','2025-12-25 16:27:24',NULL,'ampere','511','وائل الغوراني','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('511','طه الناصر','','','','','1','0','2025-12-25 16:27:50',NULL,'ampere','523','وائل الغوراني','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('512','طه لوباني','','','','','1','0','2025-12-25 16:28:12',NULL,'ampere','513','وائل الغوراني','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('513','عايد الحنشول','','','','','1','0','2025-12-25 16:28:43',NULL,'ampere','519','وائل الغوراني','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('514','عبد الله العلي','','','','','1','0','2025-12-25 16:29:10',NULL,'ampere','521','وائل الغوراني','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('516','محمود ابراهيم ابو عيد','','','','','1','0','2025-12-25 16:30:04',NULL,'ampere','514','وائل الغوراني','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('517','محمود جانا','','','','','1','0','2025-12-25 16:30:30',NULL,'ampere','515','وائل الغوراني','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('518','نور ديراوي','','','','','1','0','2025-12-25 16:30:58',NULL,'ampere','509','وائل الغوراني','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('519','وائل الغوراني','','','','','1','1','2025-12-25 16:31:24',NULL,'ampere','516','وائل الغوراني','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('520','ياسر الحسين','','','','','1','0','2025-12-25 16:31:49',NULL,'ampere','517','وائل الغوراني','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('521','محمد حواش','','','','','1','0','2025-12-26 03:33:32',NULL,'meter','170','الحنون','4','1146.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('522','ماهر عبادي','','','','','1','0','2025-12-26 03:34:15',NULL,'meter','499','الاسطبل','4','2910.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('523','غسان الدبوري','','','','','1','0','2025-12-26 03:35:51',NULL,'meter','898-2','صيدلية فاطمة','4','300.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('524','محمود دوالي','','','','','1','0','2025-12-26 03:36:46',NULL,'meter','1297','قاعة الشعب','4','21281.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('525','بلال دوالي','','','','','1','0','2025-12-26 03:37:36',NULL,'meter','1310','قاعة الشعب','4','4618.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('526','محمود دخان ','','','','','1','0','2025-12-26 03:38:27',NULL,'meter','161','الحنون','4','7150.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('527','حسن حجار','','','','','1','0','2025-12-26 03:39:00',NULL,'meter','162','الحنون','4','6078.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('528','خضر مهاوش','','','','','1','0','2025-12-26 03:39:39',NULL,'meter','163','الحنون','4','6140.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('529','محمود دخان 1','','','','','1','0','2025-12-26 03:40:17',NULL,'meter','164','الحنون','4','3714.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('530','احمد الاتب','','','','','1','0','2025-12-26 03:40:42',NULL,'meter','166','الحنون','4','4220.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('531','ياسين ابو سعدو','','','','','1','0','2025-12-26 03:41:14',NULL,'meter','167','الحنون','4','5326.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('532','محمد زيحو','','','','','1','0','2025-12-26 03:42:04',NULL,'meter','182-1','الحنون','4','152.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('533','ابو عماد المصري','','','','','1','0','2025-12-26 03:42:41',NULL,'meter','1351','الجهاد','4','5611.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('534','احمد ابو شلحة','','','','','1','0','2025-12-26 03:43:09',NULL,'meter','813','ابو باهي','4','6628.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('535','الفرا','','','','','1','0','2025-12-26 03:46:09',NULL,'meter','582','حاتم','4','5022.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('536','خالد سكجها','','','','','1','0','2025-12-26 03:46:50',NULL,'meter','1231','الحايك','4','5995.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('537','علاء سعد','','','','','1','0','2025-12-26 03:47:21',NULL,'meter','968','سالم الوالي','4','5621.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('538','فريال المصري','','','','','1','0','2025-12-26 03:47:53',NULL,'meter','969','سالم الوالي','4','2944.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('539','مصطفى السلو','','','','','1','0','2025-12-26 03:48:24',NULL,'meter','970','سالم الوالي','4','8074.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('540','طارق السيد','','','','','1','0','2025-12-26 03:48:49',NULL,'meter','1005','نفيسة','4','5504.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('541','ابو وائل','','','','','1','0','2025-12-26 03:49:12',NULL,'meter','1006','نفيسة','4','6861.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('542','حسن نفيسة','','','','','1','0','2025-12-26 03:49:41',NULL,'meter','1007','نفيسة','4','9013.00','6.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('543','محمود عثمان','','','','','1','0','2025-12-26 03:50:12',NULL,'meter','1124','جمال قداح','4','6830.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('544','عيسى الموسى','','','','','1','0','2025-12-26 03:50:45',NULL,'meter','666','العيوطي','4','5311.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('545','الصفوري المطهر','','','','','1','0','2025-12-26 03:51:37',NULL,'meter','667','العيوطي','4','4140.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('546','عمر سعد','','','','','1','1','2025-12-26 03:52:03',NULL,'meter','807','عبد سلامة','4','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('547','عمة فخري','','','','','1','0','2025-12-26 03:52:28',NULL,'meter','808','عبد سلامة','4','6486.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('548','محمد السنغري','','','','','1','0','2025-12-26 03:53:00',NULL,'meter','1209','ابو تركي','4','4293.00','2.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('549','عيادة الكاشف','','','','','1','0','2025-12-26 03:56:26',NULL,'meter','49','سريس','4','11555.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('830','دكتور بكر','','','','بالعلبة 9 امبير موتير النهار','1','0','2026-04-14 06:06:02',NULL,'ampere','193','فايز لداوي','4','0.00','9.00','20.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('551','علي قاسم','','','','','1','0','2025-12-26 03:57:35',NULL,'meter','261','بركة','4','5429.00','6.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('552','خالد عبيد','','','','','1','0','2025-12-26 03:58:51',NULL,'meter','2000','محلنا','4','6571.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('553','ابو داوود','','','','','1','0','2025-12-26 03:59:32',NULL,'meter','2001-2','محلنا','4','10498.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('554','ام العبد','','','','','1','0','2025-12-26 03:59:58',NULL,'meter','2002','محلنا','4','6247.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('555','ابو جلال جارنا','','','','','1','0','2025-12-26 04:00:27',NULL,'meter','2003','محلنا','4','10429.00','6.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('556','حسن الشاملي','','','','','1','0','2025-12-26 04:00:54',NULL,'meter','2005','محلنا','4','4504.00','5.00','0.00','390000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('557','محمد الصافي','','','','','1','0','2025-12-26 04:03:56',NULL,'meter','001','صبرا','4','1476.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('558','نادر حمود','','','','','1','0','2025-12-26 04:04:36',NULL,'meter','1309','قاعة الشعب','4','157.00','5.00','0.00','390000.00','0.00','150.00');
INSERT INTO `customers` VALUES ('814','زكريا محمد','','','','','1','0','2026-03-29 12:42:00',NULL,'ampere','806','عبد سلامة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('815','جمعة العمر ','','','','','1','0','2026-03-29 12:58:51',NULL,'ampere','1468','التضامن','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('560','ابو عطا ','','','','من عند ابو برهان ست شهور بنص القيمة من تاريخ 1/1/2026','1','0','2025-12-26 04:09:03',NULL,'ampere','1315','قاعة الشعب','4','0.00','2.00','17.50','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('561','داوود','','','','','1','0','2025-12-26 04:11:12',NULL,'meter','682-2','البليار','4','0.00','5.00','0.00','390000.00','0.00','150.00');
INSERT INTO `customers` VALUES ('562','محمود غزلان ','','','','','1','0','2025-12-26 04:11:47',NULL,'meter','1128','جمال قداح','4','0.00','5.00','0.00','390000.00','0.00','150.00');
INSERT INTO `customers` VALUES ('563','ابو جعفر','','','','','1','0','2025-12-26 07:19:57',NULL,'ampere','182-2','ابو زرد','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('594','	أحمد الصالح','','','','','1','0','2025-12-27 06:53:08',NULL,'ampere','14','الميعاري','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('595','	ابو عزيز','','','','','1','1','2025-12-27 06:54:26',NULL,'ampere','13','الميعاري','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('598','حسين ديب حسين','','','','','1','0','2025-12-27 06:56:08',NULL,'ampere','6','الميعاري','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('596','جمال ميعاري','','','','','1','1','2025-12-27 06:55:01',NULL,'ampere','9','الميعاري','5','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('564','حسين الليداوي','','','','','1','1','2025-12-26 07:22:58',NULL,'ampere','1810','ابو زرد','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('565','صيدلية فاطمة','','','','','1','0','2025-12-26 07:28:54',NULL,'ampere','1790','ابو زرد','5','0.00','7.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('566','صيدلية محمد  الميعاري','','','','موتير محلات','1','0','2025-12-26 07:32:23',NULL,'ampere','164','ابو زرد','5','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('808','فادي عرنوس','','','','نص اسامة نص فادي','1','0','2026-03-26 10:44:15',NULL,'ampere','1071','الكفاح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('568','عيادة خليل','','','','موتيير محلات','1','0','2025-12-26 07:37:02',NULL,'ampere','163','ابو زرد','5','0.00','5.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('569','كمال  ابراهيم','','','','','1','0','2025-12-26 07:38:07',NULL,'ampere','180','ابو زرد','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('570','احمد الخطيب','','','','','1','0','2025-12-26 07:39:59',NULL,'ampere','396','الساحة','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('571','بسام سعدين','','','','','1','0','2025-12-26 07:41:06',NULL,'ampere','400','الساحة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('572','جمال عابد','','','','','1','0','2025-12-26 07:42:06',NULL,'ampere','390','الساحة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('800','هادي حدادة','','','','','1','0','2026-03-02 07:46:28',NULL,'ampere','554','ابو رصاص','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('574','منار','','','','','1','0','2025-12-26 07:56:02',NULL,'ampere','1770','ابو زرد','5','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('575','سعيد سعيد','','','','','1','0','2025-12-26 07:57:12',NULL,'ampere','402','الساحة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('576','فاروق يونس','','','','','1','0','2025-12-26 07:57:53',NULL,'ampere','392','الساحة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('577','فريال','','','','','1','0','2025-12-26 07:58:30',NULL,'ampere','401','الساحة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('578','محمد  الشاويش','','','','','1','0','2025-12-26 07:59:13',NULL,'ampere','391','الساحة','5','0.00','4.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('579','محمد غربي خنيفس','','','','','1','0','2025-12-26 08:00:01',NULL,'ampere','394','الساحة','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('580','ميسر  عجينة','','','','','1','0','2025-12-26 08:00:55',NULL,'ampere','403','الساحة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('581','ابو كمال اللحام','','','','محلات','1','0','2025-12-26 10:12:15',NULL,'ampere','121','الكردي','5','0.00','10.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('582','	ابو نايف','','','','','1','0','2025-12-26 10:12:51',NULL,'ampere','101','الكردي','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('583','ابو وسيم','','','','محلات','1','0','2025-12-26 10:13:42',NULL,'ampere','122','الكردي','5','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('785','احمد عجينة','','','','','1','0','2026-01-26 12:06:42',NULL,'ampere','277','حمود','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('585','اضاءة زاروبة الكردي','','','','اضاءة زاروبة الكردي (1) ','1','1','2025-12-26 10:15:49',NULL,'ampere','118','الكردي','5','0.00','1.00','45.00','0.00','33.00','0.00');
INSERT INTO `customers` VALUES ('586','حمزة تبعنا','','','','','1','1','2025-12-26 10:17:04',NULL,'ampere','112','الكردي','5','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('587','	سعيد الرحيل','','','','','1','0','2025-12-26 10:17:45',NULL,'ampere','113','الكردي','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('588','طاهر الكردي','','','','','1','0','2025-12-26 10:18:27',NULL,'ampere','115','الكردي','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('589','عبد الله الكردي','','','','','1','0','2025-12-26 10:19:01',NULL,'ampere','116','الكردي','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('590','عبد الله محميد','','','','','1','0','2025-12-26 10:19:35',NULL,'ampere','99','الكردي','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('591','عدنان خميس','','','','','1','0','2025-12-26 10:20:35',NULL,'ampere','103','الكردي','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('592','محمد الدبدوب','','','','','1','1','2025-12-26 10:21:35',NULL,'ampere','97','الكردي','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('752','حسين علي رمضان','','','','','1','0','2026-01-02 10:49:27',NULL,'ampere','768','حليمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('603','علي خضر','','','','','1','0','2025-12-27 06:59:29',NULL,'ampere','25','الميعاري','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('604','عيادة رزان','','','','محلات','1','0','2025-12-27 07:00:12',NULL,'ampere','11','الميعاري','5','0.00','7.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('605','فوزي كردي','','','','','1','0','2025-12-27 07:02:33',NULL,'ampere','4','الميعاري','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('606','كوري','','','','','1','0','2025-12-27 07:03:43',NULL,'ampere','21','الميعاري','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('608','نادرة محسن','','','','','1','0','2025-12-27 07:06:17',NULL,'ampere','18','الميعاري','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('609','وسام الميعاري انارة','','','','','1','1','2025-12-27 07:07:37',NULL,'ampere','2','الميعاري','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('611','انارة وسام لداوي','','','','','1','1','2025-12-27 07:10:11',NULL,'ampere','279','بركة','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('612','	بسام المصري','','','','','1','0','2025-12-27 07:10:43',NULL,'ampere','262','بركة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('613','تيسير يساوي','','','','','1','0','2025-12-27 07:11:10',NULL,'ampere','273','بركة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('614','	حسناوي مصطفى','','','','','1','0','2025-12-27 07:11:59',NULL,'ampere','264','بركة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('616','	عبدو ابو زكريا','','','','','1','0','2025-12-27 07:13:25',NULL,'ampere','276','بركة','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('749','محمد المصري','','','','','1','0','2025-12-31 03:21:50',NULL,'ampere','914','الجامع','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('619','نجيب سعيد','','','','','1','0','2025-12-27 07:20:29',NULL,'ampere','274','بركة','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('620','يوسف البازي','','','','','1','0','2025-12-27 07:22:31',NULL,'ampere','258','بركة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('621','ابو جعفر محل','','','','محلات','1','0','2025-12-27 07:23:15',NULL,'ampere','5016','بشار','5','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('622','ابو عبدو الخياط','','','','محلات','1','0','2025-12-27 07:23:43',NULL,'ampere','5004','بشار','5','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('623','احمد ابو صالح','','','','محلات','1','0','2025-12-27 07:29:30',NULL,'ampere','5013','بشار','5','0.00','1.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('624','ام احمد الخياطة','','','','محلات','1','0','2025-12-27 07:30:06',NULL,'ampere','5010','بشار','5','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('626','	ام علي مجزوب','','','','','1','0','2025-12-27 07:32:33',NULL,'ampere','86','بشار','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('628','بلال لداوي','','','','محلات','1','1','2025-12-27 07:37:25',NULL,'ampere','5015','بشار','5','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('629','حافظ الشامي','','','','','1','0','2025-12-27 07:38:19',NULL,'ampere','66','بشار','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('630','	حج الوحش','','','','','1','0','2025-12-27 07:38:41',NULL,'ampere','65','بشار','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('631','حلويات ابو عبدو','','','','محلات','1','0','2025-12-27 07:39:17',NULL,'ampere','5011','بشار','5','0.00','4.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('632','شاوي دخان','','','','','1','0','2025-12-27 07:39:42',NULL,'ampere','83','بشار','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('633','صيدلية احمد ميعاري','','','','محلات','1','0','2025-12-27 07:40:20',NULL,'ampere','5002','بشار','5','0.00','5.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('634','صيدلية الصفوري','','','','محلات','1','0','2025-12-27 07:41:07',NULL,'ampere','5020','بشار','5','0.00','6.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('635','صيدلية النغم','','','','محلات','1','0','2025-12-27 07:41:46',NULL,'ampere','5018','بشار','5','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('636','عبد الله الحلاق','','','','محلات','1','0','2025-12-27 07:42:21',NULL,'ampere','5014','بشار','5','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('637','عدي سنترال','','','','محلات','1','0','2025-12-27 07:42:49',NULL,'ampere','5001','بشار','5','0.00','5.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('638','علي الميعاري','','','','','1','1','2025-12-27 07:43:21',NULL,'ampere','70','بشار','5','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('639','عيادة اللؤلؤة','','','','محلات','1','0','2025-12-27 07:43:57',NULL,'ampere','5009','بشار','5','0.00','5.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('640','عيادة نغم','','','','محلات','1','0','2025-12-27 07:44:30',NULL,'ampere','5005','بشار','5','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('642','مجدي مجزوب','','','','','1','0','2025-12-27 07:45:22',NULL,'ampere','82','بشار','5','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('643','	محمد خضر','','','','','1','0','2025-12-27 07:45:40',NULL,'ampere','77','بشار','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('644','محمد عبد الله','','','','','1','0','2025-12-27 07:46:06',NULL,'ampere','80','بشار','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('645','محمود عثمان','','','','','1','0','2025-12-27 07:46:29',NULL,'ampere','68','بشار','5','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('648','مصطفى العلي','','','','','1','0','2025-12-27 07:50:37',NULL,'ampere','71','بشار','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('649','ممدوح الحلو','','','','','1','0','2025-12-27 07:52:46',NULL,'ampere','209','بناية فايز','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('652','ممدوح ضاهر','','','','','1','0','2025-12-27 07:59:57',NULL,'ampere','67','بشار','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('810','بسام رمضان','','','','','1','0','2026-03-26 12:34:37',NULL,'ampere','794','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('654','يحيى مخلف','','','','','1','0','2025-12-27 08:02:22',NULL,'ampere','69','بشار','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('734','محمود العلي','','','','','1','0','2025-12-27 12:47:40',NULL,'ampere','209','بناية فايز','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('656','اسماعيل عمر','','','','','1','0','2025-12-27 09:56:40',NULL,'ampere','214','بناية فايز','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('660','ام نمر','','','','','1','0','2025-12-27 10:36:01',NULL,'ampere','218','بناية فايز','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('661','	جمال الجبر','','','','','1','0','2025-12-27 10:36:32',NULL,'ampere','201','بناية فايز','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('662','جمعة عبد الرحمن','','','','','1','0','2025-12-27 11:12:43',NULL,'ampere','202','بناية فايز','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('663','خليل حمدو','','','','','1','0','2025-12-27 11:13:16',NULL,'ampere','194','بناية فايز','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('664','علي العلي','','','','','1','0','2025-12-27 11:13:51',NULL,'ampere','211','بناية فايز','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('665','عماد الحمد','','','','','1','0','2025-12-27 11:14:17',NULL,'ampere','213','بناية فايز','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('666','محمد الحمصي','','','','','1','0','2025-12-27 11:14:50',NULL,'ampere','217','بناية فايز','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('667','محمد العبد','','','','','1','0','2025-12-27 11:15:21',NULL,'ampere','200','بناية فايز','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('751','احمد كنبور','','','','','1','0','2026-01-02 10:30:12',NULL,'ampere','1341','الجهاد','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('669','ملحمة البوكمال','','','','','1','0','2025-12-27 11:16:40',NULL,'ampere','215','بناية فايز','5','0.00','8.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('670','	مهند وكاع','','','','','1','0','2025-12-27 11:17:14',NULL,'ampere','219','بناية فايز','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('671','ابو محمد خليل','','','','','1','0','2025-12-27 11:26:43',NULL,'ampere','234','حمود','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('672','احمد الفتي','','','','','1','0','2025-12-27 11:27:26',NULL,'ampere','229','حمود','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('673','بدر تبعنا','','','','','1','1','2025-12-27 11:28:35',NULL,'ampere','240','حمود','5','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('674','رمضان وكاع','','','','','1','0','2025-12-27 11:29:01',NULL,'ampere','233','حمود','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('676','سمير عدلوني','','','','','1','0','2025-12-27 11:30:25',NULL,'ampere','242','حمود','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('677','سمير كيوف','','','','','1','0','2025-12-27 11:30:51',NULL,'ampere','225','حمود','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('678','عيسى ابو محمد','','','','','1','0','2025-12-27 11:31:22',NULL,'ampere','247','حمود','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('679','محمد شلحة','','','','','1','0','2025-12-27 11:32:02',NULL,'ampere','226','حمود','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('680','مصطفى الصالح','','','','','1','0','2025-12-27 11:32:39',NULL,'ampere','232','حمود','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('681','الشاوي','','','','','1','0','2025-12-27 11:33:25',NULL,'ampere','36','سريس','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('682','انس الحاج','','','','','1','0','2025-12-27 11:33:57',NULL,'ampere','55','سريس','5','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('683','حسام الجزيرة','','','','','1','0','2025-12-27 11:34:41',NULL,'ampere','40','سريس','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('840','محمد بسيوني','','','','','1','0','2026-04-28 11:58:48',NULL,'ampere','809','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('686','شحادة','','','','','1','0','2025-12-27 11:37:01',NULL,'ampere','54','سريس','5','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('687','	مرعي الحج','','','','','1','0','2025-12-27 11:37:49',NULL,'ampere','51','سريس','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('688','وائل عمبر','','','','','1','0','2025-12-27 11:38:22',NULL,'ampere','58','سريس','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('689','يوسف ابو نور','','','','','1','0','2025-12-27 11:38:49',NULL,'ampere','41','سريس','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('690','ام خالد جهجاه','','','','','1','0','2025-12-27 11:39:45',NULL,'ampere','435','عبد اللطيف','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('691','انارة','','','','','1','1','2025-12-27 11:40:57',NULL,'ampere','434','عبد اللطيف','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('692','خطاب العيسى','','','','','1','0','2025-12-27 11:41:20',NULL,'ampere','431','عبد اللطيف','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('693','زهير شرف الدين','','','','','1','0','2025-12-27 11:41:59',NULL,'ampere','429','عبد اللطيف','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('694','علي قصاص','','','','','1','0','2025-12-27 11:42:31',NULL,'ampere','433','عبد اللطيف','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('695','ابراهيم العمر','','','','','1','0','2025-12-27 11:43:39',NULL,'ampere','337',' اللداوي زاروبة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('696','ام احمد عودة','','','','','1','0','2025-12-27 11:52:12',NULL,'ampere','331',' اللداوي زاروبة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('697','ام محمد جويري','','','','','1','0','2025-12-27 11:52:34',NULL,'ampere','328',' اللداوي زاروبة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('698','تيسر رمضان','','','','','1','0','2025-12-27 11:53:01',NULL,'ampere','340',' اللداوي زاروبة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('699','حسين الخلف','','','','','1','0','2025-12-27 11:53:32',NULL,'ampere','343',' اللداوي زاروبة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('700','ربيع قناص','','','','','1','0','2025-12-27 11:54:56',NULL,'ampere','325',' اللداوي زاروبة','5','0.00','3.00','15.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('701','علي مرعي','','','','','1','0','2025-12-27 11:55:48',NULL,'ampere','327',' اللداوي زاروبة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('702','فواز الوف','','','','','1','0','2025-12-27 11:56:18',NULL,'ampere','338',' اللداوي زاروبة','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('703','محمد سعيد الحسين','','','','','1','0','2025-12-27 11:56:53',NULL,'ampere','330',' اللداوي زاروبة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('704','محمود الراشد','','','','','1','0','2025-12-27 11:57:41',NULL,'ampere','336',' اللداوي زاروبة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('705','مصطفى القناص','','','','','1','0','2025-12-27 11:58:11',NULL,'ampere','324',' اللداوي زاروبة','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('707','ياسر الخلف','','','','','1','0','2025-12-27 11:59:13',NULL,'ampere','333',' اللداوي زاروبة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('708','نوال','','','','','1','0','2025-12-27 12:00:30',NULL,'ampere','7001','علبة نوال','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('710','ام محمود الوحش','','','','','1','1','2025-12-27 12:02:47',NULL,'ampere','305','كامل سليم','5','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('711','خالد اسكندراني','','','','','1','0','2025-12-27 12:03:15',NULL,'ampere','313','كامل سليم','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('712','صقر أبو صافي','','','','','1','0','2025-12-27 12:03:55',NULL,'ampere','310','كامل سليم','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('713','عبد أبو صافي','','','','','1','0','2025-12-27 12:04:24',NULL,'ampere','309','كامل سليم','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('715','كمال ابراهيم','','','','','1','0','2025-12-27 12:05:22',NULL,'ampere','290','كامل سليم','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('716','محمد إبراهيم','','','','','1','0','2025-12-27 12:05:57',NULL,'ampere','306','كامل سليم','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('717','	محمد عفيفي بيت','','','','','1','0','2025-12-27 12:06:33',NULL,'ampere','289','كامل سليم','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('718','عيادة الشفاء','','','','محلات','1','0','2025-12-27 12:07:37',NULL,'ampere','137','كريمة','5','0.00','4.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('719','قاسم محمصة المحبة','','','','','1','0','2025-12-27 12:08:14',NULL,'ampere','150','كريمة','5','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('720','محمد حمزة','','','','','1','0','2025-12-27 12:08:55',NULL,'ampere','131','كريمة','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('721','أسامة عبد الله الناطور','','','','','1','0','2025-12-27 12:12:03',NULL,'ampere','352','المجزوب','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('722','اسعد شكر','','','','','1','0','2025-12-27 12:12:50',NULL,'ampere','354','المجزوب','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('723','امين شتور','','','','','1','0','2025-12-27 12:13:21',NULL,'ampere','369','المجزوب','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('724','توفيق محسن','','','','','1','0','2025-12-27 12:14:09',NULL,'ampere','362','المجزوب','5','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('726','ربيع شكر','','','','','1','0','2025-12-27 12:15:14',NULL,'ampere','358','المجزوب','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('727','سلامه شكر','','','','','1','0','2025-12-27 12:15:40',NULL,'ampere','360','المجزوب','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('728','علي الحسن','','','','','1','0','2025-12-27 12:17:20',NULL,'ampere','364','المجزوب','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('730','ولاء','','','','','1','0','2025-12-27 12:18:18',NULL,'ampere','353','المجزوب','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('731','	ياسمين شكر','','','','','1','0','2025-12-27 12:19:01',NULL,'ampere','366','المجزوب','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('732','محمد قدورة مختبر','','','','','1','0','2025-12-27 12:32:53',NULL,'ampere','114','الكردي','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('733','	محمد مجزوب','','','','','1','1','2025-12-27 12:35:08',NULL,'ampere','351','المجزوب','5','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('735','مبارك الصالح','','','','','1','0','2025-12-30 06:35:22',NULL,'ampere','876','العشقة','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('736','جهاد عثمان 1','','','','','1','0','2025-12-30 06:38:26',NULL,'ampere','1129','جمال قداح','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('737','محمود الميعاري','','','','','1','0','2025-12-30 07:36:59',NULL,'ampere','16','الميعاري','5','0.00','4.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('738','علاء قهوة','','','','','1','0','2025-12-30 07:38:41',NULL,'ampere','1','الميعاري','5','0.00','5.00','17.50','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('739','فادي ميعاري','','','','','1','0','2025-12-30 07:39:12',NULL,'ampere','8','الميعاري','5','0.00','4.00','30.62','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('740','مرت احمد جابر','','','','','1','0','2025-12-30 07:40:19',NULL,'ampere','275','بركة','5','0.00','3.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('841','خليل ناصر','','','','','1','0','2026-04-29 12:42:01',NULL,'ampere','1138','جمال قداح','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('742','دولا','','','','موتير المحلات','1','0','2025-12-30 07:42:03',NULL,'ampere','33','سريس','5','0.00','7.00','25.71','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('743','شادي لداوي','','','','','1','0','2025-12-30 07:43:33',NULL,'ampere','322',' اللداوي زاروبة','5','0.00','6.00','20.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('744','يوسف لداوي','','','','','1','0','2025-12-30 07:44:09',NULL,'ampere','321',' اللداوي زاروبة','5','0.00','16.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('745','صيدلية  رزان','','','','موتير المحلات','1','0','2025-12-30 07:46:43',NULL,'ampere','145','كريمة','5','0.00','5.00','22.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('746','احمد حمود','','','','','1','0','2025-12-30 07:47:21',NULL,'ampere','133','كريمة','5','0.00','5.00','24.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('747','نورا','','','','','1','0','2025-12-30 07:48:02',NULL,'ampere','129','كريمة','5','0.00','2.00','20.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('748','باسل اسامة','','','','','1','0','2025-12-30 07:48:43',NULL,'ampere','363','المجزوب','5','0.00','10.00','10.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('755','ابو حسن خياط','','','','','1','0','2026-01-10 13:13:16',NULL,'ampere','120','الكردي','5','0.00','7.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('756','محمود الاحمد','','','','','1','0','2026-01-10 13:35:43',NULL,'ampere','344',' اللداوي زاروبة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('757','ابراهيم سليمان','','','','','1','0','2026-01-10 13:41:36',NULL,'ampere','404','الساحة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('758','محمد اشقر','','','','','1','0','2026-01-10 13:44:31',NULL,'ampere','355','المجزوب','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('759','حسن عبد رحمان','','','','','1','0','2026-01-10 13:53:26',NULL,'ampere','24','الميعاري','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('760','نور ادريس','','','','محلات','1','0','2026-01-10 14:08:12',NULL,'ampere','5000','بشار','5','0.00','1.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('761','منار عبد الملك','','','','','1','0','2026-01-10 14:11:01',NULL,'ampere','98','الكردي','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('762','ناجي الاحمد','','','','','1','0','2026-01-10 14:13:06',NULL,'ampere','342',' اللداوي زاروبة','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('764','احمد كايد','','','','','1','0','2026-01-10 14:29:47',NULL,'ampere','244','حمود','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('765','ام محمد غزاوي','','','','','1','0','2026-01-10 14:35:22',NULL,'ampere','436','عبد اللطيف','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('767','احمد مطلق','','','','','1','0','2026-01-12 11:17:59',NULL,'ampere','1249','الحايك','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('771','عمر شحرور القهوة','','','','','1','0','2026-01-17 04:38:58',NULL,'meter','502',' الاسطبل','4','3051.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('772','محمود عبود','','','','','1','0','2026-01-17 12:49:41',NULL,'ampere','1319','قاعة الشعب','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('797','مصطفى الخلف','','','','','1','0','2026-02-18 04:14:51',NULL,'ampere','1201','ابو تركي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('774','حزيفة محمد','','','','','1','0','2026-01-19 07:17:44',NULL,'ampere','102','الكردي','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('809','صلاح جوني','','','','','0','0','2026-03-26 11:19:48',NULL,'ampere','561','ابو رصاص','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('778','فيصل شكر','','','','','1','0','2026-01-23 10:36:28',NULL,'ampere','10','الميعاري','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('777','انارة','','','','','1','1','2026-01-23 10:27:13',NULL,'ampere','334',' اللداوي زاروبة','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('779','صيدلية ديما','','','','محلات','1','0','2026-01-23 10:49:58',NULL,'ampere','5017','بشار','5','0.00','4.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('781','محمود عادل','','','','محلات','1','0','2026-01-23 11:13:24',NULL,'ampere','5019','بشار','5','0.00','1.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('783','محل سمر','','','','','1','0','2026-01-24 09:27:12',NULL,'ampere','34','سريس','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('784','ابو اسامة','','','','','1','0','2026-01-24 09:41:02',NULL,'ampere','356','المجزوب','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('803','جمال قاسم','','','','','1','0','2026-03-13 10:08:02',NULL,'ampere','863','ابو وسيم فرحات','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('838','كتانا جوابرة','','','','','1','0','2026-04-27 13:31:33',NULL,'ampere','1190','ابو تركي','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('790','احمد حمود','','','','','1','0','2026-01-31 09:21:05',NULL,'ampere','562','ابو رصاص','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('793','وائل العبد','','','','','1','0','2026-02-01 11:20:02',NULL,'ampere','1434','البيبي فوت','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('794','زهير الزايد','','','','','1','0','2026-02-04 08:23:58',NULL,'ampere','1461','التضامن','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('795','خالد بيومي','','','','','1','0','2026-02-09 05:06:19',NULL,'ampere','849','ابو وسيم فرحات','4','0.00','2.00','10.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('796','ياسر قبيسي','','','','','1','0','2026-02-12 11:05:00',NULL,'ampere','2503','عبد عجينة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('798','عبد المجيد دعبول','','','','','1','0','2026-02-22 10:06:34',NULL,'ampere','882','العشقة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('799','عماد الهلاج','','','','','1','0','2026-02-25 05:12:51',NULL,'ampere','564','ابو رصاص','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('801','سنونو','','','','','1','0','2026-03-04 09:38:16',NULL,'ampere','840','ابو خضر','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('805','ابو طارق السيد','','','','17 الشهر','1','0','2026-03-18 14:50:29',NULL,'ampere','655','العيوطي','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('806','محمد لداوي','','','','18 الشهر','1','0','2026-03-18 14:58:01',NULL,'ampere','790','عبد سلامة','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('807','احمد الميعاري','','','','بحاسب عاساس موتير المحلات','1','0','2026-03-22 11:13:35',NULL,'ampere','972','سالم الوالي','4','0.00','5.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('820','جامع الحبيب','','','','','1','1','2026-03-31 09:06:07',NULL,'ampere','1316','قاعة الشعب','4','0.00','2.50','0.00','0.00','87.50','0.00');
INSERT INTO `customers` VALUES ('821','ابراهيم كنجو ','','','','','1','0','2026-03-31 10:36:52',NULL,'ampere','563','ابو رصاص','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('822','اسامة ','','','','','1','0','2026-04-01 05:51:58',NULL,'ampere','1062','الكفاح','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('823','ابو النار ','','','','','1','0','2026-04-01 07:44:25',NULL,'ampere','1416','البيبي فوت','4','0.00','7.00','20.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('824','ابو عماد عيسى','','','','','1','0','2026-04-01 08:06:59',NULL,'ampere','1242','الحايك','4','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('825','دكتور  سعيد ياسين','','','','','1','0','2026-04-01 09:38:11',NULL,'ampere','79','بشار','5','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('826','ابو صالج','','','','','1','0','2026-04-01 14:54:06',NULL,'ampere','56','سريس','5','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('827','عبد العزيز الذيب','','','','','1','0','2026-04-02 05:30:09',NULL,'ampere','1462','التضامن','4','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('828','دكان ابو مالك البيت','','','','','1','0','2026-04-02 07:01:29',NULL,'ampere','870','ابو وسيم فرحات','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('829','طه صيدلية فاطمة','','','','10 الشهر','1','0','2026-04-10 12:01:37',NULL,'ampere','1342','الجهاد','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('831','شغبان بيوض','','','','','1','0','2026-04-15 12:17:17',NULL,'ampere','865','ابو وسيم فرحات','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('832','احمد رميض','','','','','1','0','2026-04-16 06:37:48',NULL,'ampere','1344','الجهاد','4','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('833','الاء غنام','','','','16 الشهر','1','0','2026-04-16 12:48:19',NULL,'ampere','767','حليمة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('834','جهاد العيساوي','','','','17 الشهر','1','0','2026-04-17 12:12:01',NULL,'ampere','811','عبد سلامة','4','0.00','1.00','45.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('835','جمعية المرأة','','','','موتير النهار','1','0','2026-04-20 04:05:39',NULL,'ampere','1206','ابو تركي','4','0.00','5.00','30.00','0.00','0.00','0.00');


CREATE TABLE `exchange_rates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usd_to_lbp` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;



CREATE TABLE `expenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `category` enum('fuel','maintenance','salaries','rent','other') DEFAULT 'other',
  `amount_usd` decimal(12,2) NOT NULL,
  `expense_date` date NOT NULL,
  `notes` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `expenses` VALUES ('1','وسام لداوي','fuel','100.00','2026-01-01','','4','2026-01-01 05:49:00');
INSERT INTO `expenses` VALUES ('2','حمزة','salaries','750.00','2026-01-05','','4','2026-01-05 07:30:50');
INSERT INTO `expenses` VALUES ('3','عبد','salaries','500.00','2026-01-05','','4','2026-01-05 08:05:42');
INSERT INTO `expenses` VALUES ('4','علاء','salaries','500.00','2026-01-05','','4','2026-01-05 08:40:08');
INSERT INTO `expenses` VALUES ('5','محمود','salaries','500.00','2026-01-05','','4','2026-01-05 11:15:42');
INSERT INTO `expenses` VALUES ('6','بدر','salaries','550.00','2026-01-05','','4','2026-01-05 11:43:22');
INSERT INTO `expenses` VALUES ('7','ربيع','salaries','800.00','2026-01-06','','4','2026-01-06 04:51:38');
INSERT INTO `expenses` VALUES ('8','25 جنكسيونة +قطاعة كبلات','maintenance','80.00','2026-01-07','','4','2026-01-07 04:22:22');
INSERT INTO `expenses` VALUES ('9','زكريا الحداد','maintenance','15.00','2026-01-21','تلحيم توربين الهوى','4','2026-01-21 10:39:00');
INSERT INTO `expenses` VALUES ('10','وسام لداوي','other','100.00','2026-02-01','','4','2026-02-01 06:46:58');
INSERT INTO `expenses` VALUES ('11','حمزة','salaries','750.00','2026-02-04','','4','2026-02-04 07:08:29');
INSERT INTO `expenses` VALUES ('12','عبد','salaries','500.00','2026-02-04','','4','2026-02-04 07:22:48');
INSERT INTO `expenses` VALUES ('13','ربيع','salaries','800.00','2026-02-04','','4','2026-02-04 08:59:47');
INSERT INTO `expenses` VALUES ('14','علاء','salaries','500.00','2026-02-04','','4','2026-02-04 09:21:44');
INSERT INTO `expenses` VALUES ('15','بدر','salaries','550.00','2026-02-04','','4','2026-02-04 10:07:55');
INSERT INTO `expenses` VALUES ('16','محمود','salaries','500.00','2026-02-05','','4','2026-02-05 04:48:14');
INSERT INTO `expenses` VALUES ('17','12 قفل للعلب ','other','75.00','2026-02-07','','4','2026-02-07 04:07:37');
INSERT INTO `expenses` VALUES ('18','جلن زيت + بطاريتين+نقلة تكتك','other','795.00','2026-02-27','','4','2026-02-27 08:16:31');
INSERT INTO `expenses` VALUES ('19','وسام لداوي','other','100.00','2026-03-02','','4','2026-03-02 13:42:07');
INSERT INTO `expenses` VALUES ('20','حمزة','salaries','750.00','2026-03-04','','4','2026-03-04 12:03:29');
INSERT INTO `expenses` VALUES ('21','بدر','salaries','550.00','2026-03-04','','4','2026-03-04 12:51:35');
INSERT INTO `expenses` VALUES ('22','علاء','salaries','500.00','2026-03-04','','4','2026-03-04 12:51:46');
INSERT INTO `expenses` VALUES ('23','ديجنتير الرئيسي','maintenance','590.00','2026-03-05','','4','2026-03-05 06:09:21');
INSERT INTO `expenses` VALUES ('24','ربيع','salaries','800.00','2026-03-05','','4','2026-03-05 06:51:16');
INSERT INTO `expenses` VALUES ('25','محمود','salaries','500.00','2026-03-07','','4','2026-03-07 13:29:35');
INSERT INTO `expenses` VALUES ('26','فلاتر للموتيرات','maintenance','180.00','2026-03-30','','4','2026-03-30 09:08:39');
INSERT INTO `expenses` VALUES ('27','وسام لداوي','other','100.00','2026-04-02','','4','2026-04-02 09:45:45');
INSERT INTO `expenses` VALUES ('28','حمزة','salaries','750.00','2026-04-04','','4','2026-04-04 08:11:14');
INSERT INTO `expenses` VALUES ('29','ربيع','salaries','800.00','2026-04-04','','4','2026-04-04 08:35:02');
INSERT INTO `expenses` VALUES ('30','بدر','salaries','550.00','2026-04-04','','4','2026-04-04 10:31:40');
INSERT INTO `expenses` VALUES ('31','علاء','salaries','550.00','2026-04-04','','4','2026-04-04 11:35:19');
INSERT INTO `expenses` VALUES ('32','لفة كبل كهربا للبوارد','other','125.00','2026-04-06','','4','2026-04-06 05:08:13');
INSERT INTO `expenses` VALUES ('33','محمود','salaries','500.00','2026-04-06','','4','2026-04-06 11:38:07');
INSERT INTO `expenses` VALUES ('34','ديجنتيرات للتابلو','maintenance','72.00','2026-04-23','','4','2026-04-23 05:07:02');
INSERT INTO `expenses` VALUES ('35','زكريا الحداد','maintenance','90.00','2026-04-27','تنظيف وتلحيم اساطل الدواخين','4','2026-04-27 09:43:00');


CREATE TABLE `meter_readings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `meter_id` int(11) NOT NULL,
  `previous_reading` decimal(10,2) DEFAULT NULL,
  `current_reading` decimal(10,2) DEFAULT NULL,
  `collector_id` int(11) DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_meter_period` (`meter_id`,`month`,`year`),
  KEY `collector_id` (`collector_id`)
) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO `meter_readings` VALUES ('1','555','10429.00','10587.00',NULL,'12','2025','2025-12-30 05:41:06');
INSERT INTO `meter_readings` VALUES ('2','553','10498.00','10655.00',NULL,'12','2025','2025-12-30 05:41:25');
INSERT INTO `meter_readings` VALUES ('3','533','5611.00','5743.00',NULL,'12','2025','2025-12-30 05:41:56');
INSERT INTO `meter_readings` VALUES ('4','541','6861.00','6976.00',NULL,'12','2025','2025-12-30 05:42:17');
INSERT INTO `meter_readings` VALUES ('5','534','6628.00','6731.00',NULL,'12','2025','2025-12-30 05:42:36');
INSERT INTO `meter_readings` VALUES ('6','530','4220.00','4277.00',NULL,'12','2025','2025-12-30 05:42:48');
INSERT INTO `meter_readings` VALUES ('7','550','5466.00','5583.00',NULL,'12','2025','2025-12-30 05:43:20');
INSERT INTO `meter_readings` VALUES ('8','545','4140.00','4306.00',NULL,'12','2025','2025-12-30 05:43:45');
INSERT INTO `meter_readings` VALUES ('9','535','5022.00','5092.00',NULL,'12','2025','2025-12-30 05:43:58');
INSERT INTO `meter_readings` VALUES ('10','554','6247.00','6353.00',NULL,'12','2025','2025-12-30 05:44:19');
INSERT INTO `meter_readings` VALUES ('11','525','4618.00','4670.00',NULL,'12','2025','2025-12-30 05:44:37');
INSERT INTO `meter_readings` VALUES ('12','556','4504.00','4535.00',NULL,'12','2025','2025-12-30 05:45:18');
INSERT INTO `meter_readings` VALUES ('13','527','6078.00','6196.00',NULL,'12','2025','2025-12-30 05:45:36');
INSERT INTO `meter_readings` VALUES ('14','542','9013.00','9149.00',NULL,'12','2025','2025-12-30 05:46:45');
INSERT INTO `meter_readings` VALUES ('15','536','5995.00','6135.00',NULL,'12','2025','2025-12-30 05:47:30');
INSERT INTO `meter_readings` VALUES ('16','552','6571.00','6624.00',NULL,'12','2025','2025-12-30 05:47:55');
INSERT INTO `meter_readings` VALUES ('17','528','6140.00','6217.00',NULL,'12','2025','2025-12-30 05:48:16');
INSERT INTO `meter_readings` VALUES ('18','561','0.00','42.00',NULL,'12','2025','2025-12-30 05:48:30');
INSERT INTO `meter_readings` VALUES ('19','540','5504.00','5616.00',NULL,'12','2025','2025-12-30 06:04:48');
INSERT INTO `meter_readings` VALUES ('20','537','5621.00','5820.00',NULL,'12','2025','2025-12-30 06:08:34');
INSERT INTO `meter_readings` VALUES ('21','551','5429.00','5511.00',NULL,'12','2025','2025-12-30 06:15:30');
INSERT INTO `meter_readings` VALUES ('22','547','6486.00','6561.00',NULL,'12','2025','2025-12-30 06:16:27');
INSERT INTO `meter_readings` VALUES ('23','549','11555.00','11695.00',NULL,'12','2025','2025-12-30 06:18:42');
INSERT INTO `meter_readings` VALUES ('24','544','5311.00','5428.00',NULL,'12','2025','2025-12-30 06:23:48');
INSERT INTO `meter_readings` VALUES ('25','523','300.00','352.00',NULL,'12','2025','2025-12-30 06:26:09');
INSERT INTO `meter_readings` VALUES ('26','538','2944.00','3000.00',NULL,'12','2025','2025-12-30 06:26:37');
INSERT INTO `meter_readings` VALUES ('27','522','2910.00','3004.00',NULL,'12','2025','2025-12-30 06:26:51');
INSERT INTO `meter_readings` VALUES ('28','548','4293.00','4350.00',NULL,'12','2025','2025-12-30 06:27:23');
INSERT INTO `meter_readings` VALUES ('29','557','1476.00','1501.00',NULL,'12','2025','2025-12-30 06:27:43');
INSERT INTO `meter_readings` VALUES ('30','521','1146.00','1162.00',NULL,'12','2025','2025-12-30 06:27:58');
INSERT INTO `meter_readings` VALUES ('31','532','152.00','290.00',NULL,'12','2025','2025-12-30 06:28:09');
INSERT INTO `meter_readings` VALUES ('32','526','7150.00','7242.00',NULL,'12','2025','2025-12-30 06:28:26');
INSERT INTO `meter_readings` VALUES ('33','529','3714.00','3743.00',NULL,'12','2025','2025-12-30 06:29:17');
INSERT INTO `meter_readings` VALUES ('34','524','21281.00','21562.00',NULL,'12','2025','2025-12-30 06:29:31');
INSERT INTO `meter_readings` VALUES ('35','543','6830.00','6886.00',NULL,'12','2025','2025-12-30 06:29:56');
INSERT INTO `meter_readings` VALUES ('36','562','0.00','137.00',NULL,'12','2025','2025-12-30 06:30:12');
INSERT INTO `meter_readings` VALUES ('37','539','8074.00','8275.00',NULL,'12','2025','2025-12-30 06:30:31');
INSERT INTO `meter_readings` VALUES ('38','558','157.00','272.00',NULL,'12','2025','2025-12-30 06:30:47');
INSERT INTO `meter_readings` VALUES ('39','531','5326.00','5407.00',NULL,'12','2025','2025-12-30 06:31:09');
INSERT INTO `meter_readings` VALUES ('40','521','1162.00','1195.00',NULL,'1','2026','2026-01-31 04:26:06');
INSERT INTO `meter_readings` VALUES ('41','522','3004.00','3100.00',NULL,'1','2026','2026-01-31 04:26:32');
INSERT INTO `meter_readings` VALUES ('42','523','352.00','414.00',NULL,'1','2026','2026-01-31 04:27:40');
INSERT INTO `meter_readings` VALUES ('43','524','21562.00','21861.00',NULL,'1','2026','2026-01-31 04:27:59');
INSERT INTO `meter_readings` VALUES ('44','525','4670.00','4733.00',NULL,'1','2026','2026-01-31 04:28:20');
INSERT INTO `meter_readings` VALUES ('45','526','7242.00','7333.00',NULL,'1','2026','2026-01-31 04:28:50');
INSERT INTO `meter_readings` VALUES ('46','527','6196.00','6238.00',NULL,'1','2026','2026-01-31 04:29:01');
INSERT INTO `meter_readings` VALUES ('47','528','6217.00','6295.00',NULL,'1','2026','2026-01-31 04:29:15');
INSERT INTO `meter_readings` VALUES ('48','529','3743.00','3770.00',NULL,'1','2026','2026-01-31 04:29:48');
INSERT INTO `meter_readings` VALUES ('49','530','4277.00','4339.00',NULL,'1','2026','2026-01-31 04:29:58');
INSERT INTO `meter_readings` VALUES ('50','531','5407.00','5497.00',NULL,'1','2026','2026-01-31 04:30:09');
INSERT INTO `meter_readings` VALUES ('51','532','290.00','434.00',NULL,'1','2026','2026-01-31 04:30:41');
INSERT INTO `meter_readings` VALUES ('52','533','5743.00','5872.00',NULL,'1','2026','2026-01-31 04:30:53');
INSERT INTO `meter_readings` VALUES ('53','534','6731.00','6822.00',NULL,'1','2026','2026-01-31 04:31:04');
INSERT INTO `meter_readings` VALUES ('54','535','5092.00','5172.00',NULL,'1','2026','2026-01-31 04:31:31');
INSERT INTO `meter_readings` VALUES ('55','536','6135.00','6283.00',NULL,'1','2026','2026-01-31 04:31:43');
INSERT INTO `meter_readings` VALUES ('56','537','5820.00','6026.00',NULL,'1','2026','2026-01-31 04:31:54');
INSERT INTO `meter_readings` VALUES ('57','538','3000.00','3055.00',NULL,'1','2026','2026-01-31 04:32:04');
INSERT INTO `meter_readings` VALUES ('58','539','8275.00','8503.00',NULL,'1','2026','2026-01-31 04:32:16');
INSERT INTO `meter_readings` VALUES ('59','540','5616.00','5776.00',NULL,'1','2026','2026-01-31 04:32:28');
INSERT INTO `meter_readings` VALUES ('60','541','6976.00','7120.00',NULL,'1','2026','2026-01-31 04:32:38');
INSERT INTO `meter_readings` VALUES ('61','542','9149.00','9299.00',NULL,'1','2026','2026-01-31 04:32:55');
INSERT INTO `meter_readings` VALUES ('62','543','6886.00','6915.00',NULL,'1','2026','2026-01-31 04:33:07');
INSERT INTO `meter_readings` VALUES ('63','544','5428.00','5532.00',NULL,'1','2026','2026-01-31 04:33:18');
INSERT INTO `meter_readings` VALUES ('64','545','4306.00','4548.00',NULL,'1','2026','2026-01-31 04:33:31');
INSERT INTO `meter_readings` VALUES ('65','547','6561.00','6639.00',NULL,'1','2026','2026-01-31 04:33:49');
INSERT INTO `meter_readings` VALUES ('66','548','4350.00','4419.00',NULL,'1','2026','2026-01-31 04:34:03');
INSERT INTO `meter_readings` VALUES ('67','549','11695.00','11823.00',NULL,'1','2026','2026-01-31 04:34:26');
INSERT INTO `meter_readings` VALUES ('68','550','5583.00','5692.00',NULL,'1','2026','2026-01-31 04:34:56');
INSERT INTO `meter_readings` VALUES ('69','551','5511.00','5597.00',NULL,'1','2026','2026-01-31 04:35:14');
INSERT INTO `meter_readings` VALUES ('70','552','6624.00','6683.00',NULL,'1','2026','2026-01-31 04:35:29');
INSERT INTO `meter_readings` VALUES ('71','553','10655.00','10821.00',NULL,'1','2026','2026-01-31 04:35:41');
INSERT INTO `meter_readings` VALUES ('72','554','6353.00','6460.00',NULL,'1','2026','2026-01-31 04:35:59');
INSERT INTO `meter_readings` VALUES ('73','555','10587.00','10804.00',NULL,'1','2026','2026-01-31 04:36:11');
INSERT INTO `meter_readings` VALUES ('74','556','4535.00','4565.00',NULL,'1','2026','2026-01-31 04:36:25');
INSERT INTO `meter_readings` VALUES ('75','557','1501.00','1544.00',NULL,'1','2026','2026-01-31 04:38:54');
INSERT INTO `meter_readings` VALUES ('76','562','137.00','281.00',NULL,'1','2026','2026-01-31 04:39:16');
INSERT INTO `meter_readings` VALUES ('77','561','42.00','129.00',NULL,'1','2026','2026-01-31 04:39:28');
INSERT INTO `meter_readings` VALUES ('78','558','272.00','390.00',NULL,'1','2026','2026-01-31 04:39:39');
INSERT INTO `meter_readings` VALUES ('79','771','3051.00','3142.00',NULL,'1','2026','2026-01-31 04:39:53');
INSERT INTO `meter_readings` VALUES ('80','521','1195.00','1201.00',NULL,'2','2026','2026-02-28 11:52:52');
INSERT INTO `meter_readings` VALUES ('81','522','3100.00','3269.00',NULL,'2','2026','2026-02-28 11:53:07');
INSERT INTO `meter_readings` VALUES ('82','523','414.00','451.00',NULL,'2','2026','2026-02-28 11:53:20');
INSERT INTO `meter_readings` VALUES ('83','524','21861.00','22093.00',NULL,'2','2026','2026-02-28 11:53:37');
INSERT INTO `meter_readings` VALUES ('84','525','4733.00','4784.00',NULL,'2','2026','2026-02-28 11:53:54');
INSERT INTO `meter_readings` VALUES ('85','526','7333.00','7409.00',NULL,'2','2026','2026-02-28 11:54:39');
INSERT INTO `meter_readings` VALUES ('86','527','6238.00','6341.00',NULL,'2','2026','2026-02-28 11:54:52');
INSERT INTO `meter_readings` VALUES ('87','537','6026.00','6158.00',NULL,'2','2026','2026-02-28 11:55:10');
INSERT INTO `meter_readings` VALUES ('88','529','3770.00','3797.00',NULL,'2','2026','2026-02-28 11:55:24');
INSERT INTO `meter_readings` VALUES ('89','530','4339.00','4387.00',NULL,'2','2026','2026-02-28 11:55:37');
INSERT INTO `meter_readings` VALUES ('90','531','5497.00','5570.00',NULL,'2','2026','2026-02-28 11:55:50');
INSERT INTO `meter_readings` VALUES ('91','532','434.00','540.00',NULL,'2','2026','2026-02-28 11:56:05');
INSERT INTO `meter_readings` VALUES ('92','533','5872.00','5971.00',NULL,'2','2026','2026-02-28 11:56:18');
INSERT INTO `meter_readings` VALUES ('93','534','6822.00','6880.00',NULL,'2','2026','2026-02-28 11:56:37');
INSERT INTO `meter_readings` VALUES ('94','535','5172.00','5247.00',NULL,'2','2026','2026-02-28 11:57:37');
INSERT INTO `meter_readings` VALUES ('95','536','6283.00','6416.00',NULL,'2','2026','2026-02-28 11:57:52');
INSERT INTO `meter_readings` VALUES ('96','528','6295.00','6355.00',NULL,'2','2026','2026-02-28 11:58:50');
INSERT INTO `meter_readings` VALUES ('97','538','3055.00','3055.00',NULL,'2','2026','2026-02-28 11:59:21');
INSERT INTO `meter_readings` VALUES ('98','539','8503.00','8672.00',NULL,'2','2026','2026-02-28 11:59:39');
INSERT INTO `meter_readings` VALUES ('99','540','5776.00','5865.00',NULL,'2','2026','2026-02-28 11:59:51');
INSERT INTO `meter_readings` VALUES ('100','541','7120.00','7233.00',NULL,'2','2026','2026-02-28 12:00:02');
INSERT INTO `meter_readings` VALUES ('101','542','9299.00','9364.00',NULL,'2','2026','2026-02-28 12:00:14');
INSERT INTO `meter_readings` VALUES ('102','543','6915.00','6947.00',NULL,'2','2026','2026-02-28 12:00:30');
INSERT INTO `meter_readings` VALUES ('103','544','5532.00','5601.00',NULL,'2','2026','2026-02-28 12:00:52');
INSERT INTO `meter_readings` VALUES ('104','545','4548.00','4662.00',NULL,'2','2026','2026-02-28 12:01:05');
INSERT INTO `meter_readings` VALUES ('105','547','6639.00','6693.00',NULL,'2','2026','2026-02-28 12:01:28');
INSERT INTO `meter_readings` VALUES ('106','548','4419.00','4481.00',NULL,'2','2026','2026-02-28 12:01:41');
INSERT INTO `meter_readings` VALUES ('107','549','11823.00','11909.00',NULL,'2','2026','2026-02-28 12:02:53');
INSERT INTO `meter_readings` VALUES ('108','550','5692.00','5777.00',NULL,'2','2026','2026-02-28 12:03:04');
INSERT INTO `meter_readings` VALUES ('109','551','5597.00','5662.00',NULL,'2','2026','2026-02-28 12:03:18');
INSERT INTO `meter_readings` VALUES ('110','552','6683.00','6730.00',NULL,'2','2026','2026-02-28 12:03:32');
INSERT INTO `meter_readings` VALUES ('111','553','10821.00','10941.00',NULL,'2','2026','2026-02-28 12:03:49');
INSERT INTO `meter_readings` VALUES ('112','554','6460.00','6550.00',NULL,'2','2026','2026-02-28 12:04:53');
INSERT INTO `meter_readings` VALUES ('113','555','10804.00','10945.00',NULL,'2','2026','2026-02-28 12:05:12');
INSERT INTO `meter_readings` VALUES ('114','556','4565.00','4591.00',NULL,'2','2026','2026-02-28 12:05:27');
INSERT INTO `meter_readings` VALUES ('115','557','1544.00','1545.00',NULL,'2','2026','2026-02-28 12:05:51');
INSERT INTO `meter_readings` VALUES ('116','562','281.00','403.00',NULL,'2','2026','2026-02-28 12:06:06');
INSERT INTO `meter_readings` VALUES ('117','561','129.00','195.00',NULL,'2','2026','2026-02-28 12:06:17');
INSERT INTO `meter_readings` VALUES ('118','558','390.00','496.00',NULL,'2','2026','2026-02-28 12:06:30');
INSERT INTO `meter_readings` VALUES ('119','771','3142.00','3168.00',NULL,'2','2026','2026-02-28 12:06:42');
INSERT INTO `meter_readings` VALUES ('120','521','1201.00','1220.00',NULL,'3','2026','2026-03-31 06:13:56');
INSERT INTO `meter_readings` VALUES ('121','522','3269.00','3442.00',NULL,'3','2026','2026-03-31 06:14:08');
INSERT INTO `meter_readings` VALUES ('122','523','451.00','504.00',NULL,'3','2026','2026-03-31 06:14:20');
INSERT INTO `meter_readings` VALUES ('123','524','22093.00','22362.00',NULL,'3','2026','2026-03-31 06:14:36');
INSERT INTO `meter_readings` VALUES ('124','525','4784.00','4824.00',NULL,'3','2026','2026-03-31 06:14:54');
INSERT INTO `meter_readings` VALUES ('125','526','7409.00','7499.00',NULL,'3','2026','2026-03-31 06:15:32');
INSERT INTO `meter_readings` VALUES ('126','527','6341.00','6445.00',NULL,'3','2026','2026-03-31 06:15:59');
INSERT INTO `meter_readings` VALUES ('127','528','6355.00','6425.00',NULL,'3','2026','2026-03-31 06:17:38');
INSERT INTO `meter_readings` VALUES ('128','529','3797.00','3824.00',NULL,'3','2026','2026-03-31 06:17:53');
INSERT INTO `meter_readings` VALUES ('129','530','4387.00','4445.00',NULL,'3','2026','2026-03-31 06:18:06');
INSERT INTO `meter_readings` VALUES ('130','531','5570.00','5671.00',NULL,'3','2026','2026-03-31 06:18:19');
INSERT INTO `meter_readings` VALUES ('131','532','540.00','655.00',NULL,'3','2026','2026-03-31 06:18:31');
INSERT INTO `meter_readings` VALUES ('132','533','5971.00','6071.00',NULL,'3','2026','2026-03-31 06:18:44');
INSERT INTO `meter_readings` VALUES ('133','534','6880.00','6924.00',NULL,'3','2026','2026-03-31 06:19:00');
INSERT INTO `meter_readings` VALUES ('134','535','5247.00','5329.00',NULL,'3','2026','2026-03-31 06:19:18');
INSERT INTO `meter_readings` VALUES ('135','536','6416.00','6563.00',NULL,'3','2026','2026-03-31 06:19:31');
INSERT INTO `meter_readings` VALUES ('136','537','6158.00','6267.00',NULL,'3','2026','2026-03-31 06:19:45');
INSERT INTO `meter_readings` VALUES ('137','538','3055.00','3055.00',NULL,'3','2026','2026-03-31 06:20:00');
INSERT INTO `meter_readings` VALUES ('138','539','8672.00','8827.00',NULL,'3','2026','2026-03-31 06:20:17');
INSERT INTO `meter_readings` VALUES ('139','540','5865.00','5951.00',NULL,'3','2026','2026-03-31 06:20:38');
INSERT INTO `meter_readings` VALUES ('140','541','7233.00','7403.00',NULL,'3','2026','2026-03-31 06:20:55');
INSERT INTO `meter_readings` VALUES ('141','542','9364.00','9449.00',NULL,'3','2026','2026-03-31 06:21:11');
INSERT INTO `meter_readings` VALUES ('142','543','6947.00','6969.00',NULL,'3','2026','2026-03-31 06:21:29');
INSERT INTO `meter_readings` VALUES ('143','544','5601.00','5703.00',NULL,'3','2026','2026-03-31 06:22:02');
INSERT INTO `meter_readings` VALUES ('144','545','4662.00','4758.00',NULL,'3','2026','2026-03-31 06:22:20');
INSERT INTO `meter_readings` VALUES ('145','547','6693.00','6758.00',NULL,'3','2026','2026-03-31 06:22:42');
INSERT INTO `meter_readings` VALUES ('146','548','4481.00','4542.00',NULL,'3','2026','2026-03-31 06:22:57');
INSERT INTO `meter_readings` VALUES ('147','549','11909.00','11985.00',NULL,'3','2026','2026-03-31 06:23:28');
INSERT INTO `meter_readings` VALUES ('148','551','5662.00','5729.00',NULL,'3','2026','2026-03-31 06:24:28');
INSERT INTO `meter_readings` VALUES ('149','552','6730.00','6784.00',NULL,'3','2026','2026-03-31 06:24:44');
INSERT INTO `meter_readings` VALUES ('150','553','10941.00','11063.00',NULL,'3','2026','2026-03-31 06:25:21');
INSERT INTO `meter_readings` VALUES ('151','554','6550.00','6646.00',NULL,'3','2026','2026-03-31 06:25:38');
INSERT INTO `meter_readings` VALUES ('152','555','10945.00','11115.00',NULL,'3','2026','2026-03-31 06:25:51');
INSERT INTO `meter_readings` VALUES ('153','556','4591.00','4596.00',NULL,'3','2026','2026-03-31 06:26:06');
INSERT INTO `meter_readings` VALUES ('154','557','1545.00','1562.00',NULL,'3','2026','2026-03-31 06:26:20');
INSERT INTO `meter_readings` VALUES ('155','562','403.00','598.00',NULL,'3','2026','2026-03-31 06:26:33');
INSERT INTO `meter_readings` VALUES ('156','561','195.00','254.00',NULL,'3','2026','2026-03-31 06:26:45');
INSERT INTO `meter_readings` VALUES ('157','558','496.00','625.00',NULL,'3','2026','2026-03-31 06:26:59');
INSERT INTO `meter_readings` VALUES ('158','771','3168.00','3232.00',NULL,'3','2026','2026-03-31 06:27:12');
INSERT INTO `meter_readings` VALUES ('159','550','5777.00','5876.00',NULL,'3','2026','2026-03-31 06:27:42');
INSERT INTO `meter_readings` VALUES ('160','522','3442.00','3675.00',NULL,'4','2026','2026-04-30 05:03:22');
INSERT INTO `meter_readings` VALUES ('161','523','504.00','551.00',NULL,'4','2026','2026-04-30 05:03:56');
INSERT INTO `meter_readings` VALUES ('162','524','22362.00','22645.00',NULL,'4','2026','2026-04-30 05:04:36');
INSERT INTO `meter_readings` VALUES ('163','525','4824.00','4879.00',NULL,'4','2026','2026-04-30 05:05:20');
INSERT INTO `meter_readings` VALUES ('164','558','625.00','735.00',NULL,'4','2026','2026-04-30 05:05:37');
INSERT INTO `meter_readings` VALUES ('165','771','3232.00','3252.00',NULL,'4','2026','2026-04-30 05:06:02');
INSERT INTO `meter_readings` VALUES ('166','526','7499.00','7593.00',NULL,'4','2026','2026-04-30 05:07:13');
INSERT INTO `meter_readings` VALUES ('167','527','6445.00','6522.00',NULL,'4','2026','2026-04-30 05:07:34');
INSERT INTO `meter_readings` VALUES ('168','528','6425.00','6502.00',NULL,'4','2026','2026-04-30 05:08:05');
INSERT INTO `meter_readings` VALUES ('169','529','3824.00','3851.00',NULL,'4','2026','2026-04-30 05:08:25');
INSERT INTO `meter_readings` VALUES ('170','530','4445.00','4498.00',NULL,'4','2026','2026-04-30 05:08:47');
INSERT INTO `meter_readings` VALUES ('171','531','5671.00','5741.00',NULL,'4','2026','2026-04-30 05:09:14');
INSERT INTO `meter_readings` VALUES ('172','521','1220.00','1266.00',NULL,'4','2026','2026-04-30 05:09:53');
INSERT INTO `meter_readings` VALUES ('173','532','655.00','775.00',NULL,'4','2026','2026-04-30 05:10:19');
INSERT INTO `meter_readings` VALUES ('174','533','6071.00','6175.00',NULL,'4','2026','2026-04-30 05:10:41');
INSERT INTO `meter_readings` VALUES ('175','534','6924.00','7021.00',NULL,'4','2026','2026-04-30 05:11:01');
INSERT INTO `meter_readings` VALUES ('176','535','5329.00','5407.00',NULL,'4','2026','2026-04-30 05:13:13');
INSERT INTO `meter_readings` VALUES ('177','536','6563.00','6693.00',NULL,'4','2026','2026-04-30 05:13:32');
INSERT INTO `meter_readings` VALUES ('178','537','6267.00','6410.00',NULL,'4','2026','2026-04-30 05:14:07');
INSERT INTO `meter_readings` VALUES ('179','538','3055.00','3055.00',NULL,'4','2026','2026-04-30 05:14:26');
INSERT INTO `meter_readings` VALUES ('180','539','8827.00','8969.00',NULL,'4','2026','2026-04-30 05:14:48');
INSERT INTO `meter_readings` VALUES ('181','540','5951.00','6043.00',NULL,'4','2026','2026-04-30 05:15:17');
INSERT INTO `meter_readings` VALUES ('182','541','7403.00','7521.00',NULL,'4','2026','2026-04-30 05:15:37');
INSERT INTO `meter_readings` VALUES ('183','542','9449.00','9577.00',NULL,'4','2026','2026-04-30 05:16:04');
INSERT INTO `meter_readings` VALUES ('184','543','6969.00','7001.00',NULL,'4','2026','2026-04-30 05:16:23');
INSERT INTO `meter_readings` VALUES ('185','562','598.00','737.00',NULL,'4','2026','2026-04-30 05:16:47');
INSERT INTO `meter_readings` VALUES ('186','544','5703.00','5792.00',NULL,'4','2026','2026-04-30 05:18:18');
INSERT INTO `meter_readings` VALUES ('187','545','4758.00','4892.00',NULL,'4','2026','2026-04-30 05:20:05');
INSERT INTO `meter_readings` VALUES ('188','547','6758.00','6851.00',NULL,'4','2026','2026-04-30 05:20:42');
INSERT INTO `meter_readings` VALUES ('189','561','254.00','312.00',NULL,'4','2026','2026-04-30 05:21:01');
INSERT INTO `meter_readings` VALUES ('190','548','4542.00','4602.00',NULL,'4','2026','2026-04-30 05:21:28');
INSERT INTO `meter_readings` VALUES ('191','552','6784.00','6848.00',NULL,'4','2026','2026-04-30 05:21:48');
INSERT INTO `meter_readings` VALUES ('192','553','11063.00','11219.00',NULL,'4','2026','2026-04-30 05:22:10');
INSERT INTO `meter_readings` VALUES ('193','554','6646.00','6747.00',NULL,'4','2026','2026-04-30 05:22:36');
INSERT INTO `meter_readings` VALUES ('194','555','11115.00','11259.00',NULL,'4','2026','2026-04-30 05:23:00');
INSERT INTO `meter_readings` VALUES ('195','556','4596.00','4607.00',NULL,'4','2026','2026-04-30 05:23:20');
INSERT INTO `meter_readings` VALUES ('196','557','1562.00','1623.00',NULL,'4','2026','2026-04-30 05:23:43');
INSERT INTO `meter_readings` VALUES ('197','549','11985.00','12083.00',NULL,'4','2026','2026-04-30 05:24:06');
INSERT INTO `meter_readings` VALUES ('198','551','5729.00','5796.00',NULL,'4','2026','2026-04-30 05:24:29');


CREATE TABLE `meters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `meter_number` varchar(50) DEFAULT NULL,
  `last_reading` decimal(10,2) DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;



CREATE TABLE `monthly_pricing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `price_kwh` decimal(10,4) NOT NULL,
  `price_amp` decimal(10,2) NOT NULL,
  `fee_per_rated_amp` decimal(10,2) DEFAULT 0.00,
  `fixed_fee` decimal(12,2) DEFAULT 0.00,
  `exchange_rate` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_period` (`month`,`year`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `monthly_pricing` VALUES ('1','12','2025','29975.0000','33.00','0.00','0.00','90000','2025-12-31 03:27:02');
INSERT INTO `monthly_pricing` VALUES ('2','1','2026','28355.0000','33.00','0.00','0.00','90000','2025-12-31 03:27:40');
INSERT INTO `monthly_pricing` VALUES ('4','2','2026','30244.0000','33.00','0.00','0.00','90000','2026-01-31 05:43:14');
INSERT INTO `monthly_pricing` VALUES ('5','3','2025','28355.0000','33.00','0.00','0.00','90000','2026-03-01 09:29:40');
INSERT INTO `monthly_pricing` VALUES ('6','3','2026','40580.0000','33.00','0.00','0.00','90000','2026-03-01 09:31:05');
INSERT INTO `monthly_pricing` VALUES ('7','2','2025','30244.0000','33.00','0.00','0.00','90000','2026-03-03 06:15:51');
INSERT INTO `monthly_pricing` VALUES ('10','4','2026','40580.0000','35.00','0.00','0.00','90000','2026-03-31 08:12:34');


CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bill_id` int(11) NOT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `currency` enum('USD','LBP') DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `bill_id` (`bill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;



CREATE TABLE `pricing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `system_type` enum('meter','ampere') NOT NULL,
  `price` decimal(10,4) NOT NULL DEFAULT 0.0000,
  `currency` varchar(20) DEFAULT 'USD',
  `month` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `kilo_price_usd` decimal(10,2) NOT NULL,
  `ampere_price_usd` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `month` (`month`,`year`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO `pricing` VALUES ('3','meter','0.3000','USD','0','0','0.00','0.00','2025-12-24 04:06:02');


CREATE TABLE `settings` (
  `setting_key` varchar(50) NOT NULL,
  `setting_value` text DEFAULT NULL,
  PRIMARY KEY (`setting_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `settings` VALUES ('exchange_rate','90000');

