-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Waktu pembuatan: 27 Apr 2026 pada 12.20
-- Versi server: 10.6.24-MariaDB-cll-lve-log
-- Versi PHP: 8.4.20

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


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

--
-- Database: `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;

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