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
(86, '#OPNAG-OW-00000078', '$2y$10$ygENifsaVU1brU9kBfzDE.IVMivuDmI13NAtZpBsdVhhxA8Z94v..', '42.110.173.5', 'Govind Singh Bisht', 'Lt. Madan Singh Bisht', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Balaka Abasan Block A/6 Flat 2/2 anewtown Rajarhat Newtown S. O North 24 PGS WB 700156', NULL, '', '700156', NULL, NULL, '9804558955', 'bishtgovind1965@gmail.com', '1965-12-25', '558218378177', NULL, 0x[encoded data, 16742 characters], 0x[encoded data, 17278 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E404', 'E404/202', 'E440/202 SP Sukhobrishti Newtown action area 3  kol 700135', NULL, 'f', '1', '320', 'S6', '2', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'Sandipan Deb', 'Samir Chandra Deb', 'AD nagar RD no. 06 near Vidyasagar school AD nagar Agartala Charipara A. D nagar West Tripura 799003', '799003', '1991-07-24', '9674882034', 'sandipand25@gmail.com', '250552173922', 'CNAPD9002L', 0x[encoded data, 22838 characters], 0x[encoded data, 23446 characters], 0x[encoded data, 23350 characters], 0x[encoded data, 18614 characters], 'service', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-01 17:47:12', '2023-07-01 17:56: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
(87, '#OPNAG-OW-00000079', '$2y$10$goeiNG1LM.2yDjr5kC4dv.5xMa5J6PSqMyjAD2.vIuwBp.YaFS8Uy', '42.110.172.217', 'Govind Singh Bisht', 'Lt. Madan Singh Bisht', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Balaka Abasan Block A/6 Flat 2/2 newtown Rajarhat Newtown S. O North 24 PGS WB 700156', NULL, '', '700156', NULL, NULL, '9804558955', 'bishtgovind1965@gmail.com', '1965-12-25', '558218378177', NULL, 0x[encoded data, 14862 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E 404', 'E404/202', 'E404/202 SP Sukhobrishti Newtown action area 3 Kol 700135', NULL, 'f', '1', '320', 'S6', '2', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'Sandipan Deb', 'Samir Chandra Deb', 'A.D nagar RD. No. 6 near Vidyasagar School A.D nagar, Agartala Charipara A. D nagar West Tripura 799003', '799003', '1991-07-24', '9674882034', 'sandipand25@gmail.com', '250552173922', 'CNAPD9002L', 0x[encoded data, 24342 characters], 0x[encoded data, 23982 characters], 0x[encoded data, 23526 characters], 0x[encoded data, 20798 characters], 'service', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-01 19:29:12', '2023-07-01 19:36:37');
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
(88, '#OPNAG-OW-00000080', '$2y$10$juIliEoAHlnCzuCgP6ewj.R.is./o2.D7PiNs92yGfwoqOPPIfM9m', '103.59.73.119', 'INDRANIL MUKHOPADHYAY ', 'ARUN KUMAR MUKHOPADHYAY ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'G-13/4, Karunamoyee Housing Estate, Sector 2, Sech Bhawan North 24 Parganas West Bengal 700091', NULL, 'imranhassi.0022@gmail.com', '700091', NULL, NULL, '9748736955', 'indranil36@gmail.com', '1971-01-09', '981818243427', NULL, 0x[encoded data, 16862 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', 'J/20', 'J/20/602', 'J/20/602 Sp Shukhobrishti new town action area 3 Kolkata West Bengal 700135', NULL, 'f', '2', '735', 'NO', '6', 'f', 16000, 'Sixteen Thousand ', 32000, 'Thirty Two Thousand ', 0.00, 10, '2023-07-03', 11, '2024-06-02', 6, 1, 'SAURAV SINGH ', 'SHASHI KAPOOR SINGH', 'Opposite Radha Swami Satsang Ghar, Madnadih Loyabad, Bansjora, Dhanbad Jharkhand - 828101', '828101', '1995-07-18', '7003320106', 'sauravsingh2800@gmail.com', '647263295533', 'FFZPS1947M', 0x[encoded data, 15702 characters], 0x[encoded data, 13382 characters], 0x[encoded data, 17038 characters], 0x[encoded data, 13526 characters], '700197', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-03 11:20:42', '2023-07-03 11:44:20');
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
(89, '#OPNAG-OW-00000081', '$2y$10$4b6D0B4W/YpYoJfeBwwHL.fBeoiWFAEN.OYIKiFrszouEI.lv9Jxa', '157.40.175.33', 'Bharati Das', 'Nidhubhushan Das', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '3 SATYAJIT ROY SARANI, EAST VIVEKANANDA PALLY WARD NO 15, Siliguri (M. Corp), Darjeeling, Rabindra Sarani, West Bengal, 734006', NULL, '', '734006', NULL, NULL, '9733268638', 'parthaslg.2010@gmail.com', '1958-01-01', '651828402752', NULL, 0x[encoded data, 14374 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D 342', 'D 342 / 404', 'D 342 / 404, SP Sukhobrishti Housing Complex, Action area 3, Newton, Kolkata, 700135.', NULL, 'f', '1', '320', 'NA', '4', 'f', 8000, 'Eight Thousand ', 16000, 'Sixteen Thousand ', 7000.00, 10, '2023-07-04', 11, '2024-06-03', 6, 1, 'Mylapalli Suvarna Bharathi ', 'Mylapalli Prasad', 'Mylapalli Suvarna Bharathi \r\nD/O Mylapalli Prasad\r\nH No 3-5\r\nSC Colony\r\nPeddamalapalli\r\nMunagapaka Mandalam\r\nNagulapalle\r\nVisakhapatnam Andhra Pradesh - 531001', '531001', '2001-05-26', '7013990442', 'suvarnabharathi.2001@gmail.com', '222148807886', 'DZTPM3912A', 0x[encoded data, 19934 characters], 0x[encoded data, 20910 characters], 0x[encoded data, 14718 characters], 0x[encoded data, 18110 characters], '91771', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-04 16:47:13', '2023-07-04 17:09:30');
