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
(153, '#OPNAG-OW-00000142', '$2y$10$CeugI5D9achCD.0dpePoPebExSyULWxSkcKFw2atvORfUWusRi16e', '103.59.72.61', 'PARAG DUTTA ', 'Parimal Kanti Datta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '444 Hooghly Station Road Post - Bandel, PS Chinsurah Magra Bandel Junction Chinsurah Magra Hooghly West Bengal 712123', NULL, '', '712123', NULL, NULL, '8763445052', 'imranhassi.0022@gmail.com', '1985-08-20', '951130322200', NULL, 0x[encoded data, 22014 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/85', 'A/85/303', 'A/85/303 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', NULL, 'f', '1', '320', 'NO', '3', 'f', 13000, 'Thirteen Thousand ', 26000, 'Twenty Six Thousand ', 0.00, 10, '2023-08-10', 1, '2024-07-09', 7, 1, 'ISAAC LALLAWSANHA', 'A. MALSAWMTLUANGA', 'A-54/A, Bial I, Behind Presbyterian Church, Dawrpui Vengthar, Aizawl Municipal Council Aizawl, Mizoram, 796001', '796001', '2000-09-14', '9330765540', 'isaac.xc14@gmail.com', '699665224869', 'BGWPL0665H', 0x[encoded data, 12254 characters], 0x[encoded data, 15070 characters], 0x[encoded data, 15342 characters], 0x[encoded data, 17758 characters], '20300570', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-09 19:05:30', '2023-08-09 19:38: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
(154, '#OPNAG-OW-00000143', '$2y$10$/SHw9fAyJKIcsgXfclgZheXxvibF2jNBY.17.coflQPkz9WWQB0jG', '152.58.180.190', 'PARAG DUTTA', 'Parimal Kanti Datta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '444 Hooghly Station Road Post - Bandel, PS Chinsurah Magra Bandel Junction Chinsurah Magra Hooghly West Bengal 712123', NULL, '', '712123', NULL, NULL, '8763445052', 'imranhassi.0022@gmail.com', '1985-08-20', '951130322200', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/85', 'A/85/303', 'A/85/303 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', NULL, 'f', '1', '320', 'A/85-S8 Two wheeler parking space on the ground level ', '3', 'f', 13000, 'Thirteen Thousand ', 26000, 'Twenty Six Thousand ', 0.00, 10, '2023-08-10', 11, '2024-07-09', 7, 1, 'ISAAC LALLAWSANHA ', 'A. MALSAWMTLUANGA', 'A-54/A, Bial I, Behind Presbyterian Church, Dawrpui Vengthar Aizawl Municipal Council, Aizawl Mizoram - 796001', '796001', '2000-09-14', '9330765540', 'isaac.xc14@gmail.com', '699665224869', 'BGWPL0665H', 0x[encoded data, 12254 characters], 0x[encoded data, 15070 characters], 0x[encoded data, 15342 characters], 0x[encoded data, 17758 characters], '20300570', 's', 'Service ', 'A-54/A, Bial I, Behind Presbyterian Church, Dawrpui Vengthar Aizawl Municipal Council, Aizawl Mizoram - 796001', '656375256990', 'BGWPL0665H', 'NA', 'isaac.xc14@gmail.com', '9862671972', NULL, '', '2023-08-10 10:27:45', '2023-08-10 10:57: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
(155, '#OPNAG-OW-00000144', '$2y$10$nRlItjHYVz7qxdkFQeYb7ezCV.dz8RRGR12RrnzAc29ewGTlruelW', '103.59.73.98', 'ALO CHAKRABORTY ', 'W/O: BIPLAB CHAKRABORTY ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Binayak Enclave Block -P Flat - 205 59, Kalicharan Ghosh Road, Baranagar Sinthee North 24 Parganas West Bengal - 700050', NULL, '', '700050', NULL, NULL, '9433507621', 'imranhassi.0022@gmail.com', '1959-07-06', '462827385193', NULL, 0x[encoded data, 18126 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'M', 'M/89', 'M/89/1104', 'M/89/1104 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', NULL, 'f', '2', '735', 'NO', '11', 'f', 16400, 'Sixteen Thousand Four Hundred ', 30000, 'Thirty Thousand ', 0.00, 10, '2023-08-01', 11, '2024-06-30', 7, 1, 'BISWAJIT DIXIT ', 'Badri Narayan Dixit ', 'A-214, Sector 4 Rourkela Rourkela Sundergarh Rourkela -2, Odisha, 769002', '769002', '1998-04-29', '6370360254', 'biswajitdixit7991@gmail.com', '490031752087', 'EGPPD4632A', 0x[encoded data, 12326 characters], 0x[encoded data, 17342 characters], 0x[encoded data, 16590 characters], 0x[encoded data, 10662 characters], 'EMPL516', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-10 13:00:59', '2023-08-10 13:16: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
(156, '#OPNAG-OW-00000145', '$2y$10$BHRPRV8PoatxBbEkSTeycenAJVKkSs4XXjzQ0ScQ3GakO3bUHxsWK', '103.59.73.98', 'SHIBASHIS ROY', 'SUJAN KUMAR ROY', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '27D South Sinthee Road Sinthee Kolkata West Bengal 700050', NULL, '', '700050', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1983-03-13', '575344077913', NULL, 0x[encoded data, 17942 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/43', 'A/43/104', 'A/43/104 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', NULL, 'f', '1', '320', 'A/43-S4 Two wheeler parking space on the ground level ', '1', 'f', 12500, 'Twelve Thousand Five Hundred ', 25000, 'Twenty Five Thousand ', 0.00, 10, '2023-08-10', 11, '2024-07-09', 7, 1, 'NAIBEDYA PATNAYAK ', 'Tusarkaya Pattanaik', 'Salepur Chandradeipur Salipur Cuttack Odisha 754202', '754202', '1995-05-13', '8763316937', 'pnaibedya@gmail.com', '526501829186', 'COTPP1698Q', 0x[encoded data, 14078 characters], 0x[encoded data, 15414 characters], 0x[encoded data, 15246 characters], 0x[encoded data, 12598 characters], '1965285', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-08-10 14:38:11', '2023-08-10 14:49:48');
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
(157, '#OPNAG-OW-00000146', '$2y$10$g.EFq9TtrrMf1.R1l9U4fOmN1VN6N5KDeHqkvOJh0DuijjUq3PDpa', '103.59.73.125', 'MOHAMMAD SAJID', 'Md Nuru', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '6/A, Convent Lane, Tangra, Kolkata West Bengal 700015', NULL, '', '700015', NULL, NULL, '9748187493', 'imranhassi.0022@gmail.com', '1988-02-15', '210976712623', NULL, 0x[encoded data, 28606 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D/307', 'D/307/204', 'D/307/204 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal 700135', NULL, 'f', '1', '450', 'D/307-S4 Two wheeler parking space on the ground level ', '2', 'f', 8600, 'Eight Thousand Six Hundred ', 16000, 'Sixteen Thousand ', 0.00, 10, '2023-08-01', 11, '2024-06-30', 7, 1, 'SOHINI CHAKRABORTY ', 'Shyamal Chakraborty ', 'Manikpur Ghosalpara Harinavi, Harinavi, South 24 Parganas West Bengal - 700148', '700148', '2001-11-13', '9875624406', 'sohinichakraborty1313@gmail.com', '780524732069', 'CIZPC5133M', 0x[encoded data, 23862 characters], 0x[encoded data, 23862 characters], 0x[encoded data, 15830 characters], 0x[encoded data, 24590 characters], 'NA', 's', 'Housewife ', 'Manikpur Ghosalpara Harinavi, Harinavi, South 24 Parganas West Bengal - 700148', '355892453991', 'AJLPC0783A', 'NA', 'sohinichakraborty1313@gmail.com', '6290950042', NULL, '', '2023-08-12 12:31:19', '2023-08-12 12:45:22');
