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
(24, '#OPNAG-OW-00000018', '$2y$10$Wo85Hc2CYGv9qWXw3m43Q.54QIjZAgtTsYActvUTYT0CjQGWBSniK', '49.37.51.232', 'sujan', 'soma', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Basirhat', NULL, 'sujanm311@gmail.com', '743412', NULL, NULL, '7595972963', 'sujanm312@gmail.com', '1995-06-29', '904529691949', 'CLXPM4153J', 0x[encoded data, 14534 characters], 0x[encoded data, 14534 characters], 0x[encoded data, 14534 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'naa', '111', '111', 'test', NULL, 'f', '1', '1200', '111', '6', 'f', 5000, 'Five Thousand ', 2000, 'Two Thousand ', 0.00, 14, '2023-06-01', 4, '2023-09-30', 5, 4, 'sujan', 'soma', 'Basirhat', '743412', '1995-06-29', '7908051944', 'sujanm312@gmail.com', '904529691949', 'clxpm4153j', 0x[encoded data, 14534 characters], 0x[encoded data, 14534 characters], 0x[encoded data, 14534 characters], 0x[encoded data, 14534 characters], 'Student', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-11 20:37:42', '2023-06-11 20:54:30');
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
(26, '#OPNAG-OW-00000020', '$2y$10$KW/v48KD5GdUN4qtWJhUH.ARWBBe0cpNgayVGmy9cjojN9ScnNTgS', '45.250.247.72', 'Sbsbb', 'Bhshsh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Hdhhdhjd', NULL, '', '700131', NULL, NULL, '9876543210', 'ananda.chakraborty2008@gmail.com', '1999-06-18', '987654320987', 'HSHHS9876S', 0x[encoded data, 14870 characters], 0x[encoded data, 14870 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 4, 'Elita garden vista', 'Hdhdjd', 'Hdhhd', 'Hhdhhdd', 'Hdhhdjksjjd', NULL, 'f', '2', NULL, NULL, NULL, 'f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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-12 00:02:08', '2023-06-12 00:05:56');
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
(27, '#OPNAG-OW-00000020', '$2y$10$IA/Nn/Rc5BKXHo52Ad7mH.FnRtQTIluN.cWwDmt05gF2ftdeUj8ri', '49.37.51.232', 'asdasdasd', 'sdfsdfsdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'asdadadadadd', NULL, '', '700131', NULL, NULL, '9987843214', 'asdasd@gmail.com', '1999-09-25', '369852147258', 'ADADA9874A', 0x[encoded data, 14534 characters], 0x[encoded data, 14534 characters], 0x[encoded data, 14534 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'asda', 'asdad', 'asdad', 'asdadadada', NULL, 'f', '2', '963', 'adadad', '4', 'f', 25879, 'Twenty Five Thousand Eight Hundred and Seventy Nine Only ', 56980, 'Fifty Six Thousand Nine Hundred and Eighty Only ', 1254.00, 5, '2023-06-25', 8, '2024-02-24', 7, 9, 'asdadad', 'zxxzcz', 'zxczxcxzczxzxcz', '700131', '1999-09-25', '9874654120', 'adadasd@gmail.com', '987465413210', 'adasa9874a', 0x[encoded data, 17846 characters], 0x[encoded data, 17846 characters], 0x[encoded data, 17846 characters], 0x[encoded data, 17846 characters], 'asdasdada', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-12 01:17:23', '2023-06-12 01:34: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
(28, '#OPNAG-OW-00000021', '$2y$10$9ktCVeR0qzFMxSdhjlY2CuTKTX.jrmi65jWS/0x5YlWb4l1GotkIO', '45.250.247.72', 'Shiladitya', 'Ajoy Chakraborty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'MGM', NULL, '', '700121', NULL, NULL, '9874654120', 'ananda@gmail.com', '1983-09-26', '963085207410', 'ASDAD9874A', 0x[encoded data, 14142 characters], 0x[encoded data, 14142 characters], 0x[encoded data, 14142 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'Block M', 'Apartmet 96', 'Flat 78', 'block b, Lake Town, Kolkata, West Bengal 700089', NULL, 'f', '2', '2500', 'NA', '3', 'f', 25487, 'Twenty Five Thousand Four Hundred and Eighty Seven Only ', 36987, 'Thirty Six Thousand Nine Hundred and Eighty Seven Only ', 1254.00, 2, '2023-06-25', 5, '2023-11-24', 7, 8, 'Akash', 'upal', 'Street:  6-3-569/1, Somajiguda\r\n\r\nCity:   Hyderabad\r\n\r\nState/province/area:    Andhra Pradesh\r\n\r\nPhone number  00402332581\r\n\r\nZip code  500082', '500082', '1999-06-25', '9874654120', 'upal@gmail.com', '987465412050', 'asdfd9630a', 0x[encoded data, 14142 characters], 0x[encoded data, 19446 characters], 0x[encoded data, 18542 characters], 0x[encoded data, 19446 characters], 'Serv 985', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-12 02:28:59', '2023-06-12 02:43:01');
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
(29, '#OPNAG-OW-00000022', '$2y$10$q1i93KIvYuvalkQY7cEVdePCzKLvzVLwN/CQNIK1fUdvf7uoK7OTe', '157.40.163.252', 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '296/3 Ali harder Road Titagarh Kolkata 700119', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1998-10-26', '355087659876', 'BZBPA0379R', '', '', '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K-45', 'K-45/302', 'K-45/302, SP Shukhobrishti housing Complex Kolkata 700156', NULL, 'f', '1', '420', 'No', '4', 'f', 10000, 'Ten Thousand ', 2000, 'Two Thousand ', 0.00, 0, '2023-07-01', 11, '2024-05-31', 6, 1, 'TAMIM AKHTAR', 'Naim Akhtar', 'A-10/4 ARENA HOUSING COMPLEX\r\nSTREET-110\r\nBACK TO CENTAL MALL,NEWTOWN', '700156', '1997-01-06', '9674946680', 'tamimakhtar56@gmail.com', '393656133570', 'BSFPA8475H', 0x[encoded data, 22438 characters], 0x[encoded data, 23262 characters], 0x[encoded data, 32062 characters], 0x[encoded data, 19934 characters], 'IVY NEST APARTMENTS', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-12 10:19:03', '2023-06-12 10:53:04');
