-
Notifications
You must be signed in to change notification settings - Fork 0
/
financial_report.php
98 lines (97 loc) · 4.06 KB
/
financial_report.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
<?php include 'db_connect.php' ?>
<div class="col-md-12">
<div class="card card-outline card-success">
<div class="card-header">
<b>Project Progress</b>
<div class="card-tools">
<button class="btn btn-flat btn-sm bg-gradient-success btn-success" id="print"><i class="fa fa-print"></i> Print</button>
</div>
</div>
<div class="card-body p-0">
<div class="table-responsive" id="printable">
<table class="table m-0 table-bordered">
<!-- <colgroup>
<col width="5%">
<col width="15%">
<col width="35%">
<col width="15%">
</colgroup> -->
<thead>
<th>#</th>
<th>Project</th>
<th>Description</th>
<th>Amount</th>
</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()):
$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;
$dur = $conn->query("SELECT sum(time_rendered) as duration FROM user_productivity where project_id = {$row['id']}");
$dur = $dur->num_rows > 0 ? $dur->fetch_assoc()['duration'] : 0;
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>
<td>
<?php echo $i++ ?>
</td>
<td>
<a>
<?php echo ucwords($row['name']) ?>
</a>
<br>
<small>
Due: <?php echo date("Y-m-d",strtotime($row['end_date'])) ?>
</small>
</td>
<td class="text-center">
<?php echo number_format($tprog) ?>
</td>
<td class="text-center">
<?php echo number_format($cprog) ?>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<script>
$('#print').click(function(){
start_load()
var _h = $('head').clone()
var _p = $('#printable').clone()
var _d = "<p class='text-center'><b>Project Progress Report as of (<?php echo date("F d, Y") ?>)</b></p>"
_p.prepend(_d)
_p.prepend(_h)
var nw = window.open("","","width=900,height=600")
nw.document.write(_p.html())
nw.document.close()
nw.print()
setTimeout(function(){
nw.close()
end_load()
},750)
})
</script>