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
(170, '#OPNAG-OW-00000158', '$2y$10$Ej0NyugTtkChGKaqKiTuRe6g6.00jL./EZ0o3ubt.05GK7x1rM4TS', '103.59.73.39', 'SAMBIT SEN', 'Subir Kumar Sen', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'P -592 Purna Das Road, Sarat Bose Road Circus Avenue Kolkata West Bengal 700029', NULL, '', '700029', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1986-10-17', '596754794908', NULL, 0x[encoded data, 12518 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K/31', 'K/31/603', 'K/31/603 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', NULL, 'f', '3', '901', 'NO', '6', 'f', 17000, 'Seventeen Thousand ', 34000, 'Thirty Four Thousand ', 0.00, 10, '2023-09-01', 11, '2024-07-31', 7, 1, 'AVANISH ANAND', 'Sanjay Jha,', 'Shivpuri Ward No -09 Araria, Bihar - 854311', '854311', '1998-12-17', '8240218343', 'sada9873@gmail.com', '997677185950', 'DYQPA5814R', 0x[encoded data, 26550 characters], 0x[encoded data, 20502 characters], 0x[encoded data, 16918 characters], 0x[encoded data, 9222 characters], '11619766', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-31 22:19:38', '2023-08-31 22:53:35');
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
(171, '#OPNAG-OW-00000159', '$2y$10$x95GIxM9ImpzyJSeMKiLmeegBKQwIaMA.KO8QaqO2BYklLabD2Lqu', '103.59.73.111', 'Dipti Palit', 'Malin Kumar Roychowdhury ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '5/4/1A Rifle Range Road Ballygunge Kolkata West Bengal 700019', NULL, '', '700019', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1943-09-01', '803613425912', NULL, 0x[encoded data, 16614 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/22', 'A/22/203', 'A/22/203 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 7000135', NULL, 'f', '1', '320', 'NO', '2', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-09-01', 11, '2024-07-31', 7, 1, 'Disha Das', 'Jayanta Das', 'Bethuadahari Adarsha Colony Jugpur Colony Nakashipara Nadia West Bengal 741126', '741126', '2001-12-04', '9749191359', 'imranhassi.0022@gmail.com', '931987740887', 'IQDPD4055D', 0x[encoded data, 20302 characters], 0x[encoded data, 14934 characters], 0x[encoded data, 13350 characters], 0x[encoded data, 18142 characters], '2012228001070', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-01 18:10:11', '2023-09-01 18:30:28');
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
(172, '#OPNAG-OW-00000160', '$2y$10$xy.um.kq.wI.hcnDWADfzeKfivPRVE7fiYIbgVwNf3ZQo3r1tyJF6', '94.49.32.113', '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, 17350 characters], 0x[encoded data, 15022 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E/388', 'SPANDAN, 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', 8500, 'Eight Thousand Five Hundred ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-09-02', 11, '2024-08-01', 6, 1, 'ASHUTOSH KUMAR DUBEY', 'DEVENDRA KUMAR DUBEY', 'S/O D.K. DUBEY, RAJA BAGICHA, DEOGHAR, DEOGHAR, JHARKHAND - 814112', '814112', '1989-11-30', '8368325948', 'ashutoshkumar1104@gmail.com', '576118410886', 'cdepd3825p', 0x[encoded data, 16206 characters], 0x[encoded data, 15150 characters], 0x[encoded data, 15486 characters], 0x[encoded data, 27398 characters], 'Working in Elderfly Healthtech Pvt Ltd- Offer Letter ref: Ref: ELD/2023/0017,  Date 07 Aug 2023. Office Address: 3A-1, Martin Burn iSpace-1, Street 315, DH-6/35, Action area 1, New town, Kolkata, West Bengal-700156', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-01 19:36:32', '2023-09-01 20:23:32');
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
(173, '#OPNAG-OW-00000161', '$2y$10$SEszye/P7DvrLSf88IJiVu/KjANkKNh9FZ6PKpc663Uk8OsxfUzPK', '103.59.73.111', 'Sarfaraz Anwar Siddiquee', 'Shafi Anwar Siddiquee ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '11, Kabitirtha Sarani, National Cenima Hall, Khiddirpore, Kolkata, West Bengal - 700023', NULL, '', '700023', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1979-09-01', '774822192353', NULL, 0x[encoded data, 20102 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'B', 'B/162', 'B/162/304', 'B/162/304 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', NULL, 'f', '1', '320', 'NO', '3', 'f', 8600, 'Eight Thousand Six Hundred ', 16000, 'Sixteen Thousand ', 0.00, 10, '2023-09-01', 11, '2024-07-31', 7, 1, 'Ashwini Kumar Tiwari ', 'Ashok Tiwari ', 'Near By Police Chuki 1 Professor Colony, Anand Nagar Siwan Bihar - 841226', '841226', '1986-04-16', '7903139805', 'ashwini.siwan@gmail.com', '823271217651', 'AKMPT5550E', '', 0x[encoded data, 12478 characters], 0x[encoded data, 10622 characters], 0x[encoded data, 15902 characters], '512794', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-01 21:59:33', '2023-09-01 22:23:50');
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
(174, '#OPNAG-OW-00000162', '$2y$10$YkHEQeyID29C3lBrCzrcxuErfT0E2WK5SKQjIPgyZ7.56C9zoMuUC', '103.59.73.213', 'Arnab Manna', 'Ajoy Manna ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '28D Rahim Ostagar Road, Lake Gardens, Lake Garden Circus Avenue Kolkata West Bengal - 700045', NULL, '', '700045', NULL, NULL, '9830203605', 'imranhassi.0022@gmail.com', '1989-08-08', '455368707035', NULL, 0x[encoded data, 13678 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/02', 'A/02/402', 'A/02/402 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal -700135', NULL, 'f', '1', '320', 'NO', '4', 'f', 8000, 'Eight Thousand ', 16000, 'Sixteen Thousand ', 0.00, 10, '2023-09-01', 11, '2024-07-31', 7, 1, 'Syed Abdul Mohsin ', 'Syed Abdul Majeed ', 'Gole Bajar, Kharagpur, West Midnapore, West Bengal -721301', '721301', '1988-11-01', '9046777780', 'sada9873@gmail.com', '869829420343', 'BBMPM9326B', 0x[encoded data, 9118 characters], 0x[encoded data, 8478 characters], 0x[encoded data, 9918 characters], 0x[encoded data, 9654 characters], '2602607', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-02 18:02:56', '2023-09-02 18:17:20');
