File-Monitoring-System/ass_comm_delete.php at master · amonkats/File-Monitoring-System · 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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
<?php
   session_start();
   if (isset($_SESSION['user'])) {
      if ((time() - $_SESSION['last_time']) > 1200) {
         header("location:logout.php");
      }else{
         $_SESSION['last_time'] = time();
      }
   }else{
      header("Location:Index.php");
   }
?>

<!DOCTYPE html>
<html>
<head>
   <title>EDP&RD File Monitoring System</title>
   <!--<link rel="stylesheet" type="text/css" href="style.css">-->
</head>
<body style="text-align: center;">

 <img src="images/arms.jpg">
   <p id="republic">THE REPUBLIC OF UGANDA</p>
   <h1>EDP&RD FILE MONITORING SYSTEM</h1>
   <h2>MINISTRY OF FINANCE, PLANNING AND ECONOMIC DEVELOPMENT</h2>
   <h2>ECONOMIC DEVELOPMENT POLICY AND RESEARCH DEPARTMENT (EDP&RD)</h2>
      <!--<h3>TAX POLICY DEPARTMENT FILE SYSTEM (TPDFS)</h3>-->
<?php

      include ("hor_nav_ass_comm.php");

      if ($_SESSION['user'] == true) {
         echo "<i>You are logged in as "."<label style='text-decoration: underline;'><b>".$_SESSION['user']."</b></label></i>";
      }else{
         header("Location:Index.php");
      }

    ?>
    <br><br>


<section style="background: #142634; color: #fff;"><br>

   <?php

   $dbConnect = mysqli_connect('localhost', 'root', 'ak_94*jmv', 'edpr');

   $searchId = $_GET['searchId'];

   $search_Query = "SELECT serialno, refno, file_origin, subject FROM ass_comm_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM sec_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM pe_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM se_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e1_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e2_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e2_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e3_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM re1_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM re2_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM ra_psc_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM se1_dpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM se2_dpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e1_dpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e2_dpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM re_dpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM ra_dpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM se_mpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e1_mpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e2_mpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM e3_mpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM ge_mpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM re_mpa_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM h_psdu_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM sca_psdu_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM mrp_psdu_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM megd_psdu_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM me_psdu_edpr WHERE serialno='$searchId'";

   $search_Query .= "UNION SELECT serialno, refno, file_origin, subject FROM sec_psdu_edpr WHERE serialno='$searchId'";

    $search_result=mysqli_query($dbConnect, $search_Query);
    $row=mysqli_fetch_array($search_result);

?>

   <form action="" method="post">

      <input type="text" name="serialno" readonly="readonly" placeholder="Serial No" value="<?php echo $row[0];?>" style="width: 220px; height: 40px;">

     <input type="text" name="refno" readonly="readonly" placeholder="Ref No" value="<?php echo $row[1];?>" style="width: 220px; height: 40px;"><br><br>

     <!--<textarea type="text" cols="40" rows="6" placeholder="Origin" value="<?php //echo $row[2];?>" name="origin" style="width: 342px; height: 97px;"></textarea>-->

     <input type="text" name="origin" readonly="readonly" placeholder="Origin" value="<?php echo $row[2];?>" style="width: 220px; height: 40px;">

     <input type="text" name="subject" readonly="readonly" placeholder="Subject" value="<?php echo $row[3];?>" style="width: 220px; height: 40px;"><br><br>


    <!--<input type="text" name="status" required="required" placeholder="Status" value="<?php //echo $row[3];?>" style="width: 220px; height: 40px;"><br><br>-->

    <input type="submit" name="deletebtn" value="Delete" style="width: 185px; height: 45px;"><br><br>

   </form>

   <?php
   if(isset($_POST['deletebtn'])){
      include('ass_comm_deleted.php');
   }
?>

</section>
</body>
</html>