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
(133, '#OPNAG-OW-00000122', '$2y$10$k2xpyaqN0xlKKqZVTqhhsOMjuMUv9NNyFhuoAgknsMMtHbiTB7bGG', '157.40.205.189', 'Mirza Sakhawat Ullah', 'Mirza Zaimul Zahedin Baig', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Kandarpur,  kandarpur,  cuttack, kandarpur, odisha , 754100', NULL, '', '754100', NULL, NULL, '9748961500', 'msu.200717@gmail.com', '1986-04-04', '637633145359', NULL, 0x[encoded data, 15814 characters], 0x[encoded data, 11294 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', '23', '605', 'Flat No. 605, 6th Floor, k - 23, Sharpoorji Sukhobrishti Residential Complex, Action Area - 3, Newtown,  Kolkata  - 700135, Distt - North 24 Parganas', NULL, 'f', '2', '480', '1', '6', 'f', 15000, '', 30000, '', 0.00, 0, '2023-08-01', 11, '2024-06-30', 3, 2, 'Abhishek', 'Gajanand', '62, Near Old Bus Stand, Mohalla Adarsh Nagar, Bhiwani, Bhiwani, Haryana - 127021', '127021', '1987-05-25', '8826250465', 'Abhishek.k.hcl@gmail.com', '760942390673', 'ARVPA1498C', 0x[encoded data, 16990 characters], 0x[encoded data, 12742 characters], 0x[encoded data, 15022 characters], 0x[encoded data, 19734 characters], 'SERVICE ', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'THIS LICENSEE AGREEMENT made this the 25\" day pt.day: 023 dames\r\nMIRZA SAKHAWAT ULLAH, Aadhat No- 6376 3314 5359. son of Mirza\r\nZaimul Zahedin Baig. by faith- Islam, by occupation-\r\nNOTARY\r\n3600. MOr Tesiding al\r\nKandarpur, Cuttack. Odisha- 754100, herein after called and fêrefred to as \"The Licensor/Owner\' of the FIRST PART \" (which expression shall\" include her heirs. legal representatives, successors and assigns).\r\nAND\r\nABHISHEK KAUSHIK, Aadhar No- 7609 4239 0673 son of Gajanand Kaushik. by faith-Hindu. by occupation-Servie, residing at 62. Adarsh Nagar, near Civil Line Police Station, District- Bhiwani. Haryana, Pin- 127021 hereinatier called as The Licensec/ Second party*of the SECOND PART (which expression shall include her heirs. legal representatives. successors and assigns).\r\n\r\n3. That he Licensee will use the said schedule propenty for residential purpose shly\"* and it is also mentioned here that the guest and relatives are allowed in the Licensed paction for temporary basis but not for permanently.\r\n6. That it is further agreed, declared and covenanted by and between the parties that the schedule property will be used and occupied by the Licensee on the following terms and conditions.\r\na) That the Licensee shall keep the schedule property in good habitable condition and repair the inside broken.\r\nb) That the save and except as aforesaid. the License shall othenwise maintain and preserve the said schedule property in good condition or order. protect the same against moths and white ants.\r\nc) That the Licensee use the schedule property for residential purpose be it mentioned here that the License should not carry on any trade in the Schedule Property or use the same for illegal and unlawful purpose or will not make any oflice of any political party.\r\nd) That the Licensee has to keep adequate numbers of fire extinguishers inside property and will make all possible arrangements for the fire safety. In Case of any event of fire in the schedule solely responsible for the same and cannot claim any compensation from the Licensor on the contrary on the License will compensate for the damages to the Licensor.\r\ne) That the Licensce shall neither hold nor cause or allow to hold held any public performance meeting or public function in the schedule property.\r\n1) That the Licensee shall not create or cause to be created any nuisance or annoyance in the schedule property.\r\ng) That the Licensee Shall pay the Municipality Property Tas (if any) in the Licence Period for the schedule property mentioned on this agreement.\r\nh) That the Licensee Shall pay the monthly charges for Electricity Consumption bills of the schedule property on his own accounts.\r\ni ) That the Licensce shall not make any material alteration to the schedule property unless approved and sanctioned by the Licensor in writing and in any event such alleration. If permitted, shall be made by the Licensee at his own cost.  expenses and/ or on such terms and conditions as may tie imposed by the Licensor. Such\r\nalteration and additions shall in all cases become the propery and the Licensee shall not be entitled to any conditions by the Lieensor or to any compensation on that account.\r\n1) That the Licensce shall not transfer the Licensed portion whole or any portion thercof to any person or persons and the licensee shall not sub-let/sub license or under let/license or assign or transfer of his occupied portion.\r\nk) That if the Licensee cause any damage to the schedule property in that event a mason/ plumber/ Electrician will be appointed to repair/ asses the quantum damages and accordingly equal amount will be paid by the license to the licensor otherwise the Licensor will deduct from the security deposit.\r\n1) That the Licensee shall not leave the Licensed portion under lock and key condition for the long period without the consent of the Licensor.\r\nm) That the License has had inspected the schedule property and is fully satisfied about its condition and internal arrangement and has thereafter freely and voluntarily agreed to the terms of this agreement hereunder provided and shall not hereafter make any grievance on any account whatsoever.\r\nn) On any breach of any ofihe terms of the agreement the Licensor will be entitled to terminate the Licence on giving 66 days Notice.\r\nSOM AR\r\no) That if the Licensee wish to vacate the Licensed portion before the Licensed period mentioned herein above will be liable to giye 30days prior notice to the Licensor and Licensor shall also be liable to give sodays prior notice to Licensee need the Licensed portion before the licensed period as mentioned carlier.\r\nSONIOR.\r\np) That in case of renewal of this agreen?- &og, Augher period, a fresh\r\nagreement will be executed by and between the parties herein with exclusive renewal rights of the licenser and the said licensee fees will be increased mutually by the parties.\r\ng) That the licensee shall not claim any shifting charges from the Licensor at the time of surrendering of the licensed unit.\r\n\r\nTHE SCHEDULE ABOVE REFERED TO\r\n\r\nALL. THAT piece and parcel of said Flat on Sixth floor on the multi-storied building portion consisting of 2(Two) Bed rooms, 1(One) Kitchen,\r\n¿(Two) toilets and I (One) Hall at the Premises of Flat No- 605, 6\'* Floor, K-23, Shapoorji Sukhobristi Residential Complex, Action Area- 3, New Town, Kolkata- 700135, Dist- North 24 Parganas.\r\n', '2023-07-30 14:12:05', '2023-07-30 14:19:47');
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
(134, '#OPNAG-OW-00000123', '$2y$10$BKsmNqDDgH2UhpWYpqf1lujnu6ItDTQ6rI.q894FmmOoRuKOq/2/6', '103.59.73.206', 'RUPA DAS', 'ADHIR KUMAR BARMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Flat No 318, - E Maruti Heritage Ward No 46 Rajendra Prasad Ward Near IOB Bank Pachpedinaka, Raipur Chhattisgarh -492001', NULL, '', '492001', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1968-01-01', '524897244799', NULL, 0x[encoded data, 17222 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', 'J/06', 'J/06/1105', 'J/06/1105 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', NULL, 'f', '2', '735', 'NO', '11', 'f', 16000, 'Sixteen Thousand ', 32000, 'Thirty Two Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'NIRAJ KUMAR SONI', 'OM PRAKASH SAHU', 'Ranchi Khunti Road Mahavir Chowk Hatiya Ranchi Jharkhand - 834003', '834003', '1997-08-17', '7008298186', 'nirajsoni.nix@gmail.com', '914528989191', 'KLGPS4609C', 0x[encoded data, 22574 characters], 0x[encoded data, 15710 characters], 0x[encoded data, 13542 characters], 0x[encoded data, 9806 characters], '13438095', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-07-31 19:34:37', '2023-07-31 19:52:53');
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
(135, '#OPNAG-OW-00000124', '$2y$10$0WULesTvZb9qgLW9NQQfx.rAQfuPVT.LDbD50cLOHOVUjlRURg3S6', '49.37.33.247', 'r', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'cwerwv', NULL, 'cba@gmail.com', '700010', NULL, NULL, '7998190973', 'abc@gmail.com', '2023-07-01', '221365478921', 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', 'veve', '2', '2', 'fdv', NULL, 'rk', '3', '2520', '52', '50', 'f', 125600, 'One Lakh Twenty Five Thousand Six Hundred ', 125460, 'One Lakh Twenty Five Thousand Four Hundred and Sixty Only ', 5400.00, 5, '2024-03-12', 1, '2024-04-11', 6, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'wvwv', '2023-07-31 20:07:55', '2023-07-31 20:08:58'),
(136, '#OPNAG-OW-00000125', '$2y$10$8k4VF.adaDJWLW1VjKk/9.qxvuwiSHZtNGOkg.s7QdNh3Vj9z2QCS', '49.37.33.247', 'Sourav Basak', 'Test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'lkjoieorvoebrov', NULL, 'souravbasak185@gmail.com', '700006', NULL, NULL, '7998190973', 'basaksourav030@gmail.com', '2023-07-07', '254836548975', NULL, 0x[encoded data, 13222 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 5, 'Eden court', 'jkwefb', 'lklwnelw', '46', 'Giri', NULL, 'rk', '3', '25', 'fer', '9', 'f', 125000, '', 15640, '', 1540.00, 8, '2023-07-21', 3, '2024-02-20', 10, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Big oru but', '2023-07-31 23:34:40', '2023-07-31 23:39:12');
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
(137, '#OPNAG-OW-00000126', '$2y$10$AhEy8xRMjTzlJw9152j0uuCmtNOK82Ki3Nnj5dVHnsJcLqkubtvpG', '103.59.73.231', 'KARTIK MONDAL ', 'DULAL MONDAL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Bargachi, Moyail, Baragachi, Barddhaman, West Bengal - 713513', NULL, '', '713513', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1981-08-15', '837907418312', NULL, 0x[encoded data, 19686 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', 'J/13', 'J/13/304', 'J/13/304 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', NULL, 'f', '2', '735', 'NO', '3', 'f', 12000, 'Twelve Thousand ', 20000, 'Twenty Thousand ', 0.00, 10, '2023-08-15', 11, '2024-07-14', 6, 1, 'MOULIPRIYA BHAKTA', 'BISWAJIT BHAKTA', 'Rasdanga, Asansol,  MC, Asansol, Bardhaman, West Bengal - 713301', '713301', '1993-12-08', '7890631970', 'mouliur21@gmail.com', '202552858393', 'BUBPB0070K', 0x[encoded data, 18494 characters], 0x[encoded data, 18190 characters], 0x[encoded data, 19526 characters], 0x[encoded data, 18998 characters], 'UEIPL-96', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-01 11:15:59', '2023-08-01 11:26:51');
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
(138, '#OPNAG-OW-00000127', '$2y$10$XQn5NziRDH0zPwa/oAWVruUHDzc/Ze/wQt2wk0z29hTBZ9o.4.TRG', '152.58.178.86', 'PAROMITA JANA', 'BIMAL KUMAR DAW', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '6 Durgacharan Doctor Road Intally West Bengal 700014', NULL, '', '700014', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1972-06-04', '965268065739', NULL, 0x[encoded data, 22854 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J', 'J/08', 'J/08/301', 'J/08/301 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', NULL, 'f', '2', '735', 'NO', '3', 'f', 13000, 'Thirteen Thousand ', 13000, 'Thirteen Thousand ', 0.00, 10, '2023-08-01', 11, '2024-06-30', 6, 1, 'SUBHASRI LAHIRI ', 'BIPLAB LAHIRI ', 'Inda Postoffice Bosepara Kharagpur Inda West Midnapore West Bengal 721305', '721305', '1994-09-17', '9775453422', 'me.subhasreelahiri@gmail.com', '355633646299', 'AMDPL3327L', 0x[encoded data, 11526 characters], 0x[encoded data, 11526 characters], 0x[encoded data, 10702 characters], 0x[encoded data, 11670 characters], '20094774', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-02 11:28:40', '2023-08-02 11:43:10');
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
(139, '#OPNAG-OW-00000128', '$2y$10$jpTW31uWjFsDrhcHFg/bWeh6UhvdsCG7bpFMWZcUuUhzeu72lFue2', '152.58.179.83', 'DILIP KUMAR MONDAL ', 'PRANKRISHNA MONDAL ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Vill+Post Hatisala Ps KLC South 24 Parganas West Bengal - 700135', NULL, '', '700135', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1984-01-01', '786628536349', NULL, 0x[encoded data, 13790 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/52', 'A/52/203', 'A/52/203 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', NULL, 'f', '1', '320', 'NO', '2', 'f', 11500, 'Eleven Thousand Five Hundred ', 23000, 'Twenty Three Thousand ', 0.00, 10, '2023-08-04', 11, '2024-07-03', 6, 1, 'ASMITA MONDAL ', 'SANAT KUMAR MONDAL ', 'Dhandabag, Amrai Durgapur Bardhaman, Durgapur Steel Project, West Bengal 713203', '713203', '2005-03-05', '7557873528', 'asmitamondal2005@gmail.com', '478966792326', 'ADSPM3568J', 0x[encoded data, 11382 characters], 0x[encoded data, 14342 characters], 0x[encoded data, 13334 characters], 0x[encoded data, 20278 characters], 'NA', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-02 12:04:59', '2023-08-02 13:02:30');
