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
(227, '#OPNAG-OW-00000211', '$2y$10$0Ac7SnCCpzSE665kPtkhk.oA12VQf.y6XgdPlH36ylE/6PzPlSy5W', '152.58.180.173', 'SUJATA HAZRA', 'ASIT BARAN HAZRA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'HAROPUR, PURBA MEDINIPUR, ALANKAARPUR, WEST BENGAL, 721441', NULL, '', '700135', NULL, NULL, '7003261687', 'dhananjoymondal7003@gmail.com', '1991-06-22', '937720505095', NULL, 0x[encoded data, 15406 characters], 0x[encoded data, 18782 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E/460/101', 'S. P sukhobristi', 'E/460/101', 'S. P sukhobristi', '700135', 'f', '1', '320', 'No', '1', 'f', 13500, 'Thirteen Thousand Five Hundred ', 27000, 'Twenty Seven Thousand ', 0.00, 10, '2023-10-10', 1, '2023-11-09', 6, 1, 'SUPRABHAT SHAW', 'FAKIR CHANDRA SHAW', 'kherejora,Gidhni,Paschim Medinipur,West Bengal 721505', '721505', '1995-10-27', '7003393653', 'Suprabhatshaw66@gmail.com', '733621862946', 'FWLPS3242A', 0x[encoded data, 17694 characters], 0x[encoded data, 17694 characters], 0x[encoded data, 17102 characters], 0x[encoded data, 18622 characters], 'Na', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-10 04:35:46', '2023-10-10 05:30:53');
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
(228, '#OPNAG-OW-00000212', '$2y$10$ORguPFAVnuM64YSDlrS92eJ8dpF.HV/rAvk4MHuuP905vHb9s.uSW', '152.58.177.124', 'SUJATA HAZRA', 'ASIT BARAN HAZRA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'HAROPUR, PURBA MEDINIPUR, ALANKAARPUR, WEST BENGAL, 721441', NULL, '', '700135', NULL, NULL, '7003261687', 'dhananjoymondal7003@gmail.com', '1991-06-20', '937720505095', NULL, 0x[encoded data, 13678 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E/460/101', 'S. P sukhobristi', 'E/460/101', 'S. P sukhobristi', '700135', 'f', '1', '320', 'No', '1', 'f', 13500, 'Thirteen Thousand Five Hundred ', 27000, 'Twenty Seven Thousand ', 0.00, 11, '2023-10-10', 11, '2024-09-09', 6, 6, 'SUPRABHAT SHAW', 'FAKIR CHANDRA SHAW', 'Kherejora,Gidhni,Paschim Medinipur,West Bengal 721505', '721505', '1995-10-27', '7003393653', 'Suprabhatshaw66@gmail.com', '733621862946', 'FWLPS3242A', 0x[encoded data, 17694 characters], 0x[encoded data, 17694 characters], 0x[encoded data, 17102 characters], 0x[encoded data, 18622 characters], 'Na', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-10 05:51:07', '2023-10-10 06:04: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
(229, '#OPNAG-OW-00000213', '$2y$10$E6QM9oCacv2cKfrGA35zdupJxFp.gXJvXkJP5VKOHIbxLpRpeqB..', '42.110.174.80', 'RAJEEV GOENKA ', 'SANJEEV GOENKA ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'CLUBTOWN ENCLAVE-02/3L, 20  CHINAR PARK, KOLKATA-700157', NULL, 'mslgarments@gmail.com', '700157', NULL, NULL, '9830066299', 'rajeevkgoenka@gmail.com', '1968-05-30', '602133765251', NULL, 0x[encoded data, 20566 characters], 0x[encoded data, 19622 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J-17', 'SPARSH SP SUKHOBRISTI HOUSING', '604', 'AA-III, NEWTOWN ', '700135', 'f', '2', '480', 'Na', '6', 'f', 15000, 'Fifteen Thousand ', 30000, 'Thirty Thousand ', 0.00, 10, '2023-10-10', 11, '2024-09-09', 6, 1, 'Subham Poddar', 'Dulal Poddar', 'Hno 219, Tank Road, Po Mango, Mango, Jamshedpur', '831012', '1995-09-29', '7909048907', 'subhampoddar13@gmail.com', '970687338942', 'CLXPp8392L', 0x[encoded data, 18438 characters], 0x[encoded data, 18582 characters], 0x[encoded data, 11702 characters], 0x[encoded data, 18790 characters], 'Bank Employee', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Leave and license agreement.\r\nFurnished flat.\r\nLicensee will use the flat only for residencial purpose for 11 months. Licensee will not sublet or allow paying guest without prior permission of the flat owner.  Licensee will not make any illegal construction inside or outside the flat. Licensee will follow the rules and regulation of the housing cooperative society. Licensee will be responsible for all petty repairs of the flat. Each party will give 1 month prior notice to each other to vacate the flat.', '2023-10-10 18:20:33', '2023-10-10 18:41:43');
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
(230, '#OPNAG-OW-00000214', '$2y$10$vE.8hcsmRo7Gtcm0OlZMXeODL63yLJbYkd/5moLw7hNxRBinDu9Lu', '157.40.89.129', 'MAUSUMI MUKHERJEE ', 'BIMALENDU ACHARYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'C/7 Anandalok Housing Estate V.I.P road kakur gachi S.O kakurgachi,Kolkata West Bengal -700054', NULL, 'mousumi_m@hotmail.com', '700054', NULL, NULL, '9051513229', 'mousumibrishti@gmail.com', '1962-11-05', '260690014041', NULL, 0x[encoded data, 16814 characters], 0x[encoded data, 14174 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', 'J18', 'J18/202', 'J18/202 s.p sukhobrishti new town Kolkata 700135', '700135', 'f', '2', '650', 'NA', '2', 'f', 12000, 'Twelve Thousand ', 13000, 'Thirteen Thousand ', 23718.00, 10, '2023-10-11', 11, '2024-09-10', 6, 1, 'UJJAL BANERJEE', 'Utpal Banerjee', 'Palla,Memari -1, Barddhaman, West Bengal 713151', '713151', '1997-07-20', '7797561401', 'ujjalbanerjee3@gmail.com', '778415319082', 'CHXPB6824M', 0x[encoded data, 16654 characters], 0x[encoded data, 17766 characters], 0x[encoded data, 19518 characters], 0x[encoded data, 16454 characters], '1622269', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-11 18:36:03', '2023-10-11 18:52:58');
