-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 27 Apr 2026 pada 12.20
-- Versi server: 10.6.24-MariaDB-cll-lve-log
-- Versi PHP: 8.4.20

START TRANSACTION;



--
-- Database: `tuofdccv_qris_statis`
--

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

--
-- Struktur dari tabel `transaksi_tenant`
--

CREATE TABLE `transaksi_tenant` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `kode_agen` varchar(50) DEFAULT NULL,
  `tipe` enum('masuk','keluar') NOT NULL,
  `is_notified` tinyint(1) NOT NULL DEFAULT 0,
  `lock_callback` tinyint(1) NOT NULL DEFAULT 0,
  `is_log` tinyint(1) NOT NULL DEFAULT 0,
  `notif_lock` tinyint(1) NOT NULL DEFAULT 0,
  `is_updated` tinyint(1) NOT NULL DEFAULT 0,
  `is_reffund` tinyint(1) NOT NULL DEFAULT 0,
  `nominal` double NOT NULL,
  `is_settel` tinyint(1) NOT NULL DEFAULT 0,
  `admin` int(11) NOT NULL DEFAULT 0,
  `markup` int(11) NOT NULL DEFAULT 0,
  `markup_server` int(11) NOT NULL DEFAULT 0,
  `keterangan` text DEFAULT NULL,
  `api_nama_user` varchar(150) DEFAULT NULL,
  `api_email_user` varchar(150) DEFAULT NULL,
  `api_id_perubahan` varchar(60) DEFAULT NULL,
  `api_userid` varchar(60) DEFAULT NULL,
  `spl` varchar(100) DEFAULT NULL,
  `saldo_sebelum` double DEFAULT NULL,
  `saldo_sesudah` double DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `partner_reff` varchar(100) DEFAULT NULL,
  `rrn` varchar(100) DEFAULT NULL,
  `accountnumber` varchar(50) DEFAULT NULL,
  `serialnumber` varchar(100) DEFAULT NULL,
  `amount` int(11) NOT NULL,
  `payment_reff` varchar(100) DEFAULT NULL,
  `accountname` varchar(100) DEFAULT NULL,
  `customer_data` text DEFAULT NULL,
  `bankname` varchar(50) DEFAULT NULL,
  `bankcode` varchar(20) DEFAULT NULL,
  `respon_desc` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `meter_awal` varchar(20) DEFAULT NULL,
  `meter_akhir` varchar(20) DEFAULT NULL,
  `is_sending` varchar(10) DEFAULT '0',
  `callback_response` text DEFAULT NULL,
  `callback_at` datetime DEFAULT NULL,
  `sistem` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `transaksi_tenant`
--

