-
Notifications
You must be signed in to change notification settings - Fork 0
/
statusupdate_dev.php
134 lines (101 loc) · 3.12 KB
/
statusupdate_dev.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
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
<?php
include "header.php";
$taskid=$_REQUEST['taskid'];
$sql=mysql_query("select * from tasks where task_id='$taskid'");
while($row=mysql_fetch_array($sql))
{
$admin=$row[1];
$description=$row['description'];
$assigned_to=$row['assigned_to'];
$start_date=$row['start_date'];
$end_date= $row['end_date'];
$priority=$row['priority'];
$assigned_by1=$row['assigned_by'];
}
$assigned_by=substr($assigned_by1,0,4);
$q = "select * from admin where first_name like '%". $assigned_by."%' ";
//echo $q;
$query=mysql_query("select * from admin where first_name like '%". $assigned_by."%' ");
$q1=mysql_fetch_array($query);
$to = $q1['email']. ",developer@ccbst.ca";
$first_name = $q1['first_name'];
//echo $student_id;
//echo $myusername;
$today=date("Y-m-d");
if(isset($_POST['submit']))
{
$newstatus=$_POST['status'];
$admin2=$_POST['pwd'];
$sql=mysql_query("update tasks set status='$newstatus',`temporary_status_date`='$today' where task_id='$taskid'");
$to = "developer@ccbst.ca,kris@ccbst.ca";
$subject = $myusername;
$subject .= " updated task status on PM tool";
$message="Hi ";
$message .= $first_name;
$message .= ",
";
$message .= "\r\n";
$message .= $myusername;
$message .= " had changed a task status to ";
$message .= $newstatus;
$message .= ".\r\n";
$message .= ".\r\n";
$message .= "=============================================";
$message .= ".\r\n";
$message .= "Task assigned was:";
$message .= $description;
$message .= "\r\n";
$message .= "Start Date: ";
$message .= $start_date;
$message .= ".\r\n";
$message .= "End Date: ";
$message .= $end_date;
$message .= ".\r\n";
$message .= "Task Priority: ";
$message .= $priority;
$message .= ".\r\n";
date_default_timezone_set("America/New_York");
$message .= "Task completed on: ";
$message .= date("Y-m-d") ;
//$message .= echo ' ';
$message .= " ";
$message .= date("h:i:sa");
$message .= ".\r\n";
$message .= "=============================================";
$message .= ".\r\n";
$message .= "If the task is not completed yet please change the status to open again.Please let us know if you are unable to do so.";
$message .= "=============================================";
$message .= ".\r\n";
$message .= ".\r\n";
$message .= "Please open following link to view more details:";
$message .= "\r\n";
$message .= "http://projecttracker.ccbst.info/";
$headers = 'From: pmtool@ccbst.info' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
//mail($to,$subject,$message,$headers);
header('location:my_view.php');
}
?>
<form action="#" enctype="multipart/form-data" method="post">
<table align="center" >
<td>
SELECT STATUS:
</td>
<td><select name="status">
<option name="open" value="open">Open</option>
<option name="onhold" value="onhold">OnHold</option>
<option name="completed" value="completed">Completed Successfully</option>
<option name="cancelled" value="cancelled">Cancelled</option>
</select>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="submit" name="submit" />
</td>
</tr>
</form>
</table>
<?php
include "footer.php";
?>