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
(214, '#OPNAG-OW-00000201', '$2y$10$ktFvlLeBETVmMmirnVNpu.1Bsb0k524dM/mppOISvC2TD17EfTayu', '152.58.177.12', 'Mallika Roy', 'Sankha Subhra Roy', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Sriniketan, krishnanagar road, near lali cinema hall, Barasat, Noapara, North 24 paraganas, west bengal-700125', NULL, '', '700125', NULL, NULL, '7890232521', 'mollikaroy336@gmail.com', '1980-01-23', '843421427358', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'C', 'C219', 'C219/303', 'C219/303, SP SUKHOBRISHTI, newtown, kolkata 700135', '700135', 'f', '1', '320', 'No', '3', 'f', 12500, 'Twelve Thousand Five Hundred ', 25000, 'Twenty Five Thousand ', 0.00, 0, '2023-10-06', 11, '2024-09-05', 6, 1, 'Manish Dutta', 'S K Dutta', 'S/O Subrata Kumar Dutta, C-4, Indian Oil Colony, Jayant, post-Jayant, District-Singrauli, gopad banas, Sidhi, Madhya Pradesh-486890', '486890', '2001-10-27', '7029308257', 'manishduttacool@gmail.com', '521534789664', 'EVEPD9556F', 0x[encoded data, 35270 characters], 0x[encoded data, 35270 characters], 0x[encoded data, 23414 characters], 0x[encoded data, 26782 characters], '101432415', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-06 20:09:08', '2023-10-06 21:03:01');
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
(216, '#OPNAG-OW-00000203', '$2y$10$HtA1DajQYaEJ2H.Sx9rk0eLxxr.DlStJGNbx00iu.X78VbwhZ4jYm', '110.224.109.152', 'Gauri Sankar panda', 'Basanta Kumar panda ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Flat - B, 4th floor, Rabiroshmi Apartment, AB-11&12, samarpally (near 3no camp), krishnapur, North Paraganas, kol-700102', NULL, '', '700102', NULL, NULL, '9434655701', 'Deba1286@gmail.com', '1955-02-02', '877198492545', NULL, 0x[encoded data, 12286 characters], 0x[encoded data, 11638 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'L', '52', '0305', 'SP Sukhobrishti, Shapoorji, Action Area III, Newtown Kolkata 700135 ', '700135', 'f', '3', '690', 'L/52/08', '3', 'f', 17500, 'Seventeen Thousand Five Hundred ', 35000, 'Thirty Five Thousand ', 0.00, 0, '2023-10-08', 11, '2024-09-07', 6, 1, 'Reyazuddin khan', 'Maslehuddin khan', 'Gandhi marga, NEAR police field, Nayagarh, Odisha ', '752069', '1987-06-10', '8442843649', 'Sp.reyazuddin@gmail.com', '658964272551', 'BFEPK3064E', 0x[encoded data, 15942 characters], 0x[encoded data, 15862 characters], 0x[encoded data, 12038 characters], 0x[encoded data, 13894 characters], 'EGIL28687 ', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-06 20:35:32', '2023-10-06 21:11: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
(217, '#OPNAG-OW-00000203', '$2y$10$poPFW2CIiLOWXrYAif1Se.riAAgMnKSAsn92fP1uNhPj/QSuPdiXe', '157.40.202.239', 'Abdus Samad Sarkar', 'Late Abdul Gafur Sarkar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Ward no 17,Chakbhabani,College Para,Balurghat,Dakshin Dinajpur,West Bengal,733101', NULL, '', '700135', NULL, NULL, '9733124655', 'mostanali04@gmail.com', '1960-03-13', '497122926505', NULL, 0x[encoded data, 13190 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K45', 'K45/1302', 'K45/1302 SP Sukhobristi, New Town, Kolkata,700135', '700135', 'f', '2', '620', 'No', '13', 'f', 16000, 'Sixteen Thousand ', 32000, 'Thirty Two Thousand ', 0.00, 10, '2023-10-06', 11, '2024-09-05', 6, 2, 'Ashish Das', 'Madhu Sudan', '559, road no5, magadh colony,chandauti,Gaya,Gaya,Bihar', '823001', '1995-09-13', '7782036693', 'ashish.das131995@gmail.com', '928667334342', 'BVXPD1026Q', 0x[encoded data, 17470 characters], 0x[encoded data, 14454 characters], 0x[encoded data, 14310 characters], 0x[encoded data, 29878 characters], 'TCS/EP2023RA2605308', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-06 21:00:43', '2023-10-06 21:20:24');
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
(218, '#OPNAG-OW-00000204', '$2y$10$K4FR/i/VOpZi24LiHWEASuObuDHG/v6O.Aj5roTpCbr2kAqjDRLL2', '157.40.85.165', 'Sakti Bera', 'Lt. Narendra Nath Bera', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '20, Sashi Bhusan Dey Street, Kolkata: 700012', NULL, '', '700012', NULL, NULL, '9331867991', 'saktibera453@gmail.com', '1966-06-18', '678963943589', NULL, 0x[encoded data, 20806 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'C', '197', '304', 'SP SHUKHOBRISTI, NEWTOWN, ACTION AREA- III, KOLKATA: 700135', '700135', '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-10-06 21:46:57', '2023-10-06 21:48: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
(219, '#OPNAG-OW-00000205', '$2y$10$4ZID7DNYmmliVMoMrwnf0OJHlVSwex47/5jBw4whoJCsLIX9p/NXq', '157.40.217.127', 'Jesmin ray', 'Subrata ray', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '9, Banamali ghosal lane, P.S Behala, Kolkata,700034', NULL, 'rayalfred.02@gmail.com', '700034', NULL, NULL, '7044074609', 'rayalfred.02@gmail.com', '1955-01-16', '961033557394', NULL, 0x[encoded data, 17926 characters], 0x[encoded data, 16910 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'E ', 'E406', 'E406/204', 'E 406/204, sp shukhobrishti, Newtown, kolkata, 700135', '700135', 'f', '1', '320', 'No', '2', 'f', 9500, '', 20000, '', 0.00, 0, '2023-10-05', 11, '2024-09-04', 6, 1, 'Priyanka Kundu ', 'Utpal Kumar kundu', 'Paik para, Rammohan park, Ranaghat,Ranaghat-1,Nadia, West Bengal,741201', '741201', '1997-02-19', '9064212778', 'priyankakundu620@gmail.com', '273553917674', 'GREPK3632P', 0x[encoded data, 17574 characters], 0x[encoded data, 17574 characters], 0x[encoded data, 19014 characters], 0x[encoded data, 11886 characters], '42516', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-06 22:52:04', '2023-10-06 23:12:25');
