-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 13, 2026 at 09:02 AM
-- Server version: 10.11.16-MariaDB-cll-lve
-- PHP Version: 8.4.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ssteleco_hpay`
--

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

--
-- Table structure for table `balance_log`
--

CREATE TABLE `balance_log` (
  `id` int(11) NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `hotspot_payment_transactions`
--

CREATE TABLE `hotspot_payment_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice` varchar(64) NOT NULL,
  `username` varchar(100) NOT NULL DEFAULT 'hotspot',
  `mac` varchar(80) DEFAULT NULL,
  `ip` varchar(80) DEFAULT NULL,
  `login_url` text DEFAULT NULL,
  `dst` text DEFAULT NULL,
  `package_key` varchar(30) NOT NULL,
  `package_label` varchar(100) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `profile` varchar(80) NOT NULL,
  `days` int(11) NOT NULL DEFAULT 0,
  `status` varchar(30) NOT NULL DEFAULT 'created',
  `payment_id` varchar(160) DEFAULT NULL,
  `trx_id` varchar(120) DEFAULT NULL,
  `token` varchar(80) DEFAULT NULL,
  `raw_response` mediumtext DEFAULT NULL,
  `error_message` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `paid_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotspot_payment_transactions`
--

INSERT INTO `hotspot_payment_transactions` (`id`, `invoice`, `username`, `mac`, `ip`, `login_url`, `dst`, `package_key`, `package_label`, `amount`, `profile`, `days`, `status`, `payment_id`, `trx_id`, `token`, `raw_response`, `error_message`, `created_at`, `paid_at`) VALUES
(17, 'HS2605051303074552', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'paid', 'TR0011xYpMbmE1777986188414', 'DE50TYISUG', 'DE50TYISUG', '{\"paymentID\":\"TR0011xYpMbmE1777986188414\",\"trxID\":\"DE50TYISUG\",\"transactionStatus\":\"Completed\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"paymentExecuteTime\":\"2026-05-05T19:03:35:162 GMT+0600\",\"merchantInvoiceNumber\":\"HS2605051303074552\",\"payerType\":\"Customer\",\"payerReference\":\"hotspot-HS2605051303074552\",\"customerMsisdn\":\"01711901209\",\"payerAccount\":\"01711901209\",\"maxRefundableAmount\":\"14.00\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200}', NULL, '2026-05-05 19:03:07', '2026-05-05 19:03:38'),
(18, 'HS2605051926104592', 'hotspot', 'D8:93:D4:EC:A1:87', '10.5.50.215', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'paid', 'TR0011bCZ4P1N1777987571693', 'DE51TZVYL1', 'DE51TZVYL1', '{\"paymentID\":\"TR0011bCZ4P1N1777987571693\",\"trxID\":\"DE51TZVYL1\",\"transactionStatus\":\"Completed\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"paymentExecuteTime\":\"2026-05-05T19:26:42:155 GMT+0600\",\"merchantInvoiceNumber\":\"HS2605051926104592\",\"payerType\":\"Customer\",\"payerReference\":\"hotspot-HS2605051926104592\",\"customerMsisdn\":\"01711901209\",\"payerAccount\":\"01711901209\",\"maxRefundableAmount\":\"14.00\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200}', NULL, '2026-05-05 19:26:10', '2026-05-05 19:26:44'),
(19, 'HS2605060930273168', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'failed', 'TR0011FJuY4Ir1778038228605', NULL, NULL, '{\"query\":{\"paymentID\":\"TR0011FJuY4Ir1778038228605\",\"status\":\"cancel\",\"signature\":\"284LC90Egi\",\"apiVersion\":\"1.2.0-beta/\"},\"post\":[]}', 'Payment status: cancel', '2026-05-06 09:30:27', NULL),
(20, 'HS2605060930552800', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'failed', 'TR0011Qxdxiq41778038257072', NULL, NULL, '{\"query\":{\"paymentID\":\"TR0011Qxdxiq41778038257072\",\"status\":\"cancel\",\"signature\":\"qkDDlDbsVZ\",\"apiVersion\":\"1.2.0-beta/\"},\"post\":[]}', 'Payment status: cancel', '2026-05-06 09:30:55', NULL),
(21, 'HS2605060941389115', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '3day', '3-Day', 29.00, '3', 3, 'payment_created', 'TR0011pDG2oBA1778038899444', NULL, NULL, '{\"paymentID\":\"TR0011pDG2oBA1778038899444\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011pDG2oBA1778038899444&hash=C5ryu7sPp1ZWVOwrDeuGPLT*Frzi3mRJ-gS2pt!V563BkeQmvBkSKbAzzyFyt_6XQs6iduN.vMb8ag_B8BX(E-uPNPZ_s_oJTOm*1778038899444&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011pDG2oBA1778038899444&status=success&signature=ijYw9nxDTU\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011pDG2oBA1778038899444&status=failure&signature=ijYw9nxDTU\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011pDG2oBA1778038899444&status=cancel&signature=ijYw9nxDTU\",\"amount\":\"29.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T09:41:39:444 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605060941389115\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605060941389115\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"29.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605060941389115\"}}', NULL, '2026-05-06 09:41:38', NULL),
(22, 'HS2605060942043689', 'hotspot', '8C:93:8B:50:EE:4D', '10.5.50.62', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR00118yUZZTT1778038925798', NULL, NULL, '{\"paymentID\":\"TR00118yUZZTT1778038925798\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR00118yUZZTT1778038925798&hash=Bf!wEuwm0wIW270zFbjGv96BPhX!bQxV*Nf0s-49m8PHgdO4-ixVEdIIYv2(wSijxq1*(Fy)zGnOLSdrK)dW)40.H6CRNrQDz6(Z1778038925799&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118yUZZTT1778038925798&status=success&signature=Crw6VNPKjt\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118yUZZTT1778038925798&status=failure&signature=Crw6VNPKjt\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118yUZZTT1778038925798&status=cancel&signature=Crw6VNPKjt\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T09:42:05:798 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605060942043689\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605060942043689\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605060942043689\"}}', NULL, '2026-05-06 09:42:04', NULL),
(23, 'HS2605060942204811', 'hotspot', '8C:93:8B:50:EE:4D', '10.5.50.62', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011VH11a3T1778038941656', NULL, NULL, '{\"paymentID\":\"TR0011VH11a3T1778038941656\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011VH11a3T1778038941656&hash=69)RclGwG!dEGouaV.(akw8fAnT41(UZi.ZJM)SXeDNAgJyJSmfYKtu0rMop1yA7o.M8pbVul9CWSNfq!NdxNMcO6CT8h2_68_I71778038941656&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011VH11a3T1778038941656&status=success&signature=kyFJI1vodT\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011VH11a3T1778038941656&status=failure&signature=kyFJI1vodT\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011VH11a3T1778038941656&status=cancel&signature=kyFJI1vodT\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T09:42:21:656 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605060942204811\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605060942204811\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605060942204811\"}}', NULL, '2026-05-06 09:42:20', NULL),
(24, 'HS2605061045105486', 'hotspot', '8C:6A:3B:07:35:CD', '10.5.50.66', 'http://hotspot.wifiapp.net/login', '', '3day', '3-Day', 29.00, '3', 3, 'payment_created', 'TR0011vUFUVEq1778042711545', NULL, NULL, '{\"paymentID\":\"TR0011vUFUVEq1778042711545\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011vUFUVEq1778042711545&hash=fl7C7)k7zDKl8E7ZUNAGoMqF48lOF!.HQlzPNDj3E*j94Qc7wXaCn!mvSHLfbFbxPaxE)pGTt.Xtl3LLmr_dfj2FqYtXGbKw(Cti1778042711545&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011vUFUVEq1778042711545&status=success&signature=IsaqLxuy35\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011vUFUVEq1778042711545&status=failure&signature=IsaqLxuy35\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011vUFUVEq1778042711545&status=cancel&signature=IsaqLxuy35\",\"amount\":\"29.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T10:45:11:545 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061045105486\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061045105486\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"29.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061045105486\"}}', NULL, '2026-05-06 10:45:10', NULL),
(25, 'HS2605061046408338', 'hotspot', '8C:6A:3B:07:35:CD', '10.5.50.66', 'http://hotspot.wifiapp.net/login', '', '3day', '3-Day', 29.00, '3', 3, 'paid', 'TR0011tlYUsjX1778042801561', 'DE66UM3SDU', 'DE66UM3SDU', '{\"paymentID\":\"TR0011tlYUsjX1778042801561\",\"trxID\":\"DE66UM3SDU\",\"transactionStatus\":\"Completed\",\"amount\":\"29.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"paymentExecuteTime\":\"2026-05-06T10:47:08:617 GMT+0600\",\"merchantInvoiceNumber\":\"HS2605061046408338\",\"payerType\":\"Customer\",\"payerReference\":\"hotspot-HS2605061046408338\",\"customerMsisdn\":\"01715850157\",\"payerAccount\":\"01715850157\",\"maxRefundableAmount\":\"29.00\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200}', NULL, '2026-05-06 10:46:40', '2026-05-06 10:47:10'),
(26, 'HS2605061303174777', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'paid', 'TR0011uzWe7A81778050998362', 'DE66US2VYG', 'DE66US2VYG', '{\"paymentID\":\"TR0011uzWe7A81778050998362\",\"trxID\":\"DE66US2VYG\",\"transactionStatus\":\"Completed\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"paymentExecuteTime\":\"2026-05-06T13:03:42:393 GMT+0600\",\"merchantInvoiceNumber\":\"HS2605061303174777\",\"payerType\":\"Customer\",\"payerReference\":\"hotspot-HS2605061303174777\",\"customerMsisdn\":\"01711901209\",\"payerAccount\":\"01711901209\",\"maxRefundableAmount\":\"14.00\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200}', NULL, '2026-05-06 13:03:17', '2026-05-06 13:03:45'),
(27, 'HS2605061651168637', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011tGvKHxl1778064677775', NULL, NULL, '{\"paymentID\":\"TR0011tGvKHxl1778064677775\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011tGvKHxl1778064677775&hash=wnzN5rQB4LC9kp!g_vowfI91nJHyRjjiE*XWDVc3SHrqRmmlF*p1T30LSSqxgo8mprgfj3KY0eekz_6bBJ0YVZjtp4UI8-qiE8_D1778064677775&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011tGvKHxl1778064677775&status=success&signature=GLmBMqZbeg\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011tGvKHxl1778064677775&status=failure&signature=GLmBMqZbeg\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011tGvKHxl1778064677775&status=cancel&signature=GLmBMqZbeg\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T16:51:17:775 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061651168637\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061651168637\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061651168637\"}}', NULL, '2026-05-06 16:51:16', NULL),
(28, 'HS2605061656204475', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011dM3cQnZ1778064981047', NULL, NULL, '{\"paymentID\":\"TR0011dM3cQnZ1778064981047\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011dM3cQnZ1778064981047&hash=44vmlUnMrozR*MdDcH1o_DejRn*aXbLxG7*1z.sA*A0Fy4sVh.RQ!TaETrgzSmVrUnV(f8mDZwI)z6UJAqW_K54swYBwaLD)nj!T1778064981047&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011dM3cQnZ1778064981047&status=success&signature=G4N99Hyz6y\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011dM3cQnZ1778064981047&status=failure&signature=G4N99Hyz6y\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011dM3cQnZ1778064981047&status=cancel&signature=G4N99Hyz6y\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T16:56:21:047 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061656204475\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061656204475\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061656204475\"}}', NULL, '2026-05-06 16:56:20', NULL),
(29, 'HS2605061657505486', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'paid', 'TR0011EPp0Rtv1778065071330', 'DE65V03ZZ1', 'DE65V03ZZ1', '{\"paymentID\":\"TR0011EPp0Rtv1778065071330\",\"trxID\":\"DE65V03ZZ1\",\"transactionStatus\":\"Completed\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"paymentExecuteTime\":\"2026-05-06T16:58:22:793 GMT+0600\",\"merchantInvoiceNumber\":\"HS2605061657505486\",\"payerType\":\"Customer\",\"payerReference\":\"hotspot-HS2605061657505486\",\"customerMsisdn\":\"01711901209\",\"payerAccount\":\"01711901209\",\"maxRefundableAmount\":\"14.00\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200}', NULL, '2026-05-06 16:57:50', '2026-05-06 16:58:24'),
(30, 'HS2605061712452797', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.34', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'paid', 'TR0011xOxYzPY1778065966798', 'DE69V0NYHJ', 'DE69V0NYHJ', '{\"paymentID\":\"TR0011xOxYzPY1778065966798\",\"trxID\":\"DE69V0NYHJ\",\"transactionStatus\":\"Completed\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"paymentExecuteTime\":\"2026-05-06T17:13:19:661 GMT+0600\",\"merchantInvoiceNumber\":\"HS2605061712452797\",\"payerType\":\"Customer\",\"payerReference\":\"hotspot-HS2605061712452797\",\"customerMsisdn\":\"01711901209\",\"payerAccount\":\"01711901209\",\"maxRefundableAmount\":\"14.00\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200}', NULL, '2026-05-06 17:12:45', '2026-05-06 17:13:21'),
(31, 'HS2605061825568455', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:56', NULL),
(32, 'HS2605061825569327', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:56', NULL),
(33, 'HS2605061825568206', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:56', NULL),
(34, 'HS2605061825569089', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:56', NULL),
(35, 'HS2605061825574161', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:57', NULL),
(36, 'HS2605061825579401', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:57', NULL),
(37, 'HS2605061825579251', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:57', NULL),
(38, 'HS2605061825576670', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:57', NULL),
(39, 'HS2605061825571263', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:57', NULL),
(40, 'HS2605061825589507', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'created', NULL, NULL, NULL, NULL, NULL, '2026-05-06 18:25:58', NULL),
(41, 'HS2605061825582256', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011rU6pSdL1778070359058', NULL, NULL, '{\"paymentID\":\"TR0011rU6pSdL1778070359058\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011rU6pSdL1778070359058&hash=22moC_crFBVz41XD3Xf47JPV4bD4PQyPfPQ3(WlP(OykcUqKv9c)XDP8*5)8b0amxS1kWguMwJr3*!2pqQaw_fxbQoccC)HLj5Vt1778070359058&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011rU6pSdL1778070359058&status=success&signature=6y51BTADtp\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011rU6pSdL1778070359058&status=failure&signature=6y51BTADtp\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011rU6pSdL1778070359058&status=cancel&signature=6y51BTADtp\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T18:25:59:058 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061825582256\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061825582256\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061825582256\"}}', NULL, '2026-05-06 18:25:58', NULL),
(42, 'HS2605061826009074', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011RiKN97T1778070361783', NULL, NULL, '{\"paymentID\":\"TR0011RiKN97T1778070361783\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011RiKN97T1778070361783&hash=I)0eeUbIVxMUY9fDdTXVpk53Go1b3YpgT2_O58FWE5CYnvk!Pcf13XFr894*eMZDPU61l7rNAfa9hj14cDMB5i-CDDm(uxE1fM071778070361783&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011RiKN97T1778070361783&status=success&signature=aux37uPYcv\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011RiKN97T1778070361783&status=failure&signature=aux37uPYcv\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011RiKN97T1778070361783&status=cancel&signature=aux37uPYcv\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T18:26:01:783 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061826009074\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061826009074\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061826009074\"}}', NULL, '2026-05-06 18:26:00', NULL),
(43, 'HS2605061826025457', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR00117W32ZgB1778070364106', NULL, NULL, '{\"paymentID\":\"TR00117W32ZgB1778070364106\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR00117W32ZgB1778070364106&hash=ZweL*F4KLGfiUqMsinsjaqjVMzROO7M*JhD13**QSwsF66CK)oRhOkhE7.E8Kew69YBORnoNsI71cl_1vR(eMUd.DK7CzS*50aBR1778070364106&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117W32ZgB1778070364106&status=success&signature=ncBfgNU33f\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117W32ZgB1778070364106&status=failure&signature=ncBfgNU33f\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117W32ZgB1778070364106&status=cancel&signature=ncBfgNU33f\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T18:26:04:106 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061826025457\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061826025457\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061826025457\"}}', NULL, '2026-05-06 18:26:02', NULL),
(44, 'HS2605061826048751', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011wHQuy2R1778070365032', NULL, NULL, '{\"paymentID\":\"TR0011wHQuy2R1778070365032\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011wHQuy2R1778070365032&hash=1RZ(xXA!lZbV7d4EFIjzAq8(u!UEK5pfOZhqClJfcxYFPdXfvl4kpdyqX9sBEuXRv2IUxGID6Gz_Q5qEq3rX)mEpboc)KlUwV)4W1778070365032&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011wHQuy2R1778070365032&status=success&signature=9VVLAjRZIS\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011wHQuy2R1778070365032&status=failure&signature=9VVLAjRZIS\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011wHQuy2R1778070365032&status=cancel&signature=9VVLAjRZIS\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T18:26:05:032 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061826048751\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061826048751\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061826048751\"}}', NULL, '2026-05-06 18:26:04', NULL),
(45, 'HS2605061830215492', 'hotspot', 'BA:4A:0D:46:6E:BB', '10.5.50.27', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011pVKjejK1778070621991', NULL, NULL, '{\"paymentID\":\"TR0011pVKjejK1778070621991\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011pVKjejK1778070621991&hash=V6mADlBMu_2OD-j0i(a5pMrBzB.xaw4JcTH!I4O5ybr9INS4OGq86MU!K5EfHzBgu69mYM8)pi)dKNCZyyJCADpBZtkjVKVFxA_l1778070621991&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011pVKjejK1778070621991&status=success&signature=PXp50JJcSu\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011pVKjejK1778070621991&status=failure&signature=PXp50JJcSu\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011pVKjejK1778070621991&status=cancel&signature=PXp50JJcSu\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T18:30:21:991 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061830215492\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061830215492\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061830215492\"}}', NULL, '2026-05-06 18:30:21', NULL),
(46, 'HS2605061934068682', 'hotspot', '14:96:E5:74:14:5D', '10.5.50.81', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR00112wv0k251778074447532', NULL, NULL, '{\"paymentID\":\"TR00112wv0k251778074447532\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR00112wv0k251778074447532&hash=f)l9OEpoaUpir.B55qjO.deqEvw)9r*FeuMZpjSPTVAFnnvd4bsobNA7!IWgD7f0.slpZqoe_(c2ewM875XhO*gAbU9T-0AyasDG1778074447532&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00112wv0k251778074447532&status=success&signature=HN5HJu5qco\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00112wv0k251778074447532&status=failure&signature=HN5HJu5qco\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00112wv0k251778074447532&status=cancel&signature=HN5HJu5qco\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-06T19:34:07:532 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605061934068682\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605061934068682\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605061934068682\"}}', NULL, '2026-05-06 19:34:06', NULL),
(47, 'HS2605070604383308', 'hotspot', '6A:83:65:B5:DE:C1', '10.5.50.39', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR00117rpW0fN1778112279550', NULL, NULL, '{\"paymentID\":\"TR00117rpW0fN1778112279550\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR00117rpW0fN1778112279550&hash=a-1qH6uLGss6DF)ElXQw.aicf)gO-E.ux8CWDjUa4Lir2eJeH5GXGoLAY6hClI)!mzgNxQAH0caKmxb.hwAp868Jk)yhIzKgt7XY1778112279550&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117rpW0fN1778112279550&status=success&signature=UZsxgIeA8r\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117rpW0fN1778112279550&status=failure&signature=UZsxgIeA8r\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117rpW0fN1778112279550&status=cancel&signature=UZsxgIeA8r\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-07T06:04:39:550 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605070604383308\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605070604383308\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605070604383308\"}}', NULL, '2026-05-07 06:04:38', NULL),
(48, 'HS2605071151465610', 'hotspot', 'E2:DC:71:2B:E3:FF', '10.5.50.98', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'paid', 'TR0011zbUKiFd1778133107524', 'DE76VUV7CU', 'DE76VUV7CU', '{\"paymentID\":\"TR0011zbUKiFd1778133107524\",\"trxID\":\"DE76VUV7CU\",\"transactionStatus\":\"Completed\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"paymentExecuteTime\":\"2026-05-07T11:52:15:873 GMT+0600\",\"merchantInvoiceNumber\":\"HS2605071151465610\",\"payerType\":\"Customer\",\"payerReference\":\"hotspot-HS2605071151465610\",\"customerMsisdn\":\"01711901209\",\"payerAccount\":\"01711901209\",\"maxRefundableAmount\":\"14.00\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200}', NULL, '2026-05-07 11:51:46', '2026-05-07 11:52:17'),
(49, 'HS2605071912223911', 'hotspot', '66:27:70:3C:3D:54', '10.5.50.108', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR00117KY1H6n1778159543539', NULL, NULL, '{\"paymentID\":\"TR00117KY1H6n1778159543539\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR00117KY1H6n1778159543539&hash=dJS9KOclWJw_Mf2w*Nly3MBEAgOjxfoKbgOMhL8GV(!IFDPG76ZVkqvEM6zUr!hBjXdgKIVp1yYCxmuHetPektJ6RPA-hZ*EHNcE1778159543539&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117KY1H6n1778159543539&status=success&signature=6V2Ohq404M\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117KY1H6n1778159543539&status=failure&signature=6V2Ohq404M\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00117KY1H6n1778159543539&status=cancel&signature=6V2Ohq404M\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-07T19:12:23:539 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605071912223911\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605071912223911\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605071912223911\"}}', NULL, '2026-05-07 19:12:22', NULL),
(50, 'HS2605071912562013', 'hotspot', '66:27:70:3C:3D:54', '10.5.50.108', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011Ge54H941778159577251', NULL, NULL, '{\"paymentID\":\"TR0011Ge54H941778159577251\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011Ge54H941778159577251&hash=JPdfZ4z!aLFuxFBvhV6vydLABSTROYPmmim*W4UxclzhF7_cSOlQDnYOhMms!4Ei*X.9GbdAg4pZx2gYXyfnM)KF*ybmyPrlvlPO1778159577251&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011Ge54H941778159577251&status=success&signature=kOyAygXUaW\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011Ge54H941778159577251&status=failure&signature=kOyAygXUaW\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011Ge54H941778159577251&status=cancel&signature=kOyAygXUaW\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-07T19:12:57:251 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605071912562013\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605071912562013\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605071912562013\"}}', NULL, '2026-05-07 19:12:56', NULL),
(51, 'HS2605071954399304', 'hotspot', '66:27:70:3C:3D:54', '10.5.50.108', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR00118XnCQxq1778162080267', NULL, NULL, '{\"paymentID\":\"TR00118XnCQxq1778162080267\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR00118XnCQxq1778162080267&hash=pYI1wvzbTmE.UE6NEwRpr-6mRE-z)Bi(BFUG02xD01rVKxk75LBeJV2HpcvBx-2XNuGoCiUBmXLRSgnoXLqDqvbQje(XahS7chZz1778162080267&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118XnCQxq1778162080267&status=success&signature=K6ZXnqbLyg\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118XnCQxq1778162080267&status=failure&signature=K6ZXnqbLyg\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118XnCQxq1778162080267&status=cancel&signature=K6ZXnqbLyg\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-07T19:54:40:267 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605071954399304\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605071954399304\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605071954399304\"}}', NULL, '2026-05-07 19:54:39', NULL),
(52, 'HS2605072113378159', 'hotspot', '16:6B:A7:8E:A1:E2', '10.5.50.122', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011KRQ6itm1778166818353', NULL, NULL, '{\"paymentID\":\"TR0011KRQ6itm1778166818353\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011KRQ6itm1778166818353&hash=nKq498H80gI0ckSCbXyF3(KDnXpv-0l_MP-42OwqV7I7aAIBG)7B9Uy!-ocd7pXri7BdxGx(JsUlTjuaQidp!L9COuD-tHCg22k81778166818353&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011KRQ6itm1778166818353&status=success&signature=QeTHcQ4niD\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011KRQ6itm1778166818353&status=failure&signature=QeTHcQ4niD\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011KRQ6itm1778166818353&status=cancel&signature=QeTHcQ4niD\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-07T21:13:38:353 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605072113378159\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605072113378159\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605072113378159\"}}', NULL, '2026-05-07 21:13:37', NULL),
(53, 'HS2605091954486111', 'hotspot', '2A:6C:C2:A9:2D:47', '10.5.50.46', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011WrR3m9K1778334889623', NULL, NULL, '{\"paymentID\":\"TR0011WrR3m9K1778334889623\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011WrR3m9K1778334889623&hash=qfeE0QmyKBkLuTgWoOwKHF4pO-ye3q.fxpBbR8Wj)0r.AHmHWqabOQufTAyhbwuh9b0jVqqEx!Z2zFaMSGe9cnrZku._Ol)lA7mk1778334889623&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011WrR3m9K1778334889623&status=success&signature=jXy1iD9vEu\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011WrR3m9K1778334889623&status=failure&signature=jXy1iD9vEu\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011WrR3m9K1778334889623&status=cancel&signature=jXy1iD9vEu\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-09T19:54:49:623 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605091954486111\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605091954486111\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605091954486111\"}}', NULL, '2026-05-09 19:54:48', NULL),
(54, 'HS2605100824595551', 'hotspot', '6A:81:82:4B:C7:E7', '10.5.50.25', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR00118L9qGyJ1778379900049', NULL, NULL, '{\"paymentID\":\"TR00118L9qGyJ1778379900049\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR00118L9qGyJ1778379900049&hash=)Mm75Y)CCFbCF5gr.YM6-Iig0ln164sRHrnlwHav7(4m1jdOZkiTkI-jTT)iMo4H(y0M9EObnXAa.quFfPVh-W1xjxAPlWMMUPxu1778379900050&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118L9qGyJ1778379900049&status=success&signature=OltlT1kZnb\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118L9qGyJ1778379900049&status=failure&signature=OltlT1kZnb\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR00118L9qGyJ1778379900049&status=cancel&signature=OltlT1kZnb\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-10T08:25:00:050 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605100824595551\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605100824595551\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605100824595551\"}}', NULL, '2026-05-10 08:24:59', NULL),
(55, 'HS2605101733135937', 'hotspot', '62:D8:4D:34:50:70', '10.5.50.106', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011OzmAfw71778412794440', NULL, NULL, '{\"paymentID\":\"TR0011OzmAfw71778412794440\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011OzmAfw71778412794440&hash=tzI1*Wr0zw-s1wnc9CqC3RoL8CeIjBY4Nk-bo(MQWqb8y!TzpyIW.zOmHnyc7_!cxbw.qU7YL-n21(bAJuDLGooQqM4VSgal.PCj1778412794440&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011OzmAfw71778412794440&status=success&signature=9qtXlEJhRQ\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011OzmAfw71778412794440&status=failure&signature=9qtXlEJhRQ\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011OzmAfw71778412794440&status=cancel&signature=9qtXlEJhRQ\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-10T17:33:14:440 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605101733135937\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605101733135937\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605101733135937\"}}', NULL, '2026-05-10 17:33:13', NULL),
(56, 'HS2605121722169576', 'hotspot', '2A:6C:C2:A9:2D:47', '10.5.50.46', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011ZksW7EE1778584937738', NULL, NULL, '{\"paymentID\":\"TR0011ZksW7EE1778584937738\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011ZksW7EE1778584937738&hash=-l7zwmtCCHbdVVzxTtH3HW-4h.t!tfPDkm9SJ5U5mmD34KeWs(e9TLjkNz_h5Bziy2L-hFcX-VsCAcj*n)87cq(A0k-iP3vKE8w01778584937738&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011ZksW7EE1778584937738&status=success&signature=hzCvn8Fvvx\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011ZksW7EE1778584937738&status=failure&signature=hzCvn8Fvvx\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011ZksW7EE1778584937738&status=cancel&signature=hzCvn8Fvvx\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-12T17:22:17:738 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605121722169576\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605121722169576\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605121722169576\"}}', NULL, '2026-05-12 17:22:16', NULL),
(57, 'HS2605121933509284', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.134', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011R39xsyV1778592831554', NULL, NULL, '{\"paymentID\":\"TR0011R39xsyV1778592831554\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011R39xsyV1778592831554&hash=CbhF9zeynuvLb1.IOSos(vQ*fVFszZ-OxuDPzXJ!xZFw0SM-epJtTp.C.sfiV3g2jO9K1b*j)0hKu-!m3NQMxS0qaosWzswX-xVm1778592831554&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011R39xsyV1778592831554&status=success&signature=PZYn7X8jxc\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011R39xsyV1778592831554&status=failure&signature=PZYn7X8jxc\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011R39xsyV1778592831554&status=cancel&signature=PZYn7X8jxc\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-12T19:33:51:554 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605121933509284\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605121933509284\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605121933509284\"}}', NULL, '2026-05-12 19:33:50', NULL),
(58, 'HS2605121934497458', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.134', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011MtWYdR91778592890128', NULL, NULL, '{\"paymentID\":\"TR0011MtWYdR91778592890128\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011MtWYdR91778592890128&hash=9jsrl1DwnYRcbk0y(k9NN(rNnp-fBRJD5z_y*K5tzH(2-N_Khay4yTBaTC(H2gVtwI4KUQaNdvL!XRSGYo3_Tcu-dIBomGsH)Z7Q1778592890128&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011MtWYdR91778592890128&status=success&signature=FNp7mvlPSL\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011MtWYdR91778592890128&status=failure&signature=FNp7mvlPSL\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011MtWYdR91778592890128&status=cancel&signature=FNp7mvlPSL\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-12T19:34:50:128 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605121934497458\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605121934497458\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605121934497458\"}}', NULL, '2026-05-12 19:34:49', NULL),
(59, 'HS2605121936213905', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.134', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'failed', 'TR0011NjwpIG91778592982650', NULL, NULL, '{\"query\":{\"paymentID\":\"TR0011NjwpIG91778592982650\",\"status\":\"cancel\",\"signature\":\"3c5kjdZ286\",\"apiVersion\":\"1.2.0-beta/\"},\"post\":[]}', 'Payment status: cancel', '2026-05-12 19:36:21', NULL),
(60, 'HS2605121938069185', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.134', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'paid', 'TR0011ldxd3TX1778593087831', 'DEC45FB61G', 'DEC45FB61G', '{\"paymentID\":\"TR0011ldxd3TX1778593087831\",\"trxID\":\"DEC45FB61G\",\"transactionStatus\":\"Completed\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"paymentExecuteTime\":\"2026-05-12T19:39:27:443 GMT+0600\",\"merchantInvoiceNumber\":\"HS2605121938069185\",\"payerType\":\"Customer\",\"payerReference\":\"hotspot-HS2605121938069185\",\"customerMsisdn\":\"01711901209\",\"payerAccount\":\"01711901209\",\"maxRefundableAmount\":\"14.00\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200}', NULL, '2026-05-12 19:38:06', '2026-05-12 19:39:28'),
(61, 'HS2605122016457874', 'hotspot', '8C:93:8B:50:EE:4D', '10.5.50.137', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011Ggku2Zf1778595407053', NULL, NULL, '{\"paymentID\":\"TR0011Ggku2Zf1778595407053\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011Ggku2Zf1778595407053&hash=(CZhcDvAIl4zYrOUkbWmCFKIocwqe1jraokBgn5pljMG9qCfvDJKRrW6v0dtBRZUdzo!bmz_TQr8O!STBn)fE(hqozDAbhAyh7GO1778595407053&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011Ggku2Zf1778595407053&status=success&signature=FfIFCwgL5r\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011Ggku2Zf1778595407053&status=failure&signature=FfIFCwgL5r\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011Ggku2Zf1778595407053&status=cancel&signature=FfIFCwgL5r\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-12T20:16:47:053 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605122016457874\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605122016457874\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605122016457874\"}}', NULL, '2026-05-12 20:16:45', NULL),
(62, 'HS2605130851068730', 'hotspot', '42:91:4B:DD:B5:88', '10.5.50.134', 'http://hotspot.wifiapp.net/login', '', '1day', '1-Day', 14.00, '1', 1, 'payment_created', 'TR0011VL0H4py1778640667724', NULL, NULL, '{\"paymentID\":\"TR0011VL0H4py1778640667724\",\"bkashURL\":\"https://payment.bkash.com/?paymentId=TR0011VL0H4py1778640667724&hash=T!23O-1GjPdry!N3kgg_hjoXjfaTLZ1EuxQEDF4(wWrVU4ofwRE7oRJH6bt*d4GYllGgRQ-9jmtNUzvCGORBVciO*mVQsnl8PcI91778640667725&mode=0011&apiVersion=v1.2.0-beta/\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"successCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011VL0H4py1778640667724&status=success&signature=mdXJhF2ZQF\",\"failureCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011VL0H4py1778640667724&status=failure&signature=mdXJhF2ZQF\",\"cancelledCallbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php?paymentID=TR0011VL0H4py1778640667724&status=cancel&signature=mdXJhF2ZQF\",\"amount\":\"14.00\",\"intent\":\"sale\",\"currency\":\"BDT\",\"paymentCreateTime\":\"2026-05-13T08:51:07:724 GMT+0600\",\"transactionStatus\":\"Initiated\",\"merchantInvoiceNumber\":\"HS2605130851068730\",\"statusCode\":\"0000\",\"statusMessage\":\"Successful\",\"_http_code\":200,\"_payload\":{\"mode\":\"0011\",\"payerReference\":\"hotspot-HS2605130851068730\",\"callbackURL\":\"https://hotspot.wifiapp.net/hotspot_gateway/callback.php\",\"amount\":\"14.00\",\"currency\":\"BDT\",\"intent\":\"sale\",\"merchantInvoiceNumber\":\"HS2605130851068730\"}}', NULL, '2026-05-13 08:51:06', NULL);

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `method` varchar(20) NOT NULL,
  `payment_id` varchar(100) NOT NULL,
  `trx_id` varchar(100) DEFAULT NULL,
  `status` varchar(20) DEFAULT 'pending',
  `raw_data` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `balance` decimal(10,2) DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `hotspot_payment_transactions`
--
ALTER TABLE `hotspot_payment_transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_invoice` (`invoice`),
  ADD UNIQUE KEY `uniq_payment_id` (`payment_id`),
  ADD UNIQUE KEY `uniq_trx_id` (`trx_id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_mac` (`mac`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payment_id_unique` (`payment_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
