INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(13, '#OPNAG-OW-00000012', '$2y$10$45b7/QZsuaFsn7jJ01KC9eJ7EK7N1pClCCPkU667QD1OZKozsCOze', '122.163.86.114', 'Md. Nayab Nezam Ansari', 'Nezamuddin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1998-10-26', '532720454171', 'BDOPC6533J', 0x[encoded data, 9118 characters], 0x[encoded data, 9910 characters], 0x[encoded data, 9910 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 3, 'TATA Avenida', 'K', '45', '1404', 'HGHDDETDGCHGXEQEH;JOKVKHVHKVHCJGXFHX', NULL, 'h', '2', '890', 'No', '8', 'f', 10000, 'Ten Thousand ', 20000, 'Twenty Thousand ', 1200.00, 9, '2023-06-10', 9, '2024-03-09', 6, 1, 'TAMIM AKHTAR', 'NAIM A', 'ARENA HOUSING COMPLEX\r\nSTREET-110\r\nBACK TO CENTAL MALL,NEWTOWN', '700156', '1998-01-06', '9674946680', 'tamimakhtar56@gmail.com', '398080903020', 'bzbpa0379r', 0x[encoded data, 15462 characters], 0x[encoded data, 15462 characters], 0x[encoded data, 15462 characters], 0x[encoded data, 15462 characters], 'IVY NEST APARTMENTS', 's', 'JGGDGJCH', 'NKHHJVHC', '799790090001', 'BHJIA0337R', 'YGIUIHV88', 'nayab1997+KOL@gmail.com', '7003359699', NULL, NULL, '2023-06-10 19:16:48', '2023-06-10 19:21:35');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(14, '#OPNAG-OW-00000013', '$2y$10$GtxRGM6CiFjE1n90u6qxo.DGrpij7.ds6HVX1OFJwTNLDnwjlmdrm', '49.37.48.178', 'sujan', 'soma', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Harishpur, Basirhat', NULL, '', '743412', NULL, NULL, '7595972963', 'sujanm312@gmail.com', '1995-06-29', '904529691949', 'CLXPM4153J', 0x[encoded data, 11158 characters], 0x[encoded data, 11158 characters], 0x[encoded data, 11158 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'A1B2', '111', '111', 'text', NULL, 'f', '1', '1200', '121', '1', 'f', 1500, 'One Thousand Five Hundred ', 1000, 'One Thousand ', 500.00, 15, '2023-06-29', 8, '2024-02-28', 8, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-10 19:23:50', '2023-06-10 19:38:37'),
(15, '#OPNAG-OW-00000014', '$2y$10$xzrwTQvtMpklq86z8K1WJO.URr8EIy0kgPCM6irg7QNrwbhaG31oS', '122.163.86.114', 'Tamim Akhtar', 'Znmzm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Povb', NULL, 'tamimakhtar@ivynestapartments.com', '700011', NULL, NULL, '9674946680', 'tamimakhtar56@gmail.com', '2023-06-10', '190016881633', 'BSFPA7485H', '', '', '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'K', '55', '77', 'Mmm', NULL, 'h', '2', '200', 'Hhg', '3', 'f', 20000, 'Twenty Thousand ', 20000, 'Twenty Thousand ', 260.00, 2, '2023-06-10', 6, '2023-12-09', 3, 2, 'Tamim Akhtar', 'Nn', 'Jffcb', '700156', '2023-06-10', '8961612477', 'tamimakhtar12@gmail.com', '180045767890', 'BSFPA7585j', '', '', '', '', '5996shn', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-10 21:10:12', '2023-06-10 21:45:31');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(21, '#OPNAG-OW-00000015', '$2y$10$/.DfMaYeyfWt/VT/N96xdO78KpcHbjXbvyNpn./bQ89GO97YkByv.', '103.189.130.109', 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1998-10-26', '355087659876', 'BZBPA0379R', 0x[encoded data, 12974 characters], 0x[encoded data, 11446 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'C', 'B-161', '4019', ' , m.b bcfxfxgjn.nklgykbhfghckrfhxsjvgj ghgvhdf', NULL, 'f', '1', '420', 'No', '12', 'f', 18521, 'Eighteen Thousand Five Hundred and Twenty One Only ', 34981, 'Thirty Four Thousand Nine Hundred and Eighty One Only ', 0.00, 0, '2023-06-11', 8, '2024-02-10', 2, 1, 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '700119', '1998-02-26', '7003359699', 'nayab1997@gmail.com', '393656133570', 'BSFPA8475H', 0x[encoded data, 10766 characters], 0x[encoded data, 15454 characters], 0x[encoded data, 10766 characters], 0x[encoded data, 17934 characters], 'IVY Nest Apartments', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-11 02:44:30', '2023-06-11 02:48:13');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(22, '#OPNAG-OW-00000016', '$2y$10$Kfo6xwnP84hKWrH6uZQLOufgIwJCx9cf5d7LHPsYAZXtoAptTlNVO', '115.187.42.233', 'Altamas firoz', 'Firoz alam', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Ali haider road math pata ', NULL, '', '700119', NULL, NULL, '8697275472', 'altamashfiroz66@gmail.com', '2001-02-15', '684208260741', 'AFJPS1192A', 0x[encoded data, 25726 characters], 0x[encoded data, 6262 characters], 0x[encoded data, 11934 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 6, 'Newtown heights', '1245', 'Westin', '254', 'Newtown Kolkata ', NULL, 'v', '4', '36000', '42', '15', 'f', 10000, 'Ten Thousand ', 5000, 'Five Thousand ', 150.00, 0, '2023-06-01', 6, '2023-11-30', 5, 1, 'Kamran akbar', 'Akbar ali', 'Titagarh kolkata', '700120', '1999-03-09', '8261972391', 'kamranakbar@gmail.com', '851382510132', 'Aafgj7413g', 0x[encoded data, 28998 characters], 0x[encoded data, 20342 characters], 0x[encoded data, 25094 characters], 0x[encoded data, 24982 characters], 'Service', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-11 13:13:58', '2023-06-11 13:34:57');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(23, '#OPNAG-OW-00000017', '$2y$10$1h/vg4rwe5RzH5L68CkCMuU.GuAzGt7GciDa4UZX.mmdQsnH.RB..', '110.227.67.105', 'Upal chatterjee ', 'Kaustav Chatterjee ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Uniworld city Newtown Kolkata ', NULL, 'abcd@gmail.com', '712103', NULL, NULL, '9038677216', 'upalchatt@gmail.com', '1995-03-07', '675489456754', 'BDOPC6533J', 0x[encoded data, 19062 characters], 0x[encoded data, 7678 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'Block K', 'K-145-AB', '125', 'K-145 ,Sukhobristi, Sapoorji, Kolkata-7000453', NULL, 'f', '2', '1000', 'NA', '4', 'f', 16500, 'Sixteen Thousand Five Hundred ', 30000, 'Thirty Thousand ', 2000.00, 5, '2023-05-12', 2, '2023-11-11', 4, 1, 'Ananda Chakraborty ', 'Demo Name', 'New Barrackpore, Kolkata', '734568', '1980-04-20', '8975644673', 'ananda.chakraborty2008@gmail.com', '876545674565', 'Bdocj4765u', 0x[encoded data, 14238 characters], 0x[encoded data, 4366 characters], 0x[encoded data, 19254 characters], 0x[encoded data, 11598 characters], 'Hdhs764475hgg', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-11 17:02:43', '2023-06-11 17:43:23');
