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
(209, '#OPNAG-OW-00000196', '$2y$10$JRJGMqazxclElbW2X6fL8u/TxycRgiPd3HnGaGuM.4mTsepA15mO6', '110.224.109.81', 'Arindam ghosh', 'Biswanath ghosh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Paisara. Kapsit, Hooghly, 712-613 West Bengal ', NULL, '', '712613', NULL, NULL, '9735556178', 'arindam.ghosh14@yahoo.com', '1987-04-14', '731627024151', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', '298', '204', 'D-298/204, Shapporji sukhobriti, action area 3 ', '700135', 'f', '1', '320', 'Yes', '2', 'f', 9000, 'Nine Thousand ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 1, 1, 'Sourav roy', 'Bijoy Krishna roy', 'G-1/485a and 486. Dall mill road Uttam Nagar west Delhi 110059', '110059', '2023-10-01', '9958690108', 'Roytan.sourav25@gmail.com', '426046201492', 'Avopr5280l', 0x[encoded data, 24374 characters], 0x[encoded data, 24798 characters], 0x[encoded data, 22750 characters], 0x[encoded data, 18414 characters], 'Bt57191', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-06 19:04:48', '2023-10-06 19:12:54');
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
(210, '#OPNAG-OW-00000197', '$2y$10$C5Z5RKCfJw3BUd.6rpbld.VY8.lU6E3Wb1rgfESlpbw3gssEZ28Pu', '152.58.183.66', 'Kusum Lata chugh', 'Amar singh juneja', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'C/O amar singh juneja, GF-1 T6, ground floor,sec 82, gracious tower,buildtech imperial estate, kheri kalan(113), faridabad, haryana -121002', NULL, 'kusumchugh79@gmail.com', '121002', NULL, NULL, '8918273922', 'sharondaisy631@gmail.com', '1955-10-02', '748295799148', NULL, 0x[encoded data, 16414 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J5/1403', 'Sp sukhobristi j5/1403', 'J5/1403', 'Sp sukhobristi action area 3 Rajarhat Newtown Kolkata 700135', '700135', 'f', '2', '480', 'Na', '14', 'f', 10000, 'Ten Thousand ', 19000, 'Nineteen Thousand ', 10974.00, 11, '2023-10-01', 11, '2024-08-31', 11, 2, 'Sharon Daisy Tigga ', 'Daniel Jonathan Tigga', 'L4/qr 9, cr road 20, sidhgora, near rama krishna mission school, jamshedpur, agrico, agrico east Singhbhum jharkhand 831009', '831009', '1994-07-17', '7992349781', 'sharondaisy631@gmail.com', '993830167553', 'BQKPT5249M', 0x[encoded data, 20238 characters], 0x[encoded data, 20030 characters], 0x[encoded data, 20334 characters], 0x[encoded data, 19646 characters], 'BT68077', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-06 19:17:23', '2023-10-06 19:27: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
(211, '#OPNAG-OW-00000198', '$2y$10$v9RqXMc0qqtV391gVfFeiu0SL2aLFL3udppU4QDB5MHhaW0sb19sa', '152.58.180.145', 'RIA CHATTERJEE', 'Saikat Banerjee', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '8/1C Gurudas Dutta Garden Lane, Kolkata 700067', NULL, 'bsaikat0501@gmail.com', '700067', NULL, NULL, '9038001029', 'mailme.riachatterjee@gmail.com', '1987-09-22', '233799054576', NULL, 0x[encoded data, 11206 characters], 0x[encoded data, 14542 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', '419', '0104', 'Newtown Sukhobristi Action Area 3, Kolkata', '700135', 'f', '1', '420', 'NA', '1', 'f', 9000, '', 18000, '', 0.00, 10, '2023-10-06', 11, '2024-09-05', 6, 1, 'Pradeepta Kishore Dash', 'Brajabandhu Dash', '1103, Balaji Residency, Plot No-52/53, Sector-15, Kharghar, Navi Mumbai', '410210', '1975-07-01', '8169050151', 'pradeeptakdash@yahoo.com', '975878045657', 'AFNPD5350C', 0x[encoded data, 16046 characters], 0x[encoded data, 13070 characters], 0x[encoded data, 16126 characters], 0x[encoded data, 13982 characters], 'NA', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '10% rent increment on renewal ', '2023-10-06 19:17:48', '2023-10-06 19:36:29');
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
(212, '#OPNAG-OW-00000199', '$2y$10$G19.L8R1yrDJ2e/hAq/cfeW/XTYusZrnmSr2hZpjE3HwHm14PCkkC', '42.110.168.85', 'SUBIR MONDAL', 'MAHANANDA MONDAL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Vill karinya, po pindira, dist hooghly, pin 712146', NULL, 'subirm@gmail.com ', '712146', NULL, NULL, '9883125393', 'Subirm@gmail.com', '2023-10-06', '586757450895', NULL, 0x[encoded data, 17790 characters], 0x[encoded data, 15310 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', '400', '202', 'S. P. Shukhobrishti newtown kolkata 700135 rajarhat', '700135', 'rk', '1', '320', 'Na', '2', 'f', 13500, 'Thirteen Thousand Five Hundred ', 27000, 'Twenty Seven Thousand ', 0.00, 0, '2023-10-06', 11, '2024-09-05', 6, 1, 'Chaitali kar', 'Dinbandhu kar', 'House no 11,road no 1,kantatoli colony netaji nagar ', '834001', '1990-04-04', '9939947253', 'Chaitali045@gmail.com', '647310639111', 'Cpdpk9675r', 0x[encoded data, 19438 characters], 0x[encoded data, 18350 characters], 0x[encoded data, 16510 characters], 0x[encoded data, 16878 characters], '870080', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-06 19:20:46', '2023-10-06 19:41:44');
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
(213, '#OPNAG-OW-00000200', '$2y$10$8/uQv3yMyEZIfBq2.k0gdO5D5Y.L2BdbkWdUV.sH8pLnN0lQc01OS', '157.40.74.36', 'Sandhya Saha', 'Brojendra mohan saha chowdhary', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Block 8, Flat no 40 lig skim 107, bidhannagar road ultadanga kolkata 700067', NULL, '', '700067', NULL, NULL, '9038681978', 'aditichowdhury66@gmail.com', '1943-12-28', '753845307200', NULL, 0x[encoded data, 25894 characters], 0x[encoded data, 26166 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E block', 'SP sukhibisti', 'E 472/103', 'SP sukhobisti housing complex, New town, Kolkata', '700135', 'f', '1', '320', 'Na', '1', 'f', 9000, '', 9000, '', 0.00, 0, '2023-10-06', 11, '2024-09-05', 6, 1, 'Neeraj Kumar Jha', 'R N Jha', 'Sector 1, Bokaro', '827001', '1992-10-07', '9330096607', 'reachneerajjha@gmail.com', '352370389844', 'Bbqpj9247n', 0x[encoded data, 12918 characters], 0x[encoded data, 14126 characters], 0x[encoded data, 17262 characters], 0x[encoded data, 15782 characters], 'Service', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-06 19:31:22', '2023-10-06 19:43:23');
