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
(196, '#OPNAG-OW-00000184', '$2y$10$WTHoGdQbBQa5dk/ioBAnS.TwmKvTcwIx/cudWzoco9.oFJ1X3wevi', '103.59.73.164', 'Mousumi Das', 'Chandra Sekhar Mallick ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '120/B Raja Dinendra Street, Shyambazar Mail, Kolkata West Bengal 700004', NULL, '', '700004', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1973-09-29', '245076725265', NULL, 0x[encoded data, 19582 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E/415', 'E/415/302', 'E/415/302 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '1', '320', 'NO', '3', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Mousumi Roy Chowdhury ', 'Shankar Roy Chowdhury ', 'Paikpara Lane, Surjyanagar C Group, Nasra, Ranaghat-1 Nasra Nadia West Bengal 741202', '741202', '1998-11-10', '8388988215', 'sada9873@gmail.com', '781916079550', 'CKBPR7063R', 0x[encoded data, 12334 characters], 0x[encoded data, 14150 characters], 0x[encoded data, 12438 characters], 0x[encoded data, 17230 characters], 'NA', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-29 18:41:58', '2023-09-29 18:55:26');
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
(197, '#OPNAG-OW-00000185', '$2y$10$9Xi7eXB7d0UZku1rC72ZQeW8Gepff8XfYwZweMqdsP1z6p7FHLKk6', '103.59.73.127', 'Mina Batabyal', 'Bimal Batabyal ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '102 Narkel Danga North Road Narkel Danga Kolkata West Bengal-700011', NULL, '', '700011', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1970-11-15', '849924695777', NULL, 0x[encoded data, 18574 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D/307', 'D/307/302', 'D/307/302 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '1', '320', 'NO', '3', 'f', 8000, 'Eight Thousand ', 13000, 'Thirteen Thousand ', 0.00, 10, '2023-09-16', 11, '2024-08-15', 7, 1, 'Mrityunjay Bhattacharya ', 'Avoya Kumar Bhattacharjee ', '81 Flat Premises, ED-66 Near Pani Tank, Lal Banglow, Damodar Colony, Kalmegha Dhanbad Jharkhand - 828122', '828122', '2002-07-23', '9572312607', 'sada9873@gmail.com', '298682966832', 'FHIPB1162A', 0x[encoded data, 16086 characters], 0x[encoded data, 17646 characters], 0x[encoded data, 21598 characters], '', '120220009001124', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-30 23:43:33', '2023-09-30 23:58:15');
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
(198, '#OPNAG-OW-00000186', '$2y$10$XIyjvmm3lZ2axjdg2vLwxO0tePXN.D0Ug4Sq2wU2njwq7ErCV72pm', '103.59.73.20', 'Prabhat ', 'Surendra Prasad Singh ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Flat No -307, Satyam Apartment PIT Colony Kankarbagh Patna Bihar -800020', NULL, '', '800020', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1982-11-06', '519112476177', NULL, 0x[encoded data, 15326 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'B', 'B/97', 'B/97/402', 'B/97/402 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', '700135', 'f', '1', '320', 'NO', '4', 'f', 8000, 'Eight Thousand ', 12000, 'Twelve Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Pranay Gurung ', 'Jai Kumar Gurung ', 'Dhobi Dhura Latpanchar G . C. P Sitting III G.P Latpanchar Forest Latpanchar Kurseong Darjeeling West Bengal - 734008', '734008', '1988-01-01', '8777240137', 'sada9873@gmail.com', '772476035782', 'BLXPG1197D', 0x[encoded data, 20214 characters], 0x[encoded data, 20214 characters], 0x[encoded data, 23878 characters], 0x[encoded data, 17806 characters], '11646', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-01 17:35:53', '2023-10-01 17:51:02');
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
(199, '#OPNAG-OW-00000187', '$2y$10$jC6s5Oz0oppd5h/a2c/PduoBW/SvzNFx5Ajk2/XeiXsJ9f.6EyZVa', '152.58.178.202', 'Samir Ahmed ', 'Sk Jahir Ahmed ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '18, Karaya Road Circus Avenue Kolkata West Bengal -700017', NULL, '', '700017', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1990-11-02', '728441650231', NULL, 0x[encoded data, 10550 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/08', 'A/08/104', 'A/08/104 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '1', '320', 'NO', '1', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Adrish Bhowmic', 'Tapas Bhowmic ', 'Rambandh, Burnpur, Asansol Bardhaman West Bengal - 713325', '713328', '2002-11-11', '8777240137', 'sada9873@gmail.com', '738617871089', 'CBKPB4033K', 0x[encoded data, 23390 characters], 0x[encoded data, 22374 characters], 0x[encoded data, 24302 characters], 0x[encoded data, 20982 characters], '2118701081', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-01 21:16:34', '2023-10-01 21:28:29');
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
(200, '#OPNAG-OW-00000188', '$2y$10$XK6T2XoQuCeGH4JtQFmrZufj4wtjMGh2qFCu5N02Crh700rxmSrOO', '103.59.73.30', 'Barnali Joardar', 'Khokan Joarder ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Sa kar Mission Para, Anatheswar Road Krishnonagor Nadia West Bengal 741101', NULL, '', '741101', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1961-12-11', '360353546896', NULL, 0x[encoded data, 12766 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D/291', 'D/291/304', 'D/291/304 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '1', '320', 'NO', '3', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-10-03', 11, '2024-09-02', 7, 1, 'Moumita Nesa', 'Shek Sirajuddin ', 'Shridharpur Purba Medinipur West Bengal 721632', '721632', '1992-07-13', '8158815397', 'sada9873@gmail.com', '515968555228', 'AVZPN5240P', 0x[encoded data, 11566 characters], 0x[encoded data, 12630 characters], 0x[encoded data, 11710 characters], '', '201934359', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-03 19:22:45', '2023-10-03 19:31:51');
