Construction-Management/viewReport.php at master · shreyzo/Construction-Management · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php
include 'DatabaseConnection.php';
?>
<html>
  <head>
  <link rel="stylesheet" type="text/css" href="main.css">
</head>

<?php


$Name=$_POST['substructurename'];

$query1="select SubstructureID from newprojectschedule where Name='$Name' ";
$result1=mysqli_query($conn,$query1);

$row=mysqli_fetch_array($result1);
$id=$row['SubstructureID'];

$query2="select Overall_Progress from progressreport where SubstructureID='$id' ";
$result2=mysqli_query($conn,$query2);
$row2=mysqli_fetch_array($result2);
$pro=$row2['Overall_Progress'];


$query="select * from workreport where SubstructureID='$id' ";
$result=mysqli_query($conn,$query);

//calculating  progress
$result5 = mysqli_query($conn,$query);
$numerator = 0;
$denominator = 0;
$progress = 0;
if ($result5->num_rows > 0)
{
    // output data of each row
    while($row5 = $result5->fetch_assoc())
    {
        if($row5["ActualWork"]>0)
        {
            $numerator = $numerator + $row5["ActualWork"];
            $denominator = $denominator + $row5["IdealWork"];
        }
    }
    $progress = ($numerator/$denominator)*100;
}
else
{
    echo "0 results";
}
//Calculating progress done
echo "<div class='c'>";
//Progress bar color check
if($progress < 80)
{
    echo "<style> .c {background-color: red;}</style>";
    //background-color: #33cc00;
}
else
{
    echo "<style> .c {background-color: #33cc00;}</style>";
}
echo "Activity Progress - ". round($progress,2) ."%";
echo "</div>";


echo "<table border='1'>
<tr>
<th>Date</th>
<th>Scheduled Work</th>
<th>Actual Work</th>
<th>Lag</th>
</tr>
";
?>

<!-- Optimize Button and div -->

<button onclick="optimizebtn()"  >Click here to Optimize</button>
<div id="optimize" style="display:none;">
  <?php

  include 'calculations.php';?>
</div>
<script>
    function optimizebtn() {
      var x = document.getElementById("optimize");
      if (x.style.display === "none") {
        x.style.display = "block";

      } else {
        x.style.display = "none";
      }
    }
</script>


<?php

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
      echo "<tr>";
      echo "<td>" .  $row["Date"] ."</td>";
      echo "<td>" .  $row["IdealWork"] ."</td>";
      echo "<td>" .  $row["ActualWork"] ."</td>";
      echo "<td>" .  $row["Progress"] ."</td>";
      echo "</tr>";
    }
} else {
    echo "0 results";
}
?>
</html>