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
(146, '#OPNAG-OW-00000135', '$2y$10$ZEMptcBrCbIMJSSsJUrVRunJOVcGRjy59ANwa4D1Np3SLWeS2XcSy', '110.224.98.69', 'Purnima Nandi', 'Santinath Nandi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'W/O Santinath Nandi, NATURAL HEIGHT, FLAT - NO-9 E BLOCK 2, PADMAPUKUR, BENACHITY, DURGAPUR, BARDDHAMAN', NULL, '', '713213', NULL, NULL, '9775741748', 'firojahamed8835@gmail.com', '1960-01-18', '694658063210', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A04', 'A04/301', 'A04/301, SP Sukhobrishti, New Town, Kolkata, 700135', NULL, 'f', '1', '320', 'No', '3', 'f', 9500, 'Nine Thousand Five Hundred ', 19000, 'Nineteen Thousand ', 0.00, 10, '2023-08-07', 11, '2024-07-06', 6, 1, 'Shreya Bhui', 'Netai Bhui', 'Vivekananda Sarani, Vivekananda Park, Asansol 5, Ramkrishna Mission Bardhaman ', '713305', '2002-09-27', '9064803086', 'shreyabhui2002@gmail.com', '405898073274', 'FHUPB3834B', 0x[encoded data, 30198 characters], '', 0x[encoded data, 35126 characters], 0x[encoded data, 32878 characters], 'DT20234056457', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-07 12:54:59', '2023-08-07 13:35:36');
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
(147, '#OPNAG-OW-00000136', '$2y$10$qAXqV6vINkdjfScD1Mn4i.TfHxWO4yl.iFZcXtho1iUtRIwBcpFeC', '110.224.98.69', 'Purnima Nandi', 'Santinath Nandi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'W/O Santinath Nandi, NATURAL HEIGHT, FLAT - NO-9 E BLOCK 2,PADMAPUKUR, BENACHITY, Durgapur (m Corp), BARDDHAMAN', NULL, '', '713213', NULL, NULL, '9775741747', 'firojahamed8835@gmail.com', '1960-01-18', '694658063210', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A04', 'A04/301', 'A04/301, SP Sukhobrishti', NULL, 'f', '1', '320', 'NO', '3', 'f', 9500, 'Nine Thousand Five Hundred ', 19000, 'Nineteen Thousand ', 0.00, 0, '2023-08-07', 11, '2024-07-06', 6, 1, 'Shreya Bhui', 'Netai Bhui', 'Vivekananda Sarani, Vivekananda Park, Asansol - 5, Ramkrishna Mission, BARDDHAMAN, West Bengal 713305', '713305', '2002-09-27', '9064803086', 'shreyabhui2002@gmail.com', '405898073274', 'FHUPB3834B', '', '', '', '', 'DT20234056457', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-07 16:48:00', '2023-08-07 17:00:45');
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
(148, '#OPNAG-OW-00000137', '$2y$10$T5FsbhJ2fAWrQ.L5O1uOf.KWnE6Dvcp4y638j/arg50Z26ZHlEtZe', '103.189.130.103', 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '9466433', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '2023-08-01', '355087659876', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 5, 'Eden court', 'G', 'Da', 'Daq', 'Hsievussvznxnxjx', NULL, 'f', '1', '334', 'Ctyyv', '3', 'f', 356, 'Three Hundred and Fifty Six Only ', 346, 'Three Hundred and Forty Six Only ', 3456.00, 10, '2023-08-17', 7, '2024-03-16', 1, 1, 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '700119', '2023-08-01', '7003359699', 'nayab1997@gmail.com', '393656133570', 'BZBPA0379R', 0x[encoded data, 25646 characters], 0x[encoded data, 25646 characters], 0x[encoded data, 43118 characters], 0x[encoded data, 16454 characters], 'IVY Nest Apartments', 's', 'Nezamuddin Ansari', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '789012345566', 'BZBPA0397R', 'Huj', 'nayab1997@gmail.com', '7003359699', NULL, 'Dgghnm\r\nFfgghhhb\r\nCccvvgtdcvhh\r\nCcdcv', '2023-08-08 20:12:10', '2023-08-08 20:29:32');
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
(149, '#OPNAG-OW-00000138', '$2y$10$nV6.61fUMKupK8cMknPl5uz0XRw04YfVmXO.bQycbHHdKZPhMQLey', '49.37.35.141', 'Sourav Basak', 'Test 2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'lkjoieorvoebrov', NULL, 'souravbasak185@gmail.com', '700006', NULL, NULL, '7998190973', 'basaksourav030@gmail.com', '2023-08-16', '254836548975', NULL, 0x[encoded data, 11662 characters], 0x[encoded data, 9222 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 3, 'TATA Avenida', 'jkwefb', 'lklwnelw', '46', 'edfbb', NULL, 'v', '4', '25', 'fer', '15', 'f', 125000, 'One Lakh Twenty Five Thousand ', 15640, 'Fifteen Thousand Six Hundred and Forty Only ', 1540.00, 8, '2023-08-09', 5, '2024-01-08', 4, 6, 'Sourav Basak', 'dsvsd', '2 No, Jadu Pandit Road, Kolkata - 700006', '700006', '2023-08-09', '7998190973', 'basaksourav030@gmail.com', '216547893254', 'chbig7850h', 0x[encoded data, 9222 characters], 0x[encoded data, 11662 characters], 0x[encoded data, 11662 characters], 0x[encoded data, 9222 characters], 'Free Recharge', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'svSVSF', '2023-08-08 20:16:43', '2023-08-08 20:52: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
(150, '#OPNAG-OW-00000139', '$2y$10$pufOtRwJrM/tY473sipibeu6vFKcnBQ061MICIaOULaOusqBfqc7O', '49.37.35.141', 'Sourav Basak', 'Test 2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'lkjoieorvoebrov', NULL, 'basaksourav030@gmail.com', '700006', NULL, NULL, '7998190973', 'basaksourav030@gmail.com', '2023-09-02', '254836548975', NULL, 0x[encoded data, 11662 characters], 0x[encoded data, 9222 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 6, 'Newtown heights', 'jkwefb', 'lklwnelw', '46', 'srfg', NULL, 'v', '2', '25', 'fer', '12', 'f', 125000, 'One Lakh Twenty Five Thousand ', 15640, 'Fifteen Thousand Six Hundred and Forty Only ', 1540.00, 9, '2023-08-18', 4, '2023-12-17', 6, 9, 'Sourav Basak', 'dsvsd', '2 No, Jadu Pandit Road, Kolkata - 700006', '700006', '2023-08-24', '7998190973', 'basaksourav030@gmail.com', '216547893254', 'chbig7850h', 0x[encoded data, 9222 characters], 0x[encoded data, 11662 characters], 0x[encoded data, 11662 characters], 0x[encoded data, 9222 characters], 'Free Recharge', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'zdxc v ', '2023-08-09 03:11:38', '2023-08-09 03:13:35');
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
(151, '#OPNAG-OW-00000140', '$2y$10$Z4ubg401nQ45F03VxymcDuVrWsX3wL5pltoWZV/xgsYoDwNjyv18u', '103.189.130.103', 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'ARENA HOUSING COMPLEX, Action Area III , Newtown 700135', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '2023-08-02', '355087659876', NULL, 0x[encoded data, 16774 characters], 0x[encoded data, 16774 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'B', 'B-161', 'B-161/401', 'adasfaasfasdasdasd', NULL, 'f', '1', '420', 'S/12', '6', 'f', 18521, 'Eighteen Thousand Five Hundred and Twenty One Only ', 12, 'Twelve Only ', 1.00, 10, '2023-08-01', 11, '2024-06-30', 7, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'axxax', '2023-08-09 13:00:22', '2023-08-09 13:04: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
(152, '#OPNAG-OW-00000141', '$2y$10$.gd73vMUb.f91w/Z2Jzs7OHFdD/WSsrtKP8Y4RACSgfbpFfO1kkKi', '49.37.35.141', 'Rahul Sharma', 'Test 2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'lkjoieorvoebrov', NULL, 'basaksourav030@gmail.com', '802301', NULL, NULL, '7894563210', 'souravbasak185@gmail.com', '2023-08-14', '254836548975', NULL, 0x[encoded data, 11662 characters], 0x[encoded data, 9222 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 4, 'Elita garden vista', 'jkwefb', 'lklwnelw', '46', 'gckuvgjh', NULL, 'h', '2', '25', 'fer', '15', 'f', 125000, 'One Lakh Twenty Five Thousand ', 15640, 'Fifteen Thousand Six Hundred and Forty Only ', 1540.00, 10, '2023-08-04', 2, '2023-10-03', 7, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'yfxfch', '2023-08-09 13:24:57', '2023-08-09 13:25:40');
