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
(188, '#OPNAG-OW-00000176', '$2y$10$qP2t5MuHiEK0REsjX18T4.OSPnST7uGOiA9FUet78kGzDLGpjbb2.', '103.59.73.20', 'Sudip Kumar Saha', 'Ananta Kumar Saha ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'B.J-201, Salt Lake Sector 2 Bidhannagar Sech Bhawan North 24 Parganas West Bengal 700091', NULL, '', '700091', NULL, NULL, '8334029574', 'sahasudip67@gmail.com', '1968-01-12', '992099852168', NULL, 0x[encoded data, 13830 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', 'J/16', 'J/16/706', 'J/16/706 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '2', '735', 'NO', '7', 'f', 11000, 'Eleven Thousand ', 11000, 'Eleven Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Saptaswa Saha', 'Swapan Saha', '13/4 M.M Chandidas Road Ward 02 Buro Shibtala Nabadwip Nadia West Bengal - 741302', '741302', '1995-01-10', '7076865268', 'imranhassi.0022@gmail.com', '853401421777', 'FABPS3593A', 0x[encoded data, 12422 characters], 0x[encoded data, 8902 characters], 0x[encoded data, 9646 characters], 0x[encoded data, 9406 characters], 'IN07214221751219', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-24 23:01:44', '2023-09-24 23:12: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
(189, '#OPNAG-OW-00000177', '$2y$10$fYsm43HA6R4cjCup2OIwp.xSAJpKpCvPE6fLg18jlsWXVIfGaZLpW', '103.59.72.54', 'Somesh Ghatak', 'Jogeshwar Ghatak ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'House No. FC-49, Lajpat Nagar, Sahibabad Ghazi Abad, Uttar Pradesh -201005', NULL, '', '201005', NULL, NULL, '8777240137', 'imranhassi.0022@gmail.com', '1957-09-25', '226304236118', NULL, 0x[encoded data, 23318 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K/34', 'K/34/405', 'K/34/405 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '2', '735', 'NO', '4', 'f', 12000, 'Twelve Thousand ', 24000, 'Twenty Four Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Hara Prasad Chattopadhyay ', 'Brahma Prasad Chattopadhyay ', 'Faridpur Colony, Harisabha Mandir, Katwa Barddhaman West Bengal 713130', '713130', '1999-09-27', '8348817467', 'sada9873@gmail.com', '510121109315', 'BRLPC9976L', 0x[encoded data, 16454 characters], 0x[encoded data, 14590 characters], 0x[encoded data, 17398 characters], 0x[encoded data, 19254 characters], '1917388', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-26 18:24:51', '2023-09-26 18:42:16');
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
(190, '#OPNAG-OW-00000178', '$2y$10$z3fGhwVRRDjSSXECgNmec.v1AqNe9l9DhkqCr.dUYuu0oJvmaSge6', '103.59.72.54', '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', 'sada9873@gmail.com', '1982-10-06', '519112476177', NULL, 0x[encoded data, 15326 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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-09-26 23:34:26', '2023-09-26 23:34: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
(191, '#OPNAG-OW-00000179', '$2y$10$7j0fmyfYwymGCO1zAuN0C.rGGemuAwBkj27HS6pjucAbfdq6h/ymm', '152.58.180.163', 'Rajarshi Paul', 'Ramprasad Paul', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '1, Beg STN Road, Bagmore, Kumarpara, Kanchrapara North 24 Parganas West Bengal -743145', NULL, '', '743145', NULL, NULL, '8348817467', 'rajatan.Paul@gmail.com', '2023-10-01', '670447327622', NULL, 0x[encoded data, 9126 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E/421', 'E/421/402', 'E/421/402 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '1', '320', 'NO', '4', 'f', 8000, 'Eight Thousand ', 16000, 'Sixteen Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Abhishek Tiwari ', 'Anil Kumar Tiwari ', 'Bishukia, Ballia, Phehpana, Uttar Pradesh -277503', '277503', '1998-06-05', '6261275518', 'sada9873@gmail.com', '677857266833', 'BAJPT4300G', 0x[encoded data, 9798 characters], 0x[encoded data, 11102 characters], '', 0x[encoded data, 14950 characters], '2302348', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-27 16:41:55', '2023-09-27 16:58:22'),
(192, '#OPNAG-OW-00000180', '$2y$10$fKbHGHUlDC.LW4QJv29OB.tQi2RxljMhgZWkQ9Nz8yW2sZDlTkoLm', '103.59.73.248', 'Rajarshi Paul', 'Ramprasad Paul', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '1, Beg STN Road, Bagmore, Kumarpara, Kanchrapara North 24 Parganas West Bengal -743145', NULL, '', '743145', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1983-11-07', '670447327622', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E/421', 'E/421/402', 'E/421/402 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '1', '320', 'NO', '4', 'f', 8000, '', 16000, '', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Abhishek Tiwari ', 'Anil Kumar Tiwari ', 'Bishukia, Ballia, Phehpana, Uttar Pradesh -277503', '277503', '1998-06-05', '6261275518', 'sada9873@gmail.com', '677857266833', 'BAJPT4300G', '', '', '', '', '2302348', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-27 17:04:30', '2023-09-27 17:08:31');
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
(193, '#OPNAG-OW-00000181', '$2y$10$4/xSuT3AAcEiGQ5HxiHxq.LeAWiTa6RFvQqnnaR6sZAylpLml0fA.', '103.59.73.248', 'Ram Prasad Paul ', 'Jugal Kishore Pul', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '76/66/79 Bag Station Road Kumarpara Bagmore,VTC,  Anakha, Po Kanchrapara North 24 Parganas West Bengal 743145', NULL, '', '743145', NULL, NULL, '8013191288', 'imranhassi.0022@gmail.com', '1954-04-04', '735933665914', NULL, 0x[encoded data, 11614 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E/421', 'E/421/402', 'E/421/402 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', '700135', 'f', '1', '320', 'NO', '4', 'f', 8000, 'Eight Thousand ', 16000, 'Sixteen Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Abhishek Tiwari ', 'Anil Kumar Tiwari ', 'Bishukia Ballia Phehpana Uttar Pradesh 277503', '277503', '1998-06-05', '6261275518', 'sada9873@gmail.com', '677857266833', 'DAJPT4300G', 0x[encoded data, 9086 characters], 0x[encoded data, 12382 characters], 0x[encoded data, 11390 characters], 0x[encoded data, 11054 characters], '2302348', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-27 17:41:25', '2023-09-27 17:50:17');
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
(194, '#OPNAG-OW-00000182', '$2y$10$W7ohyTPs5jv1J4WvBtelO.0HBR/PGJ4xdLe9YCTD0S4sMOI5UEpVO', '152.58.182.195', 'Somesh Ghatak', 'Jogeshwar Ghatak ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'House No. FC-49, Lajpat Nagar, Sahibabad Ghazi Abad, Uttar Pradesh -201005', NULL, '', '201005', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1872-09-19', '226304236118', NULL, 0x[encoded data, 23318 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K/34', 'K/405', 'K/34/405 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', '700135', 'f', '2', '735', 'NO', '4', 'f', 12500, 'Twelve Thousand Five Hundred ', 24000, 'Twenty Four Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Hara Prasad Chattopadhyay ', 'Brahma Prasad Chattopadhyay ', 'Faridpur Colony Harisabha Mandir Katwa Barddhaman West Bengal 713130', '713130', '1999-09-27', '8777368939', 'sada9873@gmail.com', '510121109315', 'BRLPC9976L', 0x[encoded data, 16454 characters], 0x[encoded data, 14590 characters], 0x[encoded data, 17398 characters], 0x[encoded data, 19254 characters], '1917388', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-28 17:39:35', '2023-09-28 17:46: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
(195, '#OPNAG-OW-00000183', '$2y$10$L/8U7vsjm.FCI4XxuL2d7OV2edLeMrxNCl7YMyQ4hiBitQ0z6GI7u', '103.59.73.164', 'Rintu Mondal ', 'Uttam Mondal ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '2C Kanakangan Apartment Bengal Shristi Complex City Centre Durgapur Bardhaman West Bengal 713216', NULL, '', '713216', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1976-12-31', '870891292509', NULL, 0x[encoded data, 24494 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E', 'E/370', 'E/370/303', 'E/370/303 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700138', '700135', 'f', '1', '320', 'NO', '3', 'f', 8500, 'Eight Thousand Five Hundred ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 7, 1, 'Sudipta Pusty', 'Ashok Kumar Pusty ', 'M-29/30 Saharpura Sindri, Saharpura Sindri, Dhanbad Jharkhand - 828122', '828122', '1994-06-22', '9836376990', 'sada9873@gmail.com', '550840776658', 'CIYPP0268H', 0x[encoded data, 12174 characters], 0x[encoded data, 9310 characters], 0x[encoded data, 16270 characters], 0x[encoded data, 16406 characters], '2029326', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-09-29 16:29:23', '2023-09-29 16:40:01');
