source: trunk/tools/database/sample.kSqlHtml@ 2783

Last change on this file since 2783 was 2765, checked in by bird, 26 years ago

Some new reports.
General bugfixes and new features.
File size: 9.6 KB
Line 
1<!-- $Id: sample.kSqlHtml,v 1.2 2000-02-12 17:55:04 bird Exp $
2 --
3 -- kSqlHTML Template Sample.
4 --
5 -- Copyright (c) 1999-2000 knut st. osmundsen (knut.stange.osmundsen@pmsc.no)
6 --
7 -- Project Odin Software License can be found in LICENSE.TXT
8 -->
9
10<!kTemplate filename="odin32ImplementationStatus.html"><HTML>
11<Title>Odin32 Implementation Status</Title>
12<BODY>
13<CENTER><H1>Odin32 Implementation Status</H1></CENTER>
14<!kSql sql="SELECT CURDATE() AS currentdate">
15<CENTER><H2>- $(currentdate) -</H2></CENTER>
16</!kSql>
17
18<!-- Content -->
19<H3><A NAME="$TotalContent"><A HREF="#TotalsBody">Project Totals</A></A></H3>
20
21<!-- Currently we'll skip the API Groups -->
22<!kSql sql="SELECT
23 TRIM(SUBSTRING('dll apigroup author', refcode, 11)) AS tablename,
24 TRIM(SUBSTRING('Dlls API Groups Authors', refcode, 11)) AS title,
25 TRIM(SUBSTRING('name refcode refcode', refcode, 11)) AS fileidfield
26 FROM function
27 WHERE refcode IN (1,23) ORDER BY refcode">
28<H3><A NAME="$(Title)Content"><A HREF="#$(Title)Body">$(Title)</A></A></H3>
29<UL>
30<!kSql sql="SELECT name,
31 $(fileidfield) AS fileid
32 FROM $(tablename)
33 ORDER BY name">
34 <li><A HREF="#$(name)">$(name)</A> <A HREF="odin32$(tablename)$(fileid).html">(details)</A><!/kSql>
35</UL>
36<!/kSql>
37
38
39<!-- Body -->
40<!-- Project Totals -->
41<HR>
42<CENTER><A NAME="TotalsBody"><A HREF="#TotalsContent"><H1>Project Totals</H1></A></A></CENTER>
43
44<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
45 <THEAD> <TR VALIGN=TOP> <TH>State</TH> <TH>Percent</TH> <TH>Count</TH> </TR> </THEAD>
46 <TBODY>
47 <!kSql sql="SELECT count(*) AS totalcount
48 FROM function"
49 ><!kSql sql="SELECT refcode AS currentstate,
50 name AS statedesc,
51 0 AS percent,
52 0 AS count
53 FROM state
54 ORDER BY refcode"
55 ><!kSql sql="SELECT count(*) AS count,
56 ROUND(count(*)*100 / $(totalcount), 1) AS percent
57 FROM function
58 WHERE state = $(currentstate)"
59 ><TR>
60 <TD><P ALIGN=LEFT>$(statedesc)<P></TD>
61 <TD><P ALIGN=RIGHT>$(percent)%<P></TD>
62 <TD><P ALIGN=RIGHT>$(count)<P></TD>
63 </TR><!/kSql><!/kSql>
64 <TR>
65 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
66 <TD><P ALIGN=RIGHT>100.0%<P></TD>
67 <TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
68 </TR><!/kSql>
69 </TBODY>
70</TABLE>
71<!-- Graph -->
72
73
74<!-- DLL -->
75<HR>
76<CENTER><A NAME="Dllsbody"><A HREF="#Dllscontent"><H1>Dlls</H1></A></A></CENTER>
77
78<!kSql sql="SELECT name AS grpname,
79 refcode AS grprefcode,
80 name AS fileid
81 FROM dll ORDER BY name">
82<A NAME="$(grpname)"><H3>$(grpname) <A HREF="odin32Dll$(fileid).html">(details)</A></H3></A>
83<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
84 <THEAD> <TR VALIGN=TOP> <TH>State</TH> <TH>Percent</TH> <TH>Count</TH> </TR> </THEAD>
85 <TBODY>
86 <!kSql sql="SELECT count(*) AS totalcount
87 FROM function
88 WHERE dll = $(grprefcode)"
89 ><!kSql sql="SELECT refcode AS currentstate,
90 name AS statedesc,
91 color AS statecolor,
92 0 AS percent,
93 0 AS count
94 FROM state
95 ORDER BY refcode"
96 ><!kSql sql="SELECT count(*) AS count,
97 ROUND(count(*)*100 / $(totalcount), 1) AS percent
98 FROM function
99 WHERE dll = $(grprefcode)
100 AND state = $(currentstate)"
101 ><TR>
102 <TD><FONT COLOR="$(statecolor)"><P ALIGN=LEFT>$(statedesc)<P></TD>
103 <TD><P ALIGN=RIGHT>$(percent)%<P></TD>
104 <TD><P ALIGN=RIGHT>$(count)<P></FONT></TD>
105 </TR><!/kSql><!/kSql>
106 <TR>
107 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
108 <TD><P ALIGN=RIGHT>100.0%<P></TD>
109 <TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
110 </TR><!/kSql>
111 </TBODY>
112</TABLE>
113
114<!-- TODO graph TODO -->
115</p><p>
116<!kGraph filename="odin32Dll$(fileid).gif"
117 type=lines cx=400 cy=300
118 data="SELECT date, count, s.color, s.name
119 FROM historydll hd, state s
120 WHERE hd.state = s.refcode AND hd.dll = $(grprefcode)"
121 title="$(grpname)"
122 >
123<IMAGE SRC="odin32Dll$(fileid).gif">
124</p><p>
125<!/kSql>
126
127<!-- Currently we'll skip the API Groups -->
128
129<HR>
130<!-- Author -->
131<CENTER><A NAME="AuthorsBody"><A HREF="#AuthorsContent"><H1>Authors</H1></A></A></CENTER>
132
133<!kSql sql="SELECT name AS grpname,
134 refcode AS grprefcode,
135 refcode AS fileid
136 FROM author ORDER BY name">
137<A NAME="$(grpname)"><H3>$(grpname) <A HREF="odin32Author$(fileid).html">(details)</A></H3></A>
138
139<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
140 <THEAD> <TR VALIGN=TOP> <TH>State</TH> <TH>Percent</TH> <TH>Count</TH> </TR> </THEAD>
141 <TBODY>
142 <!kSql sql="SELECT count(*) AS totalcount
143 FROM fnauthor
144 WHERE author = $(grprefcode)"
145 ><!kSql sql="SELECT refcode AS currentstate,
146 name AS statedesc,
147 0 AS percent,
148 0 AS count
149 FROM state
150 ORDER BY refcode"
151 ><!kSql sql="SELECT count(*) AS count,
152 ROUND(count(*)*100 / $(totalcount), 1) AS percent
153 FROM fnauthor fa, function fn
154 WHERE fa.function = fn.refcode
155 AND fa.author = $(grprefcode)
156 AND fn.state = $(currentstate)"
157 ><TR>
158 <TD><P ALIGN=LEFT>$(statedesc)<P></TD>
159 <TD><P ALIGN=RIGHT>$(percent)%<P></TD>
160 <TD><P ALIGN=RIGHT>$(count)<P></TD>
161 </TR><!/kSql><!/kSql>
162 <TR>
163 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
164 <TD><P ALIGN=RIGHT>100.0%<P></TD>
165 <TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
166 </TR><!/kSql>
167 </TBODY>
168</TABLE>
169<!/kSql>
170<!/kSql>
171
172</BODY>
173</HTML>
174
175<!-- End of File -->
176<!kSql sql="SELECT refcode AS dllrefcode,
177 name AS dllname,
178 'xxxx' AS ordinal,
179 'no functions' AS functionname,
180 'xxxx' AS statename
181 FROM dll
182 ORDER BY name">
183<!kTemplate filename="odin32Dll$(dllname).html">
184<HTML>
185<TITLE>Details on APIs in $(dllname)</TITLE>
186<BODY>
187<H1>Details on APIs in $(dllname)</H1>
188<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
189 <THEAD>
190 <TR VALIGN=TOP> <TH>Ordinal</TH> <TH>API name</TH> <TH>State</TH> </TR>
191 </THEAD>
192 <TBODY>
193 <!kSql sql="SELECT ordinal,
194 function.name AS functionname,
195 state.name AS statename
196 FROM function, state
197 WHERE state.refcode = state
198 AND dll = $(dllrefcode)"
199 ><TR>
200 <TD><P ALIGN=RIGHT>$(ordinal)<P></TD>
201 <TD><P ALIGN=LEFT>$(functionname)<P></TD>
202 <TD><P ALIGN=LEFT>$(statename)<P></TD>
203 </TR><!/kSql>
204 <TR>
205 <TD><P ALIGN=RIGHT>xxxx<P></TD>
206 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
207 <!kSql sql="SELECT COUNT(*) AS totalcount
208 FROM function
209 WHERE dll = $(dllrefcode)"
210 ><TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
211 <!/kSql>
212 </TR>
213 </TBODY>
214</TABLE>
215</BODY>
216</HTML>
217<!/kSql>
218
219
220<!-- End of File -->
221<!kSql sql="SELECT refcode AS authorrefcode,
222 name AS authorname,
223 'xxxx' AS ordinal,
224 'no dll' AS dllname,
225 'no functions' AS functionname,
226 'xxxx' AS statename
227 FROM author
228 ORDER BY name">
229<!kTemplate filename="odin32Author$(authorrefcode).html">
230<HTML>
231<TITLE>Details on APIs written by $(authorname)</TITLE>
232<BODY>
233<H1>Details on APIs written by $(authorname)</H1>
234<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
235 <THEAD>
236 <TR VALIGN=TOP> <TH>Ordinal</TH> <TH>API name</TH> <TH>State</TH> </TR>
237 </THEAD>
238 <TBODY>
239 <!kSql sql="SELECT ordinal,
240 fn.name AS functionname,
241 s.name AS statename,
242 d.name AS dllname
243 FROM fnauthor fa, function fn, state s, dll d
244 WHERE fa.author = $(authorrefcode)
245 AND fa.function = fn.refcode
246 AND s.refcode = fn.state
247 AND fn.dll = d.refcode
248 ORDER BY dllname, functionname"
249 ><TR>
250 <TD><P ALIGN=RIGHT>$(ordinal)<P></TD>
251 <TD><P ALIGN=RIGHT>$(dllname)<P></TD>
252 <TD><P ALIGN=LEFT>$(functionname)<P></TD>
253 <TD><P ALIGN=LEFT>$(statename)<P></TD>
254 </TR><!/kSql>
255 <TR>
256 <TD><P ALIGN=RIGHT>xxxx<P></TD>
257 <TD><P ALIGN=RIGHT>xxxx<P></TD>
258 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
259 <!kSql sql="SELECT COUNT(*) AS totalcount
260 FROM fnauthor
261 WHERE author = $(authorrefcode)"
262 ><TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
263 <!/kSql>
264 </TR>
265 </TBODY>
266</TABLE>
267</BODY>
268</HTML>
269<!/kSql>
270
271
272
Note: See TracBrowser for help on using the repository browser.