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
(62, '#OPNAG-OW-00000054', '$2y$10$UGf9TNHsD6vEH9lA4ji5OuMmnhOGhtDjvU2ua.0eDPabCmu0tzU6a', '223.191.48.143', 'Sonali Mukherjee ', 'Sarajit Mukherjee ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', ' W/O: Sarajit Mukherjee,  BE-397, SALTLAKE SEC-1. Bidhannagar(M), Bidhannagar CC  Block North 24 Parganas, West Bengal, 700064', NULL, '', '700064', NULL, NULL, '9831436229', 'bydut01@gmail.com', '1961-11-19', '792960877044', 'AJOPM9095N', 0x[encoded data, 6750 characters], 0x[encoded data, 11798 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', 'J-17', 'J-17/1404', 'J-17/1404 SP Shukhobrishti Housing Complex Newtown Kolkata 700135', NULL, 'f', '2', '480', 'No', '14', 'f', 10500, 'Ten Thousand Five Hundred ', 21000, 'Twenty One Thousand ', 0.00, 10, '2023-08-01', 11, '2024-06-30', 6, 1, 'Pragya  Nautiyal', 'Prakash Chandra Nautiyal', 'D/O: Prakash Chandra Nautiyal, Village- Dagoli, Post- Tikochi, Dagoli, Uttarkashi, Uttarakhand - 249185', '249185', '2003-02-11', '9084597977', 'pragyanautiyal53@gmail.com', '722214915831', 'CPnpn6784c', 0x[encoded data, 7654 characters], 0x[encoded data, 7198 characters], 0x[encoded data, 15110 characters], 0x[encoded data, 12622 characters], '20406237', 's', 'Teacher', 'Dagoli, p.o tikochi,uttarkashi,Uttarakhand ', '725480028991', 'AIMPN1633L', '45140313M08583', 'pragyanautiyal89@gmail.com', '9258903142', NULL, NULL, '2023-06-19 17:20:15', '2023-06-19 17:34:03');
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
(63, '#OPNAG-OW-00000055', '$2y$10$khtlfnGSsVvMePxcJy.Ws.zUvVk1XIAto16EdO0It9Kl0e12qnbGe', '157.40.173.47', 'Sukrity Kumar', 'Mondal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'S/O: Dhirendra Nath Mondal, ELITA GARDEN VISTA, TOWER-16,1402, OPPOSITE-SHAPOORJI SUKHOBRISTI, AA- 3E, Rajarhat, North 24 Parganas, West Bengal - 700135', NULL, '', '700135', NULL, NULL, '9073379551', 'sukrity@gmail.com', '1976-12-29', '752844840655', 'APHPM6381A', '', '', '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'C', 'C240', 'C240/203', 'C240/203 SP Shukhubrishti housing complex new town Kolkata 700135', NULL, 'f', '1', '320', 'No', '2', 'f', 11000, 'Eleven Thousand ', 22000, 'Twenty Two Thousand ', 0.00, 10, '2023-06-20', 11, '2024-05-19', 6, 1, 'Sonam Tashi ', 'Passang dolma ', 'S/O NAMDUL HOUSE NO. 40, TR\r\n§ CAMP NO.5 Tindolong Lohit Arunachal\r\n• Pradesh - 792001', '792001', '2001-02-25', '9366185410', 'sonamtashicr@gmail.com', '980789704918', 'BZZPT5544H', '', '', '', '', 'IIHM21KOL377', 's', 'Nurse ', 'S/O NAMDUL HOUSE NO. 40, TR § CAMP NO.5 Tindolong Lohit Arunachal • Pradesh - 792001', '962038012970', 'FXDPD1220A', 'No', 'passangdolma96@gmail.com', '7076177656', NULL, NULL, '2023-06-20 11:42:14', '2023-06-20 12:03:03');
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
(64, '#OPNAG-OW-00000056', '$2y$10$P8TaTpgFac136QpWwk/8Qum3Z13s.wWb2QaTWD.TnVj/awbZFR15C', '103.59.73.61', 'ANURAG SINHA ', 'RANJIT SINHA ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '30 Jagadish Chandra Bose Road Ghola Panihati Sodpur North 24 Parganas West Bengal 700110', NULL, '', '700110', NULL, NULL, '8670413618', 'imranhassi.0022@gmail.com', '1988-01-23', '881680717174', 'BNTPS0157H', 0x[encoded data, 14702 characters], 0x[encoded data, 13702 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/92', 'A/92/304', 'A/92/304 sp shukhobrishti new town action area 3 Kolkata West Bengal 700135', NULL, 'f', '1', '320', 'NO', '3', 'f', 8500, 'Eight Thousand Five Hundred ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-07-01', 1, '2024-05-31', 6, 1, '320', '320', '320', '713211', '2004-11-22', '7908795851', 'nishaalidgp@gmail.com', '369847457738', 'BJXPA1851L', 0x[encoded data, 16238 characters], 0x[encoded data, 11686 characters], 0x[encoded data, 19190 characters], 0x[encoded data, 15190 characters], 'Service ', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-20 12:41:35', '2023-06-20 13:03:22');
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
(65, '#OPNAG-OW-00000057', '$2y$10$5ox/B8rQPgX15Vy6wWlw7eqrmsX3mP3LFaRfa8pVJ1WiGrMhJCdRS', '152.58.176.63', 'SHANSHAH AZAM', 'BASHIRU AZAM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '1/B Hari Bagan road, Intally, Kolkata , West Bengal - 700014', NULL, '', '700135', NULL, NULL, '7686048670', 'Mondalpurnendu883@gmail.com', '2023-06-20', '789830814914', 'BPCPA1798H', '', '', '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'B', 'B 147', 'B 147/302', 'B 147/ 302  sp sukhobrishti, housing complex, shapoorji Newtown, Kolkata -700135', NULL, 'f', '1', '325', 'Yes', '3', 'f', 13000, 'Thirteen Thousand ', 26000, 'Twenty Six Thousand ', 0.00, 11, '2023-06-19', 11, '2024-05-18', 2, 2, 'DINESH KUMAR SHARMA', 'Asha sharma', 'House no 2, Road no 6/A, near shiv mandir, Ramnagar, Sonari, Jamshedpur - 831011', '831011', '1996-10-06', '7717784795', 'Kashu000048@gmail.com', '521546125749', 'FZVPS2312L', 0x[encoded data, 30118 characters], 0x[encoded data, 29998 characters], 0x[encoded data, 29206 characters], 0x[encoded data, 27206 characters], 'Cognizant Id', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-20 12:55:39', '2023-06-20 13:05: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
(66, '#OPNAG-OW-00000058', '$2y$10$OfAWlSPTOpwnqOCVxK4Q7uxfH20FWddSOWiKqjV66L.IGmkKzW4IG', '103.59.73.61', 'ANURAG SINHA ', 'RANJIT SINHA ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '30 Jagadish Chandra Bose Road Ghola Panihati Sodpur North 24 Parganas West Bengal 700110', NULL, 'imranhassi.0022@gmail.com', '700110', NULL, NULL, '8670413618', 'imranhassi.0022@gmail.com', '1988-01-23', '881680717174', 'BNTPS0157H', 0x[encoded data, 13822 characters], 0x[encoded data, 13894 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/92', 'A/92/304', 'A/92/304 sp shukhobrishti new town action area 3 Kolkata West Bengal - 700135', NULL, 'f', '1', '320', 'NO', '3', 'f', 8500, 'Eight Thousand Five Hundred ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'SHREEN RAFA', 'MD NAWAB', 'P-145 Sagar Bhanga Colony Durgapur Paschim Bardhaman West Bengal 713211', '713211', '2004-11-22', '7908795851', 'sada9873@gmail.com', '369847457738', 'BJXPA1851L', 0x[encoded data, 13462 characters], 0x[encoded data, 12270 characters], 0x[encoded data, 24614 characters], 0x[encoded data, 13006 characters], 'Service ', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-20 14:01:45', '2023-06-20 14:23:49');
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
(67, '#OPNAG-OW-00000059', '$2y$10$Z9XF8./2ANqRxfGmLKT7eOaohT4hYzspKNKbEaWWimibKSpb8FQP6', '110.224.102.206', 'Nayab Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'ARENA HOUSING COMPLEX, Action Area III , Newtown 700135', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '2023-06-20', '355087659876', 'BZBPA0379R', '', 0x[encoded data, 9606 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D 111', 'D 111/103', 'D 111/103 SP Shukhobrishti husing complex new town action area III kolkata 700135', NULL, 'f', '1', '325', 'No', '2', 'f', 2000, 'Two Thousand ', 4000, 'Four Thousand ', 0.00, 6, '2023-06-20', 11, '2024-05-19', 6, 4, 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-20 15:20:03', '2023-06-20 15:34:11');
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
(68, '#OPNAG-OW-00000060', '$2y$10$jEQQQ1.m/iGUyNP8ebur3uVqmK0JcoitlR3UlbdwckHS5S6MJ7kHi', '103.59.72.78', 'MOUPRIYA DUTTA', 'TAPAS KUMAR DUTTA ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Flat no 3a 3rd Floor, Baihi Apartment, 17/13, Jelia Para, Opposite Khardah Municipality, Khardah North 24 Parganas West Bengal 700117', NULL, '', '700117', NULL, NULL, '9830805812', 'imranhassi.0022@gmail.com', '1988-01-29', '616866022076', 'AWGPD4619Q', 0x[encoded data, 20926 characters], 0x[encoded data, 24878 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D/342', 'D/342/401', 'D/342/401 sp shukhobrishti new town action area 3 Kolkata West Bengal 700135', NULL, 'f', '1', '320', 'NO', '4', 'f', 8200, 'Eight Thousand Two Hundred ', 15000, 'Fifteen Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'RAJIB SHARMA ', 'PUSPA BHATTACHARYA SHARMA ', 'Ward 28 Sree Palli Badharghat Near Nabajagaran Sangha Club Agartala Arundhatinagar West Tripura 799003', '799003', '1983-03-05', '9771481868', 'rajib.agt@gmail.com', '990689930733', 'CPRPS9634C', 0x[encoded data, 23654 characters], 0x[encoded data, 35102 characters], 0x[encoded data, 15318 characters], 0x[encoded data, 11853 characters]