| | @@ -328,11 +328,11 @@ |
| 328 | 328 | zTitle = db_text(0, "SELECT title FROM reportfmt " |
| 329 | 329 | "WHERE rn=%d", rn); |
| 330 | 330 | if( zTitle==0 ) cgi_redirect("reportlist"); |
| 331 | 331 | |
| 332 | 332 | style_header("Are You Sure?"); |
| 333 | | - @ <form action="rptedit" method="POST"> |
| 333 | + @ <form action="rptedit" method="post"> |
| 334 | 334 | @ <p>You are about to delete all traces of the report |
| 335 | 335 | @ <strong>%h(zTitle)</strong> from |
| 336 | 336 | @ the database. This is an irreversible operation. All records |
| 337 | 337 | @ related to this report will be removed and cannot be recovered.</p> |
| 338 | 338 | @ |
| | @@ -399,24 +399,24 @@ |
| 399 | 399 | } |
| 400 | 400 | style_header(rn>0 ? "Edit Report Format":"Create New Report Format"); |
| 401 | 401 | if( zErr ){ |
| 402 | 402 | @ <blockquote><font color="#ff0000"><b>%h(zErr)</b></font></blockquote> |
| 403 | 403 | } |
| 404 | | - @ <form action="rptedit" method="POST"> |
| 405 | | - @ <input type="hidden" name="rn" value="%d(rn)"> |
| 404 | + @ <form action="rptedit" method="post"><div> |
| 405 | + @ <input type="hidden" name="rn" value="%d(rn)" /> |
| 406 | 406 | @ <p>Report Title:<br /> |
| 407 | | - @ <input type="text" name="t" value="%h(zTitle)" size="60"></p> |
| 407 | + @ <input type="text" name="t" value="%h(zTitle)" size="60" /></p> |
| 408 | 408 | @ <p>Enter a complete SQL query statement against the "TICKET" table:<br /> |
| 409 | 409 | @ <textarea name="s" rows="20" cols="80">%h(zSQL)</textarea> |
| 410 | 410 | @ </p> |
| 411 | 411 | login_insert_csrf_secret(); |
| 412 | 412 | if( g.okAdmin ){ |
| 413 | 413 | @ <p>Report owner: |
| 414 | | - @ <input type="text" name="w" size="20" value="%h(zOwner)"> |
| 414 | + @ <input type="text" name="w" size="20" value="%h(zOwner)" /> |
| 415 | 415 | @ </p> |
| 416 | 416 | } else { |
| 417 | | - @ <input type="hidden" name="w" value="%h(zOwner)"> |
| 417 | + @ <input type="hidden" name="w" value="%h(zOwner)" /> |
| 418 | 418 | } |
| 419 | 419 | @ <p>Enter an optional color key in the following box. (If blank, no |
| 420 | 420 | @ color key is displayed.) Each line contains the text for a single |
| 421 | 421 | @ entry in the key. The first token of each line is the background |
| 422 | 422 | @ color for that line.<br /> |
| | @@ -428,15 +428,15 @@ |
| 428 | 428 | @ </form> |
| 429 | 429 | report_format_hints(); |
| 430 | 430 | style_footer(); |
| 431 | 431 | return; |
| 432 | 432 | } |
| 433 | | - @ <input type="submit" value="Apply Changes"> |
| 433 | + @ <input type="submit" value="Apply Changes" /> |
| 434 | 434 | if( rn>0 ){ |
| 435 | | - @ <input type="submit" value="Delete This Report" name="del1"> |
| 435 | + @ <input type="submit" value="Delete This Report" name="del1" /> |
| 436 | 436 | } |
| 437 | | - @ </form> |
| 437 | + @ </div></form> |
| 438 | 438 | report_format_hints(); |
| 439 | 439 | style_footer(); |
| 440 | 440 | } |
| 441 | 441 | |
| 442 | 442 | /* |
| | @@ -478,17 +478,17 @@ |
| 478 | 478 | @ <p>In this example, the first column in the result set is named |
| 479 | 479 | @ "bgcolor". The value of this column is not displayed. Instead, it |
| 480 | 480 | @ selects the background color of each row based on the TICKET.STATUS |
| 481 | 481 | @ field of the database. The color key at the right shows the various |
| 482 | 482 | @ color codes.</p> |
| 483 | | - @ <table align="right" style="margin: 0 5px;" border=1 cellspacing=0 width=125> |
| 484 | | - @ <tr bgcolor="#f2dcdc"><td align="center">new or active</td></tr> |
| 485 | | - @ <tr bgcolor="#e8e8bd"><td align="center">review</td></tr> |
| 486 | | - @ <tr bgcolor="#cfe8bd"><td align="center">fixed</td></tr> |
| 487 | | - @ <tr bgcolor="#bde5d6"><td align="center">tested</td></tr> |
| 488 | | - @ <tr bgcolor="#cacae5"><td align="center">defer</td></tr> |
| 489 | | - @ <tr bgcolor="#c8c8c8"><td align="center">closed</td></tr> |
| 483 | + @ <table class="rpteditex"> |
| 484 | + @ <tr style="background-color:#f2dcdc;"><td class="rpteditex">new or active</td></tr> |
| 485 | + @ <tr style="background-color:#e8e8bd;"><td class="rpteditex">review</td></tr> |
| 486 | + @ <tr style="background-color:#cfe8bd;"><td class="rpteditex">fixed</td></tr> |
| 487 | + @ <tr style="background-color:#bde5d6;"><td class="rpteditex">tested</td></tr> |
| 488 | + @ <tr style="background-color:#cacae5;"><td class="rpteditex">defer</td></tr> |
| 489 | + @ <tr style="background-color:#c8c8c8;"><td class="rpteditex">closed</td></tr> |
| 490 | 490 | @ </table> |
| 491 | 491 | @ <blockquote><pre> |
| 492 | 492 | @ SELECT |
| 493 | 493 | @ CASE WHEN status IN ('new','active') THEN '#f2dcdc' |
| 494 | 494 | @ WHEN status='review' THEN '#e8e8bd' |
| | @@ -510,16 +510,16 @@ |
| 510 | 510 | @ FROM ticket |
| 511 | 511 | @ </pre></blockquote> |
| 512 | 512 | @ <p>To base the background color on the TICKET.PRIORITY or |
| 513 | 513 | @ TICKET.SEVERITY fields, substitute the following code for the |
| 514 | 514 | @ first column of the query:</p> |
| 515 | | - @ <table align="right" style="margin: 0 5px;" border=1 cellspacing=0 width=125> |
| 516 | | - @ <tr bgcolor="#f2dcdc"><td align="center">1</td></tr> |
| 517 | | - @ <tr bgcolor="#e8e8bd"><td align="center">2</td></tr> |
| 518 | | - @ <tr bgcolor="#cfe8bd"><td align="center">3</td></tr> |
| 519 | | - @ <tr bgcolor="#cacae5"><td align="center">4</td></tr> |
| 520 | | - @ <tr bgcolor="#c8c8c8"><td align="center">5</td></tr> |
| 515 | + @ <table class="rpteditex"> |
| 516 | + @ <tr style="background-color:#f2dcdc;"><td class="rpteditex">1</td></tr> |
| 517 | + @ <tr style="background-color:#e8e8bd;"><td class="rpteditex">2</td></tr> |
| 518 | + @ <tr style="background-color:#cfe8bd;"><td class="rpteditex">3</td></tr> |
| 519 | + @ <tr style="background-color:#cacae5;"><td class="rpteditex">4</td></tr> |
| 520 | + @ <tr style="background-color:#c8c8c8;"><td class="rpteditex">5</td></tr> |
| 521 | 521 | @ </table> |
| 522 | 522 | @ <blockquote><pre> |
| 523 | 523 | @ SELECT |
| 524 | 524 | @ CASE priority WHEN 1 THEN '#f2dcdc' |
| 525 | 525 | @ WHEN 2 THEN '#e8e8bd' |
| 526 | 526 | |