'Move the ticket to a client before quoting it.']); exit; } $ticket_sql = mysqli_query( $mysqli, "SELECT asset_id, asset_name, asset_type, category_name, client_id, contact_id, contact_name, ticket_assigned_to, ticket_billable, ticket_category, ticket_created_at, ticket_created_by, ticket_first_response_at, ticket_number, ticket_onsite, ticket_prefix, ticket_priority, ticket_resolved_at, ticket_subject, user_name FROM tickets LEFT JOIN clients ON ticket_client_id = client_id LEFT JOIN contacts ON ticket_contact_id = contact_id LEFT JOIN users ON ticket_assigned_to = user_id LEFT JOIN locations ON ticket_location_id = location_id LEFT JOIN assets ON ticket_asset_id = asset_id LEFT JOIN ticket_statuses ON ticket_status = ticket_status_id LEFT JOIN categories ON ticket_category = category_id WHERE ticket_id = $ticket_id " . clientScopeSql('ticket_client_id') . " LIMIT 1" ); $row = mysqli_fetch_assoc($ticket_sql); $client_id = intval($row['client_id']); // The contract in force's rate, else the default $client_rate_info = contractClientRate($client_id); $client_rate = $client_rate_info['rate']; $ticket_prefix = escapeHtml($row['ticket_prefix']); $ticket_number = intval($row['ticket_number']); $ticket_category = intval($row['ticket_category']); $ticket_category_display = escapeHtml($row['category_name']); $ticket_subject = escapeHtml($row['ticket_subject']); $ticket_priority = escapeHtml($row['ticket_priority']); $ticket_billable = intval($row['ticket_billable']); $ticket_onsite = intval($row['ticket_onsite']); $ticket_created_at = escapeHtml($row['ticket_created_at']); $ticket_created_by = intval($row['ticket_created_by']); $ticket_date = date('Y-m-d g:i A', strtotime($ticket_created_at)); $ticket_first_response_at = escapeHtml($row['ticket_first_response_at']); if ($ticket_first_response_at) { $ticket_first_response_date_time = date('Y-m-d g:i A', strtotime($ticket_first_response_at)); } else { $ticket_first_response_date_time = ''; } $ticket_resolved_at = escapeHtml($row['ticket_resolved_at']); if ($ticket_resolved_at) { $ticket_resolved_date = date('Y-m-d g:i A', strtotime($ticket_resolved_at)); } else { $ticket_resolved_date = ''; } $ticket_assigned_to = intval($row['ticket_assigned_to']); if ($ticket_assigned_to) { $ticket_assigned_agent = escapeHtml($row['user_name']); } else { $ticket_assigned_agent = ''; } $contact_id = intval($row['contact_id']); $contact_name = escapeHtml($row['contact_name']); $asset_id = intval($row['asset_id']); $asset_name = escapeHtml($row['asset_name']); $asset_type = escapeHtml($row['asset_type']); if ($client_id) { enforceClientAccess(); } ob_start(); ?>
Create quote from ticket
">
" max="2999-12-31" value="" required>
is an hour