Public in black, Private Groups in yellow, Non-Published in red
\n"; } $query = "select ItemID,Status,Notes,Description,VideoCaution,VideoConformance,VideoConnection,VideoCredentialsCommunity,VideoCredentialsPassword,VideoCredentialsUsername,VideoE164,VideoGatekeeper,VideoManufacturer,VideoModel,VideoSeatingCapacity,VideoSerial,VideoSoftwareVersion,VideoSystemName,VideoVisibility,VideoVisibilityGroup,VideoVoice,AbbrevName,IP,Device,Interface,Network,Room,City,AddressAsVCARD,LastUpdateStamp from VideoSystems where DbUid=$which"; #CF_Print_Var("query", $query); $result = CF_DB_Select($db, $DB_DEVICES_TYPE, $query); $numrows = CF_DB_Num_Rows($db, $DB_DEVICES_TYPE, $result); if ($numrows <= 0) { echo "No such video system.
"; return; } $ItemID = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 0)); $Status = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 1)); $Notes = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 2)); $Description = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 3)); $VideoCaution = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 4)); $VideoConformance = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 5)); $VideoConnection = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 6)); $VideoCredentialsCommunity = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 7)); $VideoCredentialsPassword = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 8)); $VideoCredentialsUsername = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 9)); $VideoE164 = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 10)); $VideoGatekeeper = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 11)); $VideoManufacturer = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 12)); $VideoModel = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 13)); $VideoSeatingCapacity = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 14)); $VideoSerial = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 15)); $VideoSoftwareVersion = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 16)); $VideoSystemName = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 17)); $VideoVisibility = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 18)); $VideoVisibilityGroup = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 19)); $VideoVoice = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 20)); $AbbrevName = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 21)); $IP = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 22)); $Device = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 23)); $Interface = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 24)); $Network = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 25)); $Room = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 26)); $City = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 27)); $AddressAsVCARD = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 28)); $LastUpdateStamp = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, 0, 29)); if ($VideoVisibilityGroup != "") { if (!CDS_Verify_Video($VideoVisibilityGroup)) { CF_Error_Error("access not permitted"); return; } } elseif ($view == "public" || $view == "video") { if ($VideoVisibility != "Courts" && $VideoVisibility != "HIPAA" && $VideoVisibility != "Public" && $VideoVisibility != "") { CF_Error_Error("access not permitted"); return; } } echo "
Update information on this system.
\n"; } # ------------------------------------------------------------ # Show the contacts function Show_Contacts ($db, $usertype, $view, $tableuid) { global $DB_DEVICES_TYPE; $query = "select ContactUid,ContactType from ContactMap where TableName='VideoSystems' and TableUid=$tableuid order by ContactType"; #CF_Print_Var("query", $query); $match_type = "Site Application"; if ($view == "public" && Show_Contacts_Any_Scheduling($db, $tableuid)) { $match_type = "Site Scheduling"; } $result = CF_DB_Select($db, $DB_DEVICES_TYPE, $query); $numrows = CF_DB_Num_Rows($db, $DB_DEVICES_TYPE, $result); if ($numrows <= 0) { echo "No contacts listed.
\n"; return; } $any = false; for ($i = 0; $i < $numrows; $i++) { $ContactUid = CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, $i, 0); $ContactType = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result, $i, 1)); #CF_Print_Var("ContactUid", $ContactUid); #CF_Print_Var("ContactType", $ContactType); if ($view == "public" && $ContactType != $match_type) { continue; } $query2 = "select Name,EmailAddress,TelephoneNumber from ContactCore where DbUid='$ContactUid'"; #CF_Print_Var("query2", $query2); $result2 = CF_DB_Select($db, $DB_DEVICES_TYPE, $query2); $numrows2 = CF_DB_Num_Rows($db, $DB_DEVICES_TYPE, $result2); if ($numrows2 <= 0) { continue; } $Name = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result2, 0, 0)); $EmailAddress = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result2, 0, 1)); $TelephoneNumber = htmlspecialchars(CF_DB_Get_Field($db, $DB_DEVICES_TYPE, $result2, 0, 2)); #CF_Print_Var("Name", $Name); #CF_Print_Var("EmailAddress", $EmailAddress); #CF_Print_Var("TelephoneNumber", $TelephoneNumber); if ($view == "public") { if (!$any) { echo "contact type | name | phone |
---|
contact type | name | phone |
---|