import React, { useState, useEffect } from 'react'; import { useRouter } from 'next/router'; import LoadingSpinner from 'ui/components/LoadingSpinner'; const AdminCoworkersList = () => { const router = useRouter(); const [coworkers, setCoworkers] = useState([]); const [page, setPage] = useState(1); const [totalPages, setTotalPages] = useState(1); const [isAdmin, setIsAdmin] = useState(true); const [loading, setLoading] = useState(true); const [error, setError] = useState(''); const [cancelCoworkerId, setCancelCoworkerId] = useState(null); const [cancelCoworkerName, setCancelCoworkerName] = useState(''); const [showCancelModal, setShowCancelModal] = useState(false); const [showDetailModal, setShowDetailModal] = useState(false); const [selectedCoworker, setSelectedCoworker] = useState(null); const [inProgress, setInProgress] = useState(false); const [userData, setUserData] = useState(); const pageSize = 1000; const charLimit = 50; // Character limit for truncation const [location, setLocation] = useState(""); const [date, setDate] = useState("all-time"); const getCookie = (name) => { try { const cookies = document.cookie.split(';').map(cookie => cookie.trim()); const cookie = cookies.find(c => c.startsWith(`${name}=`)); if (!cookie) return null; const value = cookie.split('=')[1]; return value ? decodeURIComponent(value) : null; } catch (error) { console.error(`Error fetching cookie ${name}:`, error); router.push('/login'); return null; } }; useEffect(() => { const token = getCookie('nexudus.auth.public.v4.token'); if (!token) { router.push('/login'); return; } checkAdminStatus(); }, [page]); const checkAdminStatus = async () => { try { const token = getCookie('nexudus.auth.public.v4.token'); const response = await fetch('https://theqube.spaces.nexudus.com/en/user/me', { headers: { Authorization: `Bearer ${token}` } }); if (!response.ok) throw new Error('Failed to fetch user info'); const user = await response.json(); const isAdminUser = user?.IsAdmin || user?.Roles?.includes('admin'); // adjust this based on actual fields setIsAdmin(isAdminUser); if (isAdminUser) fetchCoworkers(); else setLoading(false); } catch (err) { console.error('Error checking admin status:', err); setIsAdmin(false); setLoading(false); } }; useEffect(() => { // if(location !== '' || date !== ''){ fetchCoworkers(); // } }, [location, date]) function getDateRange(filterOption) { const now = new Date(); now.setHours(0, 0, 0, 0); // Start of today in UTC let fromDate, toDate; switch (filterOption) { case 'this-week': const currentDay = now.getDay(); fromDate = new Date(now); fromDate.setDate(now.getDate() - (currentDay === 0 ? 6 : currentDay - 1)); // Monday fromDate.setHours(0, 0, 0, 0); toDate = new Date(fromDate); toDate.setDate(fromDate.getDate() + 6); // Sunday toDate.setHours(23, 59, 59, 999); break; case 'last-week': fromDate = new Date(now); const daysToLastMonday = now.getDay() === 0 ? 13 : now.getDay() + 6; // Back to previous Monday fromDate.setDate(now.getDate() - daysToLastMonday); fromDate.setUTCHours(0, 0, 0, 0); toDate = new Date(fromDate); toDate.setDate(fromDate.getDate() + 6); // Sunday toDate.setUTCHours(23, 59, 59, 999); break; case 'this-month': fromDate = new Date(now.getFullYear(), now.getMonth(), 1); toDate = new Date(now.getFullYear(), now.getMonth() + 1, 0); toDate.setHours(23, 59, 59, 999); break; case 'last-month': fromDate = new Date(now.getFullYear(), now.getMonth() - 1, 1); toDate = new Date(now.getFullYear(), now.getMonth(), 0); toDate.setHours(23, 59, 59, 999); break; case 'last-6-months': fromDate = new Date(now.getFullYear(), now.getMonth() - 5, 1); toDate = new Date(now); toDate.setHours(23, 59, 59, 999); break; case 'last-12-months': fromDate = new Date(now.getFullYear(), now.getMonth() - 11, 1); toDate = new Date(now); toDate.setHours(23, 59, 59, 999); break; case 'all-time': fromDate = null; toDate = null; break; default: throw new Error(`Unknown filter option: ${filterOption}`); } return { from: fromDate ? fromDate.toISOString() : null, to: toDate ? toDate.toISOString() : null, }; } function isDateInRange(customDateStr, fromStr, toStr) { if (!fromStr && !toStr) return !!customDateStr; // All-time: include any valid date if (!customDateStr) return false; // Skip if no exit date const customDate = new Date(customDateStr); if (isNaN(customDate.getTime())) return false; // Skip invalid dates const fromDate = fromStr ? new Date(fromStr) : null; const toDate = toStr ? new Date(toStr) : null; if (fromDate && customDate < fromDate) return false; if (toDate && customDate > toDate) return false; return true; } const fetchCoworkers = async () => { setLoading(true); try { const token = getCookie('nexudus.auth.public.v4.token'); const { from, to } = getDateRange(date); const params = new URLSearchParams({ page, size: pageSize, Coworker_Custom20: 'applied', }); if (location && location !== '') { params.append('Coworker_Custom13', location); } const url = `https://theqube.spaces.nexudus.com/api/spaces/coworkers?${params.toString()}`; const response = await fetch(url, { headers: { Authorization: `Bearer ${token}` } }); if (!response.ok) throw new Error(`Failed to fetch coworkers: ${response.statusText}`); const data = await response.json(); // Add hasActiveContracts to each coworker (simplified for now) const coworkersWithContracts = data.Records.map(coworker => ({ ...coworker, hasActiveContracts: true })); if(date && date !== null && from !== null && to !== null){ const filteredCoworkers = (from || to) ? coworkersWithContracts.filter(coworker => isDateInRange(coworker.Custom21, from, to)) : coworkersWithContracts; setCoworkers(filteredCoworkers); }else{ setCoworkers(coworkersWithContracts); } setTotalPages(data.TotalPages); } catch (err) { setError(`Error fetching data: ${err.message}`); } finally { setLoading(false); } }; const resetFilters = () => { setDate(""); setLocation(""); // fetchCoworkers(); } // const handleCancelSubscription = async () => { // setLoading(true); // try { // const token = getCookie('nexudus.auth.public.v4.token'); // const contractsResponse = await fetch( // `https://theqube.spaces.nexudus.com/api/billing/coworkercontracts?coworkercontract_coworker=${cancelCoworkerId}&coworkercontract_active=true`, // { headers: { Authorization: `Bearer ${token}` } } // ); // if (!contractsResponse.ok) throw new Error('Failed to fetch contracts'); // const contracts = await contractsResponse.json(); // const coworker = await fetch( // `https://theqube.spaces.nexudus.com/api/spaces/coworkers/${cancelCoworkerId}`, // { headers: { Authorization: `Bearer ${token}` } } // ); // const coworkerData = await coworker.json(); // setUserData(coworkerData); // const response = await fetch( // `https://theqube.spaces.nexudus.com/api/spaces/coworkers/`, // { // method: 'PUT', // headers: { // Authorization: `Bearer ${token}`, // 'Content-Type': 'application/json', // }, // body: JSON.stringify({ // ...coworkerData, // Custom20: "cancelled" // }), // } // ); // for (const contract of contracts.Records) { // const response = await fetch( // `https://theqube.spaces.nexudus.com/api/billing/coworkercontracts`, // { // method: 'PUT', // headers: { // Authorization: `Bearer ${token}`, // 'Content-Type': 'application/json', // }, // body: JSON.stringify({ // ...contract, // Active: false // }), // } // ); // if (!response.ok) throw new Error(`Failed to cancel contract ${contract.Id}`); // } // setError(`Subscription for ${cancelCoworkerName} cancelled successfully!`); // setShowCancelModal(false); // fetchCoworkers(); // } catch (err) { // setError(`Error cancelling subscription: ${err.message}`); // } finally { // setLoading(false); // } // }; const handleCancelSubscription = async () => { setLoading(true); try { const token = getCookie('nexudus.auth.public.v4.token'); // const contractsResponse = await fetch( // `https://theqube.spaces.nexudus.com/api/billing/coworkercontracts?coworkercontract_coworker=${cancelCoworkerId}&coworkercontract_active=true`, // { headers: { Authorization: `Bearer ${token}` } } // ); // if (!contractsResponse.ok) throw new Error('Failed to fetch contracts'); // const contracts = await contractsResponse.json(); const coworker = await fetch( `https://theqube.spaces.nexudus.com/api/spaces/coworkers/${cancelCoworkerId}`, { headers: { Authorization: `Bearer ${token}` } } ); const coworkerData = await coworker.json(); setUserData(coworkerData); const response = await fetch( `https://theqube.spaces.nexudus.com/api/spaces/coworkers/`, { method: 'PUT', headers: { Authorization: `Bearer ${token}`, 'Content-Type': 'application/json', }, body: JSON.stringify({ ...coworkerData, Custom20: "cancelled" }), } ); // for (const contract of contracts.Records) { // const response = await fetch( // `https://theqube.spaces.nexudus.com/api/billing/coworkercontracts`, // { // method: 'PUT', // headers: { // Authorization: `Bearer ${token}`, // 'Content-Type': 'application/json', // }, // body: JSON.stringify({ // ...contract, // Active: false // }), // } // ); // if (!response.ok) throw new Error(`Failed to cancel contract ${contract.Id}`); // } // setError(`Subscription for ${cancelCoworkerName} cancelled successfully!`); setShowCancelModal(false); fetchCoworkers(); } catch (err) { setError(`Error cancelling subscription: ${err.message}`); } finally { setLoading(false); } }; const handlePageChange = (newPage) => { if (newPage >= 1 && newPage <= totalPages) { setPage(newPage); } }; const truncateText = (text, limit) => { if (!text) return 'N/A'; return text.length > limit ? text.substring(0, limit) + '...' : text; }; const handleRowClick = (coworker) => { setSelectedCoworker(coworker); setShowDetailModal(true); }; const generateCSV = (data, filename = 'coworkers.csv') => { // Define the headers for the CSV const headers = [ 'First Name', 'Last Name', 'Location', 'Reason', 'Experience', 'Date', 'Email', 'Plan', 'Aspect Enjoyed Info', 'Returning In Future', 'Returning In Future Info', 'Waived Monthly Membership Fee' 'Creating music/ podcasts/ recording Dj sets', 'Change mind' ]; // Helper function to escape CSV values (handles commas, quotes, and newlines) const escapeCsvValue = (value) => { if (value == null) return 'N/A'; const stringValue = String(value); if (stringValue.includes(',') || stringValue.includes('"') || stringValue.includes('\n')) { return `"${stringValue.replace(/"/g, '""')}"`; } return stringValue; }; // Map the data to CSV rows const csvRows = data.map(coworker => [ escapeCsvValue(coworker.Custom10), escapeCsvValue(coworker.Custom11), escapeCsvValue(coworker.Custom13), escapeCsvValue(coworker.Custom14), escapeCsvValue(coworker.Custom15), escapeCsvValue(coworker.Custom21), escapeCsvValue(coworker.Custom12), escapeCsvValue(coworker.hasActiveContracts ? "Active" : "Inactive"), escapeCsvValue(coworker.Custom16), escapeCsvValue(coworker.Custom17 === "YesIf" ? "Yes" : coworker.Custom17), escapeCsvValue(coworker.Custom18), escapeCsvValue(coworker.Custom19 === 'true' ? 'Yes' : 'No'), escapeCsvValue(coworker.Custom23), escapeCsvValue(coworker.Custom24), ].join(',')); // Combine headers and rows const csvContent = [headers.join(','), ...csvRows].join('\n'); // Create a Blob with the CSV content const blob = new Blob([csvContent], { type: 'text/csv;charset=utf-8;' }); // Create a temporary link to trigger the download const link = document.createElement('a'); const url = URL.createObjectURL(blob); link.setAttribute('href', url); link.setAttribute('download', filename); document.body.appendChild(link); link.click(); document.body.removeChild(link); URL.revokeObjectURL(url); }; const changeStatus = async(cb, coworker) => { setInProgress(true); let isChecked = cb.checked; const token = getCookie('nexudus.auth.public.v4.token'); const coworkerDat = await fetch( `https://theqube.spaces.nexudus.com/api/spaces/coworkers/${coworker.Id}`, { headers: { Authorization: `Bearer ${token}` } } ); const coworkerData = await coworkerDat.json(); const alertBox = document.getElementById("alertBox"); const response = await fetch( `https://theqube.spaces.nexudus.com/api/spaces/coworkers/`, { method: 'PUT', headers: { Authorization: `Bearer ${token}`, 'Content-Type': 'application/json', }, body: JSON.stringify({ ...coworkerData, Custom22: isChecked ? "yes" : "no" }), } ); if (isChecked) { alertBox.innerHTML = `

Checked!

`; } else { alertBox.innerHTML = `

Unchecked!

`; } fetchCoworkers(); setInProgress(false); setTimeout(() => { alertBox.innerHTML = ""; // removes alert }, 3000); } if (!isAdmin) { return (

Access Denied

Only admins can access this page. Please contact{' '} booking@theqube.com .

); } if (loading) { return (

); } return (

Coworkers with Request For Cancel Subscription

{error &&

{error}

}

Qube Location *

Date

{ coworkers.map((coworker) => { return ( // onClick={() => handleRowClick(coworker)} ); }) }

First Name	Last Name	Location	Reason	Experience	Action	Date	Email	Checked
{truncateText(coworker.Custom10, charLimit) \|\| 'N/A'}	{truncateText(coworker.Custom11, charLimit) \|\| 'N/A'}	{truncateText(coworker.Custom13, charLimit) \|\| 'N/A'}	{truncateText(coworker.Custom14, charLimit) \|\| 'N/A'}	{truncateText(coworker.Custom15, charLimit) \|\| 'N/A'}		{truncateText(new Date(coworker.Custom21).toLocaleDateString("en-GB"), charLimit)}	{truncateText(coworker.Email, charLimit)}	changeStatus(e.currentTarget, coworker)} />

Page {page} of {totalPages}

{showCancelModal && ( )} {showDetailModal && selectedCoworker && ( )}

); }; export default AdminCoworkersList;

Access Denied

Coworkers with Request For Cancel Subscription

Confirm Remove From List

Coworker Details

Members Portal

Our additional products and services

1000 credits