-- Osama Electric System Backup
-- Date: 2025-12-26 12:21:18



CREATE TABLE `amperes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `amperes` int(11) NOT NULL,
  `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 `audit_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `action` mediumtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `audit_log` VALUES ('1','3','System Reset Performed: financials','2025-12-25 07:09:57');
INSERT INTO `audit_log` VALUES ('2','3','System Reset Performed: readings','2025-12-25 07:10:01');
INSERT INTO `audit_log` VALUES ('3','3','System Reset Performed: customers_balance','2025-12-25 07:10:04');
INSERT INTO `audit_log` VALUES ('4','3','Login: User authorized via professional portal','2025-12-25 07:32:13');
INSERT INTO `audit_log` VALUES ('5','3','Login: User authorized via professional portal','2025-12-25 08:30:44');
INSERT INTO `audit_log` VALUES ('6','4','Login: User authorized via professional portal','2025-12-25 10:55:05');
INSERT INTO `audit_log` VALUES ('7','4','Login: User authorized via professional portal','2025-12-25 11:41:45');
INSERT INTO `audit_log` VALUES ('8','4','Login: User authorized via professional portal','2025-12-25 12:13:52');
INSERT INTO `audit_log` VALUES ('9','4','Login: User authorized via professional portal','2025-12-25 14:52:33');
INSERT INTO `audit_log` VALUES ('10','4','Login: User authorized via professional portal','2025-12-25 16:39:47');
INSERT INTO `audit_log` VALUES ('11','4','Login: User authorized via professional portal','2025-12-26 01:06:43');
INSERT INTO `audit_log` VALUES ('12','4','Login: User authorized via professional portal','2025-12-26 01:13:48');
INSERT INTO `audit_log` VALUES ('13','4','Login: User authorized via professional portal','2025-12-26 02:03:40');
INSERT INTO `audit_log` VALUES ('14','4','Login: User authorized via professional portal','2025-12-26 02:13:53');
INSERT INTO `audit_log` VALUES ('15','3','Login: User authorized via professional portal','2025-12-26 03:14:50');
INSERT INTO `audit_log` VALUES ('16','4','Login: User authorized via professional portal','2025-12-26 03:26:38');


CREATE TABLE `bills` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bill_number` varchar(50) DEFAULT NULL,
  `customer_id` int(11) NOT NULL,
  `type` enum('meter','ampere') DEFAULT 'meter',
  `month` int(11) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `consumption` decimal(10,2) DEFAULT NULL,
  `amount_usd` decimal(10,2) DEFAULT NULL,
  `amount_lbp` decimal(15,2) DEFAULT NULL,
  `exchange_rate` decimal(10,2) DEFAULT NULL,
  `status` enum('paid','unpaid') DEFAULT 'unpaid',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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,
  `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=563 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `customers` VALUES ('1','احمد ابو زيد','','','','','1','0','2025-12-25 07:14:27',NULL,'ampere','926','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('2','حسن شرعان','','','','','1','0','2025-12-25 07:15:04',NULL,'ampere','913','الجامع','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','الجامع','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','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('5','خلف ادهم','','','','','1','0','2025-12-25 07:16:43',NULL,'ampere','921','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('7','رانيا محمود','','','','','1','0','2025-12-25 07:17:36',NULL,'ampere','919','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('8','صليبة','','','','','1','0','2025-12-25 07:18:24',NULL,'ampere','923','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('9','عبد الناصر الاحمد','','','','','1','0','2025-12-25 07:18:55',NULL,'ampere','924','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('10','محمد حسين','','','','','1','0','2025-12-25 07:21:01',NULL,'ampere','933','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('11','محمد خالد','','','','','1','0','2025-12-25 07:21:29',NULL,'ampere','920','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('12','محمود سعد','','','','','1','0','2025-12-25 07:25:48',NULL,'ampere','917','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('13','مهند كرمو','','','','','1','0','2025-12-25 07:26:54',NULL,'ampere','922','الجامع','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('14','بشار رمو','',NULL,'','','1','0','2025-12-25 07:30:25',NULL,'ampere','2501','عبد عجينة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('15','خالد الحسن','',NULL,'','','1','0','2025-12-25 07:30:55',NULL,'ampere','2507','عبد عجينة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('16','عبد الغفور وردي','',NULL,'','','1','0','2025-12-25 07:31:24',NULL,'ampere','2503','عبد عجينة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('17','عقيل العمر','','','','','1','0','2025-12-25 07:31:55',NULL,'ampere','2504','عبد عجينة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('18','ابو لينا','','','','','1','0','2025-12-25 07:34:57',NULL,'ampere','998','ابو الروس','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','ابو الروس','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('20','احمد منصور','','','','','1','0','2025-12-25 07:40:57',NULL,'ampere','1002','ابو الروس','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('21','صالح داوود مكتب','','','','','1','0','2025-12-25 07:52:18',NULL,'ampere','996','ابو الروس','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','ابو الروس','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','ابو الروس','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','ابو الروس','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('25','ابو السعيد عبد الهادي','','','','','1','0','2025-12-25 08:07:07',NULL,'ampere','818','ابو باهي','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','ابو باهي','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','ابو باهي','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','ابو باهي','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','ابو باهي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('30','حمودة العدنان المصطفى','','','','','1','0','2025-12-25 08:18:34',NULL,'ampere','1107','ابو باهي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('31','خالد عبد الهادي','','','','','1','1','2025-12-25 08:19:10',NULL,'ampere','817','ابو باهي','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','ابو باهي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('33','عصام القاسم','','','','','1','0','2025-12-25 08:22:03',NULL,'ampere','823','ابو باهي','0.00','3.00','2.66','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('34','عمر شعبان','','','','','1','0','2025-12-25 08:22:56',NULL,'ampere','824','ابو باهي','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','ابو باهي','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','ابو باهي','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','ابو باهي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('38','محمد احمد احمد','','','','','1','0','2025-12-25 08:25:46',NULL,'ampere','825','ابو باهي','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','ابو باهي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('40','وائل الحريري','','','','','1','0','2025-12-25 08:27:48',NULL,'ampere','814','ابو باهي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('41','وليد توفيق','','','','10 الشهر','1','0','2025-12-25 08:28:27',NULL,'ampere','815','ابو باهي','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','ابو باهي','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','ابو باهي','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('44','عمار حوراني','','','','','1','0','2025-12-25 08:30:50',NULL,'ampere','1102','ابو باهي','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('45','محمد محمود','','','','','1','0','2025-12-25 08:31:41',NULL,'ampere','821','ابو باهي','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','ابو تركي','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','ابو تركي','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','ابو تركي','0.00','3.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('49','انارة زاروب ابو تركي','','','','','1','1','2025-12-25 08:42:18',NULL,'ampere','1200','ابو تركي','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','ابو تركي','0.00','2.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('51','ايهم العبد الله','','','','','1','0','2025-12-25 08:45:38',NULL,'ampere','1204','ابو تركي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('52','جمعية المرأة','','','','موتير المحلات','1','0','2025-12-25 08:46:59',NULL,'ampere','1206','ابو تركي','0.00','5.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('53','جهاد سليم','','','','','1','1','2025-12-25 08:48:27',NULL,'ampere','1191','ابو تركي','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','ابو تركي','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','ابو تركي','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','ابو تركي','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','ابو تركي','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','ابو تركي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('59','خالد الحبال','','','','','1','0','2025-12-25 08:55:37',NULL,'ampere','1184','ابو تركي','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','ابو تركي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('61','زياد شعبان','','','','','1','0','2025-12-25 08:58:01',NULL,'ampere','1192','ابو تركي','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','ابو تركي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('63','عبد تبعنا','','','','','1','1','2025-12-25 08:59:10',NULL,'ampere','1193','ابو تركي','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','ابو تركي','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','ابو تركي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('66','كتانا جوابرة','','','','','1','0','2025-12-25 09:05:10',NULL,'ampere','1190','ابو تركي','0.00','2.50','25.20','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('67','محمد الشيخ','','','','','1','0','2025-12-25 09:06:28',NULL,'ampere','1196','ابو تركي','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','ابو تركي','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','1185','ابو تركي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('70','محمود شواخ','','','','','1','0','2025-12-25 09:10:18',NULL,'ampere','1179','ابو تركي','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','ابو خضر','0.00','10.00','31.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('72','احمد جاسم','','','','','1','0','2025-12-25 09:13:14',NULL,'ampere','841','ابو خضر','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('73','ام عبد الله حلب','','','','','1','0','2025-12-25 09:14:09',NULL,'ampere','833','ابو خضر','0.00','2.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('74','ايمن العجوز','','','','','1','0','2025-12-25 09:14:45',NULL,'ampere','834','ابو خضر','0.00','5.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','ابو خضر','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('76','خالد الشامان','','','','','1','0','2025-12-25 09:16:02',NULL,'ampere','835','ابو خضر','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','ابو خضر','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('78','محمد الحلو','','','','','1','0','2025-12-25 09:17:32',NULL,'ampere','838','ابو خضر','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','ابو خضر','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('80','ياسر جابر','','','','','1','0','2025-12-25 09:18:49',NULL,'ampere','832','ابو خضر','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','ابو رصاص','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','ابو رصاص','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('83','ربيع كنجو','','','','','1','0','2025-12-25 09:22:18',NULL,'ampere','561','ابو رصاص','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('84','عبد الرحمن نجم','','','','','1','0','2025-12-25 09:23:02',NULL,'ampere','563','ابو رصاص','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('85','علي حسين الصفوري','','','','','1','0','2025-12-25 09:23:56',NULL,'ampere','543','ابو رصاص','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','ابو رصاص','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('87','محمد توتايو','','','','','1','0','2025-12-25 09:25:19',NULL,'ampere','553','ابو رصاص','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('88','محمد نايف جميل','','','','','1','0','2025-12-25 09:25:53',NULL,'ampere','559','ابو رصاص','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('89','محمود المحيا','','','','','1','0','2025-12-25 09:27:26',NULL,'ampere','550','ابو رصاص','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('90','ناجي حسين','','','','','1','0','2025-12-25 09:28:00',NULL,'ampere','542','ابو رصاص','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','ابو رصاص','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('92','حسن دادا','','','','','1','0','2025-12-25 09:29:50',NULL,'ampere','1260','ابو نصرا','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','ابو نصرا','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','ابو نصرا','0.00','3.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','ابو نصرا','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','1271','ابو نصرا','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('97','طه لوباني','','','','','1','0','2025-12-25 09:33:04',NULL,'ampere','1278','ابو نصرا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('98','عبد السلام الجاسم','','','','','1','0','2025-12-25 09:33:44',NULL,'ampere','1270','ابو نصرا','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('99','عبد الله خالد مصطفى','','','','','1','0','2025-12-25 09:35:57',NULL,'ampere','1263','ابو نصرا','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','ابو نصرا','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','ابو نصرا','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','ابو نصرا','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('103','فراس مسعود','','','','','1','0','2025-12-25 09:38:43',NULL,'ampere','1277','ابو نصرا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('104','محمود الفرن','','','','','1','0','2025-12-25 09:39:14',NULL,'ampere','1267','ابو نصرا','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('105','وليد عبارة','','','','','1','0','2025-12-25 09:39:51',NULL,'ampere','1279','ابو نصرا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('106','ابو حزيفة','','','','','1','0','2025-12-25 09:41:10',NULL,'ampere','845','ابو وسيم فرحات','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','ابو وسيم فرحات','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('108','احمد سعدو الخالد','','','','','1','0','2025-12-25 09:42:56',NULL,'ampere','858','ابو وسيم فرحات','0.00','1.00','35.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','ابو وسيم فرحات','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','ابو وسيم فرحات','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('111','جهاد ابو اللطف','','','','','1','0','2025-12-25 09:45:29',NULL,'ampere','855','ابو وسيم فرحات','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('112','حمزة جاد','','','','','1','0','2025-12-25 09:46:02',NULL,'ampere','849','ابو وسيم فرحات','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('113','عمر انور','','','','','1','0','2025-12-25 09:47:07',NULL,'ampere','852','ابو وسيم فرحات','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('114','محمد الخضر','','','','','1','0','2025-12-25 09:47:47',NULL,'ampere','854','ابو وسيم فرحات','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('115','مصطفى عطور','','','','','1','0','2025-12-25 09:48:28',NULL,'ampere','848','ابو وسيم فرحات','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','الاسطبل','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','الاسطبل','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('118','حيدر حمود','','','','من عند ابو برهان ركب بتاريخ  11/12 شهر بيدفع شهر لا لمدة سنة','1','0','2025-12-25 09:54:08',NULL,'ampere','498','الاسطبل','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('119','عبد عجينة','','','','','1','1','2025-12-25 09:55:04',NULL,'ampere','484','الاسطبل','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','الاسطبل','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','الاسطبل','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','الاسطبل','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','الاسطبل','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','الاسطبل','0.00','1.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('125','محمد عبد الله','','','','','1','0','2025-12-25 10:01:05',NULL,'ampere','483','الاسطبل','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('126','محمود دوالي','','','','موتير المحلات','1','0','2025-12-25 10:02:40',NULL,'ampere','493','الاسطبل','0.00','3.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('127','وائل علي','','','','','1','0','2025-12-25 10:03:26',NULL,'ampere','486','الاسطبل','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','البليار','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','البليار','0.00','3.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','البليار','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','البليار','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','البليار','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('133','حسين علي حمزة','','','','','1','0','2025-12-25 10:08:18',NULL,'ampere','694','البليار','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('134','حميد حمزة','','','','','1','0','2025-12-25 10:08:54',NULL,'ampere','682','البليار','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('135','داني العلي','','','','','1','0','2025-12-25 10:09:35',NULL,'ampere','679','البليار','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('136','زياد المغير','','','','','1','0','2025-12-25 10:10:08',NULL,'ampere','671','البليار','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','البليار','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('138','سعد دلول','','','','','1','0','2025-12-25 10:11:10',NULL,'ampere','687','البليار','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('139','سليمان الحسن','','','','','1','0','2025-12-25 10:12:06',NULL,'ampere','693','البليار','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('140','ام محمد نهر البارد','','','','','1','1','2025-12-25 10:12:42',NULL,'ampere','676','البليار','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','البليار','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','البليار','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('143','محمد صلاح صالح','','','','موتير المحلات','1','0','2025-12-25 10:14:56',NULL,'ampere','686','البليار','0.00','3.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('144','هاني المصري','','','','','1','0','2025-12-25 10:17:29',NULL,'ampere','680','البليار','0.00','2.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('145','احمد ابو داوود','','','','','1','0','2025-12-25 10:22:09',NULL,'ampere','1453','التضامن','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','التضامن','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','1470','التضامن','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('148','خالد الحلو','','','','','1','0','2025-12-25 10:24:10',NULL,'ampere','1459','التضامن','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','التضامن','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','التضامن','0.00','2.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','التضامن','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','التضامن','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('153','محمد سليمان','','','','','1','0','2025-12-25 10:27:54',NULL,'ampere','1450','التضامن','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','التضامن','0.00','2.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('155','محمود الحلو','','','','','1','0','2025-12-25 10:30:06',NULL,'ampere','1455','التضامن','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','التضامن','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('157','منى العلي','','','','','1','0','2025-12-25 10:31:07',NULL,'ampere','1454','التضامن','0.00','3.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','التضامن','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('159','اسامة صالح','','','','','1','0','2025-12-25 10:33:08',NULL,'ampere','944','التعاونية','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','التعاونية','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','التعاونية','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','التعاونية','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('163','اخت هاني المصري','','','','','1','1','2025-12-25 10:35:52',NULL,'ampere','946','التعاونية','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','التعاونية','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','التعاونية','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('166','جميلة المصرية','','','','','1','0','2025-12-25 10:38:55',NULL,'ampere','949','التعاونية','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('167','عبد الملك سليمان','','','','','1','0','2025-12-25 10:39:31',NULL,'ampere','952','التعاونية','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('168','عمر هلال','','','','','1','0','2025-12-25 10:42:48',NULL,'ampere','945','التعاونية','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','التعاونية','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','التعاونية','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','التعاونية','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('172','نجاح زعرورة','','','','10 الشهر','1','0','2025-12-25 10:45:35',NULL,'ampere','961','التعاونية','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','التعاونية','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('174','ابو عمر','','','','13 الشهر','1','0','2025-12-25 12:16:37',NULL,'ampere','22222','صبرا','0.00','5.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','صبرا','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','صبرا','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','صبرا','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','البيبي فوت','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','البيبي فوت','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','البيبي فوت','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','البيبي فوت','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('182','انارة زاروب البيبي فوت','','','','','1','1','2025-12-25 12:23:42',NULL,'ampere','1431','البيبي فوت','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','1418','البيبي فوت','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('184','حسن ابراهيم','','','','','1','0','2025-12-25 12:25:52',NULL,'ampere','1407','البيبي فوت','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','البيبي فوت','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','البيبي فوت','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('187','حسن المصري','','','','','1','1','2025-12-25 12:28:23',NULL,'ampere','1433','البيبي فوت','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','البيبي فوت','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','البيبي فوت','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','البيبي فوت','0.00','1.00','35.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','البيبي فوت','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','البيبي فوت','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','البيبي فوت','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('194','رمضان حسين','','','','','1','0','2025-12-25 12:34:12',NULL,'ampere','1430','البيبي فوت','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('195','سمير القاسم','','','','','1','0','2025-12-25 12:35:14',NULL,'ampere','1417','البيبي فوت','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('196','صيدلية الشفاء','','','','موتير المحلات','1','0','2025-12-25 12:36:30',NULL,'ampere','3000','البيبي فوت','0.00','3.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('197','عبد منصور','','','','','1','0','2025-12-25 12:37:08',NULL,'ampere','1406','البيبي فوت','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','البيبي فوت','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','البيبي فوت','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','البيبي فوت','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('201','ابو هاني قتناني','','','','بالعلبة 5 امبير','1','0','2025-12-25 12:40:12',NULL,'ampere','1403','البيبي فوت','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','1415','البيبي فوت','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('203','محمود ابو ستيتة','','','','','1','0','2025-12-25 12:41:57',NULL,'ampere','1420','البيبي فوت','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','الجهاد','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','1434','البيبي فوت','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('206','مرت عم مؤمن','','','','','1','1','2025-12-25 12:43:50',NULL,'ampere','1404','البيبي فوت','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','البيبي فوت','0.00','4.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('208','مصطفى كسار','','','','','1','0','2025-12-25 12:46:18',NULL,'ampere','1428','البيبي فوت','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('209','ياسين دريلمي','','','','','1','0','2025-12-25 12:47:05',NULL,'ampere','1419','البيبي فوت','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','الجهاد','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('212','احمد رميض','','','','','1','0','2025-12-25 12:56:14',NULL,'ampere','1342','الجهاد','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('213','احمد صالح','','','','','1','0','2025-12-25 12:56:55',NULL,'ampere','1330','الجهاد','0.00','1.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('214','ام علي معروف','','','','','1','0','2025-12-25 12:57:57',NULL,'ampere','1333','الجهاد','0.00','2.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('215','بشار محمد العبد','','','','','1','0','2025-12-25 12:58:48',NULL,'ampere','1327','الجهاد','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('216','جمعة الحسن','','','','','1','0','2025-12-25 12:59:24',NULL,'ampere','1352','الجهاد','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','الجهاد','0.00','1.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('218','عبد الهادي مستأجر دبوري','','','','','1','0','2025-12-25 13:01:19',NULL,'ampere','1339','الجهاد','0.00','1.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('219','عدنان صالح جمعة','','','','','1','0','2025-12-25 13:02:12',NULL,'ampere','1340','الجهاد','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','الجهاد','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','الجهاد','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('222','مالك الحوراني','','','','','1','0','2025-12-25 13:04:55',NULL,'ampere','1329','الجهاد','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','الجهاد','0.00','3.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','الجهاد','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','الحايك','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','الحايك','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','1232','الحايك','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('228','عبدالله دعبول','','','','','1','0','2025-12-25 13:10:35',NULL,'ampere','1237','الحايك','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('229','عدنان محمد العراقي','','','','','1','0','2025-12-25 13:11:13',NULL,'ampere','1235','الحايك','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','الحايك','0.00','7.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','الحايك','0.00','2.50','24.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('232','نادية حمدان','','','','','1','0','2025-12-25 13:14:13',NULL,'ampere','1229','الحايك','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','الحايك','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('234','ابو عمار صطوف','','','','','1','0','2025-12-25 13:16:00',NULL,'ampere','170','الحنون','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('235','الحجة ام اسماعيل','','','','','1','0','2025-12-25 13:16:28',NULL,'ampere','171','الحنون','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','الحنون','0.00','4.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('237','صيدلية الميعاري','','','','موتير المحلات','1','0','2025-12-25 13:17:40',NULL,'ampere','177','الحنون','0.00','10.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('238','عاهد ابو صلاح','','','','','1','0','2025-12-25 13:18:14',NULL,'ampere','169','الحنون','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','الحنون','0.00','10.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('240','احمد اخو ابو فادي','','','','موتير المحلات','1','0','2025-12-25 13:22:10',NULL,'ampere','1372','الصمود','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','الصمود','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('242','محمد فجر ','','','','','1','0','2025-12-25 13:23:02',NULL,'ampere','1375','الصمود','0.00','3.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('243','احمد اليوسف','','','','','1','0','2025-12-25 13:24:26',NULL,'ampere','883','العشقة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('244','ام وسام العمشى','','','','','1','0','2025-12-25 13:26:03',NULL,'ampere','878','العشقة','0.00','2.50','6.66','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('245','ريما حسين','','','','','1','0','2025-12-25 13:26:35',NULL,'ampere','884','العشقة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('246','وسام العمشى','','','','','1','0','2025-12-25 13:27:07',NULL,'ampere','877','العشقة','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','العيوطي','0.00','3.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('248','احمد ابو عنتر','','','','','1','0','2025-12-25 13:30:17',NULL,'ampere','651','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('249','احمد الاحمد','','','','','1','0','2025-12-25 13:30:50',NULL,'ampere','657','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('250','ادم خضرو','','','','','1','0','2025-12-25 13:31:27',NULL,'ampere','655','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('251','الايوبي سنترال','','','','','1','1','2025-12-25 13:32:01',NULL,'ampere','640','العيوطي','0.00','2.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','العيوطي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('253','اياد يوسف','','','','','1','0','2025-12-25 13:32:54',NULL,'ampere','661','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('254','جهاد الشاويش','','','','','1','0','2025-12-25 13:33:25',NULL,'ampere','659','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('255','عائشة جهجاه','','','','','1','0','2025-12-25 13:34:02',NULL,'ampere','660','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('256','عامر سليم','','','','','1','0','2025-12-25 13:34:28',NULL,'ampere','662','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('257','عبد الله اللحام','','','','','1','0','2025-12-25 13:35:26',NULL,'ampere','639','العيوطي','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','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('259','علاء عز الدين','','','','','1','1','2025-12-25 13:36:28',NULL,'ampere','646','العيوطي','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('260','علاء غاز','','','','','1','1','2025-12-25 13:36:53',NULL,'ampere','654','العيوطي','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','العيوطي','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','العيوطي','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','العيوطي','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','العيوطي','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','العيوطي','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('266','محمد ايوب','','','','','1','0','2025-12-25 13:39:50',NULL,'ampere','663','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('267','محمد سعد','','','','','1','0','2025-12-25 13:40:25',NULL,'ampere','658','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('268','محمد محمود ابراهيم','','','','','1','0','2025-12-25 13:40:50',NULL,'ampere','641','العيوطي','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','العيوطي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('270','مصطفى عراقي','','','','','1','0','2025-12-25 13:42:32',NULL,'ampere','656','العيوطي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('271','مصطفى محسن','','','','','1','0','2025-12-25 13:42:59',NULL,'ampere','638','العيوطي','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','العيوطي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('273','يوسف العلي','','','','','1','0','2025-12-25 13:43:44',NULL,'ampere','653','العيوطي','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','الكفاح','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','الكفاح','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('276','الحج ابو عاطف','','','','','1','1','2025-12-25 13:46:28',NULL,'ampere','1058','الكفاح','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','الكفاح','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','الكفاح','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','الكفاح','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','الكفاح','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('281','علي عنبتاوي','','','','','1','0','2025-12-25 13:49:14',NULL,'ampere','1051','الكفاح','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','الكفاح','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','الكفاح','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','الكفاح','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('285','وسيم احمد','','','','','1','0','2025-12-25 13:51:08',NULL,'ampere','1053','الكفاح','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','الكفاح','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','بنايتنا','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','بنايتنا','0.00','10.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','بنايتنا','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','بنايتنا','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','بنايتنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('292','ثامر فرحان','','','','','1','0','2025-12-25 13:56:19',NULL,'ampere','734','بنايتنا','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','بنايتنا','0.00','3.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('294','مؤمن البيت','','','','','1','1','2025-12-25 13:57:21',NULL,'ampere','733','بنايتنا','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','بنايتنا','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','بنايتنا','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','بنايتنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('298','ابو الياس','','','','','1','0','2025-12-25 14:00:10',NULL,'ampere','1137','جمال قداح','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','جمال قداح','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','جمال قداح','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('301','احمد غزلان','','','','','1','0','2025-12-25 14:02:09',NULL,'ampere','1127','جمال قداح','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','جمال قداح','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','جمال قداح','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','جمال قداح','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','جمال قداح','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','جمال قداح','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('307','جهاد عثمان','','','','','1','0','2025-12-25 14:05:41',NULL,'ampere','1121','جمال قداح','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('308','حسين الاغا','','','','','1','0','2025-12-25 14:06:02',NULL,'ampere','1131','جمال قداح','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','جمال قداح','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','جمال قداح','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('311','خليل ناصر','','','','','1','0','2025-12-25 14:07:37',NULL,'ampere','1130','جمال قداح','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('312','علي الدايا','','','','','1','0','2025-12-25 14:08:27',NULL,'ampere','1143','جمال قداح','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('313','علي حميدي','','','','','1','0','2025-12-25 14:08:55',NULL,'ampere','1138','جمال قداح','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('314','علي خلف','','','','','1','0','2025-12-25 14:09:20',NULL,'ampere','1142','جمال قداح','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('315','فادي الصالح','','','','','1','0','2025-12-25 14:10:01',NULL,'ampere','1148','جمال قداح','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('316','فادي علي','','','','','1','0','2025-12-25 14:10:26',NULL,'ampere','1126','جمال قداح','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('317','محمد الزمار','','','','','1','0','2025-12-25 14:10:52',NULL,'ampere','1118','جمال قداح','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','1123','جمال قداح','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('319','مروان فرج','','','','','1','0','2025-12-25 14:11:44',NULL,'ampere','1132','جمال قداح','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','جمال قداح','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('321','ابو سليمان البلاط','','','','','1','0','2025-12-25 14:14:21',NULL,'ampere','595','حاتم','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('322','احمد علي','','','','','1','0','2025-12-25 14:14:46',NULL,'ampere','593','حاتم','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','حاتم','0.00','5.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','حاتم','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('325','رامي ابو جاموس','','','','','1','0','2025-12-25 14:16:09',NULL,'ampere','573','حاتم','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','حاتم','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('327','سامر دحويش','','','','','1','0','2025-12-25 14:17:11',NULL,'ampere','596','حاتم','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('328','صالح الاحمد','','','','','1','0','2025-12-25 14:17:37',NULL,'ampere','574','حاتم','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('329','عبد الحميد دعبول','','','','','1','0','2025-12-25 14:18:08',NULL,'ampere','576','حاتم','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('330','عبد حمود','','','','','1','0','2025-12-25 14:18:44',NULL,'ampere','578','حاتم','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('331','عبد الله حالول','','','','','1','0','2025-12-25 14:19:18',NULL,'ampere','575','حاتم','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','حاتم','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('333','محمد درعاوي فرن','','','','','1','0','2025-12-25 14:20:20',NULL,'ampere','589','حاتم','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','حاتم','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','حاتم','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('336','احمد عكاوي','','','','','1','0','2025-12-25 14:28:37',NULL,'ampere','720','حسنين','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('337','احمد نابلسي','','','','','1','0','2025-12-25 14:29:01',NULL,'ampere','722','حسنين','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('338','الدكتور محمد خليل','','','','موتير المحلات','1','0','2025-12-25 14:29:41',NULL,'ampere','6003','حسنين','0.00','5.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('339','الدكتور معن','','','','موتير المحلات','1','0','2025-12-25 14:30:25',NULL,'ampere','6002','حسنين','0.00','8.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('340','الصفوري عيادة اول المخيم','','','','','1','0','2025-12-25 14:31:04',NULL,'ampere','7322','حسنين','0.00','20.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','حسنين','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','حسنين','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','حسنين','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','حسنين','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('345','حسن قاسم','','','','موتير المحلات','1','0','2025-12-25 14:34:38',NULL,'ampere','6000','حسنين','0.00','1.50','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('346','حمزة طه','','','','','1','0','2025-12-25 14:35:03',NULL,'ampere','705','حسنين','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','حسنين','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('348','رياض المصطفى','','','','','1','0','2025-12-25 14:36:12',NULL,'ampere','7321','حسنين','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('349','سلوى ابو شليح','','','','','1','0','2025-12-25 14:37:09',NULL,'ampere','702','حسنين','0.00','2.50','3.20','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('350','صلاح داوود','','','','','1','0','2025-12-25 14:37:36',NULL,'ampere','721','حسنين','0.00','2.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','حسنين','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','حسنين','0.00','2.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('353','عبد العفيس','','','','','1','0','2025-12-25 14:39:22',NULL,'ampere','707','حسنين','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','حسنين','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('355','علي الفرن','','','','','1','0','2025-12-25 14:40:11',NULL,'ampere','701','حسنين','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','حسنين','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','حسنين','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('358','محمصة الشامي','','','','موتير المحلات','1','0','2025-12-25 14:42:11',NULL,'ampere','6001','حسنين','0.00','6.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('359','محمد الكفري','','','','','1','0','2025-12-25 14:42:46',NULL,'ampere','728','حسنين','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('360','محمد غلايني','','','','','1','0','2025-12-25 14:43:14',NULL,'ampere','711','حسنين','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','حسنين','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','حسنين','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('363','محمد وسام الحوت','','','','10 الشهر','1','0','2025-12-25 14:44:43',NULL,'ampere','712','حسنين','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','حسنين','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('365','ياسين فرن','','','','','1','0','2025-12-25 14:45:31',NULL,'ampere','704','حسنين','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('366','احمد كساب','','','','','1','0','2025-12-25 14:47:05',NULL,'ampere','751','حليمة','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','حليمة','0.00','5.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('368','بكر شباكي','','','','','1','0','2025-12-25 14:48:00',NULL,'ampere','764','حليمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('369','توفيق ابو سويد','','','','','1','0','2025-12-25 14:48:25',NULL,'ampere','748','حليمة','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','حليمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('371','عبد الوهاب جعفر','','','','','1','0','2025-12-25 14:49:21',NULL,'ampere','767','حليمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('372','فادي حليمة','','','','','1','1','2025-12-25 14:49:50',NULL,'ampere','758','حليمة','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','حليمة','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','حليمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('375','محمد حمود','','','','','1','0','2025-12-25 14:51:13',NULL,'ampere','763','حليمة','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('376','منير شوقي','','','','','1','0','2025-12-25 14:51:42',NULL,'ampere','754','حليمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('377','وسيم جار اهلي','','','','','1','0','2025-12-25 14:52:09',NULL,'ampere','749','حليمة','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','حليمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('379','بلال دحويش','','','','','1','0','2025-12-25 15:01:09',NULL,'ampere','978','سالم الوالي','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','972','سالم الوالي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('381','حسن الحامد','','','','','1','0','2025-12-25 15:01:55',NULL,'ampere','975','سالم الوالي','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','سالم الوالي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('383','عبد عشموطي','','','','','1','0','2025-12-25 15:02:48',NULL,'ampere','989','سالم الوالي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('384','عبود العبود','','','','','1','0','2025-12-25 15:03:15',NULL,'ampere','987','سالم الوالي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('385','عثمان الحامد','','','','','1','0','2025-12-25 15:03:43',NULL,'ampere','993','سالم الوالي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('386','فخري اسماعيل','','','','','1','0','2025-12-25 15:04:14',NULL,'ampere','988','سالم الوالي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('387','فضل حسن','','','','','1','0','2025-12-25 15:04:55',NULL,'ampere','991','سالم الوالي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('388','فيصل علاو','','','','','1','0','2025-12-25 15:05:22',NULL,'ampere','973','سالم الوالي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('389','قاسم ابو زيد','','','','','1','0','2025-12-25 15:05:49',NULL,'ampere','971','سالم الوالي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('390','محمد الحامد','','','','','1','0','2025-12-25 15:06:12',NULL,'ampere','976','سالم الوالي','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('391','محمد نور المصطفى','','','','','1','0','2025-12-25 15:07:02',NULL,'ampere','990','سالم الوالي','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('392','ابراهيم الحلبي','','','','','1','0','2025-12-25 15:08:18',NULL,'ampere','894','صيدلية فاطمة','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('393','ابو الوليد ','','','','','1','0','2025-12-25 15:08:41',NULL,'ampere','892','صيدلية فاطمة','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','صيدلية فاطمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('395','امبوبا','','','','','1','1','2025-12-25 15:09:42',NULL,'ampere','899','صيدلية فاطمة','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','صيدلية فاطمة','0.00','5.00','20.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('397','جابر مقدسي','','','','','1','0','2025-12-25 15:10:49',NULL,'ampere','902','صيدلية فاطمة','0.00','4.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('398','دكتور محمد عيادة','','','','موتير المحلات','1','0','2025-12-25 15:11:22',NULL,'ampere','897','صيدلية فاطمة','0.00','5.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('399','سالم عبد','','','','','1','0','2025-12-25 15:11:46',NULL,'ampere','895','صيدلية فاطمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('400','صالون ليا','','','','','1','0','2025-12-25 15:12:09',NULL,'ampere','900','صيدلية فاطمة','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('401','علي ابو جاموس','','','','','1','0','2025-12-25 15:12:33',NULL,'ampere','901','صيدلية فاطمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('402','يوسف نبهاني','','','','','1','0','2025-12-25 15:13:00',NULL,'ampere','893','صيدلية فاطمة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('403','ام محمد','','','','','1','0','2025-12-25 15:13:51',NULL,'ampere','614','عاطف','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('404','حمد الصفري','','','','','1','0','2025-12-25 15:14:15',NULL,'ampere','615','عاطف','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('405','عاطف','','','','','1','1','2025-12-25 15:14:36',NULL,'ampere','605','عاطف','0.00','10.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('406','عبد الله قمبر','','','','','1','0','2025-12-25 15:15:03',NULL,'ampere','607','عاطف','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('407','علاء عابد علي','','','','','1','0','2025-12-25 15:15:28',NULL,'ampere','609','عاطف','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','عاطف','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','عاطف','0.00','3.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','عاطف','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('411','ابراهيم الخضر ','','','','','1','0','2025-12-25 15:24:59',NULL,'ampere','805','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('412','ابو شملي','','','','','1','0','2025-12-25 15:25:26',NULL,'ampere','786','عبد سلامة','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','عبد سلامة','0.00','2.00','20.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('414','احمد اليوسف','','','','','1','0','2025-12-25 15:26:27',NULL,'ampere','803','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('415','احمد برو','','','','','1','0','2025-12-25 15:26:51',NULL,'ampere','2.5','عبد سلامة','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('416','احمد غدار','','','','','1','0','2025-12-25 15:27:23',NULL,'ampere','782','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('417','احمد غدار 1','','','','','1','0','2025-12-25 15:28:52',NULL,'ampere','795','عبد سلامة','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','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('419','الوحش','','','','','1','0','2025-12-25 15:30:29',NULL,'ampere','801','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('420','ام خالد البرجا','','','','','1','0','2025-12-25 15:30:54',NULL,'ampere','799','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('421','ام رشيد بعلبي','','','','','1','1','2025-12-25 15:31:44',NULL,'ampere','800','عبد سلامة','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','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('423','بسام النجار','','','','بالعلبة 3 امبير','1','0','2025-12-25 15:34:31',NULL,'ampere','793','عبد سلامة','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','عبد سلامة','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','عبد سلامة','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','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('427','سامر دروبي','','','','','1','0','2025-12-25 15:37:21',NULL,'ampere','811','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('428','عصام عبد العال','','','','','1','0','2025-12-25 15:38:05',NULL,'ampere','809','عبد سلامة','0.00','2.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','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('430','عماد حمد','','','','بالعلبة 3 امبير','1','0','2025-12-25 15:39:12',NULL,'ampere','785','عبد سلامة','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','عبد سلامة','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','806','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('433','محمد احمد','','','','','1','0','2025-12-25 15:41:02',NULL,'ampere','781','عبد سلامة','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('434','محمد لداوي','','','','','1','0','2025-12-25 15:41:34',NULL,'ampere','794','عبد سلامة','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('435','محمد مختار العلي','','','','','1','0','2025-12-25 15:42:04',NULL,'ampere','798','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('436','محمد مهدي علاص','','','','','1','0','2025-12-25 15:42:31',NULL,'ampere','796','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('437','ندى عبد الرحيم','','','','بالعلبة 4 امبير','1','0','2025-12-25 15:43:29',NULL,'ampere','788','عبد سلامة','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','عبد سلامة','0.00','6.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('439','هدى العزبة','','','','','1','0','2025-12-25 15:44:39',NULL,'ampere','784','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('440','وائل العبد','','','','','1','0','2025-12-25 15:45:02',NULL,'ampere','804','عبد سلامة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('441','ابو صالح','','','','','1','0','2025-12-25 15:46:43',NULL,'ampere','1292','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','0.00','2.50','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('449','رائد الهبود','','','','','1','0','2025-12-25 15:50:51',NULL,'ampere','1321','قاعة الشعب','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('450','رضوان الاحمد','','','','','1','0','2025-12-25 15:51:23',NULL,'ampere','1311','قاعة الشعب','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('451','زكريا خانتوماني','','','','','1','0','2025-12-25 15:52:14',NULL,'ampere','1293','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','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','قاعة الشعب','0.00','2.50','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('458','محمود عبود','','','','','1','0','2025-12-25 15:56:18',NULL,'ampere','1319','قاعة الشعب','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('459','نجوى حزينة','','','','','1','0','2025-12-25 15:56:43',NULL,'ampere','1305','قاعة الشعب','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('460','نشأت مرة','','','','','1','0','2025-12-25 15:57:09',NULL,'ampere','1308','قاعة الشعب','0.00','3.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('461','ابو ايمن حبوش','','','','','1','0','2025-12-25 15:58:45',NULL,'ampere','453','محلنا','0.00','3.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('462','ابو علي فرن','','','','','1','0','2025-12-25 15:59:07',NULL,'ampere','448','محلنا','0.00','4.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','محلنا','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','محلنا','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','محلنا','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','محلنا','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','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('468','اروى','','','','','1','0','2025-12-25 16:02:44',NULL,'ampere','461','محلنا','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','محلنا','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','محلنا','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','محلنا','0.00','2.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('472','ام لولو','','','','','1','0','2025-12-25 16:04:38',NULL,'ampere','459','محلنا','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','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('474','بسام عبد الهادي','','','','','1','0','2025-12-25 16:05:43',NULL,'ampere','4550','محلنا','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('475','بشار الخالد','','','','','1','0','2025-12-25 16:06:15',NULL,'ampere','474','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('476','بلال اخو عاطف','','','','','1','0','2025-12-25 16:06:55',NULL,'ampere','446','محلنا','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','محلنا','0.00','20.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','محلنا','0.00','3.00','25.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('479','دلال حريري','','','','','1','0','2025-12-25 16:08:54',NULL,'ampere','457','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('480','زجاج','','','','','1','0','2025-12-25 16:09:14',NULL,'ampere','445','محلنا','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','محلنا','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','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('483','عبد شراب','','','','','1','0','2025-12-25 16:10:49',NULL,'ampere','458','محلنا','0.00','2.50','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('484','علي محمود','','','','','1','0','2025-12-25 16:11:14',NULL,'ampere','478','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('485','فارس خليفة','','','','','1','0','2025-12-25 16:11:40',NULL,'ampere','476','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('486','ليث محمد','','','','','1','0','2025-12-25 16:12:03',NULL,'ampere','466','محلنا','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('487','ماهر شحادة','','','','','1','0','2025-12-25 16:12:30',NULL,'ampere','472','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('488','محمد الشريف','','','','','1','0','2025-12-25 16:12:52',NULL,'ampere','471','محلنا','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','محلنا','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','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('491','وليد عثمان','','','','','1','0','2025-12-25 16:14:30',NULL,'ampere','463','محلنا','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('492','ابو جلال المورق','','','','','1','0','2025-12-25 16:18:02',NULL,'ampere','1020','نفيسة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('493','ابو صادق خنزالا','','','','','1','0','2025-12-25 16:18:31',NULL,'ampere','1008','نفيسة','0.00','3.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('494','احمد اسماعيل','','','','','1','0','2025-12-25 16:19:10',NULL,'ampere','1011','نفيسة','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','نفيسة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('496','اكرم علي','','','','','1','0','2025-12-25 16:20:06',NULL,'ampere','1024','نفيسة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('497','ام حسن نفيسة','','','','','1','0','2025-12-25 16:20:37',NULL,'ampere','1004','نفيسة','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','نفيسة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('499','رائد ابراهيم','','','','','1','0','2025-12-25 16:21:31',NULL,'ampere','1010','نفيسة','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','نفيسة','0.00','5.00','30.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('501','علي الشريف','','','','','1','0','2025-12-25 16:22:20',NULL,'ampere','1014','نفيسة','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','نفيسة','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','نفيسة','0.00','3.00','26.33','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('504','محمود الاسمر','','','','','1','0','2025-12-25 16:24:23',NULL,'ampere','1017','نفيسة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('505','مهند العمر','','','','','1','0','2025-12-25 16:24:49',NULL,'ampere','1021','نفيسة','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('506','وسيم العلي','','','','','1','0','2025-12-25 16:25:13',NULL,'ampere','1013','نفيسة','0.00','2.00','0.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('507','ابو عبود','','','','','1','0','2025-12-25 16:26:17',NULL,'ampere','520','وائل الغوراني','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('508','العسكري','','','','','1','0','2025-12-25 16:26:37',NULL,'ampere','522','وائل الغوراني','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('509','حمد احمد العيسى','','','','','1','0','2025-12-25 16:27:03',NULL,'ampere','527','وائل الغوراني','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('510','شادي عسلي','','','','','1','0','2025-12-25 16:27:24',NULL,'ampere','511','وائل الغوراني','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','وائل الغوراني','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('512','طه لوباني','','','','','1','0','2025-12-25 16:28:12',NULL,'ampere','513','وائل الغوراني','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','وائل الغوراني','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('514','عبد الله العلي','','','','','1','0','2025-12-25 16:29:10',NULL,'ampere','521','وائل الغوراني','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('515','عبودة المصطفى','','','','','1','0','2025-12-25 16:29:36',NULL,'ampere','525','وائل الغوراني','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('516','محمود ابراهيم ابو عيد','','','','','1','0','2025-12-25 16:30:04',NULL,'ampere','514','وائل الغوراني','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','وائل الغوراني','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','وائل الغوراني','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','وائل الغوراني','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','524','وائل الغوراني','0.00','1.00','35.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('521','محمد حواش','','','','','1','0','2025-12-26 03:33:32',NULL,'meter','496','الاسطبل','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','الاسطبل','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','صيدلية فاطمة','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','1302','قاعة الشعب','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','قاعة الشعب','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','الحنون','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','الحنون','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','الحنون','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','الحنون','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','الحنون','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','الحنون','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','الحنون','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','الجهاد','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','ابو باهي','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','حاتم','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','الحايك','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','سالم الوالي','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','سالم الوالي','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','سالم الوالي','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','نفيسة','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','نفيسة','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','نفيسة','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','جمال قداح','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','العيوطي','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','العيوطي','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','عبد سلامة','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','عبد سلامة','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','ابو تركي','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','سريس','11555.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('550','الدكتور بكر','','','','','1','0','2025-12-26 03:57:02',NULL,'meter','193','فايز لداوي','5466.00','10.00','0.00','640000.00','0.00','0.00');
INSERT INTO `customers` VALUES ('551','علي قاسم','','','','','1','0','2025-12-26 03:57:35',NULL,'meter','261','بركة','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','محلنا','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','محلنا','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','محلنا','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','محلنا','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','محلنا','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','صبرا','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','قاعة الشعب','157.00','5.00','0.00','390000.00','0.00','150.00');
INSERT INTO `customers` VALUES ('559','نبهان الحريري','','','','من عند ابو برهان ست شهور بنص القيمة من تاريخ 1/1/2026','1','0','2025-12-26 04:08:14',NULL,'ampere','467','محلنا','0.00','1.00','17.50','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','قاعة الشعب','0.00','2.00','33.00','0.00','0.00','0.00');
INSERT INTO `customers` VALUES ('561','داوود','','','','','1','0','2025-12-26 04:11:12',NULL,'meter','682','البليار','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','جمال قداح','0.00','5.00','0.00','390000.00','0.00','150.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_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;



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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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');


CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('admin','user') NOT NULL,
  `permissions` mediumtext DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` VALUES ('4','mo2min','uosama','$2y$10$ocM1qSFh8s384QqxcBN5S.Tda7aB66EcWdDoS/3RCQlCGcf3FSlg.','admin','[\"customers\",\"meters\",\"pricing\",\"exchange\",\"readings\",\"bills_gen\",\"bills_pay\",\"reports\",\"system\"]','1','2025-12-24 04:41:13');
INSERT INTO `users` VALUES ('3','osama','osamaadmin','$2y$10$baCzkD7gcZ9GDmuqy/Jg0.Qvo0L3QLETNaaMtMblCBMjYGhT1R5Gi','admin','[\"customers\",\"meters\",\"pricing\",\"exchange\",\"readings\",\"bills_gen\",\"bills_pay\",\"reports\",\"system\"]','1','2025-12-24 04:34:20');
INSERT INTO `users` VALUES ('5','ali me3are','ali','$2y$10$twO9uHyXZnE8Kq2SMAr.YOQdKZUKyZUvYBWQjpwzWKTqQm4DIYKUe','','[\"customers\",\"bills_gen\",\"bills_pay\"]','1','2025-12-24 12:18:34');

