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
(116, '#OPNAG-OW-00000105', '$2y$10$7qoVB3GiAw2/mJwPCg6fPuOOLInyt4ZN2fmnFCX2StT0ToaQPemSS', '49.37.35.17', '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-07-19', '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, 1, 'SP Sukhobrishti Housing Complex', 'jkwefb', 'lklwnelw', '46', ';e;emvmpjepvor', NULL, 'f', '2', '25', 'fer', '4', 'f', 125000, 'One Lakh Twenty Five Thousand ', 15640, 'Fifteen Thousand Six Hundred and Forty Only ', 1540.00, 15, '2022-12-27', 8, '2023-08-26', 8, 5, 'veeve', 'kjbbkj', 'cmqlenchown', '746513', '2023-07-09', '9874561230', 'ttrt@gmail.com', '215647893205', 'cdpgp9875p', 0x[encoded data, 9222 characters], 0x[encoded data, 11662 characters], 0x[encoded data, 11662 characters], 0x[encoded data, 9222 characters], '598', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'lwvnwlrnvpw;vrnwp;vw', '2023-07-24 15:44:27', '2023-07-24 17:12:46');
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
(117, '#OPNAG-OW-00000106', '$2y$10$V.e8odYm0pfJInktJ627fe6ueuL6RWF7xmebpXQvIVkxQut.TwxqO', '103.59.73.138', 'NIRMAL KUMAR MONDAL ', 'BIJOY KUMAR MONDAL ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'B 4/25 Kalyani Near 3 No Market, Kalyani Nadia West Bengal 741235', NULL, '', '741235', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1958-03-27', '610736509897', NULL, 0x[encoded data, 19414 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'L', 'L/67', 'L/67/1402', 'L/67/1402 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal -700135', NULL, 'f', '3', '901', 'NO', '14', 'f', 15000, 'Fifteen Thousand ', 30000, 'Thirty Thousand ', 0.00, 10, '2023-08-01', 11, '2024-06-30', 6, 0, 'DEBAYAN ROY', 'DEBASISH ROY', '24 S R Layout Main Road Murugeshpalya Bangalore North Vimanapura, Karnataka 560017', '560017', '1985-01-24', '9986394641', 'debzkool@gmail.com', '686670200239', 'AKXPR0311A', 0x[encoded data, 18102 characters], 0x[encoded data, 19094 characters], 0x[encoded data, 21750 characters], 0x[encoded data, 16998 characters], 'NA', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-07-24 19:12:38', '2023-07-24 19:33:41');
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
(118, '#OPNAG-OW-00000107', '$2y$10$ruaBG3ECQsiRxo8vhRYHJeOnfBbrcmd.x1gU.PPcMnHpAzA4S.x.q', '152.58.183.20', 'Shamim Ahmed', 'Mokaddes Ahmed ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'LX 40302, UTSA THE CONDOVILLE, BLOCK AG/1/D, NEW TOWN, NEW TOWN S.O , NORTH TWENTY FOUR PARGHANAS , WEST BENGAL -700156', NULL, 'shamschon123@gmail.com', '700156', NULL, NULL, '7003614052', 'Shamschon123@gmail.com', '1978-08-14', '413079347330', NULL, 0x[encoded data, 20190 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K block', 'K43', '703', 'SP Sukhobrishti Ln, Action Area III, Newtown, New Town, West Bengal 700135', NULL, 'f', '2', '480', 'No', '7', 'f', 18500, 'Eighteen Thousand Five Hundred ', 37000, 'Thirty Seven Thousand ', 0.00, 0, '2023-07-10', 11, '2024-06-09', 6, 0, 'Lumbini Jain', 'Kamal Kumar Jain ', 'Bengali road, gpo, mithapur, B area,phulwari patna 800001', '800001', '2000-05-15', '8210532957', 'lumbinijain15@gmail.com', '574982589545', 'CFJPJ1706G', 0x[encoded data, 20470 characters], 0x[encoded data, 20150 characters], 0x[encoded data, 16758 characters], 0x[encoded data, 17206 characters], '13618891', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-07-24 19:38:03', '2023-07-24 19:48:00');
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
(119, '#OPNAG-OW-00000108', '$2y$10$YgKwnGQsV5ZzJNYKb5tjeuaQnEbKGPIa4DM3YiuZohrdHcDRXsAY.', '49.37.35.17', '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-07-04', '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', 'khvuckcdoytdiy', NULL, 'v', '3', '25', 'fer', '7', 'f', 125000, 'One Lakh Twenty Five Thousand ', 15640, 'Fifteen Thousand Six Hundred and Forty Only ', 1540.00, 15, '2023-07-14', 9, '2024-04-13', 8, 8, 'kjkb', 'dsvsd', 'svsv', '700006', '2023-08-05', '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, 'lasknova\'dnvjb\'oVI\'wVu\'owrbvo\'', '2023-07-25 03:29:11', '2023-07-25 03:32:00');
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
(120, '#OPNAG-OW-00000109', '$2y$10$wsO6c13y0FHRAAnSr5qF6e0zxOINrfziuZkrhIFIw.TrVmmGwadN.', '103.59.73.88', 'JYOTIN PANDE', 'GIRISH CHANDRA ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Pande, Second Floor, 11 Park Side Road, Kalighat S. O, Kalighat, Kolkata, West Bengal -700026', NULL, '', '700026', NULL, NULL, '9831092611', 'imranhassi.0022@gmail.com', '1951-11-05', '298277898461', NULL, 0x[encoded data, 12246 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D/343', 'D/343/201', 'D/343/201 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal -700135', NULL, 'f', '1', '320', 'NO', '2', 'f', 9000, 'Nine Thousand ', 18000, 'Eighteen Thousand ', 0.00, 10, '2023-08-01', 11, '2024-06-30', 6, 1, 'AARCHI SINGH', 'SAROJ SINGH', 'Bhagwan Das Marwari Lane Sujaganj, Jagdishpur, Bhagalpur Bihar -812002', '812002', '2000-07-30', '8825147087', 'aarchisingh07@gmail.com', '596618275830', 'LXIPS9466G', 0x[encoded data, 14238 characters], 0x[encoded data, 12902 characters], 0x[encoded data, 12062 characters], 0x[encoded data, 10214 characters], '20452485', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-07-26 15:24:40', '2023-07-26 16:28:00');
