-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtask_list.php
152 lines (148 loc) · 5.84 KB
/
task_list.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
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php include'db_connect.php' ?>
<div class="col-lg-12">
<div class="card card-outline card-success">
<div class="card-header">
<div class="card-tools">
<a class="btn btn-block btn-sm btn-default btn-flat border-primary" href="./index.php?page=new_project"><i class="fa fa-plus"></i> Add New project</a>
</div>
</div>
<div class="card-body">
<table class="table tabe-hover table-condensed" id="list">
<colgroup>
<col width="5%">
<col width="15%">
<col width="20%">
<col width="15%">
<col width="15%">
<col width="10%">
<col width="10%">
<col width="10%">
</colgroup>
<thead>
<tr>
<th class="text-center">#</th>
<th>Project</th>
<th>Task</th>
<th>Project Started</th>
<th>Project Due Date</th>
<th>Project Status</th>
<th>Task Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$where = "";
if($_SESSION['login_type'] == 2){
$where = " where p.manager_id = '{$_SESSION['login_id']}' ";
}elseif($_SESSION['login_type'] == 3){
$where = " where concat('[',REPLACE(p.user_ids,',','],['),']') LIKE '%[{$_SESSION['login_id']}]%' ";
}
$stat = array("Pending","Started","On-Progress","On-Hold","Over Due","Done");
$qry = $conn->query("SELECT t.*,p.name as pname,p.start_date,p.status as pstatus, p.end_date,p.id as pid FROM task_list t inner join project_list p on p.id = t.project_id $where order by p.name asc");
while($row= $qry->fetch_assoc()):
$trans = get_html_translation_table(HTML_ENTITIES,ENT_QUOTES);
unset($trans["\""], $trans["<"], $trans[">"], $trans["<h2"]);
$desc = strtr(html_entity_decode($row['description']),$trans);
$desc=str_replace(array("<li>","</li>"), array("",", "), $desc);
$tprog = $conn->query("SELECT * FROM task_list where project_id = {$row['pid']}")->num_rows;
$cprog = $conn->query("SELECT * FROM task_list where project_id = {$row['pid']} and status = 3")->num_rows;
$prog = $tprog > 0 ? ($cprog/$tprog) * 100 : 0;
$prog = $prog > 0 ? number_format($prog,2) : $prog;
$prod = $conn->query("SELECT * FROM user_productivity where project_id = {$row['pid']}")->num_rows;
if($row['pstatus'] == 0 && strtotime(date('Y-m-d')) >= strtotime($row['start_date'])):
if($prod > 0 || $cprog > 0)
$row['pstatus'] = 2;
else
$row['pstatus'] = 1;
elseif($row['pstatus'] == 0 && strtotime(date('Y-m-d')) > strtotime($row['end_date'])):
$row['pstatus'] = 4;
endif;
?>
<tr>
<td class="text-center"><?php echo $i++ ?></td>
<td>
<p><b><?php echo ucwords($row['pname']) ?></b></p>
</td>
<td>
<p><b><?php echo ucwords($row['task']) ?></b></p>
<p class="truncate"><?php echo strip_tags($desc) ?></p>
</td>
<td><b><?php echo date("M d, Y",strtotime($row['start_date'])) ?></b></td>
<td><b><?php echo date("M d, Y",strtotime($row['end_date'])) ?></b></td>
<td class="text-center">
<?php
if($stat[$row['pstatus']] =='Pending'){
echo "<span class='badge badge-secondary'>{$stat[$row['pstatus']]}</span>";
}elseif($stat[$row['pstatus']] =='Started'){
echo "<span class='badge badge-primary'>{$stat[$row['pstatus']]}</span>";
}elseif($stat[$row['pstatus']] =='On-Progress'){
echo "<span class='badge badge-info'>{$stat[$row['pstatus']]}</span>";
}elseif($stat[$row['pstatus']] =='On-Hold'){
echo "<span class='badge badge-warning'>{$stat[$row['pstatus']]}</span>";
}elseif($stat[$row['pstatus']] =='Over Due'){
echo "<span class='badge badge-danger'>{$stat[$row['pstatus']]}</span>";
}elseif($stat[$row['pstatus']] =='Done'){
echo "<span class='badge badge-success'>{$stat[$row['pstatus']]}</span>";
}
?>
</td>
<td>
<?php
if($row['status'] == 1){
echo "<span class='badge badge-secondary'>Pending</span>";
}elseif($row['status'] == 2){
echo "<span class='badge badge-primary'>On-Progress</span>";
}elseif($row['status'] == 3){
echo "<span class='badge badge-success'>Done</span>";
}
?>
</td>
<td class="text-center">
<button type="button" class="btn btn-default btn-sm btn-flat border-info wave-effect text-info dropdown-toggle" data-toggle="dropdown" aria-expanded="true">
Action
</button>
<div class="dropdown-menu" style="">
<a class="dropdown-item new_productivity" data-pid = '<?php echo $row['pid'] ?>' data-tid = '<?php echo $row['id'] ?>' data-task = '<?php echo ucwords($row['task']) ?>' href="javascript:void(0)">Add Productivity</a>
</div>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
</div>
</div>
<style>
table p{
margin: unset !important;
}
table td{
vertical-align: middle !important
}
</style>
<script>
$(document).ready(function(){
$('#list').dataTable()
$('.new_productivity').click(function(){
uni_modal("<i class='fa fa-plus'></i> New Progress for: "+$(this).attr('data-task'),"manage_progress.php?pid="+$(this).attr('data-pid')+"&tid="+$(this).attr('data-tid'),'large')
})
})
function delete_project($id){
start_load()
$.ajax({
url:'ajax.php?action=delete_project',
method:'POST',
data:{id:$id},
success:function(resp){
if(resp==1){
alert_toast("Data successfully deleted",'success')
setTimeout(function(){
location.reload()
},1500)
}
}
})
}
</script>