INSERT INTO `customers` (`customer_id`, `name`, `phone`, `bill_amount`, `expiry_date`, `address`, `status`) VALUES
('RANG400', 'bipul fay', '1340601975', 500, '2026-04-10', NULL, 'active'),
('RANG401', 'shawon muktadir', '1615121739', 500, '2026-04-10', NULL, 'active'),
('RANG402', 'korim basa', '1715881691', 350, '2026-04-21', '(2nd)', 'active'),
('RANG403', 'sofiqul emon aps', '1915632668', 500, '2026-04-10', '(5th right)', 'active'),
('RANG404', 'jisa sumon', '1875747744', 500, '2026-04-10', '(5th 5c)', 'active'),
('RANG405', 'nizam fay', '1716456572', 500, '2026-04-10', NULL, 'active'),
('RANG406', 'sanjoy sumi', '1927658775', 500, '2026-04-10', NULL, 'active'),
('RANG407', 'plash rfl', '1775878893', 500, '2026-04-15', '(5th 5c)', 'active'),
('RANG408', 'mehadi home 5a', '1970520918', 500, '2026-04-10', '(5th 5a)', 'active'),
('RANG409', 'sabeha bisty aj', '1976517190', 500, '2026-04-01', '(room 14)', 'active'),
('RANG410', 'mehadi faysal the', '1755710753', 500, '2026-04-10', '(2nd 2a)', 'active'),
('RANG411', 'rezaul shopnopuri', '1306428461', 300, '2026-04-15', '(security)', 'active'),
('RANG412', 'roshid rfl', '1601330902', 500, '2026-04-10', '(2nd)', 'active'),
('RANG413', 'imrul rfl', '1712353810', 500, '2026-04-10', '(3rd floor)', 'active'),
('RANG414', 'orin rfl', '1332816986', 500, '2026-04-10', '(2nd)', 'active'),
('RANG415', 'jitu rajabari', '1712089949', 500, '2026-04-10', '(4th floor)', 'active'),
('RANG416', 'saiful dulal', '1328167616', 500, '2026-04-10', NULL, 'active'),
('RANG417', 'akhi kobita', '1518707843', 0, '2026-04-01', '(6th )', 'active'),
('RANG418', 'saymon mahi', '1963613751', 500, '2026-04-10', '(3rd 3b)', 'active'),
('RANG419', 'nisan samia', '1843732410', 600, '2026-04-10', '(6th 6a)', 'active'),
('RANG420', 'rayhan aps', '1602598302', 500, '2026-04-10', NULL, 'active'),
('RANG421', 'shisir samia', '1753384180', 500, '2026-04-07', '(2nd 2b)', 'active'),
('RANG422', 'saiful amtola', '1718797478', 0, '2026-04-10', '(2nd)', 'active'),
('RANG423', 'foysal samia', '1307105080', 500, '2026-04-10', NULL, 'active'),
('RANG424', 'sahin adiba', '1739797797', 500, '2026-04-10', NULL, 'active'),
('RANG425', 'younus bitishpara', '1607393045', 500, '2026-04-10', NULL, 'active'),
('RANG426', 'sohag rajabari', '1849657468', 500, '2026-04-25', NULL, 'active'),
('RANG427', 'rajon amtola', '1911997264', 500, '2026-04-15', NULL, 'active'),
('RANG428', 'alamin vai', '1677530014', 500, '2026-04-15', NULL, 'active'),
('RANG429', 'sorif rajib', '1705568207', 500, '2026-04-10', NULL, 'active'),
('RANG430', 'hira niribili', '1601502266', 500, '2026-04-01', '(9th 9d)', 'active'),
('RANG431', 'murad houqe', '1994314251', 0, '2026-04-01', NULL, 'active'),
('RANG432', 'nawaz sami', '1818691796', 500, '2026-04-10', '(4th 4d)', 'active'),
('RANG433', 'ariful adiba', '1715035523', 500, '2026-04-15', NULL, 'active'),
('RANG434', 'sohel fozlu', '1729600670', 0, '2026-04-01', NULL, 'active'),
('RANG435', 'majaharul green', '1955592000', 500, '2026-04-15', '(b2/3b)', 'active'),
('RANG436', 'mahmuda pakha', '1923819881', 500, '2026-04-15', NULL, 'active'),
('RANG437', 'rasel amtola', '1772311646', 400, '2026-04-15', NULL, 'active'),
('RANG438', 'rabbi pakha office', '1679269558', 500, '2026-04-15', '(office)', 'active'),
('RANG439', 'siam aps back', '1339451747', 500, '2026-04-21', '(4th)', 'active'),
('RANG440', 'nasir jamtola', '1731798426', 300, '2026-04-21', NULL, 'active'),
('RANG441', 'zafir', '1930992767', 0, '2026-04-21', '(6th left -floor)', 'active'),
('RANG442', 'falguni amtola', '1716364877', 500, '2026-04-10', '(5th)', 'active'),
('RANG443', 'likhon rose', '1722657681', 500, '2026-04-10', NULL, 'active'),
('RANG444', 'tabiha jamtola', '1903108776', 500, '2026-04-15', '(4th )', 'active'),
('RANG445', 'robiul faydabad', '1786661905', 0, '2026-04-01', '(6th 6a )', 'active'),
('RANG446', 'tanvir sami', '1642588746', 500, '2026-04-10', '(8th )', 'active'),
('RANG447', 'kisukhon abashon', '1738483944', 500, '2026-04-10', NULL, 'active'),
('RANG448', 'rokon samia', '1857083146', 500, '2026-04-10', '(7th 7a)', 'active'),
('RANG449', 'mahim fay', '173604763', 500, '2026-04-10', '(bakary)', 'active'),
('RANG450', 'mukta kobita', '1946546030', 500, '2026-04-10', '(gf)', 'active'),
('RANG451', 'kawser salun', '1757123943', 500, '2026-04-10', '(salun)', 'active'),
('RANG452', 'siam mamun', '1623735459', 300, '2026-04-10', 'gf', 'active'),
('RANG453', 'sobuz farha', '1787873024', 500, '2026-04-07', '(6th)', 'active'),
('RANG454', 'shamim taznur', '1727611159', 500, '2026-04-10', '(6th)', 'active'),
('RANG455', 'rahat popi', '1883719459', 500, '2026-04-10', '(gf)', 'active'),
('RANG456', 'abbas anamul', '1768885647', 500, '2026-04-10', '(gf)', 'active'),
('RANG457', 'afiya nadia', '1973251768', 500, '2026-04-10', '(gf)', 'active'),
('RANG458', 'tahasan pro', '1611525558', 500, '2026-04-15', '(8th)', 'active'),
('RANG459', 'din islam taznur', '1888702072', 500, '2026-04-15', NULL, 'active'),
('RANG460', 'zahid asad', '1317933946', 0, '2026-04-01', '(2nd )', 'active'),
('RANG461', 'tonny anik', '1621248720', 500, '2026-04-15', NULL, 'active'),
('RANG462', 'mou babul', '1827586168', 500, '2026-04-15', '(3rd)', 'active'),
('RANG463', 'rafiul home', '1708429561', 600, '2026-04-15', '(9th 9c)', 'active'),
('RANG464', 'munna giash', '1816926990', 500, '2026-04-15', NULL, 'active'),
('RANG465', 'othoi iiyan', '1332588980', 500, '2026-04-21', NULL, 'active'),
('RANG466', 'bejoy uf', '1941201678', 500, '2026-04-07', NULL, 'active'),
('RANG467', 'mijan sami', '1345962159', 500, '2026-04-07', '(3rd 3a)', 'active'),
('RANG468', 'dola sorna', '1804336650', 0, '2026-04-01', '(3rd)', 'active'),
('RANG469', 'saleem jim', '1634642840', 500, '2026-04-21', NULL, 'active'),
('RANG470', 'israfil basa', '1945956271', 0, '2026-04-01', '(gf)', 'active'),
('RANG471', 'rahman green', '1515695080', 500, '2026-04-10', '(b.2 4d)', 'active'),
('RANG472', 'nurislam sahin', '1718458321', 500, '2026-04-10', NULL, 'active'),
('RANG473', 'ripon rafin sp', '1737760902', 500, '2026-04-10', '(4th 4d)', 'active'),
('RANG474', 'nayeem redoy', '1634822234', 500, '2026-04-10', '(3rd left)', 'active'),
('RANG475', 'tanvir rafin sp', '1979659970', 500, '2026-04-10', '(2nd right)', 'active'),
('RANG476', 'tanzil houqe', '1936977331', 500, '2026-04-10', '(2nd 2a)', 'active'),
('RANG477', 'mahbub rafin sp', '1846632965', 0, '2026-04-01', '(4th right)', 'active'),
('RANG478', 'alamin', NULL, 0, '2026-04-01', NULL, 'active'),
('RANG479', 'ashik safayat', '1969270231', 500, '2026-04-07', NULL, 'active'),
('RANG480', 'mukta kowsik', '1925168705', 500, '2026-04-10', '(2nd)', 'active'),
('RANG481', 'ashik kbn', '1828649152', 500, '2026-04-15', NULL, 'active'),
('RANG482', 'mariya 21 tower', '1603861097', 500, '2026-04-10', '(2nd left)', 'active'),
('RANG483', 'Sopon morgat', '1789167927', 500, '2026-04-15', NULL, 'active'),
('RANG484', 'Jahid kuba moshjid', '1313786288', 500, '2026-04-07', NULL, 'active'),
('RANG485', 'Elma store', '1923100322', 0, '2026-04-01', NULL, 'active'),
('RANG486', 'Tanvir bipul fay', '1832118037', 400, '2026-04-10', NULL, 'active'),
('RANG487', 'hasan morgat', '1915637363', 500, '2026-04-15', NULL, 'active'),
('RANG488', 'mim rahman mor', '1300251980', 500, '2026-04-07', NULL, 'active'),
('RANG489', 'Kazi joy', '1877827716', 0, '2026-04-01', NULL, 'active'),
('RANG490', 'jamal kbn', '1716330496', 500, '2026-04-10', NULL, 'active'),
('RANG491', 'Mukul kbn back', '1716994239', 500, '2026-04-07', NULL, 'active'),
('RANG492', 'Sojib kuba moshjid', '1631696738', 0, '2026-04-01', NULL, 'active'),
('RANG493', 'Rajib kbn font', '1764960924', 0, '2026-04-01', NULL, 'active'),
('RANG494', 'Wafik morgat', '1716709617', 500, '2026-04-07', NULL, 'active'),
('RANG495', 'anowar kuba moshjid', '1886086884', 500, '2026-04-15', NULL, 'active'),
('RANG496', 'Tamim houqe', '1976893052', 500, '2026-04-25', NULL, 'active'),
('RANG497', 'Hakim badol', '1781820993', 500, '2026-04-15', NULL, 'active'),
('RANG498', 'rohotmullha morgat', '1409144409', 500, '2026-04-07', NULL, 'active'),
('RANG499', 'shuvo amtola', '1864781303', 500, '2026-04-10', '(10th 3b)', 'active'),
('RANG500', 'dina shamol', '1969872863', 500, '2026-04-15', NULL, 'active'),
('RANG501', 'Litton kbn back', '1950549353', 400, '2026-04-10', NULL, 'active'),
('RANG502', 'imtiaz', '1821198056', 0, '2026-04-07', NULL, 'active'),
('RANG503', 'sajjad rahman mor', '1733910572', 400, '2026-04-21', NULL, 'active'),
('RANG504', 'jui babul', '1624393201', 500, '2026-04-21', '(gf)', 'active'),
('RANG505', 'shakil aslam', '1715985236', 500, '2026-04-15', '(kbn font)', 'active'),
('RANG506', 'Yeasin rahman', '1928884533', 500, '2026-04-07', NULL, 'active'),
('RANG507', 'shamim shain dr', '1906200295', 500, '2026-04-01', NULL, 'active'),
('RANG508', 'Ajahar mojshid gat', '1997759107', 400, '2026-04-15', '(3rd)', 'active'),
('RANG509', 'pranto moshjid ghat', '1939729046', 500, '2026-04-15', NULL, 'active'),
('RANG510', 'Mushfiqur rahman', '1756871592', 500, '2026-04-10', NULL, 'active'),
('RANG511', 'Taher morgat', '1812975683', 500, '2026-04-15', NULL, 'active'),
('RANG512', 'akther alamin', '1918754926', 500, '2026-04-10', '(2nd)', 'active'),
('RANG513', 'Faruk dcp', '1819474160', 500, '2026-04-15', '(gf)', 'active'),
('RANG514', 'Juwel talukder', '1706780908', 0, '2026-04-01', NULL, 'active'),
('RANG515', 'Belal dokan dcp', '1712041895', 400, '2026-04-07', '(shop)', 'active'),
('RANG516', 'Bellal Home', '1712041895', 400, '2026-04-07', NULL, 'active'),
('RANG517', 'Hamza dcp', '1785646861', 400, '2026-04-10', NULL, 'active'),
('RANG518', 'Rakel emdad', '1710567281', 500, '2026-04-07', '(2nd floor)', 'active'),
('RANG519', 'Babul fay ad', '1980409479', 500, '2026-04-15', NULL, 'active'),
('RANG520', 'Fahim rahman mor', '1751594483', 500, '2026-04-10', '(2nd middel)', 'active'),
('RANG521', 'Sohel dangu', '1716054744', 500, '2026-04-15', NULL, 'active'),
('RANG522', 'Forid dangu', '1626772287', 500, '2026-04-15', NULL, 'active'),
('RANG523', 'Mostofa kbn back', '1712910868', 400, '2026-04-01', '(2nd right)', 'active'),
('RANG524', 'forhad kbn back', '1719429139', 500, '2026-04-10', NULL, 'active'),
('RANG525', 'Kisor houqe', '1857109811', 500, '2026-04-15', NULL, 'active'),
('RANG526', 'Mohasin kuba moshid', '1624357366', 400, '2026-04-15', NULL, 'active'),
('RANG527', 'Rafi rfl', '1609778499', 500, '2026-04-10', NULL, 'active'),
('RANG528', 'Mukta rahman', '1681409568', 500, '2026-04-10', NULL, 'active'),
('RANG529', 'sujon kbn', '1628809656', 500, '2026-04-10', NULL, 'active'),
('RANG530', 'rahman morgat', '1677309934', 0, NULL, '(3rd 3a)', 'active'),
('RANG531', 'Sumon press', '1677309934', 0, NULL, NULL, 'active'),
('RANG532', 'Mehadi morgat', '1815553019', 500, '2026-04-15', NULL, 'active'),
('RANG533', 'soikot rahman mor', '1799747891', 0, NULL, '(3rd 3b)', 'active'),
('RANG534', 'Siam', '1731373010', 0, NULL, NULL, 'active'),
('RANG535', 'Joy', '1841987869', 0, NULL, NULL, 'active'),
('RANG536', 'fayaj samia', '1959560840', 500, '2026-04-10', NULL, 'active'),
('RANG537', 'mehadi sumi', '1737605276', 500, '2026-04-10', NULL, 'active'),
('RANG538', 'piash liton', '1971328891', 500, '2026-04-07', NULL, 'active'),
('RANG539', 'habib samia', '1632106915', 500, '2026-04-07', NULL, 'active'),
('RANG540', 'monir shopnipuri', '1715762798', 500, '2026-04-10', '(2nd 2c)', 'active'),
('RANG541', 'mahdi mahi', '1908922767', 700, '2026-04-10', NULL, 'active'),
('RANG542', 'ibrahim green', '1963150411', 500, '2026-04-10', 'b1 2d', 'active'),
('RANG543', 'Mahbub tr', '1726042511', 500, '2026-04-10', NULL, 'active'),
('RANG544', 'Sabbir salun', '1951305059', 0, '2026-04-10', NULL, 'active'),
('RANG545', 'Ariyan adiba', NULL, 500, '2026-04-10', NULL, 'active'),
('RANG546', 'Abdullha adiba', '1822614636', 500, '2026-04-10', NULL, 'active'),
('RANG547', 'Sajon farha', '1776569718', 500, '2026-04-10', NULL, 'active'),
('RANG548', 'nur baki', '1775938535', 500, '2026-04-10', NULL, 'active'),
('RANG549', 'Azad alamin', '1805468945', 500, '2026-04-10', NULL, 'active'),
('RANG550', 'Juma plash', '1905767396', 600, '2026-04-10', NULL, 'active'),
('RANG551', 'yeasin tonmoy', '1926926654', 500, '2026-04-10', NULL, 'active'),
('RANG552', 'bipul sumon', '1839444182', 500, NULL, NULL, 'active'),
('RANG553', 'sohid dengu', '1714111689', 500, NULL, NULL, 'active'),
('RANG554', 'shuvo hin', NULL, 500, NULL, NULL, 'active'),
('RANG555', 'Midul Sikder', '1410401499', 0, NULL, NULL, 'active'),
('RANG556', 'Tanvir tonmoy', '1937128791', 500, NULL, NULL, 'active'),
('RANG557', 'rifat basa', '1600059831', 500, NULL, NULL, 'active'),
('RANG558', 'nayeem bitishpar', '1621793936', 0, NULL, NULL, 'active'),
('RANG559', 'umar anamul', '1894056217', 500, '2026-04-01', NULL, 'active'),
('RANG560', 'rakib tr', '1993155535', 500, '2026-04-01', NULL, 'active'),
('RANG561', 'momin konikaloy 2nd', '1737326616', 500, '2026-04-10', NULL, 'active'),
('RANG562', 'Imtiaz 21 tower', '1821198056', 500, '2026-04-07', NULL, 'active'),
('RANG563', 'rupa sami', '1612669686', 500, '2026-04-10', NULL, 'active'),
('RANG564', 'taima kbn', '1906301805', 500, '2026-04-07', NULL, 'active'),
('RANG565', 'rezwan taznur', '1841110149', 500, '2026-04-10', '(4th 4c)', 'active'),
('RANG566', 'Jihad baki', '1910602112', 500, '2026-04-07', NULL, 'active'),
('RANG568', 'Rony borishal', '1330462998', 500, '2026-04-10', NULL, 'active'),
('RANG569', 'kibria baki', '1621959215', 500, '2026-04-15', '(4th 4b)', 'active'),
('RANG570', 'Pranto amtola', '1717112566', 500, '2026-04-10', '(2nd fast door)', 'active'),
('RANG571', 'mijan lal', '1550028550', 500, '2026-04-07', NULL, 'active'),
('RANG573', 'farsin ontor', '1776000890', 500, '2026-04-10', NULL, 'active'),
('RANG574', 'mojidul ontor', '1911448166', 500, '2026-04-10', NULL, 'active'),
('RANG575', 'Sakib sami 5b', '1321155817', 500, '2026-04-07', '(lift 5b)', 'active'),
('RANG576', 'foysal home', '1787651203', 500, '2026-04-10', '(top floor)', 'active'),
('RANG577', 'gofur tonmoy', '1812926394', 500, '2026-04-10', NULL, 'active'),
('RANG578', 'Sorif asad', '1315721638', 500, '2026-04-10', '(gf floor)', 'active'),
('RANG579', 'rubel muktadir', '1993736586', 500, '2026-04-10', '(5th)', 'active'),
('RANG580', 'Limon tonmoy', '1735244188', 500, '2026-04-10', NULL, 'active'),
('RANG581', 'sumon tarik', '1324535139', 500, '2026-04-10', NULL, 'active'),
('RANG582', 'rokonuzzman farha', '1923750202', 500, '2026-04-10', NULL, 'active'),
('RANG583', 'rohman sahin', '1773332888', 500, '2026-04-07', NULL, 'active'),
('RANG585', 'fardin sami', '1735176110', 500, '2026-04-07', '(5th 5a)', 'active');
