-
Notifications
You must be signed in to change notification settings - Fork 1
/
financial_list.php
122 lines (118 loc) · 4.7 KB
/
financial_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
<?php include'db_connect.php' ?>
<div class="col-lg-12">
<div class="card card-outline card-success">
<div class="card-header">
<?php if($_SESSION['login_type'] != 3): ?>
<div class="card-tools">
<a class="btn btn-block btn-sm btn-default btn-flat border-primary" href="./index.php?page=finance"><i class="fa fa-plus"></i>New Finance</a>
</div>
<?php endif; ?>
</div>
<div class="card-body">
<table class="table tabe-hover table-condensed" id="list">
<colgroup>
<col width="5%">
<col width="35%">
<col width="20%">
<col width="15%">
<col width="10%">
</colgroup>
<thead>
<tr>
<th class="text-center">#</th>
<th>Project</th>
<th>Description</th>
<th>Amount</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$stat = array("Pending","Started","On-Progress","On-Hold","Over Due","Done");
$where = "";
if($_SESSION['login_type'] == 2){
$where = " where manager_id = '{$_SESSION['login_id']}' ";
}elseif($_SESSION['login_type'] == 3){
$where = " where concat('[',REPLACE(user_ids,',','],['),']') LIKE '%[{$_SESSION['login_id']}]%' ";
}
$qry = $conn->query("SELECT * FROM project_list $where order by 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['id']}")->num_rows;
$cprog = $conn->query("SELECT * FROM task_list where project_id = {$row['id']} 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['id']}")->num_rows;
if($row['status'] == 0 && strtotime(date('Y-m-d')) >= strtotime($row['start_date'])):
if($prod > 0 || $cprog > 0)
$row['status'] = 2;
else
$row['status'] = 1;
elseif($row['status'] == 0 && strtotime(date('Y-m-d')) > strtotime($row['end_date'])):
$row['status'] = 4;
endif;
?>
<tr>
<th class="text-center"><?php echo $i++ ?></th>
<td>
<p><b><?php echo ucwords($row['name']) ?></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">
<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="">
<div class="dropdown-divider"></div>
<?php if($_SESSION['login_type'] != 3): ?>
<a class="dropdown-item" href="./index.php?page=edit_finance&id=<?php echo $row['id'] ?>">Edit</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item delete_project" href="javascript:void(0)" data-id="<?php echo $row['id'] ?>">Delete</a>
<?php endif; ?>
</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()
$('.delete_project').click(function(){
_conf("Are you sure to delete this project?","delete_project",[$(this).attr('data-id')])
})
})
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>