관리자 로그인 - 리워드 플랫폼 출금정산 시스템

.*, ba.bank_name, ba.account_holder, CONCAT(SUBSTRING(ba.account_number, 1, 3), '****', SUBSTRING(ba.account_number, -4)) as masked_account FROM withdrawals w JOIN bank_accounts ba ON w.bank_account_id = ba.id WHERE w.user_id = ? ORDER BY w.created_at DESC LIMIT ? OFFSET ? "); $stmt->execute([$userId, $limit, $offset]); return $stmt->fetchAll(PDO::FETCH_ASSOC); } public function getRequestsForAdmin($filters = [], $limit = 50, $offset = 0) { $where = ["1=1"]; $params = []; if (!empty($filters['status'])) { $where[] = "w.status = ?"; $params[] = $filters['status']; } if (!empty($filters['user_name'])) { $where[] = "u.name LIKE ?"; $params[] = "%{$filters['user_name']}%"; } if (!empty($filters['date_from'])) { $where[] = "DATE(w.created_at) >= ?"; $params[] = $filters['date_from']; } if (!empty($filters['date_to'])) { $where[] = "DATE(w.created_at) <= ?"; $params[] = $filters['date_to']; } $whereClause = implode(" AND ", $where); $params[] = $limit; $params[] = $offset; $stmt = $this->db->prepare(" SELECT w 관리자 로그인 - 리워드 플랫폼 출금정산 시스템