-- Table structure for table `pan_verify_hkb`
--

CREATE TABLE `pan_verify_hkb` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `fathername` varchar(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `dob` varchar(100) NOT NULL,
  `pan` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `date` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pan_verify_hkb`
--

INSERT INTO `pan_verify_hkb` (`id`, `name`, `fathername`, `gender`, `dob`, `pan`, `username`, `date`) VALUES
(1, 'SANTOSH  MAURYA', 'LOK NATH MAURYA', 'MALE', '02-08-1996', 'ESRPM6020H', '8699591290', '18/01/2024 8:03:55'),
(2, 'SANTOSH  MAURYA', 'LOK NATH MAURYA', 'MALE', '02-08-1996', 'ESRPM6020H', '8699591290', '18/01/2024 8:04:41'),
(3, 'MANPREET  KAUR', 'MITHU  SINGH', 'FEMALE', '15-05-1991', 'CQRPK9535R', '8699591290', '13/02/2024 11:30:55'),
(4, 'VIMLA  DEVI', '  RAMRATAN', 'FEMALE', '01-01-1992', 'EGTPD5626L', '8356848121', '20/02/2024 1:14:23'),
(5, 'SANTOSH  MAURYA', 'LOK NATH MAURYA', 'MALE', '02-08-1996', 'ESRPM6020H', '8699591290', '02/03/2024 2:11:12'),
(6, 'MANDEEP  SINGH', 'TARSEM  SINGH', 'MALE', '09-10-1995', 'JWTPS0067K', '9653056786', '05/03/2024 10:07:13'),
(7, 'VARINDER KUMAR VERMA', 'SUKHDEV  KUMAR', 'MALE', '27-06-1989', 'BUZPV1631A', '9878322513', '26/03/2024 11:35:18'),
(8, '  USHA', 'PREM  NATH', 'FEMALE', '15-12-1985', 'ACBPU7656F', '7307166002', '28/03/2024 2:50:17'),
(9, '  USHA', 'PREM  NATH', 'FEMALE', '15-12-1985', 'ACBPU7656F', '7307166002', '29/03/2024 6:03:00'),
(10, '  USHA', 'PREM  NATH', 'FEMALE', '18-10-1983', 'ACBPU7656F', '7307166002', '31/03/2024 2:10:10'),
(11, 'NEHA  DEVI', '  KAILASH', 'FEMALE', '05-05-1998', 'EAXPD7433R', '8356848121', '03/04/2024 2:33:12'),
(12, '  KAVITA', '  GOVARDHAN', 'FEMALE', '08-12-1990', 'LOKPK1777D', 'ADMIN', '15/04/2024 12:24:15'),
(13, 'MOBARAK  ANSARI', 'ALAUDDIN  ANSARI', 'MALE', '18-05-2000', 'CYOPA5748M', '8617858750', '20/04/2024 12:07:33'),
(14, 'MOHD ZAKIR HUSSAIN', 'MOHD SAALIM HUSSAIN', 'MALE', '05-01-1996', 'ANIPH0221P', '6299991996', '25/04/2024 8:42:06'),
(15, 'RAJANISH KUMAR MISHRA', 'SURYA NARAYAN MISHRA', 'MALE', '02-02-1990', 'czapm9259e', '7870380381', '26/04/2024 10:34:21'),
(16, 'MANISH  KUMAR', 'SOHAN  PRASAD', 'MALE', '01-01-1990', 'LNPPK4946Q', '9801939381', '29/04/2024 2:42:55'),
(17, 'KARAN  KUMAR', 'MUNNA  PRASAD', 'MALE', '01-01-2006', 'OMZPK3592Q', '9801939381', '04/05/2024 8:08:27'),
(18, 'VISHAL  KUMAR', 'ASHOK KUMAR PANDEY', 'MALE', '14-11-1990', 'FBNPK7020M', '7033665817', '05/05/2024 2:43:15'),
(19, 'ARUN  KUMAR', 'MISRI  SINGH', 'MALE', '12-01-1967', 'CTMPK4054M', '7033665817', '07/05/2024 11:18:24'),
(20, 'CHANAMUNI  KUMARI', 'RAMBACHAN  SINGH', 'FEMALE', '10-10-1993', 'KNKPK9149B', '6299991996', '09/05/2024 1:39:10'),
(21, 'GORAKHNATH RAMAYAN RAM', 'RAMAYAN BRIJNADAN RAM', 'MALE', '28-01-1971', 'AMGPR3790N', '6299991996', '11/05/2024 10:03:48'),
(22, 'MANORMA  DEVI', 'DHANI  SINGH', 'FEMALE', '01-01-1957', 'EHFPD4528E', '6299991996', '11/05/2024 10:04:17'),
(23, 'ASHWINI GOVIND DHUMAL', 'SAMBHAJI TATERAO BIRAJDAR', 'FEMALE', '01-01-1994', 'FKAPD0191N', '8905993904', '12/05/2024 6:11:48'),
(24, 'NAUSHAD AHMAD MALLICK', 'EHATASHAMUDDIN AHMAD MALLICK', 'MALE', '11-12-1974', 'BGXPM0360B', '7033665817', '16/05/2024 10:55:09'),
(25, 'SHIV  KUMAR', 'SUBHASH  CHAND', 'MALE', '05-10-1983', 'AFLPT7010H', '9988194455', '17/05/2024 5:43:32'),
(26, 'KRISHNA  GUPTA', 'JAGDESH NARAYAN GUPTA', 'FEMALE', '15-06-1967', 'AESPG3227K', '7417957880', '18/05/2024 10:51:42'),
(27, 'BHIM  CHAUDHARI', 'YOGENDRA  CHAUDHARI', 'MALE', '01-01-1997', 'BICPC3215J', '7320972673', '20/05/2024 2:21:39'),
(28, 'AJAY KUMAR SAHU', 'NANDEV  SAHU', 'MALE', '15-07-1996', 'NTWPS0712K', '8969056208', '23/05/2024 3:58:39'),
(29, 'SUBASH  PRASAD', 'MOHAN  PRASAD', 'MALE', '01-02-2006', 'IFIPP9355G', '8969056208', '23/05/2024 6:46:51'),
(30, 'ANIL KUMAR NAGAR', 'RAMESHWAR PRASAD NAGAR', 'MALE', '25-10-1987', 'AIXPN6088L', '8770427621', '23/05/2024 10:17:33'),
(31, 'ANIL KUMAR NAGAR', 'RAMESHWAR PRASAD NAGAR', 'MALE', '25-10-1987', 'AIXPN6088L', '8770427621', '23/05/2024 10:18:10'),
(32, 'ARJUN  SINGH', 'AMAR  SINGH', 'MALE', '15-04-1962', 'AMCPS9312F', '9988194455', '24/05/2024 12:09:26'),
(33, 'TILAK  KUMAR', 'AMI  CHAND', 'MALE', '03-05-1986', 'BCQPK3704G', '8770427621', '24/05/2024 1:05:00'),
(34, 'MUNNA  KHAN', 'ABDUL JABBAR  KHAN', 'MALE', '16-03-1984', 'GROPK6015A', '8969056208', '26/05/2024 4:31:20'),
(35, 'GUDIYA  DEVI', 'LORI  MANDAL', 'FEMALE', '01-01-1996', 'FCCPD5487B', '9801939381', '27/05/2024 7:16:29'),
(36, 'PUSHPENDRA  TIWARI', 'NATTHI LAL TIWARI', 'MALE', '22-05-1995', 'ATBPT9087A', '8770427621', '01/06/2024 3:47:00'),
(37, '  ALHAIT', '  CHHOTE', 'MALE', '01-01-1970', 'EDCPA3040R', '8175098216', '03/06/2024 10:23:33'),
(38, 'RAKESH  KUMAR', 'JAGDISH  SAAH', 'MALE', '01-08-1981', 'BJFPK6856D', '9801939381', '03/06/2024 7:49:41'),
(39, 'ROHIT  KATARIA', 'SUBHASH  CHANDER', 'MALE', '02-05-1991', 'BNPPK4923H', '8770427621', '06/06/2024 12:16:03'),
(40, 'SIDDHESHWAR APAPARAO NAKADE', 'APAPARAO  NAKADE', 'MALE', '01-01-1948', 'CAEPN7444R', '8905993904', '10/06/2024 9:40:21'),
(41, 'BUKKE  SUBBAMMA', 'MUDE  CHEEMALA NAIK', 'FEMALE', '01-01-1958', 'HZMPS9171N', '7981121611', '11/06/2024 3:32:21');

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

--
-- Table structure for table `pricing`
--

CREATE TABLE `pricing` (
  `id` int(11) NOT NULL,
  `service_name` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pricing`
--

INSERT INTO `pricing` (`id`, `service_name`, `price`) VALUES
(1, 'aadhaarpdf', '500'),
(2, 'aadhaar_no', '500'),
(3, 'pan_pdf', '60'),
(4, 'pan_no', '30'),
(5, 'aadhaaar_advance_fee', '30'),
(6, 'aadhar_manual_fee', '10'),
(7, 'rasan_to_aadhar_pdf', '700'),
(8, 'certificate_apply', '100'),
(9, 'epictopdfapply', '30'),
(10, 'dl_pdf', '30'),
(11, 'rasan_card', '30'),
(12, 'covid_1_dose', '600'),
(13, 'covid_1_2_dose', '600'),
(14, 'kafilapay', '600'),
(15, 'covid_2_dose', '600'),
(16, 'aadhaar_pdf', '500'),
(17, 'voter_original_fee', '30'),
(18, 'voter_manual_hkb', '20'),
(19, 'dl_no', '100'),
(20, 'kafilapass', '200'),
(21, 'sampay', '60'),
(22, 'upbpay', '100'),
(23, 'voter_manual_fee', '10'),
(24, 'instant_pan_manual_fee', '10'),
(25, 'instant_pan', '30'),
(50, 'generated_eid', '30'),
(51, 'job_card_fee', '20'),
(52, 'v_mobile_link', '20'),
(54, 'pan_details_verify', '10'),
(55, 'dl_gf_instant', '30'),
(56, 'voter_org_fee', '20'),
(57, 'rc_vehical_fee', '50'),
(58, 'ayushman_fee', '50'),
(59, 'ration_pdf_hkb_print_fee', '50'),
(60, 'birth', '200');

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

--
-- Table structure for table `rasan_card`
--

CREATE TABLE `rasan_card` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dl_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rasan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rasan_card`
--

INSERT INTO `rasan_card` (`id`, `application_no`, `appliedby`, `dl_no`, `rasan_no`, `name`, `pan_no`, `eid`, `date`, `time`, `pdf_link`, `status`, `fee`, `ret_wp_no`, `aadhaar_no`, `state`, `apply_date`) VALUES
(75, 'AHK88729117', '7837641108', NULL, '030006902787', 'SWARCHA', NULL, NULL, '01/01/1951', NULL, 'https://nsdlpanfind.in/admin/uploads/751158030006902787.pdf', 'success', '20', '7837641108', '030006902787', 'PUNJAB', '2023-02-15 17:08:19'),
(76, 'AHK59537979', '7837641108', NULL, '030003114711', 'mamta', NULL, NULL, '01/01/1992', NULL, 'https://nsdlpanfind.in/admin/uploads/742540030003114711.pdf', 'success', '30', '8847004972', '030003114711', 'PUNJAB', '2023-02-27 15:13:35'),
(77, 'AHK27538723', '7699102800', NULL, '103655908', 'Saju Sardar', NULL, NULL, '24/10/1998', NULL, 'https://nsdlpanfind.in/admin/uploads/15549NODATA.JPG', 'success', '30', '7699102800', '103655908	', 'WEST BENGAL', '2023-02-28 10:47:14'),
(78, 'AHK92053689', '7238891681', NULL, '219541604545', 'SARITA CHAUHAN', NULL, NULL, '15/07/2000', NULL, '../admin/uploads/83985pdf (20).pdf', 'success', '25', '7238891681', NULL, 'UTTAR PRADESH', '2023-03-15 17:02:29'),
(79, 'AHK24790287', '7417513101', NULL, '113840876346', 'ALKA GOEL', NULL, NULL, '07/08/1970', NULL, '../admin/uploads/95789pdf (21).pdf', 'success', '25', '7417513101', NULL, 'UTTAR PRADESH', '2023-03-18 22:56:19'),
(80, 'AHK54653005', 'admin', NULL, '030006331157', 'SUKHWINDER KAUR', NULL, NULL, '05/10/1981', NULL, '../admin/uploads/35441pdf (17).pdf', 'success', '25', 'admin', NULL, 'PUNJAB', '2023-03-21 20:50:30'),
(81, 'AHK98051338', '8475989282', NULL, '214840610063', 'ANAR DEVI', NULL, NULL, '01/01/1970', NULL, '../admin/uploads/99211pdf (26).pdf', 'success', '25', '8475989282', NULL, 'UTTAR PRADESH', '2023-03-22 17:21:43'),
(82, 'AHK24122114', '916906646', NULL, '217940741569', 'RAVI NISHAD', NULL, NULL, '05/05/1990', NULL, '../admin/uploads/63941pdf (27).pdf', 'success', '25', '9169066646', NULL, 'UTTAR PRADESH', '2023-03-22 21:10:33'),
(83, 'AHK41356722', '7973921838', NULL, '030006276262', 'GURMEET GORD', NULL, NULL, '08/07/1997', NULL, '../admin/uploads/6708pdf (28).pdf', 'success', '25', '7973921838', NULL, 'PUNJAB', '2023-03-23 13:36:31'),
(84, 'AHK63766062', '8840582591', NULL, '218810043450', 'Urmila ', NULL, NULL, '01/01/1972', NULL, 'https://nsdlpanfind.in/admin/uploads/373406pdf (31).pdf', 'success', '25', '8840582591', '218810043450', 'UTTAR PRADESH', '2023-03-23 20:52:38'),
(85, 'AHK15561980', '8840582591', NULL, '218810043450', 'Urmila ', NULL, NULL, '01/01/1971', NULL, 'https://nsdlpanfind.in/admin/uploads/45416pdf (31).pdf', 'success', '25', '8840582591', '218810043450', 'UTTAR PRADESH', '2023-03-23 21:24:33'),
(86, 'AHK12288644', '9870626683', NULL, '215021031082', 'CHAMELI DEVI ', NULL, NULL, '01/01/1973', NULL, 'https://nsdlpanfind.in/admin/uploads/816807pdf (39).pdf', 'success', '25', '9870626683', 'done', 'UTTAR PRADESH', '2023-03-24 15:34:57'),
(87, 'AHK37795244', '9634492941', NULL, ' 114240359037', 'Kusum Gautam', NULL, NULL, '01/01/1958', NULL, '../admin/uploads/93337pdf.pdf', 'success', '25', '9634492941', NULL, 'UTTAR PRADESH', '2023-03-24 18:33:40'),
(88, 'AHK17367616', '7236051899', NULL, '217340216225', 'Pankaj Saroj ', NULL, NULL, '02/05/2001', NULL, '../admin/uploads/80370pdf (1).pdf', 'success', '25', '7236051899', NULL, 'UTTAR PRADESH', '2023-03-24 18:39:07'),
(89, 'AHK80167302', '7678878817', NULL, '117620032520', 'RAJ RANI', NULL, NULL, '12/02/1961', NULL, '../admin/uploads/99921pdf (1).pdf', 'success', '25', '7678878817', NULL, 'UTTAR PRADESH', '2023-03-25 13:06:25'),
(90, 'AHK12375190', '9161311680', NULL, '217240917110', 'Nagma Begam', NULL, NULL, '01/01/1989', NULL, '../admin/uploads/1804pdf (6).pdf', 'success', '25', '9161311680', NULL, 'UTTAR PRADESH', '2023-03-29 12:49:26'),
(91, 'AHK89789286', 'admin', NULL, '218240731489', 'Pushpa', NULL, NULL, '01/01/1967', NULL, 'https://nsdlpanfind.in/admin/uploads/219955pdf (7).pdf', 'success', '10', 'admin', '218240731489', 'UTTAR PRADESH', '2023-03-30 21:00:10'),
(92, 'AHK55555146', '9056858481', NULL, '030006657379', 'RAJNI', NULL, NULL, '15/06/1979', NULL, 'https://nsdlpanfind.in/admin/uploads/524522030006657379.pdf', 'success', '10', '9056858481', '030006657379', 'PUNJAB', '2023-04-01 19:38:59'),
(93, 'AHK3354541', '8475989282', NULL, '214840372938', 'Kamla Devi', NULL, NULL, '01/01/1988', NULL, 'https://nsdlpanfind.in/admin/uploads/196574214840372938.pdf', 'success', '10', '8475989282', '214840372938', 'UTTAR PRADESH', '2023-04-02 11:49:46'),
(94, 'AHK46373409', '8608632454', NULL, '10190050091044500048', 'Priti Devi', NULL, NULL, '05/03/1985', NULL, 'https://nsdlpanfind.in/admin/uploads/398743wong data.JPG', 'success', '10', '8608632454', 'wrong data', 'UTTAR PRADESH', '2023-04-02 11:54:00'),
(95, 'AHK72687597', '8421215992', NULL, '736545247555', 'Vaishnavi Parmeshwar Mathpati', NULL, NULL, '19/04/2002', NULL, '', 'reject', '10', '8421215992', NULL, 'PUNJAB', '2023-04-05 11:25:30'),
(96, 'AHK76050402', '7518619358', NULL, '217840832104', 'ISHRAT JAHAN', NULL, NULL, '01/01/1993', NULL, 'https://nsdlpanfind.in/admin/uploads/748644217840832104.pdf', 'success', '10', '7518619358', '217840832104', 'UTTAR PRADESH', '2023-04-07 17:22:29'),
(97, 'AHK78474222', '8173006110', NULL, '116440942169', 'MAHRUBA KHATUN', NULL, NULL, '01/01/1970', NULL, 'https://nsdlpanfind.in/admin/uploads/919748NODATA.JPG', 'success', '10', '8173006110', 'no', 'UTTAR PRADESH', '2023-04-08 14:06:32'),
(98, 'AHK33251662', '9760117476', NULL, ' 213340962586', 'IMRANA PARVEEN', NULL, NULL, '30/01/1997', NULL, 'https://nsdlpanfind.in/admin/uploads/432825NODATA.JPG', 'success', '10', '9760117476', 'no', 'UTTAR PRADESH', '2023-04-08 18:21:48'),
(99, 'AHK83259314', '7518619358', NULL, '217840765204', 'FATAMA BANO', NULL, NULL, '01/01/1976', NULL, 'https://nsdlpanfind.in/admin/uploads/122099217840765204.pdf', 'success', '10', '7518619358', '217840765204', 'UTTAR PRADESH', '2023-04-09 11:56:36'),
(100, 'AHK32563021', '8840582591', NULL, '218841267509', 'Guddi', NULL, NULL, '01/01/1971', NULL, 'https://nsdlpanfind.in/admin/uploads/61579218841267509.pdf', 'success', '10', '8840582591', '218841267509', 'UTTAR PRADESH', '2023-04-15 11:58:23'),
(101, 'AHK44501689', '8840582591', NULL, '218841357929', 'Suman', NULL, NULL, '01/01/1994', NULL, 'https://nsdlpanfind.in/admin/uploads/768025218841357929.pdf', 'success', '10', '8840582591', '218841357929', 'UTTAR PRADESH', '2023-04-15 11:59:34'),
(102, 'AHK30899727', '8840582591', NULL, '218810043518', 'Urmila ', NULL, NULL, '01/01/1988', NULL, 'https://nsdlpanfind.in/admin/uploads/830363218810043518.pdf', 'success', '10', '8840582591', '218810043518', 'UTTAR PRADESH', '2023-04-15 12:00:25'),
(103, 'AHK54872428', '8858004338', NULL, '219041296565', 'BRIJBHUSHAN', NULL, NULL, '01/02/1989', NULL, 'https://nsdlpanfind.in/admin/uploads/976617219041296565.pdf', 'success', '10', '8858004338', '219041296565', 'UTTAR PRADESH', '2023-04-15 13:25:58'),
(104, 'AHK77330103', '9720065884', NULL, '213240875313', 'Farmani', NULL, NULL, '01/01/1985', NULL, 'https://nsdlpanfind.in/admin/uploads/930000213240875313.pdf', 'success', '10', '9720065884', '213240875313', 'UTTAR PRADESH', '2023-04-16 12:57:17'),
(105, 'AHK54277321', '9451513952', NULL, '2155414388005', 'HARIOM ', NULL, NULL, '03/05/2002', NULL, 'https://nsdlpanfind.in/admin/uploads/303631wong data.JPG', 'success', '10', '9451513952', 'WRONG DATA', 'UTTAR PRADESH', '2023-04-18 16:42:24'),
(106, 'AHK50114684', '9161311680', NULL, '217240917109', 'Shariphun Nisha', NULL, NULL, '01/01/1952', NULL, 'https://nsdlpanfind.in/admin/uploads/483313217240917109.pdf', 'success', '10', '9161311680', '217240917109', 'UTTAR PRADESH', '2023-04-18 19:15:17'),
(107, 'AHK3635632', 'admin', NULL, '4246776547', 'FSFG', NULL, NULL, '11/11/2022', NULL, NULL, 'pending', '10', 'admin', NULL, 'UTTAR PRADESH', '2023-04-20 10:10:08'),
(108, 'AHK57887804', '8318881762', NULL, '117840093282', 'ASHISH KUMAR VISHWAKARMA', NULL, NULL, '20/08/1987', NULL, 'https://nsdlpanfind.in/admin/uploads/670263117840093282.pdf', 'success', '10', '8318881762', '117840093282', 'UTTAR PRADESH', '2023-04-23 09:01:14'),
(109, 'AHK2209688', 'admin', NULL, '556677777777', 'HHHHHHH', NULL, NULL, '11/11/2022', NULL, NULL, 'pending', '10', 'admin', NULL, 'PUNJAB', '2023-04-23 14:23:05'),
(110, 'AHK98058809', 'admin', NULL, '3453566664646', 'SSSGSGGGG', NULL, NULL, '11/11/2022', NULL, 'https://mbajallive.xyz/admin/uploads/915931on recod.PNG', 'success', '10', 'admin', 'REFUND', 'MADHYA PRADESH', '2023-04-23 14:26:54'),
(111, 'AHK63585211', '8447480258', NULL, '217830084035', 'Sumitra Devi', NULL, NULL, '01/01/1968', NULL, 'https://nsdlpanfind.in/admin/uploads/818800217830084035.pdf', 'success', '10', '8447480258', '217830084035', 'UTTAR PRADESH', '2023-04-23 18:25:11'),
(112, 'AHK87663116', '9855503006', NULL, ' 030004431194', 'sandeep singh', NULL, NULL, '16/05/195_', NULL, 'https://mbajallive.xyz/admin/uploads/894570pdf (8).pdf', 'success', '50', '9855503006', '030004431194', 'PUNJAB', '2023-08-31 04:17:57'),
(113, 'AHK17167512', '9855677915', NULL, '030006912111', 'PAVITTAR KUMAR', NULL, NULL, '13/02/1972', NULL, 'https://mbajallive.xyz/admin/uploads/131420pdf (8).pdf', 'success', '50', '9855677915', '030006912111', 'PUNJAB', '2023-09-10 06:24:20'),
(114, 'AHK2700778', '8699591290', NULL, '218041191208', 'santosh maurya', NULL, NULL, '02/08/1996', NULL, 'https://mbajallive.xyz/admin/uploads/52541030006185813.pdf', 'success', '50', '8699591290', '030006185813', 'UTTAR PRADESH', '2023-09-24 09:42:21'),
(115, 'AHK31339976', '8360428077', NULL, '030006185813', 'DAVINDERJIT KAUR', NULL, NULL, '01/01/1960', NULL, 'https://mbajallive.xyz/admin/uploads/905368030006185813.pdf', 'success', '50', '8360428077', '030006185813', 'PUNJAB', '2023-10-21 08:00:55'),
(116, 'AHK989580', '8360428077', NULL, '030003170932', 'harjeet singh', NULL, NULL, '01/01/1991', NULL, 'https://mbajallive.xyz/admin/uploads/231686030003170932.pdf', 'success', '50', '8360428077', '030003170932', 'PUNJAB', '2023-12-14 04:53:33'),
(117, 'AHK96672222', '8360428077', NULL, '030003028351', 'gurnoor kaur', NULL, NULL, '01/01/2010', NULL, 'https://mbajallive.xyz/admin/uploads/301798030003028351.pdf', 'success', '50', '8360428077', '030003028351', 'PUNJAB', '2023-12-14 04:55:55'),
(118, 'AHK34971900', '9653056786', NULL, '030006764353', 'RANJIT KUMAR', NULL, NULL, '25/02/1990', NULL, 'https://mbajallive.xyz/admin/uploads/362858030006764353.pdf', 'success', '30', '9653056786', '030006764353', 'PUNJAB', '2024-02-15 12:51:45'),
(119, 'AHK13331858', '7307166002', NULL, '03000524529', 'Kartik Kumar', NULL, NULL, '01/01/2009', NULL, 'https://mbajallive.xyz/admin/uploads/549766on recod.PNG', 'success', '30', '8728027953', ' Invalid', 'PUNJAB', '2024-03-01 13:31:29'),
(120, 'AHK48495587', '9653056786', NULL, '030006786565', 'Angrej singh', NULL, NULL, '03/01/1988', NULL, 'https://mbajallive.xyz/admin/uploads/426894somefile.pdf', 'success', '30', '9653056786', '030006764353', 'PUNJAB', '2024-03-21 15:55:00'),
(121, 'AHK22807309', '8905993904', NULL, '272029801546', 'hausabai vyankat partale', NULL, NULL, '01/01/1977', NULL, NULL, 'pending', '30', '8905993904', NULL, 'MADHYA PRADESH', '2024-05-31 19:56:17');

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

--
-- Table structure for table `rasn_print`
--

CREATE TABLE `rasn_print` (
  `id` int(50) NOT NULL,
  `application_no` varchar(300) NOT NULL,
  `username` varchar(300) NOT NULL,
  `rasan_no` varchar(300) NOT NULL,
  `state` varchar(300) NOT NULL,
  `response` longtext NOT NULL,
  `status` varchar(300) NOT NULL,
  `message` varchar(300) DEFAULT NULL,
  `fee` int(50) NOT NULL,
  `front` longtext NOT NULL,
  `back` longtext NOT NULL,
  `pdf` longtext NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rasn_print`
--

INSERT INTO `rasn_print` (`id`, `application_no`, `username`, `rasan_no`, `state`, `response`, `status`, `message`, `fee`, `front`, `back`, `pdf`, `date`) VALUES
(1, 'HKB_375668', '8699591290', '030001383012', 'other', '{\"status\":\"Success\",\"message\":\"PDF Generate Successful\",\"name\":\"PRIYA SHARD\",\"front\":\"[BLOB]\",\"back\":\"[BLOB]\",\"a4\":\"[BLOB]\",\"sample\":false}', 'success', NULL, 20, '[BLOB]', '[BLOB]', '[BLOB]', '2024-04-05 18:48:35');
INSERT INTO `rasn_print` (`id`, `application_no`, `username`, `rasan_no`, `state`, `response`, `status`, `message`, `fee`, `front`, `back`, `pdf`, `date`) VALUES
(2, 'HKB_900572', '8360428077', '030003143497', 'other', '{\"status\":\"Success\",\"message\":\"PDF Generate Successful\",\"name\":\"MOHINDER PAL SINGH\",\"front\":\"[BLOB]\",\"back\":\"[BLOB]\",\"a4\":\"[BLOB]