Code: Select all
==============================================================
^!g::
;Get title where SO is stored
WinGetTitle,Title,Comments - SO
;Strip all but SO #
StringTrimLeft,SONum,Title,15
;Download to temp file
UrlDownloadToFile,http://10.46.30.43/connInfo/search/%SONum%,%A_AppData%\temp.txt
;Read file contents into clipboard and paste
FileRead, Contents, %A_AppData%\temp.txt
if not ErrorLevel ; Successfully loaded.
{
clipboard = %Contents%
Send ^v
}
return
=========================================================
The PHP script to connect and run the SQL is as follows:
public function getDeviceInfo($strBiSrvLocNbr)
{
if (empty($strBiSrvLocNbr)) throw new Exception(__CLASS__.'->'.__FUNCTION__.'['.__LINE__.']: Service Location Number cannot be NULL');
$strSQL = sprintf
(
'SELECT
BIDTGR.BI_DVC_TYPE_GRP_DESC
,BIDS.BI_DVC_TYPE
,BIDR.BI_DVC_DESC
,BIDI.BI_DVC_STAT_CD
,BIDS.BI_X_COORD
,BIDS.BI_Y_COORD
FROM
BI_DVC_SRV BIDS
INNER JOIN
BI_DVC_INV BIDI ON BIDS.BI_DVC_SER_NBR = BIDI.BI_DVC_SER_NBR
INNER JOIN
BI_DVC_REF BIDR ON BIDI.BI_DVC_TYPE = BIDR.BI_DVC_TYPE
INNER JOIN
BI_DVC_TYPE_GRP_REF BIDTGR ON BIDR.BI_DVC_TYPE_GRP = BIDTGR.BI_DVC_TYPE_GRP
WHERE
BIDS.BI_SRV_LOC_NBR=\'%s\'
ORDER BY
BIDS.BI_DVC_TYPE DESC'
,Janitor::sanitizeString($strBiSrvLocNbr)
);
try
{
$stmt = $this->_objDatabase->query($strSQL);
if ($stmt === FALSE) return false;
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $results;
}
catch (Exception $e)
{
throw new Exception(__CLASS__.'->'.__FUNCTION__.' [' . __LINE__ . ']: Unable to get device information.', 0, $e);
}
}
The PHP that displays to the screen is as follows:
foreach ($aryDeviceInfo as $device)
{
$strBiDvcTypeGrpDesc = (!empty($device['BI_DVC_TYPE_GRP_DESC'])) ? $device['BI_DVC_TYPE_GRP_DESC'] : '';
$strBiDvcType = (!empty($device['BI_DVC_TYPE'])) ? $device['BI_DVC_TYPE'] : '';
$strBiDvcDesc = (!empty($device['BI_DVC_DESC'])) ? $device['BI_DVC_DESC'] : '';
$strBiDvcStatCd = (!empty($device['BI_DVC_STAT_CD'])) ? $device['BI_DVC_STAT_CD'] : '';
$strBiDvcXCoord = (!empty($device['BI_DVC_X_COORD'])) ? $device['BI_DVC_X_COORD'] : '';
$strBiDvcYCoord = (!empty($device['BI_DVC_Y_COORD'])) ? $device['BI_DVC_Y_COORD'] : '';
$strDeviceInformation .= sprintf
(
"Device Group: %s".PHP_EOL.
"Device Type: %s".PHP_EOL.
"Device Description: %s".PHP_EOL.
"Status: %s".PHP_EOL.
"X Coord: %s".PHP_EOL.
"Y Coord: %s".PHP_EOL,
$strBiDvcTypeGrpDesc,
$strBiDvcType,
$strBiDvcDesc,
$strBiDvcStatCd,
$strBiDvcXCoord,
$strBiDvcYCoord
);
Screen print:
==============================================
Device Info:
--------------------
Device Group: LED Lighting
Device Type: L50
Device Description: LED Outdoor Light 50W
Status: 1
X Coord:
Y Coord:
Srv Loc Nbr:
============================================
Moderator Note: Added code tags. ~sinkfaze