-
Notifications
You must be signed in to change notification settings - Fork 1
/
grant_access_sys.php
76 lines (65 loc) · 2.59 KB
/
grant_access_sys.php
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
<?php
session_start();
include 'dbh.php';
$counter=mysqli_real_escape_string($conn,$_POST['counter']);
$year=mysqli_real_escape_string($conn,$_POST['year']);
$form=mysqli_real_escape_string($conn,$_POST['form']);
$facultyId=mysqli_real_escape_string($conn,$_POST['facultyId']);
// echo $year.','.$form.','.$facultyId;
if($form=='A')
{
//set entry to 0 in subit_for_review table if present
$sql="SELECT id FROM submitted_for_review_table WHERE facultyId='$facultyId' AND year='$year'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)!=0)
{
$sql2="UPDATE submitted_for_review_table SET partA=0 WHERE facultyId='$facultyId' AND year='$year'";
$result2=mysqli_query($conn,$sql2);
//remove entry from summary table
$sqlxx="SELECT id FROM summary_table WHERE year='$year' AND facultyId='$facultyId'";
$resultxx=mysqli_query($conn,$sqlxx);
if(mysqli_num_rows($resultxx)==0)
{
$sqlx="DELETE FROM summary_table WHERE year='$year' AND facultyId='$facultyId'";
$resultx=mysqli_query($conn, $sqlx);
}
}
//set entry to 0 in self appraisal if present
$sql="SELECT id FROM submitted_for_self_appraisal WHERE facultyId='$facultyId' AND year='$year'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)!=0)
{
$sql2="UPDATE submitted_for_self_appraisal SET partA=0 WHERE facultyId='$facultyId' AND year='$year'";
$result2=mysqli_query($conn,$sql2);
}
}
else if($form=='B')
{
//set entry to 0 in subit_for_review table if present
$sql="SELECT id FROM submitted_for_review_table WHERE facultyId='$facultyId' AND year='$year'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)!=0)
{
$sql2="UPDATE submitted_for_review_table SET partB=0 WHERE facultyId='$facultyId' AND year='$year'";
$result2=mysqli_query($conn,$sql2);
//remove entry from summary table
$sqlxx="SELECT id FROM summary_table WHERE year='$year' AND facultyId='$facultyId'";
$resultxx=mysqli_query($conn,$sqlxx);
if(mysqli_num_rows($resultxx)==0)
{
$sqlx="DELETE FROM summary_table WHERE year='$year' AND facultyId='$facultyId'";
$resultx=mysqli_query($conn, $sqlx);
}
}
//set entry to 0 in self appraisal if present
$sql="SELECT id FROM submitted_for_self_appraisal WHERE facultyId='$facultyId' AND year='$year'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)!=0)
{
$sql2="UPDATE submitted_for_self_appraisal SET partB=0 WHERE facultyId='$facultyId' AND year='$year'";
$result2=mysqli_query($conn,$sql2);
}
}
$sql3="DELETE FROM request_edit_access WHERE facultyId='$facultyId' AND year='$year' AND form='$form'";
$result3=mysqli_query($conn,$sql3);
echo $counter;