diff options
| author | ivan <ivan> | 2008-03-27 20:40:43 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2008-03-27 20:40:43 +0000 |
| commit | 2c38085c11751a8c5f69e57b821a2ecbbce8f60d (patch) | |
| tree | cda142991206bbbd6b7099b9aec612e900797ba2 | |
| parent | 8d029daaa89e10b9a3e320cccfaad14714e19581 (diff) | |
add back raw SQL query (it had an appropriate ACL)
| -rw-r--r-- | httemplate/elements/menu.html | 2 | ||||
| -rw-r--r-- | httemplate/search/report_sql.html | 23 |
2 files changed, 25 insertions, 0 deletions
diff --git a/httemplate/elements/menu.html b/httemplate/elements/menu.html index 0c74746b7..047671ae5 100644 --- a/httemplate/elements/menu.html +++ b/httemplate/elements/menu.html @@ -213,6 +213,8 @@ $report_menu{'Billing events'} = [ \%report_bill_event, 'Billing events' ] if $curuser->access_right('Billing event reports'); $report_menu{'Financial'} = [ \%report_financial, 'Financial reports' ] if $curuser->access_right('Financial reports'); +$report_menu{'SQL Query'} = [ $fsurl.'search/report_sql.html', 'SQL Query' ] + if $curuser->access_right('Raw SQL'); tie my %tools_importing, 'Tie::IxHash', 'Import customers from CSV file' => [ $fsurl.'misc/cust_main-import.cgi', '' ], diff --git a/httemplate/search/report_sql.html b/httemplate/search/report_sql.html new file mode 100644 index 000000000..995330894 --- /dev/null +++ b/httemplate/search/report_sql.html @@ -0,0 +1,23 @@ +<% include('/elements/header.html', 'SQL Query' ) %> + +<FORM ACTION="sql.html" METHOD="GET"> + +<TABLE BGCOLOR="#cccccc" CELLSPACING=0> + <TR> + <TD ALIGN="right" VALIGN="top">SELECT </TD> + <TD><TEXTAREA NAME="sql"></TEXTAREA></TD> + </TR> +</TABLE> + +<BR> +<INPUT TYPE="submit" VALUE="Query"> + +</FORM> + +<% include('/elements/footer.html') %> +<%init> + +die "access denied" + unless $FS::CurrentUser::CurrentUser->access_right('Raw SQL'); + +</%init> |