48 lines
1.6 KiB
Batchfile
48 lines
1.6 KiB
Batchfile
@echo off
|
|
|
|
:MAIN
|
|
echo ^<html^>
|
|
echo ^<head^>
|
|
echo ^<title^>Color Profile Report^</title^>
|
|
echo ^<meta http-equiv="Content-Type" content="text/html; charset=utf-8"^>
|
|
echo ^<style type="text/css"^>
|
|
echo table {
|
|
echo border-collapse: separate;
|
|
echo border-spacing: 1px;
|
|
echo position: static;
|
|
echo }
|
|
echo th {
|
|
echo background-color: #5182bb;
|
|
echo color: #fff;
|
|
echo border: 1px solid #5182bb;
|
|
echo padding: 5px 10px;
|
|
echo font-size: 14px;
|
|
echo font-family: Consolas;
|
|
echo font-weight: bold;
|
|
echo text-align: left;
|
|
echo }
|
|
echo tr {
|
|
echo border: 1px solid #5182bb;
|
|
echo }
|
|
echo td {
|
|
echo color: #000;
|
|
echo padding: 5px 10px;
|
|
echo font-size: 14px;
|
|
echo font-family: Consolas;
|
|
echo }
|
|
echo ^</style^>
|
|
echo ^</head^>
|
|
echo ^<body^>
|
|
echo ^<table^>
|
|
echo ^<tr^>^<th^>SN^</th^>^<th^>File Name^</th^>^<th^>Remote Size^</th^>^<th^>Local Size^</th^>^<th^>MD5 Hash^</th^>^<th^>Collect Time^</th^>^<th^>Zip Test^</th^>^<th^>Transfer Size^</th^>^</tr^>
|
|
|
|
for /f "tokens=1-8 delims=," %%a in ('mysql -B -s -h 10.60.230.5 -uwcqte -ptest1234 -e "SELECT CONCAT_WS(',',sn,filename,remotesize,localsize,filehash,colltime,ziptest,xfersize) FROM lnvlog.colorlog WHERE sn='%USN%' ORDER BY seqnum ASC;"') do (
|
|
echo ^<tr^>^<td^>%%a^</td^>^<td^>%%b^</td^>^<td^>%%c^</td^>^<td^>%%d^</td^>^<td^>%%e^</td^>^<td^>%%f^</td^>^<td^>%%g^</td^>^<td^>%%h^</td^>^</tr^>
|
|
)
|
|
|
|
echo ^</table^>
|
|
echo ^</body^>
|
|
echo ^</html^>
|
|
|
|
:END
|