40 lines
1.1 KiB
PHP
40 lines
1.1 KiB
PHP
<?php
|
|
include("../dbinfo.php");
|
|
|
|
$con=mysqli_connect($host,$username,$password,$database);
|
|
$query = "SELECT ROUND(
|
|
(((SELECT easttotground FROM easttotalground ORDER BY id DESC LIMIT 1) - (
|
|
SELECT easttotground FROM easttotalground ORDER BY id DESC LIMIT 299, 1))*(24
|
|
-
|
|
((SELECT TIME_TO_SEC(
|
|
TIMEDIFF(
|
|
CASE
|
|
WHEN CURRENT_TIME() < '5:00:00'
|
|
THEN ADDTIME(CURRENT_TIME(), '240000')
|
|
ELSE CURRENT_TIME() END,
|
|
'05:00:00'))/3600))))
|
|
+
|
|
(((SELECT westtotground FROM westtotalground ORDER BY id DESC LIMIT 1) - (
|
|
SELECT westtotground FROM westtotalground ORDER BY id DESC LIMIT 299, 1))*(24
|
|
-
|
|
((SELECT TIME_TO_SEC(
|
|
TIMEDIFF(
|
|
CASE
|
|
WHEN CURRENT_TIME() < '5:00:00'
|
|
THEN ADDTIME(CURRENT_TIME(), '240000')
|
|
ELSE CURRENT_TIME() END,
|
|
'05:00:00'))/3600)))))*12
|
|
+
|
|
(SELECT MillTotalGround FROM mill_total_ground ORDER BY id DESC LIMIT 1)
|
|
AS millprojected";
|
|
$result=mysqli_query($con,$query);
|
|
|
|
$include4=mysqli_fetch_array($result,MYSQLI_ASSOC);
|
|
|
|
mysqli_close($con);
|
|
?>
|
|
|
|
|
|
<?php echo round($include4['millprojected']); ?>
|
|
|