-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `IE4520100329`
--

-- --------------------------------------------------------

--
-- Table structure for table `addmenuitems`
--

CREATE TABLE `addmenuitems` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `menuitemdate` date NOT NULL,
  `menuitemday` varchar(255) DEFAULT NULL,
  `menuitemtime` varchar(255) DEFAULT NULL,
  `menuitemname` text,
  `menuitemimage` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `candi_name` varchar(255) NOT NULL,
  `candidate_mobile` varchar(12) NOT NULL,
  `booking_date` date NOT NULL,
  `regdate` date NOT NULL,
  `roomno` int(255) NOT NULL,
  `seatno` varchar(255) NOT NULL,
  `Booking_amount` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`id`, `created_at`, `updated_at`, `candi_name`, `candidate_mobile`, `booking_date`, `regdate`, `roomno`, `seatno`, `Booking_amount`, `status`) VALUES
(1, '2023-10-02 03:05:42', '2023-10-02 10:03:26', 'OM PANDEY', '8839775299', '2023-10-26', '2023-10-04', 111, '1', '2000', 0),
(2, '2023-10-09 05:58:58', '2023-10-02 10:05:23', 'UDAY KAKDE', '9131323248', '2023-09-29', '2023-10-15', 106, '1', '1000', 0),
(3, '2023-10-07 11:59:59', '2023-10-02 10:06:37', 'OM PANDEY', '9131323248', '2023-09-26', '2023-10-04', 111, '1', '2000', 0),
(4, '2023-10-06 12:02:08', '2023-10-03 12:08:20', 'ROSHNI SONI', '9109319650', '2023-10-02', '2023-10-08', 201, '1', '2000', 0),
(5, '2023-10-06 12:00:51', '2023-10-05 12:35:41', 'manshi patel', '9302547255', '2023-10-04', '2023-10-06', 201, '2', '500', 0),
(6, '2023-10-06 13:34:17', '2023-10-05 19:10:41', 'Himanshi sethi', '9981306146', '2023-10-03', '2023-10-03', 204, '2', '0', 0),
(7, '2023-10-07 13:05:31', '2023-10-05 19:51:33', 'ANJALI MALVIYA', '9009569704', '2023-10-05', '2023-10-15', 204, '3', '0', 0),
(8, '2023-10-07 13:05:48', '2023-10-06 00:37:49', 'Ayushi singh', '7985959240', '2023-10-05', '2023-10-15', 209, '1', '2000', 0),
(9, '2023-10-07 13:06:07', '2023-10-06 14:36:37', 'Ayushi singh', '7085959240', '2023-10-06', '2023-10-15', 209, '1', '2000', 0),
(10, '2023-10-10 16:07:30', '2023-10-06 17:37:23', 'PRAGYA SHARMA', '7354568367', '2023-10-05', '2023-10-07', 210, '1', '0', 0),
(11, '2023-10-08 11:22:30', '2023-10-06 19:01:49', 'MANSHI PATEL', '9302547255', '2023-10-04', '2023-10-06', 202, '2', '500', 0),
(12, '2023-10-11 16:29:28', '2023-10-06 19:02:48', 'ROSHNI SONI', '9109319650', '2023-10-03', '2023-10-08', 202, '1', '2000', 0),
(13, '2023-10-11 16:37:00', '2023-10-07 20:06:46', 'Ayushi Singh', '7985959240', '2023-10-05', '2023-10-15', 209, '1', '1000', 0),
(14, '2023-10-11 16:48:53', '2023-10-08 15:07:54', 'Nikita manwani', '7049096562', '2023-10-08', '2023-10-08', 206, '1', '2000', 0),
(15, '2023-10-11 13:57:46', '2023-10-09 11:45:14', 'ANJALI MALVIYA', '9009569704', '2023-10-07', '2023-10-09', 203, '1', '2000', 0),
(16, '2023-10-10 05:27:30', '2023-10-09 12:26:33', 'Sourabh soni', '9630115121', '2023-10-09', '2023-10-09', 105, '1', '5400', 0),
(17, '2023-10-10 16:05:06', '2023-10-09 12:27:57', 'Sourav tiwari', '7694830910', '2023-10-09', '2023-10-09', 105, '1', '5400', 0),
(18, '2023-10-10 16:05:30', '2023-10-09 12:40:43', 'sourabh tiwari', '7694830910', '2023-10-09', '2023-10-09', 105, '1', '2000', 0),
(19, '2023-10-09 05:56:08', '2023-10-09 12:55:21', 'saurabh soni', '7879868904', '2023-10-09', '2023-10-09', 105, '2', '2000', 0),
(20, '2023-10-10 05:37:01', '2023-10-09 12:58:43', 'Sourav Tiwari', '7694830910', '2023-10-09', '2023-10-09', 105, '2', '5400', 0),
(21, '2023-10-12 15:19:40', '2023-10-09 12:59:49', 'UDAY KAKDE', '9131323248', '2023-10-09', '2023-10-09', 111, '2', '1000', 0),
(22, '2023-10-10 16:06:43', '2023-10-10 12:08:10', 'Suhana thakur', '6265086305', '2023-10-10', '2023-10-10', 204, '1', '1000', 0),
(23, '2023-10-10 16:07:14', '2023-10-10 12:08:10', 'Suhana thakur', '6265086305', '2023-10-10', '2023-10-10', 204, '1', '1000', 0),
(24, '2023-10-10 07:12:50', '2023-10-10 14:04:52', 'SUHANA THAKUR', '6265086305', '2023-10-09', '2023-10-10', 204, '3', '1000', 0),
(25, '2023-10-10 14:47:11', '2023-10-10 21:37:42', 'DIVYANSH YADAV', '9589117270', '2023-10-10', '2023-10-11', 101, '1', '2000', 0),
(26, '2023-10-10 14:47:26', '2023-10-10 21:45:14', 'ATISHAY JAIN', '8717851267', '2023-10-10', '2023-10-11', 101, '2', '1000', 0),
(27, '2023-10-11 12:53:48', '2023-10-10 21:50:02', 'DIVYANSH YADAV', '9589117270', '2023-10-10', '2023-10-01', 101, '1', '3000', 0),
(28, '2023-10-11 12:42:52', '2023-10-10 21:50:43', 'ATISHAY JAIN', '8717851267', '2023-10-10', '2023-10-11', 101, '2', '2000', 0),
(29, '2023-10-13 05:38:44', '2023-10-10 23:13:19', 'TEJASVINI JAIN', '8770213389', '2023-10-10', '2023-10-11', 210, '2', '0', 0),
(30, '2023-11-24 07:08:42', '2023-10-11 13:39:40', 'AYUSH SHARMA', '7869625984', '2023-10-11', '2023-11-16', 101, '3', '1000', 0),
(31, '2023-10-12 13:50:36', '2023-10-12 20:50:12', 'VINITA SAHNI', '6386975976', '2023-10-12', '2023-10-13', 208, '1', '2000', 0),
(32, '2023-10-13 05:10:21', '2023-10-12 20:51:54', 'VINITA SAHNI', '6386975976', '2023-10-12', '2023-10-13', 208, '1', '1000', 0),
(33, '2023-10-17 04:04:26', '2023-10-13 20:11:00', 'RICHA PATEL', '9691443436', '2023-10-13', '2023-10-16', 208, '2', '2000', 0),
(34, '2023-12-20 05:38:22', '2023-12-09 14:51:36', 'mayank', '6386975976', '2023-12-04', '2023-12-20', 107, '1', '2000', 0),
(35, '2023-12-20 05:44:53', '2023-12-09 14:52:20', 'kishan', '6386975976', '2023-12-04', '2023-12-20', 107, '2', '2000', 0),
(36, '2023-12-20 05:38:12', '2023-12-16 21:48:55', 'Anubhav agnihotri', '738911616', '2023-12-16', '2023-12-02', 109, '2', '2000', 0),
(37, '2023-12-20 05:41:11', '2023-12-20 12:40:27', 'Anubhav agnihotri', '7389116167', '2023-12-16', '2024-01-02', 201, '2', '2000', 0),
(38, '2023-12-27 03:12:03', '2023-12-20 12:43:17', 'Anubhav agnihotri', '7389116167', '2023-12-16', '2024-01-02', 107, '1', '2000', 0),
(39, '2023-12-27 03:12:27', '2023-12-20 12:43:17', 'Anubhav agnihotri', '7389116167', '2023-12-16', '2024-01-02', 107, '1', '2000', 0),
(40, '2023-12-27 10:13:25', '2023-12-27 10:13:25', 'Anubhav Agnihotri', '7389116167', '2023-12-16', '2024-01-02', 107, '2', '2000', 1),
(41, '2024-01-02 06:05:04', '2023-12-27 10:16:36', 'Pankaj Barpete', '9340404089', '2023-12-24', '2023-12-26', 105, '2', '2000', 0),
(42, '2024-01-02 13:04:03', '2024-01-02 13:04:03', 'Vansh Jain', '9755523971', '2024-01-01', '2024-01-07', 103, '3', '2000', 1),
(43, '2024-01-02 17:20:50', '2024-01-02 17:20:50', 'argh jain', '7067403934', '2024-01-02', '2024-01-05', 105, '2', '2000', 1);

-- --------------------------------------------------------

--
-- Table structure for table `custome_reveived_amounts`
--

CREATE TABLE `custome_reveived_amounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `receiveDate` date DEFAULT NULL,
  `candidateID` int(11) DEFAULT NULL,
  `invoiceNo` int(11) DEFAULT NULL,
  `pandingAmount` float DEFAULT NULL,
  `receiveAmount` float DEFAULT NULL,
  `paymentMode` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unused` float NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customsalesales`
--

CREATE TABLE `customsalesales` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `roomno` int(25) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `mobile` varchar(12) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `invoiceno` int(25) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `tpdate` date DEFAULT NULL,
  `item` varchar(255) DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `rate` varchar(255) DEFAULT NULL,
  `tax` varchar(255) DEFAULT NULL,
  `amount` varchar(255) NOT NULL,
  `payment_status` tinyint(1) NOT NULL DEFAULT '1',
  `discount` varchar(25) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `receive_amount` double DEFAULT NULL,
  `remaining_amount` double DEFAULT NULL,
  `unused` double DEFAULT '0',
  `paymentMode` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customsalesales`
--

INSERT INTO `customsalesales` (`id`, `created_at`, `updated_at`, `roomno`, `name`, `mobile`, `address`, `invoiceno`, `invoicedate`, `tpdate`, `item`, `quantity`, `rate`, `tax`, `amount`, `payment_status`, `discount`, `total`, `receive_amount`, `remaining_amount`, `unused`, `paymentMode`) VALUES
(2, '2023-11-30 15:38:22', '2023-11-30 15:38:22', 101, 'ssg hostelor', '7879868904', 'ssg indore', 54, '2023-11-30', '2023-11-30', '9,8', '5,1', '350,500', '0,0', '1499.995,450', 1, '14.286,10', 1949, 1949, 0, 0, 'cash'),
(3, '2023-12-04 16:44:02', '2023-12-04 16:44:02', 108, 'aman sawle', '0000000000', 'ssg inodore', 84, '2023-11-30', '2023-11-30', '14', '2', '80', '0', '120', 1, '25', 120, 120, 0, 0, 'online'),
(8, '2023-12-27 10:47:12', '2023-12-27 10:47:12', 211, 'ssg hostelor', '7879868904', 'ssg indore', 118, '2023-12-31', '2023-12-31', '8', '12', '500', '0', '5400', 1, '10', 5400, 5400, 0, 0, 'online'),
(9, '2024-01-02 05:39:45', '2024-01-02 12:39:45', 107, 'ssg hostelor', '7879868904', 'ssg indore', 119, '2023-12-31', '2023-12-31', '8,9', '1,1', '500,350', '0,0', '500,250.25', 1, '0,28.5', 750.25, 750.25, 0, 0, 'online'),
(10, '2024-01-02 12:43:06', '2024-01-02 12:43:06', 0, 'sachin jee', '7879868904', 'haier office', 121, '2023-12-11', '2023-12-11', '11', '2', '1650', '0', '2999.7', 1, '9.1', 2999.7, 2999.7, 0, 0, 'online'),
(11, '2024-01-02 14:12:20', '2024-01-02 14:12:20', 103, 'cancel booking', '7879868904', 'ssg hosteler', 124, '2023-12-31', '2023-12-31', '7', '1', '3000', '0', '2000.1', 1, '33.33', 2000.1, 2000.1, 0, 0, 'online'),
(12, '2024-01-02 14:14:07', '2024-01-02 14:14:07', 0, 'gaurav jee', '7879868904', 'ssg indore', 125, '2023-12-31', '2023-12-31', '14', '7', '80', '0', '420', 1, '25', 420, 420, 0, 0, 'online');

-- --------------------------------------------------------

--
-- Table structure for table `electicity_management`
--

CREATE TABLE `electicity_management` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `roomno` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `BillDate` date DEFAULT NULL,
  `discountUnits` float DEFAULT '0',
  `previous_reading` double(8,2) DEFAULT NULL,
  `present_reading` double(8,2) DEFAULT NULL,
  `units` double(8,2) DEFAULT NULL,
  `readingRate` float DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `electicity_management`
--

