forked from smuwanga/ViralLoad
/
tpl.reports.contracts.review.recommendations.php
83 lines (83 loc) · 4.39 KB
/
tpl.reports.contracts.review.recommendations.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
<?
//security check
if(!$GLOBALS['vlDC'] || !$_SESSION["VLEMAIL"]) {
die("<font face=arial size=2>You must be logged in to view this page.</font>");
}
?>
<table width="100%" border="0" class="vl">
<tr>
<td class="toplinks" style="padding:0px 0px 10px 0px"><a class="toplinks" href="/dashboard/">HOME</a> <a class="toplinks" href="/reports/">REPORTS</a> <a class="toplinks" href="/reports/contracts.review.recommendations/">CONTRACTS BY REVIEW RECOMMENDATIONS</a></td>
</tr>
<tr>
<td style="padding: 5px 0px 15px 0px; border-bottom: 1px dashed #dfe6e6"><strong>Contracts by Review Recommendations</strong></td>
</tr>
<tr>
<td>
<table width="100%" border="0" class="vl">
<tr>
<td style="padding:10px 0px 0px 0px">
<div style="height: 250px; width: 100%; overflow: auto; padding:5px; border: 1px solid #d5e6cf">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="vl_tdsub" width="1%"><strong>#</strong></td>
<td class="vl_tdsub" width="94%"><strong> </strong></td>
<td class="vl_tdsub" width="5%"><strong>Totals</strong></td>
</tr>
<?
//contracts
$numContract=0;
$numContract=getDetailedTableInfo3("vl_contracts","id!=''","count(id)","num");
$numContract=number_format((float)$numContract);
?>
<tr onMouseover="this.bgColor='#f0e6dd'" onMouseout="this.bgColor='#FFFFFF'">
<td class="vl_tdstandard">1</td>
<td class="vl_tdstandard">All Contracts</td>
<td class="vl_tdstandard" align="center"><?=$numContract?></td>
</tr>
<?
//contracts
$numContract=0;
$numContract=getDetailedTableInfo3("vl_contracts,vl_contracts_reviews","vl_contracts.id=vl_contracts_reviews.contractID and
vl_contracts_reviews.reviewRecommendation='Proceed with Contract'","count(distinct vl_contracts.id)","num");
$numContract=number_format((float)$numContract);
?>
<tr onMouseover="this.bgColor='#f0e6dd'" onMouseout="this.bgColor='#FFFFFF'">
<td class="vl_tdstandard">2</td>
<td class="vl_tdstandard">Proceed with Contract</td>
<td class="vl_tdstandard" align="center"><?=$numContract?></td>
</tr>
<?
//contracts
$numContract=0;
$numContract=getDetailedTableInfo3("vl_contracts,vl_contracts_reviews","vl_contracts.id=vl_contracts_reviews.contractID and
vl_contracts_reviews.reviewRecommendation='Renew'","count(distinct vl_contracts.id)","num");
$numContract=number_format((float)$numContract);
?>
<tr onMouseover="this.bgColor='#f0e6dd'" onMouseout="this.bgColor='#FFFFFF'">
<td class="vl_tdstandard">3</td>
<td class="vl_tdstandard">Renew</td>
<td class="vl_tdstandard" align="center"><?=$numContract?></td>
</tr>
<?
//contracts
$numContract=0;
$numContract=getDetailedTableInfo3("vl_contracts,vl_contracts_reviews","vl_contracts.id=vl_contracts_reviews.contractID and
vl_contracts_reviews.reviewRecommendation='Terminate Immediately'","count(distinct vl_contracts.id)","num");
$numContract=number_format((float)$numContract);
?>
<tr onMouseover="this.bgColor='#f0e6dd'" onMouseout="this.bgColor='#FFFFFF'">
<td class="vl_tdnoborder">4</td>
<td class="vl_tdnoborder">Terminate Immediately</td>
<td class="vl_tdnoborder" align="center"><?=$numContract?></td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td style="padding:20px 0px 0px 0px"><a href="/reports/">Return to Reports</a> :: <a href="/dashboard/">Return to Dashboard</a></td>
</tr>
</table>
</td>
</tr>
</table>