INSERT INTO `transaksi_tenant` (`id`, `user_id`, `kode_agen`, `tipe`, `is_notified`, `lock_callback`, `is_log`, `notif_lock`, `is_updated`, `is_reffund`, `nominal`, `is_settel`, `admin`, `markup`, `markup_server`, `keterangan`, `api_nama_user`, `api_email_user`, `api_id_perubahan`, `api_userid`, `spl`, `saldo_sebelum`, `saldo_sesudah`, `created_at`, `partner_reff`, `rrn`, `accountnumber`, `serialnumber`, `amount`, `payment_reff`, `accountname`, `customer_data`, `bankname`, `bankcode`, `respon_desc`, `type`, `meter_awal`, `meter_akhir`, `is_sending`, `callback_response`, `callback_at`, `sistem`) VALUES
(132478, 138176, 'Topup138176', 'masuk', 0, 0, 1, 0, 1, 0, 75352, 1, 0, 0, 0, 'Deposit Transfer Bank Ewallet Dana', NULL, NULL, NULL, NULL, NULL, 7269, 82621, '2026-03-27 13:01:47', '36875493360', '77669912724', '082378202807', '7535220260327130147', 75000, '38254954749', 'setiawanmbeny', NULL, 'Ewallet Dana', 'deposit saldo', 'SUCCESS', NULL, NULL, NULL, '0', NULL, NULL, NULL),
(132479, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 4967, 1, 35, 3, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 34772, 39739, '2026-03-27 13:11:05', 'EXT177459186490321205950732', '001084387705', 'PDN0000007545', 'REF177459186490321105160300', 5000, '001084387705', 'ZARFAN STORE', 'GOPAY', 'GOPAY', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132480, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 4967, 1, 35, 3, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 39739, 44706, '2026-03-27 13:22:46', 'EXT177459256581079300850053', '1mzml4h61791', 'PDN0000007545', 'REF177459256581079208440329', 5000, '1mzml4h61791', 'ZARFAN STORE', 'TO****************', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132481, 138044, 'WLsP', 'keluar', 2, 1, 1, 0, 1, 0, 2355, 0, 55, 350, 0, 'Promo 90 Menit All Operator 1 Hari', 'Deni', 'nesiaditz122@gmail.com', '57515070', NULL, 'ORDER_KUOTA', 2577852, 2575497, '2026-03-27 13:59:47', 'TRX20260327135945322', '138044-20260327140023-2355', '081374365225', '04042000001596873067', 2650, 'T#1139098737', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'SSC9', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132482, 138044, 'WHOo', 'keluar', 2, 1, 1, 0, 1, 0, 8400, 0, 50, 350, 0, 'Mini Axis 5GB + Bonus Aigo 2 Hari', 'initans', 'sixseventans@gmail.com', '57518319', NULL, 'ORDER_KUOTA', 2575497, 2567097, '2026-03-27 14:30:48', 'TRX20260327143046215', '138044-20260327143054-8400', '083832122285', 'AIGO Mini 5GB Lokal 2hr (OUTEMBAK241178260327143050069)', 8700, 'T#1139137942', 'MDP-H2H', 'API- Axis', 'Axis', 'AXM5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132483, 138093, 'WEHI', 'keluar', 2, 1, 1, 0, 1, 0, 36169, 0, 65, 300, 0, 'Cetak Voucher Aigo Axis', 'HangLengkir', 'jayabersamatcc@gmail.com', '57522143', NULL, 'ORDER_KUOTA', 673997, 637828, '2026-03-27 15:05:38', 'TRX20260327150538001', '138093-20260327150612-36169', '1161430000262000', 'ISIU165357260327150606653\",\"description\":\"AIGO Bronet 10GB 28hr\"', 36404, 'T#1139183616', 'MDP-H2H', 'API- AXIS', 'Axis', 'TVKJ2', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132484, 138052, 'Ur4N', 'keluar', 2, 1, 1, 0, 1, 0, 1113, 0, 75, 185, 0, 'Dana 1.000', 'ahsans', 'brothersdigitalofficial@gmail.com', '57524839', NULL, 'ORDER_KUOTA', 807510, 806397, '2026-03-27 15:34:22', 'TRX20260327153421338', '138052-20260327153423-1113', '085798125032', 'DNID ASEX HASXX SADXXXX/1000/2026032710121481030100166009292325687', 1223, 'T#1139217713', 'MDP-H2H', 'API- dana', 'dana', 'D1', 'SUKSES', 'PRABAYAR', NULL, NULL, 'failed', 'HTTP Code: 404', '2026-03-27 15:35:17', 'bukaolshop'),
(132485, 138135, 'SDGL', 'masuk', 0, 0, 1, 0, 1, 0, 9935, 1, 65, 0, 0, 'PEMBAYARAN VIA QRIS', 'PATEMI', 'akunkususkontakwa19@gmail.com', 'ID1025466105885', NULL, NULL, 0, 9935, '2026-03-27 15:34:31', 'EXT177460047042486909680798', '1mzq95o81218', 'PDN0000007354', 'REF177460047042486706510654', 10000, '1mzq95o81218', 'NikoPay', 'RA***********************', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132486, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 993, 1, 10, 4, 0, 'PEMBAYARAN VIA QRIS', 'Sugi Antoro', 'mdp@mdppulsa.my.id', 'ID1025463827481', NULL, NULL, 0, 993, '2026-03-27 15:38:11', 'EXT177460069011689400210737', '018515228936', 'PDN0000006217', 'REF177460069011689309630596', 1000, '018515228936', 'Toko pulsa', 'SU*********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132487, 138176, 'V4Ho', 'keluar', 2, 1, 1, 0, 1, 0, 51845, 0, 75, 200, 0, 'TOKEN PLN H2H 50.000', 'Anda Buah', 'andakeluarga1@gmail.com', '57525160', NULL, 'ORDER_KUOTA', 82621, 30776, '2026-03-27 15:39:14', 'TRX20260327153913580', '138176-20260327153914-51845', '14426978939', '6994-5587-6059-0555-4358/DALIMAN D/R2/4400VA/27.5 KWH', 51970, 'T#1139223517', 'MDP-H2H', 'API- TOKEN', 'TOKEN', 'PLNB50A', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132488, 138135, 'SDGL', 'keluar', 2, 1, 1, 0, 1, 0, 10113, 0, 75, 334, 0, 'Dana 10.000', 'NikoPay Indonesia', 'akunkususkontakwa19@gmail.com', '57531765', NULL, 'ORDER_KUOTA', 10602, 489, '2026-03-27 16:54:23', 'TRX20260327165422535', '138135-20260327165424-10113', '083125668657', 'DNID PATXXX/10000/2026032710121481030100166590992526246', 10372, 'T#1139323621', 'MDP-H2H', 'API- dana', 'dana', 'D10', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132489, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 5299, 0, 75, 300, 0, 'Telkomsel 5.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57533329', NULL, 'ORDER_KUOTA', 637828, 632529, '2026-03-27 17:11:47', 'TRX20260327171145159', '138093-20260327171153-5299', '081277529090', '04103800001458044368', 5524, 'T#1139348539', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S5', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132490, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 8683, 0, 75, 350, 0, '70 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57534583', NULL, 'ORDER_KUOTA', 2567097, 2558414, '2026-03-27 17:24:07', 'TRX20260327172406594', '138044-20260327172428-8683', '9622754347', '@opangufenk . Refid: K77747385', 8958, 'T#1139366807', 'MDP-H2H', 'API -  gff', 'gff', 'FF70', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132491, 138172, 'W61S', 'masuk', 0, 0, 1, 0, 1, 0, 197338, 1, 1291, 0, 75, 'DEPOSIT USER VIA QRIS', 'Fadli Foocie', 'ffoocie@gmail.com', '57535059', 'W61S', NULL, 0, 197338, '2026-03-27 17:28:43', '2620536650', '1mztf5e82843', 'PDN0000007543', 'QRA177460727250759404516041', 195000, '2026117070177723', 'Retikashop', '08********** - Fadli Foocie', 'DANA', 'QRIS DINAMIS', 'Successful', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132492, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 8683, 0, 75, 350, 0, '70 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57535176', NULL, 'ORDER_KUOTA', 2558414, 2549731, '2026-03-27 17:30:24', 'TRX20260327173023776', '138044-20260327173031-8683', '15175119886', '?RATU••PMK¶§ . Refid: K77748194', 8958, 'T#1139375950', 'MDP-H2H', 'API -  gff', 'gff', 'FF70', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132493, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 928, 1, 6, 0, 75, 'DEPOSIT USER VIA QRIS', 'MDP PAYMENT', 'mdp@mdppulsa.my.id', '57537824', 'SfdX', NULL, 993, 1921, '2026-03-27 17:55:51', '5693796239', '1mzu76a15742', 'PDN0000006217', 'QRA177460887177290503434560', 1000, '2026117070177731', 'Toko pulsa', 'SU********* - MDP PAYMENT', 'DANA', 'QRIS DINAMIS', 'Successful', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132494, 138217, 'WdZw', 'masuk', 0, 0, 1, 0, 1, 0, 10048, 1, 66, 0, 75, 'DEPOSIT USER VIA QRIS', 'Wahyu', 'danacare8899@gmail.com', '57540153', 'WdZw', NULL, 20172, 30220, '2026-03-27 18:19:09', '2472323640', '05cbdc268e97', 'PDN0000007535', 'QRA177461027046462605354921', 10000, '2026117070177734', 'Digitalpay', 'HENDRA SONJAYA - Wahyu', 'OVO', 'QRIS DINAMIS', 'Successful', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132495, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 34675, 0, 75, 300, 0, 'Telkomsel 35.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57546443', NULL, 'ORDER_KUOTA', 632529, 597854, '2026-03-27 19:16:22', 'TRX20260327191620336', '138093-20260327191625-34675', '082286561463', '04103700001460860147', 34900, 'T#1139549303', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S35', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132496, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57546783', NULL, 'ORDER_KUOTA', 597854, 587125, '2026-03-27 19:19:08', 'TRX20260327191908001', '138093-20260327192008-10729', '1156690000991969', 'OISI847763260327192008170', 10964, 'T#1139556850', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132497, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57546783', NULL, 'ORDER_KUOTA', 587125, 576396, '2026-03-27 19:19:09', 'TRX20260327191909002', '138093-20260327192010-10729', '1156690000991970', 'OISI847761260327192009274', 10964, 'T#1139556904', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132498, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57546783', NULL, 'ORDER_KUOTA', 576396, 565667, '2026-03-27 19:19:10', 'TRX20260327191910003', '138093-20260327192010-10729', '1156690000991971', 'OISI847765260327192009270', 10964, 'T#1139556909', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132499, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57546783', NULL, 'ORDER_KUOTA', 565667, 554938, '2026-03-27 19:19:11', 'TRX20260327191911004', '138093-20260327192009-10729', '1156690000991972', 'OISI847761260327192009011', 10964, 'T#1139556915', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132500, 138052, 'Ur4N', 'keluar', 2, 1, 1, 0, 1, 0, 250113, 0, 75, 250, 0, 'Dana 250.000', 'ahsans', 'brothersdigitalofficial@gmail.com', '57547855', NULL, 'ORDER_KUOTA', 806397, 556284, '2026-03-27 19:28:00', 'TRX20260327192758151', '138052-20260327192801-250113', '085798125032', 'DNID ASEX HASXX SADXXXX/250000/2026032710121481030100166009292409438', 250288, 'T#1139572064', 'MDP-H2H', 'API- dana', 'dana', 'D250', 'SUKSES', 'PRABAYAR', NULL, NULL, 'failed', 'HTTP Code: 404', '2026-03-27 19:28:16', 'bukaolshop'),
(132501, 138093, 'WEGX', 'keluar', 2, 1, 1, 0, 1, 0, 36355, 0, 65, 300, 0, 'Isat Cetak Freedom Internet Central Sumatra', 'BATU16', 'ozilponsel17@gmail.com', '57553666', NULL, 'ORDER_KUOTA', 554938, 518583, '2026-03-27 20:14:29', 'TRX20260327201429001', '138093-20260327201512-36355', '2001451687047', '10GB l 10GB l 10GB - 28hr SUMATRA TENGAH VOU (04103300035324684363)', 36590, 'T#1139661631', 'MDP-H2H', 'API- INDOSAT', 'Indosat', 'ACFBCS7', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132502, 138093, 'WMlg', 'keluar', 2, 1, 1, 0, 1, 0, 20275, 0, 75, 300, 0, '8GB All + 1GB Bonus 5 Hari', 'Irpan', 'meizasaskirana1@gmail.com', '57564146', NULL, 'ORDER_KUOTA', 518583, 498308, '2026-03-27 21:40:50', 'TRX20260327214050271', '138093-20260327214053-20275', '089510168937', '03270940142230368', 20500, 'T#1139781040', 'MDP-H2H', 'API- Tri', 'Tri', 'TRH8M5', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132503, 138044, 'WHDZ', 'masuk', 0, 0, 1, 0, 1, 0, 4967, 1, 35, 3, 0, 'PEMBAYARAN VIA QRIS', 'Willy Saputra Pratama ', 'officialwilly22@gmail.com', 'ID1026488901533', NULL, NULL, 9934, 14901, '2026-03-27 22:10:55', 'EXT177462425421017005140535', '018499563471', 'PDN0000012994', 'REF177462425421016604030202', 5000, '018499563471', 'LELEK GAMING STORE', 'MU****************************', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132504, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57574541', NULL, 'ORDER_KUOTA', 498308, 487579, '2026-03-27 23:25:52', 'TRX20260327232552001', '138093-20260327232607-10729', '1156690000991975', 'OISI847763260327232605597', 10964, 'T#1139852385', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132505, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57574541', NULL, 'ORDER_KUOTA', 487579, 476850, '2026-03-27 23:25:53', 'TRX20260327232553002', '138093-20260327232608-10729', '1156690000991976', 'OISI452427260327232606778', 10964, 'T#1139852392', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132506, 138093, 'WEHI', 'keluar', 2, 1, 1, 0, 1, 0, 31446, 0, 65, 300, 0, 'Cetak Voucher Aigo Axis', 'HangLengkir', 'jayabersamatcc@gmail.com', '57578640', NULL, 'ORDER_KUOTA', 476850, 445404, '2026-03-28 00:34:52', 'TRX20260328003452001', '138093-20260328003513-31446', '1161430000261996', 'ISIU165357260328003507180\",\"description\":\"AIGO 7GB Lokal 28hr\"', 31681, 'T#1139868510', 'MDP-H2H', 'API- AXIS', 'Axis', 'TVK5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132507, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 8673, 0, 75, 350, 0, '70 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57589716', NULL, 'ORDER_KUOTA', 2594437, 2585764, '2026-03-28 07:56:33', 'TRX20260328075632213', '138044-20260328075640-8673', '7687409526', 'karaamafiaa? . Refid: K77789438', 8948, 'T#1139978908', 'MDP-H2H', 'API -  gff', 'gff', 'FF70', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132508, 138176, 'V4Ho', 'keluar', 2, 1, 1, 0, 1, 0, 12690, 0, 50, 200, 0, 'Kuota 4GB All 7 Hari', 'Anda Buah', 'andakeluarga1@gmail.com', '57592689', NULL, 'ORDER_KUOTA', 30776, 18086, '2026-03-28 08:46:58', 'TRX20260328084658786', '138176-20260328084718-12690', '085198819898', 'DGPS260328084710906802676', 12840, 'T#1140033124', 'MDP-H2H', 'API- ByU', 'ByU', 'BYUH4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132509, 137992, 'RC5h', 'keluar', 2, 1, 1, 0, 1, 0, 100113, 0, 75, 300, 0, 'Dana 100.000', 'Putri naIfa Syaqila', 'naifaasyaqilla03@gmail.com', '57592739', NULL, 'ORDER_KUOTA', 507911, 407798, '2026-03-28 08:47:51', 'TRX20260328084750538', '137992-20260328084752-100113', '081254713794', 'DNID PETXXX KANXXXXX KWAXX/100000/2026032810121481030100166570194708624', 100338, 'T#1140034124', 'MDP-H2H', 'API -  dana', 'dana', 'D100', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132510, 138052, 'Ur4N', 'keluar', 2, 1, 1, 0, 1, 0, 10913, 0, 75, 175, 0, 'Axis 10.000', 'ahsans', 'brothersdigitalofficial@gmail.com', '57599332', NULL, 'ORDER_KUOTA', 556284, 545371, '2026-03-28 10:16:18', 'TRX20260328101618328', '138052-20260328101621-10913', '083156793395', '99970328019646', 11013, 'T#1140152949', 'MDP-H2H', 'API- Axis', 'Axis', 'A10', 'SUKSES', 'PRABAYAR', NULL, NULL, 'failed', 'HTTP Code: 404', '2026-03-28 10:17:16', 'bukaolshop'),
(132511, 137992, 'RC5h', 'keluar', 2, 1, 1, 0, 1, 0, 60113, 0, 75, 300, 0, 'Dana 60.000', 'Putri naIfa Syaqila', 'naifaasyaqilla03@gmail.com', '57607582', NULL, 'ORDER_KUOTA', 407798, 347685, '2026-03-28 11:43:06', 'TRX20260328114305752', '137992-20260328114308-60113', '085325508718', 'DNID FHAXX INDXXXXX ENTXXXXX/60000/2026032810121481030100166795594014382', 60338, 'T#1140272153', 'MDP-H2H', 'API -  dana', 'dana', 'D60', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132512, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 4967, 1, 35, 3, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 4967, 9934, '2026-03-28 13:25:03', 'EXT177467910242069704420702', '018331782320', 'PDN0000007545', 'REF177467910242069508160325', 5000, '018331782320', 'ZARFAN STORE', '08**********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132513, 138044, 'X5gq', 'keluar', 2, 1, 1, 0, 1, 0, 17213, 0, 75, 350, 0, '140 Diamond Free Fire', 'Arpa', 'arpa47724@gmail.com', '57621417', NULL, 'ORDER_KUOTA', 2585764, 2568551, '2026-03-28 13:46:07', 'TRX20260328134606891', '138044-20260328134652-17213', '3136890966', 'APPA?BORRO Refid: K77849328', 17488, 'T#1140421953', 'MDP-H2H', 'API -  gff', 'gff', 'FF140', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132514, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 51865, 0, 75, 350, 0, '405 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57638911', NULL, 'ORDER_KUOTA', 2568551, 2516686, '2026-03-28 16:57:35', 'TRX20260328165733575', '138044-20260328165737-51865', '9796640193', '353d1fc0-b068-49aa-b2dd-82fbd5d8c63e', 52140, 'T#1140649781', 'MDP-H2H', 'API -  gff', 'gff', 'FFU405', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132515, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 89280, 0, 75, 500, 0, '720 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57639790', NULL, 'ORDER_KUOTA', 2516686, 2427406, '2026-03-28 17:07:02', 'TRX20260328170701177', '138044-20260328170706-89280', '9396640193', '720 Diamonds /nick: Awan8#7P9 /ref: 19D33E95CDA3368436C011A82', 89705, 'T#1140662646', 'MDP-H2H', 'API -  gff', 'gff', 'FF720', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132516, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640371', NULL, 'ORDER_KUOTA', 445404, 439110, '2026-03-28 17:13:22', 'TRX20260328171322001', '138093-20260328171408-6294', '1156690000991869', 'OISI452427260328171407244', 6529, 'T#1140672970', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132517, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640371', NULL, 'ORDER_KUOTA', 439110, 432816, '2026-03-28 17:13:23', 'TRX20260328171323002', '138093-20260328171407-6294', '1156690000991870', 'OISI847762260328171406143', 6529, 'T#1140672984', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132518, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640371', NULL, 'ORDER_KUOTA', 432816, 426522, '2026-03-28 17:13:24', 'TRX20260328171324003', '138093-20260328171408-6294', '1156690000991871', 'OISI338519260328171407853', 6529, 'T#1140672991', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132519, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640371', NULL, 'ORDER_KUOTA', 426522, 420228, '2026-03-28 17:13:25', 'TRX20260328171325004', '138093-20260328171408-6294', '1156690000991872', 'OISI338519260328171407754', 6529, 'T#1140672995', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132520, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640371', NULL, 'ORDER_KUOTA', 420228, 413934, '2026-03-28 17:13:26', 'TRX20260328171326005', '138093-20260328171408-6294', '1156690000991873', 'OISI847763260328171407857', 6529, 'T#1140672999', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132521, 138093, 'UGRh', 'keluar', 2, 0, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640371', NULL, 'ORDER_KUOTA', 413934, 407640, '2026-03-28 17:13:27', 'TRX20260328171327006', '138093-20260328171607-6294', '1156690000991874', 'OISI452424260328171407949', 6529, 'T#1140678850', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132522, 138093, 'UGRh', 'keluar', 2, 0, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640371', NULL, 'ORDER_KUOTA', 407640, 401346, '2026-03-28 17:13:28', 'TRX20260328171328007', '138093-20260328171607-6294', '1156690000991875', 'OISI847765260328171407949', 6529, 'T#1140678850', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132523, 138093, 'UGRh', 'keluar', 2, 0, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640371', NULL, 'ORDER_KUOTA', 401346, 395052, '2026-03-28 17:13:29', 'TRX20260328171329008', '138093-20260328171607-6294', '1156690000991876', 'OISI847764260328171408597', 6529, 'T#1140678850', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132524, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640537', NULL, 'ORDER_KUOTA', 395052, 384323, '2026-03-28 17:15:07', 'TRX20260328171507001', '138093-20260328171606-10729', '1156690000991977', 'OISI847761260328171606251', 10964, 'T#1140675813', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132525, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640537', NULL, 'ORDER_KUOTA', 384323, 373594, '2026-03-28 17:15:08', 'TRX20260328171508002', '138093-20260328171607-10729', '1156690000991978', 'OISI452427260328171606243', 10964, 'T#1140675819', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132526, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640537', NULL, 'ORDER_KUOTA', 373594, 362865, '2026-03-28 17:15:09', 'TRX20260328171509003', '138093-20260328171606-10729', '1156690000991979', 'OISI847762260328171606366', 10964, 'T#1140675823', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132527, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640537', NULL, 'ORDER_KUOTA', 362865, 352136, '2026-03-28 17:15:10', 'TRX20260328171510004', '138093-20260328171607-10729', '1156690000991980', 'OISI847762260328171606907', 10964, 'T#1140675825', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132528, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640537', NULL, 'ORDER_KUOTA', 352136, 341407, '2026-03-28 17:15:11', 'TRX20260328171511005', '138093-20260328171607-10729', '1156690000991981', 'OISI847761260328171606890', 10964, 'T#1140675827', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132529, 138093, 'UGRh', 'keluar', 2, 0, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640537', NULL, 'ORDER_KUOTA', 341407, 330678, '2026-03-28 17:15:12', 'TRX20260328171512006', '138093-20260328171607-10729', '1156690000991982', 'OISI847765260328171606924', 10964, 'T#1140678850', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132530, 138093, 'UGRh', 'keluar', 2, 0, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640537', NULL, 'ORDER_KUOTA', 330678, 319949, '2026-03-28 17:15:13', 'TRX20260328171513007', '138093-20260328171607-10729', '1156690000991983', 'OISI847764260328171607346', 10964, 'T#1140678850', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132531, 138093, 'UGRh', 'keluar', 2, 0, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640537', NULL, 'ORDER_KUOTA', 319949, 309220, '2026-03-28 17:15:14', 'TRX20260328171514008', '138093-20260328171607-10729', '1156690000991984', 'OISI338519260328171607332', 10964, 'T#1140678850', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132532, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15583, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640708', NULL, 'ORDER_KUOTA', 309220, 293637, '2026-03-28 17:17:05', 'TRX20260328171705001', '138093-20260328171807-15583', '1156690000991877', 'OISI452427260328171806745', 15818, 'T#1140678850', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132533, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15583, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640708', NULL, 'ORDER_KUOTA', 293637, 278054, '2026-03-28 17:17:06', 'TRX20260328171706002', '138093-20260328171807-15583', '1156690000991878', 'OISI452424260328171806871', 15818, 'T#1140678854', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132534, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15583, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640708', NULL, 'ORDER_KUOTA', 278054, 262471, '2026-03-28 17:17:07', 'TRX20260328171707003', '138093-20260328171808-15583', '1156690000991879', 'OISI452427260328171807424', 15818, 'T#1140678859', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132535, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15583, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57640708', NULL, 'ORDER_KUOTA', 262471, 246888, '2026-03-28 17:17:08', 'TRX20260328171708004', '138093-20260328171808-15583', '1156690000991880', 'OISI847764260328171807373', 15818, 'T#1140678864', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132536, 138044, 'VJmR', 'keluar', 2, 1, 1, 0, 1, 0, 5920, 0, 75, 150, 0, 'XL 5.000', 'ilham nur taufik', 'semintz27@gmail.com', '57640886', NULL, 'ORDER_KUOTA', 2427406, 2421486, '2026-03-28 17:19:19', 'TRX20260328171918707', '138044-20260328171921-5920', '0818831242', '99970328036093', 5995, 'T#1140680568', 'MDP-H2H', 'API- XL', 'XL', 'X5', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132537, 138044, 'VDGt', 'masuk', 0, 0, 1, 0, 1, 0, 7961, 1, 56, 4, 0, 'PEMBAYARAN VIA QRIS', 'Rif\'at Achmadhani', 'toyobambang38@gmail.com', 'ID1026481399255', NULL, NULL, 9934, 17895, '2026-03-28 17:50:13', 'EXT177469501209761803590349', '1n0y18y89967', 'PDN0000007550', 'REF177469501209761702070020', 8014, '1n0y18y89967', 'Rifat King Store', 'GOPAY', 'GOPAY', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132538, 138044, 'VDGt', 'masuk', 0, 0, 1, 0, 1, 0, 1987, 1, 14, 1, 0, 'PEMBAYARAN VIA QRIS', 'Rif\'at Achmadhani', 'toyobambang38@gmail.com', 'ID1026481399255', NULL, NULL, 17895, 19882, '2026-03-28 17:52:21', 'EXT177469514035166607680386', '010000BSTX1S', 'PDN0000007550', 'REF177469514035166501990352', 2000, '010000BSTX1S', 'Rifat King Store', 'RIFAT ACHMADHANI', 'SEABANK', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132539, 138044, 'VDGt', 'masuk', 0, 0, 1, 0, 1, 0, 844, 1, 6, 1, 0, 'PEMBAYARAN VIA QRIS', 'Rif\'at Achmadhani', 'toyobambang38@gmail.com', 'ID1026481399255', NULL, NULL, 19882, 20726, '2026-03-28 17:53:58', 'EXT177469523731540102350496', '010000BSTXV2', 'PDN0000007550', 'REF177469523731539901140618', 850, '010000BSTXV2', 'Rifat King Store', 'RIFAT ACHMADHANI', 'SEABANK', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132540, 138093, 'VRPk', 'keluar', 2, 1, 1, 0, 1, 0, 9720, 0, 50, 400, 0, 'Smart 4GB All 3 Hari', 'Ganet', 'ponseljayabersama@gmail.com', '57645813', NULL, 'ORDER_KUOTA', 246888, 237168, '2026-03-28 18:13:11', 'TRX20260328181309804', '138093-20260328181314-9720', '088222485404', '4GB 3 HARI (005420253257771357)', 10070, 'T#1140756741', 'MDP-H2H', 'API- Smartfren', 'Smartfren', 'MDS43', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132541, 138093, 'Topup138093', 'masuk', 0, 0, 1, 0, 1, 0, 500347, 1, 0, 0, 0, 'Deposit Transfer Bank Seabank', NULL, NULL, NULL, NULL, NULL, 237168, 737515, '2026-03-28 18:34:57', '2480776430', '45435058842', '901341311777', '50034720260328183457', 500000, '50592499626', 'JbVan', NULL, 'Seabank', 'deposit saldo', 'SUCCESS', NULL, NULL, NULL, '0', NULL, NULL, NULL),
(132542, 138176, 'V4Ho', 'keluar', 2, 1, 1, 0, 1, 0, 17000, 0, 100, 60, 100, 'H2H DANA Topup (Bebas Nominal)', 'Anda Buah', 'andakeluarga1@gmail.com', '57648134', NULL, 'ORDER_KUOTA', 18086, 948, '2026-03-28 18:36:28', 'TRX20260328183627540', '138176-20260328183629-17000', '085198819898', 'DNID M BENX SETXXXXX/17000/2026032810121481030100166455694210308', 17098, 'T#1140791137', 'MDP-H2H', 'API- dana', 'dana', 'BBSDN', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132543, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 35915, 0, 65, 400, 0, 'XL Cetak Voucher Flex Mini', 'Widiaandriko', 'widiaandriko21@gmail.com', '57652740', NULL, 'ORDER_KUOTA', 737515, 701600, '2026-03-28 19:16:36', 'TRX20260328191636001', '138093-20260328191706-35915', '1134090000353932', 'ISITXL8476262402151121420573', 36250, 'T#1140862564', 'MDP-H2H', 'API- XL', 'XL', 'AVXDFM15G14', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132544, 138044, 'WKNR', 'keluar', 2, 1, 1, 0, 1, 0, 10800, 0, 50, 350, 0, 'Data 2,5GB 5 Hari', 'Gilzz', 'agilpiyoto322@gmail.com', '57665610', NULL, 'ORDER_KUOTA', 2421486, 2410686, '2026-03-28 20:59:54', 'TRX20260328205952775', '138044-20260328210023-10800', '082190049087', '0360020560943520', 11100, 'T#1141035944', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'TJ2', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132545, 138044, 'WHDZ', 'masuk', 0, 0, 1, 0, 1, 0, 19870, 1, 140, 10, 0, 'PEMBAYARAN VIA QRIS', 'Willy Saputra Pratama ', 'officialwilly22@gmail.com', 'ID1026488901533', NULL, NULL, 20726, 40596, '2026-03-28 23:17:49', 'EXT177471466764202206930847', '1n175as42050', 'PDN0000012994', 'REF177471466764202102920934', 20000, '1n175as42050', 'LELEK GAMING STORE', '08**********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132546, 138044, 'WHDZ', 'masuk', 0, 0, 1, 0, 1, 0, 2980, 1, 21, 2, 0, 'PEMBAYARAN VIA QRIS', 'Willy Saputra Pratama ', 'officialwilly22@gmail.com', 'ID1026488901533', NULL, NULL, 40596, 43576, '2026-03-28 23:20:40', 'EXT177471483838594708230156', '1n177au57197', 'PDN0000012994', 'REF177471483838594603030254', 3000, '1n177au57197', 'LELEK GAMING STORE', '08**********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132547, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10913, 0, 75, 300, 0, 'Axis 10.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57684054', NULL, 'ORDER_KUOTA', 701600, 690687, '2026-03-29 00:36:29', 'TRX20260329003628210', '138093-20260329003631-10913', '083137844769', '99970329000160', 11138, 'T#1141169844', 'MDP-H2H', 'API- Axis', 'Axis', 'A10', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132548, 138172, 'XHKS', 'masuk', 0, 0, 1, 0, 1, 0, 11000, 1, 3500, 0, 0, 'DEPOSIT VIA VIRTUAL ACCOUNT', 'Tokoh manisan', 'yyyiu288@gmail.com', '57685785', 'XHKS', NULL, 313298, 324298, '2026-03-29 01:15:56', '2274798440', '2026117070177876', '1604021695176771', 'MDP1450020260329011556', 14500, '2026117070177876', 'MDP Digital - Retikashop', '-', 'BRI', '002', 'SUCCESS', 'VIRTUAL ACCOUNT', NULL, NULL, '0', NULL, NULL, NULL),
(132549, 138172, 'XHKS', 'keluar', 1, 0, 1, 0, 1, 1, 3464, 0, 75, 500, 0, '12 (11+1) Diamond Mobile Legend', 'Tokoh manisan', 'yyyiu288@gmail.com', '57686925', NULL, 'ORDER_KUOTA', 324298, 324298, '2026-03-29 01:47:33', 'TRX20260329014732203', NULL, '239183750', 'TIME-OUT', 3889, NULL, NULL, 'API -  gml', 'gml', 'DML12', 'GAGAL', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132550, 137992, 'X8hJ', 'keluar', 2, 1, 1, 0, 1, 0, 200113, 0, 75, 300, 0, 'Dana 200.000', 'Liona', 'bastianliona2@gmail.com', '57692699', NULL, 'ORDER_KUOTA', 347685, 147572, '2026-03-29 06:52:55', 'TRX20260329065255481', '137992-20260329065257-200113', '081250193880', 'DNID MANXX RIAXXXXX/200000/2026032910121481030100166134696066045', 200338, 'T#1141231890', 'MDP-H2H', 'API -  dana', 'dana', 'D200', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132551, 137992, 'Topup137992', 'masuk', 0, 0, 1, 0, 1, 0, 250662, 1, 0, 0, 0, 'Deposit Transfer Bank Ewallet Dana', NULL, NULL, NULL, NULL, NULL, 147572, 398234, '2026-03-29 06:59:32', '42953804689', '63785546765', '082378202807', '25066220260329065932', 250000, '27759803225', 'Armedia', NULL, 'Ewallet Dana', 'deposit saldo', 'SUCCESS', NULL, NULL, NULL, '0', NULL, NULL, NULL),
(132552, 138044, 'WHOo', 'keluar', 2, 1, 1, 0, 1, 0, 8400, 0, 50, 350, 0, 'Mini Axis 5GB + Bonus Aigo 2 Hari', 'initans', 'sixseventans@gmail.com', '57695990', NULL, 'ORDER_KUOTA', 2410686, 2402286, '2026-03-29 08:12:06', 'TRX20260329081204166', '138044-20260329081211-8400', '083832122285', 'AIGO Mini 5GB Lokal 2hr (OUTEMBAK260465260329081208130)', 8700, 'T#1141293245', 'MDP-H2H', 'API- Axis', 'Axis', 'AXM5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132553, 138152, 'X8lf', 'masuk', 0, 0, 1, 0, 1, 0, 50000, 1, 3500, 0, 0, 'DEPOSIT VIA VIRTUAL ACCOUNT', 'LISDA MANIS', 'lisdaayunda241@gmail.com', '57699211', 'X8lf', NULL, 271093, 321093, '2026-03-29 09:10:00', '4880610531', '2026117070177884', '1604050134785989', 'MDP5350020260329091000', 53500, '2026117070177884', 'MDP Digital - Pasmurah', '-', 'BRI', '002', 'SUCCESS', 'VIRTUAL ACCOUNT', NULL, NULL, '0', NULL, NULL, NULL),
(132554, 138093, 'WEHI', 'keluar', 2, 1, 1, 0, 1, 0, 31643, 0, 65, 300, 0, 'XL Cetak Voucher Flex', 'HangLengkir', 'jayabersamatcc@gmail.com', '57700487', NULL, 'ORDER_KUOTA', 690687, 659044, '2026-03-29 09:29:07', 'TRX20260329092907001', '138093-20260329093008-31643', '1134090000351117', 'OISI876502260329093008079', 31878, 'T#1141385186', 'MDP-H2H', 'API- XL', 'XL', 'UVXFS', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132555, 138044, 'VDGt', 'masuk', 0, 0, 1, 0, 1, 0, 4371, 1, 31, 3, 0, 'PEMBAYARAN VIA QRIS', 'Rif\'at Achmadhani', 'toyobambang38@gmail.com', 'ID1026481399255', NULL, NULL, 43576, 47947, '2026-03-29 09:34:11', 'EXT177475165055781804390133', '1n1o9bg87147', 'PDN0000007550', 'REF177475165055781708010547', 4400, '1n1o9bg87147', 'Rifat King Store', 'RI***************', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132556, 138044, 'VDGt', 'masuk', 0, 0, 1, 0, 1, 0, 6565, 1, 46, 4, 0, 'PEMBAYARAN VIA QRIS', 'Rif\'at Achmadhani', 'toyobambang38@gmail.com', 'ID1026481399255', NULL, NULL, 47947, 54512, '2026-03-29 09:35:07', 'EXT177475170779859309580142', '002608863649', 'PDN0000007550', 'REF177475170779859202110135', 6608, '002608863649', 'Rifat King Store', 'RIF\'AT ACHMADHANI', 'KROM BANK', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132557, 138152, 'X8lf', 'masuk', 0, 0, 1, 0, 1, 0, 90000, 1, 3500, 0, 0, 'DEPOSIT VIA VIRTUAL ACCOUNT', 'LISDA MANIS', 'lisdaayunda241@gmail.com', '57703247', 'X8lf', NULL, 321093, 411093, '2026-03-29 10:08:11', '4489832531', '2026117070177886', '1604053590869305', 'MDP9350020260329100811', 93500, '2026117070177886', 'MDP Digital - Pasmurah', '-', 'BRI', '002', 'SUCCESS', 'VIRTUAL ACCOUNT', NULL, NULL, '0', NULL, NULL, NULL),
(132558, 138044, 'WHDZ', 'masuk', 0, 0, 1, 0, 1, 0, 306, 1, 2, 0, 0, 'PEMBAYARAN VIA QRIS', 'Willy Saputra Pratama ', 'officialwilly22@gmail.com', 'ID1026488901533', NULL, NULL, 54512, 54818, '2026-03-29 10:09:00', 'EXT177475374069775004550504', '1n1p8c033764', 'PDN0000012994', 'REF177475374069774904510933', 308, '1n1p8c033764', 'LELEK GAMING STORE', 'WILLY SAPUTRA PRATAMA', 'SUPERBANK', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132559, 138152, 'X8lf', 'keluar', 2, 1, 1, 0, 1, 0, 21840, 0, 75, 0, 0, 'Promo Token PLN 20 Ribu', 'LISDA MANIS', 'lisdaayunda241@gmail.com', '57704656', NULL, 'ORDER_KUOTA', 411093, 389253, '2026-03-29 10:25:44', 'TRX20260329102543808', '138152-20260329102545-21840', '56201796978', '5942-0943-5478-9466-0502/CSR2019GASSING DG KULLE/R1/450VA/43.9 KWH', 21765, 'T#1141456349', 'MDP-H2H', 'API- TOKEN', 'TOKEN', 'PLNP20', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132560, 137992, 'X8hJ', 'keluar', 2, 1, 1, 0, 1, 0, 11540, 0, 75, 200, 0, 'Isat Promo 10.000', 'Liona', 'bastianliona2@gmail.com', '57706038', NULL, 'ORDER_KUOTA', 398234, 386694, '2026-03-29 10:41:54', 'TRX20260329104153308', '137992-20260329104210-11540', '085753457825', '04098300054209119932.', 11665, 'T#1141478245', 'MDP-H2H', 'API -  Indosat', 'Indosat', 'IA10', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132561, 137992, 'X8hJ', 'keluar', 2, 1, 1, 0, 1, 0, 200113, 0, 75, 300, 0, 'Dana 200.000', 'Liona', 'bastianliona2@gmail.com', '57706153', NULL, 'ORDER_KUOTA', 386694, 186581, '2026-03-29 10:42:56', 'TRX20260329104254864', '137992-20260329104257-200113', '081250193880', 'DNID MANXX RIAXXXXX/200000/2026032910121481030100166134695952113', 200338, 'T#1141479781', 'MDP-H2H', 'API -  dana', 'dana', 'D200', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132562, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 993.5, 1, 0, -7, 0, 'PEMBAYARAN VIA QRIS', 'Sugi Antoro', 'mdp@mdppulsa.my.id', 'ID1025463827481', NULL, NULL, 1921, 2914.5, '2026-03-29 11:09:09', 'EXT177475694309614402120717', '1n1qpbv48973', 'PDN0000006217', 'REF177475694309614306700999', 1000, '1n1qpbv48973', 'Toko pulsa', 'SU*********', 'ESPAY DEBIT INDONESIA KOE', 'QRIS STATIS', 'payment_success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132563, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 993, 1, 0, -6, 0, 'PEMBAYARAN VIA QRIS', 'Sugi Antoro', 'mdp@mdppulsa.my.id', 'ID1025463827481', NULL, NULL, 2914.5, 3907.5, '2026-03-29 11:11:49', 'EXT177475750856943300550958', '018548910136', 'PDN0000006217', 'REF177475750856943206870209', 1000, '018548910136', 'Toko pulsa', 'SU*********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132564, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 993, 1, 0, -6, 0, 'PEMBAYARAN VIA QRIS', 'Sugi Antoro', 'mdp@mdppulsa.my.id', 'ID1025463827481', NULL, NULL, 3907.5, 4900.5, '2026-03-29 11:15:53', 'EXT177475775251538806180125', '018548299236', 'PDN0000006217', 'REF177475775251538704770959', 1000, '018548299236', 'Toko pulsa', 'SU*********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132565, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 993, 1, 0, -6, 0, 'PEMBAYARAN VIA QRIS', 'Sugi Antoro', 'mdp@mdppulsa.my.id', 'ID1025463827481', NULL, NULL, 4900.5, 5893.5, '2026-03-29 12:52:54', 'EXT177476357320491608680820', '1n1tscb31422', 'PDN0000006217', 'REF177476357320491506800656', 1000, '1n1tscb31422', 'Toko pulsa', 'SU*********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132566, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 993, 1, 10, 4, 0, 'PEMBAYARAN VIA QRIS', 'Sugi Antoro', 'mdp@mdppulsa.my.id', 'ID1025463827481', NULL, NULL, 5893.5, 6886.5, '2026-03-29 13:02:34', 'EXT177476415319677403620467', '1n1u1cj08976', 'PDN0000006217', 'REF177476415319677308860225', 1000, '1n1u1cj08976', 'Toko pulsa', 'SU*********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132567, 138052, 'BZy6', 'keluar', 2, 1, 1, 0, 1, 0, 21840, 0, 75, 100, 0, 'Promo Token PLN 20 Ribu', 'Egi Vitriansyah', 'egilovelisna@gmail.com', '57720513', NULL, 'ORDER_KUOTA', 545371, 523531, '2026-03-29 13:20:02', 'TRX20260329132000237', '138052-20260329132004-21840', '535352296572', '3524-2692-8785-2522-3237/DADI TARMEDI/R1M/900VA/13.9 KWH', 21865, 'T#1141668998', 'MDP-H2H', 'API- TOKEN', 'TOKEN', 'PLNP20', 'SUKSES', 'PRABAYAR', NULL, NULL, 'failed', 'HTTP Code: 404', '2026-03-29 13:21:16', 'bukaolshop'),
(132568, 138146, 'WLna', 'masuk', 0, 0, 1, 0, 1, 0, 49798, 1, 326, 0, 75, 'DEPOSIT USER VIA QRIS', 'Lamin Kristy ', 'rahmikristi@gmail.com', '57721975', 'WLna', NULL, 0, 49798, '2026-03-29 13:34:38', '8001991294', '018474271652', 'PDN0000007350', 'QRA177476585279758301253515', 50000, '2026117070177888', 'Mitra cell', 'LA************** - Lamin Kristy', 'DANA', 'QRIS DINAMIS', 'Successful', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132569, 138152, 'X8lf', 'keluar', 2, 1, 1, 0, 1, 0, 30113, 0, 75, 0, 0, 'Dana 30.000', 'LISDA MANIS', 'lisdaayunda241@gmail.com', '57723600', NULL, 'ORDER_KUOTA', 389253, 359140, '2026-03-29 13:52:47', 'TRX20260329135247167', '138152-20260329135249-30113', '087839141803', 'DNID 087839141803/30000/2026032910121481030100166692593126933', 30038, 'T#1141708159', 'MDP-H2H', 'API- dana', 'dana', 'D30', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132570, 138152, 'X8lf', 'keluar', 2, 1, 1, 0, 1, 0, 60113, 0, 75, 0, 0, 'Dana 60.000', 'LISDA MANIS', 'lisdaayunda241@gmail.com', '57726007', NULL, 'ORDER_KUOTA', 359140, 299027, '2026-03-29 14:21:12', 'TRX20260329142111528', '138152-20260329142114-60113', '08152507206', 'DNID HAYX/60000/2026032910121481030100166091994604013', 60038, 'T#1141739673', 'MDP-H2H', 'API- dana', 'dana', 'D60', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132571, 138172, 'SHAd', 'masuk', 0, 0, 1, 0, 1, 0, 6954, 1, 53, 8, 0, 'PEMBAYARAN VIA QRIS', 'Muhamad khoerudin', 'muhama.paus97@gmail.com', 'ID1026484768225', NULL, NULL, 197338, 204292, '2026-03-29 14:43:09', 'EXT177477018785582702760832', '116929159162', 'PDN0000012690', 'REF177477018785582605540944', 7000, '116929159162', 'KOLAM RENANG WICEK', 'MUHAMAD KHOERUDIN', 'BANK RAKYAT INDONESIA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132572, 138093, 'WMlg', 'keluar', 2, 1, 1, 0, 1, 0, 15100, 0, 50, 400, 0, 'Paket Harian 5,5GB+ Lokal 5 Hari', 'Irpan', 'meizasaskirana1@gmail.com', '57728133', NULL, 'ORDER_KUOTA', 659044, 643944, '2026-03-29 14:44:37', 'TRX20260329144435283', '138093-20260329144451-15100', '083183268068', '218870651', 15450, 'T#1141765151', 'MDP-H2H', 'API- Axis', 'Axis', 'ADH5G5H', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132573, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 993, 1, 10, 4, 0, 'PEMBAYARAN VIA QRIS', 'Sugi Antoro', 'mdp@mdppulsa.my.id', 'ID1025463827481', NULL, NULL, 6886.5, 7879.5, '2026-03-29 15:18:37', 'EXT177477231614081109640391', '018540999936', 'PDN0000006217', 'REF177477231614081006990286', 1000, '018540999936', 'Toko pulsa', 'SU*********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132574, 138042, 'SfdX', 'masuk', 0, 0, 1, 0, 1, 0, 993, 1, 0, -6, 0, 'PEMBAYARAN VIA QRIS', 'Sugi Antoro', 'mdp@mdppulsa.my.id', 'ID1025463827481', NULL, NULL, 7879.5, 8872.5, '2026-03-29 15:21:49', 'EXT177477250806960902760564', '1n1xxco23531', 'PDN0000006217', 'REF177477250806960804130151', 1000, '1n1xxco23531', 'Toko pulsa', 'SU*********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132575, 138044, 'WHDZ', 'masuk', 0, 0, 1, 0, 1, 0, 6954, 1, 49, 4, 0, 'PEMBAYARAN VIA QRIS', 'Willy Saputra Pratama ', 'officialwilly22@gmail.com', 'ID1026488901533', NULL, NULL, 54818, 61772, '2026-03-29 15:31:07', 'EXT177477306614166106160389', '018318549795', 'PDN0000012994', 'REF177477306614166009370962', 7000, '018318549795', 'LELEK GAMING STORE', '08**********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132576, 138044, 'V7Yb', 'keluar', 2, 1, 1, 0, 1, 0, 19325, 0, 75, 350, 0, '150 Diamond Free Fire', 'Bintang Satria', 'bintangstria990@gmail.com', '57736408', NULL, 'ORDER_KUOTA', 2402286, 2382961, '2026-03-29 16:17:38', 'TRX20260329161737402', '138044-20260329161744-19325', '2289770373', 'VICKY|AE? . RefId: T774775861GMVVKGP57K', 19600, 'T#1141870256', 'MDP-H2H', 'API -  gff', 'gff', 'FFU150', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132577, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 33620, 0, 75, 350, 0, '260 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57737459', NULL, 'ORDER_KUOTA', 2382961, 2349341, '2026-03-29 16:28:49', 'TRX20260329162848654', '138044-20260329162855-33620', '1969742220', 'VF???Yanz Refid: K78001344', 33895, 'T#1141884530', 'MDP-H2H', 'API -  gff', 'gff', 'FFU260', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132578, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 54025, 0, 75, 350, 0, '420 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57738640', NULL, 'ORDER_KUOTA', 2349341, 2295316, '2026-03-29 16:42:21', 'TRX20260329164220306', '138044-20260329164230-54025', '7687409526', 'karaamafiaa? Refid: K78003125', 54300, 'T#1141903244', 'MDP-H2H', 'API -  gff', 'gff', 'FFU420', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132579, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57739768', NULL, 'ORDER_KUOTA', 643944, 637650, '2026-03-29 16:55:18', 'TRX20260329165518001', '138093-20260329165607-6294', '1156690000990890', 'OISI452427260329165606400', 6529, 'T#1141921930', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132580, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57739768', NULL, 'ORDER_KUOTA', 637650, 631356, '2026-03-29 16:55:19', 'TRX20260329165519002', '138093-20260329165608-6294', '1156690000990891', 'OISI847763260329165607965', 6529, 'T#1141921965', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132581, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 8332, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57739957', NULL, 'ORDER_KUOTA', 631356, 623024, '2026-03-29 16:57:40', 'TRX20260329165740001', '138093-20260329165806-8332', '1156690000990892', 'OISI847762260329165805519', 8567, 'T#1141924684', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132582, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 8332, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57739957', NULL, 'ORDER_KUOTA', 623024, 614692, '2026-03-29 16:57:41', 'TRX20260329165741002', '138093-20260329165806-8332', '1156690000990893', 'OISI847765260329165805668', 8567, 'T#1141924693', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132583, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57740195', NULL, 'ORDER_KUOTA', 614692, 603963, '2026-03-29 17:00:42', 'TRX20260329170042001', '138093-20260329170106-10729', '1156690000990894', 'OISI847765260329170105250', 10964, 'T#1141929077', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132584, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57740195', NULL, 'ORDER_KUOTA', 603963, 593234, '2026-03-29 17:00:43', 'TRX20260329170043002', '138093-20260329170106-10729', '1156690000990895', 'OISI338519260329170105371', 10964, 'T#1141929083', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132585, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 14151, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 5 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57740316', NULL, 'ORDER_KUOTA', 593234, 579083, '2026-03-29 17:02:05', 'TRX20260329170205001', '138093-20260329170307-14151', '1156690000990896', 'OISI847761260329170305843', 14386, 'T#1141931813', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM2', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132586, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 14151, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 5 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57740316', NULL, 'ORDER_KUOTA', 579083, 564932, '2026-03-29 17:02:06', 'TRX20260329170206002', '138093-20260329170307-14151', '1156690000990897', 'OISI847761260329170305861', 14386, 'T#1141931842', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM2', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop');
INSERT INTO `transaksi_tenant` (`id`, `user_id`, `kode_agen`, `tipe`, `is_notified`, `lock_callback`, `is_log`, `notif_lock`, `is_updated`, `is_reffund`, `nominal`, `is_settel`, `admin`, `markup`, `markup_server`, `keterangan`, `api_nama_user`, `api_email_user`, `api_id_perubahan`, `api_userid`, `spl`, `saldo_sebelum`, `saldo_sesudah`, `created_at`, `partner_reff`, `rrn`, `accountnumber`, `serialnumber`, `amount`, `payment_reff`, `accountname`, `customer_data`, `bankname`, `bankcode`, `respon_desc`, `type`, `meter_awal`, `meter_akhir`, `is_sending`, `callback_response`, `callback_at`, `sistem`) VALUES
(132587, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 21450, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 15 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57740469', NULL, 'ORDER_KUOTA', 564932, 543482, '2026-03-29 17:03:50', 'TRX20260329170350001', '138093-20260329170405-21450', '1156690000990898', 'OISI847761260329170405089', 21685, 'T#1141933299', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAMV6', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132588, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 21450, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 15 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57740469', NULL, 'ORDER_KUOTA', 543482, 522032, '2026-03-29 17:03:51', 'TRX20260329170351002', '138093-20260329170406-21450', '1156690000990899', 'OISI847761260329170405740', 21685, 'T#1141933310', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAMV6', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132589, 138052, 'BZy6', 'keluar', 2, 1, 1, 0, 1, 0, 21840, 0, 75, 100, 0, 'Promo Token PLN 20 Ribu', 'Egi Vitriansyah', 'egilovelisna@gmail.com', '57740722', NULL, 'ORDER_KUOTA', 523531, 501691, '2026-03-29 17:06:53', 'TRX20260329170652267', '138052-20260329170654-21840', '86239921702', '6224-1619-1467-9264-0262/NY ADE/R1M/900VA/13.9 KWH', 21865, 'T#1141937339', 'MDP-H2H', 'API- TOKEN', 'TOKEN', 'PLNP20', 'SUKSES', 'PRABAYAR', NULL, NULL, 'failed', 'HTTP Code: 404', '2026-03-29 17:07:16', 'bukaolshop'),
(132590, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 13164, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 7 Hari', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57740724', NULL, 'ORDER_KUOTA', 522032, 508868, '2026-03-29 17:06:56', 'TRX20260329170656001', '138093-20260329170706-13164', '11566900009908900', 'OISI847761260329170705835', 13399, 'T#1141937569', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAMV1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132591, 138093, 'VDTQ', 'keluar', 1, 1, 1, 0, 1, 1, 31369, 0, 65, 300, 0, 'Cetak Voucher Aigo Axis', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57741426', NULL, 'ORDER_KUOTA', 508868, 508868, '2026-03-29 17:15:21', 'TRX20260329171521001', '138093-20260329171605-31369', '11566900009908901', 'GAGAL. Nomor tujuan salah.', 31604, 'T#1141950661', 'MDP-H2H', 'API- AXIS', 'Axis', 'TVK5G', 'GAGAL', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132592, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 6323, 0, 125, 300, 0, 'Nasional 140 Menit All Operator 3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57741814', NULL, 'ORDER_KUOTA', 508868, 502545, '2026-03-29 17:20:14', 'TRX20260329172013425', '138093-20260329172025-6323', '082286609642', '04042100000378008434', 6498, 'T#1141956944', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'SSA14', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132593, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 5464, 1, 39, 4, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 61772, 67236, '2026-03-29 17:23:11', 'EXT177477979014259702440090', '010000BTYDXN', 'PDN0000007545', 'REF177477979014259500910002', 5500, '010000BTYDXN', 'ZARFAN STORE', 'SETIAWAN', 'SEABANK', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132594, 138052, 'BZy6', 'keluar', 2, 1, 1, 0, 1, 0, 21840, 0, 75, 100, 0, 'Promo Token PLN 20 Ribu', 'Egi Vitriansyah', 'egilovelisna@gmail.com', '57742363', NULL, 'ORDER_KUOTA', 501691, 479851, '2026-03-29 17:26:22', 'TRX20260329172621143', '138052-20260329172623-21840', '14238743430', '1631-7575-2915-8865-5213/ERAT/R1/900VA/31.2 KWH', 21865, 'T#1141965901', 'MDP-H2H', 'API- TOKEN', 'TOKEN', 'PLNP20', 'SUKSES', 'PRABAYAR', NULL, NULL, 'failed', 'HTTP Code: 404', '2026-03-29 17:27:16', 'bukaolshop'),
(132595, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 48064, 0, 75, 300, 0, 'Indosat 50.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57749559', NULL, 'ORDER_KUOTA', 502545, 454481, '2026-03-29 18:46:26', 'TRX20260329184625749', '138093-20260329184628-48064', '081534891083', '04105300035350446093', 48289, 'T#1142089795', 'MDP-H2H', 'API- Indosat', 'Indosat', 'I50', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132596, 138044, 'V7Yb', 'keluar', 2, 1, 1, 0, 1, 0, 19310, 0, 75, 350, 0, '150 Diamond Free Fire', 'Bintang Satria', 'bintangstria990@gmail.com', '57750692', NULL, 'ORDER_KUOTA', 2295316, 2276006, '2026-03-29 18:57:55', 'TRX20260329185754871', '138044-20260329185815-19310', '7666037751', 'I\'mBinzz:). RefId: S44165098', 19585, 'T#1142111785', 'MDP-H2H', 'API -  gff', 'gff', 'FFU150', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132597, 138152, 'X8lf', 'keluar', 2, 1, 1, 0, 1, 0, 5113, 0, 75, 0, 0, 'Dana 5.000', 'LISDA MANIS', 'lisdaayunda241@gmail.com', '57752574', NULL, 'ORDER_KUOTA', 299027, 293914, '2026-03-29 19:14:16', 'TRX20260329191415688', '138152-20260329191418-5113', '087763945991', 'DNID ALIX/5000/2026032910121481030100166252195907389', 5038, 'T#1142144721', 'MDP-H2H', 'API- dana', 'dana', 'D5', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132598, 138093, 'UGY6', 'masuk', 0, 0, 1, 0, 1, 0, 993, 1, 0, -6, 0, 'PEMBAYARAN VIA QRIS', 'Arpan Jaya', 'arpanjaya7@gmail.com', 'ID1021066419305', NULL, NULL, 0, 993, '2026-03-29 19:22:06', 'EXT177478692496109408790841', '018754277013', 'PDN0000007417', 'REF177478692496109305520440', 1000, '018754277013', 'Jaya Bersama', 'AR********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132599, 138093, 'UGRh', 'keluar', 1, 1, 1, 0, 1, 1, 39630, 0, 75, 300, 0, 'Telkomsel 40.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57753926', NULL, 'ORDER_KUOTA', 454481, 454481, '2026-03-29 19:25:35', 'TRX20260329192534828', '138093-20260329193057-39630', '082231954921', 'GAGAL. Nomor tujuan salah.', 39855, 'T#1142166508', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S40', 'GAGAL', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132600, 137992, 'X8hJ', 'keluar', 2, 1, 1, 0, 1, 0, 20113, 0, 75, 300, 0, 'Dana 20.000', 'Liona', 'bastianliona2@gmail.com', '57754497', NULL, 'ORDER_KUOTA', 186581, 166468, '2026-03-29 19:30:21', 'TRX20260329193020968', '137992-20260329193025-20113', '085820966843', 'DNID 085820966843/20000/2026032910121481030100166578995373084', 20338, 'T#1142174054', 'MDP-H2H', 'API -  dana', 'dana', 'D20', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132601, 138044, 'VkiN', 'keluar', 2, 1, 1, 0, 1, 0, 5192, 0, 50, 350, 0, 'Three 5.000', 'Bocah', 'kujangjalang@gmail.com', '57758040', NULL, 'ORDER_KUOTA', 2276006, 2270814, '2026-03-29 19:57:59', 'TRX20260329195757806', '138044-20260329195804-5192', '0895617882050', '260329195801054', 5492, 'T#1142225365', 'MDP-H2H', 'API- Three', 'Three', 'T5', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132602, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 31360, 0, 65, 300, 0, 'Cetak Voucher Aigo Axis', 'Widiaandriko', 'widiaandriko21@gmail.com', '57759214', NULL, 'ORDER_KUOTA', 454481, 423121, '2026-03-29 20:07:06', 'TRX20260329200706001', '138093-20260329200812-31360', '1156690000991973', 'ISIU165357260329200805857\",\"description\":\"AIGO 7GB Lokal 28hr\"', 31595, 'T#1142242996', 'MDP-H2H', 'API- AXIS', 'Axis', 'TVK5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132603, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 19980, 0, 75, 300, 0, 'Telkomsel 20.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57759727', NULL, 'ORDER_KUOTA', 423121, 403141, '2026-03-29 20:10:59', 'TRX20260329201058486', '138093-20260329201244-19980', '082387124887', '04105400001496173174', 20205, 'T#1142248090', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S20', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132604, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57762154', NULL, 'ORDER_KUOTA', 403141, 392412, '2026-03-29 20:29:07', 'TRX20260329202907001', '138093-20260329203010-10729', '1156690000991861', 'OISI847764260329203008363', 10964, 'T#1142277705', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132605, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57762154', NULL, 'ORDER_KUOTA', 392412, 381683, '2026-03-29 20:29:08', 'TRX20260329202908002', '138093-20260329203011-10729', '1156690000991862', 'OISI847763260329203010674', 10964, 'T#1142277766', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132606, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57762154', NULL, 'ORDER_KUOTA', 381683, 370954, '2026-03-29 20:29:09', 'TRX20260329202909003', '138093-20260329203012-10729', '1156690000991863', 'OISI847763260329203011601', 10964, 'T#1142277785', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132607, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57762154', NULL, 'ORDER_KUOTA', 370954, 360225, '2026-03-29 20:29:10', 'TRX20260329202910004', '138093-20260329203012-10729', '1156690000991864', 'OISI847762260329203011626', 10964, 'T#1142277792', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132608, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 4416, 1, 31, 3, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 67236, 71652, '2026-03-29 20:35:13', 'EXT177479131132089604940752', '1n26mdq23381', 'PDN0000007545', 'REF177479131132089505980268', 4445, '1n26mdq23381', 'ZARFAN STORE', 'GOPAY', 'GOPAY', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132609, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 9, 1, 0, 0, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 71652, 71661, '2026-03-29 20:49:08', 'EXT177479214654300103940901', '1n270dt10615', 'PDN0000007545', 'REF177479214654300007230483', 10, '1n270dt10615', 'ZARFAN STORE', 'GOPAY', 'GOPAY', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132610, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 29925, 0, 75, 300, 0, 'By U 30.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57764660', NULL, 'ORDER_KUOTA', 360225, 330300, '2026-03-29 20:50:10', 'TRX20260329205008364', '138093-20260329205021-29925', '085148100491', '04105000001496725670', 30150, 'T#1142306824', 'MDP-H2H', 'API- ByU', 'ByU', 'BYU30', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132611, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 63620, 0, 75, 350, 0, '500 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57766432', NULL, 'ORDER_KUOTA', 2270814, 2207194, '2026-03-29 21:06:21', 'TRX20260329210620239', '138044-20260329210625-63620', '3055536140', '500 Diamonds /nick: ???????ot4u‘ /ref: 19D39EACA6D10AFB5D1EBA434', 63895, 'T#1142329526', 'MDP-H2H', 'API -  gff', 'gff', 'FF500', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132612, 138093, 'VDTQ', 'keluar', 2, 1, 1, 0, 1, 0, 31358, 0, 65, 300, 0, 'Cetak Voucher Aigo Axis', 'Anggraini Saskia Paramuditha ', 'saskiaanggraini.1910@gmail.com', '57766585', NULL, 'ORDER_KUOTA', 330300, 298942, '2026-03-29 21:07:42', 'TRX20260329210742001', '138093-20260329210811-31358', '1156690000990901', 'ISIU165357260329210805528\",\"description\":\"AIGO 7GB Lokal 28hr\"', 31593, 'T#1142331816', 'MDP-H2H', 'API- AXIS', 'Axis', 'TVK5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132613, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 31358, 0, 65, 300, 0, 'Cetak Voucher Aigo Axis', 'Widiaandriko', 'widiaandriko21@gmail.com', '57768036', NULL, 'ORDER_KUOTA', 298942, 267584, '2026-03-29 21:22:06', 'TRX20260329212206001', '138093-20260329212322-31358', '1156690000991974', 'ISIU165357260329212305752\",\"description\":\"AIGO 7GB Lokal 28hr\"', 31593, 'T#1142350962', 'MDP-H2H', 'API- AXIS', 'Axis', 'TVK5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132614, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 34675, 0, 75, 300, 0, 'Telkomsel 35.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57768234', NULL, 'ORDER_KUOTA', 267584, 232909, '2026-03-29 21:24:07', 'TRX20260329212406574', '138093-20260329212410-34675', '085265650712', '04105100001497150401', 34900, 'T#1142352146', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S35', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132615, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10201, 0, 75, 300, 0, 'Three 10.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57770827', NULL, 'ORDER_KUOTA', 232909, 222708, '2026-03-29 21:49:24', 'TRX20260329214922925', '138093-20260329214931-10201', '089523960949', 'R260329.2149.21008a', 10426, 'T#1142377500', 'MDP-H2H', 'API- Three', 'Three', 'T10', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132616, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 19980, 0, 75, 300, 0, 'Telkomsel 20.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57774071', NULL, 'ORDER_KUOTA', 222708, 202728, '2026-03-29 22:28:35', 'TRX20260329222835391', '138093-20260329222849-19980', '082285999899', '04105900001497724159', 20205, 'T#1142407333', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S20', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132617, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15004, 0, 75, 300, 0, 'Telkomsel 15.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57774344', NULL, 'ORDER_KUOTA', 202728, 187724, '2026-03-29 22:32:21', 'TRX20260329223220125', '138093-20260329223224-15004', '082285999899', '04105200001497738232', 15229, 'T#1142409668', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S15', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132618, 138093, 'WMlg', 'keluar', 2, 1, 1, 0, 1, 0, 10725, 0, 50, 400, 0, 'Paket Harian 5GB+ Lokal 3 Hari', 'Irpan', 'meizasaskirana1@gmail.com', '57780450', NULL, 'ORDER_KUOTA', 187724, 176999, '2026-03-30 00:43:52', 'TRX20260330004351142', '138093-20260330004400-10725', '083152344268', '260330004355206.', 11075, 'T#1142448771', 'MDP-H2H', 'API- Axis', 'Axis', 'ADH5G3H', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132619, 138061, 'WQEY', 'keluar', 2, 1, 1, 0, 1, 0, 1113, 0, 75, 150, 0, 'Dana 1.000', 'Abu', 'abu25482@gmail.com', '57780583', NULL, 'ORDER_KUOTA', 3883, 2770, '2026-03-30 00:48:21', 'TRX20260330004820182', '138061-20260330004822-1113', '082239015878', 'DNID ABUXXXXX/1000/2026033010121481030100166505994484267', 1188, 'T#1142449777', 'MDP-H2H', 'API- dana', 'dana', 'D1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132620, 138135, 'SDGL', 'masuk', 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 'PEMBAYARAN VIA QRIS', 'PATEMI', 'akunkususkontakwa19@gmail.com', 'ID1025466105885', NULL, NULL, 0, 0, '2026-03-30 01:02:55', 'EXT177480737299535704130913', '001089079287', 'PDN0000007354', 'REF177480737299535602810627', 1, '001089079287', 'NikoPay', 'GOPAY', 'GOPAY', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132621, 138093, 'Topup138093', 'masuk', 0, 0, 1, 0, 1, 0, 600041, 1, 0, 0, 0, 'Deposit Transfer Bank Seabank', NULL, NULL, NULL, NULL, NULL, 176999, 777040, '2026-03-30 05:34:17', '70974960886', '85200200026', '901341311777', '60004120260330053417', 600000, '78146842698', 'JbVan', NULL, 'Seabank', 'deposit saldo', 'SUCCESS', NULL, NULL, NULL, '0', NULL, NULL, NULL),
(132622, 138052, 'Ur4N', 'keluar', 2, 1, 1, 0, 1, 0, 15004, 0, 75, 175, 0, 'Telkomsel 15.000', 'ahsans', 'brothersdigitalofficial@gmail.com', '57784860', NULL, 'ORDER_KUOTA', 479851, 464847, '2026-03-30 05:46:16', 'TRX20260330054615995', '138052-20260330054619-15004', '082115002617', '04106700001499030467', 15104, 'T#1142484693', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S15', 'SUKSES', 'PRABAYAR', NULL, NULL, 'failed', 'HTTP Code: 404', '2026-03-30 05:47:23', 'bukaolshop'),
(132623, 138093, 'WMlg', 'keluar', 2, 1, 1, 0, 1, 0, 15100, 0, 50, 400, 0, 'Paket Harian 5,5GB+ Lokal 5 Hari', 'Irpan', 'meizasaskirana1@gmail.com', '57787819', NULL, 'ORDER_KUOTA', 777040, 761940, '2026-03-30 07:47:00', 'TRX20260330074659133', '138093-20260330074715-15100', '083862289363', '222522051', 15450, 'T#1142568354', 'MDP-H2H', 'API- Axis', 'Axis', 'ADH5G5H', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132624, 137992, 'RC5h', 'keluar', 2, 1, 1, 0, 1, 0, 90113, 0, 75, 300, 0, 'Dana 90.000', 'Putri naIfa Syaqila', 'naifaasyaqilla03@gmail.com', '57791284', NULL, 'ORDER_KUOTA', 166468, 76355, '2026-03-30 09:05:18', 'TRX20260330090518920', '137992-20260330090519-90113', '085821970449', 'DNID EMAXXXX DALX WARX/90000/2026033010121481030100166746494956071', 90338, 'T#1142659825', 'MDP-H2H', 'API -  dana', 'dana', 'D90', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132625, 138044, 'WGyR', 'keluar', 2, 1, 1, 0, 1, 0, 18939, 0, 75, 350, 0, '150 Diamond Free Fire', 'Darderdor', 'dadidudiriku@gmail.com', '57792672', NULL, 'ORDER_KUOTA', 2207194, 2188255, '2026-03-30 09:33:07', 'TRX20260330093306162', '138044-20260330093309-18939', '7618019448', '?????•LADRAO .RefId: K78056782', 19214, 'T#1142698300', 'MDP-H2H', 'API -  gff', 'gff', 'FFU150', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132626, 138042, 'SfdX', 'keluar', 2, 0, 1, 0, 1, 0, 10000, 0, 2000, 1500, 0, 'SEABANK INDONESIA', 'MDP PAYMENT', 'mdp@mdppulsa.my.id', '57795172', NULL, NULL, 148563, 136563, '2026-03-30 10:12:24', 'TRX-BANK-138042-SfdX-20260330101224', '144041622007', '901341311777', 'BKO177484034548035505332955', 10000, '20260330101225', 'SUGI ANTORO', 'METODE BI-FAST', 'SEABANK INDONESIA', '535', 'Sukses', 'TRANSFER BANK', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132627, 138042, 'SfdX', 'keluar', 2, 0, 1, 0, 1, 0, 10000, 0, 2000, 1500, 0, 'SEABANK INDONESIA', 'MDP PAYMENT', 'mdp@mdppulsa.my.id', '57795412', NULL, NULL, 136563, 124563, '2026-03-30 10:15:55', 'TRX-BANK-138042-SfdX-20260330101555', '990631750193', '901341311777', 'BKO177484055655757702179522', 10000, '20260330101556', 'SUGI ANTORO', 'METODE BI-FAST', 'SEABANK INDONESIA', '535', 'Sukses', 'TRANSFER BANK', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132628, 138042, 'SfdX', 'keluar', 2, 0, 1, 0, 1, 0, 10000, 0, 2000, 1500, 0, 'SEABANK INDONESIA', 'MDP PAYMENT', 'mdp@mdppulsa.my.id', '57796036', NULL, NULL, 124563, 112563, '2026-03-30 10:25:36', 'TRX-BANK-138042-SfdX-20260330102535', '840776204839', '901341311777', 'BKO177484113684561005032787', 10000, '20260330102536', 'SUGI ANTORO', 'METODE BI-FAST', 'SEABANK INDONESIA', '535', 'Sukses', 'TRANSFER BANK', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132629, 138093, 'WEHI', 'keluar', 2, 1, 1, 0, 1, 0, 31344, 0, 65, 300, 0, 'Cetak Voucher Aigo Axis', 'HangLengkir', 'jayabersamatcc@gmail.com', '57796608', NULL, 'ORDER_KUOTA', 761940, 730596, '2026-03-30 10:32:43', 'TRX20260330103243001', '138093-20260330103305-31344', '1161430000262231', 'OISI847763260330103305451', 31579, 'T#1142784946', 'MDP-H2H', 'API- AXIS', 'Axis', 'TVK5G', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132630, 138152, 'X8lf', 'masuk', 0, 0, 1, 0, 1, 0, 250000, 1, 3500, 0, 0, 'DEPOSIT VIA VIRTUAL ACCOUNT', 'LISDA MANIS', 'lisdaayunda241@gmail.com', '57796638', 'X8lf', NULL, 293914, 543914, '2026-03-30 10:33:05', '3855346531', '2026117070177906', '1604041498245679', 'MDP25350020260330103305', 253500, '2026117070177906', 'MDP Digital - Pasmurah', '-', 'BRI', '002', 'SUCCESS', 'VIRTUAL ACCOUNT', NULL, NULL, '0', NULL, NULL, NULL),
(132631, 138042, 'SfdX', 'keluar', 2, 1, 1, 0, 1, 0, 15300, 0, 75, 250, 0, 'By U 15.000', 'MDP PAYMENT', 'mdp@mdppulsa.my.id', '57801700', NULL, 'ORDER_KUOTA', 112563, 97263, '2026-03-30 11:36:40', 'TRX20260330113639428', '138042-20260330113642-15300', '085199764917', '04106400001505945184', 15475, 'T#1142879286', 'MDP-H2H', 'API- ByU', 'ByU', 'BYU15', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132632, 138146, 'WLna', 'masuk', 0, 0, 1, 0, 1, 0, 49798, 1, 326, 0, 75, 'DEPOSIT USER VIA QRIS', 'Lamin Kristy ', 'rahmikristi@gmail.com', '57806734', 'WLna', NULL, 49798, 99596, '2026-03-30 12:37:27', '321838294', '018491866952', 'PDN0000007350', 'QRA177484896402389809907239', 50000, '2026117070177907', 'Mitra cell', 'LA************** - Lamin Kristy', 'DANA', 'QRIS DINAMIS', 'Successful', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132633, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 19870, 1, 140, 10, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 71661, 91531, '2026-03-30 12:37:32', 'EXT177484905178262500250058', 'AX4U1MFOA4S2', 'PDN0000007545', 'REF177484905178262401640479', 20000, 'AX4U1MFOA4S2', 'ZARFAN STORE', '6285749711298', 'SHOPEEPAY', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132634, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 19870, 1, 140, 10, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 91531, 111401, '2026-03-30 12:38:02', 'EXT177484908222141908370269', 'AX4U1MFOA5KH', 'PDN0000007545', 'REF177484908222141800470189', 20000, 'AX4U1MFOA5KH', 'ZARFAN STORE', '6285749711298', 'SHOPEEPAY', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132635, 138146, 'YzL', 'masuk', 0, 0, 1, 0, 1, 0, 98500, 1, 3500, 0, 0, 'DEPOSIT VIA VIRTUAL ACCOUNT', 'Sabina Tsarwah', 'dedyhartanto08@gmail.com', '57808583', 'YzL', NULL, 387, 98887, '2026-03-30 12:59:59', '9035647499', '2026117070177909', '1604050069382326', 'MDP10200020260330125959', 102000, '2026117070177909', 'MDP Digital - MITRA BAYAR', '-', 'BRI', '002', 'SUCCESS', 'VIRTUAL ACCOUNT', NULL, NULL, '0', NULL, NULL, NULL),
(132636, 138146, 'WLna', 'keluar', 2, 1, 1, 0, 1, 0, 51845, 0, 75, 100, 0, 'H2H Token PLN 50.000', 'Lamin Kristy ', 'rahmikristi@gmail.com', '57808872', NULL, 'ORDER_KUOTA', 148685, 96840, '2026-03-30 13:03:18', 'TRX20260330130317349', '138146-20260330130318-51845', '14397831406', '2312-8748-3544-3223-6580/RUDI/R1M/900VA/33.7 KWH', 51870, 'T#1143000853', 'MDP-H2H', 'API- TOKEN', 'TOKEN', 'PLNB50', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132637, 138217, 'Wb6N', 'masuk', 0, 0, 1, 0, 1, 0, 10000, 1, 3500, 0, 0, 'DEPOSIT VIA VIRTUAL ACCOUNT', 'Riko Nopersyah ', 'nazwasulaiman@gmail.com', '57810022', 'Wb6N', NULL, 879183, 889183, '2026-03-30 13:16:05', '3424724119', '2026117070177911', '1604051290162497', 'MDP1350020260330131605', 13500, '2026117070177911', 'MDP Digital - DigitalPay', '-', 'BRI', '002', 'SUCCESS', 'VIRTUAL ACCOUNT', NULL, NULL, '0', NULL, NULL, NULL),
(132638, 138146, 'WLna', 'keluar', 2, 1, 1, 0, 1, 0, 45113, 0, 75, 100, 0, 'Dana 45.000', 'Lamin Kristy ', 'rahmikristi@gmail.com', '57810998', NULL, 'ORDER_KUOTA', 96840, 51727, '2026-03-30 13:26:47', 'TRX20260330132646188', '138146-20260330132649-45113', '085212537057', 'DNID LAMXX MANXXXXXXX/45000/2026033010121481030100166521795668006', 45138, 'T#1143033220', 'MDP-H2H', 'API- dana', 'dana', 'D45', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132639, 138146, 'WLna', 'keluar', 2, 1, 1, 0, 1, 0, 2113, 0, 75, 100, 0, 'Dana 2.000', 'Lamin Kristy ', 'rahmikristi@gmail.com', '57812829', NULL, 'ORDER_KUOTA', 51727, 49614, '2026-03-30 13:48:34', 'TRX20260330134833768', '138146-20260330134836-2113', '085212537057', 'DNID LAMXX MANXXXXXXX/2000/2026033010121481030100166521795658908', 2138, 'T#1143062404', 'MDP-H2H', 'API- dana', 'dana', 'D2', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132640, 138042, 'SfdX', 'keluar', 2, 0, 1, 0, 1, 0, 10000, 0, 2000, 1500, 0, 'SEABANK INDONESIA', 'MDP PAYMENT', 'mdp@mdppulsa.my.id', '57816655', NULL, NULL, 106135, 94135, '2026-03-30 14:29:31', 'TRX-BANK-138042-SfdX-20260330142931', '118307055706', '901341311777', 'BKO177485577189433305343332', 10000, '20260330142932', 'SUGI ANTORO', 'METODE BI-FAST', 'SEABANK INDONESIA', '535', 'Sukses', 'TRANSFER BANK', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132641, 138042, 'SfdX', 'keluar', 2, 0, 1, 0, 1, 0, 10000, 0, 2000, 1500, 0, 'SEABANK INDONESIA', 'MDP PAYMENT', 'mdp@mdppulsa.my.id', '57817851', NULL, NULL, 94135, 82135, '2026-03-30 14:41:13', 'TRX-BANK-138042-SfdX-20260330144113', '758197252629', '901341311777', 'BKO177485647518797907384870', 10000, '20260330144114', 'SUGI ANTORO', 'METODE BI-FAST', 'SEABANK INDONESIA', '535', 'Sukses', 'TRANSFER BANK', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132642, 138042, 'SfdX', 'keluar', 2, 0, 1, 0, 1, 0, 10000, 0, 2000, 1500, 0, 'SEABANK INDONESIA', 'MDP PAYMENT', 'mdp@mdppulsa.my.id', '57818424', NULL, NULL, 1000000, 988000, '2026-03-30 14:47:29', 'TRX-BANK-138042-SfdX-20260330144729', '231481612926', '901341311777', 'BKO177485685176982605997752', 10000, '20260330144730', 'SUGI ANTORO', 'METODE BI-FAST', 'SEABANK INDONESIA', '535', 'Sukses', 'TRANSFER BANK', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132643, 138172, 'UDgE', 'masuk', 0, 0, 1, 0, 1, 0, 10048, 1, 66, 0, 75, 'DEPOSIT USER VIA QRIS', 'tau Rtu', 'taurtu95@gmail.com', '57818977', 'UDgE', NULL, 0, 10048, '2026-03-30 14:53:32', '4727193430', '001089919941', 'PDN0000007543', 'QRA177485527402553504506982', 10000, '2026117070177912', 'Retikashop', 'GOPAY - tau Rtu', 'GOPAY', 'QRIS DINAMIS', 'Successful', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132644, 138217, 'SHje', 'keluar', 2, 1, 1, 0, 1, 0, 889000, 0, 100, 400, 100, 'Dana Topup (Bebas Nominal)', 'Eko Prasetiyo', 'ekopay2@gmail.com', '57820513', NULL, 'ORDER_KUOTA', 889183, 35, '2026-03-30 15:10:32', 'TRX20260330151031905', '138217-20260330151034-889000', '083895945079', 'DNID EXX PRAXXXXXX/889000/2026033010121481030100166722692275997', 889448, 'T#1143167164', 'MDP-H2H', 'API- dana', 'dana', 'BBSD', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132645, 138042, 'SvT9', 'keluar', 2, 1, 1, 0, 1, 0, 69200, 0, 75, 250, 0, 'Telkomsel 70.000', 'azahra ', 'yanialzahra@gmail.com', '57821892', NULL, 'ORDER_KUOTA', 988000, 918800, '2026-03-30 15:27:21', 'TRX20260330152720103', '138042-20260330152724-69200', '081367163041', '04106700001511687407', 69375, 'T#1143189412', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S70', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132646, 138044, 'WHDZ', 'masuk', 0, 0, 1, 0, 1, 0, 39740, 1, 280, 20, 0, 'PEMBAYARAN VIA QRIS', 'Willy Saputra Pratama ', 'officialwilly22@gmail.com', 'ID1026488901533', NULL, NULL, 39740, 79480, '2026-03-30 15:30:41', 'EXT177485944041674705990005', '018341294995', 'PDN0000012994', 'REF177485944041674601610430', 40000, '018341294995', 'LELEK GAMING STORE', '08**********', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132647, 138172, 'SHAd', 'masuk', 0, 0, 1, 0, 1, 0, 198, 1, 2, 1, 0, 'PEMBAYARAN VIA QRIS', 'Muhamad khoerudin', 'muhama.paus97@gmail.com', 'ID1026484768225', NULL, NULL, 10048, 10246, '2026-03-30 16:15:47', 'EXT177486214590369702090339', '018313807549', 'PDN0000012690', 'REF177486214590369606690325', 200, '018313807549', 'KOLAM RENANG WICEK', 'MU***************', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132648, 138172, 'SHAd', 'masuk', 0, 0, 1, 0, 1, 0, 1490, 1, 11, 2, 0, 'PEMBAYARAN VIA QRIS', 'Muhamad khoerudin', 'muhama.paus97@gmail.com', 'ID1026484768225', NULL, NULL, 10246, 11736, '2026-03-30 16:17:09', 'EXT177486222811445704780243', '117461708792', 'PDN0000012690', 'REF177486222811445603070882', 1500, '117461708792', 'KOLAM RENANG WICEK', 'MUHAMAD KHOERUDIN', 'BANK RAKYAT INDONESIA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132649, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 5299, 0, 75, 300, 0, 'Telkomsel 5.000', 'Widiaandriko', 'widiaandriko21@gmail.com', '57828229', NULL, 'ORDER_KUOTA', 731589, 726290, '2026-03-30 16:33:23', 'TRX20260330163322759', '138093-20260330163335-5299', '081275770148', '04106100001513666411', 5524, 'T#1143277724', 'MDP-H2H', 'API- Telkomsel', 'Telkomsel', 'S5', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132650, 137992, 'RC5h', 'keluar', 2, 1, 1, 0, 1, 0, 15113, 0, 75, 300, 0, 'Dana 15.000', 'Putri naIfa Syaqila', 'naifaasyaqilla03@gmail.com', '57829399', NULL, 'ORDER_KUOTA', 76355, 61242, '2026-03-30 16:44:51', 'TRX20260330164450547', '137992-20260330164452-15113', '085652170947', 'DNID SALXXXX/15000/2026033010121481030100166274397038978', 15338, 'T#1143294031', 'MDP-H2H', 'API -  dana', 'dana', 'D15', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132651, 137992, 'RC5h', 'keluar', 2, 1, 1, 0, 1, 0, 5113, 0, 75, 300, 0, 'Dana 5.000', 'Putri naIfa Syaqila', 'naifaasyaqilla03@gmail.com', '57829512', NULL, 'ORDER_KUOTA', 61242, 56129, '2026-03-30 16:45:53', 'TRX20260330164552263', '137992-20260330164554-5113', '085652170947', 'DNID SALXXXX/5000/2026033010121481030100166274397065951', 5338, 'T#1143295539', 'MDP-H2H', 'API -  dana', 'dana', 'D5', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132652, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831389', NULL, 'ORDER_KUOTA', 726290, 719996, '2026-03-30 17:05:47', 'TRX20260330170547001', '138093-20260330170607-6294', '1156690000991845', 'OISI847765260330170606330', 6529, 'T#1143325299', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132653, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831389', NULL, 'ORDER_KUOTA', 719996, 713702, '2026-03-30 17:05:48', 'TRX20260330170548002', '138093-20260330170607-6294', '1156690000991846', 'OISI847763260330170606848', 6529, 'T#1143325318', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132654, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831389', NULL, 'ORDER_KUOTA', 713702, 707408, '2026-03-30 17:05:49', 'TRX20260330170549003', '138093-20260330170608-6294', '1156690000991847', 'OISI452424260330170607916', 6529, 'T#1143325329', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132655, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 6294, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831389', NULL, 'ORDER_KUOTA', 707408, 701114, '2026-03-30 17:05:50', 'TRX20260330170550004', '138093-20260330170609-6294', '1156690000991848', 'OISI847762260330170608189', 6529, 'T#1143325359', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAS1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132656, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831587', NULL, 'ORDER_KUOTA', 701114, 690385, '2026-03-30 17:07:23', 'TRX20260330170723001', '138093-20260330170807-10729', '1156690000991849', 'OISI452427260330170806906', 10964, 'T#1143328377', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132657, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831587', NULL, 'ORDER_KUOTA', 690385, 679656, '2026-03-30 17:07:24', 'TRX20260330170724002', '138093-20260330170808-10729', '1156690000991850', 'OISI847765260330170807335', 10964, 'T#1143328387', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132658, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831587', NULL, 'ORDER_KUOTA', 679656, 668927, '2026-03-30 17:07:25', 'TRX20260330170725003', '138093-20260330170808-10729', '1156690000991851', 'OISI452427260330170807223', 10964, 'T#1143328391', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132659, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831587', NULL, 'ORDER_KUOTA', 668927, 658198, '2026-03-30 17:07:26', 'TRX20260330170726004', '138093-20260330170808-10729', '1156690000991852', 'OISI847765260330170807912', 10964, 'T#1143328399', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132660, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831587', NULL, 'ORDER_KUOTA', 658198, 647469, '2026-03-30 17:07:27', 'TRX20260330170727005', '138093-20260330170808-10729', '1156690000991853', 'OISI452427260330170807822', 10964, 'T#1143328406', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132661, 138093, 'UGRh', 'keluar', 0, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831587', NULL, 'ORDER_KUOTA', 647469, 636740, '2026-03-30 17:07:28', 'TRX20260330170728006', '138093-20260330170809-10729', '1156690000991854', 'OISI847761260330170808752', 10964, 'T#1143328427', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132662, 138093, 'UGRh', 'keluar', 0, 0, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831587', NULL, 'ORDER_KUOTA', 636740, 626011, '2026-03-30 17:07:29', 'TRX20260330170729007', NULL, '1156690000991855', 'OISI847763260330170808850', 10964, NULL, NULL, 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132663, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 10729, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831587', NULL, 'ORDER_KUOTA', 626011, 615282, '2026-03-30 17:07:30', 'TRX20260330170730008', '138093-20260330170810-10729', '1156690000991856', 'OISI452424260330170809321', 10964, 'T#1143328443', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAB1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132664, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15583, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831687', NULL, 'ORDER_KUOTA', 615282, 599699, '2026-03-30 17:08:20', 'TRX20260330170820001', '138093-20260330170906-15583', '1156690000991857', 'OISI847763260330170906136', 15818, 'T#1143329929', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132665, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15583, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831687', NULL, 'ORDER_KUOTA', 599699, 584116, '2026-03-30 17:08:21', 'TRX20260330170821002', '138093-20260330170907-15583', '1156690000991858', 'OISI452427260330170906274', 15818, 'T#1143329949', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132666, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15583, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831687', NULL, 'ORDER_KUOTA', 584116, 568533, '2026-03-30 17:08:22', 'TRX20260330170822003', '138093-20260330170907-15583', '1156690000991859', 'OISI847761260330170906603', 15818, 'T#1143329955', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132667, 138093, 'UGRh', 'keluar', 2, 1, 1, 0, 1, 0, 15583, 0, 65, 300, 0, 'Cetak Voucher Mini Axis 1-3 Hari', 'Widiaandriko', 'widiaandriko21@gmail.com', '57831687', NULL, 'ORDER_KUOTA', 568533, 552950, '2026-03-30 17:08:23', 'TRX20260330170823004', '138093-20260330170907-15583', '1156690000991860', 'OISI452427260330170906700', 15818, 'T#1143329960', 'MDP-H2H', 'API- AXIS', 'Axis', 'CAM4', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132668, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 9984, 1, 70, 5, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 79480, 89464, '2026-03-30 17:14:15', 'EXT177486565348929507270111', '1n351ft75911', 'PDN0000007545', 'REF177486565348929405730940', 10050, '1n351ft75911', 'ZARFAN STORE', 'PA**************', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132669, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 17883, 1, 126, 9, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 89464, 107347, '2026-03-30 17:19:55', 'EXT177486599426043500380479', '010000BW6X4X', 'PDN0000007545', 'REF177486599426043506700489', 18000, '010000BW6X4X', 'ZARFAN STORE', 'WATI', 'SEABANK', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132670, 138152, 'XBEd', 'keluar', 2, 1, 1, 0, 1, 0, 100113, 0, 75, 0, 0, 'Dana 100.000', 'Wildan Jaelani', 'zaelaniw80@gmail.com', '57834259', NULL, 'ORDER_KUOTA', 543914, 443801, '2026-03-30 17:33:53', 'TRX20260330173352520', '138152-20260330173354-100113', '085643694546', 'DNID SITX NURXXXX/100000/2026033010121481030100166584197069114', 100038, 'T#1143367789', 'MDP-H2H', 'API- dana', 'dana', 'D100', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132671, 138052, 'BZy6', 'keluar', 2, 1, 1, 0, 1, 0, 21840, 0, 75, 100, 0, 'Promo Token PLN 20 Ribu', 'Egi Vitriansyah', 'egilovelisna@gmail.com', '57834306', NULL, 'ORDER_KUOTA', 464847, 443007, '2026-03-30 17:34:19', 'TRX20260330173417539', '138052-20260330173420-21840', '535352015095', '3101-8164-0533-7791-0677/TARSONO/R1M/900VA/13.9 KWH', 21865, 'T#1143368437', 'MDP-H2H', 'API- TOKEN', 'TOKEN', 'PLNP20', 'SUKSES', 'PRABAYAR', NULL, NULL, 'failed', 'HTTP Code: 404', '2026-03-30 17:36:17', 'bukaolshop'),
(132672, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 20863, 1, 147, 11, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 107347, 128210, '2026-03-30 17:42:31', 'EXT177486734993378101660728', '018295636590', 'PDN0000007545', 'REF177486734993378107550201', 21000, '018295636590', 'ZARFAN STORE', 'CH*****', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132673, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 7948, 1, 56, 4, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 128210, 136158, '2026-03-30 17:43:41', 'EXT177486741942012304560113', '1n35vfn92713', 'PDN0000007545', 'REF177486741942012204310869', 8000, '1n35vfn92713', 'ZARFAN STORE', 'JO****************************', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL),
(132674, 138055, 'VrgE', 'keluar', 2, 1, 1, 0, 1, 0, 118864, 0, 75, 200, 0, 'Indosat 125.000', 'Abdulhakim ', 'abdulhakim56935@gmail.com', '57838835', NULL, 'ORDER_KUOTA', 348836, 229972, '2026-03-30 18:22:09', 'TRX20260330182208229', '138055-20260330182211-118864', '085866018301', '04106400035365050694', 118989, 'T#1143443212', 'MDP-H2H', 'API- Indosat', 'Indosat', 'I125', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132675, 138055, 'VrgE', 'keluar', 1, 1, 1, 0, 1, 1, 14425, 0, 75, 250, 0, 'Masa Aktif Indosat + 30 Hari', 'Abdulhakim ', 'abdulhakim56935@gmail.com', '57839904', NULL, 'ORDER_KUOTA', 229972, 229972, '2026-03-30 18:32:11', 'TRX20260330183209203', '138055-20260330183856-14425', '085866018301', 'GAGAL. Cek kembali nomor tujuan Anda..', 14600, 'T#1143459604', 'MDP-H2H', 'API- Indosat', 'Indosat', 'IMSA1', 'GAGAL', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, 'bukaolshop'),
(132676, 138042, 'SfdX', 'keluar', 2, 1, 1, 0, 1, 0, 1113, 0, 75, 200, 0, 'Dana 1.000', 'mdppayment', 'andi@gmail.com', '#ID:225685250944', NULL, 'ORDER_KUOTA', 918800, 917687, '2026-03-30 18:52:22', 'TRX202603301852222945', '138042-20260330185223-1113', '082378202807', 'DNID SUGX ANTXXX/1000/2026033010121481030100166363395018765', 1238, 'T#1143496232', 'MDP-H2H', 'API - dana', 'wallet dana', 'D1', 'SUKSES', 'PRABAYAR', NULL, NULL, '0', NULL, NULL, NULL),
(132677, 138044, 'V9Nw', 'masuk', 0, 0, 1, 0, 1, 0, 19870, 1, 140, 10, 0, 'PEMBAYARAN VIA QRIS', 'MISBAH', 'zahiramantap88@gmail.com', 'ID1026474417296', NULL, NULL, 136158, 156028, '2026-03-30 18:58:37', 'EXT177487191607672008330722', '018439399514', 'PDN0000007545', 'REF177487191607671909160505', 20000, '018439399514', 'ZARFAN STORE', 'AN***', 'DANA', 'QRIS STATIS', 'success', 'QRIS', NULL, NULL, '0', NULL, NULL, NULL);

--
-- Trigger `transaksi_tenant`
--
DELIMITER $$
CREATE TRIGGER `trg_transaksi_tenant_ke_reseller` AFTER INSERT ON `transaksi_tenant` FOR EACH ROW BEGIN

DECLARE saldo_lama DECIMAL(15,2);
DECLARE saldo_baru DECIMAL(15,2);
DECLARE v_id_reseller INT;

IF 
    NEW.tipe = 'masuk'
    AND (
        NEW.partner_reff LIKE 'QRA%' 
        OR NEW.partner_reff LIKE 'VA-%'
    )
THEN

    /* Ambil saldo reseller yang SUDAH terupdate */
    SELECT saldo, id
    INTO saldo_baru, v_id_reseller
    FROM reseller
    WHERE kode_agen = NEW.kode_agen
    LIMIT 1;

    /* Hitung saldo sebelum (saldo sekarang - amount) */
    SET saldo_lama = saldo_baru - NEW.amount;

    /* Insert ke mutasi_reseller */
    INSERT INTO mutasi_reseller (
        id_reseller,
        partner_reff,
        serialnumber,
        rrn,
        accountnumber,
        accountname,
        bankname,
        respon_desc,
        kode_agen,
        user_id,
        payment_reff,
        keterangan,
        admin,
        saldo_sebelum,
        saldo_sesudah,
        nominal,
        bankcode,
        type,
        tipe,
        spl,
        res_spl
    )
    VALUES (
        v_id_reseller,
        NEW.partner_reff,
        NEW.serialnumber,
        NEW.rrn,
        NEW.accountnumber,
        NEW.accountname,
        NEW.bankname,
        NEW.respon_desc,
        NEW.kode_agen,
        NEW.user_id,
        NEW.payment_reff,
        NEW.keterangan,
        NEW.markup_server,
        saldo_lama,
        saldo_baru,
        NEW.amount,
        NEW.bankcode,
        'Deposit',
        NEW.tipe,
        'MDP',
        'deposit_sukses'
    );

END IF;

END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `trg_update_mutasi_reseller` AFTER UPDATE ON `transaksi_tenant` FOR EACH ROW BEGIN

    UPDATE mutasi_reseller
    SET 
        serialnumber = IF(NEW.serialnumber IS NOT NULL AND NEW.serialnumber != '', NEW.serialnumber, serialnumber),
        respon_desc  = IF(NEW.respon_desc IS NOT NULL AND NEW.respon_desc != '', NEW.respon_desc, respon_desc),
        payment_reff = IF(NEW.payment_reff IS NOT NULL AND NEW.payment_reff != '', NEW.payment_reff, payment_reff),
        accountname  = IF(NEW.accountname IS NOT NULL AND NEW.accountname != '', NEW.accountname, accountname),
        bankname     = IF(NEW.bankname IS NOT NULL AND NEW.bankname != '', NEW.bankname, bankname),
        meter_awal_meter_akhir = CONCAT_WS('-', 
            IFNULL(NEW.meter_awal, ''), 
            IFNULL(NEW.meter_akhir, '')
        )
    WHERE partner_reff = NEW.partner_reff;

END
$$
DELIMITER ;

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `transaksi_tenant`
--
ALTER TABLE `transaksi_tenant`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `partner_reff` (`partner_reff`),
  ADD KEY `idx_mutasi_user_agen` (`user_id`,`kode_agen`,`created_at`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_user_id` (`user_id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `transaksi_tenant`
--
ALTER TABLE `transaksi_tenant`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149841;
COMMIT;

