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
(165, '#OPNAG-OW-00000153', '$2y$10$mIjdxqepWE1doNxmcRCOIejR3.iNk.9RveXh/Wo4LGyyfhdMlTo/i', '157.40.98.166', 'Firoz ', 'Alam', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Major Arterial Road, Action Area II, Rajarhat, New Town, Kolkata - 700156 West Bengal, India.', NULL, '', '700156', NULL, NULL, '7278616746', 'ordealmarker@gmail.com', '2002-03-03', '452089565940', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'B', 'B-162', 'B-162/101', 'B-162/101 Sp shukhobrishti housing Newtown 700156', NULL, 'f', '1', '320', 'N/A', '1', 'f', 12000, 'Twelve Thousand ', 24000, 'Twenty Four Thousand ', 0.00, 10, '2023-08-23', 11, '2024-07-22', 6, 1, 'Kamran Akbar', 'Akbar Anwar', '299/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '700119', '2001-03-03', '7003359699', 'nayab1997@gmail.com', '631707958638', 'Ccupc3710k', 0x[encoded data, 12854 characters], '', 0x[encoded data, 14406 characters], 0x[encoded data, 11790 characters], 'IVY Nest Apartments', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-23 22:11:54', '2023-08-23 22:27:15');
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
(166, '#OPNAG-OW-00000154', '$2y$10$Q5xD8b6n85iXDCaEuMU9VOXULNtiiiDlVz2SAfrG0X1GaCaHRRkkC', '157.40.98.166', 'Jahanara Bibi', 'Gulab Ansari ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '3rd & 4th Floor Plot A2, M2 & N2, Sector V, Salt Lake Electronics Complex, Bidhan nagar Kolkata 700 091', NULL, '', '700091', NULL, NULL, '8961491694', 'ansarimdnayabnezam@gmail.com', '1992-06-14', '355087659876', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E394', 'E394/302', 'E394/302 SP Shukhobrishti Complex Newtown Kolkata 700135', NULL, 'f', '1', '320', 'N/A', '3', 'f', 12000, 'Twelve Thousand ', 24000, 'Twenty Four Thousand ', 0.00, 10, '2023-08-23', 11, '2024-07-22', 6, 1, 'Altamash Firoz', 'Firoz Alam', 'A-07/2, ARENA HOUSING COMPLEX\r\nSTREET-110\r\nBACK TO CENTAL MALL,NEWTOWN', '700156', '1989-03-29', '9062284971', 'nayab1997@gmail.com', '520971545843', 'Gdgoa4578t', 0x[encoded data, 11790 characters], '', 0x[encoded data, 14406 characters], 0x[encoded data, 12854 characters], 'TCS-120', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-23 22:45:25', '2023-08-23 22:56: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
(167, '#OPNAG-OW-00000155', '$2y$10$LZrW4.svItrEzpg98h8HSOyb/ii6Y60bXgemsI6N.OzX6i9TWunLG', '157.40.94.42', 'Md aquil khan', 'Sabir khan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '14/D enayat Ali shah nagar', NULL, 'nayab1997@gmail.com', '700119', NULL, NULL, '8981884165', 'altamashfiroz66@gmail.com', '1998-12-18', '134570531780', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 5, 'Eden court', '5', '1D', '203', '14/D enayat Ali shah nagar', NULL, 'f', '2', '400', '2', '4', 'f', 12500, 'Twelve Thousand Five Hundred ', 25000, 'Twenty Five Thousand ', 0.00, 10, '2023-08-23', 11, '2024-07-22', 6, 1, 'Taj mohammed', 'Akbar', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '700119', '1998-08-23', '7003359699', 'nayab1997@gmail.com', '352179346458', 'Afhid1192c', 0x[encoded data, 38078 characters], 0x[encoded data, 36774 characters], 0x[encoded data, 36430 characters], 0x[encoded data, 36734 characters], 'IVY Nest Apartments', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-23 23:25:31', '2023-08-23 23:34:52');
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
(168, '#OPNAG-OW-00000156', '$2y$10$pufVlQ8ze2v377SAf4tzfe/jTvTJhQihjZfYAOiy3LRjwSDNgEGnG', '103.189.130.108', 'Arshiya Jamil', 'C/o Syed Asif Hassan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'House No. 43008, old purulia road road no. 2, West mango, jamshedpur 832110', NULL, '', '832110', NULL, NULL, '9060594576', 'arshiya.jamil@gmail.com', '1987-04-11', '455245313365', NULL, 0x[encoded data, 21102 characters], 0x[encoded data, 32622 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E-443', 'E-443/304', 'E-443/304 SP Shukhobrishti Housing Complex, Rajarhat, Action Area III, Newtown, New Town, West Bengal 700135', NULL, 'f', '1', '420', 'E-443/S12-2', '3', 'f', 8500, 'Eight Thousand Five Hundred ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-08-15', 11, '2024-07-14', 6, 1, 'Talha Alam', 'Sarwar Alam', 'S/O Sarwar Alam, near , urdu middle school, muslim nagar , ward n0 12, Daltonganj, Daltonganj, Palamu, Jharkhand, 822101', '822101', '1998-01-22', '7488269895', 'alamtalha3@gmail.com', '410030194741', 'BZNPA1003N', 0x[encoded data, 14838 characters], 0x[encoded data, 15190 characters], 0x[encoded data, 18102 characters], 0x[encoded data, 21918 characters], '46045054', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-28 20:09:30', '2023-08-28 20:30:17');
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
(169, '#OPNAG-OW-00000157', '$2y$10$iTTTIpkJnNLwk7YxFjNQ6.1nVBwYT1YKa9kzsLngV3eMLjSZeawly', '5.163.249.143', 'Sandip Kumar', 'Khirodhari Kumar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Village: Sulumjuri, Post: Silli, Police Station: Silli, District: Ranchi, Jharkhand-835102', NULL, 'amit_320170@yahoo.com', '835102', NULL, NULL, '9674041947', 'Sandipkumar.sp16@gmail.com', '1989-01-01', '230842276662', NULL, 0x[encoded data, 11958 characters], 0x[encoded data, 11182 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E/388', 'E 388', 'E/388/302', 'E/388/302, 3RD Floor, SPANDAN, Shapoorji Pallonji - Shukhobristi Housing Cooperative Society, Plot E-1/E2, Action Area-III, New Town, Kolkata 700135', NULL, 'f', '1', '550', 'E-388/S10', '3', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-09-01', 11, '2024-07-31', 3, 1, 'ANKIT KUMAR MISHRA', 'Sunil Mishra', 'RAMPUR BUZURG, DEORIA, BANKATA, UTTAR PRADESH, PIN 274704', '274704', '1999-12-06', '7668452972', 'akakm1305@gmail.com', '605378176489', 'ESXPM5555B', 0x[encoded data, 12582 characters], 0x[encoded data, 13374 characters], 0x[encoded data, 14550 characters], 0x[encoded data, 18398 characters], 'TCS ID Card. Employee #2390279', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-30 04:55:05', '2023-08-30 05:58:22');
