igroups/edit_budget.php at master · iit-ideashop/igroups · 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
<?php
	include_once('globals.php');
	include_once('checklogin.php');

	$s_userid = $_SESSION['userID'];
	$s_selectedGroup = $_SESSION['selectedGroup'];
	$s_selectedGroupType = $_SESSION['selectedGroupType'];
	$s_selectedSemester = $_SESSION['selectedSemester'];
	$s_selectedCategory = $_GET['bOrder'];
	$s_selectedDesc = $_GET['bDesc'];

	//------Start of Code for Form Processing-----------------------//

	if(isset($_POST['submit_edit_budget']))
	{
		$new_budget_amt = $_POST['budget_revised_amt'];
		$new_budget_desc = $_POST['edit_budget'];
		$s_selectedCategory = $_POST['budget_category'];
		$s_selectedCategoryName = $_POST['budget_category_name'];

		//Insert old record in history
		$query = $db->query("INSERT INTO BudgetsHistory(iProjectID, iSemesterID, bCategory, bRequested, bApproved, bDesc, bStatus, bOrder, bRequestedDate, bApprovedDate) SELECT iProjectID, iSemesterID, bCategory, bRequested, bApproved, bDesc, bStatus, bOrder, bRequestedDate, bApprovedDate FROM Budgets WHERE iProjectID=$s_selectedGroup AND iSemesterID=$s_selectedSemester AND bOrder=$s_selectedCategory AND bStatus='Completed'");

		//Update record w/ revised info
		$query = $db->query("UPDATE Budgets SET bDesc='$new_budget_desc', bRequested=$new_budget_amt, bStatus='Pending', bRequestedDate=now() WHERE iProjectID=$s_selectedGroup AND iSemesterID=$s_selectedSemester AND bOrder=$s_selectedCategory");


		//Send Automatic Email
		$msg = "This is an auto-generated $appname notification to let you know that ". $currentGroup->getName() ." team has made changes in the budget category: $s_selectedCategoryName.\n\n";
		$msg .= "--- $appname System Auto-Generated Massage";
		$headers = "From: \"$appname Support\" <$contactemail>\n";

		$headers .= 'To: jacobius@iit.edu';
		$headers .= "\nContent-Type: text/plain;\n";
		$headers .= "Content-Transfer-Encoding: 7bit;\n";
		mail('', $currentGroup->getName() .' revised the budget category ' .$s_selectedCategoryName.'', $msg, $headers);

		//Redirect to Budget Main Page
		header('Location: budget.php');
	}

	//------End of Code for Form Processing-------------------------//
	//------Start XHTML Output--------------------------------------//

	require('doctype.php');
	require('appearance.php');
	echo "<link rel=\"stylesheet\" href=\"skins/$skin/default.css\" type=\"text/css\" title=\"$skin\" />\n";
	foreach($altskins as $altskin)
		echo "<link rel=\"alternate stylesheet\" href=\"skins/$altskin/default.css\" type=\"text/css\" title=\"$altskin\" />\n";
?>
<title><?php echo $appname; ?> - Budget</title>
</head>
<body>
<?php
	require('sidebar.php');
	echo "<div id=\"content\"><div id=\"topbanner\">{$currentGroup->getName()}</div>\n";
	$query = $db->query("SELECT bDesc, bCategory, bRequested from Budgets WHERE iProjectID=$s_selectedGroup AND iSemesterID=$s_selectedSemester AND bOrder=$s_selectedCategory");
	$result = mysql_fetch_row($query);

	echo "Editing budget category: <strong>{$result[1]}</strong>\n";
?>

	<form method="post" name="edit_budget_desc" id="edit_budget_desc" action="edit_budget.php"><fieldset>
	<h3><label for="budget_revised_amt">Amount:</label></h3>
	$ <input type="text" id="budget_revised_amt" name="budget_revised_amt" value="<?php echo $result[2] ?>" size="5" />
	<h3>Description:</h3>
	<textarea id="edit_budget" name="edit_budget" cols="50" rows="20"><?php echo htmlspecialchars($result[0]) ?></textarea>
	<input type="hidden" id="budget_category" name="budget_category" value="<?php echo $s_selectedCategory ?>" />
	<input type="hidden" id="budget_category_name" name="budget_category_name" value="<?php echo $result[1] ?>" />
		<input type="submit" id="submit_edit_budget" value="Edit" name="submit_edit_budget" />
	</fieldset></form>
</div></body></html>