[encoded data, 177497 characters]', 'FIND-ADMIN', '$2y$10$hOt8/hqSdFcZCjRa064D5OidLxAuReLQn8cSlSjmefrY4OGXxJQwG', '42ab3ca511b73583e4f2ada3783777e3', 'MAIN ADMIN', 'SAHARA COMMUNICATION', '9511983178', 'SAHARACOMMUNICATION49@GMAIL.COM', 'ADMIN_UTI', 'ADMIN_UTI', 'BIHAR', '11', '852131', 'mainadmin', 'PRITA ENTERPRISES', '99998994.5', '95.50', '20', '10', 'YES', '107', '59', '107', '80', '1.8', '3.80', '3.80', '3.0', '5.00', '5.00', '2.90', '4.00', '3.50', '3.00', '2.90', '0', '', '', '', '18-Apr-2020 07:11:39 PM', 'approved');
INSERT INTO `loginusers` (`id`, `web_url`, `pic`, `username`, `password`, `login_key`, `owner_name`, `shop_name`, `mobile_no`, `email_id`, `pan_no`, `uid_no`, `address`, `state`, `pin_code`, `usertype`, `createby`, `balance`, `p_coupon`, `find_charge`, `pan_pdf`, `nsdl_active`, `ekyc_nsdl`, `e_coupon`, `p_nsdl`, `e_nsdl`, `airtel`, `idea`, `vodafone`, `jio`, `bsnl_topup`, `bsnl_special`, `airtel_dth`, `dish_dth`, `tatasky_dth`, `videocon_dth`, `sun_dth`, `bbps`, `rt`, `ad`, `api_key`, `date_time`, `status`) VALUES
(707, 'find.getapi.co.in', '', '1111111111', '$2y$10$/MFC2eZnsWe4E5UObAZQlutAQXuOcR2XQMDVXkI5E5asJ.K2RIkBq', 'd4fcd3a9212e141d57b1acc024f7ca98', 'DEMO', 'DEMO', '1111111111', 'DEMO@GMAIL.COM', 'DEMO244324', '111111111111', 'DEMO', '35', '121212', 'distributor', '1221222222', '202', '100', '1', '10', 'YES', '107', '100', '107', '107', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '', '', '', '28-Aug-2023 03:28:06 PM', 'approved'),
(713, '', '', '7059592222', '$2y$10$29Hqh5gOxdeenx8EzPa79uENP/EGzPAviV8THeRUNC.GUy5oKM2KS', '3a427b3632bed923daa2be11456b9289', 'MAYUR', 'SAHARA', '7059592222', 'SPDIGIPAY@GMAIL.COM', 'JHGFH7686H', '276523871528', 'KEDGAON', '19', '123456', 'retailer', 'FIND-ADMIN', '36', '', '30', '11', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-10-13', 'approved'),
(714, '', '', '8983884008', '$2y$10$SquTqhzwwNFuUfIhb1pdROYg7.CqolIbRaPOKDLlQVQMH.qUxFSQm', 'fee029371e1df107f359e525882cd91f', 'KARAN DEOKAR', 'KARAN DEOKAR', '8983884008', 'KARANDEOKARPATIL012@GMAIL.COM', 'BKAFG2828N', '827359836597', 'KEDGAON', '19', '412203', 'distributor', 'FIND-ADMIN', '103', '', '30', '11', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-10-23', 'approved'),
(715, '', '', '9552530593', '$2y$10$6CZTUKR.DcYt03ayzXYCauMix9reGTZ8pgzefadjodoDmOm9s33su', 'ecfb6cc55c2901c9a7647a29e32e7fba', 'HUSEN MUBARAK TAMBOLI', 'ALIE ENTERPRISE ', '9552530593', 'DIGITALINDIA413103@GMAIL.COM', 'AKFPT6719C', '246871180308', 'INDAPUR', '19', '413183', 'retailer', '8983884008', '28', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved'),
(716, '', '', '7030570446', '$2y$10$aoiKYMxjUnsuHdDWnvMSt.IAe2JKeSrmWU6ilg0H80RjuFpJxzs5C', 'c8763c26b4404f41838a48d7f130b631', 'SHUBHAM KATE', 'E SEWA KENDRA ', '7030570446', 'SHUBHAMKATE171@GMAIL.COM', 'ETLPK5191L', '979882411918', 'TULJAPUR', '19', '413608', 'retailer', '8983884008', '23', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved'),
(717, '', '', '8605314931', '$2y$10$2nmFN6UbhAdFHXVbGPpoxO9DXHwz4e3XlUJ39EHc.T4dB8Oyy5F3e', 'd3d826b34ad28a09edf85dd0dcb81e30', 'ANIL BABER', 'E SEWA KENDRA ', '8605314931', 'ANILBABAR20@GMAIL.COM', 'BBNPB5210L', '549667961735', 'AHMEDNAGAR ', '19', '414401', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved');
INSERT INTO `loginusers` (`id`, `web_url`, `pic`, `username`, `password`, `login_key`, `owner_name`, `shop_name`, `mobile_no`, `email_id`, `pan_no`, `uid_no`, `address`, `state`, `pin_code`, `usertype`, `createby`, `balance`, `p_coupon`, `find_charge`, `pan_pdf`, `nsdl_active`, `ekyc_nsdl`, `e_coupon`, `p_nsdl`, `e_nsdl`, `airtel`, `idea`, `vodafone`, `jio`, `bsnl_topup`, `bsnl_special`, `airtel_dth`, `dish_dth`, `tatasky_dth`, `videocon_dth`, `sun_dth`, `bbps`, `rt`, `ad`, `api_key`, `date_time`, `status`) VALUES
(718, '', 'data:image/jpg;base64,[encoded data, 53636 characters]', '8010606248', '$2y$10$rit1/xdGbqkHO3iZJSXk1eGiMv7bD8gMSr6IGYct9w9XEes0VYiOm', '8a824c2e00e995daeee5e8994904dcef', 'TUSHAR DALVI ', 'SP ENTERPRISE ', '8010606248', 'TUSHARDALVI23@GMAIL.COM', 'CSLPD9551Q', '920089513485', 'RAIGARH ', '19', '402303', 'retailer', '8983884008', '100', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved');
INSERT INTO `loginusers` (`id`, `web_url`, `pic`, `username`, `password`, `login_key`, `owner_name`, `shop_name`, `mobile_no`, `email_id`, `pan_no`, `uid_no`, `address`, `state`, `pin_code`, `usertype`, `createby`, `balance`, `p_coupon`, `find_charge`, `pan_pdf`, `nsdl_active`, `ekyc_nsdl`, `e_coupon`, `p_nsdl`, `e_nsdl`, `airtel`, `idea`, `vodafone`, `jio`, `bsnl_topup`, `bsnl_special`, `airtel_dth`, `dish_dth`, `tatasky_dth`, `videocon_dth`, `sun_dth`, `bbps`, `rt`, `ad`, `api_key`, `date_time`, `status`) VALUES
(719, '', '', '8080156000', '$2y$10$26NDmalNnPDHVQf4nP25aulWPeKSb2uHyCaucgXKymRuXSe2uSGgi', '', 'KAMLAKAR SHIVGAN', 'SIGMA INFOTECH ', '8080156000', 'SIGMAINFOTECHKAMLAKAR@GMAIL.COM', 'AZBPS4086J', '512025511567', 'MUMBAI ', '19', '400030', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved'),
(720, '', 'data:image/jpg;base64,[encoded data, 39788 characters]', '9096095560', '$2y$10$iOaGj3UnAiWHisshqH76yu7lbsB6R0lPzoHdN.MbLuffkWsLaN9Mi', '8d3214fd913ec81f1ee7c0fe9fdacba0', 'YOGESH SATPUTE ', 'SHREE GANESH MULTISERVICES ', '9096095560', 'YNSATPUTE28@GMAIL.COM', 'DHTPS3563M', '247398198758', 'LATUR ', '19', '413527', 'retailer', '8983884008', '21', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved'),
(721, '', '', '7972621081', '$2y$10$/iRFZ8rYCG8WFgKalG6fNOg9q9A.R0DPrmMYssxlpUbLEiDI/.mdO', '83ab86ca0b6ffdda5c96eb5c1d02c095', 'VAISHALI VIJAPURR ', 'KETKI MULTISERVICES ', '7972621081', 'DRVPAN94@GMAIL.COM', 'BSBPV9963M', '767402214846', 'LATUR ', '19', '413537', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved'),
(722, '', '', '959573501o', '$2y$10$bOwi8IyJhelru4bTi/n1lOqdyTnFra827U6iwMnT2.5R3927dh9/W', '', 'SUNIL PAHNDHRE', 'MAHA E SEWA KENDRA ', '959573501o', 'PRESSSUNILPANDHARE@GMAIL.COM', 'BLHPP8254N', '446675868366', 'SILLOD ', '19', '413536', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved'),
(723, '', '', '8097278953', '$2y$10$u1sTRktuCaceBpABAsIoFOpUk3oYuIP8GupvjWQJBeIRSZIaGRS4y', '6e630e624a589c33a64e4d1c3600aacb', 'RINESH KAMBALE ', 'E SEWA KENDRA ', '8097278953', 'KAMBLERINESH@GMAIL.COM', 'MPCPK6352N', '398660913675', 'PUNE', '19', '411015', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved'),
(724, '', '', '9822818488', '$2y$10$mlKI6XHXcvSC3PnC4DDdr.Vw1ycjfvMMxvN7g9suVthP74UDfZRgq', 'e563dcdcaa75ebafe5112c79b76094da', 'GANESH KULKARNI ', 'KULKARNI MULTISERVICES ', '9822818488', 'KULKARNIG37@GMAIL.COM', 'BDGPK2997A', '834467273706', 'AURANGABAD ', '19', '431115', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-04', 'approved');
INSERT INTO `loginusers` (`id`, `web_url`, `pic`, `username`, `password`, `login_key`, `owner_name`, `shop_name`, `mobile_no`, `email_id`, `pan_no`, `uid_no`, `address`, `state`, `pin_code`, `usertype`, `createby`, `balance`, `p_coupon`, `find_charge`, `pan_pdf`, `nsdl_active`, `ekyc_nsdl`, `e_coupon`, `p_nsdl`, `e_nsdl`, `airtel`, `idea`, `vodafone`, `jio`, `bsnl_topup`, `bsnl_special`, `airtel_dth`, `dish_dth`, `tatasky_dth`, `videocon_dth`, `sun_dth`, `bbps`, `rt`, `ad`, `api_key`, `date_time`, `status`) VALUES
(725, '', 'data:image/jpg;base64,[encoded data, 64512 characters]', '9860410013', '$2y$10$k9g2a2WTznU5hzycVrSbPesQXF0bo2sJZxfcYMHCdfbx4lFOi33kO', 'a47d065e282f50892e4b79703a383649', 'VISHAL KAMBALE ', 'SHREE MULTISERVICES ', '9860410013', 'VNK451993@GMAIL.COM', 'EDNPK5144K', '294008636212', 'LATUR ', '19', '413520', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-05', 'approved');
INSERT INTO `loginusers` (`id`, `web_url`, `pic`, `username`, `password`, `login_key`, `owner_name`, `shop_name`, `mobile_no`, `email_id`, `pan_no`, `uid_no`, `address`, `state`, `pin_code`, `usertype`, `createby`, `balance`, `p_coupon`, `find_charge`, `pan_pdf`, `nsdl_active`, `ekyc_nsdl`, `e_coupon`, `p_nsdl`, `e_nsdl`, `airtel`, `idea`, `vodafone`, `jio`, `bsnl_topup`, `bsnl_special`, `airtel_dth`, `dish_dth`, `tatasky_dth`, `videocon_dth`, `sun_dth`, `bbps`, `rt`, `ad`, `api_key`, `date_time`, `status`) VALUES
(726, '', '', '9422541955', '$2y$10$Ud/8PwVszN1v.NlE9eu0neolA56YGbJRbCTO5s0lG61VxCxGen/bq', 'fc2a7df7e8284e174c9292b527c2de15', 'MANOJ SHINDE', 'SHRI RAM DIGITAL ONLINE SARVICES SHENDI', '9422541955', 'SHRIRAM1842@GMAIL.COM', 'KPFPS3985Q', '844143698114', 'AHMADNAGAR ', '19', '414601', 'retailer', '8983884008', '100', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-05', 'approved'),
(727, '', '', '9922981132', '$2y$10$k8uQ/W1GK4qZSBYuSmgW2eqmQxWFPIb3IrAhFrHLDUP6YKJ8RKXLm', 'f215c6864ebdd3a87aa46e1c8fe8d684', 'SHAISHKANT GAIKWAD ', 'MATOSHRI MAHA E-SEVA KENDRA', '9922981132', 'SHASHIKANT2297@GMAIL.COM', 'CNEPG8214M', '774757694596', 'SOLAPUR ', '19', '413305', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(728, '', '', '8879434407', '$2y$10$guPFLJkOCZxP2ONLNA7Opeq/2OyN5iqvWO/OVDfix4SprUzoV/FhO', '7bf7ddd46b015cc3ecbe43c00611f077', 'MONOHAR MUGDALE ', 'SHIVKHRUPA ONLINE SERVICE ', '8879434407', 'SHIVKRUPAATNUR@GMAIL.COM', 'CEMPM9274A', '630101170648', 'LATUR ', '19', '413532', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(729, '', '', '8600190076', '$2y$10$a5hsNuH76SQeT0VfxQBsdeht/BxyK7WU.5mHWHhIB8qUFJpVIemQ2', '0d74ebd3701419ec5b40e08a920a0e95', 'KUMAR APPA KHARE', 'E SEWA KENDRA ', '8600190076', 'KUMARAPPA@GMAIL.COM', 'DGNPK1466C', '993983687985', 'SOLAPUR ', '19', '413304', 'retailer', '8983884008', '23', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(730, '', '', '9172855528', '$2y$10$0qOxk7mW0UrGob8IxNdLG.rJgMTuHulglqRxtRVTU.JKCPhLdwQTa', 'e3b196954c0e4d63ba7db3ed60ef7946', 'SUNIL JAMSANDEKAR', 'SMARATH DIGITAL ', '9172855528', 'SUNILJAMSANDEKAR@GMAIL.COM', 'AIAPJ4433A', '707426334165', 'THANE ', '19', '400506', 'retailer', '8983884008', '28', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(731, '', '', '9503136161', '$2y$10$qyjfblRPc/7bAMP2Olj89ue5HyioIPnvDrXtUoFnwZpdB4xT/gcvK', 'fa20b38955d1b756dc5d447d8621a259', 'DADASAHEB MADHUKAR MURTE', 'MAULI MULTISERVICES ', '9503136161', 'DADAMURTE@GMAIL.COM', 'BCUPM3746E', '244859423842', 'OSMANABAD ', '19', '413606', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(732, '', '', '8554971044', '$2y$10$uyX1RYd/yrcJspjHU1xpC.zVndLI4Le3dPJFnhbDPQsxfcMCuvFX2', '9f4841fb319bb5a00a8c22266a5aac39', 'PROMOD TONDARE ', 'SHREE MULTISERVICES ', '8554971044', 'SHREECSCTADLAPUR@GMAIL.COM', 'BTCPT4888F', '534748474653', 'LATUR ', '19', '413517', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(733, '', '', '8805114276', '$2y$10$5GMoEPfDEuD0.ugbz5ZcduYvu7HsxG9P0GSoQvh2EnewEjUvaDysu', '45fa1d5f8e19da5cecc23f0eddef2de1', 'BHARAT KHUTE ', 'RAJ ONLINE SERVICE ', '8805114276', 'BHARATKUTE2048@GMAIL.COM', 'GTWPK4872H', '685127588334', 'SOLAPUR ', '19', '413305', 'retailer', '8983884008', '100', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(734, '', '', '9881050497', '$2y$10$sRrsKrwaywocg..2U6N7pOBL2KcsWEIq3nG/dUse2P4oX4oy.nISy', 'd61796bd4077c9c102253c379878922c', 'SHOUKAT BHAI', 'TAJMAHAL SERVICE ', '9881050497', 'SHOUKAT268@GMAIL.COM', 'CPCPS9623C', '868430310443', 'OSMANABAD ', '19', '413528', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(735, '', '', '9067935975', '$2y$10$3Y18YSdtZDceGYYQjPiHyu2tWB44R6AQakMWpdczEEtcIkpK9UXkq', '7bfeeb30b27d6cb5f40c563a86f92573', 'RAKESH GAJANAN DAHALE', ' DAHALE INSURANCE SERVICES ', '9067935975', 'RDAHALE10@GMAIL.COM', 'BCGPD4598H', '546914895192', 'AHMADNAGAR ', '19', '413737', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-06', 'approved'),
(736, '', '', '9130336917', '$2y$10$FgqswoIX5BNYiSwDnhlAkuwt2rnznXOX8zjZwGyIIdTyZowPpz8IW', '274fa8d20f73ffaeedaadb1d0e7e665c', 'ASHISH DEVKAR ', 'MAITRI ONLINE AND XEROX CENTRE', '9130336917', 'ASHISHDEVKAR17@GMAIL.COM', 'EXNPD2141H', '925421319268', 'SOLAPUR ', '19', '413209', 'retailer', '8983884008', '0', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(737, '', '', '9767829042', '$2y$10$swS3cav35Bl7O2olYMmtSe0LhieJ2c5ovSo5HWzeLRFQB6qdwaIee', 'df870182ff70a31876b44d846f446fca', 'SACHIN CHAVAN ', 'PATIL XEROX ', '9767829042', 'PATILCOM2003@GMAIL.COM', 'AZKPC5996L', '371746931988', 'SOLAPUR ', '19', '413209', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(738, '', '', '7447565402', '$2y$10$n4iMQ6YcEEQrNh6bNxyPvepfAvjGC8HqmWWCF.b.YKtdnRmNXRNHO', '5e4d5b3f32bba8b5053a57111f3e3e56', 'RAVINDRA ', 'RD ONLINE SERVICE ', '7447565402', 'RD.SETU01@GMAIL.COM', 'GMDPD6343G', '770495288498', 'BEED', '19', '414204', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(739, '', '', '9112499676', '$2y$10$mpqWop5mWwyAfO0V31nE1.wJvSRhGE0QpH4ObdS8MdySWRsoh5AJu', '393053263ef6629346313f4644e80753', 'VIKARM KAMBALE ', 'SHIVTEJ COMPUTER ', '9112499676', 'VKAMBALE881@GMAIL.COM', 'JSDPK8710F', '329986942054', 'AHMAD NAGAR', '19', '413204', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(740, '', '', '8669008964', '$2y$10$wNjGOd2k/mR7/ZBlXO3lgOIKUksQuKroNaZEldec8zw9FXv8Rw7f2', '96e7ac30dcc41a287aae9c6754579998', 'GARUDEV MULTISERVICES ', 'GARUDEV MULTISERVICES ', '8669008964', 'SHAMDATIR@GMAIL.COM', 'BDIPD3982N', '362669074940', 'SANGMNER', '19', '413738', 'retailer', '8983884008', '1', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(741, '', '', '7057579582', '$2y$10$t0x8py4e5MmzxkQCBI/VkuRNgqKV1ffo.LVVP9dL0HwqkJ9BXRfyK', '5919707d41f9b6e4c7ad9b6a3e5c86e0', 'SURVE SOMNATH ', 'GANESH ENTERPRISES ', '7057579582', 'SURVESOMNATH4@GMAIL.COM', 'IKUPS3854Q', '637819035030', 'MADHA ', '19', '413301', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(742, '', '', '8600976910', '$2y$10$lpFFIfDGWA1jVKkx0B.aH.S56SZhiUADXJLYu5tKSaBVMd3XXHJpu', '3b3c210df33eca412ec9fbb54c87aed0', 'SAMARTH ONLINE SERVICES', 'SHRI SAI SAMARTH BANKING CSP POINT ', '8600976910', 'SAMARTHONLINESERVICES9@GMAIL.COM', 'AESPW2086C', '564429284531', 'MANGALVEDA ', '19', '413322', 'retailer', '8983884008', '28', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(743, '', '', '9803895444', '$2y$10$PonLFWRdY5F7Et3UcyQeIeEQUxxZJuDZMINp7aCUi29hBdqv6ZM7a', '', 'SHAM CHAVAN ', 'KEDSHAVAR COMPUTER ', '9803895444', 'SHYAMCHAVAN222@GMAIL.COM', 'APAPC4323B', '798734804803', 'JAMKHED ', '19', '413204', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(744, '', '', '8380902002', '$2y$10$at7bFsJuXlhpmRwhVNxkDuTEzRwheGPd9YXgnO5X68pb1MunyOgn.', 'e7e0eb3efbd87d7e3813798ee085a463', 'GANESH ', 'GANESH SETU ONLINE ', '8380902002', 'GANESHJORVEKAR125@GMAIL.COM', 'ANKPJ1563E', '853154483890', 'AHMAD NAGAR', '19', '413637', 'retailer', '8983884008', '', '', '35', '20', 'YES', '107', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-07', 'approved'),
(745, '', '', '8647079257', '$2y$10$N4gUWo3TmD7FDKcwPYCwg.aSH3NqTnilt2gGAY8OJV.eD9wkMDz16', '', 'JAMIL EBERT', 'JAMIL EBERT', '8647079257', 'ALBERTA_KESSLER9@MONEYSQUAD.ORG', 'INVOICE', '36852773', '402 KENDRA INLET', '36', '826312', 'retailer', 'FIND-ADMIN', '', '107', '', '', 'YES', '107', '80', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023-11-17', 'paywait');

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

--
-- Table structure for table `nsdlpancard`
--

CREATE TABLE `nsdlpancard` (
  `id` int(11) NOT NULL,
  `web_url` varchar(255) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `cat_applicant` varchar(255) NOT NULL,
  `pan_number` varchar(255) NOT NULL,
  `l_name` varchar(255) NOT NULL,
  `f_name` varchar(255) NOT NULL,
  `m_name` varchar(255) NOT NULL,
  `name_card` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `fal_name` varchar(255) NOT NULL,
  `faf_name` varchar(255) NOT NULL,
  `fam_name` varchar(255) NOT NULL,
  `aadhaar_num` varchar(255) NOT NULL,
  `name_aadhaar` varchar(255) NOT NULL,
  `mob_num` varchar(255) NOT NULL,
  `email_id` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `address3` varchar(255) NOT NULL,
  `address4` varchar(255) NOT NULL,
  `address5` varchar(255) NOT NULL,
  `user_state` varchar(255) NOT NULL,
  `pincode` varchar(255) NOT NULL,
  `pan_type` varchar(255) NOT NULL,
  `r_title` varchar(255) DEFAULT NULL,
  `rl_name` varchar(255) DEFAULT NULL,
  `rf_name` varchar(255) DEFAULT NULL,
  `rm_name` varchar(255) DEFAULT NULL,
  `r_address1` varchar(255) DEFAULT NULL,
  `r_address2` varchar(255) DEFAULT NULL,
  `r_address3` varchar(255) DEFAULT NULL,
  `r_address4` varchar(255) DEFAULT NULL,
  `r_address5` varchar(255) DEFAULT NULL,
  `r_state` varchar(255) DEFAULT NULL,
  `r_pincode` varchar(255) DEFAULT NULL,
  `city` varchar(255) NOT NULL,
  `area_code` varchar(255) NOT NULL,
  `ao_type` varchar(255) NOT NULL,
  `rangecode` varchar(255) NOT NULL,
  `aocode` varchar(255) NOT NULL,
  `proof_id` varchar(255) NOT NULL,
  `proof_add` varchar(255) NOT NULL,
  `proof_dob` varchar(255) NOT NULL,
  `form_pdf` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `sign` varchar(255) NOT NULL,
  `epan_flag` varchar(255) NOT NULL,
  `changes` longtext NOT NULL,
  `amount` varchar(255) NOT NULL,
  `balance` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `date_time` date NOT NULL,
  `ack_no` varchar(255) NOT NULL,
  `ack_pdf` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `hard_copy` int(11) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `nsdlpanfind`
--

CREATE TABLE `nsdlpanfind` (
  `id` int(11) NOT NULL,
  `web_url` varchar(255) DEFAULT NULL,
  `order_id` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `pan_number` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `aadhaar_num` varchar(255) NOT NULL,
  `name_aadhaar` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `pan_type` varchar(255) NOT NULL,
  `form_pdf` varchar(255) NOT NULL,
  `changes` longtext NOT NULL,
  `amount` varchar(255) NOT NULL,
  `balance` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `date_time` date NOT NULL,
  `remark` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `nsdlpanfind`
--

INSERT INTO `nsdlpanfind` (`id`, `web_url`, `order_id`, `type`, `pan_number`, `dob`, `aadhaar_num`, `name_aadhaar`, `name`, `pan_type`, `form_pdf`, `changes`, `amount`, `balance`, `user_id`, `date_time`, `remark`, `status`) VALUES
(1, 'cscvleprintkaro.in', 'ESK4879662', 'PANFIND', 'KGOPK3822G', '04/09/2002', '411048365709', '', 'MANISHA KUMARI', 'findpan', '', '', '22', '28', '712', '2023-09-13', 'PAN NO GENERATED', 'success'),
(2, 'cscvleprintkaro.in', 'ESK64027165', 'PANFIND', 'HLNPS0364G', '12/04/1996', '953898606122', '', 'PRABHADEVI DUBEY', 'findpan', '', '', '22', '99999234.5', '1', '2023-09-14', 'PAN NO GENERATED', 'success'),
(3, 'cscvleprintkaro.in', 'ESK82939791', 'PANFIND', 'HKBPK2304H', '01/01/2000', '249590434936', '', 'VISHNU KUMAR', 'findpan', '', '', '22', '258', '712', '2023-09-14', 'PAN NO GENERATED', 'success'),
(4, 'saharacommunication.online', 'ESK77410750', 'PANFIND', 'BKCPC8085N', '15/10/1997', '464658430412', '', 'MAYUR ATUL CHAVAN', 'findpan', '', '', '25', '28', '713', '2023-10-13', 'PAN NO GENERATED', 'success'),
(5, 'saharacommunication.online', 'ESK97549571', 'PANFIND', 'ECBPG6838P', '01/06/1995', '368626595827', '', 'MADHAVI ATMARAM GAVANDE', 'findpan', '', '', '22', '26', '713', '2023-10-17', 'PAN NO GENERATED', 'success'),
(6, 'saharacommunication.online', 'ESK78300293', 'PANFIND', 'BHZPC1444F', '15/07/1996', '908210355315', '', 'SANDIP SOPAN CHAVAN', 'findpan', '', '', '22', '54', '713', '2023-10-18', 'PAN NO GENERATED', 'success'),
(7, 'saharacommunication.online', 'ESK68615548', 'PANFIND', 'BHZPC1444F', '15/07/1996', '908210355315', '', 'SANDIP SOPAN CHAVAN', 'findpan', '', '', '22', '32', '713', '2023-10-18', 'PAN NO GENERATED', 'success'),
(8, 'saharacommunication.online', 'ESK74435574', 'PANFIND', 'IAFPS1531B', '26/01/1996', '623514250969', '', 'PRIYANKA DIGAMBAR SABALE', 'findpan', '', '', '22', '20', '713', '2023-10-21', 'PAN NO GENERATED', 'success'),
(9, 'saharacommunication.online', 'ESK83816641', 'PANFIND', 'EDXPG2809F', '01/01/1953', '308904462512', '', 'TARABAI BHOU GAYKAR', 'findpan', '', '', '22', '48', '713', '2023-10-23', 'PAN NO GENERATED', 'success'),
(10, 'saharacommunication.online', 'ESK76055704', 'PANFIND', 'FMGPB6791E', '17/08/1999', '429174289124', '', 'AJAY JALINDAR BHAVLE', 'findpan', '', '', '22', '13', '714', '2023-11-04', 'PAN NO GENERATED', 'success'),
(11, 'saharacommunication.online', 'ESK26218515', 'PANFIND', 'HZIPK5644E', '19//10/199', '828952727576', '', 'SAGAR POPAT KADAM', 'findpan', '', '', '22', '28', '715', '2023-11-04', 'PAN NO GENERATED', 'success'),
(12, 'saharacommunication.online', 'ESK70648638', 'PANFIND', 'BZRPB6942H', '25/10/1996', '506323068465', '', 'TEJES BALU BANSODE ', 'findpan', '', '', '22', '23', '716', '2023-11-04', 'PAN NO GENERATED', 'success'),
(13, 'saharacommunication.online', 'ESK6959723', 'PANFIND', 'LKWPK7378C', '10/12/2004', '496479810757', '', 'PALLAVI SANJAY KALE', 'findpan', '', '', '22', '28', '720', '2023-11-04', 'PAN NO GENERATED', 'success'),
(14, 'saharacommunication.online', 'ESK10567917', 'PANFIND', 'JCQPS4427A', '10/04/1996', '523453150146', '', 'ASHWIN VIJAY SAWANT ', 'findpan', '', '', '22', '36', '713', '2023-11-05', 'PAN NO GENERATED', 'success'),
(15, 'saharacommunication.online', 'ESK78298569', 'PANFIND', 'CUMPG9009H', '01/01/1974', '360726596308', '', 'MACCHINDRA AGNU GHADAGE ', 'findpan', '', '', '22', '23', '729', '2023-11-07', 'PAN NO GENERATED', 'success'),
(16, 'saharacommunication.online', 'ESK31871137', 'PANFIND', 'HXJPP5078L', '01/01/1980', '887349187960', '', 'MAHADEV BABURAO PUTTE', 'findpan', '', '', '22', '56', '720', '2023-11-07', 'PAN NO GENERATED', 'success'),
(17, 'saharacommunication.online', 'ESK85960785', 'PANFIND', 'RXOPS8830N', '27/03/1980', '796195597514', '', 'AMIT KISAN SURVE', 'findpan', '', '', '22', '28', '730', '2023-11-07', 'PAN NO GENERATED', 'success'),
(18, 'saharacommunication.online', 'ESK62034050', 'PANFIND', 'GHZPM2395J', '10/08/2002', '939309694382', '', 'AUDUMBAR ATAMARAM METAKARI', 'findpan', '', '', '22', '28', '742', '2023-11-07', 'PAN NO GENERATED', 'success'),
(19, 'saharacommunication.online', 'ESK5430091', 'PANFIND', 'AJTPU4911C', '01/01/1978', '235932195237', '', 'MANACHAK NARHARI UBALE', 'findpan', '', '', '30', '88', '714', '2023-11-08', 'PAN NO GENERATED', 'success'),
(20, 'saharacommunication.online', 'ESK114051', 'PANFIND', 'FSBPM5268N', '08/03/1992', '264936791971', '', 'SAGAR RAJENDRA MORE', 'findpan', '', '', '35', '15', '736', '2023-11-08', 'PAN NO GENERATED', 'success'),
(21, 'saharacommunication.online', 'ESK29387718', 'PANFIND', 'EXNPD2141H', '06/12/1999', '925421319268', '', 'ASHISH DHANAJI DEVKAR', 'findpan', '', '', '35', '0', '736', '2023-11-08', 'PAN NO GENERATED', 'success'),
(22, 'saharacommunication.online', 'ESK76963654', 'PANFIND', '', '01/01/1971', '782135776734', '', 'SHESHIKALA KISHANRAO CHAVHAN', 'findpan', '', '', '35', '21', '720', '2023-11-23', 'PAN NO GENERATED', 'success');

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

--
-- Table structure for table `paymentreq`
--

CREATE TABLE `paymentreq` (
  `id` int(11) NOT NULL,
  `web_url` varchar(255) NOT NULL,
  `date_time` varchar(255) NOT NULL,
  `datetime` varchar(100) NOT NULL,
  `user` varchar(100) NOT NULL,
  `bank` varchar(255) NOT NULL,
  `mode` varchar(100) NOT NULL,
  `type` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `balance` varchar(255) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `orderid` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `paymentreq`
--

INSERT INTO `paymentreq` (`id`, `web_url`, `date_time`, `datetime`, `user`, `bank`, `mode`, `type`, `amount`, `balance`, `reference`, `orderid`, `remark`, `status`) VALUES
(1, '', '2020-10-19', '', 'UTIMITRA', 'U7004309634', 'USERID', 'debit', '', '-100', 'TXN194704', '', 'U7004309634, Purchase: retailer, Id', 'success'),
(2, '', '2020-10-20', '', 'UTIMITRA', 'AE9973348362', 'PORTAL', 'debit', '100', '-200', 'TXN328154', '', 'Transfer to AE9973348362 - SANJEEV GUPTA', 'success'),
(3, '', '2020-10-20', '', 'AE9973348362', 'UTIMITRA', 'PORTAL', 'credit', '100', '100', 'TXN328154', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(4, '', '2020-10-20', '', 'AE9973348362', 'AE9973348362', 'COUPON', 'debit', '95', '5', 'TXN518167', '', 'p-coupon Purchase: AE9973348362 - SANJEEV GUPTA', 'success'),
(5, '', '2020-10-20', '', 'UTIMITRA', 'AE9973348362', 'COMMISSION', 'credit', '1.6', '-198.4', 'TXN557135', '', 'Rs.1.6<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(6, '', '2020-10-26', '', 'UTIMITRA', 'AE9006208184', 'USERID', 'debit', '', '-198.4', 'TXN750433', '', 'AE9006208184, Purchase: retailer, Id', 'success'),
(7, '', '2020-10-26', '', 'AE9006208184', 'PPBLC UPI', 'ONLINE', 'credit', '500.00', '500', '394186_625', '', 'Received from Payment Gateway -UPI', 'success'),
(8, '', '2020-10-26', '', 'AE9006208184', 'AE9006208184', 'COUPON', 'debit', '500', '0', 'TXN364431', '', 'p-coupon Purchase: AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(9, '', '2020-10-26', '', 'AE9006208184', 'AE9006208184', 'REFUNDED', 'credit', '500', '500', 'TXN164527', '', 'Coupon Rejected, Refund Amount Rs.500', 'success'),
(10, '', '2020-10-26', '', 'AE9006208184', 'AE9006208184', 'COUPON', 'debit', '500', '0', 'TXN430861', '', 'p-coupon Purchase: AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(11, '', '2020-10-26', '', 'UTIMITRA', 'AE9006208184', 'COMMISSION', 'credit', '33', '-165.4', 'TXN991075', '', 'Rs.6.6<br>Qty: 5 p-Coupon Commission Credit', 'success'),
(12, '', '2020-10-26', '', 'UTIMITRA', 'U6268555227', 'USERID', 'debit', '', '-165.4', 'TXN565846', '', 'U6268555227, Purchase: retailer, Id', 'success'),
(13, '', '2020-10-26', '', 'UTIMITRA', 'AE6268555227', 'PORTAL', 'debit', '500', '-665.4', 'TXN213485', '', 'Transfer to AE6268555227 - ANAND KUMAR ', 'success'),
(14, '', '2020-10-26', '', 'AE6268555227', 'UTIMITRA', 'PORTAL', 'credit', '500', '500', 'TXN213485', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(15, '', '2020-10-26', '', 'AE6268555227', 'AE6268555227', 'COUPON', 'debit', '500', '0', 'TXN689182', '', 'p-coupon Purchase: AE6268555227 - ANAND KUMAR ', 'success'),
(16, '', '2020-10-26', '', 'UTIMITRA', 'AE6268555227', 'COMMISSION', 'credit', '33', '-632.4', 'TXN424080', '', 'Rs.6.6<br>Qty: 5 p-Coupon Commission Credit', 'success'),
(17, '', '2020-10-26', '', 'UTIMITRA', 'AE9572986150', 'USERID', 'debit', '', '-632.4', 'TXN470227', '', 'AE9572986150, Purchase: distributor, Id', 'success'),
(18, '', '2020-10-26', '', 'UTIMITRA', 'AE9572986150', 'PORTAL', 'debit', '1003', '-1635.4', 'TXN356713', '', 'Transfer to AE9572986150 - SUBHASH KUMAR', 'success'),
(19, '', '2020-10-26', '', 'AE9572986150', 'UTIMITRA', 'PORTAL', 'credit', '1003', '1003', 'TXN356713', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(20, '', '2020-10-26', '', 'UTIMITRA', 'AE9572986150', 'PORTAL', 'debit', '10', '-1645.4', 'TXN960032', '', 'Transfer to AE9572986150 - SUBHASH KUMAR', 'success'),
(21, '', '2020-10-26', '', 'AE9572986150', 'UTIMITRA', 'PORTAL', 'credit', '10', '1013', 'TXN960032', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(22, '', '2020-10-28', '', 'UTIMITRA', 'U9708487702', 'USERID', 'debit', '', '-1645.4', 'TXN308151', '', 'U9708487702, Purchase: retailer, Id', 'success'),
(23, '', '2020-10-28', '', 'UTIMITRA', 'AE9708487702', 'PORTAL', 'debit', '525', '-2170.4', 'TXN960704', '', 'Transfer to AE9708487702 - SUNIL KUMAR YADAV ', 'success'),
(24, '', '2020-10-28', '', 'AE9708487702', 'UTIMITRA', 'PORTAL', 'credit', '525', '525', 'TXN960704', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(25, '', '2020-10-28', '', 'AE9708487702', 'AE9708487702', 'COUPON', 'debit', '525', '0', 'TXN369469', '', 'p-coupon Purchase: AE9708487702 - SUNIL KUMAR YADAV ', 'success'),
(26, '', '2020-10-28', '', 'AE9708487702', 'AE9708487702', 'REFUNDED', 'credit', '525', '525', 'TXN165221', '', 'Coupon Rejected, Refund Amount Rs.525', 'success'),
(27, '', '2020-10-28', '', 'AE9708487702', 'AE9708487702', 'COUPON', 'debit', '525', '0', 'TXN443364', '', 'p-coupon Purchase: AE9708487702 - SUNIL KUMAR YADAV ', 'success'),
(28, '', '2020-10-28', '', 'UTIMITRA', 'AE9708487702', 'COMMISSION', 'credit', '58', '-2112.4', 'TXN799987', '', 'Rs.11.6<br>Qty: 5 p-Coupon Commission Credit', 'success'),
(29, '', '2020-10-29', '', 'UTIMITRA', 'U8271175524', 'USERID', 'debit', '', '-2112.4', 'TXN785389', '', 'U8271175524, Purchase: retailer, Id', 'success'),
(30, '', '2020-10-29', '', 'UTIMITRA', 'AE8271175524', 'PORTAL', 'debit', '500', '-2612.4', 'TXN529470', '', 'Transfer to AE8271175524 - ABHISHEK KUMAR ', 'success'),
(31, '', '2020-10-29', '', 'AE8271175524', 'UTIMITRA', 'PORTAL', 'credit', '500', '500', 'TXN529470', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(32, '', '2020-10-29', '', 'AE8271175524', 'AE8271175524', 'COUPON', 'debit', '500', '0', 'TXN827196', '', 'p-coupon Purchase: AE8271175524 - ABHISHEK KUMAR ', 'success'),
(33, '', '2020-10-29', '', 'AE8271175524', 'AE8271175524', 'REFUNDED', 'credit', '500', '500', 'TXN237753', '', 'Coupon Rejected, Refund Amount Rs.500', 'success'),
(34, '', '2020-10-29', '', 'AE8271175524', 'AE8271175524', 'COUPON', 'debit', '500', '0', 'TXN194340', '', 'p-coupon Purchase: AE8271175524 - ABHISHEK KUMAR ', 'success'),
(35, '', '2020-10-29', '', 'UTIMITRA', 'AE8271175524', 'COMMISSION', 'credit', '33', '-2579.4', 'TXN867378', '', 'Rs.6.6<br>Qty: 5 p-Coupon Commission Credit', 'success'),
(36, '', '2020-10-31', '', 'UTIMITRA', 'GDS8340658935', 'PORTAL', 'debit', '99', '-2678.4', 'TXN306428', '', 'Transfer to GDS8340658935 - RITESH SHARMA', 'success'),
(37, '', '2020-10-31', '', 'GDS8340658935', 'UTIMITRA', 'PORTAL', 'credit', '99', '99', 'TXN306428', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(38, '', '2020-10-31', '', 'UTIMITRA', 'GDS8340658935', 'PORTAL', 'debit', '2000', '-4678.4', 'TXN215793', '', 'Transfer to GDS8340658935 - RITESH SHARMA', 'success'),
(39, '', '2020-10-31', '', 'GDS8340658935', 'UTIMITRA', 'PORTAL', 'credit', '2000', '2099', 'TXN215793', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(40, '', '2020-10-31', '', 'GDS8340658935', 'GDS8340658935', 'COUPON', 'debit', '2058', '41', 'TXN721848', '', 'p-coupon Purchase: GDS8340658935 - RITESH SHARMA', 'success'),
(41, '', '2020-10-31', '', 'UTIMITRA', 'GDS8340658935', 'COMMISSION', 'credit', '96.6', '-4581.8', 'TXN198306', '', 'Rs.4.6<br>Qty: 21 p-Coupon Commission Credit', 'success'),
(42, '', '2020-11-01', '', 'UTIMITRA', 'AE9006208184', 'PORTAL', 'debit', '1800', '-6381.8', 'TXN579007', '', 'Transfer to AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(43, '', '2020-11-01', '', 'AE9006208184', 'UTIMITRA', 'PORTAL', 'credit', '1800', '1800', 'TXN579007', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(44, '', '2020-11-01', '', 'UTIMITRA', 'AE9006208184', 'PORTAL', 'credit', '800', '-5581.8', 'TXN427276', '', 'Credit from AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(45, '', '2020-11-01', '', 'AE9006208184', 'UTIMITRA', 'PORTAL', 'debit', '800', '1000', 'TXN427276', '', 'Debit Through UTIMITRA - ADMIN_UTI', 'success'),
(46, '', '2020-11-05', '', 'UTIMITRA', 'AE9006208184', 'PORTAL', 'credit', '400', '-5181.8', 'TXN776568', '', 'Credit from AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(47, '', '2020-11-05', '', 'AE9006208184', 'UTIMITRA', 'PORTAL', 'debit', '400', '600', 'TXN776568', '', 'Debit Through UTIMITRA - ADMIN_UTI', 'success'),
(48, '', '2020-11-05', '', 'UTIMITRA', 'AE9572986150', 'PORTAL', 'credit', '700', '-4481.8', 'TXN212839', '', 'Credit from AE9572986150 - SUBHASH KUMAR', 'success'),
(49, '', '2020-11-05', '', 'AE9572986150', 'UTIMITRA', 'PORTAL', 'debit', '700', '313', 'TXN212839', '', 'Debit Through UTIMITRA - ADMIN_UTI', 'success'),
(50, '', '2020-11-05', '', 'GDS8789425122', 'PPBL UPI', 'ONLINE', 'credit', '200.00', '200', '457598_640', '', 'Received from Payment Gateway -UPI', 'success'),
(51, '', '2020-11-07', '', 'UTIMITRA', 'AE9006208184', 'PORTAL', 'credit', '600', '-3881.8', 'TXN891502', '', 'Credit from AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(52, '', '2020-11-07', '', 'AE9006208184', 'UTIMITRA', 'PORTAL', 'debit', '600', '0', 'TXN891502', '', 'Debit Through UTIMITRA - ADMIN_UTI', 'success'),
(53, '', '2020-11-09', '', 'GDS9931619378', 'PPBLC UPI', 'ONLINE', 'credit', '1000.00', '1000', '701368_637', '', 'Received from Payment Gateway -UPI', 'success'),
(54, '', '2020-11-09', '', 'AE8789906674', 'AE8789906674', 'COUPON', 'debit', '960', '40', 'TXN680867', '', 'p-coupon Purchase: AE8789906674 - RANJIT KUMAR SINGH', 'success'),
(55, '', '2020-11-09', '', 'UTIMITRA', 'AE8789906674', 'COMMISSION', 'credit', '26', '-3855.8', 'TXN123715', '', 'Rs.2.6<br>Qty: 10 p-Coupon Commission Credit', 'success'),
(56, '', '2020-11-11', '', 'AE9572986150', 'AE9572986150', 'COUPON', 'debit', '291', '22', 'TXN368041', '', 'p-coupon Purchase: AE9572986150 - SUBHASH KUMAR', 'success'),
(57, '', '2020-11-11', '', 'UTIMITRA', 'AE9572986150', 'PORTAL', 'debit', '2000', '-5855.8', 'TXN719922', '', 'Transfer to AE9572986150 - SUBHASH KUMAR', 'success'),
(58, '', '2020-11-11', '', 'AE9572986150', 'UTIMITRA', 'PORTAL', 'credit', '2000', '2022', 'TXN719922', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(59, '', '2020-11-11', '', 'AE9572986150', 'AE9572986150', 'COUPON', 'debit', '1940', '82', 'TXN787888', '', 'p-coupon Purchase: AE9572986150 - SUBHASH KUMAR', 'success'),
(60, '', '2020-11-11', '', 'UTIMITRA', 'AE9572986150', 'COMMISSION', 'credit', '72', '-5783.8', 'TXN366617', '', 'Rs.3.6<br>Qty: 20 p-Coupon Commission Credit', 'success'),
(61, '', '2020-11-11', '', 'UTIMITRA', 'AE9572986150', 'COMMISSION', 'credit', '10.8', '-5773', 'TXN712848', '', 'Rs.3.6<br>Qty: 3 p-Coupon Commission Credit', 'success'),
(62, '', '2020-11-11', '', 'AE9572986150', 'PPBL UPI', 'ONLINE', 'credit', '100.00', '182', '178140_628', '', 'Received from Payment Gateway -UPI', 'success'),
(63, '', '2020-11-16', '', 'AE8789906674', 'PPBLC UPI', 'ONLINE', 'credit', '500.00', '540', '892153_637', '', 'Received from Payment Gateway -UPI', 'success'),
(64, '', '2020-11-16', '', 'AE8789906674', 'AE8789906674', 'COUPON', 'debit', '480', '60', 'TXN505002', '', 'p-coupon Purchase: AE8789906674 - RANJIT KUMAR SINGH', 'success'),
(65, '', '2020-11-16', '', 'AE8789906674', 'AE8789906674', 'REFUNDED', 'credit', '480', '540', 'TXN218990', '', 'Coupon Rejected, Refund Amount Rs.480', 'success'),
(66, '', '2020-11-16', '', 'AE8789906674', 'AE8789906674', 'COUPON', 'debit', '480', '60', 'TXN528893', '', 'p-coupon Purchase: AE8789906674 - RANJIT KUMAR SINGH', 'success'),
(67, '', '2020-11-16', '', 'AE8789906674', 'PPBLC UPI', 'ONLINE', 'credit', '500.00', '560', '243077_637', '', 'Received from Payment Gateway -UPI', 'success'),
(68, '', '2020-11-16', '', 'UTIMITRA', 'AE8789906674', 'COMMISSION', 'credit', '13', '-5760', 'TXN363371', '', 'Rs.2.6<br>Qty: 5 p-Coupon Commission Credit', 'success'),
(69, '', '2020-11-16', '', 'AE8789906674', 'AE8789906674', 'COUPON', 'debit', '480', '80', 'TXN240861', '', 'p-coupon Purchase: AE8789906674 - RANJIT KUMAR SINGH', 'success'),
(70, '', '2020-11-16', '', 'AE8789906674', 'AE8789906674', 'REFUNDED', 'credit', '480', '560', 'TXN816497', '', 'Coupon Rejected, Refund Amount Rs.480', 'success'),
(71, '', '2020-11-16', '', 'AE8789906674', 'AE8789906674', 'COUPON', 'debit', '480', '80', 'TXN882718', '', 'p-coupon Purchase: AE8789906674 - RANJIT KUMAR SINGH', 'success'),
(72, '', '2020-11-16', '', 'UTIMITRA', 'AE8789906674', 'COMMISSION', 'credit', '13', '-5747', 'TXN250272', '', 'Rs.2.6<br>Qty: 5 p-Coupon Commission Credit', 'success'),
(73, '', '2020-11-16', '', 'AE9572986150', 'U9386196395', 'USERID', 'debit', '21', '161', 'TXN582585', '', 'U9386196395, Purchase: retailer, Id', 'success'),
(74, '', '2020-12-04', '', 'U8292213904', 'PPBLC UPI', 'ONLINE', 'credit', '100.00', '100', '750260_647', '', 'Received from Payment Gateway -UPI', 'success'),
(75, '', '2020-12-04', '', 'U8292213904', 'U8292213904', 'COUPON', 'debit', '95', '5', 'TXN499772', '', 'p-coupon Purchase: U8292213904 - ARUN BHARATI', 'success'),
(76, '', '2020-12-04', '', 'U8292213904', 'U8292213904', 'REFUNDED', 'credit', '95', '100', 'TXN855571', '', 'Coupon Rejected, Refund Amount Rs.95', 'success'),
(77, '', '2020-12-05', '', 'U9572928990', 'PPBLC UPI', 'ONLINE', 'credit', '1000.00', '1000', '405363_648', '', 'Received from Payment Gateway -UPI', 'success'),
(78, '', '2020-12-05', '', 'U9572928990', 'U9572928990', 'COUPON', 'debit', '980', '20', 'TXN493595', '', 'p-coupon Purchase: U9572928990 - DINESH SINGH', 'success'),
(79, '', '2020-12-05', '', 'UTIMITRA', 'U9572928990', 'COMMISSION', 'credit', '46', '-5701', 'TXN708611', '', 'Rs.4.6<br>Qty: 10 p-Coupon Commission Credit', 'success'),
(80, '', '2020-12-06', '', 'UTIMITRA', 'AE9006208184', 'PORTAL', 'debit', '300', '-6001', 'TXN445121', '', 'Transfer to AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(81, '', '2020-12-06', '', 'AE9006208184', 'UTIMITRA', 'PORTAL', 'credit', '300', '300', 'TXN445121', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(82, '', '2020-12-06', '', 'AE9006208184', 'AE9006208184', 'COUPON', 'debit', '300', '0', 'TXN268761', '', 'p-coupon Purchase: AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(83, '', '2020-12-07', '', 'UTIMITRA', 'GDS8340658935', 'PORTAL', 'debit', '2000', '-8001', 'TXN915267', '', 'Transfer to GDS8340658935 - RITESH SHARMA', 'success'),
(84, '', '2020-12-07', '', 'GDS8340658935', 'UTIMITRA', 'PORTAL', 'credit', '2000', '2041', 'TXN915267', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(85, '', '2020-12-07', '', 'GDS8340658935', 'GDS8340658935', 'COUPON', 'debit', '294', '1747', 'TXN200945', '', 'p-coupon Purchase: GDS8340658935 - RITESH SHARMA', 'success'),
(86, '', '2020-12-07', '', 'UTIMITRA', 'GDS8340658935', 'COMMISSION', 'credit', '13.8', '-7987.2', 'TXN392676', '', 'Rs.4.6<br>Qty: 3 p-Coupon Commission Credit', 'success'),
(87, '', '2020-12-07', '', 'AE9006208184', 'AE9006208184', 'REFUNDED', 'credit', '300', '300', 'TXN349310', '', 'Coupon Rejected, Refund Amount Rs.300', 'success'),
(88, '', '2020-12-08', '', 'GDS8340658935', 'GDS8340658935', 'COUPON', 'debit', '1666', '81', 'TXN245637', '', 'p-coupon Purchase: GDS8340658935 - RITESH SHARMA', 'success'),
(89, '', '2020-12-08', '', 'GDS8340658935', 'GDS8340658935', 'REFUNDED', 'credit', '1666', '1747', 'TXN666337', '', 'Coupon Rejected, Refund Amount Rs.1666', 'success'),
(90, '', '2020-12-08', '', 'GDS8340658935', 'GDS8340658935', 'COUPON', 'debit', '1666', '81', 'TXN483195', '', 'p-coupon Purchase: GDS8340658935 - RITESH SHARMA', 'success'),
(91, '', '2020-12-08', '', 'UTIMITRA', 'GDS8340658935', 'COMMISSION', 'credit', '78.2', '-7909', 'TXN789031', '', 'Rs.4.6<br>Qty: 17 p-Coupon Commission Credit', 'success'),
(92, '', '2020-12-24', '', 'UTIMITRA', 'U7739542845', 'USERID', 'debit', '', '-7909', 'TXN416548', '', 'U7739542845, Purchase: distributor, Id', 'success'),
(93, '', '2020-12-24', '', 'U7739542845', 'PPBL UPI', 'ONLINE', 'credit', '100.00', '100', '633008_649', '', 'Received from Payment Gateway -UPI', 'success'),
(94, '', '2020-12-24', '', 'U7739542845', 'U8292399190', 'USERID', 'debit', '21', '79', 'TXN887148', '', 'U8292399190, Purchase: retailer, Id', 'success'),
(95, '', '2020-12-24', '', 'UTIMITRA', 'U7739542845', 'PORTAL', 'debit', '100', '-8009', 'TXN285383', '', 'Transfer to U7739542845 - AVINASH KUMAR VERMA', 'success'),
(96, '', '2020-12-24', '', 'U7739542845', 'UTIMITRA', 'PORTAL', 'credit', '100', '179', 'TXN285383', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(97, '', '2020-12-24', '', 'U7739542845', 'U7739542845', 'COUPON', 'debit', '98', '81', 'TXN478769', '', 'p-coupon Purchase: U7739542845 - AVINASH KUMAR VERMA', 'success'),
(98, '', '2020-12-24', '', 'U7739542845', 'U7739542845', 'REFUNDED', 'credit', '98', '179', 'TXN697340', '', 'Coupon Rejected, Refund Amount Rs.98', 'success'),
(99, '', '2020-12-24', '', 'U7739542845', 'U7739542845', 'COUPON', 'debit', '98', '81', 'TXN989025', '', 'p-coupon Purchase: U7739542845 - AVINASH KUMAR VERMA', 'success'),
(100, '', '2020-12-26', '', 'U7739542845', 'U7739542845', 'REFUNDED', 'credit', '98', '179', 'TXN547352', '', 'Coupon Rejected, Refund Amount Rs.98', 'success'),
(101, '', '2020-12-26', '', 'UTIMITRA', 'AE8271175524', 'PORTAL', 'debit', '582', '-8591', 'TXN842998', '', 'Transfer to AE8271175524 - ABHISHEK KUMAR ', 'success'),
(102, '', '2020-12-26', '', 'AE8271175524', 'UTIMITRA', 'PORTAL', 'credit', '582', '582', 'TXN842998', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(103, '', '2020-12-26', '', 'AE8271175524', 'AE8271175524', 'COUPON', 'debit', '582', '0', 'TXN201042', '', 'p-coupon Purchase: AE8271175524 - ABHISHEK KUMAR ', 'success'),
(104, '', '2020-12-26', '', 'UTIMITRA', 'AE8271175524', 'COMMISSION', 'credit', '21.6', '-8569.4', 'TXN460120', '', 'Rs.3.6<br>Qty: 6 p-Coupon Commission Credit', 'success'),
(105, '', '2020-12-26', '', 'U7739542845', 'U7739542845', 'COUPON', 'debit', '98', '81', 'TXN318146', '', 'p-coupon Purchase: U7739542845 - AVINASH KUMAR VERMA', 'success'),
(106, '', '2020-12-26', '', 'UTIMITRA', 'U7739542845', 'COMMISSION', 'credit', '4.6', '-8564.8', 'TXN921708', '', 'Rs.4.6<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(107, '', '2021-01-04', '', 'GDS8340658935', 'PPBL UPI', 'ONLINE', 'credit', '1900.00', '1981', '202473_636', '', 'Received from Payment Gateway -UPI', 'success'),
(108, '', '2021-01-04', '', 'GDS8340658935', 'GDS8340658935', 'COUPON', 'debit', '1960', '21', 'TXN816174', '', 'p-coupon Purchase: GDS8340658935 - RITESH SHARMA', 'success'),
(109, '', '2021-01-07', '', 'AE8271175524', 'PPBL UPI', 'ONLINE', 'credit', '485.00', '485', '696970_632', '', 'Received from Payment Gateway -UPI', 'success'),
(110, '', '2021-01-08', '', 'UTIMITRA', 'GDS8340658935', 'COMMISSION', 'credit', '92', '-8472.8', 'TXN719877', '', 'Rs.4.6<br>Qty: 20 p-Coupon Commission Credit', 'success'),
(111, '', '2021-01-08', '', 'AE8271175524', 'AE8271175524', 'COUPON', 'debit', '485', '0', 'TXN723309', '', 'p-coupon Purchase: AE8271175524 - ABHISHEK KUMAR ', 'success'),
(112, '', '2021-01-08', '', 'UTIMITRA', 'AE8271175524', 'COMMISSION', 'credit', '18', '-8454.8', 'TXN337466', '', 'Rs.3.6<br>Qty: 5 p-Coupon Commission Credit', 'success'),
(113, '', '2021-01-13', '', 'AE9572986150', 'U7870848938', 'USERID', 'debit', '21', '140', 'TXN828674', '', 'U7870848938, Purchase: retailer, Id', 'success'),
(114, '', '2021-01-16', '', 'AE9771189441', 'PPBL UPI', 'ONLINE', 'credit', '1000.00', '1000', '720893_631', '', 'Received from Payment Gateway -UPI', 'success'),
(115, '', '2021-01-16', '', 'AE9771189441', 'AE9771189441', 'COUPON', 'debit', '1000', '0', 'TXN544899', '', 'p-coupon Purchase: AE9771189441 - SONU KUMAR', 'success'),
(116, '', '2021-01-18', '', 'UTIMITRA', 'AE9771189441', 'COMMISSION', 'credit', '66', '-8388.8', 'TXN456612', '', 'Rs.6.6<br>Qty: 10 p-Coupon Commission Credit', 'success'),
(117, '', '2021-01-18', '', 'UTIMITRA', 'U9097041982', 'USERID', 'debit', '', '-8388.8', 'TXN317295', '', 'U9097041982, Purchase: distributor, Id', 'success'),
(118, '', '2021-01-20', '', 'UTIMITRA', 'U9924556458', 'PORTAL', 'debit', '1000', '-9388.8', 'TXN700732', '', 'Transfer to U9924556458 - AMARSINH', 'success'),
(119, '', '2021-01-20', '', 'U9924556458', 'UTIMITRA', 'PORTAL', 'credit', '1000', '1000', 'TXN700732', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(120, '', '2021-01-20', '', 'U9924556458', 'U9924556458', 'COUPON', 'debit', '94', '906', 'TXN351137', '', 'p-coupon Purchase: U9924556458 - AMARSINH', 'success'),
(121, '', '2021-01-20', '', 'UTIMITRA', 'U9924556458', 'COMMISSION', 'credit', '0.59999999999999', '-9388.2', 'TXN898455', '', 'Rs.0.59999999999999<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(122, '', '2021-01-20', '', 'U9924556458', 'J9924556457', 'USERID', 'debit', '100', '806', 'TXN110611', '', 'J9924556457, Purchase: retailer, Id', 'success'),
(123, '', '2021-01-20', '', 'U9924556458', 'J9924556457', 'PORTAL', 'debit', '500', '306', 'TXN785700', '', 'Transfer to J9924556457 - AMARSINH', 'success'),
(124, '', '2021-01-20', '', 'J9924556457', 'U9924556458', 'PORTAL', 'credit', '500', '500', 'TXN785700', '', 'Received from U9924556458 - AMARSINH', 'success'),
(125, '', '2021-01-20', '', 'J9924556457', 'J9924556457', 'COUPON', 'debit', '100', '400', 'TXN585266', '', 'p-coupon Purchase: J9924556457 - AMARSINH', 'success'),
(126, '', '2021-01-20', '', 'U9924556458', 'J9924556457', 'COMMISSION', 'credit', '6', '312', 'TXN185987', '', 'Rs.6<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(127, '', '2021-01-20', '', 'UTIMITRA', 'U9924556458', 'COMMISSION', 'credit', '0.59999999999999', '-9387.6', 'TXN185987', '', 'Rs.0.59999999999999<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(128, '', '2021-01-20', '', 'J9924556457', 'J9924556457', 'RECHARGE', 'debit', '9.9', '390.1', 'TXN683757', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(129, '', '2021-01-20', '', 'J9924556457', 'J9924556457', 'RECHARGE', 'credit', '9.9', '400', 'TXN683757', '', 'Recharge , Refund 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(130, '', '2021-01-20', '', 'UTIMITRA', 'UTI9097041982', 'PORTAL', 'debit', '1000', '-10387.6', 'TXN598292', '', 'Transfer to UTI9097041982 - VISHAL KUMAR ', 'success'),
(131, '', '2021-01-20', '', 'UTI9097041982', 'UTIMITRA', 'PORTAL', 'credit', '1000', '1000', 'TXN598292', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(132, '', '2021-01-21', '', 'UTI9097041982', 'UTI9097041982', 'RECHARGE', 'debit', '9.9', '990.1', 'TXN637997', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(133, '', '2021-01-21', '', 'UTI9097041982', 'UTI9097041982', 'RECHARGE', 'credit', '9.9', '1000', 'TXN637997', '', 'Recharge , Refund 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(134, '', '2021-01-23', '', 'UTIMITRA', 'AE9006208184', 'PORTAL', 'debit', '100000', '-110387.6', 'TXN820090', '', 'Transfer to AE9006208184 - SUDHIR KUMAR SINGH', 'success'),
(135, '', '2021-01-23', '', 'AE9006208184', 'UTIMITRA', 'PORTAL', 'credit', '100000', '100300', 'TXN820090', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(136, '', '2021-01-23', '', 'UTIMITRA', 'J9999999999', 'USERID', 'debit', '', '-110387.6', 'TXN451179', '', 'J9999999999, Purchase: retailer, Id', 'success'),
(137, '', '2021-01-23', '', 'UTIMITRA', 'J9999999992', 'USERID', 'debit', '', '-110387.6', 'TXN704530', '', 'J9999999992, Purchase: retailer, Id', 'success'),
(138, '', '2021-01-23', '', 'UTIMITRA', 'J9999999992', 'PORTAL', 'debit', '1000', '-111387.6', 'TXN791312', '', 'Transfer to J9999999992 - AMARSINH PARMAR', 'success'),
(139, '', '2021-01-23', '', 'J9999999992', 'UTIMITRA', 'PORTAL', 'credit', '1000', '1000', 'TXN791312', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(140, '', '2021-01-23', '', 'J9999999992', 'J9999999992', 'NSDLPAN', 'debit', '100', '900', 'TXN397052', '', 'AMARSINH PRAVINSINH PARMAR-506670321897', 'success'),
(141, '', '2021-01-23', '', 'J9999999992', 'J9999999992', 'COUPON', 'debit', '94', '806', 'TXN470940', '', 'p-coupon Purchase: J9999999992 - AMARSINH PARMAR', 'success'),
(142, 'jmkcomputer.in', '2021-01-23', '23-Jan-2021 09:45:02 PM', 'J9999999992', 'HDFC BANK ', 'CASH', 'payment', '6000', '0', '1234567890', '', '', 'rejected'),
(143, '', '2021-01-24', '', 'UTIMITRA', 'J9999999992', 'COMMISSION', 'credit', '0.59999999999999', '-111387', 'TXN436070', '', 'Rs.0.59999999999999<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(144, '', '2021-01-24', '', 'J9998129004', 'JSMC9998129005', 'USERID', 'debit', '0', '0', 'TXN358142', '', 'JSMC9998129005, Purchase: supdistributor, Id', 'success'),
(145, '', '2021-01-24', '', 'JSMC9998129005', 'JSMC9998129006', 'USERID', 'debit', '', '0', 'TXN683208', '', 'JSMC9998129006, Purchase: distributor, Id', 'success'),
(146, '', '2021-01-24', '', 'UTIMITRA', 'JSMC9998129006', 'PORTAL', 'debit', '1', '-111388', 'TXN512227', '', 'Transfer to JSMC9998129006 - AMARSINH PARMAR', 'success'),
(147, '', '2021-01-24', '', 'JSMC9998129006', 'UTIMITRA', 'PORTAL', 'credit', '1', '1', 'TXN512227', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(148, '', '2021-01-24', '', 'JSMC9998129006', 'JSMC9998129007', 'USERID', 'debit', '0', '1', 'TXN944542', '', 'JSMC9998129007, Purchase: retailer, Id', 'success'),
(149, '', '2021-01-24', '', 'UTIMITRA', 'JSMC9998129007', 'PORTAL', 'debit', '1000', '-112388', 'TXN324246', '', 'Transfer to JSMC9998129007 - AMARSINH PARMAR', 'success'),
(150, '', '2021-01-24', '', 'JSMC9998129007', 'UTIMITRA', 'PORTAL', 'credit', '1000', '1000', 'TXN324246', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(151, '', '2021-01-24', '', 'JSMC9998129007', 'JSMC9998129007', 'NSDLPAN', 'debit', '107', '893', 'TXN682893', '', 'JAYESHKUMAR BALABHAI TARAL-836317127819', 'success'),
(152, '', '2021-01-24', '', 'JSMC9998129007', 'JSMC9998129007', 'COUPON', 'debit', '97', '796', 'TXN832475', '', 'p-coupon Purchase: JSMC9998129007 - AMARSINH PARMAR', 'success'),
(153, '', '2021-01-24', '', 'JSMC9998129006', 'JSMC9998129007', 'COMMISSION', 'credit', '1', '2', 'TXN653677', '', 'Rs.1<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(154, '', '2021-01-24', '', 'JSMC9998129005', 'JSMC9998129006', 'COMMISSION', 'credit', '1', '1', 'TXN653677', '', 'Rs.1<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(155, '', '2021-01-24', '', 'J9998129004', 'JSMC9998129005', 'COMMISSION', 'credit', '1', '1', 'TXN653677', '', 'Rs.1<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(156, 'egramseva.co.in', '2021-01-24', '24-Jan-2021 02:09:29 PM', 'JSMC9998129005', 'STATE BANK OF INDIA', 'CHEQUE', 'payment', '100', '101', '92542544444', '', 'ok', 'approved'),
(157, 'jmkcomputer.in', '2021-01-24', '24-Jan-2021 02:11:51 PM', 'J9998129004', 'HDFC BANK ', 'CASH', 'payment', '1000', '1001', '9255555555', '', 'ok', 'approved'),
(158, 'jmkcomputer.in', '2021-01-24', '', 'UTIMITRA', 'J9998129004', 'PORTAL', 'debit', '1000', '-113388', 'TXN264585', '', 'Payment Approved to J9998129004 - AMARSINH PARMAR', 'success'),
(159, 'egramseva.co.in', '2021-01-24', '', 'J9998129004', 'JSMC9998129005', 'PORTAL', 'debit', '100', '901', 'TXN424759', '', 'Payment Approved to JSMC9998129005 - AMARSINH PARMAR', 'success'),
(160, '', '2021-01-24', '', 'JSMC9998129005', 'JSMC9998129006', 'COUPON', 'debit', '95', '6', 'TXN323214', '', 'p-coupon Purchase: JSMC9998129006 - AMARSINH PARMAR', 'success'),
(161, '', '2021-01-24', '', 'JSMC9998129005', 'JSMC9998129005', 'REFUNDED', 'credit', '95', '101', 'TXN360322', '', 'Coupon Rejected, Refund Amount Rs.95', 'success'),
(162, '', '2021-01-24', '', 'JSMC9998129005', 'PPBL UPI', 'ONLINE', 'credit', '100.00', '201', '409852_661', '', 'Received from Payment Gateway -UPI', 'success'),
(163, '', '2021-01-24', '', 'UTIMITRA', 'J9924556458', 'PORTAL', 'debit', '2000', '-115388', 'TXN603307', '', 'Transfer to J9924556458 - AMARSINH PARMAR', 'success'),
(164, '', '2021-01-24', '', 'J9924556458', 'UTIMITRA', 'PORTAL', 'credit', '2000', '2000', 'TXN603307', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(165, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'USERID', 'debit', '', '-115388', 'TXN508976', '', 'J9998129006, Purchase: retailer, Id', 'success'),
(166, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'PORTAL', 'debit', '100', '-115488', 'TXN639634', '', 'Transfer to J9998129006 - AMARSINH P', 'success'),
(167, '', '2021-01-25', '', 'J9998129006', 'UTIMITRA', 'PORTAL', 'credit', '100', '100', 'TXN639634', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(168, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'NSDLPAN', 'debit', '96', '4', 'TXN205792', '', 'AMARSINH KASJDAKD PARMAR-999999999999', 'success'),
(169, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'COMMISSION', 'credit', '1', '-115487', 'TXN641440', '', 'OrderId:205792 NSDL P-PAN Commission Credit Rs.1', 'success'),
(170, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '3.96', '0.04', 'TXN444301', '', '9924556458, Opt:airtel, Amt Rs.4', 'success'),
(171, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'COMMISSION', 'credit', '0.032', '-115486.968', 'TXN444301', '', 'Rs.0.032, Recharge Commission, 9924556458, Opt:airtel, Amt Rs.4', 'success'),
(172, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'PORTAL', 'debit', '1000', '-116486.968', 'TXN829659', '', 'Transfer to J9998129006 - AMARSINH P', 'success'),
(173, '', '2021-01-25', '', 'J9998129006', 'UTIMITRA', 'PORTAL', 'credit', '1000', '1000.04', 'TXN829659', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(174, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '990.14', 'TXN627310', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(175, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'COMMISSION', 'credit', '0.08', '-116486.888', 'TXN627310', '', 'Rs.0.08, Recharge Commission, 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(176, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '980.24', 'TXN716407', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(177, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'COMMISSION', 'credit', '0.08', '-116486.808', 'TXN716407', '', 'Rs.0.08, Recharge Commission, 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(178, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '970.34', 'TXN971638', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(179, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'credit', '9.9', '980.24', 'TXN971638', '', 'Recharge , Refund 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(180, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '970.34', 'TXN186356', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(181, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'COMMISSION', 'credit', '0.08', '-116486.728', 'TXN186356', '', 'Rs.0.08, Recharge Commission, 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(182, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '960.44', 'TXN919605', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(183, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'COMMISSION', 'credit', '0.08', '-116486.648', 'TXN919605', '', 'Rs.0.08, Recharge Commission, 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(184, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '950.54', 'TXN811003', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(185, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '940.64', 'TXN510532', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(186, 'egramseva.co.in', '2021-01-25', '25-Jan-2021 11:22:47 PM', 'J9998129006', 'HDFC BANK ', 'CHEQUE', 'payment', '1000', '0', '1111111111111', '', 'SBI', 'pending'),
(187, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '930.74', 'TXN816353', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(188, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'credit', '9.9', '940.64', 'TXN816353', '', 'Recharge failed, Refund 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(189, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '930.74', 'TXN919075', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(190, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'credit', '9.9', '940.64', 'TXN919075', '', 'Recharge , Refund 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(191, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'debit', '9.9', '930.74', 'TXN161188', '', '9924556458, Opt:airtel, Amt Rs.10', 'success'),
(192, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'RECHARGE', 'credit', '9.9', '940.64', 'TXN161188', '', 'Recharge , Refund 9924556458, Opt:airtel, Amt Rs.10', 'success'),
(193, '', '2021-01-25', '', 'J9998129006', 'J9998129006', 'COUPON', 'debit', '95', '845.64', 'TXN971847', '', 'p-coupon Purchase: J9998129006 - AMARSINH P', 'success'),
(194, '', '2021-01-25', '', 'UTIMITRA', 'J9998129006', 'COMMISSION', 'credit', '1.6', '-116485.048', 'TXN736041', '', 'Rs.1.6<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(195, '', '2021-01-26', '', 'UTIMITRA', 'US9924556450', 'PORTAL', 'debit', '1000', '-117485.048', 'TXN588234', '', 'Transfer to US9924556450 - AMARSINH PARMAR', 'success'),
(196, '', '2021-01-26', '', 'US9924556450', 'UTIMITRA', 'PORTAL', 'credit', '1000', '1000', 'TXN588234', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(197, '', '2021-01-26', '', 'J9924556458', 'US9924556450', 'API COUPON', 'debit', '470', '1530', 'TXN862158', '', 'Api p-coupon Purchase: US9924556450 - AMARSINH PARMAR', 'success'),
(198, '', '2021-01-26', '', 'J9924556458', 'J9924556458', 'REFUNDED', 'credit', '470', '2000', 'TXN997487', '', 'Coupon Rejected, Refund Amount Rs.470', 'success'),
(199, '', '2021-04-16', '', 'UTIMITRA', 'RKSO9510564221', 'USERID', 'debit', '', '100000000', 'TXN399558', '', 'RKSO9510564221, Purchase: retailer, Id', 'success'),
(200, '', '2021-04-16', '', 'UTIMITRA', 'RKSO9510564221', 'PORTAL', 'debit', '500', '99999500', 'TXN963613', '', 'Transfer to RKSO9510564221 - MUKESHBHAI', 'success'),
(201, '', '2021-04-16', '', 'RKSO9510564221', 'UTIMITRA', 'PORTAL', 'credit', '500', '500', 'TXN963613', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(202, '', '2021-04-16', '', 'RKSO9510564221', 'RKSO9510564221', 'COUPON', 'debit', '495', '5', 'TXN183473', '', 'p-coupon Purchase: RKSO9510564221 - MUKESHBHAI', 'success'),
(203, '', '2021-04-16', '', 'RKSO9510564221', 'RKSO9510564221', 'REFUNDED', 'credit', '495', '500', 'TXN606536', '', 'Coupon Rejected, Refund Amount Rs.495', 'success'),
(204, 'rkservice.online', '2021-04-17', '', 'UTIMITRA', 'UTIMITRA', 'RECHARGE', 'debit', '9.62', '99999490.38', 'TXN754883', '', '9638408975, Opt:idea, Amt Rs.10', 'success'),
(205, 'rkservice.online', '2021-04-17', '', 'UTIMITRA', 'UTIMITRA', 'RECHARGE', 'credit', '9.62', '99999500', 'TXN754883', '', 'Recharge , Refund 9638408975, Opt:idea, Amt Rs.10', 'success'),
(206, 'rkservice.online', '2021-04-17', '', 'UTIMITRA', 'UTIMITRA', 'RECHARGE', 'debit', '9.62', '99999490.38', 'TXN936697', '', '9638408975, Opt:idea, Amt Rs.10', 'success'),
(207, 'rkservice.online', '2021-04-17', '', 'UTIMITRA', 'UTIMITRA', 'RECHARGE', 'credit', '9.62', '99999500', 'TXN936697', '', 'Recharge , Refund 9638408975, Opt:idea, Amt Rs.10', 'success'),
(208, '', '2021-04-17', '', 'UTIMITRA', 'RKSO9510564221', 'PORTAL', 'debit', '10', '99999490', 'TXN222551', '', 'Transfer to RKSO9510564221 - MUKESHBHAI', 'success'),
(209, '', '2021-04-17', '', 'RKSO9510564221', 'UTIMITRA', 'PORTAL', 'credit', '10', '510', 'TXN222551', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(210, '', '2021-04-17', '', 'UTIMITRA', 'RKSO9510564221', 'PORTAL', 'credit', '10', '99999500', 'TXN571020', '', 'Credit from RKSO9510564221 - MUKESHBHAI', 'success'),
(211, '', '2021-04-17', '', 'RKSO9510564221', 'UTIMITRA', 'PORTAL', 'debit', '10', '500', 'TXN571020', '', 'Debit Through UTIMITRA - ADMIN_UTI', 'success'),
(212, '', '2021-04-17', '', 'RKSO9510564221', 'RKSO9510564221', 'COUPON', 'debit', '99', '401', 'TXN115866', '', 'p-coupon Purchase: RKSO9510564221 - MUKESHBHAI', 'success'),
(213, '', '2021-04-17', '', 'RKSO9510564221', 'RKSO9510564221', 'REFUNDED', 'credit', '99', '500', 'TXN520556', '', 'Coupon Rejected, Refund Amount Rs.99', 'success'),
(214, 'rkservice.online', '2021-04-17', '', 'RKSO9510564221', 'RKSO9510564221', 'RECHARGE', 'debit', '10', '490', 'TXN284404', '', '10, Opt:idea, Amt Rs.10', 'success'),
(215, 'rkservice.online', '2021-04-17', '', 'RKSO9510564221', 'RKSO9510564221', 'RECHARGE', 'credit', '10', '500', 'TXN284404', '', 'Recharge , Refund 10, Opt:idea, Amt Rs.10', 'success'),
(216, 'rkservice.online', '2021-04-17', '17-Apr-2021 11:53:08 AM', 'RKSO9510564221', 'BANK OF BARODA', 'NEFT', 'payment', '10', '0', 'M', '', '', 'rejected'),
(217, '', '2021-04-19', '', 'UTIMITRA', 'P&RS9726517118', 'USERID', 'debit', '', '99999500', 'TXN881300', '', 'P&RS9726517118, Purchase: retailer, Id', 'success'),
(218, '', '2021-04-19', '', 'UTIMITRA', 'RKS9726517118', 'USERID', 'debit', '', '99999500', 'TXN386870', '', 'RKS9726517118, Purchase: retailer, Id', 'success'),
(219, '', '2021-04-19', '', 'UTIMITRA', 'RKS9638408975', 'USERID', 'debit', '', '99999500', 'TXN618061', '', 'RKS9638408975, Purchase: retailer, Id', 'success'),
(220, '', '2021-04-19', '', 'UTIMITRA', 'RKS8469332244', 'USERID', 'debit', '0', '99999500', 'TXN385925', '', 'RKS8469332244, Purchase: supdistributor, Id', 'success'),
(221, '', '2021-04-20', '', 'UTIMITRA', 'RKS8980772172', 'USERID', 'debit', '', '99999500', 'TXN947146', '', 'RKS8980772172, Purchase: retailer, Id', 'success'),
(222, '', '2021-04-20', '', 'RKS9638408975', 'PPBL UPI', 'ONLINE', 'credit', '1.00', '1', '788153_673', '', 'Received from Payment Gateway -UPI', 'success'),
(223, '', '2021-04-20', '', 'UTIMITRA', 'RKS9638408975', 'PORTAL', 'credit', '1', '99999501', 'TXN224360', '', 'Credit from RKS9638408975 - MUESHBHAI', 'success'),
(224, '', '2021-04-20', '', 'RKS9638408975', 'UTIMITRA', 'PORTAL', 'debit', '1', '0', 'TXN224360', '', 'Debit Through UTIMITRA - ADMIN_UTI', 'success'),
(225, '', '2021-04-20', '', 'UTIMITRA', 'RKS9638408975', 'PORTAL', 'debit', '1', '99999500', 'TXN747980', '', 'Transfer to RKS9638408975 - MUESHBHAI', 'success'),
(226, '', '2021-04-20', '', 'RKS9638408975', 'UTIMITRA', 'PORTAL', 'credit', '1', '1', 'TXN747980', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(227, '', '2021-04-20', '', 'UTIMITRA', 'RKS7067447138', 'USERID', 'debit', '', '99999500', 'TXN524552', '', 'RKS7067447138, Purchase: distributor, Id', 'success'),
(228, '', '2021-04-21', '', 'UTIMITRA', 'RKS9576342098', 'USERID', 'debit', '', '99999500', 'TXN689612', '', 'RKS9576342098, Purchase: retailer, Id', 'success'),
(229, '', '2021-04-21', '', 'UTIMITRA', 'RKS8271581181', 'USERID', 'debit', '', '99999500', 'TXN267075', '', 'RKS8271581181, Purchase: distributor, Id', 'success'),
(230, '', '2021-04-22', '', 'RKS9638408975', 'PPBL UPI', 'ONLINE', 'credit', '1.00', '2', '716353_673', '', 'Received from Payment Gateway -UPI', 'success'),
(231, '', '2021-04-22', '', 'UTIMITRA', 'RKS9576342098', 'PORTAL', 'debit', '1', '99999499', 'TXN532297', '', 'Transfer to RKS9576342098 - MUKESH KUMAR PODDAR', 'success'),
(232, '', '2021-04-22', '', 'RKS9576342098', 'UTIMITRA', 'PORTAL', 'credit', '1', '1', 'TXN532297', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(233, '', '2021-04-22', '', 'RKS9576342098', 'PPBL UPI', 'ONLINE', 'credit', '115.00', '116', '954052_682', '', 'Received from Payment Gateway -UPI', 'success'),
(234, '', '2021-04-22', '', 'UTIMITRA', 'RKS9638408975', 'PORTAL', 'debit', '95', '99999404', 'TXN575968', '', 'Transfer to RKS9638408975 - MUKESHBHAI', 'success'),
(235, '', '2021-04-22', '', 'RKS9638408975', 'UTIMITRA', 'PORTAL', 'credit', '95', '97', 'TXN575968', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(236, '', '2021-04-22', '', 'RKS9638408975', 'RKS9638408975', 'COUPON', 'debit', '95.5', '1.5', 'TXN477798', '', 'p-coupon Purchase: RKS9638408975 - MUKESHBHAI', 'success'),
(237, '', '2021-04-22', '', 'UTIMITRA', 'RKS9638408975', 'COMMISSION', 'credit', '0', '99999404', 'TXN477798', '', 'Rs.0<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(238, '', '2021-04-23', '', 'RKS9576342098', 'RKS9576342098', 'COUPON', 'debit', '105', '11', 'TXN801685', '', 'p-coupon Purchase: RKS9576342098 - MUKESH KUMAR PODDAR', 'success'),
(239, '', '2021-04-23', '', 'UTIMITRA', 'RKS9576342098', 'COMMISSION', 'credit', '9.5', '99999413.5', 'TXN801685', '', 'Rs.9.5<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(240, '', '2021-04-24', '', 'UTIMITRA', 'RKS9016540265', 'USERID', 'debit', '', '99999413.5', 'TXN238248', '', 'RKS9016540265, Purchase: distributor, Id', 'success'),
(241, '', '2021-04-26', '', 'UTIMITRA', 'RKS9955043560', 'USERID', 'debit', '', '99999413.5', 'TXN749719', '', 'RKS9955043560, Purchase: retailer, Id', 'success'),
(242, '', '2021-04-26', '', 'UTIMITRA', 'RKS9638408975', 'PORTAL', 'debit', '105', '99999308.5', 'TXN703018', '', 'Transfer to RKS9638408975 - MUKESHBHAI', 'success'),
(243, '', '2021-04-26', '', 'RKS9638408975', 'UTIMITRA', 'PORTAL', 'credit', '105', '106.5', 'TXN703018', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(244, '', '2021-04-26', '', 'UTIMITRA', 'RKS9638408975', 'PORTAL', 'debit', '1', '99999307.5', 'TXN116972', '', 'Transfer to RKS9638408975 - MUKESHBHAI', 'success'),
(245, '', '2021-04-26', '', 'RKS9638408975', 'UTIMITRA', 'PORTAL', 'credit', '1', '107.5', 'TXN116972', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(246, '', '2021-04-27', '', 'UTIMITRA', 'RKS8500372153', 'USERID', 'debit', '', '99999307.5', 'TXN604294', '', 'RKS8500372153, Purchase: retailer, Id', 'success'),
(247, 'rkservice.online', '2021-04-28', '', 'UTIMITRA', 'UTIMITRA', 'RECHARGE', 'debit', '143.338', '99999164.162', 'TXN961023', '', '9913155622, Opt:idea, Amt Rs.149', 'success'),
(248, 'rkservice.online', '2021-04-28', '', 'UTIMITRA', 'UTIMITRA', 'RECHARGE', 'credit', '143.338', '99999307.5', 'TXN961023', '', 'Recharge , Refund 9913155622, Opt:idea, Amt Rs.149', 'success'),
(249, 'rkservice.online', '2021-04-28', '', 'UTIMITRA', 'UTIMITRA', 'RECHARGE', 'debit', '9.62', '99999297.88', 'TXN260500', '', '9638408975, Opt:idea, Amt Rs.10', 'success'),
(250, 'rkservice.online', '2021-04-28', '', 'UTIMITRA', 'UTIMITRA', 'RECHARGE', 'credit', '9.62', '99999307.5', 'TXN260500', '', 'Recharge , Refund 9638408975, Opt:idea, Amt Rs.10', 'success'),
(251, '', '2021-04-28', '', 'RKS9638408975', 'RKS9638408975', 'NSDLPAN', 'debit', '107', '0.5', 'TXN924029', '', 'MARIWAD NANABHAI-605645238878', 'success'),
(252, '', '2021-04-28', '', 'RKS9638408975', 'UTIMITRA', 'REFUNDED', 'credit', '107', '107.5', 'TXN340028', '', 'P-PAN Rejected, Refund Amount Rs.107, OrderId:924029', 'success'),
(253, '', '2021-04-29', '', 'RKS9638408975', 'RKS9638408975', 'NSDLPAN', 'debit', '107', '0.5', 'TXN717549', '', 'MARIWAD NANABHAI-605645238878', 'success'),
(254, '', '2021-05-04', '', 'RKS9638408975', 'PPBL UPI', 'ONLINE', 'credit', '100.00', '100.5', '238906_673', '', 'Received from Payment Gateway -UPI', 'success'),
(255, '', '2021-05-04', '', 'RKS9638408975', 'PPBL UPI', 'ONLINE', 'credit', '1.00', '101.5', '411308_673', '', 'Received from Payment Gateway -UPI', 'success'),
(256, '', '2021-05-04', '', 'RKS9638408975', 'RKS9638408975', 'COUPON', 'debit', '95.5', '6', 'TXN531938', '', 'p-coupon Purchase: RKS9638408975 - MUKESHBHAI', 'success'),
(257, '', '2021-05-04', '', 'UTIMITRA', 'RKS9638408975', 'COMMISSION', 'credit', '0', '99999307.5', 'TXN531938', '', 'Rs.0<br>Qty: 1 p-Coupon Commission Credit', 'success'),
(258, '', '2021-05-06', '', 'UTIMITRA', 'RKS9016540265', 'PORTAL', 'debit', '50', '99999257.5', 'TXN833378', '', 'Transfer to RKS9016540265 - DAMOR PARVATBHAI DHIRABHAI', 'success'),
(259, '', '2021-05-06', '', 'RKS9016540265', 'UTIMITRA', 'PORTAL', 'credit', '50', '50', 'TXN833378', '', 'Received from UTIMITRA - ADMIN_UTI', 'success'),
(260, '', '2021-05-14', '', 'RKS9638408975', 'PPBL UPI', 'ONLINE', 'credit', '1.00', '7', '856262_673', '', 'Received from Payment Gateway -UPI', 'success'),
(261, '', '2021-05-23', '', 'RKS9638408975', 'UTIMITRA', 'REFUNDED', 'credit', '107', '114', 'TXN360592', '', 'P-PAN Rejected, Refund Amount Rs.107, OrderId:717549', 'success'),
(262, '', '2021-05-23', '', 'UTIMITRA', 'RKS9712678989', 'USERID', 'debit', '', '99999257.5', 'TXN702001', '', 'RKS9712678989, Purchase: distributor, Id', 'success'),
(263, '', '2021-05-24', '', 'RKS9712678989', 'PPBL NB', 'ONLINE', 'credit', '0.97', '0.97', '643859_701', '', 'Received from Payment Gateway -NB', 'success'),
(264, '', '2021-05-27', '', 'UTIMITRA', 'RKS7859035590', 'USERID', 'debit', '', '99999257.5', 'TXN293385', '', 'RKS7859035590, Purchase: retailer, Id', 'success'),
(265, '', '2021-06-06', '', 'UTIMITRA', 'RKS7567649023', 'USERID', 'debit', '', '99999257.5', 'TXN988778', '', 'RKS7567649023, Purchase: retailer, Id', 'success'),
(266, '', '2023-08-28', '', 'ESK-ADMIN', '1111111111', 'USERID', 'debit', '', '99999257.5', 'TXN859793', '', '1111111111, Purchase: retailer, Id', 'success'),
(267, 'pan.pancardpdf.in', '2023-08-31', '', 'ESK-ADMIN', 'ESK-ADMIN', 'RECHARGE', 'debit', '15', '99999242.5', 'TXN274183', '', '9773244037, Opt:, Amt Rs.15', 'success'),
(268, 'pan.pancardpdf.in', '2023-08-31', '', 'ESK-ADMIN', 'ESK-ADMIN', 'RECHARGE', 'credit', '15', '99999257.5', 'TXN274183', '', 'Recharge , Refund 9773244037, Opt:, Amt Rs.15', 'success'),
(269, '', '2023-08-31', '', 'ESK-ADMIN', '1111111111', 'PORTAL', 'debit', '1', '99999256.5', 'TXN913007', '', 'Transfer to 1111111111 - DEMO', 'success'),
(270, '', '2023-08-31', '', '1111111111', 'ESK-ADMIN', 'PORTAL', 'credit', '1', '1', 'TXN913007', '', 'Received from ESK-ADMIN - MAIN ADMIN', 'success'),
(271, '', '2023-08-31', '', 'ESK-ADMIN', '1111111111', 'PORTAL', 'debit', '1', '99999255.5', 'TXN531346', '', 'Transfer to 1111111111 - DEMO', 'success'),
(272, '', '2023-08-31', '', '1111111111', 'ESK-ADMIN', 'PORTAL', 'credit', '1', '2', 'TXN531346', '', 'Received from ESK-ADMIN - MAIN ADMIN', 'success'),
(273, '', '2023-08-31', '', 'ESK-ADMIN', '1111111111', 'PORTAL', 'debit', '1', '99999254.5', 'TXN304621', '', 'Transfer to 1111111111 - DEMO', 'success'),
(274, '', '2023-08-31', '', '1111111111', 'ESK-ADMIN', 'PORTAL', 'credit', '1', '3', 'TXN304621', '', 'Received from ESK-ADMIN - MAIN ADMIN', 'success'),
(275, '', '2023-09-12 09:28:02', '', '1111111111', '1111111111', 'PANPDF', 'debit', '1', '2', 'TXN20230912092802', '', 'HKBPK2304H - 249590434936', 'success'),
(276, '', '2023-09-13 09:40:18', '', '7021281169', '7021281169', 'PAN FIND', 'debit', '22', '28', 'ESKESK4879662', '', '411048365709', 'success'),
(277, '', '2023-09-14 12:16:17', '', 'PRITA-ADMIN', 'PRITA-ADMIN', 'PAN FIND', 'debit', '22', '99999234.5', 'ESKESK64027165', '', '953898606122', 'success'),
(278, '', '2023-09-14 12:17:25', '', 'PRITA-ADMIN', 'PRITA-ADMIN', 'PANPDF', 'debit', '10', '99999224.5', 'TXN20230914121725', '', 'HLNPS0364G - 953898606122', 'success'),
(279, '', '2023-09-14 12:25:22', '', '7021281169', '7021281169', 'PAN FIND', 'debit', '22', '258', 'ESKESK82939791', '', '249590434936', 'success'),
(280, '', '2023-09-14 12:25:53', '', '7021281169', '7021281169', 'PANPDF', 'debit', '50', '208', 'TXN20230914122553', '', 'HKBPK2304H - 249590434936', 'success'),
(281, '', '2023-09-14', '', '7021281169', 'BHARATPE.8000759213<br>7526501179', 'ONLINE', 'credit', '1', '209', '7526501179', '362315217066', 'Received from JIGARKUMAR RAMESHBHAI SADAT - <b>BankRRN: </b>362315217066', 'success'),
(282, '', '2023-10-13', '', 'FIND-ADMIN', '7059592222', 'PORTAL', 'debit', '50', '99999174.5', 'TXN371617', '', 'Transfer to 7059592222 - MAYUR', 'success'),
(283, '', '2023-10-13', '', '7059592222', 'FIND-ADMIN', 'PORTAL', 'credit', '50', '50', 'TXN371617', '', 'Received from FIND-ADMIN - MAIN ADMIN', 'success'),
(284, '', '2023-10-13 01:36:50', '', '7059592222', '7059592222', 'PAN FIND', 'debit', '22', '28', 'ESKESK77410750', '', '464658430412', 'success'),
(285, '', '2023-10-13 01:36:50', '', 'FIND-ADMIN', '7059592222', 'COMMISSION', 'credit', '5', '99999179.5', 'TXNESK77410750', '', 'Rs.5 Commission Credit', 'success'),
(286, '', '2023-10-16', '', 'FIND-ADMIN', '7059592222', 'PORTAL', 'debit', '20', '99999159.5', 'TXN101854', '', 'Transfer to 7059592222 - MAYUR', 'success'),
(287, '', '2023-10-16', '', '7059592222', 'FIND-ADMIN', 'PORTAL', 'credit', '20', '48', 'TXN101854', '', 'Received from FIND-ADMIN - MAIN ADMIN', 'success'),
(288, '', '2023-10-17 12:06:25', '', '7059592222', '7059592222', 'PAN FIND', 'debit', '22', '26', 'ESKESK97549571', '', '368626595827', 'success'),
(289, '', '2023-10-17 12:06:25', '', 'FIND-ADMIN', '7059592222', 'COMMISSION', 'credit', '10', '99999169.5', 'TXNESK97549571', '', 'Rs.10 Commission Credit', 'success'),
(290, '', '2023-10-18', '', 'FIND-ADMIN', '7059592222', 'PORTAL', 'debit', '50', '99999119.5', 'TXN238308', '', 'Transfer to 7059592222 - MAYUR', 'success'),
(291, '', '2023-10-18', '', '7059592222', 'FIND-ADMIN', 'PORTAL', 'credit', '50', '76', 'TXN238308', '', 'Received from FIND-ADMIN - MAIN ADMIN', 'success'),
(292, '', '2023-10-18 01:12:43', '', '7059592222', '7059592222', 'PAN FIND', 'debit', '22', '54', 'ESKESK78300293', '', '908210355315', 'success'),
(293, '', '2023-10-18 01:12:43', '', 'FIND-ADMIN', '7059592222', 'COMMISSION', 'credit', '10', '99999129.5', 'TXNESK78300293', '', 'Rs.10 Commission Credit', 'success'),
(294, '', '2023-10-18 01:13:06', '', '7059592222', '7059592222', 'PAN FIND', 'debit', '22', '32', 'ESKESK68615548', '', '908210355315', 'success'),
(295, '', '2023-10-18 01:13:06', '', 'FIND-ADMIN', '7059592222', 'COMMISSION', 'credit', '10', '99999139.5', 'TXNESK68615548', '', 'Rs.10 Commission Credit', 'success'),
(296, '', '2023-10-21', '', 'FIND-ADMIN', '7059592222', 'PORTAL', 'debit', '10', '99999129.5', 'TXN594321', '', 'Transfer to 7059592222 - MAYUR', 'success'),
(297, '', '2023-10-21', '', '7059592222', 'FIND-ADMIN', 'PORTAL', 'credit', '10', '42', 'TXN594321', '', 'Received from FIND-ADMIN - MAIN ADMIN', 'success'),
(298, '', '2023-10-21 12:05:22', '', '7059592222', '7059592222', 'PAN FIND', 'debit', '22', '20', 'ESKESK74435574', '', '623514250969', 'success'),
(299, '', '2023-10-21 12:05:22', '', 'FIND-ADMIN', '7059592222', 'COMMISSION', 'credit', '10', '99999139.5', 'TXNESK74435574', '', 'Rs.10 Commission Credit', 'success'),
(300, '', '2023-10-23', '', 'FIND-ADMIN', '8983884008', 'PORTAL', 'debit', '5', '99999134.5', 'TXN805481', '', 'Transfer to 8983884008 - KARAN DEOKAR', 'success'),
(301, '', '2023-10-23', '', '8983884008', 'FIND-ADMIN', 'PORTAL', 'credit', '5', '5', 'TXN805481', '', 'Received from FIND-ADMIN - MAIN ADMIN', 'success');
INSERT INTO `paymentreq` (`id`, `web_url`, `date_time`, `datetime`, `user`, `bank`, `mode`, `type`, `amount`, `balance`, `reference`, `orderid`, `remark`, `status`) VALUES
(302, '', '2023-10-23', '', 'FIND-ADMIN', '7059592222', 'PORTAL', 'debit', '50', '99999084.5', 'TXN444336', '', 'Transfer to 7059592222 - MAYUR', 'success'),
(303, '', '2023-10-23', '', '7059592222', 'FIND-ADMIN', 'PORTAL', 'credit', '50', '70', 'TXN444336', '', 'Received from FIND-ADMIN - MAIN ADMIN', 'success'),
(304, '', '2023-10-23 05:06:25', '', '7059592222', '7059592222', 'PAN FIND', 'debit', '22', '48', 'ESKESK83816641', '', '308904462512', 'success'),
(305, '', '2023-10-23 05:06:25', '', 'FIND-ADMIN', '7059592222', 'COMMISSION', 'credit', '10', '99999094.5', 'TXNESK83816641', '', 'Rs.10 Commission Credit', 'success'),
(306, '', '2023-11-03', '', 'FIND-ADMIN', '8983884008', 'PORTAL', 'debit', '30', '99999064.5', 'TXN516808', '', 'Transfer to 8983884008 - KARAN DEOKAR', 'success'),
(307, '', '2023-11-03', '', '8983884008', 'FIND-ADMIN', 'PORTAL', 'credit', '30', '35', 'TXN516808', '', 'Received from FIND-ADMIN - MAIN ADMIN', 'success'),
(308, '', '2023-11-04 10:09:49', '', '8983884008', '8983884008', 'PAN FIND', 'debit', '22', '13', 'ESKESK76055704', '', '429174289124', 'success'),
(309, '', '2023-11-04 10:09:49', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99999074.5', 'TXNESK76055704', '', 'Rs.10 Commission Credit', 'success'),
(310, '', '2023-11-04', '', '7059592222', 'BHARATPE.8001326591<br>8143008247', 'ONLINE', 'credit', '10', '58', '8143008247', '330868891562', 'Received from SAHARA COMMUNICATION - <b>BankRRN: </b>330868891562', 'success'),
(311, '', '2023-11-04', '', '9552530593', 'BHARATPE.8001326591<br>8143222734', 'ONLINE', 'credit', '50', '50', '8143222734', '330884463899', 'Received from HUSEN MUBARAK TAMBOLI - <b>BankRRN: </b>330884463899', 'success'),
(312, '', '2023-11-04 11:02:07', '', '9552530593', '9552530593', 'PAN FIND', 'debit', '22', '28', 'ESKESK26218515', '', '828952727576', 'success'),
(313, '', '2023-11-04 11:02:07', '', '8983884008', '9552530593', 'COMMISSION', 'credit', '15', '28', 'TXNESK26218515', '', 'Rs.15 Commission Credit', 'success'),
(314, '', '2023-11-04 11:02:07', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99999084.5', 'TXNESK26218515', '', 'Rs.10 Coupon Commission Credit', 'success'),
(315, '', '2023-11-04', '', '7030570446', 'BHARATPE.8001326591<br>8144074888', 'ONLINE', 'credit', '45', '45', '8144074888', '330897596283', 'Received from SHUBHAM - <b>BankRRN: </b>330897596283', 'success'),
(316, '', '2023-11-04 12:32:12', '', '7030570446', '7030570446', 'PAN FIND', 'debit', '22', '23', 'ESKESK70648638', '', '506323068465', 'success'),
(317, '', '2023-11-04 12:32:12', '', '8983884008', '7030570446', 'COMMISSION', 'credit', '15', '43', 'TXNESK70648638', '', 'Rs.15 Commission Credit', 'success'),
(318, '', '2023-11-04 12:32:12', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99999094.5', 'TXNESK70648638', '', 'Rs.10 Coupon Commission Credit', 'success'),
(319, '', '2023-11-04', '', '9096095560', 'BHARATPE.8001326591<br>8146402366', 'ONLINE', 'credit', '50', '50', '8146402366', '330824544613', 'Received from YOGESH NAGNATH SATPUTE - <b>BankRRN: </b>330824544613', 'success'),
(320, '', '2023-11-04 03:21:43', '', '9096095560', '9096095560', 'PAN FIND', 'debit', '22', '28', 'ESKESK6959723', '', '496479810757', 'success'),
(321, '', '2023-11-04 03:21:43', '', '8983884008', '9096095560', 'COMMISSION', 'credit', '15', '58', 'TXNESK6959723', '', 'Rs.15 Commission Credit', 'success'),
(322, '', '2023-11-04 03:21:43', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99999104.5', 'TXNESK6959723', '', 'Rs.10 Coupon Commission Credit', 'success'),
(323, '', '2023-11-05 06:56:54', '', '7059592222', '7059592222', 'PAN FIND', 'debit', '22', '36', 'ESKESK10567917', '', '523453150146', 'success'),
(324, '', '2023-11-05 06:56:54', '', 'FIND-ADMIN', '7059592222', 'COMMISSION', 'credit', '10', '99999114.5', 'TXNESK10567917', '', 'Rs.10 Commission Credit', 'success'),
(325, '', '2023-11-06', '', '8010606248', 'BHARATPE.8001326591<br>8169044942', 'ONLINE', 'credit', '100', '100', '8169044942', '331050966557', 'Received from TUSHAR PRAKASH DALVI - <b>BankRRN: </b>331050966557', 'success'),
(326, '', '2023-11-06', '', '8805114276', 'BHARATPE.8001326591<br>8170706915', 'ONLINE', 'credit', '100', '100', '8170706915', '331003873947', 'Received from BHARAT TATYASO KUTE - <b>BankRRN: </b>331003873947', 'success'),
(327, '', '2023-11-07', '', '8600190076', 'BHARATPE.8001326591<br>8179730887', 'ONLINE', 'credit', '45', '45', '8179730887', '331170771531', 'Received from KUMAR APPA KHARE - <b>BankRRN: </b>331170771531', 'success'),
(328, '', '2023-11-07', '', '9422541955', 'BHARATPE.8001326591<br>8180575062', 'ONLINE', 'credit', '100', '100', '8180575062', '331179570666', 'Received from MANOJ RAMESH SHINDE - <b>BankRRN: </b>331179570666', 'success'),
(329, '', '2023-11-07 11:04:38', '', '8600190076', '8600190076', 'PAN FIND', 'debit', '22', '23', 'ESKESK78298569', '', '360726596308', 'success'),
(330, '', '2023-11-07 11:04:38', '', '8983884008', '8600190076', 'COMMISSION', 'credit', '15', '73', 'TXNESK78298569', '', 'Rs.15 Commission Credit', 'success'),
(331, '', '2023-11-07 11:04:38', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99999124.5', 'TXNESK78298569', '', 'Rs.10 Coupon Commission Credit', 'success'),
(332, '', '2023-11-07', '', '9096095560', 'BHARATPE.8001326591<br>8184149156', 'ONLINE', 'credit', '50', '78', '8184149156', '331102651519', 'Received from MR YOGESH NAGNATH SATPUTE - <b>BankRRN: </b>331102651519', 'success'),
(333, '', '2023-11-07 03:37:23', '', '9096095560', '9096095560', 'PAN FIND', 'debit', '22', '56', 'ESKESK31871137', '', '887349187960', 'success'),
(334, '', '2023-11-07 03:37:23', '', '8983884008', '9096095560', 'COMMISSION', 'credit', '15', '88', 'TXNESK31871137', '', 'Rs.15 Commission Credit', 'success'),
(335, '', '2023-11-07 03:37:23', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99999134.5', 'TXNESK31871137', '', 'Rs.10 Coupon Commission Credit', 'success'),
(336, '', '2023-11-07', '', '9172855528', 'BHARATPE.8001326591<br>8186280251', 'ONLINE', 'credit', '50', '50', '8186280251', '331110814946', 'Received from SUNIL RAMESH JAMSAND - <b>BankRRN: </b>331110814946', 'success'),
(337, '', '2023-11-07 06:10:20', '', '9172855528', '9172855528', 'PAN FIND', 'debit', '22', '28', 'ESKESK85960785', '', '796195597514', 'success'),
(338, '', '2023-11-07 06:10:20', '', '8983884008', '9172855528', 'COMMISSION', 'credit', '15', '103', 'TXNESK85960785', '', 'Rs.15 Commission Credit', 'success'),
(339, '', '2023-11-07 06:10:20', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99999144.5', 'TXNESK85960785', '', 'Rs.10 Coupon Commission Credit', 'success'),
(340, '', '2023-11-07', '', '8600976910', 'BHARATPE.8001326591<br>8189896945', 'ONLINE', 'credit', '50', '50', '8189896945', '331116447196', 'Received from MR DATTATRAY TUKARAM WAGHMARE2 - <b>BankRRN: </b>331116447196', 'success'),
(341, '', '2023-11-07 09:22:07', '', '8600976910', '8600976910', 'PAN FIND', 'debit', '22', '28', 'ESKESK62034050', '', '939309694382', 'success'),
(342, '', '2023-11-07 09:22:07', '', '8983884008', '8600976910', 'COMMISSION', 'credit', '15', '118', 'TXNESK62034050', '', 'Rs.15 Commission Credit', 'success'),
(343, '', '2023-11-07 09:22:07', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99999154.5', 'TXNESK62034050', '', 'Rs.10 Coupon Commission Credit', 'success'),
(344, '', '2023-11-07', '', 'FIND-ADMIN', '1111111111', 'PORTAL', 'debit', '200', '99998954.5', 'TXN122635', '', 'Transfer to 1111111111 - DEMO', 'success'),
(345, '', '2023-11-07', '', '1111111111', 'FIND-ADMIN', 'PORTAL', 'credit', '200', '202', 'TXN122635', '', 'Received from FIND-ADMIN - MAIN ADMIN', 'success'),
(346, '', '2023-11-07 21:40:06', '', '1111111111', '1111111111', 'NSDLPAN', 'debit', '107', '95', 'EKYC2023110709400619180815', '', 'NSDL EKYC PAN: demo - 9510724254', 'success'),
(347, '', '2023-11-07 21:40:06', '', '1111111111', '1111111111', 'NSDLPAN', 'credit', '107', '202', 'EKYC2023110709400619180815', 'EKYC2023110709400619180815', 'NSDL EKYC PAN REFUND: demo - 9510724254', 'success'),
(348, '', '2023-11-07 21:46:21', '', '1111111111', '1111111111', 'NSDLPAN', 'debit', '107', '95', 'EKYC2023110709462144754647', '', 'NSDL EKYC PAN: demo - 9510724254', 'success'),
(349, '', '2023-11-08 05:57:28', '', '8983884008', '8983884008', 'PAN FIND', 'debit', '30', '88', 'ESKESK5430091', '', '235932195237', 'success'),
(350, '', '2023-11-08 05:57:28', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99998964.5', 'TXNESK5430091', '', 'Rs.10 Commission Credit', 'success'),
(351, '', '2023-11-08', '', '9130336917', 'BHARATPE.8001326591<br>8201171010', 'ONLINE', 'credit', '50', '50', '8201171010', '331204101010', 'Received from MASTER ASHISH DHANAJI DEVKAR - <b>BankRRN: </b>331204101010', 'success'),
(352, '', '2023-11-08 08:03:21', '', '9130336917', '9130336917', 'PAN FIND', 'debit', '35', '15', 'ESKESK114051', '', '264936791971', 'success'),
(353, '', '2023-11-08 08:03:21', '', '8983884008', '9130336917', 'COMMISSION', 'credit', '5', '93', 'TXNESK114051', '', 'Rs.5 Commission Credit', 'success'),
(354, '', '2023-11-08 08:03:21', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99998974.5', 'TXNESK114051', '', 'Rs.10 Coupon Commission Credit', 'success'),
(355, '', '2023-11-08', '', '9130336917', 'BHARATPE.8001326591<br>8201529206', 'ONLINE', 'credit', '20', '35', '8201529206', '331278800608', 'Received from MASTER ASHISH DHANAJI DEVKAR - <b>BankRRN: </b>331278800608', 'success'),
(356, '', '2023-11-08 08:19:09', '', '9130336917', '9130336917', 'PAN FIND', 'debit', '35', '0', 'ESKESK29387718', '', '925421319268', 'success'),
(357, '', '2023-11-08 08:19:09', '', '8983884008', '9130336917', 'COMMISSION', 'credit', '5', '98', 'TXNESK29387718', '', 'Rs.5 Commission Credit', 'success'),
(358, '', '2023-11-08 08:19:09', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99998984.5', 'TXNESK29387718', '', 'Rs.10 Coupon Commission Credit', 'success'),
(359, '', '2023-11-13', '', '8669008964', 'BHARATPE.8001326591<br>8230706349', 'ONLINE', 'credit', '1', '1', '8230706349', '331508482022', 'Received from SHAMRAO BHAGVAT DATIR - <b>BankRRN: </b>331508482022', 'success'),
(360, '', '2023-11-23 11:06:50', '', '9096095560', '9096095560', 'PAN FIND', 'debit', '35', '21', 'ESKESK76963654', '', '782135776734', 'success'),
(361, '', '2023-11-23 11:06:50', '', '8983884008', '9096095560', 'COMMISSION', 'credit', '5', '103', 'TXNESK76963654', '', 'Rs.5 Commission Credit', 'success'),
(362, '', '2023-11-23 11:06:50', '', 'FIND-ADMIN', '8983884008', 'COMMISSION', 'credit', '10', '99998994.5', 'TXNESK76963654', '', 'Rs.10 Coupon Commission Credit', 'success'),
(363, '', '2024-02-10', '', '1111111111', 'FIND-ADMIN', 'NSDLPAN', 'credit', '107', '202', 'EKYC2023110709462144754647', '', 'NSDL EKYC PAN REFUND: Manual Failed', 'success');

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

--
-- Table structure for table `psapassreq`
--

CREATE TABLE `psapassreq` (
  `id` int(11) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `user` varchar(255) NOT NULL,
  `vle_id` varchar(255) NOT NULL,
  `vle_name` varchar(255) NOT NULL,
  `date_time` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `recharges`
--

CREATE TABLE `recharges` (
  `id` int(11) NOT NULL,
  `web_url` varchar(200) NOT NULL,
  `order_id` varchar(100) NOT NULL,
  `number` varchar(12) NOT NULL,
  `operator` varchar(100) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `debit_amt` varchar(100) NOT NULL,
  `balance` varchar(100) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `date_time` varchar(150) NOT NULL,
  `date` date NOT NULL,
  `ref_id` varchar(200) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `recharges`
--

INSERT INTO `recharges` (`id`, `web_url`, `order_id`, `number`, `operator`, `amount`, `debit_amt`, `balance`, `user_id`, `date_time`, `date`, `ref_id`, `remark`, `status`) VALUES
(1, 'pan.pancardpdf.in', '274183', '9773244037', '', '15', '15', '99999242.5', '1', '31-Aug-2023 12:57:08 PM', '2023-08-31', '125708083123', 'Recharge ', 'failed');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `webname` varchar(100) NOT NULL,
  `copyright` varchar(255) NOT NULL,
  `webtag` text NOT NULL,
  `webnote` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `btn_link` longtext NOT NULL,
  `weblogo` longtext NOT NULL,
  `webemail` varchar(50) NOT NULL,
  `webmob1` varchar(12) NOT NULL,
  `webmob2` varchar(12) NOT NULL,
  `address1` text NOT NULL,
  `address2` text NOT NULL,
  `address3` text NOT NULL,
  `timings` varchar(255) NOT NULL,
  `smsapi` longtext NOT NULL,
  `pgapi` longtext NOT NULL,
  `gateway_api` text NOT NULL,
  `retailer` varchar(100) NOT NULL,
  `r_pcoupon` varchar(100) NOT NULL,
  `r_ecoupon` varchar(100) NOT NULL,
  `distributor` varchar(100) NOT NULL,
  `d_pcoupon` varchar(100) NOT NULL,
  `d_ecoupon` varchar(100) NOT NULL,
  `supperdistributor` varchar(100) NOT NULL,
  `sd_pcoupon` varchar(100) NOT NULL,
  `sd_ecoupon` varchar(100) NOT NULL,
  `apiuser` varchar(100) NOT NULL,
  `a_pcoupon` varchar(100) NOT NULL,
  `a_ecoupon` varchar(100) NOT NULL,
  `wluser` varchar(100) NOT NULL,
  `w_pcoupon` varchar(100) NOT NULL,
  `w_ecoupon` varchar(100) NOT NULL,
  `users` varchar(255) NOT NULL,
  `status` varchar(100) NOT NULL,
  `color_json` longtext NOT NULL,
  `weburl` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `webname`, `copyright`, `webtag`, `webnote`, `btn_link`, `weblogo`, `webemail`, `webmob1`, `webmob2`, `address1`, `address2`, `address3`, `timings`, `smsapi`, `pgapi`, `gateway_api`, `retailer`, `r_pcoupon`, `r_ecoupon`, `distributor`, `d_pcoupon`, `d_ecoupon`, `supperdistributor`, `sd_pcoupon`, `sd_ecoupon`, `apiuser`, `a_pcoupon`, `a_ecoupon`, `wluser`, `w_pcoupon`, `w_ecoupon`, `users`, `status`, `color_json`, `weburl`) VALUES
(1, 'SAHARA COMMUNICATION', 'All Rights Reserved 2023 @ saharacommunication', 'SAHARA COMMUNICATION', '<p>PAN FIND ADMIN- RS.2500-------RECHARGE ADMIN-RS.6000---------NSDL KYC NEW PAN ADMIN-RS.3000-------PAN FIND WITH NSDL KYC ADMIN-RS.5000</p>\r\n', '<p class=\"MsoNormal\"><span style=\"font-size: 9pt;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-size: 8pt; font-family: Helvetica, sans-serif; color: black;\">Helpdesk\r\nnumber -9510564221</span></p>', 'data:image/jpg;base64,[encoded data, 70300 characters]', 'saharacommunication49@gmail.com', '9511983178', '9511983178', 'SAHARA COMMUNICATION', 'SAHARA COMMUNICATION', '852131', '10:30AM TO 06:00PM', '{\"api_key\":\"\",\"username\":\"vngLWUQtyZ4RhB7eUA0u5wHhEiD7xQ9l\",\"password\":\"919044455005\",\"senderid\":\"MDSE\",\"route\":\"2\"}', '{\"mid\":\"BHARATPE.8001326591@fbpe\",\"mid_key\":\"34b704-c3c248-1c4677-2f41cb-8dfe42\",\"charges\":\"703\",\"status\":\"PROD\"}', '{\"user_id\":\"\",\"api_key\":\"\",\"psa_url\":\"saharacommunication.online\",\"psa_key\":\"c7ba9d-cb1937-c53d78-32cb0a-9d75c2\"}', '99', '107', '80', '199', '105', '77', '299', '103', '75', '999', '99', '67', 'NA', 'NA', 'NA', '1', 'active', '{\"main_color\":\"#dfdddd\",\"supportive_color\":\"#595959\"}', 'saharacommunication.online');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

