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
(30, '#OPNAG-OW-00000023', '$2y$10$Pugei1EJ3xEoysd4qeTKheQ71xDiyzHnNigTpsJcTFSNEr4QlEDUy', '45.250.247.72', 'Ananda', 'Ajoy Chakraborty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Cecilia Chapman 711-2880 Nulla St. Mankato Mississippi 96522', NULL, '', '700131', NULL, NULL, '9831496974', 'ananda.chakraborty2008@gmail.com', '1999-09-26', '654798743214', 'ASDWE9874A', 0x[encoded data, 18542 characters], 0x[encoded data, 18542 characters], 0x[encoded data, 18542 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 3, 'TATA Avenida', 'Block N', 'apa 98', 'Flat 7', 'Iris Watson\r\nP.O. Box 283 8562 Fusce Rd.\r\nFrederick Nebraska 20620', NULL, 'f', '2', '2541', 'NA', '3', 'f', 16350, 'Sixteen Thousand Three Hundred and Fifty Only ', 30000, 'Thirty Thousand ', 2563.00, 5, '2023-06-25', 5, '2023-11-24', 7, 8, 'Akash', 'Dhananjoy', 'Celeste Slater\r\n606-3727 Ullamcorper. Street\r\nRoseville NH 11523', '700142', '2001-08-03', '6547896541', 'anandamca83@gmail.com', '987465413214', 'awsde9630a', 0x[encoded data, 18542 characters], 0x[encoded data, 18542 characters], 0x[encoded data, 18542 characters], 0x[encoded data, 18542 characters], 'serv963', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-12 12:30:59', '2023-06-12 12:46:02');
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
(31, '#OPNAG-OW-00000024', '$2y$10$obx.9MwlsZDEmOhx7ypPIeXaXnxO3VpDpejdTbBJJKsEg0QRwhGku', '103.59.72.109', 'IMRAN HOSSIAN', 'NIZAM UDDIN MOLLA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'POLERHAT, KHAYERPUR, SWASTAYAN GACHI, SOUTH 24 PARGANAS  WEST BENGAL - 700135', NULL, '', '700135', NULL, NULL, '8348817467', 'IMRANHASSI@GMAIL.COM', '1996-11-22', '526926885875', 'AVVPH9735P', 0x[encoded data, 19046 characters], '', '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'A', 'A/50', 'A/50/202', 'A/50/202 SP SHUKHOBRISHTI NEW TOWN AA III KOLKATA - 700135', NULL, 'f', '1', '335', 'NO', '2', 'f', 8500, 'Eight Thousand Five Hundred ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-06-12', 11, '2024-05-11', 6, 1, 'SWETA PRADHAN', 'HIMAL PRADHAN', '15 No Line Nagrakata\r\nHope Tea Garden\r\nNagrakata\r\nNagrakata Jalpaiguri\r\nWest Bengal 735225', '735225', '2001-02-09', '8777240137', 'sahanajferdous96@gmail.com', '941235729489', 'FGMPP9210E', '', '', '', '', 'IGA 61518', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-12 13:36:07', '2023-06-12 13:54: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
(32, '#OPNAG-OW-00000025', '$2y$10$P83tmsJo5iu48z4eUrFCVON899QpI7Z0YHzXlUZmdfJf0814uuKiS', '122.163.86.114', 'Nayab Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '295/3, Ali Haider Road, Gowal Para, Titagarh, Kolkata 700119', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1998-10-26', '393656133570', 'BZBPA0397R', 0x[encoded data, 9910 characters], 0x[encoded data, 15462 characters], 0x[encoded data, 10350 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K-45', 'K-45/302', 'K-45/302, SP Shukhobrishti Housing Complex, Newtown, Kolkata, West Bengal, India 700156', NULL, 'f', '2', '385', 'K-45/6', '3', 'f', 12000, 'Twelve Thousand ', 24000, 'Twenty Four Thousand ', 0.00, 10, '2023-07-01', 11, '2024-05-31', 6, 1, 'ANANDA chakraborty', ' ABBA chakraborty', 'ARENA HOUSING COMPLEX\r\nSTREET-110\r\nBACK TO CENTAL MALL,NEWTOWN', '700156', '1976-09-26', '9831496974', 'ananda.chakraborty2008@gmail.com', '398080903020', 'bzbpa9089r', 0x[encoded data, 12190 characters], 0x[encoded data, 19286 characters], 0x[encoded data, 27654 characters], 0x[encoded data, 21558 characters], 'HIOGT789', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-13 11:59:24', '2023-06-13 12:09: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
(34, '#OPNAG-OW-00000026', '$2y$10$OVL47wi/vF4ITYE5PNAODuqp2xG.zfDVIhmn9QOQ.xIpEHo6TRjRi', '103.59.72.34', 'RAJENDRA JHUNJHUNWALA ', 'HARI PRASAD JHUNJHUNWALA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'FE-324 SALT LAKE CITY SECTOR 3, BIDHANNAGAR B MARKET KOLKATA WEST BENGAL - 700106', NULL, 'imranhassi.0022@gmail.com', '700106', NULL, NULL, '9831426066', 'hpjassociates@gmail.com', '1998-12-25', '272660737432', 'ACQPJ7600R', 0x[encoded data, 11766 characters], 0x[encoded data, 11406 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K/29', 'K/29/305', 'K/29/305 SP SHUKHOBRISHTI NEW TOWN ACTION AREA 3 KOLKATA WEST BENGAL 700135', NULL, 'f', '3', '901', 'NO', '3', 'f', 16000, '', 32000, '', 0.00, 10, '2023-06-15', 3, '2024-05-14', 6, 1, 'APARAJITA GHOSH ', 'MIHIR KANTI GHOSH ', 'AMLAPARA-1,NEAR FIRE SERVICE,BELONIA,BELONIA NAGAR PANCHAYET,SOUTH TRIPURA,TRIPURA_799155', '799155', '1998-12-25', '8787624314', 'aparajitaghosh12@gmail.com', '794667150805', 'BZOPG6842G', 0x[encoded data, 14918 characters], 0x[encoded data, 11158 characters], 0x[encoded data, 17150 characters], 0x[encoded data, 11862 characters], '55996', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-14 13:26:57', '2023-06-14 13:58:04');
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
(35, '#OPNAG-OW-00000027', '$2y$10$gE4Eb.ZTGIQevSIxJWdC2eY3AtGd284FU0IqHJbqJx.AxK6RtpBOu', '103.59.72.34', 'RAJENDRA JHUNJHUNWALA ', 'HARI PRASAD JHUNJHUNWALA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'FE-324 SALT LAKE CITY SECTOR 3, BIDHANNAGAR B MARKET KOLKATA WEST BENGAL - 700106', NULL, 'imranhassi.0022@gmail.com', '700106', NULL, NULL, '9831426066', 'hpjassociates@gmail.com', '1967-03-31', '272660737432', 'ACQPJ7600R', 0x[encoded data, 11654 characters], 0x[encoded data, 10726 characters], '', NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K/29', 'K/29/305', 'K/29/305 SP SHUKHOBRISHTI NEW TOWN ACTION AREA 3 KOLKATA WEST BENGAL 700135', NULL, 'f', '3', '901', 'NO', '3', 'f', 16000, 'Sixteen Thousand ', 32000, 'Thirty Two Thousand ', 0.00, 10, '2023-06-15', 11, '2024-05-14', 11, 1, 'APARAJITA GHOSH ', 'MIHIR KANTI GHOSH ', 'AMLAPARA-1,NEAR FIRE SERVICE,BELONIA,BELONIA NAGAR PANCHAYET,SOUTH TRIPURA,TRIPURA_799155', '799155', '1998-12-25', '8787624314', 'aparajitaghosh12@gmail.com', '794667150805', 'BZOPG6842G', 0x[encoded data, 13998 characters], 0x[encoded data, 11942 characters], 0x[encoded data, 15726 characters], '', '55996', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-14 14:37:58', '2023-06-14 14:50:47');
