RTI_Automation/modify_queries.php at master · saloniBhartia/RTI_Automation · 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
<?php
session_start();
?>
<html>
<head>
	<title>Modified</title>
	<link rel="stylesheet" href="css/background.css">
	<meta charset="utf-8">
</head>

<body>
<?php
	include 'config_database.php';
	$id = $_POST['ID'];
	$d1=strtotime($_POST['date_of_receipt']);
	$d2=strtotime($_POST['date_of_receipt_cio']);
	$d3=floor(abs($d2-$d1)/86400);

	$data = "UPDATE add_rti SET
			name = '$_POST[name]',
			gender = '$_POST[gender]',
			address = '$_POST[address]',
			pin_code = '$_POST[pin_code]',
			state = '$_POST[state]',
			country = '$_POST[country]',
			phone_no = '$_POST[phone_no]',
			mobile = '$_POST[mobile]',
			email = '$_POST[email]',
			citizenship = '$_POST[citizenship]',
			date_of_receipt = '$_POST[date_of_receipt]',
			date_of_receipt_cio = '$_POST[date_of_receipt_cio]',
			timespan = '$d3',
			fee_enclosed = '$_POST[fee_enclosed]',
			fee_deposit_date = '$_POST[fee_deposit_date]',
			pay_mode = '$_POST[pay_mode]'
			WHERE id=".$id;

	if ($con->query($data) === TRUE) {
		echo "<b>Details of record updated successfully<b><br>";
	}
	else {
		echo "Error updating record: " . $con->error;
	}

if(isset($_POST['edit']))
{
	$data1="SELECT * FROM t2 WHERE id=".$id.";";
	$query=mysqli_query($con,$data1);
	$data2=mysqli_num_rows($query);

	$_SESSION['qu']= $data2;
	$a=$data2;

	echo "<table>
			<tbody>
				<tr>
					<th>Query No</th>
					<th>Query</th>
					<th>Map To</th>
					<th>Date Sent</th>
				</tr>";
	echo "<form action=save_modified_queries.php method=post>";
?>
<script type="text/javascript">
	function mailTo (q_no) {
		var a = "q_no"+q_no;
		var map = document.getElementById("map"+a);
		var no_select = "no_selection"+a;
		var selected = map.options[map.selectedIndex].value;
		if(no_select != selected){
			var mailid;
			if(selected == "Ac"){
				mailid = "academics@igdtuw.com";
			} else if(selected == "Ex"){
				mailid = "examination@igdtuw.com";
			} else if(selected == "Ad"){
				mailid = "administrative@igdtuw.com";
			} else{
				mailid = "humaresource@igdtuw.com";
			}
			var subject="Please Send reply to the query of RTI Id: "+ <?php echo $id; ?>;
			var ques = "ques"+a;
			var body="Query: " + document.getElementById(ques).value + " \ndated on:" + document.getElementById("date_s"+a).value;
			window.open('mailto:'+mailid+'?subject='+subject+'&body='+body);
		}
		else{
			alert("Please select department first");
		}
	}
</script>
<?php
	while( $a!=0)
	{
		$data3=mysqli_fetch_array($query);
		$qno="q_no".$a;
		$ques="ques".$a;
		$no_selection="no_selectio".$qno;
		$map="map".$a;
		$date_s="date_s".$a;
		$ques_id= "ques".$qno;
		$map_id= "map".$qno;
		$date_s_id= "date_s".$qno;
?>
		<tr>
			<th><input  value="<?php echo $data3['q_no']?>" type=text name=<?php echo $qno; ?>></th>
			<th><input type=text name=<?php echo $ques; ?> value="<?php echo $data3['ques'];?>" id=<?php echo $ques_id; ?>></th>
			<th><select name=<?php echo $map; ?> id=<?php echo $map_id; ?> >
					<span>
						<option value=<?php echo $no_selection; ?> <?php if(strcmp($data3['map'], "") == 0){ echo "selected=\"selected\""; }?> >--Select--</option>
						<option value=Ac <?php if(strcmp($data3['map'], "Ac") == 0){ echo "selected=\"selected\""; }?>>Academics</option>
						<option value=Ex <?php if(strcmp($data3['map'], "Ex") == 0){ echo "selected=\"selected\""; }?>>Examination Division</option>
						<option value=Ad <?php if(strcmp($data3['map'], "Ad") == 0){ echo "selected=\"selected\""; }?>>Administrative</option>
						<option value=HR <?php if(strcmp($data3['map'], "HR") == 0){ echo "selected=\"selected\""; }?>>Human Resource</option>
					</span>
				</select>
			</th>
			<th><input type=date name=<?php echo $date_s; ?> value="<?php echo $data3['date_sent'] ?>" id=<?php echo $date_s_id; ?> placeholder=YYYY-MM-DD></th>
			<th><button type="button" name="mail_button" onclick="mailTo(<?php echo $a; ?>);">Mail</button></th>
		</tr>
<?php
		$sql="DELETE FROM t2 WHERE id=".$id.";";
		mysqli_query($con,$sql);
		$a--;
	}
	echo "<th colspan=15></th><th><input type=submit name=save class=btn value='Save and Exit' ></th>";
	echo "<th colspan=15></th><th><input type=submit name=reply class=btn value='Generate Reply' ></th>";
	echo "</form>";
}
$con->close();

?>
</body>
</html>