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
(57, '#OPNAG-OW-00000049', '$2y$10$leUkKhp4nlnkhEtsymC2ieh/BWiqatHlwvuQvBevSUW7hvxkyPP.2', '152.58.138.45', 'CHANDAN KUMAR DASBAYEN', 'SAKTIPADA DASBAYEN ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'PARBATIPUR, WARD NO-13 NEAR HAMILTON HIGH SCHOOL, TAMLUK,  PURBA MEDINIPUR WEST BENGAL 721636', NULL, 'imranhassi.0022@gmail.com', '721636', NULL, NULL, '7431830345', 'ckdasbayen53@gmail.com', '1953-01-15', '602940929197', 'ACWPD6422H', 0x[encoded data, 16582 characters], 0x[encoded data, 16662 characters], 0x[encoded data, 13414 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'L', 'L/68', 'L/68/1203', 'L/68/1203 SP SHUKHOBRISHTI NEW TOWN ACTION AREA 3 KOLKATA WEST BENGAL 700135', NULL, 'f', '3', '901', 'NO', '12', 'f', 16000, 'Sixteen Thousand ', 32000, 'Thirty Two Thousand ', 0.00, 10, '2023-06-16', 6, '2023-12-15', 11, 1, 'ABHISHEK ARYA', 'SURENDRA KUMAR SHARMA ', 'POST, KESHWARI THANA, SURIYA, VILL, KESHWARI, GIRIDIH, JHARKHAND - 825320', '825320', '1993-12-04', '9692248576', 'abhiaryaa00@gmail.com', '868001564817', 'BIQPA6497N', 0x[encoded data, 17814 characters], 0x[encoded data, 15878 characters], 0x[encoded data, 12078 characters], 0x[encoded data, 23662 characters], '689863', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-16 11:47:25', '2023-06-16 12:10:33');
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
(58, '#OPNAG-OW-00000050', '$2y$10$p7OSl4Nog8Tcm6UyFXUzvu36QXSo6XOYnmdsvHs4Y.GLu3VeHVeBG', '117.99.91.129', 'Saket Shekhar', 'Radha Nath Nankuliyar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Near Shiv Temple, New Area Beldari Tola, Gaya, Bihar, 823001', NULL, '', '823001', NULL, NULL, '9004093383', 'shekhar.saket@gmail.com', '1985-06-10', '843956397919', 'BZSPS9976H', 0x[encoded data, 14398 characters], 0x[encoded data, 11974 characters], 0x[encoded data, 25846 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'B 147', 'Shapoorji Sukhobristi', '103', 'Shapoorji Sukhobristi\r\nB147/103 \r\nNew Town, Kolkata, 700135', NULL, 'f', '1', '400', 'NA', '1', 'f', 14000, 'Fourteen Thousand ', 28000, 'Twenty Eight Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 2, 1, 'Debjit Das', 'Dinabandhu Das', 'Tribeni, Baikunthapur, Near Senpukur, Opp. of Water Tank, P.S. - Mogra, Dist. Hooghly, 712503', '712503', '1982-08-13', '9804904433', 'debjit13@gmail.com', '539876306737', 'ASUPD7461N', 0x[encoded data, 17326 characters], 0x[encoded data, 21854 characters], 0x[encoded data, 12542 characters], 0x[encoded data, 20670 characters], '2383066', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-16 14:15:35', '2023-06-16 14:54:16');
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
(59, '#OPNAG-OW-00000051', '$2y$10$EZCNmixWWHoOScXb0OewcOXPVSkaPvtGAu2IZ21gLXgtl0A.IkQxq', '110.224.110.189', 'Sonali Mukherjee', 'Sarajit Mukherjee ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'BE 397 Salt Lake', NULL, '', '700064', NULL, NULL, '9831436229', 'smsonagold@gmail.com', '1961-11-19', '792960877044', 'AJOPM9095N', 0x[encoded data, 11870 characters], 0x[encoded data, 11550 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', '17', '1404', 'J17 1404 SP Shukhobrishti Shapoorji Newton 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, 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-17 12:55:53', '2023-06-17 13:02:38');
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
(60, '#OPNAG-OW-00000052', '$2y$10$2w/Q2nqRTDGWm55FJEE8rOSHGsh9hHeF/to755B1NILxy31bLPNQG', '117.217.61.202', 'Pankaj Kanti Mani', 'Kshitish Chandra Mani', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Block D, 12/10, Uttorayan Township, Citycenter Mall, PO-Matigara, Darjeeling, WB, 734010', NULL, '', '734010', NULL, NULL, '9775777777', 'Pankajkantimani@gmail.com', '1951-04-07', '293335558783', 'ADRPM5386P', 0x[encoded data, 25462 characters], 0x[encoded data, 25462 characters], 0x[encoded data, 12742 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E440', '103', 'Flat-103/E440\r\nSapoorji Sukhobrishti, New Town\r\nPS - Technocity\r\nNorth 24 Pragana\r\nKolkata, West Bengal, 700135', NULL, 'f', '1', '425', 'E440/S1', '1', 'f', 8000, 'Eight Thousand ', 16000, 'Sixteen Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'Manoj Kumar Mukharjee ', 'Ashok Kumar Mukharjee ', 'Brahmankhanda, Sirlo Nabagram, Cuttack, 754132', '754132', '1989-07-03', '8981653338', 'mukharjee.manoj4@gmail.com', '536942749435', 'BRIPM8413P', '', 0x[encoded data, 14814 characters], 0x[encoded data, 9086 characters], 0x[encoded data, 9006 characters], 'Service ID', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-19 12:23:16', '2023-06-19 12:42:34');
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
(61, '#OPNAG-OW-00000053', '$2y$10$vEzXU4BR0306x6JAGiBwxO98AU8xbLrr8I6H6X0mC57y0TgJyz6ae', '157.40.207.46', 'Barnali manek', 'J.c pal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Address: W/O: Viani Manek, C.F-332/7, SALTLAKE SECTOR-1, Bidhannagar (M), Bidhannagar CC Block, North 24 Parganas, West Bengal, 700064', NULL, '', '700064', NULL, NULL, '9330914450', 'bydut01@gmail.com', '1964-08-28', '354654100809', 'AEKPM9380B', 0x[encoded data, 11814 characters], 0x[encoded data, 9966 characters], 0x[encoded data, 18702 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', 'J-17', 'J-17/1402', 'J-17/1402 Sp Shukhobrishti housing complex newtown action area III kolkata 700135', NULL, 'f', '2', '480', 'No', '14', 'f', 10000, 'Ten Thousand ', 20000, 'Twenty Thousand ', 0.00, 10, '2023-06-19', 11, '2024-05-18', 6, 1, 'Soniya', 'Bhola', 'H no 460A,gali no 9  sahid bhagat singh colony,karawal nagar delhi 94', '110094', '2000-06-23', '9354629399', 'soniyakumari21072000@gmail.com', '847740459639', 'Lcups0771s', 0x[encoded data, 11230 characters], 0x[encoded data, 8150 characters], 0x[encoded data, 14718 characters], 0x[encoded data, 18894 characters], '2252789322', 's', 'Sevice', 'H no 460A,galino 9, sahid bhaga', '930091679692', 'Aqopc7204q', 'Na', 'Soniyakumari21072000@gmail.com', '9654618504', NULL, NULL, '2023-06-19 16:35:46', '2023-06-19 16:53:22');
