\n"; echo " \n"; echo " \n";//background: black; color: white; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; // ====== Network Data $q = "select * from networking where cCode=\"{$_REQUEST['cCode']}\""; $networkData = sqlEx($q); if (mysql_num_rows($networkData)) { $networkData = mysql_fetch_assoc($networkData); echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo " \n"; echo " \n"; echo " \n"; // ====== Networked Devices switch ($_REQUEST['srt']) { case "all": case "name": $sortOrd = "device_name,device_mfg,device_model"; $captionExtra = " (by device name)"; break; case "mfg": $sortOrd = "device_mfg,device_model,device_name"; $captionExtra = " (by make and model)"; break; default: $sortOrd = "device_ip,device_port"; $captionExtra = " (by control port)"; break; } $q = "select * from networkdevice where cCode='{$_REQUEST['cCode']}' and device_name != ''"; if ($_REQUEST['srt'] != "all") $q .= " and integrate != ''"; $q .= " order by $sortOrd"; echo "\n"; $deviceList = sqlEx($q); $deviceCnt = mysql_num_rows($deviceList); if ($deviceCnt) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } // ====== Other Devices switch ($_REQUEST['srt']) { case "all": case "name": $sortOrd = "equip_name,equip_mfg,equip_mo,equip_sn"; $captionExtra = " (by device name)"; break; case "mfg": $sortOrd = "equip_mfg,equip_mo,equip_sn,equip_name"; $captionExtra = " (by make and model)"; break; default: $sortOrd = "equip_ctl_port,equip_ctl_type,equip_name"; $captionExtra = " (by control connection)"; break; } // $q = "select * from equipment where cCode='{$_REQUEST['cCode']}' and equip_name != '' order by equip_ctl_type,equip_ctl_port,equip_name,equip_mfg,equip_mo,equip_sn"; $q = "select * from equipment where cCode='{$_REQUEST['cCode']}' and equip_name != ''"; if ($_REQUEST['srt'] != "all") $q .= " and equip_integrate != ''"; $q .= " order by $sortOrd"; $equipmentList = sqlEx($q); $equipmentCount = mysql_num_rows($equipmentList); if ($equipmentCount) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } ?>

Equipment and Integration Report for ".getClientNameByCode($_REQUEST['cCode'])."

Network

\n"; echo "\n"; if (!empty($networkData['modem_mfg']) or !empty($networkData['modem_mo'])) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (empty($networkData['router_mfg']) and empty($networkData['router_mo'])) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo " \n"; } echo " \n"; if (!empty($networkData['router_mfg']) or !empty($networkData['router_mo'])) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (empty($networkData['modem_mfg']) and empty($networkData['modem_mo'])) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; } } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (!empty($networkData['ddns_url'])) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo " Modem: {$networkData['modem_mfg']} Model: {$networkData['modem_mo']} SSID: {$networkData['ssid']} Passcode: {$networkData['wl_key']} Router: {$networkData['router_mfg']} Model: {$networkData['router_mo']} SSID: {$networkData['ssid']} Passcode: {$networkData['wl_key']} WAN IP: {$networkData['wan_ip']} Gateway: {$networkData['lan_gateway']} Username: {$networkData['router_user']} Password: {$networkData['router_pass']} DDNS: {$networkData['ddns_url']} Provider: {$networkData['ddns_provider']} Username: {$networkData['ddns_user']} Password: {$networkData['ddns_pass']} \n"; echo "

Networked Equipment

\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($device = mysql_fetch_assoc($deviceList)) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (!empty($device['device_notes'])) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; } } echo " Mfg Model IP[Type] MAC Port(s) Connectivity {$device['device_name']} {$device['device_mfg']} {$device['device_model']} {$device['device_ip']}"; if (!empty($device['device_ip_type'])) echo " [{$device['device_ip_type']}]"; echo " {$device['device_mac']} {$device['device_port']} {$device['device_connectivity']} {$device['device_notes']} \n"; echo "

Un-Networked Equipment $captionExtra

\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($equipment = mysql_fetch_assoc($equipmentList)) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (!empty($equipment['equip_notes'])) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; } } echo " Mfg Model Control[Port] Connectivitiy Code Compatibility {$equipment['equip_name']} {$equipment['equip_mfg']} {$equipment['equip_mo']} {$equipment['equip_ctl_type']}"; if (!empty($equipment['equip_ctl_port'])) echo " [{$equipment['equip_ctl_port']}]"; echo " {$equipment['equip_connection']} {$equipment['equip_code_set']} {$equipment['equip_notes']} \n"; echo "