269 lines
11 KiB
PHP
269 lines
11 KiB
PHP
<?php
|
|
include("../items.php");
|
|
|
|
|
|
//West AVG time query
|
|
|
|
$con=mysqli_connect('192.168.0.9', 'corey', '41945549', 'controls');
|
|
$query="SELECT DATE FROM plc GROUP BY totsouth DESC LIMIT 10";
|
|
$result=mysqli_query($con, $query);
|
|
|
|
$westtime = [];
|
|
|
|
while ($row=mysqli_fetch_array($result, MYSQLI_ASSOC)) {
|
|
array_push($westtime, date(strtotime($row['DATE'])));
|
|
}
|
|
$westavg=date('i:s', ($westtime[0]-$westtime[9])/10);
|
|
|
|
//West2 AVG time query
|
|
|
|
$query="SELECT DATE FROM plc GROUP BY totwest2 DESC LIMIT 10";
|
|
$result=mysqli_query($con, $query);
|
|
|
|
$west2time = [];
|
|
|
|
while ($row=mysqli_fetch_array($result, MYSQLI_ASSOC)) {
|
|
array_push($west2time, date(strtotime($row['DATE'])));
|
|
}
|
|
$west2avg=date('i:s', ($west2time[0]-$west2time[9])/10);
|
|
|
|
//East AVG time query
|
|
|
|
$query="SELECT DATE FROM plc GROUP BY totnorth DESC LIMIT 10";
|
|
$result=mysqli_query($con, $query);
|
|
|
|
$easttime = [];
|
|
|
|
while ($row=mysqli_fetch_array($result, MYSQLI_ASSOC)) {
|
|
array_push($easttime, date(strtotime($row['DATE'])));
|
|
}
|
|
$eastavg=date('i:s', ($easttime[0]-$easttime[9])/10);
|
|
|
|
mysqli_close($con);
|
|
?>
|
|
|
|
<div>
|
|
|
|
<table width="100%" border="1" cellspacing="0" cellpadding="2">
|
|
|
|
<tr>
|
|
<td colspan="3" id="title">Scale Data</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td id="vtitle">Cane In Today:</td>
|
|
<td id="sum-count"><?php include("tonsin.php");?></td>
|
|
<td id="vtitle">Tons</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Cane In Yesterday:</td>
|
|
<td id="sum-count"><?php include("tonsinprev.php");?></td>
|
|
<td id="vtitle">Tons</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">YTD Cane Total Tons:</td>
|
|
<td id="sum-count"><?php include("tonsintot.php");?></td>
|
|
<td id="vtitle">Tons</td>
|
|
<tr>
|
|
<td colspan="3" id="title">Overview</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Live Steam Pressure:</td>
|
|
<td id="sum-count"><?php echo $value['PT_001']; ?></td>
|
|
<td id="vtitle">PSI</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Exhaust Pressure:</td>
|
|
<td id="sum-count"><?php echo $roundedid['00302']; ?></td>
|
|
<td id="vtitle">PSI</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Exhaust Pressure At Pan 9:</td>
|
|
<td id="sum-count"><?php echo $value['PAN9 EXST']; ?></td>
|
|
<td id="vtitle">PSI</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Vapor Pressure at Pan 8:</td>
|
|
<td id="sum-count"><?php echo $ID['00532']; ?></td>
|
|
<td id="vtitle">PSI</td>
|
|
</tr>
|
|
<td id="vtitle" id="padded">Pan 8 Level:</a></td>
|
|
<td id="sum-count"><?php echo $value['PAN8 LVL']; ?></td>
|
|
<td id="vtitle">%</a></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Vapor Header Pressure:</a></td>
|
|
<td id="sum-count"><?php echo $value['VAPOR HDR PRES']; ?></td>
|
|
<td id="vtitle">PSI</a></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">New Evap Vapor Valve:</a></td>
|
|
<td id="sum-count"><?php echo $value['35kVaporValve']; ?></td>
|
|
<td id="vtitle">%</a></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Final Molasses Temp:</a></td>
|
|
<td id="sum-count"><?php echo $value['FinalMolTemp']; ?></td>
|
|
<td id="vtitle">F</a></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Cold Water Inj Temp:</a></td>
|
|
<td id="sum-count"><?php echo $value['Cold Water Injection']; ?></td>
|
|
<td id="vtitle">F</a></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Hot Water Inj Temp:</a></td>
|
|
<td id="sum-count"><?php echo $value['Hot Water Injection']; ?></td>
|
|
<td id="vtitle">F</a></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">City Water Pressure:</a></td>
|
|
<td id="sum-count"><?php echo $value['CityWaterPressure']; ?></td>
|
|
<td id="vtitle">PSI</a></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">House Air Pressure:</a></td>
|
|
<td id="sum-count"><?php echo $value['HouseAirPressure']; ?></td>
|
|
<td id="vtitle">PSI</a></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="3" id="title">Tank Levels</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Juice Tank 1 Level:</td>
|
|
<td colspan="2" ><progress id="progresstanks" data-label="<?php echo $value['Juice Tank1']; ?>%" max="100" value="<?php echo $value['Juice Tank1']; ?>"></progress></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Juice Tank 2 Level:</td>
|
|
<td colspan="2" align="left"><progress id="progresstanks" data-label="<?php echo $value['Juice Tank2']; ?>%" max="100" value="<?php echo $value['Juice Tank2']; ?>"></progress></td
|
|
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Syrup RCVR Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['Syrup RCVR']; ?>%" max="100" value="<?php echo $value['Syrup RCVR']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Syrup Overflow Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['Syrup Overflow Lvl']; ?>%" max="100" value="<?php echo $value['Syrup Overflow Lvl']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Total Syrup Level:</a></td>
|
|
<td colspan="3"><progress id="progresstanks" data-label="<?php echo round(($value['Syrup Overflow Lvl']*.82569)+($value['Syrup RCVR']*.17431),0); ?>%" max="100" value="<?php echo round(($value['Syrup Overflow Lvl']*.82569)+($value['Syrup RCVR']*.17431),0); ?>"></meter></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">A1 Molasses RCVR Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['A1 RCVR']; ?>%" max="100" value="<?php echo $value['A1 RCVR']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">A1 Molasses Overflow Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['A1 Molasses Overflow Lvl']; ?>%" max="100" value="<?php echo $value['A1 Molasses Overflow Lvl']; ?>"></progress</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">A2 Molasses RCVR Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['A2 RCVR']; ?>%" max="100" value="<?php echo $value['A2 RCVR']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">A2 Molasses Overflow Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['A2 Molasses Overflow Lvl']; ?>%" max="100" value="<?php echo $value['A2 Molasses Overflow Lvl']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">B Molasses RCVR Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['B RCVR']; ?>%" max="100" value="<?php echo $value['B RCVR']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">B Molasses Overflow Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['B Molasses Overflow Lvl']; ?>%" max="100" value="<?php echo $value['B Molasses Overflow Lvl']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Condensate Water Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['CondensateWater']; ?>%" max="100" value="<?php echo $value['CondensateWater']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Sweetwater Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['SweetwaterTank']; ?>%" max="100" value="<?php echo $value['SweetwaterTank']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Cold Water Inj Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['Cold Water Injection LVL']; ?>%" max="100" value="<?php echo $value['Cold Water Injection LVL']; ?>"></progress></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Flash Tank Level:</a></td>
|
|
<td colspan="2"><progress id="progresstanks" data-label="<?php echo $value['FlashTankLVL']; ?>%" max="100" value="<?php echo $value['FlashTankLVL']; ?>"></progress></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="3" id="title">East Truck Dump</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">24hr Total Dumps:</a></td>
|
|
<td id="sum-count"colspan="2"><?php echo $value['24hrnorth']; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">YTD Total Dumps:</a></td>
|
|
<td id="sum-count" colspan="2"><?php echo $value['totnorth']; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Time Since Last Dump:</a></td>
|
|
<td id="sum-count" colspan="2"><?php include("sincen.php");?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Average Between Last 10 Dumps</a></td>
|
|
<td id="sum-count" colspan="2"><?php echo $eastavg; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Time Between Dumps:</a></td>
|
|
<td id="sum-count" colspan="2"><?php include("dumptimen.php");?></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="3" id="title"> West Truck Dump 1</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">24hr Total Dumps:</a></td>
|
|
<td id="sum-count" colspan="2"><?php echo $value['24hrsouth']; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">YTD Total Dumps:</a></td>
|
|
<td id="sum-count" colspan="2"><?php echo $value['totsouth']; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Time Since Last Dump:</a></td>
|
|
<td id="sum-count" colspan="2"><?php include("sinces.php");?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Average Between Last 10 Dumps</a></td>
|
|
<td id="sum-count" colspan="2"><?php echo $westavg; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Time Between Dumps:</a></td>
|
|
<td id="sum-count" colspan="2"><?php include("dumptimes.php");?></td>
|
|
</tr><tr>
|
|
<td colspan="3" id="title"> West Truck Dump 2</td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">24hr Total Dumps:</a></td>
|
|
<td id="sum-count" colspan="2"><?php echo $value['24hrwest2']; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">YTD Total Dumps:</a></td>
|
|
<td id="sum-count" colspan="2"><?php echo $value['totwest2']; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Time Since Last Dump:</a></td>
|
|
<td id="sum-count" colspan="2"><?php include("sincew2.php");?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Average Between Last 10 Dumps</a></td>
|
|
<td id="sum-count" colspan="2"><?php echo $west2avg; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td id="vtitle" id="padded">Time Between Dumps:</a></td>
|
|
<td id="sum-count" colspan="2"><?php include("dumptimew2.php");?></td>
|
|
</tr>
|
|
|
|
|
|
</table>
|
|
|
|
</div>
|