INSERT INTO `electicity_management` (`id`, `roomno`, `BillDate`, `discountUnits`, `previous_reading`, `present_reading`, `units`, `readingRate`, `created_at`, `updated_at`) VALUES
(1, '101', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:11:21'),
(2, '102', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:11:30'),
(3, '103', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:11:39'),
(4, '104', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:11:52'),
(5, '105', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:12:10'),
(6, '106', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:12:17'),
(7, '107', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:12:23'),
(8, '108', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:12:30'),
(9, '109', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:12:38'),
(10, '110', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:12:45'),
(11, '111', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:12:52'),
(12, '201', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:13:01'),
(13, '202', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:13:09'),
(14, '203', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:13:17'),
(15, '204', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:13:24'),
(16, '205', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:13:31'),
(17, '206', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:13:40'),
(18, '207', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:13:48'),
(19, '208', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:13:55'),
(20, '209', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:14:03'),
(21, '210', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:14:12'),
(22, '211', '2023-10-01', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:07:17', '2023-12-10 20:14:19'),
(23, '101', '2023-11-06', 24, 1.00, 52.00, 51.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(24, '102', '2023-11-06', 13, 1.00, 41.00, 40.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(25, '103', '2023-11-06', 18, 1.00, 46.00, 45.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(26, '104', '2023-11-06', 0, 1.00, 5.00, 4.00, 11, '2023-12-03 19:25:14', '2023-12-04 13:37:02'),
(27, '105', '2023-11-06', 18, 1.00, 46.00, 45.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(28, '106', '2023-11-06', 0, 1.00, 5.00, 4.00, 11, '2023-12-03 19:25:14', '2023-12-04 13:36:53'),
(29, '107', '2023-11-06', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:25:14', '2023-12-04 13:37:34'),
(30, '108', '2023-11-06', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:25:14', '2023-12-04 13:37:44'),
(31, '109', '2023-11-06', 0, 1.00, 1.00, 0.00, 11, '2023-12-03 19:25:14', '2023-12-04 13:39:41'),
(32, '110', '2023-11-06', 0, 1.00, 17.00, 16.00, 11, '2023-12-03 19:25:14', '2023-12-04 13:37:12'),
(33, '111', '2023-11-06', 18, 1.00, 46.00, 45.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(34, '201', '2023-11-06', 0, 1.00, 9.00, 8.00, 11, '2023-12-03 19:25:14', '2023-12-04 13:37:28'),
(35, '202', '2023-11-06', 38, 1.00, 66.00, 65.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(36, '203', '2023-11-06', 14, 1.00, 42.00, 41.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(37, '204', '2023-11-06', 10, 1.00, 38.00, 37.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(38, '205', '2023-11-06', 21, 1.00, 49.00, 48.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(39, '206', '2023-11-06', 10, 1.00, 38.00, 37.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(40, '207', '2023-11-06', 0, 1.00, 12.00, 11.00, 11, '2023-12-03 19:25:14', '2023-12-10 20:14:38'),
(41, '208', '2023-11-06', 10, 1.00, 38.00, 37.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(42, '209', '2023-11-06', 0, 1.00, 12.00, 11.00, 11, '2023-12-03 19:25:14', '2023-12-04 13:39:52'),
(43, '210', '2023-11-06', 29, 1.00, 57.00, 56.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(44, '211', '2023-11-06', 30, 1.00, 58.00, 57.00, 11, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(45, '101', '2023-12-06', 10, 52.00, 89.00, 37.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(46, '102', '2023-12-06', 0, 41.00, 64.00, 23.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(47, '103', '2023-12-06', 2, 46.00, 75.00, 29.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(48, '104', '2023-12-06', 0, 5.00, 17.00, 12.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(49, '105', '2023-12-06', 2, 46.00, 75.00, 29.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(50, '106', '2023-12-06', 0, 5.00, 17.00, 12.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(51, '107', '2023-12-06', 0, 1.00, 4.00, 3.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(52, '108', '2023-12-06', 0, 1.00, 1.00, 0.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(53, '109', '2023-12-06', 0, 1.00, 3.00, 2.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(54, '110', '2023-12-06', 0, 17.00, 17.00, 0.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(55, '111', '2023-12-06', 0, 46.00, 52.00, 6.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(56, '201', '2023-12-06', 0, 9.00, 18.00, 9.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(57, '202', '2023-12-06', 18, 66.00, 111.00, 45.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(58, '203', '2023-12-06', 0, 42.00, 69.00, 27.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(59, '204', '2023-12-06', 3, 38.00, 68.00, 30.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(60, '205', '2023-12-06', 19, 49.00, 95.00, 46.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(61, '206', '2023-12-06', 3, 38.00, 68.00, 30.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(62, '207', '2023-12-06', 0, 12.00, 28.00, 16.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(63, '208', '2023-12-06', 3, 38.00, 68.00, 30.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(64, '209', '2023-12-06', 16, 12.00, 28.00, 16.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:17:06'),
(65, '210', '2023-12-06', 3, 57.00, 87.00, 30.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(66, '211', '2023-12-06', 38, 58.00, 123.00, 65.00, 11, '2023-12-07 14:11:51', '2023-12-07 14:11:51');

-- --------------------------------------------------------

--
-- Table structure for table `emp_attendances`
--

CREATE TABLE `emp_attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('P','A','H','L') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `emp_management`
--

CREATE TABLE `emp_management` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `form_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_date` date DEFAULT NULL,
  `candidate_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `aadharcard_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blood_group` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `helth_issue` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `helth_description` text COLLATE utf8mb4_unicode_ci,
  `marital_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehical_check` enum('Yes','No') COLLATE utf8mb4_unicode_ci DEFAULT 'No',
  `vehical_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_address` text COLLATE utf8mb4_unicode_ci,
  `parmanent_address` text COLLATE utf8mb4_unicode_ci,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_contect` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `designation` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `startDate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `endDate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `holder_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Ifcs_code` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `candidate_signature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `candidate_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aadhar_front` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aadhar_back` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `expensedetails`
--

CREATE TABLE `expensedetails` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `quantity` varchar(255) NOT NULL,
  `amount` int(255) NOT NULL,
  `billdate` text NOT NULL,
  `itemname` varchar(255) NOT NULL,
  `rate` varchar(255) NOT NULL,
  `paymentmode` varchar(225) NOT NULL,
  `uploadbill` varchar(500) DEFAULT NULL,
  `category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `expensedetails`
--

INSERT INTO `expensedetails` (`id`, `created_at`, `updated_at`, `quantity`, `amount`, `billdate`, `itemname`, `rate`, `paymentmode`, `uploadbill`, `category_id`) VALUES
(1, '2023-10-02 09:41:47', '2023-10-02 09:41:47', '1', 4310, '2023-10-01', 'DMART STORE', '4310', 'Cash', NULL, 4),
(2, '2023-10-02 09:42:15', '2023-10-02 09:42:15', '1', 6943, '2023-10-01', 'DMART ONLINE', '6943', 'Cash', NULL, 4),
(4, '2023-10-02 09:45:51', '2023-10-02 09:45:51', '1', 510, '2023-10-01', 'PETROL 26/09', '510', 'Cash', NULL, 5),
(5, '2023-10-02 09:46:21', '2023-10-02 09:46:21', '1', 210, '2023-10-01', 'PETROL 01/10', '210', 'Online', NULL, 5),
(6, '2023-10-02 09:47:09', '2023-10-02 09:47:09', '1', 500, '2023-10-01', 'sabji mandi', '500', 'Cash', NULL, 6),
(7, '2023-10-02 12:53:39', '2023-10-02 12:53:39', '1', 4490, '2023-10-02', 'BESTPRICE STORE', '4490', 'Online', NULL, 4),
(8, '2023-10-03 05:10:55', '2023-10-03 12:10:55', '1', 27600, '2023-10-01', 'CCTV SETUP', '27600', 'Cash', NULL, 11),
(10, '2023-10-03 13:04:15', '2023-10-03 13:04:15', '1', 500, '2023-10-02', 'sabji mandi', '500', 'Online', NULL, 6),
(12, '2023-10-07 19:53:40', '2023-10-07 19:53:40', '1', 2350, '2023-10-07', '2', '2350', 'Cash', NULL, 7),
(13, '2023-10-09 19:20:20', '2023-10-09 19:20:20', '1', 9000, '2023-10-10', 'Washing Machine', '9000', 'Online', NULL, 11),
(14, '2023-10-13 10:26:40', '2023-10-13 10:26:40', '1', 600, '2023-10-11', 'petrol', '600', 'Cash', NULL, 5),
(15, '2023-10-13 10:27:07', '2023-10-13 10:27:07', '1', 500, '2023-10-11', 'sushant ticket', '500', 'Cash', NULL, 5),
(17, '2023-10-13 10:30:39', '2023-10-13 10:30:39', '1', 500, '2023-10-03', 'sabji futkar', '500', 'Cash', NULL, 6),
(18, '2023-10-13 10:30:59', '2023-10-13 10:30:59', '1', 700, '2023-10-07', 'sabji mandi', '700', 'Cash', NULL, 6),
(19, '2023-10-13 10:31:22', '2023-10-13 10:31:22', '1', 600, '2023-10-12', 'sabji', '600', 'Cash', NULL, 6),
(20, '2023-10-13 10:33:22', '2023-10-13 10:33:22', '1', 800, '2023-10-11', 'key ring+stainor+Hooks', '800', 'Cash', NULL, 10),
(21, '2023-10-13 10:33:45', '2023-10-13 10:33:45', '1', 500, '2023-10-11', 'induction repair', '500', 'Cash', NULL, 10),
(22, '2023-10-13 10:35:08', '2023-10-13 10:35:08', '1', 1285, '2023-10-11', 'dmart store', '1285', 'Cash', NULL, 4),
(23, '2023-10-14 21:51:40', '2023-10-14 21:51:40', '1', 4000, '2023-10-01', 'FOOD 7 DAYS', '4000', 'Cash', NULL, 12),
(24, '2023-10-14 21:52:42', '2023-10-14 21:52:42', '2', 2220, '2023-10-13', 'TEA DISPENSER', '1110', 'Online', NULL, 11),
(25, '2023-10-14 21:53:03', '2023-10-14 21:53:03', '1', 640, '2023-10-13', 'CUP SET', '640', 'Online', NULL, 11),
(26, '2023-10-14 21:54:09', '2023-10-14 21:54:09', '1', 750, '2023-10-12', 'AGREEMENT', '750', 'Cash', NULL, 12),
(27, '2023-10-15 12:53:24', '2023-10-15 12:53:24', '1', 13750, '2023-10-15', 'TV', '13750', 'Online', NULL, 11),
(28, '2023-10-15 12:54:53', '2023-10-15 12:54:53', '1', 850, '2023-10-01', 'stationary', '850', 'Cash', NULL, 12),
(29, '2023-10-15 12:55:43', '2023-10-15 12:55:43', '1', 1350, '2023-10-15', 'promotional poster', '1350', 'Online', NULL, 12),
(30, '2023-10-17 10:28:46', '2023-10-17 10:28:46', '1', 1054, '2023-10-01', 'doormates', '1054', 'Cash', NULL, 12),
(31, '2023-10-17 10:29:31', '2023-10-17 10:29:31', '2', 178, '2023-10-12', 'hooks', '89', 'Cash', NULL, 12),
(32, '2023-10-17 10:30:30', '2023-10-17 10:30:30', '1', 250, '2023-10-15', 'TV wall mount', '250', 'Cash', NULL, 11),
(33, '2023-11-01 20:00:37', '2023-11-02 03:00:37', '1', 1100, '2023-11-01', '1', '1100', 'Online', NULL, 7),
(34, '2023-11-07 10:29:48', '2023-11-07 10:29:48', '1', 413, '2023-10-31', 'ITEM TILL 31', '413', 'Cash', NULL, 10),
(35, '2023-11-11 13:30:21', '2023-11-11 20:30:21', '1', 310, '2023-10-13', 'PETROL', '310', 'Cash', NULL, 5),
(36, '2023-11-07 10:35:56', '2023-11-07 10:35:56', '1', 150, '2023-10-30', 'FUTKAR PETROL TILL 30', '150', 'Cash', NULL, 5),
(37, '2023-11-11 13:29:46', '2023-11-11 20:29:46', '1', 1000, '2023-10-17', 'ANIL TRANSPORT', '1000', 'Cash', NULL, 5),
(38, '2023-11-11 13:36:55', '2023-11-11 20:36:55', '1', 12000, '2023-11-10', 'DINESH salary', '12000', 'Online', NULL, 8),
(39, '2023-11-07 10:39:48', '2023-11-07 10:39:48', '1', 4235, '2023-10-31', 'SABJI MANDI TILL 31', '4235', 'Cash', NULL, 6),
(40, '2023-11-07 10:41:36', '2023-11-07 10:41:36', '1', 1570, '2023-10-31', 'FUTKAR DAIRY TILL 31', '1570', 'Cash', NULL, 3),
(41, '2023-11-07 10:42:02', '2023-11-07 10:42:02', '1', 1500, '2023-10-31', 'MILK TILL 31', '1500', 'Cash', NULL, 3),
(42, '2023-11-07 10:42:59', '2023-11-07 10:42:59', '1', 240, '2023-10-31', 'SABJI PATA', '240', 'Cash', NULL, 11),
(43, '2023-11-07 10:45:30', '2023-11-07 10:45:30', '1', 416, '2023-10-16', 'DMART', '416', 'Cash', NULL, 4),
(44, '2023-11-07 10:46:16', '2023-11-07 10:46:16', '1', 2650, '2023-10-23', 'DAMRT', '2650', 'Online', NULL, 4),
(45, '2023-11-07 10:47:52', '2023-11-07 10:47:52', '1', 1092, '2023-10-31', 'BEST PRICE', '1092', 'Cash', NULL, 4),
(46, '2023-12-07 08:20:36', '2023-12-07 15:20:36', '2', 1000, '2023-11-06', 'water container', '500', 'Online', NULL, 11),
(47, '2023-11-11 20:29:07', '2023-11-11 20:29:07', '2', 2000, '2023-11-08', 'sushant+anil', '1000', 'Cash', NULL, 5),
(48, '2023-11-11 20:33:22', '2023-11-11 20:33:22', '1', 3860, '2023-11-08', 'best price', '3860', 'Online', NULL, 4),
(49, '2023-11-11 20:33:54', '2023-11-11 20:33:54', '1', 2263, '2023-11-08', 'DMART store', '2263', 'Online', NULL, 4),
(50, '2023-11-11 20:35:07', '2023-11-11 20:35:07', '1', 6590, '2023-11-10', 'dmart on;line', '6590', 'Online', NULL, 4),
(51, '2023-11-11 20:36:38', '2023-11-11 20:36:38', '1', 9000, '2023-11-10', 'kishan salary', '9000', 'Online', NULL, 8),
(52, '2023-11-11 20:37:43', '2023-11-11 20:37:43', '1', 1500, '2023-11-10', 'anil safai', '1500', 'Online', NULL, 8),
(53, '2023-11-11 20:38:48', '2023-11-11 20:38:48', '1', 300, '2023-11-11', 'Mobile bill', '300', 'Online', NULL, 9),
(54, '2023-11-11 20:39:50', '2023-11-11 20:39:50', '1', 943, '2023-11-11', 'wifi bill', '943', 'Online', NULL, 9),
(55, '2023-11-17 14:29:41', '2023-11-17 14:29:41', '1', 3000, '2023-11-17', 'HIMANSHI PATEL', '3000', 'Online', NULL, 13),
(56, '2023-11-19 03:26:15', '2023-11-19 10:26:15', '1', 1150, '2023-11-14', 'CYLINDER', '1150', 'Online', NULL, 7),
(57, '2023-11-20 14:45:12', '2023-11-20 14:45:12', '1', 1087, '2023-11-30', 'dmart', '1087', 'Online', NULL, 4),
(58, '2023-11-21 14:30:24', '2023-11-21 14:30:24', '50', 50, '2023-11-20', 'table screw', '1', 'Online', NULL, 12),
(59, '2023-12-04 12:06:08', '2023-12-04 19:06:08', '1', 582, '2023-11-20', 'scooter service', '582', 'Online', NULL, 10),
(60, '2023-11-29 22:02:26', '2023-11-29 22:02:26', '1', 1100, '2023-11-28', 'cylinder', '1100', 'Online', NULL, 7),
(61, '2023-12-06 04:50:55', '2023-12-06 11:50:55', '1', 2980, '2023-11-30', 'sabji till 30  nov', '2980', 'Cash', NULL, 6),
(62, '2023-12-04 12:25:30', '2023-12-04 19:25:30', '1', 6000, '2023-11-01', 'bike payment', '6000', 'Online', NULL, 11),
(63, '2023-12-02 15:36:23', '2023-12-02 15:36:23', '1', 110000, '2023-11-30', 'DECEMBER RENT', '110000', 'Online', NULL, 15),
(64, '2023-12-02 15:37:35', '2023-12-02 15:37:35', '1', 6000, '2023-11-15', 'OCT BILL', '6000', 'Online', NULL, 14),
(65, '2023-12-06 04:58:21', '2023-12-06 11:58:21', '1', 1652, '2023-11-22', 'DMART', '1652', 'Online', NULL, 4),
(66, '2023-12-06 04:52:08', '2023-12-06 11:52:08', '1', 2346, '2023-11-30', 'shop bill', '2346', 'Online', NULL, 3),
(67, '2023-12-06 11:47:00', '2023-12-06 11:47:00', '1', 570, '2023-11-30', 'tub+gas pipe+mop', '570', 'Online', NULL, 10),
(68, '2023-12-06 11:47:20', '2023-12-06 11:47:20', '1', 400, '2023-11-30', 'gas stove repair', '400', 'Online', NULL, 10),
(69, '2023-12-06 11:49:15', '2023-12-06 11:49:15', '1', 150, '2023-11-30', 'petrol till 30', '150', 'Online', NULL, 5),
(70, '2023-12-06 11:52:36', '2023-12-06 11:52:36', '1', 175, '2023-11-30', 'futkar dairy', '175', 'Cash', NULL, 3),
(71, '2023-12-07 12:11:20', '2023-12-07 19:11:20', '1', 5732, '2023-12-01', 'dmart Online', '5732', 'Cash', NULL, 4),
(72, '2023-12-07 19:11:50', '2023-12-07 19:11:50', '1', 3978, '2023-12-07', 'dmart store', '3978', 'Cash', NULL, 4),
(73, '2023-12-08 10:32:16', '2023-12-08 10:32:16', '1', 800, '2023-12-07', 'kachra wala payment (oct & Nov)', '800', 'Cash', NULL, 10),
(74, '2023-12-10 13:50:25', '2023-12-10 13:50:25', '4', 16000, '2023-12-09', 'bed', '4000', 'Online', NULL, 11),
(75, '2023-12-10 13:51:08', '2023-12-10 13:51:08', '6', 20100, '2023-12-10', 'single almirah', '3350', 'Online', NULL, 11),
(76, '2023-12-12 13:09:34', '2023-12-12 13:09:34', '1', 12000, '2023-12-11', 'kishan salary', '12000', 'Online', NULL, 8),
(77, '2023-12-12 13:11:10', '2023-12-12 13:11:10', '1', 12000, '2023-12-11', 'dinesh salary', '12000', 'Online', NULL, 8),
(78, '2023-12-12 13:39:10', '2023-12-12 13:39:10', '1', 1000, '2023-12-05', 'anil transport', '1000', 'Online', NULL, 5),
(79, '2023-12-22 12:16:49', '2023-12-22 12:16:49', '1', 3000, '2023-12-18', 'sourav tiwari', '3000', 'Online', NULL, 13),
(80, '2023-12-27 10:21:59', '2023-12-27 10:21:59', '1', 110000, '2023-12-31', 'jan rent', '110000', 'Online', NULL, 15),
(81, '2023-12-28 11:32:48', '2023-12-28 18:32:48', '1', 1070, '2023-12-31', 'electricity work', '1070', 'Cash', NULL, 10),
(82, '2023-12-27 10:28:06', '2023-12-27 10:28:06', '1', 1243, '2023-12-08', 'wifi+mobile bill', '1243', 'Online', NULL, 9),
(83, '2023-12-27 10:28:55', '2023-12-27 10:28:55', '1', 2000, '2023-12-24', 'anil safai', '2000', 'Online', NULL, 8),
(84, '2023-12-27 10:30:14', '2023-12-27 10:30:14', '1', 3250, '2023-12-22', 'new cylinder', '3250', 'Online', NULL, 7),
(85, '2024-01-02 07:21:48', '2024-01-02 14:21:48', '1', 2000, '2023-12-22', 'sushant+ anil transport', '2000', 'Online', NULL, 5),
(86, '2023-12-27 10:37:57', '2023-12-27 10:37:57', '1', 3344, '2023-12-16', 'dmart online', '3344', 'Online', NULL, 4),
(87, '2023-12-27 10:40:40', '2023-12-27 10:40:40', '1', 1931, '2023-12-26', 'dmart store', '1931', 'Online', NULL, 4),
(88, '2023-12-27 10:49:46', '2023-12-27 10:49:46', '1', 1002, '2023-12-11', 'dmart stor', '1002', 'Cash', NULL, 4),
(89, '2023-12-27 03:56:09', '2023-12-27 10:56:09', '1', 3408, '2023-12-08', 'best price', '3408', 'Online', NULL, 4),
(90, '2023-12-27 10:59:49', '2023-12-27 10:59:49', '1', 1200, '2023-12-07', 'cylinder filling', '1200', 'Online', NULL, 7),
(91, '2023-12-27 11:00:22', '2023-12-27 11:00:22', '1', 1100, '2023-12-16', 'cylinder filling', '1100', 'Online', NULL, 7),
(92, '2023-12-31 07:56:49', '2023-12-31 14:56:49', '1', 6160, '2023-12-31', 'SABJI MANDI TILL 31', '6160', 'Online', NULL, 6),
(93, '2023-12-31 07:50:11', '2023-12-31 14:50:11', '1', 444, '2023-12-31', 'futkar dairy', '444', 'Online', NULL, 3),
(94, '2023-12-27 11:14:46', '2023-12-27 11:14:46', '1', 470, '2023-12-31', 'petrol', '470', 'Online', NULL, 5),
(95, '2023-12-27 11:15:48', '2023-12-27 11:15:48', '1', 90, '2023-12-09', 'plumbing valve', '90', 'Cash', NULL, 10),
(96, '2023-12-28 18:28:27', '2023-12-28 18:28:27', '1', 2010, '2024-01-01', 'electric work', '2010', 'Online', NULL, 10),
(97, '2023-12-31 13:06:41', '2023-12-31 13:06:41', '1', 900, '2023-12-30', 'camera repair', '900', 'Online', NULL, 10),
(98, '2023-12-31 14:46:21', '2023-12-31 14:46:21', '1', 1250, '2023-12-30', 'cylinder', '1250', 'Online', NULL, 7),
(99, '2023-12-31 14:47:12', '2023-12-31 14:47:12', '1', 350, '2023-12-28', 'chhota cylinder', '350', 'Online', NULL, 7),
(100, '2023-12-31 15:00:34', '2023-12-31 15:00:34', '1', 4704, '2023-12-31', 'Shop bill', '4704', 'Online', NULL, 3),
(102, '2024-01-02 08:09:27', '2024-01-02 15:09:27', '2', 1000, '2023-12-22', 'blanket', '500', 'Online', NULL, 11),
(103, '2024-01-02 13:16:50', '2024-01-02 13:16:50', '1', 12000, '2023-12-10', 'DECEMBER RENT', '12000', 'Online', NULL, 14),
(104, '2024-01-05 14:18:52', '2024-01-05 14:18:52', '1', 6287, '2024-01-01', 'dmart online', '6287', 'Online', NULL, 4),
(105, '2024-01-05 14:18:52', '2024-01-05 14:18:52', '1', 6287, '2024-01-01', 'dmart online', '6287', 'Online', NULL, 4);

-- --------------------------------------------------------

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `category_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` (`id`, `created_at`, `updated_at`, `category_name`) VALUES
(3, '2023-10-02 09:35:49', '2023-10-02 09:35:49', 'DAIRY'),
(4, '2023-10-02 09:36:32', '2023-10-02 09:36:32', 'KIRANA'),
(5, '2023-10-02 09:36:45', '2023-10-02 09:36:45', 'TRANSPORT'),
(6, '2023-10-02 09:37:02', '2023-10-02 09:37:02', 'SABJI'),
(7, '2023-10-02 09:37:14', '2023-10-02 09:37:14', 'CYLINDER'),
(8, '2023-10-02 09:37:36', '2023-10-02 09:37:36', 'SALARY'),
(9, '2023-10-02 09:39:12', '2023-10-02 09:39:12', 'BILLS'),
(10, '2023-10-02 09:40:03', '2023-10-02 09:40:03', 'MAINTANANCE'),
(11, '2023-10-14 14:50:16', '2023-10-14 21:50:16', 'PURCHASES'),
(12, '2023-10-14 21:51:04', '2023-10-14 21:51:04', 'OTHERS'),
(13, '2023-11-17 14:29:06', '2023-11-17 14:29:06', 'CM REFUNDS'),
(14, '2023-11-30 12:56:45', '2023-11-30 12:56:45', 'electricity bill'),
(15, '2023-12-02 15:35:16', '2023-12-02 15:35:16', 'BUILDING RENT');

-- --------------------------------------------------------

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `gallerydate` date NOT NULL,
  `gallerytype` varchar(25) DEFAULT NULL,
  `roomnogallery` varchar(25) DEFAULT NULL,
  `imageupload` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `itemcode` varchar(255) DEFAULT NULL,
  `itemname` varchar(255) NOT NULL,
  `rate` double NOT NULL,
  `tax` double NOT NULL,
  `amount` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `created_at`, `updated_at`, `itemcode`, `itemname`, `rate`, `tax`, `amount`) VALUES
(1, '2023-09-30 20:57:57', '2023-09-30 20:57:57', '0', 'electricity bill', 12, 0, 12),
(2, '2023-09-30 13:59:36', '2023-09-30 20:59:36', '0', 'Food (breakfast, lunch & dinner)', 3000, 0, 3000),
(3, '2023-09-30 21:00:08', '2023-09-30 21:00:08', '0', 'rent delay penalty', 100, 0, 100),
(4, '2023-09-30 21:00:50', '2023-09-30 21:00:50', '4', 'cooler rent', 500, 0, 500),
(5, '2023-09-30 21:01:50', '2023-09-30 21:01:50', '5', 'food waste penalty', 50, 0, 50),
(6, '2023-10-02 10:01:26', '2023-10-02 10:01:26', '0', 'Registration', 500, 0, 500),
(7, '2023-10-02 10:01:50', '2023-10-02 10:01:50', '0', 'Caution money', 3000, 0, 3000),
(8, '2023-10-07 20:00:32', '2023-10-07 20:00:32', '8', 'Room rent/day (with food)', 500, 0, 500),
(9, '2023-10-07 20:01:08', '2023-10-07 20:01:08', '9', 'Room rent/day (without food)', 350, 0, 350),
(11, '2023-10-17 02:44:13', '2023-10-17 09:44:13', 'SSG10', 'Food (lunch/dinner)', 1650, 0, 1650),
(12, '2023-10-17 09:43:55', '2023-10-17 09:43:55', 'SSG11', 'Food (breakfast)', 900, 0, 900),
(13, '2023-11-07 17:03:10', '2023-11-07 17:03:10', '12', 'non entry penalty', 100, 0, 100),
(14, '2023-11-13 12:30:15', '2023-11-13 12:30:15', 'SSG13', 'Food (lunch/dinner) (single meal)', 80, 0, 80),
(15, '2023-11-13 12:32:00', '2023-11-13 12:32:00', 'SSG14', 'Food (breakfast)(single meal)', 25, 0, 25),
(16, '2023-11-30 15:48:06', '2023-11-30 15:48:06', '007', 'food plate penalty', 200, 0, 200);

-- --------------------------------------------------------

--
-- Table structure for table `leadmanagers`
--

CREATE TABLE `leadmanagers` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `leaddate` date NOT NULL,
  `leadcandidatename` text NOT NULL,
  `leadmobile` varchar(12) NOT NULL,
  `leadmail` varchar(25) DEFAULT NULL,
  `requirement` varchar(255) DEFAULT NULL,
  `budget` varchar(255) DEFAULT NULL,
  `leadstatus` int(11) NOT NULL DEFAULT '0',
  `lead_source` varchar(255) DEFAULT NULL,
  `location` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `leadmanagers`
--

INSERT INTO `leadmanagers` (`id`, `created_at`, `updated_at`, `leaddate`, `leadcandidatename`, `leadmobile`, `leadmail`, `requirement`, `budget`, `leadstatus`, `lead_source`, `location`) VALUES
(1, '2023-10-01 07:27:27', '2023-10-01 14:27:27', '2023-10-01', 'pranjal kothari', '9165319801', 'asr.official0012gmail.com', '2 sharing for 2 girls without food', '4000-5000', 0, NULL, NULL),
(2, '2023-10-01 07:28:59', '2023-10-01 14:28:59', '2023-10-01', 'rishabh jain', '9479627881', 'asr.official0012gmail.com', '2 sharing for 2 boys without food or with food', '4000-5000', 0, NULL, NULL),
(3, '2023-10-01 07:57:37', '2023-10-01 14:57:37', '2023-10-26', 'krish menon', '7669010541', 'asr.official0012gmail.com', 'required triple seater room', '4500-5000', 0, NULL, NULL),
(4, '2023-10-01 07:58:33', '2023-10-01 14:58:33', '2023-10-01', 'yashika patel', '9770894344', 'asr.official0012gmail.com', 'required double seater room', '7000-8000', 0, NULL, NULL),
(5, '2023-10-01 08:01:04', '2023-10-01 15:01:04', '2023-10-01', 'anushka singh', '7666974326', 'asr.official0012gmail.com', 'required double seater room', '7000-9000', 0, NULL, NULL),
(6, '2023-10-01 09:10:48', '2023-10-01 15:03:47', '2023-10-01', 'shreya vishwakarma', '9302566341', 'asr.official0012gmail.com', 'required double sharing', '6000-7000', 1, NULL, NULL),
(7, '2023-10-01 08:43:35', '2023-10-01 15:43:35', '2023-10-01', 'kamal jain', '9303022395', 'asr.official0012gmail.com', 'required 2 shareing', '5000-6000', 0, NULL, NULL),
(8, '2023-10-03 05:55:33', '2023-10-03 12:55:33', '2023-10-02', 'Anushka Singh', '7666974326', 'SSG@gmail.com', 'double sharing', '6000-7000', 0, NULL, NULL),
(9, '2023-10-03 07:44:23', '2023-10-03 14:44:23', '2023-10-02', 'Nandini patel', '8962036963', 'Smart co-living indore', '3 sharing for 3 girls with food', '7500', 0, NULL, NULL),
(10, '2023-10-03 07:46:43', '2023-10-03 14:46:43', '2023-10-02', 'Nitin Solanki', '6264461413', 'Smart co-living indore', '2 seater / 3 seater with food room 101', '8500', 0, NULL, NULL),
(12, '2023-10-05 12:10:41', '2023-10-03 17:59:08', '2023-10-03', 'Himanshi sethi', '9981306146', 'Smart co-living indore', '3 seater 204 1 month', '7000-8000', 1, NULL, NULL),
(14, '2023-10-04 06:52:26', '2023-10-04 13:52:26', '2023-10-04', 'Akansha pandey', '9893399738', 'Smart co-living indore', '2 seater', '6000-7000', 0, NULL, NULL),
(15, '2023-10-04 06:53:50', '2023-10-04 13:53:50', '2023-10-03', 'Pratham tanwani', '7470564065', 'Smart co-living indore', '3 seater', '6000-7500', 0, NULL, NULL),
(16, '2023-10-05 04:18:43', '2023-10-05 11:18:43', '2023-10-04', 'Madhav mjavdiya', '9424601711', 'Smart co- living indore', '2 seater 111', '7000-8000', 0, NULL, NULL),
(17, '2023-10-05 04:20:29', '2023-10-05 11:20:29', '2023-10-04', 'Sagar Gupta', '7489309755', 'Smart co-living indore', '2 seater', '7000-8000', 0, NULL, NULL),
(22, '2023-10-05 05:35:41', '2023-10-05 12:33:45', '2023-10-06', 'manshi patel', '9302547255', 'asr.official0012gmail.com', 'required 2 seater room', '8000-9000', 1, NULL, NULL),
(23, '2023-10-05 06:10:17', '2023-10-05 13:10:17', '2023-10-05', 'pragya sharma', '7354568367', 'ssg@gmail.com', 'single or double sharing', '8-10k', 0, NULL, NULL),
(24, '2023-10-05 10:03:02', '2023-10-05 17:03:02', '2023-10-05', 'Sejal Sharma', '7000724355', 'ssg@gmail.com', '2 seater expected by 10 oct', '8000-9000', 0, NULL, NULL),
(25, '2023-10-05 10:04:47', '2023-10-05 17:04:47', '2023-10-05', 'Lovesh sharma', '6353233958', 'ssg@gmail.com', '2 seater', '8000-9000', 0, NULL, NULL),
(26, '2023-10-05 10:10:37', '2023-10-05 17:10:37', '2023-10-05', 'Vipin Agarwal (father)', '7987109389', 'ssg@gmail.com', '2 seater for girls', '8000-9000', 0, NULL, NULL),
(27, '2023-10-06 05:21:01', '2023-10-06 12:21:01', '2023-10-06', 'Jheel Jain', '7022950650', 'Ssg@gmail.com', '2 seater room 210', '8000-9000', 0, NULL, NULL),
(28, '2023-10-06 05:22:24', '2023-10-06 12:22:24', '2023-10-06', 'Suhana parihar', '6265086305', 'Ssg@gmail.com', '3 seater 204', '7000-8000', 0, NULL, NULL),
(30, '2023-10-09 06:22:04', '2023-10-09 13:22:04', '2023-10-08', 'Isha chourisa', '7610632319', 'Ssg@gmail.com', '2 seater', '8000-9000', 0, NULL, NULL),
(31, '2023-10-10 05:51:40', '2023-10-10 12:51:40', '2023-10-10', 'Shahista khan', '9575312542', 'Ssg@gmail.com', '2 seater', '8000-9000', 0, NULL, NULL),
(32, '2023-10-12 13:44:05', '2023-10-12 20:44:05', '2023-10-12', 'leecha', '9691443436', 'ssg@indore', 'triple', '7500', 0, NULL, NULL),
(33, '2023-10-14 10:54:48', '2023-10-14 17:54:48', '2023-10-14', 'Anshu yadav', '8817876618', 'Ssg@gmailcom', '2 seater', '7000-9000', 0, NULL, NULL),
(34, '2023-10-14 10:56:18', '2023-10-14 17:56:18', '2023-10-14', 'Anshu yadav', '8817876618', 'Ssg@ gmail.com', '2 seater', '7000-9000', 0, NULL, NULL),
(35, '2023-10-14 10:57:45', '2023-10-14 17:57:45', '2023-10-14', 'Anshu Yadav', '8817876618', 'Ssg@ gmail.com', '2 seater exp 15 oct', '8000', 0, NULL, NULL),
(36, '2023-10-17 14:18:47', '2023-10-17 21:18:47', '2023-10-17', 'pratiksha nigam', '9109444577', 'asr.official0012gmail.com', '106 double sharing', '8500', 0, NULL, NULL),
(37, '2023-11-21 07:55:04', '2023-11-21 14:55:04', '2023-11-19', 'jaya parwani', '0779149828', 'ssg@indore', '2 seater pref 210', '9000', 0, NULL, 'indore'),
(38, '2023-11-30 06:45:30', '2023-11-30 13:45:30', '2023-11-29', 'bhumi', '9302347225', 'ssg@indore', '2 seats in double share', '5500-6000', 0, NULL, 'LIG indore'),
(39, '2023-12-02 09:10:57', '2023-12-02 16:10:57', '2023-12-02', 'sakshi chaturvedi', '7692911621', 'ssg@indore', '1 seater', '11k', 0, NULL, 'indore');

-- --------------------------------------------------------

--
-- Table structure for table `leave_applications`
--

CREATE TABLE `leave_applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `leave_id` bigint(20) UNSIGNED DEFAULT NULL,
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `leave_masters`
--

CREATE TABLE `leave_masters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `leave_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `leave_status` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `masterroomseats`
--

CREATE TABLE `masterroomseats` (
  `id` int(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `masterroomtype` varchar(255) NOT NULL,
  `masterroomseat` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `mealtypes`
--

CREATE TABLE `mealtypes` (
  `id` int(11) NOT NULL,
  `category_name` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mealtypes`
--

INSERT INTO `mealtypes` (`id`, `category_name`, `status`) VALUES
(1, 'Breakfast', 1),
(2, 'Lunch', 1),
(3, 'Brunch', 1),
(4, 'Dinner', 1);

-- --------------------------------------------------------

--
-- Table structure for table `menuitems`
--

CREATE TABLE `menuitems` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `menuitemcode` int(25) NOT NULL,
  `catid` varchar(255) DEFAULT NULL,
  `menuitemname` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menuitems`
--

INSERT INTO `menuitems` (`id`, `created_at`, `updated_at`, `menuitemcode`, `catid`, `menuitemname`) VALUES
(1, '2023-10-21 20:07:39', '2023-10-21 20:07:39', 100, '1', 'Samosa'),
(2, '2023-10-21 20:08:15', '2023-10-21 20:08:15', 101, '2', 'Chapati'),
(3, '2023-10-21 20:08:15', '2023-10-21 20:08:15', 101, '4', 'Chapati'),
(4, '2023-10-21 20:09:05', '2023-10-21 20:09:05', 103, '1', 'Idli Sambhar');

-- --------------------------------------------------------

--
-- Table structure for table `menu_images`
--

CREATE TABLE `menu_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `menuImages` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `olddataregisters`
--

CREATE TABLE `olddataregisters` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `formno` int(25) DEFAULT NULL,
  `roomno` int(25) NOT NULL,
  `seetno` int(25) NOT NULL,
  `date` date NOT NULL,
  `candidatename` text NOT NULL,
  `dob` date NOT NULL,
  `valid` varchar(25) NOT NULL,
  `phone` varchar(25) NOT NULL,
  `email` varchar(255) NOT NULL,
  `blood` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `healthissue` varchar(255) NOT NULL,
  `stydrt` varchar(255) NOT NULL,
  `fathername` varchar(255) NOT NULL,
  `fatheroocc` varchar(255) NOT NULL,
  `mothername` varchar(255) NOT NULL,
  `motheroocc` varchar(255) NOT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobilenumber` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pemail` varchar(155) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fullAddress` text,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pinno` varchar(25) NOT NULL,
  `guardianname` varchar(255) NOT NULL,
  `guardiannumber` varchar(15) NOT NULL,
  `guardianaddress` varchar(500) NOT NULL,
  `uploadimage` varchar(500) NOT NULL,
  `uploadaadharfront` varchar(500) NOT NULL,
  `uploadaadharback` varchar(500) NOT NULL,
  `health_description` varchar(255) DEFAULT NULL,
  `vehicledescription` varchar(255) DEFAULT NULL,
  `vehicalno` varchar(255) NOT NULL,
  `institutename` varchar(255) DEFAULT NULL,
  `coursename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coursedetails` varchar(255) DEFAULT NULL,
  `jobdetails` varchar(255) DEFAULT NULL,
  `institute` varchar(255) NOT NULL,
  `companyname` varchar(255) DEFAULT NULL,
  `leave_date` date DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `ChangeRoomStatus` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `olddataregisters`
--

INSERT INTO `olddataregisters` (`id`, `created_at`, `updated_at`, `formno`, `roomno`, `seetno`, `date`, `candidatename`, `dob`, `valid`, `phone`, `email`, `blood`, `healthissue`, `stydrt`, `fathername`, `fatheroocc`, `mothername`, `motheroocc`, `tel`, `mobilenumber`, `pemail`, `fullAddress`, `state`, `pinno`, `guardianname`, `guardiannumber`, `guardianaddress`, `uploadimage`, `uploadaadharfront`, `uploadaadharback`, `health_description`, `vehicledescription`, `vehicalno`, `institutename`, `coursename`, `coursedetails`, `jobdetails`, `institute`, `companyname`, `leave_date`, `status`, `ChangeRoomStatus`) VALUES
(3, '2023-11-07 10:54:37', '2023-11-07 10:54:37', 4, 204, 2, '2023-10-03', 'Himanshi sethi', '2005-03-22', '289022814954', '9981306146', 'himanshisethi05@gmail.com', 'A+', 'no', '1 month', 'Shailendra sethi', 'Businesses man', 'Preeti sethi', 'Housewife', '9424037070', '9424070307', NULL, 'SSG', 'Madhya Pradesh', '458441', 'Priyanka chabbra', '9424513614', '109,Mangal marg,Gandhi magar', '1696599257.2000379828.jpeg', '', '', '', '', 'no', 'Renaissance', 'coursetype', 'Bba', '', 'institute Name', NULL, '2023-11-03', 0, 0),
(4, '2023-12-10 11:41:38', '2023-12-04 13:33:17', 29, 209, 1, '2023-10-11', 'Ayushi Singh', '1999-07-05', '458216983897', '7985959240', 'SAYU6435@GMAIL.COM', 'A+', 'yes', '3 month', 'MR I P SINGH', 'CIVIL ENGINEER', 'MRS NEELAM SINGH', 'house wife', '7082719356', NULL, NULL, 'AZIZ NAGAR, MOHIBULLAHPUR, NEAR BAL NIKUNJ COLLEGE, LUCKNOW', 'UTTAR PRADESH', '226021', 'MR I P SINGH', '7082719356', 'AZIZ NAGAR, MOHIBULLAHPUR, NEAR BAL NIKUNJ COLLEGE, LUCKNOW', '1697042220.692138357.jpeg', '', '', 'MIGRANE', NULL, 'no', 'CIBOM', 'jobtype', NULL, 'COMMUNICATION CENTER', 'Comapany Name', 'CIBOM', '2023-11-28', 0, 0),
(5, '2023-12-08 16:54:33', '2023-12-08 16:54:33', 8, 105, 2, '2023-10-09', 'Sourav Tiwari', '2000-01-01', '916753769700', '7694830910', 'souravtiwari1108@gmail.com', 'B+', 'no', '2', 'Sn Tiwari', 'Service man', 'Saroj Tiwari', 'Housewife', '8355064470', NULL, NULL, 'C 51 Tirupati Abhinav homes Bhopal', 'Mp', '462010', 'Sn Tiwari', '8355064470', 'C 51 Tirupati Abhinav homes Bhopal , Mp, 462010', '1696916221.1699889951.jpeg', '', '', '', '', 'no', 'Taskus', 'jobtype', '', 'Bpo', 'institute Name', NULL, '2023-12-08', 0, 0),
(6, '2024-01-02 14:47:01', '2024-01-02 14:47:01', 7, 105, 1, '2023-10-09', 'Sourabh soni', '1999-07-31', '916525258512', '9630115121', 'sourabhsoni9157@gmail.com', 'A+', 'no', '2', 'Ashok Kumar soni', 'Business', 'Nirmala', 'Housewife', '9630115121', '9977634498', NULL, '428 - A Devi Ji square, Amjhera (Dhar)', 'Madhya pradesh', '454441', 'Ashok soni', '9977634498', 'Devi Ji square, Amjhera (Dhar)', '1696915650.1909677330.jpeg', '', '', NULL, 'Mp11nd9666', 'yes', NULL, 'jobtype', NULL, 'It', 'Comapany Name', 'Task us', '2023-12-08', 0, 0),
(8, '2024-01-06 14:35:14', '2024-01-06 14:35:14', 31, 108, 2, '2023-12-08', 'Bhadrayu Singh Panwar', '1998-01-09', '597432266838', '6262330039', 'panwarbhadrayu@gmail.com', 'B+', 'no', '1', 'Rajendra Singh Panwar', 'Government servent', 'Mithlesh panwar', 'House wife', '6262330039', NULL, 'panwarbhadrayu@gmail.com', 'House no 1719 basant bahar colony khandwa MadhyaPradesh', 'Rajendra Singh Panwar', '450001', 'Rajendra panwar', '9754950435', 'House no 1719 basant bahar colony khandwa MadhyaPradesh', '1702295019.1468477655.jpg', '1702295019.33915886.jpg', '1702295019.1017799478.jpg', NULL, NULL, 'no', 'Orlando', 'coursetype', 'Pgdac', NULL, 'instituteName', NULL, '2024-01-05', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL,
  `permissionType` varchar(255) DEFAULT NULL,
  `permission` tinyint(1) DEFAULT '0',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `permissionType`, `permission`, `updated_at`, `created_at`) VALUES
(1, 'Desktop Whatsapp', 1, '2023-12-28 12:37:17', '2023-12-27 11:08:36');

-- --------------------------------------------------------

--
-- Table structure for table `recieve_amounts`
--

CREATE TABLE `recieve_amounts` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `receiveDate` date DEFAULT NULL,
  `candidateID` int(11) DEFAULT NULL,
  `invoiceNo` int(11) DEFAULT NULL,
  `pandingAmount` float DEFAULT NULL,
  `receiveAmount` float DEFAULT NULL,
  `paymentMode` varchar(255) DEFAULT NULL,
  `unused` float DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recieve_amounts`
--

INSERT INTO `recieve_amounts` (`id`, `created_at`, `updated_at`, `receiveDate`, `candidateID`, `invoiceNo`, `pandingAmount`, `receiveAmount`, `paymentMode`, `unused`) VALUES
(6, '2023-10-06 21:04:52', '2023-10-06 21:04:52', '2023-10-01', 3, 1, 7500, 3500, 'cash', 0),
(10, '2023-10-07 13:02:01', '2023-10-07 13:02:01', '2023-10-06', 4, 5, 11900, 11900, 'cash', 0),
(11, '2023-10-07 13:03:27', '2023-10-07 13:03:27', '2023-10-03', 5, 4, 11000, 11000, 'cash', 0),
(19, '2023-10-17 09:16:11', '2023-10-17 09:16:11', '2023-10-12', 18, 7, 0, 11900, 'cash', 0),
(21, '2023-10-17 09:20:06', '2023-10-17 09:20:06', '2023-10-08', 17, 9, 0, 11900, 'cash', 0),
(22, '2023-10-17 09:21:40', '2023-10-17 09:21:40', '2023-10-04', 8, 8, 12500, 12500, 'cash', 0),
(23, '2023-10-17 09:22:09', '2023-10-17 09:22:09', '2023-10-06', 6, 6, 11900, 11900, 'cash', 0),
(25, '2023-10-17 09:26:34', '2023-10-17 09:26:34', '2023-10-11', 20, 11, 0, 11900, 'cash', 0),
(26, '2023-10-17 09:28:03', '2023-10-17 09:28:03', '2023-10-10', 14, 12, 9900, 2000, 'cash', 0),
(27, '2023-10-17 09:30:14', '2023-10-17 09:30:14', '2023-10-11', 16, 13, 0, 10700, 'cash', 0),
(29, '2023-10-17 09:34:43', '2023-10-17 09:34:43', '2023-10-11', 12, 15, 0, 10600, 'cash', 0),
(30, '2023-10-17 09:35:49', '2023-10-17 09:35:49', '2023-10-11', 13, 14, 10600, 10600, 'cash', 0),
(31, '2023-10-17 09:37:29', '2023-10-17 09:37:29', '2023-10-13', 19, 16, 0, 11000, 'cash', 0),
(36, '2023-10-17 10:42:54', '2023-10-17 10:42:54', '2023-10-17', 3, 1, NULL, 3750, 'online', 0),
(38, '2023-10-17 11:01:19', '2023-10-17 11:01:19', '2023-10-16', 21, 19, 4200, 7700, 'cash', 0),
(39, '2023-10-17 21:24:21', '2023-10-17 21:24:21', '2023-10-17', 14, 12, NULL, 9900, 'cash', 0),
(40, '2023-10-17 21:30:29', '2023-10-17 21:30:29', '2023-10-01', 1, 2, 2750, 8000, 'cash', 0),
(41, '2023-10-22 12:42:10', '2023-10-22 12:42:10', '2023-10-09', 15, 10, 12500, 12500, 'cash', 0),
(42, '2023-11-07 09:29:57', '2023-11-07 09:29:57', '2023-10-17', 3, 1, NULL, 3750, 'cash', 0),
(43, '2023-11-07 09:30:53', '2023-11-07 09:30:53', '2023-10-17', 1, 2, NULL, 2750, 'cash', 0),
(45, '2023-11-11 19:56:49', '2023-11-11 19:56:49', '2023-11-09', 21, 19, NULL, 4200, 'cash', 0),
(46, '2023-11-11 19:57:38', '2023-11-11 19:57:38', '2023-11-08', 4, 24, NULL, 5400, 'cash', 0),
(47, '2023-11-11 20:01:57', '2023-11-11 20:01:57', '2023-11-07', 6, 23, NULL, 8100, 'cash', 0),
(48, '2023-11-11 20:02:19', '2023-11-11 20:02:19', '2023-11-07', 17, 26, NULL, 8400, 'cash', 0),
(49, '2023-11-11 20:05:43', '2023-11-11 20:05:43', '2023-11-07', 3, 22, NULL, 4500, 'online', 0),
(51, '2023-11-11 20:11:37', '2023-11-11 20:11:37', '2023-10-09', 9, 17, 8000, 8000, 'cash', 0),
(52, '2023-11-16 14:09:15', '2023-11-16 14:09:15', '2023-11-15', 1, 21, NULL, 7500, 'cash', 0),
(53, '2023-11-17 12:59:35', '2023-11-17 12:59:35', '2023-11-16', 20, 28, NULL, 6000, 'cash', 0),
(54, '2023-11-17 13:01:33', '2023-11-17 13:01:33', '2023-10-31', 16, 36, 660, 660, 'cash', 0),
(55, '2023-11-17 13:03:03', '2023-11-17 13:03:03', '2023-11-16', 16, 30, NULL, 7200, 'cash', 0),
(56, '2023-11-17 13:07:09', '2023-11-17 13:07:09', '2023-11-17', 15, 27, NULL, 6000, 'cash', 0),
(57, '2023-11-17 13:29:22', '2023-11-17 13:29:22', '2023-11-16', 14, 29, NULL, 8400, 'cash', 0),
(58, '2023-11-18 11:17:55', '2023-11-18 11:17:55', '2023-11-17', 18, 38, NULL, 8400, 'cash', 0),
(59, '2023-11-18 11:19:39', '2023-11-18 11:19:39', '2023-11-16', 23, 41, 0, 11900, 'cash', 0),
(60, '2023-11-18 11:26:50', '2023-11-18 11:26:50', '2023-11-16', 19, 37, NULL, 7500, 'cash', 0),
(62, '2023-11-18 14:09:32', '2023-11-18 14:09:32', '2023-11-16', 24, 43, 0, 11900, 'cash', 0),
(63, '2023-11-18 14:23:12', '2023-11-18 14:23:12', '2023-11-13', 8, 34, 900, 900, 'online', 0),
(64, '2023-11-18 14:24:04', '2023-11-18 14:24:04', '2023-11-04', 8, 25, 9000, 9000, 'online', 0),
(69, '2023-11-20 14:23:04', '2023-11-20 14:23:04', '2023-11-09', 10, 39, 4500, 4500, 'online', 0),
(70, '2023-11-20 14:25:54', '2023-11-20 14:25:54', '2023-10-09', 10, 18, 9485, 9485, 'online', 0),
(71, '2023-11-20 14:27:55', '2023-11-20 14:27:55', '2023-11-09', 9, 40, 4500, 4500, 'online', 0),
(73, '2023-11-21 14:26:01', '2023-11-21 14:26:01', '2023-11-20', 26, 49, 8900, 8900, 'cash', 0),
(74, '2023-11-23 21:20:49', '2023-11-23 21:20:49', '2023-11-11', 12, 31, 7300, 7300, 'online', 0),
(75, '2023-11-23 21:21:35', '2023-11-23 21:21:35', '2023-11-16', 21, 50, 0, 4200, 'online', 1),
(78, '2023-11-29 21:56:22', '2023-11-29 21:56:22', '2023-11-11', 13, 32, 7300, 7300, 'online', 0),
(79, '2023-11-30 13:42:19', '2023-11-30 13:42:19', '2023-11-16', 27, 52, 10800, 10800, 'cash', 0),
(80, '2023-12-02 14:44:17', '2023-12-02 14:44:17', '2023-12-02', 3, 22, NULL, 3000, 'cash', 0),
(84, '2023-12-04 15:50:09', '2023-12-04 15:50:09', '2023-12-12', 18, 58, 8400, 8400, 'cash', 0),
(89, '2023-12-04 18:41:12', '2023-12-04 18:41:12', '2023-10-26', 22, 20, 9500, 9500, 'online', 0),
(91, '2023-12-06 13:10:33', '2023-12-06 13:10:33', '2023-12-05', 1, 92, NULL, 7500, 'cash', 0),
(92, '2023-12-06 19:40:15', '2023-12-06 19:40:15', '2023-12-06', 30, 93, 0, 11900, 'cash', 0),
(93, '2023-12-06 19:51:04', '2023-12-06 19:51:04', '2023-12-06', 29, 94, 0, 11500, 'online', 0),
(94, '2023-12-06 19:59:52', '2023-12-06 19:59:52', '2023-12-05', 3, 72, NULL, 7500, 'online', 0),
(95, '2023-12-07 12:32:44', '2023-12-07 12:32:44', '2023-12-02', 21, 61, 8400, 8400, 'online', 0),
(96, '2023-12-07 12:37:18', '2023-12-07 12:37:18', '2023-12-04', 8, 73, 9000, 9000, 'online', 0),
(98, '2023-12-07 15:23:44', '2023-12-07 15:23:44', '2023-11-24', 28, 96, 0, 11000, 'cash', 0),
(99, '2023-12-09 11:28:32', '2023-12-09 11:28:32', '2023-12-06', 4, 63, 6000, 6000, 'online', 0),
(100, '2023-12-09 11:30:28', '2023-12-09 11:30:28', '2023-12-08', 17, 64, 6000, 6000, 'online', 0),
(102, '2023-12-09 11:32:42', '2023-12-09 11:32:42', '2023-12-06', 6, 62, 8400, 8400, 'online', 0),
(103, '2023-12-09 11:33:27', '2023-12-09 11:33:27', '2023-11-20', 25, 95, 11900, 11900, 'online', 0),
(104, '2023-12-09 14:33:13', '2023-12-09 14:33:13', '2023-12-09', 31, 97, 0, 11900, 'online', 0),
(105, '2023-12-11 15:51:22', '2023-12-11 15:51:22', '2023-12-11', 33, 98, NULL, 11900, 'cash', 0),
(106, '2023-12-11 18:47:56', '2023-12-11 18:47:56', '2023-12-08', 34, 99, 0, 11900, 'online', 0),
(107, '2023-12-12 13:13:07', '2023-12-12 13:13:07', '2023-12-11', 10, 65, NULL, 4500, 'online', 0),
(108, '2023-12-12 13:13:17', '2023-12-12 13:13:17', '2023-12-12', 15, 67, NULL, 6000, 'online', 0),
(109, '2023-12-13 15:29:28', '2023-12-13 15:29:28', '2023-12-13', 36, 105, NULL, 11000, 'online', 0),
(110, '2023-12-15 11:03:31', '2023-12-15 11:03:31', '2023-12-15', 37, 106, NULL, 14500, 'online', 0),
(111, '2023-12-19 12:29:49', '2023-12-19 12:29:49', '2023-12-19', 22, 53, NULL, 6000, 'online', 0),
(112, '2023-12-19 12:30:28', '2023-12-19 12:30:28', '2023-12-19', 22, 91, NULL, 900, 'cash', 0),
(113, '2023-12-19 13:20:31', '2023-12-19 13:20:31', '2023-12-17', 38, 110, 0, 12500, 'cash', 0),
(114, '2023-12-19 13:25:21', '2023-12-19 13:25:21', '2023-12-16', 20, 101, NULL, 6000, 'online', 0),
(115, '2023-12-19 13:26:08', '2023-12-19 13:26:08', '2023-12-17', 19, 102, NULL, 7500, 'online', 0),
(116, '2023-12-19 13:27:39', '2023-12-19 13:27:39', '2023-12-18', 12, 104, NULL, 7300, 'online', 0),
(117, '2023-12-20 14:20:27', '2023-12-20 14:20:27', '2023-12-10', 14, 100, 8400, 8400, 'online', 0),
(118, '2023-12-22 12:11:24', '2023-12-22 12:11:24', '2023-12-22', 39, 115, NULL, 11900, 'online', 0),
(119, '2023-12-25 12:27:44', '2023-12-25 12:27:44', '2023-12-21', 23, 107, NULL, 8400, 'online', 0),
(121, '2023-12-25 12:30:46', '2023-12-25 12:30:46', '2023-12-22', 13, 103, NULL, 7300, 'online', 0),
(122, '2023-12-31 13:08:07', '2023-12-31 13:08:07', '2023-12-28', 24, 109, NULL, 8400, 'online', 0),
(123, '2023-12-31 13:10:25', '2023-12-31 13:10:25', '2023-12-21', 27, 108, NULL, 7300, 'online', 0),
(124, '2023-12-31 14:22:22', '2023-12-31 14:22:22', '2023-12-31', 25, 120, 1780, 2700, 'online', 0),
(125, '2024-01-02 13:12:42', '2024-01-02 13:12:42', '2023-12-31', 26, 123, 0, 780, 'online', 0),
(126, '2024-01-02 13:14:01', '2024-01-02 13:14:01', '2023-12-31', 28, 116, NULL, 7500, 'online', 0),
(127, '2024-01-02 14:41:05', '2024-01-02 14:41:05', '2023-12-10', 35, 126, 0, 12500, 'online', 0),
(128, '2024-01-04 11:56:12', '2024-01-04 11:56:12', '2024-01-03', 26, 113, NULL, 5400, 'online', 0),
(129, '2024-01-07 10:09:50', '2024-01-07 10:09:50', '2024-01-06', 22, 117, NULL, 6000, 'online', 0),
(130, '2024-01-07 10:10:17', '2024-01-07 10:10:17', '2024-01-06', 22, 122, NULL, 2280, 'online', 0),
(131, '2024-01-07 10:13:06', '2024-01-07 10:13:06', '2024-01-04', 3, 129, NULL, 8000, 'online', 0),
(132, '2024-01-07 10:21:16', '2024-01-07 10:21:16', '2024-01-01', 1, 137, 0, 7500, 'cash', 0);

-- --------------------------------------------------------

--
-- Table structure for table `registers`
--

CREATE TABLE `registers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `formNo` int(255) NOT NULL,
  `roomNo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `seetNo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `condidate_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `DOB` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ValidID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Phone` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `blood` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `other` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `VehicalNo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `CourseName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instituteName` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fatherName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `father_occ` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `motherName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mother_occ` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobileNumber` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `emailg` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `houseNo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secter` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `street` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `district` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pinNo` int(255) NOT NULL,
  `GuardianName` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `GuardianNumber` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Guardianaddress` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `CDTsignature` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PRTsignature` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `WDNsignature` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `roomseats`
--

CREATE TABLE `roomseats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `roomno` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roomtype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `numberseats` int(255) NOT NULL,
  `nocandidate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roomseats`
--

INSERT INTO `roomseats` (`id`, `created_at`, `updated_at`, `roomno`, `roomtype`, `numberseats`, `nocandidate`, `rent`) VALUES
(1, '2023-09-30 16:27:52', '2023-10-10 21:38:15', '101', 'attached', 3, '0', '5000'),
(2, '2023-09-30 16:29:10', '2023-09-30 16:29:10', '102', 'attached', 2, '0', '6000'),
(4, '2023-09-30 16:29:36', '2023-09-30 16:30:04', '103', 'attached', 3, '0', '5000'),
(5, '2023-09-30 16:30:41', '2023-09-30 16:30:41', '104', 'attached', 2, '0', '6000'),
(6, '2023-09-30 16:31:15', '2023-09-30 16:31:15', '105', 'attached', 3, '0', '5000'),
(9, '2023-09-30 16:34:09', '2023-09-30 16:34:09', '106', 'attached', 2, '0', '6000'),
(10, '2023-09-30 16:34:24', '2023-09-30 16:34:24', '107', 'attached', 2, '0', '6000'),
(11, '2023-09-30 16:34:57', '2023-09-30 16:34:57', '108', 'attached', 2, '0', '6000'),
(12, '2023-09-30 16:35:16', '2023-09-30 16:35:16', '109', 'attached', 2, '0', '6000'),
(13, '2023-09-30 16:36:10', '2023-09-30 16:36:10', '110', 'attached', 2, '0', '6000'),
(14, '2023-09-30 16:36:48', '2023-09-30 16:36:48', '111', 'attached *', 2, '0', '6000'),
(15, '2023-09-30 20:29:22', '2023-09-30 20:29:22', '201', 'attached', 2, '0', '6000'),
(16, '2023-09-30 20:29:58', '2023-09-30 20:29:58', '202', 'attached*', 2, '0', '6000'),
(17, '2023-09-30 20:30:30', '2023-09-30 20:30:30', '203', 'attached', 2, '0', '6000'),
(18, '2023-09-30 20:30:59', '2023-09-30 20:30:59', '204', 'attached', 3, '0', '5000'),
(19, '2023-09-30 20:33:06', '2023-09-30 20:33:06', '205', 'attached', 2, '0', '6000'),
(20, '2023-09-30 20:34:11', '2023-12-11 15:32:09', '206', 'attached*', 3, '0', '6000'),
(21, '2023-09-30 20:34:29', '2023-09-30 20:36:19', '207', 'attached', 2, '0', '6000'),
(22, '2023-09-30 20:35:02', '2023-09-30 20:36:36', '208', 'attached', 3, '0', '5000'),
(23, '2023-09-30 20:35:30', '2023-09-30 20:36:55', '209', 'attached', 1, '0', '8000'),
(24, '2023-09-30 20:37:20', '2023-10-06 18:59:02', '210', 'Attached*', 2, '0', '6000'),
(25, '2023-09-30 20:38:27', '2023-10-06 19:00:16', '211', 'attached', 2, '0', '6000');

-- --------------------------------------------------------

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `roomno` int(11) DEFAULT NULL,
  `studentid` int(11) DEFAULT NULL,
  `invoiceno` int(11) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `tpdate` date DEFAULT NULL,
  `item` varchar(25) DEFAULT NULL,
  `quantity` varchar(25) DEFAULT NULL,
  `rate` varchar(25) DEFAULT NULL,
  `tax` varchar(25) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `payment_status` tinyint(1) NOT NULL DEFAULT '0',
  `discount` varchar(25) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `receive_amount` double DEFAULT NULL,
  `remaining_amount` double DEFAULT NULL,
  `unused` double DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`id`, `created_at`, `updated_at`, `roomno`, `studentid`, `invoiceno`, `invoicedate`, `tpdate`, `item`, `quantity`, `rate`, `tax`, `amount`, `payment_status`, `discount`, `total`, `receive_amount`, `remaining_amount`, `unused`) VALUES
(1, '2023-11-07 02:29:57', '2023-11-07 09:29:57', 103, 3, 1, '2023-10-01', '2023-10-01', '0,2,6,7', '1,1,1,1', '5000,3000,500,3000', '0,0,0,0', '4500,3000,500,3000', 1, '10,0,0,0', 11000, 11000, 0, 0),
(2, '2023-11-07 02:30:53', '2023-11-07 09:30:53', 204, 1, 2, '2023-10-01', '2023-10-01', '0,2,7,6', '1,1,1,1', '5000,3000,3000,500', '0,0,0,0', '4500,3000,3000,250', 1, '10,0,0,50', 10750, 10750, 0, 0),
(4, '2023-10-07 06:03:27', '2023-10-07 13:03:27', 204, 5, 4, '2023-10-03', '2023-10-03', '0,2,6,7', '1,1,1,1', '5000,3000,500,3000', '0,0,0,0', '4500,3000,500,3000', 1, '10,0,0,0', 11000, 11000, 0, 0),
(5, '2023-10-07 06:02:01', '2023-10-07 13:02:01', 210, 4, 5, '2023-10-06', '2023-10-06', '0,2,6,7', '1,1,1,1', '6000,3000,500,3000', '0,0,0,0', '5400,3000,500,3000', 1, '10,0,0,0', 11900, 11900, 0, 0),
(6, '2023-10-17 02:22:09', '2023-10-17 09:22:09', 111, 6, 6, '2023-10-06', '2023-10-06', '0,2,6,7', '1,1,1,1', '6000,3000,500,3000', '0,0,0,0', '5400,3000,500,3000', 1, '10,0,0,0', 11900, 11900, 0, 0),
(8, '2023-10-17 09:16:11', '2023-10-17 09:16:11', 111, 18, 7, '2023-10-12', '2023-10-12', '6,7,0,2', '1,1,1,1', '500,3000,6000,3000', '0,0,0,0', '500,3000,5400,3000', 1, '0,0,10,0', 11900, 11900, 0, 0),
(9, '2023-10-17 02:21:40', '2023-10-17 09:21:40', 202, 8, 8, '2023-10-04', '2023-10-04', '0,2,6,7', '1,1,1,1', '6000,3000,500,3000', '0,0,0,0', '6000,3000,500,3000', 1, '0,0,0,0', 12500, 12500, 0, 0),
(10, '2023-10-17 09:20:06', '2023-10-17 09:20:06', 206, 17, 9, '2023-10-08', '2023-10-08', '6,7,0,2', '1,1,1,1', '500,3000,6000,3000', '0,0,0,0', '500,3000,5400,3000', 1, '0,0,10,0', 11900, 11900, 0, 0),
(11, '2023-10-22 05:42:10', '2023-10-22 12:42:10', 202, 15, 10, '2023-10-09', '2023-10-09', '0,2,6,7', '1,1,1,1', '6000,3000,500,3000', '0,0,0,0', '6000,3000,500,3000', 1, '0,0,0,0', 12500, 12500, 0, 0),
(12, '2023-10-17 09:26:34', '2023-10-17 09:26:34', 203, 20, 11, '2023-10-11', '2023-10-11', '6,7,0,2', '1,1,1,1', '500,3000,6000,3000', '0,0,0,0', '500,3000,5400,3000', 1, '0,0,10,0', 11900, 11900, 0, 0),
(13, '2023-10-17 14:24:21', '2023-10-17 21:24:21', 205, 14, 12, '2023-10-10', '2023-10-10', '6,7,0,2', '1,1,1,1', '500,3000,6000,3000', '0,0,0,0', '500,3000,5400,3000', 1, '0,0,10,0', 11900, 11900, 0, 0),
(14, '2024-01-05 06:23:41', '2024-01-05 06:23:41', 209, 32, 13, '2023-10-11', '2023-10-11', '6,7,0', '1,1,1', '500,3000,8000', '0,0,0', '500,3000,7200', 1, '0,0,10', 10700, 10700, 0, 0),
(15, '2023-10-17 02:35:49', '2023-10-17 09:35:49', 101, 13, 14, '2023-10-11', '2023-10-11', '0,2,7,6', '1,1,1,1', '5000,3000,3000,500', '0,0,0,0', '4300,3000,3000,300', 1, '14,0,0,40', 10600, 10600, 0, 0),
(16, '2023-10-17 09:34:43', '2023-10-17 09:34:43', 101, 12, 15, '2023-10-11', '2023-10-11', '6,7,0,2,6', '1,1,1,1,1', '500,3000,5000,3000,500', '0,0,0,0,0', '500,3000,4300,3000,300', 1, '0,0,14,0,40', 10600, 10600, 0, 0),
(17, '2023-10-17 09:37:29', '2023-10-17 09:37:29', 208, 19, 16, '2023-10-13', '2023-10-13', '6,7,0,2', '1,1,1,1', '500,3000,5000,3000', '0,0,0,0', '500,3000,4500,3000', 1, '0,0,10,0', 11000, 11000, 0, 0),
(18, '2023-11-11 13:11:37', '2023-11-11 20:11:37', 105, 9, 17, '2023-10-09', '2023-10-09', '0,6,7', '1,1,1', '5000,500,3000', '0,0,0', '4500,500,3000', 1, '10,0,0', 8000, 8000, 0, 0),
(19, '2023-11-20 07:25:54', '2023-11-20 14:25:54', 105, 10, 18, '2023-10-09', '2023-10-09', '0,6,7,11', '1,1,1,1', '5000,500,3000,1650', '0,0,0,0', '4500,500,3000,1485', 1, '10,0,0,10', 9485, 9485, 0, 0),
(20, '2023-11-11 12:56:49', '2023-11-11 19:56:49', 106, 21, 19, '2023-10-16', '2023-10-16', '6,7,0,2', '1,1,1,1', '500,3000,6000,3000', '0,0,0,0', '500,3000,5400,3000', 1, '0,0,10,0', 11900, 11900, 0, 0),
(21, '2023-12-04 11:41:12', '2023-12-04 18:41:12', 108, 22, 20, '2023-10-26', '2023-10-26', '6,7,0', '1,1,1', '500,3000,6000', '0,0,0', '500,3000,6000', 1, '0,0,0', 9500, 9500, 0, 0),
(22, '2023-11-16 07:09:15', '2023-11-16 14:09:15', 204, 1, 21, '2023-11-01', '2023-11-01', '0,2', '1,1', '5000,3000', '0,0', '4500,3000', 1, '10,0', 7500, 7500, 0, 0),
(23, '2023-12-02 07:44:17', '2023-12-02 14:44:17', 103, 3, 22, '2023-11-01', '2023-11-01', '0,2', '1,1', '5000,3000', '0,0', '4500,3000', 1, '10,0', 7500, 7500, 0, 0),
(24, '2023-11-11 13:01:57', '2023-11-11 20:01:57', 111, 6, 23, '2023-11-06', '2023-11-06', '2,0', '1,1', '3000,6000', '0,0', '3000,5100', 1, '0,15', 8100, 8100, 0, 0),
(25, '2023-11-11 12:57:38', '2023-11-11 19:57:38', 210, 4, 24, '2023-11-06', '2023-11-06', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 5400, 5400, 0, 0),
(26, '2023-11-18 07:24:04', '2023-11-18 14:24:04', 202, 8, 25, '2023-11-04', '2023-11-04', '0,2', '1,1', '6000,3000', '0,0', '6000,3000', 1, ',0', 9000, 9000, 0, 0),
(27, '2023-11-11 13:02:19', '2023-11-11 20:02:19', 206, 17, 26, '2023-11-08', '2023-11-08', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 8400, 8400, 0, 0),
(28, '2023-11-17 06:07:09', '2023-11-17 13:07:09', 202, 15, 27, '2023-11-09', '2023-11-09', '0', '1', '6000', '0', '6000', 1, '0', 6000, 6000, 0, 0),
(29, '2023-11-17 05:59:35', '2023-11-17 12:59:35', 203, 20, 28, '2023-11-11', '2023-11-11', '0', '1', '6000', '0', '6000', 1, '0', 6000, 6000, 0, 0),
(30, '2023-11-17 06:29:22', '2023-11-17 13:29:22', 205, 14, 29, '2023-11-10', '2023-11-10', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 8400, 8400, 0, 0),
(31, '2024-01-05 06:24:48', '2024-01-05 06:24:48', 209, 32, 30, '2023-11-11', '2023-11-11', '0', '1', '8000', '0', '7200', 1, '10', 7200, 7200, 0, 0),
(32, '2023-11-23 14:20:49', '2023-11-23 21:20:49', 101, 12, 31, '2023-11-11', '2023-11-11', '0,2', '1,1', '5000,3000', '0,0', '4300,3000', 1, '14,0', 7300, 7300, 0, 0),
(33, '2023-11-29 14:56:22', '2023-11-29 21:56:22', 101, 13, 32, '2023-11-11', '2023-11-11', '0,2', '1,1', '5000,3000', '0,0', '4300,3000', 1, '14,0', 7300, 7300, 0, 0),
(35, '2023-11-18 07:23:12', '2023-11-18 14:23:12', 202, 8, 34, '2023-11-13', '2023-11-13', '3', '9', '100', '0', '900', 1, '0', 900, 900, 0, 0),
(37, '2023-11-17 06:01:33', '2023-11-17 13:01:33', 209, 16, 36, '2023-10-31', '2023-10-31', '14', '11', '80', '0', '660', 1, '25', 660, 660, 0, 0),
(38, '2023-11-18 04:26:50', '2023-11-18 11:26:50', 208, 19, 37, '2023-11-13', '2023-11-13', '0,2', '1,1', '5000,3000', '0,0', '4500,3000', 1, '10,0', 7500, 7500, 0, 0),
(39, '2023-11-18 04:17:55', '2023-11-18 11:17:55', 111, 18, 38, '2023-11-12', '2023-11-12', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 8400, 8400, 0, 0),
(40, '2023-11-20 07:23:04', '2023-11-20 14:23:04', 105, 10, 39, '2023-11-09', '2023-11-09', '0', '1', '5000', '0', '4500', 1, '10', 4500, 4500, 0, 0),
(41, '2023-11-20 07:27:55', '2023-11-20 14:27:55', 105, 9, 40, '2023-11-09', '2023-11-09', '0', '1', '5000', '0', '4500', 1, '10', 4500, 4500, 0, 0),
(42, '2023-11-18 11:19:39', '2023-11-18 11:19:39', 201, 23, 41, '2023-11-16', '2023-11-16', '6,7,0,0,2', '1,1,1,1,1', '500,3000,6000,6000,3000', '0,0,0,0,0', '500,3000,6000,5400,3000', 1, '0,0,0,10,0', 11900, 11900, 0, 0),
(44, '2023-11-18 14:09:32', '2023-11-18 14:09:32', 207, 24, 43, '2023-11-16', '2023-11-16', '0,2,7,0,6', '1,1,1,1,1', '6000,3000,3000,6000,500', '0,0,0,0,0', '6000,3000,3000,5400,500', 1, '0,0,0,10,0', 11900, 11900, 0, 0),
(46, '2023-11-19 11:01:06', '2023-11-19 11:01:06', 101, 13, 45, '2023-11-19', '2023-11-19', '3', '9', '100', '0', '900', 1, '0', 900, 0, 900, 0),
(47, '2023-11-19 11:01:50', '2023-11-19 11:01:50', 101, 12, 46, '2023-11-19', '2023-11-19', '3', '9', '100', '0', '900', 1, '0', 900, 0, 900, 0),
(50, '2023-11-21 07:26:01', '2023-11-21 14:26:01', 108, 26, 49, '2023-11-20', '2023-11-20', '0,6,7', '1,1,1', '6000,500,3000', '0,0,0', '5400,500,3000', 1, '10,0,0', 8900, 8900, 0, 0),
(51, '2023-11-23 14:21:35', '2023-11-23 21:21:35', 106, 21, 50, '2023-11-16', '2023-11-16', '8', '17', '500', '0', '4199', 1, '50.6', 4199, 4200, 0, 1),
(53, '2023-11-30 06:42:19', '2023-11-30 13:42:19', 101, 27, 52, '2023-11-16', '2023-11-16', '0,2,6,7', '1,1,1,1', '5000,3000,500,3000', '0,0,0,0', '4300,3000,500,3000', 1, '14,0,0,0', 10800, 10800, 0, 0),
(54, '2023-12-19 05:29:49', '2023-12-19 12:29:49', 110, 22, 53, '2023-11-26', '2023-11-26', '0', '1', '6000', '0', '6000', 1, '0', 6000, 6000, 0, 0),
(56, '2023-11-30 15:50:26', '2023-11-30 15:50:26', 106, 21, 56, '2023-11-30', '2023-11-30', '16', '2', '200', '0', '400', 1, '0', 400, 0, 400, 0),
(58, '2023-12-04 08:50:09', '2023-12-04 15:50:09', 111, 18, 58, '2023-12-12', '2023-12-12', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 8400, 8400, 0, 0),
(61, '2023-12-07 05:32:44', '2023-12-07 12:32:44', 106, 21, 61, '2023-12-02', '2023-12-02', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 8400, 8400, 0, 0),
(62, '2023-12-09 04:32:42', '2023-12-09 11:32:42', 111, 6, 62, '2023-12-06', '2023-12-06', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 8400, 8400, 0, 0),
(63, '2023-12-09 04:28:32', '2023-12-09 11:28:32', 210, 4, 63, '2023-12-06', '2023-12-06', '0', '1', '6000', '0', '6000', 1, '0', 6000, 6000, 0, 0),
(64, '2023-12-09 04:30:28', '2023-12-09 11:30:28', 206, 17, 64, '2023-12-08', '2023-12-08', '0', '1', '6000', '0', '6000', 1, '0', 6000, 6000, 0, 0),
(65, '2023-12-12 06:13:07', '2023-12-12 13:13:07', 105, 10, 65, '2023-12-09', '2023-12-09', '0', '1', '5000', '0', '4500', 1, '10', 4500, 4500, 0, 0),
(67, '2023-12-12 06:13:17', '2023-12-12 13:13:17', 202, 15, 67, '2023-12-09', '2023-12-09', '0', '1', '6000', '0', '6000', 1, '0', 6000, 6000, 0, 0),
(72, '2023-12-06 12:59:52', '2023-12-06 19:59:52', 103, 3, 72, '2023-12-01', '2023-12-01', '0,2', '1,1', '5000,3000', '0,0', '4500,3000', 1, '10,0', 7500, 7500, 0, 0),
(73, '2023-12-07 05:37:18', '2023-12-07 12:37:18', 202, 8, 73, '2023-12-04', '2023-12-04', '0,2', '1,1', '6000,3000', '0,0', '6000,3000', 1, '0,0', 9000, 9000, 0, 0),
(86, '2023-12-19 05:30:28', '2023-12-19 12:30:28', 110, 22, 91, '2023-11-30', '2023-11-30', '14', '15', '80', '0', '900', 1, '25', 900, 900, 0, 0),
(87, '2023-12-06 06:10:33', '2023-12-06 13:10:33', 204, 1, 92, '2023-12-01', '2023-12-01', '0,2', '1,1', '5000,3000', '0,0', '4500,3000', 1, '10,0', 7500, 7500, 0, 0),
(88, '2023-12-06 19:40:15', '2023-12-06 19:40:15', 106, 30, 93, '2023-12-06', '2023-12-06', '6,7,0,2,0', '1,1,1,1,1', '500,3000,6000,3000,6000', '0,0,0,0,0', '500,3000,6000,3000,5400', 1, '0,0,0,0,10', 11900, 11900, 0, 0),
(89, '2023-12-06 19:51:04', '2023-12-06 19:51:04', 105, 29, 94, '2023-12-06', '2023-12-06', '6,7,0,2', '1,1,1,1', '500,3000,5000,3000', '0,0,0,0', '500,3000,5000,3000', 1, '0,0,0,0', 11500, 11500, 0, 0),
(90, '2023-12-09 04:33:27', '2023-12-09 11:33:27', 104, 25, 95, '2023-11-20', '2023-11-20', '0,2,6,7', '1,1,1,1', '6000,3000,500,3000', '0,0,0,0', '5400,3000,500,3000', 1, '10,0,0,0', 11900, 11900, 0, 0),
(91, '2023-12-07 15:23:44', '2023-12-07 15:23:44', 103, 28, 96, '2023-11-24', '2023-11-24', '6,7,2,0', '1,1,1,1', '500,3000,3000,5000', '0,0,0,0', '500,3000,3000,4500', 1, '0,0,0,10', 11000, 11000, 0, 0),
(92, '2023-12-09 14:33:13', '2023-12-09 14:33:13', 104, 31, 97, '2023-12-09', '2023-12-09', '6,7,2,0', '1,1,1,1', '500,3000,3000,6000', '0,0,0,0', '500,3000,3000,5400', 1, '0,0,0,10', 11900, 11900, 0, 0),
(93, '2023-12-11 08:51:22', '2023-12-11 15:51:22', 110, 33, 98, '2023-12-11', '2023-12-11', '6,7,2,0', '1,1,1,1', '500,3000,3000,6000', '0,0,0,0', '500,3000,3000,5400', 1, '0,0,0,10', 11900, 11900, 0, 0),
(94, '2023-12-11 18:47:56', '2023-12-11 18:47:56', 108, 34, 99, '2023-12-08', '2023-12-08', '6,7,2,0', '1,1,1,1', '500,3000,3000,6000', '0,0,0,0', '500,3000,3000,5400', 1, '0,0,0,10', 11900, 11900, 0, 0),
(95, '2023-12-20 07:20:27', '2023-12-20 14:20:27', 205, 14, 100, '2023-12-10', '2023-12-10', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 8400, 8400, 0, 0),
(96, '2023-12-19 06:25:21', '2023-12-19 13:25:21', 203, 20, 101, '2023-12-11', '2023-12-11', '0', '1', '6000', '0', '6000', 1, '0', 6000, 6000, 0, 0),
(97, '2023-12-19 06:26:08', '2023-12-19 13:26:08', 208, 19, 102, '2023-12-13', '2023-12-13', '0,2', '1,1', '5000,3000', '0,0', '4500,3000', 1, '10,0', 7500, 7500, 0, 0),
(98, '2023-12-25 05:30:46', '2023-12-25 12:30:46', 101, 13, 103, '2023-12-11', '2023-12-11', '2,0', '1,1', '3000,5000', '0,0', '3000,4300', 1, '0,14', 7300, 7300, 0, 0),
(99, '2023-12-19 06:27:39', '2023-12-19 13:27:39', 101, 12, 104, '2023-12-11', '2023-12-11', '2,0', '1,1', '3000,5000', '0,0', '3000,4300', 1, '0,14', 7300, 7300, 0, 0),
(100, '2023-12-13 08:29:28', '2023-12-13 15:29:28', 208, 36, 105, '2023-12-13', '2023-12-13', '6,7,2,0', '1,1,1,1', '500,3000,3000,5000', '0,0,0,0', '500,3000,3000,4500', 1, '0,0,0,10', 11000, 11000, 0, 0),
(101, '2023-12-15 04:03:31', '2023-12-15 11:03:31', 209, 37, 106, '2023-12-13', '2023-12-13', '6,7,2,0', '1,1,1,1', '500,3000,3000,8000', '0,0,0,0', '500,3000,3000,8000', 1, '0,0,0,0', 14500, 14500, 0, 0),
(102, '2023-12-25 05:27:44', '2023-12-25 12:27:44', 201, 23, 107, '2023-12-16', '2023-12-16', '0,2', '1,1', '6000,3000', '0,0', '5400,3000', 1, '10,0', 8400, 8400, 0, 0),
(103, '2023-12-31 06:10:25', '2023-12-31 13:10:25', 101, 27, 108, '2023-12-16', '2023-12-16', '2,0', '1,1', '3000,5000', '0,0', '3000,4300', 1, '0,14', 7300, 7300, 0, 0),
(104, '2023-12-31 06:08:07', '2023-12-31 13:08:07', 207, 24, 109, '2023-12-16', '2023-12-16', '2,0', '1,1', '3000,6000', '0,0', '3000,5400', 1, '0,10', 8400, 8400, 0, 0),
(105, '2023-12-19 13:20:31', '2023-12-19 13:20:31', 109, 38, 110, '2023-12-17', '2023-12-17', '6,7,2,0', '1,1,1,1', '500,3000,3000,6000', '0,0,0,0', '500,3000,3000,6000', 1, '0,0,0,0', 12500, 12500, 0, 0),
(106, '2023-12-19 13:29:56', '2023-12-19 13:29:56', 101, 12, 111, '2023-12-18', '2023-12-18', '3', '8', '100', '0', '800', 1, '0', 800, 0, 800, 0),
(107, '2023-12-25 05:30:05', '2023-12-25 12:30:05', 101, 13, 112, '2023-12-22', '2023-12-22', '3', '12', '100', '0', '1200', 1, '0', 1200, 0, 1200, 0),
(109, '2024-01-04 04:56:12', '2024-01-04 11:56:12', 108, 26, 113, '2023-12-20', '2023-12-20', '0', '1', '6000', '0', '6000', 1, '0', 6000, 5400, 600, 0),
(111, '2023-12-22 05:11:24', '2023-12-22 12:11:24', 107, 39, 115, '2023-12-22', '2023-12-22', '6,7,0,2', '1,1,1,1', '500,3000,6000,3000', '0,0,0,0', '500,3000,5400,3000', 1, '0,0,10,0', 11900, 11900, 0, 0),
(112, '2024-01-02 06:14:01', '2024-01-02 13:14:01', 103, 28, 116, '2023-12-24', '2023-12-24', '0,2', '1,1', '5000,3000', '0,0', '4500,3000', 1, '10,0', 7500, 7500, 0, 0),
(113, '2024-01-07 03:09:50', '2024-01-07 10:09:50', 110, 22, 117, '2023-12-26', '2023-12-26', '0', '1', '6000', '0', '6000', 1, '0', 6000, 6000, 0, 0),
(114, '2023-12-31 14:22:22', '2023-12-31 14:22:22', 104, 25, 120, '2023-12-31', '2023-12-31', '8,8', '12,16', '500,500', '0,0', '3360,4480', 1, '44,44', 4480, 2700, 1780, 0),
(115, '2024-01-07 03:10:17', '2024-01-07 10:10:17', 110, 22, 122, '2023-12-31', '2023-12-31', '14', '38', '80', '0', '2280', 1, '25', 2280, 2280, 0, 0),
(116, '2024-01-02 13:12:42', '2024-01-02 13:12:42', 108, 26, 123, '2023-12-31', '2023-12-31', '14', '13', '80', '0', '780', 1, '25', 780, 780, 0, 0),
(117, '2024-01-02 14:41:05', '2024-01-02 14:41:05', 109, 35, 126, '2023-12-10', '2023-12-10', '6,7,0,2', '1,1,1,1', '500,3000,6000,3000', '0,0,0,0', '500,3000,6000,3000', 1, '0,0,0,0', 12500, 12500, 0, 0),
(118, '2024-01-04 11:59:52', '2024-01-04 11:59:52', 110, 22, 127, '2024-01-04', '2024-01-04', '3', '10', '100', '0', '1000', 1, '0', 1000, 0, 1000, 0),
(120, '2024-01-07 03:13:06', '2024-01-07 10:13:06', 103, 3, 129, '2024-01-01', '2024-01-01', '0,2', '1,1', '5000,3000', '0,0', '5000,3000', 1, '0,0', 8000, 8000, 0, 0),
(121, '2024-01-04 13:12:24', '2024-01-04 13:12:24', 106, 21, 130, '2024-01-02', '2024-01-02', '0,2', '1,1', '6000,3000', '0,0', '6000,3000', 1, '0,0', 9000, 0, 9000, 0),
(122, '2024-01-04 13:13:42', '2024-01-04 13:13:42', 202, 8, 131, '2024-01-04', '2024-01-04', '0,2', '1,1', '6000,3000', '0,0', '6000,3000', 1, '0,0', 9000, 0, 9000, 0),
(123, '2024-01-07 10:09:18', '2024-01-07 10:09:18', 111, 6, 132, '2024-01-06', '2024-01-06', '0,2', '1,1', '6000,3000', '0,0', '6000,3000', 1, '0,0', 9000, 0, 9000, 0),
(124, '2024-01-07 10:11:25', '2024-01-07 10:11:25', 104, 25, 133, '2024-01-05', '2024-01-05', '0,2', '1,1', '6000,3000', '0,0', '6000,3000', 1, '0,0', 9000, 0, 9000, 0),
(125, '2024-01-07 10:14:01', '2024-01-07 10:14:01', 105, 29, 134, '2024-01-06', '2024-01-06', '0,2', '1,1', '5000,3000', '0,0', '5000,3000', 1, '0,0', 8000, 0, 8000, 0),
(126, '2024-01-07 10:15:00', '2024-01-07 10:15:00', 106, 30, 135, '2024-01-06', '2024-01-06', '0,2', '1,1', '6000,3000', '0,0', '6000,3000', 1, '0,0', 9000, 0, 9000, 0),
(127, '2024-01-07 10:16:06', '2024-01-07 10:16:06', 210, 4, 136, '2024-01-06', '2024-01-06', '0', '1', '6000', '0', '6000', 1, '0', 6000, 0, 6000, 0),
(128, '2024-01-07 10:21:16', '2024-01-07 10:21:16', 204, 1, 137, '2024-01-01', '2024-01-01', '0,2', '1,1', '5000,3000', '0,0', '4500,3000', 1, '10,0', 7500, 7500, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `self_student_registration`
--

CREATE TABLE `self_student_registration` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `regdate` date DEFAULT NULL,
  `candidatename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `aadhar` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blood` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_job` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coursedetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobdetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institute_company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institutename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stydrt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `healthissue` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `health_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehicalno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehicledescription` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parentmobile1` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parentmobile2` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pemail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fullAddress` text COLLATE utf8mb4_unicode_ci,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pinno` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fathername` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fatheroocc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mothername` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `motheroocc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardianname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardiannumber` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardianaddress` text COLLATE utf8mb4_unicode_ci,
  `studentImg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uploadaadharfront` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uploadaadharback` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `candidatesign` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Parentsign` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `termsAndCondition` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `share_menus`
--

CREATE TABLE `share_menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `menu_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `date` date NOT NULL,
  `img_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `stockitems`
--

CREATE TABLE `stockitems` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `itemName` varchar(255) DEFAULT NULL,
  `itemUnite` varchar(50) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `stock_categories`
--

CREATE TABLE `stock_categories` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `category_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `stock_details`
--

CREATE TABLE `stock_details` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `item_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `month` varchar(255) DEFAULT NULL,
  `est_stock` float DEFAULT '0',
  `order1` float DEFAULT '0',
  `order2` float DEFAULT '0',
  `order3` float DEFAULT '0',
  `total_stock` float DEFAULT NULL,
  `used_stock` float DEFAULT '0',
  `Date` date DEFAULT NULL,
  `orderDate` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `studentregisters`
--

CREATE TABLE `studentregisters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `formno` int(25) DEFAULT NULL,
  `roomno` int(25) DEFAULT NULL,
  `seetno` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `join_date` date DEFAULT NULL,
  `candidatename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dob` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valid` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `blood` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `healthissue` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stydrt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vehicalno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coursename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coursedetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobdetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institute` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `institutename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fathername` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fatheroocc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mothername` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `motheroocc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobilenumber` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pemail` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fullAddress` text COLLATE utf8mb4_unicode_ci,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pinno` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guardianname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guardiannumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guardianaddress` varchar(5000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uploadimage` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uploadaadharfront` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uploadaadharback` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `reserve` int(11) NOT NULL DEFAULT '1',
  `leave_date` date DEFAULT NULL,
  `health_description` text COLLATE utf8mb4_unicode_ci,
  `vehicledescription` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `candidatesign` text COLLATE utf8mb4_unicode_ci,
  `Parentsign` text COLLATE utf8mb4_unicode_ci,
  `ChangeRoom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `studentregisters`
--

INSERT INTO `studentregisters` (`id`, `created_at`, `updated_at`, `formno`, `roomno`, `seetno`, `date`, `join_date`, `candidatename`, `dob`, `valid`, `phone`, `email`, `blood`, `healthissue`, `stydrt`, `vehicalno`, `coursename`, `coursedetails`, `jobdetails`, `companyname`, `institute`, `institutename`, `fathername`, `fatheroocc`, `mothername`, `motheroocc`, `tel`, `mobilenumber`, `pemail`, `fullAddress`, `state`, `pinno`, `guardianname`, `guardiannumber`, `guardianaddress`, `uploadimage`, `uploadaadharfront`, `uploadaadharback`, `status`, `reserve`, `leave_date`, `health_description`, `vehicledescription`, `candidatesign`, `Parentsign`, `ChangeRoom`) VALUES
(1, '2023-10-02 09:54:25', '2023-11-13 12:09:42', 1, 204, '1', '2023-10-01', NULL, 'SHREYA VISHWAKARMA', '2006-12-01', '905071679717', '9302566341', 'SSG@GMAIL.COM', 'B+', 'no', '1 YEAR', 'no', 'coursetype', 'NDA', '', NULL, 'institute Name', 'MAA TUTORIAL', 'MR MUKESH VISHWAKARMA', 'FARMER', 'MRS SEEMA VISHWAKARMA', 'HOUSE WIFE', '9691332542', NULL, NULL, '66, WARD-11, AMLAY, SHUJALPUR, MADHYA PRADESH', 'MADHYA PRADESH', '465335', 'MR MUKESH VISHWAKARMA', '9691332542', '66, WARD-11, AMLAY, SHUJALPUR, MADHYA PRADESH', '1696215265.1964193266.jpg', '', '', '1', 1, NULL, '', '', NULL, NULL, NULL),
(3, '2023-10-02 12:48:31', '2023-11-07 11:16:04', 2, 103, '1', '2023-10-01', NULL, 'KRISH MAHENDRU', '2005-11-10', '75058403335', '7669010541', 'SSG001@GMAIL.COM', 'AB+', 'no', '3 MONTHS', 'no', 'coursetype', 'BBA', '', NULL, 'institute Name', 'RENNAISSENCE COLLEGE', 'MR DEEPAK MAHENDRU', 'Businessman', 'MRS DIVYA MAHENDRU', 'HOUSE WIFE', '9910914355', NULL, NULL, 'B-773, GREEN FIELD COLONY,, NHPC COLONY, FARIDABAD , HARAYANA', 'HARYANA', '121010', 'MR DEEPK MAHENDRU', '9910914355', 'B-773, GREEN FIELD COLONY,, NHPC COLONY, FARIDABAD , HARAYANA', '1696225711.302073196.jpg', '', '', '1', 1, NULL, '', '', NULL, NULL, NULL),
(4, '2023-10-06 20:23:46', '2023-11-07 09:43:46', 3, 210, '1', '2023-10-06', NULL, 'Pragya Sharma', '2000-01-01', '448681311851', '7354568367', 'pragyashrama173@gmail.com', 'A+', 'no', '3+', 'yes', 'coursetype', 'Student', '', NULL, 'institute Name', 'Online', 'Deva Kant sharma', 'Business', 'Pratibha Sharma', 'Housewife', '9425188752', '7004009560', NULL, 'ssg indore', 'Madhya pradesh', '487118', 'Deepanshu Sharma', '7000400956', 'Plot no 216 Saket Nagar Indore', '1696598626.956712473.jpeg', '', '', '1', 1, NULL, '', 'MP49mz1814', NULL, NULL, NULL),
(5, '2023-10-06 20:34:17', '2023-10-11 10:54:54', 4, 204, '2', '2023-10-03', NULL, 'Himanshi sethi', '2005-03-22', '289022814954', '9981306146', 'himanshisethi05@gmail.com', 'A+', 'no', '1 month', 'no', 'coursetype', 'Bba', '', NULL, 'institute Name', 'Renaissance', 'Shailendra sethi', 'Businesses man', 'Preeti sethi', 'Housewife', '9424037070', '9424070307', NULL, 'SSG', 'Madhya Pradesh', '458441', 'Priyanka chabbra', '9424513614', '109,Mangal marg,Gandhi magar', '1696599257.2000379828.jpeg', '', '', '0', 1, '2023-11-03', '', '', NULL, NULL, NULL),
(6, '2023-10-07 18:59:59', '2023-11-07 11:52:57', 5, 111, '1', '2023-10-06', NULL, 'OM PANDEY', '2000-01-01', '249018635538', '8839775299', 'ompipaney95@gmail.com', 'A+', 'no', '36', 'no', 'coursetype', 'Bba', '', NULL, 'institute Name', 'Renaissance college', 'Dinesh Pandey', 'Govt job', 'Pratima Pandey', 'Homemaker', '9589447347', '8103355806', NULL, 'H.N0-1', 'Chhattisgarh', '497235', 'Dinesh Pandey', '9589447347', 'Old miners - 169 , Bhatgoan colony , Surajpur ,Chhattisgarh', '1696679999.677781792.jpeg', '', '', '1', 1, NULL, '', '', NULL, NULL, NULL),
(8, '2023-10-08 18:22:30', '2023-12-11 15:40:28', 6, 202, '2', '2023-10-04', NULL, 'MANSI PATEL', '2002-06-14', '597283450276', '9302547255', 'mansi96177@gmail.com', 'B+', 'no', '6', 'yes', 'coursetype', 'Bba', '', NULL, 'institute Name', 'Prestige college', 'Mr Manoj Patel', 'Business Man', 'Savita Patel', 'Housewife', '6261649698', NULL, NULL, 'ssg indore', 'Mp', '461775', 'Harpreet Singh Hora', '9685938103', 'B31 navlakha complex agrasen square indore', '1696764150.1719355702.jpeg', '', '', '1', 1, NULL, '', 'MP04 MR 6681', NULL, NULL, NULL),
(9, '2023-10-10 12:27:30', '2023-10-10 12:27:30', 7, 105, '1', '2023-10-09', NULL, 'Sourabh soni', '1999-07-31', '916525258512', '9630115121', 'sourabhsoni9157@gmail.com', 'A+', 'no', '2', 'yes', 'jobtype', NULL, 'It', 'Task us', 'Comapany Name', NULL, 'Ashok Kumar soni', 'Business', 'Nirmala', 'Housewife', '9630115121', '9977634498', NULL, '428 - A Devi Ji square, Amjhera (Dhar)', 'Madhya pradesh', '454441', 'Ashok soni', '9977634498', 'Devi Ji square, Amjhera (Dhar)', '1696915650.1909677330.jpeg', '', '', '0', 1, '2023-12-08', NULL, 'Mp11nd9666', NULL, NULL, NULL),
(10, '2023-10-10 12:37:01', '2024-01-02 14:47:55', 8, 105, '1', '2023-12-08', NULL, 'Sourav Tiwari', '2000-01-01', '916753769700', '7694830910', 'souravtiwari1108@gmail.com', 'B+', 'no', '2', 'no', 'jobtype', '', 'Bpo', NULL, 'institute Name', 'Taskus', 'Sn Tiwari', 'Service man', 'Saroj Tiwari', 'Housewife', '8355064470', NULL, NULL, 'C 51 Tirupati Abhinav homes Bhopal', 'Mp', '462010', 'Sn Tiwari', '8355064470', 'C 51 Tirupati Abhinav homes Bhopal , Mp, 462010', '1696916221.1699889951.jpeg', '', '', '1', 1, NULL, '', '', NULL, NULL, NULL),
(12, '2023-10-11 19:42:52', '2023-10-11 19:42:52', 9, 101, '2', '2023-10-11', NULL, 'ATISHAY JAIN', '2000-01-01', '475987808872', '8717851267', 'atishayjain142732@gmail.com', 'A+', 'no', '5 month', 'no', 'coursetype', 'b-com', NULL, NULL, 'institute Name', 'rennaissance college indore', 'Mr ABHAY KUMAR JAIN', 'BUSINESS', 'MRS PINKY JAIN', 'house wife', '9826945490', NULL, NULL, 'WARD 15, RAHATGARH, SAGAR', 'MADHYA PRADESH', '470119', 'MRS. ATUL JAIN', '6263317276', '78, INDORE', '1697028172.1060425357.jpeg', '', '', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(13, '2023-10-11 19:53:48', '2023-10-11 19:53:48', 10, 101, '1', '2023-10-11', NULL, 'DIVYANSH YADAV', '2000-01-01', '640795039394', '9589117270', 'DY65041@GMAIL.COM', 'B+', 'no', '5 MONTHS', 'no', 'coursetype', 'BBA', NULL, NULL, 'institute Name', 'RENNAISSANCE', 'MR BALKISHAN YADAV', 'FARMER BUSINESS', 'MRS CHANDA RANI YADAV', 'house wife', '7067817625', NULL, NULL, 'GRAM VILASPUR, SAGAR', 'MADHYA PRADESH', '470119', 'AKSHAY YADAV', '7898738382', 'NAVLAKHA, INDORE', '1697028828.390520751.jpeg', '', '', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(14, '2023-10-11 20:57:46', '2023-10-11 20:57:46', 11, 205, '1', '2023-10-10', NULL, 'ANJALI MALVIYA', '2002-08-22', '632476788727', '9009569704', 'anjalimalviya1727@gmail.com', 'O+', 'no', '2 MONTHS', 'no', 'coursetype', 'CA', NULL, NULL, 'institute Name', 'SELF', 'MR RAJENDRA MALVIYA', 'BUSINESS', 'MRS SADNA MALVIYA', 'house wife', '7617273652', NULL, NULL, 'ANJAD REVENUE AREA ANJAD, BARWANI', 'MADHYA PRADESH', '451556', 'MS VAISALI MALVIYA', '9109429493', 'CHAUITRAM MANDI, INDORE', '1697032666.1349648845.jpeg', '', '', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(15, '2023-10-11 23:29:28', '2023-10-13 09:58:42', 13, 202, '1', '2023-10-09', NULL, 'ROSHNI SONI', '1997-07-10', '780757961955', '9109319650', 'roshnisoni.ngd@gmail.com', 'O+', 'no', '3 months', 'no', 'coursetype', 'C-dac', '', NULL, 'institute Name', 'orlando acadamy', 'Mr INDRAVAS SONI', 'GOV EMPLOYEE', 'MRS SOMBATI', 'house wife', '8305077720', NULL, NULL, 'KUM KUM PALACE KE PICHE, NAGOD', 'MADHYA PRADESH', '485421', 'GOURAV  SONI', '9755626569', 'INDORE', '1697041768.242360902.jpeg', '', '', '1', 1, NULL, '', '', NULL, NULL, NULL),
(17, '2023-10-11 23:48:53', '2023-10-13 10:03:45', 15, 206, '1', '2023-10-08', NULL, 'Nikita manwani', '2000-10-01', '809743292630', '7049096562', 'NIKITAMANWANI110@GMAIL.COM', 'B+', 'no', '3 MONTHS', 'yes', 'jobtype', '', 'FASION STYLER', 'KALANYA FASIONS', 'Comapany Name', 'KALANYA FASIONS', 'MR NANDSYAM NANWANI', 'BUSINESS', 'MRS ANITA MANWANI', 'house wife', '7999055178', NULL, NULL, '134, NEAR CUMMUNITY HALL PRABHU NAGAR IDGAH HILLS ,BHOPAL', 'MADHYA PRADESH', '462001', 'MR NANDSYAM NANWANI', '7999055178', '134, NEAR CUMMUNITY HALL PRABHU NAGAR IDGAH HILLS ,BHOPAL', '1697042933.464765568.jpeg', '', '', '1', 1, NULL, '', 'MP04UJ2484', NULL, NULL, NULL),
(18, '2023-10-12 22:19:40', '2023-10-12 22:25:11', 14, 111, '2', '2023-10-12', NULL, 'UDAY KAKDE', '2003-08-19', '396821078533', '9131323248', 'kakdeuday07@gmail.com', 'B+', 'yes', '3 month', 'yes', 'coursetype', 'llb', '', NULL, 'institute Name', 'rennaissance college indore', 'MR GANESH KAKDE', 'GOVT EMPLOYEE', 'MRS SARLA KAKDE', 'house wife', '8959492783', '9669612833', NULL, 'H NO, 16 WARD NO.46, CHITRA TALKIES KE PAAS BURHANPUR,', 'MADHYA PRADESH', '450331', 'MUSKAN GURJAR', '9644820414', 'NEAR RENNAISANCE COLLEGE, INDORE', '1697123980.1231046439.jpeg', '1697123980.282069022.jpeg', '', '1', 1, NULL, 'NO', 'MP09ZT3341', NULL, NULL, NULL),
(19, '2023-10-13 12:10:21', '2023-10-13 12:10:21', 16, 208, '1', '2023-10-13', NULL, 'VINITA SAHNI', '2002-10-02', '544283277233', '6386975976', 'vinitasahnimzp@gmail.com', 'O+', 'no', '3 months', 'no', 'coursetype', 'badminton', NULL, NULL, 'institute Name', 'sports club', 'MR LALIT SAHNI', 'GOVT SERVICE', 'MRS SAROJ SAHNI', 'house wife', '7355432470', '8707504720', NULL, 'DWARKAPURI COLONY, LOHIYA TALAB, MAHUARIA, MIRZAPUR', 'UTTAR PRADESH', '231001', 'MR CHANDAN JEE', '6202146491', 'CAT SQUARE, INDORE', '1697173821.2028151884.jpeg', '1697173821.153515067.jpeg', '1697173821.256644765.jpeg', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(20, '2023-10-13 12:38:44', '2023-11-14 18:30:41', 17, 203, '1', '2023-10-11', NULL, 'TEJASVINI JAIN', '2000-06-14', '712120524625', '8770213389', 'TANYANALWAYA14@GMAIL.COM', 'AB-', 'no', '3 MONTHS', 'no', 'coursetype', 'INTERN', '', NULL, 'institute Name', 'ORLANDO ACADAMY', 'LATE MR PROMOD JAIN', 'FARMING BUSINESS', 'MRS SANGEETA JAIN', 'HOUSE WIFE', '8817263882', NULL, NULL, 'MANASA ROAD, SCHEME NO 10, NEEMUCH', 'MADYA PRADESH', '458441', 'MR. PUKHRAJ JEE', '8817263882', 'KALANI NAGAR, INDORE', '1697277774.766694251.jpeg', '1697175524.520720970.jpeg', '1697175524.1446155700.jpeg', '1', 1, NULL, '', '', NULL, NULL, NULL),
(21, '2023-10-17 10:54:29', '2023-10-17 10:54:29', 18, 106, '1', '2023-10-16', NULL, 'KESAV AGRAWAL', '2004-07-16', '308336317883', '9584716399', 'KESAVAGRAWAL052@GMAIL.COM', 'B+', 'no', '3 MONTHS', 'yes', 'coursetype', 'BBA', NULL, NULL, 'institute Name', 'rennaissance college indore', 'MR NILESH AGRAWAL', 'BUSINESS', 'MRS ARCHANA AGRAWAL', 'HOUSE WIFE', '6265335769', NULL, NULL, 'MAIN ROAD, OZHAR, RAJPUR, BARWANI ,', 'madhya pradesh', '451449', 'ABHISHEK AGRAWAL UNCLE', '7000471429', 'Orange odessy  Agrasen chaurah Navlakha  Near to Netram opticals', '1697514869.10810317.jpeg', '1697514869.165313716.jpeg', '1697514869.1124942924.jpeg', '1', 1, NULL, NULL, 'MP46ML5704', NULL, NULL, NULL),
(22, '2023-11-07 09:26:03', '2024-01-02 14:05:24', 19, 110, '1', '2023-10-26', NULL, 'MADHAV MUJHAVDIYA', '2000-01-01', '995788430530', '9424601711', 'ssg@gmail.com', 'A+', 'no', '3 months', 'no', 'coursetype', 'student', '', NULL, 'institute Name', 'student', 'MR MANOJ MUJHAVDIYA', 'BUSINESS', 'MR MANOJ MUJHAVDIYA', 'house wife', '7024805838', NULL, 'asr.official001@gmail.com', 'ssg indore', 'Madhya Pradesh', '452011', 'MR MANOJ MUJHAVDIYA', '9424601711', 'SSG INDORE', '1699323963.645460146.png', '', '', '1', 1, NULL, '', '', NULL, NULL, NULL),
(23, '2023-11-18 11:14:07', '2023-11-18 11:14:07', 20, 201, '1', '2023-11-16', NULL, 'JHEEL JAIN', '2002-01-02', '787668427090', '7022950650', 'jainjheel0102@gmail.com', 'O+', 'no', '3 month and can extend', 'no', 'coursetype', 'LLB honors', NULL, NULL, 'instituteName', 'Renaissance University', 'ANTIM JAIN', 'Banker', 'RACHNA JAIN', 'Homemaker', '9981513972', NULL, NULL, '83,Zamindar colony,Ramtekri,Mandsaur district', 'ANTIM JAIN', '458001', 'ANTIM JAIN', '9981513972', '83, Zamindar colony, Ramtekri, Mandsaur district', '1700237019.1638385118.jpg', '1700237019.1859632241.jpg', '1700237019.2074463928.jpg', '1', 1, NULL, NULL, NULL, '1700237019.638336220.jpg', '1700237019.1853733234.jpg', NULL),
(24, '2023-11-18 12:40:51', '2023-11-18 12:40:51', 21, 207, '1', '2023-11-16', NULL, 'ritika jain', '1999-07-11', '339712717789', '9977317231', 'ritikj1107@gmail.com', 'B+', 'no', '6 months', 'no', 'jobtype', NULL, 'motion graphic designer', 'the band ant', 'Comapany Name', NULL, 'mukesh jain', 'businessman', 'renu jain', 'house wife', '8269006910', '9039304280', NULL, '137 bhagyakunj lig harda', 'M P', '461331', 'vijay kumar jain', '9893565069', 'kalani nagar', '1700286051.1222630188.jpg', '', '', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(25, '2023-11-20 10:29:31', '2023-11-20 10:29:31', 22, 104, '1', '2023-11-20', NULL, 'abhay pratap singh', '1996-04-11', '637152249137', '7523877288', 'abhaykeepworking@gmail.com', 'B+', 'no', '6 months', 'no', 'jobtype', NULL, 'softwer developer', 'just mind works', 'Comapany Name', NULL, 'ram karan singh', 'rent psu officer', 'amita singh', 'home maker', '9415154004', '7800430396', NULL, '838 new rananagar, near sarwmangala devi temple raebareli', 'uttar pradesh', '229001', 'ram karan singh', '7523877288', '838 new rananagar, near sarwmangala devi temple raebareli', '1700450971.1959437810.jpg', '', '', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(26, '2023-11-21 14:22:33', '2023-11-21 14:22:33', 23, 108, '1', '2023-11-20', NULL, 'aman sawle', '1996-04-25', '524931759223', '8120997629', 'ssg@indore', 'O+', 'no', '3+', 'no', 'jobtype', NULL, 'sales', NULL, 'institute Name', 'patanjali', 'kailash sawle', 'businessman', 'anjana sawle', 'home maker', '9926035440', '9981334466', 'ssg@indore', 'house no 108 gram babihar vanihar khargone', 'M P', '451440', 'kailesh sawle', '9981334466', 'house no 108 gram babihar vanihar khargone', '1700551353.711674034.jpg', '', '', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(27, '2023-11-24 14:08:42', '2023-11-24 14:08:42', 24, 101, '3', '2023-11-16', NULL, 'AYUSH SHARMA', '2004-08-07', '482264677925', '7869625984', 'Manojsir648@gmail.com', 'B+', 'no', '3+', 'no', 'coursetype', 'B.Com honours', NULL, NULL, 'institute Name', 'Renaissance college', 'Manoj Sharma', 'Kisan', 'Sunita Sharma', 'housewife', '9893186497', '7869625984', 'Manojsir648@gmail.com', '15d, nadi pare tal murad.gird.gwalior', 'M P', '474006', 'Manoj Sharma', '9893186497', '15d, nadi pare tal murad.gird.gwalior', '1700809722.911423398.jpg', '', '', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(28, '2023-12-02 16:25:18', '2023-12-02 16:25:18', 25, 103, '2', '2023-11-24', NULL, 'hirday joshi', '2000-01-01', '271066467205', '9024292121', 'ssg@indore', 'B+', 'no', '3+', 'no', 'coursetype', 'school', NULL, NULL, 'institute Name', 'Tiny tots public school barmer', 'sandeep joshi', 'service', 'Daksha joshi', 'house wife', '6376055825', '8209503451', 'ssg@indore', '-joshio ka upperla bass barmer', 'rajsthan', '344001', 'sandeep joshi', '6376055825', '-joshio ka upperla bass barmer', '1701509118.526410792.jpg', '', '', '1', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(29, '2023-12-06 15:45:49', '2023-12-06 15:45:49', 26, 105, '3', '2023-12-06', NULL, 'Nayan Dengre', '2003-05-21', '440239367098', '8226059420', 'nayandengre123@gmail.com', 'A+', 'no', '1 month', 'no', 'coursetype', 'Hotel management', NULL, NULL, 'instituteName', 'Shelf', 'Pushendra Dengre', 'Bussiness man', 'Archna Dengre', 'House wife', '8226059420', '9009219583', 'nayandengre123@gmail.com', 'Panna mord, katni', 'Pushendra Dengre', '483501', 'Nancy Dengre', '9009219583', 'Anoop Nagar, lig, indore', '1701852301.515138044.jpg', '1701852301.1321984942.jpg', '1701852301.293481057.jpg', '1', 1, NULL, NULL, NULL, '1701852301.968055691.jpg', '1701852301.1682334611.jpg', NULL),
(30, '2023-12-06 19:35:20', '2023-12-06 19:35:20', 27, 106, '2', '2023-12-06', NULL, 'Yamunesh Kaushik', '1998-11-11', '924424023022', '9929163509', 'yuvi.kaushik1034@gmail.com', 'O+', 'no', '3 months', 'no', 'coursetype', 'Aviation', NULL, NULL, 'instituteName', 'Dfly', 'Lt Rajendra kaushik', 'Self employed', 'Lt Manju sharma', 'Nurse', '9413705833', '9413706251', 'sharmasantosh89@yahoo.com', 'C-188 Pratap nagar Chittorgarh', 'Lt Rajendra kaushik', '312001', 'Giriraj prasad sharma', '9413705833', 'C-188 Pratap nagar Chittorgarh', '1701866026.1130611491.jpg', '1701866026.328439660.jpg', '1701866026.278746355.jpg', '1', 1, NULL, NULL, NULL, '1701866026.1030654245.jpg', '1701866026.336649333.jpg', NULL),
(31, '2023-12-08 16:54:12', '2023-12-08 16:54:12', 28, 104, '2', '2023-12-07', NULL, 'Animesh Singh Dhariwal', '2000-01-01', '288573559817', '8770715723', 'animesh.online11@gmail.com', 'A+', 'no', '3', 'no', 'coursetype', 'CAT', NULL, NULL, 'instituteName', 'Ims', 'SK Dhariwal', 'Seed Certification Officer', 'Rekha Rani Dhariwal', 'Housewife', '9893068697', NULL, 'booyaka.619.as@gmail.com', '1161,Near Durga Mandir , J.P Nagar , Adhartal , Jabalpur, Baba ki bagiya', 'SK Dhariwal', '482001', 'SK Dhariwal', '9893068697', '1161,Near Durga Mandir , J.P Nagar , Adhartal , Jabalpur', '1702017865.1085672745.jpg', '1702017865.552833266.jpg', '1702017865.621080961.jpg', '1', 1, NULL, 'no', NULL, '1702017865.947881122.jpg', '1702017865.1490865011.jpg', NULL),
(32, '2023-10-11 23:37:00', '2023-10-11 23:37:00', 29, 209, '1', '2023-10-11', NULL, 'Ayushi Singh', '1999-07-05', '458216983897', '7985959240', 'SAYU6435@GMAIL.COM', 'A+', 'yes', '3 month', 'no', 'jobtype', NULL, 'COMMUNICATION CENTER', 'CIBOM', 'Comapany Name', 'CIBOM', 'MR I P SINGH', 'CIVIL ENGINEER', 'MRS NEELAM SINGH', 'house wife', '7082719356', NULL, NULL, 'AZIZ NAGAR, MOHIBULLAHPUR, NEAR BAL NIKUNJ COLLEGE, LUCKNOW', 'UTTAR PRADESH', '226021', 'MR I P SINGH', '7082719356', 'AZIZ NAGAR, MOHIBULLAHPUR, NEAR BAL NIKUNJ COLLEGE, LUCKNOW', '1697042220.692138357.jpeg', '', '', '0', 1, '2023-11-28', 'MIGRANE', NULL, NULL, NULL, NULL),
(33, '2023-12-11 15:30:25', '2023-12-11 15:30:25', 30, 110, '2', '2023-12-11', NULL, 'Shriyansh Soni', '1461-09-14', '897625519979', '6260181155', 'shriyanshsoni54@gmail.com', 'O+', 'no', '3 month', 'no', 'coursetype', 'BBA', NULL, NULL, 'instituteName', 'Renessance college', 'Chetan soni', 'Business', 'Meenu soni', 'House wife', '9131772156', '6260181155', 'shriyanshoni54@gnail.com', 'Fowara chowk manendrgarh', 'Chetan soni', '497442', 'Chetan soni', '9131772155', 'Fowara chowk manendragarh', '1702133833.815298857.JPG', '1702133833.907441828.jpg', '1702133833.1757089954.jpg', '1', 1, NULL, NULL, NULL, '1702133833.1050686050.JPG', '1702133833.2117456985.JPG', NULL),
(34, '2023-12-11 18:44:50', '2023-12-11 18:44:50', 31, 108, '2', '2023-12-08', NULL, 'Bhadrayu Singh Panwar', '1998-01-09', '597432266838', '6262330039', 'panwarbhadrayu@gmail.com', 'B+', 'no', '1', 'no', 'coursetype', 'Pgdac', NULL, NULL, 'instituteName', 'Orlando', 'Rajendra Singh Panwar', 'Government servent', 'Mithlesh panwar', 'House wife', '6262330039', NULL, 'panwarbhadrayu@gmail.com', 'House no 1719 basant bahar colony khandwa MadhyaPradesh', 'Rajendra Singh Panwar', '450001', 'Rajendra panwar', '9754950435', 'House no 1719 basant bahar colony khandwa MadhyaPradesh', '1702295019.1468477655.jpg', '1702295019.33915886.jpg', '1702295019.1017799478.jpg', '0', 1, '2024-01-05', NULL, NULL, '1702295019.832696985.jpg', '1702295019.1842961940.jpg', NULL),
(35, '2023-12-12 13:23:26', '2023-12-14 11:49:04', 32, 109, '1', '2023-12-10', NULL, 'Aniq Haider', '2000-12-08', '246495601020', '8318842530', 'aniqhaider@gmail.com', 'AB+', 'no', '1 month', 'no', 'jobtype', '', 'Internship', 'Primathon', 'ComapanyName', 'Primathon', 'Laiq Haider', 'Business', 'Tasneem Haider', 'Teacher', '6392747666', '9026313846', 'tasneemhaider60@gmail.com', 'A-17/25 Pathani Tola , Vishweshvarganj, Varanasi', 'Laiq Haider', '221001', 'Syed Gulfam Ali', '9098073500', '513, Greater Brijeshwari Colony near Sakar Kunj campus. Pipliyahana,Indore', '1702349601.988849270.jpg', '1702349601.1631050870.jpg', '1702349601.1028302285.jpg', '1', 1, NULL, '', '', '1702349601.355256119.jpg', '1702349601.1370301701.jpg', NULL),
(36, '2023-12-13 14:15:15', '2023-12-13 14:15:15', 33, 208, '2', '2023-12-13', NULL, 'Khushi Chakrawarti', '2002-05-09', '696538227638', '7999240436', 'khushichakrawarti95@gmail.com', 'B+', 'no', '3', 'no', 'coursetype', 'Ca Intern', NULL, NULL, 'instituteName', 'RK GURBANI AND CO', 'Manoj Chakrawarti', 'Business', 'Neeta Chakrawarti', 'Housewife', '9893085505', NULL, 'khushichakrawarti95@gmail.com', 'Ward no. 06 Khalwara Bazaar kymore katni', 'Manoj Chakrawarti', '483880', 'Kunj Pithadia', '8982563241', '3/2 Bhandari Marg ,indore', '1702451672.1561467091.jpg', '1702451672.2126559047.jpg', '1702451672.1807543247.jpg', '1', 1, NULL, NULL, NULL, '1702451672.1112982687.jpg', '1702451672.410330977.jpg', NULL),
(37, '2023-12-14 21:21:56', '2023-12-14 21:21:56', 34, 209, '1', '2023-12-13', NULL, 'Sakshi Chaturvedi', '1996-01-05', '498403631298', '7692911621', 'sakshishastri07@gmail.com', 'O-', 'no', 'December', 'no', 'jobtype', NULL, 'Business analyst', 'Sgs consulting', 'ComapanyName', NULL, 'Mr Manoj Narayan Chaturvedi', 'Govt job', 'Mrs Seema Chaturvedi', 'Home maker', '8839264987', NULL, NULL, '256 Rohit Nagar Road Aakriti Ecocity Salaiya, Near Bisoniya hospital', 'Mr Manoj Narayan Chaturvedi', '462039', 'Sakshi Chaturvedi', '8839264977', '256 Rohit Nagar Road Aakriti Ecocity Salaiya', '1702558753.13516382.jpg', '1702558753.617270976.jpg', '1702558753.1238427973.jpg', '1', 1, NULL, NULL, NULL, '1702558753.1243521458.jpg', '1702558753.1821067581.jpg', NULL),
(38, '2023-12-19 12:20:26', '2023-12-19 12:20:26', 35, 109, '2', '2023-12-17', NULL, 'Rahul banjara', '1994-07-09', '877991275562', '7000404413', 'b94rahul@gmail.com', 'B+', 'no', '1month', 'no', 'jobtype', NULL, 'Self', 'Self', 'ComapanyName', NULL, 'Rupesh banjara', 'Business', 'Jaya banjara', 'House wife', '7000404413', '6265343377', 'b94rahul@gmail.com', '163,shastri nagar', 'Rupesh banjara', '457001', 'Pankaj banjara', '6265343377', '163,shastri nagar ratlam', '1702890617.1142608854.jpg', '1702890617.1907457158.jpg', '1702890617.1787295140.jpg', '1', 1, NULL, NULL, NULL, '1702890617.1203219069.jpg', '1702890617.115513067.jpg', NULL),
(39, '2023-12-22 12:03:24', '2023-12-22 12:03:24', 36, 107, '1', '2023-12-22', NULL, 'Mohd kasif wasi', '2002-07-24', '834788181939', '7007560429', 'Mohdkashifkhan66@gmail.com', 'AB+', 'no', '3', 'no', 'jobtype', NULL, 'Full time', 'Gramophone', 'ComapanyName', NULL, 'Vaseeuzzama', 'Business', 'Israt  jahan', 'House wife', '8081760761', NULL, NULL, '132/350 babu purwa t.p nagar', 'Vaseeuzzama', '208023', 'Vaseeuzzama', '8081760761', '132/350 babu purwa nai masjid', '1703174226.247202117.jpg', '1703174226.706960545.jpg', '1703174226.111345914.jpg', '1', 1, NULL, NULL, NULL, '1703174226.1763968926.jpg', '1703174226.962534430.jpg', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `students_electricity_bill`
--

CREATE TABLE `students_electricity_bill` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `roomNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seatNo` int(11) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `unit` decimal(10,2) DEFAULT NULL,
  `prUnitCharge` decimal(10,2) DEFAULT NULL,
  `Amount` double NOT NULL DEFAULT '0',
  `billDate` date DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `invoiceno` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `students_electricity_bill`
--

INSERT INTO `students_electricity_bill` (`id`, `roomNo`, `seatNo`, `userId`, `unit`, `prUnitCharge`, `Amount`, `billDate`, `status`, `invoiceno`, `created_at`, `updated_at`) VALUES
(3, '101', 2, 12, 51.00, 12.00, 132, '2023-11-06', 0, NULL, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(4, '101', 1, 13, 51.00, 12.00, 132, '2023-11-06', 0, NULL, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(5, '103', 1, 3, 45.00, 18.00, 198, '2023-11-06', 0, NULL, '2023-12-03 19:25:14', '2023-12-03 19:25:14'),
(6, '105', 1, 9, 45.00, 9.00, 99, '2023-11-06', 0, NULL, '2023-12-03 19:25:15', '2023-12-03 19:25:15'),
(7, '105', 2, 10, 45.00, 9.00, 99, '2023-11-06', 0, NULL, '2023-12-03 19:25:15', '2023-12-03 19:25:15'),
(10, '111', 1, 6, 45.00, 9.96, 109.56, '2023-11-06', 0, NULL, '2023-12-03 19:25:15', '2023-12-03 19:25:15'),
(11, '111', 2, 18, 45.00, 8.04, 88.44, '2023-11-06', 0, NULL, '2023-12-03 19:25:15', '2023-12-03 19:25:15'),
(14, '203', 1, 20, 41.00, 14.00, 154, '2023-11-06', 0, NULL, '2023-12-03 19:25:16', '2023-12-03 19:25:16'),
(15, '204', 1, 1, 37.00, 5.37, 59.07, '2023-11-06', 0, NULL, '2023-12-03 19:25:16', '2023-12-03 19:25:16'),
(16, '204', 2, 5, 37.00, 4.63, 50.93, '2023-11-06', 0, NULL, '2023-12-03 19:25:16', '2023-12-03 19:25:16'),
(17, '205', 1, 14, 48.00, 21.00, 231, '2023-11-06', 0, NULL, '2023-12-03 19:25:16', '2023-12-03 19:25:16'),
(18, '206', 1, 17, 37.00, 10.00, 110, '2023-11-06', 0, NULL, '2023-12-03 19:25:16', '2023-12-03 19:25:16'),
(19, '208', 1, 19, 37.00, 10.00, 110, '2023-11-06', 0, NULL, '2023-12-03 19:25:17', '2023-12-03 19:25:17'),
(21, '210', 1, 4, 56.00, 29.00, 319, '2023-11-06', 0, NULL, '2023-12-03 19:25:17', '2023-12-03 19:25:17'),
(22, '106', 1, 21, 4.00, 0.00, 0, '2023-11-06', 0, NULL, '2023-12-04 13:36:53', '2023-12-04 13:36:53'),
(23, '110', 1, 22, 16.00, 0.00, 0, '2023-11-06', 0, NULL, '2023-12-04 13:37:12', '2023-12-04 13:37:12'),
(24, '209', 1, 16, 11.00, 0.00, 0, '2023-11-06', 0, NULL, '2023-12-04 13:39:52', '2023-12-04 13:39:52'),
(25, '101', 2, 12, 37.00, 3.75, 41.25, '2023-12-06', 0, NULL, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(26, '101', 1, 13, 37.00, 3.75, 41.25, '2023-12-06', 0, NULL, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(27, '101', 3, 27, 37.00, 2.50, 27.5, '2023-12-06', 0, NULL, '2023-12-07 14:11:51', '2023-12-07 14:11:51'),
(28, '103', 1, 3, 29.00, 1.43, 15.73, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(29, '103', 2, 28, 29.00, 0.57, 6.27, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(30, '104', 1, 25, 12.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(31, '105', 1, 9, 29.00, 1.00, 11, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(32, '105', 2, 10, 29.00, 1.00, 11, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(33, '105', 3, 29, 29.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(34, '106', 1, 21, 12.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(35, '106', 2, 30, 12.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(36, '108', 1, 26, 0.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(37, '110', 1, 22, 0.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:52', '2023-12-07 14:11:52'),
(38, '111', 1, 6, 6.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:53', '2023-12-07 14:11:53'),
(39, '111', 2, 18, 6.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:53', '2023-12-07 14:11:53'),
(40, '201', 1, 23, 9.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:53', '2023-12-07 14:11:53'),
(42, '203', 1, 20, 27.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:53', '2023-12-07 14:11:53'),
(43, '204', 1, 1, 30.00, 3.00, 33, '2023-12-06', 0, NULL, '2023-12-07 14:11:53', '2023-12-07 14:11:53'),
(44, '205', 1, 14, 46.00, 19.00, 209, '2023-12-06', 0, NULL, '2023-12-07 14:11:53', '2023-12-07 14:11:53'),
(45, '206', 1, 17, 30.00, 3.00, 33, '2023-12-06', 0, NULL, '2023-12-07 14:11:53', '2023-12-07 14:11:53'),
(46, '207', 1, 24, 16.00, 0.00, 0, '2023-12-06', 0, NULL, '2023-12-07 14:11:53', '2023-12-07 14:11:53'),
(47, '208', 1, 19, 30.00, 3.00, 33, '2023-12-06', 0, NULL, '2023-12-07 14:11:54', '2023-12-07 14:11:54'),
(49, '210', 1, 4, 30.00, 3.00, 33, '2023-12-06', 0, NULL, '2023-12-07 14:11:54', '2023-12-07 14:11:54'),
(58, '103', 1, 3, 0.00, 0.00, 0, '2023-10-01', 0, NULL, '2023-12-10 20:11:39', '2023-12-10 20:11:39'),
(59, '204', 1, 1, 0.00, 0.00, 0, '2023-10-01', 0, NULL, '2023-12-10 20:13:24', '2023-12-10 20:13:24'),
(60, '202', 1, 15, 65.00, 18.03, 198.33, '2023-11-06', 0, NULL, '2023-12-10 20:14:59', '2023-12-10 20:14:59'),
(61, '202', 2, 8, 65.00, 19.97, 219.67, '2023-11-06', 0, NULL, '2023-12-10 20:14:59', '2023-12-10 20:14:59'),
(62, '209', 1, 32, 16.00, 16.00, 176, '2023-12-06', 0, NULL, '2023-12-10 20:15:38', '2023-12-10 20:15:38'),
(64, '202', 2, 8, 45.00, 9.00, 99, '2023-12-06', 0, NULL, '2023-12-11 17:14:02', '2023-12-11 17:14:02'),
(65, '202', 1, 15, 45.00, 9.00, 99, '2023-12-06', 0, NULL, '2023-12-11 17:14:02', '2023-12-11 17:14:02');

-- --------------------------------------------------------

--
-- Table structure for table `table_student_electicity_bill_records`
--

CREATE TABLE `table_student_electicity_bill_records` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `roomno` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `candidate_id` int(11) DEFAULT NULL,
  `seat_no` int(11) DEFAULT NULL,
  `joining_date` date NOT NULL,
  `leaving_date` date DEFAULT NULL,
  `reading_start_date` date NOT NULL,
  `reading_end_date` date NOT NULL,
  `total_reading_candidate` float NOT NULL DEFAULT '0',
  `reading_amount` float DEFAULT '0',
  `total_reading` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `take_attendances`
--

CREATE TABLE `take_attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `emp_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('Present','Absent','Late') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Present',
  `time_in` time DEFAULT NULL,
  `time_out` time DEFAULT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tanantComplaints`
--

CREATE TABLE `tanantComplaints` (
  `id` int(11) NOT NULL,
  `complaint_date` date DEFAULT NULL,
  `complaint_type` varchar(255) DEFAULT NULL,
  `studentId` int(11) DEFAULT NULL,
  `complaint_msg` text,
  `responseMsg` text,
  `document` varchar(255) DEFAULT NULL,
  `action` int(11) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tanantNotice`
--

CREATE TABLE `tanantNotice` (
  `id` int(11) NOT NULL,
  `noticeDate` date DEFAULT NULL,
  `noticeType` varchar(255) DEFAULT NULL,
  `studentId` int(11) DEFAULT NULL,
  `NoticeMsg` text,
  `responseMsg` text,
  `document` varchar(255) DEFAULT NULL,
  `action` int(11) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tanantNotice`
--

INSERT INTO `tanantNotice` (`id`, `noticeDate`, `noticeType`, `studentId`, `NoticeMsg`, `responseMsg`, `document`, `action`, `created_at`, `updated_at`) VALUES
(1, '2024-01-10', 'leaving', 1, 'i want leave the hostel 12/01/2024', NULL, '', 0, '2024-01-06 11:28:35', '2024-01-06 11:28:35');

-- --------------------------------------------------------

--
-- Table structure for table `termsandconditions`
--

CREATE TABLE `termsandconditions` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `termsandconditions` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `termsandconditions`
--

INSERT INTO `termsandconditions` (`id`, `created_at`, `updated_at`, `termsandconditions`) VALUES
(1, '2023-09-30 21:03:03', '2023-09-30 21:03:03', 'caution money/security deposit fully refundable, please keep the receipt carefully.'),
(2, '2023-09-30 21:03:22', '2023-09-30 21:03:22', 'caution money/security deposit refundable only after stay duration of 3 months.'),
(3, '2023-09-30 21:03:34', '2023-09-30 21:03:34', 'To get caution money/ security deposit apply 1 month in advance'),
(4, '2023-09-30 21:03:47', '2023-09-30 21:03:47', 'registration fees not refundable at any condition.'),
(5, '2023-09-30 21:03:59', '2023-09-30 21:03:59', 'room rent non refundable at any cost');

-- --------------------------------------------------------

--
-- Table structure for table `uploadprofiles`
--

CREATE TABLE `uploadprofiles` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `upload_name` varchar(225) NOT NULL,
  `upload_pdf` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uploadprofiles`
--

INSERT INTO `uploadprofiles` (`id`, `created_at`, `updated_at`, `upload_name`, `upload_pdf`) VALUES
(1, '2023-10-01 16:33:44', '2023-10-01 16:33:44', 'Stamp With Signature', '1696152824_34919298.jpeg'),
(2, '2023-10-12 14:35:50', '2023-10-06 21:04:26', 'Rules & Regulations', '1697121350_1439986890.pdf');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addmenuitems`
--
ALTER TABLE `addmenuitems`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custome_reveived_amounts`
--
ALTER TABLE `custome_reveived_amounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customsalesales`
--
ALTER TABLE `customsalesales`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `electicity_management`
--
ALTER TABLE `electicity_management`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expensedetails`
--
ALTER TABLE `expensedetails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `leadmanagers`
--
ALTER TABLE `leadmanagers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `masterroomseats`
--
ALTER TABLE `masterroomseats`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mealtypes`
--
ALTER TABLE `mealtypes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menuitems`
--
ALTER TABLE `menuitems`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu_images`
--
ALTER TABLE `menu_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `olddataregisters`
--
ALTER TABLE `olddataregisters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `recieve_amounts`
--
ALTER TABLE `recieve_amounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `registers`
--
ALTER TABLE `registers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`,`created_at`,`updated_at`);

--
-- Indexes for table `roomseats`
--
ALTER TABLE `roomseats`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `self_student_registration`
--
ALTER TABLE `self_student_registration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `share_menus`
--
ALTER TABLE `share_menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `studentregisters`
--
ALTER TABLE `studentregisters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `students_electricity_bill`
--
ALTER TABLE `students_electricity_bill`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `table_student_electicity_bill_records`
--
ALTER TABLE `table_student_electicity_bill_records`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tanantComplaints`
--
ALTER TABLE `tanantComplaints`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tanantNotice`
--
ALTER TABLE `tanantNotice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `termsandconditions`
--
ALTER TABLE `termsandconditions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `uploadprofiles`
--
ALTER TABLE `uploadprofiles`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `addmenuitems`
--
ALTER TABLE `addmenuitems`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `custome_reveived_amounts`
--
ALTER TABLE `custome_reveived_amounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customsalesales`
--
ALTER TABLE `customsalesales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `electicity_management`
--
ALTER TABLE `electicity_management`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT for table `expensedetails`
--
ALTER TABLE `expensedetails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `leadmanagers`
--
ALTER TABLE `leadmanagers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `masterroomseats`
--
ALTER TABLE `masterroomseats`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mealtypes`
--
ALTER TABLE `mealtypes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `menuitems`
--
ALTER TABLE `menuitems`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `menu_images`
--
ALTER TABLE `menu_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `olddataregisters`
--
ALTER TABLE `olddataregisters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `recieve_amounts`
--
ALTER TABLE `recieve_amounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133;

--
-- AUTO_INCREMENT for table `registers`
--
ALTER TABLE `registers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roomseats`
--
ALTER TABLE `roomseats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;

--
-- AUTO_INCREMENT for table `self_student_registration`
--
ALTER TABLE `self_student_registration`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `share_menus`
--
ALTER TABLE `share_menus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `studentregisters`
--
ALTER TABLE `studentregisters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `students_electricity_bill`
--
ALTER TABLE `students_electricity_bill`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT for table `table_student_electicity_bill_records`
--
ALTER TABLE `table_student_electicity_bill_records`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tanantComplaints`
--
ALTER TABLE `tanantComplaints`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tanantNotice`
--
ALTER TABLE `tanantNotice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `termsandconditions`
--
ALTER TABLE `termsandconditions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `uploadprofiles`
--
ALTER TABLE `uploadprofiles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

