" . htmlspecialchars($response) . ""; $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE); curl_close($ch); if ($httpCode !== 200) { echo "Error fetching job codes: HTTP Error Code - $httpCode"; return null; } $jobcodes = json_decode($response, true); if (json_last_error() !== JSON_ERROR_NONE) { echo "Error decoding JSON: " . json_last_error_msg(); return null; } return $jobcodes; } // Function to start a regular timesheet for a specific user onto a specific project function startRegularTimesheet($accessToken, $userId, $jobcodeId) { $start = (new DateTime('now', new DateTimeZone('Australia/Brisbane')))->format('Y-m-d\TH:i:sP'); $end = ""; // Active on-the-clock timesheet // Data to start a regular timesheet $regularTimeSheetData = [ "data" => [ [ "user_id" => $userId, "jobcode_id" => $jobcodeId, "start" => $start, // Starting time for the timesheet "type" => "regular", "end" => $end ] ] ]; $timesheetsUrl = "https://api.tsheets.com/api/v1/timesheets"; $headers = [ "Authorization: Bearer $accessToken", "Accept: application/json", "Content-Type: application/json", "User-Agent: QuickBooks-Integration-Script" ]; $ch = curl_init($timesheetsUrl); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST"); echo "
" . htmlspecialchars(json_encode($regularTimeSheetData, JSON_PRETTY_PRINT)) . ""; curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($regularTimeSheetData)); $response = curl_exec($ch); // Check for errors in the API response if ($response === false) { echo "Error starting regular timesheet: " . curl_error($ch); curl_close($ch); return null; } $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE); echo "
" . htmlspecialchars($response) . ""; curl_close($ch); if ($httpCode !== 201) { echo "Error starting regular timesheet: HTTP Error Code - $httpCode"; return null; } $regularTimeSheetResponse = json_decode($response, true); if (json_last_error() !== JSON_ERROR_NONE) { echo "Error decoding JSON: " . json_last_error_msg(); return null; } return $regularTimeSheetResponse; } // Fetch users and find the specified employee $users = getQuickBooksUsers($accessToken); if ($users && isset($users['results']['users'])) { $employeeUserId = null; $employeeName = isset($_GET['employee']) ? strtolower($_GET['employee']) : ''; foreach ($users['results']['users'] as $user) { $fullName = strtolower($user['first_name'] . ' ' . $user['last_name']); if ($fullName == $employeeName) { $employeeUserId = $user['id']; break; } } if ($employeeUserId) { // Fetch job codes and find the correct one based on the query string parameter "job" $jobcodes = getJobCodes($accessToken); if ($jobcodes && isset($jobcodes['results']['jobcodes'])) { $jobcodeId = null; $jobName = isset($_GET['job']) ? strtolower($_GET['job']) : ''; foreach ($jobcodes['results']['jobcodes'] as $jobcode) { if (strtolower($jobcode['name']) == $jobName) { $jobcodeId = $jobcode['id']; break; } } if ($jobcodeId) { // Start regular timesheet for the specified employee onto the specified project $regularTimeSheetResponse = startRegularTimesheet($accessToken, $employeeUserId, $jobcodeId); if ($regularTimeSheetResponse && isset($regularTimeSheetResponse['results']['timesheets'])) { echo "
Successfully started regular timesheet for " . htmlspecialchars($employeeName) . " on the '" . htmlspecialchars($jobName) . "' project.
"; echo "" . htmlspecialchars(json_encode($regularTimeSheetResponse, JSON_PRETTY_PRINT)) . ""; } else { echo "
Failed to start regular timesheet for " . htmlspecialchars($employeeName) . "
"; } } else { echo "Job code for '" . htmlspecialchars($jobName) . "' not found.
"; } } else { echo "Error fetching job codes.
"; } } else { echo "User " . htmlspecialchars($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.
"; ?>