Portions created by the Initial Developer are Copyright (C) 2008-2015 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ require_once "root.php"; require_once "resources/require.php"; require_once "resources/check_auth.php"; if (!permission_exists('contact_time_add')) { echo "access denied"; exit; } //get contact and time uuids $domain_uuid = $_REQUEST['domain_uuid']; $contact_uuid = $_REQUEST['contact_uuid']; $contact_time_uuid = $_REQUEST['contact_time_uuid']; //get time quantity $sql = "select "; $sql .= "time_start "; $sql .= "from v_contact_times "; $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and contact_time_uuid = :contact_time_uuid "; $sql .= "and user_uuid = :user_uuid "; $sql .= "and contact_uuid = :contact_uuid "; $sql .= "and time_start is not null "; $sql .= "and time_stop is null "; $parameters['domain_uuid'] = $domain_uuid; $parameters['contact_uuid'] = $contact_uuid; $parameters['user_uuid'] = $_SESSION['user']['user_uuid']; $parameters['contact_time_uuid'] = $contact_time_uuid; $database = new database; $row = $database->select($sql, $parameters, 'row'); if (is_array($row) && @sizeof($row) != 0) { $time_start = strtotime($row["time_start"]); $time_now = strtotime(date("Y-m-d H:i:s")); $time_diff = gmdate("H:i:s", ($time_now - $time_start)); echo $time_diff; echo ""; } unset ($sql, $parameters, $row); ?>