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
(6, '#OPNAG-OW-00000006', '$2y$10$eOfeeBmJMq.05g2bj4VH/ObHsH0KBjtSJiAlc5fNaVIFXd9jxIz3e', '103.189.130.109', 'Md. Nayab Nezam Ansari', 'Naim Akhtar', 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, 17934 characters], 0x[encoded data, 10454 characters], 0x[encoded data, 15454 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'K', '45', 'K-45/302', 'SP Sukhobrishti Ln, Action Area III, Newtown, New Town, West Bengal 700135', NULL, 'f', '2', NULL, NULL, NULL, 'f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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-09 16:22:42', '2023-06-09 16:23:01'),
(7, '#OPNAG-OW-00000007', '$2y$10$ImQv7UjZEH5j41RRjPyd3e3.jRayX7zW32W/0VJjUXBLD0ACgHN/.', '122.163.86.114', 'Monirul Islam ', 'Nazrul Islam Molla', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Bhagowanpur pakapole Kashipur 24 pgs (s) 700135', NULL, '', '700135', NULL, NULL, '7407727505', 'mi9837380@gmail.com', '1990-01-05', '258220838683', 'AEEPI5077F', '', '', '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'K-24/202 Association', 'K-23/202', 'k-23', 'SP shukhobrishti Shapoorji New tiwn Kolkata 700135', NULL, 'f', '1', '420', 'No', '2', 'f', 12000, '', 3000, '', 6000.00, 5, '2023-06-01', 11, '2024-04-30', 4, 1, 'Mir Hossain', 'Modhu Hossain', 'Hudo laouhati Rajarhat pgs (n)700156', '700156', '1986-06-10', '9836943735', 'nayab1997@gmail.com', '393656133570', 'BZBPA0397R', '', '', '', '', '12456', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-10 11:33:47', '2023-06-10 12:13: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
(9, '#OPNAG-OW-00000009', '$2y$10$X45RVwFtItWgzVo5SrkWUOfMnc/ykLWE/F/EKBQrvUR/oL4xsL5EO', '122.163.86.114', '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+owner@gmail.com', '1998-10-26', '355087659876', 'BZBPA0379R', 0x[encoded data, 16006 characters], 0x[encoded data, 13302 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'H', '34', '4019', 'Inaljdbciueqbckjqe ckjea ckhsHbcsKJ ck szjc kaenbckjsaj lcec ', NULL, 'f', '2', '980', 'D-302/4', '15', 'f', 10000, 'Ten Thousand ', 24000, 'Twenty Four Thousand ', 10000.00, 10, '2023-07-01', 11, '2024-05-31', 8, 0, 'Upal chartterjee', 'K chartterjee', 'Hncwhwdnwncscknskchscnskcmisnxsknxwknxjsbcjwnucw kxbsjxnwjbxsjvxwgvdwx wknxkwmxkwnxwnjsnkxnwc. Iwbckwnciw ckw ksnckw c wmc knk. Kscnwknckwncksn isnkcnsc ', '280635', '1992-06-04', '9674946680', 'Upalchartt@gmail.com', '393656133570', 'BZBPA0379R', 0x[encoded data, 14966 characters], 0x[encoded data, 20614 characters], 0x[encoded data, 14246 characters], 0x[encoded data, 11702 characters], 'IVY NEST APPARTMENTS', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-10 15:19:25', '2023-06-10 15:24:30');
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
(10, '#OPNAG-OW-00000009', '$2y$10$mUKHgXwX2QzROKJ4LuqbZuMlZ8La7MMD6eYZIMdtXhVsIyo6RlANm', '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', 'BZBPA0397R', 0x[encoded data, 10350 characters], 0x[encoded data, 6526 characters], 0x[encoded data, 15462 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'K', '45', '1404', 'SP Sukhobrishti Ln, Action Area III, Newtown, New Town, West Bengal 700135', NULL, 'f', '2', '700', 'No', '4', 'f', 10000, 'Ten Thousand ', 20000, 'Twenty Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'Upal Chartterjee', 'k Chartterhee', 'hsgdudgkSBLJabx jsKJSBdbLJABDLKAD JBDJDLJWBD.QWD;Q AISHLDNSDK', '712356', '1996-03-07', '9038677216', 'upalchatt@gmail.com', '398080903020', 'bzbpa0379r', 0x[encoded data, 15462 characters], 0x[encoded data, 15462 characters], 0x[encoded data, 15462 characters], 0x[encoded data, 15462 characters], 'ugugiughkgkhhghj', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-10 18:53:07', '2023-06-10 18:57:27');
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
(11, '#OPNAG-OW-00000010', '$2y$10$gcpVevM9OU8wPuiaIASp9Om5x89DK4W2Py/FWomN0NpTAmpmq0ue2', '122.163.86.114', 'TAMIM AKHTAR', 'K Chatterjee', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'ARENA HOUSING COMPLEX', NULL, '', '700156', NULL, NULL, '9674946680', 'upalchatt@gmail.com', '1996-03-07', '532720454171', 'BDOPC6533J', 0x[encoded data, 9118 characters], 0x[encoded data, 9118 characters], 0x[encoded data, 9118 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'K', '45', '1404', 'SP Sukhobrishti Ln, Action Area III, Newtown, New Town, West Bengal 700135', NULL, 'f', '1', '700', 'No', '4', 'f', 10000, 'Ten Thousand ', 20000, 'Twenty Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'Md. Nayab Nezam Ansari', 'NEZAMUDDIN ANSARI', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '700119', '1998-10-26', '7003359699', 'nayab1997@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', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-10 19:05:43', '2023-06-10 19:07:37');
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
(12, '#OPNAG-OW-00000011', '$2y$10$QMFjFDFfZ27sVAtugf1mWur9BjiCQYvEP4SSt8ijun9exnD9x97vi', '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', 'BZBPA0397R', 0x[encoded data, 15462 characters], 0x[encoded data, 15462 characters], 0x[encoded data, 15462 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'K', '46', '1404', 'SP Sukhobrishti Ln, Action Area III, Newtown, New Town, West Bengal 700135SP Sukhobrishti Ln, Action Area III, Newtown, New Town, West Bengal 700135', NULL, 'f', '2', '700', 'k45/6', '6', 'f', 10000, 'Ten Thousand ', 20000, 'Twenty Thousand ', 122.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'Md. Nayab Nezam Ansari', 'NEZAMUDDIN ANSARI', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '700119', '1947-09-26', '9831496974', 'ananda.chakraborty2008@gmail.com', '398080903020', 'bzbpa0379r', 0x[encoded data, 9910 characters], 0x[encoded data, 9910 characters], 0x[encoded data, 9910 characters], 0x[encoded data, 9910 characters], 'IVY Nest Apartments', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-10 19:09:35', '2023-06-10 19:13:47');
