" . htmlspecialchars($response) . ""; return null; } $decodedResponse = json_decode($response, true); if (json_last_error() !== JSON_ERROR_NONE) { echo "Error decoding JSON: " . json_last_error_msg(); return null; } return $decodedResponse; } // Function to fetch list of users from QuickBooks Time API function getQuickBooksUsers($accessToken) { $usersUrl = "https://api.tsheets.com/api/v1/users"; $headers = [ "Authorization: Bearer $accessToken", "Accept: application/json", "Content-Type: application/json", "User-Agent: QuickBooks-Integration-Script" ]; return makeCurlRequest($usersUrl, $headers); } // Function to fetch the active timesheet for a user function getActiveTimesheet($accessToken, $userId) { $startDate = (new DateTime('-1 day', new DateTimeZone('Australia/Brisbane')))->format('Y-m-d'); $timesheetsUrl = "https://api.tsheets.com/api/v1/timesheets?user_ids=$userId&on_the_clock=true&start_date=$startDate"; $headers = [ "Authorization: Bearer $accessToken", "Accept: application/json", "Content-Type: application/json", "User-Agent: QuickBooks-Integration-Script" ]; return makeCurlRequest($timesheetsUrl, $headers); } // Function to end a timesheet function endTimesheet($accessToken, $timesheetId) { $end = (new DateTime('now', new DateTimeZone('Australia/Brisbane')))->format('Y-m-d\TH:i:sP'); $timesheetsUrl = "https://rest.tsheets.com/api/v1/timesheets"; $headers = [ "Authorization: Bearer $accessToken", "Accept: application/json", "Content-Type: application/json", "User-Agent: QuickBooks-Integration-Script" ]; $updateData = [ "data" => [ [ "id" => $timesheetId, "end" => $end ] ] ]; echo "
" . htmlspecialchars(json_encode($updateData, JSON_PRETTY_PRINT)) . ""; return makeCurlRequest($timesheetsUrl, $headers, "PUT", $updateData); } if (!isset($_GET['employee'])) { echo "
Error: Employee name must be specified in the query string as 'employee'.
"; exit; } $employeeName = strtolower(trim($_GET['employee'])); // Fetch users and find $employeeName $users = getQuickBooksUsers($accessToken); if ($users && isset($users['results']['users'])) { $employeeUserId = null; foreach ($users['results']['users'] as $user) { if (strcasecmp($user['first_name'] . ' ' . $user['last_name'], $employeeName) == 0) { $employeeUserId = $user['id']; break; } } if ($employeeUserId) { // Fetch active timesheet for the employee $activeTimesheet = getActiveTimesheet($accessToken, $employeeUserId); if ($activeTimesheet && isset($activeTimesheet['results']['timesheets']) && count($activeTimesheet['results']['timesheets']) > 0) { echo "" . htmlspecialchars(json_encode($activeTimesheet, JSON_PRETTY_PRINT)) . ""; $timesheets = array_values($activeTimesheet['results']['timesheets']); $timesheetId = $timesheets[0]['id']; // End the active timesheet $endTimesheetResponse = endTimesheet($accessToken, $timesheetId); if ($endTimesheetResponse && isset($endTimesheetResponse['results']['timesheets'])) { echo "
Successfully ended timesheet for $employeeName.
"; echo "" . htmlspecialchars(json_encode($endTimesheetResponse, JSON_PRETTY_PRINT)) . ""; } else { echo "
Failed to end timesheet for $employeeName.
"; } } else { echo "No active timesheet found for $employeeName.
"; } } else { echo "User $employeeName not found.
"; } } else { echo "Error fetching users.
"; } // Calculate the total time taken to execute the operation $endTime = microtime(true); $executionTime = round($endTime - $startTime, 2); echo "Operation took $executionTime seconds.
"; ?>