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
(98, '#OPNAG-OW-00000088', '$2y$10$9Nnm6PH8I6o7j9ecfwzhBuK1OS0.KghvUpCEcCK6o2aNWeLIS4Kny', '103.59.73.23', 'SUTAPA BHATTACHARYA ', 'SUBRATA BHATTACHARYA ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '4/72 Bijoygarh, Jadavpur University Kolkata West Bengal -700032', NULL, '', '700032', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1968-05-10', '999315482464', NULL, 0x[encoded data, 15246 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'C', 'C221', 'C221/201', 'C/221/201 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', NULL, 'f', '1', '320', 'NO', '1', 'f', 13500, 'Thirteen Thousand Five Hundred ', 27000, 'Twenty Seven Thousand ', 0.00, 10, '2023-07-07', 11, '2024-06-06', 6, 0, 'DEBADRI BASU', 'SUSHANTA BASU', 'Saktigarh, Narattam Palli, Bongaon, North 24 Parganas West Bengal 743235', '743235', '1996-10-17', '7003262072', 'debadri.work.96@gmail.com', '690472513967', 'CKDPB2257H', 0x[encoded data, 17958 characters], 0x[encoded data, 19894 characters], 0x[encoded data, 14806 characters], 0x[encoded data, 16518 characters], '1241238', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-07 12:24:23', '2023-07-07 13:03:41');
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
(99, '#OPNAG-OW-00000089', '$2y$10$mmn.kF0AKPFHhMrECwHpY.DsXuAfeCv8NP3Q/BAST.HmRwUQ4T726', '110.224.111.227', 'Shamim Ahmed', 'Mokaddes Ahmed', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'LX 40302 , UTSA THE CONDOVILLE , BLOCK - AG /1/D , NEW TOWN , New Town S.O , NORTH TWENTY FOUR PARGHANAS, WEST BENGAL - 700156', NULL, '', '700156', NULL, NULL, '7003614052', 'shamschon123@gmail.com', '1978-08-14', '413079347330', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K ', 'K43', 'K43/703', 'K43/703 SP SHUKHOBRISHTI NEW TOWN ACTION AREA 3 , KOLKATA - 700135', NULL, 'f', '2', '480', 'NO ', '2', 'f', 18500, 'Eighteen Thousand Five Hundred ', 37000, 'Thirty Seven Thousand ', 22000.00, 10, '2023-07-10', 11, '2024-06-09', 6, 0, 'Vartica Gondhedekar', 'Manmohan Das', 'inda PIRBABA KHARAGPUR, Inda, Paschim Medinipur West Bengal - 721305', '721305', '2000-09-14', '9775851624', 'vartica2000@gmail.com', '370437847419', 'CVNPG0485M', 0x[encoded data, 26038 characters], 0x[encoded data, 28246 characters], 0x[encoded data, 22390 characters], 0x[encoded data, 32462 characters], '13687171', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 20:26:56', '2023-07-10 20:46:41');
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
(100, '#OPNAG-OW-00000090', '$2y$10$4S7aTnqYqR5l5mN7Nv8YRO9syN1dKcUuhPyBBSX8W7anmlvRqktMK', '152.58.183.220', 'Gita sen', 'Bratis Sen', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Gitanjali apartment 2 ramdhan Mukherjee lane, kamarhati, belgharia ', NULL, '', '700056', NULL, NULL, '9339806056', 'prayasisen28@gmail.com', '1950-02-01', '291684774469', NULL, 0x[encoded data, 12830 characters], 0x[encoded data, 10470 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A77', 'A77/302', 'A77/302 SP SHUKOBRISTI, NEWTOWN, ACTION AREA 3, KOLKATA, 700135', NULL, 'f', '1', '320', 'No', '3', 'f', 8500, 'Eight Thousand Five Hundred ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-07-09', 11, '2024-06-08', 6, 1, 'Vishal Joshi', 'Vishnu Joshi', 'Near shyam mandir, choudhary tola, ward no 12, kahalgaon,Bihar ', '813203', '2001-01-02', '6299631959', 'vishaljoshi.bs@gmail.com', '470880695943', 'BTYPJ4035J', 0x[encoded data, 14014 characters], 0x[encoded data, 15550 characters], 0x[encoded data, 13926 characters], 0x[encoded data, 20222 characters], 'Service', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-11 17:47:22', '2023-07-11 18: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
(101, '#OPNAG-OW-00000091', '$2y$10$QNuMuPYdqSBTS1QC.9Oiz.AuDD9mLrRWoHwHso5ZbTkZ2vgGtXFMG', '103.59.73.29', 'ALIK CHATTERJEE ', 'UMAPADA CHATTERJEE ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'D/26 Natunpally, Benachiti, Durgapur Benachity, Barddhaman West Bengal 713213', NULL, '', '713213', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1964-09-21', '506408235456', NULL, 0x[encoded data, 19982 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E/435', 'E/435/103', 'E/435/103 SP SHUKHOBRISHTI NEW TOWN ACTION AREA 3 KOLKATA WEST BENGAL 700135', NULL, 'f', '1', '320', 'NO', '1', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-07-12', 11, '2024-06-11', 6, 1, 'SOMYA MISHRA ', 'LAXMI KANT MISHRA ', 'Thana Baghmara Rathtand Baghmara Bazar Dhanbad Jharkhand - 828306', '828306', '2000-03-13', '8340332826', 'dikshamishra4444@gmail.com', '239817133410', 'FCXPM2439D', 0x[encoded data, 16510 characters], 0x[encoded data, 14366 characters], 0x[encoded data, 16126 characters], 0x[encoded data, 18630 characters], '46847', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-12 11:04:55', '2023-07-12 11:26:42');
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
(102, '#OPNAG-OW-00000092', '$2y$10$Kt0Ir1cD8fI5XQJS6I1gU./uhz716O3F.kiVPoFc8.bjrdgc/8ABi', '103.59.73.29', 'MANJU SHARMA ', 'KAWSAL KISHORE SINGH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Jayanl Niwash, Alka Colony Sandadalpur, Sampaetchak, Patna Bihar 800006', NULL, 'imranhassi.0022@gmail.com', '800006', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1960-08-15', '245865964938', NULL, 0x[encoded data, 12934 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'C', 'C/665', 'C/665/204', 'C/665/204 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700137', NULL, 'f', '1', '320', 'NO', '2', 'f', 13000, 'Thirteen Thousand ', 26000, 'Twenty Six Thousand ', 0.00, 10, '2023-07-12', 11, '2024-06-11', 6, 0, 'KOMAL BARNWAL ', 'VIJAY KUMAR BARNWAL ', '742,S B Gorai Road, Near Sudha Oil Mill, Asansol, Barddhaman, Asansol West Bengal 713301', '713301', '1993-12-31', '9851316397', 'imranhassi.0022@gmail.com', '882017050182', 'BKMPB2340F', 0x[encoded data, 13742 characters], 0x[encoded data, 14278 characters], 0x[encoded data, 21382 characters], 0x[encoded data, 11478 characters], '576804', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-12 12:24:15', '2023-07-12 12:34:02');
