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
(39, '#OPNAG-OW-00000031', '$2y$10$TJu2zpRmXViShLRaw4hcuuCh5LaGyEY76ndXJqshU4DvYzsU3FN4W', '103.189.130.109', 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '295/3 Ali Haider Road Gowalpara 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', 'B', 'B-161', 'B-161/401', 'B-161/401 SP SUKHOBRISHTI HOUSING COMPLEX NEWTOWN ACTION ACTION III 700135', NULL, 'f', '1', '390', 'No', '3', 'f', 12000, 'Twelve Thousand ', 24000, 'Twenty Four Thousand ', 0.00, 0, '2023-06-01', 11, '2024-04-30', 6, 1, 'TAMIM AKHTAR', 'Naim Akhtar', 'ARENA HOUSING COMPLEXSTREET-110BACK TO CENTAL MALL,NEWTOWN', '700156', '1997-01-06', '9674946680', 'tamimakhtar56@gmail.com', '473908761234', 'BZBPA0379R', 0x[encoded data, 30670 characters], 0x[encoded data, 32062 characters], 0x[encoded data, 32062 characters], 0x[encoded data, 31518 characters], 'IVY NEST APARTMENTS', 's', 'Service', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '456709871234', 'Hihpa0896r', 'Bak-123', 'Ordealmarker@gmail.com', '9883499490', NULL, NULL, '2023-06-14 23:48:50', '2023-06-15 00:05:50');
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
(40, '#OPNAG-OW-00000032', '$2y$10$UTWU3AzctSGY4V70piWA1uy7ruPquLd6HgDxbQvfFGiGSKpiS.8Ni', '103.189.130.109', 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'jskcncscnsxnsjnx kscnkncscnscnsocns sicsknsknwiwnxwam', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1998-10-26', '355087659876', 'BZBPA0379R', 0x[encoded data, 11022 characters], 0x[encoded data, 10878 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'C', 'C-666', 'B-161/401', 'ojudhsjohidhsA KSCNKJIahiaxnskpx ksnkscioshcs dwdm jxcnxjc nsknushaxkscjdpivjcndfmjcxcsnk', NULL, 'f', '3', '580', 'S/12', '10', 'f', 18521, 'Eighteen Thousand Five Hundred and Twenty One Only ', 20000, 'Twenty Thousand ', 0.00, 10, '2023-06-15', 11, '2024-05-14', 6, 1, 'TAMIM AKHTAR', 'Naim Akhtar', 'ARENA HOUSING COMPLEX\r\nSTREET-110\r\nBACK TO CENTAL MALL,NEWTOWN', '700156', '2023-06-15', '9674946680', 'tamimakhtar56@gmail.com', '393656133570', 'BSFPA8475H', 0x[encoded data, 12974 characters], 0x[encoded data, 9382 characters], 0x[encoded data, 10766 characters], 0x[encoded data, 10982 characters], 'IVY NEST APARTMENTS', 's', 'Nezamuddin Ansari', 'nkjjbkjbxjbjb jbljbjbzbz jbz', '789012345566', 'BZBPA0397R', 'nkanak', 'nayab26@outlook.co.in', '9883499490', NULL, NULL, '2023-06-15 00:59:00', '2023-06-15 01:13:22');
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
(41, '#OPNAG-OW-00000033', '$2y$10$0.fITmYxT70zX2mnn137Fe1Zr2kc4AUEtMCDPqTTGgQnDJoXPOrkS', '42.105.103.0', 'Monirul Islam ', 'Nazrul Islam Molla', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Bhagowanpur pakapole Kashipur 24 pgs (s) 700135', NULL, '', '700135', NULL, NULL, '7407727505', 'mi9837380@gmail.com', '1990-05-01', '258220838683', 'AEEPI5077F', 0x[encoded data, 5622 characters], 0x[encoded data, 13438 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K-Block', 'K -40', 'k-40/201', 'SP -Shukhobrishti Newtown kolkata 700135\r\n', NULL, 'f', '1', '420', 'No', '2', 'f', 12000, 'Twelve Thousand ', 3000, 'Three Thousand ', 6000.00, 1, '2023-06-15', 6, '2023-12-14', 2, 2, 'Mir Hossain', 'Tarikul ', 'Naazrul Islam Molla', '700156', '2000-06-15', '9836943735', 'nayab1997@gmail.com', '393656133570', 'BZBPA0397R', 0x[encoded data, 13982 characters], 0x[encoded data, 8326 characters], 0x[encoded data, 14566 characters], 0x[encoded data, 12014 characters], '12456', 's', 'Mbbs', 'Rabi Islam', '740772740511', 'BXKPM7865C', 'MBBS001', 'moni111@gmail.com', '9836473821', NULL, NULL, '2023-06-15 10:36:55', '2023-06-15 11:14:39');
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
(42, '#OPNAG-OW-00000034', '$2y$10$fhvpJqGnxOgN4V3HjW2OHeR9.oG6pC/ka9iOeQWusr9/Cb/zGBI7y', '157.40.108.6', 'Mohinur Hasan Molla', 'Moksed ali', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Matiagacha rajarhat north 24 pgs kol 700135', NULL, 'mohinurhasanm.@gmail.com', '700135', NULL, NULL, '9836550569', 'mollabiju897@gmail.com', '1981-06-23', '551005374781', 'BXKPM6363C', 0x[encoded data, 18422 characters], 0x[encoded data, 19014 characters], 0x[encoded data, 25686 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D block', 'D344', '303', 'SP shukhobristhi Newtown rajarhat kol.- 700135', NULL, 'f', '1', '320', 'No', '3', 'f', 9775, 'Nine Thousand Seven Hundred and Seventy Five Only ', 9775, 'Nine Thousand Seven Hundred and Seventy Five Only ', 0.00, 0, '2023-06-15', 11, '2024-05-14', 3, 1, 'Parimal sardar', 'Panchu sardar', 'Ghashkhali Newtown kol 700135', '700135', '1996-06-15', '9062711388', 'mollabiju897@gmail.com', '235687907875', 'BXKPM3636C', 0x[encoded data, 19014 characters], 0x[encoded data, 13750 characters], 0x[encoded data, 25686 characters], '', 'Students', 's', 'Doctor', 'Lauhati north 24 pgs', '234509875674', 'BXLPM6878C', 'MBBS', 'mollabiju897@gmail.com', '9804235434', NULL, NULL, '2023-06-15 10:43:03', '2023-06-15 10:56:25');
