‰PNG  IHDRÛ¤;œˆŽIDATxÚíÜģn¤0€áŧ˙KĄ• Š)(ĻpAá‚Â… –ąĮ7†LeG{ũ§ Â§ãģĸ|ŦīØ°aÆ 6lØ°aÆ 6lØ°aÆ 6lomûķ$^ūyŋúŨØ°ag“5bÆ 6lØ°aÆ 6lØ°a{‘íŧ 6lØ°aÆ ›`›ĩįã´}HĪFkm,›mļĐûŦĶĒņŅęôŌô!Ũ ‹xÛ|'Üĸ˟;ˇE:—Ôõ9­&áļ’ļ}Ž{žv]™n&Ņ6į íhíÕ_õ÷t¨Ú Íĩ-ŌĢ¯šēZ;ú´Z$Û.žPÔÄøkíÅž)ē!§oĄĄˆ>}lŗeQfJÕTą—u Ņ–ĩō•›åچĒ×\âŨX=8ŨîRŲ†4`Vwōlž>ëÃ×ún•Gū^›ėižsŠĖ"msŲ$×uņŨiģˆ?wĄbs[mŠ6ŗK4áãįO†‰š.Ŗ4›Ū%ēЏ×/õĀßĪbëC%Šįt û‰MŸ×–– ú-lîG6ąmrz2–ôļs%ģ9Ā•s@˜šė-âkģ9 =ėæî)ÎŨõĖåâkģB5ÕËÂ×\Ãņš+͂įZsŲ˛ åĩōRnÚÂ~G§…ÉRĻ¯•CŸŠí¨É ›wIcIīén7jJ°åčhۛNCS|ėâĶj0æĒō8yīˆˇŊiHKۛÖļĐkōɈ+;Sz°ļú¨áL/ĩ­FĐ*\įÆԔË#"5¯Âmë2Üī[SÅ­ĢģÍú‹Ŗ=Šg¯În‹aķP…eÚŌ“ûî‘ŦLÛ˙ lØ°aÆ 6lØ^kãīĖąaÆ 6lØ°aÆ 6lØ°a;˙Š ļ_ÚÎØ°aÆ 6lØ°aÆ 6lØ°aÆ ļá¨ëœRĸĮÆIENDŽB` -- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 30, 2021 at 03:58 AM -- Server version: 10.3.31-MariaDB-log-cll-lve -- PHP Version: 7.3.28 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `smalgfdf_smalgfdf_dhhl_realstate` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- CREATE TABLE `accounts` ( `id` int(11) NOT NULL, `reference_id` int(11) NOT NULL, `member_id` int(11) DEFAULT NULL, `sell_id` int(11) DEFAULT NULL, `company_log` double DEFAULT NULL, `reference_log` double DEFAULT NULL, `updated_at` datetime NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `accounts` -- INSERT INTO `accounts` (`id`, `reference_id`, `member_id`, `sell_id`, `company_log`, `reference_log`, `updated_at`, `created_at`) VALUES (149, 31, 46, 156, 70000, NULL, '2021-09-19 11:04:16', '2021-09-19 11:04:16'), (150, 31, 46, 157, 70000, NULL, '2021-09-19 11:05:52', '2021-09-19 11:05:52'), (151, 31, 46, 158, 70000, NULL, '2021-09-19 11:07:46', '2021-09-19 11:07:46'), (152, 32, 47, 159, 70000, NULL, '2021-09-25 10:33:21', '2021-09-25 10:33:21'), (153, 32, 47, 160, 125000, NULL, '2021-09-25 10:56:57', '2021-09-25 10:56:57'), (154, 37, 53, 162, 100000, NULL, '2021-09-29 15:54:38', '2021-09-29 15:54:38'); -- -------------------------------------------------------- -- -- Table structure for table `banks` -- CREATE TABLE `banks` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ac_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `current_balance` double DEFAULT NULL, `after_dp_balance` double DEFAULT NULL, `after_wd_balance` double DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `banks` -- INSERT INTO `banks` (`id`, `name`, `ac_number`, `slip_no`, `current_balance`, `after_dp_balance`, `after_wd_balance`, `status`, `created_at`, `updated_at`) VALUES (17, 'Pubali Bank', '5436789065', NULL, 262000, 263000, 262000, 1, '2021-09-06 13:25:11', '2021-09-25 11:51:04'), (18, 'Jamuna Bank', '456732189', NULL, 1497000, 1498000, 1497000, 1, '2021-09-06 13:25:37', '2021-09-25 11:51:00'), (19, 'Jamuna Bank', '876549976', NULL, 380000, 505000, 380000, 0, '2021-09-25 11:51:24', '2021-09-25 12:03:24'), (20, 'Pubali Bank', '9823566789', NULL, 175000, 475000, 175000, 0, '2021-09-25 11:51:38', '2021-09-25 12:04:39'), (21, 'Dutch Bangla Bank', '121.123450.345', NULL, 12000, 80000, 12000, 0, '2021-09-29 17:51:05', '2021-09-29 18:01:00'); -- -------------------------------------------------------- -- -- Table structure for table `bank_withdraws` -- CREATE TABLE `bank_withdraws` ( `id` bigint(20) UNSIGNED NOT NULL, `bank_id` int(10) UNSIGNED NOT NULL, `amount` double NOT NULL, `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `date` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bank_withdraws` -- INSERT INTO `bank_withdraws` (`id`, `bank_id`, `amount`, `slip_no`, `status`, `date`, `created_at`, `updated_at`) VALUES (31, 19, 125000, 'ana 1272664', 0, '2021-09-11', '2021-09-25 12:03:24', '2021-09-25 12:03:24'), (32, 20, 300000, 'JCA No. 6677272664', 0, '2021-09-15', '2021-09-25 12:04:39', '2021-09-25 12:04:39'), (33, 21, 34000, '657834', 0, '2021-09-10', '2021-09-29 17:54:22', '2021-09-29 17:54:22'), (34, 21, 34000, '1254', 0, '2021-09-22', '2021-09-29 18:01:00', '2021-09-29 18:01:00'); -- -------------------------------------------------------- -- -- Table structure for table `baynas` -- CREATE TABLE `baynas` ( `id` bigint(20) UNSIGNED NOT NULL, `donor_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `land_volume` double DEFAULT NULL, `stain_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ledger` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shotok_price` double DEFAULT NULL, `total_price` double DEFAULT NULL, `reference_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_file_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dolil_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paid_amount` double DEFAULT NULL, `deu_amount` double DEFAULT NULL, `date` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `baynas` -- INSERT INTO `baynas` (`id`, `donor_name`, `land_volume`, `stain_number`, `ledger`, `shotok_price`, `total_price`, `reference_name`, `reference_file_no`, `dolil_no`, `details`, `paid_amount`, `deu_amount`, `date`, `created_at`, `updated_at`) VALUES (14, 'Ali akbar', 20, '459', '987', 80000, 1600000, 'Masum billah', '234', '34556575, 6788999, 123456', 'gfg ghgg', 75000, 1525000, '2021-08-11', '2021-09-25 10:46:41', '2021-09-25 10:46:41'), (15, 'Karim Saheb', 15, '234', '987', 100000, 1500000, 'Masum billah', '24', '34556575, 6788999', 'gjk h jh jhhh hjhhh', 122222, 1377778, '2021-06-19', '2021-09-25 10:48:10', '2021-09-25 10:48:10'), (16, 'Md. Selim', 15, NULL, '432', 85000, 1275000, 'Masum billah', '234', '123456', 'cash', 200000, 1075000, '2021-09-15', '2021-09-25 10:49:05', '2021-09-25 10:49:05'), (17, 'asd', 6, NULL, 'āĻĻā§‡āĻļā§‡ āĻ•āĻ°ā§‹āĻ¨āĻž āĻ¸āĻ‚āĻ•ā§āĻ°āĻŽāĻŖā§‡ āĻ†āĻļāĻžāĻ° āĻ–', 120000, 720000, 'Sahjalal', 'w12', 'D5667 āĻĻā§‡āĻļā§‡', NULL, 100000, 620000, '2021-09-10', '2021-09-29 20:01:47', '2021-09-29 20:01:47'); -- -------------------------------------------------------- -- -- Table structure for table `blocks` -- CREATE TABLE `blocks` ( `id` int(11) NOT NULL, `block_no` int(11) DEFAULT NULL, `title` varchar(255) NOT NULL, `booking_amount` double NOT NULL, `installment_amount` double NOT NULL, `ekkalin_amount` double NOT NULL, `status` int(11) DEFAULT NULL, `updated_at` datetime NOT NULL, `created_at` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `blocks` -- INSERT INTO `blocks` (`id`, `block_no`, `title`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `status`, `updated_at`, `created_at`) VALUES (16, 1, 'Standerd', 100000, 10, 40, 0, '2021-07-01 14:44:33', '2021-07-01 14:43:44'), (17, 2, 'Block A', 0, 0, 0, 0, '2021-07-07 16:06:31', '2021-07-07 12:33:52'), (18, 3, 'Duplex', 35000, 8, 15, 0, '2021-07-08 16:50:53', '2021-07-07 16:06:13'), (19, 4, 'Demo Block 01', 10000, 10, 40, 0, '2021-08-07 15:15:25', '2021-07-11 14:07:02'), (20, 5, 'Test Edit', 10, 6, 12, 0, '2021-09-29 15:58:32', '2021-08-28 19:16:17'), (21, 6, 'Block A-1', 20000, 5, 10, 0, '2021-09-08 05:40:30', '2021-09-08 05:39:24'), (22, 7, 'test afftab', 0, 0, 0, 0, '2021-09-29 16:37:49', '2021-09-29 16:37:49'), (23, 8, 'asd', 0, 0, 0, 0, '2021-09-29 16:38:31', '2021-09-29 16:38:31'); -- -------------------------------------------------------- -- -- Table structure for table `booking_amounts` -- CREATE TABLE `booking_amounts` ( `id` int(11) NOT NULL, `member_id` int(11) DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `sales_id` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `company_log` double DEFAULT NULL, `refference_log` double DEFAULT NULL, `due` double DEFAULT NULL, `date` text DEFAULT NULL, `image` text DEFAULT NULL, `book_no` int(11) DEFAULT NULL, `remark` text DEFAULT NULL, `money_rec` text DEFAULT NULL, `sale_no` int(11) DEFAULT NULL, `count` int(11) DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `booking_forms` -- CREATE TABLE `booking_forms` ( `id` int(11) NOT NULL, `member_id` int(11) DEFAULT NULL, `mem_signature` text DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `sale_id` int(11) DEFAULT NULL, `name` text DEFAULT NULL, `so` text DEFAULT NULL, `mother` text DEFAULT NULL, `dob` text DEFAULT NULL, `profession` text DEFAULT NULL, `religion` text DEFAULT NULL, `present_address` text DEFAULT NULL, `permanent_address` text DEFAULT NULL, `mobile` text DEFAULT NULL, `office` text DEFAULT NULL, `res` text DEFAULT NULL, `email` text DEFAULT NULL, `n_name` text DEFAULT NULL, `n_so` text DEFAULT NULL, `n_address` text DEFAULT NULL, `n_relation` text DEFAULT NULL, `nationality` text DEFAULT NULL, `n_nationality` text DEFAULT NULL, `n_dob` text DEFAULT NULL, `nominee_pic` text DEFAULT NULL, `ref` text DEFAULT NULL, `ref_signature` text DEFAULT NULL, `check_no` text DEFAULT NULL, `name_project` text DEFAULT NULL, `bank` text DEFAULT NULL, `branch` text DEFAULT NULL, `date` text DEFAULT NULL, `tk` text DEFAULT NULL, `tk_word` text DEFAULT NULL, `auth_date` text DEFAULT NULL, `app_date` text DEFAULT NULL, `down_pay` text DEFAULT NULL, `block` text DEFAULT NULL, `block_no` int(11) DEFAULT NULL, `plot_no` int(11) DEFAULT NULL, `face` varchar(191) DEFAULT NULL, `road` varchar(191) DEFAULT NULL, `plot_size` varchar(191) DEFAULT NULL, `ins` text DEFAULT NULL, `booking` int(11) DEFAULT NULL, `rate_per` double DEFAULT NULL, `total_rate` double DEFAULT NULL, `ins_no` int(11) DEFAULT NULL, `ins_am` double DEFAULT NULL, `one` text DEFAULT NULL, `file_no` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `booking_forms` -- INSERT INTO `booking_forms` (`id`, `member_id`, `mem_signature`, `serial_id`, `sale_id`, `name`, `so`, `mother`, `dob`, `profession`, `religion`, `present_address`, `permanent_address`, `mobile`, `office`, `res`, `email`, `n_name`, `n_so`, `n_address`, `n_relation`, `nationality`, `n_nationality`, `n_dob`, `nominee_pic`, `ref`, `ref_signature`, `check_no`, `name_project`, `bank`, `branch`, `date`, `tk`, `tk_word`, `auth_date`, `app_date`, `down_pay`, `block`, `block_no`, `plot_no`, `face`, `road`, `plot_size`, `ins`, `booking`, `rate_per`, `total_rate`, `ins_no`, `ins_am`, `one`, `file_no`, `created_at`, `updated_at`) VALUES (30, 46, NULL, 1, 137, 'Tom Riddle', 'Riddle', 'Riddle', '01-07-2021', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', 'No information', 'No information', 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, 'No information', 'DREAM GREEN CITY', 'No information', 'No information', 'No information', 'No information', 'No information', 'No information', 'No information', 'No information', 'Standerd', 1, NULL, 'north', '6', '10', NULL, 70000, 0, NULL, 10, 92400, 'No information', 1, '2021-08-19 18:20:42', '2021-08-23 14:09:04'), (31, 46, NULL, 1, 138, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Standerd', 1, NULL, 'north', '6', '10', NULL, 70000, 0, NULL, 10, 92400, NULL, 2, '2021-08-19 18:24:22', '2021-08-19 18:24:22'), (32, 47, NULL, 2, 139, 'Sharif Molla', 'Md. Karim', 'Kamrunnesa', '1980-07-31', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', NULL, NULL, 'sharif@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Standerd', 1, NULL, 'north', '6', '10', NULL, 70000, 0, NULL, 10, 92400, NULL, 3, '2021-08-23 07:34:34', '2021-08-23 07:34:34'), (33, 46, NULL, 1, 140, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'south', 'Main', '5', NULL, 70000, 0, NULL, 10, 42400, NULL, 4, '2021-08-23 07:35:09', '2021-08-23 07:35:09'), (34, 46, NULL, 1, 143, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'north', 'Sub-04/N-01', '5', NULL, 300, 0, NULL, 10, 49370, NULL, 7, '2021-08-23 18:11:09', '2021-08-23 18:11:09'), (35, 46, NULL, 1, 144, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Standerd', 1, NULL, 'north', '6', '10', NULL, 70000, 0, NULL, 10, 92400, NULL, 1, '2021-08-23 21:37:27', '2021-08-23 21:37:27'), (36, 46, NULL, 1, 145, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'south', 'Main', '5', NULL, 100, 0, NULL, 10, 49390, NULL, 2, '2021-08-24 06:53:29', '2021-08-24 06:53:29'), (37, 49, NULL, 4, 146, 'From new', 'From', 'From', '08-01-1997', 'Vampire', 'islam', 'From', 'From', '55876685765', 'No information', 'No information', 'from@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, 'No information', 'DREAM GREEN CITY', 'No informasdsdtion', 'Nosdas information', 'No isdasnformation', 'No informationad', 'No informationad', 'No information', 'No information', 'No informationdsds', 'Test Edit', 5, NULL, 'west', '6', '10', NULL, 70000, 0, NULL, 10, 92400, 'No informationds', 3, '2021-08-28 19:17:23', '2021-08-29 07:02:37'), (38, 46, NULL, 1, 147, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test Edit', 5, NULL, 'west', '6', '10', NULL, 70000, 0, NULL, 10, 92400, NULL, 4, '2021-08-28 19:56:35', '2021-08-28 19:56:35'), (39, 49, NULL, 4, 148, 'From new', 'From', 'From', '1997-01-08', 'Vampire', 'islam', 'From', 'From', '55876685765', NULL, NULL, 'from@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test Edit', 5, NULL, 'west', '6', '10', NULL, 1000, 0, NULL, 10, 99900, NULL, 5, '2021-08-29 20:21:54', '2021-08-29 20:21:54'), (40, 52, NULL, 7, 149, 'Saiful Islam', 'Md. Julhas', 'Nazma Begum', '25-05-1970', 'Business', 'Islam', 'tikatuli,Dhaka-1212', 'tikatuli,Dhaka-1212', '01927718260', 'No information', 'No information', 'saiful@gmail.com', NULL, NULL, NULL, NULL, 'Banghladeshi', NULL, NULL, NULL, NULL, NULL, NULL, 'DREAM GREEN CITY', NULL, 'No information', NULL, NULL, NULL, 'No information', 'No information', 'No information', 'Block A-1', 6, NULL, 'north', 'Sub-01/ S-01', '3', NULL, 50000, 0, NULL, 5, 290000, 'No information', 6, '2021-09-08 06:39:20', '2021-09-08 06:41:15'), (41, 52, NULL, 7, 150, 'Saiful Islam', 'Md. Julhas', 'Nazma Begum', '25-05-1970', 'Business', 'Islam', 'tikatuli,Dhaka-1212', 'tikatuli,Dhaka-1212', '01927718260', NULL, NULL, 'saiful@gmail.com', NULL, NULL, NULL, NULL, 'Banghladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A-1', 6, NULL, 'north', 'Sub-01/ S-01', '3', NULL, 1350000, 0, NULL, NULL, 0, NULL, 7, '2021-09-08 06:44:22', '2021-09-08 06:44:22'), (42, 50, NULL, 5, 151, 'Demo member 1', 'bggv', 'Riddle', '1984-12-12', 'job', 'islam', 'axassdwd', 'axassdwd', '555', NULL, NULL, 'demotkt@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Duplex', 3, NULL, 'west', 'Main', '5', NULL, 70000, 0, NULL, 10, 42400, NULL, 8, '2021-09-11 12:00:01', '2021-09-11 12:00:01'), (43, 50, NULL, 5, 152, 'Demo member 1', 'bggv', 'Riddle', '1984-12-12', 'job', 'islam', 'axassdwd', 'axassdwd', '555', NULL, NULL, 'demotkt@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Duplex', 3, NULL, 'west', 'Main', '5', NULL, 1000, 0, NULL, 10, 49900, NULL, 9, '2021-09-11 12:02:42', '2021-09-11 12:02:42'), (44, 50, NULL, 5, 153, 'Demo member 1', 'bggv', 'Riddle', '1984-12-12', 'job', 'islam', 'axassdwd', 'axassdwd', '555', NULL, NULL, 'demotkt@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'north', 'Sub-04/N-01', '5', NULL, 1000, 0, NULL, 10, 49900, NULL, 10, '2021-09-11 13:57:20', '2021-09-11 13:57:20'), (45, 50, NULL, 5, 154, 'Demo member 1', 'bggv', 'Riddle', '1984-12-12', 'job', 'islam', 'axassdwd', 'axassdwd', '555', NULL, NULL, 'demotkt@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'north', 'Sub-04/N-01', '5', NULL, 500000, 0, NULL, NULL, 0, NULL, 11, '2021-09-11 15:46:49', '2021-09-11 15:46:49'), (46, 47, NULL, 2, 155, 'Sharif Molla', 'Md. Karim', 'Kamrunnesa', '1980-07-31', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', NULL, NULL, 'sharif@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'south', 'Main', '5', NULL, 100, 0, NULL, 10, 49390, NULL, 12, '2021-09-18 19:05:38', '2021-09-18 19:05:38'), (47, 46, NULL, 1, 156, 'Tom Riddleeee', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', NULL, 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tomii@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'north', 'Sub-04/N-01', '5', NULL, 70000, 0, NULL, 10, 42400, NULL, 1, '2021-09-19 11:04:16', '2021-09-19 11:04:16'), (48, 46, NULL, 1, 157, 'Tom Riddleeee', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', NULL, 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tomii@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'north', 'Sub-04/N-01', '5', NULL, 70000, 0, NULL, 10, 42400, NULL, 1, '2021-09-19 11:05:52', '2021-09-19 11:05:52'), (49, 46, NULL, 1, 158, 'Tom Riddleeee', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', NULL, 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tomii@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'north', 'Sub-04/N-01', '5', NULL, 70000, 0, NULL, 10, 42400, NULL, 1, '2021-09-19 11:07:46', '2021-09-19 11:07:46'), (50, 47, NULL, 2, 159, 'Sharif Molla', 'Md. Karim', 'Kamrunnesa', '1980-07-31', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', NULL, NULL, 'sharif@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A-1', 6, NULL, 'north', 'Sub-01/ S-01', '3', NULL, 70000, 0, NULL, 96, 14895.83, NULL, 4, '2021-09-25 10:33:21', '2021-09-25 10:33:21'), (51, 47, NULL, 2, 160, 'Sharif Molla', 'Md. Karim', 'Kamrunnesa', '1980-07-31', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', NULL, NULL, 'sharif@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'south', 'Main', '5', NULL, 125000, 0, NULL, 96, 24739.58, NULL, 5, '2021-09-25 10:56:57', '2021-09-25 10:56:57'), (52, 53, NULL, 8, 162, 'golam rabbany', 'XYZ', 'Mahfuza Nasrin', '10-09-2021', 'Business', 'Islam', 'Dilkusha C/A', 'Dilkusha C/A', '01919774996', NULL, NULL, 'mwgrabbany100@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'north', 'Sub-04/N-01', '5', NULL, 100000, 0, NULL, 5, 480000, NULL, 7, '2021-09-29 15:54:38', '2021-09-29 15:54:38'); -- -------------------------------------------------------- -- -- Table structure for table `commision_plans` -- CREATE TABLE `commision_plans` ( `id` int(11) NOT NULL, `booking_amount` double NOT NULL, `installment_amount` double NOT NULL, `ekkalin_amount` double NOT NULL, `block_id` int(11) NOT NULL, `block_title` varchar(255) NOT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `commision_plans` -- INSERT INTO `commision_plans` (`id`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `block_id`, `block_title`, `status`, `created_at`, `updated_at`) VALUES (46, 100000, 20, 40, 15, 'Block A', 1, '2021-06-20 13:57:49', '2021-07-01 18:44:17'), (47, 100001, 10, 40, 16, 'Standerd', 0, '2021-07-01 18:44:33', '2021-07-01 18:44:33'), (48, 30000, 5, 10, 17, 'Block A', 0, '2021-07-07 16:34:55', '2021-07-07 19:46:58'), (49, 35000, 8, 15, 18, 'Duplex', 0, '2021-07-07 20:07:56', '2021-07-08 20:50:53'), (50, 20000, 10, 40, 19, 'Demo Block 01', 0, '2021-07-11 08:11:45', '2021-07-11 10:25:15'), (51, 10000, 10, 40, 19, 'Demo Block 01', 0, '2021-08-07 09:15:25', '2021-08-07 09:15:25'), (52, 20010, 12, 50, 20, 'Test Edit', 0, '2021-08-28 13:16:51', '2021-08-28 13:55:06'), (53, 20000, 5, 10, 21, 'Block A-1', 0, '2021-09-08 09:40:29', '2021-09-08 09:40:29'), (54, 10, 6, 12, 20, 'Test Edit', 0, '2021-09-29 19:58:31', '2021-09-29 19:58:31'); -- -------------------------------------------------------- -- -- Table structure for table `companies` -- CREATE TABLE `companies` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `address` text COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `quote` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `companies` -- INSERT INTO `companies` (`id`, `name`, `mobile`, `address`, `logo`, `email`, `quote`, `created_at`, `updated_at`) VALUES (1, 'DREAM HEAVEN HOUSING LTD.', 'Tel: 02-9512433, Mobile: 01915-618117', '5B-1,Ittefaq Bhaban,1,R.K Mission Road,Dhaka-1203', 'logo/hR4jJcJWHE5TIUovnrgFsE2JwBe81LYVJJxrJOws.png', 'dreamgreencity@gmail.com www.dhhl.ltd', '5B-1 ittefaq Bhaban, 1 R.K Mission Road, Wari, Dhaka - 1203', '2020-03-03 12:19:38', '2021-09-06 12:34:46'); -- -------------------------------------------------------- -- -- Table structure for table `custom_bookings` -- CREATE TABLE `custom_bookings` ( `id` int(11) NOT NULL, `image` text DEFAULT NULL, `amount` double DEFAULT NULL, `remark` text DEFAULT NULL, `money_rec` text DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `member_id` int(11) DEFAULT NULL, `sales_id` int(11) DEFAULT NULL, `date` text DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `due` double DEFAULT NULL, `company_log` double DEFAULT NULL, `refference_log` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `custom_installments` -- CREATE TABLE `custom_installments` ( `id` bigint(11) NOT NULL, `amount` double DEFAULT NULL, `remark` text DEFAULT NULL, `via` text DEFAULT NULL, `bank_name` text DEFAULT NULL, `image` text DEFAULT NULL, `account_no` text DEFAULT NULL, `money_rec` text DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL, `member_id` int(11) NOT NULL, `saled_id` int(11) DEFAULT NULL, `date` text DEFAULT NULL, `serial_id` int(11) NOT NULL, `reference_id` int(11) NOT NULL, `due` double NOT NULL, `ins_no` int(11) DEFAULT NULL, `company_log` double DEFAULT NULL, `refference_log` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `demo_installments` -- CREATE TABLE `demo_installments` ( `id` bigint(20) NOT NULL, `member_id` int(11) DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `sales_id` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `company_log` double DEFAULT NULL, `refference_log` double DEFAULT NULL, `due` double DEFAULT NULL, `date` text DEFAULT NULL, `ins_no` int(11) DEFAULT NULL, `remark` text DEFAULT NULL, `via` text DEFAULT NULL, `bank_name` text DEFAULT NULL, `image` text DEFAULT NULL, `account_no` text DEFAULT NULL, `money_rec` text DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `deposits` -- CREATE TABLE `deposits` ( `id` bigint(20) UNSIGNED NOT NULL, `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_id` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `status` int(11) DEFAULT NULL, `date` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `deposits` -- INSERT INTO `deposits` (`id`, `slip_no`, `bank_id`, `amount`, `status`, `date`, `created_at`, `updated_at`) VALUES (35, '1', 19, 50000, 0, '2021-08-07', '2021-09-25 11:55:43', '2021-09-25 11:55:43'), (36, '2', 20, 25000, 0, '2021-07-13', '2021-09-25 11:56:55', '2021-09-25 11:56:55'), (37, '17', 19, 125000, 0, '2021-09-01', '2021-09-25 11:58:20', '2021-09-25 11:58:20'), (38, 'rttyy6777', 20, 450000, 0, '2021-12-04', '2021-09-25 11:59:10', '2021-09-25 11:59:10'), (39, '656', 19, 30000, 0, '2021-10-21', '2021-09-25 11:59:56', '2021-09-25 11:59:56'), (40, '23344', 19, 300000, 0, '2021-09-18', '2021-09-25 12:00:27', '2021-09-25 12:00:27'), (41, '657834', 21, 80000, 0, '2021-09-02', '2021-09-29 17:53:06', '2021-09-29 17:53:06'); -- -------------------------------------------------------- -- -- Table structure for table `expences` -- CREATE TABLE `expences` ( `id` bigint(20) UNSIGNED NOT NULL, `expence_head_id` int(10) UNSIGNED NOT NULL, `date` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` double DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `expences` -- INSERT INTO `expences` (`id`, `expence_head_id`, `date`, `description`, `note`, `amount`, `isDelete`, `created_at`, `updated_at`) VALUES (30, 20, '2021-06-01', 'Dhaka to Comilla', 'By Bus', 1200, NULL, '2021-09-25 12:14:08', '2021-09-25 12:14:08'), (31, 20, '2021-06-22', 'bdhbdb gd ddghdh', 'by cng', 500, NULL, '2021-09-25 12:14:47', '2021-09-25 12:14:47'), (32, 20, '2021-09-15', 'fgfg ggg yhy', 'tikatulo to gulshan', 220, NULL, '2021-09-25 12:15:38', '2021-09-25 12:15:38'), (33, 19, '2021-09-01', 'bscuit', 'fgrgb rfgg gr', 620, NULL, '2021-09-25 12:16:23', '2021-09-25 12:16:23'), (34, 4, '2021-08-06', 'dvdv dfef sss', 'fgghtht', 20000, NULL, '2021-09-25 12:19:27', '2021-09-25 12:19:27'), (35, 5, '2021-09-17', 'dfggfg hghh dffd', 'ghghgjyytyhh', 25000, NULL, '2021-09-25 12:22:02', '2021-09-25 12:22:02'), (36, 4, '2021-09-17', 'fh hghgh ghgh', 'gfghg ghfgf', 120000, NULL, '2021-09-25 12:24:37', '2021-09-25 12:24:37'); -- -------------------------------------------------------- -- -- Table structure for table `expence_heads` -- CREATE TABLE `expence_heads` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `expence_heads` -- INSERT INTO `expence_heads` (`id`, `name`, `slug`, `isDelete`, `created_at`, `updated_at`) VALUES (13, 'Hermione Granger', 'hermione-granger', 1, '2021-06-21 12:07:35', '2021-06-21 12:07:40'), (4, 'Land purchaseew', 'land-purchaseew', 0, '2021-03-11 15:53:30', '2021-06-21 12:07:48'), (5, 'Comission', 'comission', 0, '2021-03-21 12:28:28', '2021-03-21 12:28:28'), (6, 'interest', 'interest', 0, '2021-03-21 13:25:40', '2021-03-21 13:25:40'), (7, 'Vechile Gas', 'vechile-gas', 0, '2021-03-22 12:18:06', '2021-03-22 12:18:06'), (8, 'Office Mobile Bill', 'office-mobile-bill', 0, '2021-03-22 12:24:23', '2021-03-22 12:24:23'), (10, 'Land Purchase', 'land-purchase', 0, '2021-06-07 10:53:25', '2021-06-07 10:53:25'), (11, 'Land Purchase File No. 19 Investor name: Ahmed Loan - 500000', 'land-purchase-file-no-19-investor-name-ahmed-loan-500000', 0, '2021-06-07 13:30:42', '2021-06-07 13:30:42'), (12, 'Land Purchase File No. 19 Marketer Commission - 62500', 'land-purchase-file-no-19-marketer-commission-62500', 0, '2021-06-07 13:33:09', '2021-06-07 13:33:09'), (14, 'Angle', 'angle', 0, '2021-08-23 13:55:52', '2021-08-23 13:55:52'), (15, 'Vehicle Gas + Toll +Parking', 'vehicle-gas-toll-parking', 0, '2021-09-06 14:16:51', '2021-09-06 14:16:51'), (16, 'Land', 'land', 1, '2021-09-06 14:17:33', '2021-09-06 14:17:42'), (17, 'Land Purchase Bayna-Abu Yusuf Gong', 'land-purchase-bayna-abu-yusuf-gong', 0, '2021-09-06 14:18:29', '2021-09-06 14:18:29'), (18, 'Office Maintenance', 'office-maintenance', 0, '2021-09-06 14:18:57', '2021-09-06 14:18:57'), (19, 'Site Office Entertainment', 'site-office-entertainment', 0, '2021-09-06 14:19:16', '2021-09-06 14:19:16'), (20, 'Conveyance', 'conveyance', 0, '2021-09-06 14:19:36', '2021-09-06 14:19:36'); -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `id` int(11) NOT NULL, `name` text NOT NULL, `status` int(11) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `groups` -- INSERT INTO `groups` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES (1, 'abc', 0, '2021-09-03 18:45:52', '2021-09-03 18:45:52'), (2, 'dfg', 1, '2021-09-03 18:48:20', '2021-09-03 18:48:30'), (3, 'EFG', 0, '2021-09-03 20:10:19', '2021-09-03 20:10:19'), (4, 'Group 1', 0, '2021-09-04 09:29:41', '2021-09-04 09:29:41'), (5, 'Admin', 0, '2021-09-06 09:37:52', '2021-09-06 09:37:52'), (6, 'All Directors', 0, '2021-09-09 07:45:45', '2021-09-09 07:45:45'), (7, 'A', 0, '2021-09-25 07:00:35', '2021-09-25 07:00:35'); -- -------------------------------------------------------- -- -- Table structure for table `group_members` -- CREATE TABLE `group_members` ( `id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `group_name` text DEFAULT NULL, `member_name` text NOT NULL, `mobile` text NOT NULL, `status` int(11) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `group_members` -- INSERT INTO `group_members` (`id`, `group_id`, `group_name`, `member_name`, `mobile`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'abc', 'aaa', '43334234', 0, '2021-09-03 19:20:45', '2021-09-03 19:20:45'), (4, 4, NULL, 'member 2', '01648558178', 1, '2021-09-04 09:30:53', '2021-09-04 09:40:03'), (6, 5, 'Admin', 'Golam Rabbany', '01919774996', 0, '2021-09-06 09:39:12', '2021-09-06 09:39:12'), (7, 5, 'Admin', 'Mohammad ali', '01915618117', 0, '2021-09-06 09:40:27', '2021-09-06 09:40:27'), (8, 5, 'Admin', 'Rahat', '01684801240', 0, '2021-09-06 09:41:37', '2021-09-06 09:41:37'), (9, 5, 'Admin', 'Ahmed', '01712869532', 0, '2021-09-06 09:42:38', '2021-09-06 09:42:38'), (10, 5, 'Admin', 'Musanna Vai', '01973018941', 0, '2021-09-06 10:21:50', '2021-09-06 10:21:50'), (11, 5, 'Admin', 'Saiful Islam', '01711133043', 0, '2021-09-06 10:23:04', '2021-09-06 10:23:04'), (12, 5, 'Admin', 'Mamun', '01715653453', 0, '2021-09-06 10:23:46', '2021-09-06 10:23:46'), (13, 5, 'Admin', 'Masum billah', '01933946254', 0, '2021-09-06 10:37:03', '2021-09-06 10:37:03'), (15, 6, 'All Directors', 'Mohammad Ali', '01915618117', 0, '2021-09-09 07:50:39', '2021-09-09 07:50:39'), (16, 6, 'All Directors', 'Md. Abdul Haque Molla', '01711221031', 0, '2021-09-09 07:51:46', '2021-09-09 07:51:46'), (17, 6, 'All Directors', 'Md. Shah Alam', '01817106462', 0, '2021-09-09 07:52:19', '2021-09-09 07:52:19'), (18, 6, 'All Directors', 'Md. Saiful Islam', '01711133043', 0, '2021-09-09 07:53:09', '2021-09-09 07:53:09'), (19, 6, 'All Directors', 'Nasir Bin Jalal', '01711374795', 1, '2021-09-09 07:54:00', '2021-09-09 10:04:18'), (20, 6, 'All Directors', 'A.H.M Momenur Rahman', '01937404817', 0, '2021-09-09 07:55:01', '2021-09-09 07:55:01'), (21, 6, 'All Directors', 'Ahammad Ali', '01712869532', 0, '2021-09-09 07:55:31', '2021-09-09 07:55:31'), (22, 6, 'All Directors', 'Md. Nizam Uddin', '01731946864', 1, '2021-09-09 07:56:06', '2021-09-09 10:04:28'), (23, 6, 'All Directors', 'Syed Shahria Habib', '01717055220', 0, '2021-09-09 07:57:33', '2021-09-09 07:57:33'), (24, 6, 'All Directors', 'Riazul Haque', '01715688904', 0, '2021-09-09 07:58:25', '2021-09-09 07:58:25'), (25, 6, 'All Directors', 'Mawlana Masum Billah', '01933946254', 0, '2021-09-09 07:59:58', '2021-09-09 07:59:58'), (26, 6, 'All Directors', 'Md. Hossain', '01733388327', 0, '2021-09-09 08:08:22', '2021-09-09 08:08:22'), (27, 6, 'All Directors', 'Syed Hasan Musanna', '01973018941', 0, '2021-09-09 08:09:04', '2021-09-09 08:09:04'), (28, 6, 'All Directors', 'Hossain Howlader', '01681700113', 0, '2021-09-09 08:09:40', '2021-09-09 08:09:40'), (29, 6, 'All Directors', 'Md. Yakub Mollah', '01920790325', 0, '2021-09-09 08:10:17', '2021-09-09 08:10:17'), (30, 6, 'All Directors', 'Md. Faysal Talukder', '01774445924', 0, '2021-09-09 08:10:52', '2021-09-09 08:10:52'), (31, 6, 'All Directors', 'D.M Samsuddin', '01684242988', 0, '2021-09-09 08:11:21', '2021-09-09 08:11:21'), (32, 6, 'All Directors', 'Md. Selim', '01727393632', 0, '2021-09-09 08:11:45', '2021-09-09 08:11:45'), (33, 6, 'All Directors', 'Md. Fazal Talukder', '01714387062', 0, '2021-09-09 08:12:25', '2021-09-09 08:12:25'), (34, 6, 'All Directors', 'Abul Kalam Bhuiyan', '01711627231', 0, '2021-09-09 08:13:19', '2021-09-09 08:13:19'), (35, 6, 'All Directors', 'Arif Khan Regan', '01711162433', 0, '2021-09-09 08:14:12', '2021-09-09 08:14:12'), (36, 6, 'All Directors', 'Md. Moniruzzaman', '01714300811', 1, '2021-09-09 08:15:33', '2021-09-09 10:04:54'), (37, 6, 'All Directors', 'Md. Rasel Iqbal', '01715107531', 0, '2021-09-09 08:16:12', '2021-09-09 08:16:12'), (38, 6, 'All Directors', 'Arifa Jahan Tani (Zahir Sir)', '01712986538', 0, '2021-09-09 08:17:09', '2021-09-09 08:17:09'), (39, 6, 'All Directors', 'Md. Abdus Salam', '01712087567', 0, '2021-09-09 08:17:45', '2021-09-09 08:17:45'), (40, 6, 'All Directors', 'Md. Alim Khan', '01915888765', 1, '2021-09-09 08:18:15', '2021-09-09 10:05:09'), (41, 6, 'All Directors', 'Md. Abdur Rahim', '01730720897', 1, '2021-09-09 08:19:29', '2021-09-09 10:05:17'); -- -------------------------------------------------------- -- -- Table structure for table `group_msgs` -- CREATE TABLE `group_msgs` ( `id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `sms` text NOT NULL, `status` int(11) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `group_msgs` -- INSERT INTO `group_msgs` (`id`, `group_id`, `sms`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'gdgdgd', 0, '2021-09-03 20:10:51', '2021-09-03 20:10:51'), (2, 1, 'gdgdgd', 1, '2021-09-03 20:11:13', '2021-09-03 20:12:34'), (3, 1, 'aaaaaaaaaaaaaaaaaaaaaaa', 1, '2021-09-03 20:13:21', '2021-09-03 20:14:04'), (4, 1, 'aaaaaaaaaaaaaaaaaaaaaaa', 0, '2021-09-03 20:13:33', '2021-09-03 20:13:33'), (5, 4, 'uuuuuuuuuszxcxcxc', 0, '2021-09-03 20:14:24', '2021-09-10 16:42:21'), (6, 4, 'group', 1, '2021-09-04 09:31:26', '2021-09-04 09:40:27'), (7, 1, 'abc grp', 1, '2021-09-04 09:32:42', '2021-09-04 09:40:23'), (8, 5, 'āĻ†āĻŽāĻžāĻĻā§‡āĻ° āĻ—ā§ā§°āĻžāĻŽ - āĻŦāĻžāĻ‚āĻ˛āĻž āĻ°āĻšāĻ¨āĻž, Please check your software', 0, '2021-09-06 09:47:12', '2021-09-06 09:47:12'), (9, 5, 'āĻ†āĻĒāĻ¨āĻžāĻ° āĻ•ā§‹āĻŽā§āĻĒāĻžāĻ¨āĻŋāĻ° āĻ“āĻ¯āĻŧā§‡āĻŦāĻ¸āĻžāĻ‡āĻŸ āĻāĻŦāĻ‚ āĻ¸āĻĢā§āĻŸāĻ“āĻ¯āĻŧā§āĻ¯āĻžāĻ° āĻšā§‡āĻ• āĻ•āĻ°ā§āĻ¨āĨ¤ āĻāĻŦāĻ‚ āĻ†āĻŽāĻžāĻ•ā§‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ›āĻŦāĻŋ mwgrabbany100@gmail.com āĻ āĻĻāĻŋāĻ¨āĨ¤\r\nāĻ“āĻ¯āĻŧā§‡āĻŦāĻ¸āĻžāĻ‡āĻŸ: www.dhhl.ltd\r\nāĻ‡āĻ†āĻ°āĻĒāĻŋ āĻāĻŦāĻ‚ āĻŽā§āĻ¯āĻžāĻ¸ā§‡āĻœ āĻ¸āĻŋāĻ¸ā§āĻŸā§‡āĻŽ āĻ¸āĻš āĻ¸āĻĢā§āĻŸāĻ“āĻ¯āĻŧā§āĻ¯āĻžāĻ°:\r\nhttps://soft.dhhl.ltd\r\nāĻĒā§āĻ°āĻļāĻžāĻ¸āĻ•: dreamgreencity@gmail.com\r\nāĻĒāĻžāĻ¸: 123456', 0, '2021-09-06 10:30:18', '2021-09-06 10:30:18'), (10, 5, 'You are a Great Leader āĻāĻŦāĻ‚ āĻ†āĻŽāĻžāĻ•ā§‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ›āĻŦāĻŋ mwgrabbany100@gmail.com āĻ āĻĻāĻŋāĻ¨āĨ¤ \r\nāĻ“āĻ¯āĻŧā§‡āĻŦāĻ¸āĻžāĻ‡āĻŸ: www.dhhl.ltd \r\nāĻ‡āĻ†āĻ°āĻĒāĻŋ āĻāĻŦāĻ‚ āĻŽā§āĻ¯āĻžāĻ¸ā§‡āĻœ āĻ¸āĻŋāĻ¸ā§āĻŸā§‡āĻŽ āĻ¸āĻš āĻ¸āĻĢā§āĻŸāĻ“āĻ¯āĻŧā§āĻ¯āĻžāĻ°: https://soft.dhhl.ltd \r\nadmin login: dreamgreencity@gmail.com \r\nPassword: 123456', 0, '2021-09-06 10:40:01', '2021-09-06 10:40:01'), (11, 6, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:09:58', '2021-09-09 10:09:58'); -- -------------------------------------------------------- -- -- Table structure for table `incomes` -- CREATE TABLE `incomes` ( `id` int(11) NOT NULL, `income_head_id` int(11) DEFAULT NULL, `date` text DEFAULT NULL, `description` text DEFAULT NULL, `note` text DEFAULT NULL, `amount` double DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `income_heads` -- CREATE TABLE `income_heads` ( `id` int(11) NOT NULL, `name` text DEFAULT NULL, `slug` text DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `income_heads` -- INSERT INTO `income_heads` (`id`, `name`, `slug`, `isDelete`, `created_at`, `updated_at`) VALUES (1, 'The vinchissd dddds', 'the-vinchissd-dddds', 0, '2021-06-21 10:09:35', '2021-06-21 18:46:02'), (2, 'asas', 'asas', 1, '2021-06-21 10:09:41', '2021-06-21 10:14:56'), (3, 'Demon Salvator', 'demon-salvator', 1, '2021-06-21 17:56:25', '2021-06-21 18:07:10'), (4, 'The vinchi', 'the-vinchi', 1, '2021-06-21 18:08:29', '2021-06-21 18:08:36'), (5, 'Hermione Granger', 'hermione-granger', 1, '2021-06-21 18:08:39', '2021-09-06 10:42:11'), (6, 'BOOKING', 'booking', 0, '2021-07-06 16:56:00', '2021-07-06 16:56:00'), (7, 'Installment', 'installment', 0, '2021-07-06 16:56:22', '2021-07-06 16:56:22'), (8, 'capital', 'capital', 0, '2021-07-08 17:11:45', '2021-07-08 17:11:45'), (9, 'Commission Return', 'commission-return', 1, '2021-07-08 17:12:41', '2021-09-06 10:41:33'), (10, 'loan received', 'loan-received', 0, '2021-07-08 17:13:06', '2021-07-08 17:13:06'), (11, 'Khaled', 'khaled', 0, '2021-09-08 07:06:04', '2021-09-08 07:06:04'); -- -------------------------------------------------------- -- -- Table structure for table `installments` -- CREATE TABLE `installments` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` int(10) UNSIGNED NOT NULL, `serial_id` int(11) DEFAULT NULL, `reference_id` int(11) NOT NULL, `sales_id` int(10) UNSIGNED NOT NULL, `amount` double DEFAULT NULL, `company_log` double UNSIGNED DEFAULT NULL, `refference_log` double UNSIGNED DEFAULT NULL, `due` double DEFAULT NULL, `date` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ins_no` int(11) DEFAULT NULL, `remark` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `money_rec` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `updated_at` date DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `land_purchases` -- CREATE TABLE `land_purchases` ( `id` bigint(20) UNSIGNED NOT NULL, `date` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_file_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dolil_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rs_dag` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `land_poriman` double DEFAULT NULL, `commision_percentage` double DEFAULT NULL, `investor_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `investor_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `investor_total_invest` double DEFAULT NULL, `total_commision` double DEFAULT NULL, `investor_interest` double DEFAULT NULL, `investor_total_interest` double DEFAULT NULL, `investor_total_invest_1` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `registri_amount` double DEFAULT NULL, `total_fee` double DEFAULT NULL, `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shotok_price` double DEFAULT NULL, `total_price` double DEFAULT NULL, `paid_amount` double DEFAULT NULL, `deu_amount` double DEFAULT NULL, `ledger` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `land_purchases` -- INSERT INTO `land_purchases` (`id`, `date`, `owner_name`, `reference_name`, `reference_file_no`, `dolil_no`, `rs_dag`, `land_poriman`, `commision_percentage`, `investor_name`, `investor_number`, `investor_total_invest`, `total_commision`, `investor_interest`, `investor_total_interest`, `investor_total_invest_1`, `registri_amount`, `total_fee`, `details`, `shotok_price`, `total_price`, `paid_amount`, `deu_amount`, `ledger`, `status`, `created_at`, `updated_at`) VALUES (25, '2021-06-17', 'sdad', 'Masum billah', '20', '3455', '4567', 12, 5000, 'Abdur rahim', '01919774996', 300000, 60000, 5000, 30000, '300000', 12390, 702390, NULL, 50000, 600000, 200000, 502390, '315', NULL, '2021-09-25 10:26:20', '2021-09-25 10:29:36'), (26, '2021-08-26', 'sajeda Gong', 'Masum billah', '27', '123456', '301-309, 338-341', 6, 5000, 'Mohammad Ali', '01919774996', 480000, 30000, 5000, 30000, '480000', 6500, 546500, NULL, 80000, 480000, 546500, 0, '987', NULL, '2021-09-25 10:32:57', '2021-09-25 10:32:57'), (27, '2021-08-05', 'Abbas Ali', 'Masum billah', '24', '3456', '1234', 12.5, 5000, 'Mohammad Ali', '01919774996', 500000, 62500, 5000, 50000, '500000', 10000, 747500, 'cash', 50000, 625000, 747500, 0, '432', NULL, '2021-09-25 10:35:10', '2021-09-25 10:35:10'), (28, '2021-09-26', 'Robin Majumder Gong', 'Masum billah', '30', '9645', '875', 6.5, 5000, 'Mohammad Ali', '01919774996', 425000, 32500, 5000, 17000, '425000', 6532, 868532, NULL, 125000, 812500, 868532, 0, '465', NULL, '2021-09-25 10:37:14', '2021-09-25 10:37:14'), (29, '2021-06-09', 'sdad', 'Masum billah', '17', '3456', '55767', 12, 5000, 'Mohammad Ali', '01919774996', 500000, 60000, 5000, 20000, '500000', 39411, 1619411, NULL, 125000, 1500000, 234233, 1385178, '432', NULL, '2021-09-25 10:45:21', '2021-09-25 10:45:21'), (30, '2021-09-11', 'Rokon', 'Sahjalal', 'w12', 'D5667 āĻĻā§‡āĻļā§‡', 'kjg7yiuh', 12.56, 4500, 'ahmed-50000 | Forkan-300000', '01919774996', 300000, 56520, 5000, 12500, '350000', 34000, 1610220, 'valo', 120000, 1507200, 100000, 1510220, 'āĻĻā§‡āĻļā§‡ āĻ•āĻ°ā§‹āĻ¨āĻž āĻ¸āĻ‚āĻ•ā§āĻ°āĻŽāĻŖā§‡ āĻ†āĻļāĻžāĻ° āĻ–', NULL, '2021-09-29 18:10:59', '2021-09-29 18:10:59'); -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birthday` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nid` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `signature_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `serial_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_id` int(10) UNSIGNED NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `members` -- INSERT INTO `members` (`id`, `name`, `hus_father`, `nationality`, `birthday`, `mother`, `profession`, `religion`, `present_address`, `permanent_address`, `mobile`, `nid`, `email`, `created_at`, `updated_at`, `picture`, `signature_image`, `serial_id`, `reference_id`, `password`) VALUES (47, 'Sharif Molla', 'Md. Karim', 'Bangladeshi', '1980-07-31', 'Kamrunnesa', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', 'B765x4338', 'sharif@gmail.com', '2021-07-07 16:20:05', '2021-07-07 16:20:05', 'members/recniIJhDQYaY8RyYerzAEld7Yit3qYcwksr8SyV.jpeg', 'members/ektefSAQolTk90F4fJLWAbfllHR83nNgqUTdpSzH.jpeg', '000002', 32, '123456'), (46, 'Tom Riddleeee', 'Riddle', 'American', '2021-07-01', 'Riddle', 'Wizard', NULL, 'Hogwarts', 'Hogwarts', '55876685765', 'cdcds 3333', 'tomii@gmail.com', '2021-07-01 18:43:17', '2021-08-29 13:15:28', 'members/80ybyAFk6WFIKsLUOIQoxlZv29vkv6DhMDen0TAK.jpeg', 'members/5Kmu6wmqqbdBMqGLldtndDbf9KlvUzANVSQVNAaq.jpeg', '000001', 31, '123456'), (48, 'karim', 'gfgfggfg', 'Bangladeshi', '1984-01-02', 'fdfdf', 'Business', 'islam', 'aww23 332e9gg,ff fgfg', 'aww23 332e9gg,ff fgfg', '01521125086', '3433344225455', 'karim@gmail.com', '2021-07-07 20:01:59', '2021-07-07 20:01:59', 'members/CqH7fqYEobPpsp0bUv36RmMRlkPf5DWVKFIcwgGp.jpeg', 'members/YpyQoWXuaCZ2G6OYSl19FHuk3pK103nb1vxbr9eC.jpeg', '000003', 32, '123456'), (49, 'From new', 'From', 'American', '1997-01-08', 'From', 'Vampire', 'islam', 'From', 'From', '55876685765', 'cdcds 3333', 'from@gmail.com', '2021-07-11 08:14:47', '2021-07-11 08:14:47', 'members/Qlse5oUtNp9RuReBja2z22ZGEkdZfQxGqC9vEMW1.jpeg', 'members/F9TX6OvJJ0tFzOL5Rr4KvU9gckhM4wVkC3mvpPgu.jpeg', '000004', 33, '123456'), (50, 'Demo member 1', 'bggv', 'American', '1984-12-12', 'Riddle', 'job', 'islam', 'axassdwd', 'axassdwd', '555', 'cdcds 3333', 'demotkt@gmail.com', '2021-08-07 09:14:29', '2021-08-08 10:37:12', 'members/lGP123t1u0EHEQOteOiKuODZ3oSuQoVpBjkmRqLi.jpeg', 'members/d0I9I6JMeEWq7hCM4EypBRmJurmTiScI8eCXzVBx.png', '000005', 34, '123456'), (51, 'dgd', 'scsad', 'sdsf', '25-08-2021', 'dsada', 'sfsa', 'islam', 'fdsfsf', 'fdsfsf', '334244', 'sdae 344', 'gdgdg@gmail.com', '2021-08-23 09:40:52', '2021-08-23 09:43:30', 'members/97pGE8T7RFsl0uDJ5MseL0A0MVLKHqOGT3jicwzw.jpeg', 'members/GQHltMbvjZnN1YBry0YG2tryDk4NUkxSNEwQGuah.jpeg', '000006', 34, '112345'), (52, 'Saiful Islam', 'Md. Julhas', 'Banghladeshi', '25-05-1970', 'Nazma Begum', 'Business', 'Islam', 'tikatuli,Dhaka-1212', 'tikatuli,Dhaka-1212', '01927718260', '567889990', 'saiful@gmail.com', '2021-09-08 10:31:27', '2021-09-08 10:31:27', 'members/pwIux5arcYI7UEPOBTvZNOKjMLb8HJrUY1YD5qRn.jpeg', 'members/CYT47qL05jqxXgZSUxOsldq0kcBy43BAMFhIQJ6O.jpeg', '000007', 36, '123456'), (53, 'golam rabbany', 'XYZ', 'Bangladeshi', '10-09-2021', 'Mahfuza Nasrin', 'Business', 'Islam', 'Dilkusha C/A', 'Dilkusha C/A', '01919774996', '23435435546', 'mwgrabbany100@gmail.com', '2021-09-29 15:35:07', '2021-09-29 15:40:28', 'members/8NmH1Zk5Hhzoa5xsZwATPBKcRfbVDWVkSJQNP9i7.jpeg', 'members/HFoyfXrOoEKtULjmrbllzU2t5woOKIBzSqYRCWXW.jpeg', '000008', 37, 'rabsup-123654'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2020_01_31_143519_create_land_purchases_table', 1), (4, '2020_01_31_162552_create_members_table', 1), (5, '2020_01_31_190024_create_baynas_table', 1), (6, '2020_01_31_192032_create_plots_table', 1), (7, '2020_02_01_065631_create_banks_table', 1), (8, '2020_02_01_072110_create_deposits_table', 1), (9, '2020_02_01_082138_add_picture_to_member_table', 1), (10, '2020_02_01_103646_create_references_table', 1), (11, '2020_02_01_174219_create_nominees_table', 1), (12, '2020_02_02_151623_add_role_to_table_users', 1), (13, '2020_02_02_164945_create_expence_heads_table', 1), (14, '2020_02_02_165029_create_expences_table', 1), (15, '2020_02_04_151412_create_sales_table', 1), (16, '2020_02_04_154015_add_serial_id_to_members_table', 1), (17, '2020_02_21_045445_create_sub_memebers_table', 1), (18, '2020_02_21_062807_create_installments_table', 1), (19, '2020_02_21_080045_add_reference_id_to_members_table', 1), (20, '2020_02_22_054809_add_amount_to_references_table', 1), (21, '2020_02_22_061714_create_reference_incomes_table', 1), (22, '2020_02_22_064256_create_reference_withdraws_table', 1), (23, '2020_02_25_145851_create_companies_table', 1), (24, '2020_02_28_153109_create_purchase_installments_table', 1), (25, '2020_02_28_181508_create_bank_withdraws_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `money_receipts` -- CREATE TABLE `money_receipts` ( `id` int(11) NOT NULL, `ins_id` int(11) DEFAULT NULL, `sale_id` int(11) DEFAULT NULL, `booking_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `money_receipts` -- INSERT INTO `money_receipts` (`id`, `ins_id`, `sale_id`, `booking_id`, `created_at`, `updated_at`) VALUES (1, NULL, 156, NULL, '2021-09-19 11:04:16', '2021-09-19 11:04:16'), (2, NULL, 157, NULL, '2021-09-19 11:05:52', '2021-09-19 11:05:52'), (3, NULL, 158, NULL, '2021-09-19 11:07:46', '2021-09-19 11:07:46'), (4, NULL, 159, NULL, '2021-09-25 10:33:21', '2021-09-25 10:33:21'), (5, NULL, 160, NULL, '2021-09-25 10:56:57', '2021-09-25 10:56:57'), (6, NULL, 162, NULL, '2021-09-29 15:54:38', '2021-09-29 15:54:38'); -- -------------------------------------------------------- -- -- Table structure for table `nominees` -- CREATE TABLE `nominees` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nationality` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nid` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `member_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `saled_id` int(11) DEFAULT NULL, `relation` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `nominees` -- INSERT INTO `nominees` (`id`, `name`, `hus_father`, `address`, `religion`, `nationality`, `nid`, `picture`, `member_id`, `saled_id`, `relation`, `birthday`, `status`, `created_at`, `updated_at`) VALUES (17, 'rahim', 'gdf', 'gytgt55ghiu86tyg', 'islam', 'Bangladeshi', '55446778888876655', 'nominees/Sv5BviIiY4XftA1uAC4U5BQREL2LkndL4tEzc6gi.jpeg', '48', NULL, NULL, '2003-02-14', NULL, '2021-07-07 20:08:50', '2021-07-07 20:08:50'), (16, 'Mahadi', 'Sharif Molla', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', NULL, 'Bangladeshi', '54432217899008', 'nominees/PRGo1IPypqdA5517nLZi7u5S5SY84EqrBbga4bs7.jpeg', '47', NULL, NULL, '2014-10-27', NULL, '2021-07-07 16:24:02', '2021-07-07 16:24:02'), (15, 'Demon Salvator', 'Salvator', 'Mistic falls', 'christian', 'American', '45353535352 abc', 'nominees/P7EkbLTkuh3d9VyLDSibZBmsi3VjrQHtwjHIh1w0.png', '46', NULL, 'brother', '2021-07-01', NULL, '2021-07-01 19:12:23', '2021-07-01 19:14:57'), (18, 'Angle', 'eer', 'dsgdg', 'islam', 'rgrg', 'gfbgg', 'nominees/pKv2kBuYeJzcoiAt1RYV6UepqQjAZxd7ubHg9vXN.jpeg', '46', NULL, NULL, '25-08-2021', NULL, '2021-08-23 13:31:54', '2021-08-23 13:31:54'), (19, 'Sohan', 'Md. Saiful Islam', 'sdfwefsdf', NULL, 'Bangladeshi', '43575688675', 'nominees/CdEBBVFTMY0sDr1czQ1Og7qnNQxKbKnqxVV23ux4.jpeg', '52', NULL, 'Child', '03-09-2021', NULL, '2021-09-08 10:37:04', '2021-09-08 10:41:37'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `plots` -- CREATE TABLE `plots` ( `id` bigint(20) UNSIGNED NOT NULL, `plot_size` double DEFAULT NULL, `block` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `block_id` int(11) NOT NULL, `road` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `face` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quantity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `plots` -- INSERT INTO `plots` (`id`, `plot_size`, `block`, `block_id`, `road`, `face`, `quantity`, `status`, `created_at`, `updated_at`) VALUES (25, 10, 'Standerd', 16, '6', 'north', '38', 0, '2021-07-01 18:44:05', '2021-08-23 15:37:27'), (26, 5, 'Block A', 17, 'Main', 'south', '13', 0, '2021-07-07 16:36:07', '2021-09-25 14:56:57'), (27, 5, 'Duplex', 18, 'Main', 'west', '49', 0, '2021-07-07 20:06:35', '2021-09-11 06:02:42'), (28, 5, 'Block A', 17, 'Sub-04/N-01', 'north', '11', 0, '2021-07-08 20:28:58', '2021-09-29 19:54:38'), (29, 3, 'Duplex', 18, 'Sub-09/N-01', 'south', '18', 0, '2021-07-08 20:49:49', '2021-07-11 05:05:22'), (30, 10, 'Standerd', 16, '5', 'north', '49', 0, '2021-07-11 05:06:50', '2021-07-11 05:07:16'), (31, 10, 'Demo Block 01', 19, 'Road no:01', 'north', '45', 0, '2021-07-11 08:09:17', '2021-08-07 06:10:39'), (32, 5, 'Demo Block 01', 19, '5', 'north', '46', 0, '2021-08-07 09:15:05', '2021-08-07 13:34:59'), (33, 3.5, 'Demo Block 01', 19, '5', 'south', '49', 0, '2021-08-08 10:23:51', '2021-08-09 01:48:42'), (34, 10, 'Test Edit', 20, '6', 'west', '7', 0, '2021-08-28 13:16:36', '2021-08-29 14:21:53'), (35, 3, 'Block A-1', 21, 'Sub-01/ S-01', 'north', '14', 0, '2021-09-08 09:43:16', '2021-09-25 14:33:21'); -- -------------------------------------------------------- -- -- Table structure for table `purchase_installments` -- CREATE TABLE `purchase_installments` ( `id` bigint(20) UNSIGNED NOT NULL, `land_purchase_id` int(10) UNSIGNED NOT NULL, `date` date NOT NULL, `amount` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `purchase_installments` -- INSERT INTO `purchase_installments` (`id`, `land_purchase_id`, `date`, `amount`, `created_at`, `updated_at`) VALUES (5, 7, '2021-05-10', 100, '2021-05-10 12:22:13', '2021-05-10 12:22:13'); -- -------------------------------------------------------- -- -- Table structure for table `references` -- CREATE TABLE `references` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `father_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mother_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nid` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `signature_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `amount` double DEFAULT NULL, `booking_amount` double NOT NULL, `installment_amount` double NOT NULL, `ekkalin_amount` double NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `references` -- INSERT INTO `references` (`id`, `name`, `father_name`, `mother_name`, `nid`, `dob`, `email`, `profession`, `present_address`, `permanent_address`, `mobile`, `religion`, `image`, `signature_image`, `status`, `created_at`, `updated_at`, `amount`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `password`) VALUES (32, 'Md. Abdus Salam', 'Haji Osimoddin', 'Hajera Khatun', '65499664', '1956-06-04', 'salam@gmail.com', 'Business', '17/b, Shyambazar Dhaka - 1100', '17/b, Shyambazar Dhaka - 1100', '01712087567', 'muslim', 'members/OdC1jf0baQuKwcemRRALpwQWdXdZt8DfyWaRIDoi.jpeg', 'members/zLJIeEpQdZ2toI6NJoV9QfcRcUm1ZJO19uHLJ64n.jpeg', 0, '2021-07-07 16:15:44', '2021-07-07 16:15:44', NULL, 0, 0, 0, '123456'), (31, 'Hermione Grangerooo', 'Granger', 'Granger', '45353535352 abc', '2021-07-01', 'hermioneee@gmail.com', 'Witch', 'Hogwarts', 'Hogwarts', '33333333333333', 'Islam', 'members/cj1UlLpZkWakT0BTRtKgN4X04ozZVISB8Xsw8bEr.jpeg', 'members/LVPSRo990RaVmSdUZcahQJBK8NZ8CdFRanpB9o1k.jpeg', 0, '2021-07-01 18:41:46', '2021-08-29 13:11:53', NULL, 0, 0, 0, '1234567'), (33, 'New Here', 'Here', 'Here', '45353535352 abc', '1995-12-31', 'new@gmail.com', 'Witch', 'New new', 'New new', '3333333', 'muslim', 'members/2DcIgB1RDaiAtzOjx3OA9krPAyimet1J2nK2WiCY.jpeg', 'members/Wi97rTKeehXInpeasQBC5UwlH7uVzzeNLQ3PjHNA.jpeg', 0, '2021-07-11 08:13:41', '2021-07-11 08:13:41', NULL, 0, 0, 0, '123456'), (34, 'Demo sale 1', 'Demo sale', 'Demo sale', '45353535352 abc', '2021-08-07', 'demo@gmail.com', 'Witch', 'aasAS', 'aasAS', 'Tel: 02-9512433, Mobile: 01915-618117', 'muslim', 'members/2qMErw9X6rpDl7gUyA8pdSLW78OreevWR6l9BS3D.jpeg', 'members/sg6lgKA4Glc1Vazg3KR3pOK4liJuNNHTfL6chJyj.jpeg', 1, '2021-08-07 09:13:07', '2021-09-29 20:09:17', NULL, 0, 0, 0, '123456'), (35, 'Angle', 'fgfg', 'gbgf', 'gfbgg', '31-08-2021', 'tescccc@gmail.com', 'bgbf', 'fgf', 'fgf', '43334234', 'muslim', 'members/BLGT3D3VE5g8roj44LvAFVtUPyFxCdJYXgJRyN00.png', 'members/GizB1aUTNH6OREI6wzfdzSAQBTdEgPpEwBqwD2Di.png', 1, '2021-08-23 12:53:32', '2021-09-29 20:09:00', NULL, 0, 0, 0, '112345'), (36, 'Golam Rabbany', 'Karim Khan', 'Chand Sultana Parvin', '56789654', '12-07-1985', 'Rabbany@gmail.com', 'Business', '1 R K Mission Road, Ittefaq Bhaban', '1 R K Mission Road, Ittefaq Bhaban', '01521125086', 'Islam', 'members/EMumoT2EiFtI79orDZGDDIItXKYKV7sONIPTrCD1.jpeg', 'members/NFO2liL4WA3ZwvXoACCKWR5hm0Tv1x0jigjUFPkO.png', 1, '2021-09-08 10:06:37', '2021-09-29 15:25:17', NULL, 0, 0, 0, '123456'), (37, 'golam rabbany', 'Abdur rashid', 'Mahfuza Nasrin', '9866565757655', '12/19/1992', 'mwgrabbany100@gmail.com', 'Business', 'Dilkusha C/A', 'Dilkusha C/A', '01919774996', 'Islam', 'members/vyxhoBDVQjJPhUCqneBO4fKA7yI4Z4ywkDqAPy5g.jpeg', 'members/lI5XZl3JxmTOPIy0dHT30wU9Zg9drIcIBOSBDEoy.jpeg', 0, '2021-09-29 15:15:43', '2021-09-29 15:20:36', NULL, 0, 0, 0, 'rabsup-123654'); -- -------------------------------------------------------- -- -- Table structure for table `reference_incomes` -- CREATE TABLE `reference_incomes` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` int(10) UNSIGNED NOT NULL, `reference_id` int(10) UNSIGNED NOT NULL, `sell_id` int(11) DEFAULT NULL, `intall_id` int(11) DEFAULT NULL, `paid_amount` double DEFAULT NULL, `installment_amount` double DEFAULT NULL, `block_id` int(11) NOT NULL, `block_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `plot_size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `face` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `road` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `booking_amount` double NOT NULL, `installment_per_amount` double NOT NULL, `ekkalin_per_amount` double NOT NULL, `amount` double DEFAULT NULL, `rest_amount` double DEFAULT NULL, `status` int(11) NOT NULL, `status_d` int(11) DEFAULT NULL, `isDelete` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `reference_incomes` -- INSERT INTO `reference_incomes` (`id`, `member_id`, `reference_id`, `sell_id`, `intall_id`, `paid_amount`, `installment_amount`, `block_id`, `block_name`, `plot_size`, `face`, `road`, `booking_amount`, `installment_per_amount`, `ekkalin_per_amount`, `amount`, `rest_amount`, `status`, `status_d`, `isDelete`, `created_at`, `updated_at`) VALUES (340, 46, 31, 156, NULL, 70000, 42400, 17, 'Block A', '5', 'north', 'Sub-04/N-01', 30000, 5, 10, 150000, 150000, 2, NULL, 0, '2021-09-19 15:04:16', '2021-09-19 15:04:16'), (341, 46, 31, 157, NULL, 70000, 42400, 17, 'Block A', '5', 'north', 'Sub-04/N-01', 30000, 5, 10, 150000, 150000, 2, NULL, 0, '2021-09-19 15:05:52', '2021-09-19 15:05:52'), (342, 46, 31, 158, NULL, 70000, 42400, 17, 'Block A', '5', 'north', 'Sub-04/N-01', 30000, 5, 10, 150000, 150000, 2, NULL, 0, '2021-09-19 15:07:46', '2021-09-19 15:07:46'), (343, 47, 32, 159, NULL, 70000, 14895.83, 21, 'Block A-1', '3', 'north', 'Sub-01/ S-01', 20000, 5, 10, 60000, 60000, 2, NULL, 0, '2021-09-25 14:33:21', '2021-09-25 14:33:21'), (344, 47, 32, 160, NULL, 125000, 24739.58, 17, 'Block A', '5', 'south', 'Main', 30000, 5, 10, 150000, 150000, 2, NULL, 0, '2021-09-25 14:56:57', '2021-09-25 14:56:57'), (345, 53, 37, 162, NULL, 100000, 480000, 17, 'Block A', '5', 'north', 'Sub-04/N-01', 30000, 5, 10, 150000, 150000, 2, NULL, 0, '2021-09-29 19:54:38', '2021-09-29 19:54:38'); -- -------------------------------------------------------- -- -- Table structure for table `reference_withdraws` -- CREATE TABLE `reference_withdraws` ( `id` bigint(20) UNSIGNED NOT NULL, `reference_id` int(10) UNSIGNED NOT NULL, `member_id` int(11) DEFAULT NULL, `income_id` int(11) NOT NULL, `sell_id` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `date` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `status_purpose` int(11) DEFAULT NULL, `created_at` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_at` date DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sales` -- CREATE TABLE `sales` ( `id` bigint(20) UNSIGNED NOT NULL, `plot_id` int(10) UNSIGNED NOT NULL, `plot_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rate_per` double DEFAULT NULL, `total_rate` double DEFAULT NULL, `block_id` int(11) DEFAULT NULL, `member_id` int(10) UNSIGNED NOT NULL, `nominee_id` int(11) DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `installment` int(11) DEFAULT NULL, `installment_amount` double DEFAULT NULL, `due_amount` double DEFAULT NULL, `paid` double DEFAULT NULL, `discount` double DEFAULT NULL, `target_booking` double DEFAULT NULL, `date` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sale_no` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `status_del` int(11) DEFAULT NULL, `money_rec` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `reference_id` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sales` -- INSERT INTO `sales` (`id`, `plot_id`, `plot_no`, `rate_per`, `total_rate`, `block_id`, `member_id`, `nominee_id`, `serial_id`, `installment`, `installment_amount`, `due_amount`, `paid`, `discount`, `target_booking`, `date`, `remark`, `sale_no`, `status`, `status_del`, `money_rec`, `created_at`, `updated_at`, `reference_id`) VALUES (156, 28, '019', 100000, 500000, 17, 46, NULL, 1, 10, 42400, 424000, 70000, 6000, 250000, '2021-09-25', 'sale no 1', 1, 2, NULL, '033', '2021-09-19 15:04:16', '2021-09-19 15:04:16', 31), (157, 28, '019', 100000, 500000, 17, 46, NULL, 1, 10, 42400, 424000, 70000, 6000, 250000, '2021-09-25', 'sale no 1', 1, 2, NULL, '033', '2021-09-19 15:05:52', '2021-09-19 15:05:52', 31), (158, 28, '019', 100000, 500000, 17, 46, NULL, 1, 10, 42400, 424000, 70000, 6000, 250000, '2021-09-25', 'sale no 1', 1, 2, NULL, '033', '2021-09-19 15:07:46', '2021-09-19 15:07:46', 31), (159, 35, '31', 500000, 1500000, 21, 47, NULL, 2, 96, 14895.83, 1430000, 70000, 0, 225000, '2021-09-26', 'dvfv fggt vfgf', 4, 2, NULL, NULL, '2021-09-25 14:33:21', '2021-09-25 14:33:21', 32), (160, 26, '32', 500000, 2500000, 17, 47, NULL, 2, 96, 24739.58, 2375000, 125000, 0, 375000, '2021-09-30', NULL, 5, 2, NULL, NULL, '2021-09-25 14:56:57', '2021-09-25 14:56:57', 32), (161, 28, '56', 500000, 2500000, 17, 53, NULL, 8, 5, 480000, 2400000, 100000, 0, 125000, '2021-09-09', '45645', 6, 2, NULL, 'retert', '2021-09-29 18:04:18', '2021-09-29 18:04:18', 37), (162, 28, '59', 500000, 2500000, 17, 53, NULL, 8, 5, 480000, 2400000, 100000, 0, 125000, '2021-09-27', '534534', 7, 2, NULL, '657565', '2021-09-29 19:54:38', '2021-09-29 19:54:38', 37); -- -------------------------------------------------------- -- -- Table structure for table `sale_details` -- CREATE TABLE `sale_details` ( `id` bigint(20) UNSIGNED NOT NULL, `sales_id` int(10) UNSIGNED NOT NULL, `refference_id` int(11) NOT NULL, `refference_name` text NOT NULL, `plot_id` int(10) UNSIGNED NOT NULL, `member_id` int(10) UNSIGNED NOT NULL, `installment` int(11) DEFAULT NULL, `installment_amount` double DEFAULT NULL, `due_amount` double DEFAULT NULL, `total_rate` double DEFAULT NULL, `paid` double DEFAULT NULL, `discount` int(11) DEFAULT NULL, `target_booking` double DEFAULT NULL, `date` text NOT NULL, `company_log` double UNSIGNED DEFAULT NULL, `refference_log` double UNSIGNED DEFAULT NULL, `booking_amount` double DEFAULT NULL, `install_amount` double DEFAULT NULL, `ekkalin_amount` double DEFAULT NULL, `status` int(11) DEFAULT NULL, `money_rec` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sale_details` -- INSERT INTO `sale_details` (`id`, `sales_id`, `refference_id`, `refference_name`, `plot_id`, `member_id`, `installment`, `installment_amount`, `due_amount`, `total_rate`, `paid`, `discount`, `target_booking`, `date`, `company_log`, `refference_log`, `booking_amount`, `install_amount`, `ekkalin_amount`, `status`, `money_rec`, `created_at`, `updated_at`) VALUES (154, 156, 31, 'Hermione Grangerooo', 28, 46, 10, 42400, 424000, 500000, 70000, 6000, 250000, '2021-09-25', 70000, NULL, 30000, 5, 10, NULL, 33, '2021-09-19 15:04:16', '2021-09-19 15:04:16'), (155, 157, 31, 'Hermione Grangerooo', 28, 46, 10, 42400, 424000, 500000, 70000, 6000, 250000, '2021-09-25', 70000, NULL, 30000, 5, 10, NULL, 33, '2021-09-19 15:05:52', '2021-09-19 15:05:52'), (156, 158, 31, 'Hermione Grangerooo', 28, 46, 10, 42400, 424000, 500000, 70000, 6000, 250000, '2021-09-25', 70000, NULL, 30000, 5, 10, NULL, 33, '2021-09-19 15:07:46', '2021-09-19 15:07:46'), (157, 159, 32, 'Md. Abdus Salam', 35, 47, 96, 14895.83, 1430000, 1500000, 70000, 0, 225000, '2021-09-26', 70000, NULL, 20000, 5, 10, NULL, NULL, '2021-09-25 14:33:21', '2021-09-25 14:33:21'), (158, 160, 32, 'Md. Abdus Salam', 26, 47, 96, 24739.58, 2375000, 2500000, 125000, 0, 375000, '2021-09-30', 125000, NULL, 30000, 5, 10, NULL, NULL, '2021-09-25 14:56:57', '2021-09-25 14:56:57'), (159, 162, 37, 'golam rabbany', 28, 53, 5, 480000, 2400000, 2500000, 100000, 0, 125000, '2021-09-27', 100000, NULL, 30000, 5, 10, NULL, 657565, '2021-09-29 19:54:38', '2021-09-29 19:54:38'); -- -------------------------------------------------------- -- -- Table structure for table `sale_dues` -- CREATE TABLE `sale_dues` ( `id` int(11) NOT NULL, `sale_id` int(11) NOT NULL, `member_id` int(11) NOT NULL, `booking_id` int(11) DEFAULT NULL, `ins_id` int(11) DEFAULT NULL, `amount` double NOT NULL, `status` int(11) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `single_sms_lists` -- CREATE TABLE `single_sms_lists` ( `id` int(11) NOT NULL, `name` text DEFAULT NULL, `number` int(11) NOT NULL, `sms` text NOT NULL, `status` int(11) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `single_sms_lists` -- INSERT INTO `single_sms_lists` (`id`, `name`, `number`, `sms`, `status`, `created_at`, `updated_at`) VALUES (1, NULL, 13343555, 'fsdfsdfsf', 0, '2021-09-03 18:12:16', '2021-09-03 18:12:16'), (2, NULL, 13343555, 'fsdfsdfsf', 1, '2021-09-03 18:13:24', '2021-09-03 20:11:36'), (3, 'Atp', 1303106337, 'single msg', 1, '2021-09-04 09:28:06', '2021-09-04 09:39:31'), (4, 'Angle', 1303106337, 'single 2', 1, '2021-09-04 09:28:51', '2021-09-04 09:39:27'), (5, 'Abdun Nafi Rahman', 1919774996, 'Hello Please Come now', 0, '2021-09-06 09:37:03', '2021-09-10 16:11:24'), (6, 'Rahat', 1521125086, 'Office aso na kano', 0, '2021-09-06 09:43:19', '2021-09-06 09:43:19'), (7, 'Md. Saiful Islam', 1711133043, 'Please Send Me Your Photo. 01919774996 ( Whatsapp) / mail: mwgrabbany100@gmail.com', 0, '2021-09-06 10:06:55', '2021-09-06 10:06:55'), (8, 'Mohammad Ali', 1915618117, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:19:30', '2021-09-09 10:19:30'), (9, 'Abdullah Al Mamun', 1715653453, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\n\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:21:52', '2021-09-09 10:21:52'), (10, 'Md. Rahat', 1521125086, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\n\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 1, '2021-09-09 10:22:23', '2021-09-09 10:27:27'), (11, 'Md. Rahat', 1684801240, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\n\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:23:51', '2021-09-09 10:23:51'), (12, 'Md. Abdul Haque Molla', 1711221031, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:33:36', '2021-09-09 10:33:36'), (13, 'Md. Shah Alam', 1817106462, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:36:51', '2021-09-09 10:36:51'), (14, 'Md. Saiful Islam', 1711133043, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:39:40', '2021-09-09 10:39:40'), (15, 'A.H.M Momenur Rahman', 1937404817, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:41:36', '2021-09-09 10:41:36'), (16, 'Syed Shahria Habib', 1717055220, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:43:25', '2021-09-09 10:43:25'), (17, 'Mawlana Masum Billah', 1933946254, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:44:45', '2021-09-09 10:44:45'), (18, 'Md. Hossain', 1733388327, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:45:31', '2021-09-09 10:45:31'), (19, 'Syed Hasan Musanna', 1973018941, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:46:08', '2021-09-09 10:46:08'), (20, 'Hossain Howlader', 1681700113, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\n\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:47:43', '2021-09-09 10:47:43'), (21, 'Md. Yakub Mollah', 1920790325, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:48:28', '2021-09-09 10:48:28'), (22, 'Md. Faysal Talukder', 1774445924, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:49:00', '2021-09-09 10:49:00'), (23, 'D.M Samsuddin', 1684242988, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:49:42', '2021-09-09 10:49:42'), (24, 'Md. Selim', 1727393632, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:50:20', '2021-09-09 10:50:20'), (25, 'Md. Fazal Talukder', 1714387062, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:51:00', '2021-09-09 10:51:00'), (26, 'Abul Kalam Bhuiyan', 1711627231, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:51:38', '2021-09-09 10:51:38'), (27, 'Arif Khan Regan', 1711162433, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:52:15', '2021-09-09 10:52:15'), (28, 'Md. Rasel Iqbal', 1715107531, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:52:51', '2021-09-09 10:52:51'), (29, 'Arifa Jahan Tani (Zahir Sir)', 1712986538, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 10:53:44', '2021-09-09 10:53:44'), (30, 'Md. Rahat', 1927718260, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 11:12:10', '2021-09-09 11:12:10'), (31, 'Office', 1844991718, 'āĻ¸āĻŽā§āĻŽāĻžāĻ¨ā§€āĻ¤ āĻĒāĻ°āĻŋāĻšāĻžāĻ˛āĻ•āĻŦā§ƒāĻ¨ā§āĻĻ,\r\nāĻ†āĻ¸āĻ¸āĻžāĻ˛āĻžāĻŽā§ -āĻ†āĻ˛āĻžāĻ‡āĻ•ā§āĻŽ, āĻ†āĻ—āĻžāĻŽā§€ ā§§ā§§āĻ‡ āĻ¸ā§‡āĻĒā§āĻŸā§‡āĻŽā§āĻŦāĻ°, ā§¨ā§Ļā§¨ā§§ āĻ‡āĻ‚ āĻ¤āĻžāĻ°āĻŋāĻ– āĻ°ā§‹āĻœ āĻļāĻ¨āĻŋāĻŦāĻžāĻ° āĻ¸āĻ•āĻžāĻ˛ ā§§ā§§.ā§Ļā§Ļ āĻ˜āĻŸāĻŋāĻ•āĻžāĻ° āĻ¸āĻŽā§Ÿ āĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ āĻāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡ ā§§ā§­ āĻ¤āĻŽ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻž āĻ…āĻ¨ā§āĻˇā§āĻ āĻŋāĻ¤ āĻšāĻŦā§‡āĨ¤\r\nāĻ‰āĻ•ā§āĻ¤ āĻŦā§‹āĻ°ā§āĻĄ āĻ¸āĻ­āĻžā§Ÿ āĻ…āĻŦāĻļā§āĻ¯āĻ‡ āĻ†āĻĒāĻ¨āĻžāĻ° āĻ‰āĻĒāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻāĻ•āĻžāĻ¨ā§āĻ¤āĻ­āĻžāĻŦā§‡ āĻ•āĻžāĻŽāĻ¨āĻž āĻ•āĻ°āĻ›āĻŋāĨ¤\r\n\r\nāĻ†āĻ˛ā§‹āĻšā§āĻ¯āĻ¸ā§‚āĻšāĻŋ:\r\nā§§. āĻœāĻŽāĻŋ āĻ•ā§āĻ°ā§Ÿ āĻ¨āĻŋā§Ÿā§‡ āĻ†āĻ˛ā§‹āĻšāĻ¨āĻžāĨ¤ \r\n\r\nāĻ§āĻ¨ā§āĻ¯āĻŦāĻžāĻĻāĻžāĻ¨ā§āĻ¤ā§‡,\r\n\r\nāĻŽā§‹āĻšāĻžāĻŽā§āĻŽāĻĻ āĻ†āĻ˛ā§€\r\nāĻšā§‡ā§ŸāĻžāĻ°āĻŽā§āĻ¯āĻžāĻ¨\r\nāĻĄā§āĻ°ā§€āĻŽ āĻšā§āĻ¯āĻžāĻ­ā§‡āĻ¨ āĻšāĻžāĻ‰āĻœāĻŋāĻ‚ āĻ˛āĻŋāĻŽāĻŋāĻŸā§‡āĻĄ', 0, '2021-09-09 11:38:41', '2021-09-09 11:38:41'), (32, 'Tutan Kumar Roy Gong', 1941211411, 'Dear Tutan Kumar Roy Gong,\r\nYou have paid an Installment amount of Tk.10000/- for the File No: 162.\r\nTotal Due Amount Tk.14,95,000/-.\r\nThank You.', 0, '2021-09-23 05:27:30', '2021-09-23 05:27:30'), (33, 'Golam Rabbany', 1919774996, 'Hello, Sir. How are you?', 0, '2021-09-25 07:05:41', '2021-09-25 07:05:41'); -- -------------------------------------------------------- -- -- Table structure for table `sms_counters` -- CREATE TABLE `sms_counters` ( `id` int(11) NOT NULL, `mobile` text DEFAULT NULL, `sms` text DEFAULT NULL, `total` double DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sms_counters` -- INSERT INTO `sms_counters` (`id`, `mobile`, `sms`, `total`, `created_at`, `updated_at`) VALUES (1, '55876685765', 'Dear Tom Riddleeee, You paid 70000 TK and Due amount 424000 TK for File No: 1 Plot owner Login panel link: https://soft.dhhl.ltd/login_customer', 5000, '2021-09-19 11:07:47', '2021-09-19 11:07:47'), (2, '55876685765', 'Dear Tom Riddleeee, This is your email address: tomii@gmail.com and password: 123456', 5000, '2021-09-19 11:10:52', '2021-09-19 11:10:52'), (3, '01941211411', 'Dear Tutan Kumar Roy Gong,\r\nYou have paid an Installment amount of Tk.10000/- for the File No: 162.\r\nTotal Due Amount Tk.14,95,000/-.\r\nThank You.', 5000, '2021-09-23 05:27:31', '2021-09-23 05:27:31'), (4, '01919774996', 'Hello, Sir. How are you?', 5000, '2021-09-25 07:05:42', '2021-09-25 07:05:42'), (5, '01918873065', 'Dear Sharif Molla, You paid 70000 TK and Due amount 1430000 TK for File No: 4 Plot owner Login panel link: https://soft.dhhl.ltd/login_customer', 5000, '2021-09-25 10:33:22', '2021-09-25 10:33:22'), (6, '01918873065', 'Dear Sharif Molla, You paid 125000 TK and Due amount 2375000 TK for File No: 5 Plot owner Login panel link: https://soft.dhhl.ltd/login_customer', 5000, '2021-09-25 10:56:58', '2021-09-25 10:56:58'), (7, '01919774996', 'Dear GOLAM RABBANY, This is your email address: mwgrabbany100@gmail.comand password: $2y$10$zmdui/5R17pUU56424hPS.9lyNb0pzLcQa6O.gVbftlpOZZfdnTXW', 5000, '2021-09-29 11:07:39', '2021-09-29 11:07:39'), (8, '01919774996', 'Dear golam rabbany, This is your email address: mwgrabbany100@gmail.comand password: 123456', 5000, '2021-09-29 11:19:05', '2021-09-29 11:19:05'), (9, '01919774996', 'Dear golam rabbany, This is your email address: mwgrabbany100@gmail.comand password: rabsup-123654', 5000, '2021-09-29 11:20:58', '2021-09-29 11:20:58'), (10, '01919774996', 'Dear golam rabbany, Thanks For Joining With us. You have registered on our site https://dhhl.ltd .Plot owner registrated panal- Login email: mwgrabbany100@gmail.com | Password: 123456 | Login panel link: https://soft.dhhl.ltd/login_customer', 5000, '2021-09-29 11:35:08', '2021-09-29 11:35:08'), (11, '01919774996', 'Dear golam rabbany, This is your email address: mwgrabbany100@gmail.com and password: rabsup-123654', 5000, '2021-09-29 11:41:41', '2021-09-29 11:41:41'), (12, '01919774996', 'Dear golam rabbany, You paid 100000 TK and Due amount 2400000 TK for File No: 7 Plot owner Login panel link: https://soft.dhhl.ltd/login_customer', 5000, '2021-09-29 15:54:39', '2021-09-29 15:54:39'), (13, '01919774996', 'Dear GOLAM RABBANY, This is your email address: mwgrabbany100@gmail.comand password: $2y$10$zmdui/5R17pUU56424hPS.9lyNb0pzLcQa6O.gVbftlpOZZfdnTXW', 5000, '2021-09-29 16:24:19', '2021-09-29 16:24:19'); -- -------------------------------------------------------- -- -- Table structure for table `sub_memebers` -- CREATE TABLE `sub_memebers` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `serial_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `mobile`, `password`, `remember_token`, `created_at`, `updated_at`, `role`) VALUES (2, 'Ahmed Ali', 'ahmed@gmail.com', '01712869532', '$2y$10$mMs82dRYbCmCg5gRyWqX1OAlGt5wRbMCGaLJBnt7vCuI6L5pce9va', NULL, '2020-12-07 06:57:11', '2021-09-25 14:05:47', 'user'), (3, 'Mohammed Ali', 'dreamgreencity@gmail.com', NULL, '$2y$10$0Ic3IrOHEchbSWH.Gq/TV./EhxKqIZH5Pdg53x.UHY/46kQYBKYuy', NULL, '2020-12-12 13:36:08', '2021-09-06 14:28:31', 'user'), (4, 'Nizam', 'nizamlata1982@gmail.com', NULL, '$2y$10$Pb5LkqBMKfr/5nWkxwlgruJGsQUMUs1ve/lo./A4ThCG0zSoUxKla', NULL, '2021-01-14 13:27:06', '2021-01-14 13:27:06', 'user'), (5, 'Rahat', 'mdrahat@gmail.com', '01684801240', '$2y$10$WzoLSPaNaVbWwneU13fALu4AaLa6dACnOBonOQrGDCr2bzwXTTKpe', NULL, '2021-05-25 13:04:13', '2021-09-25 14:06:24', 'user'), (6, 'GOLAM RABBANY', 'mwgrabbany100@gmail.com', '01919774996', '$2y$10$zmdui/5R17pUU56424hPS.9lyNb0pzLcQa6O.gVbftlpOZZfdnTXW', NULL, '2021-09-29 15:06:25', '2021-09-29 15:06:25', 'Admin'); -- -- Indexes for dumped tables -- -- -- Indexes for table `accounts` -- ALTER TABLE `accounts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banks` -- ALTER TABLE `banks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bank_withdraws` -- ALTER TABLE `bank_withdraws` ADD PRIMARY KEY (`id`); -- -- Indexes for table `baynas` -- ALTER TABLE `baynas` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blocks` -- ALTER TABLE `blocks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `booking_amounts` -- ALTER TABLE `booking_amounts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `booking_forms` -- ALTER TABLE `booking_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `commision_plans` -- ALTER TABLE `commision_plans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `companies` -- ALTER TABLE `companies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `custom_bookings` -- ALTER TABLE `custom_bookings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `custom_installments` -- ALTER TABLE `custom_installments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `demo_installments` -- ALTER TABLE `demo_installments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `deposits` -- ALTER TABLE `deposits` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expences` -- ALTER TABLE `expences` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expence_heads` -- ALTER TABLE `expence_heads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `groups` -- ALTER TABLE `groups` ADD PRIMARY KEY (`id`); -- -- Indexes for table `group_members` -- ALTER TABLE `group_members` ADD PRIMARY KEY (`id`); -- -- Indexes for table `group_msgs` -- ALTER TABLE `group_msgs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `incomes` -- ALTER TABLE `incomes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `income_heads` -- ALTER TABLE `income_heads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `installments` -- ALTER TABLE `installments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `land_purchases` -- ALTER TABLE `land_purchases` ADD PRIMARY KEY (`id`); -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `money_receipts` -- ALTER TABLE `money_receipts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `nominees` -- ALTER TABLE `nominees` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `plots` -- ALTER TABLE `plots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchase_installments` -- ALTER TABLE `purchase_installments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `references` -- ALTER TABLE `references` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reference_incomes` -- ALTER TABLE `reference_incomes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reference_withdraws` -- ALTER TABLE `reference_withdraws` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sales` -- ALTER TABLE `sales` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sale_details` -- ALTER TABLE `sale_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sale_dues` -- ALTER TABLE `sale_dues` ADD PRIMARY KEY (`id`); -- -- Indexes for table `single_sms_lists` -- ALTER TABLE `single_sms_lists` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sms_counters` -- ALTER TABLE `sms_counters` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_memebers` -- ALTER TABLE `sub_memebers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `accounts` -- ALTER TABLE `accounts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=155; -- -- AUTO_INCREMENT for table `banks` -- ALTER TABLE `banks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `bank_withdraws` -- ALTER TABLE `bank_withdraws` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `baynas` -- ALTER TABLE `baynas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `blocks` -- ALTER TABLE `blocks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `booking_amounts` -- ALTER TABLE `booking_amounts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `booking_forms` -- ALTER TABLE `booking_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53; -- -- AUTO_INCREMENT for table `commision_plans` -- ALTER TABLE `commision_plans` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55; -- -- AUTO_INCREMENT for table `companies` -- ALTER TABLE `companies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `custom_bookings` -- ALTER TABLE `custom_bookings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `custom_installments` -- ALTER TABLE `custom_installments` MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `demo_installments` -- ALTER TABLE `demo_installments` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `deposits` -- ALTER TABLE `deposits` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- AUTO_INCREMENT for table `expences` -- ALTER TABLE `expences` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `expence_heads` -- ALTER TABLE `expence_heads` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `groups` -- ALTER TABLE `groups` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `group_members` -- ALTER TABLE `group_members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- AUTO_INCREMENT for table `group_msgs` -- ALTER TABLE `group_msgs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `incomes` -- ALTER TABLE `incomes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `income_heads` -- ALTER TABLE `income_heads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `installments` -- ALTER TABLE `installments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=196; -- -- AUTO_INCREMENT for table `land_purchases` -- ALTER TABLE `land_purchases` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `money_receipts` -- ALTER TABLE `money_receipts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `nominees` -- ALTER TABLE `nominees` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `plots` -- ALTER TABLE `plots` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `purchase_installments` -- ALTER TABLE `purchase_installments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `references` -- ALTER TABLE `references` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `reference_incomes` -- ALTER TABLE `reference_incomes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=346; -- -- AUTO_INCREMENT for table `reference_withdraws` -- ALTER TABLE `reference_withdraws` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107; -- -- AUTO_INCREMENT for table `sales` -- ALTER TABLE `sales` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=163; -- -- AUTO_INCREMENT for table `sale_details` -- ALTER TABLE `sale_details` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160; -- -- AUTO_INCREMENT for table `sale_dues` -- ALTER TABLE `sale_dues` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `single_sms_lists` -- ALTER TABLE `single_sms_lists` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `sms_counters` -- ALTER TABLE `sms_counters` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `sub_memebers` -- ALTER TABLE `sub_memebers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;