forked from joedanz/cf-project-tracker
-
Notifications
You must be signed in to change notification settings - Fork 0
/
allmilestones.cfm
126 lines (109 loc) · 4.05 KB
/
allmilestones.cfm
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
<cfsetting enablecfoutputonly="true">
<cfset projects = application.project.get(session.user.userid)>
<cfquery name="active_projects" dbtype="query">
select * from projects where status = 'Active'
</cfquery>
<cfquery name="onhold_projects" dbtype="query">
select * from projects where status = 'On-Hold'
</cfquery>
<cfquery name="arch_projects" dbtype="query">
select * from projects where status = 'Archived'
</cfquery>
<cfif not projects.recordCount>
<cfset QueryAddRow(projects)>
<cfset QuerySetCell(projects, "projectID", "0")>
</cfif>
<cfset visible_project_list = "">
<cfloop query="projects">
<cfif mstones gt 0>
<cfset visible_project_list = listAppend(visible_project_list,projectID)>
</cfif>
</cfloop>
<cfset milestones_overdue = application.milestone.get('','','overdue','',visible_project_list)>
<cfset milestones_upcoming = application.milestone.get('','','upcoming','',visible_project_list)>
<!--- Loads header/footer --->
<cfmodule template="#application.settings.mapping#/tags/layout.cfm" templatename="main" title="#application.settings.app_title# » Milestones">
<cfoutput>
<div id="container">
<!--- left column --->
<div class="left">
<div class="main">
<div class="header">
<h2 class="milestone">Milestones across all your projects</h2>
</div>
<div class="content">
<div class="wrapper">
<cfif milestones_overdue.recordCount or milestones_upcoming.recordCount>
<cfif milestones_overdue.recordCount>
<div class="mb5 b" style="color:##f00;border-bottom:1px solid ##f00;">Late Milestones</div>
<ul class="nobullet mb20">
<cfloop query="milestones_overdue">
<cfset daysago = DateDiff("d",dueDate,Now())>
<li><span class="b" style="color:##f00;"><cfif daysago eq 0>Today<cfelseif daysago eq 1>Yesterday<cfelse>#daysago# day ago</cfif>:</span>
<a href="milestone.cfm?p=#projectID#&m=#milestoneID#">#name#</a>
<span style="font-size:.9em;">(<a href="project.cfm?p=#projectID#" class="b">#projName#</a><cfif compare(lastName,'')> | #firstName# #lastName# is responsible</cfif>)</span>
</li>
</cfloop>
</ul>
</cfif>
<cfif milestones_upcoming.recordCount>
<div class="mb5 b" style="border-bottom:1px solid ##000;">Upcoming Milestones</div>
<ul class="nobullet mb20">
<cfloop query="milestones_upcoming">
<cfset daysago = DateDiff("d",Now(),dueDate)>
<li><span class="b"><cfif daysago eq 0>Tomorrow<cfelse>#daysago+1# day<cfif daysago neq 1>s</cfif> away</cfif>:</span>
<a href="milestones.cfm?p=#projectID#">#name#</a>
<span style="font-size:.9em;">(<a href="project.cfm?p=#projectID#" class="b">#projName#</a><cfif compare(lastName,'')> | #firstName# #lastName# is responsible</cfif>)</span>
</li>
</cfloop>
</ul>
</cfif>
<cfelse>
<div class="warn">No milestones have been added.</div>
</cfif>
</div>
</div>
</div>
<div class="bottom"> </div>
<div class="footer">
<cfinclude template="footer.cfm">
</div>
</div>
<!--- right column --->
<div class="right">
<h3><a href="editProject.cfm" class="add">Create a new project</a></h3><br />
<cfif active_projects.recordCount>
<div class="header"><h3>Your projects</h3></div>
<div class="content">
<ul>
<cfloop query="active_projects">
<li><a href="project.cfm?p=#projectID#">#name#</a></li>
</cfloop>
</ul>
</div>
</cfif>
<cfif onhold_projects.recordCount>
<div class="header"><h3>On-Hold projects</h3></div>
<div class="content">
<ul>
<cfloop query="onhold_projects">
<li><a href="project.cfm?p=#projectID#">#name#</a></li>
</cfloop>
</ul>
</div>
</cfif>
<cfif arch_projects.recordCount>
<div class="header"><h3>Archived projects</h3></div>
<div class="content">
<ul>
<cfloop query="arch_projects">
<li><a href="project.cfm?p=#projectID#">#name#</a></li>
</cfloop>
</ul>
</div>
</cfif>
</div>
</div>
</cfoutput>
</cfmodule>
<cfsetting enablecfoutputonly="false">