Portions created by the Initial Developer are Copyright (C) 2008-2024 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ //includes files require_once dirname(__DIR__, 2) . "/resources/require.php"; require_once "resources/check_auth.php"; //check permissions if (!permission_exists('contact_time_view')) { echo "access denied"; exit; } //set from session variables $list_row_edit_button = $settings->get('theme', 'list_row_edit_button', false); //set the uuid if (!empty($_GET['id']) && is_uuid($_GET['id'])) { $contact_uuid = $_GET['id']; } //set the time zone date_default_timezone_set($settings->get('domain', 'time_zone', date_default_timezone_get())); //set the time format options: 12h, 24h if ($settings->get('domain', 'time_format') == '24h') { $time_format = 'H:i:s'; } else { $time_format = 'h:i:s a'; } //get the contact list $sql = "select ct.*, u.username, u.domain_uuid as user_domain_uuid "; $sql .= "from v_contact_times as ct, v_users as u "; $sql .= "where ct.user_uuid = u.user_uuid "; $sql .= "and ct.domain_uuid = :domain_uuid "; $sql .= "and ct.contact_uuid = :contact_uuid "; $sql .= "order by ct.time_start desc "; $parameters['domain_uuid'] = $domain_uuid; $parameters['contact_uuid'] = $contact_uuid ?? ''; $contact_times = $database->select($sql, $parameters, 'all'); unset($sql, $parameters); //show if exists if (!empty($contact_times)) { //show the content echo "
\n"; echo "
".$text['header_contact_times']."
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; if (permission_exists('contact_time_delete')) { echo " \n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; if (permission_exists('contact_time_edit') && $list_row_edit_button) { echo " \n"; } echo "\n"; if (!empty($contact_times)) { $x = 0; foreach ($contact_times as $row) { if (!empty($row["time_start"]) && !empty($row['time_stop'])) { $time_start = strtotime($row["time_start"]); $time_stop = strtotime($row['time_stop']); $time = gmdate($time_zone, ($time_stop - $time_start)); } else { unset($time); } $tmp = explode(' ', $row['time_start']); $time_start = $tmp[0]; $list_row_url = ''; if (permission_exists('contact_time_edit')) { $list_row_url = "contact_time_edit.php?contact_uuid=".urlencode($row['contact_uuid'])."&id=".urlencode($row['contact_time_uuid']); if ($row['domain_uuid'] != $_SESSION['domain_uuid'] && permission_exists('domain_select')) { $list_row_url .= '&domain_uuid='.urlencode($row['domain_uuid']).'&domain_change=true'; } } echo "\n"; if (permission_exists('contact_time_delete')) { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (permission_exists('contact_time_edit') && $list_row_edit_button) { echo " \n"; } echo "\n"; $x++; } unset($contact_times); } echo "
\n"; echo " \n"; echo " ".$text['label-time_user']."".$text['label-time_start']."".$text['label-time_duration']."".$text['label-time_description']." 
\n"; echo " \n"; echo " \n"; echo " ".escape($row["username"])." ".$time_start." ".$time." ".escape($row['time_description'])." \n"; echo button::create(['type'=>'button','title'=>$text['button-edit'],'icon'=>$settings->get('theme', 'button_icon_edit'),'link'=>$list_row_url]); echo "
\n"; echo "
\n"; echo "
\n"; } ?>