30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
#endif
/*
** WEBPAGE: reportlist
**
** Main menu for Tickets.
*/
void view_list(void){
const char *zScript;
Blob ril; /* Report Item List */
Stmt q;
int rn = 0;
int cnt = 0;
login_check_credentials();
|
|
|
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
#endif
/*
** WEBPAGE: reportlist
**
** Main menu for Tickets.
*/
void reportlist_page(void){
const char *zScript;
Blob ril; /* Report Item List */
Stmt q;
int rn = 0;
int cnt = 0;
login_check_credentials();
|
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
|
/*
** WEBPAGE: rptsql
** URL: /rptsql?rn=N
**
** Display the SQL query used to generate a ticket report. The rn=N
** query parameter identifies the specific report number to be displayed.
*/
void view_see_sql(void){
int rn;
const char *zTitle;
const char *zSQL;
const char *zOwner;
const char *zClrKey;
Stmt q;
|
|
|
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
|
/*
** WEBPAGE: rptsql
** URL: /rptsql?rn=N
**
** Display the SQL query used to generate a ticket report. The rn=N
** query parameter identifies the specific report number to be displayed.
*/
void rptsql_page(void){
int rn;
const char *zTitle;
const char *zSQL;
const char *zOwner;
const char *zClrKey;
Stmt q;
|
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
|
**
** rn=N Ticket report number. (required)
** t=TITLE Title of the report format
** w=USER Owner of the report format
** s=SQL SQL text used to implement the report
** k=KEY Color key
*/
void view_edit(void){
int rn;
const char *zTitle;
const char *z;
const char *zOwner;
const char *zClrKey;
char *zSQL;
char *zErr = 0;
|
|
|
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
|
**
** rn=N Ticket report number. (required)
** t=TITLE Title of the report format
** w=USER Owner of the report format
** s=SQL SQL text used to implement the report
** k=KEY Color key
*/
void rptedit_page(void){
int rn;
const char *zTitle;
const char *z;
const char *zOwner;
const char *zClrKey;
char *zSQL;
char *zErr = 0;
|